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_012 dependencies on IGS_AD_IMP_012

Line 1: PACKAGE BODY IGS_AD_IMP_012 AS

1: PACKAGE BODY IGS_AD_IMP_012 AS
2: /* $Header: IGSAD90B.pls 120.2 2006/01/25 09:23:00 skpandey noship $ */
3: /*
4: || Change History :
5: || Who When What

Line 148: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.begin_crt_prsn_contacts';

144: IF (l_request_id IS NULL) THEN
145: l_request_id := fnd_global.conc_request_id;
146: END IF;
147:
148: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.begin_crt_prsn_contacts';
149: l_debug_str := 'Igs_Ad_Imp_012.crt_prsn_contacts';
150:
151: fnd_log.string_with_context( fnd_log.level_procedure,
152: l_label,

Line 149: l_debug_str := 'Igs_Ad_Imp_012.crt_prsn_contacts';

145: l_request_id := fnd_global.conc_request_id;
146: END IF;
147:
148: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.begin_crt_prsn_contacts';
149: l_debug_str := 'Igs_Ad_Imp_012.crt_prsn_contacts';
150:
151: fnd_log.string_with_context( fnd_log.level_procedure,
152: l_label,
153: l_debug_str, NULL,

Line 210: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.exception_crt_prsn_contacts';

206: IF (l_request_id IS NULL) THEN
207: l_request_id := fnd_global.conc_request_id;
208: END IF;
209:
210: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.exception_crt_prsn_contacts';
211:
212: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
213: fnd_message.set_token('INTERFACE_ID',rec_pc.interface_contacts_id);
214: fnd_message.set_token('ERROR_CD','E322');

Line 252: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.exception_crt_prsn_contacts';

248: IF (l_request_id IS NULL) THEN
249: l_request_id := fnd_global.conc_request_id;
250: END IF;
251:
252: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.exception_crt_prsn_contacts';
253:
254: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
255: fnd_message.set_token('INTERFACE_ID',rec_pc.interface_contacts_id);
256: fnd_message.set_token('ERROR_CD','E322');

Line 295: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.begin_validate_prsn_contacts';

291: IF (l_request_id IS NULL) THEN
292: l_request_id := fnd_global.conc_request_id;
293: END IF;
294:
295: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.begin_validate_prsn_contacts';
296: l_debug_str := 'Igs_Ad_Imp_012.validate_prsn_contacts';
297:
298: fnd_log.string_with_context( fnd_log.level_procedure,
299: l_label,

Line 296: l_debug_str := 'Igs_Ad_Imp_012.validate_prsn_contacts';

292: l_request_id := fnd_global.conc_request_id;
293: END IF;
294:
295: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.begin_validate_prsn_contacts';
296: l_debug_str := 'Igs_Ad_Imp_012.validate_prsn_contacts';
297:
298: fnd_log.string_with_context( fnd_log.level_procedure,
299: l_label,
300: l_debug_str, NULL,

Line 436: l_prog_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls';

432: -- main procedure begins;
433: BEGIN
434:
435: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
436: l_prog_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls';
437: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.';
438: l_enable_log := igs_ad_imp_001.g_enable_log;
439:
440: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN

Line 437: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.';

433: BEGIN
434:
435: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
436: l_prog_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls';
437: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.';
438: l_enable_log := igs_ad_imp_001.g_enable_log;
439:
440: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
441:

Line 446: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.begin';

442: IF (l_request_id IS NULL) THEN
443: l_request_id := fnd_global.conc_request_id;
444: END IF;
445:
446: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.begin';
447: l_debug_str := 'Igs_Ad_Imp_012.prc_pe_cntct_dtls';
448:
449: fnd_log.string_with_context( fnd_log.level_procedure,
450: l_label,

Line 447: l_debug_str := 'Igs_Ad_Imp_012.prc_pe_cntct_dtls';

443: l_request_id := fnd_global.conc_request_id;
444: END IF;
445:
446: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.begin';
447: l_debug_str := 'Igs_Ad_Imp_012.prc_pe_cntct_dtls';
448:
449: fnd_log.string_with_context( fnd_log.level_procedure,
450: l_label,
451: l_debug_str, NULL,

Line 699: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.exception1';

695: IF (l_request_id IS NULL) THEN
696: l_request_id := fnd_global.conc_request_id;
697: END IF;
698:
699: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.exception1';
700:
701: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
702: fnd_message.set_token('INTERFACE_ID',rec_pc1.interface_contacts_id);
703: fnd_message.set_token('ERROR_CD','E014');

Line 739: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.exception2';

735: IF (l_request_id IS NULL) THEN
736: l_request_id := fnd_global.conc_request_id;
737: END IF;
738:
739: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.exception2';
740:
741: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
742: fnd_message.set_token('INTERFACE_ID',rec_pc1.interface_contacts_id);
743: fnd_message.set_token('ERROR_CD','E014');

Line 835: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.exception3';

831: IF (l_request_id IS NULL) THEN
832: l_request_id := fnd_global.conc_request_id;
833: END IF;
834:
835: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.exception3';
836:
837: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
838: fnd_message.set_token('INTERFACE_ID',rec_pc1.interface_contacts_id);
839: fnd_message.set_token('ERROR_CD',l_error_code);

Line 872: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.exception4';

868: IF (l_request_id IS NULL) THEN
869: l_request_id := fnd_global.conc_request_id;
870: END IF;
871:
872: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.exception4';
873:
874: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
875: fnd_message.set_token('INTERFACE_ID',rec_pc1.interface_contacts_id);
876: fnd_message.set_token('ERROR_CD','E014');

Line 908: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.exception5';

904: IF (l_request_id IS NULL) THEN
905: l_request_id := fnd_global.conc_request_id;
906: END IF;
907:
908: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_cntct_dtls.exception5';
909:
910: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
911: fnd_message.set_token('INTERFACE_ID',rec_pc1.interface_contacts_id);
912: fnd_message.set_token('ERROR_CD','E518');

Line 1045: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.exception_validate_lang';

1041: IF (l_request_id IS NULL) THEN
1042: l_request_id := fnd_global.conc_request_id;
1043: END IF;
1044:
1045: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.exception_validate_lang';
1046:
1047: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1048: fnd_message.set_token('INTERFACE_ID',p_person_language_rec.interface_language_id);
1049: fnd_message.set_token('ERROR_CD',l_error_code);

Line 1088: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.begin_crt_prsn_language';

1084: IF (l_request_id IS NULL) THEN
1085: l_request_id := fnd_global.conc_request_id;
1086: END IF;
1087:
1088: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.begin_crt_prsn_language';
1089: l_debug_str := 'Igs_Ad_Imp_012.crt_prsn_language';
1090:
1091: fnd_log.string_with_context( fnd_log.level_procedure,
1092: l_label,

Line 1089: l_debug_str := 'Igs_Ad_Imp_012.crt_prsn_language';

1085: l_request_id := fnd_global.conc_request_id;
1086: END IF;
1087:
1088: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.begin_crt_prsn_language';
1089: l_debug_str := 'Igs_Ad_Imp_012.crt_prsn_language';
1090:
1091: fnd_log.string_with_context( fnd_log.level_procedure,
1092: l_label,
1093: l_debug_str, NULL,

Line 1142: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.exception_crt_prsn_language1';

1138: IF (l_request_id IS NULL) THEN
1139: l_request_id := fnd_global.conc_request_id;
1140: END IF;
1141:
1142: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.exception_crt_prsn_language1';
1143:
1144: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1145: fnd_message.set_token('INTERFACE_ID',p_person_language_rec.interface_language_id);
1146: fnd_message.set_token('ERROR_CD','E322');

Line 1183: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.exception_crt_prsn_language2';

1179: IF (l_request_id IS NULL) THEN
1180: l_request_id := fnd_global.conc_request_id;
1181: END IF;
1182:
1183: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.exception_crt_prsn_language2';
1184:
1185: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1186: fnd_message.set_token('INTERFACE_ID',p_person_language_rec.interface_language_id);
1187: fnd_message.set_token('ERROR_CD','E322');

Line 1207: l_prog_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language';

1203: -- start of main procedure prc_pe_lang
1204: BEGIN
1205:
1206: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1207: l_prog_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language';
1208: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.';
1209: l_enable_log := igs_ad_imp_001.g_enable_log;
1210:
1211: l_rule :=igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_LANGUAGES');

Line 1208: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.';

1204: BEGIN
1205:
1206: l_interface_run_id := igs_ad_imp_001.g_interface_run_id;
1207: l_prog_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language';
1208: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.';
1209: l_enable_log := igs_ad_imp_001.g_enable_log;
1210:
1211: l_rule :=igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_LANGUAGES');
1212:

Line 1383: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.exception1';

1379: IF (l_request_id IS NULL) THEN
1380: l_request_id := fnd_global.conc_request_id;
1381: END IF;
1382:
1383: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.exception1';
1384:
1385: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1386: fnd_message.set_token('INTERFACE_ID',person_language_rec.interface_language_id);
1387: fnd_message.set_token('ERROR_CD','E014');

Line 1419: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.exception2';

1415: IF (l_request_id IS NULL) THEN
1416: l_request_id := fnd_global.conc_request_id;
1417: END IF;
1418:
1419: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.exception2';
1420:
1421: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1422: fnd_message.set_token('INTERFACE_ID',person_language_rec.interface_language_id);
1423: fnd_message.set_token('ERROR_CD','E014');

Line 1505: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.exception3';

1501: IF (l_request_id IS NULL) THEN
1502: l_request_id := fnd_global.conc_request_id;
1503: END IF;
1504:
1505: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.exception3';
1506:
1507: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1508: fnd_message.set_token('INTERFACE_ID',person_language_rec.interface_language_id);
1509: fnd_message.set_token('ERROR_CD','E014');

Line 1539: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.exception4';

1535: IF (l_request_id IS NULL) THEN
1536: l_request_id := fnd_global.conc_request_id;
1537: END IF;
1538:
1539: l_label := 'igs.plsql.igs_ad_imp_012.prc_pe_language.exception4';
1540:
1541: fnd_message.set_name('IGS','IGS_PE_IMP_ERROR');
1542: fnd_message.set_token('INTERFACE_ID',person_language_rec.interface_language_id);
1543: fnd_message.set_token('ERROR_CD','E014');

Line 2677: END IGS_AD_IMP_012;

2673: prc_apcnt_ath_dtls(p_source_type_id, p_batch_id);
2674: prc_apcnt_ath_prg (p_source_type_id, p_batch_id);
2675: END prc_apcnt_ath;
2676:
2677: END IGS_AD_IMP_012;