154: ,p_non_mandatory_arg => p_non_mandatory_arg
155: );
156: */
157: exception
158: when hr_api.cannot_find_prog_unit then
159: hr_api.cannot_find_prog_unit_error
160: (p_module_name => 'CREATE_ALLOC_CHECKLIST'
161: ,p_hook_type => 'BP'
162: );
155: );
156: */
157: exception
158: when hr_api.cannot_find_prog_unit then
159: hr_api.cannot_find_prog_unit_error
160: (p_module_name => 'CREATE_ALLOC_CHECKLIST'
161: ,p_hook_type => 'BP'
162: );
163: end;
298: ,p_some_warning =>
299: );
300: */
301: exception
302: when hr_api.cannot_find_prog_unit then
303: hr_api.cannot_find_prog_unit_error
304: (p_module_name => 'CREATE_ALLOC_CHECKLIST'
305: ,p_hook_type => 'AP'
306: );
299: );
300: */
301: exception
302: when hr_api.cannot_find_prog_unit then
303: hr_api.cannot_find_prog_unit_error
304: (p_module_name => 'CREATE_ALLOC_CHECKLIST'
305: ,p_hook_type => 'AP'
306: );
307: end;
308: --
309: -- When in validation only mode raise the Validate_Enabled exception
310: --
311: if p_validate then
312: raise hr_api.validate_enabled;
313: end if;
314: --
315: -- Set all IN OUT and OUT parameters with out values
316: --
320: --p_some_warning :=
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 70);
323: exception
324: when hr_api.validate_enabled then
325: --
326: -- As the Validate_Enabled exception has been raised
327: -- we must rollback to the savepoint
328: --
441: -- instead of p_language_code from now on, to allow an IN OUT parameter to
442: -- be passed through.
443: --
444: l_language_code := p_language_code;
445: hr_api.validate_language_code(p_language_code => l_language_code);
446: */
447: --
448: -- Call Before Process User Hook
449: --
503: ,p_object_version_number => l_object_version_number
504: );
505: --
506: exception
507: when hr_Api.cannot_find_prog_unit then
508: hr_Api.cannot_find_prog_unit_error
509: (p_module_name => 'UPDATE_ALLOC_CHECKLIST'
510: ,p_hook_type => 'BP'
511: );
504: );
505: --
506: exception
507: when hr_Api.cannot_find_prog_unit then
508: hr_Api.cannot_find_prog_unit_error
509: (p_module_name => 'UPDATE_ALLOC_CHECKLIST'
510: ,p_hook_type => 'BP'
511: );
512: end;
627: ,p_information19 => p_information19
628: ,p_information20 => p_information20
629: ,p_object_version_number => l_object_version_number);
630: exception
631: when hr_Api.cannot_find_prog_unit then
632: hr_Api.cannot_find_prog_unit_error
633: (p_module_name => 'UPDATE_ALLOC_CHECKLIST'
634: ,p_hook_type => 'AP'
635: );
628: ,p_information20 => p_information20
629: ,p_object_version_number => l_object_version_number);
630: exception
631: when hr_Api.cannot_find_prog_unit then
632: hr_Api.cannot_find_prog_unit_error
633: (p_module_name => 'UPDATE_ALLOC_CHECKLIST'
634: ,p_hook_type => 'AP'
635: );
636: end;
637: --
638: -- When in validation only mode raise the Validate_Enabled exception
639: --
640: if p_validate then
641: raise hr_Api.validate_enabled;
642: end if;
643: --
644: -- Set all output arguements
645: --
645: --
646: p_object_version_number := l_object_version_number;
647: hr_utility.set_location(' Leaving:'||l_proc, 70);
648: exception
649: when hr_Api.validate_enabled then
650: --
651: -- As the Validate_Enabled exception has been raised
652: -- we must rollback to the savepoint
653: --
698: (p_allocated_checklist_id => p_allocated_checklist_id
699: ,p_object_version_number => p_object_version_number
700: );
701: exception
702: when hr_Api.cannot_find_prog_unit then
703: hr_Api.cannot_find_prog_unit_error
704: (p_module_name => 'DELETE_ALLOC_CHECKLIST'
705: ,p_hook_type => 'BP'
706: );
699: ,p_object_version_number => p_object_version_number
700: );
701: exception
702: when hr_Api.cannot_find_prog_unit then
703: hr_Api.cannot_find_prog_unit_error
704: (p_module_name => 'DELETE_ALLOC_CHECKLIST'
705: ,p_hook_type => 'BP'
706: );
707: end;
722: (p_allocated_checklist_id => p_allocated_checklist_id
723: ,p_object_version_number => p_object_version_number
724: );
725: exception
726: when hr_api.cannot_find_prog_unit then
727: hr_Api.cannot_find_prog_unit_error
728: (p_module_name => 'DELETE_ALLOC_CHECKLIST'
729: ,p_hook_type => 'AP'
730: );
723: ,p_object_version_number => p_object_version_number
724: );
725: exception
726: when hr_api.cannot_find_prog_unit then
727: hr_Api.cannot_find_prog_unit_error
728: (p_module_name => 'DELETE_ALLOC_CHECKLIST'
729: ,p_hook_type => 'AP'
730: );
731: end;
732: --
733: -- When in validation only mode raise the Validate_Enabled exception
734: --
735: if p_validate then
736: raise hr_Api.validate_enabled;
737: end if;
738: --
739: hr_utility.set_location(' Leaving:'||l_proc, 70);
740: exception
737: end if;
738: --
739: hr_utility.set_location(' Leaving:'||l_proc, 70);
740: exception
741: when hr_Api.validate_enabled then
742: --
743: -- As the Validate_Enabled exception has been raised
744: -- we must rollback to the savepoint
745: --