APPS.IGF_AW_CANCEL_AWD dependencies on FND_MESSAGE

Line 253: fnd_message.set_name('IGF','IGF_AW_CANCEL_NOT_FOUND');

249: FETCH c_award INTO lc_award;
250:
251: IF c_award%NOTFOUND THEN
252: -- No awards found satisfying the criteria
253: fnd_message.set_name('IGF','IGF_AW_CANCEL_NOT_FOUND');
254: fnd_file.put_line( fnd_file.log, fnd_message.get);
255: CLOSE c_award;
256: RETURN;
257: END IF;

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

250:
251: IF c_award%NOTFOUND THEN
252: -- No awards found satisfying the criteria
253: fnd_message.set_name('IGF','IGF_AW_CANCEL_NOT_FOUND');
254: fnd_file.put_line( fnd_file.log, fnd_message.get);
255: CLOSE c_award;
256: RETURN;
257: END IF;
258:

Line 270: fnd_message.set_name('IGF','IGF_AW_AWARD_NOT_FOUND');

266: FETCH c_awd INTO lc_awd;
267:
268: IF c_awd%NOTFOUND THEN
269: -- This award does not seem to exist ???
270: fnd_message.set_name('IGF','IGF_AW_AWARD_NOT_FOUND');
271: fnd_file.put_line( fnd_file.log, fnd_message.get);
272: CLOSE c_awd;
273: RAISE e_next_record;
274: END IF;

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

267:
268: IF c_awd%NOTFOUND THEN
269: -- This award does not seem to exist ???
270: fnd_message.set_name('IGF','IGF_AW_AWARD_NOT_FOUND');
271: fnd_file.put_line( fnd_file.log, fnd_message.get);
272: CLOSE c_awd;
273: RAISE e_next_record;
274: END IF;
275:

Line 278: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_AWD');

274: END IF;
275:
276: l_retval := chk_awd_cancel(lc_awd.award_id,lc_awd.base_id,lc_awd.fund_id,l_msgname);
277:
278: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_AWD');
279: fnd_message.set_token('AWD_ID', lc_award.award_id);
280: fnd_file.put_line( fnd_file.log, fnd_message.get);
281:
282: -- Check if award can be cancelled

Line 279: fnd_message.set_token('AWD_ID', lc_award.award_id);

275:
276: l_retval := chk_awd_cancel(lc_awd.award_id,lc_awd.base_id,lc_awd.fund_id,l_msgname);
277:
278: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_AWD');
279: fnd_message.set_token('AWD_ID', lc_award.award_id);
280: fnd_file.put_line( fnd_file.log, fnd_message.get);
281:
282: -- Check if award can be cancelled
283: IF l_retval AND chk_awd_exp_date(

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

276: l_retval := chk_awd_cancel(lc_awd.award_id,lc_awd.base_id,lc_awd.fund_id,l_msgname);
277:
278: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_AWD');
279: fnd_message.set_token('AWD_ID', lc_award.award_id);
280: fnd_file.put_line( fnd_file.log, fnd_message.get);
281:
282: -- Check if award can be cancelled
283: IF l_retval AND chk_awd_exp_date(
284: p_base_id => lc_awd.base_id,

Line 373: fnd_message.set_name('IGF', 'IGF_AW_AWARD_CANCELLED');

369: END LOOP;
370:
371: igf_aw_gen.update_fabase_awds(lc_award.base_id,'CANCELLED');
372:
373: fnd_message.set_name('IGF', 'IGF_AW_AWARD_CANCELLED');
374: fnd_message.set_token('AWD', lc_award.award_id);
375: fnd_message.set_token('FUND', lc_award.fund_code);
376: fnd_file.put_line( fnd_file.log, fnd_message.get);
377: fnd_file.new_line(fnd_file.log,1);

Line 374: fnd_message.set_token('AWD', lc_award.award_id);

370:
371: igf_aw_gen.update_fabase_awds(lc_award.base_id,'CANCELLED');
372:
373: fnd_message.set_name('IGF', 'IGF_AW_AWARD_CANCELLED');
374: fnd_message.set_token('AWD', lc_award.award_id);
375: fnd_message.set_token('FUND', lc_award.fund_code);
376: fnd_file.put_line( fnd_file.log, fnd_message.get);
377: fnd_file.new_line(fnd_file.log,1);
378:

Line 375: fnd_message.set_token('FUND', lc_award.fund_code);

371: igf_aw_gen.update_fabase_awds(lc_award.base_id,'CANCELLED');
372:
373: fnd_message.set_name('IGF', 'IGF_AW_AWARD_CANCELLED');
374: fnd_message.set_token('AWD', lc_award.award_id);
375: fnd_message.set_token('FUND', lc_award.fund_code);
376: fnd_file.put_line( fnd_file.log, fnd_message.get);
377: fnd_file.new_line(fnd_file.log,1);
378:
379: -- Log

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

372:
373: fnd_message.set_name('IGF', 'IGF_AW_AWARD_CANCELLED');
374: fnd_message.set_token('AWD', lc_award.award_id);
375: fnd_message.set_token('FUND', lc_award.fund_code);
376: fnd_file.put_line( fnd_file.log, fnd_message.get);
377: fnd_file.new_line(fnd_file.log,1);
378:
379: -- Log
380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 389: fnd_message.set_name('IGF', l_msgname);

385: ELSE
386: -- AWARD INELIGIBLE FOR CANCELLATION
387: IF l_msgname IS NOT NULL THEN
388: -- chk_awd_cancel() failed
389: fnd_message.set_name('IGF', l_msgname);
390: fnd_file.put_line( fnd_file.log, fnd_message.get);
391:
392: -- Log
393: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

386: -- AWARD INELIGIBLE FOR CANCELLATION
387: IF l_msgname IS NOT NULL THEN
388: -- chk_awd_cancel() failed
389: fnd_message.set_name('IGF', l_msgname);
390: fnd_file.put_line( fnd_file.log, fnd_message.get);
391:
392: -- Log
393: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
394: fnd_log.string(fnd_log.level_statement,

Line 525: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');

521: FETCH cur_alt_code INTO l_alt_code;
522:
523: IF cur_alt_code%NOTFOUND THEN
524: CLOSE cur_alt_code;
525: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');
526: igs_ge_msg_stack.add;
527: fnd_file.put_line(fnd_file.log,fnd_message.get);
528: RAISE NO_DATA_FOUND;
529: END IF;

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

523: IF cur_alt_code%NOTFOUND THEN
524: CLOSE cur_alt_code;
525: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');
526: igs_ge_msg_stack.add;
527: fnd_file.put_line(fnd_file.log,fnd_message.get);
528: RAISE NO_DATA_FOUND;
529: END IF;
530: CLOSE cur_alt_code;
531:

Line 585: fnd_message.set_name('IGS','IGS_AD_SYSCAL_CONFIG_NOT_DTMN');

581:
582: -- Award Year
583: IF l_ci_cal_type IS NULL OR l_ci_sequence_number IS NULL THEN
584: -- Err
585: fnd_message.set_name('IGS','IGS_AD_SYSCAL_CONFIG_NOT_DTMN');
586: fnd_file.put_line(fnd_file.log, fnd_message.get);
587: RAISE PARAM_ERR;
588: END IF;
589:

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

582: -- Award Year
583: IF l_ci_cal_type IS NULL OR l_ci_sequence_number IS NULL THEN
584: -- Err
585: fnd_message.set_name('IGS','IGS_AD_SYSCAL_CONFIG_NOT_DTMN');
586: fnd_file.put_line(fnd_file.log, fnd_message.get);
587: RAISE PARAM_ERR;
588: END IF;
589:
590: -- Base Id and PIG

Line 593: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');

589:
590: -- Base Id and PIG
591: IF (p_base_id IS NOT NULL) AND (p_pig IS NOT NULL) THEN
592: -- Err
593: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
594: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
595: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
596: fnd_file.put_line(fnd_file.log, fnd_message.get);
597: fnd_file.new_line(fnd_file.log, 1);

Line 594: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));

590: -- Base Id and PIG
591: IF (p_base_id IS NOT NULL) AND (p_pig IS NOT NULL) THEN
592: -- Err
593: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
594: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
595: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
596: fnd_file.put_line(fnd_file.log, fnd_message.get);
597: fnd_file.new_line(fnd_file.log, 1);
598: RAISE PARAM_ERR;

Line 595: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));

591: IF (p_base_id IS NOT NULL) AND (p_pig IS NOT NULL) THEN
592: -- Err
593: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
594: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
595: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
596: fnd_file.put_line(fnd_file.log, fnd_message.get);
597: fnd_file.new_line(fnd_file.log, 1);
598: RAISE PARAM_ERR;
599: END IF;

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

592: -- Err
593: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
594: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
595: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
596: fnd_file.put_line(fnd_file.log, fnd_message.get);
597: fnd_file.new_line(fnd_file.log, 1);
598: RAISE PARAM_ERR;
599: END IF;
600:

Line 633: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');

629: 'Parameters base_id is available and pig is NULL. Calling cancel_award_fabase');
630: END IF;
631:
632: fnd_file.new_line(fnd_file.log,1);
633: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');
634: fnd_message.set_token('STUD', l_person_no);
635: fnd_file.put_line( fnd_file.log, fnd_message.get);
636:
637: cancel_award_fabase (

Line 634: fnd_message.set_token('STUD', l_person_no);

630: END IF;
631:
632: fnd_file.new_line(fnd_file.log,1);
633: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');
634: fnd_message.set_token('STUD', l_person_no);
635: fnd_file.put_line( fnd_file.log, fnd_message.get);
636:
637: cancel_award_fabase (
638: p_ci_cal_type => l_ci_cal_type,

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

631:
632: fnd_file.new_line(fnd_file.log,1);
633: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');
634: fnd_message.set_token('STUD', l_person_no);
635: fnd_file.put_line( fnd_file.log, fnd_message.get);
636:
637: cancel_award_fabase (
638: p_ci_cal_type => l_ci_cal_type,
639: p_ci_seq_num => l_ci_sequence_number,

Line 697: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');

693: 'Calling cancel_award_fabase for base_id: ' ||l_base_id);
694: END IF;
695:
696: fnd_file.new_line(fnd_file.log,1);
697: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');
698: fnd_message.set_token('STUD', l_person_no);
699: fnd_file.put_line( fnd_file.log, fnd_message.get);
700:
701: cancel_award_fabase (

Line 698: fnd_message.set_token('STUD', l_person_no);

694: END IF;
695:
696: fnd_file.new_line(fnd_file.log,1);
697: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');
698: fnd_message.set_token('STUD', l_person_no);
699: fnd_file.put_line( fnd_file.log, fnd_message.get);
700:
701: cancel_award_fabase (
702: p_ci_cal_type => l_ci_cal_type,

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

695:
696: fnd_file.new_line(fnd_file.log,1);
697: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');
698: fnd_message.set_token('STUD', l_person_no);
699: fnd_file.put_line( fnd_file.log, fnd_message.get);
700:
701: cancel_award_fabase (
702: p_ci_cal_type => l_ci_cal_type,
703: p_ci_seq_num => l_ci_sequence_number,

Line 710: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');

706: p_run_mode => p_run_mode
707: );
708: ELSE
709: IF l_person_no IS NULL THEN
710: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
711: fnd_file.put_line(fnd_file.log,RPAD(' ',5) ||fnd_message.get);
712: END IF;
713:
714: IF l_base_id is NULL THEN

Line 711: fnd_file.put_line(fnd_file.log,RPAD(' ',5) ||fnd_message.get);

707: );
708: ELSE
709: IF l_person_no IS NULL THEN
710: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
711: fnd_file.put_line(fnd_file.log,RPAD(' ',5) ||fnd_message.get);
712: END IF;
713:
714: IF l_base_id is NULL THEN
715: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');

Line 715: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');

711: fnd_file.put_line(fnd_file.log,RPAD(' ',5) ||fnd_message.get);
712: END IF;
713:
714: IF l_base_id is NULL THEN
715: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');
716: fnd_message.set_token('PERSON_NUMBER', l_person_no);
717: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_ci_cal_type, l_ci_sequence_number));
718: fnd_file.put_line(fnd_file.log,fnd_message.get);
719: END IF;

Line 716: fnd_message.set_token('PERSON_NUMBER', l_person_no);

712: END IF;
713:
714: IF l_base_id is NULL THEN
715: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');
716: fnd_message.set_token('PERSON_NUMBER', l_person_no);
717: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_ci_cal_type, l_ci_sequence_number));
718: fnd_file.put_line(fnd_file.log,fnd_message.get);
719: END IF;
720:

Line 717: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_ci_cal_type, l_ci_sequence_number));

713:
714: IF l_base_id is NULL THEN
715: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');
716: fnd_message.set_token('PERSON_NUMBER', l_person_no);
717: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_ci_cal_type, l_ci_sequence_number));
718: fnd_file.put_line(fnd_file.log,fnd_message.get);
719: END IF;
720:
721: END IF;

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

714: IF l_base_id is NULL THEN
715: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');
716: fnd_message.set_token('PERSON_NUMBER', l_person_no);
717: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(l_ci_cal_type, l_ci_sequence_number));
718: fnd_file.put_line(fnd_file.log,fnd_message.get);
719: END IF;
720:
721: END IF;
722: END IF; -- l_party_id IS NOT NULL

Line 727: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');

723: END LOOP;
724:
725: IF NOT l_per_exists THEN
726: -- No records found in PIG
727: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
728: fnd_file.put_line(fnd_file.log,fnd_message.get);
729: END IF;
730:
731: END IF;

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

724:
725: IF NOT l_per_exists THEN
726: -- No records found in PIG
727: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
728: fnd_file.put_line(fnd_file.log,fnd_message.get);
729: END IF;
730:
731: END IF;
732:

Line 738: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');

734:
735: WHEN PARAM_ERR THEN
736: ROLLBACK;
737: RETCODE := 2;
738: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');
739: ERRBUF := fnd_message.get;
740: igs_ge_msg_stack.conc_exception_hndl;
741:
742: WHEN NO_DATA_FOUND THEN

Line 739: ERRBUF := fnd_message.get;

735: WHEN PARAM_ERR THEN
736: ROLLBACK;
737: RETCODE := 2;
738: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');
739: ERRBUF := fnd_message.get;
740: igs_ge_msg_stack.conc_exception_hndl;
741:
742: WHEN NO_DATA_FOUND THEN
743: NULL;

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

744:
745: WHEN OTHERS THEN
746: ROLLBACK ;
747: RETCODE := 2;
748: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
749: fnd_message.set_token('NAME','igf_aw_cancel_awd.cancel_award');
750: ERRBUF := fnd_message.get;
751: igs_ge_msg_stack.conc_exception_hndl;
752:

Line 749: fnd_message.set_token('NAME','igf_aw_cancel_awd.cancel_award');

745: WHEN OTHERS THEN
746: ROLLBACK ;
747: RETCODE := 2;
748: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
749: fnd_message.set_token('NAME','igf_aw_cancel_awd.cancel_award');
750: ERRBUF := fnd_message.get;
751: igs_ge_msg_stack.conc_exception_hndl;
752:
753: END cancel_award;

Line 750: ERRBUF := fnd_message.get;

746: ROLLBACK ;
747: RETCODE := 2;
748: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
749: fnd_message.set_token('NAME','igf_aw_cancel_awd.cancel_award');
750: ERRBUF := fnd_message.get;
751: igs_ge_msg_stack.conc_exception_hndl;
752:
753: END cancel_award;
754:

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

949: IF cur_dl_disb%ISOPEN THEN
950: CLOSE cur_dl_disb;
951: END IF;
952:
953: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
954: fnd_message.set_token('NAME','igf_aw_cancel_awd.chk_awd_cancel');
955: igs_ge_msg_stack.conc_exception_hndl;
956: RETURN FALSE;
957:

Line 954: fnd_message.set_token('NAME','igf_aw_cancel_awd.chk_awd_cancel');

950: CLOSE cur_dl_disb;
951: END IF;
952:
953: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
954: fnd_message.set_token('NAME','igf_aw_cancel_awd.chk_awd_cancel');
955: igs_ge_msg_stack.conc_exception_hndl;
956: RETURN FALSE;
957:
958: END chk_awd_cancel;