Search Results pon_auction_headers_interface

Overview

APPS.PON_OPEN_INTERFACE_PUB is a public PL/SQL package in Oracle E-Business Procurement (Advanced Procurement / Sourcing) that serves as the import entry point for converting staged auction and negotiation data from the open interface table into live negotiation records. Its source header (PON_OPEN_INTERFACE_PUB.plb 120.2.12020000.4, dated 2013/02/22) identifies it as a member of the PON module, the schema family that houses Oracle Sourcing and negotiation objects in Release 12.1.1 and 12.2.2. The package encapsulates the validation and hand-off logic required to turn pending interface rows into actual negotiation documents, isolating callers from the internal private package PON_OPEN_INTERFACE_PVT.

Key Procedures and Functions

Two documented units are exposed through the package:

• CREATE_NEGOTIATIONS — The principal public procedure. It accepts a group batch identifier (p_group_batch_id) and returns an outbound status buffer (EFFBUF) and return code (RETCODE). It first initializes the message stack via FND_MSG_PUB.initialize, then verifies that at least one row in PON_AUCTION_HEADERS_INTERFACE carries the supplied interface_group_id with a PROCESSING_STATUS_CODE of 'PENDING'. When no such row exists, it raises the seeded message PON_IMPORT_INV_GRPBATCHID, sets RETCODE to '2', and returns without further processing. On success it delegates the substantive work to PON_OPEN_INTERFACE_PVT.create_negotiations, propagates the returned status, logs accumulated FND messages to the concurrent manager log via FND_FILE.put_line, and assigns RETCODE '0' on success or '2' on failure.
• PRINT_LOG — A helper procedure used for diagnostic logging, invoked at the start of CREATE_NEGOTIATIONS to record the procedure name and its parameters to the log file. It supports troubleshooting of import runs.

Tables Accessed

The package reads the open interface table PON_AUCTION_HEADERS_INTERFACE through an APPS synonym. This table is the staging area for inbound auction and negotiation header data. CREATE_NEGOTIATIONS queries it specifically to confirm the presence of a PENDING row matching the supplied interface_group_id before invoking the private processing engine. The actual insertion or update of negotiation records is performed downstream by PON_OPEN_INTERFACE_PVT, which consumes the same interface rows and advances their processing status.

Usage Notes

CREATE_NEGOTIATIONS is typically invoked by the concurrent program that processes the auction headers open interface — commonly the Sourcing import program that transforms staged spreadsheet or external-system data into negotiable documents. Because it is a PUB-classified API, it may also be called from custom PL/SQL, concurrent-program wrappers, or host scripts that pass a valid interface_group_id. Callers must ensure the interface rows are staged with PROCESSING_STATUS_CODE 'PENDING' and share the intended interface_group_id; otherwise the procedure exits with RETCODE '2' and the PON_IMPORT_INV_GRPBATCHID error. The RETCODE convention follows the standard EBS API pattern ('0' success, non-zero failure), and messages are written to the concurrent request log, making the concurrent manager log the first place to investigate unsuccessful runs. The package is self-contained and, per the ETRM metadata, is not referenced by any other package, so it functions purely as a top-level integration entry point.