APPS.WMS_CROSS_DOCK_PVT dependencies on FND_PROFILE

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

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

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

64: x_msg_data OUT NOCOPY VARCHAR2
65: )
66: IS
67: l_user_id NUMBER;
68: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
69: BEGIN
70: -- Initialize API return status to success
71: x_return_status := fnd_api.g_ret_sts_success;
72:

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

281: ) IS
282:
283: l_api_name CONSTANT VARCHAR2(30) := 'check_crossdock';
284: l_progress VARCHAR2(10);
285: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
286:
287: l_org_id NUMBER;
288: l_lpn_id NUMBER;
289: l_line_id NUMBER;

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

1567: FROM wms_license_plate_numbers
1568: START WITH lpn_id = p_innermost_lpn_id
1569: CONNECT BY lpn_id = PRIOR parent_lpn_id;
1570:
1571: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1572: BEGIN
1573:
1574: l_return_status:= FND_API.G_RET_STS_SUCCESS;
1575:

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

2668: l_msg_count NUMBER;
2669: l_msg_data VARCHAR2(240);
2670: l_return_status VARCHAR2(1);
2671:
2672: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2673: BEGIN
2674:
2675: IF (l_debug = 1) THEN
2676: mydebug('in mark delivery as submitted');