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_LOG

Line 124: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

120: --If To Do
121: IF l_person_dtls.person_id IS NOT NULL THEN
122: FOR l_person_ref IN c_person_ref(p_ci_cal_type,p_ci_sequence_number,l_person_dtls.person_id,l_person_dtls.s_student_todo_type,l_person_dtls.sequence_number)
123: LOOP
124: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
125: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.update_to_do_items.debug','Updating table igs_pe_std_todo for person id: '||l_person_dtls.person_id);
126: END IF;
127:
128: igs_pe_std_todo_ref_pkg.update_row(

Line 125: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.update_to_do_items.debug','Updating table igs_pe_std_todo for person id: '||l_person_dtls.person_id);

121: IF l_person_dtls.person_id IS NOT NULL THEN
122: FOR l_person_ref IN c_person_ref(p_ci_cal_type,p_ci_sequence_number,l_person_dtls.person_id,l_person_dtls.s_student_todo_type,l_person_dtls.sequence_number)
123: LOOP
124: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
125: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.update_to_do_items.debug','Updating table igs_pe_std_todo for person id: '||l_person_dtls.person_id);
126: END IF;
127:
128: igs_pe_std_todo_ref_pkg.update_row(
129: x_rowid => l_person_ref.row_id,

Line 150: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

146: FETCH c_person_todo INTO l_person_todo;
147:
148: IF c_person_todo%FOUND THEN
149:
150: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.update_to_do_items.debug','c_person_todo%FOUND');
152: END IF;
153:
154: igs_pe_std_todo_pkg.update_row(

Line 151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.update_to_do_items.debug','c_person_todo%FOUND');

147:
148: IF c_person_todo%FOUND THEN
149:
150: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
151: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.update_to_do_items.debug','c_person_todo%FOUND');
152: END IF;
153:
154: igs_pe_std_todo_pkg.update_row(
155: x_rowid => l_person_todo.row_id,

Line 173: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

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;
177: app_exception.raise_exception;

Line 174: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_update.update_to_do_items.exception','sql error:'||SQLERRM);

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;
177: app_exception.raise_exception;
178:

Line 245: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

241:
242: BEGIN
243: l_counter := 0;
244:
245: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
246: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','OPEN c_rate_order');
247: END IF;
248:
249: OPEN c_rate_order(p_ci_cal_type,p_ci_sequence_number,p_item_code);

Line 246: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','OPEN c_rate_order');

242: BEGIN
243: l_counter := 0;
244:
245: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
246: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','OPEN c_rate_order');
247: END IF;
248:
249: OPEN c_rate_order(p_ci_cal_type,p_ci_sequence_number,p_item_code);
250: FETCH c_rate_order INTO l_rate_order;

Line 272: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

268: AND (NVL(l_rate_order.ld_sequence_number,p_ld_sequence_number) = p_ld_sequence_number)
269: )
270: THEN
271:
272: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
273: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','inside if condition');
274: END IF;
275:
276: IF l_rate_order.pid_group_cd IS NOT NULL THEN

Line 273: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','inside if condition');

269: )
270: THEN
271:
272: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
273: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','inside if condition');
274: END IF;
275:
276: IF l_rate_order.pid_group_cd IS NOT NULL THEN
277: OPEN c_grp_id(l_rate_order.pid_group_cd);

Line 302: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

298:
299: FETCH c_chk_per_exist INTO lv_chk_per_exist;
300:
301: IF c_chk_per_exist%NOTFOUND THEN
302: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
303: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','c_chk_per_exist%NOTFOUND');
304: END IF;
305:
306: ELSE

Line 303: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','c_chk_per_exist%NOTFOUND');

299: FETCH c_chk_per_exist INTO lv_chk_per_exist;
300:
301: IF c_chk_per_exist%NOTFOUND THEN
302: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
303: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','c_chk_per_exist%NOTFOUND');
304: END IF;
305:
306: ELSE
307: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 307: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

303: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','c_chk_per_exist%NOTFOUND');
304: END IF;
305:
306: ELSE
307: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
308: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','person found in the person group id');
309: END IF;
310:
311: l_counter := 1;

Line 308: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','person found in the person group id');

304: END IF;
305:
306: ELSE
307: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
308: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','person found in the person group id');
309: END IF;
310:
311: l_counter := 1;
312: CLOSE c_chk_per_exist;

Line 317: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

313: EXIT;
314: END IF;
315: CLOSE c_chk_per_exist;
316: ELSE
317: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
318: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','l_grp_id.group_id IS NULL');
319: END IF;
320: END IF;
321:

Line 318: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','l_grp_id.group_id IS NULL');

314: END IF;
315: CLOSE c_chk_per_exist;
316: ELSE
317: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
318: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','l_grp_id.group_id IS NULL');
319: END IF;
320: END IF;
321:
322: ELSE

Line 323: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

319: END IF;
320: END IF;
321:
322: ELSE
323: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
324: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','l_rate_order.pid_group_cd IS NULL');
325: END IF;
326:
327: l_counter := 1;

Line 324: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','l_rate_order.pid_group_cd IS NULL');

320: END IF;
321:
322: ELSE
323: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
324: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.is_attrib_matching.debug','l_rate_order.pid_group_cd IS NULL');
325: END IF;
326:
327: l_counter := 1;
328: EXIT;

Line 551: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

547: CLOSE c_base_rec;
548:
549: IF l_base_rec.lock_coa_flag = 'Y' THEN
550:
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');

Line 552: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','base_id:'||p_base_id||' is locked');

548:
549: IF l_base_rec.lock_coa_flag = 'Y' THEN
550:
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);

Line 562: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

558: FOR l_items IN c_items(p_base_id)
559: LOOP
560: IF l_items.lock_flag = 'Y' THEN
561:
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');

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

559: LOOP
560: IF l_items.lock_flag = 'Y' THEN
561:
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);

Line 588: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

584: FOR l_terms IN c_terms(p_base_id, l_items.item_code)
585: LOOP
586: IF l_terms.lock_flag = 'Y' THEN
587:
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');

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

585: LOOP
586: IF l_terms.lock_flag = 'Y' THEN
587:
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));

Line 597: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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);
599: END IF;
600:
601: l_base_details := igf_aw_coa_gen.getBaseDetails(p_base_id,l_terms.ld_cal_type,l_terms.ld_sequence_number);

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

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);
599: END IF;
600:
601: l_base_details := igf_aw_coa_gen.getBaseDetails(p_base_id,l_terms.ld_cal_type,l_terms.ld_sequence_number);
602:

Line 622: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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;
625:
626: igf_aw_coa_itm_terms_pkg.update_row(

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

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;
625:
626: igf_aw_coa_itm_terms_pkg.update_row(
627: x_rowid => l_terms.row_id,

Line 680: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

676: END LOOP;
677: END IF;
678:
679: IF lv_coa_itm_update = 'Y' THEN
680: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
681: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','lv_coa_itm_update = Y');
682: END IF;
683:
684: lv_award_proc_status := igf_aw_coa_gen.set_awd_proc_status(p_base_id);

Line 681: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','lv_coa_itm_update = Y');

677: END IF;
678:
679: IF lv_coa_itm_update = 'Y' THEN
680: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
681: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.evaluate.debug','lv_coa_itm_update = Y');
682: END IF;
683:
684: lv_award_proc_status := igf_aw_coa_gen.set_awd_proc_status(p_base_id);
685: END IF;

Line 693: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level 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;
696:
697: WHEN OTHERS THEN

Line 694: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_update.evaluate.exception','sql error message:'||SQLERRM);

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;
696:
697: WHEN OTHERS THEN
698: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

Line 700: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

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;
704: app_exception.raise_exception;

Line 701: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_coa_update.evaluate.exception','sql error:'||SQLERRM);

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;
704: app_exception.raise_exception;
705:

Line 869: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

865: ln_ci_sequence_number := TO_NUMBER(SUBSTR(p_award_year,11));
866: lv_status := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */
867:
868:
869: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
870: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_award_year:'||p_award_year);
871: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_run_type:'||p_run_type);
872: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_pid_group:'||p_pid_group);
873: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_base_id:'||p_base_id);

Line 870: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_award_year:'||p_award_year);

866: lv_status := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */
867:
868:
869: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
870: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_award_year:'||p_award_year);
871: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_run_type:'||p_run_type);
872: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_pid_group:'||p_pid_group);
873: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_base_id:'||p_base_id);
874: END IF;

Line 871: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_run_type:'||p_run_type);

867:
868:
869: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
870: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_award_year:'||p_award_year);
871: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_run_type:'||p_run_type);
872: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_pid_group:'||p_pid_group);
873: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_base_id:'||p_base_id);
874: END IF;
875:

Line 872: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_pid_group:'||p_pid_group);

868:
869: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
870: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_award_year:'||p_award_year);
871: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_run_type:'||p_run_type);
872: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_pid_group:'||p_pid_group);
873: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_base_id:'||p_base_id);
874: END IF;
875:
876: fnd_file.new_line(fnd_file.log,1);

Line 873: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_base_id:'||p_base_id);

869: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
870: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_award_year:'||p_award_year);
871: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_run_type:'||p_run_type);
872: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_pid_group:'||p_pid_group);
873: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','p_base_id:'||p_base_id);
874: END IF;
875:
876: fnd_file.new_line(fnd_file.log,1);
877:

Line 928: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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;
931:
932: --Call evaluate procedure for COA re-computation

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

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;
931:
932: --Call evaluate procedure for COA re-computation
933: evaluate(p_base_id,lv_ci_cal_type,ln_ci_sequence_number);

Line 938: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

934:
935: --Update To Do Items
936: update_to_do_items(p_base_id,lv_ci_cal_type,ln_ci_sequence_number);
937:
938: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
939: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Run_Type=S done');
940: END IF;
941:
942: --COMPUTATION FOR AWARD YEAR ONLY

Line 939: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Run_Type=S done');

935: --Update To Do Items
936: update_to_do_items(p_base_id,lv_ci_cal_type,ln_ci_sequence_number);
937:
938: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
939: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Run_Type=S done');
940: END IF;
941:
942: --COMPUTATION FOR AWARD YEAR ONLY
943: ELSIF p_run_type = 'Y' AND (p_pid_group IS NULL) AND (p_base_id IS NULL) THEN

Line 951: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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;
954:
955: --Call evaluate procedure for COA re-computation

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

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;
954:
955: --Call evaluate procedure for COA re-computation
956: evaluate(l_per_awd_rec.base_id,lv_ci_cal_type,ln_ci_sequence_number);

Line 963: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

959: update_to_do_items(l_per_awd_rec.base_id,lv_ci_cal_type,ln_ci_sequence_number);
960:
961: END LOOP;
962:
963: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
964: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Run_Type=Y done');
965: END IF;
966:
967: --COMPUTATION FOR ALL PERSONS IN THE PERSON ID GROUP

Line 964: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Run_Type=Y done');

960:
961: END LOOP;
962:
963: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
964: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Run_Type=Y done');
965: END IF;
966:
967: --COMPUTATION FOR ALL PERSONS IN THE PERSON ID GROUP
968: ELSIF (p_run_type = 'P' AND p_pid_group IS NOT NULL) THEN

Line 1012: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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;
1015:
1016: --Call evaluate procedure for COA re-computation

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

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;
1015:
1016: --Call evaluate procedure for COA re-computation
1017: evaluate(ln_base_id,lv_ci_cal_type,ln_ci_sequence_number);

Line 1022: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1018:
1019: --Update To Do Items
1020: update_to_do_items(ln_base_id,lv_ci_cal_type,ln_ci_sequence_number);
1021:
1022: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1023: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Run_Type=P done');
1024: END IF;
1025:
1026: ELSE

Line 1023: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Run_Type=P done');

1019: --Update To Do Items
1020: update_to_do_items(ln_base_id,lv_ci_cal_type,ln_ci_sequence_number);
1021:
1022: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1023: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Run_Type=P done');
1024: END IF;
1025:
1026: ELSE
1027: OPEN c_person_no(per_grp_rec.person_id);

Line 1068: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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;
1071:
1072: --Call evaluate procedure for COA re-computation

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

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;
1071:
1072: --Call evaluate procedure for COA re-computation
1073: evaluate(ln_base_id,lv_ci_cal_type,ln_ci_sequence_number);

Line 1077: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1073: evaluate(ln_base_id,lv_ci_cal_type,ln_ci_sequence_number);
1074:
1075: FOR l_person_ref IN c_person_ref(lv_ci_cal_type,ln_ci_sequence_number,l_person_id.person_id,l_person_id.s_student_todo_type,l_person_id.sequence_number)
1076: LOOP
1077: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Updating table igs_pe_std_todo for person id: '||l_person_id.person_id);
1079: END IF;
1080:
1081: igs_pe_std_todo_ref_pkg.update_row(

Line 1078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Updating table igs_pe_std_todo for person id: '||l_person_id.person_id);

1074:
1075: FOR l_person_ref IN c_person_ref(lv_ci_cal_type,ln_ci_sequence_number,l_person_id.person_id,l_person_id.s_student_todo_type,l_person_id.sequence_number)
1076: LOOP
1077: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Updating table igs_pe_std_todo for person id: '||l_person_id.person_id);
1079: END IF;
1080:
1081: igs_pe_std_todo_ref_pkg.update_row(
1082: x_rowid => l_person_ref.row_id,

Line 1103: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1099: FETCH c_person_todo INTO l_person_todo;
1100:
1101: IF c_person_todo%FOUND THEN
1102:
1103: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1104: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','c_person_todo%FOUND');
1105: END IF;
1106:
1107: igs_pe_std_todo_pkg.update_row(

Line 1104: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','c_person_todo%FOUND');

1100:
1101: IF c_person_todo%FOUND THEN
1102:
1103: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1104: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','c_person_todo%FOUND');
1105: END IF;
1106:
1107: igs_pe_std_todo_pkg.update_row(
1108: x_rowid => l_person_todo.row_id,

Line 1119: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1115: );
1116: END IF;
1117: CLOSE c_person_todo;
1118:
1119: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1120: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Run_Type=A done');
1121: END IF;
1122:
1123: ELSE

Line 1120: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Run_Type=A done');

1116: END IF;
1117: CLOSE c_person_todo;
1118:
1119: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1120: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_update.main.debug','Run_Type=A done');
1121: END IF;
1122:
1123: ELSE
1124: OPEN c_person_no(l_person_id.person_id);