Search Results oe_msg_pub

Overview

OE_MSG_PUB is the Order Management message-handling package body owned by the APPS schema. Its business function is to centralize the collection, storage, retrieval, and display of processing messages generated during order entry and order import workflows. Rather than writing ad-hoc error text to log files, Oracle Order Management forms, concurrent programs, and public APIs call into OE_MSG_PUB to accumulate messages against a processing context and later persist or surface them to users. Messages captured in this manner are written to the OE_PROCESSING_MSGS and OE_PROCESSING_MSGS_TL tables, which support the Processing Messages window and the order import corrections workflow.

The package is classified as a public (PUB) API, meaning it is supported for direct invocation by customer extensions and integrations. Its status is VALID, and it is referenced by 482 other database objects, confirming its role as a foundational utility across the Order Management module and dependent applications.

Key Procedures and Functions

The documented interface exposes 37 procedures and functions. The principal entry points include:

INITIALIZE — establishes the message-handling environment for a session or processing run.
SET_PROCESS_ACTIVITY, SET_MSG_CONTEXT, RESET_MSG_CONTEXT, UPDATE_MSG_CONTEXT, GET_MSG_CONTEXT — manage the context under which messages are collected, tying messages to a process, activity, and entity.
ADD, ADD_TEXT, ADD_EXC_MSG, BUILD_EXC_MSG — add messages to the in-memory stack, including free-text messages and messages derived from exception conditions.
GET, COUNT_MSG, COUNT_AND_GET, CHECK_MSG_LEVEL — retrieve accumulated messages, count them, and evaluate message severity to determine whether processing should continue.
DELETE_MSG, RESET — remove individual messages or clear the entire message stack.
SAVE_MESSAGES, INSERT_MESSAGE — persist buffered messages to the database.
DUMP_MSG, DUMP_LIST — output messages for diagnostic or logging purposes.

No parameter lists are reproduced here; refer to the ETRM or package source for exact signatures.

Tables Accessed

The package accesses the following documented objects, primarily through APPS synonyms:

OE_PROCESSING_MSGS / OE_PROCESSING_MSGS_TL — the primary message store, holding message rows and their translated text.
OE_MSG_ID_S — sequence used to generate message identifiers.
OE_ORDER_HEADERS_ALL / OE_ORDER_LINES_ALL — order header and line data used to associate messages with specific order entities.
FND_NEW_MESSAGES, FND_APPLICATION, FND_LANGUAGES — message dictionary and language metadata for resolving application-defined message text.

Usage Notes

OE_MSG_PUB is invoked from Order Management forms, order import concurrent programs, and public order APIs (such as OE_ORDER_PUB) whenever processing outcomes must be captured for user review. Custom code should follow the same pattern: initialize the context, add messages as processing proceeds, check message level to decide whether to continue, and save messages so they appear in the Processing Messages window. The dependency on FND_MSG_PUB, FND_API, and OE_DEBUG_PUB indicates integration with the standard EBS message and debugging frameworks.

PACKAGE BODY: APPS.OE_MSG_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_MSG_PUB, status:VALID,
PACKAGE BODY: APPS.OE_MSG_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_MSG_PUB, status:VALID,
PACKAGE: APPS.OE_PC_CONSTRAINTS_ADMIN_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_PC_CONSTRAINTS_ADMIN_PUB, status:VALID,
SYNONYM: APPS.OE_MSG_ID_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OE_MSG_ID_S, status:VALID,
PACKAGE BODY: APPS.OE_VALIDATE_SCH_LINE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_VALIDATE_SCH_LINE, status:VALID,
PACKAGE BODY: APPS.QP_GLOBALS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QP_GLOBALS, status:VALID,
PACKAGE BODY: APPS.OE_DEPENDENCIES_EXTN 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_DEPENDENCIES_EXTN, status:VALID,
PACKAGE BODY: APPS.OE_BLANKET_UTIL_MISC 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_BLANKET_UTIL_MISC, status:VALID,
PACKAGE BODY: APPS.OE_CREDIT_CHECK_GLOBALS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_CREDIT_CHECK_GLOBALS, status:VALID,
PACKAGE BODY: APPS.QP_GLOBALS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_GLOBALS, status:VALID,
PACKAGE: APPS.OE_PC_CONSTRAINTS_ADMIN_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_PC_CONSTRAINTS_ADMIN_PUB, status:VALID,
PACKAGE BODY: APPS.OE_HEADER_STATUS_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_HEADER_STATUS_PUB, status:VALID,
PACKAGE BODY: APPS.ONT_ICP_PROCESS_PACKAGE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ONT_ICP_PROCESS_PACKAGE, status:VALID,
PACKAGE BODY: APPS.OE_BLANKET_UTIL_MISC 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_BLANKET_UTIL_MISC, status:VALID,
PACKAGE BODY: APPS.OE_OPM_RMA_UTILS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_OPM_RMA_UTILS, status:VALID,
PACKAGE BODY: APPS.OE_VALIDATE_SCH_LINE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_VALIDATE_SCH_LINE, status:VALID,
PACKAGE BODY: APPS.OE_SERVICE_CREDIT_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_SERVICE_CREDIT_GRP, status:VALID,
PACKAGE BODY: APPS.OE_OPM_RMA_UTILS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_OPM_RMA_UTILS, status:VALID,
PACKAGE BODY: APPS.OE_DEPENDENCIES_EXTN 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_DEPENDENCIES_EXTN, status:VALID,
PACKAGE BODY: APPS.QP_OA_DELAYED_REQUESTS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QP_OA_DELAYED_REQUESTS_PVT, status:VALID,
PACKAGE BODY: APPS.OE_SERVICE_CREDIT_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_SERVICE_CREDIT_GRP, status:VALID,
PACKAGE BODY: APPS.OE_CREDIT_CHECK_GLOBALS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_CREDIT_CHECK_GLOBALS, status:VALID,
SYNONYM: APPS.OE_MSG_ID_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OE_MSG_ID_S, status:VALID,
PACKAGE BODY: APPS.OE_ADJ_PRIVILEGE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_ADJ_PRIVILEGE, status:VALID,
PACKAGE BODY: APPS.OE_VALIDATE_CONTRACT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_VALIDATE_CONTRACT, status:VALID,
PACKAGE BODY: APPS.OE_VALIDATE_AGREEMENT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_VALIDATE_AGREEMENT, status:VALID,
PACKAGE BODY: APPS.QP_VALIDATE_RQT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QP_VALIDATE_RQT, status:VALID,
SYNONYM: APPS.OE_PROCESSING_MSGS_TL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OE_PROCESSING_MSGS_TL, status:VALID,
PACKAGE BODY: APPS.OE_VALIDATE_ATTR 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_VALIDATE_ATTR, status:VALID,
PACKAGE BODY: APPS.OE_DUAL_UOM_HOOK 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_DUAL_UOM_HOOK, status:VALID,
PACKAGE BODY: APPS.QP_VALIDATE_QUALIFIER_RULES 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_VALIDATE_QUALIFIER_RULES, status:VALID,
PACKAGE BODY: APPS.OE_ORDER_CONTEXT_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_ORDER_CONTEXT_GRP, status:VALID,
PACKAGE BODY: APPS.OE_VALIDATE_CONTRACT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_VALIDATE_CONTRACT, status:VALID,
PACKAGE BODY: APPS.OE_VALIDATE_AGREEMENT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_VALIDATE_AGREEMENT, status:VALID,
PACKAGE BODY: APPS.OE_ORDER_CONTEXT_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_ORDER_CONTEXT_GRP, status:VALID,
PACKAGE BODY: APPS.OE_VALIDATE_PRICE_BREAK 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_VALIDATE_PRICE_BREAK, status:VALID,
PACKAGE BODY: APPS.QP_VALIDATE_CON 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QP_VALIDATE_CON, status:VALID,
PACKAGE BODY: APPS.OE_CREDIT_SUMMARIES_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_CREDIT_SUMMARIES_PKG, status:VALID,
PACKAGE BODY: APPS.QP_OA_DELAYED_REQUESTS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_OA_DELAYED_REQUESTS_PVT, status:VALID,
PACKAGE BODY: APPS.OE_CREDIT_SUMMARIES_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_CREDIT_SUMMARIES_PKG, status:VALID,
PACKAGE BODY: APPS.ONT_ICP_PROCESS_PACKAGE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ONT_ICP_PROCESS_PACKAGE, status:VALID,
PACKAGE BODY: APPS.QP_QP_FORM_CON 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QP_QP_FORM_CON, status:VALID,
PACKAGE BODY: APPS.CSF_DEBRIEF_CREATE_ORDER 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:CSF_DEBRIEF_CREATE_ORDER, status:VALID,
PACKAGE BODY: APPS.OE_ORDER_UPGRADE_UTIL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_ORDER_UPGRADE_UTIL, status:VALID,
PACKAGE BODY: APPS.QP_PRL_LOADER_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_PRL_LOADER_PUB, status:VALID,
PACKAGE BODY: APPS.OE_EXTERNAL_CREDIT_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_EXTERNAL_CREDIT_PUB, status:VALID,
PACKAGE BODY: APPS.QP_QP_FORM_FORMULA 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_QP_FORM_FORMULA, status:VALID,
PACKAGE BODY: APPS.QP_QP_FORM_SEG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_QP_FORM_SEG, status:VALID,
PACKAGE BODY: APPS.QP_QP_FORM_PSG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QP_QP_FORM_PSG, status:VALID,
PACKAGE BODY: APPS.OE_ORDER_IMPORT_INTEROP_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_ORDER_IMPORT_INTEROP_PUB, status:VALID,