eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_INBOUND_TXN_HISTORY

Line 1643: wsh_inbound_txn_history wth,

1639: wnd.ultimate_dropoff_location_id,
1640: wnd.name
1641: FROM wsh_delivery_details wdd,
1642: wsh_delivery_assignments wda ,
1643: wsh_inbound_txn_history wth,
1644: wsh_new_deliveries wnd
1645: WHERE wda.delivery_id = p_delivery_id
1646: AND nvl(wda.type,'S') IN ('S','O')
1647: AND wda.delivery_detail_Id = wdd.delivery_detail_id

Line 1677: FROM wsh_inbound_txn_history

1673: p_rr_number VARCHAR2) IS
1674: SELECT transaction_id,
1675: revision_number,
1676: parent_shipment_header_id
1677: FROM wsh_inbound_txn_history
1678: WHERE supplier_id = p_supplier_id
1679: AND receipt_number = p_rr_number
1680: AND transaction_type='ROUTING_REQUEST'
1681: ORDER BY revision_number DESC;

Line 1705: l_txn_history_rec wsh_inbound_txn_history_pkg.ib_txn_history_rec_type;

1701: l_xc_msg_data VARCHAR2(2000);
1702: l_num_warnings NUMBER :=0;
1703: l_num_errors NUMBER :=0;
1704: l_tmp_rr_number VARCHAR2(40);
1705: l_txn_history_rec wsh_inbound_txn_history_pkg.ib_txn_history_rec_type;
1706: l_cache_index NUMBER;
1707: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1708: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
1709: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;

Line 2134: UPDATE wsh_inbound_txn_history

2130: l_chk_delivery_id := l_delivery_rec.delivery_id;
2131: --
2132: IF l_routing_response_id IS NOT NULL THEN
2133: --{
2134: UPDATE wsh_inbound_txn_history
2135: SET supplier_id = p_to_id,
2136: last_update_date = sysdate,
2137: last_updated_by = fnd_global.user_id,
2138: last_update_login = fnd_global.login_id

Line 2145: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_inbound_txn_history. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);

2141: AND supplier_id = p_from_id;
2142: IF l_debug_on THEN
2143: --{
2144: WSH_DEBUG_SV.log(l_module_name, 'Updated ROUTING_RESP record for', l_delivery_rec.delivery_id);
2145: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_inbound_txn_history. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
2146: --}
2147: END IF;
2148:
2149: --}

Line 2305: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_TXN_HISTORY_PKG.GET_TXN_HISTORY',WSH_DEBUG_SV.C_PROC_LEVEL);

2301: IF l_new_rr_id IS NULL THEN
2302: --{
2303: IF l_debug_on THEN
2304: --{
2305: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_TXN_HISTORY_PKG.GET_TXN_HISTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
2306: --}
2307: END IF;
2308: WSH_INBOUND_TXN_HISTORY_PKG.get_txn_history(
2309: p_transaction_id => l_dlvy_rr_rec.routing_req_id,

Line 2308: WSH_INBOUND_TXN_HISTORY_PKG.get_txn_history(

2304: --{
2305: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_TXN_HISTORY_PKG.GET_TXN_HISTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
2306: --}
2307: END IF;
2308: WSH_INBOUND_TXN_HISTORY_PKG.get_txn_history(
2309: p_transaction_id => l_dlvy_rr_rec.routing_req_id,
2310: x_txn_history_rec => l_txn_history_rec,
2311: x_return_status => l_return_status
2312: );

Line 2315: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_INBOUND_TXN_HISTORY_PKG.GET_TXN_HISTORY is ' || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);

2311: x_return_status => l_return_status
2312: );
2313: IF l_debug_on THEN
2314: --{
2315: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_INBOUND_TXN_HISTORY_PKG.GET_TXN_HISTORY is ' || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
2316: --}
2317: END IF;
2318: wsh_util_core.api_post_call(
2319: p_return_status => l_return_status,

Line 2330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_TXN_HISTORY_PKG.CREATE_TXN_HISTORY',WSH_DEBUG_SV.C_PROC_LEVEL);

2326: l_txn_history_rec.supplier_id := p_to_id;
2327: --
2328: IF l_debug_on THEN
2329: --{
2330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_TXN_HISTORY_PKG.CREATE_TXN_HISTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
2331: --}
2332: END IF;
2333: WSH_INBOUND_TXN_HISTORY_PKG.create_txn_history(
2334: p_txn_history_rec => l_txn_history_rec,

Line 2333: WSH_INBOUND_TXN_HISTORY_PKG.create_txn_history(

2329: --{
2330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_TXN_HISTORY_PKG.CREATE_TXN_HISTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
2331: --}
2332: END IF;
2333: WSH_INBOUND_TXN_HISTORY_PKG.create_txn_history(
2334: p_txn_history_rec => l_txn_history_rec,
2335: x_txn_id => l_new_rr_id,
2336: x_return_status => l_return_status
2337: );

Line 2340: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_INBOUND_TXN_HISTORY_PKG.CREATE_TXN_HISTORY is ' , l_return_status);

2336: x_return_status => l_return_status
2337: );
2338: IF l_debug_on THEN
2339: --
2340: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_INBOUND_TXN_HISTORY_PKG.CREATE_TXN_HISTORY is ' , l_return_status);
2341: WSH_DEBUG_SV.log(l_module_name, 'New Txn ID', l_new_rr_id);
2342:
2343: --
2344: END IF;

Line 2433: -- Update WSH_INBOUND_TXN_HISTORY with the merge to vendor

2429: END IF; --IF l_delivery_rec_tbl.COUNT > 0
2430: --
2431: IF p_From_id <> p_to_id THEN
2432: --{
2433: -- Update WSH_INBOUND_TXN_HISTORY with the merge to vendor
2434: --
2435: UPDATE wsh_inbound_txn_history a
2436: SET supplier_id = p_to_id,
2437: last_update_date = sysdate,

Line 2435: UPDATE wsh_inbound_txn_history a

2431: IF p_From_id <> p_to_id THEN
2432: --{
2433: -- Update WSH_INBOUND_TXN_HISTORY with the merge to vendor
2434: --
2435: UPDATE wsh_inbound_txn_history a
2436: SET supplier_id = p_to_id,
2437: last_update_date = sysdate,
2438: last_updated_by = fnd_global.user_id,
2439: last_update_login = fnd_global.login_id

Line 2453: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_inbound_txn_history. Number of Rows updated is ' || l_numRowsUpdated, WSH_DEBUG_SV.C_STMT_LEVEL);

2449: --
2450: IF l_debug_on THEN
2451: --{
2452: WSH_DEBUG_SV.log(l_module_name, 'Updated ASN/RECEIPT records with vendor', p_to_id);
2453: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_inbound_txn_history. Number of Rows updated is ' || l_numRowsUpdated, WSH_DEBUG_SV.C_STMT_LEVEL);
2454: --}
2455: END IF;
2456: --}
2457: END IF;