Search Results notify_fmc

Overview

XNP_DEF_JEOPARDY_LOGIC is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified by ETRM as an OTHER API. It belongs to the XNP family of objects, which supports the Oracle Transportation Management and Logistics execution functionality that integrates with Order Management via the XDP (Order Management) schema objects. The package encapsulates the jeopardy notification logic used when an order or shipment is at risk of missing a required delivery or pickup window. Its principal role is to initiate a workflow that notifies the Freight Management Coordinator (FMC) when a jeopardy condition is detected, allowing the coordinator to respond and to apply corrective action before the order falls out of compliance with its service commitment.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the package owner. The header comment block carries the source control identifier XNPJTMRS.pls, revision 120.0, dated 30 May 2005, indicating that the object has been stable since the early 11i releases and is carried forward largely unchanged into Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

ETRM documents a single procedure on this package:

• notify_fmc — The only documented member. It is designated as a Private API in the source header, whose stated purpose is to start a workflow that notifies the FMC. The workflow does not simply emit a message; it enters a wait state, holding for a response from an FMC user. The procedure accepts one parameter, p_msg_header, typed as XNP_MESSAGE.MSG_HEADER_REC_TYPE. This parameter carries the message header record that supplies the workflow context, including the message identifier and associated business document information needed to launch and correlate the notification. Because the procedure is private, it is not intended to be called directly from external customizations; it is invoked internally by the jeopardy processing logic within the XNP package family.

No other public procedures or functions are exposed by the documented interface of this package.

Tables Accessed

The documented table access for this package resolves through APPS synonyms to a single base object:

• XDP_ORDER_HEADERS — The order header table in the XDP (Order Management integration) schema. The jeopardy logic reads order header data to determine the order context for which the FMC notification workflow must be raised, and to populate the message header passed to notify_fmc. This linkage ties the jeopardy notification to the specific order whose service commitment is at risk.

Because the procedure receives a fully formed message header record as its parameter, direct table access within this module is minimal; the bulk of the data assembly is performed by the calling jeopardy logic, with XDP_ORDER_HEADERS providing the authoritative order-level reference.

Usage Notes

XNP_DEF_JEOPARDY_LOGIC is not offered as a general-purpose integration API. Its classification as OTHER and the private designation of notify_fmc indicate that it is an internal implementation package invoked by the broader XNP jeopardy monitoring infrastructure. ETRM records that it is referenced by one other package, confirming that its callers are sibling XNP modules rather than external code or concurrent program definitions.

In practice, the package is reached when a jeopardy evaluation routine determines that an order requires FMC intervention; the caller constructs the message header record and delegates the workflow launch to notify_fmc. Oracle does not document a formal public interface, and no standard concurrent program or Oracle Forms screen invokes it directly. Customizations should therefore avoid calling this package explicitly and should instead trigger the supported XNP jeopardy processing, allowing the workflow notification and FMC response handling to proceed through Oracle-controlled code paths. This preserves upgrade safety across 12.1.1 and 12.2.2, where the package has remained unchanged.