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 284: x_return_status := FND_API.G_RET_STS_SUCCESS;

280: WHERE key = l_procedure_id;
281:
282: -- bug3592160 END
283:
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);

Line 287: WHEN FND_API.G_EXC_ERROR THEN

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

Line 289: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 414: x_return_status := FND_API.G_RET_STS_SUCCESS;

410: WHERE key = l_procedure_id;
411:
412: -- bug3592160 END
413:
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);

Line 417: WHEN FND_API.G_EXC_ERROR THEN

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

Line 419: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 545: x_return_status := FND_API.G_RET_STS_SUCCESS;

541: x_req_status_rec.cancel_flag
542: FROM po_headers_gt
543: ORDER BY PO_HEADER_ID;
544:
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);

Line 548: WHEN FND_API.G_EXC_ERROR THEN

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

Line 550: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

631: END IF;
632:
633: -- Standard call to check for call compatibility
634: l_progress := '010';
635: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: END IF;
638:
639: l_progress := '020'; -- Initialize Local/Output Variables

Line 636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 658: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

654: x_return_status => x_return_status,
655: x_msg_count => x_msg_count,
656: x_msg_data => x_msg_data);
657:
658: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
659: return;
660: END IF;
661:
662: END IF; --END of IF INSTR(p_mode, G_CHECK_UPDATEABLE) > 0

Line 679: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

675: x_return_status => x_return_status,
676: x_msg_count => x_msg_count,
677: x_msg_data => x_msg_data);
678:
679: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
680: return;
681: END IF;
682:
683: END IF; --END of IF INSTR(p_mode, G_CHECK_RESERVABLE) > 0

Line 700: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

696: x_return_status => x_return_status,
697: x_msg_count => x_msg_count,
698: x_msg_data => x_msg_data);
699:
700: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
701: return;
702: END IF;
703:
704: END IF; --END of IF INSTR(p_mode, G_CHECK_UNRESERVABLE) > 0

Line 720: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

716: x_return_status => x_return_status,
717: x_msg_count => x_msg_count,
718: x_msg_data => x_msg_data);
719:
720: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
721: return;
722: END IF;
723:
724: END IF; --}END of IF INSTR(p_mode, G_GET_STATUS) > 0

Line 732: RAISE FND_API.G_EXC_ERROR;

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

Line 736: WHEN FND_API.G_EXC_ERROR THEN

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

Line 738: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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