Search Results table_to_comma

Overview

FTE_FREIGHT_PRICING_UTIL is a utility package in the Oracle E-Business Suite freight and transportation execution (FTE) module. It encapsulates a reusable set of diagnostic, logging, and data-conversion helpers that support the wider freight pricing engine. Rather than exposing pricing rules directly, the package supplies the plumbing that other freight pricing programs invoke when they need structured debug output, consistent message handling, or delimited-string conversion. It is classified as a UTIL object in ETRM 12.2.2 and is owned by APPS.

The package maintains several global variables that control logging behavior, including a file handle for UTL_FILE output, a log-level threshold, and a count of messages pushed onto the FND message stack. A debug flag governs whether diagnostic output is emitted at all, so that production runs incur minimal overhead while development and troubleshooting sessions capture full trace detail.

Key Procedures and Functions

The 29 documented routines fall into distinct functional groups.

• Debug toggles: SET_DEBUG_ON, SET_DEBUG_OFF, SET_QP_DEBUG_ON, and SET_QP_DEBUG_OFF enable or suppress diagnostic output generally and for the Oracle Pricing (QP) layer specifically. RESET_DBG_VARS clears method, location, and exception context variables between calls.
• Logging output: PRINT_DEBUG, PRINT_MSG, and PRINT_TAG write diagnostic or tagged messages at a given log level. FLUSH_LOGS and CLOSE_LOGS manage buffered output and release the underlying file handle.
• Context tracking: SET_METHOD marks entry into a procedure or function, UNSET_METHOD marks exit, SET_LOCATION records the current code location, and SET_EXCEPTION / SET_EXIT_EXCEPTION record error context for later reporting.
• Initialization: INITIALIZE_LOGGING and GET_LOG_FILE_NAME establish the log file target and return its name, supporting the FTE_PRC_LOG message used by the package.
• Lookups: GET_LOOKUP_MEANING returns the meaning of a lookup value, used to translate coded values into readable text.
• Conversion utilities: COMMA_TO_TABLE and COMMA_TO_NUMBER_TABLE split a delimited string into a PL/SQL table or numeric table respectively. COMMA_TO_TABLE is the routine most often associated with the "table_to_comma" style search, since it performs the inverse of concatenating a collection into a comma-separated list.

Tables Accessed

The package reads setup and reference data through APPS synonyms. FND_LOOKUP_TYPES and FND_LOOKUP_VALUES back the GET_LOOKUP_MEANING helper. FTE_LANES, WSH_CARRIERS, WSH_NEW_DELIVERIES, WSH_TRIPS, HZ_PARTIES, and QP_LIST_HEADERS supply freight, carrier, delivery, trip, party, and pricing context used by callers. FTE_PRC_DEBUG_S holds debug settings. DUAL, PLITBLM, DBMS_UTILITY, and UTL_FILE provide infrastructure for row generation, splitting, and file output.

Usage Notes

The package is referenced by twelve other packages, indicating it is invoked from multiple freight pricing and transportation execution routines rather than from a single entry point. It is typically called from custom or seeded PL/SQL code, concurrent programs, and runtime freight computation logic that wraps its calls in SET_METHOD/UNSET_METHOD blocks. Because it is a utility object, it is not exposed directly through forms; developers invoking it in EBS 12.1.1 or 12.2.2 should ensure UTL_FILE directory privileges are configured for logging and that debug is disabled before production executions.