59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'PYMT_CHECK_DET_ID')
67: );
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
376: IF NOT ben_pdt_shd.api_updating
377: (p_pymt_check_det_id => p_rec.pymt_check_det_id
378: ,p_object_version_number => p_rec.object_version_number
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;
377: (p_pymt_check_det_id => p_rec.pymt_check_det_id
378: ,p_object_version_number => p_rec.object_version_number
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;
385:
378: ,p_object_version_number => p_rec.object_version_number
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;
385:
386: IF nvl(p_rec.business_group_id,hr_api.g_number) <>
379: ) THEN
380: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
381: fnd_message.set_token('PROCEDURE ', l_proc);
382: fnd_message.set_token('STEP ', '5');
383: fnd_message.raise_error;
384: END IF;
385:
386: IF nvl(p_rec.business_group_id,hr_api.g_number) <>
387: nvl(ben_pdt_shd.g_old_rec.business_group_id,hr_api.g_number) then