eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_WSH_INTERFACE_PKG dependencies on FND_API

Line 30: raise fnd_api.g_exc_unexpected_error;

26: WHEN OTHERS THEN
27: IF (g_asn_debug = 'Y') THEN
28: asn_debug.put_line('Unexpected exception in get_uom_from_code : ' || SQLERRM);
29: END IF;
30: raise fnd_api.g_exc_unexpected_error;
31: END get_uom_from_code;
32:
33: --RTV2 rtv project phase 2 : start
34: -- Get_return_lpn_id() function should not be used to fetch lpn_id after cancellation

Line 64: raise fnd_api.g_exc_unexpected_error;

60: WHEN OTHERS THEN
61: IF (g_asn_debug = 'Y') THEN
62: asn_debug.put_line('Unexpected exception in get_return_lpn_id : ' || SQLERRM);
63: END IF;
64: raise fnd_api.g_exc_unexpected_error;
65: END get_return_lpn_id;
66:
67: PROCEDURE unmark_wdd_lpn(p_wdd_rec IN wsh_delivery_details%rowtype,
68: p_lpn_id IN NUMBER DEFAULT NULL,

Line 112: raise fnd_api.g_exc_unexpected_error;

108: WHEN OTHERS THEN
109: IF (g_asn_debug = 'Y') THEN
110: asn_debug.put_line('Unexpected exception in unmark_wdd_lpn with lpn_id : '||l_lpn_id||', SQLERRM:' || SQLERRM);
111: END IF;
112: raise fnd_api.g_exc_unexpected_error;
113: END unmark_wdd_lpn;
114:
115: PROCEDURE remove_RTV_order
116: ( p_bkup_rti_id IN NUMBER) IS

Line 174: raise fnd_api.g_exc_unexpected_error;

170: WHEN OTHERS THEN
171: IF (g_asn_debug = 'Y') THEN
172: asn_debug.put_line('Unexpected exception in remove_RTV_order : ' || SQLERRM);
173: END IF;
174: raise fnd_api.g_exc_unexpected_error;
175: END remove_RTV_order;
176: --RTV2 rtv project phase 2 : end
177:
178: --

Line 231: , p_init_msg_lst => fnd_api.G_TRUE

227:
228: INV_Reservation_PUB.Create_Reservation
229: (
230: p_api_version_number => 1.0
231: , p_init_msg_lst => fnd_api.G_TRUE
232: , x_return_status => x_return_status --RTV2 rtv project phase 2
233: , x_msg_count => x_msg_count --RTV2 rtv project phase 2
234: , x_msg_data => x_msg_data --RTV2 rtv project phase 2
235: , p_rsv_rec => l_rsv_rec

Line 238: , p_partial_reservation_flag => fnd_api.g_true

234: , x_msg_data => x_msg_data --RTV2 rtv project phase 2
235: , p_rsv_rec => l_rsv_rec
236: , p_serial_number => l_dummy_sn
237: , x_serial_number => l_dummy_sn
238: , p_partial_reservation_flag => fnd_api.g_true
239: , p_force_reservation_flag => fnd_api.g_false
240: , p_validation_flag => fnd_api.g_true
241: , x_quantity_reserved => l_qty_succ_reserved
242: , x_reservation_id => l_org_wide_res_id

Line 239: , p_force_reservation_flag => fnd_api.g_false

235: , p_rsv_rec => l_rsv_rec
236: , p_serial_number => l_dummy_sn
237: , x_serial_number => l_dummy_sn
238: , p_partial_reservation_flag => fnd_api.g_true
239: , p_force_reservation_flag => fnd_api.g_false
240: , p_validation_flag => fnd_api.g_true
241: , x_quantity_reserved => l_qty_succ_reserved
242: , x_reservation_id => l_org_wide_res_id
243: );

Line 240: , p_validation_flag => fnd_api.g_true

236: , p_serial_number => l_dummy_sn
237: , x_serial_number => l_dummy_sn
238: , p_partial_reservation_flag => fnd_api.g_true
239: , p_force_reservation_flag => fnd_api.g_false
240: , p_validation_flag => fnd_api.g_true
241: , x_quantity_reserved => l_qty_succ_reserved
242: , x_reservation_id => l_org_wide_res_id
243: );
244:

Line 260: raise fnd_api.g_exc_unexpected_error;

256: WHEN OTHERS THEN
257: IF (g_asn_debug = 'Y') THEN
258: asn_debug.put_line('Unexpected exception in create_return_reservation : ' || SQLERRM);
259: END IF;
260: raise fnd_api.g_exc_unexpected_error;
261: END create_return_reservation;
262: --
263:
264: PROCEDURE relieve_return_reservation

Line 324: raise fnd_api.g_exc_unexpected_error;

320: WHEN OTHERS THEN
321: IF (g_asn_debug = 'Y') THEN
322: asn_debug.put_line('Unexpected exception in relieve_return_reservation : ' || SQLERRM);
323: END IF;
324: raise fnd_api.g_exc_unexpected_error;
325: END relieve_return_reservation;
326:
327: -- RTV2 rtv project phase 2 : start
328: PROCEDURE relieve_return_reservation

Line 345: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

341: x_return_status => l_return_status,
342: x_msg_count => l_msg_count,
343: x_msg_data => l_msg_data);
344:
345: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
346: raise fnd_api.g_exc_unexpected_error;
347: END IF;
348: EXCEPTION
349: WHEN OTHERS THEN

Line 346: raise fnd_api.g_exc_unexpected_error;

342: x_msg_count => l_msg_count,
343: x_msg_data => l_msg_data);
344:
345: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
346: raise fnd_api.g_exc_unexpected_error;
347: END IF;
348: EXCEPTION
349: WHEN OTHERS THEN
350: IF (g_asn_debug = 'Y') THEN

Line 353: raise fnd_api.g_exc_unexpected_error;

349: WHEN OTHERS THEN
350: IF (g_asn_debug = 'Y') THEN
351: asn_debug.put_line('Unexpected exception in relieve_return_reservation : ' || SQLERRM);
352: END IF;
353: raise fnd_api.g_exc_unexpected_error;
354: END relieve_return_reservation;
355: --
356: PROCEDURE rollback_rtp_fail( p_wdd_rec IN wsh_delivery_details%rowtype,
357: p_group_id IN NUMBER) IS

Line 393: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

389: p_lpn_id => l_lpn_id,
390: x_return_status => l_return_status,
391: x_msg_count => l_msg_count,
392: x_msg_data => l_msg_data);
393: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
394: raise fnd_api.g_exc_unexpected_error;
395: END IF;
396: END IF;
397:

Line 394: raise fnd_api.g_exc_unexpected_error;

390: x_return_status => l_return_status,
391: x_msg_count => l_msg_count,
392: x_msg_data => l_msg_data);
393: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
394: raise fnd_api.g_exc_unexpected_error;
395: END IF;
396: END IF;
397:
398: --unmark against new rti id

Line 410: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

406: p_lpn_id => l_lpn_id,
407: x_return_status => l_return_status,
408: x_msg_count => l_msg_count,
409: x_msg_data => l_msg_data);
410: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
411: raise fnd_api.g_exc_unexpected_error;
412: END IF;
413: END IF;
414: EXCEPTION

Line 411: raise fnd_api.g_exc_unexpected_error;

407: x_return_status => l_return_status,
408: x_msg_count => l_msg_count,
409: x_msg_data => l_msg_data);
410: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
411: raise fnd_api.g_exc_unexpected_error;
412: END IF;
413: END IF;
414: EXCEPTION
415: WHEN OTHERS THEN

Line 419: raise fnd_api.g_exc_unexpected_error;

415: WHEN OTHERS THEN
416: IF (g_asn_debug = 'Y') THEN
417: asn_debug.put_line('Unexpected exception in rollback_rtp_fail : ' || SQLERRM);
418: END IF;
419: raise fnd_api.g_exc_unexpected_error;
420: END;
421: --this procedure is used for RTV in receipt org only.
422: PROCEDURE marklpn_rtp_fail( p_group_id IN NUMBER) IS
423: CURSOR remark_lpns IS

Line 477: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

473: p_org_id => mark_rec.to_organization_id,
474: p_subinventory => mark_rec.from_subinventory,
475: p_locator_id => mark_rec.from_locator_id);
476:
477: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
478: asn_debug.put_line(' Could not remark lpn : ----> ' || mark_rec.transfer_lpn_id);
479: asn_debug.put_line(' Could not remark for item : ----> ' || mark_rec.item_id);
480: FOR i IN 1..l_msg_count LOOP
481: l_message := fnd_msg_pub.get(i, 'F');

Line 484: raise fnd_api.g_exc_unexpected_error;

480: FOR i IN 1..l_msg_count LOOP
481: l_message := fnd_msg_pub.get(i, 'F');
482: asn_debug.put_line(substr(l_message,1,255));
483: end LOOP;
484: raise fnd_api.g_exc_unexpected_error;
485: END IF;
486: END LOOP;
487: EXCEPTION
488: WHEN OTHERS THEN

Line 492: raise fnd_api.g_exc_unexpected_error;

488: WHEN OTHERS THEN
489: IF (g_asn_debug = 'Y') THEN
490: asn_debug.put_line('Unexpected exception in marklpn_rtp_fail : ' || SQLERRM);
491: END IF;
492: raise fnd_api.g_exc_unexpected_error;
493: END;
494: -- RTV2 rtv project phase 2 : end
495: /*===========================================================================
496:

Line 631: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

627:
628: l_progress := '040';
629: wsh_util_core.get_location_id ('ORG', p_return_org_id, l_wdd_tbl(1).ship_from_location_id, l_return_status);
630:
631: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
632: raise e_location_error;
633: END IF;
634:
635: l_progress := '050';

Line 772: p_init_msg_list => FND_API.G_TRUE,

768: END IF;
769:
770: wsh_interface_grp.create_update_delivery_detail
771: ( p_api_version_number => 1.0,
772: p_init_msg_list => FND_API.G_TRUE,
773: p_commit => NULL,
774: x_return_status => l_return_status,
775: x_msg_count => l_msg_count,
776: x_msg_data => l_msg_data,

Line 781: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

777: p_detail_info_tab => l_wdd_tbl,
778: p_IN_rec => l_IN_rec,
779: x_OUT_rec => l_OUT_rec );
780:
781: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
782: l_progress := '120';
783: raise e_wdd_creation_error;
784: END IF;
785:

Line 801: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

797: p_wdd_table => l_wdd_tbl);
798:
799: END IF;
800:
801: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
802: l_progress := '130';
803: raise e_con_wdd_creation_error;
804: END IF;
805:

Line 813: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

809: x_return_status => l_return_status,
810: x_msg_count => l_msg_count,
811: x_msg_data => l_msg_data);
812:
813: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
814: l_progress := '160';
815: raise e_mr_creation_error;
816: END IF;
817: l_wdd_tbl(1).delivery_detail_id := NULL;

Line 854: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

850: p_detail_info_tab => l_wdd_tbl,
851: p_IN_rec => l_IN_rec,
852: x_OUT_rec => l_OUT_rec );
853:
854: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
855: l_progress := '250';
856: raise e_wdd_creation_error;
857: END IF;
858:

Line 874: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

870: p_wdd_table => l_wdd_tbl);
871:
872: END IF;
873:
874: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
875: l_progress := '260';
876: raise e_con_wdd_creation_error;
877: END IF;
878:

Line 887: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

883: x_return_status => l_return_status,
884: x_msg_count => l_msg_count,
885: x_msg_data => l_msg_data);
886:
887: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
888: l_progress := '280';
889: raise e_mr_creation_error;
890: END IF;
891: l_wdd_tbl(1).delivery_detail_id := NULL;

Line 918: raise fnd_api.g_exc_error;

914: l_msg_data := fnd_msg_pub.get (x, 'F');
915: END LOOP;
916:
917: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);
918: raise fnd_api.g_exc_error;
919:
920: WHEN e_wdd_creation_error THEN
921: IF (g_asn_debug = 'Y') THEN
922: asn_debug.put_line('e_wdd_creation_error in create_delivery_details : ' || l_progress);

Line 926: raise fnd_api.g_exc_error;

922: asn_debug.put_line('e_wdd_creation_error in create_delivery_details : ' || l_progress);
923: END IF;
924: l_msg_data := fnd_msg_pub.get (1, 'F');
925: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);
926: raise fnd_api.g_exc_error;
927:
928: --RTV2 rtv project phase 2 : start
929: WHEN e_con_wdd_creation_error THEN
930: IF (g_asn_debug = 'Y') THEN

Line 942: raise fnd_api.g_exc_error;

938: FOR x IN 1 .. l_msg_count LOOP
939: l_msg_data := fnd_msg_pub.get (x, 'F');
940: END LOOP;
941: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);
942: raise fnd_api.g_exc_error;
943:
944: WHEN e_mr_creation_error THEN
945: IF (g_asn_debug = 'Y') THEN
946: asn_debug.put_line('e_mr_creation_error in create_delivery_details : ' || l_progress);

Line 957: raise fnd_api.g_exc_error;

953: FOR x IN 1 .. l_msg_count LOOP
954: l_msg_data := fnd_msg_pub.get (x, 'F');
955: END LOOP;
956: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', l_msg_data, sqlcode);
957: raise fnd_api.g_exc_error;
958: --RTV2 rtv project phase 2 : end
959:
960: WHEN OTHERS THEN
961: IF (g_asn_debug = 'Y') THEN

Line 966: raise fnd_api.g_exc_unexpected_error;

962: asn_debug.put_line('Unexpected exception in create_delivery_details : ' || SQLERRM);
963: asn_debug.put_line('l_progress : ' || l_progress);
964: END IF;
965: po_message_s.sql_error('rcv_wsh_interface_pkg.create_delivery_details', 'Unexpected exception', sqlcode);
966: raise fnd_api.g_exc_unexpected_error;
967: END create_delivery_details;
968:
969: /*===========================================================================
970:

Line 1515: p_init_msg_list => FND_API.G_TRUE,

1511:
1512: BEGIN
1513: l_status := inv_txn_manager_pub.process_transactions
1514: ( p_api_version => 1.0,
1515: p_init_msg_list => FND_API.G_TRUE,
1516: p_commit => FND_API.G_FALSE,
1517: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1518: x_return_status => l_return_status,
1519: x_msg_count => l_msg_count,

Line 1516: p_commit => FND_API.G_FALSE,

1512: BEGIN
1513: l_status := inv_txn_manager_pub.process_transactions
1514: ( p_api_version => 1.0,
1515: p_init_msg_list => FND_API.G_TRUE,
1516: p_commit => FND_API.G_FALSE,
1517: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1518: x_return_status => l_return_status,
1519: x_msg_count => l_msg_count,
1520: x_msg_data => l_msg_data,

Line 1517: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1513: l_status := inv_txn_manager_pub.process_transactions
1514: ( p_api_version => 1.0,
1515: p_init_msg_list => FND_API.G_TRUE,
1516: p_commit => FND_API.G_FALSE,
1517: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1518: x_return_status => l_return_status,
1519: x_msg_count => l_msg_count,
1520: x_msg_data => l_msg_data,
1521: x_trans_count => l_trans_count,

Line 1636: raise fnd_api.g_exc_unexpected_error;

1632: asn_debug.put_line('l_account_id : ' || l_account_id);
1633: END IF;
1634:
1635: IF (l_account_id IS NULL) THEN
1636: raise fnd_api.g_exc_unexpected_error;
1637: END IF;
1638: --
1639: SELECT currency_code, operating_unit
1640: INTO l_functional_currency, l_ou_id

Line 1660: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1656: x_return_status => l_return_status,
1657: x_msg_data => l_msg_data,
1658: x_msg_count => l_msg_count);
1659:
1660: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1661: raise fnd_api.g_exc_unexpected_error;
1662: END IF;
1663: END IF;
1664: IF (g_asn_debug = 'Y') THEN

Line 1661: raise fnd_api.g_exc_unexpected_error;

1657: x_msg_data => l_msg_data,
1658: x_msg_count => l_msg_count);
1659:
1660: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1661: raise fnd_api.g_exc_unexpected_error;
1662: END IF;
1663: END IF;
1664: IF (g_asn_debug = 'Y') THEN
1665: asn_debug.put_line('l_functional_currency : ' || l_functional_currency);

Line 1791: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1787: p_lpn_id => l_lpn_id,
1788: x_return_status => l_return_status,
1789: x_msg_count => l_msg_count,
1790: x_msg_data => l_msg_data);
1791: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1792: raise fnd_api.g_exc_unexpected_error;
1793: END IF;
1794: --RTV2 rtv project phase 2 : end
1795:

Line 1792: raise fnd_api.g_exc_unexpected_error;

1788: x_return_status => l_return_status,
1789: x_msg_count => l_msg_count,
1790: x_msg_data => l_msg_data);
1791: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1792: raise fnd_api.g_exc_unexpected_error;
1793: END IF;
1794: --RTV2 rtv project phase 2 : end
1795:
1796: IF (g_asn_debug = 'Y') THEN

Line 2182: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2178: p_lpn_id => rti_rec.transfer_lpn_id,
2179: x_return_status => l_return_status,
2180: x_msg_count => l_msg_count,
2181: x_msg_data => l_msg_data);
2182: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2183: raise fnd_api.g_exc_unexpected_error;
2184: END IF;
2185: END IF;
2186: --Re-mark lpn for new RTIs

Line 2183: raise fnd_api.g_exc_unexpected_error;

2179: x_return_status => l_return_status,
2180: x_msg_count => l_msg_count,
2181: x_msg_data => l_msg_data);
2182: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2183: raise fnd_api.g_exc_unexpected_error;
2184: END IF;
2185: END IF;
2186: --Re-mark lpn for new RTIs
2187: IF( rti_rec.transfer_lpn_id IS NOT NULL) THEN

Line 2205: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2201: p_org_id => rti_rec.to_organization_id,
2202: p_subinventory => l_from_subinventory,
2203: p_locator_id => l_from_locator_id);
2204:
2205: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2206: raise fnd_api.g_exc_unexpected_error;
2207: END IF;
2208: END IF;
2209: --RTV2 rtv project phase 2 : end

Line 2206: raise fnd_api.g_exc_unexpected_error;

2202: p_subinventory => l_from_subinventory,
2203: p_locator_id => l_from_locator_id);
2204:
2205: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2206: raise fnd_api.g_exc_unexpected_error;
2207: END IF;
2208: END IF;
2209: --RTV2 rtv project phase 2 : end
2210:

Line 2873: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2869: x_msg_count => l_msg_count,
2870: x_msg_data => l_msg_data,
2871: p_rcv_trx_interface_id => p_bkup_rti_id,
2872: p_ship_flag => l_ship_flag);
2873: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2874: raise e_WMS_post_Error;
2875: END IF;
2876: -- RTV project phase 2 : end
2877: --

Line 3131: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3127: p_lpn_id => l_lpn_id,
3128: x_return_status => l_return_status,
3129: x_msg_count => l_msg_count,
3130: x_msg_data => l_msg_data);
3131: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3132: raise e_cancel_unmark_lpn_error;
3133: END IF;
3134: --check if relevant contaienr wdd is fully cancelled , if yes, delete it.
3135: SELECT count(1)

Line 3146: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3142: END IF;
3143: wsh_container_actions.delete_containers
3144: (p_container_id => l_wdd_lpns(indx).lpn_wdd_id,
3145: x_return_status => l_return_status);
3146: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3147: raise e_cancel_lpn_wdd_error;
3148: END IF;
3149: END IF;
3150: EXIT;

Line 3161: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3157: p_lpn_id => l_lpn_id,
3158: x_return_status => l_return_status,
3159: x_msg_count => l_msg_count,
3160: x_msg_data => l_msg_data);
3161: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3162: raise e_cancel_MR_error;
3163: END IF;
3164: --RTV2 rtv project phase 2 : end
3165: END LOOP;

Line 3270: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3266: (x_return_status => l_return_status,
3267: x_msg_count => l_msg_count,
3268: x_msg_data => l_msg_data,
3269: p_rtv_order => l_rtv_order);
3270: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3271: raise e_cancel_unpack_lpn_error;
3272: END IF;
3273: END IF;
3274: --RTV project phase 2 : end

Line 3289: raise fnd_api.g_exc_error;

3285: asn_debug.put_line('wsh_integration.get_cancel_qty_allowed returned error!');
3286: END IF;
3287: l_msg_data := fnd_msg_pub.get (1, 'F');
3288: po_message_s.sql_error('wsh_integration.get_cancel_qty_allowed', l_msg_data, sqlcode);
3289: raise fnd_api.g_exc_error;
3290:
3291: WHEN e_cancel_error2 THEN
3292: IF (g_asn_debug = 'Y') THEN
3293: asn_debug.put_line('wsh_interface.update_shipping_attributes returned error!');

Line 3305: raise fnd_api.g_exc_error;

3301: l_msg_data := fnd_msg_pub.get (x, 'F');
3302: END LOOP;
3303:
3304: po_message_s.sql_error('wsh_interface.update_shipping_attributes', l_msg_data, sqlcode);
3305: raise fnd_api.g_exc_error;
3306: -- Bug 10089980 : End
3307: -- RTV project phase 2 : start
3308: WHEN e_cancel_MR_error THEN
3309: IF (g_asn_debug = 'Y') THEN

Line 3322: raise fnd_api.g_exc_error;

3318: l_msg_data := fnd_msg_pub.get (x, 'F');
3319: END LOOP;
3320:
3321: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);
3322: raise fnd_api.g_exc_error;
3323:
3324: WHEN e_cancel_unmark_lpn_error THEN
3325: IF (g_asn_debug = 'Y') THEN
3326: asn_debug.put_line('wms_return_sv.unmark_returns returned error!');

Line 3338: raise fnd_api.g_exc_error;

3334: l_msg_data := fnd_msg_pub.get (x, 'F');
3335: END LOOP;
3336:
3337: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);
3338: raise fnd_api.g_exc_error;
3339:
3340: WHEN e_cancel_unpack_lpn_error THEN
3341: IF (g_asn_debug = 'Y') THEN
3342: asn_debug.put_line('wms_return_sv.cancel_return_order_RTV returned error!');

Line 3354: raise fnd_api.g_exc_error;

3350: l_msg_data := fnd_msg_pub.get (x, 'F');
3351: END LOOP;
3352:
3353: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);
3354: raise fnd_api.g_exc_error;
3355:
3356: WHEN e_cancel_lpn_wdd_error THEN
3357: IF (g_asn_debug = 'Y') THEN
3358: asn_debug.put_line('whs_container_actions.delete_containers returned error!');

Line 3362: raise fnd_api.g_exc_error;

3358: asn_debug.put_line('whs_container_actions.delete_containers returned error!');
3359: END IF;
3360: l_msg_data := fnd_msg_pub.get (1, 'F');
3361: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', l_msg_data, sqlcode);
3362: raise fnd_api.g_exc_error;
3363: -- RTV project phase 2 : end
3364:
3365: WHEN OTHERS THEN
3366: IF (g_asn_debug = 'Y') THEN

Line 3370: raise fnd_api.g_exc_unexpected_error;

3366: IF (g_asn_debug = 'Y') THEN
3367: asn_debug.put_line('Unexpected exception in cancel_rtv_lines : ' || SQLERRM);
3368: END IF;
3369: po_message_s.sql_error('rcv_wsh_interface_pkg.cancel_rtv_lines', 'Unexpected exception', sqlcode);
3370: raise fnd_api.g_exc_unexpected_error;
3371: END cancel_rtv_lines;
3372:
3373: END RCV_WSH_INTERFACE_PKG;