DBA Data[Home] [Help]

APPS.GHR_EHRI_DYNRPT dependencies on FND_FILE

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

1524: l_output_xml_fname := l_audit_log_dir || '\' || l_xml_file_name;
1525: l_output_ascii_fname := l_audit_log_dir || '\' || l_ascii_file_name;
1526: END IF;
1527:
1528: -- fnd_file.put_line(fnd_file.log,'-----'||l_audit_log_dir);
1529: p_ascii_fp := utl_file.fopen(l_audit_log_dir,l_ascii_file_name,'w',32767);
1530:
1531: IF p_gen_xml_file = 'Y' THEN
1532: p_xml_fp := utl_file.fopen(l_audit_log_dir,l_xml_file_name,'w',32767);

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

1586: END LOOP;
1587: END IF; -- IF p_gen_xml_file = 'Y' THEN
1588:
1589: l_count := l_count - 1;
1590: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
1591: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
1592: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
1593:
1594: IF p_gen_xml_file = 'Y' OR p_gen_txt_file = 'Y' THEN

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

1587: END IF; -- IF p_gen_xml_file = 'Y' THEN
1588:
1589: l_count := l_count - 1;
1590: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
1591: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
1592: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
1593:
1594: IF p_gen_xml_file = 'Y' OR p_gen_txt_file = 'Y' THEN
1595: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');

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

1588:
1589: l_count := l_count - 1;
1590: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
1591: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
1592: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
1593:
1594: IF p_gen_xml_file = 'Y' OR p_gen_txt_file = 'Y' THEN
1595: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');
1596: IF p_gen_xml_file = 'Y' THEN

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

1591: fnd_file.put_line(fnd_file.log,'Total Records : ' || l_count );
1592: fnd_file.put_line(fnd_file.log,'------------------------------------------------');
1593:
1594: IF p_gen_xml_file = 'Y' OR p_gen_txt_file = 'Y' THEN
1595: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');
1596: IF p_gen_xml_file = 'Y' THEN
1597: fnd_file.put_line(fnd_file.log,'XML file : ' || l_output_xml_fname);
1598: END IF;
1599: IF p_gen_txt_file = 'Y' THEN

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

1593:
1594: IF p_gen_xml_file = 'Y' OR p_gen_txt_file = 'Y' THEN
1595: fnd_file.put_line(fnd_file.log,'------------Path of output file----------------');
1596: IF p_gen_xml_file = 'Y' THEN
1597: fnd_file.put_line(fnd_file.log,'XML file : ' || l_output_xml_fname);
1598: END IF;
1599: IF p_gen_txt_file = 'Y' THEN
1600: fnd_file.put_line(fnd_file.log,'Text file : ' || l_output_ascii_fname);
1601: END IF;

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

1596: IF p_gen_xml_file = 'Y' THEN
1597: fnd_file.put_line(fnd_file.log,'XML file : ' || l_output_xml_fname);
1598: END IF;
1599: IF p_gen_txt_file = 'Y' THEN
1600: fnd_file.put_line(fnd_file.log,'Text file : ' || l_output_ascii_fname);
1601: END IF;
1602: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
1603: END IF;
1604:

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

1598: END IF;
1599: IF p_gen_txt_file = 'Y' THEN
1600: fnd_file.put_line(fnd_file.log,'Text file : ' || l_output_ascii_fname);
1601: END IF;
1602: fnd_file.put_line(fnd_file.log,'-------------------------------------------');
1603: END IF;
1604:
1605: END WritetoFile;
1606:

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

2222: l_temp := p_tags(l_tags).tagvalue;
2223: IF p_gen_txt_file = 'Y' THEN
2224: utl_file.put_line(p_l_fp,l_temp);
2225: END IF;
2226: fnd_file.put_line(fnd_file.output,l_temp);
2227: ELSE
2228: l_temp := p_tags(l_tags).tagvalue || '|';
2229: IF p_gen_txt_file = 'Y' THEN
2230: utl_file.put(p_l_fp,l_temp);

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

2228: l_temp := p_tags(l_tags).tagvalue || '|';
2229: IF p_gen_txt_file = 'Y' THEN
2230: utl_file.put(p_l_fp,l_temp);
2231: END IF;
2232: fnd_file.put(fnd_file.output,l_temp);
2233: END IF;
2234: END LOOP;
2235: END IF;
2236:

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

4165: p_message => l_log_text
4166: );
4167:
4168: l_mesgbuff1:='No Records found for the period '||p_start_Date||' - '||p_end_date;
4169: fnd_file.put(fnd_file.log,l_mesgbuff1);
4170: fnd_file.new_line(fnd_file.log);
4171: END IF;
4172:
4173: ELSE -- DATES are not proper

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

4166: );
4167:
4168: l_mesgbuff1:='No Records found for the period '||p_start_Date||' - '||p_end_date;
4169: fnd_file.put(fnd_file.log,l_mesgbuff1);
4170: fnd_file.new_line(fnd_file.log);
4171: END IF;
4172:
4173: ELSE -- DATES are not proper
4174: l_message_name:= 'CHECK_REPORT_FROM_TO_DATES';