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

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

215: END IF;
216:
217: -- Displays log message "Deleting the existing qualifications that are imported from UCAS and not having Advanced standing details associated with it.".
218: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_DELETE');
219: fnd_file.put_line(fnd_file.log, fnd_message.get);
220: fnd_file.put_line(fnd_file.log,' ' );
221:
222: -- Deleting All the existing Qualifications Records Imported from UCAS
223: -- and creating the Qualifications from the UCAS Interface Table.

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

216:
217: -- Displays log message "Deleting the existing qualifications that are imported from UCAS and not having Advanced standing details associated with it.".
218: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_DELETE');
219: fnd_file.put_line(fnd_file.log, fnd_message.get);
220: fnd_file.put_line(fnd_file.log,' ' );
221:
222: -- Deleting All the existing Qualifications Records Imported from UCAS
223: -- and creating the Qualifications from the UCAS Interface Table.
224: -- This was enhanced for the bug,2825034

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

262: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
263: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
264: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
265: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);
266: fnd_file.put_line(fnd_file.log, fnd_message.get);
267: fnd_file.put_line(fnd_file.log,' ' );
268: ELSE
269: --Invalid Qualification. So display appropriate message asking user's mannual review.
270: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_INVALID');

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

263: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
264: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
265: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);
266: fnd_file.put_line(fnd_file.log, fnd_message.get);
267: fnd_file.put_line(fnd_file.log,' ' );
268: ELSE
269: --Invalid Qualification. So display appropriate message asking user's mannual review.
270: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_INVALID');
271: fnd_message.set_token('PER_NO', l_person_number);

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

274: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
275: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
276: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
277: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);
278: fnd_file.put_line(fnd_file.log, fnd_message.get);
279: fnd_file.put_line(fnd_file.log,' ' );
280: END IF;
281:
282: ELSE

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

275: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
276: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
277: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);
278: fnd_file.put_line(fnd_file.log, fnd_message.get);
279: fnd_file.put_line(fnd_file.log,' ' );
280: END IF;
281:
282: ELSE
283: --Delete the existing imported Qualification when advanced standing details doesn't exists.

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

287:
288: END LOOP ;
289:
290: -- Displays log message "Importing Qualification details data from UCAS Interface table to Qualification Details table".
291: fnd_file.put_line(fnd_file.log,' ' );
292: fnd_message.set_name('IGS','IGS_UC_IMP_QUAL_DETS');
293: fnd_file.put_line(fnd_file.log, fnd_message.get);
294: fnd_file.put_line(fnd_file.log,' ' );
295:

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

289:
290: -- Displays log message "Importing Qualification details data from UCAS Interface table to Qualification Details table".
291: fnd_file.put_line(fnd_file.log,' ' );
292: fnd_message.set_name('IGS','IGS_UC_IMP_QUAL_DETS');
293: fnd_file.put_line(fnd_file.log, fnd_message.get);
294: fnd_file.put_line(fnd_file.log,' ' );
295:
296: /* Picking up records from igs_uc_com_ebl_subj table for Importing in to qual dets table */
297: FOR I IN cur_ucas_interface LOOP

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

290: -- Displays log message "Importing Qualification details data from UCAS Interface table to Qualification Details table".
291: fnd_file.put_line(fnd_file.log,' ' );
292: fnd_message.set_name('IGS','IGS_UC_IMP_QUAL_DETS');
293: fnd_file.put_line(fnd_file.log, fnd_message.get);
294: fnd_file.put_line(fnd_file.log,' ' );
295:
296: /* Picking up records from igs_uc_com_ebl_subj table for Importing in to qual dets table */
297: FOR I IN cur_ucas_interface LOOP
298:

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

343: fnd_message.set_token('YEAR', I.year);
344: fnd_message.set_token('SITTING', I.sitting);
345: fnd_message.set_token('AWD_BDY', l_oss_awarding_body);
346: fnd_message.set_token('EBL_RSLT',J.ebl_result);
347: fnd_file.put_line(fnd_file.log, fnd_message.get);
348:
349: ELSIF l_imported = 'N' THEN
350:
351: /* This means the record is manually entered so only the approved result should be updated */

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

369: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
370: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
371: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);
372: fnd_message.set_token('EBL_RSLT',J.ebl_result);
373: fnd_file.put_line(fnd_file.log, fnd_message.get);
374: ELSE
375: --Diplays message "Updating record".
376: fnd_message.set_name('IGS','IGS_UC_UPD_QUAL_DETS_REC');
377: fnd_message.set_token('PER_NO', J.person_number);

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

386: fnd_message.set_token('PRD_RSLT',Cur_qual_dets_val.predicted_result);
387: fnd_message.set_token('EBL_RSLT',J.ebl_result);
388: fnd_message.set_token('CLM_RSLT',Cur_qual_dets_val.claimed_result);
389: fnd_message.set_token('TARIFF', Cur_qual_dets_val.ucas_tariff);
390: fnd_file.put_line(fnd_file.log, fnd_message.get);
391:
392: IF cur_qual_dets_val.grading_schema_cd IS NOT NULL
393: AND cur_qual_dets_val.version_number IS NOT NULL
394: AND j.ebl_result IS NOT NULL

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

400: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
401: fnd_message.set_token('GS_CD',cur_qual_dets_val.grading_schema_cd);
402: fnd_message.set_token('GS_VER',cur_qual_dets_val.version_number);
403: fnd_message.set_token('APP_RESULT',j.ebl_result);
404: fnd_file.put_line(fnd_file.log, fnd_message.get);
405: l_records_errored := NVL(l_records_errored ,0) + 1 ;
406:
407: ELSE
408:

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

451: fnd_message.set_token('GS_CD', C_grad_sch_rec.grading_schema_cd);
452: fnd_message.set_token('GS_VER', C_grad_sch_rec.gs_version_number);
453: fnd_message.set_token('EBL_RSLT',J.ebl_result);
454: fnd_message.set_token('CLM_RSLT',J.claimed_result);
455: fnd_file.put_line(fnd_file.log, fnd_message.get);
456:
457: l_rowid := NULL ;
458: l_validation_status := TRUE ;
459:

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

461: IF l_oss_exam_level IS NULL THEN
462: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
463: fnd_message.set_token('CODE',I.Exam_level);
464: fnd_message.set_token('TYPE', 'EXAM LEVEL');
465: fnd_file.put_line(fnd_file.log, fnd_message.get);
466: l_validation_status := FALSE ;
467: END IF ;
468:
469: -- Check whether the Grading Scema and Grade Combination exist in the Parent Table

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

478: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
479: fnd_message.set_token('GS_CD',c_grad_sch_rec.grading_schema_cd);
480: fnd_message.set_token('GS_VER',c_grad_sch_rec.gs_version_number);
481: fnd_message.set_token('APP_RESULT',j.ebl_result);
482: fnd_file.put_line(fnd_file.log, fnd_message.get);
483: l_validation_status := FALSE ;
484:
485: ELSIF c_grad_sch_rec.grading_schema_cd IS NOT NULL
486: AND c_grad_sch_rec.gs_version_number IS NOT NULL

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

493: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
494: fnd_message.set_token('GS_CD',c_grad_sch_rec.grading_schema_cd);
495: fnd_message.set_token('GS_VER',c_grad_sch_rec.gs_version_number);
496: fnd_message.set_token('APP_RESULT',j.claimed_result);
497: fnd_file.put_line(fnd_file.log, fnd_message.get);
498: l_validation_status := FALSE ;
499:
500: END IF ;
501:

Line 548: fnd_file.put_line(fnd_file.log,fnd_message.get()||l_mesg_data);

544: l_mesg_data := ' - '||l_mesg_data;
545: END IF;
546: END IF;
547: fnd_message.set_name('IGS','IGS_UC_QUAL_DET_IMP_ERR');
548: fnd_file.put_line(fnd_file.log,fnd_message.get()||l_mesg_data);
549:
550: END; -- End of Anonymous block
551:
552: fnd_file.put_line(fnd_file.log,' ' );

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

548: fnd_file.put_line(fnd_file.log,fnd_message.get()||l_mesg_data);
549:
550: END; -- End of Anonymous block
551:
552: fnd_file.put_line(fnd_file.log,' ' );
553: l_msg_count := NULL;
554:
555: END LOOP; -- Insert/Update Igs_uc_qual_dets looop
556:

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

555: END LOOP; -- Insert/Update Igs_uc_qual_dets looop
556:
557: END LOOP; -- igs_uc_com_ebl_subj Records Loop
558:
559: fnd_file.put_line(fnd_file.log,' ' );
560: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
561: fnd_file.put_line(fnd_file.log,SUBSTR(fnd_message.get_string('IGS','IGS_UC_INS_REC_STAT_INT'), 29, 22));
562: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
563: fnd_message.set_name('IGS','IGS_UC_DEL_REC_COUNT');

Line 560: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));

556:
557: END LOOP; -- igs_uc_com_ebl_subj Records Loop
558:
559: fnd_file.put_line(fnd_file.log,' ' );
560: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
561: fnd_file.put_line(fnd_file.log,SUBSTR(fnd_message.get_string('IGS','IGS_UC_INS_REC_STAT_INT'), 29, 22));
562: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
563: fnd_message.set_name('IGS','IGS_UC_DEL_REC_COUNT');
564: fnd_message.set_token('REC_CNT', NVL(l_records_deleted,0));

Line 561: fnd_file.put_line(fnd_file.log,SUBSTR(fnd_message.get_string('IGS','IGS_UC_INS_REC_STAT_INT'), 29, 22));

557: END LOOP; -- igs_uc_com_ebl_subj Records Loop
558:
559: fnd_file.put_line(fnd_file.log,' ' );
560: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
561: fnd_file.put_line(fnd_file.log,SUBSTR(fnd_message.get_string('IGS','IGS_UC_INS_REC_STAT_INT'), 29, 22));
562: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
563: fnd_message.set_name('IGS','IGS_UC_DEL_REC_COUNT');
564: fnd_message.set_token('REC_CNT', NVL(l_records_deleted,0));
565: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 562: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));

558:
559: fnd_file.put_line(fnd_file.log,' ' );
560: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
561: fnd_file.put_line(fnd_file.log,SUBSTR(fnd_message.get_string('IGS','IGS_UC_INS_REC_STAT_INT'), 29, 22));
562: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
563: fnd_message.set_name('IGS','IGS_UC_DEL_REC_COUNT');
564: fnd_message.set_token('REC_CNT', NVL(l_records_deleted,0));
565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: fnd_message.set_name('IGS','IGS_UC_INS_REC_COUNT');

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

561: fnd_file.put_line(fnd_file.log,SUBSTR(fnd_message.get_string('IGS','IGS_UC_INS_REC_STAT_INT'), 29, 22));
562: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
563: fnd_message.set_name('IGS','IGS_UC_DEL_REC_COUNT');
564: fnd_message.set_token('REC_CNT', NVL(l_records_deleted,0));
565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: fnd_message.set_name('IGS','IGS_UC_INS_REC_COUNT');
567: fnd_message.set_token('REC_CNT', NVL(l_records_inserted,0));
568: fnd_file.put_line(fnd_file.log, fnd_message.get);
569: fnd_message.set_name('IGS','IGS_UC_UPD_REC_COUNT');

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

564: fnd_message.set_token('REC_CNT', NVL(l_records_deleted,0));
565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: fnd_message.set_name('IGS','IGS_UC_INS_REC_COUNT');
567: fnd_message.set_token('REC_CNT', NVL(l_records_inserted,0));
568: fnd_file.put_line(fnd_file.log, fnd_message.get);
569: fnd_message.set_name('IGS','IGS_UC_UPD_REC_COUNT');
570: fnd_message.set_token('REC_CNT', NVL(l_records_updated,0));
571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572: fnd_message.set_name('IGS','IGS_UC_ERR_REC_COUNT');

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

567: fnd_message.set_token('REC_CNT', NVL(l_records_inserted,0));
568: fnd_file.put_line(fnd_file.log, fnd_message.get);
569: fnd_message.set_name('IGS','IGS_UC_UPD_REC_COUNT');
570: fnd_message.set_token('REC_CNT', NVL(l_records_updated,0));
571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572: fnd_message.set_name('IGS','IGS_UC_ERR_REC_COUNT');
573: fnd_message.set_token('REC_CNT', NVL(l_records_errored,0));
574: fnd_file.put_line(fnd_file.log, fnd_message.get);
575: fnd_file.put_line(fnd_file.log,' ' );

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

570: fnd_message.set_token('REC_CNT', NVL(l_records_updated,0));
571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572: fnd_message.set_name('IGS','IGS_UC_ERR_REC_COUNT');
573: fnd_message.set_token('REC_CNT', NVL(l_records_errored,0));
574: fnd_file.put_line(fnd_file.log, fnd_message.get);
575: fnd_file.put_line(fnd_file.log,' ' );
576:
577:
578: EXCEPTION

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

571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572: fnd_message.set_name('IGS','IGS_UC_ERR_REC_COUNT');
573: fnd_message.set_token('REC_CNT', NVL(l_records_errored,0));
574: fnd_file.put_line(fnd_file.log, fnd_message.get);
575: fnd_file.put_line(fnd_file.log,' ' );
576:
577:
578: EXCEPTION
579:

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

578: EXCEPTION
579:
580: WHEN igs_uc_he_not_enabled_excep THEN
581: fnd_message.set_name('IGS','IGS_UC_HE_NOT_ENABLED');
582: fnd_file.put_line(fnd_file.log, fnd_message.get);
583: retcode := 2;
584: igs_ge_msg_stack.conc_exception_hndl;
585:
586: WHEN OTHERS THEN