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

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

384: Commneted for bug#11736960 ends */
385:
386: -- Added for bug#12570805
387: IF (hr_utility.debug_enabled) THEN
388: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query3);
389: END IF;
390: qryCtx := dbms_xmlgen.newContext (l_query3);
391:
392: l_xml_string := '';

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

389: END IF;
390: qryCtx := dbms_xmlgen.newContext (l_query3);
391:
392: l_xml_string := '';
393: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
395:
396: l_xml_string := '';
397: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

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

390: qryCtx := dbms_xmlgen.newContext (l_query3);
391:
392: l_xml_string := '';
393: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
395:
396: l_xml_string := '';
397: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
398: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

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

393: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
395:
396: l_xml_string := '';
397: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
398: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
399:
400: --Load 5 records at a time
401: DBMS_XMLGEN.setMaxRows(qryCtx, 5);

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

394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
395:
396: l_xml_string := '';
397: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
398: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
399:
400: --Load 5 records at a time
401: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
402: LOOP

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

404: l_result := DBMS_XMLGEN.getXML(qryCtx);
405: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
406: --insert into tab_clob values (to_char(l_xml_string));
407: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
408: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
409: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
410:
411: END LOOP;
412:

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

405: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
406: --insert into tab_clob values (to_char(l_xml_string));
407: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
408: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
409: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
410:
411: END LOOP;
412:
413: -- Added for bug#12570805

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

411: END LOOP;
412:
413: -- Added for bug#12570805
414: IF (hr_utility.debug_enabled) THEN
415: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query4);
416: END IF;
417: qryCtx := dbms_xmlgen.newContext (l_query4);
418:
419: --Load 5 records at a time

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

423: l_result := DBMS_XMLGEN.getXML(qryCtx);
424: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
425: --insert into tab_clob values (to_char(l_xml_string));
426: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
427: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
429:
430: END LOOP;
431:

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

424: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
425: --insert into tab_clob values (to_char(l_xml_string));
426: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
427: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
428: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
429:
430: END LOOP;
431:
432: -- Added for bug#11736960

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

430: END LOOP;
431:
432: -- Added for bug#11736960
433: IF (hr_utility.debug_enabled) THEN
434: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query1);
435: END IF;
436: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_query);
437:
438: -- Added for bug#11736960

Line 436: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_query);

432: -- Added for bug#11736960
433: IF (hr_utility.debug_enabled) THEN
434: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query1);
435: END IF;
436: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_query);
437:
438: -- Added for bug#11736960
439: qryCtx := dbms_xmlgen.newContext (l_query1);
440: --qryCtx := dbms_xmlgen.newContext (l_query);

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

446: l_result := DBMS_XMLGEN.getXML(qryCtx);
447: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
448: --insert into tab_clob values (to_char(l_xml_string));
449: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
450: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
452:
453: END LOOP;
454:

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

447: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
448: --insert into tab_clob values (to_char(l_xml_string));
449: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
450: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
451: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
452:
453: END LOOP;
454:
455: -- Added for bug#11736960

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

453: END LOOP;
454:
455: -- Added for bug#11736960
456: IF (hr_utility.debug_enabled) THEN
457: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query2);
458: END IF;
459:
460: qryCtx := dbms_xmlgen.newContext (l_query2);
461:

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

466: l_result := DBMS_XMLGEN.getXML(qryCtx);
467: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
468: --insert into tab_clob values (to_char(l_xml_string));
469: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
470: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
471: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
472:
473: END LOOP;
474:

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

467: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
468: --insert into tab_clob values (to_char(l_xml_string));
469: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
470: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
471: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
472:
473: END LOOP;
474:
475: --execute l_query5,added for bug 14034810

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

473: END LOOP;
474:
475: --execute l_query5,added for bug 14034810
476: IF (hr_utility.debug_enabled) THEN
477: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query5);
478: END IF;
479: qryCtx := dbms_xmlgen.newContext (l_query5);
480:
481: --Load 5 records at a time

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

489: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
490:
491: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
492:
493: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
495: END LOOP;
496:
497: -- Get Name of the business group.

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

490:
491: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
492:
493: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
494: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
495: END LOOP;
496:
497: -- Get Name of the business group.
498: SELECT name into l_business_group_name from hr_organization_units

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

503: l_xml_string := ' '|| l_business_group_name ||'
504: ' || to_char(l_report_date, 'dd-Mon-yyyy') ||'
505: ' || p_reporting_year ||'
506: ';
507: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
508: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
509:
510: end generate_exception_report;
511:

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

504: ' || to_char(l_report_date, 'dd-Mon-yyyy') ||'
505: ' || p_reporting_year ||'
506: ';
507: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
508: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
509:
510: end generate_exception_report;
511:
512: END PER_US_EEO4_EXP_PKG;