DBA Data[Home] [Help]

APPS.BEN_ELIG_OTHR_PTIP_PRTE_API dependencies on HR_UTILITY

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

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

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

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

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

246: p_base_table_reference_column => 'ELIG_PTIP_PRTE_FLAG',
247: p_reference_table => 'BEN_ELIG_OTHR_PTIP_PRTE_F',
248: p_reference_table_column => 'ELIGY_PRFL_ID');
249: --
250: hr_utility.set_location(l_proc, 60);
251: --
252: -- When in validation only mode raise the Validate_Enabled exception
253: --
254: if p_validate then

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

261: p_effective_start_date := l_effective_start_date;
262: p_effective_end_date := l_effective_end_date;
263: p_object_version_number := l_object_version_number;
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 70);
266: --
267: exception
268: --
269: when hr_api.validate_enabled then

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

280: p_elig_othr_ptip_prte_id := null;
281: p_effective_start_date := null;
282: p_effective_end_date := null;
283: p_object_version_number := null;
284: hr_utility.set_location(' Leaving:'||l_proc, 80);
285: --
286: when others then
287: --
288: -- A validation or unexpected error has occured

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

357: l_effective_end_date ben_elig_othr_ptip_prte_f.effective_end_date%TYPE;
358: --
359: begin
360: --
361: hr_utility.set_location('Entering:'|| l_proc, 10);
362: --
363: -- Issue a savepoint if operating in validation only mode
364: --
365: savepoint update_ELIG_OTHR_PTIP_PRTE;

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

363: -- Issue a savepoint if operating in validation only mode
364: --
365: savepoint update_ELIG_OTHR_PTIP_PRTE;
366: --
367: hr_utility.set_location(l_proc, 20);
368: --
369: -- Process Logic
370: --
371: l_object_version_number := p_object_version_number;

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

536: -- End of API User Hook for the after hook of update_ELIG_OTHR_PTIP_PRTE
537: --
538: end;
539: --
540: hr_utility.set_location(l_proc, 60);
541: --
542: -- When in validation only mode raise the Validate_Enabled exception
543: --
544: if p_validate then

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

550: p_object_version_number := l_object_version_number;
551: p_effective_start_date := l_effective_start_date;
552: p_effective_end_date := l_effective_end_date;
553: --
554: hr_utility.set_location(' Leaving:'||l_proc, 70);
555: --
556: exception
557: --
558: when hr_api.validate_enabled then

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

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

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

606: l_effective_end_date ben_elig_othr_ptip_prte_f.effective_end_date%TYPE;
607: --
608: begin
609: --
610: hr_utility.set_location('Entering:'|| l_proc, 10);
611: --
612: -- Issue a savepoint if operating in validation only mode
613: --
614: savepoint delete_ELIG_OTHR_PTIP_PRTE;

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

612: -- Issue a savepoint if operating in validation only mode
613: --
614: savepoint delete_ELIG_OTHR_PTIP_PRTE;
615: --
616: hr_utility.set_location(l_proc, 20);
617: --
618: -- Process Logic
619: --
620: l_object_version_number := p_object_version_number;

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

684: p_base_table_reference_column => 'ELIG_PTIP_PRTE_FLAG',
685: p_reference_table => 'BEN_ELIG_OTHR_PTIP_PRTE_F',
686: p_reference_table_column => 'ELIGY_PRFL_ID');
687: --
688: hr_utility.set_location(l_proc, 60);
689: --
690: -- When in validation only mode raise the Validate_Enabled exception
691: --
692: if p_validate then

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

692: if p_validate then
693: raise hr_api.validate_enabled;
694: end if;
695: --
696: hr_utility.set_location(' Leaving:'||l_proc, 70);
697: --
698: exception
699: --
700: when hr_api.validate_enabled then

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

750: l_validation_end_date date;
751: --
752: begin
753: --
754: hr_utility.set_location('Entering:'|| l_proc, 10);
755: --
756: ben_eoy_shd.lck
757: (
758: p_elig_othr_ptip_prte_id => p_elig_othr_ptip_prte_id

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

762: ,p_effective_date => p_effective_date
763: ,p_datetrack_mode => p_datetrack_mode
764: );
765: --
766: hr_utility.set_location(' Leaving:'||l_proc, 70);
767: --
768: end lck;
769: --
770: end ben_ELIG_OTHR_PTIP_PRTE_api;