APPS.PQH_SITUATIONS_API dependencies on HR_UTILITY

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

95: l_situation_id pqh_situations.situation_id%TYPE;
96: l_object_version_number pqh_situations.object_version_number%TYPE;
97: --
98: begin
99: hr_utility.set_location('Entering:'|| l_proc, 10);
100: --
101: -- Issue a savepoint
102: --
103: savepoint CREATE_SITUATION;

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

378: --
379: p_situation_id := l_situation_id;
380: p_object_version_number := l_object_version_number;
381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 70);
383: exception
384: when hr_api.validate_enabled then
385: --
386: -- As the Validate_Enabled exception has been raised

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

393: -- when validation only mode is being used.)
394: --
395: p_situation_id := null;
396: p_object_version_number := null;
397: hr_utility.set_location(' Leaving:'||l_proc, 80);
398: when others then
399: p_situation_id := null;
400: p_object_version_number := null;
401: --

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

401: --
402: -- A validation or unexpected error has occured
403: --
404: rollback to CREATE_SITUATION;
405: hr_utility.set_location(' Leaving:'||l_proc, 90);
406: raise;
407: end create_situation;
408: --
409: --

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

496: l_proc varchar2(72) := g_package||'UPDATE_SITUATION';
497: l_object_version_number number := p_object_version_number;
498: --
499: begin
500: hr_utility.set_location('Entering:'|| l_proc, 10);
501: --
502: -- Issue a savepoint
503: --
504: savepoint UPDATE_SITUATION;

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

780: -- Set all output arguments
781: --
782: p_object_version_number := p_object_version_number;
783: --
784: hr_utility.set_location(' Leaving:'||l_proc, 70);
785: exception
786: when hr_api.validate_enabled then
787: --
788: -- As the Validate_Enabled exception has been raised

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

794: -- (Any key or derived arguments must be set to null
795: -- when validation only mode is being used.)
796: --
797: p_object_version_number := p_object_version_number;
798: hr_utility.set_location(' Leaving:'||l_proc, 80);
799: when others then
800: p_object_version_number := l_object_version_number;
801: --
802: -- A validation or unexpected error has occured

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

801: --
802: -- A validation or unexpected error has occured
803: --
804: rollback to UPDATE_SITUATION;
805: hr_utility.set_location(' Leaving:'||l_proc, 90);
806: raise;
807: end update_situation;
808: --
809: --

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

822:
823: l_proc varchar2(72) := g_package||'DELETE_SITUATION';
824: --
825: begin
826: hr_utility.set_location('Entering:'|| l_proc, 10);
827: --
828: -- Issue a savepoint
829: --
830: savepoint DELETE_SITUATION;

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

886: --
887: -- Set all output arguments
888: --
889: --
890: hr_utility.set_location(' Leaving:'||l_proc, 70);
891: exception
892: when hr_api.validate_enabled then
893: --
894: -- As the Validate_Enabled exception has been raised

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

899: -- Only set output warning arguments
900: -- (Any key or derived arguments must be set to null
901: -- when validation only mode is being used.)
902: --
903: hr_utility.set_location(' Leaving:'||l_proc, 80);
904: when others then
905: --
906: -- A validation or unexpected error has occured
907: --

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

905: --
906: -- A validation or unexpected error has occured
907: --
908: rollback to DELETE_SITUATION;
909: hr_utility.set_location(' Leaving:'||l_proc, 90);
910: raise;
911: end delete_situation;
912: --
913: end pqh_situations_api;