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 WMS_DEVICE_INTEGRATION_PVT

Line 150: IF p_business_event_id = wms_device_integration_pvt.wms_be_truck_load_ship THEN

146: l_request_id := l_device_req_id_pkg;
147: END IF;
148:
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:

Line 197: IF (( p_output_method_id= wms_device_integration_pvt.WMS_DEV_IO_XML) OR (p_output_method_id = wms_device_integration_pvt.WMS_DEV_IO_CSV)) then

193: END IF;
194:
195:
196: -- Generate XML,CSV if configured for it
197: IF (( p_output_method_id= wms_device_integration_pvt.WMS_DEV_IO_XML) OR (p_output_method_id = wms_device_integration_pvt.WMS_DEV_IO_CSV)) then
198: IF (l_debug = 1) THEN
199: trace('going to call wms_device_integration_pvt.generate_xml_csv');
200: END IF;
201:

Line 199: trace('going to call wms_device_integration_pvt.generate_xml_csv');

195:
196: -- Generate XML,CSV if configured for it
197: IF (( p_output_method_id= wms_device_integration_pvt.WMS_DEV_IO_XML) OR (p_output_method_id = wms_device_integration_pvt.WMS_DEV_IO_CSV)) then
198: IF (l_debug = 1) THEN
199: trace('going to call wms_device_integration_pvt.generate_xml_csv');
200: END IF;
201:
202: BEGIN
203: l_retval := wms_device_integration_pvt.generate_xml_csv(p_device_id,p_output_method_id);

Line 203: l_retval := wms_device_integration_pvt.generate_xml_csv(p_device_id,p_output_method_id);

199: trace('going to call wms_device_integration_pvt.generate_xml_csv');
200: END IF;
201:
202: BEGIN
203: l_retval := wms_device_integration_pvt.generate_xml_csv(p_device_id,p_output_method_id);
204:
205: IF l_retval <> 0 THEN
206: l_xml_stat := 'E';
207: ELSE

Line 217: trace(' Exception in call to wms_device_integration_pvt.generate_xml_csv');

213:
214: EXCEPTION
215: WHEN OTHERS THEN
216: IF (l_debug = 1) THEN
217: trace(' Exception in call to wms_device_integration_pvt.generate_xml_csv');
218: END IF;
219: l_xml_stat := 'E';
220: END;
221:

Line 235: ELSIF (p_output_method_id = wms_device_integration_pvt.WMS_DEV_IO_API) then

231: WHERE device_id = p_device_id;
232: END IF;
233:
234:
235: ELSIF (p_output_method_id = wms_device_integration_pvt.WMS_DEV_IO_API) then
236: IF (l_debug = 1) THEN
237: trace(' generate_xml_csv_api: Submit sync_device_request');
238: END IF;
239:

Line 278: IF p_business_event_id <> wms_device_integration_pvt.wms_be_rfid_error THEN

274:
275: END IF;
276:
277:
278: IF p_business_event_id <> wms_device_integration_pvt.wms_be_rfid_error THEN
279: IF (l_debug = 1) THEN
280: trace(' generate_xml_csv_api: Calling populate_history');
281: END IF;
282:

Line 499: AND (business_event_id = wms_device_integration_pvt.wms_be_truck_load

495: SELECT business_event_id,verification_required INTO x_out_business_event_id,x_verif_req FROM wms_bus_event_devices
496: WHERE device_id = p_device_id
497: AND ENABLED_FLAG = 'Y'
498: AND organization_id = p_organization_id
499: AND (business_event_id = wms_device_integration_pvt.wms_be_truck_load
500: OR business_event_id = wms_device_integration_pvt.wms_be_truck_load_ship);
501:
502: x_valid_device_for_txn := 1;
503:

Line 500: OR business_event_id = wms_device_integration_pvt.wms_be_truck_load_ship);

496: WHERE device_id = p_device_id
497: AND ENABLED_FLAG = 'Y'
498: AND organization_id = p_organization_id
499: AND (business_event_id = wms_device_integration_pvt.wms_be_truck_load
500: OR business_event_id = wms_device_integration_pvt.wms_be_truck_load_ship);
501:
502: x_valid_device_for_txn := 1;
503:
504: EXCEPTION

Line 522: (wms_device_integration_pvt.wms_be_std_insp_receipt,wms_device_integration_pvt.wms_be_direct_receipt);

518: WHERE device_id = p_device_id
519: AND ENABLED_FLAG = 'Y'
520: AND organization_id = p_organization_id
521: AND business_event_id IN
522: (wms_device_integration_pvt.wms_be_std_insp_receipt,wms_device_integration_pvt.wms_be_direct_receipt);
523:
524: x_valid_device_for_txn := 1;
525:
526: EXCEPTION

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

2931:
2932:
2933: IF L_return_status <> 'S' THEN
2934:
2935: 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);
2936: raise end_processing;
2937:
2938: END IF;
2939:

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

2998:
2999: --Insert generate XML/CSV or Call API for wms_be_rfid_error bus
3000: --event
3001: ROLLBACK TO wms_rfid_sp;
3002: 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);
3003: raise end_processing;
3004:
3005:
3006: ELSE --is_transaction_valid

Line 3089: IF l_out_business_event_id= wms_device_integration_pvt.wms_be_TRUCK_LOAD THEN

3085: trace('process_rfid_txn :Direct Ship');
3086: END IF;
3087:
3088:
3089: IF l_out_business_event_id= wms_device_integration_pvt.wms_be_TRUCK_LOAD THEN
3090:
3091: IF (l_debug = 1) THEN
3092: trace('process_rfid_txn :Processing Direct Truck Load');
3093: END IF;

Line 3119: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD,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);

3115: --Insert record into the WMS_DEVICE_REQUESTS table
3116: --Generate xml/call API for truck_load business event
3117: --populate in the history table
3118: ROLLBACK TO wms_rfid_sp1;
3119: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD,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);
3120: x_return_value := 'error';
3121:
3122: ELSE
3123: --Truck Load Txn Successful

Line 3124: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD,l_organization_id,l_lpn_id,l_output_method_id,l_subinventory_code,l_locator_id,'S', p_event_date,l_request_id,l_return_status);

3120: x_return_value := 'error';
3121:
3122: ELSE
3123: --Truck Load Txn Successful
3124: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD,l_organization_id,l_lpn_id,l_output_method_id,l_subinventory_code,l_locator_id,'S', p_event_date,l_request_id,l_return_status);
3125:
3126: END IF;
3127:
3128:

Line 3129: elsif l_out_business_event_id = wms_device_integration_pvt.wms_be_truck_load_ship THEN

3125:
3126: END IF;
3127:
3128:
3129: elsif l_out_business_event_id = wms_device_integration_pvt.wms_be_truck_load_ship THEN
3130:
3131: IF (l_debug = 1) THEN
3132: trace('process_rfid_txn :Processing Direct Truck Load and SHIP');
3133: END IF;

Line 3162: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD_SHIP,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);

3158: --Insert record into the WMS_DEVICE_REQUESTS table
3159: --Generate xml/call API for truck_load business event
3160: --populate in the history table
3161: ROLLBACK TO wms_rfid_sp1;
3162: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD_SHIP,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);
3163: x_return_value := 'error';
3164:
3165: ELSE
3166: --Truck Load Txn Successful

Line 3167: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD_SHIP,l_organization_id,l_lpn_id,l_output_method_id,l_subinventory_code,l_locator_id,'S', p_event_date,l_request_id,l_return_status);

3163: x_return_value := 'error';
3164:
3165: ELSE
3166: --Truck Load Txn Successful
3167: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD_SHIP,l_organization_id,l_lpn_id,l_output_method_id,l_subinventory_code,l_locator_id,'S', p_event_date,l_request_id,l_return_status);
3168:
3169: END IF;
3170:
3171: END IF; --FOR l_out_business_event_id

Line 3179: IF l_out_business_event_id= wms_device_integration_pvt.wms_be_TRUCK_LOAD THEN

3175: IF (l_debug = 1) THEN
3176: trace('process_rfid_txn :Normal LPN Ship');
3177: END IF;
3178:
3179: IF l_out_business_event_id= wms_device_integration_pvt.wms_be_TRUCK_LOAD THEN
3180:
3181: IF (l_debug = 1) THEN
3182: trace('process_rfid_txn :Processing Normal Truck Load');
3183: END IF;

Line 3216: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD,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);

3212: --Generate xml/call API for truck_load business event
3213: --populate in the history table
3214:
3215: ROLLBACK TO wms_rfid_sp1;
3216: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD,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);
3217: x_return_value := 'error';
3218: ELSE
3219: --Truck Load Txn Successful
3220: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD,l_organization_id,l_lpn_id,l_output_method_id,l_subinventory_code,l_locator_id,'S', p_event_date,l_request_id,l_return_status);

Line 3220: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD,l_organization_id,l_lpn_id,l_output_method_id,l_subinventory_code,l_locator_id,'S', p_event_date,l_request_id,l_return_status);

3216: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD,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);
3217: x_return_value := 'error';
3218: ELSE
3219: --Truck Load Txn Successful
3220: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD,l_organization_id,l_lpn_id,l_output_method_id,l_subinventory_code,l_locator_id,'S', p_event_date,l_request_id,l_return_status);
3221:
3222: END IF;
3223:
3224:

Line 3225: ELSIF l_out_business_event_id= wms_device_integration_pvt.wms_be_TRUCK_LOAD_ship THEN

3221:
3222: END IF;
3223:
3224:
3225: ELSIF l_out_business_event_id= wms_device_integration_pvt.wms_be_TRUCK_LOAD_ship THEN
3226:
3227: IF (l_debug = 1) THEN
3228: trace('process_rfid_txn :Processing Normal Truck Load and SHIP');
3229: END IF;

Line 3260: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD_ship,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);

3256: --Generate xml/call API for truck_load business event
3257: --populate in the history table
3258:
3259: ROLLBACK TO wms_rfid_sp1;
3260: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD_ship,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);
3261: x_return_value := 'error';
3262: ELSE
3263:
3264: --Truck Load ship Txn Successful

Line 3265: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD_ship,l_organization_id,l_lpn_id,l_output_method_id,l_subinventory_code,l_locator_id,'S', p_event_date,l_request_id,l_return_status);

3261: x_return_value := 'error';
3262: ELSE
3263:
3264: --Truck Load ship Txn Successful
3265: generate_xml_csv_api(l_device_id,wms_device_integration_pvt.wms_be_TRUCK_LOAD_ship,l_organization_id,l_lpn_id,l_output_method_id,l_subinventory_code,l_locator_id,'S', p_event_date,l_request_id,l_return_status);
3266:
3267: END IF;
3268:
3269: END IF;

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

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

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

3353: IF (l_debug = 1) THEN
3354: trace(' Error : inv_rcv_common_apis.failed in getting _routing_id');
3355: END IF;
3356: ROLLBACK TO wms_rfid_sp1;
3357: 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);
3358: raise end_processing;
3359:
3360: ELSE -- get_routing_id succeeded
3361:

Line 3369: IF ((l_routing_id = 3 AND l_out_business_event_id = wms_device_integration_pvt.wms_be_direct_receipt) OR

3365: --possible case: if the transaction record for rcv gives Direct
3366: --routing whereas the device_id passed is setup for Std/Insp
3367: --business event this transaction should fail
3368:
3369: IF ((l_routing_id = 3 AND l_out_business_event_id = wms_device_integration_pvt.wms_be_direct_receipt) OR
3370: (l_routing_id IN (1,2)
3371: AND l_out_business_event_id = wms_device_integration_pvt.wms_be_std_insp_receipt)) THEN
3372:
3373: IF (l_debug = 1) THEN

Line 3371: AND l_out_business_event_id = wms_device_integration_pvt.wms_be_std_insp_receipt)) THEN

3367: --business event this transaction should fail
3368:
3369: IF ((l_routing_id = 3 AND l_out_business_event_id = wms_device_integration_pvt.wms_be_direct_receipt) OR
3370: (l_routing_id IN (1,2)
3371: AND l_out_business_event_id = wms_device_integration_pvt.wms_be_std_insp_receipt)) THEN
3372:
3373: IF (l_debug = 1) THEN
3374: trace('process_rfid_txn: Processing receiving txn');
3375: END IF;

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

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);
3405: x_return_value := 'error';
3406:
3407: ELSIF l_routing_id = 3 THEN
3408: -- direct routing

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

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';
3416:
3417: END IF;
3418:

Line 3427: 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,'S', p_event_date,l_request_id,l_return_status);

3423: END IF;
3424:
3425: IF l_routing_id = 1 OR l_routing_id = 2 THEN
3426: --Standard/inspection routing
3427: 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,'S', p_event_date,l_request_id,l_return_status);
3428:
3429:
3430: ELSIF l_routing_id = 3 THEN
3431: -- direct routing

Line 3432: 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,'S', p_event_date,l_request_id,l_return_status);

3428:
3429:
3430: ELSIF l_routing_id = 3 THEN
3431: -- direct routing
3432: 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,'S', p_event_date,l_request_id,l_return_status);
3433:
3434: END IF;
3435:
3436:

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

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:
3450: END IF; --matching routing_id and l_out_business_event_id
3451:

Line 3482: IF l_out_business_event_id = wms_device_integration_pvt.wms_be_truck_load_ship THEN

3478: --We do populate mesg in case of succes too.
3479: --when the delivery or trip is complete.
3480:
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;