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 1341: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),

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

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

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

Line 1910: last_updated_by = FND_GLOBAL.USER_ID,

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

Line 1911: last_update_login = FND_GLOBAL.LOGIN_ID

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

Line 3438: last_updated_by = FND_GLOBAL.USER_ID,

3434: IF (p_action = C_ACTION_SEMICLOSED) THEN
3435: UPDATE WSH_EXCEPTIONS
3436: SET status= 'CLOSED',
3437: last_update_date = sysdate,
3438: last_updated_by = FND_GLOBAL.USER_ID,
3439: last_update_login = FND_GLOBAL.USER_ID
3440: WHERE trip_id = p_trip_id
3441: AND status <> 'CLOSED'
3442: AND severity <> 'INFO';

Line 3439: last_update_login = FND_GLOBAL.USER_ID

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

Line 3447: last_updated_by = FND_GLOBAL.USER_ID,

3443: ELSE
3444: UPDATE WSH_EXCEPTIONS
3445: SET status= 'CLOSED',
3446: last_update_date = sysdate,
3447: last_updated_by = FND_GLOBAL.USER_ID,
3448: last_update_login = FND_GLOBAL.USER_ID
3449: WHERE trip_id = p_trip_id
3450: AND status <> 'CLOSED';
3451: END IF;

Line 3448: last_update_login = FND_GLOBAL.USER_ID

3444: UPDATE WSH_EXCEPTIONS
3445: SET status= 'CLOSED',
3446: last_update_date = sysdate,
3447: last_updated_by = FND_GLOBAL.USER_ID,
3448: last_update_login = FND_GLOBAL.USER_ID
3449: WHERE trip_id = p_trip_id
3450: AND status <> 'CLOSED';
3451: END IF;
3452: l_count := SQL%rowcount;

Line 3466: last_updated_by = FND_GLOBAL.USER_ID,

3462: IF (p_action = C_ACTION_SEMICLOSED) THEN
3463: UPDATE WSH_EXCEPTIONS
3464: SET status='CLOSED',
3465: last_update_date = sysdate,
3466: last_updated_by = FND_GLOBAL.USER_ID,
3467: last_update_login = FND_GLOBAL.USER_ID
3468: WHERE trip_stop_id = p_trip_stop_id
3469: AND status <> 'CLOSED'
3470: AND severity <> 'INFO';

Line 3467: last_update_login = FND_GLOBAL.USER_ID

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

Line 3475: last_updated_by = FND_GLOBAL.USER_ID,

3471: ELSE
3472: UPDATE WSH_EXCEPTIONS
3473: SET status='CLOSED',
3474: last_update_date = sysdate,
3475: last_updated_by = FND_GLOBAL.USER_ID,
3476: last_update_login = FND_GLOBAL.USER_ID
3477: WHERE trip_stop_id = p_trip_stop_id
3478: AND status <> 'CLOSED';
3479:

Line 3476: last_update_login = FND_GLOBAL.USER_ID

3472: UPDATE WSH_EXCEPTIONS
3473: SET status='CLOSED',
3474: last_update_date = sysdate,
3475: last_updated_by = FND_GLOBAL.USER_ID,
3476: last_update_login = FND_GLOBAL.USER_ID
3477: WHERE trip_stop_id = p_trip_stop_id
3478: AND status <> 'CLOSED';
3479:
3480: END IF;

Line 3501: last_updated_by = FND_GLOBAL.USER_ID,

3497:
3498: UPDATE WSH_EXCEPTIONS
3499: SET status = C_STATUS_CLOSED,
3500: last_update_date = sysdate,
3501: last_updated_by = FND_GLOBAL.USER_ID,
3502: last_update_login = FND_GLOBAL.USER_ID
3503: WHERE delivery_detail_id IN
3504: (SELECT wda.delivery_detail_id
3505: FROM wsh_delivery_assignments wda

Line 3502: last_update_login = FND_GLOBAL.USER_ID

3498: UPDATE WSH_EXCEPTIONS
3499: SET status = C_STATUS_CLOSED,
3500: last_update_date = sysdate,
3501: last_updated_by = FND_GLOBAL.USER_ID,
3502: last_update_login = FND_GLOBAL.USER_ID
3503: WHERE delivery_detail_id IN
3504: (SELECT wda.delivery_detail_id
3505: FROM wsh_delivery_assignments wda
3506: WHERE wda.delivery_id = p_delivery_id)

Line 3515: last_updated_by = FND_GLOBAL.USER_ID,

3511:
3512: UPDATE WSH_EXCEPTIONS
3513: SET status = C_STATUS_CLOSED,
3514: last_update_date = sysdate,
3515: last_updated_by = FND_GLOBAL.USER_ID,
3516: last_update_login = FND_GLOBAL.USER_ID
3517: WHERE delivery_id = p_delivery_id
3518: AND status <> C_STATUS_CLOSED
3519: AND severity <> C_SEVERITY_INFO;

Line 3516: last_update_login = FND_GLOBAL.USER_ID

3512: UPDATE WSH_EXCEPTIONS
3513: SET status = C_STATUS_CLOSED,
3514: last_update_date = sysdate,
3515: last_updated_by = FND_GLOBAL.USER_ID,
3516: last_update_login = FND_GLOBAL.USER_ID
3517: WHERE delivery_id = p_delivery_id
3518: AND status <> C_STATUS_CLOSED
3519: AND severity <> C_SEVERITY_INFO;
3520:

Line 3528: last_updated_by = FND_GLOBAL.USER_ID,

3524: -- UPDATES are tuned the same way as above.
3525: UPDATE WSH_EXCEPTIONS
3526: SET status = p_action,
3527: last_update_date = sysdate,
3528: last_updated_by = FND_GLOBAL.USER_ID,
3529: last_update_login = FND_GLOBAL.USER_ID
3530: WHERE delivery_detail_id IN
3531: (SELECT wda.delivery_detail_id
3532: FROM wsh_delivery_assignments wda

Line 3529: last_update_login = FND_GLOBAL.USER_ID

3525: UPDATE WSH_EXCEPTIONS
3526: SET status = p_action,
3527: last_update_date = sysdate,
3528: last_updated_by = FND_GLOBAL.USER_ID,
3529: last_update_login = FND_GLOBAL.USER_ID
3530: WHERE delivery_detail_id IN
3531: (SELECT wda.delivery_detail_id
3532: FROM wsh_delivery_assignments wda
3533: WHERE wda.delivery_id = p_delivery_id)

Line 3541: last_updated_by = FND_GLOBAL.USER_ID,

3537:
3538: UPDATE WSH_EXCEPTIONS
3539: SET status = p_action,
3540: last_update_date = sysdate,
3541: last_updated_by = FND_GLOBAL.USER_ID,
3542: last_update_login = FND_GLOBAL.USER_ID
3543: WHERE delivery_id = p_delivery_id
3544: AND status <> C_STATUS_CLOSED;
3545:

Line 3542: last_update_login = FND_GLOBAL.USER_ID

3538: UPDATE WSH_EXCEPTIONS
3539: SET status = p_action,
3540: last_update_date = sysdate,
3541: last_updated_by = FND_GLOBAL.USER_ID,
3542: last_update_login = FND_GLOBAL.USER_ID
3543: WHERE delivery_id = p_delivery_id
3544: AND status <> C_STATUS_CLOSED;
3545:
3546: l_count := l_count + SQL%rowcount;

Line 3558: last_updated_by = FND_GLOBAL.USER_ID,

3554: IF (p_action = C_ACTION_SEMICLOSED) THEN
3555: UPDATE WSH_EXCEPTIONS
3556: SET status='CLOSED',
3557: last_update_date = sysdate,
3558: last_updated_by = FND_GLOBAL.USER_ID,
3559: last_update_login = FND_GLOBAL.USER_ID
3560: WHERE delivery_id = p_delivery_id
3561: AND status <> 'CLOSED'
3562: AND severity <> 'INFO'

Line 3559: last_update_login = FND_GLOBAL.USER_ID

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

Line 3569: last_updated_by = FND_GLOBAL.USER_ID,

3565: ELSE
3566: UPDATE WSH_EXCEPTIONS
3567: SET status='CLOSED',
3568: last_update_date = sysdate,
3569: last_updated_by = FND_GLOBAL.USER_ID,
3570: last_update_login = FND_GLOBAL.USER_ID
3571: WHERE delivery_id = p_delivery_id
3572: AND status <> 'CLOSED'
3573: --AND exception_name <> 'WSH_OTM_SHIPMENT_ERROR'; -- OTM R12 glog project;

Line 3570: last_update_login = FND_GLOBAL.USER_ID

3566: UPDATE WSH_EXCEPTIONS
3567: SET status='CLOSED',
3568: last_update_date = sysdate,
3569: last_updated_by = FND_GLOBAL.USER_ID,
3570: last_update_login = FND_GLOBAL.USER_ID
3571: WHERE delivery_id = p_delivery_id
3572: AND status <> 'CLOSED'
3573: --AND exception_name <> 'WSH_OTM_SHIPMENT_ERROR'; -- OTM R12 glog project;
3574: AND exception_name <> C_OTM_EXC_NAME; -- OTM R12 glog project;

Line 3588: last_updated_by = FND_GLOBAL.USER_ID,

3584: l_use_dynamic := 'N';
3585: UPDATE WSH_EXCEPTIONS
3586: SET status=p_action ,
3587: last_update_date = sysdate,
3588: last_updated_by = FND_GLOBAL.USER_ID,
3589: last_update_login = FND_GLOBAL.USER_ID
3590: WHERE delivery_detail_id = p_delivery_detail_id
3591: AND status <> 'CLOSED';
3592: l_count := SQL%rowcount;

Line 3589: last_update_login = FND_GLOBAL.USER_ID

3585: UPDATE WSH_EXCEPTIONS
3586: SET status=p_action ,
3587: last_update_date = sysdate,
3588: last_updated_by = FND_GLOBAL.USER_ID,
3589: last_update_login = FND_GLOBAL.USER_ID
3590: WHERE delivery_detail_id = p_delivery_detail_id
3591: AND status <> 'CLOSED';
3592: l_count := SQL%rowcount;
3593:

Line 3771: last_updated_by = FND_GLOBAL.USER_ID,

3767: FORALL l_counter IN 1..c_cfetch
3768: UPDATE WSH_EXCEPTIONS
3769: SET status=p_action ,
3770: last_update_date = sysdate,
3771: last_updated_by = FND_GLOBAL.USER_ID,
3772: last_update_login = FND_GLOBAL.USER_ID
3773: WHERE rowid = RowIdList(l_counter);
3774: END IF;
3775:

Line 3772: last_update_login = FND_GLOBAL.USER_ID

3768: UPDATE WSH_EXCEPTIONS
3769: SET status=p_action ,
3770: last_update_date = sysdate,
3771: last_updated_by = FND_GLOBAL.USER_ID,
3772: last_update_login = FND_GLOBAL.USER_ID
3773: WHERE rowid = RowIdList(l_counter);
3774: END IF;
3775:
3776: --IF (l_count > 0) THEN

Line 5053: p_logging_entity_id => FND_GLOBAL.USER_ID,

5049: x_exception_id => l_exception_id,
5050: p_exception_location_id => p_delivery_info_tab(i).INITIAL_PICKUP_LOCATION_ID,
5051: p_logged_at_location_id => p_delivery_info_tab(i).INITIAL_PICKUP_LOCATION_ID,
5052: p_logging_entity => 'SHIPPER',
5053: p_logging_entity_id => FND_GLOBAL.USER_ID,
5054: p_exception_name => l_exception_name,
5055: p_delivery_id => p_delivery_info_tab(i).delivery_id,
5056: p_message => l_exception_message);
5057:

Line 5126: p_logging_entity_id => FND_GLOBAL.USER_ID,

5122: x_exception_id => l_exception_id,
5123: p_exception_location_id => p_delivery_info_tab(i).INITIAL_PICKUP_LOCATION_ID,
5124: p_logged_at_location_id => p_delivery_info_tab(i).INITIAL_PICKUP_LOCATION_ID,
5125: p_logging_entity => 'SHIPPER',
5126: p_logging_entity_id => FND_GLOBAL.USER_ID,
5127: p_exception_name => l_exception_name,
5128: p_delivery_id => p_delivery_info_tab(i).delivery_id,
5129: p_message => l_exception_message);
5130: