APPS.WMS_WORKFLOW_WRAPPERS dependencies on FND_PROFILE

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

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

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

63: lX_PRIMARY_QUANTITY NUMBER;
64: lX_TRANSACTION_QUANTITY NUMBER;
65: lX_RESERVATION_ID NUMBER;
66:
67: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
68: BEGIN
69: IF (l_debug = 1) THEN
70: mdebug('In workflow wrapper');
71: END IF;

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

402: -- debug variable
403:
404: l_api_name CONSTANT VARCHAR2(30) := 'wf_start_workflow';
405:
406: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
407: BEGIN
408: IF (l_debug = 1) THEN
409: mdebug('In Start_Workflow');
410: END IF;

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

1478: lp_sub_code VARCHAR2(10);
1479: lp_line_num NUMBER;
1480:
1481:
1482: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1483: BEGIN
1484: IF (l_debug = 1) THEN
1485: mdebug('In WMS_Suggest_Alt_Loc');
1486: END IF;

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

1810: l_locator_id NUMBER;
1811: l_inventory_item_id NUMBER; --BUG #2867331
1812:
1813: lmsg varchar(300); /*for debugging cycle count call*/
1814: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1815: --Bug 7504490 l_allocated_lpn_id
1816: l_allocated_lpn_id NUMBER;
1817: l_revision VARCHAR2(250);
1818:

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

2036: l_workflow_name VARCHAR2(250);
2037: l_item_key VARCHAR2(250);
2038: l_txn_header_id NUMBER;
2039:
2040: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2041:
2042: lx_return_status VARCHAR2(1);
2043: BEGIN
2044: IF (l_debug = 1) THEN

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

2151: l_old_sub_code VARCHAR2(30);
2152: l_old_loc_id NUMBER;
2153: l_task_type_id NUMBER;
2154:
2155: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2156: BEGIN
2157: IF (l_debug = 1) THEN
2158: mdebug('in wf_generate_next_task');
2159: END IF;

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

2277: funcmode IN VARCHAR2,
2278: result OUT NOCOPY VARCHAR2)
2279:
2280: IS
2281: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2282: BEGIN
2283: IF (l_debug = 1) THEN
2284: mdebug('In wf_send_to_bg');
2285: END IF;

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

2340: lX_RESERVATION_ID NUMBER;
2341: lX_IS_RESERVATION_SUCCESSFUL VARCHAR2(250);
2342: lX_IS_CYCLE_COUNT_SUCCESSFUL VARCHAR2(250);
2343:
2344: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2345: BEGIN
2346: IF (l_debug = 1) THEN
2347: mdebug('In workflow wrapper');
2348: END IF;

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

2541: ; lp_sub_code VARCHAR2(10)
2542: ; lp_line_num NUMBER
2543: ;
2544:
2545: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2546: BEGIN
2547: IF (l_debug = 1) THEN
2548: mdebug('In WMS_Inadequate_Quantity');
2549: END IF;