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.
110: open c_sel1;
111: fetch c_sel1 into l_exists;
112: if c_sel1%notfound then
113: close c_sel1;
114: fnd_message.set_name('PER','AME_400575_ACT_TYP_NOT_EXIST');
115: -- Need message here
116: fnd_message.raise_error;
117: end if;
118: close c_sel1;
112: if c_sel1%notfound then
113: close c_sel1;
114: fnd_message.set_name('PER','AME_400575_ACT_TYP_NOT_EXIST');
115: -- Need message here
116: fnd_message.raise_error;
117: end if;
118: close c_sel1;
119: exception
120: when app_exception.application_exception then
175: fetch c_sel1 into l_exists;
176: if c_sel1%notfound then
177: close c_sel1;
178: -- Invalid attribute id
179: fnd_message.set_name('PER','AME_400473_INV_ATTRIBUTE_ID');
180: -- Need message here
181: fnd_message.raise_error;
182: end if;
183: close c_sel1;
177: close c_sel1;
178: -- Invalid attribute id
179: fnd_message.set_name('PER','AME_400473_INV_ATTRIBUTE_ID');
180: -- Need message here
181: fnd_message.raise_error;
182: end if;
183: close c_sel1;
184: exception
185: when app_exception.application_exception then
212: open c_sell;
213: fetch c_sell into l_exists;
214: if c_sell%found then
215: --It is a mandatory attribute.should not be added
216: fnd_message.set_name('PER','AME_400792_ATTR_IS_MAN');
217: fnd_message.raise_error;
218:
219: end if;
220: close c_sell;
213: fetch c_sell into l_exists;
214: if c_sell%found then
215: --It is a mandatory attribute.should not be added
216: fnd_message.set_name('PER','AME_400792_ATTR_IS_MAN');
217: fnd_message.raise_error;
218:
219: end if;
220: close c_sell;
221: exception
249: fetch c_sell into l_created_by;
250: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and
251: ame_utility_pkg.check_seeddb = 'N'
252: then
253: fnd_message.set_name('PER','AME_400793_SEED_ATY_NO_UPD');
254: fnd_message.raise_error;
255: end if;
256: close c_sell;
257: exception
250: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and
251: ame_utility_pkg.check_seeddb = 'N'
252: then
253: fnd_message.set_name('PER','AME_400793_SEED_ATY_NO_UPD');
254: fnd_message.raise_error;
255: end if;
256: close c_sell;
257: exception
258: when app_exception.application_exception then
311: if c_sel1%found then
312: close c_sel1;
313: -- AT MESSAGE
314: -- A required attribute of a seeded action type cannot be deleted.
315: fnd_message.set_name('PER','AME_400599_SD_REQ_ATT_CN_DEL');
316: fnd_message.raise_error;
317: end if;
318: close c_sel1;
319: exception
312: close c_sel1;
313: -- AT MESSAGE
314: -- A required attribute of a seeded action type cannot be deleted.
315: fnd_message.set_name('PER','AME_400599_SD_REQ_ATT_CN_DEL');
316: fnd_message.raise_error;
317: end if;
318: close c_sel1;
319: exception
320: when app_exception.application_exception then
393: --
394: -- An unhandled or unexpected error has occurred which
395: -- we must report
396: --
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','15');
400: fnd_message.raise_error;
401: End dt_update_validate;
394: -- An unhandled or unexpected error has occurred which
395: -- we must report
396: --
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','15');
400: fnd_message.raise_error;
401: End dt_update_validate;
402: --
395: -- we must report
396: --
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','15');
400: fnd_message.raise_error;
401: End dt_update_validate;
402: --
403: -- ----------------------------------------------------------------------------
396: --
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','15');
400: fnd_message.raise_error;
401: End dt_update_validate;
402: --
403: -- ----------------------------------------------------------------------------
404: -- |--------------------------< dt_delete_validate >--------------------------|
491: --
492: -- An unhandled or unexpected error has occurred which
493: -- we must report
494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: --
492: -- An unhandled or unexpected error has occurred which
493: -- we must report
494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: --
500: End dt_delete_validate;
493: -- we must report
494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: --
500: End dt_delete_validate;
501: --
494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: --
500: End dt_delete_validate;
501: --
502: -- ----------------------------------------------------------------------------