[Home] [Help]
126: of last assignment before termination.
127: 09-FEB-2004 A.Mills 115.36 3433915. Also added suspended assignments to
128: future_active_exists to remedy issue.
129: 17-FEB-2004 A.Mills 115.37 Change to payment_made function. Plus use
130: fnd_file calls to place non-p45s in log.
131: 3452081.
132: 03-MAR-2004 A.Mills 115.38 3473274. For 1st period of new starter, the
133: c_act query raises exception, handle this in
134: code.
1467: -- and Raise an unhandled exception to fail the process.
1468: --
1469: IF l_report_type = 'P45PT1' and l_report_category = 'EDI' THEN
1470: IF (l_test_indicator = 'Y' AND l_test_id IS NULL) THEN
1471: fnd_file.put_line (fnd_file.LOG,'Error : Enter the Test ID as the EDI Test Indicator is Yes.');
1472: RAISE test_indicator_error;
1473: END IF;
1474: END IF;
1475: --
1511: AND to_date('05/04/'||to_char(l_chk_start_date,'YYYY'),'dd/mm/yyyy')))
1512: THEN
1513: hr_utility.set_location('Start Date and End Date are in the same tax year ',6);
1514: ELSE
1515: fnd_file.put_line (fnd_file.LOG, 'The Start Date and the End Date must be within the tax year.');
1516: hr_utility.set_location('The Start Date and the End Date must be within the tax year.',8);
1517: RAISE p45_one_taxyear_error;
1518: END IF;
1519: END;
2521: if l_archive = FALSE then
2522: hr_utility.trace('No P45 for '||to_char(rec_asg.assignment_id)||
2523: '. Reason:');
2524: hr_utility.trace(l_non_p45_message);
2525: fnd_file.put_line(fnd_file.log,
2526: rec_asg.assignment_number||': '|| l_non_p45_message);
2527: l_non_p45_message := null;
2528: else
2529: hr_utility.set_location(l_proc,107);
2580: else
2581: hr_utility.set_location(l_proc,130);
2582: hr_utility.trace('No P45 for '||to_char(rec_asg.assignment_id)||
2583: '. Tax Code = NI');
2584: fnd_file.put_line(fnd_file.log,
2585: rec_asg.assignment_number||': Tax Code = NI');
2586: end if; -- NI Tax Code
2587: end if; -- archive FALSE
2588: END LOOP; -- csr_all_assignments