eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_ROUTE_PVT dependencies on STANDARD

Line 16: -- Liang Xia 12/2/2002 Fixed PLSQL standard: "No MISS.." "NOCOPY" GSCC warning.

12: -- create_item_routes and update_item_route
13: -- added updating priority in IEM_ACCOUNT_ROUTES for delete_item_batch
14: -- Liang Xia 6/7/2002 added validation for dynamic Route
15: -- Liang Xia 11/6/2002 release the validation for ALL_EMAILS and fixed part of "No MISS.." GSCC warning.
16: -- Liang Xia 12/2/2002 Fixed PLSQL standard: "No MISS.." "NOCOPY" GSCC warning.
17: -- Liang Xia 12/06/2004 Changed for 115.11 schema: iem_mstemail_account
18: -- --------- ------ ------------------------------------------
19:
20: -- Enter procedure, function bodies as shown below

Line 43: --Standard Savepoint

39:
40: IEM_ROUTE_NOT_DELETED EXCEPTION;
41: BEGIN
42:
43: --Standard Savepoint
44: SAVEPOINT delete_acct_route_by_acct;
45:
46: -- Standard call to check for call compatibility.
47: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

42:
43: --Standard Savepoint
44: SAVEPOINT delete_acct_route_by_acct;
45:
46: -- Standard call to check for call compatibility.
47: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
48: p_api_version_number,
49: l_api_name,
50: G_PKG_NAME)

Line 71: --Standard check of p_commit

67: FROM IEM_ACCOUNT_ROUTES
68: WHERE email_account_id = p_email_account_id;
69:
70:
71: --Standard check of p_commit
72: IF FND_API.to_Boolean(p_commit) THEN
73: COMMIT WORK;
74: END IF;
75:

Line 126: --Standard Savepoint

122: BEGIN
123:
124:
125:
126: --Standard Savepoint
127: SAVEPOINT delete_item_batch;
128:
129: -- Standard call to check for call compatibility.
130: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

125:
126: --Standard Savepoint
127: SAVEPOINT delete_item_batch;
128:
129: -- Standard call to check for call compatibility.
130: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
131: p_api_version_number,
132: l_api_name,
133: G_PKG_NAME)

Line 187: --Standard check of p_commit

183: END LOOP;
184:
185: end if;
186:
187: --Standard check of p_commit
188: IF FND_API.to_Boolean(p_commit) THEN
189: COMMIT WORK;
190: END IF;
191:

Line 268: -- Standard Start of API savepoint

264: IEM_ROUTE_RULE_NOT_CREATED EXCEPTION;
265:
266: BEGIN
267:
268: -- Standard Start of API savepoint
269: SAVEPOINT create_item_wrap;
270:
271: -- Standard call to check for call compatibility.
272: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

267:
268: -- Standard Start of API savepoint
269: SAVEPOINT create_item_wrap;
270:
271: -- Standard call to check for call compatibility.
272: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
273: p_api_version_number,
274: l_api_name,
275: G_PKG_NAME)

Line 356: -- Standard Check Of p_commit.

352: raise IEM_ROUTE_RULE_NOT_CREATED;
353: end if;
354: end loop;
355: end if;
356: -- Standard Check Of p_commit.
357: IF FND_API.To_Boolean(p_commit) THEN
358: COMMIT WORK;
359: END IF;
360:

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

357: IF FND_API.To_Boolean(p_commit) THEN
358: COMMIT WORK;
359: END IF;
360:
361: -- Standard callto get message count and if count is 1, get message info.
362: FND_MSG_PUB.Count_And_Get
363: ( p_count => x_msg_count,
364: p_data => x_msg_data
365: );

Line 437: -- Standard Start of API savepoint

433: l_IEM_INVALID_PROCEDURE EXCEPTION;
434: IEM_ADM_NO_PROCEDURE_NAME EXCEPTION;
435:
436: BEGIN
437: -- Standard Start of API savepoint
438: SAVEPOINT create_item_routes_PVT;
439:
440: -- Standard call to check for call compatibility.
441:

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

436: BEGIN
437: -- Standard Start of API savepoint
438: SAVEPOINT create_item_routes_PVT;
439:
440: -- Standard call to check for call compatibility.
441:
442: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
443: p_api_version_number,
444: l_api_name,

Line 581: -- Standard Check Of p_commit.

577:
578:
579: );
580:
581: -- Standard Check Of p_commit.
582: IF FND_API.To_Boolean(p_commit) THEN
583: COMMIT WORK;
584: END IF;
585:

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

582: IF FND_API.To_Boolean(p_commit) THEN
583: COMMIT WORK;
584: END IF;
585:
586: -- Standard callto get message count and if count is 1, get message info.
587: FND_MSG_PUB.Count_And_Get
588: ( p_count => x_msg_count,
589: p_data => x_msg_data
590: );

Line 691: -- Standard Start of API savepoint

687:
688: --IEM_INVALID_DATE_FORMAT EXCEPTION;
689:
690: BEGIN
691: -- Standard Start of API savepoint
692:
693: SAVEPOINT create_item_route_rules_PVT;
694: -- Standard call to check for call compatibility.
695: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

690: BEGIN
691: -- Standard Start of API savepoint
692:
693: SAVEPOINT create_item_route_rules_PVT;
694: -- Standard call to check for call compatibility.
695: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
696: p_api_version_number,
697: l_api_name,
698: G_PKG_NAME)

Line 807: -- Standard Check Of p_commit.

803: sysdate,
804: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
805: );
806:
807: -- Standard Check Of p_commit.
808: IF FND_API.To_Boolean(p_commit) THEN
809:
810: COMMIT WORK;
811:

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

810: COMMIT WORK;
811:
812: END IF;
813:
814: -- Standard callto get message count and if count is 1, get message info.
815: FND_MSG_PUB.Count_And_Get
816: ( p_count => x_msg_count,
817: p_data => x_msg_data
818: );

Line 885: -- Standard Start of API savepoint

881: l_seq_id number;
882:
883: BEGIN
884:
885: -- Standard Start of API savepoint
886: SAVEPOINT create_item_acct_routes_PVT;
887:
888: -- Standard call to check for call compatibility.
889: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

884:
885: -- Standard Start of API savepoint
886: SAVEPOINT create_item_acct_routes_PVT;
887:
888: -- Standard call to check for call compatibility.
889: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
890: p_api_version_number,
891:
892: l_api_name,

Line 986: -- Standard Check Of p_commit.

982: sysdate,
983: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
984: );
985:
986: -- Standard Check Of p_commit.
987:
988:
989: IF FND_API.To_Boolean(p_commit) THEN
990: COMMIT WORK;

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

989: IF FND_API.To_Boolean(p_commit) THEN
990: COMMIT WORK;
991: END IF;
992:
993: -- Standard callto get message count and if count is 1, get message info.
994: FND_MSG_PUB.Count_And_Get
995: ( p_count => x_msg_count,
996: p_data => x_msg_data
997: );

Line 1086: -- Standard Start of API savepoint

1082: l_proc_name VARCHAR2(256);
1083: l_return_type VARCHAR2(30);
1084: l_description VARCHAR2(256);
1085: BEGIN
1086: -- Standard Start of API savepoint
1087: SAVEPOINT update_item_wrap;
1088:
1089: -- Standard call to check for call compatibility.
1090: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

1085: BEGIN
1086: -- Standard Start of API savepoint
1087: SAVEPOINT update_item_wrap;
1088:
1089: -- Standard call to check for call compatibility.
1090: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1091:
1092: p_api_version_number,
1093: l_api_name,

Line 1326: -- Standard Start of API savepoint

1322: IEM_ADMIN_ROUTE_NO_PROC EXCEPTION;
1323: l_IEM_INVALID_PROCEDURE EXCEPTION;
1324: BEGIN
1325:
1326: -- Standard Start of API savepoint
1327: SAVEPOINT update_item_route;
1328:
1329: -- Standard call to check for call compatibility.
1330: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

1325:
1326: -- Standard Start of API savepoint
1327: SAVEPOINT update_item_route;
1328:
1329: -- Standard call to check for call compatibility.
1330: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1331: p_api_version_number,
1332: l_api_name,
1333: G_PKG_NAME)

Line 1399: -- Standard Check Of p_commit.

1395: LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
1396:
1397: where route_id=p_route_id;
1398:
1399: -- Standard Check Of p_commit.
1400: IF FND_API.To_Boolean(p_commit) THEN
1401: COMMIT WORK;
1402: END IF;
1403:

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

1400: IF FND_API.To_Boolean(p_commit) THEN
1401: COMMIT WORK;
1402: END IF;
1403:
1404: -- Standard callto get message count and if count is 1, get message info.
1405: FND_MSG_PUB.Count_And_Get
1406: ( p_count => x_msg_count,
1407: p_data => x_msg_data
1408: );

Line 1492: -- Standard Start of API savepoint

1488:
1489: IEM_NO_RULE_UPDATE EXCEPTION;
1490: --IEM_INVALID_DATE_FORMAT EXCEPTION;
1491: BEGIN
1492: -- Standard Start of API savepoint
1493:
1494: SAVEPOINT update_item_rule;
1495: -- Standard call to check for call compatibility.
1496: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

1491: BEGIN
1492: -- Standard Start of API savepoint
1493:
1494: SAVEPOINT update_item_rule;
1495: -- Standard call to check for call compatibility.
1496: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1497: p_api_version_number,
1498: l_api_name,
1499: G_PKG_NAME)

Line 1553: -- Standard Check Of p_commit.

1549: where route_rule_id=p_route_rule_id;
1550:
1551:
1552:
1553: -- Standard Check Of p_commit.
1554: IF FND_API.To_Boolean(p_commit) THEN
1555: COMMIT WORK;
1556: END IF;
1557:

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

1554: IF FND_API.To_Boolean(p_commit) THEN
1555: COMMIT WORK;
1556: END IF;
1557:
1558: -- Standard callto get message count and if count is 1, get message info.
1559: FND_MSG_PUB.Count_And_Get
1560: ( p_count => x_msg_count,
1561: p_data => x_msg_data
1562: );

Line 1650: -- Standard Start of API savepoint

1646: IEM_ADMIN_ROUTE_NOT_EXIST EXCEPTION;
1647: IEM_ADMIN_ACCOUNT_NOT_EXIST EXCEPTION;
1648: IEM_ACCOUNT_ROUTE_NOT_UPDATED EXCEPTION;
1649: BEGIN
1650: -- Standard Start of API savepoint
1651: SAVEPOINT create_wrap_account_routes_PVT;
1652:
1653: -- Standard call to check for call compatibility.
1654: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

1649: BEGIN
1650: -- Standard Start of API savepoint
1651: SAVEPOINT create_wrap_account_routes_PVT;
1652:
1653: -- Standard call to check for call compatibility.
1654: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1655:
1656: p_api_version_number,
1657: l_api_name,

Line 1720: -- Standard Check Of p_commit.

1716: end if;
1717:
1718:
1719: --dbms_output.put_line('after insert : ');
1720: -- Standard Check Of p_commit.
1721: IF FND_API.To_Boolean(p_commit) THEN
1722:
1723: COMMIT WORK;
1724: END IF;

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

1721: IF FND_API.To_Boolean(p_commit) THEN
1722:
1723: COMMIT WORK;
1724: END IF;
1725: -- Standard callto get message count and if count is 1, get message info.
1726: FND_MSG_PUB.Count_And_Get
1727: ( p_count => x_msg_count,
1728: p_data => x_msg_data
1729: );

Line 1821: -- Standard Start of API savepoint

1817:
1818: IEM_ADM_G_MISS_FOR_NOTNULL EXCEPTION;
1819:
1820: BEGIN
1821: -- Standard Start of API savepoint
1822: SAVEPOINT update_account_routes_PVT;
1823: -- Standard call to check for call compatibility.
1824: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1825: p_api_version_number,

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

1819:
1820: BEGIN
1821: -- Standard Start of API savepoint
1822: SAVEPOINT update_account_routes_PVT;
1823: -- Standard call to check for call compatibility.
1824: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1825: p_api_version_number,
1826: l_api_name,
1827: G_PKG_NAME)

Line 1894: -- Standard Check Of p_commit.

1890: end if;
1891:
1892:
1893:
1894: -- Standard Check Of p_commit.
1895: IF FND_API.To_Boolean(p_commit) THEN
1896: COMMIT WORK;
1897:
1898: END IF;

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

1895: IF FND_API.To_Boolean(p_commit) THEN
1896: COMMIT WORK;
1897:
1898: END IF;
1899: -- Standard callto get message count and if count is 1, get message info.
1900: FND_MSG_PUB.Count_And_Get
1901: ( p_count => x_msg_count,
1902: p_data => x_msg_data
1903:

Line 1969: --Standard Savepoint

1965: IEM_ACCOUNT_ROUTE_NOT_DELETED EXCEPTION;
1966:
1967: BEGIN
1968:
1969: --Standard Savepoint
1970:
1971: SAVEPOINT delete_acct_route_batch;
1972:
1973: -- Standard call to check for call compatibility.

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

1969: --Standard Savepoint
1970:
1971: SAVEPOINT delete_acct_route_batch;
1972:
1973: -- Standard call to check for call compatibility.
1974: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1975: p_api_version_number,
1976: l_api_name,
1977: G_PKG_NAME)

Line 2017: --Standard check of p_commit

2013: --if SQL%NOTFOUND then
2014: -- raise IEM_ACCOUNT_ROUTE_NOT_DELETED;
2015: --end if;
2016:
2017: --Standard check of p_commit
2018: IF FND_API.to_Boolean(p_commit) THEN
2019: COMMIT WORK;
2020: END IF;
2021:

Line 2092: -- Standard Start of API savepoint

2088:
2089: IEM_ACCOUNT_ROUTE_NOT_DELETED EXCEPTION;
2090: IEM_ACCOUNT_ROUTE_NOT_UPDATED EXCEPTION;
2091: BEGIN
2092: -- Standard Start of API savepoint
2093: SAVEPOINT update_wrap_acct_routes_1_PVT;
2094:
2095: -- Standard call to check for call compatibility.
2096: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

2091: BEGIN
2092: -- Standard Start of API savepoint
2093: SAVEPOINT update_wrap_acct_routes_1_PVT;
2094:
2095: -- Standard call to check for call compatibility.
2096: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2097: p_api_version_number,
2098: l_api_name,
2099: G_PKG_NAME)

Line 2171: -- Standard Check Of p_commit.

2167:
2168:
2169:
2170: --dbms_output.put_line('after insert : ');
2171: -- Standard Check Of p_commit.
2172: IF FND_API.To_Boolean(p_commit) THEN
2173: COMMIT WORK;
2174: END IF;
2175:

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

2172: IF FND_API.To_Boolean(p_commit) THEN
2173: COMMIT WORK;
2174: END IF;
2175:
2176: -- Standard callto get message count and if count is 1, get message info.
2177: FND_MSG_PUB.Count_And_Get
2178:
2179: ( p_count => x_msg_count,
2180: p_data => x_msg_data