BANINST1@S10B80

index

Package sb_wl_section_ctrl_strings

This package contains the error messages and error message functions for the Waitlist Section Control API.

Message NameError Message
INVALID_AUTO_NOTIFY_INDInvalid value for the automatic waitlist notification indicator on the waitlist section control record.
An attempt was made to create or update the control on waitlist section control to allow automatic notification when a seat becomes available to a value other than 'N' (No) or 'Y' (Yes).
INVALID_CRNInvalid value for the course reference number on the waitlist section control record.
An attempt was made to create or update the course reference number with a value that does not exist on the section's general information record for the specified term code.
INVALID_DATA_ORIGINInvalid value for the data source on the waitlist section control record.
An attempt was made to create or update the waitlist section control data origin with an invalid value.
INVALID_DEADLINE_NOTIFYInvalid value for the waitlist notification deadline hours on the waitlist section control. Value should be greater than zero.
An attempt was made to create or update the waitlist notification deadline hours with a value less than zero.
INVALID_TERM_CODEInvalid value for the term code on the waitlist section control record.
The term code entered must be valid in the term code validation table (STVTERM).
INVALID_USER_IDInvalid value for the user ID on the waitlist section control record.
An attempt was made to create or update the user id for the waitlist section control record with an invalid value.
INVALID_WL_POS_WEBC_DISP_INDInvalid value for the show waitlist position on the self-service indicator on the waitlist section control record.
An attempt was made to create or update the show waitlist position on the self-service indicator for the waitlist section control with an invalid value.
INVALID_WL_REG_CHECK_INDInvalid value for the use waitlist registration checking indicator on the waitlist section control record.
An attempt was made to create or update the control to enforce waitlist registration errors checking with a value other than 'N' (No) or 'Y' (Yes).
INVALID_MAX_RESEND_HRSInvalid value for the maximum resend hours on the waitlist section control. Value should be greater than or equal to zero.
An attempt was made to create or update the maximum resend hours with a value less than zero.
MISSING_AUTO_NOTIFY_INDMissing mandatory value for the automatic waitlist notification indicator on the waitlist section control record.
The required indicator to enforce automatic notification when a seat becomes available is missing and must be designated with a value of 'N' (No) or 'Y' (Yes).
MISSING_CRNMissing mandatory value for the course reference number on the waitlist section control record.
An attempt was made to create or update the waitlist section control course reference number with a NULL value.
MISSING_DEADLINE_NOTIFYMissing value for the waitlist notification deadline hours on the waitlist section control record.
Waitlist notification deadline hours cannot be null when the automatic waitlist notification indicator is active.
Waitlist deadline hours must be provided when the automatic waitlist notification indicator is active.
MISSING_PARENTCourse reference number for the specified term does no exist on the 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 the term code on the waitlist section control 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 the user ID on the waitlist section control record.
An attempt was made to create or update the waitlist section control user ID with a NULL value.
MISSING_WL_POS_WEBC_DISP_INDMissing mandatory value for the show waitlist position on the self-service indicator on the waitlist section control record.
The required indicator to allow the display of the student's waitlist position on self-service is missing and must be designated with a value of 'N' (No) or 'Y' (Yes).
MISSING_WL_REG_CHECK_INDMissing mandatory value for the use waitlist registration checking indicator on the waitlist section control record.
The required indicator to enforce waitlist registration checking is missing and must be designated with a value of 'N' (No) or 'Y' (Yes).
PK_NOT_FOUNDCannot find the record using the primary key for the waitlist section control.
An attempt to update or delete a waitlist section control record was unsuccessful because the record could not be found using the primary key of the student term code and course reference number.
P_DELETE_FAILEDCannot delete the record because it does not exist for the waitlist section control.
An attempt to delete a waitlist section control record was unsuccessful because the record could not be found.
RECORD_EXISTSCannot create the record because it already exists for the waitlist section control.
An attempt to create a waitlist section  control record was unsuccessful because the record already exists; duplicates are not allowed.


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.