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

Line 450: || FND_GLOBAL.LOCAL_CHR(10)

446: ELSIF l_messageLength + l_messageStrLength < 2000
447: THEN
448: --{
449: l_messageStr := l_messageStr
450: || FND_GLOBAL.LOCAL_CHR(10)
451: || l_message;
452: --}
453: ELSE
454: --{

Line 694: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

690: SET STATUS = NVL(l_headerStatus,STATUS),
691: OBJECT_VERSION_NUMBER = NVL(l_headerObjectVersionNumber,OBJECT_VERSION_NUMBER),
692: MAX_RCV_TRANSACTION_ID = NVL(l_maxRCVTransactionId,MAX_RCV_TRANSACTION_ID),
693: LAST_UPDATE_DATE = SYSDATE,
694: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
695: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
696: WHERE TRANSACTION_ID = p_headerTransactionId;
697: --
698: IF SQL%ROWCOUNT = 0

Line 695: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

691: OBJECT_VERSION_NUMBER = NVL(l_headerObjectVersionNumber,OBJECT_VERSION_NUMBER),
692: MAX_RCV_TRANSACTION_ID = NVL(l_maxRCVTransactionId,MAX_RCV_TRANSACTION_ID),
693: LAST_UPDATE_DATE = SYSDATE,
694: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
695: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
696: WHERE TRANSACTION_ID = p_headerTransactionId;
697: --
698: IF SQL%ROWCOUNT = 0
699: THEN

Line 6665: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

6661: SET OBJECT_VERSION_NUMBER = NVL(OBJECT_VERSION_NUMBER,0) + 1,
6662: SHIPMENT_NUMBER = l_shipmentNumber,
6663: RECEIPT_NUMBER = l_receiptNumber,
6664: LAST_UPDATE_DATE = SYSDATE,
6665: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
6666: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
6667: WHERE SHIPMENT_HEADER_ID = l_RCVShipmentHeaderId
6668: AND TRANSACTION_TYPE NOT IN ('ROUTING_RESPONSE','ROUTING_REQUEST');
6669: --

Line 6666: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

6662: SHIPMENT_NUMBER = l_shipmentNumber,
6663: RECEIPT_NUMBER = l_receiptNumber,
6664: LAST_UPDATE_DATE = SYSDATE,
6665: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
6666: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
6667: WHERE SHIPMENT_HEADER_ID = l_RCVShipmentHeaderId
6668: AND TRANSACTION_TYPE NOT IN ('ROUTING_RESPONSE','ROUTING_REQUEST');
6669: --
6670: IF SQL%ROWCOUNT = 0

Line 8892: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

8888: MAX_RCV_TRANSACTION_ID = l_maxRCVTransactionId,
8889: SHIPMENT_NUMBER = l_shipmentNumber,
8890: RECEIPT_NUMBER = l_receiptNumber,
8891: LAST_UPDATE_DATE = SYSDATE,
8892: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
8893: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
8894: WHERE TRANSACTION_ID = l_headerTransactionId;
8895: --
8896: IF SQL%ROWCOUNT = 0

Line 8893: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

8889: SHIPMENT_NUMBER = l_shipmentNumber,
8890: RECEIPT_NUMBER = l_receiptNumber,
8891: LAST_UPDATE_DATE = SYSDATE,
8892: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
8893: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
8894: WHERE TRANSACTION_ID = l_headerTransactionId;
8895: --
8896: IF SQL%ROWCOUNT = 0
8897: THEN

Line 8920: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

8916: SET OBJECT_VERSION_NUMBER = NVL(OBJECT_VERSION_NUMBER,0) + 1,
8917: SHIPMENT_NUMBER = l_shipmentNumber,
8918: RECEIPT_NUMBER = l_receiptNumber,
8919: LAST_UPDATE_DATE = SYSDATE,
8920: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
8921: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
8922: WHERE TRANSACTION_ID = l_parentTxnHistoryRec.transaction_id;
8923: --
8924: IF SQL%ROWCOUNT = 0

Line 8921: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

8917: SHIPMENT_NUMBER = l_shipmentNumber,
8918: RECEIPT_NUMBER = l_receiptNumber,
8919: LAST_UPDATE_DATE = SYSDATE,
8920: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
8921: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
8922: WHERE TRANSACTION_ID = l_parentTxnHistoryRec.transaction_id;
8923: --
8924: IF SQL%ROWCOUNT = 0
8925: THEN

Line 10009: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

10005: --
10006: UPDATE WSH_INBOUND_TXN_HISTORY
10007: SET OBJECT_VERSION_NUMBER = NVL(OBJECT_VERSION_NUMBER,0) + 1,
10008: LAST_UPDATE_DATE = SYSDATE,
10009: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
10010: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
10011: WHERE TRANSACTION_ID = l_txnHistoryRec.transaction_id;
10012: --
10013: IF SQL%ROWCOUNT = 0

Line 10010: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

10006: UPDATE WSH_INBOUND_TXN_HISTORY
10007: SET OBJECT_VERSION_NUMBER = NVL(OBJECT_VERSION_NUMBER,0) + 1,
10008: LAST_UPDATE_DATE = SYSDATE,
10009: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
10010: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
10011: WHERE TRANSACTION_ID = l_txnHistoryRec.transaction_id;
10012: --
10013: IF SQL%ROWCOUNT = 0
10014: THEN