Search Results xnp_sync_err_u




Overview
Explore in AI Chat

Overview

The APPS.XNP_SYNC_ERR_U package is a PL/SQL error-handling and messaging utility within the Oracle E-Business Suite Advanced Supply Chain Planning and Collaborative Planning messaging infrastructure, which is built on the XNP (XML Network Protocol) messaging framework. The package is declared with AUTHID CURRENT_USER, indicating that its SQL and PL/SQL execute under the privileges of the calling user rather than the package owner. Its business function is to generate, publish, and send standardized "SYNC_ERR" message notifications whenever a synchronization or message-processing operation encounters an error condition. In effect, this package provides the canonical mechanism by which the XNP messaging layer reports failure and status back to trading partners, internal processes, or the exception queue.

Key Procedures and Functions

  • CREATE_MSG — Constructs the SYNC_ERR message payload. It accepts a SYNC label and an optional SDP result code, and returns an output message header record plus the message text and error code/message. Optional parameters support versioning, sender/recipient metadata, reference identifiers, and scheduling attributes such as delay and interval.
  • PUBLISH — Publishes a SYNC_ERR message to the XNP messaging queue, returning an output message identifier along with error code and error message. It supports a consumer list, sender name, recipient list, and versioning.
  • SEND — Delivers a SYNC_ERR message to a specified consumer (with optional sender and recipient names, version, and reference identifier), returning the message identifier and error outputs.
  • PROCESS — Handles the processing of an incoming or queued SYNC_ERR message within the messaging pipeline.
  • DEFAULT_PROCESS — Provides the default processing path for SYNC_ERR messages when no specialized handler applies.
  • VALIDATE — Validates the SYNC_ERR message structure and content prior to or during processing.

Tables Accessed

The package's documented references include the Oracle Advanced Queuing package DBMS_AQ (exposed via an APPS synonym), which is the enqueue/dequeue engine underlying the PUBLISH, SEND, and PROCESS operations. No base application tables are explicitly documented in the metadata excerpt; the message header type is drawn from XNP_MESSAGE.MSG_HEADER_REC_TYPE, a shared record type in the XNP message utility package.

Usage Notes

XNP_SYNC_ERR_U is typically invoked by XNP messaging routines, collaborative planning synchronization processes, and any custom or standard code that must emit a SYNC_ERR notification upon synchronization failure. The metadata indicates it is referenced by one other package within the EBS schema, consistent with its role as a low-level messaging utility rather than an end-user-facing API. In EBS 12.1.1 and 12.2.2, such packages are generally called from concurrent programs or internal PL/SQL messaging handlers rather than directly from forms. Because the package runs with AUTHID CURRENT_USER, callers must hold the appropriate execution privileges, and integration code should surface the returned error code and message for diagnostic purposes. The header comment references XNPSYERS.pls, version 120.1, dated 2005.