1197: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status_text',l_return_status_text);
1198: END IF;
1199:
1200: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1201: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1202: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1203: FND_MSG_PUB.Add;
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1198: END IF;
1199:
1200: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1201: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1202: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1203: FND_MSG_PUB.Add;
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1206: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1202: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1203: FND_MSG_PUB.Add;
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1206: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1207: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1208: FND_MSG_PUB.Add;
1209: RAISE FND_API.G_EXC_ERROR;
1210: END IF;
1203: FND_MSG_PUB.Add;
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1206: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1207: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1208: FND_MSG_PUB.Add;
1209: RAISE FND_API.G_EXC_ERROR;
1210: END IF;
1211: END IF;
1236: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status_text',l_return_status_text);
1237: END IF;
1238:
1239: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1240: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1241: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1242: FND_MSG_PUB.Add;
1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1244: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1237: END IF;
1238:
1239: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1240: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1241: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1242: FND_MSG_PUB.Add;
1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1244: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1245: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1241: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1242: FND_MSG_PUB.Add;
1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1244: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1245: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1246: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1247: FND_MSG_PUB.Add;
1248: RAISE FND_API.G_EXC_ERROR;
1249: END IF;
1242: FND_MSG_PUB.Add;
1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1244: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1245: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1246: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1247: FND_MSG_PUB.Add;
1248: RAISE FND_API.G_EXC_ERROR;
1249: END IF;
1250: END IF;
1297: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status_text',l_return_status_text);
1298: END IF;
1299:
1300: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1301: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1302: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1303: FND_MSG_PUB.Add;
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1298: END IF;
1299:
1300: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1301: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1302: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1303: FND_MSG_PUB.Add;
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1306: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1302: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1303: FND_MSG_PUB.Add;
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1306: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1307: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1308: FND_MSG_PUB.Add;
1309: RAISE FND_API.G_EXC_ERROR;
1310: END IF;
1303: FND_MSG_PUB.Add;
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1306: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1307: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_return_status_text);
1308: FND_MSG_PUB.Add;
1309: RAISE FND_API.G_EXC_ERROR;
1310: END IF;
1311: END IF;
1735: l_progress := '190';
1736: IF g_debug_stmt THEN
1737: PO_DEBUG.debug_stmt(p_log_head,l_progress,'in lock record exception, someone else working on the row');
1738: END IF;
1739: --FND_MESSAGE.SET_NAME('ONT', 'PO_LOCK_ROW_ALREADY_LOCKED');
1740: --PO_MSG_PUB.Add;
1741: RAISE FND_API.G_EXC_ERROR;
1742: WHEN NO_DATA_FOUND THEN
1743: l_progress := '200';