48:
49: begin
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51: IF FND_API.to_Boolean( p_init_msg_list ) THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54: IF FND_GLOBAL.User_Id IS NULL THEN
55: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
56: RAISE FND_API.G_EXC_ERROR;
222: exception
223: WHEN FND_API.G_EXC_ERROR THEN
224: ROLLBACK;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
227:
228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
229: ROLLBACK;
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227:
228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
229: ROLLBACK;
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
232:
233: WHEN OTHERS THEN
234: ROLLBACK;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232:
233: WHEN OTHERS THEN
234: ROLLBACK;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
237: THEN
238: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
239: END IF;
240: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
234: ROLLBACK;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
237: THEN
238: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
239: END IF;
240: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
241:
242: end insert_exception_header_row;
236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
237: THEN
238: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
239: END IF;
240: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
241:
242: end insert_exception_header_row;
243:
244:
261:
262: begin
263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264: IF FND_API.to_Boolean( p_init_msg_list ) THEN
265: FND_MSG_PUB.initialize;
266: END IF;
267: IF FND_GLOBAL.User_Id IS NULL THEN
268: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
269: RAISE FND_API.G_EXC_ERROR;
298: exception
299: WHEN FND_API.G_EXC_ERROR THEN
300: ROLLBACK;
301: x_return_status := FND_API.G_RET_STS_ERROR;
302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: ROLLBACK;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: ROLLBACK;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
308:
309: WHEN OTHERS THEN
310: ROLLBACK;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308:
309: WHEN OTHERS THEN
310: ROLLBACK;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
313: THEN
314: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
315: END IF;
316: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
310: ROLLBACK;
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
313: THEN
314: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
315: END IF;
316: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
317:
318: end insert_exceptions_reasons_row;
312: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
313: THEN
314: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
315: END IF;
316: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
317:
318: end insert_exceptions_reasons_row;
319:
320: