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_EMAILPROC_HDL_PVT dependencies on STANDARD

Line 62: -- Standard Start of API savepoint

58: l_seq_id number;
59:
60: BEGIN
61:
62: -- Standard Start of API savepoint
63: SAVEPOINT create_item_acct_routes_PVT;
64:
65: -- Standard call to check for call compatibility.
66: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

61:
62: -- Standard Start of API savepoint
63: SAVEPOINT create_item_acct_routes_PVT;
64:
65: -- Standard call to check for call compatibility.
66: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
67: p_api_version_number,
68:
69: l_api_name,

Line 149: -- Standard Check Of p_commit.

145: sysdate,
146: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
147: );
148:
149: -- Standard Check Of p_commit.
150:
151:
152: IF FND_API.To_Boolean(p_commit) THEN
153: COMMIT WORK;

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

152: IF FND_API.To_Boolean(p_commit) THEN
153: COMMIT WORK;
154: END IF;
155:
156: -- Standard callto get message count and if count is 1, get message info.
157: FND_MSG_PUB.Count_And_Get
158: ( p_count => x_msg_count,
159: p_data => x_msg_data
160: );

Line 231: -- Standard Start of API savepoint

227: l_IEM_INVALID_PROCEDURE EXCEPTION;
228: IEM_ADM_G_MISS_FOR_NOTNULL EXCEPTION;
229: BEGIN
230:
231: -- Standard Start of API savepoint
232: SAVEPOINT update_item_route;
233:
234: -- Standard call to check for call compatibility.
235: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

230:
231: -- Standard Start of API savepoint
232: SAVEPOINT update_item_route;
233:
234: -- Standard call to check for call compatibility.
235: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
236: p_api_version_number,
237: l_api_name,
238: G_PKG_NAME)

Line 316: -- Standard Check Of p_commit.

312: LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,FND_API.G_MISS_CHAR,-1,G_LAST_UPDATE_LOGIN)
313:
314: where emailproc_id=p_emailproc_id;
315:
316: -- Standard Check Of p_commit.
317: IF FND_API.To_Boolean(p_commit) THEN
318: COMMIT WORK;
319: END IF;
320:

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

317: IF FND_API.To_Boolean(p_commit) THEN
318: COMMIT WORK;
319: END IF;
320:
321: -- Standard callto get message count and if count is 1, get message info.
322: FND_MSG_PUB.Count_And_Get
323: ( p_count => x_msg_count,
324: p_data => x_msg_data
325: );

Line 416: -- Standard Start of API savepoint

412: IEM_NO_RULE_UPDATE EXCEPTION;
413: IEM_ADM_G_MISS_FOR_NOTNULL EXCEPTION;
414: --IEM_INVALID_DATE_FORMAT EXCEPTION;
415: BEGIN
416: -- Standard Start of API savepoint
417:
418: SAVEPOINT update_item_rule;
419: -- Standard call to check for call compatibility.
420: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

415: BEGIN
416: -- Standard Start of API savepoint
417:
418: SAVEPOINT update_item_rule;
419: -- Standard call to check for call compatibility.
420: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
421: p_api_version_number,
422: l_api_name,
423: G_PKG_NAME)

Line 480: -- Standard Check Of p_commit.

476: LAST_UPDATE_DATE = sysdate,
477: LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
478: where emailproc_rule_id=p_emailproc_rule_id;
479:
480: -- Standard Check Of p_commit.
481: IF FND_API.To_Boolean(p_commit) THEN
482: COMMIT WORK;
483: END IF;
484:

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

481: IF FND_API.To_Boolean(p_commit) THEN
482: COMMIT WORK;
483: END IF;
484:
485: -- Standard callto get message count and if count is 1, get message info.
486: FND_MSG_PUB.Count_And_Get
487: ( p_count => x_msg_count,
488: p_data => x_msg_data
489: );

Line 577: -- Standard Start of API savepoint

573: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
574: l_enabled_flag VARCHAR2(1);
575:
576: BEGIN
577: -- Standard Start of API savepoint
578: SAVEPOINT update_account_emailprocs_PVT;
579: -- Standard call to check for call compatibility.
580: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
581: p_api_version_number,

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

575:
576: BEGIN
577: -- Standard Start of API savepoint
578: SAVEPOINT update_account_emailprocs_PVT;
579: -- Standard call to check for call compatibility.
580: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
581: p_api_version_number,
582: l_api_name,
583: G_PKG_NAME)

Line 648: -- Standard Check Of p_commit.

644: APP_EXCEPTION.RAISE_EXCEPTION;
645: end if;
646:
647:
648: -- Standard Check Of p_commit.
649: IF FND_API.To_Boolean(p_commit) THEN
650: COMMIT WORK;
651:
652: END IF;

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

649: IF FND_API.To_Boolean(p_commit) THEN
650: COMMIT WORK;
651:
652: END IF;
653: -- Standard callto get message count and if count is 1, get message info.
654: FND_MSG_PUB.Count_And_Get
655: ( p_count => x_msg_count,
656: p_data => x_msg_data
657:

Line 734: -- Standard Start of API savepoint

730: IEM_ADM_DUP_NAME EXCEPTION;
731: l_IEM_INVALID_PROCEDURE EXCEPTION;
732:
733: BEGIN
734: -- Standard Start of API savepoint
735: SAVEPOINT create_item_routes_PVT;
736:
737: -- Standard call to check for call compatibility.
738:

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

733: BEGIN
734: -- Standard Start of API savepoint
735: SAVEPOINT create_item_routes_PVT;
736:
737: -- Standard call to check for call compatibility.
738:
739: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
740: p_api_version_number,
741: l_api_name,

Line 868: -- Standard Check Of p_commit.

864: );
865:
866: x_emailproc_id := l_seq_id;
867:
868: -- Standard Check Of p_commit.
869: IF FND_API.To_Boolean(p_commit) THEN
870: COMMIT WORK;
871: END IF;
872:

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

869: IF FND_API.To_Boolean(p_commit) THEN
870: COMMIT WORK;
871: END IF;
872:
873: -- Standard callto get message count and if count is 1, get message info.
874: FND_MSG_PUB.Count_And_Get
875: ( p_count => x_msg_count,
876: p_data => x_msg_data
877: );

Line 955: -- Standard Start of API savepoint

951:
952: --IEM_INVALID_DATE_FORMAT EXCEPTION;
953:
954: BEGIN
955: -- Standard Start of API savepoint
956:
957: SAVEPOINT create_emailproc_rules_PVT;
958: -- Standard call to check for call compatibility.
959: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

954: BEGIN
955: -- Standard Start of API savepoint
956:
957: SAVEPOINT create_emailproc_rules_PVT;
958: -- Standard call to check for call compatibility.
959: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
960: p_api_version_number,
961: l_api_name,
962: G_PKG_NAME)

Line 1060: -- Standard Check Of p_commit.

1056: sysdate,
1057: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
1058: );
1059:
1060: -- Standard Check Of p_commit.
1061: IF FND_API.To_Boolean(p_commit) THEN
1062:
1063: COMMIT WORK;
1064:

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

1063: COMMIT WORK;
1064:
1065: END IF;
1066:
1067: -- Standard callto get message count and if count is 1, get message info.
1068: FND_MSG_PUB.Count_And_Get
1069: ( p_count => x_msg_count,
1070: p_data => x_msg_data
1071: );

Line 1124: -- Standard Start of API savepoint

1120: l_seq_id number;
1121:
1122: BEGIN
1123:
1124: -- Standard Start of API savepoint
1125: SAVEPOINT create_item_actions_PVT;
1126:
1127: -- Standard call to check for call compatibility.
1128: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

1123:
1124: -- Standard Start of API savepoint
1125: SAVEPOINT create_item_actions_PVT;
1126:
1127: -- Standard call to check for call compatibility.
1128: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1129: p_api_version_number,
1130:
1131: l_api_name,

Line 1209: -- Standard Check Of p_commit.

1205: );
1206:
1207: x_action_id := l_seq_id;
1208:
1209: -- Standard Check Of p_commit.
1210: IF FND_API.To_Boolean(p_commit) THEN
1211: COMMIT WORK;
1212: END IF;
1213:

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

1210: IF FND_API.To_Boolean(p_commit) THEN
1211: COMMIT WORK;
1212: END IF;
1213:
1214: -- Standard callto get message count and if count is 1, get message info.
1215: FND_MSG_PUB.Count_And_Get
1216: ( p_count => x_msg_count,
1217: p_data => x_msg_data
1218: );

Line 1279: -- Standard Start of API savepoint

1275: l_seq_id number;
1276:
1277: BEGIN
1278:
1279: -- Standard Start of API savepoint
1280: SAVEPOINT create_item_action_dtls_pvt;
1281:
1282: -- Standard call to check for call compatibility.
1283: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

1278:
1279: -- Standard Start of API savepoint
1280: SAVEPOINT create_item_action_dtls_pvt;
1281:
1282: -- Standard call to check for call compatibility.
1283: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1284: p_api_version_number,
1285:
1286: l_api_name,

Line 1366: -- Standard Check Of p_commit.

1362: sysdate,
1363: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
1364: );
1365:
1366: -- Standard Check Of p_commit.
1367:
1368:
1369: IF FND_API.To_Boolean(p_commit) THEN
1370: COMMIT WORK;

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

1369: IF FND_API.To_Boolean(p_commit) THEN
1370: COMMIT WORK;
1371: END IF;
1372:
1373: -- Standard callto get message count and if count is 1, get message info.
1374: FND_MSG_PUB.Count_And_Get
1375: ( p_count => x_msg_count,
1376: p_data => x_msg_data
1377: );

Line 1439: --Standard Savepoint

1435:
1436:
1437: BEGIN
1438:
1439: --Standard Savepoint
1440:
1441: SAVEPOINT delete_acct_emailproc_batch;
1442:
1443: -- Standard call to check for call compatibility.

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

1439: --Standard Savepoint
1440:
1441: SAVEPOINT delete_acct_emailproc_batch;
1442:
1443: -- Standard call to check for call compatibility.
1444: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1445: p_api_version_number,
1446: l_api_name,
1447: G_PKG_NAME)

Line 1491: --Standard check of p_commit

1487: --if SQL%NOTFOUND then
1488: -- raise IEM_ACCOUNT_ROUTE_NOT_DELETED;
1489: --end if;
1490:
1491: --Standard check of p_commit
1492: IF FND_API.to_Boolean(p_commit) THEN
1493: COMMIT WORK;
1494: END IF;
1495: