APPS.WMS_TASK_DISPATCH_DEVICE dependencies on FND_API

Line 44: x_return_status := FND_API.G_RET_STS_SUCCESS;

40: l_device_status VARCHAR2(400);
41: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
42: l_wcs_enabled VARCHAR2(1);
43: BEGIN
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45:
46: IF (l_debug = 1) THEN
47: mydebug('In insert_device');
48: END IF;

Line 108: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

104: mydebug('Status Code : '||x_return_status);
105: mydebug('Device Status : '||l_device_status);
106: END IF;
107:
108: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
109: -- Have to commit it, so that the others can see it and current devices can see it
110: COMMIT;
111: END IF;
112:

Line 115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

111: END IF;
112:
113: EXCEPTION
114: WHEN OTHERS THEN
115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
116: END insert_device;
117:
118:
119:

Line 141: x_return_status := FND_API.G_RET_STS_SUCCESS;

137: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
138: l_wcs_enabled VARCHAR2(1);
139: BEGIN
140:
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142:
143: IF (l_debug = 1) THEN
144: mydebug('In cleanup_device_and_tasks');
145: END IF;

Line 185: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

181: mydebug('Status Code : '||x_return_status);
182: mydebug('Device Status : '||l_device_status);
183: END IF;
184:
185: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
186: EXIT;
187: END IF;
188:
189: END LOOP;

Line 215: IF (x_return_status = FND_API.g_ret_sts_success) THEN

211: and task_type IN (1,3,4,5,6);
212: END IF;
213:
214: -- Commit so that task dispatching can see it
215: IF (x_return_status = FND_API.g_ret_sts_success) THEN
216: COMMIT;
217: END IF;
218:
219: EXCEPTION

Line 221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

217: END IF;
218:
219: EXCEPTION
220: WHEN OTHERS THEN
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: END cleanup_device_and_tasks;
223:
224: /*
225: This is the overloaded procedure

Line 254: x_return_status := FND_API.G_RET_STS_SUCCESS;

250: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
251: l_wcs_enabled VARCHAR2(1);
252: BEGIN
253:
254: x_return_status := FND_API.G_RET_STS_SUCCESS;
255:
256: IF (l_debug = 1) THEN
257: mydebug('In Overloaded cleanup_device_and_tasks');
258: END IF;

Line 298: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

294: mydebug('Status Code : '||x_return_status);
295: mydebug('Device Status : '||l_device_status);
296: END IF;
297:
298: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
299: EXIT;
300: END IF;
301:
302: END LOOP;

Line 331: IF (x_return_status = FND_API.g_ret_sts_success) THEN

327: and task_type IN (1,3,4,5,6);
328: END IF;
329:
330: -- Commit so that task dispatching can see it
331: IF (x_return_status = FND_API.g_ret_sts_success) THEN
332: COMMIT;
333: END IF;
334:
335: EXCEPTION

Line 337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

333: END IF;
334:
335: EXCEPTION
336: WHEN OTHERS THEN
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
338: END cleanup_device_and_tasks; -- End of overloaded procedure
339:
340: --J Develop
341:

Line 373: x_return_status := FND_API.G_RET_STS_SUCCESS;

369: For device_type_id=100 (Workstation) Sub will be NULL
370: ***********************************************************************************/
371:
372: BEGIN
373: x_return_status := FND_API.G_RET_STS_SUCCESS;
374: x_signed_onto_wrk_stn := 'Y';
375: l_is_multi_signon_dev := wms_devices_pkg.is_device_multisignon(p_organization_id, p_device_name);
376: is_org_wcs_enabled := wms_devices_pkg.is_wcs_enabled(p_organization_id);
377: IF (l_debug = 1) THEN

Line 454: x_return_status := FND_API.G_RET_STS_ERROR;

450: AND name = p_device_name
451: AND device_type_id <> 7 ;
452: EXCEPTION
453: WHEN no_data_found THEN
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: WHEN OTHERS THEN
456: x_return_status := FND_API.g_ret_sts_unexp_error;
457: END;
458: WHEN using_asrs_without_wrk_stn THEN

Line 456: x_return_status := FND_API.g_ret_sts_unexp_error;

452: EXCEPTION
453: WHEN no_data_found THEN
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: WHEN OTHERS THEN
456: x_return_status := FND_API.g_ret_sts_unexp_error;
457: END;
458: WHEN using_asrs_without_wrk_stn THEN
459: x_return_status := FND_API.G_RET_STS_ERROR;
460: x_signed_onto_wrk_stn := 'N';

Line 459: x_return_status := FND_API.G_RET_STS_ERROR;

455: WHEN OTHERS THEN
456: x_return_status := FND_API.g_ret_sts_unexp_error;
457: END;
458: WHEN using_asrs_without_wrk_stn THEN
459: x_return_status := FND_API.G_RET_STS_ERROR;
460: x_signed_onto_wrk_stn := 'N';
461: END get_device_info;
462:
463: