56: if c_sel1%notfound then
57: close c_sel1;
58: -- AT MESSAGE
59: -- The action type id specified is invalid
60: fnd_message.set_name('PER','AME_400575_ACT_TYP_NOT_EXIST');
61: fnd_message.raise_error;
62: end if;
63: close c_sel1;
64: exception
57: close c_sel1;
58: -- AT MESSAGE
59: -- The action type id specified is invalid
60: fnd_message.set_name('PER','AME_400575_ACT_TYP_NOT_EXIST');
61: fnd_message.raise_error;
62: end if;
63: close c_sel1;
64: exception
65: when app_exception.application_exception then
112: nvl(end_date - (1/86400), sysdate);
113: if l_count <> 0 then
114: -- AT MESSAGE
115: -- The action type already has an usage
116: fnd_message.set_name('PER','AME_400663_ACT_USG_EXISTS');
117: fnd_message.raise_error;
118: end if;
119: exception
120: when app_exception.application_exception then
113: if l_count <> 0 then
114: -- AT MESSAGE
115: -- The action type already has an usage
116: fnd_message.set_name('PER','AME_400663_ACT_USG_EXISTS');
117: fnd_message.raise_error;
118: end if;
119: exception
120: when app_exception.application_exception then
121: if hr_multi_message.exception_add
179: ame_util.postListGroupRuleType,
180: ame_util.productionRuleType) then
181: -- AT MESSAGE
182: -- The rule type specified is not valid
183: fnd_message.set_name('PER','AME_400638_INVALID_RULE_TYPE');
184: fnd_message.raise_error;
185: end if;
186: exception
187: when app_exception.application_exception then
180: ame_util.productionRuleType) then
181: -- AT MESSAGE
182: -- The rule type specified is not valid
183: fnd_message.set_name('PER','AME_400638_INVALID_RULE_TYPE');
184: fnd_message.raise_error;
185: end if;
186: exception
187: when app_exception.application_exception then
188: if hr_multi_message.exception_add
238: ,p_rule_type => p_rec.rule_type
239: ,p_effective_date => p_effective_date
240: ,p_object_version_number => p_rec.object_version_number
241: ) THEN
242: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE ', l_proc);
244: fnd_message.set_token('STEP ', '5');
245: fnd_message.raise_error;
246: END IF;
239: ,p_effective_date => p_effective_date
240: ,p_object_version_number => p_rec.object_version_number
241: ) THEN
242: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE ', l_proc);
244: fnd_message.set_token('STEP ', '5');
245: fnd_message.raise_error;
246: END IF;
247: --
240: ,p_object_version_number => p_rec.object_version_number
241: ) THEN
242: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE ', l_proc);
244: fnd_message.set_token('STEP ', '5');
245: fnd_message.raise_error;
246: END IF;
247: --
248: -- EDIT_HERE: Add checks to ensure non-updateable args have
241: ) THEN
242: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE ', l_proc);
244: fnd_message.set_token('STEP ', '5');
245: fnd_message.raise_error;
246: END IF;
247: --
248: -- EDIT_HERE: Add checks to ensure non-updateable args have
249: -- not been updated.
297: if c_sel1%found then
298: close c_sel1;
299: -- AT MESSAGE
300: -- An action type usage of a seeded action type cannot be deleted.
301: fnd_message.set_name('PER','AME_400598_SD_ACTTYPUSG_CN_DEL');
302: fnd_message.raise_error;
303: end if;
304: close c_sel1;
305: exception
298: close c_sel1;
299: -- AT MESSAGE
300: -- An action type usage of a seeded action type cannot be deleted.
301: fnd_message.set_name('PER','AME_400598_SD_ACTTYPUSG_CN_DEL');
302: fnd_message.raise_error;
303: end if;
304: close c_sel1;
305: exception
306: when app_exception.application_exception then
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: End dt_update_validate;
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: End dt_update_validate;
388: --
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: End dt_update_validate;
388: --
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: End dt_update_validate;
388: --
389: -- ----------------------------------------------------------------------------
390: -- |--------------------------< dt_delete_validate >--------------------------|
477: --
478: -- An unhandled or unexpected error has occurred which
479: -- we must report
480: --
481: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
482: fnd_message.set_token('PROCEDURE', l_proc);
483: fnd_message.set_token('STEP','15');
484: fnd_message.raise_error;
485: --
478: -- An unhandled or unexpected error has occurred which
479: -- we must report
480: --
481: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
482: fnd_message.set_token('PROCEDURE', l_proc);
483: fnd_message.set_token('STEP','15');
484: fnd_message.raise_error;
485: --
486: End dt_delete_validate;
479: -- we must report
480: --
481: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
482: fnd_message.set_token('PROCEDURE', l_proc);
483: fnd_message.set_token('STEP','15');
484: fnd_message.raise_error;
485: --
486: End dt_delete_validate;
487: --
480: --
481: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
482: fnd_message.set_token('PROCEDURE', l_proc);
483: fnd_message.set_token('STEP','15');
484: fnd_message.raise_error;
485: --
486: End dt_delete_validate;
487: --
488: -- ----------------------------------------------------------------------------