index

Package gb_prior_college_strings

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

Message NameError Message
ADMR_CODE_EXISTSCannot update Prior College, Admissions request code used for another record
An attempt to create or update the prior college record was unsuccessful because the admissions request code is being used with an existing record.
DEGREE_CHILD_EXISTSCannot delete Prior College, Degree record exists
An attempt to delete the prior college record was unsuccessful because an existing prior college degree child record exists.
INVALID_ADMR_CODEInvalid Admission Request for Prior College
An attempt was made to create or update the prior college Admission Request code with an invalid value.  The Admission Request Code must exist in the Admission Request Code validation table (STVADMR).
INVALID_OFFICIAL_TRANSInvalid Official Transcript indicator for Prior College; Valid value is 'Y'
An attempt was made to create or update the prior college official transcript indicator with a value other than 'Y' or null.
INVALID_PIDMInvalid PIDM for Prior College
An attempt to create or update the prior college record was unsuccessful because the PIDM given does not exist in the SPRIDEN table.
INVALID_SBGI_CODEInvalid Source Background Institution for Prior College
An attempt was made to create or update the prior college 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_PIDMMissing mandatory PIDM for Prior College
The prior college PIDM is missing or NULL and must be entered.
MISSING_SBGI_CODEMissing mandatory Source Background Institution for Prior College
The prior college Source Background Institution Code is missing or NULL and must be entered.
PK_NOT_FOUNDCannot update Prior College, record does not exist
An attempt was made to update a prior college record that does not exist.
P_DELETE_FAILEDCannot delete Prior College, record does not exist
An attempt was made to delete a prior college record that does not exist.
RECORD_EXISTSCannot create, record already exists for Prior College
An attempt was made to create a prior college record that 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.