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_PDP_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_pdp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_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_elig_cvrd_dpnt_id;
78:
79: --

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

105: l_api_updating boolean;
106: --
107: Begin
108: --
109: hr_utility.set_location('Entering:'||l_proc, 5);
110: --
111: l_api_updating := ben_pdp_shd.api_updating
112: (p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id,
113: p_effective_date => p_effective_date,

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

136: end if;
137: --
138: end if;
139: --
140: hr_utility.set_location('Leaving:'||l_proc,10);
141: --
142: end chk_ovrdn_flag;
143:
144: -- ---------------------------------------------------------------------------

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

169: l_api_updating boolean;
170: --
171: Begin
172: --
173: hr_utility.set_location('Entering:'||l_proc, 5);
174: --
175: l_api_updating := ben_pdp_shd.api_updating
176: (p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id,
177: p_effective_date => p_effective_date,

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

200: end if;
201: --
202: end if;
203: --
204: hr_utility.set_location('Leaving:'||l_proc,10);
205: --
206: end chk_cvg_pndg_flag;
207: --
208: -- ----------------------------------------------------------------------------

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

236: l_proc varchar2(72) := g_package||'chk_cvg_dates';
237: --
238: Begin
239: --
240: hr_utility.set_location('Entering:'||l_proc,5);
241: --
242: if p_cvg_strt_dt is not null and p_cvg_thru_dt is not null and
243: p_cvg_strt_dt > p_cvg_thru_dt then
244: --

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

249: --
250: --
251: end if;
252: --
253: hr_utility.set_location('Leaving:'||l_proc,10);
254: --
255: end chk_cvg_dates;
256: --
257: --

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

323: ;
324: --
325: Begin
326: --
327: hr_utility.set_location('Entering:'||l_proc,5);
328: --
329: l_api_updating := ben_pdp_shd.api_updating
330: (p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id,
331: p_effective_date => p_effective_date,

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

370: end if;
371: --
372: end if;
373: --
374: hr_utility.set_location('Leaving:'||l_proc,10);
375: --
376: End chk_dpnt_person_id;
377: --
378: --

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

427: ;
428: --
429: Begin
430: --
431: hr_utility.set_location('Entering:'||l_proc,5);
432: --
433: l_api_updating := ben_pdp_shd.api_updating
434: (p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id,
435: p_effective_date => p_effective_date,

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

461: --
462: --
463: end if;
464: --
465: hr_utility.set_location('Leaving:'||l_proc,10);
466: --
467: End chk_prtt_enrt_rslt_id;
468: --
469: --

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

653: --
654:
655: Begin
656: --
657: hr_utility.set_location('Entering:'||l_proc,5);
658: --
659:
660: l_api_updating := ben_pdp_shd.api_updating
661: (p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id,

Line 675: hr_utility.set_location('open info1_c :'||l_proc,10);

671: (not l_api_updating or
672: ben_pdp_shd.g_old_rec.cvg_strt_dt = null)
673: then
674: --
675: hr_utility.set_location('open info1_c :'||l_proc,10);
676: --
677: open info1_c;
678: --
679: fetch info1_c into l_person_id

Line 718: hr_utility.set_location('Leaving:'||l_proc,99);

714: end if;
715: end if;
716: end if;
717: --
718: hr_utility.set_location('Leaving:'||l_proc,99);
719: --
720: end chk_max_num_dpnt;
721:
722: --

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

766: and crc.crt_ordr_id = crt.crt_ordr_id;
767: --
768: Begin
769: --
770: hr_utility.set_location('Entering:'||l_proc, 5);
771: --
772: --
773: if p_cvg_thru_dt <> hr_api.g_eot then
774: --

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

793: close c1;
794: --
795: end if;
796: --
797: hr_utility.set_location('Leaving:'||l_proc,10);
798: --
799: end chk_crt_ordr;
800: --
801: -- ---------------------------------------------------------------------------

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

1037: l_cobra_pgm BOOLEAN := FALSE;
1038: --
1039: BEGIN
1040: --
1041: hr_utility.set_location ('Entering:' || l_proc, 5);
1042: --
1043: hr_utility.set_location ('Checking court order at PDP level : ' || p_prtt_enrt_Rslt_id, 12);
1044: --
1045: IF p_prtt_enrt_rslt_id IS NOT NULL

Line 1043: hr_utility.set_location ('Checking court order at PDP level : ' || p_prtt_enrt_Rslt_id, 12);

1039: BEGIN
1040: --
1041: hr_utility.set_location ('Entering:' || l_proc, 5);
1042: --
1043: hr_utility.set_location ('Checking court order at PDP level : ' || p_prtt_enrt_Rslt_id, 12);
1044: --
1045: IF p_prtt_enrt_rslt_id IS NOT NULL
1046: THEN
1047: --

Line 1102: hr_utility.set_location ('Level = ' || l_level, 40);

1098: END IF;
1099: --
1100: -- Retrieve designation code
1101: --
1102: hr_utility.set_location ('Level = ' || l_level, 40);
1103: --
1104: IF l_level = 'PGM'
1105: THEN
1106: --

Line 1157: hr_utility.set_location ('dsgn code = ' || l_code, 40);

1153: l_code := NULL;
1154: --
1155: END IF;
1156: --
1157: hr_utility.set_location ('dsgn code = ' || l_code, 40);
1158: --
1159: IF l_code IS NOT NULL AND
1160: NOT l_cobra_pgm
1161: THEN

Line 1188: hr_utility.set_location('ACE l_lf_evt_ocrd_dt = ' || l_lf_evt_ocrd_dt, 9999);

1184: --
1185: CLOSE c_lf_evt_ocrd_dt;
1186: --
1187: /*
1188: hr_utility.set_location('ACE l_lf_evt_ocrd_dt = ' || l_lf_evt_ocrd_dt, 9999);
1189: hr_utility.set_location('ACE rslt_enrt_cvg_strt_dt = ' || rslt_enrt_cvg_strt_dt, 9999);
1190: hr_utility.set_location('ACE p_prtt_enrt_rslt_id = ' || p_prtt_enrt_rslt_id, 9999);
1191: hr_utility.set_location('ACE p_effective_date = ' || p_effective_date, 9999);
1192: */

Line 1189: hr_utility.set_location('ACE rslt_enrt_cvg_strt_dt = ' || rslt_enrt_cvg_strt_dt, 9999);

1185: CLOSE c_lf_evt_ocrd_dt;
1186: --
1187: /*
1188: hr_utility.set_location('ACE l_lf_evt_ocrd_dt = ' || l_lf_evt_ocrd_dt, 9999);
1189: hr_utility.set_location('ACE rslt_enrt_cvg_strt_dt = ' || rslt_enrt_cvg_strt_dt, 9999);
1190: hr_utility.set_location('ACE p_prtt_enrt_rslt_id = ' || p_prtt_enrt_rslt_id, 9999);
1191: hr_utility.set_location('ACE p_effective_date = ' || p_effective_date, 9999);
1192: */
1193:

Line 1190: hr_utility.set_location('ACE p_prtt_enrt_rslt_id = ' || p_prtt_enrt_rslt_id, 9999);

1186: --
1187: /*
1188: hr_utility.set_location('ACE l_lf_evt_ocrd_dt = ' || l_lf_evt_ocrd_dt, 9999);
1189: hr_utility.set_location('ACE rslt_enrt_cvg_strt_dt = ' || rslt_enrt_cvg_strt_dt, 9999);
1190: hr_utility.set_location('ACE p_prtt_enrt_rslt_id = ' || p_prtt_enrt_rslt_id, 9999);
1191: hr_utility.set_location('ACE p_effective_date = ' || p_effective_date, 9999);
1192: */
1193:
1194: OPEN c_crt_ordr;

Line 1191: hr_utility.set_location('ACE p_effective_date = ' || p_effective_date, 9999);

1187: /*
1188: hr_utility.set_location('ACE l_lf_evt_ocrd_dt = ' || l_lf_evt_ocrd_dt, 9999);
1189: hr_utility.set_location('ACE rslt_enrt_cvg_strt_dt = ' || rslt_enrt_cvg_strt_dt, 9999);
1190: hr_utility.set_location('ACE p_prtt_enrt_rslt_id = ' || p_prtt_enrt_rslt_id, 9999);
1191: hr_utility.set_location('ACE p_effective_date = ' || p_effective_date, 9999);
1192: */
1193:
1194: OPEN c_crt_ordr;
1195: --

Line 1206: hr_utility.set_location('Court Order Found', 9999);

1202: l_crt_ordr_typ_cd;
1203: --
1204: EXIT WHEN c_crt_ordr%NOTFOUND;
1205: --
1206: hr_utility.set_location('Court Order Found', 9999);
1207: /*
1208: hr_utility.set_location ('dpnt name = ' || l_name, 40);
1209: hr_utility.set_location ('type = ' || l_contact_type, 40);
1210: hr_utility.set_location ('dpnt id = ' || l_dpnt_id, 40);

Line 1208: hr_utility.set_location ('dpnt name = ' || l_name, 40);

1204: EXIT WHEN c_crt_ordr%NOTFOUND;
1205: --
1206: hr_utility.set_location('Court Order Found', 9999);
1207: /*
1208: hr_utility.set_location ('dpnt name = ' || l_name, 40);
1209: hr_utility.set_location ('type = ' || l_contact_type, 40);
1210: hr_utility.set_location ('dpnt id = ' || l_dpnt_id, 40);
1211: */
1212: --

Line 1209: hr_utility.set_location ('type = ' || l_contact_type, 40);

1205: --
1206: hr_utility.set_location('Court Order Found', 9999);
1207: /*
1208: hr_utility.set_location ('dpnt name = ' || l_name, 40);
1209: hr_utility.set_location ('type = ' || l_contact_type, 40);
1210: hr_utility.set_location ('dpnt id = ' || l_dpnt_id, 40);
1211: */
1212: --
1213: OPEN c_elig_dpnt;

Line 1210: hr_utility.set_location ('dpnt id = ' || l_dpnt_id, 40);

1206: hr_utility.set_location('Court Order Found', 9999);
1207: /*
1208: hr_utility.set_location ('dpnt name = ' || l_name, 40);
1209: hr_utility.set_location ('type = ' || l_contact_type, 40);
1210: hr_utility.set_location ('dpnt id = ' || l_dpnt_id, 40);
1211: */
1212: --
1213: OPEN c_elig_dpnt;
1214: --

Line 1220: hr_utility.set_location('C_ELIG_DPNT Returned No Rows', 9999);

1216: --
1217: IF c_elig_dpnt%NOTFOUND
1218: THEN
1219: --
1220: hr_utility.set_location('C_ELIG_DPNT Returned No Rows', 9999);
1221: --
1222: l_crt_ordr_meaning := hr_general.decode_lookup
1223: (p_lookup_type => 'BEN_CRT_ORDR_TYP',
1224: p_lookup_code => l_crt_ordr_typ_cd

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

1248: CLOSE c_rslt;
1249: --
1250: END IF;
1251:
1252: hr_utility.set_location ('Leaving:' || l_proc, 10);
1253: END crt_ordr_warning;
1254:
1255: -- ---------------------------------------------------------------------------
1256: -- |------------------------< crt_ordr_warning_ss >----------------------------|

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

1345: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;
1346: --
1347: Begin
1348: --
1349: hr_utility.set_location('Entering:'||l_proc, 5);
1350: --
1351: open c_person_id;
1352: fetch c_person_id into l_person_id;
1353: close c_person_id;

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

1362: ,p_person_id => l_person_id
1363: );
1364: end if;
1365: --
1366: hr_utility.set_location('Leaving:'||l_proc,10);
1367: --
1368: end chk_dpnt_strt_end_dt;
1369: --
1370: ----Bug#5088571*/

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

1407: l_integrity_error Exception;
1408: l_table_name all_tables.table_name%TYPE;
1409: --
1410: Begin
1411: hr_utility.set_location('Entering:'||l_proc, 5);
1412: --
1413: -- Ensure that the p_datetrack_mode argument is not null
1414: --
1415: hr_api.mandatory_arg_error

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

1448: */
1449: --
1450: End If;
1451: --
1452: hr_utility.set_location(' Leaving:'||l_proc, 10);
1453: Exception
1454: When l_integrity_error Then
1455: --
1456: -- A referential integrity check was violated therefore

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

1516: l_rows_exist Exception;
1517: l_table_name all_tables.table_name%TYPE;
1518: --
1519: Begin
1520: hr_utility.set_location('Entering:'||l_proc, 5);
1521: --
1522: -- Ensure that the p_datetrack_mode argument is not null
1523: --
1524: hr_api.mandatory_arg_error

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

1561: End If;
1562: --
1563: End If;
1564: --
1565: hr_utility.set_location(' Leaving:'||l_proc, 10);
1566: Exception
1567: When l_rows_exist Then
1568: --
1569: -- A referential integrity check was violated therefore

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

1595: --
1596: l_proc varchar2(72) := g_package||'insert_validate';
1597: --
1598: Begin
1599: hr_utility.set_location('Entering:'||l_proc, 5);
1600: --
1601: -- Call all supporting business operations
1602: --
1603: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

1668: (p_cvg_strt_dt => p_rec.cvg_strt_dt,
1669: p_cvg_thru_dt => p_rec.cvg_thru_dt,
1670: p_prtt_enrt_rslt_id => p_rec.prtt_enrt_rslt_id); */
1671: --
1672: hr_utility.set_location(' Leaving:'||l_proc, 10);
1673: --
1674: End insert_validate;
1675: --
1676: -- ----------------------------------------------------------------------------

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

1685: --
1686: l_proc varchar2(72) := g_package||'update_validate';
1687: --
1688: Begin
1689: hr_utility.set_location('Entering:'||l_proc, 5);
1690: --
1691: -- Call all supporting business operations
1692: --
1693: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

1770: (p_cvg_strt_dt => p_rec.cvg_strt_dt,
1771: p_cvg_thru_dt => p_rec.cvg_thru_dt,
1772: p_prtt_enrt_rslt_id => p_rec.prtt_enrt_rslt_id); */
1773: --
1774: hr_utility.set_location(' Leaving:'||l_proc, 10);
1775: End update_validate;
1776: --
1777: -- ----------------------------------------------------------------------------
1778: -- |---------------------------< delete_validate >----------------------------|

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

1787: --
1788: l_proc varchar2(72) := g_package||'delete_validate';
1789: --
1790: Begin
1791: hr_utility.set_location('Entering:'||l_proc, 5);
1792: --
1793: -- Call all supporting business operations
1794: --
1795: dt_delete_validate

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

1806: p_effective_date => p_effective_date,
1807: p_business_group_id => p_rec.business_group_id);
1808: */
1809: --
1810: hr_utility.set_location(' Leaving:'||l_proc, 10);
1811: --
1812: End delete_validate;
1813: --
1814: --

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

1834: l_proc varchar2(72) := g_package||'return_legislation_code';
1835: --
1836: begin
1837: --
1838: hr_utility.set_location('Entering:'|| l_proc, 10);
1839: --
1840: -- Ensure that all the mandatory parameter are not null
1841: --
1842: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1859: end if;
1860: --
1861: close csr_leg_code;
1862: --
1863: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1864: --
1865: return l_legislation_code;
1866: --
1867: end return_legislation_code;