DBA Data[Home] [Help]

APPS.WMS_ENGINE_PVT dependencies on FND_PROFILE

Line 139: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

135: l_wms_txn_temp_tbl_size NUMBER;
136: l_temp_id_tbl g_number_tbl_type;
137: BEGIN
138: IF NOT(inv_cache.is_pickrelease AND g_debug IS NOT NULL) THEN
139: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
140: END IF;
141: l_debug := g_debug;
142: IF l_debug = 1 THEN
143: log_procedure(l_api_name, 'start', 'Start Insert_Detail_temp_records');

Line 291: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

287: l_api_name CONSTANT VARCHAR2(30) := 'purge_detail_temp_records';
288: l_debug NUMBER;
289: BEGIN
290: IF NOT(inv_cache.is_pickrelease AND g_debug IS NOT NULL) THEN
291: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
292: END IF;
293: l_debug := g_debug;
294: IF l_debug = 1 THEN
295: log_procedure(l_api_name, 'start', 'Start purge_detail_temp_records');

Line 361: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

357: l_wms_txn_temp_tbl_size NUMBER;
358: l_debug NUMBER;
359: BEGIN
360: IF NOT(inv_cache.is_pickrelease AND g_debug IS NOT NULL) THEN
361: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
362: END IF;
363: l_debug := g_debug;
364: IF l_debug = 1 THEN
365: log_procedure(l_api_name, 'start', 'Start resolve_serials');

Line 490: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

486: l_rsv_ctr NUMBER; -- [ Added to track number of detailed serial numbers ]
487: --
488: BEGIN
489: IF NOT(inv_cache.is_pickrelease AND g_debug IS NOT NULL) THEN
490: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
491: END IF;
492: l_debug := g_debug;
493: IF l_debug = 1 THEN
494: log_procedure(l_api_name, 'start', 'Start Prepare');

Line 792: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

788: -- Added for Bug 6063903
789:
790: BEGIN
791: IF NOT(inv_cache.is_pickrelease AND g_debug IS NOT NULL) THEN
792: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
793: END IF;
794: l_debug := g_debug;
795: IF l_debug = 1 THEN
796: log_procedure(l_api_name, 'start', 'Start prepare_transfer_receipt');

Line 977: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

973: RETURN;
974: END IF; */
975:
976: IF g_debug IS NULL THEN
977: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
978: END IF;
979: l_debug := g_debug;
980:
981: IF l_debug = 1 THEN

Line 1140: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1136: l_debug NUMBER;
1137: --
1138: BEGIN
1139: IF NOT(inv_cache.is_pickrelease AND g_debug IS NOT NULL) THEN
1140: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1141: END IF;
1142: l_debug := g_debug;
1143: IF l_debug = 1 THEN
1144: log_procedure(l_api_name, 'start', 'Start output_issue_or_receipt');

Line 1351: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1347: l_grade_code VARCHAR2(150);
1348: l_debug NUMBER;
1349: BEGIN
1350: IF NOT(inv_cache.is_pickrelease AND g_debug IS NOT NULL) THEN
1351: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1352: END IF;
1353: l_debug := g_debug;
1354: IF l_debug = 1 THEN
1355: log_procedure(l_api_name, 'start', 'Start combine_transfer');

Line 1686: l_rules_engine_mode NUMBER := 1; --:= NVL(fnd_profile.VALUE('WMS_RULES_ENGINE_MODE'), 0);

1682: l_allow_non_partial_rules BOOLEAN; --- DEFAULT TRUE;
1683: l_return_type VARCHAR2(1);
1684: l_return_type_id NUMBER;
1685: l_sequence_number NUMBER;
1686: l_rules_engine_mode NUMBER := 1; --:= NVL(fnd_profile.VALUE('WMS_RULES_ENGINE_MODE'), 0);
1687: l_wip_rsv_exists NUMBER;
1688:
1689: --- Rules J Project Variables
1690: ---

Line 1793: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1789:
1790: BEGIN
1791:
1792: IF NOT(inv_cache.is_pickrelease AND g_debug IS NOT NULL) THEN
1793: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1794: END IF;
1795: l_debug := g_debug;
1796: l_progress := 10;
1797: --

Line 1807: l_allow_nr_sub_xfer := Upper(NVL( SUBSTR(FND_PROFILE.VALUE('INV_ALLOW_NR_SUB_XFER'),1,1), 'N')) ; -- Bug#4006426

1803: , 'Starting the WMS Rules engine ' || 'to allocate material for move order line: '
1804: || p_transaction_temp_id
1805: );
1806: End if;
1807: l_allow_nr_sub_xfer := Upper(NVL( SUBSTR(FND_PROFILE.VALUE('INV_ALLOW_NR_SUB_XFER'),1,1), 'N')) ; -- Bug#4006426
1808:
1809: If l_debug = 1 THEN
1810: log_event( l_api_name, 'WMS_ALLOW_NR_SUB_XFER := ', l_allow_nr_sub_xfer );
1811: End if;