DBA Data[Home] [Help]

APPS.PER_SEC_PROFILE_ASG_SWI dependencies on HR_UTILITY

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

31: --
32: -- Other variables
33: l_proc varchar2(72) := g_package ||'create_security_profile_asg';
34: Begin
35: hr_utility.set_location(' Entering:' || l_proc,10);
36: --
37: -- Issue a savepoint
38: --
39: savepoint create_sec_prf_asg_swi;

Line 45: hr_utility.trace(' user id ' || p_user_id );

41: -- Initialise Multiple Message Detection
42: --
43: hr_multi_message.enable_message_list;
44:
45: hr_utility.trace(' user id ' || p_user_id );
46: hr_utility.trace(' Sec Grp Id ' || p_security_group_id);
47: hr_utility.trace(' Sec Prf Id ' || p_security_profile_id);
48: hr_utility.trace(' Resp Id ' || p_responsibility_id);
49: hr_utility.trace(' Resp Appl Id ' || p_responsibility_application_i);

Line 46: hr_utility.trace(' Sec Grp Id ' || p_security_group_id);

42: --
43: hr_multi_message.enable_message_list;
44:
45: hr_utility.trace(' user id ' || p_user_id );
46: hr_utility.trace(' Sec Grp Id ' || p_security_group_id);
47: hr_utility.trace(' Sec Prf Id ' || p_security_profile_id);
48: hr_utility.trace(' Resp Id ' || p_responsibility_id);
49: hr_utility.trace(' Resp Appl Id ' || p_responsibility_application_i);
50: hr_utility.trace(' Business Group Id ' || p_business_group_id);

Line 47: hr_utility.trace(' Sec Prf Id ' || p_security_profile_id);

43: hr_multi_message.enable_message_list;
44:
45: hr_utility.trace(' user id ' || p_user_id );
46: hr_utility.trace(' Sec Grp Id ' || p_security_group_id);
47: hr_utility.trace(' Sec Prf Id ' || p_security_profile_id);
48: hr_utility.trace(' Resp Id ' || p_responsibility_id);
49: hr_utility.trace(' Resp Appl Id ' || p_responsibility_application_i);
50: hr_utility.trace(' Business Group Id ' || p_business_group_id);
51: --

Line 48: hr_utility.trace(' Resp Id ' || p_responsibility_id);

44:
45: hr_utility.trace(' user id ' || p_user_id );
46: hr_utility.trace(' Sec Grp Id ' || p_security_group_id);
47: hr_utility.trace(' Sec Prf Id ' || p_security_profile_id);
48: hr_utility.trace(' Resp Id ' || p_responsibility_id);
49: hr_utility.trace(' Resp Appl Id ' || p_responsibility_application_i);
50: hr_utility.trace(' Business Group Id ' || p_business_group_id);
51: --
52: -- Remember IN OUT parameter IN values

Line 49: hr_utility.trace(' Resp Appl Id ' || p_responsibility_application_i);

45: hr_utility.trace(' user id ' || p_user_id );
46: hr_utility.trace(' Sec Grp Id ' || p_security_group_id);
47: hr_utility.trace(' Sec Prf Id ' || p_security_profile_id);
48: hr_utility.trace(' Resp Id ' || p_responsibility_id);
49: hr_utility.trace(' Resp Appl Id ' || p_responsibility_application_i);
50: hr_utility.trace(' Business Group Id ' || p_business_group_id);
51: --
52: -- Remember IN OUT parameter IN values
53: --

Line 50: hr_utility.trace(' Business Group Id ' || p_business_group_id);

46: hr_utility.trace(' Sec Grp Id ' || p_security_group_id);
47: hr_utility.trace(' Sec Prf Id ' || p_security_profile_id);
48: hr_utility.trace(' Resp Id ' || p_responsibility_id);
49: hr_utility.trace(' Resp Appl Id ' || p_responsibility_application_i);
50: hr_utility.trace(' Business Group Id ' || p_business_group_id);
51: --
52: -- Remember IN OUT parameter IN values
53: --
54: --

Line 87: hr_utility.trace(' user id ' || p_user_id );

83: );
84: --
85: -- Convert API warning boolean parameter values to specific
86: -- messages and add them to Multiple Message List
87: hr_utility.trace(' user id ' || p_user_id );
88: hr_utility.trace(' Sec Grp Id ' || p_security_group_id);
89: hr_utility.trace(' Sec Prf Id ' || p_security_profile_id);
90: hr_utility.trace(' Resp Id ' || p_responsibility_id);
91: hr_utility.trace(' Resp Appl Id ' || p_responsibility_application_i);

Line 88: hr_utility.trace(' Sec Grp Id ' || p_security_group_id);

84: --
85: -- Convert API warning boolean parameter values to specific
86: -- messages and add them to Multiple Message List
87: hr_utility.trace(' user id ' || p_user_id );
88: hr_utility.trace(' Sec Grp Id ' || p_security_group_id);
89: hr_utility.trace(' Sec Prf Id ' || p_security_profile_id);
90: hr_utility.trace(' Resp Id ' || p_responsibility_id);
91: hr_utility.trace(' Resp Appl Id ' || p_responsibility_application_i);
92:

Line 89: hr_utility.trace(' Sec Prf Id ' || p_security_profile_id);

85: -- Convert API warning boolean parameter values to specific
86: -- messages and add them to Multiple Message List
87: hr_utility.trace(' user id ' || p_user_id );
88: hr_utility.trace(' Sec Grp Id ' || p_security_group_id);
89: hr_utility.trace(' Sec Prf Id ' || p_security_profile_id);
90: hr_utility.trace(' Resp Id ' || p_responsibility_id);
91: hr_utility.trace(' Resp Appl Id ' || p_responsibility_application_i);
92:
93: --

Line 90: hr_utility.trace(' Resp Id ' || p_responsibility_id);

86: -- messages and add them to Multiple Message List
87: hr_utility.trace(' user id ' || p_user_id );
88: hr_utility.trace(' Sec Grp Id ' || p_security_group_id);
89: hr_utility.trace(' Sec Prf Id ' || p_security_profile_id);
90: hr_utility.trace(' Resp Id ' || p_responsibility_id);
91: hr_utility.trace(' Resp Appl Id ' || p_responsibility_application_i);
92:
93: --
94: --

Line 91: hr_utility.trace(' Resp Appl Id ' || p_responsibility_application_i);

87: hr_utility.trace(' user id ' || p_user_id );
88: hr_utility.trace(' Sec Grp Id ' || p_security_group_id);
89: hr_utility.trace(' Sec Prf Id ' || p_security_profile_id);
90: hr_utility.trace(' Resp Id ' || p_responsibility_id);
91: hr_utility.trace(' Resp Appl Id ' || p_responsibility_application_i);
92:
93: --
94: --
95: -- Convert API non-warning boolean parameter values

Line 103: hr_utility.set_location(' Leaving:' || l_proc,20);

99: -- messages of any type exist in the Multiple Message List.
100: -- Also disable Multiple Message Detection.
101: --
102: p_return_status := hr_multi_message.get_return_status_disable;
103: hr_utility.set_location(' Leaving:' || l_proc,20);
104: --
105: exception
106: when hr_multi_message.error_message_exist then
107: --

Line 124: hr_utility.set_location(' Leaving:' || l_proc, 30);

120:
121: p_object_version_number := null;
122:
123: p_return_status := hr_multi_message.get_return_status_disable;
124: hr_utility.set_location(' Leaving:' || l_proc, 30);
125: when others then
126: --
127: -- When Multiple Message Detection is enabled catch
128: -- any Application specific or other unexpected

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

131: -- error.
132: --
133: rollback to create_sec_prf_asg_swi;
134: if hr_multi_message.unexpected_error_add(l_proc) then
135: hr_utility.set_location(' Leaving:' || l_proc,40);
136: raise;
137: end if;
138: --
139: -- Reset IN OUT and set OUT parameters

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

145:
146: p_object_version_number := null;
147:
148: p_return_status := hr_multi_message.get_return_status_disable;
149: hr_utility.set_location(' Leaving:' || l_proc,50);
150: end create_security_profile_asg;
151:
152:
153: -- ----------------------------------------------------------------------------

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

177: -- Other variables
178:
179: l_proc varchar2(72) := g_package ||'update_security_profile_asg';
180: Begin
181: hr_utility.set_location(' Entering:' || l_proc,10);
182: --
183: -- Issue a savepoint
184: --
185: savepoint update_sec_prf_asg_swi;

Line 245: hr_utility.set_location(' Leaving:' || l_proc,20);

241: -- messages of any type exist in the Multiple Message List.
242: -- Also disable Multiple Message Detection.
243: --
244: p_return_status := hr_multi_message.get_return_status_disable;
245: hr_utility.set_location(' Leaving:' || l_proc,20);
246: --
247: exception
248: when hr_multi_message.error_message_exist then
249: --

Line 264: hr_utility.set_location(' Leaving:' || l_proc, 30);

260:
261: p_object_version_number := l_object_version_number;
262:
263: p_return_status := hr_multi_message.get_return_status_disable;
264: hr_utility.set_location(' Leaving:' || l_proc, 30);
265: when others then
266: --
267: -- When Multiple Message Detection is enabled catch
268: -- any Application specific or other unexpected

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

271: -- error.
272: --
273: rollback to update_sec_prf_asg_swi;
274: if hr_multi_message.unexpected_error_add(l_proc) then
275: hr_utility.set_location(' Leaving:' || l_proc,40);
276: raise;
277: end if;
278: --
279: -- Reset IN OUT and set OUT parameters

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

283:
284: p_object_version_number := l_object_version_number;
285:
286: p_return_status := hr_multi_message.get_return_status_disable;
287: hr_utility.set_location(' Leaving:' || l_proc,50);
288: end update_security_profile_asg;
289:
290: end per_sec_profile_asg_swi;