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

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

38: l_proc varchar2(72) := g_package||' chk_wait_perd_value ';
39: --
40: Begin
41: --
42: hr_utility.set_location('Entering:'||l_proc, 5);
43: --
44: /* DENISE IS THINKING ABOUT THIS RULE AND CHECKING CRUD FOR PGMDE
45: if p_wait_perd_val is not null and p_prtn_eff_strt_dt_rl is null then
46: --

Line 47: hr_utility.set_message(801,'wait_perd_eff_strt_rl');

43: --
44: /* DENISE IS THINKING ABOUT THIS RULE AND CHECKING CRUD FOR PGMDE
45: if p_wait_perd_val is not null and p_prtn_eff_strt_dt_rl is null then
46: --
47: hr_utility.set_message(801,'wait_perd_eff_strt_rl');
48: hr_utility.raise_error;
49: --
50: end if;
51: */

Line 48: hr_utility.raise_error;

44: /* DENISE IS THINKING ABOUT THIS RULE AND CHECKING CRUD FOR PGMDE
45: if p_wait_perd_val is not null and p_prtn_eff_strt_dt_rl is null then
46: --
47: hr_utility.set_message(801,'wait_perd_eff_strt_rl');
48: hr_utility.raise_error;
49: --
50: end if;
51: */
52: --

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

49: --
50: end if;
51: */
52: --
53: hr_utility.set_location('Leaving:'||l_proc, 15);
54: --
55: End chk_wait_perd_value;
56: --
57: -- ----------------------------------------------------------------------------

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

87: l_proc varchar2(72) := g_package||'chk_prtn_eff_strt_dt_cd_rl';
88: --
89: Begin
90: --
91: hr_utility.set_location('Entering:'||l_proc, 5);
92: --
93: -- check dependency of Code and Rule.
94: --
95: if (p_prtn_eff_strt_dt_cd <> 'RL' and

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

109: end if;
110: --
111: -- Leaving Procedure.
112: --
113: hr_utility.set_location('Leaving:'||l_proc,10);
114: --
115: end chk_prtn_eff_strt_dt_cd_rl;
116: --
117: -- ----------------------------------------------------------------------------

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

147: l_proc varchar2(72) := g_package||'chk_prtn_eff_end_dt_cd_rl';
148: --
149: Begin
150: --
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: --
153: -- check dependency of Code and Rule.
154: --
155: if (p_prtn_eff_end_dt_cd <> 'RL' and

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

169: end if;
170: --
171: -- Leaving Procedure.
172: --
173: hr_utility.set_location('Leaving:'||l_proc,10);
174: --
175: end chk_prtn_eff_end_dt_cd_rl;
176: --
177: -- ----------------------------------------------------------------------------

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

209: l_api_updating boolean;
210: --
211: Begin
212: --
213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: l_api_updating := ben_epa_shd.api_updating
216: (p_effective_date => p_effective_date,
217: p_prtn_elig_id => p_prtn_elig_id,

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

238: end if;
239: --
240: end if;
241: --
242: hr_utility.set_location('Leaving:'||l_proc, 10);
243: --
244: End chk_prtn_elig_id;
245: --
246: -- ----------------------------------------------------------------------------

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

295: and ff.effective_end_date;
296: --
297: Begin
298: --
299: hr_utility.set_location('Entering:'||l_proc, 5);
300: --
301: l_api_updating := ben_epa_shd.api_updating
302: (p_prtn_elig_id => p_prtn_elig_id,
303: 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_prtn_eff_end_dt_rl;
340: --
341: -- ----------------------------------------------------------------------------

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

391: and ff.effective_end_date;
392: --
393: Begin
394: --
395: hr_utility.set_location('Entering:'||l_proc, 5);
396: --
397: l_api_updating := ben_epa_shd.api_updating
398: (p_prtn_elig_id => p_prtn_elig_id,
399: p_effective_date => p_effective_date,

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

429: close c1;
430: --
431: end if;
432: --
433: hr_utility.set_location('Leaving:'||l_proc,10);
434: --
435: end chk_prtn_eff_strt_dt_rl;
436: --
437: -- ----------------------------------------------------------------------------

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

469: l_api_updating boolean;
470: --
471: Begin
472: --
473: hr_utility.set_location('Entering:'||l_proc, 5);
474: --
475: l_api_updating := ben_epa_shd.api_updating
476: (p_prtn_elig_id => p_prtn_elig_id,
477: p_effective_date => p_effective_date,

Line 495: hr_utility.set_message(801,'prtn_eff_end_dt_cd');

491: p_effective_date => p_effective_date) then
492: --
493: -- raise error as does not exist as lookup
494: --
495: hr_utility.set_message(801,'prtn_eff_end_dt_cd');
496: hr_utility.raise_error;
497: --
498: end if;
499: --

Line 496: hr_utility.raise_error;

492: --
493: -- raise error as does not exist as lookup
494: --
495: hr_utility.set_message(801,'prtn_eff_end_dt_cd');
496: hr_utility.raise_error;
497: --
498: end if;
499: --
500: end if;

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

498: end if;
499: --
500: end if;
501: --
502: hr_utility.set_location('Leaving:'||l_proc,10);
503: --
504: end chk_prtn_eff_end_dt_cd;
505: --
506: -- ----------------------------------------------------------------------------

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

538: l_api_updating boolean;
539: --
540: Begin
541: --
542: hr_utility.set_location('Entering:'||l_proc, 5);
543: --
544: l_api_updating := ben_epa_shd.api_updating
545: (p_prtn_elig_id => p_prtn_elig_id,
546: p_effective_date => p_effective_date,

Line 564: hr_utility.set_message(801,'prtn_eff_strt_dt_cd');

560: p_effective_date => p_effective_date) then
561: --
562: -- raise error as does not exist as lookup
563: --
564: hr_utility.set_message(801,'prtn_eff_strt_dt_cd');
565: hr_utility.raise_error;
566: --
567: end if;
568: --

Line 565: hr_utility.raise_error;

561: --
562: -- raise error as does not exist as lookup
563: --
564: hr_utility.set_message(801,'prtn_eff_strt_dt_cd');
565: hr_utility.raise_error;
566: --
567: end if;
568: --
569: end if;

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

567: end if;
568: --
569: end if;
570: --
571: hr_utility.set_location('Leaving:'||l_proc,10);
572: --
573: end chk_prtn_eff_strt_dt_cd;
574: --
575: -- ----------------------------------------------------------------------------

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

609: l_api_updating boolean;
610: --
611: Begin
612: --
613: hr_utility.set_location('Entering:'||l_proc, 5);
614: --
615: l_api_updating := ben_epa_shd.api_updating
616: (p_prtn_elig_id => p_prtn_elig_id,
617: p_effective_date => p_effective_date,

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

643: end if;
644: --
645: end if;
646: --
647: hr_utility.set_location('Leaving:'||l_proc,10);
648: --
649: end chk_wait_perd_dt_to_use_cd;
650: --
651: -- ----------------------------------------------------------------------------

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

686: l_api_updating boolean;
687: --
688: Begin
689: --
690: hr_utility.set_location('Entering:'||l_proc, 5);
691: --
692: l_api_updating := ben_epa_shd.api_updating
693: (p_effective_date => p_effective_date,
694: p_prtn_elig_id => p_prtn_elig_id,

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

718: end if;
719: --
720: end if;
721: --
722: hr_utility.set_location('Leaving:'||l_proc,10);
723: --
724: end chk_wait_perd_dt_to_use_rl;
725: --
726: -- ----------------------------------------------------------------------------

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

758: l_api_updating boolean;
759: --
760: Begin
761: --
762: hr_utility.set_location('Entering:'||l_proc, 5);
763: --
764: l_api_updating := ben_epa_shd.api_updating
765: (p_prtn_elig_id => p_prtn_elig_id,
766: p_effective_date => p_effective_date,

Line 784: hr_utility.set_message(801,'wait_perd_uom');

780: p_effective_date => p_effective_date) then
781: --
782: -- raise error as does not exist as lookup
783: --
784: hr_utility.set_message(801,'wait_perd_uom');
785: hr_utility.raise_error;
786: --
787: end if;
788: --

Line 785: hr_utility.raise_error;

781: --
782: -- raise error as does not exist as lookup
783: --
784: hr_utility.set_message(801,'wait_perd_uom');
785: hr_utility.raise_error;
786: --
787: end if;
788: --
789: end if;

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

787: end if;
788: --
789: end if;
790: --
791: hr_utility.set_location('Leaving:'||l_proc,10);
792: --
793: end chk_wait_perd_uom;
794: --
795: -- ----------------------------------------------------------------------------

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

830: l_api_updating boolean;
831: --
832: Begin
833: --
834: hr_utility.set_location('Entering:'||l_proc, 5);
835: --
836: l_api_updating := ben_epa_shd.api_updating
837: (p_effective_date => p_effective_date,
838: p_prtn_elig_id => p_prtn_elig_id,

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

862: end if;
863: --
864: end if;
865: --
866: hr_utility.set_location('Leaving:'||l_proc,10);
867: --
868: end chk_wait_perd_rl;
869: --
870: -- ----------------------------------------------------------------------------

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

905: l_api_updating boolean;
906: --
907: Begin
908: --
909: hr_utility.set_location('Entering:'||l_proc, 5);
910: --
911: l_api_updating := ben_epa_shd.api_updating
912: (p_effective_date => p_effective_date,
913: p_prtn_elig_id => p_prtn_elig_id,

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

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

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

980: l_api_updating boolean;
981: --
982: Begin
983: --
984: hr_utility.set_location('Entering:'||l_proc, 5);
985: --
986: l_api_updating := ben_epa_shd.api_updating
987: (p_effective_date => p_effective_date,
988: p_prtn_elig_id => p_prtn_elig_id,

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

1013: --
1014: --
1015: end if;
1016: --
1017: hr_utility.set_location('Leaving:'||l_proc,10);
1018: --
1019: end chk_mx_poe_rl;
1020: --
1021: -- ----------------------------------------------------------------------------

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

1055: l_api_updating boolean;
1056: --
1057: Begin
1058: --
1059: hr_utility.set_location('Entering:'||l_proc, 5);
1060: --
1061: l_api_updating := ben_epa_shd.api_updating
1062: (p_prtn_elig_id => p_prtn_elig_id,
1063: p_effective_date => p_effective_date,

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

1086: end if;
1087: --
1088: end if;
1089: --
1090: hr_utility.set_location('Leaving:'||l_proc,10);
1091: --
1092: end chk_mx_poe_apls_cd;
1093: --
1094: -- ----------------------------------------------------------------------------

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

1128: l_api_updating boolean;
1129: --
1130: Begin
1131: --
1132: hr_utility.set_location('Entering:'||l_proc, 5);
1133: --
1134: l_api_updating := ben_epa_shd.api_updating
1135: (p_prtn_elig_id => p_prtn_elig_id,
1136: p_effective_date => p_effective_date,

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

1159: end if;
1160: --
1161: end if;
1162: --
1163: hr_utility.set_location('Leaving:'||l_proc,10);
1164: --
1165: end chk_mx_poe_uom;
1166: --
1167: -- ----------------------------------------------------------------------------

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

1201: l_api_updating boolean;
1202: --
1203: Begin
1204: --
1205: hr_utility.set_location('Entering:'||l_proc, 5);
1206: --
1207: l_api_updating := ben_epa_shd.api_updating
1208: (p_prtn_elig_id => p_prtn_elig_id,
1209: p_effective_date => p_effective_date,

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

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

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

1289: end count_them;
1290: --
1291: Begin
1292: --
1293: hr_utility.set_location('Entering:'||l_proc, 5);
1294: --
1295: -- Check to ensure that only one of the FK's is populated.
1296: --
1297: if count_them(p_oipl_id) +

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

1304: fnd_message.raise_error;
1305: --
1306: end if;
1307: --
1308: hr_utility.set_location('Leaving:'||l_proc,10);
1309: --
1310: end chk_only_one_fk;
1311: --
1312: -- ----------------------------------------------------------------------------

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

1358: --
1359: --
1360: Begin
1361: --
1362: hr_utility.set_location('Entering:'||l_proc,5);
1363: --
1364: l_api_updating := ben_epa_shd.api_updating
1365: (p_prtn_elig_id => p_prtn_elig_id,
1366: p_effective_date => p_effective_date,

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

1388: --
1389: end if;
1390: --
1391: end if;
1392: hr_utility.set_location('Leaving:'||l_proc,10);
1393: --
1394: End chk_pgm_id;
1395: --
1396: -- ----------------------------------------------------------------------------

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

1442: --
1443: --
1444: Begin
1445: --
1446: hr_utility.set_location('Entering:'||l_proc,5);
1447: --
1448: l_api_updating := ben_epa_shd.api_updating
1449: (p_prtn_elig_id => p_prtn_elig_id,
1450: p_effective_date => p_effective_date,

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

1472: --
1473: end if;
1474: --
1475: end if;
1476: hr_utility.set_location('Leaving:'||l_proc,10);
1477: --
1478: End chk_pl_id;
1479: --
1480: -- ----------------------------------------------------------------------------

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

1526: --
1527: --
1528: Begin
1529: --
1530: hr_utility.set_location('Entering:'||l_proc,5);
1531: --
1532: l_api_updating := ben_epa_shd.api_updating
1533: (p_prtn_elig_id => p_prtn_elig_id,
1534: p_effective_date => p_effective_date,

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

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

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

1609: and p_validation_end_date >= effective_start_date;
1610: --
1611: Begin
1612: --
1613: hr_utility.set_location('Entering:'||l_proc,5);
1614: --
1615: l_api_updating := ben_epa_shd.api_updating
1616: (p_prtn_elig_id => p_prtn_elig_id,
1617: p_effective_date => p_effective_date,

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

1643: end if;
1644: --
1645: end if;
1646: --
1647: hr_utility.set_location('Leaving:'||l_proc,10);
1648: --
1649: End chk_ptip_id;
1650: -- ----------------------------------------------------------------------------
1651: -- |--------------------------------< chk_plip_id >---------------------------|

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

1695: and p_validation_end_date >= effective_start_date;
1696: --
1697: Begin
1698: --
1699: hr_utility.set_location('Entering:'||l_proc,5);
1700: --
1701: l_api_updating := ben_epa_shd.api_updating
1702: (p_prtn_elig_id => p_prtn_elig_id,
1703: p_effective_date => p_effective_date,

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

1729: end if;
1730: --
1731: end if;
1732: --
1733: hr_utility.set_location('Leaving:'||l_proc,10);
1734: --
1735: End chk_plip_id;
1736: --
1737: -- ----------------------------------------------------------------------------

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

1779: l_integrity_error Exception;
1780: l_table_name all_tables.table_name%TYPE;
1781: --
1782: Begin
1783: hr_utility.set_location('Entering:'||l_proc, 5);
1784: --
1785: -- Ensure that the p_datetrack_mode argument is not null
1786: --
1787: hr_api.mandatory_arg_error

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

1868: End If;
1869: --
1870: End If;
1871: --
1872: hr_utility.set_location(' Leaving:'||l_proc, 10);
1873: Exception
1874: When l_integrity_error Then
1875: --
1876: -- A referential integrity check was violated therefore

Line 1879: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');

1875: --
1876: -- A referential integrity check was violated therefore
1877: -- we must error
1878: --
1879: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1880: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1881: hr_utility.raise_error;
1882: When Others Then
1883: --

Line 1880: hr_utility.set_message_token('TABLE_NAME', l_table_name);

1876: -- A referential integrity check was violated therefore
1877: -- we must error
1878: --
1879: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1880: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1881: hr_utility.raise_error;
1882: When Others Then
1883: --
1884: -- An unhandled or unexpected error has occurred which

Line 1881: hr_utility.raise_error;

1877: -- we must error
1878: --
1879: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1880: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1881: hr_utility.raise_error;
1882: When Others Then
1883: --
1884: -- An unhandled or unexpected error has occurred which
1885: -- we must report

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

1883: --
1884: -- An unhandled or unexpected error has occurred which
1885: -- we must report
1886: --
1887: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1888: hr_utility.set_message_token('PROCEDURE', l_proc);
1889: hr_utility.set_message_token('STEP','15');
1890: hr_utility.raise_error;
1891: End dt_update_validate;

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

1884: -- An unhandled or unexpected error has occurred which
1885: -- we must report
1886: --
1887: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1888: hr_utility.set_message_token('PROCEDURE', l_proc);
1889: hr_utility.set_message_token('STEP','15');
1890: hr_utility.raise_error;
1891: End dt_update_validate;
1892: --

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

1885: -- we must report
1886: --
1887: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1888: hr_utility.set_message_token('PROCEDURE', l_proc);
1889: hr_utility.set_message_token('STEP','15');
1890: hr_utility.raise_error;
1891: End dt_update_validate;
1892: --
1893: -- ----------------------------------------------------------------------------

Line 1890: hr_utility.raise_error;

1886: --
1887: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1888: hr_utility.set_message_token('PROCEDURE', l_proc);
1889: hr_utility.set_message_token('STEP','15');
1890: hr_utility.raise_error;
1891: End dt_update_validate;
1892: --
1893: -- ----------------------------------------------------------------------------
1894: -- |--------------------------< dt_delete_validate >--------------------------|

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

1935: l_rows_exist Exception;
1936: l_table_name all_tables.table_name%TYPE;
1937: --
1938: Begin
1939: hr_utility.set_location('Entering:'||l_proc, 5);
1940: --
1941: -- Ensure that the p_datetrack_mode argument is not null
1942: --
1943: hr_api.mandatory_arg_error

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

1989: End If;
1990: --
1991: End If;
1992: --
1993: hr_utility.set_location(' Leaving:'||l_proc, 10);
1994: Exception
1995: When l_rows_exist Then
1996: --
1997: -- A referential integrity check was violated therefore

Line 2000: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');

1996: --
1997: -- A referential integrity check was violated therefore
1998: -- we must error
1999: --
2000: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
2001: hr_utility.set_message_token('TABLE_NAME', l_table_name);
2002: hr_utility.raise_error;
2003: When Others Then
2004: --

Line 2001: hr_utility.set_message_token('TABLE_NAME', l_table_name);

1997: -- A referential integrity check was violated therefore
1998: -- we must error
1999: --
2000: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
2001: hr_utility.set_message_token('TABLE_NAME', l_table_name);
2002: hr_utility.raise_error;
2003: When Others Then
2004: --
2005: -- An unhandled or unexpected error has occurred which

Line 2002: hr_utility.raise_error;

1998: -- we must error
1999: --
2000: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
2001: hr_utility.set_message_token('TABLE_NAME', l_table_name);
2002: hr_utility.raise_error;
2003: When Others Then
2004: --
2005: -- An unhandled or unexpected error has occurred which
2006: -- we must report

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

2004: --
2005: -- An unhandled or unexpected error has occurred which
2006: -- we must report
2007: --
2008: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2009: hr_utility.set_message_token('PROCEDURE', l_proc);
2010: hr_utility.set_message_token('STEP','15');
2011: hr_utility.raise_error;
2012: End dt_delete_validate;

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

2005: -- An unhandled or unexpected error has occurred which
2006: -- we must report
2007: --
2008: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2009: hr_utility.set_message_token('PROCEDURE', l_proc);
2010: hr_utility.set_message_token('STEP','15');
2011: hr_utility.raise_error;
2012: End dt_delete_validate;
2013: --

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

2006: -- we must report
2007: --
2008: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2009: hr_utility.set_message_token('PROCEDURE', l_proc);
2010: hr_utility.set_message_token('STEP','15');
2011: hr_utility.raise_error;
2012: End dt_delete_validate;
2013: --
2014: -- ----------------------------------------------------------------------------

Line 2011: hr_utility.raise_error;

2007: --
2008: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2009: hr_utility.set_message_token('PROCEDURE', l_proc);
2010: hr_utility.set_message_token('STEP','15');
2011: hr_utility.raise_error;
2012: End dt_delete_validate;
2013: --
2014: -- ----------------------------------------------------------------------------
2015: -- |---------------------------< insert_validate >----------------------------|

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

2023: --
2024: l_proc varchar2(72) := g_package||'insert_validate';
2025: --
2026: Begin
2027: hr_utility.set_location('Entering:'||l_proc, 5);
2028: --
2029: -- Call all supporting business operations
2030: --
2031: --

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

2183: p_effective_date => p_effective_date,
2184: p_business_group_id => p_rec.business_group_id,
2185: p_object_version_number => p_rec.object_version_number);
2186: --
2187: hr_utility.set_location(' Leaving:'||l_proc, 10);
2188: --
2189: End insert_validate;
2190: --
2191: -- ----------------------------------------------------------------------------

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

2201: --
2202: l_proc varchar2(72) := g_package||'update_validate';
2203: --
2204: Begin
2205: hr_utility.set_location('Entering:'||l_proc, 5);
2206: --
2207: -- Call all supporting business operations
2208: --
2209: --

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

2374: p_datetrack_mode => p_datetrack_mode,
2375: p_validation_start_date => p_validation_start_date,
2376: p_validation_end_date => p_validation_end_date);
2377: --
2378: hr_utility.set_location(' Leaving:'||l_proc, 10);
2379: End update_validate;
2380: --
2381: -- ----------------------------------------------------------------------------
2382: -- |---------------------------< delete_validate >----------------------------|

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

2390: --
2391: l_proc varchar2(72) := g_package||'delete_validate';
2392: --
2393: Begin
2394: hr_utility.set_location('Entering:'||l_proc, 5);
2395: --
2396: -- Call all supporting business operations
2397: --
2398: dt_delete_validate

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

2400: p_validation_start_date => p_validation_start_date,
2401: p_validation_end_date => p_validation_end_date,
2402: p_prtn_elig_id => p_rec.prtn_elig_id);
2403: --
2404: hr_utility.set_location(' Leaving:'||l_proc, 10);
2405: End delete_validate;
2406: --
2407: --
2408: -- ---------------------------------------------------------------------------

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

2427: l_proc varchar2(72) := g_package||'return_legislation_code';
2428: --
2429: begin
2430: --
2431: hr_utility.set_location('Entering:'|| l_proc, 10);
2432: --
2433: -- Ensure that all the mandatory parameter are not null
2434: --
2435: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

2445: close csr_leg_code;
2446: --
2447: -- The primary key is invalid therefore we must error
2448: --
2449: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
2450: hr_utility.raise_error;
2451: --
2452: end if;
2453: --

Line 2450: hr_utility.raise_error;

2446: --
2447: -- The primary key is invalid therefore we must error
2448: --
2449: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
2450: hr_utility.raise_error;
2451: --
2452: end if;
2453: --
2454: close csr_leg_code;

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

2452: end if;
2453: --
2454: close csr_leg_code;
2455: --
2456: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2457: --
2458: return l_legislation_code;
2459: --
2460: end return_legislation_code;