DBA Data[Home] [Help]

APPS.WMS_ITEM_LOAD dependencies on INV_RCV_COMMON_APIS

Line 2570: l_txn_mode_code := inv_rcv_common_apis.g_po_startup_value.transaction_mode;

2566: print_debug('Call the Receiving TM');
2567: END IF;
2568:
2569: -- Store the original receiving txn mode in a local variable
2570: l_txn_mode_code := inv_rcv_common_apis.g_po_startup_value.transaction_mode;
2571:
2572: -- Set the receiving txn mode to online
2573: inv_rcv_common_apis.g_po_startup_value.transaction_mode := 'ONLINE';
2574: IF (l_debug = 1) THEN

Line 2573: inv_rcv_common_apis.g_po_startup_value.transaction_mode := 'ONLINE';

2569: -- Store the original receiving txn mode in a local variable
2570: l_txn_mode_code := inv_rcv_common_apis.g_po_startup_value.transaction_mode;
2571:
2572: -- Set the receiving txn mode to online
2573: inv_rcv_common_apis.g_po_startup_value.transaction_mode := 'ONLINE';
2574: IF (l_debug = 1) THEN
2575: print_debug('Temporarily set the RCV transaction mode to ONLINE');
2576: END IF;
2577: l_progress := '130';

Line 2580: print_debug('updating proceesing mode in rti for group id'||inv_rcv_common_apis.g_rcv_global_var.interface_group_id);

2576: END IF;
2577: l_progress := '130';
2578: --Bug 6944334
2579: Begin
2580: print_debug('updating proceesing mode in rti for group id'||inv_rcv_common_apis.g_rcv_global_var.interface_group_id);
2581: UPDATE RCV_TRANSACTIONS_INTERFACE
2582: SET PROCESSING_MODE_CODE = 'ONLINE'
2583: WHERE GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
2584: EXCEPTION

Line 2583: WHERE GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

2579: Begin
2580: print_debug('updating proceesing mode in rti for group id'||inv_rcv_common_apis.g_rcv_global_var.interface_group_id);
2581: UPDATE RCV_TRANSACTIONS_INTERFACE
2582: SET PROCESSING_MODE_CODE = 'ONLINE'
2583: WHERE GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
2584: EXCEPTION
2585: WHEN OTHERS THEN
2586: print_debug('no record found in rti to ');
2587: END;

Line 2603: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_txn_mode_code;

2599: -- implying that a commit was done.
2600: l_rcv_tm_called := TRUE;
2601:
2602: -- Revert the receiving txn mode
2603: inv_rcv_common_apis.g_po_startup_value.transaction_mode := l_txn_mode_code;
2604: IF (l_debug = 1) THEN
2605: print_debug('Reverted the RCV transaction mode to previous value');
2606: END IF;
2607: l_progress := '140';

Line 2613: inv_rcv_common_apis.rcv_clear_global;

2609: -- Call this to clean up the RCV globals
2610: -- Bug# 3251237: Always call this whether or not the TM call is
2611: -- successful. Previously this would not be called in case the
2612: -- Rcv TM errored out since an exception would be thrown.
2613: inv_rcv_common_apis.rcv_clear_global;
2614: IF (l_debug = 1) THEN
2615: print_debug('Finished calling rcv_clear_global API');
2616: END IF;
2617: l_progress := '150';