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

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_enp_shd.api_updating
47: (p_enrt_perd_id => p_enrt_perd_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_enrt_perd_id;
75: --
76: -- ----------------------------------------------------------------------------

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

117: and a.effective_end_date;
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_enp_shd.api_updating
124: (p_enrt_perd_id => p_enrt_perd_id,
125: p_object_version_number => p_object_version_number);

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

148: close c1;
149: --
150: end if;
151: --
152: hr_utility.set_location('Leaving:'||l_proc,10);
153: --
154: End chk_popl_enrt_typ_cycl_id;
155: --
156: -- ----------------------------------------------------------------------------

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

208: -- and to allow a period to be used more than once and have different
209: -- enrollment periods in them.
210: Begin
211: --
212: hr_utility.set_location('Entering:'||l_proc,5);
213: --
214: l_api_updating := ben_enp_shd.api_updating
215: (p_enrt_perd_id => p_enrt_perd_id,
216: p_object_version_number => p_object_version_number);

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

256: --
257: */
258: end if;
259: --
260: hr_utility.set_location('Leaving:'||l_proc,10);
261: --
262: End chk_yr_perd_id;
263: --
264: -- ----------------------------------------------------------------------------

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

297: l_api_updating boolean;
298: --
299: Begin
300: --
301: hr_utility.set_location('Entering:'||l_proc, 5);
302: --
303: hr_api.mandatory_arg_error(p_api_name => l_proc,
304: p_argument => 'strt_dt',
305: p_argument_value => p_strt_dt);

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

340: --
341: end if;
342: -- chek for asnd_lf_evt_dt is to be added here
343: --
344: hr_utility.set_location('Leaving:'||l_proc,10);
345: --
346: end chk_end_dt;
347: --
348: -- ----------------------------------------------------------------------------

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

391: and enp.asnd_lf_evt_dt = p_asnd_lf_evt_dt
392: and enp.business_group_id = p_business_group_id ;
393: Begin
394: --
395: hr_utility.set_location('Entering:'||l_proc, 5);
396: --
397: hr_api.mandatory_arg_error(p_api_name => l_proc,
398: p_argument => 'asnd_lf_evt_dt',
399: p_argument_value => p_asnd_lf_evt_dt);

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

425: --
426: end if;
427: -- chek for asnd_lf_evt_dt is to be added here
428: --
429: hr_utility.set_location('Leaving:'||l_proc,10);
430: --
431: end chk_dup_asnd_lf_evt_dt;
432: --
433: -- ----------------------------------------------------------------------------

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

465: l_api_updating boolean;
466: --
467: Begin
468: --
469: hr_utility.set_location('Entering:'||l_proc, 5);
470: --
471: /* hr_api.mandatory_arg_error(p_api_name => l_proc,
472: p_argument => 'dflt_enrt_dt',
473: p_argument_value => p_dflt_enrt_dt);

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

502: end if;
503: --
504: end if;
505: --
506: hr_utility.set_location('Leaving:'||l_proc,10);
507: --
508: end chk_dflt_enrt_dt;
509: --
510: -- ----------------------------------------------------------------------------

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

559: and ff.effective_end_date;
560: --
561: Begin
562: --
563: hr_utility.set_location('Entering:'||l_proc, 5);
564: --
565: l_api_updating := ben_enp_shd.api_updating
566: (p_enrt_perd_id => p_enrt_perd_id,
567: p_object_version_number => p_object_version_number);

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

596: close c1;
597: --
598: end if;
599: --
600: hr_utility.set_location('Leaving:'||l_proc,10);
601: --
602: end chk_rt_end_dt_rl;
603: -- ----------------------------------------------------------------------------
604: -- |------< chk_rt_end_dt_cd >------|

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

635: l_api_updating boolean;
636: --
637: Begin
638: --
639: hr_utility.set_location('Entering:'||l_proc, 5);
640: --
641: l_api_updating := ben_enp_shd.api_updating
642: (p_enrt_perd_id => p_enrt_perd_id,
643: p_object_version_number => p_object_version_number);

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_rt_end_dt_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_enp_shd.api_updating
714: (p_enrt_perd_id => p_enrt_perd_id,
715: p_object_version_number => p_object_version_number);

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

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

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

780: l_api_updating boolean;
781: --
782: Begin
783: --
784: hr_utility.set_location('Entering:'||l_proc, 5);
785: --
786: l_api_updating := ben_enp_shd.api_updating
787: (p_enrt_perd_id => p_enrt_perd_id,
788: p_object_version_number => p_object_version_number);

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

812: end if;
813: --
814: end if;
815: --
816: hr_utility.set_location('Leaving:'||l_proc,10);
817: --
818: end chk_reinstate_cd;
819:
820: --

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

854: l_api_updating boolean;
855: --
856: Begin
857: --
858: hr_utility.set_location('Entering:'||l_proc, 5);
859: --
860: l_api_updating := ben_enp_shd.api_updating
861: (p_enrt_perd_id => p_enrt_perd_id,
862: p_object_version_number => p_object_version_number);

Line 879: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

875: p_effective_date => p_effective_date) then
876: --
877: -- raise error as does not exist as lookup
878: --
879: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
880: hr_utility.raise_error;
881: --
882: end if;
883: --

Line 880: hr_utility.raise_error;

876: --
877: -- raise error as does not exist as lookup
878: --
879: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
880: hr_utility.raise_error;
881: --
882: end if;
883: --
884: end if;

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

882: end if;
883: --
884: end if;
885: --
886: hr_utility.set_location('Leaving:'||l_proc,10);
887: --
888: end chk_rt_strt_dt_cd;
889: --
890: -- ----------------------------------------------------------------------------

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

939: and ff.effective_end_date;
940: --
941: Begin
942: --
943: hr_utility.set_location('Entering:'||l_proc, 5);
944: --
945: l_api_updating := ben_enp_shd.api_updating
946: (p_enrt_perd_id => p_enrt_perd_id,
947: p_object_version_number => p_object_version_number);

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

976: close c1;
977: --
978: end if;
979: --
980: hr_utility.set_location('Leaving:'||l_proc,10);
981: --
982: end chk_enrt_cvg_end_dt_rl;
983: --
984: -- ----------------------------------------------------------------------------

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

1033: and ff.effective_end_date;
1034: --
1035: Begin
1036: --
1037: hr_utility.set_location('Entering:'||l_proc, 5);
1038: --
1039: l_api_updating := ben_enp_shd.api_updating
1040: (p_enrt_perd_id => p_enrt_perd_id,
1041: p_object_version_number => p_object_version_number);

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

1070: close c1;
1071: --
1072: end if;
1073: --
1074: hr_utility.set_location('Leaving:'||l_proc,10);
1075: --
1076: end chk_enrt_cvg_strt_dt_rl;
1077: --
1078: -- ----------------------------------------------------------------------------

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

1110: l_api_updating boolean;
1111: --
1112: Begin
1113: --
1114: hr_utility.set_location('Entering:'||l_proc, 5);
1115: --
1116: l_api_updating := ben_enp_shd.api_updating
1117: (p_enrt_perd_id => p_enrt_perd_id,
1118: p_object_version_number => p_object_version_number);

Line 1135: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

1131: p_effective_date => p_effective_date) then
1132: --
1133: -- raise error as does not exist as lookup
1134: --
1135: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1136: hr_utility.raise_error;
1137: --
1138: end if;
1139: --

Line 1136: hr_utility.raise_error;

1132: --
1133: -- raise error as does not exist as lookup
1134: --
1135: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1136: hr_utility.raise_error;
1137: --
1138: end if;
1139: --
1140: end if;

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

1138: end if;
1139: --
1140: end if;
1141: --
1142: hr_utility.set_location('Leaving:'||l_proc,10);
1143: --
1144: end chk_enrt_cvg_end_dt_cd;
1145: --
1146: -- ----------------------------------------------------------------------------

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

1195: and ff.effective_end_date;
1196: --
1197: Begin
1198: --
1199: hr_utility.set_location('Entering:'||l_proc, 5);
1200: --
1201: l_api_updating := ben_enp_shd.api_updating
1202: (p_enrt_perd_id => p_enrt_perd_id,
1203: p_object_version_number => p_object_version_number);

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

1232: close c1;
1233: --
1234: end if;
1235: --
1236: hr_utility.set_location('Leaving:'||l_proc,10);
1237: --
1238: end chk_rt_strt_dt_rl;
1239: --
1240: -- ----------------------------------------------------------------------------

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

1272: l_api_updating boolean;
1273: --
1274: Begin
1275: --
1276: hr_utility.set_location('Entering:'||l_proc, 5);
1277: --
1278: l_api_updating := ben_enp_shd.api_updating
1279: (p_enrt_perd_id => p_enrt_perd_id,
1280: p_object_version_number => p_object_version_number);

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

1300: end if;
1301: --
1302: end if;
1303: --
1304: hr_utility.set_location('Leaving:'||l_proc,10);
1305: --
1306: end chk_enrt_cvg_strt_dt_cd;
1307: --
1308: -- ----------------------------------------------------------------------------

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

1340: l_api_updating boolean;
1341: --
1342: Begin
1343: --
1344: hr_utility.set_location('Entering:'||l_proc, 5);
1345: --
1346: l_api_updating := ben_enp_shd.api_updating
1347: (p_enrt_perd_id => p_enrt_perd_id,
1348: p_object_version_number => p_object_version_number);

Line 1365: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

1361: p_effective_date => p_effective_date) then
1362: --
1363: -- raise error as does not exist as lookup
1364: --
1365: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1366: hr_utility.raise_error;
1367: --
1368: end if;
1369: --

Line 1366: hr_utility.raise_error;

1362: --
1363: -- raise error as does not exist as lookup
1364: --
1365: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1366: hr_utility.raise_error;
1367: --
1368: end if;
1369: --
1370: end if;

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

1368: end if;
1369: --
1370: end if;
1371: --
1372: hr_utility.set_location('Leaving:'||l_proc,10);
1373: --
1374: end chk_cls_enrt_dt_to_use_cd;
1375: --
1376: -- ----------------------------------------------------------------------------

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

1413: l_api_updating boolean;
1414: --
1415: Begin
1416: --
1417: hr_utility.set_location('Entering:'||l_proc, 5);
1418: --
1419: l_api_updating := ben_enp_shd.api_updating
1420: (p_enrt_perd_id => p_enrt_perd_id,
1421: p_object_version_number => p_object_version_number);

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

1443: end if;
1444: --
1445: end if;
1446: --
1447: hr_utility.set_location('Leaving:'||l_proc,10);
1448: --
1449: end chk_enrl_strt_dt_dpndcy;
1450: --
1451:

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

1493: l_dummy varchar2(1) ;
1494: --
1495: Begin
1496:
1497: hr_utility.set_location('Entering:'||l_proc, 5);
1498: --
1499: l_api_updating := ben_enp_shd.api_updating
1500: (p_enrt_perd_id => p_enrt_perd_id,
1501: p_object_version_number => p_object_version_number);

Line 1512: hr_utility.set_location('validating SAl_CHG_REASON:'||p_Sal_chg_reason_cd, 5);

1508: )
1509: or not l_api_updating)
1510: and p_Sal_chg_reason_cd is not null then
1511:
1512: hr_utility.set_location('validating SAl_CHG_REASON:'||p_Sal_chg_reason_cd, 5);
1513: if hr_api.not_exists_in_hr_lookups
1514: (p_lookup_type => 'PROPOSAL_REASON',
1515: p_lookup_code => p_Sal_chg_reason_cd,
1516: p_effective_date => p_effective_date) then

Line 1520: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

1516: p_effective_date => p_effective_date) then
1517: --
1518: -- raise error as does not exist as lookup
1519: --
1520: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1521: hr_utility.raise_error;
1522: --
1523: end if;
1524:

Line 1521: hr_utility.raise_error;

1517: --
1518: -- raise error as does not exist as lookup
1519: --
1520: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1521: hr_utility.raise_error;
1522: --
1523: end if;
1524:
1525: end if ;

Line 1535: hr_utility.set_location('validating Approval_mode_cd:'||p_Approval_mode_cd, 5);

1531: )
1532: or not l_api_updating)
1533: and p_Approval_mode_cd is not null then
1534:
1535: hr_utility.set_location('validating Approval_mode_cd:'||p_Approval_mode_cd, 5);
1536: if hr_api.not_exists_in_hr_lookups
1537: (p_lookup_type => 'BEN_CWB_APPROVAL_MODE',
1538: p_lookup_code => p_Approval_mode_cd,
1539: p_effective_date => p_effective_date) then

Line 1543: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

1539: p_effective_date => p_effective_date) then
1540: --
1541: -- raise error as does not exist as lookup
1542: --
1543: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1544: hr_utility.raise_error;
1545: --
1546: end if;
1547:

Line 1544: hr_utility.raise_error;

1540: --
1541: -- raise error as does not exist as lookup
1542: --
1543: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1544: hr_utility.raise_error;
1545: --
1546: end if;
1547:
1548: end if ;

Line 1565: hr_utility.set_location('validating hrchy_ame_trn_cd:'||p_hrchy_ame_trn_cd, 5);

1561: )
1562: or not l_api_updating)
1563: and p_hrchy_ame_trn_cd is not null then
1564:
1565: hr_utility.set_location('validating hrchy_ame_trn_cd:'||p_hrchy_ame_trn_cd, 5);
1566: open c_hrchy_ame ;
1567: fetch c_hrchy_ame into l_dummy ;
1568: if c_hrchy_ame%notfound then
1569: close c_hrchy_ame ;

Line 1570: hr_utility.set_location('validating hrchy_ame_trn_cd:'||p_hrchy_ame_trn_cd, 7);

1566: open c_hrchy_ame ;
1567: fetch c_hrchy_ame into l_dummy ;
1568: if c_hrchy_ame%notfound then
1569: close c_hrchy_ame ;
1570: hr_utility.set_location('validating hrchy_ame_trn_cd:'||p_hrchy_ame_trn_cd, 7);
1571: fnd_message.set_name('BEN','BEN_93730_CW_HRCHY_AME_ERR');
1572: --Bug 4083891 : Passed Assigned Life Event Date parameter to the modified message
1573: fnd_message.set_token('ALED',fnd_date.date_to_displaydate(p_effective_date,calendar_aware=>2));
1574: fnd_message.raise_error;

Line 1579: hr_utility.set_location('out validating hrchy_ame_trn_cd:'||p_hrchy_ame_trn_cd, 5);

1575:
1576: end if ;
1577: close c_hrchy_ame ;
1578:
1579: hr_utility.set_location('out validating hrchy_ame_trn_cd:'||p_hrchy_ame_trn_cd, 5);
1580: end if ;
1581:
1582:
1583: if (l_api_updating

Line 1591: hr_utility.set_location('validating hrchy_rl:'||p_hrchy_rl, 5);

1587: )
1588: or not l_api_updating)
1589: and p_hrchy_rl is not null then
1590:
1591: hr_utility.set_location('validating hrchy_rl:'||p_hrchy_rl, 5);
1592: open c_hrchy_rl ;
1593: fetch c_hrchy_rl into l_dummy;
1594: if c_hrchy_rl%notfound then
1595: --

Line 1617: hr_utility.set_location('validating hrchy_to_use_cd:'||p_hrchy_to_use_cd, 5);

1613: ( nvl( p_hrchy_to_use_cd,hr_api.g_varchar2) <>
1614: nvl(ben_enp_shd.g_old_rec.hrchy_to_use_cd,hr_api.g_varchar2)
1615: )
1616: or not l_api_updating) then
1617: hr_utility.set_location('validating hrchy_to_use_cd:'||p_hrchy_to_use_cd, 5);
1618: if p_hrchy_to_use_cd is not null then
1619: if hr_api.not_exists_in_hr_lookups
1620: (p_lookup_type => 'BEN_HRCHY_TO_USE',
1621: p_lookup_code => p_hrchy_to_use_cd,

Line 1626: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

1622: p_effective_date => p_effective_date) then
1623: --
1624: -- raise error as does not exist as lookup
1625: --
1626: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1627: hr_utility.raise_error;
1628: --
1629: end if;
1630: end if ;

Line 1627: hr_utility.raise_error;

1623: --
1624: -- raise error as does not exist as lookup
1625: --
1626: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1627: hr_utility.raise_error;
1628: --
1629: end if;
1630: end if ;
1631: end if ;

Line 1635: hr_utility.set_location(' p_hrchy_to_use_cd ' || p_hrchy_to_use_cd, 99);

1631: end if ;
1632: --
1633: -- Bug 4498668 Moved out the checks out of if condition
1634: --
1635: hr_utility.set_location(' p_hrchy_to_use_cd ' || p_hrchy_to_use_cd, 99);
1636: hr_utility.set_location(' p_hrchy_ame_trn_cd ' || p_hrchy_ame_trn_cd, 99);
1637:
1638: if (p_hrchy_to_use_cd = 'RL' and p_hrchy_rl is null)
1639: or ( nvl(p_hrchy_to_use_cd,hr_api.g_varchar2) <> 'RL'

Line 1636: hr_utility.set_location(' p_hrchy_ame_trn_cd ' || p_hrchy_ame_trn_cd, 99);

1632: --
1633: -- Bug 4498668 Moved out the checks out of if condition
1634: --
1635: hr_utility.set_location(' p_hrchy_to_use_cd ' || p_hrchy_to_use_cd, 99);
1636: hr_utility.set_location(' p_hrchy_ame_trn_cd ' || p_hrchy_ame_trn_cd, 99);
1637:
1638: if (p_hrchy_to_use_cd = 'RL' and p_hrchy_rl is null)
1639: or ( nvl(p_hrchy_to_use_cd,hr_api.g_varchar2) <> 'RL'
1640: and p_hrchy_rl is not null ) then

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

1662: fnd_message.raise_error;
1663: --
1664: end if;
1665: --
1666: hr_utility.set_location('Leaving:'||l_proc,10);
1667: end chk_cwb_validations ;
1668:
1669:
1670: -- ----------------------------------------------------------------------------

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

1707: l_api_updating boolean;
1708: --
1709: Begin
1710: --
1711: hr_utility.set_location('Entering:'||l_proc, 5);
1712: --
1713: l_api_updating := ben_enp_shd.api_updating
1714: (p_enrt_perd_id => p_enrt_perd_id,
1715: p_object_version_number => p_object_version_number);

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

1738: end if;
1739: --
1740: end if;
1741: --
1742: hr_utility.set_location('Leaving:'||l_proc,10);
1743: --
1744: end chk_enrl_end_dt_dpndcy;
1745: --
1746: -- ----------------------------------------------------------------------------

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

1783: l_api_updating boolean;
1784: --
1785: Begin
1786: --
1787: hr_utility.set_location('Entering:'||l_proc, 5);
1788: --
1789: l_api_updating := ben_enp_shd.api_updating
1790: (p_enrt_perd_id => p_enrt_perd_id,
1791: p_object_version_number => p_object_version_number);

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

1813: end if;
1814: --
1815: end if;
1816: --
1817: hr_utility.set_location('Leaving:'||l_proc,10);
1818: --
1819: end chk_rt_strt_dt_dpndcy;
1820: --
1821: -- ----------------------------------------------------------------------------

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

1858: l_api_updating boolean;
1859: --
1860: Begin
1861: --
1862: hr_utility.set_location('Entering:'||l_proc, 5);
1863: --
1864: l_api_updating := ben_enp_shd.api_updating
1865: (p_enrt_perd_id => p_enrt_perd_id,
1866: p_object_version_number => p_object_version_number);

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

1889: end if;
1890: --
1891: end if;
1892: --
1893: hr_utility.set_location('Leaving:'||l_proc,10);
1894: --
1895: end chk_rt_end_dt_dpndcy;
1896: --
1897: -- ----------------------------------------------------------------------------

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

1929: l_api_updating boolean;
1930: --
1931: Begin
1932: --
1933: hr_utility.set_location('Entering:'||l_proc, 5);
1934: --
1935:
1936: l_api_updating := ben_enp_shd.api_updating
1937: (p_enrt_perd_id => p_enrt_perd_id,

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

1961: end if;
1962: --
1963: end if;
1964:
1965: hr_utility.set_location('Leaving:'||l_proc,10);
1966: --
1967: end chk_bdgt_upd_end_dt;
1968: --
1969: -- ----------------------------------------------------------------------------

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

2001: l_api_updating boolean;
2002: --
2003: Begin
2004: --
2005: hr_utility.set_location('Entering:'||l_proc, 5);
2006: --
2007:
2008: l_api_updating := ben_enp_shd.api_updating
2009: (p_enrt_perd_id => p_enrt_perd_id,

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

2033: end if;
2034: --
2035: end if;
2036:
2037: hr_utility.set_location('Leaving:'||l_proc,10);
2038: --
2039: end chk_ws_upd_end_dt;
2040: --
2041: --

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

2079: l_api_updating boolean;
2080: --
2081: Begin
2082: --
2083: hr_utility.set_location('Entering:'||l_proc, 5);
2084: --
2085: hr_api.mandatory_arg_error(p_api_name => l_proc,
2086: p_argument => 'strt_dt',
2087: p_argument_value => p_strt_dt);

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

2127: end if;
2128: --
2129: end if;
2130:
2131: hr_utility.set_location('Leaving:'||l_proc,10);
2132: --
2133: end chk_bdgt_upd_period;
2134: --
2135: --

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

2173: l_api_updating boolean;
2174: --
2175: Begin
2176: --
2177: hr_utility.set_location('Entering:'||l_proc, 5);
2178: --
2179: hr_api.mandatory_arg_error(p_api_name => l_proc,
2180: p_argument => 'strt_dt',
2181: p_argument_value => p_strt_dt);

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

2221: end if;
2222: --
2223: end if;
2224:
2225: hr_utility.set_location('Leaving:'||l_proc,10);
2226: --
2227: end chk_ws_upd_period;
2228: --
2229: --

Line 2280: hr_utility.set_location('Entering:'|| l_proc, 9653);

2276: l_proc varchar2(72) := g_package||'chk_defer_flag_set_pln_plip';
2277: --
2278: begin
2279: --
2280: hr_utility.set_location('Entering:'|| l_proc, 9653);
2281: --
2282: l_api_updating := ben_enp_shd.api_updating
2283: (p_enrt_perd_id => p_enrt_perd_id,
2284: p_object_version_number => p_object_version_number);

Line 2306: hr_utility.set_location('Leaving:'|| l_proc, 9653);

2302: --
2303: end if;
2304: --
2305: end if;
2306: hr_utility.set_location('Leaving:'|| l_proc, 9653);
2307: --
2308: end chk_defer_flag_set_pln_plip;
2309: --
2310:

Line 2346: hr_utility.set_location('Entering:'|| l_proc, 9653);

2342: l_proc varchar2(72) := g_package||'chk_defer_flag_lookup';
2343: --
2344: begin
2345: --
2346: hr_utility.set_location('Entering:'|| l_proc, 9653);
2347: --
2348: l_api_updating := ben_enp_shd.api_updating
2349: (p_enrt_perd_id => p_enrt_perd_id,
2350: p_object_version_number => p_object_version_number);

Line 2371: hr_utility.set_location('Leaving:'|| l_proc, 9653);

2367: end if;
2368: --
2369: end if;
2370: --
2371: hr_utility.set_location('Leaving:'|| l_proc, 9653);
2372: --
2373: end chk_defer_flag_lookup;
2374: --
2375: --

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

2381: --
2382: l_proc varchar2(72) := g_package||'insert_validate';
2383: --
2384: Begin
2385: hr_utility.set_location('Entering:'||l_proc, 5);
2386: --
2387: -- Call all supporting business operations
2388: --
2389: --

Line 2542: --hr_utility.set_location(' p_rec.asnd_lf_evt_dt:'||p_rec.asnd_lf_evt_dt, 10);

2538: p_ws_upd_end_dt => p_rec.ws_upd_end_dt,
2539: p_object_version_number => p_rec.object_version_number);
2540: --
2541: -- CWB
2542: --hr_utility.set_location(' p_rec.asnd_lf_evt_dt:'||p_rec.asnd_lf_evt_dt, 10);
2543: chk_cwb_validations
2544: (p_enrt_perd_id => p_rec.enrt_perd_id,
2545: p_data_freeze_date => p_rec.data_freeze_date,
2546: p_Sal_chg_reason_cd => p_rec.Sal_chg_reason_cd,

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

2581: ,p_defer_deenrol_flag => p_rec.defer_deenrol_flag
2582: ,p_object_version_number => p_rec.object_version_number
2583: );
2584: --
2585: hr_utility.set_location(' Leaving:'||l_proc, 10);
2586: --
2587: end insert_validate;
2588: -- ----------------------------------------------------------------------------
2589: -- |---------------------------< update_validate >----------------------------|

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

2593: --
2594: l_proc varchar2(72) := g_package||'update_validate';
2595: --
2596: Begin
2597: hr_utility.set_location('Entering:'||l_proc, 5);
2598: --
2599: -- Call all supporting business operations
2600: --
2601: --

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

2794: ,p_defer_deenrol_flag => p_rec.defer_deenrol_flag
2795: ,p_object_version_number => p_rec.object_version_number
2796: );
2797: --
2798: hr_utility.set_location(' Leaving:'||l_proc, 10);
2799: End update_validate;
2800: --
2801: -- ----------------------------------------------------------------------------
2802: -- |---------------------------< delete_validate >----------------------------|

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

2806: --
2807: l_proc varchar2(72) := g_package||'delete_validate';
2808: --
2809: Begin
2810: hr_utility.set_location('Entering:'||l_proc, 5);
2811: --
2812: -- Call all supporting business operations
2813: --
2814: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

2810: hr_utility.set_location('Entering:'||l_proc, 5);
2811: --
2812: -- Call all supporting business operations
2813: --
2814: hr_utility.set_location(' Leaving:'||l_proc, 10);
2815: End delete_validate;
2816: --
2817: --
2818: -- ---------------------------------------------------------------------------

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

2837: l_proc varchar2(72) := g_package||'return_legislation_code';
2838: --
2839: begin
2840: --
2841: hr_utility.set_location('Entering:'|| l_proc, 10);
2842: --
2843: -- Ensure that all the mandatory parameter are not null
2844: --
2845: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 2859: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

2855: close csr_leg_code;
2856: --
2857: -- The primary key is invalid therefore we must error
2858: --
2859: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
2860: hr_utility.raise_error;
2861: --
2862: end if;
2863: --

Line 2860: hr_utility.raise_error;

2856: --
2857: -- The primary key is invalid therefore we must error
2858: --
2859: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
2860: hr_utility.raise_error;
2861: --
2862: end if;
2863: --
2864: close csr_leg_code;

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

2862: end if;
2863: --
2864: close csr_leg_code;
2865: --
2866: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2867: --
2868: return l_legislation_code;
2869: --
2870: end return_legislation_code;