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,'PAYE_DETAILS_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
210: (p_paye_details_id => p_rec.paye_details_id
211: ,p_effective_date => p_effective_date
212: ,p_object_version_number => p_rec.object_version_number
213: ) THEN
214: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
215: fnd_message.set_token('PROCEDURE ', l_proc);
216: fnd_message.set_token('STEP ', '5');
217: fnd_message.raise_error;
218: END IF;
211: ,p_effective_date => p_effective_date
212: ,p_object_version_number => p_rec.object_version_number
213: ) THEN
214: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
215: fnd_message.set_token('PROCEDURE ', l_proc);
216: fnd_message.set_token('STEP ', '5');
217: fnd_message.raise_error;
218: END IF;
219: --
212: ,p_object_version_number => p_rec.object_version_number
213: ) THEN
214: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
215: fnd_message.set_token('PROCEDURE ', l_proc);
216: fnd_message.set_token('STEP ', '5');
217: fnd_message.raise_error;
218: END IF;
219: --
220: if nvl(p_rec.business_group_id, hr_api.g_number) <>
213: ) THEN
214: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
215: fnd_message.set_token('PROCEDURE ', l_proc);
216: fnd_message.set_token('STEP ', '5');
217: fnd_message.raise_error;
218: END IF;
219: --
220: if nvl(p_rec.business_group_id, hr_api.g_number) <>
221: nvl(pay_ppd_shd.g_old_rec.business_group_id
359: --
360: -- An unhandled or unexpected error has occurred which
361: -- we must report
362: --
363: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
364: fnd_message.set_token('PROCEDURE', l_proc);
365: fnd_message.set_token('STEP','15');
366: fnd_message.raise_error;
367: End dt_update_validate;
360: -- An unhandled or unexpected error has occurred which
361: -- we must report
362: --
363: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
364: fnd_message.set_token('PROCEDURE', l_proc);
365: fnd_message.set_token('STEP','15');
366: fnd_message.raise_error;
367: End dt_update_validate;
368: --
361: -- we must report
362: --
363: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
364: fnd_message.set_token('PROCEDURE', l_proc);
365: fnd_message.set_token('STEP','15');
366: fnd_message.raise_error;
367: End dt_update_validate;
368: --
369: -- ----------------------------------------------------------------------------
362: --
363: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
364: fnd_message.set_token('PROCEDURE', l_proc);
365: fnd_message.set_token('STEP','15');
366: fnd_message.raise_error;
367: End dt_update_validate;
368: --
369: -- ----------------------------------------------------------------------------
370: -- |--------------------------< dt_delete_validate >--------------------------|
456: --
457: -- An unhandled or unexpected error has occurred which
458: -- we must report
459: --
460: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
461: fnd_message.set_token('PROCEDURE', l_proc);
462: fnd_message.set_token('STEP','15');
463: fnd_message.raise_error;
464: --
457: -- An unhandled or unexpected error has occurred which
458: -- we must report
459: --
460: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
461: fnd_message.set_token('PROCEDURE', l_proc);
462: fnd_message.set_token('STEP','15');
463: fnd_message.raise_error;
464: --
465: End dt_delete_validate;
458: -- we must report
459: --
460: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
461: fnd_message.set_token('PROCEDURE', l_proc);
462: fnd_message.set_token('STEP','15');
463: fnd_message.raise_error;
464: --
465: End dt_delete_validate;
466: --
459: --
460: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
461: fnd_message.set_token('PROCEDURE', l_proc);
462: fnd_message.set_token('STEP','15');
463: fnd_message.raise_error;
464: --
465: End dt_delete_validate;
466: --
467: -- ----------------------------------------------------------------------------