DBA Data[Home] [Help]

APPS.INV_SERIAL_PICK_PKG dependencies on INV_QUANTITY_TREE_PUB

Line 192: l_tree_mode NUMBER := inv_quantity_tree_pub.g_transaction_mode;

188:
189: l_is_revision_control BOOLEAN;
190: l_is_lot_control BOOLEAN;
191:
192: l_tree_mode NUMBER := inv_quantity_tree_pub.g_transaction_mode;
193: l_quantity_type NUMBER := inv_quantity_tree_pvt.g_qoh;
194: l_onhand_source NUMBER := inv_quantity_tree_pvt.g_all_subs;
195: l_qoh NUMBER;
196: l_rqoh NUMBER;

Line 406: inv_quantity_tree_pub.clear_quantity_cache;

402: RAISE fnd_api.g_exc_unexpected_error;
403: end if;
404: end LOOP;
405: -- clean up the qty tree cache so that the qty tree can be rebuild
406: inv_quantity_tree_pub.clear_quantity_cache;
407: end if; --p_initial_serial
408: ELSIF l_ato_item = 1 THEN
409: if p_initial_serial = 'Y' then
410: FOR l_transaction_rec in MMTT_TEMP_ID LOOP

Line 537: inv_quantity_tree_pub.query_quantities

533: END IF;
534:
535:
536: -- Query the quantity tree for available to transact quantity
537: inv_quantity_tree_pub.query_quantities
538: (p_api_version_number => 1.0,
539: p_init_msg_lst => fnd_api.g_false,
540: x_return_status => x_return_status,
541: x_msg_count => l_msg_count,

Line 574: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

570: END IF;
571:
572: IF x_return_status <> fnd_api.g_ret_sts_success THEN
573: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
574: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
575: x_error_msg := fnd_message.get;
576:
577: RAISE fnd_api.g_exc_unexpected_error;
578: END IF;

Line 586: inv_quantity_tree_pub.update_quantities

582:
583: IF l_att > 0 THEN
584: -- Update the quantity tree so that the serial transaction is
585: -- reflected in the available quantity
586: inv_quantity_tree_pub.update_quantities
587: (p_api_version_number => 1.0,
588: p_init_msg_lst => fnd_api.g_false,
589: x_return_status => x_return_status,
590: x_msg_count => l_msg_count,

Line 617: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');

613: x_atr => l_atr);
614:
615: IF x_return_status <> fnd_api.g_ret_sts_success THEN
616: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
617: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
618: x_error_msg := fnd_message.get;
619: RAISE fnd_api.g_exc_unexpected_error;
620: END IF;
621: IF (l_debug = 1) THEN

Line 626: inv_quantity_tree_pub.update_quantities

622: debug('ATT in source: ' || l_att);
623: END IF;
624:
625: -- update the destionation qty bug # 2470050
626: inv_quantity_tree_pub.update_quantities
627: (p_api_version_number => 1.0,
628: p_init_msg_lst => fnd_api.g_false,
629: x_return_status => x_return_status,
630: x_msg_count => l_msg_count,

Line 657: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');

653: x_atr => l_atr);
654:
655: IF x_return_status <> fnd_api.g_ret_sts_success THEN
656: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
657: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
658: x_error_msg := fnd_message.get;
659: RAISE fnd_api.g_exc_unexpected_error;
660: END IF;
661: