APPS.FND_TABLESPACES_PUB dependencies on FND_TABLESPACES_PUB

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 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 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 289: END FND_TABLESPACES_PUB;

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