DBA Data[Home] [Help]

APPS.BEN_PBN_BUS dependencies on HR_UTILITY

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

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

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

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

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

111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_pbn_shd.api_updating
118: (p_pl_bnf_id => p_pl_bnf_id,
119: p_effective_date => p_effective_date,

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

140: end if;
141: --
142: end if;
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: end chk_prmry_cntngnt_cd;
147: --
148: --

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

251: l_disp_param varchar2(30);
252: l_lf_evt_ocrd_dt date;
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc,5);
256:
257: l_disp_param := null;
258: l_lf_evt_ocrd_dt := null;
259: l_disp_param := fnd_profile.value('BEN_DSPL_NAME_BASIS');

Line 260: hr_utility.set_location('l_disp_param :' || l_disp_param, 12345);

256:
257: l_disp_param := null;
258: l_lf_evt_ocrd_dt := null;
259: l_disp_param := fnd_profile.value('BEN_DSPL_NAME_BASIS');
260: hr_utility.set_location('l_disp_param :' || l_disp_param, 12345);
261:
262: if l_disp_param = 'LEOD' then
263: open c_pil;
264: fetch c_pil into l_lf_evt_ocrd_dt;

Line 265: hr_utility.set_location('l_lf_evt_ocrd_dt :' || l_lf_evt_ocrd_dt, 12345);

261:
262: if l_disp_param = 'LEOD' then
263: open c_pil;
264: fetch c_pil into l_lf_evt_ocrd_dt;
265: hr_utility.set_location('l_lf_evt_ocrd_dt :' || l_lf_evt_ocrd_dt, 12345);
266: close c_pil;
267: end if;
268:
269: -- check if ben_pl_f bnf parameters do not contradict ben_pl_bnf_f values

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

413: fnd_message.raise_error;
414: end if;
415: end if;
416: close pl1;
417: hr_utility.set_location('Leaving:'||l_proc,10);
418: End chk_all_pl_bnf_parameters;
419: --
420: --
421: -- ----------------------------------------------------------------------------

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

472: ;
473: --
474: Begin
475: --
476: hr_utility.set_location('Entering:'||l_proc,5);
477: --
478: l_api_updating := ben_pbn_shd.api_updating
479: (p_pl_bnf_id => p_pl_bnf_id,
480: p_effective_date => p_effective_date,

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

504: --
505: end if;
506: end if;
507: --
508: hr_utility.set_location('Leaving:'||l_proc,10);
509: --
510: End chk_pct_dsgd_num;
511: --
512: -- ----------------------------------------------------------------------------

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

573: ;
574: --
575: Begin
576: --
577: hr_utility.set_location('Entering:'||l_proc,5);
578: --
579: l_api_updating := ben_pbn_shd.api_updating
580: (p_pl_bnf_id => p_pl_bnf_id,
581: p_effective_date => p_effective_date,

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

619: --
620: end if;
621: end if;
622: --
623: hr_utility.set_location('Leaving:'||l_proc,10);
624: --
625: End chk_amt_dsgd_val;
626: --
627: -- ----------------------------------------------------------------------------

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

672: ;
673: --
674: Begin
675: --
676: hr_utility.set_location('Entering:'||l_proc, 5);
677: --
678: l_api_updating := ben_pbn_shd.api_updating
679: (p_pl_bnf_id => p_pl_bnf_id,
680: p_effective_date => p_effective_date,

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

713: --
714: end if;
715: end if;
716: --
717: hr_utility.set_location('Leaving:'||l_proc,10);
718: --
719: end chk_amt_dsgd_uom;
720: --
721: --

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

789: ;
790: --
791: Begin
792: --
793: hr_utility.set_location('Entering:'||l_proc,5);
794: --
795: l_api_updating := ben_pbn_shd.api_updating
796: (p_pl_bnf_id => p_pl_bnf_id,
797: p_effective_date => p_effective_date,

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

836: --
837: end if;
838: end if;
839: --
840: hr_utility.set_location('Leaving:'||l_proc,10);
841: --
842: End chk_bnf_person_id;
843: --
844: --

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

897: ;
898: --
899: Begin
900: --
901: hr_utility.set_location('Entering:'||l_proc,5);
902: --
903: l_api_updating := ben_pbn_shd.api_updating
904: (p_pl_bnf_id => p_pl_bnf_id,
905: p_effective_date => p_effective_date,

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

932: --
933: end if;
934: end if;
935: --
936: hr_utility.set_location('Leaving:'||l_proc,10);
937: --
938: End chk_ttee_person_id;
939: --
940: --

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

1156: End;
1157:
1158: Begin
1159: --
1160: hr_utility.set_location('Entering:'||l_proc,5);
1161: --
1162: l_api_updating := ben_pbn_shd.api_updating
1163: (p_pl_bnf_id => p_pl_bnf_id,
1164: p_effective_date => p_effective_date,

Line 1205: hr_utility.set_location('l_rel_typ' || l_rel_typ ,07);

1201: --
1202: -- check if the designated beneficiary has a contact type provided
1203: -- at option level designation requirement.
1204: --
1205: hr_utility.set_location('l_rel_typ' || l_rel_typ ,07);
1206: hr_utility.set_location('l_lkup_meaning_reln_type' || l_lkup_meaning_reln_type ,07);
1207: open c_opt_dsgn_rqmt;
1208: loop
1209: fetch c_opt_dsgn_rqmt into l_rlshp_typ_cd;

Line 1206: hr_utility.set_location('l_lkup_meaning_reln_type' || l_lkup_meaning_reln_type ,07);

1202: -- check if the designated beneficiary has a contact type provided
1203: -- at option level designation requirement.
1204: --
1205: hr_utility.set_location('l_rel_typ' || l_rel_typ ,07);
1206: hr_utility.set_location('l_lkup_meaning_reln_type' || l_lkup_meaning_reln_type ,07);
1207: open c_opt_dsgn_rqmt;
1208: loop
1209: fetch c_opt_dsgn_rqmt into l_rlshp_typ_cd;
1210: if c_opt_dsgn_rqmt%notfound then

Line 1218: hr_utility.set_location('l_rlshp_typ_cd' || l_rlshp_typ_cd ,07);

1214: end if;
1215: exit;
1216: end if;
1217: -- 3212439
1218: hr_utility.set_location('l_rlshp_typ_cd' || l_rlshp_typ_cd ,07);
1219: open c_bnf_person_rel_typ (l_rlshp_typ_cd);
1220: fetch c_bnf_person_rel_typ into l_rel_typ,l_lkup_meaning_reln_type ;
1221: hr_utility.set_location('l_rel_typ' || l_rel_typ ,07);
1222: hr_utility.set_location('l_lkup_meaning_reln_type' || l_lkup_meaning_reln_type ,07);

Line 1221: hr_utility.set_location('l_rel_typ' || l_rel_typ ,07);

1217: -- 3212439
1218: hr_utility.set_location('l_rlshp_typ_cd' || l_rlshp_typ_cd ,07);
1219: open c_bnf_person_rel_typ (l_rlshp_typ_cd);
1220: fetch c_bnf_person_rel_typ into l_rel_typ,l_lkup_meaning_reln_type ;
1221: hr_utility.set_location('l_rel_typ' || l_rel_typ ,07);
1222: hr_utility.set_location('l_lkup_meaning_reln_type' || l_lkup_meaning_reln_type ,07);
1223: if c_bnf_person_rel_typ%found then
1224: close c_bnf_person_rel_typ ;
1225: close c_opt_dsgn_rqmt ;

Line 1222: hr_utility.set_location('l_lkup_meaning_reln_type' || l_lkup_meaning_reln_type ,07);

1218: hr_utility.set_location('l_rlshp_typ_cd' || l_rlshp_typ_cd ,07);
1219: open c_bnf_person_rel_typ (l_rlshp_typ_cd);
1220: fetch c_bnf_person_rel_typ into l_rel_typ,l_lkup_meaning_reln_type ;
1221: hr_utility.set_location('l_rel_typ' || l_rel_typ ,07);
1222: hr_utility.set_location('l_lkup_meaning_reln_type' || l_lkup_meaning_reln_type ,07);
1223: if c_bnf_person_rel_typ%found then
1224: close c_bnf_person_rel_typ ;
1225: close c_opt_dsgn_rqmt ;
1226: return;

Line 1237: hr_utility.set_location(l_proc,10);

1233: --
1234: -- check if the designated beneficiary has a contact type provided
1235: -- at option in plan level designation requirement.
1236: --
1237: hr_utility.set_location(l_proc,10);
1238: open c_oipl_dsgn_rqmt;
1239: loop
1240: fetch c_oipl_dsgn_rqmt into l_rlshp_typ_cd;
1241: if c_oipl_dsgn_rqmt%notfound then

Line 1250: hr_utility.set_location('l_rlshp_typ_cd' || l_rlshp_typ_cd ,08);

1246: exit;
1247: end if;
1248:
1249: -- 3212439
1250: hr_utility.set_location('l_rlshp_typ_cd' || l_rlshp_typ_cd ,08);
1251: open c_bnf_person_rel_typ (l_rlshp_typ_cd);
1252: fetch c_bnf_person_rel_typ into l_rel_typ,l_lkup_meaning_reln_type ;
1253: hr_utility.set_location('l_rel_typ' || l_rel_typ ,08);
1254: hr_utility.set_location('l_lkup_meaning_reln_type' || l_lkup_meaning_reln_type ,08);

Line 1253: hr_utility.set_location('l_rel_typ' || l_rel_typ ,08);

1249: -- 3212439
1250: hr_utility.set_location('l_rlshp_typ_cd' || l_rlshp_typ_cd ,08);
1251: open c_bnf_person_rel_typ (l_rlshp_typ_cd);
1252: fetch c_bnf_person_rel_typ into l_rel_typ,l_lkup_meaning_reln_type ;
1253: hr_utility.set_location('l_rel_typ' || l_rel_typ ,08);
1254: hr_utility.set_location('l_lkup_meaning_reln_type' || l_lkup_meaning_reln_type ,08);
1255: if c_bnf_person_rel_typ%found then
1256: close c_bnf_person_rel_typ ;
1257: close c_oipl_dsgn_rqmt ;

Line 1254: hr_utility.set_location('l_lkup_meaning_reln_type' || l_lkup_meaning_reln_type ,08);

1250: hr_utility.set_location('l_rlshp_typ_cd' || l_rlshp_typ_cd ,08);
1251: open c_bnf_person_rel_typ (l_rlshp_typ_cd);
1252: fetch c_bnf_person_rel_typ into l_rel_typ,l_lkup_meaning_reln_type ;
1253: hr_utility.set_location('l_rel_typ' || l_rel_typ ,08);
1254: hr_utility.set_location('l_lkup_meaning_reln_type' || l_lkup_meaning_reln_type ,08);
1255: if c_bnf_person_rel_typ%found then
1256: close c_bnf_person_rel_typ ;
1257: close c_oipl_dsgn_rqmt ;
1258: return;

Line 1274: hr_utility.set_location(l_proc,15);

1270: --
1271: -- check if the designated beneficiary has a contact type provided
1272: -- at plan level designation requirement.
1273: --
1274: hr_utility.set_location(l_proc,15);
1275: open c_pl_dsgn_rqmt;
1276: loop
1277: fetch c_pl_dsgn_rqmt into l_rlshp_typ_cd;
1278: if c_pl_dsgn_rqmt%notfound then

Line 1287: hr_utility.set_location('l_rlshp_typ_cd' || l_rlshp_typ_cd ,09);

1283: exit;
1284: end if;
1285:
1286: -- 3212439
1287: hr_utility.set_location('l_rlshp_typ_cd' || l_rlshp_typ_cd ,09);
1288: open c_bnf_person_rel_typ (l_rlshp_typ_cd);
1289: fetch c_bnf_person_rel_typ into l_rel_typ,l_lkup_meaning_reln_type ;
1290: hr_utility.set_location('l_rel_typ' || l_rel_typ ,09);
1291: hr_utility.set_location('l_lkup_meaning_reln_type' || l_lkup_meaning_reln_type ,09);

Line 1290: hr_utility.set_location('l_rel_typ' || l_rel_typ ,09);

1286: -- 3212439
1287: hr_utility.set_location('l_rlshp_typ_cd' || l_rlshp_typ_cd ,09);
1288: open c_bnf_person_rel_typ (l_rlshp_typ_cd);
1289: fetch c_bnf_person_rel_typ into l_rel_typ,l_lkup_meaning_reln_type ;
1290: hr_utility.set_location('l_rel_typ' || l_rel_typ ,09);
1291: hr_utility.set_location('l_lkup_meaning_reln_type' || l_lkup_meaning_reln_type ,09);
1292: if c_bnf_person_rel_typ%found then
1293: close c_bnf_person_rel_typ ;
1294: close c_pl_dsgn_rqmt ;

Line 1291: hr_utility.set_location('l_lkup_meaning_reln_type' || l_lkup_meaning_reln_type ,09);

1287: hr_utility.set_location('l_rlshp_typ_cd' || l_rlshp_typ_cd ,09);
1288: open c_bnf_person_rel_typ (l_rlshp_typ_cd);
1289: fetch c_bnf_person_rel_typ into l_rel_typ,l_lkup_meaning_reln_type ;
1290: hr_utility.set_location('l_rel_typ' || l_rel_typ ,09);
1291: hr_utility.set_location('l_lkup_meaning_reln_type' || l_lkup_meaning_reln_type ,09);
1292: if c_bnf_person_rel_typ%found then
1293: close c_bnf_person_rel_typ ;
1294: close c_pl_dsgn_rqmt ;
1295: return;

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

1303: -- end if;
1304:
1305: end loop;
1306: close c_pl_dsgn_rqmt ;
1307: hr_utility.set_location('Leaving:'||l_proc,40);
1308: --
1309: End chk_bnf_dsgn_rqmt_relnshp_typ ;
1310: --
1311: --

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

1497: and p_effective_date between oipl.effective_start_date and oipl.effective_end_date ;
1498:
1499: Begin
1500: --
1501: hr_utility.set_location('Entering:'||l_proc,5);
1502: --
1503: l_api_updating := ben_pbn_shd.api_updating
1504: (p_pl_bnf_id => p_pl_bnf_id,
1505: p_effective_date => p_effective_date,

Line 1547: hr_utility.set_location(l_proc,07);

1543: --
1544: fetch c_opt_dsgn_rqmt into l_dummy;
1545: if c_opt_dsgn_rqmt%found then
1546: close c_opt_dsgn_rqmt ;
1547: hr_utility.set_location(l_proc,07);
1548: elsif c_opt_dsgn_rqmt%notfound then
1549: --
1550: hr_utility.set_location(l_proc,10);
1551: close c_opt_dsgn_rqmt;

Line 1550: hr_utility.set_location(l_proc,10);

1546: close c_opt_dsgn_rqmt ;
1547: hr_utility.set_location(l_proc,07);
1548: elsif c_opt_dsgn_rqmt%notfound then
1549: --
1550: hr_utility.set_location(l_proc,10);
1551: close c_opt_dsgn_rqmt;
1552: --
1553: -- check if the designated beneficiary has a contact type provided
1554: -- at option in plan level designation requirement.

Line 1561: hr_utility.set_location(l_proc,15);

1557: --
1558: fetch c_oipl_dsgn_rqmt into l_dummy;
1559: if c_oipl_dsgn_rqmt%found then
1560: close c_oipl_dsgn_rqmt ;
1561: hr_utility.set_location(l_proc,15);
1562: elsif c_oipl_dsgn_rqmt%notfound then
1563: --
1564: hr_utility.set_location(l_proc,20);
1565: close c_oipl_dsgn_rqmt;

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

1560: close c_oipl_dsgn_rqmt ;
1561: hr_utility.set_location(l_proc,15);
1562: elsif c_oipl_dsgn_rqmt%notfound then
1563: --
1564: hr_utility.set_location(l_proc,20);
1565: close c_oipl_dsgn_rqmt;
1566: --
1567: -- check if the designated beneficiary has a contact type provided
1568: -- at plan level designation requirement.

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

1571: --
1572: fetch c_pl_dsgn_rqmt into l_dummy;
1573: if c_pl_dsgn_rqmt%notfound then
1574: --
1575: hr_utility.set_location(l_proc,30);
1576: close c_pl_dsgn_rqmt;
1577: --
1578: -- Since the contact type has not been provided as a designation requirement
1579: -- at option / option in plan / plan level, Raise an error that this

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

1618: end if;
1619: --
1620: -- close c_opt_dsgn_rqmt;
1621: --
1622: hr_utility.set_location('Leaving:'||l_proc,40);
1623: --
1624: End chk_bnf_dsgn_rqmt_relnshp_typ ;
1625: --*/
1626: --

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

1671: ;
1672: --
1673: Begin
1674: --
1675: hr_utility.set_location('Entering:'||l_proc,5);
1676: --
1677: l_api_updating := ben_pbn_shd.api_updating
1678: (p_pl_bnf_id => p_pl_bnf_id,
1679: p_effective_date => p_effective_date,

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

1706: --
1707: end if;
1708: end if;
1709: --
1710: hr_utility.set_location('Leaving:'||l_proc,10);
1711: --
1712: End chk_organization_id;
1713:
1714: -- Bug 2843162

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

1773:
1774: --
1775: Begin
1776: --
1777: hr_utility.set_location('Entering:'||l_proc,5);
1778: --
1779: l_api_updating := ben_pbn_shd.api_updating
1780: (p_pl_bnf_id => p_pl_bnf_id,
1781: p_effective_date => p_effective_date,

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

1810: --
1811: --
1812: end if;
1813: --
1814: hr_utility.set_location('Leaving:'||l_proc,10);
1815: --
1816: End chk_bnf_primy_cntgnt_exist;
1817:
1818: -- end 2843162

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

1858: l_integrity_error Exception;
1859: l_table_name all_tables.table_name%TYPE;
1860: --
1861: Begin
1862: hr_utility.set_location('Entering:'||l_proc, 5);
1863: --
1864: -- Ensure that the p_datetrack_mode argument is not null
1865: --
1866: hr_api.mandatory_arg_error

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

1899: --
1900: --
1901: End If;
1902: --
1903: hr_utility.set_location(' Leaving:'||l_proc, 10);
1904: Exception
1905: When l_integrity_error Then
1906: --
1907: -- A referential integrity check was violated therefore

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

1966: l_rows_exist Exception;
1967: l_table_name all_tables.table_name%TYPE;
1968: --
1969: Begin
1970: hr_utility.set_location('Entering:'||l_proc, 5);
1971: --
1972: -- Ensure that the p_datetrack_mode argument is not null
1973: --
1974: hr_api.mandatory_arg_error

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

2011: End If;
2012: --
2013: End If;
2014: --
2015: hr_utility.set_location(' Leaving:'||l_proc, 10);
2016: Exception
2017: When l_rows_exist Then
2018: --
2019: -- A referential integrity check was violated therefore

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

2045: --
2046: l_proc varchar2(72) := g_package||'insert_validate';
2047: --
2048: Begin
2049: hr_utility.set_location('Entering:'||l_proc, 5);
2050: --
2051: -- Call all supporting business operations
2052: --
2053: --

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

2172: p_effective_date => p_effective_date,
2173: p_business_group_id => p_rec.business_group_id,
2174: p_object_version_number => p_rec.object_version_number);
2175: --
2176: hr_utility.set_location(' Leaving:'||l_proc, 10);
2177: End insert_validate;
2178: --
2179: -- ----------------------------------------------------------------------------
2180: -- |---------------------------< update_validate >----------------------------|

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

2188: --
2189: l_proc varchar2(72) := g_package||'update_validate';
2190: --
2191: Begin
2192: hr_utility.set_location('Entering:'||l_proc, 5);
2193: --
2194: -- Call all supporting business operations
2195: --
2196: --

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

2328: p_datetrack_mode => p_datetrack_mode,
2329: p_validation_start_date => p_validation_start_date,
2330: p_validation_end_date => p_validation_end_date);
2331: --
2332: hr_utility.set_location(' Leaving:'||l_proc, 10);
2333: End update_validate;
2334: --
2335: -- ----------------------------------------------------------------------------
2336: -- |---------------------------< delete_validate >----------------------------|

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

2344: --
2345: l_proc varchar2(72) := g_package||'delete_validate';
2346: --
2347: Begin
2348: hr_utility.set_location('Entering:'||l_proc, 5);
2349: --
2350: -- Call all supporting business operations
2351: --
2352: dt_delete_validate

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

2354: p_validation_start_date => p_validation_start_date,
2355: p_validation_end_date => p_validation_end_date,
2356: p_pl_bnf_id => p_rec.pl_bnf_id);
2357: --
2358: hr_utility.set_location(' Leaving:'||l_proc, 10);
2359: End delete_validate;
2360: --
2361: --
2362: -- ---------------------------------------------------------------------------

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

2381: l_proc varchar2(72) := g_package||'return_legislation_code';
2382: --
2383: begin
2384: --
2385: hr_utility.set_location('Entering:'|| l_proc, 10);
2386: --
2387: -- Ensure that all the mandatory parameter are not null
2388: --
2389: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

2406: end if;
2407: --
2408: close csr_leg_code;
2409: --
2410: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2411: --
2412: return l_legislation_code;
2413: --
2414: end return_legislation_code;