147: p_message => l_log_text
148: );
149:
150: l_mesgbuff1:='No Records found for the given Report Date '||p_report_date;
151: fnd_file.put(fnd_file.log,l_mesgbuff1);
152: fnd_file.new_line(fnd_file.log);
153: END IF;
154:
155: END populate_temp;
148: );
149:
150: l_mesgbuff1:='No Records found for the given Report Date '||p_report_date;
151: fnd_file.put(fnd_file.log,l_mesgbuff1);
152: fnd_file.new_line(fnd_file.log);
153: END IF;
154:
155: END populate_temp;
156:
625: END LOOP;
626: END IF;
627:
628: l_count := l_count - 1;
629: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
630: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
631: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
632: -- Write the end tag and close the XML File.
633:
626: END IF;
627:
628: l_count := l_count - 1;
629: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
630: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
631: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
632: -- Write the end tag and close the XML File.
633:
634: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');
627:
628: l_count := l_count - 1;
629: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
630: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
631: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
632: -- Write the end tag and close the XML File.
633:
634: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');
635: IF p_gen_file = 'XML' THEN
630: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
631: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
632: -- Write the end tag and close the XML File.
633:
634: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');
635: IF p_gen_file = 'XML' THEN
636: fnd_file.put_line(fnd_file.log,'XML file : ' || l_output_xml_fname);
637: END IF;
638: IF p_gen_file = 'TEXT' THEN
632: -- Write the end tag and close the XML File.
633:
634: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');
635: IF p_gen_file = 'XML' THEN
636: fnd_file.put_line(fnd_file.log,'XML file : ' || l_output_xml_fname);
637: END IF;
638: IF p_gen_file = 'TEXT' THEN
639: fnd_file.put_line(fnd_file.log,'Text file : ' || l_output_ascii_fname);
640: END IF;
635: IF p_gen_file = 'XML' THEN
636: fnd_file.put_line(fnd_file.log,'XML file : ' || l_output_xml_fname);
637: END IF;
638: IF p_gen_file = 'TEXT' THEN
639: fnd_file.put_line(fnd_file.log,'Text file : ' || l_output_ascii_fname);
640: END IF;
641: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
642:
643: END WritetoFile;
637: END IF;
638: IF p_gen_file = 'TEXT' THEN
639: fnd_file.put_line(fnd_file.log,'Text file : ' || l_output_ascii_fname);
640: END IF;
641: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
642:
643: END WritetoFile;
644:
645: PROCEDURE WriteTagValues(p_eeoc_rec GHR_CPDF_TEMP%ROWTYPE,
843: l_temp := p_tags(l_tags).tagvalue;
844: IF p_gen_file = 'TEXT' THEN
845: utl_file.put_line(p_l_fp,l_temp);
846: END IF;
847: fnd_file.put_line(fnd_file.output,l_temp);
848: ELSE
849: l_temp := p_tags(l_tags).tagvalue || '|';
850: IF p_gen_file = 'TEXT' THEN
851: utl_file.put(p_l_fp,l_temp);
849: l_temp := p_tags(l_tags).tagvalue || '|';
850: IF p_gen_file = 'TEXT' THEN
851: utl_file.put(p_l_fp,l_temp);
852: END IF;
853: fnd_file.put(fnd_file.output,l_temp);
854: END IF;
855: END LOOP;
856: END IF;
857:
877: IF p_gen_file = 'TEXT' THEN
878: utl_file.put(p_l_fp,l_temp);
879: END IF;
880:
881: fnd_file.put(fnd_file.output,l_temp);
882: END LOOP;
883: IF p_gen_file = 'TEXT' THEN
884: utl_file.new_line(p_l_fp);
885: END IF;
882: END LOOP;
883: IF p_gen_file = 'TEXT' THEN
884: utl_file.new_line(p_l_fp);
885: END IF;
886: fnd_file.new_line(fnd_file.output);
887: END;
888:
889:
890: