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

Line 395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

391: l_temp_str := Substr(l_query_sql, l_last_error_pos-5, 50);
392: IF l_debug = 1 THEN
393: trace('Error in parse sql statement, at '||l_temp_str);
394: END IF;
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: END;
397:
398: IF l_debug =1 THEN
399: trace('Binding variables');

Line 825: x_return_status := fnd_api.G_RET_STS_SUCCESS;

821:
822: trace(' p_is_pjm_enabled_org ='|| p_is_pjm_enabled_org);
823: END IF;
824:
825: x_return_status := fnd_api.G_RET_STS_SUCCESS;
826:
827: /* Step 1, Build Dynamic SQL statement for the query */
828: IF p_subinventory_code IS NOT NULL THEN
829: l_where_str := l_where_str || l_sub_where_str;

Line 1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1005: l_temp_str := Substr(l_query_sql, l_last_error_pos-5, 50);
1006: IF l_debug = 1 THEN
1007: trace('Error in parse sql statement, at '||l_temp_str);
1008: END IF;
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: END;
1011:
1012: l_progress := '040';
1013: IF l_debug =1 THEN

Line 1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1320: WHEN no_data_found THEN
1321: IF l_debug = 1 THEN
1322: trace('No data found in getting shipment line of '||l_material_rec.reference_id);
1323: END IF;
1324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1325: END;
1326:
1327: IF l_req_line_id IS NOT NULL THEN
1328: l_material_rec.document_type := 'REQ';

Line 1340: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1336: ELSE
1337: IF l_debug = 1 THEN
1338: trace('Can not decide document type');
1339: END IF;
1340: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1341: END IF;
1342: ELSE
1343: IF l_debug = 1 THEN
1344: trace('Can not decide document type');

Line 1346: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1342: ELSE
1343: IF l_debug = 1 THEN
1344: trace('Can not decide document type');
1345: END IF;
1346: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1347: END IF;
1348: END IF;
1349: ELSE
1350: l_material_rec.document_type := 'MIXED';

Line 1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1362: IF (l_shipment_num IS NOT NULL) AND (l_shipment_num <> l_material_rec.document_number) THEN
1363: IF l_debug = 1 THEN
1364: trace('l_shipment_num '||l_shipment_num ||' not equal to l_material_rec.document_number '||l_material_rec.document_number);
1365: END IF;
1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1367: END IF;
1368: ELSE
1369: -- Need to derive document number
1370: IF l_shipment_num IS NOT NULL THEN

Line 1387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1383: WHEN no_data_found THEN
1384: IF l_debug = 1 THEN
1385: trace('Can not derive document number for type ASN/INTSHIP and reference_id = '||l_material_rec.reference_id);
1386: END IF;
1387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1388: END;
1389: END IF;
1390: END IF;
1391: END IF;

Line 1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1395: IF (l_line_num IS NOT NULL) AND (l_line_num <> l_material_rec.document_line_num) THEN
1396: IF l_debug = 1 THEN
1397: trace('l_line_num '||l_line_num ||' not equal to l_material_rec.document_line_num '||l_material_rec.document_line_num);
1398: END IF;
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: END IF;
1401: ELSE
1402: -- Need to derive document number
1403: IF l_line_num IS NOT NULL THEN

Line 1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1414: WHEN no_data_found THEN
1415: IF l_debug = 1 THEN
1416: trace('Can not derive document line for type ASN/INTSHIP and reference_id = '||l_material_rec.reference_id);
1417: END IF;
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419: END;
1420: END IF;
1421: END IF;
1422: END IF;

Line 1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1439: WHEN no_data_found THEN
1440: IF l_debug = 1 THEN
1441: trace('Can not derive vendor for type ASN and reference_id = '||l_material_rec.reference_id);
1442: END IF;
1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1444: END;
1445: END IF;
1446: END IF;
1447: END IF;

Line 1459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1455: WHEN no_data_found THEN
1456: IF l_debug = 1 THEN
1457: trace('Can not derive vendor name for type ASN and vendor_id = '||l_material_rec.vendor_id);
1458: END IF;
1459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1460: END;
1461: END IF;
1462: ELSE
1463: -- INTSHIP, get source_org

Line 1478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1474: WHEN no_data_found THEN
1475: IF l_debug = 1 THEN
1476: trace('Can not derive src_org_id for type INTSHIP and reference_id = '||l_material_rec.reference_id);
1477: END IF;
1478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1479: END;
1480: END IF;
1481: END IF;
1482: END IF;

Line 1495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1491: WHEN no_data_found THEN
1492: IF l_debug = 1 THEN
1493: trace('Can not derive src_org name for type INSTHIP and org_id = '||l_material_rec.source_org_id);
1494: END IF;
1495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1496: END;
1497: END IF;
1498: END IF;
1499: END IF;

Line 1521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1517: WHEN no_data_found THEN
1518: IF l_debug = 1 THEN
1519: trace('Can not derive document number for type PO and reference_id = '||l_material_rec.reference_id);
1520: END IF;
1521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1522: END;
1523: END IF;
1524: END IF;
1525:

Line 1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1536: WHEN no_data_found THEN
1537: IF l_debug = 1 THEN
1538: trace('Can not derive document line for type PO and reference_id = '||l_material_rec.reference_id);
1539: END IF;
1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1541: END;
1542: END IF;
1543: END IF;
1544:

Line 1556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1552: WHEN no_data_found THEN
1553: IF l_debug = 1 THEN
1554: trace('Can not derive vendor name for type PO and vendor_id = '||l_material_rec.vendor_id);
1555: END IF;
1556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1557: END;
1558: END IF;
1559:
1560: ELSIF l_material_rec.document_type = 'REQ' THEN

Line 1577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1573: WHEN no_data_found THEN
1574: IF l_debug = 1 THEN
1575: trace('Can not derive document number for type REQ and reference_id = '||l_material_rec.reference_id);
1576: END IF;
1577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1578: END;
1579: END IF;
1580: END IF;
1581:

Line 1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1592: WHEN no_data_found THEN
1593: IF l_debug = 1 THEN
1594: trace('Can not derive document line for type REQ and reference_id = '||l_material_rec.reference_id);
1595: END IF;
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597: END;
1598: END IF;
1599: END IF;
1600:

Line 1613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1609: WHEN no_data_found THEN
1610: IF l_debug = 1 THEN
1611: trace('Can not derive src_org name for type INSTHIP and org_id = '||l_material_rec.source_org_id);
1612: END IF;
1613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1614: END;
1615: END IF;
1616: ELSIF l_material_rec.document_type = 'RMA' THEN
1617: -- Document Number

Line 1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1628: WHEN no_data_found THEN
1629: IF l_debug = 1 THEN
1630: trace('Can not derive document number for type RMA and reference_id='||l_material_rec.reference_id);
1631: END IF;
1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1633: END;
1634: END IF;
1635: END IF;
1636:

Line 1650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1646: WHEN no_data_found THEN
1647: IF l_debug = 1 THEN
1648: trace('Can not derive document line for type RMA and reference_id = '||l_material_rec.reference_id);
1649: END IF;
1650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1651: END;
1652: END IF;
1653: END IF;
1654:

Line 1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1662: WHEN no_data_found THEN
1663: IF l_debug = 1 THEN
1664: trace('Can not derive vendor name for type RMA and vendor_id = '||l_material_rec.vendor_id);
1665: END IF;
1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1667: END;
1668: END IF;
1669: END IF;
1670:

Line 1724: RAISE fnd_api.g_exc_error;

1720: trace('Do not know which one to pick: Return');
1721: END IF;
1722:
1723: CLOSE get_proj_task_rec;
1724: RAISE fnd_api.g_exc_error;
1725:
1726: END IF;
1727:
1728: END LOOP;

Line 1740: WHEN fnd_api.g_exc_error THEN

1736: end if;
1737: */
1738:
1739: EXCEPTION
1740: WHEN fnd_api.g_exc_error THEN
1741: x_return_status := fnd_api.G_RET_STS_ERROR;
1742: IF l_debug = 1 THEN
1743: trace('User defined: Show message: x_return_status :'||x_return_status);
1744: END IF;

Line 1741: x_return_status := fnd_api.G_RET_STS_ERROR;

1737: */
1738:
1739: EXCEPTION
1740: WHEN fnd_api.g_exc_error THEN
1741: x_return_status := fnd_api.G_RET_STS_ERROR;
1742: IF l_debug = 1 THEN
1743: trace('User defined: Show message: x_return_status :'||x_return_status);
1744: END IF;
1745:

Line 1754: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

1750: trace('ERROR MESSAGE = ' || SQLERRM);
1751: END IF;
1752: dbms_sql.close_cursor(l_cursor);
1753:
1754: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1755:
1756: END query_inbound_material;
1757:
1758: /************************************************

Line 2102: x_return_status := fnd_api.G_RET_STS_SUCCESS;

2098: trace(' p_delivery_state='||p_delivery_state);
2099: trace(' p_customer_id='||p_customer_id||', p_customer='||p_customer);
2100: END IF;
2101:
2102: x_return_status := fnd_api.G_RET_STS_SUCCESS;
2103: l_del_count := 0;
2104: l_rec_count := 0;
2105:
2106: delete from wms_packing_material_gtemp;

Line 2536: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

2532: trace('Error in query_outbound_material(), l_progress='||l_progress);
2533: trace('ERROR CODE = ' || SQLCODE);
2534: trace('ERROR MESSAGE = ' || SQLERRM);
2535: END IF;
2536: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2537: END query_outbound_material;
2538:
2539:
2540: FUNCTION get_kit_list(

Line 2670: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

2666: IF l_debug = 1 THEN
2667: trace('ERROR CODE = ' || SQLCODE);
2668: trace('ERROR MESSAGE = ' || SQLERRM);
2669: END IF;
2670: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
2671:
2672: END get_kit_list;
2673:
2674: PROCEDURE insert_kit_info(

Line 2932: x_return_status := FND_API.G_RET_STS_SUCCESS;

2928:
2929: l_return_status VARCHAR2(1);
2930:
2931: BEGIN
2932: x_return_status := FND_API.G_RET_STS_SUCCESS;
2933: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2934:
2935: IF p_source_id = 1 THEN
2936: -- Inbound

Line 3155: x_return_status := fnd_api.G_RET_STS_SUCCESS;

3151: trace(' p_project_id='||p_project_id||', p_task_id='||p_task_id);
3152: trace(' p_grade_code='||p_grade_code);
3153: END IF;
3154:
3155: x_return_status := fnd_api.G_RET_STS_SUCCESS;
3156:
3157: l_new_tolocator_id := p_to_locator_id;
3158: -- Here only those records should be present to process for which there is
3159: -- UNIQUE combination OF projec/task for the item, The restriction

Line 3230: raise fnd_api.g_exc_error;

3226: l_txn_type_id := 88; -- Container Unpack
3227: ELSE
3228: fnd_message.set_name('INV','INV_INT_TRXACTCODE');
3229: fnd_msg_pub.add;
3230: raise fnd_api.g_exc_error;
3231: END IF;
3232:
3233: IF l_debug = 1 THEN
3234: trace('trx action='||l_txn_action_id||',trx type='||l_txn_type_id);

Line 3258: raise fnd_api.g_exc_error;

3254: IF l_return_status <> 'S' THEN
3255: IF l_debug = 1 THEN
3256: trace('Error in process transaction for hdr_id='||p_transaction_header_id||',l_msg_data='||l_msg_data);
3257: END IF;
3258: raise fnd_api.g_exc_error;
3259: ELSE
3260: IF l_debug = 1 THEN
3261: trace('transaction processed successfully, hdr_id ='||p_transaction_header_id);
3262: END IF;

Line 3302: raise fnd_api.g_exc_error;

3298: IF l_debug = 1 THEN
3299: trace('Error when inserting MMTT for content lpn ID '|| p_content_lpn_id|| 'err is '||l_proc_msg);
3300: END IF;
3301: x_proc_msg := l_proc_msg;
3302: raise fnd_api.g_exc_error;
3303: END IF;
3304:
3305: IF l_debug = 1 THEN
3306: trace('MMTT inserted, tmp_id='||l_txn_tmp_id);

Line 3326: raise fnd_api.g_exc_error;

3322: IF l_return_status <> 'S' THEN
3323: IF l_debug = 1 THEN
3324: trace('Error in process transaction for hdr_id='||l_txn_hdr_id||',tmp_id='||l_txn_tmp_id ||',l_msg_data='||l_msg_data);
3325: END IF;
3326: raise fnd_api.g_exc_error;
3327: ELSE
3328: IF l_debug = 1 THEN
3329: trace('transaction processed successfully, txn_temp_id ='||l_txn_tmp_id);
3330: END IF;

Line 3367: raise fnd_api.g_exc_error;

3363: IF l_return_status <> 'S' THEN
3364: IF l_debug = 1 THEN
3365: trace('Error in process transaction for hdr_id='||p_transaction_header_id||',l_msg_data='||l_msg_data);
3366: END IF;
3367: raise fnd_api.g_exc_error;
3368: ELSE
3369: IF l_debug = 1 THEN
3370: trace('transaction processed successfully, hdr_id='||p_transaction_header_id);
3371: END IF;

Line 3424: raise fnd_api.g_exc_error;

3420: , l_mol_inspection_status;
3421: IF inb_cur%NOTFOUND THEN
3422: fnd_message.set_name('WMS','WMS_NO_ELIGIBLE_MATERIAL');
3423: fnd_msg_pub.add;
3424: raise fnd_api.g_exc_error;
3425: END IF;
3426:
3427: LOOP
3428: IF inb_cur%NOTFOUND THEN

Line 3492: raise fnd_api.g_exc_error;

3488: IF l_available_qty < p_primary_qty THEN
3489: l_mol_list := l_null_mol_list;
3490: fnd_message.set_name('WMS','WMS_NO_ELIGIBLE_MATERIAL');
3491: fnd_msg_pub.add;
3492: raise fnd_api.g_exc_error;
3493: END IF;
3494: IF l_debug = 1 THEN
3495: trace('Found move order lines to fulfill transactions, number of records:'||l_mol_list.count);
3496: END IF;

Line 3571: raise fnd_api.g_exc_error;

3567: IF l_debug = 1 THEN
3568: trace('Error when inserting MMTT for move order line id:'||l_mol_list(i).move_order_line_id || 'err is '||l_proc_msg);
3569: END IF;
3570: x_proc_msg := l_proc_msg;
3571: raise fnd_api.g_exc_error;
3572: END IF;
3573:
3574: IF l_txn_hdr_id IS NULL THEN
3575: l_txn_hdr_id := l_txn_tmp_id;

Line 3642: raise fnd_api.g_exc_error;

3638: IF l_debug = 1 THEN
3639: trace('Error when inserting MTLT for lot:'||p_lot_number||',l_proc_msg='||l_proc_msg);
3640: END IF;
3641: x_proc_msg := l_proc_msg;
3642: raise fnd_api.g_exc_error;
3643: END IF;
3644: IF l_debug = 1 THEN
3645: trace('MTLT record inserted for lot(no attr):'||p_lot_number||',ser_txn_id='||l_ser_txn_id);
3646: END IF;

Line 3740: raise fnd_api.g_exc_error;

3736: IF l_debug = 1 THEN
3737: trace('Error when inserting MTLT for lot:'||p_lot_number||',l_proc_msg='||l_proc_msg);
3738: END IF;
3739: x_proc_msg := l_proc_msg;
3740: raise fnd_api.g_exc_error;
3741: END IF;
3742: IF l_debug = 1 THEN
3743: trace('MTLT record inserted for lot(with attr):'||p_lot_number||',ser_txn_id='||l_ser_txn_id);
3744: END IF;

Line 3797: raise fnd_api.g_exc_error;

3793: IF l_debug = 1 THEN
3794: trace('Error when inserting MSNT for serial(no attr):'||p_fm_serial_number||',l_proc_msg='||l_proc_msg);
3795: END IF;
3796: x_proc_msg := l_proc_msg;
3797: raise fnd_api.g_exc_error;
3798: END IF;
3799: IF l_debug = 1 THEN
3800: trace('MSNT record inserted for serial(no attr):'||p_fm_serial_number||',ser_txn_id='||nvl(l_ser_txn_id,l_txn_tmp_id));
3801: END IF;

Line 3870: raise fnd_api.g_exc_error;

3866: IF l_debug = 1 THEN
3867: trace('Error when inserting MSNT for serial:'||p_fm_serial_number||',l_proc_msg='||l_proc_msg);
3868: END IF;
3869: x_proc_msg := l_proc_msg;
3870: raise fnd_api.g_exc_error;
3871: END IF;
3872: trace('MSNT record inserted for serial(with attr):'||p_fm_serial_number||',ser_txn_id='||nvl(l_ser_txn_id,l_txn_tmp_id));
3873:
3874: END IF;

Line 3892: raise fnd_api.g_exc_error;

3888: WHEN others THEN
3889: IF l_debug = 1 THEN
3890: trace('Error when update MSN with group_mark_id='||l_txn_tmp_id||',SN='||p_fm_serial_number);
3891: END IF;
3892: raise fnd_api.g_exc_error;
3893: END;
3894:
3895: END IF;
3896: -- Mark WMS_PROCESS_FLAG for the move order line

Line 3906: raise fnd_api.g_exc_error;

3902: WHEN others THEN
3903: IF l_debug = 1 THEN
3904: trace('Error when updating wms_process_flag for mo line:'||l_mol_list(i).move_order_line_id);
3905: END IF;
3906: raise fnd_api.g_exc_error;
3907: END;
3908:
3909: x_transaction_header_id := l_txn_hdr_id;
3910: x_transaction_temp_id := l_txn_tmp_id;

Line 3927: raise fnd_api.g_exc_error;

3923: WHEN others THEN
3924: IF l_debug = 1 THEN
3925: trace('Error when updating MMTT rec,tmp_id='||p_transaction_temp_id);
3926: END IF;
3927: raise fnd_api.g_exc_error;
3928: END;
3929: IF l_debug = 1 THEN
3930: trace('MMTT updated for tmp_id '||p_transaction_temp_id);
3931: END IF;

Line 3950: raise fnd_api.g_exc_error;

3946: WHEN others THEN
3947: IF l_debug = 1 THEN
3948: trace('Error when updating MTLT rec,tmp_id='||p_transaction_temp_id);
3949: END IF;
3950: raise fnd_api.g_exc_error;
3951: END;
3952: IF l_debug = 1 THEN
3953: trace('MTLT updated for tmp_id '||p_transaction_temp_id);
3954: END IF;

Line 4006: raise fnd_api.g_exc_error;

4002: IF l_debug = 1 THEN
4003: trace('Error when inserting MSNT for serial(no attr):'||p_fm_serial_number||',l_proc_msg='||l_proc_msg);
4004: END IF;
4005: x_proc_msg := l_proc_msg;
4006: raise fnd_api.g_exc_error;
4007: END IF;
4008: IF l_debug = 1 THEN
4009: trace('MSNT record inserted for serial(no attr):'||p_fm_serial_number||',ser_txn_id='||nvl(l_ser_txn_id,l_txn_tmp_id));
4010: END IF;

Line 4079: raise fnd_api.g_exc_error;

4075: IF l_debug = 1 THEN
4076: trace('Error when inserting MSNT for serial(with attr):'||p_fm_serial_number||',l_proc_msg='||l_proc_msg);
4077: END IF;
4078: x_proc_msg := l_proc_msg;
4079: raise fnd_api.g_exc_error;
4080: END IF;
4081: trace('MSNT record inserted for serial(with attr):'||p_fm_serial_number||',ser_txn_id='||nvl(l_ser_txn_id,l_txn_tmp_id));
4082: END IF;
4083: /* l_insert := inv_trx_util_pub.insert_ser_trx(

Line 4095: raise fnd_api.g_exc_error;

4091: IF l_debug = 1 THEN
4092: trace('Error when inserting MSNT for serial:'||p_fm_serial_number||',l_proc_msg='||l_proc_msg);
4093: END IF;
4094: x_proc_msg := l_proc_msg;
4095: raise fnd_api.g_exc_error;
4096: END IF;
4097: IF l_debug = 1 THEN
4098: trace('MSNT record inserted for serial:'||p_fm_serial_number||',ser_txn_id='||
4099: nvl(l_cur_rec.serial_transaction_temp_id, p_transaction_temp_id));

Line 4119: raise fnd_api.g_exc_error;

4115: WHEN others THEN
4116: IF l_debug = 1 THEN
4117: trace('Error when update MSN with group_mark_id='||l_txn_tmp_id||',SN='||p_fm_serial_number);
4118: END IF;
4119: raise fnd_api.g_exc_error;
4120: END;
4121:
4122: END IF; -- END SN is not null
4123: x_transaction_header_id := p_transaction_header_id;

Line 4148: raise fnd_api.g_exc_error;

4144: WHEN others THEN
4145: IF l_debug = 1 THEN
4146: trace('Error when updating wms_packing_material_gtemp for mol:'||l_mol_list(i).move_order_line_id);
4147: END IF;
4148: raise fnd_api.g_exc_error;
4149: END;
4150:
4151: END LOOP; -- Move order lines loop
4152:

Line 4157: raise fnd_api.g_exc_error;

4153: ELSE
4154: IF l_debug = 1 THEN
4155: trace('Content has to be either lpn or item');
4156: END IF;
4157: raise fnd_api.g_exc_error;
4158: END IF;
4159:
4160:
4161: ELSIF p_source = 2 THEN

Line 4217: raise fnd_api.g_exc_error;

4213: l_txn_type_id := 88;
4214: ELSE
4215: fnd_message.set_name('INV','INV_INT_TRXACTCODE');
4216: fnd_msg_pub.add;
4217: raise fnd_api.g_exc_error;
4218: END IF;
4219: ELSE
4220: -- There is move happens
4221: -- Use subinventory transfer

Line 4295: raise fnd_api.g_exc_error;

4291: IF l_debug = 1 THEN
4292: trace('Error when inserting MMTT for content lpn ID:'||p_content_lpn_id|| 'err is '||l_proc_msg);
4293: END IF;
4294: x_proc_msg := l_proc_msg;
4295: raise fnd_api.g_exc_error;
4296: END IF;
4297:
4298: IF l_debug = 1 THEN
4299: trace('MMTT inserted, hdr_id='||l_txn_hdr_id|| ',tmp_id='||l_txn_tmp_id);

Line 4321: raise fnd_api.g_exc_error;

4317: IF l_debug = 1 THEN
4318: trace('Error when deleting from wms_packing_material_gtemp for content lpn '||p_content_lpn_id);
4319: END IF;
4320: x_proc_msg := l_proc_msg;
4321: raise fnd_api.g_exc_error;
4322: END;
4323:
4324: ELSIF p_inventory_item_id IS NOT NULL THEN
4325: -- Content is Item

Line 4386: raise fnd_api.g_exc_error;

4382: IF l_debug = 1 THEN
4383: trace('Error when inserting MMTT for item id:'||p_inventory_item_id|| 'err is '||l_proc_msg);
4384: END IF;
4385: x_proc_msg := l_proc_msg;
4386: raise fnd_api.g_exc_error;
4387: END IF;
4388:
4389: IF l_debug = 1 THEN
4390: trace('MMTT inserted, tmp_id='||l_txn_tmp_id);

Line 4408: raise fnd_api.g_exc_error;

4404: WHEN others THEN
4405: IF l_debug = 1 THEN
4406: trace('Error when updating MMTT rec,tmp_id='||p_transaction_temp_id);
4407: END IF;
4408: raise fnd_api.g_exc_error;
4409: END;
4410: IF l_debug = 1 THEN
4411: trace('MMTT updated for tmp_id '||p_transaction_temp_id);
4412: END IF;

Line 4437: raise fnd_api.g_exc_error;

4433: IF l_debug = 1 THEN
4434: trace('Error when inserting MTLT for lot:'||p_lot_number||',l_proc_msg='||l_proc_msg);
4435: END IF;
4436: x_proc_msg := l_proc_msg;
4437: raise fnd_api.g_exc_error;
4438: END IF;
4439: IF l_debug = 1 THEN
4440: trace('MTLT record inserted for lot:'||p_lot_number||',ser_txn_id='||l_ser_txn_id);
4441: END IF;

Line 4460: raise fnd_api.g_exc_error;

4456: IF l_debug = 1 THEN
4457: trace('Error when inserting MSNT for fm_serial:'||p_fm_serial_number||',to_serial:'||p_to_serial_number||',l_proc_msg='||l_proc_msg);
4458: END IF;
4459: x_proc_msg := l_proc_msg;
4460: raise fnd_api.g_exc_error;
4461: END IF;
4462: IF l_debug = 1 THEN
4463: trace('MSNT record inserted for fm_serial:'||p_fm_serial_number||',to_serial:'||p_to_serial_number||',ser_txn_id='||l_ser_txn_id);
4464: END IF;

Line 4571: raise fnd_api.g_exc_error;

4567: trace('Error when updating wms_packing_material_gtemp for item, only one record should be updated');
4568: END IF;
4569: fnd_message.set_name('INV','INV_FAILED');
4570: fnd_msg_pub.add;
4571: raise fnd_api.g_exc_error;
4572: ELSE
4573: IF l_debug = 1 THEN
4574: trace('wms_packing_material_gtemp updated, row_count='||l_row_count);
4575: END IF;

Line 4584: raise fnd_api.g_exc_error;

4580: trace('Error when updating wms_packing_material_gtemp for item '||p_inventory_item_id);
4581: END IF;
4582: fnd_message.set_name('INV','INV_FAILED');
4583: fnd_msg_pub.add;
4584: raise fnd_api.g_exc_error;
4585: END;
4586: */
4587: --End Commented out Bug 6028098
4588:

Line 4607: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

4603: trace('Other errors in create_txn');
4604: trace('ERROR Code ='||SQLCODE);
4605: trace('ERROR Message='||SQLERRM);
4606: END IF;
4607: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
4608: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data, p_encoded => 'F');
4609: IF (l_msg_count = 1) THEN
4610: x_proc_msg := x_proc_msg || l_msg_data;
4611: ELSIF (l_msg_count > 1) THEN

Line 4651: x_return_status := fnd_api.G_RET_STS_SUCCESS;

4647: l_sec_uom VARCHAR2(3); --INCONV kkillams
4648: l_progress VARCHAR2(20);
4649:
4650: BEGIN
4651: x_return_status := fnd_api.G_RET_STS_SUCCESS;
4652: IF l_debug = 1 THEN
4653: trace('In wms_packing_workbench_pvt.delete_txn');
4654: trace(', p_transaction_header_id = '||p_transaction_header_id||',p_transaction_temp_id='||p_transaction_temp_id);
4655: trace(', p_lot_number='||p_lot_number||', p_serial_number='||p_serial_number);

Line 4749: RAISE fnd_api.g_exc_error;

4745: trace(l_row_count||' rows of MMTT deleted with tmp_id '||p_transaction_temp_id);
4746: END IF;
4747: l_progress := '011';
4748: IF l_row_count <> 1 THEN
4749: RAISE fnd_api.g_exc_error;
4750: END IF;
4751: ELSE
4752:
4753: IF p_serial_number IS NOT NULL THEN

Line 4766: RAISE fnd_api.g_exc_error;

4762: END IF;
4763: l_progress := '013';
4764:
4765: IF l_row_count <> 1 THEN
4766: RAISE fnd_api.g_exc_error;
4767: END IF;
4768: END IF;
4769:
4770: IF p_lot_number IS NOT NULL THEN

Line 4782: RAISE fnd_api.g_exc_error;

4778: END IF;
4779: l_progress := '015';
4780:
4781: IF l_row_count <> 1 THEN
4782: RAISE fnd_api.g_exc_error;
4783: END IF;
4784: ELSIF l_mtlt_qty > abs(p_quantity) THEN
4785: -- Update MTLT
4786: UPDATE mtl_transaction_lots_temp

Line 4798: RAISE fnd_api.g_exc_error;

4794: END IF;
4795: l_progress := '017';
4796:
4797: IF l_row_count <> 1 THEN
4798: RAISE fnd_api.g_exc_error;
4799: END IF;
4800: ELSE
4801: IF l_debug = 1 THEN
4802: trace('mtlt quantity can not be less than p_quantity');

Line 4804: RAISE fnd_api.g_exc_error;

4800: ELSE
4801: IF l_debug = 1 THEN
4802: trace('mtlt quantity can not be less than p_quantity');
4803: END IF;
4804: RAISE fnd_api.g_exc_error;
4805: END IF;
4806: END IF;
4807:
4808: -- MMTT

Line 4820: RAISE fnd_api.g_exc_error;

4816: END IF;
4817: l_progress := '019';
4818:
4819: IF l_row_count <> 1 THEN
4820: RAISE fnd_api.g_exc_error;
4821: END IF;
4822: ELSIF l_mmtt_qty > abs(p_quantity) THEN
4823: UPDATE mtl_material_transactions_temp
4824: SET primary_quantity = primary_quantity - abs(p_quantity)

Line 4842: RAISE fnd_api.g_exc_error;

4838: trace(l_row_count||' rows of MMTT updated with tmp_id '||p_transaction_temp_id);
4839: END IF;
4840: l_progress := '021';
4841: IF l_row_count <> 1 THEN
4842: RAISE fnd_api.g_exc_error;
4843: END IF;
4844: ELSE
4845: IF l_debug = 1 THEN
4846: trace('mmtt quantity can not be less than p_quantity');

Line 4848: RAISE fnd_api.g_exc_error;

4844: ELSE
4845: IF l_debug = 1 THEN
4846: trace('mmtt quantity can not be less than p_quantity');
4847: END IF;
4848: RAISE fnd_api.g_exc_error;
4849: END IF;
4850:
4851: END IF;
4852:

Line 4855: x_return_status := fnd_api.G_RET_STS_ERROR;

4851: END IF;
4852:
4853: EXCEPTION
4854: WHEN others THEN
4855: x_return_status := fnd_api.G_RET_STS_ERROR;
4856: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4857: IF l_debug = 1 THEN
4858: trace('Error in delete_txn(), progress='||l_progress);
4859: trace('ERROR Code ='||SQLCODE);

Line 4901: raise fnd_api.g_exc_error;

4897: IF l_debug = 1 THEN
4898: trace('Called WMS_RCV_PUP_PVT.pack_unpack_split API, return_status='||l_return_status||',msg_count='||l_msg_count||',msg_data='||l_msg_data);
4899: END IF;
4900: IF l_return_status <> 'S' THEN
4901: raise fnd_api.g_exc_error;
4902: ELSE
4903: x_return_status := fnd_api.G_RET_STS_SUCCESS;
4904: x_proc_msg := NULL;
4905: END IF;

Line 4903: x_return_status := fnd_api.G_RET_STS_SUCCESS;

4899: END IF;
4900: IF l_return_status <> 'S' THEN
4901: raise fnd_api.g_exc_error;
4902: ELSE
4903: x_return_status := fnd_api.G_RET_STS_SUCCESS;
4904: x_proc_msg := NULL;
4905: END IF;
4906: ELSE
4907: -- Outbound

Line 4921: x_return_status := fnd_api.G_RET_STS_SUCCESS;

4917: IF l_debug = 1 THEN
4918: trace('called INV_LPN_TRX_PUB.PROCESS_LPN_TRX , l_return='||l_return||',l_proc_msg='||l_proc_msg);
4919: END IF;
4920: IF l_return = 0 THEN
4921: x_return_status := fnd_api.G_RET_STS_SUCCESS;
4922: x_proc_msg := null;
4923: ELSE
4924: x_return_status := fnd_api.G_RET_STS_ERROR;
4925: x_proc_msg := l_proc_msg;

Line 4924: x_return_status := fnd_api.G_RET_STS_ERROR;

4920: IF l_return = 0 THEN
4921: x_return_status := fnd_api.G_RET_STS_SUCCESS;
4922: x_proc_msg := null;
4923: ELSE
4924: x_return_status := fnd_api.G_RET_STS_ERROR;
4925: x_proc_msg := l_proc_msg;
4926: END IF;
4927:
4928: END IF;

Line 4932: x_return_status := fnd_api.G_RET_STS_ERROR;

4928: END IF;
4929:
4930: EXCEPTION
4931: WHEN others THEN
4932: x_return_status := fnd_api.G_RET_STS_ERROR;
4933: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data, p_encoded => 'F');
4934: IF (l_msg_count = 1) THEN
4935: x_proc_msg := l_msg_data;
4936: ELSIF (l_msg_count > 1) THEN

Line 4977: p_init_msg_list => fnd_api.g_false,

4973: l_delivery_id_tab(1) := p_delivery_id;
4974:
4975: WSH_INTERFACE_EXT_GRP.Delivery_Action
4976: (p_api_version_number => 1.0,
4977: p_init_msg_list => fnd_api.g_false,
4978: p_commit => fnd_api.g_false,
4979: p_action_prms => l_action_prms,
4980: p_delivery_id_tab => l_delivery_id_tab,
4981: x_delivery_out_rec => l_delivery_out_rec,

Line 4978: p_commit => fnd_api.g_false,

4974:
4975: WSH_INTERFACE_EXT_GRP.Delivery_Action
4976: (p_api_version_number => 1.0,
4977: p_init_msg_list => fnd_api.g_false,
4978: p_commit => fnd_api.g_false,
4979: p_action_prms => l_action_prms,
4980: p_delivery_id_tab => l_delivery_id_tab,
4981: x_delivery_out_rec => l_delivery_out_rec,
4982: x_return_status => l_return_status,

Line 5416: x_return_status := fnd_api.G_RET_STS_SUCCESS;

5412: BEGIN
5413: IF l_debug = 1 THEN
5414: trace('In get_kitting_info, p_org_id='||p_organization_id||',p_item_id='||p_inventory_item_id||',p_qty='||p_quantity);
5415: END IF;
5416: x_return_status := fnd_api.G_RET_STS_SUCCESS;
5417: -- First get the list of kits that the item belongs to
5418: l_kit_list := get_kit_list(p_organization_id, p_inventory_item_id, 'N');
5419:
5420: l_new_inserted_kit_cnt := 0;