Search Results log_interface_errors




Overview
Explore in AI Chat

Overview

APPS.WSH_INTERFACE_VALIDATIONS_PKG is a server-side PL/SQL package within the Oracle E-Business Suite Shipping (WSH) module. It provides validation logic for the receipt of shipping-related interface records, most notably documents exchanged with trading partners via Oracle EDI Gateway (ECX) and the delivery and delivery-detail open interfaces. Its primary role is to verify inbound and outbound document references and to reconcile ship request and ship advice data before those records are processed by downstream shipping and order management routines.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the definer, which is typical of interface validation routines that must run in the context of a calling concurrent program or API. It relies on the WSH_DEBUG_SV utility for debug-level tracing and defines the record type Interface_errors_rec_type to hold error message names, tokens, values, and the associated interface table name and identifier. This structure allows validation failures to be captured against APPS.WSH_INTERFACE_ERRORS for later review and reprocessing.

Key Procedures and Functions

  • VALIDATE_DOCUMENT — The central routine associated with the user's search term. It validates a shipping document based on document type, document number, trading partner code, action type, document direction, and original document number, returning the resolved trading partner identifier, a validation flag, and a return status. This procedure is used to confirm that a document referenced on an inbound or outbound interface record is valid and that the trading partner can be resolved.
  • VALIDATE_DELIVERIES — Validates a delivery identified by its delivery identifier, returning a status. It confirms delivery integrity prior to interface processing.
  • COMPARE_SHIP_REQUEST_ADVICE — Reconciles a ship request (typically an outbound delivery request) against a corresponding ship advice (the partner's confirmation), using the delivery identifier and returning a status. This supports the comparison logic needed to detect discrepancies between requested and advised shipments.
  • GET_CLIENT_DETAILS — Retrieves client-level parameter details, supporting the validation context for the shipping organization and partner.
  • LOG_INTERFACE_ERRORS — Writes validation failures into the WSH_INTERFACE_ERRORS table using the Interface_errors_rec_type record structure.
  • NAME — A utility routine within the package (name identification) used internally by the validation flow.

Tables Accessed

The package reads and writes several interface and reference tables through APPS synonyms. Validation errors are recorded in WSH_INTERFACE_ERRORS (and its sequence WSH_INTERFACE_ERRORS_S). Trading partner resolution uses ECX_TP_HEADERS, while client and organization context is drawn from MTL_CLIENT_PARAMETERS, MTL_PARAMETERS, and HR_ORGANIZATION_INFORMATION. Delivery validation and reconciliation touch WSH_DELIVERY_ASSIGNMENTS, WSH_DELIVERY_DETAILS, WSH_NEW_DELIVERIES, and their interface counterparts WSH_DEL_ASSGN_INTERFACE, WSH_DEL_DETAILS_INTERFACE, and WSH_NEW_DEL_INTERFACE. Order and requisition references are validated through OE_ORDER_LINES_ALL, PO_REQUISITION_HEADERS_ALL, and PO_REQUISITION_LINES_ALL.

Usage Notes

WSH_INTERFACE_VALIDATIONS_PKG is generally invoked by shipping open interface concurrent programs, the EDI Gateway inbound and outbound processing flows, and custom PL/SQL that stages delivery or delivery-detail interface records. The metadata indicates it is referenced by five other packages, confirming its role as a shared validation layer. When a customer or developer searches for "validate_document," the reference is to the VALIDATE_DOCUMENT procedure, which is the entry point for document-level validation within this package and is typically called before interface records are promoted into the production shipping tables.