index

Package sb_mass_entry_form_strings

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

Message NameError Message
INVALID_ADD_DATEInvalid date on the mass entry form (SOBMAUD).
Add date for the mass entry form is not valid.
INVALID_ADD_USER_IDInvalid initiating user ID on the mass entry form (SOBMAUD).
ID of the initiating user  for the mass entry form is not valid.
INVALID_COMPLETION_DATEInvalid completion date on the mass entry form (SOBMAUD).
Completion date for the mass entry form is not valid.
INVALID_DATA_ORIGINData origin on the mass entry form (SOBMAUD).
Data origin for the mass entry form is not valid.
INVALID_FORM_NAMEInvalid form name on the mass entry form (SOBMAUD).
Form name for the mass entry form is not valid.
INVALID_JOB_NAMEInvalid job name on the mass entry form (SOBMAUD).
Job name for the mass entry form is not valid.
INVALID_USER_IDInvalid user ID on the mass entry form (SOBMAUD).
User ID for the mass entry form is not valid.
MISSING_ADD_DATEAdd date is missing from the mass entry form (SOBMAUD).
Add date is missing. This field is required by the mass entry form.
MISSING_ADD_USER_IDID of the initiating user is missing from the mass entry form (SOBMAUD).
ID of the initiating user is missing. This field is required by the mass entry form.
MISSING_DATA_ORIGINAdd date is missing from the mass entry form (SOBMAUD).
Data origin is missing. This field is required by the mass entry form.
MISSING_FORM_NAMEForm name is missing from the mass entry form (SOBMAUD).
Form name is missing. This field is required by the mass entry form.
MISSING_USER_IDID of the user is missing from the mass entry form (SOBMAUD).
User ID is missing. This field is required by the mass entry form.
PK_NOT_FOUNDCannot find record using primary or unique key for the mass entry form (SOBMAUD).
Cannot find the record using primary or unique key for the mass entry form.
P_DELETE_FAILEDCannot delete the record because it does not exist.
Cannot delete the record because the record 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.