DBA Data[Home] [Help]

APPS.PER_QUALIFICATIONS_API dependencies on HR_UTILITY

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

101: l_projected_completion_date date;
102: l_language_code varchar2(30);
103:
104: begin
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Issue a savepoint
108: --
109: savepoint CREATE_QUALIFICATION;

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

404: --
405: p_qualification_id := l_qualification_id;
406: p_object_version_number := l_object_version_number;
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 70);
409: exception
410: when hr_Api.validate_enabled then
411: --
412: -- As the Validate_Enabled exception has been raised

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

419: -- when validation only mode is being used.)
420: --
421: p_qualification_id := null;
422: p_object_version_number := null;
423: hr_utility.set_location(' Leaving:'||l_proc, 80);
424: when others then
425: --
426: -- A validation or unexpected error has occured
427: --

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

429: --
430: p_qualification_id := null;
431: p_object_version_number := null;
432: --
433: hr_utility.set_location(' Leaving:'||l_proc, 90);
434: raise;
435: end CREATE_QUALIFICATION;
436: --
437: -- ----------------------------------------------------------------------------

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

527: l_language_code varchar2(30);
528: l_temp_ovn number;
529:
530: begin
531: hr_utility.set_location('Entering:'|| l_proc, 10);
532: --
533: -- Issue a savepoint
534: --
535: savepoint UPDATE_QUALIFICATION;

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

826: --
827: -- Set all output arguements
828: --
829: p_object_version_number := l_object_version_number;
830: hr_utility.set_location(' Leaving:'||l_proc, 70);
831: exception
832: when hr_Api.validate_enabled then
833: --
834: -- As the Validate_Enabled exception has been raised

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

839: -- Only set output warning arguments
840: -- (Any key or derived arguments must be set to null
841: -- when validation only mode is being used.)
842: --
843: hr_utility.set_location(' Leaving:'||l_proc, 80);
844: when others then
845: --
846: -- A validation or unexpected error has occured
847: --

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

846: -- A validation or unexpected error has occured
847: --
848: p_object_version_number := l_temp_ovn;
849: rollback to UPDATE_QUALIFICATION;
850: hr_utility.set_location(' Leaving:'||l_proc, 90);
851: raise;
852: end UPDATE_QUALIFICATION;
853:
854: --

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

874:
875: l_person_id number := -1;
876:
877: begin
878: hr_utility.set_location('Entering:'|| l_proc, 10);
879:
880: OPEN get_person_info;
881: FETCH get_person_info INTO l_person_id;
882: CLOSE get_person_info;

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

938: if p_validate then
939: raise hr_Api.validate_enabled;
940: end if;
941: --
942: hr_utility.set_location(' Leaving:'||l_proc, 70);
943: exception
944: when hr_Api.validate_enabled then
945: --
946: -- As the Validate_Enabled exception has been raised

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

947: -- we must rollback to the savepoint
948: --
949: rollback to DELETE_QUALIFICATION;
950: --
951: hr_utility.set_location(' Leaving:'||l_proc, 80);
952: when others then
953: --
954: -- A validation or unexpected error has occured
955: --

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

953: --
954: -- A validation or unexpected error has occured
955: --
956: rollback to DELETE_QUALIFICATION;
957: hr_utility.set_location(' Leaving:'||l_proc, 90);
958: raise;
959: end DELETE_QUALIFICATION;
960:
961: end PER_QUALIFICATIONS_API;