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_UC_EXPUNGE_APP dependencies on FND_FILE

Line 334: fnd_file.put_line(fnd_file.log, fnd_message.get);

330: CLOSE cur_system_val_setup;
331:
332: IF l_setup_comp = 'X' THEN
333: fnd_message.set_name( 'IGS','IGS_UC_OBS_SETUP_NOT_SET');
334: fnd_file.put_line(fnd_file.log, fnd_message.get);
335: -- end job in warning state
336: retcode := 1;
337: ELSE
338:

Line 394: fnd_file.put_line (fnd_file.log,' ');

390:
391: l_oss_app_inst_suspended := 'Y';
392:
393: -- log Application Choice processing message.
394: fnd_file.put_line (fnd_file.log,' ');
395: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
396: fnd_message.set_token('APPNO', TO_CHAR(l_wrong_app_rec.app_no));
397: fnd_message.set_token('CHOICE',TO_CHAR(l_expunge_choice_det(l_loc)));
398: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 398: fnd_file.put_line(fnd_file.log, fnd_message.get);

394: fnd_file.put_line (fnd_file.log,' ');
395: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
396: fnd_message.set_token('APPNO', TO_CHAR(l_wrong_app_rec.app_no));
397: fnd_message.set_token('CHOICE',TO_CHAR(l_expunge_choice_det(l_loc)));
398: fnd_file.put_line(fnd_file.log, fnd_message.get);
399:
400: --Identify the OSS Admission Application instances to be suspended.
401: OPEN cur_oss_ad_appl_inst(l_wrong_app_rec.app_no, l_expunge_choice_det(l_loc));
402: FETCH cur_oss_ad_appl_inst INTO l_appl_inst_rec;

Line 411: fnd_file.put_line (fnd_file.log,fnd_message.get);

407: CLOSE cur_oss_ad_appl_inst;
408: fnd_message.set_name( 'IGS','IGS_UC_NO_XPG_APPL_INST');
409: fnd_message.set_token('APP_NO',TO_CHAR(l_wrong_app_rec.app_no));
410: fnd_message.set_token('CHOICE_NO',TO_CHAR(l_expunge_choice_det(l_loc)));
411: fnd_file.put_line (fnd_file.log,fnd_message.get);
412:
413: ELSE
414:
415: CLOSE cur_oss_ad_appl_inst;

Line 502: fnd_file.put_line(fnd_file.log,fnd_message.get()||l_dec_imp_err);

498: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
499: fnd_message.set_token('APP_NO', l_oss_ad_appl_inst_rec.alt_appl_id);
500: fnd_message.set_token('CHOICE_NO',l_oss_ad_appl_inst_rec.choice_number);
501: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
502: fnd_file.put_line(fnd_file.log,fnd_message.get()||l_dec_imp_err);
503: ELSE
504: OPEN cur_per_no(l_oss_ad_appl_inst_rec.person_id);
505: FETCH cur_per_no INTO l_person_no;
506: CLOSE cur_per_no;

Line 515: fnd_file.put_line(fnd_file.log,fnd_message.get());

511: fnd_message.set_token('PROG_VER', l_oss_ad_appl_inst_rec.crv_version_number);
512: fnd_message.set_token('LOC', l_oss_ad_appl_inst_rec.location_cd);
513: fnd_message.set_token('ATT_TYPE', l_oss_ad_appl_inst_rec.attendance_mode);
514: fnd_message.set_token('ATT_MODE', l_oss_ad_appl_inst_rec.attendance_type);
515: fnd_file.put_line(fnd_file.log,fnd_message.get());
516: END IF ; -- decision import failed or passed
517:
518: END LOOP; -- End of the Admission Application Instances Loop FOR UCAS Wrong Applications
519:

Line 550: fnd_file.put_line(fnd_file.log,fnd_message.get());

546:
547: fnd_message.set_name('IGS','IGS_UC_XPG_APP_CHO_REC_COMP');
548: fnd_message.set_token('APP_NO', TO_CHAR(l_wrong_app_rec.app_no));
549: fnd_message.set_token('CHOICE_NO',TO_CHAR(l_expunge_choice_det(l_loc)));
550: fnd_file.put_line(fnd_file.log,fnd_message.get());
551:
552: END IF;
553:
554: END LOOP; -- End of the Choices (pl/sql table) Loop FOR UCAS Wrong Application

Line 611: fnd_file.put_line(fnd_file.log,fnd_message.get());

607: x_region_cd => l_alt_pers_id_rec.region_cd);
608:
609: fnd_message.set_name('IGS','IGS_UC_END_DT_ALT_PID_COMP');
610: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
611: fnd_file.put_line(fnd_file.log,fnd_message.get());
612: EXCEPTION
613: WHEN OTHERS THEN
614: l_pe_alt_pers_id_closed := 'N';
615: l_mesg_data := NULL;

Line 625: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);

621: fnd_message.set_name('IGS','IGS_UC_END_DT_ALT_PID_ERR');
622: fnd_message.set_token('PER_NO', l_person_no);
623: fnd_message.set_token('ALT_PID', l_alt_pers_id_rec.api_person_id);
624: fnd_message.set_token('PID_TYPE',l_alt_pers_id_rec.person_id_type);
625: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);
626: END;
627: END IF;
628: CLOSE cur_alt_pers_id;
629:

Line 641: fnd_file.put_line(fnd_file.log,fnd_message.get());

637: BEGIN
638: --Call the sub procedure to delete Wrong Applicant records from UCAS Interface tables.
639: delete_ucas_interface_rec(l_wrong_app_rec.app_no);
640: fnd_message.set_name('IGS','IGS_UC_XPG_INT_REC_COMP');
641: fnd_file.put_line(fnd_file.log,fnd_message.get());
642: EXCEPTION
643: WHEN OTHERS THEN
644: l_ucas_app_recs_deleted := 'N';
645: l_mesg_data := NULL;

Line 650: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);

646: l_msg_index := NULL;
647: IGS_GE_MSG_STACK.GET(IGS_GE_MSG_STACK.COUNT_MSG,FND_API.G_FALSE, l_mesg_data, l_msg_index);
648: fnd_message.set_name('IGS','IGS_UC_XPG_INT_REC_ERR');
649: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
650: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);
651: END;
652: END IF; ----End of Check FOR all oss applications are suspended and Alternate IDs are end dated.
653:
654: -- IGS_UC_WRONG_APP.EXPUNGED can be set to 'Y' in following 2 conditions.

Line 687: fnd_file.put_line(fnd_file.log,fnd_message.get());

683: -- Display the Application level expunge message only when complete Application details are expunged.
684: IF l_ucas_app_expunged = 'Y' THEN
685: fnd_message.set_name('IGS','IGS_UC_XPG_APP_NO_REC_COMP');
686: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
687: fnd_file.put_line(fnd_file.log,fnd_message.get());
688: fnd_file.put_line(fnd_file.log,' ');
689: END IF;
690: EXCEPTION
691: WHEN OTHERS THEN

Line 688: fnd_file.put_line(fnd_file.log,' ');

684: IF l_ucas_app_expunged = 'Y' THEN
685: fnd_message.set_name('IGS','IGS_UC_XPG_APP_NO_REC_COMP');
686: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
687: fnd_file.put_line(fnd_file.log,fnd_message.get());
688: fnd_file.put_line(fnd_file.log,' ');
689: END IF;
690: EXCEPTION
691: WHEN OTHERS THEN
692: l_mesg_data := NULL;

Line 697: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);

693: l_msg_index := NULL;
694: IGS_GE_MSG_STACK.GET(IGS_GE_MSG_STACK.COUNT_MSG,FND_API.G_FALSE, l_mesg_data, l_msg_index);
695: fnd_message.set_name('IGS','IGS_UC_MARK_APP_EXPUNGED_ERR');
696: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
697: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);
698: END;
699: END IF;
700:
701: END LOOP; -- End of the UCAS Wrong Applications Loop