39: l_seq_id number;
40: l_grp_cnt number;
41:
42: BEGIN
43: -- Standard Start of API savepoint
44: SAVEPOINT create_item_PVT;
45: -- Standard call to check for call compatibility.
46: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
47: p_api_version_number,
41:
42: BEGIN
43: -- Standard Start of API savepoint
44: SAVEPOINT create_item_PVT;
45: -- Standard call to check for call compatibility.
46: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
47: p_api_version_number,
48: l_api_name,
49: G_PKG_NAME)
128: p_ATTRIBUTE14,
129: p_ATTRIBUTE15
130: );
131:
132: -- Standard Check Of p_commit.
133: IF FND_API.To_Boolean(p_commit) THEN
134: COMMIT WORK;
135: END IF;
136: -- Standard callto get message count and if count is 1, get message info.
132: -- Standard Check Of p_commit.
133: IF FND_API.To_Boolean(p_commit) THEN
134: COMMIT WORK;
135: END IF;
136: -- Standard callto get message count and if count is 1, get message info.
137: FND_MSG_PUB.Count_And_Get
138: ( p_count => x_msg_count,
139: p_data => x_msg_data
140: );
191: l_api_name VARCHAR2(255):='delete_item';
192: l_api_version_number NUMBER:=1.0;
193:
194: BEGIN
195: -- Standard Start of API savepoint
196: SAVEPOINT delete_item_PVT;
197: -- Standard call to check for call compatibility.
198: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
199: p_api_version_number,
193:
194: BEGIN
195: -- Standard Start of API savepoint
196: SAVEPOINT delete_item_PVT;
197: -- Standard call to check for call compatibility.
198: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
199: p_api_version_number,
200: l_api_name,
201: G_PKG_NAME)
217: delete from IEM_EMC_SERVERS
218: where emc_server_id=p_emc_server_id;
219: end if;
220:
221: -- Standard Check Of p_commit.
222: IF FND_API.To_Boolean(p_commit) THEN
223: COMMIT WORK;
224: END IF;
225: -- Standard callto get message count and if count is 1, get message info.
221: -- Standard Check Of p_commit.
222: IF FND_API.To_Boolean(p_commit) THEN
223: COMMIT WORK;
224: END IF;
225: -- Standard callto get message count and if count is 1, get message info.
226: FND_MSG_PUB.Count_And_Get
227: ( p_count => x_msg_count,
228: p_data => x_msg_data
229: );
298: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
299: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
300:
301: BEGIN
302: -- Standard Start of API savepoint
303: SAVEPOINT update_item_PVT;
304: -- Standard call to check for call compatibility.
305: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
306: p_api_version_number,
300:
301: BEGIN
302: -- Standard Start of API savepoint
303: SAVEPOINT update_item_PVT;
304: -- Standard call to check for call compatibility.
305: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
306: p_api_version_number,
307: l_api_name,
308: G_PKG_NAME)
378: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
379: where emc_server_id=p_emc_server_id;
380: end if;
381:
382: -- Standard Check Of p_commit.
383: IF FND_API.To_Boolean(p_commit) THEN
384: COMMIT WORK;
385: END IF;
386: -- Standard callto get message count and if count is 1, get message info.
382: -- Standard Check Of p_commit.
383: IF FND_API.To_Boolean(p_commit) THEN
384: COMMIT WORK;
385: END IF;
386: -- Standard callto get message count and if count is 1, get message info.
387: FND_MSG_PUB.Count_And_Get
388: ( p_count => x_msg_count,
389: p_data => x_msg_data
390: );
444:
445: SERVER_GROUP_NOT_DELETED EXCEPTION;
446: BEGIN
447:
448: --Standard Savepoint
449: SAVEPOINT delete_item_batch;
450:
451: -- Standard call to check for call compatibility.
452: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
447:
448: --Standard Savepoint
449: SAVEPOINT delete_item_batch;
450:
451: -- Standard call to check for call compatibility.
452: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
453: p_api_version_number,
454: l_api_name,
455: G_PKG_NAME)
475: raise SERVER_GROUP_NOT_DELETED;
476: end if;
477:
478:
479: --Standard check of p_commit
480: IF FND_API.to_Boolean(p_commit) THEN
481: COMMIT WORK;
482: END IF;
483: