[Home] [Help]
183: --
184: -- Other variables
185: l_proc varchar2(72) := g_package ||'create_position';
186: Begin
187: hr_utility.set_location(' Entering:' || l_proc,10);
188: --
189: -- Issue a savepoint
190: --
191: savepoint create_position_swi;
386: -- messages of any type exist in the Multiple Message List.
387: -- Also disable Multiple Message Detection.
388: --
389: p_return_status := hr_multi_message.get_return_status_disable;
390: hr_utility.set_location(' Leaving:' || l_proc,20);
391: --
392: exception
393: when hr_multi_message.error_message_exist then
394: --
406: p_position_definition_id := null;
407: p_name := null;
408: p_object_version_number := null;
409: p_return_status := hr_multi_message.get_return_status_disable;
410: hr_utility.set_location(' Leaving:' || l_proc, 30);
411: when others then
412: --
413: -- When Multiple Message Detection is enabled catch
414: -- any Application specific or other unexpected
417: -- error.
418: --
419: rollback to create_position_swi;
420: if hr_multi_message.unexpected_error_add(l_proc) then
421: hr_utility.set_location(' Leaving:' || l_proc,40);
422: raise;
423: end if;
424: --
425: -- Reset IN OUT and set OUT parameters
430: p_position_definition_id := null;
431: p_name := null;
432: p_object_version_number := null;
433: p_return_status := hr_multi_message.get_return_status_disable;
434: hr_utility.set_location(' Leaving:' || l_proc,50);
435: end create_position;
436: -- ----------------------------------------------------------------------------
437: -- |----------------------------< delete_position >---------------------------|
438: -- ----------------------------------------------------------------------------
456: --
457: -- Other variables
458: l_proc varchar2(72) := g_package ||'delete_position';
459: Begin
460: hr_utility.set_location(' Entering:' || l_proc,10);
461: --
462: -- Issue a savepoint
463: --
464: savepoint delete_position_swi;
504: -- messages of any type exist in the Multiple Message List.
505: -- Also disable Multiple Message Detection.
506: --
507: p_return_status := hr_multi_message.get_return_status_disable;
508: hr_utility.set_location(' Leaving:' || l_proc,20);
509: --
510: exception
511: when hr_multi_message.error_message_exist then
512: --
521: p_effective_start_date := null;
522: p_effective_end_date := null;
523: p_object_version_number := l_object_version_number;
524: p_return_status := hr_multi_message.get_return_status_disable;
525: hr_utility.set_location(' Leaving:' || l_proc, 30);
526: when others then
527: --
528: -- When Multiple Message Detection is enabled catch
529: -- any Application specific or other unexpected
532: -- error.
533: --
534: rollback to delete_position_swi;
535: if hr_multi_message.unexpected_error_add(l_proc) then
536: hr_utility.set_location(' Leaving:' || l_proc,40);
537: raise;
538: end if;
539: --
540: -- Reset IN OUT and set OUT parameters
542: p_effective_start_date := null;
543: p_effective_end_date := null;
544: p_object_version_number := l_object_version_number;
545: p_return_status := hr_multi_message.get_return_status_disable;
546: hr_utility.set_location(' Leaving:' || l_proc,50);
547: end delete_position;
548: -- ----------------------------------------------------------------------------
549: -- |----------------------------------< lck >---------------------------------|
550: -- ----------------------------------------------------------------------------
564: --
565: -- Other variables
566: l_proc varchar2(72) := g_package ||'lck';
567: Begin
568: hr_utility.set_location(' Entering:' || l_proc,10);
569: --
570: -- Issue a savepoint
571: --
572: savepoint lck_swi;
606: -- messages of any type exist in the Multiple Message List.
607: -- Also disable Multiple Message Detection.
608: --
609: p_return_status := hr_multi_message.get_return_status_disable;
610: hr_utility.set_location(' Leaving:' || l_proc,20);
611: --
612: exception
613: when hr_multi_message.error_message_exist then
614: --
622: --
623: p_validation_start_date := null;
624: p_validation_end_date := null;
625: p_return_status := hr_multi_message.get_return_status_disable;
626: hr_utility.set_location(' Leaving:' || l_proc, 30);
627: when others then
628: --
629: -- When Multiple Message Detection is enabled catch
630: -- any Application specific or other unexpected
633: -- error.
634: --
635: rollback to lck_swi;
636: if hr_multi_message.unexpected_error_add(l_proc) then
637: hr_utility.set_location(' Leaving:' || l_proc,40);
638: raise;
639: end if;
640: --
641: -- Reset IN OUT and set OUT parameters
642: --
643: p_validation_start_date := null;
644: p_validation_end_date := null;
645: p_return_status := hr_multi_message.get_return_status_disable;
646: hr_utility.set_location(' Leaving:' || l_proc,50);
647: end lck;
648: -- ----------------------------------------------------------------------------
649: -- |----------------------------< update_position >---------------------------|
650: -- ----------------------------------------------------------------------------
822: --
823: -- Other variables
824: l_proc varchar2(72) := g_package ||'update_position';
825: Begin
826: hr_utility.set_location(' Entering:' || l_proc,10);
827: --
828: -- Issue a savepoint
829: --
830: savepoint update_position_swi;
1029: -- messages of any type exist in the Multiple Message List.
1030: -- Also disable Multiple Message Detection.
1031: --
1032: p_return_status := hr_multi_message.get_return_status_disable;
1033: hr_utility.set_location(' Leaving:' || l_proc,20);
1034: --
1035: exception
1036: when hr_multi_message.error_message_exist then
1037: --
1048: p_position_definition_id := null;
1049: p_name := null;
1050: p_object_version_number := l_object_version_number;
1051: p_return_status := hr_multi_message.get_return_status_disable;
1052: hr_utility.set_location(' Leaving:' || l_proc, 30);
1053: when others then
1054: --
1055: -- When Multiple Message Detection is enabled catch
1056: -- any Application specific or other unexpected
1059: -- error.
1060: --
1061: rollback to update_position_swi;
1062: if hr_multi_message.unexpected_error_add(l_proc) then
1063: hr_utility.set_location(' Leaving:' || l_proc,40);
1064: raise;
1065: end if;
1066: --
1067: -- Reset IN OUT and set OUT parameters
1071: p_position_definition_id := null;
1072: p_name := null;
1073: p_object_version_number := l_object_version_number;
1074: p_return_status := hr_multi_message.get_return_status_disable;
1075: hr_utility.set_location(' Leaving:' || l_proc,50);
1076: end update_position;
1077: end hr_position_swi;