DBA Data[Home] [Help]

APPS.WMS_POSTALLOC_PVT dependencies on WMS_DEVICE_INTEGRATION_PVT

Line 5663: wms_device_integration_pvt.is_device_set_up

5659: , l_api_name);
5660: END IF;
5661:
5662: l_api_return_status := fnd_api.g_ret_sts_success;
5663: wms_device_integration_pvt.is_device_set_up
5664: ( p_org_id => p_organization_id
5665: , p_bus_event_id => 11
5666: , x_return_status => l_api_return_status
5667: );

Line 5682: || wms_device_integration_pvt.wms_call_device_request

5678: END IF;
5679:
5680: IF g_debug = 1 THEN
5681: print_debug( 'Value of wms_call_device_request: '
5682: || wms_device_integration_pvt.wms_call_device_request
5683: , l_api_name);
5684: END IF;
5685:
5686: IF wms_device_integration_pvt.wms_call_device_request = 1 THEN

Line 5686: IF wms_device_integration_pvt.wms_call_device_request = 1 THEN

5682: || wms_device_integration_pvt.wms_call_device_request
5683: , l_api_name);
5684: END IF;
5685:
5686: IF wms_device_integration_pvt.wms_call_device_request = 1 THEN
5687: l_bus_event_id := wms_device_integration_pvt.wms_be_pick_release;
5688: ELSE
5689: RETURN;
5690: END IF;

Line 5687: l_bus_event_id := wms_device_integration_pvt.wms_be_pick_release;

5683: , l_api_name);
5684: END IF;
5685:
5686: IF wms_device_integration_pvt.wms_call_device_request = 1 THEN
5687: l_bus_event_id := wms_device_integration_pvt.wms_be_pick_release;
5688: ELSE
5689: RETURN;
5690: END IF;
5691:

Line 5738: VALUES( wms_device_integration_pvt.wms_pkRel_dev_req_id --global var same for all pick release lines

5734: , transaction_quantity
5735: , last_update_date
5736: , last_updated_by
5737: , device_id )
5738: VALUES( wms_device_integration_pvt.wms_pkRel_dev_req_id --global var same for all pick release lines
5739: , t_transaction_temp_id(ii)
5740: , 'Y'
5741: , 1 --"LOAD"
5742: , l_bus_event_id

Line 5781: VALUES( wms_device_integration_pvt.wms_pkRel_dev_req_id

5777: , transaction_quantity
5778: , last_update_date
5779: , last_updated_by
5780: , device_id )
5781: VALUES( wms_device_integration_pvt.wms_pkRel_dev_req_id
5782: , t_transaction_temp_id(jj)
5783: , 'Y'
5784: , 2 --"DROP"
5785: , l_bus_event_id

Line 5831: ( SELECT wms_device_integration_pvt.wms_pkRel_dev_req_id

5827: , status_code
5828: , last_update_date
5829: , last_updated_by
5830: , last_update_login )
5831: ( SELECT wms_device_integration_pvt.wms_pkRel_dev_req_id
5832: , t_transaction_temp_id(kk)
5833: , NULL
5834: , NULL
5835: , 'N'

Line 5864: SELECT wms_device_integration_pvt.wms_pkRel_dev_req_id

5860: AND t_dev_id(kk) IS NOT NULL
5861: AND t_lot_serial_capable_flag(kk) <> 'N'
5862: AND mtlt.serial_transaction_temp_id IS NULL
5863: UNION ALL
5864: SELECT wms_device_integration_pvt.wms_pkRel_dev_req_id
5865: , t_transaction_temp_id(kk)
5866: , NULL
5867: , NULL
5868: , 'N'

Line 5896: SELECT wms_device_integration_pvt.wms_pkRel_dev_req_id

5892: WHERE msnt.transaction_temp_id = t_transaction_temp_id(kk)
5893: AND t_dev_id(kk) IS NOT NULL
5894: AND t_lot_serial_capable_flag(kk) <> 'N'
5895: UNION ALL
5896: SELECT wms_device_integration_pvt.wms_pkRel_dev_req_id
5897: , t_transaction_temp_id(kk)
5898: , NULL
5899: , NULL
5900: , 'N'

Line 6005: VALUES( wms_device_integration_pvt.wms_pkRel_dev_req_id

6001: , transaction_quantity
6002: , last_update_date
6003: , last_updated_by
6004: , device_id )
6005: VALUES( wms_device_integration_pvt.wms_pkRel_dev_req_id
6006: , t_transaction_temp_id(ll)
6007: , 'Y'
6008: , 2 --"DROP"
6009: , l_bus_event_id

Line 6107: VALUES( wms_device_integration_pvt.wms_pkRel_dev_req_id

6103: , transaction_quantity
6104: , last_update_date
6105: , last_updated_by
6106: , device_id )
6107: VALUES( wms_device_integration_pvt.wms_pkRel_dev_req_id
6108: , t_transaction_temp_id(mm)
6109: , 'Y'
6110: , 1 --"LOAD"
6111: , l_bus_event_id

Line 6161: ( SELECT wms_device_integration_pvt.wms_pkRel_dev_req_id

6157: , status_code
6158: , last_update_date
6159: , last_updated_by
6160: , last_update_login )
6161: ( SELECT wms_device_integration_pvt.wms_pkRel_dev_req_id
6162: , t_transaction_temp_id(nn)
6163: , NULL
6164: , NULL
6165: , 'N'

Line 6194: SELECT wms_device_integration_pvt.wms_pkRel_dev_req_id

6190: AND t_dev_id(nn) IS NOT NULL
6191: AND t_lot_serial_capable_flag(nn) <> 'N'
6192: AND mtlt.serial_transaction_temp_id IS NULL
6193: UNION ALL
6194: SELECT wms_device_integration_pvt.wms_pkRel_dev_req_id
6195: , t_transaction_temp_id(nn)
6196: , NULL
6197: , NULL
6198: , 'N'

Line 6226: SELECT wms_device_integration_pvt.wms_pkRel_dev_req_id

6222: WHERE msnt.transaction_temp_id = t_transaction_temp_id(nn)
6223: AND t_dev_id(nn) IS NOT NULL
6224: AND t_lot_serial_capable_flag(nn) <> 'N'
6225: UNION ALL
6226: SELECT wms_device_integration_pvt.wms_pkRel_dev_req_id
6227: , t_transaction_temp_id(nn)
6228: , NULL
6229: , NULL
6230: , 'N'

Line 6271: wms_device_integration_pvt.device_request

6267:
6268: COMMIT;
6269:
6270: l_api_return_status := fnd_api.g_ret_sts_success;
6271: wms_device_integration_pvt.device_request
6272: ( p_bus_event => wms_device_integration_pvt.wms_be_pick_release
6273: , p_call_ctx => wms_device_integration_pvt.dev_req_auto
6274: , p_task_trx_id => p_mo_header_id -- p_organization_id;bug 9130704
6275: , p_org_id => p_organization_id -- p_mo_header_id;bug 9130704

Line 6272: ( p_bus_event => wms_device_integration_pvt.wms_be_pick_release

6268: COMMIT;
6269:
6270: l_api_return_status := fnd_api.g_ret_sts_success;
6271: wms_device_integration_pvt.device_request
6272: ( p_bus_event => wms_device_integration_pvt.wms_be_pick_release
6273: , p_call_ctx => wms_device_integration_pvt.dev_req_auto
6274: , p_task_trx_id => p_mo_header_id -- p_organization_id;bug 9130704
6275: , p_org_id => p_organization_id -- p_mo_header_id;bug 9130704
6276: , x_request_msg => l_req_msg

Line 6273: , p_call_ctx => wms_device_integration_pvt.dev_req_auto

6269:
6270: l_api_return_status := fnd_api.g_ret_sts_success;
6271: wms_device_integration_pvt.device_request
6272: ( p_bus_event => wms_device_integration_pvt.wms_be_pick_release
6273: , p_call_ctx => wms_device_integration_pvt.dev_req_auto
6274: , p_task_trx_id => p_mo_header_id -- p_organization_id;bug 9130704
6275: , p_org_id => p_organization_id -- p_mo_header_id;bug 9130704
6276: , x_request_msg => l_req_msg
6277: , x_return_status => l_api_return_status

Line 6312: WHERE request_id = wms_device_integration_pvt.wms_pkRel_dev_req_id;

6308: print_debug (l_msg_data, l_api_name);
6309: END IF;
6310:
6311: DELETE FROM wms_device_requests
6312: WHERE request_id = wms_device_integration_pvt.wms_pkRel_dev_req_id;
6313:
6314: COMMIT;
6315:
6316: IF c_non_bulk_tasks%ISOPEN THEN

Line 6333: WHERE request_id = wms_device_integration_pvt.wms_pkRel_dev_req_id;

6329: print_debug ('Other error: ' || SQLERRM, l_api_name);
6330: END IF;
6331:
6332: DELETE FROM wms_device_requests
6333: WHERE request_id = wms_device_integration_pvt.wms_pkRel_dev_req_id;
6334:
6335: COMMIT;
6336:
6337: IF c_non_bulk_tasks%ISOPEN THEN