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

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

115:
116: l_jurisdiction PAY_CA_EMP_PROV_TAX_INFO_F.JURISDICTION_CODE%type := null;
117:
118: begin
119: hr_utility.set_location ('Entering '||l_package,10);
120: open csr_asg;
121: fetch csr_asg into p_assignment_id, p_organization_id,
122: p_region_2, p_location_id;
123: if csr_asg%NOTFOUND or csr_asg%NOTFOUND is null then

Line 135: hr_utility.set_location ('Leaving '||l_package,99);

131: -- (p_state => p_region_2);
132: --else
133: p_jurisdiction := null;
134: --end if;
135: hr_utility.set_location ('Leaving '||l_package,99);
136: end get_rule_data;
137:
138: -- ----------------------------------------------------------------------------
139: -- |------------------------< determine_costing >----------------------------|

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

213: l_cnt2 number;
214: l_outputs ff_exec.outputs_t;
215:
216: begin
217: hr_utility.set_location ('Entering '||l_package,10);
218: l_effective_date := trunc(p_effective_date);
219: --
220: --
221: -- Look for cost allocation definition

Line 225: hr_utility.set_location(l_package, 27);

221: -- Look for cost allocation definition
222: open csr_cost_id;
223: fetch csr_cost_id into l_cost_id;
224: if csr_cost_id%FOUND then
225: hr_utility.set_location(l_package, 27);
226:
227: -- get the actl-prem cost-allocation info to copy to the prtt-prem cost-allocation.
228: open csr_apr_cak;
229: fetch csr_apr_cak into l_apr_cak(1).sgmt, l_apr_cak(2).sgmt,

Line 243: hr_utility.set_location(l_package, 29);

239: l_apr_cak(25).sgmt, l_apr_cak(26).sgmt, l_apr_cak(27).sgmt,
240: l_apr_cak(28).sgmt, l_apr_cak(29).sgmt,
241: l_apr_cak(30).sgmt;
242: if csr_apr_cak%FOUND then
243: hr_utility.set_location(l_package, 29);
244:
245: -- check for overrides to the actl-prem cost-allocation info, stored in
246: -- prem-cstg-by-sgmt.
247: open csr_asg;

Line 298: hr_utility.set_location(l_package, 31);

294: end loop;
295: end if;
296: close csr_asg;
297:
298: hr_utility.set_location(l_package, 31);
299:
300: hr_kflex_utility.ins_or_sel_keyflex_comb
301: (p_appl_short_name => 'PAY'
302: ,p_flex_code => 'COST'

Line 339: hr_utility.set_location(l_package, 35);

335: ,p_ccid => p_cak_id -- out
336: ,p_concat_segments_out => l_segments -- out
337: );
338:
339: hr_utility.set_location(l_package, 35);
340: end if;
341: close csr_apr_cak;
342:
343: end if;

Line 346: hr_utility.set_location ('Leaving '||l_package,99);

342:
343: end if;
344: close csr_cost_id;
345:
346: hr_utility.set_location ('Leaving '||l_package,99);
347: exception
348: when others then
349: l_error_text := sqlerrm;
350: hr_utility.set_location ('Fail in '||l_package,999);

Line 350: hr_utility.set_location ('Fail in '||l_package,999);

346: hr_utility.set_location ('Leaving '||l_package,99);
347: exception
348: when others then
349: l_error_text := sqlerrm;
350: hr_utility.set_location ('Fail in '||l_package,999);
351: hr_utility.set_location('Error:'||l_error_text,999);
352: fnd_message.raise_error;
353: end determine_costing;
354:

Line 351: hr_utility.set_location('Error:'||l_error_text,999);

347: exception
348: when others then
349: l_error_text := sqlerrm;
350: hr_utility.set_location ('Fail in '||l_package,999);
351: hr_utility.set_location('Error:'||l_error_text,999);
352: fnd_message.raise_error;
353: end determine_costing;
354:
355: -- ----------------------------------------------------------------------------

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

386: and prm.effective_end_date;
387: l_premiums_exist varchar2(1) := 'N';
388: l_message fnd_new_messages.message_name%type := 'BEN_92320_INVALID_WARNING';
389: begin
390: hr_utility.set_location ('Entering '||l_package,10);
391:
392: -- write warning messages if a premium exists during the time that
393: -- the result was created thru to the time that we are doing something
394: -- in correction mode.

Line 424: hr_utility.set_location ('Leaving '||l_package,99);

420:
421: end if;
422: close c_premium;
423:
424: hr_utility.set_location ('Leaving '||l_package,99);
425: end premium_warning;
426:
427: -- ----------------------------------------------------------------------------
428: -- |------------------------< compute_partial_mo >----------------------------|

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

469: l_start_or_stop_date date;
470: l_prorate_flag varchar2(30);
471: --
472: begin
473: hr_utility.set_location ('Entering '||l_package,10);
474: -- load the full premium into a local. This may change to a pro-rated
475: -- or zero value.
476: get_rule_data(p_person_id => p_person_id
477: ,p_business_group_id => p_business_group_id

Line 485: hr_utility.set_location ('Proration code to use: '||

481: ,p_organization_id => l_organization_id
482: ,p_region_2 => l_region_2
483: ,p_jurisdiction => l_jurisdiction);
484: l_val := p_val;
485: hr_utility.set_location ('Proration code to use: '||
486: p_prtl_mo_det_mthd_cd,20);
487: if p_enrt_cvg_strt_dt is not null then
488: hr_utility.set_location ('coverage started this month '||
489: l_package,14);

Line 488: hr_utility.set_location ('coverage started this month '||

484: l_val := p_val;
485: hr_utility.set_location ('Proration code to use: '||
486: p_prtl_mo_det_mthd_cd,20);
487: if p_enrt_cvg_strt_dt is not null then
488: hr_utility.set_location ('coverage started this month '||
489: l_package,14);
490: l_start_or_stop_cd:='STRT';
491: l_start_or_stop_date:=p_enrt_cvg_strt_dt;
492: elsif p_enrt_cvg_thru_dt is not null then

Line 494: hr_utility.set_location ('coverage ended this month '||

490: l_start_or_stop_cd:='STRT';
491: l_start_or_stop_date:=p_enrt_cvg_strt_dt;
492: elsif p_enrt_cvg_thru_dt is not null then
493: -- coverage ended this month....
494: hr_utility.set_location ('coverage ended this month '||
495: l_package,20);
496: l_start_or_stop_cd:='STP';
497: l_start_or_stop_date:=p_enrt_cvg_thru_dt;
498: end if;

Line 524: hr_utility.set_location ('Proration code used: '||

520: ,p_wsh_rl_dy_mo_num =>p_wsh_rl_dy_mo_num
521: ,p_prtl_mo_det_mthd_cd =>l_prtl_mo_det_mthd_cd
522: ,p_prtl_mo_det_mthd_rl =>p_prtl_mo_det_mthd_rl
523: );
524: hr_utility.set_location ('Proration code used: '||
525: l_prtl_mo_det_mthd_cd,20);
526: end if;
527: --
528: -- Since we are changing the value of the premium,

Line 532: hr_utility.set_location('Variable Limits Checking'||l_package,68);

528: -- Since we are changing the value of the premium,
529: -- re-check the upper and lower limits.
530: --
531: if l_val <> p_val then
532: hr_utility.set_location('Variable Limits Checking'||l_package,68);
533: -- get data needed for rules, if we didn't already get it.
534: if p_lwr_lmt_calc_rl is not null or p_upr_lmt_calc_rl is not null then
535: null;
536: else

Line 561: hr_utility.set_location ('Leaving '||l_package,99);

557: p_val => l_val);
558:
559: end if;
560: p_val := l_val;
561: hr_utility.set_location ('Leaving '||l_package,99);
562: exception
563: when others then
564: l_error_text := sqlerrm;
565: hr_utility.set_location ('Fail in '||l_package,999);

Line 565: hr_utility.set_location ('Fail in '||l_package,999);

561: hr_utility.set_location ('Leaving '||l_package,99);
562: exception
563: when others then
564: l_error_text := sqlerrm;
565: hr_utility.set_location ('Fail in '||l_package,999);
566: hr_utility.set_location('Error:'||l_error_text,999);
567: fnd_message.raise_error;
568: end compute_partial_mo;
569: -- ----------------------------------------------------------------------------

Line 566: hr_utility.set_location('Error:'||l_error_text,999);

562: exception
563: when others then
564: l_error_text := sqlerrm;
565: hr_utility.set_location ('Fail in '||l_package,999);
566: hr_utility.set_location('Error:'||l_error_text,999);
567: fnd_message.raise_error;
568: end compute_partial_mo;
569: -- ----------------------------------------------------------------------------
570: -- |------------------------------< compute_prem >----------------------------|

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

650: -- Bug 4892354
651: --
652:
653: begin
654: hr_utility.set_location ('Entering '||l_package,10);
655:
656: -- This procedure is first called with the effective date (or effective-date plus one
657: -- month) as the processing month.
658: -- Then, if the main procedure determines that prior month premiums may be due,

Line 662: hr_utility.set_location ('Actl Prem:'||to_char(p_actl_prem_id),10);

658: -- Then, if the main procedure determines that prior month premiums may be due,
659: -- this procedure is called with each prior month as the processing month
660: -- p_last_day_of_month is always the last day of the processing month
661: -- p_first_day_of_month is always the first day of the processing month
662: hr_utility.set_location ('Actl Prem:'||to_char(p_actl_prem_id),10);
663: hr_utility.set_location ('first date '||
664: to_char(p_first_day_of_month,'dd-mon-yyyy'),10);
665: hr_utility.set_location ('last date '||
666: to_char(p_last_day_of_month,'dd-mon-yyyy'),10);

Line 663: hr_utility.set_location ('first date '||

659: -- this procedure is called with each prior month as the processing month
660: -- p_last_day_of_month is always the last day of the processing month
661: -- p_first_day_of_month is always the first day of the processing month
662: hr_utility.set_location ('Actl Prem:'||to_char(p_actl_prem_id),10);
663: hr_utility.set_location ('first date '||
664: to_char(p_first_day_of_month,'dd-mon-yyyy'),10);
665: hr_utility.set_location ('last date '||
666: to_char(p_last_day_of_month,'dd-mon-yyyy'),10);
667: hr_utility.set_location ('p_enrt_cvg_strt_dt '||p_enrt_cvg_strt_dt,10);

Line 665: hr_utility.set_location ('last date '||

661: -- p_first_day_of_month is always the first day of the processing month
662: hr_utility.set_location ('Actl Prem:'||to_char(p_actl_prem_id),10);
663: hr_utility.set_location ('first date '||
664: to_char(p_first_day_of_month,'dd-mon-yyyy'),10);
665: hr_utility.set_location ('last date '||
666: to_char(p_last_day_of_month,'dd-mon-yyyy'),10);
667: hr_utility.set_location ('p_enrt_cvg_strt_dt '||p_enrt_cvg_strt_dt,10);
668: hr_utility.set_location ('p_enrt_cvg_thru_dt :'|| p_enrt_cvg_thru_dt, 10) ;
669:

Line 667: hr_utility.set_location ('p_enrt_cvg_strt_dt '||p_enrt_cvg_strt_dt,10);

663: hr_utility.set_location ('first date '||
664: to_char(p_first_day_of_month,'dd-mon-yyyy'),10);
665: hr_utility.set_location ('last date '||
666: to_char(p_last_day_of_month,'dd-mon-yyyy'),10);
667: hr_utility.set_location ('p_enrt_cvg_strt_dt '||p_enrt_cvg_strt_dt,10);
668: hr_utility.set_location ('p_enrt_cvg_thru_dt :'|| p_enrt_cvg_thru_dt, 10) ;
669:
670: -- load the full premium into a local. This may change to a pro-rated
671: -- or zero value.

Line 668: hr_utility.set_location ('p_enrt_cvg_thru_dt :'|| p_enrt_cvg_thru_dt, 10) ;

664: to_char(p_first_day_of_month,'dd-mon-yyyy'),10);
665: hr_utility.set_location ('last date '||
666: to_char(p_last_day_of_month,'dd-mon-yyyy'),10);
667: hr_utility.set_location ('p_enrt_cvg_strt_dt '||p_enrt_cvg_strt_dt,10);
668: hr_utility.set_location ('p_enrt_cvg_thru_dt :'|| p_enrt_cvg_thru_dt, 10) ;
669:
670: -- load the full premium into a local. This may change to a pro-rated
671: -- or zero value.
672: l_val := p_val;

Line 699: hr_utility.set_location ('coverage started this month ' || p_stop_looking ,14);

695: then
696: -- coverage started during this month....
697: -- no need to continue to look back thru months
698: p_stop_looking := 'Y';
699: hr_utility.set_location ('coverage started this month ' || p_stop_looking ,14);
700: -- compute partial month premium
701: compute_partial_mo
702: (p_business_group_id => p_business_group_id
703: ,p_effective_date => p_effective_date

Line 734: hr_utility.set_location ('coverage ended this month ',20);

730:
731: -- BUG3379060 and (p_last_day_of_month - 1) then
732: -- BUG3379060 revetred for 3742713 and p_last_day_of_month then
733: -- coverage ended this month....
734: hr_utility.set_location ('coverage ended this month ',20);
735: -- compute partial month premium
736: compute_partial_mo
737: (p_business_group_id => p_business_group_id
738: ,p_effective_date => p_effective_date

Line 772: hr_utility.set_location ('coverage started this month ' || p_stop_looking ,15);

768: if p_enrt_cvg_strt_dt = p_first_day_of_month then
769: -- coverage started the first day of this month....
770: -- no need to continue to look back thru months
771: p_stop_looking := 'Y';
772: hr_utility.set_location ('coverage started this month ' || p_stop_looking ,15);
773: end if;
774:
775: hr_utility.set_location ('write costing ',30);
776: -- first insert into cost allocation keyflex

Line 775: hr_utility.set_location ('write costing ',30);

771: p_stop_looking := 'Y';
772: hr_utility.set_location ('coverage started this month ' || p_stop_looking ,15);
773: end if;
774:
775: hr_utility.set_location ('write costing ',30);
776: -- first insert into cost allocation keyflex
777: determine_costing (p_actl_prem_id => p_actl_prem_id
778: ,p_person_id => p_person_id
779: ,p_effective_date => p_effective_date

Line 782: hr_utility.set_location ('write premium. Actl Prem:'||

778: ,p_person_id => p_person_id
779: ,p_effective_date => p_effective_date
780: ,p_business_group_id => p_business_group_id
781: ,p_cak_id => l_cak);
782: hr_utility.set_location ('write premium. Actl Prem:'||
783: to_char(p_actl_prem_id)||' val:'||to_char(l_val),31);
784: open c_prm(p_prtt_prem_id => p_prtt_prem_id);
785: fetch c_prm into l_prm;
786: if c_prm%notfound or c_prm%notfound is null then

Line 789: hr_utility.set_location ('l_effective_date_mo :'|| l_effective_date_mo, 10) ;

785: fetch c_prm into l_prm;
786: if c_prm%notfound or c_prm%notfound is null then
787: --
788: l_effective_date_mo := last_day(to_date(p_yr_num||lpad(p_mo_num,2,0),'YYYYMM')); -- bug 2784213
789: hr_utility.set_location ('l_effective_date_mo :'|| l_effective_date_mo, 10) ;
790: --
791: ben_prtt_prem_by_mo_api.create_prtt_prem_by_mo
792: (p_prtt_prem_by_mo_id => l_prm.prtt_prem_by_mo_id
793: ,p_effective_start_date => l_effective_start_date

Line 829: hr_utility.set_location ('update the premium:'|| l_prm.prtt_prem_by_mo_id, 10) ;

825: fetch c_prm_ovn into l_prm ;
826: close c_prm_ovn ;
827: */
828: if l_prm.cr_val > 0 and l_val > 0 then
829: hr_utility.set_location ('update the premium:'|| l_prm.prtt_prem_by_mo_id, 10) ;
830: --
831: -- Bug 4892354 : Get Valid Update Modes
832: --
833: dt_api.Find_DT_Upd_Modes

Line 888: hr_utility.set_location ('correct the premium:'|| l_prm.prtt_prem_by_mo_id, 10) ;

884: elsif (l_prm.val > 0 and p_enrt_cvg_thru_dt > p_last_day_of_month )
885: and ( l_prm.uom <> p_uom or l_prm.val <> l_val or
886: nvl(l_prm.cost_allocation_keyflex_id,-1) <> nvl(l_cak,-1) ) then
887: --
888: hr_utility.set_location ('correct the premium:'|| l_prm.prtt_prem_by_mo_id, 10) ;
889: --
890: -- Bug 4892354 : Get Valid Update Modes
891: --
892: dt_api.Find_DT_Upd_Modes

Line 936: hr_utility.set_location (' monthly chg found ' || p_stop_looking ,14);

932: ,p_datetrack_mode => l_prm_update_mode);
933: else
934: -- if monthly chg found without any change dont go further
935: p_stop_looking := 'Y';
936: hr_utility.set_location (' monthly chg found ' || p_stop_looking ,14);
937: end if ;
938: --
939: else
940: -- if manually adjusted flag found dont go further to generate the premium

Line 942: hr_utility.set_location (' manually adjusted flag found ' || p_stop_looking ,14);

938: --
939: else
940: -- if manually adjusted flag found dont go further to generate the premium
941: p_stop_looking := 'Y';
942: hr_utility.set_location (' manually adjusted flag found ' || p_stop_looking ,14);
943: end if;
944: --
945: end if;
946: p_out_val := l_val;

Line 947: hr_utility.set_location ('Leaving '||l_package,99);

943: end if;
944: --
945: end if;
946: p_out_val := l_val;
947: hr_utility.set_location ('Leaving '||l_package,99);
948: exception
949: when others then
950: l_error_text := sqlerrm;
951: hr_utility.set_location ('Fail in '||l_package,999);

Line 951: hr_utility.set_location ('Fail in '||l_package,999);

947: hr_utility.set_location ('Leaving '||l_package,99);
948: exception
949: when others then
950: l_error_text := sqlerrm;
951: hr_utility.set_location ('Fail in '||l_package,999);
952: hr_utility.set_location('Error:'||l_error_text,999);
953: fnd_message.raise_error;
954: end compute_prem;
955: -- ----------------------------------------------------------------------------

Line 952: hr_utility.set_location('Error:'||l_error_text,999);

948: exception
949: when others then
950: l_error_text := sqlerrm;
951: hr_utility.set_location ('Fail in '||l_package,999);
952: hr_utility.set_location('Error:'||l_error_text,999);
953: fnd_message.raise_error;
954: end compute_prem;
955: -- ----------------------------------------------------------------------------
956: -- |------------------------------< main >------------------------------------|

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

1082: l_person_ended varchar2(30):='N';
1083: -- Concurrent Code End
1084: begin
1085: -- p_effective_date is always the last day of the month this is being run
1086: hr_utility.set_location ('Entering '||l_package,10);
1087: hr_utility.set_location ('For person:'||to_char(p_person_id),20);
1088:
1089: -- Concurrent Code Begin
1090: l_actn := 'Initializing...';

Line 1087: hr_utility.set_location ('For person:'||to_char(p_person_id),20);

1083: -- Concurrent Code End
1084: begin
1085: -- p_effective_date is always the last day of the month this is being run
1086: hr_utility.set_location ('Entering '||l_package,10);
1087: hr_utility.set_location ('For person:'||to_char(p_person_id),20);
1088:
1089: -- Concurrent Code Begin
1090: l_actn := 'Initializing...';
1091: Savepoint process_premium_savepoint;

Line 1118: hr_utility.set_location ('Result id '||l_results.prtt_enrt_rslt_id,10);

1114: close c_opt;
1115: else l_opt := null;
1116: end if;
1117:
1118: hr_utility.set_location ('Result id '||l_results.prtt_enrt_rslt_id,10);
1119:
1120: l_rule_ret:='Y';
1121: if p_comp_selection_rl is not null then
1122: hr_utility.set_location('found a rule',12);

Line 1122: hr_utility.set_location('found a rule',12);

1118: hr_utility.set_location ('Result id '||l_results.prtt_enrt_rslt_id,10);
1119:
1120: l_rule_ret:='Y';
1121: if p_comp_selection_rl is not null then
1122: hr_utility.set_location('found a rule',12);
1123: l_rule_ret:=ben_maintain_designee_elig.comp_selection_rule(
1124: p_person_id => p_person_id
1125: ,p_business_group_id => p_business_group_id
1126: ,p_pgm_id => l_results.pgm_id

Line 1136: hr_utility.set_location(l_package,13);

1132: ,p_comp_selection_rule_id => p_comp_selection_rl
1133: ,p_effective_date => p_effective_date
1134: );
1135: end if;
1136: hr_utility.set_location(l_package,13);
1137: if l_rule_ret='Y' then
1138: -- Concurrent Code End
1139: for l_prems in c_prems(p_prtt_enrt_rslt_id => l_results.prtt_enrt_rslt_id) loop
1140: if l_prems.prsptv_r_rtsptv_cd = 'PRO' or

Line 1168: hr_utility.set_location('look back date ' || l_look_back_dt , 56 ) ;

1164: if l_prems.cr_lkbk_val is not null then
1165: l_look_back_dt := add_months( l_last_day_of_month , (l_prems.cr_lkbk_val * -1)) ;
1166: end if ;
1167: end if ;
1168: hr_utility.set_location('look back date ' || l_look_back_dt , 56 ) ;
1169: --
1170: l_current_month := 'Y';
1171: loop
1172: l_stop_looking := 'N';

Line 1173: hr_utility.set_location(l_package,133);

1169: --
1170: l_current_month := 'Y';
1171: loop
1172: l_stop_looking := 'N';
1173: hr_utility.set_location(l_package,133);
1174: if l_results.enrt_cvg_thru_dt >= l_first_day_of_month then
1175: -- they have coverage during the month we are processing.
1176: -- If they don't this if stmt will ensure we don't write
1177: -- a premium for them.

Line 1251: hr_utility.set_location('l_stop_looking = ' || l_stop_looking, 999);

1247: -- in the month we are processing, there is no need to continue to
1248: -- look back for other month's premiums.
1249: -- We also don't look back if the result was created prior to this
1250: -- month (because prior runs would have created the premiums).
1251: hr_utility.set_location('l_stop_looking = ' || l_stop_looking, 999);
1252: hr_utility.set_location('l_results.effective_start_date = ' || l_results.effective_start_date, 999);
1253: hr_utility.set_location('l_first_day_of_month = ' || l_first_day_of_month, 999);
1254:
1255: if l_stop_looking = 'N' then

Line 1252: hr_utility.set_location('l_results.effective_start_date = ' || l_results.effective_start_date, 999);

1248: -- look back for other month's premiums.
1249: -- We also don't look back if the result was created prior to this
1250: -- month (because prior runs would have created the premiums).
1251: hr_utility.set_location('l_stop_looking = ' || l_stop_looking, 999);
1252: hr_utility.set_location('l_results.effective_start_date = ' || l_results.effective_start_date, 999);
1253: hr_utility.set_location('l_first_day_of_month = ' || l_first_day_of_month, 999);
1254:
1255: if l_stop_looking = 'N' then
1256: -- For results that were created for the first time

Line 1253: hr_utility.set_location('l_first_day_of_month = ' || l_first_day_of_month, 999);

1249: -- We also don't look back if the result was created prior to this
1250: -- month (because prior runs would have created the premiums).
1251: hr_utility.set_location('l_stop_looking = ' || l_stop_looking, 999);
1252: hr_utility.set_location('l_results.effective_start_date = ' || l_results.effective_start_date, 999);
1253: hr_utility.set_location('l_first_day_of_month = ' || l_first_day_of_month, 999);
1254:
1255: if l_stop_looking = 'N' then
1256: -- For results that were created for the first time
1257: -- this month, we want to look back thru prior months to

Line 1287: hr_utility.set_location ('Look for prior months ',50);

1283: -- l_results.prtt_enrt_rslt_id,
1284: -- p_effective_start_date => l_results.effective_start_date);
1285: --fetch c_old_result into l_old_result;
1286: --if c_old_result%notfound or c_old_result%notfound is null then
1287: hr_utility.set_location ('Look for prior months ',50);
1288: l_first_day_of_month := add_months(l_first_day_of_month, -1);
1289: l_last_day_of_month := add_months(l_last_day_of_month, -1);
1290: l_mo_num := to_char(l_last_day_of_month,'MM');
1291: l_yr_num := to_char(l_last_day_of_month,'YYYY');

Line 1300: hr_utility.set_location ('l_first_day_of_month '|| l_first_day_of_month ||

1296: --close c_old_result;
1297: -- for OSP the the result will be the same so we hve to validate the
1298: -- condition with premium row
1299:
1300: hr_utility.set_location ('l_first_day_of_month '|| l_first_day_of_month ||
1301: ' l_prem.effective_start_date '||trunc(l_prems.effective_start_date,'MM') ,50);
1302:
1303: --if trunc(l_first_day_of_month) < trunc(round(l_results.effective_start_date,'MM')) then
1304: if trunc(l_first_day_of_month) < trunc(l_prems.effective_start_date,'MM') then

Line 1306: hr_utility.set_location ( ' exit calcualtion ' ,50);

1302:
1303: --if trunc(l_first_day_of_month) < trunc(round(l_results.effective_start_date,'MM')) then
1304: if trunc(l_first_day_of_month) < trunc(l_prems.effective_start_date,'MM') then
1305:
1306: hr_utility.set_location ( ' exit calcualtion ' ,50);
1307: exit ;
1308: end if ;
1309:
1310:

Line 1315: hr_utility.set_location ( ' exit look back ' || l_look_back_dt ,50);

1311: -- if the month end date is below than look back date dont
1312: -- calcualte
1313:
1314: if l_look_back_dt is not null and l_look_back_dt > l_last_day_of_month then
1315: hr_utility.set_location ( ' exit look back ' || l_look_back_dt ,50);
1316: exit ;
1317: end if ;
1318:
1319: else

Line 1328: hr_utility.set_location(l_package,110);

1324: end loop; -- premiums
1325: end if; -- comp object rule passed
1326: end loop; -- results
1327: -- Concurrent Code Begin
1328: hr_utility.set_location(l_package,110);
1329: l_actn := 'Calling Ben_batch_utils.write_comp...';
1330: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
1331: ,p_effective_date => p_effective_date
1332: );

Line 1352: hr_utility.set_location ('Leaving '||l_package,99);

1348: ,p_effective_date => p_effective_date
1349: );
1350: End if;
1351: commit;
1352: hr_utility.set_location ('Leaving '||l_package,99);
1353: Exception
1354: When others then
1355: l_error_text := sqlerrm;
1356: hr_utility.set_location ('Fail in '||l_package,998);

Line 1356: hr_utility.set_location ('Fail in '||l_package,998);

1352: hr_utility.set_location ('Leaving '||l_package,99);
1353: Exception
1354: When others then
1355: l_error_text := sqlerrm;
1356: hr_utility.set_location ('Fail in '||l_package,998);
1357: hr_utility.set_location (' with error '||l_error_text,999);
1358: rollback to process_premium_savepoint;
1359: ben_batch_utils.write_error_rec;
1360: ben_batch_utils.rpt_error(p_proc => l_package

Line 1357: hr_utility.set_location (' with error '||l_error_text,999);

1353: Exception
1354: When others then
1355: l_error_text := sqlerrm;
1356: hr_utility.set_location ('Fail in '||l_package,998);
1357: hr_utility.set_location (' with error '||l_error_text,999);
1358: rollback to process_premium_savepoint;
1359: ben_batch_utils.write_error_rec;
1360: ben_batch_utils.rpt_error(p_proc => l_package
1361: ,p_last_actn => l_actn