index

Package gb_pcol_degree_strings

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

Message NameError Message
ATTEND_FROM_GREATER_ATTEND_TOCannot update Prior College Degree; Attendance Date must be greater than Begin Date
An attempt was made to insert or update the prior college degree Date First Attended or the prior college degree Date Last Attended so that the Date First Attended is greater than the Date Last Attended.
ATTEND_FROM_GREATER_GRADUATIONCannot update Prior College Degree; Date of Graduation must be greater than Date First Attended
An attempt was made to insert or update the prior college degree Date First Attended or the prior college degree Date of Graduation so that the Date First Attended is greater than the Date of Graduation.
ATTEND_TO_GREATER_ATTEND_FROMCannot update Prior College Degree; Date Last Attended must be greater than Date First Attended
An attempt was made to insert or update the prior college degree Date First Attended or the prior college degree Date Last Attended so that the Date First Attended is greater than the Date Last Attended.
CHILD_RECORD_EXISTSCannot delete Prior College Degree; Major/Minor/Area of Concentration data exists
An attempt was made to delete a prior college degree record when a child Major/Minor/Area of Concentration record exists.
INVALID_COLL_CODEInvalid College for Prior College Degree
An attempt was made to create or update the prior college degree College code with an invalid value. The College Code must exist in the College Code validation table (STVCOLL).
INVALID_DEGC_CODEInvalid Degree for Prior College Degree
An attempt was made to create or update the prior college Degree code with an invalid value. The Degree Code must exist in the Degree Code validation table (STVDEGC).
INVALID_EGOL_CODEInvalid Education Goal for Prior College Degree
An attempt was made to create or update the prior college degree Education Goal code with an invalid value. The Education Goal Code must exist in the Education Goal Code validation table (STVEGOL).
INVALID_HONR_CODEInvalid Honor for Prior College Degree
An attempt was made to create or update the prior college degree Institutional Honors code with an invalid value. The Institutional Honors Code must exist in the Institutional Honors Code validation table (STVHONR).
INVALID_PIDMInvalid Pidm for Prior College Degree
An attempt to create or update the prior college degree record was unsuccessful because the PIDM given does not exist in the SPRIDEN table.
INVALID_PRIMARY_INDInvalid Primary Indicator for Prior College Degree; valid values: 'N' and 'Y'
An attempt was made to create or update the prior college degree Primary indicator with a value other than 'Y' or 'N'.
INVALID_SBGI_CODEInvalid Source Background Institution for Prior College Degree
An attempt was made to create or update the prior college degree Source Background Institution code with an invalid value. The Source Background Institution Code must exist in the Source Background Institution Code validation table (STVSBGI).
INVALID_TERM_DEGREEInvalid Prior College Terminal Degree Indicator; valid values: 'N' and 'Y'
An attempt was made to create or update the prior college Terminal Degree indicator with a value other than 'Y' or 'N'.
MISSING_DEGR_SEQ_NOMissing mandatory Prior College Degree Sequence Number
The prior college Degree Sequence Number is missing or NULL and must be entered.
MISSING_PARENTRequired Source Background Institution parent record not found for Prior College Degree
The prior college degree PIDM and Source Background Institution Code are required and must be defined in the Prior College Table (SORPCOL).
MISSING_PIDMMissing mandatory PIDM for Prior College Degree
The PIDM for prior college degree is missing or NULL and must be entered.
MISSING_SBGI_CODEMissing mandatory Source Background Institution for Prior College Degree
The prior college degree Source Background Institution Code is missing or NULL and must be entered.
PK_NOT_FOUNDCannot update Prior College Degree, record does not exist
An attempt was made to update a prior college degree record that does not exist.
P_DELETE_FAILEDCannot delete Prior College Degree, record does not exist
An attempt was made to delete a prior college degree record that does not exist.
RECORD_EXISTSCannot create, record already exists for Prior College Degree
An attempt was made to create a prior college degree 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.