index

Package sb_transfer_equiv_cmt_strings

Error messages and error message functions for the Transfer Equivalent Comments API (sb_transfer_equiv_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_SUBJ_CODE_INSTInstitution subject code is missing
Institution subject code is missing. This field is required.
MISSING_CRSE_NUMB_INSTInstitution course number is missing
Institution course number is missing. This field is required.
MISSING_SHRTATC_SEQNOSequence number associated with the equivalent course is missing
Sequence number associated with the equivalent course is missing. This field is required.
MISSING_PARENTEquivalent course parent record is missing
Equivalent course child record cannot be created because there is no parent record in the SHRTATC table.
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_SUBJ_CODE_INSTInstitution subject code is not valid
Institution subject code is not valid.
INVALID_CRSE_NUMB_INSTInstitution course number is not valid
Institution course number is not valid.
INVALID_SHRTATC_SEQNOSequence number associated with the equivalent course is not valid
Sequence number associated with the equivalent course is not valid.
INVALID_SEQNOSequence number associated with the comment is not valid
Sequence number associated with the comment is not valid.
INVALID_TEXTText of the comment is not valid
Text of the comment is not valid.
INVALID_GROUPGroup code is not valid
Group code is not valid.
P_DELETE_FAILEDCannot delete the comment (SHRICMT) because the record does not exist
Cannot delete the transfer course comment record because it does not exist.
PK_NOT_FOUNDCannot find the comment (SHRICMT) record using the primary or unique key
Cannot find the transfer course comment record using the primary or unique key.
RECORD_EXISTSCannot create the comment (SHRICMT) 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.