DBA Data[Home] [Help]

APPS.EGO_IMPORT_BATCH_COMPARE_PVT dependencies on FND_MESSAGE

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

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');

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

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');

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

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();

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

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');

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

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();

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

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');

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

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();

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

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');

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

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();

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

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');

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

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();

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

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');

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

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();

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

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:

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

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();

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

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('', '', '','','','','','','','','','','','','');

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

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:

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

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

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

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 ';

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

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;

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

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;

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

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

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

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 ';

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

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;

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

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;