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_DEVICE_INTEGRATION_PVT dependencies on WMS_DEVICE_REQUESTS_HIST

Line 9: SUBTYPE WDRH_ROW IS WMS_DEVICE_REQUESTS_HIST%ROWTYPE;

5: -----------------------------------------------------
6: -- Global declarations
7: -----------------------------------------------------
8: SUBTYPE WDR_ROW IS WMS_DEVICE_REQUESTS%ROWTYPE;
9: SUBTYPE WDRH_ROW IS WMS_DEVICE_REQUESTS_HIST%ROWTYPE;
10:
11:
12: -----------------------------------------------------
13: -- trace

Line 657: FROM wms_device_requests_hist

653: dev_id := 0;
654: BEGIN
655: SELECT device_id, task_id
656: INTO dev_id, par_task_id
657: FROM wms_device_requests_hist
658: WHERE request_id = p_parent_request_id
659: AND ROWNUM < 2;
660: EXCEPTION
661: WHEN OTHERS THEN

Line 1283: INSERT INTO wms_device_requests_hist (request_id,

1279: trace('outfile_name='||l_rec.outfile_name||'request_id:'||l_rec.request_id||'task_id:'||l_rec.task_id);
1280: END IF;
1281: */
1282: l_counter := l_counter +1;
1283: INSERT INTO wms_device_requests_hist (request_id,
1284: task_id,
1285: relation_id,
1286: sequence_id,
1287: task_summary,

Line 1462: from wms_device_requests_hist

1458: ,TRANSFER_ORG_ID
1459: ,TRANSFER_SUB_CODE
1460: ,UOM
1461: ,XFER_LPN_ID
1462: from wms_device_requests_hist
1463: WHERE request_id = p_request_id
1464: AND status_code ='P'
1465: AND Nvl(business_event_id,-1) = Nvl(p_bus_event_id,-1);
1466:

Line 1644: FROM wms_device_requests_hist

1640: RAISE FND_API.G_EXC_ERROR;
1641: ELSE
1642: BEGIN
1643: SELECT request_id INTO l_parent_request_id
1644: FROM wms_device_requests_hist
1645: WHERE request_id = p_request_id
1646: AND task_summary = 'Y';
1647: EXCEPTION
1648: WHEN no_data_found THEN

Line 1712: wms_device_requests_hist

1708: BEGIN
1709: SELECT TRANSFER_ORG_ID,TRANSFER_SUB_CODE,TRANSFER_LOC_ID
1710: INTO l_xfr_org_id,l_xfr_subinv,l_xfr_locator_id
1711: FROM
1712: wms_device_requests_hist
1713: WHERE REQUEST_ID=p_request_id;
1714: EXCEPTION
1715: WHEN no_data_found THEN
1716: IF (l_debug = 1) THEN

Line 1881: update wms_device_requests_hist

1877: update wms_device_requests
1878: set relation_id = l_parent_request_id
1879: where device_id = l_cur_dev.device_id;
1880:
1881: update wms_device_requests_hist
1882: set relation_id = l_parent_request_id
1883: where request_id = l_parent_request_id;
1884: EXCEPTION
1885: WHEN others THEN

Line 2101: The request traffic will get logged in the wms_device_requests_hist table

2097:
2098: Inserting into WDR is kept transparent to the OPM team who will call this
2099: through a wrapper API in a group package
2100:
2101: The request traffic will get logged in the wms_device_requests_hist table
2102: in addition to being captured in wms_carousel_log
2103: */
2104: PROCEDURE DEVICE_REQUEST(
2105: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

Line 2234: FROM wms_device_requests_hist

2230: RAISE FND_API.G_EXC_ERROR;
2231: ELSE
2232: BEGIN
2233: SELECT request_id INTO l_parent_request_id
2234: FROM wms_device_requests_hist
2235: WHERE request_id = p_request_id
2236: AND task_summary = 'Y';
2237: EXCEPTION
2238: WHEN no_data_found THEN

Line 2418: update wms_device_requests_hist

2414: update wms_device_requests
2415: set relation_id = l_parent_request_id
2416: where device_id = l_cur_dev.device_id;
2417:
2418: update wms_device_requests_hist
2419: set relation_id = l_parent_request_id
2420: where request_id = l_parent_request_id;
2421: EXCEPTION
2422: WHEN others THEN

Line 2588: FROM wms_device_requests_hist

2584: P_business_event_id IN NUMBER
2585: )IS
2586:
2587: CURSOR x_cur IS SELECT distinct device_id dev_id
2588: FROM wms_device_requests_hist
2589: WHERE Nvl(device_id, -1) = Nvl( p_device_id, -1)
2590: AND request_id = p_request_id
2591: AND status_code ='P'
2592: AND Nvl(sequence_id,-1) = Nvl(p_sequence_id,nvl(sequence_id, -1))

Line 2624: DELETE FROM wms_device_requests_hist

2620: IF (l_debug = 1) THEN
2621: trace('deleting all current error records from WDRH');
2622: END IF;
2623: --delete all current error records from WDRH
2624: DELETE FROM wms_device_requests_hist
2625: WHERE request_id = p_request_id
2626: AND status_code ='P'
2627: AND Nvl(sequence_id,-1) = Nvl(p_sequence_id,nvl(sequence_id, -1))
2628: AND Nvl(task_id,-1) = Nvl(p_task_trx_id,nvl(task_id, -1))

Line 2659: FROM wms_device_requests_hist

2655: ELSE--other business event
2656: BEGIN
2657: SELECT nvl(WCS_ENABLED,'N') into l_wcs_enabled FROM MTL_PARAMETERS
2658: WHERE ORGANIZATION_ID = (SELECT ORGANIZATION_ID
2659: FROM wms_device_requests_hist
2660: WHERE request_id = p_request_id
2661: AND status_code ='P'
2662: AND Nvl(business_event_id,-1) = Nvl(p_business_event_id,-1)
2663: AND ROWNUM < 2);

Line 2693: UPDATE wms_device_requests_hist

2689: x_status_msg => l_stat_msg );
2690: END IF;
2691:
2692: IF ( l_req_stat <> FND_API.g_ret_sts_success) THEN
2693: UPDATE wms_device_requests_hist
2694: SET status_code = l_req_stat,
2695: status_msg = l_stat_msg
2696: WHERE device_id = l_rec.dev_id
2697: AND request_id = p_request_id;

Line 2699: UPDATE wms_device_requests_hist

2695: status_msg = l_stat_msg
2696: WHERE device_id = l_rec.dev_id
2697: AND request_id = p_request_id;
2698: ELSE
2699: UPDATE wms_device_requests_hist
2700: SET status_code = 'S'
2701: WHERE device_id = l_rec.dev_id
2702: AND request_id = p_request_id;
2703: END IF;

Line 2726: UPDATE wms_device_requests_hist

2722: ( p_count => l_dev_req_type,
2723: p_data => l_req_stat
2724: );
2725: --this is set to P in the form while making call to concurrent req
2726: UPDATE wms_device_requests_hist
2727: SET status_code = 'E',resubmit_date = null
2728: WHERE request_id = p_request_id
2729: AND BUSINESS_EVENT_ID =p_business_event_id
2730: AND status_code = 'P';

Line 2744: UPDATE wms_device_requests_hist

2740: p_data => l_req_stat
2741: );
2742:
2743: --this is set to P in the form while making call to concurrent req
2744: UPDATE wms_device_requests_hist
2745: SET status_code = 'E',resubmit_date = null
2746: WHERE request_id = p_request_id
2747: AND BUSINESS_EVENT_ID =p_business_event_id
2748: AND status_code = 'P';

Line 2762: UPDATE wms_device_requests_hist

2758: ( p_count => l_dev_req_type,
2759: p_data => l_req_stat
2760: );
2761: --this is set to P in the form while making call to concurrent req
2762: UPDATE wms_device_requests_hist
2763: SET status_code = 'E',resubmit_date = null
2764: WHERE request_id = p_request_id
2765: AND BUSINESS_EVENT_ID =p_business_event_id
2766: AND status_code = 'P';

Line 2875: delete from wms_device_requests_hist

2871: l_ret := fnd_concurrent.set_completion_status('ERROR', 'WMS_MISS_REQ_PARAMETER');
2872: x_retcode := 2;
2873: x_errbuf := 'ERROR';
2874: ELSE
2875: delete from wms_device_requests_hist
2876: where creation_date < p_purge_date and organization_id = p_orgid ;
2877: delete from wms_lpn_histories
2878: where creation_date < p_purge_date and organization_id = p_orgid ;
2879: delete from wms_dispatched_tasks_history