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.

[Home] [Help]

APPS.BEN_EVALUATE_PTNL_LF_EVT dependencies on HR_UTILITY

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

243: -- end bug
244:
245: begin
246: --
247: hr_utility.set_location('Entering:'|| l_proc, 10);
248: --
249: -- Initialise all the variables in the loop.
250: --
251: loop

Line 589: hr_utility.set_location('Leaving:'|| l_proc, 10);

585:
586: p_created_ler_id := l_winning_ptnl_rec.ler_id;
587:
588: if not l_create_per_in_ler then
589: hr_utility.set_location('Leaving:'|| l_proc, 10);
590: raise ben_manage_life_events.g_life_event_after;
591: end if;
592:
593:

Line 628: hr_utility.set_location('Leaving:'|| l_proc, 10);

624: ben_evaluate_ptnl_lf_evt.g_bckdt_pil_tbl.delete;
625:
626: --End 6086392
627:
628: hr_utility.set_location('Leaving:'|| l_proc, 10);
629: --
630: -- bug 5987235
631: Exception
632: when ben_manage_life_events.g_life_event_after then

Line 633: hr_utility.set_location('PTNLE Absence eval Exception g_life_event_after', 121);

629: --
630: -- bug 5987235
631: Exception
632: when ben_manage_life_events.g_life_event_after then
633: hr_utility.set_location('PTNLE Absence eval Exception g_life_event_after', 121);
634: ben_evaluate_ptnl_lf_evt.g_bckdt_pil_tbl.delete;
635: raise ben_manage_life_events.g_life_event_after;
636: when others then
637: hr_utility.set_location('PTNLE Absence eval Exception ', 121);

Line 637: hr_utility.set_location('PTNLE Absence eval Exception ', 121);

633: hr_utility.set_location('PTNLE Absence eval Exception g_life_event_after', 121);
634: ben_evaluate_ptnl_lf_evt.g_bckdt_pil_tbl.delete;
635: raise ben_manage_life_events.g_life_event_after;
636: when others then
637: hr_utility.set_location('PTNLE Absence eval Exception ', 121);
638: ben_evaluate_ptnl_lf_evt.g_bckdt_pil_tbl.delete;
639: fnd_message.raise_error;
640: -- end bug 5987235
641: end absences_eval_ptnl_per_for_ler;

Line 730: hr_utility.set_location('Entering cwb_eval_ptnl_per_for_ler',10);

726: l_rec benutils.g_batch_param_rec;
727: --
728: begin
729: --
730: hr_utility.set_location('Entering cwb_eval_ptnl_per_for_ler',10);
731: hr_utility.set_location('ler_id = ' || p_ler_id,12345);
732: hr_utility.set_location('p_lf_evt_ocrd_dt = ' || p_lf_evt_ocrd_dt,12345);
733: --
734: -- Check whether a per in ler exists for a given ler_id,

Line 731: hr_utility.set_location('ler_id = ' || p_ler_id,12345);

727: --
728: begin
729: --
730: hr_utility.set_location('Entering cwb_eval_ptnl_per_for_ler',10);
731: hr_utility.set_location('ler_id = ' || p_ler_id,12345);
732: hr_utility.set_location('p_lf_evt_ocrd_dt = ' || p_lf_evt_ocrd_dt,12345);
733: --
734: -- Check whether a per in ler exists for a given ler_id,
735: -- life event occured date

Line 732: hr_utility.set_location('p_lf_evt_ocrd_dt = ' || p_lf_evt_ocrd_dt,12345);

728: begin
729: --
730: hr_utility.set_location('Entering cwb_eval_ptnl_per_for_ler',10);
731: hr_utility.set_location('ler_id = ' || p_ler_id,12345);
732: hr_utility.set_location('p_lf_evt_ocrd_dt = ' || p_lf_evt_ocrd_dt,12345);
733: --
734: -- Check whether a per in ler exists for a given ler_id,
735: -- life event occured date
736: --

Line 745: hr_utility.set_location('A',10);

741: if l_pil_rec.lf_evt_ocrd_dt is null then
742: --
743: -- Case A : Create the per in ler.
744: --
745: hr_utility.set_location('A',10);
746: --
747: open c_ptnl(p_ptnl_ler_for_per_id);
748: fetch c_ptnl into l_ptnl_rec;
749: close c_ptnl;

Line 770: hr_utility.set_location(ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id ,1234);

766: p_pl_id => l_rec.pl_id,
767: p_lf_evt_ocrd_dt => l_rec.lf_evt_ocrd_dt,
768: p_business_group_id => l_rec.business_group_id);
769: --
770: hr_utility.set_location(ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id ,1234);
771: if l_rec.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
772: --
773: ben_manage_cwb_life_events.get_cwb_manager_and_assignment
774: (p_person_id => p_person_id,

Line 781: hr_utility.set_location('l_ws_mgr_id = ' || l_ws_mgr_id, 1234);

777: p_effective_date => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,
778: p_manager_id => l_ws_mgr_id,
779: p_assignment_id => l_assignment_id ) ;
780: --
781: hr_utility.set_location('l_ws_mgr_id = ' || l_ws_mgr_id, 1234);
782: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);
783: end if;
784: end if;
785: --

Line 782: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);

778: p_manager_id => l_ws_mgr_id,
779: p_assignment_id => l_assignment_id ) ;
780: --
781: hr_utility.set_location('l_ws_mgr_id = ' || l_ws_mgr_id, 1234);
782: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);
783: end if;
784: end if;
785: --
786: hr_utility.set_location('group_pl_id = ' || ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 1234);

Line 786: hr_utility.set_location('group_pl_id = ' || ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 1234);

782: hr_utility.set_location('l_assignment_id = ' || l_assignment_id, 1234);
783: end if;
784: end if;
785: --
786: hr_utility.set_location('group_pl_id = ' || ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id, 1234);
787: ben_Person_Life_Event_api.create_Person_Life_Event_perf
788: (p_validate => false
789: ,p_per_in_ler_id => l_curr_per_in_ler_id
790: ,p_ler_id => p_ler_id

Line 815: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 1234);

811: --
812: -- Per in ler created is a group per in ler so populate other
813: -- plan design tables.
814: --
815: hr_utility.set_location('Call ben_manage_cwb_life_events.popu_cwb_tables', 1234);
816: ben_manage_cwb_life_events.popu_cwb_tables(
817: p_group_per_in_ler_id => l_curr_per_in_ler_id,
818: p_group_pl_id => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
819: p_group_lf_evt_ocrd_dt => ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt,

Line 853: hr_utility.set_location('Case B ',10);

849: ,p_effective_date => p_effective_date);
850: --
851: elsif p_lf_evt_ocrd_dt > l_pil_rec.lf_evt_ocrd_dt then
852: --
853: hr_utility.set_location('Case B ',10);
854: --
855: -- Case B : Potential is after active per in ler. First complete it.
856: --
857: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');

Line 892: hr_utility.set_location('Case C ',10);

888: raise ben_manage_life_events.g_life_event_after;
889: --
890: else
891: --
892: hr_utility.set_location('Case C ',10);
893: --
894: -- Case C : Processed or active per in ler is in future for the given
895: -- ler so error out. You can't go back and run.
896: --

Line 933: hr_utility.set_location('Leaving cwb_eval_ptnl_per_for_ler',10);

929: --
930: --
931: end if;
932: --
933: hr_utility.set_location('Leaving cwb_eval_ptnl_per_for_ler',10);
934: --
935: end cwb_eval_ptnl_per_for_ler;
936: --
937: -- GRADE/STEP : process the grade/step potential life events.

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

1021: l_dummy varchar2(1);
1022: --
1023: begin
1024: --
1025: hr_utility.set_location('Entering:'|| l_proc, 10);
1026: --
1027: -- Step 1 : Find a potential life event with least lf_evt_ocrd_dt.
1028: -- Step 2 : Get a started or processed grade/step life event.
1029: -- If found log a message and skip processing of this person.

Line 1186: hr_utility.set_location('GSP Rate Sync processed withouth GSP Prog', 9);

1182: then
1183: --
1184: -- GSP Rate Sync is being processed for a person who is never processed for GSP Prog in the past
1185: close c_gsp_prog_procd_exists;
1186: hr_utility.set_location('GSP Rate Sync processed withouth GSP Prog', 9);
1187: --
1188: fnd_message.set_name('BEN','BEN_94091_NO_GSP_PROG_PROCD');
1189: benutils.write(fnd_message.get);
1190: --

Line 1266: hr_utility.set_location('Leaving:'|| l_proc, 10);

1262: ,p_request_id => fnd_global.conc_request_id
1263: ,p_program_update_date => sysdate);
1264: --
1265: end if;
1266: hr_utility.set_location('Leaving:'|| l_proc, 10);
1267: --
1268: end grd_stp_eval_ptnl_per_for_ler;
1269: --
1270: -- ----------------------------------------------------------------------------

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

1693: l_mnl_ler_name ben_ler_f.name%type;
1694: --
1695: begin
1696: --
1697: hr_utility.set_location('Entering:'|| l_proc, 10);
1698: --
1699: -- Rules
1700: --
1701: -- 1) if tmlns_eval_cd is null then

Line 1774: hr_utility.set_location(' tmlns_eval_cd '|| l_potent.tmlns_eval_cd , 10);

1770: --
1771: fetch c1 into l_potent;
1772: exit when c1%notfound;
1773: --
1774: hr_utility.set_location(' tmlns_eval_cd '|| l_potent.tmlns_eval_cd , 10);
1775: hr_utility.set_location(' tmlns_perd_cd '|| l_potent.tmlns_perd_cd , 10);
1776: --
1777: l_npv_ptnl_cnt := l_npv_ptnl_cnt + 1; --added during iRec
1778: l_action_happened := false;

Line 1775: hr_utility.set_location(' tmlns_perd_cd '|| l_potent.tmlns_perd_cd , 10);

1771: fetch c1 into l_potent;
1772: exit when c1%notfound;
1773: --
1774: hr_utility.set_location(' tmlns_eval_cd '|| l_potent.tmlns_eval_cd , 10);
1775: hr_utility.set_location(' tmlns_perd_cd '|| l_potent.tmlns_perd_cd , 10);
1776: --
1777: l_npv_ptnl_cnt := l_npv_ptnl_cnt + 1; --added during iRec
1778: l_action_happened := false;
1779: --

Line 2169: hr_utility.set_location(' l_npv_ptnl_cnt '|| l_npv_ptnl_cnt , 10);

2165: end loop;
2166: --
2167: close c1;
2168: --
2169: hr_utility.set_location(' l_npv_ptnl_cnt '|| l_npv_ptnl_cnt , 10);
2170: hr_utility.set_location(' l_curr_voidd_ptnl_cnt '|| l_curr_voidd_ptnl_cnt , 10);
2171: hr_utility.set_location(' l_mnl_ptnl_cnt '|| l_mnl_ptnl_cnt , 10);
2172: hr_utility.set_location(' l_mnl_ler_name '|| l_mnl_ler_name , 10);
2173: --

Line 2170: hr_utility.set_location(' l_curr_voidd_ptnl_cnt '|| l_curr_voidd_ptnl_cnt , 10);

2166: --
2167: close c1;
2168: --
2169: hr_utility.set_location(' l_npv_ptnl_cnt '|| l_npv_ptnl_cnt , 10);
2170: hr_utility.set_location(' l_curr_voidd_ptnl_cnt '|| l_curr_voidd_ptnl_cnt , 10);
2171: hr_utility.set_location(' l_mnl_ptnl_cnt '|| l_mnl_ptnl_cnt , 10);
2172: hr_utility.set_location(' l_mnl_ler_name '|| l_mnl_ler_name , 10);
2173: --
2174: -- 6245213 : Set savepoint. This is rolled back, if reqd, in check_and_get_winner.

Line 2171: hr_utility.set_location(' l_mnl_ptnl_cnt '|| l_mnl_ptnl_cnt , 10);

2167: close c1;
2168: --
2169: hr_utility.set_location(' l_npv_ptnl_cnt '|| l_npv_ptnl_cnt , 10);
2170: hr_utility.set_location(' l_curr_voidd_ptnl_cnt '|| l_curr_voidd_ptnl_cnt , 10);
2171: hr_utility.set_location(' l_mnl_ptnl_cnt '|| l_mnl_ptnl_cnt , 10);
2172: hr_utility.set_location(' l_mnl_ler_name '|| l_mnl_ler_name , 10);
2173: --
2174: -- 6245213 : Set savepoint. This is rolled back, if reqd, in check_and_get_winner.
2175: if (l_mnl_ptnl_cnt > 0) and not l_mnl_savepoint_established then

Line 2172: hr_utility.set_location(' l_mnl_ler_name '|| l_mnl_ler_name , 10);

2168: --
2169: hr_utility.set_location(' l_npv_ptnl_cnt '|| l_npv_ptnl_cnt , 10);
2170: hr_utility.set_location(' l_curr_voidd_ptnl_cnt '|| l_curr_voidd_ptnl_cnt , 10);
2171: hr_utility.set_location(' l_mnl_ptnl_cnt '|| l_mnl_ptnl_cnt , 10);
2172: hr_utility.set_location(' l_mnl_ler_name '|| l_mnl_ler_name , 10);
2173: --
2174: -- 6245213 : Set savepoint. This is rolled back, if reqd, in check_and_get_winner.
2175: if (l_mnl_ptnl_cnt > 0) and not l_mnl_savepoint_established then
2176: l_mnl_savepoint_established := true;

Line 2223: hr_utility.set_location('Leaving:'|| l_proc, 10);

2219: raise ben_manage_life_events.g_life_event_after;
2220: --
2221: end if;
2222: --
2223: hr_utility.set_location('Leaving:'|| l_proc, 10);
2224: --
2225: end check_for_timeliness;
2226: --
2227: function rule_evaluates

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

2259: l_jurisdiction_code varchar2(30);
2260: --
2261: begin
2262: --
2263: hr_utility.set_location('Entering:'|| l_proc, 10);
2264: --
2265: -- If no rule then return a Y else lets check the rule
2266: --
2267: if p_rule_id is null then

Line 2400: -- hr_utility.set_location('life_event_happened '||l_happened , 15);

2396: end;
2397: --
2398: end loop;
2399: --
2400: -- hr_utility.set_location('life_event_happened '||l_happened , 15);
2401: -- hr_utility.set_location('life_event_status_code '||l_ptnl_ler_for_per_stat_cd, 15);
2402: --
2403: if l_happened not in ('Y','N') then
2404: --

Line 2401: -- hr_utility.set_location('life_event_status_code '||l_ptnl_ler_for_per_stat_cd, 15);

2397: --
2398: end loop;
2399: --
2400: -- hr_utility.set_location('life_event_happened '||l_happened , 15);
2401: -- hr_utility.set_location('life_event_status_code '||l_ptnl_ler_for_per_stat_cd, 15);
2402: --
2403: if l_happened not in ('Y','N') then
2404: --
2405: fnd_message.set_name('BEN','BEN_92143_LIFE_EVENT_HAPPENED');

Line 2413: -- hr_utility.set_location('Step 1 ' ,190);

2409: end if;
2410: --
2411: if l_happened = 'Y' then
2412: --
2413: -- hr_utility.set_location('Step 1 ' ,190);
2414: if p_ler_id <> l_ler_id or
2415: p_lf_evt_ocrd_dt <> l_lf_evt_ocrd_dt or
2416: nvl(p_ntfn_dt,hr_api.g_date) <> nvl(l_ntfn_dt,hr_api.g_date) or
2417: nvl(p_dtctd_dt,hr_api.g_date) <> nvl(l_dtctd_dt,hr_api.g_date) or

Line 2424: -- hr_utility.set_location('Step 2 ' ,191);

2420: --
2421: -- Sanity check, they may have updated the voidd_dt but forgot to
2422: -- set the ptnl_ler_for_per_stat_cd so we set it for them
2423: --
2424: -- hr_utility.set_location('Step 2 ' ,191);
2425: if l_voidd_dt is not null and
2426: l_ptnl_ler_for_per_stat_cd <> 'VOIDD' then
2427: --
2428: l_ptnl_ler_for_per_stat_cd := 'VOIDD';

Line 2435: --hr_utility.set_location(' In the didnot happened case ', 15);

2431: -- did not happen as we want the event to be voided but we also
2432: -- want to update certain columns.
2433: --
2434: l_happened := 'N';
2435: --hr_utility.set_location(' In the didnot happened case ', 15);
2436: --
2437: end if;
2438: --
2439: -- We may have had a different life event reason returned in which

Line 2445: -- hr_utility.set_location('Step 3 ' ,193);

2441: -- life event. In this case carry out the void with the old values
2442: -- and create the new with the new returned values from the
2443: -- formula. In this case the event happened.
2444: --
2445: -- hr_utility.set_location('Step 3 ' ,193);
2446: if l_ler_id <> p_ler_id then
2447:
2448: -- Test for valid l_ptnl_ler_for_per_stat_cd
2449: if l_ptnl_ler_for_per_stat_cd not in ('DTCTD','MNL','UNPROCD') then

Line 2450: -- hr_utility.set_location('Invalid stat code returned from rule.',10);

2446: if l_ler_id <> p_ler_id then
2447:
2448: -- Test for valid l_ptnl_ler_for_per_stat_cd
2449: if l_ptnl_ler_for_per_stat_cd not in ('DTCTD','MNL','UNPROCD') then
2450: -- hr_utility.set_location('Invalid stat code returned from rule.',10);
2451: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
2452: fnd_message.raise_error;
2453: end if;
2454:

Line 2465: -- hr_utility.set_location('Step 4 ' ,194);

2461: if l_ptnl_ler_for_per_stat_cd = 'DTCTD' then
2462: l_ptnl_ler_for_per_stat_cd_use := 'DTCTD';
2463: else
2464: l_ptnl_ler_for_per_stat_cd_use := 'UNPROCD';
2465: -- hr_utility.set_location('Step 4 ' ,194);
2466: end if;
2467: --hr_utility.set_location(' r_per_stat_cd '||l_ptnl_ler_for_per_stat_cd, 17);
2468: if l_ptnl_ler_for_per_stat_cd = 'MNL' then
2469: l_unprocd_dt := l_mnl_dt;

Line 2467: --hr_utility.set_location(' r_per_stat_cd '||l_ptnl_ler_for_per_stat_cd, 17);

2463: else
2464: l_ptnl_ler_for_per_stat_cd_use := 'UNPROCD';
2465: -- hr_utility.set_location('Step 4 ' ,194);
2466: end if;
2467: --hr_utility.set_location(' r_per_stat_cd '||l_ptnl_ler_for_per_stat_cd, 17);
2468: if l_ptnl_ler_for_per_stat_cd = 'MNL' then
2469: l_unprocd_dt := l_mnl_dt;
2470: else
2471: l_unprocd_dt := sysdate;

Line 2493: -- hr_utility.set_location('Step 5 ' ,195);

2489: p_program_id => fnd_global.conc_program_id,
2490: p_request_id => fnd_global.conc_request_id,
2491: p_program_update_date => sysdate);
2492: --
2493: -- hr_utility.set_location('Step 5 ' ,195);
2494: if l_ptnl_ler_for_per_stat_cd = 'MNL' then
2495: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
2496: (p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,
2497: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,

Line 2509: --hr_utility.set_location('Step 6 ' ,196);

2505: p_mnl_dt => l_mnl_dt,
2506: p_procd_dt => l_procd_dt,
2507: p_unprocd_dt => l_unprocd_dt);
2508: end if;
2509: --hr_utility.set_location('Step 6 ' ,196);
2510: l_happened := 'Y';
2511: --
2512: -- Make sure that when we update the ptnl ler for per that the
2513: -- voided date and stat code are set correctly.

Line 2542: -- hr_utility.set_location('Step 7 ' ,197);

2538: p_effective_date => p_effective_date,
2539: p_mnl_dt => l_mnl_dt,
2540: p_procd_dt => l_procd_dt,
2541: p_unprocd_dt => l_unprocd_dt);
2542: -- hr_utility.set_location('Step 7 ' ,197);
2543: --
2544: end if;
2545: --
2546: --hr_utility.set_location('Step 8 ' ,198);

Line 2546: --hr_utility.set_location('Step 8 ' ,198);

2542: -- hr_utility.set_location('Step 7 ' ,197);
2543: --
2544: end if;
2545: --
2546: --hr_utility.set_location('Step 8 ' ,198);
2547: end if;
2548: --
2549: -- hr_utility.set_location('l_happened before return '||l_happened , 18 );
2550: return l_happened;

Line 2549: -- hr_utility.set_location('l_happened before return '||l_happened , 18 );

2545: --
2546: --hr_utility.set_location('Step 8 ' ,198);
2547: end if;
2548: --
2549: -- hr_utility.set_location('l_happened before return '||l_happened , 18 );
2550: return l_happened;
2551: --
2552: end if;
2553: --

Line 2554: hr_utility.set_location('Leaving:'|| l_proc, 10);

2550: return l_happened;
2551: --
2552: end if;
2553: --
2554: hr_utility.set_location('Leaving:'|| l_proc, 10);
2555: --
2556: end rule_evaluates;
2557: --
2558: procedure check_and_get_winner

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

2672: --
2673:
2674: begin
2675: --
2676: hr_utility.set_location('Entering: '|| l_proc, 10);
2677: --
2678: -- First back out any ptnls.
2679: --
2680: --

Line 2834: hr_utility.set_location ('Going to Manual. Rollback all Backouts' ,100);

2830: --
2831: -- 6245213 : Rollback all backouts, since the LE is going to MANUAL.
2832: --
2833: if (l_mnl_savepoint_established) then
2834: hr_utility.set_location ('Going to Manual. Rollback all Backouts' ,100);
2835: rollback to ptnl_set_to_manual_savepoint;
2836: l_mnl_savepoint_established := false;
2837: l_mnl_savepoint_preestablish:=false;
2838: end if;

Line 2855: hr_utility.set_location('Lea l_win_ler_name '||l_win_ler_name , 9.9);

2851: --
2852: close c2;
2853: --
2854:
2855: hr_utility.set_location('Lea l_win_ler_name '||l_win_ler_name , 9.9);
2856: hr_utility.set_location('Leaving:'|| l_proc, 10);
2857: --
2858: end check_and_get_winner;
2859: --

Line 2856: hr_utility.set_location('Leaving:'|| l_proc, 10);

2852: close c2;
2853: --
2854:
2855: hr_utility.set_location('Lea l_win_ler_name '||l_win_ler_name , 9.9);
2856: hr_utility.set_location('Leaving:'|| l_proc, 10);
2857: --
2858: end check_and_get_winner;
2859: --
2860: function get_earliest_potential(p_person_id in number,

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

2892: l_min_lf_evt_ocrd_dt date;
2893: --
2894: begin
2895: --
2896: hr_utility.set_location('Entering:'|| l_proc, 10);
2897: --
2898: open c1;
2899: --
2900: fetch c1 into l_min_lf_evt_ocrd_dt;

Line 2924: hr_utility.set_location('Leaving:'|| l_proc, 10);

2920: end if;
2921: --
2922: close c1;
2923: --
2924: hr_utility.set_location('Leaving:'|| l_proc, 10);
2925: --
2926: return l_min_lf_evt_ocrd_dt;
2927: --
2928: end get_earliest_potential;

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

2928: end get_earliest_potential;
2929: --
2930: begin
2931: --
2932: hr_utility.set_location('Entering:'|| l_proc, 10);
2933:
2934: --Start 6086392
2935: ben_evaluate_ptnl_lf_evt.g_bckdt_pil_tbl.delete;
2936: --End 6086392

Line 2980: hr_utility.set_location(l_potent.ler_eval_rl,10);

2976: --
2977: -- If there is a rule attached lets evaluate it and handle the returned
2978: -- values.
2979: --
2980: hr_utility.set_location(l_potent.ler_eval_rl,10);
2981: if rule_evaluates
2982: (p_ler_id => l_potent.ler_id,
2983: p_person_id => p_person_id,
2984: p_business_group_id => p_business_group_id,

Line 2997: hr_utility.set_location('After call to rule_evaluates ',19);

2993: p_effective_date => p_effective_date) <> 'Y' then
2994: --
2995: -- The life event didn't happen so void it
2996: --
2997: hr_utility.set_location('After call to rule_evaluates ',19);
2998: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
2999: (p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id,
3000: p_object_version_number => l_potent.object_version_number,
3001: p_ptnl_ler_for_per_stat_cd => 'VOIDD',

Line 3036: hr_utility.set_location('Before entering check_for_timeliness',90);

3032: --
3033: -- Now we have manipulated all potentials, check whether the remaining
3034: -- potentials fall within the timeliness
3035: --
3036: hr_utility.set_location('Before entering check_for_timeliness',90);
3037: --
3038: -- 6245213 : If Event goes to manual due to timeliness then
3039: -- set savepoint l_mnl_savepoint_established in the proc. check_for_timeliness
3040: -- and rollbck to savepoint in proc.check_and_get_winner

Line 3048: hr_utility.set_location('After leaving check_for_timeliness',90);

3044: p_effective_date => p_effective_date,
3045: p_mode => p_mode,
3046: p_business_group_id => p_business_group_id);
3047: --
3048: hr_utility.set_location('After leaving check_for_timeliness',90);
3049: --
3050: -- Check we actually have potential life events and get the minimum life
3051: -- event occurred of the set of potential life events
3052: --

Line 3157: hr_utility.set_location('active LED '||l_current_per_in_ler.lf_evt_ocrd_dt,10);

3153: fetch get_current_per_in_ler into l_current_per_in_ler;
3154: --
3155: close get_current_per_in_ler;
3156: --
3157: hr_utility.set_location('active LED '||l_current_per_in_ler.lf_evt_ocrd_dt,10);
3158: hr_utility.set_location('ptnl LED '||l_ptnl_rec.lf_evt_ocrd_dt,10);
3159: -- If no PER_IN_LER exists then we
3160: -- insert PTNL into PER_IN_LER
3161: -- update BEN_PTNL_LER_FOR_PER setting to processed

Line 3158: hr_utility.set_location('ptnl LED '||l_ptnl_rec.lf_evt_ocrd_dt,10);

3154: --
3155: close get_current_per_in_ler;
3156: --
3157: hr_utility.set_location('active LED '||l_current_per_in_ler.lf_evt_ocrd_dt,10);
3158: hr_utility.set_location('ptnl LED '||l_ptnl_rec.lf_evt_ocrd_dt,10);
3159: -- If no PER_IN_LER exists then we
3160: -- insert PTNL into PER_IN_LER
3161: -- update BEN_PTNL_LER_FOR_PER setting to processed
3162: --

Line 3176: hr_utility.set_location('A',10);

3172: --
3173: --
3174: if l_current_per_in_ler.lf_evt_ocrd_dt is null then
3175: --
3176: hr_utility.set_location('A',10);
3177: -- insert ptnl
3178: --
3179: l_created_ler := 'Y';
3180: p_created_ler_id := l_ptnl_rec.ler_id;

Line 3219: hr_utility.set_location('B',10);

3215: --
3216: -- Bug : 3179 : Check any dead lock situation.
3217: -- Any pil's which occured on same day.
3218: --
3219: hr_utility.set_location('B',10);
3220: open c_check_deadlock_pil(l_ptnl_rec.lf_evt_ocrd_dt);
3221: --
3222: fetch c_check_deadlock_pil into l_deadlock_per_in_ler;
3223: --

Line 3328: hr_utility.set_location(l_proc||' Loop GAPIL ', 50);

3324: open get_all_per_in_ler(l_ptnl_rec.lf_evt_ocrd_dt, l_curr_per_in_ler_id);
3325: --
3326: loop
3327: --
3328: hr_utility.set_location(l_proc||' Loop GAPIL ', 50);
3329: fetch get_all_per_in_ler into l_pil_rec;
3330: exit when get_all_per_in_ler%notfound;
3331: --
3332: -- First back out all the relevant stuff

Line 3422: hr_utility.set_location('Leaving:'|| l_proc, 90);

3418:
3419:
3420: --End 6086392
3421:
3422: hr_utility.set_location('Leaving:'|| l_proc, 90);
3423: --
3424: end eval_ptnl_per_for_ler;
3425: --
3426: -- iRec

Line 3533: -- hr_utility.set_location('** ERROR SUP',9909);

3529: --
3530: -- Offer is already processed, so you can't initiate the offer again.
3531: -- Error out.
3532: --
3533: -- hr_utility.set_location('** ERROR SUP',9909);
3534: fnd_message.set_name('BEN','BEN_94025_IREC_OFFER_PROCESSED');
3535: benutils.write(p_text => fnd_message.get);
3536: --
3537: g_rec.person_id := p_person_id;