index

Package sb_wl_collector_strings

This package contains the error messages and error message functions for the Waitlist Collector API (sb_wl_collector).

Message NameError Message
INVALID_CRNInvalid value for course reference number on seats available collector record.
An attempt was made to create or update course reference number with a value that does not exists on section general information record for the specified term code.
INVALID_DATA_ORIGINInvalid value for data source on seats available collector record.
An attempt was made to create or update the seats available collector data origin with an invalid value.
INVALID_TERM_CODEInvalid value for term code on seats available collector record.
The term code entered must be valid in the term code validation table (STVTERM).
INVALID_USER_IDInvalid value for user ID on seats available collector record.
An attempt was made to create or update the user id for seats available collector with an invalid value.
MISSING_CRNMissing mandatory value for course reference number on seats available collector record.
An attempt was made to create or update seats available collector course reference number with a NULL value.
MISSING_PARENTCourse reference number for specified term does no exists on section general information.
The term code and course reference number are required and must be defined in the section general information table (SSBSECT).
MISSING_TERM_CODEMissing mandatory value for term code on seats available collector record.
The required term code value is missing and must be valid in the term code validation table (STVTERM).
MISSING_USER_IDMissing mandatory value for most recent user ID to create or update the seats available collector record.
An attempt was made to create or update the seats available collector user id with a NULL value.
PK_NOT_FOUNDCannot find seats available collector record using primary or unique key.
An attempt to update or delete a seats available collector record was unsuccessful because the record could not be found using the primary key of student term code and course reference number.
P_DELETE_FAILEDCannot delete ,seats available collector record does not exists.
An attempt to delete a seats available collector record was unsuccessful because the record could not be found.
RECORD_EXISTSCannot create, seats available collector record already exists.
An attempt to create a seats available collector 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.