DBA Data[Home] [Help]

APPS.BEN_POSTAL_ZIP_RATE_API dependencies on HR_UTILITY

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

63: l_object_version_number ben_pstl_zip_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_POSTAL_ZIP_RATE;

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

69: -- Issue a savepoint if operating in validation only mode
70: --
71: savepoint create_POSTAL_ZIP_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_PSTL_CD_FLAG',
243: p_reference_table => 'BEN_PSTl_ZIP_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_pstl_zip_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 356: hr_utility.set_location('Entering:'|| l_proc, 10);

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

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

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

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

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

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

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

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

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

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

599: l_effective_end_date ben_pstl_zip_rt_f.effective_end_date%TYPE;
600: --
601: begin
602: --
603: hr_utility.set_location('Entering:'|| l_proc, 10);
604: --
605: -- Issue a savepoint if operating in validation only mode
606: --
607: savepoint delete_POSTAL_ZIP_RATE;

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

605: -- Issue a savepoint if operating in validation only mode
606: --
607: savepoint delete_POSTAL_ZIP_RATE;
608: --
609: hr_utility.set_location(l_proc, 20);
610: --
611: -- Process Logic
612: --
613: l_object_version_number := p_object_version_number;

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

677: p_base_table_reference_column => 'RT_PSTL_CD_FLAG',
678: p_reference_table => 'BEN_PSTl_ZIP_RT_F',
679: p_reference_table_column => 'VRBL_RT_PRFL_ID');
680: --
681: hr_utility.set_location(l_proc, 60);
682: --
683: -- When in validation only mode raise the Validate_Enabled exception
684: --
685: if p_validate then

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

685: if p_validate then
686: raise hr_api.validate_enabled;
687: end if;
688: --
689: hr_utility.set_location(' Leaving:'||l_proc, 70);
690: --
691: exception
692: --
693: when hr_api.validate_enabled then

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

739: l_validation_end_date date;
740: --
741: begin
742: --
743: hr_utility.set_location('Entering:'|| l_proc, 10);
744: --
745: ben_pzr_shd.lck
746: (
747: p_pstl_zip_rt_id => p_pstl_zip_rt_id

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

751: ,p_effective_date => p_effective_date
752: ,p_datetrack_mode => p_datetrack_mode
753: );
754: --
755: hr_utility.set_location(' Leaving:'||l_proc, 70);
756: --
757: end lck;
758: --
759: end ben_POSTAL_ZIP_RATE_api;