1127: oe_debug_pub.add( 'ERROR:'||L_ERR_TEXT , 5 ) ;
1128: oe_debug_pub.add( 'IN OUTER EXCEPTION' , 5 ) ;
1129: oe_debug_pub.add( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1130: END IF;
1131: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1132: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'RecordLineHist');
1133: END IF;
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add( 'ERROR WHILE INSERTING LINE HISTORY RECORD' ) ;
1128: oe_debug_pub.add( 'IN OUTER EXCEPTION' , 5 ) ;
1129: oe_debug_pub.add( 'HIST_TYPE_CODE VALUE:' || P_HIST_TYPE_CODE , 5 ) ;
1130: END IF;
1131: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1132: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,'RecordLineHist');
1133: END IF;
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add( 'ERROR WHILE INSERTING LINE HISTORY RECORD' ) ;
1136: END IF;
1615: END IF;
1616:
1617: EXCEPTION
1618: WHEN OTHERS THEN
1619: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1620: FND_MSG_PUB.Add_Exc_Msg
1621: (G_PKG_NAME
1622: ,'RecordHeaderHist');
1623: END IF;
1616:
1617: EXCEPTION
1618: WHEN OTHERS THEN
1619: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1620: FND_MSG_PUB.Add_Exc_Msg
1621: (G_PKG_NAME
1622: ,'RecordHeaderHist');
1623: END IF;
1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1766: END IF;
1767:
1768: EXCEPTION
1769: WHEN OTHERS THEN
1770: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1771: FND_MSG_PUB.Add_Exc_Msg
1772: (G_PKG_NAME
1773: ,'RecordHSCreditHist');
1774: END IF;
1767:
1768: EXCEPTION
1769: WHEN OTHERS THEN
1770: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1771: FND_MSG_PUB.Add_Exc_Msg
1772: (G_PKG_NAME
1773: ,'RecordHSCreditHist');
1774: END IF;
1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1917: END IF;
1918:
1919: EXCEPTION
1920: WHEN OTHERS THEN
1921: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1922: FND_MSG_PUB.Add_Exc_Msg
1923: (G_PKG_NAME
1924: ,'RecordLSCreditHist');
1925: END IF;
1918:
1919: EXCEPTION
1920: WHEN OTHERS THEN
1921: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1922: FND_MSG_PUB.Add_Exc_Msg
1923: (G_PKG_NAME
1924: ,'RecordLSCreditHist');
1925: END IF;
1926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2198: END IF;
2199:
2200: EXCEPTION
2201: WHEN OTHERS THEN
2202: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2203: FND_MSG_PUB.Add_Exc_Msg
2204: (G_PKG_NAME
2205: ,'RecordHPAdjHist');
2206: END IF;
2199:
2200: EXCEPTION
2201: WHEN OTHERS THEN
2202: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2203: FND_MSG_PUB.Add_Exc_Msg
2204: (G_PKG_NAME
2205: ,'RecordHPAdjHist');
2206: END IF;
2207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2483: END IF;
2484:
2485: EXCEPTION
2486: WHEN OTHERS THEN
2487: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2488: FND_MSG_PUB.Add_Exc_Msg
2489: (G_PKG_NAME
2490: ,'RecordLPAdjHist');
2491: END IF;
2484:
2485: EXCEPTION
2486: WHEN OTHERS THEN
2487: IF FND_MSG_PUB.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2488: FND_MSG_PUB.Add_Exc_Msg
2489: (G_PKG_NAME
2490: ,'RecordLPAdjHist');
2491: END IF;
2492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;