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.PQH_RLS_UPD dependencies on HR_UTILITY

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

57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
60: Begin
61: hr_utility.set_location('Entering:'||l_proc,5);
62: --
63: -- Increment the object version
64: p_rec.object_version_number :=p_rec.object_version_number + 1;
65: --

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

111: where role_id = p_rec.role_id;
112: --
113: --
114: --
115: hr_utility.set_location(' Leaving:'||l_proc,10);
116: --
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated

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

173: --
174: l_proc varchar2(72) := g_package||'pre_update';
175: --
176: Begin
177: hr_utility.set_location('Entering:'||l_proc,5);
178: --
179: hr_utility.set_location(' Leaving:'||l_proc,10);
180: End pre_update;
181: --

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

175: --
176: Begin
177: hr_utility.set_location('Entering:'||l_proc,5);
178: --
179: hr_utility.set_location(' Leaving:'||l_proc,10);
180: End pre_update;
181: --
182: -- ----------------------------------------------------------------------------
183: -- |-----------------------------< post_update >------------------------------|

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

223: l_expiration_date date := to_date('31/12/4712','DD/MM/RRRR');
224: l_proc varchar2(72) := g_package||'post_update';
225: --
226: Begin
227: hr_utility.set_location('Entering:'||l_proc,5);
228: begin
229: --
230: pqh_rls_rku.after_update
231: (p_effective_date => p_effective_date

Line 308: hr_utility.set_location('Role enabled'||l_proc,10);

304: ,p_information30_o => pqh_rls_shd.g_old_rec.information30
305: );
306: --
307: if ((nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'N' and p_rec.enable_flag = 'Y') or (nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y' and p_rec.enable_flag = 'Y')) then
308: hr_utility.set_location('Role enabled'||l_proc,10);
309: declare
310: l_user_name varchar2(50);
311: l_plist wf_parameter_list_t;
312: cursor c1 is

Line 324: hr_utility.set_location('building list '||l_proc, 12);

320: and ppei.PEI_INFORMATION5 = 'Y'
321: and ppei.person_id = usr.employee_id;
322:
323: begin
324: hr_utility.set_location('building list '||l_proc, 12);
325: hr_utility.set_location('expiration date'||to_char(l_expiration_date,'dd/mm/RRRR'), 13);
326: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
327: --WF_EVENT.AddParameterToList('DISPLAY_NAME',p_rec.role_name,l_plist);
328: WF_EVENT.AddParameterToList('DISPLAYNAME',p_rec.role_name,l_plist);

Line 325: hr_utility.set_location('expiration date'||to_char(l_expiration_date,'dd/mm/RRRR'), 13);

321: and ppei.person_id = usr.employee_id;
322:
323: begin
324: hr_utility.set_location('building list '||l_proc, 12);
325: hr_utility.set_location('expiration date'||to_char(l_expiration_date,'dd/mm/RRRR'), 13);
326: WF_EVENT.AddParameterToList('USER_NAME','PQH_ROLE:'|| p_rec.role_id, l_plist);
327: --WF_EVENT.AddParameterToList('DISPLAY_NAME',p_rec.role_name,l_plist);
328: WF_EVENT.AddParameterToList('DISPLAYNAME',p_rec.role_name,l_plist);
329: WF_EVENT.AddParameterToList('DESCRIPTION',p_rec.role_name,l_plist);

Line 341: hr_utility.set_location('calling sync role '||l_proc, 14);

337: then
338: WF_EVENT.AddParameterToList('UPDATEONLY','TRUE',l_plist);
339: end if;
340:
341: hr_utility.set_location('calling sync role '||l_proc, 14);
342: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PQH_ROLE',
343: p_orig_system_id => p_rec.role_id,
344: p_attributes => l_plist,
345: p_start_date => l_start_date,

Line 348: hr_utility.set_location('sync role done'||l_proc, 15);

344: p_attributes => l_plist,
345: p_start_date => l_start_date,
346: p_expiration_date => l_expiration_date);
347:
348: hr_utility.set_location('sync role done'||l_proc, 15);
349: for r1 in c1 loop
350: l_plist := null;
351: hr_utility.set_location('going persons loop '||l_proc, 17);
352: WF_EVENT.AddParameterToList('expirationdate',to_char(l_expiration_date,wf_engine.date_format), l_plist);

Line 351: hr_utility.set_location('going persons loop '||l_proc, 17);

347:
348: hr_utility.set_location('sync role done'||l_proc, 15);
349: for r1 in c1 loop
350: l_plist := null;
351: hr_utility.set_location('going persons loop '||l_proc, 17);
352: WF_EVENT.AddParameterToList('expirationdate',to_char(l_expiration_date,wf_engine.date_format), l_plist);
353: WF_EVENT.AddParameterToList('USER_NAME',r1.user_name,l_plist);
354: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
355: WF_EVENT.AddParameterToList('ExpirationDate',to_char(l_expiration_date,wf_engine.date_format),l_plist);

Line 358: hr_utility.set_location('calling sync user '||l_proc, 19);

354: WF_EVENT.AddParameterToList('orclIsEnabled','ACTIVE',l_plist);
355: WF_EVENT.AddParameterToList('ExpirationDate',to_char(l_expiration_date,wf_engine.date_format),l_plist);
356: WF_EVENT.AddParameterToList('StartDate',to_char(l_start_date,wf_engine.date_format),l_plist);
357: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
358: hr_utility.set_location('calling sync user '||l_proc, 19);
359: WF_LOCAL_SYNCH.propagate_user_role(p_user_orig_system => 'PER',
360: p_user_orig_system_id => r1.person_id,
361: p_role_orig_system => 'PQH_ROLE',
362: p_role_orig_system_id => p_rec.role_id,

Line 365: hr_utility.set_location('sync user done'||l_proc, 21);

361: p_role_orig_system => 'PQH_ROLE',
362: p_role_orig_system_id => p_rec.role_id,
363: p_start_date => l_start_date,
364: p_expiration_date => l_expiration_date);
365: hr_utility.set_location('sync user done'||l_proc, 21);
366: end loop;
367: end;
368: elsif nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y'
369: and p_rec.enable_flag = 'N' then

Line 370: hr_utility.set_location('role being disabled '||l_proc, 30);

366: end loop;
367: end;
368: elsif nvl(pqh_rls_shd.g_old_rec.enable_flag,'N') = 'Y'
369: and p_rec.enable_flag = 'N' then
370: hr_utility.set_location('role being disabled '||l_proc, 30);
371: declare
372: l_plist wf_parameter_list_t;
373: --
374: cursor c0 is

Line 382: hr_utility.set_location('building list'||l_proc, 32);

378: and ROLE_ORIG_SYSTEM_ID = p_rec.role_id;
379: --
380: begin
381: l_plist := null;
382: hr_utility.set_location('building list'||l_proc, 32);
383: wf_event.AddParameterToList( 'USER_NAME', 'PQH_ROLE:'|| p_rec.role_id, l_plist);
384: wf_event.AddParameterToList( 'DELETE', 'TRUE', l_plist);
385: wf_event.AddParameterToList( 'EXPIRATIONDATE', to_char(l_start_date,wf_engine.date_format), l_plist);
386: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);

Line 388: hr_utility.set_location('calling sync user '||l_proc, 34);

384: wf_event.AddParameterToList( 'DELETE', 'TRUE', l_plist);
385: wf_event.AddParameterToList( 'EXPIRATIONDATE', to_char(l_start_date,wf_engine.date_format), l_plist);
386: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
387: for r1 in c0 loop
388: hr_utility.set_location('calling sync user '||l_proc, 34);
389: -- setting the expiration date to today
390: WF_LOCAL_SYNCH.propagate_user_role(p_user_orig_system => 'PER',
391: p_user_orig_system_id => r1.user_orig_system_id,
392: p_role_orig_system => 'PQH_ROLE',

Line 395: hr_utility.set_location('sync user done'||l_proc, 36);

391: p_user_orig_system_id => r1.user_orig_system_id,
392: p_role_orig_system => 'PQH_ROLE',
393: p_role_orig_system_id => p_rec.role_id,
394: p_expiration_date => l_start_date);
395: hr_utility.set_location('sync user done'||l_proc, 36);
396: end loop;
397: l_plist := null;
398: wf_event.AddParameterToList('USER_NAME', 'PQH_ROLE:'|| p_rec.role_id, l_plist);
399: wf_event.AddParameterToList('EXPIRATIONDATE', to_char(p_effective_date,wf_engine.date_format), l_plist);

Line 402: hr_utility.set_location('calling sync role '||l_proc, 38);

398: wf_event.AddParameterToList('USER_NAME', 'PQH_ROLE:'|| p_rec.role_id, l_plist);
399: wf_event.AddParameterToList('EXPIRATIONDATE', to_char(p_effective_date,wf_engine.date_format), l_plist);
400: wf_event.AddParameterToList('DELETE', 'TRUE', l_plist);
401: WF_EVENT.AddParameterToList('RaiseErrorS','FALSE',l_plist);
402: hr_utility.set_location('calling sync role '||l_proc, 38);
403: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PQH_ROLE',
404: p_orig_system_id => p_rec.role_id,
405: p_attributes => l_plist,
406: p_expiration_date => p_effective_date);

Line 407: hr_utility.set_location('sync role done'||l_proc, 40);

403: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PQH_ROLE',
404: p_orig_system_id => p_rec.role_id,
405: p_attributes => l_plist,
406: p_expiration_date => p_effective_date);
407: hr_utility.set_location('sync role done'||l_proc, 40);
408: end;
409: end if;
410: end;
411: --

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

408: end;
409: end if;
410: end;
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 10);
413: End post_update;
414: --
415: --
416: -- ----------------------------------------------------------------------------

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

624: --
625: l_proc varchar2(72) := g_package||'upd';
626: --
627: Begin
628: hr_utility.set_location('Entering:'||l_proc,5);
629: --
630: -- We must lock the row which we need to update.
631: --
632: pqh_rls_shd.lck

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

713: l_rec pqh_rls_shd.g_rec_type;
714: l_proc varchar2(72) := g_package||'upd';
715: --
716: Begin
717: hr_utility.set_location('Entering:'||l_proc,5);
718: --
719: -- Call conversion function to turn arguments into the
720: -- l_rec structure.
721: --

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

771: ,l_rec
772: );
773: p_object_version_number := l_rec.object_version_number;
774: --
775: hr_utility.set_location(' Leaving:'||l_proc,10);
776: End upd;
777: --
778: end pqh_rls_upd;