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_EML_CLASSIFICATIONS_PVT dependencies on FND_MSG_PUB

Line 66: FND_MSG_PUB.initialize;

62: END IF;
63: -- Initialize message list if p_init_msg_list is set to TRUE.
64: IF FND_API.to_Boolean( p_init_msg_list )
65: THEN
66: FND_MSG_PUB.initialize;
67: END IF;
68: -- Initialize API return status to SUCCESS
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70: select count(*) into l_count from iem_email_classifications

Line 104: FND_MSG_PUB.Count_And_Get

100: IF FND_API.To_Boolean(p_commit) THEN
101: COMMIT WORK;
102: END IF;
103: -- Standard callto get message count and if count is 1, get message info.
104: FND_MSG_PUB.Count_And_Get
105: ( p_count => x_msg_count,
106: p_data => x_msg_data
107: );
108: EXCEPTION

Line 112: FND_MSG_PUB.Count_And_Get

108: EXCEPTION
109: WHEN FND_API.G_EXC_ERROR THEN
110: -- ROLLBACK TO update_item_PVT;
111: x_return_status := FND_API.G_RET_STS_ERROR ;
112: FND_MSG_PUB.Count_And_Get
113: ( p_count => x_msg_count,
114: p_data => x_msg_data
115: );
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 119: FND_MSG_PUB.Count_And_Get

115: );
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117: -- ROLLBACK TO update_item_PVT;
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: FND_MSG_PUB.Count_And_Get
120: ( p_count => x_msg_count,
121: p_data => x_msg_data
122: );
123: WHEN OTHERS THEN

Line 126: IF FND_MSG_PUB.Check_Msg_Level

122: );
123: WHEN OTHERS THEN
124: -- ROLLBACK TO update_item_PVT;
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: IF FND_MSG_PUB.Check_Msg_Level
127: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
128: THEN
129: FND_MSG_PUB.Add_Exc_Msg
130: ( G_PKG_NAME ,

Line 127: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

123: WHEN OTHERS THEN
124: -- ROLLBACK TO update_item_PVT;
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: IF FND_MSG_PUB.Check_Msg_Level
127: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
128: THEN
129: FND_MSG_PUB.Add_Exc_Msg
130: ( G_PKG_NAME ,
131: l_api_name

Line 129: FND_MSG_PUB.Add_Exc_Msg

125: x_return_status := FND_API.G_RET_STS_ERROR;
126: IF FND_MSG_PUB.Check_Msg_Level
127: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
128: THEN
129: FND_MSG_PUB.Add_Exc_Msg
130: ( G_PKG_NAME ,
131: l_api_name
132: );
133: END IF;

Line 134: FND_MSG_PUB.Count_And_Get

130: ( G_PKG_NAME ,
131: l_api_name
132: );
133: END IF;
134: FND_MSG_PUB.Count_And_Get
135: ( p_count => x_msg_count ,
136: p_data => x_msg_data
137: );
138:

Line 194: FND_MSG_PUB.initialize;

190: END IF;
191: -- Initialize message list if p_init_msg_list is set to TRUE.
192: IF FND_API.to_Boolean( p_init_msg_list )
193: THEN
194: FND_MSG_PUB.initialize;
195: END IF;
196: -- Initialize API return status to SUCCESS
197: x_return_status := FND_API.G_RET_STS_SUCCESS;
198: DELETE FROM IEM_EMAIL_CLASSIFICATIONS

Line 207: FND_MSG_PUB.Count_And_Get

203: IF FND_API.To_Boolean(p_commit) THEN
204: COMMIT WORK;
205: END IF;
206: -- Standard callto get message count and if count is 1, get message info.
207: FND_MSG_PUB.Count_And_Get
208: ( p_count => x_msg_count,
209: p_data => x_msg_data
210: );
211: EXCEPTION

Line 215: FND_MSG_PUB.Count_And_Get

211: EXCEPTION
212: WHEN FND_API.G_EXC_ERROR THEN
213: -- ROLLBACK TO delete_item_PVT;
214: x_return_status := FND_API.G_RET_STS_ERROR ;
215: FND_MSG_PUB.Count_And_Get
216: ( p_count => x_msg_count,
217: p_data => x_msg_data
218: );
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 222: FND_MSG_PUB.Count_And_Get

218: );
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: --ROLLBACK TO delete_item_PVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
222: FND_MSG_PUB.Count_And_Get
223: ( p_count => x_msg_count,
224: p_data => x_msg_data
225: );
226: WHEN OTHERS THEN

Line 229: IF FND_MSG_PUB.Check_Msg_Level

225: );
226: WHEN OTHERS THEN
227: --ROLLBACK TO delete_item_PVT;
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: IF FND_MSG_PUB.Check_Msg_Level
230: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
231: THEN
232: FND_MSG_PUB.Add_Exc_Msg
233: ( G_PKG_NAME ,

Line 230: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

226: WHEN OTHERS THEN
227: --ROLLBACK TO delete_item_PVT;
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: IF FND_MSG_PUB.Check_Msg_Level
230: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
231: THEN
232: FND_MSG_PUB.Add_Exc_Msg
233: ( G_PKG_NAME ,
234: l_api_name

Line 232: FND_MSG_PUB.Add_Exc_Msg

228: x_return_status := FND_API.G_RET_STS_ERROR;
229: IF FND_MSG_PUB.Check_Msg_Level
230: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
231: THEN
232: FND_MSG_PUB.Add_Exc_Msg
233: ( G_PKG_NAME ,
234: l_api_name
235: );
236: END IF;

Line 237: FND_MSG_PUB.Count_And_Get

233: ( G_PKG_NAME ,
234: l_api_name
235: );
236: END IF;
237: FND_MSG_PUB.Count_And_Get
238: ( p_count => x_msg_count ,
239: p_data => x_msg_data
240: );
241:

Line 279: FND_MSG_PUB.initialize;

275: END IF;
276: -- Initialize message list if p_init_msg_list is set to TRUE.
277: IF FND_API.to_Boolean( p_init_msg_list )
278: THEN
279: FND_MSG_PUB.initialize;
280: END IF;
281: -- Initialize API return status to SUCCESS
282: x_return_status := FND_API.G_RET_STS_SUCCESS;
283:

Line 300: FND_MSG_PUB.Count_And_Get

296: IF FND_API.To_Boolean(p_commit) THEN
297: COMMIT WORK;
298: END IF;
299: -- Standard callto get message count and if count is 1, get message info.
300: FND_MSG_PUB.Count_And_Get
301: ( p_count => x_msg_count,
302: p_data => x_msg_data
303: );
304:

Line 310: FND_MSG_PUB.Count_And_Get

306: EXCEPTION
307: WHEN FND_API.G_EXC_ERROR THEN
308: --ROLLBACK TO getclassification_pvt;
309: x_return_status := FND_API.G_RET_STS_ERROR ;
310: FND_MSG_PUB.Count_And_Get
311: ( p_count => x_msg_count,
312: p_data => x_msg_data
313: );
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 317: FND_MSG_PUB.Count_And_Get

313: );
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: --ROLLBACK TO getclassification_pvt;
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
317: FND_MSG_PUB.Count_And_Get
318: ( p_count => x_msg_count,
319: p_data => x_msg_data
320: );
321: WHEN OTHERS THEN

Line 324: IF FND_MSG_PUB.Check_Msg_Level

320: );
321: WHEN OTHERS THEN
322: --ROLLBACK TO getclassification_pvt;
323: x_return_status := FND_API.G_RET_STS_ERROR;
324: IF FND_MSG_PUB.Check_Msg_Level
325: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
326: THEN
327: FND_MSG_PUB.Add_Exc_Msg
328: ( G_PKG_NAME ,

Line 325: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

321: WHEN OTHERS THEN
322: --ROLLBACK TO getclassification_pvt;
323: x_return_status := FND_API.G_RET_STS_ERROR;
324: IF FND_MSG_PUB.Check_Msg_Level
325: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
326: THEN
327: FND_MSG_PUB.Add_Exc_Msg
328: ( G_PKG_NAME ,
329: l_api_name

Line 327: FND_MSG_PUB.Add_Exc_Msg

323: x_return_status := FND_API.G_RET_STS_ERROR;
324: IF FND_MSG_PUB.Check_Msg_Level
325: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
326: THEN
327: FND_MSG_PUB.Add_Exc_Msg
328: ( G_PKG_NAME ,
329: l_api_name
330: );
331: END IF;

Line 332: FND_MSG_PUB.Count_And_Get

328: ( G_PKG_NAME ,
329: l_api_name
330: );
331: END IF;
332: FND_MSG_PUB.Count_And_Get
333: ( p_count => x_msg_count ,
334: p_data => x_msg_data
335: );
336:

Line 377: FND_MSG_PUB.initialize;

373: END IF;
374: -- Initialize message list if p_init_msg_list is set to TRUE.
375: IF FND_API.to_Boolean( p_init_msg_list )
376: THEN
377: FND_MSG_PUB.initialize;
378: END IF;
379: -- Initialize API return status to SUCCESS
380: x_return_status := FND_API.G_RET_STS_SUCCESS;
381: BEGIN

Line 407: FND_MSG_PUB.Count_And_Get

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

Line 417: FND_MSG_PUB.Count_And_Get

413: EXCEPTION
414: WHEN FND_API.G_EXC_ERROR THEN
415: --ROLLBACK TO getclassification_pvt;
416: x_return_status := FND_API.G_RET_STS_ERROR ;
417: FND_MSG_PUB.Count_And_Get
418: ( p_count => x_msg_count,
419: p_data => x_msg_data
420: );
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 424: FND_MSG_PUB.Count_And_Get

420: );
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422: --ROLLBACK TO getclassification_pvt;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
424: FND_MSG_PUB.Count_And_Get
425: ( p_count => x_msg_count,
426: p_data => x_msg_data
427: );
428: WHEN OTHERS THEN

Line 431: IF FND_MSG_PUB.Check_Msg_Level

427: );
428: WHEN OTHERS THEN
429: --ROLLBACK TO getclassification_pvt;
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: IF FND_MSG_PUB.Check_Msg_Level
432: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
433: THEN
434: FND_MSG_PUB.Add_Exc_Msg
435: ( G_PKG_NAME ,

Line 432: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

428: WHEN OTHERS THEN
429: --ROLLBACK TO getclassification_pvt;
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: IF FND_MSG_PUB.Check_Msg_Level
432: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
433: THEN
434: FND_MSG_PUB.Add_Exc_Msg
435: ( G_PKG_NAME ,
436: l_api_name

Line 434: FND_MSG_PUB.Add_Exc_Msg

430: x_return_status := FND_API.G_RET_STS_ERROR;
431: IF FND_MSG_PUB.Check_Msg_Level
432: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
433: THEN
434: FND_MSG_PUB.Add_Exc_Msg
435: ( G_PKG_NAME ,
436: l_api_name
437: );
438: END IF;

Line 439: FND_MSG_PUB.Count_And_Get

435: ( G_PKG_NAME ,
436: l_api_name
437: );
438: END IF;
439: FND_MSG_PUB.Count_And_Get
440: ( p_count => x_msg_count ,
441: p_data => x_msg_data
442: );
443:

Line 508: FND_MSG_PUB.initialize;

504: END IF;
505: -- Initialize message list if p_init_msg_list is set to TRUE.
506: IF FND_API.to_Boolean( p_init_msg_list )
507: THEN
508: FND_MSG_PUB.initialize;
509: END IF;
510: -- Initialize API return status to SUCCESS
511: x_return_status := FND_API.G_RET_STS_SUCCESS;
512: select count(*) into l_count from iem_email_classifications

Line 548: FND_MSG_PUB.Count_And_Get

544: IF FND_API.To_Boolean(p_commit) THEN
545: COMMIT WORK;
546: END IF;
547: -- Standard callto get message count and if count is 1, get message info.
548: FND_MSG_PUB.Count_And_Get
549: ( p_count => x_msg_count,
550: p_data => x_msg_data
551: );
552: EXCEPTION

Line 555: FND_MSG_PUB.Count_And_Get

551: );
552: EXCEPTION
553: WHEN FND_API.G_EXC_ERROR THEN
554: x_return_status := FND_API.G_RET_STS_ERROR ;
555: FND_MSG_PUB.Count_And_Get
556: ( p_count => x_msg_count,
557: p_data => x_msg_data
558: );
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 561: FND_MSG_PUB.Count_And_Get

557: p_data => x_msg_data
558: );
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
561: FND_MSG_PUB.Count_And_Get
562: ( p_count => x_msg_count,
563: p_data => x_msg_data
564: );
565: WHEN OTHERS THEN

Line 567: IF FND_MSG_PUB.Check_Msg_Level

563: p_data => x_msg_data
564: );
565: WHEN OTHERS THEN
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: IF FND_MSG_PUB.Check_Msg_Level
568: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
569: THEN
570: FND_MSG_PUB.Add_Exc_Msg
571: ( G_PKG_NAME ,

Line 568: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

564: );
565: WHEN OTHERS THEN
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: IF FND_MSG_PUB.Check_Msg_Level
568: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
569: THEN
570: FND_MSG_PUB.Add_Exc_Msg
571: ( G_PKG_NAME ,
572: l_api_name

Line 570: FND_MSG_PUB.Add_Exc_Msg

566: x_return_status := FND_API.G_RET_STS_ERROR;
567: IF FND_MSG_PUB.Check_Msg_Level
568: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
569: THEN
570: FND_MSG_PUB.Add_Exc_Msg
571: ( G_PKG_NAME ,
572: l_api_name
573: );
574: END IF;

Line 575: FND_MSG_PUB.Count_And_Get

571: ( G_PKG_NAME ,
572: l_api_name
573: );
574: END IF;
575: FND_MSG_PUB.Count_And_Get
576: ( p_count => x_msg_count ,
577: p_data => x_msg_data
578: );
579: