DBA Data[Home] [Help]

APPS.WSH_IB_TXN_MATCH_PKG dependencies on FND_MESSAGE

Line 282: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

278: --
279: IF l_fieldName IS NOT NULL
280: THEN
281: --{
282: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
283: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_fieldName);
284: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
285: RAISE FND_API.G_EXC_ERROR;
286: --}

Line 283: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_fieldName);

279: IF l_fieldName IS NOT NULL
280: THEN
281: --{
282: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
283: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_fieldName);
284: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
285: RAISE FND_API.G_EXC_ERROR;
286: --}
287: END IF;

Line 365: -- PARAMETERS: p_startIndex Start Index on FND Message Stack.

361: --
362: --========================================================================
363: -- PROCEDURE : retrieveMessages
364: --
365: -- PARAMETERS: p_startIndex Start Index on FND Message Stack.
366: -- p_endIndex End Index on FND Message Stack.
367: -- x_messageTbl Table of messages(retrieved from stack)
368: -- x_return_status Return status of the API
369: --

Line 366: -- p_endIndex End Index on FND Message Stack.

362: --========================================================================
363: -- PROCEDURE : retrieveMessages
364: --
365: -- PARAMETERS: p_startIndex Start Index on FND Message Stack.
366: -- p_endIndex End Index on FND Message Stack.
367: -- x_messageTbl Table of messages(retrieved from stack)
368: -- x_return_status Return status of the API
369: --
370: --

Line 371: -- COMMENT : It retrieves messages from FND message stack between p_startIndex and p_endIndex.

367: -- x_messageTbl Table of messages(retrieved from stack)
368: -- x_return_status Return status of the API
369: --
370: --
371: -- COMMENT : It retrieves messages from FND message stack between p_startIndex and p_endIndex.
372: -- This procedure is called in the event of matching algorithm failure before raising
373: -- business event. It extracts all messages (which inform the user reasons for failure)
374: -- which will be passed as business event parameter.
375: --========================================================================

Line 567: -- 02. Retrieve all messages from FND message stack

563: -- COMMENT : This procedure is called when matching algorithm fails.
564: -- It performs following steps:
565: --
566: -- 01. Update WSH_INBOUND_TXN_HISTORY status (Manual reconciliation required/Matchec,child pending)
567: -- 02. Retrieve all messages from FND message stack
568: -- 03. Raise business event with following parameters
569: -- - TRANSACTION_TYPE
570: -- - SHIPMENT_HEADER_ID
571: -- - SHIPMENT_NUMBER

Line 700: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');

696: WHERE TRANSACTION_ID = p_headerTransactionId;
697: --
698: IF SQL%ROWCOUNT = 0
699: THEN
700: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');
701: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_headerTransactionId);
702: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
703: RAISE FND_API.G_EXC_ERROR;
704: END IF;

Line 701: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_headerTransactionId);

697: --
698: IF SQL%ROWCOUNT = 0
699: THEN
700: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');
701: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_headerTransactionId);
702: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
703: RAISE FND_API.G_EXC_ERROR;
704: END IF;
705: --

Line 744: FND_MESSAGE.SET_NAME('WSH','WSH_IB_EVENT_KEY_ERROR');

740: CLOSE eventKey_csr;
741: --
742: IF l_eventKey IS NULL
743: THEN
744: FND_MESSAGE.SET_NAME('WSH','WSH_IB_EVENT_KEY_ERROR');
745: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
746: RAISE FND_API.G_EXC_ERROR;
747: END IF;
748: --

Line 808: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_FAILURE');

804: p_parameterList => l_eventParameterList
805: );
806: --
807: --
808: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_FAILURE');
809: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE', p_transactionMeaning);
810: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM', p_receiptNumber);
811: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM', p_shipmentNumber);
812:

Line 809: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE', p_transactionMeaning);

805: );
806: --
807: --
808: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_FAILURE');
809: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE', p_transactionMeaning);
810: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM', p_receiptNumber);
811: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM', p_shipmentNumber);
812:
813: --

Line 810: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM', p_receiptNumber);

806: --
807: --
808: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_FAILURE');
809: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE', p_transactionMeaning);
810: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM', p_receiptNumber);
811: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM', p_shipmentNumber);
812:
813: --
814: -- Debug Statements

Line 811: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM', p_shipmentNumber);

807: --
808: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_FAILURE');
809: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE', p_transactionMeaning);
810: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM', p_receiptNumber);
811: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM', p_shipmentNumber);
812:
813: --
814: -- Debug Statements
815: --

Line 823: p_value => FND_MESSAGE.GET,

819: --
820: WF_EVENT.AddParameterToList
821: (
822: p_name => 'SUMMARY_MESSAGE',
823: p_value => FND_MESSAGE.GET,
824: p_parameterList => l_eventParameterList
825: );
826: --
827: --

Line 1041: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_TXN_TYPE');

1037: END IF;
1038: END IF;
1039: ELSE
1040: --{
1041: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_TXN_TYPE');
1042: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_transactionType);
1043: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1044: RAISE FND_API.G_EXC_ERROR;
1045: --}

Line 1042: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_transactionType);

1038: END IF;
1039: ELSE
1040: --{
1041: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_TXN_TYPE');
1042: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_transactionType);
1043: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1044: RAISE FND_API.G_EXC_ERROR;
1045: --}
1046: END IF;

Line 1628: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DUP_ASN_ERROR');

1624: -- Record already exists in WSH_INBOUND_TXN_HISTORY, raise error
1625: --
1626: IF p_transactionType = WSH_INBOUND_TXN_HISTORY_PKG.C_ASN
1627: THEN
1628: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DUP_ASN_ERROR');
1629: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER',l_txnHistoryRec.SHIPMENT_NUMBER);
1630: ELSIF p_transactionType = WSH_INBOUND_TXN_HISTORY_PKG.C_RECEIPT
1631: THEN
1632: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DUP_RECPT_ERROR');

Line 1629: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER',l_txnHistoryRec.SHIPMENT_NUMBER);

1625: --
1626: IF p_transactionType = WSH_INBOUND_TXN_HISTORY_PKG.C_ASN
1627: THEN
1628: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DUP_ASN_ERROR');
1629: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER',l_txnHistoryRec.SHIPMENT_NUMBER);
1630: ELSIF p_transactionType = WSH_INBOUND_TXN_HISTORY_PKG.C_RECEIPT
1631: THEN
1632: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DUP_RECPT_ERROR');
1633: FND_MESSAGE.SET_TOKEN('RECEIPT_NUMBER',l_txnHistoryRec.RECEIPT_NUMBER);

Line 1632: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DUP_RECPT_ERROR');

1628: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DUP_ASN_ERROR');
1629: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER',l_txnHistoryRec.SHIPMENT_NUMBER);
1630: ELSIF p_transactionType = WSH_INBOUND_TXN_HISTORY_PKG.C_RECEIPT
1631: THEN
1632: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DUP_RECPT_ERROR');
1633: FND_MESSAGE.SET_TOKEN('RECEIPT_NUMBER',l_txnHistoryRec.RECEIPT_NUMBER);
1634: END IF;
1635: --
1636: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 1633: FND_MESSAGE.SET_TOKEN('RECEIPT_NUMBER',l_txnHistoryRec.RECEIPT_NUMBER);

1629: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER',l_txnHistoryRec.SHIPMENT_NUMBER);
1630: ELSIF p_transactionType = WSH_INBOUND_TXN_HISTORY_PKG.C_RECEIPT
1631: THEN
1632: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DUP_RECPT_ERROR');
1633: FND_MESSAGE.SET_TOKEN('RECEIPT_NUMBER',l_txnHistoryRec.RECEIPT_NUMBER);
1634: END IF;
1635: --
1636: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1637: RAISE FND_API.G_EXC_ERROR;

Line 1773: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_TXN_TYPE');

1769: END IF;
1770: --}
1771: ELSE
1772: --{
1773: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_TXN_TYPE');
1774: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_transactionType);
1775: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1776: RAISE FND_API.G_EXC_ERROR;
1777: --}

Line 1774: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_transactionType);

1770: --}
1771: ELSE
1772: --{
1773: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_TXN_TYPE');
1774: FND_MESSAGE.SET_TOKEN('TXN_TYPE',p_transactionType);
1775: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1776: RAISE FND_API.G_EXC_ERROR;
1777: --}
1778: END IF;

Line 1964: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DUP_CANCEL_ASN_ERROR');

1960: --{
1961: IF x_parentTxnHistoryRec.status = WSH_INBOUND_TXN_HISTORY_PKG.C_CANCELLED
1962: THEN
1963: --{
1964: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DUP_CANCEL_ASN_ERROR');
1965: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER',x_parentTxnHistoryRec.SHIPMENT_NUMBER);
1966: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1967: RAISE FND_API.G_EXC_ERROR;
1968: --}

Line 1965: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER',x_parentTxnHistoryRec.SHIPMENT_NUMBER);

1961: IF x_parentTxnHistoryRec.status = WSH_INBOUND_TXN_HISTORY_PKG.C_CANCELLED
1962: THEN
1963: --{
1964: FND_MESSAGE.SET_NAME('WSH','WSH_IB_DUP_CANCEL_ASN_ERROR');
1965: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER',x_parentTxnHistoryRec.SHIPMENT_NUMBER);
1966: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1967: RAISE FND_API.G_EXC_ERROR;
1968: --}
1969: END IF;

Line 2078: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_INVALID_STATUS');

2074: x_num_errors => l_num_errors
2075: );
2076: --
2077: --
2078: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_INVALID_STATUS');
2079: FND_MESSAGE.SET_TOKEN('STATUS_CODE',x_parentTxnHistoryRec.status);
2080: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning);
2081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',x_parentTxnHistoryRec.RECEIPT_NUMBER);
2082: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',x_parentTxnHistoryRec.SHIPMENT_NUMBER);

Line 2079: FND_MESSAGE.SET_TOKEN('STATUS_CODE',x_parentTxnHistoryRec.status);

2075: );
2076: --
2077: --
2078: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_INVALID_STATUS');
2079: FND_MESSAGE.SET_TOKEN('STATUS_CODE',x_parentTxnHistoryRec.status);
2080: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning);
2081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',x_parentTxnHistoryRec.RECEIPT_NUMBER);
2082: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',x_parentTxnHistoryRec.SHIPMENT_NUMBER);
2083: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 2080: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning);

2076: --
2077: --
2078: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_INVALID_STATUS');
2079: FND_MESSAGE.SET_TOKEN('STATUS_CODE',x_parentTxnHistoryRec.status);
2080: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning);
2081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',x_parentTxnHistoryRec.RECEIPT_NUMBER);
2082: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',x_parentTxnHistoryRec.SHIPMENT_NUMBER);
2083: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2084: RAISE FND_API.G_EXC_ERROR;

Line 2081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',x_parentTxnHistoryRec.RECEIPT_NUMBER);

2077: --
2078: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_INVALID_STATUS');
2079: FND_MESSAGE.SET_TOKEN('STATUS_CODE',x_parentTxnHistoryRec.status);
2080: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning);
2081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',x_parentTxnHistoryRec.RECEIPT_NUMBER);
2082: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',x_parentTxnHistoryRec.SHIPMENT_NUMBER);
2083: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2084: RAISE FND_API.G_EXC_ERROR;
2085: --}

Line 2082: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',x_parentTxnHistoryRec.SHIPMENT_NUMBER);

2078: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_INVALID_STATUS');
2079: FND_MESSAGE.SET_TOKEN('STATUS_CODE',x_parentTxnHistoryRec.status);
2080: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning);
2081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',x_parentTxnHistoryRec.RECEIPT_NUMBER);
2082: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',x_parentTxnHistoryRec.SHIPMENT_NUMBER);
2083: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
2084: RAISE FND_API.G_EXC_ERROR;
2085: --}
2086: END IF;

Line 4323: FND_MESSAGE.SET_NAME('WSH','WSH_IB_PO_WDD_LINK_ERROR');

4319: --
4320: --
4321: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
4322: THEN
4323: FND_MESSAGE.SET_NAME('WSH','WSH_IB_PO_WDD_LINK_ERROR');
4324: FND_MESSAGE.SET_TOKEN('KEY',l_key);
4325: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4326: RAISE FND_API.G_EXC_ERROR;
4327: --Should we raise some error insteaD?

Line 4324: FND_MESSAGE.SET_TOKEN('KEY',l_key);

4320: --
4321: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
4322: THEN
4323: FND_MESSAGE.SET_NAME('WSH','WSH_IB_PO_WDD_LINK_ERROR');
4324: FND_MESSAGE.SET_TOKEN('KEY',l_key);
4325: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4326: RAISE FND_API.G_EXC_ERROR;
4327: --Should we raise some error insteaD?
4328: -- This may fail parent txn.....check again

Line 4750: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');

4746: OR x_matchedLineRecTbl.received_qty2_tab(l_lineIndex)
4747: - x_matchedLineRecTbl.returned_qty2_tab(l_lineIndex) < 0
4748: THEN
4749: --{
4750: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');
4751: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
4752: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
4753: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4754: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);

Line 4751: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);

4747: - x_matchedLineRecTbl.returned_qty2_tab(l_lineIndex) < 0
4748: THEN
4749: --{
4750: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');
4751: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
4752: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
4753: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4754: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
4755: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);

Line 4752: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

4748: THEN
4749: --{
4750: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');
4751: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
4752: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
4753: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4754: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
4755: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
4756: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);

Line 4753: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

4749: --{
4750: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');
4751: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
4752: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
4753: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4754: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
4755: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
4756: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
4757: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);

Line 4754: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);

4750: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');
4751: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
4752: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
4753: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4754: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
4755: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
4756: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
4757: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
4758: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 4755: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);

4751: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
4752: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
4753: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4754: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
4755: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
4756: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
4757: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
4758: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4759: --

Line 4756: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);

4752: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
4753: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4754: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
4755: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
4756: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
4757: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
4758: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4759: --
4760: RAISE FND_API.G_EXC_ERROR;

Line 4757: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);

4753: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4754: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
4755: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
4756: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
4757: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
4758: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4759: --
4760: RAISE FND_API.G_EXC_ERROR;
4761: --}

Line 4942: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');

4938: OR x_matchedLineRecTbl.received_qty2_tab(l_lastMatchedLineIndex)
4939: - x_matchedLineRecTbl.returned_qty2_tab(l_lastMatchedLineIndex) < 0
4940: THEN
4941: --{
4942: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');
4943: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
4944: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
4945: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4946: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);

Line 4943: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);

4939: - x_matchedLineRecTbl.returned_qty2_tab(l_lastMatchedLineIndex) < 0
4940: THEN
4941: --{
4942: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');
4943: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
4944: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
4945: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4946: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
4947: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);

Line 4944: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

4940: THEN
4941: --{
4942: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');
4943: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
4944: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
4945: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4946: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
4947: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
4948: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);

Line 4945: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

4941: --{
4942: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');
4943: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
4944: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
4945: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4946: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
4947: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
4948: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
4949: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);

Line 4946: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);

4942: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');
4943: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
4944: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
4945: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4946: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
4947: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
4948: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
4949: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
4950: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 4947: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);

4943: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
4944: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
4945: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4946: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
4947: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
4948: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
4949: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
4950: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4951: --

Line 4948: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);

4944: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
4945: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4946: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
4947: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
4948: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
4949: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
4950: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4951: --
4952: RAISE FND_API.G_EXC_ERROR;

Line 4949: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);

4945: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
4946: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
4947: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
4948: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
4949: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
4950: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4951: --
4952: RAISE FND_API.G_EXC_ERROR;
4953: --}

Line 4957: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_NO_MATCH_ERROR');

4953: --}
4954: END IF;
4955: --}
4956: ELSE
4957: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_NO_MATCH_ERROR');
4958: FND_MESSAGE.SET_TOKEN('KEY',l_key);
4959: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4960: RAISE FND_API.G_EXC_ERROR;
4961: END IF;

Line 4958: FND_MESSAGE.SET_TOKEN('KEY',l_key);

4954: END IF;
4955: --}
4956: ELSE
4957: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_NO_MATCH_ERROR');
4958: FND_MESSAGE.SET_TOKEN('KEY',l_key);
4959: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4960: RAISE FND_API.G_EXC_ERROR;
4961: END IF;
4962: --}

Line 5339: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');

5335: THEN
5336: --{
5337: IF p_putMessages
5338: THEN
5339: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
5340: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
5341: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
5342: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
5343: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 5340: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);

5336: --{
5337: IF p_putMessages
5338: THEN
5339: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
5340: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
5341: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
5342: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
5343: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
5344: END IF;

Line 5341: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

5337: IF p_putMessages
5338: THEN
5339: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
5340: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
5341: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
5342: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
5343: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
5344: END IF;
5345: --

Line 5342: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

5338: THEN
5339: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
5340: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
5341: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
5342: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
5343: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
5344: END IF;
5345: --
5346: RAISE e_notMatched;

Line 5439: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_NOT_EXIST');

5435: --
5436: IF NOT(l_found)
5437: THEN
5438: --{
5439: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_NOT_EXIST');
5440: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',l_deliveryId);
5441: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
5442: RAISE FND_API.G_EXC_ERROR;
5443: --}

Line 5440: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',l_deliveryId);

5436: IF NOT(l_found)
5437: THEN
5438: --{
5439: FND_MESSAGE.SET_NAME('WSH','WSH_DLVY_NOT_EXIST');
5440: FND_MESSAGE.SET_TOKEN('DELIVERY_ID',l_deliveryId);
5441: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
5442: RAISE FND_API.G_EXC_ERROR;
5443: --}
5444: END IF;

Line 5671: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_DATES');

5667: OPEN carrier_csr(l_transactionCarrierId);
5668: FETCH carrier_csr INTO l_carrierName;
5669: CLOSE carrier_csr;
5670: --
5671: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_DATES');
5672: FND_MESSAGE.SET_TOKEN('TXN_DATE',p_transactionDate);
5673: FND_MESSAGE.SET_TOKEN('CARRIER_NAME',l_carrierName);
5674: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
5675: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

Line 5672: FND_MESSAGE.SET_TOKEN('TXN_DATE',p_transactionDate);

5668: FETCH carrier_csr INTO l_carrierName;
5669: CLOSE carrier_csr;
5670: --
5671: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_DATES');
5672: FND_MESSAGE.SET_TOKEN('TXN_DATE',p_transactionDate);
5673: FND_MESSAGE.SET_TOKEN('CARRIER_NAME',l_carrierName);
5674: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
5675: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
5676: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

Line 5673: FND_MESSAGE.SET_TOKEN('CARRIER_NAME',l_carrierName);

5669: CLOSE carrier_csr;
5670: --
5671: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_DATES');
5672: FND_MESSAGE.SET_TOKEN('TXN_DATE',p_transactionDate);
5673: FND_MESSAGE.SET_TOKEN('CARRIER_NAME',l_carrierName);
5674: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
5675: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
5676: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
5677: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);

Line 5674: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);

5670: --
5671: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_DATES');
5672: FND_MESSAGE.SET_TOKEN('TXN_DATE',p_transactionDate);
5673: FND_MESSAGE.SET_TOKEN('CARRIER_NAME',l_carrierName);
5674: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
5675: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
5676: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
5677: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
5678: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);

Line 5675: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

5671: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_DATES');
5672: FND_MESSAGE.SET_TOKEN('TXN_DATE',p_transactionDate);
5673: FND_MESSAGE.SET_TOKEN('CARRIER_NAME',l_carrierName);
5674: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
5675: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
5676: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
5677: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
5678: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
5679: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);

Line 5676: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

5672: FND_MESSAGE.SET_TOKEN('TXN_DATE',p_transactionDate);
5673: FND_MESSAGE.SET_TOKEN('CARRIER_NAME',l_carrierName);
5674: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
5675: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
5676: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
5677: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
5678: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
5679: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
5680: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);

Line 5677: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);

5673: FND_MESSAGE.SET_TOKEN('CARRIER_NAME',l_carrierName);
5674: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
5675: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
5676: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
5677: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
5678: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
5679: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
5680: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
5681: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 5678: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);

5674: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_transactionMeaning); --p_action_prms.action_code);
5675: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
5676: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
5677: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
5678: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
5679: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
5680: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
5681: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
5682: --}

Line 5679: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);

5675: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
5676: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
5677: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
5678: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
5679: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
5680: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
5681: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
5682: --}
5683: END IF;

Line 5680: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);

5676: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
5677: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
5678: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
5679: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
5680: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
5681: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
5682: --}
5683: END IF;
5684: --

Line 6293: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_WSH_LOC');

6289: END IF;
6290:
6291: IF l_trx_wsh_location_id IS NULL
6292: THEN
6293: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_WSH_LOC');
6294: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
6295: RAISE FND_API.G_EXC_ERROR;
6296: END IF;
6297: END IF;

Line 6672: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_HDR_UPD_ERROR');

6668: AND TRANSACTION_TYPE NOT IN ('ROUTING_RESPONSE','ROUTING_REQUEST');
6669: --
6670: IF SQL%ROWCOUNT = 0
6671: THEN
6672: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_HDR_UPD_ERROR');
6673: FND_MESSAGE.SET_TOKEN('SHIPMENT_HEADER_ID',l_RCVShipmentHeaderId);
6674: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
6675: RAISE FND_API.G_EXC_ERROR;
6676: END IF;

Line 6673: FND_MESSAGE.SET_TOKEN('SHIPMENT_HEADER_ID',l_RCVShipmentHeaderId);

6669: --
6670: IF SQL%ROWCOUNT = 0
6671: THEN
6672: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_HDR_UPD_ERROR');
6673: FND_MESSAGE.SET_TOKEN('SHIPMENT_HEADER_ID',l_RCVShipmentHeaderId);
6674: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
6675: RAISE FND_API.G_EXC_ERROR;
6676: END IF;
6677: --

Line 6697: FND_MESSAGE.SET_NAME('WSH','WSH_IB_PENDING_ASN_MATCH');

6693: --{
6694: --
6695: -- Cannot match receipt until parent ASN is matched
6696: --
6697: FND_MESSAGE.SET_NAME('WSH','WSH_IB_PENDING_ASN_MATCH');
6698: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
6699: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
6700: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
6701: --

Line 6698: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

6694: --
6695: -- Cannot match receipt until parent ASN is matched
6696: --
6697: FND_MESSAGE.SET_NAME('WSH','WSH_IB_PENDING_ASN_MATCH');
6698: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
6699: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
6700: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
6701: --
6702: RAISE e_notMatched;

Line 6699: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

6695: -- Cannot match receipt until parent ASN is matched
6696: --
6697: FND_MESSAGE.SET_NAME('WSH','WSH_IB_PENDING_ASN_MATCH');
6698: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
6699: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
6700: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
6701: --
6702: RAISE e_notMatched;
6703: --}

Line 6829: FND_MESSAGE.SET_NAME('WSH','WSH_IB_RSL_NOT_FOUND');

6825: --
6826: IF rcv_line_check_csr%NOTFOUND
6827: THEN
6828: --{
6829: FND_MESSAGE.SET_NAME('WSH','WSH_IB_RSL_NOT_FOUND');
6830: FND_MESSAGE.SET_TOKEN('RCV_SHIPMENT_LINE_ID',p_line_rec.shipment_line_id(l_index));
6831: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
6832: RAISE FND_API.G_EXC_ERROR;
6833: --}

Line 6830: FND_MESSAGE.SET_TOKEN('RCV_SHIPMENT_LINE_ID',p_line_rec.shipment_line_id(l_index));

6826: IF rcv_line_check_csr%NOTFOUND
6827: THEN
6828: --{
6829: FND_MESSAGE.SET_NAME('WSH','WSH_IB_RSL_NOT_FOUND');
6830: FND_MESSAGE.SET_TOKEN('RCV_SHIPMENT_LINE_ID',p_line_rec.shipment_line_id(l_index));
6831: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
6832: RAISE FND_API.G_EXC_ERROR;
6833: --}
6834: END IF;

Line 7130: FND_MESSAGE.SET_NAME('WSH','WSH_IB_PARENT_MULTI_SF_MATCH');

7126: --}
7127: ELSIF l_receiptShipFromLocationCount > 1
7128: THEN
7129: --{
7130: FND_MESSAGE.SET_NAME('WSH','WSH_IB_PARENT_MULTI_SF_MATCH');
7131: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_action_prms.action_code);
7132: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7133: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7134: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 7131: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_action_prms.action_code);

7127: ELSIF l_receiptShipFromLocationCount > 1
7128: THEN
7129: --{
7130: FND_MESSAGE.SET_NAME('WSH','WSH_IB_PARENT_MULTI_SF_MATCH');
7131: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_action_prms.action_code);
7132: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7133: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7134: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
7135: --

Line 7132: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

7128: THEN
7129: --{
7130: FND_MESSAGE.SET_NAME('WSH','WSH_IB_PARENT_MULTI_SF_MATCH');
7131: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_action_prms.action_code);
7132: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7133: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7134: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
7135: --
7136: RAISE e_lineNotMatched;

Line 7133: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

7129: --{
7130: FND_MESSAGE.SET_NAME('WSH','WSH_IB_PARENT_MULTI_SF_MATCH');
7131: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',p_action_prms.action_code);
7132: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7133: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7134: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
7135: --
7136: RAISE e_lineNotMatched;
7137: --}

Line 7269: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_SHP_LINES');

7265: RAISE e_lineNotMatched;
7266: --}
7267: ELSE
7268: --{
7269: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_SHP_LINES');
7270: --
7271: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
7272: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7273: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

Line 7271: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);

7267: ELSE
7268: --{
7269: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_SHP_LINES');
7270: --
7271: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
7272: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7273: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7274: --
7275: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);

Line 7272: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

7268: --{
7269: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_SHP_LINES');
7270: --
7271: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
7272: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7273: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7274: --
7275: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7276: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);

Line 7273: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

7269: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_SHP_LINES');
7270: --
7271: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
7272: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7273: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7274: --
7275: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7276: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7277: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);

Line 7275: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);

7271: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
7272: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7273: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7274: --
7275: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7276: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7277: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
7278: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
7279: --

Line 7276: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);

7272: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7273: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7274: --
7275: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7276: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7277: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
7278: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
7279: --
7280: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 7277: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);

7273: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7274: --
7275: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7276: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7277: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
7278: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
7279: --
7280: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
7281: --

Line 7278: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);

7274: --
7275: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7276: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7277: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
7278: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
7279: --
7280: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
7281: --
7282: RAISE e_NotMatched;

Line 7435: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_PO_LINE_ERROR');

7431: RAISE e_lineNotMatched;
7432: --}
7433: ELSE
7434: --{
7435: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_PO_LINE_ERROR');
7436: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning);
7437: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7438: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7439: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);

Line 7436: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning);

7432: --}
7433: ELSE
7434: --{
7435: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_PO_LINE_ERROR');
7436: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning);
7437: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7438: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7439: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7440: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);

Line 7437: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

7433: ELSE
7434: --{
7435: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_PO_LINE_ERROR');
7436: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning);
7437: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7438: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7439: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7440: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7441: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);

Line 7438: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

7434: --{
7435: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_PO_LINE_ERROR');
7436: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning);
7437: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7438: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7439: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7440: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7441: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
7442: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);

Line 7439: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);

7435: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_PO_LINE_ERROR');
7436: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning);
7437: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7438: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7439: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7440: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7441: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
7442: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
7443: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 7440: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);

7436: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning);
7437: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7438: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7439: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7440: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7441: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
7442: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
7443: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
7444: RAISE FND_API.G_EXC_ERROR;

Line 7441: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);

7437: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7438: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7439: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7440: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7441: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
7442: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
7443: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
7444: RAISE FND_API.G_EXC_ERROR;
7445: --}

Line 7442: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);

7438: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7439: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7440: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7441: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
7442: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
7443: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
7444: RAISE FND_API.G_EXC_ERROR;
7445: --}
7446: END IF;

Line 7579: FND_MESSAGE.SET_NAME('WSH',l_messageName);

7575: IF l_ReceiptAgainstASN = 'Y'
7576: AND l_transactionType = WSH_INBOUND_TXN_HISTORY_PKG.C_RECEIPT
7577: THEN
7578: --{
7579: FND_MESSAGE.SET_NAME('WSH',l_messageName);
7580: --
7581: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
7582: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7583: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

Line 7581: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);

7577: THEN
7578: --{
7579: FND_MESSAGE.SET_NAME('WSH',l_messageName);
7580: --
7581: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
7582: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7583: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7584: --
7585: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);

Line 7582: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

7578: --{
7579: FND_MESSAGE.SET_NAME('WSH',l_messageName);
7580: --
7581: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
7582: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7583: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7584: --
7585: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7586: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);

Line 7583: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

7579: FND_MESSAGE.SET_NAME('WSH',l_messageName);
7580: --
7581: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
7582: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7583: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7584: --
7585: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7586: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7587: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);

Line 7585: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);

7581: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
7582: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7583: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7584: --
7585: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7586: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7587: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
7588: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
7589: --

Line 7586: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);

7582: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7583: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7584: --
7585: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7586: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7587: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
7588: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
7589: --
7590: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 7587: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);

7583: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7584: --
7585: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7586: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7587: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
7588: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
7589: --
7590: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
7591: --

Line 7588: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);

7584: --
7585: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
7586: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
7587: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
7588: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
7589: --
7590: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
7591: --
7592: RAISE e_NotMatched;

Line 7979: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');

7975: ELSIF l_lineUniqueSFLocnId <> WSH_UTIL_CORE.C_NULL_SF_LOCN_ID
7976: AND l_lineUniqueSFLocnId <> l_txnUniqueSFLocnId
7977: THEN
7978: --{
7979: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
7980: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
7981: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7982: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7983: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);

Line 7980: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);

7976: AND l_lineUniqueSFLocnId <> l_txnUniqueSFLocnId
7977: THEN
7978: --{
7979: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
7980: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
7981: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7982: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7983: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
7984: RAISE e_notMatched;

Line 7981: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

7977: THEN
7978: --{
7979: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
7980: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
7981: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7982: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7983: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
7984: RAISE e_notMatched;
7985: --}

Line 7982: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

7978: --{
7979: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
7980: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
7981: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
7982: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
7983: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
7984: RAISE e_notMatched;
7985: --}
7986: END IF;

Line 8078: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_SF_LOCN');

8074: l_messageName := 'WSH_IB_NOT_MATCH_SF_LOCN';
8075: RAISE e_lineNotMatched;
8076: ELSE
8077: --{
8078: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_SF_LOCN');
8079: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8080: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8082: FND_MESSAGE.SET_TOKEN('SHIP_FROM_LOCATION',l_txnUniqueSFLocnCode);

Line 8079: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);

8075: RAISE e_lineNotMatched;
8076: ELSE
8077: --{
8078: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_SF_LOCN');
8079: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8080: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8082: FND_MESSAGE.SET_TOKEN('SHIP_FROM_LOCATION',l_txnUniqueSFLocnCode);
8083: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);

Line 8080: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

8076: ELSE
8077: --{
8078: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_SF_LOCN');
8079: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8080: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8082: FND_MESSAGE.SET_TOKEN('SHIP_FROM_LOCATION',l_txnUniqueSFLocnCode);
8083: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
8084: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);

Line 8081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

8077: --{
8078: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_SF_LOCN');
8079: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8080: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8082: FND_MESSAGE.SET_TOKEN('SHIP_FROM_LOCATION',l_txnUniqueSFLocnCode);
8083: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
8084: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
8085: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);

Line 8082: FND_MESSAGE.SET_TOKEN('SHIP_FROM_LOCATION',l_txnUniqueSFLocnCode);

8078: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_MATCH_SF_LOCN');
8079: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8080: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8082: FND_MESSAGE.SET_TOKEN('SHIP_FROM_LOCATION',l_txnUniqueSFLocnCode);
8083: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
8084: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
8085: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
8086: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);

Line 8083: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);

8079: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8080: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8082: FND_MESSAGE.SET_TOKEN('SHIP_FROM_LOCATION',l_txnUniqueSFLocnCode);
8083: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
8084: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
8085: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
8086: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
8087: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 8084: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);

8080: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8082: FND_MESSAGE.SET_TOKEN('SHIP_FROM_LOCATION',l_txnUniqueSFLocnCode);
8083: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
8084: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
8085: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
8086: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
8087: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8088: --

Line 8085: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);

8081: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8082: FND_MESSAGE.SET_TOKEN('SHIP_FROM_LOCATION',l_txnUniqueSFLocnCode);
8083: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
8084: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
8085: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
8086: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
8087: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8088: --
8089: RAISE e_notMatched;

Line 8086: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);

8082: FND_MESSAGE.SET_TOKEN('SHIP_FROM_LOCATION',l_txnUniqueSFLocnCode);
8083: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
8084: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
8085: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
8086: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
8087: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8088: --
8089: RAISE e_notMatched;
8090: --}

Line 8269: --FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');

8265: --
8266: IF l_messageName IS NOT NULL
8267: THEN
8268: --{
8269: --FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');
8270: FND_MESSAGE.SET_NAME('WSH',l_messageName);
8271: --
8272: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8273: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

Line 8270: FND_MESSAGE.SET_NAME('WSH',l_messageName);

8266: IF l_messageName IS NOT NULL
8267: THEN
8268: --{
8269: --FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');
8270: FND_MESSAGE.SET_NAME('WSH',l_messageName);
8271: --
8272: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8273: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8274: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

Line 8272: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);

8268: --{
8269: --FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');
8270: FND_MESSAGE.SET_NAME('WSH',l_messageName);
8271: --
8272: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8273: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8274: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8275: --
8276: IF l_messageName IN (

Line 8273: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

8269: --FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_LINE_FATAL_ERROR');
8270: FND_MESSAGE.SET_NAME('WSH',l_messageName);
8271: --
8272: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8273: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8274: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8275: --
8276: IF l_messageName IN (
8277: 'WSH_IB_PEND_PARENT_TXN_MATCH',

Line 8274: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

8270: FND_MESSAGE.SET_NAME('WSH',l_messageName);
8271: --
8272: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8273: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8274: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8275: --
8276: IF l_messageName IN (
8277: 'WSH_IB_PEND_PARENT_TXN_MATCH',
8278: 'WSH_IB_PEND_PARENT_LINE_MATCH',

Line 8288: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);

8284: 'WSH_IB_NOT_MATCH_SHP_LINES'
8285: )
8286: THEN
8287: --{
8288: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
8289: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
8290: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
8291: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
8292: --}

Line 8289: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);

8285: )
8286: THEN
8287: --{
8288: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
8289: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
8290: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
8291: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
8292: --}
8293: END IF;

Line 8290: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);

8286: THEN
8287: --{
8288: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
8289: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
8290: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
8291: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
8292: --}
8293: END IF;
8294: --

Line 8291: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);

8287: --{
8288: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_poHeaderNumber);
8289: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM',l_poLineNumber);
8290: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM',l_poShipmentLineNumber);
8291: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_poReleaseNumber);
8292: --}
8293: END IF;
8294: --
8295: --

Line 8298: FND_MESSAGE.SET_TOKEN('SHIP_FROM_LOCATION',l_txnUniqueSFLocnCode);

8294: --
8295: --
8296: IF l_messageName = 'WSH_IB_NOT_MATCH_SF_LOCN'
8297: THEN
8298: FND_MESSAGE.SET_TOKEN('SHIP_FROM_LOCATION',l_txnUniqueSFLocnCode);
8299: END IF;
8300: --
8301: --
8302: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 8586: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');

8582: --}
8583: ELSIF NOT(l_txnUniqueSFLocnFound)
8584: THEN
8585: --{
8586: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
8587: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8588: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8589: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8590: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);

Line 8587: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);

8583: ELSIF NOT(l_txnUniqueSFLocnFound)
8584: THEN
8585: --{
8586: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
8587: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8588: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8589: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8590: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
8591: RAISE e_notMatched;

Line 8588: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

8584: THEN
8585: --{
8586: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
8587: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8588: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8589: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8590: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
8591: RAISE e_notMatched;
8592: --}

Line 8589: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

8585: --{
8586: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
8587: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8588: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8589: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8590: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
8591: RAISE e_notMatched;
8592: --}
8593: END IF;

Line 8659: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');

8655: --
8656: IF NOT(l_txnUniqueSFLocnFound)
8657: THEN
8658: --{
8659: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
8660: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8661: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8662: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8663: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);

Line 8660: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);

8656: IF NOT(l_txnUniqueSFLocnFound)
8657: THEN
8658: --{
8659: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
8660: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8661: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8662: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8663: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
8664: RAISE e_notMatched;

Line 8661: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

8657: THEN
8658: --{
8659: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
8660: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8661: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8662: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8663: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
8664: RAISE e_notMatched;
8665: --}

Line 8662: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

8658: --{
8659: FND_MESSAGE.SET_NAME('WSH','WSH_IB_NOT_UNIQUE_SF_LOCN');
8660: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE',l_transactionMeaning); --p_action_prms.action_code);
8661: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
8662: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
8663: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
8664: RAISE e_notMatched;
8665: --}
8666: END IF;

Line 8898: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');

8894: WHERE TRANSACTION_ID = l_headerTransactionId;
8895: --
8896: IF SQL%ROWCOUNT = 0
8897: THEN
8898: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');
8899: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',l_headerTransactionId);
8900: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8901: RAISE FND_API.G_EXC_ERROR;
8902: END IF;

Line 8899: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',l_headerTransactionId);

8895: --
8896: IF SQL%ROWCOUNT = 0
8897: THEN
8898: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');
8899: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',l_headerTransactionId);
8900: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8901: RAISE FND_API.G_EXC_ERROR;
8902: END IF;
8903: --

Line 8926: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');

8922: WHERE TRANSACTION_ID = l_parentTxnHistoryRec.transaction_id;
8923: --
8924: IF SQL%ROWCOUNT = 0
8925: THEN
8926: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');
8927: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',l_parentTxnHistoryRec.transaction_id);
8928: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8929: RAISE FND_API.G_EXC_ERROR;
8930: END IF;

Line 8927: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',l_parentTxnHistoryRec.transaction_id);

8923: --
8924: IF SQL%ROWCOUNT = 0
8925: THEN
8926: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');
8927: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',l_parentTxnHistoryRec.transaction_id);
8928: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
8929: RAISE FND_API.G_EXC_ERROR;
8930: END IF;
8931: --}

Line 9116: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_FATAL_ERROR');

9112:
9113: WHEN e_fatalError THEN
9114: ROLLBACK TO matchTransaction_sp;
9115: --
9116: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_FATAL_ERROR');
9117: FND_MESSAGE.SET_TOKEN('TRANSACTION_CODE',p_action_prms.action_code);
9118: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
9119: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
9120: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 9117: FND_MESSAGE.SET_TOKEN('TRANSACTION_CODE',p_action_prms.action_code);

9113: WHEN e_fatalError THEN
9114: ROLLBACK TO matchTransaction_sp;
9115: --
9116: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_FATAL_ERROR');
9117: FND_MESSAGE.SET_TOKEN('TRANSACTION_CODE',p_action_prms.action_code);
9118: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
9119: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
9120: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
9121: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 9118: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);

9114: ROLLBACK TO matchTransaction_sp;
9115: --
9116: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_FATAL_ERROR');
9117: FND_MESSAGE.SET_TOKEN('TRANSACTION_CODE',p_action_prms.action_code);
9118: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
9119: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
9120: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
9121: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9122: */

Line 9119: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);

9115: --
9116: FND_MESSAGE.SET_NAME('WSH','WSH_IB_MATCH_FATAL_ERROR');
9117: FND_MESSAGE.SET_TOKEN('TRANSACTION_CODE',p_action_prms.action_code);
9118: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUM',l_shipmentNumber);
9119: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM',l_receiptNumber);
9120: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
9121: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9122: */
9123: --

Line 10015: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');

10011: WHERE TRANSACTION_ID = l_txnHistoryRec.transaction_id;
10012: --
10013: IF SQL%ROWCOUNT = 0
10014: THEN
10015: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');
10016: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',l_txnHistoryRec.transaction_id);
10017: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
10018: RAISE FND_API.G_EXC_ERROR;
10019: END IF;

Line 10016: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',l_txnHistoryRec.transaction_id);

10012: --
10013: IF SQL%ROWCOUNT = 0
10014: THEN
10015: FND_MESSAGE.SET_NAME('WSH','WSH_IB_TXN_UPDATE_ERROR');
10016: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',l_txnHistoryRec.transaction_id);
10017: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
10018: RAISE FND_API.G_EXC_ERROR;
10019: END IF;
10020: --}