DBA Data[Home] [Help]

APPS.IGF_AW_COA_GEN dependencies on FND_MESSAGE

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

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:

Line 106: fnd_message.set_token('NAME','IGF_AW_COA_GEN.COA_AMOUNT ' || SQLERRM);

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;

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

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:

Line 190: fnd_message.set_token('NAME','IGF_AW_COA_GEN.AWARD_AMOUNT ' || SQLERRM);

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;

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

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:

Line 333: fnd_message.set_token('NAME','IGF_AW_COA_GEN.ISCOALOCKED ' || SQLERRM);

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;

Line 508: fnd_message.set_name('IGF','IGF_AW_ITM_TRM_LOCK');

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:

Line 509: fnd_message.set_token('ITEM',p_item_code);

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:

Line 510: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type,p_ld_sequence_number));

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(

Line 511: fnd_file.put_line(fnd_file.log,RPAD(' ',8)||fnd_message.get);

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,

Line 574: fnd_message.set_name('IGF','IGF_AW_BUDGET_LOCK');

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(

Line 575: fnd_file.put_line(fnd_file.log,RPAD(' ',4)||fnd_message.get);

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,

Line 729: fnd_message.set_name('IGF','IGF_AW_ITM_TRM_UNLOCK');

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:

Line 730: fnd_message.set_token('ITEM',p_item_code);

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:

Line 731: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type,p_ld_sequence_number));

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(

Line 732: fnd_file.put_line(fnd_file.log,RPAD(' ',4)||fnd_message.get);

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,

Line 807: fnd_message.set_name('IGF','IGF_AW_BUDGET_UNLOCK');

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(

Line 808: fnd_file.put_line(fnd_file.log,RPAD(' ',8)||fnd_message.get);

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,

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

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:

Line 986: fnd_message.set_token('NAME','IGF_AW_COA_GEN.DOLOCK ' || SQLERRM);

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;

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

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:

Line 1038: fnd_message.set_token('NAME','IGF_AW_COA_GEN.DOUNLOCK ' || SQLERRM);

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;

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

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;

Line 1825: fnd_message.set_token('NAME','IGF_AW_COA_GEN.GETBASEDETAILS ' || SQLERRM);

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:

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

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:

Line 1948: fnd_message.set_token('NAME','IGF_AW_COA_GEN.INS_COA_TODO ' || SQLERRM);

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;

Line 2284: fnd_message.set_name('IGF','IGF_AW_NOT_RESP_ORG_UNIT');

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;

Line 2285: fnd_message.set_token('ORG_UNIT',p_org_unit_code);

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;

Line 2286: fnd_message.set_token('PROG_CODE',p_program_code);

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;

Line 2302: fnd_message.set_name('IGF','IGF_AW_PROG_NOT_OF_TYPE');

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;

Line 2303: fnd_message.set_token('PROG_CODE',p_program_code);

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;

Line 2304: fnd_message.set_token('PROG_TYPE',p_program_type);

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;

Line 2320: fnd_message.set_name('IGF','IGF_AW_PRG_NT_OFFER');

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;

Line 2321: fnd_message.set_token('PROG_CODE',p_program_code);

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;

Line 2322: fnd_message.set_token('PROG_LOC',p_program_location);

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;

Line 2339: fnd_message.set_name('IGF','IGF_AW_NO_PROG_LOC');

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);

Line 2340: fnd_message.set_token('PROG_CODE',p_program_code);

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;

Line 2341: fnd_message.set_token('PROG_LOC',p_program_location);

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;

Line 2342: fnd_message.set_token('ATTND_TYPE',p_attend_type);

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;

Line 2343: fnd_message.set_token('ATTND_MODE',p_attend_mode);

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;