index

Package sb_facsec_access_strings

This package contains the error messages and error message functions for SB_FACSEC_ACCESS.

Message NameError Message
INVALID_ACTIVE_INDActive Indicator for the sb_facsec_access API is not valid.
Active Indicator must be either 'Y' or 'N'.
INVALID_ALL_ACCESS_INDAll Access Indicator for the sb_facsec_access API is not valid.
All Access Indicator must be either 'Y' or 'N'.
INVALID_ATTR_TYPE_CHECK_INDAttribute And Type Checking for the sb_facsec_access API is not valid.
Attribute and Type Checking Indicator must be either 'Y' or 'N'.
INVALID_PIN_CONTROL_INDPin Control Indicator for the sb_facsec_access API is not valid.
Pin Control Indicator must be either 'Y' or 'N'.
INVALID_PRIMARY_INDPrimary Indicator for the sb_facsec_access API is not valid.
Primary Indicator must be either 'Y' or 'N'.
INVALID_PROC_CODEProcess Code for the sb_facsec_access API is not valid.
Process code must be valid on STVPROC.
INVALID_RELATIONSHIP_INDRelationship Indicator for the sb_facsec_access API is not valid.
Relationship Indicator must be either 'Y' or 'N'.
INVALID_ROLE_CDERole Code for the sb_facsec_access API is not valid.
Role code must be either 'A' or 'F'.
INVALID_SYSREQ_INDSystem Required Ind for the sb_facsec_access API is not valid.
System Required Indicator must be either 'Y' or 'N'.
MISSING_ACTIVE_INDActive Indicator is missing. This field is required by the sb_facsec_access API.
The Active Indicator is missing and must be a valid value ('Y' or 'N').
MISSING_ALL_ACCESS_INDAll Access Indicator is missing. This field is required by the sb_facsec_access API.
The All Access Indicator is missing and must be a valid value ('Y' or 'N').
MISSING_ATTR_TYPE_CHECK_INDAttribute And Type Checking is missing. This field is required by the sb_facsec_access API.
The Attribute And Type Checking Indicator is missing and must be a valid value ('Y' or 'N').
MISSING_PARENTRequired STVPROC() record not found for sb_facsec_access API.
Process code must be valid on STVPROC.
MISSING_PIN_CONTROL_INDPin Control Indicator is missing. This field is required by the sb_facsec_access API.
The Pin Control Indicator is missing and must be a valid value ('Y' or 'N').
MISSING_PRIMARY_INDPrimary Indicator is missing. This field is required by the sb_facsec_access API.
The Primary Indicator is missing and must be a valid value ('Y' or 'N').
MISSING_PROC_CODEProcess Code is missing. This field is required by the sb_facsec_access API.
The Process Code is missing and must be a valid value in the Process Code Validation Table (STVPROC).
MISSING_RELATIONSHIP_INDRelationship Indicator is missing. This field is required by the sb_facsec_access API.
The Relationship Indicator is missing and must be a valid value ('Y' or 'N').
MISSING_ROLE_CDERole Code is missing. This field is required by the sb_facsec_access API.
The Role Code is missing and must be a valid value ('A' or 'F').
MISSING_USER_IDUser Id is missing. This field is required by the sb_facsec_access API.
User Id is missing. This field is required by the sb_facsec_access API.
PK_NOT_FOUNDCannot find record using primary or unique key for the sb_facsec_access API.
An attempt to find a Faculty Security access rule record was unsuccessful because the record could not be found using the primary or unique key of the Process code and Role Code.
P_DELETE_FAILEDCannot delete FACSEC_ACCESS(sb_facsec_access) because the record does not exist.
An attempt to delete a Faculty Security access rule failed because no matching record was found.
RECORD_EXISTSsb_facsec_access API cannot create FACSEC_ACCESS(sb_facsec_access) because the record already exists.
An attempt to create a Faculty Security access rule record was unsuccessful because the record already exists.


Program units
f_get_error   Returns the error message corresponding to p_errorname.

Variables
error_tab   Global PL/SQL table that holds the error messages.


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Global PL/SQL table that holds the error messages.


f_get_error

Function f_get_error(p_errorname VARCHAR2)
  RETURN gb_common_strings.err_type

Returns the error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.