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

Line 89: hr_utility.set_location('Entering:'||l_proc, 5);

85: (p_position_id in number, p_effective_date in date) return varchar2 is
86: l_proc varchar2(72) := g_package||'open_status';
87: l_open_state varchar2(100):= 'OPEN';
88: begin
89: hr_utility.set_location('Entering:'||l_proc, 5);
90: --
91: -- fetch open state
92: --
93: l_open_state := pqh_psf_bus.open_status(p_position_id, p_effective_date);

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

91: -- fetch open state
92: --
93: l_open_state := pqh_psf_bus.open_status(p_position_id, p_effective_date);
94: --
95: hr_utility.set_location(' Leaving:'||l_proc, 10);
96: --
97: return l_open_state;
98: end;
99: --

Line 111: hr_utility.set_location('Entering:'||l_proc, 5);

107: (p_position_id in number) return varchar2 is
108: l_proc varchar2(72) := g_package||'future_approved_actions';
109: l_pending_action_flag varchar2(100):= 'N';
110: begin
111: hr_utility.set_location('Entering:'||l_proc, 5);
112: --
113: -- fetch future approved actions flag
114: --
115: l_pending_action_flag := pqh_psf_bus.future_approved_actions(p_position_id);

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

113: -- fetch future approved actions flag
114: --
115: l_pending_action_flag := pqh_psf_bus.future_approved_actions(p_position_id);
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: --
119: return l_pending_action_flag;
120: end;
121: --

Line 136: hr_utility.set_location('Entering:'||l_proc, 5);

132: --
133: l_proc varchar2(72) := g_package||'per_abv_insert_validate';
134: --
135: begin
136: hr_utility.set_location('Entering:'||l_proc, 5);
137: --
138: pqh_psf_bus.per_abv_insert_validate(
139: p_assignment_id =>p_assignment_id,
140: p_value =>p_value,

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

140: p_value =>p_value,
141: p_unit =>p_unit,
142: p_effective_date =>p_effective_date);
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 10);
145: end;
146: --
147: -- ---------------------------------------------------------------------------
148: -- |----------------------< per_abv_update_validate >-------------------|

Line 164: hr_utility.set_location('Entering:'||l_proc, 5);

160: --
161: l_proc varchar2(72) := g_package||'per_abv_update_validate';
162: --
163: begin
164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: pqh_psf_bus.per_abv_update_validate(
167: p_abv_id =>p_abv_id,
168: p_assignment_id =>p_assignment_id,

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

172: p_validation_start_date =>p_validation_start_date,
173: p_validation_end_date =>p_validation_end_date,
174: p_datetrack_mode =>p_datetrack_mode);
175: --
176: hr_utility.set_location(' Leaving:'||l_proc, 10);
177: end;
178: --
179: -- ----------------------------------------------------------------------------
180: -- |------------------------< hr_psf_bus >--------------------|

Line 192: hr_utility.set_location('Entering:'||l_proc, 5);

188: --
189: l_proc varchar2(72) := g_package||'hr_psf_bus';
190: --
191: begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
194: if p_event = 'INSERT_VALIDATE' then
195: pqh_psf_bus.hr_psf_bus_insert_validate(p_rec, p_effective_date);
196: elsif p_event = 'UPDATE_VALIDATE' then

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

196: elsif p_event = 'UPDATE_VALIDATE' then
197: pqh_psf_bus.hr_psf_bus_update_validate(p_rec, p_effective_date, p_validation_start_date,p_validation_end_date, p_datetrack_mode );
198: end if;
199: --
200: hr_utility.set_location(' Leaving:'||l_proc, 10);
201: end;
202: --
203: --
204: -- ----------------------------------------------------------------------------

Line 217: hr_utility.set_location('Entering:'||l_proc, 5);

213: --
214: l_proc varchar2(72) := g_package||'per_asg_bus';
215: --
216: begin
217: hr_utility.set_location('Entering:'||l_proc, 5);
218: --
219: if p_event = 'INSERT_VALIDATE' then
220: pqh_psf_bus.per_asg_bus_insert_validate(p_rec, p_effective_date);
221: elsif p_event = 'UPDATE_VALIDATE' then

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

232: ,p_validation_end_date => p_validation_end_date
233: ,p_datetrack_mode => p_datetrack_mode);
234: end if;
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 10);
237: end;
238: --
239: --
240: -- ----------------------------------------------------------------------------

Line 249: hr_utility.set_location('Entering:'||l_proc, 5);

245: --
246: l_proc varchar2(72) := g_package||'hr_psf_bus';
247: --
248: begin
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 10);
253: end;

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

248: begin
249: hr_utility.set_location('Entering:'||l_proc, 5);
250: --
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 10);
253: end;
254: --
255: --
256: -- ----------------------------------------------------------------------------

Line 265: hr_utility.set_location('Entering:'||l_proc, 5);

261: --
262: l_proc varchar2(72) := g_package||'hr_psf_bus';
263: --
264: begin
265: hr_utility.set_location('Entering:'||l_proc, 5);
266: --
267: --
268: hr_utility.set_location(' Leaving:'||l_proc, 10);
269: end;

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

264: begin
265: hr_utility.set_location('Entering:'||l_proc, 5);
266: --
267: --
268: hr_utility.set_location(' Leaving:'||l_proc, 10);
269: end;
270: --
271: /*
272: --

Line 282: hr_utility.set_location('Entering:'||l_proc, 5);

278: --
279: l_proc varchar2(72) := g_package||'hr_psf_bus';
280: --
281: begin
282: hr_utility.set_location('Entering:'||l_proc, 5);
283: --
284: --
285: hr_utility.set_location(' Leaving:'||l_proc, 10);
286: end;

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

281: begin
282: hr_utility.set_location('Entering:'||l_proc, 5);
283: --
284: --
285: hr_utility.set_location(' Leaving:'||l_proc, 10);
286: end;
287: --
288: */
289: --

Line 299: hr_utility.set_location('Entering:'||l_proc, 5);

295: --
296: l_proc varchar2(72) := g_package||'hr_psf_bus';
297: --
298: begin
299: hr_utility.set_location('Entering:'||l_proc, 5);
300: --
301: --
302: hr_utility.set_location(' Leaving:'||l_proc, 10);
303: end;

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

298: begin
299: hr_utility.set_location('Entering:'||l_proc, 5);
300: --
301: --
302: hr_utility.set_location(' Leaving:'||l_proc, 10);
303: end;
304: --
305: --
306: -- ----------------------------------------------------------------------------

Line 315: hr_utility.set_location('Entering:'||l_proc, 5);

311: --
312: l_proc varchar2(72) := g_package||'hr_psf_bus';
313: --
314: begin
315: hr_utility.set_location('Entering:'||l_proc, 5);
316: --
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 10);
319: end;

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

314: begin
315: hr_utility.set_location('Entering:'||l_proc, 5);
316: --
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 10);
319: end;
320: --
321: --
322: -- ----------------------------------------------------------------------------

Line 331: hr_utility.set_location('Entering:'||l_proc, 5);

327: --
328: l_proc varchar2(72) := g_package||'hr_psf_bus';
329: --
330: begin
331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: --
334: hr_utility.set_location(' Leaving:'||l_proc, 10);
335: end;

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

330: begin
331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: --
334: hr_utility.set_location(' Leaving:'||l_proc, 10);
335: end;
336: --
337: --
338: -- ----------------------------------------------------------------------------

Line 347: hr_utility.set_location('Entering:'||l_proc, 5);

343: --
344: l_proc varchar2(72) := g_package||'hr_psf_bus';
345: --
346: begin
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: --
350: hr_utility.set_location(' Leaving:'||l_proc, 10);
351: end;

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

346: begin
347: hr_utility.set_location('Entering:'||l_proc, 5);
348: --
349: --
350: hr_utility.set_location(' Leaving:'||l_proc, 10);
351: end;
352: --
353: --
354: -- ----------------------------------------------------------------------------

Line 363: hr_utility.set_location('Entering:'||l_proc, 5);

359: --
360: l_proc varchar2(72) := g_package||'hr_psf_bus';
361: --
362: begin
363: hr_utility.set_location('Entering:'||l_proc, 5);
364: --
365: --
366: hr_utility.set_location(' Leaving:'||l_proc, 10);
367: end;

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

362: begin
363: hr_utility.set_location('Entering:'||l_proc, 5);
364: --
365: --
366: hr_utility.set_location(' Leaving:'||l_proc, 10);
367: end;
368: --
369: --
370: -- ----------------------------------------------------------------------------

Line 379: hr_utility.set_location('Entering:'||l_proc, 5);

375: --
376: l_proc varchar2(72) := g_package||'hr_psf_bus';
377: --
378: begin
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: --
381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 10);
383: end;

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

378: begin
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: --
381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 10);
383: end;
384: --
385: --
386: -- ----------------------------------------------------------------------------

Line 395: hr_utility.set_location('Entering:'||l_proc, 5);

391: --
392: l_proc varchar2(72) := g_package||'hr_psf_bus';
393: --
394: begin
395: hr_utility.set_location('Entering:'||l_proc, 5);
396: --
397: --
398: hr_utility.set_location(' Leaving:'||l_proc, 10);
399: end;

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

394: begin
395: hr_utility.set_location('Entering:'||l_proc, 5);
396: --
397: --
398: hr_utility.set_location(' Leaving:'||l_proc, 10);
399: end;
400: --
401: --
402: -- ----------------------------------------------------------------------------

Line 411: hr_utility.set_location('Entering:'||l_proc, 5);

407: --
408: l_proc varchar2(72) := g_package||'hr_psf_bus';
409: --
410: begin
411: hr_utility.set_location('Entering:'||l_proc, 5);
412: --
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 10);
415: end;

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

410: begin
411: hr_utility.set_location('Entering:'||l_proc, 5);
412: --
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 10);
415: end;
416: --
417: --
418: -- ----------------------------------------------------------------------------

Line 427: hr_utility.set_location('Entering:'||l_proc, 5);

423: --
424: l_proc varchar2(72) := g_package||'hr_psf_bus';
425: --
426: begin
427: hr_utility.set_location('Entering:'||l_proc, 5);
428: --
429: --
430: hr_utility.set_location(' Leaving:'||l_proc, 10);
431: end;

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

426: begin
427: hr_utility.set_location('Entering:'||l_proc, 5);
428: --
429: --
430: hr_utility.set_location(' Leaving:'||l_proc, 10);
431: end;
432: --
433: --
434: -- ----------------------------------------------------------------------------

Line 443: hr_utility.set_location('Entering:'||l_proc, 5);

439: --
440: l_proc varchar2(72) := g_package||'hr_psf_bus';
441: --
442: begin
443: hr_utility.set_location('Entering:'||l_proc, 5);
444: --
445: --
446: hr_utility.set_location(' Leaving:'||l_proc, 10);
447: end;

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

442: begin
443: hr_utility.set_location('Entering:'||l_proc, 5);
444: --
445: --
446: hr_utility.set_location(' Leaving:'||l_proc, 10);
447: end;
448: --
449: --
450: -- ----------------------------------------------------------------------------

Line 459: hr_utility.set_location('Entering:'||l_proc, 5);

455: --
456: l_proc varchar2(72) := g_package||'hr_psf_bus';
457: --
458: begin
459: hr_utility.set_location('Entering:'||l_proc, 5);
460: --
461: --
462: hr_utility.set_location(' Leaving:'||l_proc, 10);
463: end;

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

458: begin
459: hr_utility.set_location('Entering:'||l_proc, 5);
460: --
461: --
462: hr_utility.set_location(' Leaving:'||l_proc, 10);
463: end;
464: --
465: --
466: -- ----------------------------------------------------------------------------

Line 475: hr_utility.set_location('Entering:'||l_proc, 5);

471: --
472: l_proc varchar2(72) := g_package||'hr_psf_bus';
473: --
474: begin
475: hr_utility.set_location('Entering:'||l_proc, 5);
476: --
477: --
478: hr_utility.set_location(' Leaving:'||l_proc, 10);
479: end;

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

474: begin
475: hr_utility.set_location('Entering:'||l_proc, 5);
476: --
477: --
478: hr_utility.set_location(' Leaving:'||l_proc, 10);
479: end;
480: --
481: --
482: --

Line 582: hr_utility.set_location('Entered '||l_proc,10);

578: and effective_start_date = p_start_date
579: and effective_end_date = p_end_date;
580:
581: Begin
582: hr_utility.set_location('Entered '||l_proc,10);
583:
584: l_entity := wf_event.getvalueforparameter( p_name => 'CONTEXT',
585: p_parameterlist => my_parms);
586:

Line 633: hr_utility.set_location(l_proc||'l_entity ='||l_entity,40);

629:
630: l_expiration_date := fnd_date.canonical_to_date(l_expiration_date_can);
631:
632:
633: hr_utility.set_location(l_proc||'l_entity ='||l_entity,40);
634: hr_utility.set_location(l_proc||'l_event ='||l_event,50);
635: hr_utility.set_location(l_proc||'l_datetrack_mode ='||l_datetrack_mode,60);
636: hr_utility.set_location(l_proc||'l_assignment_id ='||l_assignment_id,70);
637: hr_utility.set_location(l_proc||'l_user_orig_system ='||l_user_orig_system,80);

Line 634: hr_utility.set_location(l_proc||'l_event ='||l_event,50);

630: l_expiration_date := fnd_date.canonical_to_date(l_expiration_date_can);
631:
632:
633: hr_utility.set_location(l_proc||'l_entity ='||l_entity,40);
634: hr_utility.set_location(l_proc||'l_event ='||l_event,50);
635: hr_utility.set_location(l_proc||'l_datetrack_mode ='||l_datetrack_mode,60);
636: hr_utility.set_location(l_proc||'l_assignment_id ='||l_assignment_id,70);
637: hr_utility.set_location(l_proc||'l_user_orig_system ='||l_user_orig_system,80);
638: hr_utility.set_location(l_proc||'l_user_orig_system_id ='||l_user_orig_system_id,90);

Line 635: hr_utility.set_location(l_proc||'l_datetrack_mode ='||l_datetrack_mode,60);

631:
632:
633: hr_utility.set_location(l_proc||'l_entity ='||l_entity,40);
634: hr_utility.set_location(l_proc||'l_event ='||l_event,50);
635: hr_utility.set_location(l_proc||'l_datetrack_mode ='||l_datetrack_mode,60);
636: hr_utility.set_location(l_proc||'l_assignment_id ='||l_assignment_id,70);
637: hr_utility.set_location(l_proc||'l_user_orig_system ='||l_user_orig_system,80);
638: hr_utility.set_location(l_proc||'l_user_orig_system_id ='||l_user_orig_system_id,90);
639: hr_utility.set_location(l_proc||'l_role_orig_system ='||l_role_orig_system,100);

Line 636: hr_utility.set_location(l_proc||'l_assignment_id ='||l_assignment_id,70);

632:
633: hr_utility.set_location(l_proc||'l_entity ='||l_entity,40);
634: hr_utility.set_location(l_proc||'l_event ='||l_event,50);
635: hr_utility.set_location(l_proc||'l_datetrack_mode ='||l_datetrack_mode,60);
636: hr_utility.set_location(l_proc||'l_assignment_id ='||l_assignment_id,70);
637: hr_utility.set_location(l_proc||'l_user_orig_system ='||l_user_orig_system,80);
638: hr_utility.set_location(l_proc||'l_user_orig_system_id ='||l_user_orig_system_id,90);
639: hr_utility.set_location(l_proc||'l_role_orig_system ='||l_role_orig_system,100);
640: hr_utility.set_location(l_proc||'l_role_orig_system_id ='||l_role_orig_system_id,110);

Line 637: hr_utility.set_location(l_proc||'l_user_orig_system ='||l_user_orig_system,80);

633: hr_utility.set_location(l_proc||'l_entity ='||l_entity,40);
634: hr_utility.set_location(l_proc||'l_event ='||l_event,50);
635: hr_utility.set_location(l_proc||'l_datetrack_mode ='||l_datetrack_mode,60);
636: hr_utility.set_location(l_proc||'l_assignment_id ='||l_assignment_id,70);
637: hr_utility.set_location(l_proc||'l_user_orig_system ='||l_user_orig_system,80);
638: hr_utility.set_location(l_proc||'l_user_orig_system_id ='||l_user_orig_system_id,90);
639: hr_utility.set_location(l_proc||'l_role_orig_system ='||l_role_orig_system,100);
640: hr_utility.set_location(l_proc||'l_role_orig_system_id ='||l_role_orig_system_id,110);
641: hr_utility.set_location(l_proc||'l_old_position_id ='||l_old_position_id,120);

Line 638: hr_utility.set_location(l_proc||'l_user_orig_system_id ='||l_user_orig_system_id,90);

634: hr_utility.set_location(l_proc||'l_event ='||l_event,50);
635: hr_utility.set_location(l_proc||'l_datetrack_mode ='||l_datetrack_mode,60);
636: hr_utility.set_location(l_proc||'l_assignment_id ='||l_assignment_id,70);
637: hr_utility.set_location(l_proc||'l_user_orig_system ='||l_user_orig_system,80);
638: hr_utility.set_location(l_proc||'l_user_orig_system_id ='||l_user_orig_system_id,90);
639: hr_utility.set_location(l_proc||'l_role_orig_system ='||l_role_orig_system,100);
640: hr_utility.set_location(l_proc||'l_role_orig_system_id ='||l_role_orig_system_id,110);
641: hr_utility.set_location(l_proc||'l_old_position_id ='||l_old_position_id,120);
642: hr_utility.set_location(l_proc||'l_user_name ='||l_user_name,130);

Line 639: hr_utility.set_location(l_proc||'l_role_orig_system ='||l_role_orig_system,100);

635: hr_utility.set_location(l_proc||'l_datetrack_mode ='||l_datetrack_mode,60);
636: hr_utility.set_location(l_proc||'l_assignment_id ='||l_assignment_id,70);
637: hr_utility.set_location(l_proc||'l_user_orig_system ='||l_user_orig_system,80);
638: hr_utility.set_location(l_proc||'l_user_orig_system_id ='||l_user_orig_system_id,90);
639: hr_utility.set_location(l_proc||'l_role_orig_system ='||l_role_orig_system,100);
640: hr_utility.set_location(l_proc||'l_role_orig_system_id ='||l_role_orig_system_id,110);
641: hr_utility.set_location(l_proc||'l_old_position_id ='||l_old_position_id,120);
642: hr_utility.set_location(l_proc||'l_user_name ='||l_user_name,130);
643: hr_utility.set_location(l_proc||'l_start_date ='||l_start_date,140);

Line 640: hr_utility.set_location(l_proc||'l_role_orig_system_id ='||l_role_orig_system_id,110);

636: hr_utility.set_location(l_proc||'l_assignment_id ='||l_assignment_id,70);
637: hr_utility.set_location(l_proc||'l_user_orig_system ='||l_user_orig_system,80);
638: hr_utility.set_location(l_proc||'l_user_orig_system_id ='||l_user_orig_system_id,90);
639: hr_utility.set_location(l_proc||'l_role_orig_system ='||l_role_orig_system,100);
640: hr_utility.set_location(l_proc||'l_role_orig_system_id ='||l_role_orig_system_id,110);
641: hr_utility.set_location(l_proc||'l_old_position_id ='||l_old_position_id,120);
642: hr_utility.set_location(l_proc||'l_user_name ='||l_user_name,130);
643: hr_utility.set_location(l_proc||'l_start_date ='||l_start_date,140);
644: hr_utility.set_location(l_proc||'l_expiration_date ='||l_expiration_date,150);

Line 641: hr_utility.set_location(l_proc||'l_old_position_id ='||l_old_position_id,120);

637: hr_utility.set_location(l_proc||'l_user_orig_system ='||l_user_orig_system,80);
638: hr_utility.set_location(l_proc||'l_user_orig_system_id ='||l_user_orig_system_id,90);
639: hr_utility.set_location(l_proc||'l_role_orig_system ='||l_role_orig_system,100);
640: hr_utility.set_location(l_proc||'l_role_orig_system_id ='||l_role_orig_system_id,110);
641: hr_utility.set_location(l_proc||'l_old_position_id ='||l_old_position_id,120);
642: hr_utility.set_location(l_proc||'l_user_name ='||l_user_name,130);
643: hr_utility.set_location(l_proc||'l_start_date ='||l_start_date,140);
644: hr_utility.set_location(l_proc||'l_expiration_date ='||l_expiration_date,150);
645:

Line 642: hr_utility.set_location(l_proc||'l_user_name ='||l_user_name,130);

638: hr_utility.set_location(l_proc||'l_user_orig_system_id ='||l_user_orig_system_id,90);
639: hr_utility.set_location(l_proc||'l_role_orig_system ='||l_role_orig_system,100);
640: hr_utility.set_location(l_proc||'l_role_orig_system_id ='||l_role_orig_system_id,110);
641: hr_utility.set_location(l_proc||'l_old_position_id ='||l_old_position_id,120);
642: hr_utility.set_location(l_proc||'l_user_name ='||l_user_name,130);
643: hr_utility.set_location(l_proc||'l_start_date ='||l_start_date,140);
644: hr_utility.set_location(l_proc||'l_expiration_date ='||l_expiration_date,150);
645:
646: open C_Pos_Per_Exist(l_role_orig_system_id,l_start_date, l_expiration_date);

Line 643: hr_utility.set_location(l_proc||'l_start_date ='||l_start_date,140);

639: hr_utility.set_location(l_proc||'l_role_orig_system ='||l_role_orig_system,100);
640: hr_utility.set_location(l_proc||'l_role_orig_system_id ='||l_role_orig_system_id,110);
641: hr_utility.set_location(l_proc||'l_old_position_id ='||l_old_position_id,120);
642: hr_utility.set_location(l_proc||'l_user_name ='||l_user_name,130);
643: hr_utility.set_location(l_proc||'l_start_date ='||l_start_date,140);
644: hr_utility.set_location(l_proc||'l_expiration_date ='||l_expiration_date,150);
645:
646: open C_Pos_Per_Exist(l_role_orig_system_id,l_start_date, l_expiration_date);
647: fetch C_Pos_Per_Exist into l_pos_id;

Line 644: hr_utility.set_location(l_proc||'l_expiration_date ='||l_expiration_date,150);

640: hr_utility.set_location(l_proc||'l_role_orig_system_id ='||l_role_orig_system_id,110);
641: hr_utility.set_location(l_proc||'l_old_position_id ='||l_old_position_id,120);
642: hr_utility.set_location(l_proc||'l_user_name ='||l_user_name,130);
643: hr_utility.set_location(l_proc||'l_start_date ='||l_start_date,140);
644: hr_utility.set_location(l_proc||'l_expiration_date ='||l_expiration_date,150);
645:
646: open C_Pos_Per_Exist(l_role_orig_system_id,l_start_date, l_expiration_date);
647: fetch C_Pos_Per_Exist into l_pos_id;
648:

Line 652: hr_utility.set_location(l_proc,160);

648:
649: if C_Pos_Per_Exist%notfound then
650: close C_Pos_Per_Exist;
651: else
652: hr_utility.set_location(l_proc,160);
653: if l_datetrack_mode = 'CORRECTION' then
654:
655: WF_LOCAL_SYNCH.propagate_user_role(p_user_orig_system => l_user_orig_system,
656: p_user_orig_system_id => l_user_orig_system_id,

Line 661: hr_utility.set_location(l_proc,170);

657: p_role_orig_system => l_role_orig_system,
658: p_role_orig_system_id => l_role_orig_system_id,
659: p_start_date => hr_general.end_of_time,
660: p_expiration_date => hr_general.end_of_time);
661: hr_utility.set_location(l_proc,170);
662: else
663:
664: /* Below call to Wf_Directory.DeleteUserRole is to deleted already end-dated old POS - PER relation.
665: After deleting the old one, we can create the new relation with new POS */

Line 666: hr_utility.set_location(l_proc,180);

662: else
663:
664: /* Below call to Wf_Directory.DeleteUserRole is to deleted already end-dated old POS - PER relation.
665: After deleting the old one, we can create the new relation with new POS */
666: hr_utility.set_location(l_proc,180);
667: /*Wf_Directory.DeleteUserRole ( p_username => l_user_name,
668: p_rolename => 'POS'|| ':' || l_old_position_id,
669: p_userOrigSystem => 'PER',
670: p_userOrigSystemID => l_user_orig_system_id,

Line 676: hr_utility.set_location(l_proc,190);

672: p_roleOrigSystemID => l_old_position_id);*/
673:
674: /* Wf_Directory.RemoveUsersFromAdHocRole(role_name => 'POS'|| ':' || l_old_position_id,
675: role_users => l_user_name);*/
676: hr_utility.set_location(l_proc,190);
677: WF_LOCAL_SYNCH.propagate_user_role(p_user_orig_system => l_user_orig_system,
678: p_user_orig_system_id => l_user_orig_system_id,
679: p_role_orig_system => l_role_orig_system,
680: p_role_orig_system_id => l_role_orig_system_id,

Line 683: hr_utility.set_location(l_proc,200);

679: p_role_orig_system => l_role_orig_system,
680: p_role_orig_system_id => l_role_orig_system_id,
681: p_start_date => l_start_date,
682: p_expiration_date => l_expiration_date);
683: hr_utility.set_location(l_proc,200);
684: end if;
685: Close C_Pos_Per_Exist;
686: end if;
687: hr_utility.set_location('Leaving - '||l_proc,160);

Line 687: hr_utility.set_location('Leaving - '||l_proc,160);

683: hr_utility.set_location(l_proc,200);
684: end if;
685: Close C_Pos_Per_Exist;
686: end if;
687: hr_utility.set_location('Leaving - '||l_proc,160);
688: End mysynch_routine;
689:
690: --
691: --

Line 780: hr_utility.set_location('Entering:'||l_proc, 5);

776: AND ass.position_id = p_old_position_id;
777:
778:
779: begin
780: hr_utility.set_location('Entering:'||l_proc, 5);
781: --
782: l_position_id := p_rec.position_id;
783: l_assignment_id := p_rec.assignment_id;
784: l_old_position_id := nvl(per_asg_shd.g_old_rec.position_id,p_old_position_id);

Line 897: hr_utility.set_location(l_proc,96);

893:
894: wf_event.addparametertolist(p_name => 'EXPIRATION_DATE',
895: p_value => l_assg_end_date_canonical,
896: p_parameterlist => l_plist);
897: hr_utility.set_location(l_proc,96);
898: wf_util.call_me_later(p_callback => 'per_pqh_shr.mysynch_routine',
899: p_when => trunc(l_assg_start_date),
900: p_parameters => l_plist);
901:

Line 930: hr_utility.set_location(l_proc||'To Delete previous user role',86);

926:
927: if l_assg_start_date <= l_current_date -- to check if the start date of the new relation is in the past or future
928: then -- below call is to synch user role as the start date is in the past
929:
930: hr_utility.set_location(l_proc||'To Delete previous user role',86);
931: /* Wf_Directory.DeleteUserRole ( p_username => l_user_name,
932: p_rolename => 'POS'|| ':' || l_old_pos_id,
933: p_userOrigSystem => 'PER',
934: p_userOrigSystemID => p_rec.person_id,

Line 941: hr_utility.set_location(l_proc||'Deleted pervious user role',87);

937:
938: /*Wf_Directory.RemoveUsersFromAdHocRole(role_name => 'POS'|| ':' || l_old_pos_id,
939: role_users => l_user_name);*/
940:
941: hr_utility.set_location(l_proc||'Deleted pervious user role',87);
942: WF_LOCAL_SYNCH.propagate_user_role(p_user_orig_system => 'PER',
943: p_user_orig_system_id => p_rec.person_id,
944: p_role_orig_system => 'POS',
945: p_role_orig_system_id => l_position_id,

Line 949: hr_utility.set_location(l_proc,95);

945: p_role_orig_system_id => l_position_id,
946: p_start_date => l_assg_start_date,
947: p_expiration_date => least(l_assg_end_date,nvl(l_usr_end_date,hr_general.end_of_time)));
948: else -- below call is to queue and call back later on appropriate date as the start date is in the future
949: hr_utility.set_location(l_proc,95);
950: l_per_id_can := fnd_number.number_to_canonical(p_rec.person_id);
951: l_assignment_id_canonical := fnd_number.number_to_canonical(l_assignment_id);
952: l_position_id_canonical := fnd_number.number_to_canonical(l_position_id);
953: l_assg_start_date_canonical := fnd_date.date_to_canonical(greatest(l_effective_start_date,l_usr_strt_date));

Line 1004: hr_utility.set_location(l_proc,96);

1000:
1001: wf_event.addparametertolist(p_name => 'EXPIRATION_DATE',
1002: p_value => l_assg_end_date_canonical,
1003: p_parameterlist => l_plist);
1004: hr_utility.set_location(l_proc,96);
1005: wf_util.call_me_later(p_callback => 'per_pqh_shr.mysynch_routine',
1006: p_when => trunc(l_assg_start_date),
1007: p_parameters => l_plist);
1008:

Line 1026: hr_utility.set_location('Leaving:'||l_proc, 5);

1022: end if;
1023: end if;
1024: -- fix for bug 8945335 ends here
1025: --
1026: hr_utility.set_location('Leaving:'||l_proc, 5);
1027:
1028: end per_asg_wf_sync;
1029: --
1030: -- ----------------------------------------------------------------------------

Line 1108: hr_utility.set_location('ORIG SYSTEM ID: '|| r_person.USER_ORIG_SYSTEM_ID||l_proc, 5);

1104: if l_assignment_id is not null then
1105: open c_person(l_assignment_id);
1106: fetch c_person into r_person;
1107:
1108: hr_utility.set_location('ORIG SYSTEM ID: '|| r_person.USER_ORIG_SYSTEM_ID||l_proc, 5);
1109: hr_utility.set_location('ORIG SYSTEM:'|| r_person.USER_ORIG_SYSTEM|| l_proc, 5);
1110: hr_utility.set_location('ROLE ORIG SYSTEM:'|| r_person.ROLE_ORIG_SYSTEM|| l_proc, 5);
1111:
1112: if c_person%notfound then

Line 1109: hr_utility.set_location('ORIG SYSTEM:'|| r_person.USER_ORIG_SYSTEM|| l_proc, 5);

1105: open c_person(l_assignment_id);
1106: fetch c_person into r_person;
1107:
1108: hr_utility.set_location('ORIG SYSTEM ID: '|| r_person.USER_ORIG_SYSTEM_ID||l_proc, 5);
1109: hr_utility.set_location('ORIG SYSTEM:'|| r_person.USER_ORIG_SYSTEM|| l_proc, 5);
1110: hr_utility.set_location('ROLE ORIG SYSTEM:'|| r_person.ROLE_ORIG_SYSTEM|| l_proc, 5);
1111:
1112: if c_person%notfound then
1113: /*

Line 1110: hr_utility.set_location('ROLE ORIG SYSTEM:'|| r_person.ROLE_ORIG_SYSTEM|| l_proc, 5);

1106: fetch c_person into r_person;
1107:
1108: hr_utility.set_location('ORIG SYSTEM ID: '|| r_person.USER_ORIG_SYSTEM_ID||l_proc, 5);
1109: hr_utility.set_location('ORIG SYSTEM:'|| r_person.USER_ORIG_SYSTEM|| l_proc, 5);
1110: hr_utility.set_location('ROLE ORIG SYSTEM:'|| r_person.ROLE_ORIG_SYSTEM|| l_proc, 5);
1111:
1112: if c_person%notfound then
1113: /*
1114: open c_per_pos_del(r_person.USER_ORIG_SYSTEM_ID);

Line 1117: hr_utility.set_location('WF_SYNC set DELETE parameter true: '||l_proc, 10);

1113: /*
1114: open c_per_pos_del(r_person.USER_ORIG_SYSTEM_ID);
1115: fetch c_per_pos_del into l_dummy;
1116: if c_per_pos_del%found then
1117: hr_utility.set_location('WF_SYNC set DELETE parameter true: '||l_proc, 10);
1118: wf_event.AddParameterToList('USER_NAME', r_person.ROLE_NAME,l_plist);
1119: wf_event.AddParameterToList('DELETE', 'TRUE',l_plist);
1120: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
1121: -- synch the wf_local_user table --

Line 1122: hr_utility.set_location('Before deleting WF_SYNC package role_user: '

1118: wf_event.AddParameterToList('USER_NAME', r_person.ROLE_NAME,l_plist);
1119: wf_event.AddParameterToList('DELETE', 'TRUE',l_plist);
1120: wf_event.AddParameterToList( 'Raiseerrors', 'TRUE', l_plist);
1121: -- synch the wf_local_user table --
1122: hr_utility.set_location('Before deleting WF_SYNC package role_user: '
1123: || r_person.USER_NAME, 15);
1124: wf_local_synch.propagate_user_role(p_user_orig_system => r_person.USER_ORIG_SYSTEM,
1125: p_user_orig_system_id => r_person.USER_ORIG_SYSTEM_ID,
1126: p_role_orig_system => r_person.ROLE_ORIG_SYSTEM,

Line 1128: hr_utility.set_location('After deleting WF_SYNC role_user: '||l_proc, 20);

1124: wf_local_synch.propagate_user_role(p_user_orig_system => r_person.USER_ORIG_SYSTEM,
1125: p_user_orig_system_id => r_person.USER_ORIG_SYSTEM_ID,
1126: p_role_orig_system => r_person.ROLE_ORIG_SYSTEM,
1127: p_role_orig_system_id => r_person.ROLE_ORIG_SYSTEM_ID);
1128: hr_utility.set_location('After deleting WF_SYNC role_user: '||l_proc, 20);
1129: --
1130: end if;
1131: */
1132: --

Line 1143: hr_utility.set_location('Before calling add parameters: '||l_proc, 20);

1139:
1140: --
1141: -- construct the list of attributes using standard OID att names --
1142: --
1143: hr_utility.set_location('Before calling add parameters: '||l_proc, 20);
1144: wf_event.AddParameterToList( 'orclWFOrigSystem',r_person.ROLE_ORIG_SYSTEM,l_plist);
1145: wf_event.AddParameterToList( 'orclWFOrigSystemID',r_person.ROLE_ORIG_SYSTEM_ID,l_plist);
1146: wf_event.AddParameterToList( 'orclWorkFlowNotificationPref', r_person.NOTIFICATION_PREFERENCE, l_plist);
1147: wf_event.AddParameterToList('preferredLanguage',r_person.LANGUAGE,l_plist);

Line 1162: hr_utility.set_location('In Insert WF_SYNC role: '

1158: p_name => 'USER_NAME',
1159: p_value => r_person.ROLE_NAME,
1160: p_parameterlist => l_plist);
1161:
1162: hr_utility.set_location('In Insert WF_SYNC role: '
1163: || r_person.ROLE_NAME, 25);
1164:
1165:
1166: WF_LOCAL_SYNCH.propagate_role(p_orig_system => r_person.ROLE_ORIG_SYSTEM,

Line 1175: hr_utility.set_location('In Insert WF_SYNC user: '

1171: open c_user_exists(r_person.USER_ORIG_SYSTEM_ID);
1172: fetch c_user_exists into l_dummy_user;
1173:
1174: if c_user_exists%notfound then
1175: hr_utility.set_location('In Insert WF_SYNC user: '
1176: || r_person.USER_NAME, 25);
1177: wf_event.AddParameterToList(
1178: p_name => 'USER_NAME',
1179: p_value => r_person.USER_NAME,

Line 1188: hr_utility.set_location('Before calling WF_SYNC propagate user_role: '

1184: p_attributes => l_plist);
1185: end if;
1186:
1187: -- synch the wf_local_user table --
1188: hr_utility.set_location('Before calling WF_SYNC propagate user_role: '
1189: || r_person.USER_ORIG_SYSTEM_ID, 30);
1190: WF_LOCAL_SYNCH.propagate_user_role(
1191: p_user_orig_system => r_person.USER_ORIG_SYSTEM,
1192: p_user_orig_system_id => r_person.USER_ORIG_SYSTEM_ID,

Line 1196: hr_utility.set_location('After calling WF_SYNC propagate user_role: '||l_proc, 35);

1192: p_user_orig_system_id => r_person.USER_ORIG_SYSTEM_ID,
1193: p_role_orig_system => r_person.ROLE_ORIG_SYSTEM,
1194: p_role_orig_system_id => r_person.ROLE_ORIG_SYSTEM_ID);
1195:
1196: hr_utility.set_location('After calling WF_SYNC propagate user_role: '||l_proc, 35);
1197: --
1198: end my_synch_routine;
1199: --
1200: end per_pqh_shr;