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_MESSAGE

Line 129: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

125: IF cur_match_set%ISOPEN THEN
126: CLOSE cur_match_set;
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:

Line 130: fnd_message.set_token('NAME','IGS_UC_EXPORT_HESA_TO_OSS_PKG.IMPORT_PROCESS'||' - '||SQLERRM);

126: CLOSE cur_match_set;
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:

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 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 369: fnd_message.set_name('IGS','IGS_UC_SETUP_PREV_INST_DET');

365: l_rec_found := 'N';
366: l_no_setup := 'N';
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;

Line 370: fnd_message.set_token('SYSTEM',l_ucas_setup_rec.system_code);

366: l_no_setup := 'N';
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:

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 380: fnd_message.set_name('IGS','IGS_UC_NO_UCAS_SRC_TYP');

376: l_src_type_id_rec := NULL ;
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:

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 390: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');

386: -- the Interface Table, so that this record will be processed by the Admission Import Process
387: OPEN cur_pe_src_cat(l_src_type_id_rec.source_type_id,'PERSON_STATISTICS');
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;

Line 391: fnd_message.set_token('INT_TYPE', 'STATISTIC');

387: OPEN cur_pe_src_cat(l_src_type_id_rec.source_type_id,'PERSON_STATISTICS');
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;

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 414: FND_MESSAGE.Set_Name('IGS','IGS_UC_HE_NO_PERS');

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:
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:

Line 415: FND_MESSAGE.Set_Token('PERSON_ID',all_appl_rec.app_no);

411: chk_person_present(all_appl_rec.oss_person_id, l_chk_per_present);
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*/

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 441: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_DOM_MAPPING');

437: FETCH cur_ucas_oss_map INTO l_dom_cd;
438:
439: IF cur_ucas_oss_map%NOTFOUND THEN
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';

Line 442: FND_MESSAGE.Set_Token('PERSON_ID',l_person_number);

438:
439: IF cur_ucas_oss_map%NOTFOUND THEN
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:

Line 443: FND_MESSAGE.Set_Token('CODE',all_appl_rec.domicile_apr);

439: IF cur_ucas_oss_map%NOTFOUND THEN
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 ;

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 465: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_OCC_MAPPING');

461: FETCH cur_ucas_oss_map INTO l_occ_code;
462:
463: IF cur_ucas_oss_map%NOTFOUND THEN
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';

Line 466: FND_MESSAGE.Set_Token('PERSON_ID',l_person_number);

462:
463: IF cur_ucas_oss_map%NOTFOUND THEN
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:

Line 467: FND_MESSAGE.Set_Token('CODE',all_appl_rec.starh_pocc );

463: IF cur_ucas_oss_map%NOTFOUND THEN
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;

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 485: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_SOC_MAPPING');

481: OPEN cur_ucas_oss_map('UC_OSS_HE_SOC_ASSOC',all_appl_rec.starh_socio_economic);
482: FETCH cur_ucas_oss_map INTO l_soc_code;
483: IF cur_ucas_oss_map%NOTFOUND THEN
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';

Line 486: FND_MESSAGE.Set_Token('PERSON_ID',l_person_number);

482: FETCH cur_ucas_oss_map INTO l_soc_code;
483: IF cur_ucas_oss_map%NOTFOUND THEN
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:

Line 487: FND_MESSAGE.Set_Token('CODE',all_appl_rec.starh_socio_economic );

483: IF cur_ucas_oss_map%NOTFOUND THEN
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 ;

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 524: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');

520: FETCH cur_ucas_oss_map INTO l_oss_ethnic_origin;
521: IF cur_ucas_oss_map%NOTFOUND THEN
522: l_oss_ethnic_origin := NULL;
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;

Line 525: fnd_message.set_token('CODE',l_ethnic_cd );

521: IF cur_ucas_oss_map%NOTFOUND THEN
522: l_oss_ethnic_origin := NULL;
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;

Line 526: fnd_message.set_token('TYPE','ETHNIC' );

522: l_oss_ethnic_origin := NULL;
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 ;

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 539: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');

535: FETCH cur_ucas_oss_map INTO l_oss_religion_cd;
536: IF cur_ucas_oss_map%NOTFOUND THEN
537: l_oss_religion_cd := NULL;
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;

Line 540: fnd_message.set_token('CODE',l_app_stat_rec.ivstarx_religion );

536: IF cur_ucas_oss_map%NOTFOUND THEN
537: l_oss_religion_cd := NULL;
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;

Line 541: fnd_message.set_token('TYPE','RELIGION' );

537: l_oss_religion_cd := NULL;
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;

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 648: fnd_message.get_string('IGS','IGS_UC_IMP_ACAD_HIST_BATCH_ID'),

644: program_application_id,
645: program_update_date,
646: program_id)
647: VALUES ( l_imp_batch_id,
648: fnd_message.get_string('IGS','IGS_UC_IMP_ACAD_HIST_BATCH_ID'),
649: fnd_global.user_id,
650: SYSDATE,
651: fnd_global.user_id,
652: SYSDATE,

Line 739: fnd_message.set_name('IGS','IGS_UC_SYS_STAT_NOT_IMP') ;

735: l_stat_int_rec_populated := 'Y';
736:
737: END IF; -- checking l_error_code
738: ELSE
739: fnd_message.set_name('IGS','IGS_UC_SYS_STAT_NOT_IMP') ;
740: fnd_message.set_token('APP_NO1',all_appl_rec.app_no);
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);

Line 740: fnd_message.set_token('APP_NO1',all_appl_rec.app_no);

736:
737: END IF; -- checking l_error_code
738: ELSE
739: fnd_message.set_name('IGS','IGS_UC_SYS_STAT_NOT_IMP') ;
740: fnd_message.set_token('APP_NO1',all_appl_rec.app_no);
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);

Line 741: fnd_message.set_token('SYS_CODE1',all_appl_rec.system_code);

737: END IF; -- checking l_error_code
738: ELSE
739: fnd_message.set_name('IGS','IGS_UC_SYS_STAT_NOT_IMP') ;
740: fnd_message.set_token('APP_NO1',all_appl_rec.app_no);
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);

Line 742: fnd_message.set_token('APP_NO2',l_max_sys_ethnic.app_no);

738: ELSE
739: fnd_message.set_name('IGS','IGS_UC_SYS_STAT_NOT_IMP') ;
740: fnd_message.set_token('APP_NO1',all_appl_rec.app_no);
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

Line 743: fnd_message.set_token('SYS_CODE2',l_max_sys_ethnic.system_code);

739: fnd_message.set_name('IGS','IGS_UC_SYS_STAT_NOT_IMP') ;
740: fnd_message.set_token('APP_NO1',all_appl_rec.app_no);
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:

Line 744: fnd_message.set_token('PER_NO',l_person_number);

740: fnd_message.set_token('APP_NO1',all_appl_rec.app_no);
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:

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 787: fnd_message.set_name('IGS','IGS_UC_EXP_STAT_INT_SUCC') ;

783: END LOOP;
784:
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:

Line 788: fnd_message.set_token('PERSON_NO',l_person_number);

784:
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 */

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 793: fnd_message.set_name('IGS','IGS_UC_EXP_SUCC') ;

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') ;
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.

Line 794: fnd_message.set_token('PERSON_ID',l_person_number);

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') ;
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:

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 809: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');

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 ,'-----------------------------------');
813: COMMIT;

Line 810: fnd_message.set_token('REQ_ID',TO_CHAR(l_imp_batch_id));

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 ,'-----------------------------------');
813: COMMIT;
814: --Call the import_process() procedure to launch the AD import process.

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 828: fnd_message.set_name('IGS','IGS_UC_IMP_STAT_FAIL');

824: OPEN c_stat_int(l_imp_int_rec.interface_id);
825: FETCH c_stat_int INTO l_interface_stat_rec;
826: IF c_stat_int%FOUND THEN
827: --When Statistic import failed.
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);

Line 829: fnd_message.set_token('PERSON_NO',l_imp_int_rec.person_number);

825: FETCH c_stat_int INTO l_interface_stat_rec;
826: IF c_stat_int%FOUND THEN
827: --When Statistic import failed.
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;

Line 830: fnd_message.set_token('ETHNIC', l_interface_stat_rec.ethnic_origin);

826: IF c_stat_int%FOUND THEN
827: --When Statistic import failed.
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;

Line 831: fnd_message.set_token('INT_ID', l_imp_int_rec.interface_id);

827: --When Statistic import failed.
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 ;

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 843: errbuf :=FND_MESSAGE.get_string('IGS','IGS_UC_HE_NOT_ENABLED');

839: EXCEPTION
840:
841: WHEN IGS_UC_HE_NOT_ENABLED_EXCEP THEN
842: retcode :=2;
843: errbuf :=FND_MESSAGE.get_string('IGS','IGS_UC_HE_NOT_ENABLED');
844: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
845:
846: WHEN OTHERS THEN
847: ROLLBACK;

Line 850: FND_MESSAGE.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

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;
854:

Line 851: FND_MESSAGE.Set_Token('NAME','igs_uc_export_hesa_to_oss_pkg.export_data');

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;
854:
855: END export_data;

Line 852: errbuf :=FND_MESSAGE.get ;

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;
854:
855: END export_data;
856: