Results for “validate_account_wrapper”

5 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PO_DOCUMENT_CHECKS_PVT is a private PL/SQL package body in the APPS schema that centralizes the server-side validation logic applied to Oracle Purchasing documents before they are submitted for approval and, in certain flows, after submission has completed. Its principal business purpose is to enforce purchasing business rules — supplier and supplier site validity, buyer and agent authorization, accounting flexfield combinations, currency and currency precision rules, unit of measure conversions, contract and deliverable references, global (cross-organization) sourcing references, consignment references, and Country of Birth (CBC) compliance checks — against requisitions, purchase orders, blankets, contracts, and releases. Because it is classified as a PVT package, it is an internal implementation component rather than a public API: it is called by other Purchasing packages and by the document submission framework, and its name does not form part of the supported integration surface.

Key Procedures and Functions

The package exposes 38 documented subprograms. The entry-point validators are organized by document type and lifecycle stage:

Tables Accessed

The package reads and writes a broad set of EBS tables through APPS synonyms. Supplier data is sourced from AP_SUPPLIERS, AP_SUPPLIER_CONTACTS, and AP_SUPPLIER_SITES_ALL, while buyer and agent authorization draws on PO_AGENTS. Accounting validation uses GL_CODE_COMBINATIONS and GL_SETS_OF_BOOKS, and financials defaults are read from FINANCIALS_SYSTEM_PARAMETERS and FINANCIALS_SYSTEM_PARAMS_ALL. Currency rules come from FND_CURRENCIES; unit of measure checking relies on MTL_UNITS_OF_MEASURE, MTL_UOM_CLASSES_TL, and MTL_UOM_CLASS_CONVERSIONS. Item validation uses MTL_SYSTEM_ITEMS and MTL_ITEM_CATEGORIES. Contract and deliverable validation references OKC_K_LINES_B, OKC_K_VERS_NUMBERS_H, OKE_DELIVERABLES_B, and related views; global sourcing uses PO_APPROVED_SUPPLIER_LIS_VAL_V, PO_ASL_ATTRIBUTES, and PO_ASL_STATUS_RULES_V. Attachments and messages are handled through FND_ATTACHED_DOCUMENTS, FND_DOCUMENTS_TL, FND_NEW_MESSAGES, and FND_LOG_MESSAGES. Additional references include HR_LOCATIONS_ALL, HZ_PARTIES, HZ_PARTY_SITES, FND_USER, FND_CONCURRENT_REQUESTS, PON_FBO_POSTS, and PO_DOCUMENT_TYPES.

Usage Notes

PO_DOCUMENT_CHECKS_PVT is invoked automatically by the Purchasing submission and approval framework during document submission from the Purchase Orders, Requisitions, and related forms, and by concurrent processes that submit purchasing documents in batch. It is not intended for direct invocation by custom code. Because the package is private and its signature is not guaranteed, customizations should call supported public APIs such as PO_DOCUMENT_CHECKS_PUB or the document submission APIs rather than referencing PO_DOCUMENT_CHECKS_PVT directly. Developers reviewing this object in 12.1.1 or 12.2.2 should treat any wrapper or call to its subprograms as a deprecated integration point and validate behavior after patch or upgrade application.