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_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 2315: hr_utility.set_location('Entering:'|| l_proc, 116);

2311: l_current_ler varchar2(240);
2312: --
2313: begin
2314: --
2315: hr_utility.set_location('Entering:'|| l_proc, 116);
2316: --
2317: open c1;
2318: --
2319: fetch c1 into l_min_lf_evt_ocrd_dt;

Line 2320: hr_utility.set_location('l_min_lf_evt_ocrd_dt:'|| l_min_lf_evt_ocrd_dt, 10);

2316: --
2317: open c1;
2318: --
2319: fetch c1 into l_min_lf_evt_ocrd_dt;
2320: hr_utility.set_location('l_min_lf_evt_ocrd_dt:'|| l_min_lf_evt_ocrd_dt, 10);
2321: --
2322: -- Remember the min function always returns a row so check if the result
2323: -- is null rather than c1%notfound.
2324: --

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

2350: end if;
2351: --
2352: close c1;
2353: --
2354: hr_utility.set_location('Leaving:'|| l_proc, 10);
2355: --
2356: end check_earliest_potential;
2357: --End Bug 14137075
2358: --

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

2357: --End Bug 14137075
2358: --
2359: begin
2360: --
2361: hr_utility.set_location('Entering:'|| l_proc, 10);
2362: --
2363: -- If no rule then return a Y else lets check the rule
2364: --
2365: if p_rule_id is null then

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

2503: end;
2504: --
2505: end loop;
2506: --
2507: -- hr_utility.set_location('life_event_happened '||l_happened , 15);
2508: -- hr_utility.set_location('life_event_status_code '||l_ptnl_ler_for_per_stat_cd, 15);
2509: --
2510: if l_happened not in ('Y','N') then
2511: --

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

2504: --
2505: end loop;
2506: --
2507: -- hr_utility.set_location('life_event_happened '||l_happened , 15);
2508: -- hr_utility.set_location('life_event_status_code '||l_ptnl_ler_for_per_stat_cd, 15);
2509: --
2510: if l_happened not in ('Y','N') then
2511: --
2512: fnd_message.set_name('BEN','BEN_92143_LIFE_EVENT_HAPPENED');

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

2516: end if;
2517: --
2518: if l_happened = 'Y' then
2519: --
2520: -- hr_utility.set_location('Step 1 ' ,190);
2521: if p_ler_id <> l_ler_id or
2522: p_lf_evt_ocrd_dt <> l_lf_evt_ocrd_dt or
2523: nvl(p_ntfn_dt,hr_api.g_date) <> nvl(l_ntfn_dt,hr_api.g_date) or
2524: nvl(p_dtctd_dt,hr_api.g_date) <> nvl(l_dtctd_dt,hr_api.g_date) or

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

2527: --
2528: -- Sanity check, they may have updated the voidd_dt but forgot to
2529: -- set the ptnl_ler_for_per_stat_cd so we set it for them
2530: --
2531: -- hr_utility.set_location('Step 2 ' ,191);
2532: if l_voidd_dt is not null and
2533: l_ptnl_ler_for_per_stat_cd <> 'VOIDD' then
2534: --
2535: l_ptnl_ler_for_per_stat_cd := 'VOIDD';

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

2538: -- did not happen as we want the event to be voided but we also
2539: -- want to update certain columns.
2540: --
2541: l_happened := 'N';
2542: --hr_utility.set_location(' In the didnot happened case ', 15);
2543: --
2544: end if;
2545: --
2546: -- We may have had a different life event reason returned in which

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

2548: -- life event. In this case carry out the void with the old values
2549: -- and create the new with the new returned values from the
2550: -- formula. In this case the event happened.
2551: --
2552: -- hr_utility.set_location('Step 3 ' ,193);
2553: if l_ler_id <> p_ler_id then--l_ler_id <> p_ler_id
2554:
2555: -- Test for valid l_ptnl_ler_for_per_stat_cd
2556: if l_ptnl_ler_for_per_stat_cd not in ('DTCTD','MNL','UNPROCD') then

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

2553: if l_ler_id <> p_ler_id then--l_ler_id <> p_ler_id
2554:
2555: -- Test for valid l_ptnl_ler_for_per_stat_cd
2556: if l_ptnl_ler_for_per_stat_cd not in ('DTCTD','MNL','UNPROCD') then
2557: -- hr_utility.set_location('Invalid stat code returned from rule.',10);
2558: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
2559: fnd_message.raise_error;
2560: end if;
2561:

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

2568: if l_ptnl_ler_for_per_stat_cd = 'DTCTD' then
2569: l_ptnl_ler_for_per_stat_cd_use := 'DTCTD';
2570: else
2571: l_ptnl_ler_for_per_stat_cd_use := 'UNPROCD';
2572: -- hr_utility.set_location('Step 4 ' ,194);
2573: end if;
2574: --hr_utility.set_location(' r_per_stat_cd '||l_ptnl_ler_for_per_stat_cd, 17);
2575: if l_ptnl_ler_for_per_stat_cd = 'MNL' then
2576: l_unprocd_dt := l_mnl_dt;

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

2570: else
2571: l_ptnl_ler_for_per_stat_cd_use := 'UNPROCD';
2572: -- hr_utility.set_location('Step 4 ' ,194);
2573: end if;
2574: --hr_utility.set_location(' r_per_stat_cd '||l_ptnl_ler_for_per_stat_cd, 17);
2575: if l_ptnl_ler_for_per_stat_cd = 'MNL' then
2576: l_unprocd_dt := l_mnl_dt;
2577: else
2578: l_unprocd_dt := sysdate;

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

2596: p_program_id => fnd_global.conc_program_id,
2597: p_request_id => fnd_global.conc_request_id,
2598: p_program_update_date => sysdate);
2599: --
2600: -- hr_utility.set_location('Step 5 ' ,195);
2601: if l_ptnl_ler_for_per_stat_cd = 'MNL' then
2602: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
2603: (p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id,
2604: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt,

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

2612: p_mnl_dt => l_mnl_dt,
2613: p_procd_dt => l_procd_dt,
2614: p_unprocd_dt => l_unprocd_dt);
2615: end if;
2616: --hr_utility.set_location('Step 6 ' ,196);
2617: l_happened := 'Y';
2618: --
2619: -- Make sure that when we update the ptnl ler for per that the
2620: -- voided date and stat code are set correctly.

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

2654: p_effective_date => p_effective_date,
2655: p_mnl_dt => l_mnl_dt,
2656: p_procd_dt => l_procd_dt,
2657: p_unprocd_dt => l_unprocd_dt);
2658: -- hr_utility.set_location('Step 7 ' ,197);
2659: --
2660: -- end if;--l_ler_id <> p_ler_id --bug 12596491
2661: --Start Start Bug 14137075
2662: if l_ler_id <> p_ler_id then

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

2672: end if;
2673: --End Start Bug 14137075
2674: end if;
2675: --
2676: --hr_utility.set_location('Step 8 ' ,198);
2677: end if;
2678: --
2679: -- hr_utility.set_location('l_happened before return '||l_happened , 18 );
2680: return l_happened;

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

2675: --
2676: --hr_utility.set_location('Step 8 ' ,198);
2677: end if;
2678: --
2679: -- hr_utility.set_location('l_happened before return '||l_happened , 18 );
2680: return l_happened;
2681: --
2682: end if;
2683: --

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

2680: return l_happened;
2681: --
2682: end if;
2683: --
2684: hr_utility.set_location('Leaving:'|| l_proc, 10);
2685: --
2686: end rule_evaluates;
2687: --
2688: procedure check_and_get_winner

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

2802: --
2803:
2804: begin
2805: --
2806: hr_utility.set_location('Entering: '|| l_proc, 10);
2807: --
2808: -- First back out any ptnls.
2809: --
2810: --

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

2960: --
2961: -- 6245213 : Rollback all backouts, since the LE is going to MANUAL.
2962: --
2963: if (l_mnl_savepoint_established) then
2964: hr_utility.set_location ('Going to Manual. Rollback all Backouts' ,100);
2965: rollback to ptnl_set_to_manual_savepoint;
2966: l_mnl_savepoint_established := false;
2967: l_mnl_savepoint_preestablish:=false;
2968: end if;

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

2981: --
2982: close c2;
2983: --
2984:
2985: hr_utility.set_location('Lea l_win_ler_name '||l_win_ler_name , 9.9);
2986: hr_utility.set_location('Leaving:'|| l_proc, 10);
2987: --
2988: end check_and_get_winner;
2989: --

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

2982: close c2;
2983: --
2984:
2985: hr_utility.set_location('Lea l_win_ler_name '||l_win_ler_name , 9.9);
2986: hr_utility.set_location('Leaving:'|| l_proc, 10);
2987: --
2988: end check_and_get_winner;
2989: --
2990: function get_earliest_potential(p_person_id in number,

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

3022: l_min_lf_evt_ocrd_dt date;
3023: --
3024: begin
3025: --
3026: hr_utility.set_location('Entering:'|| l_proc, 10);
3027: --
3028: open c1;
3029: --
3030: fetch c1 into l_min_lf_evt_ocrd_dt;

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

3050: end if;
3051: --
3052: close c1;
3053: --
3054: hr_utility.set_location('Leaving:'|| l_proc, 10);
3055: --
3056: return l_min_lf_evt_ocrd_dt;
3057: --
3058: end get_earliest_potential;

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

3058: end get_earliest_potential;
3059: --
3060: begin
3061: --
3062: hr_utility.set_location('Entering:'|| l_proc, 10);
3063:
3064: --Start 6086392
3065: ben_evaluate_ptnl_lf_evt.g_bckdt_pil_tbl.delete;
3066: --End 6086392

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

3106: --
3107: -- If there is a rule attached lets evaluate it and handle the returned
3108: -- values.
3109: --
3110: hr_utility.set_location(l_potent.ler_eval_rl,10);
3111: if rule_evaluates
3112: (p_ler_id => l_potent.ler_id,
3113: p_person_id => p_person_id,
3114: p_business_group_id => p_business_group_id,

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

3123: p_effective_date => p_effective_date) <> 'Y' then
3124: --
3125: -- The life event didn't happen so void it
3126: --
3127: hr_utility.set_location('After call to rule_evaluates ',19);
3128: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf
3129: (p_ptnl_ler_for_per_id => l_potent.ptnl_ler_for_per_id,
3130: p_object_version_number => l_potent.object_version_number,
3131: p_ptnl_ler_for_per_stat_cd => 'VOIDD',

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

3162: --
3163: -- Now we have manipulated all potentials, check whether the remaining
3164: -- potentials fall within the timeliness
3165: --
3166: hr_utility.set_location('Before entering check_for_timeliness',90);
3167: --
3168: -- 6245213 : If Event goes to manual due to timeliness then
3169: -- set savepoint l_mnl_savepoint_established in the proc. check_for_timeliness
3170: -- and rollbck to savepoint in proc.check_and_get_winner

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

3174: p_effective_date => p_effective_date,
3175: p_mode => p_mode,
3176: p_business_group_id => p_business_group_id);
3177: --
3178: hr_utility.set_location('After leaving check_for_timeliness',90);
3179: --
3180: -- Check we actually have potential life events and get the minimum life
3181: -- event occurred of the set of potential life events
3182: --

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

3283: fetch get_current_per_in_ler into l_current_per_in_ler;
3284: --
3285: close get_current_per_in_ler;
3286: --
3287: hr_utility.set_location('active LED '||l_current_per_in_ler.lf_evt_ocrd_dt,10);
3288: hr_utility.set_location('ptnl LED '||l_ptnl_rec.lf_evt_ocrd_dt,10);
3289: -- If no PER_IN_LER exists then we
3290: -- insert PTNL into PER_IN_LER
3291: -- update BEN_PTNL_LER_FOR_PER setting to processed

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

3284: --
3285: close get_current_per_in_ler;
3286: --
3287: hr_utility.set_location('active LED '||l_current_per_in_ler.lf_evt_ocrd_dt,10);
3288: hr_utility.set_location('ptnl LED '||l_ptnl_rec.lf_evt_ocrd_dt,10);
3289: -- If no PER_IN_LER exists then we
3290: -- insert PTNL into PER_IN_LER
3291: -- update BEN_PTNL_LER_FOR_PER setting to processed
3292: --

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

3302: --
3303: --
3304: if l_current_per_in_ler.lf_evt_ocrd_dt is null then
3305: --
3306: hr_utility.set_location('A',10);
3307: -- insert ptnl
3308: --
3309: l_created_ler := 'Y';
3310: p_created_ler_id := l_ptnl_rec.ler_id;

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

3345: --
3346: -- Bug : 3179 : Check any dead lock situation.
3347: -- Any pil's which occured on same day.
3348: --
3349: hr_utility.set_location('B',10);
3350: open c_check_deadlock_pil(l_ptnl_rec.lf_evt_ocrd_dt);
3351: --
3352: fetch c_check_deadlock_pil into l_deadlock_per_in_ler;
3353: --

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

3454: open get_all_per_in_ler(l_ptnl_rec.lf_evt_ocrd_dt, l_curr_per_in_ler_id);
3455: --
3456: loop
3457: --
3458: hr_utility.set_location(l_proc||' Loop GAPIL ', 50);
3459: fetch get_all_per_in_ler into l_pil_rec;
3460: exit when get_all_per_in_ler%notfound;
3461: --
3462: -- First back out all the relevant stuff

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

3548:
3549:
3550: --End 6086392
3551:
3552: hr_utility.set_location('Leaving:'|| l_proc, 90);
3553: --
3554: end eval_ptnl_per_for_ler;
3555: --
3556: -- iRec

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

3659: --
3660: -- Offer is already processed, so you can't initiate the offer again.
3661: -- Error out.
3662: --
3663: -- hr_utility.set_location('** ERROR SUP',9909);
3664: fnd_message.set_name('BEN','BEN_94025_IREC_OFFER_PROCESSED');
3665: benutils.write(p_text => fnd_message.get);
3666: --
3667: g_rec.person_id := p_person_id;