index

Package sb_gradapp_strings

This package contains the error messages and error message functions for the Graduation Application API (sb_gradapp).
 
This package contains the error messages and error message functions for SB_GRADAPP.

Message NameError Message
INVALID_DETC_DETAIL_CODEDetail Code is not valid
Detail Code is not valid.
INVALID_DGMR_UPD_GRST_CODEUpdate Degree Graduation Status Code is not valid
Update Degree Graduation Status Code is not valid.
INVALID_GADR_CODEGraduation Application Display Rule is not valid
Graduation Application Display Rule is not valid.
INVALID_GAST_CODEGraduation Application Status Code is not valid
Graduation Application Status Code is not valid.
INVALID_GRAD_ACYR_CODEGraduation Academic Year Code is not valid
Graduation Academic Year Code is not valid.
INVALID_GRAD_ATTEND_CDEAttend Graduation Indicator is not valid
Attend Graduation Indicator is not valid.
INVALID_GRAD_TERM_CODEGraduation Term Code is not valid
Graduation Term Code is not valid.
INVALID_NATN_CODEMailing Address Nation Code is not valid
Mailing Address Nation Code is not valid.
INVALID_PIDMPIDM is not valid
PIDM is not valid.
INVALID_STAT_CODEMailing Address State Code is not valid
Mailing Address State Code is not valid.
INVALID_TERM_CODE_DETCBilling Detail Code is not valid
Billing Detail Code is not valid.
INVALID_WPYO_CODEWeb Payment Code is not valid
Web Payment Code is not valid.
MISSING_GAST_CODEGraduation Application Status Code is missing
Graduation Application Status Code is required.
MISSING_GAST_DATEGraduation Application Status Date is missing
Graduation Application Status Date is required.
MISSING_PIDMPIDM is missing
PIDM is required.
MISSING_REQUEST_DATERequest Date is missing
Request Date is required.
MISSING_SEQNOSequence Number is missing
Sequence Number is required.
MISSING_USER_IDUser ID is missing
User ID is required.
PK_NOT_FOUNDCannot find the graduation application record using primary or unique key.
Cannot find the graduation application record using primary or unique key.
P_DELETE_FAILEDCannot delete the graduation application record because the record does not exist
Cannot delete the graduation application record because the record does not exist.
RECORD_EXISTSCannot create the graduation application record because the record already exists
Cannot create the graduation application record because the record already exists.

Program units
f_get_error  
f_active  
f_inactive  

Variables
error_tab  

Constants
ACTIVE  
INACTIVE  

ACTIVE 

ACTIVE     CONSTANT VARCHAR2(30) := 'AC';

Constant for the Graduation Application Status Code AC ACTIVE

INACTIVE 

INACTIVE   CONSTANT VARCHAR2(30) := 'IA';

Constant for the Graduation Application Status Code IA INACTIVE

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.

f_active 

Function f_active RETURN VARCHAR2

Returns the ACTIVE status constant.

Returns
ACTIVE Constant

f_inactive 

Function f_inactive RETURN VARCHAR2

Returns the INACTIVE status constant.

Returns
INACTIVE Constant