DBA Data[Home] [Help]

APPS.BEN_BENEFIT_GRP_RATE_API dependencies on HR_UTILITY

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

63: l_object_version_number ben_benfts_grp_rt_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);
68: --
69: -- Issue a savepoint if operating in validation only mode
70: --
71: savepoint create_BENEFIT_GRP_RATE;

Line 73: hr_utility.set_location(l_proc, 20);

69: -- Issue a savepoint if operating in validation only mode
70: --
71: savepoint create_BENEFIT_GRP_RATE;
72: --
73: hr_utility.set_location(l_proc, 20);
74: --
75: -- Process Logic
76: --
77: begin

Line 246: hr_utility.set_location(l_proc, 60);

242: p_base_table_reference_column => 'RT_BENFTS_GRP_FLAG',
243: p_reference_table => 'BEN_BENFTS_GRP_RT_F',
244: p_reference_table_column => 'VRBL_RT_PRFL_ID');
245: --
246: hr_utility.set_location(l_proc, 60);
247: --
248: -- When in validation only mode raise the Validate_Enabled exception
249: --
250: if p_validate then

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

257: p_effective_start_date := l_effective_start_date;
258: p_effective_end_date := l_effective_end_date;
259: p_object_version_number := l_object_version_number;
260: --
261: hr_utility.set_location(' Leaving:'||l_proc, 70);
262: --
263: exception
264: --
265: when hr_api.validate_enabled then

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

276: p_benfts_grp_rt_id := null;
277: p_effective_start_date := null;
278: p_effective_end_date := null;
279: p_object_version_number := null;
280: hr_utility.set_location(' Leaving:'||l_proc, 80);
281: --
282: when others then
283: --
284: -- A validation or unexpected error has occured

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

286: p_benfts_grp_rt_id := null;
287: p_effective_start_date := null;
288: p_effective_end_date := null;
289: p_object_version_number := null;
290: hr_utility.set_location(' Leaving:'||l_proc, 80);
291: --
292: ROLLBACK TO create_BENEFIT_GRP_RATE;
293: raise;
294: --

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

351: l_effective_end_date ben_benfts_grp_rt_f.effective_end_date%TYPE;
352: --
353: begin
354: --
355: hr_utility.set_location('Entering:'|| l_proc, 10);
356: --
357: -- Issue a savepoint if operating in validation only mode
358: --
359: savepoint update_BENEFIT_GRP_RATE;

Line 361: hr_utility.set_location(l_proc, 20);

357: -- Issue a savepoint if operating in validation only mode
358: --
359: savepoint update_BENEFIT_GRP_RATE;
360: --
361: hr_utility.set_location(l_proc, 20);
362: --
363: -- Process Logic
364: --
365: l_object_version_number := p_object_version_number;

Line 531: hr_utility.set_location(l_proc, 60);

527: -- End of API User Hook for the after hook of update_BENEFIT_GRP_RATE
528: --
529: end;
530: --
531: hr_utility.set_location(l_proc, 60);
532: --
533: -- When in validation only mode raise the Validate_Enabled exception
534: --
535: if p_validate then

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

541: p_object_version_number := l_object_version_number;
542: p_effective_start_date := l_effective_start_date;
543: p_effective_end_date := l_effective_end_date;
544: --
545: hr_utility.set_location(' Leaving:'||l_proc, 70);
546: --
547: exception
548: --
549: when hr_api.validate_enabled then

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

556: -- Only set output warning arguments
557: -- (Any key or derived arguments must be set to null
558: -- when validation only mode is being used.)
559: --
560: hr_utility.set_location(' Leaving:'||l_proc, 80);
561: --
562: when others then
563: --
564: -- A validation or unexpected error has occured

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

565: --
566: p_effective_start_date := null;
567: p_effective_end_date := null;
568: p_object_version_number := l_object_version_number;
569: hr_utility.set_location(' Leaving:'||l_proc, 80);
570: --
571: ROLLBACK TO update_BENEFIT_GRP_RATE;
572: raise;
573: --

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

594: l_effective_end_date ben_benfts_grp_rt_f.effective_end_date%TYPE;
595: --
596: begin
597: --
598: hr_utility.set_location('Entering:'|| l_proc, 10);
599: --
600: -- Issue a savepoint if operating in validation only mode
601: --
602: savepoint delete_BENEFIT_GRP_RATE;

Line 604: hr_utility.set_location(l_proc, 20);

600: -- Issue a savepoint if operating in validation only mode
601: --
602: savepoint delete_BENEFIT_GRP_RATE;
603: --
604: hr_utility.set_location(l_proc, 20);
605: --
606: -- Process Logic
607: --
608: l_object_version_number := p_object_version_number;

Line 676: hr_utility.set_location(l_proc, 60);

672: p_base_table_reference_column => 'RT_BENFTS_GRP_FLAG',
673: p_reference_table => 'BEN_BENFTS_GRP_RT_F',
674: p_reference_table_column => 'VRBL_RT_PRFL_ID');
675: --
676: hr_utility.set_location(l_proc, 60);
677: --
678: -- When in validation only mode raise the Validate_Enabled exception
679: --
680: if p_validate then

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

680: if p_validate then
681: raise hr_api.validate_enabled;
682: end if;
683: --
684: hr_utility.set_location(' Leaving:'||l_proc, 70);
685: --
686: exception
687: --
688: when hr_api.validate_enabled then

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

705: --
706: p_effective_start_date := null;
707: p_effective_end_date := null;
708: p_object_version_number := l_object_version_number;
709: hr_utility.set_location(' Leaving:'||l_proc, 80);
710: --
711: ROLLBACK TO delete_BENEFIT_GRP_RATE;
712: raise;
713: --

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

735: l_validation_end_date date;
736: --
737: begin
738: --
739: hr_utility.set_location('Entering:'|| l_proc, 10);
740: --
741: ben_brg_shd.lck
742: (
743: p_benfts_grp_rt_id => p_benfts_grp_rt_id

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

747: ,p_effective_date => p_effective_date
748: ,p_datetrack_mode => p_datetrack_mode
749: );
750: --
751: hr_utility.set_location(' Leaving:'||l_proc, 70);
752: --
753: end lck;
754: --
755: end ben_BENEFIT_GRP_RATE_api;