50: l_object_version_number number;
51: l_effective_date date;
52:
53: begin
54: hr_utility.set_location('Entering:'|| l_proc, 10);
55: --
56: -- Issue a savepoint
57: --
58: savepoint create_act_cat_inclusion;
198: --
199: --
200: p_object_version_number := l_object_version_number;
201: --
202: hr_utility.set_location(' Leaving:'||l_proc, 70);
203: exception
204: when hr_api.validate_enabled then
205: --
206: -- As the Validate_Enabled exception has been raised
212: -- (Any key or derived arguments must be set to null
213: -- when validation only mode is being used.)
214: --
215: p_object_version_number := null;
216: hr_utility.set_location(' Leaving:'||l_proc, 80);
217: when others then
218: --
219: -- A validation or unexpected error has occured
220: --
219: -- A validation or unexpected error has occured
220: --
221: rollback to create_act_cat_inclusion;
222: p_object_version_number := null;
223: hr_utility.set_location(' Leaving:'||l_proc, 90);
224: raise;
225: end create_act_cat_inclusion ;
226: -- ----------------------------------------------------------------------------
227: -- |-------------------------< update_act_cat_inclusion >-------------------|
267: l_object_version_number number := p_object_version_number;
268: l_effective_date date;
269:
270: begin
271: hr_utility.set_location('Entering:'|| l_proc, 10);
272: --
273: -- Issue a savepoint
274: --
275: savepoint update_act_cat_inclusion ;
414: -- Set all output arguments
415: --
416: -- p_object_version_number := l_object_version_number;
417: --
418: hr_utility.set_location(' Leaving:'||l_proc, 70);
419: exception
420: when hr_api.validate_enabled then
421: --
422: -- As the Validate_Enabled exception has been raised
428: -- (Any key or derived arguments must be set to null
429: -- when validation only mode is being used.)
430: --
431: p_object_version_number := null;
432: hr_utility.set_location(' Leaving:'||l_proc, 80);
433: when others then
434: --
435: -- A validation or unexpected error has occured
436: --
434: --
435: -- A validation or unexpected error has occured
436: --
437: rollback to update_act_cat_inclusion ;
438: hr_utility.set_location(' Leaving:'||l_proc, 90);
439: p_object_version_number := l_object_version_number;
440: raise;
441: end update_act_cat_inclusion ;
442:
457: --
458: l_proc varchar2(72) := g_package||' delete_act_cat_inclusion ';
459: --
460: begin
461: hr_utility.set_location('Entering:'|| l_proc, 10);
462: --
463: -- Issue a savepoint
464: --
465: savepoint delete_act_cat_inclusion ;
513: --
514: -- Set all output arguments
515: --
516: --
517: hr_utility.set_location(' Leaving:'||l_proc, 170);
518: exception
519: when hr_api.validate_enabled then
520: --
521: -- As the Validate_Enabled exception has been raised
526: -- Only set output warning arguments
527: -- (Any key or derived arguments must be set to null
528: -- when validation only mode is being used.)
529: --
530: hr_utility.set_location(' Leaving:'||l_proc, 180);
531: when others then
532: --
533: -- A validation or unexpected error has occured
534: --
532: --
533: -- A validation or unexpected error has occured
534: --
535: rollback to delete_act_cat_inclusion ;
536: hr_utility.set_location(' Leaving:'||l_proc, 190);
537: raise;
538: end delete_act_cat_inclusion;
539: --
540: end ota_activity_category_api;