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_009

Line 1: PACKAGE BODY Igs_Ad_Imp_009 AS

1: PACKAGE BODY Igs_Ad_Imp_009 AS
2: /* $Header: IGSAD87B.pls 120.3 2006/03/24 02:34:32 gmaheswa noship $ */
3:
4: /*************************************
5: || Change History

Line 104: l_prog_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_p';

100: l_dsql_debug VARCHAR2(4000);
101:
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

Line 105: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_p.';

101:
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:

Line 114: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_p.begin';

110: IF (l_request_id IS NULL) THEN
111: l_request_id := fnd_global.conc_request_id;
112: END IF;
113:
114: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_p.begin';
115: l_debug_str := 'igs_ad_imp_009.igs_ad_find_duplicates_imp_p';
116:
117: fnd_log.string_with_context( fnd_log.level_procedure,
118: l_label,

Line 115: l_debug_str := 'igs_ad_imp_009.igs_ad_find_duplicates_imp_p';

111: l_request_id := fnd_global.conc_request_id;
112: END IF;
113:
114: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_p.begin';
115: l_debug_str := 'igs_ad_imp_009.igs_ad_find_duplicates_imp_p';
116:
117: fnd_log.string_with_context( fnd_log.level_procedure,
118: l_label,
119: l_debug_str, NULL,

Line 372: l_prog_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_pp';

368: BEGIN
369:
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

Line 373: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_pp.';

369:
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:

Line 382: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_pp.begin';

378: IF (l_request_id IS NULL) THEN
379: l_request_id := fnd_global.conc_request_id;
380: END IF;
381:
382: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_pp.begin';
383: l_debug_str := 'Igs_Ad_Imp_009.igs_ad_find_duplicates_imp_pp';
384:
385: fnd_log.string_with_context( fnd_log.level_procedure,
386: l_label,

Line 383: l_debug_str := 'Igs_Ad_Imp_009.igs_ad_find_duplicates_imp_pp';

379: l_request_id := fnd_global.conc_request_id;
380: END IF;
381:
382: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_pp.begin';
383: l_debug_str := 'Igs_Ad_Imp_009.igs_ad_find_duplicates_imp_pp';
384:
385: fnd_log.string_with_context( fnd_log.level_procedure,
386: l_label,
387: l_debug_str, NULL,

Line 669: l_prog_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_pa';

665: l_view_passed VARCHAR2(50);
666: BEGIN
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

Line 670: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_pa.';

666: BEGIN
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:

Line 679: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_pa.begin';

675: IF (l_request_id IS NULL) THEN
676: l_request_id := fnd_global.conc_request_id;
677: END IF;
678:
679: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_pa.begin';
680: l_debug_str := 'Igs_Ad_Imp_009.igs_ad_find_duplicates_imp_pa';
681:
682: fnd_log.string_with_context( fnd_log.level_procedure,
683: l_label,

Line 680: l_debug_str := 'Igs_Ad_Imp_009.igs_ad_find_duplicates_imp_pa';

676: l_request_id := fnd_global.conc_request_id;
677: END IF;
678:
679: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_pa.begin';
680: l_debug_str := 'Igs_Ad_Imp_009.igs_ad_find_duplicates_imp_pa';
681:
682: fnd_log.string_with_context( fnd_log.level_procedure,
683: l_label,
684: l_debug_str, NULL,

Line 1021: l_prog_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_ppa';

1017: BEGIN
1018:
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

Line 1022: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_ppa.';

1018:
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:

Line 1031: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_ppa.begin';

1027: IF (l_request_id IS NULL) THEN
1028: l_request_id := fnd_global.conc_request_id;
1029: END IF;
1030:
1031: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_ppa.begin';
1032: l_debug_str := 'Igs_Ad_Imp_009.igs_ad_find_duplicates_imp_ppa';
1033:
1034: fnd_log.string_with_context( fnd_log.level_procedure,
1035: l_label,

Line 1032: l_debug_str := 'Igs_Ad_Imp_009.igs_ad_find_duplicates_imp_ppa';

1028: l_request_id := fnd_global.conc_request_id;
1029: END IF;
1030:
1031: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_duplicates_imp_ppa.begin';
1032: l_debug_str := 'Igs_Ad_Imp_009.igs_ad_find_duplicates_imp_ppa';
1033:
1034: fnd_log.string_with_context( fnd_log.level_procedure,
1035: l_label,
1036: l_debug_str, NULL,

Line 1364: l_prog_label := 'igs.plsql.igs_ad_imp_009.igs_ad_imp_find_dup_persons';

1360: BEGIN
1361:
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

Line 1365: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_imp_find_dup_persons.';

1361:
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:

Line 1374: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_dup_persons.begin';

1370: IF (l_request_id IS NULL) THEN
1371: l_request_id := fnd_global.conc_request_id;
1372: END IF;
1373:
1374: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_dup_persons.begin';
1375: l_debug_str := 'Igs_Ad_Imp_009.igs_ad_find_dup_persons for Interface ID: '||p_interface_id||' with Address type: '||p_addr_type
1376: ||' Person ID Type: '||p_person_id_type;
1377:
1378: fnd_log.string_with_context( fnd_log.level_procedure,

Line 1375: l_debug_str := 'Igs_Ad_Imp_009.igs_ad_find_dup_persons for Interface ID: '||p_interface_id||' with Address type: '||p_addr_type

1371: l_request_id := fnd_global.conc_request_id;
1372: END IF;
1373:
1374: l_label := 'igs.plsql.igs_ad_imp_009.igs_ad_find_dup_persons.begin';
1375: l_debug_str := 'Igs_Ad_Imp_009.igs_ad_find_dup_persons for Interface ID: '||p_interface_id||' with Address type: '||p_addr_type
1376: ||' Person ID Type: '||p_person_id_type;
1377:
1378: fnd_log.string_with_context( fnd_log.level_procedure,
1379: l_label,

Line 1460: l_label := 'igs_ad_imp_009.igs_ad_imp_find_dup_persons.exception';

1456: IF (l_request_id IS NULL) THEN
1457: l_request_id := fnd_global.conc_request_id;
1458: END IF;
1459:
1460: l_label := 'igs_ad_imp_009.igs_ad_imp_find_dup_persons.exception';
1461:
1462: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1463: fnd_message.set_token('INTERFACE_ID',p_interface_id);
1464: fnd_message.set_token('ERROR_CD','E177');

Line 1482: END Igs_Ad_Imp_009;

1478: END igs_ad_imp_find_dup_persons;
1479: -- 2
1480: /*removed the procedure SET_STAT_MATC_RVW_DIS_RCDS as part of bug 3191401*/
1481:
1482: END Igs_Ad_Imp_009;