DBA Data[Home] [Help]

APPS.IGF_AP_ISIR_GEN_PKG dependencies on FND_MESSAGE

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

48: );
49:
50: EXCEPTION
51: WHEN OTHERS THEN
52: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
53: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.attach_isir');
54: cp_message_out:= fnd_message.get;
55: END attach_isir;
56:

Line 53: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.attach_isir');

49:
50: EXCEPTION
51: WHEN OTHERS THEN
52: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
53: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.attach_isir');
54: cp_message_out:= fnd_message.get;
55: END attach_isir;
56:
57: FUNCTION can_unlock_isir(

Line 54: cp_message_out:= fnd_message.get;

50: EXCEPTION
51: WHEN OTHERS THEN
52: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
53: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.attach_isir');
54: cp_message_out:= fnd_message.get;
55: END attach_isir;
56:
57: FUNCTION can_unlock_isir(
58: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

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

137: WHEN OTHERS THEN
138: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
139: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.can_unlock_isir.exception','The exception is : ' || SQLERRM );
140: END IF;
141: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
142: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.can_unlock_isir');
143: fnd_file.put_line(fnd_file.log,fnd_message.get);
144: igs_ge_msg_stack.add;
145: RETURN 'N';

Line 142: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.can_unlock_isir');

138: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
139: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.can_unlock_isir.exception','The exception is : ' || SQLERRM );
140: END IF;
141: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
142: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.can_unlock_isir');
143: fnd_file.put_line(fnd_file.log,fnd_message.get);
144: igs_ge_msg_stack.add;
145: RETURN 'N';
146:

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

139: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.can_unlock_isir.exception','The exception is : ' || SQLERRM );
140: END IF;
141: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
142: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.can_unlock_isir');
143: fnd_file.put_line(fnd_file.log,fnd_message.get);
144: igs_ge_msg_stack.add;
145: RETURN 'N';
146:
147: END can_unlock_isir;

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

379: WHEN OTHERS THEN
380: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
381: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.is_awarding_pymnt_isir_exists.exception','The exception is : ' || SQLERRM );
382: END IF;
383: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
384: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.is_awarding_pymnt_isir_exists');
385: fnd_file.put_line(fnd_file.log,fnd_message.get);
386: igs_ge_msg_stack.add;
387: RETURN 'N';

Line 384: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.is_awarding_pymnt_isir_exists');

380: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
381: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.is_awarding_pymnt_isir_exists.exception','The exception is : ' || SQLERRM );
382: END IF;
383: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
384: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.is_awarding_pymnt_isir_exists');
385: fnd_file.put_line(fnd_file.log,fnd_message.get);
386: igs_ge_msg_stack.add;
387: RETURN 'N';
388:

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

381: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.is_awarding_pymnt_isir_exists.exception','The exception is : ' || SQLERRM );
382: END IF;
383: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
384: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.is_awarding_pymnt_isir_exists');
385: fnd_file.put_line(fnd_file.log,fnd_message.get);
386: igs_ge_msg_stack.add;
387: RETURN 'N';
388:
389: END is_awarding_pymnt_isir_exists;

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

446: WHEN OTHERS THEN
447: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
448: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.are_corrections_exists.exception','The exception is : ' || SQLERRM );
449: END IF;
450: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
451: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.are_corrections_exists');
452: fnd_file.put_line(fnd_file.log,fnd_message.get);
453: igs_ge_msg_stack.add;
454: RETURN 'N';

Line 451: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.are_corrections_exists');

447: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
448: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.are_corrections_exists.exception','The exception is : ' || SQLERRM );
449: END IF;
450: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
451: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.are_corrections_exists');
452: fnd_file.put_line(fnd_file.log,fnd_message.get);
453: igs_ge_msg_stack.add;
454: RETURN 'N';
455:

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

448: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.are_corrections_exists.exception','The exception is : ' || SQLERRM );
449: END IF;
450: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
451: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.are_corrections_exists');
452: fnd_file.put_line(fnd_file.log,fnd_message.get);
453: igs_ge_msg_stack.add;
454: RETURN 'N';
455:
456: END are_corrections_exists;

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

555:
556: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
557: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.delete_isir.exception','The exception is : ' || SQLERRM );
558: END IF;
559: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
560: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_isir');
561:
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: l_err_msg := fnd_message.get||SQLERRM;

Line 560: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_isir');

556: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
557: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.delete_isir.exception','The exception is : ' || SQLERRM );
558: END IF;
559: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
560: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_isir');
561:
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: l_err_msg := fnd_message.get||SQLERRM;
564: fnd_msg_pub.count_and_get(

Line 563: l_err_msg := fnd_message.get||SQLERRM;

559: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
560: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_isir');
561:
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: l_err_msg := fnd_message.get||SQLERRM;
564: fnd_msg_pub.count_and_get(
565: p_encoded => fnd_api.g_false,
566: p_count => x_msg_count,
567: p_data => l_err_msg --x_msg_data

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

1870:
1871: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1872: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.delete_isir.exception','The exception is : ' || SQLERRM );
1873: END IF;
1874: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1875: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_isir');
1876:
1877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1878: l_err_msg := fnd_message.get||SQLERRM;

Line 1875: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_isir');

1871: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1872: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.delete_isir.exception','The exception is : ' || SQLERRM );
1873: END IF;
1874: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1875: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_isir');
1876:
1877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1878: l_err_msg := fnd_message.get||SQLERRM;
1879: fnd_msg_pub.count_and_get(

Line 1878: l_err_msg := fnd_message.get||SQLERRM;

1874: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1875: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_isir');
1876:
1877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1878: l_err_msg := fnd_message.get||SQLERRM;
1879: fnd_msg_pub.count_and_get(
1880: p_encoded => fnd_api.g_false,
1881: p_count => x_msg_count,
1882: p_data => l_err_msg --x_msg_data

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

1946: WHEN OTHERS THEN
1947: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1948: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.delete_person_match.exception','The exception is : ' || SQLERRM );
1949: END IF;
1950: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1951: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_person_match');
1952: fnd_file.put_line(fnd_file.log,fnd_message.get);
1953: igs_ge_msg_stack.add;
1954: END delete_person_match;

Line 1951: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_person_match');

1947: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1948: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.delete_person_match.exception','The exception is : ' || SQLERRM );
1949: END IF;
1950: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1951: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_person_match');
1952: fnd_file.put_line(fnd_file.log,fnd_message.get);
1953: igs_ge_msg_stack.add;
1954: END delete_person_match;
1955:

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

1948: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.delete_person_match.exception','The exception is : ' || SQLERRM );
1949: END IF;
1950: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1951: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_person_match');
1952: fnd_file.put_line(fnd_file.log,fnd_message.get);
1953: igs_ge_msg_stack.add;
1954: END delete_person_match;
1955:
1956:

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

2011: WHEN OTHERS THEN
2012: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2013: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.delete_interface_person_match.exception','The exception is : ' || SQLERRM );
2014: END IF;
2015: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2016: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_interface_person_match');
2017: fnd_file.put_line(fnd_file.log,fnd_message.get);
2018: igs_ge_msg_stack.add;
2019: lv_status := 'E';

Line 2016: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_interface_person_match');

2012: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2013: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.delete_interface_person_match.exception','The exception is : ' || SQLERRM );
2014: END IF;
2015: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2016: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_interface_person_match');
2017: fnd_file.put_line(fnd_file.log,fnd_message.get);
2018: igs_ge_msg_stack.add;
2019: lv_status := 'E';
2020: END delete_interface_record;

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

2013: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.delete_interface_person_match.exception','The exception is : ' || SQLERRM );
2014: END IF;
2015: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2016: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.delete_interface_person_match');
2017: fnd_file.put_line(fnd_file.log,fnd_message.get);
2018: igs_ge_msg_stack.add;
2019: lv_status := 'E';
2020: END delete_interface_record;
2021:

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

2175: WHEN OTHERS THEN
2176: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2177: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.is_awards_exists.exception','The exception is : ' || SQLERRM );
2178: END IF;
2179: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2180: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.is_awards_exists');
2181: fnd_file.put_line(fnd_file.log,fnd_message.get);
2182: igs_ge_msg_stack.add;
2183: RETURN 'N';

Line 2180: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.is_awards_exists');

2176: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2177: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.is_awards_exists.exception','The exception is : ' || SQLERRM );
2178: END IF;
2179: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2180: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.is_awards_exists');
2181: fnd_file.put_line(fnd_file.log,fnd_message.get);
2182: igs_ge_msg_stack.add;
2183: RETURN 'N';
2184: END is_awards_exists;

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

2177: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.is_awards_exists.exception','The exception is : ' || SQLERRM );
2178: END IF;
2179: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2180: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.is_awards_exists');
2181: fnd_file.put_line(fnd_file.log,fnd_message.get);
2182: igs_ge_msg_stack.add;
2183: RETURN 'N';
2184: END is_awards_exists;
2185:

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

2252: WHEN OTHERS THEN
2253: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2254: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.chk_pell_orig.exception','The exception is : ' || SQLERRM );
2255: END IF;
2256: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2257: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.chk_pell_orig');
2258: fnd_file.put_line(fnd_file.log,fnd_message.get);
2259: igs_ge_msg_stack.add;
2260: RETURN 'N';

Line 2257: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.chk_pell_orig');

2253: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2254: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.chk_pell_orig.exception','The exception is : ' || SQLERRM );
2255: END IF;
2256: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2257: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.chk_pell_orig');
2258: fnd_file.put_line(fnd_file.log,fnd_message.get);
2259: igs_ge_msg_stack.add;
2260: RETURN 'N';
2261: END chk_pell_orig;

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

2254: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.chk_pell_orig.exception','The exception is : ' || SQLERRM );
2255: END IF;
2256: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2257: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.chk_pell_orig');
2258: fnd_file.put_line(fnd_file.log,fnd_message.get);
2259: igs_ge_msg_stack.add;
2260: RETURN 'N';
2261: END chk_pell_orig;
2262:

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

2325: WHEN OTHERS THEN
2326: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2327: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.make_awarding_isir.exception','The exception is : ' || SQLERRM );
2328: END IF;
2329: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2330: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.make_awarding_isir');
2331: fnd_file.put_line(fnd_file.log,fnd_message.get);
2332: igs_ge_msg_stack.add;
2333: RETURN 'N';

Line 2330: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.make_awarding_isir');

2326: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2327: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.make_awarding_isir.exception','The exception is : ' || SQLERRM );
2328: END IF;
2329: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2330: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.make_awarding_isir');
2331: fnd_file.put_line(fnd_file.log,fnd_message.get);
2332: igs_ge_msg_stack.add;
2333: RETURN 'N';
2334: END make_awarding_isir;

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

2327: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.make_awarding_isir.exception','The exception is : ' || SQLERRM );
2328: END IF;
2329: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2330: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.make_awarding_isir');
2331: fnd_file.put_line(fnd_file.log,fnd_message.get);
2332: igs_ge_msg_stack.add;
2333: RETURN 'N';
2334: END make_awarding_isir;
2335:

Line 2521: fnd_message.set_name('IGF','IGF_AW_ATTEND_TYPE_NOT_DEF');

2517: lc_attendance_type := NULL;
2518: OPEN c_attendance_type(new_active_isir.batch_year, new_active_isir.summ_enrl_status);
2519: FETCH c_attendance_type INTO lc_attendance_type;
2520: IF c_attendance_type%NOTFOUND THEN
2521: fnd_message.set_name('IGF','IGF_AW_ATTEND_TYPE_NOT_DEF');
2522: fnd_message.set_token('STATUS',new_active_isir.summ_enrl_status);
2523: fnd_file.put_line(fnd_file.log,fnd_message.get);
2524: END IF;
2525: CLOSE c_attendance_type;

Line 2522: fnd_message.set_token('STATUS',new_active_isir.summ_enrl_status);

2518: OPEN c_attendance_type(new_active_isir.batch_year, new_active_isir.summ_enrl_status);
2519: FETCH c_attendance_type INTO lc_attendance_type;
2520: IF c_attendance_type%NOTFOUND THEN
2521: fnd_message.set_name('IGF','IGF_AW_ATTEND_TYPE_NOT_DEF');
2522: fnd_message.set_token('STATUS',new_active_isir.summ_enrl_status);
2523: fnd_file.put_line(fnd_file.log,fnd_message.get);
2524: END IF;
2525: CLOSE c_attendance_type;
2526:

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

2519: FETCH c_attendance_type INTO lc_attendance_type;
2520: IF c_attendance_type%NOTFOUND THEN
2521: fnd_message.set_name('IGF','IGF_AW_ATTEND_TYPE_NOT_DEF');
2522: fnd_message.set_token('STATUS',new_active_isir.summ_enrl_status);
2523: fnd_file.put_line(fnd_file.log,fnd_message.get);
2524: END IF;
2525: CLOSE c_attendance_type;
2526:
2527: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2536: fnd_message.set_name('IGF','IGF_AW_CLASS_STANDING_NOT_DEF');

2532: lc_class_standing := NULL;
2533: OPEN c_class_standing(new_active_isir.grade_level_in_college);
2534: FETCH c_class_standing INTO lc_class_standing;
2535: IF c_class_standing%NOTFOUND THEN
2536: fnd_message.set_name('IGF','IGF_AW_CLASS_STANDING_NOT_DEF');
2537: fnd_message.set_token('GD_LEVEL',new_active_isir.grade_level_in_college);
2538: fnd_file.put_line(fnd_file.log,fnd_message.get);
2539: END IF;
2540: CLOSE c_class_standing;

Line 2537: fnd_message.set_token('GD_LEVEL',new_active_isir.grade_level_in_college);

2533: OPEN c_class_standing(new_active_isir.grade_level_in_college);
2534: FETCH c_class_standing INTO lc_class_standing;
2535: IF c_class_standing%NOTFOUND THEN
2536: fnd_message.set_name('IGF','IGF_AW_CLASS_STANDING_NOT_DEF');
2537: fnd_message.set_token('GD_LEVEL',new_active_isir.grade_level_in_college);
2538: fnd_file.put_line(fnd_file.log,fnd_message.get);
2539: END IF;
2540: CLOSE c_class_standing;
2541:

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

2534: FETCH c_class_standing INTO lc_class_standing;
2535: IF c_class_standing%NOTFOUND THEN
2536: fnd_message.set_name('IGF','IGF_AW_CLASS_STANDING_NOT_DEF');
2537: fnd_message.set_token('GD_LEVEL',new_active_isir.grade_level_in_college);
2538: fnd_file.put_line(fnd_file.log,fnd_message.get);
2539: END IF;
2540: CLOSE c_class_standing;
2541:
2542: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2562: fnd_message.set_name('IGF','IGF_AW_ATTEND_MODE_NOT_DEF');

2558: FETCH c_attendance_mode INTO lc_attendance_mode;
2559: IF c_attendance_mode%FOUND THEN
2560: lc_ant_data.housing_status_code := lc_attendance_mode.housing_stat_code;
2561: ELSE
2562: fnd_message.set_name('IGF','IGF_AW_ATTEND_MODE_NOT_DEF');
2563: fnd_message.set_token('H_PLAN',new_active_isir.fedral_schl_code_indicator);
2564: fnd_file.put_line(fnd_file.log,fnd_message.get);
2565: END IF;
2566: CLOSE c_attendance_mode;

Line 2563: fnd_message.set_token('H_PLAN',new_active_isir.fedral_schl_code_indicator);

2559: IF c_attendance_mode%FOUND THEN
2560: lc_ant_data.housing_status_code := lc_attendance_mode.housing_stat_code;
2561: ELSE
2562: fnd_message.set_name('IGF','IGF_AW_ATTEND_MODE_NOT_DEF');
2563: fnd_message.set_token('H_PLAN',new_active_isir.fedral_schl_code_indicator);
2564: fnd_file.put_line(fnd_file.log,fnd_message.get);
2565: END IF;
2566: CLOSE c_attendance_mode;
2567:

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

2560: lc_ant_data.housing_status_code := lc_attendance_mode.housing_stat_code;
2561: ELSE
2562: fnd_message.set_name('IGF','IGF_AW_ATTEND_MODE_NOT_DEF');
2563: fnd_message.set_token('H_PLAN',new_active_isir.fedral_schl_code_indicator);
2564: fnd_file.put_line(fnd_file.log,fnd_message.get);
2565: END IF;
2566: CLOSE c_attendance_mode;
2567:
2568: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 2617: fnd_message.set_name('IGF','IGF_AW_ANTICIP_DATA_UPDATED');

2613: );
2614: END LOOP;
2615:
2616: p_anticip_status := 'SUCCESS';
2617: fnd_message.set_name('IGF','IGF_AW_ANTICIP_DATA_UPDATED');
2618: fnd_file.put_line(fnd_file.log,fnd_message.get);
2619:
2620: END IF;
2621:

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

2614: END LOOP;
2615:
2616: p_anticip_status := 'SUCCESS';
2617: fnd_message.set_name('IGF','IGF_AW_ANTICIP_DATA_UPDATED');
2618: fnd_file.put_line(fnd_file.log,fnd_message.get);
2619:
2620: END IF;
2621:
2622: ELSE

Line 2668: fnd_message.set_name('IGF','IGF_AW_AWD_PRC_STATUS_CHNGED');

2664: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_gen_pkg.upd_anticip_data_awd_prc_status.debug','after updating Awd process status : '||p_awd_prc_status);
2665: END IF;
2666:
2667: IF p_awd_prc_status IS NOT NULL THEN
2668: fnd_message.set_name('IGF','IGF_AW_AWD_PRC_STATUS_CHNGED');
2669: fnd_message.set_token('STATUS',igf_aw_gen.lookup_desc('IGF_AW_AWD_PROC_STAT',p_awd_prc_status));
2670: fnd_file.put_line(fnd_file.log,fnd_message.get);
2671: END IF;
2672:

Line 2669: fnd_message.set_token('STATUS',igf_aw_gen.lookup_desc('IGF_AW_AWD_PROC_STAT',p_awd_prc_status));

2665: END IF;
2666:
2667: IF p_awd_prc_status IS NOT NULL THEN
2668: fnd_message.set_name('IGF','IGF_AW_AWD_PRC_STATUS_CHNGED');
2669: fnd_message.set_token('STATUS',igf_aw_gen.lookup_desc('IGF_AW_AWD_PROC_STAT',p_awd_prc_status));
2670: fnd_file.put_line(fnd_file.log,fnd_message.get);
2671: END IF;
2672:
2673: END IF;

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

2666:
2667: IF p_awd_prc_status IS NOT NULL THEN
2668: fnd_message.set_name('IGF','IGF_AW_AWD_PRC_STATUS_CHNGED');
2669: fnd_message.set_token('STATUS',igf_aw_gen.lookup_desc('IGF_AW_AWD_PROC_STAT',p_awd_prc_status));
2670: fnd_file.put_line(fnd_file.log,fnd_message.get);
2671: END IF;
2672:
2673: END IF;
2674: END IF;

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

2685: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_isir_gen_pkg.upd_anticip_data_awd_prc_status.exception','The exception is : ' || SQLERRM );
2686: END IF;
2687: p_anticip_status := 'ERROR';
2688: p_awd_prc_status := 'ERROR';
2689: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2690: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.upd_anticip_data_awd_prc_status'||SQLERRM);
2691: fnd_file.put_line(fnd_file.log,fnd_message.get);
2692: igs_ge_msg_stack.add;
2693: END upd_ant_data_awd_prc_status;

Line 2690: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.upd_anticip_data_awd_prc_status'||SQLERRM);

2686: END IF;
2687: p_anticip_status := 'ERROR';
2688: p_awd_prc_status := 'ERROR';
2689: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2690: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.upd_anticip_data_awd_prc_status'||SQLERRM);
2691: fnd_file.put_line(fnd_file.log,fnd_message.get);
2692: igs_ge_msg_stack.add;
2693: END upd_ant_data_awd_prc_status;
2694:

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

2687: p_anticip_status := 'ERROR';
2688: p_awd_prc_status := 'ERROR';
2689: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2690: fnd_message.set_token('NAME','igf_ap_isir_gen_pkg.upd_anticip_data_awd_prc_status'||SQLERRM);
2691: fnd_file.put_line(fnd_file.log,fnd_message.get);
2692: igs_ge_msg_stack.add;
2693: END upd_ant_data_awd_prc_status;
2694:
2695: END igf_ap_isir_gen_pkg;