APPS.PAY_GB_RTI_FPS_VALIDATE dependencies on FND_DATE

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

926: END IF;
927:
928:
929: IF l_payment_date IS NOT NULL THEN
930: IF l_payment_date < fnd_date.canonical_to_date('2012/04/06 00:00:00') THEN
931: populate_run_msg(p_assactid, 'The Payment Date ' ||l_payment_date|| ' for assignment ' || l_assignment_number||' is invalid.');
932: fnd_file.put_line (fnd_file.LOG,'The Payment Date ' ||l_payment_date|| ' for assignment ' || l_assignment_number||' is invalid.');
933: edi_validation_fail := 'Y';
934: END IF;

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

1048: edi_validation_fail := 'Y';
1049: END IF;
1050:
1051: IF l_payment_after_leaving = 'Y' AND
1052: l_end_date = fnd_date.canonical_to_date('4712/12/31') THEN
1053: populate_run_msg(p_assactid, 'The Date of Leaving is missing for assignment ' || l_assignment_number|| ',although Payment after leaving indicator is present.');
1054: 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.');
1055: edi_validation_fail := 'Y';
1056: END IF;

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

1458: END IF;
1459:
1460:
1461: IF l_payment_date IS NOT NULL THEN
1462: IF l_payment_date < fnd_date.canonical_to_date('2012/04/06 00:00:00') THEN
1463: populate_run_msg(p_assactid, 'The Payment Date ' ||l_payment_date|| ' for assignment ' || l_assignment_number||' is invalid.');
1464: fnd_file.put_line (fnd_file.LOG,'The Payment Date ' ||l_payment_date|| ' for assignment ' || l_assignment_number||' is invalid.');
1465: edi_validation_fail := 'Y';
1466: END IF;

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

1580: edi_validation_fail := 'Y';
1581: END IF;
1582:
1583: IF l_payment_after_leaving = 'Y' AND
1584: l_end_date = fnd_date.canonical_to_date('4712/12/31') THEN
1585: populate_run_msg(p_assactid, 'The Date of Leaving is missing for assignment ' || l_assignment_number|| ',although Payment after leaving indicator is present.');
1586: 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.');
1587: edi_validation_fail := 'Y';
1588: END IF;

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

2379: else
2380: l_tax_date := to_date(l_tax_year||'0405','RRRRMMDD'); /*tax year end date*/
2381: end if;
2382:
2383: l_tax_date := fnd_date.canonical_to_date(to_char(l_tax_date,'RRRRMMDD'));
2384:
2385: l_tax_year_start := add_months(l_tax_date,-12)+1 ;
2386:
2387: l_date_valid := p_validate_date;