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:
284: x_return_status := FND_API.G_RET_STS_SUCCESS;
285:
286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN
288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: WHEN OTHERS THEN
291: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
292: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
287: WHEN FND_API.G_EXC_ERROR THEN
288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: WHEN OTHERS THEN
291: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
292: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
294:
295: END check_reservable;
288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: WHEN OTHERS THEN
291: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
292: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
294:
295: END check_reservable;
296:
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415:
416: EXCEPTION
417: WHEN FND_API.G_EXC_ERROR THEN
418: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: WHEN OTHERS THEN
421: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
417: WHEN FND_API.G_EXC_ERROR THEN
418: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: WHEN OTHERS THEN
421: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424:
425: END check_unreservable;
418: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: WHEN OTHERS THEN
421: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424:
425: END check_unreservable;
426:
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546:
547: EXCEPTION
548: WHEN FND_API.G_EXC_ERROR THEN
549: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: WHEN OTHERS THEN
552: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
553: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
548: WHEN FND_API.G_EXC_ERROR THEN
549: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: WHEN OTHERS THEN
552: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
553: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555:
556: END get_status;
549: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: WHEN OTHERS THEN
552: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
553: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555:
556: END get_status;
557:
727:
728: IF x_return_status is null THEN -- no valid check status request specified
729: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
730: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid p_mode: ' || p_mode);
731: FND_MSG_PUB.Add;
732: RAISE FND_API.G_EXC_ERROR;
733: END IF;
734:
735: EXCEPTION
733: END IF;
734:
735: EXCEPTION
736: WHEN FND_API.G_EXC_ERROR THEN
737: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
738: x_return_status := FND_API.G_RET_STS_ERROR;
739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
740: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: WHEN FND_API.G_EXC_ERROR THEN
737: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
738: x_return_status := FND_API.G_RET_STS_ERROR;
739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
740: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: WHEN OTHERS THEN
743: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
744: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
740: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: WHEN OTHERS THEN
743: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
744: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746:
747: END req_status_check;
740: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: WHEN OTHERS THEN
743: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
744: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746:
747: END req_status_check;
748: