DBA Data[Home] [Help]

APPS.AME_ATR_BUS dependencies on FND_MESSAGE

Line 71: fnd_message.set_name('PER','AME_400469_INV_APPROVER_TYPE');

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

Line 72: fnd_message.raise_error;

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');

Line 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

Line 77: 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
81: when app_exception.application_exception then

Line 137: fnd_message.set_name('PER','AME_400471_INV_ATTRIBUTE_TYPE');

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

Line 138: fnd_message.raise_error;

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

Line 202: fnd_message.set_name('PER','AME_400472_INV_ITEM_CLASS');

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

Line 203: fnd_message.raise_error;

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

Line 272: fnd_message.set_name('PER','AME_400667_ATT_NAME_EXIST');

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

Line 273: fnd_message.raise_error;

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

Line 344: fnd_message.set_name('PER','AME_400171_ATT_IS_IN_USE');

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;

Line 345: fnd_message.raise_error;

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;

Line 352: fnd_message.set_name('PER','AME_400170_ATT_MAND_CANT_DEL');

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

Line 353: fnd_message.raise_error;

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

Line 408: fnd_message.set_name('AME','AME_400523_ATT_ATTR_USG_EXIST');

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

Line 409: fnd_message.set_token('TABLE_NAME','ame_attribute_usages');

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;

Line 417: fnd_message.set_name('AME','AME_400170_ATT_MAND_CANT_DEL');

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

Line 418: fnd_message.set_token('TABLE_NAME','ame_mandatory_attributes');

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;

Line 426: fnd_message.set_name('AME','AME_400524_ATT_COND_EXIST');

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: --

Line 427: fnd_message.set_token('TABLE_NAME','ame_conditions');

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;

Line 477: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 478: fnd_message.set_token('PROCEDURE ', l_proc);

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: --

Line 479: fnd_message.set_token('STEP ', '5');

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) <>

Line 480: fnd_message.raise_error;

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)

Line 606: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 607: fnd_message.set_token('PROCEDURE', l_proc);

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: --

Line 608: fnd_message.set_token('STEP','15');

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: -- ----------------------------------------------------------------------------

Line 609: fnd_message.raise_error;

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 >--------------------------|

Line 707: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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: --

Line 708: fnd_message.set_token('PROCEDURE', l_proc);

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;

Line 709: fnd_message.set_token('STEP','15');

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: --

Line 710: fnd_message.raise_error;

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: -- ----------------------------------------------------------------------------