eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_KB_CATEGORIES_PVT dependencies on FND_API

Line 7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3:
4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_KB_CATEGORIES_PVT ';
5:
6: PROCEDURE create_item (p_api_version_number IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_kb_category_id NUMBER,
10: p_kb_parent_category_id IN NUMBER,
11: p_display_name IN VARCHAR2,

Line 8: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_KB_CATEGORIES_PVT ';
5:
6: PROCEDURE create_item (p_api_version_number IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_kb_category_id NUMBER,
10: p_kb_parent_category_id IN NUMBER,
11: p_display_name IN VARCHAR2,
12: p_category_code IN VARCHAR2,

Line 52: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

48: BEGIN
49: -- Standard Start of API savepoint
50: SAVEPOINT create_item_PVT;
51: -- Standard call to check for call compatibility.
52: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
53: p_api_version_number,
54: l_api_name,
55: G_PKG_NAME)
56: THEN

Line 57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

53: p_api_version_number,
54: l_api_name,
55: G_PKG_NAME)
56: THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: END IF;
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list )
61: THEN

Line 60: IF FND_API.to_Boolean( p_init_msg_list )

56: THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: END IF;
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list )
61: THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64: -- Initialize API return status to SUCCESS

Line 65: x_return_status := FND_API.G_RET_STS_SUCCESS;

61: THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64: -- Initialize API return status to SUCCESS
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: SELECT IEM_KB_CATEGORIES_s1.nextval
68: INTO l_seq_id
69: FROM dual;

Line 108: decode(p_category_desc,FND_API.G_MISS_CHAR,NULL,p_category_desc),

104: p_display_name,
105: p_category_code,
106: p_is_repos,
107: p_category_order,
108: decode(p_category_desc,FND_API.G_MISS_CHAR,NULL,p_category_desc),
109: decode(l_CREATED_BY,null,-1,l_CREATED_BY),
110: sysdate,
111: decode(l_LAST_UPDATED_BY,null,-1,l_LAST_UPDATED_BY),
112: sysdate,

Line 137: WHEN FND_API.G_EXC_ERROR THEN

133: ( p_count => x_msg_count,
134: p_data => x_msg_data
135: );
136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
138: ROLLBACK TO create_item_PVT;
139: x_return_status := FND_API.G_RET_STS_ERROR ;
140: FND_MSG_PUB.Count_And_Get
141: ( p_count => x_msg_count,

Line 139: x_return_status := FND_API.G_RET_STS_ERROR ;

135: );
136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
138: ROLLBACK TO create_item_PVT;
139: x_return_status := FND_API.G_RET_STS_ERROR ;
140: FND_MSG_PUB.Count_And_Get
141: ( p_count => x_msg_count,
142: p_data => x_msg_data
143: );

Line 144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

140: FND_MSG_PUB.Count_And_Get
141: ( p_count => x_msg_count,
142: p_data => x_msg_data
143: );
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: ROLLBACK TO create_item_PVT;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
147: FND_MSG_PUB.Count_And_Get
148: ( p_count => x_msg_count,

Line 146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

142: p_data => x_msg_data
143: );
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: ROLLBACK TO create_item_PVT;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
147: FND_MSG_PUB.Count_And_Get
148: ( p_count => x_msg_count,
149: p_data => x_msg_data
150: );

Line 153: x_return_status := FND_API.G_RET_STS_ERROR;

149: p_data => x_msg_data
150: );
151: WHEN OTHERS THEN
152: ROLLBACK TO create_item_PVT;
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: IF FND_MSG_PUB.Check_Msg_Level
155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
156: THEN
157: FND_MSG_PUB.Add_Exc_Msg

Line 170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

166:
167: END create_item;
168:
169: PROCEDURE delete_item (p_api_version_number IN NUMBER,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: p_kb_category_id in NUMBER,
173: p_kb_parent_category_id IN NUMBER,
174: p_display_name IN VARCHAR2 ,

Line 171: p_commit IN VARCHAR2 := FND_API.G_FALSE,

167: END create_item;
168:
169: PROCEDURE delete_item (p_api_version_number IN NUMBER,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: p_kb_category_id in NUMBER,
173: p_kb_parent_category_id IN NUMBER,
174: p_display_name IN VARCHAR2 ,
175: x_return_status OUT NOCOPY VARCHAR2,

Line 186: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

182: BEGIN
183: -- Standard Start of API savepoint
184: SAVEPOINT delete_item_PVT;
185: -- Standard call to check for call compatibility.
186: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
187: p_api_version_number,
188: l_api_name,
189: G_PKG_NAME)
190: THEN

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

187: p_api_version_number,
188: l_api_name,
189: G_PKG_NAME)
190: THEN
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: END IF;
193: -- Initialize message list if p_init_msg_list is set to TRUE.
194: IF FND_API.to_Boolean( p_init_msg_list )
195: THEN

Line 194: IF FND_API.to_Boolean( p_init_msg_list )

190: THEN
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: END IF;
193: -- Initialize message list if p_init_msg_list is set to TRUE.
194: IF FND_API.to_Boolean( p_init_msg_list )
195: THEN
196: FND_MSG_PUB.initialize;
197: END IF;
198: -- Initialize API return status to SUCCESS

Line 199: x_return_status := FND_API.G_RET_STS_SUCCESS;

195: THEN
196: FND_MSG_PUB.initialize;
197: END IF;
198: -- Initialize API return status to SUCCESS
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
201: IF p_kb_category_id =FND_API.G_MISS_NUM THEN
202: DELETE FROM IEM_KB_CATEGORIES
203: WHERE display_name=p_display_name AND

Line 201: IF p_kb_category_id =FND_API.G_MISS_NUM THEN

197: END IF;
198: -- Initialize API return status to SUCCESS
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
201: IF p_kb_category_id =FND_API.G_MISS_NUM THEN
202: DELETE FROM IEM_KB_CATEGORIES
203: WHERE display_name=p_display_name AND
204: kb_parent_category_id=p_kb_parent_category_id;
205: else

Line 211: IF FND_API.To_Boolean(p_commit) THEN

207: where kb_category_id=p_kb_category_id;
208: end if;
209:
210: -- Standard Check Of p_commit.
211: IF FND_API.To_Boolean(p_commit) THEN
212: COMMIT WORK;
213: END IF;
214: -- Standard callto get message count and if count is 1, get message info.
215: FND_MSG_PUB.Count_And_Get

Line 220: WHEN FND_API.G_EXC_ERROR THEN

216: ( p_count => x_msg_count,
217: p_data => x_msg_data
218: );
219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN
221: ROLLBACK TO delete_item_PVT;
222: x_return_status := FND_API.G_RET_STS_ERROR ;
223: FND_MSG_PUB.Count_And_Get
224: ( p_count => x_msg_count,

Line 222: x_return_status := FND_API.G_RET_STS_ERROR ;

218: );
219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN
221: ROLLBACK TO delete_item_PVT;
222: x_return_status := FND_API.G_RET_STS_ERROR ;
223: FND_MSG_PUB.Count_And_Get
224: ( p_count => x_msg_count,
225: p_data => x_msg_data
226: );

Line 227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

223: FND_MSG_PUB.Count_And_Get
224: ( p_count => x_msg_count,
225: p_data => x_msg_data
226: );
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO delete_item_PVT;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: FND_MSG_PUB.Count_And_Get
231: ( p_count => x_msg_count,

Line 229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

225: p_data => x_msg_data
226: );
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO delete_item_PVT;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: FND_MSG_PUB.Count_And_Get
231: ( p_count => x_msg_count,
232: p_data => x_msg_data
233: );

Line 236: x_return_status := FND_API.G_RET_STS_ERROR;

232: p_data => x_msg_data
233: );
234: WHEN OTHERS THEN
235: ROLLBACK TO delete_item_PVT;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: IF FND_MSG_PUB.Check_Msg_Level
238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: FND_MSG_PUB.Add_Exc_Msg

Line 253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

249:
250: END delete_item;
251:
252: PROCEDURE update_item (p_api_version_number IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
255: p_kb_category_id IN NUMBER,
256: p_kb_parent_category_id IN number,
257: p_display_name IN varchar2,

Line 254: p_commit IN VARCHAR2 := FND_API.G_FALSE,

250: END delete_item;
251:
252: PROCEDURE update_item (p_api_version_number IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254: p_commit IN VARCHAR2 := FND_API.G_FALSE,
255: p_kb_category_id IN NUMBER,
256: p_kb_parent_category_id IN number,
257: p_display_name IN varchar2,
258: p_category_code IN varchar2,

Line 295: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

291: BEGIN
292: -- Standard Start of API savepoint
293: SAVEPOINT update_item_PVT;
294: -- Standard call to check for call compatibility.
295: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
296: p_api_version_number,
297: l_api_name,
298: G_PKG_NAME)
299: THEN

Line 300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

296: p_api_version_number,
297: l_api_name,
298: G_PKG_NAME)
299: THEN
300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
301: END IF;
302: -- Initialize message list if p_init_msg_list is set to TRUE.
303: IF FND_API.to_Boolean( p_init_msg_list )
304: THEN

Line 303: IF FND_API.to_Boolean( p_init_msg_list )

299: THEN
300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
301: END IF;
302: -- Initialize message list if p_init_msg_list is set to TRUE.
303: IF FND_API.to_Boolean( p_init_msg_list )
304: THEN
305: FND_MSG_PUB.initialize;
306: END IF;
307: -- Initialize API return status to SUCCESS

Line 308: x_return_status := FND_API.G_RET_STS_SUCCESS;

304: THEN
305: FND_MSG_PUB.initialize;
306: END IF;
307: -- Initialize API return status to SUCCESS
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309:
310: update IEM_KB_CATEGORIES
311: set kb_parent_category_id=decode(p_kb_parent_category_id,FND_API.G_MISS_NUM,kb_parent_category_id,p_kb_parent_category_id),
312: display_name=decode(p_display_name,FND_API.G_MISS_CHAR,display_name,p_display_name),

Line 311: set kb_parent_category_id=decode(p_kb_parent_category_id,FND_API.G_MISS_NUM,kb_parent_category_id,p_kb_parent_category_id),

307: -- Initialize API return status to SUCCESS
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309:
310: update IEM_KB_CATEGORIES
311: set kb_parent_category_id=decode(p_kb_parent_category_id,FND_API.G_MISS_NUM,kb_parent_category_id,p_kb_parent_category_id),
312: display_name=decode(p_display_name,FND_API.G_MISS_CHAR,display_name,p_display_name),
313: category_code=decode(p_category_code,FND_API.G_MISS_CHAR,category_code,p_category_code),
314: is_repository=decode(p_is_repos,FND_API.G_MISS_CHAR,is_repository,p_is_repos),
315: category_order=decode(p_category_order,FND_API.G_MISS_NUM,category_order,p_category_order),

Line 312: display_name=decode(p_display_name,FND_API.G_MISS_CHAR,display_name,p_display_name),

308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309:
310: update IEM_KB_CATEGORIES
311: set kb_parent_category_id=decode(p_kb_parent_category_id,FND_API.G_MISS_NUM,kb_parent_category_id,p_kb_parent_category_id),
312: display_name=decode(p_display_name,FND_API.G_MISS_CHAR,display_name,p_display_name),
313: category_code=decode(p_category_code,FND_API.G_MISS_CHAR,category_code,p_category_code),
314: is_repository=decode(p_is_repos,FND_API.G_MISS_CHAR,is_repository,p_is_repos),
315: category_order=decode(p_category_order,FND_API.G_MISS_NUM,category_order,p_category_order),
316: category_desc=decode(p_category_desc,FND_API.G_MISS_CHAR,category_desc,p_category_desc),

Line 313: category_code=decode(p_category_code,FND_API.G_MISS_CHAR,category_code,p_category_code),

309:
310: update IEM_KB_CATEGORIES
311: set kb_parent_category_id=decode(p_kb_parent_category_id,FND_API.G_MISS_NUM,kb_parent_category_id,p_kb_parent_category_id),
312: display_name=decode(p_display_name,FND_API.G_MISS_CHAR,display_name,p_display_name),
313: category_code=decode(p_category_code,FND_API.G_MISS_CHAR,category_code,p_category_code),
314: is_repository=decode(p_is_repos,FND_API.G_MISS_CHAR,is_repository,p_is_repos),
315: category_order=decode(p_category_order,FND_API.G_MISS_NUM,category_order,p_category_order),
316: category_desc=decode(p_category_desc,FND_API.G_MISS_CHAR,category_desc,p_category_desc),
317: LAST_UPDATE_DATE = sysdate,

Line 314: is_repository=decode(p_is_repos,FND_API.G_MISS_CHAR,is_repository,p_is_repos),

310: update IEM_KB_CATEGORIES
311: set kb_parent_category_id=decode(p_kb_parent_category_id,FND_API.G_MISS_NUM,kb_parent_category_id,p_kb_parent_category_id),
312: display_name=decode(p_display_name,FND_API.G_MISS_CHAR,display_name,p_display_name),
313: category_code=decode(p_category_code,FND_API.G_MISS_CHAR,category_code,p_category_code),
314: is_repository=decode(p_is_repos,FND_API.G_MISS_CHAR,is_repository,p_is_repos),
315: category_order=decode(p_category_order,FND_API.G_MISS_NUM,category_order,p_category_order),
316: category_desc=decode(p_category_desc,FND_API.G_MISS_CHAR,category_desc,p_category_desc),
317: LAST_UPDATE_DATE = sysdate,
318: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),

Line 315: category_order=decode(p_category_order,FND_API.G_MISS_NUM,category_order,p_category_order),

311: set kb_parent_category_id=decode(p_kb_parent_category_id,FND_API.G_MISS_NUM,kb_parent_category_id,p_kb_parent_category_id),
312: display_name=decode(p_display_name,FND_API.G_MISS_CHAR,display_name,p_display_name),
313: category_code=decode(p_category_code,FND_API.G_MISS_CHAR,category_code,p_category_code),
314: is_repository=decode(p_is_repos,FND_API.G_MISS_CHAR,is_repository,p_is_repos),
315: category_order=decode(p_category_order,FND_API.G_MISS_NUM,category_order,p_category_order),
316: category_desc=decode(p_category_desc,FND_API.G_MISS_CHAR,category_desc,p_category_desc),
317: LAST_UPDATE_DATE = sysdate,
318: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),
319: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),

Line 316: category_desc=decode(p_category_desc,FND_API.G_MISS_CHAR,category_desc,p_category_desc),

312: display_name=decode(p_display_name,FND_API.G_MISS_CHAR,display_name,p_display_name),
313: category_code=decode(p_category_code,FND_API.G_MISS_CHAR,category_code,p_category_code),
314: is_repository=decode(p_is_repos,FND_API.G_MISS_CHAR,is_repository,p_is_repos),
315: category_order=decode(p_category_order,FND_API.G_MISS_NUM,category_order,p_category_order),
316: category_desc=decode(p_category_desc,FND_API.G_MISS_CHAR,category_desc,p_category_desc),
317: LAST_UPDATE_DATE = sysdate,
318: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),
319: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),
320: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

Line 320: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

316: category_desc=decode(p_category_desc,FND_API.G_MISS_CHAR,category_desc,p_category_desc),
317: LAST_UPDATE_DATE = sysdate,
318: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),
319: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),
320: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
321: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
322: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
323: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
324: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

Line 321: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

317: LAST_UPDATE_DATE = sysdate,
318: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),
319: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),
320: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
321: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
322: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
323: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
324: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
325: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

Line 322: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

318: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),
319: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),
320: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
321: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
322: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
323: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
324: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
325: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
326: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

Line 323: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

319: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),
320: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
321: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
322: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
323: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
324: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
325: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
326: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
327: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

Line 324: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

320: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
321: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
322: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
323: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
324: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
325: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
326: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
327: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
328: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

Line 325: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

321: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
322: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
323: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
324: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
325: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
326: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
327: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
328: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
329: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

Line 326: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

322: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
323: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
324: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
325: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
326: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
327: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
328: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
329: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
330: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

Line 327: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

323: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
324: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
325: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
326: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
327: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
328: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
329: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
330: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
331: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

Line 328: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

324: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
325: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
326: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
327: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
328: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
329: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
330: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
331: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
332: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

Line 329: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

325: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
326: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
327: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
328: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
329: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
330: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
331: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
332: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
333: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

Line 330: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

326: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
327: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
328: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
329: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
330: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
331: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
332: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
333: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
334: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)

Line 331: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

327: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
328: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
329: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
330: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
331: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
332: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
333: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
334: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
335: where kb_category_id=p_kb_category_id;

Line 332: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

328: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
329: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
330: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
331: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
332: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
333: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
334: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
335: where kb_category_id=p_kb_category_id;
336:

Line 333: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

329: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
330: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
331: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
332: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
333: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
334: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
335: where kb_category_id=p_kb_category_id;
336:
337: -- Standard Check Of p_commit.

Line 334: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)

330: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
331: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
332: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
333: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
334: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
335: where kb_category_id=p_kb_category_id;
336:
337: -- Standard Check Of p_commit.
338: IF FND_API.To_Boolean(p_commit) THEN

Line 338: IF FND_API.To_Boolean(p_commit) THEN

334: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
335: where kb_category_id=p_kb_category_id;
336:
337: -- Standard Check Of p_commit.
338: IF FND_API.To_Boolean(p_commit) THEN
339: COMMIT WORK;
340: END IF;
341: -- Standard callto get message count and if count is 1, get message info.
342: FND_MSG_PUB.Count_And_Get

Line 347: WHEN FND_API.G_EXC_ERROR THEN

343: ( p_count => x_msg_count,
344: p_data => x_msg_data
345: );
346: EXCEPTION
347: WHEN FND_API.G_EXC_ERROR THEN
348: ROLLBACK TO update_item_PVT;
349: x_return_status := FND_API.G_RET_STS_ERROR ;
350: FND_MSG_PUB.Count_And_Get
351: ( p_count => x_msg_count,

Line 349: x_return_status := FND_API.G_RET_STS_ERROR ;

345: );
346: EXCEPTION
347: WHEN FND_API.G_EXC_ERROR THEN
348: ROLLBACK TO update_item_PVT;
349: x_return_status := FND_API.G_RET_STS_ERROR ;
350: FND_MSG_PUB.Count_And_Get
351: ( p_count => x_msg_count,
352: p_data => x_msg_data
353: );

Line 354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

350: FND_MSG_PUB.Count_And_Get
351: ( p_count => x_msg_count,
352: p_data => x_msg_data
353: );
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: ROLLBACK TO update_item_PVT;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
357: FND_MSG_PUB.Count_And_Get
358: ( p_count => x_msg_count,

Line 356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

352: p_data => x_msg_data
353: );
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: ROLLBACK TO update_item_PVT;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
357: FND_MSG_PUB.Count_And_Get
358: ( p_count => x_msg_count,
359: p_data => x_msg_data
360: );

Line 363: x_return_status := FND_API.G_RET_STS_ERROR;

359: p_data => x_msg_data
360: );
361: WHEN OTHERS THEN
362: ROLLBACK TO update_item_PVT;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: IF FND_MSG_PUB.Check_Msg_Level
365: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
366: THEN
367: FND_MSG_PUB.Add_Exc_Msg