APPS.OE_FREIGHT_RATING_PVT dependencies on FND_API

Line 100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

96: 'Get_List_Line_Type_Code'
97: );
98: END IF;
99:
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END Get_List_Line_Type_Code;
102:
103:
104: /*--------------------------------------------------------------+

Line 148: x_return_status := FND_API.G_RET_STS_SUCCESS;

144:
145: IF l_debug_level > 0 THEN
146: oe_debug_pub.add( 'ENTERING PROCEDURE PREPARE_ADJ_DETAIL.' , 3 ) ;
147: END IF;
148: x_return_status := FND_API.G_RET_STS_SUCCESS;
149:
150: select oe_price_adjustments_s.nextval into l_price_adjustment_id
151: from dual;
152:

Line 182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

178: END IF;
179:
180: EXCEPTION
181: WHEN OTHERS THEN
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
183: IF l_debug_level > 0 THEN
184: oe_debug_pub.add( 'ERROR IN PROCEDURE PREPARE_ADJ_DETAIL: '||SUBSTR ( SQLERRM , 1 , 240 ) , 3 ) ;
185: END IF;
186: IF l_debug_level > 0 THEN

Line 249: x_return_status := FND_API.G_RET_STS_SUCCESS;

245: BEGIN
246:
247: Print_Time('Entering OE_Freight_Rating_PVT.Process_FTE_Output..');
248:
249: x_return_status := FND_API.G_RET_STS_SUCCESS;
250:
251:
252: -- delete the old records from previous FTE call.
253: DELETE FROM OE_PRICE_ADJUSTMENTS

Line 495: WHEN FND_API.G_EXC_ERROR THEN

491: Print_Time('Entering OE_Freight_Rating_PVT.Process_FTE_Output..');
492:
493: EXCEPTION
494:
495: WHEN FND_API.G_EXC_ERROR THEN
496:
497: IF l_debug_level > 0 THEN
498: oe_debug_pub.add( 'EXPECTED ERROR IN PROCESS FTE OUTPUT' , 1 ) ;
499: END IF;

Line 501: x_return_status := FND_API.G_RET_STS_ERROR;

497: IF l_debug_level > 0 THEN
498: oe_debug_pub.add( 'EXPECTED ERROR IN PROCESS FTE OUTPUT' , 1 ) ;
499: END IF;
500:
501: x_return_status := FND_API.G_RET_STS_ERROR;
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504:
505: IF l_debug_level > 0 THEN

Line 503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

499: END IF;
500:
501: x_return_status := FND_API.G_RET_STS_ERROR;
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504:
505: IF l_debug_level > 0 THEN
506: oe_debug_pub.add( 'UNEXPECTED ERROR IN PROCESS FTE OUTPUT'|| SQLERRM , 2 ) ;
507: END IF;

Line 509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

505: IF l_debug_level > 0 THEN
506: oe_debug_pub.add( 'UNEXPECTED ERROR IN PROCESS FTE OUTPUT'|| SQLERRM , 2 ) ;
507: END IF;
508:
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510:
511: WHEN OTHERS THEN
512:
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510:
511: WHEN OTHERS THEN
512:
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514:
515: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
516: THEN
517: OE_MSG_PUB.Add_Exc_Msg