DBA Data[Home] [Help]

APPS.PAY_GB_EOY_ARCHIVE dependencies on FND_FILE

Line 1118: fnd_file.put_line(fnd_file.output, rpad(' ', 41)||

1114: PROCEDURE write_output_header IS
1115: BEGIN
1116: --
1117: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1118: fnd_file.put_line(fnd_file.output, rpad(' ', 41)||
1119: 'End Of Year Process - Errors and Warnings Report'||
1120: rpad(' ', 30)||fnd_date.date_to_displaydate(sysdate));
1121: fnd_file.put_line(fnd_file.output, ' ');
1122: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||

Line 1121: fnd_file.put_line(fnd_file.output, ' ');

1117: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1118: fnd_file.put_line(fnd_file.output, rpad(' ', 41)||
1119: 'End Of Year Process - Errors and Warnings Report'||
1120: rpad(' ', 30)||fnd_date.date_to_displaydate(sysdate));
1121: fnd_file.put_line(fnd_file.output, ' ');
1122: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1123: 'Request Id: '||fnd_global.conc_request_id);
1124: fnd_file.put_line(fnd_file.output, ' ');
1125: fnd_file.put_line(fnd_file.output, rpad('Assignment', 14) || ' ' ||

Line 1122: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||

1118: fnd_file.put_line(fnd_file.output, rpad(' ', 41)||
1119: 'End Of Year Process - Errors and Warnings Report'||
1120: rpad(' ', 30)||fnd_date.date_to_displaydate(sysdate));
1121: fnd_file.put_line(fnd_file.output, ' ');
1122: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1123: 'Request Id: '||fnd_global.conc_request_id);
1124: fnd_file.put_line(fnd_file.output, ' ');
1125: fnd_file.put_line(fnd_file.output, rpad('Assignment', 14) || ' ' ||
1126: rpad(' ', 30) || ' ' || rpad('Error or', 10) || ' ' ||

Line 1124: fnd_file.put_line(fnd_file.output, ' ');

1120: rpad(' ', 30)||fnd_date.date_to_displaydate(sysdate));
1121: fnd_file.put_line(fnd_file.output, ' ');
1122: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1123: 'Request Id: '||fnd_global.conc_request_id);
1124: fnd_file.put_line(fnd_file.output, ' ');
1125: fnd_file.put_line(fnd_file.output, rpad('Assignment', 14) || ' ' ||
1126: rpad(' ', 30) || ' ' || rpad('Error or', 10) || ' ' ||
1127: rpad(' ', 75));
1128: fnd_file.put_line(fnd_file.output, rpad('Number', 14) || ' ' ||

Line 1125: fnd_file.put_line(fnd_file.output, rpad('Assignment', 14) || ' ' ||

1121: fnd_file.put_line(fnd_file.output, ' ');
1122: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1123: 'Request Id: '||fnd_global.conc_request_id);
1124: fnd_file.put_line(fnd_file.output, ' ');
1125: fnd_file.put_line(fnd_file.output, rpad('Assignment', 14) || ' ' ||
1126: rpad(' ', 30) || ' ' || rpad('Error or', 10) || ' ' ||
1127: rpad(' ', 75));
1128: fnd_file.put_line(fnd_file.output, rpad('Number', 14) || ' ' ||
1129: rpad('Full Name', 30) || ' ' || rpad('Warning', 10) || ' ' ||

Line 1128: fnd_file.put_line(fnd_file.output, rpad('Number', 14) || ' ' ||

1124: fnd_file.put_line(fnd_file.output, ' ');
1125: fnd_file.put_line(fnd_file.output, rpad('Assignment', 14) || ' ' ||
1126: rpad(' ', 30) || ' ' || rpad('Error or', 10) || ' ' ||
1127: rpad(' ', 75));
1128: fnd_file.put_line(fnd_file.output, rpad('Number', 14) || ' ' ||
1129: rpad('Full Name', 30) || ' ' || rpad('Warning', 10) || ' ' ||
1130: rpad('Message', 75));
1131: fnd_file.put_line(fnd_file.output, rpad('-', 14, '-') || ' ' ||
1132: rpad('-', 30, '-') || ' ' || rpad('-', 10, '-') || ' ' ||

Line 1131: fnd_file.put_line(fnd_file.output, rpad('-', 14, '-') || ' ' ||

1127: rpad(' ', 75));
1128: fnd_file.put_line(fnd_file.output, rpad('Number', 14) || ' ' ||
1129: rpad('Full Name', 30) || ' ' || rpad('Warning', 10) || ' ' ||
1130: rpad('Message', 75));
1131: fnd_file.put_line(fnd_file.output, rpad('-', 14, '-') || ' ' ||
1132: rpad('-', 30, '-') || ' ' || rpad('-', 10, '-') || ' ' ||
1133: rpad('-', 75, '-'));
1134: g_output_header := FALSE;
1135: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 100);

Line 1162: fnd_file.put_line(fnd_file.log, 'An error encountered when processing assignment '||p_assignment_number||', please check output file for more details.');

1158: END IF;
1159: hr_utility.set_location('pay_gb_eoy_archive.write_output', 30);
1160: IF p_message_type = 'E' THEN
1161: l_err_warn := 'Error';
1162: fnd_file.put_line(fnd_file.log, 'An error encountered when processing assignment '||p_assignment_number||', please check output file for more details.');
1163: g_err_count := nvl(g_err_count, 0) + 1;
1164: ELSE
1165: l_err_warn := 'Warning';
1166: g_warn_count := nvl(g_warn_count, 0) + 1;

Line 1170: fnd_file.put_line(fnd_file.output, rpad(p_assignment_number, 14)||' '||

1166: g_warn_count := nvl(g_warn_count, 0) + 1;
1167: END IF;
1168: --
1169: hr_utility.set_location('pay_gb_eoy_archive.write_output', 40);
1170: fnd_file.put_line(fnd_file.output, rpad(p_assignment_number, 14)||' '||
1171: rpad(p_full_name, 30)||' '||rpad(l_err_warn,10)||' '||
1172: rpad(l_message,75));
1173: --
1174: hr_utility.set_location('pay_gb_eoy_archive.write_output', 50);

Line 1176: fnd_file.put_line(fnd_file.output, rpad(' ', 57)||

1172: rpad(l_message,75));
1173: --
1174: hr_utility.set_location('pay_gb_eoy_archive.write_output', 50);
1175: IF length(l_message) > 75 THEN
1176: fnd_file.put_line(fnd_file.output, rpad(' ', 57)||
1177: rpad(substr(l_message,76),75));
1178: END IF;
1179: --
1180: hr_utility.set_location('pay_gb_eoy_archive.write_output', 100);

Line 1193: fnd_file.put_line(fnd_file.output, ' ');

1189: write_output_header;
1190: END IF;
1191: --
1192: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1193: fnd_file.put_line(fnd_file.output, ' ');
1194: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1195: 'Total Number of Errors = '||nvl(g_err_count,0));
1196: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1197: 'Total Number of Warnings = '||nvl(g_warn_count,0));

Line 1194: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||

1190: END IF;
1191: --
1192: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1193: fnd_file.put_line(fnd_file.output, ' ');
1194: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1195: 'Total Number of Errors = '||nvl(g_err_count,0));
1196: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1197: 'Total Number of Warnings = '||nvl(g_warn_count,0));
1198: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 100);

Line 1196: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||

1192: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1193: fnd_file.put_line(fnd_file.output, ' ');
1194: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1195: 'Total Number of Errors = '||nvl(g_err_count,0));
1196: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1197: 'Total Number of Warnings = '||nvl(g_warn_count,0));
1198: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 100);
1199: return 0;
1200: END write_output_footer;

Line 1489: fnd_file.put_line (fnd_file.LOG,'You must provide a Unique Test ID if the EDI Test Indicator is Yes.');

1485:
1486: -- Unique Test ID is mandatory if EDI Test indicator is Yes
1487:
1488: IF (l_test_indicator = 'Y' AND l_unique_test_id IS NULL) THEN
1489: fnd_file.put_line (fnd_file.LOG,'You must provide a Unique Test ID if the EDI Test Indicator is Yes.');
1490: RAISE test_indicator_error;
1491: END IF;
1492:
1493: -- End BUG 5909829 EOY

Line 1654: fnd_file.put_line(fnd_file.log, substr(sqlerrm(sqlcode),1,80));

1650: RAISE; -- reraise the error
1651: --
1652: WHEN OTHERS THEN
1653: -- Write to the conc logfile, and try to archive err msg.
1654: fnd_file.put_line(fnd_file.log, substr(sqlerrm(sqlcode),1,80));
1655: l_payroll_action_message := substr('Payroll Extract failed with: '||
1656: sqlerrm(sqlcode),1,240);
1657: ff_archive_api.create_archive_item
1658: (p_archive_item_id => l_archive_item_id,

Line 1688: fnd_file.put_line(fnd_file.log,

1684: hr_utility.set_location('Leaving: '||l_proc,40);
1685: EXCEPTION
1686: WHEN OTHERS THEN
1687: hr_utility.set_location(' Leaving: '||l_proc,50);
1688: fnd_file.put_line(fnd_file.log,
1689: substr('Error in rangecode '||sqlerrm(sqlcode),1,80));
1690: -- Return cursor that selects no rows
1691: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
1692: END range_cursor;

Line 4326: fnd_file.put_line(fnd_file.log, 'Error encountered while processing assignment action '||p_assactid);

4322: END IF;
4323: --
4324: IF l_payroll_id IS NULL THEN
4325: hr_utility.trace('l_assignment_message='||l_assignment_message);
4326: fnd_file.put_line(fnd_file.log, 'Error encountered while processing assignment action '||p_assactid);
4327: fnd_file.put_line(fnd_file.log, l_assignment_message);
4328: l_dummy := write_output(p_assignment_number => l_assignment_number,
4329: p_full_name => l_last_name||', '||l_first_name,
4330: p_message_type => 'E',

Line 4327: fnd_file.put_line(fnd_file.log, l_assignment_message);

4323: --
4324: IF l_payroll_id IS NULL THEN
4325: hr_utility.trace('l_assignment_message='||l_assignment_message);
4326: fnd_file.put_line(fnd_file.log, 'Error encountered while processing assignment action '||p_assactid);
4327: fnd_file.put_line(fnd_file.log, l_assignment_message);
4328: l_dummy := write_output(p_assignment_number => l_assignment_number,
4329: p_full_name => l_last_name||', '||l_first_name,
4330: p_message_type => 'E',
4331: p_message => 'Assignment action '||p_assactid||' encountered '||l_assignment_message);