1029: x_return_status := FND_API.G_RET_STS_SUCCESS;
1030:
1031: EXCEPTION
1032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1033: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1034: p_encoded => 'F');
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: WHEN OTHERS THEN
1037: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1033: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1034: p_encoded => 'F');
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: WHEN OTHERS THEN
1037: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1038: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name,
1039: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
1040: END IF;
1041:
1034: p_encoded => 'F');
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: WHEN OTHERS THEN
1037: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1038: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name,
1039: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
1040: END IF;
1041:
1042: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1038: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name,
1039: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
1040: END IF;
1041:
1042: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1043: p_encoded => 'F');
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1045:
1046: END UPDATE_NEGOTIATION_LINE_REF;
1723:
1724: EXCEPTION
1725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1726: ROLLBACK TO renegotiate_blanket_grp;
1727: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1728: p_encoded => 'F');
1729: x_return_status := l_ret_sts_error;
1730: WHEN OTHERS THEN
1731: ROLLBACK TO renegotiate_blanket_grp;
1728: p_encoded => 'F');
1729: x_return_status := l_ret_sts_error;
1730: WHEN OTHERS THEN
1731: ROLLBACK TO renegotiate_blanket_grp;
1732: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1733: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name,
1734: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
1735: END IF;
1736:
1729: x_return_status := l_ret_sts_error;
1730: WHEN OTHERS THEN
1731: ROLLBACK TO renegotiate_blanket_grp;
1732: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1733: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name,
1734: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
1735: END IF;
1736:
1737: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1733: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name,
1734: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
1735: END IF;
1736:
1737: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1738: p_encoded => 'F');
1739: x_return_status := l_ret_sts_error;
1740:
1741: END RENEGOTIATE_BLANKET;
1823: ' l_msg_data: ' || l_msg_data || ' l_msg_count: ' || l_msg_count);
1824: END IF;
1825: END IF;
1826:
1827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1828: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name,
1829: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
1830: END IF;
1831:
1824: END IF;
1825: END IF;
1826:
1827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1828: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name,
1829: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
1830: END IF;
1831:
1832: x_auction_display_line_num := NULL;