APPS.HR_SG_AEI_LEG_HOOK dependencies on FND_DATE

Line 117: elsif fnd_date.canonical_to_date(p_aei_information4) <= fnd_date.canonical_to_date(p_aei_information3) then

113: -- check if Period To Date of Additional Wages is greater then
114: -- Period From Date of Additional Wages
115: -- Modified the condition for Bug# 3249303
116:
117: elsif fnd_date.canonical_to_date(p_aei_information4) <= fnd_date.canonical_to_date(p_aei_information3) then
118: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID2');
119: fnd_message.set_token('DATE1', 'Period To Date of Additional Wages');
120: fnd_message.set_token('DATE2', 'Period From Date of Additional Wages');
121: fnd_message.raise_error;

Line 128: elsif fnd_date.canonical_to_date(p_aei_information5) < fnd_date.canonical_to_date(p_aei_information4) then

124:
125: -- Check Pay date for additional wages must be greater or equal to
126: -- Payment for additional wages to date
127:
128: elsif fnd_date.canonical_to_date(p_aei_information5) < fnd_date.canonical_to_date(p_aei_information4) then
129: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
130: fnd_message.set_token('DATE1', 'Pay Date of Additional Wages');
131: fnd_message.set_token('DATE2', 'Period To Date of Additional Wages');
132: fnd_message.raise_error;

Line 187: elsif fnd_date.canonical_to_date(p_aei_information8) < fnd_date.canonical_to_date(p_aei_information5) then

183:
184: -- Check date of refund on ER CPF Contribution on amount of refund must
185: -- be greater or equal to Pay date for additional wages
186:
187: elsif fnd_date.canonical_to_date(p_aei_information8) < fnd_date.canonical_to_date(p_aei_information5) then
188: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
189: fnd_message.set_token('DATE1', 'Date of Refund of Employer Amount');
190: fnd_message.set_token('DATE2', 'Pay Date of Additional Wages');
191: fnd_message.raise_error;

Line 247: elsif fnd_date.canonical_to_date(p_aei_information11) < fnd_date.canonical_to_date(p_aei_information5) then

243:
244: -- Check date of refund on EE CPF Contribution on amount of refund must
245: -- be greater or equal to Pay date for additional wages
246:
247: elsif fnd_date.canonical_to_date(p_aei_information11) < fnd_date.canonical_to_date(p_aei_information5) then
248: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
249: fnd_message.set_token('DATE1', 'Date of Refund of Employee Amount');
250: fnd_message.set_token('DATE2', 'Pay Date of Additional Wages');
251: fnd_message.raise_error;

Line 258: elsif nvl(to_char(fnd_date.canonical_to_date(p_aei_information3), 'YYYY'),

254:
255: -- Check all dates are in basis year
256: -- Bug 5960714, this validation check should not include Date of refund
257: -- p_aei_information8 &p_aei_information11
258: elsif nvl(to_char(fnd_date.canonical_to_date(p_aei_information3), 'YYYY'),
259: p_aei_information1) <> p_aei_information1 or
260: nvl(to_char(fnd_date.canonical_to_date(p_aei_information4), 'YYYY'),
261: p_aei_information1) <> p_aei_information1 or
262: nvl(to_char(fnd_date.canonical_to_date(p_aei_information5), 'YYYY'),

Line 260: nvl(to_char(fnd_date.canonical_to_date(p_aei_information4), 'YYYY'),

256: -- Bug 5960714, this validation check should not include Date of refund
257: -- p_aei_information8 &p_aei_information11
258: elsif nvl(to_char(fnd_date.canonical_to_date(p_aei_information3), 'YYYY'),
259: p_aei_information1) <> p_aei_information1 or
260: nvl(to_char(fnd_date.canonical_to_date(p_aei_information4), 'YYYY'),
261: p_aei_information1) <> p_aei_information1 or
262: nvl(to_char(fnd_date.canonical_to_date(p_aei_information5), 'YYYY'),
263: p_aei_information1) <> p_aei_information1 then
264:

Line 262: nvl(to_char(fnd_date.canonical_to_date(p_aei_information5), 'YYYY'),

258: elsif nvl(to_char(fnd_date.canonical_to_date(p_aei_information3), 'YYYY'),
259: p_aei_information1) <> p_aei_information1 or
260: nvl(to_char(fnd_date.canonical_to_date(p_aei_information4), 'YYYY'),
261: p_aei_information1) <> p_aei_information1 or
262: nvl(to_char(fnd_date.canonical_to_date(p_aei_information5), 'YYYY'),
263: p_aei_information1) <> p_aei_information1 then
264:
265: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_SAME_YEAR');
266: fnd_message.raise_error;