117: ,p_information29 => p_information29
118: ,p_information30 => p_information30
119: );
120: exception
121: when hr_api.cannot_find_prog_unit then
122: hr_api.cannot_find_prog_unit_error
123: (
124: p_module_name => 'create_role'
125: ,p_hook_type => 'BP'
118: ,p_information30 => p_information30
119: );
120: exception
121: when hr_api.cannot_find_prog_unit then
122: hr_api.cannot_find_prog_unit_error
123: (
124: p_module_name => 'create_role'
125: ,p_hook_type => 'BP'
126: );
216: ,p_information29 => p_information29
217: ,p_information30 => p_information30
218: );
219: exception
220: when hr_api.cannot_find_prog_unit then
221: hr_api.cannot_find_prog_unit_error
222: (p_module_name => 'create_role'
223: ,p_hook_type => 'AP'
224: );
217: ,p_information30 => p_information30
218: );
219: exception
220: when hr_api.cannot_find_prog_unit then
221: hr_api.cannot_find_prog_unit_error
222: (p_module_name => 'create_role'
223: ,p_hook_type => 'AP'
224: );
225: --
231: --
232: -- When in validation only mode raise the Validate_Enabled exception
233: --
234: if p_validate then
235: raise hr_api.validate_enabled;
236: end if;
237: --
238: -- Set all output arguments
239: --
243: hr_utility.set_location(' Leaving:'||l_proc, 70);
244: --
245: exception
246: --
247: when hr_api.validate_enabled then
248: --
249: -- As the Validate_Enabled exception has been raised
250: -- we must rollback to the savepoint
251: --
379: ,p_information29 => p_information29
380: ,p_information30 => p_information30
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'update_role'
386: ,p_hook_type => 'BP'
387: );
380: ,p_information30 => p_information30
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'update_role'
386: ,p_hook_type => 'BP'
387: );
388: --
477: ,p_information29 => p_information29
478: ,p_information30 => p_information30
479: );
480: exception
481: when hr_api.cannot_find_prog_unit then
482: hr_api.cannot_find_prog_unit_error
483: (p_module_name => 'update_role'
484: ,p_hook_type => 'AP'
485: );
478: ,p_information30 => p_information30
479: );
480: exception
481: when hr_api.cannot_find_prog_unit then
482: hr_api.cannot_find_prog_unit_error
483: (p_module_name => 'update_role'
484: ,p_hook_type => 'AP'
485: );
486: --
492: --
493: -- When in validation only mode raise the Validate_Enabled exception
494: --
495: if p_validate then
496: raise hr_api.validate_enabled;
497: end if;
498: --
499: -- Set all output arguments
500: --
503: hr_utility.set_location(' Leaving:'||l_proc, 70);
504: --
505: exception
506: --
507: when hr_api.validate_enabled then
508: --
509: -- As the Validate_Enabled exception has been raised
510: -- we must rollback to the savepoint
511: --
567: ,p_object_version_number => p_object_version_number
568: ,p_effective_date => trunc(p_effective_date)
569: );
570: exception
571: when hr_api.cannot_find_prog_unit then
572: hr_api.cannot_find_prog_unit_error
573: (p_module_name => 'delete_role'
574: ,p_hook_type => 'BP'
575: );
568: ,p_effective_date => trunc(p_effective_date)
569: );
570: exception
571: when hr_api.cannot_find_prog_unit then
572: hr_api.cannot_find_prog_unit_error
573: (p_module_name => 'delete_role'
574: ,p_hook_type => 'BP'
575: );
576: --
595: ,p_object_version_number => l_object_version_number
596: ,p_effective_date => trunc(p_effective_date)
597: );
598: exception
599: when hr_api.cannot_find_prog_unit then
600: hr_api.cannot_find_prog_unit_error
601: (p_module_name => 'delete_role'
602: ,p_hook_type => 'AP'
603: );
596: ,p_effective_date => trunc(p_effective_date)
597: );
598: exception
599: when hr_api.cannot_find_prog_unit then
600: hr_api.cannot_find_prog_unit_error
601: (p_module_name => 'delete_role'
602: ,p_hook_type => 'AP'
603: );
604: --
610: --
611: -- When in validation only mode raise the Validate_Enabled exception
612: --
613: if p_validate then
614: raise hr_api.validate_enabled;
615: end if;
616: --
617: hr_utility.set_location(' Leaving:'||l_proc, 70);
618: --
617: hr_utility.set_location(' Leaving:'||l_proc, 70);
618: --
619: exception
620: --
621: when hr_api.validate_enabled then
622: --
623: -- As the Validate_Enabled exception has been raised
624: -- we must rollback to the savepoint
625: --