index

Package sb_transfer_crse_strings

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

Message NameError Message
MISSING_SBGI_CODESource/background institution code is missing
Source/background institution code is missing. This field is required.
MISSING_PROGRAMDegree program is missing
Degree program is missing. This field is required.
MISSING_TLVL_CODELevel code is missing
Level code is missing. This field is required.
MISSING_SUBJ_CODE_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_TRNS_TITLETransfer course title is missing
Transfer course title is missing. This field is required.
MISSING_TAST_CODEStatus code is missing
Status code is missing. This field is required.
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_CODE_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_TRNS_TITLETransfer course title is not valid
Transfer course title is not valid.
INVALID_TRNS_LOW_HRSTransfer course low hours is not valid
Value for the transfer course low hours is not valid.
INVALID_TRNS_HIGH_HRSTransfer course high hours is not valid
Value for the transfer course high hours is not valid.
INVALID_TRNS_REVIEW_INDTransfer course review indicator is not valid
Value for the transfer course review indicator is not valid.
INVALID_TAST_CODEStatus code is not valid
Status code is not valid.
INVALID_TRNS_CATALOGTransfer source catalog is not valid
Value for the transfer source catalog is not valid.
INVALID_TGRD_CODE_MINMinimum transfer grade is not valid
Minimum transfer grade is not valid.
INVALID_GROUPGroup code is not valid
Group code is not valid.
INVALID_GROUP_PRIMARY_INDGroup primary indicator is not valid
Value for the group primary indicator is not valid.
INVALID_PROTECT_INDProtect from batch update indicator is not valid
Value for the protect from batch update indicator is not valid.
INVALID_CRSE_DESCCourse description is not valid
Course description is not valid.
INVALID_USER_IDUser ID is not valid
User ID is not valid.
INVALID_DATA_ORIGINData origin is not valid
Data origin is not valid.
P_DELETE_FAILEDCannot delete transfer course because the record does not exist
Cannot delete the transfer course record because it does not exist.
PK_NOT_FOUNDCannot find transfer course (SHBTATC) record using primary or unique key
Cannot find the transfer course record using the primary or unique key.
RECORD_EXISTSCannot create transfer course (SHBTATC) because the record already exists
Cannot create the transfer course record because it already exists.
P_CHILD_EXISTSCannot delete transfer course (SHBTATC) because a child record exists
Cannot delete the transfer course parent record because a child record exists in transfer course attributes.


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.