DBA Data[Home] [Help]

APPS.GHR_EEOC_DYNAMICS_REPORT dependencies on FND_FILE

Line 127: fnd_file.put(fnd_file.log,l_mesgbuff1);

123: p_message => l_log_text
124: );
125:
126: l_mesgbuff1:='No Records found for the period '||p_report_st_dt||' - '||p_report_end_dt;
127: fnd_file.put(fnd_file.log,l_mesgbuff1);
128: fnd_file.new_line(fnd_file.log);
129: END IF;
130:
131: END Populate_temp;

Line 128: fnd_file.new_line(fnd_file.log);

124: );
125:
126: l_mesgbuff1:='No Records found for the period '||p_report_st_dt||' - '||p_report_end_dt;
127: fnd_file.put(fnd_file.log,l_mesgbuff1);
128: fnd_file.new_line(fnd_file.log);
129: END IF;
130:
131: END Populate_temp;
132:

Line 281: fnd_file.put_line(fnd_file.log,'------------------------------------------------');

277: END LOOP;
278: END IF;
279:
280: l_count := l_count - 1;
281: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
282: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
283: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
284: -- Write the end tag and close the XML File.
285:

Line 282: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );

278: END IF;
279:
280: l_count := l_count - 1;
281: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
282: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
283: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
284: -- Write the end tag and close the XML File.
285:
286: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');

Line 283: fnd_file.put_line(fnd_file.log,'------------------------------------------------');

279:
280: l_count := l_count - 1;
281: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
282: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
283: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
284: -- Write the end tag and close the XML File.
285:
286: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');
287: IF p_gen_file = 'XML' THEN

Line 286: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');

282: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
283: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
284: -- Write the end tag and close the XML File.
285:
286: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');
287: IF p_gen_file = 'XML' THEN
288: fnd_file.put_line(fnd_file.log,'XML file : ' || l_output_xml_fname);
289: END IF;
290: IF p_gen_file = 'TEXT' THEN

Line 288: fnd_file.put_line(fnd_file.log,'XML file : ' || l_output_xml_fname);

284: -- Write the end tag and close the XML File.
285:
286: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');
287: IF p_gen_file = 'XML' THEN
288: fnd_file.put_line(fnd_file.log,'XML file : ' || l_output_xml_fname);
289: END IF;
290: IF p_gen_file = 'TEXT' THEN
291: fnd_file.put_line(fnd_file.log,'Text file : ' || l_output_ascii_fname);
292: END IF;

Line 291: fnd_file.put_line(fnd_file.log,'Text file : ' || l_output_ascii_fname);

287: IF p_gen_file = 'XML' THEN
288: fnd_file.put_line(fnd_file.log,'XML file : ' || l_output_xml_fname);
289: END IF;
290: IF p_gen_file = 'TEXT' THEN
291: fnd_file.put_line(fnd_file.log,'Text file : ' || l_output_ascii_fname);
292: END IF;
293: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
294:
295: END WritetoFile;

Line 293: fnd_file.put_line(fnd_file.log,'-------------------------------------------');

289: END IF;
290: IF p_gen_file = 'TEXT' THEN
291: fnd_file.put_line(fnd_file.log,'Text file : ' || l_output_ascii_fname);
292: END IF;
293: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
294:
295: END WritetoFile;
296:
297: PROCEDURE WriteTagValues(p_eeoc_rec GHR_CPDF_TEMP%ROWTYPE,

Line 394: fnd_file.put_line(fnd_file.output,l_temp);

390: l_temp := p_tags(l_tags).tagvalue;
391: IF p_gen_file = 'TEXT' THEN
392: utl_file.put_line(p_l_fp,l_temp);
393: END IF;
394: fnd_file.put_line(fnd_file.output,l_temp);
395: ELSE
396: l_temp := p_tags(l_tags).tagvalue || '|';
397: IF p_gen_file = 'TEXT' THEN
398: utl_file.put(p_l_fp,l_temp);

Line 400: fnd_file.put(fnd_file.output,l_temp);

396: l_temp := p_tags(l_tags).tagvalue || '|';
397: IF p_gen_file = 'TEXT' THEN
398: utl_file.put(p_l_fp,l_temp);
399: END IF;
400: fnd_file.put(fnd_file.output,l_temp);
401: END IF;
402: END LOOP;
403: END IF;
404:

Line 428: fnd_file.put(fnd_file.output,l_temp);

424: IF p_gen_file = 'TEXT' THEN
425: utl_file.put(p_l_fp,l_temp);
426: END IF;
427:
428: fnd_file.put(fnd_file.output,l_temp);
429: END LOOP;
430: IF p_gen_file = 'TEXT' THEN
431: utl_file.new_line(p_l_fp);
432: END IF;

Line 433: fnd_file.new_line(fnd_file.output);

429: END LOOP;
430: IF p_gen_file = 'TEXT' THEN
431: utl_file.new_line(p_l_fp);
432: END IF;
433: fnd_file.new_line(fnd_file.output);
434: END;
435:
436:
437: PROCEDURE Eeoc_Dynamics_Main( errbuf OUT NOCOPY VARCHAR2