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:
- PO_SUBMISSION_CHECK and POST_SUBMISSION_CHECK — the primary pre-submission and post-submission validation drivers for purchase orders, invoking the applicable document-specific checks.
- CHECK_PO, CHECK_PO_PA_HEADER, CHECK_STANDARD_PO, CHECK_PLANNED_PO_BLANKET_PA, and CHECK_CONTRACT_AGREEMENT — validate standard purchase orders, planned and blanket purchase agreements, and contract agreements respectively.
- CHECK_REQUISITIONS and CHECK_RELEASES — validate requisition and release documents.
- CHECK_PO_REL_REQPRICE — verifies pricing on releases and requisitions tied to prior agreements.
- CHECK_STD_GLOBAL_REF, CHECK_STD_CONSIGNED_REF, and CHECK_STD_GC_REF — validate global sourcing references, consigned inventory references, and global/consignment combinations.
- DO_CBC_RELATED_VALIDATIONS — applies Country of Birth compliance validation.
- VALIDATE_ACCOUNT_WRAPPER — wraps accounting flexfield validation for the document's charge account.
- POPULATE_PO_HEADERS_GT, POPULATE_REQ_HEADERS_GT, POPULATE_REQ_LINES_GT, POPULATE_RELEASES_GT, and UPDATE_GLOBAL_TEMP_TABLES — populate and refresh the global temporary tables that stage document data for validation processing.
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.