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_009 dependencies on IGS_AD_IMP_001

Line 106: l_enable_log := igs_ad_imp_001.g_enable_log;

102: BEGIN
103:
104: l_prog_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_p';
105: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_p.';
106: l_enable_log := igs_ad_imp_001.g_enable_log;
107:
108: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
109:
110: IF (l_request_id IS NULL) THEN

Line 212: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E002', p_match_ind => '13');

208:
209: p_match_ind := '13';
210:
211: IF l_enable_log = 'Y' THEN
212: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E002', p_match_ind => '13');
213: END IF;
214:
215: RETURN;
216: END IF;

Line 293: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E003', p_match_ind => '14');

289: WHERE interface_id = imp_person_rec.interface_id;
290: p_match_ind := '14';
291:
292: IF l_enable_log = 'Y' THEN
293: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E003', p_match_ind => '14');
294: END IF;
295:
296: RETURN;
297: END IF;

Line 310: igs_ad_imp_001.logerrormessage(p_record => p_d_interface_id, p_error => 'E001', p_match_ind => '24');

306: WHERE interface_id = p_d_interface_id;
307: p_match_ind := '24';
308:
309: IF l_enable_log = 'Y' THEN
310: igs_ad_imp_001.logerrormessage(p_record => p_d_interface_id, p_error => 'E001', p_match_ind => '24');
311: END IF;
312:
313: END IF;
314: END igs_ad_find_duplicates_imp_p;

Line 374: l_enable_log := igs_ad_imp_001.g_enable_log;

370: -- Call Log header
371:
372: l_prog_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_pp';
373: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_pp.';
374: l_enable_log := igs_ad_imp_001.g_enable_log;
375:
376: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
377:
378: IF (l_request_id IS NULL) THEN

Line 428: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);

424:
425: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
426: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
427: l_dsql_debug := fnd_dsql.get_text(TRUE);
428: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
429: */
430: LOOP
431: -- fetch a row
432: IF dbms_sql.fetch_rows(l_cursor_id) > 0 THEN

Line 474: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E002', p_match_ind => '13');

470: WHERE interface_id = imp_person_rec.interface_id;
471: p_match_ind := '13';
472:
473: IF l_enable_log = 'Y' THEN
474: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E002', p_match_ind => '13');
475: END IF;
476:
477: RETURN;
478: END IF;

Line 515: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);

511: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id1);
512:
513: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
514: l_dsql_debug := fnd_dsql.get_text(TRUE);
515: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
516: */
517:
518: LOOP
519: -- fetch a row

Line 567: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E003', p_match_ind => '14');

563:
564: p_match_ind := '14';
565:
566: IF l_enable_log = 'Y' THEN
567: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E003', p_match_ind => '14');
568: END IF;
569:
570: RETURN;
571: END IF;

Line 585: Igs_Ad_Imp_001.set_message('IGS_PE_PID_INFO_MISS');

581: WHERE interface_id = p_d_interface_id;
582: p_match_ind := '24';
583: IF l_enable_log = 'Y' THEN
584: --vrathi: Add specific message to log
585: Igs_Ad_Imp_001.set_message('IGS_PE_PID_INFO_MISS');
586: igs_ad_imp_001.logerrormessage(p_record => p_d_interface_id, p_error => 'E001', p_match_ind => '24');
587: END IF;
588: END IF;
589: END igs_ad_find_duplicates_imp_pp;

Line 586: igs_ad_imp_001.logerrormessage(p_record => p_d_interface_id, p_error => 'E001', p_match_ind => '24');

582: p_match_ind := '24';
583: IF l_enable_log = 'Y' THEN
584: --vrathi: Add specific message to log
585: Igs_Ad_Imp_001.set_message('IGS_PE_PID_INFO_MISS');
586: igs_ad_imp_001.logerrormessage(p_record => p_d_interface_id, p_error => 'E001', p_match_ind => '24');
587: END IF;
588: END IF;
589: END igs_ad_find_duplicates_imp_pp;
590:

Line 671: l_enable_log := igs_ad_imp_001.g_enable_log;

667: -- Call Log header
668:
669: l_prog_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_pa';
670: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_pa.';
671: l_enable_log := igs_ad_imp_001.g_enable_log;
672:
673: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
674:
675: IF (l_request_id IS NULL) THEN

Line 741: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);

737:
738: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
739: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
740: l_dsql_debug := fnd_dsql.get_text(TRUE);
741: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
742: */
743: LOOP
744: -- fetch a row
745: IF dbms_sql.fetch_rows(l_cursor_id) > 0 THEN

Line 802: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E002', p_match_ind => '13');

798:
799: p_match_ind := '13';
800:
801: IF l_enable_log = 'Y' THEN
802: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E002', p_match_ind => '13');
803: END IF;
804:
805:
806: RETURN;

Line 853: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);

849: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id1);
850:
851: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
852: l_dsql_debug := fnd_dsql.get_text(TRUE);
853: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
854: */
855: LOOP
856: -- fetch a row
857: IF dbms_sql.fetch_rows(l_cursor_id1) > 0 THEN

Line 915: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E003', p_match_ind => '14');

911:
912: p_match_ind := '14';
913:
914: IF l_enable_log = 'Y' THEN
915: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E003', p_match_ind => '14');
916: END IF;
917:
918: RETURN;
919: END IF;

Line 936: Igs_Ad_Imp_001.set_message('IGS_PE_ADDR_INFO_MISS');

932: p_match_ind := '24';
933:
934: IF l_enable_log = 'Y' THEN
935: --vrathi: Add specific message to log
936: Igs_Ad_Imp_001.set_message('IGS_PE_ADDR_INFO_MISS');
937: igs_ad_imp_001.logerrormessage(p_record => p_d_interface_id, p_error => 'E001', p_match_ind => '24');
938: END IF;
939:
940: END IF;

Line 937: igs_ad_imp_001.logerrormessage(p_record => p_d_interface_id, p_error => 'E001', p_match_ind => '24');

933:
934: IF l_enable_log = 'Y' THEN
935: --vrathi: Add specific message to log
936: Igs_Ad_Imp_001.set_message('IGS_PE_ADDR_INFO_MISS');
937: igs_ad_imp_001.logerrormessage(p_record => p_d_interface_id, p_error => 'E001', p_match_ind => '24');
938: END IF;
939:
940: END IF;
941:

Line 1023: l_enable_log := igs_ad_imp_001.g_enable_log;

1019: -- Call Log header
1020:
1021: l_prog_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_ppa';
1022: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_ppa.';
1023: l_enable_log := igs_ad_imp_001.g_enable_log;
1024:
1025: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1026:
1027: IF (l_request_id IS NULL) THEN

Line 1101: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);

1097:
1098: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
1099: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
1100: l_dsql_debug := fnd_dsql.get_text(TRUE);
1101: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
1102: */
1103: LOOP
1104: -- fetch a row
1105: IF dbms_sql.fetch_rows(l_cursor_id) > 0 THEN

Line 1165: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E002', p_match_ind => '13');

1161:
1162: p_match_ind := '13';
1163:
1164: IF l_enable_log = 'Y' THEN
1165: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E002', p_match_ind => '13');
1166: END IF;
1167:
1168: RETURN;
1169: END IF;

Line 1217: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);

1213: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id1);
1214:
1215: /* This will print the Dynamic SQL statement prepared. Can be uncommented when testing.
1216: l_dsql_debug := fnd_dsql.get_text(TRUE);
1217: Igs_Ad_Imp_001.logDetail('l_dsql_debug :'||l_dsql_debug);
1218: */
1219: LOOP
1220: -- fetch a row
1221: IF dbms_sql.fetch_rows(l_cursor_id1) > 0 THEN

Line 1276: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E003', p_match_ind => '14');

1272:
1273: p_match_ind := '14';
1274:
1275: IF l_enable_log = 'Y' THEN
1276: igs_ad_imp_001.logerrormessage(p_record => imp_person_rec.interface_id, p_error => 'E003', p_match_ind => '14');
1277: END IF;
1278:
1279: RETURN;
1280: END IF;

Line 1296: Igs_Ad_Imp_001.set_message('IGS_PE_ADDR_PID_MISS');

1292: p_match_ind := '24';
1293: --vrathi: Add specific message to log
1294:
1295: IF l_enable_log = 'Y' THEN
1296: Igs_Ad_Imp_001.set_message('IGS_PE_ADDR_PID_MISS');
1297: igs_ad_imp_001.logerrormessage(p_record => p_d_interface_id, p_error => 'E001', p_match_ind => '24');
1298: END IF;
1299: END IF;
1300:

Line 1297: igs_ad_imp_001.logerrormessage(p_record => p_d_interface_id, p_error => 'E001', p_match_ind => '24');

1293: --vrathi: Add specific message to log
1294:
1295: IF l_enable_log = 'Y' THEN
1296: Igs_Ad_Imp_001.set_message('IGS_PE_ADDR_PID_MISS');
1297: igs_ad_imp_001.logerrormessage(p_record => p_d_interface_id, p_error => 'E001', p_match_ind => '24');
1298: END IF;
1299: END IF;
1300:
1301: END igs_ad_find_duplicates_imp_ppa;

Line 1366: l_enable_log := igs_ad_imp_001.g_enable_log;

1362: -- Call Log header
1363:
1364: l_prog_label := 'igs.plsql.igs_ad_imp_009.igs_ad_imp_find_dup_persons';
1365: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_imp_find_dup_persons.';
1366: l_enable_log := igs_ad_imp_001.g_enable_log;
1367:
1368: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1369:
1370: IF (l_request_id IS NULL) THEN

Line 1475: igs_ad_imp_001.logerrormessage(p_interface_id,'E177');

1471: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1472: END IF;
1473:
1474: IF l_enable_log = 'Y' THEN
1475: igs_ad_imp_001.logerrormessage(p_interface_id,'E177');
1476: END IF;
1477:
1478: END igs_ad_imp_find_dup_persons;
1479: -- 2