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 677: -- Standard Start of API savepoint

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

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

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

Line 1061: -- Standard Start of API savepoint

1057: IEM_ADM_AUTOPRC_NO_PARAMETERS EXCEPTION;
1058: IEM_ADM_INVALID_PROC_NAME EXCEPTION;
1059: BEGIN
1060:
1061: -- Standard Start of API savepoint
1062: SAVEPOINT create_item_wrap;
1063:
1064: -- Standard call to check for call compatibility.
1065: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

1060:
1061: -- Standard Start of API savepoint
1062: SAVEPOINT create_item_wrap;
1063:
1064: -- Standard call to check for call compatibility.
1065: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1066: p_api_version_number,
1067: l_api_name,
1068: G_PKG_NAME)

Line 1324: -- Standard Start of API savepoint

1320: IEM_ADMIN_ACCOUNT_NOT_EXIST EXCEPTION;
1321: IEM_ACCOUNT_ROUTE_NOT_UPDATED EXCEPTION;
1322: IEM_NOT_REDIRECT_SAME_ACCT EXCEPTION;
1323: BEGIN
1324: -- Standard Start of API savepoint
1325: SAVEPOINT create_wrap_account_routes_PVT;
1326:
1327: -- Standard call to check for call compatibility.
1328: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

1323: BEGIN
1324: -- Standard Start of API savepoint
1325: SAVEPOINT create_wrap_account_routes_PVT;
1326:
1327: -- Standard call to check for call compatibility.
1328: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1329:
1330: p_api_version_number,
1331: l_api_name,

Line 1394: -- Standard Check Of p_commit.

1390: raise IEM_ACCOUNT_ROUTE_NOT_UPDATED;
1391:
1392: end if;
1393:
1394: -- Standard Check Of p_commit.
1395: IF FND_API.To_Boolean(p_commit) THEN
1396: COMMIT WORK;
1397: END IF;
1398: -- Standard callto get message count and if count is 1, get message info.

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

1394: -- Standard Check Of p_commit.
1395: IF FND_API.To_Boolean(p_commit) THEN
1396: COMMIT WORK;
1397: END IF;
1398: -- Standard callto get message count and if count is 1, get message info.
1399: FND_MSG_PUB.Count_And_Get
1400: ( p_count => x_msg_count,
1401: p_data => x_msg_data
1402: );

Line 1501: -- Standard Start of API savepoint

1497: l_msg_data VARCHAR2(2000);
1498: IEM_ACCT_EMAILPROC_NOT_DELETED EXCEPTION;
1499: IEM_ACCT_EMAILPROC_NOT_UPDATED EXCEPTION;
1500: BEGIN
1501: -- Standard Start of API savepoint
1502: SAVEPOINT update_wrap_acct_emailproc_PVT;
1503:
1504: -- Standard call to check for call compatibility.
1505: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

1500: BEGIN
1501: -- Standard Start of API savepoint
1502: SAVEPOINT update_wrap_acct_emailproc_PVT;
1503:
1504: -- Standard call to check for call compatibility.
1505: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1506: p_api_version_number,
1507: l_api_name,
1508: G_PKG_NAME)

Line 1563: -- Standard Check Of p_commit.

1559:
1560: end if;
1561:
1562:
1563: -- Standard Check Of p_commit.
1564: IF FND_API.To_Boolean(p_commit) THEN
1565: COMMIT WORK;
1566: END IF;
1567:

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

1564: IF FND_API.To_Boolean(p_commit) THEN
1565: COMMIT WORK;
1566: END IF;
1567:
1568: -- Standard callto get message count and if count is 1, get message info.
1569: FND_MSG_PUB.Count_And_Get
1570:
1571: ( p_count => x_msg_count,
1572: p_data => x_msg_data

Line 1652: --Standard Savepoint

1648: BEGIN
1649:
1650:
1651:
1652: --Standard Savepoint
1653: SAVEPOINT delete_item_batch;
1654:
1655: -- Standard call to check for call compatibility.
1656: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

1651:
1652: --Standard Savepoint
1653: SAVEPOINT delete_item_batch;
1654:
1655: -- Standard call to check for call compatibility.
1656: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1657: p_api_version_number,
1658: l_api_name,
1659: G_PKG_NAME)

Line 1719: --Standard check of p_commit

1715: --remove iem_email_actions
1716: delete from iem_actions where emailproc_id = p_emailproc_id;
1717:
1718:
1719: --Standard check of p_commit
1720: IF FND_API.to_Boolean(p_commit) THEN
1721: COMMIT WORK;
1722: END IF;
1723:

Line 1775: --Standard Savepoint

1771: l_api_version_number number:=1.0;
1772:
1773: BEGIN
1774:
1775: --Standard Savepoint
1776: SAVEPOINT delete_acct_emailproc_by_acct;
1777:
1778: -- Standard call to check for call compatibility.
1779: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

1774:
1775: --Standard Savepoint
1776: SAVEPOINT delete_acct_emailproc_by_acct;
1777:
1778: -- Standard call to check for call compatibility.
1779: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1780: p_api_version_number,
1781: l_api_name,
1782: G_PKG_NAME)

Line 1803: --Standard check of p_commit

1799: FROM IEM_ACCOUNT_EMAILPROCS
1800: WHERE email_account_id = p_email_account_id;
1801:
1802:
1803: --Standard check of p_commit
1804: IF FND_API.to_Boolean(p_commit) THEN
1805: COMMIT WORK;
1806: END IF;
1807: