Search Results g_not_eligible_for_ltl

Overview

FTE_FREIGHT_PRICING_UTIL is a utility PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the Oracle Freight and Transportation Execution (FTE) module, part of the broader Oracle Transportation Management and Logistics suite. Its role is to provide shared, low-level building blocks used by freight pricing and rating logic — resolving pricing events, applying base prices, managing weight and volume breaks, assembling pricing qualifiers, and writing debug and diagnostic output. The package is classified as a UTIL (utility) API, meaning it is not a public, user-facing interface but rather an internal support library consumed by other freight pricing packages. It is referenced by twelve other packages, confirming its position as a common dependency in the freight rating stack. The public specification declares a large set of named global exceptions, ranging from parameter and UOM handling errors (G_NO_PARAMS_FOUND, G_INVALID_UOM_CODE, G_INVALID_UOM_CONVERSION) to pricing- and QP-interface failures (G_QP_PRICE_REQUEST_FAILED, G_APPLY_NEW_BASE_PRICE_FAILED, G_ADD_QP_OUTPUT_DETAIL_FAILED) and eligibility checks (G_NOT_ELIGIBLE_FOR_LTL, G_PARCEL_NOT_ELIGIBLE). These exceptions are raised by the utility routines and propagated to the calling packages, which handle them and produce meaningful application feedback.

Key Procedures and Functions

The documented API comprises twenty-nine procedures and functions. The debug and logging family includes RESET_DBG_VARS, which reinitializes the package-level debug globals; SET_DEBUG_ON and SET_DEBUG_OFF, which control general debug tracing; SET_QP_DEBUG_ON and SET_QP_DEBUG_OFF, which specifically toggle Oracle Pricing (QP) debug output; PRINT_DEBUG, PRINT_MSG, and PRINT_TAG, which emit formatted diagnostic text; FLUSH_LOGS and CLOSE_LOGS, which manage buffered log files; INITIALIZE_LOGGING, which establishes the logging session; and GET_LOG_FILE_NAME, which returns the active log file name (backed by UTL_FILE). The runtime-call-context family includes SET_METHOD, UNSET_METHOD, SET_LOCATION, SET_EXIT_EXCEPTION, and SET_EXCEPTION, used to record the caller's method name, location, and the exception to be raised on error. Utility conversion routines COM MA_TO_TABLE and COMMA_TO_NUMBER_TABLE parse delimited strings into PL/SQL collections. GET_LOOKUP_MEANING resolves a lookup code to its descriptive meaning from FND_LOOKUP_VALUES.

Tables Accessed

Through APPS synonyms the package reads and writes several data dictionary and transactional objects. FTE_PRC_DEBUG_S stores freight pricing debug settings and is the primary table toggled by SET_QP_DEBUG_ON and SET_QP_DEBUG_OFF. FND_LOOKUP_TYPES and FND_LOOKUP_VALUES supply lookup validation and meaning resolution. FTE_LANES provides lane definitions used in pricing qualification. HZ_PARTIES supplies trading-partner attributes for qualifier construction. WSH_CARRIERS, WSH_NEW_DELIVERIES, and WSH_TRIPS provide carrier, delivery, and trip context for shipment-based rating. QP_LIST_HEADERS references Oracle Advanced Pricing price lists during pricing-event setup. PLITBLM and DUAL are used for generic parsing and single-row selection, while DBMS_UTILITY and UTL_FILE are invoked for string handling and file I/O.

Usage Notes

FTE_FREIGHT_PRICING_UTIL is invoked indirectly rather than through a form or concurrent program. Shipping and freight pricing screens in Oracle Shipping Execution, and the rating concurrent programs, call higher-level freight pricing packages that in turn depend on this utility. The most common searchable entry point is SET_QP_DEBUG_OFF, used to disable Oracle Pricing debug tracing after diagnosis, paired with SET_QP_DEBUG_ON to enable it. Debug state is persisted in FTE_PRC_DEBUG_S. Because the package is internal, customizations should not call it directly where a supported API exists; integrators typically invoke it only to control diagnostic logging or to reuse the comma-parsing helpers. Behavior is consistent across 12.1.1 and 12.2.2, as the header indicates the source has been stable since the 11i-era 2005 revision.