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

Line 474: last_updated_by = FND_GLOBAL.USER_ID

470: FORALL i in l_tmp_detail_ids.FIRST..l_tmp_detail_ids.LAST
471: UPDATE wsh_delivery_details
472: SET ignore_for_planning = l_ignoreplan,
473: last_update_date = sysdate,
474: last_updated_by = FND_GLOBAL.USER_ID
475: WHERE delivery_detail_id=l_tmp_detail_ids(i);
476: IF (SQL%NOTFOUND) THEN
477: rollback to before_update;
478: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');

Line 504: last_updated_by = FND_GLOBAL.USER_ID

500: FORALL i in l_tmp_del_ids.FIRST..l_tmp_del_ids.LAST
501: UPDATE wsh_new_deliveries
502: SET ignore_for_planning = l_ignoreplan,
503: last_update_date = sysdate,
504: last_updated_by = FND_GLOBAL.USER_ID
505: WHERE delivery_id=l_tmp_del_ids(i);
506:
507: IF (SQL%NOTFOUND) THEN
508: rollback to before_update;

Line 618: last_updated_by = FND_GLOBAL.USER_ID,

614: UPDATE wsh_trips
615: SET ignore_for_planning = l_ignoreplan,
616: tp_plan_name = NULL, -- OTM R12, glog proj
617: last_update_date = sysdate,
618: last_updated_by = FND_GLOBAL.USER_ID,
619: last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj
620: WHERE trip_id=p_in_ids(i);
621:
622: ELSE -- l_tp_plan_name_update is null or N, do not update tp_plan_name

Line 619: last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj

615: SET ignore_for_planning = l_ignoreplan,
616: tp_plan_name = NULL, -- OTM R12, glog proj
617: last_update_date = sysdate,
618: last_updated_by = FND_GLOBAL.USER_ID,
619: last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj
620: WHERE trip_id=p_in_ids(i);
621:
622: ELSE -- l_tp_plan_name_update is null or N, do not update tp_plan_name
623: UPDATE wsh_trips

Line 626: last_updated_by = FND_GLOBAL.USER_ID,

622: ELSE -- l_tp_plan_name_update is null or N, do not update tp_plan_name
623: UPDATE wsh_trips
624: SET ignore_for_planning = l_ignoreplan,
625: last_update_date = sysdate,
626: last_updated_by = FND_GLOBAL.USER_ID,
627: last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj
628: WHERE trip_id=p_in_ids(i);
629: END IF;
630: -- end of OTM R12, glog proj

Line 627: last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj

623: UPDATE wsh_trips
624: SET ignore_for_planning = l_ignoreplan,
625: last_update_date = sysdate,
626: last_updated_by = FND_GLOBAL.USER_ID,
627: last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj
628: WHERE trip_id=p_in_ids(i);
629: END IF;
630: -- end of OTM R12, glog proj
631: --

Line 864: last_updated_by = FND_GLOBAL.USER_ID

860: FORALL i in l_tmp_detail_ids.FIRST..l_tmp_detail_ids.LAST
861: UPDATE wsh_delivery_details
862: SET ignore_for_planning = l_ignoreplan,
863: last_update_date = sysdate,
864: last_updated_by = FND_GLOBAL.USER_ID
865: WHERE delivery_detail_id=l_tmp_detail_ids(i);
866: IF (SQL%NOTFOUND) THEN
867: ROLLBACK to before_update;
868: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');

Line 1050: last_updated_by = FND_GLOBAL.USER_ID,

1046: tms_version_number = DECODE(l_tms_update,
1047: 'Y', l_new_version_number_tab(1),
1048: tms_version_number),
1049: last_update_date = sysdate,
1050: last_updated_by = FND_GLOBAL.USER_ID,
1051: last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj
1052: WHERE delivery_id=p_in_ids(i);
1053:
1054: IF (SQL%NOTFOUND) THEN

Line 1051: last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj

1047: 'Y', l_new_version_number_tab(1),
1048: tms_version_number),
1049: last_update_date = sysdate,
1050: last_updated_by = FND_GLOBAL.USER_ID,
1051: last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj
1052: WHERE delivery_id=p_in_ids(i);
1053:
1054: IF (SQL%NOTFOUND) THEN
1055: ROLLBACK to before_update;

Line 1263: last_updated_by = FND_GLOBAL.USER_ID

1259: FORALL i in l_tmp_detail_ids.FIRST..l_tmp_detail_ids.LAST
1260: UPDATE wsh_delivery_details
1261: SET ignore_for_planning=l_ignoreplan,
1262: last_update_date = sysdate,
1263: last_updated_by = FND_GLOBAL.USER_ID
1264: WHERE delivery_detail_id=l_tmp_detail_ids(i)
1265: RETURNING container_flag, organization_id, line_direction bulk collect into l_cont_flag_tbl, l_orgn_id_tbl, l_line_dir_tbl; -- LPN CONV. rv
1266: IF (SQL%NOTFOUND) THEN
1267: rollback to before_update;

Line 1416: last_updated_by = FND_GLOBAL.USER_ID

1412:
1413: UPDATE wsh_delivery_details
1414: SET ignore_for_planning = l_ignoreplan,
1415: last_update_date = sysdate,
1416: last_updated_by = FND_GLOBAL.USER_ID
1417: WHERE delivery_detail_id=p_in_ids(i);
1418: IF (SQL%NOTFOUND) THEN
1419: rollback to before_update;
1420: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');

Line 1597: last_updated_by = FND_GLOBAL.USER_ID

1593: l_deliveries_exist:='Y';
1594: UPDATE wsh_new_deliveries
1595: SET planned_flag = c_routing_firm_flag,
1596: last_update_date = sysdate,
1597: last_updated_by = FND_GLOBAL.USER_ID
1598: WHERE delivery_id = del_cur.delivery_id;
1599: --raise error to avoid inconsistency
1600: IF (SQL%NOTFOUND) THEN
1601: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');

Line 1637: last_updated_by = FND_GLOBAL.USER_ID

1633:
1634: UPDATE wsh_trips
1635: SET planned_flag = l_plannedflag,
1636: last_update_date = sysdate,
1637: last_updated_by = FND_GLOBAL.USER_ID
1638: WHERE trip_id = l_trips_cur.trip_id;
1639: --return error to avoid inconsistency
1640: IF (SQL%NOTFOUND) THEN
1641: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');

Line 1672: last_updated_by = FND_GLOBAL.USER_ID

1668: ELSE
1669: UPDATE wsh_trips
1670: SET planned_flag = c_routing_firm_flag ,
1671: last_update_date = sysdate,
1672: last_updated_by = FND_GLOBAL.USER_ID
1673: WHERE trip_id = p_entity_id;
1674: IF (SQL%NOTFOUND) THEN
1675: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
1676: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1716: last_updated_by = FND_GLOBAL.USER_ID

1712:
1713: UPDATE wsh_trips
1714: SET planned_flag = l_plannedflag,
1715: last_update_date = sysdate,
1716: last_updated_by = FND_GLOBAL.USER_ID
1717: WHERE trip_id = l_trips_cur.trip_id;
1718:
1719: --return error to avoid inconsistency
1720: IF (SQL%NOTFOUND) THEN

Line 1752: last_updated_by = FND_GLOBAL.USER_ID

1748: ELSE
1749: UPDATE wsh_new_deliveries
1750: SET planned_flag = c_routing_firm_flag,
1751: last_update_date = sysdate,
1752: last_updated_by = FND_GLOBAL.USER_ID
1753: WHERE delivery_id = p_entity_id;
1754:
1755: IF (SQL%NOTFOUND) THEN
1756: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');

Line 1889: last_updated_by = FND_GLOBAL.USER_ID

1885:
1886: UPDATE wsh_trips
1887: SET planned_flag = l_action,
1888: last_update_date = sysdate,
1889: last_updated_by = FND_GLOBAL.USER_ID
1890: WHERE trip_id = p_entity_id;
1891:
1892: IF (SQL%NOTFOUND) THEN
1893: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');

Line 1915: last_updated_by = FND_GLOBAL.USER_ID

1911: --from RCF (l_action = 'Y') in which case the delivery will remain at RCF.
1912: UPDATE wsh_new_deliveries
1913: SET planned_flag = decode(l_action, 'Y', planned_flag, 'Y'),
1914: last_update_date = sysdate,
1915: last_updated_by = FND_GLOBAL.USER_ID
1916: WHERE delivery_id = del_cur.delivery_id;
1917: --raise error to avoid inconsistency
1918: IF (SQL%NOTFOUND) THEN
1919: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');

Line 1937: last_updated_by = FND_GLOBAL.USER_ID

1933: FOR l_trips_cur IN c_trips(del_cur.delivery_id) LOOP
1934: UPDATE wsh_trips
1935: SET planned_flag = 'Y',
1936: last_update_date = sysdate,
1937: last_updated_by = FND_GLOBAL.USER_ID
1938: WHERE trip_id = l_trips_cur.trip_id;
1939: --raise error to avoid inconsistency
1940: IF (SQL%NOTFOUND) THEN
1941: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');

Line 1962: last_updated_by = FND_GLOBAL.USER_ID

1958:
1959: UPDATE wsh_new_deliveries
1960: SET planned_flag = l_action,
1961: last_update_date = sysdate,
1962: last_updated_by = FND_GLOBAL.USER_ID
1963: WHERE delivery_id = p_entity_id;
1964:
1965: IF (SQL%NOTFOUND) THEN
1966: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');

Line 1980: last_updated_by = FND_GLOBAL.USER_ID

1976: FOR cur_deltrip IN c_dlvy_trips LOOP
1977: UPDATE wsh_trips
1978: SET planned_flag = 'Y',
1979: last_update_date = sysdate,
1980: last_updated_by = FND_GLOBAL.USER_ID
1981: WHERE trip_id = cur_deltrip.trip_id;
1982:
1983: --raise error to avoid inconsistency
1984: IF (SQL%NOTFOUND) THEN

Line 3142: last_updated_by = FND_GLOBAL.USER_ID,

3138: 'Y', l_tms_version_number,
3139: NVL(tms_version_number, 1)),
3140: --
3141: last_update_date = sysdate,
3142: last_updated_by = FND_GLOBAL.USER_ID,
3143: last_update_login = FND_GLOBAL.LOGIN_ID
3144: WHERE delivery_id = l_delivery_id;
3145:
3146: --OTM R12

Line 3143: last_update_login = FND_GLOBAL.LOGIN_ID

3139: NVL(tms_version_number, 1)),
3140: --
3141: last_update_date = sysdate,
3142: last_updated_by = FND_GLOBAL.USER_ID,
3143: last_update_login = FND_GLOBAL.LOGIN_ID
3144: WHERE delivery_id = l_delivery_id;
3145:
3146: --OTM R12
3147: IF (l_gc3_is_installed = 'Y' AND l_tms_update = 'Y') THEN--{

Line 3472: last_updated_by = FND_GLOBAL.USER_ID

3468: earliest_dropoff_date = l_earliest_mdropoff_date,
3469: latest_pickup_date = l_latest_mpickup_date,
3470: latest_dropoff_date = l_latest_mdropoff_date,
3471: last_update_date = sysdate,
3472: last_updated_by = FND_GLOBAL.USER_ID
3473: WHERE delivery_detail_id = p_delivery_detail_id
3474: AND ( nvl(earliest_pickup_date, sysdate) <> nvl(l_earliest_mpickup_date, sysdate)
3475: OR nvl(earliest_dropoff_date, sysdate) <> nvl(earliest_dropoff_date, sysdate)
3476: OR nvl(latest_pickup_date, sysdate) <> nvl(latest_pickup_date, sysdate)

Line 3634: p_logging_entity_id => FND_GLOBAL.USER_ID,

3630: x_exception_id => l_exception_id,
3631: p_exception_location_id => l_location_id,
3632: p_logged_at_location_id => l_location_id,
3633: p_logging_entity => l_logging_entity,
3634: p_logging_entity_id => FND_GLOBAL.USER_ID,
3635: p_exception_name => l_exception_name,
3636: p_message => l_exception_message,
3637: p_delivery_id => p_entity_id,
3638: p_delivery_name => to_char(p_entity_id)

Line 3658: p_logging_entity_id => FND_GLOBAL.USER_ID,

3654: x_exception_id => l_exception_id,
3655: p_exception_location_id => l_location_id,
3656: p_logged_at_location_id => l_location_id,
3657: p_logging_entity => l_logging_entity,
3658: p_logging_entity_id => FND_GLOBAL.USER_ID,
3659: p_exception_name => l_exception_name,
3660: p_message => l_exception_message,
3661: p_delivery_detail_id => p_entity_id
3662: );

Line 3761: p_logging_entity_id => FND_GLOBAL.USER_ID,

3757: x_exception_id => l_exception_id,
3758: p_exception_location_id => l_location_id,
3759: p_logged_at_location_id => l_location_id,
3760: p_logging_entity => l_logging_entity,
3761: p_logging_entity_id => FND_GLOBAL.USER_ID,
3762: p_exception_name => l_exception_name,
3763: p_message => l_exception_message,
3764: p_delivery_detail_id => l_delivery_detail_id
3765: );