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 HR_UTILITY

Line 53: hr_utility.set_location(l_proc,10);

49: l_payment_cond_row csr_payment_condition_ins%rowtype;
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:

Line 59: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');

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');
60: hr_utility.raise_error;
61: end if; --date check
62: --Message: You entered a start date later than the end date.
63: -- Please enter a start date earlier than or the same as the end date.

Line 60: hr_utility.raise_error;

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');
60: hr_utility.raise_error;
61: end if; --date check
62: --Message: You entered a start date later than the end date.
63: -- Please enter a start date earlier than or the same as the end date.
64:

Line 71: hr_utility.set_message(800,'HR_375886_PAYMENT_COND_DATES');

67: fetch csr_assgt_start_date into l_assignment_start_date,l_assignment_end_date;
68: close csr_assgt_start_date;
69:
70: if (l_date_from < l_assignment_start_date) or nvl(l_date_to,l_end_of_time)>l_assignment_end_date then
71: hr_utility.set_message(800,'HR_375886_PAYMENT_COND_DATES');
72: hr_utility.raise_error;
73: end if;
74:
75: --ensure that for this information_type(PL_PAYMENT_CONDITIONS),assignemnt_id and type of salary(p_aei_information3)

Line 72: hr_utility.raise_error;

68: close csr_assgt_start_date;
69:
70: if (l_date_from < l_assignment_start_date) or nvl(l_date_to,l_end_of_time)>l_assignment_end_date then
71: hr_utility.set_message(800,'HR_375886_PAYMENT_COND_DATES');
72: hr_utility.raise_error;
73: end if;
74:
75: --ensure that for this information_type(PL_PAYMENT_CONDITIONS),assignemnt_id and type of salary(p_aei_information3)
76: --there isnt another record having same type of salary with overlapping dates

Line 84: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');

80: if csr_payment_condition_ins%found then
81: close csr_payment_condition_ins;
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;

Line 85: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));

81: close csr_payment_condition_ins;
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

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 88: hr_utility.raise_error;

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---
92: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');

Line 92: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');

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

Line 93: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));

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

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 95: hr_utility.raise_error;

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;
99:

Line 100: hr_utility.set_location('Leaving'||l_proc,20);

96: end if; --aei information2 is not null
97: end if; --csr_payment_condition_ins found
98: close csr_payment_condition_ins;
99:
100: hr_utility.set_location('Leaving'||l_proc,20);
101: END;
102:
103: procedure UPDATE_PL_PAYMENT_CONDITIONS(
104:

Line 152: hr_utility.set_location('Entering '||l_proc,10);

148:
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:

Line 158: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');

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');
159: hr_utility.raise_error;
160: end if; --date check
161: --Message: You entered a start date later than the end date.
162: -- Please enter a start date earlier than or the same as the end date.

Line 159: hr_utility.raise_error;

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');
159: hr_utility.raise_error;
160: end if; --date check
161: --Message: You entered a start date later than the end date.
162: -- Please enter a start date earlier than or the same as the end date.
163:

Line 174: hr_utility.set_message(800,'HR_375886_PAYMENT_COND_DATES');

170: fetch csr_assgt_start_date into l_assignment_start_date,l_assignment_end_date;
171: close csr_assgt_start_date;
172:
173: if (l_date_from < l_assignment_start_date ) or nvl(l_date_to,l_end_of_time)>l_assignment_end_date then
174: hr_utility.set_message(800,'HR_375886_PAYMENT_COND_DATES');
175: hr_utility.raise_error;
176: end if;
177:
178:

Line 175: hr_utility.raise_error;

171: close csr_assgt_start_date;
172:
173: if (l_date_from < l_assignment_start_date ) or nvl(l_date_to,l_end_of_time)>l_assignment_end_date then
174: hr_utility.set_message(800,'HR_375886_PAYMENT_COND_DATES');
175: hr_utility.raise_error;
176: end if;
177:
178:
179: open csr_payment_condition_upd(l_assignment_id);

Line 185: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');

181: if csr_payment_condition_upd%found then
182: close csr_payment_condition_upd;
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;

Line 186: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));

182: close csr_payment_condition_upd;
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

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 189: hr_utility.raise_error;

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---
193: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');

Line 193: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');

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

Line 194: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_TYPE_OF_SALARY',p_aei_information3));

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

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 196: hr_utility.raise_error;

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;
200:

Line 201: hr_utility.set_location('Leaving'||l_proc,20);

197: end if; --aei information2 is not null
198: end if;--csr_payment_condition_upd found
199: close csr_payment_condition_upd;
200:
201: hr_utility.set_location('Leaving'||l_proc,20);
202:
203: Exception
204: When others then
205: hr_utility.raise_error;

Line 205: hr_utility.raise_error;

201: hr_utility.set_location('Leaving'||l_proc,20);
202:
203: Exception
204: When others then
205: hr_utility.raise_error;
206:
207: END UPDATE_PL_PAYMENT_CONDITIONS; --end procedure
208:
209:

Line 262: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN

258: */
259:
260: l_proc:='CREATE_PL_ASSGT_EXTRA_INFO';
261: /* Added for GSI Bug 5472781 */
262: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
263: hr_utility.set_location('Leaving : '||l_proc,10);
264: return;
265: END IF;
266: hr_utility.set_location('Entering '||g_package||l_proc,10);

Line 263: hr_utility.set_location('Leaving : '||l_proc,10);

259:
260: l_proc:='CREATE_PL_ASSGT_EXTRA_INFO';
261: /* Added for GSI Bug 5472781 */
262: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
263: hr_utility.set_location('Leaving : '||l_proc,10);
264: return;
265: END IF;
266: hr_utility.set_location('Entering '||g_package||l_proc,10);
267:

Line 266: hr_utility.set_location('Entering '||g_package||l_proc,10);

262: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
263: hr_utility.set_location('Leaving : '||l_proc,10);
264: return;
265: END IF;
266: hr_utility.set_location('Entering '||g_package||l_proc,10);
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.

Line 272: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');

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:
276: hr_utility.set_location(g_package||l_proc,20);

Line 273: hr_utility.raise_error;

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:
276: hr_utility.set_location(g_package||l_proc,20);
277: --Make sure that start date is after Assignemnt start date

Line 276: hr_utility.set_location(g_package||l_proc,20);

272: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
273: hr_utility.raise_error;
274: end if; --date check
275:
276: hr_utility.set_location(g_package||l_proc,20);
277: --Make sure that start date is after Assignemnt start date
278: open csr_assgt_start_date(P_ASSIGNMENT_ID);
279: fetch csr_assgt_start_date into l_assignment_start_date,l_assignment_end_date;
280: close csr_assgt_start_date;

Line 282: hr_utility.set_location(g_package||l_proc,30);

278: open csr_assgt_start_date(P_ASSIGNMENT_ID);
279: fetch csr_assgt_start_date into l_assignment_start_date,l_assignment_end_date;
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');

Line 286: hr_utility.set_message(800,'HR_375865_ASSGT_START_END_DATE');

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:
290:

Line 287: hr_utility.raise_error;

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:
290:
291: hr_utility.set_location(g_package||l_proc,40);

Line 291: hr_utility.set_location(g_package||l_proc,40);

287: hr_utility.raise_error;
288: end if;
289:
290:
291: hr_utility.set_location(g_package||l_proc,40);
292:
293: --ensure that for this information_type,assignemnt_id and Kind of Work(p_aei_information3),
294: --there isnt another record having same Kind of Work
295: --with overlapping dates

Line 303: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');

299: if csr_work_condition_date_ins%found then
300: close csr_work_condition_date_ins;
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;

Line 304: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));

300: close csr_work_condition_date_ins;
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

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 307: hr_utility.raise_error;

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---
311: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');

Line 311: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');

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

Line 312: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));

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

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 314: hr_utility.raise_error;

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;
318:

Line 336: hr_utility.set_location('Leaving'||g_package||l_proc,50);

332: P_AEI_INFORMATION7 => P_AEI_INFORMATION7);
333:
334: end if;
335:
336: hr_utility.set_location('Leaving'||g_package||l_proc,50);
337:
338:
339: Exception
340: When others then

Line 341: hr_utility.raise_error;

337:
338:
339: Exception
340: When others then
341: hr_utility.raise_error;
342: end; --end procedure
343:
344:
345: procedure UPDATE_PL_ASSGT_EXTRA_INFO(

Line 404: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN

400: */
401:
402: l_proc:= 'UPDATE_PL_ASSGT_EXTRA_INFO';
403: /* Added for GSI Bug 5472781 */
404: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
405: hr_utility.set_location('Leaving : '||l_proc,10);
406: return;
407: END IF;
408: hr_utility.set_location('Entering '||g_package||l_proc,10);

Line 405: hr_utility.set_location('Leaving : '||l_proc,10);

401:
402: l_proc:= 'UPDATE_PL_ASSGT_EXTRA_INFO';
403: /* Added for GSI Bug 5472781 */
404: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
405: hr_utility.set_location('Leaving : '||l_proc,10);
406: return;
407: END IF;
408: hr_utility.set_location('Entering '||g_package||l_proc,10);
409:

Line 408: hr_utility.set_location('Entering '||g_package||l_proc,10);

404: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
405: hr_utility.set_location('Leaving : '||l_proc,10);
406: return;
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');

Line 412: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');

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:
416: open csr_assignment_id;

Line 413: hr_utility.raise_error;

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:
416: open csr_assignment_id;
417: fetch csr_assignment_id into l_assignment_id;

Line 420: hr_utility.set_location(g_package||l_proc,20);

416: open csr_assignment_id;
417: fetch csr_assignment_id into l_assignment_id;
418: close csr_assignment_id;
419:
420: hr_utility.set_location(g_package||l_proc,20);
421:
422: --Make sure that start date is after Assignemnt start date
423: open csr_assgt_start_date(l_ASSIGNMENT_ID);
424: fetch csr_assgt_start_date into l_assignment_start_date,l_assignment_end_date;

Line 429: hr_utility.set_message(800,'HR_375865_ASSGT_START_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:
433: hr_utility.set_location(g_package||l_proc,30);

Line 430: hr_utility.raise_error;

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:
433: hr_utility.set_location(g_package||l_proc,30);
434:

Line 433: hr_utility.set_location(g_package||l_proc,30);

429: hr_utility.set_message(800,'HR_375865_ASSGT_START_END_DATE');
430: hr_utility.raise_error;
431: end if;
432:
433: hr_utility.set_location(g_package||l_proc,30);
434:
435: open csr_work_condition_date_upd(l_assignment_id);
436: fetch csr_work_condition_date_upd into l_work_cond_row;
437: if csr_work_condition_date_upd%found then

Line 441: hr_utility.set_message(800,'HR_375854_OTHER_EIT_OVERLAP');

437: if csr_work_condition_date_upd%found then
438: close csr_work_condition_date_upd;
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;

Line 442: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));

438: close csr_work_condition_date_upd;
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

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 445: hr_utility.raise_error;

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---
449: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');

Line 449: hr_utility.set_message(800,'HR_375870_OTHER_EIT_EXISTS');

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

Line 450: hr_utility.set_message_token('WORKCOND',hr_general.decode_lookup('PL_OTHER_WORK_CONDS',p_aei_information3));

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

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;

Line 452: hr_utility.raise_error;

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;
456:

Line 469: hr_utility.set_location('Leaving'||g_package||l_proc,40);

465: P_AEI_INFORMATION6 => P_AEI_INFORMATION6,
466: P_AEI_INFORMATION7 => P_AEI_INFORMATION7);
467: end if;--p_aei_information_category='PL_PAYMENT_CONDITIONS'
468:
469: hr_utility.set_location('Leaving'||g_package||l_proc,40);
470:
471:
472: Exception
473: When others then

Line 474: hr_utility.raise_error;

470:
471:
472: Exception
473: When others then
474: hr_utility.raise_error;
475:
476: END UPDATE_PL_ASSGT_EXTRA_INFO; --end procedure update
477:
478: END PER_PL_AEI_INFO ; --end package