DBA Data[Home] [Help]

APPS.AME_APPROVER_GROUP_API dependencies on FND_MESSAGE

Line 169: fnd_message.set_name('PER','AME_400631_GRP_INVALID_MEMBERS');

165: end loop;
166: exception
167: when others then
168: --this point can be reached when group_members table too does not contain the approver detail
169: fnd_message.set_name('PER','AME_400631_GRP_INVALID_MEMBERS');
170: fnd_message.raise_error;
171: end refresh_group_dependents;
172: --
173: --

Line 170: fnd_message.raise_error;

166: exception
167: when others then
168: --this point can be reached when group_members table too does not contain the approver detail
169: fnd_message.set_name('PER','AME_400631_GRP_INVALID_MEMBERS');
170: fnd_message.raise_error;
171: end refresh_group_dependents;
172: --
173: --
174: -- ----------------------------------------------------------------------------

Line 273: fnd_message.set_name('PER', 'AME_400571_PRE_APG_ACT_DESC');

269: --
270: for rec in C_Sel1
271: loop
272: if(rec.name = ame_util.preApprovalTypeName) then
273: fnd_message.set_name('PER', 'AME_400571_PRE_APG_ACT_DESC');
274: elsif (rec.name = ame_util.postApprovalTypeName) then
275: fnd_message.set_name('PER', 'AME_400572_POST_APG_ACT_DESC');
276: elsif (rec.name = ame_util.groupChainApprovalTypeName) then
277: fnd_message.set_name('PER', 'AME_400573_COA_APG_ACT_DESC');

Line 275: fnd_message.set_name('PER', 'AME_400572_POST_APG_ACT_DESC');

271: loop
272: if(rec.name = ame_util.preApprovalTypeName) then
273: fnd_message.set_name('PER', 'AME_400571_PRE_APG_ACT_DESC');
274: elsif (rec.name = ame_util.postApprovalTypeName) then
275: fnd_message.set_name('PER', 'AME_400572_POST_APG_ACT_DESC');
276: elsif (rec.name = ame_util.groupChainApprovalTypeName) then
277: fnd_message.set_name('PER', 'AME_400573_COA_APG_ACT_DESC');
278: end if;
279: fnd_message.set_token('GROUP_NAME', p_name);

Line 277: fnd_message.set_name('PER', 'AME_400573_COA_APG_ACT_DESC');

273: fnd_message.set_name('PER', 'AME_400571_PRE_APG_ACT_DESC');
274: elsif (rec.name = ame_util.postApprovalTypeName) then
275: fnd_message.set_name('PER', 'AME_400572_POST_APG_ACT_DESC');
276: elsif (rec.name = ame_util.groupChainApprovalTypeName) then
277: fnd_message.set_name('PER', 'AME_400573_COA_APG_ACT_DESC');
278: end if;
279: fnd_message.set_token('GROUP_NAME', p_name);
280: ame_action_api.create_ame_action
281: (p_action_type_id => rec.action_type_id

Line 279: fnd_message.set_token('GROUP_NAME', p_name);

275: fnd_message.set_name('PER', 'AME_400572_POST_APG_ACT_DESC');
276: elsif (rec.name = ame_util.groupChainApprovalTypeName) then
277: fnd_message.set_name('PER', 'AME_400573_COA_APG_ACT_DESC');
278: end if;
279: fnd_message.set_token('GROUP_NAME', p_name);
280: ame_action_api.create_ame_action
281: (p_action_type_id => rec.action_type_id
282: ,p_parameter => to_char(l_approval_group_id)
283: ,p_description => fnd_message.get

Line 283: ,p_description => fnd_message.get

279: fnd_message.set_token('GROUP_NAME', p_name);
280: ame_action_api.create_ame_action
281: (p_action_type_id => rec.action_type_id
282: ,p_parameter => to_char(l_approval_group_id)
283: ,p_description => fnd_message.get
284: ,p_parameter_two => null
285: ,p_action_id => l_action_id
286: ,p_object_version_number => l_object_version_number
287: ,p_start_date => l_start_date

Line 664: fnd_message.set_name('PER', 'AME_400558_RULES_EXIST_FOR_APG');

660: fetch CSel4 into l_rule_count;
661: close CSel4;
662: if(l_rule_count <> 0) then
663: --there are rules using actions on this group
664: fnd_message.set_name('PER', 'AME_400558_RULES_EXIST_FOR_APG');
665: fnd_message.raise_error;
666: end if;
667:
668: --throw an error if config is existing for this group

Line 665: fnd_message.raise_error;

661: close CSel4;
662: if(l_rule_count <> 0) then
663: --there are rules using actions on this group
664: fnd_message.set_name('PER', 'AME_400558_RULES_EXIST_FOR_APG');
665: fnd_message.raise_error;
666: end if;
667:
668: --throw an error if config is existing for this group
669: select count(*)

Line 678: fnd_message.set_name('PER', 'AME_400559_CFG_EXIST_FOR_APG');

674: and a.application_id = aca.application_id
675: and sysdate between aca.start_date and nvl(aca.end_date - (1/86400), sysdate)
676: and sysdate between a.start_date and nvl(a.end_date - (1/86400), sysdate);
677: if(l_config_count <> 0) then
678: fnd_message.set_name('PER', 'AME_400559_CFG_EXIST_FOR_APG');
679: fnd_message.raise_error;
680: end if;
681:
682: --delete group actions for group related action_types

Line 679: fnd_message.raise_error;

675: and sysdate between aca.start_date and nvl(aca.end_date - (1/86400), sysdate)
676: and sysdate between a.start_date and nvl(a.end_date - (1/86400), sysdate);
677: if(l_config_count <> 0) then
678: fnd_message.set_name('PER', 'AME_400559_CFG_EXIST_FOR_APG');
679: fnd_message.raise_error;
680: end if;
681:
682: --delete group actions for group related action_types
683: for rec in C_Sel2

Line 1376: fnd_message.set_name('PER', 'AME_400560_APG_ITEM_IS_INVALID');

1372: fetch Csel1 into l_approval_group_id;
1373: --handle case where item_id is invalid
1374: if Csel1%notfound then
1375: close Csel1;
1376: fnd_message.set_name('PER', 'AME_400560_APG_ITEM_IS_INVALID');
1377: fnd_message.raise_error;
1378: else
1379: close Csel1;
1380: end if;

Line 1377: fnd_message.raise_error;

1373: --handle case where item_id is invalid
1374: if Csel1%notfound then
1375: close Csel1;
1376: fnd_message.set_name('PER', 'AME_400560_APG_ITEM_IS_INVALID');
1377: fnd_message.raise_error;
1378: else
1379: close Csel1;
1380: end if;
1381: ame_gpi_del.del(p_effective_date => sysdate

Line 1521: fnd_message.set_name('PER', 'AME_400560_APG_ITEM_IS_INVALID');

1517: fetch Csel1 into l_approval_group_id;
1518: --handle case when item_id is invalid
1519: if Csel1%notfound then
1520: close Csel1;
1521: fnd_message.set_name('PER', 'AME_400560_APG_ITEM_IS_INVALID');
1522: fnd_message.raise_error;
1523: else
1524: close Csel1;
1525: end if;

Line 1522: fnd_message.raise_error;

1518: --handle case when item_id is invalid
1519: if Csel1%notfound then
1520: close Csel1;
1521: fnd_message.set_name('PER', 'AME_400560_APG_ITEM_IS_INVALID');
1522: fnd_message.raise_error;
1523: else
1524: close Csel1;
1525: end if;
1526: ame_gpi_upd.upd(p_effective_date => sysdate