eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_STATUS_PKG dependencies on FND_PROFILE

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

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

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

172: FROM MTL_LOT_NUMBERS
173: WHERE organization_id = p_org_id
174: AND inventory_item_id = p_item_id
175: AND lot_number BETWEEN p_from_lot AND p_to_lot;
176: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
177: BEGIN
178: x_Status := 'C';
179: FOR cc IN lot_cur LOOP
180: if first_row then

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

253: --AND current_status in (1, 3, 5)
254: AND current_status in (1, 3, 5, 7)
255: AND serial_number BETWEEN p_from_serial AND p_to_serial;
256:
257: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
258: BEGIN
259: x_Status := 'C';
260: FOR cc IN serial_cur LOOP
261: if first_row then

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

692: --LPN status project end
693:
694:
695:
696: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
697: l_allow_mixed_status NUMBER := NVL(FND_PROFILE.VALUE('WMS_ALLOW_MIXED_STATUS'),2);--lpn status project
698: l_ret_status varchar2(20) := 'S';
699: l_outermost_lpn_id NUMBER;
700: l_count NUMBER :=0; -- Bug 6798024

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

693:
694:
695:
696: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
697: l_allow_mixed_status NUMBER := NVL(FND_PROFILE.VALUE('WMS_ALLOW_MIXED_STATUS'),2);--lpn status project
698: l_ret_status varchar2(20) := 'S';
699: l_outermost_lpn_id NUMBER;
700: l_count NUMBER :=0; -- Bug 6798024
701: l_serial_status_control NUMBER := 1;--bug 6952533

Line 704: l_eres_enabled VARCHAR2(3) := NVL(fnd_profile.VALUE('INV_DEF_ERES_ENABLED'), 'N');

700: l_count NUMBER :=0; -- Bug 6798024
701: l_serial_status_control NUMBER := 1;--bug 6952533
702: l_status_group_id NUMBER := NULL; --Bug#11826279
703: --ERES Deferred
704: l_eres_enabled VARCHAR2(3) := NVL(fnd_profile.VALUE('INV_DEF_ERES_ENABLED'), 'N');
705: l_pending_eres_chk NUMBER :=0;
706: -- e_invalid_update EXCEPTION;
707:
708: BEGIN

Line 713: l_multiple_app := NVL(FND_PROFILE.VALUE('INV_ERES_MULTIPLE_SIGNATURE'),0); --ERES Deferred

709: IF (l_debug = 1) THEN
710: mdebug('p_group_id is: '||p_group_id);
711: END IF;
712:
713: l_multiple_app := NVL(FND_PROFILE.VALUE('INV_ERES_MULTIPLE_SIGNATURE'),0); --ERES Deferred
714:
715: --BEGIN SCHANDRU INVERES
716: IF p_update_from_mobile = 'Y' THEN
717: SAVEPOINT INV_UPDATE_STATUS;

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

1439: lX_PRIMARY_QUANTITY NUMBER;
1440: lX_TRANSACTION_QUANTITY NUMBER;
1441: lX_RESERVATION_ID NUMBER;
1442:
1443: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1444: BEGIN
1445: IF (l_debug = 1) THEN
1446: mdebug('In invoke_reason_wf');
1447: END IF;