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_USA_INV_PVT dependencies on WSH_UTIL_CORE

Line 68: l_mdc_detail_tab wsh_util_core.id_tab_type;

64: l_new_parent_detail_id NUMBER;
65: l_num_warnings NUMBER := 0;
66: -- K LPN CONV. rv
67:
68: l_mdc_detail_tab wsh_util_core.id_tab_type;
69: l_dd_id WSH_UTIL_CORE.ID_TAB_TYPE;
70: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;
71: l_return_status VARCHAR2(1);
72: l_new_delivery_id WSH_DELIVERY_ASSIGNMENTS_V.DELIVERY_ID%TYPE;

Line 69: l_dd_id WSH_UTIL_CORE.ID_TAB_TYPE;

65: l_num_warnings NUMBER := 0;
66: -- K LPN CONV. rv
67:
68: l_mdc_detail_tab wsh_util_core.id_tab_type;
69: l_dd_id WSH_UTIL_CORE.ID_TAB_TYPE;
70: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;
71: l_return_status VARCHAR2(1);
72: l_new_delivery_id WSH_DELIVERY_ASSIGNMENTS_V.DELIVERY_ID%TYPE;
73:

Line 70: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;

66: -- K LPN CONV. rv
67:
68: l_mdc_detail_tab wsh_util_core.id_tab_type;
69: l_dd_id WSH_UTIL_CORE.ID_TAB_TYPE;
70: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;
71: l_return_status VARCHAR2(1);
72: l_new_delivery_id WSH_DELIVERY_ASSIGNMENTS_V.DELIVERY_ID%TYPE;
73:
74: l_reprice_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 74: l_reprice_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;

70: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;
71: l_return_status VARCHAR2(1);
72: l_new_delivery_id WSH_DELIVERY_ASSIGNMENTS_V.DELIVERY_ID%TYPE;
73:
74: l_reprice_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
75:
76: MARK_REPRICE_ERROR EXCEPTION;
77: e_return EXCEPTION;
78:

Line 89: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

85:
86: -- OTM R12 : unassign delivery detail
87: l_ignore_for_planning WSH_DELIVERY_DETAILS.IGNORE_FOR_PLANNING%TYPE;
88: l_is_delivery_empty VARCHAR2(1);
89: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
90: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
91: l_gc3_is_installed VARCHAR2(1);
92: l_call_update VARCHAR2(1);
93: -- End of OTM R12 : unassign delivery detail

Line 90: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

86: -- OTM R12 : unassign delivery detail
87: l_ignore_for_planning WSH_DELIVERY_DETAILS.IGNORE_FOR_PLANNING%TYPE;
88: l_is_delivery_empty VARCHAR2(1);
89: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
90: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
91: l_gc3_is_installed VARCHAR2(1);
92: l_call_update VARCHAR2(1);
93: -- End of OTM R12 : unassign delivery detail
94:

Line 110: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

106: WSH_DEBUG_SV.log(l_module_name,'P_BACKORDER_REC_TBL.COUNT',P_BACKORDER_REC_TBL.COUNT);
107: WSH_DEBUG_SV.log(l_module_name,'P_ORG_INFO_TBL.COUNT',P_ORG_INFO_TBL.COUNT);
108: END IF;
109:
110: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
111:
112: -- OTM R12
113: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
114:

Line 113: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

109:
110: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
111:
112: -- OTM R12
113: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
114:
115: IF (l_gc3_is_installed IS NULL) THEN
116: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
117: END IF;

Line 116: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

112: -- OTM R12
113: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
114:
115: IF (l_gc3_is_installed IS NULL) THEN
116: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
117: END IF;
118: -- End of OTM R12
119:
120: -- Return back to caller if there are no records in table

Line 139: l_delivery_id_mod := MOD(p_backorder_rec_tbl(i).delivery_id,WSH_UTIL_CORE.C_INDEX_LIMIT) ; --Bug 9406326

135:
136: -- For Pick Release cases where Delivery exists
137: IF WSH_PICK_LIST.G_BATCH_ID IS NOT NULL AND p_backorder_rec_tbl(i).delivery_id IS NOT NULL THEN --{
138:
139: l_delivery_id_mod := MOD(p_backorder_rec_tbl(i).delivery_id,WSH_UTIL_CORE.C_INDEX_LIMIT) ; --Bug 9406326
140:
141: -- If the Delivery will be unassigned, then add to the list
142: -- This is used to unassign empty containers from the Delivery at the end of Pick Release process
143: IF p_backorder_rec_tbl(i).planned_flag = 'N'

Line 197: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

193: p_diff_fill_volume => -1 * p_backorder_rec_tbl(i).volume,
194: p_check_for_empty => 'Y',
195: x_return_status => l_return_status);
196:
197: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
198: WSH_UTIL_CORE.Add_Message(l_return_status);
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_WV_UTILS.DD_WV_Post_Process ');
201: END IF;

Line 198: WSH_UTIL_CORE.Add_Message(l_return_status);

194: p_check_for_empty => 'Y',
195: x_return_status => l_return_status);
196:
197: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
198: WSH_UTIL_CORE.Add_Message(l_return_status);
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_WV_UTILS.DD_WV_Post_Process ');
201: END IF;
202: ROLLBACK TO unassign_backorder_details;

Line 241: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

237: l_call_update := 'Y';
238: l_delivery_id_tab(1) := p_backorder_rec_tbl(i).delivery_id;
239: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(p_backorder_rec_tbl(i).delivery_id);
240:
241: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
242: IF l_debug_on THEN
243: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIE_ACTIONS.IS_DELIVERY_EMPTY '||to_char(p_backorder_rec_tbl(i).delivery_id));
244: END IF;
245: ROLLBACK TO unassign_backorder_details;

Line 263: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

259: p_delivery_id_tab => l_delivery_id_tab,
260: p_tms_interface_flag_tab => l_interface_flag_tab,
261: x_return_status => l_return_status);
262:
263: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
264: IF l_debug_on THEN
265: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
266: END IF;
267: ROLLBACK TO unassign_backorder_details;

Line 270: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

266: END IF;
267: ROLLBACK TO unassign_backorder_details;
268: l_num_errors := l_num_errors + 1;
269: GOTO next_record;
270: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
271: IF l_debug_on THEN
272: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
273: END IF;
274: RAISE e_return;

Line 275: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

271: IF l_debug_on THEN
272: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
273: END IF;
274: RAISE e_return;
275: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
276: IF l_debug_on THEN
277: WSH_DEBUG_SV.logmsg(l_module_name,'Warning in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
278: END IF;
279: l_num_warnings := l_num_warnings + 1;

Line 298: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

294: WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record(
295: p_detail_id_tab => l_mdc_detail_tab,
296: x_return_status => l_return_status);
297:
298: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
299: IF l_debug_on THEN
300: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record');
301: END IF;
302: ROLLBACK TO unassign_backorder_details;

Line 305: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

301: END IF;
302: ROLLBACK TO unassign_backorder_details;
303: l_num_errors := l_num_errors + 1;
304: GOTO next_record;
305: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
306: IF l_debug_on THEN
307: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error in WSH_DELIVERY_DETAILS_ACTIONS.Delete_Consol_Record ');
308: END IF;
309: RAISE e_return;

Line 318: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

314: WSH_DELIVERY_DETAILS_ACTIONS.Create_Consol_Record(
315: p_detail_id_tab => l_mdc_detail_tab,
316: x_return_status => l_return_status);
317:
318: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
319: IF l_debug_on THEN
320: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_DETAILS_ACTIONS.Create_Consol_Record');
321: END IF;
322: ROLLBACK TO unassign_backorder_details;

Line 325: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

321: END IF;
322: ROLLBACK TO unassign_backorder_details;
323: l_num_errors := l_num_errors + 1;
324: GOTO next_record;
325: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error in WSH_DELIVERY_DETAILS_ACTIONS.Create_Consol_Record');
328: END IF;
329: RAISE e_return;

Line 369: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

365: );
366: IF l_debug_on THEN
367: WSH_DEBUG_SV.log(l_module_name,'Return Status',l_return_status);
368: END IF;
369: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
370: IF l_debug_on THEN
371: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_WMS_SYNC_TMP_PKG.MERGE ');
372: END IF;
373: ROLLBACK TO unassign_backorder_details;

Line 376: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

372: END IF;
373: ROLLBACK TO unassign_backorder_details;
374: l_num_errors := l_num_errors + 1;
375: GOTO next_record;
376: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected Error in WSH_WMS_SYNC_TMP_PKG.MERGE ');
379: END IF;
380: RAISE e_return;

Line 381: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected Error in WSH_WMS_SYNC_TMP_PKG.MERGE ');
379: END IF;
380: RAISE e_return;
381: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
382: l_num_warnings := l_num_warnings + 1;
383: END IF;
384: --}
385: END IF;

Line 407: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN --{

403: p_entity_ids => l_del_tab,
404: x_return_status => l_return_status);
405: END IF; --}
406: -- Common Error Handling for above APIs
407: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN --{
408: IF l_debug_on THEN
409: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_TP_RELEASE.calculate_cont_del_tpdates ');
410: END IF;
411: ROLLBACK TO unassign_backorder_details;

Line 414: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

410: END IF;
411: ROLLBACK TO unassign_backorder_details;
412: l_num_errors := l_num_errors + 1;
413: GOTO next_record;
414: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
415: IF l_debug_on THEN
416: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected Error in WSH_TP_RELEASE.calculate_cont_del_tpdates ');
417: END IF;
418: RAISE e_return;

Line 419: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

415: IF l_debug_on THEN
416: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected Error in WSH_TP_RELEASE.calculate_cont_del_tpdates ');
417: END IF;
418: RAISE e_return;
419: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
420: l_num_warnings := l_num_warnings + 1;
421: END IF; --}
422: END IF; --}
423:

Line 435: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND l_new_delivery_id IS NULL THEN --{

431: -- If backordered line remains assigned to delivery, it can retain
432: -- freight costs.
433: -- Bug 2769639 fixes this in the API Unassign_Detail_From_Delivery,
434: -- and it needs to be incorporated here as well.
435: IF WSH_UTIL_CORE.FTE_Is_Installed = 'Y' AND l_new_delivery_id IS NULL THEN --{
436: l_dd_id(1) := p_backorder_rec_tbl(i).delivery_detail_id;
437:
438: IF l_debug_on THEN
439: WSH_DEBUG_SV.log(l_module_name,'Call WSH_FREIGHT_COSTS_PVT.Remove_FTE_Freight_Costs',p_backorder_rec_tbl(i).delivery_detail_id);

Line 450: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN --{

446: IF l_debug_on THEN
447: WSH_DEBUG_SV.log(l_module_name,'After WSH_FREIGHT_COSTS_PVT.Remove_FTE_Freight_Costs: return',l_return_status);
448: END IF;
449:
450: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN --{
451: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
452: WSH_UTIL_CORE.add_message(l_return_status, l_module_name);
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.logmsg(l_module_name,'Remove_FTE_Freight_Costs failed');

Line 452: WSH_UTIL_CORE.add_message(l_return_status, l_module_name);

448: END IF;
449:
450: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN --{
451: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
452: WSH_UTIL_CORE.add_message(l_return_status, l_module_name);
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.logmsg(l_module_name,'Remove_FTE_Freight_Costs failed');
455: END IF;
456: ROLLBACK TO unassign_backorder_details;

Line 459: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

455: END IF;
456: ROLLBACK TO unassign_backorder_details;
457: l_num_errors := l_num_errors + 1;
458: GOTO next_record;
459: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
460: l_num_warnings := l_num_warnings + 1;
461: END IF; --}
462: END IF; --}
463:

Line 483: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

479: p_diff_volume => p_backorder_rec_tbl(i).volume,
480: p_diff_fill_volume => p_backorder_rec_tbl(i).volume,
481: x_return_status => l_return_status);
482:
483: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
484: WSH_UTIL_CORE.Add_Message(l_return_status);
485: IF l_debug_on THEN
486: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_WV_UTILS.DD_WV_Post_Process ');
487: END IF;

Line 484: WSH_UTIL_CORE.Add_Message(l_return_status);

480: p_diff_fill_volume => p_backorder_rec_tbl(i).volume,
481: x_return_status => l_return_status);
482:
483: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
484: WSH_UTIL_CORE.Add_Message(l_return_status);
485: IF l_debug_on THEN
486: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_WV_UTILS.DD_WV_Post_Process ');
487: END IF;
488: ROLLBACK TO unassign_backorder_details;

Line 507: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

503: x_return_status => l_return_status);
504: IF l_debug_on THEN
505: WSH_DEBUG_SV.log(l_module_name,'Mark_Reprice_Required l_return_status',l_return_status);
506: END IF;
507: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
508: RAISE MARK_REPRICE_ERROR;
509: END IF;
510: END IF; --}
511:

Line 513: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

509: END IF;
510: END IF; --}
511:
512: IF (l_num_errors > 0) THEN
513: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
514: ELSIF (l_num_warnings > 0) THEN
515: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
516: END IF;
517:

Line 515: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

511:
512: IF (l_num_errors > 0) THEN
513: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
514: ELSIF (l_num_warnings > 0) THEN
515: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
516: END IF;
517:
518: IF l_debug_on THEN
519: WSH_DEBUG_SV.pop(l_module_name);

Line 527: WSH_UTIL_CORE.add_message(l_return_status,l_module_name);

523:
524: WHEN MARK_REPRICE_ERROR THEN
525: x_return_status := l_return_status;
526: FND_MESSAGE.SET_NAME('WSH', 'WSH_REPRICE_REQUIRED_ERR');
527: WSH_UTIL_CORE.add_message(l_return_status,l_module_name);
528: -- OTM R12 : unassign delivery detail
529: IF (c_detail_cont_planning_cur%ISOPEN) THEN
530: CLOSE c_detail_cont_planning_cur;
531: END IF;

Line 540: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.unassign_backordered_details');

536: END IF;
537:
538: WHEN e_return THEN
539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
540: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.unassign_backordered_details');
541: -- OTM R12 : unassign delivery detail
542: IF (c_detail_cont_planning_cur%ISOPEN) THEN
543: CLOSE c_detail_cont_planning_cur;
544: END IF;

Line 553: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.unassign_backordered_details');

549: END IF;
550:
551: WHEN OTHERS THEN
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.unassign_backordered_details');
554: -- OTM R12 : unassign delivery detail
555: IF (c_detail_cont_planning_cur%ISOPEN) THEN
556: CLOSE c_detail_cont_planning_cur;
557: END IF;

Line 623: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

619: --
620: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PACKAGE_NAME || '.' || 'BACKORDER_DELIVERY_DETAIL';
621: --
622:
623: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
624: l_dbi_rs VARCHAR2(1); -- DBI Project
625: l_dd_txn_id NUMBER; -- DBI Project
626: l_txn_return_status VARCHAR2(1); -- DBI Project
627: l_wf_rs VARCHAR2(1); -- Pick To POD WF project

Line 680: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

676: WSH_DEBUG_SV.log(l_module_name,'l_standalone_mode',l_standalone_mode);
677: END IF;
678: --
679:
680: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
681:
682: -- J: W/V Changes
683: OPEN C1;
684: FETCH C1 INTO l_container_id, l_delivery_id;

Line 735: IF (l_txn_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

731: WSH_DD_TXNS_PVT. create_dd_txn_from_dd (
732: p_delivery_detail_id => p_delivery_detail_id,
733: x_dd_txn_id => l_dd_txn_id,
734: x_return_status =>l_txn_return_status);
735: IF (l_txn_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
736: x_return_status := l_txn_return_status;
737: RETURN;
738: END IF;
739: --DBI

Line 785: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

781:
782: IF l_debug_on THEN
783: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
784: END IF;
785: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
786: x_return_status := l_dbi_rs;
787: -- just pass this return status to caller API
788: IF l_debug_on THEN
789: WSH_DEBUG_SV.logmsg(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

Line 833: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

829:
830: IF l_debug_on THEN
831: WSH_DEBUG_SV.log(l_module_name,'After Unassign_Backordered_Details: return',l_return_status);
832: END IF;
833: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
834: x_return_status := l_return_status;
835: WSH_UTIL_CORE.Add_Message(x_return_status);
836: IF l_debug_on THEN
837: WSH_DEBUG_SV.log(l_module_name,'Return Status',x_return_status);

Line 835: WSH_UTIL_CORE.Add_Message(x_return_status);

831: WSH_DEBUG_SV.log(l_module_name,'After Unassign_Backordered_Details: return',l_return_status);
832: END IF;
833: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
834: x_return_status := l_return_status;
835: WSH_UTIL_CORE.Add_Message(x_return_status);
836: IF l_debug_on THEN
837: WSH_DEBUG_SV.log(l_module_name,'Return Status',x_return_status);
838: WSH_DEBUG_SV.pop(l_module_name);
839: END IF;

Line 841: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

837: WSH_DEBUG_SV.log(l_module_name,'Return Status',x_return_status);
838: WSH_DEBUG_SV.pop(l_module_name);
839: END IF;
840: RETURN;
841: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
842: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
843: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
844: END IF;
845: END IF;

Line 842: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

838: WSH_DEBUG_SV.pop(l_module_name);
839: END IF;
840: RETURN;
841: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
842: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
843: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
844: END IF;
845: END IF;
846: --}

Line 843: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

839: END IF;
840: RETURN;
841: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
842: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
843: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
844: END IF;
845: END IF;
846: --}
847: ELSE

Line 864: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.backorder_delivery_detail');

860: EXCEPTION
861:
862: WHEN OTHERS THEN
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
864: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.backorder_delivery_detail');
865: IF l_debug_on THEN
866: WSH_DEBUG_SV.logmsg(l_module_name,'BACKORDER_DELIVERY_DETAIL_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
867: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:BACKORDER_DELIVERY_DETAIL');
868: END IF;

Line 965: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

961: END IF;
962:
963: EXCEPTION
964: WHEN totals_failed THEN
965: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
966: WSH_UTIL_CORE.add_message (x_return_status);
967: IF l_debug_on THEN
968: WSH_DEBUG_SV.logmsg(l_module_name,'GET_TOTAL_RESERVED_QUANTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
969: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GET_TOTAL_RESERVED_QUANTITY');

Line 966: WSH_UTIL_CORE.add_message (x_return_status);

962:
963: EXCEPTION
964: WHEN totals_failed THEN
965: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
966: WSH_UTIL_CORE.add_message (x_return_status);
967: IF l_debug_on THEN
968: WSH_DEBUG_SV.logmsg(l_module_name,'GET_TOTAL_RESERVED_QUANTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
969: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:GET_TOTAL_RESERVED_QUANTITY');
970: END IF;

Line 974: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.Get_total_Reserved_quantity');

970: END IF;
971:
972: WHEN OTHERS THEN
973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
974: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.Get_total_Reserved_quantity');
975: IF l_debug_on THEN
976: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
977: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
978: END IF;

Line 1145: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1141: END IF;
1142: --
1143: EXCEPTION
1144: WHEN query_reservation_failed THEN
1145: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1146: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.logmsg(l_module_name,'QUERY_RESERVATION_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1149: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:QUERY_RESERVATION_FAILED');

Line 1146: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

1142: --
1143: EXCEPTION
1144: WHEN query_reservation_failed THEN
1145: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1146: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.logmsg(l_module_name,'QUERY_RESERVATION_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1149: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:QUERY_RESERVATION_FAILED');
1150: END IF;

Line 1253: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1249: END IF;
1250: --
1251: EXCEPTION
1252: WHEN delete_reservation_failed THEN
1253: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1254: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1255: --
1256: -- Debug Statements
1257: --

Line 1254: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

1250: --
1251: EXCEPTION
1252: WHEN delete_reservation_failed THEN
1253: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1254: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1255: --
1256: -- Debug Statements
1257: --
1258: IF l_debug_on THEN

Line 1424: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1420: END IF;
1421: --
1422: EXCEPTION
1423: WHEN create_reservation_failed THEN
1424: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1425: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1426: --
1427: -- Debug Statements
1428: --

Line 1425: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

1421: --
1422: EXCEPTION
1423: WHEN create_reservation_failed THEN
1424: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1425: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1426: --
1427: -- Debug Statements
1428: --
1429: IF l_debug_on THEN

Line 1558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1554: END IF;
1555: --
1556: EXCEPTION
1557: WHEN update_reservation_failed THEN
1558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1559: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1560: --
1561: -- Debug Statements
1562: --

Line 1559: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

1555: --
1556: EXCEPTION
1557: WHEN update_reservation_failed THEN
1558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1559: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1560: --
1561: -- Debug Statements
1562: --
1563: IF l_debug_on THEN

Line 1842: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1838: WSH_DEBUG_SV.log(l_module_name,'p_delivery_detail_split_rec.delivery_detail_id',p_delivery_detail_split_rec.delivery_detail_id);
1839: WSH_DEBUG_SV.log(l_module_name,'p_delivery_detail_split_rec.inventory_item_id',p_delivery_detail_split_rec.inventory_item_id);
1840: END IF;
1841: --
1842: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1843:
1844: IF p_cancellation_quantity = 0 THEN
1845: --
1846: -- Debug Statements

Line 2058: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2054: END IF;
2055: --
2056: EXCEPTION
2057: WHEN cancel_failed THEN
2058: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2059: --
2060: -- Debug Statements
2061: --
2062: IF l_debug_on THEN

Line 2068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2064: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CANCEL_FAILED');
2065: END IF;
2066: --
2067: WHEN others THEN
2068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2069: wsh_util_core.default_handler('WSH_USA_INV_PVT.cancel_staged_reservation',l_module_name);
2070:
2071: IF l_debug_on THEN
2072: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2069: wsh_util_core.default_handler('WSH_USA_INV_PVT.cancel_staged_reservation',l_module_name);

2065: END IF;
2066: --
2067: WHEN others THEN
2068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2069: wsh_util_core.default_handler('WSH_USA_INV_PVT.cancel_staged_reservation',l_module_name);
2070:
2071: IF l_debug_on THEN
2072: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2073: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2163: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2159: WSH_DEBUG_SV.log(l_module_name,'P_CANCELLATION_QUANTITY',P_CANCELLATION_QUANTITY);
2160: WSH_DEBUG_SV.log(l_module_name,'P_CANCELLATION_QUANTITY2',P_CANCELLATION_QUANTITY2);
2161: END IF;
2162: --
2163: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2164:
2165: IF p_cancellation_quantity = 0 THEN
2166: --
2167: -- Debug Statements

Line 2319: l_fulfillment_base := WSH_UTIL_CORE.Get_Line_Fulfillment_Base(p_source_code, p_source_line_id);

2315:
2316: END LOOP;
2317:
2318: --MUOM Bug 16662301
2319: l_fulfillment_base := WSH_UTIL_CORE.Get_Line_Fulfillment_Base(p_source_code, p_source_line_id);
2320:
2321: IF l_debug_on THEN
2322: WSH_DEBUG_SV.log(l_module_name,'l_nonstaged_rsv_qty',l_nonstaged_rsv_qty);
2323: WSH_DEBUG_SV.log(l_module_name,'l_nonstaged_qty',l_nonstaged_qty);

Line 2695: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2691: END IF;
2692: --
2693: EXCEPTION
2694: WHEN cancel_failed THEN
2695: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2696: --
2697: -- Debug Statements
2698: --
2699: IF l_debug_on THEN

Line 2705: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2701: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CANCEL_FAILED');
2702: END IF;
2703: --
2704: WHEN others THEN
2705: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2706: wsh_util_core.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);
2707:
2708: --
2709: -- Debug Statements

Line 2706: wsh_util_core.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);

2702: END IF;
2703: --
2704: WHEN others THEN
2705: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2706: wsh_util_core.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);
2707:
2708: --
2709: -- Debug Statements
2710: --

Line 3146: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3142:
3143: --
3144: EXCEPTION
3145: WHEN transfer_split_failed THEN
3146: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3147: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3148: IF l_debug_on THEN
3149: WSH_DEBUG_SV.logmsg(l_module_name,'TRANSFER_SPLIT_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3150: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:TRANSFER_SPLIT_FAILED');

Line 3147: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

3143: --
3144: EXCEPTION
3145: WHEN transfer_split_failed THEN
3146: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3147: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3148: IF l_debug_on THEN
3149: WSH_DEBUG_SV.logmsg(l_module_name,'TRANSFER_SPLIT_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3150: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:TRANSFER_SPLIT_FAILED');
3151: END IF;

Line 3154: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3150: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:TRANSFER_SPLIT_FAILED');
3151: END IF;
3152: --
3153: WHEN others THEN
3154: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3155: wsh_util_core.default_handler('WSH_USA_INV_PVT.reservation_split_action',l_module_name);
3156: IF l_debug_on THEN
3157: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3158: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3155: wsh_util_core.default_handler('WSH_USA_INV_PVT.reservation_split_action',l_module_name);

3151: END IF;
3152: --
3153: WHEN others THEN
3154: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3155: wsh_util_core.default_handler('WSH_USA_INV_PVT.reservation_split_action',l_module_name);
3156: IF l_debug_on THEN
3157: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3158: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3159: END IF;

Line 3206: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

3202: l_split_quantity2 NUMBER ;
3203: l_sales_order_id NUMBER;
3204: l_reservation_id NUMBER;
3205:
3206: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
3207: l_dbi_rs VARCHAR2(1); -- DBI Project
3208:
3209: l_wf_rs VARCHAR2(1); --Pick to POD WF Project
3210: l_organization_id NUMBER; --Pick to POD WF Project

Line 3236: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS; -- bug # 9410461: Initializing return status.

3232: THEN
3233: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3234: END IF;
3235: --
3236: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS; -- bug # 9410461: Initializing return status.
3237: --
3238: IF l_debug_on THEN
3239: WSH_DEBUG_SV.push(l_module_name);
3240: --

Line 3254: l_fulfillment_base := WSH_UTIL_CORE.Get_Line_Fulfillment_Base(p_source_code, p_original_source_line_id);

3250: WSH_DEBUG_SV.log(l_module_name,'p_delivery_detail_split_rec.inventory_item_id',p_delivery_detail_split_rec.inventory_item_id);
3251: END IF;
3252:
3253: -- muom
3254: l_fulfillment_base := WSH_UTIL_CORE.Get_Line_Fulfillment_Base(p_source_code, p_original_source_line_id);
3255: --
3256: --
3257: -- Debug Statements
3258: -- HW OPMCONV. Removed checking for OPM org

Line 3318: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3314: WSH_DEBUG_SV.log(l_module_name,'Cancel_Move_Order_Line x_return_status',x_return_status);
3315: END IF;
3316:
3317: -- bug 5226867
3318: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3319: --
3320: IF l_debug_on THEN
3321: WSH_DEBUG_SV.log(l_module_name,'Cancel_Move_Order_Line returned unexpected error');
3322: END IF;

Line 3326: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

3322: END IF;
3323:
3324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3325: --
3326: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3327: --
3328: IF l_debug_on THEN
3329: WSH_DEBUG_SV.log(l_module_name,'Cancel_Move_Order_Line returned error');
3330: END IF;

Line 3386: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

3382:
3383: IF l_debug_on THEN
3384: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
3385: END IF;
3386: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3387: x_return_status := l_dbi_rs;
3388: -- just pass this return status to caller API
3389: IF l_debug_on THEN
3390: WSH_DEBUG_SV.pop(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

Line 3667: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3663: END IF;
3664: --
3665: EXCEPTION
3666: WHEN split_failed THEN
3667: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3668: --
3669: -- Debug Statements
3670: --
3671: IF l_debug_on THEN

Line 3679: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

3675: --
3676: -- bug 5226867
3677: -- Added the new excpetion for unexpected error
3678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3679: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3680: --
3681: -- Debug Statements
3682: --
3683: IF l_debug_on THEN

Line 3690: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3686: END IF;
3687: --
3688: -- bug 5226867
3689: WHEN others THEN
3690: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3691: wsh_util_core.default_handler('WSH_USA_INV_PVT.split_reservation',l_module_name);
3692:
3693: --
3694: -- Debug Statements

Line 3691: wsh_util_core.default_handler('WSH_USA_INV_PVT.split_reservation',l_module_name);

3687: --
3688: -- bug 5226867
3689: WHEN others THEN
3690: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3691: wsh_util_core.default_handler('WSH_USA_INV_PVT.split_reservation',l_module_name);
3692:
3693: --
3694: -- Debug Statements
3695: --

Line 3791: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

3787: WSH_DEBUG_SV.log(l_module_name,'Unmark_Serial_Number x_return_status',x_return_status);
3788: END IF;
3789: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3790: x_return_status := FND_API.G_RET_STS_ERROR;
3791: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3792: --
3793: -- Debug Statements
3794: --
3795: IF l_debug_on THEN

Line 3821: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.update_serial_numbers',l_module_name);

3817: EXCEPTION
3818:
3819: WHEN OTHERS THEN
3820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3821: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.update_serial_numbers',l_module_name);
3822:
3823: --
3824: -- Debug Statements
3825: --

Line 3903: l_cons_dd_ids WSH_UTIL_CORE.Id_Tab_Type;

3899: l_global_param_rec_type WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
3900:
3901: -- Added tables to call the wsh_delivery_details_actions.Consolidate_Source_Lines
3902: l_Cons_Source_Line_Rec_Tab WSH_DELIVERY_DETAILS_ACTIONS.Cons_Source_Line_Rec_Tab;
3903: l_cons_dd_ids WSH_UTIL_CORE.Id_Tab_Type;
3904:
3905: -- To store the shipping global parameter "Consolidate BO lines" value
3906: l_auto_consolidate VARCHAR2(1) := 'N';
3907: -- To check the consolidation happened or Not

Line 3941: l_delivery_detail_ids WSH_UTIL_CORE.Id_Tab_Type;

3937: l_cont_item_id NUMBER ;
3938: l_cont_instance_id NUMBER ;
3939: l_num_containers NUMBER ;
3940: l_organization_id NUMBER ;
3941: l_delivery_detail_ids WSH_UTIL_CORE.Id_Tab_Type;
3942: l_row_id VARCHAR2(30);
3943: l_request_id NUMBER;
3944: l_msg VARCHAR2(2000) := NULL;
3945: l_item_name VARCHAR2(2000):=NULL; -- Bug 1577237 : Earlier this was 40 characters long.

Line 3966: l_details_to_delete WSH_UTIL_CORE.Id_Tab_Type;

3962: l_update_transaction_temp_id VARCHAR2(1);
3963: l_update_shipped_quantity VARCHAR2(1);
3964:
3965: l_copy_detail_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
3966: l_details_to_delete WSH_UTIL_CORE.Id_Tab_Type;
3967: l_delete_count NUMBER := 0;
3968:
3969: l_overpick_rec WSH_INTERFACE.ChangedAttributeRecType;
3970: l_source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE;

Line 4017: l_cont_tab wsh_util_core.id_tab_type;

4013: l_carrier_id NUMBER;
4014: l_client_id NUMBER; -- LSP PROJECT
4015:
4016: -- K LPN CONV. rvishnuv
4017: l_cont_tab wsh_util_core.id_tab_type;
4018: l_lpn_unit_weight NUMBER;
4019: l_lpn_unit_volume NUMBER;
4020: l_lpn_weight_uom_code VARCHAR2(100);
4021: l_lpn_volume_uom_code VARCHAR2(100);

Line 4036: l_adjust_planned_del_tab WSH_UTIL_CORE.Id_Tab_Type;

4032: l_volume NUMBER;
4033:
4034: -- deliveryMerge
4035: Adjust_Planned_Flag_Err EXCEPTION;
4036: l_adjust_planned_del_tab WSH_UTIL_CORE.Id_Tab_Type;
4037: l_delivery_already_included boolean;
4038:
4039: -- inbound --jckwok
4040: Delivery_Line_Direction_Err EXCEPTION;

Line 4042: l_cnt_tab WSH_UTIL_CORE.Id_Tab_Type;

4038:
4039: -- inbound --jckwok
4040: Delivery_Line_Direction_Err EXCEPTION;
4041: --Added for bug 5234326
4042: l_cnt_tab WSH_UTIL_CORE.Id_Tab_Type;
4043:
4044: l_det_tab WSH_UTIL_CORE.Id_Tab_Type;
4045:
4046: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

Line 4044: l_det_tab WSH_UTIL_CORE.Id_Tab_Type;

4040: Delivery_Line_Direction_Err EXCEPTION;
4041: --Added for bug 5234326
4042: l_cnt_tab WSH_UTIL_CORE.Id_Tab_Type;
4043:
4044: l_det_tab WSH_UTIL_CORE.Id_Tab_Type;
4045:
4046: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
4047: l_dbi_rs VARCHAR2(1); -- DBI Project
4048: l_dd_txn_id NUMBER; -- DBI Project

Line 4046: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

4042: l_cnt_tab WSH_UTIL_CORE.Id_Tab_Type;
4043:
4044: l_det_tab WSH_UTIL_CORE.Id_Tab_Type;
4045:
4046: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
4047: l_dbi_rs VARCHAR2(1); -- DBI Project
4048: l_dd_txn_id NUMBER; -- DBI Project
4049: l_txn_return_status VARCHAR2(1); -- DBI Project
4050:

Line 4116: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4112: IF l_debug_on THEN
4113: WSH_DEBUG_SV.push(l_module_name);
4114: END IF;
4115: --
4116: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4117: l_multiple_update := 'N';
4118:
4119: -- deliveryMerge
4120: l_adjust_planned_del_tab.delete;

Line 4142: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

4138: x_msg_data => l_msg_data) ;
4139: IF l_debug_on THEN
4140: WSH_DEBUG_SV.log(l_module_name,'After call to Get_Inv_PC_Attributes ',l_return_status);
4141: END IF;
4142: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4143: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4144: IF l_debug_on THEN
4145: WSH_DEBUG_SV.logmsg(l_module_name, 'Errored out in Get_Inv_PC_Attributes ' );
4146: END IF;

Line 4143: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4139: IF l_debug_on THEN
4140: WSH_DEBUG_SV.log(l_module_name,'After call to Get_Inv_PC_Attributes ',l_return_status);
4141: END IF;
4142: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4143: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4144: IF l_debug_on THEN
4145: WSH_DEBUG_SV.logmsg(l_module_name, 'Errored out in Get_Inv_PC_Attributes ' );
4146: END IF;
4147: ELSE

Line 4185: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

4181:
4182: IF l_debug_on THEN
4183: WSH_DEBUG_SV.log(l_module_name,'After call to Set_Inv_PC_Attributes ',l_return_status);
4184: END IF;
4185: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4186: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4187: IF l_debug_on THEN
4188: WSH_DEBUG_SV.logmsg(l_module_name, 'Errored out in Set_Inv_PC_Attributes ' );
4189: END IF;

Line 4186: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4182: IF l_debug_on THEN
4183: WSH_DEBUG_SV.log(l_module_name,'After call to Set_Inv_PC_Attributes ',l_return_status);
4184: END IF;
4185: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4186: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4187: IF l_debug_on THEN
4188: WSH_DEBUG_SV.logmsg(l_module_name, 'Errored out in Set_Inv_PC_Attributes ' );
4189: END IF;
4190: END IF;

Line 4207: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4203: l_ship_status := 'having more than 1 record from inventory to be processed';
4204: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
4205: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
4206: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
4207: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4208: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
4209: IF l_debug_on THEN
4210: WSH_DEBUG_SV.pop(l_module_name,'ERROR:REJECT INV REQUEST');
4211: END IF;

Line 4208: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

4204: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
4205: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
4206: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
4207: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4208: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
4209: IF l_debug_on THEN
4210: WSH_DEBUG_SV.pop(l_module_name,'ERROR:REJECT INV REQUEST');
4211: END IF;
4212: RETURN;

Line 4311: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

4307: -- J: raise an exception if line_direction is not 'outbound' or 'internal order' -- jckwok
4308: IF (old_delivery_detail_rec.line_direction NOT IN ('O', 'IO')) THEN
4309: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_LINE_DIR_INVALID');
4310: FND_MESSAGE.Set_Token('DELIVERY_DETAIL_ID', old_delivery_detail_rec.delivery_detail_id);
4311: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
4312: IF l_debug_on THEN
4313: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: operation is invalid for delivery line direction');
4314: END IF;
4315: raise Delivery_Line_Direction_Err;

Line 4318: l_fulfillment_base := WSH_UTIL_CORE.Get_Line_Fulfillment_Base(old_delivery_detail_rec.source_code, old_delivery_detail_rec.source_line_id);

4314: END IF;
4315: raise Delivery_Line_Direction_Err;
4316: END IF;
4317: -- muom
4318: l_fulfillment_base := WSH_UTIL_CORE.Get_Line_Fulfillment_Base(old_delivery_detail_rec.source_code, old_delivery_detail_rec.source_line_id);
4319:
4320: --
4321: -- Debug Statements
4322: --

Line 4338: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4334: IF OLD_DELIVERY_DETAIL_REC.RELEASED_STATUS = 'N'
4335: AND p_changed_attributes(l_Counter).action_flag <> 'B'
4336: THEN
4337:
4338: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4339:
4340: FND_MESSAGE.SET_NAME('WSH', 'WSH_PICK_CONFIRM_NOT_READY');
4341:
4342: FND_MESSAGE.SET_TOKEN('SOURCE_LINE_NUM',

Line 4347: WSH_UTIL_CORE.add_message (x_return_status, l_module_name);

4343: old_delivery_detail_rec.source_line_number);
4344: FND_MESSAGE.SET_TOKEN('SOURCE_ORDER_NUM',
4345: old_delivery_detail_rec.source_header_number);
4346:
4347: WSH_UTIL_CORE.add_message (x_return_status, l_module_name);
4348:
4349: IF l_debug_on THEN
4350: WSH_DEBUG_SV.logmsg(l_module_name, 'detail is not ready to release.');
4351: WSH_DEBUG_SV.pop(l_module_name);

Line 4441: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

4437:
4438: -- Bug 3724578 : Return back to the caller if any error occures while
4439: -- splitting the delivery detail line
4440: --- Message will be set in Split_Delivery_Details
4441: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4442: x_return_status := l_return_status;
4443: return;
4444: END IF;
4445:

Line 4509: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

4505:
4506: -- Bug 3724578 : Return back to the caller if any error occures while
4507: -- splitting the delivery detail line
4508: --- Message will be set in Split_Delivery_Details
4509: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4510: x_return_status := l_return_status;
4511: return;
4512: END IF;
4513: END IF;

Line 4572: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

4568:
4569: -- Bug 3724578 : Return back to the caller if any error occures while
4570: -- splitting the delivery detail line
4571: --- Message will be set in Split_Delivery_Details
4572: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4573: x_return_status := l_return_status;
4574: return;
4575: END IF;
4576:

Line 4636: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

4632:
4633: -- Bug 3724578 : Return back to the caller if any error occures while
4634: -- splitting the delivery detail line
4635: --- Message will be set in Split_Delivery_Details
4636: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4637: x_return_status := l_return_status;
4638: return;
4639: END IF;
4640: END IF;

Line 4746: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

4742:
4743: -- Bug 3724578 : Return back to the caller if any error occures while
4744: -- splitting the delivery detail line
4745: -- Message will be set in Split_Delivery_Details
4746: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4747: x_return_status := l_return_status;
4748: return;
4749: END IF;
4750:

Line 4786: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

4782: -- DBI API can only raise unexpected error, in that case need to
4783: -- pass it to the caller API for roll back of the whole transaction
4784: -- Only need to handle Unexpected error, rest are treated as success
4785: -- Since code is not proceeding, no need to reset x_return_status
4786: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
4787: x_return_status := l_dbi_rs;
4788: IF l_debug_on THEN
4789: WSH_DEBUG_SV.pop(l_module_name);
4790: END IF;

Line 4818: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

4814: p_calc_wv_if_frozen => 'N',
4815: x_net_weight => l_net_weight,
4816: x_volume => l_volume,
4817: x_return_status => l_return_status);
4818: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
4819: x_return_status := l_return_status;
4820: IF l_debug_on THEN
4821: WSH_DEBUG_SV.logmsg(l_module_name,'Detail_Weight_Volume returned '|| l_return_status);
4822: WSH_DEBUG_SV.pop(l_module_name);

Line 4844: IF (l_txn_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

4840: x_dd_txn_id => l_dd_txn_id,
4841: x_return_status =>l_txn_return_status
4842: );
4843:
4844: IF (l_txn_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4845: x_return_status := l_txn_return_status;
4846: return;
4847: END IF;
4848: --DBI Api

Line 4903: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

4899: -- DBI API can only raise unexpected error, in that case need to
4900: -- pass it to the caller API for roll back of the whole transaction
4901: -- Only need to handle Unexpected error, rest are treated as success
4902: -- Since code is not proceeding, no need to reset x_return_status
4903: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
4904: x_return_status := l_dbi_rs;
4905: IF l_debug_on THEN
4906: WSH_DEBUG_SV.pop(l_module_name);
4907: END IF;

Line 4949: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

4945: WSH_DEBUG_SV.log(l_module_name,'Split_Delivery_Details l_return_status',l_return_status);
4946: WSH_DEBUG_SV.log(l_module_name,'Split_Delivery_Details is ',l_dummy_detail_id);
4947: END IF;
4948:
4949: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4950: x_return_status := l_return_status;
4951: return;
4952: END IF;
4953:

Line 4978: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

4974: -- muom
4975: x_split_quantity2 => l_split_quantity2,
4976: x_return_status => l_return_status
4977: );
4978: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4979: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4980: END IF;
4981: GOTO loop_end;
4982:

Line 4979: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4975: x_split_quantity2 => l_split_quantity2,
4976: x_return_status => l_return_status
4977: );
4978: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
4979: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4980: END IF;
4981: GOTO loop_end;
4982:
4983: -- if action_flag = 'R'

Line 5001: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

4997: --
4998: IF l_debug_on THEN
4999: WSH_DEBUG_SV.logmsg(l_module_name, 'CYCLE_COUNT_QUANTITY = ' || P_CHANGED_ATTRIBUTES ( L_COUNTER ) .CYCLE_COUNT_QUANTITY );
5000: WSH_DEBUG_SV.logmsg(l_module_name, 'L_REQUEST_ID = ' || L_REQUEST_ID );
5001: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5002: END IF;
5003:
5004: l_item_name := WSH_UTIL_CORE.Get_Item_Name(old_delivery_detail_rec.inventory_item_id,old_delivery_detail_rec.organization_id);
5005: IF (old_delivery_detail_rec.ship_set_id IS NOT NULL) OR

Line 5004: l_item_name := WSH_UTIL_CORE.Get_Item_Name(old_delivery_detail_rec.inventory_item_id,old_delivery_detail_rec.organization_id);

5000: WSH_DEBUG_SV.logmsg(l_module_name, 'L_REQUEST_ID = ' || L_REQUEST_ID );
5001: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5002: END IF;
5003:
5004: l_item_name := WSH_UTIL_CORE.Get_Item_Name(old_delivery_detail_rec.inventory_item_id,old_delivery_detail_rec.organization_id);
5005: IF (old_delivery_detail_rec.ship_set_id IS NOT NULL) OR
5006: (old_delivery_detail_rec.top_model_line_id IS NOT NULL ) THEN
5007:
5008: -- Line belongs to Ship Set / SMC

Line 5098: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

5094: AND set_type = 'SHIP_SET';
5095: END IF;
5096:
5097: IF l_debug_on THEN
5098: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5099: END IF;
5100: --
5101: g_backordered_item := WSH_UTIL_CORE.Get_Item_Name(l_backordered_item_id,old_delivery_detail_rec.organization_id);
5102: --

Line 5101: g_backordered_item := WSH_UTIL_CORE.Get_Item_Name(l_backordered_item_id,old_delivery_detail_rec.organization_id);

5097: IF l_debug_on THEN
5098: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5099: END IF;
5100: --
5101: g_backordered_item := WSH_UTIL_CORE.Get_Item_Name(l_backordered_item_id,old_delivery_detail_rec.organization_id);
5102: --
5103: --
5104: IF l_debug_on THEN
5105: WSH_DEBUG_SV.logmsg(l_module_name, 'FOUND NEW G_MOVE_ORDER_LINE_ID = ' || G_MOVE_ORDER_LINE_ID ||

Line 5200: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

5196: WHERE line_id = g_ship_model_id;
5197: END IF;
5198: --
5199: IF l_debug_on THEN
5200: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5201: END IF;
5202: --
5203: g_backordered_item := WSH_UTIL_CORE.Get_Item_Name(l_backordered_item_id,old_delivery_detail_rec.organization_id);
5204: --

Line 5203: g_backordered_item := WSH_UTIL_CORE.Get_Item_Name(l_backordered_item_id,old_delivery_detail_rec.organization_id);

5199: IF l_debug_on THEN
5200: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_ITEM_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5201: END IF;
5202: --
5203: g_backordered_item := WSH_UTIL_CORE.Get_Item_Name(l_backordered_item_id,old_delivery_detail_rec.organization_id);
5204: --
5205: g_top_model_item := WSH_UTIL_CORE.Get_Item_Name(l_top_model_item_id,old_delivery_detail_rec.organization_id);
5206: --
5207: WSH_INTEGRATION.G_BackorderRec_Tbl.DELETE(l_backorder_cnt);

Line 5205: g_top_model_item := WSH_UTIL_CORE.Get_Item_Name(l_top_model_item_id,old_delivery_detail_rec.organization_id);

5201: END IF;
5202: --
5203: g_backordered_item := WSH_UTIL_CORE.Get_Item_Name(l_backordered_item_id,old_delivery_detail_rec.organization_id);
5204: --
5205: g_top_model_item := WSH_UTIL_CORE.Get_Item_Name(l_top_model_item_id,old_delivery_detail_rec.organization_id);
5206: --
5207: WSH_INTEGRATION.G_BackorderRec_Tbl.DELETE(l_backorder_cnt);
5208: EXIT;
5209: END IF;

Line 5496: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

5492: IF l_debug_on THEN
5493: WSH_DEBUG_SV.logmsg(l_module_name, 'After calling Get_Global_Parameters: ' || l_return_status );
5494: END IF;
5495: --
5496: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
5497: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5498: END IF;
5499: l_auto_consolidate := l_global_param_rec_type.consolidate_bo_lines;
5500: END IF; --}, l_planned_flag

Line 5497: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5493: WSH_DEBUG_SV.logmsg(l_module_name, 'After calling Get_Global_Parameters: ' || l_return_status );
5494: END IF;
5495: --
5496: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
5497: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5498: END IF;
5499: l_auto_consolidate := l_global_param_rec_type.consolidate_bo_lines;
5500: END IF; --}, l_planned_flag
5501:

Line 5534: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

5530:
5531: IF l_debug_on THEN
5532: WSH_DEBUG_SV.log(l_module_name,'After calling CONSOLIDATE_SOURCE_LINE: ',l_return_status);
5533: END IF;
5534: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
5535: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5536: END IF;
5537: -- Checking consolidation is done or not
5538:

Line 5535: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5531: IF l_debug_on THEN
5532: WSH_DEBUG_SV.log(l_module_name,'After calling CONSOLIDATE_SOURCE_LINE: ',l_return_status);
5533: END IF;
5534: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
5535: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5536: END IF;
5537: -- Checking consolidation is done or not
5538:
5539: IF ( l_cons_dd_ids(1) <> p_Changed_attributes(l_counter).delivery_detail_id ) THEN

Line 5575: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

5571:
5572: -- Bug 3724578 : Return back to the caller if any error occures while
5573: -- splitting the delivery detail line
5574: -- Message will be set in Split_Delivery_Details
5575: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
5576: x_return_status := l_return_status;
5577: return;
5578: END IF;
5579:

Line 5615: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

5611: IF l_debug_on THEN
5612: WSH_DEBUG_SV.log(l_module_name,'After calling CONSOLIDATE_SOURCE_LINE: ',l_return_status);
5613: END IF;
5614:
5615: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
5616: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5617: END IF;
5618:
5619: IF ( l_cons_dd_ids(1) <> p_Changed_attributes(l_counter).delivery_detail_id ) THEN

Line 5616: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5612: WSH_DEBUG_SV.log(l_module_name,'After calling CONSOLIDATE_SOURCE_LINE: ',l_return_status);
5613: END IF;
5614:
5615: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
5616: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5617: END IF;
5618:
5619: IF ( l_cons_dd_ids(1) <> p_Changed_attributes(l_counter).delivery_detail_id ) THEN
5620: l_cons_flag := 'Y';

Line 5664: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

5660: -- muom
5661: x_split_quantity2 => l_split_quantity2,
5662: x_return_status => l_return_status
5663: );
5664: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
5665: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5666: END IF;
5667:
5668:

Line 5665: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5661: x_split_quantity2 => l_split_quantity2,
5662: x_return_status => l_return_status
5663: );
5664: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
5665: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5666: END IF;
5667:
5668:
5669: -- muom

Line 5739: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5735: --
5736: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5737: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5738: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transfer lpn id');
5739: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5740: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
5741: ELSE
5742: IF (l_parent_detail_id IS NOT NULL) THEN
5743:

Line 5740: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

5736: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
5737: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
5738: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transfer lpn id');
5739: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5740: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
5741: ELSE
5742: IF (l_parent_detail_id IS NOT NULL) THEN
5743:
5744: l_msg := NULL;

Line 5771: IF (l_exception_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

5767: );
5768: IF l_debug_on THEN
5769: WSH_DEBUG_SV.log(l_module_name,'log_exception l_exception_return_status',l_exception_return_status);
5770: END IF;
5771: IF (l_exception_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
5772: --
5773: -- Debug Statements
5774: --
5775: IF l_debug_on THEN

Line 5858: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5854: p_ignore_for_planning => old_delivery_detail_rec.ignore_for_planning,
5855: p_caller => l_create_cnt_caller);
5856:
5857: IF (l_cont_tab.count = 0) THEN
5858: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5859: --
5860: -- Debug Statements
5861: --
5862: IF l_debug_on THEN

Line 5877: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,

5873: IF l_debug_on THEN
5874: WSH_DEBUG_SV.log(l_module_name,'Create_Cont_Instance_Multi l_return_status',l_return_status);
5875: END IF;
5876:
5877: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
5878: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5879: x_return_status := l_return_status;
5880: IF l_debug_on THEN
5881: WSH_DEBUG_SV.pop(l_module_name);

Line 5878: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5874: WSH_DEBUG_SV.log(l_module_name,'Create_Cont_Instance_Multi l_return_status',l_return_status);
5875: END IF;
5876:
5877: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
5878: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5879: x_return_status := l_return_status;
5880: IF l_debug_on THEN
5881: WSH_DEBUG_SV.pop(l_module_name);
5882: END IF;

Line 5982: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,

5978: WSH_WMS_LPN_GRP.g_caller := l_original_caller;
5979: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;
5980: -- LPN CONV rv
5981: --
5982: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
5983: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5984: x_return_status := l_return_status;
5985: RETURN;
5986: END IF ;

Line 5983: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5979: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;
5980: -- LPN CONV rv
5981: --
5982: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
5983: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
5984: x_return_status := l_return_status;
5985: RETURN;
5986: END IF ;
5987:

Line 6002: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,

5998: IF l_debug_on THEN
5999: WSH_DEBUG_SV.log(l_module_name,'calculate_cont_del_tpdates l_return_status',l_return_status);
6000: END IF;
6001:
6002: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
6003: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6004: x_return_status := l_return_status;
6005: RETURN;
6006: END IF ;

Line 6003: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

5999: WSH_DEBUG_SV.log(l_module_name,'calculate_cont_del_tpdates l_return_status',l_return_status);
6000: END IF;
6001:
6002: IF (l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
6003: WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
6004: x_return_status := l_return_status;
6005: RETURN;
6006: END IF ;
6007:

Line 6042: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

6038: IF l_debug_on THEN
6039: WSH_DEBUG_SV.log(l_module_name,'Update_Cont_Hierarchy l_return_status',l_return_status);
6040: END IF;
6041:
6042: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
6043: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
6044: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
6045: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
6046: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 6045: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);

6041:
6042: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
6043: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
6044: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
6045: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
6046: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6047: END IF;
6048:
6049: END IF;--}

Line 6046: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

6042: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
6043: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
6044: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
6045: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
6046: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6047: END IF;
6048:
6049: END IF;--}
6050:

Line 6071: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6067: IF ( l_reject_update = 'Y' ) THEN
6068: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6069: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6070: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'subinventory');
6071: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6072: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
6073: ELSE
6074: -- bug 2302693: we do not log an exception if the line is packed
6075: -- and its subinventory was not null before pick confirm.

Line 6072: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

6068: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6069: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6070: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'subinventory');
6071: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6072: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
6073: ELSE
6074: -- bug 2302693: we do not log an exception if the line is packed
6075: -- and its subinventory was not null before pick confirm.
6076: -- The reason is that the item is being moved from a source subinventory

Line 6099: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6095: l_ship_status := 'confirmed, in-transit or closed';
6096: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6097: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6098: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'locator_id');
6099: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6100: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
6101: ELSE
6102: -- bug 2302693: we do not log an exception if the line is packed
6103: -- and its inventory control was not null before pick confirm.

Line 6100: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

6096: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6097: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6098: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'locator_id');
6099: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6100: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
6101: ELSE
6102: -- bug 2302693: we do not log an exception if the line is packed
6103: -- and its inventory control was not null before pick confirm.
6104: -- The reason is that before pick confirm, we assume packing is planned.

Line 6125: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6121: l_ship_status := 'confirmed, in-transit or closed';
6122: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6123: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6124: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'revision');
6125: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6126: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6127: ELSE
6128: -- bug 2302693: we do not log an exception if the line is packed
6129: -- and its inventory control was not null before pick confirm.

Line 6126: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

6122: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6123: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6124: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'revision');
6125: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6126: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6127: ELSE
6128: -- bug 2302693: we do not log an exception if the line is packed
6129: -- and its inventory control was not null before pick confirm.
6130: -- The reason is that before pick confirm, we assume packing is planned.

Line 6158: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6154: l_ship_status := 'confirmed, in-transit or closed';
6155: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6156: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6157: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'lot_number');
6158: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6159: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6160: ELSE
6161: -- bug 2302693: we do not log an exception if the line is packed
6162: -- and its inventory control was not null before pick confirm.

Line 6159: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

6155: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6156: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6157: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'lot_number');
6158: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6159: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6160: ELSE
6161: -- bug 2302693: we do not log an exception if the line is packed
6162: -- and its inventory control was not null before pick confirm.
6163: -- The reason is that before pick confirm, we assume packing is planned.

Line 6187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6183: l_ship_status := 'confirmed, in-transit or closed';
6184: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6185: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6186: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'preferred_grade');
6187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6188: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6189: ELSE
6190: -- bug 2302693: we do not log an exception if the line is packed
6191: -- and its inventory control was not null before pick confirm.

Line 6188: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

6184: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6185: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6186: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'preferred_grade');
6187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6188: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6189: ELSE
6190: -- bug 2302693: we do not log an exception if the line is packed
6191: -- and its inventory control was not null before pick confirm.
6192: -- The reason is that before pick confirm, we assume packing is planned.

Line 6218: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6214: l_ship_status := 'confirmed, in-transit or closed';
6215: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6216: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6217: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
6218: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6219: WSH_UTIL_CORE.Add_Message(x_return_status);
6220: ELSE
6221: l_update_transaction_temp_id := 'Y';
6222: END IF; -- End of if l_reject_update = 'Y'

Line 6219: WSH_UTIL_CORE.Add_Message(x_return_status);

6215: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6216: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6217: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'transaction_temp_id');
6218: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6219: WSH_UTIL_CORE.Add_Message(x_return_status);
6220: ELSE
6221: l_update_transaction_temp_id := 'Y';
6222: END IF; -- End of if l_reject_update = 'Y'
6223: END IF; -- End of if transaction_temp_id

Line 6240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6236: l_ship_status := 'confirmed, in-transit or closed';
6237: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6238: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6239: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'serial_number');
6240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6241: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6242: ELSE
6243: -- bug 2302693: we do not log an exception if the line is packed
6244: -- and its inventory control was not null before pick confirm.

Line 6241: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

6237: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6238: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6239: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'serial_number');
6240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6241: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6242: ELSE
6243: -- bug 2302693: we do not log an exception if the line is packed
6244: -- and its inventory control was not null before pick confirm.
6245: -- The reason is that before pick confirm, we assume packing is planned.

Line 6266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6262: l_ship_status := 'confirmed, in-transit or closed';
6263: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6264: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6265: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'released_status');
6266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6267: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6268: ELSE
6269: l_update_rel_status := 'Y';
6270:

Line 6267: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

6263: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_UPDATE_REQUEST');
6264: FND_MESSAGE.Set_Token('SHIP_STATUS', l_ship_status);
6265: FND_MESSAGE.Set_Token('UPDATE_ATTRIBUTE', 'released_status');
6266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6267: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
6268: ELSE
6269: l_update_rel_status := 'Y';
6270:
6271: -- start overpicking logic

Line 6352: IF l_rs = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

6348: WSH_DEBUG_SV.log(l_module_name,'chgd.attr picked.qty2 ', p_changed_attributes(l_counter).picked_quantity2);
6349: WSH_DEBUG_SV.log(l_module_name,'l_max_qty2 ', l_max_quantity2);
6350: END IF;
6351:
6352: IF l_rs = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
6353: IF l_debug_on THEN
6354: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET', WSH_DEBUG_SV.C_PROC_LEVEL);
6355: END IF;
6356: wsh_shipping_params_pvt.get(

Line 6378: IF l_ret_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

6374: WSH_DEBUG_SV.log(l_module_name,'l_process_flag',l_process_flag);
6375: END IF;
6376:
6377:
6378: IF l_ret_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
6379: l_retain_nonstaged_dd_param := nvl(l_ship_params.retain_nonstaged_det_flag,'N');
6380: IF ( l_process_flag = FND_API.G_FALSE AND l_retain_nonstaged_dd_param = 'Y') THEN
6381: -- muom
6382: IF l_fulfillment_base = 'P' THEN

Line 6400: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6396: l_new_req_quantity := LEAST(p_changed_attributes(l_counter).picked_quantity, l_avail_quantity);
6397: l_new_req_quantity2 := nvl(LEAST(p_changed_attributes(l_counter).picked_quantity2,l_avail_quantity2),0);
6398: END IF;
6399: ELSE
6400: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6401: l_new_req_quantity := NULL;
6402: l_new_req_quantity2 := NULL;
6403: END IF;
6404: ELSE

Line 6405: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6401: l_new_req_quantity := NULL;
6402: l_new_req_quantity2 := NULL;
6403: END IF;
6404: ELSE
6405: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6406: l_new_req_quantity := NULL;
6407: l_new_req_quantity2 := NULL;
6408: END IF;
6409: --Bug 7131800

Line 6487: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6483: FND_MESSAGE.Set_Name('WSH', 'WSH_REJECT_INV_REQUEST');
6484: FND_MESSAGE.Set_Token('TRANSACTION_TEMP_ID', l_transaction_temp_id);
6485: FND_MESSAGE.Set_Token('SERIAL_NUMBER', p_changed_attributes(l_counter).serial_number);
6486: FND_MESSAGE.Set_Token('PICKED_QUANTITY', p_changed_attributes(l_counter).picked_quantity);
6487: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6488: WSH_UTIL_CORE.Add_Message(x_return_status);
6489:
6490: END IF;
6491:

Line 6488: WSH_UTIL_CORE.Add_Message(x_return_status);

6484: FND_MESSAGE.Set_Token('TRANSACTION_TEMP_ID', l_transaction_temp_id);
6485: FND_MESSAGE.Set_Token('SERIAL_NUMBER', p_changed_attributes(l_counter).serial_number);
6486: FND_MESSAGE.Set_Token('PICKED_QUANTITY', p_changed_attributes(l_counter).picked_quantity);
6487: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6488: WSH_UTIL_CORE.Add_Message(x_return_status);
6489:
6490: END IF;
6491:
6492:

Line 6512: l_fulfillment_base := WSH_UTIL_CORE.Get_Line_Fulfillment_Base(old_delivery_detail_rec.source_code, old_delivery_detail_rec.source_line_id);

6508: --
6509:
6510: -- muom
6511: l_split_flag := 'Y';
6512: l_fulfillment_base := WSH_UTIL_CORE.Get_Line_Fulfillment_Base(old_delivery_detail_rec.source_code, old_delivery_detail_rec.source_line_id);
6513:
6514: -- bug 2120494
6515: -- This part handles backordering of lines in the case of under picking where
6516: -- the pending quantity is zero.

Line 6591: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

6587: IF l_debug_on THEN
6588: WSH_DEBUG_SV.logmsg(l_module_name, 'After calling Get_Global_Parameters: ' || l_return_status );
6589: END IF;
6590: --
6591: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6592: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6593: END IF;
6594: l_auto_consolidate := l_global_param_rec_type.consolidate_bo_lines;
6595: END IF;

Line 6592: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6588: WSH_DEBUG_SV.logmsg(l_module_name, 'After calling Get_Global_Parameters: ' || l_return_status );
6589: END IF;
6590: --
6591: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6592: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6593: END IF;
6594: l_auto_consolidate := l_global_param_rec_type.consolidate_bo_lines;
6595: END IF;
6596:

Line 6661: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

6657:
6658: IF l_debug_on THEN
6659: WSH_DEBUG_SV.log(l_module_name,'After calling CONSOLIDATE_SOURCE_LINE: ',l_return_status);
6660: END IF;
6661: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6662: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6663: END IF;
6664:
6665: IF ( l_cons_dd_ids(1) <> p_Changed_attributes(l_counter).delivery_detail_id ) THEN

Line 6662: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6658: IF l_debug_on THEN
6659: WSH_DEBUG_SV.log(l_module_name,'After calling CONSOLIDATE_SOURCE_LINE: ',l_return_status);
6660: END IF;
6661: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6662: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6663: END IF;
6664:
6665: IF ( l_cons_dd_ids(1) <> p_Changed_attributes(l_counter).delivery_detail_id ) THEN
6666: l_cons_flag := 'Y';

Line 6703: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

6699:
6700: -- Bug 3724578 : Return back to the caller if any error occures while
6701: -- splitting the delivery detail line
6702: --- Message will be set in Split_Delivery_Details
6703: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6704: x_return_status := l_return_status;
6705: return;
6706: END IF;
6707:

Line 6750: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

6746: -- muom
6747: x_split_quantity2 => l_dummy_quantity2,
6748: x_return_status => l_return_status
6749: );
6750: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6751: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6752: END IF;
6753: --End Bug# 5436033
6754: END IF;

Line 6751: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6747: x_split_quantity2 => l_dummy_quantity2,
6748: x_return_status => l_return_status
6749: );
6750: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6751: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6752: END IF;
6753: --End Bug# 5436033
6754: END IF;
6755: -- muom

Line 6886: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

6882: -- DBI API can only raise unexpected error, in that case need to
6883: -- pass it to the caller API for roll back of the whole transaction
6884: -- Only need to handle Unexpected error, rest are treated as success
6885: -- Since code is not proceeding, no need to reset x_return_status
6886: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
6887: x_return_status := l_dbi_rs;
6888: IF l_debug_on THEN
6889: WSH_DEBUG_SV.pop(l_module_name);
6890: END IF;

Line 6931: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

6927: x_net_weight => l_cont_net_weight,
6928: x_volume => l_cont_volume,
6929: x_cont_fill_pc => l_cont_fill_pc,
6930: x_return_status => x_return_status);
6931: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
6932: x_return_status := l_return_status;
6933: IF l_debug_on THEN
6934: WSH_DEBUG_SV.pop(l_module_name,'Container_Weight_Volume returned '||l_return_status);
6935: WSH_DEBUG_SV.pop(l_module_name);

Line 6963: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

6959: p_calc_wv_if_frozen => 'N',
6960: x_net_weight => l_net_weight,
6961: x_volume => l_volume,
6962: x_return_status => l_return_status);
6963: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
6964: x_return_status := l_return_status;
6965: IF l_debug_on THEN
6966: WSH_DEBUG_SV.pop(l_module_name,'Detail_Weight_Volume returned '||l_return_status);
6967: WSH_DEBUG_SV.pop(l_module_name);

Line 6994: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

6990: p_context => 'OVERPICK',
6991: x_return_status => l_return_status
6992: );
6993:
6994: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6995: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6996: END IF;
6997: END IF;
6998:

Line 6995: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6991: x_return_status => l_return_status
6992: );
6993:
6994: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
6995: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6996: END IF;
6997: END IF;
6998:
6999: END IF;

Line 7040: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

7036: x_return_status => l_return_status);
7037: IF l_debug_on THEN
7038: WSH_DEBUG_SV.log(l_module_name,'Delete_Details l_return_status',l_return_status);
7039: END IF;
7040: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
7041: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7042: END IF;
7043: END IF;
7044:

Line 7041: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

7037: IF l_debug_on THEN
7038: WSH_DEBUG_SV.log(l_module_name,'Delete_Details l_return_status',l_return_status);
7039: END IF;
7040: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
7041: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7042: END IF;
7043: END IF;
7044:
7045:

Line 7059: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

7055: IF l_debug_on THEN
7056: WSH_DEBUG_SV.log(l_module_name,'Adjust_Planned_Flag returns ',l_return_status);
7057: END IF;
7058:
7059: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
7060: raise Adjust_Planned_Flag_Err;
7061: ELSIF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_WARNING, WSH_UTIL_CORE.G_RET_STS_ERROR)) and
7062: x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
7063: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 7061: ELSIF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_WARNING, WSH_UTIL_CORE.G_RET_STS_ERROR)) and

7057: END IF;
7058:
7059: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
7060: raise Adjust_Planned_Flag_Err;
7061: ELSIF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_WARNING, WSH_UTIL_CORE.G_RET_STS_ERROR)) and
7062: x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
7063: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7064: END IF;
7065: END IF;

Line 7062: x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

7058:
7059: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
7060: raise Adjust_Planned_Flag_Err;
7061: ELSIF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_WARNING, WSH_UTIL_CORE.G_RET_STS_ERROR)) and
7062: x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
7063: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7064: END IF;
7065: END IF;
7066:

Line 7063: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

7059: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
7060: raise Adjust_Planned_Flag_Err;
7061: ELSIF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_WARNING, WSH_UTIL_CORE.G_RET_STS_ERROR)) and
7062: x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
7063: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7064: END IF;
7065: END IF;
7066:
7067:

Line 7072: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

7068: <>
7069: IF (l_multiple_update = 'Y') THEN
7070: update_inventory_info(l_changed_attributes, l_return_status);
7071: --bugfix 9726107 added warning condition
7072: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
7073: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7074: ELSIF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
7075: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7076: END IF;

Line 7073: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

7069: IF (l_multiple_update = 'Y') THEN
7070: update_inventory_info(l_changed_attributes, l_return_status);
7071: --bugfix 9726107 added warning condition
7072: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
7073: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7074: ELSIF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
7075: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7076: END IF;
7077:

Line 7074: ELSIF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

7070: update_inventory_info(l_changed_attributes, l_return_status);
7071: --bugfix 9726107 added warning condition
7072: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
7073: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7074: ELSIF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
7075: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7076: END IF;
7077:
7078: END IF;

Line 7075: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

7071: --bugfix 9726107 added warning condition
7072: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
7073: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
7074: ELSIF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
7075: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7076: END IF;
7077:
7078: END IF;
7079: --

Line 7098: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

7094: --
7095: EXCEPTION
7096: -- inbound logistics --jckwok
7097: WHEN Delivery_Line_Direction_Err THEN
7098: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7099: --
7100: -- LPN CONV rv
7101: WSH_WMS_LPN_GRP.g_caller := l_original_caller;
7102: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;

Line 7111: WSH_UTIL_CORE.add_message(l_return_status,l_module_name);

7107: END IF;
7108: -- deliveryMerge
7109: WHEN Adjust_Planned_Flag_Err THEN
7110: FND_MESSAGE.SET_NAME('WSH', 'WSH_ADJUST_PLANNED_FLAG_ERR');
7111: WSH_UTIL_CORE.add_message(l_return_status,l_module_name);
7112: x_return_status := l_return_status;
7113:
7114: --
7115: -- LPN CONV rv

Line 7127: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

7123: END IF;
7124: --
7125:
7126: WHEN others THEN
7127: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7128: wsh_util_core.default_handler('WSH_USA_INV_PVT.Update_Inventory_Info',l_module_name);
7129: --
7130: -- LPN CONV rv
7131: WSH_WMS_LPN_GRP.g_caller := l_original_caller;

Line 7128: wsh_util_core.default_handler('WSH_USA_INV_PVT.Update_Inventory_Info',l_module_name);

7124: --
7125:
7126: WHEN others THEN
7127: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7128: wsh_util_core.default_handler('WSH_USA_INV_PVT.Update_Inventory_Info',l_module_name);
7129: --
7130: -- LPN CONV rv
7131: WSH_WMS_LPN_GRP.g_caller := l_original_caller;
7132: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;

Line 7194: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

7190: WSH_DEBUG_SV.push(l_module_name);
7191: WSH_DEBUG_SV.log(l_module_name,'p_mo_line_id',p_mo_line_id);
7192: END IF;
7193:
7194: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7195:
7196: OPEN c_detailed_qty(p_mo_line_id);
7197: FETCH c_detailed_qty INTO l_detailed_qty, l_detailed_qty2;
7198: IF c_detailed_qty%NOTFOUND THEN

Line 7224: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

7220:
7221: EXCEPTION
7222:
7223: WHEN qty_not_found THEN
7224: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7225: IF c_detailed_qty%ISOPEN THEN
7226: CLOSE c_detailed_qty;
7227: END IF;
7228: IF l_debug_on THEN

Line 7243: wsh_util_core.default_handler('WSH_USA_INV_PVT.get_detailed_quantity',l_module_name);

7239: IF l_debug_on THEN
7240: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7241: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
7242: END IF;
7243: wsh_util_core.default_handler('WSH_USA_INV_PVT.get_detailed_quantity',l_module_name);
7244:
7245: END get_detailed_quantity;
7246:
7247: --

Line 7303: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_INV_PVT.is_mo_type_putaway',l_module_name);

7299: IF l_debug_on THEN
7300: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7301: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
7302: END IF;
7303: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_INV_PVT.is_mo_type_putaway',l_module_name);
7304: RETURN 'N';
7305:
7306: END is_mo_type_putaway;
7307:

Line 7350: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

7346: WSH_DEBUG_SV.log(l_module_name,'p_released_status',p_released_status);
7347: WSH_DEBUG_SV.log(l_module_name,'p_move_order_line_id',p_move_order_line_id);
7348: END IF;
7349:
7350: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7351: -- Check if released_status and move_order_line_id have been specified
7352: -- MOL can be null even if released status is specified.
7353: IF (p_detail_id is not null AND
7354: p_released_status IS NULL

Line 7392: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_INV_PVT.get_putaway_detail_id',l_module_name);

7388: IF c_get_line_details%ISOPEN THEN
7389: CLOSE c_get_line_details;
7390: END IF;
7391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7392: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_INV_PVT.get_putaway_detail_id',l_module_name);
7393: IF l_debug_on THEN
7394: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7395: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
7396: END IF;