DBA Data[Home] [Help]

APPS.OE_SHIPPING_INTEGRATION_PUB dependencies on OE_SHIPPING_INTEGRATION_PUB

Line 1: PACKAGE BODY OE_Shipping_Integration_PUB AS

1: PACKAGE BODY OE_Shipping_Integration_PUB AS
2: /* $Header: OEXPSHPB.pls 120.2.12020000.3 2012/11/14 05:27:42 spothula ship $ */
3:
4: -- Global constant holding the package name
5:

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

2: /* $Header: OEXPSHPB.pls 120.2.12020000.3 2012/11/14 05:27:42 spothula ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Shipping_Integration_PUB';
7:
8: -- Start of Comments
9: -- API name OE_Shipping_Integration_PUB
10: -- Type Public

Line 9: -- API name OE_Shipping_Integration_PUB

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

Line 104: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.COMPLETE_SHIP_LINE_ACTIVITY '|| TO_CHAR ( P_LINE_ID ) ||' '||P_RESULT_CODE , 1 ) ;

100: BEGIN
101:
102: -- Standard call to check for call compatibility
103: IF l_debug_level > 0 THEN
104: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.COMPLETE_SHIP_LINE_ACTIVITY '|| TO_CHAR ( P_LINE_ID ) ||' '||P_RESULT_CODE , 1 ) ;
105: END IF;
106:
107: IF NOT FND_API.Compatible_API_Call
108: ( l_api_version_number

Line 137: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.COMPLETE_SHIP_LINE_ACTIVITY '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;

133:
134: x_return_status := FND_API.G_RET_STS_SUCCESS;
135:
136: IF l_debug_level > 0 THEN
137: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.COMPLETE_SHIP_LINE_ACTIVITY '|| TO_CHAR ( P_LINE_ID ) , 1 ) ;
138: END IF;
139: EXCEPTION
140:
141: WHEN FND_API.G_EXC_ERROR THEN

Line 392: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;

388: --
389: BEGIN
390:
391: IF l_debug_level > 0 THEN
392: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;
393: END IF;
394: -- Standard call to check for call compatibility
395: x_update_tolerance_flag := FND_API.G_FALSE;
396: x_ship_beyond_tolerance := FND_API.G_FALSE;

Line 667: OE_Shipping_Integration_PUB.Get_Quantity

663:
664: IF l_line_rec.line_set_id IS NOT NULL AND
665: l_line_rec.line_set_id <> FND_API.G_MISS_NUM THEN
666:
667: OE_Shipping_Integration_PUB.Get_Quantity
668: (
669: p_api_version_number => 1.0,
670: p_line_id => l_line_rec.line_id,
671: p_line_set_id => l_line_rec.line_set_id,

Line 855: OE_Shipping_Integration_PUB.Get_Quantity

851:
852: IF l_line_rec.line_set_id IS NOT NULL AND
853: l_line_rec.line_set_id <> FND_API.G_MISS_NUM THEN
854:
855: OE_Shipping_Integration_PUB.Get_Quantity
856: (
857: p_api_version_number => 1.0,
858: p_line_id => l_line_rec.line_id,
859: p_line_set_id => l_line_rec.line_set_id,

Line 913: oe_debug_pub.add( 'EXITING FROM OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;

909:
910:
911: x_return_status := FND_API.G_RET_STS_SUCCESS;
912: IF l_debug_level > 0 THEN
913: oe_debug_pub.add( 'EXITING FROM OE_SHIPPING_INTEGRATION_PUB.GET_TOLERANCE ' , 1 ) ;
914: END IF;
915:
916: EXCEPTION
917:

Line 999: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_QUANTITY '||TO_CHAR ( P_LINE_ID ) ||'/'||TO_CHAR ( P_LINE_SET_ID ) , 1 ) ;

995: BEGIN
996:
997: -- Standard call to check for call compatibility
998: IF l_debug_level > 0 THEN
999: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_QUANTITY '||TO_CHAR ( P_LINE_ID ) ||'/'||TO_CHAR ( P_LINE_SET_ID ) , 1 ) ;
1000: END IF;
1001:
1002: IF NOT FND_API.Compatible_API_Call
1003: ( l_api_version_number

Line 1027: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_QUANTITY ' , 1 ) ;

1023: x_shipping_quantity := l_x_shipping_quantity;
1024: x_return_status := FND_API.G_RET_STS_SUCCESS;
1025:
1026: IF l_debug_level > 0 THEN
1027: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_QUANTITY ' , 1 ) ;
1028: END IF;
1029: EXCEPTION
1030:
1031: WHEN NO_DATA_FOUND THEN

Line 1105: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;

1101: l_is_op_create VARCHAR2(1) := 'N';
1102: BEGIN
1103:
1104: IF l_debug_level > 0 THEN
1105: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;
1106: END IF;
1107:
1108: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
1109: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);

Line 1238: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SHIPPING_INTEGRATION_PUB IS:' || X_RETURN_STATUS ) ;

1234: p_line_id => p_line_id,
1235: x_index => l_index,
1236: x_return_status => x_return_status);
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SHIPPING_INTEGRATION_PUB IS:' || X_RETURN_STATUS ) ;
1239: END IF;
1240: IF l_debug_level > 0 THEN
1241: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
1242: END IF;

Line 1339: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;

1335: END IF; -- Firm flag
1336: END IF; -- IF OE_GLOBALS.G_ASO_INSTALLED = 'Y' or DBI installed.
1337:
1338: IF l_debug_level > 0 THEN
1339: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.UPDATE_SHIPPING_INTERFACE' , 1 ) ;
1340: END IF;
1341:
1342: x_return_status := FND_API.G_RET_STS_SUCCESS;
1343:

Line 1445: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY' , 1 ) ;

1441: --
1442: BEGIN
1443:
1444: IF l_debug_level > 0 THEN
1445: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY' , 1 ) ;
1446: END IF;
1447:
1448: x_return_status := FND_API.G_RET_STS_SUCCESS;
1449: /*

Line 1489: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY '||X_RETURN_STATUS , 1 ) ;

1485: oe_debug_pub.add( 'SHP RETURN MAX REMAINING QUANTITY2 : '||X_MAX_REMAINING_QUANTITY2 , 3 ) ;
1486: END IF;
1487:
1488: IF l_debug_level > 0 THEN
1489: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY '||X_RETURN_STATUS , 1 ) ;
1490: END IF;
1491:
1492: EXCEPTION
1493:

Line 1764: END OE_Shipping_Integration_PUB;

1760: p_setsmc_output_rec.x_interface_status := 'N';
1761:
1762: END Get_SetSMC_Interface_Status;
1763: -- 3623149 changes ends
1764: END OE_Shipping_Integration_PUB;
1765: