DBA Data[Home] [Help]

APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on INV_PICK_RELEASE_PUB

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

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

Line 224: inv_pick_release_pub.reserve_Unconfirmed_Quantity

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

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

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

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

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

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

648: exit when get_mtlt_c%NOTFOUND;
649: mdebug('l_missing_quantity:'||l_missing_quantity);
650: mdebug('l_lot:'||l_lot);
651: -- for debugging
652: mdebug('Before calling: inv_pick_release_pub.reserve_Unconfirmed_Quantity');
653:
654: inv_pick_release_pub.reserve_Unconfirmed_Quantity
655: (
656: p_api_version => 1.0

Line 654: inv_pick_release_pub.reserve_Unconfirmed_Quantity

650: mdebug('l_lot:'||l_lot);
651: -- for debugging
652: mdebug('Before calling: inv_pick_release_pub.reserve_Unconfirmed_Quantity');
653:
654: inv_pick_release_pub.reserve_Unconfirmed_Quantity
655: (
656: p_api_version => 1.0
657: ,p_init_msg_list => fnd_api.g_false
658: ,p_commit => fnd_api.g_false

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

671: ,p_lot_number => l_lot
672: );
673:
674: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
675: mdebug(' inv_pick_release_pub.reserve_Unconfirmed_Quantity failed');
676: l_cc_transfer_flag := 'F';
677: l_lot_qty := l_lot_qty + l_missing_quantity;
678: END IF;
679:

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

685: l_missing_quantity := l_primary_qty;
686: mdebug('l_missing_quantity: '||l_missing_quantity);
687: l_lot_qty := 0;
688:
689: mdebug('Before calling: inv_pick_release_pub.reserve_Unconfirmed_Quantity');
690:
691: -- Calling Reserve Unconfirmed Quantity API (from INVPPCIB.pls)
692: inv_pick_release_pub.reserve_Unconfirmed_Quantity
693: (

Line 692: inv_pick_release_pub.reserve_Unconfirmed_Quantity

688:
689: mdebug('Before calling: inv_pick_release_pub.reserve_Unconfirmed_Quantity');
690:
691: -- Calling Reserve Unconfirmed Quantity API (from INVPPCIB.pls)
692: inv_pick_release_pub.reserve_Unconfirmed_Quantity
693: (
694: p_api_version => 1.0
695: ,p_init_msg_list => fnd_api.g_false
696: ,p_commit => fnd_api.g_false

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

710: );
711: mdebug ('l_return_status : '|| l_return_status );
712:
713: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
714: mdebug(' inv_pick_release_pub.reserve_Unconfirmed_Quantity failed');
715: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR; -- ???? should we not raise exception??
716: -- and continue to do the pick release ??? need answers
717: l_cc_transfer_flag := 'F';
718: l_lot_qty := l_missing_quantity;

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

719: END IF;
720: end if;
721:
722: -- for debugging
723: mdebug('After calling: inv_pick_release_pub.reserve_Unconfirmed_Quantity');
724:
725: ELSE
726:
727: mdebug('l_reservation_id is null');