index

Package sb_athletic_degc_comp_strings

Error messages and error message functions for the Athletic Degree Completion API (sb_athletic_degc_comp).

Message KeyError Message
MISSING_PIDMUnique identifier (PIDM) is missing
Unique identifier (PIDM) is required for the athletic degree completion record and cannot be null.
MISSING_TERM_CODETerm code is missing
Term code is required for the athletic degree completion record and cannot be null.
MISSING_LEVL_CODEStudent level code is missing
Student level code is required for the athletic degree completion record and cannot be null.
MISSING_LCUR_SEQNOLearner curriculum sequence number is missing
Learner curriculum sequence number is required by the athletic degree completion and cannot be null.
MISSING_KEY_SEQNOKey sequence number is missing
Key sequence number is required by the athletic degree completion and cannot be null.
MISSING_USER_IDUser ID is missing
User ID is required by athletic degree completion and cannot be null.
INVALID_PIDMInvalid unique identifier (PIDM)
Unique identifier (PIDM) for the athletic degree completion record must be valid.
INVALID_TERM_CODEInvalid term code
Term code for the athletic degree completion record must exist on the STVTERM table.
INVALID_LEVL_CODEInvalid student level code
Student level code for the athletic degree completion record must exist on the STVLEVL table.
INVALID_LCUR_SEQNOInvalid learner curriculum sequence number
Learner curriculum sequence number for the athletic degree completion must exist for the PIDM on the SORLCUR table.
INVALID_KEY_SEQNOInvalid key sequence number
Key sequence number for the athletic degree completion is not valid.
INVALID_USER_IDInvalid User ID
User ID for the athletic degree completion record must be valid.
INVALID_REQUIRED_HOURSInvalid value for required hours
The number of hours required for degree completion record is not in a valid format.
INVALID_COMPLETED_HOURSInvalid value for completed hours
The number of hours completed toward the degree record is not in a valid format.
INVALID_DCPR_CODEInvalid degree completion percentage reason code
Degree completion percentage reason code for the athletic degree completion record must exist on the STVDCPR table.
INVALID_DATA_ORIGINInvalid data origin
Data origin for the athletic degree completion record is not valid.
P_DELETE_FAILEDCannot delete the record because it does not exist
Cannot delete the athletic degree completion record because it does not exist.
PK_NOT_FOUNDCannot find the record using the primary or unique key
Cannot find the athletic degree completion record using the primary or unique key.
RECORD_EXISTSCannot create a new record because the record already exists
The new athletic degree completion record cannot be created because the record already exists.


Program units
f_get_error   Returns the error message corresponding to p_errorname.

Variables
error_tab   Global PL/SQL table that holds the error messages.


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.