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.11.12020000.3 2012/07/03 12:55:29 amnaraya 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 3146: -- raise ben_evaluate_rate_profiles.g_profile_failed;

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

Line 3169: raise ben_evaluate_rate_profiles.g_profile_failed;

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

Line 3335: -- raise ben_evaluate_rate_profiles.g_profile_failed;

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

Line 3356: raise ben_evaluate_rate_profiles.g_profile_failed;

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

Line 3577: raise ben_evaluate_rate_profiles.g_profile_failed;

3573: end if;
3574: --
3575: if l_rows_found and not l_ok then
3576: --
3577: raise ben_evaluate_rate_profiles.g_profile_failed;
3578: --
3579: end if;
3580: --
3581: end check_los;

Line 3754: -- raise ben_evaluate_rate_profiles.g_profile_failed;

3750: exit;
3751: --
3752: elsif l_ok and l_inst_set(i).excld_flag = 'Y' then
3753: --
3754: -- raise ben_evaluate_rate_profiles.g_profile_failed;
3755: l_ok := false ;
3756: exit ;
3757: --
3758: elsif (not l_ok) and l_inst_set(i).excld_flag = 'Y' then

Line 3775: raise ben_evaluate_rate_profiles.g_profile_failed;

3771: end if;
3772: --
3773: if l_rows_found and not l_ok then
3774: --
3775: raise ben_evaluate_rate_profiles.g_profile_failed;
3776: --
3777: end if;
3778: --
3779: end check_age_los;

Line 3945: raise ben_evaluate_rate_profiles.g_profile_failed;

3941: fetch c_ler into l_ler_rec ;
3942: if c_ler%notfound then
3943: hr_utility.set_location ('not a new qualifying termination event:',10);
3944: close c_ler;
3945: raise ben_evaluate_rate_profiles.g_profile_failed;
3946: else
3947: close c_ler;
3948: -- Calculate the start date.
3949: --

Line 3988: raise ben_evaluate_rate_profiles.g_profile_failed;

3984: hr_utility.set_location ('l_end_dt '||l_end_dt , 199);
3985: --
3986: if nvl(p_lf_evt_ocrd_dt, p_effective_date) not between
3987: l_strt_dt and l_end_dt then
3988: raise ben_evaluate_rate_profiles.g_profile_failed;
3989: end if;
3990: --
3991: -- arra event
3992: --

Line 3995: raise ben_evaluate_rate_profiles.g_profile_failed;

3991: -- arra event
3992: --
3993: if (l_inst_set(i).cbr_dsblty_apls_flag = 'N'
3994: and l_ler_rec.name <> 'Assistance Eligible Individual') then
3995: raise ben_evaluate_rate_profiles.g_profile_failed;
3996: end if;
3997: --
3998: goto l_ler ;
3999: --

Line 4003: raise ben_evaluate_rate_profiles.g_profile_failed;

3999: --
4000: end if ;
4001:
4002:
4003: raise ben_evaluate_rate_profiles.g_profile_failed;
4004: else
4005: close c_get_quald_bnf;
4006: --
4007: -- Calculate the start date.

Line 4107: raise ben_evaluate_rate_profiles.g_profile_failed;

4103: end if;
4104: end loop;
4105: --
4106: if l_dsbld = false then
4107: raise ben_evaluate_rate_profiles.g_profile_failed;
4108: end if;
4109: else
4110: --
4111: -- arra event

Line 4120: raise ben_evaluate_rate_profiles.g_profile_failed;

4116: fetch c_get_arra_evt into l_exists;
4117: if c_get_arra_evt%notfound then
4118: hr_utility.set_location ('event not found',10);
4119: close c_get_arra_evt;
4120: raise ben_evaluate_rate_profiles.g_profile_failed;
4121: else
4122: hr_utility.set_location ('event found',10);
4123: close c_get_arra_evt;
4124: l_end_dt := l_end_dt - 1;

Line 4132: raise ben_evaluate_rate_profiles.g_profile_failed;

4128: --
4129: if nvl(p_lf_evt_ocrd_dt, p_effective_date) not between
4130: l_strt_dt and l_end_dt then
4131: hr_utility.set_location ('l_strt_dt'||l_strt_dt,10);
4132: raise ben_evaluate_rate_profiles.g_profile_failed;
4133: end if;
4134: hr_utility.set_location ('p_lf_evt_ocrd_dt'||p_lf_evt_ocrd_dt,10);
4135: end if; -- qualified beneficiary
4136: --

Line 4206: raise ben_evaluate_rate_profiles.g_profile_failed;

4202: end if;
4203: end loop;
4204:
4205: if l_profile_match = 'N' then
4206: raise ben_evaluate_rate_profiles.g_profile_failed;
4207: end if;
4208:
4209: end if;
4210: end check_ttl_prtt;

Line 6532: raise ben_evaluate_rate_profiles.g_profile_failed;

6528: end if;
6529: end loop;
6530:
6531: if l_profile_match = 'N' then
6532: raise ben_evaluate_rate_profiles.g_profile_failed;
6533: end if;
6534:
6535: end if;
6536: end check_ttl_cvg;

Line 6953: ben_evaluate_rate_profiles.g_no_match_cnt := 0 ;

6949: -- init_globals
6950: -- ---------------------------------------------------------------------------
6951: procedure init_globals is
6952: begin
6953: ben_evaluate_rate_profiles.g_no_match_cnt := 0 ;
6954: ben_evaluate_rate_profiles.g_no_match_cvg := 0 ;
6955: ben_evaluate_rate_profiles.g_all_prfls.delete;
6956:
6957: ben_evaluate_rate_profiles.g_num_of_prfls_used := 0 ;

Line 6954: ben_evaluate_rate_profiles.g_no_match_cvg := 0 ;

6950: -- ---------------------------------------------------------------------------
6951: procedure init_globals is
6952: begin
6953: ben_evaluate_rate_profiles.g_no_match_cnt := 0 ;
6954: ben_evaluate_rate_profiles.g_no_match_cvg := 0 ;
6955: ben_evaluate_rate_profiles.g_all_prfls.delete;
6956:
6957: ben_evaluate_rate_profiles.g_num_of_prfls_used := 0 ;
6958: ben_evaluate_rate_profiles.g_use_prfls.delete;

Line 6955: ben_evaluate_rate_profiles.g_all_prfls.delete;

6951: procedure init_globals is
6952: begin
6953: ben_evaluate_rate_profiles.g_no_match_cnt := 0 ;
6954: ben_evaluate_rate_profiles.g_no_match_cvg := 0 ;
6955: ben_evaluate_rate_profiles.g_all_prfls.delete;
6956:
6957: ben_evaluate_rate_profiles.g_num_of_prfls_used := 0 ;
6958: ben_evaluate_rate_profiles.g_use_prfls.delete;
6959:

Line 6957: ben_evaluate_rate_profiles.g_num_of_prfls_used := 0 ;

6953: ben_evaluate_rate_profiles.g_no_match_cnt := 0 ;
6954: ben_evaluate_rate_profiles.g_no_match_cvg := 0 ;
6955: ben_evaluate_rate_profiles.g_all_prfls.delete;
6956:
6957: ben_evaluate_rate_profiles.g_num_of_prfls_used := 0 ;
6958: ben_evaluate_rate_profiles.g_use_prfls.delete;
6959:
6960: end init_globals;
6961: -- ---------------------------------------------------------------------------

Line 6958: ben_evaluate_rate_profiles.g_use_prfls.delete;

6954: ben_evaluate_rate_profiles.g_no_match_cvg := 0 ;
6955: ben_evaluate_rate_profiles.g_all_prfls.delete;
6956:
6957: ben_evaluate_rate_profiles.g_num_of_prfls_used := 0 ;
6958: ben_evaluate_rate_profiles.g_use_prfls.delete;
6959:
6960: end init_globals;
6961: -- ---------------------------------------------------------------------------
6962: -- load_globals

Line 7841: raise ben_evaluate_rate_profiles.g_profile_failed;

7837: --
7838: if (l_profile.asmt_to_use_cd <> 'ANY' and
7839: l_asg_rec.assignment_id is null) then
7840: --
7841: raise ben_evaluate_rate_profiles.g_profile_failed;
7842: end if;
7843: --
7844: -- Bug 6399423
7845: hr_utility.set_location ('ASG Profs '||l_package,10);

Line 8146: raise ben_evaluate_rate_profiles.g_profile_failed;

8142: if l_count = l_loop_count then
8143: --
8144: -- Raise error to main exception handler
8145: --
8146: raise ben_evaluate_rate_profiles.g_profile_failed;
8147: --
8148: end if;
8149: --
8150: end;

Line 8851: when ben_evaluate_rate_profiles.g_profile_failed then

8847: end if;
8848: --
8849: exception
8850: --
8851: when ben_evaluate_rate_profiles.g_profile_failed then
8852: --
8853: -- If profile failed one of the criteria,
8854: -- go onto next profile.
8855: --

Line 8900: end ben_evaluate_rate_profiles;

8896: hr_utility.set_location ('Leaving '||l_package,99);
8897: --
8898: end main;
8899: --
8900: end ben_evaluate_rate_profiles;