Search Results iem_outbox_errors_s1

Overview

APPS.IEM_OUTBOX_PROC_PUB is a public PL/SQL package body within the Oracle E-Business Suite Interaction Center / Email Center (IEM) module. Its primary business function is to manage the outbound message lifecycle for the IEM Outbox: creating outbound messages, submitting them for processing, writing processing errors, generating automatic replies and notifications, and attaching supporting content such as body text and documents. The package is classified as a PUB API in the ETRM, indicating that it is intended for external invocation by other EBS modules, concurrent programs, or custom extensions, rather than being an internal-only implementation unit. It is documented against both EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes twelve documented procedures and functions, each corresponding to a distinct outbound-processing operation:

• CREATEOUTBOXMESSAGE — creates an outbound message record for subsequent processing.
• CANCELOUTBOXMESSAGE — cancels a previously created outbound message.
• SUBMITOUTBOXMESSAGE — submits an outbound message for delivery or downstream processing.
• WRITEOUTBOXERROR — records error information against an outbound message.
• CREATEAUTOREPLY — generates an automated reply message.
• INSERTBODYTEXT — inserts the body text of an outbound message.
• INSERTDOCUMENT — inserts a document as part of the outbound message content.
• ATTACHDOCUMENT — attaches a document to an outbound message.
• GETACCOUNTLIST — retrieves the list of email accounts relevant to outbound processing.
• REDIRECTMESSAGE — redirects a message to a different recipient or routing target.
• AUTOFORWARD — performs automatic forwarding of a message.
• CREATESRAUTONOTIFICATION — creates an automatic notification associated with a service request.

Tables Accessed

The package accesses its data through APPS synonyms. The core outbound infrastructure tables include IEM_OUTBOX_ERRORS and its sequence IEM_OUTBOX_ERRORS_S1 (used for error ID generation), IEM_MSG_PARTS (body and part content), IEM_ROUTE_RULES and IEM_ROUTE_CLASSIFICATIONS (routing determination), and IEM_RT_INTERACTIONS with IEM_RT_INTERACTIONS_S1 (runtime interaction tracking). Media content is handled through IEM_RT_MEDIA_ITEMS and IEM_RT_MEDIA_ITEMS_S1, while IEM_RT_PROC_EMAILS supports email processing. Interaction history is recorded in JTF_IH_INTERACTIONS. The package also references DUAL and PLITBLM, the standard Oracle-supplied objects for scalar queries and PL/SQL index-by table bulk operations. The user search term "iem_outbox_errors_s1" corresponds to the sequence that the package uses when inserting rows into IEM_OUTBOX_ERRORS, most commonly via WRITEOUTBOXERROR.

Usage Notes

IEM_OUTBOX_PROC_PUB is documented as not referenced by any other database object, meaning it is a top-level entry point rather than a dependency of another PL/SQL unit, although it is listed as referenced by one other package per the metadata. It depends on standard EBS foundation packages — FND_API, FND_MESSAGE, FND_MSG_PUB, and FND_PROFILE — indicating consistent use of the FND error-handling and message-stack conventions, including profile-option-driven behavior. It further depends on other IEM public packages (IEM_CLIENT_PUB, IEM_EMAILACCOUNT_PUB, IEM_MC_PUB). Typical invocations include Interaction Center and Email Center forms and processing flows, concurrent programs that dispatch or monitor outbound messages, and custom code that needs to create, submit, cancel, or diagnose outbound messages. When errors occur, the IEM_OUTBOX_ERRORS table and its sequence are the principal diagnostic targets for troubleshooting, and developers commonly query IEM_OUTBOX_ERRORS_S1 when tracing how error rows were generated.