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
71: /* Copy all parameters to local variables to be passed to Pre, Post AND Business APIs */
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;
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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;
219: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
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;
219: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
220: p_data => x_msg_data );
221: END Create_WebAssist;
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;
219: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
220: p_data => x_msg_data );
221: END Create_WebAssist;
222:
223: PROCEDURE Update_WebAssist(
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
261: /* Copy all parameters to local variables to be passed to Pre, Post AND Business APIs */
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;
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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;
360: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
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;
360: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
361: p_data => x_msg_data );
362: END Update_WebAssist;
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;
360: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
361: p_data => x_msg_data );
362: END Update_WebAssist;
363: BEGIN
364: G_APPL_ID := FND_GLOBAL.Prog_Appl_Id;