APPS.OTA_CERT_PRD_ENROLLMENT_API dependencies on HR_UTILITY

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

52: l_object_version_number number;
53: l_effective_date date;
54:
55: begin
56: hr_utility.set_location('Entering:'|| l_proc, 10);
57: --
58: -- Issue a savepoint
59: --
60: savepoint CREATE_cert_prd_enrollment;

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

194: if p_validate then
195: raise hr_api.validate_enabled;
196: end if;
197:
198: hr_utility.set_location(' Leaving:'||l_proc, 70);
199: exception
200: when hr_api.validate_enabled then
201: --
202: -- As the Validate_Enabled exception has been raised

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

209: -- when validation only mode is being used.)
210: --
211: p_cert_prd_enrollment_id := null;
212: p_object_version_number := null;
213: hr_utility.set_location(' Leaving:'||l_proc, 80);
214: when others then
215: --
216: -- A validation or unexpected error has occured
217: --

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

217: --
218: rollback to CREATE_cert_prd_enrollment;
219: p_cert_prd_enrollment_id := null;
220: p_object_version_number := null;
221: hr_utility.set_location(' Leaving:'||l_proc, 90);
222: raise;
223: end create_cert_prd_enrollment;
224: -- ----------------------------------------------------------------------------
225: -- |-------------------------< UPDATE_cert_prd_enrollment >-------------------------|

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

327: l_cert_period_end_date date :=p_cert_period_end_date;
328:
329:
330: begin
331: hr_utility.set_location('Entering:'|| l_proc, 10);
332: --
333: -- Issue a savepoint
334: --
335: savepoint UPDATE_cert_prd_enrollment;

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

621: -- Set all output arguments
622: --
623: p_object_version_number := l_object_version_number;
624:
625: hr_utility.set_location(' Leaving:'||l_proc, 70);
626: exception
627: when hr_api.validate_enabled then
628: --
629: -- As the Validate_Enabled exception has been raised

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

635: -- (Any key or derived arguments must be set to null
636: -- when validation only mode is being used.)
637: --
638: p_object_version_number := null;
639: hr_utility.set_location(' Leaving:'||l_proc, 80);
640: when others then
641: --
642: -- A validation or unexpected error has occured
643: --

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

642: -- A validation or unexpected error has occured
643: --
644: rollback to UPDATE_cert_prd_enrollment;
645: p_object_version_number := l_object_version_number;
646: hr_utility.set_location(' Leaving:'||l_proc, 90);
647: raise;
648: end update_cert_prd_enrollment;
649: --
650: -- ----------------------------------------------------------------------------

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

663: l_proc varchar2(72) := g_package||'DELETE_cert_prd_enrollment';
664: --
665: --
666: begin
667: hr_utility.set_location('Entering:'|| l_proc, 10);
668: --
669: -- Issue a savepoint
670: --
671: savepoint DELETE_cert_prd_enrollment;

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

720: --
721: -- Set all output arguments
722: --
723: --
724: hr_utility.set_location(' Leaving:'||l_proc, 170);
725: exception
726: when hr_api.validate_enabled then
727: --
728: -- As the Validate_Enabled exception has been raised

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

733: -- Only set output warning arguments
734: -- (Any key or derived arguments must be set to null
735: -- when validation only mode is being used.)
736: --
737: hr_utility.set_location(' Leaving:'||l_proc, 180);
738: when others then
739: --
740: -- A validation or unexpected error has occured
741: --

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

739: --
740: -- A validation or unexpected error has occured
741: --
742: rollback to DELETE_cert_prd_enrollment;
743: hr_utility.set_location(' Leaving:'||l_proc, 190);
744: raise;
745: end delete_cert_prd_enrollment;
746:
747: -- ----------------------------------------------------------------------------

Line 865: hr_utility.set_location(' Leaving:' || l_proc, 30);

861: -- Reset IN OUT parameters and set OUT parameters
862: --
863: p_cert_prd_enrollment_id := null;
864: p_certification_status_code := null;
865: hr_utility.set_location(' Leaving:' || l_proc, 30);
866:
867: when others then
868: --
869: -- A validation or unexpected error has occured

Line 878: hr_utility.set_location(' Leaving:' || l_proc,50);

874: --
875: p_cert_prd_enrollment_id := null;
876: p_certification_status_code := null;
877:
878: hr_utility.set_location(' Leaving:' || l_proc,50);
879: raise;
880: END renew_cert_prd_enrollment;
881: --
882: end OTA_CERT_PRD_ENROLLMENT_api;