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

Line 47: hr_utility.set_location('Entering:'||l_proc, 5);

43: l_api_updating boolean;
44: --
45: Begin
46: --
47: hr_utility.set_location('Entering:'||l_proc, 5);
48: --
49: l_api_updating := ben_prc_shd.api_updating
50: (p_effective_date => p_effective_date,
51: p_prtt_reimbmt_rqst_id => p_prtt_reimbmt_rqst_id,

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

72: end if;
73: --
74: end if;
75: --
76: hr_utility.set_location('Leaving:'||l_proc, 10);
77: --
78: End chk_prtt_reimbmt_rqst_id;
79: --
80:

Line 212: hr_utility.set_location('Entering:'||l_proc,5);

208: l_yr_end_date date;
209: l_assignment_id number;
210: l_assignment_action_id number;
211: begin
212: hr_utility.set_location('Entering:'||l_proc,5);
213: hr_utility.set_location ('Effective date'||p_effective_date,111);
214: l_assignment_id := null;
215: open c_asg('E',p_person_id );
216: fetch c_asg into l_assignment_id;

Line 213: hr_utility.set_location ('Effective date'||p_effective_date,111);

209: l_assignment_id number;
210: l_assignment_action_id number;
211: begin
212: hr_utility.set_location('Entering:'||l_proc,5);
213: hr_utility.set_location ('Effective date'||p_effective_date,111);
214: l_assignment_id := null;
215: open c_asg('E',p_person_id );
216: fetch c_asg into l_assignment_id;
217: close c_asg;

Line 220: hr_utility.set_location (' employee failed ' || l_assignment_id , 30) ;

216: fetch c_asg into l_assignment_id;
217: close c_asg;
218: IF l_assignment_id IS NULL THEN
219: --
220: hr_utility.set_location (' employee failed ' || l_assignment_id , 30) ;
221: open c_asg('B',p_person_id);
222: fetch c_asg into l_assignment_id;
223: close c_asg;
224: --

Line 237: hr_utility.set_location(' result id ' || p_prtt_enrt_rslt_id ,293);

233: open c_abr_prv;
234: fetch c_abr_prv into l_abr_prv;
235: close c_abr_prv;
236:
237: hr_utility.set_location(' result id ' || p_prtt_enrt_rslt_id ,293);
238: hr_utility.set_location(' acty_base_rt ' || l_acty_base_rt_id,293);
239: hr_utility.set_location(' ytd cntr cd ' || l_abr_balance.det_pl_ytd_cntrs_cd,293);
240: hr_utility.set_location(' ptd level ' || l_abr_balance.ptd_comp_lvl_fctr_id,293);
241: hr_utility.set_location(' acty_base_rt ' || l_abr_balance.acty_base_rt_id,293);

Line 238: hr_utility.set_location(' acty_base_rt ' || l_acty_base_rt_id,293);

234: fetch c_abr_prv into l_abr_prv;
235: close c_abr_prv;
236:
237: hr_utility.set_location(' result id ' || p_prtt_enrt_rslt_id ,293);
238: hr_utility.set_location(' acty_base_rt ' || l_acty_base_rt_id,293);
239: hr_utility.set_location(' ytd cntr cd ' || l_abr_balance.det_pl_ytd_cntrs_cd,293);
240: hr_utility.set_location(' ptd level ' || l_abr_balance.ptd_comp_lvl_fctr_id,293);
241: hr_utility.set_location(' acty_base_rt ' || l_abr_balance.acty_base_rt_id,293);
242: hr_utility.set_location(' p_effective_date ' || p_effective_date ,293);

Line 239: hr_utility.set_location(' ytd cntr cd ' || l_abr_balance.det_pl_ytd_cntrs_cd,293);

235: close c_abr_prv;
236:
237: hr_utility.set_location(' result id ' || p_prtt_enrt_rslt_id ,293);
238: hr_utility.set_location(' acty_base_rt ' || l_acty_base_rt_id,293);
239: hr_utility.set_location(' ytd cntr cd ' || l_abr_balance.det_pl_ytd_cntrs_cd,293);
240: hr_utility.set_location(' ptd level ' || l_abr_balance.ptd_comp_lvl_fctr_id,293);
241: hr_utility.set_location(' acty_base_rt ' || l_abr_balance.acty_base_rt_id,293);
242: hr_utility.set_location(' p_effective_date ' || p_effective_date ,293);
243: hr_utility.set_location(' yr_perd_id ' || l_get_epe.yr_perd_id ,293);

Line 240: hr_utility.set_location(' ptd level ' || l_abr_balance.ptd_comp_lvl_fctr_id,293);

236:
237: hr_utility.set_location(' result id ' || p_prtt_enrt_rslt_id ,293);
238: hr_utility.set_location(' acty_base_rt ' || l_acty_base_rt_id,293);
239: hr_utility.set_location(' ytd cntr cd ' || l_abr_balance.det_pl_ytd_cntrs_cd,293);
240: hr_utility.set_location(' ptd level ' || l_abr_balance.ptd_comp_lvl_fctr_id,293);
241: hr_utility.set_location(' acty_base_rt ' || l_abr_balance.acty_base_rt_id,293);
242: hr_utility.set_location(' p_effective_date ' || p_effective_date ,293);
243: hr_utility.set_location(' yr_perd_id ' || l_get_epe.yr_perd_id ,293);
244: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);

Line 241: hr_utility.set_location(' acty_base_rt ' || l_abr_balance.acty_base_rt_id,293);

237: hr_utility.set_location(' result id ' || p_prtt_enrt_rslt_id ,293);
238: hr_utility.set_location(' acty_base_rt ' || l_acty_base_rt_id,293);
239: hr_utility.set_location(' ytd cntr cd ' || l_abr_balance.det_pl_ytd_cntrs_cd,293);
240: hr_utility.set_location(' ptd level ' || l_abr_balance.ptd_comp_lvl_fctr_id,293);
241: hr_utility.set_location(' acty_base_rt ' || l_abr_balance.acty_base_rt_id,293);
242: hr_utility.set_location(' p_effective_date ' || p_effective_date ,293);
243: hr_utility.set_location(' yr_perd_id ' || l_get_epe.yr_perd_id ,293);
244: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);
245: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);

Line 242: hr_utility.set_location(' p_effective_date ' || p_effective_date ,293);

238: hr_utility.set_location(' acty_base_rt ' || l_acty_base_rt_id,293);
239: hr_utility.set_location(' ytd cntr cd ' || l_abr_balance.det_pl_ytd_cntrs_cd,293);
240: hr_utility.set_location(' ptd level ' || l_abr_balance.ptd_comp_lvl_fctr_id,293);
241: hr_utility.set_location(' acty_base_rt ' || l_abr_balance.acty_base_rt_id,293);
242: hr_utility.set_location(' p_effective_date ' || p_effective_date ,293);
243: hr_utility.set_location(' yr_perd_id ' || l_get_epe.yr_perd_id ,293);
244: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);
245: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);
246: hr_utility.set_location(' person_id ' || p_person_id ,293);

Line 243: hr_utility.set_location(' yr_perd_id ' || l_get_epe.yr_perd_id ,293);

239: hr_utility.set_location(' ytd cntr cd ' || l_abr_balance.det_pl_ytd_cntrs_cd,293);
240: hr_utility.set_location(' ptd level ' || l_abr_balance.ptd_comp_lvl_fctr_id,293);
241: hr_utility.set_location(' acty_base_rt ' || l_abr_balance.acty_base_rt_id,293);
242: hr_utility.set_location(' p_effective_date ' || p_effective_date ,293);
243: hr_utility.set_location(' yr_perd_id ' || l_get_epe.yr_perd_id ,293);
244: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);
245: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);
246: hr_utility.set_location(' person_id ' || p_person_id ,293);
247:

Line 244: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);

240: hr_utility.set_location(' ptd level ' || l_abr_balance.ptd_comp_lvl_fctr_id,293);
241: hr_utility.set_location(' acty_base_rt ' || l_abr_balance.acty_base_rt_id,293);
242: hr_utility.set_location(' p_effective_date ' || p_effective_date ,293);
243: hr_utility.set_location(' yr_perd_id ' || l_get_epe.yr_perd_id ,293);
244: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);
245: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);
246: hr_utility.set_location(' person_id ' || p_person_id ,293);
247:
248: if l_abr_prv.comp_src_cd is not null then

Line 245: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);

241: hr_utility.set_location(' acty_base_rt ' || l_abr_balance.acty_base_rt_id,293);
242: hr_utility.set_location(' p_effective_date ' || p_effective_date ,293);
243: hr_utility.set_location(' yr_perd_id ' || l_get_epe.yr_perd_id ,293);
244: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);
245: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);
246: hr_utility.set_location(' person_id ' || p_person_id ,293);
247:
248: if l_abr_prv.comp_src_cd is not null then
249: --

Line 246: hr_utility.set_location(' person_id ' || p_person_id ,293);

242: hr_utility.set_location(' p_effective_date ' || p_effective_date ,293);
243: hr_utility.set_location(' yr_perd_id ' || l_get_epe.yr_perd_id ,293);
244: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);
245: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);
246: hr_utility.set_location(' person_id ' || p_person_id ,293);
247:
248: if l_abr_prv.comp_src_cd is not null then
249: --
250: if l_abr_prv.comp_src_cd = 'BALTYP' THEN

Line 290: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);

286: ,l_assignment_id
287: ,least(p_effective_date,l_yr_end_date));
288: */
289: elsif l_abr_prv.comp_src_cd = 'BNFTBALTYP' then
290: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);
291: hr_utility.set_location(' person_id ' || p_person_id ,293);
292: open c_bnft_bal(l_abr_prv.bnfts_bal_id, p_person_id);
293: fetch c_bnft_bal into l_ptd_balance;
294: close c_bnft_bal;

Line 291: hr_utility.set_location(' person_id ' || p_person_id ,293);

287: ,least(p_effective_date,l_yr_end_date));
288: */
289: elsif l_abr_prv.comp_src_cd = 'BNFTBALTYP' then
290: hr_utility.set_location(' bnfts_bal_id ' || l_abr_prv.bnfts_bal_id ,293);
291: hr_utility.set_location(' person_id ' || p_person_id ,293);
292: open c_bnft_bal(l_abr_prv.bnfts_bal_id, p_person_id);
293: fetch c_bnft_bal into l_ptd_balance;
294: close c_bnft_bal;
295: end if;

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

299: fnd_message.set_token('STD_RATE_NAME ', l_abr_prv.name);
300: fnd_message.raise_error;
301:
302: end if;
303: hr_utility.set_location('Leaving:'||l_proc, 10);
304: hr_utility.set_location('ptd_balance '||l_ptd_balance , 293);
305: return nvl(l_ptd_balance,0);
306: end get_year_balance ;
307:

Line 304: hr_utility.set_location('ptd_balance '||l_ptd_balance , 293);

300: fnd_message.raise_error;
301:
302: end if;
303: hr_utility.set_location('Leaving:'||l_proc, 10);
304: hr_utility.set_location('ptd_balance '||l_ptd_balance , 293);
305: return nvl(l_ptd_balance,0);
306: end get_year_balance ;
307:
308: --

Line 382: hr_utility.set_location('Entering:'||l_proc,5);

378: l_proc varchar2(100) := ' plan_year_claim' ;
379:
380:
381: begin
382: hr_utility.set_location('Entering:'||l_proc,5);
383: /*
384: hr_utility.set_location('pl' ||p_pl_id ,5);
385: hr_utility.set_location('reimbq '||p_prtt_reimbmt_rqst_id ,5);
386: hr_utility.set_location('person '||p_person_id ,5);

Line 384: hr_utility.set_location('pl' ||p_pl_id ,5);

380:
381: begin
382: hr_utility.set_location('Entering:'||l_proc,5);
383: /*
384: hr_utility.set_location('pl' ||p_pl_id ,5);
385: hr_utility.set_location('reimbq '||p_prtt_reimbmt_rqst_id ,5);
386: hr_utility.set_location('person '||p_person_id ,5);
387: hr_utility.set_location('b group'||p_business_group_id ,5);
388: hr_utility.set_location('eff dt '||p_effective_date ,5);

Line 385: hr_utility.set_location('reimbq '||p_prtt_reimbmt_rqst_id ,5);

381: begin
382: hr_utility.set_location('Entering:'||l_proc,5);
383: /*
384: hr_utility.set_location('pl' ||p_pl_id ,5);
385: hr_utility.set_location('reimbq '||p_prtt_reimbmt_rqst_id ,5);
386: hr_utility.set_location('person '||p_person_id ,5);
387: hr_utility.set_location('b group'||p_business_group_id ,5);
388: hr_utility.set_location('eff dt '||p_effective_date ,5);
389: open c1;

Line 386: hr_utility.set_location('person '||p_person_id ,5);

382: hr_utility.set_location('Entering:'||l_proc,5);
383: /*
384: hr_utility.set_location('pl' ||p_pl_id ,5);
385: hr_utility.set_location('reimbq '||p_prtt_reimbmt_rqst_id ,5);
386: hr_utility.set_location('person '||p_person_id ,5);
387: hr_utility.set_location('b group'||p_business_group_id ,5);
388: hr_utility.set_location('eff dt '||p_effective_date ,5);
389: open c1;
390: fetch c1 into l_year_bal ;

Line 387: hr_utility.set_location('b group'||p_business_group_id ,5);

383: /*
384: hr_utility.set_location('pl' ||p_pl_id ,5);
385: hr_utility.set_location('reimbq '||p_prtt_reimbmt_rqst_id ,5);
386: hr_utility.set_location('person '||p_person_id ,5);
387: hr_utility.set_location('b group'||p_business_group_id ,5);
388: hr_utility.set_location('eff dt '||p_effective_date ,5);
389: open c1;
390: fetch c1 into l_year_bal ;
391: close c1 ;

Line 388: hr_utility.set_location('eff dt '||p_effective_date ,5);

384: hr_utility.set_location('pl' ||p_pl_id ,5);
385: hr_utility.set_location('reimbq '||p_prtt_reimbmt_rqst_id ,5);
386: hr_utility.set_location('person '||p_person_id ,5);
387: hr_utility.set_location('b group'||p_business_group_id ,5);
388: hr_utility.set_location('eff dt '||p_effective_date ,5);
389: open c1;
390: fetch c1 into l_year_bal ;
391: close c1 ;
392: */

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

417: --
418: p_amt_2 := p_amt_2 + nvl(l_year_bal,0);
419: --
420: end if;
421: hr_utility.set_location('Leaving:'||l_proc, 10);
422: end plan_year_claim ;
423:
424: --
425: -- ----------------------------------------------------------------------------

Line 467: hr_utility.set_location('Entering:'||l_proc,5);

463: where a.gd_or_svc_typ_id = p_gd_or_svc_typ_id;
464: --
465: Begin
466: --
467: hr_utility.set_location('Entering:'||l_proc,5);
468: --
469: l_api_updating := ben_prc_shd.api_updating
470: (p_prtt_reimbmt_rqst_id => p_prtt_reimbmt_rqst_id,
471: p_effective_date => p_effective_date,

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

496: close c1;
497: --
498: end if;
499: --
500: hr_utility.set_location('Leaving:'||l_proc,10);
501: --
502: End chk_gd_or_svc_typ_id;
503: --
504: -- ----------------------------------------------------------------------------

Line 555: hr_utility.set_location('Entering:'||l_proc,5);

551: where person_id = p_provider_person_id;
552: --
553: Begin
554: --
555: hr_utility.set_location('Entering:'||l_proc,5);
556: --
557: l_api_updating := ben_prc_shd.api_updating
558: (p_prtt_reimbmt_rqst_id => p_prtt_reimbmt_rqst_id,
559: p_effective_date => p_effective_date,

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

594: close c1;
595: --
596: end if;
597: --
598: hr_utility.set_location('Leaving:'||l_proc,10);
599: --
600: End chk_provider_person_id;
601: --
602: -- ----------------------------------------------------------------------------

Line 638: hr_utility.set_location('Entering:'||l_proc, 5);

634: l_api_updating boolean;
635: --
636: Begin
637: --
638: hr_utility.set_location('Entering:'||l_proc, 5);
639: --
640: l_api_updating := ben_prc_shd.api_updating
641: (p_prtt_reimbmt_rqst_id => p_prtt_reimbmt_rqst_id,
642: p_effective_date => p_effective_date,

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

666: end if;
667: --
668: end if;
669: --
670: hr_utility.set_location('Leaving:'||l_proc,10);
671: --
672: end chk_rcrrg_cd;
673: --
674: -- ----------------------------------------------------------------------------

Line 711: hr_utility.set_location('Entering:'||l_proc, 5);

707: l_api_updating boolean;
708: --
709: Begin
710: --
711: hr_utility.set_location('Entering:'||l_proc, 5);
712: --
713: l_api_updating := ben_prc_shd.api_updating
714: (p_prtt_reimbmt_rqst_id => p_prtt_reimbmt_rqst_id,
715: p_effective_date => p_effective_date,

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

739: end if;
740: --
741: end if;
742: --
743: hr_utility.set_location('Leaving:'||l_proc,10);
744: --
745: end chk_reimbmt_ctfn_typ_prvdd_cd;
746:
747:

Line 773: hr_utility.set_location('Entering:'||l_proc, 5);

769: l_ctfn_pending_flag varchar2(1) ;
770: l_dummy_var varchar2(1) ;
771: Begin
772:
773: hr_utility.set_location('Entering:'||l_proc, 5);
774:
775: if p_prtt_reimbmt_rqst_stat_cd in ('APPRVD','PDINFL','PRTLYPD') then
776:
777: -- Check the approved amount is entered

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

807:
808:
809: end if ;
810: --
811: hr_utility.set_location('Leaving:'||l_proc,10);
812: --
813:
814: end chk_prtt_reimbmt_stat_apprvd ;
815: --

Line 834: hr_utility.set_location('Entering:'||l_proc, 5);

830: l_api_updating boolean;
831: --
832: Begin
833: --
834: hr_utility.set_location('Entering:'||l_proc, 5);
835: --
836:
837: l_api_updating := ben_prc_shd.api_updating
838: (p_prtt_reimbmt_rqst_id => p_prtt_reimbmt_rqst_id,

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

864:
865: --
866: end if;
867: --
868: hr_utility.set_location('Leaving:'||l_proc,10);
869: --
870: end chk_stat_rsn_cd;
871:
872:

Line 889: hr_utility.set_location('Entering:'||l_proc, 5);

885: l_api_updating boolean;
886: --
887: Begin
888: --
889: hr_utility.set_location('Entering:'||l_proc, 5);
890: --
891:
892: l_api_updating := ben_prc_shd.api_updating
893: (p_prtt_reimbmt_rqst_id => p_prtt_reimbmt_rqst_id,

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

919:
920: --
921: end if;
922: --
923: hr_utility.set_location('Leaving:'||l_proc,10);
924: --
925: end chk_pymt_stat_rsn_cd;
926:
927:

Line 943: hr_utility.set_location('Entering:'||l_proc, 5);

939: l_api_updating boolean;
940: --
941: Begin
942: --
943: hr_utility.set_location('Entering:'||l_proc, 5);
944: --
945:
946: l_api_updating := ben_prc_shd.api_updating
947: (p_prtt_reimbmt_rqst_id => p_prtt_reimbmt_rqst_id,

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

973:
974: --
975: end if;
976: --
977: hr_utility.set_location('Leaving:'||l_proc,10);
978: --
979: end chk_pymt_stat_cd;
980:
981:

Line 1020: hr_utility.set_location('Entering:'||l_proc, 5);

1016: l_api_updating boolean;
1017: --
1018: Begin
1019: --
1020: hr_utility.set_location('Entering:'||l_proc, 5);
1021: --
1022:
1023: l_api_updating := ben_prc_shd.api_updating
1024: (p_prtt_reimbmt_rqst_id => p_prtt_reimbmt_rqst_id,

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

1084: end if;
1085: --
1086: end if;
1087: --
1088: hr_utility.set_location('Leaving:'||l_proc,10);
1089: --
1090: end chk_prtt_reimbmt_rqst_stat_cd;
1091: --
1092: -- ----------------------------------------------------------------------------

Line 1204: hr_utility.set_location('Entering:'||l_proc, 5);

1200: prev_yr_cvg number;
1201: --
1202: Begin
1203: --
1204: hr_utility.set_location('Entering:'||l_proc, 5);
1205: --
1206: l_api_updating := ben_prc_shd.api_updating
1207: (p_prtt_reimbmt_rqst_id => p_prtt_reimbmt_rqst_id,
1208: p_effective_date => p_effective_date,

Line 1212: hr_utility.set_location(' p_exp_incurd_dt ' || p_exp_incurd_dt ,192);

1208: p_effective_date => p_effective_date,
1209: p_object_version_number => p_object_version_number);
1210: --
1211:
1212: hr_utility.set_location(' p_exp_incurd_dt ' || p_exp_incurd_dt ,192);
1213:
1214: -- Check the UOM value
1215: if (l_api_updating
1216: and p_rqst_amt_uom

Line 1299: hr_utility.set_location('claim amount I year' || l_amt_1 , 293 );

1295: ,p_amt_1 => l_amt_1
1296: ,p_amt_2 => l_amt_2
1297: ,p_exp_incurd_dt => p_exp_incurd_dt );
1298:
1299: hr_utility.set_location('claim amount I year' || l_amt_1 , 293 );
1300: hr_utility.set_location('claim amount II year ' || l_amt_2 , 294 );
1301:
1302: if l_cmpr_clms_to_cvg_or_bal_cd in ('CVG', 'BAL') then
1303: -- if the expense is not in grace period

Line 1300: hr_utility.set_location('claim amount II year ' || l_amt_2 , 294 );

1296: ,p_amt_2 => l_amt_2
1297: ,p_exp_incurd_dt => p_exp_incurd_dt );
1298:
1299: hr_utility.set_location('claim amount I year' || l_amt_1 , 293 );
1300: hr_utility.set_location('claim amount II year ' || l_amt_2 , 294 );
1301:
1302: if l_cmpr_clms_to_cvg_or_bal_cd in ('CVG', 'BAL') then
1303: -- if the expense is not in grace period
1304: if p_popl_yr_perd_id_2 is null then

Line 1322: hr_utility.set_location ('Fully Paid'||p_aprvd_for_pymt_amt,11);

1318: End if ;
1319: --
1320: Else
1321: --
1322: hr_utility.set_location ('Fully Paid'||p_aprvd_for_pymt_amt,11);
1323: P_PYMT_STAT_CD := 'RMBFLPAID' ;
1324: p_pymt_amount := nvl(p_aprvd_for_pymt_amt,p_rqst_amt) ;
1325: p_amt_1 := p_pymt_amount;
1326: --

Line 1331: hr_utility.set_location ('Previos year coverage'||l_c2_rec.bnft_amt,12);

1327: end if;
1328: --if the expense in grace period
1329: else
1330: --
1331: hr_utility.set_location ('Previos year coverage'||l_c2_rec.bnft_amt,12);
1332: prev_yr_cvg := nvl(l_c2_rec.bnft_amt,0);
1333: open c2 (p_popl_yr_perd_id_2);
1334: fetch c2 into l_c2_rec;
1335: if c2%notfound then

Line 1347: hr_utility.set_location ('Previous fully used or no coverage',100);

1343: --
1344: if prev_yr_cvg <= l_amt_1 or prev_yr_cvg = 0 then
1345: -- the previous year benefit amount fully used so consider for this year
1346: -- there was no coverage in the previous year
1347: hr_utility.set_location ('Previous fully used or no coverage',100);
1348: hr_utility.set_location ('Benefit amont '||l_c2_rec.bnft_amt,101);
1349: hr_utility.set_location ('Approved amount '||p_aprvd_for_pymt_amt,102);
1350: hr_utility.set_location (l_amt_2 + nvl(p_aprvd_for_pymt_amt,p_rqst_amt),103);
1351: if nvl(l_c2_rec.bnft_amt,0) < (l_amt_2 + nvl(p_aprvd_for_pymt_amt,p_rqst_amt))

Line 1348: hr_utility.set_location ('Benefit amont '||l_c2_rec.bnft_amt,101);

1344: if prev_yr_cvg <= l_amt_1 or prev_yr_cvg = 0 then
1345: -- the previous year benefit amount fully used so consider for this year
1346: -- there was no coverage in the previous year
1347: hr_utility.set_location ('Previous fully used or no coverage',100);
1348: hr_utility.set_location ('Benefit amont '||l_c2_rec.bnft_amt,101);
1349: hr_utility.set_location ('Approved amount '||p_aprvd_for_pymt_amt,102);
1350: hr_utility.set_location (l_amt_2 + nvl(p_aprvd_for_pymt_amt,p_rqst_amt),103);
1351: if nvl(l_c2_rec.bnft_amt,0) < (l_amt_2 + nvl(p_aprvd_for_pymt_amt,p_rqst_amt))
1352: then

Line 1349: hr_utility.set_location ('Approved amount '||p_aprvd_for_pymt_amt,102);

1345: -- the previous year benefit amount fully used so consider for this year
1346: -- there was no coverage in the previous year
1347: hr_utility.set_location ('Previous fully used or no coverage',100);
1348: hr_utility.set_location ('Benefit amont '||l_c2_rec.bnft_amt,101);
1349: hr_utility.set_location ('Approved amount '||p_aprvd_for_pymt_amt,102);
1350: hr_utility.set_location (l_amt_2 + nvl(p_aprvd_for_pymt_amt,p_rqst_amt),103);
1351: if nvl(l_c2_rec.bnft_amt,0) < (l_amt_2 + nvl(p_aprvd_for_pymt_amt,p_rqst_amt))
1352: then
1353: -- chek there is no fund or partial fund

Line 1350: hr_utility.set_location (l_amt_2 + nvl(p_aprvd_for_pymt_amt,p_rqst_amt),103);

1346: -- there was no coverage in the previous year
1347: hr_utility.set_location ('Previous fully used or no coverage',100);
1348: hr_utility.set_location ('Benefit amont '||l_c2_rec.bnft_amt,101);
1349: hr_utility.set_location ('Approved amount '||p_aprvd_for_pymt_amt,102);
1350: hr_utility.set_location (l_amt_2 + nvl(p_aprvd_for_pymt_amt,p_rqst_amt),103);
1351: if nvl(l_c2_rec.bnft_amt,0) < (l_amt_2 + nvl(p_aprvd_for_pymt_amt,p_rqst_amt))
1352: then
1353: -- chek there is no fund or partial fund
1354: hr_utility.set_location ('Partial payment',103);

Line 1354: hr_utility.set_location ('Partial payment',103);

1350: hr_utility.set_location (l_amt_2 + nvl(p_aprvd_for_pymt_amt,p_rqst_amt),103);
1351: if nvl(l_c2_rec.bnft_amt,0) < (l_amt_2 + nvl(p_aprvd_for_pymt_amt,p_rqst_amt))
1352: then
1353: -- chek there is no fund or partial fund
1354: hr_utility.set_location ('Partial payment',103);
1355: if (nvl(l_c2_rec.bnft_amt,0) - l_amt_2 ) <= 0 then
1356: p_pymt_amount := null ;
1357: p_aprvd_for_pymt_amt := null ;
1358: p_prtt_reimbmt_rqst_stat_cd := 'DND' ;

Line 1371: hr_utility.set_location ('Fully Paid', 105);

1367: End if ;
1368: --
1369: else
1370: --
1371: hr_utility.set_location ('Fully Paid', 105);
1372: P_PYMT_STAT_CD := 'RMBFLPAID' ;
1373: p_pymt_amount := nvl(p_aprvd_for_pymt_amt,p_rqst_amt) ;
1374: p_amt_2 := p_pymt_amount;
1375: --

Line 1380: hr_utility.set_location ('Balance Available prev yr',13);

1376: end if;
1377: --
1378: else -- balance available in previous year
1379: --
1380: hr_utility.set_location ('Balance Available prev yr',13);
1381: if prev_yr_cvg >= l_amt_1 + nvl(p_aprvd_for_pymt_amt,p_rqst_amt) then
1382: --
1383: hr_utility.set_location ('previous year fully paid',14);
1384: P_PYMT_STAT_CD := 'RMBFLPAID' ;

Line 1383: hr_utility.set_location ('previous year fully paid',14);

1379: --
1380: hr_utility.set_location ('Balance Available prev yr',13);
1381: if prev_yr_cvg >= l_amt_1 + nvl(p_aprvd_for_pymt_amt,p_rqst_amt) then
1382: --
1383: hr_utility.set_location ('previous year fully paid',14);
1384: P_PYMT_STAT_CD := 'RMBFLPAID' ;
1385: p_pymt_amount := nvl(p_aprvd_for_pymt_amt,p_rqst_amt) ;
1386: p_amt_1 := p_pymt_amount;
1387: --

Line 1391: hr_utility.set_location ('Claim falls on two year',15);

1387: --
1388: elsif (prev_yr_cvg + nvl(l_c2_rec.bnft_amt,0)) >= (l_amt_1 + l_amt_2 +
1389: nvl(p_aprvd_for_pymt_amt,p_rqst_amt)) then
1390: --
1391: hr_utility.set_location ('Claim falls on two year',15);
1392: P_PYMT_STAT_CD := 'RMBFLPAID' ;
1393: p_pymt_amount := nvl(p_aprvd_for_pymt_amt,p_rqst_amt) ;
1394: p_amt_1 := prev_yr_cvg - l_amt_1;
1395: p_amt_2 := p_pymt_amount - p_amt_1;

Line 1398: hr_utility.set_location ('No current year coverage',16);

1394: p_amt_1 := prev_yr_cvg - l_amt_1;
1395: p_amt_2 := p_pymt_amount - p_amt_1;
1396: elsif nvl(l_c2_rec.bnft_amt,0) = 0 then --no current coverage
1397: --
1398: hr_utility.set_location ('No current year coverage',16);
1399: p_pymt_amount := prev_yr_cvg - l_amt_1;
1400: p_amt_1 := p_pymt_amount;
1401: P_PYMT_STAT_CD := 'RMBPRTPAID' ;
1402: p_stat_rsn_cd := 'RMBINCVG' ;

Line 1408: hr_utility.set_location ('Partially paid for two years',17);

1404: --
1405: elsif (prev_yr_cvg + nvl(l_c2_rec.bnft_amt,0)) < (l_amt_1 + l_amt_2 +
1406: nvl(p_aprvd_for_pymt_amt,p_rqst_amt)) then
1407: --
1408: hr_utility.set_location ('Partially paid for two years',17);
1409: p_amt_1 := prev_yr_cvg - l_amt_1;
1410: p_amt_2 := nvl(l_c2_rec.bnft_amt,0) - l_amt_2;
1411: p_pymt_amount := p_amt_1 + p_amt_2;
1412: P_PYMT_STAT_CD := 'RMBPRTPAID' ;

Line 1467: hr_utility.set_location(' pyment amount ' || p_pymt_amount ,110);

1463: p_pymt_amount := nvl(p_aprvd_for_pymt_amt,p_rqst_amt) ;
1464: p_amt_1 := p_pymt_amount;
1465: end if;
1466: end if; */
1467: hr_utility.set_location(' pyment amount ' || p_pymt_amount ,110);
1468:
1469: hr_utility.set_location('Leaving:'||l_proc,10);
1470: end chk_pl_id_rqst_amt_and_uom;
1471:

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

1465: end if;
1466: end if; */
1467: hr_utility.set_location(' pyment amount ' || p_pymt_amount ,110);
1468:
1469: hr_utility.set_location('Leaving:'||l_proc,10);
1470: end chk_pl_id_rqst_amt_and_uom;
1471:
1472: ------------------------------------------------------------------------------
1473: -- |------< chk_remb_status >-----|

Line 1481: hr_utility.set_location('Entering:'||l_proc, 5);

1477: p_prtt_reimbmt_rqst_stat_cd in varchar2
1478: )is
1479: l_proc varchar2(72) := g_package||' chk_remb_status';
1480: begin
1481: hr_utility.set_location('Entering:'||l_proc, 5);
1482:
1483: if p_prtt_reimbmt_rqst_stat_cd in ('APPRVD','PDINFL','PRTLYPD') then
1484: fnd_message.set_name('BEN','BEN_92705_REIMB_RQST_APPROVD');
1485: fnd_message.raise_error;

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

1488: fnd_message.set_name('BEN','BEN_92708_REIMB_RQST_VOIDED');
1489: fnd_message.raise_error;
1490: end if ;
1491:
1492: hr_utility.set_location('Leaving:'||l_proc,10);
1493: end chk_remb_status;
1494:
1495:
1496: --

Line 1592: hr_utility.set_location('Entering:'||l_proc,5);

1588: l_acty_base_rt_id number ;
1589: l_rt_strt_dt date ;
1590: begin
1591:
1592: hr_utility.set_location('Entering:'||l_proc,5);
1593: -- when future date tracked row in available for the reimbmt req
1594: /* thery may be status cahnges though there is futer dated entry there
1595: hr_utility.set_location('checking for futrue prc:'||l_proc,5);
1596: open c_prc ;

Line 1595: hr_utility.set_location('checking for futrue prc:'||l_proc,5);

1591:
1592: hr_utility.set_location('Entering:'||l_proc,5);
1593: -- when future date tracked row in available for the reimbmt req
1594: /* thery may be status cahnges though there is futer dated entry there
1595: hr_utility.set_location('checking for futrue prc:'||l_proc,5);
1596: open c_prc ;
1597: fetch c_prc into l_dummy_var ;
1598: if c_prc%found then
1599: close c_prc ;

Line 1606: hr_utility.set_location('checking for future election:'||l_proc,5);

1602: end if ;
1603: close c_prc ;
1604: */
1605: -- when the future date tracked election is avaialble
1606: hr_utility.set_location('checking for future election:'||l_proc,5);
1607: /*
1608: open c_per ;
1609: fetch c_per into l_dummy_var ;
1610: if c_per%found then

Line 1628: hr_utility.set_location('checking for runresult:'||l_proc,5);

1624: fetch c_prv into l_acty_base_rt_id,l_rt_strt_dt ;
1625: close c_prv ;
1626:
1627:
1628: hr_utility.set_location('checking for runresult:'||l_proc,5);
1629: g_max_end_date := null;
1630: open c_get_end_dt(p_payroll_id => l_payroll_id
1631: ,p_acty_base_rt_id => l_acty_base_rt_id
1632: ,p_business_group_id => p_business_group_id

Line 1645: hr_utility.set_location('Leaving:' ||l_proc,5);

1641: fnd_message.set_token('PARMB',g_max_end_date);
1642: fnd_message.raise_error;
1643:
1644: end if;
1645: hr_utility.set_location('Leaving:' ||l_proc,5);
1646: end chk_future_dated ;
1647:
1648: --
1649:

Line 1858: hr_utility.set_location('Entering:'||l_proc,5);

1854: --
1855: --
1856: Begin
1857: --
1858: hr_utility.set_location('Entering:'||l_proc,5);
1859: --
1860: l_api_updating := ben_prc_shd.api_updating
1861: (p_prtt_reimbmt_rqst_id => p_prtt_reimbmt_rqst_id,
1862: p_effective_date => p_effective_date,

Line 1878: hr_utility.set_location('validating'||l_proc,5);

1874: nvl(ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd ,'-1')
1875: or nvl(p_pl_id,-1) <> nvl(ben_prc_shd.g_old_rec.pl_id,-1) ))
1876: or not l_api_updating) then
1877:
1878: hr_utility.set_location('validating'||l_proc,5);
1879:
1880:
1881: /* ************** bug 2272862
1882: --

Line 1899: hr_utility.set_location( ' from st dt ' || i.enrt_cvg_strt_dt, 90) ;

1895: **************** */
1896:
1897: for i in c1 Loop
1898:
1899: hr_utility.set_location( ' from st dt ' || i.enrt_cvg_strt_dt, 90) ;
1900: hr_utility.set_location( ' from en dt ' || i.enrt_cvg_thru_dt, 90) ;
1901: if l_enrt_cvg_strt_dt is null then
1902: l_enrt_cvg_strt_dt := i.enrt_cvg_strt_dt ;
1903: else

Line 1900: hr_utility.set_location( ' from en dt ' || i.enrt_cvg_thru_dt, 90) ;

1896:
1897: for i in c1 Loop
1898:
1899: hr_utility.set_location( ' from st dt ' || i.enrt_cvg_strt_dt, 90) ;
1900: hr_utility.set_location( ' from en dt ' || i.enrt_cvg_thru_dt, 90) ;
1901: if l_enrt_cvg_strt_dt is null then
1902: l_enrt_cvg_strt_dt := i.enrt_cvg_strt_dt ;
1903: else
1904: l_enrt_cvg_strt_dt := least(i.enrt_cvg_strt_dt,l_enrt_cvg_strt_dt) ;

Line 1913: hr_utility.set_location( ' from st dt ' || l_enrt_cvg_strt_dt, 99) ;

1909: else
1910: l_enrt_cvg_thru_dt := greatest(i.enrt_cvg_thru_dt,l_enrt_cvg_thru_dt) ;
1911: end if ;
1912:
1913: hr_utility.set_location( ' from st dt ' || l_enrt_cvg_strt_dt, 99) ;
1914: hr_utility.set_location( ' from en dt ' || l_enrt_cvg_thru_dt, 99) ;
1915: l_yrp_start_date := i.start_date ;
1916: l_yrp_end_date := i.end_date ;
1917: l_acpt_clm_rqsts_thru_dt := i.acpt_clm_rqsts_thru_dt ;

Line 1914: hr_utility.set_location( ' from en dt ' || l_enrt_cvg_thru_dt, 99) ;

1910: l_enrt_cvg_thru_dt := greatest(i.enrt_cvg_thru_dt,l_enrt_cvg_thru_dt) ;
1911: end if ;
1912:
1913: hr_utility.set_location( ' from st dt ' || l_enrt_cvg_strt_dt, 99) ;
1914: hr_utility.set_location( ' from en dt ' || l_enrt_cvg_thru_dt, 99) ;
1915: l_yrp_start_date := i.start_date ;
1916: l_yrp_end_date := i.end_date ;
1917: l_acpt_clm_rqsts_thru_dt := i.acpt_clm_rqsts_thru_dt ;
1918: l_py_clms_thru_dt := i.PY_CLMS_THRU_DT ;

Line 1949: hr_utility.set_location(' p_effective_date ' || p_effective_date , 98 );

1945: fnd_message.raise_error;
1946: --
1947: end if;
1948: --
1949: hr_utility.set_location(' p_effective_date ' || p_effective_date , 98 );
1950: hr_utility.set_location(' l_acpt_clm_rqsts_thru_dt ' || l_acpt_clm_rqsts_thru_dt , 98 );
1951: if p_effective_date > l_acpt_clm_rqsts_thru_dt then
1952: --
1953: -- No claim to be accepted beyond acpt_clm_rqsts_thru_dt.

Line 1950: hr_utility.set_location(' l_acpt_clm_rqsts_thru_dt ' || l_acpt_clm_rqsts_thru_dt , 98 );

1946: --
1947: end if;
1948: --
1949: hr_utility.set_location(' p_effective_date ' || p_effective_date , 98 );
1950: hr_utility.set_location(' l_acpt_clm_rqsts_thru_dt ' || l_acpt_clm_rqsts_thru_dt , 98 );
1951: if p_effective_date > l_acpt_clm_rqsts_thru_dt then
1952: --
1953: -- No claim to be accepted beyond acpt_clm_rqsts_thru_dt.
1954: -- If acpt_clm_rqsts_thru_dt not specified, use enrt_cvg_thru_dt

Line 1964: hr_utility.set_location(' p_incrd_from_dt ' || p_incrd_from_dt , 98 );

1960: fnd_message.raise_error;
1961: --
1962: end if;
1963: --
1964: hr_utility.set_location(' p_incrd_from_dt ' || p_incrd_from_dt , 98 );
1965: hr_utility.set_location(' p_incrd_to_dt ' || p_incrd_to_dt , 98 );
1966: hr_utility.set_location(' l_enrt_cvg_strt_dt ' || l_enrt_cvg_strt_dt , 98 );
1967: hr_utility.set_location(' l_enrt_cvg_thru_dt ' || l_enrt_cvg_thru_dt , 98 );
1968: hr_utility.set_location(' l_yrp_start_date ' || l_yrp_start_date , 98 );

Line 1965: hr_utility.set_location(' p_incrd_to_dt ' || p_incrd_to_dt , 98 );

1961: --
1962: end if;
1963: --
1964: hr_utility.set_location(' p_incrd_from_dt ' || p_incrd_from_dt , 98 );
1965: hr_utility.set_location(' p_incrd_to_dt ' || p_incrd_to_dt , 98 );
1966: hr_utility.set_location(' l_enrt_cvg_strt_dt ' || l_enrt_cvg_strt_dt , 98 );
1967: hr_utility.set_location(' l_enrt_cvg_thru_dt ' || l_enrt_cvg_thru_dt , 98 );
1968: hr_utility.set_location(' l_yrp_start_date ' || l_yrp_start_date , 98 );
1969: hr_utility.set_location(' l_yrp_end_date ' || l_yrp_end_date , 98 );

Line 1966: hr_utility.set_location(' l_enrt_cvg_strt_dt ' || l_enrt_cvg_strt_dt , 98 );

1962: end if;
1963: --
1964: hr_utility.set_location(' p_incrd_from_dt ' || p_incrd_from_dt , 98 );
1965: hr_utility.set_location(' p_incrd_to_dt ' || p_incrd_to_dt , 98 );
1966: hr_utility.set_location(' l_enrt_cvg_strt_dt ' || l_enrt_cvg_strt_dt , 98 );
1967: hr_utility.set_location(' l_enrt_cvg_thru_dt ' || l_enrt_cvg_thru_dt , 98 );
1968: hr_utility.set_location(' l_yrp_start_date ' || l_yrp_start_date , 98 );
1969: hr_utility.set_location(' l_yrp_end_date ' || l_yrp_end_date , 98 );
1970: if not (p_incrd_from_dt >= l_enrt_cvg_strt_dt

Line 1967: hr_utility.set_location(' l_enrt_cvg_thru_dt ' || l_enrt_cvg_thru_dt , 98 );

1963: --
1964: hr_utility.set_location(' p_incrd_from_dt ' || p_incrd_from_dt , 98 );
1965: hr_utility.set_location(' p_incrd_to_dt ' || p_incrd_to_dt , 98 );
1966: hr_utility.set_location(' l_enrt_cvg_strt_dt ' || l_enrt_cvg_strt_dt , 98 );
1967: hr_utility.set_location(' l_enrt_cvg_thru_dt ' || l_enrt_cvg_thru_dt , 98 );
1968: hr_utility.set_location(' l_yrp_start_date ' || l_yrp_start_date , 98 );
1969: hr_utility.set_location(' l_yrp_end_date ' || l_yrp_end_date , 98 );
1970: if not (p_incrd_from_dt >= l_enrt_cvg_strt_dt
1971: -- if a person last coverage beore the yr end allow him up to the year end

Line 1968: hr_utility.set_location(' l_yrp_start_date ' || l_yrp_start_date , 98 );

1964: hr_utility.set_location(' p_incrd_from_dt ' || p_incrd_from_dt , 98 );
1965: hr_utility.set_location(' p_incrd_to_dt ' || p_incrd_to_dt , 98 );
1966: hr_utility.set_location(' l_enrt_cvg_strt_dt ' || l_enrt_cvg_strt_dt , 98 );
1967: hr_utility.set_location(' l_enrt_cvg_thru_dt ' || l_enrt_cvg_thru_dt , 98 );
1968: hr_utility.set_location(' l_yrp_start_date ' || l_yrp_start_date , 98 );
1969: hr_utility.set_location(' l_yrp_end_date ' || l_yrp_end_date , 98 );
1970: if not (p_incrd_from_dt >= l_enrt_cvg_strt_dt
1971: -- if a person last coverage beore the yr end allow him up to the year end
1972: and p_incrd_to_dt <= greatest(l_enrt_cvg_thru_dt,l_yrp_end_date)

Line 1969: hr_utility.set_location(' l_yrp_end_date ' || l_yrp_end_date , 98 );

1965: hr_utility.set_location(' p_incrd_to_dt ' || p_incrd_to_dt , 98 );
1966: hr_utility.set_location(' l_enrt_cvg_strt_dt ' || l_enrt_cvg_strt_dt , 98 );
1967: hr_utility.set_location(' l_enrt_cvg_thru_dt ' || l_enrt_cvg_thru_dt , 98 );
1968: hr_utility.set_location(' l_yrp_start_date ' || l_yrp_start_date , 98 );
1969: hr_utility.set_location(' l_yrp_end_date ' || l_yrp_end_date , 98 );
1970: if not (p_incrd_from_dt >= l_enrt_cvg_strt_dt
1971: -- if a person last coverage beore the yr end allow him up to the year end
1972: and p_incrd_to_dt <= greatest(l_enrt_cvg_thru_dt,l_yrp_end_date)
1973: and p_incrd_from_dt <= p_incrd_to_dt

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

2022: */
2023: end if;
2024: end if;
2025: --
2026: hr_utility.set_location('Leaving:'||l_proc,10);
2027: --
2028: End chk_incrd_dt;
2029: --
2030: --

Line 2071: hr_utility.set_location('Entering:'||l_proc, 5);

2067: l_integrity_error Exception;
2068: l_table_name all_tables.table_name%TYPE;
2069: --
2070: Begin
2071: hr_utility.set_location('Entering:'||l_proc, 5);
2072: --
2073: -- Ensure that the p_datetrack_mode argument is not null
2074: --
2075: hr_api.mandatory_arg_error

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

2106: End If;
2107: --
2108: End If;
2109: --
2110: hr_utility.set_location(' Leaving:'||l_proc, 10);
2111: Exception
2112: When l_integrity_error Then
2113: --
2114: -- A referential integrity check was violated therefore

Line 2143: hr_utility.set_location('Entering:'||l_proc,5);

2139: from ben_prtt_rt_val a
2140: where a.prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id;
2141:
2142: Begin
2143: hr_utility.set_location('Entering:'||l_proc,5);
2144: --
2145: -- check if child rows exists in ben_prtt_rt_val.
2146: --
2147: open c1;

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

2156: Else
2157: close c1;
2158: Return(false);
2159: end if;
2160: hr_utility.set_location('Leaving:'||l_proc,10);
2161: End prv_rows_exists;
2162:
2163: --
2164: -- ----------------------------------------------------------------------------

Line 2210: hr_utility.set_location('Entering:'||l_proc, 5);

2206: l_rows_exist Exception;
2207: l_table_name all_tables.table_name%TYPE;
2208: --
2209: Begin
2210: hr_utility.set_location('Entering:'||l_proc, 5);
2211: --
2212: -- Ensure that the p_datetrack_mode argument is not null
2213: --
2214: hr_api.mandatory_arg_error

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

2245: Raise l_rows_exist;
2246: End If;
2247: End If;
2248: --
2249: hr_utility.set_location(' Leaving:'||l_proc, 10);
2250: Exception
2251: When l_rows_exist Then
2252: --
2253: -- A referential integrity check was violated therefore we must error

Line 2279: hr_utility.set_location('Entering:'||l_proc, 5);

2275: --
2276: l_proc varchar2(72) := g_package||'insert_validate';
2277: --
2278: Begin
2279: hr_utility.set_location('Entering:'||l_proc, 5);
2280: --
2281: -- Call all supporting business operations
2282: --
2283: --

Line 2387: hr_utility.set_location('after stat check ' || p_rec.prtt_reimbmt_rqst_stat_cd, 110);

2383: p_popl_yr_perd_id_2 => p_rec.popl_yr_perd_id_2,
2384: p_amt_1 => p_rec.amt_year1,
2385: p_amt_2 => p_rec.amt_year2 );
2386:
2387: hr_utility.set_location('after stat check ' || p_rec.prtt_reimbmt_rqst_stat_cd, 110);
2388: hr_utility.set_location('after stat check ' || p_rec.stat_rsn_cd, 110);
2389: hr_utility.set_location('after stat check ' || p_rec.Pymt_stat_cd, 110);
2390: hr_utility.set_location('after stat check ' || p_rec.pymt_stat_rsn_cd, 110);
2391:

Line 2388: hr_utility.set_location('after stat check ' || p_rec.stat_rsn_cd, 110);

2384: p_amt_1 => p_rec.amt_year1,
2385: p_amt_2 => p_rec.amt_year2 );
2386:
2387: hr_utility.set_location('after stat check ' || p_rec.prtt_reimbmt_rqst_stat_cd, 110);
2388: hr_utility.set_location('after stat check ' || p_rec.stat_rsn_cd, 110);
2389: hr_utility.set_location('after stat check ' || p_rec.Pymt_stat_cd, 110);
2390: hr_utility.set_location('after stat check ' || p_rec.pymt_stat_rsn_cd, 110);
2391:
2392:

Line 2389: hr_utility.set_location('after stat check ' || p_rec.Pymt_stat_cd, 110);

2385: p_amt_2 => p_rec.amt_year2 );
2386:
2387: hr_utility.set_location('after stat check ' || p_rec.prtt_reimbmt_rqst_stat_cd, 110);
2388: hr_utility.set_location('after stat check ' || p_rec.stat_rsn_cd, 110);
2389: hr_utility.set_location('after stat check ' || p_rec.Pymt_stat_cd, 110);
2390: hr_utility.set_location('after stat check ' || p_rec.pymt_stat_rsn_cd, 110);
2391:
2392:
2393: --

Line 2390: hr_utility.set_location('after stat check ' || p_rec.pymt_stat_rsn_cd, 110);

2386:
2387: hr_utility.set_location('after stat check ' || p_rec.prtt_reimbmt_rqst_stat_cd, 110);
2388: hr_utility.set_location('after stat check ' || p_rec.stat_rsn_cd, 110);
2389: hr_utility.set_location('after stat check ' || p_rec.Pymt_stat_cd, 110);
2390: hr_utility.set_location('after stat check ' || p_rec.pymt_stat_rsn_cd, 110);
2391:
2392:
2393: --
2394: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

2390: hr_utility.set_location('after stat check ' || p_rec.pymt_stat_rsn_cd, 110);
2391:
2392:
2393: --
2394: hr_utility.set_location(' Leaving:'||l_proc, 10);
2395: End insert_validate;
2396: --
2397: -- ----------------------------------------------------------------------------
2398: -- |---------------------------< update_validate >----------------------------|

Line 2410: hr_utility.set_location('Entering:'||l_proc, 5);

2406: --
2407: l_proc varchar2(72) := g_package||'update_validate';
2408: --
2409: Begin
2410: hr_utility.set_location('Entering:'||l_proc, 5);
2411: --
2412: -- Call all supporting business operations
2413: --
2414: --

Line 2486: hr_utility.set_location('after date check ' || p_rec.stat_rsn_cd, 110);

2482: p_stat_rsn_cd => p_rec.stat_rsn_cd,
2483: p_exp_incurd_dt => p_rec.exp_incurd_dt -- 2272862
2484: );
2485:
2486: hr_utility.set_location('after date check ' || p_rec.stat_rsn_cd, 110);
2487:
2488: --
2489: chk_pl_id_rqst_amt_and_uom
2490: (p_prtt_reimbmt_rqst_id => p_rec.prtt_reimbmt_rqst_id,

Line 2512: hr_utility.set_location('after uom check ' || p_rec.stat_rsn_cd, 110);

2508: p_amt_1 => p_rec.amt_year1,
2509: p_amt_2 => p_rec.amt_year2 );
2510:
2511:
2512: hr_utility.set_location('after uom check ' || p_rec.stat_rsn_cd, 110);
2513: chk_prtt_reimbmt_stat_apprvd
2514: (p_prtt_reimbmt_rqst_id => p_rec.prtt_reimbmt_rqst_id,
2515: p_aprvd_for_pymt_amt => p_rec.aprvd_for_pymt_amt ,
2516: p_prtt_reimbmt_rqst_stat_cd => p_rec.prtt_reimbmt_rqst_stat_cd ,

Line 2522: hr_utility.set_location('after stat check ' || p_rec.prtt_reimbmt_rqst_stat_cd, 110);

2518: p_effective_date => p_effective_date
2519: ) ;
2520:
2521:
2522: hr_utility.set_location('after stat check ' || p_rec.prtt_reimbmt_rqst_stat_cd, 110);
2523: hr_utility.set_location('after sta check ' || p_rec.stat_rsn_cd, 110);
2524: hr_utility.set_location('after stat check ' || p_rec.Pymt_stat_cd, 110);
2525: hr_utility.set_location('after stat check ' || p_rec.pymt_stat_rsn_cd, 110);
2526:

Line 2523: hr_utility.set_location('after sta check ' || p_rec.stat_rsn_cd, 110);

2519: ) ;
2520:
2521:
2522: hr_utility.set_location('after stat check ' || p_rec.prtt_reimbmt_rqst_stat_cd, 110);
2523: hr_utility.set_location('after sta check ' || p_rec.stat_rsn_cd, 110);
2524: hr_utility.set_location('after stat check ' || p_rec.Pymt_stat_cd, 110);
2525: hr_utility.set_location('after stat check ' || p_rec.pymt_stat_rsn_cd, 110);
2526:
2527:

Line 2524: hr_utility.set_location('after stat check ' || p_rec.Pymt_stat_cd, 110);

2520:
2521:
2522: hr_utility.set_location('after stat check ' || p_rec.prtt_reimbmt_rqst_stat_cd, 110);
2523: hr_utility.set_location('after sta check ' || p_rec.stat_rsn_cd, 110);
2524: hr_utility.set_location('after stat check ' || p_rec.Pymt_stat_cd, 110);
2525: hr_utility.set_location('after stat check ' || p_rec.pymt_stat_rsn_cd, 110);
2526:
2527:
2528:

Line 2525: hr_utility.set_location('after stat check ' || p_rec.pymt_stat_rsn_cd, 110);

2521:
2522: hr_utility.set_location('after stat check ' || p_rec.prtt_reimbmt_rqst_stat_cd, 110);
2523: hr_utility.set_location('after sta check ' || p_rec.stat_rsn_cd, 110);
2524: hr_utility.set_location('after stat check ' || p_rec.Pymt_stat_cd, 110);
2525: hr_utility.set_location('after stat check ' || p_rec.pymt_stat_rsn_cd, 110);
2526:
2527:
2528:
2529:

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

2542: p_datetrack_mode => p_datetrack_mode,
2543: p_validation_start_date => p_validation_start_date,
2544: p_validation_end_date => p_validation_end_date);
2545: --
2546: hr_utility.set_location(' Leaving:'||l_proc, 10);
2547: End update_validate;
2548: --
2549: -- ----------------------------------------------------------------------------
2550: -- |---------------------------< delete_validate >----------------------------|

Line 2562: hr_utility.set_location('Entering:'||l_proc, 5);

2558: --
2559: l_proc varchar2(72) := g_package||'delete_validate';
2560: --
2561: Begin
2562: hr_utility.set_location('Entering:'||l_proc, 5);
2563: --
2564: -- Call all supporting business operations
2565: --
2566: chk_remb_status (

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

2579: p_validation_start_date => p_validation_start_date,
2580: p_validation_end_date => p_validation_end_date,
2581: p_prtt_reimbmt_rqst_id => p_rec.prtt_reimbmt_rqst_id);
2582: --
2583: hr_utility.set_location(' Leaving:'||l_proc, 10);
2584: End delete_validate;
2585: --
2586: --
2587: -- ---------------------------------------------------------------------------

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

2606: l_proc varchar2(72) := g_package||'return_legislation_code';
2607: --
2608: begin
2609: --
2610: hr_utility.set_location('Entering:'|| l_proc, 10);
2611: --
2612: -- Ensure that all the mandatory parameter are not null
2613: --
2614: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 2635: hr_utility.set_location(' Leaving:'|| l_proc, 20);

2631: end if;
2632: --
2633: close csr_leg_code;
2634: --
2635: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2636: --
2637: return l_legislation_code;
2638: --
2639: end return_legislation_code;