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_ANTICIPATED_DATA dependencies on FND_FILE

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

153:
154: lv_set_ant_data := 'N';
155: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
156: fnd_message.set_token('FIELD','ORG_UNIT_CD '||': '||p_interface.org_unit_cd );
157: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
158: END IF;
159: CLOSE c_org_unit;
160: END IF;
161:

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

170:
171: lv_set_ant_data := 'N';
172: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
173: fnd_message.set_token('FIELD','PROGRAM_TYPE'||': '||p_interface.program_type);
174: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
175: END IF;
176: CLOSE c_prog_type;
177: END IF;
178:

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

187:
188: lv_set_ant_data := 'N';
189: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
190: fnd_message.set_token('FIELD','PROGRAM_LOCATION_CD'||': '||p_interface.program_location_cd);
191: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
192: END IF;
193: CLOSE c_prog_loc;
194: END IF;
195:

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

204:
205: lv_set_ant_data := 'N';
206: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
207: fnd_message.set_token('FIELD','PROGRAM_CD'||': '||p_interface.program_cd);
208: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
209: END IF;
210: CLOSE c_prog_cd;
211: END IF;
212:

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

221:
222: lv_set_ant_data := 'N';
223: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
224: fnd_message.set_token('FIELD','CLASS_STANDING'||': '||p_interface.class_standing);
225: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
226: END IF;
227: CLOSE c_class_stnd;
228: END IF;
229:

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

238:
239: lv_set_ant_data := 'N';
240: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
241: fnd_message.set_token('FIELD','RESIDENCY_STATUS_CODE'||': '||p_interface.residency_status_code);
242: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
243: END IF;
244: CLOSE c_res_status;
245: END IF;
246:

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

255:
256: lv_set_ant_data := 'N';
257: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
258: fnd_message.set_token('FIELD','HOUSING_STATUS_CODE'||': '||p_interface.housing_status_code);
259: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
260: END IF;
261: CLOSE c_res_status;
262: END IF;
263:

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

272:
273: lv_set_ant_data := 'N';
274: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
275: fnd_message.set_token('FIELD','ATTENDANCE_TYPE'||': '||p_interface.attendance_type);
276: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
277: END IF;
278: CLOSE c_atten_type;
279: END IF;
280:

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

289:
290: lv_set_ant_data := 'N';
291: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
292: fnd_message.set_token('FIELD','ATTENDANCE_MODE'||': '||p_interface.attendance_mode);
293: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
294: END IF;
295: CLOSE c_atten_mode;
296: END IF;
297:

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

304:
305: lv_set_ant_data := 'N';
306: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
307: fnd_message.set_token('FIELD','MONTHS_ENROLLED_NUM'||': '||p_interface.months_enrolled_num);
308: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
309: END IF;
310: END IF;
311:
312: --validate credit point number

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

318:
319: lv_set_ant_data := 'N';
320: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
321: fnd_message.set_token('FIELD','CREDIT_POINTS_NUM'||': '||p_interface.credit_points_num);
322: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
323: END IF;
324: END IF;
325:
326: --to check OSS attributes

Line 355: fnd_file.put_line(fnd_file.log,lv_message);

351: RPAD(' ',5) ||
352: lv_msg_text;
353: END IF;
354: END LOOP;
355: fnd_file.put_line(fnd_file.log,lv_message);
356: END IF;
357: END IF;
358:
359:

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

387: x_credit_points_num => p_interface.credit_points_num
388: );
389:
390: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
391: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
392:
393: ELSIF p_interface.import_record_type = 'I' THEN
394: lv_rowid := NULL;
395:

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

417: );
418:
419:
420: fnd_message.set_name('IGS','IGS_AD_SUCC_IMP_OFR_RESP_REC');
421: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
422:
423: END IF;
424:
425: IF p_delete_flag = 'Y' THEN

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

452: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','No data Imported');
453: END IF;
454:
455: fnd_message.set_name('IGS','IGS_EN_NO_DATA_IMP');
456: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
457:
458: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
459: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.process_anti_data.debug','updating in igf_aw_anticpt_ints');
460: END IF;

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

597: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_batch_id:'||p_batch_id);
598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','p_del_ind:'||p_del_ind);
599: END IF;
600:
601: fnd_file.new_line(fnd_file.log,1);
602:
603: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
604: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| lv_alternate_code);
605: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','BATCH_NUMBER'),40) ||': '||p_batch_id);

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

599: END IF;
600:
601: fnd_file.new_line(fnd_file.log,1);
602:
603: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
604: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| lv_alternate_code);
605: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','BATCH_NUMBER'),40) ||': '||p_batch_id);
606: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DELETE_FLAG'),40) ||': '||igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind) );
607:

Line 604: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| lv_alternate_code);

600:
601: fnd_file.new_line(fnd_file.log,1);
602:
603: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
604: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| lv_alternate_code);
605: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','BATCH_NUMBER'),40) ||': '||p_batch_id);
606: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DELETE_FLAG'),40) ||': '||igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind) );
607:
608: fnd_file.new_line(fnd_file.log,2);

Line 605: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','BATCH_NUMBER'),40) ||': '||p_batch_id);

601: fnd_file.new_line(fnd_file.log,1);
602:
603: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
604: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| lv_alternate_code);
605: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','BATCH_NUMBER'),40) ||': '||p_batch_id);
606: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DELETE_FLAG'),40) ||': '||igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind) );
607:
608: fnd_file.new_line(fnd_file.log,2);
609:

Line 606: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DELETE_FLAG'),40) ||': '||igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind) );

602:
603: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
604: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| lv_alternate_code);
605: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','BATCH_NUMBER'),40) ||': '||p_batch_id);
606: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DELETE_FLAG'),40) ||': '||igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind) );
607:
608: fnd_file.new_line(fnd_file.log,2);
609:
610: IF (p_award_year IS NULL) OR (p_batch_id IS NULL) OR (p_del_ind IS NULL) THEN

Line 608: fnd_file.new_line(fnd_file.log,2);

604: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),40) ||': '|| lv_alternate_code);
605: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','BATCH_NUMBER'),40) ||': '||p_batch_id);
606: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DELETE_FLAG'),40) ||': '||igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind) );
607:
608: fnd_file.new_line(fnd_file.log,2);
609:
610: IF (p_award_year IS NULL) OR (p_batch_id IS NULL) OR (p_del_ind IS NULL) THEN
611: RAISE param_exception;
612:

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

624: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','l_chk_batch.batch_num IS NULL');
625: END IF;
626:
627: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');
628: fnd_file.put_line(fnd_file.log,fnd_message.get);
629: RAISE param_exception;
630: END IF;
631:
632: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');

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

628: fnd_file.put_line(fnd_file.log,fnd_message.get);
629: RAISE param_exception;
630: END IF;
631:
632: fnd_file.put_line(fnd_file.log,'-------------------------------------------------------');
633:
634: --check Anticipated Data From Interface Table with status as 'R'
635: OPEN c_chk_interface(p_batch_id,lv_alternate_code);
636: FETCH c_chk_interface INTO l_chk_interface;

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

641: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','l_chk_interface.val IS NULL');
642: END IF;
643:
644: fnd_message.set_name('IGS','IGS_FI_NO_RECORD_AVAILABLE');
645: fnd_file.put_line(fnd_file.log,fnd_message.get);
646: RETURN;
647: END IF;
648:
649:

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

653: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
654: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','validating person number :'||l_interface.person_number);
655: END IF;
656:
657: fnd_file.new_line(fnd_file.log,1);
658:
659: IF lv_person_number <> l_interface.person_number THEN
660: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
661: fnd_message.set_token('STDNT',l_interface.person_number);

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

658:
659: IF lv_person_number <> l_interface.person_number THEN
660: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
661: fnd_message.set_token('STDNT',l_interface.person_number);
662: fnd_file.put_line(fnd_file.log,fnd_message.get);
663:
664: --here call to the generic wrapper is being made to check the validity of the perosn and base record
665: igf_ap_gen.check_person(l_interface.person_number,lv_ci_cal_type,ln_ci_sequence_number,ln_person_id,ln_base_id);
666: END IF;

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

672: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','ln_person_id IS NULL');
673: END IF;
674:
675: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
676: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
677: ELSE
678: IF ln_base_id IS NULL THEN
679: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
680: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','ln_base_id IS NULL');

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

680: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','ln_base_id IS NULL');
681: END IF;
682:
683: fnd_message.set_name('IGF','IGF_AP_FABASE_NOT_FOUND');
684: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
685: ELSE
686: l_get_cal_typ_seq_num := NULL;
687:
688: OPEN c_get_cal_typ_seq_num(l_interface.ld_alternate_code,

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

694: CLOSE c_get_cal_typ_seq_num;
695:
696: fnd_message.set_name('IGF','IGF_AW_PROC_TERM');
697: fnd_message.set_token('TERM',l_interface.ld_alternate_code);
698: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
699:
700:
701: IF l_get_cal_typ_seq_num.ld_cal_type IS NULL OR l_get_cal_typ_seq_num.ld_sequence_number IS NULL THEN
702: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

704: END IF;
705:
706: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
707: fnd_message.set_token('FIELD','LD_ALTERNATE_CODE'||': '||l_interface.ld_alternate_code);
708: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
709:
710: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
711: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');
712: END IF;

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

737: END IF;
738:
739: fnd_message.set_name('IGF','IGF_AW_IMP_ANT_AVAL');
740: fnd_message.set_token('REC_TYPE',l_interface.import_record_type);
741: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
742:
743: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
744: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');
745: END IF;

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

766: END IF;
767:
768: fnd_message.set_name('IGF','IGF_AW_IMP_ANT_NOT_AVAL');
769: fnd_message.set_token('REC_TYPE',l_interface.import_record_type);
770: fnd_file.put_line(fnd_file.log,RPAD(' ',5)||fnd_message.get);
771:
772: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
773: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_anticipated_data.main.debug','updating in igf_aw_anticpt_ints');
774: END IF;