DBA Data[Home] [Help]

APPS.OTA_LP_MEMBER_ENROLLMENT_API dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

352: AND lme.learning_path_member_id = lpm.learning_path_member_id;
353:
354:
355: begin
356: hr_utility.set_location('Entering:'|| l_proc, 10);
357: --
358: -- Issue a savepoint
359: --
360: savepoint UPDATE_LP_MEMBER_ENROLLMENT;

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

546: -- Set all output arguments
547: --
548: p_object_version_number := l_object_version_number;
549:
550: hr_utility.set_location(' Leaving:'||l_proc, 70);
551: exception
552: when hr_api.validate_enabled then
553: --
554: -- As the Validate_Enabled exception has been raised

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

560: -- (Any key or derived arguments must be set to null
561: -- when validation only mode is being used.)
562: --
563: p_object_version_number := null;
564: hr_utility.set_location(' Leaving:'||l_proc, 80);
565: when others then
566: --
567: -- A validation or unexpected error has occured
568: --

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

567: -- A validation or unexpected error has occured
568: --
569: rollback to UPDATE_LP_MEMBER_ENROLLMENT;
570: p_object_version_number := l_object_version_number;
571: hr_utility.set_location(' Leaving:'||l_proc, 90);
572: raise;
573: end update_lp_member_enrollment;
574: --
575: -- ----------------------------------------------------------------------------

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

587: l_proc varchar2(72) := g_package||'DELETE_LP_MEMBER_ENROLLMENT';
588: --
589: --
590: begin
591: hr_utility.set_location('Entering:'|| l_proc, 10);
592: --
593: -- Issue a savepoint
594: --
595: savepoint DELETE_LP_MEMBER_ENROLLMENT;

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

644: --
645: -- Set all output arguments
646: --
647: --
648: hr_utility.set_location(' Leaving:'||l_proc, 170);
649: exception
650: when hr_api.validate_enabled then
651: --
652: -- As the Validate_Enabled exception has been raised

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

657: -- Only set output warning arguments
658: -- (Any key or derived arguments must be set to null
659: -- when validation only mode is being used.)
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 180);
662: when others then
663: --
664: -- A validation or unexpected error has occured
665: --

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

663: --
664: -- A validation or unexpected error has occured
665: --
666: rollback to DELETE_LP_MEMBER_ENROLLMENT;
667: hr_utility.set_location(' Leaving:'||l_proc, 190);
668: raise;
669: end delete_lp_member_enrollment;
670: --
671: end ota_lp_member_enrollment_api;