107: ,p_attribute20 => p_attribute20
108: ,p_comments => p_comments
109: );
110: exception
111: when hr_api.cannot_find_prog_unit then
112: hr_api.cannot_find_prog_unit_error
113: (p_module_name => 'CREATE_TXN_JOB_REQUIREMENT'
114: ,p_hook_type => 'BP'
115: );
108: ,p_comments => p_comments
109: );
110: exception
111: when hr_api.cannot_find_prog_unit then
112: hr_api.cannot_find_prog_unit_error
113: (p_module_name => 'CREATE_TXN_JOB_REQUIREMENT'
114: ,p_hook_type => 'BP'
115: );
116: end;
206: ,p_attribute20 => p_attribute20
207: ,p_comments => p_comments
208: );
209: exception
210: when hr_api.cannot_find_prog_unit then
211: hr_api.cannot_find_prog_unit_error
212: (p_module_name => 'CREATE_TXN_JOB_REQUIREMENT'
213: ,p_hook_type => 'AP'
214: );
207: ,p_comments => p_comments
208: );
209: exception
210: when hr_api.cannot_find_prog_unit then
211: hr_api.cannot_find_prog_unit_error
212: (p_module_name => 'CREATE_TXN_JOB_REQUIREMENT'
213: ,p_hook_type => 'AP'
214: );
215: end;
216: --
217: -- When in validation only mode raise the Validate_Enabled exception
218: --
219: if p_validate then
220: raise hr_api.validate_enabled;
221: end if;
222: --
223: -- Set all output arguments
224: --
226: p_object_version_number := l_object_version_number;
227: --
228: hr_utility.set_location(' Leaving:'||l_proc, 70);
229: exception
230: when hr_api.validate_enabled then
231: --
232: -- As the Validate_Enabled exception has been raised
233: -- we must rollback to the savepoint
234: --
260: (p_validate in boolean default false
261: ,p_effective_date in date
262: ,p_txn_job_requirement_id in number
263: ,p_object_version_number in out nocopy number
264: ,p_business_group_id in number default hr_api.g_number
265: ,p_analysis_criteria_id in number default hr_api.g_number
266: ,p_position_transaction_id in number default hr_api.g_number
267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date
261: ,p_effective_date in date
262: ,p_txn_job_requirement_id in number
263: ,p_object_version_number in out nocopy number
264: ,p_business_group_id in number default hr_api.g_number
265: ,p_analysis_criteria_id in number default hr_api.g_number
266: ,p_position_transaction_id in number default hr_api.g_number
267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date
262: ,p_txn_job_requirement_id in number
263: ,p_object_version_number in out nocopy number
264: ,p_business_group_id in number default hr_api.g_number
265: ,p_analysis_criteria_id in number default hr_api.g_number
266: ,p_position_transaction_id in number default hr_api.g_number
267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2
263: ,p_object_version_number in out nocopy number
264: ,p_business_group_id in number default hr_api.g_number
265: ,p_analysis_criteria_id in number default hr_api.g_number
266: ,p_position_transaction_id in number default hr_api.g_number
267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
264: ,p_business_group_id in number default hr_api.g_number
265: ,p_analysis_criteria_id in number default hr_api.g_number
266: ,p_position_transaction_id in number default hr_api.g_number
267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number
265: ,p_analysis_criteria_id in number default hr_api.g_number
266: ,p_position_transaction_id in number default hr_api.g_number
267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number
266: ,p_position_transaction_id in number default hr_api.g_number
267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number
267: ,p_job_requirement_id in number default hr_api.g_number
268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date
268: ,p_date_from in date default hr_api.g_date
269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
269: ,p_date_to in date default hr_api.g_date
270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
270: ,p_essential in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
271: ,p_job_id in number default hr_api.g_number
272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
272: ,p_request_id in number default hr_api.g_number
273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
273: ,p_program_application_id in number default hr_api.g_number
274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
274: ,p_program_id in number default hr_api.g_number
275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
275: ,p_program_update_date in date default hr_api.g_date
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
276: ,p_attribute_category in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
277: ,p_attribute1 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
278: ,p_attribute2 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
279: ,p_attribute3 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
280: ,p_attribute4 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
281: ,p_attribute5 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
282: ,p_attribute6 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
283: ,p_attribute7 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
284: ,p_attribute8 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
285: ,p_attribute9 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
286: ,p_attribute10 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2
287: ,p_attribute11 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2
295: ,p_attribute19 in varchar2 default hr_api.g_varchar2
288: ,p_attribute12 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2
295: ,p_attribute19 in varchar2 default hr_api.g_varchar2
296: ,p_attribute20 in varchar2 default hr_api.g_varchar2
289: ,p_attribute13 in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2
295: ,p_attribute19 in varchar2 default hr_api.g_varchar2
296: ,p_attribute20 in varchar2 default hr_api.g_varchar2
297: ,p_comments in varchar2 default hr_api.g_varchar2
290: ,p_attribute14 in varchar2 default hr_api.g_varchar2
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2
295: ,p_attribute19 in varchar2 default hr_api.g_varchar2
296: ,p_attribute20 in varchar2 default hr_api.g_varchar2
297: ,p_comments in varchar2 default hr_api.g_varchar2
298: ) is
291: ,p_attribute15 in varchar2 default hr_api.g_varchar2
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2
295: ,p_attribute19 in varchar2 default hr_api.g_varchar2
296: ,p_attribute20 in varchar2 default hr_api.g_varchar2
297: ,p_comments in varchar2 default hr_api.g_varchar2
298: ) is
299: --
292: ,p_attribute16 in varchar2 default hr_api.g_varchar2
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2
295: ,p_attribute19 in varchar2 default hr_api.g_varchar2
296: ,p_attribute20 in varchar2 default hr_api.g_varchar2
297: ,p_comments in varchar2 default hr_api.g_varchar2
298: ) is
299: --
300: -- Declare cursors and local variables
293: ,p_attribute17 in varchar2 default hr_api.g_varchar2
294: ,p_attribute18 in varchar2 default hr_api.g_varchar2
295: ,p_attribute19 in varchar2 default hr_api.g_varchar2
296: ,p_attribute20 in varchar2 default hr_api.g_varchar2
297: ,p_comments in varchar2 default hr_api.g_varchar2
298: ) is
299: --
300: -- Declare cursors and local variables
301: --
355: ,p_txn_job_requirement_id => p_txn_job_requirement_id
356: ,p_object_version_number => p_object_version_number
357: );
358: exception
359: when hr_api.cannot_find_prog_unit then
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'UPDATE_TXN_JOB_REQUIREMENT'
362: ,p_hook_type => 'BP'
363: );
356: ,p_object_version_number => p_object_version_number
357: );
358: exception
359: when hr_api.cannot_find_prog_unit then
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'UPDATE_TXN_JOB_REQUIREMENT'
362: ,p_hook_type => 'BP'
363: );
364: end;
454: ,p_attribute20 => p_attribute20
455: ,p_comments => p_comments
456: );
457: exception
458: when hr_api.cannot_find_prog_unit then
459: hr_api.cannot_find_prog_unit_error
460: (p_module_name => 'UPDATE_TXN_JOB_REQUIREMENT'
461: ,p_hook_type => 'AP'
462: );
455: ,p_comments => p_comments
456: );
457: exception
458: when hr_api.cannot_find_prog_unit then
459: hr_api.cannot_find_prog_unit_error
460: (p_module_name => 'UPDATE_TXN_JOB_REQUIREMENT'
461: ,p_hook_type => 'AP'
462: );
463: end;
464: --
465: -- When in validation only mode raise the Validate_Enabled exception
466: --
467: if p_validate then
468: raise hr_api.validate_enabled;
469: end if;
470: --
471: -- Set all output arguments
472: --
473: p_object_version_number := l_object_version_number;
474: --
475: hr_utility.set_location(' Leaving:'||l_proc, 70);
476: exception
477: when hr_api.validate_enabled then
478: --
479: -- As the Validate_Enabled exception has been raised
480: -- we must rollback to the savepoint
481: --
532: ,p_txn_job_requirement_id => p_txn_job_requirement_id
533: ,p_object_version_number => l_object_version_number
534: );
535: exception
536: when hr_api.cannot_find_prog_unit then
537: hr_api.cannot_find_prog_unit_error
538: (p_module_name => 'DELETE_TXN_JOB_REQUIREMENT'
539: ,p_hook_type => 'BP'
540: );
533: ,p_object_version_number => l_object_version_number
534: );
535: exception
536: when hr_api.cannot_find_prog_unit then
537: hr_api.cannot_find_prog_unit_error
538: (p_module_name => 'DELETE_TXN_JOB_REQUIREMENT'
539: ,p_hook_type => 'BP'
540: );
541: end;
563: ,p_txn_job_requirement_id => p_txn_job_requirement_id
564: ,p_object_version_number => l_object_version_number
565: );
566: exception
567: when hr_api.cannot_find_prog_unit then
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'DELETE_TXN_JOB_REQUIREMENT'
570: ,p_hook_type => 'AP'
571: );
564: ,p_object_version_number => l_object_version_number
565: );
566: exception
567: when hr_api.cannot_find_prog_unit then
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'DELETE_TXN_JOB_REQUIREMENT'
570: ,p_hook_type => 'AP'
571: );
572: end;
573: --
574: -- When in validation only mode raise the Validate_Enabled exception
575: --
576: if p_validate then
577: raise hr_api.validate_enabled;
578: end if;
579: --
580: -- Set all output arguments
581: --
581: --
582: --
583: hr_utility.set_location(' Leaving:'||l_proc, 70);
584: exception
585: when hr_api.validate_enabled then
586: --
587: -- As the Validate_Enabled exception has been raised
588: -- we must rollback to the savepoint
589: --