67: open c_sel1;
68: fetch c_sel1 into l_exists;
69: if c_sel1%notfound then
70: close c_sel1;
71: fnd_message.set_name('PER','AME_400469_INV_APPROVER_TYPE');
72: fnd_message.raise_error;
73: end if;
74: close c_sel1;
75: else
68: fetch c_sel1 into l_exists;
69: if c_sel1%notfound then
70: close c_sel1;
71: fnd_message.set_name('PER','AME_400469_INV_APPROVER_TYPE');
72: fnd_message.raise_error;
73: end if;
74: close c_sel1;
75: else
76: fnd_message.set_name('PER','AME_400470_NO_APPROVER_TYPE');
72: fnd_message.raise_error;
73: end if;
74: close c_sel1;
75: else
76: fnd_message.set_name('PER','AME_400470_NO_APPROVER_TYPE');
77: fnd_message.raise_error;
78: end if;
79: end if;
80: exception
73: end if;
74: close c_sel1;
75: else
76: fnd_message.set_name('PER','AME_400470_NO_APPROVER_TYPE');
77: fnd_message.raise_error;
78: end if;
79: end if;
80: exception
81: when app_exception.application_exception then
133: p_attribute_type = ame_util.currencyAttributeType or
134: p_attribute_type = ame_util.dateAttributeType or
135: p_attribute_type = ame_util.numberAttributeType or
136: p_attribute_type = ame_util.stringAttributeType) then
137: fnd_message.set_name('PER','AME_400471_INV_ATTRIBUTE_TYPE');
138: fnd_message.raise_error;
139: end if;
140: exception
141: when app_exception.application_exception then
134: p_attribute_type = ame_util.dateAttributeType or
135: p_attribute_type = ame_util.numberAttributeType or
136: p_attribute_type = ame_util.stringAttributeType) then
137: fnd_message.set_name('PER','AME_400471_INV_ATTRIBUTE_TYPE');
138: fnd_message.raise_error;
139: end if;
140: exception
141: when app_exception.application_exception then
142: if hr_multi_message.exception_add
198: open c_sel1;
199: fetch c_sel1 into l_exists;
200: if c_sel1%notfound then
201: close c_sel1;
202: fnd_message.set_name('PER','AME_400472_INV_ITEM_CLASS');
203: fnd_message.raise_error;
204: end if;
205: close c_sel1;
206: exception
199: fetch c_sel1 into l_exists;
200: if c_sel1%notfound then
201: close c_sel1;
202: fnd_message.set_name('PER','AME_400472_INV_ITEM_CLASS');
203: fnd_message.raise_error;
204: end if;
205: close c_sel1;
206: exception
207: when app_exception.application_exception then
268: fetch c_sel1 into tempCount;
269: if c_sel1%found and
270: tempCount > 0 then
271: close c_sel1;
272: fnd_message.set_name('PER','AME_400667_ATT_NAME_EXIST');
273: fnd_message.raise_error;
274: end if;
275: close c_sel1;
276: exception
269: if c_sel1%found and
270: tempCount > 0 then
271: close c_sel1;
272: fnd_message.set_name('PER','AME_400667_ATT_NAME_EXIST');
273: fnd_message.raise_error;
274: end if;
275: close c_sel1;
276: exception
277: when app_exception.application_exception then
340: open c_sel1;
341: fetch c_sel1 into l_exists;
342: if c_sel1%found then
343: close c_sel1;
344: fnd_message.set_name('PER','AME_400171_ATT_IS_IN_USE');
345: fnd_message.raise_error;
346: end if;
347: close c_sel1;
348: open c_sel2;
341: fetch c_sel1 into l_exists;
342: if c_sel1%found then
343: close c_sel1;
344: fnd_message.set_name('PER','AME_400171_ATT_IS_IN_USE');
345: fnd_message.raise_error;
346: end if;
347: close c_sel1;
348: open c_sel2;
349: fetch c_sel2 into l_exists;
348: open c_sel2;
349: fetch c_sel2 into l_exists;
350: if c_sel2%found then
351: close c_sel2;
352: fnd_message.set_name('PER','AME_400170_ATT_MAND_CANT_DEL');
353: fnd_message.raise_error;
354: end if;
355: close c_sel2;
356: exception
349: fetch c_sel2 into l_exists;
350: if c_sel2%found then
351: close c_sel2;
352: fnd_message.set_name('PER','AME_400170_ATT_MAND_CANT_DEL');
353: fnd_message.raise_error;
354: end if;
355: close c_sel2;
356: exception
357: when app_exception.application_exception then
404: Open C_Sel1;
405: Fetch C_Sel1 into l_child_count;
406: Close C_Sel1;
407: If l_child_count >0 then
408: fnd_message.set_name('AME','AME_400523_ATT_ATTR_USG_EXIST');
409: fnd_message.set_token('TABLE_NAME','ame_attribute_usages');
410: hr_multi_message.add;
411: End If;
412: -- ame_mandatory_attributes
405: Fetch C_Sel1 into l_child_count;
406: Close C_Sel1;
407: If l_child_count >0 then
408: fnd_message.set_name('AME','AME_400523_ATT_ATTR_USG_EXIST');
409: fnd_message.set_token('TABLE_NAME','ame_attribute_usages');
410: hr_multi_message.add;
411: End If;
412: -- ame_mandatory_attributes
413: Open C_Sel2;
413: Open C_Sel2;
414: Fetch C_Sel2 into l_child_count;
415: Close C_Sel2;
416: If l_child_count >0 then
417: fnd_message.set_name('AME','AME_400170_ATT_MAND_CANT_DEL');
418: fnd_message.set_token('TABLE_NAME','ame_mandatory_attributes');
419: hr_multi_message.add;
420: End If;
421: -- ame_conditions
414: Fetch C_Sel2 into l_child_count;
415: Close C_Sel2;
416: If l_child_count >0 then
417: fnd_message.set_name('AME','AME_400170_ATT_MAND_CANT_DEL');
418: fnd_message.set_token('TABLE_NAME','ame_mandatory_attributes');
419: hr_multi_message.add;
420: End If;
421: -- ame_conditions
422: Open C_Sel3;
422: Open C_Sel3;
423: Fetch C_Sel3 into l_child_count;
424: Close C_Sel3;
425: If l_child_count >0 then
426: fnd_message.set_name('AME','AME_400524_ATT_COND_EXIST');
427: fnd_message.set_token('TABLE_NAME','ame_conditions');
428: hr_multi_message.add;
429: End If;
430: --
423: Fetch C_Sel3 into l_child_count;
424: Close C_Sel3;
425: If l_child_count >0 then
426: fnd_message.set_name('AME','AME_400524_ATT_COND_EXIST');
427: fnd_message.set_token('TABLE_NAME','ame_conditions');
428: hr_multi_message.add;
429: End If;
430: --
431: End chk_usages_exist;
473: (p_attribute_id => p_rec.attribute_id
474: ,p_effective_date => p_effective_date
475: ,p_object_version_number => p_rec.object_version_number
476: ) THEN
477: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
478: fnd_message.set_token('PROCEDURE ', l_proc);
479: fnd_message.set_token('STEP ', '5');
480: fnd_message.raise_error;
481: END IF;
474: ,p_effective_date => p_effective_date
475: ,p_object_version_number => p_rec.object_version_number
476: ) THEN
477: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
478: fnd_message.set_token('PROCEDURE ', l_proc);
479: fnd_message.set_token('STEP ', '5');
480: fnd_message.raise_error;
481: END IF;
482: --
475: ,p_object_version_number => p_rec.object_version_number
476: ) THEN
477: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
478: fnd_message.set_token('PROCEDURE ', l_proc);
479: fnd_message.set_token('STEP ', '5');
480: fnd_message.raise_error;
481: END IF;
482: --
483: if nvl(p_rec.name,hr_api.g_varchar2) <>
476: ) THEN
477: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
478: fnd_message.set_token('PROCEDURE ', l_proc);
479: fnd_message.set_token('STEP ', '5');
480: fnd_message.raise_error;
481: END IF;
482: --
483: if nvl(p_rec.name,hr_api.g_varchar2) <>
484: nvl(ame_atr_shd.g_old_rec.name,hr_api.g_varchar2)
602: --
603: -- An unhandled or unexpected error has occurred which
604: -- we must report
605: --
606: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
607: fnd_message.set_token('PROCEDURE', l_proc);
608: fnd_message.set_token('STEP','15');
609: fnd_message.raise_error;
610: End dt_update_validate;
603: -- An unhandled or unexpected error has occurred which
604: -- we must report
605: --
606: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
607: fnd_message.set_token('PROCEDURE', l_proc);
608: fnd_message.set_token('STEP','15');
609: fnd_message.raise_error;
610: End dt_update_validate;
611: --
604: -- we must report
605: --
606: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
607: fnd_message.set_token('PROCEDURE', l_proc);
608: fnd_message.set_token('STEP','15');
609: fnd_message.raise_error;
610: End dt_update_validate;
611: --
612: -- ----------------------------------------------------------------------------
605: --
606: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
607: fnd_message.set_token('PROCEDURE', l_proc);
608: fnd_message.set_token('STEP','15');
609: fnd_message.raise_error;
610: End dt_update_validate;
611: --
612: -- ----------------------------------------------------------------------------
613: -- |--------------------------< dt_delete_validate >--------------------------|
703: --
704: -- An unhandled or unexpected error has occurred which
705: -- we must report
706: --
707: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
708: fnd_message.set_token('PROCEDURE', l_proc);
709: fnd_message.set_token('STEP','15');
710: fnd_message.raise_error;
711: --
704: -- An unhandled or unexpected error has occurred which
705: -- we must report
706: --
707: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
708: fnd_message.set_token('PROCEDURE', l_proc);
709: fnd_message.set_token('STEP','15');
710: fnd_message.raise_error;
711: --
712: End dt_delete_validate;
705: -- we must report
706: --
707: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
708: fnd_message.set_token('PROCEDURE', l_proc);
709: fnd_message.set_token('STEP','15');
710: fnd_message.raise_error;
711: --
712: End dt_delete_validate;
713: --
706: --
707: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
708: fnd_message.set_token('PROCEDURE', l_proc);
709: fnd_message.set_token('STEP','15');
710: fnd_message.raise_error;
711: --
712: End dt_delete_validate;
713: --
714: -- ----------------------------------------------------------------------------