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,'ELIG_OBJ_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
201: (p_elig_obj_id => p_rec.elig_obj_id
202: ,p_effective_date => p_effective_date
203: ,p_object_version_number => p_rec.object_version_number
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
202: ,p_effective_date => p_effective_date
203: ,p_object_version_number => p_rec.object_version_number
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
210: --
203: ,p_object_version_number => p_rec.object_version_number
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
210: --
211: -- EDIT_HERE: Add checks to ensure non-updateable args have
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
210: --
211: -- EDIT_HERE: Add checks to ensure non-updateable args have
212: -- not been updated.
285: ,p_base_key_column => p_column_name
286: ,p_base_key_value => p_column_value
287: ,p_from_date => p_validation_start_date
288: ,p_to_date => p_validation_end_date))) Then
289: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
290: fnd_message.set_token('TABLE_NAME','elig obj');
291: hr_multi_message.add
292: (p_associated_column1 => ben_beo_shd.g_tab_nam || '.column_value');
293: End If;
286: ,p_base_key_value => p_column_value
287: ,p_from_date => p_validation_start_date
288: ,p_to_date => p_validation_end_date))) Then
289: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
290: fnd_message.set_token('TABLE_NAME','elig obj');
291: hr_multi_message.add
292: (p_associated_column1 => ben_beo_shd.g_tab_nam || '.column_value');
293: End If;
294: --
297: --
298: -- An unhandled or unexpected error has occurred which
299: -- we must report
300: --
301: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
302: fnd_message.set_token('PROCEDURE', l_proc);
303: fnd_message.set_token('STEP','15');
304: fnd_message.raise_error;
305: End dt_update_validate;
298: -- An unhandled or unexpected error has occurred which
299: -- we must report
300: --
301: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
302: fnd_message.set_token('PROCEDURE', l_proc);
303: fnd_message.set_token('STEP','15');
304: fnd_message.raise_error;
305: End dt_update_validate;
306: --
299: -- we must report
300: --
301: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
302: fnd_message.set_token('PROCEDURE', l_proc);
303: fnd_message.set_token('STEP','15');
304: fnd_message.raise_error;
305: End dt_update_validate;
306: --
307: -- ----------------------------------------------------------------------------
300: --
301: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
302: fnd_message.set_token('PROCEDURE', l_proc);
303: fnd_message.set_token('STEP','15');
304: fnd_message.raise_error;
305: End dt_update_validate;
306: --
307: -- ----------------------------------------------------------------------------
308: -- |--------------------------< dt_delete_validate >--------------------------|
394: --
395: -- An unhandled or unexpected error has occurred which
396: -- we must report
397: --
398: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
399: fnd_message.set_token('PROCEDURE', l_proc);
400: fnd_message.set_token('STEP','15');
401: fnd_message.raise_error;
402: --
395: -- An unhandled or unexpected error has occurred which
396: -- we must report
397: --
398: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
399: fnd_message.set_token('PROCEDURE', l_proc);
400: fnd_message.set_token('STEP','15');
401: fnd_message.raise_error;
402: --
403: End dt_delete_validate;
396: -- we must report
397: --
398: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
399: fnd_message.set_token('PROCEDURE', l_proc);
400: fnd_message.set_token('STEP','15');
401: fnd_message.raise_error;
402: --
403: End dt_delete_validate;
404: --
397: --
398: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
399: fnd_message.set_token('PROCEDURE', l_proc);
400: fnd_message.set_token('STEP','15');
401: fnd_message.raise_error;
402: --
403: End dt_delete_validate;
404: --
405: -- ----------------------------------------------------------------------------