196: INV_ORGHIERARCHY_PVT.Log( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
197: , 'SQLERRM '|| SQLERRM);
198: --END IF;
199:
200: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
201: THEN
202: FND_MSG_PUB.Add_Exc_Msg
203: ( G_PKG_NAME
204: , ' GET_CLOSED_STATUS'
198: --END IF;
199:
200: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
201: THEN
202: FND_MSG_PUB.Add_Exc_Msg
203: ( G_PKG_NAME
204: , ' GET_CLOSED_STATUS'
205: );
206: END IF;
325: INV_ORGHIERARCHY_PVT.Log( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
326: , 'SQLERRM '|| SQLERRM) ;
327: --END IF;
328:
329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
330: THEN
331: FND_MSG_PUB.Add_Exc_Msg
332: ( G_PKG_NAME
333: , ' GET_OPEN_REQUESTS_COUNT'
327: --END IF;
328:
329: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
330: THEN
331: FND_MSG_PUB.Add_Exc_Msg
332: ( G_PKG_NAME
333: , ' GET_OPEN_REQUESTS_COUNT'
334: );
335: END IF;
634: INV_ORGHIERARCHY_PVT.Log( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
635: , 'SQLERRM '|| SQLERRM) ;
636: --END IF;
637:
638: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg
641: ( G_PKG_NAME
642: , ' GET_MAX_OPEN_PERIOD'
636: --END IF;
637:
638: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg
641: ( G_PKG_NAME
642: , ' GET_MAX_OPEN_PERIOD'
643: );
644: END IF;
777: INV_ORGHIERARCHY_PVT.Log( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
778: , 'SQLERRM '|| SQLERRM) ;
779: --END IF;
780:
781: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
782: THEN
783: FND_MSG_PUB.Add_Exc_Msg
784: ( G_PKG_NAME
785: , 'GET_MIN_OPEN_PERIOD'
779: --END IF;
780:
781: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
782: THEN
783: FND_MSG_PUB.Add_Exc_Msg
784: ( G_PKG_NAME
785: , 'GET_MIN_OPEN_PERIOD'
786: );
787: END IF;
2530: */
2531: INV_ORGHIERARCHY_PVT.Log( INV_ORGHIERARCHY_PVT.G_LOG_EXCEPTION
2532: , 'SQLERRM '|| SQLERRM) ;
2533: --END IF;
2534: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2535: THEN
2536: FND_MSG_PUB.Add_Exc_Msg
2537: ( G_PKG_NAME
2538: , ' Period_Control '
2532: , 'SQLERRM '|| SQLERRM) ;
2533: --END IF;
2534: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2535: THEN
2536: FND_MSG_PUB.Add_Exc_Msg
2537: ( G_PKG_NAME
2538: , ' Period_Control '
2539: );
2540: END IF;