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_SHIPMENT_REQUEST_PUB dependencies on FND_MESSAGE

Line 208: fnd_message.set_name('WSH', 'WSH_STND_ATTR_MANDATORY');

204: l_invalid_inputs := 0;
205: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
206: IF p_shipment_request_info.Document_Number IS NULL OR p_shipment_request_info.Document_REVISION is NULL THEN
207: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
208: fnd_message.set_name('WSH', 'WSH_STND_ATTR_MANDATORY');
209: fnd_message.set_token('ATTRIBUTE','DOCUMENT_NUMBER and DOCUMENT_REVISION');
210: wsh_util_core.add_message(x_return_status);
211:
212: IF l_debug_on THEN

Line 209: fnd_message.set_token('ATTRIBUTE','DOCUMENT_NUMBER and DOCUMENT_REVISION');

205: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
206: IF p_shipment_request_info.Document_Number IS NULL OR p_shipment_request_info.Document_REVISION is NULL THEN
207: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
208: fnd_message.set_name('WSH', 'WSH_STND_ATTR_MANDATORY');
209: fnd_message.set_token('ATTRIBUTE','DOCUMENT_NUMBER and DOCUMENT_REVISION');
210: wsh_util_core.add_message(x_return_status);
211:
212: IF l_debug_on THEN
213: WSH_DEBUG_SV.log(l_module_name, 'Mandatory input parameters have not been passed');

Line 220: fnd_message.set_name('WSH', 'WSH_STND_POSITIVE_INTEGER');

216:
217: IF p_shipment_request_info.Document_Number <= 0 OR
218: p_shipment_request_info.Document_Number <> trunc(p_shipment_request_info.Document_Number) THEN
219: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
220: fnd_message.set_name('WSH', 'WSH_STND_POSITIVE_INTEGER');
221: fnd_message.set_token('ATTRIBUTE', 'DOCUMENT_NUMBER');
222: wsh_util_core.add_message(x_return_status);
223:
224: l_invalid_inputs := 1;

Line 221: fnd_message.set_token('ATTRIBUTE', 'DOCUMENT_NUMBER');

217: IF p_shipment_request_info.Document_Number <= 0 OR
218: p_shipment_request_info.Document_Number <> trunc(p_shipment_request_info.Document_Number) THEN
219: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
220: fnd_message.set_name('WSH', 'WSH_STND_POSITIVE_INTEGER');
221: fnd_message.set_token('ATTRIBUTE', 'DOCUMENT_NUMBER');
222: wsh_util_core.add_message(x_return_status);
223:
224: l_invalid_inputs := 1;
225: END IF;

Line 229: fnd_message.set_name('WSH', 'WSH_STND_POSITIVE_INTEGER');

225: END IF;
226: IF p_shipment_request_info.Document_revision <= 0 OR
227: p_shipment_request_info.Document_revision <> trunc(p_shipment_request_info.Document_revision ) THEN
228: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
229: fnd_message.set_name('WSH', 'WSH_STND_POSITIVE_INTEGER');
230: fnd_message.set_token('ATTRIBUTE', 'DOCUMENT_REVISION');
231: wsh_util_core.add_message(x_return_status);
232:
233: l_invalid_inputs := 1;

Line 230: fnd_message.set_token('ATTRIBUTE', 'DOCUMENT_REVISION');

226: IF p_shipment_request_info.Document_revision <= 0 OR
227: p_shipment_request_info.Document_revision <> trunc(p_shipment_request_info.Document_revision ) THEN
228: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
229: fnd_message.set_name('WSH', 'WSH_STND_POSITIVE_INTEGER');
230: fnd_message.set_token('ATTRIBUTE', 'DOCUMENT_REVISION');
231: wsh_util_core.add_message(x_return_status);
232:
233: l_invalid_inputs := 1;
234: END IF;

Line 238: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');

234: END IF;
235:
236: IF p_shipment_request_info.ACTION_TYPE NOT IN ('A','C','D') THEN
237: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
238: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
239: fnd_message.set_token('ATTRIBUTE', 'ACTION_TYPE');
240: wsh_util_core.add_message(x_return_status);
241: IF l_debug_on THEN
242: WSH_DEBUG_SV.log(l_module_name,'Action Type should be A or C or D. Action type',p_shipment_request_info.ACTION_TYPE);

Line 239: fnd_message.set_token('ATTRIBUTE', 'ACTION_TYPE');

235:
236: IF p_shipment_request_info.ACTION_TYPE NOT IN ('A','C','D') THEN
237: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
238: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
239: fnd_message.set_token('ATTRIBUTE', 'ACTION_TYPE');
240: wsh_util_core.add_message(x_return_status);
241: IF l_debug_on THEN
242: WSH_DEBUG_SV.log(l_module_name,'Action Type should be A or C or D. Action type',p_shipment_request_info.ACTION_TYPE);
243: END IF;

Line 306: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_ACTION');

302: RAISE FND_API.G_EXC_ERROR;
303: END IF;
304: ELSE
305: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
306: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_ACTION');
307: fnd_message.set_token('ACTION_CODE', p_action_code);
308: wsh_util_core.add_message(x_return_status);
309: IF l_debug_on THEN
310: WSH_DEBUG_SV.log(l_module_name, 'p_action_code should be CREATE/QUERY/UPDATE/DELETE.The current value is',p_action_code);

Line 307: fnd_message.set_token('ACTION_CODE', p_action_code);

303: END IF;
304: ELSE
305: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
306: fnd_message.set_name('WSH', 'WSH_PUB_INVALID_ACTION');
307: fnd_message.set_token('ACTION_CODE', p_action_code);
308: wsh_util_core.add_message(x_return_status);
309: IF l_debug_on THEN
310: WSH_DEBUG_SV.log(l_module_name, 'p_action_code should be CREATE/QUERY/UPDATE/DELETE.The current value is',p_action_code);
311: END IF;

Line 479: FND_MESSAGE.Set_Name('WSH', 'WSH_SUCCESS_PROCESS');

475: x_return_status => l_return_status );
476:
477:
478: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
479: FND_MESSAGE.Set_Name('WSH', 'WSH_SUCCESS_PROCESS');
480: WSH_UTIL_CORE.Add_Message(l_return_status);
481: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
482: x_return_status := l_return_status;
483: fnd_msg_pub.count_and_get( p_encoded => 'F'

Line 493: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_SR_PROCESS_ERROR');

489: WSH_DEBUG_SV.logmsg(l_module_name, 'Process_Shipment_Request completed with error');
490: END IF;
491: --
492: x_return_status := l_return_status;
493: FND_MESSAGE.Set_Name('WSH', 'WSH_STND_SR_PROCESS_ERROR');
494: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
495: raise FND_API.G_EXC_ERROR;
496: END IF;
497:

Line 528: FND_MESSAGE.Set_Name('WSH', 'WSH_REQUEST_SUBMITTED');

524: IF (nvl(x_request_id,0) <= 0) THEN
525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
526: raise FND_API.G_EXC_ERROR;
527: ELSE
528: FND_MESSAGE.Set_Name('WSH', 'WSH_REQUEST_SUBMITTED');
529: FND_MESSAGE.Set_Token('REQUEST_ID', x_request_id);
530: WSH_UTIL_CORE.Add_Message(x_return_status);
531: END IF;
532: ELSE

Line 529: FND_MESSAGE.Set_Token('REQUEST_ID', x_request_id);

525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
526: raise FND_API.G_EXC_ERROR;
527: ELSE
528: FND_MESSAGE.Set_Name('WSH', 'WSH_REQUEST_SUBMITTED');
529: FND_MESSAGE.Set_Token('REQUEST_ID', x_request_id);
530: WSH_UTIL_CORE.Add_Message(x_return_status);
531: END IF;
532: ELSE
533: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 534: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');

530: WSH_UTIL_CORE.Add_Message(x_return_status);
531: END IF;
532: ELSE
533: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
534: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
535: fnd_message.set_token('ATTRIBUTE', 'PROCESS_MODE');
536: wsh_util_core.add_message(x_return_status);
537: IF l_debug_on THEN
538: WSH_DEBUG_SV.logmsg(l_module_name, 'p_process_mode should be ONLINE/CONCURRENT');

Line 535: fnd_message.set_token('ATTRIBUTE', 'PROCESS_MODE');

531: END IF;
532: ELSE
533: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
534: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
535: fnd_message.set_token('ATTRIBUTE', 'PROCESS_MODE');
536: wsh_util_core.add_message(x_return_status);
537: IF l_debug_on THEN
538: WSH_DEBUG_SV.logmsg(l_module_name, 'p_process_mode should be ONLINE/CONCURRENT');
539: END IF;

Line 665: fnd_message.set_name('WSH', 'WSH_STND_DUP_DOCUMENT');

661: AND document_direction = 'I';
662:
663: if l_exists >0 THEN
664: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
665: fnd_message.set_name('WSH', 'WSH_STND_DUP_DOCUMENT');
666: fnd_message.set_token('DOCUMENT_NUMBER', p_shipment_request_info.document_number);
667: fnd_message.set_token('DOCUMENT_REVISION', p_shipment_request_info.document_revision);
668: wsh_util_core.add_message(x_return_status);
669: IF l_debug_on THEN

Line 666: fnd_message.set_token('DOCUMENT_NUMBER', p_shipment_request_info.document_number);

662:
663: if l_exists >0 THEN
664: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
665: fnd_message.set_name('WSH', 'WSH_STND_DUP_DOCUMENT');
666: fnd_message.set_token('DOCUMENT_NUMBER', p_shipment_request_info.document_number);
667: fnd_message.set_token('DOCUMENT_REVISION', p_shipment_request_info.document_revision);
668: wsh_util_core.add_message(x_return_status);
669: IF l_debug_on THEN
670: wsh_debug_sv.logmsg(l_module_name, 'The document already exists');

Line 667: fnd_message.set_token('DOCUMENT_REVISION', p_shipment_request_info.document_revision);

663: if l_exists >0 THEN
664: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
665: fnd_message.set_name('WSH', 'WSH_STND_DUP_DOCUMENT');
666: fnd_message.set_token('DOCUMENT_NUMBER', p_shipment_request_info.document_number);
667: fnd_message.set_token('DOCUMENT_REVISION', p_shipment_request_info.document_revision);
668: wsh_util_core.add_message(x_return_status);
669: IF l_debug_on THEN
670: wsh_debug_sv.logmsg(l_module_name, 'The document already exists');
671: END IF;

Line 1457: fnd_message.set_name('WSH', 'WSH_STND_INVALID_DOC');

1453: p_shipment_request_info.client_code; -- LSP PROJECT
1454:
1455: IF c_get_WTH_WNDI_Rec%NOTFOUND THEN
1456: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1457: fnd_message.set_name('WSH', 'WSH_STND_INVALID_DOC');
1458: fnd_message.set_token('DOCUMENT_NUMBER', p_shipment_request_info.document_number);
1459: fnd_message.set_token('DOCUMENT_REVISION', p_shipment_request_info.document_revision);
1460: wsh_util_core.add_message(x_return_status);
1461:

Line 1458: fnd_message.set_token('DOCUMENT_NUMBER', p_shipment_request_info.document_number);

1454:
1455: IF c_get_WTH_WNDI_Rec%NOTFOUND THEN
1456: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1457: fnd_message.set_name('WSH', 'WSH_STND_INVALID_DOC');
1458: fnd_message.set_token('DOCUMENT_NUMBER', p_shipment_request_info.document_number);
1459: fnd_message.set_token('DOCUMENT_REVISION', p_shipment_request_info.document_revision);
1460: wsh_util_core.add_message(x_return_status);
1461:
1462: IF l_debug_on THEN

Line 1459: fnd_message.set_token('DOCUMENT_REVISION', p_shipment_request_info.document_revision);

1455: IF c_get_WTH_WNDI_Rec%NOTFOUND THEN
1456: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1457: fnd_message.set_name('WSH', 'WSH_STND_INVALID_DOC');
1458: fnd_message.set_token('DOCUMENT_NUMBER', p_shipment_request_info.document_number);
1459: fnd_message.set_token('DOCUMENT_REVISION', p_shipment_request_info.document_revision);
1460: wsh_util_core.add_message(x_return_status);
1461:
1462: IF l_debug_on THEN
1463: WSH_DEBUG_SV.log(l_module_name, 'No Data found');

Line 1683: fnd_message.set_name('WSH', 'WSH_STND_INVALID_DOC');

1679: OPEN c_get_Details_DN;
1680: FETCH c_get_Details_DN INTO l_document_number,l_document_revision,l_delivery_interface_id,l_transaction_id;
1681: IF c_get_Details_DN%NOTFOUND THEN
1682: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1683: fnd_message.set_name('WSH', 'WSH_STND_INVALID_DOC');
1684: fnd_message.set_token('DOCUMENT_NUMBER', p_shipment_request_info.document_number);
1685: fnd_message.set_token('DOCUMENT_REVISION', p_shipment_request_info.document_revision);
1686: wsh_util_core.add_message(x_return_status);
1687: IF l_debug_on THEN

Line 1684: fnd_message.set_token('DOCUMENT_NUMBER', p_shipment_request_info.document_number);

1680: FETCH c_get_Details_DN INTO l_document_number,l_document_revision,l_delivery_interface_id,l_transaction_id;
1681: IF c_get_Details_DN%NOTFOUND THEN
1682: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1683: fnd_message.set_name('WSH', 'WSH_STND_INVALID_DOC');
1684: fnd_message.set_token('DOCUMENT_NUMBER', p_shipment_request_info.document_number);
1685: fnd_message.set_token('DOCUMENT_REVISION', p_shipment_request_info.document_revision);
1686: wsh_util_core.add_message(x_return_status);
1687: IF l_debug_on THEN
1688: wsh_debug_sv.logmsg(l_module_name, 'Invalid parameters have been passed');

Line 1685: fnd_message.set_token('DOCUMENT_REVISION', p_shipment_request_info.document_revision);

1681: IF c_get_Details_DN%NOTFOUND THEN
1682: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1683: fnd_message.set_name('WSH', 'WSH_STND_INVALID_DOC');
1684: fnd_message.set_token('DOCUMENT_NUMBER', p_shipment_request_info.document_number);
1685: fnd_message.set_token('DOCUMENT_REVISION', p_shipment_request_info.document_revision);
1686: wsh_util_core.add_message(x_return_status);
1687: IF l_debug_on THEN
1688: wsh_debug_sv.logmsg(l_module_name, 'Invalid parameters have been passed');
1689: END IF;

Line 1709: fnd_message.set_name('WSH', 'WSH_STND_ATTR_MANDATORY');

1705:
1706: IF p_shipment_request_info.shipment_details_tab(i).line_number IS NULL THEN
1707:
1708: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1709: fnd_message.set_name('WSH', 'WSH_STND_ATTR_MANDATORY');
1710: fnd_message.set_token('ATTRIBUTE','LINE_NUMBER');
1711: wsh_util_core.add_message(x_return_status);
1712: IF l_debug_on THEN
1713: wsh_debug_sv.logmsg(l_module_name, 'Line number is a mandatory parameter for delivery_detail_interface records');

Line 1710: fnd_message.set_token('ATTRIBUTE','LINE_NUMBER');

1706: IF p_shipment_request_info.shipment_details_tab(i).line_number IS NULL THEN
1707:
1708: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1709: fnd_message.set_name('WSH', 'WSH_STND_ATTR_MANDATORY');
1710: fnd_message.set_token('ATTRIBUTE','LINE_NUMBER');
1711: wsh_util_core.add_message(x_return_status);
1712: IF l_debug_on THEN
1713: wsh_debug_sv.logmsg(l_module_name, 'Line number is a mandatory parameter for delivery_detail_interface records');
1714: END IF;

Line 1738: fnd_message.set_name('WSH', 'WSH_STND_INVALID_DOC_LINE');

1734: wsh_debug_sv.logmsg(l_module_name, 'Error: Line number ' || p_shipment_request_info.shipment_details_tab(i).line_number || ' does not exist');
1735: END IF;
1736: --
1737: l_tmp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1738: fnd_message.set_name('WSH', 'WSH_STND_INVALID_DOC_LINE');
1739: fnd_message.set_token('LINE_NUMBER', p_shipment_request_info.shipment_details_tab(i).line_number);
1740: wsh_util_core.add_message(l_tmp_status);
1741: END IF;
1742: ELSE

Line 1739: fnd_message.set_token('LINE_NUMBER', p_shipment_request_info.shipment_details_tab(i).line_number);

1735: END IF;
1736: --
1737: l_tmp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1738: fnd_message.set_name('WSH', 'WSH_STND_INVALID_DOC_LINE');
1739: fnd_message.set_token('LINE_NUMBER', p_shipment_request_info.shipment_details_tab(i).line_number);
1740: wsh_util_core.add_message(l_tmp_status);
1741: END IF;
1742: ELSE
1743: l_update_sr_info.shipment_details_tab(l_upd_count):= p_shipment_request_info.shipment_details_tab(i);

Line 2114: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');

2110: END IF;
2111: EXCEPTION
2112: WHEN RECORD_LOCKED THEN
2113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2114: FND_MESSAGE.SET_NAME('WSH','WSH_NO_LOCK');
2115: IF l_debug_on THEN
2116: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
2117: END IF;
2118: rollback;