Line 459: fnd_file.put_line(fnd_file.output,formated_data_string (p_input_string => lvc_message
455: || to_char(p_employee_count)
456: || ' Number of Employees with difference = '
457: || to_char(p_diff_count);
458: hr_utility.set_location(gv_package_name || '.formated_no_diff', 10); 459: fnd_file.put_line(fnd_file.output,formated_data_string (p_input_string => lvc_message 460: ,p_bold => 'N'
461: ,p_output_file_type => output_file_type));
462: END IF;
463: END;
Line 477: fnd_file.put_line(fnd_file.output, formated_data_string (p_input_string => lvc_message
473: -- IF output_file_type = 'CSV' THEN
474: lvc_message := 'No person was picked up for comparision based on selection parameters.' ||
475: ' Ensure GRE has employees and all employees were successfully archived in the YEPP for the GRE.';
476: hr_utility.set_location(gv_package_name || '.formated_zero_count', 10); 477: fnd_file.put_line(fnd_file.output, formated_data_string (p_input_string => lvc_message 478: ,p_bold => 'N'
479: ,p_output_file_type => output_file_type));
480: -- END IF;
481: hr_utility.set_location(gv_package_name || '.formated_zero_count', 20);
Line 1014: fnd_file.put_line(fnd_file.output, formated_header_string(
1010:
1011: /* Print header for the first time for Federal or state comparision*/
1012: if lvn_diff_count = 0 THEN
1013: 1014: fnd_file.put_line(fnd_file.output, formated_header_string( 1015: gv_title || ':- Tax Year: ' || lvc_year || ' ( ' || lvc_date_time || ' ) '
1016: ,p_output_file_type
1017: ));
1018:
Line 1020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1016: ,p_output_file_type
1017: ));
1018:
1019: IF p_output_file_type ='HTML' THEN 1020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''); 1021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1022: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1023: END IF;
1024:
Line 1021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1017: ));
1018:
1019: IF p_output_file_type ='HTML' THEN
1020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
'); 1021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1022: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1023: END IF;
1024:
1025:
Line 1022: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1018:
1019: IF p_output_file_type ='HTML' THEN
1020: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
'); 1022: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1023: END IF;
1024:
1025:
1026: IF p_fed_state = 'Federal' AND lvn_diff_count = 0 THEN
Line 1027: fnd_file.put_line(fnd_file.output,formated_header_federal( p_output_file_type));
1023: END IF;
1024:
1025:
1026: IF p_fed_state = 'Federal' AND lvn_diff_count = 0 THEN 1027: fnd_file.put_line(fnd_file.output,formated_header_federal( p_output_file_type)); 1028: lvc_label1 := formated_header_federal( p_output_file_type);
1029:
1030: ELSIF p_fed_state = 'State' and lvn_diff_count = 0 THEN
1031: fnd_file.put_line(fnd_file.output,formated_header_state( p_output_file_type));
Line 1031: fnd_file.put_line(fnd_file.output,formated_header_state( p_output_file_type));
1027: fnd_file.put_line(fnd_file.output,formated_header_federal( p_output_file_type));
1028: lvc_label1 := formated_header_federal( p_output_file_type);
1029:
1030: ELSIF p_fed_state = 'State' and lvn_diff_count = 0 THEN 1031: fnd_file.put_line(fnd_file.output,formated_header_state( p_output_file_type)); 1032: lvc_label1 := formated_header_state ( p_output_file_type);
1033: END IF; /* p_fed_state = Federal */
1034:
1035: IF p_output_file_type ='HTML' THEN
Line 1036: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1032: lvc_label1 := formated_header_state ( p_output_file_type);
1033: END IF; /* p_fed_state = Federal */
1034:
1035: IF p_output_file_type ='HTML' THEN 1036: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''); 1037: END IF;
1038: END IF;
1039: lvn_diff_value := lvn_archive_value - lvn_live_value ;
1040:
Line 1063: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1059: if p_output_file_type ='HTML' then
1060: lv_data_row := '
Line 1089: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1085: IF p_output_file_type ='HTML' THEN
1086: lv_data_row := '
' || lv_data_row || '
' ;
1087: end if;
1088: 1089: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row); 1090:
1091: hr_utility.set_location(gv_package_name || '.select_employee', 100);
1092:
1093: END IF; /* to print the details */
Line 1127: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1123:
1124: IF lvn_employee_count > 0 THEN
1125: IF lvn_diff_count > 0 THEN
1126: IF p_output_file_type ='HTML' THEN 1127: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '