eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_OBJECT_TABLESPACES_PUB dependencies on FND_OBJECT_TABLESPACES

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 67: FND_OBJECT_TABLESPACES_PKG.INSERT_ROW(

63: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;
66:
67: FND_OBJECT_TABLESPACES_PKG.INSERT_ROW(
68: X_ROWID => l_row_id,
69: P_APPLICATION_ID => l_application_id,
70: P_OBJECT_NAME => P_OBJECT_NAME,
71: P_OBJECT_TYPE => P_OBJECT_TYPE,

Line 182: FND_OBJECT_TABLESPACES_PKG.UPDATE_ROW(

178: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
179: RAISE FND_API.G_EXC_ERROR;
180: END IF;
181:
182: FND_OBJECT_TABLESPACES_PKG.UPDATE_ROW(
183: P_APPLICATION_ID => l_application_id,
184: P_OBJECT_NAME => p_OBJECT_NAME,
185: P_OBJECT_TYPE => p_OBJECT_TYPE,
186: P_TABLESPACE_TYPE => NULL,

Line 269: from fnd_object_tablespaces

265: and fpi.application_id = l_app_id;
266:
267: cursor c5(l_app_id NUMBER) is
268: select 1
269: from fnd_object_tablespaces
270: where application_id = l_app_id
271: and object_name = p_object_name;
272:
273: cursor c3(l_oracle_user VARCHAR2) is

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 385: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_OBJECT_TABLESPACES');

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;
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: end if;
389: CLOSE c5;

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 418: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_OBJECT_TABLESPACES');

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;
420: x_return_status := FND_API.G_RET_STS_ERROR;
421: end if;
422: CLOSE c3;

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;