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

Line 59: g_debug boolean := hr_utility.debug_enabled;

55: */
56: --
57: --Globals
58: --
59: g_debug boolean := hr_utility.debug_enabled;
60: --
61: cursor c_pil(p_ler_id number,
62: p_life_event_date date,
63: p_person_id number) is

Line 176: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);

172: IF c_pil%NOTFOUND THEN
173: --
174: CLOSE c_pil;
175: if g_debug then
176: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
177: end if;
178: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
179: fnd_message.set_token('PROC',l_proc);
180: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

Line 218: hr_utility.set_location('BEN_94612_NO_EPE_EU'|| to_char(p_person_id),54);

214: FETCH c_epe_oipl INTO l_epe;
215: IF c_epe_oipl%NOTFOUND THEN
216: CLOSE c_epe_oipl ;
217: if g_debug then
218: hr_utility.set_location('BEN_94612_NO_EPE_EU'|| to_char(p_person_id),54);
219: end if;
220: fnd_message.set_name('BEN','BEN_94612_NO_EPE_EU');
221: fnd_message.set_token('PROC',l_proc);
222: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

Line 243: hr_utility.set_location('BEN_94612_NO_EPE_EU'|| to_char(p_person_id),54);

239: FETCH c_epe_pl INTO l_epe;
240: IF c_epe_pl%NOTFOUND THEN
241: CLOSE c_epe_pl ;
242: if g_debug then
243: hr_utility.set_location('BEN_94612_NO_EPE_EU'|| to_char(p_person_id),54);
244: end if;
245: fnd_message.set_name('BEN','BEN_94612_NO_EPE_EU');
246: fnd_message.set_token('PROC',l_proc);
247: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

Line 288: hr_utility.set_location('BEN_94616_DPNT_WRONG',54);

284: --
285: IF c_egd%NOTFOUND THEN
286: CLOSE c_egd ;
287: if g_debug then
288: hr_utility.set_location('BEN_94616_DPNT_WRONG',54);
289: end if;
290: fnd_message.set_name('BEN','BEN_94616_DPNT_WRONG');
291: fnd_message.set_token('PROC',l_proc);
292: fnd_message.raise_error;

Line 326: hr_utility.set_location('BEN_94617_DPNT_NO_PEN',54);

322: fetch c_pen into l_dummy;
323: IF c_pen%NOTFOUND THEN
324: CLOSE c_pen ;
325: if g_debug then
326: hr_utility.set_location('BEN_94617_DPNT_NO_PEN',54);
327: end if;
328: fnd_message.set_name('BEN','BEN_94617_DPNT_NO_PEN');
329: fnd_message.set_token('PROC',l_proc);
330: fnd_message.raise_error;

Line 338: hr_utility.set_location('BEN_94617_DPNT_NO_PEN',54);

334: close c_pen ;
335: ELSE
336: --
337: if g_debug then
338: hr_utility.set_location('BEN_94617_DPNT_NO_PEN',54);
339: end if;
340: fnd_message.set_name('BEN','BEN_94617_DPNT_NO_PEN');
341: fnd_message.set_token('PROC',l_proc);
342: fnd_message.raise_error;

Line 364: hr_utility.set_location('BEN_94617_NO_BNF_PERSON',54);

360: --
361: IF p_organization_id IS NULL AND p_bnf_person_id IS NULL THEN
362: --
363: if g_debug then
364: hr_utility.set_location('BEN_94617_NO_BNF_PERSON',54);
365: end if;
366: fnd_message.set_name('BEN','BEN_94617_NO_BNF_PERSON');
367: fnd_message.set_token('PROC',l_proc);
368: fnd_message.raise_error;

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

785: l_pl_opt_name varchar2(600) := null;
786: --
787: begin
788: --
789: hr_utility.set_location('Entering:'||l_proc, 20);
790: --
791: fnd_file.put_line
792: (which => fnd_file.log,
793: buff => 'Entering - BEN_ENROLLMENT_PROCESS.ENROLLMENT_INFORMATION_DETAIL' );

Line 861: hr_utility.set_location('BEN_94552_NO_CVG_STRT_DT'|| to_char(p_person_id),54);

857: l_epe.enrt_cvg_strt_dt := p_enrt_cvg_strt_dt ;
858: ELSE
859: --Throw Error.. Coverage start date needs to be entered
860: if g_debug then
861: hr_utility.set_location('BEN_94552_NO_CVG_STRT_DT'|| to_char(p_person_id),54);
862: end if;
863: fnd_message.set_name('BEN','BEN_94552_NO_CVG_STRT_DT');
864: fnd_message.set_token('PACKAGE',l_proc);
865: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

Line 877: hr_utility.set_location('No Coverage Start date is required '||p_enrt_cvg_strt_dt ,54);

873: --
874: ELSE
875: --
876: if g_debug then
877: hr_utility.set_location('No Coverage Start date is required '||p_enrt_cvg_strt_dt ,54);
878: end if;
879: --
880: END IF;
881: --

Line 898: hr_utility.set_location('BEN_91561_BENVRBRT_ENB_NF'|| to_char(p_person_id),54);

894: FETCH c_enb_with_amt INTO l_enb;
895: IF c_enb_with_amt%NOTFOUND THEN
896: CLOSE c_enb_with_amt ;
897: if g_debug then
898: hr_utility.set_location('BEN_91561_BENVRBRT_ENB_NF'|| to_char(p_person_id),54);
899: end if;
900: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
901: fnd_message.set_token('PACKAGE',l_proc);
902: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

Line 923: hr_utility.set_location('BEN_94558_INVALID_BNFT_VAL'|| to_char(p_person_id),54);

919: ELSE
920: --
921: CLOSE c_enb_with_amt ;
922: if g_debug then
923: hr_utility.set_location('BEN_94558_INVALID_BNFT_VAL'|| to_char(p_person_id),54);
924: end if;
925: fnd_message.set_name('BEN','BEN_91561_BENVRBRT_ENB_NF');
926: fnd_message.set_token('PROC',l_proc);
927: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

Line 990: hr_utility.set_location('BEN_94559_NO_BNFT_VAL'|| to_char(p_person_id),54);

986: IF ((l_enb.entr_val_at_enrt_flag = 'Y' or l_enb.cvg_mlt_cd like '%RNG') and
987: p_bnft_val IS NULL) THEN
988: --
989: if g_debug then
990: hr_utility.set_location('BEN_94559_NO_BNFT_VAL'|| to_char(p_person_id),54);
991: end if;
992: CLOSE c_enb ;
993: fnd_message.set_name('BEN','BEN_94559_NO_BNFT_VAL');
994: fnd_message.set_token('PROC',l_proc);

Line 1044: hr_utility.set_location('APP_94555_NO_RATE_VAL'|| to_char(p_person_id),54);

1040: --
1041: ELSE
1042: --
1043: if g_debug then
1044: hr_utility.set_location('APP_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1045: end if;
1046: fnd_message.set_name('BEN','APP_94555_NO_RATE_VAL');
1047: fnd_message.set_token('PROC',l_proc);
1048: fnd_message.set_token('PERSON_ID', to_char(p_person_id));

Line 1072: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);

1068: FETCH c_ecr_enb INTO l_ecr1; -- l_enrt_rt_id1;
1069: IF c_ecr_enb%NOTFOUND THEN
1070: CLOSE c_ecr_enb ;
1071: if g_debug then
1072: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1073: end if;
1074: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1075: fnd_message.set_token('PROC',l_proc);
1076: fnd_message.set_token('PERSON_ID', to_char(p_person_id));

Line 1092: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);

1088: --
1089: ELSE
1090: --Throw Error
1091: if g_debug then
1092: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1093: end if;
1094: CLOSE c_ecr_enb;
1095: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1096: fnd_message.set_token('PACKAGE',l_proc);

Line 1115: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);

1111: l_ecr1.ann_val := p_ann_rt_val1;
1112: ELSE
1113: --Throw error- rates need to be entered
1114: if g_debug then
1115: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1116: end if;
1117: CLOSE c_ecr_enb;
1118: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1119: fnd_message.set_token('PACKAGE',l_proc);

Line 1143: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);

1139: FETCH c_ecr INTO l_ecr1; -- l_enrt_rt_id1;
1140: IF c_ecr%NOTFOUND THEN
1141: CLOSE c_ecr ;
1142: if g_debug then
1143: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1144: end if;
1145: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1146: fnd_message.set_token('PROC',l_proc);
1147: fnd_message.set_token('PERSON_ID', to_char(p_person_id));

Line 1163: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);

1159: --
1160: ELSE
1161: --Throw Error
1162: if g_debug then
1163: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1164: end if;
1165: CLOSE c_ecr;
1166: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1167: fnd_message.set_token('PACKAGE',l_proc);

Line 1186: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);

1182: l_ecr1.ann_val := p_ann_rt_val1;
1183: ELSE
1184: --Throw error- rates need to be entered
1185: if g_debug then
1186: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1187: end if;
1188: CLOSE c_ecr;
1189: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1190: fnd_message.set_token('PACKAGE',l_proc);

Line 1222: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);

1218: FETCH c_ecr_enb INTO l_ecr2; -- l_enrt_rt_id2;
1219: IF c_ecr_enb%NOTFOUND THEN
1220: CLOSE c_ecr_enb ;
1221: if g_debug then
1222: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1223: end if;
1224: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1225: fnd_message.set_token('PROC',l_proc);
1226: fnd_message.set_token('PERSON_ID', to_char(p_person_id));

Line 1242: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);

1238: --
1239: ELSE
1240: --Throw Error
1241: if g_debug then
1242: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1243: end if;
1244: CLOSE c_ecr_enb;
1245: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1246: fnd_message.set_token('PACKAGE',l_proc);

Line 1265: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);

1261: l_ecr2.ann_val := p_ann_rt_val2;
1262: ELSE
1263: --Throw error- rates need to be entered
1264: if g_debug then
1265: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1266: end if;
1267: CLOSE c_ecr_enb;
1268: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1269: fnd_message.set_token('PACKAGE',l_proc);

Line 1293: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);

1289: FETCH c_ecr INTO l_ecr2; -- l_enrt_rt_id2;
1290: IF c_ecr%NOTFOUND THEN
1291: CLOSE c_ecr ;
1292: if g_debug then
1293: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1294: end if;
1295: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1296: fnd_message.set_token('PROC',l_proc);
1297: fnd_message.set_token('PERSON_ID', to_char(p_person_id));

Line 1313: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);

1309: --
1310: ELSE
1311: --Throw Error
1312: if g_debug then
1313: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1314: end if;
1315: CLOSE c_ecr;
1316: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1317: fnd_message.set_token('PACKAGE',l_proc);

Line 1336: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);

1332: l_ecr2.ann_val := p_ann_rt_val2;
1333: ELSE
1334: --Throw error- rates need to be entered
1335: if g_debug then
1336: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1337: end if;
1338: CLOSE c_ecr;
1339: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1340: fnd_message.set_token('PACKAGE',l_proc);

Line 1372: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);

1368: FETCH c_ecr_enb INTO l_ecr3; -- l_enrt_rt_id3;
1369: IF c_ecr_enb%NOTFOUND THEN
1370: CLOSE c_ecr_enb ;
1371: if g_debug then
1372: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1373: end if;
1374: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1375: fnd_message.set_token('PROC',l_proc);
1376: fnd_message.set_token('PERSON_ID', to_char(p_person_id));

Line 1392: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);

1388: --
1389: ELSE
1390: --Throw Error
1391: if g_debug then
1392: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1393: end if;
1394: CLOSE c_ecr_enb;
1395: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1396: fnd_message.set_token('PACKAGE',l_proc);

Line 1415: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);

1411: l_ecr3.ann_val := p_ann_rt_val3;
1412: ELSE
1413: --Throw error- rates need to be entered
1414: if g_debug then
1415: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1416: end if;
1417: CLOSE c_ecr_enb;
1418: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1419: fnd_message.set_token('PACKAGE',l_proc);

Line 1443: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);

1439: FETCH c_ecr INTO l_ecr3; -- l_enrt_rt_id3;
1440: IF c_ecr%NOTFOUND THEN
1441: CLOSE c_ecr ;
1442: if g_debug then
1443: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1444: end if;
1445: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1446: fnd_message.set_token('PROC',l_proc);
1447: fnd_message.set_token('PERSON_ID', to_char(p_person_id));

Line 1463: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);

1459: --
1460: ELSE
1461: --Throw Error
1462: if g_debug then
1463: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1464: end if;
1465: CLOSE c_ecr;
1466: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1467: fnd_message.set_token('PACKAGE',l_proc);

Line 1486: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);

1482: l_ecr3.ann_val := p_ann_rt_val3;
1483: ELSE
1484: --Throw error- rates need to be entered
1485: if g_debug then
1486: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1487: end if;
1488: CLOSE c_ecr;
1489: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1490: fnd_message.set_token('PACKAGE',l_proc);

Line 1522: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);

1518: FETCH c_ecr_enb INTO l_ecr4; -- l_enrt_rt_id4;
1519: IF c_ecr_enb%NOTFOUND THEN
1520: CLOSE c_ecr_enb ;
1521: if g_debug then
1522: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1523: end if;
1524: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1525: fnd_message.set_token('PROC',l_proc);
1526: fnd_message.set_token('PERSON_ID', to_char(p_person_id));

Line 1542: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);

1538: --
1539: ELSE
1540: --Throw Error
1541: if g_debug then
1542: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1543: end if;
1544: CLOSE c_ecr_enb;
1545: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1546: fnd_message.set_token('PACKAGE',l_proc);

Line 1565: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);

1561: l_ecr4.ann_val := p_ann_rt_val4;
1562: ELSE
1563: --Throw error- rates need to be entered
1564: if g_debug then
1565: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1566: end if;
1567: CLOSE c_ecr_enb;
1568: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1569: fnd_message.set_token('PACKAGE',l_proc);

Line 1593: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);

1589: FETCH c_ecr INTO l_ecr4; -- l_enrt_rt_id4;
1590: IF c_ecr%NOTFOUND THEN
1591: CLOSE c_ecr ;
1592: if g_debug then
1593: hr_utility.set_location('BEN_94535_ECR_NOT_FOUND'|| to_char(p_person_id),54);
1594: end if;
1595: fnd_message.set_name('BEN','BEN_94535_ECR_NOT_FOUND');
1596: fnd_message.set_token('PROC',l_proc);
1597: fnd_message.set_token('PERSON_ID', to_char(p_person_id));

Line 1613: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);

1609: --
1610: ELSE
1611: --Throw Error
1612: if g_debug then
1613: hr_utility.set_location('BEN_94552_NO_RT_STRT_DT'|| to_char(p_person_id),54);
1614: end if;
1615: CLOSE c_ecr;
1616: fnd_message.set_name('BEN','BEN_94552_NO_RT_STRT_DT');
1617: fnd_message.set_token('PACKAGE',l_proc);

Line 1636: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);

1632: l_ecr4.ann_val := p_ann_rt_val4;
1633: ELSE
1634: --Throw error- rates need to be entered
1635: if g_debug then
1636: hr_utility.set_location('BEN_94555_NO_RATE_VAL'|| to_char(p_person_id),54);
1637: end if;
1638: CLOSE c_ecr;
1639: fnd_message.set_name('BEN','BEN_94555_NO_RATE_VAL');
1640: fnd_message.set_token('PACKAGE',l_proc);

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

1808: ,p_mode => null); --?
1809: --
1810: end if; --End of if(l_enroll_flag)
1811: --
1812: hr_utility.set_location('Leaving:'||l_proc, 20);
1813: --
1814: exception when others then
1815: raise ;
1816: end enrollment_information_detail;

Line 1857: hr_utility.set_location('Entering:'||l_proc, 20);

1853: l_flx_cr_flag VARCHAR2(30) := 'N';
1854: --
1855: begin
1856: --
1857: hr_utility.set_location('Entering:'||l_proc, 20);
1858: --
1859: IF p_pgm_id IS NOT NULL THEN
1860: OPEN c_pgm ;
1861: FETCH c_pgm INTO l_pgm_typ_cd ;

Line 1879: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);

1875: IF c_pil%NOTFOUND THEN
1876: CLOSE c_pil ;
1877: --
1878: if g_debug then
1879: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
1880: end if;
1881: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
1882: fnd_message.set_token('PROC',l_proc);
1883: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

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

1928: ,p_proc_cd => p_proc_cd
1929: ,p_business_group_id => p_business_group_id
1930: ,p_effective_date => p_effective_date);
1931: --
1932: hr_utility.set_location('Leaving:'||l_proc, 20);
1933: --
1934: exception when others then
1935: raise ;
1936: end post_enrollment ;

Line 1982: hr_utility.set_location('Entering:'||l_proc||':'||p_record_typ_cd, 20);

1978: l_proc varchar2(60) := 'ben_enrollment_process.create_enrollment' ;
1979: --
1980: begin
1981: --
1982: hr_utility.set_location('Entering:'||l_proc||':'||p_record_typ_cd, 20);
1983: --Bug 5259118
1984: -- IF fnd_global.conc_request_id = -1 THEN
1985: --
1986: ben_env_object.init(p_business_group_id => p_business_group_id,

Line 2094: hr_utility.set_location('BEN_94536_RECORD_TYPE_ERROR'|| to_char(p_person_id),54);

2090: --
2091: ELSE
2092: --
2093: if g_debug then
2094: hr_utility.set_location('BEN_94536_RECORD_TYPE_ERROR'|| to_char(p_person_id),54);
2095: end if;
2096: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');
2097: fnd_message.set_token('PROC',l_proc);
2098: fnd_message.set_token('PERSON_ID',p_record_typ_cd);

Line 2149: hr_utility.set_location('Entering:'||l_proc, 20);

2145: l_returned_end_dt date ;
2146: --
2147: begin
2148: --
2149: hr_utility.set_location('Entering:'||l_proc, 20);
2150: --
2151: --Bug 5259118
2152: -- IF fnd_global.conc_request_id = -1 THEN
2153: --

Line 2429: hr_utility.set_location('BEN_94536_RECORD_TYPE_ERROR'|| to_char(p_person_id),54);

2425: --
2426: ELSE
2427: --Throw Error invalid record type
2428: if g_debug then
2429: hr_utility.set_location('BEN_94536_RECORD_TYPE_ERROR'|| to_char(p_person_id),54);
2430: end if;
2431: fnd_message.set_name('BEN','BEN_94536_RECORD_TYPE_ERROR');
2432: fnd_message.set_token('PROC',l_proc);
2433: fnd_message.set_token('PERSON_ID',l_record_typ_cd);

Line 2441: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);

2437: --
2438: END IF;
2439: ELSE
2440: if g_debug then
2441: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
2442: end if;
2443: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2444: fnd_message.set_token('PROC',l_proc);
2445: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

Line 2526: hr_utility.set_location('Entering:'||l_proc, 20);

2522: and p_effective_date
2523: between effective_start_date and effective_end_date;
2524: --
2525: begin
2526: hr_utility.set_location('Entering:'||l_proc, 20);
2527: --
2528: --Bug 5259118
2529: -- IF fnd_global.conc_request_id = -1 THEN
2530: --

Line 2649: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);

2645: --
2646: IF l_pil.per_in_ler_id IS NULL THEN
2647: --
2648: if g_debug then
2649: hr_utility.set_location('BEN_94534_PIL_NOT_FOUND'|| to_char(p_person_id),54);
2650: end if;
2651: fnd_message.set_name('BEN','BEN_94534_PIL_NOT_FOUND');
2652: fnd_message.set_token('PROC',l_proc);
2653: fnd_message.set_token('PERSON_ID',to_char(p_person_id));