DBA Data[Home] [Help]

APPS.IEX_WEBDIR_PVT dependencies on FND_API

Line 66: IF FND_API.to_Boolean( p_init_msg_list ) THEN

62: -- Standard begin of API savepoint
63: SAVEPOINT Create_WebAssist_PVT;
64:
65: -- Check p_init_msg_list
66: IF FND_API.to_Boolean( p_init_msg_list ) THEN
67: FND_MSG_PUB.initialize;
68: END IF;
69:
70: -- Implementation of User Hooks

Line 124: x_return_status := FND_API.G_RET_STS_SUCCESS;

120: l_query_string_rec.last_update_login := l_login_id;
121:
122:
123: -- Initialize API return status to success
124: x_return_status := FND_API.G_RET_STS_SUCCESS;
125:
126:
127: OPEN c_web_assist;
128: FETCH c_web_assist INTO l_web_assist_id;

Line 202: WHEN FND_API.G_EXC_ERROR THEN

198: -- Normal API Exception handling, IF exception occurs outside of phone processing loop
199: --
200: EXCEPTION
201:
202: WHEN FND_API.G_EXC_ERROR THEN
203: ROLLBACK TO Create_WebAssist_PVT;
204: x_return_status := FND_API.G_RET_STS_ERROR ;
205: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
206: p_data => x_msg_data );

Line 204: x_return_status := FND_API.G_RET_STS_ERROR ;

200: EXCEPTION
201:
202: WHEN FND_API.G_EXC_ERROR THEN
203: ROLLBACK TO Create_WebAssist_PVT;
204: x_return_status := FND_API.G_RET_STS_ERROR ;
205: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
206: p_data => x_msg_data );
207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
208: ROLLBACK TO Create_WebAssist_PVT;

Line 207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

203: ROLLBACK TO Create_WebAssist_PVT;
204: x_return_status := FND_API.G_RET_STS_ERROR ;
205: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
206: p_data => x_msg_data );
207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
208: ROLLBACK TO Create_WebAssist_PVT;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
210: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
211: p_data => x_msg_data );

Line 209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

205: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
206: p_data => x_msg_data );
207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
208: ROLLBACK TO Create_WebAssist_PVT;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
210: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
211: p_data => x_msg_data );
212: WHEN OTHERS THEN
213: ROLLBACK TO Create_WebAssist_PVT;

Line 214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

210: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
211: p_data => x_msg_data );
212: WHEN OTHERS THEN
213: ROLLBACK TO Create_WebAssist_PVT;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
215: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
216: THEN
217: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
218: END IF;

Line 256: IF FND_API.to_Boolean( p_init_msg_list ) THEN

252: -- Standard begin of API savepoint
253: SAVEPOINT Update_WebAssist_PVT;
254:
255: -- Check p_init_msg_list
256: IF FND_API.to_Boolean( p_init_msg_list ) THEN
257: FND_MSG_PUB.initialize;
258: END IF;
259:
260: -- Implementation of User Hooks

Line 321: x_return_status := FND_API.G_RET_STS_SUCCESS;

317: l_query_string_rec.created_by := p_query_string_rec.created_by;
318:
319:
320: -- Initialize API return status to success
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322:
323:
324: IEX_WEBDIR_PKG.Update_WebAssist(
325: P_API_VERSION => l_api_version,

Line 343: WHEN FND_API.G_EXC_ERROR THEN

339: -- Normal API Exception handling, IF exception occurs outside of phone processing loop
340: --
341: EXCEPTION
342:
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO Update_WebAssist_PVT;
345: x_return_status := FND_API.G_RET_STS_ERROR ;
346: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
347: p_data => x_msg_data );

Line 345: x_return_status := FND_API.G_RET_STS_ERROR ;

341: EXCEPTION
342:
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO Update_WebAssist_PVT;
345: x_return_status := FND_API.G_RET_STS_ERROR ;
346: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
347: p_data => x_msg_data );
348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
349: ROLLBACK TO Update_WebAssist_PVT;

Line 348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

344: ROLLBACK TO Update_WebAssist_PVT;
345: x_return_status := FND_API.G_RET_STS_ERROR ;
346: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
347: p_data => x_msg_data );
348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
349: ROLLBACK TO Update_WebAssist_PVT;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
351: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
352: p_data => x_msg_data );

Line 350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

346: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
347: p_data => x_msg_data );
348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
349: ROLLBACK TO Update_WebAssist_PVT;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
351: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
352: p_data => x_msg_data );
353: WHEN OTHERS THEN
354: ROLLBACK TO Update_WebAssist_PVT;

Line 355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

351: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
352: p_data => x_msg_data );
353: WHEN OTHERS THEN
354: ROLLBACK TO Update_WebAssist_PVT;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
356: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
357: THEN
358: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
359: END IF;