APPS.FND_TABLESPACES_PUB dependencies on FND_TABLESPACES

Line 1: PACKAGE BODY FND_TABLESPACES_PUB AS

1: PACKAGE BODY FND_TABLESPACES_PUB AS
2: /* $Header: fndptblb.pls 115.3 2004/04/16 20:26:04 sakhtar noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'FND_TABLESPACES_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'fndptblb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'FND_TABLESPACES_PUB';

1: PACKAGE BODY FND_TABLESPACES_PUB AS
2: /* $Header: fndptblb.pls 115.3 2004/04/16 20:26:04 sakhtar noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'FND_TABLESPACES_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'fndptblb.pls';
6:
7: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 59: FND_TABLESPACES_PKG.INSERT_ROW(

55: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
56: RAISE FND_API.G_EXC_ERROR;
57: END IF;
58:
59: FND_TABLESPACES_PKG.INSERT_ROW(
60: X_ROWID => l_row_id,
61: P_TABLESPACE_TYPE => P_TABLESPACE_TYPE,
62: P_TABLESPACE => P_TABLESPACE,
63: P_CUSTOM_FLAG => 'C',

Line 160: FND_TABLESPACES_PKG.UPDATE_ROW(

156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: FND_TABLESPACES_PKG.UPDATE_ROW(
161: P_TABLESPACE_TYPE => P_TABLESPACE_TYPE,
162: P_TABLESPACE => P_TABLESPACE,
163: P_CUSTOM_FLAG => 'C',
164: P_LAST_UPDATE_DATE => sysdate,

Line 220: from fnd_tablespaces

216: X_Msg_Data OUT NOCOPY VARCHAR2)
217: IS
218: cursor c1 is
219: select 1
220: from fnd_tablespaces
221: where tablespace_type = p_tablespace_type;
222: l_dummy NUMBER;
223: BEGIN
224:

Line 229: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');

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;

Line 239: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');

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;

Line 253: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');

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;

Line 256: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_TABLESPACES');

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;

Line 270: FND_MESSAGE.Set_Token('ROUTINE', 'FND_TABLESPACES_PUB');

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;

Line 273: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_TABLESPACES');

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;

Line 289: END FND_TABLESPACES_PUB;

285: );
286: END VALIDATE_TABLESPACES;
287:
288:
289: END FND_TABLESPACES_PUB;