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;
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: --
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
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
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: -- ----------------------------------------------------------------------------
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;
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: --
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
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
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: -- ----------------------------------------------------------------------------
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;
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: --
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
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
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;