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 WSH_UTIL_CORE

Line 205: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

201:
202: END IF;
203: --
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');

Line 207: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

203: --
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:

Line 210: wsh_util_core.add_message(x_return_status);

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');
214: END IF;

Line 219: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

215: END IF;
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:

Line 222: wsh_util_core.add_message(x_return_status);

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;
226: IF p_shipment_request_info.Document_revision <= 0 OR

Line 228: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

224: l_invalid_inputs := 1;
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:

Line 231: wsh_util_core.add_message(x_return_status);

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;
235:

Line 237: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

233: l_invalid_inputs := 1;
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

Line 240: wsh_util_core.add_message(x_return_status);

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;
244: l_invalid_inputs := 1;

Line 261: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

257: Create_Shipment_Request(p_shipment_request_info => p_shipment_request_info,
258: p_caller => 'SHIPMENT_REQUEST',
259: x_return_status => l_return_status);
260:
261: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
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;

Line 279: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

275: --
276: Query_Shipment_Request(p_shipment_request_info => p_shipment_request_info,
277: x_interface_errors_info => x_interface_errors_info ,
278: x_return_status => l_return_status);
279: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
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;

Line 297: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

293: Update_Delete_Shipment_Request(
294: p_action_code => p_action_code,
295: p_shipment_request_info => p_shipment_request_info,
296: x_return_status => l_return_status);
297: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
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;

Line 305: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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');
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

Line 308: wsh_util_core.add_message(x_return_status);

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;
312: RAISE FND_API.G_EXC_ERROR;

Line 360: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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');
364: END IF;

Line 449: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

445: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.to_shipment_request_date',p_criteria_info.to_shipment_request_date);
446: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.transaction_id',p_criteria_info.transaction_id);
447: WSH_DEBUG_SV.log(l_module_name,'p_criteria_info.client_code',p_criteria_info.client_code); -- LSP PROJECT
448: END IF;
449: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
450:
451: IF p_process_mode = 'ONLINE' THEN
452: OPEN c_get_date(p_criteria_info.from_shipment_request_date,p_criteria_info.from_shipment_request_date);
453: FETCH c_get_date into l_from_date,l_to_date;

Line 478: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

474: p_transaction_id => p_criteria_info.transaction_id,
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;

Line 480: WSH_UTIL_CORE.Add_Message(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'
484: ,p_count => x_msg_count

Line 481: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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'
484: ,p_count => x_msg_count
485: ,p_data => x_msg_data);

Line 494: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_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:
498:

Line 525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

521: WSH_DEBUG_SV.log(l_module_name, 'Request Id returned from FND_REQUEST.SUBMIT_REQUEST', x_request_id);
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);

Line 530: WSH_UTIL_CORE.Add_Message(x_return_status);

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;
534: fnd_message.set_name('WSH', 'WSH_OI_INVALID_ATTRIBUTE');

Line 533: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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;
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

Line 536: wsh_util_core.add_message(x_return_status);

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;
540: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 540: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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;
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

Line 557: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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
561: CLOSE c_get_date;

Line 558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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
561: CLOSE c_get_date;
562: END IF;

Line 583: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

579: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
580: END IF;
581: rollback;
582:
583: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
584: IF l_debug_on THEN
585: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
586: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
587: END IF;

Line 611: l_del_det_int_tab wsh_util_core.id_tab_type;

607: l_exists NUMBER;
608: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
609: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Shipment_Request';
610:
611: l_del_det_int_tab wsh_util_core.id_tab_type;
612: --Bug8784331
613: l_date_requested wsh_util_core.Date_Tab_Type;
614: l_date_scheduled wsh_util_core.Date_Tab_Type;
615: l_inventory_item_id wsh_util_core.Id_Tab_Type;

Line 613: l_date_requested wsh_util_core.Date_Tab_Type;

609: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Shipment_Request';
610:
611: l_del_det_int_tab wsh_util_core.id_tab_type;
612: --Bug8784331
613: l_date_requested wsh_util_core.Date_Tab_Type;
614: l_date_scheduled wsh_util_core.Date_Tab_Type;
615: l_inventory_item_id wsh_util_core.Id_Tab_Type;
616: l_item_number wsh_util_core.tbl_varchar;
617: l_customer_item_id wsh_util_core.Id_Tab_Type;

Line 614: l_date_scheduled wsh_util_core.Date_Tab_Type;

610:
611: l_del_det_int_tab wsh_util_core.id_tab_type;
612: --Bug8784331
613: l_date_requested wsh_util_core.Date_Tab_Type;
614: l_date_scheduled wsh_util_core.Date_Tab_Type;
615: l_inventory_item_id wsh_util_core.Id_Tab_Type;
616: l_item_number wsh_util_core.tbl_varchar;
617: l_customer_item_id wsh_util_core.Id_Tab_Type;
618: l_customer_item_number wsh_util_core.tbl_varchar;

Line 615: l_inventory_item_id wsh_util_core.Id_Tab_Type;

611: l_del_det_int_tab wsh_util_core.id_tab_type;
612: --Bug8784331
613: l_date_requested wsh_util_core.Date_Tab_Type;
614: l_date_scheduled wsh_util_core.Date_Tab_Type;
615: l_inventory_item_id wsh_util_core.Id_Tab_Type;
616: l_item_number wsh_util_core.tbl_varchar;
617: l_customer_item_id wsh_util_core.Id_Tab_Type;
618: l_customer_item_number wsh_util_core.tbl_varchar;
619: l_requested_quantity wsh_util_core.Id_Tab_Type;

Line 616: l_item_number wsh_util_core.tbl_varchar;

612: --Bug8784331
613: l_date_requested wsh_util_core.Date_Tab_Type;
614: l_date_scheduled wsh_util_core.Date_Tab_Type;
615: l_inventory_item_id wsh_util_core.Id_Tab_Type;
616: l_item_number wsh_util_core.tbl_varchar;
617: l_customer_item_id wsh_util_core.Id_Tab_Type;
618: l_customer_item_number wsh_util_core.tbl_varchar;
619: l_requested_quantity wsh_util_core.Id_Tab_Type;
620: l_requested_quantity_uom wsh_util_core.tbl_varchar;

Line 617: l_customer_item_id wsh_util_core.Id_Tab_Type;

613: l_date_requested wsh_util_core.Date_Tab_Type;
614: l_date_scheduled wsh_util_core.Date_Tab_Type;
615: l_inventory_item_id wsh_util_core.Id_Tab_Type;
616: l_item_number wsh_util_core.tbl_varchar;
617: l_customer_item_id wsh_util_core.Id_Tab_Type;
618: l_customer_item_number wsh_util_core.tbl_varchar;
619: l_requested_quantity wsh_util_core.Id_Tab_Type;
620: l_requested_quantity_uom wsh_util_core.tbl_varchar;
621: l_src_requested_quantity wsh_util_core.Id_Tab_Type;

Line 618: l_customer_item_number wsh_util_core.tbl_varchar;

614: l_date_scheduled wsh_util_core.Date_Tab_Type;
615: l_inventory_item_id wsh_util_core.Id_Tab_Type;
616: l_item_number wsh_util_core.tbl_varchar;
617: l_customer_item_id wsh_util_core.Id_Tab_Type;
618: l_customer_item_number wsh_util_core.tbl_varchar;
619: l_requested_quantity wsh_util_core.Id_Tab_Type;
620: l_requested_quantity_uom wsh_util_core.tbl_varchar;
621: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
622: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;

Line 619: l_requested_quantity wsh_util_core.Id_Tab_Type;

615: l_inventory_item_id wsh_util_core.Id_Tab_Type;
616: l_item_number wsh_util_core.tbl_varchar;
617: l_customer_item_id wsh_util_core.Id_Tab_Type;
618: l_customer_item_number wsh_util_core.tbl_varchar;
619: l_requested_quantity wsh_util_core.Id_Tab_Type;
620: l_requested_quantity_uom wsh_util_core.tbl_varchar;
621: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
622: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
623: l_line_number wsh_util_core.Id_Tab_Type;

Line 620: l_requested_quantity_uom wsh_util_core.tbl_varchar;

616: l_item_number wsh_util_core.tbl_varchar;
617: l_customer_item_id wsh_util_core.Id_Tab_Type;
618: l_customer_item_number wsh_util_core.tbl_varchar;
619: l_requested_quantity wsh_util_core.Id_Tab_Type;
620: l_requested_quantity_uom wsh_util_core.tbl_varchar;
621: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
622: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
623: l_line_number wsh_util_core.Id_Tab_Type;
624: l_source_line_number wsh_util_core.tbl_varchar;

Line 621: l_src_requested_quantity wsh_util_core.Id_Tab_Type;

617: l_customer_item_id wsh_util_core.Id_Tab_Type;
618: l_customer_item_number wsh_util_core.tbl_varchar;
619: l_requested_quantity wsh_util_core.Id_Tab_Type;
620: l_requested_quantity_uom wsh_util_core.tbl_varchar;
621: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
622: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
623: l_line_number wsh_util_core.Id_Tab_Type;
624: l_source_line_number wsh_util_core.tbl_varchar;
625: l_source_header_number wsh_util_core.tbl_varchar;

Line 622: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;

618: l_customer_item_number wsh_util_core.tbl_varchar;
619: l_requested_quantity wsh_util_core.Id_Tab_Type;
620: l_requested_quantity_uom wsh_util_core.tbl_varchar;
621: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
622: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
623: l_line_number wsh_util_core.Id_Tab_Type;
624: l_source_line_number wsh_util_core.tbl_varchar;
625: l_source_header_number wsh_util_core.tbl_varchar;
626: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;

Line 623: l_line_number wsh_util_core.Id_Tab_Type;

619: l_requested_quantity wsh_util_core.Id_Tab_Type;
620: l_requested_quantity_uom wsh_util_core.tbl_varchar;
621: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
622: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
623: l_line_number wsh_util_core.Id_Tab_Type;
624: l_source_line_number wsh_util_core.tbl_varchar;
625: l_source_header_number wsh_util_core.tbl_varchar;
626: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
627: l_latest_pickup_date wsh_util_core.Date_Tab_Type;

Line 624: l_source_line_number wsh_util_core.tbl_varchar;

620: l_requested_quantity_uom wsh_util_core.tbl_varchar;
621: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
622: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
623: l_line_number wsh_util_core.Id_Tab_Type;
624: l_source_line_number wsh_util_core.tbl_varchar;
625: l_source_header_number wsh_util_core.tbl_varchar;
626: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
627: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
628: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;

Line 625: l_source_header_number wsh_util_core.tbl_varchar;

621: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
622: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
623: l_line_number wsh_util_core.Id_Tab_Type;
624: l_source_line_number wsh_util_core.tbl_varchar;
625: l_source_header_number wsh_util_core.tbl_varchar;
626: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
627: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
628: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
629: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;

Line 626: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;

622: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
623: l_line_number wsh_util_core.Id_Tab_Type;
624: l_source_line_number wsh_util_core.tbl_varchar;
625: l_source_header_number wsh_util_core.tbl_varchar;
626: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
627: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
628: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
629: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
630: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;

Line 627: l_latest_pickup_date wsh_util_core.Date_Tab_Type;

623: l_line_number wsh_util_core.Id_Tab_Type;
624: l_source_line_number wsh_util_core.tbl_varchar;
625: l_source_header_number wsh_util_core.tbl_varchar;
626: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
627: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
628: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
629: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
630: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
631: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;

Line 628: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;

624: l_source_line_number wsh_util_core.tbl_varchar;
625: l_source_header_number wsh_util_core.tbl_varchar;
626: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
627: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
628: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
629: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
630: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
631: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
632: l_shipping_instructions wsh_util_core.tbl_varchar;

Line 629: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;

625: l_source_header_number wsh_util_core.tbl_varchar;
626: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
627: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
628: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
629: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
630: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
631: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
632: l_shipping_instructions wsh_util_core.tbl_varchar;
633: l_packing_instructions wsh_util_core.tbl_varchar;

Line 630: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;

626: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
627: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
628: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
629: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
630: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
631: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
632: l_shipping_instructions wsh_util_core.tbl_varchar;
633: l_packing_instructions wsh_util_core.tbl_varchar;
634: l_shipment_priority_code wsh_util_core.tbl_varchar;

Line 631: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;

627: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
628: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
629: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
630: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
631: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
632: l_shipping_instructions wsh_util_core.tbl_varchar;
633: l_packing_instructions wsh_util_core.tbl_varchar;
634: l_shipment_priority_code wsh_util_core.tbl_varchar;
635: l_cust_po_number wsh_util_core.tbl_varchar;

Line 632: l_shipping_instructions wsh_util_core.tbl_varchar;

628: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
629: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
630: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
631: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
632: l_shipping_instructions wsh_util_core.tbl_varchar;
633: l_packing_instructions wsh_util_core.tbl_varchar;
634: l_shipment_priority_code wsh_util_core.tbl_varchar;
635: l_cust_po_number wsh_util_core.tbl_varchar;
636: l_subinventory wsh_util_core.tbl_varchar;

Line 633: l_packing_instructions wsh_util_core.tbl_varchar;

629: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
630: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
631: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
632: l_shipping_instructions wsh_util_core.tbl_varchar;
633: l_packing_instructions wsh_util_core.tbl_varchar;
634: l_shipment_priority_code wsh_util_core.tbl_varchar;
635: l_cust_po_number wsh_util_core.tbl_varchar;
636: l_subinventory wsh_util_core.tbl_varchar;
637: l_locator_id wsh_util_core.Id_Tab_Type;

Line 634: l_shipment_priority_code wsh_util_core.tbl_varchar;

630: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
631: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
632: l_shipping_instructions wsh_util_core.tbl_varchar;
633: l_packing_instructions wsh_util_core.tbl_varchar;
634: l_shipment_priority_code wsh_util_core.tbl_varchar;
635: l_cust_po_number wsh_util_core.tbl_varchar;
636: l_subinventory wsh_util_core.tbl_varchar;
637: l_locator_id wsh_util_core.Id_Tab_Type;
638: l_locator_code wsh_util_core.tbl_varchar;

Line 635: l_cust_po_number wsh_util_core.tbl_varchar;

631: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
632: l_shipping_instructions wsh_util_core.tbl_varchar;
633: l_packing_instructions wsh_util_core.tbl_varchar;
634: l_shipment_priority_code wsh_util_core.tbl_varchar;
635: l_cust_po_number wsh_util_core.tbl_varchar;
636: l_subinventory wsh_util_core.tbl_varchar;
637: l_locator_id wsh_util_core.Id_Tab_Type;
638: l_locator_code wsh_util_core.tbl_varchar;
639: l_lot_number wsh_util_core.tbl_varchar;

Line 636: l_subinventory wsh_util_core.tbl_varchar;

632: l_shipping_instructions wsh_util_core.tbl_varchar;
633: l_packing_instructions wsh_util_core.tbl_varchar;
634: l_shipment_priority_code wsh_util_core.tbl_varchar;
635: l_cust_po_number wsh_util_core.tbl_varchar;
636: l_subinventory wsh_util_core.tbl_varchar;
637: l_locator_id wsh_util_core.Id_Tab_Type;
638: l_locator_code wsh_util_core.tbl_varchar;
639: l_lot_number wsh_util_core.tbl_varchar;
640: l_revision wsh_util_core.tbl_varchar;

Line 637: l_locator_id wsh_util_core.Id_Tab_Type;

633: l_packing_instructions wsh_util_core.tbl_varchar;
634: l_shipment_priority_code wsh_util_core.tbl_varchar;
635: l_cust_po_number wsh_util_core.tbl_varchar;
636: l_subinventory wsh_util_core.tbl_varchar;
637: l_locator_id wsh_util_core.Id_Tab_Type;
638: l_locator_code wsh_util_core.tbl_varchar;
639: l_lot_number wsh_util_core.tbl_varchar;
640: l_revision wsh_util_core.tbl_varchar;
641: l_ship_set_name wsh_util_core.tbl_varchar;

Line 638: l_locator_code wsh_util_core.tbl_varchar;

634: l_shipment_priority_code wsh_util_core.tbl_varchar;
635: l_cust_po_number wsh_util_core.tbl_varchar;
636: l_subinventory wsh_util_core.tbl_varchar;
637: l_locator_id wsh_util_core.Id_Tab_Type;
638: l_locator_code wsh_util_core.tbl_varchar;
639: l_lot_number wsh_util_core.tbl_varchar;
640: l_revision wsh_util_core.tbl_varchar;
641: l_ship_set_name wsh_util_core.tbl_varchar;
642: l_unit_selling_price wsh_util_core.Id_Tab_Type;

Line 639: l_lot_number wsh_util_core.tbl_varchar;

635: l_cust_po_number wsh_util_core.tbl_varchar;
636: l_subinventory wsh_util_core.tbl_varchar;
637: l_locator_id wsh_util_core.Id_Tab_Type;
638: l_locator_code wsh_util_core.tbl_varchar;
639: l_lot_number wsh_util_core.tbl_varchar;
640: l_revision wsh_util_core.tbl_varchar;
641: l_ship_set_name wsh_util_core.tbl_varchar;
642: l_unit_selling_price wsh_util_core.Id_Tab_Type;
643: --Bug8784331

Line 640: l_revision wsh_util_core.tbl_varchar;

636: l_subinventory wsh_util_core.tbl_varchar;
637: l_locator_id wsh_util_core.Id_Tab_Type;
638: l_locator_code wsh_util_core.tbl_varchar;
639: l_lot_number wsh_util_core.tbl_varchar;
640: l_revision wsh_util_core.tbl_varchar;
641: l_ship_set_name wsh_util_core.tbl_varchar;
642: l_unit_selling_price wsh_util_core.Id_Tab_Type;
643: --Bug8784331
644: BEGIN

Line 641: l_ship_set_name wsh_util_core.tbl_varchar;

637: l_locator_id wsh_util_core.Id_Tab_Type;
638: l_locator_code wsh_util_core.tbl_varchar;
639: l_lot_number wsh_util_core.tbl_varchar;
640: l_revision wsh_util_core.tbl_varchar;
641: l_ship_set_name wsh_util_core.tbl_varchar;
642: l_unit_selling_price wsh_util_core.Id_Tab_Type;
643: --Bug8784331
644: BEGIN
645:

Line 642: l_unit_selling_price wsh_util_core.Id_Tab_Type;

638: l_locator_code wsh_util_core.tbl_varchar;
639: l_lot_number wsh_util_core.tbl_varchar;
640: l_revision wsh_util_core.tbl_varchar;
641: l_ship_set_name wsh_util_core.tbl_varchar;
642: l_unit_selling_price wsh_util_core.Id_Tab_Type;
643: --Bug8784331
644: BEGIN
645:
646: --

Line 652: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

648: WSH_DEBUG_SV.push(l_module_name);
649: WSH_DEBUG_SV.log(l_module_name,'Caller',p_caller);
650: END IF;
651: --
652: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
653:
654: if p_caller ='SHIPMENT_REQUEST' THEN
655: --{
656: select count(*) into l_exists

Line 664: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

660: AND document_type = 'SR'
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);

Line 668: wsh_util_core.add_message(x_return_status);

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;
672: RAISE FND_API.G_EXC_ERROR;

Line 676: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

672: RAISE FND_API.G_EXC_ERROR;
673: END IF;
674:
675:
676: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
677: IF l_debug_on THEN
678: wsh_debug_sv.logmsg(l_module_name, 'Inserting into WSH_NEW_DEL_INTERFACE');
679: END IF;
680:

Line 1214: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1210: IF l_debug_on THEN
1211: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
1212: END IF;
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;

Line 1232: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1228: IF l_debug_on THEN
1229: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
1230: END IF;
1231: rollback;
1232: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1233: IF l_debug_on THEN
1234: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1236: END IF;

Line 1393: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1389: WSH_DEBUG_SV.log(l_module_name, 'Document Number',p_shipment_request_info.document_number);
1390: WSH_DEBUG_SV.log(l_module_name, 'Document Revision',p_shipment_request_info.document_revision);
1391: END IF;
1392: --
1393: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1394: OPEN c_get_WTH_WNDI_Rec;
1395: FETCH c_get_WTH_WNDI_Rec INTO p_shipment_request_info.transaction_id,
1396: p_shipment_request_info.action_type,
1397: p_shipment_request_info.document_number,

Line 1456: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1452: p_shipment_request_info.price_list_id,
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);

Line 1460: wsh_util_core.add_message(x_return_status);

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');
1464: END IF;

Line 1515: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1511: END IF;
1512: IF c_get_WDDI_Rec%ISOPEN THEN
1513: CLOSE c_get_WDDI_Rec;
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;

Line 1538: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1534: FOR i in 1..p_shipment_request_info.shipment_details_tab.count LOOP
1535: p_shipment_request_info.shipment_details_tab(i).delivery_detail_interface_id := NULL;
1536: END LOOP;
1537: END IF;
1538: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1539: IF l_debug_on THEN
1540: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1541: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1542: END IF;

Line 1607: l_del_det_int_tab wsh_util_core.id_tab_type;

1603:
1604: --
1605: l_delivery_interface_id WSH_NEW_DEL_INTERFACE.delivery_interface_id%TYPE;
1606: l_transaction_id WSH_TRANSACTIONS_HISTORY.Transaction_Id%TYPE;
1607: l_del_det_int_tab wsh_util_core.id_tab_type;
1608: l_document_number WSH_TRANSACTIONS_HISTORY.document_number%TYPE;
1609: l_document_revision WSH_TRANSACTIONS_HISTORY.document_revision%TYPE;
1610: l_count NUMBER;
1611: l_ins_rows NUMBER;

Line 1629: l_date_requested wsh_util_core.Date_Tab_Type;

1625: RECORD_LOCKED EXCEPTION;
1626: PRAGMA EXCEPTION_INIT(record_locked, -54);
1627: --
1628: --Bug8784331
1629: l_date_requested wsh_util_core.Date_Tab_Type;
1630: l_date_scheduled wsh_util_core.Date_Tab_Type;
1631: l_inventory_item_id wsh_util_core.Id_Tab_Type;
1632: l_item_number wsh_util_core.tbl_varchar;
1633: l_customer_item_id wsh_util_core.Id_Tab_Type;

Line 1630: l_date_scheduled wsh_util_core.Date_Tab_Type;

1626: PRAGMA EXCEPTION_INIT(record_locked, -54);
1627: --
1628: --Bug8784331
1629: l_date_requested wsh_util_core.Date_Tab_Type;
1630: l_date_scheduled wsh_util_core.Date_Tab_Type;
1631: l_inventory_item_id wsh_util_core.Id_Tab_Type;
1632: l_item_number wsh_util_core.tbl_varchar;
1633: l_customer_item_id wsh_util_core.Id_Tab_Type;
1634: l_customer_item_number wsh_util_core.tbl_varchar;

Line 1631: l_inventory_item_id wsh_util_core.Id_Tab_Type;

1627: --
1628: --Bug8784331
1629: l_date_requested wsh_util_core.Date_Tab_Type;
1630: l_date_scheduled wsh_util_core.Date_Tab_Type;
1631: l_inventory_item_id wsh_util_core.Id_Tab_Type;
1632: l_item_number wsh_util_core.tbl_varchar;
1633: l_customer_item_id wsh_util_core.Id_Tab_Type;
1634: l_customer_item_number wsh_util_core.tbl_varchar;
1635: l_requested_quantity wsh_util_core.Id_Tab_Type;

Line 1632: l_item_number wsh_util_core.tbl_varchar;

1628: --Bug8784331
1629: l_date_requested wsh_util_core.Date_Tab_Type;
1630: l_date_scheduled wsh_util_core.Date_Tab_Type;
1631: l_inventory_item_id wsh_util_core.Id_Tab_Type;
1632: l_item_number wsh_util_core.tbl_varchar;
1633: l_customer_item_id wsh_util_core.Id_Tab_Type;
1634: l_customer_item_number wsh_util_core.tbl_varchar;
1635: l_requested_quantity wsh_util_core.Id_Tab_Type;
1636: l_requested_quantity_uom wsh_util_core.tbl_varchar;

Line 1633: l_customer_item_id wsh_util_core.Id_Tab_Type;

1629: l_date_requested wsh_util_core.Date_Tab_Type;
1630: l_date_scheduled wsh_util_core.Date_Tab_Type;
1631: l_inventory_item_id wsh_util_core.Id_Tab_Type;
1632: l_item_number wsh_util_core.tbl_varchar;
1633: l_customer_item_id wsh_util_core.Id_Tab_Type;
1634: l_customer_item_number wsh_util_core.tbl_varchar;
1635: l_requested_quantity wsh_util_core.Id_Tab_Type;
1636: l_requested_quantity_uom wsh_util_core.tbl_varchar;
1637: l_src_requested_quantity wsh_util_core.Id_Tab_Type;

Line 1634: l_customer_item_number wsh_util_core.tbl_varchar;

1630: l_date_scheduled wsh_util_core.Date_Tab_Type;
1631: l_inventory_item_id wsh_util_core.Id_Tab_Type;
1632: l_item_number wsh_util_core.tbl_varchar;
1633: l_customer_item_id wsh_util_core.Id_Tab_Type;
1634: l_customer_item_number wsh_util_core.tbl_varchar;
1635: l_requested_quantity wsh_util_core.Id_Tab_Type;
1636: l_requested_quantity_uom wsh_util_core.tbl_varchar;
1637: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
1638: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;

Line 1635: l_requested_quantity wsh_util_core.Id_Tab_Type;

1631: l_inventory_item_id wsh_util_core.Id_Tab_Type;
1632: l_item_number wsh_util_core.tbl_varchar;
1633: l_customer_item_id wsh_util_core.Id_Tab_Type;
1634: l_customer_item_number wsh_util_core.tbl_varchar;
1635: l_requested_quantity wsh_util_core.Id_Tab_Type;
1636: l_requested_quantity_uom wsh_util_core.tbl_varchar;
1637: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
1638: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
1639: l_line_number wsh_util_core.Id_Tab_Type;

Line 1636: l_requested_quantity_uom wsh_util_core.tbl_varchar;

1632: l_item_number wsh_util_core.tbl_varchar;
1633: l_customer_item_id wsh_util_core.Id_Tab_Type;
1634: l_customer_item_number wsh_util_core.tbl_varchar;
1635: l_requested_quantity wsh_util_core.Id_Tab_Type;
1636: l_requested_quantity_uom wsh_util_core.tbl_varchar;
1637: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
1638: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
1639: l_line_number wsh_util_core.Id_Tab_Type;
1640: l_source_line_number wsh_util_core.tbl_varchar;

Line 1637: l_src_requested_quantity wsh_util_core.Id_Tab_Type;

1633: l_customer_item_id wsh_util_core.Id_Tab_Type;
1634: l_customer_item_number wsh_util_core.tbl_varchar;
1635: l_requested_quantity wsh_util_core.Id_Tab_Type;
1636: l_requested_quantity_uom wsh_util_core.tbl_varchar;
1637: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
1638: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
1639: l_line_number wsh_util_core.Id_Tab_Type;
1640: l_source_line_number wsh_util_core.tbl_varchar;
1641: l_source_header_number wsh_util_core.tbl_varchar;

Line 1638: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;

1634: l_customer_item_number wsh_util_core.tbl_varchar;
1635: l_requested_quantity wsh_util_core.Id_Tab_Type;
1636: l_requested_quantity_uom wsh_util_core.tbl_varchar;
1637: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
1638: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
1639: l_line_number wsh_util_core.Id_Tab_Type;
1640: l_source_line_number wsh_util_core.tbl_varchar;
1641: l_source_header_number wsh_util_core.tbl_varchar;
1642: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;

Line 1639: l_line_number wsh_util_core.Id_Tab_Type;

1635: l_requested_quantity wsh_util_core.Id_Tab_Type;
1636: l_requested_quantity_uom wsh_util_core.tbl_varchar;
1637: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
1638: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
1639: l_line_number wsh_util_core.Id_Tab_Type;
1640: l_source_line_number wsh_util_core.tbl_varchar;
1641: l_source_header_number wsh_util_core.tbl_varchar;
1642: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
1643: l_latest_pickup_date wsh_util_core.Date_Tab_Type;

Line 1640: l_source_line_number wsh_util_core.tbl_varchar;

1636: l_requested_quantity_uom wsh_util_core.tbl_varchar;
1637: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
1638: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
1639: l_line_number wsh_util_core.Id_Tab_Type;
1640: l_source_line_number wsh_util_core.tbl_varchar;
1641: l_source_header_number wsh_util_core.tbl_varchar;
1642: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
1643: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
1644: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;

Line 1641: l_source_header_number wsh_util_core.tbl_varchar;

1637: l_src_requested_quantity wsh_util_core.Id_Tab_Type;
1638: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
1639: l_line_number wsh_util_core.Id_Tab_Type;
1640: l_source_line_number wsh_util_core.tbl_varchar;
1641: l_source_header_number wsh_util_core.tbl_varchar;
1642: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
1643: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
1644: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
1645: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;

Line 1642: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;

1638: l_src_requested_quantity_uom wsh_util_core.tbl_varchar;
1639: l_line_number wsh_util_core.Id_Tab_Type;
1640: l_source_line_number wsh_util_core.tbl_varchar;
1641: l_source_header_number wsh_util_core.tbl_varchar;
1642: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
1643: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
1644: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
1645: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
1646: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;

Line 1643: l_latest_pickup_date wsh_util_core.Date_Tab_Type;

1639: l_line_number wsh_util_core.Id_Tab_Type;
1640: l_source_line_number wsh_util_core.tbl_varchar;
1641: l_source_header_number wsh_util_core.tbl_varchar;
1642: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
1643: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
1644: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
1645: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
1646: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
1647: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;

Line 1644: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;

1640: l_source_line_number wsh_util_core.tbl_varchar;
1641: l_source_header_number wsh_util_core.tbl_varchar;
1642: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
1643: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
1644: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
1645: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
1646: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
1647: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
1648: l_shipping_instructions wsh_util_core.tbl_varchar;

Line 1645: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;

1641: l_source_header_number wsh_util_core.tbl_varchar;
1642: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
1643: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
1644: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
1645: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
1646: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
1647: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
1648: l_shipping_instructions wsh_util_core.tbl_varchar;
1649: l_packing_instructions wsh_util_core.tbl_varchar;

Line 1646: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;

1642: l_earliest_pickup_date wsh_util_core.Date_Tab_Type;
1643: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
1644: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
1645: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
1646: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
1647: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
1648: l_shipping_instructions wsh_util_core.tbl_varchar;
1649: l_packing_instructions wsh_util_core.tbl_varchar;
1650: l_shipment_priority_code wsh_util_core.tbl_varchar;

Line 1647: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;

1643: l_latest_pickup_date wsh_util_core.Date_Tab_Type;
1644: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
1645: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
1646: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
1647: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
1648: l_shipping_instructions wsh_util_core.tbl_varchar;
1649: l_packing_instructions wsh_util_core.tbl_varchar;
1650: l_shipment_priority_code wsh_util_core.tbl_varchar;
1651: l_cust_po_number wsh_util_core.tbl_varchar;

Line 1648: l_shipping_instructions wsh_util_core.tbl_varchar;

1644: l_earliest_dropoff_date wsh_util_core.Date_Tab_Type;
1645: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
1646: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
1647: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
1648: l_shipping_instructions wsh_util_core.tbl_varchar;
1649: l_packing_instructions wsh_util_core.tbl_varchar;
1650: l_shipment_priority_code wsh_util_core.tbl_varchar;
1651: l_cust_po_number wsh_util_core.tbl_varchar;
1652: l_subinventory wsh_util_core.tbl_varchar;

Line 1649: l_packing_instructions wsh_util_core.tbl_varchar;

1645: l_latest_dropoff_date wsh_util_core.Date_Tab_Type;
1646: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
1647: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
1648: l_shipping_instructions wsh_util_core.tbl_varchar;
1649: l_packing_instructions wsh_util_core.tbl_varchar;
1650: l_shipment_priority_code wsh_util_core.tbl_varchar;
1651: l_cust_po_number wsh_util_core.tbl_varchar;
1652: l_subinventory wsh_util_core.tbl_varchar;
1653: l_locator_id wsh_util_core.Id_Tab_Type;

Line 1650: l_shipment_priority_code wsh_util_core.tbl_varchar;

1646: l_ship_tolerance_above wsh_util_core.Id_Tab_Type;
1647: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
1648: l_shipping_instructions wsh_util_core.tbl_varchar;
1649: l_packing_instructions wsh_util_core.tbl_varchar;
1650: l_shipment_priority_code wsh_util_core.tbl_varchar;
1651: l_cust_po_number wsh_util_core.tbl_varchar;
1652: l_subinventory wsh_util_core.tbl_varchar;
1653: l_locator_id wsh_util_core.Id_Tab_Type;
1654: l_locator_code wsh_util_core.tbl_varchar;

Line 1651: l_cust_po_number wsh_util_core.tbl_varchar;

1647: l_ship_tolerance_below wsh_util_core.Id_Tab_Type;
1648: l_shipping_instructions wsh_util_core.tbl_varchar;
1649: l_packing_instructions wsh_util_core.tbl_varchar;
1650: l_shipment_priority_code wsh_util_core.tbl_varchar;
1651: l_cust_po_number wsh_util_core.tbl_varchar;
1652: l_subinventory wsh_util_core.tbl_varchar;
1653: l_locator_id wsh_util_core.Id_Tab_Type;
1654: l_locator_code wsh_util_core.tbl_varchar;
1655: l_lot_number wsh_util_core.tbl_varchar;

Line 1652: l_subinventory wsh_util_core.tbl_varchar;

1648: l_shipping_instructions wsh_util_core.tbl_varchar;
1649: l_packing_instructions wsh_util_core.tbl_varchar;
1650: l_shipment_priority_code wsh_util_core.tbl_varchar;
1651: l_cust_po_number wsh_util_core.tbl_varchar;
1652: l_subinventory wsh_util_core.tbl_varchar;
1653: l_locator_id wsh_util_core.Id_Tab_Type;
1654: l_locator_code wsh_util_core.tbl_varchar;
1655: l_lot_number wsh_util_core.tbl_varchar;
1656: l_revision wsh_util_core.tbl_varchar;

Line 1653: l_locator_id wsh_util_core.Id_Tab_Type;

1649: l_packing_instructions wsh_util_core.tbl_varchar;
1650: l_shipment_priority_code wsh_util_core.tbl_varchar;
1651: l_cust_po_number wsh_util_core.tbl_varchar;
1652: l_subinventory wsh_util_core.tbl_varchar;
1653: l_locator_id wsh_util_core.Id_Tab_Type;
1654: l_locator_code wsh_util_core.tbl_varchar;
1655: l_lot_number wsh_util_core.tbl_varchar;
1656: l_revision wsh_util_core.tbl_varchar;
1657: l_ship_set_name wsh_util_core.tbl_varchar;

Line 1654: l_locator_code wsh_util_core.tbl_varchar;

1650: l_shipment_priority_code wsh_util_core.tbl_varchar;
1651: l_cust_po_number wsh_util_core.tbl_varchar;
1652: l_subinventory wsh_util_core.tbl_varchar;
1653: l_locator_id wsh_util_core.Id_Tab_Type;
1654: l_locator_code wsh_util_core.tbl_varchar;
1655: l_lot_number wsh_util_core.tbl_varchar;
1656: l_revision wsh_util_core.tbl_varchar;
1657: l_ship_set_name wsh_util_core.tbl_varchar;
1658: l_unit_selling_price wsh_util_core.Id_Tab_Type;

Line 1655: l_lot_number wsh_util_core.tbl_varchar;

1651: l_cust_po_number wsh_util_core.tbl_varchar;
1652: l_subinventory wsh_util_core.tbl_varchar;
1653: l_locator_id wsh_util_core.Id_Tab_Type;
1654: l_locator_code wsh_util_core.tbl_varchar;
1655: l_lot_number wsh_util_core.tbl_varchar;
1656: l_revision wsh_util_core.tbl_varchar;
1657: l_ship_set_name wsh_util_core.tbl_varchar;
1658: l_unit_selling_price wsh_util_core.Id_Tab_Type;
1659: l_delivery_detail_interface_id wsh_util_core.Id_Tab_Type;

Line 1656: l_revision wsh_util_core.tbl_varchar;

1652: l_subinventory wsh_util_core.tbl_varchar;
1653: l_locator_id wsh_util_core.Id_Tab_Type;
1654: l_locator_code wsh_util_core.tbl_varchar;
1655: l_lot_number wsh_util_core.tbl_varchar;
1656: l_revision wsh_util_core.tbl_varchar;
1657: l_ship_set_name wsh_util_core.tbl_varchar;
1658: l_unit_selling_price wsh_util_core.Id_Tab_Type;
1659: l_delivery_detail_interface_id wsh_util_core.Id_Tab_Type;
1660: --Bug8784331

Line 1657: l_ship_set_name wsh_util_core.tbl_varchar;

1653: l_locator_id wsh_util_core.Id_Tab_Type;
1654: l_locator_code wsh_util_core.tbl_varchar;
1655: l_lot_number wsh_util_core.tbl_varchar;
1656: l_revision wsh_util_core.tbl_varchar;
1657: l_ship_set_name wsh_util_core.tbl_varchar;
1658: l_unit_selling_price wsh_util_core.Id_Tab_Type;
1659: l_delivery_detail_interface_id wsh_util_core.Id_Tab_Type;
1660: --Bug8784331
1661:

Line 1658: l_unit_selling_price wsh_util_core.Id_Tab_Type;

1654: l_locator_code wsh_util_core.tbl_varchar;
1655: l_lot_number wsh_util_core.tbl_varchar;
1656: l_revision wsh_util_core.tbl_varchar;
1657: l_ship_set_name wsh_util_core.tbl_varchar;
1658: l_unit_selling_price wsh_util_core.Id_Tab_Type;
1659: l_delivery_detail_interface_id wsh_util_core.Id_Tab_Type;
1660: --Bug8784331
1661:
1662:

Line 1659: l_delivery_detail_interface_id wsh_util_core.Id_Tab_Type;

1655: l_lot_number wsh_util_core.tbl_varchar;
1656: l_revision wsh_util_core.tbl_varchar;
1657: l_ship_set_name wsh_util_core.tbl_varchar;
1658: l_unit_selling_price wsh_util_core.Id_Tab_Type;
1659: l_delivery_detail_interface_id wsh_util_core.Id_Tab_Type;
1660: --Bug8784331
1661:
1662:
1663: BEGIN

Line 1672: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1668: WSH_DEBUG_SV.log(l_module_name,'WDDI count',p_shipment_request_info.shipment_details_tab.count);
1669: END IF;
1670:
1671:
1672: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1673: l_tmp_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1674:
1675: IF l_debug_on THEN
1676: wsh_debug_sv.logmsg(l_module_name, 'Taking locks on WTH,WNDI');

Line 1673: l_tmp_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1669: END IF;
1670:
1671:
1672: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1673: l_tmp_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1674:
1675: IF l_debug_on THEN
1676: wsh_debug_sv.logmsg(l_module_name, 'Taking locks on WTH,WNDI');
1677: END IF;

Line 1682: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1678:
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);

Line 1686: wsh_util_core.add_message(x_return_status);

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;
1690: RAISE FND_API.G_EXC_ERROR;

Line 1708: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1704: FOR i in 1..p_shipment_request_info.shipment_details_tab.count LOOP
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

Line 1711: wsh_util_core.add_message(x_return_status);

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;
1715: RAISE FND_API.G_EXC_ERROR;

Line 1737: l_tmp_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1733: IF l_debug_on THEN
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;

Line 1740: wsh_util_core.add_message(l_tmp_status);

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);
1744: l_upd_count :=l_upd_count + 1;

Line 1761: IF l_tmp_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1757: CLOSE c_get_all_del_det_interface_id;
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

Line 1990: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1986: Create_Shipment_Request(p_shipment_request_info => l_insert_sr_info,
1987: p_caller => 'UPDATE',
1988: x_return_status => l_return_status);
1989:
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;

Line 2113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2109: WSH_DEBUG_SV.pop(l_module_name);
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;

Line 2119: wsh_util_core.add_message(x_return_status,l_module_name);

2115: IF l_debug_on THEN
2116: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
2117: END IF;
2118: rollback;
2119: wsh_util_core.add_message(x_return_status,l_module_name);
2120: IF l_debug_on THEN
2121: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2122: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
2123: END IF;

Line 2152: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2148: IF l_debug_on THEN
2149: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
2150: END IF;
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;

Line 2166: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2162: IF l_debug_on THEN
2163: WSH_DEBUG_SV.logmsg(l_module_name,'Rolling back the transactions');
2164: END IF;
2165: rollback;
2166: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2167: IF l_debug_on THEN
2168: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2169: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2170: END IF;