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_RCV_PUP_PVT dependencies on FND_API

Line 394: RAISE fnd_api.g_exc_error;

390: WHEN OTHERS THEN
391: IF (l_debug = 1) THEN
392: print_debug('INSERT_LOT_SERIAL: ERROR - More than 1 row of MTLT associated with MMTT');
393: END IF;
394: RAISE fnd_api.g_exc_error;
395: END;
396:
397: l_transaction_temp_id := p_transaction_temp_id;
398:

Line 517: RAISE fnd_api.g_exc_error;

513: print_debug('INSERT_LOT_SERIAL: ERROR - insert_mtli Fail');
514: END IF;
515: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
516: fnd_msg_pub.ADD;
517: RAISE fnd_api.g_exc_error;
518: END IF;
519:
520: /* Check if there are msnt associated with this mtlt */
521: IF (l_serial_txn_tmp_id IS NOT NULL) THEN

Line 603: RAISE fnd_api.g_exc_error;

599: );
600: IF (x_return_status <> g_ret_sts_success) THEN
601: IF (l_debug = 1) THEN
602: print_debug('INSERT_LOT_SERIAL: ERROR- insert_msni Fail');
603: RAISE fnd_api.g_exc_error;
604: END IF;
605: END IF;
606: END LOOP;
607: END IF;

Line 703: RAISE fnd_api.g_exc_error;

699: print_debug('INSERT_LOT_SERIAL: ERROR - insert_msni Fail');
700: END IF;
701: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
702: fnd_msg_pub.ADD;
703: RAISE fnd_api.g_exc_error;
704: END IF;
705:
706: END LOOP;
707:

Line 711: WHEN fnd_api.g_exc_error THEN

707:
708: END IF;
709: RETURN l_intf_id;
710: EXCEPTION
711: WHEN fnd_api.g_exc_error THEN
712: x_return_status := fnd_api.g_ret_sts_error;
713: fnd_msg_pub.count_and_get
714: ( p_count => x_msg_count
715: ,p_data => x_msg_data );

Line 712: x_return_status := fnd_api.g_ret_sts_error;

708: END IF;
709: RETURN l_intf_id;
710: EXCEPTION
711: WHEN fnd_api.g_exc_error THEN
712: x_return_status := fnd_api.g_ret_sts_error;
713: fnd_msg_pub.count_and_get
714: ( p_count => x_msg_count
715: ,p_data => x_msg_data );
716: IF (l_debug = 1) THEN

Line 781: RAISE fnd_api.g_exc_error;

777: WHEN OTHERS THEN
778: IF (l_debug = 1) THEN
779: print_debug('ABORT_MMTTS: Unexpected Exception Raised in Bulk Select');
780: END IF;
781: RAISE fnd_api.g_exc_error;
782: END;
783: ELSIF (p_lpn_id IS NOT NULL) THEN
784:
785: IF (l_debug = 1) THEN

Line 824: RAISE fnd_api.g_exc_error;

820: WHEN OTHERS THEN
821: IF (l_debug = 1 ) THEN
822: print_debug('ABORT_MMTTS: Unexpected Exception Raised in Bulk Select');
823: END IF;
824: RAISE fnd_api.g_exc_error;
825: END;
826: END IF;
827:
828: print_debug('ABORT_MMTTS: count is:'|| l_txn_tmp_id_tb.COUNT);

Line 851: RAISE fnd_api.g_exc_error;

847: IF (x_return_status <> g_ret_sts_success) THEN
848: IF (l_debug = 1) THEN
849: print_debug('ABORT_MMTTS: ERROR - cancel_op_plan_instance fail with error code ' || l_error_code);
850: END IF;
851: RAISE fnd_api.g_exc_error;
852: END IF;
853:
854: END LOOP;
855:

Line 861: WHEN fnd_api.g_exc_error THEN

857: print_debug('ABORT_MMTTS: Quitting...');
858: END IF;
859:
860: EXCEPTION
861: WHEN fnd_api.g_exc_error THEN
862: x_return_status := fnd_api.g_ret_sts_error;
863: fnd_msg_pub.count_and_get
864: ( p_count => x_msg_count
865: ,p_data => x_msg_data );

Line 862: x_return_status := fnd_api.g_ret_sts_error;

858: END IF;
859:
860: EXCEPTION
861: WHEN fnd_api.g_exc_error THEN
862: x_return_status := fnd_api.g_ret_sts_error;
863: fnd_msg_pub.count_and_get
864: ( p_count => x_msg_count
865: ,p_data => x_msg_data );
866: IF (l_debug = 1) THEN

Line 903: ,p_call_rcv_tm IN VARCHAR2 DEFAULT fnd_api.g_true

899:
900: PROCEDURE pack_unpack_split
901: (p_transaction_temp_id IN NUMBER DEFAULT NULL
902: ,p_header_id IN NUMBER DEFAULT NULL
903: ,p_call_rcv_tm IN VARCHAR2 DEFAULT fnd_api.g_true
904: ,p_txn_mode_code IN VARCHAR2 DEFAULT g_default_txn_mode
905: ,x_return_status OUT NOCOPY VARCHAR2
906: ,x_msg_count OUT NOCOPY NUMBER
907: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1097: -- l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1093:
1094: l_receipt_count NUMBER := 0; -- Added for bug 14269755
1095: l_shipment_header_id NUMBER;
1096:
1097: -- l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1098: -- x_msg_count NUMBER;
1099: -- x_msg_data VARCHAR2(2400);
1100:
1101: BEGIN

Line 1121: RAISE fnd_api.g_exc_error;

1117: OPEN tmp_mmtt_cur_by_hdr_id(p_header_id);
1118: ELSE
1119: l_progress := '0.0.1';
1120: print_debug('PACK_UNPACK_SPLIT: Invalid parameter passed to API!');
1121: RAISE fnd_api.g_exc_error;
1122: END IF;
1123:
1124: LOOP
1125: IF (p_transaction_temp_id IS NOT NULL) THEN

Line 1228: RAISE fnd_api.g_exc_error;

1224: print_debug('PACK_UNPACK_SPLIT: abort_mmtts failed');
1225: END IF;
1226: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1227: fnd_msg_pub.ADD;
1228: RAISE fnd_api.g_exc_error;
1229: END IF;
1230: l_progress := '1.1.1';
1231:
1232: IF (l_debug = 1) THEN

Line 1261: RAISE fnd_api.g_exc_error;

1257: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_rti Fail');
1258: END IF;
1259: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1260: fnd_msg_pub.ADD;
1261: RAISE fnd_api.g_exc_error;
1262: END IF;
1263:
1264: l_progress := '1.1.2';
1265:

Line 1290: RAISE fnd_api.g_exc_error;

1286: IF (x_return_status <> g_ret_sts_success) THEN
1287: IF (l_debug = 1) THEN
1288: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_wlpni Fail');
1289: END IF;
1290: RAISE fnd_api.g_exc_error;
1291: END IF;
1292:
1293: l_progress := '1.1.3';
1294: IF (l_debug = 1) THEN

Line 1333: RAISE fnd_api.g_exc_error;

1329: print_debug('PACK_UNPACK_SPLIT: ERROR - Abort MMTTs Fail');
1330: END IF;
1331: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1332: fnd_msg_pub.ADD;
1333: RAISE fnd_api.g_exc_error;
1334: END IF;
1335:
1336: l_progress := '2.1.1';
1337: IF (l_debug = 1) THEN

Line 1365: RAISE fnd_api.g_exc_error;

1361: print_debug('ERROR: insert_rti Fail');
1362: END IF;
1363: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1364: fnd_msg_pub.ADD;
1365: RAISE fnd_api.g_exc_error;
1366: END IF;
1367:
1368: l_progress := '2.1.2';
1369:

Line 1395: RAISE fnd_api.g_exc_error;

1391: IF (x_return_status <> g_ret_sts_success) THEN
1392: IF (l_debug = 1) THEN
1393: print_debug('PACK_UNPACK_SPLIT: ERROR - Insert WLPN Fail');
1394: END IF;
1395: RAISE fnd_api.g_exc_error;
1396: END IF;
1397:
1398: l_progress := '2.1.3';
1399:

Line 1429: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

1425: ,p_subinventory => l_tmp_mmtt_rec.transfer_subinventory
1426: ,p_locator_id => l_tmp_mmtt_rec.transfer_to_location
1427: ,p_lpn_context => 3 --RCV
1428: );
1429: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1430: IF (l_debug = 1) THEN
1431: print_debug('PACK_UNPACK_SPLIT: modify_lpn failed');
1432: END IF;
1433: RAISE fnd_api.g_exc_error;

Line 1433: RAISE fnd_api.g_exc_error;

1429: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1430: IF (l_debug = 1) THEN
1431: print_debug('PACK_UNPACK_SPLIT: modify_lpn failed');
1432: END IF;
1433: RAISE fnd_api.g_exc_error;
1434: END IF;
1435:
1436: wms_container_pvt.packunpack_container
1437: (p_api_version => 1.0

Line 1452: RAISE fnd_api.g_exc_error;

1448: print_debug('PACK_UNPACK_SPLIT: ERROR - packunpack_container Fail');
1449: END IF;
1450: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_PACK_UPDATE_ERR');
1451: fnd_msg_pub.ADD;
1452: RAISE fnd_api.g_exc_error;
1453: END IF;
1454:
1455:
1456: l_progress := '2.2.1';

Line 1487: RAISE fnd_api.g_exc_error;

1483: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts Fail');
1484: END IF;
1485: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1486: fnd_msg_pub.ADD;
1487: RAISE fnd_api.g_exc_error;
1488: END IF;
1489:
1490: l_progress := '3.1.1';
1491: IF (l_debug = 1) THEN

Line 1519: RAISE fnd_api.g_exc_error;

1515: print_debug('ERROR: insert_rti Fail');
1516: END IF;
1517: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1518: fnd_msg_pub.ADD;
1519: RAISE fnd_api.g_exc_error;
1520: END IF;
1521:
1522: l_progress := '3.1.2';
1523:

Line 1552: RAISE fnd_api.g_exc_error;

1548: IF (x_return_status <> g_ret_sts_success) THEN
1549: IF (l_debug = 1) THEN
1550: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_wlpni Fail');
1551: END IF;
1552: RAISE fnd_api.g_exc_error;
1553: END IF;
1554:
1555: l_progress := '3.1.3';
1556:

Line 1591: RAISE fnd_api.g_exc_error;

1587: print_debug('PACK_UNPACK_SPLIT: packunpack_container Fail');
1588: END IF;
1589: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_UNPACK_UPDATE_ERR');
1590: fnd_msg_pub.ADD;
1591: RAISE fnd_api.g_exc_error;
1592: END IF;
1593:
1594: l_progress := '3.2.1';
1595: IF (l_debug = 1) THEN

Line 1622: RAISE fnd_api.g_exc_error;

1618: IF (x_return_status <> g_ret_sts_success) THEN
1619: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts Fail');
1620: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1621: fnd_msg_pub.ADD;
1622: RAISE fnd_api.g_exc_error;
1623: END IF;
1624:
1625: l_progress := '4.1.1';
1626: IF (l_debug = 1) THEN

Line 1654: RAISE fnd_api.g_exc_error;

1650: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_rti FAIL');
1651: END IF;
1652: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1653: fnd_msg_pub.ADD;
1654: RAISE fnd_api.g_exc_error;
1655: END IF;
1656:
1657: l_progress := '4.1.2';
1658: IF (l_debug = 1) THEN

Line 1688: RAISE fnd_api.g_exc_error;

1684: IF (x_return_status <> g_ret_sts_success) THEN
1685: IF (l_debug = 1) THEN
1686: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_wlpni FAIL');
1687: END IF;
1688: RAISE fnd_api.g_exc_error;
1689: END IF;
1690:
1691: l_progress := '4.1.3';
1692: IF (l_debug = 1) THEN

Line 1725: RAISE fnd_api.g_exc_error;

1721: print_debug('PACK_UNPACK_SPLIT: ERROR - packunpack_container Fail');
1722: END IF;
1723: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_UNPACK_UPDATE_ERR');
1724: fnd_msg_pub.ADD;
1725: RAISE fnd_api.g_exc_error;
1726: END IF;
1727:
1728: l_progress := '4.2.1';
1729: IF (l_debug = 1) THEN

Line 1749: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

1745: ,p_subinventory => l_tmp_mmtt_rec.transfer_subinventory
1746: ,p_locator_id => l_tmp_mmtt_rec.transfer_to_location
1747: ,p_lpn_context => 3 --RCV
1748: );
1749: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1750: IF (l_debug = 1) THEN
1751: print_debug('PACK_UNPACK_SPLIT: modify_lpn failed');
1752: END IF;
1753: RAISE fnd_api.g_exc_error;

Line 1753: RAISE fnd_api.g_exc_error;

1749: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1750: IF (l_debug = 1) THEN
1751: print_debug('PACK_UNPACK_SPLIT: modify_lpn failed');
1752: END IF;
1753: RAISE fnd_api.g_exc_error;
1754: END IF;
1755:
1756: wms_container_pvt.packunpack_container
1757: (p_api_version => '1.0' --??

Line 1772: RAISE fnd_api.g_exc_error;

1768: print_debug('PACK_UNPACK_SPLIT: ERROR: packunpack_container Fail', 9);
1769: END IF;
1770: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_PACK_UPDATE_ERR');
1771: fnd_msg_pub.ADD;
1772: RAISE fnd_api.g_exc_error;
1773: END IF;
1774:
1775: l_progress := '2.2.1';
1776: IF (l_debug = 1) THEN

Line 1801: RAISE fnd_api.g_exc_error;

1797: print_debug('PACK_UNPACK_SPLIT: ERROR: abort_mmtts FAIL', 9);
1798: END IF;
1799: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1800: fnd_msg_pub.ADD;
1801: RAISE fnd_api.g_exc_error;
1802: END IF;
1803:
1804: l_mo_splt_tb(1).prim_qty := l_tmp_mmtt_rec.primary_quantity;
1805:

Line 1826: RAISE fnd_api.g_exc_error;

1822: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL', 9);
1823: END IF;
1824: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
1825: fnd_msg_pub.ADD;
1826: RAISE fnd_api.g_exc_error;
1827: END IF;
1828:
1829: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN
1830: IF (l_debug = 1) THEN

Line 1866: RAISE fnd_api.g_exc_error;

1862: IF (l_debug = 1) THEN
1863: print_debug('PACK_UNPACK_SPLIT: ERROR: insert_lot_serial FAIL',
1864: 9);
1865: END IF;
1866: RAISE fnd_api.g_exc_error;
1867: END IF;
1868:
1869: l_progress := '5.2';
1870:

Line 1950: RAISE fnd_api.g_exc_error;

1946: IF (x_return_status <> g_ret_sts_success) THEN
1947: IF (l_debug = 1) THEN
1948: print_debug('PACK_UNPACK_SPLIT: ERROR - Match_transfer_rcvtxn_rec FAIL', 9);
1949: END IF;
1950: RAISE fnd_api.g_exc_error;
1951: END IF;
1952:
1953: l_progress := '5.4';
1954:

Line 1991: RAISE fnd_api.g_exc_error;

1987: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL', 9);
1988: END IF;
1989: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
1990: fnd_msg_pub.ADD;
1991: RAISE fnd_api.g_exc_error;
1992: END IF;
1993:
1994: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN
1995: IF (l_debug = 1) THEN

Line 2033: RAISE fnd_api.g_exc_error;

2029: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts FAIL', 9);
2030: END IF;
2031: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
2032: fnd_msg_pub.ADD;
2033: RAISE fnd_api.g_exc_error;
2034: END IF;
2035:
2036: l_progress := '6.1.3';
2037:

Line 2057: RAISE fnd_api.g_exc_error;

2053: IF (x_return_status <> g_ret_sts_success) THEN
2054: IF (l_debug = 1) THEN
2055: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_lot_serial FAIL', 9);
2056: END IF;
2057: RAISE fnd_api.g_exc_error;
2058: END IF;
2059:
2060: l_progress := '6.1.4';
2061:

Line 2135: RAISE fnd_api.g_exc_error;

2131: IF (x_return_status <> g_ret_sts_success) THEN
2132: IF (l_debug = 1) THEN
2133: print_debug('ERROR: Match_transfer_rcvtxn_rec FAIL', 9);
2134: END IF;
2135: RAISE fnd_api.g_exc_error;
2136: END IF;
2137:
2138: -- Set flag to call to TM
2139: l_call_rm := TRUE;

Line 2174: RAISE fnd_api.g_exc_error;

2170: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL', 9);
2171: END IF;
2172: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
2173: fnd_msg_pub.ADD;
2174: RAISE fnd_api.g_exc_error;
2175: END IF;
2176:
2177: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN
2178: IF (l_debug = 1) THEN

Line 2222: RAISE fnd_api.g_exc_error;

2218: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts FAIL', 9);
2219: END IF;
2220: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
2221: fnd_msg_pub.ADD;
2222: RAISE fnd_api.g_exc_error;
2223: END IF;
2224:
2225: l_progress := '6.2.2.5';
2226:

Line 2249: RAISE fnd_api.g_exc_error;

2245: IF (x_return_status <> g_ret_sts_success) THEN
2246: IF (l_debug = 1) THEN
2247: print_debug('ERROR: insert_lot_serial FAIL', 9);
2248: END IF;
2249: RAISE fnd_api.g_exc_error;
2250: END IF;
2251:
2252: l_progress := '6.2.3';
2253:

Line 2362: RAISE fnd_api.g_exc_error;

2358: IF (x_return_status <> g_ret_sts_success) THEN
2359: IF (l_debug = 1) THEN
2360: print_debug('ERROR: split_lot_serial FAIL', 9);
2361: END IF;
2362: RAISE fnd_api.g_exc_error;
2363: END IF;
2364:
2365: l_progress := '6.2.8';
2366:

Line 2430: RAISE fnd_api.g_exc_error;

2426: IF (l_debug = 1) THEN
2427: print_debug('PACK_UNPACK_SPLIT : ERROR - Match_transfer_rcvtxn_rec FAIL',
2428: 9);
2429: END IF;
2430: RAISE fnd_api.g_exc_error;
2431: END IF;
2432:
2433: l_progress := '6.2.9';
2434:

Line 2518: RAISE fnd_api.g_exc_error;

2514: IF (l_debug = 1) THEN
2515: print_debug('PACK_UNPACK_SPLIT: ERROR - Match_transfer_rcvtxn_rec FAIL',
2516: 9);
2517: END IF;
2518: RAISE fnd_api.g_exc_error;
2519: END IF;
2520:
2521: END IF; -- End remaining qty check
2522:

Line 2602: RAISE fnd_api.g_exc_error;

2598: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL');
2599: END IF;
2600: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
2601: fnd_msg_pub.ADD;
2602: RAISE fnd_api.g_exc_error;
2603: END IF;
2604:
2605: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN
2606: IF (l_debug = 1) THEN

Line 2648: RAISE fnd_api.g_exc_error;

2644: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts FAIL');
2645: END IF;
2646: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
2647: fnd_msg_pub.ADD;
2648: RAISE fnd_api.g_exc_error;
2649: END IF;
2650:
2651: l_progress := '7.1.3';
2652:

Line 2669: RAISE fnd_api.g_exc_error;

2665: IF (x_return_status <> g_ret_sts_success) THEN
2666: IF (l_debug = 1) THEN
2667: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_lot_serial FAIL', 9);
2668: END IF;
2669: RAISE fnd_api.g_exc_error;
2670: END IF;
2671:
2672: l_progress := '7.1.4';
2673: IF (l_debug = 1) THEN

Line 2723: RAISE fnd_api.g_exc_error;

2719: IF (x_return_status <> g_ret_sts_success) THEN
2720: IF (l_debug = 1) THEN
2721: print_debug('PACK_UNPACK_SPLIT: ERROR - Match_transfer_rcvtxn_rec FAIL');
2722: END IF;
2723: RAISE fnd_api.g_exc_error;
2724: END IF;
2725:
2726: l_progress := '7.1.6';
2727:

Line 2764: RAISE fnd_api.g_exc_error;

2760: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL');
2761: END IF;
2762: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
2763: fnd_msg_pub.ADD;
2764: RAISE fnd_api.g_exc_error;
2765: END IF;
2766:
2767: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN
2768: IF (l_debug = 1) THEN

Line 2805: RAISE fnd_api.g_exc_error;

2801: IF (x_return_status <> g_ret_sts_success) THEN
2802: IF (l_debug = 1) THEN
2803: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_lot_serail FAIL');
2804: END IF;
2805: RAISE fnd_api.g_exc_error;
2806: END IF;
2807:
2808: l_progress := '7.2.4';
2809: OPEN mol_cur(l_tmp_mmtt_rec.move_order_line_id);

Line 2914: RAISE fnd_api.g_exc_error;

2910: IF (x_return_status <> g_ret_sts_success) THEN
2911: IF (l_debug = 1) THEN
2912: print_debug('PACK_UNPACK_SPLIT: ERROR - split_lot_serial FAIL', 9);
2913: END IF;
2914: RAISE fnd_api.g_exc_error;
2915: END IF;
2916: l_progress := '7.2.8';
2917:
2918: IF l_mmtt_rec.transaction_uom <> l_tmp_mmtt_rec.transaction_uom THEN

Line 2971: RAISE fnd_api.g_exc_error;

2967: IF (l_debug = 1) THEN
2968: print_debug('PACK_UNPACK_SPLIT: ERROR - Match_transfer_rcvtxn_rec FAIL',
2969: 9);
2970: END IF;
2971: RAISE fnd_api.g_exc_error;
2972: END IF;
2973: l_progress := '7.2.8';
2974:
2975: END LOOP;

Line 3026: RAISE fnd_api.g_exc_error;

3022: IF (x_return_status <> g_ret_sts_success) THEN
3023: IF (l_debug = 1) THEN
3024: print_debug('PAC_UNPACK_SPLIT: ERROR - 1 Match_transfer_rcvtxn_rec FAIL');
3025: END IF;
3026: RAISE fnd_api.g_exc_error;
3027: END IF;
3028: END IF;
3029:
3030: l_progress := '7.2.11';

Line 3042: RAISE fnd_api.g_exc_error;

3038: END IF; -- End sub/loc test
3039: ELSE
3040: fnd_message.set_name('INV', 'INV_INVALID_TXN_TYPE');
3041: fnd_msg_pub.ADD;
3042: RAISE fnd_api.g_exc_error;
3043: END IF; -- End txn_type test
3044:
3045:
3046: END LOOP; -- End tmp_mmtt_cur loop

Line 3077: RAISE fnd_api.g_exc_error;

3073: WHEN OTHERS THEN
3074: IF (l_debug = 1) THEN
3075: print_debug('Error deleting temp MSNTs');
3076: END IF;
3077: RAISE fnd_api.g_exc_error;
3078: END;
3079:
3080: BEGIN
3081: forall i IN 1 .. l_mmtts_count

Line 3092: RAISE fnd_api.g_exc_error;

3088: WHEN OTHERS THEN
3089: IF (l_debug = 1) THEN
3090: print_debug('Error deleting temp MTLTs');
3091: END IF;
3092: RAISE fnd_api.g_exc_error;
3093: END;
3094:
3095: BEGIN
3096: forall i IN 1 .. l_mmtts_count

Line 3107: RAISE fnd_api.g_exc_error;

3103: WHEN OTHERS THEN
3104: IF (l_debug =1 )THEN
3105: print_debug('Error deleting temp MMTTs');
3106: END IF;
3107: RAISE fnd_api.g_exc_error;
3108: END;
3109:
3110: --Added for bug 14269755
3111: BEGIN

Line 3127: IF (l_call_rm = TRUE AND p_call_rcv_tm = fnd_api.g_true) THEN

3123: END;
3124:
3125: COMMIT; --Need to commit the delete
3126:
3127: IF (l_call_rm = TRUE AND p_call_rcv_tm = fnd_api.g_true) THEN
3128: IF (l_debug = 1) THEN
3129: print_debug('Calling Receiving TM');
3130: END IF;
3131:

Line 3168: WHEN fnd_api.g_exc_unexpected_error THEN

3164:
3165: x_mo_lines_tb := l_out_mo_splt_tb;
3166:
3167: EXCEPTION
3168: WHEN fnd_api.g_exc_unexpected_error THEN
3169: IF (l_debug = 1) THEN
3170: print_debug('PACK_UNPACK_SPLIT: Unexpected Exception occured after progress: '
3171: || l_progress);
3172: END IF;