APPS.OE_FREIGHT_RATING_PVT dependencies on FND_API

Line 99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 147: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 248: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 494: WHEN FND_API.G_EXC_ERROR THEN

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

Line 500: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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