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_MSG_PUB

Line 153: l_msg_data := fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');

149:
150: IF p_business_event_id = wms_device_integration_pvt.wms_be_truck_load_ship THEN
151: l_msg_data := l_ship_confirm_pkg_mesg;
152: else
153: l_msg_data := fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');
154:
155: END IF;
156:
157:

Line 226: l_msg_data := fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');--only last message

222:
223: --Update WDR since error while generating the XML
224: IF l_xml_stat <> 'S' THEN
225:
226: l_msg_data := fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');--only last message
227:
228: UPDATE wms_device_requests
229: SET status_code = l_xml_stat,
230: status_msg = l_msg_data

Line 266: l_msg_data := fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');--only last message

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
269: SET status_code = l_return_status,
270: status_msg = l_msg_data

Line 838: FND_MSG_PUB.ADD;

834: IF (l_debug = 1) THEN
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:

Line 875: FND_MSG_PUB.ADD;

871: IF (l_debug = 1) THEN
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:

Line 929: FND_MSG_PUB.ADD;

925: IF l_error_code = 5 THEN
926:
927: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_LPN_OTH_DOCK');
928: FND_MESSAGE.SET_TOKEN('DOCK', l_loaded_dock_door);
929: FND_MSG_PUB.ADD;
930: else
931: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_TRUCK_LOAD_FAIL');
932: FND_MSG_PUB.ADD;
933: END IF;

Line 932: FND_MSG_PUB.ADD;

928: FND_MESSAGE.SET_TOKEN('DOCK', l_loaded_dock_door);
929: FND_MSG_PUB.ADD;
930: else
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:

Line 954: FND_MSG_PUB.ADD;

950: IF (l_debug = 1) THEN
951: trace('last LPN to be loaded for delivery');
952: END IF;
953: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_LAST_LPN_DELIVERY');
954: FND_MSG_PUB.ADD;
955: ELSIF l_is_last_lpn_load = 3 THEN
956: IF (l_debug = 1) THEN
957: trace('last LPN to be loaded for trip');
958: END IF;

Line 960: FND_MSG_PUB.ADD;

956: IF (l_debug = 1) THEN
957: trace('last LPN to be loaded for trip');
958: END IF;
959: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_LAST_LPN_TRIP');
960: FND_MSG_PUB.ADD;
961: ELSE
962: IF (l_debug = 1) THEN
963: trace('Truck Load Successful');
964: END IF;

Line 966: FND_MSG_PUB.ADD;

962: IF (l_debug = 1) THEN
963: trace('Truck Load Successful');
964: END IF;
965: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_TRUCK_LOAD_SUCCESS');
966: FND_MSG_PUB.ADD;
967:
968: END IF;
969:
970: END IF;

Line 1073: l_ship_confirm_pkg_mesg :=fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');

1069: ELSE
1070: IF (l_debug = 1) THEN
1071: trace('process_normal_truck_load_ship: Not the last LPN in the trip or delivery:So DO not Ship Confirm');
1072:
1073: l_ship_confirm_pkg_mesg :=fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');
1074:
1075: END IF;
1076:
1077: END IF;

Line 1157: FND_MSG_PUB.ADD;

1153: IF (l_debug = 1) THEN
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:

Line 1194: FND_MSG_PUB.ADD;

1190: IF (l_debug = 1) THEN
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:

Line 1250: FND_MSG_PUB.ADD;

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

Line 1261: FND_MSG_PUB.ADD;

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

Line 1285: FND_MSG_PUB.ADD;

1281:
1282: IF l_return_status IS NULL OR l_return_status = 'E' OR
1283: l_return_status = 'U' THEN
1284: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_TRUCK_LOAD_FAIL');
1285: FND_MSG_PUB.ADD;
1286: RAISE FND_API.G_EXC_ERROR;
1287:
1288: ELSE
1289: IF (l_debug = 1) THEN

Line 1302: FND_MSG_PUB.ADD;

1298: trace('last LPN to be loaded for delivery');
1299: END IF;
1300:
1301: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_LAST_LPN_DELIVERY');
1302: FND_MSG_PUB.ADD;
1303: ELSIF l_is_last_lpn_load = 3 THEN
1304: IF (l_debug = 1) THEN
1305: trace('last LPN to be loaded for trip');
1306: END IF;

Line 1308: FND_MSG_PUB.ADD;

1304: IF (l_debug = 1) THEN
1305: trace('last LPN to be loaded for trip');
1306: END IF;
1307: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_LAST_LPN_TRIP');
1308: FND_MSG_PUB.ADD;
1309: ELSE
1310: IF (l_debug = 1) THEN
1311: trace('Truck Load Successful');
1312: END IF;

Line 1314: FND_MSG_PUB.ADD;

1310: IF (l_debug = 1) THEN
1311: trace('Truck Load Successful');
1312: END IF;
1313: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_TRUCK_LOAD_SUCCESS');
1314: FND_MSG_PUB.ADD;
1315:
1316: END IF;
1317:
1318: --Must Commit here

Line 1415: fnd_msg_pub.Count_And_Get

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

Line 1423: 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);

1419: );
1420:
1421: IF l_msg_count > 1 THEN
1422: FOR i IN 1..l_msg_count LOOP
1423: 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);
1424: END LOOP;
1425: ELSE
1426:
1427: l_ship_confirm_pkg_mesg :=substr(l_msg_data,1,240);

Line 1431: fnd_msg_pub.delete_msg;

1427: l_ship_confirm_pkg_mesg :=substr(l_msg_data,1,240);
1428:
1429: END IF;
1430:
1431: fnd_msg_pub.delete_msg;
1432:
1433:
1434: IF (l_debug = 1) THEN
1435: trace('process_direct_truck_load_ship SHP_msg_data ::'||l_ship_confirm_pkg_mesg);

Line 1455: l_ship_confirm_pkg_mesg :=fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');

1451: ELSE
1452: IF (l_debug = 1) THEN
1453: trace('process_direct_truck_load_ship: Not the last LPN in the trip or delivery: DO not Ship Confirm');
1454: END IF;
1455: l_ship_confirm_pkg_mesg :=fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');
1456: END IF;
1457:
1458: END IF;
1459:

Line 1562: FND_MSG_PUB.ADD;

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

Line 1791: FND_MSG_PUB.ADD;

1787: inv_rcv_common_apis.rcv_clear_global;
1788:
1789: IF l_return_status = 'S' THEN
1790: FND_MESSAGE.SET_NAME('WMS', 'WMS_TXN_SUCCESS');
1791: FND_MSG_PUB.ADD;
1792: END IF;
1793:
1794: x_return_status := l_return_status;
1795:

Line 1925: FND_MSG_PUB.ADD;

1921: x_pallet_lpn_id := NULL;
1922: x_pallet_lpn_context := NULL;
1923: x_return_status := 'E';
1924: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_NO_INNER_LPN_READ');--Already seeded
1925: FND_MSG_PUB.ADD;
1926:
1927: END IF;
1928:
1929:

Line 1964: FND_MSG_PUB.ADD;

1960: x_pallet_lpn_id := NULL;
1961: x_pallet_lpn_context := NULL;
1962: x_return_status := 'E';
1963: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_NO_INNER_LPN_READ');
1964: FND_MSG_PUB.ADD;
1965:
1966: END IF;
1967:
1968: EXCEPTION

Line 1974: FND_MSG_PUB.ADD;

1970: x_pallet_lpn_id := NULL;
1971: x_pallet_lpn_context := NULL;
1972: x_return_status := 'E';
1973: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
1974: FND_MSG_PUB.ADD;
1975:
1976: RETURN;
1977:
1978: END;

Line 2032: FND_MSG_PUB.ADD;

2028: x_pallet_lpn_id := NULL;
2029: x_pallet_lpn_context := NULL;
2030: x_return_status := fnd_api.g_ret_sts_error;
2031: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_INVALID_READ');
2032: FND_MSG_PUB.ADD;
2033:
2034: l_is_error :=1;
2035: EXIT; --exit the loop
2036:

Line 2043: FND_MSG_PUB.ADD;

2039: x_pallet_lpn_id := NULL;
2040: x_pallet_lpn_context := NULL;
2041: x_return_status := fnd_api.g_ret_sts_error;
2042: FND_MESSAGE.SET_NAME('WMS', 'WMS_DUPLICATE_EPC');
2043: FND_MSG_PUB.ADD;
2044:
2045: l_is_error :=1;
2046: EXIT; --exit the loop
2047: WHEN OTHERS THEN

Line 2056: FND_MSG_PUB.ADD;

2052: x_pallet_lpn_id := NULL;
2053: x_pallet_lpn_context := NULL;
2054: x_return_status := fnd_api.g_ret_sts_error;
2055: FND_MESSAGE.SET_NAME('WMS', 'WMS_UNEXPECTED_ERR');
2056: FND_MSG_PUB.ADD;
2057:
2058: l_is_error :=1;
2059:
2060: EXIT; --exit the loop

Line 2121: FND_MSG_PUB.ADD;

2117: trace('Error: Multiple Pallets OR Cases belongs to multiple Pallets');
2118: END IF;
2119: x_return_status := 'E';
2120: FND_MESSAGE.SET_NAME('WMS','WMS_RFID_MULTIPLE_PALLET');
2121: FND_MSG_PUB.ADD;
2122:
2123: l_is_error := 1;
2124: EXIT; --exit the loop
2125:

Line 2173: FND_MSG_PUB.ADD;

2169: trace('Error: There IS NO PALLET for Serial');
2170: END IF;
2171: x_return_status := 'E';
2172: FND_MESSAGE.SET_NAME('WMS','WMS_RFID_NO_PALLET');
2173: FND_MSG_PUB.ADD;
2174:
2175: l_is_error := 1;
2176: EXIT; --exit the loop
2177:

Line 2190: FND_MSG_PUB.ADD;

2186: trace('Error: Serials belong to multiple Pallet');
2187: END IF;
2188: x_return_status := 'E';
2189: FND_MESSAGE.SET_NAME('WMS','WMS_RFID_MULTIPLE_PALLET');
2190: FND_MSG_PUB.ADD;
2191:
2192: l_is_error := 1;
2193: EXIT; --exit the loop
2194:

Line 2226: FND_MSG_PUB.ADD;

2222: trace('Error:UNIDENTIFIED CROSS-REFERENCE TYPE');
2223: END IF;
2224: x_return_status := 'E';
2225: FND_MESSAGE.SET_NAME('WMS','WMS_RFID_INVALID_READ');
2226: FND_MSG_PUB.ADD;
2227:
2228: l_is_error := 1;
2229: EXIT; --exit the loop
2230: END IF;

Line 2254: FND_MSG_PUB.ADD;

2250: x_pallet_lpn_id := NULL;
2251: x_pallet_lpn_context := NULL;
2252: x_return_status := 'E';
2253: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_MULTIPLE_PALLET');
2254: FND_MSG_PUB.ADD;
2255:
2256: l_is_error :=1;
2257:
2258: ELSE

Line 2274: FND_MSG_PUB.ADD;

2270: x_pallet_lpn_id := NULL;
2271: x_pallet_lpn_context := NULL;
2272: x_return_status := 'E';
2273: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_INVALID_READ');
2274: FND_MSG_PUB.ADD;
2275:
2276: RETURN;
2277:
2278: END IF;

Line 2289: SET status = substr(fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F'),1,240),

2285: IF l_is_error = 1 THEN
2286:
2287: FOR j IN 1..x_tag_info.COUNT LOOP
2288: UPDATE wms_epc
2289: SET status = substr(fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F'),1,240),
2290: status_code = 'E'
2291: WHERE EPC = x_tag_info(j).TAG_id;
2292:
2293: END LOOP;

Line 2306: FND_MSG_PUB.ADD;

2302: x_pallet_lpn_id := NULL;
2303: x_pallet_lpn_context := NULL;
2304: x_return_status := 'E';
2305: FND_MESSAGE.SET_NAME('WMS', 'UNEXPECTED ERROR');
2306: FND_MSG_PUB.ADD;
2307: IF (l_debug = 1) THEN
2308: trace ('parse_read_tags :Inside when others exception');
2309: trace ('SQL ERROR :'||SQLCODE);
2310: trace ('SQL ERROR :'||Sqlerrm);

Line 2410: FND_MSG_PUB.ADD;

2406: WHEN OTHERS THEN
2407:
2408: x_return_status := 'E';
2409: FND_MESSAGE.SET_NAME('WMS', 'UNEXPECTED_ERROR');
2410: FND_MSG_PUB.ADD;
2411:
2412: IF l_debug = 1 then
2413: trace('ERROR CODE = ' || SQLCODE);
2414: trace('ERROR MESSAGE = ' || SQLERRM);

Line 2441: FND_MSG_PUB.ADD;

2437: l_error_code := 1;
2438: --mark all read EPC as invalid in EPC table
2439: x_return_status := 'E';
2440: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_INVALID_READ');
2441: FND_MSG_PUB.ADD;
2442:
2443: EXIT;
2444:
2445: END IF;

Line 2453: FND_MSG_PUB.ADD;

2449: --Cases from different pallet are in this set of tags
2450:
2451: x_return_status := 'E';
2452: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_MIXED_CASES');
2453: FND_MSG_PUB.ADD;
2454: EXIT;
2455: END IF;
2456:
2457:

Line 2602: FND_MSG_PUB.ADD;

2598: END IF;
2599:
2600: x_return_status := 'S';
2601: FND_MESSAGE.SET_NAME('WMS', 'WMS_VERIFY_COMPLETE');
2602: FND_MSG_PUB.ADD;
2603:
2604: ELSIF l_cur_percent < l_load_verify_threshold THEN
2605:
2606: IF (l_debug = 1) THEN

Line 2612: FND_MSG_PUB.ADD;

2608: END IF;
2609: x_return_status := 'E';
2610:
2611: FND_MESSAGE.SET_NAME('WMS', 'WMS_VERIF_UNDER_THRESHOLD');
2612: FND_MSG_PUB.ADD;
2613:
2614:
2615: ELSIF l_cur_percent > 100 THEN --case when there are more cases on
2616: --the pallet the expected, amy be OF other pallet

Line 2620: FND_MSG_PUB.ADD;

2616: --the pallet the expected, amy be OF other pallet
2617:
2618: x_return_status := 'E';
2619: FND_MESSAGE.SET_NAME('WMS','WMS_VERIF_EXTRA_CASE');
2620: FND_MSG_PUB.ADD;
2621: END IF;
2622:
2623: END IF; -- x_return_status = 'S'
2624:

Line 2639: FND_MSG_PUB.ADD;

2635:
2636: IF l_total_lpn_qty < l_total_gtin_qty THEN
2637: x_return_status := 'E';
2638: FND_MESSAGE.SET_NAME('WMS','WMS_VERIF_EXTRA_GTIN_PACK');
2639: FND_MSG_PUB.ADD;
2640:
2641: END IF;
2642:
2643: ELSE

Line 2654: l_msg_data := substr(fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F'),1,240);

2650:
2651: --Update appropriate tables with verification result
2652:
2653: --get the failue/success meag
2654: l_msg_data := substr(fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F'),1,240);
2655:
2656: IF x_return_status = 'E' THEN
2657:
2658: --1. UPDATE WMS_EPC TABLE FOR FAILURE FOR ALL READS

Line 2855: FND_MSG_PUB.initialize;

2851: END IF;
2852: END IF;
2853:
2854:
2855: FND_MSG_PUB.initialize;
2856:
2857: IF (l_debug = 1) THEN
2858: trace('Inside process_rfid_txn rfid_user_id :'||l_user_id||
2859: --', LPN/EPC name :'||l_tagid||

Line 2884: FND_MSG_PUB.ADD;

2880: --Can not generate xml since organization_id is required
2881: --column IN the wdr AND we have no information about it here
2882: END IF;
2883: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_NO_DEVICE_FOUND');
2884: FND_MSG_PUB.ADD;
2885: raise end_processing;
2886:
2887: WHEN too_many_rows THEN
2888: IF (l_debug = 1) THEN

Line 2892: FND_MSG_PUB.ADD;

2888: IF (l_debug = 1) THEN
2889: trace('Error :Multiple devices with same device_name');
2890: END IF;
2891: FND_MESSAGE.SET_NAME('WMS', 'DUPLICATE_DEVICE_ENTRY');
2892: FND_MSG_PUB.ADD;
2893: raise end_processing;
2894:
2895: WHEN OTHERS then
2896: IF (l_debug = 1) THEN

Line 2978: FND_MSG_PUB.ADD;

2974: END IF;
2975:
2976: IF l_is_valid_txn_device = 0 THEN
2977: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_NO_ELIGIBLE_BUS_EVENT');
2978: FND_MSG_PUB.ADD;
2979: ELSIF l_is_valid_txn_device = -1 THEN
2980: IF (l_debug = 1) THEN
2981: trace('process_rfid_txn : Error: Both Truck_load and Truck_load_ship are associated');
2982: END IF;

Line 2984: FND_MSG_PUB.ADD;

2980: IF (l_debug = 1) THEN
2981: trace('process_rfid_txn : Error: Both Truck_load and Truck_load_ship are associated');
2982: END IF;
2983: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_INVALID_BUS_ASSOC');
2984: FND_MSG_PUB.ADD;
2985: ELSIF l_is_valid_txn_device = -2 THEN
2986: IF (l_debug = 1) THEN
2987: trace('process_rfid_txn : Error: Direct rcv and Std/Insp both with same device');
2988: END IF;

Line 2990: FND_MSG_PUB.ADD;

2986: IF (l_debug = 1) THEN
2987: trace('process_rfid_txn : Error: Direct rcv and Std/Insp both with same device');
2988: END IF;
2989: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_INVALID_BUS_ASSOC');
2990: FND_MSG_PUB.ADD;
2991: ELSIF l_is_valid_txn_device = -3 THEN
2992: IF (l_debug = 1) THEN
2993: trace('process_rfid_txn : Error: Invalid LPN context');
2994: END IF;

Line 2996: FND_MSG_PUB.ADD;

2992: IF (l_debug = 1) THEN
2993: trace('process_rfid_txn : Error: Invalid LPN context');
2994: END IF;
2995: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN_CONTEXT');
2996: FND_MSG_PUB.ADD;
2997:
2998: END IF;
2999:
3000: --Insert generate XML/CSV or Call API for wms_be_rfid_error bus

Line 3044: FND_MSG_PUB.ADD;

3040: trace('Error: Verification of a Single LPN');
3041: END IF;
3042:
3043: FND_MESSAGE.SET_NAME('WMS', 'WMS_VERIF_UNDER_THRESHOLD');
3044: FND_MSG_PUB.ADD;
3045: l_return_status:= 'E';
3046:
3047: END IF;
3048:

Line 3297: FND_MSG_PUB.ADD;

3293: IF (l_debug = 1) THEN
3294: trace('process_rfid_txn:No record found with LPN ::'||l_lpn_id);
3295: END IF;
3296: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_INVALID_RCV_LPN ');
3297: FND_MSG_PUB.ADD;
3298: ROLLBACK TO wms_rfid_sp1;
3299: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_rfid_error,l_organization_id,l_lpn_id,l_output_method_id,l_subinventory_code,l_locator_id,'E', p_event_date,l_request_id,l_return_status);
3300: raise end_processing;
3301: end;

Line 3401: FND_MSG_PUB.ADD;

3397: IF l_routing_id = 1 OR l_routing_id = 2 THEN
3398: --Standard/inspection routing
3399: IF l_return_status <> 'N' THEN --avoid overwriting of mesg SET IN the API call
3400: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_STD_INSP_RCV_FAIL');
3401: FND_MSG_PUB.ADD;
3402: END IF;
3403:
3404: ROLLBACK TO wms_rfid_sp1;
3405: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.WMS_BE_STD_INSP_RECEIPT,l_organization_id,l_lpn_id,l_output_method_id,l_subinventory_code,l_locator_id,'E', p_event_date,l_request_id,l_return_status);

Line 3412: FND_MSG_PUB.ADD;

3408: ELSIF l_routing_id = 3 THEN
3409: -- direct routing
3410: IF l_return_status <> 'N' THEN--avoid overwriting of mesg set in the API call
3411: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_DIR_RCV_FAIL');
3412: FND_MSG_PUB.ADD;
3413: END IF;
3414: ROLLBACK TO wms_rfid_sp1;
3415: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.WMS_BE_DIRECT_RECEIPT,l_organization_id,l_lpn_id,l_output_method_id,l_subinventory_code,l_locator_id,'E', p_event_date,l_request_id,l_return_status);
3416: x_return_value := 'error';

Line 3446: FND_MSG_PUB.ADD;

3442: IF (l_debug = 1) THEN
3443: trace('Error: Device set up and returned txn routing does not match');
3444: END IF;
3445: FND_MESSAGE.SET_NAME('WMS','WMS_RFID_NO_ELIGIBLE_BUS_EVENT');
3446: FND_MSG_PUB.ADD;
3447: ROLLBACK TO wms_rfid_sp1;
3448: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_rfid_error,l_organization_id,l_lpn_id,l_output_method_id,l_subinventory_code,l_locator_id,'E', p_event_date,l_request_id,l_return_status);
3449: raise end_processing;
3450:

Line 3486: x_return_mesg := fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');

3482: --returning message
3483: IF l_out_business_event_id = wms_device_integration_pvt.wms_be_truck_load_ship THEN
3484: x_return_mesg := l_ship_confirm_pkg_mesg;
3485: else
3486: x_return_mesg := fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');
3487: END IF;
3488:
3489: EXCEPTION
3490: WHEN end_processing THEN

Line 3494: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);

3490: WHEN end_processing THEN
3491: x_return_value := 'error';
3492:
3493: /* somehow it does not retrieve all mesg
3494: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
3495: x_return_mesg := l_msg_data;
3496: */
3497:
3498: x_return_mesg := fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');

Line 3498: x_return_mesg := fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');

3494: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
3495: x_return_mesg := l_msg_data;
3496: */
3497:
3498: x_return_mesg := fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');
3499:
3500: IF (l_debug = 1) THEN
3501: trace('process_rfid_txn:throwing Exception:end_processing, Delete requested rows from WDR');
3502: trace('x_return_mesg :' || x_return_mesg);

Line 3512: x_return_mesg := fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');

3508:
3509: WHEN OTHERS THEN
3510: ROLLBACK TO wms_rfid_sp1;
3511: x_return_value := 'error';
3512: x_return_mesg := fnd_msg_pub.get(fnd_msg_pub.G_LAST,'F');
3513: IF (l_debug = 1) THEN
3514: trace('Other error in process_rfid_txn l_progress:;'|| l_progress);
3515: trace('SQL error :'||substr(sqlerrm, 1, 240));
3516: END IF;