Search Results insert_distribution_warning




Overview
Explore in AI Chat

Overview

PA_TAX_CLIENT_EXTN_DRV is a client extension driver package in the Oracle EBS Projects (PA) module that supports the calculation and application of output tax on draft invoices. Its principal business role is to surface warning conditions encountered during tax processing so that users reviewing a draft invoice are alerted to potential tax exceptions before the invoice is finalized. In release 12.1.1 and 12.2.2 the package operates within the APPS schema and is classified as an OTHER API, meaning it is an internal utility rather than a public, callable interface.

The package body contains private procedures and maintains package-level global variables that persist the current project identifier and draft invoice number across successive invocations. These globals are used to detect changes in processing context and to avoid redundant warning insertions within a single processing run.

Key Procedures and Functions

  • GET_TAX_CODE — The single documented procedure/function in the ETRM metadata. It is the public entry point for retrieving the applicable tax code during output tax determination for invoice distributions. Only its name and purpose are documented; parameter details are not published in the metadata.
  • INSERT_DISTRIBUTION_WARNING (private) — Although not listed among the documented procedures, the source excerpt reveals this private procedure, which inserts a draft invoice distribution warning into PA_DISTRIBUTION_WARNINGS. It accepts a project ID, user ID, request ID, and error message code. It first resolves the error message code to a descriptive meaning via PA_LOOKUPS (lookup type 'OUTPUT TAX'), falling back to the raw code when no meaning is found. The insert is guarded by a comparison of the incoming project ID and draft invoice number against the package globals, ensuring a warning is written only when the processing context has changed. When no draft invoice number is present, the procedure stores the error code in a global instead of inserting a row.

Tables Accessed

  • PA_DISTRIBUTION_WARNINGS — The primary table referenced through an APPS synonym. The package inserts rows capturing project ID, draft invoice number, audit columns (creation and last update date/user), request ID, and the resolved warning message. This table is the persistence mechanism through which tax-processing warnings become visible on the draft invoice.
  • PA_LOOKUPS — Read during warning insertion to translate an error message code into a user-readable meaning using the 'OUTPUT TAX' lookup type. A NO_DATA_FOUND exception is handled locally, defaulting to the raw code.

Usage Notes

Because the package is classified as OTHER and is referenced by two other packages, it is invoked internally by the Projects tax extension framework rather than directly by end users. Typical invocation occurs during draft invoice generation and output tax calculation, where the driver evaluates tax conditions for invoice distributions and calls Insert_Distribution_Warning to record exceptions.

The package is not intended as a standalone concurrent program. Customizations should not call the private procedures directly; any extension of output tax behavior should follow Oracle's documented client extension patterns and be applied in a controlled environment. The static $Header value (PAXVDTXB.pls 120.7.12010000.2) indicates the file was last delivered in the 12.1.1 code line and remains compatible with 12.2.2.