Search Results handle_error

Overview

APPS.OZF_RESALE_WF_PVT is a private PL/SQL package body within the Oracle E-Business Suite Trade Management (formerly Oracle Resale Management) module. Its declared purpose is to service the Resale Data processing and Payment initiation workflows. The package acts as the technical engine behind the Oracle Workflow orchestration of resale batches — validating them, moving them through their lifecycle statuses, computing customer trading profile data, and initiating payments (including chargeback, special pricing, and tracing disbursements). Because it is classified as a PVT (private) package, it is not intended for direct invocation by end users or external integrations; it is called internally by Workflow function activities, other packages in the OZF schema, and by only one other package as documented.

Key Procedures and Functions

The package exposes 26 documented procedures and functions. The HANDLE_ERROR procedure — the subject of the user's search — is the centralized workflow error handler. It takes the item type, item key, message count, message data, and process name as inputs, retrieves the resale batch identifier from the Workflow item attributes, iterates through the pending FND messages, concatenates them into a single error message, and returns it via an OUT parameter. This allows workflow error notifications to include meaningful, context-rich diagnostics.

Lifecycle management routines include INIT_ATTRIBUTES, which seeds workflow item attributes from the batch; GET_BATCH_STATUS, GET_BATCH_TYPE, and GET_BATCH_CALLER, which retrieve batch context; RESET_STATUS and SET_BATCH_STATUS, which transition batch state; and SET_PAYMENT_PENDING, which flags a batch awaiting payment.

Validation and processing routines include VALIDATE_BATCH and VALIDATE_ORDER, CHECK_DUPLICATES, PROCESS_RESALE, PROCESS_CHARGEBACK, PROCESS_SPECIAL_PRICING, and PROCESS_TRACING. Payment initiation is handled by INITIATE_PAYMENT and its variants INITIATE_PAYMENT_CHARGEBACK, INITIATE_PAYMENT_SPP, and INITIATE_PAYMENT_TRACING. Configuration/query helpers include GET_AUTO_ACCRUAL_FLAG and SET_TOLERANCE_LEVEL.

Tables Accessed

Through APPS synonyms the package reads and writes:

• OZF_RESALE_BATCHES_ALL — the core resale batch records whose status, type, and tolerances are manipulated.
• OZF_CUST_TRD_PRFLS — customer trading profiles supplying accrual and pricing attributes.
• OZF_SYS_PARAMETERS — system-level configuration values.
• JTF_RS_RESOURCE_EXTNS — resource (salesperson) details associated with batches.
• WF_ITEM_ATTRIBUTE_VALUES and WF_PARAMETER_LIST_T — Workflow runtime attributes and parameter lists used to pass context between activities.

Usage Notes

This package is invoked from Workflow function activities attached to the Resale Data Processing and Payment Initiation workflow definitions. It is also referenced internally by one other OZF package. Developers should not call PVT procedures directly; instead, invoke the parent workflow or supported public APIs. The HANDLE_ERROR routine is typically wired as the error-handling activity on workflow processes so that batch-level failures surface as formatted FND messages retrievable via the notification system.