1037: end loop;
1038: */
1039:
1040: hr_utility.trace( 'B4 formated header string ');
1041: fnd_file.put_line(fnd_file.output,
1042: formated_header_string(gv_title,'HTML'));
1043: fnd_file.new_line(fnd_file.output,1);
1044: hr_utility.trace( 'A4 formated header string new line ');
1045: /****************************************************************
1039:
1040: hr_utility.trace( 'B4 formated header string ');
1041: fnd_file.put_line(fnd_file.output,
1042: formated_header_string(gv_title,'HTML'));
1043: fnd_file.new_line(fnd_file.output,1);
1044: hr_utility.trace( 'A4 formated header string new line ');
1045: /****************************************************************
1046: ** Print the Header Information. If the format is HTML then open
1047: ** the body and table before printing the header info, otherwise
1048: ** just print the header information.
1049: ****************************************************************/
1050: if l_output_file_type ='HTML' then
1051:
1052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1053: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
1073: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_value);
1074: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_type);
1075: end loop ;
1076:
1077: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
1074: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_type);
1075: end loop ;
1076:
1077: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
1195: hr_utility.trace('Exception value found for '||ee_last_name);
1196:
1197: IF c_ee_exception%ROWCOUNT =1 THEN
1198:
1199: fnd_file.put_line(fnd_file.output
1200: ,employee_header('CSV','Header1',p_report_type));
1201:
1202: fnd_file.new_line(fnd_file.output,1);
1203:
1198:
1199: fnd_file.put_line(fnd_file.output
1200: ,employee_header('CSV','Header1',p_report_type));
1201:
1202: fnd_file.new_line(fnd_file.output,1);
1203:
1204: fnd_file.put_line(fnd_file.output
1205: ,employee_header('CSV','Header2',p_report_type));
1206:
1200: ,employee_header('CSV','Header1',p_report_type));
1201:
1202: fnd_file.new_line(fnd_file.output,1);
1203:
1204: fnd_file.put_line(fnd_file.output
1205: ,employee_header('CSV','Header2',p_report_type));
1206:
1207: END IF;
1208:
1205: ,employee_header('CSV','Header2',p_report_type));
1206:
1207: END IF;
1208:
1209: fnd_file.put_line(fnd_file.output
1210: ,employee_data (
1211: er_name,
1212: er_ein,
1213: er_addr_line_1,