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

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

250: )';
251: Commneted for bug#11736960 ends */
252:
253: -- Added for bug#12570805
254: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query3);
255: qryCtx := dbms_xmlgen.newContext (l_query3);
256:
257: l_xml_string := '';
258: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

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

254: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query3);
255: qryCtx := dbms_xmlgen.newContext (l_query3);
256:
257: l_xml_string := '';
258: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
260:
261: l_xml_string := '';
262: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

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

255: qryCtx := dbms_xmlgen.newContext (l_query3);
256:
257: l_xml_string := '';
258: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
260:
261: l_xml_string := '';
262: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

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

258: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
260:
261: l_xml_string := '';
262: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
264:
265: --Load 5 records at a time
266: DBMS_XMLGEN.setMaxRows(qryCtx, 5);

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

259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
260:
261: l_xml_string := '';
262: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
264:
265: --Load 5 records at a time
266: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
267: LOOP

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

269: l_result := DBMS_XMLGEN.getXML(qryCtx);
270: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
271: --insert into tab_clob values (to_char(l_xml_string));
272: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
273: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
275:
276: END LOOP;
277:

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

270: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
271: --insert into tab_clob values (to_char(l_xml_string));
272: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
273: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
275:
276: END LOOP;
277:
278: -- Added for bug#12570805

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

275:
276: END LOOP;
277:
278: -- Added for bug#12570805
279: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query4);
280: qryCtx := dbms_xmlgen.newContext (l_query4);
281:
282: --Load 5 records at a time
283: DBMS_XMLGEN.setMaxRows(qryCtx, 5);

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

286: l_result := DBMS_XMLGEN.getXML(qryCtx);
287: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
288: --insert into tab_clob values (to_char(l_xml_string));
289: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
290: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
292:
293: END LOOP;
294:

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

287: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
288: --insert into tab_clob values (to_char(l_xml_string));
289: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
290: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
292:
293: END LOOP;
294:
295: -- Added for bug#11736960

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

292:
293: END LOOP;
294:
295: -- Added for bug#11736960
296: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query1);
297: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_query);
298:
299: -- Added for bug#11736960
300: qryCtx := dbms_xmlgen.newContext (l_query1);

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

293: END LOOP;
294:
295: -- Added for bug#11736960
296: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query1);
297: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_query);
298:
299: -- Added for bug#11736960
300: qryCtx := dbms_xmlgen.newContext (l_query1);
301: --qryCtx := dbms_xmlgen.newContext (l_query);

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

307: l_result := DBMS_XMLGEN.getXML(qryCtx);
308: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
309: --insert into tab_clob values (to_char(l_xml_string));
310: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
311: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
313:
314: END LOOP;
315:

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

308: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
309: --insert into tab_clob values (to_char(l_xml_string));
310: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
311: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
313:
314: END LOOP;
315:
316: -- Added for bug#11736960

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

313:
314: END LOOP;
315:
316: -- Added for bug#11736960
317: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query2);
318:
319: qryCtx := dbms_xmlgen.newContext (l_query2);
320:
321: --Load 5 records at a time

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

325: l_result := DBMS_XMLGEN.getXML(qryCtx);
326: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
327: --insert into tab_clob values (to_char(l_xml_string));
328: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
329: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
330: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
331:
332: END LOOP;
333:

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

326: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
327: --insert into tab_clob values (to_char(l_xml_string));
328: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
329: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
330: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
331:
332: END LOOP;
333:
334: -- Get Name of the business group.

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

340: l_xml_string := ' '|| l_business_group_name ||'
341: ' || to_char(l_report_date, 'dd-Mon-yyyy') ||'
342: ' || p_reporting_year ||'
343: ';
344: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
346:
347: end generate_exception_report;
348:

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

341: ' || to_char(l_report_date, 'dd-Mon-yyyy') ||'
342: ' || p_reporting_year ||'
343: ';
344: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
346:
347: end generate_exception_report;
348:
349: END PER_US_EEO5_EXP_PKG;