index

Package gb_pii_tables_str

This package contains the error messages and error message functions for PII TABLES API.

Message KeyError Message
INVALID_TABLE_NAMEInvalid value for PII table name
The PII table name entered must be a valid value in ALL_TABLES or ALL_VIEWS.
INVALID_SYS_REQ_INDInvalid value for PII tables System Required indicator
An attempt was made to create the FGAC business profile rule System Required indicator to a value other than 'Y' or 'N', or an attempt was made to update a record where the System Required indicator is 'Y'.
Updates are not permitted to the System Required indicator if the current value is Y.
INVALID_ACTIVE_INDInvalid value for PII tables Active indicator
An attempt was made to create or update the PII tables Active indicator to a value other than 'Y' or 'N'.
MISSING_TABLE_NAMEMissing mandatory value for PII table name
The PII table name is missing and must be a valid value from ALL_TABLES or ALL_VIEWS.
MISSING_COLUMN_NAMEMissing mandatory value for PII column name
The PII column name is missing and must be a valid value.
MISSING_SYS_REQ_INDMissing mandatory value for PII tables System Required indicator
The PII tables System Required indicator is missing.  It must 'Y' or 'N'.
MISSING_ACTIVE_INDMissing mandatory value for PII tables Active indicator
The PII tables Active indicator is missing.  It must 'Y' or 'N'.
MISSING_USER_IDMissing mandatory value for PII tables User ID
The PII tables User ID is missing and must be a valid Oracle user.
P_DELETE_FAILEDCannot delete, PII tables record does not exist
An attempt to delete a PII tables record was unsuccessful because the record could not be found.
PK_NOT_FOUNDCannot find PII tables record using primary or unique key
An attempt to update or delete a PII tables record was unsuccessful because the record could not be found using the primary key which is the Table Name.
RECORD_EXISTSCannot create, PII tables record already exists
An attempt to create a PII tables record was unsuccessful because the record already exists; duplicates are not allowed.
CANNOT_DELETE_SYS_REQCannot delete PII tables System Required record
An attempt to delete the record was unsuccessful because the record is required by the system.
CANNOT_UPDATE_SYS_REQCannot update PII tables System Required record
An attempt to update the record was unsuccessful because the record is required by the system.


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.