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.IEM_DB_CONNECTIONS_PVT dependencies on FND_MSG_PUB

Line 61: FND_MSG_PUB.initialize;

57: END IF;
58: -- Initialize message list if p_init_msg_list is set to TRUE.
59: IF FND_API.to_Boolean( p_init_msg_list )
60: THEN
61: FND_MSG_PUB.initialize;
62: END IF;
63: -- Initialize API return status to SUCCESS
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:

Line 77: FND_MSG_PUB.ADD;

73: where db_server_id=p_db_server_id
74: and rownum=1;
75: IF l_grp_cnt = 0 then
76: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DB_SRV_GRP');
77: FND_MSG_PUB.ADD;
78: x_return_status := FND_API.G_RET_STS_ERROR ;
79: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
80: p_data =>x_msg_data);
81: APP_EXCEPTION.RAISE_EXCEPTION;

Line 79: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

75: IF l_grp_cnt = 0 then
76: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DB_SRV_GRP');
77: FND_MSG_PUB.ADD;
78: x_return_status := FND_API.G_RET_STS_ERROR ;
79: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
80: p_data =>x_msg_data);
81: APP_EXCEPTION.RAISE_EXCEPTION;
82: END IF;
83: end if;

Line 151: FND_MSG_PUB.Count_And_Get

147: IF FND_API.To_Boolean(p_commit) THEN
148: COMMIT WORK;
149: END IF;
150: -- Standard callto get message count and if count is 1, get message info.
151: FND_MSG_PUB.Count_And_Get
152: ( p_count => x_msg_count,
153: p_data => x_msg_data
154: );
155: EXCEPTION

Line 159: FND_MSG_PUB.Count_And_Get

155: EXCEPTION
156: WHEN FND_API.G_EXC_ERROR THEN
157: ROLLBACK TO create_item_PVT;
158: x_return_status := FND_API.G_RET_STS_ERROR ;
159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count,
161: p_data => x_msg_data
162: );
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 166: FND_MSG_PUB.Count_And_Get

162: );
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: ROLLBACK TO create_item_PVT;
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
166: FND_MSG_PUB.Count_And_Get
167: ( p_count => x_msg_count,
168: p_data => x_msg_data
169: );
170: WHEN OTHERS THEN

Line 173: IF FND_MSG_PUB.Check_Msg_Level

169: );
170: WHEN OTHERS THEN
171: ROLLBACK TO create_item_PVT;
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: IF FND_MSG_PUB.Check_Msg_Level
174: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: FND_MSG_PUB.Add_Exc_Msg
177: ( G_PKG_NAME ,

Line 174: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

170: WHEN OTHERS THEN
171: ROLLBACK TO create_item_PVT;
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: IF FND_MSG_PUB.Check_Msg_Level
174: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: FND_MSG_PUB.Add_Exc_Msg
177: ( G_PKG_NAME ,
178: l_api_name

Line 176: FND_MSG_PUB.Add_Exc_Msg

172: x_return_status := FND_API.G_RET_STS_ERROR;
173: IF FND_MSG_PUB.Check_Msg_Level
174: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: FND_MSG_PUB.Add_Exc_Msg
177: ( G_PKG_NAME ,
178: l_api_name
179: );
180: END IF;

Line 181: FND_MSG_PUB.Count_And_Get

177: ( G_PKG_NAME ,
178: l_api_name
179: );
180: END IF;
181: FND_MSG_PUB.Count_And_Get
182: ( p_count => x_msg_count ,
183: p_data => x_msg_data
184: );
185:

Line 215: FND_MSG_PUB.initialize;

211: END IF;
212: -- Initialize message list if p_init_msg_list is set to TRUE.
213: IF FND_API.to_Boolean( p_init_msg_list )
214: THEN
215: FND_MSG_PUB.initialize;
216: END IF;
217: -- Initialize API return status to SUCCESS
218: x_return_status := FND_API.G_RET_STS_SUCCESS;
219: if p_db_conn_id = FND_API.G_MISS_NUM then

Line 232: FND_MSG_PUB.Count_And_Get

228: IF FND_API.To_Boolean(p_commit) THEN
229: COMMIT WORK;
230: END IF;
231: -- Standard callto get message count and if count is 1, get message info.
232: FND_MSG_PUB.Count_And_Get
233: ( p_count => x_msg_count,
234: p_data => x_msg_data
235: );
236: EXCEPTION

Line 240: FND_MSG_PUB.Count_And_Get

236: EXCEPTION
237: WHEN FND_API.G_EXC_ERROR THEN
238: ROLLBACK TO delete_item_PVT;
239: x_return_status := FND_API.G_RET_STS_ERROR ;
240: FND_MSG_PUB.Count_And_Get
241: ( p_count => x_msg_count,
242: p_data => x_msg_data
243: );
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 247: FND_MSG_PUB.Count_And_Get

243: );
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: ROLLBACK TO delete_item_PVT;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: FND_MSG_PUB.Count_And_Get
248: ( p_count => x_msg_count,
249: p_data => x_msg_data
250: );
251: WHEN OTHERS THEN

Line 254: IF FND_MSG_PUB.Check_Msg_Level

250: );
251: WHEN OTHERS THEN
252: ROLLBACK TO delete_item_PVT;
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: IF FND_MSG_PUB.Check_Msg_Level
255: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg
258: ( G_PKG_NAME ,

Line 255: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

251: WHEN OTHERS THEN
252: ROLLBACK TO delete_item_PVT;
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: IF FND_MSG_PUB.Check_Msg_Level
255: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg
258: ( G_PKG_NAME ,
259: l_api_name

Line 257: FND_MSG_PUB.Add_Exc_Msg

253: x_return_status := FND_API.G_RET_STS_ERROR;
254: IF FND_MSG_PUB.Check_Msg_Level
255: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg
258: ( G_PKG_NAME ,
259: l_api_name
260: );
261: END IF;

Line 262: FND_MSG_PUB.Count_And_Get

258: ( G_PKG_NAME ,
259: l_api_name
260: );
261: END IF;
262: FND_MSG_PUB.Count_And_Get
263: ( p_count => x_msg_count ,
264: p_data => x_msg_data
265: );
266:

Line 323: FND_MSG_PUB.initialize;

319: END IF;
320: -- Initialize message list if p_init_msg_list is set to TRUE.
321: IF FND_API.to_Boolean( p_init_msg_list )
322: THEN
323: FND_MSG_PUB.initialize;
324: END IF;
325: -- Initialize API return status to SUCCESS
326: x_return_status := FND_API.G_RET_STS_SUCCESS;
327:

Line 337: FND_MSG_PUB.ADD;

333: where db_server_id=p_db_Server_id
334: and rownum=1;
335: IF l_grp_cnt = 0 then
336: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DB_SRV_GRP');
337: FND_MSG_PUB.ADD;
338: x_return_status := FND_API.G_RET_STS_ERROR ;
339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
340: p_data =>x_msg_data);
341: APP_EXCEPTION.RAISE_EXCEPTION;

Line 339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

335: IF l_grp_cnt = 0 then
336: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DB_SRV_GRP');
337: FND_MSG_PUB.ADD;
338: x_return_status := FND_API.G_RET_STS_ERROR ;
339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
340: p_data =>x_msg_data);
341: APP_EXCEPTION.RAISE_EXCEPTION;
342: END IF;
343: end if;

Line 403: FND_MSG_PUB.Count_And_Get

399: IF FND_API.To_Boolean(p_commit) THEN
400: COMMIT WORK;
401: END IF;
402: -- Standard callto get message count and if count is 1, get message info.
403: FND_MSG_PUB.Count_And_Get
404: ( p_count => x_msg_count,
405: p_data => x_msg_data
406: );
407: EXCEPTION

Line 411: FND_MSG_PUB.Count_And_Get

407: EXCEPTION
408: WHEN FND_API.G_EXC_ERROR THEN
409: ROLLBACK TO update_item_PVT;
410: x_return_status := FND_API.G_RET_STS_ERROR ;
411: FND_MSG_PUB.Count_And_Get
412: ( p_count => x_msg_count,
413: p_data => x_msg_data
414: );
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 418: FND_MSG_PUB.Count_And_Get

414: );
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO update_item_PVT;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418: FND_MSG_PUB.Count_And_Get
419: ( p_count => x_msg_count,
420: p_data => x_msg_data
421: );
422: WHEN OTHERS THEN

Line 425: IF FND_MSG_PUB.Check_Msg_Level

421: );
422: WHEN OTHERS THEN
423: ROLLBACK TO update_item_PVT;
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: IF FND_MSG_PUB.Check_Msg_Level
426: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
427: THEN
428: FND_MSG_PUB.Add_Exc_Msg
429: ( G_PKG_NAME ,

Line 426: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

422: WHEN OTHERS THEN
423: ROLLBACK TO update_item_PVT;
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: IF FND_MSG_PUB.Check_Msg_Level
426: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
427: THEN
428: FND_MSG_PUB.Add_Exc_Msg
429: ( G_PKG_NAME ,
430: l_api_name

Line 428: FND_MSG_PUB.Add_Exc_Msg

424: x_return_status := FND_API.G_RET_STS_ERROR;
425: IF FND_MSG_PUB.Check_Msg_Level
426: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
427: THEN
428: FND_MSG_PUB.Add_Exc_Msg
429: ( G_PKG_NAME ,
430: l_api_name
431: );
432: END IF;

Line 433: FND_MSG_PUB.Count_And_Get

429: ( G_PKG_NAME ,
430: l_api_name
431: );
432: END IF;
433: FND_MSG_PUB.Count_And_Get
434: ( p_count => x_msg_count ,
435: p_data => x_msg_data
436: );
437:

Line 467: FND_MSG_PUB.initialize;

463: END IF;
464: -- Initialize message list if p_init_msg_list is set to TRUE.
465: IF FND_API.to_Boolean( p_init_msg_list )
466: THEN
467: FND_MSG_PUB.initialize;
468: END IF;
469: -- Initialize API return status to SUCCESS
470: x_return_status := FND_API.G_RET_STS_SUCCESS;
471: BEGIN

Line 478: FND_MSG_PUB.Add;

474: where db_server_id=p_db_server_id
475: and is_admin=p_is_admin;
476: EXCEPTION WHEN NO_DATA_FOUND THEN
477: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DBLINK_NAME');
478: FND_MSG_PUB.Add;
479: x_return_status := FND_API.G_RET_STS_ERROR ;
480: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
481: p_data =>x_msg_data);
482: WHEN TOO_MANY_ROWS THEN

Line 480: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

476: EXCEPTION WHEN NO_DATA_FOUND THEN
477: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DBLINK_NAME');
478: FND_MSG_PUB.Add;
479: x_return_status := FND_API.G_RET_STS_ERROR ;
480: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
481: p_data =>x_msg_data);
482: WHEN TOO_MANY_ROWS THEN
483: FND_MESSAGE.SET_NAME('IEM','IEM_MORE_THAN_ONE_DBLINK');
484: FND_MSG_PUB.Add;

Line 484: FND_MSG_PUB.Add;

480: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
481: p_data =>x_msg_data);
482: WHEN TOO_MANY_ROWS THEN
483: FND_MESSAGE.SET_NAME('IEM','IEM_MORE_THAN_ONE_DBLINK');
484: FND_MSG_PUB.Add;
485: x_return_status := FND_API.G_RET_STS_ERROR ;
486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
487: p_data =>x_msg_data);
488: END;

Line 486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

482: WHEN TOO_MANY_ROWS THEN
483: FND_MESSAGE.SET_NAME('IEM','IEM_MORE_THAN_ONE_DBLINK');
484: FND_MSG_PUB.Add;
485: x_return_status := FND_API.G_RET_STS_ERROR ;
486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
487: p_data =>x_msg_data);
488: END;
489: -- Standard Check Of p_commit.
490: IF FND_API.To_Boolean(p_commit) THEN

Line 494: FND_MSG_PUB.Count_And_Get

490: IF FND_API.To_Boolean(p_commit) THEN
491: COMMIT WORK;
492: END IF;
493: -- Standard callto get message count and if count is 1, get message info.
494: FND_MSG_PUB.Count_And_Get
495: ( p_count => x_msg_count,
496: p_data => x_msg_data
497: );
498: EXCEPTION

Line 502: FND_MSG_PUB.Count_And_Get

498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO select_item_PVT;
501: x_return_status := FND_API.G_RET_STS_ERROR ;
502: FND_MSG_PUB.Count_And_Get
503: ( p_count => x_msg_count,
504: p_data => x_msg_data
505: );
506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 509: FND_MSG_PUB.Count_And_Get

505: );
506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
507: ROLLBACK TO select_item_PVT;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
509: FND_MSG_PUB.Count_And_Get
510: ( p_count => x_msg_count,
511: p_data => x_msg_data
512: );
513: WHEN OTHERS THEN

Line 516: IF FND_MSG_PUB.Check_Msg_Level

512: );
513: WHEN OTHERS THEN
514: ROLLBACK TO select_item_PVT;
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level
517: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
518: THEN
519: FND_MSG_PUB.Add_Exc_Msg
520: ( G_PKG_NAME ,

Line 517: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

513: WHEN OTHERS THEN
514: ROLLBACK TO select_item_PVT;
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level
517: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
518: THEN
519: FND_MSG_PUB.Add_Exc_Msg
520: ( G_PKG_NAME ,
521: l_api_name

Line 519: FND_MSG_PUB.Add_Exc_Msg

515: x_return_status := FND_API.G_RET_STS_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level
517: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
518: THEN
519: FND_MSG_PUB.Add_Exc_Msg
520: ( G_PKG_NAME ,
521: l_api_name
522: );
523: END IF;

Line 524: FND_MSG_PUB.Count_And_Get

520: ( G_PKG_NAME ,
521: l_api_name
522: );
523: END IF;
524: FND_MSG_PUB.Count_And_Get
525: ( p_count => x_msg_count ,
526: p_data => x_msg_data
527: );
528: END select_item;