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_WRK_SCH_PKG dependencies on HR_UTILITY

Line 124: hr_utility.set_location('entering overlap check: ', 10);

120:
121:
122: begin
123:
124: hr_utility.set_location('entering overlap check: ', 10);
125:
126: OPEN c_max_inh_seq;
127: FETCH c_max_inh_seq INTO l_sch_inh_seq;
128: CLOSE c_max_inh_seq;

Line 130: hr_utility.set_location('MaxSeq: '||l_sch_inh_seq, 10);

126: OPEN c_max_inh_seq;
127: FETCH c_max_inh_seq INTO l_sch_inh_seq;
128: CLOSE c_max_inh_seq;
129:
130: hr_utility.set_location('MaxSeq: '||l_sch_inh_seq, 10);
131:
132: -- Get person assignment attributes
133: OPEN c_per_asg (p_person_assignment_id
134: ,p_period_start_date

Line 143: hr_utility.set_location('BGId:'||l_bus_grp_id||

139: ,l_pos_id
140: ,l_loc_id;
141: CLOSE c_per_asg;
142:
143: hr_utility.set_location('BGId:'||l_bus_grp_id||
144: ' HROrgId:'||l_hr_org_id||
145: ' JobId:'||l_job_id||
146: ' PosId:'||l_pos_id||
147: ' LocId:'||l_loc_id, 15);

Line 156: hr_utility.set_location('SchInhLvl: '||x_schedule_source, 20);

152: OPEN c_sch_inh_lvl (l_sch_inh_seq);
153: FETCH c_sch_inh_lvl INTO x_schedule_source;
154: CLOSE c_sch_inh_lvl;
155:
156: hr_utility.set_location('SchInhLvl: '||x_schedule_source, 20);
157:
158: CASE x_schedule_source
159: WHEN 'BUS_GRP' THEN
160: -- Get schedule from business group

Line 161: hr_utility.set_location('overlap check', 30);

157:
158: CASE x_schedule_source
159: WHEN 'BUS_GRP' THEN
160: -- Get schedule from business group
161: hr_utility.set_location('overlap check', 30);
162: cac_avlblty_pub.get_schedule(p_api_version => 1.0
163: ,p_init_msg_list => 'F'
164: ,p_object_type => 'BUSINESS_GROUP'
165: ,p_object_id => l_bus_grp_id

Line 176: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 45);

172: ,x_return_status => l_return_status
173: ,x_msg_count => l_msg_count
174: ,x_msg_data => l_msg_data
175: );
176: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 45);
177:
178: IF x_schedule.COUNT >= 1 then
179: hr_utility.set_location(l_proc||' Before opening cursor ', 1);
180: OPEN c_sch_dates ('BUSINESS_GROUP'

Line 179: hr_utility.set_location(l_proc||' Before opening cursor ', 1);

175: );
176: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 45);
177:
178: IF x_schedule.COUNT >= 1 then
179: hr_utility.set_location(l_proc||' Before opening cursor ', 1);
180: OPEN c_sch_dates ('BUSINESS_GROUP'
181: ,l_bus_grp_id
182: ,p_period_start_date
183: ,p_period_end_date

Line 187: hr_utility.set_location(l_proc||' After opening cursor ', 2);

183: ,p_period_end_date
184: ,p_schedule_category
185: );
186:
187: hr_utility.set_location(l_proc||' After opening cursor ', 2);
188: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
189: hr_utility.set_location(l_proc||' After fetching', 3);
190: if(c_sch_dates%found) then
191: hr_utility.set_location(l_proc||' Record found', 40);

Line 189: hr_utility.set_location(l_proc||' After fetching', 3);

185: );
186:
187: hr_utility.set_location(l_proc||' After opening cursor ', 2);
188: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
189: hr_utility.set_location(l_proc||' After fetching', 3);
190: if(c_sch_dates%found) then
191: hr_utility.set_location(l_proc||' Record found', 40);
192: close c_sch_dates;
193: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);

Line 191: hr_utility.set_location(l_proc||' Record found', 40);

187: hr_utility.set_location(l_proc||' After opening cursor ', 2);
188: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
189: hr_utility.set_location(l_proc||' After fetching', 3);
190: if(c_sch_dates%found) then
191: hr_utility.set_location(l_proc||' Record found', 40);
192: close c_sch_dates;
193: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);
194: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
195: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then

Line 193: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);

189: hr_utility.set_location(l_proc||' After fetching', 3);
190: if(c_sch_dates%found) then
191: hr_utility.set_location(l_proc||' Record found', 40);
192: close c_sch_dates;
193: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);
194: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
195: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then
196: hr_utility.set_location(l_proc||' Raising error', 20);
197: raise overlapped;

Line 196: hr_utility.set_location(l_proc||' Raising error', 20);

192: close c_sch_dates;
193: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);
194: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
195: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then
196: hr_utility.set_location(l_proc||' Raising error', 20);
197: raise overlapped;
198: hr_utility.set_location(l_proc||' Raising error', 21);
199:
200: end if;

Line 198: hr_utility.set_location(l_proc||' Raising error', 21);

194: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
195: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then
196: hr_utility.set_location(l_proc||' Raising error', 20);
197: raise overlapped;
198: hr_utility.set_location(l_proc||' Raising error', 21);
199:
200: end if;
201: hr_utility.set_location(l_proc||' Exiting with success', 5);
202: ELSE

Line 201: hr_utility.set_location(l_proc||' Exiting with success', 5);

197: raise overlapped;
198: hr_utility.set_location(l_proc||' Raising error', 21);
199:
200: end if;
201: hr_utility.set_location(l_proc||' Exiting with success', 5);
202: ELSE
203: hr_utility.set_location(l_proc||' No Record found ', 6);
204: close c_sch_dates;
205: l_sch_start_date:=null;

Line 203: hr_utility.set_location(l_proc||' No Record found ', 6);

199:
200: end if;
201: hr_utility.set_location(l_proc||' Exiting with success', 5);
202: ELSE
203: hr_utility.set_location(l_proc||' No Record found ', 6);
204: close c_sch_dates;
205: l_sch_start_date:=null;
206: l_sch_end_date:=null;
207:

Line 213: hr_utility.set_location(l_proc, 80);

209: end if;
210:
211: WHEN 'HR_ORG' THEN
212: -- Get schedule from hr organization
213: hr_utility.set_location(l_proc, 80);
214: cac_avlblty_pub.get_schedule(p_api_version => 1.0
215: ,p_init_msg_list => 'F'
216: ,p_object_type => 'HR_ORGANIZATION'
217: ,p_object_id => l_hr_org_id

Line 228: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 85);

224: ,x_return_status => l_return_status
225: ,x_msg_count => l_msg_count
226: ,x_msg_data => l_msg_data
227: );
228: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 85);
229: IF x_schedule.COUNT >= 1 then
230: hr_utility.set_location(l_proc||' Before opening cursor ', 21);
231: OPEN c_sch_dates ('HR_ORGANIZATION'
232: ,l_hr_org_id

Line 230: hr_utility.set_location(l_proc||' Before opening cursor ', 21);

226: ,x_msg_data => l_msg_data
227: );
228: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 85);
229: IF x_schedule.COUNT >= 1 then
230: hr_utility.set_location(l_proc||' Before opening cursor ', 21);
231: OPEN c_sch_dates ('HR_ORGANIZATION'
232: ,l_hr_org_id
233: ,p_period_start_date
234: ,p_period_end_date

Line 238: hr_utility.set_location(l_proc||' After opening cursor ', 22);

234: ,p_period_end_date
235: ,p_schedule_category
236: );
237:
238: hr_utility.set_location(l_proc||' After opening cursor ', 22);
239: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
240: hr_utility.set_location(l_proc||' After fetching', 3);
241: if(c_sch_dates%found) then
242: hr_utility.set_location(l_proc||' Record found', 23);

Line 240: hr_utility.set_location(l_proc||' After fetching', 3);

236: );
237:
238: hr_utility.set_location(l_proc||' After opening cursor ', 22);
239: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
240: hr_utility.set_location(l_proc||' After fetching', 3);
241: if(c_sch_dates%found) then
242: hr_utility.set_location(l_proc||' Record found', 23);
243: close c_sch_dates;
244: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);

Line 242: hr_utility.set_location(l_proc||' Record found', 23);

238: hr_utility.set_location(l_proc||' After opening cursor ', 22);
239: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
240: hr_utility.set_location(l_proc||' After fetching', 3);
241: if(c_sch_dates%found) then
242: hr_utility.set_location(l_proc||' Record found', 23);
243: close c_sch_dates;
244: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);
245: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
246: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then

Line 244: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);

240: hr_utility.set_location(l_proc||' After fetching', 3);
241: if(c_sch_dates%found) then
242: hr_utility.set_location(l_proc||' Record found', 23);
243: close c_sch_dates;
244: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);
245: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
246: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then
247: hr_utility.set_location(l_proc||' Raising error', 24);
248: raise overlapped;

Line 247: hr_utility.set_location(l_proc||' Raising error', 24);

243: close c_sch_dates;
244: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);
245: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
246: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then
247: hr_utility.set_location(l_proc||' Raising error', 24);
248: raise overlapped;
249: hr_utility.set_location(l_proc||' Raising error', 25);
250:
251: end if;

Line 249: hr_utility.set_location(l_proc||' Raising error', 25);

245: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
246: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then
247: hr_utility.set_location(l_proc||' Raising error', 24);
248: raise overlapped;
249: hr_utility.set_location(l_proc||' Raising error', 25);
250:
251: end if;
252: hr_utility.set_location(l_proc||' Exiting with success', 26);
253: ELSE

Line 252: hr_utility.set_location(l_proc||' Exiting with success', 26);

248: raise overlapped;
249: hr_utility.set_location(l_proc||' Raising error', 25);
250:
251: end if;
252: hr_utility.set_location(l_proc||' Exiting with success', 26);
253: ELSE
254: hr_utility.set_location(l_proc||' No Record found ', 27);
255: close c_sch_dates;
256: l_sch_start_date:=null;

Line 254: hr_utility.set_location(l_proc||' No Record found ', 27);

250:
251: end if;
252: hr_utility.set_location(l_proc||' Exiting with success', 26);
253: ELSE
254: hr_utility.set_location(l_proc||' No Record found ', 27);
255: close c_sch_dates;
256: l_sch_start_date:=null;
257: l_sch_end_date:=null;
258:

Line 264: hr_utility.set_location(l_proc, 90);

260: end if;
261:
262: WHEN 'JOB' THEN
263: -- Get schedule from job
264: hr_utility.set_location(l_proc, 90);
265: cac_avlblty_pub.get_schedule(p_api_version => 1.0
266: ,p_init_msg_list => 'F'
267: ,p_object_type => 'HR_JOB'
268: ,p_object_id => l_job_id

Line 279: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 95);

275: ,x_return_status => l_return_status
276: ,x_msg_count => l_msg_count
277: ,x_msg_data => l_msg_data
278: );
279: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 95);
280: IF x_schedule.COUNT >= 1 then
281: hr_utility.set_location(l_proc||' Before opening cursor ', 41);
282: OPEN c_sch_dates ('HR_JOB'
283: ,l_job_id

Line 281: hr_utility.set_location(l_proc||' Before opening cursor ', 41);

277: ,x_msg_data => l_msg_data
278: );
279: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 95);
280: IF x_schedule.COUNT >= 1 then
281: hr_utility.set_location(l_proc||' Before opening cursor ', 41);
282: OPEN c_sch_dates ('HR_JOB'
283: ,l_job_id
284: ,p_period_start_date
285: ,p_period_end_date

Line 289: hr_utility.set_location(l_proc||' After opening cursor ', 42);

285: ,p_period_end_date
286: ,p_schedule_category
287: );
288:
289: hr_utility.set_location(l_proc||' After opening cursor ', 42);
290: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
291: hr_utility.set_location(l_proc||' After fetching', 3);
292: if(c_sch_dates%found) then
293: hr_utility.set_location(l_proc||' Record found', 43);

Line 291: hr_utility.set_location(l_proc||' After fetching', 3);

287: );
288:
289: hr_utility.set_location(l_proc||' After opening cursor ', 42);
290: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
291: hr_utility.set_location(l_proc||' After fetching', 3);
292: if(c_sch_dates%found) then
293: hr_utility.set_location(l_proc||' Record found', 43);
294: close c_sch_dates;
295: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);

Line 293: hr_utility.set_location(l_proc||' Record found', 43);

289: hr_utility.set_location(l_proc||' After opening cursor ', 42);
290: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
291: hr_utility.set_location(l_proc||' After fetching', 3);
292: if(c_sch_dates%found) then
293: hr_utility.set_location(l_proc||' Record found', 43);
294: close c_sch_dates;
295: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);
296: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
297: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then

Line 295: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);

291: hr_utility.set_location(l_proc||' After fetching', 3);
292: if(c_sch_dates%found) then
293: hr_utility.set_location(l_proc||' Record found', 43);
294: close c_sch_dates;
295: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);
296: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
297: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then
298: hr_utility.set_location(l_proc||' Raising error', 44);
299: raise overlapped;

Line 298: hr_utility.set_location(l_proc||' Raising error', 44);

294: close c_sch_dates;
295: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);
296: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
297: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then
298: hr_utility.set_location(l_proc||' Raising error', 44);
299: raise overlapped;
300: hr_utility.set_location(l_proc||' Raising error', 45);
301:
302: end if;

Line 300: hr_utility.set_location(l_proc||' Raising error', 45);

296: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
297: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then
298: hr_utility.set_location(l_proc||' Raising error', 44);
299: raise overlapped;
300: hr_utility.set_location(l_proc||' Raising error', 45);
301:
302: end if;
303: hr_utility.set_location(l_proc||' Exiting with success', 46);
304: ELSE

Line 303: hr_utility.set_location(l_proc||' Exiting with success', 46);

299: raise overlapped;
300: hr_utility.set_location(l_proc||' Raising error', 45);
301:
302: end if;
303: hr_utility.set_location(l_proc||' Exiting with success', 46);
304: ELSE
305: hr_utility.set_location(l_proc||' No Record found ', 47);
306: close c_sch_dates;
307: l_sch_start_date:=null;

Line 305: hr_utility.set_location(l_proc||' No Record found ', 47);

301:
302: end if;
303: hr_utility.set_location(l_proc||' Exiting with success', 46);
304: ELSE
305: hr_utility.set_location(l_proc||' No Record found ', 47);
306: close c_sch_dates;
307: l_sch_start_date:=null;
308: l_sch_end_date:=null;
309:

Line 315: hr_utility.set_location(l_proc, 100);

311: end if;
312:
313: WHEN 'POS' THEN
314: -- Get schedule from position
315: hr_utility.set_location(l_proc, 100);
316: cac_avlblty_pub.get_schedule(p_api_version => 1.0
317: ,p_init_msg_list => 'F'
318: ,p_object_type => 'HR_POSITION'
319: ,p_object_id => l_pos_id

Line 330: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 105);

326: ,x_return_status => l_return_status
327: ,x_msg_count => l_msg_count
328: ,x_msg_data => l_msg_data
329: );
330: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 105);
331: IF x_schedule.COUNT >= 1 then
332: hr_utility.set_location(l_proc||' Before opening cursor ', 41);
333: OPEN c_sch_dates ('HR_POSITION'
334: ,l_pos_id

Line 332: hr_utility.set_location(l_proc||' Before opening cursor ', 41);

328: ,x_msg_data => l_msg_data
329: );
330: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 105);
331: IF x_schedule.COUNT >= 1 then
332: hr_utility.set_location(l_proc||' Before opening cursor ', 41);
333: OPEN c_sch_dates ('HR_POSITION'
334: ,l_pos_id
335: ,p_period_start_date
336: ,p_period_end_date

Line 340: hr_utility.set_location(l_proc||' After opening cursor ', 42);

336: ,p_period_end_date
337: ,p_schedule_category
338: );
339:
340: hr_utility.set_location(l_proc||' After opening cursor ', 42);
341: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
342: hr_utility.set_location(l_proc||' After fetching', 3);
343: if(c_sch_dates%found) then
344: hr_utility.set_location(l_proc||' Record found', 43);

Line 342: hr_utility.set_location(l_proc||' After fetching', 3);

338: );
339:
340: hr_utility.set_location(l_proc||' After opening cursor ', 42);
341: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
342: hr_utility.set_location(l_proc||' After fetching', 3);
343: if(c_sch_dates%found) then
344: hr_utility.set_location(l_proc||' Record found', 43);
345: close c_sch_dates;
346: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);

Line 344: hr_utility.set_location(l_proc||' Record found', 43);

340: hr_utility.set_location(l_proc||' After opening cursor ', 42);
341: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
342: hr_utility.set_location(l_proc||' After fetching', 3);
343: if(c_sch_dates%found) then
344: hr_utility.set_location(l_proc||' Record found', 43);
345: close c_sch_dates;
346: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);
347: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
348: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then

Line 346: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);

342: hr_utility.set_location(l_proc||' After fetching', 3);
343: if(c_sch_dates%found) then
344: hr_utility.set_location(l_proc||' Record found', 43);
345: close c_sch_dates;
346: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);
347: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
348: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then
349: hr_utility.set_location(l_proc||' Raising error', 44);
350: raise overlapped;

Line 349: hr_utility.set_location(l_proc||' Raising error', 44);

345: close c_sch_dates;
346: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);
347: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
348: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then
349: hr_utility.set_location(l_proc||' Raising error', 44);
350: raise overlapped;
351: hr_utility.set_location(l_proc||' Raising error', 45);
352:
353: end if;

Line 351: hr_utility.set_location(l_proc||' Raising error', 45);

347: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
348: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then
349: hr_utility.set_location(l_proc||' Raising error', 44);
350: raise overlapped;
351: hr_utility.set_location(l_proc||' Raising error', 45);
352:
353: end if;
354: hr_utility.set_location(l_proc||' Exiting with success', 46);
355: ELSE

Line 354: hr_utility.set_location(l_proc||' Exiting with success', 46);

350: raise overlapped;
351: hr_utility.set_location(l_proc||' Raising error', 45);
352:
353: end if;
354: hr_utility.set_location(l_proc||' Exiting with success', 46);
355: ELSE
356: hr_utility.set_location(l_proc||' No Record found ', 47);
357: close c_sch_dates;
358: l_sch_start_date:=null;

Line 356: hr_utility.set_location(l_proc||' No Record found ', 47);

352:
353: end if;
354: hr_utility.set_location(l_proc||' Exiting with success', 46);
355: ELSE
356: hr_utility.set_location(l_proc||' No Record found ', 47);
357: close c_sch_dates;
358: l_sch_start_date:=null;
359: l_sch_end_date:=null;
360:

Line 366: hr_utility.set_location(l_proc, 110);

362: end if;
363:
364: WHEN 'LOC' THEN
365: -- Get schedule from location
366: hr_utility.set_location(l_proc, 110);
367: cac_avlblty_pub.get_schedule(p_api_version => 1.0
368: ,p_init_msg_list => 'F'
369: ,p_object_type => 'HR_LOCATION'
370: ,p_object_id => l_loc_id

Line 381: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 115);

377: ,x_return_status => l_return_status
378: ,x_msg_count => l_msg_count
379: ,x_msg_data => l_msg_data
380: );
381: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 115);
382:
383: IF x_schedule.COUNT >= 1 then
384: hr_utility.set_location(l_proc||' Before opening cursor ', 51);
385: OPEN c_sch_dates ('HR_LOCATION'

Line 384: hr_utility.set_location(l_proc||' Before opening cursor ', 51);

380: );
381: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 115);
382:
383: IF x_schedule.COUNT >= 1 then
384: hr_utility.set_location(l_proc||' Before opening cursor ', 51);
385: OPEN c_sch_dates ('HR_LOCATION'
386: ,l_loc_id
387: ,p_period_start_date
388: ,p_period_end_date

Line 392: hr_utility.set_location(l_proc||' After opening cursor ', 52);

388: ,p_period_end_date
389: ,p_schedule_category
390: );
391:
392: hr_utility.set_location(l_proc||' After opening cursor ', 52);
393: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
394: hr_utility.set_location(l_proc||' After fetching', 3);
395: if(c_sch_dates%found) then
396: hr_utility.set_location(l_proc||' Record found', 53);

Line 394: hr_utility.set_location(l_proc||' After fetching', 3);

390: );
391:
392: hr_utility.set_location(l_proc||' After opening cursor ', 52);
393: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
394: hr_utility.set_location(l_proc||' After fetching', 3);
395: if(c_sch_dates%found) then
396: hr_utility.set_location(l_proc||' Record found', 53);
397: close c_sch_dates;
398: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);

Line 396: hr_utility.set_location(l_proc||' Record found', 53);

392: hr_utility.set_location(l_proc||' After opening cursor ', 52);
393: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
394: hr_utility.set_location(l_proc||' After fetching', 3);
395: if(c_sch_dates%found) then
396: hr_utility.set_location(l_proc||' Record found', 53);
397: close c_sch_dates;
398: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);
399: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
400: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then

Line 398: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);

394: hr_utility.set_location(l_proc||' After fetching', 3);
395: if(c_sch_dates%found) then
396: hr_utility.set_location(l_proc||' Record found', 53);
397: close c_sch_dates;
398: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);
399: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
400: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then
401: hr_utility.set_location(l_proc||' Raising error', 54);
402: raise overlapped;

Line 401: hr_utility.set_location(l_proc||' Raising error', 54);

397: close c_sch_dates;
398: hr_utility.set_location(l_proc||': start date '||l_sch_start_date||' end date '||to_char(l_sch_end_date), 20);
399: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
400: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then
401: hr_utility.set_location(l_proc||' Raising error', 54);
402: raise overlapped;
403: hr_utility.set_location(l_proc||' Raising error', 55);
404:
405: end if;

Line 403: hr_utility.set_location(l_proc||' Raising error', 55);

399: -- if(p_period_start_date < l_sch_start_date or p_period_end_date > l_sch_end_date) then
400: if ( p_period_start_date between l_sch_start_date and l_sch_end_date ) then
401: hr_utility.set_location(l_proc||' Raising error', 54);
402: raise overlapped;
403: hr_utility.set_location(l_proc||' Raising error', 55);
404:
405: end if;
406: hr_utility.set_location(l_proc||' Exiting with success', 56);
407: ELSE

Line 406: hr_utility.set_location(l_proc||' Exiting with success', 56);

402: raise overlapped;
403: hr_utility.set_location(l_proc||' Raising error', 55);
404:
405: end if;
406: hr_utility.set_location(l_proc||' Exiting with success', 56);
407: ELSE
408: hr_utility.set_location(l_proc||' No Record found ', 57);
409: close c_sch_dates;
410: l_sch_start_date:=null;

Line 408: hr_utility.set_location(l_proc||' No Record found ', 57);

404:
405: end if;
406: hr_utility.set_location(l_proc||' Exiting with success', 56);
407: ELSE
408: hr_utility.set_location(l_proc||' No Record found ', 57);
409: close c_sch_dates;
410: l_sch_start_date:=null;
411: l_sch_end_date:=null;
412:

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

558: x_schedule_dup cac_avlblty_time_varray;
559:
560: BEGIN
561: l_proc := 'hr_wrk_sch_pkg.get_per_asg_schedule';
562: hr_utility.set_location('Entering: '|| l_proc, 10);
563: --
564: -- Initialize
565: x_return_status := 0;
566: x_schedule := cac_avlblty_time_varray();

Line 586: hr_utility.set_location(l_proc, 20);

582: x_return_message := 'NULL P_PERIOD_END_DATE';
583: RAISE e_invalid_params;
584: END IF;
585:
586: hr_utility.set_location(l_proc, 20);
587:
588: -- Get schedule from person assignment
589: cac_avlblty_pub.get_schedule(p_api_version => 1.0
590: ,p_init_msg_list => 'F'

Line 604: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 30);

600: ,x_msg_count => l_msg_count
601: ,x_msg_data => l_msg_data
602: );
603: --
604: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 30);
605: --
606: IF x_schedule.COUNT > 1 OR (x_schedule.COUNT = 1 AND x_schedule(1).period_name IS NOT NULL) THEN
607: l_wrk_sch_found := TRUE;
608: END IF;

Line 625: hr_utility.set_location('PerAsg SchCnt:'||l_wrk_sch_count, 35);

621: IF l_wrk_sch_count > 0 THEN
622: l_wrk_sch_found := TRUE;
623: END IF;
624: --
625: hr_utility.set_location('PerAsg SchCnt:'||l_wrk_sch_count, 35);
626: END IF;
627: -- fix for the bug 6711896
628: --
629: OPEN c_sch_dates ('PERSON_ASSIGNMENT'

Line 639: hr_utility.set_location(l_proc||' start date :'||to_char(l_sch_start_date),20);

635: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
636:
637: if(c_sch_dates%found) then
638: close c_sch_dates;
639: hr_utility.set_location(l_proc||' start date :'||to_char(l_sch_start_date),20);
640: hr_utility.set_location(l_proc||' end date :'||to_char(l_sch_end_date),20);
641:
642: if ( p_period_start_date < l_sch_start_date and p_period_end_date > l_sch_start_date )
643: then

Line 640: hr_utility.set_location(l_proc||' end date :'||to_char(l_sch_end_date),20);

636:
637: if(c_sch_dates%found) then
638: close c_sch_dates;
639: hr_utility.set_location(l_proc||' start date :'||to_char(l_sch_start_date),20);
640: hr_utility.set_location(l_proc||' end date :'||to_char(l_sch_end_date),20);
641:
642: if ( p_period_start_date < l_sch_start_date and p_period_end_date > l_sch_start_date )
643: then
644:

Line 646: hr_utility.set_location('call the check overlap function :' ,20);

642: if ( p_period_start_date < l_sch_start_date and p_period_end_date > l_sch_start_date )
643: then
644:
645: x_schedule_dup :=x_schedule; -- Bug 14683476
646: hr_utility.set_location('call the check overlap function :' ,20);
647: check_overlap_schedules(p_person_assignment_id,
648: p_period_start_date,
649: p_period_end_date,
650: p_schedule_category,

Line 657: hr_utility.set_location('after checking overlaps :' ,20);

653: x_schedule_source,
654: x_schedule_dup ); -- Bug 14683476
655: end if;
656: end if;
657: hr_utility.set_location('after checking overlaps :' ,20);
658: --
659: -- fix for the bug 6711896
660: -- fix for the bug 6711896
661: --

Line 670: hr_utility.set_location('MaxSeq: '||l_sch_inh_seq, 40);

666: OPEN c_max_inh_seq;
667: FETCH c_max_inh_seq INTO l_sch_inh_seq;
668: CLOSE c_max_inh_seq;
669:
670: hr_utility.set_location('MaxSeq: '||l_sch_inh_seq, 40);
671:
672: -- Get person assignment attributes
673: OPEN c_per_asg (p_person_assignment_id
674: ,p_period_start_date

Line 683: hr_utility.set_location('BGId:'||l_bus_grp_id||

679: ,l_pos_id
680: ,l_loc_id;
681: CLOSE c_per_asg;
682:
683: hr_utility.set_location('BGId:'||l_bus_grp_id||
684: ' HROrgId:'||l_hr_org_id||
685: ' JobId:'||l_job_id||
686: ' PosId:'||l_pos_id||
687: ' LocId:'||l_loc_id, 50);

Line 695: hr_utility.set_location('SchInhLvl: '||x_schedule_source, 60);

691: OPEN c_sch_inh_lvl (l_sch_inh_seq);
692: FETCH c_sch_inh_lvl INTO x_schedule_source;
693: CLOSE c_sch_inh_lvl;
694:
695: hr_utility.set_location('SchInhLvl: '||x_schedule_source, 60);
696:
697: CASE x_schedule_source
698: WHEN 'BUS_GRP' THEN
699: -- Get schedule from business group

Line 700: hr_utility.set_location(l_proc, 70);

696:
697: CASE x_schedule_source
698: WHEN 'BUS_GRP' THEN
699: -- Get schedule from business group
700: hr_utility.set_location(l_proc, 70);
701: cac_avlblty_pub.get_schedule(p_api_version => 1.0
702: ,p_init_msg_list => 'F'
703: ,p_object_type => 'BUSINESS_GROUP'
704: ,p_object_id => l_bus_grp_id

Line 715: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 75);

711: ,x_return_status => l_return_status
712: ,x_msg_count => l_msg_count
713: ,x_msg_data => l_msg_data
714: );
715: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 75);
716:
717: WHEN 'HR_ORG' THEN
718: -- Get schedule from hr organization
719: hr_utility.set_location(l_proc, 80);

Line 719: hr_utility.set_location(l_proc, 80);

715: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 75);
716:
717: WHEN 'HR_ORG' THEN
718: -- Get schedule from hr organization
719: hr_utility.set_location(l_proc, 80);
720: cac_avlblty_pub.get_schedule(p_api_version => 1.0
721: ,p_init_msg_list => 'F'
722: ,p_object_type => 'HR_ORGANIZATION'
723: ,p_object_id => l_hr_org_id

Line 734: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 85);

730: ,x_return_status => l_return_status
731: ,x_msg_count => l_msg_count
732: ,x_msg_data => l_msg_data
733: );
734: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 85);
735:
736: WHEN 'JOB' THEN
737: -- Get schedule from job
738: hr_utility.set_location(l_proc, 90);

Line 738: hr_utility.set_location(l_proc, 90);

734: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 85);
735:
736: WHEN 'JOB' THEN
737: -- Get schedule from job
738: hr_utility.set_location(l_proc, 90);
739: cac_avlblty_pub.get_schedule(p_api_version => 1.0
740: ,p_init_msg_list => 'F'
741: ,p_object_type => 'HR_JOB'
742: ,p_object_id => l_job_id

Line 753: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 95);

749: ,x_return_status => l_return_status
750: ,x_msg_count => l_msg_count
751: ,x_msg_data => l_msg_data
752: );
753: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 95);
754:
755: WHEN 'POS' THEN
756: -- Get schedule from position
757: hr_utility.set_location(l_proc, 100);

Line 757: hr_utility.set_location(l_proc, 100);

753: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 95);
754:
755: WHEN 'POS' THEN
756: -- Get schedule from position
757: hr_utility.set_location(l_proc, 100);
758: cac_avlblty_pub.get_schedule(p_api_version => 1.0
759: ,p_init_msg_list => 'F'
760: ,p_object_type => 'HR_POSITION'
761: ,p_object_id => l_pos_id

Line 772: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 105);

768: ,x_return_status => l_return_status
769: ,x_msg_count => l_msg_count
770: ,x_msg_data => l_msg_data
771: );
772: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 105);
773:
774: WHEN 'LOC' THEN
775: -- Get schedule from location
776: hr_utility.set_location(l_proc, 110);

Line 776: hr_utility.set_location(l_proc, 110);

772: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 105);
773:
774: WHEN 'LOC' THEN
775: -- Get schedule from location
776: hr_utility.set_location(l_proc, 110);
777: cac_avlblty_pub.get_schedule(p_api_version => 1.0
778: ,p_init_msg_list => 'F'
779: ,p_object_type => 'HR_LOCATION'
780: ,p_object_id => l_loc_id

Line 791: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 115);

787: ,x_return_status => l_return_status
788: ,x_msg_count => l_msg_count
789: ,x_msg_data => l_msg_data
790: );
791: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 115);
792: END CASE;
793:
794: -- Loop exit conditions
795: IF x_schedule.COUNT > 1 OR (x_schedule.COUNT = 1 AND x_schedule(1).period_name IS NOT NULL) THEN

Line 816: hr_utility.set_location('BusGrp SchCnt:'||l_wrk_sch_count, 117);

812: IF l_wrk_sch_count > 0 THEN
813: l_wrk_sch_found := TRUE;
814: END IF;
815: --
816: hr_utility.set_location('BusGrp SchCnt:'||l_wrk_sch_count, 117);
817: --
818: WHEN 'HR_ORG' THEN
819: OPEN c_sch_found ('HR_ORGANIZATION'
820: ,l_hr_org_id

Line 831: hr_utility.set_location('HROrg SchCnt:'||l_wrk_sch_count, 117);

827: IF l_wrk_sch_count > 0 THEN
828: l_wrk_sch_found := TRUE;
829: END IF;
830: --
831: hr_utility.set_location('HROrg SchCnt:'||l_wrk_sch_count, 117);
832: --
833: WHEN 'JOB' THEN
834: OPEN c_sch_found ('HR_JOB'
835: ,l_job_id

Line 846: hr_utility.set_location('HRJob SchCnt:'||l_wrk_sch_count, 117);

842: IF l_wrk_sch_count > 0 THEN
843: l_wrk_sch_found := TRUE;
844: END IF;
845: --
846: hr_utility.set_location('HRJob SchCnt:'||l_wrk_sch_count, 117);
847: --
848: WHEN 'POS' THEN
849: OPEN c_sch_found ('HR_POSITION'
850: ,l_pos_id

Line 861: hr_utility.set_location('HRPos SchCnt:'||l_wrk_sch_count, 117);

857: IF l_wrk_sch_count > 0 THEN
858: l_wrk_sch_found := TRUE;
859: END IF;
860: --
861: hr_utility.set_location('HRPos SchCnt:'||l_wrk_sch_count, 117);
862: --
863: WHEN 'LOC' THEN
864: OPEN c_sch_found ('HR_LOCATION'
865: ,l_loc_id

Line 876: hr_utility.set_location('HRLoc SchCnt:'||l_wrk_sch_count, 117);

872: IF l_wrk_sch_count > 0 THEN
873: l_wrk_sch_found := TRUE;
874: END IF;
875: --
876: hr_utility.set_location('HRLoc SchCnt:'||l_wrk_sch_count, 117);
877: --
878: END CASE;
879: END IF;
880: --

Line 893: hr_utility.set_location('Leaving: '|| l_proc, 120);

889: IF l_return_status = 'S' THEN
890: x_return_status := 0;
891: END IF;
892:
893: hr_utility.set_location('Leaving: '|| l_proc, 120);
894:
895: EXCEPTION
896: WHEN e_invalid_params THEN
897: hr_utility.set_location('Leaving: '|| l_proc, 130);

Line 897: hr_utility.set_location('Leaving: '|| l_proc, 130);

893: hr_utility.set_location('Leaving: '|| l_proc, 120);
894:
895: EXCEPTION
896: WHEN e_invalid_params THEN
897: hr_utility.set_location('Leaving: '|| l_proc, 130);
898: hr_utility.set_location(SQLERRM, 135);
899: x_return_status := 1;
900:
901: WHEN overlapped THEN

Line 898: hr_utility.set_location(SQLERRM, 135);

894:
895: EXCEPTION
896: WHEN e_invalid_params THEN
897: hr_utility.set_location('Leaving: '|| l_proc, 130);
898: hr_utility.set_location(SQLERRM, 135);
899: x_return_status := 1;
900:
901: WHEN overlapped THEN
902: hr_utility.set_location('raising: '|| l_proc, 125);

Line 902: hr_utility.set_location('raising: '|| l_proc, 125);

898: hr_utility.set_location(SQLERRM, 135);
899: x_return_status := 1;
900:
901: WHEN overlapped THEN
902: hr_utility.set_location('raising: '|| l_proc, 125);
903: fnd_message.set_name('PER', 'HR_449835_ABS_SCHEDULE_OVERLAP');
904: /* Commented and added as a part of Bug#10239011 Starts
905: fnd_message.set_token('STARTDATE', fnd_date.date_to_chardate(l_sch_start_date));
906: fnd_message.set_token('ENDDATE', fnd_date.date_to_chardate(l_sch_end_date)); */

Line 913: hr_utility.set_location('Leaving: '|| l_proc, 140);

909: /* Commented and added as a part of Bug#10239011 Ends */
910: fnd_message.raise_error;
911:
912: WHEN OTHERS THEN
913: hr_utility.set_location('Leaving: '|| l_proc, 140);
914: hr_utility.set_location(SQLERRM, 145);
915: x_return_status := 2;
916: x_return_message := SQLERRM;
917:

Line 914: hr_utility.set_location(SQLERRM, 145);

910: fnd_message.raise_error;
911:
912: WHEN OTHERS THEN
913: hr_utility.set_location('Leaving: '|| l_proc, 140);
914: hr_utility.set_location(SQLERRM, 145);
915: x_return_status := 2;
916: x_return_message := SQLERRM;
917:
918: END get_per_asg_schedule;