DBA Data[Home] [Help]

APPS.BEN_PPV_BUS dependencies on HR_API

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

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

Line 187: <> nvl(ben_ppv_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)

183: p_object_version_number => p_object_version_number);
184: --
185: if (l_api_updating
186: and p_rndg_cd
187: <> nvl(ben_ppv_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)
188: or not l_api_updating)
189: and p_rndg_cd is not null then
190: --
191: -- check if value of lookup falls within lookup type.

Line 193: if hr_api.not_exists_in_hr_lookups

189: and p_rndg_cd is not null then
190: --
191: -- check if value of lookup falls within lookup type.
192: --
193: if hr_api.not_exists_in_hr_lookups
194: (p_lookup_type => 'BEN_RNDG',
195: p_lookup_code => p_rndg_cd,
196: p_effective_date => p_effective_date) then
197: --

Line 272: and nvl(p_prtl_mo_prortn_rl,hr_api.g_number)

268: p_effective_date => p_effective_date,
269: p_object_version_number => p_object_version_number);
270: --
271: if (l_api_updating
272: and nvl(p_prtl_mo_prortn_rl,hr_api.g_number)
273: <> ben_ppv_shd.g_old_rec.prtl_mo_prortn_rl
274: or not l_api_updating)
275: and p_prtl_mo_prortn_rl is not null then
276: --

Line 360: and nvl(p_rndg_rl,hr_api.g_number)

356: p_effective_date => p_effective_date,
357: p_object_version_number => p_object_version_number);
358: --
359: if (l_api_updating
360: and nvl(p_rndg_rl,hr_api.g_number)
361: <> ben_ppv_shd.g_old_rec.rndg_rl
362: or not l_api_updating)
363: and p_rndg_rl is not null then
364: --

Line 387: -- if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then

383: --
384: close c1;
385: --
386: -- Unless Rounding Code = Rule, Rounding rule must be blank.
387: -- if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then
388: --
389: -- fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
390: -- fnd_message.raise_error;
391: --

Line 392: -- elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then

388: --
389: -- fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
390: -- fnd_message.raise_error;
391: --
392: -- elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
393: --
394: -- fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
395: -- fnd_message.raise_error;
396: --

Line 505: <> nvl(ben_ppv_shd.g_old_rec.strt_r_stp_cvg_cd,hr_api.g_varchar2)

501: p_object_version_number => p_object_version_number);
502: --
503: if (l_api_updating
504: and p_strt_r_stp_cvg_cd
505: <> nvl(ben_ppv_shd.g_old_rec.strt_r_stp_cvg_cd,hr_api.g_varchar2)
506: or not l_api_updating)
507: and p_strt_r_stp_cvg_cd is not null then
508: --
509: -- check if value of lookup falls within lookup type.

Line 511: if hr_api.not_exists_in_hr_lookups

507: and p_strt_r_stp_cvg_cd is not null then
508: --
509: -- check if value of lookup falls within lookup type.
510: --
511: if hr_api.not_exists_in_hr_lookups
512: (p_lookup_type => 'BEN_STRT_R_STP_CVG',
513: p_lookup_code => p_strt_r_stp_cvg_cd,
514: p_effective_date => p_effective_date) then
515: --

Line 829: (p_actl_prem_id in number default hr_api.g_number,

825: --
826: -- {End Of Comments}
827: -- ----------------------------------------------------------------------------
828: Procedure dt_update_validate
829: (p_actl_prem_id in number default hr_api.g_number,
830: p_cvg_amt_calc_mthd_id in number default hr_api.g_number,
831: p_acty_base_rt_id in number default hr_api.g_number,
832: p_datetrack_mode in varchar2,
833: p_validation_start_date in date,

Line 830: p_cvg_amt_calc_mthd_id in number default hr_api.g_number,

826: -- {End Of Comments}
827: -- ----------------------------------------------------------------------------
828: Procedure dt_update_validate
829: (p_actl_prem_id in number default hr_api.g_number,
830: p_cvg_amt_calc_mthd_id in number default hr_api.g_number,
831: p_acty_base_rt_id in number default hr_api.g_number,
832: p_datetrack_mode in varchar2,
833: p_validation_start_date in date,
834: p_validation_end_date in date) Is

Line 831: p_acty_base_rt_id in number default hr_api.g_number,

827: -- ----------------------------------------------------------------------------
828: Procedure dt_update_validate
829: (p_actl_prem_id in number default hr_api.g_number,
830: p_cvg_amt_calc_mthd_id in number default hr_api.g_number,
831: p_acty_base_rt_id in number default hr_api.g_number,
832: p_datetrack_mode in varchar2,
833: p_validation_start_date in date,
834: p_validation_end_date in date) Is
835: --

Line 845: hr_api.mandatory_arg_error

841: hr_utility.set_location('Entering:'||l_proc, 5);
842: --
843: -- Ensure that the p_datetrack_mode argument is not null
844: --
845: hr_api.mandatory_arg_error
846: (p_api_name => l_proc,
847: p_argument => 'datetrack_mode',
848: p_argument_value => p_datetrack_mode);
849: --

Line 857: hr_api.mandatory_arg_error

853: --
854: --
855: -- Ensure the arguments are not null
856: --
857: hr_api.mandatory_arg_error
858: (p_api_name => l_proc,
859: p_argument => 'validation_start_date',
860: p_argument_value => p_validation_start_date);
861: --

Line 862: hr_api.mandatory_arg_error

858: (p_api_name => l_proc,
859: p_argument => 'validation_start_date',
860: p_argument_value => p_validation_start_date);
861: --
862: hr_api.mandatory_arg_error
863: (p_api_name => l_proc,
864: p_argument => 'validation_end_date',
865: p_argument_value => p_validation_end_date);
866: --

Line 867: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and

863: (p_api_name => l_proc,
864: p_argument => 'validation_end_date',
865: p_argument_value => p_validation_end_date);
866: --
867: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and
868: NOT (dt_api.check_min_max_dates
869: (p_base_table_name => 'ben_actl_prem_f',
870: p_base_key_column => 'actl_prem_id',
871: p_base_key_value => p_actl_prem_id,

Line 877: If ((nvl(p_cvg_amt_calc_mthd_id, hr_api.g_number) <> hr_api.g_number) and

873: p_to_date => p_validation_end_date))) Then
874: l_table_name := 'ben_actl_prem_f';
875: Raise l_integrity_error;
876: End If;
877: If ((nvl(p_cvg_amt_calc_mthd_id, hr_api.g_number) <> hr_api.g_number) and
878: NOT (dt_api.check_min_max_dates
879: (p_base_table_name => 'ben_cvg_amt_calc_mthd_f',
880: p_base_key_column => 'cvg_amt_calc_mthd_id',
881: p_base_key_value => p_cvg_amt_calc_mthd_id,

Line 887: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and

883: p_to_date => p_validation_end_date))) Then
884: l_table_name := 'ben_cvg_amt_calc_mthd_f';
885: Raise l_integrity_error;
886: End If;
887: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
888: NOT (dt_api.check_min_max_dates
889: (p_base_table_name => 'ben_acty_base_rt_f',
890: p_base_key_column => 'acty_base_rt_id',
891: p_base_key_value => p_acty_base_rt_id,

Line 971: hr_api.mandatory_arg_error

967: hr_utility.set_location('Entering:'||l_proc, 5);
968: --
969: -- Ensure that the p_datetrack_mode argument is not null
970: --
971: hr_api.mandatory_arg_error
972: (p_api_name => l_proc,
973: p_argument => 'datetrack_mode',
974: p_argument_value => p_datetrack_mode);
975: --

Line 985: hr_api.mandatory_arg_error

981: --
982: --
983: -- Ensure the arguments are not null
984: --
985: hr_api.mandatory_arg_error
986: (p_api_name => l_proc,
987: p_argument => 'validation_start_date',
988: p_argument_value => p_validation_start_date);
989: --

Line 990: hr_api.mandatory_arg_error

986: (p_api_name => l_proc,
987: p_argument => 'validation_start_date',
988: p_argument_value => p_validation_start_date);
989: --
990: hr_api.mandatory_arg_error
991: (p_api_name => l_proc,
992: p_argument => 'validation_end_date',
993: p_argument_value => p_validation_end_date);
994: --

Line 995: hr_api.mandatory_arg_error

991: (p_api_name => l_proc,
992: p_argument => 'validation_end_date',
993: p_argument_value => p_validation_end_date);
994: --
995: hr_api.mandatory_arg_error
996: (p_api_name => l_proc,
997: p_argument => 'prtl_mo_rt_prtn_val_id',
998: p_argument_value => p_prtl_mo_rt_prtn_val_id);
999: --

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

1039: --
1040: -- Call all supporting business operations
1041: --
1042: --
1043: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1044: --
1045: if p_rec.PRORATE_BY_DAY_TO_MON_FLAG = 'Y' then
1046: --
1047: chk_dup_prorate_by_day_row(p_effective_date => p_effective_date,

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

1131: --
1132: -- Call all supporting business operations
1133: --
1134: --
1135: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1136: --
1137: if p_rec.PRORATE_BY_DAY_TO_MON_FLAG = 'Y' then
1138: --
1139: chk_dup_prorate_by_day_row(p_effective_date => p_effective_date,

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

1270: hr_utility.set_location('Entering:'|| l_proc, 10);
1271: --
1272: -- Ensure that all the mandatory parameter are not null
1273: --
1274: hr_api.mandatory_arg_error(p_api_name => l_proc,
1275: p_argument => 'prtl_mo_rt_prtn_val_id',
1276: p_argument_value => p_prtl_mo_rt_prtn_val_id);
1277: --
1278: open csr_leg_code;