index

Package nb_redistr_ftyp_strings

This package contains the error messages and error message functions for the Labor Redistribution Member Fund Type API (NB_REDISTR_FTYP).
 

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