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 1636: wsh_inbound_txn_history wth,

1632: wnd.ultimate_dropoff_location_id,
1633: wnd.name
1634: FROM wsh_delivery_details wdd,
1635: wsh_delivery_assignments wda ,
1636: wsh_inbound_txn_history wth,
1637: wsh_new_deliveries wnd
1638: WHERE wda.delivery_id = p_delivery_id
1639: AND nvl(wda.type,'S') IN ('S','O')
1640: AND wda.delivery_detail_Id = wdd.delivery_detail_id

Line 1670: FROM wsh_inbound_txn_history

1666: p_rr_number VARCHAR2) IS
1667: SELECT transaction_id,
1668: revision_number,
1669: parent_shipment_header_id
1670: FROM wsh_inbound_txn_history
1671: WHERE supplier_id = p_supplier_id
1672: AND receipt_number = p_rr_number
1673: AND transaction_type='ROUTING_REQUEST'
1674: ORDER BY revision_number DESC;

Line 1698: l_txn_history_rec wsh_inbound_txn_history_pkg.ib_txn_history_rec_type;

1694: l_xc_msg_data VARCHAR2(2000);
1695: l_num_warnings NUMBER :=0;
1696: l_num_errors NUMBER :=0;
1697: l_tmp_rr_number VARCHAR2(40);
1698: l_txn_history_rec wsh_inbound_txn_history_pkg.ib_txn_history_rec_type;
1699: l_cache_index NUMBER;
1700: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1701: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
1702: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;

Line 2127: UPDATE wsh_inbound_txn_history

2123: l_chk_delivery_id := l_delivery_rec.delivery_id;
2124: --
2125: IF l_routing_response_id IS NOT NULL THEN
2126: --{
2127: UPDATE wsh_inbound_txn_history
2128: SET supplier_id = p_to_id,
2129: last_update_date = sysdate,
2130: last_updated_by = fnd_global.user_id,
2131: last_update_login = fnd_global.login_id

Line 2138: 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);

2134: AND supplier_id = p_from_id;
2135: IF l_debug_on THEN
2136: --{
2137: WSH_DEBUG_SV.log(l_module_name, 'Updated ROUTING_RESP record for', l_delivery_rec.delivery_id);
2138: 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);
2139: --}
2140: END IF;
2141:
2142: --}

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

2294: IF l_new_rr_id IS NULL THEN
2295: --{
2296: IF l_debug_on THEN
2297: --{
2298: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_TXN_HISTORY_PKG.GET_TXN_HISTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
2299: --}
2300: END IF;
2301: WSH_INBOUND_TXN_HISTORY_PKG.get_txn_history(
2302: p_transaction_id => l_dlvy_rr_rec.routing_req_id,

Line 2301: WSH_INBOUND_TXN_HISTORY_PKG.get_txn_history(

2297: --{
2298: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_TXN_HISTORY_PKG.GET_TXN_HISTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
2299: --}
2300: END IF;
2301: WSH_INBOUND_TXN_HISTORY_PKG.get_txn_history(
2302: p_transaction_id => l_dlvy_rr_rec.routing_req_id,
2303: x_txn_history_rec => l_txn_history_rec,
2304: x_return_status => l_return_status
2305: );

Line 2308: 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);

2304: x_return_status => l_return_status
2305: );
2306: IF l_debug_on THEN
2307: --{
2308: 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);
2309: --}
2310: END IF;
2311: wsh_util_core.api_post_call(
2312: p_return_status => l_return_status,

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

2319: l_txn_history_rec.supplier_id := p_to_id;
2320: --
2321: IF l_debug_on THEN
2322: --{
2323: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_TXN_HISTORY_PKG.CREATE_TXN_HISTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
2324: --}
2325: END IF;
2326: WSH_INBOUND_TXN_HISTORY_PKG.create_txn_history(
2327: p_txn_history_rec => l_txn_history_rec,

Line 2326: WSH_INBOUND_TXN_HISTORY_PKG.create_txn_history(

2322: --{
2323: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_TXN_HISTORY_PKG.CREATE_TXN_HISTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
2324: --}
2325: END IF;
2326: WSH_INBOUND_TXN_HISTORY_PKG.create_txn_history(
2327: p_txn_history_rec => l_txn_history_rec,
2328: x_txn_id => l_new_rr_id,
2329: x_return_status => l_return_status
2330: );

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

2329: x_return_status => l_return_status
2330: );
2331: IF l_debug_on THEN
2332: --
2333: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_INBOUND_TXN_HISTORY_PKG.CREATE_TXN_HISTORY is ' , l_return_status);
2334: WSH_DEBUG_SV.log(l_module_name, 'New Txn ID', l_new_rr_id);
2335:
2336: --
2337: END IF;

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

2422: END IF; --IF l_delivery_rec_tbl.COUNT > 0
2423: --
2424: IF p_From_id <> p_to_id THEN
2425: --{
2426: -- Update WSH_INBOUND_TXN_HISTORY with the merge to vendor
2427: --
2428: UPDATE wsh_inbound_txn_history a
2429: SET supplier_id = p_to_id,
2430: last_update_date = sysdate,

Line 2428: UPDATE wsh_inbound_txn_history a

2424: IF p_From_id <> p_to_id THEN
2425: --{
2426: -- Update WSH_INBOUND_TXN_HISTORY with the merge to vendor
2427: --
2428: UPDATE wsh_inbound_txn_history a
2429: SET supplier_id = p_to_id,
2430: last_update_date = sysdate,
2431: last_updated_by = fnd_global.user_id,
2432: last_update_login = fnd_global.login_id

Line 2446: 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);

2442: --
2443: IF l_debug_on THEN
2444: --{
2445: WSH_DEBUG_SV.log(l_module_name, 'Updated ASN/RECEIPT records with vendor', p_to_id);
2446: 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);
2447: --}
2448: END IF;
2449: --}
2450: END IF;