1577: l_output_xml_fname := l_audit_log_dir || '\' || l_xml_file_name;
1578: l_output_ascii_fname := l_audit_log_dir || '\' || l_ascii_file_name;
1579: END IF;
1580:
1581: -- fnd_file.put_line(fnd_file.log,'-----'||l_audit_log_dir);
1582: p_ascii_fp := utl_file.fopen(l_audit_log_dir,l_ascii_file_name,'w',32767);
1583:
1584: IF p_gen_xml_file = 'Y' THEN
1585: p_xml_fp := utl_file.fopen(l_audit_log_dir,l_xml_file_name,'w',32767);
1639: END LOOP;
1640: END IF; -- IF p_gen_xml_file = 'Y' THEN
1641:
1642: l_count := l_count - 1;
1643: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
1644: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
1645: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
1646:
1647: IF p_gen_xml_file = 'Y' OR p_gen_txt_file = 'Y' THEN
1640: END IF; -- IF p_gen_xml_file = 'Y' THEN
1641:
1642: l_count := l_count - 1;
1643: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
1644: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
1645: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
1646:
1647: IF p_gen_xml_file = 'Y' OR p_gen_txt_file = 'Y' THEN
1648: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');
1641:
1642: l_count := l_count - 1;
1643: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
1644: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
1645: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
1646:
1647: IF p_gen_xml_file = 'Y' OR p_gen_txt_file = 'Y' THEN
1648: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');
1649: IF p_gen_xml_file = 'Y' THEN
1644: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
1645: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
1646:
1647: IF p_gen_xml_file = 'Y' OR p_gen_txt_file = 'Y' THEN
1648: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');
1649: IF p_gen_xml_file = 'Y' THEN
1650: fnd_file.put_line(fnd_file.log,'XML file : ' || l_output_xml_fname);
1651: END IF;
1652: IF p_gen_txt_file = 'Y' THEN
1646:
1647: IF p_gen_xml_file = 'Y' OR p_gen_txt_file = 'Y' THEN
1648: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');
1649: IF p_gen_xml_file = 'Y' THEN
1650: fnd_file.put_line(fnd_file.log,'XML file : ' || l_output_xml_fname);
1651: END IF;
1652: IF p_gen_txt_file = 'Y' THEN
1653: fnd_file.put_line(fnd_file.log,'Text file : ' || l_output_ascii_fname);
1654: END IF;
1649: IF p_gen_xml_file = 'Y' THEN
1650: fnd_file.put_line(fnd_file.log,'XML file : ' || l_output_xml_fname);
1651: END IF;
1652: IF p_gen_txt_file = 'Y' THEN
1653: fnd_file.put_line(fnd_file.log,'Text file : ' || l_output_ascii_fname);
1654: END IF;
1655: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
1656: END IF;
1657:
1651: END IF;
1652: IF p_gen_txt_file = 'Y' THEN
1653: fnd_file.put_line(fnd_file.log,'Text file : ' || l_output_ascii_fname);
1654: END IF;
1655: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
1656: END IF;
1657:
1658: END WritetoFile;
1659:
2289: l_temp := p_tags(l_tags).tagvalue;
2290: IF p_gen_txt_file = 'Y' THEN
2291: utl_file.put_line(p_l_fp,l_temp);
2292: END IF;
2293: fnd_file.put_line(fnd_file.output,l_temp);
2294: ELSE
2295: l_temp := p_tags(l_tags).tagvalue || '|';
2296: IF p_gen_txt_file = 'Y' THEN
2297: utl_file.put(p_l_fp,l_temp);
2295: l_temp := p_tags(l_tags).tagvalue || '|';
2296: IF p_gen_txt_file = 'Y' THEN
2297: utl_file.put(p_l_fp,l_temp);
2298: END IF;
2299: fnd_file.put(fnd_file.output,l_temp);
2300: END IF;
2301: END LOOP;
2302: END IF;
2303:
4464: p_message => l_log_text
4465: );
4466:
4467: l_mesgbuff1:='No Records found for the period '||p_start_Date||' - '||p_end_date;
4468: fnd_file.put(fnd_file.log,l_mesgbuff1);
4469: fnd_file.new_line(fnd_file.log);
4470: END IF;
4471:
4472: ELSE -- DATES are not proper
4465: );
4466:
4467: l_mesgbuff1:='No Records found for the period '||p_start_Date||' - '||p_end_date;
4468: fnd_file.put(fnd_file.log,l_mesgbuff1);
4469: fnd_file.new_line(fnd_file.log);
4470: END IF;
4471:
4472: ELSE -- DATES are not proper
4473: l_message_name:= 'CHECK_REPORT_FROM_TO_DATES';