Search Results print_debug_log

Overview

APPS.PON_FORMS_UTIL_PVT is a private PL/SQL utility package within the Oracle Sourcing application, invoked almost exclusively by other packages rather than directly by end users. Its purpose is to render Oracle Forms-based sourcing documents (RFQs, auctions, and negotiation forms) into XML, manage form field metadata, resolve flexfield values, and support the publishing, compilation, and post-save processing of those forms. Typical callers are the public Sourcing form APIs and the negotiation workbench, which delegate low-level XML generation, value-set resolution, and error/debug logging to this package.

The package is classified as PVT, meaning it is internal infrastructure: its interfaces are not guaranteed stable across patches, and it is not intended to be called from customer extensions without caution.

Key Procedures and Functions

• PRINT_DEBUG_LOG / PRINT_ERROR_LOG: Conditional logging routines. Debug output is gated by the AFLOG_ENABLED profile option (g_fnd_debug), so diagnostics only appear when logging is enabled.
• GETSYSTEMDATE / GETSYSTEMNUMBER / GETSYSTEMCHAR: Typed accessors returning server-side system values used to populate form fields and XML tokens.
• GETFLEXINDENDENTVALUE / GETFLEXTBLVALUE / GETFLEXVALUE: Resolve flexfield segment values, including table-validated values, against the FND flexfield definition tables.
• GETVALSETQUERYIDORDER / GET_VALSETQUERY: Build the value-set query and ORDER BY clause used to populate LOV and validation data for form fields.
• GENERATE_XMLQUERY / GENERATE_XMLSCHEMA / GENERATE_XML: Produce the XML representations (query, schema, and document body) that drive the JRad-based form rendering defined by g_jrad_rgn_pkg_name.
• GENERATE_FORM_DETAILS: Assembles the complete form definition by combining regions, sections, and field metadata.
• COMPILE_FORM / PUBLISHABSTRACT: Finalise a form definition and publish the abstract or compiled output for downstream consumption.
• GETDATAENTRYREGIONNAME / GETREADONLYREGIONNAME: Return the region identifiers for data-entry and read-only layouts.
• PERFORMPOSTSAVECHANGES / DELETEFORMFIELDVALUES: Handle field-level persistence and cleanup after a form save.
• GET_FREIGHT: Retrieves freight information, typically for auction or sourcing cost calculations.

Tables Accessed

The package reads and writes several categories of data. Flexfield metadata and values come from FND_FLEX_VALUE_SETS, FND_FLEX_VALUES, FND_FLEX_VALUES_TL, and FND_FLEX_VALIDATION_TABLES; descriptive flexfield context data is drawn from EGO_FND_DSC_FLX_CTX_EXT. Sourcing transaction data is held in PON_AUCTION_HEADERS_ALL, PON_AUCTION_ITEM_PRICES_ALL, PON_AUC_DOCTYPES, and PON_AUC_DOCTYPES_TL. Form post-save state is tracked in PON_FBO_POSTS. Supporting reference data includes FINANCIALS_SYSTEM_PARAMS_ALL, HR_ALL_ORGANIZATION_UNITS_TL, ORG_FREIGHT_TL, FND_LANGUAGES, and FND_LOOKUP_VALUES.

Usage Notes

The package is referenced by five other packages and is normally invoked indirectly when a Sourcing form is opened, rendered, validated, saved, or published. Debug tracing is enabled by setting the AFLOG_ENABLED profile option, which activates PRINT_DEBUG_LOG output. Because the package is classified PVT and its APIs are not part of the supported public interface, customisations should avoid direct calls and instead use the public Sourcing APIs. The header revision (120.9, dated 2006) indicates the object has been largely stable across 12.1.1 and 12.2.2.