DBA Data[Home] [Help]

APPS.BEN_PFF_BUS dependencies on HR_API

Line 51: and nvl(p_pct_fl_tm_fctr_id,hr_api.g_number)

47: (p_pct_fl_tm_fctr_id => p_pct_fl_tm_fctr_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_pct_fl_tm_fctr_id,hr_api.g_number)
52: <> ben_pff_shd.g_old_rec.pct_fl_tm_fctr_id) then
53: --
54: -- raise error as PK has changed
55: --

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

133: (p_pct_fl_tm_fctr_id => p_pct_fl_tm_fctr_id,
134: p_object_version_number => p_object_version_number);
135: --
136: if (l_api_updating
137: and nvl(p_rndg_rl,hr_api.g_number)
138: <> ben_pff_shd.g_old_rec.rndg_rl
139: or not l_api_updating)
140: and p_rndg_rl is not null then
141: --

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

162: --
163: end if;
164: --
165: -- Unless Rounding Code = Rule, Rounding rule must be blank.
166: if nvl(p_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_rndg_rl is not null then
167: --
168: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
169: fnd_message.raise_error;
170: --

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

167: --
168: fnd_message.set_name('BEN', 'BEN_91043_RNDG_RL_NOT_NULL');
169: fnd_message.raise_error;
170: --
171: elsif nvl(p_rndg_cd,hr_api.g_varchar2) = 'RL' and p_rndg_rl is null then
172: --
173: fnd_message.set_name('BEN', 'BEN_92340_RNDG_RL_NULL');
174: fnd_message.raise_error;
175: --

Line 226: <> nvl(ben_pff_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)

222: p_object_version_number => p_object_version_number);
223: --
224: if (l_api_updating
225: and p_rndg_cd
226: <> nvl(ben_pff_shd.g_old_rec.rndg_cd,hr_api.g_varchar2)
227: or not l_api_updating)
228: and p_rndg_cd is not null then
229: --
230: -- check if value of lookup falls within lookup type.

Line 232: if hr_api.not_exists_in_hr_lookups

228: and p_rndg_cd is not null then
229: --
230: -- check if value of lookup falls within lookup type.
231: --
232: if hr_api.not_exists_in_hr_lookups
233: (p_lookup_type => 'BEN_RNDG',
234: p_lookup_code => p_rndg_cd,
235: p_effective_date => p_effective_date) then
236: --

Line 294: <> nvl(ben_pff_shd.g_old_rec.use_sum_of_all_asnts_flag,hr_api.g_varchar2)

290: p_object_version_number => p_object_version_number);
291: --
292: if (l_api_updating
293: and p_use_sum_of_all_asnts_flag
294: <> nvl(ben_pff_shd.g_old_rec.use_sum_of_all_asnts_flag,hr_api.g_varchar2)
295: or not l_api_updating)
296: and p_use_sum_of_all_asnts_flag is not null then
297: --
298: -- check if value of lookup falls within lookup type.

Line 300: if hr_api.not_exists_in_hr_lookups

296: and p_use_sum_of_all_asnts_flag is not null then
297: --
298: -- check if value of lookup falls within lookup type.
299: --
300: if hr_api.not_exists_in_hr_lookups
301: (p_lookup_type => 'YES_NO',
302: p_lookup_code => p_use_sum_of_all_asnts_flag,
303: p_effective_date => p_effective_date) then
304: --

Line 362: <> nvl(ben_pff_shd.g_old_rec.use_prmry_asnt_only_flag,hr_api.g_varchar2)

358: p_object_version_number => p_object_version_number);
359: --
360: if (l_api_updating
361: and p_use_prmry_asnt_only_flag
362: <> nvl(ben_pff_shd.g_old_rec.use_prmry_asnt_only_flag,hr_api.g_varchar2)
363: or not l_api_updating)
364: and p_use_prmry_asnt_only_flag is not null then
365: --
366: -- check if value of lookup falls within lookup type.

Line 368: if hr_api.not_exists_in_hr_lookups

364: and p_use_prmry_asnt_only_flag is not null then
365: --
366: -- check if value of lookup falls within lookup type.
367: --
368: if hr_api.not_exists_in_hr_lookups
369: (p_lookup_type => 'YES_NO',
370: p_lookup_code => p_use_prmry_asnt_only_flag,
371: p_effective_date => p_effective_date) then
372: --

Line 430: <> nvl(ben_pff_shd.g_old_rec.no_mx_pct_val_flag,hr_api.g_varchar2)

426: p_object_version_number => p_object_version_number);
427: --
428: if (l_api_updating
429: and p_no_mx_pct_val_flag
430: <> nvl(ben_pff_shd.g_old_rec.no_mx_pct_val_flag,hr_api.g_varchar2)
431: or not l_api_updating)
432: and p_no_mx_pct_val_flag is not null then
433: --
434: -- check if value of lookup falls within lookup type.

Line 436: if hr_api.not_exists_in_hr_lookups

432: and p_no_mx_pct_val_flag is not null then
433: --
434: -- check if value of lookup falls within lookup type.
435: --
436: if hr_api.not_exists_in_hr_lookups
437: (p_lookup_type => 'YES_NO',
438: p_lookup_code => p_no_mx_pct_val_flag,
439: p_effective_date => p_effective_date) then
440: --

Line 498: <> nvl(ben_pff_shd.g_old_rec.no_mn_pct_val_flag,hr_api.g_varchar2)

494: p_object_version_number => p_object_version_number);
495: --
496: if (l_api_updating
497: and p_no_mn_pct_val_flag
498: <> nvl(ben_pff_shd.g_old_rec.no_mn_pct_val_flag,hr_api.g_varchar2)
499: or not l_api_updating)
500: and p_no_mn_pct_val_flag is not null then
501: --
502: -- check if value of lookup falls within lookup type.

Line 504: if hr_api.not_exists_in_hr_lookups

500: and p_no_mn_pct_val_flag is not null then
501: --
502: -- check if value of lookup falls within lookup type.
503: --
504: if hr_api.not_exists_in_hr_lookups
505: (p_lookup_type => 'YES_NO',
506: p_lookup_code => p_no_mn_pct_val_flag,
507: p_effective_date => p_effective_date) then
508: --

Line 587: if nvl( p_no_mn_pct_val_flag, hr_api.g_varchar2) = 'Y'

583: --
584: -- If No Minimum Percent value flag set to "on" (Y),
585: -- then minimum percent value must be blank.
586: --
587: if nvl( p_no_mn_pct_val_flag, hr_api.g_varchar2) = 'Y'
588: and p_mn_pct_val is not null
589: then
590: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
591: fnd_message.raise_error;

Line 592: elsif nvl( p_no_mn_pct_val_flag, hr_api.g_varchar2) = 'N'

588: and p_mn_pct_val is not null
589: then
590: fnd_message.set_name('BEN','BEN_91054_MIN_VAL_NOT_NULL');
591: fnd_message.raise_error;
592: elsif nvl( p_no_mn_pct_val_flag, hr_api.g_varchar2) = 'N'
593: and p_mn_pct_val is null
594: then
595: fnd_message.set_name('BEN','BEN_91055_MIN_VAL_REQUIRED');
596: fnd_message.raise_error;

Line 602: if nvl( p_no_mx_pct_val_flag, hr_api.g_varchar2) = 'Y'

598: --
599: -- If No Maximum Percent value flag set to "on" (Y),
600: -- then maximum percent value must be blank.
601: --
602: if nvl( p_no_mx_pct_val_flag, hr_api.g_varchar2) = 'Y'
603: and p_mx_pct_val is not null
604: then
605: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
606: fnd_message.raise_error;

Line 607: elsif nvl( p_no_mx_pct_val_flag, hr_api.g_varchar2) = 'N'

603: and p_mx_pct_val is not null
604: then
605: fnd_message.set_name('BEN','BEN_91056_MAX_VAL_NOT_NULL');
606: fnd_message.raise_error;
607: elsif nvl( p_no_mx_pct_val_flag, hr_api.g_varchar2) = 'N'
608: and p_mx_pct_val is null
609: then
610: fnd_message.set_name('BEN','BEN_91057_MAX_VAL_REQUIRED');
611: fnd_message.raise_error;

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

668: -- p_effective_date => p_effective_date,
669: p_object_version_number => p_object_version_number);
670: --
671: if (l_api_updating
672: and nvl(p_name,hr_api.g_varchar2)
673: <> ben_pff_shd.g_old_rec.name
674: or not l_api_updating)
675: and p_name is not null then
676: --

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

774: --
775: -- Call all supporting business operations
776: --
777: --
778: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
779: --
780: chk_pct_fl_tm_fctr_id
781: (p_pct_fl_tm_fctr_id => p_rec.pct_fl_tm_fctr_id,
782: p_object_version_number => p_rec.object_version_number);

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

851: --
852: -- Call all supporting business operations
853: --
854: --
855: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
856: --
857: chk_pct_fl_tm_fctr_id
858: (p_pct_fl_tm_fctr_id => p_rec.pct_fl_tm_fctr_id,
859: p_object_version_number => p_rec.object_version_number);

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

960: hr_utility.set_location('Entering:'|| l_proc, 10);
961: --
962: -- Ensure that all the mandatory parameter are not null
963: --
964: hr_api.mandatory_arg_error(p_api_name => l_proc,
965: p_argument => 'pct_fl_tm_fctr_id',
966: p_argument_value => p_pct_fl_tm_fctr_id);
967: --
968: open csr_leg_code;