364: END IF;
365: END IF;
366:
367: -- create the quantity tree
368: inv_quantity_tree_pvt.create_tree(
369: p_api_version_number => 1.0
370: , p_init_msg_lst => fnd_api.g_true
371: , x_return_status => l_return_status
372: , x_msg_count => l_msg_count
372: , x_msg_count => l_msg_count
373: , x_msg_data => l_msg_data
374: , p_organization_id => p_organization_id
375: , p_inventory_item_id => p_inventory_item_id
376: , p_tree_mode => inv_quantity_tree_pvt.g_reservation_mode
377: , p_is_revision_control => l_revision_control
378: , p_is_lot_control => l_lot_control
379: , p_is_serial_control => FALSE
380: , p_asset_sub_only => FALSE
499: debug_print('Trying to increase the Secondary Rsv Qty by '|| l_increase_secondary); -- INVCONV
500: END IF;
501:
502: --query quantity tree to make sure quantity is available to increase reservations
503: inv_quantity_tree_pvt.query_tree(
504: p_api_version_number => 1.0
505: , p_init_msg_lst => fnd_api.g_true
506: , x_return_status => l_return_status
507: , x_msg_count => l_msg_count
611: IF (l_debug = 1) THEN
612: debug_print('Reservation doesnt exists');
613: END IF;
614:
615: inv_quantity_tree_pvt.query_tree(
616: p_api_version_number => 1.0
617: , p_init_msg_lst => fnd_api.g_true
618: , x_return_status => l_return_status
619: , x_msg_count => l_msg_count
1017:
1018: RAISE fnd_api.g_exc_unexpected_error;
1019: END IF;
1020:
1021: inv_quantity_tree_pvt.clear_quantity_cache;
1022: x_return_status := fnd_api.g_ret_sts_success;
1023:
1024: EXCEPTION
1025: WHEN fnd_api.g_exc_error THEN
1254:
1255: RAISE fnd_api.g_exc_unexpected_error;
1256: END IF;
1257:
1258: inv_quantity_tree_pvt.clear_quantity_cache;
1259:
1260: x_return_status := fnd_api.g_ret_sts_success;
1261: EXCEPTION
1262: WHEN fnd_api.g_exc_error THEN