eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AW_COA_UPDATE dependencies on FND_MESSAGE

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

167: END IF;
168:
169: EXCEPTION
170: WHEN OTHERS THEN
171: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
172: fnd_message.set_token('NAME','igf_aw_coa_update.update_to_do_items :' || SQLERRM);
173: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
174: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_update.update_to_do_items.exception','sql error:'||SQLERRM);
175: END IF;

Line 172: fnd_message.set_token('NAME','igf_aw_coa_update.update_to_do_items :' || SQLERRM);

168:
169: EXCEPTION
170: WHEN OTHERS THEN
171: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
172: fnd_message.set_token('NAME','igf_aw_coa_update.update_to_do_items :' || SQLERRM);
173: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
174: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_update.update_to_do_items.exception','sql error:'||SQLERRM);
175: END IF;
176: igs_ge_msg_stack.conc_exception_hndl;

Line 334: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');

330:
331: ELSE
332:
333: IF l_rate_order.org_unit_cd IS NOT NULL AND p_base_details.org_unit_cd IS NULL THEN
334: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
335: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ORG_UNIT_CD'));
336: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
337: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
338:

Line 335: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ORG_UNIT_CD'));

331: ELSE
332:
333: IF l_rate_order.org_unit_cd IS NOT NULL AND p_base_details.org_unit_cd IS NULL THEN
334: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
335: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ORG_UNIT_CD'));
336: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
337: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
338:
339: l_counter := 2;

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

332:
333: IF l_rate_order.org_unit_cd IS NOT NULL AND p_base_details.org_unit_cd IS NULL THEN
334: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
335: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ORG_UNIT_CD'));
336: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
337: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
338:
339: l_counter := 2;
340: END IF;

Line 337: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

333: IF l_rate_order.org_unit_cd IS NOT NULL AND p_base_details.org_unit_cd IS NULL THEN
334: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
335: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ORG_UNIT_CD'));
336: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
337: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
338:
339: l_counter := 2;
340: END IF;
341:

Line 343: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');

339: l_counter := 2;
340: END IF;
341:
342: IF l_rate_order.program_type IS NOT NULL AND p_base_details.program_type IS NULL THEN
343: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
344: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_TYPE'));
345: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
346: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
347:

Line 344: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_TYPE'));

340: END IF;
341:
342: IF l_rate_order.program_type IS NOT NULL AND p_base_details.program_type IS NULL THEN
343: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
344: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_TYPE'));
345: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
346: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
347:
348: l_counter := 2;

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

341:
342: IF l_rate_order.program_type IS NOT NULL AND p_base_details.program_type IS NULL THEN
343: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
344: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_TYPE'));
345: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
346: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
347:
348: l_counter := 2;
349: END IF;

Line 346: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

342: IF l_rate_order.program_type IS NOT NULL AND p_base_details.program_type IS NULL THEN
343: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
344: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_TYPE'));
345: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
346: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
347:
348: l_counter := 2;
349: END IF;
350:

Line 352: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');

348: l_counter := 2;
349: END IF;
350:
351: IF l_rate_order.program_location_cd IS NOT NULL AND p_base_details.program_location_cd IS NULL THEN
352: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
353: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_LOCATION_CD'));
354: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
355: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
356:

Line 353: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_LOCATION_CD'));

349: END IF;
350:
351: IF l_rate_order.program_location_cd IS NOT NULL AND p_base_details.program_location_cd IS NULL THEN
352: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
353: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_LOCATION_CD'));
354: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
355: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
356:
357: l_counter := 2;

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

350:
351: IF l_rate_order.program_location_cd IS NOT NULL AND p_base_details.program_location_cd IS NULL THEN
352: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
353: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_LOCATION_CD'));
354: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
355: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
356:
357: l_counter := 2;
358: END IF;

Line 355: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

351: IF l_rate_order.program_location_cd IS NOT NULL AND p_base_details.program_location_cd IS NULL THEN
352: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
353: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_LOCATION_CD'));
354: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
355: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
356:
357: l_counter := 2;
358: END IF;
359:

Line 361: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');

357: l_counter := 2;
358: END IF;
359:
360: IF l_rate_order.program_cd IS NOT NULL AND p_base_details.program_cd IS NULL THEN
361: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
362: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_CD'));
363: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
364: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
365:

Line 362: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_CD'));

358: END IF;
359:
360: IF l_rate_order.program_cd IS NOT NULL AND p_base_details.program_cd IS NULL THEN
361: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
362: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_CD'));
363: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
364: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
365:
366: l_counter := 2;

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

359:
360: IF l_rate_order.program_cd IS NOT NULL AND p_base_details.program_cd IS NULL THEN
361: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
362: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_CD'));
363: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
364: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
365:
366: l_counter := 2;
367: END IF;

Line 364: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

360: IF l_rate_order.program_cd IS NOT NULL AND p_base_details.program_cd IS NULL THEN
361: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
362: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','PROGRAM_CD'));
363: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
364: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
365:
366: l_counter := 2;
367: END IF;
368:

Line 370: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');

366: l_counter := 2;
367: END IF;
368:
369: IF l_rate_order.class_standing IS NOT NULL AND p_base_details.class_standing IS NULL THEN
370: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
371: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','CLASS_STANDING'));
372: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
373: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
374:

Line 371: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','CLASS_STANDING'));

367: END IF;
368:
369: IF l_rate_order.class_standing IS NOT NULL AND p_base_details.class_standing IS NULL THEN
370: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
371: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','CLASS_STANDING'));
372: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
373: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
374:
375: l_counter := 2;

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

368:
369: IF l_rate_order.class_standing IS NOT NULL AND p_base_details.class_standing IS NULL THEN
370: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
371: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','CLASS_STANDING'));
372: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
373: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
374:
375: l_counter := 2;
376: END IF;

Line 373: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

369: IF l_rate_order.class_standing IS NOT NULL AND p_base_details.class_standing IS NULL THEN
370: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
371: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','CLASS_STANDING'));
372: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
373: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
374:
375: l_counter := 2;
376: END IF;
377:

Line 379: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');

375: l_counter := 2;
376: END IF;
377:
378: IF l_rate_order.residency_status_code IS NOT NULL AND p_base_details.residency_status_code IS NULL THEN
379: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
380: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','RESIDENCY_STATUS_CODE'));
381: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
382: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
383:

Line 380: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','RESIDENCY_STATUS_CODE'));

376: END IF;
377:
378: IF l_rate_order.residency_status_code IS NOT NULL AND p_base_details.residency_status_code IS NULL THEN
379: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
380: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','RESIDENCY_STATUS_CODE'));
381: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
382: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
383:
384: l_counter := 2;

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

377:
378: IF l_rate_order.residency_status_code IS NOT NULL AND p_base_details.residency_status_code IS NULL THEN
379: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
380: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','RESIDENCY_STATUS_CODE'));
381: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
382: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
383:
384: l_counter := 2;
385: END IF;

Line 382: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

378: IF l_rate_order.residency_status_code IS NOT NULL AND p_base_details.residency_status_code IS NULL THEN
379: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
380: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','RESIDENCY_STATUS_CODE'));
381: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
382: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
383:
384: l_counter := 2;
385: END IF;
386:

Line 388: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');

384: l_counter := 2;
385: END IF;
386:
387: IF l_rate_order.housing_status_code IS NOT NULL AND p_base_details.housing_status_code IS NULL THEN
388: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
389: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','HOUSING_STATUS_CODE'));
390: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
391: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
392:

Line 389: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','HOUSING_STATUS_CODE'));

385: END IF;
386:
387: IF l_rate_order.housing_status_code IS NOT NULL AND p_base_details.housing_status_code IS NULL THEN
388: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
389: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','HOUSING_STATUS_CODE'));
390: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
391: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
392:
393: l_counter := 2;

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

386:
387: IF l_rate_order.housing_status_code IS NOT NULL AND p_base_details.housing_status_code IS NULL THEN
388: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
389: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','HOUSING_STATUS_CODE'));
390: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
391: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
392:
393: l_counter := 2;
394: END IF;

Line 391: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

387: IF l_rate_order.housing_status_code IS NOT NULL AND p_base_details.housing_status_code IS NULL THEN
388: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
389: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','HOUSING_STATUS_CODE'));
390: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
391: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
392:
393: l_counter := 2;
394: END IF;
395:

Line 397: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');

393: l_counter := 2;
394: END IF;
395:
396: IF l_rate_order.attendance_type IS NOT NULL AND p_base_details.attendance_type IS NULL THEN
397: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
398: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_TYPE'));
399: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
400: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
401:

Line 398: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_TYPE'));

394: END IF;
395:
396: IF l_rate_order.attendance_type IS NOT NULL AND p_base_details.attendance_type IS NULL THEN
397: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
398: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_TYPE'));
399: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
400: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
401:
402: l_counter := 2;

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

395:
396: IF l_rate_order.attendance_type IS NOT NULL AND p_base_details.attendance_type IS NULL THEN
397: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
398: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_TYPE'));
399: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
400: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
401:
402: l_counter := 2;
403: END IF;

Line 400: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

396: IF l_rate_order.attendance_type IS NOT NULL AND p_base_details.attendance_type IS NULL THEN
397: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
398: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_TYPE'));
399: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
400: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
401:
402: l_counter := 2;
403: END IF;
404:

Line 406: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');

402: l_counter := 2;
403: END IF;
404:
405: IF l_rate_order.attendance_mode IS NOT NULL AND p_base_details.attendance_mode IS NULL THEN
406: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
407: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_MODE'));
408: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
409: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
410:

Line 407: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_MODE'));

403: END IF;
404:
405: IF l_rate_order.attendance_mode IS NOT NULL AND p_base_details.attendance_mode IS NULL THEN
406: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
407: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_MODE'));
408: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
409: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
410:
411: l_counter := 2;

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

404:
405: IF l_rate_order.attendance_mode IS NOT NULL AND p_base_details.attendance_mode IS NULL THEN
406: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
407: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_MODE'));
408: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
409: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
410:
411: l_counter := 2;
412: END IF;

Line 409: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

405: IF l_rate_order.attendance_mode IS NOT NULL AND p_base_details.attendance_mode IS NULL THEN
406: fnd_message.set_name('IGF','IGF_AW_STD_ATTRIB');
407: fnd_message.set_token('ATTRIBUTE',igf_aw_gen.lookup_desc('IGF_AW_COA_GEN','ATTENDANCE_MODE'));
408: fnd_message.set_token('TERM',igf_gr_gen.get_alt_code(p_ld_cal_type, p_ld_sequence_number));
409: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
410:
411: l_counter := 2;
412: END IF;
413:

Line 555: fnd_message.set_name('IGF','IGF_AW_STUD_SKIP');

551: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
552: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','base_id:'||p_base_id||' is locked');
553: END IF;
554:
555: fnd_message.set_name('IGF','IGF_AW_STUD_SKIP');
556: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
557: ELSE
558: FOR l_items IN c_items(p_base_id)
559: LOOP

Line 556: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

552: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','base_id:'||p_base_id||' is locked');
553: END IF;
554:
555: fnd_message.set_name('IGF','IGF_AW_STUD_SKIP');
556: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
557: ELSE
558: FOR l_items IN c_items(p_base_id)
559: LOOP
560: IF l_items.lock_flag = 'Y' THEN

Line 566: fnd_message.set_name('IGF','IGF_AW_SKP_LK_ITM');

562: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','l_items.item_code:'||l_items.item_code||' is locked');
564: END IF;
565:
566: fnd_message.set_name('IGF','IGF_AW_SKP_LK_ITM');
567: fnd_message.set_token('ITEM_CODE',l_items.item_code);
568: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
569:
570: ELSE

Line 567: fnd_message.set_token('ITEM_CODE',l_items.item_code);

563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','l_items.item_code:'||l_items.item_code||' is locked');
564: END IF;
565:
566: fnd_message.set_name('IGF','IGF_AW_SKP_LK_ITM');
567: fnd_message.set_token('ITEM_CODE',l_items.item_code);
568: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
569:
570: ELSE
571: --cursor to check whether the COA item exists in the rate based setup table or not

Line 568: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

564: END IF;
565:
566: fnd_message.set_name('IGF','IGF_AW_SKP_LK_ITM');
567: fnd_message.set_token('ITEM_CODE',l_items.item_code);
568: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
569:
570: ELSE
571: --cursor to check whether the COA item exists in the rate based setup table or not
572: OPEN c_rate_ord_exists(p_ci_cal_type, p_ci_sequence_number, l_items.item_code);

Line 577: fnd_message.set_name('IGF','IGF_AW_SKIP_NON_RATE');

573: FETCH c_rate_ord_exists INTO l_rate_ord_exists;
574: IF c_rate_ord_exists%NOTFOUND THEN
575: CLOSE c_rate_ord_exists;
576:
577: fnd_message.set_name('IGF','IGF_AW_SKIP_NON_RATE');
578: fnd_message.set_token('ITEM',l_items.item_code);
579: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
580:
581: ELSIF c_rate_ord_exists%FOUND THEN

Line 578: fnd_message.set_token('ITEM',l_items.item_code);

574: IF c_rate_ord_exists%NOTFOUND THEN
575: CLOSE c_rate_ord_exists;
576:
577: fnd_message.set_name('IGF','IGF_AW_SKIP_NON_RATE');
578: fnd_message.set_token('ITEM',l_items.item_code);
579: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
580:
581: ELSIF c_rate_ord_exists%FOUND THEN
582: CLOSE c_rate_ord_exists;

Line 579: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

575: CLOSE c_rate_ord_exists;
576:
577: fnd_message.set_name('IGF','IGF_AW_SKIP_NON_RATE');
578: fnd_message.set_token('ITEM',l_items.item_code);
579: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
580:
581: ELSIF c_rate_ord_exists%FOUND THEN
582: CLOSE c_rate_ord_exists;
583:

Line 592: fnd_message.set_name('IGF','IGF_AW_SKP_LK_TRM');

588: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','term:'||igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number)||' is locked');
590: END IF;
591:
592: fnd_message.set_name('IGF','IGF_AW_SKP_LK_TRM');
593: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
594: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
595: ELSE
596: --Execute the COA re-calculation logic

Line 593: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));

589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','term:'||igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number)||' is locked');
590: END IF;
591:
592: fnd_message.set_name('IGF','IGF_AW_SKP_LK_TRM');
593: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
594: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
595: ELSE
596: --Execute the COA re-calculation logic
597: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 594: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

590: END IF;
591:
592: fnd_message.set_name('IGF','IGF_AW_SKP_LK_TRM');
593: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
594: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
595: ELSE
596: --Execute the COA re-calculation logic
597: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','Fetching student attributes for base_id:'||p_base_id);

Line 616: fnd_message.set_name('IGF','IGF_AW_UPD_ITM');

612: ln_rate_order
613: ) THEN
614:
615: IF ln_amount <> l_terms.amount THEN
616: fnd_message.set_name('IGF','IGF_AW_UPD_ITM');
617: fnd_message.set_token('ITEM_CODE',l_items.item_code);
618: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
619: fnd_message.set_token('RATE_ORDER',ln_rate_order);
620: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

Line 617: fnd_message.set_token('ITEM_CODE',l_items.item_code);

613: ) THEN
614:
615: IF ln_amount <> l_terms.amount THEN
616: fnd_message.set_name('IGF','IGF_AW_UPD_ITM');
617: fnd_message.set_token('ITEM_CODE',l_items.item_code);
618: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
619: fnd_message.set_token('RATE_ORDER',ln_rate_order);
620: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
621:

Line 618: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));

614:
615: IF ln_amount <> l_terms.amount THEN
616: fnd_message.set_name('IGF','IGF_AW_UPD_ITM');
617: fnd_message.set_token('ITEM_CODE',l_items.item_code);
618: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
619: fnd_message.set_token('RATE_ORDER',ln_rate_order);
620: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
621:
622: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 619: fnd_message.set_token('RATE_ORDER',ln_rate_order);

615: IF ln_amount <> l_terms.amount THEN
616: fnd_message.set_name('IGF','IGF_AW_UPD_ITM');
617: fnd_message.set_token('ITEM_CODE',l_items.item_code);
618: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
619: fnd_message.set_token('RATE_ORDER',ln_rate_order);
620: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
621:
622: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
623: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','ln_amount <> l_terms.amount for base_id:'||p_base_id);

Line 620: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

616: fnd_message.set_name('IGF','IGF_AW_UPD_ITM');
617: fnd_message.set_token('ITEM_CODE',l_items.item_code);
618: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
619: fnd_message.set_token('RATE_ORDER',ln_rate_order);
620: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
621:
622: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
623: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','ln_amount <> l_terms.amount for base_id:'||p_base_id);
624: END IF;

Line 640: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');

636: lv_coa_itm_update := 'Y';
637: END IF;
638: ELSE
639: IF NVL(ln_rate_order,0) <> -1 THEN
640: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
641: fnd_message.set_token('ITEM_CODE',l_items.item_code);
642: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
643: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
644: END IF;

Line 641: fnd_message.set_token('ITEM_CODE',l_items.item_code);

637: END IF;
638: ELSE
639: IF NVL(ln_rate_order,0) <> -1 THEN
640: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
641: fnd_message.set_token('ITEM_CODE',l_items.item_code);
642: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
643: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
644: END IF;
645:

Line 642: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));

638: ELSE
639: IF NVL(ln_rate_order,0) <> -1 THEN
640: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
641: fnd_message.set_token('ITEM_CODE',l_items.item_code);
642: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
643: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
644: END IF;
645:
646: RAISE E_SKIP_STUDENT;

Line 643: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);

639: IF NVL(ln_rate_order,0) <> -1 THEN
640: fnd_message.set_name('IGF','IGF_AW_ITEM_SKIP');
641: fnd_message.set_token('ITEM_CODE',l_items.item_code);
642: fnd_message.set_token('TERM_CODE',igf_gr_gen.get_alt_code(l_terms.ld_cal_type,l_terms.ld_sequence_number));
643: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
644: END IF;
645:
646: RAISE E_SKIP_STUDENT;
647: END IF; -- End of IF is_attrib_matching()

Line 690: fnd_message.set_name('IGF','IGF_AW_RATE_NOT_AVAIL');

686:
687: EXCEPTION
688: WHEN E_SKIP_STUDENT THEN
689: ROLLBACK TO start_evaluate;
690: fnd_message.set_name('IGF','IGF_AW_RATE_NOT_AVAIL');
691: fnd_file.put_line(fnd_file.log,RPAD(' ',5)|| fnd_message.get());
692:
693: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
694: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_update.evaluate.exception','sql error message:'||SQLERRM);

Line 691: fnd_file.put_line(fnd_file.log,RPAD(' ',5)|| fnd_message.get());

687: EXCEPTION
688: WHEN E_SKIP_STUDENT THEN
689: ROLLBACK TO start_evaluate;
690: fnd_message.set_name('IGF','IGF_AW_RATE_NOT_AVAIL');
691: fnd_file.put_line(fnd_file.log,RPAD(' ',5)|| fnd_message.get());
692:
693: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
694: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_update.evaluate.exception','sql error message:'||SQLERRM);
695: END IF;

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

694: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_update.evaluate.exception','sql error message:'||SQLERRM);
695: END IF;
696:
697: WHEN OTHERS THEN
698: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
699: fnd_message.set_token('NAME','igf_aw_coa_update.evaluate :' || SQLERRM);
700: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
701: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_update.evaluate.exception','sql error:'||SQLERRM);
702: END IF;

Line 699: fnd_message.set_token('NAME','igf_aw_coa_update.evaluate :' || SQLERRM);

695: END IF;
696:
697: WHEN OTHERS THEN
698: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
699: fnd_message.set_token('NAME','igf_aw_coa_update.evaluate :' || SQLERRM);
700: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
701: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_update.evaluate.exception','sql error:'||SQLERRM);
702: END IF;
703: igs_ge_msg_stack.conc_exception_hndl;

Line 904: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_P');

900:
901: --If person selection is for all persons in the Person ID Group and
902: --Person ID Group is NULL then log error with exception
903: ELSIF p_run_type = 'P' AND p_pid_group IS NULL THEN
904: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_P');
905: fnd_file.put_line(fnd_file.log,fnd_message.get);
906: RAISE param_exception;
907:
908: --If person selection is for a single person and

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

901: --If person selection is for all persons in the Person ID Group and
902: --Person ID Group is NULL then log error with exception
903: ELSIF p_run_type = 'P' AND p_pid_group IS NULL THEN
904: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_P');
905: fnd_file.put_line(fnd_file.log,fnd_message.get);
906: RAISE param_exception;
907:
908: --If person selection is for a single person and
909: --Base ID is NULL then log error with exception

Line 911: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_S');

907:
908: --If person selection is for a single person and
909: --Base ID is NULL then log error with exception
910: ELSIF p_run_type = 'S' AND p_base_id IS NULL THEN
911: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_S');
912: fnd_file.put_line(fnd_file.log,fnd_message.get);
913: RAISE param_exception;
914:
915: END IF;

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

908: --If person selection is for a single person and
909: --Base ID is NULL then log error with exception
910: ELSIF p_run_type = 'S' AND p_base_id IS NULL THEN
911: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_S');
912: fnd_file.put_line(fnd_file.log,fnd_message.get);
913: RAISE param_exception;
914:
915: END IF;
916:

Line 924: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');

920: --COMPUTATION ONLY IF PERSON NUMBER IS PRESENT
921: IF p_run_type = 'S' AND (p_pid_group IS NULL) AND (p_base_id IS NOT NULL) THEN
922:
923: fnd_file.new_line(fnd_file.log,1);
924: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
925: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
926: fnd_file.put_line(fnd_file.log,fnd_message.get);
927:
928: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 925: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));

921: IF p_run_type = 'S' AND (p_pid_group IS NULL) AND (p_base_id IS NOT NULL) THEN
922:
923: fnd_file.new_line(fnd_file.log,1);
924: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
925: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
926: fnd_file.put_line(fnd_file.log,fnd_message.get);
927:
928: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
929: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=S with base_id:'||p_base_id);

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

922:
923: fnd_file.new_line(fnd_file.log,1);
924: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
925: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
926: fnd_file.put_line(fnd_file.log,fnd_message.get);
927:
928: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
929: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=S with base_id:'||p_base_id);
930: END IF;

Line 947: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');

943: ELSIF p_run_type = 'Y' AND (p_pid_group IS NULL) AND (p_base_id IS NULL) THEN
944: FOR l_per_awd_rec IN c_per_awd_yr(lv_ci_cal_type,ln_ci_sequence_number)
945: LOOP
946: fnd_file.new_line(fnd_file.log,1);
947: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
948: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));
949: fnd_file.put_line(fnd_file.log,fnd_message.get);
950:
951: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 948: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));

944: FOR l_per_awd_rec IN c_per_awd_yr(lv_ci_cal_type,ln_ci_sequence_number)
945: LOOP
946: fnd_file.new_line(fnd_file.log,1);
947: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
948: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));
949: fnd_file.put_line(fnd_file.log,fnd_message.get);
950:
951: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
952: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=Y with base_id:'||l_per_awd_rec.base_id);

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

945: LOOP
946: fnd_file.new_line(fnd_file.log,1);
947: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
948: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));
949: fnd_file.put_line(fnd_file.log,fnd_message.get);
950:
951: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
952: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=Y with base_id:'||l_per_awd_rec.base_id);
953: END IF;

Line 990: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');

986:
987: FETCH cur_per_grp INTO per_grp_rec;
988:
989: IF (cur_per_grp%NOTFOUND) THEN
990: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
991: fnd_file.put_line(fnd_file.log,fnd_message.get);
992: ELSE
993: LOOP
994: -- check if person has a fa base record

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

987: FETCH cur_per_grp INTO per_grp_rec;
988:
989: IF (cur_per_grp%NOTFOUND) THEN
990: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
991: fnd_file.put_line(fnd_file.log,fnd_message.get);
992: ELSE
993: LOOP
994: -- check if person has a fa base record
995: ln_base_id := NULL;

Line 1008: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');

1004: );
1005:
1006: IF lv_err_msg = 'NULL' THEN
1007: fnd_file.new_line(fnd_file.log,1);
1008: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1009: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
1010: fnd_file.put_line(fnd_file.log,fnd_message.get);
1011:
1012: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1009: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));

1005:
1006: IF lv_err_msg = 'NULL' THEN
1007: fnd_file.new_line(fnd_file.log,1);
1008: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1009: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
1010: fnd_file.put_line(fnd_file.log,fnd_message.get);
1011:
1012: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1013: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=P with base_id:'||ln_base_id);

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

1006: IF lv_err_msg = 'NULL' THEN
1007: fnd_file.new_line(fnd_file.log,1);
1008: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1009: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
1010: fnd_file.put_line(fnd_file.log,fnd_message.get);
1011:
1012: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1013: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=P with base_id:'||ln_base_id);
1014: END IF;

Line 1031: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');

1027: OPEN c_person_no(per_grp_rec.person_id);
1028: FETCH c_person_no INTO l_person_no;
1029: CLOSE c_person_no;
1030:
1031: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
1032: fnd_message.set_token('STUD',l_person_no.party_number);
1033: fnd_file.new_line(fnd_file.log,1);
1034: fnd_file.put_line(fnd_file.log,fnd_message.get);
1035: END IF;

Line 1032: fnd_message.set_token('STUD',l_person_no.party_number);

1028: FETCH c_person_no INTO l_person_no;
1029: CLOSE c_person_no;
1030:
1031: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
1032: fnd_message.set_token('STUD',l_person_no.party_number);
1033: fnd_file.new_line(fnd_file.log,1);
1034: fnd_file.put_line(fnd_file.log,fnd_message.get);
1035: END IF;
1036:

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

1030:
1031: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
1032: fnd_message.set_token('STUD',l_person_no.party_number);
1033: fnd_file.new_line(fnd_file.log,1);
1034: fnd_file.put_line(fnd_file.log,fnd_message.get);
1035: END IF;
1036:
1037: FETCH cur_per_grp INTO per_grp_rec;
1038: EXIT WHEN cur_per_grp%NOTFOUND;

Line 1064: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');

1060: );
1061:
1062: IF lv_err_msg = 'NULL' THEN
1063: fnd_file.new_line(fnd_file.log,1);
1064: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1065: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
1066: fnd_file.put_line(fnd_file.log,fnd_message.get);
1067:
1068: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1065: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));

1061:
1062: IF lv_err_msg = 'NULL' THEN
1063: fnd_file.new_line(fnd_file.log,1);
1064: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1065: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
1066: fnd_file.put_line(fnd_file.log,fnd_message.get);
1067:
1068: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1069: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=A with base_id:'||ln_base_id);

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

1062: IF lv_err_msg = 'NULL' THEN
1063: fnd_file.new_line(fnd_file.log,1);
1064: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1065: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
1066: fnd_file.put_line(fnd_file.log,fnd_message.get);
1067:
1068: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1069: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Starting Run_Type=A with base_id:'||ln_base_id);
1070: END IF;

Line 1128: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');

1124: OPEN c_person_no(l_person_id.person_id);
1125: FETCH c_person_no INTO l_person_no;
1126: CLOSE c_person_no;
1127:
1128: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
1129: fnd_message.set_token('STUD',l_person_no.party_number);
1130: fnd_file.new_line(fnd_file.log,1);
1131: fnd_file.put_line(fnd_file.log,fnd_message.get);
1132: END IF;

Line 1129: fnd_message.set_token('STUD',l_person_no.party_number);

1125: FETCH c_person_no INTO l_person_no;
1126: CLOSE c_person_no;
1127:
1128: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
1129: fnd_message.set_token('STUD',l_person_no.party_number);
1130: fnd_file.new_line(fnd_file.log,1);
1131: fnd_file.put_line(fnd_file.log,fnd_message.get);
1132: END IF;
1133:

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

1127:
1128: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
1129: fnd_message.set_token('STUD',l_person_no.party_number);
1130: fnd_file.new_line(fnd_file.log,1);
1131: fnd_file.put_line(fnd_file.log,fnd_message.get);
1132: END IF;
1133:
1134: END LOOP;
1135:

Line 1147: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');

1143:
1144: EXCEPTION
1145: WHEN param_exception THEN
1146: retcode:=2;
1147: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');
1148: igs_ge_msg_stack.add;
1149: errbuf := fnd_message.get;
1150:
1151: WHEN app_exception.record_lock_exception THEN

Line 1149: errbuf := fnd_message.get;

1145: WHEN param_exception THEN
1146: retcode:=2;
1147: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');
1148: igs_ge_msg_stack.add;
1149: errbuf := fnd_message.get;
1150:
1151: WHEN app_exception.record_lock_exception THEN
1152: ROLLBACK;
1153: retcode:=2;

Line 1154: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');

1150:
1151: WHEN app_exception.record_lock_exception THEN
1152: ROLLBACK;
1153: retcode:=2;
1154: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
1155: igs_ge_msg_stack.add;
1156: errbuf := fnd_message.get;
1157:
1158: WHEN OTHERS THEN

Line 1156: errbuf := fnd_message.get;

1152: ROLLBACK;
1153: retcode:=2;
1154: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
1155: igs_ge_msg_stack.add;
1156: errbuf := fnd_message.get;
1157:
1158: WHEN OTHERS THEN
1159: ROLLBACK;
1160: retcode:=2;

Line 1161: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

1157:
1158: WHEN OTHERS THEN
1159: ROLLBACK;
1160: retcode:=2;
1161: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1162: igs_ge_msg_stack.add;
1163: errbuf := fnd_message.get || SQLERRM;
1164: END main;
1165:

Line 1163: errbuf := fnd_message.get || SQLERRM;

1159: ROLLBACK;
1160: retcode:=2;
1161: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1162: igs_ge_msg_stack.add;
1163: errbuf := fnd_message.get || SQLERRM;
1164: END main;
1165:
1166: END igf_aw_coa_update;