656: IF PG_DEBUG in ('Y', 'C') THEN
657: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'error in insert row: sqlcode = '|| to_char(my_sqlcode));
658: END IF;
659:
660: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
661: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Mat_Demand');
662: END IF;
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: END Add_Mat_Demand;
657: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'error in insert row: sqlcode = '|| to_char(my_sqlcode));
658: END IF;
659:
660: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
661: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Mat_Demand');
662: END IF;
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: END Add_Mat_Demand;
665:
2053: END IF;
2054:
2055: EXCEPTION
2056: WHEN OTHERS THEN
2057: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2058: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Delete_Row');
2059: END IF;
2060:
2061: IF PG_DEBUG in ('Y', 'C') THEN
2054:
2055: EXCEPTION
2056: WHEN OTHERS THEN
2057: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2058: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Delete_Row');
2059: END IF;
2060:
2061: IF PG_DEBUG in ('Y', 'C') THEN
2062: msc_sch_wb.atp_debug('Delete_Row :' || sqlcode || ': ' || sqlerrm);
3641: msc_sch_wb.atp_debug('**********End Update_SD_Date Procedure************');
3642: END IF;
3643: EXCEPTION
3644: WHEN OTHERS THEN
3645: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3646: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Update_SD_Date');
3647: END IF;
3648:
3649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3642: END IF;
3643: EXCEPTION
3644: WHEN OTHERS THEN
3645: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3646: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Update_SD_Date');
3647: END IF;
3648:
3649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3650: END Update_SD_Date;
3981: END IF;
3982:
3983: EXCEPTION
3984: WHEN OTHERS THEN
3985: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3986: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Undo_Delete_Row');
3987: END IF;
3988:
3989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3982:
3983: EXCEPTION
3984: WHEN OTHERS THEN
3985: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3986: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Undo_Delete_Row');
3987: END IF;
3988:
3989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3990: