61: close csr_sec_grp;
62: --
63: -- The primary key is invalid therefore we must error
64: --
65: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
66: hr_multi_message.add
67: (p_associated_column1
68: => nvl(p_associated_column1,'ELIG_SCRE_WTG_ID')
69: );
144: --
145: -- The primary key is invalid therefore we must error
146: --
147: close csr_leg_code;
148: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: end if;
151: hr_utility.set_location(l_proc,30);
152: --
145: -- The primary key is invalid therefore we must error
146: --
147: close csr_leg_code;
148: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: end if;
151: hr_utility.set_location(l_proc,30);
152: --
153: -- Set the global variables so the values are
204: (p_elig_scre_wtg_id => p_rec.elig_scre_wtg_id
205: ,p_effective_date => p_effective_date
206: ,p_object_version_number => p_rec.object_version_number
207: ) THEN
208: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
209: fnd_message.set_token('PROCEDURE ', l_proc);
210: fnd_message.set_token('STEP ', '5');
211: fnd_message.raise_error;
212: END IF;
205: ,p_effective_date => p_effective_date
206: ,p_object_version_number => p_rec.object_version_number
207: ) THEN
208: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
209: fnd_message.set_token('PROCEDURE ', l_proc);
210: fnd_message.set_token('STEP ', '5');
211: fnd_message.raise_error;
212: END IF;
213: --
206: ,p_object_version_number => p_rec.object_version_number
207: ) THEN
208: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
209: fnd_message.set_token('PROCEDURE ', l_proc);
210: fnd_message.set_token('STEP ', '5');
211: fnd_message.raise_error;
212: END IF;
213: --
214: End chk_non_updateable_args;
207: ) THEN
208: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
209: fnd_message.set_token('PROCEDURE ', l_proc);
210: fnd_message.set_token('STEP ', '5');
211: fnd_message.raise_error;
212: END IF;
213: --
214: End chk_non_updateable_args;
215: --
283: --
284: -- An unhandled or unexpected error has occurred which
285: -- we must report
286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_update_validate;
284: -- An unhandled or unexpected error has occurred which
285: -- we must report
286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_update_validate;
292: --
285: -- we must report
286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_update_validate;
292: --
293: -- ----------------------------------------------------------------------------
286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_update_validate;
292: --
293: -- ----------------------------------------------------------------------------
294: -- |--------------------------< dt_delete_validate >--------------------------|
380: --
381: -- An unhandled or unexpected error has occurred which
382: -- we must report
383: --
384: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
385: fnd_message.set_token('PROCEDURE', l_proc);
386: fnd_message.set_token('STEP','15');
387: fnd_message.raise_error;
388: --
381: -- An unhandled or unexpected error has occurred which
382: -- we must report
383: --
384: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
385: fnd_message.set_token('PROCEDURE', l_proc);
386: fnd_message.set_token('STEP','15');
387: fnd_message.raise_error;
388: --
389: End dt_delete_validate;
382: -- we must report
383: --
384: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
385: fnd_message.set_token('PROCEDURE', l_proc);
386: fnd_message.set_token('STEP','15');
387: fnd_message.raise_error;
388: --
389: End dt_delete_validate;
390: --
383: --
384: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
385: fnd_message.set_token('PROCEDURE', l_proc);
386: fnd_message.set_token('STEP','15');
387: fnd_message.raise_error;
388: --
389: End dt_delete_validate;
390: --
391: -- ----------------------------------------------------------------------------