DBA Data[Home] [Help]

APPS.FND_OBJECT_TABLESPACES_PUB dependencies on FND_OBJECT_TABLESPACES_PUB

Line 1: PACKAGE BODY FND_OBJECT_TABLESPACES_PUB AS

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

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

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

Line 308: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');

304: -- validate NOT NULL column
305: IF (p_APPLICATION_SHORT_NAME is NULL OR p_APPLICATION_SHORT_NAME = FND_API.G_MISS_CHAR)
306: THEN
307: FND_MESSAGE.Set_Name('FND', 'OATM_REQUIRED_ENTRY');
308: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');
309: FND_MESSAGE.Set_Token('FIELD', 'Application Short Name');
310: FND_MSG_PUB.Add;
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: END IF;

Line 318: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');

314: -- validate NOT NULL column
315: IF (p_OBJECT_NAME is NULL OR p_OBJECT_NAME = FND_API.G_MISS_CHAR)
316: THEN
317: FND_MESSAGE.Set_Name('FND', 'OATM_REQUIRED_ENTRY');
318: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');
319: FND_MESSAGE.Set_Token('FIELD', 'Object Name');
320: FND_MSG_PUB.Add;
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: END IF;

Line 328: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');

324: -- validate NOT NULL column
325: IF (p_TABLESPACE_TYPE is NULL OR p_TABLESPACE_TYPE = FND_API.G_MISS_CHAR)
326: THEN
327: FND_MESSAGE.Set_Name('FND', 'OATM_REQUIRED_ENTRY');
328: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');
329: FND_MESSAGE.Set_Token('FIELD', 'Tablespace Type');
330: FND_MSG_PUB.Add;
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: END IF;

Line 337: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');

333:
334: IF (p_OBJECT_TYPE is NULL OR p_OBJECT_TYPE = FND_API.G_MISS_CHAR)
335: THEN
336: FND_MESSAGE.Set_Name('FND', 'OATM_REQUIRED_ENTRY');
337: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');
338: FND_MESSAGE.Set_Token('FIELD', 'Object Type');
339: FND_MSG_PUB.Add;
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: END IF;

Line 349: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');

345: OPEN c2;
346: FETCH c2 INTO l_application_id;
347: if c2%NOTFOUND then
348: FND_MESSAGE.Set_Name('FND', 'OATM_INVALID_ENTRY');
349: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');
350: FND_MESSAGE.Set_Token('FIELD_NAME', 'Application Short Name');
351: FND_MESSAGE.Set_Token('FIELD_VALUE', p_APPLICATION_SHORT_NAME);
352: FND_MSG_PUB.Add;
353: x_return_status := FND_API.G_RET_STS_ERROR;

Line 362: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');

358: IF (p_OBJECT_TYPE is NOT NULL OR p_OBJECT_TYPE <> FND_API.G_MISS_CHAR)
359: THEN
360: if p_OBJECT_TYPE <> 'TABLE' then
361: FND_MESSAGE.Set_Name('FND', 'OATM_INVALID_ENTRY');
362: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');
363: FND_MESSAGE.Set_Token('FIELD_NAME', 'Object Type');
364: FND_MESSAGE.Set_Token('FIELD_VALUE', p_OBJECT_TYPE);
365: FND_MSG_PUB.Add;
366: x_return_status := FND_API.G_RET_STS_ERROR;

Line 382: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');

378: OPEN c5(l_application_id);
379: FETCH c5 INTO l_dummy;
380: if c5%FOUND then
381: FND_MESSAGE.Set_Name('FND', 'OATM_NO_INSERT');
382: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');
383: FND_MESSAGE.Set_Token('FIELD_NAME', 'Object Name');
384: FND_MESSAGE.Set_Token('FIELD_VALUE', p_OBJECT_NAME);
385: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_OBJECT_TABLESPACES');
386: FND_MSG_PUB.Add;

Line 395: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');

391: OPEN c3(l_oracle_username);
392: FETCH c3 INTO l_dummy;
393: if c3%NOTFOUND then
394: FND_MESSAGE.Set_Name('FND', 'OATM_INVALID_ENTRY');
395: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');
396: FND_MESSAGE.Set_Token('FIELD_NAME', 'Object Name');
397: FND_MESSAGE.Set_Token('FIELD_VALUE', p_OBJECT_NAME);
398: FND_MSG_PUB.Add;
399: x_return_status := FND_API.G_RET_STS_ERROR;

Line 415: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');

411: OPEN c3(l_oracle_username);
412: FETCH c3 INTO l_dummy;
413: if c3%NOTFOUND then
414: FND_MESSAGE.Set_Name('FND', 'OATM_NO_UPDATE');
415: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');
416: FND_MESSAGE.Set_Token('FIELD_NAME', 'Object Name');
417: FND_MESSAGE.Set_Token('FIELD_VALUE', p_OBJECT_NAME);
418: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_OBJECT_TABLESPACES');
419: FND_MSG_PUB.Add;

Line 432: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');

428: OPEN c1;
429: FETCH c1 INTO l_dummy;
430: if c1%NOTFOUND then
431: FND_MESSAGE.Set_Name('FND', 'OATM_NO_UPDATE');
432: FND_MESSAGE.Set_Token('ROUTINE', 'FND_OBJECT_TABLESPACES_PUB');
433: FND_MESSAGE.Set_Token('FIELD_NAME', 'Tablespace Type');
434: FND_MESSAGE.Set_Token('FIELD_VALUE', p_TABLESPACE_TYPE);
435: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_TABLESPACES');
436: FND_MSG_PUB.Add;

Line 452: END FND_OBJECT_TABLESPACES_PUB;

448: p_data => x_msg_data
449: );
450: END VALIDATE_OBJECT_TABLESPACES;
451:
452: END FND_OBJECT_TABLESPACES_PUB;