index

Package gb_fgac_user_rule_str

This package contains the error messages and error message functions for the FGAC USER RULE API, gb_fgac_user_rule.

Message KeyError Message
INVALID_DELETE_INDInvalid value for FGAC user rule Delete indicator
An attempt was made to create or update the FGAC user rule Delete indicator to a value other than 'Y' or 'N'.
INVALID_FDMN_CODEInvalid value for FGAC user rule Domain code
The FGAC user rule Domain code entered must be a valid value in the Domain Code Validation table (GTVFDMN).
INVALID_FGAC_CODEInvalid value for FGAC user rule FGAC code
The FGAC user rule FGAC code entered must be a valid value in the FGAC Code Validation table (GTVFGAC).
INVALID_FGAC_USER_IDInvalid value for FGAC user rule FGAC Banner User ID
The FGAC user rule FGAC User ID entered must be a valid value in ALL_USERS.
INVALID_FPRD_SEQNOInvalid value for FGAC user rule Predicate Sequence Number
An attempt was made to create or update the FGAC user rule Predicate Sequence Number with an invalid value.
It must be a positive integer between 1 and 9999.
INVALID_INSERT_INDInvalid value for FGAC user rule Insert indicator
An attempt was made to create or update the FGAC user rule Insert indicator to a value other than 'Y' or 'N'.
INVALID_SELECT_INDInvalid value for FGAC user rule Select indicator
An attempt was made to create or update the FGAC user rule Select indicator to a value other than 'Y' or 'N'.
INVALID_UPDATE_INDInvalid value for FGAC user rule Update indicator
An attempt was made to create or update the FGAC user rule Update indicator to a value other than 'Y' or 'N'.
MISSING_DELETE_INDMissing mandatory value for FGAC user rule Delete indicator
The FGAC user rule Delete indicator is missing.  It must be 'Y' or 'N'.
MISSING_FDMN_CODEMissing mandatory value for FGAC user rule Domain code
The FGAC user rule Domain code is missing and must be a valid value from the Domain Code Validation table (GTVFDMN).
MISSING_FGAC_CODEMissing mandatory value for FGAC user rule FGAC code
The FGAC user rule FGAC code is missing and must be a valid value from the FGAC Code Validation table (GTVFGAC).
MISSING_FGAC_USER_IDMissing mandatory value for FGAC user rule FGAC User ID
The FGAC user rule Banner User ID is missing.  It must be a valid value in ALL_USERS.
MISSING_FPRD_SEQNOMissing mandatory value for FGAC user rule Predicate Sequence Number
The FGAC user rule Predicate Sequence Number is missing and must be a positive integer between 1 and 9999.
MISSING_INSERT_INDMissing mandatory value for FGAC user rule Insert indicator
The FGAC user rule Insert indicator is missing. It must be 'Y' or 'N'.
MISSING_PARENTRequired parent record for FGAC user rule not found
An attempt to update a FGAC user rule record was unsuccessful because the required parent record could not be found.
MISSING_SELECT_INDMissing mandatory value for FGAC user rule Select indicator
The FGAC user rule Select indicator is missing. It must be 'Y' or 'N'.
MISSING_UPDATE_INDMissing mandatory value for FGAC user rule Update indicator
The FGAC user rule Update indicator is missing. It must be 'Y' or 'N'.
MISSING_USER_IDMissing mandatory value for FGAC user rule User ID
The FGAC user rule Banner User ID is missing and must be a valid value.
PK_NOT_FOUNDCannot find FGAC user rule record using primary or unique key
An attempt to update or delete a FGAC user rule record was unsuccessful because the record could not be found using the primary key.
P_DELETE_FAILEDCannot delete, FGAC user rule record does not exist
An attempt to delete a FGAC user rule record was unsuccessful because the record could not be found.
RECORD_EXISTSCannot create, FGAC user rule record already exists
An attempt to create a FGAC user rule 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 variable for storing the error messages.


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Global variable for storing the error messages.


f_get_error

FUNCTION f_get_error(p_errorname VARCHAR2) RETURN VARCHAR2

Returns the error message corresponding to p_errorname

Parameters
p_errorname   Name associated with the error message.