Search Results g_module_name

Overview

The APPS.ZX_VERTEX_TAX_SERVICE_PKG package body is the core PL/SQL integration layer that connects Oracle E-Business Suite Release 12.1.1 and 12.2.2 with the Vertex indirect tax calculation engine. Oracle ETRM (E-Business Tax) relies on external tax service providers to determine jurisdiction-specific tax rates and rules for transactions such as invoices, credit memos, debit memos, and purchase orders. This package encapsulates the calls out to the Vertex service, the transformation of EBS transaction data into the format Vertex expects, and the return and persistence of Vertex's tax results back into the EBS tax repository.

The package begins with a standardized FND Logging infrastructure header, declaring constants such as G_PKG_NAME and, notably for users searching the "g_module_name" identifier, the G_MODULE_NAME constant. Set to the literal 'ZX.PLSQL.ZX_VERTEX_TAX_SERVICE_PKG.', this constant is used to prefix FND_LOG diagnostic messages so that runtime errors, events, and statement-level traces can be filtered and attributed to this package. The header additionally declares a large family of associative-array and record types used to hold transaction lines, tax lines, jurisdiction and location data during synchronous service calls.

Key Procedures and Functions

The ETRM metadata documents three public entry points:

• CALCULATE_TAX_API — The principal service procedure that submits a transaction to Vertex for tax determination. It assembles the document, line, party, and location data, invokes the Vertex service, and returns calculated tax lines and factors.
• SYNCHRONIZE_VERTEX_REPOSITORY — Refreshes the local EBS tax repository from the external Vertex configuration, ensuring jurisdictions, regimes, and geographic mappings used at runtime are current.
• GLOBAL_DOCUMENT_UPDATE — Handles the update of document-level tax results back into EBS after service processing, supporting synchronization of header-level totals and statuses.

Tables Accessed

The package interacts with a broad set of E-Business Tax and Trading Community tables through APPS synonyms. Transaction and calculation data are read from ZX_LINES and ZX_LINES_DET_FACTORS, while detail results are staged in ZX_DETAIL_TAX_LINES_GT. Jurisdiction, regime, and event-class configuration come from ZX_JURISDICTIONS_B, ZX_REGIMES_B, ZX_EVNT_CLS_MAPPINGS, and the global temporary ZX_JURISDICTIONS_GT. Provider payload data and partner details are held in ZX_PRVDR_HDR_EXTNS_GT, ZX_PRVDR_LINE_EXTNS_GT, ZX_PTNR_LOCATION_INFO_GT, ZX_PTNR_NEG_LINE_GT, and ZX_PTNR_NEG_TAX_LINE_GT. Geographic reference data is sourced from ZX_TAX_VERTEX_GEO and ZX_TAX_VERTEX_QSU, and party locations from HZ_LOCATIONS.

Usage Notes

This package is invoked internally by E-Business Tax during tax calculation for transactions serviced by Vertex as the tax provider. It is referenced by at least one other EBS package, and is typically triggered when a user validates or calculates tax in the Payables, Receivables, or Order Management forms, or when a tax calculation concurrent program runs. Because most of its routines are service-oriented, custom development should avoid modifying the package directly; extensions should instead follow supported EBS Tax APIs. Runtime diagnostics for this package are collected under the log module string defined by G_MODULE_NAME.