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.PER_PL_AEI_INFO dependencies on FND_DATE

Line 41: l_date_from between fnd_date.canonical_to_date(aei_information1)

37: and ASSIGNMENT_ID=p_assignment_id
38: and aei_information_category='PL_PAYMENT_CONDITIONS'
39: and AEI_INFORMATION3=p_AEI_INFORMATION3
40: and (
41: l_date_from between fnd_date.canonical_to_date(aei_information1)
42: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
43: or nvl(l_date_to,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)
44: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
45: or fnd_date.canonical_to_date(aei_information1)

Line 42: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)

38: and aei_information_category='PL_PAYMENT_CONDITIONS'
39: and AEI_INFORMATION3=p_AEI_INFORMATION3
40: and (
41: l_date_from between fnd_date.canonical_to_date(aei_information1)
42: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
43: or nvl(l_date_to,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)
44: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
45: or fnd_date.canonical_to_date(aei_information1)
46: between l_date_from

Line 43: or nvl(l_date_to,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)

39: and AEI_INFORMATION3=p_AEI_INFORMATION3
40: and (
41: l_date_from between fnd_date.canonical_to_date(aei_information1)
42: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
43: or nvl(l_date_to,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)
44: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
45: or fnd_date.canonical_to_date(aei_information1)
46: between l_date_from
47: and nvl(l_date_to,l_end_of_time)

Line 44: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)

40: and (
41: l_date_from between fnd_date.canonical_to_date(aei_information1)
42: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
43: or nvl(l_date_to,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)
44: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
45: or fnd_date.canonical_to_date(aei_information1)
46: between l_date_from
47: and nvl(l_date_to,l_end_of_time)
48: );

Line 45: or fnd_date.canonical_to_date(aei_information1)

41: l_date_from between fnd_date.canonical_to_date(aei_information1)
42: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
43: or nvl(l_date_to,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)
44: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
45: or fnd_date.canonical_to_date(aei_information1)
46: between l_date_from
47: and nvl(l_date_to,l_end_of_time)
48: );
49: l_payment_cond_row csr_payment_condition_ins%rowtype;

Line 54: l_date_from :=fnd_date.canonical_to_date(p_AEI_INFORMATION1);

50:
51: BEGIN
52: l_proc:=g_package||'CREATE_PL_PAYMENT_CONDITIONS';
53: hr_utility.set_location(l_proc,10);
54: l_date_from :=fnd_date.canonical_to_date(p_AEI_INFORMATION1);
55: l_date_to :=fnd_date.canonical_to_date(p_AEI_INFORMATION2);
56: l_end_of_time :=hr_general.end_of_time;
57:
58: if (l_date_from >l_date_to ) then

Line 55: l_date_to :=fnd_date.canonical_to_date(p_AEI_INFORMATION2);

51: BEGIN
52: l_proc:=g_package||'CREATE_PL_PAYMENT_CONDITIONS';
53: hr_utility.set_location(l_proc,10);
54: l_date_from :=fnd_date.canonical_to_date(p_AEI_INFORMATION1);
55: l_date_to :=fnd_date.canonical_to_date(p_AEI_INFORMATION2);
56: l_end_of_time :=hr_general.end_of_time;
57:
58: if (l_date_from >l_date_to ) then
59: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');

Line 86: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));

82: if l_payment_cond_row.aei_information2 is not null then
83: --there exists an end date for the record...display both start and end dates
84: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
85: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));
86: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));
87: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_payment_cond_row.aei_information2),l_end_of_time)));
88: hr_utility.raise_error;
89: else
90: --there doesnt exist a end date for this record...hence display only the start date

Line 87: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_payment_cond_row.aei_information2),l_end_of_time)));

83: --there exists an end date for the record...display both start and end dates
84: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
85: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));
86: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));
87: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_payment_cond_row.aei_information2),l_end_of_time)));
88: hr_utility.raise_error;
89: else
90: --there doesnt exist a end date for this record...hence display only the start date
91: --new message being used as we cannot display 31-dec-4712 to user---

Line 94: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));

90: --there doesnt exist a end date for this record...hence display only the start date
91: --new message being used as we cannot display 31-dec-4712 to user---
92: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');
93: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));
94: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));
95: hr_utility.raise_error;
96: end if; --aei information2 is not null
97: end if; --csr_payment_condition_ins found
98: close csr_payment_condition_ins;

Line 139: l_date_from between fnd_date.canonical_to_date(aei_information1)

135: and aei_information_category='PL_PAYMENT_CONDITIONS'
136: and AEI_INFORMATION3=p_AEI_INFORMATION3
137: and ASSIGNMENT_EXTRA_INFO_ID<>P_ASSIGNMENT_EXTRA_INFO_ID
138: and (
139: l_date_from between fnd_date.canonical_to_date(aei_information1)
140: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
141: or nvl(l_date_to ,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)
142: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
143: or fnd_date.canonical_to_date(aei_information1)

Line 140: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)

136: and AEI_INFORMATION3=p_AEI_INFORMATION3
137: and ASSIGNMENT_EXTRA_INFO_ID<>P_ASSIGNMENT_EXTRA_INFO_ID
138: and (
139: l_date_from between fnd_date.canonical_to_date(aei_information1)
140: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
141: or nvl(l_date_to ,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)
142: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
143: or fnd_date.canonical_to_date(aei_information1)
144: between l_date_from

Line 141: or nvl(l_date_to ,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)

137: and ASSIGNMENT_EXTRA_INFO_ID<>P_ASSIGNMENT_EXTRA_INFO_ID
138: and (
139: l_date_from between fnd_date.canonical_to_date(aei_information1)
140: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
141: or nvl(l_date_to ,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)
142: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
143: or fnd_date.canonical_to_date(aei_information1)
144: between l_date_from
145: and nvl(l_date_to ,l_end_of_time)

Line 142: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)

138: and (
139: l_date_from between fnd_date.canonical_to_date(aei_information1)
140: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
141: or nvl(l_date_to ,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)
142: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
143: or fnd_date.canonical_to_date(aei_information1)
144: between l_date_from
145: and nvl(l_date_to ,l_end_of_time)
146: );

Line 143: or fnd_date.canonical_to_date(aei_information1)

139: l_date_from between fnd_date.canonical_to_date(aei_information1)
140: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
141: or nvl(l_date_to ,l_end_of_time) between fnd_date.canonical_to_date(aei_information1)
142: and nvl(fnd_date.canonical_to_date(aei_information2),l_end_of_time)
143: or fnd_date.canonical_to_date(aei_information1)
144: between l_date_from
145: and nvl(l_date_to ,l_end_of_time)
146: );
147: l_payment_cond_row csr_payment_condition_upd%rowtype;

Line 153: l_date_from :=fnd_date.canonical_to_date(p_AEI_INFORMATION1);

149: Begin
150:
151: l_proc:= g_package||'UPDATE_PL_PAYMENT_CONITIONS';
152: hr_utility.set_location('Entering '||l_proc,10);
153: l_date_from :=fnd_date.canonical_to_date(p_AEI_INFORMATION1);
154: l_date_to :=fnd_date.canonical_to_date(p_AEI_INFORMATION2);
155: l_end_of_time :=hr_general.end_of_time;
156:
157: if (l_date_from >l_date_to ) then

Line 154: l_date_to :=fnd_date.canonical_to_date(p_AEI_INFORMATION2);

150:
151: l_proc:= g_package||'UPDATE_PL_PAYMENT_CONITIONS';
152: hr_utility.set_location('Entering '||l_proc,10);
153: l_date_from :=fnd_date.canonical_to_date(p_AEI_INFORMATION1);
154: l_date_to :=fnd_date.canonical_to_date(p_AEI_INFORMATION2);
155: l_end_of_time :=hr_general.end_of_time;
156:
157: if (l_date_from >l_date_to ) then
158: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');

Line 187: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));

183: if l_payment_cond_row.aei_information2 is not null then
184: --there exists an end date for the record...display both start and end dates
185: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
186: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));
187: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));
188: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_payment_cond_row.aei_information2),l_end_of_time)));
189: hr_utility.raise_error;
190: else
191: --there doesnt exist a end date for this record...hence display only the start date

Line 188: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_payment_cond_row.aei_information2),l_end_of_time)));

184: --there exists an end date for the record...display both start and end dates
185: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
186: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));
187: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));
188: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_payment_cond_row.aei_information2),l_end_of_time)));
189: hr_utility.raise_error;
190: else
191: --there doesnt exist a end date for this record...hence display only the start date
192: --new message being used as we cannot display 31-dec-4712 to user---

Line 195: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));

191: --there doesnt exist a end date for this record...hence display only the start date
192: --new message being used as we cannot display 31-dec-4712 to user---
193: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');
194: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));
195: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_payment_cond_row.aei_information1)));
196: hr_utility.raise_error;
197: end if; --aei information2 is not null
198: end if;--csr_payment_condition_upd found
199: close csr_payment_condition_upd;

Line 234: fnd_date.canonical_to_date(p_aei_information1)

230: and ASSIGNMENT_ID=p_assignment_id
231: and aei_information_category=p_aei_information_category
232: and AEI_INFORMATION3=p_AEI_INFORMATION3
233: and (
234: fnd_date.canonical_to_date(p_aei_information1)
235: between fnd_date.canonical_to_date(aei_information1)
236: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
237: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
238: between fnd_date.canonical_to_date(aei_information1)

Line 235: between fnd_date.canonical_to_date(aei_information1)

231: and aei_information_category=p_aei_information_category
232: and AEI_INFORMATION3=p_AEI_INFORMATION3
233: and (
234: fnd_date.canonical_to_date(p_aei_information1)
235: between fnd_date.canonical_to_date(aei_information1)
236: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
237: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
238: between fnd_date.canonical_to_date(aei_information1)
239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

Line 236: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

232: and AEI_INFORMATION3=p_AEI_INFORMATION3
233: and (
234: fnd_date.canonical_to_date(p_aei_information1)
235: between fnd_date.canonical_to_date(aei_information1)
236: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
237: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
238: between fnd_date.canonical_to_date(aei_information1)
239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
240: or fnd_date.canonical_to_date( aei_information1)

Line 237: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)

233: and (
234: fnd_date.canonical_to_date(p_aei_information1)
235: between fnd_date.canonical_to_date(aei_information1)
236: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
237: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
238: between fnd_date.canonical_to_date(aei_information1)
239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
240: or fnd_date.canonical_to_date( aei_information1)
241: between fnd_date.canonical_to_date(p_aei_information1)

Line 238: between fnd_date.canonical_to_date(aei_information1)

234: fnd_date.canonical_to_date(p_aei_information1)
235: between fnd_date.canonical_to_date(aei_information1)
236: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
237: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
238: between fnd_date.canonical_to_date(aei_information1)
239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
240: or fnd_date.canonical_to_date( aei_information1)
241: between fnd_date.canonical_to_date(p_aei_information1)
242: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)

Line 239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

235: between fnd_date.canonical_to_date(aei_information1)
236: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
237: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
238: between fnd_date.canonical_to_date(aei_information1)
239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
240: or fnd_date.canonical_to_date( aei_information1)
241: between fnd_date.canonical_to_date(p_aei_information1)
242: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
243: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

Line 240: or fnd_date.canonical_to_date( aei_information1)

236: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
237: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
238: between fnd_date.canonical_to_date(aei_information1)
239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
240: or fnd_date.canonical_to_date( aei_information1)
241: between fnd_date.canonical_to_date(p_aei_information1)
242: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
243: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
244: between fnd_date.canonical_to_date(p_aei_information1)

Line 241: between fnd_date.canonical_to_date(p_aei_information1)

237: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
238: between fnd_date.canonical_to_date(aei_information1)
239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
240: or fnd_date.canonical_to_date( aei_information1)
241: between fnd_date.canonical_to_date(p_aei_information1)
242: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
243: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
244: between fnd_date.canonical_to_date(p_aei_information1)
245: and fnd_date.canonical_to_date(p_aei_information2)

Line 242: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)

238: between fnd_date.canonical_to_date(aei_information1)
239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
240: or fnd_date.canonical_to_date( aei_information1)
241: between fnd_date.canonical_to_date(p_aei_information1)
242: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
243: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
244: between fnd_date.canonical_to_date(p_aei_information1)
245: and fnd_date.canonical_to_date(p_aei_information2)
246: );

Line 243: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

239: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
240: or fnd_date.canonical_to_date( aei_information1)
241: between fnd_date.canonical_to_date(p_aei_information1)
242: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
243: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
244: between fnd_date.canonical_to_date(p_aei_information1)
245: and fnd_date.canonical_to_date(p_aei_information2)
246: );
247: l_work_cond_row csr_work_condition_date_ins%rowtype;

Line 244: between fnd_date.canonical_to_date(p_aei_information1)

240: or fnd_date.canonical_to_date( aei_information1)
241: between fnd_date.canonical_to_date(p_aei_information1)
242: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
243: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
244: between fnd_date.canonical_to_date(p_aei_information1)
245: and fnd_date.canonical_to_date(p_aei_information2)
246: );
247: l_work_cond_row csr_work_condition_date_ins%rowtype;
248: l_assignment_start_date date;

Line 245: and fnd_date.canonical_to_date(p_aei_information2)

241: between fnd_date.canonical_to_date(p_aei_information1)
242: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
243: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
244: between fnd_date.canonical_to_date(p_aei_information1)
245: and fnd_date.canonical_to_date(p_aei_information2)
246: );
247: l_work_cond_row csr_work_condition_date_ins%rowtype;
248: l_assignment_start_date date;
249: l_assignment_end_date date;

Line 271: if (fnd_date.canonical_to_date(p_AEI_INFORMATION1)>fnd_date.canonical_to_date(p_AEI_INFORMATION2)) then

267:
268: if p_information_type='PL_OTHER_WORK_CONDITIONS' then
269: --ensure start date is less than end date
270: --HR_ORG_START_DATE_PL already contains an apt message.so using it.
271: if (fnd_date.canonical_to_date(p_AEI_INFORMATION1)>fnd_date.canonical_to_date(p_AEI_INFORMATION2)) then
272: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
273: hr_utility.raise_error;
274: end if; --date check
275:

Line 284: if (fnd_date.canonical_to_date(p_aei_information1)

280: close csr_assgt_start_date;
281:
282: hr_utility.set_location(g_package||l_proc,30);
283:
284: if (fnd_date.canonical_to_date(p_aei_information1) 285: nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)>l_assignment_end_date then
286: hr_utility.set_message(800,'HR_375865_ASSGT_START_END_DATE');
287: hr_utility.raise_error;
288: end if;

Line 285: nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)>l_assignment_end_date then

281:
282: hr_utility.set_location(g_package||l_proc,30);
283:
284: if (fnd_date.canonical_to_date(p_aei_information1) 285: nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)>l_assignment_end_date then
286: hr_utility.set_message(800,'HR_375865_ASSGT_START_END_DATE');
287: hr_utility.raise_error;
288: end if;
289:

Line 305: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));

301: if l_work_cond_row.aei_information2 is not null then
302: --there exists an end date for the record...display both start and end dates
303: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
304: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
305: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
306: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_work_cond_row.aei_information2),hr_general.end_of_time)));
307: hr_utility.raise_error;
308: else
309: --there doesnt exist a end date for this record...hence display only the start date

Line 306: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_work_cond_row.aei_information2),hr_general.end_of_time)));

302: --there exists an end date for the record...display both start and end dates
303: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
304: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
305: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
306: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_work_cond_row.aei_information2),hr_general.end_of_time)));
307: hr_utility.raise_error;
308: else
309: --there doesnt exist a end date for this record...hence display only the start date
310: --new message being used as we cannot display 31-dec-4712 to user---

Line 313: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));

309: --there doesnt exist a end date for this record...hence display only the start date
310: --new message being used as we cannot display 31-dec-4712 to user---
311: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');
312: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
313: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
314: hr_utility.raise_error;
315: end if; --aei information2 is not null
316: end if; --csr_work_condition_date_ins found
317: close csr_work_condition_date_ins;

Line 375: fnd_date.canonical_to_date(p_aei_information1)

371: and aei_information_category=p_aei_information_category
372: and AEI_INFORMATION3=p_AEI_INFORMATION3
373: and ASSIGNMENT_EXTRA_INFO_ID<>P_ASSIGNMENT_EXTRA_INFO_ID
374: and (
375: fnd_date.canonical_to_date(p_aei_information1)
376: between fnd_date.canonical_to_date(aei_information1)
377: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
378: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
379: between fnd_date.canonical_to_date(aei_information1)

Line 376: between fnd_date.canonical_to_date(aei_information1)

372: and AEI_INFORMATION3=p_AEI_INFORMATION3
373: and ASSIGNMENT_EXTRA_INFO_ID<>P_ASSIGNMENT_EXTRA_INFO_ID
374: and (
375: fnd_date.canonical_to_date(p_aei_information1)
376: between fnd_date.canonical_to_date(aei_information1)
377: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
378: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
379: between fnd_date.canonical_to_date(aei_information1)
380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

Line 377: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

373: and ASSIGNMENT_EXTRA_INFO_ID<>P_ASSIGNMENT_EXTRA_INFO_ID
374: and (
375: fnd_date.canonical_to_date(p_aei_information1)
376: between fnd_date.canonical_to_date(aei_information1)
377: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
378: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
379: between fnd_date.canonical_to_date(aei_information1)
380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
381: or fnd_date.canonical_to_date(aei_information1)

Line 378: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)

374: and (
375: fnd_date.canonical_to_date(p_aei_information1)
376: between fnd_date.canonical_to_date(aei_information1)
377: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
378: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
379: between fnd_date.canonical_to_date(aei_information1)
380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
381: or fnd_date.canonical_to_date(aei_information1)
382: between fnd_date.canonical_to_date(p_aei_information1)

Line 379: between fnd_date.canonical_to_date(aei_information1)

375: fnd_date.canonical_to_date(p_aei_information1)
376: between fnd_date.canonical_to_date(aei_information1)
377: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
378: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
379: between fnd_date.canonical_to_date(aei_information1)
380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
381: or fnd_date.canonical_to_date(aei_information1)
382: between fnd_date.canonical_to_date(p_aei_information1)
383: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)

Line 380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

376: between fnd_date.canonical_to_date(aei_information1)
377: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
378: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
379: between fnd_date.canonical_to_date(aei_information1)
380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
381: or fnd_date.canonical_to_date(aei_information1)
382: between fnd_date.canonical_to_date(p_aei_information1)
383: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
384: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

Line 381: or fnd_date.canonical_to_date(aei_information1)

377: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
378: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
379: between fnd_date.canonical_to_date(aei_information1)
380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
381: or fnd_date.canonical_to_date(aei_information1)
382: between fnd_date.canonical_to_date(p_aei_information1)
383: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
384: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
385: between fnd_date.canonical_to_date(p_aei_information1)

Line 382: between fnd_date.canonical_to_date(p_aei_information1)

378: or nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
379: between fnd_date.canonical_to_date(aei_information1)
380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
381: or fnd_date.canonical_to_date(aei_information1)
382: between fnd_date.canonical_to_date(p_aei_information1)
383: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
384: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
385: between fnd_date.canonical_to_date(p_aei_information1)
386: and fnd_date.canonical_to_date(p_aei_information2)

Line 383: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)

379: between fnd_date.canonical_to_date(aei_information1)
380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
381: or fnd_date.canonical_to_date(aei_information1)
382: between fnd_date.canonical_to_date(p_aei_information1)
383: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
384: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
385: between fnd_date.canonical_to_date(p_aei_information1)
386: and fnd_date.canonical_to_date(p_aei_information2)
387: );

Line 384: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)

380: and nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
381: or fnd_date.canonical_to_date(aei_information1)
382: between fnd_date.canonical_to_date(p_aei_information1)
383: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
384: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
385: between fnd_date.canonical_to_date(p_aei_information1)
386: and fnd_date.canonical_to_date(p_aei_information2)
387: );
388: l_assignment_id number;

Line 385: between fnd_date.canonical_to_date(p_aei_information1)

381: or fnd_date.canonical_to_date(aei_information1)
382: between fnd_date.canonical_to_date(p_aei_information1)
383: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
384: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
385: between fnd_date.canonical_to_date(p_aei_information1)
386: and fnd_date.canonical_to_date(p_aei_information2)
387: );
388: l_assignment_id number;
389: l_assignment_start_date date;

Line 386: and fnd_date.canonical_to_date(p_aei_information2)

382: between fnd_date.canonical_to_date(p_aei_information1)
383: and nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)
384: or nvl(fnd_date.canonical_to_date(aei_information2),hr_general.end_of_time)
385: between fnd_date.canonical_to_date(p_aei_information1)
386: and fnd_date.canonical_to_date(p_aei_information2)
387: );
388: l_assignment_id number;
389: l_assignment_start_date date;
390: l_assignment_end_date date;

Line 411: if (fnd_date.canonical_to_date(p_AEI_INFORMATION1)>fnd_date.canonical_to_date(p_AEI_INFORMATION2)) then

407: END IF;
408: hr_utility.set_location('Entering '||g_package||l_proc,10);
409:
410: if p_aei_information_category = 'PL_OTHER_WORK_CONDITIONS' then
411: if (fnd_date.canonical_to_date(p_AEI_INFORMATION1)>fnd_date.canonical_to_date(p_AEI_INFORMATION2)) then
412: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
413: hr_utility.raise_error;
414: end if;
415:

Line 427: if (fnd_date.canonical_to_date(p_aei_information1)

423: open csr_assgt_start_date(l_ASSIGNMENT_ID);
424: fetch csr_assgt_start_date into l_assignment_start_date,l_assignment_end_date;
425: close csr_assgt_start_date;
426:
427: if (fnd_date.canonical_to_date(p_aei_information1) 428: nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)>l_assignment_end_date then
429: hr_utility.set_message(800,'HR_375865_ASSGT_START_END_DATE');
430: hr_utility.raise_error;
431: end if;

Line 428: nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)>l_assignment_end_date then

424: fetch csr_assgt_start_date into l_assignment_start_date,l_assignment_end_date;
425: close csr_assgt_start_date;
426:
427: if (fnd_date.canonical_to_date(p_aei_information1) 428: nvl(fnd_date.canonical_to_date(p_aei_information2),hr_general.end_of_time)>l_assignment_end_date then
429: hr_utility.set_message(800,'HR_375865_ASSGT_START_END_DATE');
430: hr_utility.raise_error;
431: end if;
432:

Line 443: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));

439: if l_work_cond_row.aei_information2 is not null then
440: --there exists an end date for the record...display both start and end dates
441: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
442: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
443: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
444: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_work_cond_row.aei_information2),hr_general.end_of_time)));
445: hr_utility.raise_error;
446: else
447: --there doesnt exist a end date for this record...hence display only the start date

Line 444: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_work_cond_row.aei_information2),hr_general.end_of_time)));

440: --there exists an end date for the record...display both start and end dates
441: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');
442: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
443: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
444: hr_utility.set_message_token('ENDDATE',fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_work_cond_row.aei_information2),hr_general.end_of_time)));
445: hr_utility.raise_error;
446: else
447: --there doesnt exist a end date for this record...hence display only the start date
448: --new message being used as we cannot display 31-dec-4712 to user---

Line 451: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));

447: --there doesnt exist a end date for this record...hence display only the start date
448: --new message being used as we cannot display 31-dec-4712 to user---
449: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');
450: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));
451: hr_utility.set_message_token('STARTDATE',fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_work_cond_row.aei_information1)));
452: hr_utility.raise_error;
453: end if; --aei information2 is not null
454: end if;--csr_work_condition_date_upd found
455: close csr_work_condition_date_upd;