Search Results fte_prc_dlv_inv_act

Overview

The APPS.FTE_DELIVERY_PUB package body is a public application programming interface (API) belonging to Oracle's Freight and Transportation Execution (FTE) module, part of the Oracle Transportation Management integration delivered with Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to allow external callers — other Oracle applications, forms, or custom PL/SQL code — to request freight rating for a delivery without directly coupling to the underlying freight rating engine. Freight rating is the process of determining the applicable transportation charges for a shipment by evaluating carrier, mode of transport, service level, and related routing attributes against the carrier's rate agreements. The _PUB suffix designates this as a published, callable-only API layer, meaning the package exposes a stable interface and encapsulates the internal logic within the freight rating delivery processing group.

Key Procedures and Functions

• Rate_Delivery — The single documented procedure in this package. It serves as the public entry point for submitting a delivery for freight rating. Internally it validates the caller's API version compatibility through the standard FND_API.Compatible_API_Call mechanism, optionally initializes the message stack when requested, and inspects the supplied action code. When the action code equals 'RATE', it maps the inbound delivery record attributes (name, carrier, mode of transport, and service level) into the internal record type and delegates the actual computation to FTE_FREIGHT_RATING_DLVY_GRP.Rate_Delivery2. If any step returns a status other than success, or if an unrecognized action code is passed, the procedure raises the appropriate API exception and surfaces error messages to the caller. The procedure therefore acts as a thin but standardized wrapper that enforces EBS API conventions of version checking, message handling, and error propagation.

Tables Accessed

The ETRM metadata documents no direct table references through APPS synonyms for this package. This is consistent with its design as a delegating API: the substantive read and write operations against freight rating and delivery tables occur inside FTE_FREIGHT_RATING_DLVY_GRP, which Rate_Delivery invokes. Custom implementations should therefore treat this package as an orchestrator rather than assuming it directly queries or updates any specific FTE base tables.

Usage Notes

This package is intended for programmatic invocation rather than direct end-user interaction. Typical callers include FTE forms, concurrent programs, and custom extensions that need to trigger freight rating for a delivery as part of an order, shipment, or delivery workflow. Because the package follows the documented PL/SQL API standard, callers must supply a compatible p_api_version, manage the optional message list initialization, inspect x_return_status after execution, and retrieve error messages via the standard message count/data outputs. The p_action_code parameter governs behavior, with 'RATE' as the supported action; unsupported values raise an error using message FTE_PRC_DLV_INV_ACT. The metadata indicates this package is referenced by zero other packages, confirming it is a terminal public interface rather than an internal dependency, and it should be called only after the required delivery attributes have been populated.