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 557: hr_utility.set_location('Entering: '|| l_proc, 10);

553: -- fix for the bug 6711896
554:
555: BEGIN
556: l_proc := 'hr_wrk_sch_pkg.get_per_asg_schedule';
557: hr_utility.set_location('Entering: '|| l_proc, 10);
558: --
559: -- Initialize
560: x_return_status := 0;
561: x_schedule := cac_avlblty_time_varray();

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

577: x_return_message := 'NULL P_PERIOD_END_DATE';
578: RAISE e_invalid_params;
579: END IF;
580:
581: hr_utility.set_location(l_proc, 20);
582:
583: -- Get schedule from person assignment
584: cac_avlblty_pub.get_schedule(p_api_version => 1.0
585: ,p_init_msg_list => 'F'

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

595: ,x_msg_count => l_msg_count
596: ,x_msg_data => l_msg_data
597: );
598: --
599: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 30);
600: --
601: IF x_schedule.COUNT > 1 OR (x_schedule.COUNT = 1 AND x_schedule(1).period_name IS NOT NULL) THEN
602: l_wrk_sch_found := TRUE;
603: END IF;

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

616: IF l_wrk_sch_count > 0 THEN
617: l_wrk_sch_found := TRUE;
618: END IF;
619: --
620: hr_utility.set_location('PerAsg SchCnt:'||l_wrk_sch_count, 35);
621: END IF;
622: -- fix for the bug 6711896
623: --
624: OPEN c_sch_dates ('PERSON_ASSIGNMENT'

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

630: fetch c_sch_dates into l_sch_start_date,l_sch_end_date;
631:
632: if(c_sch_dates%found) then
633: close c_sch_dates;
634: hr_utility.set_location(l_proc||' start date :'||to_char(l_sch_start_date),20);
635: hr_utility.set_location(l_proc||' end date :'||to_char(l_sch_end_date),20);
636:
637: if ( p_period_start_date < l_sch_start_date and p_period_end_date > l_sch_start_date )
638: then

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

631:
632: if(c_sch_dates%found) then
633: close c_sch_dates;
634: hr_utility.set_location(l_proc||' start date :'||to_char(l_sch_start_date),20);
635: hr_utility.set_location(l_proc||' end date :'||to_char(l_sch_end_date),20);
636:
637: if ( p_period_start_date < l_sch_start_date and p_period_end_date > l_sch_start_date )
638: then
639: hr_utility.set_location('call the check overlap function :' ,20);

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

635: hr_utility.set_location(l_proc||' end date :'||to_char(l_sch_end_date),20);
636:
637: if ( p_period_start_date < l_sch_start_date and p_period_end_date > l_sch_start_date )
638: then
639: hr_utility.set_location('call the check overlap function :' ,20);
640: check_overlap_schedules(p_person_assignment_id,
641: p_period_start_date,
642: p_period_end_date,
643: p_schedule_category,

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

646: x_schedule_source,
647: x_schedule );
648: end if;
649: end if;
650: hr_utility.set_location('after checking overlaps :' ,20);
651: --
652: -- fix for the bug 6711896
653: -- fix for the bug 6711896
654: --

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

659: OPEN c_max_inh_seq;
660: FETCH c_max_inh_seq INTO l_sch_inh_seq;
661: CLOSE c_max_inh_seq;
662:
663: hr_utility.set_location('MaxSeq: '||l_sch_inh_seq, 40);
664:
665: -- Get person assignment attributes
666: OPEN c_per_asg (p_person_assignment_id
667: ,p_period_start_date

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

672: ,l_pos_id
673: ,l_loc_id;
674: CLOSE c_per_asg;
675:
676: hr_utility.set_location('BGId:'||l_bus_grp_id||
677: ' HROrgId:'||l_hr_org_id||
678: ' JobId:'||l_job_id||
679: ' PosId:'||l_pos_id||
680: ' LocId:'||l_loc_id, 50);

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

684: OPEN c_sch_inh_lvl (l_sch_inh_seq);
685: FETCH c_sch_inh_lvl INTO x_schedule_source;
686: CLOSE c_sch_inh_lvl;
687:
688: hr_utility.set_location('SchInhLvl: '||x_schedule_source, 60);
689:
690: CASE x_schedule_source
691: WHEN 'BUS_GRP' THEN
692: -- Get schedule from business group

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

689:
690: CASE x_schedule_source
691: WHEN 'BUS_GRP' THEN
692: -- Get schedule from business group
693: hr_utility.set_location(l_proc, 70);
694: cac_avlblty_pub.get_schedule(p_api_version => 1.0
695: ,p_init_msg_list => 'F'
696: ,p_object_type => 'BUSINESS_GROUP'
697: ,p_object_id => l_bus_grp_id

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

704: ,x_return_status => l_return_status
705: ,x_msg_count => l_msg_count
706: ,x_msg_data => l_msg_data
707: );
708: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 75);
709:
710: WHEN 'HR_ORG' THEN
711: -- Get schedule from hr organization
712: hr_utility.set_location(l_proc, 80);

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

708: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 75);
709:
710: WHEN 'HR_ORG' THEN
711: -- Get schedule from hr organization
712: hr_utility.set_location(l_proc, 80);
713: cac_avlblty_pub.get_schedule(p_api_version => 1.0
714: ,p_init_msg_list => 'F'
715: ,p_object_type => 'HR_ORGANIZATION'
716: ,p_object_id => l_hr_org_id

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

723: ,x_return_status => l_return_status
724: ,x_msg_count => l_msg_count
725: ,x_msg_data => l_msg_data
726: );
727: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 85);
728:
729: WHEN 'JOB' THEN
730: -- Get schedule from job
731: hr_utility.set_location(l_proc, 90);

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

727: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 85);
728:
729: WHEN 'JOB' THEN
730: -- Get schedule from job
731: hr_utility.set_location(l_proc, 90);
732: cac_avlblty_pub.get_schedule(p_api_version => 1.0
733: ,p_init_msg_list => 'F'
734: ,p_object_type => 'HR_JOB'
735: ,p_object_id => l_job_id

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

742: ,x_return_status => l_return_status
743: ,x_msg_count => l_msg_count
744: ,x_msg_data => l_msg_data
745: );
746: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 95);
747:
748: WHEN 'POS' THEN
749: -- Get schedule from position
750: hr_utility.set_location(l_proc, 100);

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

746: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 95);
747:
748: WHEN 'POS' THEN
749: -- Get schedule from position
750: hr_utility.set_location(l_proc, 100);
751: cac_avlblty_pub.get_schedule(p_api_version => 1.0
752: ,p_init_msg_list => 'F'
753: ,p_object_type => 'HR_POSITION'
754: ,p_object_id => l_pos_id

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

761: ,x_return_status => l_return_status
762: ,x_msg_count => l_msg_count
763: ,x_msg_data => l_msg_data
764: );
765: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 105);
766:
767: WHEN 'LOC' THEN
768: -- Get schedule from location
769: hr_utility.set_location(l_proc, 110);

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

765: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 105);
766:
767: WHEN 'LOC' THEN
768: -- Get schedule from location
769: hr_utility.set_location(l_proc, 110);
770: cac_avlblty_pub.get_schedule(p_api_version => 1.0
771: ,p_init_msg_list => 'F'
772: ,p_object_type => 'HR_LOCATION'
773: ,p_object_id => l_loc_id

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

780: ,x_return_status => l_return_status
781: ,x_msg_count => l_msg_count
782: ,x_msg_data => l_msg_data
783: );
784: hr_utility.set_location('SchCnt:'||x_schedule.COUNT, 115);
785: END CASE;
786:
787: -- Loop exit conditions
788: IF x_schedule.COUNT > 1 OR (x_schedule.COUNT = 1 AND x_schedule(1).period_name IS NOT NULL) THEN

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

805: IF l_wrk_sch_count > 0 THEN
806: l_wrk_sch_found := TRUE;
807: END IF;
808: --
809: hr_utility.set_location('BusGrp SchCnt:'||l_wrk_sch_count, 117);
810: --
811: WHEN 'HR_ORG' THEN
812: OPEN c_sch_found ('HR_ORGANIZATION'
813: ,l_hr_org_id

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

820: IF l_wrk_sch_count > 0 THEN
821: l_wrk_sch_found := TRUE;
822: END IF;
823: --
824: hr_utility.set_location('HROrg SchCnt:'||l_wrk_sch_count, 117);
825: --
826: WHEN 'JOB' THEN
827: OPEN c_sch_found ('HR_JOB'
828: ,l_job_id

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

835: IF l_wrk_sch_count > 0 THEN
836: l_wrk_sch_found := TRUE;
837: END IF;
838: --
839: hr_utility.set_location('HRJob SchCnt:'||l_wrk_sch_count, 117);
840: --
841: WHEN 'POS' THEN
842: OPEN c_sch_found ('HR_POSITION'
843: ,l_pos_id

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

850: IF l_wrk_sch_count > 0 THEN
851: l_wrk_sch_found := TRUE;
852: END IF;
853: --
854: hr_utility.set_location('HRPos SchCnt:'||l_wrk_sch_count, 117);
855: --
856: WHEN 'LOC' THEN
857: OPEN c_sch_found ('HR_LOCATION'
858: ,l_loc_id

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

865: IF l_wrk_sch_count > 0 THEN
866: l_wrk_sch_found := TRUE;
867: END IF;
868: --
869: hr_utility.set_location('HRLoc SchCnt:'||l_wrk_sch_count, 117);
870: --
871: END CASE;
872: END IF;
873: --

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

882: IF l_return_status = 'S' THEN
883: x_return_status := 0;
884: END IF;
885:
886: hr_utility.set_location('Leaving: '|| l_proc, 120);
887:
888: EXCEPTION
889: WHEN e_invalid_params THEN
890: hr_utility.set_location('Leaving: '|| l_proc, 130);

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

886: hr_utility.set_location('Leaving: '|| l_proc, 120);
887:
888: EXCEPTION
889: WHEN e_invalid_params THEN
890: hr_utility.set_location('Leaving: '|| l_proc, 130);
891: hr_utility.set_location(SQLERRM, 135);
892: x_return_status := 1;
893:
894: WHEN overlapped THEN

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

887:
888: EXCEPTION
889: WHEN e_invalid_params THEN
890: hr_utility.set_location('Leaving: '|| l_proc, 130);
891: hr_utility.set_location(SQLERRM, 135);
892: x_return_status := 1;
893:
894: WHEN overlapped THEN
895: hr_utility.set_location('raising: '|| l_proc, 125);

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

891: hr_utility.set_location(SQLERRM, 135);
892: x_return_status := 1;
893:
894: WHEN overlapped THEN
895: hr_utility.set_location('raising: '|| l_proc, 125);
896: fnd_message.set_name('PER', 'HR_449835_ABS_SCHEDULE_OVERLAP');
897: fnd_message.set_token('STARTDATE', fnd_date.date_to_chardate(l_sch_start_date));
898: fnd_message.set_token('ENDDATE', fnd_date.date_to_chardate(l_sch_end_date));
899: fnd_message.raise_error;

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

898: fnd_message.set_token('ENDDATE', fnd_date.date_to_chardate(l_sch_end_date));
899: fnd_message.raise_error;
900:
901: WHEN OTHERS THEN
902: hr_utility.set_location('Leaving: '|| l_proc, 140);
903: hr_utility.set_location(SQLERRM, 145);
904: x_return_status := 2;
905: x_return_message := SQLERRM;
906:

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

899: fnd_message.raise_error;
900:
901: WHEN OTHERS THEN
902: hr_utility.set_location('Leaving: '|| l_proc, 140);
903: hr_utility.set_location(SQLERRM, 145);
904: x_return_status := 2;
905: x_return_message := SQLERRM;
906:
907: END get_per_asg_schedule;