66: close csr_sec_grp;
67: --
68: -- The primary key is invalid therefore we must error
69: --
70: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
71: fnd_message.raise_error;
72: --
73: end if;
74: close csr_sec_grp;
67: --
68: -- The primary key is invalid therefore we must error
69: --
70: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
71: fnd_message.raise_error;
72: --
73: end if;
74: close csr_sec_grp;
75: --
153: --
154: -- The primary key is invalid therefore we must error
155: --
156: close csr_leg_code;
157: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
158: fnd_message.raise_error;
159: end if;
160: if g_debug then
161: hr_utility.set_location(l_proc,30);
154: -- The primary key is invalid therefore we must error
155: --
156: close csr_leg_code;
157: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
158: fnd_message.raise_error;
159: end if;
160: if g_debug then
161: hr_utility.set_location(l_proc,30);
162: end if;
217: IF NOT hxc_has_shd.api_updating
218: (p_approval_style_id => p_rec.approval_style_id
219: ,p_object_version_number => p_rec.object_version_number
220: ) THEN
221: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
222: fnd_message.set_token('PROCEDURE ', l_proc);
223: fnd_message.set_token('STEP ', '5');
224: fnd_message.raise_error;
225: END IF;
218: (p_approval_style_id => p_rec.approval_style_id
219: ,p_object_version_number => p_rec.object_version_number
220: ) THEN
221: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
222: fnd_message.set_token('PROCEDURE ', l_proc);
223: fnd_message.set_token('STEP ', '5');
224: fnd_message.raise_error;
225: END IF;
226: --
219: ,p_object_version_number => p_rec.object_version_number
220: ) THEN
221: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
222: fnd_message.set_token('PROCEDURE ', l_proc);
223: fnd_message.set_token('STEP ', '5');
224: fnd_message.raise_error;
225: END IF;
226: --
227: -- EDIT_HERE: Add checks to ensure non-updateable args have
220: ) THEN
221: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
222: fnd_message.set_token('PROCEDURE ', l_proc);
223: fnd_message.set_token('STEP ', '5');
224: fnd_message.raise_error;
225: END IF;
226: --
227: -- EDIT_HERE: Add checks to ensure non-updateable args have
228: -- not been updated.