Search Results update_error_count

Overview

XDP_ERRORS_PKG is an internal PL/SQL package owned by the APPS schema that provides the centralized error-handling and message-management facility for Oracle E-Business Suite's XDP (eCommerce/Order Capture and related transaction processing) module stack. It serves as the shared error repository used across the XDP framework, including components such as XDP_ENGINE, XDP_ADAPTER, XDP_ADAPTER_CORE_DB, XDPCORE_ERROR, XDP_DRC_UTIL_PVT, and XDP_ORDER_SYNC. Rather than allowing each XDP component to manage its own error strings and counts, the framework routes message storage, retrieval, and error-frequency tracking through this single package, ensuring consistent diagnostics across order synchronization, adapter processing, and engine execution. In Oracle EBS 12.1.1 and 12.2.2, the package is documented as VALID and classified as an OTHER API type, indicating it is not part of the formally published public API surface but is relied upon internally throughout the XDP codebase.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions within this package:

• SET_MESSAGE — Records or updates an error or informational message associated with XDP processing, establishing the message text held for subsequent retrieval.
• SET_MESSAGE_AUTO — An automated variant of message setting, used where the framework populates message content programmatically without an explicitly supplied message text.
• LOG_WF_ERROR — Logs an error originating from Workflow-integrated processing, bridging XDP error capture with Oracle Workflow notification and diagnostic channels.
• GET_LAST_MESSAGE — Returns the most recently stored message, allowing callers to surface the immediate failure reason after an operation.
• GET_MESSAGE — Retrieves a stored message, providing the general access point for reading message content recorded by the SET_MESSAGE routines.
• UPDATE_ERROR_COUNT — Increments or adjusts the tracked occurrence count for a given error, supporting threshold and recurrence analysis.
• GET_ERROR_COUNT — Returns the current accumulated count for an error, enabling callers to detect repeated failures or enforce retry limits.

No parameter lists are documented in the ETRM extract; the descriptions above reflect the documented purpose of each routine only.

Tables Accessed

The package operates against three documented tables, referenced through APPS synonyms:

• XDP_ERRORS_S — The sequence or error-definition structure supporting generation of error identifiers used when messages and counts are recorded.
• XDP_ERROR_COUNT — Persists the running occurrence totals manipulated by UPDATE_ERROR_COUNT and read by GET_ERROR_COUNT.
• XDP_ERROR_LOG — The primary error log table into which XDP failures, messages, and workflow-related errors are written by the SET_MESSAGE and LOG_WF_ERROR routines, and from which GET_MESSAGE and GET_LAST_MESSAGE retrieve data.

Usage Notes

XDP_ERRORS_PKG is invoked internally rather than directly by end users. Its documented dependents — XDPCORE_ERROR, XDP_ADAPTER, XDP_ADAPTER_CORE_DB, XDP_DRC_UTIL_PVT, XDP_ENGINE, XDP_ORDER_SYNC, and XDP_ERRORS_PKG itself — call it whenever an XDP process must record, retrieve, or count an error. The package also supports the XDP_ERROR_LOG_V view, which exposes logged errors for querying and reporting. It depends only on SYS.STANDARD, requiring no other application schema objects. Because it is classified as OTHER and not a published API, customizations should treat it as a private framework utility: diagnostic forms, concurrent programs, and custom code should read the resulting error log through supported views rather than invoking this package directly, since its signature may change without notice across 12.1.1 and 12.2.2 patch levels.