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

Line 72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_reporting_date =' || p_report_date);

68: l_pr VARCHAR2(2000);
69: l_pt VARCHAR2(2000);
70: begin
71:
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_reporting_date =' || p_report_date);
73: l_report_date := fnd_date.canonical_to_date(p_report_date); --to_date(p_report_date,'YYYY/MM/DD HH24:MI:SS');
74: pqh_employment_category.fetch_empl_categories(p_business_group_id
75: ,l_fr
76: ,l_ft

Line 80: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_reporting_year =' || l_reporting_year);

76: ,l_ft
77: ,l_pr
78: ,l_pt);
79:
80: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_reporting_year =' || l_reporting_year);
81:
82: /* Commented for bug#11736960
83: l_query := 'SELECT peo.full_name name,
84: peo.employee_number employee_number,

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

445:
446:
447: l_xml_string := '';
448:
449: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
451:
452: l_xml_string := '';
453: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

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

446:
447: l_xml_string := '';
448:
449: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
451:
452: l_xml_string := '';
453: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

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

449: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
451:
452: l_xml_string := '';
453: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
455:
456: IF p_race_gender = 'Y' THEN --#14831074
457: -- Added for bug#11736960

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

450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
451:
452: l_xml_string := '';
453: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
455:
456: IF p_race_gender = 'Y' THEN --#14831074
457: -- Added for bug#11736960
458: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query1);

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

454: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
455:
456: IF p_race_gender = 'Y' THEN --#14831074
457: -- Added for bug#11736960
458: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query1);
459: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_query);
460:
461: -- Added for bug#11736960
462: qryCtx := dbms_xmlgen.newContext (l_query1);

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

455:
456: IF p_race_gender = 'Y' THEN --#14831074
457: -- Added for bug#11736960
458: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query1);
459: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_query);
460:
461: -- Added for bug#11736960
462: qryCtx := dbms_xmlgen.newContext (l_query1);
463: --qryCtx := dbms_xmlgen.newContext (l_query);

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

468: --save the XML into the CLOB field
469: l_result := DBMS_XMLGEN.getXML(qryCtx);
470: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
471: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
472: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
474:
475: END LOOP;
476:

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

469: l_result := DBMS_XMLGEN.getXML(qryCtx);
470: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
471: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
472: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
473: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
474:
475: END LOOP;
476:
477: -- Added for bug#11736960

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

474:
475: END LOOP;
476:
477: -- Added for bug#11736960
478: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query2);
479:
480: qryCtx := dbms_xmlgen.newContext (l_query2);
481:
482: --Load 5 records at a time

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

485: --save the XML into the CLOB field
486: l_result := DBMS_XMLGEN.getXML(qryCtx);
487: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
488: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
489: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
491:
492: END LOOP;
493: END IF; --#14831074

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

486: l_result := DBMS_XMLGEN.getXML(qryCtx);
487: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
488: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
489: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
491:
492: END LOOP;
493: END IF; --#14831074
494:

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

492: END LOOP;
493: END IF; --#14831074
494:
495: -- Added for bug #14831074 start
496: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query3);
497:
498: qryCtx := dbms_xmlgen.newContext (l_query3);
499:
500: --Load 5 records at a time

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

503: --save the XML into the CLOB field
504: l_result := DBMS_XMLGEN.getXML(qryCtx);
505: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
506: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
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 LOOP;
511:

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

504: l_result := DBMS_XMLGEN.getXML(qryCtx);
505: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
506: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
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 LOOP;
511:
512: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query4);

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

508: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
509:
510: END LOOP;
511:
512: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query4);
513:
514: qryCtx := dbms_xmlgen.newContext (l_query4);
515:
516: --Load 5 records at a time

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

519: --save the XML into the CLOB field
520: l_result := DBMS_XMLGEN.getXML(qryCtx);
521: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
522: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
523: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
524: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
525:
526: END LOOP;
527:

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

520: l_result := DBMS_XMLGEN.getXML(qryCtx);
521: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
522: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
523: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
524: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
525:
526: END LOOP;
527:
528: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query5);

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

524: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
525:
526: END LOOP;
527:
528: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query5);
529:
530: qryCtx := dbms_xmlgen.newContext (l_query5);
531:
532: --Load 5 records at a time

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

535: --save the XML into the CLOB field
536: l_result := DBMS_XMLGEN.getXML(qryCtx);
537: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
538: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
539: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
541:
542: END LOOP;
543:

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

536: l_result := DBMS_XMLGEN.getXML(qryCtx);
537: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
538: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
539: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
541:
542: END LOOP;
543:
544: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query6);

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

540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
541:
542: END LOOP;
543:
544: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query6);
545:
546: qryCtx := dbms_xmlgen.newContext (l_query6);
547:
548: --Load 5 records at a time

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

551: --save the XML into the CLOB field
552: l_result := DBMS_XMLGEN.getXML(qryCtx);
553: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
554: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
555: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
557:
558: END LOOP;
559:

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

552: l_result := DBMS_XMLGEN.getXML(qryCtx);
553: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
554: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
555: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
557:
558: END LOOP;
559:
560: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query7);

Line 560: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query7);

556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
557:
558: END LOOP;
559:
560: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query7);
561:
562: qryCtx := dbms_xmlgen.newContext (l_query7);
563:
564: --Load 5 records at a time

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

567: --save the XML into the CLOB field
568: l_result := DBMS_XMLGEN.getXML(qryCtx);
569: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
570: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
571: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
572: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
573:
574: END LOOP;
575:

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

568: l_result := DBMS_XMLGEN.getXML(qryCtx);
569: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
570: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
571: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
572: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
573:
574: END LOOP;
575:
576: IF (NVL(p_tenured,'N') = 'Y') THEN

Line 577: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query8);

573:
574: END LOOP;
575:
576: IF (NVL(p_tenured,'N') = 'Y') THEN
577: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query8);
578:
579: qryCtx := dbms_xmlgen.newContext (l_query8);
580:
581: --Load 5 records at a time

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

584: --save the XML into the CLOB field
585: l_result := DBMS_XMLGEN.getXML(qryCtx);
586: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
587: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
588: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
589: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
590: END LOOP;
591: END IF;
592: -- Added for bug #14831074 end

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

585: l_result := DBMS_XMLGEN.getXML(qryCtx);
586: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
587: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
588: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
589: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
590: END LOOP;
591: END IF;
592: -- Added for bug #14831074 end
593:

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

600: l_xml_string := ' '|| l_business_group_name ||'
601: ' || to_char(l_report_date, 'dd-Mon-yyyy') ||'
602: ' || to_char(l_report_date, 'yyyy') ||'
603: ';
604: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
605: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
606:
607: end generate_exception_report;
608:

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

601: ' || to_char(l_report_date, 'dd-Mon-yyyy') ||'
602: ' || to_char(l_report_date, 'yyyy') ||'
603: ';
604: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
605: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
606:
607: end generate_exception_report;
608:
609: END PER_US_IPEDS_EXP_PKG;