599:
600: IF x_return_stat = 'E'
601: THEN
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: FND_MESSAGE.set_name('AMS', 'AMS_FCST_GET_LISTPRICE_FAILURE');
604: FND_MESSAGE.set_token('ERR_MSG',x_return_status_text);
605: FND_MSG_PUB.add;
606: RAISE FND_API.G_EXC_ERROR;
607: ELSE
600: IF x_return_stat = 'E'
601: THEN
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: FND_MESSAGE.set_name('AMS', 'AMS_FCST_GET_LISTPRICE_FAILURE');
604: FND_MESSAGE.set_token('ERR_MSG',x_return_status_text);
605: FND_MSG_PUB.add;
606: RAISE FND_API.G_EXC_ERROR;
607: ELSE
608:
616:
617: IF l_status_code <> 'UPDATED'
618: THEN
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: FND_MESSAGE.set_name('AMS', 'AMS_FCST_GET_LISTPRICE_FAILURE');
621: FND_MESSAGE.set_token('ERR_MSG',l_status_text);
622: FND_MSG_PUB.add;
623: RAISE FND_API.G_EXC_ERROR;
624:
617: IF l_status_code <> 'UPDATED'
618: THEN
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: FND_MESSAGE.set_name('AMS', 'AMS_FCST_GET_LISTPRICE_FAILURE');
621: FND_MESSAGE.set_token('ERR_MSG',l_status_text);
622: FND_MSG_PUB.add;
623: RAISE FND_API.G_EXC_ERROR;
624:
625: END IF;
644:
645: WHEN OTHERS THEN
646: x_return_status := FND_API.g_ret_sts_unexp_error;
647:
648: FND_MESSAGE.set_name('AMS', 'AMS_FCST_GET_LISTPRICE_FAILURE');
649: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
650: FND_MSG_PUB.add;
651:
652: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
645: WHEN OTHERS THEN
646: x_return_status := FND_API.g_ret_sts_unexp_error;
647:
648: FND_MESSAGE.set_name('AMS', 'AMS_FCST_GET_LISTPRICE_FAILURE');
649: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
650: FND_MSG_PUB.add;
651:
652: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
653: THEN