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 2936: 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);

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

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

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

Line 3090: IF l_out_business_event_id= wms_device_integration_pvt.wms_be_TRUCK_LOAD THEN

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

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

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

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

3121: x_return_value := 'error';
3122:
3123: ELSE
3124: --Truck Load Txn Successful
3125: 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);
3126:
3127: END IF;
3128:
3129:

Line 3130: elsif l_out_business_event_id = wms_device_integration_pvt.wms_be_truck_load_ship THEN

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

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

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

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

3164: x_return_value := 'error';
3165:
3166: ELSE
3167: --Truck Load Txn Successful
3168: 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);
3169:
3170: END IF;
3171:
3172: END IF; --FOR l_out_business_event_id

Line 3180: IF l_out_business_event_id= wms_device_integration_pvt.wms_be_TRUCK_LOAD THEN

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

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

3213: --Generate xml/call API for truck_load business event
3214: --populate in the history table
3215:
3216: ROLLBACK TO wms_rfid_sp1;
3217: 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);
3218: x_return_value := 'error';
3219: ELSE
3220: --Truck Load Txn Successful
3221: 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 3221: 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);

3217: 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);
3218: x_return_value := 'error';
3219: ELSE
3220: --Truck Load Txn Successful
3221: 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);
3222:
3223: END IF;
3224:
3225:

Line 3226: ELSIF l_out_business_event_id= wms_device_integration_pvt.wms_be_TRUCK_LOAD_ship THEN

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

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

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

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

3262: x_return_value := 'error';
3263: ELSE
3264:
3265: --Truck Load ship Txn Successful
3266: 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);
3267:
3268: END IF;
3269:
3270: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3429:
3430:
3431: ELSIF l_routing_id = 3 THEN
3432: -- direct routing
3433: 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);
3434:
3435: END IF;
3436:
3437:

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

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

Line 3483: IF l_out_business_event_id = wms_device_integration_pvt.wms_be_truck_load_ship THEN

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