DBA Data[Home] [Help]

APPS.OTA_LP_MEMBER_ENROLLMENT_API dependencies on HR_UTILITY

Line 76: hr_utility.set_location('Entering:'|| l_proc, 10);

72: FROM ota_learning_path_members
73: WHERE learning_path_member_id = p_learning_path_member_id;
74:
75: begin
76: hr_utility.set_location('Entering:'|| l_proc, 10);
77: --
78: -- Issue a savepoint
79: --
80: savepoint CREATE_LP_MEMBER_ENROLLMENT;

Line 262: hr_utility.set_location(' Leaving:'||l_proc, 70);

258: if p_validate then
259: raise hr_api.validate_enabled;
260: end if;
261:
262: hr_utility.set_location(' Leaving:'||l_proc, 70);
263: exception
264: when hr_api.validate_enabled then
265: --
266: -- As the Validate_Enabled exception has been raised

Line 277: hr_utility.set_location(' Leaving:'||l_proc, 80);

273: -- when validation only mode is being used.)
274: --
275: p_lp_member_enrollment_id := null;
276: p_object_version_number := null;
277: hr_utility.set_location(' Leaving:'||l_proc, 80);
278: when others then
279: --
280: -- A validation or unexpected error has occured
281: --

Line 285: hr_utility.set_location(' Leaving:'||l_proc, 90);

281: --
282: rollback to CREATE_LP_MEMBER_ENROLLMENT;
283: p_lp_member_enrollment_id := null;
284: p_object_version_number := null;
285: hr_utility.set_location(' Leaving:'||l_proc, 90);
286: raise;
287: end create_lp_member_enrollment;
288: -- ----------------------------------------------------------------------------
289: -- |-------------------------< UPDATE_LP_MEMBER_ENROLLMENT >-------------------------|

Line 361: hr_utility.set_location('Entering:'|| l_proc, 10);

357: AND lme.learning_path_member_id = lpm.learning_path_member_id;
358:
359:
360: begin
361: hr_utility.set_location('Entering:'|| l_proc, 10);
362: --
363: -- Issue a savepoint
364: --
365: savepoint UPDATE_LP_MEMBER_ENROLLMENT;

Line 558: hr_utility.set_location(' Leaving:'||l_proc, 70);

554: -- Set all output arguments
555: --
556: p_object_version_number := l_object_version_number;
557:
558: hr_utility.set_location(' Leaving:'||l_proc, 70);
559: exception
560: when hr_api.validate_enabled then
561: --
562: -- As the Validate_Enabled exception has been raised

Line 572: hr_utility.set_location(' Leaving:'||l_proc, 80);

568: -- (Any key or derived arguments must be set to null
569: -- when validation only mode is being used.)
570: --
571: p_object_version_number := null;
572: hr_utility.set_location(' Leaving:'||l_proc, 80);
573: when others then
574: --
575: -- A validation or unexpected error has occured
576: --

Line 579: hr_utility.set_location(' Leaving:'||l_proc, 90);

575: -- A validation or unexpected error has occured
576: --
577: rollback to UPDATE_LP_MEMBER_ENROLLMENT;
578: p_object_version_number := l_object_version_number;
579: hr_utility.set_location(' Leaving:'||l_proc, 90);
580: raise;
581: end update_lp_member_enrollment;
582: --
583: -- ----------------------------------------------------------------------------

Line 599: hr_utility.set_location('Entering:'|| l_proc, 10);

595: l_proc varchar2(72) := g_package||'DELETE_LP_MEMBER_ENROLLMENT';
596: --
597: --
598: begin
599: hr_utility.set_location('Entering:'|| l_proc, 10);
600: --
601: -- Issue a savepoint
602: --
603: savepoint DELETE_LP_MEMBER_ENROLLMENT;

Line 656: hr_utility.set_location(' Leaving:'||l_proc, 170);

652: --
653: -- Set all output arguments
654: --
655: --
656: hr_utility.set_location(' Leaving:'||l_proc, 170);
657: exception
658: when hr_api.validate_enabled then
659: --
660: -- As the Validate_Enabled exception has been raised

Line 669: hr_utility.set_location(' Leaving:'||l_proc, 180);

665: -- Only set output warning arguments
666: -- (Any key or derived arguments must be set to null
667: -- when validation only mode is being used.)
668: --
669: hr_utility.set_location(' Leaving:'||l_proc, 180);
670: when others then
671: --
672: -- A validation or unexpected error has occured
673: --

Line 675: hr_utility.set_location(' Leaving:'||l_proc, 190);

671: --
672: -- A validation or unexpected error has occured
673: --
674: rollback to DELETE_LP_MEMBER_ENROLLMENT;
675: hr_utility.set_location(' Leaving:'||l_proc, 190);
676: raise;
677: end delete_lp_member_enrollment;
678: --
679: end ota_lp_member_enrollment_api;