153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154:
155: EXCEPTION
156: WHEN FND_API.G_EXC_ERROR THEN
157: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: WHEN OTHERS THEN
160: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
161: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
156: WHEN FND_API.G_EXC_ERROR THEN
157: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: WHEN OTHERS THEN
160: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
161: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
163:
164: END check_updatable;
157: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: WHEN OTHERS THEN
160: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
161: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
163:
164: END check_updatable;
165:
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290:
291: EXCEPTION
292: WHEN FND_API.G_EXC_ERROR THEN
293: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: WHEN OTHERS THEN
296: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
297: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
292: WHEN FND_API.G_EXC_ERROR THEN
293: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: WHEN OTHERS THEN
296: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
297: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299:
300: END check_reservable;
293: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: WHEN OTHERS THEN
296: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
297: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299:
300: END check_reservable;
301:
419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420:
421: EXCEPTION
422: WHEN FND_API.G_EXC_ERROR THEN
423: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: WHEN OTHERS THEN
426: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
427: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
422: WHEN FND_API.G_EXC_ERROR THEN
423: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: WHEN OTHERS THEN
426: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
427: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429:
430: END check_unreservable;
423: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: WHEN OTHERS THEN
426: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
427: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429:
430: END check_unreservable;
431:
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551:
552: EXCEPTION
553: WHEN FND_API.G_EXC_ERROR THEN
554: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: WHEN OTHERS THEN
557: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
558: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
553: WHEN FND_API.G_EXC_ERROR THEN
554: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: WHEN OTHERS THEN
557: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
558: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560:
561: END get_status;
554: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: WHEN OTHERS THEN
557: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
558: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560:
561: END get_status;
562:
732:
733: IF x_return_status is null THEN -- no valid check status request specified
734: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
735: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid p_mode: ' || p_mode);
736: FND_MSG_PUB.Add;
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;
739:
740: EXCEPTION
738: END IF;
739:
740: EXCEPTION
741: WHEN FND_API.G_EXC_ERROR THEN
742: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
741: WHEN FND_API.G_EXC_ERROR THEN
742: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
747: WHEN OTHERS THEN
748: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
749: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
747: WHEN OTHERS THEN
748: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
749: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751:
752: END req_status_check;
745: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
747: WHEN OTHERS THEN
748: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
749: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751:
752: END req_status_check;
753: