index

Package sb_wl_exclusion_strings

This package contains the error messages and error message functions for the Waitlist Exclusion API (sb_wl_exclusion).

Message NameError Message
INVALID_ASTD_CODEInvalid value for academic standing on waitlist priority exclusion rules record.
The academic standing code entered must be a valid value in the academic standing code validation table(STVASTD).
INVALID_ATTS_CODEInvalid value for student attribute code on waitlist priority exclusion rules record.
The student attribute code entered must be valid in the student attribute code validation table(STVATTS).
INVALID_CAMP_CODEInvalid value for campus code on waitlist priority exclusion rules record.
The campus code entered must be valid in the campus code validation table (STVCAMP).
INVALID_CHRT_CODEInvalid value for cohort code on waitlist priority exclusion rules record.
The cohort code entered must be valid in the cohort code validation table (STVCHRT).
INVALID_CLAS_CODEInvalid value for class code on waitlist priority exclusion rules record.
The class code entered must be valid in the class code validation table (STVCLAS).
INVALID_COLL_CODEInvalid value for college code on waitlist priority exclusion rules record.
The college code entered must be valid in the college code validation table (STVCOLL).
INVALID_DATA_ORIGINInvalid value for data source on waitlist priority exclusion rules record.
An attempt was made to create or update the waitlist priority exclusion rule data origin with an invalid value.
INVALID_DEGC_CODEInvalid value for degree code on waitlist priority exclusion rules record.
The degree code entered must be valid in the degree code validation table (STVDEGC).
INVALID_LEVL_CODEInvalid value for level code on waitlist priority exclusion rules record.
The level code entered must be valid in the level code validation table (STVLEVL)./TD>
INVALID_LFST_CODEInvalid value for field of study type on waitlist priority exclusion rules record.
The study type code entered must be valid in the learner field of study type code validation table (GTVLFSTP).
INVALID_MAJR_CODEInvalid value for major code on waitlist priority exclusion rules record.
The major code entered must be valid in the major, minor, concentration code validation table (STVMAJR).
INVALID_MAX_GPAInvalid value for maximum GPA on waitlist priority exclusion rules record.
An attempt was made to create or update the maximum GPA with and invalid range value.
INVALID_MIN_GPAInvalid value for minimum GPA on waitlist priority exclusion rules record.
An attempt was made to create or update the minimum GPA with and invalid range value.
INVALID_PRIMARY_KEYInvalid value for unique sequence number waitlist priority exclusion rules record.
An attempt was made to create or update the unique sequence number with an invalid value.
INVALID_PROGRAMInvalid value for program code on waitlist priority exclusion rules record.
The program code entered must be valid in the program rules table (SMRPRLE).
INVALID_TERM_CODEInvalid value for term code on waitlist priority exclusion rules record.
An attempt was made to create or update the waitlist priority exclusion rules term code with an invalid value. The term code must be defined in the term base table (SOBTERM).
INVALID_USER_IDInvalid value for user Id on waitlist priority exclusion rules record.
An attempt was made to create or update the user id for waitlist priority exclusion rules with an invalid value.
MISSING_PRIMARY_KEYMissing mandatory value for unique sequence number on waitlist priority exclusion rules record.
An attempt was made to create or update the unique sequence number with a NULL value.
MISSING_TERM_CODEMissing mandatory value for term code on waitlist priority exclusion rules record.
An attempt was made to create or update the user id for course selection criteria with a NULL value.
MISSING_USER_IDMissing mandatory value for user Id on waitlist priority exclusion rules record.
An attempt was made to create or update the user id for waitlist priority exclusion rules with a NULL value.
PK_NOT_FOUNDCannot find record using primary key for waitlist priority exclusion rules record.
An attempt to update or delete a waitlist priority exclusion rules record was unsuccessful because the record could not be found using the primary key of unique sequence number.
P_DELETE_FAILEDCannot delete, record does not exist for waitlist priority exclusion rules record.
An attempt to delete a waitlist priority exclusion rules record was unsuccessful because the record could not be found.
RECORD_EXISTSCannot create, record already exists for waitlist priority exclusion rules record.
An attempt to create a waitlist priority exclusion rules record was unsuccessful because the record already exists; duplicates are not allowed.

Program units
f_get_error  

Variables
error_tab  

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.