Search Results oe_cncl_validate_header




Overview
Explore in AI Chat

Overview

OE_CNCL_VALIDATE_HEADER is an Oracle E-Business Suite package body owned by the APPS schema and classified under the OTHER API category. It participates in the Order Management cancellation validation framework, providing server-side validation logic that determines whether an order header is eligible for cancellation before the cancellation request is processed. The package operates in conjunction with OE_CNCL_VALIDATE, OE_ORDER_PUB, and OE_ORDER_UTIL, forming a layered validation architecture in which header-level checks are separated from line-level checks. In Oracle EBS 12.1.1 and 12.2.2, the Order Management cancellation flow invokes this validation logic to enforce business rules around open orders, booked status, purchasing dependencies, and customer relationships, ensuring that only cancellable orders proceed to the cancellation transaction. The package relies on the FND_API framework for standardized message handling and on OE_MSG_PUB and FND_MESSAGE for seeded error and warning messages.

Key Procedures and Functions

The documented package exposes four procedures and functions:

  • CHECK_BOOK_REQD_ATTRIBUTES — Verifies that attributes required for booking-related validation are present and consistent on the order header. This check supports the rule that an order cannot be cancelled if mandatory booking attributes would be invalidated or are incomplete, returning validation results to the calling cancellation logic.
  • IS_DUPLICATE_PO_NUMBER — Evaluates whether the customer purchase order number on the header duplicates an existing value according to Order Management configuration. This function supports duplicate PO validation rules controlled through OE_SYS_PARAMETERS, preventing cancellation or cancellation reversal when duplicate PO handling would be inconsistent.
  • ENTITY — Returns or resolves the entity identifier associated with the header validation context. This function is used by the broader validation framework, including OE_CNCL_VALIDATE, to identify the business object instance under validation, typically the order header.
  • ATTRIBUTES — Retrieves or evaluates the set of header attributes relevant to cancellation validation. The results feed downstream checks that determine whether the header state permits cancellation.

These routines collectively supply header-level facts consumed by OE_CNCL_VALIDATE, which orchestrates the complete cancellation validation sequence.

Tables Accessed

The package references core Order Management and Trading Community Architecture tables through APPS synonyms:

Views such as OE_DELIVER_TO_ORGS_V, OE_INVOICE_TO_ORGS_V, OE_SHIP_TO_ORGS_V, OE_ORDER_TYPES_V, OE_AGREEMENTS_V, QP_LIST_HEADERS_VL, and ZX_EXEMPTIONS_V are also referenced, along with OE_SYS_PARAMETERS for profile-driven rule configuration, OE_ORDER_CACHE for performance, and OE_DEBUG_PUB for diagnostic output.

Usage Notes

OE_CNCL_VALIDATE_HEADER is not referenced by any database object directly; instead, it is invoked programmatically by the Order Management cancellation flow and is referenced by two other packages, including OE_CNCL_VALIDATE. Typical invocation paths include the Order Organizer and Sales Orders forms when a user selects Cancel, the Order Management concurrent programs that process mass cancellation, and custom PL/SQL extensions that call OE_ORDER_PUB or OE_CNCL_VALIDATE. Because validation depends on FND_API message stacking, callers should inspect the returned validation status and retrieve messages through OE_MSG_PUB or FND_MESSAGE rather than assuming success. Customizations should never modify this package body; extensions should wrap it or call the public OE_ORDER_PUB cancellation APIs to preserve upgrade safety across 12.1.1 and 12.2.2.