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.14.12020000.10 2013/04/29 07:35:51 adagur ship $ */
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.14.12020000.10 2013/04/29 07:35:51 adagur ship $ */
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 467: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_QUANTITY_PVT.UPDATE_ORDERED_QUANTITY, ACTION = '|| P_ACTION_FLAG );

463: --
464: -- Debug Statements
465: --
466: IF l_debug_on THEN
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;

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

2812: --
2813: -- Debug Statements
2814: --
2815: IF l_debug_on THEN
2816: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_QUANTITY_PVT.CANCEL_QUANTITY ' );
2817: END IF;
2818: --
2819: x_return_status := FND_API.G_RET_STS_SUCCESS;
2820:

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

Line 3777: END WSH_USA_QUANTITY_PVT;

3773: --
3774: END cancel_quantity;
3775:
3776:
3777: END WSH_USA_QUANTITY_PVT;