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 467: 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);

463: l_p46_5_def := 0;
464: end if;
465: end if;
466: end if;
467: 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);
468: /**** checking if the default has been run or not enabled to run ****/
469: if l_p46_5_def = 0 and nvl(l_def_send_flag,'N') = 'N' /*and nvl(l_def_static_flag,'Y') = 'Y'*/ then
470: if l_send_flag = 'Y' then
471: l_arch := true;

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

471: l_arch := true;
472: l_p46_5_def := 2; /**** diff b/n normal run for other report types and P46_5 normal run ***/
473: else
474: if l_send_flag = 'N' and l_static_flag = 'Y' then /** checking if P46 normal is rolled back ***/
475: fnd_file.put_line(fnd_file.LOG,'11111');
476: open csr_p46_5_def_det(asg_rec.assignment_id,'N');
477: fetch csr_p46_5_def_det into l_exist;
478: if csr_p46_5_def_det%notfound then
479: -- Bug 6770200

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

482: close csr_p46_5_def_det;
483: if l_arch then
484: l_p46_5_def := 2;
485: end if;
486: fnd_file.put_line(fnd_file.LOG,to_char(l_p46_5_def));
487: end if;
488: end if;
489: end if;
490: /*else

Line 524: 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);

520: l_p46_5_def := 0;
521: end if;
522: end if;
523: end if;
524: 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);
525: /**** checking if the default has been run or not enabled to run ****/
526: if l_p46_5_def = 0 and nvl(l_def_send_flag,'N') = 'N' /*and nvl(l_def_static_flag,'Y') = 'Y'*/ then
527: if l_send_flag = 'Y' then
528: l_arch := true;

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

528: l_arch := true;
529: l_p46_5_def := 2; /**** diff b/n normal run for other report types and P46_5 normal run ***/
530: else
531: if l_send_flag = 'N' and l_static_flag = 'Y' then /** checking if P46 normal is rolled back ***/
532: fnd_file.put_line(fnd_file.LOG,'11111');
533: open csr_p46_5_def_det(asg_rec.assignment_id,'N');
534: fetch csr_p46_5_def_det into l_exist;
535: if csr_p46_5_def_det%notfound then
536: -- Bug 6770200

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

539: close csr_p46_5_def_det;
540: if l_arch then
541: l_p46_5_def := 2;
542: end if;
543: fnd_file.put_line(fnd_file.LOG,to_char(l_p46_5_def));
544: end if;
545: end if;
546: end if;
547: /*else

Line 583: 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);

579: l_p46_5_def := 0;
580: end if;
581: end if;
582: end if;
583: 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);
584: /**** checking if the default has been run or not enabled to run ****/
585: if l_p46_5_def = 0 and nvl(l_def_send_flag,'N') = 'N' /*and nvl(l_def_static_flag,'Y') = 'Y'*/ then
586: if l_send_flag = 'Y' then
587: l_arch := true;

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

587: l_arch := true;
588: l_p46_5_def := 2; /**** diff b/n normal run for other report types and P46_5 normal run ***/
589: else
590: if l_send_flag = 'N' and l_static_flag = 'Y' then /** checking if P46 normal is rolled back ***/
591: fnd_file.put_line(fnd_file.LOG,'11111');
592: open csr_p46_5_def_det(asg_rec.assignment_id,'N');
593: fetch csr_p46_5_def_det into l_exist;
594: if csr_p46_5_def_det%notfound then
595: -- Bug 6770200

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

598: close csr_p46_5_def_det;
599: if l_arch then
600: l_p46_5_def := 2;
601: end if;
602: fnd_file.put_line(fnd_file.LOG,to_char(l_p46_5_def));
603: end if;
604: end if;
605: end if;
606: /*else

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

637: l_locked_action_id := -1;
638: end if;
639: close csr_p46_5_def_assact;
640:
641: fnd_file.put_line(fnd_file.LOG,to_char(l_locked_action_id));
642: if l_locked_action_id > 0 then
643: delete pay_action_interlocks where locked_action_id = l_locked_action_id;
644: hr_nonrun_asact.insint(l_ass_act_id,l_locked_action_id);
645: end if;

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

694: BEGIN
695: hr_utility.set_location('Entering: '||l_proc,1);
696: l_arch := true;
697:
698: fnd_file.put_line(fnd_file.LOG,'Entering: '||l_proc);
699: open csr_45_46_pennot_details;
700: fetch csr_45_46_pennot_details into l_45_46_pennot_rec;
701: close csr_45_46_pennot_details;
702:

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

706: pay_core_utils.push_message(801, 'PAY_78034_VALUE_EXCEEDS_MAX', 'F');
707: pay_core_utils.push_token('ITEM_NAME', 'Tax Code');
708: pay_core_utils.push_token('MAX_VALUE', '6 characters');
709: hr_utility.set_location('Tax Code error',20);
710: fnd_file.put_line(fnd_file.LOG,'l_arch3: ');
711:
712: end if;
713: if length(ltrim(l_45_46_pennot_rec.prev_tax_code,'S')) > 6 then
714: --l_arch := false;

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

715: pay_core_utils.push_message(801, 'PAY_78034_VALUE_EXCEEDS_MAX', 'F');
716: pay_core_utils.push_token('ITEM_NAME', 'Previous Tax Code');
717: pay_core_utils.push_token('MAX_VALUE', '6 characters');
718: hr_utility.set_location('Prev Tax Code',40);
719: fnd_file.put_line(fnd_file.LOG,'l_arch4: ');
720: end if;
721:
722: 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
723: --l_arch := false;

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

721:
722: 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
723: --l_arch := false;
724: hr_utility.set_location('Previous Tax Reference error',50);
725: fnd_file.put_line(fnd_file.LOG,'l_arch5: ');
726: end if;
727:
728: if not validate_data(substr(l_45_46_pennot_rec.prev_emp_paye_ref,1,3),'Previous Tax District','FULL_EDI') then
729: --l_arch := false;

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

727:
728: if not validate_data(substr(l_45_46_pennot_rec.prev_emp_paye_ref,1,3),'Previous Tax District','FULL_EDI') then
729: --l_arch := false;
730: hr_utility.set_location('Previous Tax District error',60);
731: fnd_file.put_line(fnd_file.LOG,'l_arch6: ');
732: end if;
733:
734: if not validate_data(p_tax_rec.prev_paid,'Previous Pay','FULL_EDI') then
735: -- l_arch := false;

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

733:
734: if not validate_data(p_tax_rec.prev_paid,'Previous Pay','FULL_EDI') then
735: -- l_arch := false;
736: hr_utility.set_location('Prev Pay Valiation',70);
737: fnd_file.put_line(fnd_file.LOG,'l_arch7: ');
738: end if;
739:
740: if not validate_data(p_tax_rec.prev_tax,'Previous Tax','FULL_EDI') then
741: --l_arch := false;

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

739:
740: if not validate_data(p_tax_rec.prev_tax,'Previous Tax','FULL_EDI') then
741: --l_arch := false;
742: hr_utility.set_location('Prev Tax Validation',80);
743: fnd_file.put_line(fnd_file.LOG,'l_arch8: ');
744: end if;
745:
746: if not validate_data(l_45_46_pennot_rec.prev_last_pay_period,'Previous Last Payment Period','FULL_EDI') then
747: --l_arch := false;

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

745:
746: if not validate_data(l_45_46_pennot_rec.prev_last_pay_period,'Previous Last Payment Period','FULL_EDI') then
747: --l_arch := false;
748: hr_utility.set_location('Previous period error',90);
749: fnd_file.put_line(fnd_file.LOG,'l_arch9: ');
750: end if;
751:
752: l_ovn := l_45_46_pennot_rec.object_version_number;
753: if l_arch then

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

785:
786:
787: EXCEPTION
788: WHEN OTHERS THEN
789: fnd_file.put_line(fnd_file.LOG,'2435*****');
790: return false;
791: END fetch_45_46_pennot_rec;
792: --
793:

Line 1613: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : You have not entered a tax code for the EEA Citizen ' || l_assignment_number || '. Ensure you enter Emergency Tax Code on a Cumulative Basis.');

1609: hr_utility.set_location('Etext43'||l_p46_expat_statement,111);
1610:
1611: IF l_p46_expat_eea_citizen = 'Y' AND (l_tax_code_in_use = ' ' OR l_tax_code_in_use IS NULL) THEN
1612: populate_run_msg(p_assactid,'You have not entered a tax code for the EEA Citizen ' || l_assignment_number || '. Ensure you enter Emergency Tax Code on a Cumulative Basis.');
1613: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : You have not entered a tax code for the EEA Citizen ' || l_assignment_number || '. Ensure you enter Emergency Tax Code on a Cumulative Basis.');
1614: edi_validation_fail := 'Y';
1615: END IF;
1616:
1617: IF l_p46_expat_eea_citizen = 'Y' and (l_tax_code_in_use <> ' ' OR l_tax_code_in_use IS NOT NULL) and l_tax_basis_in_use = 'N' THEN

Line 1619: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The tax basis cannot be Week1/Month1 for an EEA Citizen ' || l_assignment_number || ' .');

1615: END IF;
1616:
1617: IF l_p46_expat_eea_citizen = 'Y' and (l_tax_code_in_use <> ' ' OR l_tax_code_in_use IS NOT NULL) and l_tax_basis_in_use = 'N' THEN
1618: populate_run_msg(p_assactid,' The tax basis cannot be Week1/Month1 for an EEA Citizen ' || l_assignment_number || ' .');
1619: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The tax basis cannot be Week1/Month1 for an EEA Citizen ' || l_assignment_number || ' .');
1620: edi_validation_fail := 'Y';
1621: END IF;
1622:
1623: IF l_p46_expat_start_empl_date = ' ' OR l_p46_expat_start_empl_date IS NULL THEN

Line 1625: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The start date of employment in UK (P46EXPAT) for the assignment ' || l_assignment_number || ' is blank. Enter a valid start date.');

1621: END IF;
1622:
1623: IF l_p46_expat_start_empl_date = ' ' OR l_p46_expat_start_empl_date IS NULL THEN
1624: populate_run_msg(p_assactid,' The start date of employment in UK (P46EXPAT) for the assignment ' || l_assignment_number || ' is blank. Enter a valid start date.');
1625: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The start date of employment in UK (P46EXPAT) for the assignment ' || l_assignment_number || ' is blank. Enter a valid start date.');
1626: edi_validation_fail := 'Y';
1627: ELSIF PAY_GB_MOVDED_EDI.date_validate(p_assactid,'UK_EMPL_DATE',to_date(l_p46_expat_start_empl_date,'YYYY/MM/DD HH24:MI:SS')) = 0 THEN
1628: populate_run_msg(p_assactid,' The start date of employment in UK (P46EXPAT) for the assignment ' || l_assignment_number || ' is invalid.');
1629: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The start date of employment in UK (P46EXPAT) for the assignment ' || l_assignment_number || ' is blank. Enter a valid start date.');

Line 1629: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The start date of employment in UK (P46EXPAT) for the assignment ' || l_assignment_number || ' is blank. Enter a valid start date.');

1625: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The start date of employment in UK (P46EXPAT) for the assignment ' || l_assignment_number || ' is blank. Enter a valid start date.');
1626: edi_validation_fail := 'Y';
1627: ELSIF PAY_GB_MOVDED_EDI.date_validate(p_assactid,'UK_EMPL_DATE',to_date(l_p46_expat_start_empl_date,'YYYY/MM/DD HH24:MI:SS')) = 0 THEN
1628: populate_run_msg(p_assactid,' The start date of employment in UK (P46EXPAT) for the assignment ' || l_assignment_number || ' is invalid.');
1629: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The start date of employment in UK (P46EXPAT) for the assignment ' || l_assignment_number || ' is blank. Enter a valid start date.');
1630: edi_validation_fail := 'Y';
1631: END IF;
1632:
1633: IF l_tax_code_in_use = ' ' OR l_tax_code_in_use IS NULL THEN

Line 1635: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Code in use of the assignment ' || l_assignment_number || ' is missing.');

1631: END IF;
1632:
1633: IF l_tax_code_in_use = ' ' OR l_tax_code_in_use IS NULL THEN
1634: populate_run_msg(p_assactid,' The Tax Code in use of the assignment ' || l_assignment_number || ' is missing.');
1635: fnd_file.put_line (fnd_file.LOG,l_assignment_number||' : The Tax Code in use of the assignment ' || l_assignment_number || ' is missing.');
1636: edi_validation_fail := 'Y';
1637: END IF;
1638:
1639: IF ((l_assignment_number <> ' ' OR l_assignment_number IS NOT NULL)

Line 1642: fnd_file.put_line (fnd_file.LOG,' : The Assignment Number has invalid character(s). ' || l_assignment_number);

1638:
1639: IF ((l_assignment_number <> ' ' OR l_assignment_number IS NOT NULL)
1640: and pay_gb_eoy_magtape.validate_input(l_assignment_number,'P14_FULL_EDI') > 0) THEN
1641: populate_run_msg(p_assactid,' Assignment Number has invalid character(s).' || l_assignment_number);
1642: fnd_file.put_line (fnd_file.LOG,' : The Assignment Number has invalid character(s). ' || l_assignment_number);
1643: edi_validation_fail := 'Y';
1644: END IF;
1645:
1646: IF ((l_sex <> 'M' AND l_sex <> 'F') OR (l_sex = ' ' OR l_sex IS NULL)) THEN

Line 1648: fnd_file.put_line (fnd_file.LOG,' : The sex ' || l_sex || ' is undefined for the assignment' || l_assignment_number);

1644: END IF;
1645:
1646: IF ((l_sex <> 'M' AND l_sex <> 'F') OR (l_sex = ' ' OR l_sex IS NULL)) THEN
1647: populate_run_msg(p_assactid,' Sex is undefined for the assignment.' || l_assignment_number);
1648: fnd_file.put_line (fnd_file.LOG,' : The sex ' || l_sex || ' is undefined for the assignment' || l_assignment_number);
1649: edi_validation_fail := 'Y';
1650: END IF;
1651:
1652: IF l_date_of_birth = ' ' OR l_date_of_birth IS NULL THEN

Line 1655: fnd_file.put_line (fnd_file.LOG,' : The Date of Birth of the assignment '|| l_assignment_number || ' is missing.');

1651:
1652: IF l_date_of_birth = ' ' OR l_date_of_birth IS NULL THEN
1653: hr_utility.set_location('Etext43 l_date_of_birth'||l_date_of_birth,111);
1654: populate_run_msg(p_assactid,' The Date of Birth of the assignment ' || l_assignment_number || ' is missing.');
1655: fnd_file.put_line (fnd_file.LOG,' : The Date of Birth of the assignment '|| l_assignment_number || ' is missing.');
1656: edi_validation_fail := 'Y';
1657: END IF;
1658:
1659: IF l_p46_expat_statement = ' ' OR l_p46_expat_statement IS NULL OR (l_p46_expat_statement <> 'A' AND l_p46_expat_statement <> 'B' AND l_p46_expat_statement <> 'C') THEN

Line 1661: fnd_file.put_line (fnd_file.LOG,' : P46EXPAT statement for the assignment ' || l_assignment_number || ' is invalid. The P46EXPAT statement must be A, B or C.');

1657: END IF;
1658:
1659: IF l_p46_expat_statement = ' ' OR l_p46_expat_statement IS NULL OR (l_p46_expat_statement <> 'A' AND l_p46_expat_statement <> 'B' AND l_p46_expat_statement <> 'C') THEN
1660: populate_run_msg(p_assactid,' P46EXPAT statement for the assignment ' || l_assignment_number || ' is invalid. The P46EXPAT statement must be A, B or C.');
1661: fnd_file.put_line (fnd_file.LOG,' : P46EXPAT statement for the assignment ' || l_assignment_number || ' is invalid. The P46EXPAT statement must be A, B or C.');
1662: edi_validation_fail := 'Y';
1663: END IF;
1664:
1665: OPEN get_effective_date;

Line 1681: fnd_file.put_line (fnd_file.LOG,' : The ' || l_msg_value || ':tax code, ' || l_tax_code_in_use || ', for assignment ' || l_assignment_number);

1677:
1678: IF (l_tax_code_in_use <> ' ' OR l_tax_code_in_use IS NOT NULL)
1679: AND (l_msg_value <> ' ') THEN
1680: populate_run_msg(p_assactid, l_msg_value || 'tax code, ' || l_tax_code_in_use || ', for assignment ' || l_assignment_number);
1681: fnd_file.put_line (fnd_file.LOG,' : The ' || l_msg_value || ':tax code, ' || l_tax_code_in_use || ', for assignment ' || l_assignment_number);
1682: edi_validation_fail := 'Y';
1683: END IF;
1684:
1685:

Line 1688: fnd_file.put_line (fnd_file.LOG,' : The Tax Basis in use is not present for Tax code in use, for assignment ' || l_assignment_number);

1684:
1685:
1686: IF (l_tax_code_in_use <>' ' OR l_tax_code_in_use IS NOT NULL) AND (l_tax_basis_in_use = ' ' OR l_tax_basis_in_use IS NULL)THEN
1687: populate_run_msg(p_assactid, 'The Tax Basis in use is not present for Tax code in use, for assignment ' || l_assignment_number);
1688: fnd_file.put_line (fnd_file.LOG,' : The Tax Basis in use is not present for Tax code in use, for assignment ' || l_assignment_number);
1689: edi_validation_fail := 'Y';
1690: END IF;
1691: hr_utility.set_location('Etext44 Leaving',111);
1692:

Line 1844: fnd_file.put_line (fnd_file.LOG,' : The tax code for assignment '|| l_assignment_number ||', must be either BR or 0T.');

1840: if (trunc(l_effective_date) between l_start_date and l_end_date) then
1841: if l_p46_statement ='C' and l_tax_code <> ' ' then
1842: if l_tax_code <>'BR' and l_tax_code <>'0T' then
1843: populate_run_msg(p_assactid,'The tax code for assignment '|| l_assignment_number ||', must be either BR or 0T.');
1844: fnd_file.put_line (fnd_file.LOG,' : The tax code for assignment '|| l_assignment_number ||', must be either BR or 0T.');
1845: edi_validation_fail := 'Y';
1846: l_count_char_errors := l_count_char_errors + 1;
1847: end if;
1848: end if;

Line 1853: fnd_file.put_line (fnd_file.LOG,' : The tax code for assignment '|| l_assignment_number ||', must be 0T.');

1849:
1850: if l_default_p46 = 'Y' and l_tax_code <> ' ' then
1851: if l_tax_code <>'0T' then
1852: populate_run_msg(p_assactid,'The tax code for assignment '|| l_assignment_number ||', must be 0T.');
1853: fnd_file.put_line (fnd_file.LOG,' : The tax code for assignment '|| l_assignment_number ||', must be 0T.');
1854: edi_validation_fail := 'Y';
1855: l_count_char_errors := l_count_char_errors + 1;
1856: end if;
1857: if l_tax_basis <> 'N' then

Line 1859: fnd_file.put_line (fnd_file.LOG,' : The tax basis for assignment '|| l_assignment_number ||', must be Non Cumulative.');

1855: l_count_char_errors := l_count_char_errors + 1;
1856: end if;
1857: if l_tax_basis <> 'N' then
1858: populate_run_msg(p_assactid,'The tax basis for assignment '|| l_assignment_number ||', must be Non Cumulative.');
1859: fnd_file.put_line (fnd_file.LOG,' : The tax basis for assignment '|| l_assignment_number ||', must be Non Cumulative.');
1860: edi_validation_fail := 'Y';
1861: l_count_char_errors := l_count_char_errors + 1;
1862: end if;
1863: end if;

Line 1874: fnd_file.put_line (fnd_file.LOG,' : The National Insurance Number ' || l_national_insurance_number || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

1870: IF l_national_insurance_number <> ' ' THEN
1871: l_session_date := HR_GBNICAR.NICAR_SESSION_DATE(0);
1872: IF hr_gb_utility.ni_validate(l_national_insurance_number,l_session_date)<>0 THEN
1873: populate_run_msg(p_assactid,'The National Insurance Number ' || l_national_insurance_number || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1874: fnd_file.put_line (fnd_file.LOG,' : The National Insurance Number ' || l_national_insurance_number || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1875: edi_validation_fail := 'Y';
1876: l_count_char_errors := l_count_char_errors + 1;
1877: END IF;
1878: END IF;

Line 1882: fnd_file.put_line (fnd_file.LOG,' : The Address Line 1 of the assignment ' || l_assignment_number || ' is missing.');

1878: END IF;
1879:
1880: IF l_address_line1 = ' ' OR l_address_line1 IS NULL THEN
1881: populate_run_msg(p_assactid,'The Address Line 1 of the assignment ' || l_assignment_number || ' is missing.');
1882: fnd_file.put_line (fnd_file.LOG,' : The Address Line 1 of the assignment ' || l_assignment_number || ' is missing.');
1883: edi_validation_fail := 'Y';
1884: l_count_missing_val := l_count_missing_val + 1;
1885: ELSIF pay_gb_eoy_magtape.validate_input(l_address_line1,'P14_FULL_EDI') > 0 THEN
1886: populate_run_msg(p_assactid,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

Line 1887: fnd_file.put_line (fnd_file.LOG,' : The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

1883: edi_validation_fail := 'Y';
1884: l_count_missing_val := l_count_missing_val + 1;
1885: ELSIF pay_gb_eoy_magtape.validate_input(l_address_line1,'P14_FULL_EDI') > 0 THEN
1886: populate_run_msg(p_assactid,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1887: fnd_file.put_line (fnd_file.LOG,' : The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1888: edi_validation_fail := 'Y';
1889: l_count_char_errors := l_count_char_errors + 1;
1890: END IF;
1891:

Line 1894: fnd_file.put_line (fnd_file.LOG,' : The Address Line 2 of the assignment ' || l_assignment_number || ' is missing.');

1890: END IF;
1891:
1892: IF l_address_line2 = ' ' OR l_address_line2 IS NULL THEN
1893: populate_run_msg(p_assactid,'The Address Line 2 of the assignment ' || l_assignment_number || ' is missing.');
1894: fnd_file.put_line (fnd_file.LOG,' : The Address Line 2 of the assignment ' || l_assignment_number || ' is missing.');
1895: edi_validation_fail := 'Y';
1896: l_count_missing_val := l_count_missing_val + 1;
1897: ELSIF pay_gb_eoy_magtape.validate_input(l_address_line2,'P14_FULL_EDI') > 0 THEN
1898: populate_run_msg(p_assactid,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid character(s).');

Line 1899: fnd_file.put_line (fnd_file.LOG,' : The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid character(s).');

1895: edi_validation_fail := 'Y';
1896: l_count_missing_val := l_count_missing_val + 1;
1897: ELSIF pay_gb_eoy_magtape.validate_input(l_address_line2,'P14_FULL_EDI') > 0 THEN
1898: populate_run_msg(p_assactid,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid character(s).');
1899: fnd_file.put_line (fnd_file.LOG,' : The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid character(s).');
1900: edi_validation_fail := 'Y';
1901: l_count_char_errors := l_count_char_errors + 1;
1902: END IF;
1903:

Line 1907: fnd_file.put_line (fnd_file.LOG,' : The Address Line 3 ' || l_address_line3 || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

1903:
1904: IF l_address_line3 <> ' ' OR l_address_line3 IS NOT NULL THEN
1905: IF pay_gb_eoy_magtape.validate_input(l_address_line3,'P14_FULL_EDI') > 0 THEN
1906: populate_run_msg(p_assactid,'The Address Line 3 ' || l_address_line3 || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1907: fnd_file.put_line (fnd_file.LOG,' : The Address Line 3 ' || l_address_line3 || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1908: edi_validation_fail := 'Y';
1909: l_count_char_errors := l_count_char_errors + 1;
1910: END IF;
1911: END IF;

Line 1916: fnd_file.put_line (fnd_file.LOG,' : The Town Or City ' || l_town_or_city ||' of the assignment ' || l_assignment_number || ' has invalid character(s).');

1912:
1913: IF l_town_or_city <> ' ' OR l_town_or_city IS NOT NULL THEN
1914: IF pay_gb_eoy_magtape.validate_input(l_town_or_city,'P14_FULL_EDI') > 0 THEN
1915: populate_run_msg(p_assactid,'The Town Or City ' || l_town_or_city || ' of the assignment '|| l_assignment_number || ' has invalid character(s).');
1916: fnd_file.put_line (fnd_file.LOG,' : The Town Or City ' || l_town_or_city ||' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1917: edi_validation_fail := 'Y';
1918: l_count_char_errors := l_count_char_errors + 1;
1919: END IF;
1920: END IF;

Line 1925: fnd_file.put_line (fnd_file.LOG,' : The County ' || l_county || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

1921:
1922: IF l_county <> ' ' OR l_county IS NOT NULL THEN
1923: IF pay_gb_eoy_magtape.validate_input(l_county,'P14_FULL_EDI') > 0 THEN
1924: populate_run_msg(p_assactid,'The County ' || l_county || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1925: fnd_file.put_line (fnd_file.LOG,' : The County ' || l_county || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1926: edi_validation_fail := 'Y';
1927: l_count_char_errors := l_count_char_errors + 1;
1928: END IF;
1929: END IF;

Line 1933: fnd_file.put_line (fnd_file.LOG,' : The Last Name of the assignment '|| l_assignment_number || ' is missing.');

1929: END IF;
1930:
1931: IF l_last_name = ' ' OR per_formula_functions.isnull(l_last_name)='Y' THEN
1932: populate_run_msg(p_assactid,'The Last Name of the assignment ' || l_assignment_number || ' is missing.');
1933: fnd_file.put_line (fnd_file.LOG,' : The Last Name of the assignment '|| l_assignment_number || ' is missing.');
1934: edi_validation_fail := 'Y';
1935: l_count_missing_val := l_count_missing_val + 1;
1936: elsif pay_gb_eoy_magtape.validate_input(l_last_name,'P45_46_LAST_NAME') > 0 then
1937: populate_run_msg(p_assactid,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

Line 1938: fnd_file.put_line (fnd_file.LOG,' : The Last Name ' + l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

1934: edi_validation_fail := 'Y';
1935: l_count_missing_val := l_count_missing_val + 1;
1936: elsif pay_gb_eoy_magtape.validate_input(l_last_name,'P45_46_LAST_NAME') > 0 then
1937: populate_run_msg(p_assactid,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1938: fnd_file.put_line (fnd_file.LOG,' : The Last Name ' + l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1939: edi_validation_fail := 'Y';
1940: l_count_char_errors := l_count_char_errors + 1;
1941: END IF;
1942:

Line 1945: fnd_file.put_line (fnd_file.LOG,' : The First Name of the assignment ' || l_assignment_number || ' is missing.');

1941: END IF;
1942:
1943: IF l_first_name = ' ' OR per_formula_functions.isnull(l_first_name)='Y' THEN
1944: populate_run_msg(p_assactid,'The First Name of the assignment '|| l_assignment_number || ' is missing.');
1945: fnd_file.put_line (fnd_file.LOG,' : The First Name of the assignment ' || l_assignment_number || ' is missing.');
1946: edi_validation_fail := 'Y';
1947: l_count_missing_val := l_count_missing_val + 1;
1948:
1949: ELSIF pay_gb_eoy_magtape.validate_input(l_first_name,'P45_46_FIRST_NAME') > 0 THEN

Line 1951: fnd_file.put_line (fnd_file.LOG,' : The First Name ' || l_first_name || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

1947: l_count_missing_val := l_count_missing_val + 1;
1948:
1949: ELSIF pay_gb_eoy_magtape.validate_input(l_first_name,'P45_46_FIRST_NAME') > 0 THEN
1950: populate_run_msg(p_assactid,'The First Name ' || l_first_name ||' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1951: fnd_file.put_line (fnd_file.LOG,' : The First Name ' || l_first_name || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1952: edi_validation_fail := 'Y';
1953: l_count_char_errors := l_count_char_errors + 1;
1954: END IF;
1955:

Line 1959: fnd_file.put_line (fnd_file.LOG,' : The Middle Name ' || l_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

1955:
1956: IF l_middle_name <> ' ' AND per_formula_functions.isnull(l_middle_name)<>'Y' THEN
1957: IF pay_gb_eoy_magtape.validate_input(l_middle_name,'P45_46_FIRST_NAME') > 0 THEN
1958: populate_run_msg(p_assactid,'The Middle Name ' || l_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1959: fnd_file.put_line (fnd_file.LOG,' : The Middle Name ' || l_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1960: edi_validation_fail := 'Y';
1961: l_count_char_errors := l_count_char_errors + 1;
1962: END IF;
1963: END IF;

Line 1968: fnd_file.put_line (fnd_file.LOG,' : The Title ' || l_title || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

1964:
1965: IF l_title <> ' ' AND per_formula_functions.isnull(l_title)<>'Y' THEN
1966: IF pay_gb_eoy_magtape.validate_input(l_title,'P45_46_TITLE') > 0 THEN
1967: populate_run_msg(p_assactid,'The Title ' || l_title || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1968: fnd_file.put_line (fnd_file.LOG,' : The Title ' || l_title || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1969: edi_validation_fail := 'Y';
1970: l_count_char_errors := l_count_char_errors + 1;
1971: END IF;
1972: END IF;

Line 1977: fnd_file.put_line (fnd_file.LOG,' : The Postal Code ' || l_postal_code || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

1973:
1974: IF l_postal_code <> ' ' OR l_postal_code IS NOT NULL THEN
1975: IF pay_gb_eoy_magtape.validate_input(l_postal_code,'P45_46_POSTCODE') > 0 THEN
1976: populate_run_msg(p_assactid,'The Postal Code ' || l_postal_code || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1977: fnd_file.put_line (fnd_file.LOG,' : The Postal Code ' || l_postal_code || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1978: edi_validation_fail := 'Y';
1979: l_count_char_errors := l_count_char_errors + 1;
1980: END IF;
1981: END IF;

Line 1987: fnd_file.put_line (fnd_file.LOG,' : The Assignment Number ' || l_assignment_number || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

1983: -- below validations are from fetch_person_rec
1984: IF l_assignment_number <> ' ' OR l_assignment_number IS NOT NULL THEN
1985: IF pay_gb_eoy_magtape.validate_input(upper(l_assignment_number),'FULL_EDI') > 0 THEN --Added 'upper' to fix the bug 9503248
1986: populate_run_msg(p_assactid,'The Assignment Number ' || l_assignment_number || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1987: fnd_file.put_line (fnd_file.LOG,' : The Assignment Number ' || l_assignment_number || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1988: edi_validation_fail := 'Y';
1989: l_count_char_errors := l_count_char_errors + 1;
1990: END IF;
1991: END IF;

Line 1996: fnd_file.put_line (fnd_file.LOG,' : The Job Title ' || l_job_title || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

1992:
1993: IF l_job_title <> ' ' OR l_job_title IS NOT NULL THEN
1994: IF pay_gb_eoy_magtape.validate_input(l_job_title,'P14_FULL_EDI') > 0 THEN
1995: populate_run_msg(p_assactid,'The Job Title ' || l_job_title || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1996: fnd_file.put_line (fnd_file.LOG,' : The Job Title ' || l_job_title || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1997: edi_validation_fail := 'Y';
1998: END IF;
1999: END IF;
2000:

Line 2004: fnd_file.put_line (fnd_file.LOG,' : The National Identifier ' || l_national_identifier || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

2000:
2001: IF l_national_identifier is not null AND
2002: hr_gb_utility.ni_validate(l_national_identifier,sysdate) <> 0 THEN
2003: populate_run_msg(p_assactid,'The National Identifier ' || l_national_identifier || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
2004: fnd_file.put_line (fnd_file.LOG,' : The National Identifier ' || l_national_identifier || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
2005: edi_validation_fail := 'Y';
2006: END IF;
2007:
2008: /* 10095492 - Commented out below check inorder to make etext validations in sync with other in-year filing reports */

Line 2012: fnd_file.put_line (fnd_file.LOG,' : The Tax Code ' || l_tax_code || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

2008: /* 10095492 - Commented out below check inorder to make etext validations in sync with other in-year filing reports */
2009: /*
2010: IF (hr_gb_utility.tax_code_validate(l_tax_code,sysdate,l_assignment_id) <> ' ') THEN
2011: populate_run_msg(p_assactid,'The Tax Code ' || l_tax_code || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
2012: fnd_file.put_line (fnd_file.LOG,' : The Tax Code ' || l_tax_code || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
2013: edi_validation_fail := 'Y';
2014: END IF;
2015: */
2016:

Line 2021: fnd_file.put_line (fnd_file.LOG,' : The Tax Code ' || l_tax_code || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');

2017: --Added below validation for the bug fix 10409668
2018: --This is same as the above validation, but here we are passing l_effective_date instead of sysdate
2019: IF (hr_gb_utility.tax_code_validate(l_tax_code,l_effective_date,l_assignment_id) <> ' ') THEN
2020: populate_run_msg(p_assactid,'The Tax Code ' || l_tax_code || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
2021: fnd_file.put_line (fnd_file.LOG,' : The Tax Code ' || l_tax_code || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
2022: edi_validation_fail := 'Y';
2023: END IF;
2024:
2025: hr_utility.set_location('Etext50 Leaving',111);

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

2068:
2069: l_p46_rec csr_p46_details%rowtype;
2070: BEGIN
2071: hr_utility.set_location('Entering: '||l_proc,1);
2072: fnd_file.put_line(fnd_file.LOG,'Entering: '||l_proc);
2073: l_arch := true;
2074:
2075: open csr_p46_details;
2076: fetch csr_p46_details into l_p46_rec;

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

2136: p_p46_rec.act_info2 := l_p46_rec.p46_statement;
2137: p_p46_rec.act_info3 := l_p46_rec.student_loan;
2138: p_p46_rec.act_info4 := l_def_archive;
2139: hr_utility.set_location('Leaving: '||l_proc,999);
2140: fnd_file.put_line(fnd_file.LOG,'Leaving: '||l_proc);
2141: return l_arch;
2142: END fetch_p46_5_rec;
2143: --
2144: FUNCTION fetch_p46p_rec(p_effective_date IN DATE,

Line 2322: fnd_file.put_line(fnd_file.output,'The HMRC Office Number is missing.');

2318: IF l_tax_dist_no is null
2319: THEN
2320: l_err := TRUE;
2321: hr_utility.set_location('The HMRC Office Number is missing.',10);
2322: fnd_file.put_line(fnd_file.output,'The HMRC Office Number is missing.');
2323: END IF;
2324:
2325:
2326: IF l_tax_dist_ref is null

Line 2330: fnd_file.put_line(fnd_file.output,'The employer''s PAYE Reference is missing.');

2326: IF l_tax_dist_ref is null
2327: THEN
2328: l_err := TRUE;
2329: hr_utility.set_location('The employer''s PAYE Reference is missing.',10);
2330: fnd_file.put_line(fnd_file.output,'The employer''s PAYE Reference is missing.');
2331:
2332: ELSIF pay_gb_eoy_magtape.validate_input(l_tax_dist_ref,'P14_FULL_EDI') > 0
2333: THEN
2334: l_err := TRUE;

Line 2336: fnd_file.put_line(fnd_file.output,'The employer''s PAYE Reference contains invalid characters.');

2332: ELSIF pay_gb_eoy_magtape.validate_input(l_tax_dist_ref,'P14_FULL_EDI') > 0
2333: THEN
2334: l_err := TRUE;
2335: hr_utility.set_location('The employer''s PAYE Reference contains invalid characters.',10);
2336: fnd_file.put_line(fnd_file.output,'The employer''s PAYE Reference contains invalid characters.');
2337: END IF;
2338:
2339: --Employer name validations
2340: IF p_employer_name IS NULL

Line 2344: fnd_file.put_line(fnd_file.output,'The employer''s name is missing for employer''s PAYE Reference '||p_tax_ref);

2340: IF p_employer_name IS NULL
2341: THEN
2342: l_err := TRUE;
2343: hr_utility.set_location('The employer''s name is missing for employer''s PAYE Reference '||p_tax_ref,10);
2344: fnd_file.put_line(fnd_file.output,'The employer''s name is missing for employer''s PAYE Reference '||p_tax_ref);
2345:
2346: ELSIF pay_gb_eoy_magtape.validate_input(p_employer_name,'P14_FULL_EDI') > 0
2347: THEN
2348: l_err := TRUE;

Line 2350: fnd_file.put_line(fnd_file.output,'The employer''s name '||p_employer_name||' contains invalid character(s) for the employer''s PAYE Reference '||p_tax_ref);

2346: ELSIF pay_gb_eoy_magtape.validate_input(p_employer_name,'P14_FULL_EDI') > 0
2347: THEN
2348: l_err := TRUE;
2349: hr_utility.set_location('The employer''s name '||p_employer_name||' contains invalid character(s) for the employer''s PAYE Reference '||p_tax_ref,10);
2350: fnd_file.put_line(fnd_file.output,'The employer''s name '||p_employer_name||' contains invalid character(s) for the employer''s PAYE Reference '||p_tax_ref);
2351: END IF;
2352:
2353: --Test Indicator validations
2354: IF p_tst_indi = 'Y'

Line 2360: fnd_file.put_line(fnd_file.output,'The Test ID '||p_tst_id||' contains invalid character(s).');

2356: IF pay_gb_eoy_magtape.validate_input(p_tst_id,'MIXED_CHAR_ALPHA_NUM') > 0
2357: THEN
2358: l_err := TRUE;
2359: hr_utility.set_location('The Test ID '||p_tst_id||' contains invalid character(s).',10);
2360: fnd_file.put_line(fnd_file.output,'The Test ID '||p_tst_id||' contains invalid character(s).');
2361: END IF;
2362: END IF;
2363:
2364: hr_utility.set_location('Leaving: '||l_proc,999);

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

2526: l_report_type = 'P46EXP_VER6' or l_report_type = 'P46EXP_VER6ET' or
2527: l_report_type = 'P46_VER6ET' THEN --Bugs 9255173 and 9255183
2528: /* changes for P46_ver6_pennot ends **/
2529: IF (l_test_indicator = 'Y' AND l_test_id IS NULL) THEN
2530: fnd_file.put_line (fnd_file.LOG,'Enter the Test ID as EDI Test Indicator is Yes.');
2531: RAISE test_indicator_error;
2532: END IF;
2533: END IF;
2534: /* Changes for P45PT3 end*/

Line 2727: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Tax Code in use of the assignment '||l_assignment_number||' is missing.');

2723: THEN
2724: l_err := TRUE;
2725: populate_run_msg(p_assactid,'The Tax Code in use of the assignment '||l_assignment_number||' is missing.');
2726: hr_utility.set_location('The Tax Code in use of the assignment '||l_assignment_number||' is missing.',10);
2727: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Tax Code in use of the assignment '||l_assignment_number||' is missing.');
2728: END IF;
2729:
2730: IF l_assignment_number IS NOT NULL
2731: AND pay_gb_eoy_magtape.validate_input(l_assignment_number,'P14_FULL_EDI') > 0

Line 2736: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Assignment Number '||l_assignment_number||' has invalid character(s).');

2732: THEN
2733: l_err := TRUE;
2734: populate_run_msg(p_assactid,'The Assignment Number '||l_assignment_number||' has invalid character(s).');
2735: hr_utility.set_location('The Assignment Number '||l_assignment_number||' has invalid character(s).',10);
2736: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Assignment Number '||l_assignment_number||' has invalid character(s).');
2737: END IF;
2738:
2739: IF l_sex IS NULL
2740: THEN

Line 2744: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Sex of the assignment '||l_assignment_number||' is missing.');

2740: THEN
2741: l_err := TRUE;
2742: populate_run_msg(p_assactid,'The Sex of the assignment '||l_assignment_number||' is missing.');
2743: hr_utility.set_location('The Sex of the assignment '||l_assignment_number||' is missing.',10);
2744: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Sex of the assignment '||l_assignment_number||' is missing.');
2745: ELSIF l_sex NOT IN ('M', 'F')
2746: THEN
2747: l_err := TRUE;
2748: populate_run_msg(p_assactid,'The sex '||l_sex||' is undefined for the assignment'||l_assignment_number);

Line 2750: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The sex '||l_sex||' is undefined for the assignment'||l_assignment_number);

2746: THEN
2747: l_err := TRUE;
2748: populate_run_msg(p_assactid,'The sex '||l_sex||' is undefined for the assignment'||l_assignment_number);
2749: hr_utility.set_location('The sex '||l_sex||' is undefined for the assignment'||l_assignment_number,10);
2750: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The sex '||l_sex||' is undefined for the assignment'||l_assignment_number);
2751: END IF;
2752:
2753: IF l_date_of_birth IS NULL
2754: THEN

Line 2758: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Date of Birth of the assignment '||l_assignment_number||' is missing.');

2754: THEN
2755: l_err := TRUE;
2756: populate_run_msg(p_assactid,'The Date of Birth of the assignment '||l_assignment_number||' is missing.');
2757: hr_utility.set_location('The Date of Birth of the assignment '||l_assignment_number||' is missing.',10);
2758: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Date of Birth of the assignment '||l_assignment_number||' is missing.');
2759: END IF;
2760:
2761: IF l_default_p46 = 'N' AND l_p46_statement IS NULL
2762: THEN

Line 2766: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The assignment, '||l_assignment_number||', does not have a P46 Statement for a Normal P46 Process.');

2762: THEN
2763: l_err := TRUE;
2764: populate_run_msg(p_assactid,'The assignment, '||l_assignment_number||', does not have a P46 Statement for a Normal P46 Process.');
2765: hr_utility.set_location('The assignment, '||l_assignment_number||', does not have a P46 Statement for a Normal P46 Process.',10);
2766: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The assignment, '||l_assignment_number||', does not have a P46 Statement for a Normal P46 Process.');
2767: END IF;
2768:
2769: IF l_hire_date IS NULL
2770: THEN

Line 2774: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The assignment, '||l_assignment_number||', does not have a Hire Date.');

2770: THEN
2771: l_err := TRUE;
2772: populate_run_msg(p_assactid,'The assignment, '||l_assignment_number||', does not have a Hire Date.');
2773: hr_utility.set_location('The assignment, '||l_assignment_number||', does not have a Hire Date.',10);
2774: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The assignment, '||l_assignment_number||', does not have a Hire Date.');
2775: END IF;
2776:
2777:
2778: l_msg_value := pay_gb_eoy_magtape.validate_tax_code_yrfil(p_assactid,l_tax_code_in_use,p_effective_date);

Line 2786: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The '||l_msg_value||':tax code, '||l_tax_code_in_use||', for assignment '||l_assignment_number);

2782: THEN
2783: l_err := TRUE;
2784: populate_run_msg(p_assactid,'The '||l_msg_value||':tax code, '||l_tax_code_in_use||', for assignment '||l_assignment_number);
2785: hr_utility.set_location('The '||l_msg_value||':tax code, '||l_tax_code_in_use||', for assignment '||l_assignment_number,10);
2786: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The '||l_msg_value||':tax code, '||l_tax_code_in_use||', for assignment '||l_assignment_number);
2787: END IF;
2788:
2789: IF l_tax_code_in_use IS NOT NULL
2790: AND l_tax_basis_in_use IS NULL

Line 2795: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Tax Basis in use is not present for Tax code in use, for assignment '||l_assignment_number);

2791: THEN
2792: l_err := TRUE;
2793: populate_run_msg(p_assactid,'The Tax Basis in use is not present for Tax code in use, for assignment '||l_assignment_number);
2794: hr_utility.set_location('The Tax Basis in use is not present for Tax code in use, for assignment '||l_assignment_number,10);
2795: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Tax Basis in use is not present for Tax code in use, for assignment '||l_assignment_number);
2796: END IF;
2797:
2798: hr_utility.set_location('Leaving: '||l_proc,999);
2799: RETURN l_err;

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

2836:
2837: BEGIN
2838: hr_utility.trace('\n xxxx Test Indicator='||pay_magtape_generic.get_parameter_value('TEST'));
2839: --hr_utility.trace_on(null,'TKP');
2840: fnd_file.put_line(fnd_file.LOG,'Entering: '||l_proc);
2841: --hr_utility.trace('Tushar effective date is '|| to_char(p_effective_date,'DD-MON-YYYY') );
2842: --hr_utility.set_location('Entering: '||l_proc,1);
2843: open csr_archive_type;
2844: fetch csr_archive_type into l_archive_type;

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

2953: THEN
2954: IF l_asg_val_err OR l_p46_val_err OR l_p46exp_val_err
2955: THEN
2956: hr_utility.set_location('Validation failed, raise error.',999);
2957: fnd_file.put_line(fnd_file.LOG,'Archiving');
2958: raise error_found;
2959: ELSE
2960: hr_utility.set_location('Validation successful, archive data.',999);
2961: insert_archive_row(p_assactid, p_effective_date, l_archive_tab);

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

2963: ELSE
2964: insert_archive_row(p_assactid, p_effective_date, l_archive_tab);
2965: END IF;
2966: else
2967: fnd_file.put_line(fnd_file.LOG,'Archiving');
2968: raise error_found;
2969: end if;
2970:
2971: hr_utility.set_location('Leaving: '||l_proc,999);

Line 3167: fnd_file.put_line(fnd_file.log,'Inside Deinit. Print error msgs');

3163:
3164: --For bugs 9255173 and 9255183
3165: IF l_param.report_type = 'P46_VER6ET' or l_param.report_type = 'P46EXP_VER6ET'
3166: THEN
3167: fnd_file.put_line(fnd_file.log,'Inside Deinit. Print error msgs');
3168: FOR act_actions IN csr_act_actions
3169: LOOP
3170: FOR msg_rec IN messages(act_actions.assignment_action_id)
3171: LOOP

Line 3172: fnd_file.put_line(fnd_file.output,substr(msg_rec.error_text,1,255));

3168: FOR act_actions IN csr_act_actions
3169: LOOP
3170: FOR msg_rec IN messages(act_actions.assignment_action_id)
3171: LOOP
3172: fnd_file.put_line(fnd_file.output,substr(msg_rec.error_text,1,255));
3173: END LOOP;
3174: END LOOP;
3175: END IF;
3176:

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

3173: END LOOP;
3174: END LOOP;
3175: END IF;
3176:
3177: fnd_file.put_line(fnd_file.output,' ');
3178: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
3179: fnd_file.put_line(fnd_file.output,' ');
3180: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );
3181: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);

Line 3178: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');

3174: END LOOP;
3175: END IF;
3176:
3177: fnd_file.put_line(fnd_file.output,' ');
3178: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
3179: fnd_file.put_line(fnd_file.output,' ');
3180: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );
3181: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3182: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));

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

3175: END IF;
3176:
3177: fnd_file.put_line(fnd_file.output,' ');
3178: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
3179: fnd_file.put_line(fnd_file.output,' ');
3180: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );
3181: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3182: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3183: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);

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

3176:
3177: fnd_file.put_line(fnd_file.output,' ');
3178: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
3179: fnd_file.put_line(fnd_file.output,' ');
3180: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );
3181: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3182: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3183: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3184: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);

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

3177: fnd_file.put_line(fnd_file.output,' ');
3178: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
3179: fnd_file.put_line(fnd_file.output,' ');
3180: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );
3181: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3182: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3183: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3184: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3185: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);

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

3178: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
3179: fnd_file.put_line(fnd_file.output,' ');
3180: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );
3181: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3182: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3183: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3184: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3185: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
3186: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));

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

3179: fnd_file.put_line(fnd_file.output,' ');
3180: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );
3181: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3182: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3183: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3184: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3185: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
3186: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3187: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);

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

3180: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form );
3181: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3182: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3183: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3184: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3185: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
3186: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3187: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
3188: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);

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

3181: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
3182: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3183: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3184: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3185: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
3186: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3187: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
3188: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
3189: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);

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

3182: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
3183: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3184: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3185: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
3186: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3187: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
3188: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
3189: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
3190: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);

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

3183: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
3184: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3185: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
3186: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3187: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
3188: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
3189: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
3190: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
3191: if length(l_addr2) > 0 then

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

3184: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
3185: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
3186: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3187: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
3188: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
3189: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
3190: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
3191: if length(l_addr2) > 0 then
3192: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);

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

3185: fnd_file.put_line(fnd_file.output,rpad('Urgent : ',32) || l_urgent);
3186: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3187: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
3188: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
3189: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
3190: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
3191: if length(l_addr2) > 0 then
3192: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
3193: end if;

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

3186: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
3187: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
3188: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
3189: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
3190: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
3191: if length(l_addr2) > 0 then
3192: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
3193: end if;
3194: if length(l_addr3) > 0 then

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

3188: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
3189: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
3190: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
3191: if length(l_addr2) > 0 then
3192: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
3193: end if;
3194: if length(l_addr3) > 0 then
3195: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
3196: end if;

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

3191: if length(l_addr2) > 0 then
3192: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
3193: end if;
3194: if length(l_addr3) > 0 then
3195: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
3196: end if;
3197: if length(l_addr4) > 0 then
3198: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
3199: end if;

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

3194: if length(l_addr3) > 0 then
3195: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
3196: end if;
3197: if length(l_addr4) > 0 then
3198: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
3199: end if;
3200: end write_header;
3201:
3202: procedure write_sub_header(p_type varchar2) is

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

3200: end write_header;
3201:
3202: procedure write_sub_header(p_type varchar2) is
3203: begin
3204: fnd_file.put_line(fnd_file.output,null);
3205: if p_type = 'E' then
3206: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');
3207: else
3208: fnd_file.put_line(fnd_file.output,'The following assignments have completed successfully');

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

3202: procedure write_sub_header(p_type varchar2) is
3203: begin
3204: fnd_file.put_line(fnd_file.output,null);
3205: if p_type = 'E' then
3206: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');
3207: else
3208: fnd_file.put_line(fnd_file.output,'The following assignments have completed successfully');
3209: end if;
3210: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) ||

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

3204: fnd_file.put_line(fnd_file.output,null);
3205: if p_type = 'E' then
3206: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');
3207: else
3208: fnd_file.put_line(fnd_file.output,'The following assignments have completed successfully');
3209: end if;
3210: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) ||
3211: rpad('NI Number',11) ||
3212: rpad('Employee Name', 50));

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

3206: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');
3207: else
3208: fnd_file.put_line(fnd_file.output,'The following assignments have completed successfully');
3209: end if;
3210: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) ||
3211: rpad('NI Number',11) ||
3212: rpad('Employee Name', 50));
3213: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
3214: rpad('-',10,'-') || ' ' ||

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

3209: end if;
3210: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) ||
3211: rpad('NI Number',11) ||
3212: rpad('Employee Name', 50));
3213: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' ||
3214: rpad('-',10,'-') || ' ' ||
3215: rpad('-',50,'-'));
3216: end write_sub_header;
3217:

Line 3275: fnd_file.put_line(fnd_file.output,rpad(g_edi_errors_table(i).assignment_number, 18) || ' ' ||

3271: IF g_edi_errors_table(i).status = p_type THEN
3272: l_temp := g_edi_errors_table(i).last_name || ', '|| g_edi_errors_table(i).title || ' ' ||
3273: g_edi_errors_table(i).first_name || ' ' || g_edi_errors_table(i).middle_name ;
3274:
3275: fnd_file.put_line(fnd_file.output,rpad(g_edi_errors_table(i).assignment_number, 18) || ' ' ||
3276: rpad(g_edi_errors_table(i).ni_number ,10) || ' ' ||
3277: rpad(l_temp,50));
3278: l_count := l_count + 1;
3279: END IF;

Line 3287: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' ||

3283: IF p_type = 'ET'THEN
3284: FOR et_asg_rec IN csr_et_asg LOOP
3285: l_et_temp := et_asg_rec.l_name || ', '|| et_asg_rec.title || ' ' ||
3286: et_asg_rec.f_name || ' ' || et_asg_rec.m_name;
3287: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' ||
3288: rpad(et_asg_rec.ni_no ,10) || ' ' ||
3289: rpad(l_et_temp,50));
3290: l_count := l_count + 1;
3291: END LOOP;

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

3294: IF p_type = 'E'THEN
3295: FOR asg_rec IN csr_asg LOOP
3296: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' ||
3297: asg_rec.f_name || ' ' || asg_rec.m_name;
3298: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' ||
3299: rpad(asg_rec.ni_no ,10) || ' ' ||
3300: rpad(l_temp,50));
3301: l_count := l_count + 1;
3302: END LOOP;

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

3301: l_count := l_count + 1;
3302: END LOOP;
3303: END IF;
3304:
3305: fnd_file.put_line(fnd_file.output,null);
3306: if p_type = 'E' then
3307: fnd_file.put_line(fnd_file.output,'Total Number of assignments completed with error : ' || l_count);
3308: else
3309: fnd_file.put_line(fnd_file.output,'Total Number of assignments completed successfully :' || l_count);

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

3303: END IF;
3304:
3305: fnd_file.put_line(fnd_file.output,null);
3306: if p_type = 'E' then
3307: fnd_file.put_line(fnd_file.output,'Total Number of assignments completed with error : ' || l_count);
3308: else
3309: fnd_file.put_line(fnd_file.output,'Total Number of assignments completed successfully :' || l_count);
3310: end if;
3311: l_counter := l_counter + l_count;

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

3305: fnd_file.put_line(fnd_file.output,null);
3306: if p_type = 'E' then
3307: fnd_file.put_line(fnd_file.output,'Total Number of assignments completed with error : ' || l_count);
3308: else
3309: fnd_file.put_line(fnd_file.output,'Total Number of assignments completed successfully :' || l_count);
3310: end if;
3311: l_counter := l_counter + l_count;
3312: end write_body;
3313:

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

3312: end write_body;
3313:
3314: procedure write_footer is
3315: begin
3316: fnd_file.put_line(fnd_file.output,null);
3317: fnd_file.put_line(fnd_file.output,'Total Number Of Records : ' || l_counter);
3318: end write_footer;
3319: BEGIN
3320: hr_utility.set_location('Entering: '||l_proc,1);

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

3313:
3314: procedure write_footer is
3315: begin
3316: fnd_file.put_line(fnd_file.output,null);
3317: fnd_file.put_line(fnd_file.output,'Total Number Of Records : ' || l_counter);
3318: end write_footer;
3319: BEGIN
3320: hr_utility.set_location('Entering: '||l_proc,1);
3321: