APPS.OE_FREIGHT_RATING_UTIL dependencies on FND_NUMBER

Line 137: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);

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

Line 151: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);

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

Line 169: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);

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

Line 334: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);

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

Line 339: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);

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

Line 351: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);

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

Line 473: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);

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

Line 482: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);

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