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

Line 72: hr_utility.set_location('Entering Get_BG_ID:',10);

68: -- If the enable security groups profile is set to Y then retrieve
69: -- the business group by scanning the per_business_group view with
70: -- the supplied security_group_id
71: --
72: hr_utility.set_location('Entering Get_BG_ID:',10);
73: --fnd_log.string(1,'HR','Entering Get_BG_ID:'||'10');
74:
75:
76: BEGIN

Line 82: hr_utility.set_location('l_business_group_id: '||l_business_group_id,20);

78: INTO l_business_group_id
79: FROM per_business_groups
80: WHERE security_group_id = to_char(p_security_group_id);
81:
82: hr_utility.set_location('l_business_group_id: '||l_business_group_id,20);
83: --fnd_log.string(1,'HR','l_business_group_id: '||l_business_group_id);
84:
85: EXCEPTION
86: WHEN no_data_found THEN

Line 88: hr_utility.set_location('not found l_business_group_id: '||l_business_group_id,30);

84:
85: EXCEPTION
86: WHEN no_data_found THEN
87:
88: hr_utility.set_location('not found l_business_group_id: '||l_business_group_id,30);
89: --fnd_log.string(1,'HR','not found l_business_group_id: '||l_business_group_id);
90:
91: l_business_group_id := NULL;
92: END;

Line 108: hr_utility.set_location('Leaving Get_BG_ID:',100);

104: l_business_group_id := hr_multi_tenancy_pkg.get_bus_grp_from_sec_grp
105: (p_security_group_id => p_security_group_id);
106: END IF;
107: --
108: hr_utility.set_location('Leaving Get_BG_ID:',100);
109: --fnd_log.string(1,'HR','Leaving Get_BG_ID:'||' 100');
110: RETURN l_business_group_id;
111: --
112: END Get_BG_ID;

Line 151: hr_utility.set_location('Entering Check_Business_Group_Lockout:',10);

147: l_exists VARCHAR2(1);
148: l_lockout_exception EXCEPTION;
149: --
150: BEGIN
151: hr_utility.set_location('Entering Check_Business_Group_Lockout:',10);
152: --fnd_log.string(1,'HR','Entering Check_Business_Group_Lockout:'||' 10');
153: --
154: --
155: -- Get the value for the data migratior business group lockout

Line 160: hr_utility.set_location('l_bg_lockout: '||l_bg_lockout,20);

156: -- profile
157: --
158: l_bg_lockout :=
159: TO_NUMBER(fnd_profile.value('HR_DM_BG_LOCKOUT'));
160: hr_utility.set_location('l_bg_lockout: '||l_bg_lockout,20);
161: -- fnd_log.string(1,'HR','l_bg_lockout: '||l_bg_lockout);
162: --
163: -- If the profile has been set (ie. a migration is in progress)
164: -- then do some checking

Line 191: hr_utility.set_location('BG locked: ',30);

187: fnd_profile.put
188: (name => 'PER_BUSINESS_GROUP_ID'
189: ,val => NULL
190: );
191: hr_utility.set_location('BG locked: ',30);
192: -- fnd_log.string(1,'HR','BG locked: '||'30');
193: --
194: -- Now raise an exception to break out of this procedure
195: --

Line 214: hr_utility.set_location('BG Unlocked: ',40);

210: fnd_profile.put
211: (name => 'PER_BUSINESS_GROUP_ID'
212: ,val => NULL
213: );
214: hr_utility.set_location('BG Unlocked: ',40);
215: --fnd_log.string(1,'HR','BG Unlocked: '||'40');
216: --
217: -- Now raise an exception to break out of this procedure
218: --

Line 224: hr_utility.set_location('Leaving Check_Business_Group_Lockout:',100);

220: END IF;
221: END IF;
222: END IF;
223: --
224: hr_utility.set_location('Leaving Check_Business_Group_Lockout:',100);
225: --fnd_log.string(1,'HR','Leaving Check_Business_Group_Lockout:'||' 100');
226: EXCEPTION
227: WHEN OTHERS THEN
228: hr_utility.set_location('Leaving with error'||sqlerrm||sqlcode,101);

Line 228: hr_utility.set_location('Leaving with error'||sqlerrm||sqlcode,101);

224: hr_utility.set_location('Leaving Check_Business_Group_Lockout:',100);
225: --fnd_log.string(1,'HR','Leaving Check_Business_Group_Lockout:'||' 100');
226: EXCEPTION
227: WHEN OTHERS THEN
228: hr_utility.set_location('Leaving with error'||sqlerrm||sqlcode,101);
229: -- fnd_log.string(1,'HR','Leaving with error'||sqlerrm||sqlcode);
230: RAISE;
231: END Check_Business_Group_Lockout;
232: --

Line 285: hr_utility.set_location('Entering Get_SP_ID:',10);

281: --
282: l_security_profile_id NUMBER DEFAULT NULL;
283: --
284: BEGIN
285: hr_utility.set_location('Entering Get_SP_ID:',10);
286: --fnd_log.string(1,'HR','Entering Get_SP_ID:'||' 10');
287: --
288: -- First of all try and get the security_profile_id by scanning
289: -- for active security profile assignments

Line 300: hr_utility.set_location('l_security_profile_id: '||l_security_profile_id,20);

296: --
297: l_security_profile_id := NULL;
298: --
299: END IF;
300: hr_utility.set_location('l_security_profile_id: '||l_security_profile_id,20);
301: --fnd_log.string(1,'HR','l_security_profile_id: '||l_security_profile_id);
302: --
303: CLOSE c_get_sp_assignment;
304: --

Line 306: hr_utility.set_location('l_security_profile_id: '||l_security_profile_id,30);

302: --
303: CLOSE c_get_sp_assignment;
304: --
305: IF l_security_profile_id IS NOT NULL THEN
306: hr_utility.set_location('l_security_profile_id: '||l_security_profile_id,30);
307: --fnd_log.string(1,'HR','l_security_profile_id: '||l_security_profile_id);
308: hr_utility.set_location('Leaving: ',80);
309: --fnd_log.string(1,'HR','Leaving: 80');
310: RETURN l_security_profile_id;

Line 308: hr_utility.set_location('Leaving: ',80);

304: --
305: IF l_security_profile_id IS NOT NULL THEN
306: hr_utility.set_location('l_security_profile_id: '||l_security_profile_id,30);
307: --fnd_log.string(1,'HR','l_security_profile_id: '||l_security_profile_id);
308: hr_utility.set_location('Leaving: ',80);
309: --fnd_log.string(1,'HR','Leaving: 80');
310: RETURN l_security_profile_id;
311: END IF;
312: --

Line 325: hr_utility.set_location('l_security_profile_id: '||l_security_profile_id,90);

321: --
322: l_security_profile_id := NULL;
323: --
324: END IF;
325: hr_utility.set_location('l_security_profile_id: '||l_security_profile_id,90);
326: -- fnd_log.string(1,'HR','l_security_profile_id: '||l_security_profile_id);
327: --
328: CLOSE c_get_implicit_sp;
329: --

Line 330: hr_utility.set_location('Leaving Get_SP_ID: ',100);

326: -- fnd_log.string(1,'HR','l_security_profile_id: '||l_security_profile_id);
327: --
328: CLOSE c_get_implicit_sp;
329: --
330: hr_utility.set_location('Leaving Get_SP_ID: ',100);
331: --fnd_log.string(1,'HR','Leaving Get_SP_ID:'||'100');
332: RETURN l_security_profile_id;
333: --
334: END Get_SP_ID;

Line 355: hr_utility.set_location('Entering Set_Profile_Values:',10);

351: )
352: IS
353: --
354: BEGIN
355: hr_utility.set_location('Entering Set_Profile_Values:',10);
356: -- fnd_log.string(1,'HR','Entering Set_Profile_Values:'||' 10');
357: --
358: fnd_profile.put(name => 'PER_SECURITY_PROFILE_ID'
359: ,val => p_security_profile_id

Line 365: hr_utility.set_location('Leaving Set_Profile_Values:',100);

361: fnd_profile.put(name => 'PER_BUSINESS_GROUP_ID'
362: ,val => p_business_group_id
363: );
364: --
365: hr_utility.set_location('Leaving Set_Profile_Values:',100);
366: --fnd_log.string(1,'HR','Leaving Set_Profile_Values:'||' 100');
367: END Set_Profile_Values;
368: --
369: -----------------------------------------------------------------------

Line 399: hr_utility.set_location('Entering Security_Groups_Enabled:',10);

395: AND security_group_id = '0';
396: --
397: BEGIN
398: --
399: hr_utility.set_location('Entering Security_Groups_Enabled:',10);
400: -- fnd_log.string(1,'HR','Entering Security_Groups_Enabled:'||'10');
401: -- check if the enable_security_groups profile is set to 'Y'
402: IF fnd_profile.value('ENABLE_SECURITY_GROUPS') = 'Y' THEN
403: -- profile is enabled... make sure that the enable security groups

Line 410: hr_utility.set_location('Security_Groups_Enabled:',20);

406: --
407: -- to tell if the concurrent process has been run we can just look
408: -- for any business groups other than the setup business group that
409: -- have a security group ID of 0.
410: hr_utility.set_location('Security_Groups_Enabled:',20);
411: --fnd_log.string(1,'HR','Security_Groups_Enabled:'||'20');
412: OPEN c_check_sec_process_run;
413: --
414: FETCH c_check_sec_process_run INTO l_dummy;

Line 418: hr_utility.set_location('l_dummy: '||l_dummy,30);

414: FETCH c_check_sec_process_run INTO l_dummy;
415: --
416: IF c_check_sec_process_run%NOTFOUND THEN
417: --
418: hr_utility.set_location('l_dummy: '||l_dummy,30);
419: --fnd_log.string(1,'HR','l_dummy: '||l_dummy);
420: CLOSE c_check_sec_process_run;
421: hr_utility.set_location('Leaving Security_Groups_Enabled: ',80);
422: --fnd_log.string(1,'HR','Leaving Security_Groups_Enabled: 80');

Line 421: hr_utility.set_location('Leaving Security_Groups_Enabled: ',80);

417: --
418: hr_utility.set_location('l_dummy: '||l_dummy,30);
419: --fnd_log.string(1,'HR','l_dummy: '||l_dummy);
420: CLOSE c_check_sec_process_run;
421: hr_utility.set_location('Leaving Security_Groups_Enabled: ',80);
422: --fnd_log.string(1,'HR','Leaving Security_Groups_Enabled: 80');
423: RETURN 'Y';
424: --
425: ELSE

Line 427: hr_utility.set_location('l_dummy'||l_dummy,85);

423: RETURN 'Y';
424: --
425: ELSE
426: --
427: hr_utility.set_location('l_dummy'||l_dummy,85);
428: -- fnd_log.string(1,'HR','l_dummy'||l_dummy);
429: CLOSE c_check_sec_process_run;
430: hr_utility.set_location('Leaving Security_Groups_Enabled:',90);
431: --fnd_log.string(1,'HR','Leaving Security_Groups_Enabled: 90');

Line 430: hr_utility.set_location('Leaving Security_Groups_Enabled:',90);

426: --
427: hr_utility.set_location('l_dummy'||l_dummy,85);
428: -- fnd_log.string(1,'HR','l_dummy'||l_dummy);
429: CLOSE c_check_sec_process_run;
430: hr_utility.set_location('Leaving Security_Groups_Enabled:',90);
431: --fnd_log.string(1,'HR','Leaving Security_Groups_Enabled: 90');
432: RETURN 'N';
433: --
434: END IF;

Line 437: hr_utility.set_location('Leaving Security_Groups_Enabled: ',100);

433: --
434: END IF;
435: ELSE
436: -- profile is not enabled, so return false
437: hr_utility.set_location('Leaving Security_Groups_Enabled: ',100);
438: --fnd_log.string(1,'HR','Leaving Security_Groups_Enabled: '||'100');
439: RETURN 'N';
440: END IF;
441: --

Line 484: hr_utility.set_location('Entering Get_Security_Profile_ID:',10);

480: fnd_log.string(1,'HR','p_user_id:'||p_user_id);
481: fnd_log.string(1,'HR','p_responsibility_id:'||p_responsibility_id);
482: fnd_log.string(1,'HR','p_application_id:'||p_application_id);
483: fnd_log.string(1,'HR','p_security_group_id:'||p_security_group_id);*/
484: hr_utility.set_location('Entering Get_Security_Profile_ID:',10);
485: hr_utility.set_location('p_user_id:'||p_user_id,20);
486: hr_utility.set_location('p_responsibility_id:'||p_responsibility_id,30);
487: hr_utility.set_location('p_application_id:'||p_application_id,40);
488: hr_utility.set_location('p_security_group_id:'||p_security_group_id,50);

Line 485: hr_utility.set_location('p_user_id:'||p_user_id,20);

481: fnd_log.string(1,'HR','p_responsibility_id:'||p_responsibility_id);
482: fnd_log.string(1,'HR','p_application_id:'||p_application_id);
483: fnd_log.string(1,'HR','p_security_group_id:'||p_security_group_id);*/
484: hr_utility.set_location('Entering Get_Security_Profile_ID:',10);
485: hr_utility.set_location('p_user_id:'||p_user_id,20);
486: hr_utility.set_location('p_responsibility_id:'||p_responsibility_id,30);
487: hr_utility.set_location('p_application_id:'||p_application_id,40);
488: hr_utility.set_location('p_security_group_id:'||p_security_group_id,50);
489:

Line 486: hr_utility.set_location('p_responsibility_id:'||p_responsibility_id,30);

482: fnd_log.string(1,'HR','p_application_id:'||p_application_id);
483: fnd_log.string(1,'HR','p_security_group_id:'||p_security_group_id);*/
484: hr_utility.set_location('Entering Get_Security_Profile_ID:',10);
485: hr_utility.set_location('p_user_id:'||p_user_id,20);
486: hr_utility.set_location('p_responsibility_id:'||p_responsibility_id,30);
487: hr_utility.set_location('p_application_id:'||p_application_id,40);
488: hr_utility.set_location('p_security_group_id:'||p_security_group_id,50);
489:
490:

Line 487: hr_utility.set_location('p_application_id:'||p_application_id,40);

483: fnd_log.string(1,'HR','p_security_group_id:'||p_security_group_id);*/
484: hr_utility.set_location('Entering Get_Security_Profile_ID:',10);
485: hr_utility.set_location('p_user_id:'||p_user_id,20);
486: hr_utility.set_location('p_responsibility_id:'||p_responsibility_id,30);
487: hr_utility.set_location('p_application_id:'||p_application_id,40);
488: hr_utility.set_location('p_security_group_id:'||p_security_group_id,50);
489:
490:
491: --

Line 488: hr_utility.set_location('p_security_group_id:'||p_security_group_id,50);

484: hr_utility.set_location('Entering Get_Security_Profile_ID:',10);
485: hr_utility.set_location('p_user_id:'||p_user_id,20);
486: hr_utility.set_location('p_responsibility_id:'||p_responsibility_id,30);
487: hr_utility.set_location('p_application_id:'||p_application_id,40);
488: hr_utility.set_location('p_security_group_id:'||p_security_group_id,50);
489:
490:
491: --
492: -- Retrieve the value for the ENABLE_SECURITY_GROUPS profile option.

Line 515: hr_utility.set_location('l_business_group_id: '||l_business_group_id,60);

511: ,p_responsibility_id => p_responsibility_id
512: ,p_resp_app_id => p_application_id
513: );
514: --
515: hr_utility.set_location('l_business_group_id: '||l_business_group_id,60);
516: -- fnd_log.string(1,'HR','l_business_group_id: '||l_business_group_id);
517:
518: IF l_business_group_id IS NOT NULL THEN
519: --

Line 532: hr_utility.set_location('Business group id not null',30);

528:
529: /*fnd_log.string(1,'HR','Business group id not null'||'30');
530:
531: fnd_log.string(1,'HR','before lockout:'||'30');*/
532: hr_utility.set_location('Business group id not null',30);
533: hr_utility.set_location('before lockout:',30);
534:
535: Check_Business_Group_Lockout
536: (p_business_group_id => l_business_group_id

Line 533: hr_utility.set_location('before lockout:',30);

529: /*fnd_log.string(1,'HR','Business group id not null'||'30');
530:
531: fnd_log.string(1,'HR','before lockout:'||'30');*/
532: hr_utility.set_location('Business group id not null',30);
533: hr_utility.set_location('before lockout:',30);
534:
535: Check_Business_Group_Lockout
536: (p_business_group_id => l_business_group_id
537: ,p_security_group_id => p_security_group_id

Line 540: hr_utility.set_location('after lockout:',40);

536: (p_business_group_id => l_business_group_id
537: ,p_security_group_id => p_security_group_id
538: ,p_sg_enabled => TRUE
539: );
540: hr_utility.set_location('after lockout:',40);
541: --fnd_log.string(1,'HR','after lockout:'||'40');
542: --
543: -- Get the security profile for the session.
544: -- Unlike in R11 we no longer determine the security profile for a

Line 559: hr_utility.set_location('l_security_profile_id: '||l_security_profile_id,40);

555: ,p_resp_app_id => p_application_id
556: ,p_business_group_id => l_business_group_id
557: ,p_security_group_id => p_security_group_id
558: );
559: hr_utility.set_location('l_security_profile_id: '||l_security_profile_id,40);
560: --fnd_log.string(1,'HR','l_security_profile_id: '||l_security_profile_id);
561: --
562: -- Store the retrieved values for the BG/SP profile options in the
563: -- server-side cache.

Line 569: hr_utility.set_location('security_profile_id: '|| fnd_profile.value('PER_SECURITY_PROFILE_ID'),50);

565: Set_Profile_Values
566: (p_business_group_id => l_business_group_id
567: ,p_security_profile_id => l_security_profile_id
568: );
569: hr_utility.set_location('security_profile_id: '|| fnd_profile.value('PER_SECURITY_PROFILE_ID'),50);
570: hr_utility.set_location('business_group_id: '||fnd_profile.value('PER_BUSINESS_GROUP_ID'),50);
571: /*fnd_log.string(1,'HR','security_profile_id: '|| fnd_profile.value('PER_SECURITY_PROFILE_ID'));
572: fnd_log.string(1,'HR','business_group_id: '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));*/
573: ELSE

Line 570: hr_utility.set_location('business_group_id: '||fnd_profile.value('PER_BUSINESS_GROUP_ID'),50);

566: (p_business_group_id => l_business_group_id
567: ,p_security_profile_id => l_security_profile_id
568: );
569: hr_utility.set_location('security_profile_id: '|| fnd_profile.value('PER_SECURITY_PROFILE_ID'),50);
570: hr_utility.set_location('business_group_id: '||fnd_profile.value('PER_BUSINESS_GROUP_ID'),50);
571: /*fnd_log.string(1,'HR','security_profile_id: '|| fnd_profile.value('PER_SECURITY_PROFILE_ID'));
572: fnd_log.string(1,'HR','business_group_id: '||fnd_profile.value('PER_BUSINESS_GROUP_ID'));*/
573: ELSE
574: --

Line 578: hr_utility.set_location('Business group id is null',60);

574: --
575: -- The site level defaults will be used for this session so
576: -- retrieve the value from the profile cache now..
577: --
578: hr_utility.set_location('Business group id is null',60);
579: --fnd_log.string(1,'HR','Business group id is null'||'40');
580: l_security_profile_id
581: := TO_NUMBER(fnd_profile.value('PER_SECURITY_PROFILE_ID'));
582: hr_utility.set_location('l_security_profile_id:'||l_security_profile_id,60);

Line 582: hr_utility.set_location('l_security_profile_id:'||l_security_profile_id,60);

578: hr_utility.set_location('Business group id is null',60);
579: --fnd_log.string(1,'HR','Business group id is null'||'40');
580: l_security_profile_id
581: := TO_NUMBER(fnd_profile.value('PER_SECURITY_PROFILE_ID'));
582: hr_utility.set_location('l_security_profile_id:'||l_security_profile_id,60);
583: -- fnd_log.string(1,'HR','l_security_profile_id:'||l_security_profile_id);
584: --
585: END IF;
586: ELSE

Line 588: hr_utility.set_location('before lockout: ',80);

584: --
585: END IF;
586: ELSE
587: BEGIN
588: hr_utility.set_location('before lockout: ',80);
589: -- fnd_log.string(1,'HR','before lockout: 80');
590: Check_Business_Group_Lockout
591: (p_business_group_id =>
592: TO_NUMBER(fnd_profile.value('PER_BUSINESS_GROUP_ID'))

Line 596: hr_utility.set_location('after lockout: ',85);

592: TO_NUMBER(fnd_profile.value('PER_BUSINESS_GROUP_ID'))
593: ,p_security_group_id => 0
594: ,p_sg_enabled => FALSE
595: );
596: hr_utility.set_location('after lockout: ',85);
597: -- fnd_log.string(1,'HR','after lockout: 85');
598: --
599: l_security_profile_id
600: := TO_NUMBER(fnd_profile.value('PER_SECURITY_PROFILE_ID'));

Line 601: hr_utility.set_location('l_security_profile_id: '||l_security_profile_id,90);

597: -- fnd_log.string(1,'HR','after lockout: 85');
598: --
599: l_security_profile_id
600: := TO_NUMBER(fnd_profile.value('PER_SECURITY_PROFILE_ID'));
601: hr_utility.set_location('l_security_profile_id: '||l_security_profile_id,90);
602: --fnd_log.string(1,'HR','l_security_profile_id: '||l_security_profile_id);
603: EXCEPTION
604: WHEN OTHERS THEN
605: NULL;

Line 608: hr_utility.set_location('Leaving Get_Security_Profile_ID:',100);

604: WHEN OTHERS THEN
605: NULL;
606: END;
607: END IF;
608: hr_utility.set_location('Leaving Get_Security_Profile_ID:',100);
609:
610: --fnd_log.string(1,'HR','Leaving Get_Security_Profile_ID:'||' 100');
611: RETURN l_security_profile_id;
612: --

Line 625: hr_utility.set_location('Entering derive_legislation:',10);

621: l_leg_code varchar2(150);
622: l_business_group_id number(15);
623: --
624: BEGIN
625: hr_utility.set_location('Entering derive_legislation:',10);
626: -- fnd_log.string(1,'HR','Entering derive_legislation:'||' 10');
627: --
628: l_leg_code := hr_api.return_legislation_code(
629: fnd_profile.value('PER_BUSINESS_GROUP_ID'));

Line 632: hr_utility.set_location('l_leg_code: '||l_leg_code,20);

628: l_leg_code := hr_api.return_legislation_code(
629: fnd_profile.value('PER_BUSINESS_GROUP_ID'));
630: --
631: --
632: hr_utility.set_location('l_leg_code: '||l_leg_code,20);
633: --fnd_log.string(1,'HR','l_leg_code: '||l_leg_code);
634: hr_api.set_legislation_context(l_leg_code);
635: --
636: hr_utility.set_location('Leaving derive_legislation:',100);

Line 636: hr_utility.set_location('Leaving derive_legislation:',100);

632: hr_utility.set_location('l_leg_code: '||l_leg_code,20);
633: --fnd_log.string(1,'HR','l_leg_code: '||l_leg_code);
634: hr_api.set_legislation_context(l_leg_code);
635: --
636: hr_utility.set_location('Leaving derive_legislation:',100);
637: -- fnd_log.string(1,'HR','Leaving derive_legislation:'||' 100');
638: EXCEPTION
639: WHEN NO_DATA_FOUND THEN
640: null;

Line 672: hr_utility.set_location('Entering Initialize_HR_Security:',10);

668: l_security_profile_id NUMBER;
669: l_null_row per_security_profiles%rowtype;
670: --
671: BEGIN
672: hr_utility.set_location('Entering Initialize_HR_Security:',10);
673: -- fnd_log.string(1,'HR','Entering Initialize_HR_Security:'||'10');
674: --
675: -- 2876315
676: --

Line 678: hr_utility.set_location('session_context: '||session_context,20);

674: --
675: -- 2876315
676: --
677: session_context := fnd_global.session_context ;
678: hr_utility.set_location('session_context: '||session_context,20);
679: -- fnd_log.string(1,'HR','session_context: '||session_context);
680:
681: -- HR Multi Tenancy Addition:- Bug 7501793
682: if hr_multi_tenancy_pkg.is_multi_tenant_system then

Line 701: hr_utility.set_location('fnd_global.user_id: '||fnd_global.user_id,30);

697: /* fnd_log.string(1,'HR','fnd_global.user_id: '||fnd_global.user_id);
698: fnd_log.string(1,'HR','fnd_global.resp_id: '||fnd_global.resp_id);
699: fnd_log.string(1,'HR','fnd_global.resp_appl_id: '||fnd_global.resp_appl_id);
700: fnd_log.string(1,'HR','fnd_global.security_group_id: '||fnd_global.security_group_id);*/
701: hr_utility.set_location('fnd_global.user_id: '||fnd_global.user_id,30);
702: hr_utility.set_location('fnd_global.resp_id: '||fnd_global.resp_id,30);
703: hr_utility.set_location('fnd_global.resp_appl_id: '||fnd_global.resp_appl_id,30);
704: hr_utility.set_location('fnd_global.security_group_id: '||fnd_global.security_group_id,30);
705:

Line 702: hr_utility.set_location('fnd_global.resp_id: '||fnd_global.resp_id,30);

698: fnd_log.string(1,'HR','fnd_global.resp_id: '||fnd_global.resp_id);
699: fnd_log.string(1,'HR','fnd_global.resp_appl_id: '||fnd_global.resp_appl_id);
700: fnd_log.string(1,'HR','fnd_global.security_group_id: '||fnd_global.security_group_id);*/
701: hr_utility.set_location('fnd_global.user_id: '||fnd_global.user_id,30);
702: hr_utility.set_location('fnd_global.resp_id: '||fnd_global.resp_id,30);
703: hr_utility.set_location('fnd_global.resp_appl_id: '||fnd_global.resp_appl_id,30);
704: hr_utility.set_location('fnd_global.security_group_id: '||fnd_global.security_group_id,30);
705:
706: l_security_profile_id :=

Line 703: hr_utility.set_location('fnd_global.resp_appl_id: '||fnd_global.resp_appl_id,30);

699: fnd_log.string(1,'HR','fnd_global.resp_appl_id: '||fnd_global.resp_appl_id);
700: fnd_log.string(1,'HR','fnd_global.security_group_id: '||fnd_global.security_group_id);*/
701: hr_utility.set_location('fnd_global.user_id: '||fnd_global.user_id,30);
702: hr_utility.set_location('fnd_global.resp_id: '||fnd_global.resp_id,30);
703: hr_utility.set_location('fnd_global.resp_appl_id: '||fnd_global.resp_appl_id,30);
704: hr_utility.set_location('fnd_global.security_group_id: '||fnd_global.security_group_id,30);
705:
706: l_security_profile_id :=
707: Get_Security_Profile_ID

Line 704: hr_utility.set_location('fnd_global.security_group_id: '||fnd_global.security_group_id,30);

700: fnd_log.string(1,'HR','fnd_global.security_group_id: '||fnd_global.security_group_id);*/
701: hr_utility.set_location('fnd_global.user_id: '||fnd_global.user_id,30);
702: hr_utility.set_location('fnd_global.resp_id: '||fnd_global.resp_id,30);
703: hr_utility.set_location('fnd_global.resp_appl_id: '||fnd_global.resp_appl_id,30);
704: hr_utility.set_location('fnd_global.security_group_id: '||fnd_global.security_group_id,30);
705:
706: l_security_profile_id :=
707: Get_Security_Profile_ID
708: (fnd_global.user_id

Line 713: hr_utility.set_location('l_security_profile_id: '||l_security_profile_id,40);

709: ,fnd_global.resp_id
710: ,fnd_global.resp_appl_id
711: ,fnd_global.security_group_id
712: );
713: hr_utility.set_location('l_security_profile_id: '||l_security_profile_id,40);
714: --fnd_log.string(1,'HR','l_security_profile_id: '||l_security_profile_id);
715: --
716: -- If a security profile was found/returned then populate the package
717: -- level global variable with the appropriate row for the ID

Line 746: hr_utility.set_location('Leaving Initialize_HR_Security: ',100);

742: -- and call hr_api to setup the application context
743: -- HR_ESSION_DATA namespace LEG_CODE with the session's legislation_code.
744: --
745: derive_legislation;
746: hr_utility.set_location('Leaving Initialize_HR_Security: ',100);
747: --fnd_log.string(1,'HR','Leaving Initialize_HR_Security: '||'100');
748:
749: EXCEPTION
750: WHEN OTHERS THEN

Line 751: hr_utility.set_location('Leaving with error '||sqlcode||sqlerrm,110);

747: --fnd_log.string(1,'HR','Leaving Initialize_HR_Security: '||'100');
748:
749: EXCEPTION
750: WHEN OTHERS THEN
751: hr_utility.set_location('Leaving with error '||sqlcode||sqlerrm,110);
752: -- fnd_log.string(1,'HR','Leaving with error '||sqlcode||sqlerrm);
753: generic_error('HR_SIGNON.INITIALIZE_HR_SECURITY', sqlcode, sqlerrm);
754: END Initialize_HR_Security;
755: --