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 3130: l_login_id := FND_GLOBAL.login_id;

3126: WSH_DEBUG_SV.log(l_module_name,'P_DEFER_INTERFACE_FLAG',P_DEFER_INTERFACE_FLAG);
3127: WSH_DEBUG_SV.log(l_module_name,'P_SEND_945_FLAG',P_SEND_945_FLAG);
3128: END IF;
3129: --
3130: l_login_id := FND_GLOBAL.login_id;
3131: l_user_id := FND_GLOBAL.user_id ;
3132: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;
3133:
3134: --OTM R12

Line 3131: l_user_id := FND_GLOBAL.user_id ;

3127: WSH_DEBUG_SV.log(l_module_name,'P_SEND_945_FLAG',P_SEND_945_FLAG);
3128: END IF;
3129: --
3130: l_login_id := FND_GLOBAL.login_id;
3131: l_user_id := FND_GLOBAL.user_id ;
3132: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;
3133:
3134: --OTM R12
3135: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED; -- this is global variable

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

3148: END IF;
3149: -- bug 2778035
3150:
3151: -- Fix for Bug 3944151
3152: -- Using fnd_global.User_name for global G_USER_NAME
3153: -- This is because before this fix, global g_user_name carried the previous user name
3154: -- when one user logged out and another user logged back in the same mobile telnet session.
3155:
3156: G_USER_NAME := FND_GLOBAL.USER_NAME;

Line 3156: G_USER_NAME := FND_GLOBAL.USER_NAME;

3152: -- Using fnd_global.User_name for global G_USER_NAME
3153: -- This is because before this fix, global g_user_name carried the previous user name
3154: -- when one user logged out and another user logged back in the same mobile telnet session.
3155:
3156: G_USER_NAME := FND_GLOBAL.USER_NAME;
3157:
3158: /* if ( G_USER_NAME is NULL ) then
3159: open user_name(l_user_id);
3160: fetch user_name into G_USER_NAME ;

Line 7389: l_user_id := FND_GLOBAL.user_id;

7385: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
7386: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
7387: END IF;
7388: --
7389: l_user_id := FND_GLOBAL.user_id;
7390: l_login_id := FND_GLOBAL.login_id;
7391: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7392: l_num_warnings := 0;
7393: l_num_errors := 0;

Line 7390: l_login_id := FND_GLOBAL.login_id;

7386: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
7387: END IF;
7388: --
7389: l_user_id := FND_GLOBAL.user_id;
7390: l_login_id := FND_GLOBAL.login_id;
7391: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7392: l_num_warnings := 0;
7393: l_num_errors := 0;
7394:

Line 7799: l_user_id := FND_GLOBAL.user_id;

7795: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
7796: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
7797: END IF;
7798: --
7799: l_user_id := FND_GLOBAL.user_id;
7800: l_login_id := FND_GLOBAL.login_id;
7801: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7802: l_num_warnings := 0;
7803: l_num_errors := 0;

Line 7800: l_login_id := FND_GLOBAL.login_id;

7796: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
7797: END IF;
7798: --
7799: l_user_id := FND_GLOBAL.user_id;
7800: l_login_id := FND_GLOBAL.login_id;
7801: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7802: l_num_warnings := 0;
7803: l_num_errors := 0;
7804: --

Line 8113: l_user_id := FND_GLOBAL.user_id;

8109: WSH_DEBUG_SV.log(l_module_name,'P_ACTUAL_DATE',P_ACTUAL_DATE);
8110: END IF;
8111: --
8112: --
8113: l_user_id := FND_GLOBAL.user_id;
8114: l_login_id := FND_GLOBAL.login_id;
8115: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
8116: --
8117: l_num_warnings := 0;

Line 8114: l_login_id := FND_GLOBAL.login_id;

8110: END IF;
8111: --
8112: --
8113: l_user_id := FND_GLOBAL.user_id;
8114: l_login_id := FND_GLOBAL.login_id;
8115: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
8116: --
8117: l_num_warnings := 0;
8118: l_num_errors := 0;

Line 8946: last_updated_by = FND_GLOBAL.USER_ID

8942: IF (p_update_del_flag='Y') THEN
8943: UPDATE wsh_new_deliveries
8944: SET ITINERARY_COMPLETE = l_update_flag,
8945: last_update_date = sysdate,
8946: last_updated_by = FND_GLOBAL.USER_ID
8947: WHERE delivery_id= p_delivery_id;
8948: END IF;
8949:
8950: END IF;

Line 9671: last_updated_by = FND_GLOBAL.USER_ID,

9667:
9668: UPDATE wsh_new_deliveries
9669: SET freight_terms_code = l_dlvy_freight_terms_code,
9670: last_update_date = SYSDATE,
9671: last_updated_by = FND_GLOBAL.USER_ID,
9672: last_update_login = FND_GLOBAL.LOGIN_ID
9673: WHERE delivery_id = p_delivery_id;
9674: --
9675: IF (SQL%NOTFOUND)

Line 9672: last_update_login = FND_GLOBAL.LOGIN_ID

9668: UPDATE wsh_new_deliveries
9669: SET freight_terms_code = l_dlvy_freight_terms_code,
9670: last_update_date = SYSDATE,
9671: last_updated_by = FND_GLOBAL.USER_ID,
9672: last_update_login = FND_GLOBAL.LOGIN_ID
9673: WHERE delivery_id = p_delivery_id;
9674: --
9675: IF (SQL%NOTFOUND)
9676: THEN

Line 9709: last_updated_by = FND_GLOBAL.USER_ID,

9705: END IF;
9706: --
9707: UPDATE wsh_new_deliveries
9708: SET last_update_date = SYSDATE,
9709: last_updated_by = FND_GLOBAL.USER_ID,
9710: last_update_login = FND_GLOBAL.LOGIN_ID
9711: WHERE delivery_id = p_delivery_id;
9712: --
9713: IF (SQL%NOTFOUND)

Line 9710: last_update_login = FND_GLOBAL.LOGIN_ID

9706: --
9707: UPDATE wsh_new_deliveries
9708: SET last_update_date = SYSDATE,
9709: last_updated_by = FND_GLOBAL.USER_ID,
9710: last_update_login = FND_GLOBAL.LOGIN_ID
9711: WHERE delivery_id = p_delivery_id;
9712: --
9713: IF (SQL%NOTFOUND)
9714: THEN

Line 9913: last_updated_by = FND_GLOBAL.USER_ID,

9909: /*
9910: UPDATE WSH_NEW_DELIVERIES
9911: SET INITIAL_PICKUP_LOCATION_ID = p_location_id,
9912: last_update_date = SYSDATE,
9913: last_updated_by = FND_GLOBAL.USER_ID,
9914: last_update_login = FND_GLOBAL.LOGIN_ID
9915: WHERE delivery_id = p_delivery_id;
9916: */
9917: --

Line 9914: last_update_login = FND_GLOBAL.LOGIN_ID

9910: UPDATE WSH_NEW_DELIVERIES
9911: SET INITIAL_PICKUP_LOCATION_ID = p_location_id,
9912: last_update_date = SYSDATE,
9913: last_updated_by = FND_GLOBAL.USER_ID,
9914: last_update_login = FND_GLOBAL.LOGIN_ID
9915: WHERE delivery_id = p_delivery_id;
9916: */
9917: --
9918: --

Line 9922: last_updated_by = FND_GLOBAL.USER_ID,

9918: --
9919: UPDATE WSH_DELIVERY_DETAILS
9920: SET SHIP_FROM_LOCATION_ID = p_location_id,
9921: last_update_date = SYSDATE,
9922: last_updated_by = FND_GLOBAL.USER_ID,
9923: last_update_login = FND_GLOBAL.LOGIN_ID
9924: WHERE delivery_detail_id IN (
9925: SELECT delivery_detail_id
9926: FROM wsh_delivery_assignments_v

Line 9923: last_update_login = FND_GLOBAL.LOGIN_ID

9919: UPDATE WSH_DELIVERY_DETAILS
9920: SET SHIP_FROM_LOCATION_ID = p_location_id,
9921: last_update_date = SYSDATE,
9922: last_updated_by = FND_GLOBAL.USER_ID,
9923: last_update_login = FND_GLOBAL.LOGIN_ID
9924: WHERE delivery_detail_id IN (
9925: SELECT delivery_detail_id
9926: FROM wsh_delivery_assignments_v
9927: WHERE delivery_id = p_delivery_id

Line 10012: last_updated_by = FND_GLOBAL.USER_ID,

10008: -- physical_stop_id and physical_location_id
10009: UPDATE wsh_trip_stops
10010: SET stop_location_id = p_location_id,
10011: last_update_date = SYSDATE,
10012: last_updated_by = FND_GLOBAL.USER_ID,
10013: last_update_login = FND_GLOBAL.LOGIN_ID,
10014: physical_stop_id = l_physical_stop_id, -- J+ Internal Locations
10015: physical_location_id = l_physical_location_id -- J+ Internal Locations
10016: WHERE stop_id = stop_rec.stop_id;

Line 10013: last_update_login = FND_GLOBAL.LOGIN_ID,

10009: UPDATE wsh_trip_stops
10010: SET stop_location_id = p_location_id,
10011: last_update_date = SYSDATE,
10012: last_updated_by = FND_GLOBAL.USER_ID,
10013: last_update_login = FND_GLOBAL.LOGIN_ID,
10014: physical_stop_id = l_physical_stop_id, -- J+ Internal Locations
10015: physical_location_id = l_physical_location_id -- J+ Internal Locations
10016: WHERE stop_id = stop_rec.stop_id;
10017: --

Line 10053: last_updated_by = FND_GLOBAL.USER_ID,

10049: --will not check tms flag here
10050: UPDATE WSH_NEW_DELIVERIES
10051: SET INITIAL_PICKUP_LOCATION_ID = p_location_id,
10052: last_update_date = SYSDATE,
10053: last_updated_by = FND_GLOBAL.USER_ID,
10054: last_update_login = FND_GLOBAL.LOGIN_ID
10055: WHERE delivery_id = pickup_dlvy_rec.delivery_id;
10056: --
10057: --

Line 10054: last_update_login = FND_GLOBAL.LOGIN_ID

10050: UPDATE WSH_NEW_DELIVERIES
10051: SET INITIAL_PICKUP_LOCATION_ID = p_location_id,
10052: last_update_date = SYSDATE,
10053: last_updated_by = FND_GLOBAL.USER_ID,
10054: last_update_login = FND_GLOBAL.LOGIN_ID
10055: WHERE delivery_id = pickup_dlvy_rec.delivery_id;
10056: --
10057: --
10058: UPDATE WSH_DELIVERY_DETAILS

Line 10061: last_updated_by = FND_GLOBAL.USER_ID,

10057: --
10058: UPDATE WSH_DELIVERY_DETAILS
10059: SET SHIP_FROM_LOCATION_ID = p_location_id,
10060: last_update_date = SYSDATE,
10061: last_updated_by = FND_GLOBAL.USER_ID,
10062: last_update_login = FND_GLOBAL.LOGIN_ID
10063: WHERE delivery_detail_id IN (
10064: SELECT delivery_detail_id
10065: FROM wsh_delivery_assignments_v

Line 10062: last_update_login = FND_GLOBAL.LOGIN_ID

10058: UPDATE WSH_DELIVERY_DETAILS
10059: SET SHIP_FROM_LOCATION_ID = p_location_id,
10060: last_update_date = SYSDATE,
10061: last_updated_by = FND_GLOBAL.USER_ID,
10062: last_update_login = FND_GLOBAL.LOGIN_ID
10063: WHERE delivery_detail_id IN (
10064: SELECT delivery_detail_id
10065: FROM wsh_delivery_assignments_v
10066: WHERE delivery_id = pickup_dlvy_rec.delivery_id

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

11425: x_trip_info_tab(fmct).ATTRIBUTE13 := FND_API.G_MISS_CHAR;
11426: x_trip_info_tab(fmct).ATTRIBUTE14 := FND_API.G_MISS_CHAR;
11427: x_trip_info_tab(fmct).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11428: x_trip_info_tab(fmct).CREATION_DATE := SYSDATE;
11429: x_trip_info_tab(fmct).CREATED_BY := fnd_global.user_id;
11430: x_trip_info_tab(fmct).LAST_UPDATE_DATE := SYSDATE;
11431: x_trip_info_tab(fmct).LAST_UPDATED_BY := fnd_global.user_id;
11432: x_trip_info_tab(fmct).LAST_UPDATE_LOGIN := fnd_global.login_id;
11433: x_trip_info_tab(fmct).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;

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

11427: x_trip_info_tab(fmct).ATTRIBUTE15 := FND_API.G_MISS_CHAR;
11428: x_trip_info_tab(fmct).CREATION_DATE := SYSDATE;
11429: x_trip_info_tab(fmct).CREATED_BY := fnd_global.user_id;
11430: x_trip_info_tab(fmct).LAST_UPDATE_DATE := SYSDATE;
11431: x_trip_info_tab(fmct).LAST_UPDATED_BY := fnd_global.user_id;
11432: x_trip_info_tab(fmct).LAST_UPDATE_LOGIN := fnd_global.login_id;
11433: x_trip_info_tab(fmct).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11434: x_trip_info_tab(fmct).PROGRAM_ID := FND_API.G_MISS_NUM;
11435: x_trip_info_tab(fmct).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;

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

11428: x_trip_info_tab(fmct).CREATION_DATE := SYSDATE;
11429: x_trip_info_tab(fmct).CREATED_BY := fnd_global.user_id;
11430: x_trip_info_tab(fmct).LAST_UPDATE_DATE := SYSDATE;
11431: x_trip_info_tab(fmct).LAST_UPDATED_BY := fnd_global.user_id;
11432: x_trip_info_tab(fmct).LAST_UPDATE_LOGIN := fnd_global.login_id;
11433: x_trip_info_tab(fmct).PROGRAM_APPLICATION_ID := FND_API.G_MISS_NUM;
11434: x_trip_info_tab(fmct).PROGRAM_ID := FND_API.G_MISS_NUM;
11435: x_trip_info_tab(fmct).PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
11436: x_trip_info_tab(fmct).REQUEST_ID := FND_API.G_MISS_NUM;

Line 13131: FND_GLOBAL.USER_ID,

13127: p_parent_del_id,
13128: l_child_details_tab(k),
13129: NULL,
13130: SYSDATE,
13131: FND_GLOBAL.USER_ID,
13132: SYSDATE,
13133: FND_GLOBAL.USER_ID,
13134: FND_GLOBAL.USER_ID,
13135: NULL,

Line 13133: FND_GLOBAL.USER_ID,

13129: NULL,
13130: SYSDATE,
13131: FND_GLOBAL.USER_ID,
13132: SYSDATE,
13133: FND_GLOBAL.USER_ID,
13134: FND_GLOBAL.USER_ID,
13135: NULL,
13136: NULL,
13137: NULL,

Line 13134: FND_GLOBAL.USER_ID,

13130: SYSDATE,
13131: FND_GLOBAL.USER_ID,
13132: SYSDATE,
13133: FND_GLOBAL.USER_ID,
13134: FND_GLOBAL.USER_ID,
13135: NULL,
13136: NULL,
13137: NULL,
13138: NULL,