482: EXCEPTION
483:
484: WHEN NO_DATA_FOUND THEN
485: x_return_status:= FND_API.G_RET_STS_ERROR;
486: fnd_message.set_name('IGW', 'IGW_NO_RIGHTS');
487: fnd_msg_pub.add;
488:
489: WHEN too_many_rows THEN
490: NULL;
515:
516: EXCEPTION
517: WHEN NO_DATA_FOUND THEN
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: FND_MESSAGE.SET_NAME('IGW','IGW_SS_RECORD_CHANGED');
520: FND_MSG_PUB.Add;
521: raise fnd_api.g_exc_error;
522:
523: WHEN OTHERS THEN
548:
549: EXCEPTION
550: WHEN no_data_found THEN
551: x_return_status:= FND_API.G_RET_STS_ERROR;
552: fnd_message.set_name('IGW', 'IGW_SS_ROLE_INVALID');
553: fnd_msg_pub.add;
554:
555: WHEN too_many_rows THEN
556: x_return_status:= FND_API.G_RET_STS_ERROR;
553: fnd_msg_pub.add;
554:
555: WHEN too_many_rows THEN
556: x_return_status:= FND_API.G_RET_STS_ERROR;
557: fnd_message.set_name('IGW', 'IGW_SS_ROLE_INVALID');
558: fnd_msg_pub.add;
559:
560: WHEN OTHERS THEN
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: seeded_flag = 'Y';
582:
583: if (N <> 0) then
584: x_return_status:= FND_API.G_RET_STS_ERROR;
585: fnd_message.set_name ('IGW', 'IGW_SEEDED_ROLE');
586: fnd_msg_pub.add;
587: end if;
588:
589: EXCEPTION