DBA Data[Home] [Help]

APPS.OTA_LP_SECTION_SWI dependencies on HR_UTILITY

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

64: FROM ota_learning_paths
65: WHERE learning_path_id = p_learning_path_id;
66:
67: Begin
68: hr_utility.set_location(' Entering:' || l_proc,10);
69: --
70: -- Issue a savepoint
71: --
72: savepoint create_lpc_swi;

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

155: -- messages of any type exist in the Multiple Message List.
156: -- Also disable Multiple Message Detection.
157: --
158: p_return_status := hr_multi_message.get_return_status_disable;
159: hr_utility.set_location(' Leaving:' || l_proc,20);
160: --
161: exception
162: when hr_multi_message.error_message_exist then
163: --

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

170: -- Reset IN OUT parameters and set OUT parameters
171: --
172: p_object_version_number := null;
173: p_return_status := hr_multi_message.get_return_status_disable;
174: hr_utility.set_location(' Leaving:' || l_proc, 30);
175: when others then
176: --
177: -- When Multiple Message Detection is enabled catch
178: -- any Application specific or other unexpected

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

181: -- error.
182: --
183: rollback to create_lpc_swi;
184: if hr_multi_message.unexpected_error_add(l_proc) then
185: hr_utility.set_location(' Leaving:' || l_proc,40);
186: raise;
187: end if;
188: --
189: -- Reset IN OUT and set OUT parameters

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

189: -- Reset IN OUT and set OUT parameters
190: --
191: p_object_version_number := null;
192: p_return_status := hr_multi_message.get_return_status_disable;
193: hr_utility.set_location(' Leaving:' || l_proc,50);
194: end create_lp_section;
195: -- ----------------------------------------------------------------------------
196: -- |---------------------< update_lp_section >---------------------|
197: -- ----------------------------------------------------------------------------

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

237: --
238: -- Other variables
239: l_proc varchar2(72) := g_package ||'update_lp_section';
240: Begin
241: hr_utility.set_location(' Entering:' || l_proc,10);
242: --
243: -- Issue a savepoint
244: --
245: savepoint update_lpc_swi;

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

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

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

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

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

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

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

341: -- Reset IN OUT and set OUT parameters
342: --
343: p_object_version_number := l_object_version_number;
344: p_return_status := hr_multi_message.get_return_status_disable;
345: hr_utility.set_location(' Leaving:' || l_proc,50);
346: end update_lp_section;
347: -- ----------------------------------------------------------------------------
348: -- |---------------------< delete_lp_section >---------------------|
349: -- ----------------------------------------------------------------------------

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

361: --
362: -- Other variables
363: l_proc varchar2(72) := g_package ||'delete_lp_section';
364: Begin
365: hr_utility.set_location(' Entering:' || l_proc,10);
366: --
367: -- Issue a savepoint
368: --
369: savepoint delete_lpc_swi;

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

403: -- messages of any type exist in the Multiple Message List.
404: -- Also disable Multiple Message Detection.
405: --
406: p_return_status := hr_multi_message.get_return_status_disable;
407: hr_utility.set_location(' Leaving:' || l_proc,20);
408: --
409: exception
410: when hr_multi_message.error_message_exist then
411: --

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

417: --
418: -- Reset IN OUT parameters and set OUT parameters
419: --
420: p_return_status := hr_multi_message.get_return_status_disable;
421: hr_utility.set_location(' Leaving:' || l_proc, 30);
422: when others then
423: --
424: -- When Multiple Message Detection is enabled catch
425: -- any Application specific or other unexpected

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

428: -- error.
429: --
430: rollback to delete_lpc_swi;
431: if hr_multi_message.unexpected_error_add(l_proc) then
432: hr_utility.set_location(' Leaving:' || l_proc,40);
433: raise;
434: end if;
435: --
436: -- Reset IN OUT and set OUT parameters

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

435: --
436: -- Reset IN OUT and set OUT parameters
437: --
438: p_return_status := hr_multi_message.get_return_status_disable;
439: hr_utility.set_location(' Leaving:' || l_proc,50);
440: end delete_lp_section;
441: end ota_lp_section_swi;