DBA Data[Home] [Help]

APPS.GHR_EHRI_DYNRPT dependencies on FND_FILE

Line 1581: -- fnd_file.put_line(fnd_file.log,'-----'||l_audit_log_dir);

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);

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

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

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

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----------------');

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

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

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

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

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

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;

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

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:

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

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:

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

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);

Line 2299: fnd_file.put(fnd_file.output,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:

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

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

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

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';