APPS.BEN_PBM_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_pbm_shd.g_old_rec.mnl_adj_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_mnl_adj_flag
124: <> nvl(ben_pbm_shd.g_old_rec.mnl_adj_flag,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if value of lookup falls within lookup type.
128: --

Line 130: if hr_api.not_exists_in_hr_lookups

126: --
127: -- check if value of lookup falls within lookup type.
128: --
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'YES_NO',
132: p_lookup_code => p_mnl_adj_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 196: and nvl(p_uom,hr_api.g_varchar2)

192: p_effective_date => p_effective_date,
193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating
196: and nvl(p_uom,hr_api.g_varchar2)
197: <> nvl(ben_pbm_shd.g_old_rec.uom,hr_api.g_varchar2)
198: or not l_api_updating) then
199: --
200: -- check if uom value exists in fnd_currencies_tl table.

Line 197: <> nvl(ben_pbm_shd.g_old_rec.uom,hr_api.g_varchar2)

193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating
196: and nvl(p_uom,hr_api.g_varchar2)
197: <> nvl(ben_pbm_shd.g_old_rec.uom,hr_api.g_varchar2)
198: or not l_api_updating) then
199: --
200: -- check if uom value exists in fnd_currencies_tl table.
201: --

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

249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Procedure dt_update_validate
253: (p_actl_prem_id in number default hr_api.g_number,
254: p_datetrack_mode in varchar2,
255: p_validation_start_date in date,
256: p_validation_end_date in date) Is
257: --

Line 267: hr_api.mandatory_arg_error

263: hr_utility.set_location('Entering:'||l_proc, 5);
264: --
265: -- Ensure that the p_datetrack_mode argument is not null
266: --
267: hr_api.mandatory_arg_error
268: (p_api_name => l_proc,
269: p_argument => 'datetrack_mode',
270: p_argument_value => p_datetrack_mode);
271: --

Line 279: hr_api.mandatory_arg_error

275: --
276: --
277: -- Ensure the arguments are not null
278: --
279: hr_api.mandatory_arg_error
280: (p_api_name => l_proc,
281: p_argument => 'validation_start_date',
282: p_argument_value => p_validation_start_date);
283: --

Line 284: hr_api.mandatory_arg_error

280: (p_api_name => l_proc,
281: p_argument => 'validation_start_date',
282: p_argument_value => p_validation_start_date);
283: --
284: hr_api.mandatory_arg_error
285: (p_api_name => l_proc,
286: p_argument => 'validation_end_date',
287: p_argument_value => p_validation_end_date);
288: --

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

285: (p_api_name => l_proc,
286: p_argument => 'validation_end_date',
287: p_argument_value => p_validation_end_date);
288: --
289: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and
290: NOT (dt_api.check_min_max_dates
291: (p_base_table_name => 'ben_actl_prem_f',
292: p_base_key_column => 'actl_prem_id',
293: p_base_key_value => p_actl_prem_id,

Line 371: hr_api.mandatory_arg_error

367: hr_utility.set_location('Entering:'||l_proc, 5);
368: --
369: -- Ensure that the p_datetrack_mode argument is not null
370: --
371: hr_api.mandatory_arg_error
372: (p_api_name => l_proc,
373: p_argument => 'datetrack_mode',
374: p_argument_value => p_datetrack_mode);
375: --

Line 385: hr_api.mandatory_arg_error

381: --
382: --
383: -- Ensure the arguments are not null
384: --
385: hr_api.mandatory_arg_error
386: (p_api_name => l_proc,
387: p_argument => 'validation_start_date',
388: p_argument_value => p_validation_start_date);
389: --

Line 390: hr_api.mandatory_arg_error

386: (p_api_name => l_proc,
387: p_argument => 'validation_start_date',
388: p_argument_value => p_validation_start_date);
389: --
390: hr_api.mandatory_arg_error
391: (p_api_name => l_proc,
392: p_argument => 'validation_end_date',
393: p_argument_value => p_validation_end_date);
394: --

Line 395: hr_api.mandatory_arg_error

391: (p_api_name => l_proc,
392: p_argument => 'validation_end_date',
393: p_argument_value => p_validation_end_date);
394: --
395: hr_api.mandatory_arg_error
396: (p_api_name => l_proc,
397: p_argument => 'pl_r_oipl_prem_by_mo_id',
398: p_argument_value => p_pl_r_oipl_prem_by_mo_id);
399: --

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

437: --
438: -- Call all supporting business operations
439: --
440: --
441: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
442: --
443: chk_pl_r_oipl_prem_by_mo_id
444: (p_pl_r_oipl_prem_by_mo_id => p_rec.pl_r_oipl_prem_by_mo_id,
445: p_effective_date => p_effective_date,

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

477: --
478: -- Call all supporting business operations
479: --
480: --
481: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
482: --
483: chk_pl_r_oipl_prem_by_mo_id
484: (p_pl_r_oipl_prem_by_mo_id => p_rec.pl_r_oipl_prem_by_mo_id,
485: p_effective_date => p_effective_date,

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

561: hr_utility.set_location('Entering:'|| l_proc, 10);
562: --
563: -- Ensure that all the mandatory parameter are not null
564: --
565: hr_api.mandatory_arg_error(p_api_name => l_proc,
566: p_argument => 'pl_r_oipl_prem_by_mo_id',
567: p_argument_value => p_pl_r_oipl_prem_by_mo_id);
568: --
569: open csr_leg_code;