81: l_date_to :=trunc(p_date_to);
82: --
83: -- Check that p_grade_id is not null as it is used in the cursor.
84: --
85: hr_api.mandatory_arg_error
86: (p_api_name => l_proc,
87: p_argument => 'grade_id',
88: p_argument_value => p_grade_id);
89: --
150: ,p_attribute19 => p_attribute19
151: ,p_attribute20 => p_attribute20
152: );
153: exception
154: when hr_api.Cannot_Find_Prog_Unit then
155: hr_api.cannot_find_prog_unit_error
156: (p_module_name => 'CREATE_VALID_GRADE'
157: ,p_hook_type => 'BP'
158: );
151: ,p_attribute20 => p_attribute20
152: );
153: exception
154: when hr_api.Cannot_Find_Prog_Unit then
155: hr_api.cannot_find_prog_unit_error
156: (p_module_name => 'CREATE_VALID_GRADE'
157: ,p_hook_type => 'BP'
158: );
159: --
237: ,p_valid_grade_id => l_valid_grade_id
238: ,p_object_version_number => l_object_version_number
239: );
240: exception
241: when hr_api.Cannot_Find_Prog_Unit then
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'CREATE_VALID_GRADE'
244: ,p_hook_type => 'AP'
245: );
238: ,p_object_version_number => l_object_version_number
239: );
240: exception
241: when hr_api.Cannot_Find_Prog_Unit then
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'CREATE_VALID_GRADE'
244: ,p_hook_type => 'AP'
245: );
246: --
248: --
249: end;
250: --
251: if p_validate then
252: raise hr_api.validate_enabled;
253: end if;
254: --
255: -- Set all output arguments
256: --
262:
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 11);
265: exception
266: when hr_api.validate_enabled then
267: --
268: -- As the Validate_Enabled exception has been raised
269: -- we must rollback to the savepoint
270: --