426: EXCEPTION
427:
428: WHEN OTHERS THEN
429:
430: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
431: THEN
432: FND_MSG_PUB.Add_Exc_Msg
433: ( G_PKG_NAME
434: , 'Update_Row'
428: WHEN OTHERS THEN
429:
430: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
431: THEN
432: FND_MSG_PUB.Add_Exc_Msg
433: ( G_PKG_NAME
434: , 'Update_Row'
435: );
436: END IF;
544: gmi_reservation_util.println('ERROR in INSERT');
545: gmi_reservation_util.println(' ERR NUM => ' || SQLERRM);
546: gmi_reservation_util.println(' ERR MSG => ' || SQLCODE);
547:
548: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
549: THEN
550: FND_MSG_PUB.Add_Exc_Msg
551: ( G_PKG_NAME
552: , 'Insert_Row'
546: gmi_reservation_util.println(' ERR MSG => ' || SQLCODE);
547:
548: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
549: THEN
550: FND_MSG_PUB.Add_Exc_Msg
551: ( G_PKG_NAME
552: , 'Insert_Row'
553: );
554: END IF;
572: EXCEPTION
573:
574: WHEN OTHERS THEN
575:
576: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
577: THEN
578: FND_MSG_PUB.Add_Exc_Msg
579: ( G_PKG_NAME
580: , 'Delete_Row'
574: WHEN OTHERS THEN
575:
576: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
577: THEN
578: FND_MSG_PUB.Add_Exc_Msg
579: ( G_PKG_NAME
580: , 'Delete_Row'
581: );
582: END IF;
607: EXCEPTION
608:
609: WHEN OTHERS THEN
610:
611: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
612: )
613: THEN
614: FND_MSG_PUB.Add_Exc_Msg
615: ( G_PKG_NAME
610:
611: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
612: )
613: THEN
614: FND_MSG_PUB.Add_Exc_Msg
615: ( G_PKG_NAME
616: , 'Update_Row_Status'
617: );
618: END IF;
716: EXCEPTION
717:
718: WHEN OTHERS THEN
719:
720: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: THEN
722: FND_MSG_PUB.Add_Exc_Msg
723: ( G_PKG_NAME
724: , 'Query_Row'
718: WHEN OTHERS THEN
719:
720: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: THEN
722: FND_MSG_PUB.Add_Exc_Msg
723: ( G_PKG_NAME
724: , 'Query_Row'
725: );
726: END IF;
919:
920: x_return_status := FND_API.G_RET_STS_ERROR;
921: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_ERROR;
922:
923: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
924: THEN
925:
926: FND_MESSAGE.SET_NAME('INV','OE_LOCK_ROW_CHANGED');
927: FND_MSG_PUB.Add;
923: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
924: THEN
925:
926: FND_MESSAGE.SET_NAME('INV','OE_LOCK_ROW_CHANGED');
927: FND_MSG_PUB.Add;
928:
929: END IF;
930:
931: END IF;
936:
937: x_return_status := FND_API.G_RET_STS_ERROR;
938: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_ERROR;
939:
940: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
941: THEN
942:
943: FND_MESSAGE.SET_NAME('INV','OE_LOCK_ROW_DELETED');
944: FND_MSG_PUB.Add;
940: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
941: THEN
942:
943: FND_MESSAGE.SET_NAME('INV','OE_LOCK_ROW_DELETED');
944: FND_MSG_PUB.Add;
945:
946: END IF;
947: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
948:
948:
949: x_return_status := FND_API.G_RET_STS_ERROR;
950: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_ERROR;
951:
952: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
953: THEN
954:
955: FND_MESSAGE.SET_NAME('INV','OE_LOCK_ROW_ALREADY_LOCKED');
956: FND_MSG_PUB.Add;
952: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
953: THEN
954:
955: FND_MESSAGE.SET_NAME('INV','OE_LOCK_ROW_ALREADY_LOCKED');
956: FND_MSG_PUB.Add;
957:
958: END IF;
959: WHEN OTHERS THEN
960:
960:
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
963:
964: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
965: THEN
966: FND_MSG_PUB.Add_Exc_Msg
967: ( G_PKG_NAME
968: , 'Lock_Row'
962: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
963:
964: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
965: THEN
966: FND_MSG_PUB.Add_Exc_Msg
967: ( G_PKG_NAME
968: , 'Lock_Row'
969: );
970: END IF;