314: END IF;
315:
316: EXCEPTION
317: WHEN FND_API.G_EXC_ERROR THEN
318: x_msg_count := FND_MSG_PUB.count_msg;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: WHEN OTHERS THEN
321: x_msg_count := FND_MSG_PUB.count_msg;
322: x_return_status := FND_API.G_RET_STS_ERROR;
317: WHEN FND_API.G_EXC_ERROR THEN
318: x_msg_count := FND_MSG_PUB.count_msg;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: WHEN OTHERS THEN
321: x_msg_count := FND_MSG_PUB.count_msg;
322: x_return_status := FND_API.G_RET_STS_ERROR;
323: END CREATE_ASSET_INSTANCES_WRP ;
324:
325:
351: );
352:
353: IF x_request_id = 0 THEN
354: FND_MESSAGE.Set_Name('RRS','RRS_CON_REQUEST_FAILED');
355: FND_MSG_PUB.Add;
356: RAISE FND_API.G_EXC_ERROR;
357: END IF;
358: COMMIT ;
359: EXCEPTION
357: END IF;
358: COMMIT ;
359: EXCEPTION
360: WHEN FND_API.G_EXC_ERROR THEN
361: x_msg_count := FND_MSG_PUB.COUNT_MSG;
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: WHEN OTHERS THEN
364: x_return_status := 'E' ;
365: x_msg_count := FND_MSG_PUB.COUNT_MSG;
361: x_msg_count := FND_MSG_PUB.COUNT_MSG;
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: WHEN OTHERS THEN
364: x_return_status := 'E' ;
365: x_msg_count := FND_MSG_PUB.COUNT_MSG;
366: END CREATE_ASSET_INSTANCES_CONC ;
367:
368: PROCEDURE POPULATE_RRS_SITES_INTF
369: ( p_session_id IN VARCHAR2