DBA Data[Home] [Help]

APPS.IEM_EMAILPROC_PVT dependencies on STANDARD

Line 75: --Standard Savepoint

71: where ep.created_by=fu.user_id and ep.rule_type= v_rule_type
72: order by UPPER(name);
73: BEGIN
74:
75: --Standard Savepoint
76: SAVEPOINT loadEmailProc_pvt;
77:
78: -- Standard call to check for call compatibility.
79: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 78: -- Standard call to check for call compatibility.

74:
75: --Standard Savepoint
76: SAVEPOINT loadEmailProc_pvt;
77:
78: -- Standard call to check for call compatibility.
79: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
80: p_api_version_number,
81: l_api_name,
82: G_PKG_NAME)

Line 212: --Standard check of p_commit

208: x_3Rs := l_3Rs;
209: x_document := l_documents;
210: x_route := l_routes;
211:
212: --Standard check of p_commit
213: IF FND_API.to_Boolean(p_commit) THEN
214: COMMIT WORK;
215: END IF;
216:

Line 309: --Standard Savepoint

305: order by a.priority asc;
306:
307: BEGIN
308:
309: --Standard Savepoint
310: SAVEPOINT loadAcctEmailProc_pvt;
311:
312: -- Standard call to check for call compatibility.
313: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 312: -- Standard call to check for call compatibility.

308:
309: --Standard Savepoint
310: SAVEPOINT loadAcctEmailProc_pvt;
311:
312: -- Standard call to check for call compatibility.
313: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
314: p_api_version_number,
315: l_api_name,
316: G_PKG_NAME)

Line 440: --Standard check of p_commit

436: x_3Rs := l_3Rs;
437: x_document := l_documents;
438: x_route := l_routes;
439:
440: --Standard check of p_commit
441: IF FND_API.to_Boolean(p_commit) THEN
442: COMMIT WORK;
443: END IF;
444:

Line 501: --Standard Savepoint

497: select action_id from iem_actions where emailproc_id = v_emailProc_id;
498:
499: BEGIN
500:
501: --Standard Savepoint
502: SAVEPOINT loadAcctEmailProc_pvt;
503:
504: -- Standard call to check for call compatibility.
505: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 504: -- Standard call to check for call compatibility.

500:
501: --Standard Savepoint
502: SAVEPOINT loadAcctEmailProc_pvt;
503:
504: -- Standard call to check for call compatibility.
505: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
506: p_api_version_number,
507: l_api_name,
508: G_PKG_NAME)

Line 573: --Standard check of p_commit

569: WHERE emailproc_id = p_emailProc_id and email_account_id = p_acct_id;
570:
571: END IF;
572:
573: --Standard check of p_commit
574: IF FND_API.to_Boolean(p_commit) THEN
575: COMMIT WORK;
576: END IF;
577:

Line 674: -- Standard Start of API savepoint

670: l_all_emails VARCHAR2(1);
671: l_redirect_same_acct NUMBER;
672:
673: BEGIN
674: -- Standard Start of API savepoint
675: SAVEPOINT update_item_wrap;
676:
677: -- Standard call to check for call compatibility.
678: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 677: -- Standard call to check for call compatibility.

673: BEGIN
674: -- Standard Start of API savepoint
675: SAVEPOINT update_item_wrap;
676:
677: -- Standard call to check for call compatibility.
678: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
679:
680: p_api_version_number,
681: l_api_name,

Line 1041: -- Standard Start of API savepoint

1037: IEM_ADM_AUTOPRC_NO_PARAMETERS EXCEPTION;
1038: IEM_ADM_INVALID_PROC_NAME EXCEPTION;
1039: BEGIN
1040:
1041: -- Standard Start of API savepoint
1042: SAVEPOINT create_item_wrap;
1043:
1044: -- Standard call to check for call compatibility.
1045: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 1044: -- Standard call to check for call compatibility.

1040:
1041: -- Standard Start of API savepoint
1042: SAVEPOINT create_item_wrap;
1043:
1044: -- Standard call to check for call compatibility.
1045: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1046: p_api_version_number,
1047: l_api_name,
1048: G_PKG_NAME)

Line 1291: -- Standard Start of API savepoint

1287: IEM_ADMIN_ACCOUNT_NOT_EXIST EXCEPTION;
1288: IEM_ACCOUNT_ROUTE_NOT_UPDATED EXCEPTION;
1289: IEM_NOT_REDIRECT_SAME_ACCT EXCEPTION;
1290: BEGIN
1291: -- Standard Start of API savepoint
1292: SAVEPOINT create_wrap_account_routes_PVT;
1293:
1294: -- Standard call to check for call compatibility.
1295: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 1294: -- Standard call to check for call compatibility.

1290: BEGIN
1291: -- Standard Start of API savepoint
1292: SAVEPOINT create_wrap_account_routes_PVT;
1293:
1294: -- Standard call to check for call compatibility.
1295: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1296:
1297: p_api_version_number,
1298: l_api_name,

Line 1361: -- Standard Check Of p_commit.

1357: raise IEM_ACCOUNT_ROUTE_NOT_UPDATED;
1358:
1359: end if;
1360:
1361: -- Standard Check Of p_commit.
1362: IF FND_API.To_Boolean(p_commit) THEN
1363: COMMIT WORK;
1364: END IF;
1365: -- Standard callto get message count and if count is 1, get message info.

Line 1365: -- Standard callto get message count and if count is 1, get message info.

1361: -- Standard Check Of p_commit.
1362: IF FND_API.To_Boolean(p_commit) THEN
1363: COMMIT WORK;
1364: END IF;
1365: -- Standard callto get message count and if count is 1, get message info.
1366: FND_MSG_PUB.Count_And_Get
1367: ( p_count => x_msg_count,
1368: p_data => x_msg_data
1369: );

Line 1468: -- Standard Start of API savepoint

1464: l_msg_data VARCHAR2(2000);
1465: IEM_ACCT_EMAILPROC_NOT_DELETED EXCEPTION;
1466: IEM_ACCT_EMAILPROC_NOT_UPDATED EXCEPTION;
1467: BEGIN
1468: -- Standard Start of API savepoint
1469: SAVEPOINT update_wrap_acct_emailproc_PVT;
1470:
1471: -- Standard call to check for call compatibility.
1472: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 1471: -- Standard call to check for call compatibility.

1467: BEGIN
1468: -- Standard Start of API savepoint
1469: SAVEPOINT update_wrap_acct_emailproc_PVT;
1470:
1471: -- Standard call to check for call compatibility.
1472: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1473: p_api_version_number,
1474: l_api_name,
1475: G_PKG_NAME)

Line 1530: -- Standard Check Of p_commit.

1526:
1527: end if;
1528:
1529:
1530: -- Standard Check Of p_commit.
1531: IF FND_API.To_Boolean(p_commit) THEN
1532: COMMIT WORK;
1533: END IF;
1534:

Line 1535: -- Standard callto get message count and if count is 1, get message info.

1531: IF FND_API.To_Boolean(p_commit) THEN
1532: COMMIT WORK;
1533: END IF;
1534:
1535: -- Standard callto get message count and if count is 1, get message info.
1536: FND_MSG_PUB.Count_And_Get
1537:
1538: ( p_count => x_msg_count,
1539: p_data => x_msg_data

Line 1619: --Standard Savepoint

1615: BEGIN
1616:
1617:
1618:
1619: --Standard Savepoint
1620: SAVEPOINT delete_item_batch;
1621:
1622: -- Standard call to check for call compatibility.
1623: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 1622: -- Standard call to check for call compatibility.

1618:
1619: --Standard Savepoint
1620: SAVEPOINT delete_item_batch;
1621:
1622: -- Standard call to check for call compatibility.
1623: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1624: p_api_version_number,
1625: l_api_name,
1626: G_PKG_NAME)

Line 1686: --Standard check of p_commit

1682: --remove iem_email_actions
1683: delete from iem_actions where emailproc_id = p_emailproc_id;
1684:
1685:
1686: --Standard check of p_commit
1687: IF FND_API.to_Boolean(p_commit) THEN
1688: COMMIT WORK;
1689: END IF;
1690:

Line 1742: --Standard Savepoint

1738: l_api_version_number number:=1.0;
1739:
1740: BEGIN
1741:
1742: --Standard Savepoint
1743: SAVEPOINT delete_acct_emailproc_by_acct;
1744:
1745: -- Standard call to check for call compatibility.
1746: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 1745: -- Standard call to check for call compatibility.

1741:
1742: --Standard Savepoint
1743: SAVEPOINT delete_acct_emailproc_by_acct;
1744:
1745: -- Standard call to check for call compatibility.
1746: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1747: p_api_version_number,
1748: l_api_name,
1749: G_PKG_NAME)

Line 1770: --Standard check of p_commit

1766: FROM IEM_ACCOUNT_EMAILPROCS
1767: WHERE email_account_id = p_email_account_id;
1768:
1769:
1770: --Standard check of p_commit
1771: IF FND_API.to_Boolean(p_commit) THEN
1772: COMMIT WORK;
1773: END IF;
1774: