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

Line 107: fnd_file.put_line (fnd_file.LOG, query);

103: FROM mtl_parameters mp
104: WHERE mp.organization_id = '
105: || p_organization_id;
106:
107: fnd_file.put_line (fnd_file.LOG, query);
108:
109: qryctx := DBMS_XMLGEN.newcontext (QUERY);
110:
111: LOOP

Line 128: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure LOT_INVENTORY_REPORT ' || SQLCODE || ' ' || SQLERRM);

124: DBMS_XMLGEN.closecontext (qryctx);
125:
126: EXCEPTION
127: WHEN OTHERS THEN
128: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure LOT_INVENTORY_REPORT ' || SQLCODE || ' ' || SQLERRM);
129: END lot_inventory_report;
130:
131: PROCEDURE lot_master_report (
132: errbuf OUT NOCOPY VARCHAR2

Line 193: fnd_file.put_line (fnd_file.LOG, query);

189: from mtl_parameters mp
190: where mp.organization_id = '
191: || p_organization_id;
192:
193: fnd_file.put_line (fnd_file.LOG, query);
194: qryctx := DBMS_XMLGEN.newcontext (QUERY);
195:
196: LOOP
197: -- now get the result

Line 213: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure LOT_MASTER_REPORT ' || SQLCODE || ' ' || SQLERRM);

209: DBMS_XMLGEN.closecontext (qryctx);
210:
211: EXCEPTION
212: WHEN OTHERS THEN
213: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure LOT_MASTER_REPORT ' || SQLCODE || ' ' || SQLERRM);
214: END lot_master_report;
215:
216: PROCEDURE mat_status_def_report (
217: errbuf OUT NOCOPY VARCHAR2

Line 320: fnd_file.put_line (fnd_file.LOG, query);

316: END IF;
317:
318: QUERY := QUERY || ' ORDER BY mv.status_code ' || l_order;
319:
320: fnd_file.put_line (fnd_file.LOG, query);
321:
322: qryctx := DBMS_XMLGEN.newcontext (QUERY);
323:
324: LOOP

Line 341: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure MAT_STATUS_DEF_REPORT ' || SQLCODE || ' ' || SQLERRM);

337: DBMS_XMLGEN.closecontext (qryctx);
338:
339: EXCEPTION
340: WHEN OTHERS THEN
341: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure MAT_STATUS_DEF_REPORT ' || SQLCODE || ' ' || SQLERRM);
342: END mat_status_def_report;
343:
344: PROCEDURE grade_change_history_report (
345: errbuf OUT NOCOPY VARCHAR2

Line 440: fnd_file.put_line (fnd_file.LOG, query);

436: || ''''
437: || '
438: ORDER BY msi.concatenated_segments';
439:
440: fnd_file.put_line (fnd_file.LOG, query);
441:
442: qryctx := DBMS_XMLGEN.newcontext (QUERY);
443:
444: LOOP

Line 461: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure GRADE_CHANGE_HISTORY_REPORT ' || SQLCODE || ' ' || SQLERRM);

457: DBMS_XMLGEN.closecontext (qryctx);
458:
459: EXCEPTION
460: WHEN OTHERS THEN
461: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure GRADE_CHANGE_HISTORY_REPORT ' || SQLCODE || ' ' || SQLERRM);
462: END grade_change_history_report;
463:
464: /* ***************************************************************
465: * NAME

Line 488: fnd_file.put (fnd_file.output, file_varchar2);

484:
485: LOOP
486: IF l_len > l_limit THEN
487: file_varchar2 := DBMS_LOB.SUBSTR (l_file, 4000, l_limit);
488: fnd_file.put (fnd_file.output, file_varchar2);
489: --fnd_file.put (fnd_file.LOG, file_varchar2);
490: file_varchar2 := NULL;
491: l_limit := l_limit + 4000;
492: ELSE

Line 489: --fnd_file.put (fnd_file.LOG, file_varchar2);

485: LOOP
486: IF l_len > l_limit THEN
487: file_varchar2 := DBMS_LOB.SUBSTR (l_file, 4000, l_limit);
488: fnd_file.put (fnd_file.output, file_varchar2);
489: --fnd_file.put (fnd_file.LOG, file_varchar2);
490: file_varchar2 := NULL;
491: l_limit := l_limit + 4000;
492: ELSE
493: file_varchar2 := DBMS_LOB.SUBSTR (l_file, 4000, l_limit);

Line 494: fnd_file.put (fnd_file.output, file_varchar2);

490: file_varchar2 := NULL;
491: l_limit := l_limit + 4000;
492: ELSE
493: file_varchar2 := DBMS_LOB.SUBSTR (l_file, 4000, l_limit);
494: fnd_file.put (fnd_file.output, file_varchar2);
495: --fnd_file.put (fnd_file.LOG, file_varchar2);
496: file_varchar2 := NULL;
497: EXIT;
498: END IF;

Line 495: --fnd_file.put (fnd_file.LOG, file_varchar2);

491: l_limit := l_limit + 4000;
492: ELSE
493: file_varchar2 := DBMS_LOB.SUBSTR (l_file, 4000, l_limit);
494: fnd_file.put (fnd_file.output, file_varchar2);
495: --fnd_file.put (fnd_file.LOG, file_varchar2);
496: file_varchar2 := NULL;
497: EXIT;
498: END IF;
499: END LOOP;

Line 502: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure XML_TRANSFER ' || SQLCODE || ' ' || SQLERRM);

498: END IF;
499: END LOOP;
500: EXCEPTION
501: WHEN OTHERS THEN
502: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure XML_TRANSFER ' || SQLCODE || ' ' || SQLERRM);
503: END xml_transfer;
504: END inv_xml_reports;