DBA Data[Home] [Help]

APPS.OTA_PVT_FRM_THREAD_USERS_SWI dependencies on HR_UTILITY

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

29: --
30: -- Other variables
31: l_proc varchar2(72) := g_package ||'create_pvt_frm_thread_user';
32: Begin
33: hr_utility.set_location(' Entering:' || l_proc,10);
34: --
35: -- Issue a savepoint
36: --
37: savepoint create_pvt_frm_thread_user_swi;

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

78: -- messages of any type exist in the Multiple Message List.
79: -- Also disable Multiple Message Detection.
80: --
81: p_return_status := hr_multi_message.get_return_status_disable;
82: hr_utility.set_location(' Leaving:' || l_proc,20);
83: --
84: exception
85: when hr_multi_message.error_message_exist then
86: --

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

93: -- Reset IN OUT parameters and set OUT parameters
94: --
95: p_object_version_number := null;
96: p_return_status := hr_multi_message.get_return_status_disable;
97: hr_utility.set_location(' Leaving:' || l_proc, 30);
98: when others then
99: --
100: -- When Multiple Message Detection is enabled catch
101: -- any Application specific or other unexpected

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

104: -- error.
105: --
106: rollback to create_pvt_frm_thread_user_swi;
107: if hr_multi_message.unexpected_error_add(l_proc) then
108: hr_utility.set_location(' Leaving:' || l_proc,40);
109: raise;
110: end if;
111: --
112: -- Reset IN OUT and set OUT parameters

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

112: -- Reset IN OUT and set OUT parameters
113: --
114: p_object_version_number := null;
115: p_return_status := hr_multi_message.get_return_status_disable;
116: hr_utility.set_location(' Leaving:' || l_proc,50);
117: end create_pvt_frm_thread_user;
118: --
119: -- ----------------------------------------------------------------------------
120: -- |----------------------< update_pvt_frm_thread_user >----------------------|

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

140: --
141: -- Other variables
142: l_proc varchar2(72) := g_package ||'update_pvt_frm_thread_user';
143: Begin
144: hr_utility.set_location(' Entering:' || l_proc,10);
145: --
146: -- Issue a savepoint
147: --
148: savepoint update_pvt_frm_thread_user_swi;

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

188: -- messages of any type exist in the Multiple Message List.
189: -- Also disable Multiple Message Detection.
190: --
191: p_return_status := hr_multi_message.get_return_status_disable;
192: hr_utility.set_location(' Leaving:' || l_proc,20);
193: --
194: exception
195: when hr_multi_message.error_message_exist then
196: --

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

203: -- Reset IN OUT parameters and set OUT parameters
204: --
205: p_object_version_number := null;
206: p_return_status := hr_multi_message.get_return_status_disable;
207: hr_utility.set_location(' Leaving:' || l_proc, 30);
208: when others then
209: --
210: -- When Multiple Message Detection is enabled catch
211: -- any Application specific or other unexpected

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

214: -- error.
215: --
216: rollback to update_pvt_frm_thread_user_swi;
217: if hr_multi_message.unexpected_error_add(l_proc) then
218: hr_utility.set_location(' Leaving:' || l_proc,40);
219: raise;
220: end if;
221: --
222: -- Reset IN OUT and set OUT parameters

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

222: -- Reset IN OUT and set OUT parameters
223: --
224: p_object_version_number := null;
225: p_return_status := hr_multi_message.get_return_status_disable;
226: hr_utility.set_location(' Leaving:' || l_proc,50);
227: end update_pvt_frm_thread_user;
228: -- ----------------------------------------------------------------------------
229: -- |----------------------< delete_pvt_frm_thread_user >----------------------|
230: -- ----------------------------------------------------------------------------

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

245: --
246: -- Other variables
247: l_proc varchar2(72) := g_package ||'delete_pvt_frm_thread_user';
248: Begin
249: hr_utility.set_location(' Entering:' || l_proc,10);
250: --
251: -- Issue a savepoint
252: --
253: savepoint delete_pvt_frm_thread_user_swi;

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

290: -- messages of any type exist in the Multiple Message List.
291: -- Also disable Multiple Message Detection.
292: --
293: p_return_status := hr_multi_message.get_return_status_disable;
294: hr_utility.set_location(' Leaving:' || l_proc,20);
295: --
296: exception
297: when hr_multi_message.error_message_exist then
298: --

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

304: --
305: -- Reset IN OUT parameters and set OUT parameters
306: --
307: p_return_status := hr_multi_message.get_return_status_disable;
308: hr_utility.set_location(' Leaving:' || l_proc, 30);
309: when others then
310: --
311: -- When Multiple Message Detection is enabled catch
312: -- any Application specific or other unexpected

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

315: -- error.
316: --
317: rollback to delete_pvt_frm_thread_user_swi;
318: if hr_multi_message.unexpected_error_add(l_proc) then
319: hr_utility.set_location(' Leaving:' || l_proc,40);
320: raise;
321: end if;
322: --
323: -- Reset IN OUT and set OUT parameters

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

322: --
323: -- Reset IN OUT and set OUT parameters
324: --
325: p_return_status := hr_multi_message.get_return_status_disable;
326: hr_utility.set_location(' Leaving:' || l_proc,50);
327: end delete_pvt_frm_thread_user;
328: end ota_pvt_frm_thread_users_swi;