DBA Data[Home] [Help]

APPS.PO_REQ_DOCUMENT_CHECKS_PVT dependencies on FND_API

Line 133: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

129: p_api_version => 1.0,
130: P_req_header_id => p_req_header_id(i),
131: x_return_status => x_return_status);
132:
133: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
134: return;
135: END IF;
136: END IF; --END of IF p_lock_flag = 'Y'
137: ELSE

Line 153: x_return_status := FND_API.G_RET_STS_SUCCESS;

149:
150: -- bug3592160 END
151:
152:
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);

Line 156: WHEN FND_API.G_EXC_ERROR THEN

152:
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);

Line 158: x_return_status := FND_API.G_RET_STS_ERROR;

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);
162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
166: -------------------------------------------------------------------------------

Line 289: x_return_status := FND_API.G_RET_STS_SUCCESS;

285: WHERE key = l_procedure_id;
286:
287: -- bug3592160 END
288:
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);

Line 292: WHEN FND_API.G_EXC_ERROR THEN

288:
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);

Line 294: x_return_status := FND_API.G_RET_STS_ERROR;

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);
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
302: -------------------------------------------------------------------------------

Line 419: x_return_status := FND_API.G_RET_STS_SUCCESS;

415: WHERE key = l_procedure_id;
416:
417: -- bug3592160 END
418:
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);

Line 422: WHEN FND_API.G_EXC_ERROR THEN

418:
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);

Line 424: x_return_status := FND_API.G_RET_STS_ERROR;

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);
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
432: -------------------------------------------------------------------------------

Line 550: x_return_status := FND_API.G_RET_STS_SUCCESS;

546: x_req_status_rec.cancel_flag
547: FROM po_headers_gt
548: ORDER BY PO_HEADER_ID;
549:
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);

Line 553: WHEN FND_API.G_EXC_ERROR THEN

549:
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);

Line 555: x_return_status := FND_API.G_RET_STS_ERROR;

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);
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
563: -------------------------------------------------------------------------------

Line 640: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

636: END IF;
637:
638: -- Standard call to check for call compatibility
639: l_progress := '010';
640: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;
643:
644: l_progress := '020'; -- Initialize Local/Output Variables

Line 641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

637:
638: -- Standard call to check for call compatibility
639: l_progress := '010';
640: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;
643:
644: l_progress := '020'; -- Initialize Local/Output Variables
645: l_count := p_req_header_id.count;

Line 663: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

659: x_return_status => x_return_status,
660: x_msg_count => x_msg_count,
661: x_msg_data => x_msg_data);
662:
663: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
664: return;
665: END IF;
666:
667: END IF; --END of IF INSTR(p_mode, G_CHECK_UPDATEABLE) > 0

Line 684: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

680: x_return_status => x_return_status,
681: x_msg_count => x_msg_count,
682: x_msg_data => x_msg_data);
683:
684: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
685: return;
686: END IF;
687:
688: END IF; --END of IF INSTR(p_mode, G_CHECK_RESERVABLE) > 0

Line 705: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

701: x_return_status => x_return_status,
702: x_msg_count => x_msg_count,
703: x_msg_data => x_msg_data);
704:
705: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
706: return;
707: END IF;
708:
709: END IF; --END of IF INSTR(p_mode, G_CHECK_UNRESERVABLE) > 0

Line 725: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

721: x_return_status => x_return_status,
722: x_msg_count => x_msg_count,
723: x_msg_data => x_msg_data);
724:
725: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
726: return;
727: END IF;
728:
729: END IF; --}END of IF INSTR(p_mode, G_GET_STATUS) > 0

Line 737: RAISE FND_API.G_EXC_ERROR;

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
741: WHEN FND_API.G_EXC_ERROR THEN

Line 741: WHEN FND_API.G_EXC_ERROR THEN

737: RAISE FND_API.G_EXC_ERROR;
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);

Line 743: x_return_status := FND_API.G_RET_STS_ERROR;

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;
747: WHEN OTHERS THEN

Line 744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
747: WHEN OTHERS THEN
748: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);

Line 746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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);
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
754: