62: ,p_business_group_id => p_business_group_id
63: ,p_legislation_code => p_legislation_code
64: );
65: exception
66: when hr_api.cannot_find_prog_unit then
67: hr_api.cannot_find_prog_unit_error
68: (p_module_name => 'create_rate_matrix_node'
69: ,p_hook_type => 'BP'
70: );
63: ,p_legislation_code => p_legislation_code
64: );
65: exception
66: when hr_api.cannot_find_prog_unit then
67: hr_api.cannot_find_prog_unit_error
68: (p_module_name => 'create_rate_matrix_node'
69: ,p_hook_type => 'BP'
70: );
71: end;
111: ,p_legislation_code => p_legislation_code
112: ,p_object_version_number => l_object_version_number
113: );
114: exception
115: when hr_api.cannot_find_prog_unit then
116: hr_api.cannot_find_prog_unit_error
117: (p_module_name => 'create_rate_matrix_node'
118: ,p_hook_type => 'AP'
119: );
112: ,p_object_version_number => l_object_version_number
113: );
114: exception
115: when hr_api.cannot_find_prog_unit then
116: hr_api.cannot_find_prog_unit_error
117: (p_module_name => 'create_rate_matrix_node'
118: ,p_hook_type => 'AP'
119: );
120: end;
121: --
122: -- When in validation only mode raise the Validate_Enabled exception
123: --
124: if p_validate then
125: raise hr_api.validate_enabled;
126: end if;
127: --
128: -- Set all IN OUT and OUT parameters with out values
129: --
131: p_object_version_number := l_object_version_number;
132: --
133: hr_utility.set_location(' Leaving:'||l_proc, 70);
134: exception
135: when hr_api.validate_enabled then
136: --
137: -- As the Validate_Enabled exception has been raised
138: -- we must rollback to the savepoint
139: --
222: ,p_legislation_code => p_legislation_code
223: ,p_object_version_number => l_object_version_number
224: );
225: exception
226: when hr_api.cannot_find_prog_unit then
227: hr_api.cannot_find_prog_unit_error
228: (p_module_name => 'update_rate_matrix_node'
229: ,p_hook_type => 'BP'
230: );
223: ,p_object_version_number => l_object_version_number
224: );
225: exception
226: when hr_api.cannot_find_prog_unit then
227: hr_api.cannot_find_prog_unit_error
228: (p_module_name => 'update_rate_matrix_node'
229: ,p_hook_type => 'BP'
230: );
231: end;
270: ,p_legislation_code => p_legislation_code
271: ,p_object_version_number => l_object_version_number
272: );
273: exception
274: when hr_api.cannot_find_prog_unit then
275: hr_api.cannot_find_prog_unit_error
276: (p_module_name => 'update_rate_matrix_node'
277: ,p_hook_type => 'AP'
278: );
271: ,p_object_version_number => l_object_version_number
272: );
273: exception
274: when hr_api.cannot_find_prog_unit then
275: hr_api.cannot_find_prog_unit_error
276: (p_module_name => 'update_rate_matrix_node'
277: ,p_hook_type => 'AP'
278: );
279: end;
280: --
281: -- When in validation only mode raise the Validate_Enabled exception
282: --
283: if p_validate then
284: raise hr_api.validate_enabled;
285: end if;
286: --
287: -- Set all IN OUT and OUT parameters with out values
288: --
289: p_object_version_number := l_object_version_number;
290: --
291: hr_utility.set_location(' Leaving:'||l_proc, 70);
292: exception
293: when hr_api.validate_enabled then
294: --
295: -- As the Validate_Enabled exception has been raised
296: -- we must rollback to the savepoint
297: --
357: ,p_rate_matrix_node_id => p_rate_matrix_node_id
358: ,p_object_version_number => p_object_version_number
359: );
360: exception
361: when hr_api.cannot_find_prog_unit then
362: hr_api.cannot_find_prog_unit_error
363: (p_module_name => 'delete_rate_matrix_node'
364: ,p_hook_type => 'BP'
365: );
358: ,p_object_version_number => p_object_version_number
359: );
360: exception
361: when hr_api.cannot_find_prog_unit then
362: hr_api.cannot_find_prog_unit_error
363: (p_module_name => 'delete_rate_matrix_node'
364: ,p_hook_type => 'BP'
365: );
366: end;
388: ,p_rate_matrix_node_id => p_rate_matrix_node_id
389: ,p_object_version_number => p_object_version_number
390: );
391: exception
392: when hr_api.cannot_find_prog_unit then
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'delete_rate_matrix_node'
395: ,p_hook_type => 'AP'
396: );
389: ,p_object_version_number => p_object_version_number
390: );
391: exception
392: when hr_api.cannot_find_prog_unit then
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'delete_rate_matrix_node'
395: ,p_hook_type => 'AP'
396: );
397: end;
398: --
399: -- When in validation only mode raise the Validate_Enabled exception
400: --
401: if p_validate then
402: raise hr_api.validate_enabled;
403: end if;
404: --
405: -- Set all IN OUT and OUT parameters with out values
406: --
406: --
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 70);
409: exception
410: when hr_api.validate_enabled then
411: --
412: -- As the Validate_Enabled exception has been raised
413: -- we must rollback to the savepoint
414: --