1567: x_return_status := FND_API.G_RET_STS_SUCCESS;
1568:
1569: EXCEPTION
1570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1571: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1572: p_encoded => 'F');
1573: x_return_status := FND_API.G_RET_STS_ERROR;
1574: WHEN OTHERS THEN
1575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1571: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1572: p_encoded => 'F');
1573: x_return_status := FND_API.G_RET_STS_ERROR;
1574: WHEN OTHERS THEN
1575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1576: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name,
1577: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
1578: END IF;
1579:
1572: p_encoded => 'F');
1573: x_return_status := FND_API.G_RET_STS_ERROR;
1574: WHEN OTHERS THEN
1575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1576: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name,
1577: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
1578: END IF;
1579:
1580: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1576: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name,
1577: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
1578: END IF;
1579:
1580: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1581: p_encoded => 'F');
1582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1583:
1584: END UPDATE_NEGOTIATION_LINE_REF;
2305:
2306: EXCEPTION
2307: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2308: ROLLBACK TO renegotiate_blanket_grp;
2309: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
2310: p_encoded => 'F');
2311: x_return_status := l_ret_sts_error;
2312: WHEN OTHERS THEN
2313: ROLLBACK TO renegotiate_blanket_grp;
2310: p_encoded => 'F');
2311: x_return_status := l_ret_sts_error;
2312: WHEN OTHERS THEN
2313: ROLLBACK TO renegotiate_blanket_grp;
2314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2315: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name,
2316: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
2317: END IF;
2318:
2311: x_return_status := l_ret_sts_error;
2312: WHEN OTHERS THEN
2313: ROLLBACK TO renegotiate_blanket_grp;
2314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2315: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name,
2316: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
2317: END IF;
2318:
2319: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
2315: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name,
2316: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
2317: END IF;
2318:
2319: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
2320: p_encoded => 'F');
2321: x_return_status := l_ret_sts_error;
2322:
2323: END RENEGOTIATE_BLANKET;
2405: ' l_msg_data: ' || l_msg_data || ' l_msg_count: ' || l_msg_count);
2406: END IF;
2407: END IF;
2408:
2409: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2410: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name,
2411: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
2412: END IF;
2413:
2406: END IF;
2407: END IF;
2408:
2409: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2410: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name,
2411: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);
2412: END IF;
2413:
2414: x_auction_display_line_num := NULL;