[Home] [Help]
131: --
132: -- Other variables
133: l_proc varchar2(72) := g_package ||'create_element_link';
134: Begin
135: hr_utility.set_location(' Entering:' || l_proc,10);
136: --
137: -- Issue a savepoint
138: --
139: savepoint create_element_link_swi;
282: -- messages of any type exist in the Multiple Message List.
283: -- Also disable Multiple Message Detection.
284: --
285: p_return_status := hr_multi_message.get_return_status_disable;
286: hr_utility.set_location(' Leaving:' || l_proc,20);
287: --
288: exception
289: when hr_multi_message.error_message_exist then
290: --
301: p_object_version_number := null;
302: p_effective_start_date := null;
303: p_effective_end_date := null;
304: p_return_status := hr_multi_message.get_return_status_disable;
305: hr_utility.set_location(' Leaving:' || l_proc, 30);
306: when others then
307: --
308: -- When Multiple Message Detection is enabled catch
309: -- any Application specific or other unexpected
312: -- error.
313: --
314: rollback to create_element_link_swi;
315: if hr_multi_message.unexpected_error_add(l_proc) then
316: hr_utility.set_location(' Leaving:' || l_proc,40);
317: raise;
318: end if;
319: --
320: -- Reset IN OUT and set OUT parameters
324: p_object_version_number := null;
325: p_effective_start_date := null;
326: p_effective_end_date := null;
327: p_return_status := hr_multi_message.get_return_status_disable;
328: hr_utility.set_location(' Leaving:' || l_proc,50);
329: end create_element_link;
330: -- ----------------------------------------------------------------------------
331: -- |--------------------------< delete_element_link >-------------------------|
332: -- ----------------------------------------------------------------------------
350: --
351: -- Other variables
352: l_proc varchar2(72) := g_package ||'delete_element_link';
353: Begin
354: hr_utility.set_location(' Entering:' || l_proc,10);
355: --
356: -- Issue a savepoint
357: --
358: savepoint delete_element_link_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: --
420: p_object_version_number := l_object_version_number;
421: p_effective_start_date := null;
422: p_effective_end_date := null;
423: p_return_status := hr_multi_message.get_return_status_disable;
424: hr_utility.set_location(' Leaving:' || l_proc, 30);
425: when others then
426: --
427: -- When Multiple Message Detection is enabled catch
428: -- any Application specific or other unexpected
431: -- error.
432: --
433: rollback to delete_element_link_swi;
434: if hr_multi_message.unexpected_error_add(l_proc) then
435: hr_utility.set_location(' Leaving:' || l_proc,40);
436: raise;
437: end if;
438: --
439: -- Reset IN OUT and set OUT parameters
441: p_object_version_number := l_object_version_number;
442: p_effective_start_date := null;
443: p_effective_end_date := null;
444: p_return_status := hr_multi_message.get_return_status_disable;
445: hr_utility.set_location(' Leaving:' || l_proc,50);
446: end delete_element_link;
447: -- ----------------------------------------------------------------------------
448: -- |--------------------------< update_element_link >-------------------------|
449: -- ----------------------------------------------------------------------------
564: --
565: -- Other variables
566: l_proc varchar2(72) := g_package ||'update_element_link';
567: Begin
568: hr_utility.set_location(' Entering:' || l_proc,10);
569: --
570: -- Issue a savepoint
571: --
572: savepoint update_element_link_swi;
709: -- messages of any type exist in the Multiple Message List.
710: -- Also disable Multiple Message Detection.
711: --
712: p_return_status := hr_multi_message.get_return_status_disable;
713: hr_utility.set_location(' Leaving:' || l_proc,20);
714: --
715: exception
716: when hr_multi_message.error_message_exist then
717: --
730: p_balance_concat_segments_out := null;
731: p_effective_start_date := null;
732: p_effective_end_date := null;
733: p_return_status := hr_multi_message.get_return_status_disable;
734: hr_utility.set_location(' Leaving:' || l_proc, 30);
735: when others then
736: --
737: -- When Multiple Message Detection is enabled catch
738: -- any Application specific or other unexpected
741: -- error.
742: --
743: rollback to update_element_link_swi;
744: if hr_multi_message.unexpected_error_add(l_proc) then
745: hr_utility.set_location(' Leaving:' || l_proc,40);
746: raise;
747: end if;
748: --
749: -- Reset IN OUT and set OUT parameters
755: p_balance_concat_segments_out := null;
756: p_effective_start_date := null;
757: p_effective_end_date := null;
758: p_return_status := hr_multi_message.get_return_status_disable;
759: hr_utility.set_location(' Leaving:' || l_proc,50);
760: end update_element_link;
761: end pay_element_link_swi;