index

Package sb_transfer_crse_attr_strings

Error messages and error message functions for the Transfer Course Attribute API (sb_transfer_crse_attr).

Message KeyError Message
MISSING_PRIMARY_KEYPrimary key is missing
Primary key is missing. This field is required.
MISSING_SBGI_CODESource/background institution code is missing
Source/background institution code is missing. This field is required.
MISSING_PROGRAMDegree program code is missing
Degree program code is missing. This field is required.
MISSING_TLVL_CODELevel code is missing
Level code is missing. This field is required.
MISSING_SUBJ_CDE_TRNSTransfer subject code is missing
Transfer subject code is missing. This field is required.
MISSING_CRSE_NUMB_TRNSTransfer course number is missing
Transfer course number is missing. This field is required.
MISSING_TERM_CODE_EFF_TRNSEffective transfer term code is missing
Effective transfer term code is missing. This field is required.
MISSING_ATTR_CDEAttribute code is missing
Attribute code is missing. This field is required.
MISSING_ATTR_DESCAttribute description is missing
Attribute description is missing. This field is required.
MISSING_USER_IDUser ID is missing
User ID is missing. This field is required.
MISSING_PARENTParent record is missing
Cannot create the child transfer record because there is no parent record in the SHBTATC table.
INVALID_PRIMARY_KEYPrimary key is not valid
Primary key is not valid.
INVALID_SBGI_CODESource/background institution code is not valid
Source/background institution code is not valid.
INVALID_PROGRAMDegree program code is not valid
Degree program code is not valid.
INVALID_TLVL_CODELevel code is not valid
Level code is not valid.
INVALID_SUBJ_CDE_TRNSTransfer subject code is not valid
Transfer subject code is not valid.
INVALID_CRSE_NUMB_TRNSTransfer course number is not valid
Transfer course number is not valid.
INVALID_TERM_CODE_EFF_TRNSEffective transfer term code is not valid
Effective transfer term code is not valid.
INVALID_ATTR_CDEAttribute code is not valid
Attribute code is not valid.
INVALID_ATTR_DESCAttribute description is not valid
Attribute description is not valid.
INVALID_USER_IDUser ID is not valid
User ID is not valid.
INVALID_GROUPGroup code is not valid
Group code is not valid.
INVALID_DATA_ORIGINData origin is not valid
Data origin is not valid.
P_DELETE_FAILEDCannot delete transfer course attribute because the record does not exist
Cannot delete the transfer course attribute record because it does not exist.
PK_NOT_FOUNDCannot find transfer course attribute (SHRTCAT) record using primary or unique key
Cannot find the transfer course record using the primary or unique key.
RECORD_EXISTSCannot create transfer course attribute (SHRTCAT) because the record already exists
Cannot create the transfer course record because it already exists.
P_SEQUENCE_ERROROracle sequence error
Oracle sequence error occurred on the primary key of the transfer course attributes table.


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.