index

Package sb_curriculum_archive_strings

This package contains the error messages and error message functions for the Curriculum Archive API (sb curriculum archive).

Message NameError Message
INVALID_PIDMInvalid unique identifier (PIDM) for the archived curriculum
Unique identifier (PIDM) for the archived curriculum is not valid.
MISSING_CACT_CDECurriculum activity status code for the archived curriculum is missing
There is no curriculum activity status code value for the archived curriculum.
MISSING_COLL_CDECollege code for the archived curriculum is missing
There is no college code value for the archived curriculum.
MISSING_DATA_ORIGINData source for the archived curriculum is missing
There is no data source value for the archived curriculum.
MISSING_DEGC_CDEDegree code for the archived curriculum is missing
There is no degree code value for the archived curriculum.
MISSING_KEY_SEQNOKey sequence number for the archived curriculum is missing
There is no key sequence number for the archived curriculum.
MISSING_LEVL_CDELevel code for the archived curriculum is missing
There is no level code for the archived curriculum.
MISSING_LMOD_CDELearner module code for the archived curriculum is missing
Learner module code for the archived curriculum is missing.
MISSING_PIDMUnique identifier (PIDM) for the archived curriculum is missing
There is no unique identifier (PIDM) for the archived curriculum.
MISSING_PRIORITY_NOPriority number for the archived curriculum is missing
There is no priority number for the archived curriculum.
MISSING_ROLL_INDRoll indicator for the archived curriculum is missing
There is no roll indicator for the archived curriculum.
MISSING_SEQNOLearner curriculum sequence number for the archived curriculum is missing
There is no learner curriculum sequence number for the archived curriculum.
MISSING_TERM_CDETerm code for the archived curriculum is missing
There is no term code for the archived curriculum.
MISSING_USER_IDUser ID for the archived curriculum is missing
There is no user ID for the archived curriculum.
PK_NOT_FOUNDCannot find the curriculum archive record using the primary or unique key
Unable to locate the curriculum archive record using the primary or unique key.
P_DELETE_FAILEDCannot delete the curriculum archive because the record does not exist
The curriculum archive record cannot be deleted because the record does not exist.
RECORD_EXISTSCannot create curriculum archive record because the record already exists
Unable to create the curriculum archive record 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.