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_BPP_BUS dependencies on HR_API

Line 54: and nvl(p_bnft_prvdr_pool_id,hr_api.g_number)

50: p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_bnft_prvdr_pool_id,hr_api.g_number)
55: <> ben_bpp_shd.g_old_rec.bnft_prvdr_pool_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 118: Where a.bnft_prvdr_pool_id <> nvl(p_bnft_prvdr_pool_id,hr_api.g_number)

114: l_dummy char(1);
115: l_api_updating boolean;
116: cursor c1 is select null
117: from ben_bnft_prvdr_pool_f a
118: Where a.bnft_prvdr_pool_id <> nvl(p_bnft_prvdr_pool_id,hr_api.g_number)
119: and a.name = p_name
120: and a.business_group_id + 0 = p_business_group_id
121: and p_effective_date
122: between a.effective_start_date

Line 134: and nvl(p_name,hr_api.g_varchar2)

130: p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
131: p_object_version_number => p_object_version_number);
132: --
133: if (l_api_updating
134: and nvl(p_name,hr_api.g_varchar2)
135: <> ben_pln_shd.g_old_rec.name
136: or not l_api_updating) then
137: --
138: open c1;

Line 444: (nvl(p_pct_rndg_cd,hr_api.g_varchar2)

440: p_object_version_number => p_object_version_number);
441: --
442: if (l_api_updating
443: and
444: (nvl(p_pct_rndg_cd,hr_api.g_varchar2)
445: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or
446: nvl(p_pct_rndg_rl,hr_api.g_number)
447: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))
448: or not l_api_updating) then

Line 445: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or

441: --
442: if (l_api_updating
443: and
444: (nvl(p_pct_rndg_cd,hr_api.g_varchar2)
445: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or
446: nvl(p_pct_rndg_rl,hr_api.g_number)
447: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))
448: or not l_api_updating) then
449: --

Line 446: nvl(p_pct_rndg_rl,hr_api.g_number)

442: if (l_api_updating
443: and
444: (nvl(p_pct_rndg_cd,hr_api.g_varchar2)
445: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or
446: nvl(p_pct_rndg_rl,hr_api.g_number)
447: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))
448: or not l_api_updating) then
449: --
450: if (p_pct_rndg_cd = 'RL' and p_pct_rndg_rl is null) then

Line 447: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))

443: and
444: (nvl(p_pct_rndg_cd,hr_api.g_varchar2)
445: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2) or
446: nvl(p_pct_rndg_rl,hr_api.g_number)
447: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_rl,hr_api.g_number))
448: or not l_api_updating) then
449: --
450: if (p_pct_rndg_cd = 'RL' and p_pct_rndg_rl is null) then
451: --

Line 457: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then

453: fnd_message.raise_error;
454: --
455: end if;
456: --
457: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then
458: --
459: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
460: fnd_message.raise_error;
461: --

Line 520: (nvl(p_val_rndg_cd,hr_api.g_varchar2)

516: p_object_version_number => p_object_version_number);
517: --
518: if (l_api_updating
519: and
520: (nvl(p_val_rndg_cd,hr_api.g_varchar2)
521: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or
522: nvl(p_val_rndg_rl,hr_api.g_number)
523: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_rl,hr_api.g_number))
524: or not l_api_updating) then

Line 521: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or

517: --
518: if (l_api_updating
519: and
520: (nvl(p_val_rndg_cd,hr_api.g_varchar2)
521: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or
522: nvl(p_val_rndg_rl,hr_api.g_number)
523: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_rl,hr_api.g_number))
524: or not l_api_updating) then
525: --

Line 522: nvl(p_val_rndg_rl,hr_api.g_number)

518: if (l_api_updating
519: and
520: (nvl(p_val_rndg_cd,hr_api.g_varchar2)
521: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or
522: nvl(p_val_rndg_rl,hr_api.g_number)
523: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_rl,hr_api.g_number))
524: or not l_api_updating) then
525: --
526: if (p_val_rndg_cd = 'RL' and p_val_rndg_rl is null) then

Line 523: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_rl,hr_api.g_number))

519: and
520: (nvl(p_val_rndg_cd,hr_api.g_varchar2)
521: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2) or
522: nvl(p_val_rndg_rl,hr_api.g_number)
523: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_rl,hr_api.g_number))
524: or not l_api_updating) then
525: --
526: if (p_val_rndg_cd = 'RL' and p_val_rndg_rl is null) then
527: --

Line 533: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then

529: fnd_message.raise_error;
530: --
531: end if;
532: --
533: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then
534: --
535: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
536: fnd_message.raise_error;
537: --

Line 607: and nvl(p_val_rndg_rl,hr_api.g_number)

603: p_effective_date => p_effective_date,
604: p_object_version_number => p_object_version_number);
605: --
606: if (l_api_updating
607: and nvl(p_val_rndg_rl,hr_api.g_number)
608: <> ben_bpp_shd.g_old_rec.val_rndg_rl
609: or not l_api_updating)
610: and p_val_rndg_rl is not null then
611: --

Line 686: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2)

682: p_object_version_number => p_object_version_number);
683: --
684: if (l_api_updating
685: and p_val_rndg_cd
686: <> nvl(ben_bpp_shd.g_old_rec.val_rndg_cd,hr_api.g_varchar2)
687: or not l_api_updating)
688: and p_val_rndg_cd is not null then
689: --
690: -- check if value of lookup falls within lookup type.

Line 692: if hr_api.not_exists_in_hr_lookups

688: and p_val_rndg_cd is not null then
689: --
690: -- check if value of lookup falls within lookup type.
691: --
692: if hr_api.not_exists_in_hr_lookups
693: (p_lookup_type => 'BEN_RNDG',
694: p_lookup_code => p_val_rndg_cd,
695: p_effective_date => p_effective_date) then
696: --

Line 773: and nvl(p_pct_rndg_rl,hr_api.g_number)

769: p_effective_date => p_effective_date,
770: p_object_version_number => p_object_version_number);
771: --
772: if (l_api_updating
773: and nvl(p_pct_rndg_rl,hr_api.g_number)
774: <> ben_bpp_shd.g_old_rec.pct_rndg_rl
775: or not l_api_updating)
776: and p_pct_rndg_rl is not null then
777: --

Line 852: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2)

848: p_object_version_number => p_object_version_number);
849: --
850: if (l_api_updating
851: and p_pct_rndg_cd
852: <> nvl(ben_bpp_shd.g_old_rec.pct_rndg_cd,hr_api.g_varchar2)
853: or not l_api_updating)
854: and p_pct_rndg_cd is not null then
855: --
856: -- check if value of lookup falls within lookup type.

Line 858: if hr_api.not_exists_in_hr_lookups

854: and p_pct_rndg_cd is not null then
855: --
856: -- check if value of lookup falls within lookup type.
857: --
858: if hr_api.not_exists_in_hr_lookups
859: (p_lookup_type => 'BEN_RNDG',
860: p_lookup_code => p_pct_rndg_cd,
861: p_effective_date => p_effective_date) then
862: --

Line 923: <> nvl(ben_bpp_shd.g_old_rec.pgm_pool_flag,hr_api.g_varchar2)

919: p_object_version_number => p_object_version_number);
920: --
921: if (l_api_updating
922: and p_pgm_pool_flag
923: <> nvl(ben_bpp_shd.g_old_rec.pgm_pool_flag,hr_api.g_varchar2)
924: or not l_api_updating) then
925: --
926: -- check if value of lookup falls within lookup type.
927: --

Line 929: if hr_api.not_exists_in_hr_lookups

925: --
926: -- check if value of lookup falls within lookup type.
927: --
928: --
929: if hr_api.not_exists_in_hr_lookups
930: (p_lookup_type => 'YES_NO',
931: p_lookup_code => p_pgm_pool_flag,
932: p_effective_date => p_effective_date) then
933: --

Line 992: <> nvl(ben_bpp_shd.g_old_rec.no_mn_dstrbl_pct_flag,hr_api.g_varchar2)

988: p_object_version_number => p_object_version_number);
989: --
990: if (l_api_updating
991: and p_no_mn_dstrbl_pct_flag
992: <> nvl(ben_bpp_shd.g_old_rec.no_mn_dstrbl_pct_flag,hr_api.g_varchar2)
993: or not l_api_updating) then
994: --
995: -- check if value of lookup falls within lookup type.
996: --

Line 998: if hr_api.not_exists_in_hr_lookups

994: --
995: -- check if value of lookup falls within lookup type.
996: --
997: --
998: if hr_api.not_exists_in_hr_lookups
999: (p_lookup_type => 'YES_NO',
1000: p_lookup_code => p_no_mn_dstrbl_pct_flag,
1001: p_effective_date => p_effective_date) then
1002: --

Line 1061: <> nvl(ben_bpp_shd.g_old_rec.no_mx_dstrbl_pct_flag,hr_api.g_varchar2)

1057: p_object_version_number => p_object_version_number);
1058: --
1059: if (l_api_updating
1060: and p_no_mx_dstrbl_pct_flag
1061: <> nvl(ben_bpp_shd.g_old_rec.no_mx_dstrbl_pct_flag,hr_api.g_varchar2)
1062: or not l_api_updating) then
1063: --
1064: -- check if value of lookup falls within lookup type.
1065: --

Line 1067: if hr_api.not_exists_in_hr_lookups

1063: --
1064: -- check if value of lookup falls within lookup type.
1065: --
1066: --
1067: if hr_api.not_exists_in_hr_lookups
1068: (p_lookup_type => 'YES_NO',
1069: p_lookup_code => p_no_mx_dstrbl_pct_flag,
1070: p_effective_date => p_effective_date) then
1071: --

Line 1130: <> nvl(ben_bpp_shd.g_old_rec.no_mn_dstrbl_val_flag,hr_api.g_varchar2)

1126: p_object_version_number => p_object_version_number);
1127: --
1128: if (l_api_updating
1129: and p_no_mn_dstrbl_val_flag
1130: <> nvl(ben_bpp_shd.g_old_rec.no_mn_dstrbl_val_flag,hr_api.g_varchar2)
1131: or not l_api_updating) then
1132: --
1133: -- check if value of lookup falls within lookup type.
1134: --

Line 1136: if hr_api.not_exists_in_hr_lookups

1132: --
1133: -- check if value of lookup falls within lookup type.
1134: --
1135: --
1136: if hr_api.not_exists_in_hr_lookups
1137: (p_lookup_type => 'YES_NO',
1138: p_lookup_code => p_no_mn_dstrbl_val_flag,
1139: p_effective_date => p_effective_date) then
1140: --

Line 1199: <> nvl(ben_bpp_shd.g_old_rec.no_mx_dstrbl_val_flag,hr_api.g_varchar2)

1195: p_object_version_number => p_object_version_number);
1196: --
1197: if (l_api_updating
1198: and p_no_mx_dstrbl_val_flag
1199: <> nvl(ben_bpp_shd.g_old_rec.no_mx_dstrbl_val_flag,hr_api.g_varchar2)
1200: or not l_api_updating) then
1201: --
1202: -- check if value of lookup falls within lookup type.
1203: --

Line 1205: if hr_api.not_exists_in_hr_lookups

1201: --
1202: -- check if value of lookup falls within lookup type.
1203: --
1204: --
1205: if hr_api.not_exists_in_hr_lookups
1206: (p_lookup_type => 'YES_NO',
1207: p_lookup_code => p_no_mx_dstrbl_val_flag,
1208: p_effective_date => p_effective_date) then
1209: --

Line 1270: <> nvl(ben_bpp_shd.g_old_rec.auto_alct_excs_flag,hr_api.g_varchar2)

1266: hr_utility.set_location('auto_alct_excs_flag:'||p_auto_alct_excs_flag, 5);
1267: --
1268: if (l_api_updating
1269: and p_auto_alct_excs_flag
1270: <> nvl(ben_bpp_shd.g_old_rec.auto_alct_excs_flag,hr_api.g_varchar2)
1271: or not l_api_updating) then
1272: --
1273: -- check if value of lookup falls within lookup type.
1274: --

Line 1276: if hr_api.not_exists_in_hr_lookups

1272: --
1273: -- check if value of lookup falls within lookup type.
1274: --
1275: --
1276: if hr_api.not_exists_in_hr_lookups
1277: (p_lookup_type => 'YES_NO',
1278: p_lookup_code => p_auto_alct_excs_flag,
1279: p_effective_date => p_effective_date) then
1280: --

Line 1347: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)

1343: p_effective_date => p_effective_date,
1344: p_object_version_number => p_object_version_number);
1345: --
1346: if (l_api_updating
1347: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
1348: <> nvl(ben_bpp_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
1349: or not l_api_updating)
1350: and p_comp_lvl_fctr_id is not null then
1351: --

Line 1348: <> nvl(ben_bpp_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)

1344: p_object_version_number => p_object_version_number);
1345: --
1346: if (l_api_updating
1347: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
1348: <> nvl(ben_bpp_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
1349: or not l_api_updating)
1350: and p_comp_lvl_fctr_id is not null then
1351: --
1352: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table

Line 1429: <> nvl(ben_bpp_shd.g_old_rec.alws_ngtv_crs_flag,hr_api.g_varchar2)

1425: p_object_version_number => p_object_version_number);
1426: --
1427: if (l_api_updating
1428: and p_alws_ngtv_crs_flag
1429: <> nvl(ben_bpp_shd.g_old_rec.alws_ngtv_crs_flag,hr_api.g_varchar2)
1430: or not l_api_updating) then
1431: --
1432: -- check if value of lookup falls within lookup type.
1433: --

Line 1435: if hr_api.not_exists_in_hr_lookups

1431: --
1432: -- check if value of lookup falls within lookup type.
1433: --
1434: --
1435: if hr_api.not_exists_in_hr_lookups
1436: (p_lookup_type => 'YES_NO',
1437: p_lookup_code => p_alws_ngtv_crs_flag,
1438: p_effective_date => p_effective_date) then
1439: --

Line 1515: <> nvl(ben_bpp_shd.g_old_rec.uses_net_crs_mthd_flag,hr_api.g_varchar2)

1511: p_object_version_number => p_object_version_number);
1512: --
1513: if (l_api_updating
1514: and p_uses_net_crs_mthd_flag
1515: <> nvl(ben_bpp_shd.g_old_rec.uses_net_crs_mthd_flag,hr_api.g_varchar2)
1516: or not l_api_updating) then
1517: --
1518: -- check if value of lookup falls within lookup type.
1519: --

Line 1521: if hr_api.not_exists_in_hr_lookups

1517: --
1518: -- check if value of lookup falls within lookup type.
1519: --
1520: --
1521: if hr_api.not_exists_in_hr_lookups
1522: (p_lookup_type => 'YES_NO',
1523: p_lookup_code => p_uses_net_crs_mthd_flag,
1524: p_effective_date => p_effective_date) then
1525: --

Line 1603: <> nvl(ben_bpp_shd.g_old_rec.excs_trtmt_cd,hr_api.g_varchar2)

1599: p_object_version_number => p_object_version_number);
1600: --
1601: if (l_api_updating
1602: and p_excs_trtmt_cd
1603: <> nvl(ben_bpp_shd.g_old_rec.excs_trtmt_cd,hr_api.g_varchar2)
1604: or not l_api_updating)
1605: and p_excs_trtmt_cd is not null then
1606: --
1607: -- check if value of lookup falls within lookup type.

Line 1609: if hr_api.not_exists_in_hr_lookups

1605: and p_excs_trtmt_cd is not null then
1606: --
1607: -- check if value of lookup falls within lookup type.
1608: --
1609: if hr_api.not_exists_in_hr_lookups
1610: (p_lookup_type => 'BEN_EXCS_TRTMT',
1611: p_lookup_code => p_excs_trtmt_cd,
1612: p_effective_date => p_effective_date) then
1613: --

Line 1676: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd,hr_api.g_varchar2)

1672: p_object_version_number => p_object_version_number);
1673: --
1674: if (l_api_updating
1675: and p_dflt_excs_trtmt_cd
1676: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd,hr_api.g_varchar2)
1677: or not l_api_updating)
1678: and p_dflt_excs_trtmt_cd is not null then
1679: --
1680: -- check if value of lookup falls within lookup type.

Line 1682: if hr_api.not_exists_in_hr_lookups

1678: and p_dflt_excs_trtmt_cd is not null then
1679: --
1680: -- check if value of lookup falls within lookup type.
1681: --
1682: if hr_api.not_exists_in_hr_lookups
1683: (p_lookup_type => 'BEN_DFLT_EXCS_TRTMT',
1684: p_lookup_code => p_dflt_excs_trtmt_cd,
1685: p_effective_date => p_effective_date) then
1686: --

Line 1765: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl,hr_api.g_number)

1761: p_object_version_number => p_object_version_number);
1762: --
1763: if (l_api_updating
1764: and p_dflt_excs_trtmt_rl
1765: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl,hr_api.g_number)
1766: or not l_api_updating)
1767: and p_dflt_excs_trtmt_rl is not null then
1768: --
1769: -- check if value of rule id is valid.

Line 1849: (nvl(p_dflt_excs_trtmt_cd,hr_api.g_varchar2)

1845: p_object_version_number => p_object_version_number);
1846: --
1847: if (l_api_updating
1848: and
1849: (nvl(p_dflt_excs_trtmt_cd,hr_api.g_varchar2)
1850: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd,hr_api.g_varchar2) or
1851: nvl(p_dflt_excs_trtmt_rl,hr_api.g_number)
1852: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl,hr_api.g_number))
1853: or not l_api_updating) then

Line 1850: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd,hr_api.g_varchar2) or

1846: --
1847: if (l_api_updating
1848: and
1849: (nvl(p_dflt_excs_trtmt_cd,hr_api.g_varchar2)
1850: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd,hr_api.g_varchar2) or
1851: nvl(p_dflt_excs_trtmt_rl,hr_api.g_number)
1852: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl,hr_api.g_number))
1853: or not l_api_updating) then
1854: --

Line 1851: nvl(p_dflt_excs_trtmt_rl,hr_api.g_number)

1847: if (l_api_updating
1848: and
1849: (nvl(p_dflt_excs_trtmt_cd,hr_api.g_varchar2)
1850: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd,hr_api.g_varchar2) or
1851: nvl(p_dflt_excs_trtmt_rl,hr_api.g_number)
1852: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl,hr_api.g_number))
1853: or not l_api_updating) then
1854: --
1855: if (p_dflt_excs_trtmt_cd = 'RL' and p_dflt_excs_trtmt_rl is null) then

Line 1852: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl,hr_api.g_number))

1848: and
1849: (nvl(p_dflt_excs_trtmt_cd,hr_api.g_varchar2)
1850: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_cd,hr_api.g_varchar2) or
1851: nvl(p_dflt_excs_trtmt_rl,hr_api.g_number)
1852: <> nvl(ben_bpp_shd.g_old_rec.dflt_excs_trtmt_rl,hr_api.g_number))
1853: or not l_api_updating) then
1854: --
1855: if (p_dflt_excs_trtmt_cd = 'RL' and p_dflt_excs_trtmt_rl is null) then
1856: --

Line 1862: if nvl(p_dflt_excs_trtmt_cd,hr_api.g_varchar2) <> 'RL'

1858: fnd_message.raise_error;
1859: --
1860: end if;
1861: --
1862: if nvl(p_dflt_excs_trtmt_cd,hr_api.g_varchar2) <> 'RL'
1863: and p_dflt_excs_trtmt_rl is not null then
1864: --
1865: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
1866: fnd_message.raise_error;

Line 1907: (p_pgm_id in number default hr_api.g_number,

1903: --
1904: -- {End Of Comments}
1905: -- ----------------------------------------------------------------------------
1906: Procedure dt_update_validate
1907: (p_pgm_id in number default hr_api.g_number,
1908: p_plip_id in number default hr_api.g_number,
1909: p_ptip_id in number default hr_api.g_number,
1910: p_cmbn_plip_id in number default hr_api.g_number,
1911: p_cmbn_ptip_id in number default hr_api.g_number,

Line 1908: p_plip_id in number default hr_api.g_number,

1904: -- {End Of Comments}
1905: -- ----------------------------------------------------------------------------
1906: Procedure dt_update_validate
1907: (p_pgm_id in number default hr_api.g_number,
1908: p_plip_id in number default hr_api.g_number,
1909: p_ptip_id in number default hr_api.g_number,
1910: p_cmbn_plip_id in number default hr_api.g_number,
1911: p_cmbn_ptip_id in number default hr_api.g_number,
1912: p_cmbn_ptip_opt_id in number default hr_api.g_number,

Line 1909: p_ptip_id in number default hr_api.g_number,

1905: -- ----------------------------------------------------------------------------
1906: Procedure dt_update_validate
1907: (p_pgm_id in number default hr_api.g_number,
1908: p_plip_id in number default hr_api.g_number,
1909: p_ptip_id in number default hr_api.g_number,
1910: p_cmbn_plip_id in number default hr_api.g_number,
1911: p_cmbn_ptip_id in number default hr_api.g_number,
1912: p_cmbn_ptip_opt_id in number default hr_api.g_number,
1913: p_oiplip_id in number default hr_api.g_number,

Line 1910: p_cmbn_plip_id in number default hr_api.g_number,

1906: Procedure dt_update_validate
1907: (p_pgm_id in number default hr_api.g_number,
1908: p_plip_id in number default hr_api.g_number,
1909: p_ptip_id in number default hr_api.g_number,
1910: p_cmbn_plip_id in number default hr_api.g_number,
1911: p_cmbn_ptip_id in number default hr_api.g_number,
1912: p_cmbn_ptip_opt_id in number default hr_api.g_number,
1913: p_oiplip_id in number default hr_api.g_number,
1914: p_datetrack_mode in varchar2,

Line 1911: p_cmbn_ptip_id in number default hr_api.g_number,

1907: (p_pgm_id in number default hr_api.g_number,
1908: p_plip_id in number default hr_api.g_number,
1909: p_ptip_id in number default hr_api.g_number,
1910: p_cmbn_plip_id in number default hr_api.g_number,
1911: p_cmbn_ptip_id in number default hr_api.g_number,
1912: p_cmbn_ptip_opt_id in number default hr_api.g_number,
1913: p_oiplip_id in number default hr_api.g_number,
1914: p_datetrack_mode in varchar2,
1915: p_validation_start_date in date,

Line 1912: p_cmbn_ptip_opt_id in number default hr_api.g_number,

1908: p_plip_id in number default hr_api.g_number,
1909: p_ptip_id in number default hr_api.g_number,
1910: p_cmbn_plip_id in number default hr_api.g_number,
1911: p_cmbn_ptip_id in number default hr_api.g_number,
1912: p_cmbn_ptip_opt_id in number default hr_api.g_number,
1913: p_oiplip_id in number default hr_api.g_number,
1914: p_datetrack_mode in varchar2,
1915: p_validation_start_date in date,
1916: p_validation_end_date in date) Is

Line 1913: p_oiplip_id in number default hr_api.g_number,

1909: p_ptip_id in number default hr_api.g_number,
1910: p_cmbn_plip_id in number default hr_api.g_number,
1911: p_cmbn_ptip_id in number default hr_api.g_number,
1912: p_cmbn_ptip_opt_id in number default hr_api.g_number,
1913: p_oiplip_id in number default hr_api.g_number,
1914: p_datetrack_mode in varchar2,
1915: p_validation_start_date in date,
1916: p_validation_end_date in date) Is
1917: --

Line 1927: hr_api.mandatory_arg_error

1923: hr_utility.set_location('Entering:'||l_proc, 5);
1924: --
1925: -- Ensure that the p_datetrack_mode argument is not null
1926: --
1927: hr_api.mandatory_arg_error
1928: (p_api_name => l_proc,
1929: p_argument => 'datetrack_mode',
1930: p_argument_value => p_datetrack_mode);
1931: --

Line 1939: hr_api.mandatory_arg_error

1935: --
1936: --
1937: -- Ensure the arguments are not null
1938: --
1939: hr_api.mandatory_arg_error
1940: (p_api_name => l_proc,
1941: p_argument => 'validation_start_date',
1942: p_argument_value => p_validation_start_date);
1943: --

Line 1944: hr_api.mandatory_arg_error

1940: (p_api_name => l_proc,
1941: p_argument => 'validation_start_date',
1942: p_argument_value => p_validation_start_date);
1943: --
1944: hr_api.mandatory_arg_error
1945: (p_api_name => l_proc,
1946: p_argument => 'validation_end_date',
1947: p_argument_value => p_validation_end_date);
1948: --

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

1945: (p_api_name => l_proc,
1946: p_argument => 'validation_end_date',
1947: p_argument_value => p_validation_end_date);
1948: --
1949: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
1950: NOT (dt_api.check_min_max_dates
1951: (p_base_table_name => 'ben_pgm_f',
1952: p_base_key_column => 'pgm_id',
1953: p_base_key_value => p_pgm_id,

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

1955: p_to_date => p_validation_end_date))) Then
1956: l_table_name := 'ben_pgm_f';
1957: Raise l_integrity_error;
1958: End If;
1959: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
1960: NOT (dt_api.check_min_max_dates
1961: (p_base_table_name => 'ben_plip_f',
1962: p_base_key_column => 'plip_id',
1963: p_base_key_value => p_plip_id,

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

1965: p_to_date => p_validation_end_date))) Then
1966: l_table_name := 'ben_plip_f';
1967: Raise l_integrity_error;
1968: End If;
1969: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
1970: NOT (dt_api.check_min_max_dates
1971: (p_base_table_name => 'ben_ptip_f',
1972: p_base_key_column => 'ptip_id',
1973: p_base_key_value => p_ptip_id,

Line 1979: If ((nvl(p_cmbn_plip_id, hr_api.g_number) <> hr_api.g_number) and

1975: p_to_date => p_validation_end_date))) Then
1976: l_table_name := 'ben_ptip_f';
1977: Raise l_integrity_error;
1978: End If;
1979: If ((nvl(p_cmbn_plip_id, hr_api.g_number) <> hr_api.g_number) and
1980: NOT (dt_api.check_min_max_dates
1981: (p_base_table_name => 'ben_cmbn_plip_f',
1982: p_base_key_column => 'cmbn_plip_id',
1983: p_base_key_value => p_cmbn_plip_id,

Line 1989: If ((nvl(p_cmbn_ptip_id, hr_api.g_number) <> hr_api.g_number) and

1985: p_to_date => p_validation_end_date))) Then
1986: l_table_name := 'ben_cmbn_plip_f';
1987: Raise l_integrity_error;
1988: End If;
1989: If ((nvl(p_cmbn_ptip_id, hr_api.g_number) <> hr_api.g_number) and
1990: NOT (dt_api.check_min_max_dates
1991: (p_base_table_name => 'ben_cmbn_ptip_f',
1992: p_base_key_column => 'cmbn_ptip_id',
1993: p_base_key_value => p_cmbn_ptip_id,

Line 1999: If ((nvl(p_cmbn_ptip_opt_id, hr_api.g_number) <> hr_api.g_number) and

1995: p_to_date => p_validation_end_date))) Then
1996: l_table_name := 'ben_cmbn_ptip_f';
1997: Raise l_integrity_error;
1998: End If;
1999: If ((nvl(p_cmbn_ptip_opt_id, hr_api.g_number) <> hr_api.g_number) and
2000: NOT (dt_api.check_min_max_dates
2001: (p_base_table_name => 'ben_cmbn_ptip_opt_f',
2002: p_base_key_column => 'cmbn_ptip_opt_id',
2003: p_base_key_value => p_cmbn_ptip_opt_id,

Line 2009: If ((nvl(p_oiplip_id, hr_api.g_number) <> hr_api.g_number) and

2005: p_to_date => p_validation_end_date))) Then
2006: l_table_name := 'ben_cmbn_ptip_opt_f';
2007: Raise l_integrity_error;
2008: End If;
2009: If ((nvl(p_oiplip_id, hr_api.g_number) <> hr_api.g_number) and
2010: NOT (dt_api.check_min_max_dates
2011: (p_base_table_name => 'ben_oiplip_f',
2012: p_base_key_column => 'oiplip_id',
2013: p_base_key_value => p_oiplip_id,

Line 2092: hr_api.mandatory_arg_error

2088: hr_utility.set_location('Entering:'||l_proc, 5);
2089: --
2090: -- Ensure that the p_datetrack_mode argument is not null
2091: --
2092: hr_api.mandatory_arg_error
2093: (p_api_name => l_proc,
2094: p_argument => 'datetrack_mode',
2095: p_argument_value => p_datetrack_mode);
2096: --

Line 2106: hr_api.mandatory_arg_error

2102: --
2103: --
2104: -- Ensure the arguments are not null
2105: --
2106: hr_api.mandatory_arg_error
2107: (p_api_name => l_proc,
2108: p_argument => 'validation_start_date',
2109: p_argument_value => p_validation_start_date);
2110: --

Line 2111: hr_api.mandatory_arg_error

2107: (p_api_name => l_proc,
2108: p_argument => 'validation_start_date',
2109: p_argument_value => p_validation_start_date);
2110: --
2111: hr_api.mandatory_arg_error
2112: (p_api_name => l_proc,
2113: p_argument => 'validation_end_date',
2114: p_argument_value => p_validation_end_date);
2115: --

Line 2116: hr_api.mandatory_arg_error

2112: (p_api_name => l_proc,
2113: p_argument => 'validation_end_date',
2114: p_argument_value => p_validation_end_date);
2115: --
2116: hr_api.mandatory_arg_error
2117: (p_api_name => l_proc,
2118: p_argument => 'bnft_prvdr_pool_id',
2119: p_argument_value => p_bnft_prvdr_pool_id);
2120: --

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

2361: --
2362: -- Call all supporting business operations
2363: --
2364: --
2365: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2366: --
2367: hr_utility.set_location(' Leaving:'||l_proc, 10);
2368: End insert_validate;
2369: --

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

2562: --
2563: -- Call all supporting business operations
2564: --
2565: --
2566: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2567: --
2568: -- Call the datetrack update integrity operation
2569: --
2570: dt_update_validate

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

2634: hr_utility.set_location('Entering:'|| l_proc, 10);
2635: --
2636: -- Ensure that all the mandatory parameter are not null
2637: --
2638: hr_api.mandatory_arg_error(p_api_name => l_proc,
2639: p_argument => 'bnft_prvdr_pool_id',
2640: p_argument_value => p_bnft_prvdr_pool_id);
2641: --
2642: open csr_leg_code;