DBA Data[Home] [Help]

APPS.EGO_IMPORT_BATCH_COMPARE_PVT dependencies on FND_MESSAGE

Line 814: err_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET_STRING('EGO', 'EGO_PERSON_INVALID');

810: EXCEPTION WHEN NO_DATA_FOUND THEN
811: err_compare_tbl := SYSTEM.EGO_COMPARE_VIEW_TABLE();
812: err_compare_rec := SYSTEM.EGO_COMPARE_VIEW_REC('', '', '','', '', '','', '', '','', '','','','','');
813: --err_compare_rec.ATTR_GROUP_DISP_NAME := 'Encountered error, No search conducted';
814: err_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET_STRING('EGO', 'EGO_PERSON_INVALID');
815: err_compare_tbl.EXTEND();
816: err_compare_tbl(1) := err_compare_rec;
817: Debug_Message('Error - '||err_compare_rec.ATTR_GROUP_DISP_NAME);
818: Debug_Message('Done GET_COMPARED_DATA with error');

Line 838: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');

834: is_pdh_batch := FALSE;
835: END IF; -- IF p_ss_code = EGO_IMPORT_PVT.get_pdh_source_system_id THEN
836:
837: l_is_policy := 'N';
838: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
839: l_primay_ag_disp_name := FND_MESSAGE.GET();
840: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
841: l_primary_ag_int_name := FND_MESSAGE.GET();
842: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');

Line 839: l_primay_ag_disp_name := FND_MESSAGE.GET();

835: END IF; -- IF p_ss_code = EGO_IMPORT_PVT.get_pdh_source_system_id THEN
836:
837: l_is_policy := 'N';
838: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
839: l_primay_ag_disp_name := FND_MESSAGE.GET();
840: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
841: l_primary_ag_int_name := FND_MESSAGE.GET();
842: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
843: l_item_lable := FND_MESSAGE.GET();

Line 840: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');

836:
837: l_is_policy := 'N';
838: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
839: l_primay_ag_disp_name := FND_MESSAGE.GET();
840: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
841: l_primary_ag_int_name := FND_MESSAGE.GET();
842: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
843: l_item_lable := FND_MESSAGE.GET();
844: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');

Line 841: l_primary_ag_int_name := FND_MESSAGE.GET();

837: l_is_policy := 'N';
838: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
839: l_primay_ag_disp_name := FND_MESSAGE.GET();
840: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
841: l_primary_ag_int_name := FND_MESSAGE.GET();
842: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
843: l_item_lable := FND_MESSAGE.GET();
844: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
845: l_itemOrg_lable := FND_MESSAGE.GET();

Line 842: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');

838: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
839: l_primay_ag_disp_name := FND_MESSAGE.GET();
840: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
841: l_primary_ag_int_name := FND_MESSAGE.GET();
842: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
843: l_item_lable := FND_MESSAGE.GET();
844: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
845: l_itemOrg_lable := FND_MESSAGE.GET();
846: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');

Line 843: l_item_lable := FND_MESSAGE.GET();

839: l_primay_ag_disp_name := FND_MESSAGE.GET();
840: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
841: l_primary_ag_int_name := FND_MESSAGE.GET();
842: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
843: l_item_lable := FND_MESSAGE.GET();
844: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
845: l_itemOrg_lable := FND_MESSAGE.GET();
846: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
847: l_itemSup_lable := FND_MESSAGE.GET();

Line 844: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');

840: FND_MESSAGE.SET_NAME('EGO', 'EGO_ERP_MAIN_ATTR_GRP');
841: l_primary_ag_int_name := FND_MESSAGE.GET();
842: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
843: l_item_lable := FND_MESSAGE.GET();
844: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
845: l_itemOrg_lable := FND_MESSAGE.GET();
846: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
847: l_itemSup_lable := FND_MESSAGE.GET();
848: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');

Line 845: l_itemOrg_lable := FND_MESSAGE.GET();

841: l_primary_ag_int_name := FND_MESSAGE.GET();
842: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
843: l_item_lable := FND_MESSAGE.GET();
844: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
845: l_itemOrg_lable := FND_MESSAGE.GET();
846: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
847: l_itemSup_lable := FND_MESSAGE.GET();
848: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
849: l_itemSupSite_lable := FND_MESSAGE.GET();

Line 846: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');

842: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM');
843: l_item_lable := FND_MESSAGE.GET();
844: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
845: l_itemOrg_lable := FND_MESSAGE.GET();
846: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
847: l_itemSup_lable := FND_MESSAGE.GET();
848: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
849: l_itemSupSite_lable := FND_MESSAGE.GET();
850: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');

Line 847: l_itemSup_lable := FND_MESSAGE.GET();

843: l_item_lable := FND_MESSAGE.GET();
844: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
845: l_itemOrg_lable := FND_MESSAGE.GET();
846: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
847: l_itemSup_lable := FND_MESSAGE.GET();
848: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
849: l_itemSupSite_lable := FND_MESSAGE.GET();
850: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');
851: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();

Line 848: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');

844: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_ORGANIZATION');
845: l_itemOrg_lable := FND_MESSAGE.GET();
846: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
847: l_itemSup_lable := FND_MESSAGE.GET();
848: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
849: l_itemSupSite_lable := FND_MESSAGE.GET();
850: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');
851: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();
852: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_REVISION');

Line 849: l_itemSupSite_lable := FND_MESSAGE.GET();

845: l_itemOrg_lable := FND_MESSAGE.GET();
846: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
847: l_itemSup_lable := FND_MESSAGE.GET();
848: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
849: l_itemSupSite_lable := FND_MESSAGE.GET();
850: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');
851: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();
852: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_REVISION');
853: l_itemRev_lable := FND_MESSAGE.GET();

Line 850: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');

846: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
847: l_itemSup_lable := FND_MESSAGE.GET();
848: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
849: l_itemSupSite_lable := FND_MESSAGE.GET();
850: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');
851: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();
852: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_REVISION');
853: l_itemRev_lable := FND_MESSAGE.GET();
854:

Line 851: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();

847: l_itemSup_lable := FND_MESSAGE.GET();
848: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
849: l_itemSupSite_lable := FND_MESSAGE.GET();
850: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');
851: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();
852: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_REVISION');
853: l_itemRev_lable := FND_MESSAGE.GET();
854:
855: l_compare_tbl := SYSTEM.EGO_COMPARE_VIEW_TABLE();

Line 852: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_REVISION');

848: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
849: l_itemSupSite_lable := FND_MESSAGE.GET();
850: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');
851: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();
852: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_REVISION');
853: l_itemRev_lable := FND_MESSAGE.GET();
854:
855: l_compare_tbl := SYSTEM.EGO_COMPARE_VIEW_TABLE();
856: l_compare_rec := SYSTEM.EGO_COMPARE_VIEW_REC('', '', '','','','','','','','','','','','','');

Line 853: l_itemRev_lable := FND_MESSAGE.GET();

849: l_itemSupSite_lable := FND_MESSAGE.GET();
850: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE_STORE');
851: l_itemSupSiteOrg_lable := FND_MESSAGE.GET();
852: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_REVISION');
853: l_itemRev_lable := FND_MESSAGE.GET();
854:
855: l_compare_tbl := SYSTEM.EGO_COMPARE_VIEW_TABLE();
856: l_compare_rec := SYSTEM.EGO_COMPARE_VIEW_REC('', '', '','','','','','','','','','','','','');
857:

Line 1192: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');

1188:
1189: IF p_supplier_id IS NOT NULL THEN
1190: l_supplier_rows_count := l_supplier_rows_count + 1;
1191: l_compare_tbl.extend();
1192: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
1193: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1194: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_NAME');
1195: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1196: -- Get the supplier Information

Line 1193: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();

1189: IF p_supplier_id IS NOT NULL THEN
1190: l_supplier_rows_count := l_supplier_rows_count + 1;
1191: l_compare_tbl.extend();
1192: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
1193: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1194: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_NAME');
1195: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1196: -- Get the supplier Information
1197: l_temp_query := 'SELECT VENDOR_NAME FROM PO_VENDORS WHERE VENDOR_ID = :1 ';

Line 1194: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_NAME');

1190: l_supplier_rows_count := l_supplier_rows_count + 1;
1191: l_compare_tbl.extend();
1192: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
1193: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1194: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_NAME');
1195: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1196: -- Get the supplier Information
1197: l_temp_query := 'SELECT VENDOR_NAME FROM PO_VENDORS WHERE VENDOR_ID = :1 ';
1198: EXECUTE IMMEDIATE l_temp_query into l_temp using p_supplier_id;

Line 1195: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();

1191: l_compare_tbl.extend();
1192: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIER');
1193: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1194: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_NAME');
1195: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1196: -- Get the supplier Information
1197: l_temp_query := 'SELECT VENDOR_NAME FROM PO_VENDORS WHERE VENDOR_ID = :1 ';
1198: EXECUTE IMMEDIATE l_temp_query into l_temp using p_supplier_id;
1199: l_compare_rec.SOURCE_SYS_VAL := l_temp;

Line 1214: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');

1210:
1211: IF p_supplier_site_id IS NOT NULL THEN
1212: l_supplier_rows_count := l_supplier_rows_count + 1;
1213: l_compare_tbl.extend();
1214: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
1215: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1216: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_SITE');
1217: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1218: -- Get the supplier Information

Line 1215: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();

1211: IF p_supplier_site_id IS NOT NULL THEN
1212: l_supplier_rows_count := l_supplier_rows_count + 1;
1213: l_compare_tbl.extend();
1214: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
1215: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1216: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_SITE');
1217: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1218: -- Get the supplier Information
1219: l_temp_query := 'SELECT VENDOR_SITE_CODE FROM PO_VENDOR_SITES_ALL WHERE VENDOR_SITE_ID = :1 ';

Line 1216: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_SITE');

1212: l_supplier_rows_count := l_supplier_rows_count + 1;
1213: l_compare_tbl.extend();
1214: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
1215: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1216: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_SITE');
1217: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1218: -- Get the supplier Information
1219: l_temp_query := 'SELECT VENDOR_SITE_CODE FROM PO_VENDOR_SITES_ALL WHERE VENDOR_SITE_ID = :1 ';
1220: EXECUTE IMMEDIATE l_temp_query into l_temp using p_supplier_site_id;

Line 1217: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();

1213: l_compare_tbl.extend();
1214: FND_MESSAGE.SET_NAME('EGO', 'EGO_ITEM_SUPPLIR_SITE');
1215: l_compare_rec.ATTR_GROUP_DISP_NAME := FND_MESSAGE.GET();
1216: FND_MESSAGE.SET_NAME('EGO', 'EGO_SUPPLIER_SITE');
1217: l_compare_rec.ATTR_DISP_NAME := FND_MESSAGE.GET();
1218: -- Get the supplier Information
1219: l_temp_query := 'SELECT VENDOR_SITE_CODE FROM PO_VENDOR_SITES_ALL WHERE VENDOR_SITE_ID = :1 ';
1220: EXECUTE IMMEDIATE l_temp_query into l_temp using p_supplier_site_id;
1221: l_compare_rec.SOURCE_SYS_VAL := l_temp;