207: OPEN get_comm_line_rec;
208: FETCH get_comm_line_rec INTO l_pmt_trans_rec;
209: IF get_comm_line_rec%ROWCOUNT <> 1 THEN
210: CLOSE get_comm_line_rec;
211: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_COMMISSION_LINE');
212: FND_MESSAGE.SET_TOKEN('COMMISSION_LINE_ID', TO_CHAR(p_commission_line_id));
213: FND_MSG_PUB.ADD;
214: RAISE FND_API.G_EXC_ERROR;
215: END IF;
208: FETCH get_comm_line_rec INTO l_pmt_trans_rec;
209: IF get_comm_line_rec%ROWCOUNT <> 1 THEN
210: CLOSE get_comm_line_rec;
211: FND_MESSAGE.SET_NAME('CN', 'CN_INVALID_COMMISSION_LINE');
212: FND_MESSAGE.SET_TOKEN('COMMISSION_LINE_ID', TO_CHAR(p_commission_line_id));
213: FND_MSG_PUB.ADD;
214: RAISE FND_API.G_EXC_ERROR;
215: END IF;
216: CLOSE get_comm_line_rec;