Search Results check_tca

Overview

ASO_CHECK_TCA_PVT is a private PL/SQL package in the Oracle EBS Applications (APPS) schema that validates Oracle Trading Community Architecture (TCA) party, customer account, and account site data for Oracle Quoting (ASO) quote headers, lines, and shipments. The package name and its primary procedure, CHECK_TCA, indicate that its role is to verify that the parties, customer accounts, account sites, and contacts referenced on a quote conform to the TCA model before the quote is saved or processed. The package body header (asovctcb.pls, version 120.19) shows that it accepts a quote header record and a shipment table as IN OUT NOCOPY parameters, with operation and application type codes controlling the validation path, and returns standard API error signalling via x_return_status, x_msg_count, and x_msg_data.

Because the package is classified as PVT, it is not a public API. It is invoked internally by other ASO modules and is referenced by five other packages, meaning it acts as a shared validation service inside the Quoting product rather than as an integration point for external callers.

Key Procedures and Functions

• CHECK_TCA — The main entry point. It validates TCA-related data across the quote header and shipment structures supplied by the caller, using the operation code and application type code to determine which checks apply, and returns the standard FND_API return status, message count, and message data.
• CHECK_HEADER_ACCOUNT_INFO — Validates the customer account, party, and site information attached to the quote header.
• CHECK_LINE_ACCOUNT_INFO — Performs the equivalent validation for quote lines, ensuring line-level account references are consistent with TCA data.
• CUSTOMER_ACCOUNT — Checks or derives the customer account associated with the quote data.
• CUSTOMER_ACCOUNT_SITE — Validates the customer account site identified for the quote.
• CUST_ACCT_RELATIONSHIP — Examines relationships between customer accounts, such as ship-to and bill-to associations.
• CUST_ACCT_CONTACT_ADDR — Validates contact and address information tied to a customer account.
• ASSIGN_CUSTOMER_ACCOUNTS — Assigns the resolved customer accounts and sites to the quote structures.
• POPULATE_ACCT_PARTY — Populates party and account identifiers used by the preceding checks.
• CHECK_CUSTOMER_ACCOUNTS — Performs the aggregate customer account validation across the records supplied.

The body also declares private cursors that resolve a party from a customer account (HZ_CUST_ACCOUNTS), retrieve a party type (HZ_PARTIES), and obtain the customer party relationship (HZ_RELATIONSHIPS), confirming that party-type-driven logic underpins the validations.

Tables Accessed

The package reads and writes quote data in ASO_QUOTE_HEADERS_ALL, ASO_QUOTE_LINES_ALL, and ASO_SHIPMENTS, which hold the header, line, and shipment records being validated. TCA data is sourced from HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_RELATE, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, HZ_PARTIES, HZ_PARTY_SITES, HZ_PARTY_SITE_USES, and HZ_RELATIONSHIPS. The PLITBLM table is used as a PL/SQL index-by table for message handling. All are accessed through APPS synonyms.

Usage Notes

ASO_CHECK_TCA_PVT is called from other ASO packages during quote creation, update, and validation workflows, and indirectly from the Oracle Quoting UI and any concurrent or custom code that invokes the Quoting public APIs. It should not be called directly by external integrations; instead, callers should use the supported ASO public APIs, which invoke this private package as part of their validation flow. Because it follows the FND_API standard, callers must supply a valid p_api_version and inspect x_return_status and x_msg_data after execution.