DBA Data[Home] [Help]

APPS.IGF_GR_REPACKAGE dependencies on FND_MESSAGE

Line 139: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

135: fnd_file.new_line(fnd_file.log,2);
136:
137: EXCEPTION
138: WHEN OTHERS THEN
139: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
140: fnd_message.set_token('NAME','IGF_GE_REPACKAGE.LOG_PARAMETERS '||SQLERRM);
141: igs_ge_msg_stack.add;
142:
143: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

Line 140: fnd_message.set_token('NAME','IGF_GE_REPACKAGE.LOG_PARAMETERS '||SQLERRM);

136:
137: EXCEPTION
138: WHEN OTHERS THEN
139: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
140: fnd_message.set_token('NAME','IGF_GE_REPACKAGE.LOG_PARAMETERS '||SQLERRM);
141: igs_ge_msg_stack.add;
142:
143: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
144: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_repackage.log_parameters.exception','sql error message:'||SQLERRM);

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

303: END IF;
304:
305: EXCEPTION
306: WHEN OTHERS THEN
307: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
308: fnd_message.set_token('NAME','IGF_GR_REPACKAGE.CANCEL_INVALID_AWARD ' || SQLERRM);
309: igs_ge_msg_stack.add;
310:
311: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

Line 308: fnd_message.set_token('NAME','IGF_GR_REPACKAGE.CANCEL_INVALID_AWARD ' || SQLERRM);

304:
305: EXCEPTION
306: WHEN OTHERS THEN
307: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
308: fnd_message.set_token('NAME','IGF_GR_REPACKAGE.CANCEL_INVALID_AWARD ' || SQLERRM);
309: igs_ge_msg_stack.add;
310:
311: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
312: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_gr_repackage.cancel_invalid_award.exception','sql error message:'||SQLERRM);

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

523:
524: BEGIN
525:
526: fnd_file.new_line(fnd_file.log,1);
527: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');
528: OPEN c_person_number(p_base_id);
529: FETCH c_person_number INTO l_person_number;
530: fnd_message.set_token('STUD',l_person_number);
531: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 530: fnd_message.set_token('STUD',l_person_number);

526: fnd_file.new_line(fnd_file.log,1);
527: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');
528: OPEN c_person_number(p_base_id);
529: FETCH c_person_number INTO l_person_number;
530: fnd_message.set_token('STUD',l_person_number);
531: fnd_file.put_line(fnd_file.log, fnd_message.get);
532:
533: OPEN c_stud_det(
534: p_base_id

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

527: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');
528: OPEN c_person_number(p_base_id);
529: FETCH c_person_number INTO l_person_number;
530: fnd_message.set_token('STUD',l_person_number);
531: fnd_file.put_line(fnd_file.log, fnd_message.get);
532:
533: OPEN c_stud_det(
534: p_base_id
535: );

Line 540: fnd_message.set_name('IGF', 'IGF_AW_NO_PELL_STUDENT');

536: FETCH c_stud_det INTO lc_stud_det;
537: IF c_stud_det%NOTFOUND THEN
538: CLOSE c_stud_det;
539:
540: fnd_message.set_name('IGF', 'IGF_AW_NO_PELL_STUDENT');
541: fnd_file.put_line(fnd_file.log, fnd_message.get);
542: RETURN;
543: END IF;
544:

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

537: IF c_stud_det%NOTFOUND THEN
538: CLOSE c_stud_det;
539:
540: fnd_message.set_name('IGF', 'IGF_AW_NO_PELL_STUDENT');
541: fnd_file.put_line(fnd_file.log, fnd_message.get);
542: RETURN;
543: END IF;
544:
545: --

Line 579: fnd_message.set_name('IGF', 'IGF_GR_DISB_SENT_NO_RECALC');

575: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','lc_rfms_disb.disb_ack_act_status:'||lc_rfms_disb.disb_ack_act_status);
576: END IF;
577:
578: IF lc_rfms_disb.disb_ack_act_status NOT IN ('R','N') THEN
579: fnd_message.set_name('IGF', 'IGF_GR_DISB_SENT_NO_RECALC');
580: fnd_file.put_line( fnd_file.log, fnd_message.get);
581:
582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','pell orig sent...erroring out');

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

576: END IF;
577:
578: IF lc_rfms_disb.disb_ack_act_status NOT IN ('R','N') THEN
579: fnd_message.set_name('IGF', 'IGF_GR_DISB_SENT_NO_RECALC');
580: fnd_file.put_line( fnd_file.log, fnd_message.get);
581:
582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','pell orig sent...erroring out');
584: END IF;

Line 604: fnd_message.set_name('IGF', 'IGF_AW_NO_AWARD_REC');

600: );
601: FETCH c_award INTO lc_award;
602:
603: IF c_award%NOTFOUND THEN
604: fnd_message.set_name('IGF', 'IGF_AW_NO_AWARD_REC');
605: fnd_file.put_line( fnd_file.log, fnd_message.get);
606: CLOSE c_award;
607:
608: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

601: FETCH c_award INTO lc_award;
602:
603: IF c_award%NOTFOUND THEN
604: fnd_message.set_name('IGF', 'IGF_AW_NO_AWARD_REC');
605: fnd_file.put_line( fnd_file.log, fnd_message.get);
606: CLOSE c_award;
607:
608: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
609: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','no PELL award for student');

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

649:
650: IF g_cancel_invalid_awds = 'Y' THEN
651: --cancel the award only if the user selects to cancel invalid awards
652:
653: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
654: fnd_message.set_token('AWD',lc_stud_det.award_id);
655: fnd_message.set_token('FUND',lc_stud_det.fund_code);
656: fnd_file.put_line(fnd_file.log,fnd_message.get);
657:

Line 654: fnd_message.set_token('AWD',lc_stud_det.award_id);

650: IF g_cancel_invalid_awds = 'Y' THEN
651: --cancel the award only if the user selects to cancel invalid awards
652:
653: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
654: fnd_message.set_token('AWD',lc_stud_det.award_id);
655: fnd_message.set_token('FUND',lc_stud_det.fund_code);
656: fnd_file.put_line(fnd_file.log,fnd_message.get);
657:
658: ELSE -- Test run but not in Cancel Mode

Line 655: fnd_message.set_token('FUND',lc_stud_det.fund_code);

651: --cancel the award only if the user selects to cancel invalid awards
652:
653: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
654: fnd_message.set_token('AWD',lc_stud_det.award_id);
655: fnd_message.set_token('FUND',lc_stud_det.fund_code);
656: fnd_file.put_line(fnd_file.log,fnd_message.get);
657:
658: ELSE -- Test run but not in Cancel Mode
659: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

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

652:
653: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
654: fnd_message.set_token('AWD',lc_stud_det.award_id);
655: fnd_message.set_token('FUND',lc_stud_det.fund_code);
656: fnd_file.put_line(fnd_file.log,fnd_message.get);
657:
658: ELSE -- Test run but not in Cancel Mode
659: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
660: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 659: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

655: fnd_message.set_token('FUND',lc_stud_det.fund_code);
656: fnd_file.put_line(fnd_file.log,fnd_message.get);
657:
658: ELSE -- Test run but not in Cancel Mode
659: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
660: fnd_file.put_line(fnd_file.log,fnd_message.get);
661: fnd_file.new_line(fnd_file.log,1);
662:
663: END IF;

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

656: fnd_file.put_line(fnd_file.log,fnd_message.get);
657:
658: ELSE -- Test run but not in Cancel Mode
659: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
660: fnd_file.put_line(fnd_file.log,fnd_message.get);
661: fnd_file.new_line(fnd_file.log,1);
662:
663: END IF;
664:

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

667:
668: IF g_cancel_invalid_awds = 'Y' THEN
669: --cancel the award only if the user selects to cancel invalid awards
670:
671: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
672: fnd_message.set_token('AWD',lc_stud_det.award_id);
673: fnd_message.set_token('FUND',lc_stud_det.fund_code);
674: fnd_file.put_line(fnd_file.log,fnd_message.get);
675:

Line 672: fnd_message.set_token('AWD',lc_stud_det.award_id);

668: IF g_cancel_invalid_awds = 'Y' THEN
669: --cancel the award only if the user selects to cancel invalid awards
670:
671: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
672: fnd_message.set_token('AWD',lc_stud_det.award_id);
673: fnd_message.set_token('FUND',lc_stud_det.fund_code);
674: fnd_file.put_line(fnd_file.log,fnd_message.get);
675:
676: cancel_invalid_award(lc_stud_det.award_id);

Line 673: fnd_message.set_token('FUND',lc_stud_det.fund_code);

669: --cancel the award only if the user selects to cancel invalid awards
670:
671: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
672: fnd_message.set_token('AWD',lc_stud_det.award_id);
673: fnd_message.set_token('FUND',lc_stud_det.fund_code);
674: fnd_file.put_line(fnd_file.log,fnd_message.get);
675:
676: cancel_invalid_award(lc_stud_det.award_id);
677: COMMIT;

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

670:
671: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
672: fnd_message.set_token('AWD',lc_stud_det.award_id);
673: fnd_message.set_token('FUND',lc_stud_det.fund_code);
674: fnd_file.put_line(fnd_file.log,fnd_message.get);
675:
676: cancel_invalid_award(lc_stud_det.award_id);
677: COMMIT;
678: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 684: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

680: END IF;
681:
682: ELSE -- Actual Mode but Cancel Awards not set to Yes
683:
684: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
685: fnd_file.put_line(fnd_file.log,fnd_message.get);
686: fnd_file.new_line(fnd_file.log,1);
687:
688: END IF;

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

681:
682: ELSE -- Actual Mode but Cancel Awards not set to Yes
683:
684: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
685: fnd_file.put_line(fnd_file.log,fnd_message.get);
686: fnd_file.new_line(fnd_file.log,1);
687:
688: END IF;
689:

Line 707: fnd_message.set_name('IGF','IGF_AP_PELL_ISIR_CHK');

703:
704: IF NVL(l_payment_isir.isir_id, -1) <> NVL(l_active_isir.isir_id, -2) THEN
705:
706: --log messages
707: fnd_message.set_name('IGF','IGF_AP_PELL_ISIR_CHK');
708: fnd_file.put_line(fnd_file.log,fnd_message.get);
709: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
710: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','payment isir is not active isir..error');
711: END IF;

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

704: IF NVL(l_payment_isir.isir_id, -1) <> NVL(l_active_isir.isir_id, -2) THEN
705:
706: --log messages
707: fnd_message.set_name('IGF','IGF_AP_PELL_ISIR_CHK');
708: fnd_file.put_line(fnd_file.log,fnd_message.get);
709: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
710: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','payment isir is not active isir..error');
711: END IF;
712:

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

711: END IF;
712:
713: IF g_test_run <> 'Y' AND g_cancel_invalid_awds = 'Y' THEN
714: --cancel award and disbursements
715: fnd_message.set_name('IGF','IGF_AP_PELL_ISIR_CHK');
716: fnd_file.put_line(fnd_file.log,fnd_message.get);
717:
718: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
719: fnd_message.set_token('AWD',lc_stud_det.award_id);

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

712:
713: IF g_test_run <> 'Y' AND g_cancel_invalid_awds = 'Y' THEN
714: --cancel award and disbursements
715: fnd_message.set_name('IGF','IGF_AP_PELL_ISIR_CHK');
716: fnd_file.put_line(fnd_file.log,fnd_message.get);
717:
718: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
719: fnd_message.set_token('AWD',lc_stud_det.award_id);
720: fnd_message.set_token('FUND',lc_stud_det.fund_code);

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

714: --cancel award and disbursements
715: fnd_message.set_name('IGF','IGF_AP_PELL_ISIR_CHK');
716: fnd_file.put_line(fnd_file.log,fnd_message.get);
717:
718: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
719: fnd_message.set_token('AWD',lc_stud_det.award_id);
720: fnd_message.set_token('FUND',lc_stud_det.fund_code);
721: fnd_file.put_line(fnd_file.log,fnd_message.get);
722:

Line 719: fnd_message.set_token('AWD',lc_stud_det.award_id);

715: fnd_message.set_name('IGF','IGF_AP_PELL_ISIR_CHK');
716: fnd_file.put_line(fnd_file.log,fnd_message.get);
717:
718: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
719: fnd_message.set_token('AWD',lc_stud_det.award_id);
720: fnd_message.set_token('FUND',lc_stud_det.fund_code);
721: fnd_file.put_line(fnd_file.log,fnd_message.get);
722:
723: cancel_invalid_award(lc_stud_det.award_id);

Line 720: fnd_message.set_token('FUND',lc_stud_det.fund_code);

716: fnd_file.put_line(fnd_file.log,fnd_message.get);
717:
718: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
719: fnd_message.set_token('AWD',lc_stud_det.award_id);
720: fnd_message.set_token('FUND',lc_stud_det.fund_code);
721: fnd_file.put_line(fnd_file.log,fnd_message.get);
722:
723: cancel_invalid_award(lc_stud_det.award_id);
724: COMMIT;

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

717:
718: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
719: fnd_message.set_token('AWD',lc_stud_det.award_id);
720: fnd_message.set_token('FUND',lc_stud_det.fund_code);
721: fnd_file.put_line(fnd_file.log,fnd_message.get);
722:
723: cancel_invalid_award(lc_stud_det.award_id);
724: COMMIT;
725: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 730: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

726: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','cancelled invalid award '||lc_stud_det.award_id);
727: END IF;
728:
729: ELSE
730: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
731: fnd_file.put_line(fnd_file.log,fnd_message.get);
732: fnd_file.new_line(fnd_file.log,1);
733: END IF;
734:

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

727: END IF;
728:
729: ELSE
730: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
731: fnd_file.put_line(fnd_file.log,fnd_message.get);
732: fnd_file.new_line(fnd_file.log,1);
733: END IF;
734:
735: RETURN ;

Line 783: fnd_message.set_name('IGF','IGF_GR_PELL_VALID_PELL_AWARD');

779: END IF;
780:
781: -- Check for new pall amount match in which case abort processing
782: IF l_offered_amt = lc_award.offered_amt THEN
783: fnd_message.set_name('IGF','IGF_GR_PELL_VALID_PELL_AWARD');
784: fnd_file.put_line(fnd_file.log,fnd_message.get);
785: RAISE e_next_record;
786: END IF;
787:

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

780:
781: -- Check for new pall amount match in which case abort processing
782: IF l_offered_amt = lc_award.offered_amt THEN
783: fnd_message.set_name('IGF','IGF_GR_PELL_VALID_PELL_AWARD');
784: fnd_file.put_line(fnd_file.log,fnd_message.get);
785: RAISE e_next_record;
786: END IF;
787:
788: -- Check if Origination Exists

Line 890: fnd_message.set_name('IGF','IGF_AW_ENTITLE_OVAWD');

886: Since PELL is an entitlement, we should not insert overaward holds on the award.
887: we show a message to the user saying that this award will result in an overaward, but we are not
888: inserting overaward holds as the fund is an entitlement
889: */
890: fnd_message.set_name('IGF','IGF_AW_ENTITLE_OVAWD');
891: fnd_message.set_token('FUND_CODE',lc_stud_det.fund_code);
892: fnd_message.set_token('AWD',TO_CHAR(l_offered_amt));
893: fnd_file.put_line(fnd_file.log,fnd_message.get);
894: END IF;

Line 891: fnd_message.set_token('FUND_CODE',lc_stud_det.fund_code);

887: we show a message to the user saying that this award will result in an overaward, but we are not
888: inserting overaward holds as the fund is an entitlement
889: */
890: fnd_message.set_name('IGF','IGF_AW_ENTITLE_OVAWD');
891: fnd_message.set_token('FUND_CODE',lc_stud_det.fund_code);
892: fnd_message.set_token('AWD',TO_CHAR(l_offered_amt));
893: fnd_file.put_line(fnd_file.log,fnd_message.get);
894: END IF;
895:

Line 892: fnd_message.set_token('AWD',TO_CHAR(l_offered_amt));

888: inserting overaward holds as the fund is an entitlement
889: */
890: fnd_message.set_name('IGF','IGF_AW_ENTITLE_OVAWD');
891: fnd_message.set_token('FUND_CODE',lc_stud_det.fund_code);
892: fnd_message.set_token('AWD',TO_CHAR(l_offered_amt));
893: fnd_file.put_line(fnd_file.log,fnd_message.get);
894: END IF;
895:
896: -- Loop thru the disbursements and post data

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

889: */
890: fnd_message.set_name('IGF','IGF_AW_ENTITLE_OVAWD');
891: fnd_message.set_token('FUND_CODE',lc_stud_det.fund_code);
892: fnd_message.set_token('AWD',TO_CHAR(l_offered_amt));
893: fnd_file.put_line(fnd_file.log,fnd_message.get);
894: END IF;
895:
896: -- Loop thru the disbursements and post data
897: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));

Line 1295: fnd_message.set_name('IGF','IGF_AW_PROCESS_COMPLETE');

1291: --issue a commit
1292: COMMIT;
1293:
1294:
1295: fnd_message.set_name('IGF','IGF_AW_PROCESS_COMPLETE');
1296: fnd_file.put_line( fnd_file.log, fnd_message.get);
1297: fnd_file.new_line(fnd_file.log,2);
1298:
1299: EXCEPTION

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

1292: COMMIT;
1293:
1294:
1295: fnd_message.set_name('IGF','IGF_AW_PROCESS_COMPLETE');
1296: fnd_file.put_line( fnd_file.log, fnd_message.get);
1297: fnd_file.new_line(fnd_file.log,2);
1298:
1299: EXCEPTION
1300:

Line 1303: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

1299: EXCEPTION
1300:
1301: WHEN e_next_record THEN
1302: ROLLBACK to sv_student;
1303: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
1304: fnd_file.put_line(fnd_file.log,fnd_message.get);
1305: fnd_file.new_line(fnd_file.log,1);
1306:
1307: WHEN others THEN

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

1300:
1301: WHEN e_next_record THEN
1302: ROLLBACK to sv_student;
1303: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
1304: fnd_file.put_line(fnd_file.log,fnd_message.get);
1305: fnd_file.new_line(fnd_file.log,1);
1306:
1307: WHEN others THEN
1308: ROLLBACK to sv_student;

Line 1310: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

1306:
1307: WHEN others THEN
1308: ROLLBACK to sv_student;
1309: fnd_file.put_line(fnd_file.log,SQLERRM);
1310: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
1311: fnd_file.new_line(fnd_file.log,1);
1312:
1313: END repackage;
1314:

Line 1381: fnd_message.set_name('IGS','IGS_GE_INSUFFICIENT_PARAMETER');

1377:
1378:
1379:
1380: IF p_award_year IS NULL THEN
1381: fnd_message.set_name('IGS','IGS_GE_INSUFFICIENT_PARAMETER');
1382: fnd_file.put_line(fnd_file.log,fnd_message.get);
1383: RETURN;
1384: END IF;
1385:

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

1378:
1379:
1380: IF p_award_year IS NULL THEN
1381: fnd_message.set_name('IGS','IGS_GE_INSUFFICIENT_PARAMETER');
1382: fnd_file.put_line(fnd_file.log,fnd_message.get);
1383: RETURN;
1384: END IF;
1385:
1386: -- Process only the given fund in the given Award Year.

Line 1408: fnd_message.set_name('IGF', 'IGF_AW_COA_PARAM_EX');

1404: log_parameters(l_ci_cal_type,l_ci_sequence_number,l_base_id,p_persid_grp,p_test_run,p_cancel_invalid_awds);
1405:
1406: IF p_base_id IS NOT NULL AND p_persid_grp IS NOT NULL THEN
1407: --Cannot pass both base_id and person_id group.
1408: fnd_message.set_name('IGF', 'IGF_AW_COA_PARAM_EX');
1409: fnd_file.put_line( fnd_file.log, fnd_message.get);
1410: RETURN;
1411: END IF;
1412:

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

1405:
1406: IF p_base_id IS NOT NULL AND p_persid_grp IS NOT NULL THEN
1407: --Cannot pass both base_id and person_id group.
1408: fnd_message.set_name('IGF', 'IGF_AW_COA_PARAM_EX');
1409: fnd_file.put_line( fnd_file.log, fnd_message.get);
1410: RETURN;
1411: END IF;
1412:
1413: --

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

1440:
1441: FETCH cur_base_id INTO l_base_id;
1442: END LOOP;
1443: ELSE
1444: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
1445: fnd_file.put_line(fnd_file.log,fnd_message.get);
1446: END IF;
1447:
1448: ELSIF p_base_id IS NOT NULL THEN

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

1441: FETCH cur_base_id INTO l_base_id;
1442: END LOOP;
1443: ELSE
1444: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
1445: fnd_file.put_line(fnd_file.log,fnd_message.get);
1446: END IF;
1447:
1448: ELSIF p_base_id IS NOT NULL THEN
1449: --call the routine for the single base_id

Line 1469: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');

1465: EXCEPTION
1466: WHEN app_exception.record_lock_exception THEN
1467: ROLLBACK;
1468: retcode := 2;
1469: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
1470: igs_ge_msg_stack.conc_exception_hndl;
1471: WHEN OTHERS THEN
1472: ROLLBACK ;
1473: retcode := 2;

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

1470: igs_ge_msg_stack.conc_exception_hndl;
1471: WHEN OTHERS THEN
1472: ROLLBACK ;
1473: retcode := 2;
1474: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1475: fnd_message.set_token('NAME','IGF_GR_REPACKAGE.REPACKAGE_PELL '||SQLERRM);
1476: errbuf := fnd_message.get;
1477: igs_ge_msg_stack.conc_exception_hndl;
1478:

Line 1475: fnd_message.set_token('NAME','IGF_GR_REPACKAGE.REPACKAGE_PELL '||SQLERRM);

1471: WHEN OTHERS THEN
1472: ROLLBACK ;
1473: retcode := 2;
1474: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1475: fnd_message.set_token('NAME','IGF_GR_REPACKAGE.REPACKAGE_PELL '||SQLERRM);
1476: errbuf := fnd_message.get;
1477: igs_ge_msg_stack.conc_exception_hndl;
1478:
1479: END repackage_pell;

Line 1476: errbuf := fnd_message.get;

1472: ROLLBACK ;
1473: retcode := 2;
1474: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1475: fnd_message.set_token('NAME','IGF_GR_REPACKAGE.REPACKAGE_PELL '||SQLERRM);
1476: errbuf := fnd_message.get;
1477: igs_ge_msg_stack.conc_exception_hndl;
1478:
1479: END repackage_pell;
1480: