index

Package gb_vbs_predicate_str

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

Message KeyError Message
INVALID_FDMN_CODEInvalid value for VBS predicate Domain Code
An attempt was made to create or update the Domain Code for a VBS predicate with an invalid value.  The Domain Code must exist in the FGAC Domain Validation Table (GTVFDMN) and have a type (GOBFDMN_FDTP_CODE) equal to 'VBS'.
INVALID_FGAC_CODEInvalid value for VBS predicate FGAC Code
An attempt was made to create or update the VBS Predicate FGAC Code with an invalid value.  The FGAC Code must exist in the FGAC Group Validation Table (GTVFGAC).
INVALID_PREDICATEInvalid value for VBS predicate
Validation of the SQL for the VBS Predicate is not supported in the current version of the API.
INVALID_SEQNOInvalid value for VBS Predicate Sequence Number
An attempt was made to create or update the VBS Predicate Sequence Number with an invalid value.
The Sequence Number must be a positive integer between 1 and 9999.
INVALID_USER_IDInvalid value for VBS predicate User ID
Validation of the Oracle User ID is not supported in the current version of the VBS predicate API.
MISSING_FDMN_CODEMissing mandatory value for VBS predicate Domain Code
The VBS predicate Domain Code is missing.  It must be a valid value in the FGAC Domain Validation table (GTVFDMN).
MISSING_FGAC_CODEMissing mandatory value for VBS predicate FGAC Code
The VBS predicate FGAC Code is missing.  It must be a valid value in the FGAC Group Validation table (GTVFGAC).
MISSING_SEQNOMissing mandatory value for VBS Predicate Sequence Number
The VBS Predicate Sequence Number is missing.  It must be a positive integer between 1 and 9999.
MISSING_USER_IDMissing mandatory value for VBS predicate User ID
The VBS predicate User ID is missing and must be populated.
PK_NOT_FOUNDCannot find record using VBS predicate primary or unique key
An attempt to update or delete a VBS predicate record was unsuccessful because the record could not be found using the primary key of domain code, FGAC code, and sequence number.
P_DELETE_FAILEDCannot delete, VBS predicate record does not exist
An attempt to delete a VBS predicate record was unsuccessful because the record could not be found.
RECORD_EXISTSCannot create, VBS predicate record already exists
An attempt to create a VBS predicate record was unsuccessful because the record already exists; duplicates are not allowed.


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

Parameters
p_errorname   Name associated with error message.  Required.