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.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;

Line 323: AND ((fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00'))

319: FROM per_assignment_extra_info
320: WHERE assignment_id = p_assignment_id
321: AND information_type = p_information_type
322: AND aei_information1 = p_aei_information1
323: AND ((fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00'))
324: OR fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')))
325: OR (fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))
326: OR fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))))
327: HAVING count(*) > 1;

Line 324: OR fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')))

320: WHERE assignment_id = p_assignment_id
321: AND information_type = p_information_type
322: AND aei_information1 = p_aei_information1
323: AND ((fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00'))
324: OR fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')))
325: OR (fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))
326: OR fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))))
327: HAVING count(*) > 1;
328:

Line 325: OR (fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))

321: AND information_type = p_information_type
322: AND aei_information1 = p_aei_information1
323: AND ((fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00'))
324: OR fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')))
325: OR (fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))
326: OR fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))))
327: HAVING count(*) > 1;
328:
329: CURSOR multi_csn_dup_records_p

Line 326: OR fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))))

322: AND aei_information1 = p_aei_information1
323: AND ((fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00'))
324: OR fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')))
325: OR (fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))
326: OR fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))))
327: HAVING count(*) > 1;
328:
329: CURSOR multi_csn_dup_records_p
330: (p_assignment_id number,

Line 340: AND ((fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00'))

336: FROM per_assignment_extra_info
337: WHERE assignment_id = p_assignment_id
338: AND information_type = p_information_type
339: AND substr(aei_information1,11,3) = substr(p_aei_information1,11,3)
340: AND ((fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00'))
341: OR fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')))
342: OR (fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))
343: OR fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))))
344: HAVING count(*) > 1;

Line 341: OR fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')))

337: WHERE assignment_id = p_assignment_id
338: AND information_type = p_information_type
339: AND substr(aei_information1,11,3) = substr(p_aei_information1,11,3)
340: AND ((fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00'))
341: OR fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')))
342: OR (fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))
343: OR fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))))
344: HAVING count(*) > 1;
345:

Line 342: OR (fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))

338: AND information_type = p_information_type
339: AND substr(aei_information1,11,3) = substr(p_aei_information1,11,3)
340: AND ((fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00'))
341: OR fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')))
342: OR (fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))
343: OR fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))))
344: HAVING count(*) > 1;
345:
346: --

Line 343: OR fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))))

339: AND substr(aei_information1,11,3) = substr(p_aei_information1,11,3)
340: AND ((fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00'))
341: OR fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')))
342: OR (fnd_date.canonical_to_date(NVL(aei_information2,'1900/01/01 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))
343: OR fnd_date.canonical_to_date(NVL(aei_information3,'4712/12/31 00:00:00')) between fnd_date.canonical_to_date(NVL(p_aei_information2,'1900/01/01 00:00:00')) and fnd_date.canonical_to_date(NVL(p_aei_information3,'4712/12/31 00:00:00'))))
344: HAVING count(*) > 1;
345:
346: --
347: Begin

Line 386: if fnd_date.canonical_to_date(p_aei_information3) < fnd_date.canonical_to_date(p_aei_information2) then

382: close multi_csn_dup_records_p;
383: end if;
384: close multi_csn_dup_records;
385:
386: if fnd_date.canonical_to_date(p_aei_information3) < fnd_date.canonical_to_date(p_aei_information2) then
387: fnd_message.set_name('PAY', 'HR_SG_IR8S_C_DATES_INVALID');
388: fnd_message.set_token('DATE1', 'End Date');
389: fnd_message.set_token('DATE2', 'Start Date');
390: fnd_message.raise_error;