DBA Data[Home] [Help]

APPS.BEN_EMPLOYEE_STATUS_RT_API dependencies on HR_UTILITY

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

63: l_object_version_number ben_ee_stat_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_EMPLOYEE_STATUS_RT;

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

69: -- Issue a savepoint if operating in validation only mode
70: --
71: savepoint create_EMPLOYEE_STATUS_RT;
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_EE_STAT_FLAG',
243: p_reference_table => 'BEN_EE_STAT_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_ee_stat_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 292: hr_utility.set_location(' Leaving:'||l_proc, 80);

288: p_ee_stat_rt_id := null;
289: p_effective_start_date := null;
290: p_effective_end_date := null;
291: p_object_version_number := null;
292: hr_utility.set_location(' Leaving:'||l_proc, 80);
293: --
294: raise;
295: --
296: end create_EMPLOYEE_STATUS_RT;

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

352: l_effective_end_date ben_ee_stat_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_EMPLOYEE_STATUS_RT;

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

358: -- Issue a savepoint if operating in validation only mode
359: --
360: savepoint update_EMPLOYEE_STATUS_RT;
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_EMPLOYEE_STATUS_RT
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 561: hr_utility.set_location(' Leaving:'||l_proc, 80);

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

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

568: --
569: p_effective_start_date := null;
570: p_effective_end_date := null;
571: p_object_version_number := l_object_version_number;
572: hr_utility.set_location(' Leaving:'||l_proc, 80);
573: --
574: raise;
575: --
576: end update_EMPLOYEE_STATUS_RT;

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

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

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

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

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

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

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

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

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

709: --
710: p_effective_start_date := null;
711: p_effective_end_date := null;
712: p_object_version_number := l_object_version_number;
713: hr_utility.set_location(' Leaving:'||l_proc, 80);
714: --
715: raise;
716: --
717: end delete_EMPLOYEE_STATUS_RT;

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

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

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

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