Search Results po_delete_error

Overview

The APPS.PON_AUCTION_CREATE_PO_PKG package body is an Oracle Sourcing (PON) component in Oracle E-Business Suite 12.1.1 and 12.2.2 that orchestrates the conversion of awarded sourcing auction lines into purchase orders and purchase order workflow submissions. It serves as the bridge between the Sourcing application and the Purchasing module's PO creation and approval infrastructure.

The package is classified as API classification OTHER within ETRM. Its header ($Header: PONCRPOB.pls 120.41) indicates it is part of the core PON sourcing module. The primary business driver is the "Auto-Allocation of non-allocated items and Split requisition" activity node within the PONCOMPL (Sourcing Complete Auction) workflow. When an auction completes and awards are finalized, this package coordinates allocation of unallocated items, splitting of requisitions, and generation of the resulting purchase orders.

Package-level constants define result codes that callers use to interpret outcomes: PO_SUCCESS (1), DUPLICATE_PO_NUMBER (2), PO_SYSTEM_ERROR (3), SOURCING_SYSTEM_ERROR (4), PO_PDOI_ERROR (5), and PO_DELETE_ERROR (6). Logging is handled through FND_LOG with debug gated by the AFLOG_ENABLED profile option.

Key Procedures and Functions

The package exposes 16 documented procedures and functions. The search term "generate_pos" maps directly to the documented procedure GENERATE_POS, which drives creation of purchase orders from awarded auction content.

• AUTO_ALLOC_AND_SPLIT_REQ — Entry point invoked by the PONCOMPL workflow; coordinates allocation and requisition splitting.
• ALLOC_ALL_UNALLOC_ITEMS — Allocates all unallocated auction items.
• SPLIT_REQ_LINES — Populates PO interface tables with award and requisition information and calls the PO Split Requisition API.
• AUTO_REQ_ALLOCATION — Performs automatic requisition allocation.
• START_PO_WORKFLOW — Initiates the PO approval workflow.
• START_PO_CREATION — Begins the PO creation process.
• GENERATE_POS — Generates purchase orders from awarded auction data.
• CREATE_PO_STRUCTURE — Builds the internal PO data structures.
• LAUNCH_PO_APPROVAL — Submits created POs for approval.
• CHECK_PO_STATUS — Verifies the current status of generated POs.
• GENERATE_PO_SUCCESS_EMAIL / GENERATE_PO_FAILURE_EMAIL — Produce notification emails for successful or failed PO generation.
• CHECK_PO_EMAIL_TYPE — Determines the email notification type to send.
• INSERT_IP_DESCRIPTORS — Inserts descriptor flexfield data.
• CREATE_PON_BACK_REQ_ALLOC — Creates back-referenced requisition allocation records.
• GET_VENDOR_CONTACT_ID — Retrieves the vendor contact identifier.

Tables Accessed

The package reads and writes sourcing and purchasing tables via APPS synonyms. Auction and bid data (PON_AUCTION_HEADERS_ALL, PON_AUCTION_ITEM_PRICES_ALL, PON_BID_HEADERS, PON_BID_ITEM_PRICES, PON_AUCTION_ATTRIBUTES) supply award information. Configuration and rule references include PON_AUC_BIZRULES, PON_AUC_DOCTYPES, and PON_AUC_DOCTYPE_RULES. Workflow state is held in PON_AUCTION_WF_CREATEPO_S. Reference data includes MTL_UNITS_OF_MEASURE, FND_CURRENCIES, FND_USER, PER_ALL_PEOPLE_F, and PER_JOBS. Logging uses FND_LOG_MESSAGES.

Usage Notes

This package is typically invoked automatically by the Sourcing Complete Auction workflow rather than through a direct form or concurrent program submission. Customizations should not call it directly unless replicating the workflow path. No other packages reference it per ETRM, indicating internal, workflow-driven usage. Debug output requires the AFLOG_ENABLED profile to be set to 'Y'.