Search Results g_current_runtime_level

Overview

ZX_TAX_TAXWARE_PKG is an internal PL/SQL package body in the Oracle E-Business Suite ETRM (E-Business Tax) module. It encapsulates the integration logic between Oracle E-Business Tax (ZX) and the Taxware third-party tax calculation engine. The package provides the PL/SQL-side interface used when the E-Business Tax services invoke Taxware for tax determination, and it exposes utility routines for validating address-level data elements (geocodes and city limits) before they are passed to the external Taxware service. The package also exposes an installation-check routine that lets callers determine whether Taxware has been configured for the current instance.

In EBS 12.1.1 and 12.2.2, this object is owned by APPS and is classified as OTHER (not a public open interface). It is a private supporting package rather than a customer-callable API, and it is referenced by two other packages in the E-Business Tax codebase.

Key Procedures and Functions

The package body is instrumented with the standard FND_LOG diagnostic framework. Notably, the constant G_CURRENT_RUNTIME_LEVEL is initialized from FND_LOG.G_CURRENT_RUNTIME_LEVEL, and the log severity constants (LEVEL_UNEXPECTED, LEVEL_ERROR, LEVEL_EXCEPTION, LEVEL_EVENT, LEVEL_PROCEDURE, LEVEL_STATEMENT) and a module name of ZX.PLSQL.ZX_TAX_TAXWARE_PKG. are declared. This pattern enables per-package runtime logging controlled by the FND profile option settings.

• IS_GEOCODE_VALID — Validates whether a geocode string conforms to the expected Taxware geocode format. As documented, a geocode is considered valid when it is nine bytes long, comprises two alphabetic characters in the range AA through ZZ, followed by seven numeric characters in the range 0000000 through 9999999. The function returns a Boolean and writes statement- and procedure-level log entries on entry, success, and completion.
• IS_CITY_LIMIT_VALID — Provides the analogous validation for Taxware city-limit codes, ensuring that a supplied city limit value meets the format expectations required by the Taxware engine before tax calculation is attempted.
• INSTALLED — Reports whether Taxware has been installed and is available for use in the current environment. Internally the package caches this state in the pg_TAXWARE_INSTALLED package variable, which is initialized to NULL on first load and populated on demand.

Tables Accessed

The package references the table ZX_TAX_TAXWARE_GEN (via the APPS synonym). This is the E-Business Tax configuration/registry table that records Taxware-specific setup data, and it is the source consulted when the INSTALLED routine determines whether Taxware is enabled for the instance. Reads against this table are performed at the package level rather than per call, consistent with the caching behavior implied by the pg_TAXWARE_INSTALLED variable.

Usage Notes

ZX_TAX_TAXWARE_PKG is not intended to be invoked directly by customer forms, concurrent programs, or custom code. It is called by the E-Business Tax tax-services layer and by the two documented referencing packages whenever third-party Taxware calculation is selected for a jurisdiction. Typical invocation paths include tax calculation during order entry, invoicing, and payables processing where a Taxware-enabled tax regime applies. Because the package is an internal implementation detail, its signatures are not guaranteed to remain stable across patches; administrators should rely on the standard E-Business Tax configuration screens and the FND log diagnostics rather than calling these routines directly. When diagnosing Taxware integration issues, enabling FND logging at the PROCEDURE or STATEMENT level for module ZX.PLSQL.ZX_TAX_TAXWARE_PKG will surface the entry and exit trace messages written by these routines.