APPS.BEN_REG_BUS dependencies on HR_API

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

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

Line 124: and regn_id <> nvl(p_regn_id, hr_api.g_number)

120: cursor csr_name is
121: select null
122: from ben_regn_f
123: where name = p_name
124: and regn_id <> nvl(p_regn_id, hr_api.g_number)
125: and business_group_id + 0 = p_business_group_id
126: and p_validation_start_date <= effective_end_date
127: and p_validation_end_date >= effective_start_date;
128: --

Line 208: hr_api.mandatory_arg_error

204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: -- Ensure that the p_datetrack_mode argument is not null
207: --
208: hr_api.mandatory_arg_error
209: (p_api_name => l_proc,
210: p_argument => 'datetrack_mode',
211: p_argument_value => p_datetrack_mode);
212: --

Line 220: hr_api.mandatory_arg_error

216: --
217: --
218: -- Ensure the arguments are not null
219: --
220: hr_api.mandatory_arg_error
221: (p_api_name => l_proc,
222: p_argument => 'validation_start_date',
223: p_argument_value => p_validation_start_date);
224: --

Line 225: hr_api.mandatory_arg_error

221: (p_api_name => l_proc,
222: p_argument => 'validation_start_date',
223: p_argument_value => p_validation_start_date);
224: --
225: hr_api.mandatory_arg_error
226: (p_api_name => l_proc,
227: p_argument => 'validation_end_date',
228: p_argument_value => p_validation_end_date);
229: --

Line 305: hr_api.mandatory_arg_error

301: hr_utility.set_location('Entering:'||l_proc, 5);
302: --
303: -- Ensure that the p_datetrack_mode argument is not null
304: --
305: hr_api.mandatory_arg_error
306: (p_api_name => l_proc,
307: p_argument => 'datetrack_mode',
308: p_argument_value => p_datetrack_mode);
309: --

Line 319: hr_api.mandatory_arg_error

315: --
316: --
317: -- Ensure the arguments are not null
318: --
319: hr_api.mandatory_arg_error
320: (p_api_name => l_proc,
321: p_argument => 'validation_start_date',
322: p_argument_value => p_validation_start_date);
323: --

Line 324: hr_api.mandatory_arg_error

320: (p_api_name => l_proc,
321: p_argument => 'validation_start_date',
322: p_argument_value => p_validation_start_date);
323: --
324: hr_api.mandatory_arg_error
325: (p_api_name => l_proc,
326: p_argument => 'validation_end_date',
327: p_argument_value => p_validation_end_date);
328: --

Line 329: hr_api.mandatory_arg_error

325: (p_api_name => l_proc,
326: p_argument => 'validation_end_date',
327: p_argument_value => p_validation_end_date);
328: --
329: hr_api.mandatory_arg_error
330: (p_api_name => l_proc,
331: p_argument => 'regn_id',
332: p_argument_value => p_regn_id);
333: --

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

390: --
391: -- Call all supporting business operations
392: --
393: --
394: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
395: --
396: chk_regn_id
397: (p_regn_id => p_rec.regn_id,
398: p_effective_date => p_effective_date,

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

427: --
428: -- Call all supporting business operations
429: --
430: --
431: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
432: --
433: chk_regn_id
434: (p_regn_id => p_rec.regn_id,
435: p_effective_date => p_effective_date,

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

509: hr_utility.set_location('Entering:'|| l_proc, 10);
510: --
511: -- Ensure that all the mandatory parameter are not null
512: --
513: hr_api.mandatory_arg_error(p_api_name => l_proc,
514: p_argument => 'regn_id',
515: p_argument_value => p_regn_id);
516: --
517: open csr_leg_code;