809: IF PG_DEBUG in ('Y', 'C') THEN
810: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'error in insert row: sqlcode = '|| to_char(my_sqlcode));
811: END IF;
812:
813: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
814: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Mat_Demand');
815: END IF;
816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
817: END Add_Mat_Demand;
810: msc_sch_wb.atp_debug('Add_Mat_Demand: ' || 'error in insert row: sqlcode = '|| to_char(my_sqlcode));
811: END IF;
812:
813: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
814: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Add_Mat_Demand');
815: END IF;
816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
817: END Add_Mat_Demand;
818:
2206: END IF;
2207:
2208: EXCEPTION
2209: WHEN OTHERS THEN
2210: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2211: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Delete_Row');
2212: END IF;
2213:
2214: IF PG_DEBUG in ('Y', 'C') THEN
2207:
2208: EXCEPTION
2209: WHEN OTHERS THEN
2210: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2211: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Delete_Row');
2212: END IF;
2213:
2214: IF PG_DEBUG in ('Y', 'C') THEN
2215: msc_sch_wb.atp_debug('Delete_Row :' || sqlcode || ': ' || sqlerrm);
3811: msc_sch_wb.atp_debug('**********End Update_SD_Date Procedure************');
3812: END IF;
3813: EXCEPTION
3814: WHEN OTHERS THEN
3815: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3816: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Update_SD_Date');
3817: END IF;
3818:
3819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3812: END IF;
3813: EXCEPTION
3814: WHEN OTHERS THEN
3815: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3816: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Update_SD_Date');
3817: END IF;
3818:
3819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3820: END Update_SD_Date;
4163: END IF;
4164:
4165: EXCEPTION
4166: WHEN OTHERS THEN
4167: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4168: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Undo_Delete_Row');
4169: END IF;
4170:
4171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4164:
4165: EXCEPTION
4166: WHEN OTHERS THEN
4167: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4168: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , 'Undo_Delete_Row');
4169: END IF;
4170:
4171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4172: