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

Line 386: l_details_id WSH_UTIL_CORE.Id_Tab_Type;

382: create_assignment_failure EXCEPTION;
383: reject_update EXCEPTION;
384: reject_delete EXCEPTION;
385:
386: l_details_id WSH_UTIL_CORE.Id_Tab_Type;
387: delete_detail_failure EXCEPTION;
388: invalid_smc_model_change EXCEPTION;
389: invalid_ship_set EXCEPTION;
390:

Line 393: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;

389: invalid_ship_set EXCEPTION;
390:
391: /* H projects: pricing integration csun */
392: i NUMBER := 0;
393: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;
394: mark_reprice_error EXCEPTION;
395: -- deliveryMerge
396: Adjust_Planned_Flag_Err EXCEPTION;
397:

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

394: mark_reprice_error EXCEPTION;
395: -- deliveryMerge
396: Adjust_Planned_Flag_Err EXCEPTION;
397:
398: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
399: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
400:
401: --OTM R12
402: l_split_delivery_detail_tab WSH_ENTITY_INFO_TAB;

Line 404: l_item_quantity_uom_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

400:
401: --OTM R12
402: l_split_delivery_detail_tab WSH_ENTITY_INFO_TAB;
403: l_split_delivery_detail_rec WSH_ENTITY_INFO_REC;
404: l_item_quantity_uom_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
405: l_gc3_is_installed VARCHAR2(1);
406:
407: -- OTM R12 : update requested quantity change
408: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 408: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

404: l_item_quantity_uom_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
405: l_gc3_is_installed VARCHAR2(1);
406:
407: -- OTM R12 : update requested quantity change
408: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
409: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
410: l_call_update VARCHAR2(1);
411: -- End of OTM R12 : update requested quantity change
412: --

Line 409: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

405: l_gc3_is_installed VARCHAR2(1);
406:
407: -- OTM R12 : update requested quantity change
408: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
409: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
410: l_call_update VARCHAR2(1);
411: -- End of OTM R12 : update requested quantity change
412: --
413: -- 5870774

Line 471: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

467: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_QUANTITY_PVT.UPDATE_ORDERED_QUANTITY, ACTION = '|| P_ACTION_FLAG );
468: END IF;
469: --
470:
471: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
472:
473: --OTM R12 initialize
474: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
475:

Line 474: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

470:
471: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
472:
473: --OTM R12 initialize
474: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
475:
476: IF (l_gc3_is_installed IS NULL) THEN
477: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
478: END IF;

Line 477: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

473: --OTM R12 initialize
474: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
475:
476: IF (l_gc3_is_installed IS NULL) THEN
477: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
478: END IF;
479:
480: IF (l_gc3_is_installed = 'Y') THEN
481: l_split_delivery_detail_tab := WSH_ENTITY_INFO_TAB();

Line 487: l_fulfillment_base := WSH_UTIL_CORE.Get_Line_Fulfillment_Base(p_source_code, p_changed_attribute.source_line_id);

483: END IF;
484: --
485:
486: -- muom
487: l_fulfillment_base := WSH_UTIL_CORE.Get_Line_Fulfillment_Base(p_source_code, p_changed_attribute.source_line_id);
488:
489: OPEN C_sum_req_quantity;
490: FETCH C_sum_req_quantity INTO l_original_ordered_quantity,l_original_ordered_quantity2;
491: CLOSE C_sum_req_quantity;

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

502: IF l_debug_on THEN
503: WSH_DEBUG_SV.log(l_module_name,'l_wh_type,l_return_status',l_wh_type||','||l_return_status);
504: END IF;
505:
506: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
507: x_return_status := l_return_status;
508: raise reject_update;
509: END IF;
510: -- TPW - Distributed Organization Changes - End

Line 801: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

797: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
798: p_delivery_detail_id => old_delivery_detail_rec.delivery_detail_id,
799: p_primary_quantity => 0, --- WMS will delete the records from replenishment table.
800: x_return_status => x_return_status);
801: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
802: --{
803: IF l_debug_on THEN
804: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR FROM WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL');
805: WSH_DEBUG_SV.pop(l_module_name);

Line 822: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR

818: IF l_debug_on THEN
819: WSH_DEBUG_SV.log(l_module_name,'WSH_INTERFACE.DELETE_DETAILS l_return_status',l_return_status);
820: END IF;
821:
822: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
823: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
824: raise delete_detail_failure;
825: END IF;
826:

Line 823: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

819: WSH_DEBUG_SV.log(l_module_name,'WSH_INTERFACE.DELETE_DETAILS l_return_status',l_return_status);
820: END IF;
821:
822: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
823: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
824: raise delete_detail_failure;
825: END IF;
826:
827:

Line 963: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

959:
960: IF l_debug_on THEN
961: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
962: END IF;
963: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
964: x_return_status := l_dbi_rs;
965: -- just pass this return status to caller API
966: IF l_debug_on THEN
967: WSH_DEBUG_SV.pop(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

Line 988: IF l_rs_ignored = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

984: x_net_weight => l_net_weight,
985: x_volume => l_volume,
986: x_return_status => l_rs_ignored);
987:
988: IF l_rs_ignored = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
989: x_return_status := l_rs_ignored;
990: IF l_debug_on THEN
991: WSH_DEBUG_SV.pop(l_module_name,'Detail_Weight_Volume returned '||l_return_status);
992: WSH_DEBUG_SV.pop(l_module_name);

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

1043: -- we will not fail based on l_return_status here because
1044: -- we do not want to stop the flow
1045: -- if the detail doesn't split, it will be caught later in
1046: -- delivery splitting and will have exception on the detail
1047: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1048: IF l_debug_on THEN
1049: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery detail split failed for ' || old_delivery_detail_rec.delivery_detail_id );
1050: END IF;
1051: END IF;

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

1081: p_delivery_id_tab => l_delivery_id_tab,
1082: p_tms_interface_flag_tab => l_interface_flag_tab,
1083: x_return_status => l_return_status);
1084:
1085: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1086: x_return_status := l_return_status;
1087: IF l_debug_on THEN
1088: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
1089: WSH_DEBUG_SV.pop(l_module_name);

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

1224: END IF;
1225:
1226:
1227:
1228: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1229: RAISE create_detail_failure;
1230: END IF;
1231: --
1232: -- Debug Statements

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

1256: l_dummy_id,l_return_status',l_dummy_rowid||','||
1257: l_dummy_id||','||l_return_status);
1258: END IF;
1259:
1260: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1261: RAISE create_assignment_failure;
1262: END IF;
1263:
1264: -- Bug 2349276 recalculate wt/vol if qty. changes - ignore return_status

Line 1276: IF l_rs_ignored = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

1272: WSH_DEBUG_SV.log(l_module_name,'Detail_Weight_Volume l_net_weight,l_volume,
1273: l_rs_ignored',l_net_weight||','||l_volume||','||l_rs_ignored);
1274: END IF;
1275: -- J: W/V Changes
1276: IF l_rs_ignored = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1277: x_return_status := l_rs_ignored;
1278: IF l_debug_on THEN
1279: WSH_DEBUG_SV.pop(l_module_name,'Detail_Weight_Volume returned '||l_return_status);
1280: WSH_DEBUG_SV.pop(l_module_name);

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

1327: -- we will not fail based on l_return_status here because
1328: -- we do not want to stop the flow
1329: -- if the detail doesn't split, it will be caught later in
1330: -- delivery splitting and will have exception on the detail
1331: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1332: IF l_debug_on THEN
1333: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery detail split failed for ' || l_dummy_delivery_detail_id );
1334: END IF;
1335: END IF;

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

1450: END IF;
1451: --
1452: x_return_status := l_return_status;
1453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1454: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1455: ELSE
1456: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.cancel_quantity',l_module_name);
1457: END IF;
1458: --

Line 1456: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.cancel_quantity',l_module_name);

1452: x_return_status := l_return_status;
1453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1454: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1455: ELSE
1456: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.cancel_quantity',l_module_name);
1457: END IF;
1458: --
1459: -- Debug Statements
1460: --

Line 1607: IF (l_return_status IN (FND_API.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

1603: WSH_DEBUG_SV.logmsg(l_module_name, 'LOGGING EXCEPTION FAILED WITH '||L_RETURN_STATUS );
1604: END IF;
1605: --
1606: x_return_status := l_return_status;
1607: IF (l_return_status IN (FND_API.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1608: FND_MESSAGE.SET_NAME('WSH', 'Error in logging exception');
1609: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1610: ELSE
1611: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.log_exception',l_module_name);

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

1605: --
1606: x_return_status := l_return_status;
1607: IF (l_return_status IN (FND_API.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1608: FND_MESSAGE.SET_NAME('WSH', 'Error in logging exception');
1609: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1610: ELSE
1611: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.log_exception',l_module_name);
1612: END IF;
1613: --

Line 1611: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.log_exception',l_module_name);

1607: IF (l_return_status IN (FND_API.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1608: FND_MESSAGE.SET_NAME('WSH', 'Error in logging exception');
1609: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1610: ELSE
1611: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.log_exception',l_module_name);
1612: END IF;
1613: --
1614: -- Debug Statements
1615: --

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

1679: END IF;
1680: --
1681: x_return_status := l_return_status;
1682: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1683: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1684: ELSE
1685: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.cancel_quantity',l_module_name);
1686: END IF;
1687: --

Line 1685: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.cancel_quantity',l_module_name);

1681: x_return_status := l_return_status;
1682: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1683: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1684: ELSE
1685: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.cancel_quantity',l_module_name);
1686: END IF;
1687: --
1688: -- Debug Statements
1689: --

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

1890: END IF;
1891: --
1892: x_return_status := FND_API.G_RET_STS_ERROR;
1893: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1894: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1895: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1896: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.delete_reservation',l_module_name);
1897: --END IF;
1898: --

Line 1896: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.delete_reservation',l_module_name);

1892: x_return_status := FND_API.G_RET_STS_ERROR;
1893: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1894: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1895: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1896: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.delete_reservation',l_module_name);
1897: --END IF;
1898: --
1899: -- Debug Statements
1900: --

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

1939: END IF;
1940: --
1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1943: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1944: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1945: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);
1946: --END IF;
1947: --

Line 1945: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);

1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1943: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1944: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1945: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);
1946: --END IF;
1947: --
1948: -- Debug Statements
1949: --

Line 1981: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1977: IF l_debug_on THEN
1978: WSH_DEBUG_SV.log(l_module_name,'Mark_Reprice_Required l_return_status',l_return_status);
1979: END IF;
1980:
1981: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1982: raise mark_reprice_error;
1983: END IF;
1984:
1985: -- deliveryMerge

Line 2000: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1996: IF l_debug_on THEN
1997: WSH_DEBUG_SV.log(l_module_name,'Adjust_Planned_Flag l_return_status',l_return_status);
1998: END IF;
1999:
2000: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2001: raise Adjust_Planned_Flag_Err;
2002: END IF;
2003:
2004:

Line 2012: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2008: WSH_DEBUG_SV.pop(l_module_name);
2009: END IF;
2010: EXCEPTION
2011: WHEN reject_update THEN
2012: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2013: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2014: IF l_debug_on THEN
2015: WSH_DEBUG_SV.logmsg(l_module_name,'REJECT_UPDATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2016: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REJECT_UPDATE');

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

2009: END IF;
2010: EXCEPTION
2011: WHEN reject_update THEN
2012: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2013: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2014: IF l_debug_on THEN
2015: WSH_DEBUG_SV.logmsg(l_module_name,'REJECT_UPDATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2016: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REJECT_UPDATE');
2017: END IF;

Line 2020: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2016: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REJECT_UPDATE');
2017: END IF;
2018: --
2019: WHEN reject_delete THEN
2020: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2021: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2022: IF l_debug_on THEN
2023: WSH_DEBUG_SV.logmsg(l_module_name,'REJECT_DELETE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2024: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REJECT_DELETE');

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

2017: END IF;
2018: --
2019: WHEN reject_delete THEN
2020: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2021: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2022: IF l_debug_on THEN
2023: WSH_DEBUG_SV.logmsg(l_module_name,'REJECT_DELETE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2024: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REJECT_DELETE');
2025: END IF;

Line 2028: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2024: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REJECT_DELETE');
2025: END IF;
2026: WHEN create_assignment_failure THEN
2027: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_CREATE_AS_FAILED');
2028: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2029: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2030: IF l_debug_on THEN
2031: WSH_DEBUG_SV.logmsg(l_module_name,'CREATE_ASSIGNMENT_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2032: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_ASSIGNMENT_FAILURE');

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

2025: END IF;
2026: WHEN create_assignment_failure THEN
2027: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_CREATE_AS_FAILED');
2028: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2029: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2030: IF l_debug_on THEN
2031: WSH_DEBUG_SV.logmsg(l_module_name,'CREATE_ASSIGNMENT_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2032: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_ASSIGNMENT_FAILURE');
2033: END IF;

Line 2037: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2033: END IF;
2034: --
2035: WHEN create_detail_failure THEN
2036: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_CREATE_DET_FAILED');
2037: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2038: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2039:
2040: IF l_debug_on THEN
2041: WSH_DEBUG_SV.logmsg(l_module_name,'CREATE_DETAIL_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

2034: --
2035: WHEN create_detail_failure THEN
2036: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_CREATE_DET_FAILED');
2037: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2038: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2039:
2040: IF l_debug_on THEN
2041: WSH_DEBUG_SV.logmsg(l_module_name,'CREATE_DETAIL_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2042: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_DETAIL_FAILURE');

Line 2046: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2042: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_DETAIL_FAILURE');
2043: END IF;
2044: WHEN delete_detail_failure THEN
2045: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_DELETE_DET_FAILED');
2046: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2047: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2048:
2049: IF l_debug_on THEN
2050: WSH_DEBUG_SV.logmsg(l_module_name,'DELETE_DETAIL_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

2043: END IF;
2044: WHEN delete_detail_failure THEN
2045: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_DELETE_DET_FAILED');
2046: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2047: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2048:
2049: IF l_debug_on THEN
2050: WSH_DEBUG_SV.logmsg(l_module_name,'DELETE_DETAIL_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2051: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELETE_DETAIL_FAILURE');

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

2052: END IF;
2053: WHEN mark_reprice_error THEN
2054: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
2055: x_return_status := l_return_status;
2056: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2057:
2058: IF l_debug_on THEN
2059: WSH_DEBUG_SV.logmsg(l_module_name,'MARK_REPRICE_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2060: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MARK_REPRICE_ERROR');

Line 2070: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2066: END IF;
2067: fnd_message.set_name('WSH', 'WSH_INVALID_SET_CHANGE');
2068: fnd_message.set_token('SHIP_SET',l_ship_set_name);
2069: fnd_message.set_token('LINE_NUMBER',p_changed_attribute.line_number);
2070: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2071: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2072: WHEN invalid_smc_model_change THEN
2073: fnd_message.set_name('WSH', 'WSH_INVALID_SMC_CHANGE');
2074: fnd_message.set_token('LINE_NUMBER',l_top_model_line_id);

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

2067: fnd_message.set_name('WSH', 'WSH_INVALID_SET_CHANGE');
2068: fnd_message.set_token('SHIP_SET',l_ship_set_name);
2069: fnd_message.set_token('LINE_NUMBER',p_changed_attribute.line_number);
2070: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2071: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2072: WHEN invalid_smc_model_change THEN
2073: fnd_message.set_name('WSH', 'WSH_INVALID_SMC_CHANGE');
2074: fnd_message.set_token('LINE_NUMBER',l_top_model_line_id);
2075: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2075: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2071: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2072: WHEN invalid_smc_model_change THEN
2073: fnd_message.set_name('WSH', 'WSH_INVALID_SMC_CHANGE');
2074: fnd_message.set_token('LINE_NUMBER',l_top_model_line_id);
2075: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2076: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2077: IF l_debug_on THEN
2078: WSH_DEBUG_SV.logmsg(l_module_name,'DELETE_DETAIL_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2079: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELETE_DETAIL_FAILURE');

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

2072: WHEN invalid_smc_model_change THEN
2073: fnd_message.set_name('WSH', 'WSH_INVALID_SMC_CHANGE');
2074: fnd_message.set_token('LINE_NUMBER',l_top_model_line_id);
2075: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2076: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2077: IF l_debug_on THEN
2078: WSH_DEBUG_SV.logmsg(l_module_name,'DELETE_DETAIL_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2079: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELETE_DETAIL_FAILURE');
2080: END IF;

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

2082:
2083:
2084: WHEN Adjust_Planned_Flag_Err THEN
2085: FND_MESSAGE.SET_NAME('WSH', 'WSH_ADJUST_PLANNED_FLAG_ERR');
2086: WSH_UTIL_CORE.add_message(l_return_status,l_module_name);
2087: x_return_status := l_return_status;
2088:
2089: IF l_debug_on THEN
2090: WSH_DEBUG_SV.logmsg(l_module_name,'Adjust_Planned_Flag_Err exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2105: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2101: IF (c_old_line_ser%ISOPEN) THEN
2102: CLOSE c_old_line_ser;
2103: END IF;
2104:
2105: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2106: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.Update_Ordered_Quantity',l_module_name);
2107: IF l_debug_on THEN
2108: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2109: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2106: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.Update_Ordered_Quantity',l_module_name);

2102: CLOSE c_old_line_ser;
2103: END IF;
2104:
2105: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2106: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.Update_Ordered_Quantity',l_module_name);
2107: IF l_debug_on THEN
2108: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2109: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2110: END IF;

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

2172: l_error_text VARCHAR2(6000);
2173:
2174: l_num_warn NUMBER := 0;
2175:
2176: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
2177: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
2178:
2179: --
2180: l_debug_on BOOLEAN;

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

2271: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ') ;
2272: END IF;
2273:
2274: x_return_status := FND_API.G_RET_STS_ERROR;
2275: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2276:
2277: IF l_debug_on THEN
2278: WSH_DEBUG_SV.pop(l_module_name);
2279: END IF;

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

2346: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
2347: l_error_text := '';
2348: END IF;
2349: x_return_status := FND_API.G_RET_STS_ERROR;
2350: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2351: --
2352: -- Debug Statements
2353: --
2354: IF l_debug_on THEN

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

2372: WSH_DEBUG_SV.log(l_module_name,'update_serial_numbers x_return_status',x_return_status);
2373: END IF;
2374: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2375: x_return_status := FND_API.G_RET_STS_ERROR;
2376: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2377: --
2378: -- Debug Statements
2379: --
2380: IF l_debug_on THEN

Line 2402: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2398: IF l_debug_on THEN
2399: WSH_DEBUG_SV.log(l_module_name,'Unassign_Detail_from_delivery x_return_status',x_return_status);
2400: END IF;
2401:
2402: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2403: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2404: --
2405: -- Debug Statements
2406: --

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

2399: WSH_DEBUG_SV.log(l_module_name,'Unassign_Detail_from_delivery x_return_status',x_return_status);
2400: END IF;
2401:
2402: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2403: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2404: --
2405: -- Debug Statements
2406: --
2407: IF l_debug_on THEN

Line 2466: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2462: IF l_debug_on THEN
2463: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
2464: END IF;
2465: -- Only Handle Unexpected error
2466: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2467: x_return_status := l_dbi_rs;
2468: --
2469: IF l_debug_on THEN
2470: WSH_DEBUG_SV.pop(l_module_name);

Line 2480: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2476: --
2477:
2478: /* Bug 2310456 warning handling */
2479: IF l_num_warn > 0 THEN
2480: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2481: -- in this API we treat warning as success as of now
2482: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2483: ELSE
2484: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2482: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2478: /* Bug 2310456 warning handling */
2479: IF l_num_warn > 0 THEN
2480: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2481: -- in this API we treat warning as success as of now
2482: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2483: ELSE
2484: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2485: END IF;
2486:

Line 2484: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2480: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2481: -- in this API we treat warning as success as of now
2482: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2483: ELSE
2484: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2485: END IF;
2486:
2487: --
2488: -- Debug Statements

Line 2514: WSH_UTIL_CORE.default_handler('WSH_INTERFACE.Handle_Overpick_cancelled',l_module_name);

2510: END IF;
2511: --
2512: WHEN OTHERS THEN
2513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2514: WSH_UTIL_CORE.default_handler('WSH_INTERFACE.Handle_Overpick_cancelled',l_module_name);
2515:
2516: --
2517: -- Debug Statements
2518: --

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

2628: --
2629: EXCEPTION
2630: WHEN logging_exception_failure THEN
2631: x_return_status := FND_API.G_RET_STS_ERROR;
2632: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2633: --
2634: -- Debug Statements
2635: --
2636: IF l_debug_on THEN

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

2731: l_num_warn NUMBER := 0;
2732:
2733: l_serial_quantity NUMBER := 0;
2734:
2735: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
2736: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
2737:
2738: /*2729687 Added l_details_id and l_return_status */
2739:

Line 2740: l_details_id WSH_UTIL_CORE.Id_Tab_Type;

2736: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
2737:
2738: /*2729687 Added l_details_id and l_return_status */
2739:
2740: l_details_id WSH_UTIL_CORE.Id_Tab_Type;
2741:
2742: l_return_status VARCHAR2(30);
2743:
2744: l_planned_flag VARCHAR2(1); -- Bug fix 2864546

Line 2749: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

2745:
2746: -- OTM R12 : cancel quantity
2747: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
2748: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
2749: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2750: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2751: l_call_update VARCHAR2(1);
2752: l_del_assigned VARCHAR2(1);
2753: l_gc3_is_installed VARCHAR2(1);

Line 2750: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

2746: -- OTM R12 : cancel quantity
2747: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
2748: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
2749: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2750: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2751: l_call_update VARCHAR2(1);
2752: l_del_assigned VARCHAR2(1);
2753: l_gc3_is_installed VARCHAR2(1);
2754: -- OTM R12 : cancel quantity

Line 2822: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

2818: --
2819: x_return_status := FND_API.G_RET_STS_SUCCESS;
2820:
2821: -- OTM R12
2822: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
2823:
2824: IF (l_gc3_is_installed IS NULL) THEN
2825: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
2826: END IF;

Line 2825: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

2821: -- OTM R12
2822: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
2823:
2824: IF (l_gc3_is_installed IS NULL) THEN
2825: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
2826: END IF;
2827: -- End of OTM R12
2828:
2829: -- Overpicking creates extra reservations.

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

2852: WSH_DEBUG_SV.log(l_module_name,'unreserve_delivery_detail x_return_status',x_return_status);
2853: END IF;
2854: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2855: x_return_status := FND_API.G_RET_STS_ERROR;
2856: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2857: --
2858: -- Debug Statements
2859: --
2860: IF l_debug_on THEN

Line 3014: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3010: p_delivery_detail_id => p_delivery_detail_id,
3011: -- muom
3012: p_primary_quantity => l_update_qty,
3013: x_return_status => x_return_status);
3014: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3015: --{
3016: IF l_debug_on THEN
3017: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR FROM WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL');
3018: WSH_DEBUG_SV.pop(l_module_name);

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

3063: p_delivery_id_tab => l_delivery_id_tab,
3064: p_tms_interface_flag_tab => l_interface_flag_tab,
3065: x_return_status => l_return_status);
3066:
3067: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3068:
3069: x_return_status := l_return_status;
3070: return;
3071: END IF;

Line 3095: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

3091:
3092: IF l_debug_on THEN
3093: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
3094: END IF;
3095: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3096: x_return_status := l_dbi_rs;
3097: -- just pass this return status to caller API
3098: IF l_debug_on THEN
3099: WSH_DEBUG_SV.pop(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

Line 3146: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

3142: x_net_weight => l_net,
3143: x_volume => l_volume,
3144: x_return_status => l_return_status);
3145:
3146: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3147: x_return_status := l_return_status;
3148: IF l_debug_on THEN
3149: WSH_DEBUG_SV.pop(l_module_name,'Detail_Weight_Volume returned '||l_return_status);
3150: WSH_DEBUG_SV.pop(l_module_name);

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

3238: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
3239: l_error_text := '';
3240: END IF;
3241: x_return_status := FND_API.G_RET_STS_ERROR;
3242: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3243: --
3244: -- Debug Statements
3245: --
3246: IF l_debug_on THEN

Line 3298: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3294: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
3295: p_delivery_detail_id => p_delivery_detail_id,
3296: p_primary_quantity => 0,
3297: x_return_status => x_return_status);
3298: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3299: --{
3300: IF l_debug_on THEN
3301: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR FROM WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL');
3302: WSH_DEBUG_SV.pop(l_module_name);

Line 3328: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

3324:
3325: IF l_debug_on THEN
3326: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
3327: END IF;
3328: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3329: x_return_status := l_dbi_rs;
3330: -- just pass this return status to caller API
3331: IF l_debug_on THEN
3332: WSH_DEBUG_SV.pop(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

Line 3351: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

3347: p_post_process_flag => 'Y',
3348: x_net_weight => l_net,
3349: x_volume => l_volume,
3350: x_return_status => l_return_status);
3351: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3352: x_return_status := l_return_status;
3353: IF l_debug_on THEN
3354: WSH_DEBUG_SV.pop(l_module_name,'Detail_Weight_Volume returned '||l_return_status);
3355: WSH_DEBUG_SV.pop(l_module_name);

Line 3381: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

3377: IF l_debug_on THEN
3378: WSH_DEBUG_SV.log(l_module_name,'Unassign_Unpack_Empty_cont x_return_status',x_return_status);
3379: END IF;
3380:
3381: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
3382: IF l_debug_on THEN
3383: WSH_DEBUG_SV.pop(l_module_name);
3384: END IF;
3385: return;

Line 3402: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

3398: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(p_delivery_detail_id,x_return_status);
3399: IF l_debug_on THEN
3400: WSH_DEBUG_SV.log(l_module_name,'Unassign_Detail_from_Cont x_return_status',x_return_status);
3401: END IF;
3402: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3403: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3404: --
3405: -- Debug Statements
3406: --

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

3399: IF l_debug_on THEN
3400: WSH_DEBUG_SV.log(l_module_name,'Unassign_Detail_from_Cont x_return_status',x_return_status);
3401: END IF;
3402: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3403: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3404: --
3405: -- Debug Statements
3406: --
3407: IF l_debug_on THEN

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

3478: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
3479: l_error_text := '';
3480: END IF;
3481: x_return_status := FND_API.G_RET_STS_ERROR;
3482: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3483: --
3484: -- Debug Statements
3485: --
3486: IF l_debug_on THEN

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

3554: END LOOP;
3555: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
3556: END IF;
3557: x_return_status := FND_API.G_RET_STS_ERROR;
3558: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3559: --
3560: -- Debug Statements
3561: --
3562: IF l_debug_on THEN

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

3611: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ' );
3612: END IF;
3613: --
3614: x_return_status := FND_API.G_RET_STS_ERROR;
3615: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3616: --
3617: -- Debug Statements
3618: --
3619: IF l_debug_on THEN

Line 3630: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS; --Bug# 3542353

3626: END IF; --}
3627:
3628: -- Debug Statements
3629:
3630: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS; --Bug# 3542353
3631: --
3632: -- HW OPMCONV - Removed code forking
3633:
3634: IF p_ordered_quantity <> 0 THEN --{

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

3696: WSH_DEBUG_SV.log(l_module_name,'Update_Serial_Numbers x_return_status',x_return_status);
3697: END IF;
3698: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3699: x_return_status := FND_API.G_RET_STS_ERROR;
3700: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3701: --
3702: -- Debug Statements
3703: --
3704: IF l_debug_on THEN

Line 3714: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3710: END IF; --}
3711:
3712: /* Bug 2310456 warning handling */
3713:
3714: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3715: --
3716: -- Debug Statements
3717: --
3718: IF l_debug_on THEN

Line 3722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3718: IF l_debug_on THEN
3719: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS ' );
3720: END IF;
3721: --
3722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3723: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3724: --
3725: -- Debug Statements
3726: --

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

3719: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS ' );
3720: END IF;
3721: --
3722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3723: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3724: --
3725: -- Debug Statements
3726: --
3727: IF l_debug_on THEN

Line 3734: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3730: --
3731: return;
3732: ELSIF l_num_warn > 0 THEN
3733: -- in this API we treat warning as success as of now
3734: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3735: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3736: --
3737: -- Debug Statements
3738: --

Line 3735: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3731: return;
3732: ELSIF l_num_warn > 0 THEN
3733: -- in this API we treat warning as success as of now
3734: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3735: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3736: --
3737: -- Debug Statements
3738: --
3739: IF l_debug_on THEN

Line 3765: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.CANCEL_QUANTITY',l_module_name);

3761: IF l_debug_on THEN
3762: WSH_DEBUG_SV.logmsg(l_module_name, SQLCODE || ' : ' || SQLERRM );
3763: END IF;
3764: --
3765: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.CANCEL_QUANTITY',l_module_name);
3766: --
3767: -- Debug Statements
3768: --
3769: IF l_debug_on THEN