51: ,p_action_type_id => p_rec.action_type_id
52: ,p_effective_date => p_effective_date
53: ,p_object_version_number => p_rec.object_version_number
54: ) THEN
55: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
56: fnd_message.set_token('PROCEDURE ', l_proc);
57: fnd_message.set_token('STEP ', '5');
58: fnd_message.raise_error;
59: END IF;
52: ,p_effective_date => p_effective_date
53: ,p_object_version_number => p_rec.object_version_number
54: ) THEN
55: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
56: fnd_message.set_token('PROCEDURE ', l_proc);
57: fnd_message.set_token('STEP ', '5');
58: fnd_message.raise_error;
59: END IF;
60: --
53: ,p_object_version_number => p_rec.object_version_number
54: ) THEN
55: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
56: fnd_message.set_token('PROCEDURE ', l_proc);
57: fnd_message.set_token('STEP ', '5');
58: fnd_message.raise_error;
59: END IF;
60: --
61: -- EDIT_HERE: Add checks to ensure non-updateable args have
54: ) THEN
55: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
56: fnd_message.set_token('PROCEDURE ', l_proc);
57: fnd_message.set_token('STEP ', '5');
58: fnd_message.raise_error;
59: END IF;
60: --
61: -- EDIT_HERE: Add checks to ensure non-updateable args have
62: -- not been updated.
111: fetch c_sel1 into l_exists;
112: if c_sel1%notfound then
113: close c_sel1;
114: -- Message: Invalid action type id
115: fnd_message.set_name('PER','AME_400575_ACT_TYP_NOT_EXIST');
116: fnd_message.raise_error;
117: end if;
118: close c_sel1;
119: exception
112: if c_sel1%notfound then
113: close c_sel1;
114: -- Message: Invalid action type id
115: fnd_message.set_name('PER','AME_400575_ACT_TYP_NOT_EXIST');
116: fnd_message.raise_error;
117: end if;
118: close c_sel1;
119: exception
120: when app_exception.application_exception then
187: if(l_temp_count <> 0) then
188: close c_sel1;
189: -- AT Message
190: -- Message: An approver id already exists. Need to delete before.
191: fnd_message.set_name('PER','AME_400607_APPR_TYP_USG_EXISTS');
192: fnd_message.raise_error;
193: end if;
194: else
195: close c_sel1;
188: close c_sel1;
189: -- AT Message
190: -- Message: An approver id already exists. Need to delete before.
191: fnd_message.set_name('PER','AME_400607_APPR_TYP_USG_EXISTS');
192: fnd_message.raise_error;
193: end if;
194: else
195: close c_sel1;
196: -- AT Message
194: else
195: close c_sel1;
196: -- AT Message
197: -- Message: Invalid approver type id
198: fnd_message.set_name('PER','AME_400469_INV_APPROVER_TYPE');
199: fnd_message.raise_error;
200: end if;
201: end if;
202: close c_sel1;
195: close c_sel1;
196: -- AT Message
197: -- Message: Invalid approver type id
198: fnd_message.set_name('PER','AME_400469_INV_APPROVER_TYPE');
199: fnd_message.raise_error;
200: end if;
201: end if;
202: close c_sel1;
203: exception
256: if c_sel1%found then
257: close c_sel1;
258: -- AT MESSAGE
259: -- An approver type usage of a seeded action type cannot be deleted.
260: fnd_message.set_name('PER','AME_400596_SD_APRTYPUSG_CN_DEL');
261: fnd_message.raise_error;
262: end if;
263: close c_sel1;
264: exception
257: close c_sel1;
258: -- AT MESSAGE
259: -- An approver type usage of a seeded action type cannot be deleted.
260: fnd_message.set_name('PER','AME_400596_SD_APRTYPUSG_CN_DEL');
261: fnd_message.raise_error;
262: end if;
263: close c_sel1;
264: exception
265: when app_exception.application_exception then
338: --
339: -- An unhandled or unexpected error has occurred which
340: -- we must report
341: --
342: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
343: fnd_message.set_token('PROCEDURE', l_proc);
344: fnd_message.set_token('STEP','15');
345: fnd_message.raise_error;
346: End dt_update_validate;
339: -- An unhandled or unexpected error has occurred which
340: -- we must report
341: --
342: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
343: fnd_message.set_token('PROCEDURE', l_proc);
344: fnd_message.set_token('STEP','15');
345: fnd_message.raise_error;
346: End dt_update_validate;
347: --
340: -- we must report
341: --
342: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
343: fnd_message.set_token('PROCEDURE', l_proc);
344: fnd_message.set_token('STEP','15');
345: fnd_message.raise_error;
346: End dt_update_validate;
347: --
348: -- ----------------------------------------------------------------------------
341: --
342: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
343: fnd_message.set_token('PROCEDURE', l_proc);
344: fnd_message.set_token('STEP','15');
345: fnd_message.raise_error;
346: End dt_update_validate;
347: --
348: -- ----------------------------------------------------------------------------
349: -- |--------------------------< dt_delete_validate >--------------------------|
436: --
437: -- An unhandled or unexpected error has occurred which
438: -- we must report
439: --
440: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
441: fnd_message.set_token('PROCEDURE', l_proc);
442: fnd_message.set_token('STEP','15');
443: fnd_message.raise_error;
444: --
437: -- An unhandled or unexpected error has occurred which
438: -- we must report
439: --
440: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
441: fnd_message.set_token('PROCEDURE', l_proc);
442: fnd_message.set_token('STEP','15');
443: fnd_message.raise_error;
444: --
445: End dt_delete_validate;
438: -- we must report
439: --
440: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
441: fnd_message.set_token('PROCEDURE', l_proc);
442: fnd_message.set_token('STEP','15');
443: fnd_message.raise_error;
444: --
445: End dt_delete_validate;
446: --
439: --
440: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
441: fnd_message.set_token('PROCEDURE', l_proc);
442: fnd_message.set_token('STEP','15');
443: fnd_message.raise_error;
444: --
445: End dt_delete_validate;
446: --
447: -- ----------------------------------------------------------------------------