DBA Data[Home] [Help]

APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on INV_TRX_UTIL_PUB

Line 1751: -- INV_TRX_UTIL_PUB

1747: l_progress VARCHAR2(30) := '100';
1748: l_wf NUMBER := -1;
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:

Line 1947: mdebug ('Calling INV_TRX_UTIL_PUB.delete_transaction ' );

1943: mdebug ('NO WDT TO DELETE' );
1944: -- could not find the task to delete.. do not worry
1945: null;
1946: END IF;
1947: mdebug ('Calling INV_TRX_UTIL_PUB.delete_transaction ' );
1948: INV_TRX_UTIL_PUB.delete_transaction(
1949: x_return_status => x_return_status
1950: , x_msg_data => x_msg_data
1951: , x_msg_count => x_msg_count

Line 1948: INV_TRX_UTIL_PUB.delete_transaction(

1944: -- could not find the task to delete.. do not worry
1945: null;
1946: END IF;
1947: mdebug ('Calling INV_TRX_UTIL_PUB.delete_transaction ' );
1948: INV_TRX_UTIL_PUB.delete_transaction(
1949: x_return_status => x_return_status
1950: , x_msg_data => x_msg_data
1951: , x_msg_count => x_msg_count
1952: , p_transaction_temp_id => l_txn_temp_id

Line 2097: INV_TRX_UTIL_PUB.delete_transaction(

2093: mdebug ('l_progress: ' || l_progress );
2094: END IF;
2095: --Bug#6027401. Ends.
2096:
2097: INV_TRX_UTIL_PUB.delete_transaction(
2098: x_return_status => x_return_status
2099: , x_msg_data => x_msg_data
2100: , x_msg_count => x_msg_count
2101: , p_transaction_temp_id => l_txn_temp_id

Line 2169: INV_TRX_UTIL_PUB.delete_transaction(

2165: , last_update_date = SYSDATE
2166: , last_updated_by = p_user_id
2167: WHERE line_id = l_mo_line_id;
2168:
2169: INV_TRX_UTIL_PUB.delete_transaction(
2170: x_return_status => x_return_status
2171: , x_msg_data => x_msg_data
2172: , x_msg_count => x_msg_count
2173: , p_transaction_temp_id => l_txn_temp_id

Line 2266: INV_TRX_UTIL_PUB.delete_transaction(

2262:
2263: IF l_parent_line_id = p_temp_id
2264: THEN
2265: mdebug('Now calling delete transaction for parent line');
2266: INV_TRX_UTIL_PUB.delete_transaction(
2267: x_return_status => x_return_status
2268: , x_msg_data => x_msg_data
2269: , x_msg_count => x_msg_count
2270: , p_transaction_temp_id => l_parent_line_id