Search Results insert_error

Overview

APPS.WIP_INTERFACE_ERR_UTILS is a utility package body in the Oracle E-Business Suite WIP (Work in Process) module. Its business function is to collect, buffer, and persist errors encountered while processing records through the WIP open interfaces, and to write those errors to the interface error repository so that failed interface rows are visible and actionable to users. The interface tables it supports include the WIP job and schedule interface tables and the job detail interface table. In practice, the package serves as a controlled error-handling layer between the interface processing logic and the WIP_INTERFACE_ERRORS table. Errors are first accumulated in a PL/SQL collection in memory and subsequently flushed to the database, which avoids issuing a separate error row insert for every failure and centralizes error formatting and logging behavior.

Key Procedures and Functions

The documented procedures in this package are ADD_ERROR and LOAD_ERRORS.

• ADD_ERROR — Buffers a single interface error in memory. It accepts an interface identifier, the error text, and an error type, constructs an internal error record, truncates the descriptive text to the maximum length supported by the error table column, and appends the record to an in-memory collection. It performs no direct database write, so it is inexpensive to call repeatedly during a processing loop.
• LOAD_ERRORS — Flushes the buffered error collection to the interface error table. It iterates over the accumulated errors, optionally writes diagnostic messages to the WIP logger when runtime logging is enabled at an appropriate trace level, retrieves the audit column values (last update login, last updated by, and created by) from the source WIP interface table, and passes those values to the insertion routine, which performs the actual write. The audit values are read from the interface row rather than derived inside the insertion routine because that routine runs as an autonomous transaction and therefore cannot inherit the calling transaction's context.

An additional INSERT_ERROR procedure is declared in the specification as an autonomous transaction routine and is referenced by the LOAD_ERRORS logic. It is the low-level writer responsible for inserting individual rows into the interface errors table.

Tables Accessed

• WIP_INTERFACE_ERRORS — the primary target of the package. It stores one row per error associated with an interface record, including the interface identifier, error type, error text, and the standard Oracle audit columns. This is the table read by interface error inquiry functionality so that users can identify and correct failed rows.
• PLITBLM — a PL/SQL table used by the package to hold state, consistent with the buffered-collection design in which errors are accumulated before being flushed. Access to this table reflects the in-memory storage of pending errors and related processing state.

Audit values applied to inserted error rows are sourced from the originating WIP interface tables (job and schedule interface, and job detail interface), as noted in the package source comments.

Usage Notes

WIP_INTERFACE_ERR_UTILS is an internal utility rather than an end-user-facing API. It is invoked by the WIP interface processing logic, including concurrent programs and related packages that load job, schedule, and job detail interface data. The package is referenced by twelve other packages in the application, confirming its role as a shared error-handling component.

Typical usage follows a two-phase pattern: interface processing code calls ADD_ERROR as each validation or processing failure is detected, and then calls LOAD_ERRORS once at the end of the processing unit to persist all buffered errors. Because the insertion routine runs autonomously, error rows survive even if the calling transaction is rolled back, which is essential for retaining a record of why interface rows failed. Custom code that reuses this package should follow the same discipline and should not attempt to derive audit columns for the insertion call, since those values must be passed from the interface row. Diagnostic output is governed by the FND logging runtime level and the WIP constants trace setting, so error text appears in the log only when logging is enabled at the trace level.