APPS.INV_XML_REPORTS dependencies on FND_FILE

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

151: FROM mtl_parameters mp
152: WHERE mp.organization_id = '
153: || p_organization_id;
154:
155: fnd_file.put_line (fnd_file.LOG, query);
156:
157: qryctx := DBMS_XMLGEN.newcontext (QUERY);
158:
159: LOOP

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

172: DBMS_XMLGEN.closecontext (qryctx);
173:
174: EXCEPTION
175: WHEN OTHERS THEN
176: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure LOT_INVENTORY_REPORT ' || SQLCODE || ' ' || SQLERRM);
177: END lot_inventory_report;
178:
179: PROCEDURE lot_master_report (
180: errbuf OUT NOCOPY VARCHAR2

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

238: from mtl_parameters mp
239: where mp.organization_id = '
240: || p_organization_id;
241:
242: fnd_file.put_line (fnd_file.LOG, query);
243: qryctx := DBMS_XMLGEN.newcontext (QUERY);
244:
245: LOOP
246: -- now get the result

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

258: DBMS_XMLGEN.closecontext (qryctx);
259:
260: EXCEPTION
261: WHEN OTHERS THEN
262: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure LOT_MASTER_REPORT ' || SQLCODE || ' ' || SQLERRM);
263: END lot_master_report;
264:
265: PROCEDURE mat_status_def_report (
266: errbuf OUT NOCOPY VARCHAR2

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

369: END IF;
370:
371: QUERY := QUERY || ' ORDER BY mv.status_code ' || l_order;
372:
373: fnd_file.put_line (fnd_file.LOG, query);
374:
375: qryctx := DBMS_XMLGEN.newcontext (QUERY);
376:
377: LOOP

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

390: DBMS_XMLGEN.closecontext (qryctx);
391:
392: EXCEPTION
393: WHEN OTHERS THEN
394: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure MAT_STATUS_DEF_REPORT ' || SQLCODE || ' ' || SQLERRM);
395: END mat_status_def_report;
396:
397: PROCEDURE grade_change_history_report (
398: errbuf OUT NOCOPY VARCHAR2

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

490: || ''''
491: || '
492: ORDER BY msi.concatenated_segments';
493:
494: fnd_file.put_line (fnd_file.LOG, query);
495:
496: qryctx := DBMS_XMLGEN.newcontext (QUERY);
497:
498: LOOP

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

511: DBMS_XMLGEN.closecontext (qryctx);
512:
513: EXCEPTION
514: WHEN OTHERS THEN
515: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure GRADE_CHANGE_HISTORY_REPORT ' || SQLCODE || ' ' || SQLERRM);
516: END grade_change_history_report;
517:
518: /* ***************************************************************
519: * NAME

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

551: LOOP
552: m_file := DBMS_LOB.SUBSTR(l_file, 4000, l_limit);
553: file_varchar2 := TRIM(m_file);
554: file_varchar2 := REPLACE(file_varchar2,'',l_xml_header);
555: fnd_file.put(fnd_file.output, file_varchar2);
556: file_varchar2 := NULL;
557: m_file := NULL;
558:
559: IF l_len > l_limit THEN

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

564: END LOOP;
565:
566: EXCEPTION
567: WHEN OTHERS THEN
568: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure XML_TRANSFER ' || SQLCODE || ' ' || SQLERRM);
569: END xml_transfer;
570:
571: END inv_xml_reports;