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;
249: --
250: hr_utility.set_location(l_proc,30);
251: --
252: close csr_applicant_assignment;
253: fnd_message.set_name ('PER', 'IRC_412006_ASG_NOT_APPL');
254: fnd_message.raise_error;
255: end if;
256: --
257: close csr_applicant_assignment;
250: hr_utility.set_location(l_proc,30);
251: --
252: close csr_applicant_assignment;
253: fnd_message.set_name ('PER', 'IRC_412006_ASG_NOT_APPL');
254: fnd_message.raise_error;
255: end if;
256: --
257: close csr_applicant_assignment;
258: --
314: --
315: hr_utility.set_location(l_proc,30);
316: --
317: --- this message has to be changed to the new message
318: fnd_message.set_name ('PER', 'IRC_412599_COMMENT_LEN_EROOR');
319: fnd_message.raise_error;
320: end if;
321: --
322: --
315: hr_utility.set_location(l_proc,30);
316: --
317: --- this message has to be changed to the new message
318: fnd_message.set_name ('PER', 'IRC_412599_COMMENT_LEN_EROOR');
319: fnd_message.raise_error;
320: end if;
321: --
322: --
323: hr_utility.set_location(' Leaving:'|| l_proc, 50);
385: fetch csr_exists into l_asg_status_type_id;
386: hr_utility.set_location(l_proc,20);
387: if csr_exists%notfound then
388: close csr_exists;
389: fnd_message.set_name ('PER','IRC_412007_REC_ASG_BAD');
390: fnd_message.raise_error;
391: end if;
392: close csr_exists;
393: --
386: hr_utility.set_location(l_proc,20);
387: if csr_exists%notfound then
388: close csr_exists;
389: fnd_message.set_name ('PER','IRC_412007_REC_ASG_BAD');
390: fnd_message.raise_error;
391: end if;
392: close csr_exists;
393: --
394: hr_utility.set_location(' Leaving:'|| l_proc, 30);