Search Results set_msg_context

Overview

APPS.OE_STANDARD_WF is the standard Oracle Order Management workflow support package that provides the PL/SQL backbone for the Order Management transaction types driven by Oracle Workflow. It supplies the selector functions, message-handling utilities, and context-management routines required by the seeded order header, order line, and return workflows (OEOH, OEOL, OENH, OEBH, and OEAME). The package bridges the Sales Order form, the Order Management background workflow engine, and the underlying OM and Workflow tables, ensuring that notifications, error messages, and application context are managed consistently regardless of the calling environment.

The package exposes a small set of public globals — G_UPGRADE_MODE, G_SAVE_MESSAGES, G_RESET_APPS_CONTEXT, and G_USER_ID — that allow the caller to control whether messages are persisted, whether the item attributes on the Workflow header/line item are used to reset the application context, and whether the package runs in upgrade mode.

Key Procedures and Functions

• SET_MSG_CONTEXT — Establishes the messaging context (typically a process activity) so that subsequent error or exception messages are attributed to the correct workflow activity. This is the procedure most commonly referenced when developers search for set_msg_context.
• CLEAR_MSG_CONTEXT — Removes the current messaging context, ensuring that messages generated outside the workflow activity scope are not incorrectly attributed.
• SAVE_MESSAGES — Persists accumulated messages to the database for later retrieval; the caller can suppress persistence by toggling G_SAVE_MESSAGES.
• SAVE_MESSAGES_ON / SAVE_MESSAGES_OFF — Public toggles that set G_SAVE_MESSAGES.
• RESET_APPS_CONTEXT_ON / RESET_APPS_CONTEXT_OFF — Public toggles that govern whether the package resets the application context from the Workflow item attributes.
• UPGRADE_MODE_ON — Enables upgrade mode, used only by the OE cycle data upgrade to Workflow.
• STANDARD_BLOCK — The generic workflow activity function used by the OM workflow definitions.
• OEOH_SELECTOR, OEOL_SELECTOR, OENH_SELECTOR, OEBH_SELECTOR, OEAME_SELECTOR — Selector functions for the header, line, negotiation header, blanket header, and amendment workflows, choosing the correct subprocess based on transaction type and conditions.
• GET_SUPPLY_SOURCE_TYPE and GET_LINE_CATEGORY — Helper functions returning supply source type and line category values used during workflow processing.
• SET_EXCEPTION_MESSAGE and ADD_ERROR_ACTIVITY_MSG — Utilities for raising exception messages and adding error activity messages to the workflow process.

Tables Accessed

The package reads and writes OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, and OE_BLANKET_HEADERS_ALL to derive the context, item keys, and business attributes used by the workflows. It accesses WF_ITEMS and WF_PROCESS_ACTIVITIES to persist messages, associate them with the correct item key and activity, and to support context reset during workflow execution. All access is via APPS synonyms.

Usage Notes

OE_STANDARD_WF is invoked automatically by the seeded Order Management workflow definitions during order entry, booking, and fulfillment, and it is referenced by 48 other packages. Custom code should invoke SET_MSG_CONTEXT before raising workflow messages and CLEAR_MSG_CONTEXT afterward, toggling G_SAVE_MESSAGES only when the caller manages messages itself. The Sales Order form and the Workflow Background Engine call this package directly; a caller that has already established application context should disable RESET_APPS_CONTEXT to avoid redundant context resets.