DBA Data[Home] [Help]

APPS.GHR_PAR_EXTRA_INFO_API dependencies on HR_UTILITY

Line 122: hr_utility.set_location('Entering:'|| l_proc, 5);

118: l_noa_family_code ghr_pa_requests.noa_family_code%type;
119:
120: begin
121: l_proc := g_package||'create_pa_request_extra_info';
122: hr_utility.set_location('Entering:'|| l_proc, 5);
123: --
124: savepoint create_pa_request_extra_info;
125: --
126: --

Line 196: hr_utility.set_location(l_proc, 7);

192: end;
193: --
194: -- End of Before Process User Hook call
195: --
196: hr_utility.set_location(l_proc, 7);
197: -- Validation
198:
199: FOR l_cur_noa_family_code IN c_noa_family_code(p_pa_request_id) LOOP
200: l_noa_family_code := l_cur_noa_family_code.noa_family_code;

Line 305: hr_utility.set_location(l_proc, 8);

301: ,p_object_version_number => p_object_version_number
302: ,p_validate => false
303: );
304: --
305: hr_utility.set_location(l_proc, 8);
306: --
307: --
308: -- Call After Process User Hook
309: --

Line 386: hr_utility.set_location(' Leaving:'||l_proc, 11);

382: if p_validate then
383: raise hr_api.validate_enabled;
384: end if;
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 11);
387: exception
388: when hr_api.validate_enabled then
389: --
390: -- As the Validate_Enabled exception has been raised

Line 406: hr_utility.set_location(' Leaving:'||l_proc, 12);

402: when others then
403: ROLLBACK TO create_pa_request_extra_info;
404: p_pa_request_extra_info_id := null;
405: p_object_version_number := null;
406: hr_utility.set_location(' Leaving:'||l_proc, 12);
407: raise;
408:
409: end create_pa_request_extra_info;
410: --

Line 495: hr_utility.set_location('Entering:'|| l_proc, 5);

491: WHERE pa_request_extra_info_id = c_pa_req_extra_info_id;
492:
493: begin
494: l_proc := g_package||'update_pa_request_extra_info';
495: hr_utility.set_location('Entering:'|| l_proc, 5);
496: l_obj_version_number := p_object_version_number;
497: --
498: savepoint update_pa_request_extra_info;
499: --

Line 571: hr_utility.set_location(l_proc, 7);

567: end;
568: --
569: -- End of Before Process User Hook call
570: --
571: hr_utility.set_location(l_proc, 7);
572: --
573: -- Store the original ovn in case we rollback when p_validate is true
574: --
575: l_object_version_number := p_object_version_number;

Line 688: hr_utility.set_location(l_proc, 8);

684: ,p_object_version_number => p_object_version_number
685: ,p_validate => false
686: );
687: --
688: hr_utility.set_location(l_proc, 8);
689: --
690: --
691: -- Call After Process User Hook
692: --

Line 768: hr_utility.set_location(' Leaving:'||l_proc, 11);

764: if p_validate then
765: raise hr_api.validate_enabled;
766: end if;
767: --
768: hr_utility.set_location(' Leaving:'||l_proc, 11);
769: exception
770: when hr_api.validate_enabled then
771: --
772: -- As the Validate_Enabled exception has been raised

Line 789: hr_utility.set_location(' Leaving:'||l_proc, 12);

785: ROLLBACK TO update_pa_request_extra_info;
786: p_object_version_number := l_obj_version_number; -- NOCOPY Changes
787: raise;
788: --
789: hr_utility.set_location(' Leaving:'||l_proc, 12);
790: end update_pa_request_extra_info;
791: --
792: --
793: -- ----------------------------------------------------------------------------

Line 809: hr_utility.set_location('Entering:'|| l_proc, 5);

805: l_proc varchar2(72);
806: --
807: begin
808: l_proc := g_package||'delete_pa_request_extra_info';
809: hr_utility.set_location('Entering:'|| l_proc, 5);
810: --
811: savepoint delete_pa_request_extra_info;
812: --
813: --

Line 831: hr_utility.set_location(l_proc, 7);

827: end;
828: --
829: -- End of Before Process User Hook call
830: --
831: hr_utility.set_location(l_proc, 7);
832: --
833: -- Process Logic - Delete pa_request Extra Info details
834: --
835: ghr_rei_del.del

Line 841: hr_utility.set_location(l_proc, 8);

837: ,p_object_version_number => p_object_version_number
838: ,p_validate => false
839: );
840: --
841: hr_utility.set_location(l_proc, 8);
842: --
843: --
844: -- Call After Process User Hook
845: --

Line 867: hr_utility.set_location(' Leaving:'||l_proc, 11);

863: if p_validate then
864: raise hr_api.validate_enabled;
865: end if;
866: --
867: hr_utility.set_location(' Leaving:'||l_proc, 11);
868: exception
869: when hr_api.validate_enabled then
870: --
871: -- As the Validate_Enabled exception has been raised

Line 880: hr_utility.set_location(' Leaving:'||l_proc, 12);

876: when others then
877: ROLLBACK TO delete_pa_request_extra_info;
878: raise;
879:
880: hr_utility.set_location(' Leaving:'||l_proc, 12);
881: end delete_pa_request_extra_info;
882: --
883: --
884:

Line 966: hr_utility.set_location('---------------- Validation starts-------------------------------',1234);

962: IF p_information_type = 'GHR_US_PAR_BENEFITS' THEN
963:
964: IF p_ben_ei_validate = 'TRUE' THEN
965: -- Get PA Request Record details
966: hr_utility.set_location('---------------- Validation starts-------------------------------',1234);
967: FOR l_cur_pa_req IN c_get_pa_req(p_pa_request_id) LOOP
968: l_retirement_plan := l_cur_pa_req.retirement_plan;
969: l_pa_request_id := l_cur_pa_req.pa_request_id;
970: l_effective_date := l_cur_pa_req.effective_date;