index

Package nb_effcert_category_strings

This package contains the error messages and error message functions for the Effort Certification Category Rule API (NB_EFFCERT_CATEGORY).
 

Message NameError Message
ECCG_RECORD_EXISTSCannot create Effort Certification Category Rule, Effort Category is already associated with an Effort Category Group.
An attempt was made to create a new EFFCERT_CATEGORY record, but Effort Category is already associated with an Effort Category Group.
INVALID_ECCG_CODEInvalid Effort Category for Effort Certification Category Rule.
An invalid Effort Category parameter was provided when calling a function or procedure in the Effort Certification Category Rule API (NB_EFFCERT_CATEGORY). The code must exist in the Effort Certification Category Code Validation table (NTVECCG).
INVALID_ECGR_CODEInvalid Effort Category Group for Effort Certification Category Rule.
An invalid Effort Category Group parameter was provided when calling a function or procedure in the Effort Certification Category Rule API (NB_EFFCERT_CATEGORY). The code must exist in the Effort Certification Category Group Code Validation table (NTVECGR).
MISSING_ECCG_CODEMissing mandatory Effort Category for Effort Certification Category Rule.
The Effort Category parameter was omitted when calling a function or procedure in the Effort Certification Category Rule API (NB_EFFCERT_CATEGORY). This parameter is a key value for the EFFCERT_CATEGORY entity and must be provided.
MISSING_ECGR_CODEMissing mandatory Effort Category Group for Effort Certification Category Rule.
The Effort Category Group parameter was omitted when calling a function or procedure in the Effort Certification Category Rule API (NB_EFFCERT_CATEGORY). This parameter is a key value for the EFFCERT_CATEGORY entity and must be provided.
P_DELETE_FAILEDCannot delete Effort Certification Category Rule, record does not exist.
An attempt was made to delete a EFFCERT_CATEGORY record, but a record with these key values (or ROWID) could not be found.
RECORD_EXISTSCannot create Effort Certification Category Rule, record already exists.
An attempt was made to create a new EFFCERT_CATEGORY record, but a record already exists with these key values.

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.