DBA Data[Home] [Help]

APPS.BEN_EPA_BUS dependencies on HR_API

Line 221: and nvl(p_prtn_elig_id,hr_api.g_number)

217: p_prtn_elig_id => p_prtn_elig_id,
218: p_object_version_number => p_object_version_number);
219: --
220: if (l_api_updating
221: and nvl(p_prtn_elig_id,hr_api.g_number)
222: <> ben_epa_shd.g_old_rec.prtn_elig_id) then
223: --
224: -- raise error as PK has changed
225: --

Line 307: and nvl(p_prtn_eff_end_dt_rl,hr_api.g_number)

303: p_effective_date => p_effective_date,
304: p_object_version_number => p_object_version_number);
305: --
306: if (l_api_updating
307: and nvl(p_prtn_eff_end_dt_rl,hr_api.g_number)
308: <> ben_epa_shd.g_old_rec.prtn_eff_end_dt_rl
309: or not l_api_updating)
310: and p_prtn_eff_end_dt_rl is not null then
311: --

Line 403: and nvl(p_prtn_eff_strt_dt_rl,hr_api.g_number)

399: p_effective_date => p_effective_date,
400: p_object_version_number => p_object_version_number);
401: --
402: if (l_api_updating
403: and nvl(p_prtn_eff_strt_dt_rl,hr_api.g_number)
404: <> ben_epa_shd.g_old_rec.prtn_eff_strt_dt_rl
405: or not l_api_updating)
406: and p_prtn_eff_strt_dt_rl is not null then
407: --

Line 482: <> nvl(ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd,hr_api.g_varchar2)

478: p_object_version_number => p_object_version_number);
479: --
480: if (l_api_updating
481: and p_prtn_eff_end_dt_cd
482: <> nvl(ben_epa_shd.g_old_rec.prtn_eff_end_dt_cd,hr_api.g_varchar2)
483: or not l_api_updating)
484: and p_prtn_eff_end_dt_cd is not null then
485: --
486: -- check if value of lookup falls within lookup type.

Line 488: if hr_api.not_exists_in_hr_lookups

484: and p_prtn_eff_end_dt_cd is not null then
485: --
486: -- check if value of lookup falls within lookup type.
487: --
488: if hr_api.not_exists_in_hr_lookups
489: (p_lookup_type => 'BEN_PRTN_ELIG_END',
490: p_lookup_code => p_prtn_eff_end_dt_cd,
491: p_effective_date => p_effective_date) then
492: --

Line 551: <> nvl(ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd,hr_api.g_varchar2)

547: p_object_version_number => p_object_version_number);
548: --
549: if (l_api_updating
550: and p_prtn_eff_strt_dt_cd
551: <> nvl(ben_epa_shd.g_old_rec.prtn_eff_strt_dt_cd,hr_api.g_varchar2)
552: or not l_api_updating)
553: and p_prtn_eff_strt_dt_cd is not null then
554: --
555: -- check if value of lookup falls within lookup type.

Line 557: if hr_api.not_exists_in_hr_lookups

553: and p_prtn_eff_strt_dt_cd is not null then
554: --
555: -- check if value of lookup falls within lookup type.
556: --
557: if hr_api.not_exists_in_hr_lookups
558: (p_lookup_type => 'BEN_PRTN_ELIG_STRT',
559: p_lookup_code => p_prtn_eff_strt_dt_cd,
560: p_effective_date => p_effective_date) then
561: --

Line 622: <> nvl(ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd,hr_api.g_varchar2)

618: p_object_version_number => p_object_version_number);
619: --
620: if (l_api_updating
621: and p_wait_perd_dt_to_use_cd
622: <> nvl(ben_epa_shd.g_old_rec.wait_perd_dt_to_use_cd,hr_api.g_varchar2)
623: or not l_api_updating) and
624: p_wait_perd_dt_to_use_cd is not null
625: then
626: --

Line 630: if hr_api.not_exists_in_hr_lookups

626: --
627: -- check if value of lookup falls within lookup type.
628: --
629:
630: if hr_api.not_exists_in_hr_lookups
631: (p_lookup_type => 'BEN_MX_WTG_DT_TO_USE'
632: ,p_lookup_code => p_wait_perd_dt_to_use_cd
633: ,p_effective_date => p_effective_date)
634: then

Line 698: and nvl(p_wait_perd_dt_to_use_rl,hr_api.g_number)

694: p_prtn_elig_id => p_prtn_elig_id,
695: p_object_version_number => p_object_version_number);
696: --
697: if (l_api_updating
698: and nvl(p_wait_perd_dt_to_use_rl,hr_api.g_number)
699: <> ben_epa_shd.g_old_rec.wait_perd_dt_to_use_rl
700: or not l_api_updating)
701: and p_wait_perd_dt_to_use_rl is not null then
702: --

Line 771: <> nvl(ben_epa_shd.g_old_rec.wait_perd_uom,hr_api.g_varchar2)

767: p_object_version_number => p_object_version_number);
768: --
769: if (l_api_updating
770: and p_wait_perd_uom
771: <> nvl(ben_epa_shd.g_old_rec.wait_perd_uom,hr_api.g_varchar2)
772: or not l_api_updating)
773: and p_wait_perd_uom is not null then
774: --
775: -- check if value of lookup falls within lookup type.

Line 777: if hr_api.not_exists_in_hr_lookups

773: and p_wait_perd_uom is not null then
774: --
775: -- check if value of lookup falls within lookup type.
776: --
777: if hr_api.not_exists_in_hr_lookups
778: (p_lookup_type => 'BEN_TM_UOM',
779: p_lookup_code => p_wait_perd_uom,
780: p_effective_date => p_effective_date) then
781: --

Line 842: and nvl(p_wait_perd_rl,hr_api.g_number)

838: p_prtn_elig_id => p_prtn_elig_id,
839: p_object_version_number => p_object_version_number);
840: --
841: if (l_api_updating
842: and nvl(p_wait_perd_rl,hr_api.g_number)
843: <> ben_epa_shd.g_old_rec.wait_perd_rl
844: or not l_api_updating)
845: and p_wait_perd_rl is not null then
846: --

Line 917: and nvl(p_mx_poe_det_dt_rl,hr_api.g_number)

913: p_prtn_elig_id => p_prtn_elig_id,
914: p_object_version_number => p_object_version_number);
915: --
916: if (l_api_updating
917: and nvl(p_mx_poe_det_dt_rl,hr_api.g_number)
918: <> ben_epa_shd.g_old_rec.mx_poe_det_dt_rl
919: or not l_api_updating)
920: and p_mx_poe_det_dt_rl is not null then
921: --

Line 992: and nvl(p_mx_poe_rl,hr_api.g_number)

988: p_prtn_elig_id => p_prtn_elig_id,
989: p_object_version_number => p_object_version_number);
990: --
991: if (l_api_updating
992: and nvl(p_mx_poe_rl,hr_api.g_number)
993: <> ben_epa_shd.g_old_rec.mx_poe_rl
994: or not l_api_updating)
995: and p_mx_poe_rl is not null then
996: --

Line 1068: <> nvl(ben_epa_shd.g_old_rec.mx_poe_apls_cd,hr_api.g_varchar2)

1064: p_object_version_number => p_object_version_number);
1065: --
1066: if (l_api_updating
1067: and p_mx_poe_apls_cd
1068: <> nvl(ben_epa_shd.g_old_rec.mx_poe_apls_cd,hr_api.g_varchar2)
1069: or not l_api_updating)
1070: and p_mx_poe_apls_cd is not null then
1071: --
1072: -- check if value of lookup falls within lookup type.

Line 1074: if hr_api.not_exists_in_hr_lookups

1070: and p_mx_poe_apls_cd is not null then
1071: --
1072: -- check if value of lookup falls within lookup type.
1073: --
1074: if hr_api.not_exists_in_hr_lookups
1075: (p_lookup_type => 'BEN_MX_POE_APLS',
1076: p_lookup_code => p_mx_poe_apls_cd,
1077: p_effective_date => p_effective_date) then
1078: --

Line 1141: <> nvl(ben_epa_shd.g_old_rec.mx_poe_uom,hr_api.g_varchar2)

1137: p_object_version_number => p_object_version_number);
1138: --
1139: if (l_api_updating
1140: and p_mx_poe_uom
1141: <> nvl(ben_epa_shd.g_old_rec.mx_poe_uom,hr_api.g_varchar2)
1142: or not l_api_updating)
1143: and p_mx_poe_uom is not null then
1144: --
1145: -- check if value of lookup falls within lookup type.

Line 1147: if hr_api.not_exists_in_hr_lookups

1143: and p_mx_poe_uom is not null then
1144: --
1145: -- check if value of lookup falls within lookup type.
1146: --
1147: if hr_api.not_exists_in_hr_lookups
1148: (p_lookup_type => 'BEN_RQD_PERD_ENRT_NENRT_TM_UOM',
1149: p_lookup_code => p_mx_poe_uom,
1150: p_effective_date => p_effective_date) then
1151: --

Line 1214: <> nvl(ben_epa_shd.g_old_rec.mx_poe_det_dt_cd,hr_api.g_varchar2)

1210: p_object_version_number => p_object_version_number);
1211: --
1212: if (l_api_updating
1213: and p_mx_poe_det_dt_cd
1214: <> nvl(ben_epa_shd.g_old_rec.mx_poe_det_dt_cd,hr_api.g_varchar2)
1215: or not l_api_updating)
1216: and p_mx_poe_det_dt_cd is not null then
1217: --
1218: -- check if value of lookup falls within lookup type.

Line 1220: if hr_api.not_exists_in_hr_lookups

1216: and p_mx_poe_det_dt_cd is not null then
1217: --
1218: -- check if value of lookup falls within lookup type.
1219: --
1220: if hr_api.not_exists_in_hr_lookups
1221: (p_lookup_type => 'BEN_MX_POE_DET_DT',
1222: p_lookup_code => p_mx_poe_det_dt_cd,
1223: p_effective_date => p_effective_date) then
1224: --

Line 1354: and prtn_elig_id <> nvl(p_prtn_elig_id, hr_api.g_number)

1350: cursor c1 is
1351: select null
1352: from ben_prtn_elig_f
1353: where pgm_id = p_pgm_id
1354: and prtn_elig_id <> nvl(p_prtn_elig_id, hr_api.g_number)
1355: and business_group_id + 0 = p_business_group_id
1356: and p_validation_start_date <= effective_end_date
1357: and p_validation_end_date >= effective_start_date;
1358: --

Line 1371: and nvl(p_pgm_id, hr_api.g_number)

1367: p_object_version_number => p_object_version_number);
1368: --
1369: if p_pgm_id is not null then
1370: if (l_api_updating
1371: and nvl(p_pgm_id, hr_api.g_number)
1372: <> nvl(ben_epa_shd.g_old_rec.pgm_id, hr_api.g_number)
1373: or not l_api_updating) then
1374: --
1375: --

Line 1372: <> nvl(ben_epa_shd.g_old_rec.pgm_id, hr_api.g_number)

1368: --
1369: if p_pgm_id is not null then
1370: if (l_api_updating
1371: and nvl(p_pgm_id, hr_api.g_number)
1372: <> nvl(ben_epa_shd.g_old_rec.pgm_id, hr_api.g_number)
1373: or not l_api_updating) then
1374: --
1375: --
1376: open c1;

Line 1438: and prtn_elig_id <> nvl(p_prtn_elig_id, hr_api.g_number)

1434: cursor c1 is
1435: select null
1436: from ben_prtn_elig_f
1437: where pl_id = p_pl_id
1438: and prtn_elig_id <> nvl(p_prtn_elig_id, hr_api.g_number)
1439: and business_group_id + 0 = p_business_group_id
1440: and p_validation_start_date <= effective_end_date
1441: and p_validation_end_date >= effective_start_date;
1442: --

Line 1455: and nvl(p_pl_id, hr_api.g_number)

1451: p_object_version_number => p_object_version_number);
1452: --
1453: if p_pl_id is not null then
1454: if (l_api_updating
1455: and nvl(p_pl_id, hr_api.g_number)
1456: <> nvl(ben_epa_shd.g_old_rec.pl_id, hr_api.g_number)
1457: or not l_api_updating) then
1458: --
1459: --

Line 1456: <> nvl(ben_epa_shd.g_old_rec.pl_id, hr_api.g_number)

1452: --
1453: if p_pl_id is not null then
1454: if (l_api_updating
1455: and nvl(p_pl_id, hr_api.g_number)
1456: <> nvl(ben_epa_shd.g_old_rec.pl_id, hr_api.g_number)
1457: or not l_api_updating) then
1458: --
1459: --
1460: open c1;

Line 1522: and prtn_elig_id <> nvl(p_prtn_elig_id, hr_api.g_number)

1518: cursor c1 is
1519: select null
1520: from ben_prtn_elig_f
1521: where oipl_id = p_oipl_id
1522: and prtn_elig_id <> nvl(p_prtn_elig_id, hr_api.g_number)
1523: and business_group_id + 0 = p_business_group_id
1524: and p_validation_start_date <= effective_end_date
1525: and p_validation_end_date >= effective_start_date;
1526: --

Line 1539: and nvl(p_oipl_id, hr_api.g_number)

1535: p_object_version_number => p_object_version_number);
1536: --
1537: if p_oipl_id is not null then
1538: if (l_api_updating
1539: and nvl(p_oipl_id, hr_api.g_number)
1540: <> nvl(ben_epa_shd.g_old_rec.oipl_id, hr_api.g_number)
1541: or not l_api_updating) then
1542: --
1543: --

Line 1540: <> nvl(ben_epa_shd.g_old_rec.oipl_id, hr_api.g_number)

1536: --
1537: if p_oipl_id is not null then
1538: if (l_api_updating
1539: and nvl(p_oipl_id, hr_api.g_number)
1540: <> nvl(ben_epa_shd.g_old_rec.oipl_id, hr_api.g_number)
1541: or not l_api_updating) then
1542: --
1543: --
1544: open c1;

Line 1606: and prtn_elig_id <> nvl(p_prtn_elig_id, hr_api.g_number)

1602: cursor c1 is
1603: select null
1604: from ben_prtn_elig_f
1605: where ptip_id = p_ptip_id
1606: and prtn_elig_id <> nvl(p_prtn_elig_id, hr_api.g_number)
1607: and business_group_id+0 = p_business_group_id
1608: and p_validation_start_date <= effective_end_date
1609: and p_validation_end_date >= effective_start_date;
1610: --

Line 1623: and nvl(p_ptip_id,hr_api.g_number)

1619: --
1620: if p_ptip_id is not null then
1621: --
1622: if (l_api_updating
1623: and nvl(p_ptip_id,hr_api.g_number)
1624: <> nvl(ben_epa_shd.g_old_rec.ptip_id,hr_api.g_number)
1625: or not l_api_updating) then
1626: --
1627: open c1;

Line 1624: <> nvl(ben_epa_shd.g_old_rec.ptip_id,hr_api.g_number)

1620: if p_ptip_id is not null then
1621: --
1622: if (l_api_updating
1623: and nvl(p_ptip_id,hr_api.g_number)
1624: <> nvl(ben_epa_shd.g_old_rec.ptip_id,hr_api.g_number)
1625: or not l_api_updating) then
1626: --
1627: open c1;
1628: --

Line 1692: and prtn_elig_id <> nvl(p_prtn_elig_id, hr_api.g_number)

1688: cursor c1 is
1689: select null
1690: from ben_prtn_elig_f
1691: where plip_id = p_plip_id
1692: and prtn_elig_id <> nvl(p_prtn_elig_id, hr_api.g_number)
1693: and business_group_id+0 = p_business_group_id
1694: and p_validation_start_date <= effective_end_date
1695: and p_validation_end_date >= effective_start_date;
1696: --

Line 1709: and nvl(p_plip_id,hr_api.g_number)

1705: --
1706: if p_plip_id is not null then
1707: --
1708: if (l_api_updating
1709: and nvl(p_plip_id,hr_api.g_number)
1710: <> nvl(ben_epa_shd.g_old_rec.plip_id,hr_api.g_number)
1711: or not l_api_updating) then
1712: --
1713: open c1;

Line 1710: <> nvl(ben_epa_shd.g_old_rec.plip_id,hr_api.g_number)

1706: if p_plip_id is not null then
1707: --
1708: if (l_api_updating
1709: and nvl(p_plip_id,hr_api.g_number)
1710: <> nvl(ben_epa_shd.g_old_rec.plip_id,hr_api.g_number)
1711: or not l_api_updating) then
1712: --
1713: open c1;
1714: --

Line 1767: (p_prtn_eff_end_dt_rl in number default hr_api.g_number,

1763: --
1764: -- {End Of Comments}
1765: -- ----------------------------------------------------------------------------
1766: Procedure dt_update_validate
1767: (p_prtn_eff_end_dt_rl in number default hr_api.g_number,
1768: p_oipl_id in number default hr_api.g_number,
1769: p_pl_id in number default hr_api.g_number,
1770: p_pgm_id in number default hr_api.g_number,
1771: p_ptip_id in number default hr_api.g_number,

Line 1768: p_oipl_id in number default hr_api.g_number,

1764: -- {End Of Comments}
1765: -- ----------------------------------------------------------------------------
1766: Procedure dt_update_validate
1767: (p_prtn_eff_end_dt_rl in number default hr_api.g_number,
1768: p_oipl_id in number default hr_api.g_number,
1769: p_pl_id in number default hr_api.g_number,
1770: p_pgm_id in number default hr_api.g_number,
1771: p_ptip_id in number default hr_api.g_number,
1772: p_plip_id in number default hr_api.g_number,

Line 1769: p_pl_id in number default hr_api.g_number,

1765: -- ----------------------------------------------------------------------------
1766: Procedure dt_update_validate
1767: (p_prtn_eff_end_dt_rl in number default hr_api.g_number,
1768: p_oipl_id in number default hr_api.g_number,
1769: p_pl_id in number default hr_api.g_number,
1770: p_pgm_id in number default hr_api.g_number,
1771: p_ptip_id in number default hr_api.g_number,
1772: p_plip_id in number default hr_api.g_number,
1773: p_datetrack_mode in varchar2,

Line 1770: p_pgm_id in number default hr_api.g_number,

1766: Procedure dt_update_validate
1767: (p_prtn_eff_end_dt_rl in number default hr_api.g_number,
1768: p_oipl_id in number default hr_api.g_number,
1769: p_pl_id in number default hr_api.g_number,
1770: p_pgm_id in number default hr_api.g_number,
1771: p_ptip_id in number default hr_api.g_number,
1772: p_plip_id in number default hr_api.g_number,
1773: p_datetrack_mode in varchar2,
1774: p_validation_start_date in date,

Line 1771: p_ptip_id in number default hr_api.g_number,

1767: (p_prtn_eff_end_dt_rl in number default hr_api.g_number,
1768: p_oipl_id in number default hr_api.g_number,
1769: p_pl_id in number default hr_api.g_number,
1770: p_pgm_id in number default hr_api.g_number,
1771: p_ptip_id in number default hr_api.g_number,
1772: p_plip_id in number default hr_api.g_number,
1773: p_datetrack_mode in varchar2,
1774: p_validation_start_date in date,
1775: p_validation_end_date in date)

Line 1772: p_plip_id in number default hr_api.g_number,

1768: p_oipl_id in number default hr_api.g_number,
1769: p_pl_id in number default hr_api.g_number,
1770: p_pgm_id in number default hr_api.g_number,
1771: p_ptip_id in number default hr_api.g_number,
1772: p_plip_id in number default hr_api.g_number,
1773: p_datetrack_mode in varchar2,
1774: p_validation_start_date in date,
1775: p_validation_end_date in date)
1776: Is

Line 1787: hr_api.mandatory_arg_error

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
1788: (p_api_name => l_proc,
1789: p_argument => 'datetrack_mode',
1790: p_argument_value => p_datetrack_mode);
1791: --

Line 1799: hr_api.mandatory_arg_error

1795: --
1796: --
1797: -- Ensure the arguments are not null
1798: --
1799: hr_api.mandatory_arg_error
1800: (p_api_name => l_proc,
1801: p_argument => 'validation_start_date',
1802: p_argument_value => p_validation_start_date);
1803: --

Line 1804: hr_api.mandatory_arg_error

1800: (p_api_name => l_proc,
1801: p_argument => 'validation_start_date',
1802: p_argument_value => p_validation_start_date);
1803: --
1804: hr_api.mandatory_arg_error
1805: (p_api_name => l_proc,
1806: p_argument => 'validation_end_date',
1807: p_argument_value => p_validation_end_date);
1808: --

Line 1809: If ((nvl(p_prtn_eff_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and

1805: (p_api_name => l_proc,
1806: p_argument => 'validation_end_date',
1807: p_argument_value => p_validation_end_date);
1808: --
1809: If ((nvl(p_prtn_eff_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
1810: NOT (dt_api.check_min_max_dates
1811: (p_base_table_name => 'ff_formulas_f',
1812: p_base_key_column => 'formula_id',
1813: p_base_key_value => p_prtn_eff_end_dt_rl,

Line 1819: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and

1815: p_to_date => p_validation_end_date))) Then
1816: l_table_name := 'ff_formulas_f';
1817: Raise l_integrity_error;
1818: End If;
1819: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
1820: NOT (dt_api.check_min_max_dates
1821: (p_base_table_name => 'ben_oipl_f',
1822: p_base_key_column => 'oipl_id',
1823: p_base_key_value => p_oipl_id,

Line 1829: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

1825: p_to_date => p_validation_end_date))) Then
1826: l_table_name := 'ben_oipl_f';
1827: Raise l_integrity_error;
1828: End If;
1829: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
1830: NOT (dt_api.check_min_max_dates
1831: (p_base_table_name => 'ben_pl_f',
1832: p_base_key_column => 'pl_id',
1833: p_base_key_value => p_pl_id,

Line 1839: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and

1835: p_to_date => p_validation_end_date))) Then
1836: l_table_name := 'ben_pl_f';
1837: Raise l_integrity_error;
1838: End If;
1839: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
1840: NOT (dt_api.check_min_max_dates
1841: (p_base_table_name => 'ben_pgm_f',
1842: p_base_key_column => 'pgm_id',
1843: p_base_key_value => p_pgm_id,

Line 1849: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and

1845: p_to_date => p_validation_end_date))) Then
1846: l_table_name := 'ben_pgm_f';
1847: Raise l_integrity_error;
1848: End If;
1849: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
1850: NOT (dt_api.check_min_max_dates
1851: (p_base_table_name => 'ben_ptip_f',
1852: p_base_key_column => 'ptip_id',
1853: p_base_key_value => p_ptip_id,

Line 1859: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and

1855: p_to_date => p_validation_end_date))) Then
1856: l_table_name := 'ben_ptip_f';
1857: Raise l_integrity_error;
1858: End If;
1859: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
1860: NOT (dt_api.check_min_max_dates
1861: (p_base_table_name => 'ben_plip_f',
1862: p_base_key_column => 'plip_id',
1863: p_base_key_value => p_plip_id,

Line 1943: hr_api.mandatory_arg_error

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
1944: (p_api_name => l_proc,
1945: p_argument => 'datetrack_mode',
1946: p_argument_value => p_datetrack_mode);
1947: --

Line 1957: hr_api.mandatory_arg_error

1953: --
1954: --
1955: -- Ensure the arguments are not null
1956: --
1957: hr_api.mandatory_arg_error
1958: (p_api_name => l_proc,
1959: p_argument => 'validation_start_date',
1960: p_argument_value => p_validation_start_date);
1961: --

Line 1962: hr_api.mandatory_arg_error

1958: (p_api_name => l_proc,
1959: p_argument => 'validation_start_date',
1960: p_argument_value => p_validation_start_date);
1961: --
1962: hr_api.mandatory_arg_error
1963: (p_api_name => l_proc,
1964: p_argument => 'validation_end_date',
1965: p_argument_value => p_validation_end_date);
1966: --

Line 1967: hr_api.mandatory_arg_error

1963: (p_api_name => l_proc,
1964: p_argument => 'validation_end_date',
1965: p_argument_value => p_validation_end_date);
1966: --
1967: hr_api.mandatory_arg_error
1968: (p_api_name => l_proc,
1969: p_argument => 'prtn_elig_id',
1970: p_argument_value => p_prtn_elig_id);
1971: --

Line 2032: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

2028: --
2029: -- Call all supporting business operations
2030: --
2031: --
2032: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2033: --
2034: chk_prtn_elig_id
2035: (p_prtn_elig_id => p_rec.prtn_elig_id,
2036: p_effective_date => p_effective_date,

Line 2210: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

2206: --
2207: -- Call all supporting business operations
2208: --
2209: --
2210: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2211: --
2212: chk_prtn_elig_id
2213: (p_prtn_elig_id => p_rec.prtn_elig_id,
2214: p_effective_date => p_effective_date,

Line 2435: hr_api.mandatory_arg_error(p_api_name => l_proc,

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,
2436: p_argument => 'prtn_elig_id',
2437: p_argument_value => p_prtn_elig_id);
2438: --
2439: open csr_leg_code;