952: close csr_sec_grp;
953: --
954: -- The primary key is invalid therefore we must error
955: --
956: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
957: hr_multi_message.add
958: (p_associated_column1
959: => nvl(p_associated_column1,'GRADE_RULE_ID')
960: );
1029: --
1030: -- The primary key is invalid therefore we must error
1031: --
1032: close csr_leg_code;
1033: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1034: fnd_message.raise_error;
1035: end if;
1036: hr_utility.set_location(l_proc,30);
1037: --
1030: -- The primary key is invalid therefore we must error
1031: --
1032: close csr_leg_code;
1033: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1034: fnd_message.raise_error;
1035: end if;
1036: hr_utility.set_location(l_proc,30);
1037: --
1038: -- Set the global variables so the values are
1089: (p_grade_rule_id => p_rec.grade_rule_id
1090: ,p_effective_date => p_effective_date
1091: ,p_object_version_number => p_rec.object_version_number
1092: ) THEN
1093: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1094: fnd_message.set_token('PROCEDURE ', l_proc);
1095: fnd_message.set_token('STEP ', '5');
1096: fnd_message.raise_error;
1097: END IF;
1090: ,p_effective_date => p_effective_date
1091: ,p_object_version_number => p_rec.object_version_number
1092: ) THEN
1093: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1094: fnd_message.set_token('PROCEDURE ', l_proc);
1095: fnd_message.set_token('STEP ', '5');
1096: fnd_message.raise_error;
1097: END IF;
1098: --
1091: ,p_object_version_number => p_rec.object_version_number
1092: ) THEN
1093: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1094: fnd_message.set_token('PROCEDURE ', l_proc);
1095: fnd_message.set_token('STEP ', '5');
1096: fnd_message.raise_error;
1097: END IF;
1098: --
1099: End chk_non_updateable_args;
1092: ) THEN
1093: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1094: fnd_message.set_token('PROCEDURE ', l_proc);
1095: fnd_message.set_token('STEP ', '5');
1096: fnd_message.raise_error;
1097: END IF;
1098: --
1099: End chk_non_updateable_args;
1100: --
1168: --
1169: -- An unhandled or unexpected error has occurred which
1170: -- we must report
1171: --
1172: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1173: fnd_message.set_token('PROCEDURE', l_proc);
1174: fnd_message.set_token('STEP','15');
1175: fnd_message.raise_error;
1176: End dt_update_validate;
1169: -- An unhandled or unexpected error has occurred which
1170: -- we must report
1171: --
1172: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1173: fnd_message.set_token('PROCEDURE', l_proc);
1174: fnd_message.set_token('STEP','15');
1175: fnd_message.raise_error;
1176: End dt_update_validate;
1177: --
1170: -- we must report
1171: --
1172: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1173: fnd_message.set_token('PROCEDURE', l_proc);
1174: fnd_message.set_token('STEP','15');
1175: fnd_message.raise_error;
1176: End dt_update_validate;
1177: --
1178: -- ----------------------------------------------------------------------------
1171: --
1172: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1173: fnd_message.set_token('PROCEDURE', l_proc);
1174: fnd_message.set_token('STEP','15');
1175: fnd_message.raise_error;
1176: End dt_update_validate;
1177: --
1178: -- ----------------------------------------------------------------------------
1179: -- |--------------------------< dt_delete_validate >--------------------------|
1270: --
1271: -- An unhandled or unexpected error has occurred which
1272: -- we must report
1273: --
1274: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1275: fnd_message.set_token('PROCEDURE', l_proc);
1276: fnd_message.set_token('STEP','15');
1277: fnd_message.raise_error;
1278: --
1271: -- An unhandled or unexpected error has occurred which
1272: -- we must report
1273: --
1274: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1275: fnd_message.set_token('PROCEDURE', l_proc);
1276: fnd_message.set_token('STEP','15');
1277: fnd_message.raise_error;
1278: --
1279: End dt_delete_validate;
1272: -- we must report
1273: --
1274: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1275: fnd_message.set_token('PROCEDURE', l_proc);
1276: fnd_message.set_token('STEP','15');
1277: fnd_message.raise_error;
1278: --
1279: End dt_delete_validate;
1280: --
1273: --
1274: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1275: fnd_message.set_token('PROCEDURE', l_proc);
1276: fnd_message.set_token('STEP','15');
1277: fnd_message.raise_error;
1278: --
1279: End dt_delete_validate;
1280: --
1281: -- ----------------------------------------------------------------------------