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_API

Line 31: -- p_init_msg_list FND_API.G_TRUE to reset list

27: --========================================================================
28: -- PROCEDURE : Shipment_Request PUBLIC
29: --
30: -- PARAMETERS: p_api_version_number known api version
31: -- p_init_msg_list FND_API.G_TRUE to reset list
32: -- p_action_code 'QUERY', 'CREATE', 'UPDATE' or 'DELETE'
33: -- p_shipment_request_info Attributes for the shipment request entity
34: -- The attributes Documnet_number document revision are
35: -- mandatory parameters in all the cases.

Line 78: IF NOT FND_API.Compatible_API_Call

74: IF l_debug_on THEN
75: wsh_debug_sv.push(l_module_name);
76: END IF;
77: -- Standard call to check for call compatibility
78: IF NOT FND_API.Compatible_API_Call
79: ( l_api_version_number
80: , p_api_version_number
81: , l_api_name
82: , G_PKG_NAME

Line 85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

81: , l_api_name
82: , G_PKG_NAME
83: )
84: THEN
85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87:
88: -- Initialize message stack if required
89: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 89: IF FND_API.to_Boolean(p_init_msg_list) THEN

85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87:
88: -- Initialize message stack if required
89: IF FND_API.to_Boolean(p_init_msg_list) THEN
90: FND_MSG_PUB.initialize;
91: END IF;
92:
93: --

Line 248: RAISE FND_API.G_EXC_ERROR;

244: l_invalid_inputs := 1;
245: END IF;
246:
247: IF l_invalid_inputs = 1 THEN
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250:
251: IF p_action_code = 'CREATE' THEN
252: --

Line 266: RAISE FND_API.G_EXC_ERROR;

262: IF l_debug_on THEN
263: WSH_DEBUG_SV.logmsg(l_module_name, 'The Action '||p_action_code||' failed');
264: END IF;
265: x_return_status := l_return_status;
266: RAISE FND_API.G_EXC_ERROR;
267: END IF;
268:
269:
270: ELSIF p_action_code = 'QUERY' THEN

Line 284: RAISE FND_API.G_EXC_ERROR;

280: IF l_debug_on THEN
281: WSH_DEBUG_SV.logmsg(l_module_name, 'The Action '||p_action_code||' failed');
282: END IF;
283: x_return_status := l_return_status;
284: RAISE FND_API.G_EXC_ERROR;
285: END IF;
286:
287: ELSIF p_action_code = 'UPDATE' OR p_action_code ='DELETE' THEN
288: --

Line 302: RAISE FND_API.G_EXC_ERROR;

298: IF l_debug_on THEN
299: WSH_DEBUG_SV.logmsg(l_module_name, 'The Action '||p_action_code||' failed');
300: END IF;
301: x_return_status := l_return_status;
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');

Line 312: RAISE FND_API.G_EXC_ERROR;

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;
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314:
315: IF p_commit = FND_API.G_TRUE THEN
316: COMMIT;

Line 315: IF p_commit = FND_API.G_TRUE THEN

311: END IF;
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314:
315: IF p_commit = FND_API.G_TRUE THEN
316: COMMIT;
317: END IF;
318:
319: --

Line 326: WHEN FND_API.G_EXC_ERROR THEN

322: WSH_DEBUG_SV.pop(l_module_name);
323: END IF;
324: --
325: EXCEPTION
326: WHEN FND_API.G_EXC_ERROR THEN
327: p_shipment_request_info.delivery_interface_id := NULL;
328: p_shipment_request_info.transaction_id := null;
329: IF p_shipment_request_info.shipment_details_tab.count >0 THEN
330: FOR i in 1..p_shipment_request_info.shipment_details_tab.count LOOP

Line 336: p_encoded => fnd_api.g_false);

332: END LOOP;
333: END IF;
334: fnd_msg_pub.count_and_get(p_count => x_msg_count,
335: p_data => x_msg_data,
336: p_encoded => fnd_api.g_false);
337: IF l_debug_on THEN
338: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
339: END IF;
340: rollback;

Line 343: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');

339: END IF;
340: rollback;
341: IF l_debug_on THEN
342: WSH_DEBUG_SV.log(l_module_name, 'Error performing the action '''|| p_action_code ||''' on Document_Number',p_shipment_request_info.Document_Number);
343: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');
344: END IF;
345: WHEN others THEN
346: p_shipment_request_info.delivery_interface_id := NULL;
347: p_shipment_request_info.transaction_id := null;

Line 359: p_encoded => fnd_api.g_false);

355: END IF;
356: rollback;
357: fnd_msg_pub.count_and_get(p_count => x_msg_count,
358: p_data => x_msg_data,
359: p_encoded => fnd_api.g_false);
360: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
361: IF l_debug_on THEN
362: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
363: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 371: -- p_init_msg_list FND_API.G_TRUE to reset list

367: --========================================================================
368: -- PROCEDURE : Process_Shipment_Requests PUBLIC
369: --
370: -- PARAMETERS: p_api_version_number known api version
371: -- p_init_msg_list FND_API.G_TRUE to reset list
372: -- p_process_mode 'ONLINE' or 'CONCURRENT'
373: -- p_criteria_info Attributes for the Process Shipment Request criteria
374: -- p_log_level 0 or 1 to control the log messages
375: -- x_request_id Concurrent request id when p_process_mode is 'CONCURRENT'

Line 419: IF NOT FND_API.Compatible_API_Call

415: IF l_debug_on THEN
416: wsh_debug_sv.push(l_module_name);
417: END IF;
418: -- Standard call to check for call compatibility
419: IF NOT FND_API.Compatible_API_Call
420: ( l_api_version_number
421: , p_api_version_number
422: , l_api_name
423: , G_PKG_NAME

Line 426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

422: , l_api_name
423: , G_PKG_NAME
424: )
425: THEN
426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: END IF;
428:
429: -- Initialize message stack if required
430: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 430: IF FND_API.to_Boolean(p_init_msg_list) THEN

426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
427: END IF;
428:
429: -- Initialize message stack if required
430: IF FND_API.to_Boolean(p_init_msg_list) THEN
431: FND_MSG_PUB.initialize;
432: END IF;
433:
434: IF l_debug_on THEN

Line 467: p_commit_flag => FND_API.G_TRUE,

463: -- If Process_Shipment_Request fails then it deletes the existing error messages from WIE table(non-autonomous transaction)
464: -- and inserts new error messages into WIE table(Autonomous transaction).
465: -- If rollback is performed in public API then there will be duplicate/extra error messages in WIE table.
466: WSH_SHIPMENT_REQUEST_PKG.Process_Shipment_Request(
467: p_commit_flag => FND_API.G_TRUE,
468: p_transaction_status => p_criteria_info.shipment_request_status,
469: p_client_code => p_criteria_info.client_code, -- LSP PROJECT
470: p_from_document_number => p_criteria_info.from_shipment_request_number,
471: p_to_document_number => p_criteria_info.to_shipment_request_number,

Line 495: raise FND_API.G_EXC_ERROR;

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:
498:
499: ELSIF p_process_mode = 'CONCURRENT' THEN

Line 526: raise FND_API.G_EXC_ERROR;

522: END IF;
523: --
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);

Line 541: raise FND_API.G_EXC_ERROR;

537: IF l_debug_on THEN
538: WSH_DEBUG_SV.logmsg(l_module_name, 'p_process_mode should be ONLINE/CONCURRENT');
539: END IF;
540: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
541: raise FND_API.G_EXC_ERROR;
542: END IF;
543:
544: IF p_commit = FND_API.G_TRUE THEN
545: COMMIT;

Line 544: IF p_commit = FND_API.G_TRUE THEN

540: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
541: raise FND_API.G_EXC_ERROR;
542: END IF;
543:
544: IF p_commit = FND_API.G_TRUE THEN
545: COMMIT;
546: END IF;
547: fnd_msg_pub.count_and_get(p_count => x_msg_count,
548: p_data => x_msg_data,

Line 549: p_encoded => fnd_api.g_false);

545: COMMIT;
546: END IF;
547: fnd_msg_pub.count_and_get(p_count => x_msg_count,
548: p_data => x_msg_data,
549: p_encoded => fnd_api.g_false);
550: IF l_debug_on THEN
551: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
552: WSH_DEBUG_SV.pop(l_module_name);
553: END IF;

Line 556: WHEN FND_API.G_EXC_ERROR THEN

552: WSH_DEBUG_SV.pop(l_module_name);
553: END IF;
554:
555: EXCEPTION
556: WHEN FND_API.G_EXC_ERROR THEN
557: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
559: END IF;
560: IF c_get_date%ISOPEN THEN

Line 572: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

568: END IF;
569: rollback;
570: IF l_debug_on THEN
571: WSH_DEBUG_SV.log(l_module_name, 'Error occured while processing Shipment Request',p_criteria_info.transaction_id);
572: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
573: END IF;
574: WHEN others THEN
575: IF c_get_date%ISOPEN THEN
576: CLOSE c_get_date;

Line 672: RAISE FND_API.G_EXC_ERROR;

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;
672: RAISE FND_API.G_EXC_ERROR;
673: END IF;
674:
675:
676: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1202: WHEN FND_API.G_EXC_ERROR THEN

1198: WSH_DEBUG_SV.log(l_module_name, 'Return Status', x_return_status);
1199: WSH_DEBUG_SV.pop(l_module_name);
1200: END IF;
1201: EXCEPTION
1202: WHEN FND_API.G_EXC_ERROR THEN
1203: p_shipment_request_info.delivery_interface_id := NULL;
1204: p_shipment_request_info.transaction_id := null;
1205: IF p_shipment_request_info.shipment_details_tab.count >0 THEN
1206: FOR i in 1..p_shipment_request_info.shipment_details_tab.count LOOP

Line 1217: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1213: rollback;
1214: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1215: IF l_debug_on THEN
1216: WSH_DEBUG_SV.log(l_module_name, 'Error occured while creating shipment request with document number and revision',p_shipment_request_info.document_number||' and '||p_shipment_request_info.document_revision);
1217: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1218: END IF;
1219:
1220: WHEN others THEN
1221: p_shipment_request_info.delivery_interface_id := NULL;

Line 1465: RAISE FND_API.G_EXC_ERROR;

1461:
1462: IF l_debug_on THEN
1463: WSH_DEBUG_SV.log(l_module_name, 'No Data found');
1464: END IF;
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;
1467:
1468: l_ins_rows := sql%rowcount;
1469: IF l_debug_on THEN

Line 1498: WHEN FND_API.G_EXC_ERROR THEN

1494: END IF;
1495: --
1496:
1497: EXCEPTION
1498: WHEN FND_API.G_EXC_ERROR THEN
1499: p_shipment_request_info.delivery_interface_id := NULL;
1500: p_shipment_request_info.transaction_id := null;
1501: IF p_shipment_request_info.shipment_details_tab.count >0 THEN
1502: FOR i in 1..p_shipment_request_info.shipment_details_tab.count LOOP

Line 1518: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1514: END IF;
1515: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1516: IF l_debug_on THEN
1517: WSH_DEBUG_SV.log(l_module_name, 'Error occured while querying shipment request with document number and revision',p_shipment_request_info.document_number||' and '||p_shipment_request_info.document_revision);
1518: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1519: END IF;
1520:
1521: WHEN others THEN
1522: IF c_get_WTH_WNDI_Rec%ISOPEN THEN

Line 1690: RAISE FND_API.G_EXC_ERROR;

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;
1690: RAISE FND_API.G_EXC_ERROR;
1691: END IF;
1692: CLOSE c_get_Details_DN;
1693:
1694: p_shipment_request_info.delivery_interface_id := l_delivery_interface_id;

Line 1715: RAISE FND_API.G_EXC_ERROR;

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;
1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;
1717: IF l_debug_on THEN
1718: wsh_debug_sv.logmsg(l_module_name, 'Taking locks on WDDI and WDAI for line number :'||p_shipment_request_info.shipment_details_tab(i).line_number);
1719: END IF;

Line 1762: RAISE FND_API.G_EXC_ERROR;

1758: END IF;
1759: END IF;
1760:
1761: IF l_tmp_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1762: RAISE FND_API.G_EXC_ERROR;
1763: END IF;
1764:
1765: IF l_debug_on THEN
1766: wsh_debug_sv.logmsg(l_module_name, 'Successfully locked records of WTH,WNDI and WDDI');

Line 1994: RAISE FND_API.G_EXC_ERROR;

1990: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1991: IF l_debug_on THEN
1992: WSH_DEBUG_SV.log(l_module_name, 'The Action of inserting new del detail interface lines failed');
1993: END IF;
1994: RAISE FND_API.G_EXC_ERROR;
1995: END IF;
1996: IF l_debug_on THEN
1997: WSH_DEBUG_SV.log(l_module_name, 'The Action of inserting new del detail interface lines is successful');
1998: END IF;

Line 2134: WHEN FND_API.G_EXC_ERROR THEN

2130: IF c_get_del_det_interface_id%ISOPEN THEN
2131: CLOSE c_get_del_det_interface_id;
2132: END IF;
2133:
2134: WHEN FND_API.G_EXC_ERROR THEN
2135: p_shipment_request_info.delivery_interface_id := NULL;
2136: p_shipment_request_info.transaction_id := null;
2137: IF p_shipment_request_info.shipment_details_tab.count >0 THEN
2138: FOR i in 1..p_shipment_request_info.shipment_details_tab.count LOOP

Line 2155: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');

2151: rollback;
2152: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2153: IF l_debug_on THEN
2154: WSH_DEBUG_SV.log(l_module_name, 'Error occured while updating shipment request with document number and revision',p_shipment_request_info.document_number||' and '||p_shipment_request_info.document_revision);
2155: WSH_DEBUG_SV.pop(l_module_name,'FND_API.G_EXC_ERROR');
2156: END IF;
2157:
2158: WHEN others THEN
2159: IF c_get_Details_DN%ISOPEN THEN