Results for “g_level_exception”

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

Overview

ZX_TAX_TAXWARE_REV is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the E-Business Tax (EBTax, product family ZX) module and forms part of the Taxware integration layer that connects EBS tax determination to the Taxware (now Vertex) third-party tax calculation engine. The suffix "REV" denotes a revision, and the package functions as a thin wrapper or version-resolution utility within the Taxware adapter stack. Rather than performing tax calculation itself, it exposes revision-level metadata — most importantly the release identifier of the Taxware interface currently in use — to the surrounding tax service infrastructure. This allows EBS to validate version compatibility, route transactions to the correct Taxware access routine (ZX_TAX_TAXWARE_010), and apply the appropriate transaction preprocessing options before a tax call is issued.

Key Procedures and Functions

The ETRM metadata documents a single program unit in this package:

• GET_RELEASE — Returns the release or revision identifier associated with the Taxware integration currently active in the EBS instance. This value is consumed by the broader Taxware tax service package (ZX_TAXWARE_TAX_SERVICE_PKG) and by the tax partner package (ZX_TAX_PARTNER_PKG) to confirm which revision of the Taxware interface contract is in force. It is a read-only accessor; no tax logic, rate lookup, or transaction mutation occurs within it.

No other procedures or functions are documented in the ETRM record for this package body.

Tables Accessed

Two database objects are referenced through APPS synonyms:

• ZX_TAX_TAXWARE_010 — The primary Taxware-facing table used to hold registration, jurisdiction, or configuration data consumed when constructing a Taxware call. ZX_TAX_TAXWARE_REV reads from it to align the reported release value with the configured Taxware data set.
• ZX_TRX_PRE_PROC_OPTIONS_GT — A global temporary table that carries per-transaction preprocessing options (such as rounding, exemption handling, or interface selection) gathered before tax determination. Access here ensures the revision reported by GET_RELEASE is consistent with the preprocessing configuration staged for the current transaction context.

Additional dependencies listed in the ETRM dependency tree include FND_LOG (used for diagnostic logging), ZX_TAXWARE_TAX_SERVICE_PKG and ZX_TAX_PARTNER_PKG (the principal consumers of the returned release value), standard SYS.STANDARD, and a self-reference to ZX_TAX_TAXWARE_REV, indicating internal recursion or overloaded invocation within the package.

Usage Notes

ZX_TAX_TAXWARE_REV is not an entry-point API for end users. It is invoked internally by the E-Business Tax engine during tax service initialization, typically when the Taxware partner integration is enabled and a tax determination request is being prepared. The returned release value is used by ZX_TAXWARE_TAX_SERVICE_PKG and ZX_TAX_PARTNER_PKG to select the correct Taxware adapter behavior. Because the package is not referenced by any other database object per the ETRM metadata, it is effectively a leaf dependency — callable from PL/SQL but not exposed through Oracle Forms, concurrent programs, or standard EBS UI flows. Custom or extension code that instruments the Taxware integration may call GET_RELEASE directly for diagnostic or version-audit purposes, but such use is non-standard. Its behavior is governed by the configuration of ZX_TAX_TAXWARE_010 and the preprocessing options staged in ZX_TRX_PRE_PROC_OPTIONS_GT for the active transaction.