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 513: ,INV_Quantity_Tree_PVT.g_transaction_mode

509: ,p_demand_source_header_id
510: ,p_demand_source_line_id
511: ,p_demand_source_detail
512: ,p_demand_source_name
513: ,INV_Quantity_Tree_PVT.g_transaction_mode
514: ,l_tree_id
515: );
516: if x_return_status = fnd_api.g_ret_sts_unexp_error then
517: raise fnd_api.g_exc_unexpected_error;

Line 529: inv_quantity_tree_pvt.update_quantities

525: IF l_debug = 1 THEN
526: log_statement(l_api_name, 'update_tree', 'Updating qty tree');
527: END IF;
528:
529: inv_quantity_tree_pvt.update_quantities
530: (
531: p_api_version_number => 1.0
532: , p_init_msg_lst => fnd_api.g_false
533: , x_return_status => x_return_status

Line 543: , p_quantity_type => inv_quantity_tree_pvt.g_qs_txn

539: , p_subinventory_code => l_grp_sugg_rec.from_subinventory_code
540: , p_locator_id => l_grp_sugg_rec.from_locator_id
541: , p_primary_quantity => -1 * l_grp_sugg_rec.primary_quantity
542: , p_secondary_quantity => -1 * l_grp_sugg_rec.secondary_quantity -- INVCONV
543: , p_quantity_type => inv_quantity_tree_pvt.g_qs_txn
544: , x_qoh => l_qoh
545: , x_rqoh => l_rqoh
546: , x_qr => l_qr
547: , x_qs => l_qs

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

559: );
560:
561: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
562: IF l_debug = 1 THEN
563: log_statement(l_api_name, 'uerr_update_qty', 'Unexpected error in inv_quantity_tree_pvt.update_quantities');
564: END IF;
565:
566: RAISE fnd_api.g_exc_unexpected_error;
567: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

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

565:
566: RAISE fnd_api.g_exc_unexpected_error;
567: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
568: IF l_debug = 1 THEN
569: log_statement(l_api_name, 'err_update_qty', 'Error in inv_quantity_tree_pvt.update_quantities');
570: END IF;
571: RAISE fnd_api.g_exc_error;
572: END IF;
573: