index

Package sb_registration_msg_strings

Error messages and error message functions for the Registration Error Messages API (sb_registration_msg).

Message KeyError Message
MISSING_CDEMessage code is missing
Message code is missing. This field is required.
MISSING_SEQNOSequence number is missing
Sequence number is missing. This field is required.
MISSING_SYS_REQ_INDSystem required indicator is missing
System required indicator is missing. This field is required.
MISSING_DATA_ORIGINData origin is missing
Data origin is missing. This field is required.
MISSING_USER_IDUser ID is missing
User ID is missing. This field is required.
INVALID_CDEMessage code is not valid
Message code is not valid.
INVALID_SEQNOSequence number is not valid
Sequence number is not valid.
INVALID_SYS_REQ_INDSystem required indicator is not valid
System required indicator is not valid.
INVALID_DATA_ORIGINData origin is not valid
Data origin is not valid.
INVALID_USER_IDUser ID is not valid
User ID is not valid.
INVALID_MESSAGEMessage text is not valid
Message text is not valid.
INVALID_UPDATEMessage text cannot be updated for a system required record
Message text cannot be updated for a system required record.
INVALID_LOCAL_MESSAGELocal message text is not valid
Locally defined message text is not valid.
P_DELETE_FAILEDDelete failed, record not found
Cannot delete the message text record because it does not exist.
PK_NOT_FOUNDRecord not found
Cannot find the message text record using the primary or unique key.
RECORD_EXISTSRecord already exists
Cannot create the message text record because it already exists.
UPDATE_EXISTSCannot update, record already exists
Cannot update the message text record because it already exists.
RECORD_REQUIREDCannot delete a system required record
Cannot delete a system required record.

Program units
f_get_error  

Variables
error_tab  

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.