Search Results get_user_lang_message

Overview

PON_RESPONSE_PVT is a private PL/SQL package in the APPS schema that encapsulates the core processing logic for supplier responses (bids) submitted against Oracle Sourcing auctions and negotiations. The PVT suffix indicates that the package is classified as a private API: it is not intended to be called directly from external integrations, forms, or customer extensions, but rather serves as the internal engine invoked by the public Sourcing APIs and concurrent programs that handle bid import, bid maintenance, and bid publication.

In Oracle EBS 12.1.1 and 12.2.2, the Sourcing module (PON) manages the full negotiation lifecycle. When a supplier submits a response, or when a buyer-side process ingests responses on a supplier's behalf, the response data must be validated, priced, converted to the auction currency, and written to the bid tables. PON_RESPONSE_PVT is the package that performs this work. It is heavily oriented toward multi-currency recalculation, bid line and group pricing, header and line close-date derivation, and the publishing of bid lines and change-price records once a response is finalized.

Key Procedures and Functions

The package exposes 22 documented procedures and functions, which fall into several functional clusters.

• Close-date derivation: GET_HEADER_CLOSE_BIDDING_DATE and GET_LINE_CLOSE_BIDDING_DATE resolve the effective close bidding date at header and line level, respecting auction attributes and scheduling rules.
• Amount calculation: CALCULATE_GROUP_AMOUNTS and CALCULATE_GROUP_AMOUNTS_AUTO compute pricing totals for bid groups, with the AUTO variants supporting bulk or automatic processing paths.
• Price maintenance: CHANGE_BID_BY_PERCENTAGE applies a percentage adjustment across bid prices, and RECALCULATE_AUC_CURR_PRICES recalculates auction-currency prices from the underlying entered prices and conversion rates.
• Publishing: PUBLISH, PUBLISH_LINES, PUBLISH_LINES_AUTO, and PUBLISH_CP finalize bid header and line data and propagate change-price (CP) information.
• Row hygiene: REMOVE_EMPTY_ROWS and REMOVE_EMPTY_ROWS_AUTO delete placeholder or blank bid rows before validation and commit.
• Header maintenance: UPDATE_BID_HEADER_FIELDS and UPDATE_BID_HEADER_FIELDS_AUTO apply header-level field updates, including the automatic variant.
• Validation: VALIDATE_CP validates change-price records prior to publication.
• Messaging: GET_MESSAGE_NAME and GET_USER_LANG_MESSAGE retrieve message names and user-language message text for error and status reporting.
• Line marking: MARK_INFO_LINES and MARK_OPTION_LINES flag information lines and option lines within a response.
• Scoring: CALCULATE_AVG_EVAL_SCORES derives average evaluation scores across scored bid lines.

Tables Accessed

The package reads and writes the principal Sourcing transactional tables through APPS synonyms. PON_AUCTION_HEADERS_ALL and PON_AUCTION_ATTRIBUTES supply auction configuration and currency context. PON_BID_HEADERS, PON_BID_ITEM_PRICES, PON_BID_ATTRIBUTE_VALUES, PON_BID_PAYMENTS_SHIPMENTS, PON_BID_PRICE_DIFFERENTIALS, PON_BID_PRICE_ELEMENTS, and PON_BID_SHIPMENTS hold the supplier response itself. PON_AUCTION_ITEM_PRICES_ALL, PON_BIDDING_PARTIES, and PON_AUC_DOCTYPES provide supporting auction, party, and document-type data. FND_CURRENCIES, FND_LANGUAGES, and FND_USER are referenced for currency conversion, message translation, and user context. WRITE operations concentrate on PON_BID_HEADERS, PON_BID_ITEM_PRICES, and the associated bid detail tables.

Usage Notes

PON_RESPONSE_PVT is referenced by PON_RESPONSE_IMPORT_PKG, the public import package used by the Sourcing bid import concurrent program and by internal forms logic. It also references itself, indicating recursive or helper calls between its procedures. Customers should not invoke PON_RESPONSE_PVT directly; instead, the public import and response APIs, or the Sourcing bid maintenance forms, trigger it automatically. It is best treated as an internal implementation package whose behavior is version-sensitive across patch levels of 12.1.1 and 12.2.2.