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;
708: END get_plan_desc;
709:
710: PROCEDURE setAPProcStat(
711: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
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;
831: END setAPProcStat;
832:
833: PROCEDURE calc_students_needs(
834: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
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;
923:
924: END calc_students_needs;
925:
926: PROCEDURE check_plan(
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(
990: l_group_code IN VARCHAR2,
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;
1119: END group_run;
1120:
1121:
1122: PROCEDURE clear_simulation( l_base_id IN NUMBER ) IS
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;
1172: END clear_simulation;
1173:
1174: FUNCTION get_coa_lock_prof_val RETURN VARCHAR2 AS
1175: ------------------------------------------------------------------
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;
2053:
2054: app_exception.raise_exception;
2055: END round_off_disbursements;
2056:
2057: -- This process posts records in the Awards and Disbursements Table
2058: PROCEDURE post_award(
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;
4322:
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;
6577: END load_funds;
6578:
6579:
6580: PROCEDURE excl_incl_check(
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;
7008: END excl_incl_check;
7009:
7010:
7011: PROCEDURE calc_need(
8238: fnd_file.put_line(fnd_file.log,' ');
8239:
8240: -------------------------------------------------------------------------
8241: -- Important : Do not remove these comments
8242: -- APP_EXCEPTION.RAISE_EXCEPTION;
8243: -- As stud_run is called in loop; if a student fails any of the criteria
8244: -- then we should skip that record
8245: -- and proceed to the next record
8246: -- control should not come out NOCOPY at this point
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:
11608:
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;
11844:
11845: END update_fund;
11846:
11847:
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;
12655: END get_disbursements;
12656:
12657: PROCEDURE add_todo(
12658: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
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;
12796:
12797: END add_todo;
12798:
12799:
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;
12994: END process_single_fund;
12995:
12996: PROCEDURE log_parameters(
12997: p_award_year VARCHAR2 DEFAULT NULL,