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.OKL_ARTICLE_PUB dependencies on OKC_API

Line 15: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

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,

Line 90: l_return_status := OKC_API.G_RET_STS_ERROR;

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;

Line 98: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

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:

Line 100: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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:

Line 112: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

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,

Line 120: OKC_API.G_TRUE,

116: SELECT null,
117: null,
118: null,
119: null,
120: OKC_API.G_TRUE,
121: null,
122: null,
123: sae.SBT_CODE,
124: null,

Line 190: l_return_status := OKC_API.G_RET_STS_ERROR;

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;

Line 198: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

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

Line 201: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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:

Line 217: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 236: x_return_status := OKC_API.START_ACTIVITY(

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,

Line 246: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 247: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 248: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

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;

Line 249: raise OKC_API.G_EXCEPTION_ERROR;

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

Line 261: l_catv_rec.sfwt_flag := OKC_API.G_TRUE;

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

Line 277: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 278: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 279: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

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;

Line 280: raise OKC_API.G_EXCEPTION_ERROR;

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:

Line 285: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

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(

Line 288: when OKC_API.G_EXCEPTION_ERROR then

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',

Line 289: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 292: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

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:

Line 297: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 298: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 301: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

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:

Line 307: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 327: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 346: x_return_status := OKC_API.START_ACTIVITY(

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,

Line 356: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 357: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 358: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

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,

Line 359: raise OKC_API.G_EXCEPTION_ERROR;

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,

Line 366: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 367: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 368: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

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;

Line 369: raise OKC_API.G_EXCEPTION_ERROR;

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

Line 381: l_catv_rec.sfwt_flag := OKC_API.G_TRUE;

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,

Line 392: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 393: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 394: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

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;

Line 395: raise OKC_API.G_EXCEPTION_ERROR;

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:

Line 400: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

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(

Line 403: when OKC_API.G_EXCEPTION_ERROR then

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',

Line 404: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 407: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

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:

Line 412: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 413: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 416: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

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:

Line 422: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 442: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 456: x_return_status := OKC_API.START_ACTIVITY(

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,

Line 466: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 467: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 468: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

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,

Line 469: raise OKC_API.G_EXCEPTION_ERROR;

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

Line 475: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 476: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 477: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

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(

Line 478: raise OKC_API.G_EXCEPTION_ERROR;

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,

Line 489: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

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;

Line 490: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

Line 491: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

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,

Line 492: raise OKC_API.G_EXCEPTION_ERROR;

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

Line 495: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

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(

Line 498: when OKC_API.G_EXCEPTION_ERROR then

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',

Line 499: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 502: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

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:

Line 507: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 508: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 511: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

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:

Line 517: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,