42: ,p_time_definition_id => p_time_definition_id
43: ,p_usage_type => p_usage_type
44: );
45: exception
46: when hr_api.cannot_find_prog_unit then
47: hr_api.cannot_find_prog_unit_error
48: (p_module_name => 'create_time_def_usage'
49: ,p_hook_type => 'BP'
50: );
43: ,p_usage_type => p_usage_type
44: );
45: exception
46: when hr_api.cannot_find_prog_unit then
47: hr_api.cannot_find_prog_unit_error
48: (p_module_name => 'create_time_def_usage'
49: ,p_hook_type => 'BP'
50: );
51: end;
72: ,p_object_version_number => l_object_version_number
73: );
74:
75: exception
76: when hr_api.cannot_find_prog_unit then
77: hr_api.cannot_find_prog_unit_error
78: (p_module_name => 'create_time_def_usage'
79: ,p_hook_type => 'AP'
80: );
73: );
74:
75: exception
76: when hr_api.cannot_find_prog_unit then
77: hr_api.cannot_find_prog_unit_error
78: (p_module_name => 'create_time_def_usage'
79: ,p_hook_type => 'AP'
80: );
81: end;
82: --
83: -- When in validation only mode raise the Validate_Enabled exception
84: --
85: if p_validate then
86: raise hr_api.validate_enabled;
87: end if;
88: --
89: -- Set all IN OUT and OUT parameters with out values
90: --
92: --
93: hr_utility.set_location(' Leaving:'||l_proc, 70);
94:
95: exception
96: when hr_api.validate_enabled then
97: --
98: -- As the Validate_Enabled exception has been raised
99: -- we must rollback to the savepoint
100: --
159: ,p_usage_type => p_usage_type
160: ,p_object_version_number => p_object_version_number
161: );
162: exception
163: when hr_api.cannot_find_prog_unit then
164: hr_api.cannot_find_prog_unit_error
165: (p_module_name => 'delete_time_def_usage'
166: ,p_hook_type => 'BP'
167: );
160: ,p_object_version_number => p_object_version_number
161: );
162: exception
163: when hr_api.cannot_find_prog_unit then
164: hr_api.cannot_find_prog_unit_error
165: (p_module_name => 'delete_time_def_usage'
166: ,p_hook_type => 'BP'
167: );
168: end;
187: ,p_usage_type => p_usage_type
188: ,p_object_version_number => p_object_version_number
189: );
190: exception
191: when hr_api.cannot_find_prog_unit then
192: hr_api.cannot_find_prog_unit_error
193: (p_module_name => 'delete_time_def_usage'
194: ,p_hook_type => 'AP'
195: );
188: ,p_object_version_number => p_object_version_number
189: );
190: exception
191: when hr_api.cannot_find_prog_unit then
192: hr_api.cannot_find_prog_unit_error
193: (p_module_name => 'delete_time_def_usage'
194: ,p_hook_type => 'AP'
195: );
196: end;
197: --
198: -- When in validation only mode raise the Validate_Enabled exception
199: --
200: if p_validate then
201: raise hr_api.validate_enabled;
202: end if;
203: --
204: hr_utility.set_location(' Leaving:'||l_proc, 70);
205: exception
202: end if;
203: --
204: hr_utility.set_location(' Leaving:'||l_proc, 70);
205: exception
206: when hr_api.validate_enabled then
207: --
208: -- As the Validate_Enabled exception has been raised
209: -- we must rollback to the savepoint
210: --