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_NEW_DELIVERY_ACTIONS dependencies on FND_GLOBAL

Line 1016: p_logging_entity_id => FND_GLOBAL.USER_ID,

1012: x_exception_id => l_exception_id,
1013: p_exception_location_id => l_initial_pickup_location_id,
1014: p_logged_at_location_id => l_initial_pickup_location_id,
1015: p_logging_entity => 'SHIPPER',
1016: p_logging_entity_id => FND_GLOBAL.USER_ID,
1017: p_exception_name => 'WSH_PLAN_DELIVERY_FAIL',
1018: p_message => substrb(l_exception_message,1,2000),
1019: p_delivery_id => p_delivery_ids(i),
1020: p_error_message => 'W');

Line 1139: p_logging_entity_id => FND_GLOBAL.USER_ID,

1135: x_exception_id => l_exception_id,
1136: p_exception_location_id => l_initial_pickup_location_id,
1137: p_logged_at_location_id => l_initial_pickup_location_id,
1138: p_logging_entity => 'SHIPPER',
1139: p_logging_entity_id => FND_GLOBAL.USER_ID,
1140: p_exception_name => 'WSH_PLAN_DELIVERY_FAIL',
1141: p_message => substrb(l_exception_message,1,2000),
1142: p_delivery_id => p_delivery_ids(i),
1143: p_error_message => 'W');

Line 3178: l_login_id := FND_GLOBAL.login_id;

3174: WSH_DEBUG_SV.log(l_module_name,'P_DEFER_INTERFACE_FLAG',P_DEFER_INTERFACE_FLAG);
3175: WSH_DEBUG_SV.log(l_module_name,'P_SEND_945_FLAG',P_SEND_945_FLAG);
3176: END IF;
3177: --
3178: l_login_id := FND_GLOBAL.login_id;
3179: l_user_id := FND_GLOBAL.user_id ;
3180: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;
3181:
3182: --OTM R12

Line 3179: l_user_id := FND_GLOBAL.user_id ;

3175: WSH_DEBUG_SV.log(l_module_name,'P_SEND_945_FLAG',P_SEND_945_FLAG);
3176: END IF;
3177: --
3178: l_login_id := FND_GLOBAL.login_id;
3179: l_user_id := FND_GLOBAL.user_id ;
3180: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;
3181:
3182: --OTM R12
3183: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable

Line 3200: -- Using fnd_global.User_name for global G_USER_NAME

3196: END IF;
3197: -- bug 2778035
3198:
3199: -- Fix for Bug 3944151
3200: -- Using fnd_global.User_name for global G_USER_NAME
3201: -- This is because before this fix, global g_user_name carried the previous user name
3202: -- when one user logged out and another user logged back in the same mobile telnet session.
3203:
3204: G_USER_NAME := FND_GLOBAL.USER_NAME;

Line 3204: G_USER_NAME := FND_GLOBAL.USER_NAME;

3200: -- Using fnd_global.User_name for global G_USER_NAME
3201: -- This is because before this fix, global g_user_name carried the previous user name
3202: -- when one user logged out and another user logged back in the same mobile telnet session.
3203:
3204: G_USER_NAME := FND_GLOBAL.USER_NAME;
3205:
3206: /* if ( G_USER_NAME is NULL ) then
3207: open user_name(l_user_id);
3208: fetch user_name into G_USER_NAME ;

Line 7539: l_user_id := FND_GLOBAL.user_id;

7535: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
7536: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
7537: END IF;
7538: --
7539: l_user_id := FND_GLOBAL.user_id;
7540: l_login_id := FND_GLOBAL.login_id;
7541: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7542: l_num_warnings := 0;
7543: l_num_errors := 0;

Line 7540: l_login_id := FND_GLOBAL.login_id;

7536: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
7537: END IF;
7538: --
7539: l_user_id := FND_GLOBAL.user_id;
7540: l_login_id := FND_GLOBAL.login_id;
7541: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7542: l_num_warnings := 0;
7543: l_num_errors := 0;
7544:

Line 7995: l_user_id := FND_GLOBAL.user_id;

7991: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
7992: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
7993: END IF;
7994: --
7995: l_user_id := FND_GLOBAL.user_id;
7996: l_login_id := FND_GLOBAL.login_id;
7997: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7998: l_num_warnings := 0;
7999: l_num_errors := 0;

Line 7996: l_login_id := FND_GLOBAL.login_id;

7992: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
7993: END IF;
7994: --
7995: l_user_id := FND_GLOBAL.user_id;
7996: l_login_id := FND_GLOBAL.login_id;
7997: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7998: l_num_warnings := 0;
7999: l_num_errors := 0;
8000: --

Line 8309: l_user_id := FND_GLOBAL.user_id;

8305: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_DATE',P_ACTUAL_DATE);
8306: END IF;
8307: --
8308: --
8309: l_user_id := FND_GLOBAL.user_id;
8310: l_login_id := FND_GLOBAL.login_id;
8311: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
8312: --
8313: l_num_warnings := 0;

Line 8310: l_login_id := FND_GLOBAL.login_id;

8306: END IF;
8307: --
8308: --
8309: l_user_id := FND_GLOBAL.user_id;
8310: l_login_id := FND_GLOBAL.login_id;
8311: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
8312: --
8313: l_num_warnings := 0;
8314: l_num_errors := 0;

Line 9142: last_updated_by = FND_GLOBAL.USER_ID

9138: IF (p_update_del_flag='Y') THEN
9139: UPDATE wsh_new_deliveries
9140: SET ITINERARY_COMPLETE = l_update_flag,
9141: last_update_date = sysdate,
9142: last_updated_by = FND_GLOBAL.USER_ID
9143: WHERE delivery_id= p_delivery_id;
9144: END IF;
9145:
9146: END IF;

Line 9867: last_updated_by = FND_GLOBAL.USER_ID,

9863:
9864: UPDATE wsh_new_deliveries
9865: SET freight_terms_code = l_dlvy_freight_terms_code,
9866: last_update_date = SYSDATE,
9867: last_updated_by = FND_GLOBAL.USER_ID,
9868: last_update_login = FND_GLOBAL.LOGIN_ID
9869: WHERE delivery_id = p_delivery_id;
9870: --
9871: IF (SQL%NOTFOUND)

Line 9868: last_update_login = FND_GLOBAL.LOGIN_ID

9864: UPDATE wsh_new_deliveries
9865: SET freight_terms_code = l_dlvy_freight_terms_code,
9866: last_update_date = SYSDATE,
9867: last_updated_by = FND_GLOBAL.USER_ID,
9868: last_update_login = FND_GLOBAL.LOGIN_ID
9869: WHERE delivery_id = p_delivery_id;
9870: --
9871: IF (SQL%NOTFOUND)
9872: THEN

Line 9905: last_updated_by = FND_GLOBAL.USER_ID,

9901: END IF;
9902: --
9903: UPDATE wsh_new_deliveries
9904: SET last_update_date = SYSDATE,
9905: last_updated_by = FND_GLOBAL.USER_ID,
9906: last_update_login = FND_GLOBAL.LOGIN_ID
9907: WHERE delivery_id = p_delivery_id;
9908: --
9909: IF (SQL%NOTFOUND)

Line 9906: last_update_login = FND_GLOBAL.LOGIN_ID

9902: --
9903: UPDATE wsh_new_deliveries
9904: SET last_update_date = SYSDATE,
9905: last_updated_by = FND_GLOBAL.USER_ID,
9906: last_update_login = FND_GLOBAL.LOGIN_ID
9907: WHERE delivery_id = p_delivery_id;
9908: --
9909: IF (SQL%NOTFOUND)
9910: THEN

Line 10109: last_updated_by = FND_GLOBAL.USER_ID,

10105: /*
10106: UPDATE WSH_NEW_DELIVERIES
10107: SET INITIAL_PICKUP_LOCATION_ID = p_location_id,
10108: last_update_date = SYSDATE,
10109: last_updated_by = FND_GLOBAL.USER_ID,
10110: last_update_login = FND_GLOBAL.LOGIN_ID
10111: WHERE delivery_id = p_delivery_id;
10112: */
10113: --

Line 10110: last_update_login = FND_GLOBAL.LOGIN_ID

10106: UPDATE WSH_NEW_DELIVERIES
10107: SET INITIAL_PICKUP_LOCATION_ID = p_location_id,
10108: last_update_date = SYSDATE,
10109: last_updated_by = FND_GLOBAL.USER_ID,
10110: last_update_login = FND_GLOBAL.LOGIN_ID
10111: WHERE delivery_id = p_delivery_id;
10112: */
10113: --
10114: --

Line 10118: last_updated_by = FND_GLOBAL.USER_ID,

10114: --
10115: UPDATE WSH_DELIVERY_DETAILS
10116: SET SHIP_FROM_LOCATION_ID = p_location_id,
10117: last_update_date = SYSDATE,
10118: last_updated_by = FND_GLOBAL.USER_ID,
10119: last_update_login = FND_GLOBAL.LOGIN_ID
10120: WHERE delivery_detail_id IN (
10121: SELECT delivery_detail_id
10122: FROM wsh_delivery_assignments_v

Line 10119: last_update_login = FND_GLOBAL.LOGIN_ID

10115: UPDATE WSH_DELIVERY_DETAILS
10116: SET SHIP_FROM_LOCATION_ID = p_location_id,
10117: last_update_date = SYSDATE,
10118: last_updated_by = FND_GLOBAL.USER_ID,
10119: last_update_login = FND_GLOBAL.LOGIN_ID
10120: WHERE delivery_detail_id IN (
10121: SELECT delivery_detail_id
10122: FROM wsh_delivery_assignments_v
10123: WHERE delivery_id = p_delivery_id

Line 10208: last_updated_by = FND_GLOBAL.USER_ID,

10204: -- physical_stop_id and physical_location_id
10205: UPDATE wsh_trip_stops
10206: SET stop_location_id = p_location_id,
10207: last_update_date = SYSDATE,
10208: last_updated_by = FND_GLOBAL.USER_ID,
10209: last_update_login = FND_GLOBAL.LOGIN_ID,
10210: physical_stop_id = l_physical_stop_id, -- J+ Internal Locations
10211: physical_location_id = l_physical_location_id -- J+ Internal Locations
10212: WHERE stop_id = stop_rec.stop_id;

Line 10209: last_update_login = FND_GLOBAL.LOGIN_ID,

10205: UPDATE wsh_trip_stops
10206: SET stop_location_id = p_location_id,
10207: last_update_date = SYSDATE,
10208: last_updated_by = FND_GLOBAL.USER_ID,
10209: last_update_login = FND_GLOBAL.LOGIN_ID,
10210: physical_stop_id = l_physical_stop_id, -- J+ Internal Locations
10211: physical_location_id = l_physical_location_id -- J+ Internal Locations
10212: WHERE stop_id = stop_rec.stop_id;
10213: --

Line 10249: last_updated_by = FND_GLOBAL.USER_ID,

10245: --will not check tms flag here
10246: UPDATE WSH_NEW_DELIVERIES
10247: SET INITIAL_PICKUP_LOCATION_ID = p_location_id,
10248: last_update_date = SYSDATE,
10249: last_updated_by = FND_GLOBAL.USER_ID,
10250: last_update_login = FND_GLOBAL.LOGIN_ID
10251: WHERE delivery_id = pickup_dlvy_rec.delivery_id;
10252: --
10253: --

Line 10250: last_update_login = FND_GLOBAL.LOGIN_ID

10246: UPDATE WSH_NEW_DELIVERIES
10247: SET INITIAL_PICKUP_LOCATION_ID = p_location_id,
10248: last_update_date = SYSDATE,
10249: last_updated_by = FND_GLOBAL.USER_ID,
10250: last_update_login = FND_GLOBAL.LOGIN_ID
10251: WHERE delivery_id = pickup_dlvy_rec.delivery_id;
10252: --
10253: --
10254: UPDATE WSH_DELIVERY_DETAILS

Line 10257: last_updated_by = FND_GLOBAL.USER_ID,

10253: --
10254: UPDATE WSH_DELIVERY_DETAILS
10255: SET SHIP_FROM_LOCATION_ID = p_location_id,
10256: last_update_date = SYSDATE,
10257: last_updated_by = FND_GLOBAL.USER_ID,
10258: last_update_login = FND_GLOBAL.LOGIN_ID
10259: WHERE delivery_detail_id IN (
10260: SELECT delivery_detail_id
10261: FROM wsh_delivery_assignments_v

Line 10258: last_update_login = FND_GLOBAL.LOGIN_ID

10254: UPDATE WSH_DELIVERY_DETAILS
10255: SET SHIP_FROM_LOCATION_ID = p_location_id,
10256: last_update_date = SYSDATE,
10257: last_updated_by = FND_GLOBAL.USER_ID,
10258: last_update_login = FND_GLOBAL.LOGIN_ID
10259: WHERE delivery_detail_id IN (
10260: SELECT delivery_detail_id
10261: FROM wsh_delivery_assignments_v
10262: WHERE delivery_id = pickup_dlvy_rec.delivery_id

Line 11625: x_trip_info_tab(fmct).CREATED_BY := fnd_global.user_id;

11621: x_trip_info_tab(fmct).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11622: x_trip_info_tab(fmct).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11623: x_trip_info_tab(fmct).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11624: x_trip_info_tab(fmct).CREATION_DATE := SYSDATE;
11625: x_trip_info_tab(fmct).CREATED_BY := fnd_global.user_id;
11626: x_trip_info_tab(fmct).LAST_UPDATE_DATE := SYSDATE;
11627: x_trip_info_tab(fmct).LAST_UPDATED_BY := fnd_global.user_id;
11628: x_trip_info_tab(fmct).LAST_UPDATE_LOGIN := fnd_global.login_id;
11629: x_trip_info_tab(fmct).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;

Line 11627: x_trip_info_tab(fmct).LAST_UPDATED_BY := fnd_global.user_id;

11623: x_trip_info_tab(fmct).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11624: x_trip_info_tab(fmct).CREATION_DATE := SYSDATE;
11625: x_trip_info_tab(fmct).CREATED_BY := fnd_global.user_id;
11626: x_trip_info_tab(fmct).LAST_UPDATE_DATE := SYSDATE;
11627: x_trip_info_tab(fmct).LAST_UPDATED_BY := fnd_global.user_id;
11628: x_trip_info_tab(fmct).LAST_UPDATE_LOGIN := fnd_global.login_id;
11629: x_trip_info_tab(fmct).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11630: x_trip_info_tab(fmct).PROGRAM_ID := FND_API.G_MISS_NUM;
11631: x_trip_info_tab(fmct).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;

Line 11628: x_trip_info_tab(fmct).LAST_UPDATE_LOGIN := fnd_global.login_id;

11624: x_trip_info_tab(fmct).CREATION_DATE := SYSDATE;
11625: x_trip_info_tab(fmct).CREATED_BY := fnd_global.user_id;
11626: x_trip_info_tab(fmct).LAST_UPDATE_DATE := SYSDATE;
11627: x_trip_info_tab(fmct).LAST_UPDATED_BY := fnd_global.user_id;
11628: x_trip_info_tab(fmct).LAST_UPDATE_LOGIN := fnd_global.login_id;
11629: x_trip_info_tab(fmct).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11630: x_trip_info_tab(fmct).PROGRAM_ID := FND_API.G_MISS_NUM;
11631: x_trip_info_tab(fmct).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11632: x_trip_info_tab(fmct).REQUEST_ID := FND_API.G_MISS_NUM;

Line 13328: FND_GLOBAL.USER_ID,

13324: p_parent_del_id,
13325: l_child_details_tab(k),
13326: NULL,
13327: SYSDATE,
13328: FND_GLOBAL.USER_ID,
13329: SYSDATE,
13330: FND_GLOBAL.USER_ID,
13331: FND_GLOBAL.USER_ID,
13332: NULL,

Line 13330: FND_GLOBAL.USER_ID,

13326: NULL,
13327: SYSDATE,
13328: FND_GLOBAL.USER_ID,
13329: SYSDATE,
13330: FND_GLOBAL.USER_ID,
13331: FND_GLOBAL.USER_ID,
13332: NULL,
13333: NULL,
13334: NULL,

Line 13331: FND_GLOBAL.USER_ID,

13327: SYSDATE,
13328: FND_GLOBAL.USER_ID,
13329: SYSDATE,
13330: FND_GLOBAL.USER_ID,
13331: FND_GLOBAL.USER_ID,
13332: NULL,
13333: NULL,
13334: NULL,
13335: NULL,