43:
44: begin
45: x_return_status := FND_API.G_RET_STS_SUCCESS;
46: IF FND_API.to_Boolean( p_init_msg_list ) THEN
47: FND_MSG_PUB.initialize;
48: END IF;
49: IF FND_GLOBAL.User_Id IS NULL THEN
50: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
51: RAISE FND_API.G_EXC_ERROR;
315: exception
316: WHEN FND_API.G_EXC_ERROR THEN
317: ROLLBACK;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
320:
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322: ROLLBACK;
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
320:
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322: ROLLBACK;
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
325:
326: WHEN OTHERS THEN
327: ROLLBACK;
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
325:
326: WHEN OTHERS THEN
327: ROLLBACK;
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
330: THEN
331: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
332: END IF;
333: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
327: ROLLBACK;
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
330: THEN
331: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
332: END IF;
333: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
334:
335: end insert_row;
329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
330: THEN
331: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
332: END IF;
333: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
334:
335: end insert_row;
336:
337: