APPS.WMS_WCS_DEVICE_GRP dependencies on FND_PROFILE

Line 37: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2)
35: IS
36: l_device_id NUMBER := -1; -- Returned by get_device_info API
37: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
38: PRAGMA AUTONOMOUS_TRANSACTION;
39: BEGIN
40: x_return_status := FND_API.G_RET_STS_ERROR;
41:

Line 143: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2)
142: IS
143: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
144: PRAGMA AUTONOMOUS_TRANSACTION;
145: BEGIN
146: x_return_status := FND_API.G_RET_STS_ERROR;
147:

Line 199: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2)
198: IS
199: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
200: PRAGMA AUTONOMOUS_TRANSACTION;
201: BEGIN
202: x_return_status := FND_API.G_RET_STS_ERROR;
203:

Line 275: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

271: p_request_id IN OUT NOCOPY NUMBER,
272: p_device_id IN NUMBER
273: )
274: IS
275: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
276: BEGIN
277: x_return_status := FND_API.G_RET_STS_ERROR;
278:
279: IF (l_debug = 1) THEN

Line 372: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

368: FUNCTION IS_WCS_ENABLED(p_org_id IN NUMBER)
369: RETURN VARCHAR2
370: IS
371: l_is_wcs_enabled VARCHAR2(1);
372: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
373: PRAGMA AUTONOMOUS_TRANSACTION;
374: BEGIN
375: l_is_wcs_enabled := (WMS_DEVICES_PKG.is_wcs_enabled(p_org_id => p_org_id));
376: IF (l_debug = 1) THEN

Line 405: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

401: x_msg_data OUT NOCOPY VARCHAR2)
402: IS
403: l_successful_row_cnt NUMBER;
404: l_request_id NUMBER;
405: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
406: BEGIN
407: x_return_status := fnd_api.g_ret_sts_success;
408: IF l_debug >= 1 THEN
409: LOG(p_device_id, 'In WMS_WCS_DEVICE_GRP.PROCESS_RESPONSE for p_request_id='

Line 502: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

498: l_wf NUMBER;
499: l_return_status VARCHAR2 (10);
500: l_msg_count NUMBER;
501: l_msg_data VARCHAR2 (4000);
502: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
503: PRAGMA AUTONOMOUS_TRANSACTION;
504: BEGIN
505: BEGIN
506: SELECT 1