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

Line 517: l_request_id := fnd_global.conc_request_id;

513: THEN
514: l_manually_logged := p_manually_logged;
515: ELSE -- Bugfix 3711661
516: IF (p_request_id is null) THEN
517: l_request_id := fnd_global.conc_request_id;
518: ELSE
519: l_request_id := p_request_id;
520: END IF;
521:

Line 728: NVL(p_created_by,FND_GLOBAL.USER_ID),

724: p_attribute13,
725: p_attribute14,
726: p_attribute15,
727: NVL(p_creation_date,SYSDATE),
728: NVL(p_created_by,FND_GLOBAL.USER_ID),
729: NVL(p_last_update_date,SYSDATE),
730: NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
731: NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID),
732: -- BUG#:1549665 hwahdani added request_id

Line 730: NVL(p_last_updated_by,FND_GLOBAL.USER_ID),

726: p_attribute15,
727: NVL(p_creation_date,SYSDATE),
728: NVL(p_created_by,FND_GLOBAL.USER_ID),
729: NVL(p_last_update_date,SYSDATE),
730: NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
731: NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID),
732: -- BUG#:1549665 hwahdani added request_id
733: l_request_id, -- Bugfix 3711661, previously p_request_id was passed.
734: -- HW BUG#:1900149 added opm columns

Line 731: NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID),

727: NVL(p_creation_date,SYSDATE),
728: NVL(p_created_by,FND_GLOBAL.USER_ID),
729: NVL(p_last_update_date,SYSDATE),
730: NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
731: NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID),
732: -- BUG#:1549665 hwahdani added request_id
733: l_request_id, -- Bugfix 3711661, previously p_request_id was passed.
734: -- HW BUG#:1900149 added opm columns
735: -- HW OPMCONV - No need for sublot_number

Line 1340: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),

1336: attribute13 = p_attribute13,
1337: attribute14 = p_attribute14,
1338: attribute15 = p_attribute15,
1339: last_update_date = NVL(p_last_update_date,SYSDATE),
1340: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
1341: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID),
1342: --BUG#:1549665 hwahdani added request_id
1343: request_id = l_xcp_record.request_id
1344: WHERE CURRENT OF C3;

Line 1341: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID),

1337: attribute14 = p_attribute14,
1338: attribute15 = p_attribute15,
1339: last_update_date = NVL(p_last_update_date,SYSDATE),
1340: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
1341: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID),
1342: --BUG#:1549665 hwahdani added request_id
1343: request_id = l_xcp_record.request_id
1344: WHERE CURRENT OF C3;
1345:

Line 1909: last_updated_by = FND_GLOBAL.USER_ID,

1905:
1906: UPDATE wsh_exceptions
1907: SET status = l_new_status,
1908: last_update_date = SYSDATE,
1909: last_updated_by = FND_GLOBAL.USER_ID,
1910: last_update_login = FND_GLOBAL.LOGIN_ID
1911: WHERE exception_id = p_exception_id
1912: AND DECODE( UPPER(status),
1913: 'MANUAL','OPEN' ,

Line 1910: last_update_login = FND_GLOBAL.LOGIN_ID

1906: UPDATE wsh_exceptions
1907: SET status = l_new_status,
1908: last_update_date = SYSDATE,
1909: last_updated_by = FND_GLOBAL.USER_ID,
1910: last_update_login = FND_GLOBAL.LOGIN_ID
1911: WHERE exception_id = p_exception_id
1912: AND DECODE( UPPER(status),
1913: 'MANUAL','OPEN' ,
1914: 'LOGGED','OPEN' ,

Line 3430: last_updated_by = FND_GLOBAL.USER_ID,

3426: IF (p_action = C_ACTION_SEMICLOSED) THEN
3427: UPDATE WSH_EXCEPTIONS
3428: SET status= 'CLOSED',
3429: last_update_date = sysdate,
3430: last_updated_by = FND_GLOBAL.USER_ID,
3431: last_update_login = FND_GLOBAL.USER_ID
3432: WHERE trip_id = p_trip_id
3433: AND status <> 'CLOSED'
3434: AND severity <> 'INFO';

Line 3431: last_update_login = FND_GLOBAL.USER_ID

3427: UPDATE WSH_EXCEPTIONS
3428: SET status= 'CLOSED',
3429: last_update_date = sysdate,
3430: last_updated_by = FND_GLOBAL.USER_ID,
3431: last_update_login = FND_GLOBAL.USER_ID
3432: WHERE trip_id = p_trip_id
3433: AND status <> 'CLOSED'
3434: AND severity <> 'INFO';
3435: ELSE

Line 3439: last_updated_by = FND_GLOBAL.USER_ID,

3435: ELSE
3436: UPDATE WSH_EXCEPTIONS
3437: SET status= 'CLOSED',
3438: last_update_date = sysdate,
3439: last_updated_by = FND_GLOBAL.USER_ID,
3440: last_update_login = FND_GLOBAL.USER_ID
3441: WHERE trip_id = p_trip_id
3442: AND status <> 'CLOSED';
3443: END IF;

Line 3440: last_update_login = FND_GLOBAL.USER_ID

3436: UPDATE WSH_EXCEPTIONS
3437: SET status= 'CLOSED',
3438: last_update_date = sysdate,
3439: last_updated_by = FND_GLOBAL.USER_ID,
3440: last_update_login = FND_GLOBAL.USER_ID
3441: WHERE trip_id = p_trip_id
3442: AND status <> 'CLOSED';
3443: END IF;
3444: l_count := SQL%rowcount;

Line 3458: last_updated_by = FND_GLOBAL.USER_ID,

3454: IF (p_action = C_ACTION_SEMICLOSED) THEN
3455: UPDATE WSH_EXCEPTIONS
3456: SET status='CLOSED',
3457: last_update_date = sysdate,
3458: last_updated_by = FND_GLOBAL.USER_ID,
3459: last_update_login = FND_GLOBAL.USER_ID
3460: WHERE trip_stop_id = p_trip_stop_id
3461: AND status <> 'CLOSED'
3462: AND severity <> 'INFO';

Line 3459: last_update_login = FND_GLOBAL.USER_ID

3455: UPDATE WSH_EXCEPTIONS
3456: SET status='CLOSED',
3457: last_update_date = sysdate,
3458: last_updated_by = FND_GLOBAL.USER_ID,
3459: last_update_login = FND_GLOBAL.USER_ID
3460: WHERE trip_stop_id = p_trip_stop_id
3461: AND status <> 'CLOSED'
3462: AND severity <> 'INFO';
3463: ELSE

Line 3467: last_updated_by = FND_GLOBAL.USER_ID,

3463: ELSE
3464: UPDATE WSH_EXCEPTIONS
3465: SET status='CLOSED',
3466: last_update_date = sysdate,
3467: last_updated_by = FND_GLOBAL.USER_ID,
3468: last_update_login = FND_GLOBAL.USER_ID
3469: WHERE trip_stop_id = p_trip_stop_id
3470: AND status <> 'CLOSED';
3471:

Line 3468: last_update_login = FND_GLOBAL.USER_ID

3464: UPDATE WSH_EXCEPTIONS
3465: SET status='CLOSED',
3466: last_update_date = sysdate,
3467: last_updated_by = FND_GLOBAL.USER_ID,
3468: last_update_login = FND_GLOBAL.USER_ID
3469: WHERE trip_stop_id = p_trip_stop_id
3470: AND status <> 'CLOSED';
3471:
3472: END IF;

Line 3493: last_updated_by = FND_GLOBAL.USER_ID,

3489:
3490: UPDATE WSH_EXCEPTIONS
3491: SET status = C_STATUS_CLOSED,
3492: last_update_date = sysdate,
3493: last_updated_by = FND_GLOBAL.USER_ID,
3494: last_update_login = FND_GLOBAL.USER_ID
3495: WHERE delivery_detail_id IN
3496: (SELECT wda.delivery_detail_id
3497: FROM wsh_delivery_assignments wda

Line 3494: last_update_login = FND_GLOBAL.USER_ID

3490: UPDATE WSH_EXCEPTIONS
3491: SET status = C_STATUS_CLOSED,
3492: last_update_date = sysdate,
3493: last_updated_by = FND_GLOBAL.USER_ID,
3494: last_update_login = FND_GLOBAL.USER_ID
3495: WHERE delivery_detail_id IN
3496: (SELECT wda.delivery_detail_id
3497: FROM wsh_delivery_assignments wda
3498: WHERE wda.delivery_id = p_delivery_id)

Line 3507: last_updated_by = FND_GLOBAL.USER_ID,

3503:
3504: UPDATE WSH_EXCEPTIONS
3505: SET status = C_STATUS_CLOSED,
3506: last_update_date = sysdate,
3507: last_updated_by = FND_GLOBAL.USER_ID,
3508: last_update_login = FND_GLOBAL.USER_ID
3509: WHERE delivery_id = p_delivery_id
3510: AND status <> C_STATUS_CLOSED
3511: AND severity <> C_SEVERITY_INFO;

Line 3508: last_update_login = FND_GLOBAL.USER_ID

3504: UPDATE WSH_EXCEPTIONS
3505: SET status = C_STATUS_CLOSED,
3506: last_update_date = sysdate,
3507: last_updated_by = FND_GLOBAL.USER_ID,
3508: last_update_login = FND_GLOBAL.USER_ID
3509: WHERE delivery_id = p_delivery_id
3510: AND status <> C_STATUS_CLOSED
3511: AND severity <> C_SEVERITY_INFO;
3512:

Line 3520: last_updated_by = FND_GLOBAL.USER_ID,

3516: -- UPDATES are tuned the same way as above.
3517: UPDATE WSH_EXCEPTIONS
3518: SET status = p_action,
3519: last_update_date = sysdate,
3520: last_updated_by = FND_GLOBAL.USER_ID,
3521: last_update_login = FND_GLOBAL.USER_ID
3522: WHERE delivery_detail_id IN
3523: (SELECT wda.delivery_detail_id
3524: FROM wsh_delivery_assignments wda

Line 3521: last_update_login = FND_GLOBAL.USER_ID

3517: UPDATE WSH_EXCEPTIONS
3518: SET status = p_action,
3519: last_update_date = sysdate,
3520: last_updated_by = FND_GLOBAL.USER_ID,
3521: last_update_login = FND_GLOBAL.USER_ID
3522: WHERE delivery_detail_id IN
3523: (SELECT wda.delivery_detail_id
3524: FROM wsh_delivery_assignments wda
3525: WHERE wda.delivery_id = p_delivery_id)

Line 3533: last_updated_by = FND_GLOBAL.USER_ID,

3529:
3530: UPDATE WSH_EXCEPTIONS
3531: SET status = p_action,
3532: last_update_date = sysdate,
3533: last_updated_by = FND_GLOBAL.USER_ID,
3534: last_update_login = FND_GLOBAL.USER_ID
3535: WHERE delivery_id = p_delivery_id
3536: AND status <> C_STATUS_CLOSED;
3537:

Line 3534: last_update_login = FND_GLOBAL.USER_ID

3530: UPDATE WSH_EXCEPTIONS
3531: SET status = p_action,
3532: last_update_date = sysdate,
3533: last_updated_by = FND_GLOBAL.USER_ID,
3534: last_update_login = FND_GLOBAL.USER_ID
3535: WHERE delivery_id = p_delivery_id
3536: AND status <> C_STATUS_CLOSED;
3537:
3538: l_count := l_count + SQL%rowcount;

Line 3550: last_updated_by = FND_GLOBAL.USER_ID,

3546: IF (p_action = C_ACTION_SEMICLOSED) THEN
3547: UPDATE WSH_EXCEPTIONS
3548: SET status='CLOSED',
3549: last_update_date = sysdate,
3550: last_updated_by = FND_GLOBAL.USER_ID,
3551: last_update_login = FND_GLOBAL.USER_ID
3552: WHERE delivery_id = p_delivery_id
3553: AND status <> 'CLOSED'
3554: AND severity <> 'INFO'

Line 3551: last_update_login = FND_GLOBAL.USER_ID

3547: UPDATE WSH_EXCEPTIONS
3548: SET status='CLOSED',
3549: last_update_date = sysdate,
3550: last_updated_by = FND_GLOBAL.USER_ID,
3551: last_update_login = FND_GLOBAL.USER_ID
3552: WHERE delivery_id = p_delivery_id
3553: AND status <> 'CLOSED'
3554: AND severity <> 'INFO'
3555: --AND exception_name <> 'WSH_OTM_SHIPMENT_ERROR'; -- OTM R12 glog project;

Line 3561: last_updated_by = FND_GLOBAL.USER_ID,

3557: ELSE
3558: UPDATE WSH_EXCEPTIONS
3559: SET status='CLOSED',
3560: last_update_date = sysdate,
3561: last_updated_by = FND_GLOBAL.USER_ID,
3562: last_update_login = FND_GLOBAL.USER_ID
3563: WHERE delivery_id = p_delivery_id
3564: AND status <> 'CLOSED'
3565: --AND exception_name <> 'WSH_OTM_SHIPMENT_ERROR'; -- OTM R12 glog project;

Line 3562: last_update_login = FND_GLOBAL.USER_ID

3558: UPDATE WSH_EXCEPTIONS
3559: SET status='CLOSED',
3560: last_update_date = sysdate,
3561: last_updated_by = FND_GLOBAL.USER_ID,
3562: last_update_login = FND_GLOBAL.USER_ID
3563: WHERE delivery_id = p_delivery_id
3564: AND status <> 'CLOSED'
3565: --AND exception_name <> 'WSH_OTM_SHIPMENT_ERROR'; -- OTM R12 glog project;
3566: AND exception_name <> C_OTM_EXC_NAME; -- OTM R12 glog project;

Line 3580: last_updated_by = FND_GLOBAL.USER_ID,

3576: l_use_dynamic := 'N';
3577: UPDATE WSH_EXCEPTIONS
3578: SET status=p_action ,
3579: last_update_date = sysdate,
3580: last_updated_by = FND_GLOBAL.USER_ID,
3581: last_update_login = FND_GLOBAL.USER_ID
3582: WHERE delivery_detail_id = p_delivery_detail_id
3583: AND status <> 'CLOSED';
3584: l_count := SQL%rowcount;

Line 3581: last_update_login = FND_GLOBAL.USER_ID

3577: UPDATE WSH_EXCEPTIONS
3578: SET status=p_action ,
3579: last_update_date = sysdate,
3580: last_updated_by = FND_GLOBAL.USER_ID,
3581: last_update_login = FND_GLOBAL.USER_ID
3582: WHERE delivery_detail_id = p_delivery_detail_id
3583: AND status <> 'CLOSED';
3584: l_count := SQL%rowcount;
3585:

Line 3763: last_updated_by = FND_GLOBAL.USER_ID,

3759: FORALL l_counter IN 1..c_cfetch
3760: UPDATE WSH_EXCEPTIONS
3761: SET status=p_action ,
3762: last_update_date = sysdate,
3763: last_updated_by = FND_GLOBAL.USER_ID,
3764: last_update_login = FND_GLOBAL.USER_ID
3765: WHERE rowid = RowIdList(l_counter);
3766: END IF;
3767:

Line 3764: last_update_login = FND_GLOBAL.USER_ID

3760: UPDATE WSH_EXCEPTIONS
3761: SET status=p_action ,
3762: last_update_date = sysdate,
3763: last_updated_by = FND_GLOBAL.USER_ID,
3764: last_update_login = FND_GLOBAL.USER_ID
3765: WHERE rowid = RowIdList(l_counter);
3766: END IF;
3767:
3768: --IF (l_count > 0) THEN

Line 5045: p_logging_entity_id => FND_GLOBAL.USER_ID,

5041: x_exception_id => l_exception_id,
5042: p_exception_location_id => p_delivery_info_tab(i).INITIAL_PICKUP_LOCATION_ID,
5043: p_logged_at_location_id => p_delivery_info_tab(i).INITIAL_PICKUP_LOCATION_ID,
5044: p_logging_entity => 'SHIPPER',
5045: p_logging_entity_id => FND_GLOBAL.USER_ID,
5046: p_exception_name => l_exception_name,
5047: p_delivery_id => p_delivery_info_tab(i).delivery_id,
5048: p_message => l_exception_message);
5049:

Line 5118: p_logging_entity_id => FND_GLOBAL.USER_ID,

5114: x_exception_id => l_exception_id,
5115: p_exception_location_id => p_delivery_info_tab(i).INITIAL_PICKUP_LOCATION_ID,
5116: p_logged_at_location_id => p_delivery_info_tab(i).INITIAL_PICKUP_LOCATION_ID,
5117: p_logging_entity => 'SHIPPER',
5118: p_logging_entity_id => FND_GLOBAL.USER_ID,
5119: p_exception_name => l_exception_name,
5120: p_delivery_id => p_delivery_info_tab(i).delivery_id,
5121: p_message => l_exception_message);
5122: