APPS.WMS_WIP_XDOCK_PVT dependencies on FND_PROFILE

Line 12: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

8:
9: PROCEDURE mydebug(msg IN VARCHAR2) 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')
15: INTO l_ts
16: FROM DUAL;

Line 113: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

109: AND(l.quantity_detailed IS NULL
110: OR l.quantity_delivered IS NULL
111: OR l.quantity_delivered = 0) ;
112:
113: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
114: l_tmp_line_id NUMBER;
115: BEGIN
116: l_return_status := fnd_api.g_ret_sts_success;
117:

Line 962: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

958: SELECT fm_serial_number
959: FROM mtl_serial_numbers_temp
960: WHERE transaction_temp_id = l_serial_temp_id;
961:
962: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
963: BEGIN
964: l_return_status := fnd_api.g_ret_sts_success;
965:
966: IF (l_debug = 1) THEN

Line 1296: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1292: l_msg_count NUMBER;
1293: l_msg_data VARCHAR2(240);
1294: l_return_status VARCHAR2(1);
1295: l_qty_allocated NUMBER;
1296: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1297: BEGIN
1298: IF (l_debug = 1) THEN
1299: mydebug('in mark wip as allocated');
1300: END IF;

Line 1420: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1416: SELECT *
1417: FROM mtl_serial_numbers_temp
1418: WHERE transaction_temp_id = txn_tmp_id;
1419:
1420: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1421: BEGIN
1422: SELECT mtl_material_transactions_s.NEXTVAL
1423: INTO new_txn_temp_id
1424: FROM DUAL;