124: ,p_effective_date => p_effective_date
125: ,p_data_source => p_data_source
126: );
127: exception
128: when hr_api.cannot_find_prog_unit then
129: hr_api.cannot_find_prog_unit_error
130: (p_module_name => 'CREATE_RESOURCE_DEFINITION'
131: ,p_hook_type => 'BP'
132: );
125: ,p_data_source => p_data_source
126: );
127: exception
128: when hr_api.cannot_find_prog_unit then
129: hr_api.cannot_find_prog_unit_error
130: (p_module_name => 'CREATE_RESOURCE_DEFINITION'
131: ,p_hook_type => 'BP'
132: );
133: end;
237:
238:
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_RESOURCE_DEFINITION'
244: ,p_hook_type => 'AP'
245: );
238:
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_RESOURCE_DEFINITION'
244: ,p_hook_type => 'AP'
245: );
246: end;
248: --
249: -- When in validation only mode raise the Validate_Enabled exception
250: --
251: if p_validate then
252: raise hr_api.validate_enabled;
253: end if;
254: --
255: -- Set all output arguments
256: --
259:
260:
261: hr_utility.set_location(' Leaving:'||l_proc, 70);
262: exception
263: when hr_api.validate_enabled then
264: --
265: -- As the Validate_Enabled exception has been raised
266: -- we must rollback to the savepoint
267: --
295: ,p_resource_definition_id in number
296: ,p_consumable_flag in varchar2
297: ,p_object_version_number in out nocopy number
298: ,p_resource_type in varchar2
299: ,p_start_date in date default hr_api.g_date
300: ,p_comments in varchar2
301: ,p_cost in number
302: ,p_cost_unit in varchar2
303: ,p_currency_code in varchar2
300: ,p_comments in varchar2
301: ,p_cost in number
302: ,p_cost_unit in varchar2
303: ,p_currency_code in varchar2
304: ,p_end_date in date default hr_api.g_date
305: ,p_internal_address_line in varchar2
306: ,p_lead_time in number
307: ,p_name in varchar2
308: ,p_supplier_reference in varchar2
404: ,p_effective_date => l_effective_date
405: ,p_data_source => p_data_source
406: );
407: exception
408: when hr_api.cannot_find_prog_unit then
409: hr_api.cannot_find_prog_unit_error
410: (p_module_name => 'UPDATE_RESOURCE_DEFINITION'
411: ,p_hook_type => 'BP'
412: );
405: ,p_data_source => p_data_source
406: );
407: exception
408: when hr_api.cannot_find_prog_unit then
409: hr_api.cannot_find_prog_unit_error
410: (p_module_name => 'UPDATE_RESOURCE_DEFINITION'
411: ,p_hook_type => 'BP'
412: );
413: end;
518: ,p_effective_date => l_effective_date
519: ,p_data_source => p_data_source
520: );
521: exception
522: when hr_api.cannot_find_prog_unit then
523: hr_api.cannot_find_prog_unit_error
524: (p_module_name => 'UPDATE_RESOURCE_DEFINITION'
525: ,p_hook_type => 'AP'
526: );
519: ,p_data_source => p_data_source
520: );
521: exception
522: when hr_api.cannot_find_prog_unit then
523: hr_api.cannot_find_prog_unit_error
524: (p_module_name => 'UPDATE_RESOURCE_DEFINITION'
525: ,p_hook_type => 'AP'
526: );
527: end;
529: --
530: -- When in validation only mode raise the Validate_Enabled exception
531: --
532: if p_validate then
533: raise hr_api.validate_enabled;
534: end if;
535: --
536: -- Set all output arguments
537: --
536: -- Set all output arguments
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: --
594: (p_supplied_resource_id => p_supplied_resource_id
595: ,p_object_version_number => p_object_version_number
596: );
597: exception
598: when hr_api.cannot_find_prog_unit then
599: hr_api.cannot_find_prog_unit_error
600: (p_module_name => 'DELETE_RESOURCE_DEFINITION'
601: ,p_hook_type => 'BP'
602: );
595: ,p_object_version_number => p_object_version_number
596: );
597: exception
598: when hr_api.cannot_find_prog_unit then
599: hr_api.cannot_find_prog_unit_error
600: (p_module_name => 'DELETE_RESOURCE_DEFINITION'
601: ,p_hook_type => 'BP'
602: );
603: end;
624: (p_supplied_resource_id => p_supplied_resource_id
625: ,p_object_version_number => p_object_version_number
626: );
627: exception
628: when hr_api.cannot_find_prog_unit then
629: hr_api.cannot_find_prog_unit_error
630: (p_module_name => 'DELETE_RESOURCE_DEFINITION'
631: ,p_hook_type => 'AP'
632: );
625: ,p_object_version_number => p_object_version_number
626: );
627: exception
628: when hr_api.cannot_find_prog_unit then
629: hr_api.cannot_find_prog_unit_error
630: (p_module_name => 'DELETE_RESOURCE_DEFINITION'
631: ,p_hook_type => 'AP'
632: );
633: end;
635: --
636: -- When in validation only mode raise the Validate_Enabled exception
637: --
638: if p_validate then
639: raise hr_api.validate_enabled;
640: end if;
641: --
642: -- Set all output arguments
643: --
643: --
644: --
645: hr_utility.set_location(' Leaving:'||l_proc, 170);
646: exception
647: when hr_api.validate_enabled then
648: --
649: -- As the Validate_Enabled exception has been raised
650: -- we must rollback to the savepoint
651: --