DBA Data[Home] [Help]

APPS.AME_APPROVER_GROUP_API dependencies on FND_MESSAGE

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

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

Line 172: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 285: ,p_description => fnd_message.get

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

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

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

Line 667: fnd_message.raise_error;

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

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

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

Line 681: fnd_message.raise_error;

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

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

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

Line 1379: fnd_message.raise_error;

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

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

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

Line 1524: fnd_message.raise_error;

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