DBA Data[Home] [Help]

APPS.WMS_RULE_EXTN_PVT dependencies on INV_QUANTITY_TREE_PVT

Line 166: INV_Quantity_Tree_PVT.Create_Tree

162: log_event(l_api_name, 'create_tree',
163: 'Trying to create quantity tree in exclusive mode');
164: End if;
165:
166: INV_Quantity_Tree_PVT.Create_Tree
167: (
168: p_api_version_number => 1.0
169: --,p_init_msg_list => fnd_api.g_false
170: ,x_return_status => x_return_status

Line 187: ,p_onhand_source => inv_quantity_tree_pvt.g_all_subs

183: ,p_demand_source_line_id => l_trx_source_line_id
184: ,p_demand_source_name => p_transaction_source_name
185: ,p_demand_source_delivery => p_trx_source_delivery_id
186: ,p_lot_expiration_date => sysdate
187: ,p_onhand_source => inv_quantity_tree_pvt.g_all_subs
188: ,p_exclusive => inv_quantity_tree_pvt.g_exclusive
189: ,p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
190: ,x_tree_id => x_tree_id
191: );

Line 188: ,p_exclusive => inv_quantity_tree_pvt.g_exclusive

184: ,p_demand_source_name => p_transaction_source_name
185: ,p_demand_source_delivery => p_trx_source_delivery_id
186: ,p_lot_expiration_date => sysdate
187: ,p_onhand_source => inv_quantity_tree_pvt.g_all_subs
188: ,p_exclusive => inv_quantity_tree_pvt.g_exclusive
189: ,p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
190: ,x_tree_id => x_tree_id
191: );
192: --

Line 189: ,p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes

185: ,p_demand_source_delivery => p_trx_source_delivery_id
186: ,p_lot_expiration_date => sysdate
187: ,p_onhand_source => inv_quantity_tree_pvt.g_all_subs
188: ,p_exclusive => inv_quantity_tree_pvt.g_exclusive
189: ,p_pick_release => inv_quantity_tree_pvt.g_pick_release_yes
190: ,x_tree_id => x_tree_id
191: );
192: --
193: If (l_debug = 1) then

Line 649: ,INV_Quantity_Tree_PVT.g_transaction_mode

645: ,p_demand_source_header_id
646: ,p_demand_source_line_id
647: ,p_demand_source_detail
648: ,p_demand_source_name
649: ,INV_Quantity_Tree_PVT.g_transaction_mode
650: ,l_tree_id
651: );
652: if x_return_status = fnd_api.g_ret_sts_unexp_error then
653: raise fnd_api.g_exc_unexpected_error;

Line 665: inv_quantity_tree_pvt.update_quantities

661: IF l_debug = 1 THEN
662: log_statement(l_api_name, 'update_tree', 'Updating qty tree');
663: END IF;
664:
665: inv_quantity_tree_pvt.update_quantities
666: ( p_api_version_number => 1.0
667: , p_init_msg_lst => fnd_api.g_false
668: , x_return_status => x_return_status
669: , x_msg_count => x_msg_count

Line 678: , p_quantity_type => inv_quantity_tree_pvt.g_qs_txn

674: , p_subinventory_code => l_grp_sugg_rec.from_subinventory_code
675: , p_locator_id => l_grp_sugg_rec.from_locator_id
676: , p_primary_quantity => -1 * l_grp_sugg_rec.primary_quantity
677: , p_secondary_quantity => -1 * l_grp_sugg_rec.secondary_quantity -- INVCONV
678: , p_quantity_type => inv_quantity_tree_pvt.g_qs_txn
679: , x_qoh => l_qoh
680: , x_rqoh => l_rqoh
681: , x_qr => l_qr
682: , x_qs => l_qs

Line 698: log_statement(l_api_name, 'uerr_update_qty', 'Unexpected error in inv_quantity_tree_pvt.update_quantities');

694: );
695:
696: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
697: IF l_debug = 1 THEN
698: log_statement(l_api_name, 'uerr_update_qty', 'Unexpected error in inv_quantity_tree_pvt.update_quantities');
699: END IF;
700:
701: RAISE fnd_api.g_exc_unexpected_error;
702: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

Line 704: log_statement(l_api_name, 'err_update_qty', 'Error in inv_quantity_tree_pvt.update_quantities');

700:
701: RAISE fnd_api.g_exc_unexpected_error;
702: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
703: IF l_debug = 1 THEN
704: log_statement(l_api_name, 'err_update_qty', 'Error in inv_quantity_tree_pvt.update_quantities');
705: END IF;
706: RAISE fnd_api.g_exc_error;
707: END IF;
708: