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

Line 37: FND_MSG_PUB.initialize;

33: raise FND_API.G_EXC_UNEXPECTED_ERROR;
34: end if;
35:
36: if FND_API.to_Boolean(p_init_msg_list) then
37: FND_MSG_PUB.initialize;
38: end if;
39: -- -- -- -- begin build_text_query -- -- -- -- --
40: x_qry_string := CS_KNOWLEDGE_PVT.Build_Simple_Text_Query(
41: p_qry_string => l_qry_string,

Line 48: FND_MSG_PUB.Count_And_Get(

44: EXCEPTION
45: WHEN FND_API.G_EXC_ERROR THEN
46: ROLLBACK TO Const_Text_Qry_PUB;
47: x_return_status := FND_API.G_RET_STS_ERROR ;
48: FND_MSG_PUB.Count_And_Get(
49: p_count => x_msg_count,
50: p_data => x_msg_data );
51: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
52: ROLLBACK TO Const_Text_Qry_PUB;

Line 54: FND_MSG_PUB.Count_And_Get(

50: p_data => x_msg_data );
51: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
52: ROLLBACK TO Const_Text_Qry_PUB;
53: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
54: FND_MSG_PUB.Count_And_Get(
55: p_count => x_msg_count,
56: p_data => x_msg_data);
57: WHEN OTHERS THEN
58: ROLLBACK TO Const_Text_Qry_PUB;

Line 60: IF FND_MSG_PUB.Check_Msg_Level

56: p_data => x_msg_data);
57: WHEN OTHERS THEN
58: ROLLBACK TO Const_Text_Qry_PUB;
59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
60: IF FND_MSG_PUB.Check_Msg_Level
61: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
62: FND_MSG_PUB.Add_Exc_Msg(
63: G_PKG_NAME,
64: l_api_name);

Line 61: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

57: WHEN OTHERS THEN
58: ROLLBACK TO Const_Text_Qry_PUB;
59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
60: IF FND_MSG_PUB.Check_Msg_Level
61: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
62: FND_MSG_PUB.Add_Exc_Msg(
63: G_PKG_NAME,
64: l_api_name);
65: END IF;

Line 62: FND_MSG_PUB.Add_Exc_Msg(

58: ROLLBACK TO Const_Text_Qry_PUB;
59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
60: IF FND_MSG_PUB.Check_Msg_Level
61: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
62: FND_MSG_PUB.Add_Exc_Msg(
63: G_PKG_NAME,
64: l_api_name);
65: END IF;
66: FND_MSG_PUB.Count_And_Get(

Line 66: FND_MSG_PUB.Count_And_Get(

62: FND_MSG_PUB.Add_Exc_Msg(
63: G_PKG_NAME,
64: l_api_name);
65: END IF;
66: FND_MSG_PUB.Count_And_Get(
67: p_count => x_msg_count,
68: p_data => x_msg_data);
69: end Construct_Text_Query;
70:

Line 98: FND_MSG_PUB.initialize;

94: raise FND_API.G_EXC_UNEXPECTED_ERROR;
95: end if;
96:
97: if FND_API.to_Boolean(p_init_msg_list) then
98: FND_MSG_PUB.initialize;
99: end if;
100: -- -- -- -- begin delete set_link -- -- -- -- --
101: x_return_status := FND_API.G_RET_STS_SUCCESS;
102:

Line 107: FND_MSG_PUB.Count_And_Get(

103: l_ret := CS_KB_SET_LINKS_PKG.Delete_Set_Link_W_Obj_Code(
104: p_set_id, p_object_code, p_other_id);
105: -- -- -- -- end delete set_link -- -- --
106:
107: FND_MSG_PUB.Count_And_Get(
108: p_count => x_msg_count,
109: p_data => x_msg_data );
110:
111: IF FND_API.To_Boolean( p_commit ) THEN

Line 120: FND_MSG_PUB.Count_And_Get(

116: EXCEPTION
117: WHEN FND_API.G_EXC_ERROR THEN
118: ROLLBACK TO Del_Set_Link_PUB;
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: FND_MSG_PUB.Count_And_Get(
121: p_count => x_msg_count,
122: p_data => x_msg_data );
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: ROLLBACK TO Del_Set_Link_PUB;

Line 126: FND_MSG_PUB.Count_And_Get(

122: p_data => x_msg_data );
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: ROLLBACK TO Del_Set_Link_PUB;
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
126: FND_MSG_PUB.Count_And_Get(
127: p_count => x_msg_count,
128: p_data => x_msg_data);
129: WHEN OTHERS THEN
130: ROLLBACK TO Del_Set_Link_PUB;

Line 132: IF FND_MSG_PUB.Check_Msg_Level

128: p_data => x_msg_data);
129: WHEN OTHERS THEN
130: ROLLBACK TO Del_Set_Link_PUB;
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132: IF FND_MSG_PUB.Check_Msg_Level
133: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
134: FND_MSG_PUB.Add_Exc_Msg(
135: G_PKG_NAME,
136: l_api_name);

Line 133: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

129: WHEN OTHERS THEN
130: ROLLBACK TO Del_Set_Link_PUB;
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132: IF FND_MSG_PUB.Check_Msg_Level
133: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
134: FND_MSG_PUB.Add_Exc_Msg(
135: G_PKG_NAME,
136: l_api_name);
137: END IF;

Line 134: FND_MSG_PUB.Add_Exc_Msg(

130: ROLLBACK TO Del_Set_Link_PUB;
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132: IF FND_MSG_PUB.Check_Msg_Level
133: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
134: FND_MSG_PUB.Add_Exc_Msg(
135: G_PKG_NAME,
136: l_api_name);
137: END IF;
138: FND_MSG_PUB.Count_And_Get(

Line 138: FND_MSG_PUB.Count_And_Get(

134: FND_MSG_PUB.Add_Exc_Msg(
135: G_PKG_NAME,
136: l_api_name);
137: END IF;
138: FND_MSG_PUB.Count_And_Get(
139: p_count => x_msg_count,
140: p_data => x_msg_data);
141: end Delete_Set_Link;
142:

Line 170: FND_MSG_PUB.initialize;

166: raise FND_API.G_EXC_UNEXPECTED_ERROR;
167: end if;
168:
169: if FND_API.to_Boolean(p_init_msg_list) then
170: FND_MSG_PUB.initialize;
171: end if;
172:
173: -- -- -- -- begin delete Element_link -- -- -- -- --
174: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 181: FND_MSG_PUB.Count_And_Get(

177: p_element_id, p_object_code, p_other_id);
178:
179: -- -- -- -- end delete Element_link -- -- --
180: -- Standard call to get message count. if count=1, get message info.
181: FND_MSG_PUB.Count_And_Get(
182: p_count => x_msg_count,
183: p_data => x_msg_data );
184:
185: IF FND_API.To_Boolean( p_commit ) THEN

Line 193: FND_MSG_PUB.Count_And_Get(

189: EXCEPTION
190: WHEN FND_API.G_EXC_ERROR THEN
191: ROLLBACK TO Del_Element_Link_PUB;
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: FND_MSG_PUB.Count_And_Get(
194: p_count => x_msg_count,
195: p_data => x_msg_data );
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197: ROLLBACK TO Del_Element_Link_PUB;

Line 199: FND_MSG_PUB.Count_And_Get(

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

Line 205: IF FND_MSG_PUB.Check_Msg_Level

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

Line 206: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 207: FND_MSG_PUB.Add_Exc_Msg(

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

Line 211: FND_MSG_PUB.Count_And_Get(

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

Line 267: FND_MSG_PUB.Count_And_Get(

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

Line 273: FND_MSG_PUB.Count_And_Get(

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

Line 279: IF FND_MSG_PUB.Check_Msg_Level

275: p_data => x_msg_data);
276: WHEN OTHERS THEN
277: ROLLBACK TO Create_Set_And_Elements_PUB;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
279: IF FND_MSG_PUB.Check_Msg_Level
280: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
281: FND_MSG_PUB.Add_Exc_Msg(
282: G_PKG_NAME,
283: l_api_name);

Line 280: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

276: WHEN OTHERS THEN
277: ROLLBACK TO Create_Set_And_Elements_PUB;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
279: IF FND_MSG_PUB.Check_Msg_Level
280: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
281: FND_MSG_PUB.Add_Exc_Msg(
282: G_PKG_NAME,
283: l_api_name);
284: END IF;

Line 281: FND_MSG_PUB.Add_Exc_Msg(

277: ROLLBACK TO Create_Set_And_Elements_PUB;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
279: IF FND_MSG_PUB.Check_Msg_Level
280: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
281: FND_MSG_PUB.Add_Exc_Msg(
282: G_PKG_NAME,
283: l_api_name);
284: END IF;
285: FND_MSG_PUB.Count_And_Get(

Line 285: FND_MSG_PUB.Count_And_Get(

281: FND_MSG_PUB.Add_Exc_Msg(
282: G_PKG_NAME,
283: l_api_name);
284: END IF;
285: FND_MSG_PUB.Count_And_Get(
286: p_count => x_msg_count,
287: p_data => x_msg_data);
288: end Create_Set_And_Elements;
289:

Line 337: FND_MSG_PUB.Count_And_Get(

333: EXCEPTION
334: WHEN FND_API.G_EXC_ERROR THEN
335: ROLLBACK TO Create_Set_And_Elements_PUB;
336: x_return_status := FND_API.G_RET_STS_ERROR ;
337: FND_MSG_PUB.Count_And_Get(
338: p_count => x_msg_count,
339: p_data => x_msg_data );
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: ROLLBACK TO Create_Set_And_Elements_PUB;

Line 343: FND_MSG_PUB.Count_And_Get(

339: p_data => x_msg_data );
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: ROLLBACK TO Create_Set_And_Elements_PUB;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
343: FND_MSG_PUB.Count_And_Get(
344: p_count => x_msg_count,
345: p_data => x_msg_data);
346: WHEN OTHERS THEN
347: ROLLBACK TO Create_Set_And_Elements_PUB;

Line 349: IF FND_MSG_PUB.Check_Msg_Level

345: p_data => x_msg_data);
346: WHEN OTHERS THEN
347: ROLLBACK TO Create_Set_And_Elements_PUB;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: IF FND_MSG_PUB.Check_Msg_Level
350: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
351: FND_MSG_PUB.Add_Exc_Msg(
352: G_PKG_NAME,
353: l_api_name);

Line 350: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

346: WHEN OTHERS THEN
347: ROLLBACK TO Create_Set_And_Elements_PUB;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: IF FND_MSG_PUB.Check_Msg_Level
350: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
351: FND_MSG_PUB.Add_Exc_Msg(
352: G_PKG_NAME,
353: l_api_name);
354: END IF;

Line 351: FND_MSG_PUB.Add_Exc_Msg(

347: ROLLBACK TO Create_Set_And_Elements_PUB;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
349: IF FND_MSG_PUB.Check_Msg_Level
350: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
351: FND_MSG_PUB.Add_Exc_Msg(
352: G_PKG_NAME,
353: l_api_name);
354: END IF;
355: FND_MSG_PUB.Count_And_Get(

Line 355: FND_MSG_PUB.Count_And_Get(

351: FND_MSG_PUB.Add_Exc_Msg(
352: G_PKG_NAME,
353: l_api_name);
354: END IF;
355: FND_MSG_PUB.Count_And_Get(
356: p_count => x_msg_count,
357: p_data => x_msg_data);
358:
359: end Create_Set_And_Elements;

Line 412: FND_MSG_PUB.Count_And_Get(

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

Line 418: FND_MSG_PUB.Count_And_Get(

414: p_data => x_msg_data );
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO Create_Set_PUB;
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: WHEN OTHERS THEN
422: ROLLBACK TO Create_Set_PUB;

Line 424: IF FND_MSG_PUB.Check_Msg_Level

420: p_data => x_msg_data);
421: WHEN OTHERS THEN
422: ROLLBACK TO Create_Set_PUB;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
424: IF FND_MSG_PUB.Check_Msg_Level
425: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
426: FND_MSG_PUB.Add_Exc_Msg(
427: G_PKG_NAME,
428: l_api_name);

Line 425: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 426: FND_MSG_PUB.Add_Exc_Msg(

422: ROLLBACK TO Create_Set_PUB;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
424: IF FND_MSG_PUB.Check_Msg_Level
425: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
426: FND_MSG_PUB.Add_Exc_Msg(
427: G_PKG_NAME,
428: l_api_name);
429: END IF;
430: FND_MSG_PUB.Count_And_Get(

Line 430: FND_MSG_PUB.Count_And_Get(

426: FND_MSG_PUB.Add_Exc_Msg(
427: G_PKG_NAME,
428: l_api_name);
429: END IF;
430: FND_MSG_PUB.Count_And_Get(
431: p_count => x_msg_count,
432: p_data => x_msg_data);
433:
434: end Create_Set;

Line 482: FND_MSG_PUB.Count_And_Get(

478: EXCEPTION
479: WHEN FND_API.G_EXC_ERROR THEN
480: ROLLBACK TO Create_Element_PUB;
481: x_return_status := FND_API.G_RET_STS_ERROR ;
482: FND_MSG_PUB.Count_And_Get(
483: p_count => x_msg_count,
484: p_data => x_msg_data );
485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
486: ROLLBACK TO Create_Element_PUB;

Line 488: FND_MSG_PUB.Count_And_Get(

484: p_data => x_msg_data );
485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
486: ROLLBACK TO Create_Element_PUB;
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
488: FND_MSG_PUB.Count_And_Get(
489: p_count => x_msg_count,
490: p_data => x_msg_data);
491: WHEN OTHERS THEN
492: ROLLBACK TO Create_Element_PUB;

Line 494: IF FND_MSG_PUB.Check_Msg_Level

490: p_data => x_msg_data);
491: WHEN OTHERS THEN
492: ROLLBACK TO Create_Element_PUB;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
494: IF FND_MSG_PUB.Check_Msg_Level
495: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
496: FND_MSG_PUB.Add_Exc_Msg(
497: G_PKG_NAME,
498: l_api_name);

Line 495: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

491: WHEN OTHERS THEN
492: ROLLBACK TO Create_Element_PUB;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
494: IF FND_MSG_PUB.Check_Msg_Level
495: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
496: FND_MSG_PUB.Add_Exc_Msg(
497: G_PKG_NAME,
498: l_api_name);
499: END IF;

Line 496: FND_MSG_PUB.Add_Exc_Msg(

492: ROLLBACK TO Create_Element_PUB;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
494: IF FND_MSG_PUB.Check_Msg_Level
495: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
496: FND_MSG_PUB.Add_Exc_Msg(
497: G_PKG_NAME,
498: l_api_name);
499: END IF;
500: FND_MSG_PUB.Count_And_Get(

Line 500: FND_MSG_PUB.Count_And_Get(

496: FND_MSG_PUB.Add_Exc_Msg(
497: G_PKG_NAME,
498: l_api_name);
499: END IF;
500: FND_MSG_PUB.Count_And_Get(
501: p_count => x_msg_count,
502: p_data => x_msg_data);
503: end Create_Element;
504:

Line 561: FND_MSG_PUB.Count_And_Get(

557: EXCEPTION
558: WHEN FND_API.G_EXC_ERROR THEN
559: ROLLBACK TO Find_Sets_Matching_PUB;
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: FND_MSG_PUB.Count_And_Get(
562: p_count => x_msg_count,
563: p_data => x_msg_data );
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: ROLLBACK TO Find_Sets_Matching_PUB;

Line 567: FND_MSG_PUB.Count_And_Get(

563: p_data => x_msg_data );
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: ROLLBACK TO Find_Sets_Matching_PUB;
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
567: FND_MSG_PUB.Count_And_Get(
568: p_count => x_msg_count,
569: p_data => x_msg_data);
570: WHEN OTHERS THEN
571: ROLLBACK TO Find_Sets_Matching_PUB;

Line 573: IF FND_MSG_PUB.Check_Msg_Level

569: p_data => x_msg_data);
570: WHEN OTHERS THEN
571: ROLLBACK TO Find_Sets_Matching_PUB;
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
573: IF FND_MSG_PUB.Check_Msg_Level
574: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
575: FND_MSG_PUB.Add_Exc_Msg(
576: G_PKG_NAME,
577: l_api_name);

Line 574: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

570: WHEN OTHERS THEN
571: ROLLBACK TO Find_Sets_Matching_PUB;
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
573: IF FND_MSG_PUB.Check_Msg_Level
574: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
575: FND_MSG_PUB.Add_Exc_Msg(
576: G_PKG_NAME,
577: l_api_name);
578: END IF;

Line 575: FND_MSG_PUB.Add_Exc_Msg(

571: ROLLBACK TO Find_Sets_Matching_PUB;
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
573: IF FND_MSG_PUB.Check_Msg_Level
574: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
575: FND_MSG_PUB.Add_Exc_Msg(
576: G_PKG_NAME,
577: l_api_name);
578: END IF;
579: FND_MSG_PUB.Count_And_Get(

Line 579: FND_MSG_PUB.Count_And_Get(

575: FND_MSG_PUB.Add_Exc_Msg(
576: G_PKG_NAME,
577: l_api_name);
578: END IF;
579: FND_MSG_PUB.Count_And_Get(
580: p_count => x_msg_count,
581: p_data => x_msg_data);
582: end Find_Sets_Matching;
583:

Line 613: FND_MSG_PUB.initialize;

609: raise FND_API.G_EXC_UNEXPECTED_ERROR;
610: end if;
611:
612: if FND_API.to_Boolean(p_init_msg_list) then
613: FND_MSG_PUB.initialize;
614: end if;
615:
616: x_return_status := FND_API.G_RET_STS_SUCCESS;
617:

Line 655: FND_MSG_PUB.Count_And_Get(

651: COMMIT WORK;
652: END IF;
653:
654: -- Standard call to get message count. if count=1, get message info.
655: FND_MSG_PUB.Count_And_Get(
656: p_count => x_msg_count,
657: p_data => x_msg_data );
658:
659: EXCEPTION

Line 663: FND_MSG_PUB.Count_And_Get(

659: EXCEPTION
660: WHEN FND_API.G_EXC_ERROR THEN
661: ROLLBACK TO Create_Element_Link_Grp;
662: x_return_status := FND_API.G_RET_STS_ERROR ;
663: FND_MSG_PUB.Count_And_Get(
664: p_count => x_msg_count,
665: p_data => x_msg_data );
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: ROLLBACK TO Create_Element_Link_Grp;

Line 669: FND_MSG_PUB.Count_And_Get(

665: p_data => x_msg_data );
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: ROLLBACK TO Create_Element_Link_Grp;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
669: FND_MSG_PUB.Count_And_Get(
670: p_count => x_msg_count,
671: p_data => x_msg_data);
672: WHEN OTHERS THEN
673: ROLLBACK TO Create_Element_Link_Grp;

Line 675: IF FND_MSG_PUB.Check_Msg_Level

671: p_data => x_msg_data);
672: WHEN OTHERS THEN
673: ROLLBACK TO Create_Element_Link_Grp;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
675: IF FND_MSG_PUB.Check_Msg_Level
676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
677: FND_MSG_PUB.Add_Exc_Msg(
678: G_PKG_NAME,
679: l_api_name);

Line 676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

672: WHEN OTHERS THEN
673: ROLLBACK TO Create_Element_Link_Grp;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
675: IF FND_MSG_PUB.Check_Msg_Level
676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
677: FND_MSG_PUB.Add_Exc_Msg(
678: G_PKG_NAME,
679: l_api_name);
680: END IF;

Line 677: FND_MSG_PUB.Add_Exc_Msg(

673: ROLLBACK TO Create_Element_Link_Grp;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
675: IF FND_MSG_PUB.Check_Msg_Level
676: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
677: FND_MSG_PUB.Add_Exc_Msg(
678: G_PKG_NAME,
679: l_api_name);
680: END IF;
681: FND_MSG_PUB.Count_And_Get(

Line 681: FND_MSG_PUB.Count_And_Get(

677: FND_MSG_PUB.Add_Exc_Msg(
678: G_PKG_NAME,
679: l_api_name);
680: END IF;
681: FND_MSG_PUB.Count_And_Get(
682: p_count => x_msg_count,
683: p_data => x_msg_data);
684: end Create_Element_Link;
685:

Line 720: FND_MSG_PUB.initialize;

716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718:
719: IF FND_API.to_Boolean(p_init_msg_list) THEN
720: FND_MSG_PUB.initialize;
721: END IF;
722:
723: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
724:

Line 767: FND_MSG_PUB.Count_And_Get(

763: ROLLBACK TO Create_Set_Link_Grp;
764:
765: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;
766:
767: FND_MSG_PUB.Count_And_Get(
768: p_encoded => FND_API.G_FALSE,
769: p_count => x_msg_count,
770: p_data => x_msg_data );
771:

Line 778: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

774: ROLLBACK TO Create_Set_Link_Grp;
775:
776: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
777:
778: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
779: p_count => X_MSG_COUNT,
780: p_data => X_MSG_DATA);
781: WHEN OTHERS THEN
782:

Line 787: IF FND_MSG_PUB.Check_Msg_Level

783: ROLLBACK TO Create_Set_Link_Grp;
784:
785: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
786:
787: IF FND_MSG_PUB.Check_Msg_Level
788: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
789: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
790: END IF;
791:

Line 788: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

784:
785: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
786:
787: IF FND_MSG_PUB.Check_Msg_Level
788: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
789: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
790: END IF;
791:
792: FND_MSG_PUB.Count_And_Get(

Line 789: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);

785: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
786:
787: IF FND_MSG_PUB.Check_Msg_Level
788: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
789: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
790: END IF;
791:
792: FND_MSG_PUB.Count_And_Get(
793: p_encoded => FND_API.G_FALSE ,

Line 792: FND_MSG_PUB.Count_And_Get(

788: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
789: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
790: END IF;
791:
792: FND_MSG_PUB.Count_And_Get(
793: p_encoded => FND_API.G_FALSE ,
794: p_count => x_msg_count,
795: p_data => x_msg_data);
796:

Line 827: FND_MSG_PUB.initialize;

823: raise FND_API.G_EXC_UNEXPECTED_ERROR;
824: end if;
825:
826: if FND_API.to_Boolean(p_init_msg_list) then
827: FND_MSG_PUB.initialize;
828: end if;
829:
830: x_return_status := FND_API.G_RET_STS_SUCCESS;
831:

Line 868: FND_MSG_PUB.Count_And_Get(

864: COMMIT WORK;
865: END IF;
866:
867: -- Standard call to get message count. if count=1, get message info.
868: FND_MSG_PUB.Count_And_Get(
869: p_count => x_msg_count,
870: p_data => x_msg_data );
871:
872: EXCEPTION

Line 876: FND_MSG_PUB.Count_And_Get(

872: EXCEPTION
873: WHEN FND_API.G_EXC_ERROR THEN
874: ROLLBACK TO Update_Set_Link_Grp;
875: x_return_status := FND_API.G_RET_STS_ERROR ;
876: FND_MSG_PUB.Count_And_Get(
877: p_count => x_msg_count,
878: p_data => x_msg_data );
879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
880: ROLLBACK TO Update_Set_Link_Grp;

Line 882: FND_MSG_PUB.Count_And_Get(

878: p_data => x_msg_data );
879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
880: ROLLBACK TO Update_Set_Link_Grp;
881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
882: FND_MSG_PUB.Count_And_Get(
883: p_count => x_msg_count,
884: p_data => x_msg_data);
885: WHEN OTHERS THEN
886: ROLLBACK TO Update_Set_Link_Grp;

Line 888: IF FND_MSG_PUB.Check_Msg_Level

884: p_data => x_msg_data);
885: WHEN OTHERS THEN
886: ROLLBACK TO Update_Set_Link_Grp;
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
888: IF FND_MSG_PUB.Check_Msg_Level
889: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
890: FND_MSG_PUB.Add_Exc_Msg(
891: G_PKG_NAME,
892: l_api_name);

Line 889: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

885: WHEN OTHERS THEN
886: ROLLBACK TO Update_Set_Link_Grp;
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
888: IF FND_MSG_PUB.Check_Msg_Level
889: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
890: FND_MSG_PUB.Add_Exc_Msg(
891: G_PKG_NAME,
892: l_api_name);
893: END IF;

Line 890: FND_MSG_PUB.Add_Exc_Msg(

886: ROLLBACK TO Update_Set_Link_Grp;
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
888: IF FND_MSG_PUB.Check_Msg_Level
889: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
890: FND_MSG_PUB.Add_Exc_Msg(
891: G_PKG_NAME,
892: l_api_name);
893: END IF;
894: FND_MSG_PUB.Count_And_Get(

Line 894: FND_MSG_PUB.Count_And_Get(

890: FND_MSG_PUB.Add_Exc_Msg(
891: G_PKG_NAME,
892: l_api_name);
893: END IF;
894: FND_MSG_PUB.Count_And_Get(
895: p_count => x_msg_count,
896: p_data => x_msg_data);
897: end Update_Set_Link;
898:

Line 1028: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

1024:
1025: -- x_result_array := cs_kb_result_varray_type();
1026:
1027: if( p_search_string = FND_API.G_MISS_CHAR ) then
1028: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1029: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1030: fnd_msg_pub.Add;
1031: end if;
1032: raise FND_API.G_EXC_ERROR;

Line 1030: fnd_msg_pub.Add;

1026:
1027: if( p_search_string = FND_API.G_MISS_CHAR ) then
1028: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1029: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1030: fnd_msg_pub.Add;
1031: end if;
1032: raise FND_API.G_EXC_ERROR;
1033: end if;
1034:

Line 1368: FND_MSG_PUB.initialize;

1364: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1365: end if;
1366:
1367: if FND_API.to_Boolean(p_init_msg_list) then
1368: FND_MSG_PUB.initialize;
1369: end if;
1370:
1371: x_return_status := FND_API.G_RET_STS_SUCCESS;
1372: -- -- -- -- begin my code -- -- -- -- --

Line 1390: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

1386: x_total_row_cnt_tbl :=cs_kb_number_tbl_type();
1387:
1388:
1389: if(p_repository_tbl is null) then
1390: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1391: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1392: fnd_msg_pub.Add;
1393: end if;
1394: raise FND_API.G_EXC_ERROR;

Line 1392: fnd_msg_pub.Add;

1388:
1389: if(p_repository_tbl is null) then
1390: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1391: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1392: fnd_msg_pub.Add;
1393: end if;
1394: raise FND_API.G_EXC_ERROR;
1395: end if;
1396:

Line 1519: FND_MSG_PUB.Count_And_Get(

1515:
1516: -- -- -- -- end of code -- -- -- --
1517:
1518: -- Standard call to get message count. if count=1, get message info.
1519: FND_MSG_PUB.Count_And_Get(
1520: p_count => x_msg_count,
1521: p_data => x_msg_data );
1522:
1523: EXCEPTION

Line 1527: FND_MSG_PUB.Count_And_Get(

1523: EXCEPTION
1524: WHEN FND_API.G_EXC_ERROR THEN
1525: ROLLBACK TO Specific_Search_GRP;
1526: x_return_status := FND_API.G_RET_STS_ERROR ;
1527: FND_MSG_PUB.Count_And_Get(
1528: p_count => x_msg_count,
1529: p_data => x_msg_data );
1530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1531: ROLLBACK TO Specific_Search_GRP;

Line 1533: FND_MSG_PUB.Count_And_Get(

1529: p_data => x_msg_data );
1530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1531: ROLLBACK TO Specific_Search_GRP;
1532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1533: FND_MSG_PUB.Count_And_Get(
1534: p_count => x_msg_count,
1535: p_data => x_msg_data);
1536:
1537: WHEN OTHERS THEN

Line 1540: IF FND_MSG_PUB.Check_Msg_Level

1536:
1537: WHEN OTHERS THEN
1538: ROLLBACK TO Specific_Search_GRP;
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1540: IF FND_MSG_PUB.Check_Msg_Level
1541: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1542: FND_MSG_PUB.Add_Exc_Msg(
1543: G_PKG_NAME,
1544: l_api_name);

Line 1541: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1537: WHEN OTHERS THEN
1538: ROLLBACK TO Specific_Search_GRP;
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1540: IF FND_MSG_PUB.Check_Msg_Level
1541: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1542: FND_MSG_PUB.Add_Exc_Msg(
1543: G_PKG_NAME,
1544: l_api_name);
1545: END IF;

Line 1542: FND_MSG_PUB.Add_Exc_Msg(

1538: ROLLBACK TO Specific_Search_GRP;
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1540: IF FND_MSG_PUB.Check_Msg_Level
1541: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1542: FND_MSG_PUB.Add_Exc_Msg(
1543: G_PKG_NAME,
1544: l_api_name);
1545: END IF;
1546: FND_MSG_PUB.Count_And_Get(

Line 1546: FND_MSG_PUB.Count_And_Get(

1542: FND_MSG_PUB.Add_Exc_Msg(
1543: G_PKG_NAME,
1544: l_api_name);
1545: END IF;
1546: FND_MSG_PUB.Count_And_Get(
1547: p_count => x_msg_count,
1548: p_data => x_msg_data);
1549:
1550:

Line 1585: FND_MSG_PUB.initialize;

1581: SAVEPOINT Purge_Knowledge_Links_GRP;
1582: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1583:
1584: IF FND_API.to_Boolean(P_INIT_MSG_LIST) THEN
1585: FND_MSG_PUB.initialize;
1586: END IF;
1587:
1588: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1589: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_KNOWLEDGE_GRP.Purge_Knowledge_Links.Start',

Line 1595: FND_MSG_PUB.ADD;

1591: END IF;
1592:
1593: IF (P_PROCESSING_SET_ID IS NULL OR P_OBJECT_TYPE IS NULL) THEN
1594: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
1595: FND_MSG_PUB.ADD;
1596: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1597: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1598: p_count => X_MSG_COUNT,
1599: p_data => X_MSG_DATA);

Line 1597: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1593: IF (P_PROCESSING_SET_ID IS NULL OR P_OBJECT_TYPE IS NULL) THEN
1594: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
1595: FND_MSG_PUB.ADD;
1596: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1597: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1598: p_count => X_MSG_COUNT,
1599: p_data => X_MSG_DATA);
1600: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1601:

Line 1646: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1642:
1643: END IF;
1644:
1645: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
1646: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1647: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1648: 'Purge_Knowledge_Links');
1649: END IF;
1650: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE ,

Line 1647: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

1643: END IF;
1644:
1645: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
1646: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1647: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1648: 'Purge_Knowledge_Links');
1649: END IF;
1650: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE ,
1651: p_count => x_msg_count,

Line 1650: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE ,

1646: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1647: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1648: 'Purge_Knowledge_Links');
1649: END IF;
1650: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE ,
1651: p_count => x_msg_count,
1652: p_data => x_msg_data);
1653: END Purge_Knowledge_Links;
1654: