number seq by group x++

public FCC_ItemNumSeq itemGroupSeq(ItemGroupId _itemGroupId)
{
NumberSequenceCode numberSequenceCode;
RefRecId numberSeqRefRecId;
NumberSequenceTable numberSequenceTable;
NumberSeq num;
EcoResProduct ecoResProductLoc;
FCC_ItemNumSeq itemNumSeq;
FCC_ItemNumberSequence fcc_ItemNumberSequence, fcc_ItemNumberSequenceUpdate;

select fcc_ItemNumberSequence
where fcc_ItemNumberSequence.ItemGroupId == _itemGroupId;

numberSeqRefRecId = fcc_ItemNumberSequence.NumberSequenceRefRecId;
ecoResProductLoc = EcoResProduct::findByProductNumber(fcc_ItemNumberSequence.NumberSequenceFormat);
if(!ecoResProductLoc && fcc_ItemNumberSequence.NumberSequenceFormat != “”)
{
itemNumSeq = fcc_ItemNumberSequence.NumberSequenceFormat;
}
else
{
num = NumberSeq::newGetNumFromId(numberSeqRefRecId);
itemNumSeq = num.num();
select forUpdate fcc_ItemNumberSequenceUpdate
where fcc_ItemNumberSequenceUpdate.ItemGroupId == _itemGroupId;
ttsBegin;
fcc_ItemNumberSequenceUpdate.NumberSequenceFormat = itemNumSeq;
fcc_ItemNumberSequenceUpdate.Count = 1;
fcc_ItemNumberSequenceUpdate.update();
ttsCommit;
}
//this.insert();
return itemNumSeq;
}