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_EVALUATE_RATE_PROFILES dependencies on BEN_EVALUATE_RATE_PROFILES

Line 1: package body BEN_EVALUATE_RATE_PROFILES as

1: package body BEN_EVALUATE_RATE_PROFILES as
2: /* $Header: benrtprf.pkb 120.5.12010000.4 2008/08/05 14:54:27 ubhat ship $ */
3: --------------------------------------------------------------------------------
4: --------------------------------------------------------------------------------
5: --

Line 9: g_package varchar2(80) := 'ben_evaluate_rate_profiles';

5: --
6: -- Global exception handler
7: --
8: g_criteria_failed exception;
9: g_package varchar2(80) := 'ben_evaluate_rate_profiles';
10: --
11: -- ---------------------------------------------------------------
12: -- People Group
13: -- ---------------------------------------------------------------

Line 545: -- raise ben_evaluate_rate_profiles.g_profile_failed;

541: --exit ;
542: --
543: elsif l_ok and l_inst_set(i).excld_flag = 'Y' then
544: --
545: -- raise ben_evaluate_rate_profiles.g_profile_failed;
546: l_ok := false;
547: exit ;
548: --
549: elsif l_inst_set(i).excld_flag = 'N' then

Line 561: raise ben_evaluate_rate_profiles.g_profile_failed;

557: end if;
558: --
559: if l_rows_found and not l_ok then
560: --
561: raise ben_evaluate_rate_profiles.g_profile_failed;
562: --
563: end if;
564: --
565: end check_tobacco;

Line 620: -- raise ben_evaluate_rate_profiles.g_profile_failed;

616: exit;
617: --
618: elsif l_ok and l_inst_set(i).excld_flag = 'Y' then
619: --
620: -- raise ben_evaluate_rate_profiles.g_profile_failed;
621: l_ok := false ;
622: exit ;
623: --
624: elsif (not l_ok) and l_inst_set(i).excld_flag = 'Y' then

Line 641: raise ben_evaluate_rate_profiles.g_profile_failed;

637: end if;
638: --
639: if l_rows_found and not l_ok then
640: --
641: raise ben_evaluate_rate_profiles.g_profile_failed;
642: --
643: end if;
644: --
645: end check_gender;

Line 697: -- raise ben_evaluate_rate_profiles.g_profile_failed;

693: exit;
694: --
695: elsif l_ok and l_inst_set(i).excld_flag = 'Y' then
696: --
697: -- raise ben_evaluate_rate_profiles.g_profile_failed;
698: l_ok := false;
699: exit ;
700: --
701: elsif (not l_ok) and l_inst_set(i).excld_flag = 'Y' then

Line 719: raise ben_evaluate_rate_profiles.g_profile_failed;

715: end if;
716: --
717: if l_rows_found and not l_ok then
718: --
719: raise ben_evaluate_rate_profiles.g_profile_failed;
720: --
721: end if;
722: --
723: end check_dsbld_cd;

Line 853: -- raise ben_evaluate_rate_profiles.g_profile_failed;

849: exit;
850: --
851: elsif l_ok and l_inst_set(i).excld_flag = 'Y' then
852: --
853: -- raise ben_evaluate_rate_profiles.g_profile_failed;
854: l_ok := false;
855: exit;
856: --
857: elsif (not l_ok) and l_inst_set(i).excld_flag = 'Y' then

Line 875: raise ben_evaluate_rate_profiles.g_profile_failed;

871: end if;
872: --
873: if l_rows_found and not l_ok then
874: --
875: raise ben_evaluate_rate_profiles.g_profile_failed;
876: --
877: end if;
878: --
879: end check_benefits_grp;

Line 1288: -- raise ben_evaluate_rate_profiles.g_profile_failed;

1284: exit;
1285: --
1286: elsif l_ok and l_inst_set(i).excld_flag = 'Y' then
1287: --
1288: -- raise ben_evaluate_rate_profiles.g_profile_failed;
1289: l_ok := false;
1290: exit ;
1291: --
1292: elsif (not l_ok) and l_inst_set(i).excld_flag = 'Y' then

Line 1309: raise ben_evaluate_rate_profiles.g_profile_failed;

1305: end if;
1306: --
1307: if l_rows_found and not l_ok then
1308: --
1309: raise ben_evaluate_rate_profiles.g_profile_failed;
1310: --
1311: end if;
1312: --
1313: end check_pct_fltm;

Line 1617: -- raise ben_evaluate_rate_profiles.g_profile_failed;

1613: if l_ok and l_inst_set(i).excld_flag = 'N' then
1614: exit;
1615: elsif l_ok and l_inst_set(i).excld_flag = 'Y' then
1616: --
1617: -- raise ben_evaluate_rate_profiles.g_profile_failed;
1618: l_ok := false;
1619: exit ;
1620: --
1621: elsif (not l_ok) and l_inst_set(i).excld_flag = 'Y' then

Line 1635: raise ben_evaluate_rate_profiles.g_profile_failed;

1631:
1632: end if;
1633:
1634: if l_rows_found and not l_ok then
1635: raise ben_evaluate_rate_profiles.g_profile_failed;
1636: end if;
1637:
1638: end check_hrs_wkd;
1639: --

Line 2082: raise ben_evaluate_rate_profiles.g_profile_failed;

2078: end if;
2079: --
2080: if l_rows_found and not l_ok then
2081: --
2082: raise ben_evaluate_rate_profiles.g_profile_failed;
2083: --
2084: end if;
2085: --
2086: end check_per_typ;

Line 2201: RAISE ben_evaluate_rate_profiles.g_profile_failed;

2197: CLOSE get_elig_zip;
2198: --
2199: if not l_rows_found then
2200: --
2201: RAISE ben_evaluate_rate_profiles.g_profile_failed;
2202: --
2203: end if;
2204: --
2205: hr_utility.set_location('leaving chck_zip_code', 10);

Line 2842: RAISE ben_evaluate_rate_profiles.g_profile_failed;

2838: CLOSE get_elig_svc;
2839: --
2840: if (NOT l_rows_found) and (not l_ok) then
2841: --
2842: RAISE ben_evaluate_rate_profiles.g_profile_failed;
2843: --
2844: End if;
2845: --
2846: --

Line 3144: -- raise ben_evaluate_rate_profiles.g_profile_failed;

3140: --
3141: elsif l_ok and l_inst_set(i).excld_flag = 'Y' then
3142: --
3143: --hr_utility.set_location(' Step 3' ,99);
3144: -- raise ben_evaluate_rate_profiles.g_profile_failed;
3145: l_ok := false;
3146: exit ;
3147: --
3148: elsif (not l_ok) and l_inst_set(i).excld_flag = 'Y' then

Line 3167: raise ben_evaluate_rate_profiles.g_profile_failed;

3163: --
3164: if l_rows_found and not l_ok then
3165: --
3166: --hr_utility.set_location(' Step 5 ' ,99);
3167: raise ben_evaluate_rate_profiles.g_profile_failed;
3168: --
3169: end if;
3170: --
3171: end check_age;

Line 3333: -- raise ben_evaluate_rate_profiles.g_profile_failed;

3329: exit;
3330: --
3331: elsif l_ok and l_inst_set(i).excld_flag = 'Y' then
3332: --
3333: -- raise ben_evaluate_rate_profiles.g_profile_failed;
3334: l_ok := false;
3335: exit ;
3336: --
3337: elsif (not l_ok) and l_inst_set(i).excld_flag = 'Y' then

Line 3354: raise ben_evaluate_rate_profiles.g_profile_failed;

3350: end if;
3351: --
3352: if l_rows_found and not l_ok then
3353: --
3354: raise ben_evaluate_rate_profiles.g_profile_failed;
3355: --
3356: end if;
3357: --
3358: end check_comp_level;

Line 3573: raise ben_evaluate_rate_profiles.g_profile_failed;

3569: end if;
3570: --
3571: if l_rows_found and not l_ok then
3572: --
3573: raise ben_evaluate_rate_profiles.g_profile_failed;
3574: --
3575: end if;
3576: --
3577: end check_los;

Line 3748: -- raise ben_evaluate_rate_profiles.g_profile_failed;

3744: exit;
3745: --
3746: elsif l_ok and l_inst_set(i).excld_flag = 'Y' then
3747: --
3748: -- raise ben_evaluate_rate_profiles.g_profile_failed;
3749: l_ok := false ;
3750: exit ;
3751: --
3752: elsif (not l_ok) and l_inst_set(i).excld_flag = 'Y' then

Line 3769: raise ben_evaluate_rate_profiles.g_profile_failed;

3765: end if;
3766: --
3767: if l_rows_found and not l_ok then
3768: --
3769: raise ben_evaluate_rate_profiles.g_profile_failed;
3770: --
3771: end if;
3772: --
3773: end check_age_los;

Line 3919: raise ben_evaluate_rate_profiles.g_profile_failed;

3915: fetch c_ler into l_ler_rec ;
3916: if c_ler%notfound then
3917: hr_utility.set_location ('not a new qualifying termination event:',10);
3918: close c_ler;
3919: raise ben_evaluate_rate_profiles.g_profile_failed;
3920: else
3921: close c_ler;
3922: -- Calculate the start date.
3923: --

Line 3962: raise ben_evaluate_rate_profiles.g_profile_failed;

3958: hr_utility.set_location ('l_end_dt '||l_end_dt , 199);
3959: --
3960: if nvl(p_lf_evt_ocrd_dt, p_effective_date) not between
3961: l_strt_dt and l_end_dt then
3962: raise ben_evaluate_rate_profiles.g_profile_failed;
3963: end if;
3964: --
3965: goto l_ler ;
3966: --

Line 3970: raise ben_evaluate_rate_profiles.g_profile_failed;

3966: --
3967: end if ;
3968:
3969:
3970: raise ben_evaluate_rate_profiles.g_profile_failed;
3971: else
3972: close c_get_quald_bnf;
3973: --
3974: -- Calculate the start date.

Line 4074: raise ben_evaluate_rate_profiles.g_profile_failed;

4070: end if;
4071: end loop;
4072: --
4073: if l_dsbld = false then
4074: raise ben_evaluate_rate_profiles.g_profile_failed;
4075: end if;
4076: end if;
4077: --
4078: if nvl(p_lf_evt_ocrd_dt, p_effective_date) not between

Line 4080: raise ben_evaluate_rate_profiles.g_profile_failed;

4076: end if;
4077: --
4078: if nvl(p_lf_evt_ocrd_dt, p_effective_date) not between
4079: l_strt_dt and l_end_dt then
4080: raise ben_evaluate_rate_profiles.g_profile_failed;
4081: end if;
4082: end if; -- qualified beneficiary
4083: --
4084: <>

Line 4153: raise ben_evaluate_rate_profiles.g_profile_failed;

4149: end if;
4150: end loop;
4151:
4152: if l_profile_match = 'N' then
4153: raise ben_evaluate_rate_profiles.g_profile_failed;
4154: end if;
4155:
4156: end if;
4157: end check_ttl_prtt;

Line 6475: raise ben_evaluate_rate_profiles.g_profile_failed;

6471: end if;
6472: end loop;
6473:
6474: if l_profile_match = 'N' then
6475: raise ben_evaluate_rate_profiles.g_profile_failed;
6476: end if;
6477:
6478: end if;
6479: end check_ttl_cvg;

Line 6896: ben_evaluate_rate_profiles.g_no_match_cnt := 0 ;

6892: -- init_globals
6893: -- ---------------------------------------------------------------------------
6894: procedure init_globals is
6895: begin
6896: ben_evaluate_rate_profiles.g_no_match_cnt := 0 ;
6897: ben_evaluate_rate_profiles.g_no_match_cvg := 0 ;
6898: ben_evaluate_rate_profiles.g_all_prfls.delete;
6899:
6900: ben_evaluate_rate_profiles.g_num_of_prfls_used := 0 ;

Line 6897: ben_evaluate_rate_profiles.g_no_match_cvg := 0 ;

6893: -- ---------------------------------------------------------------------------
6894: procedure init_globals is
6895: begin
6896: ben_evaluate_rate_profiles.g_no_match_cnt := 0 ;
6897: ben_evaluate_rate_profiles.g_no_match_cvg := 0 ;
6898: ben_evaluate_rate_profiles.g_all_prfls.delete;
6899:
6900: ben_evaluate_rate_profiles.g_num_of_prfls_used := 0 ;
6901: ben_evaluate_rate_profiles.g_use_prfls.delete;

Line 6898: ben_evaluate_rate_profiles.g_all_prfls.delete;

6894: procedure init_globals is
6895: begin
6896: ben_evaluate_rate_profiles.g_no_match_cnt := 0 ;
6897: ben_evaluate_rate_profiles.g_no_match_cvg := 0 ;
6898: ben_evaluate_rate_profiles.g_all_prfls.delete;
6899:
6900: ben_evaluate_rate_profiles.g_num_of_prfls_used := 0 ;
6901: ben_evaluate_rate_profiles.g_use_prfls.delete;
6902:

Line 6900: ben_evaluate_rate_profiles.g_num_of_prfls_used := 0 ;

6896: ben_evaluate_rate_profiles.g_no_match_cnt := 0 ;
6897: ben_evaluate_rate_profiles.g_no_match_cvg := 0 ;
6898: ben_evaluate_rate_profiles.g_all_prfls.delete;
6899:
6900: ben_evaluate_rate_profiles.g_num_of_prfls_used := 0 ;
6901: ben_evaluate_rate_profiles.g_use_prfls.delete;
6902:
6903: end init_globals;
6904: -- ---------------------------------------------------------------------------

Line 6901: ben_evaluate_rate_profiles.g_use_prfls.delete;

6897: ben_evaluate_rate_profiles.g_no_match_cvg := 0 ;
6898: ben_evaluate_rate_profiles.g_all_prfls.delete;
6899:
6900: ben_evaluate_rate_profiles.g_num_of_prfls_used := 0 ;
6901: ben_evaluate_rate_profiles.g_use_prfls.delete;
6902:
6903: end init_globals;
6904: -- ---------------------------------------------------------------------------
6905: -- load_globals

Line 7780: raise ben_evaluate_rate_profiles.g_profile_failed;

7776: --
7777: if (l_profile.asmt_to_use_cd <> 'ANY' and
7778: l_asg_rec.assignment_id is null) then
7779: --
7780: raise ben_evaluate_rate_profiles.g_profile_failed;
7781: end if;
7782: --
7783: -- Bug 6399423
7784: hr_utility.set_location ('ASG Profs '||l_package,10);

Line 8085: raise ben_evaluate_rate_profiles.g_profile_failed;

8081: if l_count = l_loop_count then
8082: --
8083: -- Raise error to main exception handler
8084: --
8085: raise ben_evaluate_rate_profiles.g_profile_failed;
8086: --
8087: end if;
8088: --
8089: end;

Line 8790: when ben_evaluate_rate_profiles.g_profile_failed then

8786: end if;
8787: --
8788: exception
8789: --
8790: when ben_evaluate_rate_profiles.g_profile_failed then
8791: --
8792: -- If profile failed one of the criteria,
8793: -- go onto next profile.
8794: --

Line 8839: end ben_evaluate_rate_profiles;

8835: hr_utility.set_location ('Leaving '||l_package,99);
8836: --
8837: end main;
8838: --
8839: end ben_evaluate_rate_profiles;