APPS.WSH_USA_QUANTITY_PVT dependencies on WSH_USA_QUANTITY_PVT

Line 1: PACKAGE BODY WSH_USA_QUANTITY_PVT as

1: PACKAGE BODY WSH_USA_QUANTITY_PVT as
2: /* $Header: WSHUSAQB.pls 120.11 2008/01/08 19:57:47 mvudugul noship $ */
3:
4:
5: --G_PACKAGE_NAME CONSTANT VARCHAR2(50) := 'WSH_USA_QUANTITY_PVT';

Line 5: --G_PACKAGE_NAME CONSTANT VARCHAR2(50) := 'WSH_USA_QUANTITY_PVT';

1: PACKAGE BODY WSH_USA_QUANTITY_PVT as
2: /* $Header: WSHUSAQB.pls 120.11 2008/01/08 19:57:47 mvudugul noship $ */
3:
4:
5: --G_PACKAGE_NAME CONSTANT VARCHAR2(50) := 'WSH_USA_QUANTITY_PVT';
6:
7: -- Forward declaration for the procedures to be used in update_ordered_quantity
8:
9: PROCEDURE log_exception(

Line 428: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_QUANTITY_PVT.UPDATE_ORDERED_QUANTITY, ACTION = '|| P_ACTION_FLAG );

424: --
425: -- Debug Statements
426: --
427: IF l_debug_on THEN
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;

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 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 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 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 2529: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_QUANTITY_PVT.CANCEL_QUANTITY ' );

2525: --
2526: -- Debug Statements
2527: --
2528: IF l_debug_on THEN
2529: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_QUANTITY_PVT.CANCEL_QUANTITY ' );
2530: END IF;
2531: --
2532: x_return_status := FND_API.G_RET_STS_SUCCESS;
2533:

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

Line 3375: END WSH_USA_QUANTITY_PVT;

3371: --
3372: END cancel_quantity;
3373:
3374:
3375: END WSH_USA_QUANTITY_PVT;