DBA Data[Home] [Help]

APPS.BEN_MANAGE_LIFE_EVENTS dependencies on FND_MESSAGE

Line 1644: fnd_message.set_name('BEN','BEN_94094_PERSON_GRADE_NOT_FND');

1640: --
1641: if p_gsp_plip_id is null or p_gsp_pgm_id is null
1642: then
1643: --
1644: fnd_message.set_name('BEN','BEN_94094_PERSON_GRADE_NOT_FND');
1645: --
1646: elsif p_gsp_emp_step_id is null or p_gsp_oipl_id is null
1647: then
1648: --

Line 1649: fnd_message.set_name('BEN','BEN_94095_PERSON_STEP_NOT_FND');

1645: --
1646: elsif p_gsp_emp_step_id is null or p_gsp_oipl_id is null
1647: then
1648: --
1649: fnd_message.set_name('BEN','BEN_94095_PERSON_STEP_NOT_FND');
1650: --
1651: end if;
1652: --
1653: raise g_record_error;

Line 1994: fnd_message.set_name('BEN','BEN_91391_NO_PLAN_PROG');

1990: --
1991: if p_no_plans = 'Y' and
1992: p_no_programs = 'Y' then
1993: --
1994: fnd_message.set_name('BEN','BEN_91391_NO_PLAN_PROG');
1995: fnd_message.raise_error;
1996: --
1997: end if;
1998: --

Line 1995: fnd_message.raise_error;

1991: if p_no_plans = 'Y' and
1992: p_no_programs = 'Y' then
1993: --
1994: fnd_message.set_name('BEN','BEN_91391_NO_PLAN_PROG');
1995: fnd_message.raise_error;
1996: --
1997: end if;
1998: --
1999: -- p_person_selection_rule_id and p_person_id are mutually exclusive

Line 2004: fnd_message.set_name('BEN','BEN_91745_RULE_AND_PERSON');

2000: --
2001: if p_person_id is not null and
2002: p_person_selection_rule_id is not null then
2003: --
2004: fnd_message.set_name('BEN','BEN_91745_RULE_AND_PERSON');
2005: fnd_message.raise_error;
2006: --
2007: end if;
2008: --

Line 2005: fnd_message.raise_error;

2001: if p_person_id is not null and
2002: p_person_selection_rule_id is not null then
2003: --
2004: fnd_message.set_name('BEN','BEN_91745_RULE_AND_PERSON');
2005: fnd_message.raise_error;
2006: --
2007: end if;
2008: --
2009: -- p_no_plans = 'Y' then p_pl_id and p_opt_id must be null

Line 2015: fnd_message.set_name('BEN','BEN_91746_PROGRAMS_ONLY');

2011: if p_no_plans = 'Y' and
2012: (p_pl_id is not null or
2013: p_opt_id is not null) then
2014: --
2015: fnd_message.set_name('BEN','BEN_91746_PROGRAMS_ONLY');
2016: fnd_message.raise_error;
2017: --
2018: end if;
2019: --

Line 2016: fnd_message.raise_error;

2012: (p_pl_id is not null or
2013: p_opt_id is not null) then
2014: --
2015: fnd_message.set_name('BEN','BEN_91746_PROGRAMS_ONLY');
2016: fnd_message.raise_error;
2017: --
2018: end if;
2019: --
2020: -- p_no_programs = 'Y' then p_pgm_id must be null

Line 2025: fnd_message.set_name('BEN','BEN_91747_PLANS_ONLY');

2021: --
2022: if p_no_programs = 'Y' and
2023: p_pgm_id is not null then
2024: --
2025: fnd_message.set_name('BEN','BEN_91747_PLANS_ONLY');
2026: fnd_message.raise_error;
2027: --
2028: end if;
2029: --

Line 2026: fnd_message.raise_error;

2022: if p_no_programs = 'Y' and
2023: p_pgm_id is not null then
2024: --
2025: fnd_message.set_name('BEN','BEN_91747_PLANS_ONLY');
2026: fnd_message.raise_error;
2027: --
2028: end if;
2029: --
2030: -- p_person_id must be of p_person_type_id

Line 2043: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');

2039: fetch c1 into l_dummy;
2040: if c1%notfound then
2041: --
2042: close c1;
2043: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');
2044: fnd_message.raise_error;
2045: --
2046: end if;
2047: --

Line 2044: fnd_message.raise_error;

2040: if c1%notfound then
2041: --
2042: close c1;
2043: fnd_message.set_name('BEN','BEN_91748_PERSON_TYPE');
2044: fnd_message.raise_error;
2045: --
2046: end if;
2047: --
2048: close c1;

Line 2062: fnd_message.set_name('BEN','BEN_91749_PLAN_TYPE');

2058: (p_no_plans = 'Y' or
2059: p_opt_id is not null or
2060: p_pl_id is not null) then
2061: --
2062: fnd_message.set_name('BEN','BEN_91749_PLAN_TYPE');
2063: fnd_message.raise_error;
2064: --
2065: end if;
2066: --

Line 2063: fnd_message.raise_error;

2059: p_opt_id is not null or
2060: p_pl_id is not null) then
2061: --
2062: fnd_message.set_name('BEN','BEN_91749_PLAN_TYPE');
2063: fnd_message.raise_error;
2064: --
2065: end if;
2066: --
2067: -- p_mode = 'C' and p_popl_enrt_typ_cycl_id is null

Line 2078: fnd_message.set_name('BEN','BEN_91667_SCHED_NO_POPL_ENRT');

2074: --
2075: -- p_popl_enrt_typ_cycl_id is null then
2076: p_lf_evt_ocrd_dt is null then
2077: --
2078: fnd_message.set_name('BEN','BEN_91667_SCHED_NO_POPL_ENRT');
2079: fnd_message.raise_error;
2080: --
2081: end if;
2082: --

Line 2079: fnd_message.raise_error;

2075: -- p_popl_enrt_typ_cycl_id is null then
2076: p_lf_evt_ocrd_dt is null then
2077: --
2078: fnd_message.set_name('BEN','BEN_91667_SCHED_NO_POPL_ENRT');
2079: fnd_message.raise_error;
2080: --
2081: end if;
2082: --
2083: -- CWB Changes

Line 2087: fnd_message.set_name('BEN','BEN_91667_SCHED_NO_POPL_ENRT');

2083: -- CWB Changes
2084: --
2085: if p_mode = 'W' and p_pl_id is null then
2086: --
2087: fnd_message.set_name('BEN','BEN_91667_SCHED_NO_POPL_ENRT');
2088: fnd_message.raise_error;
2089: --
2090: end if;
2091:

Line 2088: fnd_message.raise_error;

2084: --
2085: if p_mode = 'W' and p_pl_id is null then
2086: --
2087: fnd_message.set_name('BEN','BEN_91667_SCHED_NO_POPL_ENRT');
2088: fnd_message.raise_error;
2089: --
2090: end if;
2091:
2092: --

Line 2098: fnd_message.set_name('BEN','BEN_93017_INVALID_EFF_DATE');

2094: -- Effective date must be greater than or equal to Life Event Occurred Date
2095: --
2096: if p_mode = 'W' and p_effective_date < p_lf_evt_ocrd_dt then
2097: --
2098: fnd_message.set_name('BEN','BEN_93017_INVALID_EFF_DATE');
2099: fnd_message.raise_error;
2100: --
2101: end if;
2102:

Line 2099: fnd_message.raise_error;

2095: --
2096: if p_mode = 'W' and p_effective_date < p_lf_evt_ocrd_dt then
2097: --
2098: fnd_message.set_name('BEN','BEN_93017_INVALID_EFF_DATE');
2099: fnd_message.raise_error;
2100: --
2101: end if;
2102:
2103: --

Line 2121: fnd_message.set_name('BEN','BEN_93015_CWB_NO_WS_RATE');

2117: fetch c2 into l_dummy;
2118: if c2%found then -- Bug 3975857 Changed "notfound" to "found"
2119: --
2120: close c2;
2121: fnd_message.set_name('BEN','BEN_93015_CWB_NO_WS_RATE');
2122: fnd_message.raise_error;
2123: --
2124: end if;
2125: --

Line 2122: fnd_message.raise_error;

2118: if c2%found then -- Bug 3975857 Changed "notfound" to "found"
2119: --
2120: close c2;
2121: fnd_message.set_name('BEN','BEN_93015_CWB_NO_WS_RATE');
2122: fnd_message.raise_error;
2123: --
2124: end if;
2125: --
2126: close c2;

Line 2136: fnd_message.set_name('BEN','BEN_93968_CWB_BDGT_RT_AMT_CB');

2132: fetch c5 into l_dummy;
2133: if c5%found then
2134: --
2135: close c5;
2136: fnd_message.set_name('BEN','BEN_93968_CWB_BDGT_RT_AMT_CB');
2137: fnd_message.raise_error;
2138: --
2139: end if;
2140: close c5;

Line 2137: fnd_message.raise_error;

2133: if c5%found then
2134: --
2135: close c5;
2136: fnd_message.set_name('BEN','BEN_93968_CWB_BDGT_RT_AMT_CB');
2137: fnd_message.raise_error;
2138: --
2139: end if;
2140: close c5;
2141: --

Line 2168: * fnd_message.set_name('BEN','BEN_93742_CWB_RATE_TO_CHILD');

2164: * fetch c11 into l_dummy ;
2165: * if c11%found then
2166: * close c11 ;
2167: * close c10 ;
2168: * fnd_message.set_name('BEN','BEN_93742_CWB_RATE_TO_CHILD');
2169: * fnd_message.raise_error;
2170: * end if ;
2171: * close c11 ;
2172: * end if ;

Line 2169: * fnd_message.raise_error;

2165: * if c11%found then
2166: * close c11 ;
2167: * close c10 ;
2168: * fnd_message.set_name('BEN','BEN_93742_CWB_RATE_TO_CHILD');
2169: * fnd_message.raise_error;
2170: * end if ;
2171: * close c11 ;
2172: * end if ;
2173: * close c10 ;

Line 2182: fnd_message.set_name('BEN','BEN_93967_CWB_BDGT_RT_PLAN_CB');

2178: if c3_rec.uses_bdgt_flag = 'Y' then
2179: if l_cwbdb_count < 1 or
2180: l_cwbwb_count < 1 then
2181: --
2182: fnd_message.set_name('BEN','BEN_93967_CWB_BDGT_RT_PLAN_CB');
2183: fnd_message.raise_error;
2184: --
2185: end if;
2186: end if ;

Line 2183: fnd_message.raise_error;

2179: if l_cwbdb_count < 1 or
2180: l_cwbwb_count < 1 then
2181: --
2182: fnd_message.set_name('BEN','BEN_93967_CWB_BDGT_RT_PLAN_CB');
2183: fnd_message.raise_error;
2184: --
2185: end if;
2186: end if ;
2187: /* -- bug 5090149

Line 2193: fnd_message.set_name('BEN','BEN_93740_CWB_BDGT_TASK_NOT');

2189: open c9 ;
2190: fetch c9 into l_dummy ;
2191: if c9%notfound then
2192: close c9 ;
2193: fnd_message.set_name('BEN','BEN_93740_CWB_BDGT_TASK_NOT');
2194: fnd_message.raise_error;
2195: end if ;
2196: close c9 ;
2197: */

Line 2194: fnd_message.raise_error;

2190: fetch c9 into l_dummy ;
2191: if c9%notfound then
2192: close c9 ;
2193: fnd_message.set_name('BEN','BEN_93740_CWB_BDGT_TASK_NOT');
2194: fnd_message.raise_error;
2195: end if ;
2196: close c9 ;
2197: */
2198:

Line 2208: fnd_message.set_name('BEN','BEN_93743_CWB_RATE_TO_GROUP');

2204: -- if the plan is not group and date DB/WB/reserve attached then error
2205: if l_cwbdb_count > 0 or
2206: l_cwbwb_count > 0 or
2207: l_cwbr_count > 0 then
2208: fnd_message.set_name('BEN','BEN_93743_CWB_RATE_TO_GROUP');
2209: fnd_message.raise_error;
2210: end if ;
2211: */
2212: end if ;

Line 2209: fnd_message.raise_error;

2205: if l_cwbdb_count > 0 or
2206: l_cwbwb_count > 0 or
2207: l_cwbr_count > 0 then
2208: fnd_message.set_name('BEN','BEN_93743_CWB_RATE_TO_GROUP');
2209: fnd_message.raise_error;
2210: end if ;
2211: */
2212: end if ;
2213: --

Line 2223: fnd_message.set_name('BEN','BEN_93319_CWB_BDGT_RT_SAL');

2219: fetch c6 into l_dummy;
2220: if c6%found then
2221: --
2222: close c6;
2223: fnd_message.set_name('BEN','BEN_93319_CWB_BDGT_RT_SAL');
2224: fnd_message.raise_error;
2225: --
2226: end if;
2227: --

Line 2224: fnd_message.raise_error;

2220: if c6%found then
2221: --
2222: close c6;
2223: fnd_message.set_name('BEN','BEN_93319_CWB_BDGT_RT_SAL');
2224: fnd_message.raise_error;
2225: --
2226: end if;
2227: --
2228: close c6;

Line 2244: fnd_message.set_name('BEN','BEN_93320_CWB_OPT_COMP_RSN');

2240: fetch c7 into l_opt_count;
2241: close c7;
2242:
2243: if l_opt_count = 1 then
2244: fnd_message.set_name('BEN','BEN_93320_CWB_OPT_COMP_RSN');
2245: fnd_message.raise_error;
2246: end if;
2247: */
2248:

Line 2245: fnd_message.raise_error;

2241: close c7;
2242:
2243: if l_opt_count = 1 then
2244: fnd_message.set_name('BEN','BEN_93320_CWB_OPT_COMP_RSN');
2245: fnd_message.raise_error;
2246: end if;
2247: */
2248:
2249: --

Line 2258: fnd_message.set_name('BEN','BEN_93356_CWB_NO_CVG');

2254: fetch c8 into l_dummy;
2255: if c8%found then
2256: --
2257: close c8;
2258: fnd_message.set_name('BEN','BEN_93356_CWB_NO_CVG');
2259: fnd_message.raise_error;
2260: --
2261: end if;
2262: --

Line 2259: fnd_message.raise_error;

2255: if c8%found then
2256: --
2257: close c8;
2258: fnd_message.set_name('BEN','BEN_93356_CWB_NO_CVG');
2259: fnd_message.raise_error;
2260: --
2261: end if;
2262: --
2263: close c8;

Line 2281: fnd_message.set_name('BEN','BEN_94026_NO_RPTG_GRP_DFND');

2277: fetch c_irec_rptg_grp into l_dummy;
2278: if c_irec_rptg_grp%notfound then
2279: --
2280: close c_irec_rptg_grp;
2281: fnd_message.set_name('BEN','BEN_94026_NO_RPTG_GRP_DFND');
2282: fnd_message.raise_error;
2283: --
2284: end if;
2285: --

Line 2282: fnd_message.raise_error;

2278: if c_irec_rptg_grp%notfound then
2279: --
2280: close c_irec_rptg_grp;
2281: fnd_message.set_name('BEN','BEN_94026_NO_RPTG_GRP_DFND');
2282: fnd_message.raise_error;
2283: --
2284: end if;
2285: --
2286: close c_irec_rptg_grp;

Line 2304: fnd_message.set_name('BEN','BEN_94090_NO_GSP_RS_LER_DFND');

2300: if c_gsp_rate_sync_ler%notfound
2301: then
2302: --
2303: close c_gsp_rate_sync_ler;
2304: fnd_message.set_name('BEN','BEN_94090_NO_GSP_RS_LER_DFND');
2305: fnd_message.raise_error;
2306: --
2307: end if;
2308: --

Line 2305: fnd_message.raise_error;

2301: then
2302: --
2303: close c_gsp_rate_sync_ler;
2304: fnd_message.set_name('BEN','BEN_94090_NO_GSP_RS_LER_DFND');
2305: fnd_message.raise_error;
2306: --
2307: end if;
2308: --
2309: close c_gsp_rate_sync_ler;

Line 2330: fnd_message.set_name('BEN','BEN_91326_MODE_INVALID');

2326: (p_lookup_type => 'BEN_BENMNGLE_MD',
2327: p_lookup_code => p_mode,
2328: p_effective_date => p_effective_date) then
2329: --
2330: fnd_message.set_name('BEN','BEN_91326_MODE_INVALID');
2331: fnd_message.raise_error;
2332: --
2333: end if;
2334: --

Line 2331: fnd_message.raise_error;

2327: p_lookup_code => p_mode,
2328: p_effective_date => p_effective_date) then
2329: --
2330: fnd_message.set_name('BEN','BEN_91326_MODE_INVALID');
2331: fnd_message.raise_error;
2332: --
2333: end if;
2334: --
2335: -- 2940151 grade/step

Line 2342: fnd_message.set_name('PER','HR_289506_SPP_BR_NULL');

2338: if p_per_sel_dt_cd is null and
2339: ( p_per_sel_dt_from is not null or
2340: p_per_sel_dt_to is not null) then
2341:
2342: fnd_message.set_name('PER','HR_289506_SPP_BR_NULL');
2343: fnd_message.raise_error;
2344: end if;
2345:
2346: -- 2. If business rule param is not null and business rule strt or end dts

Line 2343: fnd_message.raise_error;

2339: ( p_per_sel_dt_from is not null or
2340: p_per_sel_dt_to is not null) then
2341:
2342: fnd_message.set_name('PER','HR_289506_SPP_BR_NULL');
2343: fnd_message.raise_error;
2344: end if;
2345:
2346: -- 2. If business rule param is not null and business rule strt or end dts
2347: -- are null, raise error

Line 2352: fnd_message.set_name('PER','HR_289510_SPP_BR_DATE_NULL');

2348: if p_per_sel_dt_cd is not null and
2349: ( p_per_sel_dt_from is null or
2350: p_per_sel_dt_to is null) then
2351:
2352: fnd_message.set_name('PER','HR_289510_SPP_BR_DATE_NULL');
2353: fnd_message.raise_error;
2354: end if;
2355: --
2356: -- 3. If business rule param is neither of the four values, raise error

Line 2353: fnd_message.raise_error;

2349: ( p_per_sel_dt_from is null or
2350: p_per_sel_dt_to is null) then
2351:
2352: fnd_message.set_name('PER','HR_289510_SPP_BR_DATE_NULL');
2353: fnd_message.raise_error;
2354: end if;
2355: --
2356: -- 3. If business rule param is neither of the four values, raise error
2357:

Line 2359: fnd_message.set_name('PER','HR_289507_SPP_BR_INVALID');

2355: --
2356: -- 3. If business rule param is neither of the four values, raise error
2357:
2358: if p_per_sel_dt_cd not in ('AOJ', 'DOB', 'ASD', 'LHD') then
2359: fnd_message.set_name('PER','HR_289507_SPP_BR_INVALID');
2360: fnd_message.raise_error;
2361: end if;
2362: --
2363: -- 4. If date from is greater than date to, raise error

Line 2360: fnd_message.raise_error;

2356: -- 3. If business rule param is neither of the four values, raise error
2357:
2358: if p_per_sel_dt_cd not in ('AOJ', 'DOB', 'ASD', 'LHD') then
2359: fnd_message.set_name('PER','HR_289507_SPP_BR_INVALID');
2360: fnd_message.raise_error;
2361: end if;
2362: --
2363: -- 4. If date from is greater than date to, raise error
2364:

Line 2366: fnd_message.set_name('PER','HR_289500_SPP_BR_DATE');

2362: --
2363: -- 4. If date from is greater than date to, raise error
2364:
2365: if p_per_sel_dt_from > p_per_sel_dt_to then
2366: fnd_message.set_name('PER','HR_289500_SPP_BR_DATE');
2367: fnd_message.raise_error;
2368: end if;
2369: --
2370: -- 5. If the dates are more than 12 months apart, raise error

Line 2367: fnd_message.raise_error;

2363: -- 4. If date from is greater than date to, raise error
2364:
2365: if p_per_sel_dt_from > p_per_sel_dt_to then
2366: fnd_message.set_name('PER','HR_289500_SPP_BR_DATE');
2367: fnd_message.raise_error;
2368: end if;
2369: --
2370: -- 5. If the dates are more than 12 months apart, raise error
2371:

Line 2373: fnd_message.set_name('PER','HR_289501_SPP_BR_YEAR_GREATER');

2369: --
2370: -- 5. If the dates are more than 12 months apart, raise error
2371:
2372: if ( months_between( p_per_sel_dt_to, p_per_sel_dt_from) > 12 ) then
2373: fnd_message.set_name('PER','HR_289501_SPP_BR_YEAR_GREATER');
2374: fnd_message.raise_error;
2375: end if;
2376: --
2377: -- 6. If effective date does not fall between the from and to dates, raise error

Line 2374: fnd_message.raise_error;

2370: -- 5. If the dates are more than 12 months apart, raise error
2371:
2372: if ( months_between( p_per_sel_dt_to, p_per_sel_dt_from) > 12 ) then
2373: fnd_message.set_name('PER','HR_289501_SPP_BR_YEAR_GREATER');
2374: fnd_message.raise_error;
2375: end if;
2376: --
2377: -- 6. If effective date does not fall between the from and to dates, raise error
2378:

Line 2380: fnd_message.set_name('PER','HR_289503_SPP_EFF_BR_DATE');

2376: --
2377: -- 6. If effective date does not fall between the from and to dates, raise error
2378:
2379: if not ( p_effective_date between p_per_sel_dt_from and p_per_sel_dt_to ) then
2380: fnd_message.set_name('PER','HR_289503_SPP_EFF_BR_DATE');
2381: fnd_message.raise_error;
2382: end if;
2383: --
2384: -- 7. If year from is greater than year to, raise error

Line 2381: fnd_message.raise_error;

2377: -- 6. If effective date does not fall between the from and to dates, raise error
2378:
2379: if not ( p_effective_date between p_per_sel_dt_from and p_per_sel_dt_to ) then
2380: fnd_message.set_name('PER','HR_289503_SPP_EFF_BR_DATE');
2381: fnd_message.raise_error;
2382: end if;
2383: --
2384: -- 7. If year from is greater than year to, raise error
2385:

Line 2387: fnd_message.set_name('PER','HR_289504_SPP_BR_YEAR_FROM_TO');

2383: --
2384: -- 7. If year from is greater than year to, raise error
2385:
2386: if p_year_from > p_year_to then
2387: fnd_message.set_name('PER','HR_289504_SPP_BR_YEAR_FROM_TO');
2388: fnd_message.raise_error;
2389: end if;
2390: --
2391: -- end 2940151

Line 2388: fnd_message.raise_error;

2384: -- 7. If year from is greater than year to, raise error
2385:
2386: if p_year_from > p_year_to then
2387: fnd_message.set_name('PER','HR_289504_SPP_BR_YEAR_FROM_TO');
2388: fnd_message.raise_error;
2389: end if;
2390: --
2391: -- end 2940151
2392:

Line 3148: benutils.write(fnd_message.get);

3144: exception
3145: --
3146: --
3147: when table_full then
3148: benutils.write(fnd_message.get);
3149: fnd_message.raise_error;
3150: when index_full then
3151: benutils.write(fnd_message.get);
3152: fnd_message.raise_error;

Line 3149: fnd_message.raise_error;

3145: --
3146: --
3147: when table_full then
3148: benutils.write(fnd_message.get);
3149: fnd_message.raise_error;
3150: when index_full then
3151: benutils.write(fnd_message.get);
3152: fnd_message.raise_error;
3153: --

Line 3151: benutils.write(fnd_message.get);

3147: when table_full then
3148: benutils.write(fnd_message.get);
3149: fnd_message.raise_error;
3150: when index_full then
3151: benutils.write(fnd_message.get);
3152: fnd_message.raise_error;
3153: --
3154: when others then
3155: --

Line 3152: fnd_message.raise_error;

3148: benutils.write(fnd_message.get);
3149: fnd_message.raise_error;
3150: when index_full then
3151: benutils.write(fnd_message.get);
3152: fnd_message.raise_error;
3153: --
3154: when others then
3155: --
3156: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');

Line 3156: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');

3152: fnd_message.raise_error;
3153: --
3154: when others then
3155: --
3156: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
3157: benutils.write(fnd_message.get);
3158: fnd_message.raise_error;
3159: --
3160: end write_logfile;

Line 3157: benutils.write(fnd_message.get);

3153: --
3154: when others then
3155: --
3156: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
3157: benutils.write(fnd_message.get);
3158: fnd_message.raise_error;
3159: --
3160: end write_logfile;
3161: --

Line 3158: fnd_message.raise_error;

3154: when others then
3155: --
3156: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
3157: benutils.write(fnd_message.get);
3158: fnd_message.raise_error;
3159: --
3160: end write_logfile;
3161: --
3162: procedure flush_global_structures is

Line 6372: fnd_message.raise_error;

6368: );
6369: --
6370: if l_slave_errored then
6371: --
6372: fnd_message.raise_error;
6373: --
6374: end if;
6375: --
6376: if g_debug then

Line 6386: benutils.write(p_text => fnd_message.get);

6382: when g_record_error then
6383: if g_debug then
6384: hr_utility.set_location (l_package||' Exception g_record_error ',50);
6385: end if;
6386: benutils.write(p_text => fnd_message.get);
6387: --
6388: -- Write the last bit of information for the thread
6389: --
6390: benutils.write_table_and_file(p_table => true,

Line 6420: g_rec.text := nvl(fnd_message.get,sqlerrm);

6416: if g_debug then
6417: hr_utility.set_location ('BENMNGLE Super Error '||l_package,10);
6418: end if;
6419: g_rec.rep_typ_cd := 'FATAL';
6420: g_rec.text := nvl(fnd_message.get,sqlerrm);
6421: if g_debug then
6422: hr_utility.set_location(substr(g_rec.text,1,100),10);
6423: end if;
6424: benutils.write(p_rec => g_rec);

Line 6444: fnd_message.set_name('BEN','BEN_91665_BENMNGLE_ERRORED');

6440: end if;
6441: --
6442: -- Set generic system error with oracle SQLCODE as the token
6443: --
6444: fnd_message.set_name('BEN','BEN_91665_BENMNGLE_ERRORED');
6445: fnd_message.set_token('ORA_ERRCODE',SQLCODE);
6446: --
6447: benutils.write(p_text => fnd_message.get);
6448: benutils.write_table_and_file(p_table => true,

Line 6445: fnd_message.set_token('ORA_ERRCODE',SQLCODE);

6441: --
6442: -- Set generic system error with oracle SQLCODE as the token
6443: --
6444: fnd_message.set_name('BEN','BEN_91665_BENMNGLE_ERRORED');
6445: fnd_message.set_token('ORA_ERRCODE',SQLCODE);
6446: --
6447: benutils.write(p_text => fnd_message.get);
6448: benutils.write_table_and_file(p_table => true,
6449: p_file => true);

Line 6447: benutils.write(p_text => fnd_message.get);

6443: --
6444: fnd_message.set_name('BEN','BEN_91665_BENMNGLE_ERRORED');
6445: fnd_message.set_token('ORA_ERRCODE',SQLCODE);
6446: --
6447: benutils.write(p_text => fnd_message.get);
6448: benutils.write_table_and_file(p_table => true,
6449: p_file => true);
6450: commit;
6451: if g_debug then

Line 6454: fnd_message.raise_error;

6450: commit;
6451: if g_debug then
6452: hr_utility.set_location ('Others error '||l_package,100);
6453: end if;
6454: fnd_message.raise_error;
6455: --
6456: end do_multithread;
6457: --
6458: procedure restart

Line 6524: fnd_message.set_name('BEN','BEN_91666_BENMNGLE_NO_RESTART');

6520: --
6521: fetch c_parameters into l_parameters;
6522: if c_parameters%notfound then
6523: --
6524: fnd_message.set_name('BEN','BEN_91666_BENMNGLE_NO_RESTART');
6525: fnd_message.raise_error;
6526: --
6527: end if;
6528: --

Line 6525: fnd_message.raise_error;

6521: fetch c_parameters into l_parameters;
6522: if c_parameters%notfound then
6523: --
6524: fnd_message.set_name('BEN','BEN_91666_BENMNGLE_NO_RESTART');
6525: fnd_message.raise_error;
6526: --
6527: end if;
6528: --
6529: close c_parameters;

Line 6691: fnd_message.set_name('BEN','BEN_94272_COMOD_NO_SRS_SUBMIT');

6687: --
6688: Exception
6689: when l_exc_no_parent_req then
6690: -- 4394545
6691: fnd_message.set_name('BEN','BEN_94272_COMOD_NO_SRS_SUBMIT');
6692: l_text := fnd_message.get ;
6693: FND_FILE.PUT_LINE(FND_FILE.LOG, l_text);
6694: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_text) ;
6695: --

Line 6692: l_text := fnd_message.get ;

6688: Exception
6689: when l_exc_no_parent_req then
6690: -- 4394545
6691: fnd_message.set_name('BEN','BEN_94272_COMOD_NO_SRS_SUBMIT');
6692: l_text := fnd_message.get ;
6693: FND_FILE.PUT_LINE(FND_FILE.LOG, l_text);
6694: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_text) ;
6695: --
6696: end cwb_process;

Line 7218: fnd_message.set_name('BEN','BEN_94027_NO_ACT_APL_ASS_FOUND');

7214: fetch c_irec_ass_rec into ben_manage_life_events.g_irec_old_ass_rec; -- irec2
7215: if c_irec_ass_rec%notfound then
7216: --
7217: close c_irec_ass_rec;
7218: fnd_message.set_name('BEN','BEN_94027_NO_ACT_APL_ASS_FOUND');
7219: fnd_message.raise_error;
7220: --
7221: else -- begin irec2
7222: begin

Line 7219: fnd_message.raise_error;

7215: if c_irec_ass_rec%notfound then
7216: --
7217: close c_irec_ass_rec;
7218: fnd_message.set_name('BEN','BEN_94027_NO_ACT_APL_ASS_FOUND');
7219: fnd_message.raise_error;
7220: --
7221: else -- begin irec2
7222: begin
7223: l_old_data_migrator_mode := hr_general.g_data_migrator_mode ;

Line 8066: fnd_message.set_name('BEN','BEN_91668_NO_FIND_POPL_ENRT');

8062: fetch c_popl_enrt_typ_cycl into l_ler_override_id, l_popl_enrt_typ_cycl_id;
8063: if c_popl_enrt_typ_cycl%notfound then
8064: --
8065: close c_popl_enrt_typ_cycl;
8066: fnd_message.set_name('BEN','BEN_91668_NO_FIND_POPL_ENRT');
8067: fnd_message.raise_error;
8068: --
8069: end if;
8070: --

Line 8067: fnd_message.raise_error;

8063: if c_popl_enrt_typ_cycl%notfound then
8064: --
8065: close c_popl_enrt_typ_cycl;
8066: fnd_message.set_name('BEN','BEN_91668_NO_FIND_POPL_ENRT');
8067: fnd_message.raise_error;
8068: --
8069: end if;
8070: --
8071: close c_popl_enrt_typ_cycl;

Line 8427: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');

8423: --
8424: if l_num_ranges = 0 then
8425: --
8426: if nvl(p_mode, 'X') <> 'W' then
8427: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
8428: -- Bug 3870204 : If no persons are selected then, dont error out, but just write the message
8429: -- in Audit Log and finish the process with Status = Normal
8430: -- fnd_message.raise_error;
8431: fnd_message.set_token('PROC' , l_package);

Line 8430: -- fnd_message.raise_error;

8426: if nvl(p_mode, 'X') <> 'W' then
8427: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
8428: -- Bug 3870204 : If no persons are selected then, dont error out, but just write the message
8429: -- in Audit Log and finish the process with Status = Normal
8430: -- fnd_message.raise_error;
8431: fnd_message.set_token('PROC' , l_package);
8432: raise l_no_one_to_process;
8433: end if;
8434: --

Line 8431: fnd_message.set_token('PROC' , l_package);

8427: fnd_message.set_name('BEN','BEN_91769_NOONE_TO_PROCESS');
8428: -- Bug 3870204 : If no persons are selected then, dont error out, but just write the message
8429: -- in Audit Log and finish the process with Status = Normal
8430: -- fnd_message.raise_error;
8431: fnd_message.set_token('PROC' , l_package);
8432: raise l_no_one_to_process;
8433: end if;
8434: --
8435: end if;

Line 8600: benutils.write(p_text => fnd_message.get);

8596: --
8597: exception
8598: -- Bug 3870204
8599: when l_no_one_to_process then
8600: benutils.write(p_text => fnd_message.get);
8601: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
8602: rollback;
8603: end internal_process;
8604: --

Line 9521: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

9517: close c_ler_exists;
9518: --
9519: end if;
9520: --
9521: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
9522: --
9523: -- CWB Changes : Added mode
9524: --
9525: if p_mode in ('C', 'L') then

Line 9530: fnd_message.set_token('PROC','ben_evaluate_ptnl_lf_evt');

9526: --
9527: if g_debug then
9528: hr_utility.set_location('Evaluate potential',10);
9529: end if;
9530: fnd_message.set_token('PROC','ben_evaluate_ptnl_lf_evt');
9531: --
9532: if p_validate = 'Y'
9533: then
9534: l_validate := TRUE;

Line 9556: fnd_message.set_token('PROC','ben_evaluate_ptnl_lf_evt');

9552: if g_debug then
9553: hr_utility.set_location('Evaluate iRec Potential LER',10);
9554: end if;
9555: --
9556: fnd_message.set_token('PROC','ben_evaluate_ptnl_lf_evt');
9557: --
9558: ben_evaluate_ptnl_lf_evt.irec_eval_ptnl_per_for_ler
9559: (p_validate => false,
9560: p_person_id => p_person_id,

Line 9578: fnd_message.set_token('PROC','cwb_eval_ptnl_per_for_ler');

9574: --
9575: if g_debug then
9576: hr_utility.set_location('CWB Evaluate potential',10);
9577: end if;
9578: fnd_message.set_token('PROC','cwb_eval_ptnl_per_for_ler');
9579: --
9580: ben_evaluate_ptnl_lf_evt.cwb_eval_ptnl_per_for_ler
9581: (p_validate => false,
9582: p_person_id => p_person_id,

Line 9754: fnd_message.set_name('BEN','BEN_92145_MODE_LE_DIFFER');

9750: l_use_mode := 'Scheduled mode';
9751: else
9752: l_use_mode := 'Life event mode';
9753: end if;
9754: fnd_message.set_name('BEN','BEN_92145_MODE_LE_DIFFER');
9755: fnd_message.set_token('MODE',l_use_mode);
9756: --
9757: -- Bug 2836770
9758: -- Set proper values to global variables before raising error

Line 9755: fnd_message.set_token('MODE',l_use_mode);

9751: else
9752: l_use_mode := 'Life event mode';
9753: end if;
9754: fnd_message.set_name('BEN','BEN_92145_MODE_LE_DIFFER');
9755: fnd_message.set_token('MODE',l_use_mode);
9756: --
9757: -- Bug 2836770
9758: -- Set proper values to global variables before raising error
9759: -- Once value is retrieved from fnd_message.get, the next call

Line 9759: -- Once value is retrieved from fnd_message.get, the next call

9755: fnd_message.set_token('MODE',l_use_mode);
9756: --
9757: -- Bug 2836770
9758: -- Set proper values to global variables before raising error
9759: -- Once value is retrieved from fnd_message.get, the next call
9760: -- return null value. Hence set the values.
9761: --
9762: g_rec.text := fnd_message.get;
9763: g_rec.error_message_code := 'BEN_92145_MODE_LE_DIFFER';

Line 9762: g_rec.text := fnd_message.get;

9758: -- Set proper values to global variables before raising error
9759: -- Once value is retrieved from fnd_message.get, the next call
9760: -- return null value. Hence set the values.
9761: --
9762: g_rec.text := fnd_message.get;
9763: g_rec.error_message_code := 'BEN_92145_MODE_LE_DIFFER';
9764: benutils.write(p_text => g_rec.text );
9765: --
9766: -- Bug 2836770

Line 9772: fnd_message.set_name('BEN','BEN_92145_MODE_LE_DIFFER');

9768: -- Bug : 3658807
9769: -- Set the message name so that correct message is displayed in
9770: -- BENAUTHE.pld (Life Events Evaluation Processing Summary) - Messages
9771: --
9772: fnd_message.set_name('BEN','BEN_92145_MODE_LE_DIFFER');
9773: fnd_message.set_token('MODE',l_use_mode);
9774: raise g_record_error;
9775: --
9776: end if;

Line 9773: fnd_message.set_token('MODE',l_use_mode);

9769: -- Set the message name so that correct message is displayed in
9770: -- BENAUTHE.pld (Life Events Evaluation Processing Summary) - Messages
9771: --
9772: fnd_message.set_name('BEN','BEN_92145_MODE_LE_DIFFER');
9773: fnd_message.set_token('MODE',l_use_mode);
9774: raise g_record_error;
9775: --
9776: end if;
9777: --

Line 9795: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

9791: ben_env_object.setenv(p_lf_evt_ocrd_dt => l_rec.lf_evt_ocrd_dt);
9792: dt_fndate.change_ses_date
9793: (p_ses_date => l_rec.lf_evt_ocrd_dt,
9794: p_commit => l_commit);
9795: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
9796: fnd_message.set_token('PROC','ben_related_person_ler_api');
9797: if g_debug then
9798: hr_utility.set_location (l_package||' create_rel_per_ler ' ,20);
9799: end if;

Line 9796: fnd_message.set_token('PROC','ben_related_person_ler_api');

9792: dt_fndate.change_ses_date
9793: (p_ses_date => l_rec.lf_evt_ocrd_dt,
9794: p_commit => l_commit);
9795: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
9796: fnd_message.set_token('PROC','ben_related_person_ler_api');
9797: if g_debug then
9798: hr_utility.set_location (l_package||' create_rel_per_ler ' ,20);
9799: end if;
9800: --

Line 10033: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

10029: end if;
10030: --
10031: end if;
10032: --
10033: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
10034: fnd_message.set_token('PROC','benutils.get_batch_parameters');
10035: ben_enrolment_requirements.g_electable_choice_created := false;
10036: ben_enrolment_requirements.g_any_choice_created := false;
10037: ben_enrolment_requirements.g_auto_choice_created := false;

Line 10034: fnd_message.set_token('PROC','benutils.get_batch_parameters');

10030: --
10031: end if;
10032: --
10033: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
10034: fnd_message.set_token('PROC','benutils.get_batch_parameters');
10035: ben_enrolment_requirements.g_electable_choice_created := false;
10036: ben_enrolment_requirements.g_any_choice_created := false;
10037: ben_enrolment_requirements.g_auto_choice_created := false;
10038: ben_determine_dpnt_eligibility.g_dpnt_ineligible := false;

Line 10936: fnd_message.set_name('BEN','BEN_94094_PERSON_GRADE_NOT_FND');

10932: if l_gsp_pgm_id is null or
10933: l_gsp_plip_id is null
10934: then
10935: hr_utility.set_location('Current GSP Grade Ladder / Grade / PLIP for person not found', 15);
10936: fnd_message.set_name('BEN','BEN_94094_PERSON_GRADE_NOT_FND');
10937: raise g_record_error;
10938: elsif l_prgr_style not in ('PQH_GSP_GP') and l_gsp_oipl_id is null /* Bug 3964719 */
10939: then
10940: hr_utility.set_location('Current GSP OIPL for person not found', 15);

Line 10941: fnd_message.set_name('BEN','BEN_94095_PERSON_STEP_NOT_FND');

10937: raise g_record_error;
10938: elsif l_prgr_style not in ('PQH_GSP_GP') and l_gsp_oipl_id is null /* Bug 3964719 */
10939: then
10940: hr_utility.set_location('Current GSP OIPL for person not found', 15);
10941: fnd_message.set_name('BEN','BEN_94095_PERSON_STEP_NOT_FND');
10942: raise g_record_error;
10943: end if;
10944: --
10945: open c_ptip_pl_id(l_gsp_pgm_id,l_gsp_plip_id);

Line 10987: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

10983: end if;
10984: --
10985: end if;
10986: --
10987: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
10988: fnd_message.set_token('PROC','BEN_CARRY_FORWARD_ITEMS');
10989: --
10990: -- If the event is staying open, then delete the suspended enrollments
10991: -- and action items

Line 10988: fnd_message.set_token('PROC','BEN_CARRY_FORWARD_ITEMS');

10984: --
10985: end if;
10986: --
10987: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
10988: fnd_message.set_token('PROC','BEN_CARRY_FORWARD_ITEMS');
10989: --
10990: -- If the event is staying open, then delete the suspended enrollments
10991: -- and action items
10992: --

Line 11462: hr_utility.set_location (l_package||' fnd_message_call ',30);

11458: --
11459: if p_derivable_factors <> 'NONE' then
11460: --
11461: if g_debug then
11462: hr_utility.set_location (l_package||' fnd_message_call ',30);
11463: end if;
11464: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11465: fnd_message.set_token('PROC','ben_derive_part_and_rate_facts');
11466: if g_debug then

Line 11464: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11460: --
11461: if g_debug then
11462: hr_utility.set_location (l_package||' fnd_message_call ',30);
11463: end if;
11464: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11465: fnd_message.set_token('PROC','ben_derive_part_and_rate_facts');
11466: if g_debug then
11467: hr_utility.set_location (l_package||' done fnd_message_call ',30);
11468: hr_utility.set_location (l_package||' DRAF ',15);

Line 11465: fnd_message.set_token('PROC','ben_derive_part_and_rate_facts');

11461: if g_debug then
11462: hr_utility.set_location (l_package||' fnd_message_call ',30);
11463: end if;
11464: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11465: fnd_message.set_token('PROC','ben_derive_part_and_rate_facts');
11466: if g_debug then
11467: hr_utility.set_location (l_package||' done fnd_message_call ',30);
11468: hr_utility.set_location (l_package||' DRAF ',15);
11469: end if;

Line 11467: hr_utility.set_location (l_package||' done fnd_message_call ',30);

11463: end if;
11464: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11465: fnd_message.set_token('PROC','ben_derive_part_and_rate_facts');
11466: if g_debug then
11467: hr_utility.set_location (l_package||' done fnd_message_call ',30);
11468: hr_utility.set_location (l_package||' DRAF ',15);
11469: end if;
11470: ben_derive_part_and_rate_facts.derive_rates_and_factors
11471: (p_comp_obj_tree_row => l_comp_obj_tree_row

Line 11531: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11527: --
11528: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
11529: if l_mode not in ('R','T') then
11530: --
11531: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11532: fnd_message.set_token('PROC','ben_determine_eligibility');
11533: if g_debug then
11534: hr_utility.set_location (l_package||' Dn FND Mess ',80);
11535: end if;

Line 11532: fnd_message.set_token('PROC','ben_determine_eligibility');

11528: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
11529: if l_mode not in ('R','T') then
11530: --
11531: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11532: fnd_message.set_token('PROC','ben_determine_eligibility');
11533: if g_debug then
11534: hr_utility.set_location (l_package||' Dn FND Mess ',80);
11535: end if;
11536: --

Line 11863: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11859: --
11860: if g_debug then
11861: hr_utility.set_location (l_package||' FND Bf BENDENRR ',85);
11862: end if;
11863: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11864: fnd_message.set_token('PROC','ben_enrolment_requirements');
11865: --
11866: -- p_mode changed to l_mode in following line by Gopal Venkataraman
11867: -- 3/27/01 bug 1636071

Line 11864: fnd_message.set_token('PROC','ben_enrolment_requirements');

11860: if g_debug then
11861: hr_utility.set_location (l_package||' FND Bf BENDENRR ',85);
11862: end if;
11863: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11864: fnd_message.set_token('PROC','ben_enrolment_requirements');
11865: --
11866: -- p_mode changed to l_mode in following line by Gopal Venkataraman
11867: -- 3/27/01 bug 1636071
11868: --

Line 11919: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11915: --
11916: ben_epe_cache.g_currcobjepe_row.ler_id := p_ler_id;
11917: ben_epe_cache.g_currcobjepe_row.opt_id := l_comp_obj_tree(l_treeele_num).par_opt_id;
11918: --
11919: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11920: fnd_message.set_token('PROC','ben_determine_dpnt_eligibility');
11921: --
11922: if g_debug then
11923: hr_utility.set_location (l_package||' BDDE_PUEWEID ',110);

Line 11920: fnd_message.set_token('PROC','ben_determine_dpnt_eligibility');

11916: ben_epe_cache.g_currcobjepe_row.ler_id := p_ler_id;
11917: ben_epe_cache.g_currcobjepe_row.opt_id := l_comp_obj_tree(l_treeele_num).par_opt_id;
11918: --
11919: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11920: fnd_message.set_token('PROC','ben_determine_dpnt_eligibility');
11921: --
11922: if g_debug then
11923: hr_utility.set_location (l_package||' BDDE_PUEWEID ',110);
11924: end if;

Line 11943: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11939: );
11940: --
11941: end if;
11942: --
11943: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11944: fnd_message.set_token('PROC','BEN_DETERMINE_CHC_CTFN');
11945: --
11946: if g_debug then
11947: hr_utility.set_location ('BDCC_MN '||l_package,10);

Line 11944: fnd_message.set_token('PROC','BEN_DETERMINE_CHC_CTFN');

11940: --
11941: end if;
11942: --
11943: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11944: fnd_message.set_token('PROC','BEN_DETERMINE_CHC_CTFN');
11945: --
11946: if g_debug then
11947: hr_utility.set_location ('BDCC_MN '||l_package,10);
11948: end if;

Line 11960: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

11956: if g_debug then
11957: hr_utility.set_location ('Dn BDCC_MN '||l_package,10);
11958: end if;
11959: --
11960: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11961: fnd_message.set_token('PROC','ben_determine_coverage');
11962: --
11963: if g_debug then
11964: hr_utility.set_location (l_package||' ben_determine_coverage.main ',110);

Line 11961: fnd_message.set_token('PROC','ben_determine_coverage');

11957: hr_utility.set_location ('Dn BDCC_MN '||l_package,10);
11958: end if;
11959: --
11960: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11961: fnd_message.set_token('PROC','ben_determine_coverage');
11962: --
11963: if g_debug then
11964: hr_utility.set_location (l_package||' ben_determine_coverage.main ',110);
11965: end if;

Line 12019: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

12015: if g_debug then
12016: hr_utility.set_location (l_package||' FND Bf BENDENRR ',86);
12017: hr_utility.set_location ('l_oipl_id' ||l_oipl_id,87);
12018: end if;
12019: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12020: fnd_message.set_token('PROC','ben_enrolment_requirements');
12021: --
12022: ben_enrolment_requirements.enrolment_requirements
12023: (p_comp_obj_tree_row => l_comp_obj_tree_row

Line 12020: fnd_message.set_token('PROC','ben_enrolment_requirements');

12016: hr_utility.set_location (l_package||' FND Bf BENDENRR ',86);
12017: hr_utility.set_location ('l_oipl_id' ||l_oipl_id,87);
12018: end if;
12019: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12020: fnd_message.set_token('PROC','ben_enrolment_requirements');
12021: --
12022: ben_enrolment_requirements.enrolment_requirements
12023: (p_comp_obj_tree_row => l_comp_obj_tree_row
12024: ,p_run_mode => 'U' --l_mode

Line 12311: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

12307: );
12308: -- 1895846 call
12309: -- to delete the egd records create for the suspended pen or in pending wkflow epe records
12310: --
12311: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12312: fnd_message.set_token('PROC','delete_in_pndg_elig_dpnt');
12313: --
12314: delete_in_pndg_elig_dpnt( l_rec.per_in_ler_id,p_effective_date ) ;
12315: --

Line 12312: fnd_message.set_token('PROC','delete_in_pndg_elig_dpnt');

12308: -- 1895846 call
12309: -- to delete the egd records create for the suspended pen or in pending wkflow epe records
12310: --
12311: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12312: fnd_message.set_token('PROC','delete_in_pndg_elig_dpnt');
12313: --
12314: delete_in_pndg_elig_dpnt( l_rec.per_in_ler_id,p_effective_date ) ;
12315: --
12316: end if;

Line 12317: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

12313: --
12314: delete_in_pndg_elig_dpnt( l_rec.per_in_ler_id,p_effective_date ) ;
12315: --
12316: end if;
12317: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12318: fnd_message.set_token('PROC','ben_determine_elct_chc_flx_imp');
12319: if g_debug then
12320: hr_utility.set_location('lf evt ocrd dt'||l_rec.lf_evt_ocrd_dt,11);
12321: end if;

Line 12318: fnd_message.set_token('PROC','ben_determine_elct_chc_flx_imp');

12314: delete_in_pndg_elig_dpnt( l_rec.per_in_ler_id,p_effective_date ) ;
12315: --
12316: end if;
12317: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12318: fnd_message.set_token('PROC','ben_determine_elct_chc_flx_imp');
12319: if g_debug then
12320: hr_utility.set_location('lf evt ocrd dt'||l_rec.lf_evt_ocrd_dt,11);
12321: end if;
12322: --

Line 12367: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

12363: then
12364: if g_debug then
12365: hr_utility.set_location (l_package||'.ben_determine_actual_premium ',10);
12366: end if;
12367: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12368: fnd_message.set_token('PROC','ben_determine_actual_premium');
12369: --
12370: ben_determine_actual_premium.main
12371: (p_person_id => p_person_id,

Line 12368: fnd_message.set_token('PROC','ben_determine_actual_premium');

12364: if g_debug then
12365: hr_utility.set_location (l_package||'.ben_determine_actual_premium ',10);
12366: end if;
12367: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12368: fnd_message.set_token('PROC','ben_determine_actual_premium');
12369: --
12370: ben_determine_actual_premium.main
12371: (p_person_id => p_person_id,
12372: p_effective_date => p_effective_date,

Line 12386: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

12382: --
12383: if g_debug then
12384: hr_utility.set_location ('FND mess '||l_package,10);
12385: end if;
12386: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12387: fnd_message.set_token('PROC','ben_determine_rates');
12388: --
12389:
12390: -- bug 12354919

Line 12387: fnd_message.set_token('PROC','ben_determine_rates');

12383: if g_debug then
12384: hr_utility.set_location ('FND mess '||l_package,10);
12385: end if;
12386: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12387: fnd_message.set_token('PROC','ben_determine_rates');
12388: --
12389:
12390: -- bug 12354919
12391: -- refresh the cache g_unrest_ecr_instance since ovn has changed after imputed shell rate got updated

Line 12483: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

12479: end if;
12480: if g_debug then
12481: hr_utility.set_location ('ben_determine_rate_chg '||l_package,10);
12482: end if;
12483: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12484: fnd_message.set_token('PROC','ben_determine_rate_chg');
12485: --
12486: -- Turn off distribute rates function caching because cached information
12487: -- is updated in later RCOs. Any further RCOs will hit the DB rather the

Line 12484: fnd_message.set_token('PROC','ben_determine_rate_chg');

12480: if g_debug then
12481: hr_utility.set_location ('ben_determine_rate_chg '||l_package,10);
12482: end if;
12483: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12484: fnd_message.set_token('PROC','ben_determine_rate_chg');
12485: --
12486: -- Turn off distribute rates function caching because cached information
12487: -- is updated in later RCOs. Any further RCOs will hit the DB rather the
12488: -- function cache.

Line 12510: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

12506: end if;
12507: --
12508: end if;
12509: --
12510: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12511: fnd_message.set_token('PROC','reset_elctbl_chc_inpng_flag');
12512: --
12513: -- Reset the in_pndg_wkflow_flag to 'N' for the suspended enrollment cases
12514: --

Line 12511: fnd_message.set_token('PROC','reset_elctbl_chc_inpng_flag');

12507: --
12508: end if;
12509: --
12510: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12511: fnd_message.set_token('PROC','reset_elctbl_chc_inpng_flag');
12512: --
12513: -- Reset the in_pndg_wkflow_flag to 'N' for the suspended enrollment cases
12514: --
12515: reset_elctbl_chc_inpng_flag(l_rec.per_in_ler_id,p_effective_date );

Line 12531: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

12527: p_effective_date => l_rec.lf_evt_ocrd_dt);
12528: --
12529: end if;
12530: --
12531: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12532: fnd_message.set_token('PROC','ben_automatic_enrollments');
12533: --
12534: -- Do the automatic enrollments
12535: --

Line 12532: fnd_message.set_token('PROC','ben_automatic_enrollments');

12528: --
12529: end if;
12530: --
12531: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12532: fnd_message.set_token('PROC','ben_automatic_enrollments');
12533: --
12534: -- Do the automatic enrollments
12535: --
12536: -- CWB Changes.

Line 12560: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');

12556: --
12557: --
12558: -- Check for reqired communications
12559: --
12560: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12561: fnd_message.set_token('PROC','ben_generate_communications');
12562: --
12563: if g_debug then
12564: hr_utility.set_location ('Comms '||l_package,10);

Line 12561: fnd_message.set_token('PROC','ben_generate_communications');

12557: --
12558: -- Check for reqired communications
12559: --
12560: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12561: fnd_message.set_token('PROC','ben_generate_communications');
12562: --
12563: if g_debug then
12564: hr_utility.set_location ('Comms '||l_package,10);
12565: end if;

Line 12812: fnd_message.set_name('BEN','BEN_91462_PTIP_MISSING');

12808: open c_get_ptip(l_rslt_rec.ptip_id);
12809: fetch c_get_ptip into l_ptip_rec;
12810: if c_get_ptip%notfound then
12811: close c_get_ptip;
12812: fnd_message.set_name('BEN','BEN_91462_PTIP_MISSING');
12813: fnd_message.set_token('ID', to_char(l_rslt_rec.ptip_id) );
12814: fnd_message.raise_error;
12815: end if;
12816: --

Line 12813: fnd_message.set_token('ID', to_char(l_rslt_rec.ptip_id) );

12809: fetch c_get_ptip into l_ptip_rec;
12810: if c_get_ptip%notfound then
12811: close c_get_ptip;
12812: fnd_message.set_name('BEN','BEN_91462_PTIP_MISSING');
12813: fnd_message.set_token('ID', to_char(l_rslt_rec.ptip_id) );
12814: fnd_message.raise_error;
12815: end if;
12816: --
12817: close c_get_ptip;

Line 12814: fnd_message.raise_error;

12810: if c_get_ptip%notfound then
12811: close c_get_ptip;
12812: fnd_message.set_name('BEN','BEN_91462_PTIP_MISSING');
12813: fnd_message.set_token('ID', to_char(l_rslt_rec.ptip_id) );
12814: fnd_message.raise_error;
12815: end if;
12816: --
12817: close c_get_ptip;
12818: --

Line 12835: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');

12831: close c_get_ptip_tot_enrd;
12832: hr_utility.set_location (' MN_ENRD_RQD_OVRID_NUM '||l_ptip_rec.MN_ENRD_RQD_OVRID_NUM,10);
12833: if (l_count < l_MN_ENRD_RQD_OVRID_NUM ) then
12834: hr_utility.set_location (' error '||l_count,10);
12835: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');
12836: fnd_message.set_token('MN_ENRL', to_char(l_MN_ENRD_RQD_OVRID_NUM));
12837: fnd_message.set_token('PL_TYP_NAME', l_ptip_rec.name);
12838: fnd_message.raise_error;
12839: end if;

Line 12836: fnd_message.set_token('MN_ENRL', to_char(l_MN_ENRD_RQD_OVRID_NUM));

12832: hr_utility.set_location (' MN_ENRD_RQD_OVRID_NUM '||l_ptip_rec.MN_ENRD_RQD_OVRID_NUM,10);
12833: if (l_count < l_MN_ENRD_RQD_OVRID_NUM ) then
12834: hr_utility.set_location (' error '||l_count,10);
12835: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');
12836: fnd_message.set_token('MN_ENRL', to_char(l_MN_ENRD_RQD_OVRID_NUM));
12837: fnd_message.set_token('PL_TYP_NAME', l_ptip_rec.name);
12838: fnd_message.raise_error;
12839: end if;
12840: end if;

Line 12837: fnd_message.set_token('PL_TYP_NAME', l_ptip_rec.name);

12833: if (l_count < l_MN_ENRD_RQD_OVRID_NUM ) then
12834: hr_utility.set_location (' error '||l_count,10);
12835: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');
12836: fnd_message.set_token('MN_ENRL', to_char(l_MN_ENRD_RQD_OVRID_NUM));
12837: fnd_message.set_token('PL_TYP_NAME', l_ptip_rec.name);
12838: fnd_message.raise_error;
12839: end if;
12840: end if;
12841: end loop;

Line 12838: fnd_message.raise_error;

12834: hr_utility.set_location (' error '||l_count,10);
12835: fnd_message.set_name('BEN','BEN_91588_PL_ENRD_LT_MN_RQD');
12836: fnd_message.set_token('MN_ENRL', to_char(l_MN_ENRD_RQD_OVRID_NUM));
12837: fnd_message.set_token('PL_TYP_NAME', l_ptip_rec.name);
12838: fnd_message.raise_error;
12839: end if;
12840: end if;
12841: end loop;
12842: end if;

Line 13396: l_encoded_message := fnd_message.get_encoded;

13392: g_rec.person_id := p_person_id;
13393: g_rec.pgm_id := l_env.pgm_id;
13394: g_rec.pl_id := l_env.pl_id;
13395: g_rec.oipl_id := l_env.oipl_id;
13396: l_encoded_message := fnd_message.get_encoded;
13397: fnd_message.parse_encoded(encoded_message => l_encoded_message,
13398: app_short_name => l_app_short_name,
13399: message_name => l_message_name);
13400: fnd_message.set_encoded(encoded_message => l_encoded_message);

Line 13397: fnd_message.parse_encoded(encoded_message => l_encoded_message,

13393: g_rec.pgm_id := l_env.pgm_id;
13394: g_rec.pl_id := l_env.pl_id;
13395: g_rec.oipl_id := l_env.oipl_id;
13396: l_encoded_message := fnd_message.get_encoded;
13397: fnd_message.parse_encoded(encoded_message => l_encoded_message,
13398: app_short_name => l_app_short_name,
13399: message_name => l_message_name);
13400: fnd_message.set_encoded(encoded_message => l_encoded_message);
13401:

Line 13400: fnd_message.set_encoded(encoded_message => l_encoded_message);

13396: l_encoded_message := fnd_message.get_encoded;
13397: fnd_message.parse_encoded(encoded_message => l_encoded_message,
13398: app_short_name => l_app_short_name,
13399: message_name => l_message_name);
13400: fnd_message.set_encoded(encoded_message => l_encoded_message);
13401:
13402: g_rec.rep_typ_cd := 'ERROR';
13403: g_rec.national_identifier := l_per_rec.national_identifier;
13404:

Line 13406: -- Added nvl's for l_message_name and fnd_message.get

13402: g_rec.rep_typ_cd := 'ERROR';
13403: g_rec.national_identifier := l_per_rec.national_identifier;
13404:
13405: -- Bug 2836770
13406: -- Added nvl's for l_message_name and fnd_message.get
13407: -- made call to write_table_and_file
13408: --
13409: g_rec.error_message_code := nvl(l_message_name , g_rec.error_message_code);
13410: g_rec.text := nvl(fnd_message.get , g_rec.text );

Line 13410: g_rec.text := nvl(fnd_message.get , g_rec.text );

13406: -- Added nvl's for l_message_name and fnd_message.get
13407: -- made call to write_table_and_file
13408: --
13409: g_rec.error_message_code := nvl(l_message_name , g_rec.error_message_code);
13410: g_rec.text := nvl(fnd_message.get , g_rec.text );
13411: --
13412: --benutils.write(p_text => g_rec.text); /* GSP Rate Sync */
13413: benutils.write(p_rec => g_rec);
13414: --

Line 13434: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');

13430: ben_use_cvg_rt_date.clear_fonm_globals;
13431: --
13432: if p_error_person_count = g_max_errors_allowed then
13433: --
13434: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');
13435: benutils.write(p_text => fnd_message.get);
13436: if g_debug then
13437: hr_utility.set_location ('PLE g_record_error Err Lim '||l_package,10);
13438: end if;

Line 13435: benutils.write(p_text => fnd_message.get);

13431: --
13432: if p_error_person_count = g_max_errors_allowed then
13433: --
13434: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');
13435: benutils.write(p_text => fnd_message.get);
13436: if g_debug then
13437: hr_utility.set_location ('PLE g_record_error Err Lim '||l_package,10);
13438: end if;
13439: --

Line 13519: l_encoded_message := fnd_message.get_encoded;

13515: g_rec.person_id := p_person_id;
13516: g_rec.pgm_id := l_env.pgm_id;
13517: g_rec.pl_id := l_env.pl_id;
13518: g_rec.oipl_id := l_env.oipl_id;
13519: l_encoded_message := fnd_message.get_encoded;
13520: fnd_message.parse_encoded(encoded_message => l_encoded_message,
13521: app_short_name => l_app_short_name,
13522: message_name => l_message_name);
13523: fnd_message.set_encoded(encoded_message => l_encoded_message);

Line 13520: fnd_message.parse_encoded(encoded_message => l_encoded_message,

13516: g_rec.pgm_id := l_env.pgm_id;
13517: g_rec.pl_id := l_env.pl_id;
13518: g_rec.oipl_id := l_env.oipl_id;
13519: l_encoded_message := fnd_message.get_encoded;
13520: fnd_message.parse_encoded(encoded_message => l_encoded_message,
13521: app_short_name => l_app_short_name,
13522: message_name => l_message_name);
13523: fnd_message.set_encoded(encoded_message => l_encoded_message);
13524: g_rec.rep_typ_cd := 'ERROR';

Line 13523: fnd_message.set_encoded(encoded_message => l_encoded_message);

13519: l_encoded_message := fnd_message.get_encoded;
13520: fnd_message.parse_encoded(encoded_message => l_encoded_message,
13521: app_short_name => l_app_short_name,
13522: message_name => l_message_name);
13523: fnd_message.set_encoded(encoded_message => l_encoded_message);
13524: g_rec.rep_typ_cd := 'ERROR';
13525: g_rec.error_message_code := l_message_name;
13526: g_rec.national_identifier := l_per_rec.national_identifier;
13527: g_rec.text := fnd_message.get;

Line 13527: g_rec.text := fnd_message.get;

13523: fnd_message.set_encoded(encoded_message => l_encoded_message);
13524: g_rec.rep_typ_cd := 'ERROR';
13525: g_rec.error_message_code := l_message_name;
13526: g_rec.national_identifier := l_per_rec.national_identifier;
13527: g_rec.text := fnd_message.get;
13528: benutils.write(p_text => g_rec.text);
13529: benutils.write(p_rec => g_rec);
13530: --
13531: g_action_rec.person_action_id := p_person_action_id;

Line 13546: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');

13542: p_error_person_count := p_error_person_count +1;
13543: --
13544: if p_error_person_count = g_max_errors_allowed then
13545: --
13546: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');
13547: benutils.write(p_text => fnd_message.get);
13548: --
13549: -- Write the last bit of information for the thread before
13550: -- the rollback fires when we raise the error.

Line 13547: benutils.write(p_text => fnd_message.get);

13543: --
13544: if p_error_person_count = g_max_errors_allowed then
13545: --
13546: fnd_message.set_name('BEN','BEN_91662_BENMNGLE_ERROR_LIMIT');
13547: benutils.write(p_text => fnd_message.get);
13548: --
13549: -- Write the last bit of information for the thread before
13550: -- the rollback fires when we raise the error.
13551: --