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,
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)
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.
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: );
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,
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)
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.
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: );
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,
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)
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:
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: );
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
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,
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)
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:
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: );
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:
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,
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)
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.
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: );