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

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

200: FETCH c_batch INTO c_batch_rec;
201: IF c_batch%FOUND THEN
202: CLOSE c_batch;
203: FND_MESSAGE.SET_NAME('IGF','IGF_GE_BATCH_ALREADY_LOADED');
204: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
205: RETURN;
206: END IF;
207: CLOSE c_batch;
208:

Line 269: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

265: l_processed_count := l_processed_count +1 ;
266: ELSE
267: fnd_message.set_name('IGF','IGF_SL_INVALID_RECORD');
268: fnd_message.set_token('BATCH_ID',SUBSTR(loadrec.record_data, 2,23));
269: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
270: END IF;
271: EXCEPTION
272: WHEN OTHERS THEN
273: fnd_message.set_name('IGF','IGF_SL_INVALID_RECORD');

Line 275: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

271: EXCEPTION
272: WHEN OTHERS THEN
273: fnd_message.set_name('IGF','IGF_SL_INVALID_RECORD');
274: fnd_message.set_token('BATCH_ID',SUBSTR(loadrec.record_data, 2,23));
275: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
276: END ;
277:
278: END LOOP;
279:

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

278: END LOOP;
279:
280: FND_MESSAGE.SET_NAME('IGF','IGF_DB_YTD_SUM_FET');
281: FND_MESSAGE.SET_TOKEN('VALUE',(l_n_last_lort_id-2));
282: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
283:
284: FND_MESSAGE.SET_NAME('IGF','IGF_DB_YTD_SCHOOL_AWARD');
285: FND_MESSAGE.SET_TOKEN('VALUE',p_school_code);
286: FND_MESSAGE.SET_TOKEN('AWD_YR',p_award_year);

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

283:
284: FND_MESSAGE.SET_NAME('IGF','IGF_DB_YTD_SCHOOL_AWARD');
285: FND_MESSAGE.SET_TOKEN('VALUE',p_school_code);
286: FND_MESSAGE.SET_TOKEN('AWD_YR',p_award_year);
287: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
288:
289: FND_MESSAGE.SET_NAME('IGF','IGF_DB_YTD_SUM_PRO');
290: FND_MESSAGE.SET_TOKEN('VALUE',l_processed_count);
291: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

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

287: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
288:
289: FND_MESSAGE.SET_NAME('IGF','IGF_DB_YTD_SUM_PRO');
290: FND_MESSAGE.SET_TOKEN('VALUE',l_processed_count);
291: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
292:
293: FND_MESSAGE.SET_NAME('IGF','IGF_DB_YTD_SUM_REJ');
294: FND_MESSAGE.SET_TOKEN('VALUE',((l_n_last_lort_id-2) - l_processed_count));
295: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

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

291: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
292:
293: FND_MESSAGE.SET_NAME('IGF','IGF_DB_YTD_SUM_REJ');
294: FND_MESSAGE.SET_TOKEN('VALUE',((l_n_last_lort_id-2) - l_processed_count));
295: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
296:
297: EXCEPTION
298: WHEN INV_TRL_NUM THEN
299: RAISE;

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

398: FETCH c_batch INTO c_batch_rec;
399: IF c_batch%FOUND THEN
400: CLOSE c_batch;
401: FND_MESSAGE.SET_NAME('IGF','IGF_GE_BATCH_ALREADY_LOADED');
402: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
403: RETURN;
404: END IF;
405: CLOSE c_batch;
406:

Line 482: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

478: l_processed_count := l_processed_count +1;
479: ELSE
480: fnd_message.set_name('IGF','IGF_SL_INVALID_RECORD');
481: fnd_message.set_token('BATCH_ID',SUBSTR(loadrec.record_data, 2,23));
482: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
483: END IF;
484:
485: EXCEPTION
486: WHEN INV_TRL_NUM THEN

Line 491: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

487: RAISE;
488: WHEN OTHERS THEN
489: fnd_message.set_name('IGF','IGF_SL_INVALID_RECORD');
490: fnd_message.set_token('BATCH_ID',SUBSTR(loadrec.record_data, 2,23));
491: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
492: END ;
493:
494: END LOOP;
495:

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

494: END LOOP;
495:
496: FND_MESSAGE.SET_NAME('IGF','IGF_DB_YTD_DET_FET');
497: FND_MESSAGE.SET_TOKEN('VALUE',(l_n_last_lort_id-2));
498: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
499:
500: FND_MESSAGE.SET_NAME('IGF','IGF_DB_YTD_SCHOOL_AWD_DTL');
501: FND_MESSAGE.SET_TOKEN('VALUE',p_school_code);
502: FND_MESSAGE.SET_TOKEN('AWD_YR',p_award_year);

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

499:
500: FND_MESSAGE.SET_NAME('IGF','IGF_DB_YTD_SCHOOL_AWD_DTL');
501: FND_MESSAGE.SET_TOKEN('VALUE',p_school_code);
502: FND_MESSAGE.SET_TOKEN('AWD_YR',p_award_year);
503: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
504:
505: FND_MESSAGE.SET_NAME('IGF','IGF_DB_YTD_DET_PRO');
506: FND_MESSAGE.SET_TOKEN('VALUE',l_processed_count);
507: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

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

503: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
504:
505: FND_MESSAGE.SET_NAME('IGF','IGF_DB_YTD_DET_PRO');
506: FND_MESSAGE.SET_TOKEN('VALUE',l_processed_count);
507: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
508:
509: FND_MESSAGE.SET_NAME('IGF','IGF_DB_YTD_DET_REJ');
510: FND_MESSAGE.SET_TOKEN('VALUE',((l_n_last_lort_id-2) - l_processed_count));
511: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

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

507: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
508:
509: FND_MESSAGE.SET_NAME('IGF','IGF_DB_YTD_DET_REJ');
510: FND_MESSAGE.SET_TOKEN('VALUE',((l_n_last_lort_id-2) - l_processed_count));
511: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
512:
513: EXCEPTION
514:
515: WHEN INV_TRL_NUM THEN

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

572: --Checking if the data setup for the version is there or not
573: IF c_get_ver%NOTFOUND THEN
574: CLOSE c_get_ver;
575: FND_MESSAGE.SET_NAME('IGF','IGF_DB_DL_VERSION_FALSE');
576: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
577: RETURN;
578: ELSE
579: l_award_year:=c_get_ver_rec.ci_alternate_code;
580:

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

663: --Checking if the data setup for the version is there or not
664: IF c_get_ver%NOTFOUND THEN
665: CLOSE c_get_ver;
666: FND_MESSAGE.SET_NAME('IGF','IGF_DB_DL_VERSION_FALSE');
667: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
668: RETURN;
669: ELSE
670: l_award_year :=c_get_ver_rec.ci_alternate_code;
671: