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,'GLOBAL_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
200: (p_global_id => p_rec.global_id
201: ,p_effective_date => p_effective_date
202: ,p_object_version_number => p_rec.object_version_number
203: ) THEN
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '5');
207: fnd_message.raise_error;
208: END IF;
201: ,p_effective_date => p_effective_date
202: ,p_object_version_number => p_rec.object_version_number
203: ) THEN
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '5');
207: fnd_message.raise_error;
208: END IF;
209: --
202: ,p_object_version_number => p_rec.object_version_number
203: ) THEN
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '5');
207: fnd_message.raise_error;
208: END IF;
209: --
210: -- EDIT_HERE: Add checks to ensure non-updateable args have
203: ) THEN
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '5');
207: fnd_message.raise_error;
208: END IF;
209: --
210: -- EDIT_HERE: Add checks to ensure non-updateable args have
211: -- not been updated.
282: --
283: -- An unhandled or unexpected error has occurred which
284: -- we must report
285: --
286: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
287: fnd_message.set_token('PROCEDURE', l_proc);
288: fnd_message.set_token('STEP','15');
289: fnd_message.raise_error;
290: End dt_update_validate;
283: -- An unhandled or unexpected error has occurred which
284: -- we must report
285: --
286: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
287: fnd_message.set_token('PROCEDURE', l_proc);
288: fnd_message.set_token('STEP','15');
289: fnd_message.raise_error;
290: End dt_update_validate;
291: --
284: -- we must report
285: --
286: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
287: fnd_message.set_token('PROCEDURE', l_proc);
288: fnd_message.set_token('STEP','15');
289: fnd_message.raise_error;
290: End dt_update_validate;
291: --
292: -- ----------------------------------------------------------------------------
285: --
286: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
287: fnd_message.set_token('PROCEDURE', l_proc);
288: fnd_message.set_token('STEP','15');
289: fnd_message.raise_error;
290: End dt_update_validate;
291: --
292: -- ----------------------------------------------------------------------------
293: -- |--------------------------< dt_delete_validate >--------------------------|
379: --
380: -- An unhandled or unexpected error has occurred which
381: -- we must report
382: --
383: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
384: fnd_message.set_token('PROCEDURE', l_proc);
385: fnd_message.set_token('STEP','15');
386: fnd_message.raise_error;
387: --
380: -- An unhandled or unexpected error has occurred which
381: -- we must report
382: --
383: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
384: fnd_message.set_token('PROCEDURE', l_proc);
385: fnd_message.set_token('STEP','15');
386: fnd_message.raise_error;
387: --
388: End dt_delete_validate;
381: -- we must report
382: --
383: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
384: fnd_message.set_token('PROCEDURE', l_proc);
385: fnd_message.set_token('STEP','15');
386: fnd_message.raise_error;
387: --
388: End dt_delete_validate;
389: --
382: --
383: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
384: fnd_message.set_token('PROCEDURE', l_proc);
385: fnd_message.set_token('STEP','15');
386: fnd_message.raise_error;
387: --
388: End dt_delete_validate;
389: --
390: -- ----------------------------------------------------------------------------