index

Package sb_fieldofstudy_allowed_str

This package contains the error messages and error message functions for the Field of Study Maximum Current and Active (sb_fieldofstudy_allowed).

Message NameError Message
INVALID_LFST_CODEInvalid value for field of study type code
Field of study type code does not exist in the table GTVLFST.
INVALID_LMOD_CODEInvalid value for learner module code
Learner module code does not exist in the table STVLMOD.
INVALID_MAJOR_ALLOWEDMajor field of study type must have allowed number greater than zero
Number allowed for major must be greater than zero.
INVALID_NEGATIVE_NUMBERField of study type must have a positive number allowed and non-major types can have zero allowed
Non-major field of study types must have zero or a positive number for allowed value.
INVALID_SYS_REQ_INDInvalid value for system required indicator, enter Y/N
System required indicator must be Y or N.
INVALID_TRAN_WEB_INDInvalid value for display on transcript indicator, enter Y/N
Display on transcript indicator must be Y or N.
MISSING_DATA_ORIGINMissing mandatory value for data origin
Missing data origin value.
MISSING_LFST_CODEMissing mandatory value for field of study type
Missing field of study type code.
MISSING_LMOD_CODEMissing mandatory value for learner module
Missing learner module code.
MISSING_MAX_NUMBERMissing mandatory value for maximum allowed
Missing number allowed value.
MISSING_SYS_REQ_INDMissing mandatory value for system required indicator
System required indicator cannot be null, must be Y or N.
MISSING_TRAN_WEB_INDMissing mandatory value for display on transcript indicator
Missing mandatory value for display on transcript indicator. Enter Y or N.
MISSING_USER_IDMissing mandatory value for user ID
User ID is required and missing.
PK_NOT_FOUNDCannot find record using primary or unique key
Cannot find a record with the specified learner module code and field of study type code.
P_DELETE_FAILEDCannot delete, record does not exist
Record does not exist.
RECORD_EXISTSCannot create, record already exists
Record for the specified learner module and field of study type already exists.
SYS_REQ_DELETE_RESTRICTIONDelete not allowed because record is system required
You can only delete records with a system required indicator of N.
SYS_REQ_UPDATE_RESTRICTIONUpdate to transcript display and system required not allowed because record is system required
You can only update the number allowed on records with a system required indicator of Y.


Program units
f_get_error  

Variables
error_tab  


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Global PL/SQL table that holds the error messages.


f_get_error

Function f_get_error(p_errorname VARCHAR2) RETURN gb_common_strings.err_type

Returns the error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.