Search Results check_and_load_bid




Overview
Explore in AI Chat

Overview

The APPS.PON_MULTIPLE_RESPONSE_PKG package body is a component of the Oracle E-Business Suite Sourcing module, which supports the creation, publication, and evaluation of RFQs and auctions. Its primary business function is to determine whether a given negotiation permits multiple active responses (bids) from a supplier, and to manage the loading of bid data within that context. In EBS 12.1.1 and 12.2.2, the package operates against the PON schema objects owned by APPS and is classified as an "OTHER" API rather than a formally published public interface.

The core business rule enforced by the package is governed by the ALLOW_MULTIPLE_ACTIVE_OFFERS profile/control flag on the auction header. When multiple active offers are enabled, the package evaluates additional qualifiers such as the two-stage negotiation flag and whether the caller is a buyer or a supplier. The header comment in the source explicitly documents that a buyer should not have multiple responses when the negotiation is two-stage enabled, whereas the logic differs for supplier callers.

Key Procedures and Functions

  • MULTIPLE_RESP_ENABLED — Returns 'Y' if multiple responses are enabled for the negotiation identified by the auction header, otherwise 'N'. It decodes the ALLOW_MULTIPLE_ACTIVE_OFFERS value on PON_AUCTION_HEADERS_ALL and further decodes based on the two-part (two-stage) flag when the caller is a buyer. This function is the authoritative gate used by other routines to decide whether bid-loading logic should permit more than one active response.
  • CHECK_AND_LOAD_BID — The routine associated with the search term "check_and_load_bid". It validates and loads bid data into the Sourcing bid tables, invoking the multiple-response check to enforce whether an additional bid may be accepted. It is the principal entry point for callers that need to conditionally persist a bid header and its associated item prices.
  • GET_LATEST_NEG_WITH_RESP — Retrieves the most recent negotiation that has an associated response. This supports downstream processing that must identify the current negotiation context before evaluating or loading bids.

The package additionally contains a private LOG_MESSAGE helper that writes to FND_LOG when the AFLOG_ENABLED profile is set to 'Y' and the current runtime level permits statement-level logging.

Tables Accessed

  • PON_AUCTION_HEADERS_ALL — Read to obtain ALLOW_MULTIPLE_ACTIVE_OFFERS and TWO_PART_FLAG, which drive the multiple-response decision.
  • PON_BID_HEADERS — Read and written to validate and persist the header record of a supplier bid.
  • PON_BID_ITEM_PRICES — Read and written to store the line-level pricing associated with a loaded bid.
  • PON_CONTRACTS — Referenced in support of contract-related negotiation processing tied to bid responses.

Usage Notes

The package is referenced by two other packages within the Sourcing application, indicating it is invoked internally rather than directly by end users. Typical invocation paths include the Sourcing buyer and supplier forms and concurrent bid-processing programs. Because it is classified as OTHER and its header reflects a 12.2.2 build, custom code should treat it as a non-public API and beware of signature changes across patch levels. The CHECK_AND_LOAD_BID routine should be called within the standard bid-submission transaction flow, where the multiple-response check must succeed before bid rows are inserted.