224:
225: -- validate NOT NULL column
226: IF (p_TABLESPACE_TYPE is NULL OR p_TABLESPACE_TYPE = FND_API.G_MISS_CHAR)
227: THEN
228: FND_MESSAGE.Set_Name('FND', 'OATM_REQUIRED_ENTRY');
229: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
230: FND_MESSAGE.Set_Token('FIELD', 'Tablespace Type');
231: FND_MSG_PUB.Add;
232: x_return_status := FND_API.G_RET_STS_ERROR;
225: -- validate NOT NULL column
226: IF (p_TABLESPACE_TYPE is NULL OR p_TABLESPACE_TYPE = FND_API.G_MISS_CHAR)
227: THEN
228: FND_MESSAGE.Set_Name('FND', 'OATM_REQUIRED_ENTRY');
229: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
230: FND_MESSAGE.Set_Token('FIELD', 'Tablespace Type');
231: FND_MSG_PUB.Add;
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: END IF;
226: IF (p_TABLESPACE_TYPE is NULL OR p_TABLESPACE_TYPE = FND_API.G_MISS_CHAR)
227: THEN
228: FND_MESSAGE.Set_Name('FND', 'OATM_REQUIRED_ENTRY');
229: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
230: FND_MESSAGE.Set_Token('FIELD', 'Tablespace Type');
231: FND_MSG_PUB.Add;
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: END IF;
234:
234:
235: -- validate NOT NULL column
236: IF (p_TABLESPACE is NULL OR p_TABLESPACE = FND_API.G_MISS_CHAR)
237: THEN
238: FND_MESSAGE.Set_Name('FND', 'OATM_REQUIRED_ENTRY');
239: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
240: FND_MESSAGE.Set_Token('FIELD', 'Tablespace Name');
241: FND_MSG_PUB.Add;
242: x_return_status := FND_API.G_RET_STS_ERROR;
235: -- validate NOT NULL column
236: IF (p_TABLESPACE is NULL OR p_TABLESPACE = FND_API.G_MISS_CHAR)
237: THEN
238: FND_MESSAGE.Set_Name('FND', 'OATM_REQUIRED_ENTRY');
239: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
240: FND_MESSAGE.Set_Token('FIELD', 'Tablespace Name');
241: FND_MSG_PUB.Add;
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: END IF;
236: IF (p_TABLESPACE is NULL OR p_TABLESPACE = FND_API.G_MISS_CHAR)
237: THEN
238: FND_MESSAGE.Set_Name('FND', 'OATM_REQUIRED_ENTRY');
239: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
240: FND_MESSAGE.Set_Token('FIELD', 'Tablespace Name');
241: FND_MSG_PUB.Add;
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: END IF;
244:
248: THEN
249: OPEN c1;
250: FETCH c1 INTO l_dummy;
251: if c1%FOUND then
252: FND_MESSAGE.Set_Name('FND', 'OATM_NO_INSERT');
253: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
254: FND_MESSAGE.Set_Token('FIELD_NAME', 'Tablespace Type');
255: FND_MESSAGE.Set_Token('FIELD_VALUE', p_TABLESPACE_TYPE);
256: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_TABLESPACES');
249: OPEN c1;
250: FETCH c1 INTO l_dummy;
251: if c1%FOUND then
252: FND_MESSAGE.Set_Name('FND', 'OATM_NO_INSERT');
253: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
254: FND_MESSAGE.Set_Token('FIELD_NAME', 'Tablespace Type');
255: FND_MESSAGE.Set_Token('FIELD_VALUE', p_TABLESPACE_TYPE);
256: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_TABLESPACES');
257: FND_MSG_PUB.Add;
250: FETCH c1 INTO l_dummy;
251: if c1%FOUND then
252: FND_MESSAGE.Set_Name('FND', 'OATM_NO_INSERT');
253: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
254: FND_MESSAGE.Set_Token('FIELD_NAME', 'Tablespace Type');
255: FND_MESSAGE.Set_Token('FIELD_VALUE', p_TABLESPACE_TYPE);
256: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_TABLESPACES');
257: FND_MSG_PUB.Add;
258: x_return_status := FND_API.G_RET_STS_ERROR;
251: if c1%FOUND then
252: FND_MESSAGE.Set_Name('FND', 'OATM_NO_INSERT');
253: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
254: FND_MESSAGE.Set_Token('FIELD_NAME', 'Tablespace Type');
255: FND_MESSAGE.Set_Token('FIELD_VALUE', p_TABLESPACE_TYPE);
256: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_TABLESPACES');
257: FND_MSG_PUB.Add;
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: end if;
252: FND_MESSAGE.Set_Name('FND', 'OATM_NO_INSERT');
253: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
254: FND_MESSAGE.Set_Token('FIELD_NAME', 'Tablespace Type');
255: FND_MESSAGE.Set_Token('FIELD_VALUE', p_TABLESPACE_TYPE);
256: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_TABLESPACES');
257: FND_MSG_PUB.Add;
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: end if;
260: CLOSE c1;
265: THEN
266: OPEN c1;
267: FETCH c1 INTO l_dummy;
268: if c1%NOTFOUND then
269: FND_MESSAGE.Set_Name('FND', 'OATM_NO_UPDATE');
270: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
271: FND_MESSAGE.Set_Token('FIELD_NAME', 'Tablespace Type');
272: FND_MESSAGE.Set_Token('FIELD_VALUE', p_TABLESPACE_TYPE);
273: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_TABLESPACES');
266: OPEN c1;
267: FETCH c1 INTO l_dummy;
268: if c1%NOTFOUND then
269: FND_MESSAGE.Set_Name('FND', 'OATM_NO_UPDATE');
270: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
271: FND_MESSAGE.Set_Token('FIELD_NAME', 'Tablespace Type');
272: FND_MESSAGE.Set_Token('FIELD_VALUE', p_TABLESPACE_TYPE);
273: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_TABLESPACES');
274: FND_MSG_PUB.Add;
267: FETCH c1 INTO l_dummy;
268: if c1%NOTFOUND then
269: FND_MESSAGE.Set_Name('FND', 'OATM_NO_UPDATE');
270: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
271: FND_MESSAGE.Set_Token('FIELD_NAME', 'Tablespace Type');
272: FND_MESSAGE.Set_Token('FIELD_VALUE', p_TABLESPACE_TYPE);
273: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_TABLESPACES');
274: FND_MSG_PUB.Add;
275: x_return_status := FND_API.G_RET_STS_ERROR;
268: if c1%NOTFOUND then
269: FND_MESSAGE.Set_Name('FND', 'OATM_NO_UPDATE');
270: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
271: FND_MESSAGE.Set_Token('FIELD_NAME', 'Tablespace Type');
272: FND_MESSAGE.Set_Token('FIELD_VALUE', p_TABLESPACE_TYPE);
273: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_TABLESPACES');
274: FND_MSG_PUB.Add;
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: end if;
269: FND_MESSAGE.Set_Name('FND', 'OATM_NO_UPDATE');
270: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');
271: FND_MESSAGE.Set_Token('FIELD_NAME', 'Tablespace Type');
272: FND_MESSAGE.Set_Token('FIELD_VALUE', p_TABLESPACE_TYPE);
273: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_TABLESPACES');
274: FND_MSG_PUB.Add;
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: end if;
277: CLOSE c1;