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 545: last_updated_by = FND_GLOBAL.USER_ID,

541: UPDATE wsh_trips
542: SET ignore_for_planning = l_ignoreplan,
543: tp_plan_name = NULL, -- OTM R12, glog proj
544: last_update_date = sysdate,
545: last_updated_by = FND_GLOBAL.USER_ID,
546: last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj
547: WHERE trip_id=p_in_ids(i);
548:
549: ELSE -- l_tp_plan_name_update is null or N, do not update tp_plan_name

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

542: SET ignore_for_planning = l_ignoreplan,
543: tp_plan_name = NULL, -- OTM R12, glog proj
544: last_update_date = sysdate,
545: last_updated_by = FND_GLOBAL.USER_ID,
546: last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj
547: WHERE trip_id=p_in_ids(i);
548:
549: ELSE -- l_tp_plan_name_update is null or N, do not update tp_plan_name
550: UPDATE wsh_trips

Line 553: last_updated_by = FND_GLOBAL.USER_ID,

549: ELSE -- l_tp_plan_name_update is null or N, do not update tp_plan_name
550: UPDATE wsh_trips
551: SET ignore_for_planning = l_ignoreplan,
552: last_update_date = sysdate,
553: last_updated_by = FND_GLOBAL.USER_ID,
554: last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj
555: WHERE trip_id=p_in_ids(i);
556: END IF;
557: -- end of OTM R12, glog proj

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

550: UPDATE wsh_trips
551: SET ignore_for_planning = l_ignoreplan,
552: last_update_date = sysdate,
553: last_updated_by = FND_GLOBAL.USER_ID,
554: last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj
555: WHERE trip_id=p_in_ids(i);
556: END IF;
557: -- end of OTM R12, glog proj
558: --

Line 791: last_updated_by = FND_GLOBAL.USER_ID

787: FORALL i in l_tmp_detail_ids.FIRST..l_tmp_detail_ids.LAST
788: UPDATE wsh_delivery_details
789: SET ignore_for_planning = l_ignoreplan,
790: last_update_date = sysdate,
791: last_updated_by = FND_GLOBAL.USER_ID
792: WHERE delivery_detail_id=l_tmp_detail_ids(i);
793: IF (SQL%NOTFOUND) THEN
794: ROLLBACK to before_update;
795: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');

Line 977: last_updated_by = FND_GLOBAL.USER_ID,

973: tms_version_number = DECODE(l_tms_update,
974: 'Y', l_new_version_number_tab(1),
975: tms_version_number),
976: last_update_date = sysdate,
977: last_updated_by = FND_GLOBAL.USER_ID,
978: last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj
979: WHERE delivery_id=p_in_ids(i);
980:
981: IF (SQL%NOTFOUND) THEN

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

974: 'Y', l_new_version_number_tab(1),
975: tms_version_number),
976: last_update_date = sysdate,
977: last_updated_by = FND_GLOBAL.USER_ID,
978: last_update_login = FND_GLOBAL.LOGIN_ID -- OTM R12, glog proj
979: WHERE delivery_id=p_in_ids(i);
980:
981: IF (SQL%NOTFOUND) THEN
982: ROLLBACK to before_update;

Line 1118: last_updated_by = FND_GLOBAL.USER_ID

1114: FORALL i in l_tmp_detail_ids.FIRST..l_tmp_detail_ids.LAST
1115: UPDATE wsh_delivery_details
1116: SET ignore_for_planning=l_ignoreplan,
1117: last_update_date = sysdate,
1118: last_updated_by = FND_GLOBAL.USER_ID
1119: WHERE delivery_detail_id=l_tmp_detail_ids(i)
1120: 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
1121: IF (SQL%NOTFOUND) THEN
1122: rollback to before_update;

Line 1271: last_updated_by = FND_GLOBAL.USER_ID

1267:
1268: UPDATE wsh_delivery_details
1269: SET ignore_for_planning = l_ignoreplan,
1270: last_update_date = sysdate,
1271: last_updated_by = FND_GLOBAL.USER_ID
1272: WHERE delivery_detail_id=p_in_ids(i);
1273: IF (SQL%NOTFOUND) THEN
1274: rollback to before_update;
1275: FND_MESSAGE.SET_NAME('WSH','WSH_IGNOREPLAN_UPDATE_ERROR');

Line 1452: last_updated_by = FND_GLOBAL.USER_ID

1448: l_deliveries_exist:='Y';
1449: UPDATE wsh_new_deliveries
1450: SET planned_flag = c_routing_firm_flag,
1451: last_update_date = sysdate,
1452: last_updated_by = FND_GLOBAL.USER_ID
1453: WHERE delivery_id = del_cur.delivery_id;
1454: --raise error to avoid inconsistency
1455: IF (SQL%NOTFOUND) THEN
1456: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');

Line 1492: last_updated_by = FND_GLOBAL.USER_ID

1488:
1489: UPDATE wsh_trips
1490: SET planned_flag = l_plannedflag,
1491: last_update_date = sysdate,
1492: last_updated_by = FND_GLOBAL.USER_ID
1493: WHERE trip_id = l_trips_cur.trip_id;
1494: --return error to avoid inconsistency
1495: IF (SQL%NOTFOUND) THEN
1496: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');

Line 1527: last_updated_by = FND_GLOBAL.USER_ID

1523: ELSE
1524: UPDATE wsh_trips
1525: SET planned_flag = c_routing_firm_flag ,
1526: last_update_date = sysdate,
1527: last_updated_by = FND_GLOBAL.USER_ID
1528: WHERE trip_id = p_entity_id;
1529: IF (SQL%NOTFOUND) THEN
1530: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
1531: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1571: last_updated_by = FND_GLOBAL.USER_ID

1567:
1568: UPDATE wsh_trips
1569: SET planned_flag = l_plannedflag,
1570: last_update_date = sysdate,
1571: last_updated_by = FND_GLOBAL.USER_ID
1572: WHERE trip_id = l_trips_cur.trip_id;
1573:
1574: --return error to avoid inconsistency
1575: IF (SQL%NOTFOUND) THEN

Line 1607: last_updated_by = FND_GLOBAL.USER_ID

1603: ELSE
1604: UPDATE wsh_new_deliveries
1605: SET planned_flag = c_routing_firm_flag,
1606: last_update_date = sysdate,
1607: last_updated_by = FND_GLOBAL.USER_ID
1608: WHERE delivery_id = p_entity_id;
1609:
1610: IF (SQL%NOTFOUND) THEN
1611: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');

Line 1744: last_updated_by = FND_GLOBAL.USER_ID

1740:
1741: UPDATE wsh_trips
1742: SET planned_flag = l_action,
1743: last_update_date = sysdate,
1744: last_updated_by = FND_GLOBAL.USER_ID
1745: WHERE trip_id = p_entity_id;
1746:
1747: IF (SQL%NOTFOUND) THEN
1748: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');

Line 1770: last_updated_by = FND_GLOBAL.USER_ID

1766: --from RCF (l_action = 'Y') in which case the delivery will remain at RCF.
1767: UPDATE wsh_new_deliveries
1768: SET planned_flag = decode(l_action, 'Y', planned_flag, 'Y'),
1769: last_update_date = sysdate,
1770: last_updated_by = FND_GLOBAL.USER_ID
1771: WHERE delivery_id = del_cur.delivery_id;
1772: --raise error to avoid inconsistency
1773: IF (SQL%NOTFOUND) THEN
1774: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');

Line 1792: last_updated_by = FND_GLOBAL.USER_ID

1788: FOR l_trips_cur IN c_trips(del_cur.delivery_id) LOOP
1789: UPDATE wsh_trips
1790: SET planned_flag = 'Y',
1791: last_update_date = sysdate,
1792: last_updated_by = FND_GLOBAL.USER_ID
1793: WHERE trip_id = l_trips_cur.trip_id;
1794: --raise error to avoid inconsistency
1795: IF (SQL%NOTFOUND) THEN
1796: FND_MESSAGE.SET_NAME('WSH','WSH_FIRM_UPDATE_ERROR');

Line 1817: last_updated_by = FND_GLOBAL.USER_ID

1813:
1814: UPDATE wsh_new_deliveries
1815: SET planned_flag = l_action,
1816: last_update_date = sysdate,
1817: last_updated_by = FND_GLOBAL.USER_ID
1818: WHERE delivery_id = p_entity_id;
1819:
1820: IF (SQL%NOTFOUND) THEN
1821: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_NOT_FOUND');

Line 1835: last_updated_by = FND_GLOBAL.USER_ID

1831: FOR cur_deltrip IN c_dlvy_trips LOOP
1832: UPDATE wsh_trips
1833: SET planned_flag = 'Y',
1834: last_update_date = sysdate,
1835: last_updated_by = FND_GLOBAL.USER_ID
1836: WHERE trip_id = cur_deltrip.trip_id;
1837:
1838: --raise error to avoid inconsistency
1839: IF (SQL%NOTFOUND) THEN

Line 2995: last_updated_by = FND_GLOBAL.USER_ID,

2991: 'Y', l_tms_version_number,
2992: NVL(tms_version_number, 1)),
2993: --
2994: last_update_date = sysdate,
2995: last_updated_by = FND_GLOBAL.USER_ID,
2996: last_update_login = FND_GLOBAL.LOGIN_ID
2997: WHERE delivery_id = l_delivery_id;
2998:
2999: --OTM R12

Line 2996: last_update_login = FND_GLOBAL.LOGIN_ID

2992: NVL(tms_version_number, 1)),
2993: --
2994: last_update_date = sysdate,
2995: last_updated_by = FND_GLOBAL.USER_ID,
2996: last_update_login = FND_GLOBAL.LOGIN_ID
2997: WHERE delivery_id = l_delivery_id;
2998:
2999: --OTM R12
3000: IF (l_gc3_is_installed = 'Y' AND l_tms_update = 'Y') THEN--{

Line 3325: last_updated_by = FND_GLOBAL.USER_ID

3321: earliest_dropoff_date = l_earliest_mdropoff_date,
3322: latest_pickup_date = l_latest_mpickup_date,
3323: latest_dropoff_date = l_latest_mdropoff_date,
3324: last_update_date = sysdate,
3325: last_updated_by = FND_GLOBAL.USER_ID
3326: WHERE delivery_detail_id = p_delivery_detail_id
3327: AND ( nvl(earliest_pickup_date, sysdate) <> nvl(l_earliest_mpickup_date, sysdate)
3328: OR nvl(earliest_dropoff_date, sysdate) <> nvl(earliest_dropoff_date, sysdate)
3329: OR nvl(latest_pickup_date, sysdate) <> nvl(latest_pickup_date, sysdate)

Line 3487: p_logging_entity_id => FND_GLOBAL.USER_ID,

3483: x_exception_id => l_exception_id,
3484: p_exception_location_id => l_location_id,
3485: p_logged_at_location_id => l_location_id,
3486: p_logging_entity => l_logging_entity,
3487: p_logging_entity_id => FND_GLOBAL.USER_ID,
3488: p_exception_name => l_exception_name,
3489: p_message => l_exception_message,
3490: p_delivery_id => p_entity_id,
3491: p_delivery_name => to_char(p_entity_id)

Line 3511: p_logging_entity_id => FND_GLOBAL.USER_ID,

3507: x_exception_id => l_exception_id,
3508: p_exception_location_id => l_location_id,
3509: p_logged_at_location_id => l_location_id,
3510: p_logging_entity => l_logging_entity,
3511: p_logging_entity_id => FND_GLOBAL.USER_ID,
3512: p_exception_name => l_exception_name,
3513: p_message => l_exception_message,
3514: p_delivery_detail_id => p_entity_id
3515: );

Line 3614: p_logging_entity_id => FND_GLOBAL.USER_ID,

3610: x_exception_id => l_exception_id,
3611: p_exception_location_id => l_location_id,
3612: p_logged_at_location_id => l_location_id,
3613: p_logging_entity => l_logging_entity,
3614: p_logging_entity_id => FND_GLOBAL.USER_ID,
3615: p_exception_name => l_exception_name,
3616: p_message => l_exception_message,
3617: p_delivery_detail_id => l_delivery_detail_id
3618: );