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_PEL_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_pel_shd.api_updating
47: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_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_pil_elctbl_chc_popl_id;
75:
76: --

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

112: from fnd_currencies_tl
113: where currency_code = p_uom ;
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc, 5);
117: --
118: l_api_updating := ben_pel_shd.api_updating
119: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
120: p_object_version_number => p_object_version_number);

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

142: close c1;
143: --
144: end if;
145: --
146: hr_utility.set_location('Leaving:'||l_proc,10);
147: --
148: end chk_uom ;
149: --
150: -- ----------------------------------------------------------------------------

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

189: and a.per_in_ler_stat_cd = 'STRTD';
190: --
191: Begin
192: --
193: hr_utility.set_location('Entering:'||l_proc,5);
194: --
195: l_api_updating := ben_pel_shd.api_updating
196: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
197: p_object_version_number => p_object_version_number);

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

220: close c1;
221: --
222: end if;
223: --
224: hr_utility.set_location('Leaving:'||l_proc,10);
225: --
226: End chk_per_in_ler_id;
227: --
228: -- ----------------------------------------------------------------------------

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

269: and a.effective_end_date;
270: --
271: Begin
272: --
273: hr_utility.set_location('Entering:'||l_proc,5);
274: --
275: l_api_updating := ben_pel_shd.api_updating
276: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
277: p_object_version_number => p_object_version_number);

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

300: close c1;
301: --
302: end if;
303: --
304: hr_utility.set_location('Leaving:'||l_proc,10);
305: --
306: End chk_lee_rsn_id;
307: --
308: -- ----------------------------------------------------------------------------

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

344: where a.enrt_perd_id = p_enrt_perd_id;
345: --
346: Begin
347: --
348: hr_utility.set_location('Entering:'||l_proc,5);
349: --
350: l_api_updating := ben_pel_shd.api_updating
351: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
352: p_object_version_number => p_object_version_number);

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

376: close c1;
377: --
378: end if;
379: --
380: hr_utility.set_location('Leaving:'||l_proc,10);
381: --
382: End chk_enrt_perd_id;
383: --
384: -- ----------------------------------------------------------------------------

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

416: l_api_updating boolean;
417: --
418: Begin
419: --
420: hr_utility.set_location('Entering:'||l_proc, 5);
421: --
422: l_api_updating := ben_pel_shd.api_updating
423: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
424: p_object_version_number => p_object_version_number);

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

446: end if;
447: --
448: end if;
449: --
450: hr_utility.set_location('Leaving:'||l_proc,10);
451: --
452: end chk_enrt_typ_cycl_cd;
453: --
454: -- ----------------------------------------------------------------------------

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

486: l_api_updating boolean;
487: --
488: Begin
489: --
490: hr_utility.set_location('Entering:'||l_proc, 5);
491: --
492: l_api_updating := ben_pel_shd.api_updating
493: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
494: p_object_version_number => p_object_version_number);

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

516: end if;
517: --
518: end if;
519: --
520: hr_utility.set_location('Leaving:'||l_proc,10);
521: --
522: end chk_ws_stat_cd;
523: --
524: -- ----------------------------------------------------------------------------

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

556: l_api_updating boolean;
557: --
558: Begin
559: --
560: hr_utility.set_location('Entering:'||l_proc, 5);
561: --
562: l_api_updating := ben_pel_shd.api_updating
563: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
564: p_object_version_number => p_object_version_number);

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

586: end if;
587: --
588: end if;
589: --
590: hr_utility.set_location('Leaving:'||l_proc,10);
591: --
592: end chk_ws_acc_cd;
593: --
594: -- ----------------------------------------------------------------------------

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

626: l_api_updating boolean;
627: --
628: Begin
629: --
630: hr_utility.set_location('Entering:'||l_proc, 5);
631: --
632: l_api_updating := ben_pel_shd.api_updating
633: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
634: p_object_version_number => p_object_version_number);

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

656: end if;
657: --
658: end if;
659: --
660: hr_utility.set_location('Leaving:'||l_proc,10);
661: --
662: end chk_bdgt_stat_cd;
663: --
664: -- ----------------------------------------------------------------------------

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

696: l_api_updating boolean;
697: --
698: Begin
699: --
700: hr_utility.set_location('Entering:'||l_proc, 5);
701: --
702: l_api_updating := ben_pel_shd.api_updating
703: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
704: p_object_version_number => p_object_version_number);

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

726: end if;
727: --
728: end if;
729: --
730: hr_utility.set_location('Leaving:'||l_proc,10);
731: --
732: end chk_pop_cd;
733: --
734: -- ----------------------------------------------------------------------------

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

766: l_api_updating boolean;
767: --
768: Begin
769: --
770: hr_utility.set_location('Entering:'||l_proc, 5);
771: --
772: l_api_updating := ben_pel_shd.api_updating
773: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
774: p_object_version_number => p_object_version_number);

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

796: end if;
797: --
798: end if;
799: --
800: hr_utility.set_location('Leaving:'||l_proc,10);
801: --
802: end chk_bdgt_acc_cd;
803: --
804: -- ----------------------------------------------------------------------------

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

836: l_api_updating boolean;
837: --
838: Begin
839: --
840: hr_utility.set_location('Entering:'||l_proc, 5);
841: --
842: l_api_updating := ben_pel_shd.api_updating
843: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
844: p_object_version_number => p_object_version_number);

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

866: end if;
867: --
868: end if;
869: --
870: hr_utility.set_location('Leaving:'||l_proc,10);
871: --
872: end chk_cls_enrt_dt_to_use_cd;
873: --
874: -- ----------------------------------------------------------------------------

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

906: l_api_updating boolean;
907: --
908: Begin
909: --
910: hr_utility.set_location('Entering:'||l_proc, 5);
911: --
912: l_api_updating := ben_pel_shd.api_updating
913: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
914: p_object_version_number => p_object_version_number);

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

936: end if;
937: --
938: end if;
939: --
940: hr_utility.set_location('Leaving:'||l_proc,10);
941: --
942: end chk_acty_ref_perd_cd;
943: --
944: -- ----------------------------------------------------------------------------

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

976: l_api_updating boolean;
977: --
978: Begin
979: --
980: hr_utility.set_location('Entering:'||l_proc, 5);
981: --
982: l_api_updating := ben_pel_shd.api_updating
983: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
984: p_object_version_number => p_object_version_number);

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

1006: end if;
1007: --
1008: end if;
1009: --
1010: hr_utility.set_location('Leaving:'||l_proc,10);
1011: --
1012: end chk_pil_elctbl_popl_stat_cd;
1013: --
1014: --

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

1021: l_api_updating boolean;
1022: --
1023: Begin
1024: --
1025: hr_utility.set_location('Entering:'||l_proc, 5);
1026: --
1027: l_api_updating := ben_pel_shd.api_updating
1028: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
1029: p_object_version_number => p_object_version_number);

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

1051: end if;
1052: --
1053: end if;
1054: --
1055: hr_utility.set_location('Leaving:'||l_proc,10);
1056: --
1057: end chk_reinstate_cd;
1058: --
1059: --

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

1066: l_api_updating boolean;
1067: --
1068: Begin
1069: --
1070: hr_utility.set_location('Entering:'||l_proc, 5);
1071: --
1072: l_api_updating := ben_pel_shd.api_updating
1073: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
1074: p_object_version_number => p_object_version_number);

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

1096: end if;
1097: --
1098: end if;
1099: --
1100: hr_utility.set_location('Leaving:'||l_proc,10);
1101: --
1102: end chk_reinstate_ovrdn_cd;
1103: --
1104: -- ----------------------------------------------------------------------------

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

1116: --
1117: l_proc varchar2(72) := g_package||'chk_Enrt_Lee_ID';
1118: --
1119: Begin
1120: hr_utility.set_location('Entering:'||l_proc, 5);
1121: If ( nvl(p_Enrt_Typ_Cycl_cd,'X') = 'U') then
1122: NULL;
1123: Else
1124: if (p_enrt_perd_id is null and p_lee_rsn_id is null) then

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

1129: fnd_message.raise_error;
1130: end if;
1131: End if;
1132: --
1133: hr_utility.set_location('Leaving:'||l_proc,10);
1134: --
1135: end chk_Enrt_Lee_id;
1136: --
1137: -- ----------------------------------------------------------------------------

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

1165: from dual;
1166: */
1167: --
1168: Begin
1169: hr_utility.set_location('Entering:'||l_proc, 5);
1170: /* -- No need to check with system date
1171: open get_system_date;
1172: fetch get_system_date into l_system_date;
1173: close get_system_date;

Line 1180: -- hr_utility.set_location('Me here :'||l_proc, 8);

1176: l_api_updating := ben_pel_shd.api_updating
1177: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
1178: p_object_version_number => p_object_version_number);
1179: --
1180: -- hr_utility.set_location('Me here :'||l_proc, 8);
1181: if (l_api_updating
1182: and p_enrt_perd_end_dt
1183: <> nvl(ben_pel_shd.g_old_rec.enrt_perd_end_dt,hr_api.g_date)) then
1184: If p_pil_elctbl_popl_stat_cd = 'STRTD' then

Line 1198: -- hr_utility.set_location('Me here :'||l_proc, 10);

1194: fnd_message.raise_error;
1195: end if;
1196: End if;
1197:
1198: -- hr_utility.set_location('Me here :'||l_proc, 10);
1199: --
1200: if (l_api_updating
1201: and p_dflt_enrt_dt
1202: <> nvl(ben_pel_shd.g_old_rec.dflt_enrt_dt,hr_api.g_date)) then

Line 1219: -- hr_utility.set_location('Me here :'||l_proc, 12);

1215: fnd_message.raise_error;
1216: end if;
1217: End if;
1218: --
1219: -- hr_utility.set_location('Me here :'||l_proc, 12);
1220:
1221: -- Added the following two validations for bug 3653034
1222: /* default enrollment date can be after processing end date per plan design
1223: If p_dflt_enrt_dt > p_procg_end_dt then

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

1235: fnd_message.set_name('BEN','BEN_PDW_93536_SCH_ENRDT_CMP');
1236: fnd_message.raise_error;
1237: End If;
1238:
1239: hr_utility.set_location('Leaving:'||l_proc,10);
1240: --
1241: end chk_dflt_enrt_perd_end;
1242: --
1243: -- ----------------------------------------------------------------------------

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

1285: l_proc varchar2(72) := g_package||'chk_ws_mgr_id';
1286:
1287: begin
1288:
1289: hr_utility.set_location(' Entering:'||l_proc, 10);
1290:
1291: if (p_ws_mgr_id
1292: <> nvl(ben_pel_shd.g_old_rec.ws_mgr_id,hr_api.g_number)) then
1293:

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

1303: close c1;
1304:
1305: end if;
1306:
1307: hr_utility.set_location(' Leaving:'||l_proc, 20);
1308: end chk_ws_mgr_id;
1309: -- ----------------------------------------------------------------------------
1310: -- |---------------------------< insert_validate >----------------------------|
1311: -- ----------------------------------------------------------------------------

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

1314: --
1315: l_proc varchar2(72) := g_package||'insert_validate';
1316: --
1317: Begin
1318: hr_utility.set_location('Entering:'||l_proc, 5);
1319: --
1320: -- Call context sensitive validate bgp cache routine
1321: --
1322: ben_batch_dt_api.batch_validate_bgp_id

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

1423: p_effective_date => p_effective_date,
1424: p_object_version_number => p_rec.object_version_number
1425: );
1426: --
1427: hr_utility.set_location(' Leaving:'||l_proc, 10);
1428: End insert_validate;
1429: --
1430: -- ----------------------------------------------------------------------------
1431: -- |---------------------------< update_validate >----------------------------|

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

1435: --
1436: l_proc varchar2(72) := g_package||'update_validate';
1437: --
1438: Begin
1439: hr_utility.set_location('Entering:'||l_proc, 5);
1440: --
1441: -- Call context sensitive validate bgp cache routine
1442: --
1443: ben_batch_dt_api.batch_validate_bgp_id

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

1563: p_effective_date => p_effective_date
1564: );
1565: */
1566: --
1567: hr_utility.set_location(' Leaving:'||l_proc, 10);
1568: End update_validate;
1569: --
1570: -- ----------------------------------------------------------------------------
1571: -- |---------------------------< delete_validate >----------------------------|

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

1584: from ben_elig_per_elctbl_chc epe
1585: where epe.pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id;
1586:
1587: Begin
1588: hr_utility.set_location('Entering:'||l_proc, 5);
1589: --
1590: -- Call all supporting business operations
1591: --
1592: -- Check for existance of child EPE record before deleting parent POPL record

Line 1593: hr_utility.set_location('p_rec.pil_elctbl_chc_popl_id '||p_rec.pil_elctbl_chc_popl_id, 11);

1589: --
1590: -- Call all supporting business operations
1591: --
1592: -- Check for existance of child EPE record before deleting parent POPL record
1593: hr_utility.set_location('p_rec.pil_elctbl_chc_popl_id '||p_rec.pil_elctbl_chc_popl_id, 11);
1594: open c_epe_exists(p_rec.pil_elctbl_chc_popl_id);
1595: fetch c_epe_exists into l_val;
1596: if c_epe_exists%found
1597: then

Line 1599: hr_utility.set_location('c_epe_exists%found, raise excpetion', 11);

1595: fetch c_epe_exists into l_val;
1596: if c_epe_exists%found
1597: then
1598: close c_epe_exists;
1599: hr_utility.set_location('c_epe_exists%found, raise excpetion', 11);
1600: Raise l_rows_exist;
1601: end if;
1602: close c_epe_exists;
1603: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1599: hr_utility.set_location('c_epe_exists%found, raise excpetion', 11);
1600: Raise l_rows_exist;
1601: end if;
1602: close c_epe_exists;
1603: hr_utility.set_location(' Leaving:'||l_proc, 10);
1604: Exception
1605: When l_rows_exist Then
1606:
1607: fnd_message.set_name('BEN', 'BEN_91152_EPE_EXISTS');

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

1632: l_proc varchar2(72) := g_package||'return_legislation_code';
1633: --
1634: begin
1635: --
1636: hr_utility.set_location('Entering:'|| l_proc, 10);
1637: --
1638: -- Ensure that all the mandatory parameter are not null
1639: --
1640: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1657: end if;
1658: --
1659: close csr_leg_code;
1660: --
1661: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1662: --
1663: return l_legislation_code;
1664: --
1665: end return_legislation_code;