Package sb_wl_reordering

Package sb_wl_reordering_strings

This package contains the error messages and error message functions for the Waitlist Reorder Priority Rules API (sb_wl_reordering).

Message Name	Error Message
INVALID_ASTD_CODE	Invalid value for the academic standing on the waitlist priority reordering rules record.
The academic standing code entered must be a valid value in the academic standing code validation table (STVASTD).
INVALID_ATTS_CODE	Invalid value for the student attribute code on the waitlist priority reordering rules record.
The student attribute code entered must be valid in the student attribute code validation table (STVATTS).
INVALID_CAMP_CODE	Invalid value for the campus code on the waitlist priority reordering rules record.
The campus code entered must be valid in the campus code validation table (STVCAMP).
INVALID_CHRT_CODE	Invalid value for the cohort code on the waitlist priority reordering rules record.
The cohort code entered must be valid in the cohort code validation table (STVCHRT).
INVALID_CLAS_CODE	Invalid value for the class code on the waitlist priority reordering rules record.
The class code entered must be valid in the class code validation table (STVCLAS).
INVALID_COLL_CODE	Invalid value for the college code on the waitlist priority reordering rules record.
The college code entered must be valid in the college code validation table (STVCOLL).
INVALID_DATA_ORIGIN	Invalid value for the data source on the waitlist priority reordering rules record.
An attempt was made to create or update the waitlist priority reordering rule data origin with an invalid value.
INVALID_DEGC_CODE	Invalid value for the degree code on the waitlist priority reordering rules record.
The degree code entered must be valid in the degree code validation table (STVDEGC).
INVALID_GPA	Maximum GPA value should be greater than the minimum GPA value for the waitlist priority reordering rules record.
An attempt was made to create or update the minimum GPA with an invalid range value. The maximum GPA value should be greater than the minimum GPA.
INVALID_LEVL_CODE	Invalid value for the level code on the waitlist priority reordering rules record.
The level code entered must be valid in the level code validation table (STVLEVL).
INVALID_LFST_CODE	Invalid value for the field of study type on the waitlist priority reordering rules record.
The field of study type code entered must be valid in the learner field of study type code validation table (GTVLFSTP).
INVALID_MAJR_CODE	Invalid value for the major code on the waitlist priority reordering rules record.
The major code entered must be valid in the major, minor, concentration code validation table (STVMAJR).
INVALID_MAX_GPA	Invalid value for the maximum GPA on the waitlist priority reordering rules record.
An attempt was made to create or update the maximum GPA with an invalid range value.
INVALID_MIN_GPA	Invalid value for the minimum GPA on the waitlist priority reordering rules record.
An attempt was made to create or update the minimum GPA with an invalid range value.
INVALID_PRIMARY_KEY	Invalid value for the primary key on the waitlist priority reordering rules record.
An attempt was made to create or update the unique sequence number with an invalid value.
INVALID_PRIORITY_NUM	Invalid value for the priority number on the waitlist priority reordering rules record.
An attempt was made to create or update the waitlist priority rule priority number with an invalid value.
INVALID_PROGRAM	Invalid value for the program code on the waitlist priority reordering rules record.
The program code entered must be valid in the program rules table (SMRPRLE).
INVALID_TERM_CODE	Invalid value for the term code on the waitlist priority reordering rules record.
An attempt was made to create or update the waitlist priority reordering rules term code with an invalid value. The term code must be defined in the term base table (SOBTERM).
INVALID_USER_ID	Invalid value for the user ID on the waitlist priority reordering rules record.
An attempt was made to create or update the user ID for the waitlist priority reordering rules with an invalid value.
MISSING_PARENT	Term does not exist on the automated waitlist term control.
The term code is required and must be defined on automated waitlist term control table (SOBWLTC).
MISSING_PRIMARY_KEY	Missing mandatory value for the unique sequence number on the waitlist priority reordering rules record.
An attempt was made to create or update the unique sequence number with a NULL value.
MISSING_PRIORITY_NUM	Missing mandatory value for the priority number on the waitlist priority reordering rules record.
An attempt was made to create or update the priority number with a NULL value.
MISSING_TERM_CODE	Missing mandatory value for the term code on the waitlist priority reordering rules record.
An attempt was made to create or update the term code for the waitlist priority reordering rules with a NULL value.
MISSING_USER_ID	Missing mandatory value for the user ID the on the waitlist priority reordering rules record.
An attempt was made to create or update the user ID for the waitlist priority reordering rules with a NULL value.
PK_NOT_FOUND	Cannot find the record using the primary key for the waitlist priority reordering rules record.
An attempt to update or delete a waitlist priority reordering rules record was unsuccessful because the record could not be found using the primary key of unique sequence number.
P_DELETE_FAILED	Cannot delete the record because it does not exist for the waitlist priority reordering rules record.
An attempt to delete a waitlist priority reordering rules record was unsuccessful because the record could not be found.
RECORD_EXISTS	Cannot create the record because it already exists for the waitlist priority reordering rules record.
An attempt to create a waitlist priority reordering rules record was unsuccessful because the record already exists; duplicates are not allowed.

Program units

f_get_error

Variables

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.