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.

[Home] [Help]

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 309: hr_utility.set_location('Role enabled'||l_proc,10);

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

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

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

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

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

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

333: WF_EVENT.AddParameterToList('orclWFOrigSystemID',p_rec.role_id,l_plist);
334: WF_EVENT.AddParameterToList('expirationdate', to_char(l_expiration_date,wf_engine.date_format),l_plist);
335: WF_EVENT.AddParameterToList('RAISEERRORS','FALSE',l_plist);
336:
337: hr_utility.set_location('calling sync role '||l_proc, 14);
338: WF_LOCAL_SYNCH.propagate_role(p_orig_system => 'PQH_ROLE',
339: p_orig_system_id => p_rec.role_id,
340: p_attributes => l_plist,
341: p_start_date => l_start_date,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

404: end;
405: end if;
406: end;
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 10);
409: End post_update;
410: --
411: --
412: -- ----------------------------------------------------------------------------

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

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

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

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

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

767: ,l_rec
768: );
769: p_object_version_number := l_rec.object_version_number;
770: --
771: hr_utility.set_location(' Leaving:'||l_proc,10);
772: End upd;
773: --
774: end pqh_rls_upd;