Search Results pon_auc_attributes

Overview

The APPS.PON_RESPONSE_IMPORT_PKG package body is a Sourcing (Oracle Advanced Procurement / Oracle Sourcing) utility in Oracle E-Business Suite 12.1.1 and 12.2.2. It handles the import of supplier responses to auctions and negotiations, processing data submitted through spreadsheets (Excel-based response templates) as well as XML-based uploads. The package converts supplier-entered pricing, price breaks, quantity-based tiers, shipment information, and user-defined attribute (UDA) values into the interface tables that the Sourcing application consumes.

A significant portion of the package is dedicated to parsing numeric, character, and date values from uploaded spreadsheets and XML documents into canonical Oracle formats. The numerous private global constants — decimal separator characters, number and character masks (g_xml_number_mask, g_xml_char_prec_mask), date masks (g_xml_date_mask, g_pon_date_mask) — reveal that the package normalizes incoming data between external spreadsheet formats and internal PON storage conventions. The constants g_pb_required, g_pb_optional, g_pb_new, g_pb_delete, and g_pb_optional_updated identify the price-break states handled during import.

Key Procedures and Functions

• GET_MESSAGE_1_TOKEN — Extracts a token from an error or log message, supporting diagnostic message parsing during response validation.
• PROCESS_SPREADSHEET_DATA — Core routine that reads supplier-entered data from the spreadsheet (interface) structure and loads it into the Sourcing response interface tables. Handles price breaks, quantity-based lines, shipments, and UDA values.
• PROCESS_XML_SPREADSHEET_DATA — Processes response data delivered in XML form, applying the XML number, character, and date masks to correctly interpret values.
• REMOVE_XML_SKIPPED_LINES — Deletes interface rows that were skipped during XML processing so they are not re-processed on subsequent imports.
• COPY_SHIPMENT_INTERFACE_TO_TXN — Moves shipment-level interface records into the transactional shipment structures used during auction processing.
• PROCESS_SPREADSHEET_UDA_DATA — Loads user-defined attribute (UDA) values from the spreadsheet into the appropriate interface tables.

Tables Accessed

• PON_BID_HEADERS, PON_BID_SHIPMENTS, PON_BID_ITEM_PRICES, PON_BID_ITEM_PRICES_INTERFACE — Bid/response header, shipment, and item-price data, including the interface staging table holding prices to be validated and imported.
• PON_AUCTION_HEADERS_ALL, PON_AUCTION_SHIPMENTS_ALL, PON_AUCTION_ITEM_PRICES_ALL, PON_AUCTION_ATTRIBUTES, PON_AUC_BIZRULES, PON_AUC_DOCTYPE_RULES — Auction definition, shipment, item-price, attribute, and business/doc-type rule data used to validate and accept supplier responses.
• PON_INTERFACE_ERRORS — Stores validation errors encountered during import.
• PO_UDA_INTERFACE — Staging table for user-defined attribute values.
• FND_ATTACHED_DOCUMENTS, FND_DOCUMENT_CATEGORIES, FND_USER — Foundation tables for attachments, categories, and user identity associated with imported responses.

Usage Notes

This package is not exposed as a public API (classification: OTHER) and is referenced by no other packaged code, indicating it is invoked internally by Sourcing's response-import workflow — typically from the spreadsheet import concurrent program or the XML upload path executed when a supplier submits a response. Because the search term pon_auc_attributes maps closely to the PON_AUCTION_ATTRIBUTES table and the PROCESS_SPREADSHEET_UDA_DATA routine, the package is the correct object to inspect when debugging how attribute (UDA) values submitted via spreadsheet or XML reach auction attribute storage. Debug tracing is governed by the AFLOG_ENABLED profile option via the g_fnd_debug constant.