Search Results get_user_email

Overview

APPS.PON_PRINTING_PKG is a PL/SQL package in the Oracle E-Business Suite Oracle Procurement module that supports the printing and rendering of sourcing documents, most notably auction and negotiation output generated by Oracle Sourcing. The package is classified as OTHER in the ETRM metadata, indicating that it is an internal utility package rather than a formally published Open Interface API. Its principal business role is to assemble XML-based document representations for sourcing artifacts — auctions, supplier responses, receipts, and supporting detail — and to supply formatting, lookup, and messaging services consumed by the printing framework. The package is valid in both EBS 12.1.1 and 12.2.2 and resides in the APPS schema.

Key Procedures and Functions

The package exposes twenty-three documented program units. Several generate XML payloads consumed by the document printing infrastructure:

• GENERATE_AUCTION_XML — builds the XML representation of an auction or negotiation header and its content.
• GENERATE_EMD_XML — generates XML for the electronic submission or associated document data.
• GENERATE_SUPPLIER_XML — produces XML containing supplier-specific information for the printed document.
• GENERATE_RECEIPT_XML — generates XML for receipt-related output associated with the sourcing transaction.

Several functions provide formatting and presentation support: FORMAT_NUMBER and FORMAT_NUMBER_STRING format numeric values for display, FORMAT_PRICE formats monetary amounts, and GET_DISPLAY_RATE retrieves an exchange or display rate. IS_XDO_INSTALLED determines whether the XML Publisher (XDO) engine is available.

Additional utilities retrieve reference and communication data: GET_USER_EMAIL returns a user's e-mail address, GET_CARRIER_DESCRIPTION retrieves a carrier description, GET_DOCUMENT_MESSAGE_NAME and GET_MESSAGES return message text from the FND message repository, and GET_ACCEPTABLE_VALUE, GET_SUPPLIER_BID_TOTAL, IS_PRICE_VISIBLE, PRINT_ATTRIBUTE_RESPONSE_VALUE, and PRINT_ATTRIBUTE_TARGET_VALUE support the display logic for auction attributes, bid totals, and price visibility rules.

Tables Accessed

The package reads from a set of APPS synonyms covering both Sourcing and shared Oracle Application Object Library tables:

• PON_AUCTION_HEADERS_ALL — the primary sourcing table, supplying auction and negotiation header data; the ETRM dependency listing confirms a direct reference.
• AP_INVOICES_ALL, AP_PAYMENT_SCHEDULES_ALL, AP_TERMS — Payables tables accessed to resolve invoice, payment schedule, and payment term information.
• FINANCIALS_SYSTEM_PARAMS_ALL — provides financials system options used in formatting and document setup.
• FND_APPLICATION, FND_PRODUCT_GROUPS, FND_USER, FND_CURRENCIES_TL, FND_TERRITORIES_TL, FND_LOOKUP_VALUES — reference and translation data used in labels, currency, territory, and user lookups.
• FND_NEW_MESSAGES, FND_DOCUMENT_CATEGORIES, FND_DOCUMENT_CATEGORIES_TL, FND_ATTACHED_DOCUMENTS — messaging, document categorization, and attachment metadata used in assembling printed output.

Usage Notes

PON_PRINTING_PKG is invoked indirectly rather than by end users. The ETRM metadata shows that it is referenced by APPS.PON_AUCTION_PKG and by itself (internal calls), and that it is not called by any other package outside the Sourcing family. It is typically executed in the context of the Oracle Sourcing printing and preview flows, where auction documents are rendered through the XML Publisher engine — hence the IS_XDO_INSTALLED check. Customizations that require the same XML structure or formatting conventions should call the documented program units rather than re-implement the logic. Because the package is classified OTHER and is not a published interface, Oracle does not guarantee backward compatibility of its signatures across releases; any custom code referencing it should be validated against the target EBS version.