Results for “ntf_requestor_of_error”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AMW_GEN_APPROVAL_PVT is a private PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that implements the generic approval engine used by Oracle Engineering (product family AMW). It provides the workflow integration layer that drives approval routing for engineering change objects such as change orders, change requests, events, and campaigns. Although the package header carries a 2003 signature (amwvgaps.pls 115.3) and is classified as a private (PVT) API, it remains present and operative across EBS 12.1.1 and 12.2.2, where the underlying AMW schema objects are still installed as part of the Engineering foundation.

The package’s central responsibility is to initiate, drive, monitor, and terminate workflow-based approval transactions. It starts the approval flow for an object, resolves the set of required approvers, applies approve/reject/revert status transitions to the owning object, and issues workflow notifications to participants. In addition, it handles notification-related error paths, including the notification whose internal name is NTF_REQUESTOR_OF_ERROR — the mail message sent to the originating user (requestor) when the approval workflow encounters an unrecoverable error. Because its routines are workflow-callable, they are executed both synchronously from the initiating form and asynchronously by Workflow Engine background processing, and they declare AUTHID CURRENT_USER, causing them to run with the invoker’s privileges rather than as definer rights.

Key Procedures and Functions

• STARTPROCESS — Primary entry point. Starts the approval flow for a target object and object version, seeded with the originating user and the workflow process and item type to invoke.
• SET_OBJECT_DETAILS — Workflow activity function that populates the workflow item attributes with the object detail values used by subsequent approval steps.
• REVERT_STATUS — Workflow activity that rolls the object’s user status back when an approval is cancelled or an error unwinds the transaction.
• SET_APPROVER_DETAILS — Workflow activity that derives and sets the approver information for the current approval activity.
• ABORTPROCESS — Terminates an in-flight approval workflow and performs associated cleanup.
• GET_API_NAME — Returns the API identifier used to update the target object, allowing the generic engine to operate against different object types.
• APPROVAL_REQUIRED — Determines whether the submitted object actually requires approval, based on the configured object rules.
• UPDATE_STATUS — Applies a status change to the object after a decision is rendered.
• APPROVED_UPDATE_STATUS — Status transition handler for the approved branch.
• REJECT_UPDATE_STATUS — Status transition handler for the rejected branch.
• HANDLE_ERR — Central error handler; collects message count/data and drives error notification.
• NTF_APPROVAL, NTF_APPROVAL_REMINDER — Notification routines that send the approval request and its follow-up reminder to approvers.
• NTF_FORWARD_FYI, NTF_APPROVED_FYI, NTF_REJECTED_FYI — Informational notifications issued when a notification is forwarded and when the result is approval or rejection.
• NTF_REQUESTOR_OF_ERROR — Sends the error notification to the requestor when the workflow fails, enabling the originating user to correct the problem and resubmit.

Tables Accessed

The package’s documented table references, resolved through APPS synonyms, are:

• AMW_OBJECT_RULES — Configuration of approval rules per object type; read to decide whether approval is required and which workflow process applies.
• FND_USER — Resolves user identities for approvers, requestors, and notification recipients.
• DUAL — Utility queries for single-row values.

Object status updates themselves are performed through the object-specific APIs identified by GET_API_NAME rather than by direct DML in this package.

Usage Notes

AMW_GEN_APPROVAL_PVT is a private API and is not intended for direct customer invocation; Oracle’s own Engineering forms and Workflow definitions call it. Deployment teams typically interact with it only through troubleshooting: a search on NTF_REQUESTOR_OF_ERROR is commonly performed when users report receiving unexpected error notifications from an approval workflow, and the message text can be located in the notification tables using the Workflow notification APIs to reconstruct the failing item. The package is referenced by three other packages, so changes to its signature carry regression risk. In 12.1.1 and 12.2.2, diagnostic work should confirm the workflow item type, confirm that AMW_OBJECT_RULES is correctly configured, and review WFERROR and notification history before considering any patch or file-based customization, which would be excluded from support.