index

Package gb_pcol_concentration_strings

Error messages and error message functions for the PRIOR COLLEGE CONCENTRATION API (gb_pcol_concentration).

Message NameError Message
INVALID_DEGC_CODEInvalid Degree for Prior College Concentration
An attempt was made to create or update the prior college concentration Degree code with an invalid value.  The Degree Code must exist in the Degree Code validation table (STVDEGC).
INVALID_MAJR_CODE_CONCInvalid Concentration for Prior College Concentration
An attempt was made to create or update the prior college Concentration code with an invalid value.  The Major Code must exist in the Major, Minor, Concentration Code validation table (STVMAJR).
INVALID_PIDMInvalid PIDM for Prior College Concentration
An attempt to create or update the prior college concentration record was unsuccessful because the PIDM given does not exist in the SPRIDEN table.
INVALID_SBGI_CODEInvalid Source Background Institution for Prior College Concentration
An attempt was made to create or update the prior college concentration Source Background Institution code with an invalid value.  The Source Background Institution Code must exist in the Source Background Institution Code validation table (STVSBGI).
MISSING_DEGR_SEQ_NOMissing mandatory Degree Sequence Number for Prior College Concentration
The prior college concentration Degree Sequence Number is missing or NULL and must be entered.
MISSING_MAJR_CODE_CONCMissing mandatory Concentration for Prior College Concentration
The prior college Concentration Code is missing or NULL and must be entered.
MISSING_PARENTRequired Degree parent record not found for Prior College Concentration
The prior college concentration PIDM, Source Background Institution Code and Degree Sequence Number are required and must be defined in the Prior College Degree Table (SORDEGR).
MISSING_PIDMMissing mandatory PIDM for Prior College Concentration
The PIDM for prior college concentration is missing or NULL and must be entered.
MISSING_SBGI_CODEMissing mandatory Source Background Institution for Prior College Concentration
The prior college concentration Source Background Institution Code is missing or NULL and must be entered.
PK_NOT_FOUNDCannot find record using primary or unique key for Prior College Concentration
An attempt was made to update a prior college concentration record that does not exist.
P_DELETE_FAILEDCannot delete Prior College Concentration, record does not exist
An attempt was made to delete a prior college concentration record that does not exist.
RECORD_EXISTSCannot create, record already exists for Prior College Concentration
An attempt was made to create a prior college concentration record that already exists.
P_UPDATE_UNSUPPORTEDCannot update Prior College Concentration, p_update is unsupported
An attempt was made to call the prior college concentration p_update procedure was unsuccessful because the p_update is unsupported.


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.