APPS.BEN_BNB_BUS dependencies on HR_API

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

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

Line 124: <> nvl(ben_bnb_shd.g_old_rec.bnfts_bal_usg_cd,hr_api.g_varchar2)

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

Line 130: if hr_api.not_exists_in_hr_lookups

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

Line 192: <> nvl(ben_bnb_shd.g_old_rec.nnmntry_uom,hr_api.g_varchar2)

188: p_object_version_number => p_object_version_number);
189: --
190: if (l_api_updating
191: and p_nnmntry_uom
192: <> nvl(ben_bnb_shd.g_old_rec.nnmntry_uom,hr_api.g_varchar2)
193: or not l_api_updating)
194: and p_nnmntry_uom is not null then
195: --
196: -- check if value of lookup falls within lookup type.

Line 198: if hr_api.not_exists_in_hr_lookups

194: and p_nnmntry_uom is not null then
195: --
196: -- check if value of lookup falls within lookup type.
197: --
198: if hr_api.not_exists_in_hr_lookups
199: (p_lookup_type => 'BEN_NNMNTRY_UOM',
200: p_lookup_code => p_nnmntry_uom,
201: p_effective_date => p_effective_date) then
202: --

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

259: p_effective_date => p_effective_date,
260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating
263: and nvl(p_uom,hr_api.g_varchar2)
264: <> nvl(ben_bnb_shd.g_old_rec.uom,hr_api.g_varchar2)
265: or not l_api_updating) then
266: --and p_uom is not null then see beabrrhi.pkb
267: --

Line 264: <> nvl(ben_bnb_shd.g_old_rec.uom,hr_api.g_varchar2)

260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating
263: and nvl(p_uom,hr_api.g_varchar2)
264: <> nvl(ben_bnb_shd.g_old_rec.uom,hr_api.g_varchar2)
265: or not l_api_updating) then
266: --and p_uom is not null then see beabrrhi.pkb
267: --
268: -- check if uom value exists in fnd_currencies_tl table.

Line 275: -- if hr_api.not_exists_in_hr_lookups

271: open c1;
272: fetch c1 into l_dummy;
273: if c1%notfound then
274: --
275: -- if hr_api.not_exists_in_hr_lookups
276: -- (p_lookup_type => 'BEN_NNMNTRY_UOM',
277: -- p_lookup_code => p_uom,
278: -- p_effective_date => p_effective_date) then
279: --

Line 391: hr_api.mandatory_arg_error

387: hr_utility.set_location('Entering:'||l_proc, 5);
388: --
389: -- Ensure that the p_datetrack_mode argument is not null
390: --
391: hr_api.mandatory_arg_error
392: (p_api_name => l_proc,
393: p_argument => 'datetrack_mode',
394: p_argument_value => p_datetrack_mode);
395: --

Line 403: hr_api.mandatory_arg_error

399: --
400: --
401: -- Ensure the arguments are not null
402: --
403: hr_api.mandatory_arg_error
404: (p_api_name => l_proc,
405: p_argument => 'validation_start_date',
406: p_argument_value => p_validation_start_date);
407: --

Line 408: hr_api.mandatory_arg_error

404: (p_api_name => l_proc,
405: p_argument => 'validation_start_date',
406: p_argument_value => p_validation_start_date);
407: --
408: hr_api.mandatory_arg_error
409: (p_api_name => l_proc,
410: p_argument => 'validation_end_date',
411: p_argument_value => p_validation_end_date);
412: --

Line 486: hr_api.mandatory_arg_error

482: hr_utility.set_location('Entering:'||l_proc, 5);
483: --
484: -- Ensure that the p_datetrack_mode argument is not null
485: --
486: hr_api.mandatory_arg_error
487: (p_api_name => l_proc,
488: p_argument => 'datetrack_mode',
489: p_argument_value => p_datetrack_mode);
490: --

Line 500: hr_api.mandatory_arg_error

496: --
497: --
498: -- Ensure the arguments are not null
499: --
500: hr_api.mandatory_arg_error
501: (p_api_name => l_proc,
502: p_argument => 'validation_start_date',
503: p_argument_value => p_validation_start_date);
504: --

Line 505: hr_api.mandatory_arg_error

501: (p_api_name => l_proc,
502: p_argument => 'validation_start_date',
503: p_argument_value => p_validation_start_date);
504: --
505: hr_api.mandatory_arg_error
506: (p_api_name => l_proc,
507: p_argument => 'validation_end_date',
508: p_argument_value => p_validation_end_date);
509: --

Line 510: hr_api.mandatory_arg_error

506: (p_api_name => l_proc,
507: p_argument => 'validation_end_date',
508: p_argument_value => p_validation_end_date);
509: --
510: hr_api.mandatory_arg_error
511: (p_api_name => l_proc,
512: p_argument => 'bnfts_bal_id',
513: p_argument_value => p_bnfts_bal_id);
514: --

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

560: --
561: -- Call all supporting business operations
562: --
563: --
564: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
565: --
566: chk_bnfts_bal_id
567: (p_bnfts_bal_id => p_rec.bnfts_bal_id,
568: p_effective_date => p_effective_date,

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

613: --
614: -- Call all supporting business operations
615: --
616: --
617: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
618: --
619: chk_bnfts_bal_id
620: (p_bnfts_bal_id => p_rec.bnfts_bal_id,
621: p_effective_date => p_effective_date,

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

710: hr_utility.set_location('Entering:'|| l_proc, 10);
711: --
712: -- Ensure that all the mandatory parameter are not null
713: --
714: hr_api.mandatory_arg_error(p_api_name => l_proc,
715: p_argument => 'bnfts_bal_id',
716: p_argument_value => p_bnfts_bal_id);
717: --
718: open csr_leg_code;