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 426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

422: l_temp_str := Substr(l_query_sql, l_last_error_pos-5, 50);
423: IF l_debug = 1 THEN
424: trace('Error in parse sql statement, at '||l_temp_str);
425: END IF;
426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: END;
428:
429: IF l_debug =1 THEN
430: trace('Binding variables');

Line 886: x_return_status := fnd_api.G_RET_STS_SUCCESS;

882:
883: trace(' p_is_pjm_enabled_org ='|| p_is_pjm_enabled_org);
884: END IF;
885:
886: x_return_status := fnd_api.G_RET_STS_SUCCESS;
887:
888: /* Step 1, Build Dynamic SQL statement for the query */
889: IF p_subinventory_code IS NOT NULL THEN
890: l_where_str := l_where_str || l_sub_where_str;

Line 1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1066: l_temp_str := Substr(l_query_sql, l_last_error_pos-5, 50);
1067: IF l_debug = 1 THEN
1068: trace('Error in parse sql statement, at '||l_temp_str);
1069: END IF;
1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1071: END;
1072:
1073: l_progress := '040';
1074: IF l_debug =1 THEN

Line 1387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1383: WHEN no_data_found THEN
1384: IF l_debug = 1 THEN
1385: trace('No data found in getting shipment line of '||l_material_rec.reference_id);
1386: END IF;
1387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1388: END;
1389:
1390: IF l_req_line_id IS NOT NULL THEN
1391: l_material_rec.document_type := 'REQ';

Line 1403: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1399: ELSE
1400: IF l_debug = 1 THEN
1401: trace('Can not decide document type');
1402: END IF;
1403: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1404: END IF;
1405: ELSE
1406: IF l_debug = 1 THEN
1407: trace('Can not decide document type');

Line 1409: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1405: ELSE
1406: IF l_debug = 1 THEN
1407: trace('Can not decide document type');
1408: END IF;
1409: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1410: END IF;
1411: END IF;
1412: ELSE
1413: l_material_rec.document_type := 'MIXED';

Line 1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1425: IF (l_shipment_num IS NOT NULL) AND (l_shipment_num <> l_material_rec.document_number) THEN
1426: IF l_debug = 1 THEN
1427: trace('l_shipment_num '||l_shipment_num ||' not equal to l_material_rec.document_number '||l_material_rec.document_number);
1428: END IF;
1429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1430: END IF;
1431: ELSE
1432: -- Need to derive document number
1433: IF l_shipment_num IS NOT NULL THEN

Line 1450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1446: WHEN no_data_found THEN
1447: IF l_debug = 1 THEN
1448: trace('Can not derive document number for type ASN/INTSHIP and reference_id = '||l_material_rec.reference_id);
1449: END IF;
1450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1451: END;
1452: END IF;
1453: END IF;
1454: END IF;

Line 1462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1458: IF (l_line_num IS NOT NULL) AND (l_line_num <> l_material_rec.document_line_num) THEN
1459: IF l_debug = 1 THEN
1460: trace('l_line_num '||l_line_num ||' not equal to l_material_rec.document_line_num '||l_material_rec.document_line_num);
1461: END IF;
1462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1463: END IF;
1464: ELSE
1465: -- Need to derive document number
1466: IF l_line_num IS NOT NULL THEN

Line 1481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1477: WHEN no_data_found THEN
1478: IF l_debug = 1 THEN
1479: trace('Can not derive document line for type ASN/INTSHIP and reference_id = '||l_material_rec.reference_id);
1480: END IF;
1481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1482: END;
1483: END IF;
1484: END IF;
1485: END IF;

Line 1506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1502: WHEN no_data_found THEN
1503: IF l_debug = 1 THEN
1504: trace('Can not derive vendor for type ASN and reference_id = '||l_material_rec.reference_id);
1505: END IF;
1506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1507: END;
1508: END IF;
1509: END IF;
1510: END IF;

Line 1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1518: WHEN no_data_found THEN
1519: IF l_debug = 1 THEN
1520: trace('Can not derive vendor name for type ASN and vendor_id = '||l_material_rec.vendor_id);
1521: END IF;
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1523: END;
1524: END IF;
1525: ELSE
1526: -- INTSHIP, get source_org

Line 1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1554: WHEN no_data_found THEN
1555: IF l_debug = 1 THEN
1556: trace('Can not derive src_org name for type INSTHIP and org_id = '||l_material_rec.source_org_id);
1557: END IF;
1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1559: END;
1560: END IF;
1561: END IF;
1562: END IF;

Line 1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1580: WHEN no_data_found THEN
1581: IF l_debug = 1 THEN
1582: trace('Can not derive document number for type PO and reference_id = '||l_material_rec.reference_id);
1583: END IF;
1584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1585: END;
1586: END IF;
1587: END IF;
1588:

Line 1603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1599: WHEN no_data_found THEN
1600: IF l_debug = 1 THEN
1601: trace('Can not derive document line for type PO and reference_id = '||l_material_rec.reference_id);
1602: END IF;
1603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1604: END;
1605: END IF;
1606: END IF;
1607:

Line 1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1615: WHEN no_data_found THEN
1616: IF l_debug = 1 THEN
1617: trace('Can not derive vendor name for type PO and vendor_id = '||l_material_rec.vendor_id);
1618: END IF;
1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1620: END;
1621: END IF;
1622:
1623: --14274513

Line 1648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1663: WHEN no_data_found THEN
1664: IF l_debug = 1 THEN
1665: trace('Can not derive document line for type REQ and reference_id = '||l_material_rec.reference_id);
1666: END IF;
1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1668: END;
1669: END IF;
1670: END IF;
1671:

Line 1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1680: WHEN no_data_found THEN
1681: IF l_debug = 1 THEN
1682: trace('Can not derive src_org name for type INSTHIP and org_id = '||l_material_rec.source_org_id);
1683: END IF;
1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1685: END;
1686: END IF;
1687: ELSIF l_material_rec.document_type = 'RMA' THEN
1688: -- Document Number

Line 1703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1699: WHEN no_data_found THEN
1700: IF l_debug = 1 THEN
1701: trace('Can not derive document number for type RMA and reference_id='||l_material_rec.reference_id);
1702: END IF;
1703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1704: END;
1705: END IF;
1706: END IF;
1707:

Line 1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1717: WHEN no_data_found THEN
1718: IF l_debug = 1 THEN
1719: trace('Can not derive document line for type RMA and reference_id = '||l_material_rec.reference_id);
1720: END IF;
1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1722: END;
1723: END IF;
1724: END IF;
1725:

Line 1737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1733: WHEN no_data_found THEN
1734: IF l_debug = 1 THEN
1735: trace('Can not derive vendor name for type RMA and vendor_id = '||l_material_rec.vendor_id);
1736: END IF;
1737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1738: END;
1739: END IF;
1740: END IF;
1741:

Line 1795: RAISE fnd_api.g_exc_error;

1791: trace('Do not know which one to pick: Return');
1792: END IF;
1793:
1794: CLOSE get_proj_task_rec;
1795: RAISE fnd_api.g_exc_error;
1796:
1797: END IF;
1798:
1799: END LOOP;

Line 1811: WHEN fnd_api.g_exc_error THEN

1807: end if;
1808: */
1809:
1810: EXCEPTION
1811: WHEN fnd_api.g_exc_error THEN
1812: x_return_status := fnd_api.G_RET_STS_ERROR;
1813: IF l_debug = 1 THEN
1814: trace('User defined: Show message: x_return_status :'||x_return_status);
1815: END IF;

Line 1812: x_return_status := fnd_api.G_RET_STS_ERROR;

1808: */
1809:
1810: EXCEPTION
1811: WHEN fnd_api.g_exc_error THEN
1812: x_return_status := fnd_api.G_RET_STS_ERROR;
1813: IF l_debug = 1 THEN
1814: trace('User defined: Show message: x_return_status :'||x_return_status);
1815: END IF;
1816:

Line 1825: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

1821: trace('ERROR MESSAGE = ' || SQLERRM);
1822: END IF;
1823: dbms_sql.close_cursor(l_cursor);
1824:
1825: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1826:
1827: END query_inbound_material;
1828:
1829: /************************************************

Line 2175: x_return_status := fnd_api.G_RET_STS_SUCCESS;

2171: trace(' p_delivery_state='||p_delivery_state);
2172: trace(' p_customer_id='||p_customer_id||', p_customer='||p_customer);
2173: END IF;
2174:
2175: x_return_status := fnd_api.G_RET_STS_SUCCESS;
2176: l_del_count := 0;
2177: l_rec_count := 0;
2178:
2179: delete from wms_packing_material_gtemp;

Line 2609: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

2605: trace('Error in query_outbound_material(), l_progress='||l_progress);
2606: trace('ERROR CODE = ' || SQLCODE);
2607: trace('ERROR MESSAGE = ' || SQLERRM);
2608: END IF;
2609: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2610: END query_outbound_material;
2611:
2612:
2613: FUNCTION get_kit_list(

Line 2743: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

2739: IF l_debug = 1 THEN
2740: trace('ERROR CODE = ' || SQLCODE);
2741: trace('ERROR MESSAGE = ' || SQLERRM);
2742: END IF;
2743: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
2744:
2745: END get_kit_list;
2746:
2747: PROCEDURE insert_kit_info(

Line 3005: x_return_status := FND_API.G_RET_STS_SUCCESS;

3001:
3002: l_return_status VARCHAR2(1);
3003:
3004: BEGIN
3005: x_return_status := FND_API.G_RET_STS_SUCCESS;
3006: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3007:
3008: IF p_source_id = 1 THEN
3009: -- Inbound

Line 3321: x_return_status := fnd_api.G_RET_STS_SUCCESS;

3317: trace(' p_project_id='||p_project_id||', p_task_id='||p_task_id);
3318: trace(' p_grade_code='||p_grade_code);
3319: END IF;
3320:
3321: x_return_status := fnd_api.G_RET_STS_SUCCESS;
3322:
3323: l_new_tolocator_id := p_to_locator_id;
3324: -- Here only those records should be present to process for which there is
3325: -- UNIQUE combination OF projec/task for the item, The restriction

Line 3396: raise fnd_api.g_exc_error;

3392: l_txn_type_id := 88; -- Container Unpack
3393: ELSE
3394: fnd_message.set_name('INV','INV_INT_TRXACTCODE');
3395: fnd_msg_pub.add;
3396: raise fnd_api.g_exc_error;
3397: END IF;
3398:
3399: IF l_debug = 1 THEN
3400: trace('trx action='||l_txn_action_id||',trx type='||l_txn_type_id);

Line 3424: raise fnd_api.g_exc_error;

3420: IF l_return_status <> 'S' THEN
3421: IF l_debug = 1 THEN
3422: trace('Error in process transaction for hdr_id='||p_transaction_header_id||',l_msg_data='||l_msg_data);
3423: END IF;
3424: raise fnd_api.g_exc_error;
3425: ELSE
3426: IF l_debug = 1 THEN
3427: trace('transaction processed successfully, hdr_id ='||p_transaction_header_id);
3428: END IF;

Line 3468: raise fnd_api.g_exc_error;

3464: IF l_debug = 1 THEN
3465: trace('Error when inserting MMTT for content lpn ID '|| p_content_lpn_id|| 'err is '||l_proc_msg);
3466: END IF;
3467: x_proc_msg := l_proc_msg;
3468: raise fnd_api.g_exc_error;
3469: END IF;
3470:
3471: IF l_debug = 1 THEN
3472: trace('MMTT inserted, tmp_id='||l_txn_tmp_id);

Line 3492: raise fnd_api.g_exc_error;

3488: IF l_return_status <> 'S' THEN
3489: IF l_debug = 1 THEN
3490: trace('Error in process transaction for hdr_id='||l_txn_hdr_id||',tmp_id='||l_txn_tmp_id ||',l_msg_data='||l_msg_data);
3491: END IF;
3492: raise fnd_api.g_exc_error;
3493: ELSE
3494: IF l_debug = 1 THEN
3495: trace('transaction processed successfully, txn_temp_id ='||l_txn_tmp_id);
3496: END IF;

Line 3533: raise fnd_api.g_exc_error;

3529: IF l_return_status <> 'S' THEN
3530: IF l_debug = 1 THEN
3531: trace('Error in process transaction for hdr_id='||p_transaction_header_id||',l_msg_data='||l_msg_data);
3532: END IF;
3533: raise fnd_api.g_exc_error;
3534: ELSE
3535: IF l_debug = 1 THEN
3536: trace('transaction processed successfully, hdr_id='||p_transaction_header_id);
3537: END IF;

Line 3590: raise fnd_api.g_exc_error;

3586: , l_mol_inspection_status;
3587: IF inb_cur%NOTFOUND THEN
3588: fnd_message.set_name('WMS','WMS_NO_ELIGIBLE_MATERIAL');
3589: fnd_msg_pub.add;
3590: raise fnd_api.g_exc_error;
3591: END IF;
3592:
3593: LOOP
3594: IF inb_cur%NOTFOUND THEN

Line 3658: raise fnd_api.g_exc_error;

3654: IF l_available_qty < p_primary_qty THEN
3655: l_mol_list := l_null_mol_list;
3656: fnd_message.set_name('WMS','WMS_NO_ELIGIBLE_MATERIAL');
3657: fnd_msg_pub.add;
3658: raise fnd_api.g_exc_error;
3659: END IF;
3660: IF l_debug = 1 THEN
3661: trace('Found move order lines to fulfill transactions, number of records:'||l_mol_list.count);
3662: END IF;

Line 3737: raise fnd_api.g_exc_error;

3733: IF l_debug = 1 THEN
3734: trace('Error when inserting MMTT for move order line id:'||l_mol_list(i).move_order_line_id || 'err is '||l_proc_msg);
3735: END IF;
3736: x_proc_msg := l_proc_msg;
3737: raise fnd_api.g_exc_error;
3738: END IF;
3739:
3740: IF l_txn_hdr_id IS NULL THEN
3741: l_txn_hdr_id := l_txn_tmp_id;

Line 3808: raise fnd_api.g_exc_error;

3804: IF l_debug = 1 THEN
3805: trace('Error when inserting MTLT for lot:'||p_lot_number||',l_proc_msg='||l_proc_msg);
3806: END IF;
3807: x_proc_msg := l_proc_msg;
3808: raise fnd_api.g_exc_error;
3809: END IF;
3810: IF l_debug = 1 THEN
3811: trace('MTLT record inserted for lot(no attr):'||p_lot_number||',ser_txn_id='||l_ser_txn_id);
3812: END IF;

Line 3906: raise fnd_api.g_exc_error;

3902: IF l_debug = 1 THEN
3903: trace('Error when inserting MTLT for lot:'||p_lot_number||',l_proc_msg='||l_proc_msg);
3904: END IF;
3905: x_proc_msg := l_proc_msg;
3906: raise fnd_api.g_exc_error;
3907: END IF;
3908: IF l_debug = 1 THEN
3909: trace('MTLT record inserted for lot(with attr):'||p_lot_number||',ser_txn_id='||l_ser_txn_id);
3910: END IF;

Line 3963: raise fnd_api.g_exc_error;

3959: IF l_debug = 1 THEN
3960: trace('Error when inserting MSNT for serial(no attr):'||p_fm_serial_number||',l_proc_msg='||l_proc_msg);
3961: END IF;
3962: x_proc_msg := l_proc_msg;
3963: raise fnd_api.g_exc_error;
3964: END IF;
3965: IF l_debug = 1 THEN
3966: trace('MSNT record inserted for serial(no attr):'||p_fm_serial_number||',ser_txn_id='||nvl(l_ser_txn_id,l_txn_tmp_id));
3967: END IF;

Line 4036: raise fnd_api.g_exc_error;

4032: IF l_debug = 1 THEN
4033: trace('Error when inserting MSNT for serial:'||p_fm_serial_number||',l_proc_msg='||l_proc_msg);
4034: END IF;
4035: x_proc_msg := l_proc_msg;
4036: raise fnd_api.g_exc_error;
4037: END IF;
4038: trace('MSNT record inserted for serial(with attr):'||p_fm_serial_number||',ser_txn_id='||nvl(l_ser_txn_id,l_txn_tmp_id));
4039:
4040: END IF;

Line 4058: raise fnd_api.g_exc_error;

4054: WHEN others THEN
4055: IF l_debug = 1 THEN
4056: trace('Error when update MSN with group_mark_id='||l_txn_tmp_id||',SN='||p_fm_serial_number);
4057: END IF;
4058: raise fnd_api.g_exc_error;
4059: END;
4060:
4061: END IF;
4062: -- Mark WMS_PROCESS_FLAG for the move order line

Line 4072: raise fnd_api.g_exc_error;

4068: WHEN others THEN
4069: IF l_debug = 1 THEN
4070: trace('Error when updating wms_process_flag for mo line:'||l_mol_list(i).move_order_line_id);
4071: END IF;
4072: raise fnd_api.g_exc_error;
4073: END;
4074:
4075: x_transaction_header_id := l_txn_hdr_id;
4076: x_transaction_temp_id := l_txn_tmp_id;

Line 4093: raise fnd_api.g_exc_error;

4089: WHEN others THEN
4090: IF l_debug = 1 THEN
4091: trace('Error when updating MMTT rec,tmp_id='||p_transaction_temp_id);
4092: END IF;
4093: raise fnd_api.g_exc_error;
4094: END;
4095: IF l_debug = 1 THEN
4096: trace('MMTT updated for tmp_id '||p_transaction_temp_id);
4097: END IF;

Line 4116: raise fnd_api.g_exc_error;

4112: WHEN others THEN
4113: IF l_debug = 1 THEN
4114: trace('Error when updating MTLT rec,tmp_id='||p_transaction_temp_id);
4115: END IF;
4116: raise fnd_api.g_exc_error;
4117: END;
4118: IF l_debug = 1 THEN
4119: trace('MTLT updated for tmp_id '||p_transaction_temp_id);
4120: END IF;

Line 4172: raise fnd_api.g_exc_error;

4168: IF l_debug = 1 THEN
4169: trace('Error when inserting MSNT for serial(no attr):'||p_fm_serial_number||',l_proc_msg='||l_proc_msg);
4170: END IF;
4171: x_proc_msg := l_proc_msg;
4172: raise fnd_api.g_exc_error;
4173: END IF;
4174: IF l_debug = 1 THEN
4175: trace('MSNT record inserted for serial(no attr):'||p_fm_serial_number||',ser_txn_id='||nvl(l_ser_txn_id,l_txn_tmp_id));
4176: END IF;

Line 4245: raise fnd_api.g_exc_error;

4241: IF l_debug = 1 THEN
4242: trace('Error when inserting MSNT for serial(with attr):'||p_fm_serial_number||',l_proc_msg='||l_proc_msg);
4243: END IF;
4244: x_proc_msg := l_proc_msg;
4245: raise fnd_api.g_exc_error;
4246: END IF;
4247: trace('MSNT record inserted for serial(with attr):'||p_fm_serial_number||',ser_txn_id='||nvl(l_ser_txn_id,l_txn_tmp_id));
4248: END IF;
4249: /* l_insert := inv_trx_util_pub.insert_ser_trx(

Line 4261: raise fnd_api.g_exc_error;

4257: IF l_debug = 1 THEN
4258: trace('Error when inserting MSNT for serial:'||p_fm_serial_number||',l_proc_msg='||l_proc_msg);
4259: END IF;
4260: x_proc_msg := l_proc_msg;
4261: raise fnd_api.g_exc_error;
4262: END IF;
4263: IF l_debug = 1 THEN
4264: trace('MSNT record inserted for serial:'||p_fm_serial_number||',ser_txn_id='||
4265: nvl(l_cur_rec.serial_transaction_temp_id, p_transaction_temp_id));

Line 4285: raise fnd_api.g_exc_error;

4281: WHEN others THEN
4282: IF l_debug = 1 THEN
4283: trace('Error when update MSN with group_mark_id='||l_txn_tmp_id||',SN='||p_fm_serial_number);
4284: END IF;
4285: raise fnd_api.g_exc_error;
4286: END;
4287:
4288: END IF; -- END SN is not null
4289: x_transaction_header_id := p_transaction_header_id;

Line 4314: raise fnd_api.g_exc_error;

4310: WHEN others THEN
4311: IF l_debug = 1 THEN
4312: trace('Error when updating wms_packing_material_gtemp for mol:'||l_mol_list(i).move_order_line_id);
4313: END IF;
4314: raise fnd_api.g_exc_error;
4315: END;
4316:
4317: END LOOP; -- Move order lines loop
4318:

Line 4323: raise fnd_api.g_exc_error;

4319: ELSE
4320: IF l_debug = 1 THEN
4321: trace('Content has to be either lpn or item');
4322: END IF;
4323: raise fnd_api.g_exc_error;
4324: END IF;
4325:
4326:
4327: ELSIF p_source = 2 THEN

Line 4383: raise fnd_api.g_exc_error;

4379: l_txn_type_id := 88;
4380: ELSE
4381: fnd_message.set_name('INV','INV_INT_TRXACTCODE');
4382: fnd_msg_pub.add;
4383: raise fnd_api.g_exc_error;
4384: END IF;
4385: ELSE
4386: -- There is move happens
4387: -- Use subinventory transfer

Line 4461: raise fnd_api.g_exc_error;

4457: IF l_debug = 1 THEN
4458: trace('Error when inserting MMTT for content lpn ID:'||p_content_lpn_id|| 'err is '||l_proc_msg);
4459: END IF;
4460: x_proc_msg := l_proc_msg;
4461: raise fnd_api.g_exc_error;
4462: END IF;
4463:
4464: IF l_debug = 1 THEN
4465: trace('MMTT inserted, hdr_id='||l_txn_hdr_id|| ',tmp_id='||l_txn_tmp_id);

Line 4487: raise fnd_api.g_exc_error;

4483: IF l_debug = 1 THEN
4484: trace('Error when deleting from wms_packing_material_gtemp for content lpn '||p_content_lpn_id);
4485: END IF;
4486: x_proc_msg := l_proc_msg;
4487: raise fnd_api.g_exc_error;
4488: END;
4489:
4490: ELSIF p_inventory_item_id IS NOT NULL THEN
4491: -- Content is Item

Line 4552: raise fnd_api.g_exc_error;

4548: IF l_debug = 1 THEN
4549: trace('Error when inserting MMTT for item id:'||p_inventory_item_id|| 'err is '||l_proc_msg);
4550: END IF;
4551: x_proc_msg := l_proc_msg;
4552: raise fnd_api.g_exc_error;
4553: END IF;
4554:
4555: IF l_debug = 1 THEN
4556: trace('MMTT inserted, tmp_id='||l_txn_tmp_id);

Line 4574: raise fnd_api.g_exc_error;

4570: WHEN others THEN
4571: IF l_debug = 1 THEN
4572: trace('Error when updating MMTT rec,tmp_id='||p_transaction_temp_id);
4573: END IF;
4574: raise fnd_api.g_exc_error;
4575: END;
4576: IF l_debug = 1 THEN
4577: trace('MMTT updated for tmp_id '||p_transaction_temp_id);
4578: END IF;

Line 4603: raise fnd_api.g_exc_error;

4599: IF l_debug = 1 THEN
4600: trace('Error when inserting MTLT for lot:'||p_lot_number||',l_proc_msg='||l_proc_msg);
4601: END IF;
4602: x_proc_msg := l_proc_msg;
4603: raise fnd_api.g_exc_error;
4604: END IF;
4605: IF l_debug = 1 THEN
4606: trace('MTLT record inserted for lot:'||p_lot_number||',ser_txn_id='||l_ser_txn_id);
4607: END IF;

Line 4626: raise fnd_api.g_exc_error;

4622: IF l_debug = 1 THEN
4623: trace('Error when inserting MSNT for fm_serial:'||p_fm_serial_number||',to_serial:'||p_to_serial_number||',l_proc_msg='||l_proc_msg);
4624: END IF;
4625: x_proc_msg := l_proc_msg;
4626: raise fnd_api.g_exc_error;
4627: END IF;
4628: IF l_debug = 1 THEN
4629: trace('MSNT record inserted for fm_serial:'||p_fm_serial_number||',to_serial:'||p_to_serial_number||',ser_txn_id='||l_ser_txn_id);
4630: END IF;

Line 4737: raise fnd_api.g_exc_error;

4733: trace('Error when updating wms_packing_material_gtemp for item, only one record should be updated');
4734: END IF;
4735: fnd_message.set_name('INV','INV_FAILED');
4736: fnd_msg_pub.add;
4737: raise fnd_api.g_exc_error;
4738: ELSE
4739: IF l_debug = 1 THEN
4740: trace('wms_packing_material_gtemp updated, row_count='||l_row_count);
4741: END IF;

Line 4750: raise fnd_api.g_exc_error;

4746: trace('Error when updating wms_packing_material_gtemp for item '||p_inventory_item_id);
4747: END IF;
4748: fnd_message.set_name('INV','INV_FAILED');
4749: fnd_msg_pub.add;
4750: raise fnd_api.g_exc_error;
4751: END;
4752: */
4753: --End Commented out Bug 6028098
4754:

Line 4773: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

4769: trace('Other errors in create_txn');
4770: trace('ERROR Code ='||SQLCODE);
4771: trace('ERROR Message='||SQLERRM);
4772: END IF;
4773: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
4774: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data, p_encoded => 'F');
4775: IF (l_msg_count = 1) THEN
4776: x_proc_msg := x_proc_msg || l_msg_data;
4777: ELSIF (l_msg_count > 1) THEN

Line 4817: x_return_status := fnd_api.G_RET_STS_SUCCESS;

4813: l_sec_uom VARCHAR2(3); --INCONV kkillams
4814: l_progress VARCHAR2(20);
4815:
4816: BEGIN
4817: x_return_status := fnd_api.G_RET_STS_SUCCESS;
4818: IF l_debug = 1 THEN
4819: trace('In wms_packing_workbench_pvt.delete_txn');
4820: trace(', p_transaction_header_id = '||p_transaction_header_id||',p_transaction_temp_id='||p_transaction_temp_id);
4821: trace(', p_lot_number='||p_lot_number||', p_serial_number='||p_serial_number);

Line 4915: RAISE fnd_api.g_exc_error;

4911: trace(l_row_count||' rows of MMTT deleted with tmp_id '||p_transaction_temp_id);
4912: END IF;
4913: l_progress := '011';
4914: IF l_row_count <> 1 THEN
4915: RAISE fnd_api.g_exc_error;
4916: END IF;
4917: ELSE
4918:
4919: IF p_serial_number IS NOT NULL THEN

Line 4932: RAISE fnd_api.g_exc_error;

4928: END IF;
4929: l_progress := '013';
4930:
4931: IF l_row_count <> 1 THEN
4932: RAISE fnd_api.g_exc_error;
4933: END IF;
4934: END IF;
4935:
4936: IF p_lot_number IS NOT NULL THEN

Line 4948: RAISE fnd_api.g_exc_error;

4944: END IF;
4945: l_progress := '015';
4946:
4947: IF l_row_count <> 1 THEN
4948: RAISE fnd_api.g_exc_error;
4949: END IF;
4950: ELSIF l_mtlt_qty > abs(p_quantity) THEN
4951: -- Update MTLT
4952: UPDATE mtl_transaction_lots_temp

Line 4964: RAISE fnd_api.g_exc_error;

4960: END IF;
4961: l_progress := '017';
4962:
4963: IF l_row_count <> 1 THEN
4964: RAISE fnd_api.g_exc_error;
4965: END IF;
4966: ELSE
4967: IF l_debug = 1 THEN
4968: trace('mtlt quantity can not be less than p_quantity');

Line 4970: RAISE fnd_api.g_exc_error;

4966: ELSE
4967: IF l_debug = 1 THEN
4968: trace('mtlt quantity can not be less than p_quantity');
4969: END IF;
4970: RAISE fnd_api.g_exc_error;
4971: END IF;
4972: END IF;
4973:
4974: -- MMTT

Line 4986: RAISE fnd_api.g_exc_error;

4982: END IF;
4983: l_progress := '019';
4984:
4985: IF l_row_count <> 1 THEN
4986: RAISE fnd_api.g_exc_error;
4987: END IF;
4988: ELSIF l_mmtt_qty > abs(p_quantity) THEN
4989: UPDATE mtl_material_transactions_temp
4990: SET primary_quantity = primary_quantity - abs(p_quantity)

Line 5008: RAISE fnd_api.g_exc_error;

5004: trace(l_row_count||' rows of MMTT updated with tmp_id '||p_transaction_temp_id);
5005: END IF;
5006: l_progress := '021';
5007: IF l_row_count <> 1 THEN
5008: RAISE fnd_api.g_exc_error;
5009: END IF;
5010: ELSE
5011: IF l_debug = 1 THEN
5012: trace('mmtt quantity can not be less than p_quantity');

Line 5014: RAISE fnd_api.g_exc_error;

5010: ELSE
5011: IF l_debug = 1 THEN
5012: trace('mmtt quantity can not be less than p_quantity');
5013: END IF;
5014: RAISE fnd_api.g_exc_error;
5015: END IF;
5016:
5017: END IF;
5018:

Line 5021: x_return_status := fnd_api.G_RET_STS_ERROR;

5017: END IF;
5018:
5019: EXCEPTION
5020: WHEN others THEN
5021: x_return_status := fnd_api.G_RET_STS_ERROR;
5022: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5023: IF l_debug = 1 THEN
5024: trace('Error in delete_txn(), progress='||l_progress);
5025: trace('ERROR Code ='||SQLCODE);

Line 5067: raise fnd_api.g_exc_error;

5063: IF l_debug = 1 THEN
5064: 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);
5065: END IF;
5066: IF l_return_status <> 'S' THEN
5067: raise fnd_api.g_exc_error;
5068: ELSE
5069: x_return_status := fnd_api.G_RET_STS_SUCCESS;
5070: x_proc_msg := NULL;
5071: END IF;

Line 5069: x_return_status := fnd_api.G_RET_STS_SUCCESS;

5065: END IF;
5066: IF l_return_status <> 'S' THEN
5067: raise fnd_api.g_exc_error;
5068: ELSE
5069: x_return_status := fnd_api.G_RET_STS_SUCCESS;
5070: x_proc_msg := NULL;
5071: END IF;
5072: ELSE
5073: -- Outbound

Line 5087: x_return_status := fnd_api.G_RET_STS_SUCCESS;

5083: IF l_debug = 1 THEN
5084: trace('called INV_LPN_TRX_PUB.PROCESS_LPN_TRX , l_return='||l_return||',l_proc_msg='||l_proc_msg);
5085: END IF;
5086: IF l_return = 0 THEN
5087: x_return_status := fnd_api.G_RET_STS_SUCCESS;
5088: x_proc_msg := null;
5089: ELSE
5090: x_return_status := fnd_api.G_RET_STS_ERROR;
5091: x_proc_msg := l_proc_msg;

Line 5090: x_return_status := fnd_api.G_RET_STS_ERROR;

5086: IF l_return = 0 THEN
5087: x_return_status := fnd_api.G_RET_STS_SUCCESS;
5088: x_proc_msg := null;
5089: ELSE
5090: x_return_status := fnd_api.G_RET_STS_ERROR;
5091: x_proc_msg := l_proc_msg;
5092: END IF;
5093:
5094: END IF;

Line 5098: x_return_status := fnd_api.G_RET_STS_ERROR;

5094: END IF;
5095:
5096: EXCEPTION
5097: WHEN others THEN
5098: x_return_status := fnd_api.G_RET_STS_ERROR;
5099: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data, p_encoded => 'F');
5100: IF (l_msg_count = 1) THEN
5101: x_proc_msg := l_msg_data;
5102: ELSIF (l_msg_count > 1) THEN

Line 5143: p_init_msg_list => fnd_api.g_false,

5139: l_delivery_id_tab(1) := p_delivery_id;
5140:
5141: WSH_INTERFACE_EXT_GRP.Delivery_Action
5142: (p_api_version_number => 1.0,
5143: p_init_msg_list => fnd_api.g_false,
5144: p_commit => fnd_api.g_false,
5145: p_action_prms => l_action_prms,
5146: p_delivery_id_tab => l_delivery_id_tab,
5147: x_delivery_out_rec => l_delivery_out_rec,

Line 5144: p_commit => fnd_api.g_false,

5140:
5141: WSH_INTERFACE_EXT_GRP.Delivery_Action
5142: (p_api_version_number => 1.0,
5143: p_init_msg_list => fnd_api.g_false,
5144: p_commit => fnd_api.g_false,
5145: p_action_prms => l_action_prms,
5146: p_delivery_id_tab => l_delivery_id_tab,
5147: x_delivery_out_rec => l_delivery_out_rec,
5148: x_return_status => l_return_status,

Line 5582: x_return_status := fnd_api.G_RET_STS_SUCCESS;

5578: BEGIN
5579: IF l_debug = 1 THEN
5580: trace('In get_kitting_info, p_org_id='||p_organization_id||',p_item_id='||p_inventory_item_id||',p_qty='||p_quantity);
5581: END IF;
5582: x_return_status := fnd_api.G_RET_STS_SUCCESS;
5583: -- First get the list of kits that the item belongs to
5584: l_kit_list := get_kit_list(p_organization_id, p_inventory_item_id, 'N');
5585:
5586: l_new_inserted_kit_cnt := 0;