Search Results mark_header_error

Overview

The APPS.OE_BULK_PRICE_PVT package body is an internal (private) PL/SQL API belonging to the Oracle Order Management bulk import pricing infrastructure in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It supports the bulk order import flow by applying pricing and price adjustment logic to large batches of order headers and lines staged in the Order Management interface tables. Because it is classified as a private (PVT) API, it is not intended for direct invocation by external or customer-developed code; it is called internally by the public APIs and concurrent programs that orchestrate bulk import and order pricing.

The package's responsibilities center on three areas: inserting manual price adjustments for a batch prior to pricing, pricing orders assembled in memory, and updating pricing-related attributes on order data. The documented mark_header_error procedure, referenced in the package header, indicates that the package participates in error handling for bulk order headers during import and pricing.

Key Procedures and Functions

The ETRM documentation records three procedures or functions exposed by this package:

• INSERT_ADJUSTMENTS — Inserts manual price adjustments for a bulk import batch, moving adjustment data from the interface tables into OE_PRICE_ADJUSTMENTS. The documented guidance states this API should be called before PRICE_ORDERS to ensure manual adjustments are applied when the order is priced. It returns a return status via x_return_status.
• PRICE_ORDERS — Performs the pricing of orders for the bulk import batch, applying pricing engine logic against order headers and lines. It is intended to execute after INSERT_ADJUSTMENTS so that manual adjustments are in place.
• UPDATE_PRICING_ATTRIBUTES — Updates pricing-related attributes on the order data used during bulk import.

The package also declares internal helpers, including mark_header_error, which records an error against a specific header record by index and header record, and Booking_Failed, which handles booking failures. These are private and support the error-tracking behavior of the bulk flow.

Tables Accessed

The package reads from and writes to several core Order Management and Advanced Pricing tables through APPS synonyms:

• OE_PRICE_ADJUSTMENTS and OE_PRICE_ADJUSTMENTS_S, plus the interface table OE_PRICE_ADJS_IFACE_ALL, which are the source and target of the INSERT_ADJUSTMENTS logic.
• OE_ORDER_HEADERS and OE_ORDER_HEADERS_ALL, together with OE_ORDER_LINES and OE_ORDER_LINES_ALL, which hold the order data being priced and updated.
• QP_LIST_HEADERS, QP_LIST_LINES, and PLITBLM, which belong to the Advanced Pricing modifier and list infrastructure used to validate and apply adjustments.
• ONT_DBI_CHANGE_LOG, used for change logging and downstream reporting or analytics integration.

Usage Notes

OE_BULK_PRICE_PVT is invoked indirectly. It is referenced by two other packages and is typically driven by the bulk order import pricing concurrent programs and the public Order Management APIs rather than called directly from forms. Releases 12.1.1 and 12.2.2 preserve the documented interface. Customizations should not call this private package directly; instead, call the public pricing and import APIs that internally invoke INSERT_ADJUSTMENTS and PRICE_ORDERS in the required sequence.