DBA Data[Home] [Help]

APPS.INV_EBI_ITEM_HELPER dependencies on INV_QUANTITY_TREE_PUB

Line 4236: Inv_Quantity_Tree_Pub.clear_quantity_cache;

4232: BEGIN
4233: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_HELPER.get_item_balance');
4234: x_return_status := fnd_api.g_ret_sts_success;
4235: l_item_balance_output_tbl := inv_ebi_item_bal_output_tbl();
4236: Inv_Quantity_Tree_Pub.clear_quantity_cache;
4237: IF p_item_balance_input.item_input_table IS NOT NULL THEN
4238: FOR i IN p_item_balance_input.item_input_table.FIRST..p_item_balance_input.item_input_table.LAST LOOP
4239: BEGIN
4240: l_item_balance_output_tbl.EXTEND();

Line 4256: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_QUANTITY_TREE_PUB.query_quantities');

4252: l_is_serial_control := TRUE;
4253: ELSE
4254: l_is_serial_control := FALSE;
4255: END IF;
4256: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_QUANTITY_TREE_PUB.query_quantities');
4257: INV_QUANTITY_TREE_PUB.query_quantities(
4258: p_api_version_number => p_item_balance_input.item_input_table(i).api_version_number
4259: ,p_init_msg_lst => p_item_balance_input.item_input_table(i).init_msg_lst
4260: ,p_organization_id => p_item_balance_input.item_input_table(i).organization_id

Line 4257: INV_QUANTITY_TREE_PUB.query_quantities(

4253: ELSE
4254: l_is_serial_control := FALSE;
4255: END IF;
4256: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_QUANTITY_TREE_PUB.query_quantities');
4257: INV_QUANTITY_TREE_PUB.query_quantities(
4258: p_api_version_number => p_item_balance_input.item_input_table(i).api_version_number
4259: ,p_init_msg_lst => p_item_balance_input.item_input_table(i).init_msg_lst
4260: ,p_organization_id => p_item_balance_input.item_input_table(i).organization_id
4261: ,p_inventory_item_id => p_item_balance_input.item_input_table(i).inventory_item_id

Line 4297: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_QUANTITY_TREE_PUB.query_quantities STATUS: '||l_return_status);

4293: ,x_return_status => l_return_status
4294: ,x_msg_count => l_msg_count
4295: ,x_msg_data => l_msg_data
4296: );
4297: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_QUANTITY_TREE_PUB.query_quantities STATUS: '||l_return_status);
4298: l_item_bal_output := inv_ebi_item_balance_obj(
4299: l_return_status
4300: ,l_msg_count
4301: ,l_msg_data

Line 4372: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_QUANTITY_TREE_PUB.query_quantities');

4368: ,p_item_balance_input.item_input_table(i).subinventory_code)
4369: LOOP
4370: l_locator_id := cer.locator_id;
4371: l_item_balance_loc_tbl.extend();
4372: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_QUANTITY_TREE_PUB.query_quantities');
4373: INV_Quantity_Tree_PUB.Query_Quantities(
4374: p_api_version_number => p_item_balance_input.item_input_table(i).api_version_number
4375: ,p_init_msg_lst => p_item_balance_input.item_input_table(i).init_msg_lst
4376: ,p_organization_id => p_item_balance_input.item_input_table(i).organization_id

Line 4373: INV_Quantity_Tree_PUB.Query_Quantities(

4369: LOOP
4370: l_locator_id := cer.locator_id;
4371: l_item_balance_loc_tbl.extend();
4372: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_QUANTITY_TREE_PUB.query_quantities');
4373: INV_Quantity_Tree_PUB.Query_Quantities(
4374: p_api_version_number => p_item_balance_input.item_input_table(i).api_version_number
4375: ,p_init_msg_lst => p_item_balance_input.item_input_table(i).init_msg_lst
4376: ,p_organization_id => p_item_balance_input.item_input_table(i).organization_id
4377: ,p_inventory_item_id => p_item_balance_input.item_input_table(i).inventory_item_id

Line 4413: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_QUANTITY_TREE_PUB.query_quantities STATUS: '||l_return_status);

4409: ,x_return_status => l_return_status
4410: ,x_msg_count => l_msg_count
4411: ,x_msg_data => l_msg_data
4412: );
4413: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_QUANTITY_TREE_PUB.query_quantities STATUS: '||l_return_status);
4414: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4415: l_msg_data := l_msg_data || ' -> Inventory Item Id:' || p_item_balance_input.item_input_table(i).inventory_item_id || ' -> Org Id: ' || p_item_balance_input.item_input_table(i).organization_id;
4416: RAISE FND_API.g_exc_unexpected_error;
4417: END IF;