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 755: IF FND_API.To_Boolean( p_commit ) AND

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

Line 756: l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 761: WHEN FND_API.G_EXC_ERROR THEN

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

Line 765: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;

761: WHEN FND_API.G_EXC_ERROR THEN
762:
763: ROLLBACK TO Create_Set_Link_Grp;
764:
765: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;
766:
767: FND_MSG_PUB.Count_And_Get(
768: p_encoded => FND_API.G_FALSE,
769: p_count => x_msg_count,

Line 768: p_encoded => FND_API.G_FALSE,

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

Line 772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 776: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

Line 785: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 793: p_encoded => FND_API.G_FALSE ,

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

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

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

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

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

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

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

Line 818: if not FND_API.Compatible_API_Call(

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

Line 823: raise FND_API.G_EXC_UNEXPECTED_ERROR;

819: l_api_version,
820: p_api_version,
821: l_api_name,
822: G_PKG_NAME) then
823: raise FND_API.G_EXC_UNEXPECTED_ERROR;
824: end if;
825:
826: if FND_API.to_Boolean(p_init_msg_list) then
827: FND_MSG_PUB.initialize;

Line 826: if FND_API.to_Boolean(p_init_msg_list) then

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

Line 830: x_return_status := FND_API.G_RET_STS_SUCCESS;

826: if FND_API.to_Boolean(p_init_msg_list) then
827: FND_MSG_PUB.initialize;
828: end if;
829:
830: x_return_status := FND_API.G_RET_STS_SUCCESS;
831:
832: -- -- -- -- begin my code -- -- -- -- --
833:
834: l_sta := CS_KB_SET_LINKS_PKG.Update_Set_Link(

Line 858: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 863: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 873: WHEN FND_API.G_EXC_ERROR THEN

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

Line 875: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1032: raise FND_API.G_EXC_ERROR;

1028: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1029: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1030: fnd_msg_pub.Add;
1031: end if;
1032: raise FND_API.G_EXC_ERROR;
1033: end if;
1034:
1035:
1036: if( p_updated_in_days is not null and

Line 1037: p_updated_in_days

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1359: if not FND_API.Compatible_API_Call(

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

Line 1364: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1360: l_api_version,
1361: p_api_version,
1362: l_api_name,
1363: G_PKG_NAME) then
1364: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1365: end if;
1366:
1367: if FND_API.to_Boolean(p_init_msg_list) then
1368: FND_MSG_PUB.initialize;

Line 1367: if FND_API.to_Boolean(p_init_msg_list) then

1363: G_PKG_NAME) then
1364: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1365: end if;
1366:
1367: if FND_API.to_Boolean(p_init_msg_list) then
1368: FND_MSG_PUB.initialize;
1369: end if;
1370:
1371: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1371: x_return_status := FND_API.G_RET_STS_SUCCESS;

1367: if FND_API.to_Boolean(p_init_msg_list) then
1368: FND_MSG_PUB.initialize;
1369: end if;
1370:
1371: x_return_status := FND_API.G_RET_STS_SUCCESS;
1372: -- -- -- -- begin my code -- -- -- -- --
1373: -- 08/10/2004, klou, check search option
1374: if l_search_option is null then
1375: -- default to interMedia search, as this API is specifically for

Line 1394: raise FND_API.G_EXC_ERROR;

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

Line 1524: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1526: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1582: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1578: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1579:
1580: BEGIN
1581: SAVEPOINT Purge_Knowledge_Links_GRP;
1582: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1583:
1584: IF FND_API.to_Boolean(P_INIT_MSG_LIST) THEN
1585: FND_MSG_PUB.initialize;
1586: END IF;

Line 1584: IF FND_API.to_Boolean(P_INIT_MSG_LIST) THEN

1580: BEGIN
1581: SAVEPOINT Purge_Knowledge_Links_GRP;
1582: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1583:
1584: IF FND_API.to_Boolean(P_INIT_MSG_LIST) THEN
1585: FND_MSG_PUB.initialize;
1586: END IF;
1587:
1588: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1596: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

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

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

Line 1621: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

Line 1623: IF FND_API.to_Boolean(P_COMMIT) THEN

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

Line 1645: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

1641: ' Error= '||sqlerrm);
1642:
1643: END IF;
1644:
1645: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
1646: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1647: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,
1648: 'Purge_Knowledge_Links');
1649: END IF;

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

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