DBA Data[Home] [Help]

APPS.OTA_FORUM_SWI dependencies on HR_UTILITY

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

34: -- Other variables
35: l_proc varchar2(72) := g_package ||'create_forum';
36: l_forum_id number;
37: Begin
38: hr_utility.set_location(' Entering:' || l_proc,10);
39: --
40: -- Issue a savepoint
41: --
42: savepoint create_forum_swi;

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

91: -- messages of any type exist in the Multiple Message List.
92: -- Also disable Multiple Message Detection.
93: --
94: p_return_status := hr_multi_message.get_return_status_disable;
95: hr_utility.set_location(' Leaving:' || l_proc,20);
96: --
97: exception
98: when hr_multi_message.error_message_exist then
99: --

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

107: --
108: l_forum_id := null;
109: p_object_version_number := null;
110: p_return_status := hr_multi_message.get_return_status_disable;
111: hr_utility.set_location(' Leaving:' || l_proc, 30);
112: when others then
113: --
114: -- When Multiple Message Detection is enabled catch
115: -- any Application specific or other unexpected

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

118: -- error.
119: --
120: rollback to create_forum_swi;
121: if hr_multi_message.unexpected_error_add(l_proc) then
122: hr_utility.set_location(' Leaving:' || l_proc,40);
123: raise;
124: end if;
125: --
126: -- Reset IN OUT and set OUT parameters

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

127: --
128: l_forum_id := null;
129: p_object_version_number := null;
130: p_return_status := hr_multi_message.get_return_status_disable;
131: hr_utility.set_location(' Leaving:' || l_proc,50);
132: end create_forum;
133: -- ----------------------------------------------------------------------------
134: -- |-----------------------------< update_forum >-----------------------------|
135: -- ----------------------------------------------------------------------------

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

159: --
160: -- Other variables
161: l_proc varchar2(72) := g_package ||'update_forum';
162: Begin
163: hr_utility.set_location(' Entering:' || l_proc,10);
164: --
165: -- Issue a savepoint
166: --
167: savepoint update_forum_swi;

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

213: -- messages of any type exist in the Multiple Message List.
214: -- Also disable Multiple Message Detection.
215: --
216: p_return_status := hr_multi_message.get_return_status_disable;
217: hr_utility.set_location(' Leaving:' || l_proc,20);
218: --
219: exception
220: when hr_multi_message.error_message_exist then
221: --

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

228: -- Reset IN OUT parameters and set OUT parameters
229: --
230: p_object_version_number := l_object_version_number;
231: p_return_status := hr_multi_message.get_return_status_disable;
232: hr_utility.set_location(' Leaving:' || l_proc, 30);
233: when others then
234: --
235: -- When Multiple Message Detection is enabled catch
236: -- any Application specific or other unexpected

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

239: -- error.
240: --
241: rollback to update_forum_swi;
242: if hr_multi_message.unexpected_error_add(l_proc) then
243: hr_utility.set_location(' Leaving:' || l_proc,40);
244: raise;
245: end if;
246: --
247: -- Reset IN OUT and set OUT parameters

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

247: -- Reset IN OUT and set OUT parameters
248: --
249: p_object_version_number := l_object_version_number;
250: p_return_status := hr_multi_message.get_return_status_disable;
251: hr_utility.set_location(' Leaving:' || l_proc,50);
252: end update_forum;
253: -- ----------------------------------------------------------------------------
254: -- |-----------------------------< delete_forum >-----------------------------|
255: -- ----------------------------------------------------------------------------

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

267: --
268: -- Other variables
269: l_proc varchar2(72) := g_package ||'delete_forum';
270: Begin
271: hr_utility.set_location(' Entering:' || l_proc,10);
272: --
273: -- Issue a savepoint
274: --
275: savepoint delete_forum_swi;

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

309: -- messages of any type exist in the Multiple Message List.
310: -- Also disable Multiple Message Detection.
311: --
312: p_return_status := hr_multi_message.get_return_status_disable;
313: hr_utility.set_location(' Leaving:' || l_proc,20);
314: --
315: exception
316: when hr_multi_message.error_message_exist then
317: --

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

323: --
324: -- Reset IN OUT parameters and set OUT parameters
325: --
326: p_return_status := hr_multi_message.get_return_status_disable;
327: hr_utility.set_location(' Leaving:' || l_proc, 30);
328: when others then
329: --
330: -- When Multiple Message Detection is enabled catch
331: -- any Application specific or other unexpected

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

334: -- error.
335: --
336: rollback to delete_forum_swi;
337: if hr_multi_message.unexpected_error_add(l_proc) then
338: hr_utility.set_location(' Leaving:' || l_proc,40);
339: raise;
340: end if;
341: --
342: -- Reset IN OUT and set OUT parameters

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

341: --
342: -- Reset IN OUT and set OUT parameters
343: --
344: p_return_status := hr_multi_message.get_return_status_disable;
345: hr_utility.set_location(' Leaving:' || l_proc,50);
346: end delete_forum;
347: end ota_forum_swi;