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,'SECURITY_ORGANIZATION_ID')
67: );
138: --
139: -- The primary key is invalid therefore we must error
140: --
141: close csr_leg_code;
142: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
143: fnd_message.raise_error;
144: end if;
145: hr_utility.set_location(l_proc,30);
146: --
139: -- The primary key is invalid therefore we must error
140: --
141: close csr_leg_code;
142: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
143: fnd_message.raise_error;
144: end if;
145: hr_utility.set_location(l_proc,30);
146: --
147: -- Set the global variables so the values are
180: --
181: open csr_organization;
182: fetch csr_organization into l_dummy;
183: if csr_organization%notfound then
184: fnd_message.set_name('PER', 'HR_289002_INV_ORG_ID');
185: fnd_message.raise_error;
186: END IF;
187:
188: open csr_unique;
181: open csr_organization;
182: fetch csr_organization into l_dummy;
183: if csr_organization%notfound then
184: fnd_message.set_name('PER', 'HR_289002_INV_ORG_ID');
185: fnd_message.raise_error;
186: END IF;
187:
188: open csr_unique;
189: fetch csr_unique into l_dummy;
187:
188: open csr_unique;
189: fetch csr_unique into l_dummy;
190: if csr_unique%found then
191: fnd_message.set_name('PER', 'HR_289773_MULTI_ORG_DUPLICATE');
192: fnd_message.raise_error;
193: END IF;
194:
195: --
188: open csr_unique;
189: fetch csr_unique into l_dummy;
190: if csr_unique%found then
191: fnd_message.set_name('PER', 'HR_289773_MULTI_ORG_DUPLICATE');
192: fnd_message.raise_error;
193: END IF;
194:
195: --
196:
224: --
225: open csr_profile;
226: fetch csr_profile into l_dummy;
227: if csr_profile%notfound then
228: fnd_message.set_name('PER', 'HR_289774_INVALID_SEC_PROFILE');
229: fnd_message.raise_error;
230: END IF;
231:
232: --
225: open csr_profile;
226: fetch csr_profile into l_dummy;
227: if csr_profile%notfound then
228: fnd_message.set_name('PER', 'HR_289774_INVALID_SEC_PROFILE');
229: fnd_message.raise_error;
230: END IF;
231:
232: --
233: exception
283: IF NOT per_pso_shd.api_updating
284: (p_security_organization_id => p_rec.security_organization_id
285: ,p_object_version_number => p_rec.object_version_number
286: ) THEN
287: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE ', l_proc);
289: fnd_message.set_token('STEP ', '5');
290: fnd_message.raise_error;
291: END IF;
284: (p_security_organization_id => p_rec.security_organization_id
285: ,p_object_version_number => p_rec.object_version_number
286: ) THEN
287: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE ', l_proc);
289: fnd_message.set_token('STEP ', '5');
290: fnd_message.raise_error;
291: END IF;
292: --
285: ,p_object_version_number => p_rec.object_version_number
286: ) THEN
287: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE ', l_proc);
289: fnd_message.set_token('STEP ', '5');
290: fnd_message.raise_error;
291: END IF;
292: --
293: --
286: ) THEN
287: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE ', l_proc);
289: fnd_message.set_token('STEP ', '5');
290: fnd_message.raise_error;
291: END IF;
292: --
293: --
294: End chk_non_updateable_args;