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

Line 132: x_return_status := FND_API.g_ret_sts_success;

128: BEGIN
129:
130: SAVEPOINT generate_xml_csv_sp;
131:
132: x_return_status := FND_API.g_ret_sts_success;
133:
134:
135: IF (l_debug = 1) THEN
136: trace('generate_xml_csv_api ::DEVICE::OUT_METHOD:status_code:p_event_date');

Line 264: IF (l_return_status<> FND_API.g_ret_sts_success) THEN

260: trace(' After call to SYNC_DEVICE_REQUEST l_return_status:'||l_return_status);
261: END IF;
262:
263:
264: IF (l_return_status<> FND_API.g_ret_sts_success) THEN
265:
266: l_msg_data := fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');--only last message
267:
268: UPDATE wms_device_requests

Line 675: p_commit_flag => fnd_api.g_true --Committed

671:
672: WMS_SHIPPING_TRANSACTION_PUB.unassign_delivery_line
673: (p_delivery_detail_id =>l_delivery_detail_id,
674: x_return_status => l_return_status,
675: p_commit_flag => fnd_api.g_true --Committed
676: );
677:
678: END LOOP;
679:

Line 839: RAISE FND_API.G_EXC_ERROR;

835: trace('catch wt validation failed');
836: END IF;
837: FND_MESSAGE.SET_NAME('WMS', 'WMS_CTWT_DEFAULT_ERROR');
838: FND_MSG_PUB.ADD;
839: RAISE FND_API.G_EXC_ERROR;
840:
841: END IF;
842:
843: --make sure that the LPN does not have any Serial item which is defined as

Line 876: RAISE FND_API.G_EXC_ERROR;

872: trace('Error: LPN contains Serials at SO Issue');
873: END IF;
874: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_NO_SERIAL_ISSUE');
875: FND_MSG_PUB.ADD;
876: RAISE FND_API.G_EXC_ERROR;
877:
878: END IF;
879:
880:

Line 935: RAISE FND_API.G_EXC_ERROR;

931: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_TRUCK_LOAD_FAIL');
932: FND_MSG_PUB.ADD;
933: END IF;
934:
935: RAISE FND_API.G_EXC_ERROR;
936:
937: ELSE
938:
939: IF (l_debug = 1) THEN

Line 1011: x_return_status := FND_API.g_ret_sts_success;

1007: BEGIN
1008: IF (l_debug = 1) THEN
1009: trace('Inside process_normal_truck_load_ship');
1010: END IF;
1011: x_return_status := FND_API.g_ret_sts_success;
1012:
1013:
1014: --First Load the LPN
1015: process_normal_truck_load(p_lpn_id => p_lpn_id,

Line 1026: RAISE FND_API.G_EXC_ERROR;

1022: IF l_return_status IS NULL OR l_return_status = 'E' OR l_return_status = 'U' THEN
1023: IF (l_debug = 1) THEN
1024: trace('process_normal_truck_load_ship: Truck load failed');
1025: END IF;
1026: RAISE FND_API.G_EXC_ERROR;
1027:
1028: ELSE
1029:
1030: IF (l_debug = 1) THEN

Line 1046: p_commit_flag => fnd_api.g_false,

1042: WMS_SHIPPING_TRANSACTION_PUB.close_truck
1043: ( P_dock_door_id => p_dock_door_id,
1044: P_organization_id => p_org_id,
1045: p_shipping_mode => 'NORMAL',
1046: p_commit_flag => fnd_api.g_false,
1047: x_return_status => l_return_status,
1048: x_return_msg => l_msg_data
1049: );
1050:

Line 1065: RAISE FND_API.G_EXC_ERROR;

1061: IF (l_debug = 1) THEN
1062: trace('process_normal_truck_load_ship return Success/Warning: Commit Done');
1063: END IF;
1064: ELSE
1065: RAISE FND_API.G_EXC_ERROR;
1066: END IF;
1067:
1068:
1069: ELSE

Line 1132: x_return_status := FND_API.g_ret_sts_success;

1128: IF (l_debug = 1) THEN
1129: trace('Inside PROCESS_DIRECT_TRUCK_LOAD');
1130: END IF;
1131:
1132: x_return_status := FND_API.g_ret_sts_success;
1133:
1134: --Jason will provide this API
1135: --Check that for all items in the LPN, either catch weights are
1136: --defaulted OR defaulting is enabled so that shipping can default them

Line 1158: RAISE FND_API.G_EXC_ERROR;

1154: trace('catch wt validation failed');
1155: END IF;
1156: FND_MESSAGE.SET_NAME('WMS', 'WMS_CTWT_DEFAULT_ERROR');
1157: FND_MSG_PUB.ADD;
1158: RAISE FND_API.G_EXC_ERROR;
1159:
1160: END IF;
1161:
1162:

Line 1195: RAISE FND_API.G_EXC_ERROR;

1191: trace('Error: LPN contains Serials at SO Issue');
1192: END IF;
1193: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_NO_SERIAL_ISSUE');
1194: FND_MSG_PUB.ADD;
1195: RAISE FND_API.G_EXC_ERROR;
1196:
1197: END IF;
1198:
1199:

Line 1250: RAISE FND_API.G_EXC_ERROR;

1246: IF l_return_status IS NULL OR l_return_status = 'E' OR
1247: l_return_status = 'U' THEN
1248: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_TRUCK_LOAD_FAIL');
1249: FND_MSG_PUB.ADD;
1250: RAISE FND_API.G_EXC_ERROR;
1251:
1252: ELSE
1253:
1254: if l_remaining_qty <> 0 then

Line 1261: RAISE FND_API.G_EXC_ERROR;

1257: trace('ERROR: LPN not Totally Consumed');
1258: END IF;
1259: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_LPN_NOT_CONSUMED');
1260: FND_MSG_PUB.ADD;
1261: RAISE FND_API.G_EXC_ERROR;
1262:
1263: else
1264: IF (l_debug = 1) THEN
1265: trace('Load the LPN');

Line 1285: RAISE FND_API.G_EXC_ERROR;

1281: IF l_return_status IS NULL OR l_return_status = 'E' OR
1282: l_return_status = 'U' THEN
1283: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_TRUCK_LOAD_FAIL');
1284: FND_MSG_PUB.ADD;
1285: RAISE FND_API.G_EXC_ERROR;
1286:
1287: ELSE
1288: IF (l_debug = 1) THEN
1289: trace('Load LPN success: Checking whether the last LPN for truck Load only');

Line 1367: x_return_status := FND_API.g_ret_sts_success;

1363: IF (l_debug = 1) THEN
1364: trace('Inside process_direct_truck_load_ship');
1365: END IF;
1366:
1367: x_return_status := FND_API.g_ret_sts_success;
1368:
1369: process_direct_truck_load( p_lpn_id => p_lpn_id,
1370: p_org_id => p_org_id,
1371: p_dock_door_id => p_dock_door_id,

Line 1382: RAISE FND_API.G_EXC_ERROR;

1378: END IF;
1379:
1380: IF l_return_status IS NULL OR l_return_status = 'E' OR l_return_status ='U' THEN
1381:
1382: RAISE FND_API.G_EXC_ERROR;
1383: IF (l_debug = 1) THEN
1384: trace('process_direct_truck_load_ship::Truck Load failed');
1385: END IF;
1386:

Line 1405: p_commit_flag => fnd_api.g_false,

1401: WMS_SHIPPING_TRANSACTION_PUB.close_truck
1402: ( P_dock_door_id => p_dock_door_id,
1403: P_organization_id => p_org_id,
1404: p_shipping_mode => 'DIRECT',
1405: p_commit_flag => fnd_api.g_false,
1406: x_return_status => l_return_status,
1407: x_return_msg => l_msg_data
1408: );
1409:

Line 1415: (p_encoded => FND_API.g_false,

1411: trace('process_direct_truck_load_ship l_return_status :'||l_return_status);
1412: END IF;
1413:
1414: fnd_msg_pub.Count_And_Get
1415: (p_encoded => FND_API.g_false,
1416: p_count => l_msg_count,
1417: p_data => l_msg_data
1418: );
1419:

Line 1422: l_ship_confirm_pkg_mesg := substr((l_msg_data || '|' || FND_MSG_PUB.GET(p_msg_index => l_msg_count - i + 1, p_encoded => FND_API.g_false)),1,240);

1418: );
1419:
1420: IF l_msg_count > 1 THEN
1421: FOR i IN 1..l_msg_count LOOP
1422: l_ship_confirm_pkg_mesg := substr((l_msg_data || '|' || FND_MSG_PUB.GET(p_msg_index => l_msg_count - i + 1, p_encoded => FND_API.g_false)),1,240);
1423: END LOOP;
1424: ELSE
1425:
1426: l_ship_confirm_pkg_mesg :=substr(l_msg_data,1,240);

Line 1509: x_return_status := FND_API.g_ret_sts_success;

1505: trace('process_rfid_receiving_txn:l_shipment_header_id:p_routing_id:p_lpn_id:p_lpn_context');
1506: trace('process_rfid_receiving_txn:'||l_shipment_header_id||'::'||p_routing_id||'::'||p_lpn_id||'::'|| p_lpn_context);
1507: END IF;
1508:
1509: x_return_status := FND_API.g_ret_sts_success;
1510:
1511: if p_routing_id IS NOT NULL THEN
1512:
1513: if p_routing_id = 2 then --inspection

Line 1562: RAISE FND_API.G_EXC_ERROR;

1558:
1559: --Fail the transaction, it can not be performed by RFID
1560: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_ITEM_CTRL_ERROR');
1561: FND_MSG_PUB.ADD;
1562: RAISE FND_API.G_EXC_ERROR;
1563:
1564: ELSE
1565: IF (l_debug = 1) THEN
1566: trace('process_rfid_receiving_txn:l_lot_ser_code test passed');

Line 1696: RAISE FND_API.G_EXC_ERROR;

1692:
1693: IF (l_debug = 1) THEN
1694: trace('process_rfid_receiving_txn: Error: Rcpt generation failed');
1695: END IF;
1696: RAISE FND_API.G_EXC_ERROR;
1697:
1698: ELSE
1699:
1700: IF (l_debug = 1) THEN

Line 1767: RAISE FND_API.G_EXC_ERROR;

1763:
1764: IF (l_debug = 1) THEN
1765: trace('process_rfid_receiving_txn: Error: rcv_insert_update_header failed');
1766: END IF;
1767: RAISE FND_API.G_EXC_ERROR;
1768:
1769: ELSE
1770:
1771: IF (l_debug = 1) THEN

Line 2029: x_return_status := fnd_api.g_ret_sts_error;

2025:
2026:
2027: x_pallet_lpn_id := NULL;
2028: x_pallet_lpn_context := NULL;
2029: x_return_status := fnd_api.g_ret_sts_error;
2030: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_INVALID_READ');
2031: FND_MSG_PUB.ADD;
2032:
2033: l_is_error :=1;

Line 2040: x_return_status := fnd_api.g_ret_sts_error;

2036: WHEN too_many_rows THEN
2037: --THIS SHOULD NEVER HAPPEN AS EPC IS UNIQUE COLUMN IN THE TABLE
2038: x_pallet_lpn_id := NULL;
2039: x_pallet_lpn_context := NULL;
2040: x_return_status := fnd_api.g_ret_sts_error;
2041: FND_MESSAGE.SET_NAME('WMS', 'WMS_DUPLICATE_EPC');
2042: FND_MSG_PUB.ADD;
2043:
2044: l_is_error :=1;

Line 2053: x_return_status := fnd_api.g_ret_sts_error;

2049: END IF;
2050:
2051: x_pallet_lpn_id := NULL;
2052: x_pallet_lpn_context := NULL;
2053: x_return_status := fnd_api.g_ret_sts_error;
2054: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERR');
2055: FND_MSG_PUB.ADD;
2056:
2057: l_is_error :=1;

Line 3351: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3347: trace('process_rfid_txn:'||l_routing_id||'::'||l_return_status||'::'||l_msg_count||'::'||l_msg_data);
3348: END IF;
3349:
3350:
3351: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3352:
3353: IF (l_debug = 1) THEN
3354: trace(' Error : inv_rcv_common_apis.failed in getting _routing_id');
3355: END IF;

Line 3390: IF l_return_status <> fnd_api.g_ret_sts_success THEN--failed transaction

3386: x_return_status => l_return_status);
3387:
3388: l_progress := '90';
3389:
3390: IF l_return_status <> fnd_api.g_ret_sts_success THEN--failed transaction
3391:
3392: IF (l_debug = 1) THEN
3393: trace('process_rfid_txn: Receiving txn failed');
3394: END IF;