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.PER_US_EEO4A_EXP_PKG dependencies on FND_FILE

Line 344: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query3);

340: )';
341:
342: --execute l_query3
343: IF (hr_utility.debug_enabled) THEN
344: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query3);
345: END IF;
346:
347: qryCtx := dbms_xmlgen.newContext (l_query3);
348: l_xml_string := '';

Line 349: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

345: END IF;
346:
347: qryCtx := dbms_xmlgen.newContext (l_query3);
348: l_xml_string := '';
349: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
351:
352: l_xml_string := '';
353: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

Line 350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

346:
347: qryCtx := dbms_xmlgen.newContext (l_query3);
348: l_xml_string := '';
349: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
351:
352: l_xml_string := '';
353: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

Line 353: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

349: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
351:
352: l_xml_string := '';
353: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
355:
356: --Load 5 records at a time
357: DBMS_XMLGEN.setMaxRows(qryCtx, 5);

Line 354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

350: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
351:
352: l_xml_string := '';
353: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
354: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
355:
356: --Load 5 records at a time
357: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
358:

Line 367: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

363: --Extract the 5 records
364: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
365: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
366:
367: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
368: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
369: END LOOP;
370:
371: --execute l_query5

Line 368: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

364: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
365: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
366:
367: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
368: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
369: END LOOP;
370:
371: --execute l_query5
372: IF (hr_utility.debug_enabled) THEN

Line 373: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query5);

369: END LOOP;
370:
371: --execute l_query5
372: IF (hr_utility.debug_enabled) THEN
373: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query5);
374: END IF;
375: qryCtx := dbms_xmlgen.newContext (l_query5);
376:
377: --Load 5 records at a time

Line 389: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

385: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
386:
387: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
388:
389: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
391: END LOOP;
392:
393: --execute l_query4

Line 390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

386:
387: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
388:
389: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
391: END LOOP;
392:
393: --execute l_query4
394: IF (hr_utility.debug_enabled) THEN

Line 395: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query4);

391: END LOOP;
392:
393: --execute l_query4
394: IF (hr_utility.debug_enabled) THEN
395: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query4);
396: END IF;
397: qryCtx := dbms_xmlgen.newContext (l_query4);
398:
399: --Load 5 records at a time

Line 411: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

407: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
408:
409: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
410:
411: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
413: END LOOP;
414:
415: --execute l_query1

Line 412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

408:
409: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
410:
411: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
413: END LOOP;
414:
415: --execute l_query1
416: IF (hr_utility.debug_enabled) THEN

Line 417: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query1);

413: END LOOP;
414:
415: --execute l_query1
416: IF (hr_utility.debug_enabled) THEN
417: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query1);
418: END IF;
419: qryCtx := dbms_xmlgen.newContext (l_query1);
420:
421: --Load 5 records at a time

Line 433: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

429: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
430:
431: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
432:
433: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
434: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
435: END LOOP;
436:
437: --execute l_query2

Line 434: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

430:
431: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
432:
433: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
434: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
435: END LOOP;
436:
437: --execute l_query2
438: IF (hr_utility.debug_enabled) THEN

Line 439: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query2);

435: END LOOP;
436:
437: --execute l_query2
438: IF (hr_utility.debug_enabled) THEN
439: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query2);
440: END IF;
441: qryCtx := dbms_xmlgen.newContext (l_query2);
442:
443: --Load 5 records at a time

Line 455: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

451: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
452:
453: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
454:
455: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
457: END LOOP;
458:
459: --execute l_query6

Line 456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

452:
453: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
454:
455: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
457: END LOOP;
458:
459: --execute l_query6
460: IF (hr_utility.debug_enabled) THEN

Line 461: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query6);

457: END LOOP;
458:
459: --execute l_query6
460: IF (hr_utility.debug_enabled) THEN
461: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query6);
462: END IF;
463: qryCtx := dbms_xmlgen.newContext (l_query6);
464:
465: --Load 5 records at a time

Line 477: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

473: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
474:
475: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
476:
477: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
478: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
479: END LOOP;
480:
481: -- get the name of the business group.

Line 478: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

474:
475: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
476:
477: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
478: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
479: END LOOP;
480:
481: -- get the name of the business group.
482: SELECT name into l_business_group_name

Line 493: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

489: ' || to_char(l_report_date, 'dd-Mon-yyyy') ||'
490: ' || p_reporting_year ||'
491: ';
492:
493: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
495:
496: END generate_exception_report;
497:

Line 494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

490: ' || p_reporting_year ||'
491: ';
492:
493: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
495:
496: END generate_exception_report;
497:
498: END PER_US_EEO4A_EXP_PKG;