index

Package sb_curriculum_default_strings

This package contains the error messages and error message functions for Curriculum Default API (sb_curriculum_default).

Message NameError Message
INVALID_CAMP_CODECampus Code for the curriculum default is not valid
The campus code must exist in the STVCAMP validation table
INVALID_COLL_CODECollege Code for the curriculum default is not valid
The college code must exist in the STVCOLL validation table
INVALID_DEGC_CODEDegree Code for the curriculum default is not valid
The degree code must exist in the STVDEGC validation table
INVALID_DEPT_CODEDepartment Code for the curriculum default is not valid
The department code must exist in the STVDEPT validation table
INVALID_LEVL_CODELevel Code for the curriculum default is not valid
The level code must exist in the STVLEVL validation table
INVALID_LMOD_CODELearner Module Code for the curriculum default is not valid
The learner module code must exist in the STVLMOD validation table
INVALID_MAJR_CODEMajor Code for the curriculum default is not valid
The major code must exist in the STVMAJR validation table and have the major indicatory checked
INVALID_PROGRAMProgram for the curriculum default is not valid
The program must exist in the SMRPRLE table
MISSING_DATA_ORIGINThe Data Origin is missing and is required for the curriculum default
A data origin is required
MISSING_LMOD_CODEThe Learner Module Code is missing and is required for the curriculum default
The learner module code is required and cannot be left blank
MISSING_USER_IDThe User ID is missing and is required for the curriculum default
The User ID is required
PK_NOT_FOUNDCannot find the curriculum default record using the primary or unique key
A Curriculum Default with the User ID and specified Learner Module does not exist to update
P_DELETE_FAILEDCannot delete the curriculum default because the record does not exist
A Curriculum Default with the User ID and specified Learner Module does not exist to delete
RECORD_EXISTSCannot create curriculum default because the record already exists
A record already exists for the User ID and Learner Module Code


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.