54: open c_sel1;
55: fetch c_sel1 into l_exists;
56: if c_sel1%notfound then
57: close c_sel1;
58: fnd_message.set_name('PER','AME_400481_INV_ACTION_ID');
59: fnd_message.raise_error;
60: end if;
61: close c_sel1;
62: exception
55: fetch c_sel1 into l_exists;
56: if c_sel1%notfound then
57: close c_sel1;
58: fnd_message.set_name('PER','AME_400481_INV_ACTION_ID');
59: fnd_message.raise_error;
60: end if;
61: close c_sel1;
62: exception
63: when app_exception.application_exception then
117: open c_sel1;
118: fetch c_sel1 into l_exists;
119: if c_sel1%notfound then
120: close c_sel1;
121: fnd_message.set_name('PER','AME_400480_INV_RULE_ID');
122: fnd_message.raise_error;
123: end if;
124: close c_sel1;
125: exception
118: fetch c_sel1 into l_exists;
119: if c_sel1%notfound then
120: close c_sel1;
121: fnd_message.set_name('PER','AME_400480_INV_RULE_ID');
122: fnd_message.raise_error;
123: end if;
124: close c_sel1;
125: exception
126: 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.
258: --
259: -- An unhandled or unexpected error has occurred which
260: -- we must report
261: --
262: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
263: fnd_message.set_token('PROCEDURE', l_proc);
264: fnd_message.set_token('STEP','15');
265: fnd_message.raise_error;
266: End dt_update_validate;
259: -- An unhandled or unexpected error has occurred which
260: -- we must report
261: --
262: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
263: fnd_message.set_token('PROCEDURE', l_proc);
264: fnd_message.set_token('STEP','15');
265: fnd_message.raise_error;
266: End dt_update_validate;
267: --
260: -- we must report
261: --
262: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
263: fnd_message.set_token('PROCEDURE', l_proc);
264: fnd_message.set_token('STEP','15');
265: fnd_message.raise_error;
266: End dt_update_validate;
267: --
268: -- ----------------------------------------------------------------------------
261: --
262: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
263: fnd_message.set_token('PROCEDURE', l_proc);
264: fnd_message.set_token('STEP','15');
265: fnd_message.raise_error;
266: End dt_update_validate;
267: --
268: -- ----------------------------------------------------------------------------
269: -- |--------------------------< dt_delete_validate >--------------------------|
356: --
357: -- An unhandled or unexpected error has occurred which
358: -- we must report
359: --
360: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
361: fnd_message.set_token('PROCEDURE', l_proc);
362: fnd_message.set_token('STEP','15');
363: fnd_message.raise_error;
364: --
357: -- An unhandled or unexpected error has occurred which
358: -- we must report
359: --
360: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
361: fnd_message.set_token('PROCEDURE', l_proc);
362: fnd_message.set_token('STEP','15');
363: fnd_message.raise_error;
364: --
365: End dt_delete_validate;
358: -- we must report
359: --
360: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
361: fnd_message.set_token('PROCEDURE', l_proc);
362: fnd_message.set_token('STEP','15');
363: fnd_message.raise_error;
364: --
365: End dt_delete_validate;
366: --
359: --
360: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
361: fnd_message.set_token('PROCEDURE', l_proc);
362: fnd_message.set_token('STEP','15');
363: fnd_message.raise_error;
364: --
365: End dt_delete_validate;
366: --
367: -- ----------------------------------------------------------------------------