[Home] [Help]
68: l_member_status_type_id varchar2(30) := p_member_status_type_id;
69: l_person_id number(15);
70:
71: begin
72: hr_utility.set_location('Entering:'|| l_proc, 10);
73: --
74: -- Issue a savepoint
75: --
76: savepoint create_training_plan_member;
276: --
277: p_training_plan_member_id := l_training_plan_member_id;
278: p_object_version_number := l_object_version_number;
279: --
280: hr_utility.set_location(' Leaving:'||l_proc, 70);
281: exception
282: when hr_api.validate_enabled then
283: --
284: -- As the Validate_Enabled exception has been raised
291: -- when validation only mode is being used.)
292: --
293: p_training_plan_member_id := null;
294: p_object_version_number := null;
295: hr_utility.set_location(' Leaving:'||l_proc, 80);
296: when others then
297: --
298: -- A validation or unexpected error has occured
299: --
299: --
300: rollback to create_training_plan_member;
301: p_training_plan_member_id := null;
302: p_object_version_number := null;
303: hr_utility.set_location(' Leaving:'||l_proc, 90);
304: raise;
305: end create_training_plan_member;
306: -- ----------------------------------------------------------------------------
307: -- |-------------------------< update_training_plan_member >-------------------|
364: l_person_id number(15);
365: l_training_plan_id number(9);
366:
367: begin
368: hr_utility.set_location('Entering:'|| l_proc, 10);
369: --
370: -- Issue a savepoint
371: --
372: savepoint update_training_plan_member;
570: -- Set all output arguments
571: --
572: p_object_version_number := l_object_version_number;
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 70);
575: exception
576: when hr_api.validate_enabled then
577: --
578: -- As the Validate_Enabled exception has been raised
584: -- (Any key or derived arguments must be set to null
585: -- when validation only mode is being used.)
586: --
587: p_object_version_number := null;
588: hr_utility.set_location(' Leaving:'||l_proc, 80);
589: when others then
590: --
591: -- A validation or unexpected error has occured
592: --
590: --
591: -- A validation or unexpected error has occured
592: --
593: rollback to update_training_plan_member;
594: hr_utility.set_location(' Leaving:'||l_proc, 90);
595: p_object_version_number := l_object_version_number;
596: raise;
597: end update_training_plan_member;
598:
611: --
612: l_proc varchar2(72) := g_package||' Delete Training Plan Member';
613: --
614: begin
615: hr_utility.set_location('Entering:'|| l_proc, 10);
616: --
617: -- Issue a savepoint
618: --
619: savepoint delete_training_plan_member;
666: --
667: -- Set all output arguments
668: --
669: --
670: hr_utility.set_location(' Leaving:'||l_proc, 170);
671: exception
672: when hr_api.validate_enabled then
673: --
674: -- As the Validate_Enabled exception has been raised
679: -- Only set output warning arguments
680: -- (Any key or derived arguments must be set to null
681: -- when validation only mode is being used.)
682: --
683: hr_utility.set_location(' Leaving:'||l_proc, 180);
684: when others then
685: --
686: -- A validation or unexpected error has occured
687: --
685: --
686: -- A validation or unexpected error has occured
687: --
688: rollback to delete_training_plan_member;
689: hr_utility.set_location(' Leaving:'||l_proc, 190);
690: raise;
691: end delete_training_plan_member;
692: --
693: end ota_tpm_api;