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 1094: -- l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1090: TYPE number_tb_tp IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1091: l_mmtt_ids number_tb_tp;
1092: l_mmtts_count NUMBER := 0;
1093:
1094: -- l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1095: -- x_msg_count NUMBER;
1096: -- x_msg_data VARCHAR2(2400);
1097:
1098: BEGIN

Line 1118: RAISE fnd_api.g_exc_error;

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

Line 1188: RAISE fnd_api.g_exc_error;

1184: print_debug('PACK_UNPACK_SPLIT: abort_mmtts failed');
1185: END IF;
1186: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1187: fnd_msg_pub.ADD;
1188: RAISE fnd_api.g_exc_error;
1189: END IF;
1190: l_progress := '1.1.1';
1191:
1192: IF (l_debug = 1) THEN

Line 1221: RAISE fnd_api.g_exc_error;

1217: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_rti Fail');
1218: END IF;
1219: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1220: fnd_msg_pub.ADD;
1221: RAISE fnd_api.g_exc_error;
1222: END IF;
1223:
1224: l_progress := '1.1.2';
1225:

Line 1250: RAISE fnd_api.g_exc_error;

1246: IF (x_return_status <> g_ret_sts_success) THEN
1247: IF (l_debug = 1) THEN
1248: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_wlpni Fail');
1249: END IF;
1250: RAISE fnd_api.g_exc_error;
1251: END IF;
1252:
1253: l_progress := '1.1.3';
1254: IF (l_debug = 1) THEN

Line 1293: RAISE fnd_api.g_exc_error;

1289: print_debug('PACK_UNPACK_SPLIT: ERROR - Abort MMTTs Fail');
1290: END IF;
1291: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1292: fnd_msg_pub.ADD;
1293: RAISE fnd_api.g_exc_error;
1294: END IF;
1295:
1296: l_progress := '2.1.1';
1297: IF (l_debug = 1) THEN

Line 1325: RAISE fnd_api.g_exc_error;

1321: print_debug('ERROR: insert_rti Fail');
1322: END IF;
1323: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1324: fnd_msg_pub.ADD;
1325: RAISE fnd_api.g_exc_error;
1326: END IF;
1327:
1328: l_progress := '2.1.2';
1329:

Line 1355: RAISE fnd_api.g_exc_error;

1351: IF (x_return_status <> g_ret_sts_success) THEN
1352: IF (l_debug = 1) THEN
1353: print_debug('PACK_UNPACK_SPLIT: ERROR - Insert WLPN Fail');
1354: END IF;
1355: RAISE fnd_api.g_exc_error;
1356: END IF;
1357:
1358: l_progress := '2.1.3';
1359:

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

1385: ,p_subinventory => l_tmp_mmtt_rec.transfer_subinventory
1386: ,p_locator_id => l_tmp_mmtt_rec.transfer_to_location
1387: ,p_lpn_context => 3 --RCV
1388: );
1389: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1390: IF (l_debug = 1) THEN
1391: print_debug('PACK_UNPACK_SPLIT: modify_lpn failed');
1392: END IF;
1393: RAISE fnd_api.g_exc_error;

Line 1393: RAISE fnd_api.g_exc_error;

1389: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1390: IF (l_debug = 1) THEN
1391: print_debug('PACK_UNPACK_SPLIT: modify_lpn failed');
1392: END IF;
1393: RAISE fnd_api.g_exc_error;
1394: END IF;
1395:
1396: wms_container_pvt.packunpack_container
1397: (p_api_version => 1.0

Line 1412: RAISE fnd_api.g_exc_error;

1408: print_debug('PACK_UNPACK_SPLIT: ERROR - packunpack_container Fail');
1409: END IF;
1410: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_PACK_UPDATE_ERR');
1411: fnd_msg_pub.ADD;
1412: RAISE fnd_api.g_exc_error;
1413: END IF;
1414:
1415:
1416: l_progress := '2.2.1';

Line 1447: RAISE fnd_api.g_exc_error;

1443: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts Fail');
1444: END IF;
1445: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1446: fnd_msg_pub.ADD;
1447: RAISE fnd_api.g_exc_error;
1448: END IF;
1449:
1450: l_progress := '3.1.1';
1451: IF (l_debug = 1) THEN

Line 1479: RAISE fnd_api.g_exc_error;

1475: print_debug('ERROR: insert_rti Fail');
1476: END IF;
1477: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1478: fnd_msg_pub.ADD;
1479: RAISE fnd_api.g_exc_error;
1480: END IF;
1481:
1482: l_progress := '3.1.2';
1483:

Line 1512: RAISE fnd_api.g_exc_error;

1508: IF (x_return_status <> g_ret_sts_success) THEN
1509: IF (l_debug = 1) THEN
1510: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_wlpni Fail');
1511: END IF;
1512: RAISE fnd_api.g_exc_error;
1513: END IF;
1514:
1515: l_progress := '3.1.3';
1516:

Line 1551: RAISE fnd_api.g_exc_error;

1547: print_debug('PACK_UNPACK_SPLIT: packunpack_container Fail');
1548: END IF;
1549: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_UNPACK_UPDATE_ERR');
1550: fnd_msg_pub.ADD;
1551: RAISE fnd_api.g_exc_error;
1552: END IF;
1553:
1554: l_progress := '3.2.1';
1555: IF (l_debug = 1) THEN

Line 1582: RAISE fnd_api.g_exc_error;

1578: IF (x_return_status <> g_ret_sts_success) THEN
1579: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts Fail');
1580: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1581: fnd_msg_pub.ADD;
1582: RAISE fnd_api.g_exc_error;
1583: END IF;
1584:
1585: l_progress := '4.1.1';
1586: IF (l_debug = 1) THEN

Line 1614: RAISE fnd_api.g_exc_error;

1610: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_rti FAIL');
1611: END IF;
1612: FND_MESSAGE.SET_NAME('INV','INV_CANNOT_INSERT');
1613: fnd_msg_pub.ADD;
1614: RAISE fnd_api.g_exc_error;
1615: END IF;
1616:
1617: l_progress := '4.1.2';
1618: IF (l_debug = 1) THEN

Line 1648: RAISE fnd_api.g_exc_error;

1644: IF (x_return_status <> g_ret_sts_success) THEN
1645: IF (l_debug = 1) THEN
1646: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_wlpni FAIL');
1647: END IF;
1648: RAISE fnd_api.g_exc_error;
1649: END IF;
1650:
1651: l_progress := '4.1.3';
1652: IF (l_debug = 1) THEN

Line 1685: RAISE fnd_api.g_exc_error;

1681: print_debug('PACK_UNPACK_SPLIT: ERROR - packunpack_container Fail');
1682: END IF;
1683: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_UNPACK_UPDATE_ERR');
1684: fnd_msg_pub.ADD;
1685: RAISE fnd_api.g_exc_error;
1686: END IF;
1687:
1688: l_progress := '4.2.1';
1689: IF (l_debug = 1) THEN

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

1705: ,p_subinventory => l_tmp_mmtt_rec.transfer_subinventory
1706: ,p_locator_id => l_tmp_mmtt_rec.transfer_to_location
1707: ,p_lpn_context => 3 --RCV
1708: );
1709: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1710: IF (l_debug = 1) THEN
1711: print_debug('PACK_UNPACK_SPLIT: modify_lpn failed');
1712: END IF;
1713: RAISE fnd_api.g_exc_error;

Line 1713: RAISE fnd_api.g_exc_error;

1709: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1710: IF (l_debug = 1) THEN
1711: print_debug('PACK_UNPACK_SPLIT: modify_lpn failed');
1712: END IF;
1713: RAISE fnd_api.g_exc_error;
1714: END IF;
1715:
1716: wms_container_pvt.packunpack_container
1717: (p_api_version => '1.0' --??

Line 1732: RAISE fnd_api.g_exc_error;

1728: print_debug('PACK_UNPACK_SPLIT: ERROR: packunpack_container Fail', 9);
1729: END IF;
1730: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_PACK_UPDATE_ERR');
1731: fnd_msg_pub.ADD;
1732: RAISE fnd_api.g_exc_error;
1733: END IF;
1734:
1735: l_progress := '2.2.1';
1736: IF (l_debug = 1) THEN

Line 1761: RAISE fnd_api.g_exc_error;

1757: print_debug('PACK_UNPACK_SPLIT: ERROR: abort_mmtts FAIL', 9);
1758: END IF;
1759: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1760: fnd_msg_pub.ADD;
1761: RAISE fnd_api.g_exc_error;
1762: END IF;
1763:
1764: l_mo_splt_tb(1).prim_qty := l_tmp_mmtt_rec.primary_quantity;
1765:

Line 1786: RAISE fnd_api.g_exc_error;

1782: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL', 9);
1783: END IF;
1784: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
1785: fnd_msg_pub.ADD;
1786: RAISE fnd_api.g_exc_error;
1787: END IF;
1788:
1789: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN
1790: IF (l_debug = 1) THEN

Line 1826: RAISE fnd_api.g_exc_error;

1822: IF (l_debug = 1) THEN
1823: print_debug('PACK_UNPACK_SPLIT: ERROR: insert_lot_serial FAIL',
1824: 9);
1825: END IF;
1826: RAISE fnd_api.g_exc_error;
1827: END IF;
1828:
1829: l_progress := '5.2';
1830:

Line 1909: RAISE fnd_api.g_exc_error;

1905: IF (x_return_status <> g_ret_sts_success) THEN
1906: IF (l_debug = 1) THEN
1907: print_debug('PACK_UNPACK_SPLIT: ERROR - Match_transfer_rcvtxn_rec FAIL', 9);
1908: END IF;
1909: RAISE fnd_api.g_exc_error;
1910: END IF;
1911:
1912: l_progress := '5.4';
1913:

Line 1950: RAISE fnd_api.g_exc_error;

1946: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL', 9);
1947: END IF;
1948: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
1949: fnd_msg_pub.ADD;
1950: RAISE fnd_api.g_exc_error;
1951: END IF;
1952:
1953: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN
1954: IF (l_debug = 1) THEN

Line 1992: RAISE fnd_api.g_exc_error;

1988: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts FAIL', 9);
1989: END IF;
1990: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
1991: fnd_msg_pub.ADD;
1992: RAISE fnd_api.g_exc_error;
1993: END IF;
1994:
1995: l_progress := '6.1.3';
1996:

Line 2016: RAISE fnd_api.g_exc_error;

2012: IF (x_return_status <> g_ret_sts_success) THEN
2013: IF (l_debug = 1) THEN
2014: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_lot_serial FAIL', 9);
2015: END IF;
2016: RAISE fnd_api.g_exc_error;
2017: END IF;
2018:
2019: l_progress := '6.1.4';
2020:

Line 2093: RAISE fnd_api.g_exc_error;

2089: IF (x_return_status <> g_ret_sts_success) THEN
2090: IF (l_debug = 1) THEN
2091: print_debug('ERROR: Match_transfer_rcvtxn_rec FAIL', 9);
2092: END IF;
2093: RAISE fnd_api.g_exc_error;
2094: END IF;
2095:
2096: -- Set flag to call to TM
2097: l_call_rm := TRUE;

Line 2132: RAISE fnd_api.g_exc_error;

2128: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL', 9);
2129: END IF;
2130: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
2131: fnd_msg_pub.ADD;
2132: RAISE fnd_api.g_exc_error;
2133: END IF;
2134:
2135: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN
2136: IF (l_debug = 1) THEN

Line 2180: RAISE fnd_api.g_exc_error;

2176: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts FAIL', 9);
2177: END IF;
2178: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
2179: fnd_msg_pub.ADD;
2180: RAISE fnd_api.g_exc_error;
2181: END IF;
2182:
2183: l_progress := '6.2.2.5';
2184:

Line 2207: RAISE fnd_api.g_exc_error;

2203: IF (x_return_status <> g_ret_sts_success) THEN
2204: IF (l_debug = 1) THEN
2205: print_debug('ERROR: insert_lot_serial FAIL', 9);
2206: END IF;
2207: RAISE fnd_api.g_exc_error;
2208: END IF;
2209:
2210: l_progress := '6.2.3';
2211:

Line 2320: RAISE fnd_api.g_exc_error;

2316: IF (x_return_status <> g_ret_sts_success) THEN
2317: IF (l_debug = 1) THEN
2318: print_debug('ERROR: split_lot_serial FAIL', 9);
2319: END IF;
2320: RAISE fnd_api.g_exc_error;
2321: END IF;
2322:
2323: l_progress := '6.2.8';
2324:

Line 2387: RAISE fnd_api.g_exc_error;

2383: IF (l_debug = 1) THEN
2384: print_debug('PACK_UNPACK_SPLIT : ERROR - Match_transfer_rcvtxn_rec FAIL',
2385: 9);
2386: END IF;
2387: RAISE fnd_api.g_exc_error;
2388: END IF;
2389:
2390: l_progress := '6.2.9';
2391:

Line 2474: RAISE fnd_api.g_exc_error;

2470: IF (l_debug = 1) THEN
2471: print_debug('PACK_UNPACK_SPLIT: ERROR - Match_transfer_rcvtxn_rec FAIL',
2472: 9);
2473: END IF;
2474: RAISE fnd_api.g_exc_error;
2475: END IF;
2476:
2477: END IF; -- End remaining qty check
2478:

Line 2558: RAISE fnd_api.g_exc_error;

2554: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL');
2555: END IF;
2556: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
2557: fnd_msg_pub.ADD;
2558: RAISE fnd_api.g_exc_error;
2559: END IF;
2560:
2561: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN
2562: IF (l_debug = 1) THEN

Line 2604: RAISE fnd_api.g_exc_error;

2600: print_debug('PACK_UNPACK_SPLIT: ERROR - abort_mmtts FAIL');
2601: END IF;
2602: FND_MESSAGE.SET_NAME('WMS','WMS_TASK_DELETE_ERROR');
2603: fnd_msg_pub.ADD;
2604: RAISE fnd_api.g_exc_error;
2605: END IF;
2606:
2607: l_progress := '7.1.3';
2608:

Line 2625: RAISE fnd_api.g_exc_error;

2621: IF (x_return_status <> g_ret_sts_success) THEN
2622: IF (l_debug = 1) THEN
2623: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_lot_serial FAIL', 9);
2624: END IF;
2625: RAISE fnd_api.g_exc_error;
2626: END IF;
2627:
2628: l_progress := '7.1.4';
2629: IF (l_debug = 1) THEN

Line 2678: RAISE fnd_api.g_exc_error;

2674: IF (x_return_status <> g_ret_sts_success) THEN
2675: IF (l_debug = 1) THEN
2676: print_debug('PACK_UNPACK_SPLIT: ERROR - Match_transfer_rcvtxn_rec FAIL');
2677: END IF;
2678: RAISE fnd_api.g_exc_error;
2679: END IF;
2680:
2681: l_progress := '7.1.6';
2682:

Line 2719: RAISE fnd_api.g_exc_error;

2715: print_debug('PACK_UNPACK_SPLIT: ERROR - split_mo FAIL');
2716: END IF;
2717: fnd_message.set_name('INV', 'INV_SPLIT_MO_ERR');
2718: fnd_msg_pub.ADD;
2719: RAISE fnd_api.g_exc_error;
2720: END IF;
2721:
2722: IF (l_tmp_mmtt_rec.move_order_line_id <> l_mo_splt_tb(1).line_id) THEN
2723: IF (l_debug = 1) THEN

Line 2760: RAISE fnd_api.g_exc_error;

2756: IF (x_return_status <> g_ret_sts_success) THEN
2757: IF (l_debug = 1) THEN
2758: print_debug('PACK_UNPACK_SPLIT: ERROR - insert_lot_serail FAIL');
2759: END IF;
2760: RAISE fnd_api.g_exc_error;
2761: END IF;
2762:
2763: l_progress := '7.2.4';
2764: OPEN mol_cur(l_tmp_mmtt_rec.move_order_line_id);

Line 2869: RAISE fnd_api.g_exc_error;

2865: IF (x_return_status <> g_ret_sts_success) THEN
2866: IF (l_debug = 1) THEN
2867: print_debug('PACK_UNPACK_SPLIT: ERROR - split_lot_serial FAIL', 9);
2868: END IF;
2869: RAISE fnd_api.g_exc_error;
2870: END IF;
2871: l_progress := '7.2.8';
2872:
2873: IF l_mmtt_rec.transaction_uom <> l_tmp_mmtt_rec.transaction_uom THEN

Line 2925: RAISE fnd_api.g_exc_error;

2921: IF (l_debug = 1) THEN
2922: print_debug('PACK_UNPACK_SPLIT: ERROR - Match_transfer_rcvtxn_rec FAIL',
2923: 9);
2924: END IF;
2925: RAISE fnd_api.g_exc_error;
2926: END IF;
2927: l_progress := '7.2.8';
2928:
2929: END LOOP;

Line 2979: RAISE fnd_api.g_exc_error;

2975: IF (x_return_status <> g_ret_sts_success) THEN
2976: IF (l_debug = 1) THEN
2977: print_debug('PAC_UNPACK_SPLIT: ERROR - 1 Match_transfer_rcvtxn_rec FAIL');
2978: END IF;
2979: RAISE fnd_api.g_exc_error;
2980: END IF;
2981: END IF;
2982:
2983: l_progress := '7.2.11';

Line 2995: RAISE fnd_api.g_exc_error;

2991: END IF; -- End sub/loc test
2992: ELSE
2993: fnd_message.set_name('INV', 'INV_INVALID_TXN_TYPE');
2994: fnd_msg_pub.ADD;
2995: RAISE fnd_api.g_exc_error;
2996: END IF; -- End txn_type test
2997:
2998:
2999: END LOOP; -- End tmp_mmtt_cur loop

Line 3030: RAISE fnd_api.g_exc_error;

3026: WHEN OTHERS THEN
3027: IF (l_debug = 1) THEN
3028: print_debug('Error deleting temp MSNTs');
3029: END IF;
3030: RAISE fnd_api.g_exc_error;
3031: END;
3032:
3033: BEGIN
3034: forall i IN 1 .. l_mmtts_count

Line 3045: RAISE fnd_api.g_exc_error;

3041: WHEN OTHERS THEN
3042: IF (l_debug = 1) THEN
3043: print_debug('Error deleting temp MTLTs');
3044: END IF;
3045: RAISE fnd_api.g_exc_error;
3046: END;
3047:
3048: BEGIN
3049: forall i IN 1 .. l_mmtts_count

Line 3060: RAISE fnd_api.g_exc_error;

3056: WHEN OTHERS THEN
3057: IF (l_debug =1 )THEN
3058: print_debug('Error deleting temp MMTTs');
3059: END IF;
3060: RAISE fnd_api.g_exc_error;
3061: END;
3062:
3063: COMMIT; --Need to commit the delete
3064:

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

3061: END;
3062:
3063: COMMIT; --Need to commit the delete
3064:
3065: IF (l_call_rm = TRUE AND p_call_rcv_tm = fnd_api.g_true) THEN
3066: IF (l_debug = 1) THEN
3067: print_debug('Calling Receiving TM');
3068: END IF;
3069:

Line 3106: WHEN fnd_api.g_exc_unexpected_error THEN

3102:
3103: x_mo_lines_tb := l_out_mo_splt_tb;
3104:
3105: EXCEPTION
3106: WHEN fnd_api.g_exc_unexpected_error THEN
3107: IF (l_debug = 1) THEN
3108: print_debug('PACK_UNPACK_SPLIT: Unexpected Exception occured after progress: '
3109: || l_progress);
3110: END IF;