56: open c_sel1;
57: fetch c_sel1 into l_exists;
58: if c_sel1%notfound then
59: close c_sel1;
60: fnd_message.set_name('PER','AME_400479_INV_CONDITION_ID');
61: fnd_message.raise_error;
62: end if;
63: close c_sel1;
64: exception
57: fetch c_sel1 into l_exists;
58: if c_sel1%notfound then
59: close c_sel1;
60: fnd_message.set_name('PER','AME_400479_INV_CONDITION_ID');
61: fnd_message.raise_error;
62: end if;
63: close c_sel1;
64: exception
65: when app_exception.application_exception then
119: open c_sel1;
120: fetch c_sel1 into l_exists;
121: if c_sel1%notfound then
122: close c_sel1;
123: fnd_message.set_name('PER','AME_400480_INV_RULE_ID');
124: fnd_message.raise_error;
125: end if;
126: close c_sel1;
127: exception
120: fetch c_sel1 into l_exists;
121: if c_sel1%notfound then
122: close c_sel1;
123: fnd_message.set_name('PER','AME_400480_INV_RULE_ID');
124: fnd_message.raise_error;
125: end if;
126: close c_sel1;
127: exception
128: when app_exception.application_exception then
177: ,p_rule_id => p_rec.rule_id
178: ,p_effective_date => p_effective_date
179: ,p_object_version_number => p_rec.object_version_number
180: ) THEN
181: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
182: fnd_message.set_token('PROCEDURE ', l_proc);
183: fnd_message.set_token('STEP ', '5');
184: fnd_message.raise_error;
185: END IF;
178: ,p_effective_date => p_effective_date
179: ,p_object_version_number => p_rec.object_version_number
180: ) THEN
181: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
182: fnd_message.set_token('PROCEDURE ', l_proc);
183: fnd_message.set_token('STEP ', '5');
184: fnd_message.raise_error;
185: END IF;
186: --
179: ,p_object_version_number => p_rec.object_version_number
180: ) THEN
181: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
182: fnd_message.set_token('PROCEDURE ', l_proc);
183: fnd_message.set_token('STEP ', '5');
184: fnd_message.raise_error;
185: END IF;
186: --
187: -- EDIT_HERE: Add checks to ensure non-updateable args have
180: ) THEN
181: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
182: fnd_message.set_token('PROCEDURE ', l_proc);
183: fnd_message.set_token('STEP ', '5');
184: fnd_message.raise_error;
185: END IF;
186: --
187: -- EDIT_HERE: Add checks to ensure non-updateable args have
188: -- not been updated.
257: --
258: -- An unhandled or unexpected error has occurred which
259: -- we must report
260: --
261: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
262: fnd_message.set_token('PROCEDURE', l_proc);
263: fnd_message.set_token('STEP','15');
264: fnd_message.raise_error;
265: End dt_update_validate;
258: -- An unhandled or unexpected error has occurred which
259: -- we must report
260: --
261: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
262: fnd_message.set_token('PROCEDURE', l_proc);
263: fnd_message.set_token('STEP','15');
264: fnd_message.raise_error;
265: End dt_update_validate;
266: --
259: -- we must report
260: --
261: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
262: fnd_message.set_token('PROCEDURE', l_proc);
263: fnd_message.set_token('STEP','15');
264: fnd_message.raise_error;
265: End dt_update_validate;
266: --
267: -- ----------------------------------------------------------------------------
260: --
261: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
262: fnd_message.set_token('PROCEDURE', l_proc);
263: fnd_message.set_token('STEP','15');
264: fnd_message.raise_error;
265: End dt_update_validate;
266: --
267: -- ----------------------------------------------------------------------------
268: -- |--------------------------< dt_delete_validate >--------------------------|
355: --
356: -- An unhandled or unexpected error has occurred which
357: -- we must report
358: --
359: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
360: fnd_message.set_token('PROCEDURE', l_proc);
361: fnd_message.set_token('STEP','15');
362: fnd_message.raise_error;
363: --
356: -- An unhandled or unexpected error has occurred which
357: -- we must report
358: --
359: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
360: fnd_message.set_token('PROCEDURE', l_proc);
361: fnd_message.set_token('STEP','15');
362: fnd_message.raise_error;
363: --
364: End dt_delete_validate;
357: -- we must report
358: --
359: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
360: fnd_message.set_token('PROCEDURE', l_proc);
361: fnd_message.set_token('STEP','15');
362: fnd_message.raise_error;
363: --
364: End dt_delete_validate;
365: --
358: --
359: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
360: fnd_message.set_token('PROCEDURE', l_proc);
361: fnd_message.set_token('STEP','15');
362: fnd_message.raise_error;
363: --
364: End dt_delete_validate;
365: --
366: -- ----------------------------------------------------------------------------