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') 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 1093: x_return_status := FND_API.G_RET_STS_SUCCESS;

1089: END IF;
1090:
1091: END IF;
1092:
1093: x_return_status := FND_API.G_RET_STS_SUCCESS;
1094:
1095: EXCEPTION
1096:
1097: WHEN OTHERS THEN

Line 1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1094:
1095: EXCEPTION
1096:
1097: WHEN OTHERS THEN
1098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1099: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_status',
1100: 'Unexpected error occurred');
1101:
1102: END GET_WC_STATUS;

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

1281: EXIT WHEN l_wc_pay_item_csr%NOTFOUND;
1282: CANCEL_WC_PAY_ITEM(l_shipment_line_id,
1283: l_api_return_status,
1284: l_api_return_msg);
1285: IF(l_api_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1286: RAISE CANCEL_PAY_ITEM_ERROR;
1287: END IF;
1288: END LOOP;
1289: CLOSE l_wc_pay_item_csr;

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

1324: x_return_status => l_api_return_status,
1325: x_return_msg => l_api_return_msg
1326: );
1327:
1328: IF(l_api_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1329: RAISE NOTIF_ERROR;
1330: END IF;
1331:
1332: END IF;

Line 1336: x_return_status := FND_API.G_RET_STS_SUCCESS;

1332: END IF;
1333:
1334: COMMIT;
1335:
1336: x_return_status := FND_API.G_RET_STS_SUCCESS;
1337:
1338: EXCEPTION
1339:
1340: WHEN CANCEL_PAY_ITEM_ERROR THEN

Line 1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1337:
1338: EXCEPTION
1339:
1340: WHEN CANCEL_PAY_ITEM_ERROR THEN
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1342: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1343: 'Unexpected error occurred when cancelling pay item');
1344: WHEN NOTIF_ERROR THEN
1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1342: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1343: 'Unexpected error occurred when cancelling pay item');
1344: WHEN NOTIF_ERROR THEN
1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1347: 'Unexpected error occurred when sending buyer a cancellation notification');
1348: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1349: 'Error Message: '||l_api_return_msg);

Line 1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1348: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1349: 'Error Message: '||l_api_return_msg);
1350:
1351: WHEN OTHERS THEN
1352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1353: LOG(FND_LOG.LEVEL_UNEXPECTED,'cancel_wc',
1354: 'Unexpected error occurred');
1355:
1356:

Line 1740: x_return_status := FND_API.G_RET_STS_SUCCESS;

1736: X_TIMECARD_OVN => null,
1737: X_INTERFACE_AVAIL_AMT => null,
1738: X_INTERFACE_TRANS_AMT => null);
1739:
1740: x_return_status := FND_API.G_RET_STS_SUCCESS;
1741:
1742: EXCEPTION
1743: WHEN OTHERS then null;
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1740: x_return_status := FND_API.G_RET_STS_SUCCESS;
1741:
1742: EXCEPTION
1743: WHEN OTHERS then null;
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1745: END;
1746:
1747: -----------------------------------------------------------------------------
1748: --API name : DELETE_WC

Line 1842: x_return_status := FND_API.G_RET_STS_SUCCESS;

1838: DELETE FROM RCV_HEADERS_INTERFACE
1839: WHERE header_interface_id = l_header_interface_id;
1840:
1841: COMMIT;
1842: x_return_status := FND_API.G_RET_STS_SUCCESS;
1843:
1844: EXCEPTION
1845:
1846: WHEN OTHERS THEN

Line 1847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1843:
1844: EXCEPTION
1845:
1846: WHEN OTHERS THEN
1847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1848: LOG(FND_LOG.LEVEL_UNEXPECTED,'delete_wc',
1849: 'Unexpected error occurred');
1850:
1851: END DELETE_WC;

Line 1914: x_return_status := FND_API.G_RET_STS_SUCCESS;

1910:
1911: END LOOP;
1912: END IF;
1913:
1914: x_return_status := FND_API.G_RET_STS_SUCCESS;
1915:
1916: EXCEPTION
1917:
1918: WHEN OTHERS THEN

Line 1920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1916: EXCEPTION
1917:
1918: WHEN OTHERS THEN
1919:
1920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1921: LOG(FND_LOG.LEVEL_UNEXPECTED,'get_wc_approvers',
1922: 'Unexpected error occurred');
1923:
1924: END GET_WC_APPROVERS;