76: THEN
77: SELECT gem5_trans_id_s.nextval INTO l_cmp_tran_rec.trans_id FROM dual;
78: IF (l_cmp_tran_rec.trans_id <= 0)
79: THEN
80: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
81: FND_MESSAGE.SET_TOKEN('SKEY','trans_id');
82: FND_MSG_PUB.Add;
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;
77: SELECT gem5_trans_id_s.nextval INTO l_cmp_tran_rec.trans_id FROM dual;
78: IF (l_cmp_tran_rec.trans_id <= 0)
79: THEN
80: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
81: FND_MESSAGE.SET_TOKEN('SKEY','trans_id');
82: FND_MSG_PUB.Add;
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;
85: END IF;
750: THEN
751: SELECT gem5_summ_inv_id_s.nextval INTO l_summ_inv_id FROM dual;
752: IF (l_summ_inv_id <= 0)
753: THEN
754: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
755: FND_MESSAGE.SET_TOKEN('SKEY','summ_inv_id');
756: FND_MSG_PUB.Add;
757: RAISE FND_API.G_EXC_ERROR;
758: ELSE
751: SELECT gem5_summ_inv_id_s.nextval INTO l_summ_inv_id FROM dual;
752: IF (l_summ_inv_id <= 0)
753: THEN
754: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_SURROGATE');
755: FND_MESSAGE.SET_TOKEN('SKEY','summ_inv_id');
756: FND_MSG_PUB.Add;
757: RAISE FND_API.G_EXC_ERROR;
758: ELSE
759: INSERT INTO ic_summ_inv