index

Package nb_effcert_ftyp_strings

This package contains the error messages and error message functions for the Effort Certification Member Fund Type API (NB_EFFCERT_FTYP).
 

Message NameError Message
INVALID_FTYP_CODEInvalid Fund Type for Effort Certification Member Fund Type.
An invalid Fund Type parameter was provided when calling a function or procedure in the Effort Certification Member Fund Type API (NB_EFFCERT_FTYP). The code must exist in the Fund Type Validation table (FTVFTYP).
MISSING_FTYP_CODEMissing mandatory Fund Type for Effort Certification Member Fund Type.
The Fund Type parameter was omitted when calling a function or procedure in the Effort Certification Member Fund Type API (NB_EFFCERT_FTYP). This parameter is a key value for the EFFCERT_FTYP entity and must be provided.
MISSING_NTRECAQ_IDMissing mandatory Effort Certification Additional Queue Members ID for Effort Certification Member Fund Type.
The Effort Certification Additional Queue Members ID parameter was omitted when calling a function or procedure in the Effort Certification Member Fund Type API (NB_EFFCERT_FTYP). This parameter is a key value for the EFFCERT_FTYP entity and must be provided.
MISSING_PARENTNo Effort Certification Additional Queue Members record exists for Effort Certification Member Fund Type.
An attempt was made to create a EFFCERT_FTYP record, but no parent record with these key values could be found.
P_DELETE_FAILEDCannot delete Effort Certification Member Fund Type, record does not exist.
An attempt was made to delete a EFFCERT_FTYP record, but a record with these key values (or ROWID) could not be found.
RECORD_EXISTSCannot create Effort Certification Member Fund Type, record already exists.
An attempt was made to create a new EFFCERT_FTYP 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.