59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'USER_ROW_ID')
67: );
143: --
144: -- The primary key is invalid therefore we must error
145: --
146: close csr_leg_code;
147: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
148: fnd_message.raise_error;
149: end if;
150: hr_utility.set_location(l_proc,30);
151: --
144: -- The primary key is invalid therefore we must error
145: --
146: close csr_leg_code;
147: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
148: fnd_message.raise_error;
149: end if;
150: hr_utility.set_location(l_proc,30);
151: --
152: -- Set the global variables so the values are
202: IF NOT pay_urt_shd.api_updating
203: (p_user_row_id => p_rec.user_row_id
204: ,p_language => p_rec.language
205: ) THEN
206: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
207: fnd_message.set_token('PROCEDURE ', l_proc);
208: fnd_message.set_token('STEP ', '5');
209: fnd_message.raise_error;
210: END IF;
203: (p_user_row_id => p_rec.user_row_id
204: ,p_language => p_rec.language
205: ) THEN
206: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
207: fnd_message.set_token('PROCEDURE ', l_proc);
208: fnd_message.set_token('STEP ', '5');
209: fnd_message.raise_error;
210: END IF;
211: --
204: ,p_language => p_rec.language
205: ) THEN
206: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
207: fnd_message.set_token('PROCEDURE ', l_proc);
208: fnd_message.set_token('STEP ', '5');
209: fnd_message.raise_error;
210: END IF;
211: --
212: -- EDIT_HERE: Add checks to ensure non-updateable args have
205: ) THEN
206: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
207: fnd_message.set_token('PROCEDURE ', l_proc);
208: fnd_message.set_token('STEP ', '5');
209: fnd_message.raise_error;
210: END IF;
211: --
212: -- EDIT_HERE: Add checks to ensure non-updateable args have
213: -- not been updated.