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

Line 3: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

1: Package Body OKL_VP_K_ARTICLE_PUB AS
2: /* $Header: OKLPCARB.pls 120.1 2005/08/04 01:29:42 manumanu noship $ */
3: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_K_ARTICLE_PUB';
5: G_API_VERSION CONSTANT NUMBER := 1;
6: G_SCOPE CONSTANT varchar2(4) := '_PUB';
7:

Line 44: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

40: -- Parameters :
41: -- Version : 1.0
42: -- End of comments
43: procedure create_k_article(p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2,
48: p_catv_rec IN catv_rec_type,

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

47: x_msg_data OUT NOCOPY VARCHAR2,
48: p_catv_rec IN catv_rec_type,
49: x_catv_rec OUT NOCOPY catv_rec_type) is
50: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_K_ARTICLE';
51: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
52: l_clob clob;
53: begin
54: /* l_return_status := OKL_API.START_ACTIVITY(substr(l_api_name,1,26),
55: G_PKG_NAME,

Line 61: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

57: G_API_VERSION,
58: p_api_version,
59: G_SCOPE,
60: x_return_status);
61: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
62: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
63: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
64: RAISE OKC_API.G_EXCEPTION_ERROR;
65: END IF;*/

Line 62: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

58: p_api_version,
59: G_SCOPE,
60: x_return_status);
61: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
62: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
63: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
64: RAISE OKC_API.G_EXCEPTION_ERROR;
65: END IF;*/
66: g_catv_rec := p_catv_rec;

Line 63: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

59: G_SCOPE,
60: x_return_status);
61: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
62: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
63: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
64: RAISE OKC_API.G_EXCEPTION_ERROR;
65: END IF;*/
66: g_catv_rec := p_catv_rec;
67: --

Line 64: RAISE OKC_API.G_EXCEPTION_ERROR;

60: x_return_status);
61: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
62: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
63: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
64: RAISE OKC_API.G_EXCEPTION_ERROR;
65: END IF;*/
66: g_catv_rec := p_catv_rec;
67: --
68: -- code for temporary clob ... start

Line 89: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

85: --
86: -- Call Before Logic Hook
87: --
88: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
89: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
90: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
91: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
92: raise OKC_API.G_EXCEPTION_ERROR;
93: END IF;

Line 90: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

86: -- Call Before Logic Hook
87: --
88: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
89: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
90: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
91: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
92: raise OKC_API.G_EXCEPTION_ERROR;
93: END IF;
94: reset(p_catv_rec);

Line 91: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

87: --
88: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
89: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
90: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
91: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
92: raise OKC_API.G_EXCEPTION_ERROR;
93: END IF;
94: reset(p_catv_rec);
95: OKL_VP_K_ARTICLE_PVT.create_k_article

Line 92: raise OKC_API.G_EXCEPTION_ERROR;

88: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
89: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
90: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
91: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
92: raise OKC_API.G_EXCEPTION_ERROR;
93: END IF;
94: reset(p_catv_rec);
95: OKL_VP_K_ARTICLE_PVT.create_k_article
96: (

Line 98: p_init_msg_list => OKC_API.G_FALSE,

94: reset(p_catv_rec);
95: OKL_VP_K_ARTICLE_PVT.create_k_article
96: (
97: p_api_version => p_api_version,
98: p_init_msg_list => OKC_API.G_FALSE,
99: x_return_status => x_return_status,
100: x_msg_count => x_msg_count,
101: x_msg_data => x_msg_data,
102: p_catv_rec => g_catv_rec,

Line 105: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

101: x_msg_data => x_msg_data,
102: p_catv_rec => g_catv_rec,
103: x_catv_rec => x_catv_rec
104: );
105: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
108: RAISE OKC_API.G_EXCEPTION_ERROR;
109: END IF;

Line 106: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

102: p_catv_rec => g_catv_rec,
103: x_catv_rec => x_catv_rec
104: );
105: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
108: RAISE OKC_API.G_EXCEPTION_ERROR;
109: END IF;
110: --

Line 107: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

103: x_catv_rec => x_catv_rec
104: );
105: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
108: RAISE OKC_API.G_EXCEPTION_ERROR;
109: END IF;
110: --
111: -- Call After Logic Hook

Line 108: RAISE OKC_API.G_EXCEPTION_ERROR;

104: );
105: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
108: RAISE OKC_API.G_EXCEPTION_ERROR;
109: END IF;
110: --
111: -- Call After Logic Hook
112: --

Line 115: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

111: -- Call After Logic Hook
112: --
113: g_catv_rec := x_catv_rec;
114: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
115: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
116: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
117: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
118: raise OKC_API.G_EXCEPTION_ERROR;
119: END IF;

Line 116: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

112: --
113: g_catv_rec := x_catv_rec;
114: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
115: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
116: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
117: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
118: raise OKC_API.G_EXCEPTION_ERROR;
119: END IF;
120: /* OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);*/

Line 117: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

113: g_catv_rec := x_catv_rec;
114: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
115: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
116: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
117: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
118: raise OKC_API.G_EXCEPTION_ERROR;
119: END IF;
120: /* OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);*/
121: EXCEPTION

Line 118: raise OKC_API.G_EXCEPTION_ERROR;

114: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
115: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
116: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
117: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
118: raise OKC_API.G_EXCEPTION_ERROR;
119: END IF;
120: /* OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);*/
121: EXCEPTION
122: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 122: WHEN OKC_API.G_EXCEPTION_ERROR THEN

118: raise OKC_API.G_EXCEPTION_ERROR;
119: END IF;
120: /* OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);*/
121: EXCEPTION
122: WHEN OKC_API.G_EXCEPTION_ERROR THEN
123: x_return_status := OKC_API.HANDLE_EXCEPTIONS
124: (substr(l_api_name,1,26),
125: G_PKG_NAME,
126: 'OKC_API.G_RET_STS_ERROR',

Line 123: x_return_status := OKC_API.HANDLE_EXCEPTIONS

119: END IF;
120: /* OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);*/
121: EXCEPTION
122: WHEN OKC_API.G_EXCEPTION_ERROR THEN
123: x_return_status := OKC_API.HANDLE_EXCEPTIONS
124: (substr(l_api_name,1,26),
125: G_PKG_NAME,
126: 'OKC_API.G_RET_STS_ERROR',
127: x_msg_count,

Line 126: 'OKC_API.G_RET_STS_ERROR',

122: WHEN OKC_API.G_EXCEPTION_ERROR THEN
123: x_return_status := OKC_API.HANDLE_EXCEPTIONS
124: (substr(l_api_name,1,26),
125: G_PKG_NAME,
126: 'OKC_API.G_RET_STS_ERROR',
127: x_msg_count,
128: x_msg_data,
129: G_SCOPE);
130: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 130: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

126: 'OKC_API.G_RET_STS_ERROR',
127: x_msg_count,
128: x_msg_data,
129: G_SCOPE);
130: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
131: x_return_status := OKC_API.HANDLE_EXCEPTIONS
132: (substr(l_api_name,1,26),
133: G_PKG_NAME,
134: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 131: x_return_status := OKC_API.HANDLE_EXCEPTIONS

127: x_msg_count,
128: x_msg_data,
129: G_SCOPE);
130: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
131: x_return_status := OKC_API.HANDLE_EXCEPTIONS
132: (substr(l_api_name,1,26),
133: G_PKG_NAME,
134: 'OKC_API.G_RET_STS_UNEXP_ERROR',
135: x_msg_count,

Line 134: 'OKC_API.G_RET_STS_UNEXP_ERROR',

130: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
131: x_return_status := OKC_API.HANDLE_EXCEPTIONS
132: (substr(l_api_name,1,26),
133: G_PKG_NAME,
134: 'OKC_API.G_RET_STS_UNEXP_ERROR',
135: x_msg_count,
136: x_msg_data,
137: G_SCOPE);
138: WHEN OTHERS THEN

Line 139: x_return_status := OKC_API.HANDLE_EXCEPTIONS

135: x_msg_count,
136: x_msg_data,
137: G_SCOPE);
138: WHEN OTHERS THEN
139: x_return_status := OKC_API.HANDLE_EXCEPTIONS
140: (substr(l_api_name,1,26),
141: G_PKG_NAME,
142: 'OTHERS',
143: x_msg_count,

Line 156: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

152: -- Parameters :
153: -- Version : 1.0
154: -- End of comments
155: procedure create_k_article(p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2,
160: p_catv_tbl IN catv_tbl_type,

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

160: p_catv_tbl IN catv_tbl_type,
161: x_catv_tbl OUT NOCOPY catv_tbl_type) is
162: c NUMBER;
163: i NUMBER;
164: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
165: BEGIN
166: OKC_API.init_msg_list(p_init_msg_list);
167: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
168: c:=p_catv_tbl.COUNT;

Line 166: OKC_API.init_msg_list(p_init_msg_list);

162: c NUMBER;
163: i NUMBER;
164: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
165: BEGIN
166: OKC_API.init_msg_list(p_init_msg_list);
167: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
168: c:=p_catv_tbl.COUNT;
169: if (c>0) then
170: i := p_catv_tbl.FIRST;

Line 167: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

163: i NUMBER;
164: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
165: BEGIN
166: OKC_API.init_msg_list(p_init_msg_list);
167: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
168: c:=p_catv_tbl.COUNT;
169: if (c>0) then
170: i := p_catv_tbl.FIRST;
171: LOOP

Line 175: p_init_msg_list => OKC_API.G_FALSE,

171: LOOP
172: create_k_article
173: (
174: p_api_version => p_api_version,
175: p_init_msg_list => OKC_API.G_FALSE,
176: x_return_status => x_return_status,
177: x_msg_count => x_msg_count,
178: x_msg_data => x_msg_data,
179: p_catv_rec => p_catv_tbl(i),

Line 182: if (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

178: x_msg_data => x_msg_data,
179: p_catv_rec => p_catv_tbl(i),
180: x_catv_rec => x_catv_tbl(i)
181: );
182: if (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
183: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
184: elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
185: null;
186: end if;

Line 183: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

179: p_catv_rec => p_catv_tbl(i),
180: x_catv_rec => x_catv_tbl(i)
181: );
182: if (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
183: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
184: elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
185: null;
186: end if;
187: c:=c-1;

Line 184: elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

180: x_catv_rec => x_catv_tbl(i)
181: );
182: if (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
183: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
184: elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
185: null;
186: end if;
187: c:=c-1;
188: EXIT WHEN (c=0);

Line 205: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

201: -- Parameters :
202: -- Version : 1.0
203: -- End of comments
204: procedure update_k_article(p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_catv_rec IN catv_rec_type,

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

208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_catv_rec IN catv_rec_type,
210: x_catv_rec OUT NOCOPY catv_rec_type) is
211: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_K_ARTICLE';
212: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
213: l_clob clob;
214: begin
215: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
216: G_PKG_NAME,

Line 215: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

211: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_K_ARTICLE';
212: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
213: l_clob clob;
214: begin
215: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
216: G_PKG_NAME,
217: p_init_msg_list,
218: G_API_VERSION,
219: p_api_version,

Line 222: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

218: G_API_VERSION,
219: p_api_version,
220: G_SCOPE,
221: x_return_status);
222: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
225: RAISE OKC_API.G_EXCEPTION_ERROR;
226: END IF;

Line 223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

219: p_api_version,
220: G_SCOPE,
221: x_return_status);
222: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
225: RAISE OKC_API.G_EXCEPTION_ERROR;
226: END IF;
227: g_catv_rec := p_catv_rec;

Line 224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

220: G_SCOPE,
221: x_return_status);
222: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
225: RAISE OKC_API.G_EXCEPTION_ERROR;
226: END IF;
227: g_catv_rec := p_catv_rec;
228: --

Line 225: RAISE OKC_API.G_EXCEPTION_ERROR;

221: x_return_status);
222: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
225: RAISE OKC_API.G_EXCEPTION_ERROR;
226: END IF;
227: g_catv_rec := p_catv_rec;
228: --
229: -- code for temporary clob ... start

Line 251: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

247: --
248: -- Call Before Logic Hook
249: --
250: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
251: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
252: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
253: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
254: raise OKC_API.G_EXCEPTION_ERROR;
255: END IF;

Line 252: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

248: -- Call Before Logic Hook
249: --
250: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
251: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
252: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
253: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
254: raise OKC_API.G_EXCEPTION_ERROR;
255: END IF;
256: reset(p_catv_rec);

Line 253: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

249: --
250: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
251: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
252: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
253: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
254: raise OKC_API.G_EXCEPTION_ERROR;
255: END IF;
256: reset(p_catv_rec);
257: OKL_VP_K_ARTICLE_PVT.update_k_article ( p_api_version => p_api_version,

Line 254: raise OKC_API.G_EXCEPTION_ERROR;

250: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
251: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
252: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
253: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
254: raise OKC_API.G_EXCEPTION_ERROR;
255: END IF;
256: reset(p_catv_rec);
257: OKL_VP_K_ARTICLE_PVT.update_k_article ( p_api_version => p_api_version,
258: p_init_msg_list => OKC_API.G_FALSE,

Line 258: p_init_msg_list => OKC_API.G_FALSE,

254: raise OKC_API.G_EXCEPTION_ERROR;
255: END IF;
256: reset(p_catv_rec);
257: OKL_VP_K_ARTICLE_PVT.update_k_article ( p_api_version => p_api_version,
258: p_init_msg_list => OKC_API.G_FALSE,
259: x_return_status => x_return_status,
260: x_msg_count => x_msg_count,
261: x_msg_data => x_msg_data,
262: p_catv_rec => g_catv_rec,

Line 265: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

261: x_msg_data => x_msg_data,
262: p_catv_rec => g_catv_rec,
263: x_catv_rec => x_catv_rec
264: );
265: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
267: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
268: RAISE OKC_API.G_EXCEPTION_ERROR;
269: END IF;

Line 266: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

262: p_catv_rec => g_catv_rec,
263: x_catv_rec => x_catv_rec
264: );
265: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
267: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
268: RAISE OKC_API.G_EXCEPTION_ERROR;
269: END IF;
270: --

Line 267: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

263: x_catv_rec => x_catv_rec
264: );
265: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
267: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
268: RAISE OKC_API.G_EXCEPTION_ERROR;
269: END IF;
270: --
271: -- Call After Logic Hook

Line 268: RAISE OKC_API.G_EXCEPTION_ERROR;

264: );
265: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
267: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
268: RAISE OKC_API.G_EXCEPTION_ERROR;
269: END IF;
270: --
271: -- Call After Logic Hook
272: --

Line 275: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

271: -- Call After Logic Hook
272: --
273: g_catv_rec := x_catv_rec;
274: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
275: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
276: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
277: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
278: raise OKC_API.G_EXCEPTION_ERROR;
279: END IF;

Line 276: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

272: --
273: g_catv_rec := x_catv_rec;
274: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
275: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
276: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
277: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
278: raise OKC_API.G_EXCEPTION_ERROR;
279: END IF;
280: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 277: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

273: g_catv_rec := x_catv_rec;
274: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
275: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
276: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
277: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
278: raise OKC_API.G_EXCEPTION_ERROR;
279: END IF;
280: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
281: EXCEPTION

Line 278: raise OKC_API.G_EXCEPTION_ERROR;

274: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
275: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
276: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
277: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
278: raise OKC_API.G_EXCEPTION_ERROR;
279: END IF;
280: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
281: EXCEPTION
282: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 280: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

276: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
277: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
278: raise OKC_API.G_EXCEPTION_ERROR;
279: END IF;
280: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
281: EXCEPTION
282: WHEN OKC_API.G_EXCEPTION_ERROR THEN
283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
284: (substr(l_api_name,1,26),

Line 282: WHEN OKC_API.G_EXCEPTION_ERROR THEN

278: raise OKC_API.G_EXCEPTION_ERROR;
279: END IF;
280: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
281: EXCEPTION
282: WHEN OKC_API.G_EXCEPTION_ERROR THEN
283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
284: (substr(l_api_name,1,26),
285: G_PKG_NAME,
286: 'OKC_API.G_RET_STS_ERROR',

Line 283: x_return_status := OKC_API.HANDLE_EXCEPTIONS

279: END IF;
280: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
281: EXCEPTION
282: WHEN OKC_API.G_EXCEPTION_ERROR THEN
283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
284: (substr(l_api_name,1,26),
285: G_PKG_NAME,
286: 'OKC_API.G_RET_STS_ERROR',
287: x_msg_count,

Line 286: 'OKC_API.G_RET_STS_ERROR',

282: WHEN OKC_API.G_EXCEPTION_ERROR THEN
283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
284: (substr(l_api_name,1,26),
285: G_PKG_NAME,
286: 'OKC_API.G_RET_STS_ERROR',
287: x_msg_count,
288: x_msg_data,
289: G_SCOPE);
290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

286: 'OKC_API.G_RET_STS_ERROR',
287: x_msg_count,
288: x_msg_data,
289: G_SCOPE);
290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
291: x_return_status := OKC_API.HANDLE_EXCEPTIONS
292: (substr(l_api_name,1,26),
293: G_PKG_NAME,
294: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 291: x_return_status := OKC_API.HANDLE_EXCEPTIONS

287: x_msg_count,
288: x_msg_data,
289: G_SCOPE);
290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
291: x_return_status := OKC_API.HANDLE_EXCEPTIONS
292: (substr(l_api_name,1,26),
293: G_PKG_NAME,
294: 'OKC_API.G_RET_STS_UNEXP_ERROR',
295: x_msg_count,

Line 294: 'OKC_API.G_RET_STS_UNEXP_ERROR',

290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
291: x_return_status := OKC_API.HANDLE_EXCEPTIONS
292: (substr(l_api_name,1,26),
293: G_PKG_NAME,
294: 'OKC_API.G_RET_STS_UNEXP_ERROR',
295: x_msg_count,
296: x_msg_data,
297: G_SCOPE);
298: WHEN OTHERS THEN

Line 299: x_return_status := OKC_API.HANDLE_EXCEPTIONS

295: x_msg_count,
296: x_msg_data,
297: G_SCOPE);
298: WHEN OTHERS THEN
299: x_return_status := OKC_API.HANDLE_EXCEPTIONS
300: (substr(l_api_name,1,26),
301: G_PKG_NAME,
302: 'OTHERS',
303: x_msg_count,

Line 316: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

312: -- Parameters :
313: -- Version : 1.0
314: -- End of comments
315: procedure update_k_article(p_api_version IN NUMBER,
316: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
317: x_return_status OUT NOCOPY VARCHAR2,
318: x_msg_count OUT NOCOPY NUMBER,
319: x_msg_data OUT NOCOPY VARCHAR2,
320: p_catv_tbl IN catv_tbl_type,

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

319: x_msg_data OUT NOCOPY VARCHAR2,
320: p_catv_tbl IN catv_tbl_type,
321: x_catv_tbl OUT NOCOPY catv_tbl_type) is
322: i NUMBER;
323: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
324: begin
325: OKC_API.init_msg_list(p_init_msg_list);
326: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
327: if (p_catv_tbl.COUNT>0) then

Line 325: OKC_API.init_msg_list(p_init_msg_list);

321: x_catv_tbl OUT NOCOPY catv_tbl_type) is
322: i NUMBER;
323: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
324: begin
325: OKC_API.init_msg_list(p_init_msg_list);
326: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
327: if (p_catv_tbl.COUNT>0) then
328: i := p_catv_tbl.FIRST;
329: LOOP

Line 326: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

322: i NUMBER;
323: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
324: begin
325: OKC_API.init_msg_list(p_init_msg_list);
326: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
327: if (p_catv_tbl.COUNT>0) then
328: i := p_catv_tbl.FIRST;
329: LOOP
330: update_k_article(p_api_version=>p_api_version,

Line 331: p_init_msg_list=>OKC_API.G_FALSE,

327: if (p_catv_tbl.COUNT>0) then
328: i := p_catv_tbl.FIRST;
329: LOOP
330: update_k_article(p_api_version=>p_api_version,
331: p_init_msg_list=>OKC_API.G_FALSE,
332: x_return_status=>l_return_status,
333: x_msg_count=>x_msg_count,
334: x_msg_data=>x_msg_data,
335: p_catv_rec=>p_catv_tbl(i),

Line 337: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

333: x_msg_count=>x_msg_count,
334: x_msg_data=>x_msg_data,
335: p_catv_rec=>p_catv_tbl(i),
336: x_catv_rec=>x_catv_tbl(i));
337: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
338: x_return_status := l_return_status;
339: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
340: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
341: x_return_status := l_return_status;

Line 339: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

335: p_catv_rec=>p_catv_tbl(i),
336: x_catv_rec=>x_catv_tbl(i));
337: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
338: x_return_status := l_return_status;
339: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
340: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
341: x_return_status := l_return_status;
342: end if;
343: EXIT WHEN (i=p_catv_tbl.LAST);

Line 340: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

336: x_catv_rec=>x_catv_tbl(i));
337: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
338: x_return_status := l_return_status;
339: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
340: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
341: x_return_status := l_return_status;
342: end if;
343: EXIT WHEN (i=p_catv_tbl.LAST);
344: i := p_catv_tbl.NEXT(i);

Line 359: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

355: -- Parameters :
356: -- Version : 1.0
357: -- End of comments
358: procedure delete_k_article(p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
360: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_count OUT NOCOPY NUMBER,
362: x_msg_data OUT NOCOPY VARCHAR2,
363: p_catv_rec IN catv_rec_type) is

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

361: x_msg_count OUT NOCOPY NUMBER,
362: x_msg_data OUT NOCOPY VARCHAR2,
363: p_catv_rec IN catv_rec_type) is
364: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_K_ARTICLE';
365: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
366: begin
367: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
368: G_PKG_NAME,
369: p_init_msg_list,

Line 367: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

363: p_catv_rec IN catv_rec_type) is
364: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_K_ARTICLE';
365: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
366: begin
367: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
368: G_PKG_NAME,
369: p_init_msg_list,
370: G_API_VERSION,
371: p_api_version,

Line 374: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

370: G_API_VERSION,
371: p_api_version,
372: G_SCOPE,
373: x_return_status);
374: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
375: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
377: RAISE OKC_API.G_EXCEPTION_ERROR;
378: END IF;

Line 375: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

371: p_api_version,
372: G_SCOPE,
373: x_return_status);
374: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
375: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
377: RAISE OKC_API.G_EXCEPTION_ERROR;
378: END IF;
379: g_catv_rec := p_catv_rec;

Line 376: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

372: G_SCOPE,
373: x_return_status);
374: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
375: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
377: RAISE OKC_API.G_EXCEPTION_ERROR;
378: END IF;
379: g_catv_rec := p_catv_rec;
380: --

Line 377: RAISE OKC_API.G_EXCEPTION_ERROR;

373: x_return_status);
374: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
375: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
376: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
377: RAISE OKC_API.G_EXCEPTION_ERROR;
378: END IF;
379: g_catv_rec := p_catv_rec;
380: --
381: -- Call Before Logic Hook

Line 384: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

380: --
381: -- Call Before Logic Hook
382: --
383: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
384: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
385: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
386: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
387: raise OKC_API.G_EXCEPTION_ERROR;
388: END IF;

Line 385: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

381: -- Call Before Logic Hook
382: --
383: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
384: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
385: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
386: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
387: raise OKC_API.G_EXCEPTION_ERROR;
388: END IF;
389: reset(p_catv_rec);

Line 386: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

382: --
383: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
384: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
385: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
386: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
387: raise OKC_API.G_EXCEPTION_ERROR;
388: END IF;
389: reset(p_catv_rec);
390: OKL_VP_K_ARTICLE_PVT.delete_k_article

Line 387: raise OKC_API.G_EXCEPTION_ERROR;

383: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
384: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
385: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
386: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
387: raise OKC_API.G_EXCEPTION_ERROR;
388: END IF;
389: reset(p_catv_rec);
390: OKL_VP_K_ARTICLE_PVT.delete_k_article
391: (

Line 393: p_init_msg_list => OKC_API.G_FALSE,

389: reset(p_catv_rec);
390: OKL_VP_K_ARTICLE_PVT.delete_k_article
391: (
392: p_api_version => p_api_version,
393: p_init_msg_list => OKC_API.G_FALSE,
394: x_return_status => x_return_status,
395: x_msg_count => x_msg_count,
396: x_msg_data => x_msg_data,
397: p_catv_rec => g_catv_rec

Line 399: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

395: x_msg_count => x_msg_count,
396: x_msg_data => x_msg_data,
397: p_catv_rec => g_catv_rec
398: );
399: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
400: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
401: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
402: RAISE OKC_API.G_EXCEPTION_ERROR;
403: END IF;

Line 400: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

396: x_msg_data => x_msg_data,
397: p_catv_rec => g_catv_rec
398: );
399: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
400: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
401: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
402: RAISE OKC_API.G_EXCEPTION_ERROR;
403: END IF;
404: --

Line 401: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

397: p_catv_rec => g_catv_rec
398: );
399: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
400: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
401: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
402: RAISE OKC_API.G_EXCEPTION_ERROR;
403: END IF;
404: --
405: -- Call After Logic Hook

Line 402: RAISE OKC_API.G_EXCEPTION_ERROR;

398: );
399: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
400: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
401: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
402: RAISE OKC_API.G_EXCEPTION_ERROR;
403: END IF;
404: --
405: -- Call After Logic Hook
406: --

Line 408: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

404: --
405: -- Call After Logic Hook
406: --
407: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
408: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
409: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
410: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
411: raise OKC_API.G_EXCEPTION_ERROR;
412: END IF;

Line 409: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

405: -- Call After Logic Hook
406: --
407: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
408: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
409: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
410: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
411: raise OKC_API.G_EXCEPTION_ERROR;
412: END IF;
413: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 410: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

406: --
407: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
408: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
409: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
410: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
411: raise OKC_API.G_EXCEPTION_ERROR;
412: END IF;
413: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
414: EXCEPTION

Line 411: raise OKC_API.G_EXCEPTION_ERROR;

407: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
408: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
409: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
410: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
411: raise OKC_API.G_EXCEPTION_ERROR;
412: END IF;
413: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
414: EXCEPTION
415: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 413: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

409: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
410: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
411: raise OKC_API.G_EXCEPTION_ERROR;
412: END IF;
413: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
414: EXCEPTION
415: WHEN OKC_API.G_EXCEPTION_ERROR THEN
416: x_return_status := OKC_API.HANDLE_EXCEPTIONS
417: (substr(l_api_name,1,26),

Line 415: WHEN OKC_API.G_EXCEPTION_ERROR THEN

411: raise OKC_API.G_EXCEPTION_ERROR;
412: END IF;
413: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
414: EXCEPTION
415: WHEN OKC_API.G_EXCEPTION_ERROR THEN
416: x_return_status := OKC_API.HANDLE_EXCEPTIONS
417: (substr(l_api_name,1,26),
418: G_PKG_NAME,
419: 'OKC_API.G_RET_STS_ERROR',

Line 416: x_return_status := OKC_API.HANDLE_EXCEPTIONS

412: END IF;
413: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
414: EXCEPTION
415: WHEN OKC_API.G_EXCEPTION_ERROR THEN
416: x_return_status := OKC_API.HANDLE_EXCEPTIONS
417: (substr(l_api_name,1,26),
418: G_PKG_NAME,
419: 'OKC_API.G_RET_STS_ERROR',
420: x_msg_count,

Line 419: 'OKC_API.G_RET_STS_ERROR',

415: WHEN OKC_API.G_EXCEPTION_ERROR THEN
416: x_return_status := OKC_API.HANDLE_EXCEPTIONS
417: (substr(l_api_name,1,26),
418: G_PKG_NAME,
419: 'OKC_API.G_RET_STS_ERROR',
420: x_msg_count,
421: x_msg_data,
422: G_SCOPE);
423: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 423: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

419: 'OKC_API.G_RET_STS_ERROR',
420: x_msg_count,
421: x_msg_data,
422: G_SCOPE);
423: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
424: x_return_status := OKC_API.HANDLE_EXCEPTIONS
425: (substr(l_api_name,1,26),
426: G_PKG_NAME,
427: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 424: x_return_status := OKC_API.HANDLE_EXCEPTIONS

420: x_msg_count,
421: x_msg_data,
422: G_SCOPE);
423: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
424: x_return_status := OKC_API.HANDLE_EXCEPTIONS
425: (substr(l_api_name,1,26),
426: G_PKG_NAME,
427: 'OKC_API.G_RET_STS_UNEXP_ERROR',
428: x_msg_count,

Line 427: 'OKC_API.G_RET_STS_UNEXP_ERROR',

423: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
424: x_return_status := OKC_API.HANDLE_EXCEPTIONS
425: (substr(l_api_name,1,26),
426: G_PKG_NAME,
427: 'OKC_API.G_RET_STS_UNEXP_ERROR',
428: x_msg_count,
429: x_msg_data,
430: G_SCOPE);
431: WHEN OTHERS THEN

Line 432: x_return_status := OKC_API.HANDLE_EXCEPTIONS

428: x_msg_count,
429: x_msg_data,
430: G_SCOPE);
431: WHEN OTHERS THEN
432: x_return_status := OKC_API.HANDLE_EXCEPTIONS
433: (substr(l_api_name,1,26),
434: G_PKG_NAME,
435: 'OTHERS',
436: x_msg_count,

Line 449: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,

445: -- Parameters :
446: -- Version : 1.0
447: -- End of comments
448: procedure delete_k_article(p_api_version IN NUMBER,
449: p_init_msg_list IN VARCHAR2 default OKC_API.G_FALSE,
450: x_return_status OUT NOCOPY VARCHAR2,
451: x_msg_count OUT NOCOPY NUMBER,
452: x_msg_data OUT NOCOPY VARCHAR2,
453: p_catv_tbl IN catv_tbl_type) is

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

451: x_msg_count OUT NOCOPY NUMBER,
452: x_msg_data OUT NOCOPY VARCHAR2,
453: p_catv_tbl IN catv_tbl_type) is
454: i NUMBER;
455: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
456: begin
457: OKC_API.init_msg_list(p_init_msg_list);
458: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
459: if (p_catv_tbl.COUNT>0) then

Line 457: OKC_API.init_msg_list(p_init_msg_list);

453: p_catv_tbl IN catv_tbl_type) is
454: i NUMBER;
455: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
456: begin
457: OKC_API.init_msg_list(p_init_msg_list);
458: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
459: if (p_catv_tbl.COUNT>0) then
460: i := p_catv_tbl.FIRST;
461: LOOP

Line 458: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

454: i NUMBER;
455: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
456: begin
457: OKC_API.init_msg_list(p_init_msg_list);
458: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
459: if (p_catv_tbl.COUNT>0) then
460: i := p_catv_tbl.FIRST;
461: LOOP
462: delete_k_article(p_api_version=>p_api_version,

Line 463: p_init_msg_list=>OKC_API.G_FALSE,

459: if (p_catv_tbl.COUNT>0) then
460: i := p_catv_tbl.FIRST;
461: LOOP
462: delete_k_article(p_api_version=>p_api_version,
463: p_init_msg_list=>OKC_API.G_FALSE,
464: x_return_status=>l_return_status,
465: x_msg_count=>x_msg_count,
466: x_msg_data=>x_msg_data,
467: p_catv_rec=>p_catv_tbl(i));

Line 468: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

464: x_return_status=>l_return_status,
465: x_msg_count=>x_msg_count,
466: x_msg_data=>x_msg_data,
467: p_catv_rec=>p_catv_tbl(i));
468: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
469: x_return_status := l_return_status;
470: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
471: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
472: x_return_status := l_return_status;

Line 470: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

466: x_msg_data=>x_msg_data,
467: p_catv_rec=>p_catv_tbl(i));
468: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
469: x_return_status := l_return_status;
470: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
471: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
472: x_return_status := l_return_status;
473: end if;
474: EXIT WHEN (i=p_catv_tbl.LAST);

Line 471: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

467: p_catv_rec=>p_catv_tbl(i));
468: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
469: x_return_status := l_return_status;
470: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
471: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
472: x_return_status := l_return_status;
473: end if;
474: EXIT WHEN (i=p_catv_tbl.LAST);
475: i := p_catv_tbl.NEXT(i);

Line 517: p_init_msg_list VARCHAR2(1) := OKC_API.G_FALSE;

513: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
514: x_msg_count NUMBER;
515: x_msg_data VARCHAR2(4000);
516: p_api_version NUMBER := 1.0;
517: p_init_msg_list VARCHAR2(1) := OKC_API.G_FALSE;
518:
519: length NUMBER;
520: l_chr_id OKL_VP_ASSOCIATIONS.CHR_ID%TYPE;
521: