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 405: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

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

1470: lp_sub_code VARCHAR2(10);
1471: lp_line_num NUMBER;
1472:
1473:
1474: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1475: BEGIN
1476: IF (l_debug = 1) THEN
1477: mdebug('In WMS_Suggest_Alt_Loc');
1478: END IF;

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

1802: l_locator_id NUMBER;
1803: l_inventory_item_id NUMBER; --BUG #2867331
1804:
1805: lmsg varchar(300); /*for debugging cycle count call*/
1806: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1807: BEGIN
1808: IF (l_debug = 1) THEN
1809: mdebug('In Cycle_Count');
1810: END IF;

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

2009: l_workflow_name VARCHAR2(250);
2010: l_item_key VARCHAR2(250);
2011: l_txn_header_id NUMBER;
2012:
2013: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2014: BEGIN
2015: IF (l_debug = 1) THEN
2016: mdebug('In wf_is_task_processed');
2017: END IF;

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

2117: l_old_sub_code VARCHAR2(30);
2118: l_old_loc_id NUMBER;
2119: l_task_type_id NUMBER;
2120:
2121: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2122: BEGIN
2123: IF (l_debug = 1) THEN
2124: mdebug('in wf_generate_next_task');
2125: END IF;

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

2243: funcmode IN VARCHAR2,
2244: result OUT NOCOPY VARCHAR2)
2245:
2246: IS
2247: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2248: BEGIN
2249: IF (l_debug = 1) THEN
2250: mdebug('In wf_send_to_bg');
2251: END IF;

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

2306: lX_RESERVATION_ID NUMBER;
2307: lX_IS_RESERVATION_SUCCESSFUL VARCHAR2(250);
2308: lX_IS_CYCLE_COUNT_SUCCESSFUL VARCHAR2(250);
2309:
2310: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2311: BEGIN
2312: IF (l_debug = 1) THEN
2313: mdebug('In workflow wrapper');
2314: END IF;

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

2507: ; lp_sub_code VARCHAR2(10)
2508: ; lp_line_num NUMBER
2509: ;
2510:
2511: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2512: BEGIN
2513: IF (l_debug = 1) THEN
2514: mdebug('In WMS_Inadequate_Quantity');
2515: END IF;