101: RETURN ln_coa;
102:
103: EXCEPTION
104: WHEN OTHERS THEN
105: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
106: fnd_message.set_token('NAME','IGF_AW_COA_GEN.COA_AMOUNT ' || SQLERRM);
107: igs_ge_msg_stack.add;
108: app_exception.raise_exception;
109:
102:
103: EXCEPTION
104: WHEN OTHERS THEN
105: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
106: fnd_message.set_token('NAME','IGF_AW_COA_GEN.COA_AMOUNT ' || SQLERRM);
107: igs_ge_msg_stack.add;
108: app_exception.raise_exception;
109:
110: END coa_amount;
185: RETURN ln_award;
186:
187: EXCEPTION
188: WHEN OTHERS THEN
189: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
190: fnd_message.set_token('NAME','IGF_AW_COA_GEN.AWARD_AMOUNT ' || SQLERRM);
191: igs_ge_msg_stack.add;
192: app_exception.raise_exception;
193:
186:
187: EXCEPTION
188: WHEN OTHERS THEN
189: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
190: fnd_message.set_token('NAME','IGF_AW_COA_GEN.AWARD_AMOUNT ' || SQLERRM);
191: igs_ge_msg_stack.add;
192: app_exception.raise_exception;
193:
194: END award_amount;
328:
329:
330: EXCEPTION
331: WHEN OTHERS THEN
332: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
333: fnd_message.set_token('NAME','IGF_AW_COA_GEN.ISCOALOCKED ' || SQLERRM);
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336:
329:
330: EXCEPTION
331: WHEN OTHERS THEN
332: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
333: fnd_message.set_token('NAME','IGF_AW_COA_GEN.ISCOALOCKED ' || SQLERRM);
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336:
337: END isCoaLocked;
504: OPEN c_item_term(p_base_id,p_item_code,p_ld_cal_type,p_ld_sequence_number);
505: FETCH c_item_term INTO l_item_term;
506: CLOSE c_item_term;
507:
508: fnd_message.set_name('IGF','IGF_AW_ITM_TRM_LOCK');
509: fnd_message.set_token('ITEM',p_item_code);
510: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type,p_ld_sequence_number));
511: fnd_file.put_line(fnd_file.log,RPAD(' ',8)||fnd_message.get);
512:
505: FETCH c_item_term INTO l_item_term;
506: CLOSE c_item_term;
507:
508: fnd_message.set_name('IGF','IGF_AW_ITM_TRM_LOCK');
509: fnd_message.set_token('ITEM',p_item_code);
510: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type,p_ld_sequence_number));
511: fnd_file.put_line(fnd_file.log,RPAD(' ',8)||fnd_message.get);
512:
513:
506: CLOSE c_item_term;
507:
508: fnd_message.set_name('IGF','IGF_AW_ITM_TRM_LOCK');
509: fnd_message.set_token('ITEM',p_item_code);
510: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type,p_ld_sequence_number));
511: fnd_file.put_line(fnd_file.log,RPAD(' ',8)||fnd_message.get);
512:
513:
514: igf_aw_coa_itm_terms_pkg.update_row(
507:
508: fnd_message.set_name('IGF','IGF_AW_ITM_TRM_LOCK');
509: fnd_message.set_token('ITEM',p_item_code);
510: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type,p_ld_sequence_number));
511: fnd_file.put_line(fnd_file.log,RPAD(' ',8)||fnd_message.get);
512:
513:
514: igf_aw_coa_itm_terms_pkg.update_row(
515: x_rowid => l_item_term.row_id,
570: OPEN c_base(p_base_id);
571: FETCH c_base INTO l_base;
572: CLOSE c_base;
573:
574: fnd_message.set_name('IGF','IGF_AW_BUDGET_LOCK');
575: fnd_file.put_line(fnd_file.log,RPAD(' ',4)||fnd_message.get);
576:
577:
578: igf_ap_fa_base_rec_pkg.update_row(
571: FETCH c_base INTO l_base;
572: CLOSE c_base;
573:
574: fnd_message.set_name('IGF','IGF_AW_BUDGET_LOCK');
575: fnd_file.put_line(fnd_file.log,RPAD(' ',4)||fnd_message.get);
576:
577:
578: igf_ap_fa_base_rec_pkg.update_row(
579: x_rowid => l_base.row_id,
725: OPEN c_item_term(p_base_id,p_item_code,p_ld_cal_type,p_ld_sequence_number);
726: FETCH c_item_term INTO l_item_term;
727: CLOSE c_item_term;
728:
729: fnd_message.set_name('IGF','IGF_AW_ITM_TRM_UNLOCK');
730: fnd_message.set_token('ITEM',p_item_code);
731: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type,p_ld_sequence_number));
732: fnd_file.put_line(fnd_file.log,RPAD(' ',4)||fnd_message.get);
733:
726: FETCH c_item_term INTO l_item_term;
727: CLOSE c_item_term;
728:
729: fnd_message.set_name('IGF','IGF_AW_ITM_TRM_UNLOCK');
730: fnd_message.set_token('ITEM',p_item_code);
731: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type,p_ld_sequence_number));
732: fnd_file.put_line(fnd_file.log,RPAD(' ',4)||fnd_message.get);
733:
734:
727: CLOSE c_item_term;
728:
729: fnd_message.set_name('IGF','IGF_AW_ITM_TRM_UNLOCK');
730: fnd_message.set_token('ITEM',p_item_code);
731: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type,p_ld_sequence_number));
732: fnd_file.put_line(fnd_file.log,RPAD(' ',4)||fnd_message.get);
733:
734:
735: igf_aw_coa_itm_terms_pkg.update_row(
728:
729: fnd_message.set_name('IGF','IGF_AW_ITM_TRM_UNLOCK');
730: fnd_message.set_token('ITEM',p_item_code);
731: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type,p_ld_sequence_number));
732: fnd_file.put_line(fnd_file.log,RPAD(' ',4)||fnd_message.get);
733:
734:
735: igf_aw_coa_itm_terms_pkg.update_row(
736: x_rowid => l_item_term.row_id,
803: OPEN c_base(p_base_id);
804: FETCH c_base INTO l_base;
805: CLOSE c_base;
806:
807: fnd_message.set_name('IGF','IGF_AW_BUDGET_UNLOCK');
808: fnd_file.put_line(fnd_file.log,RPAD(' ',8)||fnd_message.get);
809:
810:
811: igf_ap_fa_base_rec_pkg.update_row(
804: FETCH c_base INTO l_base;
805: CLOSE c_base;
806:
807: fnd_message.set_name('IGF','IGF_AW_BUDGET_UNLOCK');
808: fnd_file.put_line(fnd_file.log,RPAD(' ',8)||fnd_message.get);
809:
810:
811: igf_ap_fa_base_rec_pkg.update_row(
812: x_rowid => l_base.row_id,
981:
982: EXCEPTION
983: WHEN OTHERS THEN
984: ROLLBACK TO IGF_AW_COA_GEN_DOLOCK;
985: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
986: fnd_message.set_token('NAME','IGF_AW_COA_GEN.DOLOCK ' || SQLERRM);
987: igs_ge_msg_stack.add;
988: app_exception.raise_exception;
989:
982: EXCEPTION
983: WHEN OTHERS THEN
984: ROLLBACK TO IGF_AW_COA_GEN_DOLOCK;
985: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
986: fnd_message.set_token('NAME','IGF_AW_COA_GEN.DOLOCK ' || SQLERRM);
987: igs_ge_msg_stack.add;
988: app_exception.raise_exception;
989:
990: END doLock;
1033:
1034: EXCEPTION
1035: WHEN OTHERS THEN
1036: ROLLBACK TO IGF_AW_COA_GEN_DOUNLOCK;
1037: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1038: fnd_message.set_token('NAME','IGF_AW_COA_GEN.DOUNLOCK ' || SQLERRM);
1039: igs_ge_msg_stack.add;
1040: app_exception.raise_exception;
1041:
1034: EXCEPTION
1035: WHEN OTHERS THEN
1036: ROLLBACK TO IGF_AW_COA_GEN_DOUNLOCK;
1037: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1038: fnd_message.set_token('NAME','IGF_AW_COA_GEN.DOUNLOCK ' || SQLERRM);
1039: igs_ge_msg_stack.add;
1040: app_exception.raise_exception;
1041:
1042: END doUnlock;
1820:
1821: RETURN l_base_det;
1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1825: fnd_message.set_token('NAME','IGF_AW_COA_GEN.GETBASEDETAILS ' || SQLERRM);
1826: igs_ge_msg_stack.add;
1827: app_exception.raise_exception;
1828: END getBaseDetails;
1821: RETURN l_base_det;
1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1825: fnd_message.set_token('NAME','IGF_AW_COA_GEN.GETBASEDETAILS ' || SQLERRM);
1826: igs_ge_msg_stack.add;
1827: app_exception.raise_exception;
1828: END getBaseDetails;
1829:
1943: END IF;
1944: EXCEPTION
1945: WHEN OTHERS THEN
1946: ROLLBACK TO IGFAW17B_INS_COA_TODO;
1947: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1948: fnd_message.set_token('NAME','IGF_AW_COA_GEN.INS_COA_TODO ' || SQLERRM);
1949: igs_ge_msg_stack.add;
1950: app_exception.raise_exception;
1951:
1944: EXCEPTION
1945: WHEN OTHERS THEN
1946: ROLLBACK TO IGFAW17B_INS_COA_TODO;
1947: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1948: fnd_message.set_token('NAME','IGF_AW_COA_GEN.INS_COA_TODO ' || SQLERRM);
1949: igs_ge_msg_stack.add;
1950: app_exception.raise_exception;
1951:
1952: END ins_coa_todo;
2280: FETCH c_chk_org INTO l_chk_org;
2281:
2282: IF c_chk_org%NOTFOUND THEN
2283: p_ret_status := 'W' ;
2284: fnd_message.set_name('IGF','IGF_AW_NOT_RESP_ORG_UNIT');
2285: fnd_message.set_token('ORG_UNIT',p_org_unit_code);
2286: fnd_message.set_token('PROG_CODE',p_program_code);
2287: igs_ge_msg_stack.add;
2288: END IF;
2281:
2282: IF c_chk_org%NOTFOUND THEN
2283: p_ret_status := 'W' ;
2284: fnd_message.set_name('IGF','IGF_AW_NOT_RESP_ORG_UNIT');
2285: fnd_message.set_token('ORG_UNIT',p_org_unit_code);
2286: fnd_message.set_token('PROG_CODE',p_program_code);
2287: igs_ge_msg_stack.add;
2288: END IF;
2289: CLOSE c_chk_org;
2282: IF c_chk_org%NOTFOUND THEN
2283: p_ret_status := 'W' ;
2284: fnd_message.set_name('IGF','IGF_AW_NOT_RESP_ORG_UNIT');
2285: fnd_message.set_token('ORG_UNIT',p_org_unit_code);
2286: fnd_message.set_token('PROG_CODE',p_program_code);
2287: igs_ge_msg_stack.add;
2288: END IF;
2289: CLOSE c_chk_org;
2290: END IF;
2298: FETCH c_chk_prog INTO l_chk_prog;
2299:
2300: IF c_chk_prog%NOTFOUND THEN
2301: p_ret_status := 'W' ;
2302: fnd_message.set_name('IGF','IGF_AW_PROG_NOT_OF_TYPE');
2303: fnd_message.set_token('PROG_CODE',p_program_code);
2304: fnd_message.set_token('PROG_TYPE',p_program_type);
2305: igs_ge_msg_stack.add;
2306: END IF;
2299:
2300: IF c_chk_prog%NOTFOUND THEN
2301: p_ret_status := 'W' ;
2302: fnd_message.set_name('IGF','IGF_AW_PROG_NOT_OF_TYPE');
2303: fnd_message.set_token('PROG_CODE',p_program_code);
2304: fnd_message.set_token('PROG_TYPE',p_program_type);
2305: igs_ge_msg_stack.add;
2306: END IF;
2307: CLOSE c_chk_prog;
2300: IF c_chk_prog%NOTFOUND THEN
2301: p_ret_status := 'W' ;
2302: fnd_message.set_name('IGF','IGF_AW_PROG_NOT_OF_TYPE');
2303: fnd_message.set_token('PROG_CODE',p_program_code);
2304: fnd_message.set_token('PROG_TYPE',p_program_type);
2305: igs_ge_msg_stack.add;
2306: END IF;
2307: CLOSE c_chk_prog;
2308: END IF;
2316:
2317: FETCH c_chk_prog_offer INTO l_chk_prog_offer;
2318: IF c_chk_prog_offer%NOTFOUND THEN
2319: p_ret_status := 'W' ;
2320: fnd_message.set_name('IGF','IGF_AW_PRG_NT_OFFER');
2321: fnd_message.set_token('PROG_CODE',p_program_code);
2322: fnd_message.set_token('PROG_LOC',p_program_location);
2323: igs_ge_msg_stack.add;
2324: END IF;
2317: FETCH c_chk_prog_offer INTO l_chk_prog_offer;
2318: IF c_chk_prog_offer%NOTFOUND THEN
2319: p_ret_status := 'W' ;
2320: fnd_message.set_name('IGF','IGF_AW_PRG_NT_OFFER');
2321: fnd_message.set_token('PROG_CODE',p_program_code);
2322: fnd_message.set_token('PROG_LOC',p_program_location);
2323: igs_ge_msg_stack.add;
2324: END IF;
2325: CLOSE c_chk_prog_offer;
2318: IF c_chk_prog_offer%NOTFOUND THEN
2319: p_ret_status := 'W' ;
2320: fnd_message.set_name('IGF','IGF_AW_PRG_NT_OFFER');
2321: fnd_message.set_token('PROG_CODE',p_program_code);
2322: fnd_message.set_token('PROG_LOC',p_program_location);
2323: igs_ge_msg_stack.add;
2324: END IF;
2325: CLOSE c_chk_prog_offer;
2326: END IF;
2335:
2336: FETCH c_chk_prog_option INTO l_chk_prog_option;
2337: IF c_chk_prog_option%NOTFOUND THEN
2338: p_ret_status := 'W' ;
2339: fnd_message.set_name('IGF','IGF_AW_NO_PROG_LOC');
2340: fnd_message.set_token('PROG_CODE',p_program_code);
2341: fnd_message.set_token('PROG_LOC',p_program_location);
2342: fnd_message.set_token('ATTND_TYPE',p_attend_type);
2343: fnd_message.set_token('ATTND_MODE',p_attend_mode);
2336: FETCH c_chk_prog_option INTO l_chk_prog_option;
2337: IF c_chk_prog_option%NOTFOUND THEN
2338: p_ret_status := 'W' ;
2339: fnd_message.set_name('IGF','IGF_AW_NO_PROG_LOC');
2340: fnd_message.set_token('PROG_CODE',p_program_code);
2341: fnd_message.set_token('PROG_LOC',p_program_location);
2342: fnd_message.set_token('ATTND_TYPE',p_attend_type);
2343: fnd_message.set_token('ATTND_MODE',p_attend_mode);
2344: igs_ge_msg_stack.add;
2337: IF c_chk_prog_option%NOTFOUND THEN
2338: p_ret_status := 'W' ;
2339: fnd_message.set_name('IGF','IGF_AW_NO_PROG_LOC');
2340: fnd_message.set_token('PROG_CODE',p_program_code);
2341: fnd_message.set_token('PROG_LOC',p_program_location);
2342: fnd_message.set_token('ATTND_TYPE',p_attend_type);
2343: fnd_message.set_token('ATTND_MODE',p_attend_mode);
2344: igs_ge_msg_stack.add;
2345: END IF;
2338: p_ret_status := 'W' ;
2339: fnd_message.set_name('IGF','IGF_AW_NO_PROG_LOC');
2340: fnd_message.set_token('PROG_CODE',p_program_code);
2341: fnd_message.set_token('PROG_LOC',p_program_location);
2342: fnd_message.set_token('ATTND_TYPE',p_attend_type);
2343: fnd_message.set_token('ATTND_MODE',p_attend_mode);
2344: igs_ge_msg_stack.add;
2345: END IF;
2346: CLOSE c_chk_prog_option;
2339: fnd_message.set_name('IGF','IGF_AW_NO_PROG_LOC');
2340: fnd_message.set_token('PROG_CODE',p_program_code);
2341: fnd_message.set_token('PROG_LOC',p_program_location);
2342: fnd_message.set_token('ATTND_TYPE',p_attend_type);
2343: fnd_message.set_token('ATTND_MODE',p_attend_mode);
2344: igs_ge_msg_stack.add;
2345: END IF;
2346: CLOSE c_chk_prog_option;
2347: END IF;