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_EMC_SERVERS_PVT dependencies on FND_API

Line 46: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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)
50: THEN

Line 51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

47: p_api_version_number,
48: l_api_name,
49: G_PKG_NAME)
50: THEN
51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
52: END IF;
53: -- Initialize message list if p_init_msg_list is set to TRUE.
54: IF FND_API.to_Boolean( p_init_msg_list )
55: THEN

Line 54: IF FND_API.to_Boolean( p_init_msg_list )

50: THEN
51: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
52: END IF;
53: -- Initialize message list if p_init_msg_list is set to TRUE.
54: IF FND_API.to_Boolean( p_init_msg_list )
55: THEN
56: FND_MSG_PUB.initialize;
57: END IF;
58: -- Initialize API return status to SUCCESS

Line 59: x_return_status := FND_API.G_RET_STS_SUCCESS;

55: THEN
56: FND_MSG_PUB.initialize;
57: END IF;
58: -- Initialize API return status to SUCCESS
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60:
61: SELECT IEM_EMC_SERVERS_s1.nextval
62: INTO l_seq_id
63: FROM dual;

Line 133: IF FND_API.To_Boolean(p_commit) THEN

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.
137: FND_MSG_PUB.Count_And_Get

Line 146: x_return_status := FND_API.G_RET_STS_ERROR ;

142: WHEN DUP_VAL_ON_INDEX THEN
143: ROLLBACK TO create_item_pvt;
144: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_GRP_DUP_RECORD');
145: FND_MSG_PUB.Add;
146: x_return_status := FND_API.G_RET_STS_ERROR ;
147: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
148:
149: WHEN FND_API.G_EXC_ERROR THEN
150: ROLLBACK TO create_item_PVT;

Line 149: WHEN FND_API.G_EXC_ERROR THEN

145: FND_MSG_PUB.Add;
146: x_return_status := FND_API.G_RET_STS_ERROR ;
147: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
148:
149: WHEN FND_API.G_EXC_ERROR THEN
150: ROLLBACK TO create_item_PVT;
151: x_return_status := FND_API.G_RET_STS_ERROR ;
152: FND_MSG_PUB.Count_And_Get
153: ( p_count => x_msg_count,

Line 151: x_return_status := FND_API.G_RET_STS_ERROR ;

147: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
148:
149: WHEN FND_API.G_EXC_ERROR THEN
150: ROLLBACK TO create_item_PVT;
151: x_return_status := FND_API.G_RET_STS_ERROR ;
152: FND_MSG_PUB.Count_And_Get
153: ( p_count => x_msg_count,
154: p_data => x_msg_data
155: );

Line 156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

152: FND_MSG_PUB.Count_And_Get
153: ( p_count => x_msg_count,
154: p_data => x_msg_data
155: );
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO create_item_PVT;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count,

Line 158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

154: p_data => x_msg_data
155: );
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO create_item_PVT;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count,
161: p_data => x_msg_data
162: );

Line 165: x_return_status := FND_API.G_RET_STS_ERROR;

161: p_data => x_msg_data
162: );
163: WHEN OTHERS THEN
164: ROLLBACK TO create_item_PVT;
165: x_return_status := FND_API.G_RET_STS_ERROR;
166: IF FND_MSG_PUB.Check_Msg_Level
167: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
168: THEN
169: FND_MSG_PUB.Add_Exc_Msg

Line 198: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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)
202: THEN

Line 203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

199: p_api_version_number,
200: l_api_name,
201: G_PKG_NAME)
202: THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205: -- Initialize message list if p_init_msg_list is set to TRUE.
206: IF FND_API.to_Boolean( p_init_msg_list )
207: THEN

Line 206: IF FND_API.to_Boolean( p_init_msg_list )

202: THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205: -- Initialize message list if p_init_msg_list is set to TRUE.
206: IF FND_API.to_Boolean( p_init_msg_list )
207: THEN
208: FND_MSG_PUB.initialize;
209: END IF;
210: -- Initialize API return status to SUCCESS

Line 211: x_return_status := FND_API.G_RET_STS_SUCCESS;

207: THEN
208: FND_MSG_PUB.initialize;
209: END IF;
210: -- Initialize API return status to SUCCESS
211: x_return_status := FND_API.G_RET_STS_SUCCESS;
212:
213: if (p_emc_server_id is null or p_emc_server_id=FND_API.G_MISS_CHAR) then
214: delete from IEM_EMC_SERVERS
215: where emc_server_name=p_emc_server_name and server_group_id=p_server_group_id ;

Line 213: if (p_emc_server_id is null or p_emc_server_id=FND_API.G_MISS_CHAR) then

209: END IF;
210: -- Initialize API return status to SUCCESS
211: x_return_status := FND_API.G_RET_STS_SUCCESS;
212:
213: if (p_emc_server_id is null or p_emc_server_id=FND_API.G_MISS_CHAR) then
214: delete from IEM_EMC_SERVERS
215: where emc_server_name=p_emc_server_name and server_group_id=p_server_group_id ;
216: else
217: delete from IEM_EMC_SERVERS

Line 222: IF FND_API.To_Boolean(p_commit) THEN

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.
226: FND_MSG_PUB.Count_And_Get

Line 231: WHEN FND_API.G_EXC_ERROR THEN

227: ( p_count => x_msg_count,
228: p_data => x_msg_data
229: );
230: EXCEPTION
231: WHEN FND_API.G_EXC_ERROR THEN
232: ROLLBACK TO delete_item_PVT;
233: x_return_status := FND_API.G_RET_STS_ERROR ;
234: FND_MSG_PUB.Count_And_Get
235: ( p_count => x_msg_count,

Line 233: x_return_status := FND_API.G_RET_STS_ERROR ;

229: );
230: EXCEPTION
231: WHEN FND_API.G_EXC_ERROR THEN
232: ROLLBACK TO delete_item_PVT;
233: x_return_status := FND_API.G_RET_STS_ERROR ;
234: FND_MSG_PUB.Count_And_Get
235: ( p_count => x_msg_count,
236: p_data => x_msg_data
237: );

Line 238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

234: FND_MSG_PUB.Count_And_Get
235: ( p_count => x_msg_count,
236: p_data => x_msg_data
237: );
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: ROLLBACK TO delete_item_PVT;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
241: FND_MSG_PUB.Count_And_Get
242: ( p_count => x_msg_count,

Line 240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

236: p_data => x_msg_data
237: );
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: ROLLBACK TO delete_item_PVT;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
241: FND_MSG_PUB.Count_And_Get
242: ( p_count => x_msg_count,
243: p_data => x_msg_data
244: );

Line 247: x_return_status := FND_API.G_RET_STS_ERROR;

243: p_data => x_msg_data
244: );
245: WHEN OTHERS THEN
246: ROLLBACK TO delete_item_PVT;
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: IF FND_MSG_PUB.Check_Msg_Level
249: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
250: THEN
251: FND_MSG_PUB.Add_Exc_Msg

Line 305: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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)
309: THEN

Line 310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

306: p_api_version_number,
307: l_api_name,
308: G_PKG_NAME)
309: THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;
312: -- Initialize message list if p_init_msg_list is set to TRUE.
313: IF FND_API.to_Boolean( p_init_msg_list )
314: THEN

Line 313: IF FND_API.to_Boolean( p_init_msg_list )

309: THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;
312: -- Initialize message list if p_init_msg_list is set to TRUE.
313: IF FND_API.to_Boolean( p_init_msg_list )
314: THEN
315: FND_MSG_PUB.initialize;
316: END IF;
317: -- Initialize API return status to SUCCESS

Line 318: x_return_status := FND_API.G_RET_STS_SUCCESS;

314: THEN
315: FND_MSG_PUB.initialize;
316: END IF;
317: -- Initialize API return status to SUCCESS
318: x_return_status := FND_API.G_RET_STS_SUCCESS;
319:
320: if (p_server_group_id is not null OR p_server_group_id <> FND_API.G_MISS_NUM) then
321:
322: /*Check For Existing EMC Server Group */

Line 320: if (p_server_group_id is not null OR p_server_group_id <> FND_API.G_MISS_NUM) then

316: END IF;
317: -- Initialize API return status to SUCCESS
318: x_return_status := FND_API.G_RET_STS_SUCCESS;
319:
320: if (p_server_group_id is not null OR p_server_group_id <> FND_API.G_MISS_NUM) then
321:
322: /*Check For Existing EMC Server Group */
323:
324: Select count(*) into l_grp_cnt from iem_server_groups

Line 332: if (p_emc_server_id = FND_API.G_MISS_NUM OR p_emc_server_id is null) then

328: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_GRP');
329: APP_EXCEPTION.RAISE_EXCEPTION;
330: END IF;
331: end if;
332: if (p_emc_server_id = FND_API.G_MISS_NUM OR p_emc_server_id is null) then
333: update IEM_EMC_SERVERS
334: SET dns_name=decode(p_dns_name,FND_API.G_MISS_CHAR,null,null,dns_name,p_dns_name),
335: ip_address=decode(p_ip_address,FND_API.G_MISS_CHAR,null,null,ip_address,p_ip_address),
336: LAST_UPDATE_DATE = sysdate,

Line 334: SET dns_name=decode(p_dns_name,FND_API.G_MISS_CHAR,null,null,dns_name,p_dns_name),

330: END IF;
331: end if;
332: if (p_emc_server_id = FND_API.G_MISS_NUM OR p_emc_server_id is null) then
333: update IEM_EMC_SERVERS
334: SET dns_name=decode(p_dns_name,FND_API.G_MISS_CHAR,null,null,dns_name,p_dns_name),
335: ip_address=decode(p_ip_address,FND_API.G_MISS_CHAR,null,null,ip_address,p_ip_address),
336: LAST_UPDATE_DATE = sysdate,
337: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
338: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),

Line 335: ip_address=decode(p_ip_address,FND_API.G_MISS_CHAR,null,null,ip_address,p_ip_address),

331: end if;
332: if (p_emc_server_id = FND_API.G_MISS_NUM OR p_emc_server_id is null) then
333: update IEM_EMC_SERVERS
334: SET dns_name=decode(p_dns_name,FND_API.G_MISS_CHAR,null,null,dns_name,p_dns_name),
335: ip_address=decode(p_ip_address,FND_API.G_MISS_CHAR,null,null,ip_address,p_ip_address),
336: LAST_UPDATE_DATE = sysdate,
337: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
338: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),
339: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),

Line 339: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),

335: ip_address=decode(p_ip_address,FND_API.G_MISS_CHAR,null,null,ip_address,p_ip_address),
336: LAST_UPDATE_DATE = sysdate,
337: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
338: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),
339: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
340: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
341: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
342: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
343: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),

Line 340: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),

336: LAST_UPDATE_DATE = sysdate,
337: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
338: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),
339: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
340: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
341: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
342: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
343: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
344: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),

Line 341: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),

337: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
338: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),
339: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
340: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
341: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
342: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
343: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
344: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
345: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),

Line 342: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),

338: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),
339: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
340: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
341: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
342: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
343: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
344: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
345: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
346: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),

Line 343: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),

339: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
340: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
341: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
342: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
343: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
344: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
345: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
346: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
347: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),

Line 344: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),

340: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
341: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
342: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
343: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
344: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
345: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
346: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
347: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
348: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),

Line 345: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),

341: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
342: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
343: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
344: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
345: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
346: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
347: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
348: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
349: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),

Line 346: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),

342: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
343: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
344: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
345: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
346: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
347: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
348: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
349: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
350: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),

Line 347: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),

343: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
344: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
345: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
346: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
347: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
348: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
349: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
350: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
351: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),

Line 348: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),

344: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
345: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
346: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
347: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
348: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
349: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
350: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
351: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
352: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),

Line 349: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),

345: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
346: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
347: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
348: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
349: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
350: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
351: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
352: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
353: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)

Line 350: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),

346: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
347: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
348: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
349: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
350: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
351: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
352: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
353: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
354: where emc_server_name=p_emc_server_name and server_group_id=p_server_group_id ;

Line 351: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),

347: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
348: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
349: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
350: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
351: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
352: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
353: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
354: where emc_server_name=p_emc_server_name and server_group_id=p_server_group_id ;
355: ELSE

Line 352: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),

348: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
349: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
350: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
351: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
352: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
353: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
354: where emc_server_name=p_emc_server_name and server_group_id=p_server_group_id ;
355: ELSE
356: update IEM_EMC_SERVERS

Line 353: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)

349: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
350: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
351: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
352: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
353: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
354: where emc_server_name=p_emc_server_name and server_group_id=p_server_group_id ;
355: ELSE
356: update IEM_EMC_SERVERS
357: set server_group_id=decode(p_server_group_id,FND_API.G_MISS_NUM,null,null,server_group_id,p_server_group_id),

Line 357: set server_group_id=decode(p_server_group_id,FND_API.G_MISS_NUM,null,null,server_group_id,p_server_group_id),

353: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
354: where emc_server_name=p_emc_server_name and server_group_id=p_server_group_id ;
355: ELSE
356: update IEM_EMC_SERVERS
357: set server_group_id=decode(p_server_group_id,FND_API.G_MISS_NUM,null,null,server_group_id,p_server_group_id),
358: emc_server_name=decode(p_emc_server_name,FND_API.G_MISS_CHAR,null,null,emc_server_name,p_emc_server_name),
359: dns_name=decode(p_dns_name,FND_API.G_MISS_CHAR,null,null,dns_name,p_dns_name),
360: ip_address=decode(p_ip_address,FND_API.G_MISS_CHAR,null,null,ip_address,p_ip_address),
361: LAST_UPDATE_DATE = sysdate,

Line 358: emc_server_name=decode(p_emc_server_name,FND_API.G_MISS_CHAR,null,null,emc_server_name,p_emc_server_name),

354: where emc_server_name=p_emc_server_name and server_group_id=p_server_group_id ;
355: ELSE
356: update IEM_EMC_SERVERS
357: set server_group_id=decode(p_server_group_id,FND_API.G_MISS_NUM,null,null,server_group_id,p_server_group_id),
358: emc_server_name=decode(p_emc_server_name,FND_API.G_MISS_CHAR,null,null,emc_server_name,p_emc_server_name),
359: dns_name=decode(p_dns_name,FND_API.G_MISS_CHAR,null,null,dns_name,p_dns_name),
360: ip_address=decode(p_ip_address,FND_API.G_MISS_CHAR,null,null,ip_address,p_ip_address),
361: LAST_UPDATE_DATE = sysdate,
362: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),

Line 359: dns_name=decode(p_dns_name,FND_API.G_MISS_CHAR,null,null,dns_name,p_dns_name),

355: ELSE
356: update IEM_EMC_SERVERS
357: set server_group_id=decode(p_server_group_id,FND_API.G_MISS_NUM,null,null,server_group_id,p_server_group_id),
358: emc_server_name=decode(p_emc_server_name,FND_API.G_MISS_CHAR,null,null,emc_server_name,p_emc_server_name),
359: dns_name=decode(p_dns_name,FND_API.G_MISS_CHAR,null,null,dns_name,p_dns_name),
360: ip_address=decode(p_ip_address,FND_API.G_MISS_CHAR,null,null,ip_address,p_ip_address),
361: LAST_UPDATE_DATE = sysdate,
362: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
363: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),

Line 360: ip_address=decode(p_ip_address,FND_API.G_MISS_CHAR,null,null,ip_address,p_ip_address),

356: update IEM_EMC_SERVERS
357: set server_group_id=decode(p_server_group_id,FND_API.G_MISS_NUM,null,null,server_group_id,p_server_group_id),
358: emc_server_name=decode(p_emc_server_name,FND_API.G_MISS_CHAR,null,null,emc_server_name,p_emc_server_name),
359: dns_name=decode(p_dns_name,FND_API.G_MISS_CHAR,null,null,dns_name,p_dns_name),
360: ip_address=decode(p_ip_address,FND_API.G_MISS_CHAR,null,null,ip_address,p_ip_address),
361: LAST_UPDATE_DATE = sysdate,
362: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
363: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),
364: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),

Line 364: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),

360: ip_address=decode(p_ip_address,FND_API.G_MISS_CHAR,null,null,ip_address,p_ip_address),
361: LAST_UPDATE_DATE = sysdate,
362: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
363: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),
364: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
365: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
366: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
367: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
368: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),

Line 365: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),

361: LAST_UPDATE_DATE = sysdate,
362: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
363: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),
364: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
365: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
366: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
367: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
368: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
369: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),

Line 366: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),

362: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
363: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),
364: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
365: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
366: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
367: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
368: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
369: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
370: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),

Line 367: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),

363: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),
364: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
365: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
366: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
367: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
368: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
369: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
370: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
371: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),

Line 368: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),

364: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
365: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
366: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
367: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
368: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
369: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
370: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
371: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
372: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),

Line 369: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),

365: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
366: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
367: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
368: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
369: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
370: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
371: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
372: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
373: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),

Line 370: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),

366: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
367: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
368: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
369: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
370: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
371: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
372: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
373: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
374: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),

Line 371: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),

367: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
368: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
369: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
370: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
371: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
372: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
373: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
374: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
375: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),

Line 372: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),

368: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
369: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
370: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
371: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
372: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
373: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
374: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
375: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
376: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),

Line 373: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),

369: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
370: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
371: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
372: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
373: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
374: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
375: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
376: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
377: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),

Line 374: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),

370: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
371: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
372: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
373: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
374: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
375: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
376: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
377: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
378: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)

Line 375: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),

371: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
372: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
373: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
374: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
375: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
376: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
377: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
378: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
379: where emc_server_id=p_emc_server_id;

Line 376: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),

372: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
373: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
374: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
375: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
376: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
377: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
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;

Line 377: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),

373: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
374: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
375: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
376: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
377: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
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:

Line 378: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)

374: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
375: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
376: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
377: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
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.

Line 383: IF FND_API.To_Boolean(p_commit) THEN

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.
387: FND_MSG_PUB.Count_And_Get

Line 396: x_return_status := FND_API.G_RET_STS_ERROR ;

392: WHEN DUP_VAL_ON_INDEX THEN
393: ROLLBACK TO update_item_pvt;
394: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_GRP_DUP_RECORD');
395: FND_MSG_PUB.Add;
396: x_return_status := FND_API.G_RET_STS_ERROR ;
397: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
398:
399:
400: WHEN FND_API.G_EXC_ERROR THEN

Line 400: WHEN FND_API.G_EXC_ERROR THEN

396: x_return_status := FND_API.G_RET_STS_ERROR ;
397: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
398:
399:
400: WHEN FND_API.G_EXC_ERROR THEN
401: ROLLBACK TO update_item_PVT;
402: x_return_status := FND_API.G_RET_STS_ERROR ;
403: FND_MSG_PUB.Count_And_Get
404: ( p_count => x_msg_count,

Line 402: x_return_status := FND_API.G_RET_STS_ERROR ;

398:
399:
400: WHEN FND_API.G_EXC_ERROR THEN
401: ROLLBACK TO update_item_PVT;
402: x_return_status := FND_API.G_RET_STS_ERROR ;
403: FND_MSG_PUB.Count_And_Get
404: ( p_count => x_msg_count,
405: p_data => x_msg_data
406: );

Line 407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

403: FND_MSG_PUB.Count_And_Get
404: ( p_count => x_msg_count,
405: p_data => x_msg_data
406: );
407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
408: ROLLBACK TO update_item_PVT;
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: FND_MSG_PUB.Count_And_Get
411: ( p_count => x_msg_count,

Line 409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

405: p_data => x_msg_data
406: );
407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
408: ROLLBACK TO update_item_PVT;
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410: FND_MSG_PUB.Count_And_Get
411: ( p_count => x_msg_count,
412: p_data => x_msg_data
413: );

Line 416: x_return_status := FND_API.G_RET_STS_ERROR;

412: p_data => x_msg_data
413: );
414: WHEN OTHERS THEN
415: ROLLBACK TO update_item_PVT;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: IF FND_MSG_PUB.Check_Msg_Level
418: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
419: THEN
420: FND_MSG_PUB.Add_Exc_Msg

Line 452: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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)
456: THEN

Line 457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

453: p_api_version_number,
454: l_api_name,
455: G_PKG_NAME)
456: THEN
457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END IF;
459:
460: --Initialize the message list if p_init_msg_list is set to TRUE
461: If FND_API.to_Boolean(p_init_msg_list) THEN

Line 461: If FND_API.to_Boolean(p_init_msg_list) THEN

457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
458: END IF;
459:
460: --Initialize the message list if p_init_msg_list is set to TRUE
461: If FND_API.to_Boolean(p_init_msg_list) THEN
462: FND_MSG_PUB.initialize;
463: END IF;
464:
465: --Initialize API status return

Line 466: x_return_status := FND_API.G_RET_STS_SUCCESS;

462: FND_MSG_PUB.initialize;
463: END IF;
464:
465: --Initialize API status return
466: x_return_status := FND_API.G_RET_STS_SUCCESS;
467:
468: --Actual API starts here
469: FORALL i IN p_group_tbl.FIRST..p_group_tbl.LAST
470: DELETE

Line 480: IF FND_API.to_Boolean(p_commit) THEN

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:
484:

Line 488: x_return_status := FND_API.G_RET_STS_ERROR;

484:
485: EXCEPTION
486: WHEN SERVER_GROUP_NOT_DELETED THEN
487: ROLLBACK TO delete_item_batch;
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: FND_MESSAGE.SET_NAME('IEM', 'IEM_SERVER_GROUP_NOT_DELETED');
490: FND_MSG_PUB.ADD;
491: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
492:

Line 493: WHEN FND_API.G_EXC_ERROR THEN

489: FND_MESSAGE.SET_NAME('IEM', 'IEM_SERVER_GROUP_NOT_DELETED');
490: FND_MSG_PUB.ADD;
491: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
492:
493: WHEN FND_API.G_EXC_ERROR THEN
494: ROLLBACK TO delete_item_batch;
495: x_return_status := FND_API.G_RET_STS_ERROR ;
496: FND_MSG_PUB.Count_And_Get
497: ( p_count => x_msg_count,p_data => x_msg_data);

Line 495: x_return_status := FND_API.G_RET_STS_ERROR ;

491: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
492:
493: WHEN FND_API.G_EXC_ERROR THEN
494: ROLLBACK TO delete_item_batch;
495: x_return_status := FND_API.G_RET_STS_ERROR ;
496: FND_MSG_PUB.Count_And_Get
497: ( p_count => x_msg_count,p_data => x_msg_data);
498:
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

495: x_return_status := FND_API.G_RET_STS_ERROR ;
496: FND_MSG_PUB.Count_And_Get
497: ( p_count => x_msg_count,p_data => x_msg_data);
498:
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: ROLLBACK TO delete_item_batch;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
502: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
503:

Line 501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

497: ( p_count => x_msg_count,p_data => x_msg_data);
498:
499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
500: ROLLBACK TO delete_item_batch;
501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
502: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
503:
504: WHEN OTHERS THEN
505: ROLLBACK TO delete_item_batch;

Line 506: x_return_status := FND_API.G_RET_STS_ERROR;

502: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
503:
504: WHEN OTHERS THEN
505: ROLLBACK TO delete_item_batch;
506: x_return_status := FND_API.G_RET_STS_ERROR;
507: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
508: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
509: END IF;
510: