DBA Data[Home] [Help]

APPS.PAY_LIVEARCHIVE_PKG dependencies on FND_FILE

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 := '

' || lv_data_row || '' ;
1061: end if;
1062:
1063: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1064:
1065:
1066: hr_utility.set_location(gv_package_name || '.select_employee', 90);
1067: ELSIF p_fed_state = 'State' THEN

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, '');
1128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lvc_message);
1130: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1131: ELSE

Line 1128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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, '');
1128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lvc_message);
1130: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1131: ELSE
1132: formated_no_diff(p_output_file_type,lvc_lookup_description,

Line 1129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lvc_message);

1125: IF lvn_diff_count > 0 THEN
1126: IF p_output_file_type ='HTML' THEN
1127: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lvc_message);
1130: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1131: ELSE
1132: formated_no_diff(p_output_file_type,lvc_lookup_description,
1133: lvn_employee_count, lvn_diff_count);

Line 1130: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1126: IF p_output_file_type ='HTML' THEN
1127: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lvc_message);
1130: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1131: ELSE
1132: formated_no_diff(p_output_file_type,lvc_lookup_description,
1133: lvn_employee_count, lvn_diff_count);
1134: END IF;

Line 1137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lvc_message);

1133: lvn_employee_count, lvn_diff_count);
1134: END IF;
1135: ELSE
1136: IF p_output_file_type = 'HTML' THEN
1137: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lvc_message);
1138: ELSE
1139: formated_no_diff(p_output_file_type,lvc_lookup_description,
1140: lvn_employee_count, lvn_diff_count);
1141: END IF; /* if html */