DBA Data[Home] [Help]

APPS.OTA_FORUM_THREAD_SWI dependencies on HR_UTILITY

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

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

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

83: -- messages of any type exist in the Multiple Message List.
84: -- Also disable Multiple Message Detection.
85: --
86: p_return_status := hr_multi_message.get_return_status_disable;
87: hr_utility.set_location(' Leaving:' || l_proc,20);
88: --
89: exception
90: when hr_multi_message.error_message_exist then
91: --

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

99: --
100: l_forum_thread_id := null;
101: p_object_version_number := null;
102: p_return_status := hr_multi_message.get_return_status_disable;
103: hr_utility.set_location(' Leaving:' || l_proc, 30);
104: when others then
105: --
106: -- When Multiple Message Detection is enabled catch
107: -- any Application specific or other unexpected

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

110: -- error.
111: --
112: rollback to create_forum_thread_swi;
113: if hr_multi_message.unexpected_error_add(l_proc) then
114: hr_utility.set_location(' Leaving:' || l_proc,40);
115: raise;
116: end if;
117: --
118: -- Reset IN OUT and set OUT parameters

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

119: --
120: l_forum_thread_id := null;
121: p_object_version_number := null;
122: p_return_status := hr_multi_message.get_return_status_disable;
123: hr_utility.set_location(' Leaving:' || l_proc,50);
124: end create_forum_thread;
125: --
126: -- ----------------------------------------------------------------------------
127: -- |--------------------------< update_forum_thread >-------------------------|

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

149: l_proc varchar2(72) := g_package ||'update_forum_thread';
150: l_object_version_number number := p_object_version_number;
151:
152: Begin
153: hr_utility.set_location(' Entering:' || l_proc,10);
154: --
155: -- Issue a savepoint
156: --
157: savepoint update_forum_thread_swi;

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

195: -- messages of any type exist in the Multiple Message List.
196: -- Also disable Multiple Message Detection.
197: --
198: p_return_status := hr_multi_message.get_return_status_disable;
199: hr_utility.set_location(' Leaving:' || l_proc,20);
200: --
201: exception
202: when hr_multi_message.error_message_exist then
203: --

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

210: -- Reset IN OUT parameters and set OUT parameters
211: --
212: p_object_version_number := null;
213: p_return_status := hr_multi_message.get_return_status_disable;
214: hr_utility.set_location(' Leaving:' || l_proc, 30);
215: when others then
216: --
217: -- When Multiple Message Detection is enabled catch
218: -- any Application specific or other unexpected

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

221: -- error.
222: --
223: rollback to update_forum_thread_swi;
224: if hr_multi_message.unexpected_error_add(l_proc) then
225: hr_utility.set_location(' Leaving:' || l_proc,40);
226: raise;
227: end if;
228: --
229: -- Reset IN OUT and set OUT parameters

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

229: -- Reset IN OUT and set OUT parameters
230: --
231: p_object_version_number := null;
232: p_return_status := hr_multi_message.get_return_status_disable;
233: hr_utility.set_location(' Leaving:' || l_proc,50);
234: end update_forum_thread;
235:
236: -- ----------------------------------------------------------------------------
237: -- |--------------------------< delete_forum_thread >-------------------------|

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

250: --
251: -- Other variables
252: l_proc varchar2(72) := g_package ||'delete_forum_thread';
253: Begin
254: hr_utility.set_location(' Entering:' || l_proc,10);
255: --
256: -- Issue a savepoint
257: --
258: savepoint delete_forum_thread_swi;

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

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

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

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

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

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

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

324: --
325: -- Reset IN OUT and set OUT parameters
326: --
327: p_return_status := hr_multi_message.get_return_status_disable;
328: hr_utility.set_location(' Leaving:' || l_proc,50);
329: end delete_forum_thread;
330: end ota_forum_thread_swi;