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

Line 131: fnd_file.put_line(fnd_file.LOG,fnd_message.get());

127: END IF ;
128: -- even though the admission import process completes in error , this process should continue processing
129: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
130: fnd_message.set_token('NAME','IGS_UC_EXPORT_HESA_TO_OSS_PKG.IMPORT_PROCESS'||' - '||SQLERRM);
131: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
132: END import_process;
133:
134:
135: PROCEDURE export_data(errbuf OUT NOCOPY VARCHAR2,

Line 354: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

350: FETCH cur_all_applicants INTO all_appl_rec;
351: /* If there are no applicants with sent_to_hesa value = 'N' then make an entry into the log file */
352: IF (cur_all_applicants%NOTFOUND) THEN
353:
354: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
355: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get_string('IGS','IGS_UC_HE_NO_DATA'));
356: retcode:=1;
357: RETURN;
358:

Line 355: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get_string('IGS','IGS_UC_HE_NO_DATA'));

351: /* If there are no applicants with sent_to_hesa value = 'N' then make an entry into the log file */
352: IF (cur_all_applicants%NOTFOUND) THEN
353:
354: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
355: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get_string('IGS','IGS_UC_HE_NO_DATA'));
356: retcode:=1;
357: RETURN;
358:
359: END IF;

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

367: FOR l_ucas_setup_rec IN cur_ucas_setup(p_person_id)
368: LOOP
369: fnd_message.set_name('IGS','IGS_UC_SETUP_PREV_INST_DET');
370: fnd_message.set_token('SYSTEM',l_ucas_setup_rec.system_code);
371: fnd_file.put_line(fnd_file.log,fnd_message.get);
372: l_no_setup := 'Y';
373: END LOOP;
374:
375: -- Check whether the Person Source Type 'UCAS PER' defined in the setup

Line 381: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

377: OPEN cur_src_type_id;
378: FETCH cur_src_type_id INTO l_src_type_id_rec;
379: IF cur_src_type_id%NOTFOUND THEN
380: fnd_message.set_name('IGS','IGS_UC_NO_UCAS_SRC_TYP');
381: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
382: l_no_setup := 'Y';
383: ELSE
384:
385: -- Check the Admission Source Categories Setup included the Category. If included Populate

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

388: FETCH cur_pe_src_cat INTO l_rec_found;
389: IF cur_pe_src_cat%NOTFOUND THEN
390: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
391: fnd_message.set_token('INT_TYPE', 'STATISTIC');
392: fnd_file.put_line(fnd_file.log, fnd_message.get);
393: l_no_setup := 'Y';
394: END IF;
395: CLOSE cur_pe_src_cat;
396:

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

405: /* Loop through all the UCAS Applicant records whose data need to be exported */
406:
407: FOR all_appl_rec IN cur_all_applicants(p_person_id) LOOP
408:
409: fnd_file.put_line(fnd_file.log,' ');
410: /* check if the person is present in OSS, if not then donot process the person */
411: chk_person_present(all_appl_rec.oss_person_id, l_chk_per_present);
412: IF (l_chk_per_present = 'N') THEN
413:

Line 416: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.get );

412: IF (l_chk_per_present = 'N') THEN
413:
414: FND_MESSAGE.Set_Name('IGS','IGS_UC_HE_NO_PERS');
415: FND_MESSAGE.Set_Token('PERSON_ID',all_appl_rec.app_no);
416: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.get );
417: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get_string('IGS','IGS_UC_HE_NOT_PROC') );
418:
419: ELSE /* If the person details present in OSS*/
420:

Line 417: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get_string('IGS','IGS_UC_HE_NOT_PROC') );

413:
414: FND_MESSAGE.Set_Name('IGS','IGS_UC_HE_NO_PERS');
415: FND_MESSAGE.Set_Token('PERSON_ID',all_appl_rec.app_no);
416: FND_FILE.PUT_LINE (FND_FILE.LOG,FND_MESSAGE.get );
417: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get_string('IGS','IGS_UC_HE_NOT_PROC') );
418:
419: ELSE /* If the person details present in OSS*/
420:
421: l_mapping_failed := 'N';

Line 444: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get );

440:
441: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_DOM_MAPPING');
442: FND_MESSAGE.Set_Token('PERSON_ID',l_person_number);
443: FND_MESSAGE.Set_Token('CODE',all_appl_rec.domicile_apr);
444: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get );
445: l_mapping_failed := 'Y';
446:
447: END IF ;
448: CLOSE cur_ucas_oss_map;

Line 468: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get );

464:
465: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_OCC_MAPPING');
466: FND_MESSAGE.Set_Token('PERSON_ID',l_person_number);
467: FND_MESSAGE.Set_Token('CODE',all_appl_rec.starh_pocc );
468: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get );
469: l_mapping_failed := 'Y';
470:
471: END IF;
472: CLOSE cur_ucas_oss_map;

Line 488: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get );

484:
485: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_SOC_MAPPING');
486: FND_MESSAGE.Set_Token('PERSON_ID',l_person_number);
487: FND_MESSAGE.Set_Token('CODE',all_appl_rec.starh_socio_economic );
488: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get );
489: l_mapping_failed := 'Y';
490:
491: END IF ;
492: CLOSE cur_ucas_oss_map;

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

523: l_mapping_failed := 'Y';
524: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
525: fnd_message.set_token('CODE',l_ethnic_cd );
526: fnd_message.set_token('TYPE','ETHNIC' );
527: fnd_file.put_line(fnd_file.log, fnd_message.get);
528: END IF;
529: CLOSE cur_ucas_oss_map;
530: END IF ;
531:

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

538: l_mapping_failed := 'Y';
539: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
540: fnd_message.set_token('CODE',l_app_stat_rec.ivstarx_religion );
541: fnd_message.set_token('TYPE','RELIGION' );
542: fnd_file.put_line(fnd_file.log, fnd_message.get);
543: END IF;
544: CLOSE cur_ucas_oss_map;
545: END IF;
546:

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

741: fnd_message.set_token('SYS_CODE1',all_appl_rec.system_code);
742: fnd_message.set_token('APP_NO2',l_max_sys_ethnic.app_no);
743: fnd_message.set_token('SYS_CODE2',l_max_sys_ethnic.system_code);
744: fnd_message.set_token('PER_NO',l_person_number);
745: fnd_file.put_line(fnd_file.log,fnd_message.get);
746: END IF; -- checking for system code
747:
748:
749:

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

785: IF l_stat_int_rec_populated = 'Y' THEN
786: /* Record the successful export of HESA details into Interface tables in log file */
787: fnd_message.set_name('IGS','IGS_UC_EXP_STAT_INT_SUCC') ;
788: fnd_message.set_token('PERSON_NO',l_person_number);
789: fnd_file.put_line(fnd_file.log,fnd_message.get);
790: END IF;
791:
792: /* Record the successful export of HESA details into OSS in log file */
793: fnd_message.set_name('IGS','IGS_UC_EXP_SUCC') ;

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

791:
792: /* Record the successful export of HESA details into OSS in log file */
793: fnd_message.set_name('IGS','IGS_UC_EXP_SUCC') ;
794: fnd_message.set_token('PERSON_ID',l_person_number);
795: fnd_file.put_line(fnd_file.log,fnd_message.get);
796:
797: END IF; --End of l_error_occurred = 'N' check.
798:
799: END IF ; /* End mapping failed check */

Line 808: fnd_file.put_line( fnd_file.LOG ,' ');

804:
805: -- If Academic History import interface tables have been populated
806: -- then call the import process
807: IF l_imp_batch_id IS NOT NULL THEN
808: fnd_file.put_line( fnd_file.LOG ,' ');
809: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');
810: fnd_message.set_token('REQ_ID',TO_CHAR(l_imp_batch_id));
811: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
812: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');

Line 811: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

807: IF l_imp_batch_id IS NOT NULL THEN
808: fnd_file.put_line( fnd_file.LOG ,' ');
809: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');
810: fnd_message.set_token('REQ_ID',TO_CHAR(l_imp_batch_id));
811: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
812: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
813: COMMIT;
814: --Call the import_process() procedure to launch the AD import process.
815: import_process(l_src_type_id_rec.source_type_id, l_imp_batch_id);

Line 812: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');

808: fnd_file.put_line( fnd_file.LOG ,' ');
809: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');
810: fnd_message.set_token('REQ_ID',TO_CHAR(l_imp_batch_id));
811: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
812: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
813: COMMIT;
814: --Call the import_process() procedure to launch the AD import process.
815: import_process(l_src_type_id_rec.source_type_id, l_imp_batch_id);
816: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');

Line 816: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');

812: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
813: COMMIT;
814: --Call the import_process() procedure to launch the AD import process.
815: import_process(l_src_type_id_rec.source_type_id, l_imp_batch_id);
816: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
817: fnd_file.put_line( fnd_file.LOG ,' ');
818:
819: -- For each import interface record corresponding the Admissions Batch ID
820: FOR l_imp_int_rec IN c_adm_int(l_imp_batch_id) LOOP

Line 817: fnd_file.put_line( fnd_file.LOG ,' ');

813: COMMIT;
814: --Call the import_process() procedure to launch the AD import process.
815: import_process(l_src_type_id_rec.source_type_id, l_imp_batch_id);
816: fnd_file.put_line( fnd_file.LOG ,'-----------------------------------');
817: fnd_file.put_line( fnd_file.LOG ,' ');
818:
819: -- For each import interface record corresponding the Admissions Batch ID
820: FOR l_imp_int_rec IN c_adm_int(l_imp_batch_id) LOOP
821:

Line 832: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);

828: fnd_message.set_name('IGS','IGS_UC_IMP_STAT_FAIL');
829: fnd_message.set_token('PERSON_NO',l_imp_int_rec.person_number);
830: fnd_message.set_token('ETHNIC', l_interface_stat_rec.ethnic_origin);
831: fnd_message.set_token('INT_ID', l_imp_int_rec.interface_id);
832: fnd_file.put_line( fnd_file.LOG ,fnd_message.get);
833: END IF;
834: CLOSE c_stat_int;
835: END LOOP ;
836:

Line 849: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQLERRM -> ' || SQLERRM);

845:
846: WHEN OTHERS THEN
847: ROLLBACK;
848: retcode :=2;
849: FND_FILE.PUT_LINE(FND_FILE.LOG,'SQLERRM -> ' || SQLERRM);
850: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
851: FND_MESSAGE.Set_Token('NAME','igs_uc_export_hesa_to_oss_pkg.export_data');
852: errbuf :=FND_MESSAGE.get ;
853: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;