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_MANAGE_AWD dependencies on FND_LOG

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

82: lv_publish_in_ss_flag igf_aw_award_all.publish_in_ss_flag%TYPE;
83: lv_awd_proc_status_code igf_aw_award_all.awd_proc_status_code%TYPE;
84:
85: BEGIN
86: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
87: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','Starting process_award with award_id:'||p_award_id);
88: END IF;
89:
90: --open cursor based on run mode

Line 87: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','Starting process_award with award_id:'||p_award_id);

83: lv_awd_proc_status_code igf_aw_award_all.awd_proc_status_code%TYPE;
84:
85: BEGIN
86: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
87: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','Starting process_award with award_id:'||p_award_id);
88: END IF;
89:
90: --open cursor based on run mode
91: IF p_run_mode IN ('L','U','PB','UP') THEN

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

154: lv_publish_in_ss_flag := lc_awd.publish_in_ss_flag;
155: lv_awd_proc_status_code := p_awd_proc_status;
156: END IF;
157:
158: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
159: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','Updating igf_aw_award_all with lock='||lv_lock_award_flag||' and process_status='||lv_awd_proc_status_code);
160: END IF;
161:
162: igf_aw_award_pkg.update_row (

Line 159: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','Updating igf_aw_award_all with lock='||lv_lock_award_flag||' and process_status='||lv_awd_proc_status_code);

155: lv_awd_proc_status_code := p_awd_proc_status;
156: END IF;
157:
158: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
159: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','Updating igf_aw_award_all with lock='||lv_lock_award_flag||' and process_status='||lv_awd_proc_status_code);
160: END IF;
161:
162: igf_aw_award_pkg.update_row (
163: x_mode => 'R',

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

214: fnd_message.set_token('AWARD',p_award_id);
215: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
216: END IF;
217:
218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','End of Update');
220: END IF;
221:
222: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','End of Update');

215: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
216: END IF;
217:
218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','End of Update');
220: END IF;
221:
222: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
223: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','process_award is done');

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

218: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','End of Update');
220: END IF;
221:
222: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
223: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','process_award is done');
224: END IF;
225:
226: EXCEPTION

Line 223: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','process_award is done');

219: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','End of Update');
220: END IF;
221:
222: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
223: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','process_award is done');
224: END IF;
225:
226: EXCEPTION
227: WHEN OTHERS THEN

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

226: EXCEPTION
227: WHEN OTHERS THEN
228: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
229: fnd_message.set_token('NAME','IGF_AW_MANAGE_AWD.PROCESS_AWARD :' || SQLERRM);
230: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
231: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_manage_awd.process_award.exception','sql error:'||SQLERRM);
232: END IF;
233: igs_ge_msg_stack.conc_exception_hndl;
234: app_exception.raise_exception;

Line 231: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_manage_awd.process_award.exception','sql error:'||SQLERRM);

227: WHEN OTHERS THEN
228: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
229: fnd_message.set_token('NAME','IGF_AW_MANAGE_AWD.PROCESS_AWARD :' || SQLERRM);
230: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
231: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_manage_awd.process_award.exception','sql error:'||SQLERRM);
232: END IF;
233: igs_ge_msg_stack.conc_exception_hndl;
234: app_exception.raise_exception;
235:

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

268: lv_lock_award_flag igf_aw_award_all.lock_award_flag%TYPE;
269:
270: BEGIN
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_manage_awd.lock_unlock_stud.debug','Starting lock_unlock_stud with base_id:'||p_base_id);
274: END IF;
275:
276: OPEN cur_upd_base(p_base_id,p_run_mode);

Line 273: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','Starting lock_unlock_stud with base_id:'||p_base_id);

269:
270: BEGIN
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_manage_awd.lock_unlock_stud.debug','Starting lock_unlock_stud with base_id:'||p_base_id);
274: END IF;
275:
276: OPEN cur_upd_base(p_base_id,p_run_mode);
277: FETCH cur_upd_base INTO cur_fbr_rec;

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

292: fnd_message.set_name('IGF','IGF_AW_UNLOCK_STUD_LVL');
293: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
294: END IF;
295:
296: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
297: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','Updating igf_ap_fa_base_rec_all with lock='||lv_lock_award_flag);
298: END IF;
299:
300: igf_ap_fa_base_rec_pkg.update_row

Line 297: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','Updating igf_ap_fa_base_rec_all with lock='||lv_lock_award_flag);

293: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
294: END IF;
295:
296: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
297: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','Updating igf_ap_fa_base_rec_all with lock='||lv_lock_award_flag);
298: END IF;
299:
300: igf_ap_fa_base_rec_pkg.update_row
301: (x_Mode => 'R',

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

412: x_lock_awd_flag => lv_lock_award_flag,
413: x_lock_coa_flag => cur_fbr_rec.lock_coa_flag
414: );
415:
416: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','End of Update');
418: END IF;
419:
420: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','End of Update');

413: x_lock_coa_flag => cur_fbr_rec.lock_coa_flag
414: );
415:
416: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','End of Update');
418: END IF;
419:
420: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','lock_unlock_stud is done');

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

416: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','End of Update');
418: END IF;
419:
420: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','lock_unlock_stud is done');
422: END IF;
423:
424: EXCEPTION

Line 421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','lock_unlock_stud is done');

417: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','End of Update');
418: END IF;
419:
420: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
421: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','lock_unlock_stud is done');
422: END IF;
423:
424: EXCEPTION
425: WHEN OTHERS THEN

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

424: EXCEPTION
425: WHEN OTHERS THEN
426: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
427: fnd_message.set_token('NAME','IGF_AW_MANAGE_AWD.LOCK_UNLOCK_STUD :' || SQLERRM);
428: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
429: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.exception','sql error:'||SQLERRM);
430: END IF;
431: igs_ge_msg_stack.conc_exception_hndl;
432: app_exception.raise_exception;

Line 429: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.exception','sql error:'||SQLERRM);

425: WHEN OTHERS THEN
426: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
427: fnd_message.set_token('NAME','IGF_AW_MANAGE_AWD.LOCK_UNLOCK_STUD :' || SQLERRM);
428: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
429: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.exception','sql error:'||SQLERRM);
430: END IF;
431: igs_ge_msg_stack.conc_exception_hndl;
432: app_exception.raise_exception;
433:

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

578: ln_ci_sequence_number := TO_NUMBER(SUBSTR(p_award_year,11));
579: lv_status := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */
580:
581:
582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_award_year:'||p_award_year);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_award_period:'||p_award_period);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_type:'||p_run_type);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_pid_group:'||p_pid_group);

Line 583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_award_year:'||p_award_year);

579: lv_status := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */
580:
581:
582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_award_year:'||p_award_year);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_award_period:'||p_award_period);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_type:'||p_run_type);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_pid_group:'||p_pid_group);
587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_base_id:'||p_base_id);

Line 584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_award_period:'||p_award_period);

580:
581:
582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_award_year:'||p_award_year);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_award_period:'||p_award_period);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_type:'||p_run_type);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_pid_group:'||p_pid_group);
587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_base_id:'||p_base_id);
588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_mode:'||p_run_mode);

Line 585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_type:'||p_run_type);

581:
582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_award_year:'||p_award_year);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_award_period:'||p_award_period);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_type:'||p_run_type);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_pid_group:'||p_pid_group);
587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_base_id:'||p_base_id);
588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_mode:'||p_run_mode);
589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_awd_proc_status:'||p_awd_proc_status);

Line 586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_pid_group:'||p_pid_group);

582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_award_year:'||p_award_year);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_award_period:'||p_award_period);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_type:'||p_run_type);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_pid_group:'||p_pid_group);
587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_base_id:'||p_base_id);
588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_mode:'||p_run_mode);
589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_awd_proc_status:'||p_awd_proc_status);
590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_fund_id:'||p_fund_id);

Line 587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_base_id:'||p_base_id);

583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_award_year:'||p_award_year);
584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_award_period:'||p_award_period);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_type:'||p_run_type);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_pid_group:'||p_pid_group);
587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_base_id:'||p_base_id);
588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_mode:'||p_run_mode);
589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_awd_proc_status:'||p_awd_proc_status);
590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_fund_id:'||p_fund_id);
591: END IF;

Line 588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_mode:'||p_run_mode);

584: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_award_period:'||p_award_period);
585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_type:'||p_run_type);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_pid_group:'||p_pid_group);
587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_base_id:'||p_base_id);
588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_mode:'||p_run_mode);
589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_awd_proc_status:'||p_awd_proc_status);
590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_fund_id:'||p_fund_id);
591: END IF;
592:

Line 589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_awd_proc_status:'||p_awd_proc_status);

585: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_type:'||p_run_type);
586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_pid_group:'||p_pid_group);
587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_base_id:'||p_base_id);
588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_mode:'||p_run_mode);
589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_awd_proc_status:'||p_awd_proc_status);
590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_fund_id:'||p_fund_id);
591: END IF;
592:
593: fnd_file.new_line(fnd_file.log,1);

Line 590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_fund_id:'||p_fund_id);

586: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_pid_group:'||p_pid_group);
587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_base_id:'||p_base_id);
588: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_run_mode:'||p_run_mode);
589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_awd_proc_status:'||p_awd_proc_status);
590: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','p_fund_id:'||p_fund_id);
591: END IF;
592:
593: fnd_file.new_line(fnd_file.log,1);
594:

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

664: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
665: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
666: fnd_file.put_line(fnd_file.log,fnd_message.get);
667:
668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Starting Run_Type=S with base_id:'||p_base_id);
670: END IF;
671:
672: IF p_award_period IS NOT NULL THEN

Line 669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Starting Run_Type=S with base_id:'||p_base_id);

665: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
666: fnd_file.put_line(fnd_file.log,fnd_message.get);
667:
668: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
669: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Starting Run_Type=S with base_id:'||p_base_id);
670: END IF;
671:
672: IF p_award_period IS NOT NULL THEN
673: FOR l_awards IN c_awards(lv_ci_cal_type,ln_ci_sequence_number,p_award_period,p_base_id,p_fund_id)

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

694: lock_unlock_stud(p_base_id,p_run_mode);
695: END IF;
696: END IF;
697:
698: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
699: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Run_Type=S done');
700: END IF;
701:
702: --COMPUTATION FOR AWARD YEAR ONLY

Line 699: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Run_Type=S done');

695: END IF;
696: END IF;
697:
698: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
699: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Run_Type=S done');
700: END IF;
701:
702: --COMPUTATION FOR AWARD YEAR ONLY
703: ELSIF p_run_type = 'Y' AND (p_pid_group IS NULL) AND (p_base_id IS NULL) THEN

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

707: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
708: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));
709: fnd_file.put_line(fnd_file.log,fnd_message.get);
710:
711: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
712: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Starting Run_Type=Y with base_id:'||l_per_awd_rec.base_id);
713: END IF;
714:
715: IF p_award_period IS NOT NULL THEN

Line 712: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Starting Run_Type=Y with base_id:'||l_per_awd_rec.base_id);

708: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));
709: fnd_file.put_line(fnd_file.log,fnd_message.get);
710:
711: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
712: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Starting Run_Type=Y with base_id:'||l_per_awd_rec.base_id);
713: END IF;
714:
715: IF p_award_period IS NOT NULL THEN
716: FOR l_awards IN c_awards(lv_ci_cal_type,ln_ci_sequence_number,p_award_period,l_per_awd_rec.base_id,p_fund_id)

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

738: END IF;
739: END IF;
740: END LOOP;
741:
742: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
743: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Run_Type=Y done');
744: END IF;
745:
746: --COMPUTATION FOR ALL PERSONS IN THE PERSON ID GROUP

Line 743: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Run_Type=Y done');

739: END IF;
740: END LOOP;
741:
742: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
743: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Run_Type=Y done');
744: END IF;
745:
746: --COMPUTATION FOR ALL PERSONS IN THE PERSON ID GROUP
747: ELSIF (p_run_type = 'P' AND p_pid_group IS NOT NULL) THEN

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

787: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
788: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
789: fnd_file.put_line(fnd_file.log,fnd_message.get);
790:
791: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
792: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Starting Run_Type=P with base_id:'||ln_base_id);
793: END IF;
794:
795: IF p_award_period IS NOT NULL THEN

Line 792: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Starting Run_Type=P with base_id:'||ln_base_id);

788: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
789: fnd_file.put_line(fnd_file.log,fnd_message.get);
790:
791: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
792: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Starting Run_Type=P with base_id:'||ln_base_id);
793: END IF;
794:
795: IF p_award_period IS NOT NULL THEN
796: FOR l_awards IN c_awards(lv_ci_cal_type,ln_ci_sequence_number,p_award_period,ln_base_id,p_fund_id)

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

817: lock_unlock_stud(ln_base_id,p_run_mode);
818: END IF;
819: END IF;
820:
821: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Run_Type=P done');
823: END IF;
824:
825: ELSE

Line 822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Run_Type=P done');

818: END IF;
819: END IF;
820:
821: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.run.debug','Run_Type=P done');
823: END IF;
824:
825: ELSE
826: OPEN c_person_no(per_grp_rec.person_id);