DBA Data[Home] [Help]

APPS.IEX_WEBSWITCH_PVT dependencies on FND_API

Line 48: IF NOT FND_API.Compatible_API_Call (l_api_version,

44: -- Standard begin of API savepoint
45: SAVEPOINT Create_WebSwitch_PUB;
46:
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call (l_api_version,
49: p_api_version,
50: l_api_name,
51: G_PKG_NAME)
52: THEN

Line 53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

49: p_api_version,
50: l_api_name,
51: G_PKG_NAME)
52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55:
56: -- Check p_init_msg_list
57: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 57: IF FND_API.to_Boolean( p_init_msg_list ) THEN

53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55:
56: -- Check p_init_msg_list
57: IF FND_API.to_Boolean( p_init_msg_list ) THEN
58: FND_MSG_PUB.initialize;
59: END IF;
60:
61: -- Implementation of User Hooks

Line 128: x_return_status := FND_API.G_RET_STS_SUCCESS;

124: l_switch_data_rec.attribute14 := p_switch_data_rec.attribute14;
125: l_switch_data_rec.attribute15 := p_switch_data_rec.attribute15;
126:
127: -- Initialize API return status to success
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: -- API body
131: OPEN c_cgi_switch;
132: FETCH c_cgi_switch INTO l_cgi_switch_id;

Line 174: IF FND_API.To_Boolean ( p_commit ) THEN

170:
171: -- END of API body
172:
173: -- Standard check of p_commit.
174: IF FND_API.To_Boolean ( p_commit ) THEN
175: COMMIT WORK;
176: END IF;
177:
178: -- Standard call to get message count and IF count is 1, get message info.

Line 188: WHEN FND_API.G_EXC_ERROR THEN

184: -- Normal API Exception handling, IF exception occurs outside of phone processing loop
185: --
186: EXCEPTION
187:
188: WHEN FND_API.G_EXC_ERROR THEN
189:
190: ROLLBACK TO Create_WebSwitch_PUB;
191: x_return_status := FND_API.G_RET_STS_ERROR ;
192:

Line 191: x_return_status := FND_API.G_RET_STS_ERROR ;

187:
188: WHEN FND_API.G_EXC_ERROR THEN
189:
190: ROLLBACK TO Create_WebSwitch_PUB;
191: x_return_status := FND_API.G_RET_STS_ERROR ;
192:
193: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
194: p_data => x_msg_data );
195:

Line 196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

192:
193: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
194: p_data => x_msg_data );
195:
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197:
198: ROLLBACK TO Create_WebSwitch_PUB;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
200:

Line 199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

195:
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197:
198: ROLLBACK TO Create_WebSwitch_PUB;
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
200:
201: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
202: p_data => x_msg_data );
203:

Line 207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

203:
204: WHEN OTHERS THEN
205:
206: ROLLBACK TO Create_WebSwitch_PUB;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
208:
209: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
210: THEN
211: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 245: IF NOT FND_API.Compatible_API_Call (l_api_version,

241: -- Standard begin of API savepoint
242: SAVEPOINT Update_WebSwitch_PVT;
243:
244: -- Standard call to check for call compatibility.
245: IF NOT FND_API.Compatible_API_Call (l_api_version,
246: p_api_version,
247: l_api_name,
248: G_PKG_NAME)
249: THEN

Line 250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

246: p_api_version,
247: l_api_name,
248: G_PKG_NAME)
249: THEN
250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
251: END IF;
252:
253: -- Check p_init_msg_list
254: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 254: IF FND_API.to_Boolean( p_init_msg_list ) THEN

250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
251: END IF;
252:
253: -- Check p_init_msg_list
254: IF FND_API.to_Boolean( p_init_msg_list ) THEN
255: FND_MSG_PUB.initialize;
256: END IF;
257:
258: -- Implementation of User Hooks

Line 264: x_return_status := FND_API.G_RET_STS_SUCCESS;

260: /* l_rec - will be used as In Out NOCOPY parameter in pre/post/Business API calls */
261: /* l_return_status - will be a out NOCOPY variable to get return code from called APIs */
262:
263: -- Initialize API return status to success
264: x_return_status := FND_API.G_RET_STS_SUCCESS;
265:
266: -- API body
267:
268: l_cgi_switch_rec.query_string_id := p_cgi_switch_rec.query_string_id;

Line 349: IF FND_API.To_Boolean ( p_commit ) THEN

345: -- END of API body
346:
347:
348: -- Standard check of p_commit.
349: IF FND_API.To_Boolean ( p_commit ) THEN
350: COMMIT WORK;
351: END IF;
352:
353: -- Standard call to get message count and IF count is 1, get message info.

Line 363: WHEN FND_API.G_EXC_ERROR THEN

359: -- Normal API Exception handling, IF exception occurs outside of phone processing loop
360: --
361: EXCEPTION
362:
363: WHEN FND_API.G_EXC_ERROR THEN
364:
365: ROLLBACK TO Update_WebSwitch_PVT;
366: x_return_status := FND_API.G_RET_STS_ERROR ;
367:

Line 366: x_return_status := FND_API.G_RET_STS_ERROR ;

362:
363: WHEN FND_API.G_EXC_ERROR THEN
364:
365: ROLLBACK TO Update_WebSwitch_PVT;
366: x_return_status := FND_API.G_RET_STS_ERROR ;
367:
368: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
369: p_data => x_msg_data );
370:

Line 371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

367:
368: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
369: p_data => x_msg_data );
370:
371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
372:
373: ROLLBACK TO Update_WebSwitch_PVT;
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
375:

Line 374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

370:
371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
372:
373: ROLLBACK TO Update_WebSwitch_PVT;
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
375:
376: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
377: p_data => x_msg_data );
378:

Line 382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

378:
379: WHEN OTHERS THEN
380:
381: ROLLBACK TO Update_WebSwitch_PVT;
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
383:
384: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
385: THEN
386: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);