APPS.BEN_EPN_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_epn_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_excld_flag
124: <> nvl(ben_epn_shd.g_old_rec.excld_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_excld_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 196: <> nvl(ben_epn_shd.g_old_rec.probation_unit,hr_api.g_varchar2)

192: p_object_version_number => p_object_version_number);
193: --
194: if (l_api_updating
195: and p_probation_unit
196: <> nvl(ben_epn_shd.g_old_rec.probation_unit,hr_api.g_varchar2)
197: or not l_api_updating) then
198: --
199: -- check if value of lookup falls within lookup type.
200: --

Line 202: if hr_api.not_exists_in_hr_lookups

198: --
199: -- check if value of lookup falls within lookup type.
200: --
201: --
202: if hr_api.not_exists_in_hr_lookups
203: (p_lookup_type => 'QUALIFYING_UNITS',
204: p_lookup_code => p_probation_unit,
205: p_effective_date => p_effective_date) then
206: --

Line 251: p_eligy_prfl_id in number default hr_api.g_number,

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

Line 265: hr_api.mandatory_arg_error

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

Line 277: hr_api.mandatory_arg_error

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

Line 282: hr_api.mandatory_arg_error

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

Line 287: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and

283: (p_api_name => l_proc,
284: p_argument => 'validation_end_date',
285: p_argument_value => p_validation_end_date);
286: --
287: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
288: NOT (dt_api.check_min_max_dates
289: (p_base_table_name => 'ben_eligy_prfl_f',
290: p_base_key_column => 'eligy_prfl_id',
291: p_base_key_value => p_eligy_prfl_id,

Line 369: hr_api.mandatory_arg_error

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

Line 383: hr_api.mandatory_arg_error

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

Line 388: hr_api.mandatory_arg_error

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

Line 393: hr_api.mandatory_arg_error

389: (p_api_name => l_proc,
390: p_argument => 'validation_end_date',
391: p_argument_value => p_validation_end_date);
392: --
393: hr_api.mandatory_arg_error
394: (p_api_name => l_proc,
395: p_argument => 'ELIG_PRBTN_PERD_PRTE_id',
396: p_argument_value => p_ELIG_PRBTN_PERD_PRTE_id);
397: --

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

451: p_probation_unit => p_rec.probation_unit,
452: p_effective_date => p_effective_date,
453: p_object_version_number => p_rec.object_version_number);
454: --
455: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
456: --
457: hr_utility.set_location(' Leaving:'||l_proc, 10);
458: End insert_validate;
459: --

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

491: p_probation_unit => p_rec.probation_unit,
492: p_effective_date => p_effective_date,
493: p_object_version_number => p_rec.object_version_number);
494: --
495: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
496: --
497: -- Call the datetrack update integrity operation
498: --
499: dt_update_validate

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

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