834: EXCEPTION
835:
836: WHEN OTHERS THEN
837:
838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
839: THEN
840: FND_MSG_PUB.Add_Exc_Msg
841: ( G_PKG_NAME
842: , 'Update_Row'
836: WHEN OTHERS THEN
837:
838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
839: THEN
840: FND_MSG_PUB.Add_Exc_Msg
841: ( G_PKG_NAME
842: , 'Update_Row'
843: );
844: END IF;
981: EXCEPTION
982:
983: WHEN OTHERS THEN
984:
985: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
986: THEN
987: FND_MSG_PUB.Add_Exc_Msg
988: ( G_PKG_NAME
989: , 'Insert_Row'
983: WHEN OTHERS THEN
984:
985: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
986: THEN
987: FND_MSG_PUB.Add_Exc_Msg
988: ( G_PKG_NAME
989: , 'Insert_Row'
990: );
991: END IF;
1009: EXCEPTION
1010:
1011: WHEN OTHERS THEN
1012:
1013: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: FND_MSG_PUB.Add_Exc_Msg
1016: ( G_PKG_NAME
1017: , 'Delete_Row'
1011: WHEN OTHERS THEN
1012:
1013: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: FND_MSG_PUB.Add_Exc_Msg
1016: ( G_PKG_NAME
1017: , 'Delete_Row'
1018: );
1019: END IF;
1138: (p_wip_entity_id IS NOT NULL
1139: AND
1140: p_wip_entity_id <> FND_API.G_MISS_NUM)
1141: THEN
1142: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1143: THEN
1144: FND_MSG_PUB.Add_Exc_Msg
1145: ( G_PKG_NAME
1146: , 'Query Rows'
1140: p_wip_entity_id <> FND_API.G_MISS_NUM)
1141: THEN
1142: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1143: THEN
1144: FND_MSG_PUB.Add_Exc_Msg
1145: ( G_PKG_NAME
1146: , 'Query Rows'
1147: , 'Keys are mutually exclusive: repetitive_schedule_id = '|| p_repetitive_schedule_id || ', wip_entity_id = '|| p_wip_entity_id
1148: );
1246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1247:
1248: WHEN OTHERS THEN
1249:
1250: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1251: THEN
1252: FND_MSG_PUB.Add_Exc_Msg
1253: ( G_PKG_NAME
1254: , 'Query_Rows'
1248: WHEN OTHERS THEN
1249:
1250: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1251: THEN
1252: FND_MSG_PUB.Add_Exc_Msg
1253: ( G_PKG_NAME
1254: , 'Query_Rows'
1255: );
1256: END IF;
1530:
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1533:
1534: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1535: THEN
1536:
1537: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_CHANGED');
1538: FND_MSG_PUB.Add;
1534: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1535: THEN
1536:
1537: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_CHANGED');
1538: FND_MSG_PUB.Add;
1539:
1540: END IF;
1541:
1542: END IF;
1547:
1548: x_return_status := FND_API.G_RET_STS_ERROR;
1549: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1550:
1551: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1552: THEN
1553:
1554: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_DELETED');
1555: FND_MSG_PUB.Add;
1551: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1552: THEN
1553:
1554: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_DELETED');
1555: FND_MSG_PUB.Add;
1556:
1557: END IF;
1558: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1559:
1559:
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1562:
1563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1564: THEN
1565:
1566: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_ALREADY_LOCKED');
1567: FND_MSG_PUB.Add;
1563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1564: THEN
1565:
1566: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_ALREADY_LOCKED');
1567: FND_MSG_PUB.Add;
1568:
1569: END IF;
1570: WHEN OTHERS THEN
1571:
1571:
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1573: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1574:
1575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1576: THEN
1577: FND_MSG_PUB.Add_Exc_Msg
1578: ( G_PKG_NAME
1579: , 'Lock_Row'
1573: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1574:
1575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1576: THEN
1577: FND_MSG_PUB.Add_Exc_Msg
1578: ( G_PKG_NAME
1579: , 'Lock_Row'
1580: );
1581: END IF;