154: END IF;
155:
156: -- Check p_init_msg_list
157: IF FND_API.to_boolean(p_init_msg_list) THEN
158: FND_MSG_PUB.initialize;
159: END IF;
160:
161: -- initialize API return status to success
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
1426: END IF;
1427: --
1428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: IF FND_MSG_PUB.check_msg_level
1431: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1432: THEN
1433: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1434: END IF;
1427: --
1428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: IF FND_MSG_PUB.check_msg_level
1431: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1432: THEN
1433: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1434: END IF;
1435: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);
1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: IF FND_MSG_PUB.check_msg_level
1431: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1432: THEN
1433: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1434: END IF;
1435: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);
1436:
1437:
1431: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1432: THEN
1433: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1434: END IF;
1435: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);
1436:
1437:
1438: --
1439: -- Debug Statements
1444: END IF;
1445: --
1446: WHEN OTHERS THEN
1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1448: IF FND_MSG_PUB.check_msg_level
1449: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1450: THEN
1451: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1452: END IF;
1445: --
1446: WHEN OTHERS THEN
1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1448: IF FND_MSG_PUB.check_msg_level
1449: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1450: THEN
1451: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1452: END IF;
1453: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);
1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1448: IF FND_MSG_PUB.check_msg_level
1449: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1450: THEN
1451: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1452: END IF;
1453: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);
1454:
1455:
1449: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1450: THEN
1451: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1452: END IF;
1453: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);
1454:
1455:
1456:
1457: