DBA Data[Home] [Help]

APPS.POS_WC_VIEW_CANCEL_PVT dependencies on FND_API

Line 143: x_return_status := FND_API.G_RET_STS_SUCCESS;

139: FROM PO_LINE_LOCATIONS_ALL POLL
140: WHERE POLL.PO_HEADER_ID = p_po_header_id AND
141: POLL.PAYMENT_TYPE in ('MILESTONE', 'RATE', 'LUMPSUM');
142:
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: EXCEPTION
146:
147: WHEN OTHERS THEN

Line 148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

144:
145: EXCEPTION
146:
147: WHEN OTHERS THEN
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_po_header_info',
150: 'Unexpected error when calling PO API');
151:
152:

Line 249: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN

245: x_wc_display_status => x_wc_display_status,
246: x_return_status => l_api_return_status,
247: x_return_msg => l_api_return_msg);
248:
249: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
250: RAISE FND_API.G_EXC_ERROR;
251: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: END IF;

Line 250: RAISE FND_API.G_EXC_ERROR;

246: x_return_status => l_api_return_status,
247: x_return_msg => l_api_return_msg);
248:
249: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
250: RAISE FND_API.G_EXC_ERROR;
251: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: END IF;
254:

Line 251: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

247: x_return_msg => l_api_return_msg);
248:
249: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
250: RAISE FND_API.G_EXC_ERROR;
251: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: END IF;
254:
255: l_progress := 1;

Line 252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

248:
249: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
250: RAISE FND_API.G_EXC_ERROR;
251: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: END IF;
254:
255: l_progress := 1;
256:

Line 268: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN

264: x_po_lines_ordered => x_po_lines_ordered,
265: x_return_status => l_api_return_status,
266: x_return_msg => l_api_return_msg);
267:
268: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
269: RAISE FND_API.G_EXC_ERROR;
270: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
272: END IF;

Line 269: RAISE FND_API.G_EXC_ERROR;

265: x_return_status => l_api_return_status,
266: x_return_msg => l_api_return_msg);
267:
268: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
269: RAISE FND_API.G_EXC_ERROR;
270: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
272: END IF;
273:

Line 270: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

266: x_return_msg => l_api_return_msg);
267:
268: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
269: RAISE FND_API.G_EXC_ERROR;
270: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
272: END IF;
273:
274: l_progress := 2;

Line 271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

267:
268: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
269: RAISE FND_API.G_EXC_ERROR;
270: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
272: END IF;
273:
274: l_progress := 2;
275:

Line 284: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN

280: x_wc_prev_delivered => x_prev_delivered,
281: x_return_status => l_api_return_status,
282: x_return_msg => l_api_return_msg);
283:
284: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
285: RAISE FND_API.G_EXC_ERROR;
286: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: END IF;

Line 285: RAISE FND_API.G_EXC_ERROR;

281: x_return_status => l_api_return_status,
282: x_return_msg => l_api_return_msg);
283:
284: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
285: RAISE FND_API.G_EXC_ERROR;
286: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: END IF;
289:

Line 286: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

282: x_return_msg => l_api_return_msg);
283:
284: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
285: RAISE FND_API.G_EXC_ERROR;
286: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: END IF;
289:
290: l_progress := 3;

Line 287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

283:
284: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
285: RAISE FND_API.G_EXC_ERROR;
286: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: END IF;
289:
290: l_progress := 3;
291:

Line 301: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN

297: x_wc_delivery => x_delivery,
298: x_return_status => l_api_return_status,
299: x_return_msg => l_api_return_msg);
300:
301: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
302: RAISE FND_API.G_EXC_ERROR;
303: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;

Line 302: RAISE FND_API.G_EXC_ERROR;

298: x_return_status => l_api_return_status,
299: x_return_msg => l_api_return_msg);
300:
301: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
302: RAISE FND_API.G_EXC_ERROR;
303: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306:

Line 303: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

299: x_return_msg => l_api_return_msg);
300:
301: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
302: RAISE FND_API.G_EXC_ERROR;
303: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306:
307: l_progress := 4;

Line 304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

300:
301: IF(l_api_return_status = FND_API.G_RET_STS_ERROR) THEN
302: RAISE FND_API.G_EXC_ERROR;
303: ELSIF (l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306:
307: l_progress := 4;
308:

Line 315: x_return_status := FND_API.G_RET_STS_SUCCESS;

311: IF(x_wc_status = 'APPROVED' or x_wc_status='PROCESSED' OR x_wc_status = 'CORRECTED') THEN
312: x_approved := x_total_requested;
313: END IF;
314:
315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316:
317: EXCEPTION
318:
319: WHEN FND_API.G_EXC_ERROR THEN

Line 319: WHEN FND_API.G_EXC_ERROR THEN

315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316:
317: EXCEPTION
318:
319: WHEN FND_API.G_EXC_ERROR THEN
320: x_return_status := FND_API.G_RET_STS_ERROR;
321: x_return_msg := l_api_return_msg;
322: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',
323: 'Expected error at stage: '|| l_progress);

Line 320: x_return_status := FND_API.G_RET_STS_ERROR;

316:
317: EXCEPTION
318:
319: WHEN FND_API.G_EXC_ERROR THEN
320: x_return_status := FND_API.G_RET_STS_ERROR;
321: x_return_msg := l_api_return_msg;
322: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',
323: 'Expected error at stage: '|| l_progress);
324: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',

Line 327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

323: 'Expected error at stage: '|| l_progress);
324: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',
325: 'Error: '|| l_api_return_msg);
326:
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: x_return_msg := 'Unexpected error at stage: '||l_progress||
330: ' '||l_api_return_msg;
331: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',

Line 328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

324: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',
325: 'Error: '|| l_api_return_msg);
326:
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: x_return_msg := 'Unexpected error at stage: '||l_progress||
330: ' '||l_api_return_msg;
331: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',
332: 'Unexpected error at stage: '|| l_progress);

Line 335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

331: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',
332: 'Unexpected error at stage: '|| l_progress);
333:
334: WHEN OTHERS THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: x_return_msg := 'Unexpected error in get_wc_info at stage: '|| l_progress;
337: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_info',
338: 'Unexpected error at stage: '|| l_progress);
339:

Line 463: x_return_status := FND_API.G_RET_STS_SUCCESS;

459: 'x_po_ordered: '|| x_po_ordered);
460: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_summary_info',
461: 'x_po_lines_ordered: '|| x_po_lines_ordered);
462:
463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464:
465:
466: EXCEPTION
467:

Line 469: x_return_status := FND_API.G_RET_STS_ERROR;

465:
466: EXCEPTION
467:
468: WHEN NO_PO_ID THEN
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: x_return_msg := 'Error in get_po_summary_info: No po_header_id';
471:
472: WHEN OTHERS THEN
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

469: x_return_status := FND_API.G_RET_STS_ERROR;
470: x_return_msg := 'Error in get_po_summary_info: No po_header_id';
471:
472: WHEN OTHERS THEN
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_prev_submitted',
475: 'Unexpected error occurred');
476:
477: END GET_PO_SUMMARY_INFO;

Line 588: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

584:
585: WHEN OTHERS THEN NULL;
586: LOG(FND_LOG.LEVEL_PROCEDURE,'get_po_summary_info',
587: 'Call to PO_DOCUMENT_TOTALS_PVT.get_order_totals not successful');
588: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589:
590: END GET_PO_INFO;
591:
592: -----------------------------------------------------------------------------

Line 763: x_return_status := FND_API.G_RET_STS_SUCCESS;

759: 'x_wc_prev_submitted: '|| x_wc_prev_submitted);
760: LOG(FND_LOG.LEVEL_PROCEDURE,'get_wc_prev_submitted',
761: 'x_wc_prev_delivered: '|| x_wc_prev_delivered);
762:
763: x_return_status := FND_API.G_RET_STS_SUCCESS;
764:
765: EXCEPTION
766:
767: WHEN OTHERS THEN

Line 768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

764:
765: EXCEPTION
766:
767: WHEN OTHERS THEN
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_prev_submitted',
770: 'Unexpected error occurred');
771:
772: END GET_WC_PREV_SUBMITTED;

Line 874: x_return_status := FND_API.G_RET_STS_SUCCESS;

870: x_wc_requested := l_requested;
871: x_wc_material := l_material;
872: x_wc_delivery := l_delivery;
873:
874: x_return_status := FND_API.G_RET_STS_SUCCESS;
875:
876: EXCEPTION
877:
878: WHEN OTHERS THEN

Line 879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

875:
876: EXCEPTION
877:
878: WHEN OTHERS THEN
879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
880: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_requested_and_material',
881: 'Unexpected error occurred');
882:
883: END GET_WC_REQUESTED_AND_MATERIAL;

Line 1121: x_return_status := FND_API.G_RET_STS_SUCCESS;

1117: END IF;
1118:
1119: END IF;
1120:
1121: x_return_status := FND_API.G_RET_STS_SUCCESS;
1122:
1123: EXCEPTION
1124:
1125: WHEN OTHERS THEN

Line 1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1122:
1123: EXCEPTION
1124:
1125: WHEN OTHERS THEN
1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1127: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_status',
1128: 'Unexpected error occurred');
1129:
1130: END GET_WC_STATUS;

Line 1313: IF(l_api_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1309: EXIT WHEN l_wc_pay_item_csr%NOTFOUND;
1310: CANCEL_WC_PAY_ITEM(l_shipment_line_id,
1311: l_api_return_status,
1312: l_api_return_msg);
1313: IF(l_api_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1314: RAISE CANCEL_PAY_ITEM_ERROR;
1315: END IF;
1316: END LOOP;
1317: CLOSE l_wc_pay_item_csr;

Line 1366: IF(l_api_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1362: x_return_status => l_api_return_status,
1363: x_return_msg => l_api_return_msg
1364: );
1365:
1366: IF(l_api_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1367: RAISE NOTIF_ERROR;
1368: END IF;
1369:
1370: END IF;

Line 1374: x_return_status := FND_API.G_RET_STS_SUCCESS;

1370: END IF;
1371:
1372: COMMIT;
1373:
1374: x_return_status := FND_API.G_RET_STS_SUCCESS;
1375:
1376: EXCEPTION
1377:
1378: WHEN CANCEL_PAY_ITEM_ERROR THEN

Line 1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1375:
1376: EXCEPTION
1377:
1378: WHEN CANCEL_PAY_ITEM_ERROR THEN
1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1380: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1381: 'Unexpected error occurred when cancelling pay item');
1382: WHEN NOTIF_ERROR THEN
1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1380: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1381: 'Unexpected error occurred when cancelling pay item');
1382: WHEN NOTIF_ERROR THEN
1383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1384: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1385: 'Unexpected error occurred when sending buyer a cancellation notification');
1386: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1387: 'Error Message: '||l_api_return_msg);

Line 1390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1386: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1387: 'Error Message: '||l_api_return_msg);
1388:
1389: WHEN OTHERS THEN
1390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1391: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1392: 'Unexpected error occurred');
1393:
1394:

Line 1778: x_return_status := FND_API.G_RET_STS_SUCCESS;

1774: X_TIMECARD_OVN => null,
1775: X_INTERFACE_AVAIL_AMT => null,
1776: X_INTERFACE_TRANS_AMT => null);
1777:
1778: x_return_status := FND_API.G_RET_STS_SUCCESS;
1779:
1780: EXCEPTION
1781: WHEN OTHERS then null;
1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1778: x_return_status := FND_API.G_RET_STS_SUCCESS;
1779:
1780: EXCEPTION
1781: WHEN OTHERS then null;
1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1783: END;
1784:
1785: -----------------------------------------------------------------------------
1786: --API name : DELETE_WC

Line 1880: x_return_status := FND_API.G_RET_STS_SUCCESS;

1876: DELETE FROM RCV_HEADERS_INTERFACE
1877: WHERE header_interface_id = l_header_interface_id;
1878:
1879: COMMIT;
1880: x_return_status := FND_API.G_RET_STS_SUCCESS;
1881:
1882: EXCEPTION
1883:
1884: WHEN OTHERS THEN

Line 1885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1881:
1882: EXCEPTION
1883:
1884: WHEN OTHERS THEN
1885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1886: LOG(FND_LOG.LEVEL_UNEXPECTED,'delete_wc',
1887: 'Unexpected error occurred');
1888:
1889: END DELETE_WC;

Line 1952: x_return_status := FND_API.G_RET_STS_SUCCESS;

1948:
1949: END LOOP;
1950: END IF;
1951:
1952: x_return_status := FND_API.G_RET_STS_SUCCESS;
1953:
1954: EXCEPTION
1955:
1956: WHEN OTHERS THEN

Line 1958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1954: EXCEPTION
1955:
1956: WHEN OTHERS THEN
1957:
1958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1959: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_approvers',
1960: 'Unexpected error occurred');
1961:
1962: END GET_WC_APPROVERS;