84:
85: l_type ota_learning_paths.path_source_code%type;
86:
87: begin
88: hr_utility.set_location('Entering:'|| l_proc, 10);
89: --
90: -- Issue a savepoint
91: --
92: savepoint CREATE_LP_ENROLLMENT;
312:
313: end if;
314:
315:
316: hr_utility.set_location(' Leaving:'||l_proc, 70);
317: exception
318: when hr_api.validate_enabled then
319: --
320: -- As the Validate_Enabled exception has been raised
327: -- when validation only mode is being used.)
328: --
329: p_lp_enrollment_id := null;
330: p_object_version_number := null;
331: hr_utility.set_location(' Leaving:'||l_proc, 80);
332: when others then
333: --
334: -- A validation or unexpected error has occured
335: --
335: --
336: rollback to CREATE_LP_ENROLLMENT;
337: p_lp_enrollment_id := null;
338: p_object_version_number := null;
339: hr_utility.set_location(' Leaving:'||l_proc, 90);
340: raise;
341: end create_lp_enrollment;
342: -- ----------------------------------------------------------------------------
343: -- |-------------------------< UPDATE_LP_ENROLLMENT >-------------------------|
434: l_type ota_learning_paths.path_source_code%type;
435:
436:
437: begin
438: hr_utility.set_location('Entering:'|| l_proc, 10);
439: --
440: -- Issue a savepoint
441: --
442: savepoint UPDATE_LP_ENROLLMENT;
680: p_lp_enrollment_id => p_lp_enrollment_id,
681: p_event_fired => 'LP_UNSUBSCRIBE');
682: end if;
683:
684: hr_utility.set_location(' Leaving:'||l_proc, 70);
685: exception
686: when hr_api.validate_enabled then
687: --
688: -- As the Validate_Enabled exception has been raised
694: -- (Any key or derived arguments must be set to null
695: -- when validation only mode is being used.)
696: --
697: p_object_version_number := null;
698: hr_utility.set_location(' Leaving:'||l_proc, 80);
699: when others then
700: --
701: -- A validation or unexpected error has occured
702: --
701: -- A validation or unexpected error has occured
702: --
703: rollback to UPDATE_LP_ENROLLMENT;
704: p_object_version_number := l_object_version_number;
705: hr_utility.set_location(' Leaving:'||l_proc, 90);
706: raise;
707: end update_lp_enrollment;
708: --
709: -- ----------------------------------------------------------------------------
722: l_proc varchar2(72) := g_package||'DELETE_LP_ENROLLMENT';
723: --
724: --
725: begin
726: hr_utility.set_location('Entering:'|| l_proc, 10);
727: --
728: -- Issue a savepoint
729: --
730: savepoint DELETE_LP_ENROLLMENT;
779: --
780: -- Set all output arguments
781: --
782: --
783: hr_utility.set_location(' Leaving:'||l_proc, 170);
784: exception
785: when hr_api.validate_enabled then
786: --
787: -- As the Validate_Enabled exception has been raised
792: -- Only set output warning arguments
793: -- (Any key or derived arguments must be set to null
794: -- when validation only mode is being used.)
795: --
796: hr_utility.set_location(' Leaving:'||l_proc, 180);
797: when others then
798: --
799: -- A validation or unexpected error has occured
800: --
798: --
799: -- A validation or unexpected error has occured
800: --
801: rollback to DELETE_LP_ENROLLMENT;
802: hr_utility.set_location(' Leaving:'||l_proc, 190);
803: raise;
804: end delete_lp_enrollment;
805: --
806: -- ----------------------------------------------------------------------------
1169: -- Reset IN OUT parameters and set OUT parameters
1170: --
1171: p_lp_enrollment_id := null;
1172: p_path_status_code := null;
1173: hr_utility.set_location(' Leaving:' || l_proc, 30);
1174:
1175: when others then
1176: --
1177: -- A validation or unexpected error has occured
1182: --
1183: p_lp_enrollment_id := null;
1184: p_path_status_code := null;
1185:
1186: hr_utility.set_location(' Leaving:' || l_proc,50);
1187: raise;
1188: END subscribe_to_learning_path;
1189: end ota_lp_enrollment_api;
1190: