APPS.PAY_GB_RTI_FPS_VALIDATE_13 dependencies on FND_DATE

Line 943: IF l_payment_date < fnd_date.canonical_to_date('2012/04/06 00:00:00') THEN

939: END IF;
940:
941:
942: IF l_payment_date IS NOT NULL THEN
943: IF l_payment_date < fnd_date.canonical_to_date('2012/04/06 00:00:00') THEN
944: populate_run_msg(p_assactid, 'The Payment Date ' ||l_payment_date|| ' for assignment ' || l_assignment_number||' is invalid.');
945: fnd_file.put_line (fnd_file.LOG,'The Payment Date ' ||l_payment_date|| ' for assignment ' || l_assignment_number||' is invalid.');
946: edi_validation_fail := 'Y';
947: END IF;

Line 1065: l_end_date = fnd_date.canonical_to_date('4712/12/31') THEN

1061: edi_validation_fail := 'Y';
1062: END IF;
1063:
1064: IF l_payment_after_leaving = 'Y' AND
1065: l_end_date = fnd_date.canonical_to_date('4712/12/31') THEN
1066: populate_run_msg(p_assactid, 'The Date of Leaving is missing for assignment ' || l_assignment_number|| ',although Payment after leaving indicator is present.');
1067: fnd_file.put_line (fnd_file.LOG,'The Date of Leaving is missing for assignment ' || l_assignment_number|| ',although Payment after leaving indicator is present.');
1068: edi_validation_fail := 'Y';
1069: END IF;

Line 1475: IF l_payment_date < fnd_date.canonical_to_date('2012/04/06 00:00:00') THEN

1471: END IF;
1472:
1473:
1474: IF l_payment_date IS NOT NULL THEN
1475: IF l_payment_date < fnd_date.canonical_to_date('2012/04/06 00:00:00') THEN
1476: populate_run_msg(p_assactid, 'The Payment Date ' ||l_payment_date|| ' for assignment ' || l_assignment_number||' is invalid.');
1477: fnd_file.put_line (fnd_file.LOG,'The Payment Date ' ||l_payment_date|| ' for assignment ' || l_assignment_number||' is invalid.');
1478: edi_validation_fail := 'Y';
1479: END IF;

Line 1597: l_end_date = fnd_date.canonical_to_date('4712/12/31') THEN

1593: edi_validation_fail := 'Y';
1594: END IF;
1595:
1596: IF l_payment_after_leaving = 'Y' AND
1597: l_end_date = fnd_date.canonical_to_date('4712/12/31') THEN
1598: populate_run_msg(p_assactid, 'The Date of Leaving is missing for assignment ' || l_assignment_number|| ',although Payment after leaving indicator is present.');
1599: fnd_file.put_line (fnd_file.LOG,'The Date of Leaving is missing for assignment ' || l_assignment_number|| ',although Payment after leaving indicator is present.');
1600: edi_validation_fail := 'Y';
1601: END IF;

Line 2397: l_tax_date := fnd_date.canonical_to_date(to_char(l_tax_date,'RRRRMMDD'));

2393: else
2394: l_tax_date := to_date(l_tax_year||'0405','RRRRMMDD'); /*tax year end date*/
2395: end if;
2396:
2397: l_tax_date := fnd_date.canonical_to_date(to_char(l_tax_date,'RRRRMMDD'));
2398:
2399: l_tax_year_start := add_months(l_tax_date,-12)+1 ;
2400:
2401: l_date_valid := p_validate_date;