APPS.INV_STATUS_PKG dependencies on FND_PROFILE

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

72: PROCEDURE mdebug(msg in varchar2)
73: IS
74: l_msg VARCHAR2(5100);
75: l_ts VARCHAR2(30);
76: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
77: BEGIN
78: select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
79:
80: l_msg:=l_ts||' '||msg;

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

116: FROM MTL_LOT_NUMBERS
117: WHERE organization_id = p_org_id
118: AND inventory_item_id = p_item_id
119: AND lot_number BETWEEN p_from_lot AND p_to_lot;
120: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
121: BEGIN
122: x_Status := 'C';
123: FOR cc IN lot_cur LOOP
124: if first_row then

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

197: --AND current_status in (1, 3, 5)
198: AND current_status in (1, 3, 5, 7)
199: AND serial_number BETWEEN p_from_serial AND p_to_serial;
200:
201: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
202: BEGIN
203: x_Status := 'C';
204: FOR cc IN serial_cur LOOP
205: if first_row then

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

353: --LPN status project end
354:
355:
356:
357: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
358: l_allow_mixed_status NUMBER := NVL(FND_PROFILE.VALUE('WMS_ALLOW_MIXED_STATUS'),2);--lpn status project
359: l_ret_status varchar2(20) := 'S';
360: l_outermost_lpn_id NUMBER;
361: l_count NUMBER :=0; -- Bug 6798024

Line 358: l_allow_mixed_status NUMBER := NVL(FND_PROFILE.VALUE('WMS_ALLOW_MIXED_STATUS'),2);--lpn status project

354:
355:
356:
357: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
358: l_allow_mixed_status NUMBER := NVL(FND_PROFILE.VALUE('WMS_ALLOW_MIXED_STATUS'),2);--lpn status project
359: l_ret_status varchar2(20) := 'S';
360: l_outermost_lpn_id NUMBER;
361: l_count NUMBER :=0; -- Bug 6798024
362: l_serial_status_control NUMBER := 1;--bug 6952533

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

817: lX_PRIMARY_QUANTITY NUMBER;
818: lX_TRANSACTION_QUANTITY NUMBER;
819: lX_RESERVATION_ID NUMBER;
820:
821: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
822: BEGIN
823: IF (l_debug = 1) THEN
824: mdebug('In invoke_reason_wf');
825: END IF;