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_MSG_PUB

Line 45: FND_MSG_PUB.initialize;

41:
42: -- Initialize message list if p_init_msg_list is set to TRUE.
43: IF FND_API.to_Boolean( p_init_msg_list )
44: THEN
45: FND_MSG_PUB.initialize;
46: END IF;
47:
48: -- Initialize API return status to SUCCESS
49: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 90: FND_MSG_PUB.Count_And_Get

86: COMMIT WORK;
87: END IF;
88:
89: -- Standard call to get message count and if count is 1, get message info.
90: FND_MSG_PUB.Count_And_Get
91: ( p_count => x_msg_count,
92: p_data => x_msg_data);
93:
94: EXCEPTION

Line 98: FND_MSG_PUB.Count_And_Get

94: EXCEPTION
95: WHEN FND_API.G_EXC_ERROR THEN
96: ROLLBACK TO CREATE_OBJECT_TABLESPACES_PUB;
97: x_return_status := FND_API.G_RET_STS_ERROR ;
98: FND_MSG_PUB.Count_And_Get
99: (p_count => x_msg_count,
100: p_data => x_msg_data);
101:
102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 105: FND_MSG_PUB.Count_And_Get

101:
102: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
103: ROLLBACK TO CREATE_OBJECT_TABLESPACES_PUB;
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
105: FND_MSG_PUB.Count_And_Get
106: (p_count => x_msg_count,
107: p_data => x_msg_data);
108:
109: WHEN OTHERS THEN

Line 112: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

108:
109: WHEN OTHERS THEN
110: ROLLBACK TO CREATE_OBJECT_TABLESPACES_PUB;
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
112: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
113: THEN
114: FND_MSG_PUB.Add_Exc_Msg
115: ( G_PKG_NAME,
116: l_api_name);

Line 114: FND_MSG_PUB.Add_Exc_Msg

110: ROLLBACK TO CREATE_OBJECT_TABLESPACES_PUB;
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
112: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
113: THEN
114: FND_MSG_PUB.Add_Exc_Msg
115: ( G_PKG_NAME,
116: l_api_name);
117: END IF;
118: FND_MSG_PUB.Count_And_Get

Line 118: FND_MSG_PUB.Count_And_Get

114: FND_MSG_PUB.Add_Exc_Msg
115: ( G_PKG_NAME,
116: l_api_name);
117: END IF;
118: FND_MSG_PUB.Count_And_Get
119: (p_count => x_msg_count,
120: p_data => x_msg_data);
121:
122: END CREATE_OBJECT_TABLESPACES;

Line 160: FND_MSG_PUB.initialize;

156:
157: -- Initialize message list if p_init_msg_list is set to TRUE.
158: IF FND_API.to_Boolean( p_init_msg_list )
159: THEN
160: FND_MSG_PUB.initialize;
161: END IF;
162:
163: -- Initialize API return status to SUCCESS
164: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 202: FND_MSG_PUB.Count_And_Get

198: COMMIT WORK;
199: END IF;
200:
201: -- Standard call to get message count and if count is 1, get message info.
202: FND_MSG_PUB.Count_And_Get
203: ( p_count => x_msg_count,
204: p_data => x_msg_data);
205:
206: EXCEPTION

Line 210: FND_MSG_PUB.Count_And_Get

206: EXCEPTION
207: WHEN FND_API.G_EXC_ERROR THEN
208: ROLLBACK TO UPDATE_OBJECT_TABLESPACES_PUB;
209: x_return_status := FND_API.G_RET_STS_ERROR ;
210: FND_MSG_PUB.Count_And_Get
211: (p_count => x_msg_count,
212: p_data => x_msg_data);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 217: FND_MSG_PUB.Count_And_Get

213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: ROLLBACK TO UPDATE_OBJECT_TABLESPACES_PUB;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
217: FND_MSG_PUB.Count_And_Get
218: (p_count => x_msg_count,
219: p_data => x_msg_data);
220:
221: WHEN OTHERS THEN

Line 224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

220:
221: WHEN OTHERS THEN
222: ROLLBACK TO UPDATE_OBJECT_TABLESPACES_PUB;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
225: THEN
226: FND_MSG_PUB.Add_Exc_Msg
227: ( G_PKG_NAME,
228: l_api_name);

Line 226: FND_MSG_PUB.Add_Exc_Msg

222: ROLLBACK TO UPDATE_OBJECT_TABLESPACES_PUB;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
225: THEN
226: FND_MSG_PUB.Add_Exc_Msg
227: ( G_PKG_NAME,
228: l_api_name);
229: END IF;
230: FND_MSG_PUB.Count_And_Get

Line 230: FND_MSG_PUB.Count_And_Get

226: FND_MSG_PUB.Add_Exc_Msg
227: ( G_PKG_NAME,
228: l_api_name);
229: END IF;
230: FND_MSG_PUB.Count_And_Get
231: (p_count => x_msg_count,
232: p_data => x_msg_data);
233:
234: END UPDATE_OBJECT_TABLESPACES;

Line 310: FND_MSG_PUB.Add;

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;
313:
314: -- validate NOT NULL column

Line 320: FND_MSG_PUB.Add;

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;
323:
324: -- validate NOT NULL column

Line 330: FND_MSG_PUB.Add;

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;
333:
334: IF (p_OBJECT_TYPE is NULL OR p_OBJECT_TYPE = FND_API.G_MISS_CHAR)

Line 339: FND_MSG_PUB.Add;

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;
342:
343: IF (p_APPLICATION_SHORT_NAME is not NULL AND p_APPLICATION_SHORT_NAME <> FND_API.G_MISS_CHAR)

Line 352: FND_MSG_PUB.Add;

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;
354: end if;
355: CLOSE c2;
356: END IF;

Line 365: FND_MSG_PUB.Add;

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;
367: end if;
368: END IF;
369:

Line 386: FND_MSG_PUB.Add;

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;
390:

Line 398: FND_MSG_PUB.Add;

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;
400: end if;
401: CLOSE c3;
402: END IF;

Line 419: FND_MSG_PUB.Add;

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;
423: END IF;

Line 436: FND_MSG_PUB.Add;

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;
437: x_return_status := FND_API.G_RET_STS_ERROR;
438: end if;
439: CLOSE c1;
440: END IF;

Line 446: FND_MSG_PUB.Count_And_Get

442: x_application_id := l_application_id;
443: x_oracle_username := l_oracle_username;
444:
445: -- Standard call to get message count and if count is 1, get message info.
446: FND_MSG_PUB.Count_And_Get
447: ( p_count => x_msg_count,
448: p_data => x_msg_data
449: );
450: END VALIDATE_OBJECT_TABLESPACES;