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_EPC

Line 1826: PROCEDURE parse_read_tags(p_tagid IN WMS_EPC_TAGID_TYPE,

1822: END process_rfid_receiving_txn;
1823:
1824:
1825:
1826: PROCEDURE parse_read_tags(p_tagid IN WMS_EPC_TAGID_TYPE,
1827: p_org_id IN NUMBER,
1828: x_tag_info OUT nocopy tag_info_tbl,
1829: x_pallet_lpn_id OUT nocopy NUMBER,
1830: x_pallet_lpn_context OUT nocopy NUMBER,

Line 1907: wms_epc we

1903: BEGIN
1904: SELECT wlpn.lpn_id,wlpn.lpn_context,outermost_lpn_id INTO
1905: x_pallet_lpn_id,x_pallet_lpn_context,l_outermost_lpn_id
1906: FROM wms_license_plate_numbers wlpn,
1907: wms_epc we
1908: WHERE we.lpn_id = wlpn.lpn_id
1909: AND we.cross_ref_type =1 --LPN-EPC type
1910: AND we.epc = x_tag_info(1).tag_id
1911: AND ((wlpn.parent_lpn_id = wlpn.outermost_lpn_id AND wlpn.parent_lpn_id IS NOT null) OR

Line 1994: --cross-reference from wms_epc table based on EPC

1990: FOR i IN 1..x_tag_info.COUNT LOOP
1991:
1992: --CODE LOGIC
1993: --1- get the cross_ref_type and all relevant value for
1994: --cross-reference from wms_epc table based on EPC
1995: --2-Query respective tables to ensure that cross-referenced
1996: --object IS indeed correct and get other relevant parameter values
1997:
1998:

Line 2003: FROM wms_epc we

1999: BEGIN
2000:
2001: SELECT cross_ref_type , lpn_id , inventory_item_id, serial_number, gtin, gtin_serial
2002: INTO l_cross_ref_type , l_lpn_id , l_item_id, l_serial_number, l_gtin, l_gtin_serial
2003: FROM wms_epc we
2004: WHERE we.epc = x_tag_info(i).tag_id;
2005:
2006:
2007:

Line 2281: -- IF there is error then update wms_epc

2277:
2278: END IF;
2279:
2280:
2281: -- IF there is error then update wms_epc
2282: -- No need to insert into wms_device_Requests, as transaction is going
2283: --TO fail because OF the multiple palletS
2284:
2285: IF l_is_error = 1 THEN

Line 2288: UPDATE wms_epc

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

Line 2421: --Process them against our WMS_EPC table shipment verification

2417: END;
2418:
2419:
2420:
2421: --Process them against our WMS_EPC table shipment verification
2422: l_case_cnt :=0;
2423: l_serial_cnt := 0;
2424:
2425: FOR i IN 1..p_tag_info.COUNT LOOP

Line 2658: --1. UPDATE WMS_EPC TABLE FOR FAILURE FOR ALL READS

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
2659: --2. INSERT INTO WMS_DEVICE_REQUESTs TABLE FOR READ CASE TAGS, NOT THE PALLET
2660: -- pallet will be transferred in the process_rfid_txn table and all
2661: -- above records will be moved TO the wms_device_request_hist table
2662:

Line 2663: /* we can not use the group_id to update wms_epc table in one shot

2659: --2. INSERT INTO WMS_DEVICE_REQUESTs TABLE FOR READ CASE TAGS, NOT THE PALLET
2660: -- pallet will be transferred in the process_rfid_txn table and all
2661: -- above records will be moved TO the wms_device_request_hist table
2662:
2663: /* we can not use the group_id to update wms_epc table in one shot
2664: here as all records of the group_id might not be read. I have to
2665: update only those records which have been read by the reader.
2666: */
2667:

Line 2671: UPDATE wms_epc

2667:
2668: IF l_error_code = 1 THEN --Extraneous read
2669:
2670: FOR j IN 1..p_tag_info.COUNT LOOP
2671: UPDATE wms_epc
2672: SET status = l_msg_data,
2673: status_code = x_return_status
2674: WHERE EPC = p_tag_info(j).tag_id;--Since no LPN
2675: --corredponding TO the extraneous read

Line 2712: UPDATE wms_epc

2708:
2709: ELSE
2710:
2711: FOR j IN 1..p_tag_info.COUNT LOOP
2712: UPDATE wms_epc
2713: SET status = l_msg_data,
2714: status_code = x_return_status
2715: WHERE lpn_id = p_tag_info(j).lpn_id;
2716:

Line 2752: --1. UPDATE WMS_EPC TABLE FOR VERIFICATION SUCESSSFUL FOR ALL READS

2748: END IF;
2749:
2750: ELSIF x_return_status= 'S' THEN
2751:
2752: --1. UPDATE WMS_EPC TABLE FOR VERIFICATION SUCESSSFUL FOR ALL READS
2753: --NOTHING IN THE WMS_DEVICE_REQUEST table, no case records in the wms
2754: --device history TABLE IN successful scenario
2755:
2756: FOR j IN 1..p_tag_info.COUNT LOOP

Line 2757: UPDATE wms_epc

2753: --NOTHING IN THE WMS_DEVICE_REQUEST table, no case records in the wms
2754: --device history TABLE IN successful scenario
2755:
2756: FOR j IN 1..p_tag_info.COUNT LOOP
2757: UPDATE wms_epc
2758: SET status = l_msg_data,
2759: status_code = x_return_status
2760: WHERE EPC = p_tag_info(j).tag_id;
2761:

Line 2785: p_tagid in WMS_EPC_TAGID_TYPE, -- EPC TAGS ID VALUE, IN VARRAY

2781:
2782:
2783: procedure process_rfid_txn
2784: (
2785: p_tagid in WMS_EPC_TAGID_TYPE, -- EPC TAGS ID VALUE, IN VARRAY
2786: p_tagdata IN WMS_EPC_TAGDATA_TYPE,-- ANY ADDITIONAL DATA IN VARRAY
2787: p_portalid in VARCHAR2,
2788: p_event_date in date,
2789: p_system_id in VARCHAR2 DEFAULT null,

Line 2786: p_tagdata IN WMS_EPC_TAGDATA_TYPE,-- ANY ADDITIONAL DATA IN VARRAY

2782:
2783: procedure process_rfid_txn
2784: (
2785: p_tagid in WMS_EPC_TAGID_TYPE, -- EPC TAGS ID VALUE, IN VARRAY
2786: p_tagdata IN WMS_EPC_TAGDATA_TYPE,-- ANY ADDITIONAL DATA IN VARRAY
2787: p_portalid in VARCHAR2,
2788: p_event_date in date,
2789: p_system_id in VARCHAR2 DEFAULT null,
2790: p_statuschange in NUMBER DEFAULT null,

Line 3056: -- commit all the changes in the WMS_EPC table

3052:
3053: trace(' verify_load returned status:'||l_return_status);
3054:
3055: --Whatever happens in verification later, result of verficiation needs to be commited
3056: -- commit all the changes in the WMS_EPC table
3057: COMMIT;
3058:
3059:
3060: IF l_return_status <> 'S' THEN

Line 3523: p_tagid in WMS_EPC_TAGID_TYPE, -- EPC TAGS ID VALUE, IN VARRAY

3519:
3520:
3521: Procedure WMS_READ_EVENT
3522: (
3523: p_tagid in WMS_EPC_TAGID_TYPE, -- EPC TAGS ID VALUE, IN VARRAY
3524: p_tagdata IN WMS_EPC_TAGDATA_TYPE, -- ANY ADDITIONAL DATA IN VARRAY
3525: p_portalid in VARCHAR2,
3526: p_event_date in date,
3527: p_system_id in VARCHAR2 DEFAULT null,

Line 3524: p_tagdata IN WMS_EPC_TAGDATA_TYPE, -- ANY ADDITIONAL DATA IN VARRAY

3520:
3521: Procedure WMS_READ_EVENT
3522: (
3523: p_tagid in WMS_EPC_TAGID_TYPE, -- EPC TAGS ID VALUE, IN VARRAY
3524: p_tagdata IN WMS_EPC_TAGDATA_TYPE, -- ANY ADDITIONAL DATA IN VARRAY
3525: p_portalid in VARCHAR2,
3526: p_event_date in date,
3527: p_system_id in VARCHAR2 DEFAULT null,
3528: p_statuschange in NUMBER DEFAULT null,

Line 3548: p_tagid in WMS_EPC_TAGID_TYPE, -- EPC TAGS ID VALUE, IN VARRAY

3544:
3545:
3546: procedure process_rfid_txn
3547: (
3548: p_tagid in WMS_EPC_TAGID_TYPE, -- EPC TAGS ID VALUE, IN VARRAY
3549: p_tagdata IN WMS_EPC_TAGDATA_TYPE, -- ANY ADDITIONAL DATA IN VARRAY
3550: p_portalid in VARCHAR2,--Device name as varchar2
3551: p_event_date in date,
3552: p_system_id in VARCHAR2 DEFAULT null,

Line 3549: p_tagdata IN WMS_EPC_TAGDATA_TYPE, -- ANY ADDITIONAL DATA IN VARRAY

3545:
3546: procedure process_rfid_txn
3547: (
3548: p_tagid in WMS_EPC_TAGID_TYPE, -- EPC TAGS ID VALUE, IN VARRAY
3549: p_tagdata IN WMS_EPC_TAGDATA_TYPE, -- ANY ADDITIONAL DATA IN VARRAY
3550: p_portalid in VARCHAR2,--Device name as varchar2
3551: p_event_date in date,
3552: p_system_id in VARCHAR2 DEFAULT null,
3553: p_statuschange in NUMBER DEFAULT null,

Line 3624: epc_tag_id wms_epc_tagid_type;

3620: l_index NUMBER;
3621:
3622: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3623:
3624: epc_tag_id wms_epc_tagid_type;
3625: epc_tag_data wms_epc_tagdata_type;
3626:
3627:
3628: BEGIN

Line 3625: epc_tag_data wms_epc_tagdata_type;

3621:
3622: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3623:
3624: epc_tag_id wms_epc_tagid_type;
3625: epc_tag_data wms_epc_tagdata_type;
3626:
3627:
3628: BEGIN
3629:

Line 3636: epc_tag_id := wms_epc_tagid_type('S');

3632: trace('Inside MobTest_process_rfid_txn');
3633: END IF;
3634:
3635: --Initialize the varray
3636: epc_tag_id := wms_epc_tagid_type('S');
3637: epc_tag_data := wms_epc_tagdata_type('S');
3638:
3639:
3640: IF p_tagid IS NOT null then

Line 3637: epc_tag_data := wms_epc_tagdata_type('S');

3633: END IF;
3634:
3635: --Initialize the varray
3636: epc_tag_id := wms_epc_tagid_type('S');
3637: epc_tag_data := wms_epc_tagdata_type('S');
3638:
3639:
3640: IF p_tagid IS NOT null then
3641: IF (l_debug = 1) THEN