DBA Data[Home] [Help]

APPS.BEN_PRTL_MO_RT_PRTN_VAL_API dependencies on HR_UTILITY

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

71: l_object_version_number ben_prtl_mo_rt_prtn_val_f.object_version_number%TYPE;
72: --
73: begin
74: --
75: hr_utility.set_location('Entering:'|| l_proc, 10);
76: --
77: -- Issue a savepoint if operating in validation only mode
78: --
79: savepoint create_Prtl_Mo_Rt_Prtn_Val;

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

77: -- Issue a savepoint if operating in validation only mode
78: --
79: savepoint create_Prtl_Mo_Rt_Prtn_Val;
80: --
81: hr_utility.set_location(l_proc, 20);
82: --
83: -- Process Logic
84: --
85: begin

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

265: -- End of API User Hook for the after hook of create_Prtl_Mo_Rt_Prtn_Val
266: --
267: end;
268: --
269: hr_utility.set_location(l_proc, 60);
270: --
271: -- When in validation only mode raise the Validate_Enabled exception
272: --
273: if p_validate then

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

280: p_effective_end_date := l_effective_end_date;
281: p_effective_start_date := l_effective_start_date;
282: p_object_version_number := l_object_version_number;
283: --
284: hr_utility.set_location(' Leaving:'||l_proc, 70);
285: --
286: exception
287: --
288: when hr_api.validate_enabled then

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

299: p_prtl_mo_rt_prtn_val_id := null;
300: p_effective_end_date := null;
301: p_effective_start_date := null;
302: p_object_version_number := null;
303: hr_utility.set_location(' Leaving:'||l_proc, 80);
304: --
305: when others then
306: --
307: -- A validation or unexpected error has occured

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

376: l_effective_start_date ben_prtl_mo_rt_prtn_val_f.effective_start_date%TYPE;
377: --
378: begin
379: --
380: hr_utility.set_location('Entering:'|| l_proc, 10);
381: --
382: -- Issue a savepoint if operating in validation only mode
383: --
384: savepoint update_Prtl_Mo_Rt_Prtn_Val;

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

382: -- Issue a savepoint if operating in validation only mode
383: --
384: savepoint update_Prtl_Mo_Rt_Prtn_Val;
385: --
386: hr_utility.set_location(l_proc, 20);
387: --
388: -- Process Logic
389: --
390: l_object_version_number := p_object_version_number;

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

576: -- End of API User Hook for the after hook of update_Prtl_Mo_Rt_Prtn_Val
577: --
578: end;
579: --
580: hr_utility.set_location(l_proc, 60);
581: --
582: -- When in validation only mode raise the Validate_Enabled exception
583: --
584: if p_validate then

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

590: p_object_version_number := l_object_version_number;
591: p_effective_end_date := l_effective_end_date;
592: p_effective_start_date := l_effective_start_date;
593: --
594: hr_utility.set_location(' Leaving:'||l_proc, 70);
595: --
596: exception
597: --
598: when hr_api.validate_enabled then

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

605: -- Only set output warning arguments
606: -- (Any key or derived arguments must be set to null
607: -- when validation only mode is being used.)
608: --
609: hr_utility.set_location(' Leaving:'||l_proc, 80);
610: --
611: when others then
612: --
613: -- A validation or unexpected error has occured

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

638: l_effective_start_date ben_prtl_mo_rt_prtn_val_f.effective_start_date%TYPE;
639: --
640: begin
641: --
642: hr_utility.set_location('Entering:'|| l_proc, 10);
643: --
644: -- Issue a savepoint if operating in validation only mode
645: --
646: savepoint delete_Prtl_Mo_Rt_Prtn_Val;

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

644: -- Issue a savepoint if operating in validation only mode
645: --
646: savepoint delete_Prtl_Mo_Rt_Prtn_Val;
647: --
648: hr_utility.set_location(l_proc, 20);
649: --
650: -- Process Logic
651: --
652: l_object_version_number := p_object_version_number;

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

707: -- End of API User Hook for the after hook of delete_Prtl_Mo_Rt_Prtn_Val
708: --
709: end;
710: --
711: hr_utility.set_location(l_proc, 60);
712: --
713: -- When in validation only mode raise the Validate_Enabled exception
714: --
715: if p_validate then

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

715: if p_validate then
716: raise hr_api.validate_enabled;
717: end if;
718: --
719: hr_utility.set_location(' Leaving:'||l_proc, 70);
720: --
721: exception
722: --
723: when hr_api.validate_enabled then

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

765: l_validation_end_date date;
766: --
767: begin
768: --
769: hr_utility.set_location('Entering:'|| l_proc, 10);
770: --
771: ben_ppv_shd.lck
772: (
773: p_prtl_mo_rt_prtn_val_id => p_prtl_mo_rt_prtn_val_id

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

777: ,p_effective_date => p_effective_date
778: ,p_datetrack_mode => p_datetrack_mode
779: );
780: --
781: hr_utility.set_location(' Leaving:'||l_proc, 70);
782: --
783: end lck;
784: --
785: procedure update_old_rows

Line 818: hr_utility.set_location('Update old rows',1);

814: l_effective_end_date date;
815: --
816: begin
817: --
818: hr_utility.set_location('Update old rows',1);
819: open c_ppv;
820: loop
821: fetch c_ppv into l_ppv;
822: if c_ppv%notfound then

Line 840: hr_utility.set_location ('ID '||l_ppv2.prtl_mo_rt_prtn_val_id,9);

836: l_delete_mode := hr_api.g_delete;
837: l_effective_date := p_effective_date -1 ;
838: end if;
839: --
840: hr_utility.set_location ('ID '||l_ppv2.prtl_mo_rt_prtn_val_id,9);
841: delete_Prtl_Mo_Rt_Prtn_Val
842: (
843: p_prtl_mo_rt_prtn_val_id => l_ppv2.prtl_mo_rt_prtn_val_id
844: ,p_effective_end_date => l_effective_end_date

Line 854: hr_utility.set_location ('Leaving - Update old rows',10);

850:
851: end loop;
852: close c_ppv;
853: --
854: hr_utility.set_location ('Leaving - Update old rows',10);
855: end;
856:
857:
858: end ben_Prtl_Mo_Rt_Prtn_Val_api;