DBA Data[Home] [Help]

APPS.IGF_AW_PACKAGING dependencies on IGS_GE_MSG_STACK

Line 703: igs_ge_msg_stack.add;

699: EXCEPTION
700: WHEN OTHERS THEN
701: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
702: fnd_message.set_token('NAME','IGF_AW_PACKAGING.GET_PLAN_DESC '|| SQLERRM);
703: igs_ge_msg_stack.add;
704: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
705: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.get_plan_desc.exception '|| g_req_id,'sql error message: '||SQLERRM);
706: END IF;
707: app_exception.raise_exception;

Line 826: igs_ge_msg_stack.add;

822: EXCEPTION
823: WHEN OTHERS THEN
824: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
825: fnd_message.set_token('NAME','IGF_AW_PACKAGING.setAPProcStat '|| SQLERRM);
826: igs_ge_msg_stack.add;
827: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
828: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.setAPProcStat.exception '|| g_req_id,'sql error message: '||SQLERRM);
829: END IF;
830: app_exception.raise_exception;

Line 918: igs_ge_msg_stack.add;

914: EXCEPTION
915: WHEN OTHERS THEN
916: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
917: fnd_message.set_token('NAME','IGF_AW_PACKAGING.CALC_STUDENTS_NEEDS '||SQLERRM);
918: igs_ge_msg_stack.add;
919: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
920: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.calc_students_need.exception '|| g_req_id,'sql error message: '||SQLERRM);
921: END IF;
922: app_exception.raise_exception;

Line 985: igs_ge_msg_stack.add;

981: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.check_plan.exception '|| g_req_id,'sql error:'||SQLERRM);
982: END IF;
983: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
984: fnd_message.set_token('NAME','IGF_AW_PACKAGING.CHECK_PLAN '||SQLERRM);
985: igs_ge_msg_stack.add;
986: app_exception.raise_exception;
987: END check_plan;
988:
989: PROCEDURE group_run(

Line 1114: igs_ge_msg_stack.add;

1110: EXCEPTION
1111: WHEN OTHERS THEN
1112: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1113: fnd_message.set_token('NAME','IGF_AW_PACKAGING.GROUP_RUN '||SQLERRM);
1114: igs_ge_msg_stack.add;
1115: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1116: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.group_run.exception '|| g_req_id,'sql error message: '||SQLERRM);
1117: END IF;
1118: app_exception.raise_exception;

Line 1167: igs_ge_msg_stack.add;

1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1166: fnd_message.set_token('NAME','IGF_AW_PACKAGING.CLEAR_SIMULATION '||SQLERRM);
1167: igs_ge_msg_stack.add;
1168: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1169: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.clear_simulation.exception '|| g_req_id,'sql error message: '||SQLERRM);
1170: END IF;
1171: app_exception.raise_exception;

Line 2048: igs_ge_msg_stack.add;

2044: EXCEPTION
2045: WHEN OTHERS THEN
2046: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2047: fnd_message.set_token('NAME','IGF_AW_PACKAGING.ROUND_OFF_DISBURSEMENTS '||SQLERRM);
2048: igs_ge_msg_stack.add;
2049:
2050: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2051: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.round_off_disbursements.exception '|| g_req_id,'sql error message: '||SQLERRM);
2052: END IF;

Line 4317: igs_ge_msg_stack.add;

4313: fnd_message.set_token('NAME','IGF_AW_PACKAGING.POST_AWARD' ||SQLERRM);
4314: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4315: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.post_award.exception '|| g_req_id,'sql error message: '||SQLERRM);
4316: END IF;
4317: igs_ge_msg_stack.add;
4318: app_exception.raise_exception;
4319: RETURN;
4320:
4321: END post_award;

Line 4677: igs_ge_msg_stack.add;

4673: EXCEPTION
4674: WHEN OTHERS THEN
4675: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4676: fnd_message.set_token('NAME','IGF_AW_PACKAGING.chk_gplus_loan_limits '||SQLERRM);
4677: igs_ge_msg_stack.add;
4678:
4679: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4680: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.chk_gplus_loan_limits.exception '|| g_req_id,'sql error message: '||SQLERRM);
4681: END IF;

Line 6572: igs_ge_msg_stack.add;

6568: WHEN OTHERS THEN
6569:
6570: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6571: fnd_message.set_token('NAME','IGF_AW_PACKAGING.LOAD_FUNDS '||SQLERRM);
6572: igs_ge_msg_stack.add;
6573: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
6574: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.load_funds.exception '|| g_req_id,'sql error message: '||SQLERRM);
6575: END IF;
6576: app_exception.raise_exception;

Line 7003: igs_ge_msg_stack.add;

6999: EXCEPTION
7000: WHEN OTHERS THEN
7001: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7002: fnd_message.set_token('NAME','IGF_AW_PACKAGING.EXCL_INCL_CHECK '||SQLERRM);
7003: igs_ge_msg_stack.add;
7004: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
7005: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.excl_incl_check.exception '|| g_req_id,'sql error message: '||SQLERRM);
7006: END IF;
7007: app_exception.raise_exception;

Line 8189: igs_ge_msg_stack.conc_exception_hndl;

8185: fnd_message.set_token('NAME','IGF_AW_PACKAGING.STUD_RUN ' || SQLERRM);
8186: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
8187: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.stud_run.exception '|| g_req_id,'sql error message: '||SQLERRM);
8188: END IF;
8189: igs_ge_msg_stack.conc_exception_hndl;
8190: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
8191:
8192: END IF;
8193:

Line 8235: igs_ge_msg_stack.conc_exception_hndl;

8231: fnd_message.set_token('NAME','IGF_AW_PACKAGING.STUD_RUN ' || SQLERRM);
8232: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
8233: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.stud_run.exception '|| g_req_id,'sql error message: '||SQLERRM);
8234: END IF;
8235: igs_ge_msg_stack.conc_exception_hndl;
8236: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
8237: fnd_file.put_line(fnd_file.log,fnd_message.get || igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER') || ' : ' || l_pers_num);
8238: fnd_file.put_line(fnd_file.log,' ');
8239:

Line 9461: IF igs_ge_msg_stack.count_msg > 0 THEN

9457: -- before we repackage, we should check whether the student's PELL eligibility changed after PELL was awarded
9458: lv_return_status := NULL;
9459: igf_gr_pell_calc.pell_elig(l_fabase.base_id,lv_return_status);
9460: IF NVL(lv_return_status,'N') = 'E' THEN
9461: IF igs_ge_msg_stack.count_msg > 0 THEN
9462: FOR i IN 1..igs_ge_msg_stack.count_msg LOOP
9463: lv_msg_text := NULL;
9464: igs_ge_msg_stack.get(i,'F',lv_msg_text, ln_msg_index);
9465: fnd_file.put_line(fnd_file.log,lv_msg_text);

Line 9462: FOR i IN 1..igs_ge_msg_stack.count_msg LOOP

9458: lv_return_status := NULL;
9459: igf_gr_pell_calc.pell_elig(l_fabase.base_id,lv_return_status);
9460: IF NVL(lv_return_status,'N') = 'E' THEN
9461: IF igs_ge_msg_stack.count_msg > 0 THEN
9462: FOR i IN 1..igs_ge_msg_stack.count_msg LOOP
9463: lv_msg_text := NULL;
9464: igs_ge_msg_stack.get(i,'F',lv_msg_text, ln_msg_index);
9465: fnd_file.put_line(fnd_file.log,lv_msg_text);
9466: END LOOP;

Line 9464: igs_ge_msg_stack.get(i,'F',lv_msg_text, ln_msg_index);

9460: IF NVL(lv_return_status,'N') = 'E' THEN
9461: IF igs_ge_msg_stack.count_msg > 0 THEN
9462: FOR i IN 1..igs_ge_msg_stack.count_msg LOOP
9463: lv_msg_text := NULL;
9464: igs_ge_msg_stack.get(i,'F',lv_msg_text, ln_msg_index);
9465: fnd_file.put_line(fnd_file.log,lv_msg_text);
9466: END LOOP;
9467: END IF;
9468: RAISE PELL_NO_REPACK;

Line 11564: igs_ge_msg_stack.add;

11560: RAISE;
11561: WHEN OTHERS THEN
11562: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11563: fnd_message.set_token('NAME','IGF_AW_PACKAGING.PROCESS_STUD '||SQLERRM);
11564: igs_ge_msg_stack.add;
11565: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
11566: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.process_stud.exception '|| g_req_id,'sql error:'||SQLERRM);
11567: END IF;
11568: RAISE;

Line 11603: igs_ge_msg_stack.add;

11599: fnd_message.set_token('NAME','IGF_AW_PACKAGING.GET_PROCESS_ID '|| SQLERRM);
11600: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
11601: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.get_process_id.exception '|| g_req_id,'sql error message: '||SQLERRM);
11602: END IF;
11603: igs_ge_msg_stack.add;
11604: app_exception.raise_exception;
11605:
11606: END get_process_id;
11607:

Line 11839: igs_ge_msg_stack.add;

11835: RAISE;
11836: WHEN OTHERS THEN
11837: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
11838: fnd_message.set_token('NAME','IGF_AW_PACKAGING.UPDATE_FUND '||SQLERRM);
11839: igs_ge_msg_stack.add;
11840: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
11841: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.update_fund.exception '|| g_req_id,'sql error message: '||SQLERRM);
11842: END IF;
11843: app_exception.raise_exception;

Line 12650: igs_ge_msg_stack.add;

12646: EXCEPTION
12647: WHEN OTHERS THEN
12648: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
12649: fnd_message.set_token('NAME','IGF_AW_PACKAGING.GET_DISBURSEMENTS '||SQLERRM);
12650: igs_ge_msg_stack.add;
12651: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
12652: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.get_disbursements.exception '|| g_req_id,'sql error message: '||SQLERRM);
12653: END IF;
12654: app_exception.raise_exception;

Line 12791: igs_ge_msg_stack.add;

12787: EXCEPTION
12788: WHEN OTHERS THEN
12789: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
12790: fnd_message.set_token('NAME','IGF_AW_PACKAGING.ADD_TODO '||SQLERRM);
12791: igs_ge_msg_stack.add;
12792: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
12793: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.add_todo.exception '|| g_req_id,'sql error message: '||SQLERRM);
12794: END IF;
12795: app_exception.raise_exception;

Line 12989: igs_ge_msg_stack.add;

12985: EXCEPTION
12986: WHEN OTHERS THEN
12987: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
12988: fnd_message.set_token('NAME','IGF_AW_PACKAGING.PROCESS_SINGLE_FUND '||SQLERRM);
12989: igs_ge_msg_stack.add;
12990: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
12991: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.process_single_fund.exception '|| g_req_id,'sql error message: '||SQLERRM);
12992: END IF;
12993: app_exception.raise_exception;

Line 13673: igs_ge_msg_stack.add;

13669: ROLLBACK;
13670: retcode := 2;
13671: fnd_file.new_line(fnd_file.log,2);
13672: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');
13673: igs_ge_msg_stack.add;
13674: igs_ge_msg_stack.conc_exception_hndl;
13675:
13676: WHEN OTHERS THEN
13677: ROLLBACK;

Line 13674: igs_ge_msg_stack.conc_exception_hndl;

13670: retcode := 2;
13671: fnd_file.new_line(fnd_file.log,2);
13672: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');
13673: igs_ge_msg_stack.add;
13674: igs_ge_msg_stack.conc_exception_hndl;
13675:
13676: WHEN OTHERS THEN
13677: ROLLBACK;
13678: RETCODE := 2;

Line 13685: igs_ge_msg_stack.conc_exception_hndl;

13681: errbuf := fnd_message.get;
13682: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
13683: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.run.exception '|| g_req_id,'sql error message: '||SQLERRM);
13684: END IF;
13685: igs_ge_msg_stack.conc_exception_hndl;
13686:
13687: END run;
13688:
13689:

Line 13823: igs_ge_msg_stack.add;

13819: ROLLBACK;
13820: retcode := 2;
13821: fnd_file.new_line(fnd_file.log,2);
13822: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');
13823: igs_ge_msg_stack.add;
13824: igs_ge_msg_stack.conc_exception_hndl;
13825:
13826: WHEN OTHERS THEN
13827: ROLLBACK;

Line 13824: igs_ge_msg_stack.conc_exception_hndl;

13820: retcode := 2;
13821: fnd_file.new_line(fnd_file.log,2);
13822: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');
13823: igs_ge_msg_stack.add;
13824: igs_ge_msg_stack.conc_exception_hndl;
13825:
13826: WHEN OTHERS THEN
13827: ROLLBACK;
13828: RETCODE := 2;

Line 13835: igs_ge_msg_stack.conc_exception_hndl;

13831: errbuf := fnd_message.get;
13832: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
13833: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_packaging.pkg_single_fund.exception '|| g_req_id,'sql error message: '||SQLERRM);
13834: END IF;
13835: igs_ge_msg_stack.conc_exception_hndl;
13836:
13837: END pkg_single_fund;
13838:
13839: END igf_aw_packaging;