72: fetch csr_previous_job_id into l_previous_job_id;
73: if csr_previous_job_id%notfound then
74: hr_utility.set_location(l_proc, 20);
75: close csr_previous_job_id;
76: fnd_message.set_name('PER','HR_289540_PJI_INV_PREV_JOB_ID');
77: fnd_message.raise_error;
78: end if;
79: if csr_previous_job_id%isopen then
80: close csr_previous_job_id;
73: if csr_previous_job_id%notfound then
74: hr_utility.set_location(l_proc, 20);
75: close csr_previous_job_id;
76: fnd_message.set_name('PER','HR_289540_PJI_INV_PREV_JOB_ID');
77: fnd_message.raise_error;
78: end if;
79: if csr_previous_job_id%isopen then
80: close csr_previous_job_id;
81: end if;
149: fetch csr_information_type into l_information_type;
150: if csr_information_type%notfound then
151: hr_utility.set_location(l_proc, 20);
152: close csr_information_type;
153: fnd_message.set_name('PER','HR_289539_PJI_INV_INFO_TYPE');
154: fnd_message.raise_error;
155: end if;
156: if csr_information_type%isopen then
157: close csr_information_type;
150: if csr_information_type%notfound then
151: hr_utility.set_location(l_proc, 20);
152: close csr_information_type;
153: fnd_message.set_name('PER','HR_289539_PJI_INV_INFO_TYPE');
154: fnd_message.raise_error;
155: end if;
156: if csr_information_type%isopen then
157: close csr_information_type;
158: end if;
210: close csr_sec_grp;
211: --
212: -- The primary key is invalid therefore we must error
213: --
214: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
215: fnd_message.raise_error;
216: --
217: end if;
218: close csr_sec_grp;
211: --
212: -- The primary key is invalid therefore we must error
213: --
214: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
215: fnd_message.raise_error;
216: --
217: end if;
218: close csr_sec_grp;
219: --
286: --
287: -- The primary key is invalid therefore we must error
288: --
289: close csr_leg_code;
290: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
291: fnd_message.raise_error;
292: end if;
293: hr_utility.set_location(l_proc,30);
294: --
287: -- The primary key is invalid therefore we must error
288: --
289: close csr_leg_code;
290: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
291: fnd_message.raise_error;
292: end if;
293: hr_utility.set_location(l_proc,30);
294: --
295: -- Set the global variables so the values are
702: IF NOT per_pji_shd.api_updating
703: (p_previous_job_extra_info_id => p_rec.previous_job_extra_info_id
704: ,p_object_version_number => p_rec.object_version_number
705: ) THEN
706: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
707: fnd_message.set_token('PROCEDURE ', l_proc);
708: fnd_message.set_token('STEP ', '5');
709: fnd_message.raise_error;
710: END IF;
703: (p_previous_job_extra_info_id => p_rec.previous_job_extra_info_id
704: ,p_object_version_number => p_rec.object_version_number
705: ) THEN
706: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
707: fnd_message.set_token('PROCEDURE ', l_proc);
708: fnd_message.set_token('STEP ', '5');
709: fnd_message.raise_error;
710: END IF;
711: -- Check for non updateable args
704: ,p_object_version_number => p_rec.object_version_number
705: ) THEN
706: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
707: fnd_message.set_token('PROCEDURE ', l_proc);
708: fnd_message.set_token('STEP ', '5');
709: fnd_message.raise_error;
710: END IF;
711: -- Check for non updateable args
712: if per_pji_shd.g_old_rec.previous_job_extra_info_id
705: ) THEN
706: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
707: fnd_message.set_token('PROCEDURE ', l_proc);
708: fnd_message.set_token('STEP ', '5');
709: fnd_message.raise_error;
710: END IF;
711: -- Check for non updateable args
712: if per_pji_shd.g_old_rec.previous_job_extra_info_id
713: <> p_rec.previous_job_extra_info_id