Search Results process_header_lines

Overview

CLN_ACK_PO_PKG is an Oracle E-Business Suite PL/SQL package owned by APPS and classified under the OTHER API category. It belongs to the Collaborative Planning / Supply Chain Collaboration module (CLN prefix) and is responsible for processing purchase order acknowledgements exchanged between a buying organization and its suppliers. In Oracle EBS 12.1.1 and 12.2.2, the package parses inbound acknowledgement messages, resolves the referenced order header and line records, and records the resulting status or exception information into the collaboration history and workflow data structures. It also generates outbound update events that keep collaboration records synchronized when acknowledgement processing completes or fails.

Key Procedures and Functions

The package body exposes eight documented program units:

• PROCESS_HEADER — Primary entry point that validates and processes an acknowledgement message at the order header level, invoking line-level processing as required.
• PROCESS_HEADER_L — Logic-layer variant of header processing, handling the core acknowledgement workflow for a single header record.
• PROCESS_HEADER_LINES — Iterates over the lines associated with a header and applies acknowledgement logic to each line.
• PROCESS_HEADER_LINES_RN — Renamed or refactored counterpart of line processing, retained for backward compatibility with existing callers.
• PROCESS_HEADER_RN — Renamed or refactored counterpart of header processing, similarly retained for compatibility.
• LOAD_CHANGES — Loads pending change records into the package's working structures so they can be evaluated during acknowledgement processing.
• ACKPO_ERROR_HANDLER — Centralized error routine that captures and reports failures encountered while processing purchase order acknowledgements.
• CLN_GET_PO_ACK_CODE_RN — Retrieval function that returns the acknowledgement code associated with a purchase order, used to determine the acknowledgement outcome.
• UPDATE_COLL_FOR_HDR_ONLY_MSG — Updates collaboration records when a header-only message is received, that is, an acknowledgement that carries no line-level detail.

The source excerpt additionally shows helper logic such as IS_ALREADY_PROCESSED_LINE, which tracks previously seen line numbers in an associative array to detect duplicates, and RAISE_UPDATE_EVENT, which raises the collaboration update event and is invoked from PROCESS_HEADER_L.

Tables Accessed

• CLN_COLL_HIST_HDR — Collaboration history header, where acknowledgement processing results and status transitions are recorded.
• CLN_GENERIC_S — Generic collaboration setup or staging table supplying configuration and reference data.
• ECX_TP_HEADERS — EDI/XML transaction partner header table used to resolve trading partner and message context.
• WF_PARAMETER_LIST_T — Oracle Workflow parameter list type, used when raising business events with parameter payloads.
• PLITBLM — Standard EBS PL/SQL index-by table of VARCHAR2, used as an internal collection type.
• DUAL — Used for single-row queries and expression evaluation.

Usage Notes

The package is not referenced by any other database package, as confirmed by the ETRM metadata. It is therefore invoked directly by external callers — typically the Collaboration Planning concurrent programs, workflow activity functions, or thin custom code that receives supplier acknowledgement messages and needs to apply them to purchase orders. The debug level is controlled through the profile option CLN_DEBUG_LEVEL, with diagnostic output routed through CLN_DEBUG_PUB. When extending or troubleshooting acknowledgement processing, the PROCESS_HEADER and PROCESS_HEADER_LINES call chain is the primary path to trace, with ACKPO_ERROR_HANDLER providing the error capture point.