Search Results cancel_return_order_rtv




Overview
Explore in AI Chat

Overview

WMS_RETURN_SV is a server-side PL/SQL package in the APPS schema that supports Warehouse Management System (WMS) return, correction, and Return-To-Vendor (RTV) processing within Oracle E-Business Suite. It is declared with AUTHID CURRENT_USER and is classified as an OTHER API in the ETRM repository. The package provides the transactional logic required to unpack, mark, pack, and complete License Plate Number (LPN) based returns and corrections when the Inventory Manager is not invoked directly - notably for Return To Vendor and positive correction transactions where the parent transaction type is RECEIVING.

The package bridges the Receiving and WMS subsystems, allowing the Returns/Corrections forms and mobile return flows to manipulate container contents, generate reservations, update serial and lot interface tables, and drive post-transaction WMS updates. It is referenced by four other packages, confirming its role as a shared service within the inbound logistics layer.

Key Procedures and Functions

  • TXN_COMPLETE - Called from INVRCVFB.pls; unpacks LPNs for Return To Vendor and Correction transactions with parent transaction type RECEIVING.
  • MARK_RETURNS - Invoked from the Returns/Corrections form to mark selected LPN contents for return or correction.
  • UNMARK_RETURNS - Reverses the marking applied by MARK_RETURNS.
  • PACK_INTO_RECEIVING - Used by the Corrections form to pack and mark LPN contents selected for positive correction on RECEIVE, RETURN TO VENDOR, or RETURN TO CUSTOMER.
  • PROCESS_RETURNS - Core driver for executing the return transaction set against marked LPN contents (the object the user searched).
  • PROCESS_WHOLE_LPN_RETURN - Handles return processing when an entire LPN, rather than partial contents, is returned.
  • CREATE_UPDATE_CONTAINERS_RTV - Creates or updates container (LPN) records associated with Return To Vendor activity.
  • CANCEL_RETURN_ORDER_RTV - Cancels an RTV return order and reverses related container state.
  • PERFORM_POST_TM_WMS_UPDATES - Executes post-transaction WMS updates after the core inventory transaction completes.
  • RCV_PROCESS_WRAPPER - Wrapper that invokes receiving processing on behalf of the return flow.
  • GET_TRX_VALUES - Retrieves transaction attribute values for the return/correction being processed.
  • GET_SUGGESTED_TO_LPN - Returns a suggested destination LPN for the return.
  • GET_TRX_PROC_MODE - Determines the processing mode (ONLINE or IMMEDIATE) for a transaction.
  • GET_LPN_MARKED_STATUS - Returns whether an LPN is currently marked for return or correction.
  • CREATE_RETURN_RESV - Creates the reservation required to support the return.

Tables Accessed

The package reads and writes a defined set of APPS synonyms. Inventory master and transaction tables include MTL_SYSTEM_ITEMS, MTL_PARAMETERS, MTL_MATERIAL_TRANSACTIONS, and MTL_MATERIAL_TRANSACTIONS_S. Serial and lot handling relies on MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_INTERFACE, MTL_SERIAL_NUMBERS_TEMP, MTL_LOT_NUMBERS, MTL_TRANSACTION_LOTS_INTERFACE, MTL_TRANSACTION_LOTS_TEMP, and MTL_TRANSACTION_LOT_NUMBERS. Reservations and material movement rely on MTL_TXN_REQUEST_LINES. Receiving-side context is provided by PO_LINE_LOCATIONS_ALL, RCV_INTERFACE_GROUPS_S, and RCV_PARAMETERS. Together these tables supply the item, lot, serial, receiving, and reservation data needed to mark, pack, and complete returns without invoking the Inventory Manager directly.

Usage Notes

WMS_RETURN_SV is typically invoked from the Returns/Corrections forms and the mobile return flows, and is also callable from custom code that must process LPN-based returns. Callers should treat it as an internal server-side API: it is not a public, fully versioned interface, and parameter signatures should be confirmed against the deployed source before use. Supported modes include ONLINE and IMMEDIATE, selected via GET_TRX_PROC_MODE. Because the package writes transaction interface and serial/lot temp tables, callers must ensure the correct organization, subinventory, and locator context is set. In 12.1.1 and 12.2.2 the package header is unchanged from its 2004 baseline version, indicating a stable, legacy dependency shared by four other packages.