[Home] [Help]
3110: ,x_out OUT NOCOPY inv_ebi_item_output_obj
3111: )
3112: IS
3113:
3114: l_category_output inv_ebi_category_output_obj;
3115: l_output_status inv_ebi_output_status;
3116: l_category_id NUMBER;
3117: l_old_item_category NUMBER;
3118: l_no_multi_assign_cat_set_tbl FND_TABLE_OF_NUMBER;
3119: BEGIN
3120: SAVEPOINT inv_ebi_cat_id_save_pnt;
3121: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');
3122: INV_EBI_UTIL.debug_line('STEP 20: ITEM ID: '|| p_inventory_item_id || 'ORG ID: '|| p_organization_id);
3123: l_category_output := inv_ebi_category_output_obj(NULL);
3124: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
3125: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_category_output,NULL,NULL,NULL,NULL);
3126: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING EGO_ITEM_PUB.process_item_cat_assignment');
3127: l_no_multi_assign_cat_set_tbl :=FND_TABLE_OF_NUMBER();
4000: l_organization_id NUMBER;
4001: l_organization_code VARCHAR2(3);
4002: l_item_number VARCHAR2(2000);
4003: l_output_status inv_ebi_output_status;
4004: l_category_output inv_ebi_category_output_obj;
4005:
4006: l_mfg_part_num_obj inv_ebi_manufacturer_part_obj;
4007: l_master_org_id NUMBER;
4008: l_manufacturer_count NUMBER := 0;
4075: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4076: x_out.output_status.msg_data := l_out.output_status.msg_data;
4077: RAISE fnd_api.g_exc_unexpected_error;
4078: END IF;
4079: l_category_output := inv_ebi_category_output_obj(l_out.category_output.error_code);
4080: l_master_org_id := INV_EBI_UTIL.get_master_organization(
4081: p_organization_id => p_item.main_obj_type.organization_id
4082: );
4083: