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_MANAGE_OVERRIDE dependencies on HR_UTILITY

Line 219: hr_utility.set_location('Entering '||l_package ,10);

215: if p_called_from_key_listval = 'Y' then
216: savepoint called_from_key_listval ;
217: end if;
218: --
219: hr_utility.set_location('Entering '||l_package ,10);
220: hr_utility.set_location('Calling ben_env_object.init',20);
221: ben_env_object.init(p_business_group_id => p_business_group_id ,
222: p_effective_date => p_effective_date,
223: p_thread_id => 1,

Line 220: hr_utility.set_location('Calling ben_env_object.init',20);

216: savepoint called_from_key_listval ;
217: end if;
218: --
219: hr_utility.set_location('Entering '||l_package ,10);
220: hr_utility.set_location('Calling ben_env_object.init',20);
221: ben_env_object.init(p_business_group_id => p_business_group_id ,
222: p_effective_date => p_effective_date,
223: p_thread_id => 1,
224: p_chunk_size => 1,

Line 296: hr_utility.set_location('Calling ben_enrolment_requirements_ik.enrolment_requirements',30);

292: ben_cobj_cache.g_pgm_currow := l_pgm_rec ;
293: --
294: end if ;
295: --
296: hr_utility.set_location('Calling ben_enrolment_requirements_ik.enrolment_requirements',30);
297: ben_enrolment_requirements.enrolment_requirements
298: (p_comp_obj_tree_row =>l_comp_obj_tree_row
299: ,p_run_mode =>p_run_mode
300: ,p_business_group_id =>p_business_group_id

Line 350: hr_utility.set_location('Calling ben_determine_coverage.main ',40);

346: ben_epe_cache.g_currcobjepe_row.pl_id := p_pl_id ;
347: ben_epe_cache.g_currcobjepe_row.plip_id := p_plip_id ;
348: ben_epe_cache.g_currcobjepe_row.oipl_id := p_oipl_id ;
349: --
350: hr_utility.set_location('Calling ben_determine_coverage.main ',40);
351: ben_determine_coverage.main
352: ( p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id
353: ,p_effective_date => p_effective_date
354: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt

Line 375: hr_utility.set_location('premium calculation from Override ',111);

371: close c_enb;
372: --
373: end if;
374: --
375: hr_utility.set_location('premium calculation from Override ',111);
376: ben_determine_actual_premium.g_computed_prem_val := null ;
377: ben_determine_actual_premium.main
378: (p_person_id => p_person_id,
379: p_effective_date => p_effective_date,

Line 390: hr_utility.set_location('premium calculation from override ',112);

386: p_ler_id => p_ler_id,
387: p_bnft_amt => p_bnft_amt,
388: p_business_group_id => p_business_group_id );
389: --
390: hr_utility.set_location('premium calculation from override ',112);
391: -- Create enrt_rt records
392: hr_utility.set_location('Calling ben_determine_rates.main ',50);
393: hr_utility.set_location(' l_elig_per_elctbl_chc_id '||l_elig_per_elctbl_chc_id,35);
394: --

Line 392: hr_utility.set_location('Calling ben_determine_rates.main ',50);

388: p_business_group_id => p_business_group_id );
389: --
390: hr_utility.set_location('premium calculation from override ',112);
391: -- Create enrt_rt records
392: hr_utility.set_location('Calling ben_determine_rates.main ',50);
393: hr_utility.set_location(' l_elig_per_elctbl_chc_id '||l_elig_per_elctbl_chc_id,35);
394: --
395: ben_epe_cache.clear_down_cache ;
396: --

Line 393: hr_utility.set_location(' l_elig_per_elctbl_chc_id '||l_elig_per_elctbl_chc_id,35);

389: --
390: hr_utility.set_location('premium calculation from override ',112);
391: -- Create enrt_rt records
392: hr_utility.set_location('Calling ben_determine_rates.main ',50);
393: hr_utility.set_location(' l_elig_per_elctbl_chc_id '||l_elig_per_elctbl_chc_id,35);
394: --
395: ben_epe_cache.clear_down_cache ;
396: --
397: ben_determine_rates.main

Line 407: hr_utility.set_location(' p_pgm_id '||p_pgm_id,123);

403: );
404: --
405: end if;
406: --
407: hr_utility.set_location(' p_pgm_id '||p_pgm_id,123);
408: if p_pgm_id is not null then
409: --
410: open c_flx_pgm(p_pgm_id);
411: fetch c_flx_pgm into l_char_dummy ;

Line 414: hr_utility.set_location(' Flex Program ',123);

410: open c_flx_pgm(p_pgm_id);
411: fetch c_flx_pgm into l_char_dummy ;
412: if c_flx_pgm%found then
413: --
414: hr_utility.set_location(' Flex Program ',123);
415: open c_flx_plan_exists ;
416: fetch c_flx_plan_exists into l_flx_pl_id ,l_flx_plip_id,l_flx_ptip_id ;
417: if c_flx_plan_exists%found then
418: --

Line 419: hr_utility.set_location(' No epe exists ' ,123);

415: open c_flx_plan_exists ;
416: fetch c_flx_plan_exists into l_flx_pl_id ,l_flx_plip_id,l_flx_ptip_id ;
417: if c_flx_plan_exists%found then
418: --
419: hr_utility.set_location(' No epe exists ' ,123);
420: --Call bendenrr
421: l_comp_obj_tree_row.par_ptip_id := l_flx_ptip_id;
422: l_comp_obj_tree_row.par_plip_id := l_flx_plip_id;
423: --

Line 424: hr_utility.set_location('Call bendenrr create flexshell epefor plan '||l_flx_pl_id,30);

420: --Call bendenrr
421: l_comp_obj_tree_row.par_ptip_id := l_flx_ptip_id;
422: l_comp_obj_tree_row.par_plip_id := l_flx_plip_id;
423: --
424: hr_utility.set_location('Call bendenrr create flexshell epefor plan '||l_flx_pl_id,30);
425: ben_enrolment_requirements.enrolment_requirements
426: (p_comp_obj_tree_row =>l_comp_obj_tree_row
427: ,p_run_mode =>p_run_mode
428: ,p_business_group_id =>p_business_group_id

Line 495: hr_utility.set_location(' No epe exists ' ,123);

491: -- imputed income epe and ecr rows
492: --
493: for r_imp_plans in c_imp_plan_exists loop
494: --
495: hr_utility.set_location(' No epe exists ' ,123);
496: --Call bendenrr
497: l_comp_obj_tree_row.par_ptip_id := r_imp_plans.ptip_id;
498: l_comp_obj_tree_row.par_plip_id := r_imp_plans.plip_id;
499: --

Line 500: hr_utility.set_location('Call bendenrr create imp epefor plan '||r_imp_plans.pl_id,30);

496: --Call bendenrr
497: l_comp_obj_tree_row.par_ptip_id := r_imp_plans.ptip_id;
498: l_comp_obj_tree_row.par_plip_id := r_imp_plans.plip_id;
499: --
500: hr_utility.set_location('Call bendenrr create imp epefor plan '||r_imp_plans.pl_id,30);
501: ben_enrolment_requirements.enrolment_requirements
502: (p_comp_obj_tree_row =>l_comp_obj_tree_row
503: ,p_run_mode =>p_run_mode
504: ,p_business_group_id =>p_business_group_id

Line 533: hr_utility.set_location('Leaving '||l_package,60);

529: --
530: end if;
531: end loop ; --imputed income
532: --
533: hr_utility.set_location('Leaving '||l_package,60);
534: --
535: --- no copy
536: exception
537: when others then

Line 575: hr_utility.set_location('Entering '||l_package,10);

571: --
572: l_per_in_ler_id number;
573: --
574: begin
575: hr_utility.set_location('Entering '||l_package,10);
576: -- Update epe with the prtt_enrt_rslt_id
577: open c_epe ;
578: fetch c_epe into l_epe_object_version_number,l_per_in_ler_id ;
579: close c_epe;

Line 581: hr_utility.set_location('Calling ben_ELIG_PER_ELC_CHC_api.update_ELIG_PER_ELC_CHC ',20);

577: open c_epe ;
578: fetch c_epe into l_epe_object_version_number,l_per_in_ler_id ;
579: close c_epe;
580: --
581: hr_utility.set_location('Calling ben_ELIG_PER_ELC_CHC_api.update_ELIG_PER_ELC_CHC ',20);
582: hr_utility.set_location(' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,22);
583: hr_utility.set_location(' l_epe_object_version_number '||l_epe_object_version_number,23);
584: --
585: ben_ELIG_PER_ELC_CHC_api.update_ELIG_PER_ELC_CHC

Line 582: hr_utility.set_location(' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,22);

578: fetch c_epe into l_epe_object_version_number,l_per_in_ler_id ;
579: close c_epe;
580: --
581: hr_utility.set_location('Calling ben_ELIG_PER_ELC_CHC_api.update_ELIG_PER_ELC_CHC ',20);
582: hr_utility.set_location(' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,22);
583: hr_utility.set_location(' l_epe_object_version_number '||l_epe_object_version_number,23);
584: --
585: ben_ELIG_PER_ELC_CHC_api.update_ELIG_PER_ELC_CHC
586: (p_validate => FALSE

Line 583: hr_utility.set_location(' l_epe_object_version_number '||l_epe_object_version_number,23);

579: close c_epe;
580: --
581: hr_utility.set_location('Calling ben_ELIG_PER_ELC_CHC_api.update_ELIG_PER_ELC_CHC ',20);
582: hr_utility.set_location(' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,22);
583: hr_utility.set_location(' l_epe_object_version_number '||l_epe_object_version_number,23);
584: --
585: ben_ELIG_PER_ELC_CHC_api.update_ELIG_PER_ELC_CHC
586: (p_validate => FALSE
587: ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id

Line 604: hr_utility.set_location('Calling ben_election_information.manage_enrt_bnft ',30);

600: open c_enb ;
601: fetch c_enb into l_enb_object_version_number ;
602: close c_enb ;
603: --
604: hr_utility.set_location('Calling ben_election_information.manage_enrt_bnft ',30);
605: ben_election_information.manage_enrt_bnft
606: ( p_enrt_bnft_id => p_enrt_bnft_id
607: ,p_effective_date => p_effective_date
608: ,p_object_version_number => l_enb_object_version_number

Line 618: hr_utility.set_location('Leaving '||l_package,40);

614: );
615: --
616: end if;
617: --
618: hr_utility.set_location('Leaving '||l_package,40);
619: end post_override ;
620: --
621: -- Wrapper for update_elig_dependents call
622: --

Line 633: hr_utility.set_location('Calling '||l_package,10);

629: ) is
630: l_package varchar2(500) := 'Ben_Manage_Override.update_elig_dpnt' ;
631: begin
632: --
633: hr_utility.set_location('Calling '||l_package,10);
634: ben_elig_dpnt_api.update_elig_dpnt(
635: p_elig_dpnt_id => p_elig_dpnt_id,
636: p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id,
637: p_effective_date => p_effective_date,

Line 645: hr_utility.set_location('Leaving '||l_package,20);

641: p_program_id => fnd_global.conc_program_id,
642: p_request_id => fnd_global.conc_request_id,
643: p_program_update_date => sysdate
644: );
645: hr_utility.set_location('Leaving '||l_package,20);
646: --
647: end;
648:
649: procedure rollback_choices is

Line 756: hr_utility.set_location('Entering '||l_package,10);

752: l_future_change boolean;
753: l_delete_next_change boolean;
754: --
755: begin
756: hr_utility.set_location('Entering '||l_package,10);
757: -- End dependents
758: for l_pdp in c_pdp(p_prtt_enrt_rslt_id,p_effective_date) loop
759: --
760: ben_elig_cvrd_dpnt_api.update_elig_cvrd_dpnt(

Line 863: hr_utility.set_location('Leaving '||l_package,20);

859: end if;
860: --
861: end loop ;
862: --
863: hr_utility.set_location('Leaving '||l_package,20);
864: --
865: end end_rate_and_dependents;
866: --
867: -- Procedure reopen the rates and coverages when result is end dated.

Line 984: hr_utility.set_location('Entering '||l_package,10);

980: l_future_change boolean;
981: l_delete_next_change boolean;
982: --
983: begin
984: hr_utility.set_location('Entering '||l_package,10);
985: -- End dependents
986: for l_pdp in c_pdp(p_prtt_enrt_rslt_id,p_effective_date) loop
987: --
988: ben_elig_cvrd_dpnt_api.update_elig_cvrd_dpnt(

Line 1082: hr_utility.set_location('Leaving '||l_package,20);

1078: end if;
1079: --
1080: end loop ;
1081: --
1082: hr_utility.set_location('Leaving '||l_package,20);
1083: --
1084: end reopen_rate_and_dependents;
1085: --
1086: procedure override_prtt_prem

Line 1180: hr_utility.set_location('Entering '||l_package,10);

1176: l_step varchar2(30);
1177: l_effective_start_date date;
1178: l_effective_end_date date;
1179: begin
1180: hr_utility.set_location('Entering '||l_package,10);
1181: for l_prem in c_prem loop
1182: l_step := 70;
1183: l_ppe.prtt_prem_id:=null;
1184: open c_pel;

Line 1332: hr_utility.set_location('Leaving '||l_package,20);

1328: );
1329: --
1330: end if;
1331: end loop;
1332: hr_utility.set_location('Leaving '||l_package,20);
1333: end override_prtt_prem ;
1334: --
1335: procedure correct_prtt_enrt_rslt
1336: (p_prtt_enrt_rslt_id in number

Line 1374: hr_utility.set_location('l_datetrack_mode '||l_datetrack_mode,10);

1370: ,P_desired_datetrack_mode => l_desired_datetrack_mode
1371: ,P_datetrack_allow => l_datetrack_mode
1372: );
1373: --
1374: hr_utility.set_location('l_datetrack_mode '||l_datetrack_mode,10);
1375: l_object_version_number := l_pen.object_version_number;
1376: --
1377: ben_prtt_enrt_result_api.update_prtt_enrt_result
1378: (p_validate => FALSE,

Line 1472: hr_utility.set_location('Entering:'|| l_package, 15);

1468: where prtt_rt_val_id=l_ecr_rec.prtt_rt_val_id;
1469: --
1470: begin
1471: --
1472: hr_utility.set_location('Entering:'|| l_package, 15);
1473: --
1474: l_epe_rec.elig_per_elctbl_chc_id:= p_elig_per_elctbl_chc_id;
1475: l_epe_rec.prtt_enrt_rslt_id := p_prtt_enrt_rslt_id;
1476: l_epe_rec.business_group_id := p_business_group_id;

Line 1525: hr_utility.set_location('CREATED LEDGER ID='||to_char(p_bnft_prvdd_ldgr_id),41);

1521: ,p_object_version_number => l_object_version_number
1522: ,p_cash_recd_val => null
1523: ,p_effective_date => p_effective_date
1524: );
1525: hr_utility.set_location('CREATED LEDGER ID='||to_char(p_bnft_prvdd_ldgr_id),41);
1526: else
1527: --
1528: DT_Api.Find_DT_Upd_Modes(
1529: p_effective_date => p_effective_date,

Line 1549: hr_utility.set_location('UPDATING LEDGER ID='||to_char(p_bnft_prvdd_ldgr_id),51);

1545: --
1546: if l_per_in_ler_id <> l_epe_rec.per_in_ler_id or
1547: l_used_val <> l_val then
1548: --
1549: hr_utility.set_location('UPDATING LEDGER ID='||to_char(p_bnft_prvdd_ldgr_id),51);
1550: --
1551: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
1552: p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id
1553: ,p_effective_start_date => l_effective_start_date

Line 1568: hr_utility.set_location('UPDATED LEDGER ID='||to_char(p_bnft_prvdd_ldgr_id),55);

1564: ,p_cash_recd_val => null
1565: ,p_effective_date => p_effective_date
1566: ,p_datetrack_mode => l_datetrack_mode
1567: );
1568: hr_utility.set_location('UPDATED LEDGER ID='||to_char(p_bnft_prvdd_ldgr_id),55);
1569: end if;
1570: end if;
1571: close c_old_ledger;
1572: end if;

Line 1853: hr_utility.set_location('future ee:'||l_zap_future_ee.element_entry_id,6);

1849: if c_zap_future_ee%notfound then
1850: exit;
1851: end if;
1852: --
1853: hr_utility.set_location('future ee:'||l_zap_future_ee.element_entry_id,6);
1854: hr_utility.set_location('creator type:'||l_zap_future_ee.creator_type,6);
1855: hr_utility.set_location('creator id:'||l_zap_future_ee.creator_id,6);
1856: --
1857: if l_zap_future_ee.creator_type ='F' and l_zap_future_ee.creator_id is not null then

Line 1854: hr_utility.set_location('creator type:'||l_zap_future_ee.creator_type,6);

1850: exit;
1851: end if;
1852: --
1853: hr_utility.set_location('future ee:'||l_zap_future_ee.element_entry_id,6);
1854: hr_utility.set_location('creator type:'||l_zap_future_ee.creator_type,6);
1855: hr_utility.set_location('creator id:'||l_zap_future_ee.creator_id,6);
1856: --
1857: if l_zap_future_ee.creator_type ='F' and l_zap_future_ee.creator_id is not null then
1858: --

Line 1855: hr_utility.set_location('creator id:'||l_zap_future_ee.creator_id,6);

1851: end if;
1852: --
1853: hr_utility.set_location('future ee:'||l_zap_future_ee.element_entry_id,6);
1854: hr_utility.set_location('creator type:'||l_zap_future_ee.creator_type,6);
1855: hr_utility.set_location('creator id:'||l_zap_future_ee.creator_id,6);
1856: --
1857: if l_zap_future_ee.creator_type ='F' and l_zap_future_ee.creator_id is not null then
1858: --
1859: py_element_entry_api.delete_element_entry

Line 2050: hr_utility.set_location('Updating the Required Flag to No ',5);

2046: if c_pea%notfound then
2047: exit ;
2048: end if;
2049: --
2050: hr_utility.set_location('Updating the Required Flag to No ',5);
2051: ben_prtt_enrt_actn_api.update_prtt_enrt_actn
2052: (p_prtt_enrt_actn_id => l_pea.prtt_enrt_actn_id
2053: ,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
2054: ,p_rslt_object_version_number => l_pea.pen_object_version_number

Line 2065: hr_utility.set_location('After ben_prtt_enrt_actn_api.update_prtt_enrt_actn ',20);

2061: ,p_effective_end_date => l_pea_effective_end_date
2062: ,p_object_version_number => l_pea.pea_object_version_number
2063: ,p_datetrack_mode => hr_api.g_correction
2064: );
2065: hr_utility.set_location('After ben_prtt_enrt_actn_api.update_prtt_enrt_actn ',20);
2066: --
2067: end loop ;
2068: close c_pea ;
2069: --