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

Line 49: hr_utility.set_location (l_package_name,10);

45:
46: g_dummy NUmber(1);
47: BEGIN
48:
49: hr_utility.set_location (l_package_name,10);
50: OPEN c_translation(language, ler_name,ler_id,l_business_group_id);
51: hr_utility.set_location (l_package_name,50);
52: FETCH c_translation INTO g_dummy;
53:

Line 51: hr_utility.set_location (l_package_name,50);

47: BEGIN
48:
49: hr_utility.set_location (l_package_name,10);
50: OPEN c_translation(language, ler_name,ler_id,l_business_group_id);
51: hr_utility.set_location (l_package_name,50);
52: FETCH c_translation INTO g_dummy;
53:
54: IF c_translation%NOTFOUND THEN
55: hr_utility.set_location (l_package_name,60);

Line 55: hr_utility.set_location (l_package_name,60);

51: hr_utility.set_location (l_package_name,50);
52: FETCH c_translation INTO g_dummy;
53:
54: IF c_translation%NOTFOUND THEN
55: hr_utility.set_location (l_package_name,60);
56: CLOSE c_translation;
57: ELSE
58: hr_utility.set_location (l_package_name,70);
59: CLOSE c_translation;

Line 58: hr_utility.set_location (l_package_name,70);

54: IF c_translation%NOTFOUND THEN
55: hr_utility.set_location (l_package_name,60);
56: CLOSE c_translation;
57: ELSE
58: hr_utility.set_location (l_package_name,70);
59: CLOSE c_translation;
60: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
61: fnd_message.raise_error;
62: END IF;

Line 63: hr_utility.set_location ('Leaving:'||l_package_name,80);

59: CLOSE c_translation;
60: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
61: fnd_message.raise_error;
62: END IF;
63: hr_utility.set_location ('Leaving:'||l_package_name,80);
64: END validate_translation;
65: --
66: -- change ended .. for bug 4651734
67: --

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

101: l_api_updating boolean;
102: --
103: Begin
104: --
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: l_api_updating := ben_ler_shd.api_updating
108: (p_effective_date => p_effective_date,
109: p_ler_id => p_ler_id,

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

130: end if;
131: --
132: end if;
133: --
134: hr_utility.set_location('Leaving:'||l_proc, 10);
135: --
136: End chk_ler_id;
137: -- ----------------------------------------------------------------------------
138: -- |------< chk_child_rows >------|

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

172: l_table_name all_tables.table_name%TYPE := null;
173: --
174: Begin
175: --
176: hr_utility.set_location('Entering:'||l_proc, 5);
177: --
178: If (dt_api.rows_exist
179: (p_base_table_name => 'ben_lee_rsn_f',
180: p_base_key_column => 'ler_id',

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

272: fnd_message.raise_error;
273: end if;
274: end if;
275: --
276: hr_utility.set_location('Leaving:'||l_proc, 10);
277: End chk_child_rows;
278:
279: --
280: Procedure chk_seeded_life

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

284: dummy varchar2(10);
285: --
286: Begin
287: --
288: hr_utility.set_location('Entering:'||l_proc, 5);
289: --
290: select null into dummy from ben_ler_f ler
291: where ler.ler_id = p_ler_id and ler.typ_cd in
292: (select typ_cd from ben_startup_lers);

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

292: (select typ_cd from ben_startup_lers);
293: -- fnd_message.set_name('BEN','BEN_92490_CANNOT_DELETE_LER');
294: fnd_message.set_name('BEN','BEN_92490_CANNOT_DELETE_LER');
295: fnd_message.raise_error;
296: hr_utility.set_location('Leaving:'||l_proc,10);
297: Exception
298: When no_data_found then
299: null;
300: End chk_seeded_life;

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

335: l_api_updating boolean;
336: --
337: Begin
338: --
339: hr_utility.set_location('Entering:'||l_proc, 5);
340: --
341: l_api_updating := ben_ler_shd.api_updating
342: (p_ler_id => p_ler_id,
343: p_effective_date => p_effective_date,

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

364: end if;
365: --
366: end if;
367: --
368: hr_utility.set_location('Leaving:'||l_proc,10);
369: --
370: end chk_whn_to_prcs_cd;
371: --
372: -- ----------------------------------------------------------------------------

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

418: and ff.effective_end_date;
419: --
420: Begin
421: --
422: hr_utility.set_location('Entering:'||l_proc, 5);
423: --
424: l_api_updating := ben_ler_shd.api_updating
425: (p_ler_id => p_ler_id,
426: p_effective_date => p_effective_date,

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

454: close c1;
455: --
456: end if;
457: --
458: hr_utility.set_location('Leaving:'||l_proc,10);
459: --
460: end chk_ler_eval_rl;
461: --
462: -- ----------------------------------------------------------------------------

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

494: l_api_updating boolean;
495: --
496: Begin
497: --
498: hr_utility.set_location('Entering:'||l_proc, 5);
499: --
500: l_api_updating := ben_ler_shd.api_updating
501: (p_ler_id => p_ler_id,
502: p_effective_date => p_effective_date,

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

525: end if;
526: --
527: end if;
528: --
529: hr_utility.set_location('Leaving:'||l_proc,10);
530: --
531: end chk_ptnl_ler_trtmt_cd;
532: --
533: --

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

570: l_api_updating boolean;
571: --
572: Begin
573: --
574: hr_utility.set_location('Entering:'||l_proc, 5);
575: --
576: l_api_updating := ben_ler_shd.api_updating
577: (p_ler_id => p_ler_id,
578: p_effective_date => p_effective_date,

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

598: end if;
599: --
600: end if;
601: --
602: hr_utility.set_location('Leaving:'||l_proc,10);
603: --
604: end chk_ptnl_ler_trtmt_cd_seed_ler;
605: --
606: -- ----------------------------------------------------------------------------

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

654: l_api_updating boolean;
655: --
656: Begin
657: --
658: hr_utility.set_location('Entering:'||l_proc, 5);
659: --
660: -- GSP Rate Synchronization : Check if Operation Code is not null for LER type = GSP and ABSENCES
661: if p_typ_cd in ('GSP', 'ABS') and p_lf_evt_oper_cd is null then
662: --

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

755: close c1; -- GSP Rate Synchronization
756: end if;
757: end if;
758: --
759: hr_utility.set_location('Leaving:'||l_proc,10);
760: --
761: end chk_lf_evt_oper_cd;
762: -- ----------------------------------------------------------------------------
763: -- |---------------------------< chk_slctbl_slf_svc_cd >----------------------|

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

794: l_api_updating boolean;
795: --
796: Begin
797: --
798: hr_utility.set_location('Entering:'||l_proc, 5);
799: --
800: l_api_updating := ben_ler_shd.api_updating
801: (p_ler_id => p_ler_id,
802: p_effective_date => p_effective_date,

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

825: end if;
826: --
827: end if;
828: --
829: hr_utility.set_location('Leaving:'||l_proc,10);
830: --
831: end chk_slctbl_slf_svc_cd ;
832:
833: -- ----------------------------------------------------------------------------

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

878: l_table_name all_tables.table_name%TYPE;
879: --
880: Begin
881: --
882: hr_utility.set_location('Entering:'||l_proc, 5);
883: --
884: l_api_updating := ben_ler_shd.api_updating
885: (p_ler_id => p_ler_id,
886: p_effective_date => p_effective_date,

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

965: p_validation_start_date => p_validation_start_date,
966: p_validation_end_date => p_validation_end_date,
967: p_table_name => l_table_name );
968: end if;
969: hr_utility.set_location('Leaving:'||l_proc,10);
970: --
971: end chk_typ_cd;
972: --
973: -- ----------------------------------------------------------------------------

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

1005: l_api_updating boolean;
1006: --
1007: Begin
1008: --
1009: hr_utility.set_location('Entering:'||l_proc, 5);
1010: --
1011: l_api_updating := ben_ler_shd.api_updating
1012: (p_ler_id => p_ler_id,
1013: p_effective_date => p_effective_date,

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

1019: fnd_message.raise_error;
1020: --
1021: end if;
1022: --
1023: hr_utility.set_location('Leaving:'||l_proc,10);
1024: --
1025: end chk_typ_cd_not_null;
1026: --
1027: --

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

1077: l_dummy varchar2(1);
1078: --
1079: Begin
1080: --
1081: hr_utility.set_location('Entering:'||l_proc, 5);
1082: --
1083: l_api_updating := ben_ler_shd.api_updating
1084: (p_ler_id => p_ler_id,
1085: p_effective_date => p_effective_date,

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

1108: close l_csr_ler;
1109: --
1110: end if;
1111: --
1112: hr_utility.set_location('Leaving:'||l_proc,10);
1113: --
1114: end chk_irec_typ_cd_uniq_in_bg;
1115: --
1116:

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

1150: l_api_updating boolean;
1151: --
1152: Begin
1153: --
1154: hr_utility.set_location('Entering:'||l_proc, 5);
1155: --
1156: l_api_updating := ben_ler_shd.api_updating
1157: (p_ler_id => p_ler_id,
1158: p_effective_date => p_effective_date,

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

1179: end if;
1180: --
1181: end if;
1182: --
1183: hr_utility.set_location('Leaving:'||l_proc,10);
1184: --
1185: end chk_ck_rltd_per_elig_flag;
1186: -- ----------------------------------------------------------------------------
1187: -- |------< chk_cm_aply_flag >------|

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

1219: l_api_updating boolean;
1220: --
1221: Begin
1222: --
1223: hr_utility.set_location('Entering:'||l_proc, 5);
1224: --
1225: l_api_updating := ben_ler_shd.api_updating
1226: (p_ler_id => p_ler_id,
1227: p_effective_date => p_effective_date,

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

1259: fnd_message.raise_error;
1260: --
1261: end if;
1262: --
1263: hr_utility.set_location('Leaving:'||l_proc,10);
1264: --
1265: end chk_cm_aply_flag;
1266: --
1267: -- ----------------------------------------------------------------------------

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

1316: l_api_updating boolean;
1317: --
1318: Begin
1319: --
1320: hr_utility.set_location('Entering:'||l_proc, 5);
1321: --
1322: l_api_updating := ben_ler_shd.api_updating
1323: (p_ler_id => p_ler_id,
1324: p_effective_date => p_effective_date,

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

1341: close l_csr_ler;
1342:
1343: end if;
1344: --
1345: hr_utility.set_location('Leaving:'||l_proc, 10);
1346: --
1347: End chk_name;
1348: -- ----------------------------------------------------------------------------
1349: -- |------------------------< chk_ovridg_le_flag >----------------------------|

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

1382: l_api_updating boolean;
1383: --
1384: Begin
1385: --
1386: hr_utility.set_location('Entering:'||l_proc, 5);
1387: --
1388: l_api_updating := ben_ler_shd.api_updating
1389: (p_ler_id => p_ler_id,
1390: p_effective_date => p_effective_date,

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

1412: end if;
1413: --
1414: end if;
1415: --
1416: hr_utility.set_location('Leaving:'||l_proc, 10);
1417: --
1418: End chk_ovridg_le_flag;
1419: --
1420: -- ----------------------------------------------------------------------------

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

1454: l_api_updating boolean;
1455: --
1456: Begin
1457: --
1458: hr_utility.set_location('Entering:'||l_proc, 5);
1459: --
1460: l_api_updating := ben_ler_shd.api_updating
1461: (p_ler_id => p_ler_id,
1462: p_effective_date => p_effective_date,

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

1484: end if;
1485: --
1486: end if;
1487: --
1488: hr_utility.set_location('Leaving:'||l_proc, 10);
1489: --
1490: End chk_qualg_evt_flag;
1491: --
1492: -- ----------------------------------------------------------------------------

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

1524: l_api_updating boolean;
1525: --
1526: Begin
1527: --
1528: hr_utility.set_location('Entering:'||l_proc, 5);
1529: --
1530: l_api_updating := ben_ler_shd.api_updating
1531: (p_ler_id => p_ler_id,
1532: p_effective_date => p_effective_date,

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

1555: end if;
1556: --
1557: end if;
1558: --
1559: hr_utility.set_location('Leaving:'||l_proc,10);
1560: --
1561: end chk_tmlns_eval_cd;
1562: --
1563: -- ----------------------------------------------------------------------------

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

1595: l_api_updating boolean;
1596: --
1597: Begin
1598: --
1599: hr_utility.set_location('Entering:'||l_proc, 5);
1600: --
1601: l_api_updating := ben_ler_shd.api_updating
1602: (p_ler_id => p_ler_id,
1603: p_effective_date => p_effective_date,

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

1626: end if;
1627: --
1628: end if;
1629: --
1630: hr_utility.set_location('Leaving:'||l_proc,10);
1631: --
1632: end chk_tmlns_perd_cd;
1633: --
1634: -- ----------------------------------------------------------------------------

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

1667: l_api_updating boolean;
1668: --
1669: Begin
1670: --
1671: hr_utility.set_location('Entering:'||l_proc, 5);
1672: --
1673: l_api_updating := ben_ler_shd.api_updating
1674: (p_ler_id => p_ler_id,
1675: p_object_version_number => p_object_version_number,

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

1699: end if;
1700: --
1701: end if;
1702: --
1703: hr_utility.set_location('Leaving:'||l_proc,10);
1704: --
1705: end chk_tmlns_perd_rl;
1706: -- ----------------------------------------------------------------------------
1707: -- |---------------------------< chk_slf_svc_cd_qlfg_evt >----------------------|

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

1740: l_api_updating boolean;
1741: --
1742: Begin
1743: --
1744: hr_utility.set_location('Entering:'||l_proc, 5);
1745: --
1746: l_api_updating := ben_ler_shd.api_updating
1747: (p_ler_id => p_ler_id,
1748: p_effective_date => p_effective_date,

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

1770: end if;
1771: end if ;
1772: end if ;
1773: --
1774: hr_utility.set_location('Leaving:'||l_proc,10);
1775: --
1776: end chk_slf_svc_cd_qlfg_evt ;
1777: -- ----------------------------------------------------------------------------
1778: -- |--------------------------< dt_update_validate >--------------------------|

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

1813: l_integrity_error Exception;
1814: l_table_name all_tables.table_name%TYPE;
1815: --
1816: Begin
1817: hr_utility.set_location('Entering:'||l_proc, 5);
1818: --
1819: -- Ensure that the p_datetrack_mode argument is not null
1820: --
1821: hr_api.mandatory_arg_error

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

1852: End If;
1853: --
1854: End If;
1855: --
1856: hr_utility.set_location(' Leaving:'||l_proc, 10);
1857: Exception
1858: When l_integrity_error Then
1859: --
1860: -- A referential integrity check was violated therefore

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

1913: l_proc varchar2(72) := g_package||'dt_delete_validate';
1914: l_table_name all_tables.table_name%TYPE;
1915: --
1916: Begin
1917: hr_utility.set_location('Entering:'||l_proc, 5);
1918: --
1919: -- Ensure that the p_datetrack_mode argument is not null
1920: --
1921: hr_api.mandatory_arg_error

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

1962:
1963: --
1964: End If;
1965: --
1966: hr_utility.set_location(' Leaving:'||l_proc, 10);
1967: Exception
1968: WHEN hr_utility.hr_error THEN
1969: raise;
1970: When Others Then

Line 1968: WHEN hr_utility.hr_error THEN

1964: End If;
1965: --
1966: hr_utility.set_location(' Leaving:'||l_proc, 10);
1967: Exception
1968: WHEN hr_utility.hr_error THEN
1969: raise;
1970: When Others Then
1971: --
1972: -- An unhandled or unexpected error has occurred which

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

1990: --
1991: l_proc varchar2(72) := g_package||'insert_validate';
1992: --
1993: Begin
1994: hr_utility.set_location('Entering:'||l_proc, 5);
1995: --
1996: -- Call all supporting business operations
1997: --
1998: --

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

2131: p_qualg_evt_flag => p_rec.qualg_evt_flag,
2132: p_effective_date => p_effective_date,
2133: p_object_version_number => p_rec.object_version_number) ;
2134: --
2135: hr_utility.set_location(' Leaving:'||l_proc, 10);
2136: End insert_validate;
2137: --
2138: -- ----------------------------------------------------------------------------
2139: -- |---------------------------< update_validate >----------------------------|

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

2147: --
2148: l_proc varchar2(72) := g_package||'update_validate';
2149: --
2150: Begin
2151: hr_utility.set_location('Entering:'||l_proc, 5);
2152: --
2153: -- Call all supporting business operations
2154: --
2155: --

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

2290: p_datetrack_mode => p_datetrack_mode,
2291: p_validation_start_date => p_validation_start_date,
2292: p_validation_end_date => p_validation_end_date);
2293: --
2294: hr_utility.set_location(' Leaving:'||l_proc, 10);
2295: End update_validate;
2296: --
2297: -- ----------------------------------------------------------------------------
2298: -- |---------------------------< delete_validate >----------------------------|

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

2306: --
2307: l_proc varchar2(72) := g_package||'delete_validate';
2308: --
2309: Begin
2310: hr_utility.set_location('Entering:'||l_proc, 5);
2311: --
2312: -- Call all supporting business operations
2313: --
2314: dt_delete_validate

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

2316: p_validation_start_date => p_validation_start_date,
2317: p_validation_end_date => p_validation_end_date,
2318: p_ler_id => p_rec.ler_id);
2319: --
2320: hr_utility.set_location(' Leaving:'||l_proc, 10);
2321: End delete_validate;
2322: --
2323: --
2324: -- ---------------------------------------------------------------------------

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

2343: l_proc varchar2(72) := g_package||'return_legislation_code';
2344: --
2345: begin
2346: --
2347: hr_utility.set_location('Entering:'|| l_proc, 10);
2348: --
2349: -- Ensure that all the mandatory parameter are not null
2350: --
2351: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

2368: end if;
2369: --
2370: close csr_leg_code;
2371: --
2372: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2373: --
2374: return l_legislation_code;
2375: --
2376: end return_legislation_code;