1137: close csr_sec_grp;
1138: --
1139: -- The primary key is invalid therefore we must error
1140: --
1141: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1142: fnd_message.raise_error;
1143: --
1144: end if;
1145: close csr_sec_grp;
1138: --
1139: -- The primary key is invalid therefore we must error
1140: --
1141: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1142: fnd_message.raise_error;
1143: --
1144: end if;
1145: close csr_sec_grp;
1146: --
1213: --
1214: -- The primary key is invalid therefore we must error
1215: --
1216: close csr_leg_code;
1217: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1218: fnd_message.raise_error;
1219: end if;
1220: hr_utility.set_location(l_proc,30);
1221: --
1214: -- The primary key is invalid therefore we must error
1215: --
1216: close csr_leg_code;
1217: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1218: fnd_message.raise_error;
1219: end if;
1220: hr_utility.set_location(l_proc,30);
1221: --
1222: -- Set the global variables so the values are
1629: IF NOT per_mea_shd.api_updating
1630: (p_medical_assessment_id => p_rec.medical_assessment_id
1631: ,p_object_version_number => p_rec.object_version_number) THEN
1632: --
1633: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1634: fnd_message.set_token('PROCEDURE ', l_proc);
1635: fnd_message.set_token('STEP ', '5');
1636: fnd_message.raise_error;
1637: --
1630: (p_medical_assessment_id => p_rec.medical_assessment_id
1631: ,p_object_version_number => p_rec.object_version_number) THEN
1632: --
1633: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1634: fnd_message.set_token('PROCEDURE ', l_proc);
1635: fnd_message.set_token('STEP ', '5');
1636: fnd_message.raise_error;
1637: --
1638: END IF;
1631: ,p_object_version_number => p_rec.object_version_number) THEN
1632: --
1633: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1634: fnd_message.set_token('PROCEDURE ', l_proc);
1635: fnd_message.set_token('STEP ', '5');
1636: fnd_message.raise_error;
1637: --
1638: END IF;
1639: --
1632: --
1633: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1634: fnd_message.set_token('PROCEDURE ', l_proc);
1635: fnd_message.set_token('STEP ', '5');
1636: fnd_message.raise_error;
1637: --
1638: END IF;
1639: --
1640: IF nvl(p_rec.person_id, hr_api.g_number) <>