APPS.WMS_CROSS_DOCK_PVT dependencies on FND_PROFILE

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

9: PROCEDURE mydebug(msg in varchar2)
10: IS
11: l_msg VARCHAR2(5100);
12: l_ts VARCHAR2(30);
13: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
14: BEGIN
15:
16: select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
17: l_msg:=l_ts||' '||msg;

Line 59: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

55: ) IS
56:
57: l_api_name CONSTANT VARCHAR2(30) := 'check_crossdock';
58: l_progress VARCHAR2(10);
59: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
60:
61: l_org_id NUMBER;
62: l_lpn_id NUMBER;
63: l_line_id NUMBER;

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

1286: FROM wms_license_plate_numbers
1287: START WITH lpn_id = p_innermost_lpn_id
1288: CONNECT BY lpn_id = PRIOR parent_lpn_id;
1289:
1290: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1291: BEGIN
1292:
1293: l_return_status:= FND_API.G_RET_STS_SUCCESS;
1294:

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

2312: l_msg_count NUMBER;
2313: l_msg_data VARCHAR2(240);
2314: l_return_status VARCHAR2(1);
2315:
2316: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2317: BEGIN
2318:
2319: IF (l_debug = 1) THEN
2320: mydebug('in mark delivery as submitted');