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 871: hr_utility.set_location('Entering:'|| l_proc, 10);

867: l_proc varchar2(72) := g_package||'delete_qualification';
868: l_object_version_number number(9) := p_object_version_number;
869:
870: begin
871: hr_utility.set_location('Entering:'|| l_proc, 10);
872: --
873: -- Issue a savepoint
874: --
875: savepoint DELETE_QUALIFICATION;

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

926: if p_validate then
927: raise hr_Api.validate_enabled;
928: end if;
929: --
930: hr_utility.set_location(' Leaving:'||l_proc, 70);
931: exception
932: when hr_Api.validate_enabled then
933: --
934: -- As the Validate_Enabled exception has been raised

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

935: -- we must rollback to the savepoint
936: --
937: rollback to DELETE_QUALIFICATION;
938: --
939: hr_utility.set_location(' Leaving:'||l_proc, 80);
940: when others then
941: --
942: -- A validation or unexpected error has occured
943: --

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

941: --
942: -- A validation or unexpected error has occured
943: --
944: rollback to DELETE_QUALIFICATION;
945: hr_utility.set_location(' Leaving:'||l_proc, 90);
946: raise;
947: end DELETE_QUALIFICATION;
948:
949: end PER_QUALIFICATIONS_API;