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_FILE

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

116:
117: fnd_message.set_name('IGF','IGF_AW_LOCK_STUD');
118: fnd_message.set_token('FUND',lc_awd.fund_code);
119: fnd_message.set_token('AWARD',p_award_id);
120: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
121:
122: ELSIF p_run_mode = 'U' THEN
123: lv_lock_award_flag := 'N';
124: lv_publish_in_ss_flag := lc_awd.publish_in_ss_flag;

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

126:
127: fnd_message.set_name('IGF','IGF_AW_UNLOCK_STUD');
128: fnd_message.set_token('FUND',lc_awd.fund_code);
129: fnd_message.set_token('AWARD',p_award_id);
130: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
131:
132: ELSIF p_run_mode = 'PB' THEN
133: lv_lock_award_flag := lc_awd.lock_award_flag;
134: lv_publish_in_ss_flag := 'Y';

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

136:
137: fnd_message.set_name('IGF','IGF_AW_AWD_PUBLISH');
138: fnd_message.set_token('FUNDCODE',lc_awd.fund_code);
139: fnd_message.set_token('AWDID',p_award_id);
140: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
141:
142: ELSIF p_run_mode = 'UP' THEN
143: lv_lock_award_flag := lc_awd.lock_award_flag;
144: lv_publish_in_ss_flag := 'N';

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

146:
147: fnd_message.set_name('IGF','IGF_AW_AWD_UNPUBLISH');
148: fnd_message.set_token('FUNDCODE',lc_awd.fund_code);
149: fnd_message.set_token('AWDID',p_award_id);
150: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
151:
152: ELSIF p_run_mode = 'S' THEN
153: lv_lock_award_flag := lc_awd.lock_award_flag;
154: lv_publish_in_ss_flag := lc_awd.publish_in_ss_flag;

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

211: IF p_run_mode = 'S' THEN
212: fnd_message.set_name('IGF','IGF_AW_AWD_PROC');
213: fnd_message.set_token('PROC_STATUS',p_awd_proc_status);
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');

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

284:
285: IF p_run_mode = 'L' THEN
286: lv_lock_award_flag := 'Y';
287: fnd_message.set_name('IGF','IGF_AW_LOCK_STUD_LVL');
288: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
289:
290: ELSIF p_run_mode = 'U' THEN
291: lv_lock_award_flag := 'N';
292: fnd_message.set_name('IGF','IGF_AW_UNLOCK_STUD_LVL');

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

289:
290: ELSIF p_run_mode = 'U' THEN
291: lv_lock_award_flag := 'N';
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);

Line 593: fnd_file.new_line(fnd_file.log,1);

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:
595: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
596: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
597: IF p_award_period IS NOT NULL THEN

Line 595: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));

591: END IF;
592:
593: fnd_file.new_line(fnd_file.log,1);
594:
595: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
596: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
597: IF p_award_period IS NOT NULL THEN
598: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PERIOD'),40)||': '||p_award_period );
599: END IF;

Line 596: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));

592:
593: fnd_file.new_line(fnd_file.log,1);
594:
595: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
596: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
597: IF p_award_period IS NOT NULL THEN
598: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PERIOD'),40)||': '||p_award_period );
599: END IF;
600:

Line 598: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PERIOD'),40)||': '||p_award_period );

594:
595: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
596: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| igf_gr_gen.get_alt_code(lv_ci_cal_type,ln_ci_sequence_number));
597: IF p_award_period IS NOT NULL THEN
598: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PERIOD'),40)||': '||p_award_period );
599: END IF;
600:
601: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),40)||': '||p_run_type );
602:

Line 601: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),40)||': '||p_run_type );

597: IF p_award_period IS NOT NULL THEN
598: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PERIOD'),40)||': '||p_award_period );
599: END IF;
600:
601: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_TYPE'),40)||': '||p_run_type );
602:
603: IF p_pid_group IS NOT NULL THEN
604: OPEN c_group_code(p_pid_group);
605: FETCH c_group_code INTO l_grp_cd;

Line 608: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),40) ||': '|| l_grp_cd.group_cd);

604: OPEN c_group_code(p_pid_group);
605: FETCH c_group_code INTO l_grp_cd;
606: CLOSE c_group_code;
607:
608: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),40) ||': '|| l_grp_cd.group_cd);
609: END IF;
610: IF p_base_id IS NOT NULL THEN
611: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),40) ||': '|| igf_gr_gen.get_per_num(p_base_id));
612: END If;

Line 611: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),40) ||': '|| igf_gr_gen.get_per_num(p_base_id));

607:
608: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),40) ||': '|| l_grp_cd.group_cd);
609: END IF;
610: IF p_base_id IS NOT NULL THEN
611: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),40) ||': '|| igf_gr_gen.get_per_num(p_base_id));
612: END If;
613: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_MODE'),40) ||': '||igf_aw_gen.lookup_desc('IGF_AW_LOCK_MODE',p_run_mode));
614: IF p_awd_proc_status IS NOT NULL THEN
615: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PROC_STATUS'),40) ||': '|| igf_aw_gen.lookup_desc('IGF_AW_AWD_PROC_STAT',p_awd_proc_status));

Line 613: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_MODE'),40) ||': '||igf_aw_gen.lookup_desc('IGF_AW_LOCK_MODE',p_run_mode));

609: END IF;
610: IF p_base_id IS NOT NULL THEN
611: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),40) ||': '|| igf_gr_gen.get_per_num(p_base_id));
612: END If;
613: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_MODE'),40) ||': '||igf_aw_gen.lookup_desc('IGF_AW_LOCK_MODE',p_run_mode));
614: IF p_awd_proc_status IS NOT NULL THEN
615: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PROC_STATUS'),40) ||': '|| igf_aw_gen.lookup_desc('IGF_AW_AWD_PROC_STAT',p_awd_proc_status));
616: END IF;
617:

Line 615: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PROC_STATUS'),40) ||': '|| igf_aw_gen.lookup_desc('IGF_AW_AWD_PROC_STAT',p_awd_proc_status));

611: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),40) ||': '|| igf_gr_gen.get_per_num(p_base_id));
612: END If;
613: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','RUN_MODE'),40) ||': '||igf_aw_gen.lookup_desc('IGF_AW_LOCK_MODE',p_run_mode));
614: IF p_awd_proc_status IS NOT NULL THEN
615: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_PROC_STATUS'),40) ||': '|| igf_aw_gen.lookup_desc('IGF_AW_AWD_PROC_STAT',p_awd_proc_status));
616: END IF;
617:
618: IF p_fund_id IS NOT NULL THEN
619: OPEN c_fund_code(p_fund_id);

Line 623: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_CODE'),40) ||': '|| l_fund_code.fund_code);

619: OPEN c_fund_code(p_fund_id);
620: FETCH c_fund_code INTO l_fund_code;
621: CLOSE c_fund_code;
622:
623: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_CODE'),40) ||': '|| l_fund_code.fund_code);
624: END IF;
625:
626:
627: IF (p_award_year IS NULL) OR (p_run_type IS NULL) OR (p_run_mode IS NULL) THEN

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

636: --If person selection is for all persons in the Person ID Group and
637: --Person ID Group is NULL then log error with exception
638: ELSIF p_run_type = 'P' AND p_pid_group IS NULL THEN
639: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_P');
640: fnd_file.put_line(fnd_file.log,fnd_message.get);
641: RAISE param_exception;
642:
643: --If person selection is for a single person and
644: --Base ID is NULL then log error with exception

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

643: --If person selection is for a single person and
644: --Base ID is NULL then log error with exception
645: ELSIF p_run_type = 'S' AND p_base_id IS NULL THEN
646: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_S');
647: fnd_file.put_line(fnd_file.log,fnd_message.get);
648: RAISE param_exception;
649:
650: --If the Run Mode is 'Set Award Process Status' and
651: --Fund ID is NOT NULL then log error with exception

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

650: --If the Run Mode is 'Set Award Process Status' and
651: --Fund ID is NOT NULL then log error with exception
652: ELSIF p_run_mode = 'S' AND p_fund_id IS NOT NULL THEN
653: fnd_message.set_name('IGF','IGF_AW_MANG_AW_FUND_ERR');
654: fnd_file.put_line(fnd_file.log,fnd_message.get);
655: RAISE param_exception;
656: END IF;
657:
658: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');

Line 658: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');

654: fnd_file.put_line(fnd_file.log,fnd_message.get);
655: RAISE param_exception;
656: END IF;
657:
658: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
659:
660: --COMPUTATION ONLY IF PERSON NUMBER IS PRESENT
661: IF p_run_type = 'S' AND (p_pid_group IS NULL) AND (p_base_id IS NOT NULL) THEN
662:

Line 663: fnd_file.new_line(fnd_file.log,1);

659:
660: --COMPUTATION ONLY IF PERSON NUMBER IS PRESENT
661: IF p_run_type = 'S' AND (p_pid_group IS NULL) AND (p_base_id IS NOT NULL) THEN
662:
663: fnd_file.new_line(fnd_file.log,1);
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:

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

662:
663: fnd_file.new_line(fnd_file.log,1);
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;

Line 706: fnd_file.new_line(fnd_file.log,1);

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
704: FOR l_per_awd_rec IN c_per_awd_yr(lv_ci_cal_type,ln_ci_sequence_number)
705: LOOP
706: fnd_file.new_line(fnd_file.log,1);
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:

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

705: LOOP
706: fnd_file.new_line(fnd_file.log,1);
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;

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

766: FETCH cur_per_grp INTO per_grp_rec;
767:
768: IF (cur_per_grp%NOTFOUND) THEN
769: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
770: fnd_file.put_line(fnd_file.log,fnd_message.get);
771: ELSE
772: LOOP
773: -- check if person has a fa base record
774: ln_base_id := NULL;

Line 786: fnd_file.new_line(fnd_file.log,1);

782: lv_err_msg
783: );
784:
785: IF lv_err_msg = 'NULL' THEN
786: fnd_file.new_line(fnd_file.log,1);
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:

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

785: IF lv_err_msg = 'NULL' THEN
786: fnd_file.new_line(fnd_file.log,1);
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;

Line 832: fnd_file.new_line(fnd_file.log,1);

828: CLOSE c_person_no;
829:
830: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
831: fnd_message.set_token('STUD',l_person_no.party_number);
832: fnd_file.new_line(fnd_file.log,1);
833: fnd_file.put_line(fnd_file.log,fnd_message.get);
834: END IF;
835:
836: FETCH cur_per_grp INTO per_grp_rec;

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

829:
830: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
831: fnd_message.set_token('STUD',l_person_no.party_number);
832: fnd_file.new_line(fnd_file.log,1);
833: fnd_file.put_line(fnd_file.log,fnd_message.get);
834: END IF;
835:
836: FETCH cur_per_grp INTO per_grp_rec;
837: EXIT WHEN cur_per_grp%NOTFOUND;

Line 845: fnd_file.new_line(fnd_file.log,1);

841: END IF; -- end of IF (cur_per_grp%NOTFOUND)
842:
843: END IF;
844:
845: fnd_file.new_line(fnd_file.log,1);
846: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
847:
848:
849: COMMIT;

Line 846: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');

842:
843: END IF;
844:
845: fnd_file.new_line(fnd_file.log,1);
846: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
847:
848:
849: COMMIT;
850: