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,'CWB_MATRIX_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
199: IF NOT ben_bcm_shd.api_updating
200: (p_cwb_matrix_id => p_rec.cwb_matrix_id
201: ,p_object_version_number => p_rec.object_version_number
202: ) THEN
203: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
204: fnd_message.set_token('PROCEDURE ', l_proc);
205: fnd_message.set_token('STEP ', '5');
206: fnd_message.raise_error;
207: END IF;
200: (p_cwb_matrix_id => p_rec.cwb_matrix_id
201: ,p_object_version_number => p_rec.object_version_number
202: ) THEN
203: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
204: fnd_message.set_token('PROCEDURE ', l_proc);
205: fnd_message.set_token('STEP ', '5');
206: fnd_message.raise_error;
207: END IF;
208: --
201: ,p_object_version_number => p_rec.object_version_number
202: ) THEN
203: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
204: fnd_message.set_token('PROCEDURE ', l_proc);
205: fnd_message.set_token('STEP ', '5');
206: fnd_message.raise_error;
207: END IF;
208: --
209: -- EDIT_HERE: Add checks to ensure non-updateable args have
202: ) THEN
203: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
204: fnd_message.set_token('PROCEDURE ', l_proc);
205: fnd_message.set_token('STEP ', '5');
206: fnd_message.raise_error;
207: END IF;
208: --
209: -- EDIT_HERE: Add checks to ensure non-updateable args have
210: -- not been updated.
270: p_effective_date => p_effective_date) then
271: --
272: -- raise error as does not exist as lookup
273: --
274: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
275: fnd_message.set_token('FIELD', p_row_crit_cd);
276: fnd_message.set_token('TYPE', 'BEN_CWB_MATRIX_ROW_CRITERIA');
277: fnd_message.raise_error;
278: --
271: --
272: -- raise error as does not exist as lookup
273: --
274: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
275: fnd_message.set_token('FIELD', p_row_crit_cd);
276: fnd_message.set_token('TYPE', 'BEN_CWB_MATRIX_ROW_CRITERIA');
277: fnd_message.raise_error;
278: --
279: end if;
272: -- raise error as does not exist as lookup
273: --
274: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
275: fnd_message.set_token('FIELD', p_row_crit_cd);
276: fnd_message.set_token('TYPE', 'BEN_CWB_MATRIX_ROW_CRITERIA');
277: fnd_message.raise_error;
278: --
279: end if;
280: --
273: --
274: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
275: fnd_message.set_token('FIELD', p_row_crit_cd);
276: fnd_message.set_token('TYPE', 'BEN_CWB_MATRIX_ROW_CRITERIA');
277: fnd_message.raise_error;
278: --
279: end if;
280: --
281: end if;
294: p_effective_date => p_effective_date) then
295: --
296: -- raise error as does not exist as lookup
297: --
298: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
299: fnd_message.set_token('FIELD', p_col_crit_cd);
300: fnd_message.set_token('TYPE', 'BEN_CWB_MATRIX_COLUMN_CRITERIA');
301: fnd_message.raise_error;
302: --
295: --
296: -- raise error as does not exist as lookup
297: --
298: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
299: fnd_message.set_token('FIELD', p_col_crit_cd);
300: fnd_message.set_token('TYPE', 'BEN_CWB_MATRIX_COLUMN_CRITERIA');
301: fnd_message.raise_error;
302: --
303: end if;
296: -- raise error as does not exist as lookup
297: --
298: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
299: fnd_message.set_token('FIELD', p_col_crit_cd);
300: fnd_message.set_token('TYPE', 'BEN_CWB_MATRIX_COLUMN_CRITERIA');
301: fnd_message.raise_error;
302: --
303: end if;
304: --
297: --
298: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
299: fnd_message.set_token('FIELD', p_col_crit_cd);
300: fnd_message.set_token('TYPE', 'BEN_CWB_MATRIX_COLUMN_CRITERIA');
301: fnd_message.raise_error;
302: --
303: end if;
304: --
305: end if;
317: p_effective_date => p_effective_date) then
318: --
319: -- raise error as does not exist as lookup
320: --
321: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
322: fnd_message.set_token('FIELD', p_alct_by_cd);
323: fnd_message.set_token('TYPE', 'BEN_ALLCT_BY');
324: fnd_message.raise_error;
325: --
318: --
319: -- raise error as does not exist as lookup
320: --
321: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
322: fnd_message.set_token('FIELD', p_alct_by_cd);
323: fnd_message.set_token('TYPE', 'BEN_ALLCT_BY');
324: fnd_message.raise_error;
325: --
326: end if;
319: -- raise error as does not exist as lookup
320: --
321: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
322: fnd_message.set_token('FIELD', p_alct_by_cd);
323: fnd_message.set_token('TYPE', 'BEN_ALLCT_BY');
324: fnd_message.raise_error;
325: --
326: end if;
327: --
320: --
321: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
322: fnd_message.set_token('FIELD', p_alct_by_cd);
323: fnd_message.set_token('TYPE', 'BEN_ALLCT_BY');
324: fnd_message.raise_error;
325: --
326: end if;
327: --
328: end if;