Search Results check_po_email_type

Overview

PON_AUCTION_CREATE_PO_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle Sourcing (PON) module's downstream procurement automation. Its principal business function is to convert awarded auction and bid data into purchase order structures without requiring manual re-keying by the buyer. When a sourcing event is awarded, the package reads auction headers, bid headers, bid item prices, and auction item prices, and uses that information to generate requisition allocations, split requisition lines, assemble purchase order structures, initiate the PO approval workflow, and dispatch notification e-mails describing success or failure. The package therefore acts as the technical bridge between Oracle Sourcing award outcomes and Oracle Purchasing documents.

Key Procedures and Functions

The ETRM metadata documents sixteen procedures and functions within the package. The requisition-side routines include AUTO_ALLOC_AND_SPLIT_REQ, ALLOC_ALL_UNALLOC_ITEMS, SPLIT_REQ_LINES, AUTO_REQ_ALLOCATION, and CREATE_PON_BACK_REQ_ALLOC, which collectively allocate unallocated requisition demand, split requisition lines where necessary, and create the back-reference allocation records linking sourcing results to requisitions. The purchasing-side routines include START_PO_CREATION and GENERATE_POS, which drive the overall PO generation process, and CREATE_PO_STRUCTURE, which builds the PO header and line framework. Workflow and status routines include START_PO_WORKFLOW, LAUNCH_PO_APPROVAL, and CHECK_PO_STATUS, which submit the generated document into the approval flow and verify its progression. Notification routines include GENERATE_PO_SUCCESS_EMAIL, GENERATE_PO_FAILURE_EMAIL, and CHECK_PO_EMAIL_TYPE, which determine the appropriate message type and produce the communication sent to the relevant users. Supporting utilities include GET_VENDOR_CONTACT_ID, which resolves the supplier contact used on the resulting document, and INSERT_IP_DESCRIPTORS, which writes descriptive flexfield or interface descriptor data required by the PO creation process.

Tables Accessed

The package reads and writes several core sourcing and reference tables. PON_AUCTION_HEADERS_ALL and PON_AUCTION_ITEM_PRICES_ALL supply the auction definition and awarded pricing, while PON_BID_HEADERS and PON_BID_ITEM_PRICES supply the winning supplier bid information. PON_AUCTION_ATTRIBUTES, PON_AUC_BIZRULES, PON_AUC_DOCTYPES, and PON_AUC_DOCTYPE_RULES provide business rules and document type configuration governing how the resulting PO is created. PON_AUCTION_WF_CREATEPO_S stores workflow status related to PO creation. MTL_UNITS_OF_MEASURE and FND_CURRENCIES provide unit of measure and currency validation. FND_USER, PER_ALL_PEOPLE_F, and PER_JOBS resolve user and person attributes used in notifications and document defaults, while FND_LOG_MESSAGES records diagnostic logging output from the processing routines.

Usage Notes

This package is normally invoked indirectly rather than called by end users. It is triggered as part of the automated award-to-PO cycle in Oracle Sourcing, generally through the sourcing workflow or a concurrent process that executes after an auction award is finalized. In EBS 12.1.1 and 12.2.2 the package resides in the APPS schema and references tables through APPS synonyms. Because the procedures accept and manipulate transaction data rather than exposing a general-purpose public API, custom code should call it only with caution and preferably through the standard sourcing and purchasing flows. No other packages are documented as referencing it, indicating that it functions as a terminal consumer of sourcing award data rather than a shared utility. Developers using FND_LOG_MESSAGES output should raise the relevant logging level to capture diagnostic detail during troubleshooting.