eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_013 dependencies on IGS_AD_IMP_001

Line 190: igs_ad_imp_001.logerrormessage(p_person_type_rec.interface_person_type_id,'E295');

186: SET status = '3',
187: error_code = 'E295'
188: WHERE interface_person_type_id = p_person_type_rec.interface_person_type_id;
189: IF l_enable_log = 'Y' THEN
190: igs_ad_imp_001.logerrormessage(p_person_type_rec.interface_person_type_id,'E295');
191: END IF;
192: RETURN;
193: END IF;
194: CLOSE date_overlap;

Line 213: igs_ad_imp_001.logerrormessage(p_person_type_rec.interface_person_type_id,'E585');

209: error_code = 'E585'
210: WHERE interface_person_type_id = p_person_type_rec.interface_person_type_id;
211:
212: IF l_enable_log = 'Y' THEN
213: igs_ad_imp_001.logerrormessage(p_person_type_rec.interface_person_type_id,'E585');
214: END IF;
215: RETURN;
216: END IF;
217: CLOSE emp_cat_status;

Line 284: igs_ad_imp_001.logerrormessage(p_person_type_rec.interface_person_type_id,l_error_code);

280: END IF;
281: END IF;
282:
283: IF l_enable_log = 'Y' THEN
284: igs_ad_imp_001.logerrormessage(p_person_type_rec.interface_person_type_id,l_error_code);
285: END IF;
286:
287:
288: UPDATE igs_pe_type_int

Line 369: igs_ad_imp_001.logerrormessage(p_person_type_rec.interface_person_type_id,'E295');

365: error_code = 'E295'
366: WHERE interface_person_type_id = p_person_type_rec.interface_person_type_id;
367:
368: IF l_enable_log = 'Y' THEN
369: igs_ad_imp_001.logerrormessage(p_person_type_rec.interface_person_type_id,'E295');
370: END IF;
371:
372: RETURN;
373: END IF;

Line 393: igs_ad_imp_001.logerrormessage(p_person_type_rec.interface_person_type_id,'E585');

389: error_code = 'E585'
390: WHERE interface_person_type_id = p_person_type_rec.interface_person_type_id;
391:
392: IF l_enable_log = 'Y' THEN
393: igs_ad_imp_001.logerrormessage(p_person_type_rec.interface_person_type_id,'E585');
394: END IF;
395:
396: RETURN;
397: END IF;

Line 465: igs_ad_imp_001.logerrormessage(p_person_type_rec.interface_person_type_id,l_error_code);

461: END IF;
462: END IF;
463:
464: IF l_enable_log = 'Y' THEN
465: igs_ad_imp_001.logerrormessage(p_person_type_rec.interface_person_type_id,l_error_code);
466: END IF;
467:
468: UPDATE igs_pe_type_int
469: SET status = '3',

Line 594: l_enable_log := igs_ad_imp_001.g_enable_log;

590: l_default_date := igs_ge_date.igsdate('9999/01/01');
591:
592: l_prog_label := 'igs.plsql.igs_ad_imp_013.prc_pe_type';
593: l_label := 'igs.plsql.igs_ad_imp_013.prc_pe_type.';
594: l_enable_log := igs_ad_imp_001.g_enable_log;
595: l_interface_run_id:=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.
596: -- Every child records needs to be updated with this value.
597:
598: -- If HRMS is installed and HR mapping is done then update all the staff/faculty records as invalid.

Line 595: l_interface_run_id:=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.

591:
592: l_prog_label := 'igs.plsql.igs_ad_imp_013.prc_pe_type';
593: l_label := 'igs.plsql.igs_ad_imp_013.prc_pe_type.';
594: l_enable_log := igs_ad_imp_001.g_enable_log;
595: l_interface_run_id:=igs_ad_imp_001.g_interface_run_id; -- fetching the interface run ID from the AD imp process.
596: -- Every child records needs to be updated with this value.
597:
598: -- If HRMS is installed and HR mapping is done then update all the staff/faculty records as invalid.
599: IF igs_en_gen_001.check_hrms_installed = 'Y' THEN

Line 618: igs_ad_imp_001.logerrormessage(l_staff_person_type_code,'E293');

614: status = '2' AND
615: pti.interface_run_id = l_interface_run_id;
616:
617: IF l_enable_log = 'Y' THEN
618: igs_ad_imp_001.logerrormessage(l_staff_person_type_code,'E293');
619: END IF;
620: END IF;
621:
622: CLOSE type_exist_cur;

Line 645: igs_ad_imp_001.logerrormessage(l_faculty_person_type_code,'E293');

641: status = '2' AND
642: interface_run_id = l_interface_run_id;
643:
644: IF l_enable_log = 'Y' THEN
645: igs_ad_imp_001.logerrormessage(l_faculty_person_type_code,'E293');
646: END IF;
647: END IF;
648: CLOSE type_exist_cur;
649: END IF;

Line 657: l_rule := igs_ad_imp_001.find_source_cat_rule(p_source_type_id, 'PERSON_TYPE');

653:
654: --
655: -- Fetching the discrepency rule before the loop.
656:
657: l_rule := igs_ad_imp_001.find_source_cat_rule(p_source_type_id, 'PERSON_TYPE');
658:
659:
660: -- 1. If the rule is E or I, and the match ind column is not null, update all the records to status 3 as they are invalids.
661:

Line 833: igs_ad_imp_001.logerrormessage(per_type_rec.interface_person_type_id,l_error_code);

829: error_code = l_error_code
830: WHERE interface_person_type_id = per_type_rec.interface_person_type_id;
831:
832: IF l_enable_log = 'Y' THEN
833: igs_ad_imp_001.logerrormessage(per_type_rec.interface_person_type_id,l_error_code);
834: END IF;
835: END IF;
836:
837: -- Commit for every 100 records..

Line 1357: igs_ad_imp_001.logerrormessage(person_history_rec.interface_acadhis_id,l_msg_data,'IGS_AD_ACAD_HIS_INT');

1353: l_error_text := l_msg_data;
1354: l_error_Code := NULL;
1355:
1356: IF p_enable_log = 'Y' THEN
1357: igs_ad_imp_001.logerrormessage(person_history_rec.interface_acadhis_id,l_msg_data,'IGS_AD_ACAD_HIS_INT');
1358: END IF;
1359: ELSE
1360: l_error_text := NULL;
1361: l_error_Code := 'E518';

Line 1428: igs_ad_imp_001.logerrormessage(person_history_rec.interface_acadhis_id,l_error_code,'IGS_AD_ACAD_HIS_INT');

1424: NULL, cst_mi_val_11,
1425: match_ind)
1426: WHERE INTERFACE_ACADHIS_ID = PERSON_HISTORY_REC.INTERFACE_ACADHIS_ID;
1427: IF p_enable_log = 'Y' THEN
1428: igs_ad_imp_001.logerrormessage(person_history_rec.interface_acadhis_id,l_error_code,'IGS_AD_ACAD_HIS_INT');
1429: END IF;
1430: END IF; -- end of ( l_error_code IS NULL )
1431: END crc_pe_acad_hist;
1432:

Line 1528: igs_ad_imp_001.logerrormessage(person_history_rec.interface_acadhis_id,l_msg_data,'IGS_AD_ACAD_HIS_INT');

1524: l_error_text := l_msg_data;
1525: l_error_Code := 'E014';
1526:
1527: IF p_enable_log = 'Y' THEN
1528: igs_ad_imp_001.logerrormessage(person_history_rec.interface_acadhis_id,l_msg_data,'IGS_AD_ACAD_HIS_INT');
1529: END IF;
1530: ELSE
1531: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
1532: l_error_Code := 'E518';

Line 1605: igs_ad_imp_001.logerrormessage(person_history_rec.interface_acadhis_id,l_error_code,'IGS_AD_ACAD_HIS_INT');

1601: match_ind),
1602: education_id = c_null_hdlg_acad_hist_cur_rec.Education_Id
1603: WHERE INTERFACE_ACADHIS_ID = PERSON_HISTORY_REC.INTERFACE_ACADHIS_ID;
1604: IF p_enable_log = 'Y' THEN
1605: igs_ad_imp_001.logerrormessage(person_history_rec.interface_acadhis_id,l_error_code,'IGS_AD_ACAD_HIS_INT');
1606: END IF;
1607: END IF; --validation fails
1608:
1609: END upd_pe_acad_hist;

Line 2278: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,l_error_code,'IGS_PE_CRED_INT');

2274: , error_code = l_error_code
2275: WHERE rowid = cp_pe_cr_rec.rowid ;
2276: -- Here it is assumed that validate_pe_cred procedure can only return status values '1' or '3'
2277: IF p_enable_log = 'Y' THEN
2278: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,l_error_code,'IGS_PE_CRED_INT');
2279: END IF;
2280:
2281: END IF;
2282:

Line 2298: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,l_msg_data,'IGS_PE_CRED_INT');

2294: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
2295: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
2296: l_error_text := l_msg_data;
2297: IF p_enable_log = 'Y' THEN
2298: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,l_msg_data,'IGS_PE_CRED_INT');
2299: END IF;
2300: ELSE
2301: l_error_text := NULL;
2302: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

Line 2401: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,'E322','IGS_PE_CRED_INT');

2397: WHERE rowid = cp_pe_cr_rec.rowid ;
2398:
2399: -- Here it is assumed that validate_pe_cred procedure can only return status values '1' or '3'
2400: IF p_enable_log = 'Y' THEN
2401: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,'E322','IGS_PE_CRED_INT');
2402: END IF;
2403:
2404: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
2405:

Line 2435: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,l_msg_data,'IGS_PE_CRED_INT');

2431: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
2432: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
2433: l_error_text := l_msg_data;
2434: IF p_enable_log = 'Y' THEN
2435: igs_ad_imp_001.logerrormessage(cp_pe_cr_rec.interface_cred_id,l_msg_data,'IGS_PE_CRED_INT');
2436: END IF;
2437: ELSE
2438: l_error_text := NULL;
2439: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN