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.WMS_WIP_XDOCK_PVT dependencies on FND_API

Line 116: l_return_status := fnd_api.g_ret_sts_success;

112:
113: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
114: l_tmp_line_id NUMBER;
115: BEGIN
116: l_return_status := fnd_api.g_ret_sts_success;
117:
118: IF (l_debug = 1) THEN
119: mydebug('In WIP crossdock check api...');
120: END IF;

Line 426: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

422: IF (l_debug = 1) THEN
423: mydebug('after calling mark_wip');
424: END IF;
425:
426: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
427: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
428: fnd_msg_pub.ADD;
429: RAISE fnd_api.g_exc_unexpected_error;
430: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 429: RAISE fnd_api.g_exc_unexpected_error;

425:
426: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
427: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
428: fnd_msg_pub.ADD;
429: RAISE fnd_api.g_exc_unexpected_error;
430: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
431: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
432: fnd_msg_pub.ADD;
433: RAISE fnd_api.g_exc_error;

Line 430: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

426: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
427: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
428: fnd_msg_pub.ADD;
429: RAISE fnd_api.g_exc_unexpected_error;
430: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
431: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
432: fnd_msg_pub.ADD;
433: RAISE fnd_api.g_exc_error;
434: ELSIF(l_return_status = 'L') THEN

Line 433: RAISE fnd_api.g_exc_error;

429: RAISE fnd_api.g_exc_unexpected_error;
430: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
431: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
432: fnd_msg_pub.ADD;
433: RAISE fnd_api.g_exc_error;
434: ELSIF(l_return_status = 'L') THEN
435: IF (l_debug = 1) THEN
436: mydebug('Unable to lock the record');
437: mydebug(' Getting next shortage ');

Line 507: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

503: , x_msg_data => l_msg_data
504: , x_line_id => l_tmp_line_id
505: );
506:
507: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
508: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
509: fnd_msg_pub.ADD;
510: RAISE fnd_api.g_exc_unexpected_error;
511: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 510: RAISE fnd_api.g_exc_unexpected_error;

506:
507: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
508: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
509: fnd_msg_pub.ADD;
510: RAISE fnd_api.g_exc_unexpected_error;
511: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
512: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
513: fnd_msg_pub.ADD;
514: RAISE fnd_api.g_exc_error;

Line 511: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

507: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
508: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
509: fnd_msg_pub.ADD;
510: RAISE fnd_api.g_exc_unexpected_error;
511: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
512: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
513: fnd_msg_pub.ADD;
514: RAISE fnd_api.g_exc_error;
515: END IF;

Line 514: RAISE fnd_api.g_exc_error;

510: RAISE fnd_api.g_exc_unexpected_error;
511: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
512: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
513: fnd_msg_pub.ADD;
514: RAISE fnd_api.g_exc_error;
515: END IF;
516: -- Need to fetch next del line
517: -- EXIT;
518: ELSIF l_lpn_qty < l_wip_qty THEN

Line 550: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

546: , p_primary_uom => l_primary_uom
547: , p_uom => l_uom
548: );
549:
550: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
551: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
552: fnd_msg_pub.ADD;
553: RAISE fnd_api.g_exc_unexpected_error;
554: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 553: RAISE fnd_api.g_exc_unexpected_error;

549:
550: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
551: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
552: fnd_msg_pub.ADD;
553: RAISE fnd_api.g_exc_unexpected_error;
554: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
555: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
556: fnd_msg_pub.ADD;
557: RAISE fnd_api.g_exc_error;

Line 554: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

550: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
551: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
552: fnd_msg_pub.ADD;
553: RAISE fnd_api.g_exc_unexpected_error;
554: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
555: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
556: fnd_msg_pub.ADD;
557: RAISE fnd_api.g_exc_error;
558: ELSIF(l_return_status = 'L') THEN

Line 557: RAISE fnd_api.g_exc_error;

553: RAISE fnd_api.g_exc_unexpected_error;
554: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
555: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
556: fnd_msg_pub.ADD;
557: RAISE fnd_api.g_exc_error;
558: ELSIF(l_return_status = 'L') THEN
559: IF (l_debug = 1) THEN
560: mydebug('Unable to lock the record');
561: mydebug(' Getting next shortage ');

Line 634: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

630: , x_msg_data => l_msg_data
631: , x_line_id => l_tmp_line_id
632: );
633:
634: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
635: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
636: fnd_msg_pub.ADD;
637: RAISE fnd_api.g_exc_unexpected_error;
638: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 637: RAISE fnd_api.g_exc_unexpected_error;

633:
634: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
635: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
636: fnd_msg_pub.ADD;
637: RAISE fnd_api.g_exc_unexpected_error;
638: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
639: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
640: fnd_msg_pub.ADD;
641: RAISE fnd_api.g_exc_error;

Line 638: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

634: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
635: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
636: fnd_msg_pub.ADD;
637: RAISE fnd_api.g_exc_unexpected_error;
638: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
639: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
640: fnd_msg_pub.ADD;
641: RAISE fnd_api.g_exc_error;
642: END IF;

Line 641: RAISE fnd_api.g_exc_error;

637: RAISE fnd_api.g_exc_unexpected_error;
638: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
639: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
640: fnd_msg_pub.ADD;
641: RAISE fnd_api.g_exc_error;
642: END IF;
643:
644: IF (l_debug = 1) THEN
645: mydebug(' exiting to get the next shortage ');

Line 708: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

704: , p_primary_uom => l_primary_uom
705: , p_uom => l_uom
706: );
707:
708: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
709: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
710: fnd_msg_pub.ADD;
711: RAISE fnd_api.g_exc_unexpected_error;
712: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 711: RAISE fnd_api.g_exc_unexpected_error;

707:
708: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
709: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
710: fnd_msg_pub.ADD;
711: RAISE fnd_api.g_exc_unexpected_error;
712: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
713: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
714: fnd_msg_pub.ADD;
715: RAISE fnd_api.g_exc_error;

Line 712: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

708: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
709: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
710: fnd_msg_pub.ADD;
711: RAISE fnd_api.g_exc_unexpected_error;
712: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
713: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
714: fnd_msg_pub.ADD;
715: RAISE fnd_api.g_exc_error;
716: ELSIF(l_return_status = 'L') THEN

Line 715: RAISE fnd_api.g_exc_error;

711: RAISE fnd_api.g_exc_unexpected_error;
712: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
713: fnd_message.set_name('WMS', 'WMS_TD_WIP_ERROR');
714: fnd_msg_pub.ADD;
715: RAISE fnd_api.g_exc_error;
716: ELSIF(l_return_status = 'L') THEN
717: IF (l_debug = 1) THEN
718: mydebug('Unable to lock the record');
719: mydebug(' Getting next shortage ');

Line 789: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

785: , x_msg_data => l_msg_data
786: , x_line_id => l_tmp_line_id
787: );
788:
789: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
790: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
791: fnd_msg_pub.ADD;
792: RAISE fnd_api.g_exc_unexpected_error;
793: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 792: RAISE fnd_api.g_exc_unexpected_error;

788:
789: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
790: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
791: fnd_msg_pub.ADD;
792: RAISE fnd_api.g_exc_unexpected_error;
793: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
794: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
795: fnd_msg_pub.ADD;
796: RAISE fnd_api.g_exc_error;

Line 793: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

789: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
790: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
791: fnd_msg_pub.ADD;
792: RAISE fnd_api.g_exc_unexpected_error;
793: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
794: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
795: fnd_msg_pub.ADD;
796: RAISE fnd_api.g_exc_error;
797: END IF;

Line 796: RAISE fnd_api.g_exc_error;

792: RAISE fnd_api.g_exc_unexpected_error;
793: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
794: fnd_message.set_name('WMS', 'WMS_TD_CMOL_ERROR');
795: fnd_msg_pub.ADD;
796: RAISE fnd_api.g_exc_error;
797: END IF;
798:
799: IF (l_debug = 1) THEN
800: mydebug(' exiting to get the next shortage ');

Line 831: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

827: wms_task_dispatch_put_away.crdk_wip_info_table(indx).operation_seq_num := l_operation_seq_num;
828: wms_task_dispatch_put_away.crdk_wip_info_table(indx).repetitive_schedule_id := l_repetitive_schedule_id;
829: wms_task_dispatch_put_away.crdk_wip_info_table(indx).wip_issue_flag := l_wip_issue_flag;
830:
831: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
832: fnd_message.set_name('WMS', 'WMS_TD_MK_DEL_ERROR');
833: fnd_msg_pub.ADD;
834: RAISE fnd_api.g_exc_unexpected_error;
835: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 834: RAISE fnd_api.g_exc_unexpected_error;

830:
831: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
832: fnd_message.set_name('WMS', 'WMS_TD_MK_DEL_ERROR');
833: fnd_msg_pub.ADD;
834: RAISE fnd_api.g_exc_unexpected_error;
835: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
836: fnd_message.set_name('WMS', 'WMS_TD_MK_DEL_ERROR');
837: fnd_msg_pub.ADD;
838: RAISE fnd_api.g_exc_error;

Line 835: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

831: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
832: fnd_message.set_name('WMS', 'WMS_TD_MK_DEL_ERROR');
833: fnd_msg_pub.ADD;
834: RAISE fnd_api.g_exc_unexpected_error;
835: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
836: fnd_message.set_name('WMS', 'WMS_TD_MK_DEL_ERROR');
837: fnd_msg_pub.ADD;
838: RAISE fnd_api.g_exc_error;
839: END IF;

Line 838: RAISE fnd_api.g_exc_error;

834: RAISE fnd_api.g_exc_unexpected_error;
835: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
836: fnd_message.set_name('WMS', 'WMS_TD_MK_DEL_ERROR');
837: fnd_msg_pub.ADD;
838: RAISE fnd_api.g_exc_error;
839: END IF;
840: -- Qty's match. Pick release the delivery detail
841: --l_lpn_qty:=0;
842: END IF;

Line 867: WHEN fnd_api.g_exc_error THEN

863:
864: x_ret := l_ret;
865: x_return_status := l_return_status;
866: EXCEPTION
867: WHEN fnd_api.g_exc_error THEN
868: x_ret := 2;
869: x_return_status := l_return_status;
870: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
871: WHEN fnd_api.g_exc_unexpected_error THEN

Line 871: WHEN fnd_api.g_exc_unexpected_error THEN

867: WHEN fnd_api.g_exc_error THEN
868: x_ret := 2;
869: x_return_status := l_return_status;
870: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
871: WHEN fnd_api.g_exc_unexpected_error THEN
872: x_ret := 2;
873: x_return_status := l_return_status;
874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
875: WHEN OTHERS THEN

Line 964: l_return_status := fnd_api.g_ret_sts_success;

960: WHERE transaction_temp_id = l_serial_temp_id;
961:
962: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
963: BEGIN
964: l_return_status := fnd_api.g_ret_sts_success;
965:
966: IF (l_debug = 1) THEN
967: mydebug('in WIP Complete cdock');
968: END IF;

Line 1187: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1183: IF (l_debug = 1) THEN
1184: mydebug('After Calling WIP txn proc STATUS' || x_return_status);
1185: END IF;
1186:
1187: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1188: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
1189: fnd_msg_pub.ADD;
1190: RAISE fnd_api.g_exc_unexpected_error;
1191: END IF;

Line 1190: RAISE fnd_api.g_exc_unexpected_error;

1186:
1187: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1188: fnd_message.set_name('WMS', 'WMS_TD_TXNMGR_ERROR');
1189: fnd_msg_pub.ADD;
1190: RAISE fnd_api.g_exc_unexpected_error;
1191: END IF;
1192: --Changed call above to WIP
1193: --l_txn_ret:=inv_lpn_trx_pub.PROCESS_LPN_TRX(p_trx_hdr_id=>l_new_txn_hdr_id,
1194: -- p_commit=> fnd_api.g_false,

Line 1194: -- p_commit=> fnd_api.g_false,

1190: RAISE fnd_api.g_exc_unexpected_error;
1191: END IF;
1192: --Changed call above to WIP
1193: --l_txn_ret:=inv_lpn_trx_pub.PROCESS_LPN_TRX(p_trx_hdr_id=>l_new_txn_hdr_id,
1194: -- p_commit=> fnd_api.g_false,
1195: --x_proc_msg =>l_msg_data
1196: -- );
1197: --mydebug('After Calling txn proc');
1198: --mydebug('l_txn_ret : ' || l_txn_ret);

Line 1205: -- RAISE FND_API.g_exc_unexpected_error;

1201: --COMMIT;
1202: --IF l_txn_ret<>0 THEN
1203: --FND_MESSAGE.SET_NAME('WMS','WMS_TD_TXNMGR_ERROR' );
1204: --fND_MSG_PUB.ADD;
1205: -- RAISE FND_API.g_exc_unexpected_error;
1206: --END IF;
1207: ELSE
1208: -- Bug 2829872, triggering label printing for Manufacturing Cross-Dock.
1209: BEGIN

Line 1254: x_return_status := fnd_api.g_ret_sts_success;

1250: -- transaction_status = 1
1251: -- WHERE transaction_temp_id = l_new_temp_id;
1252: END IF;
1253:
1254: x_return_status := fnd_api.g_ret_sts_success;
1255: EXCEPTION
1256: WHEN fnd_api.g_exc_error THEN
1257: x_return_status := fnd_api.g_ret_sts_error;
1258: -- Get message count and data

Line 1256: WHEN fnd_api.g_exc_error THEN

1252: END IF;
1253:
1254: x_return_status := fnd_api.g_ret_sts_success;
1255: EXCEPTION
1256: WHEN fnd_api.g_exc_error THEN
1257: x_return_status := fnd_api.g_ret_sts_error;
1258: -- Get message count and data
1259: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1260: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1257: x_return_status := fnd_api.g_ret_sts_error;

1253:
1254: x_return_status := fnd_api.g_ret_sts_success;
1255: EXCEPTION
1256: WHEN fnd_api.g_exc_error THEN
1257: x_return_status := fnd_api.g_ret_sts_error;
1258: -- Get message count and data
1259: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1260: WHEN fnd_api.g_exc_unexpected_error THEN
1261: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1260: WHEN fnd_api.g_exc_unexpected_error THEN

1256: WHEN fnd_api.g_exc_error THEN
1257: x_return_status := fnd_api.g_ret_sts_error;
1258: -- Get message count and data
1259: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1260: WHEN fnd_api.g_exc_unexpected_error THEN
1261: x_return_status := fnd_api.g_ret_sts_unexp_error;
1262: -- Get message count and data
1263: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1264: WHEN OTHERS THEN

Line 1261: x_return_status := fnd_api.g_ret_sts_unexp_error;

1257: x_return_status := fnd_api.g_ret_sts_error;
1258: -- Get message count and data
1259: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1260: WHEN fnd_api.g_exc_unexpected_error THEN
1261: x_return_status := fnd_api.g_ret_sts_unexp_error;
1262: -- Get message count and data
1263: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1264: WHEN OTHERS THEN
1265: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1265: x_return_status := fnd_api.g_ret_sts_unexp_error;

1261: x_return_status := fnd_api.g_ret_sts_unexp_error;
1262: -- Get message count and data
1263: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1264: WHEN OTHERS THEN
1265: x_return_status := fnd_api.g_ret_sts_unexp_error;
1266: fnd_message.set_name('WMS', 'WMS_TD_CCDOCK_ERROR');
1267: fnd_msg_pub.ADD;
1268: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1269: END wip_complete_crossdock;

Line 1347: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1343: IF (l_debug = 1) THEN
1344: mydebug('return status' || l_ret);
1345: END IF;
1346:
1347: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1348: fnd_message.set_name('WMS', 'WMS_TD_UPD_SHP_ERROR');
1349: fnd_msg_pub.ADD;
1350: RAISE fnd_api.g_exc_unexpected_error;
1351: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

Line 1350: RAISE fnd_api.g_exc_unexpected_error;

1346:
1347: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1348: fnd_message.set_name('WMS', 'WMS_TD_UPD_SHP_ERROR');
1349: fnd_msg_pub.ADD;
1350: RAISE fnd_api.g_exc_unexpected_error;
1351: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1352: fnd_message.set_name('WMS', 'WMS_TD_UPD_SHP_ERROR');
1353: fnd_msg_pub.ADD;
1354: RAISE fnd_api.g_exc_error;

Line 1351: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

1347: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1348: fnd_message.set_name('WMS', 'WMS_TD_UPD_SHP_ERROR');
1349: fnd_msg_pub.ADD;
1350: RAISE fnd_api.g_exc_unexpected_error;
1351: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1352: fnd_message.set_name('WMS', 'WMS_TD_UPD_SHP_ERROR');
1353: fnd_msg_pub.ADD;
1354: RAISE fnd_api.g_exc_error;
1355: END IF;

Line 1354: RAISE fnd_api.g_exc_error;

1350: RAISE fnd_api.g_exc_unexpected_error;
1351: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1352: fnd_message.set_name('WMS', 'WMS_TD_UPD_SHP_ERROR');
1353: fnd_msg_pub.ADD;
1354: RAISE fnd_api.g_exc_error;
1355: END IF;
1356:
1357: --x_ret:=l_ret;
1358: x_return_status := l_return_status;

Line 1373: WHEN fnd_api.g_exc_error THEN

1369:
1370: RETURN;
1371: END IF;
1372: EXCEPTION
1373: WHEN fnd_api.g_exc_error THEN
1374: x_return_status := fnd_api.g_ret_sts_error;
1375: --x_return_status:=l_return_status;
1376: -- Get message count and data
1377: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

Line 1374: x_return_status := fnd_api.g_ret_sts_error;

1370: RETURN;
1371: END IF;
1372: EXCEPTION
1373: WHEN fnd_api.g_exc_error THEN
1374: x_return_status := fnd_api.g_ret_sts_error;
1375: --x_return_status:=l_return_status;
1376: -- Get message count and data
1377: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1378: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1378: WHEN fnd_api.g_exc_unexpected_error THEN

1374: x_return_status := fnd_api.g_ret_sts_error;
1375: --x_return_status:=l_return_status;
1376: -- Get message count and data
1377: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1378: WHEN fnd_api.g_exc_unexpected_error THEN
1379: x_return_status := fnd_api.g_ret_sts_unexp_error;
1380: -- x_return_status:=l_return_status;
1381: -- Get message count and data
1382: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

Line 1379: x_return_status := fnd_api.g_ret_sts_unexp_error;

1375: --x_return_status:=l_return_status;
1376: -- Get message count and data
1377: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1378: WHEN fnd_api.g_exc_unexpected_error THEN
1379: x_return_status := fnd_api.g_ret_sts_unexp_error;
1380: -- x_return_status:=l_return_status;
1381: -- Get message count and data
1382: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1383: WHEN OTHERS THEN

Line 1384: x_return_status := fnd_api.g_ret_sts_unexp_error;

1380: -- x_return_status:=l_return_status;
1381: -- Get message count and data
1382: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1383: WHEN OTHERS THEN
1384: x_return_status := fnd_api.g_ret_sts_unexp_error;
1385: --x_return_status:=l_return_status;
1386: fnd_message.set_name('WMS', 'WMS_TD_MW_ERROR');
1387: fnd_msg_pub.ADD;
1388: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);