APPS.WMS_EXPRESS_PICK_TASK dependencies on FND_PROFILE

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

7:
8: L_MSG VARCHAR2(5100);
9: L_TS VARCHAR2(30);
10:
11: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12: BEGIN
13:
14: L_MSG := MSG;
15:

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

38: L_TRANSACTION_SOURCE_TYPE_ID NUMBER;
39: L_BUSINESS_FLOW_CODE NUMBER := INV_LABEL.WMS_BF_PICK_LOAD;
40: L_LABEL_STATUS VARCHAR2(100);
41:
42: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
43: BEGIN
44:
45: IF (l_debug = 1) THEN
46: MYDEBUG('IN PROCEDURE PRINT_LABEL');

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

120: ) IS
121:
122: L_DUMMY NUMBER := 0;
123:
124: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
125: BEGIN
126:
127: BEGIN
128:

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

170: ) RETURN VARCHAR2 IS
171:
172: X_RETURN_STATUS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
173:
174: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
175: BEGIN
176:
177: SELECT IS_EXPRESS_PICK_TASK_ELIGIBLE(WDT.TRANSACTION_TEMP_ID)
178: INTO X_RETURN_STATUS

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

241:
242: -- bug 2675498
243:
244:
245: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
246: BEGIN
247:
248: IF (l_debug = 1) THEN
249: MYDEBUG('IS_EXPRESS_PICK_TASK_ELIGIBLE: TRANSACTION_TEMP_ID: '||TO_CHAR(P_TRANSACTION_TEMP_ID));

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

523: L_MMTT_TO_UPDATE VARCHAR2(100) := '';
524: L_OK_TO_PROCESS VARCHAR2(100) := 'false';
525: L_TXN_HDR_ID NUMBER := 0;
526:
527: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
528: BEGIN
529:
530: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
531:

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

670: P_USER_ID IN NUMBER
671: ) IS
672: l_lpn_id NUMBER := p_lpn_id;
673: l_temp_id NUMBER := p_temp_id;
674: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
675: BEGIN
676: IF (l_debug = 1) THEN
677: mydebug('in procedure load_task');
678: END IF;

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

747: l_lpn_id NUMBER := p_lpn_id;
748: l_temp_id NUMBER := p_temp_id;
749: l_txn_hdr_id NUMBER := 0;
750: s_ok_to_process VARCHAR2(10);
751: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
752: BEGIN
753:
754: IF (l_debug = 1) THEN
755: mydebug('in prod drop_task');