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 FND_GLOBAL

Line 501: p_logging_entity_id => FND_GLOBAL.USER_ID,

497: wsh_xc_util.log_exception (
498: p_api_version => 1.0,
499: p_exception_name => 'WSH_IB_SF_LOCN_CODE_CHG',
500: p_logging_entity => 'SHIPPER',
501: p_logging_entity_id => FND_GLOBAL.USER_ID,
502: x_return_status => l_return_status,
503: x_exception_id => l_exception_id,
504: x_msg_data => l_xc_msg_data,
505: x_msg_count => l_xc_msg_count,

Line 760: p_logging_entity_id => FND_GLOBAL.USER_ID,

756: wsh_xc_util.log_exception (
757: p_api_version => 1.0,
758: p_exception_name => 'WSH_IB_SF_LOCN_CODE_CHG',
759: p_logging_entity => 'SHIPPER',
760: p_logging_entity_id => FND_GLOBAL.USER_ID,
761: x_return_status => l_return_status,
762: x_exception_id => l_exception_id,
763: x_msg_data => l_xc_msg_data,
764: x_msg_count => l_xc_msg_count,

Line 927: last_updated_by = fnd_global.user_id,

923: UPDATE wsh_new_deliveries
924: SET vendor_id = p_to_id,
925: party_id = p_to_party_id,
926: last_update_date = sysdate,
927: last_updated_by = fnd_global.user_id,
928: last_update_login = fnd_global.login_id
929: WHERE delivery_id = p_delivery_id
930: RETURNING name INTO l_dlvy_name;
931: IF l_debug_on THEN

Line 928: last_update_login = fnd_global.login_id

924: SET vendor_id = p_to_id,
925: party_id = p_to_party_id,
926: last_update_date = sysdate,
927: last_updated_by = fnd_global.user_id,
928: last_update_login = fnd_global.login_id
929: WHERE delivery_id = p_delivery_id
930: RETURNING name INTO l_dlvy_name;
931: IF l_debug_on THEN
932: --{

Line 943: last_updated_by = fnd_global.user_id,

939: UPDATE wsh_new_deliveries
940: SET vendor_id = p_to_id,
941: party_id = p_to_party_id,
942: last_update_date = sysdate,
943: last_updated_by = fnd_global.user_id,
944: last_update_login = fnd_global.login_id
945: WHERE delivery_id
946: IN ( SELECT delivery_id
947: FROM wsh_delivery_assignments

Line 944: last_update_login = fnd_global.login_id

940: SET vendor_id = p_to_id,
941: party_id = p_to_party_id,
942: last_update_date = sysdate,
943: last_updated_by = fnd_global.user_id,
944: last_update_login = fnd_global.login_id
945: WHERE delivery_id
946: IN ( SELECT delivery_id
947: FROM wsh_delivery_assignments
948: WHERE delivery_detail_id

Line 1222: last_updated_by = fnd_global.user_id,

1218: UPDATE wsh_carriers
1219: SET supplier_id = p_to_id,
1220: supplier_site_id = p_to_site_id,
1221: last_update_date = sysdate,
1222: last_updated_by = fnd_global.user_id,
1223: last_update_login = fnd_global.login_id
1224: WHERE supplier_id = p_from_id
1225: AND supplier_site_id = p_from_site_id;
1226: --

Line 1223: last_update_login = fnd_global.login_id

1219: SET supplier_id = p_to_id,
1220: supplier_site_id = p_to_site_id,
1221: last_update_date = sysdate,
1222: last_updated_by = fnd_global.user_id,
1223: last_update_login = fnd_global.login_id
1224: WHERE supplier_id = p_from_id
1225: AND supplier_site_id = p_from_site_id;
1226: --
1227: IF l_debug_on THEN

Line 1238: last_updated_by = fnd_global.user_id,

1234: --
1235: UPDATE wsh_carrier_sites
1236: SET supplier_site_id = p_to_site_id,
1237: last_update_date = sysdate,
1238: last_updated_by = fnd_global.user_id,
1239: last_update_login = fnd_global.login_id
1240: WHERE supplier_site_id = p_from_site_id;
1241: --
1242: IF l_debug_on THEN

Line 1239: last_update_login = fnd_global.login_id

1235: UPDATE wsh_carrier_sites
1236: SET supplier_site_id = p_to_site_id,
1237: last_update_date = sysdate,
1238: last_updated_by = fnd_global.user_id,
1239: last_update_login = fnd_global.login_id
1240: WHERE supplier_site_id = p_from_site_id;
1241: --
1242: IF l_debug_on THEN
1243: --{

Line 1299: last_updated_by = fnd_global.user_id,

1295: UPDATE wsh_calendar_assignments
1296: SET vendor_id = p_to_id,
1297: vendor_site_id = p_to_site_id,
1298: last_update_date = sysdate,
1299: last_updated_by = fnd_global.user_id,
1300: last_update_login = fnd_global.login_id
1301: WHERE calendar_assignment_id = check_site_calendar_rec.calendar_assignment_id;
1302: --
1303: IF l_debug_on THEN

Line 1300: last_update_login = fnd_global.login_id

1296: SET vendor_id = p_to_id,
1297: vendor_site_id = p_to_site_id,
1298: last_update_date = sysdate,
1299: last_updated_by = fnd_global.user_id,
1300: last_update_login = fnd_global.login_id
1301: WHERE calendar_assignment_id = check_site_calendar_rec.calendar_assignment_id;
1302: --
1303: IF l_debug_on THEN
1304: --{

Line 1865: last_updated_by = fnd_global.user_id,

1861: SET vendor_id = p_to_id,
1862: ship_from_site_id = p_to_site_id,
1863: party_id = p_to_party_id,
1864: last_update_date = sysdate,
1865: last_updated_by = fnd_global.user_id,
1866: last_update_login = fnd_global.login_id
1867: WHERE delivery_detail_id = l_dd_list(j);
1868: IF SQL%ROWCOUNT <> l_dd_list.count THEN
1869: --{

Line 1866: last_update_login = fnd_global.login_id

1862: ship_from_site_id = p_to_site_id,
1863: party_id = p_to_party_id,
1864: last_update_date = sysdate,
1865: last_updated_by = fnd_global.user_id,
1866: last_update_login = fnd_global.login_id
1867: WHERE delivery_detail_id = l_dd_list(j);
1868: IF SQL%ROWCOUNT <> l_dd_list.count THEN
1869: --{
1870: IF l_debug_on THEN

Line 2130: last_updated_by = fnd_global.user_id,

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
2132: WHERE transaction_type = 'ROUTING_RESPONSE'
2133: AND shipment_header_id = l_delivery_rec.delivery_id
2134: AND supplier_id = p_from_id;

Line 2131: last_update_login = fnd_global.login_id

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
2132: WHERE transaction_type = 'ROUTING_RESPONSE'
2133: AND shipment_header_id = l_delivery_rec.delivery_id
2134: AND supplier_id = p_from_id;
2135: IF l_debug_on THEN

Line 2156: last_updated_by = fnd_global.user_id,

2152: UPDATE wsh_delivery_details
2153: SET vendor_id = p_to_id,
2154: party_id = p_to_party_id,
2155: last_update_date = sysdate,
2156: last_updated_by = fnd_global.user_id,
2157: last_update_login = fnd_global.login_id
2158: WHERE container_flag = 'Y'
2159: AND vendor_id = p_from_id
2160: AND delivery_detail_id

Line 2157: last_update_login = fnd_global.login_id

2153: SET vendor_id = p_to_id,
2154: party_id = p_to_party_id,
2155: last_update_date = sysdate,
2156: last_updated_by = fnd_global.user_id,
2157: last_update_login = fnd_global.login_id
2158: WHERE container_flag = 'Y'
2159: AND vendor_id = p_from_id
2160: AND delivery_detail_id
2161: IN (

Line 2366: p_logging_entity_id => FND_GLOBAL.USER_ID,

2362: wsh_xc_util.log_exception (
2363: p_api_version => 1.0,
2364: p_exception_name => 'WSH_IB_RR_NUMBER_CHG',
2365: p_logging_entity => 'SHIPPER',
2366: p_logging_entity_id => FND_GLOBAL.USER_ID,
2367: x_return_status => l_return_status,
2368: x_exception_id => l_exception_id,
2369: x_msg_data => l_xc_msg_data,
2370: x_msg_count => l_xc_msg_count,

Line 2402: last_updated_by = fnd_global.user_id,

2398: --
2399: UPDATE wsh_delivery_details
2400: SET routing_req_Id = l_new_rr_id,
2401: last_update_date = sysdate,
2402: last_updated_by = fnd_global.user_id,
2403: last_update_login = fnd_global.login_id
2404: WHERE delivery_detail_id = l_dlvy_rr_rec.delivery_detail_id;
2405: --
2406: IF l_debug_on THEN

Line 2403: last_update_login = fnd_global.login_id

2399: UPDATE wsh_delivery_details
2400: SET routing_req_Id = l_new_rr_id,
2401: last_update_date = sysdate,
2402: last_updated_by = fnd_global.user_id,
2403: last_update_login = fnd_global.login_id
2404: WHERE delivery_detail_id = l_dlvy_rr_rec.delivery_detail_id;
2405: --
2406: IF l_debug_on THEN
2407: --{

Line 2431: last_updated_by = fnd_global.user_id,

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
2433: WHERE supplier_id = p_from_id
2434: AND transaction_type not in ('ROUTING_REQUEST','ROUTING_RESPONSE')
2435: AND exists (SELECT shipment_header_id

Line 2432: last_update_login = fnd_global.login_id

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
2433: WHERE supplier_id = p_from_id
2434: AND transaction_type not in ('ROUTING_REQUEST','ROUTING_RESPONSE')
2435: AND exists (SELECT shipment_header_id
2436: FROM rcv_shipment_headers b

Line 2562: last_updated_by = fnd_global.user_id,

2558: FORALL I IN l_dlvy_tbl.first..l_dlvy_tbl.last
2559: UPDATE wsh_delivery_legs
2560: SET reprice_required = 'Y',
2561: last_update_date = sysdate,
2562: last_updated_by = fnd_global.user_id,
2563: last_update_login = fnd_global.login_id
2564: WHERE delivery_id = l_dlvy_tbl(i);
2565:
2566: ELSIF (l_option = 'B' or l_option = 'I') THEN

Line 2563: last_update_login = fnd_global.login_id

2559: UPDATE wsh_delivery_legs
2560: SET reprice_required = 'Y',
2561: last_update_date = sysdate,
2562: last_updated_by = fnd_global.user_id,
2563: last_update_login = fnd_global.login_id
2564: WHERE delivery_id = l_dlvy_tbl(i);
2565:
2566: ELSIF (l_option = 'B' or l_option = 'I') THEN
2567:

Line 2573: last_updated_by = fnd_global.user_id,

2569: UPDATE fte_invoice_headers a
2570: SET supplier_id = p_to_id,
2571: supplier_site_id = p_to_site_id,
2572: last_update_date = sysdate,
2573: last_updated_by = fnd_global.user_id,
2574: last_update_login = fnd_global.login_id
2575: WHERE supplier_id = p_from_id
2576: AND supplier_site_id = p_from_site_id
2577: AND exists (SELECT 1

Line 2574: last_update_login = fnd_global.login_id

2570: SET supplier_id = p_to_id,
2571: supplier_site_id = p_to_site_id,
2572: last_update_date = sysdate,
2573: last_updated_by = fnd_global.user_id,
2574: last_update_login = fnd_global.login_id
2575: WHERE supplier_id = p_from_id
2576: AND supplier_site_id = p_from_site_id
2577: AND exists (SELECT 1
2578: FROM ap_invoices_all