50: close csr_sec_grp;
51: --
52: -- The primary key is invalid therefore we must error
53: --
54: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
55: hr_multi_message.add
56: (p_associated_column1
57: => nvl(p_associated_column1,'ASSIGNMENT_ID')
58: );
124: --
125: -- The primary key is invalid therefore we must error
126: --
127: close csr_leg_code;
128: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
129: fnd_message.raise_error;
130: end if;
131: hr_utility.set_location(l_proc,30);
132: --
125: -- The primary key is invalid therefore we must error
126: --
127: close csr_leg_code;
128: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
129: fnd_message.raise_error;
130: end if;
131: hr_utility.set_location(l_proc,30);
132: --
133: -- Set the global variables so the values are
182: IF NOT irc_ias_shd.api_updating
183: (p_assignment_status_id => p_rec.assignment_status_id
184: ,p_object_version_number => p_rec.object_version_number
185: ) THEN
186: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
187: fnd_message.set_token('PROCEDURE ', l_proc);
188: fnd_message.set_token('STEP ', '5');
189: fnd_message.raise_error;
190: END IF;
183: (p_assignment_status_id => p_rec.assignment_status_id
184: ,p_object_version_number => p_rec.object_version_number
185: ) THEN
186: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
187: fnd_message.set_token('PROCEDURE ', l_proc);
188: fnd_message.set_token('STEP ', '5');
189: fnd_message.raise_error;
190: END IF;
191: --
184: ,p_object_version_number => p_rec.object_version_number
185: ) THEN
186: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
187: fnd_message.set_token('PROCEDURE ', l_proc);
188: fnd_message.set_token('STEP ', '5');
189: fnd_message.raise_error;
190: END IF;
191: --
192:
185: ) THEN
186: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
187: fnd_message.set_token('PROCEDURE ', l_proc);
188: fnd_message.set_token('STEP ', '5');
189: fnd_message.raise_error;
190: END IF;
191: --
192:
193: End chk_non_updateable_args;
266: if csr_emp_applicant_assignment%notfound then
267: hr_utility.set_location(l_proc,40);
268: close csr_emp_applicant_assignment;
269: close csr_applicant_assignment;
270: fnd_message.set_name ('PER', 'IRC_412006_ASG_NOT_APPL');
271: fnd_message.raise_error;
272: end if;
273: --
274: close csr_emp_applicant_assignment;
267: hr_utility.set_location(l_proc,40);
268: close csr_emp_applicant_assignment;
269: close csr_applicant_assignment;
270: fnd_message.set_name ('PER', 'IRC_412006_ASG_NOT_APPL');
271: fnd_message.raise_error;
272: end if;
273: --
274: close csr_emp_applicant_assignment;
275: end if;
339: fetch csr_exists into l_asg_status_type_id;
340: hr_utility.set_location(l_proc,20);
341: if csr_exists%notfound then
342: close csr_exists;
343: fnd_message.set_name ('PER','IRC_412007_REC_ASG_BAD');
344: fnd_message.raise_error;
345: end if;
346: close csr_exists;
347: --
340: hr_utility.set_location(l_proc,20);
341: if csr_exists%notfound then
342: close csr_exists;
343: fnd_message.set_name ('PER','IRC_412007_REC_ASG_BAD');
344: fnd_message.raise_error;
345: end if;
346: close csr_exists;
347: --
348: hr_utility.set_location(' Leaving:'|| l_proc, 30);