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

Line 124: RAISE fnd_api.g_exc_error;

120: END IF;
121:
122: fnd_message.set_name('INV', 'INV_ERES_ENABLED');
123: fnd_msg_pub.ADD;
124: RAISE fnd_api.g_exc_error;
125: RETURN FALSE;
126: END trans_eres_enabled;
127:
128: --3978111 CHANGES START

Line 166: raise fnd_api.g_exc_unexpected_error;

162: fnd_msg_pub.ADD;
163: IF (l_debug = 1) THEN
164: inv_log_util.TRACE('INVTRXWB: Error from CSTACOSN.op_snapshot ','INVTRXWB',1);
165: END IF;
166: raise fnd_api.g_exc_unexpected_error;
167: ELSE
168: inv_log_util.TRACE('INVTRXWB: CALL TO CSTACOSN.op_snapshot SUCCESSFULL','INVTRXWB',1);
169: END IF;
170:

Line 266: RAISE fnd_api.g_exc_error;

262: fnd_message.set_token('uom1', v_mmtt_rec.transaction_uom);
263: fnd_message.set_token('uom2', l_temp_uom_code);
264: fnd_message.set_token('module', 'INSERT_LINE_TRX');
265: fnd_msg_pub.ADD;
266: RAISE fnd_api.g_exc_error;
267: END IF;*/
268: --16445970 --Commented the above
269: v_mmtt_rec.primary_quantity := curlpnrec.primary_quantity;
270: IF (l_debug = 1) THEN

Line 350: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

346: , x_incr_transfer_price => x_incr_transfer_price
347: , x_incr_currency_code => x_incr_currency_code
348: );
349:
350: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
351: THEN
352: inv_log_util.trace('X_return status is <> S',g_pkg_name || '.' || l_api_name, 5);
353: x_transfer_price := 0;
354: END IF;

Line 675: RAISE fnd_api.g_exc_error;

671: fnd_message.set_token('uom1', curlpnrec.uom);
672: fnd_message.set_token('uom2', l_primary_uom);
673: fnd_message.set_token('module', 'INSERT_LOT_TRX');
674: fnd_msg_pub.ADD;
675: RAISE fnd_api.g_exc_error;
676: END IF;*/
677: --16445970 Commented the above conversion of Primary quantity
678: l_primary_qty := curlpnrec.primary_quantity;
679:

Line 708: RAISE fnd_api.g_exc_error;

704: END IF;
705:
706: fnd_message.set_name('INV', 'INV_FAILED');
707: fnd_msg_pub.ADD;
708: RAISE fnd_api.g_exc_error;
709: END IF;
710:
711: IF (l_debug = 1) THEN
712: inv_log_util.TRACE('*Inserted Lot :' || curlpnrec.lot_number, 'INV_LPN_TRX_PUB', 9);

Line 737: RAISE fnd_api.g_exc_error;

733: END IF;
734:
735: fnd_message.set_name('INV', 'INV_FAILED');
736: fnd_msg_pub.ADD;
737: RAISE fnd_api.g_exc_error;
738: END IF;
739:
740: IF (l_debug = 1) THEN
741: inv_log_util.TRACE('*Inserted Serial:' || p_ser_number || ',trxid=' || p_sertrxid, 'INV_LPN_TRX_PUB', 9);

Line 769: RAISE fnd_api.g_exc_error;

765: fnd_message.set_token('uom1', p_uom1);
766: fnd_message.set_token('uom2', p_uom2);
767: fnd_message.set_token('module', 'GET_CONVERTED_QTY');
768: fnd_msg_pub.ADD;
769: RAISE fnd_api.g_exc_error;
770: END IF;
771:
772: RETURN l_converted_qty;
773: END;

Line 836: WMS_Container_PVT.Explode_LPN(1.0, fnd_api.g_false, fnd_api.g_false, ret_status, ret_msgcnt, ret_msgdata, p_lpn_id, 0, tb_lpn_cnts);

832: END IF;
833:
834: -- Bug 5103408 Add check for explode_lpn failure status.
835: -- Transaction should not continue if an error occurs during explosion
836: WMS_Container_PVT.Explode_LPN(1.0, fnd_api.g_false, fnd_api.g_false, ret_status, ret_msgcnt, ret_msgdata, p_lpn_id, 0, tb_lpn_cnts);
837:
838: IF ( ret_status <> fnd_api.g_ret_sts_success) THEN
839: IF (l_debug = 1) THEN
840: inv_log_util.TRACE('**Error: Failed in wms_container_pub.explode_lpn API :' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);

Line 838: IF ( ret_status <> fnd_api.g_ret_sts_success) THEN

834: -- Bug 5103408 Add check for explode_lpn failure status.
835: -- Transaction should not continue if an error occurs during explosion
836: WMS_Container_PVT.Explode_LPN(1.0, fnd_api.g_false, fnd_api.g_false, ret_status, ret_msgcnt, ret_msgdata, p_lpn_id, 0, tb_lpn_cnts);
837:
838: IF ( ret_status <> fnd_api.g_ret_sts_success) THEN
839: IF (l_debug = 1) THEN
840: inv_log_util.TRACE('**Error: Failed in wms_container_pub.explode_lpn API :' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
841: END IF;
842:

Line 843: RAISE fnd_api.g_exc_error;

839: IF (l_debug = 1) THEN
840: inv_log_util.TRACE('**Error: Failed in wms_container_pub.explode_lpn API :' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
841: END IF;
842:
843: RAISE fnd_api.g_exc_error;
844: END IF;
845:
846: -- Retrieve LPN's SUB and Locator
847: SELECT subinventory_code

Line 901: RAISE fnd_api.g_exc_error;

897: IF ( sql%rowcount = 0 ) THEN
898: fnd_message.set_name('INV', 'INV_NO_RECORDS');
899: fnd_message.set_token('ENTITY', 'MTL_TRANSACTIONS_INTERFACE');
900: fnd_msg_pub.ADD;
901: RAISE fnd_api.g_exc_error;
902: END IF;
903: END IF;
904: ELSIF(p_mmtt.inventory_item_id <> -1) THEN
905: UPDATE mtl_material_transactions_temp

Line 929: RAISE fnd_api.g_exc_error;

925: END IF;
926:
927: fnd_message.set_name('INV', 'INV_INT_XSUBCODE');
928: fnd_msg_pub.ADD;
929: RAISE fnd_api.g_exc_error;
930: END IF;
931:
932: IF (l_debug = 1) THEN
933: inv_log_util.TRACE(

Line 1108: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

1104: , p_lpn_id => NULL
1105: , p_cost_group_id => NVL(curlpnrec.cost_group_id, p_mmtt.cost_group_id)
1106: );
1107:
1108: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
1109: IF (l_debug = 1) THEN
1110: inv_log_util.TRACE('**Error: Failed in comingling_check API :' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
1111: END IF;
1112:

Line 1113: RAISE fnd_api.g_exc_error;

1109: IF (l_debug = 1) THEN
1110: inv_log_util.TRACE('**Error: Failed in comingling_check API :' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
1111: END IF;
1112:
1113: RAISE fnd_api.g_exc_error;
1114: END IF;
1115:
1116: IF (l_comingling_occurs = 'Y') THEN
1117: IF (l_debug = 1) THEN

Line 1129: RAISE fnd_api.g_exc_error;

1125:
1126: fnd_message.set_name('INV', 'INV_COMINGLE_FAIL');
1127: fnd_message.set_token('CG', l_cst_grp);
1128: fnd_msg_pub.ADD;
1129: RAISE fnd_api.g_exc_error;
1130: END IF;
1131: END IF;
1132:
1133: sertrxid := insert_lot_trx(curlpnrec, v_lasttrxtmpid);

Line 1226: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

1222: , p_lpn_id => NULL
1223: , p_cost_group_id => NVL(curlpnrec.cost_group_id, p_mmtt.cost_group_id)
1224: );
1225:
1226: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
1227: IF (l_debug = 1) THEN
1228: inv_log_util.TRACE('**Error: Failed in comingling_check API :' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
1229: END IF;
1230:

Line 1231: RAISE fnd_api.g_exc_error;

1227: IF (l_debug = 1) THEN
1228: inv_log_util.TRACE('**Error: Failed in comingling_check API :' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
1229: END IF;
1230:
1231: RAISE fnd_api.g_exc_error;
1232: END IF;
1233:
1234: IF (l_comingling_occurs = 'Y') THEN
1235: IF (l_debug = 1) THEN

Line 1247: RAISE fnd_api.g_exc_error;

1243:
1244: fnd_message.set_name('INV', 'INV_COMINGLE_FAIL');
1245: fnd_message.set_token('CG', l_cst_grp);
1246: fnd_msg_pub.ADD;
1247: RAISE fnd_api.g_exc_error;
1248: END IF;
1249: END IF;
1250:
1251: -- End Bug 2712046

Line 1320: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

1316: , x_cost_group_id => l_cst_grp_id
1317: , x_transfer_cost_group_id => l_xfr_cst_grp_id
1318: );
1319:
1320: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
1321: IF (l_debug = 1) THEN
1322: inv_log_util.TRACE(' Error from CostGrpAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
1323: END IF;
1324:

Line 1327: RAISE fnd_api.g_exc_error;

1323: END IF;
1324:
1325: fnd_message.set_name('INV', 'INV_COST_GROUP_FAILURE');
1326: fnd_msg_pub.ADD;
1327: RAISE fnd_api.g_exc_error;
1328: END IF;
1329: -- If this is for an OrgXfr transaction, update the cost_group_id
1330: -- of the content item for this LPN as this could have been
1331: -- changed by the CG API.

Line 1495: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

1491: , x_cost_group_id => l_cst_grp_id
1492: , x_transfer_cost_group_id => l_xfr_cst_grp_id
1493: );
1494:
1495: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
1496: IF (l_debug = 1) THEN
1497: inv_log_util.TRACE(' Error from CostGrpAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
1498: END IF;
1499:

Line 1502: RAISE fnd_api.g_exc_error;

1498: END IF;
1499:
1500: fnd_message.set_name('INV', 'INV_COST_GROUP_FAILURE');
1501: fnd_msg_pub.ADD;
1502: RAISE fnd_api.g_exc_error;
1503: END IF;
1504: -- If this is for an OrgXfr transaction, update the cost_group_id
1505: -- of the content item for this LPN as this could have been
1506: -- changed by the CG API.

Line 1527: x_return_status := fnd_api.g_ret_sts_success;

1523: l_shipment_line_id NUMBER;
1524: l_mmt_transaction_id NUMBER;
1525: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1526: BEGIN
1527: x_return_status := fnd_api.g_ret_sts_success;
1528:
1529: IF (l_debug = 1) THEN
1530: inv_log_util.TRACE('PO J installed', 'INV_LPN_TRX_PUB', 1);
1531: inv_log_util.TRACE('Updating FOB_POINT', 'INV_LPN_TRX_PUB', 1);

Line 1566: RAISE fnd_api.g_exc_error;

1562:
1563: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');
1564: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);
1565: fnd_msg_pub.ADD;
1566: RAISE fnd_api.g_exc_error;
1567: END;
1568:
1569: UPDATE mtl_material_transactions_temp
1570: SET fob_point = l_fob_point

Line 1589: RAISE fnd_api.g_exc_error;

1585: IF (l_debug = 1) THEN
1586: inv_log_util.TRACE('no data found rcv_transactions', 'INV_LPN_TRX_PUB', 1);
1587: END IF;
1588:
1589: RAISE fnd_api.g_exc_error;
1590: END;
1591:
1592: SELECT Nvl(mmt_transaction_id,-1)
1593: INTO l_mmt_transaction_id

Line 1623: RAISE fnd_api.g_exc_error;

1619: END IF;
1620: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');
1621: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);
1622: fnd_msg_pub.ADD;
1623: RAISE fnd_api.g_exc_error;
1624: END;
1625: else
1626: BEGIN
1627: SELECT fob_point

Line 1638: RAISE fnd_api.g_exc_error;

1634: WHEN NO_DATA_FOUND THEN
1635: IF (l_debug = 1) THEN
1636: inv_log_util.TRACE('no data found mtl_material_transactions', 'INV_LPN_TRX_PUB', 1);
1637: END IF;
1638: RAISE fnd_api.g_exc_error;
1639: END;
1640: END IF;
1641: UPDATE mtl_material_transactions_temp
1642: SET fob_point = l_fob_point

Line 1651: WHEN fnd_api.g_exc_error THEN

1647: v_mmtt.fob_point := l_fob_point;
1648: v_mmtt.intransit_account := l_intransit_inv_account;
1649: END IF; -- intransit Rcpt
1650: EXCEPTION
1651: WHEN fnd_api.g_exc_error THEN
1652: x_return_status := fnd_api.g_ret_sts_error;
1653: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1654: WHEN OTHERS THEN
1655: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1652: x_return_status := fnd_api.g_ret_sts_error;

1648: v_mmtt.intransit_account := l_intransit_inv_account;
1649: END IF; -- intransit Rcpt
1650: EXCEPTION
1651: WHEN fnd_api.g_exc_error THEN
1652: x_return_status := fnd_api.g_ret_sts_error;
1653: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1654: WHEN OTHERS THEN
1655: x_return_status := fnd_api.g_ret_sts_unexp_error;
1656: END update_fob_point;

Line 1655: x_return_status := fnd_api.g_ret_sts_unexp_error;

1651: WHEN fnd_api.g_exc_error THEN
1652: x_return_status := fnd_api.g_ret_sts_error;
1653: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1654: WHEN OTHERS THEN
1655: x_return_status := fnd_api.g_ret_sts_unexp_error;
1656: END update_fob_point;
1657:
1658: /********************************************************************
1659: * Pack or Unpack item/lpn. If lot or serial controlled, then

Line 1740: , p_init_msg_list => fnd_api.g_false

1736: END IF;
1737:
1738: WMS_Container_PVT.PackUnpack_Container(
1739: p_api_version => 1.0
1740: , p_init_msg_list => fnd_api.g_false
1741: , p_validation_level => fnd_api.g_valid_level_none
1742: , x_return_status => ret_status
1743: , x_msg_count => ret_msgcnt
1744: , x_msg_data => ret_msgdata

Line 1741: , p_validation_level => fnd_api.g_valid_level_none

1737:
1738: WMS_Container_PVT.PackUnpack_Container(
1739: p_api_version => 1.0
1740: , p_init_msg_list => fnd_api.g_false
1741: , p_validation_level => fnd_api.g_valid_level_none
1742: , x_return_status => ret_status
1743: , x_msg_count => ret_msgcnt
1744: , x_msg_data => ret_msgdata
1745: , p_caller => 'INV_TRNSACTION'

Line 1765: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

1761: , p_source_name => p_source_name
1762: , p_source_transaction_id => p_source_trx_id
1763: );
1764:
1765: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
1766: IF (l_debug = 1) THEN
1767: inv_log_util.TRACE('**Error from LPN pack/unpack :' || ret_status, 'INV_LPN_TRX_PUB', 1);
1768: inv_log_util.TRACE(
1769: '**p_lpn='

Line 1794: RAISE fnd_api.g_exc_error;

1790: END IF;
1791:
1792: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1793: fnd_msg_pub.ADD;
1794: RAISE fnd_api.g_exc_error;
1795: END IF;
1796: ELSE
1797: -- We are packing/unpacking an Item. Check for Lot and Serials
1798: item_id := p_item_rec.inventory_item_id;

Line 1833: , p_init_msg_list => fnd_api.g_false

1829: ) THEN /*pack as vanilla*/
1830: inv_log_util.TRACE('** Packing rma so issue serial as vanilla for receipt**', 'INV_LPN_TRX_PUB', 9);
1831: WMS_Container_PVT.PackUnpack_Container (
1832: p_api_version => 1.0
1833: , p_init_msg_list => fnd_api.g_false
1834: , x_return_status => ret_status
1835: , p_validation_level => fnd_api.g_valid_level_none
1836: , x_msg_count => ret_msgcnt
1837: , x_msg_data => ret_msgdata

Line 1835: , p_validation_level => fnd_api.g_valid_level_none

1831: WMS_Container_PVT.PackUnpack_Container (
1832: p_api_version => 1.0
1833: , p_init_msg_list => fnd_api.g_false
1834: , x_return_status => ret_status
1835: , p_validation_level => fnd_api.g_valid_level_none
1836: , x_msg_count => ret_msgcnt
1837: , x_msg_data => ret_msgdata
1838: , p_caller => 'INV_TRNSACTION'
1839: , p_lpn_id => p_lpn

Line 1861: , p_init_msg_list => fnd_api.g_false

1857: );
1858: ELSE
1859: WMS_Container_PVT.PackUnpack_Container (
1860: p_api_version => 1.0
1861: , p_init_msg_list => fnd_api.g_false
1862: , x_return_status => ret_status
1863: , p_validation_level => fnd_api.g_valid_level_none
1864: , x_msg_count => ret_msgcnt
1865: , x_msg_data => ret_msgdata

Line 1863: , p_validation_level => fnd_api.g_valid_level_none

1859: WMS_Container_PVT.PackUnpack_Container (
1860: p_api_version => 1.0
1861: , p_init_msg_list => fnd_api.g_false
1862: , x_return_status => ret_status
1863: , p_validation_level => fnd_api.g_valid_level_none
1864: , x_msg_count => ret_msgcnt
1865: , x_msg_data => ret_msgdata
1866: , p_caller => 'INV_TRNSACTION'
1867: , p_lpn_id => p_lpn

Line 1888: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

1884: , p_source_transaction_id => p_source_trx_id
1885: );
1886: END IF; /*end of 3158847*/
1887:
1888: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
1889: IF (l_debug = 1) THEN
1890: inv_log_util.TRACE('**Error from pack/unpack :' || ret_status, 'INV_LPN_TRX_PUB', 1);
1891: inv_log_util.TRACE(
1892: '**p_lpn='

Line 1925: RAISE fnd_api.g_exc_error;

1921: END IF;
1922:
1923: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1924: fnd_msg_pub.ADD;
1925: RAISE fnd_api.g_exc_error;
1926: END IF;
1927: END LOOP;
1928:
1929: IF (NOT v_serfound) THEN

Line 1936: , p_init_msg_list => fnd_api.g_false

1932: END IF;
1933:
1934: WMS_Container_PVT.PackUnpack_Container (
1935: p_api_version => 1.0
1936: , p_init_msg_list => fnd_api.g_false
1937: , p_validation_level => fnd_api.g_valid_level_none
1938: , x_return_status => ret_status
1939: , x_msg_count => ret_msgcnt
1940: , x_msg_data => ret_msgdata

Line 1937: , p_validation_level => fnd_api.g_valid_level_none

1933:
1934: WMS_Container_PVT.PackUnpack_Container (
1935: p_api_version => 1.0
1936: , p_init_msg_list => fnd_api.g_false
1937: , p_validation_level => fnd_api.g_valid_level_none
1938: , x_return_status => ret_status
1939: , x_msg_count => ret_msgcnt
1940: , x_msg_data => ret_msgdata
1941: , p_caller => 'INV_TRNSACTION'

Line 1962: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

1958: , p_source_name => p_source_name
1959: , p_source_transaction_id => p_source_trx_id
1960: );
1961:
1962: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
1963: IF (l_debug = 1) THEN
1964: inv_log_util.TRACE('**Error from pack/unpack :' || ret_status, 'INV_LPN_TRX_PUB', 1);
1965: inv_log_util.TRACE(
1966: '**p_lpn='

Line 1991: RAISE fnd_api.g_exc_error;

1987: END IF;
1988:
1989: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1990: fnd_msg_pub.ADD;
1991: RAISE fnd_api.g_exc_error;
1992: END IF;
1993: END IF;
1994: END LOOP;
1995:

Line 2025: , p_init_msg_list => fnd_api.g_false

2021: ) THEN /*pack as vanilla*/
2022: inv_log_util.TRACE('** Packing rma so issue serial as vanilla for receipt**', 'INV_LPN_TRX_PUB', 9);
2023: WMS_Container_PVT.PackUnpack_Container (
2024: p_api_version => 1.0
2025: , p_init_msg_list => fnd_api.g_false
2026: , x_return_status => ret_status
2027: , p_validation_level => fnd_api.g_valid_level_none
2028: , x_msg_count => ret_msgcnt
2029: , x_msg_data => ret_msgdata

Line 2027: , p_validation_level => fnd_api.g_valid_level_none

2023: WMS_Container_PVT.PackUnpack_Container (
2024: p_api_version => 1.0
2025: , p_init_msg_list => fnd_api.g_false
2026: , x_return_status => ret_status
2027: , p_validation_level => fnd_api.g_valid_level_none
2028: , x_msg_count => ret_msgcnt
2029: , x_msg_data => ret_msgdata
2030: , p_caller => 'INV_TRNSACTION'
2031: , p_lpn_id => p_lpn

Line 2053: , p_init_msg_list => fnd_api.g_false

2049: );
2050: ELSE
2051: WMS_Container_PVT.PackUnpack_Container (
2052: p_api_version => 1.0
2053: , p_init_msg_list => fnd_api.g_false
2054: , x_return_status => ret_status
2055: , x_msg_count => ret_msgcnt
2056: , x_msg_data => ret_msgdata
2057: , p_validation_level => fnd_api.g_valid_level_none

Line 2057: , p_validation_level => fnd_api.g_valid_level_none

2053: , p_init_msg_list => fnd_api.g_false
2054: , x_return_status => ret_status
2055: , x_msg_count => ret_msgcnt
2056: , x_msg_data => ret_msgdata
2057: , p_validation_level => fnd_api.g_valid_level_none
2058: , p_caller => 'INV_TRNSACTION'
2059: , p_lpn_id => p_lpn
2060: , p_content_lpn_id => p_content_lpn
2061: , p_content_item_id => item_id

Line 2079: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

2075: , p_source_transaction_id => p_source_trx_id
2076: );
2077: END IF; /*3158847*/
2078:
2079: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
2080: IF (l_debug = 1) THEN
2081: inv_log_util.TRACE(
2082: '**Error from pack/unpack :'
2083: || ret_status

Line 2104: RAISE fnd_api.g_exc_error;

2100: END IF;
2101:
2102: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
2103: fnd_msg_pub.ADD;
2104: RAISE fnd_api.g_exc_error;
2105: END IF;
2106: END LOOP;
2107:
2108: IF (NOT v_serfound) THEN

Line 2115: , p_init_msg_list => fnd_api.g_false

2111: END IF;
2112:
2113: WMS_Container_PVT.PackUnpack_Container (
2114: p_api_version => 1.0
2115: , p_init_msg_list => fnd_api.g_false
2116: , x_return_status => ret_status
2117: , x_msg_count => ret_msgcnt
2118: , x_msg_data => ret_msgdata
2119: , p_caller => 'INV_TRNSACTION'

Line 2121: , p_validation_level => fnd_api.g_valid_level_none

2117: , x_msg_count => ret_msgcnt
2118: , x_msg_data => ret_msgdata
2119: , p_caller => 'INV_TRNSACTION'
2120: , p_lpn_id => p_lpn
2121: , p_validation_level => fnd_api.g_valid_level_none
2122: , p_content_lpn_id => p_content_lpn
2123: , p_content_item_id => item_id
2124: , p_revision => p_revision
2125: , p_primary_quantity => ABS(p_primary_qty)

Line 2140: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

2136: , p_source_name => p_source_name
2137: , p_source_transaction_id => p_source_trx_id
2138: );
2139:
2140: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
2141: IF (l_debug = 1) THEN
2142: inv_log_util.TRACE('**Error from pack/unpack :' || ret_status, 'INV_LPN_TRX_PUB', 1);
2143: inv_log_util.TRACE(
2144: '**p_lpn='

Line 2170: RAISE fnd_api.g_exc_error;

2166: END IF;
2167:
2168: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
2169: fnd_msg_pub.ADD;
2170: RAISE fnd_api.g_exc_error;
2171: END IF;
2172: END IF;
2173: END IF;
2174: END IF; -- p_content_lpn is NULL

Line 2195: , p_init_msg_list => fnd_api.g_true

2191: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2192: BEGIN
2193: WMS_Container_PVT.Modify_LPN (
2194: p_api_version => 1.0
2195: , p_init_msg_list => fnd_api.g_true
2196: , p_commit => fnd_api.g_false
2197: , p_validation_level => fnd_api.g_valid_level_none
2198: , x_return_status => ret_status
2199: , x_msg_count => ret_msgcnt

Line 2196: , p_commit => fnd_api.g_false

2192: BEGIN
2193: WMS_Container_PVT.Modify_LPN (
2194: p_api_version => 1.0
2195: , p_init_msg_list => fnd_api.g_true
2196: , p_commit => fnd_api.g_false
2197: , p_validation_level => fnd_api.g_valid_level_none
2198: , x_return_status => ret_status
2199: , x_msg_count => ret_msgcnt
2200: , x_msg_data => ret_msgdata

Line 2197: , p_validation_level => fnd_api.g_valid_level_none

2193: WMS_Container_PVT.Modify_LPN (
2194: p_api_version => 1.0
2195: , p_init_msg_list => fnd_api.g_true
2196: , p_commit => fnd_api.g_false
2197: , p_validation_level => fnd_api.g_valid_level_none
2198: , x_return_status => ret_status
2199: , x_msg_count => ret_msgcnt
2200: , x_msg_data => ret_msgdata
2201: , p_caller => 'INV_TRNSACTION'

Line 2205: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

2201: , p_caller => 'INV_TRNSACTION'
2202: , p_lpn => v_lpn
2203: );
2204:
2205: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
2206: IF (l_debug = 1) THEN
2207: inv_log_util.TRACE('Error from modify_lpn :' || ret_status, 'INV_LPN_TRX_PUB', 1);
2208: inv_log_util.TRACE('Error msg :' || ret_msgdata || 'msgcnt=' || ret_msgcnt, 'INV_LPN_TRX_PUB', 1);
2209: END IF;

Line 2213: RAISE fnd_api.g_exc_error;

2209: END IF;
2210:
2211: fnd_message.set_name('INV', 'INV_LPN_UPDATE_FAILURE');
2212: fnd_msg_pub.ADD;
2213: RAISE fnd_api.g_exc_error;
2214: END IF;
2215: END;
2216:
2217: /********************************************************************

Line 2401: RAISE fnd_api.g_exc_unexpected_error;

2397: inv_log_util.TRACE('SQL error: ' || SQLERRM(SQLCODE), l_api_name, 1);
2398: END IF;
2399: END IF;
2400:
2401: RAISE fnd_api.g_exc_unexpected_error;
2402: END copy_msnt;
2403:
2404: /********************************************************************
2405: * Split Delivery Details. If serial controlled, then

Line 2694: RAISE fnd_api.g_exc_error;

2690: END IF;
2691:
2692: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
2693: fnd_msg_pub.ADD;
2694: RAISE fnd_api.g_exc_error;
2695: END IF;
2696:
2697: -- calculate the length of the serial number suffix
2698: --l_serial_suffix_length := LENGTH(l_new_fm_serial) - LENGTH(l_serial_prefix);

Line 2796: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

2792:
2793: wsh_integration.set_inv_pc_attributes(p_in_attributes => l_invpcinrectype, x_return_status => ret_status
2794: , x_msg_count => ret_msgcnt, x_msg_data => ret_msgdata);
2795:
2796: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
2797: IF (l_debug = 1) THEN
2798: inv_log_util.TRACE('return error from Set_Inv_PC_Attributes', l_api_name);
2799: END IF;
2800:

Line 2801: RAISE fnd_api.g_exc_error;

2797: IF (l_debug = 1) THEN
2798: inv_log_util.TRACE('return error from Set_Inv_PC_Attributes', l_api_name);
2799: END IF;
2800:
2801: RAISE fnd_api.g_exc_error;
2802: END IF;
2803: END IF;
2804:
2805: END IF ;--dd_rec.source_code <> 'RTV'

Line 2824: RAISE fnd_api.g_exc_error;

2820: fnd_message.set_token('uom1', p_uom_code);
2821: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);
2822: fnd_message.set_token('module', l_api_name);
2823: fnd_msg_pub.ADD;
2824: RAISE fnd_api.g_exc_error;
2825: END IF;
2826: END IF;
2827: ELSE -- Not serial controlled
2828: l_split_quantity := dd_rec.requested_quantity;

Line 2845: RAISE fnd_api.g_exc_error;

2841: fnd_message.set_token('uom1', l_remaining_qty_uom);
2842: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);
2843: fnd_message.set_token('module', l_api_name);
2844: fnd_msg_pub.ADD;
2845: RAISE fnd_api.g_exc_error;
2846: END IF;
2847:
2848: l_remaining_qty_uom := dd_rec.requested_quantity_uom;
2849: END IF;

Line 2881: RAISE fnd_api.g_exc_unexpected_error;

2877: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH_ERROR');
2878: fnd_message.set_token('UOM1', p_secondary_uom_code);
2879: fnd_message.set_token('UOM2', dd_rec.requested_quantity_uom2);
2880: fnd_msg_pub.ADD;
2881: RAISE fnd_api.g_exc_unexpected_error;
2882: ELSE
2883: -- Everything checks out determine the amount of qty2 to split
2884: -- Calculate the theoretical proportionate quantity2 to be split
2885: --l_split_quantity2 := p_secondary_trx_quantity*dd_rec.requested_quantity/p_quantity;

Line 2925: , p_init_msg_list => fnd_api.g_false

2921: END IF;
2922:
2923: wsh_interface_ext_grp.delivery_detail_action(
2924: p_api_version_number => 1.0
2925: , p_init_msg_list => fnd_api.g_false
2926: , p_commit => fnd_api.g_false
2927: , x_return_status => ret_status
2928: , x_msg_count => ret_msgcnt
2929: , x_msg_data => ret_msgdata

Line 2926: , p_commit => fnd_api.g_false

2922:
2923: wsh_interface_ext_grp.delivery_detail_action(
2924: p_api_version_number => 1.0
2925: , p_init_msg_list => fnd_api.g_false
2926: , p_commit => fnd_api.g_false
2927: , x_return_status => ret_status
2928: , x_msg_count => ret_msgcnt
2929: , x_msg_data => ret_msgdata
2930: , p_detail_id_tab => l_detail_id_tab

Line 2935: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

2931: , p_action_prms => l_action_prms
2932: , x_action_out_rec => l_action_out_rec
2933: );
2934:
2935: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
2936: IF (l_debug = 1) THEN
2937: inv_log_util.TRACE('**Error Delivery_Detail_Action: ' || ret_msgdata, l_api_name, 1);
2938: END IF;
2939:

Line 2942: RAISE fnd_api.g_exc_error;

2938: END IF;
2939:
2940: fnd_message.set_name('INV', 'INV_SPLIT_LINE_FAILURE');
2941: fnd_msg_pub.ADD;
2942: RAISE fnd_api.g_exc_error;
2943: END IF;
2944:
2945: l_shipping_attr(1).delivery_detail_id := l_action_out_rec.result_id_tab(1);
2946:

Line 2956: RAISE fnd_api.g_exc_unexpected_error;

2952: inv_log_util.TRACE('Split qty ' || l_split_quantity || ' is greater than what is available on WDD '
2953: || dd_rec.delivery_detail_id, l_api_name, 9);
2954: END IF;
2955:
2956: RAISE fnd_api.g_exc_unexpected_error;
2957: END IF;
2958:
2959: IF (l_debug = 1) THEN
2960: inv_log_util.TRACE('Call to WSH Delivery_Detail_Action unassign delivery from lpn', l_api_name, 4);

Line 2969: , p_init_msg_list => fnd_api.g_false

2965: l_wsh_del_det_id_tbl(1) := l_shipping_attr(1).delivery_detail_id;
2966:
2967: WSH_WMS_LPN_GRP.Delivery_Detail_Action (
2968: p_api_version_number => 1.0
2969: , p_init_msg_list => fnd_api.g_false
2970: , p_commit => fnd_api.g_false
2971: , x_return_status => ret_status
2972: , x_msg_count => ret_msgcnt
2973: , x_msg_data => ret_msgdata

Line 2970: , p_commit => fnd_api.g_false

2966:
2967: WSH_WMS_LPN_GRP.Delivery_Detail_Action (
2968: p_api_version_number => 1.0
2969: , p_init_msg_list => fnd_api.g_false
2970: , p_commit => fnd_api.g_false
2971: , x_return_status => ret_status
2972: , x_msg_count => ret_msgcnt
2973: , x_msg_data => ret_msgdata
2974: , p_lpn_id_tbl => l_wsh_lpn_id_tbl

Line 2980: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

2976: , p_action_prms => l_wsh_action_prms
2977: , x_defaults => l_wsh_defaults
2978: , x_action_out_rec => l_wsh_action_out_rec );
2979:
2980: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
2981: IF (l_debug = 1) THEN
2982: inv_log_util.TRACE('Error WSH_WMS_LPN_GRP.Delivery_Detail_Action' || ret_status, l_api_name, 1);
2983: END IF;
2984:

Line 2987: RAISE fnd_api.g_exc_error;

2983: END IF;
2984:
2985: fnd_message.set_name('INV', 'INV_UNASSIGN_DEL_FAILURE');
2986: fnd_msg_pub.ADD;
2987: RAISE fnd_api.g_exc_error;
2988: ELSIF (l_debug = 1) THEN
2989: inv_log_util.TRACE('Done with call to WSH Create_Update_Containers', l_api_name, 4);
2990: END IF;
2991:

Line 3016: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

3012: l_shipping_attr(1).picked_quantity2 := l_split_quantity2;
3013: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr
3014: , x_return_status => ret_status);
3015:
3016: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3017: IF (l_debug = 1) THEN
3018: inv_log_util.TRACE('***Error in update shipping attribures for split trx', l_api_name, 9);
3019: END IF;
3020:

Line 3023: RAISE fnd_api.g_exc_error;

3019: END IF;
3020:
3021: fnd_message.set_name('WMS', 'WMS_TD_UPD_SHP_ERROR');
3022: fnd_msg_pub.ADD;
3023: RAISE fnd_api.g_exc_error;
3024: END IF;
3025:
3026: -- Need to also to transfer the item reservation
3027: IF (l_debug = 1) THEN

Line 3067: , p_force_reservation_flag => fnd_api.g_true

3063: , p_lot_number => p_lot_number
3064: , p_quantity => l_split_quantity
3065: , p_uom => dd_rec.requested_quantity_uom
3066: , p_lpn_id => p_xfr_lpn_id
3067: , p_force_reservation_flag => fnd_api.g_true
3068: , p_requirement_date => (Sysdate + l_loop_counter/(24*3600))
3069: , p_source_lpn_id => p_lpn_id
3070: ,p_demand_source_name => l_demand_source_name);
3071:

Line 3072: IF ( ret_status <> fnd_api.g_ret_sts_success ) THEN

3068: , p_requirement_date => (Sysdate + l_loop_counter/(24*3600))
3069: , p_source_lpn_id => p_lpn_id
3070: ,p_demand_source_name => l_demand_source_name);
3071:
3072: IF ( ret_status <> fnd_api.g_ret_sts_success ) THEN
3073: IF (l_debug = 1) THEN
3074: inv_log_util.TRACE('upd_reservation_pup failed '||ret_msgdata, l_api_name, 1);
3075: END IF;
3076: fnd_message.set_name('WMS', 'UPD_RESERVATION_PUP_FAIL');

Line 3078: RAISE fnd_api.g_exc_error;

3074: inv_log_util.TRACE('upd_reservation_pup failed '||ret_msgdata, l_api_name, 1);
3075: END IF;
3076: fnd_message.set_name('WMS', 'UPD_RESERVATION_PUP_FAIL');
3077: fnd_msg_pub.ADD;
3078: RAISE fnd_api.g_exc_error;
3079: END IF;
3080: l_progress := 'Done with call to Upd_Reservation_PUP_New';
3081:
3082: -- Subtract the split quantity from the remaining quantity

Line 3101: RAISE fnd_api.g_exc_error;

3097: IF (l_remaining_quantity > 0) THEN
3098: inv_log_util.TRACE('***Error while splittng delivery not enough quantity found in wdd', l_api_name, 1);
3099: fnd_message.set_name('WMS', 'INV_INSUFFICIENT_WDD_QTY');
3100: fnd_msg_pub.ADD;
3101: RAISE fnd_api.g_exc_error;
3102: END IF;
3103:
3104: IF (p_secondary_trx_quantity IS NOT NULL) THEN
3105: -- We have consumed all of the primary quantity. Calculate the amount of qty2

Line 3159: RAISE fnd_api.g_exc_unexpected_error;

3155: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH_ERROR');
3156: fnd_message.set_token('UOM1', p_secondary_uom_code);
3157: fnd_message.set_token('UOM2', l_dd_rec.requested_quantity_uom2);
3158: fnd_msg_pub.ADD;
3159: RAISE fnd_api.g_exc_unexpected_error;
3160: ELSIF(l_dd_rec.picked_quantity2 > qty2_remainder) THEN
3161: -- This WDD record can consume the entire remaining qty. subtract that
3162: -- amount from the line and set remaining to zero
3163: l_del_det_attr(l_dd_ct).picked_quantity2 := l_dd_rec.picked_quantity2 - qty2_remainder;

Line 3190: RAISE fnd_api.g_exc_error;

3186: IF (qty2_remainder <> 0) THEN
3187: inv_log_util.TRACE('***Error while splittng delivery not enough quantity2 found in wdd', l_api_name, 9);
3188: fnd_message.set_name('WMS', 'INV_INSUFFICIENT_WDD_QTY');
3189: fnd_msg_pub.ADD;
3190: RAISE fnd_api.g_exc_error;
3191: END IF;
3192: ELSIF(l_debug = 1) THEN
3193: inv_log_util.TRACE('no WDD rows left in source lpn...ok', l_api_name, 9);
3194: END IF;

Line 3211: , p_init_msg_list => fnd_api.g_false

3207: END IF;
3208:
3209: wsh_interface_ext_grp.create_update_delivery_detail(
3210: p_api_version_number => 1.0
3211: , p_init_msg_list => fnd_api.g_false
3212: , p_commit => fnd_api.g_false
3213: , x_return_status => ret_status
3214: , x_msg_count => ret_msgcnt
3215: , x_msg_data => ret_msgdata

Line 3212: , p_commit => fnd_api.g_false

3208:
3209: wsh_interface_ext_grp.create_update_delivery_detail(
3210: p_api_version_number => 1.0
3211: , p_init_msg_list => fnd_api.g_false
3212: , p_commit => fnd_api.g_false
3213: , x_return_status => ret_status
3214: , x_msg_count => ret_msgcnt
3215: , x_msg_data => ret_msgdata
3216: , p_detail_info_tab => l_del_det_attr

Line 3221: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

3217: , p_in_rec => l_del_det_in_rec
3218: , x_out_rec => l_del_det_out_rec
3219: );
3220:
3221: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3222: --Get error messages from shipping
3223: wsh_util_core.get_messages('Y', ret_msgdata, l_msg_details, ret_msgcnt);
3224:
3225: IF (ret_msgcnt > 1) THEN

Line 3236: RAISE fnd_api.g_exc_unexpected_error;

3232:
3233: fnd_message.set_name('WMS', 'WMS_UPD_DELIVERY_ERROR');
3234: fnd_message.set_token('MSG1', ret_msgdata);
3235: fnd_msg_pub.ADD;
3236: RAISE fnd_api.g_exc_unexpected_error;
3237: END IF;
3238: END IF;
3239: END split_delivery_details;
3240:

Line 3292: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

3288: , p_organization_id => p_org_id
3289: , p_inventory_item_id => p_item_rec.inventory_item_id
3290: );
3291:
3292: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3293: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
3294: fnd_msg_pub.ADD;
3295: RAISE fnd_api.g_exc_unexpected_error;
3296: END IF;

Line 3295: RAISE fnd_api.g_exc_unexpected_error;

3291:
3292: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3293: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
3294: fnd_msg_pub.ADD;
3295: RAISE fnd_api.g_exc_unexpected_error;
3296: END IF;
3297:
3298: -- 16493898 start
3299: SELECT tracking_quantity_ind

Line 3327: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

3323: , p_to_lpn_id => p_xfr_lpn_id
3324: , x_show_ct_wt => l_valid_sec_qty_split
3325: );
3326:
3327: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3328: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
3329: fnd_msg_pub.ADD;
3330: RAISE fnd_api.g_exc_unexpected_error;
3331: END IF;

Line 3330: RAISE fnd_api.g_exc_unexpected_error;

3326:
3327: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3328: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
3329: fnd_msg_pub.ADD;
3330: RAISE fnd_api.g_exc_unexpected_error;
3331: END IF;
3332:
3333: IF (l_debug = 1) THEN
3334: inv_log_util.TRACE('l_valid_sec_qty_split=' || l_valid_sec_qty_split, l_api_name, 9);

Line 3356: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

3352: , p_secondary_quantity => NULL
3353: , p_secondary_uom_code => NULL
3354: );
3355:
3356: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3357: IF (l_debug = 1) THEN
3358: inv_log_util.TRACE('Error calling Update_LPN_Secondary_Quantity: ' || ret_msgdata, l_api_name, 1);
3359: END IF;
3360:

Line 3361: RAISE fnd_api.g_exc_unexpected_error;

3357: IF (l_debug = 1) THEN
3358: inv_log_util.TRACE('Error calling Update_LPN_Secondary_Quantity: ' || ret_msgdata, l_api_name, 1);
3359: END IF;
3360:
3361: RAISE fnd_api.g_exc_unexpected_error;
3362: END IF;
3363:
3364: --Clear the secondary quantity fields for the to LPN
3365: wms_catch_weight_pvt.update_lpn_secondary_quantity(

Line 3382: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

3378: , p_secondary_quantity => NULL
3379: , p_secondary_uom_code => NULL
3380: );
3381:
3382: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3383: IF (l_debug = 1) THEN
3384: inv_log_util.TRACE('Error calling Update_LPN_Secondary_Quantity: ' || ret_msgdata, l_api_name, 1);
3385: END IF;
3386:

Line 3387: RAISE fnd_api.g_exc_unexpected_error;

3383: IF (l_debug = 1) THEN
3384: inv_log_util.TRACE('Error calling Update_LPN_Secondary_Quantity: ' || ret_msgdata, l_api_name, 1);
3385: END IF;
3386:
3387: RAISE fnd_api.g_exc_unexpected_error;
3388: END IF;
3389: END IF;
3390: END IF;
3391:

Line 3445: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

3441: , p_to_lpn_id => p_xfr_lpn_id
3442: , x_show_ct_wt => l_valid_sec_qty_split
3443: );
3444:
3445: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3446: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
3447: fnd_msg_pub.ADD;
3448: RAISE fnd_api.g_exc_unexpected_error;
3449: END IF;

Line 3448: RAISE fnd_api.g_exc_unexpected_error;

3444:
3445: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3446: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
3447: fnd_msg_pub.ADD;
3448: RAISE fnd_api.g_exc_unexpected_error;
3449: END IF;
3450:
3451: IF (l_debug = 1) THEN
3452: inv_log_util.TRACE('l_valid_sec_qty_split=' || l_valid_sec_qty_split, l_api_name, 9);

Line 3477: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

3473: , p_secondary_quantity => NULL
3474: , p_secondary_uom_code => NULL
3475: );
3476:
3477: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3478: IF (l_debug = 1) THEN
3479: inv_log_util.TRACE('Error calling Update_LPN_Secondary_Quantity: ' || ret_msgdata, l_api_name, 1);
3480: END IF;
3481:

Line 3482: RAISE fnd_api.g_exc_unexpected_error;

3478: IF (l_debug = 1) THEN
3479: inv_log_util.TRACE('Error calling Update_LPN_Secondary_Quantity: ' || ret_msgdata, l_api_name, 1);
3480: END IF;
3481:
3482: RAISE fnd_api.g_exc_unexpected_error;
3483: END IF;
3484:
3485: --Clear the secondary quantity fields for the to LPN
3486: wms_catch_weight_pvt.update_lpn_secondary_quantity(

Line 3502: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

3498: , p_secondary_quantity => NULL
3499: , p_secondary_uom_code => NULL
3500: );
3501:
3502: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3503: IF (l_debug = 1) THEN
3504: inv_log_util.TRACE('Error calling Update_LPN_Secondary_Quantity: ' || ret_msgdata, l_api_name, 1);
3505: END IF;
3506:

Line 3507: RAISE fnd_api.g_exc_unexpected_error;

3503: IF (l_debug = 1) THEN
3504: inv_log_util.TRACE('Error calling Update_LPN_Secondary_Quantity: ' || ret_msgdata, l_api_name, 1);
3505: END IF;
3506:
3507: RAISE fnd_api.g_exc_unexpected_error;
3508: END IF;
3509: END IF;
3510: ELSIF(l_secondary_trx_quantity IS NOT NULL) THEN
3511: -- secondary qty populated even though item is not catch weight

Line 3557: , p_commit IN VARCHAR2 := fnd_api.g_false

3553: *******************************************************************/
3554:
3555: FUNCTION process_lpn_trx(
3556: p_trx_hdr_id IN NUMBER
3557: , p_commit IN VARCHAR2 := fnd_api.g_false
3558: , x_proc_msg OUT NOCOPY VARCHAR2
3559: , p_proc_mode IN NUMBER := NULL
3560: , p_process_trx IN VARCHAR2 := fnd_api.g_true
3561: , p_atomic IN VARCHAR2 := fnd_api.g_false

Line 3560: , p_process_trx IN VARCHAR2 := fnd_api.g_true

3556: p_trx_hdr_id IN NUMBER
3557: , p_commit IN VARCHAR2 := fnd_api.g_false
3558: , x_proc_msg OUT NOCOPY VARCHAR2
3559: , p_proc_mode IN NUMBER := NULL
3560: , p_process_trx IN VARCHAR2 := fnd_api.g_true
3561: , p_atomic IN VARCHAR2 := fnd_api.g_false
3562: , p_business_flow_code IN NUMBER := NULL
3563: )
3564: RETURN NUMBER IS

Line 3561: , p_atomic IN VARCHAR2 := fnd_api.g_false

3557: , p_commit IN VARCHAR2 := fnd_api.g_false
3558: , x_proc_msg OUT NOCOPY VARCHAR2
3559: , p_proc_mode IN NUMBER := NULL
3560: , p_process_trx IN VARCHAR2 := fnd_api.g_true
3561: , p_atomic IN VARCHAR2 := fnd_api.g_false
3562: , p_business_flow_code IN NUMBER := NULL
3563: )
3564: RETURN NUMBER IS
3565: BEGIN

Line 3583: , p_commit IN VARCHAR2 := fnd_api.g_false

3579: *
3580: *******************************************************************/
3581: FUNCTION process_lpn_trx(
3582: p_trx_hdr_id IN NUMBER
3583: , p_commit IN VARCHAR2 := fnd_api.g_false
3584: , x_proc_msg OUT NOCOPY VARCHAR2
3585: , p_proc_mode IN NUMBER := NULL
3586: , p_process_trx IN VARCHAR2 := fnd_api.g_true
3587: , p_atomic IN VARCHAR2 := fnd_api.g_false

Line 3586: , p_process_trx IN VARCHAR2 := fnd_api.g_true

3582: p_trx_hdr_id IN NUMBER
3583: , p_commit IN VARCHAR2 := fnd_api.g_false
3584: , x_proc_msg OUT NOCOPY VARCHAR2
3585: , p_proc_mode IN NUMBER := NULL
3586: , p_process_trx IN VARCHAR2 := fnd_api.g_true
3587: , p_atomic IN VARCHAR2 := fnd_api.g_false
3588: , p_business_flow_code IN NUMBER := NULL
3589: , p_init_msg_list IN BOOLEAN
3590: )

Line 3587: , p_atomic IN VARCHAR2 := fnd_api.g_false

3583: , p_commit IN VARCHAR2 := fnd_api.g_false
3584: , x_proc_msg OUT NOCOPY VARCHAR2
3585: , p_proc_mode IN NUMBER := NULL
3586: , p_process_trx IN VARCHAR2 := fnd_api.g_true
3587: , p_atomic IN VARCHAR2 := fnd_api.g_false
3588: , p_business_flow_code IN NUMBER := NULL
3589: , p_init_msg_list IN BOOLEAN
3590: )
3591: RETURN NUMBER IS

Line 3779: IF fnd_api.to_boolean(p_commit) THEN

3775: END IF;
3776:
3777: --Bug 4338316
3778: --Setting the local variable l_commit to honor the p_commit, if passed as true.
3779: IF fnd_api.to_boolean(p_commit) THEN
3780: l_commit := 1;
3781: END IF;
3782:
3783: -- Release 12 - Call to Enhanced Diagnostics Check Implemented

Line 3900: RAISE fnd_api.g_exc_unexpected_error;

3896: IF (l_debug = 1) THEN
3897: inv_log_util.TRACE('no rows retrieve when finding org and level for Cartonization', 'INV_LPN_TRX_PUB', 1);
3898: END IF;
3899:
3900: RAISE fnd_api.g_exc_unexpected_error;
3901: WHEN OTHERS THEN
3902: IF (l_debug = 1) THEN
3903: inv_log_util.TRACE('Unexpected error when finding org and level for Cartonization', 'INV_LPN_TRX_PUB', 1);
3904: END IF;

Line 3906: RAISE fnd_api.g_exc_unexpected_error;

3902: IF (l_debug = 1) THEN
3903: inv_log_util.TRACE('Unexpected error when finding org and level for Cartonization', 'INV_LPN_TRX_PUB', 1);
3904: END IF;
3905:
3906: RAISE fnd_api.g_exc_unexpected_error;
3907: END;
3908:
3909: wms_cartnzn_wrap.cartonize(
3910: p_api_version => 1.0

Line 3911: , p_init_msg_list => fnd_api.g_false

3907: END;
3908:
3909: wms_cartnzn_wrap.cartonize(
3910: p_api_version => 1.0
3911: , p_init_msg_list => fnd_api.g_false
3912: , p_commit => fnd_api.g_false
3913: ,
3914: --p_validation_level => ,
3915: x_return_status => ret_status

Line 3912: , p_commit => fnd_api.g_false

3908:
3909: wms_cartnzn_wrap.cartonize(
3910: p_api_version => 1.0
3911: , p_init_msg_list => fnd_api.g_false
3912: , p_commit => fnd_api.g_false
3913: ,
3914: --p_validation_level => ,
3915: x_return_status => ret_status
3916: , x_msg_count => ret_msgcnt

Line 3929: IF (ret_status = fnd_api.g_ret_sts_error) THEN

3925: , p_stop_level => l_containers
3926: , p_packaging_mode => 2
3927: );
3928:
3929: IF (ret_status = fnd_api.g_ret_sts_error) THEN
3930: IF (l_debug = 1) THEN
3931: inv_log_util.TRACE('Error in calling Cartonization', 'INV_LPN_TRX_PUB', 1);
3932: END IF;
3933:

Line 3934: RAISE fnd_api.g_exc_error;

3930: IF (l_debug = 1) THEN
3931: inv_log_util.TRACE('Error in calling Cartonization', 'INV_LPN_TRX_PUB', 1);
3932: END IF;
3933:
3934: RAISE fnd_api.g_exc_error;
3935: ELSIF(ret_status = fnd_api.g_ret_sts_unexp_error) THEN
3936: IF (l_debug = 1) THEN
3937: inv_log_util.TRACE('Unexpectied error in calling Cartonization', 'INV_LPN_TRX_PUB', 1);
3938: END IF;

Line 3935: ELSIF(ret_status = fnd_api.g_ret_sts_unexp_error) THEN

3931: inv_log_util.TRACE('Error in calling Cartonization', 'INV_LPN_TRX_PUB', 1);
3932: END IF;
3933:
3934: RAISE fnd_api.g_exc_error;
3935: ELSIF(ret_status = fnd_api.g_ret_sts_unexp_error) THEN
3936: IF (l_debug = 1) THEN
3937: inv_log_util.TRACE('Unexpectied error in calling Cartonization', 'INV_LPN_TRX_PUB', 1);
3938: END IF;
3939:

Line 3940: RAISE fnd_api.g_exc_unexpected_error;

3936: IF (l_debug = 1) THEN
3937: inv_log_util.TRACE('Unexpectied error in calling Cartonization', 'INV_LPN_TRX_PUB', 1);
3938: END IF;
3939:
3940: RAISE fnd_api.g_exc_unexpected_error;
3941: ELSIF(ret_status <> fnd_api.g_ret_sts_success) THEN
3942: IF (l_debug = 1) THEN
3943: inv_log_util.TRACE('Undefined error in calling Cartonization', 'INV_LPN_TRX_PUB', 1);
3944: END IF;

Line 3941: ELSIF(ret_status <> fnd_api.g_ret_sts_success) THEN

3937: inv_log_util.TRACE('Unexpectied error in calling Cartonization', 'INV_LPN_TRX_PUB', 1);
3938: END IF;
3939:
3940: RAISE fnd_api.g_exc_unexpected_error;
3941: ELSIF(ret_status <> fnd_api.g_ret_sts_success) THEN
3942: IF (l_debug = 1) THEN
3943: inv_log_util.TRACE('Undefined error in calling Cartonization', 'INV_LPN_TRX_PUB', 1);
3944: END IF;
3945:

Line 3946: RAISE fnd_api.g_exc_unexpected_error;

3942: IF (l_debug = 1) THEN
3943: inv_log_util.TRACE('Undefined error in calling Cartonization', 'INV_LPN_TRX_PUB', 1);
3944: END IF;
3945:
3946: RAISE fnd_api.g_exc_unexpected_error;
3947: END IF;
3948:
3949: IF (l_debug = 1) THEN
3950: inv_log_util.TRACE('Done with call to Cartonization', 'INV_LPN_TRX_PUB', 9);

Line 3972: IF fnd_api.to_boolean(p_atomic) THEN

3968:
3969:
3970:
3971: -- For atomic transactions create a single savepoint for the batch
3972: IF fnd_api.to_boolean(p_atomic) THEN
3973: SAVEPOINT group_savepoint;
3974: END IF;
3975:
3976: l_process := 0;

Line 4005: , p_init_msg_list => fnd_api.g_false

4001: /* ********************************************************************
4002: IF (v_mmtt.lot_number IS NOT NULL) THEN
4003: l_lot_indiv_trx_valid := INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE
4004: ( p_api_version => 1.0
4005: , p_init_msg_list => fnd_api.g_false
4006: , p_transaction_type_id => v_mmtt.transaction_type_id
4007: , p_organization_id => v_mmtt.organization_id
4008: , p_inventory_item_id => v_mmtt.inventory_item_id
4009: , p_revision => v_mmtt.revision

Line 4025: RAISE FND_API.G_EXC_ERROR;

4021: -- the transaction is not valid regarding lot indivisible:
4022: IF (l_debug = 1) THEN
4023: inv_log_util.trace('in proc process_lpn_trx. lot indivisibility error', 'INV_LPN_TRX_PUB', 9);
4024: END IF;
4025: RAISE FND_API.G_EXC_ERROR;
4026: END IF;
4027: ELSE
4028: FOR v_mtlt in c_mtlt(v_mmtt.transaction_temp_id) LOOP
4029: l_lot_indiv_trx_valid := INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE

Line 4031: , p_init_msg_list => fnd_api.g_false

4027: ELSE
4028: FOR v_mtlt in c_mtlt(v_mmtt.transaction_temp_id) LOOP
4029: l_lot_indiv_trx_valid := INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE
4030: ( p_api_version => 1.0
4031: , p_init_msg_list => fnd_api.g_false
4032: , p_transaction_type_id => v_mmtt.transaction_type_id
4033: , p_organization_id => v_mmtt.organization_id
4034: , p_inventory_item_id => v_mmtt.inventory_item_id
4035: , p_revision => v_mmtt.revision

Line 4051: RAISE FND_API.G_EXC_ERROR;

4047: -- the transaction is not valid regarding lot indivisible:
4048: IF (l_debug = 1) THEN
4049: inv_log_util.trace('in proc process_lpn_trx. lot indivisibility error', 'INV_LPN_TRX_PUB', 9);
4050: END IF;
4051: RAISE FND_API.G_EXC_ERROR;
4052: END IF;
4053:
4054: END LOOP;
4055: END IF;

Line 4120: RAISE fnd_api.g_exc_error;

4116: )
4117: ) THEN
4118: fnd_message.set_name('INV', 'INV_INT_TRXACTCODE');
4119: fnd_msg_pub.ADD;
4120: RAISE fnd_api.g_exc_error;
4121: END IF;
4122:
4123: -- For new or null transaction groups that are non atomic, create a new savepoint
4124: IF (NVL(v_mmtt.transaction_batch_id, -88) <> NVL(l_prev_trx_batch_id, -99)

Line 4125: AND NOT fnd_api.to_boolean(p_atomic)) THEN

4121: END IF;
4122:
4123: -- For new or null transaction groups that are non atomic, create a new savepoint
4124: IF (NVL(v_mmtt.transaction_batch_id, -88) <> NVL(l_prev_trx_batch_id, -99)
4125: AND NOT fnd_api.to_boolean(p_atomic)) THEN
4126: SAVEPOINT group_savepoint;
4127: l_prev_trx_batch_id := v_mmtt.transaction_batch_id;
4128: l_current_group_status := fnd_api.g_ret_sts_success;
4129:

Line 4128: l_current_group_status := fnd_api.g_ret_sts_success;

4124: IF (NVL(v_mmtt.transaction_batch_id, -88) <> NVL(l_prev_trx_batch_id, -99)
4125: AND NOT fnd_api.to_boolean(p_atomic)) THEN
4126: SAVEPOINT group_savepoint;
4127: l_prev_trx_batch_id := v_mmtt.transaction_batch_id;
4128: l_current_group_status := fnd_api.g_ret_sts_success;
4129:
4130: IF (l_debug = 1) THEN
4131: inv_log_util.TRACE('new group savepoint prevbatchid=' || l_prev_trx_batch_id, 'INV_LPN_TRX_PUB', 9);
4132: END IF;

Line 4139: AND NVL(l_current_group_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success

4135: -- Skip records that are of the same trx group where a record has failed
4136: -- Else run records normally
4137: IF NOT(
4138: v_mmtt.transaction_batch_id = l_prev_trx_batch_id
4139: AND NVL(l_current_group_status, fnd_api.g_ret_sts_success) <> fnd_api.g_ret_sts_success
4140: ) THEN
4141: insrowcnt := insrowcnt + 1;
4142:
4143: --For planning xfr and consigned xfr transactions, make sure the

Line 4246: IF (l_fob_ret_sts <> fnd_api.g_ret_sts_success) THEN

4242: ) THEN
4243: update_fob_point(v_mmtt => v_mmtt, x_return_status => l_fob_ret_sts, x_msg_data => l_fob_ret_msg
4244: , x_msg_count => l_fob_msg_count);
4245:
4246: IF (l_fob_ret_sts <> fnd_api.g_ret_sts_success) THEN
4247: IF (l_debug = 1) THEN
4248: inv_log_util.TRACE(' Error from update_fob_point:' || l_fob_ret_msg, 'INV_LPN_TRX_PUB', 1);
4249: END IF;
4250:

Line 4254: RAISE fnd_api.g_exc_error;

4250:
4251: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');
4252: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);
4253: fnd_msg_pub.ADD;
4254: RAISE fnd_api.g_exc_error;
4255: END IF;
4256: END IF;
4257: END IF; --(PO pathset J installed)
4258:

Line 4316: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

4312: , x_cost_group_id => l_cst_grp_id
4313: , x_transfer_cost_group_id => l_xfr_cst_grp_id
4314: );
4315:
4316: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
4317: IF (l_debug = 1) THEN
4318: inv_log_util.TRACE(' Error from CostGrpAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
4319: END IF;
4320: --Bug 3804314: The message from the cost group API is

Line 4324: RAISE fnd_api.g_exc_error;

4320: --Bug 3804314: The message from the cost group API is
4321: --overwritten by INV_COST_GROUP_FAILURE. Commenting the message.
4322: --fnd_message.set_name('INV', 'INV_COST_GROUP_FAILURE');
4323: --fnd_msg_pub.ADD;
4324: RAISE fnd_api.g_exc_error;
4325: END IF;
4326: END IF;
4327:
4328: -- Continue with the process based on the value of l_proc_mode

Line 4373: IF fnd_api.to_boolean(p_commit) THEN

4369: fnd_message.set_name('INV', 'INV_TXN_REQ_QUEUED');
4370: fnd_msg_pub.ADD;
4371: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4372:
4373: IF fnd_api.to_boolean(p_commit) THEN
4374: COMMIT WORK;
4375: END IF;
4376:
4377: RETURN 0;

Line 4512: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

4508: , p_input_type => inv_cost_group_pub.g_input_mmtt
4509: , x_cost_group_id => l_cst_grp_id
4510: , x_transfer_cost_group_id => l_xfr_cst_grp_id );
4511:
4512: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
4513: IF (l_debug = 1) THEN
4514: inv_log_util.TRACE(' Error from CostGrpAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
4515: END IF;
4516: RAISE fnd_api.g_exc_error;

Line 4516: RAISE fnd_api.g_exc_error;

4512: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
4513: IF (l_debug = 1) THEN
4514: inv_log_util.TRACE(' Error from CostGrpAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
4515: END IF;
4516: RAISE fnd_api.g_exc_error;
4517: END IF;
4518:
4519: END IF ;--end of l_rtv_exist --16514543
4520: END IF;

Line 4548: l_current_group_status := fnd_api.g_ret_sts_error;

4544: , 1
4545: );
4546: END IF;
4547:
4548: l_current_group_status := fnd_api.g_ret_sts_error;
4549: l_error_code := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4550: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');
4551: failedrowcnt := failedrowcnt + 1;
4552:

Line 4559: IF fnd_api.to_boolean(p_atomic) THEN

4555: END IF;
4556:
4557: ROLLBACK TO group_savepoint;
4558:
4559: IF fnd_api.to_boolean(p_atomic) THEN
4560: --Set message in MMTT line based in header id
4561: -- Bug 3804314: Changed the where clause to transaction_header_id
4562: BEGIN
4563: -- Update MMTT records with error message and set status to error

Line 4764: RAISE fnd_api.g_exc_error;

4760: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for locator_id'||v_mmtt.locator_id, 'INV_LPN_TRX_PUB', 9);
4761: END IF;
4762: fnd_message.set_name('INV', 'INV_INT_LOCEXP');
4763: fnd_msg_pub.ADD;
4764: RAISE fnd_api.g_exc_error;
4765: END IF;
4766: END IF;
4767: --for move order/direct org xfer/sub xfer,we need also check the transfer location
4768: IF(v_mmtt.transaction_source_type_id=4) then--move order

Line 4780: RAISE fnd_api.g_exc_error;

4776: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for transfer_to_location'||v_mmtt.transfer_to_location, 'INV_LPN_TRX_PUB', 9);
4777: END IF;
4778: fnd_message.set_name('INV', 'INV_INT_LOCEXP');
4779: fnd_msg_pub.ADD;
4780: RAISE fnd_api.g_exc_error;
4781: END IF;
4782: END IF;
4783: ELSIF(v_mmtt.transaction_source_type_id=13 AND v_mmtt.transaction_action_id=2) THEN --sub xfer
4784: IF l_project_ref_enabled = 1 AND nvl(v_mmtt.transfer_to_location,-1) <> -1 THEN

Line 4795: RAISE fnd_api.g_exc_error;

4791: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for transfer_to_location'||v_mmtt.transfer_to_location, 'INV_LPN_TRX_PUB', 9);
4792: END IF;
4793: fnd_message.set_name('INV', 'INV_INT_LOCEXP');
4794: fnd_msg_pub.ADD;
4795: RAISE fnd_api.g_exc_error;
4796: END IF;
4797: END IF;
4798: ELSIF(v_mmtt.transaction_source_type_id=13 AND v_mmtt.transaction_action_id=3)THEN --org direct xfer
4799: BEGIN

Line 4819: RAISE fnd_api.g_exc_error;

4815: inv_log_util.TRACE('Calling inv_projectlocator_pub.GET_PHYSICAL_LOCATION returned with error for transfer_to_location'||v_mmtt.transfer_to_location, 'INV_LPN_TRX_PUB', 9);
4816: END IF;
4817: fnd_message.set_name('INV', 'INV_INT_LOCEXP');
4818: fnd_msg_pub.ADD;
4819: RAISE fnd_api.g_exc_error;
4820: END IF;
4821: END IF;
4822: END IF;
4823: --Bug14298387 end

Line 4859: IF (fnd_api.to_boolean(l_process_trx))

4855: END;
4856:
4857:
4858: -- All preprocessing done. Call the Inventory Transactions Manager
4859: IF (fnd_api.to_boolean(l_process_trx))
4860: AND (l_process <> 0) THEN
4861: -- AND(l_call_tm) THEN
4862: -- Should all the rows in MMTT with the specified TrxHdrId be considered
4863: -- as one unit

Line 4864: IF fnd_api.to_boolean(p_atomic) THEN

4860: AND (l_process <> 0) THEN
4861: -- AND(l_call_tm) THEN
4862: -- Should all the rows in MMTT with the specified TrxHdrId be considered
4863: -- as one unit
4864: IF fnd_api.to_boolean(p_atomic) THEN
4865: l_atomic := 1;
4866: END IF;
4867:
4868: IF (l_debug = 1) THEN

Line 4916: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

4912: , p_business_flow_code => 22
4913: , p_transaction_id => wms_cartnzn_wrap.get_lpns_generated_tb
4914: );
4915:
4916: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
4917: IF (l_debug = 1) THEN
4918: inv_log_util.TRACE('**Error Label Printing :' || ret_status, 'INV_LPN_TRX_PUB', 1);
4919: END IF;
4920: END IF;

Line 4929: IF fnd_api.to_boolean(p_commit) THEN

4925: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4926: RETURN -1 * failedrowcnt;
4927: END IF;
4928:
4929: IF fnd_api.to_boolean(p_commit) THEN
4930: COMMIT WORK;
4931: END IF;
4932:
4933: --

Line 4978: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

4974: inv_log_util.TRACE(' Return Message => ' || ret_status, 'INV_LPN_TRX_PUB', 1);
4975: inv_log_util.TRACE('ERECORD => ' || ret_status, 'INV_LPN_TRX_PUB', 1);
4976: END IF;
4977:
4978: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
4979: IF (l_debug = 1) THEN
4980: inv_log_util.TRACE(' ERROR generated from getErecordIdAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
4981: END IF;
4982:

Line 4985: RAISE fnd_api.g_exc_error;

4981: END IF;
4982:
4983: fnd_message.set_name('INV', 'INV_ERECORD_INVALID');
4984: fnd_msg_pub.ADD;
4985: RAISE fnd_api.g_exc_error;
4986: END IF;
4987:
4988: /* If an eRecord exists, then acknowledge it
4989: ===========================================*/

Line 5006: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

5002: , x_msg_count => ret_msgcnt
5003: , x_msg_data => ret_msgdata
5004: );
5005:
5006: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
5007: IF (l_debug = 1) THEN
5008: inv_log_util.TRACE(' Error from Send ERES ACKNOWLEDGE API:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
5009: END IF;
5010:

Line 5013: RAISE fnd_api.g_exc_error;

5009: END IF;
5010:
5011: fnd_message.set_name('INV', 'INV_ERECORD_INVALID');
5012: fnd_msg_pub.ADD;
5013: RAISE fnd_api.g_exc_error;
5014: END IF;
5015: END IF; /* IF ERECORD ID not NULL */
5016: END IF; /* IF TRANS NOT ERES SUPPORTED */
5017: END LOOP; /* LOOP THROUGH ALL ERECORDS in TBL*/

Line 5133: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => ret_msgcnt, p_data => x_proc_msg);

5129:
5130: ROLLBACK TO process_lpn_trx;
5131: --bug 2894323 fix made changes to return all the messages in the
5132: --stack in x_proc_msg out variable
5133: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => ret_msgcnt, p_data => x_proc_msg);
5134:
5135: IF ret_msgcnt IS NULL THEN
5136: ret_msgcnt := 0;
5137: END IF;

Line 5439: x_return_status := fnd_api.g_ret_sts_success;

5435: , 9
5436: );
5437: END IF;
5438:
5439: x_return_status := fnd_api.g_ret_sts_success;
5440:
5441: --SAVEPOINT PROCESS_LPN_TRX_LINE;
5442:
5443: IF inv_cache.set_item_rec(p_organization_id => p_organization_id, p_item_id => p_inventory_item_id) THEN

Line 5490: RAISE fnd_api.g_exc_unexpected_error;

5486: );
5487: END IF;
5488: ELSE --failed to get item info
5489: l_progress := 'Error calling INV_CACHE.Set_Item_Rec to get item info';
5490: RAISE fnd_api.g_exc_unexpected_error;
5491: END IF;
5492: ELSE --Values already passed, assign to item rec type
5493: l_item_rec.organization_id := p_organization_id;
5494: l_item_rec.inventory_item_id := p_inventory_item_id;

Line 5795: , p_init_msg_list => fnd_api.g_false

5791:
5792: -- LPN must be unpacked into the current sub
5793: WMS_Container_PVT.PackUnpack_Container(
5794: p_api_version => 1.0
5795: , p_init_msg_list => fnd_api.g_false
5796: , p_commit => fnd_api.g_false
5797: , p_validation_level => fnd_api.g_valid_level_none
5798: , x_return_status => ret_status
5799: , x_msg_count => ret_msgcnt

Line 5796: , p_commit => fnd_api.g_false

5792: -- LPN must be unpacked into the current sub
5793: WMS_Container_PVT.PackUnpack_Container(
5794: p_api_version => 1.0
5795: , p_init_msg_list => fnd_api.g_false
5796: , p_commit => fnd_api.g_false
5797: , p_validation_level => fnd_api.g_valid_level_none
5798: , x_return_status => ret_status
5799: , x_msg_count => ret_msgcnt
5800: , x_msg_data => ret_msgdata

Line 5797: , p_validation_level => fnd_api.g_valid_level_none

5793: WMS_Container_PVT.PackUnpack_Container(
5794: p_api_version => 1.0
5795: , p_init_msg_list => fnd_api.g_false
5796: , p_commit => fnd_api.g_false
5797: , p_validation_level => fnd_api.g_valid_level_none
5798: , x_return_status => ret_status
5799: , x_msg_count => ret_msgcnt
5800: , x_msg_data => ret_msgdata
5801: , p_caller => 'INV_TRNSACTION'

Line 5809: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

5805: , p_locator_id => Nvl(l_wlpn_loc_id, p_locator_id) --p_locator_id --Bug 16245192
5806: , p_operation => g_unpack_all
5807: , p_source_transaction_id => p_source_transaction_id );
5808:
5809: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
5810: IF (l_debug = 1) THEN
5811: inv_log_util.TRACE('**Error Full unpack for wip issue:' || ret_status, 'INV_LPN_TRX_PUB', 1);
5812: END IF;
5813:

Line 5816: RAISE fnd_api.g_exc_error;

5812: END IF;
5813:
5814: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
5815: fnd_msg_pub.ADD;
5816: RAISE fnd_api.g_exc_error;
5817: END IF;
5818: --13884722
5819: ELSIF(p_transaction_action_id = inv_globals.g_action_issue
5820: AND p_transaction_source_type_id= inv_globals.g_sourcetype_moveorder

Line 5831: , p_init_msg_list => fnd_api.g_false

5827:
5828: -- LPN must be unpacked from the current parent LPN
5829: WMS_Container_PVT.PackUnpack_Container(
5830: p_api_version => 1.0
5831: , p_init_msg_list => fnd_api.g_false
5832: , p_commit => fnd_api.g_false
5833: , p_validation_level => fnd_api.g_valid_level_none
5834: , x_return_status => ret_status
5835: , x_msg_count => ret_msgcnt

Line 5832: , p_commit => fnd_api.g_false

5828: -- LPN must be unpacked from the current parent LPN
5829: WMS_Container_PVT.PackUnpack_Container(
5830: p_api_version => 1.0
5831: , p_init_msg_list => fnd_api.g_false
5832: , p_commit => fnd_api.g_false
5833: , p_validation_level => fnd_api.g_valid_level_none
5834: , x_return_status => ret_status
5835: , x_msg_count => ret_msgcnt
5836: , x_msg_data => ret_msgdata

Line 5833: , p_validation_level => fnd_api.g_valid_level_none

5829: WMS_Container_PVT.PackUnpack_Container(
5830: p_api_version => 1.0
5831: , p_init_msg_list => fnd_api.g_false
5832: , p_commit => fnd_api.g_false
5833: , p_validation_level => fnd_api.g_valid_level_none
5834: , x_return_status => ret_status
5835: , x_msg_count => ret_msgcnt
5836: , x_msg_data => ret_msgdata
5837: , p_caller => 'INV_TRNSACTION'

Line 5846: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

5842: , p_locator_id => p_locator_id
5843: , p_operation => g_unpack
5844: , p_source_transaction_id => p_source_transaction_id );
5845:
5846: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
5847: IF (l_debug = 1) THEN
5848: inv_log_util.TRACE('**Error During unpacking Content LPN for MO issue:' || ret_status, 'INV_LPN_TRX_PUB', 1);
5849: END IF;
5850:

Line 5853: RAISE fnd_api.g_exc_error;

5849: END IF;
5850:
5851: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
5852: fnd_msg_pub.ADD;
5853: RAISE fnd_api.g_exc_error;
5854: END IF;
5855: --13884722
5856: ELSE
5857: v_lpn.lpn_context := wms_container_pub.lpn_context_stores; --ISSUED OUT

Line 6529: v_lpn.source_name := FND_API.G_MISS_CHAR;

6525: v_lpn.locator_id := p_locator_id;
6526:
6527: IF (l_rcv_txn_type = 'DELIVER') THEN --Bug 8295406
6528: BEGIN
6529: v_lpn.source_name := FND_API.G_MISS_CHAR;
6530: v_lpn.source_header_id := FND_API.G_MISS_NUM;
6531: END;
6532:
6533: END IF;

Line 6530: v_lpn.source_header_id := FND_API.G_MISS_NUM;

6526:
6527: IF (l_rcv_txn_type = 'DELIVER') THEN --Bug 8295406
6528: BEGIN
6529: v_lpn.source_name := FND_API.G_MISS_CHAR;
6530: v_lpn.source_header_id := FND_API.G_MISS_NUM;
6531: END;
6532:
6533: END IF;
6534:

Line 6542: , p_init_msg_list => fnd_api.g_false

6538: -- contents of the LPN.
6539: IF (v_autounpack = 2) THEN
6540: WMS_Container_PVT.PackUnpack_Container (
6541: p_api_version => 1.0
6542: , p_init_msg_list => fnd_api.g_false
6543: , p_commit => fnd_api.g_false
6544: , p_validation_level => fnd_api.g_valid_level_none
6545: , x_return_status => ret_status
6546: , x_msg_count => ret_msgcnt

Line 6543: , p_commit => fnd_api.g_false

6539: IF (v_autounpack = 2) THEN
6540: WMS_Container_PVT.PackUnpack_Container (
6541: p_api_version => 1.0
6542: , p_init_msg_list => fnd_api.g_false
6543: , p_commit => fnd_api.g_false
6544: , p_validation_level => fnd_api.g_valid_level_none
6545: , x_return_status => ret_status
6546: , x_msg_count => ret_msgcnt
6547: , x_msg_data => ret_msgdata

Line 6544: , p_validation_level => fnd_api.g_valid_level_none

6540: WMS_Container_PVT.PackUnpack_Container (
6541: p_api_version => 1.0
6542: , p_init_msg_list => fnd_api.g_false
6543: , p_commit => fnd_api.g_false
6544: , p_validation_level => fnd_api.g_valid_level_none
6545: , x_return_status => ret_status
6546: , x_msg_count => ret_msgcnt
6547: , x_msg_data => ret_msgdata
6548: , p_caller => 'INV_TRNSACTION'

Line 6556: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

6552: , p_locator_id => p_locator_id
6553: , p_operation => g_unpack_all
6554: , p_source_transaction_id => p_source_transaction_id );
6555:
6556: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
6557: IF (l_debug = 1) THEN
6558: inv_log_util.TRACE('**Error Full unpack :' || ret_status, 'INV_LPN_TRX_PUB', 1);
6559: END IF;
6560:

Line 6563: RAISE fnd_api.g_exc_error;

6559: END IF;
6560:
6561: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
6562: fnd_msg_pub.ADD;
6563: RAISE fnd_api.g_exc_error;
6564: END IF;
6565: END IF;
6566: END IF;
6567: END IF;

Line 6592: RAISE fnd_api.g_exc_error;

6588: END IF;
6589:
6590: fnd_message.set_name('INV', 'BAD_INPUT_ARGUMENTS');
6591: fnd_msg_pub.ADD;
6592: RAISE fnd_api.g_exc_error;
6593: END IF;
6594: END IF;
6595:
6596: -- If transaction is subtransfer

Line 6672: RAISE fnd_api.g_exc_error;

6668: END IF;
6669:
6670: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
6671: fnd_msg_pub.ADD;
6672: RAISE fnd_api.g_exc_error;
6673: END IF;
6674:
6675: -- An item or LPN is being unpacked from this LPN.
6676: Call_Pack_Unpack (

Line 6795: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

6791: , p_to_locator_id => p_transfer_to_location
6792: , p_system_task_type => l_system_task_type --9794776
6793: );
6794:
6795: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
6796: IF (l_debug = 1) THEN
6797: inv_log_util.TRACE('Undefined error in calling Transfer_LPN_Reservations', 'INV_LPN_TRX_PUB', 1);
6798: END IF;
6799:

Line 6800: RAISE fnd_api.g_exc_error;

6796: IF (l_debug = 1) THEN
6797: inv_log_util.TRACE('Undefined error in calling Transfer_LPN_Reservations', 'INV_LPN_TRX_PUB', 1);
6798: END IF;
6799:
6800: RAISE fnd_api.g_exc_error;
6801: END IF;
6802:
6803: IF (l_debug = 1) THEN
6804: inv_log_util.TRACE('Done with call to Transfer_LPN_Reservations', 'INV_LPN_TRX_PUB', 9);

Line 6829: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

6825: , p_system_task_type => l_system_task_type
6826:
6827: );
6828:
6829: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
6830: IF (l_debug = 1) THEN
6831: inv_log_util.TRACE('Undefined error in calling transfer_reserved_lpn_contents', 'INV_LPN_TRX_PUB', 1);
6832: END IF;
6833:

Line 6834: RAISE fnd_api.g_exc_error;

6830: IF (l_debug = 1) THEN
6831: inv_log_util.TRACE('Undefined error in calling transfer_reserved_lpn_contents', 'INV_LPN_TRX_PUB', 1);
6832: END IF;
6833:
6834: RAISE fnd_api.g_exc_error;
6835: END IF;
6836:
6837: IF (l_debug = 1) THEN
6838: inv_log_util.TRACE('Done with call to transfer_reserved_lpn_contents', 'INV_LPN_TRX_PUB', 9);

Line 6902: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

6898: , p_to_locator_id => p_transfer_to_location
6899: , p_system_task_type => l_system_task_type --9794776
6900: );
6901:
6902: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
6903: IF (l_debug = 1) THEN
6904: inv_log_util.TRACE('Undefined error in calling Transfer_LPN_Reservations', 'INV_LPN_TRX_PUB', 1);
6905: END IF;
6906:

Line 6907: RAISE fnd_api.g_exc_error;

6903: IF (l_debug = 1) THEN
6904: inv_log_util.TRACE('Undefined error in calling Transfer_LPN_Reservations', 'INV_LPN_TRX_PUB', 1);
6905: END IF;
6906:
6907: RAISE fnd_api.g_exc_error;
6908: END IF;
6909:
6910: IF (l_debug = 1) THEN
6911: inv_log_util.TRACE('Done with call to Transfer_LPN_Reservations', 'INV_LPN_TRX_PUB', 9);

Line 6938: , p_init_msg_list => fnd_api.g_false

6934:
6935: -- bug 5531237 LPN org has not changed yet need to use original org not xfer org
6936: WMS_Container_PVT.PackUnpack_Container (
6937: p_api_version => 1.0
6938: , p_init_msg_list => fnd_api.g_false
6939: , p_commit => fnd_api.g_false
6940: , p_validation_level => fnd_api.g_valid_level_none
6941: , x_return_status => ret_status
6942: , x_msg_count => ret_msgcnt

Line 6939: , p_commit => fnd_api.g_false

6935: -- bug 5531237 LPN org has not changed yet need to use original org not xfer org
6936: WMS_Container_PVT.PackUnpack_Container (
6937: p_api_version => 1.0
6938: , p_init_msg_list => fnd_api.g_false
6939: , p_commit => fnd_api.g_false
6940: , p_validation_level => fnd_api.g_valid_level_none
6941: , x_return_status => ret_status
6942: , x_msg_count => ret_msgcnt
6943: , x_msg_data => ret_msgdata

Line 6940: , p_validation_level => fnd_api.g_valid_level_none

6936: WMS_Container_PVT.PackUnpack_Container (
6937: p_api_version => 1.0
6938: , p_init_msg_list => fnd_api.g_false
6939: , p_commit => fnd_api.g_false
6940: , p_validation_level => fnd_api.g_valid_level_none
6941: , x_return_status => ret_status
6942: , x_msg_count => ret_msgcnt
6943: , x_msg_data => ret_msgdata
6944: , p_caller => 'INV_TRNSACTION'

Line 6952: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

6948: , p_locator_id => NULL
6949: , p_operation => g_unpack_all
6950: , p_source_transaction_id => p_source_transaction_id );
6951:
6952: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
6953: IF (l_debug = 1) THEN
6954: inv_log_util.TRACE('**Error Full unpack :' || ret_status, 'INV_LPN_TRX_PUB', 1);
6955: END IF;
6956:

Line 6959: RAISE fnd_api.g_exc_error;

6955: END IF;
6956:
6957: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
6958: fnd_msg_pub.ADD;
6959: RAISE fnd_api.g_exc_error;
6960: END IF;
6961: ELSE
6962: IF ( l_system_task_type = 7 AND
6963: v_cnt_lpn_ctx = wms_container_pub.lpn_loaded_in_stage )

Line 7067: RAISE fnd_api.g_exc_error;

7063: END IF;
7064:
7065: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
7066: fnd_msg_pub.ADD;
7067: RAISE fnd_api.g_exc_error;
7068: END IF;
7069:
7070: IF (l_debug = 1) THEN
7071: inv_log_util.TRACE(' p_lpn_id :' || p_lpn_id, 'INV_LPN_TRX_PUB', 1);

Line 7119: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

7115: , p_system_task_type => l_system_task_type --9794776
7116:
7117: );
7118:
7119: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
7120: IF (l_debug = 1) THEN
7121: inv_log_util.TRACE('Undefined error in calling transfer_reserved_lpn_contents', 'INV_LPN_TRX_PUB', 1);
7122: END IF;
7123:

Line 7124: RAISE fnd_api.g_exc_error;

7120: IF (l_debug = 1) THEN
7121: inv_log_util.TRACE('Undefined error in calling transfer_reserved_lpn_contents', 'INV_LPN_TRX_PUB', 1);
7122: END IF;
7123:
7124: RAISE fnd_api.g_exc_error;
7125: END IF;
7126:
7127: IF (l_debug = 1) THEN
7128: inv_log_util.TRACE('Done with call to transfer_reserved_lpn_contents', 'INV_LPN_TRX_PUB', 9);

Line 7231: RAISE fnd_api.g_exc_error;

7227: END IF;
7228:
7229: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
7230: fnd_msg_pub.ADD;
7231: RAISE fnd_api.g_exc_error;
7232: END IF;
7233: END IF;
7234:
7235: IF (l_debug = 1) THEN

Line 7248: , p_init_msg_list => fnd_api.g_false

7244:
7245: -- bug 5531237 LPN org has not changed yet need to use original org not xfer org
7246: WMS_Container_PVT.PackUnpack_Container (
7247: p_api_version => 1.0
7248: , p_init_msg_list => fnd_api.g_false
7249: , p_commit => fnd_api.g_false
7250: , p_validation_level => fnd_api.g_valid_level_none
7251: , x_return_status => ret_status
7252: , x_msg_count => ret_msgcnt

Line 7249: , p_commit => fnd_api.g_false

7245: -- bug 5531237 LPN org has not changed yet need to use original org not xfer org
7246: WMS_Container_PVT.PackUnpack_Container (
7247: p_api_version => 1.0
7248: , p_init_msg_list => fnd_api.g_false
7249: , p_commit => fnd_api.g_false
7250: , p_validation_level => fnd_api.g_valid_level_none
7251: , x_return_status => ret_status
7252: , x_msg_count => ret_msgcnt
7253: , x_msg_data => ret_msgdata

Line 7250: , p_validation_level => fnd_api.g_valid_level_none

7246: WMS_Container_PVT.PackUnpack_Container (
7247: p_api_version => 1.0
7248: , p_init_msg_list => fnd_api.g_false
7249: , p_commit => fnd_api.g_false
7250: , p_validation_level => fnd_api.g_valid_level_none
7251: , x_return_status => ret_status
7252: , x_msg_count => ret_msgcnt
7253: , x_msg_data => ret_msgdata
7254: , p_caller => 'INV_TRNSACTION'

Line 7262: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

7258: , p_locator_id => NULL
7259: , p_operation => g_unpack_all
7260: , p_source_transaction_id => p_source_transaction_id );
7261:
7262: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
7263: IF (l_debug = 1) THEN
7264: inv_log_util.TRACE('****Error Full unpack :' || ret_status, 'INV_LPN_TRX_PUB', 1);
7265: END IF;
7266:

Line 7269: RAISE fnd_api.g_exc_error;

7265: END IF;
7266:
7267: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
7268: fnd_msg_pub.ADD;
7269: RAISE fnd_api.g_exc_error;
7270: END IF;
7271: ELSE
7272: IF (l_debug = 1) THEN
7273: inv_log_util.TRACE('*** Coming to else portion ie LPN controlled sub' || p_content_lpn_id, 'INV_LPN_TRX_PUB', 9);

Line 7316: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

7312: , p_to_subinventory_code => p_transfer_subinventory
7313: , p_to_locator_id => p_transfer_to_location
7314: );
7315:
7316: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
7317: IF (l_debug = 1) THEN
7318: inv_log_util.TRACE('**Error from transfer_lpn_trx_reservation :' || ret_status, 'INV_LPN_TRX_PUB', 1);
7319: END IF;
7320:

Line 7323: RAISE fnd_api.g_exc_error;

7319: END IF;
7320:
7321: fnd_message.set_name('INV', 'INV_XFR_RSV_FAILURE');
7322: fnd_msg_pub.ADD;
7323: RAISE fnd_api.g_exc_error;
7324: END IF;
7325: END IF;
7326: END IF;
7327: END IF;

Line 7440: , p_init_msg_list => fnd_api.g_false

7436: l_container_rec(1).container_flag := 'Y';
7437:
7438: wsh_container_grp.update_container(
7439: p_api_version => 1.0
7440: , p_init_msg_list => fnd_api.g_false
7441: , p_commit => fnd_api.g_false
7442: , p_validation_level => fnd_api.g_valid_level_full
7443: , x_return_status => ret_status
7444: , x_msg_count => ret_msgcnt

Line 7441: , p_commit => fnd_api.g_false

7437:
7438: wsh_container_grp.update_container(
7439: p_api_version => 1.0
7440: , p_init_msg_list => fnd_api.g_false
7441: , p_commit => fnd_api.g_false
7442: , p_validation_level => fnd_api.g_valid_level_full
7443: , x_return_status => ret_status
7444: , x_msg_count => ret_msgcnt
7445: , x_msg_data => ret_msgdata

Line 7442: , p_validation_level => fnd_api.g_valid_level_full

7438: wsh_container_grp.update_container(
7439: p_api_version => 1.0
7440: , p_init_msg_list => fnd_api.g_false
7441: , p_commit => fnd_api.g_false
7442: , p_validation_level => fnd_api.g_valid_level_full
7443: , x_return_status => ret_status
7444: , x_msg_count => ret_msgcnt
7445: , x_msg_data => ret_msgdata
7446: , p_container_rec => l_container_rec

Line 7449: IF ret_status = fnd_api.g_ret_sts_unexp_error

7445: , x_msg_data => ret_msgdata
7446: , p_container_rec => l_container_rec
7447: );
7448:
7449: IF ret_status = fnd_api.g_ret_sts_unexp_error
7450: OR ret_status = fnd_api.g_ret_sts_error THEN
7451: RAISE fnd_api.g_exc_error;
7452: END IF;
7453: ELSE

Line 7450: OR ret_status = fnd_api.g_ret_sts_error THEN

7446: , p_container_rec => l_container_rec
7447: );
7448:
7449: IF ret_status = fnd_api.g_ret_sts_unexp_error
7450: OR ret_status = fnd_api.g_ret_sts_error THEN
7451: RAISE fnd_api.g_exc_error;
7452: END IF;
7453: ELSE
7454: fnd_message.set_name('WMS','WMS_INVALID_PACK_DELIVERY');

Line 7451: RAISE fnd_api.g_exc_error;

7447: );
7448:
7449: IF ret_status = fnd_api.g_ret_sts_unexp_error
7450: OR ret_status = fnd_api.g_ret_sts_error THEN
7451: RAISE fnd_api.g_exc_error;
7452: END IF;
7453: ELSE
7454: fnd_message.set_name('WMS','WMS_INVALID_PACK_DELIVERY');
7455: fnd_msg_pub.ADD;

Line 7456: RAISE fnd_api.g_exc_error;

7452: END IF;
7453: ELSE
7454: fnd_message.set_name('WMS','WMS_INVALID_PACK_DELIVERY');
7455: fnd_msg_pub.ADD;
7456: RAISE fnd_api.g_exc_error;
7457: END IF;
7458: END;
7459:
7460: CLOSE c_wdd_exists;

Line 7650: RAISE fnd_api.g_exc_error;

7646: ELSE
7647: IF (l_debug = 1) THEN
7648: inv_log_util.TRACE('Error. While getting org parameters :' , 'INV_LPN_TRX_PUB', 1);
7649: END IF;
7650: RAISE fnd_api.g_exc_error;
7651: END IF;
7652: /* 8579396 :End */
7653: END IF; -- end of if loop based on transaction_type
7654: -- Bug 2392622 removed for now cannot be updated before TM call should be done in MMT

Line 7692: RAISE fnd_api.g_exc_error;

7688: inv_log_util.TRACE(l_api_name||' : '||p_organization_id||' is an invalid organization id', 'INV_LPN_TRX_PUB', 1);
7689: END IF;
7690: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ORG');
7691: fnd_msg_pub.ADD;
7692: RAISE fnd_api.g_exc_error;
7693: END IF;
7694:
7695: IF NVL(inv_cache.org_rec.PROCESS_ENABLED_FLAG,'N') = 'Y' then
7696:

Line 7747: IF (ret_status <> fnd_api.g_ret_sts_success) THEN

7743: , p_transaction_id => p_transaction_temp_id
7744: , p_transaction_identifier => l_transaction_identifier --Added for Bug 4891916
7745: );
7746:
7747: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
7748: IF (l_debug = 1) THEN
7749: inv_log_util.TRACE('**Error Label Printing :' || ret_status, 'INV_LPN_TRX_PUB', 1);
7750: END IF;
7751: --RAISE FND_API.G_EXC_ERROR; Since TM should not fail, even if

Line 7751: --RAISE FND_API.G_EXC_ERROR; Since TM should not fail, even if

7747: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
7748: IF (l_debug = 1) THEN
7749: inv_log_util.TRACE('**Error Label Printing :' || ret_status, 'INV_LPN_TRX_PUB', 1);
7750: END IF;
7751: --RAISE FND_API.G_EXC_ERROR; Since TM should not fail, even if
7752: --this call fails bug#2555226
7753: END IF;
7754: END IF;
7755:

Line 7809: WHEN fnd_api.g_exc_error THEN

7805: inv_log_util.TRACE('* No. of MMTT record deleted ' || SQL%ROWCOUNT, 'INV_LPN_TRX_PUB', 1);
7806: END IF;
7807: END IF;
7808: EXCEPTION
7809: WHEN fnd_api.g_exc_error THEN
7810: x_return_status := fnd_api.g_ret_sts_error;
7811: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');
7812:
7813: IF (l_debug = 1) THEN

Line 7810: x_return_status := fnd_api.g_ret_sts_error;

7806: END IF;
7807: END IF;
7808: EXCEPTION
7809: WHEN fnd_api.g_exc_error THEN
7810: x_return_status := fnd_api.g_ret_sts_error;
7811: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');
7812:
7813: IF (l_debug = 1) THEN
7814: inv_log_util.TRACE(l_api_name || ' Exc err prog=' || l_progress || ' SQL err: ' || SQLERRM(SQLCODE), l_api_name, 1);

Line 7824: x_return_status := fnd_api.g_ret_sts_unexp_error;

7820:
7821: inv_log_util.TRACE('msg: ' || l_msgdata, l_api_name, 1);
7822: END IF;
7823: WHEN OTHERS THEN
7824: x_return_status := fnd_api.g_ret_sts_unexp_error;
7825: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_previous, 'F');
7826:
7827: IF (l_debug = 1) THEN
7828: inv_log_util.TRACE(l_api_name || ' Unexp err prog=' || l_progress || ' SQL err: ' || SQLERRM(SQLCODE), l_api_name, 1);