58: close csr_sec_grp;
59: --
60: -- The primary key is invalid therefore we must error
61: --
62: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
63: fnd_message.raise_error;
64: --
65: end if;
66: close csr_sec_grp;
59: --
60: -- The primary key is invalid therefore we must error
61: --
62: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
63: fnd_message.raise_error;
64: --
65: end if;
66: close csr_sec_grp;
67: --
133: --
134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are
832: IF NOT per_rol_shd.api_updating
833: (p_role_id => p_rec.role_id
834: ,p_object_version_number => p_rec.object_version_number
835: ) THEN
836: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
837: fnd_message.set_token('PROCEDURE ', l_proc);
838: fnd_message.set_token('STEP ', '5');
839: fnd_message.raise_error;
840: END IF;
833: (p_role_id => p_rec.role_id
834: ,p_object_version_number => p_rec.object_version_number
835: ) THEN
836: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
837: fnd_message.set_token('PROCEDURE ', l_proc);
838: fnd_message.set_token('STEP ', '5');
839: fnd_message.raise_error;
840: END IF;
841: --
834: ,p_object_version_number => p_rec.object_version_number
835: ) THEN
836: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
837: fnd_message.set_token('PROCEDURE ', l_proc);
838: fnd_message.set_token('STEP ', '5');
839: fnd_message.raise_error;
840: END IF;
841: --
842: IF nvl(p_rec.person_id, hr_api.g_number) <>
835: ) THEN
836: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
837: fnd_message.set_token('PROCEDURE ', l_proc);
838: fnd_message.set_token('STEP ', '5');
839: fnd_message.raise_error;
840: END IF;
841: --
842: IF nvl(p_rec.person_id, hr_api.g_number) <>
843: nvl(per_rol_shd.g_old_rec.person_id, hr_api.g_number) then