78: close csr_sec_grp;
79: --
80: -- The primary key is invalid therefore we must error
81: --
82: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
83: --
84: else
85: close csr_sec_grp;
86: --
178: --
179: -- The primary key is invalid therefore we must error
180: --
181: close csr_leg_code;
182: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
183: fnd_message.raise_error;
184: end if;
185: if g_debug then
186: hr_utility.set_location(l_proc,30);
179: -- The primary key is invalid therefore we must error
180: --
181: close csr_leg_code;
182: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
183: fnd_message.raise_error;
184: end if;
185: if g_debug then
186: hr_utility.set_location(l_proc,30);
187: end if;
241: IF NOT hxc_lkr_shd.api_updating
242: (p_locker_type_owner_id => p_rec.locker_type_owner_id
243: ,p_locker_type_requestor_id => p_rec.locker_type_requestor_id
244: ) THEN
245: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
246: fnd_message.set_token('PROCEDURE ', l_proc);
247: fnd_message.set_token('STEP ', '5');
248: fnd_message.raise_error;
249: END IF;
242: (p_locker_type_owner_id => p_rec.locker_type_owner_id
243: ,p_locker_type_requestor_id => p_rec.locker_type_requestor_id
244: ) THEN
245: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
246: fnd_message.set_token('PROCEDURE ', l_proc);
247: fnd_message.set_token('STEP ', '5');
248: fnd_message.raise_error;
249: END IF;
250: --
243: ,p_locker_type_requestor_id => p_rec.locker_type_requestor_id
244: ) THEN
245: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
246: fnd_message.set_token('PROCEDURE ', l_proc);
247: fnd_message.set_token('STEP ', '5');
248: fnd_message.raise_error;
249: END IF;
250: --
251: -- EDIT_HERE: Add checks to ensure non-updateable args have
244: ) THEN
245: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
246: fnd_message.set_token('PROCEDURE ', l_proc);
247: fnd_message.set_token('STEP ', '5');
248: fnd_message.raise_error;
249: END IF;
250: --
251: -- EDIT_HERE: Add checks to ensure non-updateable args have
252: -- not been updated.