Search Results wsh_itm_response_headers_s

Overview

WSH_ITM_ASYN_MSGMAP_ASSISTANT is an internal PL/SQL package body owned by APPS that supports the Oracle E-Business Suite Item Management asynchronous message-mapping infrastructure. Its principal responsibility is post-processing of inbound and outbound EDI/XML messages handled by the WSH Item Management module, reconciling each processed message against the request-control and response-header records that drive the asynchronous message pipeline. The package records the outcome of message processing by updating request-control rows with the appropriate response header identifier and process flag, tracks denied-party screening results, and emits diagnostic output through the EBS debug framework.

The package defines package-level globals including a log level sourced from WSH_ITM_PARAMETER_SETUPS_B, a log filename, a UTL_FILE handle, current and previous request control identifiers, and a debug boolean. A single private helper, Initialize_Debug, and its counterpart, Close_Debug, are declared ahead of the main bodies. Every public procedure begins with Initialize_Debug and reads WSH_DEBUG_INTERFACE.g_debug, falling back to WSH_DEBUG_SV.is_debug_enabled when the flag is null, before routing messages through WSH_DEBUG_SV.Push and WSH_DEBUG_SV.Log.

Key Procedures and Functions

• INITIALIZE_DEBUG — Private helper invoked at the start of each procedure to open the debug context, evaluate log level, and prepare UTL_FILE output.
• TO / TOKENIZE_MESSAGEID / TOKENIZE_PARTYID — Tokenizing utilities that parse message and party identifiers from inbound message payloads so downstream mapping can key the correct business entities.
• INSERT_ERROR — Persists error information for failed or rejected messages to support reprocessing and audit.
• PROCESS_ACK_RECEIPT — Handles acknowledgement receipts returned by trading partners, driving status updates in the response tables.
• UPDATE_DENIED_PARTY_MATCH — Records denied-party screening outcomes against message records.
• GET_RESPONSE_HDR — Retrieves the response header record associated with a processed message.
• MESSAGE_POSTPROCESS — The central orchestration routine that finalises a message run, invoking update logic and closing the debug context.
• GET_VALID_REFERENCE_ID — Resolves a valid reference identifier used in message mapping.
• UPDATE_REQCTRL_REC — Documented in the excerpt; updates WSH_ITM_REQUEST_CONTROL with the response header and process flag for a given request control identifier.

Tables Accessed

• WSH_ITM_REQUEST_CONTROL — Updated with RESPONSE_HEADER_ID and PROCESS_FLAG by UPDATE_REQCTRL_REC; principal write target.
• WSH_ITM_PARAMETER_SETUPS_B — Read to obtain the item-management log level.
• WSH_ITM_RESPONSE_HEADERS and WSH_ITM_RESPONSE_HEADERS_S — Queried by GET_RESPONSE_HDR to resolve response header context.
• WSH_ITM_RESPONSE_LINES — Holds line-level response detail written during acknowledgement processing.
• DUAL, PLITBLM, UTL_FILE — Utility and PL/SQL table access for tokenisation and file-based debug logging.

Usage Notes

WSH_ITM_ASYN_MSGMAP_ASSISTANT is an internal technical package rather than a public API; ETRM classifies it as OTHER and records zero dependent packages. It is invoked from the asynchronous message-processing flow of the WSH Item Management module — typically triggered by the concurrent programs and workflow callbacks that ingest partner messages — rather than directly from Oracle Forms. Because it manipulates WSH_ITM_REQUEST_CONTROL and the response tables, customisations should avoid writing those tables independently. Debug output for the package is enabled through the standard EBS debug facilities (WSH_DEBUG_INTERFACE and WSH_DEBUG_SV), with Initialize_Debug acting as the entry point; the "initialize_debug" search term therefore points to the internal diagnostic hook used throughout this package. The header comment ($Header: WSHITMAB.pls 120.2 2007/08/06) dates the source to Release 12, and the package is present in both 12.1.1 and 12.2.2 installations.