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_VP_K_ARTICLE_PVT dependencies on OKC_API

Line 6: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

2: /* $Header: OKLRCARB.pls 120.1 2005/08/04 01:31:11 manumanu noship $ */
3: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_K_ARTICLE_PVT';
5: G_CHILD_RECORD_FOUND CONSTANT varchar2(200) := 'OKC_CHILD_RECORD_FOUND';
6: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
7: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
8:
9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';

Line 7: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

3: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_K_ARTICLE_PVT';
5: G_CHILD_RECORD_FOUND CONSTANT varchar2(200) := 'OKC_CHILD_RECORD_FOUND';
6: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
7: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
8:
9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';

Line 12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

8:
9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
13: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
14: G_API_TYPE VARCHAR2(3) := 'PVT';
15: ----------------------------------------------------------------------------
16: --Function to populate the articles record to be copied.

Line 13: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

9: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
11: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
12: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
13: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
14: G_API_TYPE VARCHAR2(3) := 'PVT';
15: ----------------------------------------------------------------------------
16: --Function to populate the articles record to be copied.
17: ----------------------------------------------------------------------------

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

17: ----------------------------------------------------------------------------
18: FUNCTION get_catv_rec(p_cat_id IN NUMBER,
19: x_catv_rec OUT NOCOPY catv_rec_type)
20: RETURN VARCHAR2 IS
21: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
22: l_no_data_found BOOLEAN := TRUE;
23: CURSOR c_catv_rec IS
24: SELECT ID,
25: CHR_ID,

Line 94: l_return_status := OKC_API.G_RET_STS_ERROR;

90: x_catv_rec.CAT_TYPE;
91: l_no_data_found := c_catv_rec%NOTFOUND;
92: CLOSE c_catv_rec;
93: IF l_no_data_found THEN
94: l_return_status := OKC_API.G_RET_STS_ERROR;
95: return(l_return_status);
96: ELSE
97: return(l_return_status);
98: END IF;

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

98: END IF;
99: EXCEPTION
100: WHEN OTHERS THEN
101: -- store SQL error message on message stack for caller
102: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
103: -- notify caller of an UNEXPECTED error
104: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
105: return(l_return_status);
106: END get_catv_rec;

Line 104: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

100: WHEN OTHERS THEN
101: -- store SQL error message on message stack for caller
102: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
103: -- notify caller of an UNEXPECTED error
104: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
105: return(l_return_status);
106: END get_catv_rec;
107: ----------------------------------------------------------------------------
108: --Function to populate the articles record to be copied.

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

110: FUNCTION get_catv_rec(p_sae_id IN NUMBER,
111: p_sav_release IN VARCHAR2,
112: x_catv_rec OUT NOCOPY catv_rec_type)
113: RETURN VARCHAR2 IS
114: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
115: l_no_data_found BOOLEAN := TRUE;
116: CURSOR c_catv_rec IS
117: SELECT null,
118: null,

Line 121: OKC_API.G_TRUE,

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

Line 190: l_return_status := OKC_API.G_RET_STS_ERROR;

186: x_catv_rec.CAT_TYPE;
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: -- notify caller of an UNEXPECTED error
200: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
201: return(l_return_status);
202: END get_catv_rec;

Line 200: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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: -- notify caller of an UNEXPECTED error
200: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
201: return(l_return_status);
202: END get_catv_rec;
203:
204: -- Start of comments

Line 214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

210: -- Version : 1.0
211: -- End of comments
212: PROCEDURE create_article_by_reference(
213: p_api_version IN NUMBER,
214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_sae_id IN NUMBER,

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

234: p_api_version => p_api_version,
235: p_api_type => g_api_type,
236: x_return_status => x_return_status);
237: -- check if activity started successfully
238: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
239: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
240: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
241: raise OKL_API.G_EXCEPTION_ERROR;
242: End If;

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

236: x_return_status => x_return_status);
237: -- check if activity started successfully
238: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
239: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
240: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
241: raise OKL_API.G_EXCEPTION_ERROR;
242: End If;
243:
244: x_return_status := get_catv_rec(p_sae_id => p_sae_id,

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

243:
244: x_return_status := get_catv_rec(p_sae_id => p_sae_id,
245: p_sav_release => p_sae_release,
246: x_catv_rec => l_catv_rec);
247: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
248: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
249: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
250: raise OKC_API.G_EXCEPTION_ERROR;
251: End If;

Line 248: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

244: x_return_status := get_catv_rec(p_sae_id => p_sae_id,
245: p_sav_release => p_sae_release,
246: x_catv_rec => l_catv_rec);
247: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
248: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
249: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
250: raise OKC_API.G_EXCEPTION_ERROR;
251: End If;
252:

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

245: p_sav_release => p_sae_release,
246: x_catv_rec => l_catv_rec);
247: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
248: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
249: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
250: raise OKC_API.G_EXCEPTION_ERROR;
251: End If;
252:
253: l_catv_rec.dnz_chr_id := p_chr_id;

Line 250: raise OKC_API.G_EXCEPTION_ERROR;

246: x_catv_rec => l_catv_rec);
247: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
248: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
249: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
250: raise OKC_API.G_EXCEPTION_ERROR;
251: End If;
252:
253: l_catv_rec.dnz_chr_id := p_chr_id;
254: if (p_cle_id is null) then

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

258: l_catv_rec.chr_id := null;
259: l_catv_rec.cle_id := p_cle_id;
260: end if;
261: l_catv_rec.object_version_number := 1.0;
262: l_catv_rec.sfwt_flag := OKC_API.G_TRUE;
263: l_catv_rec.sav_sae_id := p_sae_id;
264: l_catv_rec.sav_sav_release := p_sae_release;
265: l_catv_rec.cat_type := 'STA';
266: l_catv_rec.fulltext_yn := 'Y';

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

276: x_msg_count => x_msg_count,
277: x_msg_data => x_msg_data,
278: p_catv_rec => l_catv_rec,
279: x_catv_rec => x_catv_rec);
280: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
281: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
282: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
283: raise OKC_API.G_EXCEPTION_ERROR;
284: End If;

Line 281: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

277: x_msg_data => x_msg_data,
278: p_catv_rec => l_catv_rec,
279: x_catv_rec => x_catv_rec);
280: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
281: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
282: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
283: raise OKC_API.G_EXCEPTION_ERROR;
284: End If;
285: -- x_cat_id := x_catv_rec.id;

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

278: p_catv_rec => l_catv_rec,
279: x_catv_rec => x_catv_rec);
280: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
281: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
282: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
283: raise OKC_API.G_EXCEPTION_ERROR;
284: End If;
285: -- x_cat_id := x_catv_rec.id;
286: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 283: raise OKC_API.G_EXCEPTION_ERROR;

279: x_catv_rec => x_catv_rec);
280: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
281: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
282: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
283: raise OKC_API.G_EXCEPTION_ERROR;
284: End If;
285: -- x_cat_id := x_catv_rec.id;
286: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
287: x_msg_data => x_msg_data);

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

289: when OKL_API.G_EXCEPTION_ERROR then
290: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
291: p_api_name => l_api_name,
292: p_pkg_name => g_pkg_name,
293: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
294: x_msg_count => x_msg_count,
295: x_msg_data => x_msg_data,
296: p_api_type => g_api_type);
297: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

Line 297: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

293: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
294: x_msg_count => x_msg_count,
295: x_msg_data => x_msg_data,
296: p_api_type => g_api_type);
297: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
298: x_return_status := OKL_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 301: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

297: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
298: x_return_status := OKL_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: when OTHERS then

Line 326: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

322: -- Version : 1.0
323: -- End of comments
324: PROCEDURE create_article_by_copy(
325: p_api_version IN NUMBER,
326: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
327: x_return_status OUT NOCOPY VARCHAR2,
328: x_msg_count OUT NOCOPY NUMBER,
329: x_msg_data OUT NOCOPY VARCHAR2,
330: p_sae_id IN NUMBER,

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

355: p_api_version => p_api_version,
356: p_api_type => g_api_type,
357: x_return_status => x_return_status);
358: -- check if activity started successfully
359: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
360: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
361: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
362: raise OKL_API.G_EXCEPTION_ERROR;
363: End If;

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

357: x_return_status => x_return_status);
358: -- check if activity started successfully
359: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
360: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
361: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
362: raise OKL_API.G_EXCEPTION_ERROR;
363: End If;
364: x_return_status := get_catv_rec(p_sae_id => p_sae_id,
365: p_sav_release => p_sae_release,

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

363: End If;
364: x_return_status := get_catv_rec(p_sae_id => p_sae_id,
365: p_sav_release => p_sae_release,
366: x_catv_rec => l_catv_rec);
367: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
368: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
369: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
370: raise OKC_API.G_EXCEPTION_ERROR;
371: End If;

Line 368: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

364: x_return_status := get_catv_rec(p_sae_id => p_sae_id,
365: p_sav_release => p_sae_release,
366: x_catv_rec => l_catv_rec);
367: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
368: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
369: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
370: raise OKC_API.G_EXCEPTION_ERROR;
371: End If;
372: l_catv_rec.dnz_chr_id := p_chr_id;

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

365: p_sav_release => p_sae_release,
366: x_catv_rec => l_catv_rec);
367: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
368: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
369: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
370: raise OKC_API.G_EXCEPTION_ERROR;
371: End If;
372: l_catv_rec.dnz_chr_id := p_chr_id;
373: if (p_cle_id is null) then

Line 370: raise OKC_API.G_EXCEPTION_ERROR;

366: x_catv_rec => l_catv_rec);
367: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
368: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
369: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
370: raise OKC_API.G_EXCEPTION_ERROR;
371: End If;
372: l_catv_rec.dnz_chr_id := p_chr_id;
373: if (p_cle_id is null) then
374: l_catv_rec.chr_id := p_chr_id;

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: l_catv_rec.comments := p_comments;
383: l_catv_rec.FULLTEXT_YN := NULL;
384: l_catv_rec.VARIATION_DESCRIPTION := NULL;
385: l_catv_rec.SAV_SAE_ID := NULL;

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

393: x_msg_count => x_msg_count,
394: x_msg_data => x_msg_data,
395: p_catv_rec => l_catv_rec,
396: x_catv_rec => x_catv_rec);
397: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
398: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
399: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
400: raise OKC_API.G_EXCEPTION_ERROR;
401: End If;

Line 398: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

394: x_msg_data => x_msg_data,
395: p_catv_rec => l_catv_rec,
396: x_catv_rec => x_catv_rec);
397: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
398: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
399: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
400: raise OKC_API.G_EXCEPTION_ERROR;
401: End If;
402: -- Begin updating text

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

395: p_catv_rec => l_catv_rec,
396: x_catv_rec => x_catv_rec);
397: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
398: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
399: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
400: raise OKC_API.G_EXCEPTION_ERROR;
401: End If;
402: -- Begin updating text
403: OPEN cur_text;

Line 400: raise OKC_API.G_EXCEPTION_ERROR;

396: x_catv_rec => x_catv_rec);
397: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
398: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
399: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
400: raise OKC_API.G_EXCEPTION_ERROR;
401: End If;
402: -- Begin updating text
403: OPEN cur_text;
404: FETCH cur_text INTO l_clob_text;

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

419: x_return_status := OKC_UTIL.Copy_Articles_Varied_Text(
420: p_article_id => x_catv_rec.id, -- contract article id
421: p_sae_id => p_sae_id, -- standard article id
422: lang => USERENV('LANG'));
423: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
424: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
425: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
426: raise OKC_API.G_EXCEPTION_ERROR;
427: End If;

Line 424: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

420: p_article_id => x_catv_rec.id, -- contract article id
421: p_sae_id => p_sae_id, -- standard article id
422: lang => USERENV('LANG'));
423: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
424: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
425: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
426: raise OKC_API.G_EXCEPTION_ERROR;
427: End If;
428:

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

421: p_sae_id => p_sae_id, -- standard article id
422: lang => USERENV('LANG'));
423: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
424: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
425: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
426: raise OKC_API.G_EXCEPTION_ERROR;
427: End If;
428:
429: -- END FIX 3254597 --

Line 426: raise OKC_API.G_EXCEPTION_ERROR;

422: lang => USERENV('LANG'));
423: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
424: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
425: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
426: raise OKC_API.G_EXCEPTION_ERROR;
427: End If;
428:
429: -- END FIX 3254597 --
430:

Line 435: when OKC_API.G_EXCEPTION_ERROR then

431: -- x_cat_id := x_catv_rec.id;
432: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
433: x_msg_data => x_msg_data);
434: EXCEPTION
435: when OKC_API.G_EXCEPTION_ERROR then
436: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
437: p_api_name => l_api_name,
438: p_pkg_name => g_pkg_name,
439: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 436: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

432: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
433: x_msg_data => x_msg_data);
434: EXCEPTION
435: when OKC_API.G_EXCEPTION_ERROR then
436: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
437: p_api_name => l_api_name,
438: p_pkg_name => g_pkg_name,
439: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
440: x_msg_count => x_msg_count,

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

435: when OKC_API.G_EXCEPTION_ERROR then
436: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
437: p_api_name => l_api_name,
438: p_pkg_name => g_pkg_name,
439: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
440: x_msg_count => x_msg_count,
441: x_msg_data => x_msg_data,
442: p_api_type => g_api_type);
443: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

Line 443: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

439: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
440: x_msg_count => x_msg_count,
441: x_msg_data => x_msg_data,
442: p_api_type => g_api_type);
443: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
444: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
445: p_api_name => l_api_name,
446: p_pkg_name => g_pkg_name,
447: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 444: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

440: x_msg_count => x_msg_count,
441: x_msg_data => x_msg_data,
442: p_api_type => g_api_type);
443: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
444: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
445: p_api_name => l_api_name,
446: p_pkg_name => g_pkg_name,
447: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
448: x_msg_count => x_msg_count,

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

443: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
444: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
445: p_api_name => l_api_name,
446: p_pkg_name => g_pkg_name,
447: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
448: x_msg_count => x_msg_count,
449: x_msg_data => x_msg_data,
450: p_api_type => g_api_type);
451: when OTHERS then

Line 452: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

448: x_msg_count => x_msg_count,
449: x_msg_data => x_msg_data,
450: p_api_type => g_api_type);
451: when OTHERS then
452: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
453: p_api_name => l_api_name,
454: p_pkg_name => g_pkg_name,
455: p_exc_name => 'OTHERS',
456: x_msg_count => x_msg_count,

Line 486: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

482: -- Parameters :
483: -- Version : 1.0
484: -- End of comments
485: procedure create_k_article(p_api_version IN NUMBER,
486: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
487: x_return_status OUT NOCOPY VARCHAR2,
488: x_msg_count OUT NOCOPY NUMBER,
489: x_msg_data OUT NOCOPY VARCHAR2,
490: p_catv_rec IN catv_rec_type,

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

505: p_api_version => p_api_version,
506: p_api_type => g_api_type,
507: x_return_status => x_return_status);
508: -- check if activity started successfully
509: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
510: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
512: raise OKL_API.G_EXCEPTION_ERROR;
513: End If;

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

507: x_return_status => x_return_status);
508: -- check if activity started successfully
509: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
510: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
512: raise OKL_API.G_EXCEPTION_ERROR;
513: End If;
514:
515: -- Not null Validation for Article Name

Line 606: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

602: -- Parameters :
603: -- Version : 1.0
604: -- End of comments
605: procedure update_k_article(p_api_version IN NUMBER,
606: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
607: x_return_status OUT NOCOPY VARCHAR2,
608: x_msg_count OUT NOCOPY NUMBER,
609: x_msg_data OUT NOCOPY VARCHAR2,
610: p_catv_rec IN catv_rec_type,

Line 657: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

653: -- Parameters :
654: -- Version : 1.0
655: -- End of comments
656: procedure delete_k_article(p_api_version IN NUMBER,
657: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
658: x_return_status OUT NOCOPY VARCHAR2,
659: x_msg_count OUT NOCOPY NUMBER,
660: x_msg_data OUT NOCOPY VARCHAR2,
661: p_catv_rec IN catv_rec_type) is

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

658: x_return_status OUT NOCOPY VARCHAR2,
659: x_msg_count OUT NOCOPY NUMBER,
660: x_msg_data OUT NOCOPY VARCHAR2,
661: p_catv_rec IN catv_rec_type) is
662: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
663: l_chr_id OKL_VP_ASSOCIATIONS.CHR_ID%TYPE;
664:
665:
666: CURSOR cur_get_chr_id IS