DBA Data[Home] [Help]

APPS.PAY_LIVEARCHIVE_PKG dependencies on FND_FILE

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

' || lv_data_row || '' ;
1150: end if;
1151:
1152: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1153:
1154:
1155: hr_utility.set_location(gv_package_name || '.select_employee', 90);
1156: ELSIF p_fed_state = 'State' THEN

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, '');
1217: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lvc_message);
1219: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1220: ELSE

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

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, '');
1217: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lvc_message);
1219: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1220: ELSE
1221: formated_no_diff(p_output_file_type,lvc_lookup_description,

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

1214: IF lvn_diff_count > 0 THEN
1215: IF p_output_file_type ='HTML' THEN
1216: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1217: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lvc_message);
1219: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1220: ELSE
1221: formated_no_diff(p_output_file_type,lvc_lookup_description,
1222: lvn_employee_count, lvn_diff_count);

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

1215: IF p_output_file_type ='HTML' THEN
1216: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1217: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lvc_message);
1219: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1220: ELSE
1221: formated_no_diff(p_output_file_type,lvc_lookup_description,
1222: lvn_employee_count, lvn_diff_count);
1223: END IF;

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

1222: lvn_employee_count, lvn_diff_count);
1223: END IF;
1224: ELSE
1225: IF p_output_file_type = 'HTML' THEN
1226: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lvc_message);
1227: ELSE
1228: formated_no_diff(p_output_file_type,lvc_lookup_description,
1229: lvn_employee_count, lvn_diff_count);
1230: END IF; /* if html */