215: IF l_debug_level > 0 THEN
216: OE_DEBUG_PUB.Add('Other Exception in TSO_GRP.Get_MACD_Action_Mode'
217: ||sqlerrm,1);
218: END IF;
219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
220: OE_MSG_PUB.Add_Exc_Msg
221: ( G_PKG_NAME
222: ,'Get_MACD_Action_Mode' );
223: END IF;
216: OE_DEBUG_PUB.Add('Other Exception in TSO_GRP.Get_MACD_Action_Mode'
217: ||sqlerrm,1);
218: END IF;
219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
220: OE_MSG_PUB.Add_Exc_Msg
221: ( G_PKG_NAME
222: ,'Get_MACD_Action_Mode' );
223: END IF;
224:
260: OE_DEBUG_PUB.Add('Null org id',3);
261: END IF;
262:
263: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
264: OE_MSG_PUB.Add;
265: RAISE FND_API.G_EXC_ERROR;
266: END IF;
267:
268: IF l_debug_level > 0 THEN
294: x_return_status := FND_API.G_RET_STS_ERROR;
295:
296: -- Get message count and data
297:
298: OE_MSG_PUB.Count_And_Get
299: ( p_count => x_msg_count
300: , p_data => x_msg_data
301: );
302:
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
306:
307: -- Get message count and data
308:
309: OE_MSG_PUB.Count_And_Get
310: ( p_count => x_msg_count
311: , p_data => x_msg_data
312: );
313: WHEN OTHERS THEN
315: IF l_debug_level > 0 THEN
316: OE_DEBUG_PUB.Add('Other Exception in TSO_GRP.Process_MACD_Order'
317: ||sqlerrm,1);
318: END IF;
319: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
320: OE_MSG_PUB.Add_Exc_Msg
321: ( G_PKG_NAME
322: ,'Process_MACD_Order' );
323: END IF;
316: OE_DEBUG_PUB.Add('Other Exception in TSO_GRP.Process_MACD_Order'
317: ||sqlerrm,1);
318: END IF;
319: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
320: OE_MSG_PUB.Add_Exc_Msg
321: ( G_PKG_NAME
322: ,'Process_MACD_Order' );
323: END IF;
324: