Package sb_compliance_xml

Package sb_compliance_xml_strings

This package contains the error messages and error message functions for the Compliance XML API (sb_compliance_xml).

Message Key	Error Message
MISSING_PIDM	Unique identifier (PIDM) is required for the compliance XML record and cannot be null.
PIDM is missing and is required for the compliance XML record.
MISSING_REQUEST_NO	Request number is required for the compliance XML record and cannot be null.
Request number is missing and is required for the compliance XML record.
MISSING_SESSIONID	Session ID is required for the compliance XML record and cannot be null.
Session ID is missing and is required for the compliance XML record.
MISSING_USER_ID	User ID is required for the compliance XML record and cannot be null.
User ID is missing and is required for the compliance XML record.
INVALID_PIDM	Unique identifier (PIDM) for the compliance XML record must be valid.
PIDM is invalid and cannot be used for the compliance XML record.
INVALID_REQUEST_NO	Request number for the compliance XML record must be valid.
Request number is invalid and cannot be used for the compliance XML record.
INVALID_SESSIONID	Session ID for the compliance XML record must be valid.
Session ID is invalid and cannot be used for the compliance XML record.
INVALID_USER_ID	User ID for the compliance XML record must be valid.
User ID is invalid and cannot be used for the compliance XML record.
INVALID_DATA_ORIGIN	Data origin for the compliance XML record must be valid.
Data origin is invalid and cannot be used for the compliance XML record.
INVALID_PROC_SESSIONID	Process session ID for the compliance XML record must be valid.
Process session ID is invalid and cannot be used for the compliance XML record.
INVALID_XML	XML for the compliance XML record must be valid.
XML is invalid and cannot be used for the compliance XML record.
P_DELETE_FAILED	Cannot delete the compliance XML record because it does not exist.
The compliance XML record cannot be deleted because it does not exist in the database.
PK_NOT_FOUND	Cannot find the compliance XML record using the primary or unique key.
The compliance XML record cannot be found in the database using the primary or unique key.
RECORD_EXISTS	Compliance XML record cannot be created because the record already exists.
The compliance XML record cannot be created because the record already exists in the database.

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.