11: ----------------------------------------------------------------------------
12: FUNCTION get_catv_rec(p_cat_id IN NUMBER,
13: x_catv_rec OUT NOCOPY okc_k_article_pub.catv_rec_type)
14: RETURN VARCHAR2 IS
15: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
16: l_no_data_found BOOLEAN := TRUE;
17:
18: CURSOR c_catv_rec IS
19: SELECT ID,
86:
87: l_no_data_found := c_catv_rec%NOTFOUND;
88: CLOSE c_catv_rec;
89: IF l_no_data_found THEN
90: l_return_status := OKC_API.G_RET_STS_ERROR;
91: return(l_return_status);
92: ELSE
93: return(l_return_status);
94: END IF;
94: END IF;
95: EXCEPTION
96: WHEN OTHERS THEN
97: -- store SQL error message on message stack for caller
98: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
99: -- notify caller of an UNEXPECTED error
100: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
101: return(l_return_status);
102:
96: WHEN OTHERS THEN
97: -- store SQL error message on message stack for caller
98: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
99: -- notify caller of an UNEXPECTED error
100: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
101: return(l_return_status);
102:
103: END get_catv_rec;
104:
108: FUNCTION get_catv_rec(p_sae_id IN NUMBER,
109: p_sav_release IN VARCHAR2,
110: x_catv_rec OUT NOCOPY okc_k_article_pub.catv_rec_type)
111: RETURN VARCHAR2 IS
112: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
113: l_no_data_found BOOLEAN := TRUE;
114:
115: CURSOR c_catv_rec IS
116: SELECT null,
116: SELECT null,
117: null,
118: null,
119: null,
120: OKC_API.G_TRUE,
121: null,
122: null,
123: sae.SBT_CODE,
124: null,
186:
187: l_no_data_found := c_catv_rec%NOTFOUND;
188: CLOSE c_catv_rec;
189: IF l_no_data_found THEN
190: l_return_status := OKC_API.G_RET_STS_ERROR;
191: return(l_return_status);
192: ELSE
193: return(l_return_status);
194: END IF;
194: END IF;
195: EXCEPTION
196: WHEN OTHERS THEN
197: -- store SQL error message on message stack for caller
198: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
199:
200: -- notify caller of an UNEXPECTED error
201: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
202: return(l_return_status);
197: -- store SQL error message on message stack for caller
198: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
199:
200: -- notify caller of an UNEXPECTED error
201: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
202: return(l_return_status);
203:
204: END get_catv_rec;
205:
213: -- Version : 1.0
214: -- End of comments
215: PROCEDURE reference_article(
216: p_api_version IN NUMBER,
217: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_sae_id IN NUMBER,
232: x_catv_rec OKC_K_ARTICLE_PUB.catv_rec_type;
233:
234: BEGIN
235:
236: x_return_status := OKC_API.START_ACTIVITY(
237: p_api_name => l_api_name,
238: p_pkg_name => g_pkg_name,
239: p_init_msg_list => p_init_msg_list,
240: l_api_version => l_api_version,
242: p_api_type => g_api_type,
243: x_return_status => x_return_status);
244:
245: -- check if activity started successfully
246: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
247: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
248: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
249: raise OKC_API.G_EXCEPTION_ERROR;
250: End If;
243: x_return_status => x_return_status);
244:
245: -- check if activity started successfully
246: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
247: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
248: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
249: raise OKC_API.G_EXCEPTION_ERROR;
250: End If;
251:
244:
245: -- check if activity started successfully
246: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
247: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
248: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
249: raise OKC_API.G_EXCEPTION_ERROR;
250: End If;
251:
252: l_catv_rec.dnz_chr_id := p_chr_id;
245: -- check if activity started successfully
246: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
247: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
248: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
249: raise OKC_API.G_EXCEPTION_ERROR;
250: End If;
251:
252: l_catv_rec.dnz_chr_id := p_chr_id;
253: if (p_cle_id is null) then
257: l_catv_rec.chr_id := null;
258: l_catv_rec.cle_id := p_cle_id;
259: end if;
260: l_catv_rec.object_version_number := 1.0;
261: l_catv_rec.sfwt_flag := OKC_API.G_TRUE;
262: l_catv_rec.sav_sae_id := p_sae_id;
263: l_catv_rec.sav_sav_release := p_sae_release;
264: l_catv_rec.cat_type := 'STA';
265: l_catv_rec.fulltext_yn := 'Y';
273: x_msg_data => x_msg_data,
274: p_catv_rec => l_catv_rec,
275: x_catv_rec => x_catv_rec);
276:
277: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
278: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
279: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
280: raise OKC_API.G_EXCEPTION_ERROR;
281: End If;
274: p_catv_rec => l_catv_rec,
275: x_catv_rec => x_catv_rec);
276:
277: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
278: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
279: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
280: raise OKC_API.G_EXCEPTION_ERROR;
281: End If;
282:
275: x_catv_rec => x_catv_rec);
276:
277: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
278: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
279: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
280: raise OKC_API.G_EXCEPTION_ERROR;
281: End If;
282:
283: x_cat_id := x_catv_rec.id;
276:
277: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
278: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
279: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
280: raise OKC_API.G_EXCEPTION_ERROR;
281: End If;
282:
283: x_cat_id := x_catv_rec.id;
284:
281: End If;
282:
283: x_cat_id := x_catv_rec.id;
284:
285: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
286: x_msg_data => x_msg_data);
287: EXCEPTION
288: when OKC_API.G_EXCEPTION_ERROR then
289: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
284:
285: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
286: x_msg_data => x_msg_data);
287: EXCEPTION
288: when OKC_API.G_EXCEPTION_ERROR then
289: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
290: p_api_name => l_api_name,
291: p_pkg_name => g_pkg_name,
292: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
285: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
286: x_msg_data => x_msg_data);
287: EXCEPTION
288: when OKC_API.G_EXCEPTION_ERROR then
289: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
290: p_api_name => l_api_name,
291: p_pkg_name => g_pkg_name,
292: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
293: x_msg_count => x_msg_count,
288: when OKC_API.G_EXCEPTION_ERROR then
289: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
290: p_api_name => l_api_name,
291: p_pkg_name => g_pkg_name,
292: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
293: x_msg_count => x_msg_count,
294: x_msg_data => x_msg_data,
295: p_api_type => g_api_type);
296:
293: x_msg_count => x_msg_count,
294: x_msg_data => x_msg_data,
295: p_api_type => g_api_type);
296:
297: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
298: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
299: p_api_name => l_api_name,
300: p_pkg_name => g_pkg_name,
301: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
294: x_msg_data => x_msg_data,
295: p_api_type => g_api_type);
296:
297: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
298: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
299: p_api_name => l_api_name,
300: p_pkg_name => g_pkg_name,
301: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
302: x_msg_count => x_msg_count,
297: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
298: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
299: p_api_name => l_api_name,
300: p_pkg_name => g_pkg_name,
301: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
302: x_msg_count => x_msg_count,
303: x_msg_data => x_msg_data,
304: p_api_type => g_api_type);
305:
303: x_msg_data => x_msg_data,
304: p_api_type => g_api_type);
305:
306: when OTHERS then
307: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
308: p_api_name => l_api_name,
309: p_pkg_name => g_pkg_name,
310: p_exc_name => 'OTHERS',
311: x_msg_count => x_msg_count,
323: -- Version : 1.0
324: -- End of comments
325: PROCEDURE copy_article(
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
328: x_return_status OUT NOCOPY VARCHAR2,
329: x_msg_count OUT NOCOPY NUMBER,
330: x_msg_data OUT NOCOPY VARCHAR2,
331: p_sae_id IN NUMBER,
342: x_catv_rec OKC_K_ARTICLE_PUB.catv_rec_type;
343:
344: BEGIN
345:
346: x_return_status := OKC_API.START_ACTIVITY(
347: p_api_name => l_api_name,
348: p_pkg_name => g_pkg_name,
349: p_init_msg_list => p_init_msg_list,
350: l_api_version => l_api_version,
352: p_api_type => g_api_type,
353: x_return_status => x_return_status);
354:
355: -- check if activity started successfully
356: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
357: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
359: raise OKC_API.G_EXCEPTION_ERROR;
360: End If;
353: x_return_status => x_return_status);
354:
355: -- check if activity started successfully
356: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
357: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
359: raise OKC_API.G_EXCEPTION_ERROR;
360: End If;
361:
354:
355: -- check if activity started successfully
356: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
357: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
359: raise OKC_API.G_EXCEPTION_ERROR;
360: End If;
361:
362: x_return_status := get_catv_rec(p_sae_id => p_sae_id,
355: -- check if activity started successfully
356: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
357: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
359: raise OKC_API.G_EXCEPTION_ERROR;
360: End If;
361:
362: x_return_status := get_catv_rec(p_sae_id => p_sae_id,
363: p_sav_release => p_sae_release,
362: x_return_status := get_catv_rec(p_sae_id => p_sae_id,
363: p_sav_release => p_sae_release,
364: x_catv_rec => l_catv_rec);
365:
366: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
367: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
368: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
369: raise OKC_API.G_EXCEPTION_ERROR;
370: End If;
363: p_sav_release => p_sae_release,
364: x_catv_rec => l_catv_rec);
365:
366: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
367: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
368: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
369: raise OKC_API.G_EXCEPTION_ERROR;
370: End If;
371:
364: x_catv_rec => l_catv_rec);
365:
366: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
367: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
368: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
369: raise OKC_API.G_EXCEPTION_ERROR;
370: End If;
371:
372: l_catv_rec.dnz_chr_id := p_chr_id;
365:
366: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
367: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
368: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
369: raise OKC_API.G_EXCEPTION_ERROR;
370: End If;
371:
372: l_catv_rec.dnz_chr_id := p_chr_id;
373: if (p_cle_id is null) then
377: l_catv_rec.chr_id := null;
378: l_catv_rec.cle_id := p_cle_id;
379: end if;
380: l_catv_rec.object_version_number := 1.0;
381: l_catv_rec.sfwt_flag := OKC_API.G_TRUE;
382:
383: OKC_K_ARTICLE_PUB.create_k_article(
384: p_api_version => l_api_version,
385: p_init_msg_list => p_init_msg_list,
388: x_msg_data => x_msg_data,
389: p_catv_rec => l_catv_rec,
390: x_catv_rec => x_catv_rec);
391:
392: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
393: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
394: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
395: raise OKC_API.G_EXCEPTION_ERROR;
396: End If;
389: p_catv_rec => l_catv_rec,
390: x_catv_rec => x_catv_rec);
391:
392: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
393: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
394: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
395: raise OKC_API.G_EXCEPTION_ERROR;
396: End If;
397:
390: x_catv_rec => x_catv_rec);
391:
392: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
393: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
394: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
395: raise OKC_API.G_EXCEPTION_ERROR;
396: End If;
397:
398: x_cat_id := x_catv_rec.id;
391:
392: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
393: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
394: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
395: raise OKC_API.G_EXCEPTION_ERROR;
396: End If;
397:
398: x_cat_id := x_catv_rec.id;
399:
396: End If;
397:
398: x_cat_id := x_catv_rec.id;
399:
400: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
401: x_msg_data => x_msg_data);
402: EXCEPTION
403: when OKC_API.G_EXCEPTION_ERROR then
404: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
399:
400: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
401: x_msg_data => x_msg_data);
402: EXCEPTION
403: when OKC_API.G_EXCEPTION_ERROR then
404: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
405: p_api_name => l_api_name,
406: p_pkg_name => g_pkg_name,
407: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
400: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
401: x_msg_data => x_msg_data);
402: EXCEPTION
403: when OKC_API.G_EXCEPTION_ERROR then
404: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
405: p_api_name => l_api_name,
406: p_pkg_name => g_pkg_name,
407: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
408: x_msg_count => x_msg_count,
403: when OKC_API.G_EXCEPTION_ERROR then
404: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
405: p_api_name => l_api_name,
406: p_pkg_name => g_pkg_name,
407: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
408: x_msg_count => x_msg_count,
409: x_msg_data => x_msg_data,
410: p_api_type => g_api_type);
411:
408: x_msg_count => x_msg_count,
409: x_msg_data => x_msg_data,
410: p_api_type => g_api_type);
411:
412: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
413: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
414: p_api_name => l_api_name,
415: p_pkg_name => g_pkg_name,
416: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
409: x_msg_data => x_msg_data,
410: p_api_type => g_api_type);
411:
412: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
413: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
414: p_api_name => l_api_name,
415: p_pkg_name => g_pkg_name,
416: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
417: x_msg_count => x_msg_count,
412: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
413: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
414: p_api_name => l_api_name,
415: p_pkg_name => g_pkg_name,
416: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
417: x_msg_count => x_msg_count,
418: x_msg_data => x_msg_data,
419: p_api_type => g_api_type);
420:
418: x_msg_data => x_msg_data,
419: p_api_type => g_api_type);
420:
421: when OTHERS then
422: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
423: p_api_name => l_api_name,
424: p_pkg_name => g_pkg_name,
425: p_exc_name => 'OTHERS',
426: x_msg_count => x_msg_count,
438: -- Version : 1.0
439: -- End of comments
440: PROCEDURE delete_article(
441: p_api_version IN NUMBER,
442: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
443: x_return_status OUT NOCOPY VARCHAR2,
444: x_msg_count OUT NOCOPY NUMBER,
445: x_msg_data OUT NOCOPY VARCHAR2,
446: p_cat_id IN NUMBER
452: l_catv_rec OKC_K_ARTICLE_PUB.catv_rec_type;
453:
454: BEGIN
455:
456: x_return_status := OKC_API.START_ACTIVITY(
457: p_api_name => l_api_name,
458: p_pkg_name => g_pkg_name,
459: p_init_msg_list => p_init_msg_list,
460: l_api_version => l_api_version,
462: p_api_type => g_api_type,
463: x_return_status => x_return_status);
464:
465: -- check if activity started successfully
466: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
467: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
468: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
469: raise OKC_API.G_EXCEPTION_ERROR;
470: End If;
463: x_return_status => x_return_status);
464:
465: -- check if activity started successfully
466: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
467: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
468: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
469: raise OKC_API.G_EXCEPTION_ERROR;
470: End If;
471:
464:
465: -- check if activity started successfully
466: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
467: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
468: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
469: raise OKC_API.G_EXCEPTION_ERROR;
470: End If;
471:
472: x_return_status := get_catv_rec(p_cat_id => p_cat_id,
465: -- check if activity started successfully
466: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
467: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
468: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
469: raise OKC_API.G_EXCEPTION_ERROR;
470: End If;
471:
472: x_return_status := get_catv_rec(p_cat_id => p_cat_id,
473: x_catv_rec => l_catv_rec);
471:
472: x_return_status := get_catv_rec(p_cat_id => p_cat_id,
473: x_catv_rec => l_catv_rec);
474:
475: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
476: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
477: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
478: raise OKC_API.G_EXCEPTION_ERROR;
479: End If;
472: x_return_status := get_catv_rec(p_cat_id => p_cat_id,
473: x_catv_rec => l_catv_rec);
474:
475: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
476: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
477: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
478: raise OKC_API.G_EXCEPTION_ERROR;
479: End If;
480:
473: x_catv_rec => l_catv_rec);
474:
475: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
476: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
477: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
478: raise OKC_API.G_EXCEPTION_ERROR;
479: End If;
480:
481: OKC_K_ARTICLE_PUB.delete_k_article(
474:
475: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
476: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
477: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
478: raise OKC_API.G_EXCEPTION_ERROR;
479: End If;
480:
481: OKC_K_ARTICLE_PUB.delete_k_article(
482: p_api_version => l_api_version,
485: x_msg_count => x_msg_count,
486: x_msg_data => x_msg_data,
487: p_catv_rec => l_catv_rec);
488:
489: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
490: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
492: raise OKC_API.G_EXCEPTION_ERROR;
493: End If;
486: x_msg_data => x_msg_data,
487: p_catv_rec => l_catv_rec);
488:
489: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
490: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
492: raise OKC_API.G_EXCEPTION_ERROR;
493: End If;
494:
487: p_catv_rec => l_catv_rec);
488:
489: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
490: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
492: raise OKC_API.G_EXCEPTION_ERROR;
493: End If;
494:
495: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
488:
489: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
490: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
491: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
492: raise OKC_API.G_EXCEPTION_ERROR;
493: End If;
494:
495: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
496: x_msg_data => x_msg_data);
491: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
492: raise OKC_API.G_EXCEPTION_ERROR;
493: End If;
494:
495: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
496: x_msg_data => x_msg_data);
497: EXCEPTION
498: when OKC_API.G_EXCEPTION_ERROR then
499: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
494:
495: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
496: x_msg_data => x_msg_data);
497: EXCEPTION
498: when OKC_API.G_EXCEPTION_ERROR then
499: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
500: p_api_name => l_api_name,
501: p_pkg_name => g_pkg_name,
502: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
495: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
496: x_msg_data => x_msg_data);
497: EXCEPTION
498: when OKC_API.G_EXCEPTION_ERROR then
499: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
500: p_api_name => l_api_name,
501: p_pkg_name => g_pkg_name,
502: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
503: x_msg_count => x_msg_count,
498: when OKC_API.G_EXCEPTION_ERROR then
499: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
500: p_api_name => l_api_name,
501: p_pkg_name => g_pkg_name,
502: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
503: x_msg_count => x_msg_count,
504: x_msg_data => x_msg_data,
505: p_api_type => g_api_type);
506:
503: x_msg_count => x_msg_count,
504: x_msg_data => x_msg_data,
505: p_api_type => g_api_type);
506:
507: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
508: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
509: p_api_name => l_api_name,
510: p_pkg_name => g_pkg_name,
511: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
504: x_msg_data => x_msg_data,
505: p_api_type => g_api_type);
506:
507: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
508: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
509: p_api_name => l_api_name,
510: p_pkg_name => g_pkg_name,
511: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
512: x_msg_count => x_msg_count,
507: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
508: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
509: p_api_name => l_api_name,
510: p_pkg_name => g_pkg_name,
511: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
512: x_msg_count => x_msg_count,
513: x_msg_data => x_msg_data,
514: p_api_type => g_api_type);
515:
513: x_msg_data => x_msg_data,
514: p_api_type => g_api_type);
515:
516: when OTHERS then
517: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
518: p_api_name => l_api_name,
519: p_pkg_name => g_pkg_name,
520: p_exc_name => 'OTHERS',
521: x_msg_count => x_msg_count,