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.PER_NL_FDR_ARCHIVE dependencies on FND_FILE

Line 153: --fnd_file.put_line(fnd_file.log,'g_year : '||g_year);

149: l_str8 varchar2(20);
150:
151:
152: begin
153: --fnd_file.put_line(fnd_file.log,'g_year : '||g_year);
154: hr_utility.set_location('Entered Procedure Write to clob ',100);
155: -- l_str0 := '';
156: -- l_str0 := '';
157: l_str0 := ''; -- for bug 5376513

Line 1384: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: Employee number - '||v_csr_get_per_without_employer.emp_no||', '||v_csr_get_per_without_employer.name||' is not attached to an employer with tax details.');

1380:
1381: FOR v_csr_get_per_without_employer IN csr_get_per_without_employer(l_org_struct_id,l_report_date, p_actid)
1382: LOOP
1383:
1384: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: Employee number - '||v_csr_get_per_without_employer.emp_no||', '||v_csr_get_per_without_employer.name||' is not attached to an employer with tax details.');
1385:
1386: END LOOP;
1387:
1388: END IF;

Line 1392: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'),((123-l_head_length)/2)+l_head_length,' '));

1388: END IF;
1389:
1390: l_head_length := length(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'));
1391:
1392: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'),((123-l_head_length)/2)+l_head_length,' '));
1393: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1394: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(rpad(' ',l_head_length+1,'-'),((123-l_head_length)/2)+l_head_length,' '));
1395: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
1396: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BG_NAME'),30,' '));

Line 1393: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

1389:
1390: l_head_length := length(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'));
1391:
1392: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'),((123-l_head_length)/2)+l_head_length,' '));
1393: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1394: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(rpad(' ',l_head_length+1,'-'),((123-l_head_length)/2)+l_head_length,' '));
1395: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
1396: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BG_NAME'),30,' '));
1397: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');

Line 1394: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(rpad(' ',l_head_length+1,'-'),((123-l_head_length)/2)+l_head_length,' '));

1390: l_head_length := length(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'));
1391:
1392: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'),((123-l_head_length)/2)+l_head_length,' '));
1393: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1394: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(rpad(' ',l_head_length+1,'-'),((123-l_head_length)/2)+l_head_length,' '));
1395: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
1396: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BG_NAME'),30,' '));
1397: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1398: FND_FILE.PUT(FND_FILE.OUTPUT, l_bg_name);

Line 1395: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);

1391:
1392: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'),((123-l_head_length)/2)+l_head_length,' '));
1393: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1394: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(rpad(' ',l_head_length+1,'-'),((123-l_head_length)/2)+l_head_length,' '));
1395: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
1396: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BG_NAME'),30,' '));
1397: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1398: FND_FILE.PUT(FND_FILE.OUTPUT, l_bg_name);
1399: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 1396: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BG_NAME'),30,' '));

1392: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_HEAD'),((123-l_head_length)/2)+l_head_length,' '));
1393: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1394: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(rpad(' ',l_head_length+1,'-'),((123-l_head_length)/2)+l_head_length,' '));
1395: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
1396: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BG_NAME'),30,' '));
1397: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1398: FND_FILE.PUT(FND_FILE.OUTPUT, l_bg_name);
1399: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1400: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_DATE'),30,' '));

Line 1397: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');

1393: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1394: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(rpad(' ',l_head_length+1,'-'),((123-l_head_length)/2)+l_head_length,' '));
1395: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
1396: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BG_NAME'),30,' '));
1397: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1398: FND_FILE.PUT(FND_FILE.OUTPUT, l_bg_name);
1399: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1400: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_DATE'),30,' '));
1401: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');

Line 1398: FND_FILE.PUT(FND_FILE.OUTPUT, l_bg_name);

1394: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(rpad(' ',l_head_length+1,'-'),((123-l_head_length)/2)+l_head_length,' '));
1395: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
1396: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BG_NAME'),30,' '));
1397: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1398: FND_FILE.PUT(FND_FILE.OUTPUT, l_bg_name);
1399: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1400: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_DATE'),30,' '));
1401: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1402: FND_FILE.PUT(FND_FILE.OUTPUT, fnd_date.date_to_displaydate(to_date(l_report_date, 'RRRR/MM/DD HH24:MI:SS')));

Line 1399: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

1395: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
1396: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BG_NAME'),30,' '));
1397: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1398: FND_FILE.PUT(FND_FILE.OUTPUT, l_bg_name);
1399: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1400: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_DATE'),30,' '));
1401: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1402: FND_FILE.PUT(FND_FILE.OUTPUT, fnd_date.date_to_displaydate(to_date(l_report_date, 'RRRR/MM/DD HH24:MI:SS')));
1403: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 6);

Line 1400: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_DATE'),30,' '));

1396: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BG_NAME'),30,' '));
1397: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1398: FND_FILE.PUT(FND_FILE.OUTPUT, l_bg_name);
1399: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1400: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_DATE'),30,' '));
1401: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1402: FND_FILE.PUT(FND_FILE.OUTPUT, fnd_date.date_to_displaydate(to_date(l_report_date, 'RRRR/MM/DD HH24:MI:SS')));
1403: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 6);
1404:

Line 1401: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');

1397: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1398: FND_FILE.PUT(FND_FILE.OUTPUT, l_bg_name);
1399: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1400: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_DATE'),30,' '));
1401: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1402: FND_FILE.PUT(FND_FILE.OUTPUT, fnd_date.date_to_displaydate(to_date(l_report_date, 'RRRR/MM/DD HH24:MI:SS')));
1403: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 6);
1404:
1405:

Line 1402: FND_FILE.PUT(FND_FILE.OUTPUT, fnd_date.date_to_displaydate(to_date(l_report_date, 'RRRR/MM/DD HH24:MI:SS')));

1398: FND_FILE.PUT(FND_FILE.OUTPUT, l_bg_name);
1399: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1400: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_DATE'),30,' '));
1401: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1402: FND_FILE.PUT(FND_FILE.OUTPUT, fnd_date.date_to_displaydate(to_date(l_report_date, 'RRRR/MM/DD HH24:MI:SS')));
1403: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 6);
1404:
1405:
1406:

Line 1403: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 6);

1399: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1400: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','REP_DATE'),30,' '));
1401: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1402: FND_FILE.PUT(FND_FILE.OUTPUT, fnd_date.date_to_displaydate(to_date(l_report_date, 'RRRR/MM/DD HH24:MI:SS')));
1403: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 6);
1404:
1405:
1406:
1407: FOR v_csr_get_employer IN csr_get_employer

Line 1412: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: The Tax Registration Number for '||

1408: LOOP
1409:
1410: IF hr_ni_chk_pkg.chk_nat_id_format(v_csr_get_employer.tax_reg_num,'DDDDDDDDDADD') <> upper(v_csr_get_employer.tax_reg_num) OR substr(v_csr_get_employer.tax_reg_num,10,1) <> 'L' THEN
1411:
1412: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: The Tax Registration Number for '||
1413: v_csr_get_employer.org_name||' has an incorrect format. It should be nnnnnnnnnLnn. Please correct.');
1414:
1415: END IF;
1416:

Line 1418: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMPLOYER'),30,' '));

1414:
1415: END IF;
1416:
1417:
1418: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMPLOYER'),30,' '));
1419: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1420: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.org_name);
1421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1422: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'),30,' '));

Line 1419: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');

1415: END IF;
1416:
1417:
1418: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMPLOYER'),30,' '));
1419: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1420: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.org_name);
1421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1422: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'),30,' '));
1423: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');

Line 1420: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.org_name);

1416:
1417:
1418: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMPLOYER'),30,' '));
1419: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1420: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.org_name);
1421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1422: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'),30,' '));
1423: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1424: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.tax_reg_num);

Line 1421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

1417:
1418: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMPLOYER'),30,' '));
1419: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1420: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.org_name);
1421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1422: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'),30,' '));
1423: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1424: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.tax_reg_num);
1425: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);

Line 1422: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'),30,' '));

1418: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMPLOYER'),30,' '));
1419: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1420: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.org_name);
1421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1422: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'),30,' '));
1423: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1424: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.tax_reg_num);
1425: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1426:

Line 1423: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');

1419: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1420: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.org_name);
1421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1422: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'),30,' '));
1423: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1424: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.tax_reg_num);
1425: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1426:
1427: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));

Line 1424: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.tax_reg_num);

1420: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.org_name);
1421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1422: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'),30,' '));
1423: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1424: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.tax_reg_num);
1425: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1426:
1427: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1428: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 1425: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);

1421: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1422: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'),30,' '));
1423: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1424: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.tax_reg_num);
1425: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1426:
1427: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1428: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1429: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NO'), 21, ' '));

Line 1427: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));

1423: FND_FILE.PUT(FND_FILE.OUTPUT, ': ');
1424: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.tax_reg_num);
1425: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1426:
1427: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1428: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1429: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NO'), 21, ' '));
1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));
1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));

Line 1428: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

1424: FND_FILE.PUT(FND_FILE.OUTPUT, v_csr_get_employer.tax_reg_num);
1425: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1426:
1427: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1428: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1429: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NO'), 21, ' '));
1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));
1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));
1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));

Line 1429: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NO'), 21, ' '));

1425: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 2);
1426:
1427: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1428: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1429: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NO'), 21, ' '));
1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));
1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));
1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));
1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));

Line 1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));

1426:
1427: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1428: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1429: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NO'), 21, ' '));
1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));
1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));
1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));
1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));
1434: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BIRTH_DATE'), 21, ' '));

Line 1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));

1427: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1428: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1429: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NO'), 21, ' '));
1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));
1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));
1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));
1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));
1434: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BIRTH_DATE'), 21, ' '));
1435: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));

1428: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1429: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NO'), 21, ' '));
1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));
1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));
1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));
1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));
1434: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BIRTH_DATE'), 21, ' '));
1435: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1436: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));

Line 1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));

1429: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NO'), 21, ' '));
1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));
1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));
1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));
1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));
1434: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BIRTH_DATE'), 21, ' '));
1435: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1436: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1437: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 1434: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BIRTH_DATE'), 21, ' '));

1430: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','EMP_NAME'), 40, ' '));
1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));
1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));
1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));
1434: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BIRTH_DATE'), 21, ' '));
1435: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1436: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1437: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1438:

Line 1435: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

1431: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','SOFI_NO'), 20, ' '));
1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));
1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));
1434: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BIRTH_DATE'), 21, ' '));
1435: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1436: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1437: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1438:
1439:

Line 1436: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));

1432: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','TAX_REG'), 30, ' '));
1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));
1434: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BIRTH_DATE'), 21, ' '));
1435: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1436: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1437: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1438:
1439:
1440: FOR v_csr_get_employee_details IN csr_get_employee_details(v_csr_get_employer.org_name)

Line 1437: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

1433: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','HIRE_DATE'), 21, ' '));
1434: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(hr_general.decode_lookup('NL_FDR_LABELS','BIRTH_DATE'), 21, ' '));
1435: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1436: FND_FILE.PUT(FND_FILE.OUTPUT, lpad(' ',123,'-'));
1437: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1438:
1439:
1440: FOR v_csr_get_employee_details IN csr_get_employee_details(v_csr_get_employer.org_name)
1441: LOOP

Line 1445: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: Employee number - '||v_csr_get_employee_details.employee_number||', '||

1441: LOOP
1442:
1443: IF v_csr_get_employee_details.date_of_birth = ' ' THEN
1444:
1445: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error: Employee number - '||v_csr_get_employee_details.employee_number||', '||
1446: v_csr_get_employee_details.full_name||' has no Date of Birth entered.');
1447:
1448: END IF;
1449:

Line 1450: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.employee_number, 21, ' '));

1446: v_csr_get_employee_details.full_name||' has no Date of Birth entered.');
1447:
1448: END IF;
1449:
1450: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.employee_number, 21, ' '));
1451: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.full_name, 40, ' '));
1452: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.sofi_number, 20, ' '));
1453: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employer.tax_reg_num, 30, ' '));
1454: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.hire_date, 21, ' '));

Line 1451: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.full_name, 40, ' '));

1447:
1448: END IF;
1449:
1450: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.employee_number, 21, ' '));
1451: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.full_name, 40, ' '));
1452: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.sofi_number, 20, ' '));
1453: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employer.tax_reg_num, 30, ' '));
1454: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.hire_date, 21, ' '));
1455: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.date_of_birth, 21, ' '));

Line 1452: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.sofi_number, 20, ' '));

1448: END IF;
1449:
1450: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.employee_number, 21, ' '));
1451: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.full_name, 40, ' '));
1452: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.sofi_number, 20, ' '));
1453: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employer.tax_reg_num, 30, ' '));
1454: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.hire_date, 21, ' '));
1455: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.date_of_birth, 21, ' '));
1456: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 1453: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employer.tax_reg_num, 30, ' '));

1449:
1450: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.employee_number, 21, ' '));
1451: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.full_name, 40, ' '));
1452: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.sofi_number, 20, ' '));
1453: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employer.tax_reg_num, 30, ' '));
1454: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.hire_date, 21, ' '));
1455: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.date_of_birth, 21, ' '));
1456: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1457:

Line 1454: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.hire_date, 21, ' '));

1450: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.employee_number, 21, ' '));
1451: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.full_name, 40, ' '));
1452: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.sofi_number, 20, ' '));
1453: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employer.tax_reg_num, 30, ' '));
1454: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.hire_date, 21, ' '));
1455: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.date_of_birth, 21, ' '));
1456: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1457:
1458: END LOOP;

Line 1455: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.date_of_birth, 21, ' '));

1451: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.full_name, 40, ' '));
1452: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.sofi_number, 20, ' '));
1453: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employer.tax_reg_num, 30, ' '));
1454: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.hire_date, 21, ' '));
1455: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.date_of_birth, 21, ' '));
1456: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1457:
1458: END LOOP;
1459:

Line 1456: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

1452: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.sofi_number, 20, ' '));
1453: --FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employer.tax_reg_num, 30, ' '));
1454: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.hire_date, 21, ' '));
1455: FND_FILE.PUT(FND_FILE.OUTPUT, rpad(v_csr_get_employee_details.date_of_birth, 21, ' '));
1456: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1457:
1458: END LOOP;
1459:
1460: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);

Line 1460: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);

1456: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1457:
1458: END LOOP;
1459:
1460: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 3);
1461:
1462: END LOOP;
1463:
1464: --Deleting the data from pay_action_information table