54: hr_utility.set_location('Entering:'|| l_proc, 10);
55: --
56: -- Ensure that all the mandatory parameter are not null
57: --
58: hr_api.mandatory_arg_error
59: (p_api_name => l_proc
60: ,p_argument => 'pl_id'
61: ,p_argument_value => p_pl_id
62: );
59: (p_api_name => l_proc
60: ,p_argument => 'pl_id'
61: ,p_argument_value => p_pl_id
62: );
63: hr_api.mandatory_arg_error
64: (p_api_name => l_proc
65: ,p_argument => 'lf_evt_ocrd_dt'
66: ,p_argument_value => p_lf_evt_ocrd_dt
67: );
64: (p_api_name => l_proc
65: ,p_argument => 'lf_evt_ocrd_dt'
66: ,p_argument_value => p_lf_evt_ocrd_dt
67: );
68: hr_api.mandatory_arg_error
69: (p_api_name => l_proc
70: ,p_argument => 'oipl_id'
71: ,p_argument_value => p_oipl_id
72: );
95: close csr_sec_grp;
96: --
97: -- Set the security_group_id in CLIENT_INFO
98: --
99: hr_api.set_security_group_id
100: (p_security_group_id => l_security_group_id
101: );
102: --
103: -- Set the sessions legislation context in HR_SESSION_DATA
101: );
102: --
103: -- Set the sessions legislation context in HR_SESSION_DATA
104: --
105: hr_api.set_legislation_context(l_legislation_code);
106: end if;
107: --
108: hr_utility.set_location(' Leaving:'|| l_proc, 20);
109: --
141: hr_utility.set_location('Entering:'|| l_proc, 10);
142: --
143: -- Ensure that all the mandatory parameter are not null
144: --
145: hr_api.mandatory_arg_error
146: (p_api_name => l_proc
147: ,p_argument => 'pl_id'
148: ,p_argument_value => p_pl_id
149: );
146: (p_api_name => l_proc
147: ,p_argument => 'pl_id'
148: ,p_argument_value => p_pl_id
149: );
150: hr_api.mandatory_arg_error
151: (p_api_name => l_proc
152: ,p_argument => 'lf_evt_ocrd_dt'
153: ,p_argument_value => p_lf_evt_ocrd_dt
154: );
151: (p_api_name => l_proc
152: ,p_argument => 'lf_evt_ocrd_dt'
153: ,p_argument_value => p_lf_evt_ocrd_dt
154: );
155: hr_api.mandatory_arg_error
156: (p_api_name => l_proc
157: ,p_argument => 'oipl_id'
158: ,p_argument_value => p_oipl_id
159: );
157: ,p_argument => 'oipl_id'
158: ,p_argument_value => p_oipl_id
159: );
160: --
161: if (( nvl(ben_cpd_bus.g_pl_id, hr_api.g_number)
162: = p_pl_id)
163: and ( nvl(ben_cpd_bus.g_lf_evt_ocrd_dt, hr_api.g_date)
164: = p_lf_evt_ocrd_dt)
165: and ( nvl(ben_cpd_bus.g_oipl_id, hr_api.g_number)
159: );
160: --
161: if (( nvl(ben_cpd_bus.g_pl_id, hr_api.g_number)
162: = p_pl_id)
163: and ( nvl(ben_cpd_bus.g_lf_evt_ocrd_dt, hr_api.g_date)
164: = p_lf_evt_ocrd_dt)
165: and ( nvl(ben_cpd_bus.g_oipl_id, hr_api.g_number)
166: = p_oipl_id)) then
167: --
161: if (( nvl(ben_cpd_bus.g_pl_id, hr_api.g_number)
162: = p_pl_id)
163: and ( nvl(ben_cpd_bus.g_lf_evt_ocrd_dt, hr_api.g_date)
164: = p_lf_evt_ocrd_dt)
165: and ( nvl(ben_cpd_bus.g_oipl_id, hr_api.g_number)
166: = p_oipl_id)) then
167: --
168: -- The legislation code has already been found with a previous
169: -- call to this function. Just return the value in the global
252: fnd_message.set_token('STEP ', '5');
253: fnd_message.raise_error;
254: END IF;
255: --
256: if nvl(p_rec.pl_id, hr_api.g_number) <>
257: ben_cpd_shd.g_old_rec.pl_id then
258: hr_api.argument_changed_error
259: (p_api_name => l_proc
260: ,p_argument => 'PL_ID'
254: END IF;
255: --
256: if nvl(p_rec.pl_id, hr_api.g_number) <>
257: ben_cpd_shd.g_old_rec.pl_id then
258: hr_api.argument_changed_error
259: (p_api_name => l_proc
260: ,p_argument => 'PL_ID'
261: ,p_base_table => ben_cpd_shd.g_tab_nam
262: );
261: ,p_base_table => ben_cpd_shd.g_tab_nam
262: );
263: end if;
264: --
265: if nvl(p_rec.oipl_id, hr_api.g_number) <>
266: ben_cpd_shd.g_old_rec.oipl_id then
267: hr_api.argument_changed_error
268: (p_api_name => l_proc
269: ,p_argument => 'OIPL_ID'
263: end if;
264: --
265: if nvl(p_rec.oipl_id, hr_api.g_number) <>
266: ben_cpd_shd.g_old_rec.oipl_id then
267: hr_api.argument_changed_error
268: (p_api_name => l_proc
269: ,p_argument => 'OIPL_ID'
270: ,p_base_table => ben_cpd_shd.g_tab_nam
271: );
271: );
272: end if;
273: --
274: --
275: if nvl(p_rec.lf_evt_ocrd_dt, hr_api.g_date) <>
276: ben_cpd_shd.g_old_rec.lf_evt_ocrd_dt then
277: hr_api.argument_changed_error
278: (p_api_name => l_proc
279: ,p_argument => 'LF_EVT_OCRD_DT'
273: --
274: --
275: if nvl(p_rec.lf_evt_ocrd_dt, hr_api.g_date) <>
276: ben_cpd_shd.g_old_rec.lf_evt_ocrd_dt then
277: hr_api.argument_changed_error
278: (p_api_name => l_proc
279: ,p_argument => 'LF_EVT_OCRD_DT'
280: ,p_base_table => ben_cpd_shd.g_tab_nam
281: );