127:
128: WHEN OTHERS THEN
129: ROLLBACK TO ADDTOCART_PUB;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
132: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
133: FND_MSG_PUB.ADD;
134: FND_MSG_PUB.COUNT_AND_GET (
135: p_count => x_msg_count,
128: WHEN OTHERS THEN
129: ROLLBACK TO ADDTOCART_PUB;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
132: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
133: FND_MSG_PUB.ADD;
134: FND_MSG_PUB.COUNT_AND_GET (
135: p_count => x_msg_count,
136: p_data => x_msg_data );
396:
397: WHEN OTHERS THEN
398: ROLLBACK TO ENROL_CART_PUB;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
401: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
402: FND_MSG_PUB.ADD;
403: FND_MSG_PUB.COUNT_AND_GET (
404: p_count => x_msg_count,
397: WHEN OTHERS THEN
398: ROLLBACK TO ENROL_CART_PUB;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
401: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
402: FND_MSG_PUB.ADD;
403: FND_MSG_PUB.COUNT_AND_GET (
404: p_count => x_msg_count,
405: p_data => x_msg_data );
904: p_data => x_msg_data );
905:
906: WHEN OTHERS THEN
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
909: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
910: FND_MSG_PUB.ADD;
911: FND_MSG_PUB.COUNT_AND_GET (
912: p_count => x_msg_count,
905:
906: WHEN OTHERS THEN
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
909: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
910: FND_MSG_PUB.ADD;
911: FND_MSG_PUB.COUNT_AND_GET (
912: p_count => x_msg_count,
913: p_data => x_msg_data );
2062: p_data => x_msg_data);
2063: WHEN OTHERS THEN
2064: ROLLBACK TO validate_person_details;
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
2067: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2068: FND_MSG_PUB.ADD;
2069: FND_MSG_PUB.Count_And_Get(
2070: p_count => x_msg_count,
2063: WHEN OTHERS THEN
2064: ROLLBACK TO validate_person_details;
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
2067: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2068: FND_MSG_PUB.ADD;
2069: FND_MSG_PUB.Count_And_Get(
2070: p_count => x_msg_count,
2071: p_data => x_msg_data);
2163: p_data => x_msg_data );
2164:
2165: WHEN OTHERS THEN
2166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2167: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
2168: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2169: FND_MSG_PUB.ADD;
2170: FND_MSG_PUB.COUNT_AND_GET (
2171: p_count => x_msg_count,
2164:
2165: WHEN OTHERS THEN
2166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2167: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
2168: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2169: FND_MSG_PUB.ADD;
2170: FND_MSG_PUB.COUNT_AND_GET (
2171: p_count => x_msg_count,
2172: p_data => x_msg_data );
2277:
2278: WHEN OTHERS THEN
2279: ROLLBACK TO WAITLIST_PUB;
2280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2281: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
2282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2283: FND_MSG_PUB.ADD;
2284: FND_MSG_PUB.COUNT_AND_GET (
2285: p_count => x_msg_count,
2278: WHEN OTHERS THEN
2279: ROLLBACK TO WAITLIST_PUB;
2280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2281: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
2282: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2283: FND_MSG_PUB.ADD;
2284: FND_MSG_PUB.COUNT_AND_GET (
2285: p_count => x_msg_count,
2286: p_data => x_msg_data );