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_003 dependencies on IGS_AD_IMP_003

Line 1: PACKAGE BODY IGS_AD_IMP_003 AS

1: PACKAGE BODY IGS_AD_IMP_003 AS
2: /* $Header: IGSAD81B.pls 120.3 2006/07/31 06:25:35 apadegal noship $ */
3:
4: -- Start of Main Procedure Process Applicant Academic Interests
5: /*----------------------------------------------------------------------------------

Line 107: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.begin';

103: IF (l_request_id IS NULL) THEN
104: l_request_id := fnd_global.conc_request_id;
105: END IF;
106:
107: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.begin';
108:
109: l_debug_str := 'Interface Academic Interest ID: '|| l_acadint_rec.interface_acadint_id;
110:
111: fnd_log.string_with_context( fnd_log.level_procedure, l_label,l_debug_str, NULL, NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

Line 273: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.exception '||'E322';

269: END IF;
270: ELSE
271:
272: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
273: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.exception '||'E322';
274:
275: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
276: fnd_message.set_token('CONTEXT',c_acadint_rec.interface_appl_id);
277: fnd_message.set_token('ERROR', l_error_text);

Line 363: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_indt.begin';

359: IF (l_request_id IS NULL) THEN
360: l_request_id := fnd_global.conc_request_id;
361: END IF;
362:
363: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_indt.begin';
364:
365: l_debug_str := 'Interface Application Intent ID: '|| l_appint_rec.interface_appint_id;
366:
367: fnd_log.string_with_context( fnd_log.level_procedure, l_label,l_debug_str, NULL, NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

Line 578: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.exception '||'E322';

574:
575: ELSE
576:
577: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
578: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.exception '||'E322';
579:
580: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
581: fnd_message.set_token('CONTEXT',l_appint_rec.interface_appl_id);
582: fnd_message.set_token('ERROR', l_error_text);

Line 667: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_oth_inst_apld.begin';

663: IF (l_request_id IS NULL) THEN
664: l_request_id := fnd_global.conc_request_id;
665: END IF;
666:
667: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_oth_inst_apld.begin';
668:
669: l_debug_str := 'Interface Other Institution ID: '|| l_oth_inst_rec.interface_othinst_id;
670:
671: fnd_log.string_with_context( fnd_log.level_procedure, l_label,

Line 834: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_oth_inst_apld.exception '||'E322';

830: igs_ad_imp_001.logerrormessage(l_oth_inst_rec.interface_othinst_id,l_msg_data);
831: END IF;
832: ELSE
833: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
834: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_oth_inst_apld.exception '||'E322';
835:
836: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
837: fnd_message.set_token('CONTEXT',l_oth_inst_rec.interface_appl_id);
838: fnd_message.set_token('ERROR', l_error_text);

Line 922: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_spl_intrst.begin';

918: IF (l_request_id IS NULL) THEN
919: l_request_id := fnd_global.conc_request_id;
920: END IF;
921:
922: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_spl_intrst.begin';
923:
924: l_debug_str := 'Interface Special Interests ID: '|| l_spl_intrst_rec.interface_splint_id;
925:
926: fnd_log.string_with_context( fnd_log.level_procedure, l_label,

Line 1074: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_spl_intrst.exception '||'E322';

1070:
1071: ELSE
1072:
1073: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1074: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_spl_intrst.exception '||'E322';
1075:
1076: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1077: fnd_message.set_token('CONTEXT',l_spl_intrst_rec.interface_appl_id);
1078: fnd_message.set_token('ERROR', l_error_text);

Line 1161: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_spl_tal.begin';

1157: IF (l_request_id IS NULL) THEN
1158: l_request_id := fnd_global.conc_request_id;
1159: END IF;
1160:
1161: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_spl_tal.begin';
1162:
1163: l_debug_str := 'Interface Special Talent ID: '|| l_spl_tal_rec.interface_spltal_id;
1164:
1165: fnd_log.string_with_context( fnd_log.level_procedure, l_label,l_debug_str, NULL, NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));

Line 1310: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_spl_tal.exception '||'E322';

1306:
1307: ELSE
1308:
1309: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1310: l_label := 'igs.plsql.igs_ad_imp_003.prc_apcnt_spl_tal.exception '||'E322';
1311:
1312: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1313: fnd_message.set_token('CONTEXT',l_spl_tal_rec.interface_appl_id);
1314: fnd_message.set_token('ERROR', l_error_text);

Line 1397: l_label := 'igs.plsql.igs_ad_imp_003.prc_persstat_details.begin';

1393: IF (l_request_id IS NULL) THEN
1394: l_request_id := fnd_global.conc_request_id;
1395: END IF;
1396:
1397: l_label := 'igs.plsql.igs_ad_imp_003.prc_persstat_details.begin';
1398:
1399: l_debug_str := 'Interface Personal Statement ID: '|| l_appl_pers_rec.interface_perstmt_id;
1400:
1401: fnd_log.string_with_context( fnd_log.level_procedure, l_label,

Line 1505: l_label := 'igs.plsql.igs_ad_imp_003.prc_persstat_details.exception '||'E322';

1501:
1502: ELSE
1503:
1504: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1505: l_label := 'igs.plsql.igs_ad_imp_003.prc_persstat_details.exception '||'E322';
1506:
1507: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1508: fnd_message.set_token('CONTEXT',l_appl_pers_rec.interface_appl_id);
1509: fnd_message.set_token('ERROR', l_error_text);

Line 1781: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.exception '||l_error_code;

1777:
1778: ELSE
1779:
1780: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1781: l_label := 'igs.plsql.igs_ad_imp_003.prc_acad_int.exception '||l_error_code;
1782:
1783: fnd_message.set_name('IGS','IGS_PE_IMP_DET_ERROR');
1784: fnd_message.set_token('CONTEXT',l_fee_int_rec.interface_appl_id);
1785: fnd_message.set_token('ERROR', l_error_text);

Line 1876: END igs_ad_imp_003;

1872: END IF;
1873:
1874: END prc_appl_fees;
1875:
1876: END igs_ad_imp_003;