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 358: l_details_id WSH_UTIL_CORE.Id_Tab_Type;

354: create_assignment_failure EXCEPTION;
355: reject_update EXCEPTION;
356: reject_delete EXCEPTION;
357:
358: l_details_id WSH_UTIL_CORE.Id_Tab_Type;
359: delete_detail_failure EXCEPTION;
360: invalid_smc_model_change EXCEPTION;
361: invalid_ship_set EXCEPTION;
362:

Line 365: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;

361: invalid_ship_set EXCEPTION;
362:
363: /* H projects: pricing integration csun */
364: i NUMBER := 0;
365: l_del_tab WSH_UTIL_CORE.Id_Tab_Type;
366: mark_reprice_error EXCEPTION;
367: -- deliveryMerge
368: Adjust_Planned_Flag_Err EXCEPTION;
369:

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

366: mark_reprice_error EXCEPTION;
367: -- deliveryMerge
368: Adjust_Planned_Flag_Err EXCEPTION;
369:
370: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
371: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
372:
373: --OTM R12
374: l_split_delivery_detail_tab WSH_ENTITY_INFO_TAB;

Line 376: l_item_quantity_uom_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

372:
373: --OTM R12
374: l_split_delivery_detail_tab WSH_ENTITY_INFO_TAB;
375: l_split_delivery_detail_rec WSH_ENTITY_INFO_REC;
376: l_item_quantity_uom_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
377: l_gc3_is_installed VARCHAR2(1);
378:
379: -- OTM R12 : update requested quantity change
380: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 380: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

376: l_item_quantity_uom_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
377: l_gc3_is_installed VARCHAR2(1);
378:
379: -- OTM R12 : update requested quantity change
380: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
381: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
382: l_call_update VARCHAR2(1);
383: -- End of OTM R12 : update requested quantity change
384: --

Line 381: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

377: l_gc3_is_installed VARCHAR2(1);
378:
379: -- OTM R12 : update requested quantity change
380: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
381: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
382: l_call_update VARCHAR2(1);
383: -- End of OTM R12 : update requested quantity change
384: --
385: -- 5870774

Line 432: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

428: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_QUANTITY_PVT.UPDATE_ORDERED_QUANTITY, ACTION = '|| P_ACTION_FLAG );
429: END IF;
430: --
431:
432: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
433:
434: --OTM R12 initialize
435: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
436:

Line 435: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

431:
432: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
433:
434: --OTM R12 initialize
435: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
436:
437: IF (l_gc3_is_installed IS NULL) THEN
438: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
439: END IF;

Line 438: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

434: --OTM R12 initialize
435: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
436:
437: IF (l_gc3_is_installed IS NULL) THEN
438: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
439: END IF;
440:
441: IF (l_gc3_is_installed = 'Y') THEN
442: l_split_delivery_detail_tab := WSH_ENTITY_INFO_TAB();

Line 702: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

698: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
699: p_delivery_detail_id => old_delivery_detail_rec.delivery_detail_id,
700: p_primary_quantity => 0, --- WMS will delete the records from replenishment table.
701: x_return_status => x_return_status);
702: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
703: --{
704: IF l_debug_on THEN
705: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR FROM WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL');
706: WSH_DEBUG_SV.pop(l_module_name);

Line 723: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR

719: IF l_debug_on THEN
720: WSH_DEBUG_SV.log(l_module_name,'WSH_INTERFACE.DELETE_DETAILS l_return_status',l_return_status);
721: END IF;
722:
723: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
724: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
725: raise delete_detail_failure;
726: END IF;
727:

Line 724: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

720: WSH_DEBUG_SV.log(l_module_name,'WSH_INTERFACE.DELETE_DETAILS l_return_status',l_return_status);
721: END IF;
722:
723: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
724: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
725: raise delete_detail_failure;
726: END IF;
727:
728:

Line 825: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

821:
822: IF l_debug_on THEN
823: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
824: END IF;
825: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
826: x_return_status := l_dbi_rs;
827: -- just pass this return status to caller API
828: IF l_debug_on THEN
829: WSH_DEBUG_SV.pop(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

Line 850: IF l_rs_ignored = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

846: x_net_weight => l_net_weight,
847: x_volume => l_volume,
848: x_return_status => l_rs_ignored);
849:
850: IF l_rs_ignored = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
851: x_return_status := l_rs_ignored;
852: IF l_debug_on THEN
853: WSH_DEBUG_SV.pop(l_module_name,'Detail_Weight_Volume returned '||l_return_status);
854: WSH_DEBUG_SV.pop(l_module_name);

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

905: -- we will not fail based on l_return_status here because
906: -- we do not want to stop the flow
907: -- if the detail doesn't split, it will be caught later in
908: -- delivery splitting and will have exception on the detail
909: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
910: IF l_debug_on THEN
911: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery detail split failed for ' || old_delivery_detail_rec.delivery_detail_id );
912: END IF;
913: END IF;

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

943: p_delivery_id_tab => l_delivery_id_tab,
944: p_tms_interface_flag_tab => l_interface_flag_tab,
945: x_return_status => l_return_status);
946:
947: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
948: x_return_status := l_return_status;
949: IF l_debug_on THEN
950: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
951: WSH_DEBUG_SV.pop(l_module_name);

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

1048: END IF;
1049:
1050:
1051:
1052: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1053: RAISE create_detail_failure;
1054: END IF;
1055: --
1056: -- Debug Statements

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

1080: l_dummy_id,l_return_status',l_dummy_rowid||','||
1081: l_dummy_id||','||l_return_status);
1082: END IF;
1083:
1084: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1085: RAISE create_assignment_failure;
1086: END IF;
1087:
1088: -- Bug 2349276 recalculate wt/vol if qty. changes - ignore return_status

Line 1100: IF l_rs_ignored = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

1096: WSH_DEBUG_SV.log(l_module_name,'Detail_Weight_Volume l_net_weight,l_volume,
1097: l_rs_ignored',l_net_weight||','||l_volume||','||l_rs_ignored);
1098: END IF;
1099: -- J: W/V Changes
1100: IF l_rs_ignored = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1101: x_return_status := l_rs_ignored;
1102: IF l_debug_on THEN
1103: WSH_DEBUG_SV.pop(l_module_name,'Detail_Weight_Volume returned '||l_return_status);
1104: WSH_DEBUG_SV.pop(l_module_name);

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

1151: -- we will not fail based on l_return_status here because
1152: -- we do not want to stop the flow
1153: -- if the detail doesn't split, it will be caught later in
1154: -- delivery splitting and will have exception on the detail
1155: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1156: IF l_debug_on THEN
1157: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery detail split failed for ' || l_dummy_delivery_detail_id );
1158: END IF;
1159: END IF;

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

1260: END IF;
1261: --
1262: x_return_status := l_return_status;
1263: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1264: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1265: ELSE
1266: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.cancel_quantity',l_module_name);
1267: END IF;
1268: --

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

1262: x_return_status := l_return_status;
1263: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1264: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1265: ELSE
1266: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.cancel_quantity',l_module_name);
1267: END IF;
1268: --
1269: -- Debug Statements
1270: --

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

1389: WSH_DEBUG_SV.logmsg(l_module_name, 'LOGGING EXCEPTION FAILED WITH '||L_RETURN_STATUS );
1390: END IF;
1391: --
1392: x_return_status := l_return_status;
1393: IF (l_return_status IN (FND_API.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1394: FND_MESSAGE.SET_NAME('WSH', 'Error in logging exception');
1395: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1396: ELSE
1397: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.log_exception',l_module_name);

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

1391: --
1392: x_return_status := l_return_status;
1393: IF (l_return_status IN (FND_API.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1394: FND_MESSAGE.SET_NAME('WSH', 'Error in logging exception');
1395: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1396: ELSE
1397: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.log_exception',l_module_name);
1398: END IF;
1399: --

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

1393: IF (l_return_status IN (FND_API.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1394: FND_MESSAGE.SET_NAME('WSH', 'Error in logging exception');
1395: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1396: ELSE
1397: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.log_exception',l_module_name);
1398: END IF;
1399: --
1400: -- Debug Statements
1401: --

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

1455: END IF;
1456: --
1457: x_return_status := l_return_status;
1458: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1459: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1460: ELSE
1461: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.cancel_quantity',l_module_name);
1462: END IF;
1463: --

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

1457: x_return_status := l_return_status;
1458: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1459: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1460: ELSE
1461: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.cancel_quantity',l_module_name);
1462: END IF;
1463: --
1464: -- Debug Statements
1465: --

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

1631: END IF;
1632: --
1633: x_return_status := FND_API.G_RET_STS_ERROR;
1634: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1635: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1636: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1637: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.delete_reservation',l_module_name);
1638: --END IF;
1639: --

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

1633: x_return_status := FND_API.G_RET_STS_ERROR;
1634: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1635: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1636: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1637: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.delete_reservation',l_module_name);
1638: --END IF;
1639: --
1640: -- Debug Statements
1641: --

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

1680: END IF;
1681: --
1682: x_return_status := FND_API.G_RET_STS_ERROR;
1683: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1684: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1685: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1686: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);
1687: --END IF;
1688: --

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

1682: x_return_status := FND_API.G_RET_STS_ERROR;
1683: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1684: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1685: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1686: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);
1687: --END IF;
1688: --
1689: -- Debug Statements
1690: --

Line 1722: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1718: IF l_debug_on THEN
1719: WSH_DEBUG_SV.log(l_module_name,'Mark_Reprice_Required l_return_status',l_return_status);
1720: END IF;
1721:
1722: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1723: raise mark_reprice_error;
1724: END IF;
1725:
1726: -- deliveryMerge

Line 1741: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1737: IF l_debug_on THEN
1738: WSH_DEBUG_SV.log(l_module_name,'Adjust_Planned_Flag l_return_status',l_return_status);
1739: END IF;
1740:
1741: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1742: raise Adjust_Planned_Flag_Err;
1743: END IF;
1744:
1745:

Line 1753: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1749: WSH_DEBUG_SV.pop(l_module_name);
1750: END IF;
1751: EXCEPTION
1752: WHEN reject_update THEN
1753: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1754: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1755: IF l_debug_on THEN
1756: WSH_DEBUG_SV.logmsg(l_module_name,'REJECT_UPDATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REJECT_UPDATE');

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

1750: END IF;
1751: EXCEPTION
1752: WHEN reject_update THEN
1753: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1754: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1755: IF l_debug_on THEN
1756: WSH_DEBUG_SV.logmsg(l_module_name,'REJECT_UPDATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REJECT_UPDATE');
1758: END IF;

Line 1761: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REJECT_UPDATE');
1758: END IF;
1759: --
1760: WHEN reject_delete THEN
1761: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1762: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1763: IF l_debug_on THEN
1764: WSH_DEBUG_SV.logmsg(l_module_name,'REJECT_DELETE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1765: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REJECT_DELETE');

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

1758: END IF;
1759: --
1760: WHEN reject_delete THEN
1761: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1762: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1763: IF l_debug_on THEN
1764: WSH_DEBUG_SV.logmsg(l_module_name,'REJECT_DELETE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1765: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REJECT_DELETE');
1766: END IF;

Line 1769: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1765: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:REJECT_DELETE');
1766: END IF;
1767: WHEN create_assignment_failure THEN
1768: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_CREATE_AS_FAILED');
1769: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1770: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1771: IF l_debug_on THEN
1772: WSH_DEBUG_SV.logmsg(l_module_name,'CREATE_ASSIGNMENT_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1773: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_ASSIGNMENT_FAILURE');

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

1766: END IF;
1767: WHEN create_assignment_failure THEN
1768: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_CREATE_AS_FAILED');
1769: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1770: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1771: IF l_debug_on THEN
1772: WSH_DEBUG_SV.logmsg(l_module_name,'CREATE_ASSIGNMENT_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1773: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_ASSIGNMENT_FAILURE');
1774: END IF;

Line 1778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1774: END IF;
1775: --
1776: WHEN create_detail_failure THEN
1777: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_CREATE_DET_FAILED');
1778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1779: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1780:
1781: IF l_debug_on THEN
1782: WSH_DEBUG_SV.logmsg(l_module_name,'CREATE_DETAIL_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

1775: --
1776: WHEN create_detail_failure THEN
1777: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_CREATE_DET_FAILED');
1778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1779: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1780:
1781: IF l_debug_on THEN
1782: WSH_DEBUG_SV.logmsg(l_module_name,'CREATE_DETAIL_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1783: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_DETAIL_FAILURE');

Line 1787: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1783: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_DETAIL_FAILURE');
1784: END IF;
1785: WHEN delete_detail_failure THEN
1786: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_DELETE_DET_FAILED');
1787: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1788: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1789:
1790: IF l_debug_on THEN
1791: WSH_DEBUG_SV.logmsg(l_module_name,'DELETE_DETAIL_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

1784: END IF;
1785: WHEN delete_detail_failure THEN
1786: FND_MESSAGE.Set_Name('WSH', 'WSH_DET_DELETE_DET_FAILED');
1787: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1788: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1789:
1790: IF l_debug_on THEN
1791: WSH_DEBUG_SV.logmsg(l_module_name,'DELETE_DETAIL_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1792: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELETE_DETAIL_FAILURE');

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

1793: END IF;
1794: WHEN mark_reprice_error THEN
1795: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
1796: x_return_status := l_return_status;
1797: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1798:
1799: IF l_debug_on THEN
1800: WSH_DEBUG_SV.logmsg(l_module_name,'MARK_REPRICE_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1801: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MARK_REPRICE_ERROR');

Line 1811: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1807: END IF;
1808: fnd_message.set_name('WSH', 'WSH_INVALID_SET_CHANGE');
1809: fnd_message.set_token('SHIP_SET',l_ship_set_name);
1810: fnd_message.set_token('LINE_NUMBER',p_changed_attribute.line_number);
1811: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1812: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1813: WHEN invalid_smc_model_change THEN
1814: fnd_message.set_name('WSH', 'WSH_INVALID_SMC_CHANGE');
1815: fnd_message.set_token('LINE_NUMBER',l_top_model_line_id);

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

1808: fnd_message.set_name('WSH', 'WSH_INVALID_SET_CHANGE');
1809: fnd_message.set_token('SHIP_SET',l_ship_set_name);
1810: fnd_message.set_token('LINE_NUMBER',p_changed_attribute.line_number);
1811: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1812: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1813: WHEN invalid_smc_model_change THEN
1814: fnd_message.set_name('WSH', 'WSH_INVALID_SMC_CHANGE');
1815: fnd_message.set_token('LINE_NUMBER',l_top_model_line_id);
1816: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1816: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1812: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1813: WHEN invalid_smc_model_change THEN
1814: fnd_message.set_name('WSH', 'WSH_INVALID_SMC_CHANGE');
1815: fnd_message.set_token('LINE_NUMBER',l_top_model_line_id);
1816: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1817: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1818: IF l_debug_on THEN
1819: WSH_DEBUG_SV.logmsg(l_module_name,'DELETE_DETAIL_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1820: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELETE_DETAIL_FAILURE');

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

1813: WHEN invalid_smc_model_change THEN
1814: fnd_message.set_name('WSH', 'WSH_INVALID_SMC_CHANGE');
1815: fnd_message.set_token('LINE_NUMBER',l_top_model_line_id);
1816: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1817: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1818: IF l_debug_on THEN
1819: WSH_DEBUG_SV.logmsg(l_module_name,'DELETE_DETAIL_FAILURE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1820: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELETE_DETAIL_FAILURE');
1821: END IF;

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

1823:
1824:
1825: WHEN Adjust_Planned_Flag_Err THEN
1826: FND_MESSAGE.SET_NAME('WSH', 'WSH_ADJUST_PLANNED_FLAG_ERR');
1827: WSH_UTIL_CORE.add_message(l_return_status,l_module_name);
1828: x_return_status := l_return_status;
1829:
1830: IF l_debug_on THEN
1831: WSH_DEBUG_SV.logmsg(l_module_name,'Adjust_Planned_Flag_Err exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1846: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1842: IF (c_old_line_ser%ISOPEN) THEN
1843: CLOSE c_old_line_ser;
1844: END IF;
1845:
1846: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1847: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.Update_Ordered_Quantity',l_module_name);
1848: IF l_debug_on THEN
1849: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1850: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

1843: CLOSE c_old_line_ser;
1844: END IF;
1845:
1846: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1847: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.Update_Ordered_Quantity',l_module_name);
1848: IF l_debug_on THEN
1849: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1850: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1851: END IF;

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

1908: l_error_text VARCHAR2(6000);
1909:
1910: l_num_warn NUMBER := 0;
1911:
1912: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
1913: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
1914:
1915: --
1916: l_debug_on BOOLEAN;

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

2006: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ') ;
2007: END IF;
2008:
2009: x_return_status := FND_API.G_RET_STS_ERROR;
2010: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2011:
2012: IF l_debug_on THEN
2013: WSH_DEBUG_SV.pop(l_module_name);
2014: END IF;

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

2081: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
2082: l_error_text := '';
2083: END IF;
2084: x_return_status := FND_API.G_RET_STS_ERROR;
2085: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2086: --
2087: -- Debug Statements
2088: --
2089: IF l_debug_on THEN

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

2107: WSH_DEBUG_SV.log(l_module_name,'update_serial_numbers x_return_status',x_return_status);
2108: END IF;
2109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2110: x_return_status := FND_API.G_RET_STS_ERROR;
2111: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2112: --
2113: -- Debug Statements
2114: --
2115: IF l_debug_on THEN

Line 2137: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2133: IF l_debug_on THEN
2134: WSH_DEBUG_SV.log(l_module_name,'Unassign_Detail_from_delivery x_return_status',x_return_status);
2135: END IF;
2136:
2137: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2138: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2139: --
2140: -- Debug Statements
2141: --

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

2134: WSH_DEBUG_SV.log(l_module_name,'Unassign_Detail_from_delivery x_return_status',x_return_status);
2135: END IF;
2136:
2137: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2138: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2139: --
2140: -- Debug Statements
2141: --
2142: IF l_debug_on THEN

Line 2201: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2197: IF l_debug_on THEN
2198: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
2199: END IF;
2200: -- Only Handle Unexpected error
2201: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2202: x_return_status := l_dbi_rs;
2203: --
2204: IF l_debug_on THEN
2205: WSH_DEBUG_SV.pop(l_module_name);

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

2211: --
2212:
2213: /* Bug 2310456 warning handling */
2214: IF l_num_warn > 0 THEN
2215: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2216: -- in this API we treat warning as success as of now
2217: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2218: ELSE
2219: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2217: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2213: /* Bug 2310456 warning handling */
2214: IF l_num_warn > 0 THEN
2215: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2216: -- in this API we treat warning as success as of now
2217: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2218: ELSE
2219: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2220: END IF;
2221:

Line 2219: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2215: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2216: -- in this API we treat warning as success as of now
2217: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2218: ELSE
2219: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2220: END IF;
2221:
2222: --
2223: -- Debug Statements

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

2245: END IF;
2246: --
2247: WHEN OTHERS THEN
2248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2249: WSH_UTIL_CORE.default_handler('WSH_INTERFACE.Handle_Overpick_cancelled',l_module_name);
2250:
2251: --
2252: -- Debug Statements
2253: --

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

2363: --
2364: EXCEPTION
2365: WHEN logging_exception_failure THEN
2366: x_return_status := FND_API.G_RET_STS_ERROR;
2367: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2368: --
2369: -- Debug Statements
2370: --
2371: IF l_debug_on THEN

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

2452: l_num_warn NUMBER := 0;
2453:
2454: l_serial_quantity NUMBER := 0;
2455:
2456: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
2457: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
2458:
2459: /*2729687 Added l_details_id and l_return_status */
2460:

Line 2461: l_details_id WSH_UTIL_CORE.Id_Tab_Type;

2457: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
2458:
2459: /*2729687 Added l_details_id and l_return_status */
2460:
2461: l_details_id WSH_UTIL_CORE.Id_Tab_Type;
2462:
2463: l_return_status VARCHAR2(30);
2464:
2465: l_planned_flag VARCHAR2(1); -- Bug fix 2864546

Line 2470: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

2466:
2467: -- OTM R12 : cancel quantity
2468: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
2469: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
2470: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2471: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2472: l_call_update VARCHAR2(1);
2473: l_del_assigned VARCHAR2(1);
2474: l_gc3_is_installed VARCHAR2(1);

Line 2471: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

2467: -- OTM R12 : cancel quantity
2468: l_ignore WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
2469: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
2470: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2471: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2472: l_call_update VARCHAR2(1);
2473: l_del_assigned VARCHAR2(1);
2474: l_gc3_is_installed VARCHAR2(1);
2475: -- OTM R12 : cancel quantity

Line 2535: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

2531: --
2532: x_return_status := FND_API.G_RET_STS_SUCCESS;
2533:
2534: -- OTM R12
2535: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
2536:
2537: IF (l_gc3_is_installed IS NULL) THEN
2538: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
2539: END IF;

Line 2538: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

2534: -- OTM R12
2535: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
2536:
2537: IF (l_gc3_is_installed IS NULL) THEN
2538: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
2539: END IF;
2540: -- End of OTM R12
2541:
2542: -- Overpicking creates extra reservations.

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

2564: WSH_DEBUG_SV.log(l_module_name,'unreserve_delivery_detail x_return_status',x_return_status);
2565: END IF;
2566: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2567: x_return_status := FND_API.G_RET_STS_ERROR;
2568: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2569: --
2570: -- Debug Statements
2571: --
2572: IF l_debug_on THEN

Line 2646: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2642: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
2643: p_delivery_detail_id => p_delivery_detail_id,
2644: p_primary_quantity => (p_requested_quantity - ABS(p_changed_detail_quantity)),
2645: x_return_status => x_return_status);
2646: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2647: --{
2648: IF l_debug_on THEN
2649: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR FROM WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL');
2650: WSH_DEBUG_SV.pop(l_module_name);

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

2693: p_delivery_id_tab => l_delivery_id_tab,
2694: p_tms_interface_flag_tab => l_interface_flag_tab,
2695: x_return_status => l_return_status);
2696:
2697: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2698:
2699: x_return_status := l_return_status;
2700: return;
2701: END IF;

Line 2725: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2721:
2722: IF l_debug_on THEN
2723: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
2724: END IF;
2725: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2726: x_return_status := l_dbi_rs;
2727: -- just pass this return status to caller API
2728: IF l_debug_on THEN
2729: WSH_DEBUG_SV.pop(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

Line 2763: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

2759: x_net_weight => l_net,
2760: x_volume => l_volume,
2761: x_return_status => l_return_status);
2762:
2763: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2764: x_return_status := l_return_status;
2765: IF l_debug_on THEN
2766: WSH_DEBUG_SV.pop(l_module_name,'Detail_Weight_Volume returned '||l_return_status);
2767: WSH_DEBUG_SV.pop(l_module_name);

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

2838: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
2839: l_error_text := '';
2840: END IF;
2841: x_return_status := FND_API.G_RET_STS_ERROR;
2842: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2843: --
2844: -- Debug Statements
2845: --
2846: IF l_debug_on THEN

Line 2898: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2894: WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL (
2895: p_delivery_detail_id => p_delivery_detail_id,
2896: p_primary_quantity => 0,
2897: x_return_status => x_return_status);
2898: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2899: --{
2900: IF l_debug_on THEN
2901: WSH_DEBUG_SV.logmsg(l_module_name, 'UNEXPECTED ERROR FROM WMS_REPLENISHMENT_PUB.UPDATE_DELIVERY_DETAIL');
2902: WSH_DEBUG_SV.pop(l_module_name);

Line 2928: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2924:
2925: IF l_debug_on THEN
2926: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
2927: END IF;
2928: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2929: x_return_status := l_dbi_rs;
2930: -- just pass this return status to caller API
2931: IF l_debug_on THEN
2932: WSH_DEBUG_SV.pop(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

Line 2951: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

2947: p_post_process_flag => 'Y',
2948: x_net_weight => l_net,
2949: x_volume => l_volume,
2950: x_return_status => l_return_status);
2951: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2952: x_return_status := l_return_status;
2953: IF l_debug_on THEN
2954: WSH_DEBUG_SV.pop(l_module_name,'Detail_Weight_Volume returned '||l_return_status);
2955: WSH_DEBUG_SV.pop(l_module_name);

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

2977: IF l_debug_on THEN
2978: WSH_DEBUG_SV.log(l_module_name,'Unassign_Unpack_Empty_cont x_return_status',x_return_status);
2979: END IF;
2980:
2981: IF (x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
2982: IF l_debug_on THEN
2983: WSH_DEBUG_SV.pop(l_module_name);
2984: END IF;
2985: return;

Line 3002: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

2998: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont(p_delivery_detail_id,x_return_status);
2999: IF l_debug_on THEN
3000: WSH_DEBUG_SV.log(l_module_name,'Unassign_Detail_from_Cont x_return_status',x_return_status);
3001: END IF;
3002: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3003: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3004: --
3005: -- Debug Statements
3006: --

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

2999: IF l_debug_on THEN
3000: WSH_DEBUG_SV.log(l_module_name,'Unassign_Detail_from_Cont x_return_status',x_return_status);
3001: END IF;
3002: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3003: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3004: --
3005: -- Debug Statements
3006: --
3007: IF l_debug_on THEN

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

3078: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
3079: l_error_text := '';
3080: END IF;
3081: x_return_status := FND_API.G_RET_STS_ERROR;
3082: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3083: --
3084: -- Debug Statements
3085: --
3086: IF l_debug_on THEN

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

3154: END LOOP;
3155: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
3156: END IF;
3157: x_return_status := FND_API.G_RET_STS_ERROR;
3158: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3159: --
3160: -- Debug Statements
3161: --
3162: IF l_debug_on THEN

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

3209: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ' );
3210: END IF;
3211: --
3212: x_return_status := FND_API.G_RET_STS_ERROR;
3213: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3214: --
3215: -- Debug Statements
3216: --
3217: IF l_debug_on THEN

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

3224: END IF;
3225:
3226: -- Debug Statements
3227:
3228: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS; --Bug# 3542353
3229: --
3230: -- HW OPMCONV - Removed code forking
3231:
3232: IF p_ordered_quantity <> 0 THEN

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

3294: WSH_DEBUG_SV.log(l_module_name,'Update_Serial_Numbers x_return_status',x_return_status);
3295: END IF;
3296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3297: x_return_status := FND_API.G_RET_STS_ERROR;
3298: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3299: --
3300: -- Debug Statements
3301: --
3302: IF l_debug_on THEN

Line 3312: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3308: END IF;
3309:
3310: /* Bug 2310456 warning handling */
3311:
3312: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3313: --
3314: -- Debug Statements
3315: --
3316: IF l_debug_on THEN

Line 3320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3316: IF l_debug_on THEN
3317: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS ' );
3318: END IF;
3319: --
3320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3321: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3322: --
3323: -- Debug Statements
3324: --

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

3317: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS ' );
3318: END IF;
3319: --
3320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3321: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3322: --
3323: -- Debug Statements
3324: --
3325: IF l_debug_on THEN

Line 3332: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3328: --
3329: return;
3330: ELSIF l_num_warn > 0 THEN
3331: -- in this API we treat warning as success as of now
3332: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3333: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3334: --
3335: -- Debug Statements
3336: --

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

3329: return;
3330: ELSIF l_num_warn > 0 THEN
3331: -- in this API we treat warning as success as of now
3332: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3333: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3334: --
3335: -- Debug Statements
3336: --
3337: IF l_debug_on THEN

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

3359: IF l_debug_on THEN
3360: WSH_DEBUG_SV.logmsg(l_module_name, SQLCODE || ' : ' || SQLERRM );
3361: END IF;
3362: --
3363: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.CANCEL_QUANTITY',l_module_name);
3364: --
3365: -- Debug Statements
3366: --
3367: IF l_debug_on THEN