Search Results g_execute_api_callout




Overview
Explore in AI Chat

Overview

APPS.HZ_BUSINESS_EVENT_V2PVT is the private implementation package body behind the public TCA (Trading Community Architecture) business event interface, HZ_BUSINESS_EVENT_V2PUB. Its core responsibility is to translate DML activity performed against the party model into Oracle Workflow business events. The package wraps the standard HZ_PARTY_V2PUB record structures (for example PERSON_REC_TYPE) and, for each entity-verb combination, constructs a Workflow parameter list and calls HZ_EVENT_PKG.RAISE_EVENT with a normalized event name such as oracle.apps.ar.hz.Person.create.

The package is classified as OTHER in the ETRM registry and is owned by APPS. The source header identifies it as ARH2BESB.pls, version 120.21 (2006/03/24), which places the bulk of its logic in the Release 11i/12.0 timeframe and reflects the bug4369710 remediation that removed per-event subscription checks in favour of unconditional event raising. It is referenced by 20 other packages, indicating that it sits at the centre of the TCA event publication layer.

Key Procedures and Functions

The package exposes 83 documented procedures and functions, organized as matched pairs of create and update handlers. Each handler accepts the corresponding HZ_PARTY_V2PUB record type, derives an item key via HZ_EVENT_PKG.ITEM_KEY, builds a WF_PARAMETER_LIST_T containing at minimum the PARTY_ID plus environment context values supplied by HZ_EVENT_PKG.ADDPARAMENVTOLLIST, and raises the event. The documented entry points include:

All handlers follow an identical internal contract: they operate inside a SAVEPOINT named after the procedure, guard execution on the G_EXECUTE_API_CALLOUT constant (initialized to 'Y', with a commented-out FND_PROFILE lookup retained for reference), and terminate in an exception handler that issues FND_MESSAGE.SET_NAME with the message HZ_API_OTHERS_EXCEP before re-raising. The search term supplied by the user maps directly to that shared error message, which is the standard generic failure notification for TCA API calls.

Tables Accessed

The package does not perform conventional DML against TCA base tables such as HZ_PARTIES or HZ_LOCATIONS. Its database interactions are limited to the Workflow and event infrastructure, accessed through APPS synonyms:

  • WF_PARAMETER_LIST_T and WF_PARAMETER_T — Workflow collection types used for the in-memory parameter list passed to the raised event. HZ_PARAM_PKG and HZ_EVENT_PKG interactions were deliberately reduced by the bug4369710 fix.
  • PLITBLM — the standard Oracle PL/SQL index-by table of VARCHAR2 used for message token substitution, invoked through FND_MESSAGE.SET_TOKEN when reporting the HZ_API_OTHERS_EXCEP error.

Usage Notes

Because it is a PVT package, direct invocation by customer code is not supported; it is called internally by HZ_BUSINESS_EVENT_V2PUB, which in turn is driven by the TCA public APIs (HZ_PARTY_V2PUB, HZ_LOCATION_V2PUB, HZ_CONTACT_POINT_V2PUB and their siblings). Typical entry paths are Oracle Forms such as the Party and Location maintenance screens, seeded concurrent programs that perform bulk party maintenance, and customer-written PL/SQL that calls the public TCA APIs. Any subscriber configured in Oracle Workflow for the corresponding oracle.apps.ar.hz.* event names will receive the event regardless of prior subscription checks, since those checks were removed. When an event handler fails, the caller observes the HZ_API_OTHERS_EXCEP message, and diagnosis should proceed against the underlying TCA API call rather than this wrapper.