Package sb_mass_entry_column

Package sb_mass_entry_column_strings

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

Message Name	Error Message
INVALID_ADD_DATE	Invalid date for the mass entry column (SORMECL).
Add date for the mass entry column is not valid.
INVALID_ADD_USER_ID	Invalid initiating user ID for the mass entry column (SORMECL).
ID of the initiating user for the mass entry column is not valid.
INVALID_DATA_ORIGIN	Invalid data origin for the mass entry column (SORMECL).
Data origin for the mass entry column is not valid.
INVALID_FORM_NAME	Invalid from name for the mass entry column (SORMECL).
Form name for the mass entry column is not valid.
INVALID_MECL_CODE	Invalid column name for the mass entry column (SORMECL).
Column name for the mass entry column is not valid.
INVALID_SEARCH_UPDATE_CDE	Invalid search update code for the mass entry column (SORMECL).
Search update code for the mass entry column is not valid.
INVALID_USER_ID	Invalid user ID for the mass entry column (SORMECL).
User ID for the mass entry column is not valid.
MISSING_ADD_DATE	Add date is missing from the mass entry (SORMECL).
Add date is missing. This field is required for the mass entry column.
MISSING_ADD_USER_ID	Initiating user ID is missing from the mass entry (SORMECL).
ID of the initiating user is missing. This field is required for the mass entry column.
MISSING_DATA_ORIGIN	Data origin is missing from the mass entry (SORMECL).
Data origin is missing. This field is required for the mass entry column.
MISSING_FORM_NAME	Form name is missing from the mass entry (SORMECL).
Form name is missing. This field is required for the mass entry column.
MISSING_MECL_CODE	Column name is missing from the mass entry (SORMECL).
Column name is missing. This field is required for the mass entry column.
MISSING_PARENT	Parent record not found for the mass entry (SORMECL).
Required SOBMAUD record not found for mass entry column.
MISSING_SEARCH_UPDATE_CDE	Update code is missing from the mass entry (SORMECL).
Search update code is missing. This field is required for the mass entry column.
MISSING_USER_ID	User ID is missing from the mass entry (SORMECL).
User ID is missing. This field is required for the mass entry column.
PK_NOT_FOUND	Cannot find record using primary or unique key for the mass entry (SORMECL).
Cannot find the record using the primary or unique key for the mass entry column.
P_DELETE_FAILED	Cannot delete the record because it does not exist.
Cannot delete the record because it does not exist.
RECORD_EXISTS	The record cannot be created because it already exists.
The records 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.