Line 466: fnd_file.put_line(fnd_file.output,formated_data_string (p_input_string => lvc_message
462: || to_char(p_employee_count)
463: || ' Number of Employees with difference = '
464: || to_char(p_diff_count);
465: hr_utility.set_location(gv_package_name || '.formated_no_diff', 10); 466: fnd_file.put_line(fnd_file.output,formated_data_string (p_input_string => lvc_message 467: ,p_bold => 'N'
468: ,p_output_file_type => output_file_type));
469: END IF;
470: END;
Line 484: fnd_file.put_line(fnd_file.output, formated_data_string (p_input_string => lvc_message
480: -- IF output_file_type = 'CSV' THEN
481: lvc_message := 'No person was picked up for comparision based on selection parameters.' ||
482: ' Ensure GRE has employees and all employees were successfully archived in the YEPP for the GRE.';
483: hr_utility.set_location(gv_package_name || '.formated_zero_count', 10); 484: fnd_file.put_line(fnd_file.output, formated_data_string (p_input_string => lvc_message 485: ,p_bold => 'N'
486: ,p_output_file_type => output_file_type));
487: -- END IF;
488: hr_utility.set_location(gv_package_name || '.formated_zero_count', 20);
Line 1103: fnd_file.put_line(fnd_file.output, formated_header_string(
1099:
1100: /* Print header for the first time for Federal or state comparision*/
1101: if lvn_diff_count = 0 THEN
1102: 1103: fnd_file.put_line(fnd_file.output, formated_header_string( 1104: gv_title || ':- Tax Year: ' || lvc_year || ' ( ' || lvc_date_time || ' ) '
1105: ,p_output_file_type
1106: ));
1107:
Line 1109: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1105: ,p_output_file_type
1106: ));
1107:
1108: IF p_output_file_type ='HTML' THEN 1109: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''); 1110: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1112: END IF;
1113:
Line 1110: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1106: ));
1107:
1108: IF p_output_file_type ='HTML' THEN
1109: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
'); 1110: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1112: END IF;
1113:
1114:
Line 1111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1107:
1108: IF p_output_file_type ='HTML' THEN
1109: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1110: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
'); 1111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1112: END IF;
1113:
1114:
1115: IF p_fed_state = 'Federal' AND lvn_diff_count = 0 THEN
Line 1116: fnd_file.put_line(fnd_file.output,formated_header_federal( p_output_file_type));
1112: END IF;
1113:
1114:
1115: IF p_fed_state = 'Federal' AND lvn_diff_count = 0 THEN 1116: fnd_file.put_line(fnd_file.output,formated_header_federal( p_output_file_type)); 1117: lvc_label1 := formated_header_federal( p_output_file_type);
1118:
1119: ELSIF p_fed_state = 'State' and lvn_diff_count = 0 THEN
1120: fnd_file.put_line(fnd_file.output,formated_header_state( p_output_file_type));
Line 1120: fnd_file.put_line(fnd_file.output,formated_header_state( p_output_file_type));
1116: fnd_file.put_line(fnd_file.output,formated_header_federal( p_output_file_type));
1117: lvc_label1 := formated_header_federal( p_output_file_type);
1118:
1119: ELSIF p_fed_state = 'State' and lvn_diff_count = 0 THEN 1120: fnd_file.put_line(fnd_file.output,formated_header_state( p_output_file_type)); 1121: lvc_label1 := formated_header_state ( p_output_file_type);
1122: END IF; /* p_fed_state = Federal */
1123:
1124: IF p_output_file_type ='HTML' THEN
Line 1125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1121: lvc_label1 := formated_header_state ( p_output_file_type);
1122: END IF; /* p_fed_state = Federal */
1123:
1124: IF p_output_file_type ='HTML' THEN 1125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''); 1126: END IF;
1127: END IF;
1128: lvn_diff_value := lvn_archive_value - lvn_live_value ;
1129:
Line 1152: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1148: if p_output_file_type ='HTML' then
1149: lv_data_row := '
Line 1178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1174: IF p_output_file_type ='HTML' THEN
1175: lv_data_row := '
' || lv_data_row || '
' ;
1176: end if;
1177: 1178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row); 1179:
1180: hr_utility.set_location(gv_package_name || '.select_employee', 100);
1181:
1182: END IF; /* to print the details */
Line 1216: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1212:
1213: IF lvn_employee_count > 0 THEN
1214: IF lvn_diff_count > 0 THEN
1215: IF p_output_file_type ='HTML' THEN 1216: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '