Search Results validate_freight_carrier




Overview
Explore in AI Chat

Overview

POS_CREATE_ASN is a PL/SQL package owned by the APPS schema that supports the Advance Shipment Notice (ASN) creation process within the Oracle E-Business Suite Procurement and Receiving modules. Its primary business function is to construct, validate, and stage ASN data — header and transaction records — for inbound shipments so that receiving can be processed against expected deliveries. The package operates as the logical bridge between the purchasing side of the application (purchase orders, distributions, shipments, freight terms) and the receiving open interface, allowing ASN information supplied by suppliers or internal users to be validated and written into the RCV interface tables for subsequent submission to the receiving transaction processor. In the ETRM 12.2.2 metadata, POS_CREATE_ASN is classified as an OTHER API, confirming its role as a supporting utility package rather than a formally published open interface.

Key Procedures and Functions

The documented package exposes seven procedures and functions:

  • CREATE_ASN_IFACE — The principal routine for building ASN interface records, populating header and transaction staging data for onward processing by the receiving open interface.
  • GETAVAILABLESHIPMENTQUANTITY — Retrieves the quantity still available to be shipped on a given shipment or line.
  • GETTOLERABLESHIPMENTQUANTITY — Returns the shippable quantity after applying receiving tolerances, supporting over- and under-shipment validation.
  • GETSHIPMENTQUANTITY — Returns the shipment quantity associated with a shipment line.
  • GETCONVERTEDQUANTITY — Supplies unit-of-measure conversion of a quantity between the shipment UOM and the destination UOM.
  • CALLPREPROCESSOR — Invokes preprocessing logic required before ASN interface population, ensuring business rules are applied to the staged data.
  • VALIDATE_FREIGHT_CARRIER — Validates the freight carrier supplied on an ASN against valid carrier and freight-term definitions.

Tables Accessed

The package reads and writes a defined set of applications tables. Purchasing data is sourced from PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS and PO_DISTRIBUTIONS_ALL, which supply the order, shipment, and distribution context required to derive shippable quantities. PO_LOCATION_ASSOCIATIONS, HR_LOCATIONS_ALL, ORG_FREIGHT and PO_DOC_STYLE_HEADERS provide location, freight, and document style validation data used by the freight carrier and preprocessor routines. Receiving staging is performed through RCV_HEADERS_INTERFACE, RCV_HEADERS_INTERFACE_S, RCV_TRANSACTIONS_INTERFACE and RCV_TRANSACTIONS_INTERFACE_S, where ASN header and transaction rows are inserted for later processing by the receiving open interface concurrent program. DUAL is used for single-row scalar computations. The package references the STANDARD package, reflecting standard PL/SQL runtime dependencies.

Usage Notes

POS_CREATE_ASN is typically invoked indirectly. The ETRM dependency data shows it is referenced by POS_ASN_XML and POS_EXCELASN_PVT, indicating that ASN submission via the XML supplier-facing interfaces and the Excel-based ASN upload utility both rely on this package to validate and stage data. Direct invocation is normally reserved for the ASN creation flows within the Purchasing and Receiving responsibility, where the concurrent receiving processing consumes the populated RCV interface tables. Because the package is classified as an OTHER API, it is not part of the documented public open interface set; custom code invoking its routines directly should be treated as an extension that must be re-verified during upgrades from 12.1.1 to 12.2.2, since internal procedure signatures and validation logic are not guaranteed to remain backward compatible.