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_EXP_APPLICANT_DTLS dependencies on FND_MESSAGE

Line 371: fnd_message.set_name('IGS','IGS_UC_APPNO_NOT_FOUND');

367: -- anwest Bug# 4080259 Moved logging of this error message to outside
368: -- FOR LOOP to catch applicants without any choices
369: IF l_count = 0 THEN
370: fnd_file.put_line( fnd_file.LOG ,' ');
371: fnd_message.set_name('IGS','IGS_UC_APPNO_NOT_FOUND');
372: fnd_message.set_token('APP_NO', p_app_no);
373: fnd_file.put_line(fnd_file.log, fnd_message.get);
374: ELSIF p_term_cal_type IS NULL OR p_term_sequence_number IS NULL THEN
375: fnd_file.put_line( fnd_file.LOG ,' ');

Line 372: fnd_message.set_token('APP_NO', p_app_no);

368: -- FOR LOOP to catch applicants without any choices
369: IF l_count = 0 THEN
370: fnd_file.put_line( fnd_file.LOG ,' ');
371: fnd_message.set_name('IGS','IGS_UC_APPNO_NOT_FOUND');
372: fnd_message.set_token('APP_NO', p_app_no);
373: fnd_file.put_line(fnd_file.log, fnd_message.get);
374: ELSIF p_term_cal_type IS NULL OR p_term_sequence_number IS NULL THEN
375: fnd_file.put_line( fnd_file.LOG ,' ');
376: fnd_message.set_name('IGS','IGS_UC_NO_TERM_CAL');

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

369: IF l_count = 0 THEN
370: fnd_file.put_line( fnd_file.LOG ,' ');
371: fnd_message.set_name('IGS','IGS_UC_APPNO_NOT_FOUND');
372: fnd_message.set_token('APP_NO', p_app_no);
373: fnd_file.put_line(fnd_file.log, fnd_message.get);
374: ELSIF p_term_cal_type IS NULL OR p_term_sequence_number IS NULL THEN
375: fnd_file.put_line( fnd_file.LOG ,' ');
376: fnd_message.set_name('IGS','IGS_UC_NO_TERM_CAL');
377: fnd_message.set_token('APP_NO', p_app_no);

Line 376: fnd_message.set_name('IGS','IGS_UC_NO_TERM_CAL');

372: fnd_message.set_token('APP_NO', p_app_no);
373: fnd_file.put_line(fnd_file.log, fnd_message.get);
374: ELSIF p_term_cal_type IS NULL OR p_term_sequence_number IS NULL THEN
375: fnd_file.put_line( fnd_file.LOG ,' ');
376: fnd_message.set_name('IGS','IGS_UC_NO_TERM_CAL');
377: fnd_message.set_token('APP_NO', p_app_no);
378: fnd_file.put_line(fnd_file.log, fnd_message.get);
379: END IF;
380:

Line 377: fnd_message.set_token('APP_NO', p_app_no);

373: fnd_file.put_line(fnd_file.log, fnd_message.get);
374: ELSIF p_term_cal_type IS NULL OR p_term_sequence_number IS NULL THEN
375: fnd_file.put_line( fnd_file.LOG ,' ');
376: fnd_message.set_name('IGS','IGS_UC_NO_TERM_CAL');
377: fnd_message.set_token('APP_NO', p_app_no);
378: fnd_file.put_line(fnd_file.log, fnd_message.get);
379: END IF;
380:
381: EXCEPTION

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

374: ELSIF p_term_cal_type IS NULL OR p_term_sequence_number IS NULL THEN
375: fnd_file.put_line( fnd_file.LOG ,' ');
376: fnd_message.set_name('IGS','IGS_UC_NO_TERM_CAL');
377: fnd_message.set_token('APP_NO', p_app_no);
378: fnd_file.put_line(fnd_file.log, fnd_message.get);
379: END IF;
380:
381: EXCEPTION
382:

Line 385: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

381: EXCEPTION
382:
383: WHEN OTHERS THEN
384: p_app_valid_status := FALSE;
385: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
386: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.GET_TERM_DTLS'||' - '||SQLERRM);
387: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
388:
389: END get_term_dtls;

Line 386: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.GET_TERM_DTLS'||' - '||SQLERRM);

382:
383: WHEN OTHERS THEN
384: p_app_valid_status := FALSE;
385: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
386: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.GET_TERM_DTLS'||' - '||SQLERRM);
387: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
388:
389: END get_term_dtls;
390:

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

383: WHEN OTHERS THEN
384: p_app_valid_status := FALSE;
385: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
386: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.GET_TERM_DTLS'||' - '||SQLERRM);
387: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
388:
389: END get_term_dtls;
390:
391:

Line 403: fnd_message.set_name('IGS','IGS_UC_ADDR_USAGE_CORR');

399: retcode := 0;
400:
401: /* Validate parameters before starting the processing */
402: IF p_addr_usage_home IS NULL AND p_addr_usage_corr = 'HOME' THEN
403: fnd_message.set_name('IGS','IGS_UC_ADDR_USAGE_CORR');
404: errbuf := fnd_message.get;
405: fnd_file.put_line(fnd_file.LOG,errbuf);
406: retcode := 2 ;
407: RETURN;

Line 404: errbuf := fnd_message.get;

400:
401: /* Validate parameters before starting the processing */
402: IF p_addr_usage_home IS NULL AND p_addr_usage_corr = 'HOME' THEN
403: fnd_message.set_name('IGS','IGS_UC_ADDR_USAGE_CORR');
404: errbuf := fnd_message.get;
405: fnd_file.put_line(fnd_file.LOG,errbuf);
406: retcode := 2 ;
407: RETURN;
408: ELSIF p_addr_usage_corr IS NULL AND p_addr_usage_home = 'CORR' THEN

Line 409: fnd_message.set_name('IGS','IGS_UC_ADDR_USAGE_HOME');

405: fnd_file.put_line(fnd_file.LOG,errbuf);
406: retcode := 2 ;
407: RETURN;
408: ELSIF p_addr_usage_corr IS NULL AND p_addr_usage_home = 'CORR' THEN
409: fnd_message.set_name('IGS','IGS_UC_ADDR_USAGE_HOME');
410: errbuf := fnd_message.get;
411: fnd_file.put_line(fnd_file.LOG,errbuf);
412: retcode := 2 ;
413: RETURN;

Line 410: errbuf := fnd_message.get;

406: retcode := 2 ;
407: RETURN;
408: ELSIF p_addr_usage_corr IS NULL AND p_addr_usage_home = 'CORR' THEN
409: fnd_message.set_name('IGS','IGS_UC_ADDR_USAGE_HOME');
410: errbuf := fnd_message.get;
411: fnd_file.put_line(fnd_file.LOG,errbuf);
412: retcode := 2 ;
413: RETURN;
414: ELSIF p_addr_usage_corr = p_addr_usage_home THEN

Line 415: fnd_message.set_name('IGS','IGS_UC_ADDR_USAGE_SAME');

411: fnd_file.put_line(fnd_file.LOG,errbuf);
412: retcode := 2 ;
413: RETURN;
414: ELSIF p_addr_usage_corr = p_addr_usage_home THEN
415: fnd_message.set_name('IGS','IGS_UC_ADDR_USAGE_SAME');
416: errbuf := fnd_message.get;
417: fnd_file.put_line(fnd_file.LOG,errbuf);
418: retcode := 2 ;
419: RETURN;

Line 416: errbuf := fnd_message.get;

412: retcode := 2 ;
413: RETURN;
414: ELSIF p_addr_usage_corr = p_addr_usage_home THEN
415: fnd_message.set_name('IGS','IGS_UC_ADDR_USAGE_SAME');
416: errbuf := fnd_message.get;
417: fnd_file.put_line(fnd_file.LOG,errbuf);
418: retcode := 2 ;
419: RETURN;
420: END IF;

Line 433: fnd_message.set_name('IGS','IGS_UC_NO_UCAS_SRC_TYP');

429: FETCH cur_pe_src_types INTO l_src_type_id;
430: IF cur_pe_src_types%NOTFOUND THEN
431:
432: fnd_file.put_line( fnd_file.LOG ,' ');
433: fnd_message.set_name('IGS','IGS_UC_NO_UCAS_SRC_TYP');
434: fnd_file.put_line(fnd_file.log, fnd_message.get);
435: l_mandatory_check := FALSE;
436:
437: END IF;

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

430: IF cur_pe_src_types%NOTFOUND THEN
431:
432: fnd_file.put_line( fnd_file.LOG ,' ');
433: fnd_message.set_name('IGS','IGS_UC_NO_UCAS_SRC_TYP');
434: fnd_file.put_line(fnd_file.log, fnd_message.get);
435: l_mandatory_check := FALSE;
436:
437: END IF;
438: CLOSE cur_pe_src_types;

Line 447: fnd_message.set_name('IGS','IGS_UC_NI_TYPE_NOT_SET');

443: FETCH cur_ninumber_alt_type INTO cur_ninumber_alt_type_rec ;
444: IF cur_ninumber_alt_type%FOUND AND cur_ninumber_alt_type_rec.ni_number_alt_pers_type IS NULL THEN
445:
446: fnd_file.put_line( fnd_file.LOG ,' ');
447: fnd_message.set_name('IGS','IGS_UC_NI_TYPE_NOT_SET');
448: fnd_message.set_token('SYSTEM_NAME', cur_ninumber_alt_type_rec.name);
449: fnd_file.put_line(fnd_file.log, fnd_message.get);
450: l_mandatory_check := FALSE;
451:

Line 448: fnd_message.set_token('SYSTEM_NAME', cur_ninumber_alt_type_rec.name);

444: IF cur_ninumber_alt_type%FOUND AND cur_ninumber_alt_type_rec.ni_number_alt_pers_type IS NULL THEN
445:
446: fnd_file.put_line( fnd_file.LOG ,' ');
447: fnd_message.set_name('IGS','IGS_UC_NI_TYPE_NOT_SET');
448: fnd_message.set_token('SYSTEM_NAME', cur_ninumber_alt_type_rec.name);
449: fnd_file.put_line(fnd_file.log, fnd_message.get);
450: l_mandatory_check := FALSE;
451:
452: END IF;

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

445:
446: fnd_file.put_line( fnd_file.LOG ,' ');
447: fnd_message.set_name('IGS','IGS_UC_NI_TYPE_NOT_SET');
448: fnd_message.set_token('SYSTEM_NAME', cur_ninumber_alt_type_rec.name);
449: fnd_file.put_line(fnd_file.log, fnd_message.get);
450: l_mandatory_check := FALSE;
451:
452: END IF;
453: CLOSE cur_ninumber_alt_type;

Line 459: fnd_message.set_name('IGS','IGS_UC_RES_CLASS_NOT_DEF');

455: -- Check whether the Residency Class Profile is defined for Residency Category import
456: IF fnd_profile.value('IGS_FI_RES_CLASS_ID') IS NULL THEN
457:
458: fnd_file.put_line( fnd_file.LOG ,' ');
459: fnd_message.set_name('IGS','IGS_UC_RES_CLASS_NOT_DEF');
460: fnd_file.put_line(fnd_file.log, fnd_message.get);
461: l_mandatory_check := FALSE;
462:
463: END IF;

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

456: IF fnd_profile.value('IGS_FI_RES_CLASS_ID') IS NULL THEN
457:
458: fnd_file.put_line( fnd_file.LOG ,' ');
459: fnd_message.set_name('IGS','IGS_UC_RES_CLASS_NOT_DEF');
460: fnd_file.put_line(fnd_file.log, fnd_message.get);
461: l_mandatory_check := FALSE;
462:
463: END IF;
464:

Line 475: fnd_message.set_name('IGS','IGS_UC_SETUP_DEC_MAKE');

471: FETCH cur_chk_dcsn_maker_setup INTO chk_dcsn_maker_setup_rec;
472: CLOSE cur_chk_dcsn_maker_setup;
473:
474: IF chk_dcsn_maker_setup_rec.decision_make_id IS NULL THEN
475: fnd_message.set_name('IGS','IGS_UC_SETUP_DEC_MAKE');
476: fnd_message.set_token('SYSTEM', chk_dcsn_maker_setup_rec.name );
477: fnd_file.put_line(fnd_file.log, fnd_message.get);
478: l_mandatory_check := FALSE;
479: END IF;

Line 476: fnd_message.set_token('SYSTEM', chk_dcsn_maker_setup_rec.name );

472: CLOSE cur_chk_dcsn_maker_setup;
473:
474: IF chk_dcsn_maker_setup_rec.decision_make_id IS NULL THEN
475: fnd_message.set_name('IGS','IGS_UC_SETUP_DEC_MAKE');
476: fnd_message.set_token('SYSTEM', chk_dcsn_maker_setup_rec.name );
477: fnd_file.put_line(fnd_file.log, fnd_message.get);
478: l_mandatory_check := FALSE;
479: END IF;
480:

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

473:
474: IF chk_dcsn_maker_setup_rec.decision_make_id IS NULL THEN
475: fnd_message.set_name('IGS','IGS_UC_SETUP_DEC_MAKE');
476: fnd_message.set_token('SYSTEM', chk_dcsn_maker_setup_rec.name );
477: fnd_file.put_line(fnd_file.log, fnd_message.get);
478: l_mandatory_check := FALSE;
479: END IF;
480:
481: END LOOP;

Line 497: fnd_message.set_name('IGS','IGS_UC_CYCLE_NOT_FOUND');

493: l_max_curr_cycle IS NULL THEN
494:
495: CLOSE cur_get_current_cycle;
496: fnd_file.put_line(fnd_file.LOG ,' ');
497: fnd_message.set_name('IGS','IGS_UC_CYCLE_NOT_FOUND');
498: fnd_file.put_line(fnd_file.log, fnd_message.get);
499: l_mandatory_check := FALSE;
500:
501: ELSE

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

494:
495: CLOSE cur_get_current_cycle;
496: fnd_file.put_line(fnd_file.LOG ,' ');
497: fnd_message.set_name('IGS','IGS_UC_CYCLE_NOT_FOUND');
498: fnd_file.put_line(fnd_file.log, fnd_message.get);
499: l_mandatory_check := FALSE;
500:
501: ELSE
502:

Line 527: fnd_message.set_name('IGS','IGS_UC_NO_LOAD_CAL_FOUND');

523:
524: IF l_res_term_loc = 0 THEN
525:
526: fnd_file.put_line(fnd_file.LOG ,' ');
527: fnd_message.set_name('IGS','IGS_UC_NO_LOAD_CAL_FOUND');
528: fnd_message.set_token('PREV_CYCLE', l_max_curr_cycle - 1);
529: fnd_message.set_token('CURR_CYCLE', l_max_curr_cycle);
530: fnd_message.set_token('NEXT_CYCLE', l_max_curr_cycle + 1);
531: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 528: fnd_message.set_token('PREV_CYCLE', l_max_curr_cycle - 1);

524: IF l_res_term_loc = 0 THEN
525:
526: fnd_file.put_line(fnd_file.LOG ,' ');
527: fnd_message.set_name('IGS','IGS_UC_NO_LOAD_CAL_FOUND');
528: fnd_message.set_token('PREV_CYCLE', l_max_curr_cycle - 1);
529: fnd_message.set_token('CURR_CYCLE', l_max_curr_cycle);
530: fnd_message.set_token('NEXT_CYCLE', l_max_curr_cycle + 1);
531: fnd_file.put_line(fnd_file.log, fnd_message.get);
532: l_mandatory_check := FALSE;

Line 529: fnd_message.set_token('CURR_CYCLE', l_max_curr_cycle);

525:
526: fnd_file.put_line(fnd_file.LOG ,' ');
527: fnd_message.set_name('IGS','IGS_UC_NO_LOAD_CAL_FOUND');
528: fnd_message.set_token('PREV_CYCLE', l_max_curr_cycle - 1);
529: fnd_message.set_token('CURR_CYCLE', l_max_curr_cycle);
530: fnd_message.set_token('NEXT_CYCLE', l_max_curr_cycle + 1);
531: fnd_file.put_line(fnd_file.log, fnd_message.get);
532: l_mandatory_check := FALSE;
533:

Line 530: fnd_message.set_token('NEXT_CYCLE', l_max_curr_cycle + 1);

526: fnd_file.put_line(fnd_file.LOG ,' ');
527: fnd_message.set_name('IGS','IGS_UC_NO_LOAD_CAL_FOUND');
528: fnd_message.set_token('PREV_CYCLE', l_max_curr_cycle - 1);
529: fnd_message.set_token('CURR_CYCLE', l_max_curr_cycle);
530: fnd_message.set_token('NEXT_CYCLE', l_max_curr_cycle + 1);
531: fnd_file.put_line(fnd_file.log, fnd_message.get);
532: l_mandatory_check := FALSE;
533:
534: END IF;

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

527: fnd_message.set_name('IGS','IGS_UC_NO_LOAD_CAL_FOUND');
528: fnd_message.set_token('PREV_CYCLE', l_max_curr_cycle - 1);
529: fnd_message.set_token('CURR_CYCLE', l_max_curr_cycle);
530: fnd_message.set_token('NEXT_CYCLE', l_max_curr_cycle + 1);
531: fnd_file.put_line(fnd_file.log, fnd_message.get);
532: l_mandatory_check := FALSE;
533:
534: END IF;
535:

Line 554: fnd_message.set_name('IGS','IGS_UC_EXP_APPLCNT_DET');

550: -- Initialize the Batch ID to NULL
551: l_ad_batch_id := NULL;
552:
553: -- Log the message 'Exporting Applicant details to OSS' with TimeStamp
554: fnd_message.set_name('IGS','IGS_UC_EXP_APPLCNT_DET');
555: fnd_file.put_line(fnd_file.log, fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');
556: fnd_file.put_line( fnd_file.LOG ,' ');
557:
558: --jchakrab added for 3691176

Line 555: fnd_file.put_line(fnd_file.log, fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');

551: l_ad_batch_id := NULL;
552:
553: -- Log the message 'Exporting Applicant details to OSS' with TimeStamp
554: fnd_message.set_name('IGS','IGS_UC_EXP_APPLCNT_DET');
555: fnd_file.put_line(fnd_file.log, fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');
556: fnd_file.put_line( fnd_file.LOG ,' ');
557:
558: --jchakrab added for 3691176
559: IF p_app_no IS NULL THEN

Line 591: fnd_message.set_name('IGS','IGS_UC_APP_PER_ID_NOT_EXITS');

587: -- If OSS Person ID is null then log the message and stop processing the current applicant
588: IF cur_exp_applicant_dtls_rec.oss_person_id is NULL THEN
589:
590: -- Log the message 'OSS Person ID is not populated for the Application Number'
591: fnd_message.set_name('IGS','IGS_UC_APP_PER_ID_NOT_EXITS');
592: fnd_message.set_token('APP_NO',cur_exp_applicant_dtls_rec.app_no);
593: fnd_file.put_line(fnd_file.log, fnd_message.get);
594:
595: ELSE

Line 592: fnd_message.set_token('APP_NO',cur_exp_applicant_dtls_rec.app_no);

588: IF cur_exp_applicant_dtls_rec.oss_person_id is NULL THEN
589:
590: -- Log the message 'OSS Person ID is not populated for the Application Number'
591: fnd_message.set_name('IGS','IGS_UC_APP_PER_ID_NOT_EXITS');
592: fnd_message.set_token('APP_NO',cur_exp_applicant_dtls_rec.app_no);
593: fnd_file.put_line(fnd_file.log, fnd_message.get);
594:
595: ELSE
596:

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

589:
590: -- Log the message 'OSS Person ID is not populated for the Application Number'
591: fnd_message.set_name('IGS','IGS_UC_APP_PER_ID_NOT_EXITS');
592: fnd_message.set_token('APP_NO',cur_exp_applicant_dtls_rec.app_no);
593: fnd_file.put_line(fnd_file.log, fnd_message.get);
594:
595: ELSE
596:
597: -- get the Applicant Person Details in OSS

Line 604: fnd_message.set_name('IGS','IGS_UC_EXP_APP_DET_PROC');

600: FETCH cur_uc_person_dtls INTO cur_uc_person_dtls_rec;
601: CLOSE cur_uc_person_dtls;
602:
603: -- Log the message 'Processing the Applicant with Person Number: XXX and Application Number: XXX'
604: fnd_message.set_name('IGS','IGS_UC_EXP_APP_DET_PROC');
605: fnd_message.set_token('PER_NO',cur_uc_person_dtls_rec.person_number);
606: fnd_message.set_token('APP_NO',cur_exp_applicant_dtls_rec.app_no);
607: fnd_file.put_line(fnd_file.log, fnd_message.get);
608:

Line 605: fnd_message.set_token('PER_NO',cur_uc_person_dtls_rec.person_number);

601: CLOSE cur_uc_person_dtls;
602:
603: -- Log the message 'Processing the Applicant with Person Number: XXX and Application Number: XXX'
604: fnd_message.set_name('IGS','IGS_UC_EXP_APP_DET_PROC');
605: fnd_message.set_token('PER_NO',cur_uc_person_dtls_rec.person_number);
606: fnd_message.set_token('APP_NO',cur_exp_applicant_dtls_rec.app_no);
607: fnd_file.put_line(fnd_file.log, fnd_message.get);
608:
609: -- If the Batch ID is already generated use the same,

Line 606: fnd_message.set_token('APP_NO',cur_exp_applicant_dtls_rec.app_no);

602:
603: -- Log the message 'Processing the Applicant with Person Number: XXX and Application Number: XXX'
604: fnd_message.set_name('IGS','IGS_UC_EXP_APP_DET_PROC');
605: fnd_message.set_token('PER_NO',cur_uc_person_dtls_rec.person_number);
606: fnd_message.set_token('APP_NO',cur_exp_applicant_dtls_rec.app_no);
607: fnd_file.put_line(fnd_file.log, fnd_message.get);
608:
609: -- If the Batch ID is already generated use the same,
610: -- otherwise create the new Batch ID ( i.e. for First Time)

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

603: -- Log the message 'Processing the Applicant with Person Number: XXX and Application Number: XXX'
604: fnd_message.set_name('IGS','IGS_UC_EXP_APP_DET_PROC');
605: fnd_message.set_token('PER_NO',cur_uc_person_dtls_rec.person_number);
606: fnd_message.set_token('APP_NO',cur_exp_applicant_dtls_rec.app_no);
607: fnd_file.put_line(fnd_file.log, fnd_message.get);
608:
609: -- If the Batch ID is already generated use the same,
610: -- otherwise create the new Batch ID ( i.e. for First Time)
611: IF l_ad_batch_id IS NULL THEN

Line 629: fnd_message.get_string('IGS','IGS_UC_IMP_FROM_UCAS_BATCH_ID'),

625: program_update_date,
626: program_id )
627: VALUES (
628: IGS_AD_INTERFACE_BATCH_ID_S.NEXTVAL,
629: fnd_message.get_string('IGS','IGS_UC_IMP_FROM_UCAS_BATCH_ID'),
630: g_created_by,
631: SYSDATE,
632: g_last_updated_by,
633: SYSDATE,

Line 671: fnd_message.set_name('IGS','IGS_UC_INV_COUNTRY_MAP');

667: CLOSE cur_hesa_map;
668:
669: -- Log a warning if country code exists but OSS mapping doesn't
670: IF l_oss_country_code IS NULL AND cur_exp_applicant_dtls_rec.country_birth IS NOT NULL THEN
671: fnd_message.set_name('IGS','IGS_UC_INV_COUNTRY_MAP');
672: fnd_file.put_line(fnd_file.log, fnd_message.get);
673: END IF;
674:
675: INSERT INTO igs_ad_interface_all (

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

668:
669: -- Log a warning if country code exists but OSS mapping doesn't
670: IF l_oss_country_code IS NULL AND cur_exp_applicant_dtls_rec.country_birth IS NOT NULL THEN
671: fnd_message.set_name('IGS','IGS_UC_INV_COUNTRY_MAP');
672: fnd_file.put_line(fnd_file.log, fnd_message.get);
673: END IF;
674:
675: INSERT INTO igs_ad_interface_all (
676: interface_id,

Line 735: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');

731: l_ad_interface_id, l_app_valid_status);
732: ELSE
733:
734: -- Display the warning message in the log file
735: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
736: fnd_message.set_token('INT_TYPE', 'ALTERNATE PERSON ID');
737: fnd_file.put_line(fnd_file.log, fnd_message.get);
738:
739: END IF;

Line 736: fnd_message.set_token('INT_TYPE', 'ALTERNATE PERSON ID');

732: ELSE
733:
734: -- Display the warning message in the log file
735: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
736: fnd_message.set_token('INT_TYPE', 'ALTERNATE PERSON ID');
737: fnd_file.put_line(fnd_file.log, fnd_message.get);
738:
739: END IF;
740:

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

733:
734: -- Display the warning message in the log file
735: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
736: fnd_message.set_token('INT_TYPE', 'ALTERNATE PERSON ID');
737: fnd_file.put_line(fnd_file.log, fnd_message.get);
738:
739: END IF;
740:
741: END IF;

Line 782: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');

778:
779: ELSE
780:
781: -- Display the warning message in the log file
782: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
783: fnd_message.set_token('INT_TYPE', 'RESIDENCY');
784: fnd_file.put_line(fnd_file.log, fnd_message.get);
785:
786: END IF;

Line 783: fnd_message.set_token('INT_TYPE', 'RESIDENCY');

779: ELSE
780:
781: -- Display the warning message in the log file
782: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
783: fnd_message.set_token('INT_TYPE', 'RESIDENCY');
784: fnd_file.put_line(fnd_file.log, fnd_message.get);
785:
786: END IF;
787:

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

780:
781: -- Display the warning message in the log file
782: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
783: fnd_message.set_token('INT_TYPE', 'RESIDENCY');
784: fnd_file.put_line(fnd_file.log, fnd_message.get);
785:
786: END IF;
787:
788: END IF;

Line 806: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');

802: l_ad_interface_id, l_app_valid_status);
803: ELSE
804:
805: -- Display the warning message in the log file
806: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
807: fnd_message.set_token('INT_TYPE', 'INTERNATIONAL');
808: fnd_file.put_line(fnd_file.log, fnd_message.get);
809:
810: END IF;

Line 807: fnd_message.set_token('INT_TYPE', 'INTERNATIONAL');

803: ELSE
804:
805: -- Display the warning message in the log file
806: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
807: fnd_message.set_token('INT_TYPE', 'INTERNATIONAL');
808: fnd_file.put_line(fnd_file.log, fnd_message.get);
809:
810: END IF;
811:

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

804:
805: -- Display the warning message in the log file
806: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
807: fnd_message.set_token('INT_TYPE', 'INTERNATIONAL');
808: fnd_file.put_line(fnd_file.log, fnd_message.get);
809:
810: END IF;
811:
812: END IF;

Line 828: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');

824: l_ad_interface_id, l_app_valid_status);
825: ELSE
826:
827: -- Display the warning message in the log file
828: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
829: fnd_message.set_token('INT_TYPE', 'SPECIAL NEEDS');
830: fnd_file.put_line(fnd_file.log, fnd_message.get);
831:
832: END IF;

Line 829: fnd_message.set_token('INT_TYPE', 'SPECIAL NEEDS');

825: ELSE
826:
827: -- Display the warning message in the log file
828: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
829: fnd_message.set_token('INT_TYPE', 'SPECIAL NEEDS');
830: fnd_file.put_line(fnd_file.log, fnd_message.get);
831:
832: END IF;
833:

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

826:
827: -- Display the warning message in the log file
828: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
829: fnd_message.set_token('INT_TYPE', 'SPECIAL NEEDS');
830: fnd_file.put_line(fnd_file.log, fnd_message.get);
831:
832: END IF;
833:
834: END IF;

Line 851: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');

847: l_ad_interface_id,
848: l_app_valid_status);
849: ELSE
850: -- Display the warning message in the log file
851: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
852: fnd_message.set_token('INT_TYPE', 'ACADEMIC HISTORY');
853: fnd_file.put_line(fnd_file.log, fnd_message.get);
854:
855: END IF;

Line 852: fnd_message.set_token('INT_TYPE', 'ACADEMIC HISTORY');

848: l_app_valid_status);
849: ELSE
850: -- Display the warning message in the log file
851: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
852: fnd_message.set_token('INT_TYPE', 'ACADEMIC HISTORY');
853: fnd_file.put_line(fnd_file.log, fnd_message.get);
854:
855: END IF;
856:

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

849: ELSE
850: -- Display the warning message in the log file
851: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
852: fnd_message.set_token('INT_TYPE', 'ACADEMIC HISTORY');
853: fnd_file.put_line(fnd_file.log, fnd_message.get);
854:
855: END IF;
856:
857:

Line 999: fnd_message.set_name('IGS','IGS_UC_EXP_APPLCNT_ADDR_DET');

995: /****** Poulating the Admission Interface Tables to export Applicant Address Details to OSS *****/
996:
997: -- Log the message 'Exporting Applicant Address details to OSS' with Time Stamp
998: fnd_file.put_line( fnd_file.LOG ,' ');
999: fnd_message.set_name('IGS','IGS_UC_EXP_APPLCNT_ADDR_DET');
1000: fnd_file.put_line(fnd_file.log, fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');
1001: fnd_file.put_line( fnd_file.LOG ,' ');
1002:
1003: --jchakrab added for 3691210

Line 1000: fnd_file.put_line(fnd_file.log, fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');

996:
997: -- Log the message 'Exporting Applicant Address details to OSS' with Time Stamp
998: fnd_file.put_line( fnd_file.LOG ,' ');
999: fnd_message.set_name('IGS','IGS_UC_EXP_APPLCNT_ADDR_DET');
1000: fnd_file.put_line(fnd_file.log, fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');
1001: fnd_file.put_line( fnd_file.LOG ,' ');
1002:
1003: --jchakrab added for 3691210
1004: IF p_app_no IS NULL THEN

Line 1036: fnd_message.set_name('IGS','IGS_UC_APP_PER_ID_NOT_EXITS');

1032: -- If OSS Person ID is null then log the message and stop processing the current applicant
1033: IF cur_uc_app_dtls_rec.oss_person_id IS NULL THEN
1034:
1035: -- Log the message 'OSS Person ID is not populated for the Application Number'
1036: fnd_message.set_name('IGS','IGS_UC_APP_PER_ID_NOT_EXITS');
1037: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);
1038: fnd_file.put_line(fnd_file.log, fnd_message.get);
1039:
1040: ELSE

Line 1037: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);

1033: IF cur_uc_app_dtls_rec.oss_person_id IS NULL THEN
1034:
1035: -- Log the message 'OSS Person ID is not populated for the Application Number'
1036: fnd_message.set_name('IGS','IGS_UC_APP_PER_ID_NOT_EXITS');
1037: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);
1038: fnd_file.put_line(fnd_file.log, fnd_message.get);
1039:
1040: ELSE
1041:

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

1034:
1035: -- Log the message 'OSS Person ID is not populated for the Application Number'
1036: fnd_message.set_name('IGS','IGS_UC_APP_PER_ID_NOT_EXITS');
1037: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);
1038: fnd_file.put_line(fnd_file.log, fnd_message.get);
1039:
1040: ELSE
1041:
1042: -- get the Applicant Person Details in OSS

Line 1048: fnd_message.set_name('IGS','IGS_UC_EXP_APP_DET_PROC');

1044: FETCH cur_uc_person_dtls INTO cur_uc_person_dtls_rec;
1045: CLOSE cur_uc_person_dtls;
1046:
1047: -- Log the message 'Processing the Applicant with Person Number: XXX and Applicantion Number: XXX'
1048: fnd_message.set_name('IGS','IGS_UC_EXP_APP_DET_PROC');
1049: fnd_message.set_token('PER_NO',cur_uc_person_dtls_rec.person_number);
1050: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);
1051: fnd_file.put_line(fnd_file.log, fnd_message.get);
1052:

Line 1049: fnd_message.set_token('PER_NO',cur_uc_person_dtls_rec.person_number);

1045: CLOSE cur_uc_person_dtls;
1046:
1047: -- Log the message 'Processing the Applicant with Person Number: XXX and Applicantion Number: XXX'
1048: fnd_message.set_name('IGS','IGS_UC_EXP_APP_DET_PROC');
1049: fnd_message.set_token('PER_NO',cur_uc_person_dtls_rec.person_number);
1050: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);
1051: fnd_file.put_line(fnd_file.log, fnd_message.get);
1052:
1053: -- If the Batch ID is already generated use the same,

Line 1050: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);

1046:
1047: -- Log the message 'Processing the Applicant with Person Number: XXX and Applicantion Number: XXX'
1048: fnd_message.set_name('IGS','IGS_UC_EXP_APP_DET_PROC');
1049: fnd_message.set_token('PER_NO',cur_uc_person_dtls_rec.person_number);
1050: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);
1051: fnd_file.put_line(fnd_file.log, fnd_message.get);
1052:
1053: -- If the Batch ID is already generated use the same,
1054: -- otherwise create the new Batch ID ( i.e. for First Time)

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

1047: -- Log the message 'Processing the Applicant with Person Number: XXX and Applicantion Number: XXX'
1048: fnd_message.set_name('IGS','IGS_UC_EXP_APP_DET_PROC');
1049: fnd_message.set_token('PER_NO',cur_uc_person_dtls_rec.person_number);
1050: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);
1051: fnd_file.put_line(fnd_file.log, fnd_message.get);
1052:
1053: -- If the Batch ID is already generated use the same,
1054: -- otherwise create the new Batch ID ( i.e. for First Time)
1055: IF l_ad_batch_id IS NULL THEN

Line 1074: fnd_message.get_string('IGS','IGS_UC_IMP_FROM_UCAS_BATCH_ID'),

1070: program_update_date,
1071: program_id)
1072: VALUES (
1073: IGS_AD_INTERFACE_BATCH_ID_S.NEXTVAL,
1074: fnd_message.get_string('IGS','IGS_UC_IMP_FROM_UCAS_BATCH_ID'),
1075: fnd_global.user_id,
1076: SYSDATE,
1077: fnd_global.user_id,
1078: SYSDATE,

Line 1113: fnd_message.set_name('IGS','IGS_UC_INV_COUNTRY_MAP');

1109: CLOSE cur_hesa_map;
1110:
1111: -- Log a warning if country code exists but OSS mapping doesn't
1112: IF l_oss_country_code IS NULL AND cur_uc_app_dtls_rec.country_birth IS NOT NULL THEN
1113: fnd_message.set_name('IGS','IGS_UC_INV_COUNTRY_MAP');
1114: fnd_file.put_line(fnd_file.log, fnd_message.get);
1115: END IF;
1116:
1117: INSERT INTO igs_ad_interface_all (

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

1110:
1111: -- Log a warning if country code exists but OSS mapping doesn't
1112: IF l_oss_country_code IS NULL AND cur_uc_app_dtls_rec.country_birth IS NOT NULL THEN
1113: fnd_message.set_name('IGS','IGS_UC_INV_COUNTRY_MAP');
1114: fnd_file.put_line(fnd_file.log, fnd_message.get);
1115: END IF;
1116:
1117: INSERT INTO igs_ad_interface_all (
1118: interface_id,

Line 1180: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');

1176: l_ad_interface_id, l_app_valid_status );
1177: ELSE
1178:
1179: -- Display the warning message in the log file
1180: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
1181: fnd_message.set_token('INT_TYPE', 'CONTACTS');
1182: fnd_file.put_line(fnd_file.log, fnd_message.get);
1183:
1184: END IF;

Line 1181: fnd_message.set_token('INT_TYPE', 'CONTACTS');

1177: ELSE
1178:
1179: -- Display the warning message in the log file
1180: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
1181: fnd_message.set_token('INT_TYPE', 'CONTACTS');
1182: fnd_file.put_line(fnd_file.log, fnd_message.get);
1183:
1184: END IF;
1185:

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

1178:
1179: -- Display the warning message in the log file
1180: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
1181: fnd_message.set_token('INT_TYPE', 'CONTACTS');
1182: fnd_file.put_line(fnd_file.log, fnd_message.get);
1183:
1184: END IF;
1185:
1186: END IF;

Line 1208: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');

1204:
1205: ELSE
1206:
1207: -- Display the warning message in the log file
1208: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
1209: fnd_message.set_token('INT_TYPE', 'ADDRESS');
1210: fnd_file.put_line(fnd_file.log, fnd_message.get);
1211:
1212: END IF;

Line 1209: fnd_message.set_token('INT_TYPE', 'ADDRESS');

1205: ELSE
1206:
1207: -- Display the warning message in the log file
1208: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
1209: fnd_message.set_token('INT_TYPE', 'ADDRESS');
1210: fnd_file.put_line(fnd_file.log, fnd_message.get);
1211:
1212: END IF;
1213:

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

1206:
1207: -- Display the warning message in the log file
1208: fnd_message.set_name('IGS','IGS_UC_ADM_INT_NOT_IMP');
1209: fnd_message.set_token('INT_TYPE', 'ADDRESS');
1210: fnd_file.put_line(fnd_file.log, fnd_message.get);
1211:
1212: END IF;
1213:
1214: END IF;

Line 1274: fnd_message.set_name('IGS','IGS_UC_EXP_UPD_APP_INF');

1270: /***** Displaying the Manual Updations required to Applicant Names Information *******/
1271:
1272: -- Log the message 'Following changes in Applicant information need to be updated manually in Student System'
1273: fnd_file.put_line( fnd_file.LOG ,' ');
1274: fnd_message.set_name('IGS','IGS_UC_EXP_UPD_APP_INF');
1275: fnd_file.put_line(fnd_file.log, fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');
1276: fnd_file.put_line( fnd_file.LOG ,' ');
1277:
1278: --jchakrab added for 3691220

Line 1275: fnd_file.put_line(fnd_file.log, fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');

1271:
1272: -- Log the message 'Following changes in Applicant information need to be updated manually in Student System'
1273: fnd_file.put_line( fnd_file.LOG ,' ');
1274: fnd_message.set_name('IGS','IGS_UC_EXP_UPD_APP_INF');
1275: fnd_file.put_line(fnd_file.log, fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');
1276: fnd_file.put_line( fnd_file.LOG ,' ');
1277:
1278: --jchakrab added for 3691220
1279: IF p_app_no IS NULL THEN

Line 1312: fnd_message.set_name('IGS','IGS_UC_APP_PER_ID_NOT_EXITS');

1308: -- If OSS Person ID is null then log the message and stop processing the current applicant
1309: IF cur_uc_app_dtls_rec.oss_person_id IS NULL THEN
1310:
1311: -- Log the message 'OSS Person ID is not populated for the Application Number'
1312: fnd_message.set_name('IGS','IGS_UC_APP_PER_ID_NOT_EXITS');
1313: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);
1314: fnd_file.put_line(fnd_file.log, fnd_message.get);
1315:
1316: ELSE

Line 1313: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);

1309: IF cur_uc_app_dtls_rec.oss_person_id IS NULL THEN
1310:
1311: -- Log the message 'OSS Person ID is not populated for the Application Number'
1312: fnd_message.set_name('IGS','IGS_UC_APP_PER_ID_NOT_EXITS');
1313: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);
1314: fnd_file.put_line(fnd_file.log, fnd_message.get);
1315:
1316: ELSE
1317:

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

1310:
1311: -- Log the message 'OSS Person ID is not populated for the Application Number'
1312: fnd_message.set_name('IGS','IGS_UC_APP_PER_ID_NOT_EXITS');
1313: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);
1314: fnd_file.put_line(fnd_file.log, fnd_message.get);
1315:
1316: ELSE
1317:
1318: -- Get the Applicant Person Details in OSS

Line 1324: fnd_message.set_name('IGS','IGS_UC_EXP_APP_DET_PROC');

1320: FETCH cur_uc_person_dtls INTO cur_uc_person_dtls_rec;
1321: CLOSE cur_uc_person_dtls;
1322:
1323: -- Log the message 'Processing the Applicant with Person Number: XXX and Applicantion Number: XXX'
1324: fnd_message.set_name('IGS','IGS_UC_EXP_APP_DET_PROC');
1325: fnd_message.set_token('PER_NO',cur_uc_person_dtls_rec.person_number);
1326: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);
1327: fnd_file.put_line(fnd_file.log, fnd_message.get);
1328:

Line 1325: fnd_message.set_token('PER_NO',cur_uc_person_dtls_rec.person_number);

1321: CLOSE cur_uc_person_dtls;
1322:
1323: -- Log the message 'Processing the Applicant with Person Number: XXX and Applicantion Number: XXX'
1324: fnd_message.set_name('IGS','IGS_UC_EXP_APP_DET_PROC');
1325: fnd_message.set_token('PER_NO',cur_uc_person_dtls_rec.person_number);
1326: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);
1327: fnd_file.put_line(fnd_file.log, fnd_message.get);
1328:
1329: -- get the OSS mapping value for Sex

Line 1326: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);

1322:
1323: -- Log the message 'Processing the Applicant with Person Number: XXX and Applicantion Number: XXX'
1324: fnd_message.set_name('IGS','IGS_UC_EXP_APP_DET_PROC');
1325: fnd_message.set_token('PER_NO',cur_uc_person_dtls_rec.person_number);
1326: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);
1327: fnd_file.put_line(fnd_file.log, fnd_message.get);
1328:
1329: -- get the OSS mapping value for Sex
1330: -- If sex is null or mapping not found, log the message and continue with the next applicant

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

1323: -- Log the message 'Processing the Applicant with Person Number: XXX and Applicantion Number: XXX'
1324: fnd_message.set_name('IGS','IGS_UC_EXP_APP_DET_PROC');
1325: fnd_message.set_token('PER_NO',cur_uc_person_dtls_rec.person_number);
1326: fnd_message.set_token('APP_NO',cur_uc_app_dtls_rec.app_no);
1327: fnd_file.put_line(fnd_file.log, fnd_message.get);
1328:
1329: -- get the OSS mapping value for Sex
1330: -- If sex is null or mapping not found, log the message and continue with the next applicant
1331: l_oss_val := NULL;

Line 1337: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');

1333: FETCH cur_hesa_map INTO l_oss_val;
1334:
1335: IF cur_hesa_map%NOTFOUND AND cur_app_name_dtls_rec.sex IS NOT NULL THEN
1336:
1337: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
1338: fnd_message.set_token('CODE', cur_app_name_dtls_rec.sex);
1339: fnd_message.set_token('TYPE','SEX');
1340: fnd_file.put_line(fnd_file.log, fnd_message.get);
1341:

Line 1338: fnd_message.set_token('CODE', cur_app_name_dtls_rec.sex);

1334:
1335: IF cur_hesa_map%NOTFOUND AND cur_app_name_dtls_rec.sex IS NOT NULL THEN
1336:
1337: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
1338: fnd_message.set_token('CODE', cur_app_name_dtls_rec.sex);
1339: fnd_message.set_token('TYPE','SEX');
1340: fnd_file.put_line(fnd_file.log, fnd_message.get);
1341:
1342: ELSE

Line 1339: fnd_message.set_token('TYPE','SEX');

1335: IF cur_hesa_map%NOTFOUND AND cur_app_name_dtls_rec.sex IS NOT NULL THEN
1336:
1337: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
1338: fnd_message.set_token('CODE', cur_app_name_dtls_rec.sex);
1339: fnd_message.set_token('TYPE','SEX');
1340: fnd_file.put_line(fnd_file.log, fnd_message.get);
1341:
1342: ELSE
1343: -- If OSS person details are not equal to UCAS person details then report the changes required

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

1336:
1337: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
1338: fnd_message.set_token('CODE', cur_app_name_dtls_rec.sex);
1339: fnd_message.set_token('TYPE','SEX');
1340: fnd_file.put_line(fnd_file.log, fnd_message.get);
1341:
1342: ELSE
1343: -- If OSS person details are not equal to UCAS person details then report the changes required
1344: IF( NVL(cur_app_name_dtls_rec.title,'*') <> NVL(cur_uc_person_dtls_rec.pre_name_adjunct,'*') OR

Line 1351: fnd_message.set_name('IGS','IGS_UC_EXP_UPD_APP_DET');

1347: NVL(TRUNC(cur_app_name_dtls_rec.birth_date),SYSDATE) <> NVL(TRUNC(cur_uc_person_dtls_rec.birth_date),SYSDATE) OR
1348: NVL(l_oss_val,'*') <> NVL(cur_uc_person_dtls_rec.sex,'*') ) THEN
1349:
1350: -- Log the message displaying the APP_NAME Interface Table Details
1351: fnd_message.set_name('IGS','IGS_UC_EXP_UPD_APP_DET');
1352: fnd_message.set_token('TITLE',cur_app_name_dtls_rec.title);
1353: fnd_message.set_token('FORE_NAMES',cur_app_name_dtls_rec.fore_names);
1354: fnd_message.set_token('SURNAME',cur_app_name_dtls_rec.surname);
1355: fnd_message.set_token('BIRTH_DATE',cur_app_name_dtls_rec.birth_date);

Line 1352: fnd_message.set_token('TITLE',cur_app_name_dtls_rec.title);

1348: NVL(l_oss_val,'*') <> NVL(cur_uc_person_dtls_rec.sex,'*') ) THEN
1349:
1350: -- Log the message displaying the APP_NAME Interface Table Details
1351: fnd_message.set_name('IGS','IGS_UC_EXP_UPD_APP_DET');
1352: fnd_message.set_token('TITLE',cur_app_name_dtls_rec.title);
1353: fnd_message.set_token('FORE_NAMES',cur_app_name_dtls_rec.fore_names);
1354: fnd_message.set_token('SURNAME',cur_app_name_dtls_rec.surname);
1355: fnd_message.set_token('BIRTH_DATE',cur_app_name_dtls_rec.birth_date);
1356: fnd_message.set_token('SEX',l_oss_val);

Line 1353: fnd_message.set_token('FORE_NAMES',cur_app_name_dtls_rec.fore_names);

1349:
1350: -- Log the message displaying the APP_NAME Interface Table Details
1351: fnd_message.set_name('IGS','IGS_UC_EXP_UPD_APP_DET');
1352: fnd_message.set_token('TITLE',cur_app_name_dtls_rec.title);
1353: fnd_message.set_token('FORE_NAMES',cur_app_name_dtls_rec.fore_names);
1354: fnd_message.set_token('SURNAME',cur_app_name_dtls_rec.surname);
1355: fnd_message.set_token('BIRTH_DATE',cur_app_name_dtls_rec.birth_date);
1356: fnd_message.set_token('SEX',l_oss_val);
1357: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1354: fnd_message.set_token('SURNAME',cur_app_name_dtls_rec.surname);

1350: -- Log the message displaying the APP_NAME Interface Table Details
1351: fnd_message.set_name('IGS','IGS_UC_EXP_UPD_APP_DET');
1352: fnd_message.set_token('TITLE',cur_app_name_dtls_rec.title);
1353: fnd_message.set_token('FORE_NAMES',cur_app_name_dtls_rec.fore_names);
1354: fnd_message.set_token('SURNAME',cur_app_name_dtls_rec.surname);
1355: fnd_message.set_token('BIRTH_DATE',cur_app_name_dtls_rec.birth_date);
1356: fnd_message.set_token('SEX',l_oss_val);
1357: fnd_file.put_line(fnd_file.log, fnd_message.get);
1358:

Line 1355: fnd_message.set_token('BIRTH_DATE',cur_app_name_dtls_rec.birth_date);

1351: fnd_message.set_name('IGS','IGS_UC_EXP_UPD_APP_DET');
1352: fnd_message.set_token('TITLE',cur_app_name_dtls_rec.title);
1353: fnd_message.set_token('FORE_NAMES',cur_app_name_dtls_rec.fore_names);
1354: fnd_message.set_token('SURNAME',cur_app_name_dtls_rec.surname);
1355: fnd_message.set_token('BIRTH_DATE',cur_app_name_dtls_rec.birth_date);
1356: fnd_message.set_token('SEX',l_oss_val);
1357: fnd_file.put_line(fnd_file.log, fnd_message.get);
1358:
1359: END IF;

Line 1356: fnd_message.set_token('SEX',l_oss_val);

1352: fnd_message.set_token('TITLE',cur_app_name_dtls_rec.title);
1353: fnd_message.set_token('FORE_NAMES',cur_app_name_dtls_rec.fore_names);
1354: fnd_message.set_token('SURNAME',cur_app_name_dtls_rec.surname);
1355: fnd_message.set_token('BIRTH_DATE',cur_app_name_dtls_rec.birth_date);
1356: fnd_message.set_token('SEX',l_oss_val);
1357: fnd_file.put_line(fnd_file.log, fnd_message.get);
1358:
1359: END IF;
1360:

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

1353: fnd_message.set_token('FORE_NAMES',cur_app_name_dtls_rec.fore_names);
1354: fnd_message.set_token('SURNAME',cur_app_name_dtls_rec.surname);
1355: fnd_message.set_token('BIRTH_DATE',cur_app_name_dtls_rec.birth_date);
1356: fnd_message.set_token('SEX',l_oss_val);
1357: fnd_file.put_line(fnd_file.log, fnd_message.get);
1358:
1359: END IF;
1360:
1361: /* Update the IGS_UC_APP_NAMES Table with sent_to_oss_flag to 'Y' */

Line 1804: fnd_message.set_name('IGS','IGS_UC_EXP_APP_REP_SUBM');

1800: IF l_rep_request_id > 0 THEN
1801:
1802: -- If error report successfully submitted then log message
1803: fnd_file.put_line( fnd_file.LOG ,' ');
1804: fnd_message.set_name('IGS','IGS_UC_EXP_APP_REP_SUBM');
1805: fnd_message.set_token('REQ_ID',TO_CHAR(l_rep_request_id));
1806: fnd_file.put_line( fnd_file.LOG ,fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');
1807:
1808: ELSE

Line 1805: fnd_message.set_token('REQ_ID',TO_CHAR(l_rep_request_id));

1801:
1802: -- If error report successfully submitted then log message
1803: fnd_file.put_line( fnd_file.LOG ,' ');
1804: fnd_message.set_name('IGS','IGS_UC_EXP_APP_REP_SUBM');
1805: fnd_message.set_token('REQ_ID',TO_CHAR(l_rep_request_id));
1806: fnd_file.put_line( fnd_file.LOG ,fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');
1807:
1808: ELSE
1809:

Line 1806: fnd_file.put_line( fnd_file.LOG ,fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');

1802: -- If error report successfully submitted then log message
1803: fnd_file.put_line( fnd_file.LOG ,' ');
1804: fnd_message.set_name('IGS','IGS_UC_EXP_APP_REP_SUBM');
1805: fnd_message.set_token('REQ_ID',TO_CHAR(l_rep_request_id));
1806: fnd_file.put_line( fnd_file.LOG ,fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');
1807:
1808: ELSE
1809:
1810: -- If error report failed to be launched then log message

Line 1812: fnd_message.set_name('IGS','IGS_UC_EXP_APP_SUBM_ERR');

1808: ELSE
1809:
1810: -- If error report failed to be launched then log message
1811: fnd_file.put_line( fnd_file.LOG ,' ');
1812: fnd_message.set_name('IGS','IGS_UC_EXP_APP_SUBM_ERR');
1813: fnd_file.put_line( fnd_file.LOG ,fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');
1814:
1815: END IF;
1816:

Line 1813: fnd_file.put_line( fnd_file.LOG ,fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');

1809:
1810: -- If error report failed to be launched then log message
1811: fnd_file.put_line( fnd_file.LOG ,' ');
1812: fnd_message.set_name('IGS','IGS_UC_EXP_APP_SUBM_ERR');
1813: fnd_file.put_line( fnd_file.LOG ,fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');
1814:
1815: END IF;
1816:
1817: END IF;

Line 1826: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

1822:
1823: WHEN OTHERS THEN
1824:
1825: ROLLBACK;
1826: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1827: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.EXPORT_PROCESS'||' - '||SQLERRM);
1828: errbuf := fnd_message.get;
1829: retcode := 2 ;
1830: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

Line 1827: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.EXPORT_PROCESS'||' - '||SQLERRM);

1823: WHEN OTHERS THEN
1824:
1825: ROLLBACK;
1826: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1827: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.EXPORT_PROCESS'||' - '||SQLERRM);
1828: errbuf := fnd_message.get;
1829: retcode := 2 ;
1830: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1831:

Line 1828: errbuf := fnd_message.get;

1824:
1825: ROLLBACK;
1826: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1827: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.EXPORT_PROCESS'||' - '||SQLERRM);
1828: errbuf := fnd_message.get;
1829: retcode := 2 ;
1830: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1831:
1832: END export_process;

Line 1892: fnd_message.set_name('IGS','IGS_UC_NI_NUM_NOT_MATCH');

1888: -- If UCAS NI Number is not equal to the existing OSS Alternate Person ID
1889: -- Then Log the message
1890: IF p_ni_number <> cur_alt_pers_dtls_rec.api_person_id THEN
1891:
1892: fnd_message.set_name('IGS','IGS_UC_NI_NUM_NOT_MATCH');
1893: fnd_file.put_line(fnd_file.log, fnd_message.get);
1894:
1895: ELSIF cur_alt_pers_dtls_rec.end_dt IS NOT NULL THEN
1896:

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

1889: -- Then Log the message
1890: IF p_ni_number <> cur_alt_pers_dtls_rec.api_person_id THEN
1891:
1892: fnd_message.set_name('IGS','IGS_UC_NI_NUM_NOT_MATCH');
1893: fnd_file.put_line(fnd_file.log, fnd_message.get);
1894:
1895: ELSIF cur_alt_pers_dtls_rec.end_dt IS NOT NULL THEN
1896:
1897: fnd_message.set_name('IGS','IGS_UC_NI_NUM_END_DATED');

Line 1897: fnd_message.set_name('IGS','IGS_UC_NI_NUM_END_DATED');

1893: fnd_file.put_line(fnd_file.log, fnd_message.get);
1894:
1895: ELSIF cur_alt_pers_dtls_rec.end_dt IS NOT NULL THEN
1896:
1897: fnd_message.set_name('IGS','IGS_UC_NI_NUM_END_DATED');
1898: fnd_file.put_line(fnd_file.log, fnd_message.get);
1899:
1900: END IF;
1901:

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

1894:
1895: ELSIF cur_alt_pers_dtls_rec.end_dt IS NOT NULL THEN
1896:
1897: fnd_message.set_name('IGS','IGS_UC_NI_NUM_END_DATED');
1898: fnd_file.put_line(fnd_file.log, fnd_message.get);
1899:
1900: END IF;
1901:
1902: ELSE

Line 1916: fnd_message.set_name('IGS','IGS_UC_NI_NUM_END_DATED');

1912: -- If NI Number Alternate Person ID Type is defined as Unique and NI Number is used by another person
1913: -- display log message 'Warning - UCAS NI Number is in use by another person- please review
1914: IF cur_pers_type_unique%FOUND AND cur_pers_id_exist%FOUND THEN
1915:
1916: fnd_message.set_name('IGS','IGS_UC_NI_NUM_END_DATED');
1917: fnd_file.put_line(fnd_file.log, fnd_message.get);
1918:
1919: ELSE
1920:

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

1913: -- display log message 'Warning - UCAS NI Number is in use by another person- please review
1914: IF cur_pers_type_unique%FOUND AND cur_pers_id_exist%FOUND THEN
1915:
1916: fnd_message.set_name('IGS','IGS_UC_NI_NUM_END_DATED');
1917: fnd_file.put_line(fnd_file.log, fnd_message.get);
1918:
1919: ELSE
1920:
1921: -- Populate the IGS_AD_API_INT table

Line 1968: fnd_message.set_name('IGS','IGS_UC_SCN_NOT_MATCH');

1964: -- If UCAS SCN is not equal to the existing OSS Alternate Person ID
1965: -- Then Log the message in the Log file
1966: IF p_scn <> cur_alt_pers_dtls_rec.api_person_id THEN
1967:
1968: fnd_message.set_name('IGS','IGS_UC_SCN_NOT_MATCH');
1969: fnd_file.put_line(fnd_file.log, fnd_message.get);
1970:
1971: ELSIF cur_alt_pers_dtls_rec.end_dt IS NOT NULL THEN
1972:

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

1965: -- Then Log the message in the Log file
1966: IF p_scn <> cur_alt_pers_dtls_rec.api_person_id THEN
1967:
1968: fnd_message.set_name('IGS','IGS_UC_SCN_NOT_MATCH');
1969: fnd_file.put_line(fnd_file.log, fnd_message.get);
1970:
1971: ELSIF cur_alt_pers_dtls_rec.end_dt IS NOT NULL THEN
1972:
1973: fnd_message.set_name('IGS','IGS_UC_SCN_END_DATED');

Line 1973: fnd_message.set_name('IGS','IGS_UC_SCN_END_DATED');

1969: fnd_file.put_line(fnd_file.log, fnd_message.get);
1970:
1971: ELSIF cur_alt_pers_dtls_rec.end_dt IS NOT NULL THEN
1972:
1973: fnd_message.set_name('IGS','IGS_UC_SCN_END_DATED');
1974: fnd_file.put_line(fnd_file.log, fnd_message.get);
1975:
1976: END IF;
1977:

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

1970:
1971: ELSIF cur_alt_pers_dtls_rec.end_dt IS NOT NULL THEN
1972:
1973: fnd_message.set_name('IGS','IGS_UC_SCN_END_DATED');
1974: fnd_file.put_line(fnd_file.log, fnd_message.get);
1975:
1976: END IF;
1977:
1978: ELSE

Line 1992: fnd_message.set_name('IGS','IGS_UC_SCN_IN_USE');

1988: -- If UCASREGNO Alternate Person ID Type is defined as Unique and SCN is used by another person
1989: -- display log message 'Warning - SCN is in use by another person- please review
1990: IF cur_pers_type_unique%FOUND AND cur_pers_id_exist%FOUND THEN
1991:
1992: fnd_message.set_name('IGS','IGS_UC_SCN_IN_USE');
1993: fnd_file.put_line(fnd_file.log, fnd_message.get);
1994:
1995: ELSE
1996:

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

1989: -- display log message 'Warning - SCN is in use by another person- please review
1990: IF cur_pers_type_unique%FOUND AND cur_pers_id_exist%FOUND THEN
1991:
1992: fnd_message.set_name('IGS','IGS_UC_SCN_IN_USE');
1993: fnd_file.put_line(fnd_file.log, fnd_message.get);
1994:
1995: ELSE
1996:
1997: INSERT INTO igs_ad_api_int (

Line 2032: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2028:
2029: EXCEPTION
2030: WHEN OTHERS THEN
2031: p_app_valid_status := FALSE;
2032: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2033: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_API_INT'||' - '||SQLERRM);
2034: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2035:
2036: END pop_api_int;

Line 2033: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_API_INT'||' - '||SQLERRM);

2029: EXCEPTION
2030: WHEN OTHERS THEN
2031: p_app_valid_status := FALSE;
2032: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2033: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_API_INT'||' - '||SQLERRM);
2034: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2035:
2036: END pop_api_int;
2037:

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

2030: WHEN OTHERS THEN
2031: p_app_valid_status := FALSE;
2032: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2033: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_API_INT'||' - '||SQLERRM);
2034: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2035:
2036: END pop_api_int;
2037:
2038:

Line 2102: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');

2098: CLOSE cur_hesa_map ;
2099:
2100: IF l_residency_status_cd IS NULL THEN
2101: p_app_valid_status := FALSE;
2102: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2103: fnd_message.set_token('CODE', p_rescat);
2104: fnd_message.set_token('TYPE', 'RESIDENTIAL CATEGORY');
2105: fnd_file.put_line(fnd_file.log, fnd_message.get);
2106: END IF ;

Line 2103: fnd_message.set_token('CODE', p_rescat);

2099:
2100: IF l_residency_status_cd IS NULL THEN
2101: p_app_valid_status := FALSE;
2102: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2103: fnd_message.set_token('CODE', p_rescat);
2104: fnd_message.set_token('TYPE', 'RESIDENTIAL CATEGORY');
2105: fnd_file.put_line(fnd_file.log, fnd_message.get);
2106: END IF ;
2107:

Line 2104: fnd_message.set_token('TYPE', 'RESIDENTIAL CATEGORY');

2100: IF l_residency_status_cd IS NULL THEN
2101: p_app_valid_status := FALSE;
2102: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2103: fnd_message.set_token('CODE', p_rescat);
2104: fnd_message.set_token('TYPE', 'RESIDENTIAL CATEGORY');
2105: fnd_file.put_line(fnd_file.log, fnd_message.get);
2106: END IF ;
2107:
2108:

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

2101: p_app_valid_status := FALSE;
2102: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2103: fnd_message.set_token('CODE', p_rescat);
2104: fnd_message.set_token('TYPE', 'RESIDENTIAL CATEGORY');
2105: fnd_file.put_line(fnd_file.log, fnd_message.get);
2106: END IF ;
2107:
2108:
2109: IF p_app_valid_status = TRUE THEN

Line 2154: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2150:
2151: EXCEPTION
2152: WHEN OTHERS THEN
2153: p_app_valid_status := FALSE;
2154: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2155: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_RES_DTLS_INT'||' - '||SQLERRM);
2156: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2157:
2158: END pop_res_dtls_int;

Line 2155: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_RES_DTLS_INT'||' - '||SQLERRM);

2151: EXCEPTION
2152: WHEN OTHERS THEN
2153: p_app_valid_status := FALSE;
2154: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2155: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_RES_DTLS_INT'||' - '||SQLERRM);
2156: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2157:
2158: END pop_res_dtls_int;
2159:

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

2152: WHEN OTHERS THEN
2153: p_app_valid_status := FALSE;
2154: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2155: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_RES_DTLS_INT'||' - '||SQLERRM);
2156: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2157:
2158: END pop_res_dtls_int;
2159:
2160: PROCEDURE pop_acad_hist_int( p_person_id IN NUMBER,

Line 2211: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_INST');

2207: OPEN cur_ucas_oss_map('UC_OSS_HE_INS_ASSOC', p_school);
2208: FETCH cur_ucas_oss_map INTO l_oss_inst;
2209: IF (cur_ucas_oss_map%NOTFOUND) THEN
2210:
2211: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_INST');
2212: FND_MESSAGE.Set_Token('PERSON_ID',p_person_number);
2213: FND_MESSAGE.Set_Token('CODE',p_school );
2214: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get );
2215: l_mapping_failed := 'Y';

Line 2212: FND_MESSAGE.Set_Token('PERSON_ID',p_person_number);

2208: FETCH cur_ucas_oss_map INTO l_oss_inst;
2209: IF (cur_ucas_oss_map%NOTFOUND) THEN
2210:
2211: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_INST');
2212: FND_MESSAGE.Set_Token('PERSON_ID',p_person_number);
2213: FND_MESSAGE.Set_Token('CODE',p_school );
2214: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get );
2215: l_mapping_failed := 'Y';
2216:

Line 2213: FND_MESSAGE.Set_Token('CODE',p_school );

2209: IF (cur_ucas_oss_map%NOTFOUND) THEN
2210:
2211: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_INST');
2212: FND_MESSAGE.Set_Token('PERSON_ID',p_person_number);
2213: FND_MESSAGE.Set_Token('CODE',p_school );
2214: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get );
2215: l_mapping_failed := 'Y';
2216:
2217: END IF;

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

2210:
2211: FND_MESSAGE.Set_Name('IGS','IGS_UC_NO_INST');
2212: FND_MESSAGE.Set_Token('PERSON_ID',p_person_number);
2213: FND_MESSAGE.Set_Token('CODE',p_school );
2214: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.get );
2215: l_mapping_failed := 'Y';
2216:
2217: END IF;
2218: CLOSE cur_ucas_oss_map;

Line 2273: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2269:
2270: EXCEPTION
2271: WHEN OTHERS THEN
2272: p_app_valid_status := FALSE;
2273: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2274: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_ACAD_HIST_INT'||' - '||SQLERRM);
2275: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2276:
2277: END pop_acad_hist_int;

Line 2274: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_ACAD_HIST_INT'||' - '||SQLERRM);

2270: EXCEPTION
2271: WHEN OTHERS THEN
2272: p_app_valid_status := FALSE;
2273: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2274: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_ACAD_HIST_INT'||' - '||SQLERRM);
2275: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2276:
2277: END pop_acad_hist_int;
2278:

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

2271: WHEN OTHERS THEN
2272: p_app_valid_status := FALSE;
2273: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2274: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_ACAD_HIST_INT'||' - '||SQLERRM);
2275: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2276:
2277: END pop_acad_hist_int;
2278:
2279: PROCEDURE pop_citizen_int ( p_nationality IN NUMBER,

Line 2328: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');

2324:
2325: IF cur_hesa_map%NOTFOUND THEN
2326:
2327: p_app_valid_status := FALSE;
2328: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2329: fnd_message.set_token('CODE', p_nationality);
2330: fnd_message.set_token('TYPE', 'NATIONALITY');
2331: fnd_file.put_line(fnd_file.log, fnd_message.get);
2332:

Line 2329: fnd_message.set_token('CODE', p_nationality);

2325: IF cur_hesa_map%NOTFOUND THEN
2326:
2327: p_app_valid_status := FALSE;
2328: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2329: fnd_message.set_token('CODE', p_nationality);
2330: fnd_message.set_token('TYPE', 'NATIONALITY');
2331: fnd_file.put_line(fnd_file.log, fnd_message.get);
2332:
2333: ELSE

Line 2330: fnd_message.set_token('TYPE', 'NATIONALITY');

2326:
2327: p_app_valid_status := FALSE;
2328: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2329: fnd_message.set_token('CODE', p_nationality);
2330: fnd_message.set_token('TYPE', 'NATIONALITY');
2331: fnd_file.put_line(fnd_file.log, fnd_message.get);
2332:
2333: ELSE
2334:

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

2327: p_app_valid_status := FALSE;
2328: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2329: fnd_message.set_token('CODE', p_nationality);
2330: fnd_message.set_token('TYPE', 'NATIONALITY');
2331: fnd_file.put_line(fnd_file.log, fnd_message.get);
2332:
2333: ELSE
2334:
2335: -- Check if Nationality already exists as citizenship for the current applicant

Line 2382: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');

2378:
2379: IF cur_hesa_map%NOTFOUND THEN
2380:
2381: p_app_valid_status := FALSE;
2382: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2383: fnd_message.set_token('CODE', p_dual_nationality);
2384: fnd_message.set_token('TYPE', 'NATIONALITY');
2385: fnd_file.put_line(fnd_file.log, fnd_message.get);
2386:

Line 2383: fnd_message.set_token('CODE', p_dual_nationality);

2379: IF cur_hesa_map%NOTFOUND THEN
2380:
2381: p_app_valid_status := FALSE;
2382: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2383: fnd_message.set_token('CODE', p_dual_nationality);
2384: fnd_message.set_token('TYPE', 'NATIONALITY');
2385: fnd_file.put_line(fnd_file.log, fnd_message.get);
2386:
2387: ELSE

Line 2384: fnd_message.set_token('TYPE', 'NATIONALITY');

2380:
2381: p_app_valid_status := FALSE;
2382: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2383: fnd_message.set_token('CODE', p_dual_nationality);
2384: fnd_message.set_token('TYPE', 'NATIONALITY');
2385: fnd_file.put_line(fnd_file.log, fnd_message.get);
2386:
2387: ELSE
2388:

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

2381: p_app_valid_status := FALSE;
2382: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2383: fnd_message.set_token('CODE', p_dual_nationality);
2384: fnd_message.set_token('TYPE', 'NATIONALITY');
2385: fnd_file.put_line(fnd_file.log, fnd_message.get);
2386:
2387: ELSE
2388:
2389: -- Check if Dual Nationality already exists as citizenship for the current applicant

Line 2429: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2425:
2426: EXCEPTION
2427: WHEN OTHERS THEN
2428: p_app_valid_status := FALSE;
2429: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2430: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_CITIZEN_INT'||' - '||SQLERRM);
2431: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2432:
2433: END pop_citizen_int;

Line 2430: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_CITIZEN_INT'||' - '||SQLERRM);

2426: EXCEPTION
2427: WHEN OTHERS THEN
2428: p_app_valid_status := FALSE;
2429: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2430: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_CITIZEN_INT'||' - '||SQLERRM);
2431: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2432:
2433: END pop_citizen_int;
2434:

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

2427: WHEN OTHERS THEN
2428: p_app_valid_status := FALSE;
2429: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2430: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_CITIZEN_INT'||' - '||SQLERRM);
2431: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2432:
2433: END pop_citizen_int;
2434:
2435:

Line 2496: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');

2492:
2493: IF cur_hesa_map%NOTFOUND THEN
2494:
2495: p_app_valid_status := FALSE;
2496: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2497: fnd_message.set_token('CODE', p_special_needs);
2498: fnd_message.set_token('TYPE', 'DISABILITY TYPE');
2499: fnd_file.put_line(fnd_file.log, fnd_message.get);
2500:

Line 2497: fnd_message.set_token('CODE', p_special_needs);

2493: IF cur_hesa_map%NOTFOUND THEN
2494:
2495: p_app_valid_status := FALSE;
2496: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2497: fnd_message.set_token('CODE', p_special_needs);
2498: fnd_message.set_token('TYPE', 'DISABILITY TYPE');
2499: fnd_file.put_line(fnd_file.log, fnd_message.get);
2500:
2501: ELSE

Line 2498: fnd_message.set_token('TYPE', 'DISABILITY TYPE');

2494:
2495: p_app_valid_status := FALSE;
2496: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2497: fnd_message.set_token('CODE', p_special_needs);
2498: fnd_message.set_token('TYPE', 'DISABILITY TYPE');
2499: fnd_file.put_line(fnd_file.log, fnd_message.get);
2500:
2501: ELSE
2502:

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

2495: p_app_valid_status := FALSE;
2496: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
2497: fnd_message.set_token('CODE', p_special_needs);
2498: fnd_message.set_token('TYPE', 'DISABILITY TYPE');
2499: fnd_file.put_line(fnd_file.log, fnd_message.get);
2500:
2501: ELSE
2502:
2503: -- Check if Special Needs already exists as disability for the current applicant

Line 2511: fnd_message.set_name('IGS','IGS_UC_DISABLTY_END_DATED');

2507: IF cur_disablty_dtls%FOUND THEN
2508:
2509: IF cur_disablty_dtls_rec.end_date IS NOT NULL THEN
2510:
2511: fnd_message.set_name('IGS','IGS_UC_DISABLTY_END_DATED');
2512: fnd_file.put_line(fnd_file.log, fnd_message.get);
2513:
2514: END IF;
2515:

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

2508:
2509: IF cur_disablty_dtls_rec.end_date IS NOT NULL THEN
2510:
2511: fnd_message.set_name('IGS','IGS_UC_DISABLTY_END_DATED');
2512: fnd_file.put_line(fnd_file.log, fnd_message.get);
2513:
2514: END IF;
2515:
2516: ELSE -- If record not found, then populate the interface table

Line 2593: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2589:
2590: EXCEPTION
2591: WHEN OTHERS THEN
2592: p_app_valid_status := FALSE;
2593: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2594: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_DISABILITY_INT'||' - '||SQLERRM);
2595: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2596:
2597: END pop_disability_int;

Line 2594: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_DISABILITY_INT'||' - '||SQLERRM);

2590: EXCEPTION
2591: WHEN OTHERS THEN
2592: p_app_valid_status := FALSE;
2593: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2594: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_DISABILITY_INT'||' - '||SQLERRM);
2595: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2596:
2597: END pop_disability_int;
2598:

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

2591: WHEN OTHERS THEN
2592: p_app_valid_status := FALSE;
2593: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2594: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_DISABILITY_INT'||' - '||SQLERRM);
2595: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2596:
2597: END pop_disability_int;
2598:
2599:

Line 2770: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

2766:
2767: EXCEPTION
2768: WHEN OTHERS THEN
2769: p_app_valid_status := FALSE;
2770: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2771: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_CONTACT_INT'||' - '||SQLERRM);
2772: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2773:
2774: END pop_contact_int;

Line 2771: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_CONTACT_INT'||' - '||SQLERRM);

2767: EXCEPTION
2768: WHEN OTHERS THEN
2769: p_app_valid_status := FALSE;
2770: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2771: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_CONTACT_INT'||' - '||SQLERRM);
2772: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2773:
2774: END pop_contact_int;
2775:

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

2768: WHEN OTHERS THEN
2769: p_app_valid_status := FALSE;
2770: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2771: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_CONTACT_INT'||' - '||SQLERRM);
2772: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
2773:
2774: END pop_contact_int;
2775:
2776:

Line 2842: fnd_message.set_name('IGS','IGS_UC_INVAL_COUNTRY_CODE') ;

2838: IF l_country_code IS NULL THEN
2839: l_country_code := 'ZR' ;
2840:
2841: -- Display warning that the country for this student address should be checked
2842: fnd_message.set_name('IGS','IGS_UC_INVAL_COUNTRY_CODE') ;
2843: fnd_message.set_token('APPNO',p_app_no) ;
2844: fnd_message.set_token('ADR_TYPE',p_adr_type) ;
2845: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
2846: END IF ;

Line 2843: fnd_message.set_token('APPNO',p_app_no) ;

2839: l_country_code := 'ZR' ;
2840:
2841: -- Display warning that the country for this student address should be checked
2842: fnd_message.set_name('IGS','IGS_UC_INVAL_COUNTRY_CODE') ;
2843: fnd_message.set_token('APPNO',p_app_no) ;
2844: fnd_message.set_token('ADR_TYPE',p_adr_type) ;
2845: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
2846: END IF ;
2847:

Line 2844: fnd_message.set_token('ADR_TYPE',p_adr_type) ;

2840:
2841: -- Display warning that the country for this student address should be checked
2842: fnd_message.set_name('IGS','IGS_UC_INVAL_COUNTRY_CODE') ;
2843: fnd_message.set_token('APPNO',p_app_no) ;
2844: fnd_message.set_token('ADR_TYPE',p_adr_type) ;
2845: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
2846: END IF ;
2847:
2848: RETURN l_country_code;

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

2841: -- Display warning that the country for this student address should be checked
2842: fnd_message.set_name('IGS','IGS_UC_INVAL_COUNTRY_CODE') ;
2843: fnd_message.set_token('APPNO',p_app_no) ;
2844: fnd_message.set_token('ADR_TYPE',p_adr_type) ;
2845: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
2846: END IF ;
2847:
2848: RETURN l_country_code;
2849:

Line 3007: fnd_message.set_name('IGS', 'IGS_UC_NO_ADD_GIVEN');

3003: 'HOME') ;
3004:
3005: -- anwest Bug# 3622076 If address line 1 is NULL substitute dummy value
3006: IF p_app_address_dtls_rec.home_address1 IS NULL THEN
3007: fnd_message.set_name('IGS', 'IGS_UC_NO_ADD_GIVEN');
3008: l_home_address1 := fnd_message.get;
3009: ELSE
3010: l_home_address1 := p_app_address_dtls_rec.home_address1;
3011: END IF;

Line 3008: l_home_address1 := fnd_message.get;

3004:
3005: -- anwest Bug# 3622076 If address line 1 is NULL substitute dummy value
3006: IF p_app_address_dtls_rec.home_address1 IS NULL THEN
3007: fnd_message.set_name('IGS', 'IGS_UC_NO_ADD_GIVEN');
3008: l_home_address1 := fnd_message.get;
3009: ELSE
3010: l_home_address1 := p_app_address_dtls_rec.home_address1;
3011: END IF;
3012:

Line 3081: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

3077:
3078: EXCEPTION
3079: WHEN OTHERS THEN
3080: p_app_valid_status := FALSE;
3081: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3082: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_ADDRESS_INT'||' - '||SQLERRM);
3083: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
3084:
3085: END pop_address_int;

Line 3082: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_ADDRESS_INT'||' - '||SQLERRM);

3078: EXCEPTION
3079: WHEN OTHERS THEN
3080: p_app_valid_status := FALSE;
3081: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3082: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_ADDRESS_INT'||' - '||SQLERRM);
3083: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
3084:
3085: END pop_address_int;
3086:

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

3079: WHEN OTHERS THEN
3080: p_app_valid_status := FALSE;
3081: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3082: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.POP_ADDRESS_INT'||' - '||SQLERRM);
3083: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
3084:
3085: END pop_address_int;
3086:
3087: FUNCTION chk_src_cat ( p_source_type_id IN NUMBER,

Line 3192: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');

3188:
3189: p_status := TRUE;
3190: -- Display the Message in the Log File
3191: fnd_file.put_line( fnd_file.LOG ,' ');
3192: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');
3193: fnd_message.set_token('REQ_ID',TO_CHAR(p_ad_batch_id));
3194: fnd_file.put_line( fnd_file.LOG ,fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');
3195:
3196: -- Call admission application import process procedure because current process

Line 3193: fnd_message.set_token('REQ_ID',TO_CHAR(p_ad_batch_id));

3189: p_status := TRUE;
3190: -- Display the Message in the Log File
3191: fnd_file.put_line( fnd_file.LOG ,' ');
3192: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');
3193: fnd_message.set_token('REQ_ID',TO_CHAR(p_ad_batch_id));
3194: fnd_file.put_line( fnd_file.LOG ,fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');
3195:
3196: -- Call admission application import process procedure because current process
3197: -- has to wait until import process is finished

Line 3194: fnd_file.put_line( fnd_file.LOG ,fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');

3190: -- Display the Message in the Log File
3191: fnd_file.put_line( fnd_file.LOG ,' ');
3192: fnd_message.set_name('IGS','IGS_UC_ADM_IMP_PROC_LAUNCH');
3193: fnd_message.set_token('REQ_ID',TO_CHAR(p_ad_batch_id));
3194: fnd_file.put_line( fnd_file.LOG ,fnd_message.get||' ('||to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS')||')');
3195:
3196: -- Call admission application import process procedure because current process
3197: -- has to wait until import process is finished
3198: IGS_AD_IMP_001.IMP_ADM_DATA ( errbuf => l_errbuff,

Line 3219: fnd_message.set_name('IGS','IGS_UC_NOT_LAUNCH_IMP_PROC');

3215: p_status := FALSE;
3216: -- As the required parameters are not avilable to launch Admission Import Process,
3217: -- Log message is populated in log file.
3218: fnd_file.put_line( fnd_file.LOG ,' ');
3219: fnd_message.set_name('IGS','IGS_UC_NOT_LAUNCH_IMP_PROC');
3220: fnd_file.put_line(fnd_file.log, fnd_message.get);
3221:
3222: END IF;
3223: CLOSE cur_ad_interface;

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

3216: -- As the required parameters are not avilable to launch Admission Import Process,
3217: -- Log message is populated in log file.
3218: fnd_file.put_line( fnd_file.LOG ,' ');
3219: fnd_message.set_name('IGS','IGS_UC_NOT_LAUNCH_IMP_PROC');
3220: fnd_file.put_line(fnd_file.log, fnd_message.get);
3221:
3222: END IF;
3223: CLOSE cur_ad_interface;
3224:

Line 3229: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

3225: EXCEPTION
3226: WHEN OTHERS THEN
3227: p_status := FALSE;
3228: -- even though the admission import process completes in error , this process should continue processing
3229: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3230: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.ADM_IMPORT_PROCESS'||' - '||SQLERRM);
3231: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
3232:
3233: END adm_import_process;

Line 3230: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.ADM_IMPORT_PROCESS'||' - '||SQLERRM);

3226: WHEN OTHERS THEN
3227: p_status := FALSE;
3228: -- even though the admission import process completes in error , this process should continue processing
3229: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3230: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.ADM_IMPORT_PROCESS'||' - '||SQLERRM);
3231: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
3232:
3233: END adm_import_process;
3234:

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

3227: p_status := FALSE;
3228: -- even though the admission import process completes in error , this process should continue processing
3229: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3230: fnd_message.set_token('NAME','IGS_UC_EXP_APPLICANT_DTLS.ADM_IMPORT_PROCESS'||' - '||SQLERRM);
3231: fnd_file.put_line(fnd_file.LOG,fnd_message.get());
3232:
3233: END adm_import_process;
3234:
3235: END igs_uc_exp_applicant_dtls;