APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on FND_PROFILE

Line 10: g_trace_on CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'wms_txnrsn_actions_pub';
7: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
8: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;
9: l_g_ret_sts_success CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_success;
10: g_trace_on CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11:
12: g_debug NUMBER := 1;
13: g_module_name VARCHAR2(30) := NULL;
14:

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

88:
89: l_mmtt_header_id NUMBER;
90:
91:
92: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
93: l_proc_name VARCHAR2(30) := 'Inadequate_Qty';
94: BEGIN
95:
96: g_debug := l_debug;

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

523: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
524:
525: -- WF Fix End
526:
527: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
528: l_proc_name VARCHAR2(30) := 'Suggest_alternate_location';
529: BEGIN
530:
531: g_debug := l_debug;

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

1475:
1476: l_sequence NUMBER;
1477: l_return_err VARCHAR2(230);
1478:
1479: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1480: l_proc_name VARCHAR2(30) := 'Log_exception';
1481: BEGIN
1482:
1483: --Calculate Sequence Number

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

1587: l_org_id NUMBER;
1588: l_sub VARCHAR2(30);
1589: l_loc NUMBER;
1590: l_proc_name VARCHAR2(60) := 'cleanup_task (wrapper)';
1591: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1592:
1593:
1594: CURSOR rem_mmtt_csr IS
1595: SELECT mmtt.transaction_temp_id

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

1741: l_mmtt_transaction_uom VARCHAR2(3);
1742: l_mtrl_uom VARCHAR2(3);
1743: l_primary_quantity NUMBER;
1744:
1745: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1746: l_proc_name VARCHAR2(30) := 'CLEANUP_TASK';
1747: l_progress VARCHAR2(30) := '100';
1748: l_wf NUMBER := -1;
1749: l_calling_program VARCHAR2(30) := 'CLEANUP_TASK: QTY EXCEPTION';

Line 1753: l_kill_mo_profile NUMBER := NVL(FND_PROFILE.VALUE_WNPS('INV_KILL_MOVE_ORDER'),2);

1749: l_calling_program VARCHAR2(30) := 'CLEANUP_TASK: QTY EXCEPTION';
1750: l_update_parent BOOLEAN := FALSE ; -- No need to call update_parent_mmtt in
1751: -- INV_TRX_UTIL_PUB
1752: l_parent_line_id NUMBER; --For checking bulk task
1753: l_kill_mo_profile NUMBER := NVL(FND_PROFILE.VALUE_WNPS('INV_KILL_MOVE_ORDER'),2);
1754: l_return_status VARCHAR2(1);
1755:
1756: --Bug#6027401.
1757: l_reservation_id NUMBER;