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 1249: FND_MSG_PUB.ADD;

1245:
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:

Line 1260: FND_MSG_PUB.ADD;

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

Line 1284: FND_MSG_PUB.ADD;

1280:
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

Line 1301: FND_MSG_PUB.ADD;

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

Line 1307: FND_MSG_PUB.ADD;

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

Line 1313: FND_MSG_PUB.ADD;

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

Line 1414: fnd_msg_pub.Count_And_Get

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

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 1430: fnd_msg_pub.delete_msg;

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

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

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

Line 1561: FND_MSG_PUB.ADD;

1557: END IF;
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

Line 1790: FND_MSG_PUB.ADD;

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

Line 1924: FND_MSG_PUB.ADD;

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

Line 1963: FND_MSG_PUB.ADD;

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

Line 1973: FND_MSG_PUB.ADD;

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

Line 2031: FND_MSG_PUB.ADD;

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;
2034: EXIT; --exit the loop
2035:

Line 2042: FND_MSG_PUB.ADD;

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;
2045: EXIT; --exit the loop
2046: WHEN OTHERS THEN

Line 2055: FND_MSG_PUB.ADD;

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;
2058:
2059: EXIT; --exit the loop

Line 2120: FND_MSG_PUB.ADD;

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

Line 2172: FND_MSG_PUB.ADD;

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

Line 2189: FND_MSG_PUB.ADD;

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

Line 2225: FND_MSG_PUB.ADD;

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

Line 2253: FND_MSG_PUB.ADD;

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

Line 2273: FND_MSG_PUB.ADD;

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

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

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

Line 2305: FND_MSG_PUB.ADD;

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

Line 2409: FND_MSG_PUB.ADD;

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

Line 2440: FND_MSG_PUB.ADD;

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

Line 2452: FND_MSG_PUB.ADD;

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

Line 2601: FND_MSG_PUB.ADD;

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

Line 2611: FND_MSG_PUB.ADD;

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

Line 2619: FND_MSG_PUB.ADD;

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

Line 2638: FND_MSG_PUB.ADD;

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

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

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

Line 2854: FND_MSG_PUB.initialize;

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

Line 2883: FND_MSG_PUB.ADD;

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

Line 2891: FND_MSG_PUB.ADD;

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

Line 2977: FND_MSG_PUB.ADD;

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

Line 2983: FND_MSG_PUB.ADD;

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

Line 2989: FND_MSG_PUB.ADD;

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

Line 2995: FND_MSG_PUB.ADD;

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

Line 3043: FND_MSG_PUB.ADD;

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

Line 3296: FND_MSG_PUB.ADD;

3292: IF (l_debug = 1) THEN
3293: trace('process_rfid_txn:No record found with LPN ::'||l_lpn_id);
3294: END IF;
3295: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_INVALID_RCV_LPN ');
3296: FND_MSG_PUB.ADD;
3297: ROLLBACK TO wms_rfid_sp1;
3298: 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);
3299: raise end_processing;
3300: end;

Line 3400: FND_MSG_PUB.ADD;

3396: IF l_routing_id = 1 OR l_routing_id = 2 THEN
3397: --Standard/inspection routing
3398: IF l_return_status <> 'N' THEN --avoid overwriting of mesg SET IN the API call
3399: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_STD_INSP_RCV_FAIL');
3400: FND_MSG_PUB.ADD;
3401: END IF;
3402:
3403: ROLLBACK TO wms_rfid_sp1;
3404: 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 3411: FND_MSG_PUB.ADD;

3407: ELSIF l_routing_id = 3 THEN
3408: -- direct routing
3409: IF l_return_status <> 'N' THEN--avoid overwriting of mesg set in the API call
3410: FND_MESSAGE.SET_NAME('WMS', 'WMS_RFID_DIR_RCV_FAIL');
3411: FND_MSG_PUB.ADD;
3412: END IF;
3413: ROLLBACK TO wms_rfid_sp1;
3414: 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);
3415: x_return_value := 'error';

Line 3445: FND_MSG_PUB.ADD;

3441: IF (l_debug = 1) THEN
3442: trace('Error: Device set up and returned txn routing does not match');
3443: END IF;
3444: FND_MESSAGE.SET_NAME('WMS','WMS_RFID_NO_ELIGIBLE_BUS_EVENT');
3445: FND_MSG_PUB.ADD;
3446: ROLLBACK TO wms_rfid_sp1;
3447: 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);
3448: raise end_processing;
3449:

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

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

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

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

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

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

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

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