242: l_object_version_number := p_object_version_number;
243: --
244: -- Check all the mandatory parameters are specified.
245: --
246: If (nvl(p_link_input_value_id,hr_api.g_number) = hr_api.g_number) then
247: hr_api.mandatory_arg_error
248: (p_api_name => l_proc
249: ,p_argument => 'link_input_value_id'
250: ,p_argument_value => p_link_input_value_id
243: --
244: -- Check all the mandatory parameters are specified.
245: --
246: If (nvl(p_link_input_value_id,hr_api.g_number) = hr_api.g_number) then
247: hr_api.mandatory_arg_error
248: (p_api_name => l_proc
249: ,p_argument => 'link_input_value_id'
250: ,p_argument_value => p_link_input_value_id
251: );
302: ,p_warning_or_error => p_warning_or_error
303: ,p_object_version_number => l_object_version_number
304: );
305: exception
306: when hr_api.cannot_find_prog_unit then
307: hr_api.cannot_find_prog_unit_error
308: (p_module_name => 'UPDATE_LINK_INPUT_VALUES'
309: ,p_hook_type => 'BP'
310: );
303: ,p_object_version_number => l_object_version_number
304: );
305: exception
306: when hr_api.cannot_find_prog_unit then
307: hr_api.cannot_find_prog_unit_error
308: (p_module_name => 'UPDATE_LINK_INPUT_VALUES'
309: ,p_hook_type => 'BP'
310: );
311: end;
369: ,p_assignment_id_warning => l_assignment_id_warning
370: ,p_formula_message => l_formula_message
371: );
372: exception
373: when hr_api.cannot_find_prog_unit then
374: hr_api.cannot_find_prog_unit_error
375: (p_module_name => 'UPDATE_LINK_INPUT_VALUES'
376: ,p_hook_type => 'AP'
377: );
370: ,p_formula_message => l_formula_message
371: );
372: exception
373: when hr_api.cannot_find_prog_unit then
374: hr_api.cannot_find_prog_unit_error
375: (p_module_name => 'UPDATE_LINK_INPUT_VALUES'
376: ,p_hook_type => 'AP'
377: );
378: end;
379: --
380: -- When in validation only mode raise the Validate_Enabled exception
381: --
382: if p_validate then
383: raise hr_api.validate_enabled;
384: end if;
385: --
386: -- Set all output arguments
387: --
394: p_formula_message := l_formula_message;
395: --
396: hr_utility.set_location(' Leaving:'||l_proc, 70);
397: exception
398: when hr_api.validate_enabled then
399: --
400: -- As the Validate_Enabled exception has been raised
401: -- we must rollback to the savepoint
402: --
475: ,p_link_input_value_id => p_link_input_value_id
476: ,p_object_version_number => l_object_version_number
477: );
478: exception
479: when hr_api.cannot_find_prog_unit then
480: hr_api.cannot_find_prog_unit_error
481: (p_module_name => 'DELETE_LINK_INPUT_VALUES'
482: ,p_hook_type => 'BP'
483: );
476: ,p_object_version_number => l_object_version_number
477: );
478: exception
479: when hr_api.cannot_find_prog_unit then
480: hr_api.cannot_find_prog_unit_error
481: (p_module_name => 'DELETE_LINK_INPUT_VALUES'
482: ,p_hook_type => 'BP'
483: );
484: end;
515: ,p_effective_start_date => l_effective_start_date
516: ,p_effective_end_date => l_effective_end_date
517: );
518: exception
519: when hr_api.cannot_find_prog_unit then
520: hr_api.cannot_find_prog_unit_error
521: (p_module_name => 'DELETE_LINK_INPUT_VALUES'
522: ,p_hook_type => 'AP'
523: );
516: ,p_effective_end_date => l_effective_end_date
517: );
518: exception
519: when hr_api.cannot_find_prog_unit then
520: hr_api.cannot_find_prog_unit_error
521: (p_module_name => 'DELETE_LINK_INPUT_VALUES'
522: ,p_hook_type => 'AP'
523: );
524: end;
525: --
526: -- When in validation only mode raise the Validate_Enabled exception
527: --
528: if p_validate then
529: raise hr_api.validate_enabled;
530: end if;
531: --
532: -- Set all output arguments
533: --
536: p_effective_end_date := l_effective_end_date;
537: --
538: hr_utility.set_location(' Leaving:'||l_proc, 70);
539: exception
540: when hr_api.validate_enabled then
541: --
542: -- As the Validate_Enabled exception has been raised
543: -- we must rollback to the savepoint
544: --