APPS.OTA_CERTIFICATION_API dependencies on HR_UTILITY

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

87: l_certification_id number;
88: l_object_version_number number;
89: l_effective_date date;
90: begin
91: hr_utility.set_location('Entering:'|| l_proc, 10);
92: --
93: -- Issue a savepoint
94: --
95: savepoint CREATE_CERTIFICATION;

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

284: if p_validate then
285: raise hr_api.validate_enabled;
286: end if;
287:
288: hr_utility.set_location(' Leaving:'||l_proc, 70);
289: exception
290: when hr_api.validate_enabled then
291: --
292: -- As the Validate_Enabled exception has been raised

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

299: -- when validation only mode is being used.)
300: --
301: p_certification_id := null;
302: p_object_version_number := null;
303: hr_utility.set_location(' Leaving:'||l_proc, 80);
304: when others then
305: --
306: -- A validation or unexpected error has occured
307: --

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

307: --
308: rollback to CREATE_CERTIFICATION;
309: p_certification_id := null;
310: p_object_version_number := null;
311: hr_utility.set_location(' Leaving:'||l_proc, 90);
312: raise;
313: end create_certification;
314: -- ----------------------------------------------------------------------------
315: -- |-------------------------< UPDATE_LEARNING_PATH >-------------------------|

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

371: l_certification_id number;
372: l_object_version_number number;
373: l_effective_date date;
374: begin
375: hr_utility.set_location('Entering:'|| l_proc, 10);
376: --
377: -- Issue a savepoint
378: --
379: savepoint UPDATE_CERTIFICATION;

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

566: if p_validate then
567: raise hr_api.validate_enabled;
568: end if;
569:
570: hr_utility.set_location(' Leaving:'||l_proc, 70);
571: exception
572: when hr_api.validate_enabled then
573: --
574: -- As the Validate_Enabled exception has been raised

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

580: -- (Any key or derived arguments must be set to null
581: -- when validation only mode is being used.)
582: --
583: p_object_version_number := null;
584: hr_utility.set_location(' Leaving:'||l_proc, 80);
585: when others then
586: --
587: -- A validation or unexpected error has occured
588: --

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

587: -- A validation or unexpected error has occured
588: --
589: rollback to UPDATE_CERTIFICATION;
590: p_object_version_number := null;
591: hr_utility.set_location(' Leaving:'||l_proc, 90);
592: raise;
593: end update_certification;
594:
595: --

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

609: l_proc varchar2(72) := g_package||' Delete Certification';
610: --
611: --
612: begin
613: hr_utility.set_location('Entering:'|| l_proc, 10);
614: --
615: -- Issue a savepoint
616: --
617: savepoint DELETE_CERTIFICATION;

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

667: --
668: -- Set all output arguments
669: --
670: --
671: hr_utility.set_location(' Leaving:'||l_proc, 170);
672: exception
673: when hr_api.validate_enabled then
674: --
675: -- As the Validate_Enabled exception has been raised

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

675: -- As the Validate_Enabled exception has been raised
676: -- we must rollback to the savepoint
677: --
678: rollback to DELETE_CERTIFICATION;
679: hr_utility.set_location(' Leaving:'||l_proc, 190);
680: raise;
681: end delete_certification;
682: --
683: end ota_certification_api;