DBA Data[Home] [Help]

APPS.IEM_EMAIL_SERVERS_PVT dependencies on STANDARD

Line 53: -- Standard Start of API savepoint

49: IEM_DUP_EMAIL_SERVER EXCEPTION;
50: IEM_NON_EXISTENT_SERVER_GRP EXCEPTION;
51:
52: BEGIN
53: -- Standard Start of API savepoint
54: SAVEPOINT create_item_PVT;
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
57: p_api_version_number,

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

51:
52: BEGIN
53: -- Standard Start of API savepoint
54: SAVEPOINT create_item_PVT;
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
57: p_api_version_number,
58: l_api_name,
59: G_PKG_NAME)

Line 167: -- Standard Check Of p_commit.

163: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
164: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
165: );
166:
167: -- Standard Check Of p_commit.
168: IF FND_API.To_Boolean(p_commit) THEN
169: COMMIT WORK;
170: END IF;
171: -- Standard callto get message count and if count is 1, get message info.

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

167: -- Standard Check Of p_commit.
168: IF FND_API.To_Boolean(p_commit) THEN
169: COMMIT WORK;
170: END IF;
171: -- Standard callto get message count and if count is 1, get message info.
172: FND_MSG_PUB.Count_And_Get
173: ( p_count => x_msg_count,
174: p_data => x_msg_data
175: );

Line 264: -- Standard Start of API savepoint

260:
261: EXCP_EMAIL_SERVER EXCEPTION;
262:
263: BEGIN
264: -- Standard Start of API savepoint
265: SAVEPOINT create_item_PVT;
266: -- Standard call to check for call compatibility.
267: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
268: p_api_version_number,

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

262:
263: BEGIN
264: -- Standard Start of API savepoint
265: SAVEPOINT create_item_PVT;
266: -- Standard call to check for call compatibility.
267: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
268: p_api_version_number,
269: l_api_name,
270: G_PKG_NAME)

Line 348: -- Standard Check Of p_commit.

344: x_msg_data => l_data
345: );
346: -- Not raise error when failed to insert data into iem_comp_rt_stats, it is not user error.
347:
348: -- Standard Check Of p_commit.
349: IF FND_API.To_Boolean(p_commit) THEN
350: COMMIT WORK;
351: END IF;
352: -- Standard callto get message count and if count is 1, get message info.

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

348: -- Standard Check Of p_commit.
349: IF FND_API.To_Boolean(p_commit) THEN
350: COMMIT WORK;
351: END IF;
352: -- Standard callto get message count and if count is 1, get message info.
353: FND_MSG_PUB.Count_And_Get
354: ( p_count => x_msg_count,
355: p_data => x_msg_data
356: );

Line 413: -- Standard Start of API savepoint

409: l_api_name VARCHAR2(255):='delete_item';
410: l_api_version_number NUMBER:=1.0;
411:
412: BEGIN
413: -- Standard Start of API savepoint
414: SAVEPOINT delete_item_PVT;
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
417: p_api_version_number,

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

411:
412: BEGIN
413: -- Standard Start of API savepoint
414: SAVEPOINT delete_item_PVT;
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
417: p_api_version_number,
418: l_api_name,
419: G_PKG_NAME)

Line 438: -- Standard Check Of p_commit.

434: delete from iem_email_servers
435: where email_server_id=p_email_server_id;
436: end if;
437:
438: -- Standard Check Of p_commit.
439: IF FND_API.To_Boolean(p_commit) THEN
440: COMMIT WORK;
441: END IF;
442: -- Standard callto get message count and if count is 1, get message info.

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

438: -- Standard Check Of p_commit.
439: IF FND_API.To_Boolean(p_commit) THEN
440: COMMIT WORK;
441: END IF;
442: -- Standard callto get message count and if count is 1, get message info.
443: FND_MSG_PUB.Count_And_Get
444: ( p_count => x_msg_count,
445: p_data => x_msg_data
446: );

Line 525: -- Standard Start of API savepoint

521: IEM_DUP_EMAIL_SERVER EXCEPTION;
522: IEM_NON_EXISTENT_SERVER_GRP EXCEPTION;
523:
524: BEGIN
525: -- Standard Start of API savepoint
526: SAVEPOINT update_item_PVT;
527: -- Standard call to check for call compatibility.
528: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
529: p_api_version_number,

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

523:
524: BEGIN
525: -- Standard Start of API savepoint
526: SAVEPOINT update_item_PVT;
527: -- Standard call to check for call compatibility.
528: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
529: p_api_version_number,
530: l_api_name,
531: G_PKG_NAME)

Line 631: -- Standard Check Of p_commit.

627: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14),
628: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
629: where EMAIL_SERVER_ID=p_email_server_id;
630: end if;
631: -- Standard Check Of p_commit.
632: IF FND_API.To_Boolean(p_commit) THEN
633: COMMIT WORK;
634: END IF;
635: -- Standard callto get message count and if count is 1, get message info.

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

631: -- Standard Check Of p_commit.
632: IF FND_API.To_Boolean(p_commit) THEN
633: COMMIT WORK;
634: END IF;
635: -- Standard callto get message count and if count is 1, get message info.
636: FND_MSG_PUB.Count_And_Get
637: ( p_count => x_msg_count,
638: p_data => x_msg_data
639: );

Line 732: -- Standard Start of API savepoint

728:
729: EXCP_EMAIL_SERVER EXCEPTION;
730:
731: BEGIN
732: -- Standard Start of API savepoint
733: SAVEPOINT create_item_PVT;
734: -- Standard call to check for call compatibility.
735: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
736: p_api_version_number,

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

730:
731: BEGIN
732: -- Standard Start of API savepoint
733: SAVEPOINT create_item_PVT;
734: -- Standard call to check for call compatibility.
735: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
736: p_api_version_number,
737: l_api_name,
738: G_PKG_NAME)

Line 812: -- Standard Check Of p_commit.

808: x_msg_data => l_data
809: );
810: -- Not raise error when failed to insert data into iem_comp_rt_stats, it is not user error.
811:
812: -- Standard Check Of p_commit.
813: IF FND_API.To_Boolean(p_commit) THEN
814: COMMIT WORK;
815: END IF;
816: -- Standard callto get message count and if count is 1, get message info.

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

812: -- Standard Check Of p_commit.
813: IF FND_API.To_Boolean(p_commit) THEN
814: COMMIT WORK;
815: END IF;
816: -- Standard callto get message count and if count is 1, get message info.
817: FND_MSG_PUB.Count_And_Get
818: ( p_count => x_msg_count,
819: p_data => x_msg_data
820: );

Line 885: --Standard Savepoint

881: SERVER_GROUP_NOT_DELETED EXCEPTION;
882:
883: BEGIN
884:
885: --Standard Savepoint
886: SAVEPOINT delete_item_batch;
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 Savepoint
886: SAVEPOINT delete_item_batch;
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: l_api_name,
892: G_PKG_NAME)

Line 931: --Standard check of p_commit

927: WHERE EMAIL_SERVER_ID =l_email_server_id;
928:
929: END LOOP;
930:
931: --Standard check of p_commit
932: IF FND_API.to_Boolean(p_commit) THEN
933: COMMIT WORK;
934: END IF;
935: