[Home] [Help]
115: --
116: -- Other variables
117: l_proc varchar2(72) := g_package ||'create_element_type';
118: Begin
119: hr_utility.set_location(' Entering:' || l_proc,10);
120: --
121: -- Issue a savepoint
122: --
123: savepoint create_element_type_swi;
255: -- messages of any type exist in the Multiple Message List.
256: -- Also disable Multiple Message Detection.
257: --
258: p_return_status := hr_multi_message.get_return_status_disable;
259: hr_utility.set_location(' Leaving:' || l_proc,20);
260: --
261: exception
262: when hr_multi_message.error_message_exist then
263: --
274: p_effective_end_date := null;
275: p_object_version_number := null;
276: p_comment_id := null;
277: p_return_status := hr_multi_message.get_return_status_disable;
278: hr_utility.set_location(' Leaving:' || l_proc, 30);
279: when others then
280: --
281: -- When Multiple Message Detection is enabled catch
282: -- any Application specific or other unexpected
285: -- error.
286: --
287: rollback to create_element_type_swi;
288: if hr_multi_message.unexpected_error_add(l_proc) then
289: hr_utility.set_location(' Leaving:' || l_proc,40);
290: raise;
291: end if;
292: --
293: -- Reset IN OUT and set OUT parameters
297: p_effective_end_date := null;
298: p_object_version_number := null;
299: p_comment_id := null;
300: p_return_status := hr_multi_message.get_return_status_disable;
301: hr_utility.set_location(' Leaving:' || l_proc,50);
302: end create_element_type;
303: -- ----------------------------------------------------------------------------
304: -- |--------------------------< update_element_type >-------------------------|
305: -- ----------------------------------------------------------------------------
406: --
407: -- Other variables
408: l_proc varchar2(72) := g_package ||'update_element_type';
409: Begin
410: hr_utility.set_location(' Entering:' || l_proc,10);
411: --
412: -- Issue a savepoint
413: --
414: savepoint update_element_type_swi;
554: -- messages of any type exist in the Multiple Message List.
555: -- Also disable Multiple Message Detection.
556: --
557: p_return_status := hr_multi_message.get_return_status_disable;
558: hr_utility.set_location(' Leaving:' || l_proc,20);
559: --
560: exception
561: when hr_multi_message.error_message_exist then
562: --
572: p_effective_start_date := null;
573: p_effective_end_date := null;
574: p_comment_id := null;
575: p_return_status := hr_multi_message.get_return_status_disable;
576: hr_utility.set_location(' Leaving:' || l_proc, 30);
577: when others then
578: --
579: -- When Multiple Message Detection is enabled catch
580: -- any Application specific or other unexpected
583: -- error.
584: --
585: rollback to update_element_type_swi;
586: if hr_multi_message.unexpected_error_add(l_proc) then
587: hr_utility.set_location(' Leaving:' || l_proc,40);
588: raise;
589: end if;
590: --
591: -- Reset IN OUT and set OUT parameters
594: p_effective_start_date := null;
595: p_effective_end_date := null;
596: p_comment_id := null;
597: p_return_status := hr_multi_message.get_return_status_disable;
598: hr_utility.set_location(' Leaving:' || l_proc,50);
599: end update_element_type;
600: -- ----------------------------------------------------------------------------
601: -- |--------------------------< delete_element_type >-------------------------|
602: -- ----------------------------------------------------------------------------
621: --
622: -- Other variables
623: l_proc varchar2(72) := g_package ||'delete_element_type';
624: Begin
625: hr_utility.set_location(' Entering:' || l_proc,10);
626: --
627: -- Issue a savepoint
628: --
629: savepoint delete_element_type_swi;
681: -- messages of any type exist in the Multiple Message List.
682: -- Also disable Multiple Message Detection.
683: --
684: p_return_status := hr_multi_message.get_return_status_disable;
685: hr_utility.set_location(' Leaving:' || l_proc,20);
686: --
687: exception
688: when hr_multi_message.error_message_exist then
689: --
698: p_object_version_number := l_object_version_number;
699: p_effective_start_date := null;
700: p_effective_end_date := null;
701: p_return_status := hr_multi_message.get_return_status_disable;
702: hr_utility.set_location(' Leaving:' || l_proc, 30);
703: when others then
704: --
705: -- When Multiple Message Detection is enabled catch
706: -- any Application specific or other unexpected
709: -- error.
710: --
711: rollback to delete_element_type_swi;
712: if hr_multi_message.unexpected_error_add(l_proc) then
713: hr_utility.set_location(' Leaving:' || l_proc,40);
714: raise;
715: end if;
716: --
717: -- Reset IN OUT and set OUT parameters
719: p_object_version_number := l_object_version_number;
720: p_effective_start_date := null;
721: p_effective_end_date := null;
722: p_return_status := hr_multi_message.get_return_status_disable;
723: hr_utility.set_location(' Leaving:' || l_proc,50);
724: end delete_element_type;
725: -- ---------------------------------------------------------------------------+
726: -- |--------------------------< create_class_balance_feeds >-----------------|+
727: -- ---------------------------------------------------------------------------+
774: OR balance_name like p_balance_name || ' Roth Eligible Comp'
775: OR balance_name like p_balance_name || ' AT Eligible Comp');
776: --and balance_name = p_balance_name;
777: begin
778: hr_utility.set_location('Entering: '||l_proc, 5);
779: for c1_rec in c1_get_reg_earn_feeds loop
780: for c2_rec in c2_balance_type loop
781: begin
782: select count(*) into l_count
807:
808: end;
809: end loop;
810: end loop;
811: hr_utility.set_location('Leaving: '||l_proc, 10);
812: END create_class_balance_feeds;
813: end pay_element_types_swi_nd;