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

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

36: l_proc varchar2(72) := g_package||'set_security_group_id';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error

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

67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------

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

96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error

Line 118: hr_utility.set_location(l_proc, 20);

114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := ben_pry_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.

Line 135: hr_utility.set_location(l_proc,30);

131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --

Line 144: hr_utility.set_location(' Leaving:'|| l_proc, 40);

140: close csr_leg_code;
141: ben_pry_bus.g_prtt_rmt_aprvd_fr_pymt_id:= p_prtt_rmt_aprvd_fr_pymt_id;
142: ben_pry_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147:
148:

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

258: l_amt_year2 number;
259: l_rqst_amt_1 number;
260:
261: begin
262: hr_utility.set_location('Entering:'||l_proc,10);
263: --
264: open c_prc ;
265: fetch c_prc into l_rqst_amt,l_popl_yr_perd_id_1,l_popl_yr_perd_id_2,
266: l_amt_year1,l_amt_year2 ;

Line 273: hr_utility.set_location( 'reimburs ' || p_rec.prtt_reimbmt_rqst_id , 110);

269: open c_pry ;
270: fetch c_pry into l_total_pymt_amt ;
271: close c_pry ;
272:
273: hr_utility.set_location( 'reimburs ' || p_rec.prtt_reimbmt_rqst_id , 110);
274: hr_utility.set_location( 'payment ' || p_rec.prtt_rmt_aprvd_fr_pymt_id , 110);
275: hr_utility.set_location( 'rqst amount ' || l_rqst_amt , 110);
276: hr_utility.set_location( 'to payment amount ' || l_total_pymt_amt , 110);
277: hr_utility.set_location( 'payment amount ' || p_rec.aprvd_fr_pymt_amt , 110);

Line 274: hr_utility.set_location( 'payment ' || p_rec.prtt_rmt_aprvd_fr_pymt_id , 110);

270: fetch c_pry into l_total_pymt_amt ;
271: close c_pry ;
272:
273: hr_utility.set_location( 'reimburs ' || p_rec.prtt_reimbmt_rqst_id , 110);
274: hr_utility.set_location( 'payment ' || p_rec.prtt_rmt_aprvd_fr_pymt_id , 110);
275: hr_utility.set_location( 'rqst amount ' || l_rqst_amt , 110);
276: hr_utility.set_location( 'to payment amount ' || l_total_pymt_amt , 110);
277: hr_utility.set_location( 'payment amount ' || p_rec.aprvd_fr_pymt_amt , 110);
278:

Line 275: hr_utility.set_location( 'rqst amount ' || l_rqst_amt , 110);

271: close c_pry ;
272:
273: hr_utility.set_location( 'reimburs ' || p_rec.prtt_reimbmt_rqst_id , 110);
274: hr_utility.set_location( 'payment ' || p_rec.prtt_rmt_aprvd_fr_pymt_id , 110);
275: hr_utility.set_location( 'rqst amount ' || l_rqst_amt , 110);
276: hr_utility.set_location( 'to payment amount ' || l_total_pymt_amt , 110);
277: hr_utility.set_location( 'payment amount ' || p_rec.aprvd_fr_pymt_amt , 110);
278:
279:

Line 276: hr_utility.set_location( 'to payment amount ' || l_total_pymt_amt , 110);

272:
273: hr_utility.set_location( 'reimburs ' || p_rec.prtt_reimbmt_rqst_id , 110);
274: hr_utility.set_location( 'payment ' || p_rec.prtt_rmt_aprvd_fr_pymt_id , 110);
275: hr_utility.set_location( 'rqst amount ' || l_rqst_amt , 110);
276: hr_utility.set_location( 'to payment amount ' || l_total_pymt_amt , 110);
277: hr_utility.set_location( 'payment amount ' || p_rec.aprvd_fr_pymt_amt , 110);
278:
279:
280: --- whne the total submited more than requst amounnt throw errors

Line 277: hr_utility.set_location( 'payment amount ' || p_rec.aprvd_fr_pymt_amt , 110);

273: hr_utility.set_location( 'reimburs ' || p_rec.prtt_reimbmt_rqst_id , 110);
274: hr_utility.set_location( 'payment ' || p_rec.prtt_rmt_aprvd_fr_pymt_id , 110);
275: hr_utility.set_location( 'rqst amount ' || l_rqst_amt , 110);
276: hr_utility.set_location( 'to payment amount ' || l_total_pymt_amt , 110);
277: hr_utility.set_location( 'payment amount ' || p_rec.aprvd_fr_pymt_amt , 110);
278:
279:
280: --- whne the total submited more than requst amounnt throw errors
281: if nvl(l_total_pymt_amt,0) + p_rec.aprvd_fr_pymt_amt > nvl(l_rqst_amt,0) then

Line 294: hr_utility.set_location(' bal type '|| l_pl_info.cmpr_clms_to_cvg_or_bal_cd ,20);

290: -- for coverage approval takes care of the validation
291: open c_pl_info ;
292: fetch c_pl_info into l_pl_info ;
293: close c_pl_info ;
294: hr_utility.set_location(' bal type '|| l_pl_info.cmpr_clms_to_cvg_or_bal_cd ,20);
295: if l_pl_info.cmpr_clms_to_cvg_or_bal_cd = 'BAL' then
296: -- not in grace period or claim is in only for current year
297: if l_popl_yr_perd_id_2 is null or (l_popl_yr_perd_id_2 is not null and
298: l_amt_year1 is null) then

Line 310: hr_utility.set_location(' balance '|| l_total_pymt_amt ,20);

306: ,p_prtt_enrt_rslt_id => l_pl_info.prtt_enrt_rslt_id
307: ,p_effective_date => p_effective_date
308: ,p_exp_incurd_dt => l_pl_info.exp_incurd_dt
309: ) ;
310: hr_utility.set_location(' balance '|| l_total_pymt_amt ,20);
311: --
312: if l_popl_yr_perd_id_2 is null then
313: open c_yr_amount(l_pl_info.pl_id ,
314: l_pl_info.submitter_person_id ,

Line 332: hr_utility.set_location ('Paid Amount '||l_paid_amt,10);

328: fetch c_paid_amt into l_paid_amt;
329: close c_paid_amt;
330: end if;
331: if l_paid_amt > 0 then
332: hr_utility.set_location ('Paid Amount '||l_paid_amt,10);
333: if l_prc_overlap.popl_yr_perd_id_1 = l_popl_yr_perd_id_1 then
334: --
335: l_rqst_amt := l_rqst_amt + least(l_paid_amt,l_prc_overlap.amt_year1);
336: elsif

Line 368: hr_utility.set_location ('Paid Amount '||l_paid_amt,11);

364: end if;
365: --
366: if l_paid_amt > 0 then
367: --
368: hr_utility.set_location ('Paid Amount '||l_paid_amt,11);
369: if l_prc_overlap.popl_yr_perd_id_1 = l_popl_yr_perd_id_2 then
370: --
371: l_rqst_amt := l_rqst_amt + least(l_paid_amt,l_prc_overlap.amt_year1);
372: elsif

Line 382: hr_utility.set_location(' total for the yr '|| l_rqst_amt ,20);

378: --
379: end if;
380: end if;
381:
382: hr_utility.set_location(' total for the yr '|| l_rqst_amt ,20);
383: hr_utility.set_location(' old mount '|| nvl(ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt,0) ,20);
384:
385: else
386: --

Line 383: hr_utility.set_location(' old mount '|| nvl(ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt,0) ,20);

379: end if;
380: end if;
381:
382: hr_utility.set_location(' total for the yr '|| l_rqst_amt ,20);
383: hr_utility.set_location(' old mount '|| nvl(ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt,0) ,20);
384:
385: else
386: --
387: open c_yr_perd (l_popl_yr_perd_id_1);

Line 402: hr_utility.set_location(' prevbalance '|| l_total_pymt_amt ,21);

398: ,p_prtt_enrt_rslt_id => l_pl_info.prtt_enrt_rslt_id
399: ,p_effective_date => l_yr_end
400: ,p_exp_incurd_dt => l_yr_end
401: ) ;
402: hr_utility.set_location(' prevbalance '|| l_total_pymt_amt ,21);
403: open c_yr_amount(l_pl_info.pl_id ,
404: l_pl_info.submitter_person_id ,
405: l_popl_yr_perd_id_1) ;
406: fetch c_yr_amount into l_rqst_amt ;

Line 422: hr_utility.set_location ('Paid Amount '||l_paid_amt,12);

418: close c_paid_amt;
419: end if;
420: --
421: if l_paid_amt > 0 then
422: hr_utility.set_location ('Paid Amount '||l_paid_amt,12);
423: if l_prc_overlap.popl_yr_perd_id_1 = l_popl_yr_perd_id_1 then
424: --
425: l_rqst_amt := l_rqst_amt + least(l_paid_amt,l_prc_overlap.amt_year1);
426: elsif

Line 434: hr_utility.set_location(' total for the yr '|| l_rqst_amt ,21);

430: l_rqst_amt := l_rqst_amt + least((l_paid_amt - l_prc_overlap.amt_year1),l_prc_overlap.amt_year2);
431: end if;
432: --
433: end if;
434: hr_utility.set_location(' total for the yr '|| l_rqst_amt ,21);
435: hr_utility.set_location(' old mount '|| nvl(ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt,0) ,22);
436: --
437: if l_amt_year2 is not null then
438: --

Line 435: hr_utility.set_location(' old mount '|| nvl(ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt,0) ,22);

431: end if;
432: --
433: end if;
434: hr_utility.set_location(' total for the yr '|| l_rqst_amt ,21);
435: hr_utility.set_location(' old mount '|| nvl(ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt,0) ,22);
436: --
437: if l_amt_year2 is not null then
438: --
439: l_total_pymt_amt := l_total_pymt_amt +

Line 469: hr_utility.set_location ('Paid Amount '||l_paid_amt,13);

465: close c_paid_amt;
466: end if;
467: --
468: if l_paid_amt > 0 then
469: hr_utility.set_location ('Paid Amount '||l_paid_amt,13);
470: if l_prc_overlap.popl_yr_perd_id_1 = l_popl_yr_perd_id_1 then
471: --
472: l_rqst_amt := l_rqst_amt + least(l_paid_amt,l_prc_overlap.amt_year1);
473: elsif

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

496:
497: end if ;
498:
499: --
500: hr_utility.set_location(' Leaving:'||l_proc,20);
501: end chk_pymt_amt;
502:
503:
504:

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

537: --
538: l_proc varchar2(72) := g_package || 'chk_df';
539: --
540: begin
541: hr_utility.set_location('Entering:'||l_proc,10);
542: --
543: if ((p_rec.prtt_rmt_aprvd_fr_pymt_id is not null) and (
544: nvl(ben_pry_shd.g_old_rec.pry_attribute_category, hr_api.g_varchar2) <>
545: nvl(p_rec.pry_attribute_category, hr_api.g_varchar2) or

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

676: ,p_attribute30_value => p_rec.pry_attribute30
677: );
678: end if;
679: --
680: hr_utility.set_location(' Leaving:'||l_proc,20);
681: end chk_df;
682: --
683: -- ----------------------------------------------------------------------------
684: -- |-----------------------< chk_non_updateable_args >------------------------|

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

962: --
963: l_proc varchar2(72) := g_package||'insert_validate';
964: --
965: Begin
966: hr_utility.set_location('Entering:'||l_proc, 5);
967: --
968: -- Call all supporting business operations
969: --
970: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

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

991:
992: --
993: -------------------ben_pry_bus.chk_df(p_rec);
994: --
995: hr_utility.set_location(' Leaving:'||l_proc, 10);
996: End insert_validate;
997: --
998: -- ----------------------------------------------------------------------------
999: -- |---------------------------< update_validate >----------------------------|

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

1008: --
1009: l_proc varchar2(72) := g_package||'update_validate';
1010: --
1011: Begin
1012: hr_utility.set_location('Entering:'||l_proc, 5);
1013: --
1014: -- Call all supporting business operations
1015: --
1016: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

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

1050:
1051: --
1052: --------------ben_pry_bus.chk_df(p_rec);
1053: --
1054: hr_utility.set_location(' Leaving:'||l_proc, 10);
1055: End update_validate;
1056: --
1057: -- ----------------------------------------------------------------------------
1058: -- |---------------------------< delete_validate >----------------------------|

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

1067: --
1068: l_proc varchar2(72) := g_package||'delete_validate';
1069: --
1070: Begin
1071: hr_utility.set_location('Entering:'||l_proc, 5);
1072: --
1073: -- Call all supporting business operations
1074: --
1075: dt_delete_validate

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

1078: ,p_validation_end_date => p_validation_end_date
1079: ,p_prtt_rmt_aprvd_fr_pymt_id => p_rec.prtt_rmt_aprvd_fr_pymt_id
1080: );
1081: --
1082: hr_utility.set_location(' Leaving:'||l_proc, 10);
1083: End delete_validate;
1084: --
1085: end ben_pry_bus;