index

Package sb_fieldofstudy_archive_str

This package contains the error messages and error message functions for the Field of Study API (sb_fieldofstudy_archive).

Message NameError Message
INVALID_PIDMInvalid unique identifier (PIDM) for the archived field of study
Unique identifier (PIDM) for the archived field of study is not valid.
MISSING_CACT_CDECurriculum activity status code for the archived field of study is missing
There is no curriculum activity status code for the archived field of study.
MISSING_CSTS_CDECurriculum status code for the archived field of study is missing
There is no curriculum activity status code for the archived field of study.
MISSING_DATA_ORIGINData source for the archived field of study is missing
There is no data source for the archived field of study.
MISSING_LCUR_SEQNOCurriculum sequence number for the archived field of study is missing
There is no curriculum sequence number for the archived field of study.
MISSING_LFST_CDEField of study code for the archived field of study is missing
There is no field of study code for the archived field of study.
MISSING_MAJR_CDEMajor code for the archived field of study is missing
There is no major code for the archived field of study.
MISSING_PIDMUnique identifier (PIDM) for the archived field of study is missing
There is no unique identifier (PIDM) for the archived field of study.
MISSING_PRIORITY_NOPriority number for the archived field of study is missing
There is no priority number for the archived field of study.
MISSING_SEQNOField of study sequence number for the archived field of study is missing
There is no field of study sequence number for the archived field of study.
MISSING_TERM_CDETerm code for the archived field of study is missing
There is no term code for the archived field of study.
MISSING_USER_IDUser ID for the archived field of study is missing
There is no user ID for the archived field of study.
PK_NOT_FOUNDCannot find the field of study archive record using the primary or unique key
The field of study archive record cannot be located using the primary or unique key.
P_DELETE_FAILEDCannot delete the field of study archive because the record does not exist
The field of study archive record cannot be deleted because the record does not exist.
RECORD_EXISTSCannot create field of study archive because the record already exists
The field of study archive 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.