301: raise FND_API.G_EXC_UNEXPECTED_ERROR;
302: end if;
303:
304: if FND_API.to_Boolean(p_init_msg_list) then
305: FND_MSG_PUB.initialize;
306: end if;
307:
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309: -- -- -- -- begin my code -- -- -- -- --
316: x_total_row_cnt_tbl :=cs_kb_number_tbl_type();
317:
318:
319: if(p_repository_tbl is null) then
320: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
321: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
322: fnd_msg_pub.Add;
323: end if;
324: raise FND_API.G_EXC_ERROR;
318:
319: if(p_repository_tbl is null) then
320: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
321: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
322: fnd_msg_pub.Add;
323: end if;
324: raise FND_API.G_EXC_ERROR;
325: end if;
326:
364: end loop;
365: -- -- -- -- end of code -- -- -- --
366:
367: -- Standard call to get message count. if count=1, get message info.
368: FND_MSG_PUB.Count_And_Get(
369: p_count => x_msg_count,
370: p_data => x_msg_data );
371:
372: EXCEPTION
372: EXCEPTION
373: WHEN FND_API.G_EXC_ERROR THEN
374: ROLLBACK TO Specific_Search_GRP;
375: x_return_status := FND_API.G_RET_STS_ERROR ;
376: FND_MSG_PUB.Count_And_Get(
377: p_count => x_msg_count,
378: p_data => x_msg_data );
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO Specific_Search_GRP;
378: p_data => x_msg_data );
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO Specific_Search_GRP;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382: FND_MSG_PUB.Count_And_Get(
383: p_count => x_msg_count,
384: p_data => x_msg_data);
385:
386: WHEN OTHERS THEN
385:
386: WHEN OTHERS THEN
387: ROLLBACK TO Specific_Search_GRP;
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: IF FND_MSG_PUB.Check_Msg_Level
390: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
391: FND_MSG_PUB.Add_Exc_Msg(
392: G_PKG_NAME,
393: l_api_name);
386: WHEN OTHERS THEN
387: ROLLBACK TO Specific_Search_GRP;
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: IF FND_MSG_PUB.Check_Msg_Level
390: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
391: FND_MSG_PUB.Add_Exc_Msg(
392: G_PKG_NAME,
393: l_api_name);
394: END IF;
387: ROLLBACK TO Specific_Search_GRP;
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: IF FND_MSG_PUB.Check_Msg_Level
390: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
391: FND_MSG_PUB.Add_Exc_Msg(
392: G_PKG_NAME,
393: l_api_name);
394: END IF;
395: FND_MSG_PUB.Count_And_Get(
391: FND_MSG_PUB.Add_Exc_Msg(
392: G_PKG_NAME,
393: l_api_name);
394: END IF;
395: FND_MSG_PUB.Count_And_Get(
396: p_count => x_msg_count,
397: p_data => x_msg_data);
398:
399: