APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on FND_PROFILE

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

21: -----------------------------------------------------
22: -- trace
23: -----------------------------------------------------
24: PROCEDURE trace(p_msg IN VARCHAR2) IS
25: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
26: BEGIN
27: inv_trx_util_pub.trace(p_msg, 'WMS_DEVICE_CONFIRMATION_PUB', 9);
28: END trace;
29:

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

56: AND task_id = p_txn_temp_id
57: AND business_event_id IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm)
58: AND task_summary = 'N';
59:
60: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
61:
62: BEGIN
63: IF (l_debug = 1) THEN
64: trace('Inside validate_child_record');

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

243: FROM wms_device_requests
244: WHERE business_event_id IN (wms_device_integration_pvt.wms_be_load_confirm,wms_device_integration_pvt.wms_be_task_confirm)
245: ORDER BY relation_id ASC,task_id ASC, task_summary desc;
246:
247: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
248: BEGIN
249:
250: SELECT wms_device_requests_s.nextval INTO l_request_id FROM dual;
251: IF (l_debug = 1) THEN

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

372: ---------------------------------------------------------
373: FUNCTION GET_MSG_STACK RETURN VARCHAR2 IS
374: l_msg_count number;
375: l_msg_data varchar2(240);
376: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
377: BEGIN
378: fnd_msg_pub.count_And_get(
379: p_count => l_msg_count,
380: p_data => l_msg_data,

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

399: PROCEDURE update_wdr_for_error_rec(p_task_id IN NUMBER
400: ,p_relation_id IN NUMBER) IS
401: l_status_msg VARCHAR2(240);
402:
403: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
404: BEGIN
405: l_status_msg := get_msg_stack;--only last message
406: --IN the stack
407: UPDATE wms_device_requests

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

564: FROM
565: mtl_transaction_lots_temp mtlt
566: WHERE mtlt.transaction_temp_id = p_temp_id;
567:
568: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
569: BEGIN
570:
571: IF (l_debug = 1) THEN
572: trace('lpn_match: In lpn Match');

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

2656: AND device_status = 'S'
2657: AND task_summary = 'Y';
2658:
2659:
2660: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2661: BEGIN
2662: x_successful_row_cnt := 0;
2663: x_return_status:=FND_API.G_RET_STS_SUCCESS;
2664: