eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_EOY_ARCHIVE dependencies on FND_FILE

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

1138: PROCEDURE write_output_header IS
1139: BEGIN
1140: --
1141: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1142: fnd_file.put_line(fnd_file.output, rpad(' ', 41)||
1143: 'End Of Year Process - Errors and Warnings Report'||
1144: rpad(' ', 30)||fnd_date.date_to_displaydate(sysdate));
1145: fnd_file.put_line(fnd_file.output, ' ');
1146: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||

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

1141: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1142: fnd_file.put_line(fnd_file.output, rpad(' ', 41)||
1143: 'End Of Year Process - Errors and Warnings Report'||
1144: rpad(' ', 30)||fnd_date.date_to_displaydate(sysdate));
1145: fnd_file.put_line(fnd_file.output, ' ');
1146: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1147: 'Request Id: '||fnd_global.conc_request_id);
1148: fnd_file.put_line(fnd_file.output, ' ');
1149: fnd_file.put_line(fnd_file.output, rpad('Assignment', 14) || ' ' ||

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

1142: fnd_file.put_line(fnd_file.output, rpad(' ', 41)||
1143: 'End Of Year Process - Errors and Warnings Report'||
1144: rpad(' ', 30)||fnd_date.date_to_displaydate(sysdate));
1145: fnd_file.put_line(fnd_file.output, ' ');
1146: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1147: 'Request Id: '||fnd_global.conc_request_id);
1148: fnd_file.put_line(fnd_file.output, ' ');
1149: fnd_file.put_line(fnd_file.output, rpad('Assignment', 14) || ' ' ||
1150: rpad(' ', 30) || ' ' || rpad('Error or', 10) || ' ' ||

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

1144: rpad(' ', 30)||fnd_date.date_to_displaydate(sysdate));
1145: fnd_file.put_line(fnd_file.output, ' ');
1146: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1147: 'Request Id: '||fnd_global.conc_request_id);
1148: fnd_file.put_line(fnd_file.output, ' ');
1149: fnd_file.put_line(fnd_file.output, rpad('Assignment', 14) || ' ' ||
1150: rpad(' ', 30) || ' ' || rpad('Error or', 10) || ' ' ||
1151: rpad(' ', 75));
1152: fnd_file.put_line(fnd_file.output, rpad('Number', 14) || ' ' ||

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

1145: fnd_file.put_line(fnd_file.output, ' ');
1146: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1147: 'Request Id: '||fnd_global.conc_request_id);
1148: fnd_file.put_line(fnd_file.output, ' ');
1149: fnd_file.put_line(fnd_file.output, rpad('Assignment', 14) || ' ' ||
1150: rpad(' ', 30) || ' ' || rpad('Error or', 10) || ' ' ||
1151: rpad(' ', 75));
1152: fnd_file.put_line(fnd_file.output, rpad('Number', 14) || ' ' ||
1153: rpad('Full Name', 30) || ' ' || rpad('Warning', 10) || ' ' ||

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

1148: fnd_file.put_line(fnd_file.output, ' ');
1149: fnd_file.put_line(fnd_file.output, rpad('Assignment', 14) || ' ' ||
1150: rpad(' ', 30) || ' ' || rpad('Error or', 10) || ' ' ||
1151: rpad(' ', 75));
1152: fnd_file.put_line(fnd_file.output, rpad('Number', 14) || ' ' ||
1153: rpad('Full Name', 30) || ' ' || rpad('Warning', 10) || ' ' ||
1154: rpad('Message', 75));
1155: fnd_file.put_line(fnd_file.output, rpad('-', 14, '-') || ' ' ||
1156: rpad('-', 30, '-') || ' ' || rpad('-', 10, '-') || ' ' ||

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

1151: rpad(' ', 75));
1152: fnd_file.put_line(fnd_file.output, rpad('Number', 14) || ' ' ||
1153: rpad('Full Name', 30) || ' ' || rpad('Warning', 10) || ' ' ||
1154: rpad('Message', 75));
1155: fnd_file.put_line(fnd_file.output, rpad('-', 14, '-') || ' ' ||
1156: rpad('-', 30, '-') || ' ' || rpad('-', 10, '-') || ' ' ||
1157: rpad('-', 75, '-'));
1158: g_output_header := FALSE;
1159: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 100);

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

1182: END IF;
1183: hr_utility.set_location('pay_gb_eoy_archive.write_output', 30);
1184: IF p_message_type = 'E' THEN
1185: l_err_warn := 'Error';
1186: fnd_file.put_line(fnd_file.log, 'An error encountered when processing assignment '||p_assignment_number||', please check output file for more details.');
1187: g_err_count := nvl(g_err_count, 0) + 1;
1188: ELSE
1189: l_err_warn := 'Warning';
1190: g_warn_count := nvl(g_warn_count, 0) + 1;

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

1190: g_warn_count := nvl(g_warn_count, 0) + 1;
1191: END IF;
1192: --
1193: hr_utility.set_location('pay_gb_eoy_archive.write_output', 40);
1194: fnd_file.put_line(fnd_file.output, rpad(p_assignment_number, 14)||' '||
1195: rpad(p_full_name, 30)||' '||rpad(l_err_warn,10)||' '||
1196: rpad(l_message,75));
1197: --
1198: hr_utility.set_location('pay_gb_eoy_archive.write_output', 50);

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

1196: rpad(l_message,75));
1197: --
1198: hr_utility.set_location('pay_gb_eoy_archive.write_output', 50);
1199: IF length(l_message) > 75 THEN
1200: fnd_file.put_line(fnd_file.output, rpad(' ', 57)||
1201: rpad(substr(l_message,76),75));
1202: END IF;
1203: --
1204: hr_utility.set_location('pay_gb_eoy_archive.write_output', 100);

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

1213: write_output_header;
1214: END IF;
1215: --
1216: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1217: fnd_file.put_line(fnd_file.output, ' ');
1218: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1219: 'Total Number of Errors = '||nvl(g_err_count,0));
1220: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1221: 'Total Number of Warnings = '||nvl(g_warn_count,0));

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

1214: END IF;
1215: --
1216: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1217: fnd_file.put_line(fnd_file.output, ' ');
1218: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1219: 'Total Number of Errors = '||nvl(g_err_count,0));
1220: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1221: 'Total Number of Warnings = '||nvl(g_warn_count,0));
1222: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 100);

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

1216: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 10);
1217: fnd_file.put_line(fnd_file.output, ' ');
1218: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1219: 'Total Number of Errors = '||nvl(g_err_count,0));
1220: fnd_file.put_line(fnd_file.output, rpad(' ', 20)||
1221: 'Total Number of Warnings = '||nvl(g_warn_count,0));
1222: hr_utility.set_location('pay_gb_eoy_archive.write_output_header', 100);
1223: return 0;
1224: END write_output_footer;

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

1511:
1512: -- Unique Test ID is mandatory if EDI Test indicator is Yes
1513:
1514: IF (l_test_indicator = 'Y' AND l_unique_test_id IS NULL) THEN
1515: fnd_file.put_line (fnd_file.LOG,'You must provide a Unique Test ID if the EDI Test Indicator is Yes.');
1516: RAISE test_indicator_error;
1517: END IF;
1518: /* EOY 2012/2013 change-check for a Live submission,unique-id shouldnot start with 'TEST'*/
1519: IF (l_test_indicator = 'N' and upper(substr(l_permit_number,1,4)) = 'TEST') THEN

Line 1520: fnd_file.put_line (fnd_file.LOG,'Unique Id cannot begin with TEST for a live Submission.');

1516: RAISE test_indicator_error;
1517: END IF;
1518: /* EOY 2012/2013 change-check for a Live submission,unique-id shouldnot start with 'TEST'*/
1519: IF (l_test_indicator = 'N' and upper(substr(l_permit_number,1,4)) = 'TEST') THEN
1520: fnd_file.put_line (fnd_file.LOG,'Unique Id cannot begin with TEST for a live Submission.');
1521: RAISE live_submission_error;
1522: END IF;
1523: -- End BUG 5909829 EOY
1524:

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

1697: RAISE; -- reraise the error
1698: --
1699: WHEN OTHERS THEN
1700: -- Write to the conc logfile, and try to archive err msg.
1701: fnd_file.put_line(fnd_file.log, substr(sqlerrm(sqlcode),1,80));
1702: l_payroll_action_message := substr('Payroll Extract failed with: '||
1703: sqlerrm(sqlcode),1,240);
1704: ff_archive_api.create_archive_item
1705: (p_archive_item_id => l_archive_item_id,

Line 1735: fnd_file.put_line(fnd_file.log,

1731: hr_utility.set_location('Leaving: '||l_proc,40);
1732: EXCEPTION
1733: WHEN OTHERS THEN
1734: hr_utility.set_location(' Leaving: '||l_proc,50);
1735: fnd_file.put_line(fnd_file.log,
1736: substr('Error in rangecode '||sqlerrm(sqlcode),1,80));
1737: -- Return cursor that selects no rows
1738: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
1739: END range_cursor;

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

4507: END IF;
4508: --
4509: IF l_payroll_id IS NULL THEN
4510: hr_utility.trace('l_assignment_message='||l_assignment_message);
4511: fnd_file.put_line(fnd_file.log, 'Error encountered while processing assignment action '||p_assactid);
4512: fnd_file.put_line(fnd_file.log, l_assignment_message);
4513: l_dummy := write_output(p_assignment_number => l_assignment_number,
4514: p_full_name => l_last_name||', '||l_first_name,
4515: p_message_type => 'E',

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

4508: --
4509: IF l_payroll_id IS NULL THEN
4510: hr_utility.trace('l_assignment_message='||l_assignment_message);
4511: fnd_file.put_line(fnd_file.log, 'Error encountered while processing assignment action '||p_assactid);
4512: fnd_file.put_line(fnd_file.log, l_assignment_message);
4513: l_dummy := write_output(p_assignment_number => l_assignment_number,
4514: p_full_name => l_last_name||', '||l_first_name,
4515: p_message_type => 'E',
4516: p_message => 'Assignment action '||p_assactid||' encountered '||l_assignment_message);

Line 6317: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Erroneous Assignment ID ' || l_assignment_id);

6313: hr_utility.trace('ASG_ACTION_ERROR exception raised.');
6314: hr_utility.set_location(' Leaving: '||l_proc,230);
6315: raise;
6316: WHEN others THEN --Added for bug 7326591
6317: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Erroneous Assignment ID ' || l_assignment_id);
6318: hr_utility.set_location(' Exception at : '||l_proc,235);
6319: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception at : ' || l_proc);
6320: raise;
6321:

Line 6319: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception at : ' || l_proc);

6315: raise;
6316: WHEN others THEN --Added for bug 7326591
6317: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Erroneous Assignment ID ' || l_assignment_id);
6318: hr_utility.set_location(' Exception at : '||l_proc,235);
6319: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Exception at : ' || l_proc);
6320: raise;
6321:
6322: END archive_code;
6323: --