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_MOVDED_EDI dependencies on FND_FILE

Line 396: fnd_file.put_line(fnd_file.LOG,to_char(l_p46_5_def)||l_def_send_flag||l_def_static_flag||l_send_flag||l_static_flag||asg_rec.assignment_id);

392: l_p46_5_def := 0;
393: end if;
394: end if;
395: end if;
396: fnd_file.put_line(fnd_file.LOG,to_char(l_p46_5_def)||l_def_send_flag||l_def_static_flag||l_send_flag||l_static_flag||asg_rec.assignment_id);
397: /**** checking if the default has been run or not enabled to run ****/
398: if l_p46_5_def = 0 and nvl(l_def_send_flag,'N') = 'N' /*and nvl(l_def_static_flag,'Y') = 'Y'*/ then
399: if l_send_flag = 'Y' then
400: l_arch := true;

Line 404: fnd_file.put_line(fnd_file.LOG,'11111');

400: l_arch := true;
401: l_p46_5_def := 2; /**** diff b/n normal run for other report types and P46_5 normal run ***/
402: else
403: if l_send_flag = 'N' and l_static_flag = 'Y' then /** checking if P46 normal is rolled back ***/
404: fnd_file.put_line(fnd_file.LOG,'11111');
405: open csr_p46_5_def_det(asg_rec.assignment_id,'N');
406: fetch csr_p46_5_def_det into l_exist;
407: if csr_p46_5_def_det%notfound then
408: -- Bug 6770200

Line 415: fnd_file.put_line(fnd_file.LOG,to_char(l_p46_5_def));

411: close csr_p46_5_def_det;
412: if l_arch then
413: l_p46_5_def := 2;
414: end if;
415: fnd_file.put_line(fnd_file.LOG,to_char(l_p46_5_def));
416: end if;
417: end if;
418: end if;
419: /*else

Line 451: fnd_file.put_line(fnd_file.LOG,to_char(l_locked_action_id));

447: if csr_p46_5_def_assact%NOTFOUND then /*** condition happens only when default is not run prior to normal P46 ****/
448: l_locked_action_id := -1;
449: end if;
450: close csr_p46_5_def_assact;
451: fnd_file.put_line(fnd_file.LOG,to_char(l_locked_action_id));
452: if l_locked_action_id > 0 then
453: delete pay_action_interlocks where locked_action_id = l_locked_action_id;
454: hr_nonrun_asact.insint(l_ass_act_id,l_locked_action_id);
455: end if;

Line 508: fnd_file.put_line(fnd_file.LOG,'Entering: '||l_proc);

504: BEGIN
505: hr_utility.set_location('Entering: '||l_proc,1);
506: l_arch := true;
507:
508: fnd_file.put_line(fnd_file.LOG,'Entering: '||l_proc);
509: open csr_45_46_pennot_details;
510: fetch csr_45_46_pennot_details into l_45_46_pennot_rec;
511: close csr_45_46_pennot_details;
512:

Line 520: fnd_file.put_line(fnd_file.LOG,'l_arch3: ');

516: pay_core_utils.push_message(801, 'PAY_78034_VALUE_EXCEEDS_MAX', 'F');
517: pay_core_utils.push_token('ITEM_NAME', 'Tax Code');
518: pay_core_utils.push_token('MAX_VALUE', '6 characters');
519: hr_utility.set_location('Tax Code error',20);
520: fnd_file.put_line(fnd_file.LOG,'l_arch3: ');
521:
522: end if;
523: if length(ltrim(l_45_46_pennot_rec.prev_tax_code,'S')) > 6 then
524: --l_arch := false;

Line 529: fnd_file.put_line(fnd_file.LOG,'l_arch4: ');

525: pay_core_utils.push_message(801, 'PAY_78034_VALUE_EXCEEDS_MAX', 'F');
526: pay_core_utils.push_token('ITEM_NAME', 'Previous Tax Code');
527: pay_core_utils.push_token('MAX_VALUE', '6 characters');
528: hr_utility.set_location('Prev Tax Code',40);
529: fnd_file.put_line(fnd_file.LOG,'l_arch4: ');
530: end if;
531:
532: if not validate_data(substr(ltrim(substr(l_45_46_pennot_rec.prev_emp_paye_ref,4,8),'/'),1,7),'Previous Tax Reference','FULL_EDI') then
533: --l_arch := false;

Line 535: fnd_file.put_line(fnd_file.LOG,'l_arch5: ');

531:
532: if not validate_data(substr(ltrim(substr(l_45_46_pennot_rec.prev_emp_paye_ref,4,8),'/'),1,7),'Previous Tax Reference','FULL_EDI') then
533: --l_arch := false;
534: hr_utility.set_location('Previous Tax Reference error',50);
535: fnd_file.put_line(fnd_file.LOG,'l_arch5: ');
536: end if;
537:
538: if not validate_data(substr(l_45_46_pennot_rec.prev_emp_paye_ref,1,3),'Previous Tax District','FULL_EDI') then
539: --l_arch := false;

Line 541: fnd_file.put_line(fnd_file.LOG,'l_arch6: ');

537:
538: if not validate_data(substr(l_45_46_pennot_rec.prev_emp_paye_ref,1,3),'Previous Tax District','FULL_EDI') then
539: --l_arch := false;
540: hr_utility.set_location('Previous Tax District error',60);
541: fnd_file.put_line(fnd_file.LOG,'l_arch6: ');
542: end if;
543:
544: if not validate_data(p_tax_rec.prev_paid,'Previous Pay','FULL_EDI') then
545: -- l_arch := false;

Line 547: fnd_file.put_line(fnd_file.LOG,'l_arch7: ');

543:
544: if not validate_data(p_tax_rec.prev_paid,'Previous Pay','FULL_EDI') then
545: -- l_arch := false;
546: hr_utility.set_location('Prev Pay Valiation',70);
547: fnd_file.put_line(fnd_file.LOG,'l_arch7: ');
548: end if;
549:
550: if not validate_data(p_tax_rec.prev_tax,'Previous Tax','FULL_EDI') then
551: --l_arch := false;

Line 553: fnd_file.put_line(fnd_file.LOG,'l_arch8: ');

549:
550: if not validate_data(p_tax_rec.prev_tax,'Previous Tax','FULL_EDI') then
551: --l_arch := false;
552: hr_utility.set_location('Prev Tax Validation',80);
553: fnd_file.put_line(fnd_file.LOG,'l_arch8: ');
554: end if;
555:
556: if not validate_data(l_45_46_pennot_rec.prev_last_pay_period,'Previous Last Payment Period','FULL_EDI') then
557: --l_arch := false;

Line 559: fnd_file.put_line(fnd_file.LOG,'l_arch9: ');

555:
556: if not validate_data(l_45_46_pennot_rec.prev_last_pay_period,'Previous Last Payment Period','FULL_EDI') then
557: --l_arch := false;
558: hr_utility.set_location('Previous period error',90);
559: fnd_file.put_line(fnd_file.LOG,'l_arch9: ');
560: end if;
561:
562: l_ovn := l_45_46_pennot_rec.object_version_number;
563: if l_arch then

Line 599: fnd_file.put_line(fnd_file.LOG,'2435*****');

595:
596:
597: EXCEPTION
598: WHEN OTHERS THEN
599: fnd_file.put_line(fnd_file.LOG,'2435*****');
600: return false;
601: END fetch_45_46_pennot_rec;
602: --
603:

Line 1293: fnd_file.put_line(fnd_file.LOG,'Entering: '||l_proc);

1289:
1290: l_p46_rec csr_p46_details%rowtype;
1291: BEGIN
1292: hr_utility.set_location('Entering: '||l_proc,1);
1293: fnd_file.put_line(fnd_file.LOG,'Entering: '||l_proc);
1294: l_arch := true;
1295:
1296: open csr_p46_details;
1297: fetch csr_p46_details into l_p46_rec;

Line 1361: fnd_file.put_line(fnd_file.LOG,'Leaving: '||l_proc);

1357: p_p46_rec.act_info2 := l_p46_rec.p46_statement;
1358: p_p46_rec.act_info3 := l_p46_rec.student_loan;
1359: p_p46_rec.act_info4 := l_def_archive;
1360: hr_utility.set_location('Leaving: '||l_proc,999);
1361: fnd_file.put_line(fnd_file.LOG,'Leaving: '||l_proc);
1362: return l_arch;
1363: END fetch_p46_5_rec;
1364: --
1365: FUNCTION fetch_p46p_rec(p_effective_date IN DATE,

Line 1600: fnd_file.put_line (fnd_file.LOG,'Enter the Test ID as EDI Test Indicator is Yes.');

1596: CLOSE csr_parameter_info ;
1597:
1598: IF l_report_type = 'P45PT_3' or l_report_type='P46_5_PENNOT' or l_report_type='P46_5' THEN
1599: IF (l_test_indicator = 'Y' AND l_test_id IS NULL) THEN
1600: fnd_file.put_line (fnd_file.LOG,'Enter the Test ID as EDI Test Indicator is Yes.');
1601: RAISE test_indicator_error;
1602: END IF;
1603: END IF;
1604: /* Changes for P45PT3 end*/

Line 1702: fnd_file.put_line(fnd_file.LOG,'Entering: '||l_proc);

1698:
1699: BEGIN
1700: hr_utility.trace('\n xxxx Test Indicator='||pay_magtape_generic.get_parameter_value('TEST'));
1701: --hr_utility.trace_on(null,'TKP');
1702: fnd_file.put_line(fnd_file.LOG,'Entering: '||l_proc);
1703: --hr_utility.trace('Tushar effective date is '|| to_char(p_effective_date,'DD-MON-YYYY') );
1704: --hr_utility.set_location('Entering: '||l_proc,1);
1705: open csr_archive_type;
1706: fetch csr_archive_type into l_archive_type;

Line 1742: fnd_file.put_line(fnd_file.LOG,'Archiving');

1738:
1739: if l_archive_person and l_archive_addr and l_archive_data then
1740: insert_archive_row(p_assactid, p_effective_date, l_archive_tab);
1741: else
1742: fnd_file.put_line(fnd_file.LOG,'Archiving');
1743: raise error_found;
1744: end if;
1745: hr_utility.set_location('Leaving: '||l_proc,999);
1746: EXCEPTION

Line 1869: fnd_file.put_line(fnd_file.output,'\nEDI Transmission Report:');

1865: elsif l_param.report_type = 'P46_5' then
1866: l_form := 'P46 ( MOVDED 5.0 )';
1867: end if;
1868:
1869: fnd_file.put_line(fnd_file.output,'\nEDI Transmission Report:');
1870: fnd_file.put_line(fnd_file.output,' ');
1871: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );
1872: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
1873: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));

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

1866: l_form := 'P46 ( MOVDED 5.0 )';
1867: end if;
1868:
1869: fnd_file.put_line(fnd_file.output,'\nEDI Transmission Report:');
1870: fnd_file.put_line(fnd_file.output,' ');
1871: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );
1872: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
1873: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
1874: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);

Line 1871: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );

1867: end if;
1868:
1869: fnd_file.put_line(fnd_file.output,'\nEDI Transmission Report:');
1870: fnd_file.put_line(fnd_file.output,' ');
1871: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );
1872: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
1873: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
1874: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
1875: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);

Line 1872: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);

1868:
1869: fnd_file.put_line(fnd_file.output,'\nEDI Transmission Report:');
1870: fnd_file.put_line(fnd_file.output,' ');
1871: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );
1872: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
1873: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
1874: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
1875: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
1876: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);

Line 1873: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));

1869: fnd_file.put_line(fnd_file.output,'\nEDI Transmission Report:');
1870: fnd_file.put_line(fnd_file.output,' ');
1871: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );
1872: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
1873: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
1874: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
1875: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
1876: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
1877: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));

Line 1874: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);

1870: fnd_file.put_line(fnd_file.output,' ');
1871: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );
1872: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
1873: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
1874: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
1875: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
1876: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
1877: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
1878: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);

Line 1875: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);

1871: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );
1872: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
1873: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
1874: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
1875: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
1876: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
1877: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
1878: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
1879: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);

Line 1876: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);

1872: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
1873: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
1874: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
1875: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
1876: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
1877: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
1878: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
1879: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
1880: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);

Line 1877: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));

1873: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
1874: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
1875: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
1876: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
1877: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
1878: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
1879: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
1880: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
1881: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);

Line 1878: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);

1874: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
1875: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
1876: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
1877: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
1878: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
1879: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
1880: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
1881: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
1882: if length(l_addr2) > 0 then

Line 1879: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);

1875: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
1876: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
1877: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
1878: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
1879: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
1880: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
1881: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
1882: if length(l_addr2) > 0 then
1883: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);

Line 1880: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);

1876: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
1877: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
1878: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
1879: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
1880: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
1881: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
1882: if length(l_addr2) > 0 then
1883: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
1884: end if;

Line 1881: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);

1877: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
1878: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
1879: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
1880: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
1881: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
1882: if length(l_addr2) > 0 then
1883: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
1884: end if;
1885: if length(l_addr3) > 0 then

Line 1883: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);

1879: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
1880: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
1881: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
1882: if length(l_addr2) > 0 then
1883: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
1884: end if;
1885: if length(l_addr3) > 0 then
1886: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
1887: end if;

Line 1886: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);

1882: if length(l_addr2) > 0 then
1883: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
1884: end if;
1885: if length(l_addr3) > 0 then
1886: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
1887: end if;
1888: if length(l_addr4) > 0 then
1889: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
1890: end if;

Line 1889: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);

1885: if length(l_addr3) > 0 then
1886: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
1887: end if;
1888: if length(l_addr4) > 0 then
1889: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
1890: end if;
1891: end write_header;
1892:
1893: procedure write_sub_header(p_type varchar2) is

Line 1895: fnd_file.put_line(fnd_file.output,null);

1891: end write_header;
1892:
1893: procedure write_sub_header(p_type varchar2) is
1894: begin
1895: fnd_file.put_line(fnd_file.output,null);
1896: if p_type = 'E' then
1897: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');
1898: else
1899: fnd_file.put_line(fnd_file.output,'The following assignments have completed successfully');

Line 1897: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');

1893: procedure write_sub_header(p_type varchar2) is
1894: begin
1895: fnd_file.put_line(fnd_file.output,null);
1896: if p_type = 'E' then
1897: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');
1898: else
1899: fnd_file.put_line(fnd_file.output,'The following assignments have completed successfully');
1900: end if;
1901: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) ||

Line 1899: fnd_file.put_line(fnd_file.output,'The following assignments have completed successfully');

1895: fnd_file.put_line(fnd_file.output,null);
1896: if p_type = 'E' then
1897: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');
1898: else
1899: fnd_file.put_line(fnd_file.output,'The following assignments have completed successfully');
1900: end if;
1901: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) ||
1902: rpad('NI Number',11) ||
1903: rpad('Employee Name', 50));

Line 1901: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) ||

1897: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');
1898: else
1899: fnd_file.put_line(fnd_file.output,'The following assignments have completed successfully');
1900: end if;
1901: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) ||
1902: rpad('NI Number',11) ||
1903: rpad('Employee Name', 50));
1904: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
1905: rpad('-',10,'-') || ' ' ||

Line 1904: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||

1900: end if;
1901: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) ||
1902: rpad('NI Number',11) ||
1903: rpad('Employee Name', 50));
1904: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
1905: rpad('-',10,'-') || ' ' ||
1906: rpad('-',50,'-'));
1907: end write_sub_header;
1908:

Line 1936: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||

1932: l_count := 0;
1933: for asg_rec in csr_asg loop
1934: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' ||
1935: asg_rec.f_name || ' ' || asg_rec.m_name;
1936: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||
1937: rpad(asg_rec.ni_no ,10) || ' ' ||
1938: rpad(l_temp,50));
1939: l_count := l_count + 1;
1940: end loop;

Line 1941: fnd_file.put_line(fnd_file.output,null);

1937: rpad(asg_rec.ni_no ,10) || ' ' ||
1938: rpad(l_temp,50));
1939: l_count := l_count + 1;
1940: end loop;
1941: fnd_file.put_line(fnd_file.output,null);
1942: if p_type = 'E' then
1943: fnd_file.put_line(fnd_file.output,'Total Number of assignments completed with error : ' || l_count);
1944: else
1945: fnd_file.put_line(fnd_file.output,'Total Number of assignments completed successfully :' || l_count);

Line 1943: fnd_file.put_line(fnd_file.output,'Total Number of assignments completed with error : ' || l_count);

1939: l_count := l_count + 1;
1940: end loop;
1941: fnd_file.put_line(fnd_file.output,null);
1942: if p_type = 'E' then
1943: fnd_file.put_line(fnd_file.output,'Total Number of assignments completed with error : ' || l_count);
1944: else
1945: fnd_file.put_line(fnd_file.output,'Total Number of assignments completed successfully :' || l_count);
1946: end if;
1947: l_counter := l_counter + l_count;

Line 1945: fnd_file.put_line(fnd_file.output,'Total Number of assignments completed successfully :' || l_count);

1941: fnd_file.put_line(fnd_file.output,null);
1942: if p_type = 'E' then
1943: fnd_file.put_line(fnd_file.output,'Total Number of assignments completed with error : ' || l_count);
1944: else
1945: fnd_file.put_line(fnd_file.output,'Total Number of assignments completed successfully :' || l_count);
1946: end if;
1947: l_counter := l_counter + l_count;
1948: end write_body;
1949:

Line 1952: fnd_file.put_line(fnd_file.output,null);

1948: end write_body;
1949:
1950: procedure write_footer is
1951: begin
1952: fnd_file.put_line(fnd_file.output,null);
1953: fnd_file.put_line(fnd_file.output,'Total Number Of Records : ' || l_counter);
1954: end write_footer;
1955: BEGIN
1956: hr_utility.set_location('Entering: '||l_proc,1);

Line 1953: fnd_file.put_line(fnd_file.output,'Total Number Of Records : ' || l_counter);

1949:
1950: procedure write_footer is
1951: begin
1952: fnd_file.put_line(fnd_file.output,null);
1953: fnd_file.put_line(fnd_file.output,'Total Number Of Records : ' || l_counter);
1954: end write_footer;
1955: BEGIN
1956: hr_utility.set_location('Entering: '||l_proc,1);
1957: l_counter := 0;