index

Package sb_transfer_crse_cmt_strings

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

Message NameError Message
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_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_EFFEffective transfer term code is missing
Effective transfer term code is missing. This field is required.
MISSING_PARENTParent record is missing
Parent record is missing. Parent record 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_EFFEffective transfer term code is not valid
Effective transfer term code is not valid.
INVALID_SEQNOSequence number is not valid
Sequence number is not valid.
INVALID_TEXTTransfer course comment text is not valid
Transfer course comment text is not valid.
P_DELETE_FAILEDCannot delete transfer course comment because the record does not exist
Cannot delete the transfer course comment record because it does not exist.
PK_NOT_FOUNDCannot find transfer course comment (SHRTCMT) record using the primary or unique key
Cannot find the transfer course comment record using the primary or unique key.
RECORD_EXISTSCannot create transfer course comment (SHRTCMT) because the record already exists
Cannot create the transfer course comment record because it already exists.


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.