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 768: FND_MSG_PUB.Count_And_Get(

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

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

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

Line 788: IF FND_MSG_PUB.Check_Msg_Level

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

Line 789: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

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

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

Line 793: FND_MSG_PUB.Count_And_Get(

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

Line 828: FND_MSG_PUB.initialize;

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

Line 869: FND_MSG_PUB.Count_And_Get(

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

Line 877: FND_MSG_PUB.Count_And_Get(

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

Line 883: FND_MSG_PUB.Count_And_Get(

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

Line 889: IF FND_MSG_PUB.Check_Msg_Level

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

Line 890: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 891: FND_MSG_PUB.Add_Exc_Msg(

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

Line 895: FND_MSG_PUB.Count_And_Get(

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

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

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

Line 1031: fnd_msg_pub.Add;

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

Line 1369: FND_MSG_PUB.initialize;

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

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

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

Line 1393: fnd_msg_pub.Add;

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

Line 1520: FND_MSG_PUB.Count_And_Get(

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

Line 1528: FND_MSG_PUB.Count_And_Get(

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

Line 1534: FND_MSG_PUB.Count_And_Get(

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

Line 1541: IF FND_MSG_PUB.Check_Msg_Level

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

Line 1542: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 1543: FND_MSG_PUB.Add_Exc_Msg(

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

Line 1547: FND_MSG_PUB.Count_And_Get(

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

Line 1586: FND_MSG_PUB.initialize;

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

Line 1596: FND_MSG_PUB.ADD;

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

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

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

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

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

Line 1648: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,

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

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

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