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

Line 145: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);

141: l_alternate_code :=igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number);
142: l_heading :=igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');
143:
144: l_log_mesg :=igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS');
145: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
146:
147: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CI_ALTERNATE_CODE'),80,' ') ||':'||RPAD(' ',4,' ')||l_alternate_code ;
148: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
149:

Line 148: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);

144: l_log_mesg :=igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS');
145: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
146:
147: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CI_ALTERNATE_CODE'),80,' ') ||':'||RPAD(' ',4,' ')||l_alternate_code ;
148: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
149:
150: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_CATG'),80,' ')||':'||RPAD(' ',4,' ')||
151: igf_aw_gen.lookup_desc('IGF_SL_DL_LOAN_CATG',p_loan_catg) ;
152: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);

Line 152: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);

148: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
149:
150: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_CATG'),80,' ')||':'||RPAD(' ',4,' ')||
151: igf_aw_gen.lookup_desc('IGF_SL_DL_LOAN_CATG',p_loan_catg) ;
152: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
153:
154: --Display the Person Number for the Base ID
155: l_person_num :=NULL;
156: IF l_person_id IS NOT NULL THEN

Line 160: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);

156: IF l_person_id IS NOT NULL THEN
157: l_person_num:=igf_gr_gen.get_per_num_oss(l_person_id);
158: END IF;
159: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),80,' ')||':'||RPAD(' ',4,' ')||l_person_num ;
160: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
161:
162: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER'),80)||':'||p_loan_number;
163: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
164:

Line 163: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);

159: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),80,' ')||':'||RPAD(' ',4,' ')||l_person_num ;
160: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
161:
162: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER'),80)||':'||p_loan_number;
163: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
164:
165: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
166:
167: OPEN get_student_rec FOR

Line 165: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

161:
162: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER'),80)||':'||p_loan_number;
163: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
164:
165: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
166:
167: OPEN get_student_rec FOR
168: select person_id from igf_ap_fa_base_rec
169: where base_id = p_base_id and person_id IS NOT NULL;

Line 179: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

175: FETCH c_prnt_ind INTO l_print_option,l_awd_year;
176: IF c_prnt_ind%NOTFOUND THEN
177: CLOSE c_prnt_ind;
178: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_NO_DL_SETUP');
179: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
180: RAISE NO_DATA_FOUND;
181: END IF;
182: CLOSE c_prnt_ind;
183:

Line 190: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

186:
187: IF ( l_print_option <> 'F' ) THEN
188: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_PNOTE_SCH_NOPRNT');
189: FND_MESSAGE.SET_TOKEN('AWD_YR', l_awd_year );
190: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
191: RETURN;
192: END IF;
193:
194:

Line 370: fnd_file.put_line(fnd_file.log,' ');

366:
367: EXCEPTION
368: WHEN app_exception.record_lock_exception THEN
369:
370: fnd_file.put_line(fnd_file.log,' ');
371: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
372: fnd_file.put_line(fnd_file.log,fnd_message.get);
373: fnd_file.put_line(fnd_file.log,l_heading||': '||r_lor_signed.loan_number);
374: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

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

368: WHEN app_exception.record_lock_exception THEN
369:
370: fnd_file.put_line(fnd_file.log,' ');
371: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
372: fnd_file.put_line(fnd_file.log,fnd_message.get);
373: fnd_file.put_line(fnd_file.log,l_heading||': '||r_lor_signed.loan_number);
374: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
375: fnd_file.put_line(fnd_file.log,fnd_message.get);
376: fnd_file.put_line(fnd_file.log,' ');

Line 373: fnd_file.put_line(fnd_file.log,l_heading||': '||r_lor_signed.loan_number);

369:
370: fnd_file.put_line(fnd_file.log,' ');
371: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
372: fnd_file.put_line(fnd_file.log,fnd_message.get);
373: fnd_file.put_line(fnd_file.log,l_heading||': '||r_lor_signed.loan_number);
374: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
375: fnd_file.put_line(fnd_file.log,fnd_message.get);
376: fnd_file.put_line(fnd_file.log,' ');
377: ROLLBACK TO sp_prom_manifest;

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

371: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
372: fnd_file.put_line(fnd_file.log,fnd_message.get);
373: fnd_file.put_line(fnd_file.log,l_heading||': '||r_lor_signed.loan_number);
374: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
375: fnd_file.put_line(fnd_file.log,fnd_message.get);
376: fnd_file.put_line(fnd_file.log,' ');
377: ROLLBACK TO sp_prom_manifest;
378:
379: END;

Line 376: fnd_file.put_line(fnd_file.log,' ');

372: fnd_file.put_line(fnd_file.log,fnd_message.get);
373: fnd_file.put_line(fnd_file.log,l_heading||': '||r_lor_signed.loan_number);
374: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
375: fnd_file.put_line(fnd_file.log,fnd_message.get);
376: fnd_file.put_line(fnd_file.log,' ');
377: ROLLBACK TO sp_prom_manifest;
378:
379: END;
380:

Line 384: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

380:
381: END LOOP; -- End of r_lor_signed loop (i.e) main loop
382:
383: /* Display the details in the Log file */
384: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
385: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
386:
387:
388: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_NO_OF_PNOTES');

Line 385: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

381: END LOOP; -- End of r_lor_signed loop (i.e) main loop
382:
383: /* Display the details in the Log file */
384: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
385: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
386:
387:
388: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_NO_OF_PNOTES');
389: FND_MESSAGE.SET_TOKEN('NO_OF_PNOTES', l_total_pnote );

Line 390: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

386:
387:
388: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_NO_OF_PNOTES');
389: FND_MESSAGE.SET_TOKEN('NO_OF_PNOTES', l_total_pnote );
390: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
391:
392: IF l_total_pnote = 0 THEN
393: --There are no Signed Promissory Notes.Promissory Note Manifest has not been created.
394: fnd_message.set_name('IGF','IGF_SL_NO_SIGN_PROMNOTE');

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

391:
392: IF l_total_pnote = 0 THEN
393: --There are no Signed Promissory Notes.Promissory Note Manifest has not been created.
394: fnd_message.set_name('IGF','IGF_SL_NO_SIGN_PROMNOTE');
395: fnd_file.put_line(fnd_file.log,fnd_message.get);
396: END IF;
397:
398: IF l_batch_seq_num IS NOT NULL THEN
399:

Line 402: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

398: IF l_batch_seq_num IS NOT NULL THEN
399:
400: FND_MESSAGE.SET_NAME('IGF', 'IGF_SL_PNOTE_BATCH_SEQNO');
401: FND_MESSAGE.SET_TOKEN('PNOTE_BATCH_SEQNO', NVL( l_batch_seq_num, NULL) );
402: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
403:
404: END IF;
405:
406: