87: WHEN NO_DATA_FOUND THEN RETURN NULL;
88:
89: WHEN OTHERS THEN
90:
91: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
92: THEN
93: OE_MSG_PUB.Add_Exc_Msg
94: ( G_PKG_NAME ,
95: 'Get_Currency'
89: WHEN OTHERS THEN
90:
91: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
92: THEN
93: OE_MSG_PUB.Add_Exc_Msg
94: ( G_PKG_NAME ,
95: 'Get_Currency'
96: );
97: END IF;
164: EXCEPTION
165:
166: WHEN OTHERS THEN
167:
168: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
169: THEN
170: OE_MSG_PUB.Add_Exc_Msg
171: ( G_PKG_NAME ,
172: 'Get_Price_List'
166: WHEN OTHERS THEN
167:
168: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
169: THEN
170: OE_MSG_PUB.Add_Exc_Msg
171: ( G_PKG_NAME ,
172: 'Get_Price_List'
173: );
174: END IF;
431: return ll_currency_header_id;
432: end;
433:
434: when others then
435: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
436: THEN
437: OE_MSG_PUB.Add_Exc_Msg
438: ( G_PKG_NAME ,
439: 'Get_Currency_Header'
433:
434: when others then
435: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
436: THEN
437: OE_MSG_PUB.Add_Exc_Msg
438: ( G_PKG_NAME ,
439: 'Get_Currency_Header'
440: );
441: END IF;
495: WHEN NO_DATA_FOUND THEN RETURN NULL;
496:
497: WHEN OTHERS THEN
498:
499: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: OE_MSG_PUB.Add_Exc_Msg
502: ( G_PKG_NAME ,
503: 'Get_Rounding_Factor'
497: WHEN OTHERS THEN
498:
499: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: OE_MSG_PUB.Add_Exc_Msg
502: ( G_PKG_NAME ,
503: 'Get_Rounding_Factor'
504: );
505: END IF;
537: WHEN NO_DATA_FOUND THEN RETURN NULL;
538:
539: WHEN OTHERS THEN
540:
541: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
542: THEN
543: OE_MSG_PUB.Add_Exc_Msg
544: ( G_PKG_NAME ,
545: 'Get_Start_Date_Active'
539: WHEN OTHERS THEN
540:
541: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
542: THEN
543: OE_MSG_PUB.Add_Exc_Msg
544: ( G_PKG_NAME ,
545: 'Get_Start_Date_Active'
546: );
547: END IF;
712: -- Check number of iterations.
713:
714: IF p_iteration > QP_GLOBALS.G_MAX_DEF_ITERATIONS THEN
715:
716: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
717: THEN
718:
719: FND_MESSAGE.SET_NAME('QP','OE_DEF_MAX_ITERATION');
720: oe_msg_pub.Add;
716: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
717: THEN
718:
719: FND_MESSAGE.SET_NAME('QP','OE_DEF_MAX_ITERATION');
720: oe_msg_pub.Add;
721:
722: END IF;
723:
724: RAISE FND_API.G_EXC_ERROR;