[Home] [Help]
2507: -- COMMENT : This procedure is used to revert a matched transaction (ASN or
2508: -- RECEIPT)
2509: -- The following is the flow of this procedure -
2510: -- 1. If the txn type is 'ASN', then we directly call
2511: -- WSH_ASN_RECEIPT_PVT.Cancel_ASN with the action_code
2512: -- as 'REVERT_ASN'.
2513: -- 2. If the txn type is 'RECEIPT', then we do the following -
2514: -- > Call Revert_Details to revert the delivery details
2515: -- > Call Revert_Deliveries to rever the deliveries
2670: --
2671: -- Debug Statements
2672: --
2673: IF l_debug_on THEN
2674: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ASN_RECEIPT_PVT.CANCEL_ASN',WSH_DEBUG_SV.C_PROC_LEVEL);
2675: END IF;
2676: --
2677: WSH_ASN_RECEIPT_PVT.Cancel_ASN(
2678: p_header_id => p_shipment_header_id,
2673: IF l_debug_on THEN
2674: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ASN_RECEIPT_PVT.CANCEL_ASN',WSH_DEBUG_SV.C_PROC_LEVEL);
2675: END IF;
2676: --
2677: WSH_ASN_RECEIPT_PVT.Cancel_ASN(
2678: p_header_id => p_shipment_header_id,
2679: -- p_line_rec => l_line_rec,
2680: p_action_prms => l_cancel_asn_action_prms,
2681: x_return_status => l_return_status);
3221: -- p_shipment_header_id Shipment Header Id of the transaction
3222: -- p_transaction_type transaction type (ASN or RECEIPT)
3223: -- p_max_rcv_txn_id Not used any more.
3224: -- p_process_asn_rcv_flag Flag to decide whether to call
3225: -- WSH_ASN_RECEIPT_PVT.Process_Matched_Txns
3226: -- or not to match the ASN or Receipt.
3227: -- p_process_corr_rtv_flag Flag to decide whether to call
3228: -- WSH_RCV_CORR_RTV_TXN_PKG.
3229: -- process_corrections_and_rtv or not
3249: -- The following is flow of the procedure -
3250: -- 1. We check for the flags p_process_asn_rcv_flag and
3251: -- p_process_corr_rtv_flag. If the p_process_asn_rcv_flag
3252: -- is set to 'Y', then we call
3253: -- WSH_ASN_RECEIPT_PVT.Process_Matched_Txns to match the
3254: -- receipt or ASN. If the p_process_corr_rtv_flag is set to 'Y',
3255: -- then we call WSH_RCV_CORR_RTV_TXN_PKG.process_corrections_and_rtv
3256: -- to match the child transactions for the receipt.
3257: -- 2. Then we call WSH_INBOUND_TXN_HISTORY_PKG.post_process API
3260: -- 3. The APIs Process_Matched_Txns and process_corrections_and_rtv
3261: -- return the output parameter records that tell us whether
3262: -- the corresponding po shipment lines have been cancelled or closed.
3263: -- If the record count is greater than zero, then we call
3264: -- WSH_ASN_RECEIPT_PVT.cancel_close_pending_txns to cancel or
3265: -- close those respective lines.
3266: --========================================================================
3267: PROCEDURE match_shipments(
3268: p_api_version_number IN NUMBER,
3541: --{
3542: --l_action_prms.shipment_header_id := l_ib_del_det_rec.shipment_header_id;
3543: l_asn_rcv_action_prms.action_code := p_transaction_type;
3544: l_asn_rcv_action_prms.caller := 'WSH_IB_UI_MATCH';
3545: WSH_ASN_RECEIPT_PVT.Process_Matched_Txns(
3546: p_dd_rec => l_ib_del_det_rec,
3547: p_line_rec => l_line_rec,
3548: p_action_prms => l_asn_rcv_action_prms,
3549: p_shipment_header_id => l_ib_del_det_rec.shipment_header_id,
3659:
3660: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3661: IF (l_asn_rcv_po_cancel_rec.line_id.COUNT > 0 OR l_asn_rcv_po_close_rec.line_id.COUNT > 0 ) THEN
3662: --{
3663: WSH_ASN_RECEIPT_PVT.cancel_close_pending_txns(
3664: p_po_cancel_rec => l_asn_rcv_po_cancel_rec,
3665: p_po_close_rec => l_asn_rcv_po_close_rec,
3666: x_return_status => l_return_status);
3667: --
3680: END IF;
3681: --
3682: IF (l_rtv_corr_po_cancel_rec.line_id.COUNT > 0 OR l_rtv_corr_po_close_rec.line_id.COUNT > 0 ) THEN
3683: --{
3684: WSH_ASN_RECEIPT_PVT.cancel_close_pending_txns(
3685: p_po_cancel_rec => l_rtv_corr_po_cancel_rec,
3686: p_po_close_rec => l_rtv_corr_po_close_rec,
3687: x_return_status => l_return_status);
3688: --