Search Results api_post_call

Overview

FTE_FREIGHT_RATING_DLVY_GRP is the freight rating delivery grouping package within the Oracle E-Business Suite Freight and Transportation Execution (FTE) module. Its primary business function is to determine, calculate, and apply freight charges against delivery legs associated with outbound shipments. The package operates as a grouping (GRP) API, meaning it orchestrates a collection of related rating operations rather than exposing a single granular transaction. Within the ETRM 12.2.2 classification scheme it is owned by APPS and categorized as a GRP API, indicating it is intended for internal invocation by the freight rating engine and adjacent FTE components rather than direct end-user consumption.

The package operates against the core transportation tables of the Oracle Shipping Execution and Freight Execution schemas, reading trip, delivery leg, carrier, service, and freight cost data and writing rating results back to WSH_FREIGHT_COSTS. It supports the broader freight rating lifecycle: qualifying whether a delivery leg requires rating, evaluating carrier service eligibility, matching lanes and schedules, applying accessorial and base rate logic, and posting the resulting charges. The package also participates in the manifesting decision path, as evidenced by its explicit success and error return codes that distinguish reprice-not-required, non-rated freight terms, and non-rated manifesting scenarios.

Key Procedures and Functions

The documented interface exposes four entry points, all of which relate directly to the freight rating and rating-reversal workflow that a caller such as api_post_call would drive:

• RATE_DELIVERY — The primary rating routine. It evaluates a delivery and its associated delivery legs, determines whether rating is required, selects the applicable carrier service and lane, and invokes the rating engine to compute and persist freight charges for the delivery legs.
• RATE_DELIVERY2 — A companion or successor rating routine to RATE_DELIVERY, providing an alternate or extended invocation path for rating a delivery. It typically accommodates additional control parameters or a refined rating scenario without altering the base rating contract.
• CANCEL_SERVICE — Reverses or cancels a previously applied service rating. It is invoked when a delivery, trip, or carrier service assignment is cancelled or re-planned, ensuring that stale freight costs are removed or invalidated in WSH_FREIGHT_COSTS.
• API_POST_CALL — The post-processing entry point of the package. It is invoked at the tail end of the rating cycle to finalize results, reconcile status, and return the outcome code to the caller. This is the routine most closely associated with the "api_post_call" search term, as it serves as the terminal callback after the rating logic has executed.

The package also defines private constants and record/table types (dlv_leg_info_rec, trip_info_rec, lane_match_rec and their associated tables) used internally to stage delivery leg, trip, and lane match data during rating.

Tables Accessed

The package reads and writes a defined set of APPS synonyms, each serving a specific rating responsibility:

• WSH_DELIVERY_LEGS, WSH_DELIVERY_ASSIGNMENTS, WSH_NEW_DELIVERIES, WSH_DELIVERY_DETAILS — Source delivery structure and leg assignment data used to identify what requires rating.
• WSH_TRIPS, WSH_TRIP_STOPS — Trip and stop information used to derive lane, schedule, and consolidation context.
• WSH_CARRIERS, WSH_CARRIER_SERVICES, WSH_ORG_CARRIER_SERVICES — Carrier and service eligibility data used to select the applicable service and validate rating applicability.
• WSH_FREIGHT_COSTS — The destination table where computed freight charges are inserted, updated, or cancelled.
• WSH_GLOBAL_PARAMETERS — System-level configuration that governs rating and manifesting behavior.
• FTE_VEHICLE_TYPES, HZ_PARTIES, MTL_PARAMETERS — Supporting reference data for vehicle type, party (carrier) identity, and organization/parameter resolution.
• DBMS_UTILITY — Oracle-supplied utility package used for error formatting and diagnostic support.

Usage Notes

FTE_FREIGHT_RATING_DLVY_GRP is an internal grouping API and is not normally called directly from Oracle Forms. It is invoked by the FTE freight rating engine and related transportation execution processes, and the metadata records that it is referenced by three other packages. Customizations should follow the supported pattern: call the public rating and cancel routines, and rely on API_POST_CALL to receive the outcome code. Because the package writes directly to WSH_FREIGHT_COSTS, custom code must guard against duplicate rating and must honor the return codes (success, error, reprice-not-required, non-rated freight term, non-rated manifesting) to avoid inconsistent cost records. The presence of the header revision string 120.13 confirms the package is an established, versioned FTE component in the 12.1.1 and 12.2.2 code lines.