379: WHEN NO_DATA_FOUND THEN
380: null;
381: WHEN OTHERS THEN
382:
383: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
384: THEN
385: OE_MSG_PUB.Add_Exc_Msg
386: ( G_PKG_NAME,
387: 'Query_HEADER_Row'
381: WHEN OTHERS THEN
382:
383: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
384: THEN
385: OE_MSG_PUB.Add_Exc_Msg
386: ( G_PKG_NAME,
387: 'Query_HEADER_Row'
388: );
389: END IF;
778: WHEN NO_DATA_FOUND THEN
779: null;
780: WHEN OTHERS THEN
781:
782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
783: THEN
784: OE_MSG_PUB.Add_Exc_Msg
785: ( G_PKG_NAME,
786: 'Query_HEADER_Trans_Row'
780: WHEN OTHERS THEN
781:
782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
783: THEN
784: OE_MSG_PUB.Add_Exc_Msg
785: ( G_PKG_NAME,
786: 'Query_HEADER_Trans_Row'
787: );
788: END IF;
7726: WHEN NO_DATA_FOUND THEN
7727: NULL;
7728: WHEN OTHERS THEN
7729:
7730: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7731: THEN
7732: OE_MSG_PUB.Add_Exc_Msg
7733: ( G_PKG_NAME,
7734: 'Query_Line_Row'
7728: WHEN OTHERS THEN
7729:
7730: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7731: THEN
7732: OE_MSG_PUB.Add_Exc_Msg
7733: ( G_PKG_NAME,
7734: 'Query_Line_Row'
7735: );
7736: END IF;
8409: WHEN NO_DATA_FOUND THEN
8410: NULL;
8411: WHEN OTHERS THEN
8412:
8413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8414: THEN
8415: OE_MSG_PUB.Add_Exc_Msg
8416: ( G_PKG_NAME,
8417: 'Query_Line_TRANS_Row'
8411: WHEN OTHERS THEN
8412:
8413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8414: THEN
8415: OE_MSG_PUB.Add_Exc_Msg
8416: ( G_PKG_NAME,
8417: 'Query_Line_TRANS_Row'
8418: );
8419: END IF;
18366: -- RAISE NO_DATA_FOUND;
18367: null;
18368: WHEN OTHERS THEN
18369:
18370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
18371: THEN
18372: OE_MSG_PUB.Add_Exc_Msg
18373: ( G_PKG_NAME,
18374: 'Query_HEADER_SC_Row'
18368: WHEN OTHERS THEN
18369:
18370: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
18371: THEN
18372: OE_MSG_PUB.Add_Exc_Msg
18373: ( G_PKG_NAME,
18374: 'Query_HEADER_SC_Row'
18375: );
18376: END IF;
18477: -- RAISE NO_DATA_FOUND;
18478: null;
18479: WHEN OTHERS THEN
18480:
18481: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
18482: THEN
18483: OE_MSG_PUB.Add_Exc_Msg
18484: ( G_PKG_NAME,
18485: 'Query_HEADER_SC_Trans_Row'
18479: WHEN OTHERS THEN
18480:
18481: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
18482: THEN
18483: OE_MSG_PUB.Add_Exc_Msg
18484: ( G_PKG_NAME,
18485: 'Query_HEADER_SC_Trans_Row'
18486: );
18487: END IF;
19782: -- RAISE NO_DATA_FOUND;
19783: null;
19784: WHEN OTHERS THEN
19785:
19786: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
19787: THEN
19788: OE_MSG_PUB.Add_Exc_Msg
19789: ( G_PKG_NAME,
19790: 'Query_line_SC_Row'
19784: WHEN OTHERS THEN
19785:
19786: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
19787: THEN
19788: OE_MSG_PUB.Add_Exc_Msg
19789: ( G_PKG_NAME,
19790: 'Query_line_SC_Row'
19791: );
19792: END IF;
19893: -- RAISE NO_DATA_FOUND;
19894: null;
19895: WHEN OTHERS THEN
19896:
19897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
19898: THEN
19899: OE_MSG_PUB.Add_Exc_Msg
19900: ( G_PKG_NAME,
19901: 'Query_line_SC_Trans_Row'
19895: WHEN OTHERS THEN
19896:
19897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
19898: THEN
19899: OE_MSG_PUB.Add_Exc_Msg
19900: ( G_PKG_NAME,
19901: 'Query_line_SC_Trans_Row'
19902: );
19903: END IF;