APPS.BEN_EMP_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_emp_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_emp_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 131: if hr_api.not_exists_in_hr_lookups

127: -- check if value of lookup falls within lookup type.
128: --
129: --
130: hr_utility.set_location(' yes no ' || p_excld_flag , 99 );
131: if hr_api.not_exists_in_hr_lookups
132: (p_lookup_type => 'YES_NO',
133: p_lookup_code => p_excld_flag,
134: p_effective_date => p_effective_date) then
135: --

Line 169: <> nvl(ben_emp_shd.g_old_rec.marital_status,hr_api.g_varchar2)

165: p_object_version_number => p_object_version_number);
166: --
167: if (l_api_updating
168: and p_marital_status
169: <> nvl(ben_emp_shd.g_old_rec.marital_status,hr_api.g_varchar2)
170: or not l_api_updating) then
171: --
172: -- check if value of lookup falls within lookup type.
173: --

Line 177: if hr_api.not_exists_in_hr_lookups

173: --
174: --
175: hr_utility.set_location(' status ' || p_marital_status , 99 );
176: hr_utility.set_location(' date ' || p_effective_date , 99 );
177: if hr_api.not_exists_in_hr_lookups
178: (p_lookup_type => 'MAR_STATUS',
179: p_lookup_code => p_marital_status,
180: p_effective_date => p_effective_date) then
181: --

Line 226: p_eligy_prfl_id in number default hr_api.g_number,

222: -- {End Of Comments}
223: -- ----------------------------------------------------------------------------
224: Procedure dt_update_validate
225: (
226: p_eligy_prfl_id in number default hr_api.g_number,
227: p_datetrack_mode in varchar2,
228: p_validation_start_date in date,
229: p_validation_end_date in date) Is
230: --

Line 240: hr_api.mandatory_arg_error

236: hr_utility.set_location('Entering:'||l_proc, 5);
237: --
238: -- Ensure that the p_datetrack_mode argument is not null
239: --
240: hr_api.mandatory_arg_error
241: (p_api_name => l_proc,
242: p_argument => 'datetrack_mode',
243: p_argument_value => p_datetrack_mode);
244: --

Line 252: hr_api.mandatory_arg_error

248: --
249: --
250: -- Ensure the arguments are not null
251: --
252: hr_api.mandatory_arg_error
253: (p_api_name => l_proc,
254: p_argument => 'validation_start_date',
255: p_argument_value => p_validation_start_date);
256: --

Line 257: hr_api.mandatory_arg_error

253: (p_api_name => l_proc,
254: p_argument => 'validation_start_date',
255: p_argument_value => p_validation_start_date);
256: --
257: hr_api.mandatory_arg_error
258: (p_api_name => l_proc,
259: p_argument => 'validation_end_date',
260: p_argument_value => p_validation_end_date);
261: --

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

258: (p_api_name => l_proc,
259: p_argument => 'validation_end_date',
260: p_argument_value => p_validation_end_date);
261: --
262: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
263: NOT (dt_api.check_min_max_dates
264: (p_base_table_name => 'ben_eligy_prfl_f',
265: p_base_key_column => 'eligy_prfl_id',
266: p_base_key_value => p_eligy_prfl_id,

Line 344: hr_api.mandatory_arg_error

340: hr_utility.set_location('Entering:'||l_proc, 5);
341: --
342: -- Ensure that the p_datetrack_mode argument is not null
343: --
344: hr_api.mandatory_arg_error
345: (p_api_name => l_proc,
346: p_argument => 'datetrack_mode',
347: p_argument_value => p_datetrack_mode);
348: --

Line 358: hr_api.mandatory_arg_error

354: --
355: --
356: -- Ensure the arguments are not null
357: --
358: hr_api.mandatory_arg_error
359: (p_api_name => l_proc,
360: p_argument => 'validation_start_date',
361: p_argument_value => p_validation_start_date);
362: --

Line 363: hr_api.mandatory_arg_error

359: (p_api_name => l_proc,
360: p_argument => 'validation_start_date',
361: p_argument_value => p_validation_start_date);
362: --
363: hr_api.mandatory_arg_error
364: (p_api_name => l_proc,
365: p_argument => 'validation_end_date',
366: p_argument_value => p_validation_end_date);
367: --

Line 368: hr_api.mandatory_arg_error

364: (p_api_name => l_proc,
365: p_argument => 'validation_end_date',
366: p_argument_value => p_validation_end_date);
367: --
368: hr_api.mandatory_arg_error
369: (p_api_name => l_proc,
370: p_argument => 'ELIG_MRTL_STS_PRTE_id',
371: p_argument_value => p_ELIG_MRTL_STS_PRTE_id);
372: --

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

428: p_effective_date => p_effective_date,
429: p_object_version_number => p_rec.object_version_number);
430:
431: --
432: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
433: --
434: hr_utility.set_location(' Leaving:'||l_proc, 10);
435: End insert_validate;
436: --

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

467: p_marital_status => p_rec.marital_status,
468: p_effective_date => p_effective_date,
469: p_object_version_number => p_rec.object_version_number);
470:
471: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
472: --
473: -- Call the datetrack update integrity operation
474: --
475: dt_update_validate

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

535: hr_utility.set_location('Entering:'|| l_proc, 10);
536: --
537: -- Ensure that all the mandatory parameter are not null
538: --
539: hr_api.mandatory_arg_error(p_api_name => l_proc,
540: p_argument => 'ELIG_MRTL_STS_PRTE_id',
541: p_argument_value => p_ELIG_MRTL_STS_PRTE_id);
542: --
543: open csr_leg_code;