APPS.OE_FREIGHT_RATING_UTIL dependencies on FND_NUMBER

Line 138: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);

134: IF l_debug_level > 0 THEN
135: oe_debug_pub.add( 'AFTER GETTING COST AMOUNT ' || TO_CHAR ( L_COST_AMOUNT ) , 3 ) ;
136: END IF;
137:
138: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);
139: ELSE
140: SELECT NVL(SUM(ADJUSTED_AMOUNT),0)
141: INTO l_cost_amount
142: FROM OE_PRICE_ADJUSTMENTS

Line 152: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);

148: IF l_debug_level > 0 THEN
149: oe_debug_pub.add( 'AFTER GETTING ESTIMATED COST AMOUNT ' || TO_CHAR ( L_COST_AMOUNT ) , 3 ) ;
150: END IF;
151:
152: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);
153: END IF;
154: ELSE
155: IF l_debug_level > 0 THEN
156: oe_debug_pub.add( 'LINE NOT SHIPPABLE OR IS NOT SHIPPED' , 3 ) ;

Line 170: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);

166: WHEN NO_DATA_FOUND THEN
167: IF l_debug_level > 0 THEN
168: oe_debug_pub.add( 'NO COST INFORMATION FOUND IN OE_PRICE_ADJUSTMENTS' ) ;
169: END IF;
170: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);
171:
172: WHEN OTHERS THEN
173:
174: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 335: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);

331: IF l_debug_level > 0 THEN
332: oe_debug_pub.add( 'AFTER GETTING ESTIMATED COST AMOUNT ' || TO_CHAR ( L_COST_AMOUNT ) , 3 ) ;
333: END IF;
334:
335: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);
336: ELSE
337: IF l_debug_level > 0 THEN
338: oe_debug_pub.add( 'LINE NOT SHIPPABLE ' , 3 ) ;
339: END IF;

Line 340: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);

336: ELSE
337: IF l_debug_level > 0 THEN
338: oe_debug_pub.add( 'LINE NOT SHIPPABLE ' , 3 ) ;
339: END IF;
340: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);
341:
342: END IF;
343: IF l_debug_level > 0 THEN
344: oe_debug_pub.add( 'LEAVING CHARGES' ) ;

Line 352: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);

348: WHEN NO_DATA_FOUND THEN
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( 'NO COST INFORMATION FOUND IN OE_PRICE_ADJUSTMENTS' ) ;
351: END IF;
352: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);
353:
354: WHEN OTHERS THEN
355:
356: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 474: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);

470:
471: IF l_debug_level > 0 THEN
472: oe_debug_pub.add( 'AFTER GETTING ESTIMATED COST AMOUNT ' || TO_CHAR ( L_COST_AMOUNT ) , 3 ) ;
473: END IF;
474: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);
475: IF l_debug_level > 0 THEN
476: oe_debug_pub.add( 'LEAVING CHARGES' ) ;
477: END IF;
478: EXCEPTION

Line 483: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);

479: WHEN NO_DATA_FOUND THEN
480: IF l_debug_level > 0 THEN
481: oe_debug_pub.add( 'NO COST INFORMATION FOUND IN OE_PRICE_ADJUSTMENTS' ) ;
482: END IF;
483: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);
484: WHEN OTHERS THEN
485: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
486: THEN
487: FND_MSG_PUB.Add_Exc_Msg