DBA Data[Home] [Help]

APPS.IEM_THEMES_PVT dependencies on STANDARD

Line 131: -- Standard Start of API savepoint

127: l_api_version_number NUMBER:=1.0;
128: l_grp_cnt NUMBER;
129:
130: BEGIN
131: -- Standard Start of API savepoint
132: SAVEPOINT delete_item_PVT;
133: -- Standard call to check for call compatibility.
134: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
135: p_api_version_number,

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

129:
130: BEGIN
131: -- Standard Start of API savepoint
132: SAVEPOINT delete_item_PVT;
133: -- Standard call to check for call compatibility.
134: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
135: p_api_version_number,
136: l_api_name,
137: G_PKG_NAME)

Line 151: -- Standard Check Of p_commit.

147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: DELETE FROM IEM_THEMES WHERE THEME_ID = p_theme_id;
150:
151: -- Standard Check Of p_commit.
152: IF FND_API.To_Boolean(p_commit) THEN
153: COMMIT WORK;
154: END IF;
155: -- Standard callto get message count and if count is 1, get message info.

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

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

Line 237: -- Standard Start of API savepoint

233: IEM_DUPLICATE_THEME EXCEPTION;
234: PRAGMA EXCEPTION_INIT(IEM_DUPLICATE_THEME, -00001);
235:
236: BEGIN
237: -- Standard Start of API savepoint
238: SAVEPOINT update_item_PVT;
239: -- Standard call to check for call compatibility.
240: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
241: p_api_version_number,

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

235:
236: BEGIN
237: -- Standard Start of API savepoint
238: SAVEPOINT update_item_PVT;
239: -- Standard call to check for call compatibility.
240: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
241: p_api_version_number,
242: l_api_name,
243: G_PKG_NAME)

Line 279: -- Standard Check Of p_commit.

275: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
276: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
277: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
278: where theme_id = p_theme_id;
279: -- Standard Check Of p_commit.
280: IF FND_API.To_Boolean(p_commit) THEN
281: COMMIT WORK;
282: END IF;
283: -- Standard callto get message count and if count is 1, get message info.

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

279: -- Standard Check Of p_commit.
280: IF FND_API.To_Boolean(p_commit) THEN
281: COMMIT WORK;
282: END IF;
283: -- Standard callto get message count and if count is 1, get message info.
284: FND_MSG_PUB.Count_And_Get
285: ( p_count => x_msg_count,
286: p_data => x_msg_data
287: );

Line 611: --Standard Savepoint

607: l_api_name varchar2(30):='delete_item_batch';
608: l_api_version_number number:=1.0;
609: BEGIN
610:
611: --Standard Savepoint
612: SAVEPOINT delete_item_wrap;
613: -- Standard call to check for call compatibility.
614: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
615: p_api_version_number,

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

609: BEGIN
610:
611: --Standard Savepoint
612: SAVEPOINT delete_item_wrap;
613: -- Standard call to check for call compatibility.
614: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
615: p_api_version_number,
616: l_api_name,
617: G_PKG_NAME)

Line 642: --Standard check of p_commit

638: FND_MSG_PUB.ADD;
639: RAISE FND_API.G_EXC_ERROR;
640: END IF;
641:
642: --Standard check of p_commit
643: IF FND_API.to_Boolean(p_commit) THEN
644: COMMIT WORK;
645: END IF;
646:

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

643: IF FND_API.to_Boolean(p_commit) THEN
644: COMMIT WORK;
645: END IF;
646:
647: -- Standard callto get message count and if count is 1, get message info.
648: FND_MSG_PUB.Count_And_Get
649: ( p_count => x_msg_count,
650: p_data => x_msg_data
651: );

Line 682: --Standard call to get message count and message info

678: FND_MSG_PUB.Count_And_Get
679: ( p_count => x_msg_count ,
680: p_data => x_msg_data
681: );
682: --Standard call to get message count and message info
683: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
684: p_data => x_msg_data);
685: END delete_item_wrap;
686: PROCEDURE delete_item_wrap_sss

Line 703: --Standard Savepoint

699: l_class_id number;
700: l_email_account_id number;
701: BEGIN
702:
703: --Standard Savepoint
704: SAVEPOINT delete_item_wrap;
705: -- Standard call to check for call compatibility.
706: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
707: p_api_version_number,

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

701: BEGIN
702:
703: --Standard Savepoint
704: SAVEPOINT delete_item_wrap;
705: -- Standard call to check for call compatibility.
706: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
707: p_api_version_number,
708: l_api_name,
709: G_PKG_NAME)

Line 754: --Standard check of p_commit

750: FND_MSG_PUB.ADD;
751: RAISE FND_API.G_EXC_ERROR;
752: END IF;
753:
754: --Standard check of p_commit
755: IF FND_API.to_Boolean(p_commit) THEN
756: COMMIT WORK;
757: END IF;
758:

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

755: IF FND_API.to_Boolean(p_commit) THEN
756: COMMIT WORK;
757: END IF;
758:
759: -- Standard callto get message count and if count is 1, get message info.
760: FND_MSG_PUB.Count_And_Get
761: ( p_count => x_msg_count,
762: p_data => x_msg_data
763: );

Line 794: --Standard call to get message count and message info

790: FND_MSG_PUB.Count_And_Get
791: ( p_count => x_msg_count ,
792: p_data => x_msg_data
793: );
794: --Standard call to get message count and message info
795: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
796: p_data => x_msg_data);
797: END delete_item_wrap_sss;
798:

Line 823: -- Standard Start of API savepoint

819: l_theme2 VARCHAR2(100);
820: IEM_DUPLICATE_THEME EXCEPTION;
821:
822: BEGIN
823: -- Standard Start of API savepoint
824: SAVEPOINT update_item_PVT;
825: -- Standard call to check for call compatibility.
826: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
827: p_api_version_number,

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

821:
822: BEGIN
823: -- Standard Start of API savepoint
824: SAVEPOINT update_item_PVT;
825: -- Standard call to check for call compatibility.
826: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
827: p_api_version_number,
828: l_api_name,
829: G_PKG_NAME)

Line 884: -- Standard Check Of p_commit.

880: x_msg_count => x_msg_count,
881: x_msg_data => x_msg_data);
882:
883:
884: -- Standard Check Of p_commit.
885: IF FND_API.To_Boolean(p_commit) THEN
886: COMMIT WORK;
887: END IF;
888: -- Standard callto get message count and if count is 1, get message info.

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

884: -- Standard Check Of p_commit.
885: IF FND_API.To_Boolean(p_commit) THEN
886: COMMIT WORK;
887: END IF;
888: -- Standard callto get message count and if count is 1, get message info.
889: FND_MSG_PUB.Count_And_Get
890: ( p_count => x_msg_count,
891: p_data => x_msg_data
892: );