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

Line 48: FND_MSG_PUB.initialize;

44: END IF;
45: -- Initialize message list if p_init_msg_list is set to TRUE.
46: IF FND_API.to_Boolean( p_init_msg_list )
47: THEN
48: FND_MSG_PUB.initialize;
49: END IF;
50: -- Initialize API return status to SUCCESS
51: x_return_status := FND_API.G_RET_STS_SUCCESS;
52: for c_kb_rec in kb_results_csr

Line 68: FND_MSG_PUB.Count_And_Get

64: IF FND_API.To_Boolean(p_commit) THEN
65: COMMIT WORK;
66: END IF;
67: -- Standard callto get message count and if count is 1, get message info.
68: FND_MSG_PUB.Count_And_Get
69: ( p_count => x_msg_count,
70: p_data => x_msg_data
71: );
72: EXCEPTION

Line 76: FND_MSG_PUB.Count_And_Get

72: EXCEPTION
73: WHEN FND_API.G_EXC_ERROR THEN
74: ROLLBACK TO Get_SuggResponse_PUB;
75: x_return_status := FND_API.G_RET_STS_ERROR ;
76: FND_MSG_PUB.Count_And_Get
77: ( p_count => x_msg_count,
78: p_data => x_msg_data
79: );
80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 83: FND_MSG_PUB.Count_And_Get

79: );
80: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
81: ROLLBACK TO Get_SuggResponse_PUB;
82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
83: FND_MSG_PUB.Count_And_Get
84: ( p_count => x_msg_count,
85: p_data => x_msg_data
86: );
87: WHEN OTHERS THEN

Line 90: IF FND_MSG_PUB.Check_Msg_Level

86: );
87: WHEN OTHERS THEN
88: ROLLBACK TO Get_SuggResponse_PUB;
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: IF FND_MSG_PUB.Check_Msg_Level
91: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
92: THEN
93: FND_MSG_PUB.Add_Exc_Msg
94: ( G_PKG_NAME ,

Line 91: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

87: WHEN OTHERS THEN
88: ROLLBACK TO Get_SuggResponse_PUB;
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: IF FND_MSG_PUB.Check_Msg_Level
91: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
92: THEN
93: FND_MSG_PUB.Add_Exc_Msg
94: ( G_PKG_NAME ,
95: l_api_name

Line 93: FND_MSG_PUB.Add_Exc_Msg

89: x_return_status := FND_API.G_RET_STS_ERROR;
90: IF FND_MSG_PUB.Check_Msg_Level
91: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
92: THEN
93: FND_MSG_PUB.Add_Exc_Msg
94: ( G_PKG_NAME ,
95: l_api_name
96: );
97: END IF;

Line 98: FND_MSG_PUB.Count_And_Get

94: ( G_PKG_NAME ,
95: l_api_name
96: );
97: END IF;
98: FND_MSG_PUB.Count_And_Get
99: ( p_count => x_msg_count ,
100: p_data => x_msg_data
101: );
102:

Line 148: FND_MSG_PUB.initialize;

144: END IF;
145: -- Initialize message list if p_init_msg_list is set to TRUE.
146: IF FND_API.to_Boolean( p_init_msg_list )
147: THEN
148: FND_MSG_PUB.initialize;
149: END IF;
150: -- Initialize API return status to SUCCESS
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152: /*

Line 182: FND_MSG_PUB.Count_And_Get

178: IF FND_API.To_Boolean(p_commit) THEN
179: COMMIT WORK;
180: END IF;
181: -- Standard callto get message count and if count is 1, get message info.
182: FND_MSG_PUB.Count_And_Get
183: ( p_count => x_msg_count,
184: p_data => x_msg_data
185: );
186: EXCEPTION

Line 190: FND_MSG_PUB.Count_And_Get

186: EXCEPTION
187: WHEN FND_API.G_EXC_ERROR THEN
188: ROLLBACK TO Get_KBCategories_PUB;
189: x_return_status := FND_API.G_RET_STS_ERROR ;
190: FND_MSG_PUB.Count_And_Get
191: ( p_count => x_msg_count,
192: p_data => x_msg_data
193: );
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 197: FND_MSG_PUB.Count_And_Get

193: );
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: ROLLBACK TO Get_KBCategories_PUB;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197: FND_MSG_PUB.Count_And_Get
198: ( p_count => x_msg_count,
199: p_data => x_msg_data
200: );
201: WHEN OTHERS THEN

Line 204: IF FND_MSG_PUB.Check_Msg_Level

200: );
201: WHEN OTHERS THEN
202: ROLLBACK TO Get_KBCategories_PUB;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: IF FND_MSG_PUB.Check_Msg_Level
205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: FND_MSG_PUB.Add_Exc_Msg
208: ( G_PKG_NAME ,

Line 205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

201: WHEN OTHERS THEN
202: ROLLBACK TO Get_KBCategories_PUB;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: IF FND_MSG_PUB.Check_Msg_Level
205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: FND_MSG_PUB.Add_Exc_Msg
208: ( G_PKG_NAME ,
209: l_api_name

Line 207: FND_MSG_PUB.Add_Exc_Msg

203: x_return_status := FND_API.G_RET_STS_ERROR;
204: IF FND_MSG_PUB.Check_Msg_Level
205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: FND_MSG_PUB.Add_Exc_Msg
208: ( G_PKG_NAME ,
209: l_api_name
210: );
211: END IF;

Line 212: FND_MSG_PUB.Count_And_Get

208: ( G_PKG_NAME ,
209: l_api_name
210: );
211: END IF;
212: FND_MSG_PUB.Count_And_Get
213: ( p_count => x_msg_count ,
214: p_data => x_msg_data
215: );
216:

Line 244: FND_MSG_PUB.initialize;

240: END IF;
241: -- Initialize message list if p_init_msg_list is set to TRUE.
242: IF FND_API.to_Boolean( p_init_msg_list )
243: THEN
244: FND_MSG_PUB.initialize;
245: END IF;
246: -- Initialize API return status to SUCCESS
247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248: DELETE FROM IEM_KB_RESULTS

Line 260: FND_MSG_PUB.Count_And_Get

256: IF FND_API.To_Boolean(p_commit) THEN
257: COMMIT WORK;
258: END IF;
259: -- Standard callto get message count and if count is 1, get message info.
260: FND_MSG_PUB.Count_And_Get
261: ( p_count => x_msg_count,
262: p_data => x_msg_data
263: );
264: EXCEPTION

Line 268: FND_MSG_PUB.Count_And_Get

264: EXCEPTION
265: WHEN FND_API.G_EXC_ERROR THEN
266: ROLLBACK TO Delete_Resultscache_PUB;
267: x_return_status := FND_API.G_RET_STS_ERROR ;
268: FND_MSG_PUB.Count_And_Get
269: ( p_count => x_msg_count,
270: p_data => x_msg_data
271: );
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 275: FND_MSG_PUB.Count_And_Get

271: );
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: ROLLBACK TO Delete_Resultscache_PUB;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: FND_MSG_PUB.Count_And_Get
276: ( p_count => x_msg_count,
277: p_data => x_msg_data
278: );
279: WHEN OTHERS THEN

Line 282: IF FND_MSG_PUB.Check_Msg_Level

278: );
279: WHEN OTHERS THEN
280: ROLLBACK TO Delete_Resultscache_PUB;
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: IF FND_MSG_PUB.Check_Msg_Level
283: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
284: THEN
285: FND_MSG_PUB.Add_Exc_Msg
286: ( G_PKG_NAME ,

Line 283: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

279: WHEN OTHERS THEN
280: ROLLBACK TO Delete_Resultscache_PUB;
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: IF FND_MSG_PUB.Check_Msg_Level
283: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
284: THEN
285: FND_MSG_PUB.Add_Exc_Msg
286: ( G_PKG_NAME ,
287: l_api_name

Line 285: FND_MSG_PUB.Add_Exc_Msg

281: x_return_status := FND_API.G_RET_STS_ERROR;
282: IF FND_MSG_PUB.Check_Msg_Level
283: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
284: THEN
285: FND_MSG_PUB.Add_Exc_Msg
286: ( G_PKG_NAME ,
287: l_api_name
288: );
289: END IF;

Line 290: FND_MSG_PUB.Count_And_Get

286: ( G_PKG_NAME ,
287: l_api_name
288: );
289: END IF;
290: FND_MSG_PUB.Count_And_Get
291: ( p_count => x_msg_count ,
292: p_data => x_msg_data
293: );
294: END Delete_ResultsCache ;

Line 341: FND_MSG_PUB.initialize;

337: END IF;
338: -- Initialize message list if p_init_msg_list is set to TRUE.
339: IF FND_API.to_Boolean( p_init_msg_list )
340: THEN
341: FND_MSG_PUB.initialize;
342: END IF;
343: -- Initialize API return status to SUCCESS
344: x_return_status := FND_API.G_RET_STS_SUCCESS;
345: -- iem_mailpreproc_pub.iem_wf_specificsearch(p_message_id,p_email_account_id,p_classification_id,l_stat,l_out_text);

Line 362: FND_MSG_PUB.Count_And_Get

358: IF FND_API.To_Boolean(p_commit) THEN
359: COMMIT WORK;
360: END IF;
361: -- Standard callto get message count and if count is 1, get message info.
362: FND_MSG_PUB.Count_And_Get
363: ( p_count => x_msg_count,
364: p_data => x_msg_data
365: );
366: EXCEPTION

Line 370: FND_MSG_PUB.Count_And_Get

366: EXCEPTION
367: WHEN FND_API.G_EXC_ERROR THEN
368: ROLLBACK TO Get_SuggResponse_PUB;
369: x_return_status := FND_API.G_RET_STS_ERROR ;
370: FND_MSG_PUB.Count_And_Get
371: ( p_count => x_msg_count,
372: p_data => x_msg_data
373: );
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 377: FND_MSG_PUB.Count_And_Get

373: );
374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
375: ROLLBACK TO Get_SuggResponse_PUB;
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
377: FND_MSG_PUB.Count_And_Get
378: ( p_count => x_msg_count,
379: p_data => x_msg_data
380: );
381: WHEN OTHERS THEN

Line 384: IF FND_MSG_PUB.Check_Msg_Level

380: );
381: WHEN OTHERS THEN
382: ROLLBACK TO Get_SuggResponse_PUB;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: IF FND_MSG_PUB.Check_Msg_Level
385: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: FND_MSG_PUB.Add_Exc_Msg
388: ( G_PKG_NAME ,

Line 385: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

381: WHEN OTHERS THEN
382: ROLLBACK TO Get_SuggResponse_PUB;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: IF FND_MSG_PUB.Check_Msg_Level
385: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: FND_MSG_PUB.Add_Exc_Msg
388: ( G_PKG_NAME ,
389: l_api_name

Line 387: FND_MSG_PUB.Add_Exc_Msg

383: x_return_status := FND_API.G_RET_STS_ERROR;
384: IF FND_MSG_PUB.Check_Msg_Level
385: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
386: THEN
387: FND_MSG_PUB.Add_Exc_Msg
388: ( G_PKG_NAME ,
389: l_api_name
390: );
391: END IF;

Line 392: FND_MSG_PUB.Count_And_Get

388: ( G_PKG_NAME ,
389: l_api_name
390: );
391: END IF;
392: FND_MSG_PUB.Count_And_Get
393: ( p_count => x_msg_count ,
394: p_data => x_msg_data
395: );
396:

Line 453: FND_MSG_PUB.initialize;

449: END IF;
450: -- Initialize message list if p_init_msg_list is set to TRUE.
451: IF FND_API.to_Boolean( p_init_msg_list )
452: THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455: -- Initialize API return status to SUCCESS
456: x_return_status := FND_API.G_RET_STS_SUCCESS;
457: select count(*) into l_doc_count

Line 519: FND_MSG_PUB.Count_And_Get

515: IF FND_API.To_Boolean(p_commit) THEN
516: COMMIT WORK;
517: END IF;
518: -- Standard callto get message count and if count is 1, get message info.
519: FND_MSG_PUB.Count_And_Get
520: ( p_count => x_msg_count,
521: p_data => x_msg_data
522: );
523: EXCEPTION

Line 527: FND_MSG_PUB.Count_And_Get

523: EXCEPTION
524: WHEN FND_API.G_EXC_ERROR THEN
525: ROLLBACK TO Get_SuggResponse_PUB;
526: x_return_status := FND_API.G_RET_STS_ERROR ;
527: FND_MSG_PUB.Count_And_Get
528: ( p_count => x_msg_count,
529: p_data => x_msg_data
530: );
531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 534: FND_MSG_PUB.Count_And_Get

530: );
531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
532: ROLLBACK TO Get_SuggResponse_PUB;
533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
534: FND_MSG_PUB.Count_And_Get
535: ( p_count => x_msg_count,
536: p_data => x_msg_data
537: );
538: WHEN OTHERS THEN

Line 541: IF FND_MSG_PUB.Check_Msg_Level

537: );
538: WHEN OTHERS THEN
539: ROLLBACK TO Get_SuggResponse_PUB;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: IF FND_MSG_PUB.Check_Msg_Level
542: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
543: THEN
544: FND_MSG_PUB.Add_Exc_Msg
545: ( G_PKG_NAME ,

Line 542: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

538: WHEN OTHERS THEN
539: ROLLBACK TO Get_SuggResponse_PUB;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: IF FND_MSG_PUB.Check_Msg_Level
542: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
543: THEN
544: FND_MSG_PUB.Add_Exc_Msg
545: ( G_PKG_NAME ,
546: l_api_name

Line 544: FND_MSG_PUB.Add_Exc_Msg

540: x_return_status := FND_API.G_RET_STS_ERROR;
541: IF FND_MSG_PUB.Check_Msg_Level
542: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
543: THEN
544: FND_MSG_PUB.Add_Exc_Msg
545: ( G_PKG_NAME ,
546: l_api_name
547: );
548: END IF;

Line 549: FND_MSG_PUB.Count_And_Get

545: ( G_PKG_NAME ,
546: l_api_name
547: );
548: END IF;
549: FND_MSG_PUB.Count_And_Get
550: ( p_count => x_msg_count ,
551: p_data => x_msg_data
552: );
553:

Line 599: FND_MSG_PUB.initialize;

595: END IF;
596: -- Initialize message list if p_init_msg_list is set to TRUE.
597: IF FND_API.to_Boolean( p_init_msg_list )
598: THEN
599: FND_MSG_PUB.initialize;
600: END IF;
601: -- Initialize API return status to SUCCESS
602: x_return_status := FND_API.G_RET_STS_SUCCESS;
603: for c_kb_rec in kb_results_csr

Line 619: FND_MSG_PUB.Count_And_Get

615: IF FND_API.To_Boolean(p_commit) THEN
616: COMMIT WORK;
617: END IF;
618: -- Standard callto get message count and if count is 1, get message info.
619: FND_MSG_PUB.Count_And_Get
620: ( p_count => x_msg_count,
621: p_data => x_msg_data
622: );
623: EXCEPTION

Line 627: FND_MSG_PUB.Count_And_Get

623: EXCEPTION
624: WHEN FND_API.G_EXC_ERROR THEN
625: ROLLBACK TO Get_SuggResponse_PUB;
626: x_return_status := FND_API.G_RET_STS_ERROR ;
627: FND_MSG_PUB.Count_And_Get
628: ( p_count => x_msg_count,
629: p_data => x_msg_data
630: );
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 634: FND_MSG_PUB.Count_And_Get

630: );
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: ROLLBACK TO Get_SuggResponse_PUB;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
634: FND_MSG_PUB.Count_And_Get
635: ( p_count => x_msg_count,
636: p_data => x_msg_data
637: );
638: WHEN OTHERS THEN

Line 641: IF FND_MSG_PUB.Check_Msg_Level

637: );
638: WHEN OTHERS THEN
639: ROLLBACK TO Get_SuggResponse_PUB;
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: IF FND_MSG_PUB.Check_Msg_Level
642: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
643: THEN
644: FND_MSG_PUB.Add_Exc_Msg
645: ( G_PKG_NAME ,

Line 642: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

638: WHEN OTHERS THEN
639: ROLLBACK TO Get_SuggResponse_PUB;
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: IF FND_MSG_PUB.Check_Msg_Level
642: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
643: THEN
644: FND_MSG_PUB.Add_Exc_Msg
645: ( G_PKG_NAME ,
646: l_api_name

Line 644: FND_MSG_PUB.Add_Exc_Msg

640: x_return_status := FND_API.G_RET_STS_ERROR;
641: IF FND_MSG_PUB.Check_Msg_Level
642: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
643: THEN
644: FND_MSG_PUB.Add_Exc_Msg
645: ( G_PKG_NAME ,
646: l_api_name
647: );
648: END IF;

Line 649: FND_MSG_PUB.Count_And_Get

645: ( G_PKG_NAME ,
646: l_api_name
647: );
648: END IF;
649: FND_MSG_PUB.Count_And_Get
650: ( p_count => x_msg_count ,
651: p_data => x_msg_data
652: );
653: