index

Package sb_fac_sec_dates_strings

This package contains the error messages and error message functions for the sb_fac_sec_dates API.
 

Message NameError Message
INVALID_DATE_RANGEStart Date must be less than or equal to the to date.
The end date must be greater than or equal to the start date.
INVALID_MENU_INDMenu Indicator for the sb_fac_sec_dates API is not valid.
Menu indicator must be either 'Y' or 'N'.
INVALID_TERM_CODETerm for the sb_fac_sec_dates API is not valid.
The term code must be a valid value in the Term Code Validation Table (STVTERM).
INVALID_TERM_INDTerm Indicator for the sb_fac_sec_dates API is not valid.
Term indicator must be either 'Y' or 'N'.
MISSING_END_DATEEnd Date is missing. This field is required by the sb_fac_sec_dates API.
The end date is missing and must be a valid date greater than or equal to the start date.
MISSING_MENU_INDMenu Indicator is missing. This field is required by the sb_fac_sec_dates API.
The Menu Indicator is missing and must be a valid value ('Y' or 'N').
MISSING_SEQNOSequence Number is missing. This field is required by the sb_fac_sec_dates API.
The sequence number is missing. This field is required by the sb_fac_sec_dates API.
MISSING_START_DATEStart Date is missing. This field is required by the sb_fac_sec_dates API.
The Start date is missing and must be a valid date
MISSING_TERM_CODETerm is missing. This field is required by the sb_fac_sec_dates API.
The Term Code is missing and must be a valid value in the Term Code Validation Table (STVTERM).
MISSING_TERM_INDTerm Indicator is missing. This field is required by the sb_fac_sec_dates API.
The Term Indicator is missing and must be a valid value ('Y' or 'N').
MISSING_USER_IDUser Id is missing. This field is required by the sb_fac_sec_dates API.
User Id is missing. This field is required by the sb_fac_sec_dates API
PK_NOT_FOUNDCannot find record using primary or unique key for the sb_fac_sec_dates API.
An attempt to find a Faculty Security term rule record was unsuccessful because the record could not be found using the primary or unique key of the Term code and Sequence number.
P_DELETE_FAILEDCannot delete FAC_SEC_DATES(sb_fac_sec_dates) because the record does not exist.
An attempt to delete a Faculty Security term rule failed because no matching record was found.
RECORD_EXISTSsb_fac_sec_dates API cannot create FAC_SEC_DATES(sb_fac_sec_dates) because the record already exists.
An attempt to create a Faculty Security term rule record was unsuccessful because the record already exists.


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.