APPS.GR_XML_REPORTS dependencies on FND_FILE

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

103: || ' ) DISPATCH_INFO '
104: || ' FROM mtl_parameters mp '
105: || ' WHERE organization_id = ' || p_organization_id;
106:
107: fnd_file.put_line (fnd_file.LOG, l_xml_query);
108:
109: l_queryctx := DBMS_XMLGEN.newcontext (l_xml_query);
110: l_xml_result := DBMS_XMLGEN.getxml (l_queryctx);
111: xml_transfer (p_xml_clob => l_xml_result);

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

112: DBMS_XMLGEN.closecontext (l_queryctx);
113:
114: EXCEPTION
115: WHEN OTHERS THEN
116: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure DISPATCH_HISTORY_REPORT ' || SQLCODE || ' ' || SQLERRM);
117: END dispatch_history_report;
118:
119: PROCEDURE xml_transfer (
120: p_xml_clob IN CLOB) IS

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

129:
130: LOOP
131: IF l_len > l_limit THEN
132: file_varchar2 := DBMS_LOB.SUBSTR (l_file, 4000, l_limit);
133: fnd_file.put (fnd_file.output, file_varchar2);
134: file_varchar2 := NULL;
135: l_limit := l_limit + 4000;
136: ELSE
137: file_varchar2 := DBMS_LOB.SUBSTR (l_file, 4000, l_limit);

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

134: file_varchar2 := NULL;
135: l_limit := l_limit + 4000;
136: ELSE
137: file_varchar2 := DBMS_LOB.SUBSTR (l_file, 4000, l_limit);
138: fnd_file.put (fnd_file.output, file_varchar2);
139: file_varchar2 := NULL;
140: EXIT;
141: END IF;
142: END LOOP;

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

142: END LOOP;
143:
144: EXCEPTION
145: WHEN OTHERS THEN
146: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure XML_TRANSFER ' || SQLCODE || ' ' || SQLERRM);
147: END xml_transfer;
148:
149: END GR_XML_REPORTS;