DBA Data[Home] [Help]

APPS.OE_SHIPPING_INTEGRATION_PVT dependencies on OE_SHIPPING_INTEGRATION_PVT

Line 1: PACKAGE BODY OE_Shipping_Integration_PVT AS

1: PACKAGE BODY OE_Shipping_Integration_PVT AS
2: /* $Header: OEXVSHPB.pls 120.19.12010000.2 2008/11/18 13:41:40 smusanna ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Shipping_Integration_PVT';

2: /* $Header: OEXVSHPB.pls 120.19.12010000.2 2008/11/18 13:41:40 smusanna ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Shipping_Integration_PVT';
7:
8: -- Start of Comments
9: -- API name OE_Shipping_Integration_PVT
10: -- Type Private

Line 9: -- API name OE_Shipping_Integration_PVT

5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Shipping_Integration_PVT';
7:
8: -- Start of Comments
9: -- API name OE_Shipping_Integration_PVT
10: -- Type Private
11: -- Version Current version = 1.0
12: -- Initial version = 1.0
13:

Line 1565: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PVT.UPDATE_SHIPPING_PVT' , 1 ) ;

1561: --
1562: BEGIN
1563:
1564: IF l_debug_level > 0 THEN
1565: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PVT.UPDATE_SHIPPING_PVT' , 1 ) ;
1566: END IF;
1567: IF g_debug_call > 0 THEN
1568: G_DEBUG_MSG := G_DEBUG_MSG || '51,';
1569: END IF;

Line 1603: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PVT.UPDATE_SHIPPING_PVT' , 1 ) ;

1599: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1600: RAISE FND_API.G_EXC_ERROR;
1601: END IF;
1602: IF l_debug_level > 0 THEN
1603: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PVT.UPDATE_SHIPPING_PVT' , 1 ) ;
1604: END IF;
1605: IF g_debug_call > 0 THEN
1606: G_DEBUG_MSG := G_DEBUG_MSG || '54,';
1607: END IF;

Line 1682: ('ENTERING OE_SHIPPING_INTEGRATION_PVT.CHECK_SHIPMENT_LINE : '

1678: BEGIN
1679:
1680: IF l_debug_level > 0 THEN
1681: oe_debug_pub.add
1682: ('ENTERING OE_SHIPPING_INTEGRATION_PVT.CHECK_SHIPMENT_LINE : '
1683: ||TO_CHAR ( P_LINE_REC.LINE_ID ) ||'/'||TO_CHAR ( P_SHIPPED_QUANTITY )
1684: ||'/'||P_LINE_REC.ITEM_TYPE_CODE , 1 ) ;
1685: END IF;
1686: IF g_debug_call > 0 THEN

Line 2129: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PVT.GET_PTO_SHIPPED_QUANTITY '|| TO_CHAR ( P_TOP_MODEL_LINE_ID ) , 1 ) ;

2125: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2126: --
2127: BEGIN
2128: IF l_debug_level > 0 THEN
2129: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PVT.GET_PTO_SHIPPED_QUANTITY '|| TO_CHAR ( P_TOP_MODEL_LINE_ID ) , 1 ) ;
2130: END IF;
2131:
2132: IF p_top_model_line_id IS NOT NULL AND
2133: p_top_model_line_id <> FND_API.G_MISS_NUM THEN

Line 2433: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PVT.GET_PTO_SHIPPED_QUANTITY ' , 1 ) ;

2429: x_ratio_status := l_ratio_status;
2430: x_return_status := FND_API.G_RET_STS_SUCCESS;
2431:
2432: IF l_debug_level > 0 THEN
2433: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PVT.GET_PTO_SHIPPED_QUANTITY ' , 1 ) ;
2434: END IF;
2435: EXCEPTION
2436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3999: oe_debug_pub.add('ENTERING OE_SHIPPING_INTEGRATION_PVT.SHIP_CONFIRM_ATO '

3995: --
3996: BEGIN
3997:
3998: IF l_debug_level > 0 THEN
3999: oe_debug_pub.add('ENTERING OE_SHIPPING_INTEGRATION_PVT.SHIP_CONFIRM_ATO '
4000: || TO_CHAR ( P_LINE_ID ) , 1 ) ;
4001: END IF;
4002:
4003: l_line_id := p_line_id;

Line 4233: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PVT.SHIP_CONFIRM_SHIP_SET '|| TO_CHAR ( P_SHIP_SET_ID ) , 1 ) ;

4229: --
4230: BEGIN
4231:
4232: IF l_debug_level > 0 THEN
4233: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PVT.SHIP_CONFIRM_SHIP_SET '|| TO_CHAR ( P_SHIP_SET_ID ) , 1 ) ;
4234: END IF;
4235:
4236: IF g_debug_call > 0 THEN
4237: G_DEBUG_MSG := G_DEBUG_MSG || '11-1';

Line 4472: oe_debug_pub.add( 'EXITING FROM OE_SHIPPING_INTEGRATION_PVT.SHIP_CONFIRM_SHIP_SET : '||X_RETURN_STATUS , 1 ) ;

4468:
4469: x_return_status := l_return_status;
4470:
4471: IF l_debug_level > 0 THEN
4472: oe_debug_pub.add( 'EXITING FROM OE_SHIPPING_INTEGRATION_PVT.SHIP_CONFIRM_SHIP_SET : '||X_RETURN_STATUS , 1 ) ;
4473: END IF;
4474: IF g_debug_call > 0 THEN
4475: G_DEBUG_MSG := G_DEBUG_MSG || '11-9';
4476: END IF;

Line 4544: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PVT.PROCESS_SHIP_CONFIRM '|| P_PROCESS_TYPE , 1 ) ;

4540: --
4541: BEGIN
4542:
4543: IF l_debug_level > 0 THEN
4544: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PVT.PROCESS_SHIP_CONFIRM '|| P_PROCESS_TYPE , 1 ) ;
4545: END IF;
4546:
4547: -- Setting the Global variable OE_GLOBALS.G_RECURSION_MODE to Y so that the
4548: -- Price request for "SHIP" event is not triggered before COST records are

Line 4641: oe_debug_pub.add( 'RETURNED FROM OE_SHIPPING_INTEGRATION_PVT.PROCESS_SHIP_CONFIRM '|| X_RETURN_STATUS , 1 ) ;

4637: null;
4638: END IF;
4639:
4640: IF l_debug_level > 0 THEN
4641: oe_debug_pub.add( 'RETURNED FROM OE_SHIPPING_INTEGRATION_PVT.PROCESS_SHIP_CONFIRM '|| X_RETURN_STATUS , 1 ) ;
4642: END IF;
4643:
4644: EXCEPTION
4645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6285: END OE_Shipping_Integration_PVT;

6281: RAISE;
6282: END ship_complete;
6283:
6284:
6285: END OE_Shipping_Integration_PVT;