eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PRTN_ELIG_PRFL_API dependencies on HR_UTILITY

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

78: l_object_version_number ben_prtn_elig_prfl_f.object_version_number%TYPE;
79: --
80: begin
81: --
82: hr_utility.set_location('Entering:'|| l_proc, 10);
83: --
84: -- Issue a savepoint if operating in validation only mode
85: --
86: savepoint create_PRTN_ELIG_PRFL;

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

84: -- Issue a savepoint if operating in validation only mode
85: --
86: savepoint create_PRTN_ELIG_PRFL;
87: --
88: hr_utility.set_location(l_proc, 20);
89: --
90: -- Process Logic
91: --
92: begin

Line 284: hr_utility.set_location(' update of pgm_f ' , 60);

280: where c.business_group_id = p_business_group_id
281: and c.elig_apls_flag <> 'Y'
282: and c.pgm_id = l_pgm_id ;
283: --
284: hr_utility.set_location(' update of pgm_f ' , 60);
285: --
286: elsif l_plip_id is not null then
287: --
288: --updates elig_apls_flag to 'Y' in ben_plip_f table.

Line 295: hr_utility.set_location(' update of plip_f ' , 60);

291: where c.business_group_id = p_business_group_id
292: and c.elig_apls_flag <> 'Y'
293: and c.plip_id = l_plip_id ;
294: --
295: hr_utility.set_location(' update of plip_f ' , 60);
296: --
297: elsif l_ptip_id is not null then
298: --updates elig_apls_flag to 'Y' in ben_ptip_f table.
299: update ben_ptip_f c

Line 304: hr_utility.set_location(' update of ptip_f ' , 60);

300: set c.elig_apls_flag = 'Y'
301: where c.business_group_id = p_business_group_id
302: and c.elig_apls_flag <> 'Y'
303: and c.ptip_id = l_ptip_id ;
304: hr_utility.set_location(' update of ptip_f ' , 60);
305: --
306: elsif l_pl_id is not null then
307: --updates elig_apls_flag to 'Y' in ben_pl_f table.
308: update ben_pl_f c

Line 314: hr_utility.set_location(' update of pl_f ' , 60);

310: where c.business_group_id = p_business_group_id
311: and c.elig_apls_flag <> 'Y'
312: and c.pl_id = l_pl_id ;
313: --
314: hr_utility.set_location(' update of pl_f ' , 60);
315: --
316: elsif l_oipl_id is not null then
317: --updates elig_apls_flag to 'Y' in ben_oipl_f table.
318: update ben_oipl_f c

Line 324: hr_utility.set_location(' update of oipl_f ' , 60);

320: where c.business_group_id = p_business_group_id
321: and c.elig_apls_flag <> 'Y'
322: and c.oipl_id = l_oipl_id ;
323: --
324: hr_utility.set_location(' update of oipl_f ' , 60);
325: end if;
326: --
327: hr_utility.set_location(l_proc, 60);
328: --

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

323: --
324: hr_utility.set_location(' update of oipl_f ' , 60);
325: end if;
326: --
327: hr_utility.set_location(l_proc, 60);
328: --
329: -- When in validation only mode raise the Validate_Enabled exception
330: --
331: if p_validate then

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

358: p_effective_start_date := l_effective_start_date;
359: p_effective_end_date := l_effective_end_date;
360: p_object_version_number := l_object_version_number;
361: --
362: hr_utility.set_location(' Leaving:'||l_proc, 70);
363: --
364: exception
365: --
366: when hr_api.validate_enabled then

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

377: p_prtn_elig_prfl_id := null;
378: p_effective_start_date := null;
379: p_effective_end_date := null;
380: p_object_version_number := null;
381: hr_utility.set_location(' Leaving:'||l_proc, 80);
382: --
383: when others then
384: --
385: -- A validation or unexpected error has occured

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

500: l_drvbl_fctr_prtn_elig_flag varchar2(30) ;
501: --
502: begin
503: --
504: hr_utility.set_location('Entering:'|| l_proc, 10);
505: --
506: -- Issue a savepoint if operating in validation only mode
507: --
508: savepoint update_PRTN_ELIG_PRFL;

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

506: -- Issue a savepoint if operating in validation only mode
507: --
508: savepoint update_PRTN_ELIG_PRFL;
509: --
510: hr_utility.set_location(l_proc, 20);
511: --
512: -- Process Logic
513: --
514: l_object_version_number := p_object_version_number;

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

685: -- End of API User Hook for the after hook of update_PRTN_ELIG_PRFL
686: --
687: end;
688: --
689: hr_utility.set_location(l_proc, 60);
690: --
691: -- When in validation only mode raise the Validate_Enabled exception
692: --
693: if p_validate then

Line 708: hr_utility.set_location( ' old ' || l_old_eligy_prfl_id || ' new ' || p_eligy_prfl_id , 11);

704: -- 1 check whether the old profile id and new profile id is the same , if not
705: -- 2 if the flag is 'Y' and ther is a possibility current may not have the DF, so call in delete mode
706: -- 3 if the flag is 'N' and ther is a possibility current may have the DF, so call in Create mode
707:
708: hr_utility.set_location( ' old ' || l_old_eligy_prfl_id || ' new ' || p_eligy_prfl_id , 11);
709: if l_old_eligy_prfl_id <> p_eligy_prfl_id then
710: open c1 ;
711: fetch c1 into l_c1;
712: close c1;

Line 719: hr_utility.set_location( ' old pgm flag ' || l_drvbl_fctr_prtn_elig_flag , 11);

715: open c_pgm_flag(l_c1.pgm_id) ;
716: fetch c_pgm_flag into l_drvbl_fctr_prtn_elig_flag ;
717: close c_pgm_flag ;
718:
719: hr_utility.set_location( ' old pgm flag ' || l_drvbl_fctr_prtn_elig_flag , 11);
720:
721: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
722: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pgm_f','pgm_id',l_c1.pgm_id);
723: else

Line 734: hr_utility.set_location( ' old pl flag ' || l_drvbl_fctr_prtn_elig_flag , 11);

730: open c_pl_flag(l_c1.pl_id) ;
731: fetch c_pl_flag into l_drvbl_fctr_prtn_elig_flag ;
732: close c_pl_flag ;
733:
734: hr_utility.set_location( ' old pl flag ' || l_drvbl_fctr_prtn_elig_flag , 11);
735:
736:
737: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
738: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_pl_f','pl_id',l_c1.pl_id);

Line 750: hr_utility.set_location( ' old plip flag ' || l_drvbl_fctr_prtn_elig_flag , 11);

746: open c_plip_flag( l_c1.plip_id ) ;
747: fetch c_plip_flag into l_drvbl_fctr_prtn_elig_flag ;
748: close c_plip_flag ;
749:
750: hr_utility.set_location( ' old plip flag ' || l_drvbl_fctr_prtn_elig_flag , 11);
751:
752: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
753: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_plip_f','plip_id',l_c1.plip_id);
754: else

Line 765: hr_utility.set_location( ' old ptip flag ' || l_drvbl_fctr_prtn_elig_flag , 11);

761: open c_ptip_flag (l_c1.ptip_id ) ;
762: fetch c_ptip_flag into l_drvbl_fctr_prtn_elig_flag ;
763: close c_ptip_flag ;
764:
765: hr_utility.set_location( ' old ptip flag ' || l_drvbl_fctr_prtn_elig_flag , 11);
766:
767: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
768: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_ptip_f','ptip_id',l_c1.ptip_id);
769: else

Line 780: hr_utility.set_location( ' old oipl flag ' || l_drvbl_fctr_prtn_elig_flag , 11);

776: open c_oipl_flag ( l_c1.oipl_id ) ;
777: fetch c_oipl_flag into l_drvbl_fctr_prtn_elig_flag ;
778: close c_oipl_flag ;
779:
780: hr_utility.set_location( ' old oipl flag ' || l_drvbl_fctr_prtn_elig_flag , 11);
781:
782:
783: if nvl( l_drvbl_fctr_prtn_elig_flag,'N') = 'N' then
784: ben_derivable_factor.eligy_prfl_handler('CREATE','ben_oipl_f','oipl_id',l_c1.oipl_id);

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

795: p_object_version_number := l_object_version_number;
796: p_effective_start_date := l_effective_start_date;
797: p_effective_end_date := l_effective_end_date;
798: --
799: hr_utility.set_location(' Leaving:'||l_proc, 70);
800: --
801: exception
802: --
803: when hr_api.validate_enabled then

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

810: -- Only set output warning arguments
811: -- (Any key or derived arguments must be set to null
812: -- when validation only mode is being used.)
813: --
814: hr_utility.set_location(' Leaving:'||l_proc, 80);
815: --
816: when others then
817: --
818: -- A validation or unexpected error has occured

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

863: open c1;
864: fetch c1 into l_c1;
865: close c1;
866: --
867: hr_utility.set_location('Entering:'|| l_proc, 10);
868: --
869: -- Issue a savepoint if operating in validation only mode
870: --
871: savepoint delete_PRTN_ELIG_PRFL;

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

869: -- Issue a savepoint if operating in validation only mode
870: --
871: savepoint delete_PRTN_ELIG_PRFL;
872: --
873: hr_utility.set_location(l_proc, 20);
874: --
875: -- Process Logic
876: --
877: l_object_version_number := p_object_version_number;

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

1047: ben_derivable_factor.eligy_prfl_handler('DELETE','ben_oipl_f','oipl_id',l_c1.oipl_id);
1048: --
1049: end if;
1050: --
1051: hr_utility.set_location(l_proc, 60);
1052: --
1053: -- When in validation only mode raise the Validate_Enabled exception
1054: --
1055: if p_validate then

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

1055: if p_validate then
1056: raise hr_api.validate_enabled;
1057: end if;
1058: --
1059: hr_utility.set_location(' Leaving:'||l_proc, 70);
1060: --
1061: exception
1062: --
1063: when hr_api.validate_enabled then

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

1108: l_validation_end_date date;
1109: --
1110: begin
1111: --
1112: hr_utility.set_location('Entering:'|| l_proc, 10);
1113: --
1114: ben_cep_shd.lck
1115: (
1116: p_prtn_elig_prfl_id => p_prtn_elig_prfl_id

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

1120: ,p_effective_date => p_effective_date
1121: ,p_datetrack_mode => p_datetrack_mode
1122: );
1123: --
1124: hr_utility.set_location(' Leaving:'||l_proc, 70);
1125: --
1126: end lck;
1127: --
1128: procedure insert_prtn_elig