64: close csr_sec_grp;
65: --
66: -- The primary key is invalid therefore we must error
67: --
68: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
69: fnd_message.raise_error;
70: --
71: end if;
72: close csr_sec_grp;
65: --
66: -- The primary key is invalid therefore we must error
67: --
68: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
69: fnd_message.raise_error;
70: --
71: end if;
72: close csr_sec_grp;
73: --
148: --
149: -- The primary key is invalid therefore we must error
150: --
151: close csr_leg_code;
152: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
153: fnd_message.raise_error;
154: end if;
155: hr_utility.set_location(l_proc,30);
156: --
149: -- The primary key is invalid therefore we must error
150: --
151: close csr_leg_code;
152: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
153: fnd_message.raise_error;
154: end if;
155: hr_utility.set_location(l_proc,30);
156: --
157: -- Set the global variables so the values are
209: IF NOT hr_ort_shd.api_updating
210: (p_organization_id => p_rec.organization_id
211: ,p_language => p_rec.language
212: ) THEN
213: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
214: fnd_message.set_token('PROCEDURE ', l_proc);
215: fnd_message.set_token('STEP ', '5');
216: fnd_message.raise_error;
217: END IF;
210: (p_organization_id => p_rec.organization_id
211: ,p_language => p_rec.language
212: ) THEN
213: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
214: fnd_message.set_token('PROCEDURE ', l_proc);
215: fnd_message.set_token('STEP ', '5');
216: fnd_message.raise_error;
217: END IF;
218: --
211: ,p_language => p_rec.language
212: ) THEN
213: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
214: fnd_message.set_token('PROCEDURE ', l_proc);
215: fnd_message.set_token('STEP ', '5');
216: fnd_message.raise_error;
217: END IF;
218: --
219: -- EDIT_HERE: Add checks to ensure non-updateable args have
212: ) THEN
213: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
214: fnd_message.set_token('PROCEDURE ', l_proc);
215: fnd_message.set_token('STEP ', '5');
216: fnd_message.raise_error;
217: END IF;
218: --
219: -- EDIT_HERE: Add checks to ensure non-updateable args have
220: -- not been updated.