DBA Data[Home] [Help]

APPS.OE_SHIPPING_TOLERANCES_PUB dependencies on FND_API

Line 87: x_return_status := FND_API.G_RET_STS_SUCCESS;

83: IF l_debug_level > 0 THEN
84: oe_debug_pub.add( 'ENTERING OE_SHIPPING_TOLERANCES_PUB.GET_MIN_MAX_TOLERANCE_QUANTITY' , 1 ) ;
85: END IF;
86:
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88: /*
89: IF NOT FND_API.Compatible_API_Call
90: ( l_api_version_number
91: , p_api_version_number

Line 89: IF NOT FND_API.Compatible_API_Call

85: END IF;
86:
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88: /*
89: IF NOT FND_API.Compatible_API_Call
90: ( l_api_version_number
91: , p_api_version_number
92: , l_api_name
93: , G_PKG_NAME

Line 96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

92: , l_api_name
93: , G_PKG_NAME
94: )
95: THEN
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: END IF;
98: */
99: -- HW OPM retrieve qty2 for OPM
100: SELECT ship_tolerance_below,

Line 378: x_return_status := FND_API.G_RET_STS_ERROR;

374: x_max_remaining_quantity2 := 0;
375:
376: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
377: THEN
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END IF;
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382:

Line 381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

377: THEN
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END IF;
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382:
383: IF l_debug_level > 0 THEN
384: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
385: END IF;

Line 386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

382:
383: IF l_debug_level > 0 THEN
384: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
385: END IF;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
387:
388: -- Get message count and data
389:
390: FND_MSG_PUB.Count_And_Get

Line 400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

396:
397: IF l_debug_level > 0 THEN
398: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
399: END IF;
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
401:
402: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
403: THEN
404: FND_MSG_PUB.Add_Exc_Msg

Line 444: x_return_status := FND_API.G_RET_STS_SUCCESS;

440: IF l_debug_level > 0 THEN
441: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PUB.GET_MIN_MAX_QUANTITY_UOM' , 1 ) ;
442: END IF;
443:
444: x_return_status := FND_API.G_RET_STS_SUCCESS;
445:
446: OE_Shipping_Tolerances_PUB.Get_Min_Max_Tolerance_Quantity
447: (
448: p_api_version_number => p_api_version_number,

Line 504: x_return_status := FND_API.G_RET_STS_ERROR;

500: x_quantity_uom2 := '';
501:
502: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
503: THEN
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: END IF;
506:
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508:

Line 507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

503: THEN
504: x_return_status := FND_API.G_RET_STS_ERROR;
505: END IF;
506:
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508:
509: IF l_debug_level > 0 THEN
510: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
511: END IF;

Line 512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

508:
509: IF l_debug_level > 0 THEN
510: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
511: END IF;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513:
514: -- Get message count and data
515:
516: FND_MSG_PUB.Count_And_Get

Line 526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

522:
523: IF l_debug_level > 0 THEN
524: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
525: END IF;
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
527:
528: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
529: THEN
530: FND_MSG_PUB.Add_Exc_Msg