49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50:
51: VALIDATE_OBJECT_TABLESPACES(
52: P_Init_Msg_List => FND_API.G_FALSE,
53: P_Validation_mode => AS_UTILITY_PVT.G_CREATE,
54: P_application_short_name => p_APPLICATION_SHORT_NAME,
55: P_OBJECT_NAME => P_OBJECT_NAME,
56: P_OBJECT_TYPE => P_OBJECT_TYPE,
57: P_TABLESPACE_TYPE => P_TABLESPACE_TYPE,
164: x_return_status := FND_API.G_RET_STS_SUCCESS;
165:
166: VALIDATE_OBJECT_TABLESPACES(
167: P_Init_Msg_List => FND_API.G_FALSE,
168: P_Validation_mode => AS_UTILITY_PVT.G_UPDATE,
169: P_application_short_name => p_APPLICATION_SHORT_NAME,
170: P_OBJECT_NAME => P_OBJECT_NAME,
171: P_OBJECT_TYPE => P_OBJECT_TYPE,
172: P_TABLESPACE_TYPE => P_TABLESPACE_TYPE,
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: end if;
368: END IF;
369:
370: IF (p_validation_mode = AS_UTILITY_PVT.G_CREATE)
371: THEN
372: IF (p_OBJECT_NAME is not NULL AND p_OBJECT_NAME <> FND_API.G_MISS_CHAR)
373: THEN
374: OPEN c4(l_application_id);
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: end if;
401: CLOSE c3;
402: END IF;
403: ELSIF (p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
404: THEN
405: IF (p_OBJECT_NAME is not NULL AND p_OBJECT_NAME <> FND_API.G_MISS_CHAR)
406: THEN
407: OPEN c4(l_application_id);