Package sb_crse_select_pri

Package sb_crse_select_pri_strings

This package contains the error messages and error message functions for the Waitlist Course Selection Priority API.

Message Name	Error Message
INVALID_ATTR_CODE	Invalid value for the course attribute code on the course selection criteria for the waitlist priority rules record.
The course attribute code entered must be a valid value in the degree program attribute code validation table (STVATTR).
INVALID_COLL_CODE	Invalid value for the college code on the course selection criteria for the waitlist priority rules record.
The college code entered must be a valid value in the college code validation table (STVCOLL).
INVALID_CRN	Invalid value for the course reference number on the course selection criteria for the waitlist priority rules record.
An attempt was made to create or update a course reference number with a value that does not exist on the section's general information record for the specified term code.
INVALID_CRSE_NUMB	Invalid value for the course number on the course selection criteria for the waitlist priority rules record.
An attempt was made to create or update a course number with a value that does not exist on the course's general information record for the specified subject code.
INVALID_DATA_ORIGIN	Invalid value for the data source on the course selection criteria for the waitlist priority rules record.
An attempt was made to create or update the course selection criteria data origin with an invalid value.
INVALID_PRIMARY_KEY	Invalid value for the unique sequence number on the course selection criteria for the waitlist priority rules record.
An attempt was made to create or update the unique sequence number with an invalid value.
INVALID_SUBJ_CODE	Invalid value for the subject code on the course selection criteria for the waitlist priority rules record.
The subject code entered must be a valid value in the subject code validation table (STVSUBJ).
INVALID_TERM_CODE	Invalid value for the term code on the course selection criteria for the waitlist priority rules record.
An attempt was made to create or update the course selection criteria 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 course selection criteria for the waitlist priority rules record.
An attempt was made to create or update the user ID for the course selection criteria with an invalid value.
MISSING_PARENT	Term code 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 course selection criteria for the waitlist priority rules record.
An attempt was made to create or update the unique sequence number with a NULL value.
MISSING_TERM_CODE	Missing mandatory value for the term code on the course selection criteria for the waitlist priority rules record.
The course selection criteria term code is missing and must be a valid value in the term code validation table (STVTERM).
MISSING_USER_ID	Missing mandatory value for the user ID on the course selection criteria for the waitlist priority rules record.
An attempt was made to create or update the user ID for the course selection criteria with a NULL value.
PK_NOT_FOUND	Cannot find a record using the primary or unique key on the course selection criteria for the waitlist priority rules record.
An attempt to update or delete a course selection criteria record was unsuccessful because the record could not be found using the primary key or unique sequence number.
P_DELETE_FAILED	Cannot delete the record because it does not exist on the course selection criteria for the waitlist priority rules.
An attempt to delete a course selection criteria record was unsuccessful because the record could not be found.
RECORD_EXISTS	Cannot create the course selection criteria record because the rule already exists.
An attempt to create a course selection criteria 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.