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_CCM_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_ccm_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_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_cvg_amt_calc_mthd_id;
78:
79: -- ----------------------------------------------------------------------------

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

119: where cvg_amt_calc_mthd_id = p_cvg_amt_calc_mthd_id;
120: --
121: begin
122: --
123: hr_utility.set_location('Entering:'||l_proc, 5);
124: --
125: open c_creation_date;
126: --
127: fetch c_creation_date into l_creation_date;

Line 141: hr_utility.set_location('l_max_cvg_strt_dt = ' || l_max_cvg_strt_dt, 8888);

137: --
138: if l_max_cvg_strt_dt is not null
139: then
140: --
141: hr_utility.set_location('l_max_cvg_strt_dt = ' || l_max_cvg_strt_dt, 8888);
142: if p_datetrack_mode = 'ZAP'
143: then
144: --
145: close c_max_cvg_strt_dt;

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

167: close c_max_cvg_strt_dt;
168: --
169: end if;
170: --
171: hr_utility.set_location('Leaving:'||l_proc, 10);
172: --
173: end chk_pen_rows_exist;
174:
175: -- ----------------------------------------------------------------------------

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

214: p_effective_date between a.effective_start_date and a.effective_end_date and
215: b.oipl_id = p_oipl_id and p_effective_date between b.effective_start_date and b.effective_end_date ;
216:
217: begin
218: hr_utility.set_location('Entering:'||l_proc, 5);
219: if p_entr_val_at_enrt_flag = 'Y' then
220: -- decide the level - plan
221: If p_pl_id is not null then
222: -- plan level check in rate

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

255: --if any other level added
256: null;
257: end if ;
258: end if ;
259: hr_utility.set_location('Leaving:'||l_proc,10);
260: end chk_entr_at_enrt_with_rate;
261: --
262: -- ----------------------------------------------------------------------------
263: -- |------< chk_comp_lvl_fctr_id >------|

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

300: where a.comp_lvl_fctr_id = p_comp_lvl_fctr_id;
301: --
302: Begin
303: --
304: hr_utility.set_location('Entering:'||l_proc,5);
305: --
306: l_api_updating := ben_ccm_shd.api_updating
307: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
308: p_effective_date => p_effective_date,

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

333: close c1;
334: --
335: end if;
336: --
337: hr_utility.set_location('Leaving:'||l_proc,10);
338: --
339: End chk_comp_lvl_fctr_id;
340: --
341: -- ----------------------------------------------------------------------------

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

387: end count_them;
388: --
389: Begin
390: --
391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: if count_them(p_id => p_pl_id)+
394: count_them(p_id => p_oipl_id)+
395: count_them(p_id => p_plip_id) <> 1 then

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

400: fnd_message.raise_error;
401: --
402: end if;
403: --
404: hr_utility.set_location('Leaving:'||l_proc, 10);
405: --
406: End chk_only_one_fk;
407: --
408: -- ----------------------------------------------------------------------------

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

440: l_api_updating boolean;
441: --
442: Begin
443: --
444: hr_utility.set_location('Entering:'||l_proc, 5);
445: --
446: l_api_updating := ben_ccm_shd.api_updating
447: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
448: p_effective_date => p_effective_date,

Line 466: hr_utility.set_message(801,'RT_TYP_DOES_NOT_EXIST');

462: p_effective_date => p_effective_date) then
463: --
464: -- raise error as does not exist as lookup
465: --
466: hr_utility.set_message(801,'RT_TYP_DOES_NOT_EXIST');
467: hr_utility.raise_error;
468: --
469: end if;
470: --

Line 467: hr_utility.raise_error;

463: --
464: -- raise error as does not exist as lookup
465: --
466: hr_utility.set_message(801,'RT_TYP_DOES_NOT_EXIST');
467: hr_utility.raise_error;
468: --
469: end if;
470: --
471: end if;

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

469: end if;
470: --
471: end if;
472: --
473: hr_utility.set_location('Leaving:'||l_proc,10);
474: --
475: end chk_rt_typ_cd;
476: --
477: -------------------------------------------------------------------------------

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

509: l_api_updating boolean;
510: --
511: Begin
512: --
513: hr_utility.set_location('Entering:'||l_proc, 5);
514: --
515: l_api_updating := ben_ccm_shd.api_updating
516: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
517: p_effective_date => p_effective_date,

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

538: end if;
539: --
540: end if;
541: --
542: hr_utility.set_location('Leaving:'||l_proc,10);
543: --
544: end chk_entr_val_at_enrt_flag;
545: --
546: ------------------------------------------------------------------------------

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

578: l_api_updating boolean;
579: --
580: Begin
581: --
582: hr_utility.set_location('Entering:'||l_proc, 5);
583: --
584: l_api_updating := ben_ccm_shd.api_updating
585: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
586: p_effective_date => p_effective_date,

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

607: end if;
608: --
609: end if;
610: --
611: hr_utility.set_location('Leaving:'||l_proc,10);
612: --
613: end chk_dflt_flag;
614: --
615: -- ----------------------------------------------------------------------------

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

647: l_api_updating boolean;
648: --
649: Begin
650: --
651: hr_utility.set_location('Entering:'||l_proc, 5);
652: --
653: l_api_updating := ben_ccm_shd.api_updating
654: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
655: p_effective_date => p_effective_date,

Line 673: hr_utility.set_message(801,'CVG_MLT_DOES_NOT_EXIST');

669: p_effective_date => p_effective_date) then
670: --
671: -- raise error as does not exist as lookup
672: --
673: hr_utility.set_message(801,'CVG_MLT_DOES_NOT_EXIST');
674: hr_utility.raise_error;
675: --
676: end if;
677: --

Line 674: hr_utility.raise_error;

670: --
671: -- raise error as does not exist as lookup
672: --
673: hr_utility.set_message(801,'CVG_MLT_DOES_NOT_EXIST');
674: hr_utility.raise_error;
675: --
676: end if;
677: --
678: end if;

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

676: end if;
677: --
678: end if;
679: --
680: hr_utility.set_location('Leaving:'||l_proc,10);
681: --
682: end chk_cvg_mlt_cd;
683: --
684: -- ----------------------------------------------------------------------------

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

716: l_api_updating boolean;
717: --
718: Begin
719: --
720: hr_utility.set_location('Entering:'||l_proc, 5);
721: --
722: l_api_updating := ben_ccm_shd.api_updating
723: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
724: p_effective_date => p_effective_date,

Line 742: hr_utility.set_message(801,'BNFT_TYP_DOES_NOT_EXIST');

738: p_effective_date => p_effective_date) then
739: --
740: -- raise error as does not exist as lookup
741: --
742: hr_utility.set_message(801,'BNFT_TYP_DOES_NOT_EXIST');
743: hr_utility.raise_error;
744: --
745: end if;
746: --

Line 743: hr_utility.raise_error;

739: --
740: -- raise error as does not exist as lookup
741: --
742: hr_utility.set_message(801,'BNFT_TYP_DOES_NOT_EXIST');
743: hr_utility.raise_error;
744: --
745: end if;
746: --
747: end if;

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

745: end if;
746: --
747: end if;
748: --
749: hr_utility.set_location('Leaving:'||l_proc,10);
750: --
751: end chk_bnft_typ_cd;
752: --
753: -- ----------------------------------------------------------------------------

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

785: l_api_updating boolean;
786: --
787: Begin
788: --
789: hr_utility.set_location('Entering:'||l_proc, 5);
790: --
791: l_api_updating := ben_ccm_shd.api_updating
792: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
793: p_effective_date => p_effective_date,

Line 811: hr_utility.set_message(801,'BNDRY_PD_DOES_NOT_EXIST');

807: p_effective_date => p_effective_date) then
808: --
809: -- raise error as does not exist as lookup
810: --
811: hr_utility.set_message(801,'BNDRY_PD_DOES_NOT_EXIST');
812: hr_utility.raise_error;
813: --
814: end if;
815: --

Line 812: hr_utility.raise_error;

808: --
809: -- raise error as does not exist as lookup
810: --
811: hr_utility.set_message(801,'BNDRY_PD_DOES_NOT_EXIST');
812: hr_utility.raise_error;
813: --
814: end if;
815: --
816: end if;

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

814: end if;
815: --
816: end if;
817: --
818: hr_utility.set_location('Leaving:'||l_proc,10);
819: --
820: end chk_bndry_perd_cd;
821: --
822: -- ----------------------------------------------------------------------------

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_ccm_shd.api_updating
861: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
862: p_effective_date => p_effective_date,

Line 880: hr_utility.set_message(801,'NNMNTRY_UOM_DOES_NOT_EXIST');

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

Line 881: hr_utility.raise_error;

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

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

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

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

940: and ff.effective_end_date;
941: --
942: Begin
943: --
944: hr_utility.set_location('Entering:'||l_proc, 5);
945: --
946: l_api_updating := ben_ccm_shd.api_updating
947: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
948: p_effective_date => p_effective_date,

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

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

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

1018: l_api_updating boolean;
1019: --
1020: Begin
1021: --
1022: hr_utility.set_location('Entering:'||l_proc, 5);
1023: --
1024: l_api_updating := ben_ccm_shd.api_updating
1025: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
1026: p_effective_date => p_effective_date,

Line 1044: hr_utility.set_message(801,'VAL_OVRD_FLG_DOES_NOT_EXIST');

1040: p_effective_date => p_effective_date) then
1041: --
1042: -- raise error as does not exist as lookup
1043: --
1044: hr_utility.set_message(801,'VAL_OVRD_FLG_DOES_NOT_EXIST');
1045: hr_utility.raise_error;
1046: --
1047: end if;
1048: --

Line 1045: hr_utility.raise_error;

1041: --
1042: -- raise error as does not exist as lookup
1043: --
1044: hr_utility.set_message(801,'VAL_OVRD_FLG_DOES_NOT_EXIST');
1045: hr_utility.raise_error;
1046: --
1047: end if;
1048: --
1049: end if;

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

1047: end if;
1048: --
1049: end if;
1050: --
1051: hr_utility.set_location('Leaving:'||l_proc,10);
1052: --
1053: end chk_val_ovrid_alwd_flag;
1054: --
1055: -- ----------------------------------------------------------------------------

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

1104: and ff.effective_end_date;
1105: --
1106: Begin
1107: --
1108: hr_utility.set_location('Entering:'||l_proc, 5);
1109: --
1110: l_api_updating := ben_ccm_shd.api_updating
1111: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
1112: p_effective_date => p_effective_date,

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

1140: close c1;
1141: --
1142: end if;
1143: --
1144: hr_utility.set_location('Leaving:'||l_proc,10);
1145: --
1146: end chk_rndg_rl;
1147: --
1148: -- ----------------------------------------------------------------------------

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

1197: and ff.effective_end_date;
1198: --
1199: Begin
1200: --
1201: hr_utility.set_location('Entering:'||l_proc, 5);
1202: --
1203: l_api_updating := ben_ccm_shd.api_updating
1204: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
1205: p_effective_date => p_effective_date,

Line 1228: hr_utility.set_message('BEN','BEN_91815_INVALID_LWR_LMT_RL');

1224: close c1;
1225: --
1226: -- raise error
1227: --
1228: hr_utility.set_message('BEN','BEN_91815_INVALID_LWR_LMT_RL');
1229: hr_utility.raise_error;
1230: --
1231: end if;
1232: --

Line 1229: hr_utility.raise_error;

1225: --
1226: -- raise error
1227: --
1228: hr_utility.set_message('BEN','BEN_91815_INVALID_LWR_LMT_RL');
1229: hr_utility.raise_error;
1230: --
1231: end if;
1232: --
1233: close c1;

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

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

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

1290: and ff.effective_end_date;
1291: --
1292: Begin
1293: --
1294: hr_utility.set_location('Entering:'||l_proc, 5);
1295: --
1296: l_api_updating := ben_ccm_shd.api_updating
1297: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
1298: p_effective_date => p_effective_date,

Line 1321: hr_utility.set_message('BEN','BEN_91823_INVALID_UPR_LMT_RL');

1317: close c1;
1318: --
1319: -- raise error
1320: --
1321: hr_utility.set_message('BEN','BEN_91823_INVALID_UPR_LMT_RL');
1322: hr_utility.raise_error;
1323: --
1324: end if;
1325: --

Line 1322: hr_utility.raise_error;

1318: --
1319: -- raise error
1320: --
1321: hr_utility.set_message('BEN','BEN_91823_INVALID_UPR_LMT_RL');
1322: hr_utility.raise_error;
1323: --
1324: end if;
1325: --
1326: close c1;

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

1326: close c1;
1327: --
1328: end if;
1329: --
1330: hr_utility.set_location('Leaving:'||l_proc,10);
1331: --
1332: end chk_upr_lmt_calc_rl;
1333: --
1334: -- ----------------------------------------------------------------------------

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

1366: l_api_updating boolean;
1367: --
1368: Begin
1369: --
1370: hr_utility.set_location('Entering:'||l_proc, 5);
1371: --
1372: l_api_updating := ben_ccm_shd.api_updating
1373: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
1374: p_effective_date => p_effective_date,

Line 1392: hr_utility.set_message(801,'RNDG_CD_DOES_NOT_EXIST');

1388: p_effective_date => p_effective_date) then
1389: --
1390: -- raise error as does not exist as lookup
1391: --
1392: hr_utility.set_message(801,'RNDG_CD_DOES_NOT_EXIST');
1393: hr_utility.raise_error;
1394: --
1395: end if;
1396: --

Line 1393: hr_utility.raise_error;

1389: --
1390: -- raise error as does not exist as lookup
1391: --
1392: hr_utility.set_message(801,'RNDG_CD_DOES_NOT_EXIST');
1393: hr_utility.raise_error;
1394: --
1395: end if;
1396: --
1397: end if;

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

1395: end if;
1396: --
1397: end if;
1398: --
1399: hr_utility.set_location('Leaving:'||l_proc,10);
1400: --
1401: end chk_rndg_cd;
1402: --
1403: -- ----------------------------------------------------------------------------

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

1435: l_api_updating boolean;
1436: --
1437: Begin
1438: --
1439: hr_utility.set_location('Entering:'||l_proc, 5);
1440: --
1441: l_api_updating := ben_ccm_shd.api_updating
1442: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
1443: p_effective_date => p_effective_date,

Line 1461: hr_utility.set_message(801,'NO_MN_VAL_DOES_NOT_EXIST');

1457: p_effective_date => p_effective_date) then
1458: --
1459: -- raise error as does not exist as lookup
1460: --
1461: hr_utility.set_message(801,'NO_MN_VAL_DOES_NOT_EXIST');
1462: hr_utility.raise_error;
1463: --
1464: end if;
1465: --

Line 1462: hr_utility.raise_error;

1458: --
1459: -- raise error as does not exist as lookup
1460: --
1461: hr_utility.set_message(801,'NO_MN_VAL_DOES_NOT_EXIST');
1462: hr_utility.raise_error;
1463: --
1464: end if;
1465: --
1466: end if;

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

1464: end if;
1465: --
1466: end if;
1467: --
1468: hr_utility.set_location('Leaving:'||l_proc,10);
1469: --
1470: end chk_no_mn_val_dfnd_flag;
1471: --
1472: -- ----------------------------------------------------------------------------

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

1504: l_api_updating boolean;
1505: --
1506: Begin
1507: --
1508: hr_utility.set_location('Entering:'||l_proc, 5);
1509: --
1510: l_api_updating := ben_ccm_shd.api_updating
1511: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
1512: p_effective_date => p_effective_date,

Line 1530: hr_utility.set_message(801,'NO_MX_VAL_DOES_NOT_EXIST');

1526: p_effective_date => p_effective_date) then
1527: --
1528: -- raise error as does not exist as lookup
1529: --
1530: hr_utility.set_message(801,'NO_MX_VAL_DOES_NOT_EXIST');
1531: hr_utility.raise_error;
1532: --
1533: end if;
1534: --

Line 1531: hr_utility.raise_error;

1527: --
1528: -- raise error as does not exist as lookup
1529: --
1530: hr_utility.set_message(801,'NO_MX_VAL_DOES_NOT_EXIST');
1531: hr_utility.raise_error;
1532: --
1533: end if;
1534: --
1535: end if;

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

1533: end if;
1534: --
1535: end if;
1536: --
1537: hr_utility.set_location('Leaving:'||l_proc,10);
1538: --
1539: end chk_no_mx_val_dfnd_flag;
1540:
1541: ------------------------------------------------------------------------

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

1579: l_dummy varchar2(1);
1580: --
1581: Begin
1582: --
1583: hr_utility.set_location('Entering:'||l_proc, 5);
1584: --
1585: -- min_val must be < max_val,
1586: -- if both are used.
1587: --

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

1596: --
1597: --
1598: end if;
1599: --
1600: hr_utility.set_location('Leaving:'||l_proc,10);
1601: --
1602: end chk_mn_mx_val;
1603: --
1604: --

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

1633: l_proc varchar2(72) := g_package||'chk_upr_lwr_lmt_val';
1634: --
1635: Begin
1636: --
1637: hr_utility.set_location('Entering:'||l_proc, 5);
1638: --
1639: -- Upper Limit Value should not be less than Lower Limit Value
1640: -- mutually exclusive.
1641: if (p_upr_lmt_val is not null and p_lwr_lmt_val is not null) and

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

1688: -- l_api_updating boolean;
1689: --
1690: --Begin
1691: --
1692: -- hr_utility.set_location('Entering:'||l_proc, 5);
1693: --
1694: -- l_api_updating := ben_ccm_shd.api_updating
1695: -- (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
1696: -- p_effective_date => p_effective_date,

Line 1714: -- hr_utility.set_message(801,'CVG_DET_DOES_NOT_EXIST');

1710: -- p_effective_date => p_effective_date) then
1711: --
1712: -- raise error as does not exist as lookup
1713: --
1714: -- hr_utility.set_message(801,'CVG_DET_DOES_NOT_EXIST');
1715: -- hr_utility.raise_error;
1716: --
1717: -- end if;
1718: --

Line 1715: -- hr_utility.raise_error;

1711: --
1712: -- raise error as does not exist as lookup
1713: --
1714: -- hr_utility.set_message(801,'CVG_DET_DOES_NOT_EXIST');
1715: -- hr_utility.raise_error;
1716: --
1717: -- end if;
1718: --
1719: -- end if;

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

1717: -- end if;
1718: --
1719: -- end if;
1720: --
1721: -- hr_utility.set_location('Leaving:'||l_proc,10);
1722: --
1723: --end chk_cvg_det_cd;
1724: --
1725: -- ----------------------------------------------------------------------------

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

1765: and p_effective_date between effective_start_date
1766: and effective_end_date;
1767: --
1768: Begin
1769: hr_utility.set_location('Entering:'||l_proc, 5);
1770: --
1771: open c1;
1772: fetch c1 into l_dummy;
1773: if c1%found then

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

1775: fnd_message.set_name('BEN','BEN_91615_OIPL_ID_NOT_UNIQUE');
1776: fnd_message.raise_error;
1777: end if;
1778: --
1779: hr_utility.set_location('Leaving:'||l_proc, 15);
1780: End chk_oipl_id_unique;
1781: --
1782: -- ----------------------------------------------------------------------------
1783: -- |------------------------< chk_pl_id_unique >------------------------------|

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

1846: and pip.effective_end_date;
1847:
1848: --
1849: Begin
1850: hr_utility.set_location('Entering:'||l_proc, 5);
1851: --
1852: open c1;
1853: fetch c1 into l_dummy;
1854: if c1%found then

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

1891:
1892: end if;
1893: */
1894: --
1895: hr_utility.set_location('Leaving:'||l_proc, 15);
1896: End chk_pl_id_unique;
1897: --
1898: -- ----------------------------------------------------------------------------
1899: -- |----------------------< chk_plan_not_savings >----------------------------|

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

1955: and oipl.effective_end_date >= p_validation_start_date;
1956: --
1957: Begin
1958: --
1959: hr_utility.set_location('Entering:'||l_proc, 5);
1960: --
1961: if p_pl_id is not null
1962: then
1963: --

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

1991: close c_oipl;
1992: --
1993: end if;
1994: --
1995: hr_utility.set_location('Leaving:'||l_proc, 15);
1996: --
1997: End chk_plan_not_savings;
1998: --
1999: -- ----------------------------------------------------------------------------

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

2037: l_integrity_error Exception;
2038: l_table_name all_tables.table_name%TYPE;
2039: --
2040: Begin
2041: hr_utility.set_location('Entering:'||l_proc, 5);
2042: --
2043: -- Ensure that the p_datetrack_mode argument is not null
2044: --
2045: hr_api.mandatory_arg_error

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

2096: End If;
2097: --
2098: End If;
2099: --
2100: hr_utility.set_location(' Leaving:'||l_proc, 10);
2101: Exception
2102: When l_integrity_error Then
2103: --
2104: -- A referential integrity check was violated therefore

Line 2114: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

2110: --
2111: -- An unhandled or unexpected error has occurred which
2112: -- we must report
2113: --
2114: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2115: hr_utility.set_message_token('PROCEDURE', l_proc);
2116: hr_utility.set_message_token('STEP','15');
2117: hr_utility.raise_error;
2118: End dt_update_validate;

Line 2115: hr_utility.set_message_token('PROCEDURE', l_proc);

2111: -- An unhandled or unexpected error has occurred which
2112: -- we must report
2113: --
2114: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2115: hr_utility.set_message_token('PROCEDURE', l_proc);
2116: hr_utility.set_message_token('STEP','15');
2117: hr_utility.raise_error;
2118: End dt_update_validate;
2119: --

Line 2116: hr_utility.set_message_token('STEP','15');

2112: -- we must report
2113: --
2114: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2115: hr_utility.set_message_token('PROCEDURE', l_proc);
2116: hr_utility.set_message_token('STEP','15');
2117: hr_utility.raise_error;
2118: End dt_update_validate;
2119: --
2120: -- ----------------------------------------------------------------------------

Line 2117: hr_utility.raise_error;

2113: --
2114: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2115: hr_utility.set_message_token('PROCEDURE', l_proc);
2116: hr_utility.set_message_token('STEP','15');
2117: hr_utility.raise_error;
2118: End dt_update_validate;
2119: --
2120: -- ----------------------------------------------------------------------------
2121: -- |--------------------------< dt_delete_validate >--------------------------|

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

2162: l_rows_exist Exception;
2163: l_table_name all_tables.table_name%TYPE;
2164: --
2165: Begin
2166: hr_utility.set_location('Entering:'||l_proc, 5);
2167: --
2168: -- Ensure that the p_datetrack_mode argument is not null
2169: --
2170: hr_api.mandatory_arg_error

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

2234: End If;
2235: --
2236: End If;
2237: --
2238: hr_utility.set_location(' Leaving:'||l_proc, 10);
2239: Exception
2240: When l_rows_exist Then
2241: --
2242: -- A referential integrity check was violated therefore

Line 2252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

2248: --
2249: -- An unhandled or unexpected error has occurred which
2250: -- we must report
2251: --
2252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2253: hr_utility.set_message_token('PROCEDURE', l_proc);
2254: hr_utility.set_message_token('STEP','15');
2255: hr_utility.raise_error;
2256: End dt_delete_validate;

Line 2253: hr_utility.set_message_token('PROCEDURE', l_proc);

2249: -- An unhandled or unexpected error has occurred which
2250: -- we must report
2251: --
2252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2253: hr_utility.set_message_token('PROCEDURE', l_proc);
2254: hr_utility.set_message_token('STEP','15');
2255: hr_utility.raise_error;
2256: End dt_delete_validate;
2257: --

Line 2254: hr_utility.set_message_token('STEP','15');

2250: -- we must report
2251: --
2252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2253: hr_utility.set_message_token('PROCEDURE', l_proc);
2254: hr_utility.set_message_token('STEP','15');
2255: hr_utility.raise_error;
2256: End dt_delete_validate;
2257: --
2258: -- ----------------------------------------------------------------------------

Line 2255: hr_utility.raise_error;

2251: --
2252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2253: hr_utility.set_message_token('PROCEDURE', l_proc);
2254: hr_utility.set_message_token('STEP','15');
2255: hr_utility.raise_error;
2256: End dt_delete_validate;
2257: --
2258: -- ----------------------------------------------------------------------------
2259: -- |------< chk_mlt_cd_dependencies >------|

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

2297: l_api_updating boolean;
2298: --
2299: Begin
2300: --
2301: hr_utility.set_location('Entering:'||l_proc, 5);
2302: --
2303: l_api_updating := ben_ccm_shd.api_updating
2304: (p_cvg_amt_calc_mthd_id => p_cvg_amt_calc_mthd_id,
2305: p_effective_date => p_effective_date,

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

2528: -- end bug 3191595
2529: --
2530: end if;
2531: --
2532: hr_utility.set_location('Leaving:'||l_proc,10);
2533: --
2534: end chk_mlt_cd_dependencies;
2535: --
2536:

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

2564: l_proc varchar2(72) := g_package||'check_rnd_cd_rl_null';
2565: --
2566: Begin
2567: --
2568: hr_utility.set_location('Entering:'||l_proc, 5);
2569: --
2570: if p_rndg_cd='RL' and p_rndg_rl is null then
2571: --
2572: fnd_message.set_name('BEN', 'BEN_91733_RNDG_RULE');

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

2573: fnd_message.raise_error;
2574: --
2575: end if;
2576: --
2577: hr_utility.set_location('Leaving:'||l_proc,10);
2578: --
2579: end check_rnd_cd_rl_null;
2580:
2581: --Bug#5043123

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

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

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

2773: ,p_rndg_cd => p_rec.rndg_cd
2774: ,p_rndg_rl => p_rec.rndg_rl);
2775:
2776: --
2777: hr_utility.set_location(' Leaving:'||l_proc, 10);
2778: End insert_validate;
2779: --
2780: -- ----------------------------------------------------------------------------
2781: -- |---------------------------< update_validate >----------------------------|

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

2789: --
2790: l_proc varchar2(72) := g_package||'update_validate';
2791: --
2792: Begin
2793: hr_utility.set_location('Entering:'||l_proc, 5);
2794: --
2795: -- Call all supporting business operations
2796: --
2797: --

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

2980: ,p_object_version_number => p_rec.object_version_number
2981: ,p_rndg_cd => p_rec.rndg_cd
2982: ,p_rndg_rl => p_rec.rndg_rl);
2983: --
2984: hr_utility.set_location(' Leaving:'||l_proc, 10);
2985: End update_validate;
2986: --
2987: -- ----------------------------------------------------------------------------
2988: -- |---------------------------< delete_validate >----------------------------|

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

2996: --
2997: l_proc varchar2(72) := g_package||'delete_validate';
2998: --
2999: Begin
3000: hr_utility.set_location('Entering:'||l_proc, 5);
3001: --
3002: -- Call all supporting business operations
3003: --
3004: dt_delete_validate

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

3014: p_oipl_id => ben_ccm_shd.g_old_rec.oipl_id,
3015: p_business_group_id => ben_ccm_shd.g_old_rec.business_group_id,
3016: p_datetrack_mode => p_datetrack_mode );
3017: --
3018: hr_utility.set_location(' Leaving:'||l_proc, 10);
3019: End delete_validate;
3020: --
3021: --
3022: -- ---------------------------------------------------------------------------

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

3041: l_proc varchar2(72) := g_package||'return_legislation_code';
3042: --
3043: begin
3044: --
3045: hr_utility.set_location('Entering:'|| l_proc, 10);
3046: --
3047: -- Ensure that all the mandatory parameter are not null
3048: --
3049: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

3059: close csr_leg_code;
3060: --
3061: -- The primary key is invalid therefore we must error
3062: --
3063: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
3064: hr_utility.raise_error;
3065: --
3066: end if;
3067: --

Line 3064: hr_utility.raise_error;

3060: --
3061: -- The primary key is invalid therefore we must error
3062: --
3063: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
3064: hr_utility.raise_error;
3065: --
3066: end if;
3067: --
3068: close csr_leg_code;

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

3066: end if;
3067: --
3068: close csr_leg_code;
3069: --
3070: hr_utility.set_location(' Leaving:'|| l_proc, 20);
3071: --
3072: return l_legislation_code;
3073: --
3074: end return_legislation_code;