index

Package sb_mass_entry_strings

This package contains the error messages and error message functions for the Mass Entry API (sb_mass_entry).

Message NameError Message
INVALID_ADD_DATEInvalid date for the mass entry (SORMAUD).
Add date for the mass entry is not valid.
INVALID_ADD_USER_IDInvalid initiating user ID for the mass entry (SORMAUD).
ID of the initiating user for the mass entry is not valid.
INVALID_DATA_ORIGINInvalid data origin for the mass entry (SORMAUD).
Data origin for the mass entry is not valid.
INVALID_FORM_NAMEInvalid form name for the mass entry (SORMAUD).
Form name for the mass entry is not valid.
INVALID_HOLD_CDEInvalid hold indicator for the mass entry (SORMAUD).
Hold indicator for the mass entry is not valid.
INVALID_KEY_SEQNO Invalid key sequence number for the mass entry (SORMAUD).
Key sequence number for the mass entry is not valid.
INVALID_KEY_TEXTInvalid key text for the mass entry (SORMAUD).
Key text for the mass entry is not valid.
INVALID_MANUAL_ADD_IND Invalid manual add indicator for the mass entry (SORMAUD).
Manual add indicatorfor the mass entry is not valid.
INVALID_MSGInvalid message for the mass entry (SORMAUD).
Message for the mass entry is not valid.
INVALID_PIDMInvalid unique identifier (PIDM) for the mass entry (SORMAUD).
Unique identifier (PIDM) for the mass entry is not valid.
INVALID_PROCESS_INDInvalid process indicator for the mass entry (SORMAUD).
Process indicator for the mass entry is not valid.
INVALID_SEQNOInvalid sequence number for the mass entry (SORMAUD).
Sequence number for the mass entry is not valid.
INVALID_TERM_CODEInvalid term code for the mass entry (SORMAUD).
Term code for the mass entry is not valid.
INVALID_UPDATE_CDEInvalid update code for the mass entry (SORMAUD).
Update code for the mass entry is not valid.
INVALID_USER_IDInvalid user ID for the mass entry (SORMAUD).
User ID for the mass entry is not valid.
MISSING_ADD_DATEAdd date is missing from the mass entry (SORMAUD).
Add date is missing. This field is required by the mass entry.
MISSING_ADD_USER_IDID of the initiating user is missing from the mass entry (SORMAUD).
ID of the initiating user is missing. This field is required by the mass entry.
MISSING_DATA_ORIGINData origin is missing from the mass entry (SORMAUD).
Data origin is missing. This field is required by the mass entry.
MISSING_FORM_NAMEForm name is missing from the mass entry (SORMAUD).
Form name is missing. This field is required by the mass entry.
MISSING_MANUAL_ADD_IND Manual add indicator is missing from the mass entry (SORMAUD).
Manual add indicator is missing. This field is required by the mass entry.
MISSING_PARENTParent record not found for the mass entry (SORMAUD).
Required SOBMAUD record not found for the mass entry.
MISSING_PIDMUnique identifier (PIDM) is missing from the mass entry (SORMAUD).
Unique identifier (PIDM) is missing. This field is required by the mass entry.
MISSING_PROCESS_INDProcess indicator is missing from the mass entry (SORMAUD).
Process indicator is missing. This field is required by the mass entry.
MISSING_SEQNO Sequence number is missing from the mass entry (SORMAUD).
Sequence number is missing. This field is required by the mass entry.
MISSING_UPDATE_CDEUpdate code is missing from the mass entry (SORMAUD).
Update code is missing. This field is required by the mass entry.
MISSING_USER_IDUser ID is missing from the mass entry (SORMAUD).
User ID is missing. This field is required by the mass entry.
PK_NOT_FOUNDCannot find record using primary or unique key for the mass entry (SORMAUD).
Cannot find record using primary or unique key for the mass entry.
P_DELETE_FAILEDCannot delete the record because it does not exist.
Cannot delete the record because it does not exist.
RECORD_EXISTSThe record cannot be created because it already exists.
The record cannot be created because it 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.