index

Package sb_gradapp_graddate_strings

This package contains the error messages and error message functions for the Graduation Application Graduation Data Availability API (sb_gradapp_graddate).

Message NameError Message
INVALID_ACYR_CODEGraduation Year is not valid
Graduation year is not valid.
INVALID_CEREMONY_INDGraduation Ceremony Indicator is not valid
Graduation ceremony indicator must be 'Y' or 'N'.
INVALID_FROM_TO_DATESGraduation From Date must be greater than Graduation To Date
Graduation from date must be greater than the graduation to date.
INVALID_GADR_CODEGraduation Application Display Rule Code is not valid
Code used for the graduation application display rule is not valid.
INVALID_GRAD_TERM_CODEGraduation Term is not valid
Graduation term is not valid.
MISSING_CEREMONY_INDGraduation Ceremony Indicator is missing
Graduation ceremony indicator is required.
MISSING_DATE_VALUESAt least one of Graduation Date, Term or Year must be entered
At least one of Graduation Date, Term or Year must be entered.
MISSING_FROM_DATEGraduation From Date is missing
Graduation from date is required.
MISSING_GADR_CODEGraduation Application Display Rule Code is missing
Graduation application display rule code is required.
MISSING_PARENTRequired parent Display Rule (SHBGADR) record not found for Graduation Date Availability
Display Rule parent record not found for the graduation date.
MISSING_SEQNOGraduation Date Availability Sequence Number is missing
Graduation date availability sequence number is required.
MISSING_TO_DATEGraduation To Date is missing
Graduation to date is required.
MISSING_USER_IDUser ID is missing
User ID is required.
PK_NOT_FOUNDCannot find Graduation Date Availability record using the primary or unique key
Cannot find the graduation date availability using the primary or unique key.
P_DELETE_FAILEDCannot delete Graduation Date Availability (SHRGADA) because the record does not exist
Cannot delete the graduation date availability record because the record cannot be not found.
RECORD_EXISTSCannot create Graduation Date Availability because the record already exists
Cannot create a graduation date availability record because the record already exists.


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.