[Home] [Help]
2166: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2167: )
2168: IS
2169: l_transaction_type VARCHAR2(20):=ego_item_pub.g_ttype_create;
2170: l_category_output inv_ebi_category_output_obj;
2171: l_output_status inv_ebi_output_status;
2172: BEGIN
2173: SAVEPOINT inv_ebi_cat_id_save_pnt;
2174: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');
2171: l_output_status inv_ebi_output_status;
2172: BEGIN
2173: SAVEPOINT inv_ebi_cat_id_save_pnt;
2174: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');
2175: l_category_output := inv_ebi_category_output_obj(NULL);
2176: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2177: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_category_output,NULL,NULL,NULL);
2178: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item_cat_assignment ');
2179: FOR i IN 1..p_category_id_tbl.COUNT LOOP
2580: l_organization_id NUMBER;
2581: l_organization_code VARCHAR2(3);
2582: l_item_number VARCHAR2(2000);
2583: l_output_status inv_ebi_output_status;
2584: l_category_output inv_ebi_category_output_obj;
2585:
2586: l_mfg_part_num_obj inv_ebi_manufacturer_part_obj;
2587: l_master_org_id NUMBER;
2588: l_manufacturer_count NUMBER := 0;
2652: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2653: x_out.output_status.msg_data := l_out.output_status.msg_data;
2654: RAISE fnd_api.g_exc_unexpected_error;
2655: END IF;
2656: l_category_output := inv_ebi_category_output_obj(l_out.category_output.error_code);
2657: l_master_org_id := INV_EBI_UTIL.get_master_organization(
2658: p_organization_id => p_item.main_obj_type.organization_id
2659: );
2660: