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_API

Line 11: p_init_msg_list in varchar2 := FND_API.G_FALSE,

7: -- PUBLIC
8: --
9: PROCEDURE Construct_Text_Query(
10: p_api_version in number,
11: p_init_msg_list in varchar2 := FND_API.G_FALSE,
12: p_commit in varchar2 := FND_API.G_FALSE,
13: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
14: x_return_status OUT NOCOPY varchar2,
15: x_msg_count OUT NOCOPY number,

Line 12: p_commit in varchar2 := FND_API.G_FALSE,

8: --
9: PROCEDURE Construct_Text_Query(
10: p_api_version in number,
11: p_init_msg_list in varchar2 := FND_API.G_FALSE,
12: p_commit in varchar2 := FND_API.G_FALSE,
13: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
14: x_return_status OUT NOCOPY varchar2,
15: x_msg_count OUT NOCOPY number,
16: x_msg_data OUT NOCOPY varchar2,

Line 13: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

9: PROCEDURE Construct_Text_Query(
10: p_api_version in number,
11: p_init_msg_list in varchar2 := FND_API.G_FALSE,
12: p_commit in varchar2 := FND_API.G_FALSE,
13: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
14: x_return_status OUT NOCOPY varchar2,
15: x_msg_count OUT NOCOPY number,
16: x_msg_data OUT NOCOPY varchar2,
17: p_qry_string in varchar2,

Line 28: if not FND_API.Compatible_API_Call(

24: l_qry_string varchar2(30000) := p_qry_string;
25:
26: begin
27: savepoint Const_Text_Qry_PUB;
28: if not FND_API.Compatible_API_Call(
29: l_api_version,
30: p_api_version,
31: l_api_name,
32: G_PKG_NAME) then

Line 33: raise FND_API.G_EXC_UNEXPECTED_ERROR;

29: l_api_version,
30: p_api_version,
31: l_api_name,
32: G_PKG_NAME) then
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;

Line 36: if FND_API.to_Boolean(p_init_msg_list) then

32: G_PKG_NAME) then
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(

Line 45: WHEN FND_API.G_EXC_ERROR THEN

41: p_qry_string => l_qry_string,
42: p_search_option => p_search_option);
43:
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,

Line 47: x_return_status := FND_API.G_RET_STS_ERROR ;

43:
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

Line 51: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
53: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
54: FND_MSG_PUB.Count_And_Get(
55: p_count => x_msg_count,

Line 53: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
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

Line 59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

55: p_count => x_msg_count,
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,

Line 74: p_init_msg_list in varchar2 := FND_API.G_FALSE,

70:
71:
72: PROCEDURE Delete_Set_Link(
73: p_api_version in number,
74: p_init_msg_list in varchar2 := FND_API.G_FALSE,
75: p_commit in varchar2 := FND_API.G_FALSE,
76: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
77: x_return_status OUT NOCOPY varchar2,
78: x_msg_count OUT NOCOPY number,

Line 75: p_commit in varchar2 := FND_API.G_FALSE,

71:
72: PROCEDURE Delete_Set_Link(
73: p_api_version in number,
74: p_init_msg_list in varchar2 := FND_API.G_FALSE,
75: p_commit in varchar2 := FND_API.G_FALSE,
76: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
77: x_return_status OUT NOCOPY varchar2,
78: x_msg_count OUT NOCOPY number,
79: x_msg_data OUT NOCOPY varchar2,

Line 76: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

72: PROCEDURE Delete_Set_Link(
73: p_api_version in number,
74: p_init_msg_list in varchar2 := FND_API.G_FALSE,
75: p_commit in varchar2 := FND_API.G_FALSE,
76: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
77: x_return_status OUT NOCOPY varchar2,
78: x_msg_count OUT NOCOPY number,
79: x_msg_data OUT NOCOPY varchar2,
80: p_set_id in number,

Line 89: if not FND_API.Compatible_API_Call(

85: l_api_version CONSTANT number := 1.0;
86: l_ret number(5);
87: begin
88: savepoint Del_Set_Link_PUB;
89: if not FND_API.Compatible_API_Call(
90: l_api_version,
91: p_api_version,
92: l_api_name,
93: G_PKG_NAME) then

Line 94: raise FND_API.G_EXC_UNEXPECTED_ERROR;

90: l_api_version,
91: p_api_version,
92: l_api_name,
93: G_PKG_NAME) then
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;

Line 97: if FND_API.to_Boolean(p_init_msg_list) then

93: G_PKG_NAME) then
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;

Line 101: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
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 -- -- --

Line 111: IF FND_API.To_Boolean( p_commit ) THEN

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
112: COMMIT WORK;
113: END IF;
114:
115:

Line 117: WHEN FND_API.G_EXC_ERROR THEN

113: END IF;
114:
115:
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,

Line 119: x_return_status := FND_API.G_RET_STS_ERROR;

115:
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

Line 123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
126: FND_MSG_PUB.Count_And_Get(
127: p_count => x_msg_count,

Line 125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
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

Line 131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

127: p_count => x_msg_count,
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,

Line 145: p_init_msg_list in varchar2 := FND_API.G_FALSE,

141: end Delete_Set_Link;
142:
143: PROCEDURE Delete_Element_Link(
144: p_api_version in number,
145: p_init_msg_list in varchar2 := FND_API.G_FALSE,
146: p_commit in varchar2 := FND_API.G_FALSE,
147: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
148: x_return_status OUT NOCOPY varchar2,
149: x_msg_count OUT NOCOPY number,

Line 146: p_commit in varchar2 := FND_API.G_FALSE,

142:
143: PROCEDURE Delete_Element_Link(
144: p_api_version in number,
145: p_init_msg_list in varchar2 := FND_API.G_FALSE,
146: p_commit in varchar2 := FND_API.G_FALSE,
147: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
148: x_return_status OUT NOCOPY varchar2,
149: x_msg_count OUT NOCOPY number,
150: x_msg_data OUT NOCOPY varchar2,

Line 147: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

143: PROCEDURE Delete_Element_Link(
144: p_api_version in number,
145: p_init_msg_list in varchar2 := FND_API.G_FALSE,
146: p_commit in varchar2 := FND_API.G_FALSE,
147: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
148: x_return_status OUT NOCOPY varchar2,
149: x_msg_count OUT NOCOPY number,
150: x_msg_data OUT NOCOPY varchar2,
151: p_element_id in number,

Line 161: if not FND_API.Compatible_API_Call(

157: l_ret number(5);
158: begin
159: savepoint Del_Element_Link_PUB;
160:
161: if not FND_API.Compatible_API_Call(
162: l_api_version,
163: p_api_version,
164: l_api_name,
165: G_PKG_NAME) then

Line 166: raise FND_API.G_EXC_UNEXPECTED_ERROR;

162: l_api_version,
163: p_api_version,
164: l_api_name,
165: G_PKG_NAME) then
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;

Line 169: if FND_API.to_Boolean(p_init_msg_list) then

165: G_PKG_NAME) then
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 -- -- -- -- --

Line 174: x_return_status := FND_API.G_RET_STS_SUCCESS;

170: FND_MSG_PUB.initialize;
171: end if;
172:
173: -- -- -- -- begin delete Element_link -- -- -- -- --
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175:
176: l_ret := CS_KB_ELEMENT_LINKS_PKG.Delete_Element_Link_W_Obj_Code(
177: p_element_id, p_object_code, p_other_id);
178:

Line 185: IF FND_API.To_Boolean( p_commit ) THEN

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
186: COMMIT WORK;
187: END IF;
188:
189: EXCEPTION

Line 190: WHEN FND_API.G_EXC_ERROR THEN

186: COMMIT WORK;
187: END IF;
188:
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,

Line 192: x_return_status := FND_API.G_RET_STS_ERROR ;

188:
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

Line 196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
199: FND_MSG_PUB.Count_And_Get(
200: p_count => x_msg_count,

Line 198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
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

Line 204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

200: p_count => x_msg_count,
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,

Line 223: p_init_msg_list in varchar2 := FND_API.G_FALSE,

219: --
220:
221: PROCEDURE Create_Set_And_Elements(
222: p_api_version in number,
223: p_init_msg_list in varchar2 := FND_API.G_FALSE,
224: p_commit in varchar2 := FND_API.G_FALSE,
225: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
226: x_return_status OUT NOCOPY varchar2,
227: x_msg_count OUT NOCOPY number,

Line 224: p_commit in varchar2 := FND_API.G_FALSE,

220:
221: PROCEDURE Create_Set_And_Elements(
222: p_api_version in number,
223: p_init_msg_list in varchar2 := FND_API.G_FALSE,
224: p_commit in varchar2 := FND_API.G_FALSE,
225: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
226: x_return_status OUT NOCOPY varchar2,
227: x_msg_count OUT NOCOPY number,
228: x_msg_data OUT NOCOPY varchar2,

Line 225: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

221: PROCEDURE Create_Set_And_Elements(
222: p_api_version in number,
223: p_init_msg_list in varchar2 := FND_API.G_FALSE,
224: p_commit in varchar2 := FND_API.G_FALSE,
225: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
226: x_return_status OUT NOCOPY varchar2,
227: x_msg_count OUT NOCOPY number,
228: x_msg_data OUT NOCOPY varchar2,
229: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

Line 241: if not FND_API.Compatible_API_Call(

237: begin
238:
239: savepoint Create_Set_And_Elements_PUB;
240:
241: if not FND_API.Compatible_API_Call(
242: l_api_version,
243: p_api_version,
244: l_api_name,
245: G_PKG_NAME) then

Line 246: raise FND_API.G_EXC_UNEXPECTED_ERROR;

242: l_api_version,
243: p_api_version,
244: l_api_name,
245: G_PKG_NAME) then
246: raise FND_API.G_EXC_UNEXPECTED_ERROR;
247: end if;
248:
249: -- -- -- -- begin my code -- -- -- -- --
250: CS_Knowledge_PVT.Create_Set_And_Elements(

Line 264: WHEN FND_API.G_EXC_ERROR THEN

260: -- p_attrval_def_tbl => p_attrval_def_tbl,
261: x_set_id => x_set_id);
262:
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,

Line 266: x_return_status := FND_API.G_RET_STS_ERROR ;

262:
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

Line 270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273: FND_MSG_PUB.Count_And_Get(
274: p_count => x_msg_count,

Line 272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
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

Line 278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

274: p_count => x_msg_count,
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,

Line 293: p_init_msg_list in varchar2 := FND_API.G_FALSE,

289:
290:
291: PROCEDURE Create_Set_And_Elements(
292: p_api_version in number,
293: p_init_msg_list in varchar2 := FND_API.G_FALSE,
294: p_commit in varchar2 := FND_API.G_FALSE,
295: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
296: x_return_status OUT NOCOPY varchar2,
297: x_msg_count OUT NOCOPY number,

Line 294: p_commit in varchar2 := FND_API.G_FALSE,

290:
291: PROCEDURE Create_Set_And_Elements(
292: p_api_version in number,
293: p_init_msg_list in varchar2 := FND_API.G_FALSE,
294: p_commit in varchar2 := FND_API.G_FALSE,
295: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
296: x_return_status OUT NOCOPY varchar2,
297: x_msg_count OUT NOCOPY number,
298: x_msg_data OUT NOCOPY varchar2,

Line 295: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

291: PROCEDURE Create_Set_And_Elements(
292: p_api_version in number,
293: p_init_msg_list in varchar2 := FND_API.G_FALSE,
294: p_commit in varchar2 := FND_API.G_FALSE,
295: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
296: x_return_status OUT NOCOPY varchar2,
297: x_msg_count OUT NOCOPY number,
298: x_msg_data OUT NOCOPY varchar2,
299: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

Line 311: if not FND_API.Compatible_API_Call(

307: begin
308:
309: savepoint Create_Set_And_Elements_PUB;
310:
311: if not FND_API.Compatible_API_Call(
312: l_api_version,
313: p_api_version,
314: l_api_name,
315: G_PKG_NAME) then

Line 316: raise FND_API.G_EXC_UNEXPECTED_ERROR;

312: l_api_version,
313: p_api_version,
314: l_api_name,
315: G_PKG_NAME) then
316: raise FND_API.G_EXC_UNEXPECTED_ERROR;
317: end if;
318:
319: -- -- -- -- begin my code -- -- -- -- --
320: CS_Knowledge_PVT.Create_Set_And_Elements(

Line 334: WHEN FND_API.G_EXC_ERROR THEN

330: x_set_id => x_set_id,
331: x_element_id_tbl => x_element_id_tbl);
332:
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,

Line 336: x_return_status := FND_API.G_RET_STS_ERROR ;

332:
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

Line 340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
343: FND_MSG_PUB.Count_And_Get(
344: p_count => x_msg_count,

Line 342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
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

Line 348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

344: p_count => x_msg_count,
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,

Line 367: p_init_msg_list in varchar2 := FND_API.G_FALSE,

363: -- Create a set for the given element_ids.
364: --
365: PROCEDURE Create_Set(
366: p_api_version in number,
367: p_init_msg_list in varchar2 := FND_API.G_FALSE,
368: p_commit in varchar2 := FND_API.G_FALSE,
369: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
370: x_return_status OUT NOCOPY varchar2,
371: x_msg_count OUT NOCOPY number,

Line 368: p_commit in varchar2 := FND_API.G_FALSE,

364: --
365: PROCEDURE Create_Set(
366: p_api_version in number,
367: p_init_msg_list in varchar2 := FND_API.G_FALSE,
368: p_commit in varchar2 := FND_API.G_FALSE,
369: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
370: x_return_status OUT NOCOPY varchar2,
371: x_msg_count OUT NOCOPY number,
372: x_msg_data OUT NOCOPY varchar2,

Line 369: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

365: PROCEDURE Create_Set(
366: p_api_version in number,
367: p_init_msg_list in varchar2 := FND_API.G_FALSE,
368: p_commit in varchar2 := FND_API.G_FALSE,
369: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
370: x_return_status OUT NOCOPY varchar2,
371: x_msg_count OUT NOCOPY number,
372: x_msg_data OUT NOCOPY varchar2,
373: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

Line 385: if not FND_API.Compatible_API_Call(

381: begin
382:
383: savepoint Create_Set_PUB;
384:
385: if not FND_API.Compatible_API_Call(
386: l_api_version,
387: p_api_version,
388: l_api_name,
389: G_PKG_NAME) then

Line 390: raise FND_API.G_EXC_UNEXPECTED_ERROR;

386: l_api_version,
387: p_api_version,
388: l_api_name,
389: G_PKG_NAME) then
390: raise FND_API.G_EXC_UNEXPECTED_ERROR;
391: end if;
392:
393: -- -- -- -- begin my code -- -- -- -- --
394: CS_Knowledge_PVT.Create_Set(

Line 409: WHEN FND_API.G_EXC_ERROR THEN

405: x_set_id => x_set_id);
406:
407:
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,

Line 411: x_return_status := FND_API.G_RET_STS_ERROR ;

407:
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

Line 415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418: FND_MSG_PUB.Count_And_Get(
419: p_count => x_msg_count,

Line 417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
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

Line 423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

419: p_count => x_msg_count,
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,

Line 442: p_init_msg_list in varchar2 := FND_API.G_FALSE,

438: -- Other params are not used for now.
439: --
440: PROCEDURE Create_Element(
441: p_api_version in number,
442: p_init_msg_list in varchar2 := FND_API.G_FALSE,
443: p_commit in varchar2 := FND_API.G_FALSE,
444: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
445: x_return_status OUT NOCOPY varchar2,
446: x_msg_count OUT NOCOPY number,

Line 443: p_commit in varchar2 := FND_API.G_FALSE,

439: --
440: PROCEDURE Create_Element(
441: p_api_version in number,
442: p_init_msg_list in varchar2 := FND_API.G_FALSE,
443: p_commit in varchar2 := FND_API.G_FALSE,
444: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
445: x_return_status OUT NOCOPY varchar2,
446: x_msg_count OUT NOCOPY number,
447: x_msg_data OUT NOCOPY varchar2,

Line 444: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

440: PROCEDURE Create_Element(
441: p_api_version in number,
442: p_init_msg_list in varchar2 := FND_API.G_FALSE,
443: p_commit in varchar2 := FND_API.G_FALSE,
444: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
445: x_return_status OUT NOCOPY varchar2,
446: x_msg_count OUT NOCOPY number,
447: x_msg_data OUT NOCOPY varchar2,
448: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,

Line 458: if not FND_API.Compatible_API_Call(

454: begin
455:
456: savepoint Create_Element_PUB;
457:
458: if not FND_API.Compatible_API_Call(
459: l_api_version,
460: p_api_version,
461: l_api_name,
462: G_PKG_NAME) then

Line 463: raise FND_API.G_EXC_UNEXPECTED_ERROR;

459: l_api_version,
460: p_api_version,
461: l_api_name,
462: G_PKG_NAME) then
463: raise FND_API.G_EXC_UNEXPECTED_ERROR;
464: end if;
465:
466: -- -- -- -- begin my code -- -- -- -- --
467: CS_Knowledge_PVT.Create_Element(

Line 479: WHEN FND_API.G_EXC_ERROR THEN

475: p_ele_def_rec => p_ele_def_rec,
476: x_element_id => x_element_id);
477:
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,

Line 481: x_return_status := FND_API.G_RET_STS_ERROR ;

477:
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

Line 485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
488: FND_MSG_PUB.Count_And_Get(
489: p_count => x_msg_count,

Line 487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
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

Line 493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

489: p_count => x_msg_count,
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,

Line 507: p_init_msg_list in varchar2 := FND_API.G_FALSE,

503: end Create_Element;
504:
505: PROCEDURE Find_Sets_Matching (
506: p_api_version in number,
507: p_init_msg_list in varchar2 := FND_API.G_FALSE,
508: --p_commit in varchar2 := FND_API.G_FALSE,
509: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
510: x_return_status OUT NOCOPY varchar2,
511: x_msg_count OUT NOCOPY number,

Line 508: --p_commit in varchar2 := FND_API.G_FALSE,

504:
505: PROCEDURE Find_Sets_Matching (
506: p_api_version in number,
507: p_init_msg_list in varchar2 := FND_API.G_FALSE,
508: --p_commit in varchar2 := FND_API.G_FALSE,
509: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
510: x_return_status OUT NOCOPY varchar2,
511: x_msg_count OUT NOCOPY number,
512: x_msg_data OUT NOCOPY varchar2,

Line 509: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

505: PROCEDURE Find_Sets_Matching (
506: p_api_version in number,
507: p_init_msg_list in varchar2 := FND_API.G_FALSE,
508: --p_commit in varchar2 := FND_API.G_FALSE,
509: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
510: x_return_status OUT NOCOPY varchar2,
511: x_msg_count OUT NOCOPY number,
512: x_msg_data OUT NOCOPY varchar2,
513: --p_sets_c in OUT NOCOPY general_csr_type,

Line 529: if not FND_API.Compatible_API_Call(

525: l_total_rows number :=0;
526: begin
527: savepoint Find_Sets_Matching_PUB;
528:
529: if not FND_API.Compatible_API_Call(
530: l_api_version,
531: p_api_version,
532: l_api_name,
533: G_PKG_NAME) then

Line 534: raise FND_API.G_EXC_UNEXPECTED_ERROR;

530: l_api_version,
531: p_api_version,
532: l_api_name,
533: G_PKG_NAME) then
534: raise FND_API.G_EXC_UNEXPECTED_ERROR;
535: end if;
536:
537: -- -- -- -- begin my code -- -- -- -- --
538: CS_Knowledge_PVT.Find_Sets_Matching(

Line 553: p_get_total_flag => FND_API.G_FALSE,

549: p_rows => p_rows,
550: p_start_score =>p_start_score,
551: p_start_id => p_start_id,
552: p_start_row => 1,
553: p_get_total_flag => FND_API.G_FALSE,
554: x_set_tbl => x_set_tbl,
555: x_total_rows => l_total_rows);
556:
557: EXCEPTION

Line 558: WHEN FND_API.G_EXC_ERROR THEN

554: x_set_tbl => x_set_tbl,
555: x_total_rows => l_total_rows);
556:
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,

Line 560: x_return_status := FND_API.G_RET_STS_ERROR ;

556:
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

Line 564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
567: FND_MSG_PUB.Count_And_Get(
568: p_count => x_msg_count,

Line 566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
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

Line 572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

568: p_count => x_msg_count,
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,

Line 586: p_init_msg_list in varchar2 := FND_API.G_FALSE,

582: end Find_Sets_Matching;
583:
584: PROCEDURE Create_Element_Link(
585: p_api_version in number,
586: p_init_msg_list in varchar2 := FND_API.G_FALSE,
587: p_commit in varchar2 := FND_API.G_FALSE,
588: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
589: x_return_status OUT NOCOPY varchar2,
590: x_msg_count OUT NOCOPY number,

Line 587: p_commit in varchar2 := FND_API.G_FALSE,

583:
584: PROCEDURE Create_Element_Link(
585: p_api_version in number,
586: p_init_msg_list in varchar2 := FND_API.G_FALSE,
587: p_commit in varchar2 := FND_API.G_FALSE,
588: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
589: x_return_status OUT NOCOPY varchar2,
590: x_msg_count OUT NOCOPY number,
591: x_msg_data OUT NOCOPY varchar2,

Line 588: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

584: PROCEDURE Create_Element_Link(
585: p_api_version in number,
586: p_init_msg_list in varchar2 := FND_API.G_FALSE,
587: p_commit in varchar2 := FND_API.G_FALSE,
588: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
589: x_return_status OUT NOCOPY varchar2,
590: x_msg_count OUT NOCOPY number,
591: x_msg_data OUT NOCOPY varchar2,
592: p_element_link_rec in CS_KB_ELEMENT_LINKS%ROWTYPE,

Line 604: if not FND_API.Compatible_API_Call(

600: l_id number(15);
601: begin
602: savepoint Create_Element_Link_Grp;
603:
604: if not FND_API.Compatible_API_Call(
605: l_api_version,
606: p_api_version,
607: l_api_name,
608: G_PKG_NAME) then

Line 609: raise FND_API.G_EXC_UNEXPECTED_ERROR;

605: l_api_version,
606: p_api_version,
607: l_api_name,
608: G_PKG_NAME) then
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;

Line 612: if FND_API.to_Boolean(p_init_msg_list) then

608: G_PKG_NAME) then
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;

Line 616: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
618: -- -- -- -- begin my code -- -- -- -- --
619:
620: l_id := CS_KB_ELEMENT_LINKS_PKG.Create_Element_Link(

Line 645: raise FND_API.G_EXC_UNEXPECTED_ERROR;

641: );
642: if(l_id>0) then
643: x_element_link_id := l_id;
644: else
645: raise FND_API.G_EXC_UNEXPECTED_ERROR;
646: end if;
647:
648: -- -- -- -- end of code -- -- --
649:

Line 650: IF FND_API.To_Boolean( p_commit ) THEN

646: end if;
647:
648: -- -- -- -- end of code -- -- --
649:
650: IF FND_API.To_Boolean( p_commit ) THEN
651: COMMIT WORK;
652: END IF;
653:
654: -- Standard call to get message count. if count=1, get message info.

Line 660: WHEN FND_API.G_EXC_ERROR THEN

656: p_count => x_msg_count,
657: p_data => x_msg_data );
658:
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,

Line 662: x_return_status := FND_API.G_RET_STS_ERROR ;

658:
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

Line 666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
669: FND_MSG_PUB.Count_And_Get(
670: p_count => x_msg_count,

Line 668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
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

Line 674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

670: p_count => x_msg_count,
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,

Line 688: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

684: end Create_Element_Link;
685:
686: PROCEDURE Create_Set_Link(
687: P_API_VERSION IN NUMBER,
688: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
689: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
690: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
691: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
692: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 689: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

685:
686: PROCEDURE Create_Set_Link(
687: P_API_VERSION IN NUMBER,
688: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
689: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
690: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
691: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
692: X_MSG_COUNT OUT NOCOPY NUMBER,
693: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 690: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

686: PROCEDURE Create_Set_Link(
687: P_API_VERSION IN NUMBER,
688: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
689: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
690: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
691: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
692: X_MSG_COUNT OUT NOCOPY NUMBER,
693: X_MSG_DATA OUT NOCOPY VARCHAR2,
694: P_SET_LINK_REC IN CS_KB_SET_LINKS%ROWTYPE,

Line 711: IF NOT FND_API.Compatible_API_Call(

707:
708: BEGIN
709: SAVEPOINT Create_Set_Link_Grp;
710:
711: IF NOT FND_API.Compatible_API_Call(
712: l_api_version,
713: p_api_version,
714: l_api_name,
715: G_PKG_NAME) THEN

Line 716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

712: l_api_version,
713: p_api_version,
714: l_api_name,
715: G_PKG_NAME) THEN
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;

Line 719: IF FND_API.to_Boolean(p_init_msg_list) THEN

715: G_PKG_NAME) THEN
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;

Line 723: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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:
725: CS_KB_SET_LINKS_PKG.Create_Set_Link(
726: P_LINK_TYPE => p_set_link_rec.link_type,
727: P_OBJECT_CODE => p_set_link_rec.object_code,

Line 756: IF FND_API.To_Boolean( p_commit ) AND

752: X_RETURN_STATUS := l_return_status;
753: X_MSG_DATA := l_msg_data;
754: X_MSG_COUNT := l_msg_count;
755:
756: IF FND_API.To_Boolean( p_commit ) AND
757: l_return_status = FND_API.G_RET_STS_SUCCESS THEN
758: COMMIT WORK;
759: END IF;
760:

Line 757: l_return_status = FND_API.G_RET_STS_SUCCESS THEN

753: X_MSG_DATA := l_msg_data;
754: X_MSG_COUNT := l_msg_count;
755:
756: IF FND_API.To_Boolean( p_commit ) AND
757: l_return_status = FND_API.G_RET_STS_SUCCESS THEN
758: COMMIT WORK;
759: END IF;
760:
761: EXCEPTION

Line 762: WHEN FND_API.G_EXC_ERROR THEN

758: COMMIT WORK;
759: END IF;
760:
761: EXCEPTION
762: WHEN FND_API.G_EXC_ERROR THEN
763:
764: ROLLBACK TO Create_Set_Link_Grp;
765:
766: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;

Line 766: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;

762: WHEN FND_API.G_EXC_ERROR THEN
763:
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,

Line 769: p_encoded => FND_API.G_FALSE,

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:
773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

769: p_encoded => FND_API.G_FALSE,
770: p_count => x_msg_count,
771: p_data => x_msg_data );
772:
773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
774:
775: ROLLBACK TO Create_Set_Link_Grp;
776:
777: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 777: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
774:
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);

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 786: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

782: WHEN OTHERS THEN
783:
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);

Line 794: p_encoded => FND_API.G_FALSE ,

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:
798: END Create_Set_Link;

Line 802: p_init_msg_list in varchar2 := FND_API.G_FALSE,

798: END Create_Set_Link;
799:
800: PROCEDURE Update_Set_Link(
801: p_api_version in number,
802: p_init_msg_list in varchar2 := FND_API.G_FALSE,
803: p_commit in varchar2 := FND_API.G_FALSE,
804: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
805: x_return_status OUT NOCOPY varchar2,
806: x_msg_count OUT NOCOPY number,

Line 803: p_commit in varchar2 := FND_API.G_FALSE,

799:
800: PROCEDURE Update_Set_Link(
801: p_api_version in number,
802: p_init_msg_list in varchar2 := FND_API.G_FALSE,
803: p_commit in varchar2 := FND_API.G_FALSE,
804: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
805: x_return_status OUT NOCOPY varchar2,
806: x_msg_count OUT NOCOPY number,
807: x_msg_data OUT NOCOPY varchar2,

Line 804: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

800: PROCEDURE Update_Set_Link(
801: p_api_version in number,
802: p_init_msg_list in varchar2 := FND_API.G_FALSE,
803: p_commit in varchar2 := FND_API.G_FALSE,
804: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
805: x_return_status OUT NOCOPY varchar2,
806: x_msg_count OUT NOCOPY number,
807: x_msg_data OUT NOCOPY varchar2,
808: p_set_link_rec in CS_KB_SET_LINKS%ROWTYPE

Line 819: if not FND_API.Compatible_API_Call(

815: l_sta number(15);
816: begin
817: savepoint Update_Set_Link_Grp;
818:
819: if not FND_API.Compatible_API_Call(
820: l_api_version,
821: p_api_version,
822: l_api_name,
823: G_PKG_NAME) then

Line 824: raise FND_API.G_EXC_UNEXPECTED_ERROR;

820: l_api_version,
821: p_api_version,
822: l_api_name,
823: G_PKG_NAME) then
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;

Line 827: if FND_API.to_Boolean(p_init_msg_list) then

823: G_PKG_NAME) then
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;

Line 831: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
833: -- -- -- -- begin my code -- -- -- -- --
834:
835: l_sta := CS_KB_SET_LINKS_PKG.Update_Set_Link(

Line 859: raise FND_API.G_EXC_UNEXPECTED_ERROR;

855: p_set_link_rec.attribute14,
856: p_set_link_rec.attribute15
857: );
858: if(l_sta<>CS_KB_SET_LINKS_PKG.OKAY_STATUS) then
859: raise FND_API.G_EXC_UNEXPECTED_ERROR;
860: end if;
861:
862: -- -- -- -- end of code -- -- --
863:

Line 864: IF FND_API.To_Boolean( p_commit ) THEN

860: end if;
861:
862: -- -- -- -- end of code -- -- --
863:
864: IF FND_API.To_Boolean( p_commit ) THEN
865: COMMIT WORK;
866: END IF;
867:
868: -- Standard call to get message count. if count=1, get message info.

Line 874: WHEN FND_API.G_EXC_ERROR THEN

870: p_count => x_msg_count,
871: p_data => x_msg_data );
872:
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,

Line 876: x_return_status := FND_API.G_RET_STS_ERROR ;

872:
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

Line 880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
883: FND_MSG_PUB.Count_And_Get(
884: p_count => x_msg_count,

Line 882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
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

Line 888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

884: p_count => x_msg_count,
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,

Line 902: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

898: end Update_Set_Link;
899:
900: PROCEDURE Specific_Search_Mes(
901: p_api_version IN NUMBER,
902: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
903: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
904: x_return_status OUT NOCOPY VARCHAR2,
905: x_msg_count OUT NOCOPY NUMBER,
906: x_msg_data OUT NOCOPY VARCHAR2,

Line 903: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

899:
900: PROCEDURE Specific_Search_Mes(
901: p_api_version IN NUMBER,
902: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
903: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
904: x_return_status OUT NOCOPY VARCHAR2,
905: x_msg_count OUT NOCOPY NUMBER,
906: x_msg_data OUT NOCOPY VARCHAR2,
907: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 907: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,

903: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
904: x_return_status OUT NOCOPY VARCHAR2,
905: x_msg_count OUT NOCOPY NUMBER,
906: x_msg_data OUT NOCOPY VARCHAR2,
907: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
908: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
909: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
910: p_application_id IN NUMBER,
911: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type

Line 908: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,

904: x_return_status OUT NOCOPY VARCHAR2,
905: x_msg_count OUT NOCOPY NUMBER,
906: x_msg_data OUT NOCOPY VARCHAR2,
907: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
908: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
909: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
910: p_application_id IN NUMBER,
911: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
912: := null, --amv_search_grp.Default_AreaArray,

Line 909: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

905: x_msg_count OUT NOCOPY NUMBER,
906: x_msg_data OUT NOCOPY VARCHAR2,
907: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
908: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
909: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
910: p_application_id IN NUMBER,
911: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
912: := null, --amv_search_grp.Default_AreaArray,
913: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type

Line 916: p_user_id IN NUMBER := FND_API.G_MISS_NUM,

912: := null, --amv_search_grp.Default_AreaArray,
913: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
914: := null, --amv_search_grp.Default_ContentArray,
915: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
916: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
917: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,
918: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
919: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
920: p_rows_requested IN NUMBER,

Line 918: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

914: := null, --amv_search_grp.Default_ContentArray,
915: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
916: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
917: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,
918: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
919: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
920: p_rows_requested IN NUMBER,
921: p_start_row_pos IN NUMBER := 1,
922: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_false,

Line 919: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

915: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type,
916: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
917: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type,
918: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
919: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
920: p_rows_requested IN NUMBER,
921: p_start_row_pos IN NUMBER := 1,
922: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_false,
923: x_rows_returned OUT NOCOPY NUMBER,

Line 922: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_false,

918: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
919: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
920: p_rows_requested IN NUMBER,
921: p_start_row_pos IN NUMBER := 1,
922: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_false,
923: x_rows_returned OUT NOCOPY NUMBER,
924: x_next_row_pos OUT NOCOPY NUMBER,
925: x_total_row_cnt OUT NOCOPY NUMBER,
926: x_result_array IN OUT NOCOPY cs_kb_result_varray_type,

Line 966: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then

962: x_searchres_array => l_amv_res_array);
963:
964: x_amv_result_array := l_amv_res_array;
965:
966: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then
967:
968: x_rows_returned
969: := l_amv_ret_obj.returned_record_count;
970: x_next_row_pos

Line 1000: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

996: end Specific_Search_Mes;
997:
998: PROCEDURE Specific_Search_Sms(
999: p_api_version IN NUMBER,
1000: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1001: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1002: x_return_status OUT NOCOPY VARCHAR2,
1003: x_msg_count OUT NOCOPY NUMBER,
1004: x_msg_data OUT NOCOPY VARCHAR2,

Line 1001: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

997:
998: PROCEDURE Specific_Search_Sms(
999: p_api_version IN NUMBER,
1000: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1001: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1002: x_return_status OUT NOCOPY VARCHAR2,
1003: x_msg_count OUT NOCOPY NUMBER,
1004: x_msg_data OUT NOCOPY VARCHAR2,
1005: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1005: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,

1001: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1002: x_return_status OUT NOCOPY VARCHAR2,
1003: x_msg_count OUT NOCOPY NUMBER,
1004: x_msg_data OUT NOCOPY VARCHAR2,
1005: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
1006: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1007: p_rows_requested IN NUMBER,
1008: p_start_row_pos IN NUMBER := 1,
1009: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_false,

Line 1006: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,

1002: x_return_status OUT NOCOPY VARCHAR2,
1003: x_msg_count OUT NOCOPY NUMBER,
1004: x_msg_data OUT NOCOPY VARCHAR2,
1005: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
1006: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1007: p_rows_requested IN NUMBER,
1008: p_start_row_pos IN NUMBER := 1,
1009: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_false,
1010: x_rows_returned OUT NOCOPY NUMBER,

Line 1009: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_false,

1005: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
1006: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1007: p_rows_requested IN NUMBER,
1008: p_start_row_pos IN NUMBER := 1,
1009: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_false,
1010: x_rows_returned OUT NOCOPY NUMBER,
1011: x_next_row_pos OUT NOCOPY NUMBER,
1012: x_total_row_cnt OUT NOCOPY NUMBER,
1013: x_result_array IN OUT NOCOPY cs_kb_result_varray_type,

Line 1028: if( p_search_string = FND_API.G_MISS_CHAR ) then

1024: --null;
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;

Line 1033: raise FND_API.G_EXC_ERROR;

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:
1036:
1037: if( p_updated_in_days is not null and

Line 1038: p_updated_in_days

1034: end if;
1035:
1036:
1037: if( p_updated_in_days is not null and
1038: p_updated_in_days 1039: p_updated_in_days >= 0) then
1040: l_days_cond :=
1041: ' and cs_kb_sets_b.last_update_date >= (sysdate - :2 ) ';
1042: -- ' and cs_kb_sets_vl.last_update_date >= (sysdate - ' ||

Line 1089: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then

1085:
1086: end if;
1087:
1088: -- return x_row_return_obj and x_result_array
1089: if(x_return_status = FND_API.G_RET_STS_SUCCESS) then
1090:
1091: l_ret_cnt := l_sms_res_tbl.COUNT;
1092: x_total_row_cnt := l_total_cnt;
1093: x_rows_returned := l_ret_cnt;

Line 1132: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1128: -- the record type api.
1129: --
1130: PROCEDURE Specific_Search(
1131: p_api_version IN NUMBER,
1132: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1134: x_return_status OUT NOCOPY VARCHAR2,
1135: x_msg_count OUT NOCOPY NUMBER,
1136: x_msg_data OUT NOCOPY VARCHAR2,

Line 1133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1129: --
1130: PROCEDURE Specific_Search(
1131: p_api_version IN NUMBER,
1132: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1133: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1134: x_return_status OUT NOCOPY VARCHAR2,
1135: x_msg_count OUT NOCOPY NUMBER,
1136: x_msg_data OUT NOCOPY VARCHAR2,
1137: p_repository_tbl IN cs_kb_varchar100_tbl_type,

Line 1138: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,

1134: x_return_status OUT NOCOPY VARCHAR2,
1135: x_msg_count OUT NOCOPY NUMBER,
1136: x_msg_data OUT NOCOPY VARCHAR2,
1137: p_repository_tbl IN cs_kb_varchar100_tbl_type,
1138: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
1139: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1140: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1141: p_application_id IN NUMBER,
1142: p_area_array IN JTF_VARCHAR2_TABLE_4000 := null,

Line 1139: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,

1135: x_msg_count OUT NOCOPY NUMBER,
1136: x_msg_data OUT NOCOPY VARCHAR2,
1137: p_repository_tbl IN cs_kb_varchar100_tbl_type,
1138: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
1139: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1140: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1141: p_application_id IN NUMBER,
1142: p_area_array IN JTF_VARCHAR2_TABLE_4000 := null,
1143: p_content_array IN JTF_VARCHAR2_TABLE_4000 := null,

Line 1140: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1136: x_msg_data OUT NOCOPY VARCHAR2,
1137: p_repository_tbl IN cs_kb_varchar100_tbl_type,
1138: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
1139: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1140: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1141: p_application_id IN NUMBER,
1142: p_area_array IN JTF_VARCHAR2_TABLE_4000 := null,
1143: p_content_array IN JTF_VARCHAR2_TABLE_4000 := null,
1144: p_param_operator_array IN JTF_VARCHAR2_TABLE_100 := null,

Line 1146: p_user_id IN NUMBER := FND_API.G_MISS_NUM,

1142: p_area_array IN JTF_VARCHAR2_TABLE_4000 := null,
1143: p_content_array IN JTF_VARCHAR2_TABLE_4000 := null,
1144: p_param_operator_array IN JTF_VARCHAR2_TABLE_100 := null,
1145: p_param_searchstring_array IN JTF_VARCHAR2_TABLE_400 := null,
1146: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1147: p_category_id IN JTF_NUMBER_TABLE,
1148: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1149: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1150: p_rows_requested_tbl IN cs_kb_number_tbl_type,

Line 1148: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

1144: p_param_operator_array IN JTF_VARCHAR2_TABLE_100 := null,
1145: p_param_searchstring_array IN JTF_VARCHAR2_TABLE_400 := null,
1146: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1147: p_category_id IN JTF_NUMBER_TABLE,
1148: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1149: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1150: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1151: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1152: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

Line 1149: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

1145: p_param_searchstring_array IN JTF_VARCHAR2_TABLE_400 := null,
1146: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1147: p_category_id IN JTF_NUMBER_TABLE,
1148: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1149: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1150: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1151: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1152: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1153: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 1152: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

1148: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1149: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1150: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1151: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1152: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1153: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1154: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1155: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
1156: x_result_array OUT NOCOPY cs_kb_result_varray_type,

Line 1250: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1246: -- This api uses amv's record types, which used to be object types.
1247: --
1248: PROCEDURE Specific_Search(
1249: p_api_version IN NUMBER,
1250: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1252: x_return_status OUT NOCOPY VARCHAR2,
1253: x_msg_count OUT NOCOPY NUMBER,
1254: x_msg_data OUT NOCOPY VARCHAR2,

Line 1251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1247: --
1248: PROCEDURE Specific_Search(
1249: p_api_version IN NUMBER,
1250: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1251: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1252: x_return_status OUT NOCOPY VARCHAR2,
1253: x_msg_count OUT NOCOPY NUMBER,
1254: x_msg_data OUT NOCOPY VARCHAR2,
1255: p_repository_tbl IN cs_kb_varchar100_tbl_type,

Line 1256: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,

1252: x_return_status OUT NOCOPY VARCHAR2,
1253: x_msg_count OUT NOCOPY NUMBER,
1254: x_msg_data OUT NOCOPY VARCHAR2,
1255: p_repository_tbl IN cs_kb_varchar100_tbl_type,
1256: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
1257: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1258: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1259: p_application_id IN NUMBER,
1260: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type

Line 1257: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,

1253: x_msg_count OUT NOCOPY NUMBER,
1254: x_msg_data OUT NOCOPY VARCHAR2,
1255: p_repository_tbl IN cs_kb_varchar100_tbl_type,
1256: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
1257: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1258: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1259: p_application_id IN NUMBER,
1260: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
1261: := AMV_SEARCH_PVT.amv_char_varray_type(),

Line 1258: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1254: x_msg_data OUT NOCOPY VARCHAR2,
1255: p_repository_tbl IN cs_kb_varchar100_tbl_type,
1256: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
1257: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1258: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1259: p_application_id IN NUMBER,
1260: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
1261: := AMV_SEARCH_PVT.amv_char_varray_type(),
1262: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type

Line 1266: p_user_id IN NUMBER := FND_API.G_MISS_NUM,

1262: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
1263: := AMV_SEARCH_PVT.amv_char_varray_type(),
1264: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1265: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1266: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1267: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1268: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1269: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1270: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

Line 1269: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

1265: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1266: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1267: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1268: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1269: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1270: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1271: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1272: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1273: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

Line 1270: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

1266: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1267: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1268: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1269: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1270: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1271: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1272: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1273: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1274: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 1273: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

1269: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1270: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1271: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1272: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1273: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1274: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1275: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1276: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
1277: x_result_array OUT NOCOPY cs_kb_result_varray_type,

Line 1319: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1315: -- Main Specific search
1316: --
1317: PROCEDURE Specific_Search(
1318: p_api_version IN NUMBER,
1319: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1320: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1321: x_return_status OUT NOCOPY VARCHAR2,
1322: x_msg_count OUT NOCOPY NUMBER,
1323: x_msg_data OUT NOCOPY VARCHAR2,

Line 1320: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1316: --
1317: PROCEDURE Specific_Search(
1318: p_api_version IN NUMBER,
1319: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1320: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1321: x_return_status OUT NOCOPY VARCHAR2,
1322: x_msg_count OUT NOCOPY NUMBER,
1323: x_msg_data OUT NOCOPY VARCHAR2,
1324: p_repository_tbl IN cs_kb_varchar100_tbl_type,

Line 1325: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,

1321: x_return_status OUT NOCOPY VARCHAR2,
1322: x_msg_count OUT NOCOPY NUMBER,
1323: x_msg_data OUT NOCOPY VARCHAR2,
1324: p_repository_tbl IN cs_kb_varchar100_tbl_type,
1325: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
1326: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1327: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1328: p_application_id IN NUMBER,
1329: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type

Line 1326: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,

1322: x_msg_count OUT NOCOPY NUMBER,
1323: x_msg_data OUT NOCOPY VARCHAR2,
1324: p_repository_tbl IN cs_kb_varchar100_tbl_type,
1325: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
1326: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1327: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1328: p_application_id IN NUMBER,
1329: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
1330: := AMV_SEARCH_PVT.amv_char_varray_type(),

Line 1327: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

1323: x_msg_data OUT NOCOPY VARCHAR2,
1324: p_repository_tbl IN cs_kb_varchar100_tbl_type,
1325: p_search_string IN VARCHAR2 := FND_API.G_MISS_CHAR,
1326: p_updated_in_days IN NUMBER := FND_API.G_MISS_NUM,
1327: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1328: p_application_id IN NUMBER,
1329: p_area_array IN AMV_SEARCH_PVT.amv_char_varray_type
1330: := AMV_SEARCH_PVT.amv_char_varray_type(),
1331: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type

Line 1335: p_user_id IN NUMBER := FND_API.G_MISS_NUM,

1331: p_content_array IN AMV_SEARCH_PVT.amv_char_varray_type
1332: := AMV_SEARCH_PVT.amv_char_varray_type(),
1333: p_param_array IN AMV_SEARCH_PVT.amv_searchpar_varray_type
1334: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1335: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1336: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1337: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1338: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1339: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

Line 1338: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

1334: := AMV_SEARCH_PVT.amv_searchpar_varray_type(),
1335: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1336: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1337: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1338: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1339: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1340: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1341: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1342: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

Line 1339: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,

1335: p_user_id IN NUMBER := FND_API.G_MISS_NUM,
1336: p_category_id IN AMV_SEARCH_PVT.amv_number_varray_type
1337: :=AMV_SEARCH_PVT.amv_number_varray_type(),
1338: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1339: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1340: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1341: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1342: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1343: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,

Line 1342: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,

1338: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
1339: p_external_contents IN VARCHAR2 := FND_API.G_FALSE,
1340: p_rows_requested_tbl IN cs_kb_number_tbl_type,
1341: p_start_row_pos_tbl IN cs_kb_number_tbl_type,
1342: p_get_total_cnt_flag IN VARCHAR2 := fnd_api.g_true,
1343: x_rows_returned_tbl OUT NOCOPY cs_kb_number_tbl_type,
1344: x_next_row_pos_tbl OUT NOCOPY cs_kb_number_tbl_type,
1345: x_total_row_cnt_tbl OUT NOCOPY cs_kb_number_tbl_type,
1346: x_result_array OUT NOCOPY cs_kb_result_varray_type,

Line 1360: if not FND_API.Compatible_API_Call(

1356: l_search_option NUMBER := p_search_option;
1357: begin
1358: savepoint Specific_Search_GRP;
1359:
1360: if not FND_API.Compatible_API_Call(
1361: l_api_version,
1362: p_api_version,
1363: l_api_name,
1364: G_PKG_NAME) then

Line 1365: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1361: l_api_version,
1362: p_api_version,
1363: l_api_name,
1364: G_PKG_NAME) then
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;

Line 1368: if FND_API.to_Boolean(p_init_msg_list) then

1364: G_PKG_NAME) then
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;

Line 1372: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 -- -- -- -- --
1374: -- 08/10/2004, klou, check search option
1375: if l_search_option is null then
1376: -- default to interMedia search, as this API is specifically for

Line 1395: raise FND_API.G_EXC_ERROR;

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:
1398: ind := p_repository_tbl.FIRST;
1399: while ind is not null loop

Line 1525: WHEN FND_API.G_EXC_ERROR THEN

1521: p_count => x_msg_count,
1522: p_data => x_msg_data );
1523:
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,

Line 1527: x_return_status := FND_API.G_RET_STS_ERROR ;

1523:
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

Line 1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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;
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1534: FND_MSG_PUB.Count_And_Get(
1535: p_count => x_msg_count,

Line 1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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;
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:

Line 1540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1536: p_data => x_msg_data);
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,

Line 1583: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1579: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1580:
1581: BEGIN
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;

Line 1585: IF FND_API.to_Boolean(P_INIT_MSG_LIST) THEN

1581: BEGIN
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

Line 1597: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
1601: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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 1622: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1618: AND t.Processing_Set_Id = P_PROCESSING_SET_ID
1619: AND t.Object_Type = P_OBJECT_TYPE
1620: );
1621:
1622: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1623:
1624: IF FND_API.to_Boolean(P_COMMIT) THEN
1625: COMMIT;
1626: END IF;

Line 1624: IF FND_API.to_Boolean(P_COMMIT) THEN

1620: );
1621:
1622: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1623:
1624: IF FND_API.to_Boolean(P_COMMIT) THEN
1625: COMMIT;
1626: END IF;
1627:
1628: END IF;

Line 1646: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

1642: ' Error= '||sqlerrm);
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;

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: