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

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

31: l_proc varchar2(72) := g_package||'generate_communications';
32: --
33: begin
34: --
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: if p_prtt_reimbmt_rqst_stat_cd = 'PNDGPYMT' then --- Pending Payment
38: l_proc_cd := 'RMBRQST';
39: elsif p_prtt_reimbmt_rqst_stat_cd = 'PDINFL' then --- Paid in Full

Line 60: hr_utility.set_location('Leaving:'|| l_proc, 15);

56: l_proc_cd := 'RMBVOID';
57: elsif p_prtt_reimbmt_rqst_stat_cd = 'DPLICT' then --- duplicate
58: l_proc_cd := 'RMBDPLCT';
59: else
60: hr_utility.set_location('Leaving:'|| l_proc, 15);
61: return;
62: end if;
63: --
64: hr_utility.set_location( l_proc, 20);

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

60: hr_utility.set_location('Leaving:'|| l_proc, 15);
61: return;
62: end if;
63: --
64: hr_utility.set_location( l_proc, 20);
65: --
66: open c_pen;
67: fetch c_pen into l_pen;
68: --

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

100: end if;
101: --
102: close c_pen;
103: --
104: hr_utility.set_location('Leaving:'|| l_proc, 20);
105: --
106: end generate_communications;
107: --
108: procedure find_pymt_amt (p_effective_date date,

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

198: l_amt_year2 number;
199: l_rqst_amt_1 number;
200:
201: begin
202: hr_utility.set_location('Entering:'||l_proc,10);
203: --
204: open c_prc ;
205: fetch c_prc into l_rqst_amt,l_popl_yr_perd_id_1,l_popl_yr_perd_id_2,
206: l_amt_year1,l_amt_year2 ;

Line 209: hr_utility.set_location( 'reimbursement id' || p_prtt_reimbmt_rqst_id , 11);

205: fetch c_prc into l_rqst_amt,l_popl_yr_perd_id_1,l_popl_yr_perd_id_2,
206: l_amt_year1,l_amt_year2 ;
207: close c_prc ;
208:
209: hr_utility.set_location( 'reimbursement id' || p_prtt_reimbmt_rqst_id , 11);
210: open c_pl_info ;
211: fetch c_pl_info into l_pl_info ;
212: close c_pl_info ;
213: hr_utility.set_location(' bal type '|| l_pl_info.cmpr_clms_to_cvg_or_bal_cd ,20);

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

209: hr_utility.set_location( 'reimbursement id' || p_prtt_reimbmt_rqst_id , 11);
210: open c_pl_info ;
211: fetch c_pl_info into l_pl_info ;
212: close c_pl_info ;
213: hr_utility.set_location(' bal type '|| l_pl_info.cmpr_clms_to_cvg_or_bal_cd ,20);
214: if l_pl_info.cmpr_clms_to_cvg_or_bal_cd = 'BAL' then
215: -- not in grace period or claim is in only for current year
216: if l_popl_yr_perd_id_2 is null or (l_popl_yr_perd_id_2 is not null and
217: l_amt_year1 is null) then

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

225: ,p_prtt_enrt_rslt_id => l_pl_info.prtt_enrt_rslt_id
226: ,p_effective_date => p_effective_date
227: ,p_exp_incurd_dt => l_pl_info.exp_incurd_dt
228: ) ;
229: hr_utility.set_location(' balance '|| l_total_pymt_amt ,20);
230: --
231: if l_popl_yr_perd_id_2 is null then
232: open c_yr_amount(l_pl_info.pl_id ,
233: l_pl_info.submitter_person_id ,

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

247: fetch c_paid_amt into l_paid_amt;
248: close c_paid_amt;
249: end if;
250: if l_paid_amt > 0 then
251: hr_utility.set_location ('Paid Amount '||l_paid_amt,10);
252: if l_prc_overlap.popl_yr_perd_id_1 = l_popl_yr_perd_id_1 then
253: --
254: l_rqst_amt := l_rqst_amt + least(l_paid_amt,l_prc_overlap.amt_year1);
255: elsif

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

281: end if;
282: --
283: if l_paid_amt > 0 then
284: --
285: hr_utility.set_location ('Paid Amount '||l_paid_amt,11);
286: if l_prc_overlap.popl_yr_perd_id_1 = l_popl_yr_perd_id_2 then
287: --
288: l_rqst_amt := l_rqst_amt + least(l_paid_amt,l_prc_overlap.amt_year1);
289: elsif

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

295: --
296: end if;
297: end if;
298:
299: hr_utility.set_location(' total for the yr '|| l_rqst_amt ,20);
300:
301: else
302: --
303: open c_yr_perd (l_popl_yr_perd_id_1);

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

314: ,p_prtt_enrt_rslt_id => l_pl_info.prtt_enrt_rslt_id
315: ,p_effective_date => l_yr_end
316: ,p_exp_incurd_dt => l_yr_end
317: ) ;
318: hr_utility.set_location(' prevbalance '|| l_total_pymt_amt ,21);
319: open c_yr_amount(l_pl_info.pl_id ,
320: l_pl_info.submitter_person_id ,
321: l_popl_yr_perd_id_1) ;
322: fetch c_yr_amount into l_rqst_amt ;

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

334: close c_paid_amt;
335: end if;
336: --
337: if l_paid_amt > 0 then
338: hr_utility.set_location ('Paid Amount '||l_paid_amt,12);
339: if l_prc_overlap.popl_yr_perd_id_1 = l_popl_yr_perd_id_1 then
340: --
341: l_rqst_amt := l_rqst_amt + least(l_paid_amt,l_prc_overlap.amt_year1);
342: elsif

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

346: l_rqst_amt := l_rqst_amt + least((l_paid_amt - l_prc_overlap.amt_year1),l_prc_overlap.amt_year2);
347: end if;
348: --
349: end if;
350: hr_utility.set_location(' total for the yr '|| l_rqst_amt ,21);
351: --
352: if l_amt_year2 is not null then
353: --
354: l_total_pymt_amt := l_total_pymt_amt +

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

380: close c_paid_amt;
381: end if;
382: --
383: if l_paid_amt > 0 then
384: hr_utility.set_location ('Paid Amount '||l_paid_amt,13);
385: if l_prc_overlap.popl_yr_perd_id_1 = l_popl_yr_perd_id_1 then
386: --
387: l_rqst_amt := l_rqst_amt + least(l_paid_amt,l_prc_overlap.amt_year1);
388: elsif

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

410:
411: end if ;
412:
413: --
414: hr_utility.set_location(' Leaving:'||l_proc,20);
415: end find_pymt_amt;
416: --
417: procedure find_popl_yr_perd
418: (p_pl_id number,

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

636: l_popl_yr_perd_id_1 number;
637: l_popl_yr_perd_id_2 number;
638: begin
639: --
640: hr_utility.set_location('Entering:'|| l_proc, 10);
641: --
642: -- Issue a savepoint if operating in validation only mode
643: --
644: savepoint create_PRTT_REIMBMT_RQST;

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

642: -- Issue a savepoint if operating in validation only mode
643: --
644: savepoint create_PRTT_REIMBMT_RQST;
645: --
646: hr_utility.set_location(l_proc, 20);
647: --this cursor is for gettin value for resutlt id and to create prtt_rt_val
648: open c_rslt_rec;
649: fetch c_rslt_rec into l_rslt_rec;
650: close c_rslt_rec;

Line 843: --hr_utility.set_location('after ins in api ' || p_prtt_reimbmt_rqst_stat_cd, 110);

839: ,p_Aprvd_for_pymt_amt => p_Aprvd_for_pymt_amt
840: ,p_pymt_amount => l_pymt_amount
841: ,p_exp_incurd_dt => p_exp_incurd_dt
842: );
843: --hr_utility.set_location('after ins in api ' || p_prtt_reimbmt_rqst_stat_cd, 110);
844: --hr_utility.set_location('after ins status ' || P_STAT_RSN_CD, 110);
845: --hr_utility.set_location('after ins in api ' || p_Pymt_stat_cd, 110);
846: --hr_utility.set_location('after ins status ' || p_pymt_stat_rsn_cd, 110);
847:

Line 844: --hr_utility.set_location('after ins status ' || P_STAT_RSN_CD, 110);

840: ,p_pymt_amount => l_pymt_amount
841: ,p_exp_incurd_dt => p_exp_incurd_dt
842: );
843: --hr_utility.set_location('after ins in api ' || p_prtt_reimbmt_rqst_stat_cd, 110);
844: --hr_utility.set_location('after ins status ' || P_STAT_RSN_CD, 110);
845: --hr_utility.set_location('after ins in api ' || p_Pymt_stat_cd, 110);
846: --hr_utility.set_location('after ins status ' || p_pymt_stat_rsn_cd, 110);
847:
848:

Line 845: --hr_utility.set_location('after ins in api ' || p_Pymt_stat_cd, 110);

841: ,p_exp_incurd_dt => p_exp_incurd_dt
842: );
843: --hr_utility.set_location('after ins in api ' || p_prtt_reimbmt_rqst_stat_cd, 110);
844: --hr_utility.set_location('after ins status ' || P_STAT_RSN_CD, 110);
845: --hr_utility.set_location('after ins in api ' || p_Pymt_stat_cd, 110);
846: --hr_utility.set_location('after ins status ' || p_pymt_stat_rsn_cd, 110);
847:
848:
849: --

Line 846: --hr_utility.set_location('after ins status ' || p_pymt_stat_rsn_cd, 110);

842: );
843: --hr_utility.set_location('after ins in api ' || p_prtt_reimbmt_rqst_stat_cd, 110);
844: --hr_utility.set_location('after ins status ' || P_STAT_RSN_CD, 110);
845: --hr_utility.set_location('after ins in api ' || p_Pymt_stat_cd, 110);
846: --hr_utility.set_location('after ins status ' || p_pymt_stat_rsn_cd, 110);
847:
848:
849: --
850: begin

Line 941: hr_utility.set_location(' Payable Amount in api '|| l_pymt_amount, 110);

937: --
938: end;
939: --
940: --- Create payment entry only when approved
941: hr_utility.set_location(' Payable Amount in api '|| l_pymt_amount, 110);
942: if p_prtt_reimbmt_rqst_stat_cd in ('APPRVD','PDINFL','PRTLYPD') then
943: --bug#5527088
944: find_pymt_amt ( p_effective_date => p_effective_date,
945: p_prtt_reimbmt_rqst_id => p_prtt_reimbmt_rqst_id,

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

962: end if ;
963:
964: end if ;
965:
966: hr_utility.set_location(l_proc, 135);
967: if p_prtt_reimbmt_rqst_stat_cd is not null then
968: generate_communications(
969: p_submitter_person_id => p_submitter_person_id,
970: p_pl_id => p_pl_id,

Line 976: hr_utility.set_location(l_proc, 60);

972: p_business_group_id => p_business_group_id,
973: p_effective_date => p_effective_date);
974: end if ;
975: --
976: hr_utility.set_location(l_proc, 60);
977: --
978: -- When in validation only mode raise the Validate_Enabled exception
979: --
980: if p_validate then

Line 991: hr_utility.set_location(' Leaving:'||l_proc, 70);

987: p_effective_start_date := l_effective_start_date;
988: p_effective_end_date := l_effective_end_date;
989: p_object_version_number := l_object_version_number;
990: --
991: hr_utility.set_location(' Leaving:'||l_proc, 70);
992: --
993: exception
994: --
995: when hr_api.validate_enabled then

Line 1010: hr_utility.set_location(' Leaving:'||l_proc, 80);

1006: p_prtt_reimbmt_rqst_id := null;
1007: p_effective_start_date := null;
1008: p_effective_end_date := null;
1009: p_object_version_number := null;
1010: hr_utility.set_location(' Leaving:'||l_proc, 80);
1011: --
1012: when others then
1013: --
1014: -- A validation or unexpected error has occured

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

1144:
1145: --
1146: begin
1147: --
1148: hr_utility.set_location('Entering:'|| l_proc, 10);
1149: --
1150: -- Issue a savepoint if operating in validation only mode
1151: --
1152: savepoint update_PRTT_REIMBMT_RQST;

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

1150: -- Issue a savepoint if operating in validation only mode
1151: --
1152: savepoint update_PRTT_REIMBMT_RQST;
1153: --
1154: hr_utility.set_location(l_proc, 20);
1155: --
1156: -- Process Logic
1157: ----Get all before update data of reimbursement
1158: open c_prcold ;

Line 1343: --hr_utility.set_location('after upd in api ' || p_prtt_reimbmt_rqst_stat_cd, 110);

1339: ,p_pymt_amount => l_pymt_amount
1340: ,p_exp_incurd_dt => p_exp_incurd_dt
1341: );
1342: --
1343: --hr_utility.set_location('after upd in api ' || p_prtt_reimbmt_rqst_stat_cd, 110);
1344: --hr_utility.set_location('after ins in api ' || P_STAT_RSN_CD, 110);
1345: --hr_utility.set_location('after ins in api ' || p_Pymt_stat_cd, 110);
1346: --hr_utility.set_location('after ins status ' || p_pymt_stat_rsn_cd, 110);
1347:

Line 1344: --hr_utility.set_location('after ins in api ' || P_STAT_RSN_CD, 110);

1340: ,p_exp_incurd_dt => p_exp_incurd_dt
1341: );
1342: --
1343: --hr_utility.set_location('after upd in api ' || p_prtt_reimbmt_rqst_stat_cd, 110);
1344: --hr_utility.set_location('after ins in api ' || P_STAT_RSN_CD, 110);
1345: --hr_utility.set_location('after ins in api ' || p_Pymt_stat_cd, 110);
1346: --hr_utility.set_location('after ins status ' || p_pymt_stat_rsn_cd, 110);
1347:
1348: --

Line 1345: --hr_utility.set_location('after ins in api ' || p_Pymt_stat_cd, 110);

1341: );
1342: --
1343: --hr_utility.set_location('after upd in api ' || p_prtt_reimbmt_rqst_stat_cd, 110);
1344: --hr_utility.set_location('after ins in api ' || P_STAT_RSN_CD, 110);
1345: --hr_utility.set_location('after ins in api ' || p_Pymt_stat_cd, 110);
1346: --hr_utility.set_location('after ins status ' || p_pymt_stat_rsn_cd, 110);
1347:
1348: --
1349: -- bug fix 2223214

Line 1346: --hr_utility.set_location('after ins status ' || p_pymt_stat_rsn_cd, 110);

1342: --
1343: --hr_utility.set_location('after upd in api ' || p_prtt_reimbmt_rqst_stat_cd, 110);
1344: --hr_utility.set_location('after ins in api ' || P_STAT_RSN_CD, 110);
1345: --hr_utility.set_location('after ins in api ' || p_Pymt_stat_cd, 110);
1346: --hr_utility.set_location('after ins status ' || p_pymt_stat_rsn_cd, 110);
1347:
1348: --
1349: -- bug fix 2223214
1350: -- when the user tries to move from an approved status to any of the unapproved

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

1356:
1357: if nvl(p_prtt_reimbmt_rqst_stat_cd,'-1') not in ('APPRVD','PDINFL','PRTLYPD') and
1358: nvl(l_prc_old.prtt_reimbmt_rqst_stat_cd,'-1') in ('APPRVD','PDINFL','PRTLYPD') then
1359: --
1360: hr_utility.set_location(l_proc, 30);
1361: --
1362: open c_pry;
1363: loop
1364: --

Line 1368: hr_utility.set_location(l_proc, 40);

1364: --
1365: fetch c_pry into l_prtt_rmt_aprvd_pymt_id
1366: , l_pry_ovn;
1367: --
1368: hr_utility.set_location(l_proc, 40);
1369: hr_utility.set_location(' l_prtt_rmt_aprvd_pymt_id is ' || l_prtt_rmt_aprvd_pymt_id , 999);
1370: --
1371: if c_pry%found then
1372: --

Line 1369: hr_utility.set_location(' l_prtt_rmt_aprvd_pymt_id is ' || l_prtt_rmt_aprvd_pymt_id , 999);

1365: fetch c_pry into l_prtt_rmt_aprvd_pymt_id
1366: , l_pry_ovn;
1367: --
1368: hr_utility.set_location(l_proc, 40);
1369: hr_utility.set_location(' l_prtt_rmt_aprvd_pymt_id is ' || l_prtt_rmt_aprvd_pymt_id , 999);
1370: --
1371: if c_pry%found then
1372: --
1373: -- delete reimbursement payment records

Line 1393: hr_utility.set_location(l_proc, 50);

1389: --
1390: end loop;
1391: close c_pry;
1392: --
1393: hr_utility.set_location(l_proc, 50);
1394: --
1395: end if;
1396:
1397: --

Line 1401: hr_utility.set_location(' Payable Amount in api '|| l_pymt_amount, 110);

1397: --
1398: -- end fix 2223214
1399: --
1400:
1401: hr_utility.set_location(' Payable Amount in api '|| l_pymt_amount, 110);
1402: if nvl(p_prtt_reimbmt_rqst_stat_cd,'-1') in ('APPRVD','PDINFL','PRTLYPD') and
1403: nvl(l_prc_old.prtt_reimbmt_rqst_stat_cd,'-1') not in ('APPRVD','PDINFL','PRTLYPD') then
1404: --bug#5527088
1405: find_pymt_amt ( p_effective_date => p_effective_date,

Line 1534: hr_utility.set_location(l_proc, 60);

1530: p_business_group_id => p_business_group_id,
1531: p_effective_date => p_effective_date);
1532: --end if ;
1533: --
1534: hr_utility.set_location(l_proc, 60);
1535: --
1536: -- When in validation only mode raise the Validate_Enabled exception
1537: --
1538: if p_validate then

Line 1548: hr_utility.set_location(' Leaving:'||l_proc, 70);

1544: p_object_version_number := l_object_version_number;
1545: p_effective_start_date := l_effective_start_date;
1546: p_effective_end_date := l_effective_end_date;
1547: --
1548: hr_utility.set_location(' Leaving:'||l_proc, 70);
1549: --
1550: exception
1551: --
1552: when hr_api.validate_enabled then

Line 1563: hr_utility.set_location(' Leaving:'||l_proc, 80);

1559: -- Only set output warning arguments
1560: -- (Any key or derived arguments must be set to null
1561: -- when validation only mode is being used.)
1562: --
1563: hr_utility.set_location(' Leaving:'||l_proc, 80);
1564: --
1565: when others then
1566: --
1567: -- A validation or unexpected error has occured

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

1595:
1596: --
1597: begin
1598: --
1599: hr_utility.set_location('Entering:'|| l_proc, 10);
1600: --
1601: -- Issue a savepoint if operating in validation only mode
1602: --
1603: savepoint delete_PRTT_REIMBMT_RQST;

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

1601: -- Issue a savepoint if operating in validation only mode
1602: --
1603: savepoint delete_PRTT_REIMBMT_RQST;
1604: --
1605: hr_utility.set_location(l_proc, 20);
1606: --
1607: -- Process Logic
1608: --
1609: l_object_version_number := p_object_version_number;

Line 1669: hr_utility.set_location(l_proc, 60);

1665: -- End of API User Hook for the after hook of delete_PRTT_REIMBMT_RQST
1666: --
1667: end;
1668: --
1669: hr_utility.set_location(l_proc, 60);
1670: -- When in validation only mode raise the Validate_Enabled exception
1671: --
1672: if p_validate then
1673: raise hr_api.validate_enabled;

Line 1676: hr_utility.set_location(' Leaving:'||l_proc, 70);

1672: if p_validate then
1673: raise hr_api.validate_enabled;
1674: end if;
1675: --
1676: hr_utility.set_location(' Leaving:'||l_proc, 70);
1677: --
1678: exception
1679: --
1680: when hr_api.validate_enabled then

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

1722: l_validation_end_date date;
1723: --
1724: begin
1725: --
1726: hr_utility.set_location('Entering:'|| l_proc, 10);
1727: --
1728: ben_prc_shd.lck
1729: (
1730: p_prtt_reimbmt_rqst_id => p_prtt_reimbmt_rqst_id

Line 1738: hr_utility.set_location(' Leaving:'||l_proc, 70);

1734: ,p_effective_date => p_effective_date
1735: ,p_datetrack_mode => p_datetrack_mode
1736: );
1737: --
1738: hr_utility.set_location(' Leaving:'||l_proc, 70);
1739: --
1740: end lck;
1741: --
1742: end ben_PRTT_REIMBMT_RQST_api;