APPS.BEN_XIC_BUS dependencies on HR_API

Line 52: hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);

48: -- If the value is not known then go onto check against the
49: -- hr_lookups view. Just in case there has been a change to
50: -- the system defined lookup.
51: end if;
52: hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);
53: --
54: open csr_hr_look;
55: fetch csr_hr_look into l_exists;
56: if csr_hr_look%notfound then

Line 104: hr_utility.set_location(hr_api.g_package||'not_exists_in_hrstanlookups', 10);

100: -- If the value is not known then go onto check against the
101: -- hr_lookups view. Just in case there has been a change to
102: -- the system defined lookup.
103: end if;
104: hr_utility.set_location(hr_api.g_package||'not_exists_in_hrstanlookups', 10);
105: --
106: open csr_hr_look;
107: fetch csr_hr_look into l_exists;
108: if csr_hr_look%notfound then

Line 144: hr_api.mandatory_arg_error

140: hr_utility.set_location('Entering:'|| l_proc, 10);
141: --
142: -- Ensure that all the mandatory parameter are not null
143: --
144: hr_api.mandatory_arg_error
145: (p_api_name => l_proc
146: ,p_argument => 'ext_incl_chg_id'
147: ,p_argument_value => p_ext_incl_chg_id
148: );

Line 167: hr_api.set_security_group_id

163: close csr_sec_grp;
164: --
165: -- Set the security_group_id in CLIENT_INFO
166: --
167: hr_api.set_security_group_id
168: (p_security_group_id => l_security_group_id
169: );
170: --
171: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 217: and nvl(p_ext_incl_chg_id,hr_api.g_number)

213: (p_ext_incl_chg_id => p_ext_incl_chg_id,
214: p_object_version_number => p_object_version_number);
215: --
216: if (l_api_updating
217: and nvl(p_ext_incl_chg_id,hr_api.g_number)
218: <> ben_xic_shd.g_old_rec.ext_incl_chg_id) then
219: --
220: -- raise error as PK has changed
221: --

Line 289: and nvl(p_ext_rcd_in_file_id,hr_api.g_number)

285: (p_ext_incl_chg_id => p_ext_incl_chg_id,
286: p_object_version_number => p_object_version_number);
287: --
288: if (l_api_updating
289: and nvl(p_ext_rcd_in_file_id,hr_api.g_number)
290: <> nvl(ben_xic_shd.g_old_rec.ext_rcd_in_file_id,hr_api.g_number)
291: or not l_api_updating) and
292: p_ext_rcd_in_file_id is not null then
293: --

Line 290: <> nvl(ben_xic_shd.g_old_rec.ext_rcd_in_file_id,hr_api.g_number)

286: p_object_version_number => p_object_version_number);
287: --
288: if (l_api_updating
289: and nvl(p_ext_rcd_in_file_id,hr_api.g_number)
290: <> nvl(ben_xic_shd.g_old_rec.ext_rcd_in_file_id,hr_api.g_number)
291: or not l_api_updating) and
292: p_ext_rcd_in_file_id is not null then
293: --
294: -- check if ext_rcd_in_file_id value exists in ben_ext_rcd_in_file table

Line 365: and nvl(p_ext_data_elmt_in_rcd_id,hr_api.g_number)

361: (p_ext_incl_chg_id => p_ext_incl_chg_id,
362: p_object_version_number => p_object_version_number);
363: --
364: if (l_api_updating
365: and nvl(p_ext_data_elmt_in_rcd_id,hr_api.g_number)
366: <> nvl(ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id,hr_api.g_number)
367: or not l_api_updating) and
368: p_ext_data_elmt_in_rcd_id is not null then
369: --

Line 366: <> nvl(ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id,hr_api.g_number)

362: p_object_version_number => p_object_version_number);
363: --
364: if (l_api_updating
365: and nvl(p_ext_data_elmt_in_rcd_id,hr_api.g_number)
366: <> nvl(ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id,hr_api.g_number)
367: or not l_api_updating) and
368: p_ext_data_elmt_in_rcd_id is not null then
369: --
370: -- check if ext_data_elmt_in_rcd_id value exists in ben_ext_data_elmt_in_rcd table

Line 456: <> nvl(ben_xic_shd.g_old_rec.chg_evt_cd,hr_api.g_varchar2)

452: p_object_version_number => p_object_version_number);
453: --
454: if (l_api_updating
455: and p_chg_evt_cd
456: <> nvl(ben_xic_shd.g_old_rec.chg_evt_cd,hr_api.g_varchar2)
457: or not l_api_updating)
458: and p_chg_evt_cd is not null then
459: --
460: -- check if value of lookup falls within lookup type.

Line 464: if hr_api.not_exists_in_hr_lookups

460: -- check if value of lookup falls within lookup type.
461: --
462: if p_chg_evt_source is null or p_chg_evt_source = 'BEN' then
463: if p_business_group_id is not null then
464: if hr_api.not_exists_in_hr_lookups
465: (p_lookup_type => 'BEN_EXT_CHG_EVT',
466: p_lookup_code => p_chg_evt_cd,
467: p_effective_date => p_effective_date) then
468: --

Line 680: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

676: chk_startup_action(True
677: ,p_rec.business_group_id
678: ,p_rec.legislation_code);
679: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
680: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
681: END IF;
682: --
683: chk_ext_incl_chg_id
684: (p_ext_incl_chg_id => p_rec.ext_incl_chg_id,

Line 737: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

733: chk_startup_action(False
734: ,p_rec.business_group_id
735: ,p_rec.legislation_code);
736: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
737: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
738: END IF;
739: --
740: chk_ext_incl_chg_id
741: (p_ext_incl_chg_id => p_rec.ext_incl_chg_id,

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

821: hr_utility.set_location('Entering:'|| l_proc, 10);
822: --
823: -- Ensure that all the mandatory parameter are not null
824: --
825: hr_api.mandatory_arg_error(p_api_name => l_proc,
826: p_argument => 'ext_incl_chg_id',
827: p_argument_value => p_ext_incl_chg_id);
828: --
829: open csr_leg_code;

Line 844: l_legislation_code := hr_api.return_legislation_code(l_business_group_id) ;

840: fnd_message.raise_error;
841: --
842: end if;
843:
844: l_legislation_code := hr_api.return_legislation_code(l_business_group_id) ;
845: --
846: close csr_leg_code;
847: --
848: hr_utility.set_location(' Leaving:'|| l_proc, 20);