1554:
1555: EXCEPTION
1556: WHEN OTHERS THEN
1557:
1558: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1559: THEN
1560: OE_MSG_PUB.Add_Exc_Msg
1561: ( G_PKG_NAME
1562: , l_api_name
1556: WHEN OTHERS THEN
1557:
1558: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1559: THEN
1560: OE_MSG_PUB.Add_Exc_Msg
1561: ( G_PKG_NAME
1562: , l_api_name
1563: );
1564: END IF;
1631: RETURN l_current_version_number;
1632:
1633: EXCEPTION
1634: WHEN OTHERS THEN
1635: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1636: OE_MSG_PUB.Add_Exc_Msg
1637: ( G_PKG_NAME
1638: , 'Get_Version_Number'
1639: );
1632:
1633: EXCEPTION
1634: WHEN OTHERS THEN
1635: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1636: OE_MSG_PUB.Add_Exc_Msg
1637: ( G_PKG_NAME
1638: , 'Get_Version_Number'
1639: );
1640: END IF;
1709:
1710: WHEN OTHERS THEN
1711: G_INTERNAL_QUERY := FALSE;
1712:
1713: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1714: OE_MSG_PUB.Add_Exc_Msg
1715: ( G_PKG_NAME
1716: , 'Get_Transaction_Version'
1717: );
1710: WHEN OTHERS THEN
1711: G_INTERNAL_QUERY := FALSE;
1712:
1713: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1714: OE_MSG_PUB.Add_Exc_Msg
1715: ( G_PKG_NAME
1716: , 'Get_Transaction_Version'
1717: );
1718: END IF;
2104: --R12 CC Encryption
2105:
2106: EXCEPTION
2107: WHEN OTHERS THEN
2108: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2109: OE_MSG_PUB.Add_Exc_Msg
2110: ( G_PKG_NAME
2111: , 'Header Query_Row'
2112: );
2105:
2106: EXCEPTION
2107: WHEN OTHERS THEN
2108: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2109: OE_MSG_PUB.Add_Exc_Msg
2110: ( G_PKG_NAME
2111: , 'Header Query_Row'
2112: );
2113: END IF;
2160: END IF;
2161:
2162: EXCEPTION
2163: WHEN OTHERS THEN
2164: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2165: OE_MSG_PUB.Add_Exc_Msg
2166: ( G_PKG_NAME
2167: , 'Header Adj Query_Row'
2168: );
2161:
2162: EXCEPTION
2163: WHEN OTHERS THEN
2164: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2165: OE_MSG_PUB.Add_Exc_Msg
2166: ( G_PKG_NAME
2167: , 'Header Adj Query_Row'
2168: );
2169: END IF;
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598:
2599: WHEN OTHERS THEN
2600:
2601: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2602: OE_MSG_PUB.Add_Exc_Msg
2603: ( G_PKG_NAME
2604: , 'Header Adj Query_Rows'
2605: );
2598:
2599: WHEN OTHERS THEN
2600:
2601: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2602: OE_MSG_PUB.Add_Exc_Msg
2603: ( G_PKG_NAME
2604: , 'Header Adj Query_Rows'
2605: );
2606: END IF;
2646: END IF;
2647:
2648: EXCEPTION
2649: WHEN OTHERS THEN
2650: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2651: OE_MSG_PUB.Add_Exc_Msg
2652: ( G_PKG_NAME
2653: , 'Header Scredit Query_Row'
2654: );
2647:
2648: EXCEPTION
2649: WHEN OTHERS THEN
2650: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2651: OE_MSG_PUB.Add_Exc_Msg
2652: ( G_PKG_NAME
2653: , 'Header Scredit Query_Row'
2654: );
2655: END IF;
2867: END IF;
2868:
2869: EXCEPTION
2870: WHEN OTHERS THEN
2871: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2872: OE_MSG_PUB.Add_Exc_Msg
2873: ( G_PKG_NAME
2874: , 'Header Scredit Query_Rows'
2875: );
2868:
2869: EXCEPTION
2870: WHEN OTHERS THEN
2871: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2872: OE_MSG_PUB.Add_Exc_Msg
2873: ( G_PKG_NAME
2874: , 'Header Scredit Query_Rows'
2875: );
2876: END IF;
2913: END IF;
2914:
2915: EXCEPTION
2916: WHEN OTHERS THEN
2917: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2918: OE_MSG_PUB.Add_Exc_Msg
2919: ( G_PKG_NAME
2920: , 'Line Query_Row'
2921: );
2914:
2915: EXCEPTION
2916: WHEN OTHERS THEN
2917: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2918: OE_MSG_PUB.Add_Exc_Msg
2919: ( G_PKG_NAME
2920: , 'Line Query_Row'
2921: );
2922: END IF;
4420: END IF;
4421:
4422: EXCEPTION
4423: WHEN OTHERS THEN
4424: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4425: OE_MSG_PUB.Add_Exc_Msg
4426: ( G_PKG_NAME
4427: , 'Line Query_Rows'
4428: );
4421:
4422: EXCEPTION
4423: WHEN OTHERS THEN
4424: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4425: OE_MSG_PUB.Add_Exc_Msg
4426: ( G_PKG_NAME
4427: , 'Line Query_Rows'
4428: );
4429: END IF;
4465: END IF;
4466:
4467: EXCEPTION
4468: WHEN OTHERS THEN
4469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4470: OE_MSG_PUB.Add_Exc_Msg
4471: ( G_PKG_NAME
4472: , 'Line Adj Query_Row'
4473: );
4466:
4467: EXCEPTION
4468: WHEN OTHERS THEN
4469: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4470: OE_MSG_PUB.Add_Exc_Msg
4471: ( G_PKG_NAME
4472: , 'Line Adj Query_Row'
4473: );
4474: END IF;
5016: END IF;
5017:
5018: EXCEPTION
5019: WHEN OTHERS THEN
5020: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5021: OE_MSG_PUB.Add_Exc_Msg
5022: ( G_PKG_NAME
5023: , 'Line Adj Query_Rows'
5024: );
5017:
5018: EXCEPTION
5019: WHEN OTHERS THEN
5020: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5021: OE_MSG_PUB.Add_Exc_Msg
5022: ( G_PKG_NAME
5023: , 'Line Adj Query_Rows'
5024: );
5025: END IF;
5069: END IF;
5070:
5071: EXCEPTION
5072: WHEN OTHERS THEN
5073: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5074: OE_MSG_PUB.Add_Exc_Msg
5075: ( G_PKG_NAME
5076: , 'Line Scredit Query_Row'
5077: );
5070:
5071: EXCEPTION
5072: WHEN OTHERS THEN
5073: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5074: OE_MSG_PUB.Add_Exc_Msg
5075: ( G_PKG_NAME
5076: , 'Line Scredit Query_Row'
5077: );
5078: END IF;
5339: END IF;
5340:
5341: EXCEPTION
5342: WHEN OTHERS THEN
5343: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5344: OE_MSG_PUB.Add_Exc_Msg
5345: ( G_PKG_NAME
5346: , 'Line Scredit Query_Row'
5347: );
5340:
5341: EXCEPTION
5342: WHEN OTHERS THEN
5343: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5344: OE_MSG_PUB.Add_Exc_Msg
5345: ( G_PKG_NAME
5346: , 'Line Scredit Query_Row'
5347: );
5348: END IF;