809: EXCEPTION WHEN NO_DATA_FOUND THEN
810: err_compare_tbl := SYSTEM.EGO_COMPARE_VIEW_TABLE();
811: err_compare_rec := SYSTEM.EGO_COMPARE_VIEW_REC('', '', '','', '', '','', '', '','', '','','','','');
812: --err_compare_rec.ATTR_GROUP_DISP_NAME := 'Encountered error, No search conducted';
813: err_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET_STRING('EGO', 'EGO_PERSON_INVALID');
814: err_compare_tbl.EXTEND();
815: err_compare_tbl(1) := err_compare_rec;
816: Debug_Message('Error - '||err_compare_rec.ATTR_GROUP_DISP_NAME);
817: Debug_Message('Done GET_COMPARED_DATA with error');
833: is_pdh_batch := FALSE;
834: END IF; -- IF p_ss_code = EGO_IMPORT_PVT.get_pdh_source_system_id THEN
835:
836: l_is_policy := 'N';
837: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
838: l_primay_ag_disp_name := FND_MESSAGE.GET();
839: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
840: l_primary_ag_int_name := FND_MESSAGE.GET();
841: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
834: END IF; -- IF p_ss_code = EGO_IMPORT_PVT.get_pdh_source_system_id THEN
835:
836: l_is_policy := 'N';
837: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
838: l_primay_ag_disp_name := FND_MESSAGE.GET();
839: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
840: l_primary_ag_int_name := FND_MESSAGE.GET();
841: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
842: l_item_lable := FND_MESSAGE.GET();
835:
836: l_is_policy := 'N';
837: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
838: l_primay_ag_disp_name := FND_MESSAGE.GET();
839: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
840: l_primary_ag_int_name := FND_MESSAGE.GET();
841: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
842: l_item_lable := FND_MESSAGE.GET();
843: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
836: l_is_policy := 'N';
837: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
838: l_primay_ag_disp_name := FND_MESSAGE.GET();
839: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
840: l_primary_ag_int_name := FND_MESSAGE.GET();
841: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
842: l_item_lable := FND_MESSAGE.GET();
843: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
844: l_itemOrg_lable := FND_MESSAGE.GET();
837: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
838: l_primay_ag_disp_name := FND_MESSAGE.GET();
839: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
840: l_primary_ag_int_name := FND_MESSAGE.GET();
841: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
842: l_item_lable := FND_MESSAGE.GET();
843: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
844: l_itemOrg_lable := FND_MESSAGE.GET();
845: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
838: l_primay_ag_disp_name := FND_MESSAGE.GET();
839: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
840: l_primary_ag_int_name := FND_MESSAGE.GET();
841: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
842: l_item_lable := FND_MESSAGE.GET();
843: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
844: l_itemOrg_lable := FND_MESSAGE.GET();
845: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
846: l_itemSup_lable := FND_MESSAGE.GET();
839: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
840: l_primary_ag_int_name := FND_MESSAGE.GET();
841: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
842: l_item_lable := FND_MESSAGE.GET();
843: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
844: l_itemOrg_lable := FND_MESSAGE.GET();
845: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
846: l_itemSup_lable := FND_MESSAGE.GET();
847: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
840: l_primary_ag_int_name := FND_MESSAGE.GET();
841: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
842: l_item_lable := FND_MESSAGE.GET();
843: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
844: l_itemOrg_lable := FND_MESSAGE.GET();
845: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
846: l_itemSup_lable := FND_MESSAGE.GET();
847: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
848: l_itemSupSite_lable := FND_MESSAGE.GET();
841: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
842: l_item_lable := FND_MESSAGE.GET();
843: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
844: l_itemOrg_lable := FND_MESSAGE.GET();
845: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
846: l_itemSup_lable := FND_MESSAGE.GET();
847: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
848: l_itemSupSite_lable := FND_MESSAGE.GET();
849: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');
842: l_item_lable := FND_MESSAGE.GET();
843: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
844: l_itemOrg_lable := FND_MESSAGE.GET();
845: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
846: l_itemSup_lable := FND_MESSAGE.GET();
847: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
848: l_itemSupSite_lable := FND_MESSAGE.GET();
849: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');
850: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();
843: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
844: l_itemOrg_lable := FND_MESSAGE.GET();
845: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
846: l_itemSup_lable := FND_MESSAGE.GET();
847: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
848: l_itemSupSite_lable := FND_MESSAGE.GET();
849: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');
850: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();
851: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_REVISION');
844: l_itemOrg_lable := FND_MESSAGE.GET();
845: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
846: l_itemSup_lable := FND_MESSAGE.GET();
847: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
848: l_itemSupSite_lable := FND_MESSAGE.GET();
849: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');
850: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();
851: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_REVISION');
852: l_itemRev_lable := FND_MESSAGE.GET();
845: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
846: l_itemSup_lable := FND_MESSAGE.GET();
847: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
848: l_itemSupSite_lable := FND_MESSAGE.GET();
849: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');
850: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();
851: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_REVISION');
852: l_itemRev_lable := FND_MESSAGE.GET();
853:
846: l_itemSup_lable := FND_MESSAGE.GET();
847: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
848: l_itemSupSite_lable := FND_MESSAGE.GET();
849: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');
850: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();
851: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_REVISION');
852: l_itemRev_lable := FND_MESSAGE.GET();
853:
854: l_compare_tbl := SYSTEM.EGO_COMPARE_VIEW_TABLE();
847: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
848: l_itemSupSite_lable := FND_MESSAGE.GET();
849: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');
850: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();
851: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_REVISION');
852: l_itemRev_lable := FND_MESSAGE.GET();
853:
854: l_compare_tbl := SYSTEM.EGO_COMPARE_VIEW_TABLE();
855: l_compare_rec := SYSTEM.EGO_COMPARE_VIEW_REC('', '', '','','','','','','','','','','','','');
848: l_itemSupSite_lable := FND_MESSAGE.GET();
849: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');
850: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();
851: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_REVISION');
852: l_itemRev_lable := FND_MESSAGE.GET();
853:
854: l_compare_tbl := SYSTEM.EGO_COMPARE_VIEW_TABLE();
855: l_compare_rec := SYSTEM.EGO_COMPARE_VIEW_REC('', '', '','','','','','','','','','','','','');
856:
1187:
1188: IF p_supplier_id IS NOT NULL THEN
1189: l_supplier_rows_count := l_supplier_rows_count + 1;
1190: l_compare_tbl.extend();
1191: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
1192: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1193: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_NAME');
1194: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1195: -- Get the supplier Information
1188: IF p_supplier_id IS NOT NULL THEN
1189: l_supplier_rows_count := l_supplier_rows_count + 1;
1190: l_compare_tbl.extend();
1191: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
1192: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1193: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_NAME');
1194: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1195: -- Get the supplier Information
1196: l_temp_query := 'SELECT VENDOR_NAME FROM PO_VENDORS WHERE VENDOR_ID = :1 ';
1189: l_supplier_rows_count := l_supplier_rows_count + 1;
1190: l_compare_tbl.extend();
1191: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
1192: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1193: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_NAME');
1194: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1195: -- Get the supplier Information
1196: l_temp_query := 'SELECT VENDOR_NAME FROM PO_VENDORS WHERE VENDOR_ID = :1 ';
1197: EXECUTE IMMEDIATE l_temp_query into l_temp using p_supplier_id;
1190: l_compare_tbl.extend();
1191: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
1192: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1193: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_NAME');
1194: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1195: -- Get the supplier Information
1196: l_temp_query := 'SELECT VENDOR_NAME FROM PO_VENDORS WHERE VENDOR_ID = :1 ';
1197: EXECUTE IMMEDIATE l_temp_query into l_temp using p_supplier_id;
1198: l_compare_rec.SOURCE_SYS_VAL := l_temp;
1209:
1210: IF p_supplier_site_id IS NOT NULL THEN
1211: l_supplier_rows_count := l_supplier_rows_count + 1;
1212: l_compare_tbl.extend();
1213: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
1214: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1215: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_SITE');
1216: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1217: -- Get the supplier Information
1210: IF p_supplier_site_id IS NOT NULL THEN
1211: l_supplier_rows_count := l_supplier_rows_count + 1;
1212: l_compare_tbl.extend();
1213: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
1214: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1215: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_SITE');
1216: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1217: -- Get the supplier Information
1218: l_temp_query := 'SELECT VENDOR_SITE_CODE FROM PO_VENDOR_SITES_ALL WHERE VENDOR_SITE_ID = :1 ';
1211: l_supplier_rows_count := l_supplier_rows_count + 1;
1212: l_compare_tbl.extend();
1213: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
1214: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1215: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_SITE');
1216: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1217: -- Get the supplier Information
1218: l_temp_query := 'SELECT VENDOR_SITE_CODE FROM PO_VENDOR_SITES_ALL WHERE VENDOR_SITE_ID = :1 ';
1219: EXECUTE IMMEDIATE l_temp_query into l_temp using p_supplier_site_id;
1212: l_compare_tbl.extend();
1213: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
1214: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1215: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_SITE');
1216: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1217: -- Get the supplier Information
1218: l_temp_query := 'SELECT VENDOR_SITE_CODE FROM PO_VENDOR_SITES_ALL WHERE VENDOR_SITE_ID = :1 ';
1219: EXECUTE IMMEDIATE l_temp_query into l_temp using p_supplier_site_id;
1220: l_compare_rec.SOURCE_SYS_VAL := l_temp;