Search Results dbms_debug




Overview
Explore in AI Chat

Overview

ONT_FREIGHT_UTIL is a utility package body owned by APPS in the Oracle E-Business Suite Order Management (ONT) module. As classified by ETRM (API classification: UTIL), it is an internal helper package rather than a public application programming interface. Its principal business function is to support freight and pricing diagnostics for order lines — resolving the pricing qualifiers, price lists, list lines, phases, and adjustments that determine how freight charges are calculated and applied to sales order lines and delivery details. The package is oriented toward debugging and inspecting the freight/pricing determination path rather than executing an end-user business transaction. The header comment block identifies the source file as OEXUFDBB.pls, a versioned member of the Order Management freight utility family.

Key Procedures and Functions

ETRM documents a single procedure for this package: FREIGHT_DEBUG. It accepts a header name, an optional list line identifier, and a line identifier, and reports freight-related pricing detail for the referenced order or price list context. The procedure declares private cursors that query list header and list line information (list_header_id, list_line_id, list_line_type_code, effective dates, modifier level, pricing phase, incompatibility group, price break type, operand, automatic flag, arithmetic operator, qualification indicator, product precedence, and price-by-formula identifier) by joining the price list header and list line views. It uses these cursors to trace how a freight modifier was qualified and priced.

The package body also contains an internal debug output routine named dbms_debug, a private helper that writes diagnostic text in fixed-width chunks of 80 characters. Though not part of the documented API surface, its presence explains why a search for "dbms_debug" surfaces this object. The routine builds dynamic PL/SQL statements that invoke dbms_output.put_line, escaping embedded single quotes, and traps all exceptions silently. It is important to note that this is a locally defined procedure that merely shares the name of the Oracle server package DBMS_DEBUG; it is not a call to that package.

Tables Accessed

The documented tables accessed through APPS synonyms include OE_ORDER_LINES_ALL and OE_PRICE_ADJUSTMENTS, which supply order line attributes and the freight price adjustments applied to those lines; WSH_DELIVERY_DETAILS, which links order lines to shipment detail; and the pricing schema tables QP_LIST_LINES, QP_LIST_HEADER_PHASES, QP_PRICING_PHASES, QP_EVENT_PHASES, QP_QUALIFIERS, QP_PRICING_ATTRIBUTES, and QP_PRICE_FORMULA_LINES, which together define qualifiers, phases, and formula-driven pricing for freight modifiers. The synonym PLITBLM corresponds to the PL/SQL integer table type used for list processing. The package reads these objects to assemble a diagnostic picture of freight qualification and pricing; the metadata does not indicate that it writes to any table.

Usage Notes

ONT_FREIGHT_UTIL is an internal diagnostic utility. It is typically invoked from custom PL/SQL or ad hoc scripts when investigating why a freight charge was or was not applied to an order line, rather than from a standard Order Management form or concurrent program. Because it is classified as a utility and is referenced by zero other packages, there is no supported public call path into it, and its procedures are not guaranteed to be stable across releases. The embedded dbms_debug helper relies on dbms_output, so a client must have server output enabled to observe results. Developers analyzing freight pricing in either 12.1.1 or 12.2.2 should treat this package as reference material and avoid depending on it in production customizations.