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 125: hr_utility.set_location ('Entering '||l_package,10);

121:
122: l_jurisdiction PAY_CA_EMP_PROV_TAX_INFO_F.JURISDICTION_CODE%type := null;
123:
124: begin
125: hr_utility.set_location ('Entering '||l_package,10);
126: open csr_asg;
127: fetch csr_asg into p_assignment_id, p_organization_id,
128: p_region_2, p_location_id;
129: if csr_asg%NOTFOUND or csr_asg%NOTFOUND is null then

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

137: -- (p_state => p_region_2);
138: --else
139: p_jurisdiction := null;
140: --end if;
141: hr_utility.set_location ('Leaving '||l_package,99);
142: end get_rule_data;
143:
144: -- ----------------------------------------------------------------------------
145: -- |------------------------< determine_costing >----------------------------|

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

219: l_cnt2 number;
220: l_outputs ff_exec.outputs_t;
221:
222: begin
223: hr_utility.set_location ('Entering '||l_package,10);
224: l_effective_date := trunc(p_effective_date);
225: --
226: --
227: -- Look for cost allocation definition

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

227: -- Look for cost allocation definition
228: open csr_cost_id;
229: fetch csr_cost_id into l_cost_id;
230: if csr_cost_id%FOUND then
231: hr_utility.set_location(l_package, 27);
232:
233: -- get the actl-prem cost-allocation info to copy to the prtt-prem cost-allocation.
234: open csr_apr_cak;
235: fetch csr_apr_cak into l_apr_cak(1).sgmt, l_apr_cak(2).sgmt,

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

245: l_apr_cak(25).sgmt, l_apr_cak(26).sgmt, l_apr_cak(27).sgmt,
246: l_apr_cak(28).sgmt, l_apr_cak(29).sgmt,
247: l_apr_cak(30).sgmt;
248: if csr_apr_cak%FOUND then
249: hr_utility.set_location(l_package, 29);
250:
251: -- check for overrides to the actl-prem cost-allocation info, stored in
252: -- prem-cstg-by-sgmt.
253: open csr_asg;

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

300: end loop;
301: end if;
302: close csr_asg;
303:
304: hr_utility.set_location(l_package, 31);
305:
306: hr_kflex_utility.ins_or_sel_keyflex_comb
307: (p_appl_short_name => 'PAY'
308: ,p_flex_code => 'COST'

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

341: ,p_ccid => p_cak_id -- out
342: ,p_concat_segments_out => l_segments -- out
343: );
344:
345: hr_utility.set_location(l_package, 35);
346: end if;
347: close csr_apr_cak;
348:
349: end if;

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

348:
349: end if;
350: close csr_cost_id;
351:
352: hr_utility.set_location ('Leaving '||l_package,99);
353: exception
354: when others then
355: l_error_text := sqlerrm;
356: hr_utility.set_location ('Fail in '||l_package,999);

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

352: hr_utility.set_location ('Leaving '||l_package,99);
353: exception
354: when others then
355: l_error_text := sqlerrm;
356: hr_utility.set_location ('Fail in '||l_package,999);
357: hr_utility.set_location('Error:'||l_error_text,999);
358: fnd_message.raise_error;
359: end determine_costing;
360:

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

353: exception
354: when others then
355: l_error_text := sqlerrm;
356: hr_utility.set_location ('Fail in '||l_package,999);
357: hr_utility.set_location('Error:'||l_error_text,999);
358: fnd_message.raise_error;
359: end determine_costing;
360:
361: -- ----------------------------------------------------------------------------

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

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

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

426:
427: end if;
428: close c_premium;
429:
430: hr_utility.set_location ('Leaving '||l_package,99);
431: end premium_warning;
432:
433: -- ----------------------------------------------------------------------------
434: -- |------------------------< compute_partial_mo >----------------------------|

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

475: l_start_or_stop_date date;
476: l_prorate_flag varchar2(30);
477: --
478: begin
479: hr_utility.set_location ('Entering '||l_package,10);
480: -- load the full premium into a local. This may change to a pro-rated
481: -- or zero value.
482: get_rule_data(p_person_id => p_person_id
483: ,p_business_group_id => p_business_group_id

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

487: ,p_organization_id => l_organization_id
488: ,p_region_2 => l_region_2
489: ,p_jurisdiction => l_jurisdiction);
490: l_val := p_val;
491: hr_utility.set_location ('Proration code to use: '||
492: p_prtl_mo_det_mthd_cd,20);
493: if p_enrt_cvg_strt_dt is not null then
494: hr_utility.set_location ('coverage started this month '||
495: l_package,14);

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

490: l_val := p_val;
491: hr_utility.set_location ('Proration code to use: '||
492: p_prtl_mo_det_mthd_cd,20);
493: if p_enrt_cvg_strt_dt is not null then
494: hr_utility.set_location ('coverage started this month '||
495: l_package,14);
496: l_start_or_stop_cd:='STRT';
497: l_start_or_stop_date:=p_enrt_cvg_strt_dt;
498: elsif p_enrt_cvg_thru_dt is not null then

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

496: l_start_or_stop_cd:='STRT';
497: l_start_or_stop_date:=p_enrt_cvg_strt_dt;
498: elsif p_enrt_cvg_thru_dt is not null then
499: -- coverage ended this month....
500: hr_utility.set_location ('coverage ended this month '||
501: l_package,20);
502: l_start_or_stop_cd:='STP';
503: l_start_or_stop_date:=p_enrt_cvg_thru_dt;
504: end if;

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

526: ,p_wsh_rl_dy_mo_num =>p_wsh_rl_dy_mo_num
527: ,p_prtl_mo_det_mthd_cd =>l_prtl_mo_det_mthd_cd
528: ,p_prtl_mo_det_mthd_rl =>p_prtl_mo_det_mthd_rl
529: );
530: hr_utility.set_location ('Proration code used: '||
531: l_prtl_mo_det_mthd_cd,20);
532: end if;
533: --
534: -- Since we are changing the value of the premium,

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

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

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

563: p_val => l_val);
564:
565: end if;
566: p_val := l_val;
567: hr_utility.set_location ('Leaving '||l_package,99);
568: exception
569: when others then
570: l_error_text := sqlerrm;
571: hr_utility.set_location ('Fail in '||l_package,999);

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

567: hr_utility.set_location ('Leaving '||l_package,99);
568: exception
569: when others then
570: l_error_text := sqlerrm;
571: hr_utility.set_location ('Fail in '||l_package,999);
572: hr_utility.set_location('Error:'||l_error_text,999);
573: fnd_message.raise_error;
574: end compute_partial_mo;
575: -- ----------------------------------------------------------------------------

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

568: exception
569: when others then
570: l_error_text := sqlerrm;
571: hr_utility.set_location ('Fail in '||l_package,999);
572: hr_utility.set_location('Error:'||l_error_text,999);
573: fnd_message.raise_error;
574: end compute_partial_mo;
575: -- ----------------------------------------------------------------------------
576: -- |------------------------------< compute_prem >----------------------------|

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

656: -- Bug 4892354
657: --
658:
659: begin
660: hr_utility.set_location ('Entering '||l_package,10);
661:
662: -- This procedure is first called with the effective date (or effective-date plus one
663: -- month) as the processing month.
664: -- Then, if the main procedure determines that prior month premiums may be due,

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

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

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

665: -- this procedure is called with each prior month as the processing month
666: -- p_last_day_of_month is always the last day of the processing month
667: -- p_first_day_of_month is always the first day of the processing month
668: hr_utility.set_location ('Actl Prem:'||to_char(p_actl_prem_id),10);
669: hr_utility.set_location ('first date '||
670: to_char(p_first_day_of_month,'dd-mon-yyyy'),10);
671: hr_utility.set_location ('last date '||
672: to_char(p_last_day_of_month,'dd-mon-yyyy'),10);
673: hr_utility.set_location ('p_enrt_cvg_strt_dt '||p_enrt_cvg_strt_dt,10);

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

667: -- p_first_day_of_month is always the first day of the processing month
668: hr_utility.set_location ('Actl Prem:'||to_char(p_actl_prem_id),10);
669: hr_utility.set_location ('first date '||
670: to_char(p_first_day_of_month,'dd-mon-yyyy'),10);
671: hr_utility.set_location ('last date '||
672: to_char(p_last_day_of_month,'dd-mon-yyyy'),10);
673: hr_utility.set_location ('p_enrt_cvg_strt_dt '||p_enrt_cvg_strt_dt,10);
674: hr_utility.set_location ('p_enrt_cvg_thru_dt :'|| p_enrt_cvg_thru_dt, 10) ;
675:

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

669: hr_utility.set_location ('first date '||
670: to_char(p_first_day_of_month,'dd-mon-yyyy'),10);
671: hr_utility.set_location ('last date '||
672: to_char(p_last_day_of_month,'dd-mon-yyyy'),10);
673: hr_utility.set_location ('p_enrt_cvg_strt_dt '||p_enrt_cvg_strt_dt,10);
674: hr_utility.set_location ('p_enrt_cvg_thru_dt :'|| p_enrt_cvg_thru_dt, 10) ;
675:
676: -- load the full premium into a local. This may change to a pro-rated
677: -- or zero value.

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

670: to_char(p_first_day_of_month,'dd-mon-yyyy'),10);
671: hr_utility.set_location ('last date '||
672: to_char(p_last_day_of_month,'dd-mon-yyyy'),10);
673: hr_utility.set_location ('p_enrt_cvg_strt_dt '||p_enrt_cvg_strt_dt,10);
674: hr_utility.set_location ('p_enrt_cvg_thru_dt :'|| p_enrt_cvg_thru_dt, 10) ;
675:
676: -- load the full premium into a local. This may change to a pro-rated
677: -- or zero value.
678: l_val := p_val;

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

701: then
702: -- coverage started during this month....
703: -- no need to continue to look back thru months
704: p_stop_looking := 'Y';
705: hr_utility.set_location ('coverage started this month ' || p_stop_looking ,14);
706: -- compute partial month premium
707: compute_partial_mo
708: (p_business_group_id => p_business_group_id
709: ,p_effective_date => p_effective_date

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

736:
737: -- BUG3379060 and (p_last_day_of_month - 1) then
738: -- BUG3379060 revetred for 3742713 and p_last_day_of_month then
739: -- coverage ended this month....
740: hr_utility.set_location ('coverage ended this month ',20);
741: -- compute partial month premium
742: compute_partial_mo
743: (p_business_group_id => p_business_group_id
744: ,p_effective_date => p_effective_date

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

774: if p_enrt_cvg_strt_dt = p_first_day_of_month then
775: -- coverage started the first day of this month....
776: -- no need to continue to look back thru months
777: p_stop_looking := 'Y';
778: hr_utility.set_location ('coverage started this month ' || p_stop_looking ,15);
779: end if;
780:
781: hr_utility.set_location ('write costing ',30);
782: -- first insert into cost allocation keyflex

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

777: p_stop_looking := 'Y';
778: hr_utility.set_location ('coverage started this month ' || p_stop_looking ,15);
779: end if;
780:
781: hr_utility.set_location ('write costing ',30);
782: -- first insert into cost allocation keyflex
783: determine_costing (p_actl_prem_id => p_actl_prem_id
784: ,p_person_id => p_person_id
785: ,p_effective_date => p_effective_date

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

784: ,p_person_id => p_person_id
785: ,p_effective_date => p_effective_date
786: ,p_business_group_id => p_business_group_id
787: ,p_cak_id => l_cak);
788: hr_utility.set_location ('write premium. Actl Prem:'||
789: to_char(p_actl_prem_id)||' val:'||to_char(l_val),31);
790: open c_prm(p_prtt_prem_id => p_prtt_prem_id);
791: fetch c_prm into l_prm;
792: if c_prm%notfound or c_prm%notfound is null then

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

791: fetch c_prm into l_prm;
792: if c_prm%notfound or c_prm%notfound is null then
793: --
794: l_effective_date_mo := last_day(to_date(p_yr_num||lpad(p_mo_num,2,0),'YYYYMM')); -- bug 2784213
795: hr_utility.set_location ('l_effective_date_mo :'|| l_effective_date_mo, 10) ;
796: --
797: ben_prtt_prem_by_mo_api.create_prtt_prem_by_mo
798: (p_prtt_prem_by_mo_id => l_prm.prtt_prem_by_mo_id
799: ,p_effective_start_date => l_effective_start_date

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

831: fetch c_prm_ovn into l_prm ;
832: close c_prm_ovn ;
833: */
834: if l_prm.cr_val > 0 and l_val > 0 then
835: hr_utility.set_location ('update the premium:'|| l_prm.prtt_prem_by_mo_id, 10) ;
836: --
837: -- Bug 4892354 : Get Valid Update Modes
838: --
839: dt_api.Find_DT_Upd_Modes

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

890: elsif (l_prm.val > 0 and p_enrt_cvg_thru_dt > p_last_day_of_month )
891: and ( l_prm.uom <> p_uom or l_prm.val <> l_val or
892: nvl(l_prm.cost_allocation_keyflex_id,-1) <> nvl(l_cak,-1) ) then
893: --
894: hr_utility.set_location ('correct the premium:'|| l_prm.prtt_prem_by_mo_id, 10) ;
895: --
896: -- Bug 4892354 : Get Valid Update Modes
897: --
898: dt_api.Find_DT_Upd_Modes

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

938: ,p_datetrack_mode => l_prm_update_mode);
939: else
940: -- if monthly chg found without any change dont go further
941: p_stop_looking := 'Y';
942: hr_utility.set_location (' monthly chg found ' || p_stop_looking ,14);
943: end if ;
944: --
945: else
946: -- if manually adjusted flag found dont go further to generate the premium

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

944: --
945: else
946: -- if manually adjusted flag found dont go further to generate the premium
947: p_stop_looking := 'Y';
948: hr_utility.set_location (' manually adjusted flag found ' || p_stop_looking ,14);
949: end if;
950: --
951: end if;
952: p_out_val := l_val;

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

949: end if;
950: --
951: end if;
952: p_out_val := l_val;
953: hr_utility.set_location ('Leaving '||l_package,99);
954: exception
955: when others then
956: l_error_text := sqlerrm;
957: hr_utility.set_location ('Fail in '||l_package,999);

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

953: hr_utility.set_location ('Leaving '||l_package,99);
954: exception
955: when others then
956: l_error_text := sqlerrm;
957: hr_utility.set_location ('Fail in '||l_package,999);
958: hr_utility.set_location('Error:'||l_error_text,999);
959: fnd_message.raise_error;
960: end compute_prem;
961: -- ----------------------------------------------------------------------------

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

954: exception
955: when others then
956: l_error_text := sqlerrm;
957: hr_utility.set_location ('Fail in '||l_package,999);
958: hr_utility.set_location('Error:'||l_error_text,999);
959: fnd_message.raise_error;
960: end compute_prem;
961: -- ----------------------------------------------------------------------------
962: -- |------------------------------< main >------------------------------------|

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

1095: l_person_ended varchar2(30):='N';
1096: -- Concurrent Code End
1097: begin
1098: -- p_effective_date is always the last day of the month this is being run
1099: hr_utility.set_location ('Entering '||l_package,10);
1100: hr_utility.set_location ('For person:'||to_char(p_person_id),20);
1101:
1102: -- Concurrent Code Begin
1103: l_actn := 'Initializing...';

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

1096: -- Concurrent Code End
1097: begin
1098: -- p_effective_date is always the last day of the month this is being run
1099: hr_utility.set_location ('Entering '||l_package,10);
1100: hr_utility.set_location ('For person:'||to_char(p_person_id),20);
1101:
1102: -- Concurrent Code Begin
1103: l_actn := 'Initializing...';
1104: Savepoint process_premium_savepoint;

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

1127: close c_opt;
1128: else l_opt := null;
1129: end if;
1130:
1131: hr_utility.set_location ('Result id '||l_results.prtt_enrt_rslt_id,10);
1132:
1133: l_rule_ret:='Y';
1134: if p_comp_selection_rl is not null then
1135: hr_utility.set_location('found a rule',12);

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

1131: hr_utility.set_location ('Result id '||l_results.prtt_enrt_rslt_id,10);
1132:
1133: l_rule_ret:='Y';
1134: if p_comp_selection_rl is not null then
1135: hr_utility.set_location('found a rule',12);
1136: l_rule_ret:=ben_maintain_designee_elig.comp_selection_rule(
1137: p_person_id => p_person_id
1138: ,p_business_group_id => p_business_group_id
1139: ,p_pgm_id => l_results.pgm_id

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

1145: ,p_comp_selection_rule_id => p_comp_selection_rl
1146: ,p_effective_date => p_effective_date
1147: );
1148: end if;
1149: hr_utility.set_location(l_package,13);
1150: if l_rule_ret='Y' then
1151: -- Concurrent Code End
1152: for l_prems in c_prems(p_prtt_enrt_rslt_id => l_results.prtt_enrt_rslt_id) loop
1153: if l_prems.prsptv_r_rtsptv_cd = 'PRO' or

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

1177: if l_prems.cr_lkbk_val is not null then
1178: l_look_back_dt := add_months( l_last_day_of_month , (l_prems.cr_lkbk_val * -1)) ;
1179: end if ;
1180: end if ;
1181: hr_utility.set_location('look back date ' || l_look_back_dt , 56 ) ;
1182: --
1183: l_current_month := 'Y';
1184: loop
1185: l_stop_looking := 'N';

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

1182: --
1183: l_current_month := 'Y';
1184: loop
1185: l_stop_looking := 'N';
1186: hr_utility.set_location(l_package,133);
1187: if l_results.enrt_cvg_thru_dt >= l_first_day_of_month then
1188: -- they have coverage during the month we are processing.
1189: -- If they don't this if stmt will ensure we don't write
1190: -- a premium for them.

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

1260: -- in the month we are processing, there is no need to continue to
1261: -- look back for other month's premiums.
1262: -- We also don't look back if the result was created prior to this
1263: -- month (because prior runs would have created the premiums).
1264: hr_utility.set_location('l_stop_looking = ' || l_stop_looking, 999);
1265: hr_utility.set_location('l_results.effective_start_date = ' || l_results.effective_start_date, 999);
1266: hr_utility.set_location('l_first_day_of_month = ' || l_first_day_of_month, 999);
1267:
1268: if l_stop_looking = 'N' then

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

1261: -- look back for other month's premiums.
1262: -- We also don't look back if the result was created prior to this
1263: -- month (because prior runs would have created the premiums).
1264: hr_utility.set_location('l_stop_looking = ' || l_stop_looking, 999);
1265: hr_utility.set_location('l_results.effective_start_date = ' || l_results.effective_start_date, 999);
1266: hr_utility.set_location('l_first_day_of_month = ' || l_first_day_of_month, 999);
1267:
1268: if l_stop_looking = 'N' then
1269: -- For results that were created for the first time

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

1262: -- We also don't look back if the result was created prior to this
1263: -- month (because prior runs would have created the premiums).
1264: hr_utility.set_location('l_stop_looking = ' || l_stop_looking, 999);
1265: hr_utility.set_location('l_results.effective_start_date = ' || l_results.effective_start_date, 999);
1266: hr_utility.set_location('l_first_day_of_month = ' || l_first_day_of_month, 999);
1267:
1268: if l_stop_looking = 'N' then
1269: -- For results that were created for the first time
1270: -- this month, we want to look back thru prior months to

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

1296: -- l_results.prtt_enrt_rslt_id,
1297: -- p_effective_start_date => l_results.effective_start_date);
1298: --fetch c_old_result into l_old_result;
1299: --if c_old_result%notfound or c_old_result%notfound is null then
1300: hr_utility.set_location ('Look for prior months ',50);
1301: l_first_day_of_month := add_months(l_first_day_of_month, -1);
1302: l_last_day_of_month := add_months(l_last_day_of_month, -1);
1303: l_mo_num := to_char(l_last_day_of_month,'MM');
1304: l_yr_num := to_char(l_last_day_of_month,'YYYY');

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

1309: --close c_old_result;
1310: -- for OSP the the result will be the same so we hve to validate the
1311: -- condition with premium row
1312:
1313: hr_utility.set_location ('l_first_day_of_month '|| l_first_day_of_month ||
1314: ' l_prem.effective_start_date '||trunc(l_prems.effective_start_date,'MM') ,50);
1315:
1316: --if trunc(l_first_day_of_month) < trunc(round(l_results.effective_start_date,'MM')) then
1317: if trunc(l_first_day_of_month) < trunc(l_prems.effective_start_date,'MM') then

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

1315:
1316: --if trunc(l_first_day_of_month) < trunc(round(l_results.effective_start_date,'MM')) then
1317: if trunc(l_first_day_of_month) < trunc(l_prems.effective_start_date,'MM') then
1318:
1319: hr_utility.set_location ( ' exit calcualtion ' ,50);
1320: exit ;
1321: end if ;
1322:
1323:

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

1324: -- if the month end date is below than look back date dont
1325: -- calcualte
1326:
1327: if l_look_back_dt is not null and l_look_back_dt > l_last_day_of_month then
1328: hr_utility.set_location ( ' exit look back ' || l_look_back_dt ,50);
1329: exit ;
1330: end if ;
1331:
1332: else

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

1337: end loop; -- premiums
1338: end if; -- comp object rule passed
1339: end loop; -- results
1340: -- Concurrent Code Begin
1341: hr_utility.set_location(l_package,110);
1342: l_actn := 'Calling Ben_batch_utils.write_comp...';
1343: Ben_batch_utils.write_comp(p_business_group_id => p_business_group_id
1344: ,p_effective_date => p_effective_date
1345: );

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

1361: ,p_effective_date => p_effective_date
1362: );
1363: End if;
1364: commit;
1365: hr_utility.set_location ('Leaving '||l_package,99);
1366: Exception
1367: When others then
1368: l_error_text := sqlerrm;
1369: hr_utility.set_location ('Fail in '||l_package,998);

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

1365: hr_utility.set_location ('Leaving '||l_package,99);
1366: Exception
1367: When others then
1368: l_error_text := sqlerrm;
1369: hr_utility.set_location ('Fail in '||l_package,998);
1370: hr_utility.set_location (' with error '||l_error_text,999);
1371: rollback to process_premium_savepoint;
1372: ben_batch_utils.write_error_rec;
1373: ben_batch_utils.rpt_error(p_proc => l_package

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

1366: Exception
1367: When others then
1368: l_error_text := sqlerrm;
1369: hr_utility.set_location ('Fail in '||l_package,998);
1370: hr_utility.set_location (' with error '||l_error_text,999);
1371: rollback to process_premium_savepoint;
1372: ben_batch_utils.write_error_rec;
1373: ben_batch_utils.rpt_error(p_proc => l_package
1374: ,p_last_actn => l_actn