index

Package gb_group_rules_str

This package contains the error messages and error message functions for the Group Rules API, gb_group_rules.

Message KeyError Message
MISSING_FGAC_CODEMissing mandatory value for VBS group rule FGAC Code
The VBS group rule FGAC Code is missing and must be a valid value from the FGAC Code Validation Table (GTVFGAC).
MISSING_ACTIVE_INDMissing mandatory value for VBS group rule Active indicator
The VBS group rule Active indicator is missing.  It must be Y or N.
MISSING_EFF_DATEMissing mandatory value for VBS group rule Effective Date
The VBS group rule Effective Date is missing.  It must a valid date in the standard date format.
MISSING_USER_IDMissing mandatory value for VBS group rule Oracle User ID
The VBS group rule Oracle User ID is missing.  It must be a valid value such as the Oracle User ID as returned by the gb_common.f_sct_user function.
INVALID_FGAC_CODEInvalid value for VBS group rule FGAC Code
The VBS group rule FGAC Code entered must be a valid value in the FGAC Code Validation table (GTVFGAC).
INVALID_ACTIVE_INDInvalid value for VBS group rule Active indicator
An attempt was made to create or update the VBS group rule Active indicator with a value other than Y or N.
INVALID_EFF_DATEInvalid value for VBS group rule Effective Date
At attempt was made to create or update the VBS group rule Effective date with a value that is not a valid date or was not in the standard date format.
INVALID_USER_IDInvalid value for VBS group rule Oracle User ID
The VBS group rule Oracle User ID entered must be a valid value in ALL_USERS.
PK_NOT_FOUNDCannot find VBS group rule record using primary or unique key
An attempt to update or delete a VBS group rule record was unsuccessful because the record could not be found using the primary key (FGAC code).
P_DELETE_FAILEDCannot delete, VBS group rule record does not exist
An attempt to delete a VBS group rule record was unsuccessful because the record could not be found.
RECORD_EXISTSCannot create, VBS group rule record already exists
An attempt to create a VBS group rule record was unsuccessful because the record already exists; duplicates are not allowed.


Program units
f_get_error   Returns an 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 an error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with error message.  Required.