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

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

27: -- elsif sysdate > p_start_date then
28: -- return 'PAST'
29: -- end if;
30: --
31: hr_utility.set_location('Entering '||l_proc,10);
32: --
33: -- bug 4635241 Modified the following If condition to consider the Past date as well
34: --
35: if sysdate between p_start_date and p_end_date

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

46: l_status := 'PAST';
47: --
48: end if;
49: --
50: hr_utility.set_location('Leaving '||l_proc,10);
51: return(l_status);
52: --
53: end chk_date_status;
54: --

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

95: and trunc(effective_end_date) = l_end_date;
96: --
97: begin
98: --
99: hr_utility.set_location('Entering '||l_proc,10);
100: --
101: -- Check that the records exist in the parameter list.
102: -- if p_parametrs.count = 0 then .... return .....end if
103: --

Line 106: hr_utility.set_location('Not a single parameter exists '||l_proc,15);

102: -- if p_parametrs.count = 0 then .... return .....end if
103: --
104: if p_parameters.count = 0 then
105: --
106: hr_utility.set_location('Not a single parameter exists '||l_proc,15);
107: hr_utility.set_location('Leaving '||l_proc,16);
108: return;
109: --
110: end if;

Line 107: hr_utility.set_location('Leaving '||l_proc,16);

103: --
104: if p_parameters.count = 0 then
105: --
106: hr_utility.set_location('Not a single parameter exists '||l_proc,15);
107: hr_utility.set_location('Leaving '||l_proc,16);
108: return;
109: --
110: end if;
111: --

Line 114: hr_utility.set_location('Start assigning values from param_list '||l_proc,25);

110: end if;
111: --
112: --get the attribute CONTEXT value from the parameter list.
113: --
114: hr_utility.set_location('Start assigning values from param_list '||l_proc,25);
115:
116: l_entity := wf_event.getvalueforparameter(
117: p_name => 'CONTEXT',
118: p_parameterlist => p_parameters);

Line 130: hr_utility.set_location('End assign Values from param_list '||l_proc,30);

126: p_parameterlist => p_parameters);
127:
128: l_start_date := FND_DATE.canonical_to_date(l_start_date_canonical);
129: l_end_date := FND_DATE.canonical_to_date(l_end_date_canonical);
130: hr_utility.set_location('End assign Values from param_list '||l_proc,30);
131: --
132: if l_entity = 'PERSON' then
133: --
134: hr_utility.set_location('Person Record '||l_proc,35);

Line 134: hr_utility.set_location('Person Record '||l_proc,35);

130: hr_utility.set_location('End assign Values from param_list '||l_proc,30);
131: --
132: if l_entity = 'PERSON' then
133: --
134: hr_utility.set_location('Person Record '||l_proc,35);
135: -- get attribute values of peson from parameter list.
136: --
137: l_person_id_canonical := wf_event.getvalueforparameter(
138: p_name => 'PERSONID',

Line 156: hr_utility.set_location('Before call to person routine '||l_proc,40);

152: open l_person_cur;
153: fetch l_person_cur into l_person_rec;
154: close l_person_cur;
155: --
156: hr_utility.set_location('Before call to person routine '||l_proc,40);
157: --
158: PER_HRWF_SYNCH.per_per_wf(p_rec => l_person_rec,
159: p_action => null);
160: hr_utility.set_location('After call to person routine '||l_proc,45);

Line 160: hr_utility.set_location('After call to person routine '||l_proc,45);

156: hr_utility.set_location('Before call to person routine '||l_proc,40);
157: --
158: PER_HRWF_SYNCH.per_per_wf(p_rec => l_person_rec,
159: p_action => null);
160: hr_utility.set_location('After call to person routine '||l_proc,45);
161: --
162: end if; -- l_entity = 'PERSON'
163: --
164: --

Line 167: hr_utility.set_location('Position Record '||l_proc,35);

163: --
164: --
165: if l_entity = 'POSITION' then
166: --
167: hr_utility.set_location('Position Record '||l_proc,35);
168: l_assignment_id_canonical := wf_event.getvalueforparameter(
169: p_name => 'ASSIGNMENTID',
170: p_parameterlist => p_parameters);
171: --

Line 179: hr_utility.set_location('Before call to Assignment routine '||l_proc,35);

175: --
176: open l_assignment_cur;
177: fetch l_assignment_cur into l_assignment_rec;
178: close l_assignment_cur;
179: hr_utility.set_location('Before call to Assignment routine '||l_proc,35);
180: --
181: --call the routine
182: --
183: PER_HRWF_SYNCH.per_asg_wf(p_rec => l_assignment_rec,

Line 185: hr_utility.set_location('After call to Assignment routine '||l_proc,35);

181: --call the routine
182: --
183: PER_HRWF_SYNCH.per_asg_wf(p_rec => l_assignment_rec,
184: p_action => null);
185: hr_utility.set_location('After call to Assignment routine '||l_proc,35);
186: --
187: end if; --l_entity = 'POSITION'
188: --
189: hr_utility.set_location('Leaving '||l_proc,10);

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

185: hr_utility.set_location('After call to Assignment routine '||l_proc,35);
186: --
187: end if; --l_entity = 'POSITION'
188: --
189: hr_utility.set_location('Leaving '||l_proc,10);
190: --
191: end call_back;
192: --
193: --

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

238: and rownum = 1; -- This extra WHERE condition is added as per the request of "tpapired"
239: --
240: Begin
241: --
242: hr_utility.set_location('Entering '||l_proc,10);
243: --
244: -- check for the current employee flag
245: -- if current employee flag <> 'Y' then
246: -- return

Line 260: hr_utility.set_location('Not a current employee '||l_proc,15);

256: /* if (nvl(p_rec.current_employee_flag,'N') <>'Y'
257: and
258: nvl(p_rec.current_npw_flag,'N') <>'Y') then
259: --
260: hr_utility.set_location('Not a current employee '||l_proc,15);
261: hr_utility.set_location('Leaving ... '||l_proc,15);
262: return;
263: --
264: end if;*/

Line 261: hr_utility.set_location('Leaving ... '||l_proc,15);

257: and
258: nvl(p_rec.current_npw_flag,'N') <>'Y') then
259: --
260: hr_utility.set_location('Not a current employee '||l_proc,15);
261: hr_utility.set_location('Leaving ... '||l_proc,15);
262: return;
263: --
264: end if;*/
265: --

Line 278: hr_utility.set_location('Delete Person '||l_proc,20);

274: -- Check if this is DELETE
275: --
276: if nvl(p_action,'NO_DELETE') = 'DELETE' then
277: --
278: hr_utility.set_location('Delete Person '||l_proc,20);
279: wf_event.addparametertolist(
280: p_name => 'DELETE',
281: p_value => 'TRUE',
282: p_parameterlist => l_parameters);

Line 320: hr_utility.set_location('Current Person '||l_proc,20);

316: -- If the transaction is in CURRENT time frame
317: --
318: if l_date_chk = 'CURRENT' then
319: --
320: hr_utility.set_location('Current Person '||l_proc,20);
321: -- call propagate user as of now
322: --
323: -- assign attributes and values(not null values only) to l_parameters.
324: --

Line 340: hr_utility.set_location('start add params',63);

336: end if;
337: --
338: close role_exists;
339: --
340: hr_utility.set_location('start add params',63);
341: wf_event.addparametertolist(
342: p_name => 'USER_NAME',
343: p_value => l_user_name,
344: p_parameterlist => l_parameters);

Line 417: hr_utility.set_location('end add params',64);

413: p_name => 'WFSYNCH_OVERWRITE',
414: p_value => 'TRUE',
415: p_parameterlist => l_parameters);
416: end if;
417: hr_utility.set_location('end add params',64);
418: --
419: -- NEW CODE END
420: --
421: wf_local_synch.propagate_role(

Line 431: hr_utility.set_location('After calling propagate_role ',65);

427: p_expiration_date => NULL);
428: -- Bug 4635241 Modified the call to wf_local_synch.propagate_role
429: -- by passing NULL as value for p_expiration_date
430: --
431: hr_utility.set_location('After calling propagate_role ',65);
432: end if; --l_date_chk = CURRENT
433: --
434: -- if this is a future dated transaction then defer calling propagate user
435: -- until the future date equals sysdate

Line 443: hr_utility.set_location('Future Person '||l_proc,50);

439: -- This is effective in the future date, Call_back routine must be called.
440: --
441: -- assign attributes and values for l_parameters.
442: --
443: hr_utility.set_location('Future Person '||l_proc,50);
444: --
445: wf_event.addparametertolist(
446: p_name => 'CONTEXT',
447: p_value => 'PERSON',

Line 464: hr_utility.set_location('Before calling call_me_later '||l_proc,50);

460: p_value => l_end_date_canonical,
461: p_parameterlist => l_parameters);
462:
463: --
464: hr_utility.set_location('Before calling call_me_later '||l_proc,50);
465: -- Call the routine wf_util.call_me_later ()
466: --
467: wf_util.call_me_later(p_callback => 'per_hrwf_synch.call_back',
468: p_when => trunc(p_rec.effective_start_date),

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

469: p_parameters => l_parameters);
470: --
471: end if;
472: --
473: hr_utility.set_location('Leaving '||l_proc,10);
474: --
475: end per_per_wf;
476: --
477: --

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

519: --
520: l_position_id := p_rec.position_id;
521: l_assignment_id := p_rec.assignment_id;
522: --
523: hr_utility.set_location('Entering '||l_proc,10);
524: --
525: -- check for the primary assignment flag=Y and assignmrnt type = E
526: -- if primary flag <> 'Y' then
527: -- return

Line 532: hr_utility.set_location('Assignment neither Primary nor type = E '||l_proc,15);

528: -- end if
529: --
530: if p_rec.assignment_type <> 'E' and p_rec.primary_flag <>'Y' then
531: --
532: hr_utility.set_location('Assignment neither Primary nor type = E '||l_proc,15);
533: hr_utility.set_location('Leaving '||l_proc,16);
534: return;
535: --
536: end if;

Line 533: hr_utility.set_location('Leaving '||l_proc,16);

529: --
530: if p_rec.assignment_type <> 'E' and p_rec.primary_flag <>'Y' then
531: --
532: hr_utility.set_location('Assignment neither Primary nor type = E '||l_proc,15);
533: hr_utility.set_location('Leaving '||l_proc,16);
534: return;
535: --
536: end if;
537: --

Line 542: hr_utility.set_location('Position id is null .. '||l_proc,20);

538: -- No need to process where position_id is null
539: --
540: if p_rec.position_id is null then
541: --
542: hr_utility.set_location('Position id is null .. '||l_proc,20);
543: hr_utility.set_location('Leaving .. '||l_proc,21);
544: return;
545: --
546: end if;

Line 543: hr_utility.set_location('Leaving .. '||l_proc,21);

539: --
540: if p_rec.position_id is null then
541: --
542: hr_utility.set_location('Position id is null .. '||l_proc,20);
543: hr_utility.set_location('Leaving .. '||l_proc,21);
544: return;
545: --
546: end if;
547: --

Line 551: hr_utility.set_location('Delete Assignment ',25);

547: --
548: -- Check if this is DELETE
549: --
550: if nvl(p_action,'NO_DELETE') = 'DELETE' then
551: hr_utility.set_location('Delete Assignment ',25);
552: --
553: WF_LOCAL_SYNCH.propagate_user_role(
554: p_user_orig_system => 'PER',
555: p_user_orig_system_id => p_rec.person_id,

Line 572: hr_utility.set_location('Current Assignment ',30);

568: -- If the transaction is in CURRENT time frame
569: --
570: if l_date_chk = 'CURRENT' then
571: --
572: hr_utility.set_location('Current Assignment ',30);
573: -- call propagate user as of now
574: --
575: -- we are not passing any attributes to propagate_user_role procedure....
576: open start_date;

Line 591: hr_utility.set_location('Before Calling propagate_user_role ',35);

587: l_end_date := p_rec.effective_end_date;
588: end if;
589: --
590: -- Call wf_local_synch.propogate_user_role()
591: hr_utility.set_location('Before Calling propagate_user_role ',35);
592: WF_LOCAL_SYNCH.propagate_user_role(
593: p_user_orig_system => 'PER',
594: p_user_orig_system_id => p_rec.person_id,
595: p_role_orig_system => 'POS',

Line 608: hr_utility.set_location('Future Assignment ',40);

604: --
605: --
606: if l_date_chk = 'FUTURE' then
607: --
608: hr_utility.set_location('Future Assignment ',40);
609: -- This is effective in the future date, Call_back routine must be called.
610: --
611: --
612: l_person_id_canonical := FND_NUMBER.number_to_canonical(p_rec.person_id);

Line 639: hr_utility.set_location('Calling WF routine call_me_later.... ',45);

635: p_parameterlist => l_parameters);
636:
637: -- Call the routine wf_util.call_me_later ()
638: --
639: hr_utility.set_location('Calling WF routine call_me_later.... ',45);
640: WF_UTIL.call_me_later(p_callback => 'PER_HRWF_SYNCH.call_back',
641: p_when => trunc(p_rec.effective_start_date),
642: p_parameters => l_parameters);
643: --

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

642: p_parameters => l_parameters);
643: --
644: end if;
645: --
646: hr_utility.set_location('Leaving '||l_proc,100);
647: --
648: end per_asg_wf;
649: --
650: --

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

673: and rownum = 1; -- This extra WHERE condition is added as per the request of "tpapired"
674: --
675: begin
676: --
677: hr_utility.set_location('Entering '||l_proc,10);
678: --
679: if p_action = 'TERMINATION' then
680: -- l_date := p_date;
681: l_date := p_date +(1-1/86400); -- bug 4773768

Line 682: hr_utility.set_location('Termination.. '||l_proc,20);

678: --
679: if p_action = 'TERMINATION' then
680: -- l_date := p_date;
681: l_date := p_date +(1-1/86400); -- bug 4773768
682: hr_utility.set_location('Termination.. '||l_proc,20);
683: else
684: hr_utility.set_location('Reverse Termination.. '||l_proc,20);
685: --set the end of time as ATD
686: l_date := to_date('31-12-4712', 'DD-MM-YYYY');

Line 684: hr_utility.set_location('Reverse Termination.. '||l_proc,20);

680: -- l_date := p_date;
681: l_date := p_date +(1-1/86400); -- bug 4773768
682: hr_utility.set_location('Termination.. '||l_proc,20);
683: else
684: hr_utility.set_location('Reverse Termination.. '||l_proc,20);
685: --set the end of time as ATD
686: l_date := to_date('31-12-4712', 'DD-MM-YYYY');
687: -- set the status a ACTIVE
688: wf_event.addparametertolist('orclIsEnabled','ACTIVE',l_parameters); -- 4133057

Line 708: hr_utility.set_location('Calling Propagate_role '||l_proc,30);

704: wf_event.addparametertolist('orclWFOrigSystemID',p_rec.person_id,l_parameters);
705: --l_user_name := 'PER:'||p_rec.person_id;
706: wf_event.addparametertolist('USER_NAME',l_user_name,l_parameters);
707: --
708: hr_utility.set_location('Calling Propagate_role '||l_proc,30);
709: wf_local_synch.propagate_role(
710: p_orig_system => 'PER',
711: p_orig_system_id => p_rec.person_id,
712: p_attributes => l_parameters,

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

712: p_attributes => l_parameters,
713: p_start_date => p_rec.date_start,
714: p_expiration_date => l_date);
715:
716: hr_utility.set_location('Leaving '||l_proc,40);
717: --
718: end per_pds_wf;
719: --
720: -- --------------------------------------------------------------------------