DBA Data[Home] [Help]

APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on INV_PICK_RELEASE_PUB

Line 222: mdebug('Before calling: inv_pick_release_pub.reserve_Unconfirmed_Quantity');

218: END IF;
219:
220: -- for debugging
221: IF (l_debug = 1) THEN
222: mdebug('Before calling: inv_pick_release_pub.reserve_Unconfirmed_Quantity');
223: END IF;
224:
225: -- Calling Reserve Unconfirmed Quantity API (from INVPPCIB.pls)
226: inv_pick_release_pub.reserve_Unconfirmed_Quantity

Line 226: inv_pick_release_pub.reserve_Unconfirmed_Quantity

222: mdebug('Before calling: inv_pick_release_pub.reserve_Unconfirmed_Quantity');
223: END IF;
224:
225: -- Calling Reserve Unconfirmed Quantity API (from INVPPCIB.pls)
226: inv_pick_release_pub.reserve_Unconfirmed_Quantity
227: (
228: p_api_version => 1.0
229: ,p_init_msg_list => fnd_api.g_false
230: ,p_commit => fnd_api.g_false

Line 251: mdebug(' inv_pick_release_pub.reserve_Unconfirmed_Quantity failed');

247: END IF;
248:
249: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
250: IF (l_debug = 1) THEN
251: mdebug(' inv_pick_release_pub.reserve_Unconfirmed_Quantity failed');
252: END IF;
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
255:

Line 258: mdebug('After calling: inv_pick_release_pub.reserve_Unconfirmed_Quantity');

254: END IF;
255:
256: -- for debugging
257: IF (l_debug = 1) THEN
258: mdebug('After calling: inv_pick_release_pub.reserve_Unconfirmed_Quantity');
259: END IF;
260: IF (l_debug = 1) THEN
261: mdebug('Before calling: log_exception');
262: END IF;

Line 708: mdebug('Before calling: inv_pick_release_pub.reserve_Unconfirmed_lpn');

704: EXIT WHEN get_mtlt_c%NOTFOUND;
705: mdebug('l_missing_quantity:'||l_missing_quantity);
706: mdebug('l_lot:'||l_lot);
707: mdebug('l_sec_missing_qty:'||l_sec_missing_qty);
708: mdebug('Before calling: inv_pick_release_pub.reserve_Unconfirmed_lpn');
709:
710: /* Bug 7504490 - Modified the call to the new API Reserve_Unconfqty_lpn for
711: both lpn and loose. Passing allocated_lpn_id to handle CC reservation for lpn*/
712:

Line 713: inv_pick_release_pub.Reserve_Unconfqty_lpn

709:
710: /* Bug 7504490 - Modified the call to the new API Reserve_Unconfqty_lpn for
711: both lpn and loose. Passing allocated_lpn_id to handle CC reservation for lpn*/
712:
713: inv_pick_release_pub.Reserve_Unconfqty_lpn
714: (
715: p_api_version => 1.0
716: ,p_init_msg_list => fnd_api.g_false
717: ,p_commit => fnd_api.g_false

Line 737: mdebug(' inv_pick_release_pub.Reserve_Unconfqty_lpn failed');

733: ,p_lpn_id => l_allocated_lpn_id
734: );
735:
736: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
737: mdebug(' inv_pick_release_pub.Reserve_Unconfqty_lpn failed');
738: l_cc_transfer_flag := 'F';
739: l_lot_qty := l_lot_qty + l_missing_quantity;
740: l_sec_lot_qty := l_sec_lot_qty + l_sec_missing_qty; --bug 8197499
741: END IF;

Line 786: mdebug('Before calling: inv_pick_release_pub.reserve_Unconfirmed_lpn');

782: --Bug 7504490 - Modified the call to the new API Reserve_Unconfqty_lpn for
783: --both lpn and loose. Passing allocated_lpn_id to handle CC reservation for lpn
784:
785:
786: mdebug('Before calling: inv_pick_release_pub.reserve_Unconfirmed_lpn');
787:
788: inv_pick_release_pub.Reserve_Unconfqty_lpn (
789: p_api_version => 1.0
790: ,p_init_msg_list => fnd_api.g_false

Line 788: inv_pick_release_pub.Reserve_Unconfqty_lpn (

784:
785:
786: mdebug('Before calling: inv_pick_release_pub.reserve_Unconfirmed_lpn');
787:
788: inv_pick_release_pub.Reserve_Unconfqty_lpn (
789: p_api_version => 1.0
790: ,p_init_msg_list => fnd_api.g_false
791: ,p_commit => fnd_api.g_false
792: ,x_return_status => l_return_status

Line 842: mdebug('After calling: inv_pick_release_pub.reserve_Unconfirmed_Quantity');

838: l_sec_lot_qty := l_sec_missing_qty; --bug 8197499
839: END IF;
840: END IF; -- End of l_allocated_lpn_id
841: END IF; --} End of Lot controlled.
842: mdebug('After calling: inv_pick_release_pub.reserve_Unconfirmed_Quantity');
843: ELSE
844: mdebug('l_reservation_id is null');
845: END IF;--}
846: END IF;--}

Line 1775: INV_PICK_RELEASE_PUB.g_pick_release_caller := 'WMS-PICK-EXCEPTION'; --9556463

1771: mdebug('Before calling: INV_Replenish_Detail_PUB.Line_Details_PUB ');
1772:
1773: l_detailed_qty := 0;
1774:
1775: INV_PICK_RELEASE_PUB.g_pick_release_caller := 'WMS-PICK-EXCEPTION'; --9556463
1776:
1777: inv_wip_picking_pvt.g_pick_release_caller := 'WMS-PICK-EXCEPTION'; -- added for bug 9895550
1778: inv_wip_picking_pvt.g_old_detailed_qty := l_old_quantity_detailed; -- added for bug 9895550
1779:

Line 1812: INV_PICK_RELEASE_PUB.g_pick_release_caller := NULL; --9556463

1808: END IF;
1809:
1810: --mdebug('After calling: INV_Replenish_Detail_PUB.Line_Details_PUB ');
1811:
1812: INV_PICK_RELEASE_PUB.g_pick_release_caller := NULL; --9556463
1813:
1814: mdebug('After calling: INV_Replenish_Detail_PUB.Line_Details_PUB: l_detailed_qty:' || l_detailed_qty);
1815: mdebug('After calling pick release: number_of_rows:'|| l_num_of_rows);
1816: mdebug(' v_transaction_temp_id : '|| v_transaction_temp_id);