index

Package gb_vbs_tables_str

This package contains the error messages and error message functions for the VBS TABLES API, gb_vbs_tables.

Message KeyError Message
CANNOT_DELETE_SYS_REQCannot delete system required VBS table rule record
An attempt was made to delete a system required VBS table rule record.  System required records cannot be deleted.
CANNOT_UPDATE_SYS_REQCannot update system required VBS table rule record
An attempt was made to update a system required VBS table rule record.  System required records cannot be updated.
INVALID_ACTIVE_INDInvalid value for VBS table rule Active indicator
An attempt was made to create or update the VBS table rule Active indicator to a value other than 'Y' or 'N'.
INVALID_FDMN_CODEInvalid value for VBS table rule Domain code
The VBS table rule Domain code entered must be a valid value in the FGAC Domain Validation table (GTVFDMN).
INVALID_SYS_REQ_INDInvalid value for VBS table rule System Required indicator
An attempt was made to create or update the VBS table rule System Required indicator to a value other than 'Y' or 'N'.
INVALID_TABLE_NAMEInvalid value for VBS table rule table name
The VBS table rule table name entered must be a valid value found in ALL_TABLES or ALL_VIEWS.
MISSING_ACTIVE_INDMissing mandatory value for VBS table rule Active indicator
The VBS table rule Active indicator is missing.  It must be 'Y' or 'N'.
MISSING_FDMN_CODEMissing mandatory value for VBS table rule Domain code
The VBS table rule Domain code is missing and must be a valid value from the VBS Domain code Validation table (GTVFDMN).
MISSING_SYS_REQ_INDMissing mandatory value for VBS table rule System Required indicator
The VBS table rule System Required indicator is missing.  It must be 'Y' or 'N'.
MISSING_TABLE_NAMEMissing mandatory value for VBS table rule Table Name
The VBS table rule Table Name is missing and must be a valid value found in ALL_TABLES or ALL_VIEWS.
MISSING_USER_IDMissing mandatory value for VBS table rule User ID
The VBS table rule User ID is missing and must be a valid value.
PK_NOT_FOUNDCannot find VBS table rule record using primary or unique key
An attempt to update or delete a VBS table rule record was unsuccessful because the record could not be found using the primary key of domain code and table.
P_DELETE_FAILEDCannot delete, VBS table rule record does not exist
An attempt to delete a VBS table rule record was unsuccessful because the record could not be found.
RECORD_EXISTSCannot create, VBS table rule record already exists
An attempt to create a VBS table 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 the error message.  Required.