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

Line 150: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

146: okc_debug.Set_Indentation(l_proc);
147: okc_debug.Log('10: Entering ',2);
148: END IF;
149:
150: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
151: p_init_msg_list,
152: '_PUB',
153: x_return_status);
154: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

150: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
151: p_init_msg_list,
152: '_PUB',
153: x_return_status);
154: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
155: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
156: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
157: raise OKC_API.G_EXCEPTION_ERROR;
158: END IF;

Line 155: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

151: p_init_msg_list,
152: '_PUB',
153: x_return_status);
154: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
155: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
156: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
157: raise OKC_API.G_EXCEPTION_ERROR;
158: END IF;
159:

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

152: '_PUB',
153: x_return_status);
154: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
155: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
156: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
157: raise OKC_API.G_EXCEPTION_ERROR;
158: END IF;
159:
160: -- Call to Complex API procedure

Line 157: raise OKC_API.G_EXCEPTION_ERROR;

153: x_return_status);
154: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
155: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
156: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
157: raise OKC_API.G_EXCEPTION_ERROR;
158: END IF;
159:
160: -- Call to Complex API procedure
161: okc_outcome_pvt.create_outcomes_args(

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

167: p_ocev_rec,
168: p_oatv_tbl,
169: x_ocev_rec,
170: x_oatv_tbl);
171: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
172: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
173: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
174: raise OKC_API.G_EXCEPTION_ERROR;
175: END IF;

Line 172: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

168: p_oatv_tbl,
169: x_ocev_rec,
170: x_oatv_tbl);
171: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
172: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
173: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
174: raise OKC_API.G_EXCEPTION_ERROR;
175: END IF;
176:

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

169: x_ocev_rec,
170: x_oatv_tbl);
171: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
172: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
173: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
174: raise OKC_API.G_EXCEPTION_ERROR;
175: END IF;
176:
177: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 174: raise OKC_API.G_EXCEPTION_ERROR;

170: x_oatv_tbl);
171: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
172: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
173: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
174: raise OKC_API.G_EXCEPTION_ERROR;
175: END IF;
176:
177: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
178:

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

173: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
174: raise OKC_API.G_EXCEPTION_ERROR;
175: END IF;
176:
177: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
178:
179: IF (l_debug = 'Y') THEN
180: okc_debug.Log('1000: Leaving ',2);
181: okc_debug.Reset_Indentation;

Line 185: WHEN OKC_API.G_EXCEPTION_ERROR THEN

181: okc_debug.Reset_Indentation;
182: END IF;
183:
184: EXCEPTION
185: WHEN OKC_API.G_EXCEPTION_ERROR THEN
186: x_return_status := OKC_API.HANDLE_EXCEPTIONS
187: (l_api_name,
188: G_PKG_NAME,
189: 'OKC_API.G_RET_STS_ERROR',

Line 186: x_return_status := OKC_API.HANDLE_EXCEPTIONS

182: END IF;
183:
184: EXCEPTION
185: WHEN OKC_API.G_EXCEPTION_ERROR THEN
186: x_return_status := OKC_API.HANDLE_EXCEPTIONS
187: (l_api_name,
188: G_PKG_NAME,
189: 'OKC_API.G_RET_STS_ERROR',
190: x_msg_count,

Line 189: 'OKC_API.G_RET_STS_ERROR',

185: WHEN OKC_API.G_EXCEPTION_ERROR THEN
186: x_return_status := OKC_API.HANDLE_EXCEPTIONS
187: (l_api_name,
188: G_PKG_NAME,
189: 'OKC_API.G_RET_STS_ERROR',
190: x_msg_count,
191: x_msg_data,
192: '_PUB');
193: IF (l_debug = 'Y') THEN

Line 197: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

193: IF (l_debug = 'Y') THEN
194: okc_debug.Log('2000: Leaving ',2);
195: okc_debug.Reset_Indentation;
196: END IF;
197: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
198: x_return_status := OKC_API.HANDLE_EXCEPTIONS
199: (l_api_name,
200: G_PKG_NAME,
201: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 198: x_return_status := OKC_API.HANDLE_EXCEPTIONS

194: okc_debug.Log('2000: Leaving ',2);
195: okc_debug.Reset_Indentation;
196: END IF;
197: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
198: x_return_status := OKC_API.HANDLE_EXCEPTIONS
199: (l_api_name,
200: G_PKG_NAME,
201: 'OKC_API.G_RET_STS_UNEXP_ERROR',
202: x_msg_count,

Line 201: 'OKC_API.G_RET_STS_UNEXP_ERROR',

197: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
198: x_return_status := OKC_API.HANDLE_EXCEPTIONS
199: (l_api_name,
200: G_PKG_NAME,
201: 'OKC_API.G_RET_STS_UNEXP_ERROR',
202: x_msg_count,
203: x_msg_data,
204: '_PUB');
205: IF (l_debug = 'Y') THEN

Line 210: x_return_status := OKC_API.HANDLE_EXCEPTIONS

206: okc_debug.Log('3000: Leaving ',2);
207: okc_debug.Reset_Indentation;
208: END IF;
209: WHEN OTHERS THEN
210: x_return_status := OKC_API.HANDLE_EXCEPTIONS
211: (l_api_name,
212: G_PKG_NAME,
213: 'OTHERS',
214: x_msg_count,

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

233: x_oatv_tbl OUT NOCOPY oatv_tbl_type) IS
234:
235: l_api_version CONSTANT NUMBER := 1;
236: l_api_name CONSTANT VARCHAR2(30) := 'update_outcomes_args';
237: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
238:
239: --
240: l_proc varchar2(72) := ' okc_outcome_pub.'||'update_outcomes_args';
241: --

Line 250: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

246: okc_debug.Set_Indentation(l_proc);
247: okc_debug.Log('10: Entering ',2);
248: END IF;
249:
250: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
251: p_init_msg_list,
252: '_PUB',
253: x_return_status);
254: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

250: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
251: p_init_msg_list,
252: '_PUB',
253: x_return_status);
254: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
255: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
257: raise OKC_API.G_EXCEPTION_ERROR;
258: END IF;

Line 255: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

251: p_init_msg_list,
252: '_PUB',
253: x_return_status);
254: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
255: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
257: raise OKC_API.G_EXCEPTION_ERROR;
258: END IF;
259:

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

252: '_PUB',
253: x_return_status);
254: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
255: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
257: raise OKC_API.G_EXCEPTION_ERROR;
258: END IF;
259:
260: --Call to Complex API procedure

Line 257: raise OKC_API.G_EXCEPTION_ERROR;

253: x_return_status);
254: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
255: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
256: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
257: raise OKC_API.G_EXCEPTION_ERROR;
258: END IF;
259:
260: --Call to Complex API procedure
261: okc_outcome_pvt.update_outcomes_args(

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

267: p_ocev_rec,
268: p_oatv_tbl,
269: x_ocev_rec,
270: x_oatv_tbl);
271: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
272: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
273: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
274: raise OKC_API.G_EXCEPTION_ERROR;
275: END IF;

Line 272: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

268: p_oatv_tbl,
269: x_ocev_rec,
270: x_oatv_tbl);
271: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
272: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
273: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
274: raise OKC_API.G_EXCEPTION_ERROR;
275: END IF;
276:

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

269: x_ocev_rec,
270: x_oatv_tbl);
271: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
272: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
273: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
274: raise OKC_API.G_EXCEPTION_ERROR;
275: END IF;
276:
277: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 274: raise OKC_API.G_EXCEPTION_ERROR;

270: x_oatv_tbl);
271: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
272: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
273: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
274: raise OKC_API.G_EXCEPTION_ERROR;
275: END IF;
276:
277: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
278:

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

273: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
274: raise OKC_API.G_EXCEPTION_ERROR;
275: END IF;
276:
277: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
278:
279: IF (l_debug = 'Y') THEN
280: okc_debug.Log('1000: Leaving ',2);
281: okc_debug.Reset_Indentation;

Line 285: WHEN OKC_API.G_EXCEPTION_ERROR THEN

281: okc_debug.Reset_Indentation;
282: END IF;
283:
284: EXCEPTION
285: WHEN OKC_API.G_EXCEPTION_ERROR THEN
286: x_return_status := OKC_API.HANDLE_EXCEPTIONS
287: (l_api_name,
288: G_PKG_NAME,
289: 'OKC_API.G_RET_STS_ERROR',

Line 286: x_return_status := OKC_API.HANDLE_EXCEPTIONS

282: END IF;
283:
284: EXCEPTION
285: WHEN OKC_API.G_EXCEPTION_ERROR THEN
286: x_return_status := OKC_API.HANDLE_EXCEPTIONS
287: (l_api_name,
288: G_PKG_NAME,
289: 'OKC_API.G_RET_STS_ERROR',
290: x_msg_count,

Line 289: 'OKC_API.G_RET_STS_ERROR',

285: WHEN OKC_API.G_EXCEPTION_ERROR THEN
286: x_return_status := OKC_API.HANDLE_EXCEPTIONS
287: (l_api_name,
288: G_PKG_NAME,
289: 'OKC_API.G_RET_STS_ERROR',
290: x_msg_count,
291: x_msg_data,
292: '_PUB');
293: IF (l_debug = 'Y') THEN

Line 297: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

293: IF (l_debug = 'Y') THEN
294: okc_debug.Log('2000: Leaving ',2);
295: okc_debug.Reset_Indentation;
296: END IF;
297: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
298: x_return_status := OKC_API.HANDLE_EXCEPTIONS
299: (l_api_name,
300: G_PKG_NAME,
301: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 298: x_return_status := OKC_API.HANDLE_EXCEPTIONS

294: okc_debug.Log('2000: Leaving ',2);
295: okc_debug.Reset_Indentation;
296: END IF;
297: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
298: x_return_status := OKC_API.HANDLE_EXCEPTIONS
299: (l_api_name,
300: G_PKG_NAME,
301: 'OKC_API.G_RET_STS_UNEXP_ERROR',
302: x_msg_count,

Line 301: '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: (l_api_name,
300: G_PKG_NAME,
301: 'OKC_API.G_RET_STS_UNEXP_ERROR',
302: x_msg_count,
303: x_msg_data,
304: '_PUB');
305: IF (l_debug = 'Y') THEN

Line 310: x_return_status := OKC_API.HANDLE_EXCEPTIONS

306: okc_debug.Log('3000: Leaving ',2);
307: okc_debug.Reset_Indentation;
308: END IF;
309: WHEN OTHERS THEN
310: x_return_status := OKC_API.HANDLE_EXCEPTIONS
311: (l_api_name,
312: G_PKG_NAME,
313: 'OTHERS',
314: x_msg_count,

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

331: p_oatv_tbl IN oatv_tbl_type) IS
332:
333: l_api_version CONSTANT NUMBER := 1;
334: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_process_def';
335: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
336:
337: --
338: l_proc varchar2(72) := ' okc_outcome_pub.'||'validate_outcomes_args';
339: --

Line 348: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

344: okc_debug.Set_Indentation(l_proc);
345: okc_debug.Log('10: Entering ',2);
346: END IF;
347:
348: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
349: p_init_msg_list,
350: '_PUB',
351: x_return_status);
352: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

348: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
349: p_init_msg_list,
350: '_PUB',
351: x_return_status);
352: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
353: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
354: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
355: raise OKC_API.G_EXCEPTION_ERROR;
356: END IF;

Line 353: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

349: p_init_msg_list,
350: '_PUB',
351: x_return_status);
352: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
353: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
354: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
355: raise OKC_API.G_EXCEPTION_ERROR;
356: END IF;
357:

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

350: '_PUB',
351: x_return_status);
352: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
353: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
354: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
355: raise OKC_API.G_EXCEPTION_ERROR;
356: END IF;
357:
358: okc_outcome_pvt.validate_outcomes_args(

Line 355: raise OKC_API.G_EXCEPTION_ERROR;

351: x_return_status);
352: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
353: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
354: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
355: raise OKC_API.G_EXCEPTION_ERROR;
356: END IF;
357:
358: okc_outcome_pvt.validate_outcomes_args(
359: p_api_version,

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

362: x_msg_count,
363: x_msg_data,
364: p_ocev_rec,
365: p_oatv_tbl);
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: x_msg_data,
364: p_ocev_rec,
365: p_oatv_tbl);
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: p_ocev_rec,
365: p_oatv_tbl);
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: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 369: raise OKC_API.G_EXCEPTION_ERROR;

365: p_oatv_tbl);
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: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
373:

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

368: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
369: raise OKC_API.G_EXCEPTION_ERROR;
370: END IF;
371:
372: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
373:
374: IF (l_debug = 'Y') THEN
375: okc_debug.Log('1000: Leaving ',2);
376: okc_debug.Reset_Indentation;

Line 380: WHEN OKC_API.G_EXCEPTION_ERROR THEN

376: okc_debug.Reset_Indentation;
377: END IF;
378:
379: EXCEPTION
380: WHEN OKC_API.G_EXCEPTION_ERROR THEN
381: x_return_status := OKC_API.HANDLE_EXCEPTIONS
382: (l_api_name,
383: G_PKG_NAME,
384: 'OKC_API.G_RET_STS_ERROR',

Line 381: x_return_status := OKC_API.HANDLE_EXCEPTIONS

377: END IF;
378:
379: EXCEPTION
380: WHEN OKC_API.G_EXCEPTION_ERROR THEN
381: x_return_status := OKC_API.HANDLE_EXCEPTIONS
382: (l_api_name,
383: G_PKG_NAME,
384: 'OKC_API.G_RET_STS_ERROR',
385: x_msg_count,

Line 384: 'OKC_API.G_RET_STS_ERROR',

380: WHEN OKC_API.G_EXCEPTION_ERROR THEN
381: x_return_status := OKC_API.HANDLE_EXCEPTIONS
382: (l_api_name,
383: G_PKG_NAME,
384: 'OKC_API.G_RET_STS_ERROR',
385: x_msg_count,
386: x_msg_data,
387: '_PUB');
388: IF (l_debug = 'Y') THEN

Line 392: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

388: IF (l_debug = 'Y') THEN
389: okc_debug.Log('2000: Leaving ',2);
390: okc_debug.Reset_Indentation;
391: END IF;
392: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
393: x_return_status := OKC_API.HANDLE_EXCEPTIONS
394: (l_api_name,
395: G_PKG_NAME,
396: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 393: x_return_status := OKC_API.HANDLE_EXCEPTIONS

389: okc_debug.Log('2000: Leaving ',2);
390: okc_debug.Reset_Indentation;
391: END IF;
392: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
393: x_return_status := OKC_API.HANDLE_EXCEPTIONS
394: (l_api_name,
395: G_PKG_NAME,
396: 'OKC_API.G_RET_STS_UNEXP_ERROR',
397: x_msg_count,

Line 396: 'OKC_API.G_RET_STS_UNEXP_ERROR',

392: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
393: x_return_status := OKC_API.HANDLE_EXCEPTIONS
394: (l_api_name,
395: G_PKG_NAME,
396: 'OKC_API.G_RET_STS_UNEXP_ERROR',
397: x_msg_count,
398: x_msg_data,
399: '_PUB');
400: IF (l_debug = 'Y') THEN

Line 405: x_return_status := OKC_API.HANDLE_EXCEPTIONS

401: okc_debug.Log('3000: Leaving ',2);
402: okc_debug.Reset_Indentation;
403: END IF;
404: WHEN OTHERS THEN
405: x_return_status := OKC_API.HANDLE_EXCEPTIONS
406: (l_api_name,
407: G_PKG_NAME,
408: 'OTHERS',
409: x_msg_count,

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

426: x_ocev_rec OUT NOCOPY ocev_rec_type) IS
427:
428: l_api_name CONSTANT VARCHAR2(30) := 'create_outcome';
429: l_api_version CONSTANT NUMBER := 1.0;
430: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
431: l_ocev_rec ocev_rec_type := p_ocev_rec;
432: --
433: l_proc varchar2(72) := ' okc_outcome_pub.'||'create_outcome';
434: --

Line 443: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

439: okc_debug.Set_Indentation(l_proc);
440: okc_debug.Log('10: Entering ',2);
441: END IF;
442:
443: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
444: g_pkg_name,
445: p_init_msg_list,
446: l_api_version,
447: p_api_version,

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

447: p_api_version,
448: '_PUB',
449: x_return_status);
450:
451: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
452: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
453: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
454: RAISE OKC_API.G_EXCEPTION_ERROR;
455: END IF;

Line 452: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

448: '_PUB',
449: x_return_status);
450:
451: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
452: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
453: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
454: RAISE OKC_API.G_EXCEPTION_ERROR;
455: END IF;
456:

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

449: x_return_status);
450:
451: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
452: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
453: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
454: RAISE OKC_API.G_EXCEPTION_ERROR;
455: END IF;
456:
457: -- USER HOOK CALL FOR BEFORE, STARTS

Line 454: RAISE OKC_API.G_EXCEPTION_ERROR;

450:
451: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
452: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
453: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
454: RAISE OKC_API.G_EXCEPTION_ERROR;
455: END IF;
456:
457: -- USER HOOK CALL FOR BEFORE, STARTS
458: g_ocev_rec := l_ocev_rec;

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

460: okc_util.call_user_hook(x_return_status => x_return_status,
461: p_package_name => g_pkg_name,
462: p_procedure_name => l_api_name,
463: p_before_after => 'B');
464: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
465: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
466: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
467: RAISE OKC_API.G_EXCEPTION_ERROR;
468: END IF;

Line 465: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

461: p_package_name => g_pkg_name,
462: p_procedure_name => l_api_name,
463: p_before_after => 'B');
464: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
465: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
466: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
467: RAISE OKC_API.G_EXCEPTION_ERROR;
468: END IF;
469:

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

462: p_procedure_name => l_api_name,
463: p_before_after => 'B');
464: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
465: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
466: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
467: RAISE OKC_API.G_EXCEPTION_ERROR;
468: END IF;
469:
470: --get values back from hook call

Line 467: RAISE OKC_API.G_EXCEPTION_ERROR;

463: p_before_after => 'B');
464: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
465: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
466: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
467: RAISE OKC_API.G_EXCEPTION_ERROR;
468: END IF;
469:
470: --get values back from hook call
471: l_ocev_rec := migrate_ocev(l_ocev_rec, g_ocev_rec);

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

477: x_msg_count => x_msg_count,
478: x_msg_data => x_msg_data,
479: p_ocev_rec => l_ocev_rec,
480: x_ocev_rec => x_ocev_rec);
481: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
482: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
483: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
484: raise OKC_API.G_EXCEPTION_ERROR;
485: END IF;

Line 482: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

478: x_msg_data => x_msg_data,
479: p_ocev_rec => l_ocev_rec,
480: x_ocev_rec => x_ocev_rec);
481: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
482: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
483: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
484: raise OKC_API.G_EXCEPTION_ERROR;
485: END IF;
486:

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

479: p_ocev_rec => l_ocev_rec,
480: x_ocev_rec => x_ocev_rec);
481: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
482: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
483: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
484: raise OKC_API.G_EXCEPTION_ERROR;
485: END IF;
486:
487: --USER HOOK CALL FOR AFTER, STARTS

Line 484: raise OKC_API.G_EXCEPTION_ERROR;

480: x_ocev_rec => x_ocev_rec);
481: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
482: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
483: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
484: raise OKC_API.G_EXCEPTION_ERROR;
485: END IF;
486:
487: --USER HOOK CALL FOR AFTER, STARTS
488: g_ocev_rec := x_ocev_rec;

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

491: p_package_name => g_pkg_name,
492: p_procedure_name => l_api_name,
493: p_before_after => 'A');
494:
495: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
496: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
497: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
498: RAISE OKC_API.G_EXCEPTION_ERROR;
499: END IF;

Line 496: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

492: p_procedure_name => l_api_name,
493: p_before_after => 'A');
494:
495: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
496: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
497: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
498: RAISE OKC_API.G_EXCEPTION_ERROR;
499: END IF;
500: --USER HOOK CALL FOR AFTER, ENDS

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

493: p_before_after => 'A');
494:
495: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
496: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
497: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
498: RAISE OKC_API.G_EXCEPTION_ERROR;
499: END IF;
500: --USER HOOK CALL FOR AFTER, ENDS
501:

Line 498: RAISE OKC_API.G_EXCEPTION_ERROR;

494:
495: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
496: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
497: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
498: RAISE OKC_API.G_EXCEPTION_ERROR;
499: END IF;
500: --USER HOOK CALL FOR AFTER, ENDS
501:
502: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

498: RAISE OKC_API.G_EXCEPTION_ERROR;
499: END IF;
500: --USER HOOK CALL FOR AFTER, ENDS
501:
502: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
503:
504:
505: IF (l_debug = 'Y') THEN
506: okc_debug.Log('1000: Leaving ',2);

Line 511: WHEN OKC_API.G_EXCEPTION_ERROR THEN

507: okc_debug.Reset_Indentation;
508: END IF;
509:
510: EXCEPTION
511: WHEN OKC_API.G_EXCEPTION_ERROR THEN
512: x_return_status := OKC_API.HANDLE_EXCEPTIONS
513: (
514: l_api_name,
515: G_PKG_NAME,

Line 512: x_return_status := OKC_API.HANDLE_EXCEPTIONS

508: END IF;
509:
510: EXCEPTION
511: WHEN OKC_API.G_EXCEPTION_ERROR THEN
512: x_return_status := OKC_API.HANDLE_EXCEPTIONS
513: (
514: l_api_name,
515: G_PKG_NAME,
516: 'OKC_API.G_RET_STS_ERROR',

Line 516: 'OKC_API.G_RET_STS_ERROR',

512: x_return_status := OKC_API.HANDLE_EXCEPTIONS
513: (
514: l_api_name,
515: G_PKG_NAME,
516: 'OKC_API.G_RET_STS_ERROR',
517: x_msg_count,
518: x_msg_data,
519: '_PUB'
520: );

Line 526: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

522: okc_debug.Log('2000: Leaving ',2);
523: okc_debug.Reset_Indentation;
524: END IF;
525:
526: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
527: x_return_status := OKC_API.HANDLE_EXCEPTIONS
528: (
529: l_api_name,
530: G_PKG_NAME,

Line 527: x_return_status := OKC_API.HANDLE_EXCEPTIONS

523: okc_debug.Reset_Indentation;
524: END IF;
525:
526: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
527: x_return_status := OKC_API.HANDLE_EXCEPTIONS
528: (
529: l_api_name,
530: G_PKG_NAME,
531: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 531: 'OKC_API.G_RET_STS_UNEXP_ERROR',

527: x_return_status := OKC_API.HANDLE_EXCEPTIONS
528: (
529: l_api_name,
530: G_PKG_NAME,
531: 'OKC_API.G_RET_STS_UNEXP_ERROR',
532: x_msg_count,
533: x_msg_data,
534: '_PUB'
535: );

Line 542: x_return_status := OKC_API.HANDLE_EXCEPTIONS

538: okc_debug.Reset_Indentation;
539: END IF;
540:
541: WHEN OTHERS THEN
542: x_return_status := OKC_API.HANDLE_EXCEPTIONS
543: (
544: l_api_name,
545: G_PKG_NAME,
546: 'OTHERS',

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

561: x_msg_data OUT NOCOPY VARCHAR2,
562: p_ocev_tbl IN ocev_tbl_type,
563: x_ocev_tbl OUT NOCOPY ocev_tbl_type) IS
564:
565: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
566: i NUMBER := 0;
567: --
568: l_proc varchar2(72) := ' okc_outcome_pub.'||'create_outcome';
569: --

Line 579: x_return_status := OKC_API.G_RET_STS_SUCCESS;

575: okc_debug.Log('10: Entering ',2);
576: END IF;
577:
578: --Initialize the return status
579: x_return_status := OKC_API.G_RET_STS_SUCCESS;
580:
581: IF p_ocev_tbl.COUNT > 0 THEN
582: i := p_ocev_tbl.FIRST;
583: LOOP

Line 592: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

588: x_msg_count,
589: x_msg_data,
590: p_ocev_tbl(i),
591: x_ocev_tbl(i));
592: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
593: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
594: x_return_status := l_return_status;
595: raise G_EXCEPTION_HALT_VALIDATION;
596: ELSE

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

589: x_msg_data,
590: p_ocev_tbl(i),
591: x_ocev_tbl(i));
592: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
593: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
594: x_return_status := l_return_status;
595: raise G_EXCEPTION_HALT_VALIDATION;
596: ELSE
597: x_return_status := l_return_status;

Line 619: OKC_API.set_message(p_app_name => g_app_name,

615: okc_debug.Reset_Indentation;
616: END IF;
617:
618: WHEN OTHERS THEN
619: OKC_API.set_message(p_app_name => g_app_name,
620: p_msg_name => g_unexpected_error,
621: p_token1 => g_sqlcode_token,
622: p_token1_value => sqlcode,
623: p_token2 => g_sqlerrm_token,

Line 625: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

621: p_token1 => g_sqlcode_token,
622: p_token1_value => sqlcode,
623: p_token2 => g_sqlerrm_token,
624: p_token2_value => sqlerrm);
625: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
626: IF (l_debug = 'Y') THEN
627: okc_debug.Log('3000: Leaving ',2);
628: okc_debug.Reset_Indentation;
629: END IF;

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

637: p_ocev_rec IN ocev_rec_type) IS
638:
639: l_api_name CONSTANT VARCHAR2(30) := 'lock_outcome';
640: l_api_version CONSTANT NUMBER := 1.0;
641: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
642: --
643: l_proc varchar2(72) := ' okc_outcome_pub.'||'lock_outcome';
644: --
645:

Line 653: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

649: okc_debug.Set_Indentation(l_proc);
650: okc_debug.Log('10: Entering ',2);
651: END IF;
652:
653: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
654: g_pkg_name,
655: p_init_msg_list,
656: l_api_version,
657: p_api_version,

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

657: p_api_version,
658: '_PUB',
659: x_return_status);
660:
661: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
662: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
663: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
664: RAISE OKC_API.G_EXCEPTION_ERROR;
665: END IF;

Line 662: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

658: '_PUB',
659: x_return_status);
660:
661: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
662: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
663: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
664: RAISE OKC_API.G_EXCEPTION_ERROR;
665: END IF;
666:

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

659: x_return_status);
660:
661: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
662: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
663: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
664: RAISE OKC_API.G_EXCEPTION_ERROR;
665: END IF;
666:
667: -- Call to procedure of complex API

Line 664: RAISE OKC_API.G_EXCEPTION_ERROR;

660:
661: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
662: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
663: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
664: RAISE OKC_API.G_EXCEPTION_ERROR;
665: END IF;
666:
667: -- Call to procedure of complex API
668: okc_outcome_pvt.lock_outcome(p_api_version => p_api_version,

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

670: x_return_status => x_return_status,
671: x_msg_count => x_msg_count,
672: x_msg_data => x_msg_data,
673: p_ocev_rec => p_ocev_rec);
674: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
675: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
676: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
677: RAISE OKC_API.G_EXCEPTION_ERROR;
678: END IF;

Line 675: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

671: x_msg_count => x_msg_count,
672: x_msg_data => x_msg_data,
673: p_ocev_rec => p_ocev_rec);
674: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
675: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
676: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
677: RAISE OKC_API.G_EXCEPTION_ERROR;
678: END IF;
679:

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

672: x_msg_data => x_msg_data,
673: p_ocev_rec => p_ocev_rec);
674: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
675: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
676: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
677: RAISE OKC_API.G_EXCEPTION_ERROR;
678: END IF;
679:
680: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 677: RAISE OKC_API.G_EXCEPTION_ERROR;

673: p_ocev_rec => p_ocev_rec);
674: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
675: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
676: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
677: RAISE OKC_API.G_EXCEPTION_ERROR;
678: END IF;
679:
680: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
681:

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

676: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
677: RAISE OKC_API.G_EXCEPTION_ERROR;
678: END IF;
679:
680: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
681:
682:
683: IF (l_debug = 'Y') THEN
684: okc_debug.Log('1000: Leaving ',2);

Line 689: WHEN OKC_API.G_EXCEPTION_ERROR THEN

685: okc_debug.Reset_Indentation;
686: END IF;
687:
688: EXCEPTION
689: WHEN OKC_API.G_EXCEPTION_ERROR THEN
690: x_return_status := OKC_API.HANDLE_EXCEPTIONS
691: (
692: l_api_name,
693: G_PKG_NAME,

Line 690: x_return_status := OKC_API.HANDLE_EXCEPTIONS

686: END IF;
687:
688: EXCEPTION
689: WHEN OKC_API.G_EXCEPTION_ERROR THEN
690: x_return_status := OKC_API.HANDLE_EXCEPTIONS
691: (
692: l_api_name,
693: G_PKG_NAME,
694: 'OKC_API.G_RET_STS_ERROR',

Line 694: 'OKC_API.G_RET_STS_ERROR',

690: x_return_status := OKC_API.HANDLE_EXCEPTIONS
691: (
692: l_api_name,
693: G_PKG_NAME,
694: 'OKC_API.G_RET_STS_ERROR',
695: x_msg_count,
696: x_msg_data,
697: '_PUB'
698: );

Line 704: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

700: okc_debug.Log('2000: Leaving ',2);
701: okc_debug.Reset_Indentation;
702: END IF;
703:
704: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
705: x_return_status := OKC_API.HANDLE_EXCEPTIONS
706: (
707: l_api_name,
708: G_PKG_NAME,

Line 705: x_return_status := OKC_API.HANDLE_EXCEPTIONS

701: okc_debug.Reset_Indentation;
702: END IF;
703:
704: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
705: x_return_status := OKC_API.HANDLE_EXCEPTIONS
706: (
707: l_api_name,
708: G_PKG_NAME,
709: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 709: 'OKC_API.G_RET_STS_UNEXP_ERROR',

705: x_return_status := OKC_API.HANDLE_EXCEPTIONS
706: (
707: l_api_name,
708: G_PKG_NAME,
709: 'OKC_API.G_RET_STS_UNEXP_ERROR',
710: x_msg_count,
711: x_msg_data,
712: '_PUB'
713: );

Line 720: x_return_status := OKC_API.HANDLE_EXCEPTIONS

716: okc_debug.Reset_Indentation;
717: END IF;
718:
719: WHEN OTHERS THEN
720: x_return_status := OKC_API.HANDLE_EXCEPTIONS
721: (
722: l_api_name,
723: G_PKG_NAME,
724: 'OTHERS',

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

738: x_msg_count OUT NOCOPY NUMBER,
739: x_msg_data OUT NOCOPY VARCHAR2,
740: p_ocev_tbl IN ocev_tbl_type) IS
741:
742: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
743: i NUMBER := 0;
744: --
745: l_proc varchar2(72) := ' okc_outcome_pub.'||'lock_outcome';
746: --

Line 755: x_return_status := OKC_API.G_RET_STS_SUCCESS;

751: okc_debug.Set_Indentation(l_proc);
752: okc_debug.Log('10: Entering ',2);
753: END IF;
754:
755: x_return_status := OKC_API.G_RET_STS_SUCCESS;
756: IF p_ocev_tbl.COUNT > 0 THEN
757: i := p_ocev_tbl.FIRST;
758: LOOP
759: lock_outcome(

Line 766: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

762: l_return_status,
763: x_msg_count,
764: x_msg_data,
765: p_ocev_tbl(i));
766: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
767: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
768: x_return_status := l_return_status;
769: raise G_EXCEPTION_HALT_VALIDATION;
770: ELSE

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

763: x_msg_count,
764: x_msg_data,
765: p_ocev_tbl(i));
766: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
767: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
768: x_return_status := l_return_status;
769: raise G_EXCEPTION_HALT_VALIDATION;
770: ELSE
771: x_return_status := l_return_status;

Line 793: OKC_API.set_message(p_app_name => g_app_name,

789: okc_debug.Reset_Indentation;
790: END IF;
791:
792: WHEN OTHERS THEN
793: OKC_API.set_message(p_app_name => g_app_name,
794: p_msg_name => g_unexpected_error,
795: p_token1 => g_sqlcode_token,
796: p_token1_value => sqlcode,
797: p_token2 => g_sqlerrm_token,

Line 799: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

795: p_token1 => g_sqlcode_token,
796: p_token1_value => sqlcode,
797: p_token2 => g_sqlerrm_token,
798: p_token2_value => sqlerrm);
799: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
800: IF (l_debug = 'Y') THEN
801: okc_debug.Log('3000: Leaving ',2);
802: okc_debug.Reset_Indentation;
803: END IF;

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

812: x_ocev_rec OUT NOCOPY ocev_rec_type) IS
813:
814: l_api_name CONSTANT VARCHAR2(30) := 'update_outcome';
815: l_api_version CONSTANT NUMBER := 1.0;
816: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
817: l_ocev_rec ocev_rec_type := p_ocev_rec;
818: --
819: l_proc varchar2(72) := ' okc_outcome_pub.'||'update_outcome';
820: --

Line 829: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

825: okc_debug.Set_Indentation(l_proc);
826: okc_debug.Log('10: Entering ',2);
827: END IF;
828:
829: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
830: g_pkg_name,
831: p_init_msg_list,
832: l_api_version,
833: p_api_version,

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

833: p_api_version,
834: '_PUB',
835: x_return_status);
836:
837: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
838: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
839: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
840: RAISE OKC_API.G_EXCEPTION_ERROR;
841: END IF;

Line 838: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

834: '_PUB',
835: x_return_status);
836:
837: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
838: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
839: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
840: RAISE OKC_API.G_EXCEPTION_ERROR;
841: END IF;
842:

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

835: x_return_status);
836:
837: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
838: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
839: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
840: RAISE OKC_API.G_EXCEPTION_ERROR;
841: END IF;
842:
843: -- USER HOOK CALL FOR BEFORE, STARTS

Line 840: RAISE OKC_API.G_EXCEPTION_ERROR;

836:
837: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
838: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
839: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
840: RAISE OKC_API.G_EXCEPTION_ERROR;
841: END IF;
842:
843: -- USER HOOK CALL FOR BEFORE, STARTS
844: g_ocev_rec := l_ocev_rec;

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

847: p_package_name => g_pkg_name,
848: p_procedure_name => l_api_name,
849: p_before_after => 'B');
850:
851: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
854: RAISE OKC_API.G_EXCEPTION_ERROR;
855: END IF;

Line 852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

848: p_procedure_name => l_api_name,
849: p_before_after => 'B');
850:
851: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
854: RAISE OKC_API.G_EXCEPTION_ERROR;
855: END IF;
856:

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

849: p_before_after => 'B');
850:
851: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
854: RAISE OKC_API.G_EXCEPTION_ERROR;
855: END IF;
856:
857: --get values back from hook call

Line 854: RAISE OKC_API.G_EXCEPTION_ERROR;

850:
851: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
854: RAISE OKC_API.G_EXCEPTION_ERROR;
855: END IF;
856:
857: --get values back from hook call
858: l_ocev_rec := migrate_ocev(l_ocev_rec, g_ocev_rec);

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

864: x_msg_count => x_msg_count,
865: x_msg_data => x_msg_data,
866: p_ocev_rec => l_ocev_rec,
867: x_ocev_rec => x_ocev_rec);
868: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
869: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
870: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
871: RAISE OKC_API.G_EXCEPTION_ERROR;
872: END IF;

Line 869: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

865: x_msg_data => x_msg_data,
866: p_ocev_rec => l_ocev_rec,
867: x_ocev_rec => x_ocev_rec);
868: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
869: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
870: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
871: RAISE OKC_API.G_EXCEPTION_ERROR;
872: END IF;
873:

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

866: p_ocev_rec => l_ocev_rec,
867: x_ocev_rec => x_ocev_rec);
868: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
869: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
870: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
871: RAISE OKC_API.G_EXCEPTION_ERROR;
872: END IF;
873:
874: --USER HOOK CALL FOR AFTER, STARTS

Line 871: RAISE OKC_API.G_EXCEPTION_ERROR;

867: x_ocev_rec => x_ocev_rec);
868: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
869: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
870: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
871: RAISE OKC_API.G_EXCEPTION_ERROR;
872: END IF;
873:
874: --USER HOOK CALL FOR AFTER, STARTS
875: g_ocev_rec := x_ocev_rec;

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

878: p_package_name => g_pkg_name,
879: p_procedure_name => l_api_name,
880: p_before_after => 'A');
881:
882: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
884: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
885: RAISE OKC_API.G_EXCEPTION_ERROR;
886: END IF;

Line 883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

879: p_procedure_name => l_api_name,
880: p_before_after => 'A');
881:
882: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
884: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
885: RAISE OKC_API.G_EXCEPTION_ERROR;
886: END IF;
887: --USER HOOK CALL FOR AFTER, ENDS

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

880: p_before_after => 'A');
881:
882: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
884: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
885: RAISE OKC_API.G_EXCEPTION_ERROR;
886: END IF;
887: --USER HOOK CALL FOR AFTER, ENDS
888:

Line 885: RAISE OKC_API.G_EXCEPTION_ERROR;

881:
882: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
884: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
885: RAISE OKC_API.G_EXCEPTION_ERROR;
886: END IF;
887: --USER HOOK CALL FOR AFTER, ENDS
888:
889: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

885: RAISE OKC_API.G_EXCEPTION_ERROR;
886: END IF;
887: --USER HOOK CALL FOR AFTER, ENDS
888:
889: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
890:
891:
892: IF (l_debug = 'Y') THEN
893: okc_debug.Log('1000: Leaving ',2);

Line 898: WHEN OKC_API.G_EXCEPTION_ERROR THEN

894: okc_debug.Reset_Indentation;
895: END IF;
896:
897: EXCEPTION
898: WHEN OKC_API.G_EXCEPTION_ERROR THEN
899: x_return_status := OKC_API.HANDLE_EXCEPTIONS
900: (
901: l_api_name,
902: G_PKG_NAME,

Line 899: x_return_status := OKC_API.HANDLE_EXCEPTIONS

895: END IF;
896:
897: EXCEPTION
898: WHEN OKC_API.G_EXCEPTION_ERROR THEN
899: x_return_status := OKC_API.HANDLE_EXCEPTIONS
900: (
901: l_api_name,
902: G_PKG_NAME,
903: 'OKC_API.G_RET_STS_ERROR',

Line 903: 'OKC_API.G_RET_STS_ERROR',

899: x_return_status := OKC_API.HANDLE_EXCEPTIONS
900: (
901: l_api_name,
902: G_PKG_NAME,
903: 'OKC_API.G_RET_STS_ERROR',
904: x_msg_count,
905: x_msg_data,
906: '_PUB'
907: );

Line 913: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

909: okc_debug.Log('2000: Leaving ',2);
910: okc_debug.Reset_Indentation;
911: END IF;
912:
913: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
914: x_return_status := OKC_API.HANDLE_EXCEPTIONS
915: (
916: l_api_name,
917: G_PKG_NAME,

Line 914: x_return_status := OKC_API.HANDLE_EXCEPTIONS

910: okc_debug.Reset_Indentation;
911: END IF;
912:
913: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
914: x_return_status := OKC_API.HANDLE_EXCEPTIONS
915: (
916: l_api_name,
917: G_PKG_NAME,
918: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 918: 'OKC_API.G_RET_STS_UNEXP_ERROR',

914: x_return_status := OKC_API.HANDLE_EXCEPTIONS
915: (
916: l_api_name,
917: G_PKG_NAME,
918: 'OKC_API.G_RET_STS_UNEXP_ERROR',
919: x_msg_count,
920: x_msg_data,
921: '_PUB'
922: );

Line 929: x_return_status := OKC_API.HANDLE_EXCEPTIONS

925: okc_debug.Reset_Indentation;
926: END IF;
927:
928: WHEN OTHERS THEN
929: x_return_status := OKC_API.HANDLE_EXCEPTIONS
930: (
931: l_api_name,
932: G_PKG_NAME,
933: 'OTHERS',

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

948: x_msg_data OUT NOCOPY VARCHAR2,
949: p_ocev_tbl IN ocev_tbl_type,
950: x_ocev_tbl OUT NOCOPY ocev_tbl_type) IS
951:
952: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
953: i NUMBER := 0;
954: --
955: l_proc varchar2(72) := ' okc_outcome_pub.'||'update_outcome';
956: --

Line 965: x_return_status := OKC_API.G_RET_STS_SUCCESS;

961: okc_debug.Set_Indentation(l_proc);
962: okc_debug.Log('10: Entering ',2);
963: END IF;
964:
965: x_return_status := OKC_API.G_RET_STS_SUCCESS;
966: IF p_ocev_tbl.COUNT > 0 THEN
967: i := p_ocev_tbl.FIRST;
968: LOOP
969: update_outcome(

Line 977: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

973: x_msg_count,
974: x_msg_data,
975: p_ocev_tbl(i),
976: x_ocev_tbl(i));
977: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
978: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
979: x_return_status := l_return_status;
980: raise G_EXCEPTION_HALT_VALIDATION;
981: ELSE

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

974: x_msg_data,
975: p_ocev_tbl(i),
976: x_ocev_tbl(i));
977: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
978: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
979: x_return_status := l_return_status;
980: raise G_EXCEPTION_HALT_VALIDATION;
981: ELSE
982: x_return_status := l_return_status;

Line 1004: OKC_API.set_message(p_app_name => g_app_name,

1000: okc_debug.Reset_Indentation;
1001: END IF;
1002:
1003: WHEN OTHERS THEN
1004: OKC_API.set_message(p_app_name => g_app_name,
1005: p_msg_name => g_unexpected_error,
1006: p_token1 => g_sqlcode_token,
1007: p_token1_value => sqlcode,
1008: p_token2 => g_sqlerrm_token,

Line 1010: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1006: p_token1 => g_sqlcode_token,
1007: p_token1_value => sqlcode,
1008: p_token2 => g_sqlerrm_token,
1009: p_token2_value => sqlerrm);
1010: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1011: IF (l_debug = 'Y') THEN
1012: okc_debug.Log('3000: Leaving ',2);
1013: okc_debug.Reset_Indentation;
1014: END IF;

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

1022: p_ocev_rec IN ocev_rec_type) IS
1023:
1024: l_api_name CONSTANT VARCHAR2(30) := 'delete_outcome';
1025: l_api_version CONSTANT NUMBER := 1.0;
1026: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1027: l_ocev_rec ocev_rec_type := p_ocev_rec;
1028: --
1029: l_proc varchar2(72) := ' okc_outcome_pub.'||'delete_outcome';
1030: --

Line 1039: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1035: okc_debug.Set_Indentation(l_proc);
1036: okc_debug.Log('10: Entering ',2);
1037: END IF;
1038:
1039: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1040: g_pkg_name,
1041: p_init_msg_list,
1042: l_api_version,
1043: p_api_version,

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

1043: p_api_version,
1044: '_PUB',
1045: x_return_status);
1046:
1047: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1048: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1049: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1050: RAISE OKC_API.G_EXCEPTION_ERROR;
1051: END IF;

Line 1048: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1044: '_PUB',
1045: x_return_status);
1046:
1047: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1048: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1049: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1050: RAISE OKC_API.G_EXCEPTION_ERROR;
1051: END IF;
1052:

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

1045: x_return_status);
1046:
1047: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1048: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1049: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1050: RAISE OKC_API.G_EXCEPTION_ERROR;
1051: END IF;
1052:
1053: -- USER HOOK CALL FOR BEFORE, STARTS

Line 1050: RAISE OKC_API.G_EXCEPTION_ERROR;

1046:
1047: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1048: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1049: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1050: RAISE OKC_API.G_EXCEPTION_ERROR;
1051: END IF;
1052:
1053: -- USER HOOK CALL FOR BEFORE, STARTS
1054: g_ocev_rec := l_ocev_rec;

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

1056: okc_util.call_user_hook(x_return_status => x_return_status,
1057: p_package_name => g_pkg_name,
1058: p_procedure_name => l_api_name,
1059: p_before_after => 'B');
1060: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1062: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1063: RAISE OKC_API.G_EXCEPTION_ERROR;
1064: END IF;

Line 1061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1057: p_package_name => g_pkg_name,
1058: p_procedure_name => l_api_name,
1059: p_before_after => 'B');
1060: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1062: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1063: RAISE OKC_API.G_EXCEPTION_ERROR;
1064: END IF;
1065:

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

1058: p_procedure_name => l_api_name,
1059: p_before_after => 'B');
1060: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1062: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1063: RAISE OKC_API.G_EXCEPTION_ERROR;
1064: END IF;
1065:
1066: --get values back from hook call

Line 1063: RAISE OKC_API.G_EXCEPTION_ERROR;

1059: p_before_after => 'B');
1060: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1062: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1063: RAISE OKC_API.G_EXCEPTION_ERROR;
1064: END IF;
1065:
1066: --get values back from hook call
1067: l_ocev_rec := migrate_ocev(l_ocev_rec, g_ocev_rec);

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

1072: x_return_status => x_return_status,
1073: x_msg_count => x_msg_count,
1074: x_msg_data => x_msg_data,
1075: p_ocev_rec => l_ocev_rec);
1076: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1077: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1078: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1079: RAISE OKC_API.G_EXCEPTION_ERROR;
1080: END IF;

Line 1077: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1073: x_msg_count => x_msg_count,
1074: x_msg_data => x_msg_data,
1075: p_ocev_rec => l_ocev_rec);
1076: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1077: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1078: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1079: RAISE OKC_API.G_EXCEPTION_ERROR;
1080: END IF;
1081:

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

1074: x_msg_data => x_msg_data,
1075: p_ocev_rec => l_ocev_rec);
1076: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1077: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1078: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1079: RAISE OKC_API.G_EXCEPTION_ERROR;
1080: END IF;
1081:
1082: --USER HOOK CALL FOR AFTER, STARTS

Line 1079: RAISE OKC_API.G_EXCEPTION_ERROR;

1075: p_ocev_rec => l_ocev_rec);
1076: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1077: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1078: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1079: RAISE OKC_API.G_EXCEPTION_ERROR;
1080: END IF;
1081:
1082: --USER HOOK CALL FOR AFTER, STARTS
1083: okc_util.call_user_hook(x_return_status => x_return_status,

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

1084: p_package_name => g_pkg_name,
1085: p_procedure_name => l_api_name,
1086: p_before_after => 'A');
1087:
1088: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1089: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1090: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1091: RAISE OKC_API.G_EXCEPTION_ERROR;
1092: END IF;

Line 1089: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1085: p_procedure_name => l_api_name,
1086: p_before_after => 'A');
1087:
1088: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1089: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1090: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1091: RAISE OKC_API.G_EXCEPTION_ERROR;
1092: END IF;
1093: --USER HOOK CALL FOR AFTER, ENDS

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

1086: p_before_after => 'A');
1087:
1088: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1089: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1090: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1091: RAISE OKC_API.G_EXCEPTION_ERROR;
1092: END IF;
1093: --USER HOOK CALL FOR AFTER, ENDS
1094:

Line 1091: RAISE OKC_API.G_EXCEPTION_ERROR;

1087:
1088: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1089: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1090: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1091: RAISE OKC_API.G_EXCEPTION_ERROR;
1092: END IF;
1093: --USER HOOK CALL FOR AFTER, ENDS
1094:
1095: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1091: RAISE OKC_API.G_EXCEPTION_ERROR;
1092: END IF;
1093: --USER HOOK CALL FOR AFTER, ENDS
1094:
1095: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1096:
1097:
1098: IF (l_debug = 'Y') THEN
1099: okc_debug.Log('1000: Leaving ',2);

Line 1104: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1100: okc_debug.Reset_Indentation;
1101: END IF;
1102:
1103: EXCEPTION
1104: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1105: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1106: (
1107: l_api_name,
1108: G_PKG_NAME,

Line 1105: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1101: END IF;
1102:
1103: EXCEPTION
1104: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1105: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1106: (
1107: l_api_name,
1108: G_PKG_NAME,
1109: 'OKC_API.G_RET_STS_ERROR',

Line 1109: 'OKC_API.G_RET_STS_ERROR',

1105: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1106: (
1107: l_api_name,
1108: G_PKG_NAME,
1109: 'OKC_API.G_RET_STS_ERROR',
1110: x_msg_count,
1111: x_msg_data,
1112: '_PUB'
1113: );

Line 1119: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1115: okc_debug.Log('2000: Leaving ',2);
1116: okc_debug.Reset_Indentation;
1117: END IF;
1118:
1119: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1120: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1121: (
1122: l_api_name,
1123: G_PKG_NAME,

Line 1120: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1116: okc_debug.Reset_Indentation;
1117: END IF;
1118:
1119: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1120: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1121: (
1122: l_api_name,
1123: G_PKG_NAME,
1124: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1124: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1120: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1121: (
1122: l_api_name,
1123: G_PKG_NAME,
1124: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1125: x_msg_count,
1126: x_msg_data,
1127: '_PUB'
1128: );

Line 1135: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1131: okc_debug.Reset_Indentation;
1132: END IF;
1133:
1134: WHEN OTHERS THEN
1135: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1136: (
1137: l_api_name,
1138: G_PKG_NAME,
1139: 'OTHERS',

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

1153: x_msg_count OUT NOCOPY NUMBER,
1154: x_msg_data OUT NOCOPY VARCHAR2,
1155: p_ocev_tbl IN ocev_tbl_type) IS
1156:
1157: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1158: i NUMBER := 0;
1159: --
1160: l_proc varchar2(72) := ' okc_outcome_pub.'||'delete_outcome';
1161: --

Line 1170: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1166: okc_debug.Set_Indentation(l_proc);
1167: okc_debug.Log('10: Entering ',2);
1168: END IF;
1169:
1170: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1171: IF p_ocev_tbl.COUNT > 0 THEN
1172: i := p_ocev_tbl.FIRST;
1173: LOOP
1174: delete_outcome(

Line 1181: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1177: l_return_status,
1178: x_msg_count,
1179: x_msg_data,
1180: p_ocev_tbl(i));
1181: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1182: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1183: x_return_status := l_return_status;
1184: raise G_EXCEPTION_HALT_VALIDATION;
1185: ELSE

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

1178: x_msg_count,
1179: x_msg_data,
1180: p_ocev_tbl(i));
1181: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1182: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1183: x_return_status := l_return_status;
1184: raise G_EXCEPTION_HALT_VALIDATION;
1185: ELSE
1186: x_return_status := l_return_status;

Line 1208: OKC_API.set_message(p_app_name => g_app_name,

1204: okc_debug.Reset_Indentation;
1205: END IF;
1206:
1207: WHEN OTHERS THEN
1208: OKC_API.set_message(p_app_name => g_app_name,
1209: p_msg_name => g_unexpected_error,
1210: p_token1 => g_sqlcode_token,
1211: p_token1_value => sqlcode,
1212: p_token2 => g_sqlerrm_token,

Line 1214: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1210: p_token1 => g_sqlcode_token,
1211: p_token1_value => sqlcode,
1212: p_token2 => g_sqlerrm_token,
1213: p_token2_value => sqlerrm);
1214: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1215: IF (l_debug = 'Y') THEN
1216: okc_debug.Log('3000: Leaving ',2);
1217: okc_debug.Reset_Indentation;
1218: END IF;

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

1226: p_ocev_rec IN ocev_rec_type) IS
1227:
1228: l_api_name CONSTANT VARCHAR2(30) := 'validate_outcome';
1229: l_api_version CONSTANT NUMBER := 1.0;
1230: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1231: l_ocev_rec ocev_rec_type := p_ocev_rec;
1232: --
1233: l_proc varchar2(72) := ' okc_outcome_pub.'||'validate_outcome';
1234: --

Line 1243: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1239: okc_debug.Set_Indentation(l_proc);
1240: okc_debug.Log('10: Entering ',2);
1241: END IF;
1242:
1243: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1244: g_pkg_name,
1245: p_init_msg_list,
1246: l_api_version,
1247: p_api_version,

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

1247: p_api_version,
1248: '_PUB',
1249: x_return_status);
1250:
1251: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1252: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1253: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1254: RAISE OKC_API.G_EXCEPTION_ERROR;
1255: END IF;

Line 1252: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1248: '_PUB',
1249: x_return_status);
1250:
1251: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1252: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1253: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1254: RAISE OKC_API.G_EXCEPTION_ERROR;
1255: END IF;
1256:

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

1249: x_return_status);
1250:
1251: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1252: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1253: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1254: RAISE OKC_API.G_EXCEPTION_ERROR;
1255: END IF;
1256:
1257: -- USER HOOK CALL FOR BEFORE, STARTS

Line 1254: RAISE OKC_API.G_EXCEPTION_ERROR;

1250:
1251: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1252: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1253: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1254: RAISE OKC_API.G_EXCEPTION_ERROR;
1255: END IF;
1256:
1257: -- USER HOOK CALL FOR BEFORE, STARTS
1258: g_ocev_rec := l_ocev_rec;

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

1261: p_package_name => g_pkg_name,
1262: p_procedure_name => l_api_name,
1263: p_before_after => 'B');
1264:
1265: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1267: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1268: RAISE OKC_API.G_EXCEPTION_ERROR;
1269: END IF;

Line 1266: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1262: p_procedure_name => l_api_name,
1263: p_before_after => 'B');
1264:
1265: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1267: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1268: RAISE OKC_API.G_EXCEPTION_ERROR;
1269: END IF;
1270:

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

1263: p_before_after => 'B');
1264:
1265: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1267: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1268: RAISE OKC_API.G_EXCEPTION_ERROR;
1269: END IF;
1270:
1271: --get values back from hook call

Line 1268: RAISE OKC_API.G_EXCEPTION_ERROR;

1264:
1265: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1267: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1268: RAISE OKC_API.G_EXCEPTION_ERROR;
1269: END IF;
1270:
1271: --get values back from hook call
1272: l_ocev_rec := migrate_ocev(l_ocev_rec, g_ocev_rec);

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

1277: x_return_status => x_return_status,
1278: x_msg_count => x_msg_count,
1279: x_msg_data => x_msg_data,
1280: p_ocev_rec => l_ocev_rec);
1281: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1282: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1283: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1284: RAISE OKC_API.G_EXCEPTION_ERROR;
1285: END IF;

Line 1282: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1278: x_msg_count => x_msg_count,
1279: x_msg_data => x_msg_data,
1280: p_ocev_rec => l_ocev_rec);
1281: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1282: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1283: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1284: RAISE OKC_API.G_EXCEPTION_ERROR;
1285: END IF;
1286:

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

1279: x_msg_data => x_msg_data,
1280: p_ocev_rec => l_ocev_rec);
1281: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1282: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1283: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1284: RAISE OKC_API.G_EXCEPTION_ERROR;
1285: END IF;
1286:
1287: --USER HOOK CALL FOR AFTER, STARTS

Line 1284: RAISE OKC_API.G_EXCEPTION_ERROR;

1280: p_ocev_rec => l_ocev_rec);
1281: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1282: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1283: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1284: RAISE OKC_API.G_EXCEPTION_ERROR;
1285: END IF;
1286:
1287: --USER HOOK CALL FOR AFTER, STARTS
1288:

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

1290: p_package_name => g_pkg_name,
1291: p_procedure_name => l_api_name,
1292: p_before_after => 'A');
1293:
1294: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1295: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1297: RAISE OKC_API.G_EXCEPTION_ERROR;
1298: END IF;

Line 1295: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1291: p_procedure_name => l_api_name,
1292: p_before_after => 'A');
1293:
1294: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1295: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1297: RAISE OKC_API.G_EXCEPTION_ERROR;
1298: END IF;
1299: --USER HOOK CALL FOR AFTER, ENDS

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

1292: p_before_after => 'A');
1293:
1294: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1295: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1297: RAISE OKC_API.G_EXCEPTION_ERROR;
1298: END IF;
1299: --USER HOOK CALL FOR AFTER, ENDS
1300:

Line 1297: RAISE OKC_API.G_EXCEPTION_ERROR;

1293:
1294: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1295: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1297: RAISE OKC_API.G_EXCEPTION_ERROR;
1298: END IF;
1299: --USER HOOK CALL FOR AFTER, ENDS
1300:
1301: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1297: RAISE OKC_API.G_EXCEPTION_ERROR;
1298: END IF;
1299: --USER HOOK CALL FOR AFTER, ENDS
1300:
1301: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1302:
1303: IF (l_debug = 'Y') THEN
1304: okc_debug.Log('1000: Leaving ',2);
1305: okc_debug.Reset_Indentation;

Line 1309: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1305: okc_debug.Reset_Indentation;
1306: END IF;
1307:
1308: EXCEPTION
1309: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1310: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1311: (
1312: l_api_name,
1313: G_PKG_NAME,

Line 1310: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1306: END IF;
1307:
1308: EXCEPTION
1309: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1310: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1311: (
1312: l_api_name,
1313: G_PKG_NAME,
1314: 'OKC_API.G_RET_STS_ERROR',

Line 1314: 'OKC_API.G_RET_STS_ERROR',

1310: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1311: (
1312: l_api_name,
1313: G_PKG_NAME,
1314: 'OKC_API.G_RET_STS_ERROR',
1315: x_msg_count,
1316: x_msg_data,
1317: '_PUB'
1318: );

Line 1324: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1320: okc_debug.Log('2000: Leaving ',2);
1321: okc_debug.Reset_Indentation;
1322: END IF;
1323:
1324: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1325: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1326: (
1327: l_api_name,
1328: G_PKG_NAME,

Line 1325: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1321: okc_debug.Reset_Indentation;
1322: END IF;
1323:
1324: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1325: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1326: (
1327: l_api_name,
1328: G_PKG_NAME,
1329: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1329: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1325: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1326: (
1327: l_api_name,
1328: G_PKG_NAME,
1329: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1330: x_msg_count,
1331: x_msg_data,
1332: '_PUB'
1333: );

Line 1340: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1336: okc_debug.Reset_Indentation;
1337: END IF;
1338:
1339: WHEN OTHERS THEN
1340: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1341: (
1342: l_api_name,
1343: G_PKG_NAME,
1344: 'OTHERS',

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

1357: x_return_status OUT NOCOPY VARCHAR2,
1358: x_msg_count OUT NOCOPY NUMBER,
1359: x_msg_data OUT NOCOPY VARCHAR2,
1360: p_ocev_tbl IN ocev_tbl_type) IS
1361: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1362: i NUMBER := 0;
1363: --
1364: l_proc varchar2(72) := ' okc_outcome_pub.'||'validate_outcome';
1365: --

Line 1374: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1370: okc_debug.Set_Indentation(l_proc);
1371: okc_debug.Log('10: Entering ',2);
1372: END IF;
1373:
1374: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1375: IF p_ocev_tbl.COUNT > 0 THEN
1376: i := p_ocev_tbl.FIRST;
1377: LOOP
1378: validate_outcome(

Line 1385: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1381: l_return_status,
1382: x_msg_count,
1383: x_msg_data,
1384: p_ocev_tbl(i));
1385: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1386: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1387: x_return_status := l_return_status;
1388: raise G_EXCEPTION_HALT_VALIDATION;
1389: ELSE

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

1382: x_msg_count,
1383: x_msg_data,
1384: p_ocev_tbl(i));
1385: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1386: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1387: x_return_status := l_return_status;
1388: raise G_EXCEPTION_HALT_VALIDATION;
1389: ELSE
1390: x_return_status := l_return_status;

Line 1412: OKC_API.set_message(p_app_name => g_app_name,

1408: okc_debug.Reset_Indentation;
1409: END IF;
1410:
1411: WHEN OTHERS THEN
1412: OKC_API.set_message(p_app_name => g_app_name,
1413: p_msg_name => g_unexpected_error,
1414: p_token1 => g_sqlcode_token,
1415: p_token1_value => sqlcode,
1416: p_token2 => g_sqlerrm_token,

Line 1418: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1414: p_token1 => g_sqlcode_token,
1415: p_token1_value => sqlcode,
1416: p_token2 => g_sqlerrm_token,
1417: p_token2_value => sqlerrm);
1418: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1419: IF (l_debug = 'Y') THEN
1420: okc_debug.Log('3000: Leaving ',2);
1421: okc_debug.Reset_Indentation;
1422: END IF;

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

1433: x_oatv_rec OUT NOCOPY oatv_rec_type) IS
1434:
1435: l_api_name CONSTANT VARCHAR2(30) := 'create_out_arg';
1436: l_api_version CONSTANT NUMBER := 1.0;
1437: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1438: l_oatv_rec oatv_rec_type := p_oatv_rec;
1439: --
1440: l_proc varchar2(72) := ' okc_outcome_pub.'||'create_out_arg';
1441: --

Line 1450: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1446: okc_debug.Set_Indentation(l_proc);
1447: okc_debug.Log('10: Entering ',2);
1448: END IF;
1449:
1450: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1451: g_pkg_name,
1452: p_init_msg_list,
1453: l_api_version,
1454: p_api_version,

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

1454: p_api_version,
1455: '_PUB',
1456: x_return_status);
1457:
1458: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1459: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1460: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1461: RAISE OKC_API.G_EXCEPTION_ERROR;
1462: END IF;

Line 1459: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1455: '_PUB',
1456: x_return_status);
1457:
1458: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1459: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1460: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1461: RAISE OKC_API.G_EXCEPTION_ERROR;
1462: END IF;
1463:

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

1456: x_return_status);
1457:
1458: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1459: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1460: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1461: RAISE OKC_API.G_EXCEPTION_ERROR;
1462: END IF;
1463:
1464: -- USER HOOK CALL FOR BEFORE, STARTS

Line 1461: RAISE OKC_API.G_EXCEPTION_ERROR;

1457:
1458: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1459: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1460: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1461: RAISE OKC_API.G_EXCEPTION_ERROR;
1462: END IF;
1463:
1464: -- USER HOOK CALL FOR BEFORE, STARTS
1465: g_oatv_rec := l_oatv_rec;

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

1468: p_package_name => g_pkg_name,
1469: p_procedure_name => l_api_name,
1470: p_before_after => 'B');
1471:
1472: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;

Line 1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1469: p_procedure_name => l_api_name,
1470: p_before_after => 'B');
1471:
1472: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477:

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

1470: p_before_after => 'B');
1471:
1472: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477:
1478: --get values back from hook call

Line 1475: RAISE OKC_API.G_EXCEPTION_ERROR;

1471:
1472: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477:
1478: --get values back from hook call
1479: l_oatv_rec := migrate_oatv(l_oatv_rec, g_oatv_rec);

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

1485: x_msg_count => x_msg_count,
1486: x_msg_data => x_msg_data,
1487: p_oatv_rec => l_oatv_rec,
1488: x_oatv_rec => x_oatv_rec);
1489: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1491: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1492: RAISE OKC_API.G_EXCEPTION_ERROR;
1493: END IF;

Line 1490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1486: x_msg_data => x_msg_data,
1487: p_oatv_rec => l_oatv_rec,
1488: x_oatv_rec => x_oatv_rec);
1489: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1491: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1492: RAISE OKC_API.G_EXCEPTION_ERROR;
1493: END IF;
1494:

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

1487: p_oatv_rec => l_oatv_rec,
1488: x_oatv_rec => x_oatv_rec);
1489: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1491: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1492: RAISE OKC_API.G_EXCEPTION_ERROR;
1493: END IF;
1494:
1495: --USER HOOK CALL FOR AFTER, STARTS

Line 1492: RAISE OKC_API.G_EXCEPTION_ERROR;

1488: x_oatv_rec => x_oatv_rec);
1489: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1490: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1491: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1492: RAISE OKC_API.G_EXCEPTION_ERROR;
1493: END IF;
1494:
1495: --USER HOOK CALL FOR AFTER, STARTS
1496: g_oatv_rec := x_oatv_rec;

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

1499: p_package_name => g_pkg_name,
1500: p_procedure_name => l_api_name,
1501: p_before_after => 'A');
1502:
1503: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1504: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1505: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1506: RAISE OKC_API.G_EXCEPTION_ERROR;
1507: END IF;

Line 1504: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1500: p_procedure_name => l_api_name,
1501: p_before_after => 'A');
1502:
1503: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1504: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1505: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1506: RAISE OKC_API.G_EXCEPTION_ERROR;
1507: END IF;
1508: --USER HOOK CALL FOR AFTER, ENDS

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

1501: p_before_after => 'A');
1502:
1503: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1504: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1505: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1506: RAISE OKC_API.G_EXCEPTION_ERROR;
1507: END IF;
1508: --USER HOOK CALL FOR AFTER, ENDS
1509:

Line 1506: RAISE OKC_API.G_EXCEPTION_ERROR;

1502:
1503: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1504: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1505: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1506: RAISE OKC_API.G_EXCEPTION_ERROR;
1507: END IF;
1508: --USER HOOK CALL FOR AFTER, ENDS
1509:
1510: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1506: RAISE OKC_API.G_EXCEPTION_ERROR;
1507: END IF;
1508: --USER HOOK CALL FOR AFTER, ENDS
1509:
1510: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1511:
1512:
1513: IF (l_debug = 'Y') THEN
1514: okc_debug.Log('1000: Leaving ',2);

Line 1519: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1515: okc_debug.Reset_Indentation;
1516: END IF;
1517:
1518: EXCEPTION
1519: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1520: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1521: (
1522: l_api_name,
1523: G_PKG_NAME,

Line 1520: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1516: END IF;
1517:
1518: EXCEPTION
1519: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1520: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1521: (
1522: l_api_name,
1523: G_PKG_NAME,
1524: 'OKC_API.G_RET_STS_ERROR',

Line 1524: 'OKC_API.G_RET_STS_ERROR',

1520: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1521: (
1522: l_api_name,
1523: G_PKG_NAME,
1524: 'OKC_API.G_RET_STS_ERROR',
1525: x_msg_count,
1526: x_msg_data,
1527: '_PUB'
1528: );

Line 1534: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1530: okc_debug.Log('2000: Leaving ',2);
1531: okc_debug.Reset_Indentation;
1532: END IF;
1533:
1534: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1535: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1536: (
1537: l_api_name,
1538: G_PKG_NAME,

Line 1535: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1531: okc_debug.Reset_Indentation;
1532: END IF;
1533:
1534: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1535: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1536: (
1537: l_api_name,
1538: G_PKG_NAME,
1539: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1539: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1535: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1536: (
1537: l_api_name,
1538: G_PKG_NAME,
1539: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1540: x_msg_count,
1541: x_msg_data,
1542: '_PUB'
1543: );

Line 1550: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1546: okc_debug.Reset_Indentation;
1547: END IF;
1548:
1549: WHEN OTHERS THEN
1550: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1551: (
1552: l_api_name,
1553: G_PKG_NAME,
1554: 'OTHERS',

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

1569: x_msg_data OUT NOCOPY VARCHAR2,
1570: p_oatv_tbl IN oatv_tbl_type,
1571: x_oatv_tbl OUT NOCOPY oatv_tbl_type) IS
1572:
1573: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1574: i NUMBER := 0;
1575: --
1576: l_proc varchar2(72) := ' okc_outcome_pub.'||'create_out_arg';
1577: --

Line 1587: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1583: okc_debug.Log('10: Entering ',2);
1584: END IF;
1585:
1586: --Initialize the return status
1587: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1588:
1589: IF p_oatv_tbl.COUNT > 0 THEN
1590: i := p_oatv_tbl.FIRST;
1591: LOOP

Line 1600: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1596: x_msg_count,
1597: x_msg_data,
1598: p_oatv_tbl(i),
1599: x_oatv_tbl(i));
1600: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1601: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1602: x_return_status := l_return_status;
1603: raise G_EXCEPTION_HALT_VALIDATION;
1604: ELSE

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

1597: x_msg_data,
1598: p_oatv_tbl(i),
1599: x_oatv_tbl(i));
1600: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1601: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1602: x_return_status := l_return_status;
1603: raise G_EXCEPTION_HALT_VALIDATION;
1604: ELSE
1605: x_return_status := l_return_status;

Line 1627: OKC_API.set_message(p_app_name => g_app_name,

1623: okc_debug.Reset_Indentation;
1624: END IF;
1625:
1626: WHEN OTHERS THEN
1627: OKC_API.set_message(p_app_name => g_app_name,
1628: p_msg_name => g_unexpected_error,
1629: p_token1 => g_sqlcode_token,
1630: p_token1_value => sqlcode,
1631: p_token2 => g_sqlerrm_token,

Line 1633: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1629: p_token1 => g_sqlcode_token,
1630: p_token1_value => sqlcode,
1631: p_token2 => g_sqlerrm_token,
1632: p_token2_value => sqlerrm);
1633: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1634: IF (l_debug = 'Y') THEN
1635: okc_debug.Log('3000: Leaving ',2);
1636: okc_debug.Reset_Indentation;
1637: END IF;

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

1644: x_msg_data OUT NOCOPY VARCHAR2,
1645: p_oatv_rec IN oatv_rec_type) IS
1646: l_api_name CONSTANT VARCHAR2(30) := 'lock_out_arg';
1647: l_api_version CONSTANT NUMBER := 1.0;
1648: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1649: l_oatv_rec oatv_rec_type := p_oatv_rec;
1650: --
1651: l_proc varchar2(72) := ' okc_outcome_pub.'||'lock_out_arg';
1652: --

Line 1661: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1657: okc_debug.Set_Indentation(l_proc);
1658: okc_debug.Log('10: Entering ',2);
1659: END IF;
1660:
1661: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1662: g_pkg_name,
1663: p_init_msg_list,
1664: l_api_version,
1665: p_api_version,

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

1665: p_api_version,
1666: '_PUB',
1667: x_return_status);
1668:
1669: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1670: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1671: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1672: RAISE OKC_API.G_EXCEPTION_ERROR;
1673: END IF;

Line 1670: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1666: '_PUB',
1667: x_return_status);
1668:
1669: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1670: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1671: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1672: RAISE OKC_API.G_EXCEPTION_ERROR;
1673: END IF;
1674:

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

1667: x_return_status);
1668:
1669: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1670: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1671: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1672: RAISE OKC_API.G_EXCEPTION_ERROR;
1673: END IF;
1674:
1675: -- Call to procedure of complex API

Line 1672: RAISE OKC_API.G_EXCEPTION_ERROR;

1668:
1669: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1670: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1671: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1672: RAISE OKC_API.G_EXCEPTION_ERROR;
1673: END IF;
1674:
1675: -- Call to procedure of complex API
1676: okc_outcome_pvt.lock_out_arg(p_api_version => p_api_version,

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

1679: x_msg_count => x_msg_count,
1680: x_msg_data => x_msg_data,
1681: p_oatv_rec => l_oatv_rec);
1682:
1683: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1684: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1685: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1686: RAISE OKC_API.G_EXCEPTION_ERROR;
1687: END IF;

Line 1684: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1680: x_msg_data => x_msg_data,
1681: p_oatv_rec => l_oatv_rec);
1682:
1683: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1684: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1685: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1686: RAISE OKC_API.G_EXCEPTION_ERROR;
1687: END IF;
1688:

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

1681: p_oatv_rec => l_oatv_rec);
1682:
1683: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1684: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1685: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1686: RAISE OKC_API.G_EXCEPTION_ERROR;
1687: END IF;
1688:
1689: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1686: RAISE OKC_API.G_EXCEPTION_ERROR;

1682:
1683: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1684: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1685: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1686: RAISE OKC_API.G_EXCEPTION_ERROR;
1687: END IF;
1688:
1689: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1690:

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

1685: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1686: RAISE OKC_API.G_EXCEPTION_ERROR;
1687: END IF;
1688:
1689: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1690:
1691:
1692: IF (l_debug = 'Y') THEN
1693: okc_debug.Log('1000: Leaving ',2);

Line 1698: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1694: okc_debug.Reset_Indentation;
1695: END IF;
1696:
1697: EXCEPTION
1698: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1699: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1700: (
1701: l_api_name,
1702: G_PKG_NAME,

Line 1699: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1695: END IF;
1696:
1697: EXCEPTION
1698: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1699: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1700: (
1701: l_api_name,
1702: G_PKG_NAME,
1703: 'OKC_API.G_RET_STS_ERROR',

Line 1703: 'OKC_API.G_RET_STS_ERROR',

1699: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1700: (
1701: l_api_name,
1702: G_PKG_NAME,
1703: 'OKC_API.G_RET_STS_ERROR',
1704: x_msg_count,
1705: x_msg_data,
1706: '_PUB'
1707: );

Line 1713: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1709: okc_debug.Log('2000: Leaving ',2);
1710: okc_debug.Reset_Indentation;
1711: END IF;
1712:
1713: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1714: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1715: (
1716: l_api_name,
1717: G_PKG_NAME,

Line 1714: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1710: okc_debug.Reset_Indentation;
1711: END IF;
1712:
1713: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1714: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1715: (
1716: l_api_name,
1717: G_PKG_NAME,
1718: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1718: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1714: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1715: (
1716: l_api_name,
1717: G_PKG_NAME,
1718: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1719: x_msg_count,
1720: x_msg_data,
1721: '_PUB'
1722: );

Line 1729: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1725: okc_debug.Reset_Indentation;
1726: END IF;
1727:
1728: WHEN OTHERS THEN
1729: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1730: (
1731: l_api_name,
1732: G_PKG_NAME,
1733: 'OTHERS',

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

1746: x_return_status OUT NOCOPY VARCHAR2,
1747: x_msg_count OUT NOCOPY NUMBER,
1748: x_msg_data OUT NOCOPY VARCHAR2,
1749: p_oatv_tbl IN oatv_tbl_type) IS
1750: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1751: i NUMBER := 0;
1752: --
1753: l_proc varchar2(72) := ' okc_outcome_pub.'||'lock_out_arg';
1754: --

Line 1763: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1759: okc_debug.Set_Indentation(l_proc);
1760: okc_debug.Log('10: Entering ',2);
1761: END IF;
1762:
1763: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1764: IF p_oatv_tbl.COUNT > 0 THEN
1765: i := p_oatv_tbl.FIRST;
1766: LOOP
1767: lock_out_arg(

Line 1774: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1770: l_return_status,
1771: x_msg_count,
1772: x_msg_data,
1773: p_oatv_tbl(i));
1774: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1775: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1776: x_return_status := l_return_status;
1777: raise G_EXCEPTION_HALT_VALIDATION;
1778: ELSE

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

1771: x_msg_count,
1772: x_msg_data,
1773: p_oatv_tbl(i));
1774: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1775: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1776: x_return_status := l_return_status;
1777: raise G_EXCEPTION_HALT_VALIDATION;
1778: ELSE
1779: x_return_status := l_return_status;

Line 1801: OKC_API.set_message(p_app_name => g_app_name,

1797: okc_debug.Reset_Indentation;
1798: END IF;
1799:
1800: WHEN OTHERS THEN
1801: OKC_API.set_message(p_app_name => g_app_name,
1802: p_msg_name => g_unexpected_error,
1803: p_token1 => g_sqlcode_token,
1804: p_token1_value => sqlcode,
1805: p_token2 => g_sqlerrm_token,

Line 1807: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1803: p_token1 => g_sqlcode_token,
1804: p_token1_value => sqlcode,
1805: p_token2 => g_sqlerrm_token,
1806: p_token2_value => sqlerrm);
1807: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1808: IF (l_debug = 'Y') THEN
1809: okc_debug.Log('3000: Leaving ',2);
1810: okc_debug.Reset_Indentation;
1811: END IF;

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

1820: x_oatv_rec OUT NOCOPY oatv_rec_type) IS
1821:
1822: l_api_name CONSTANT VARCHAR2(30) := 'update_out_arg';
1823: l_api_version CONSTANT NUMBER := 1.0;
1824: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1825: l_oatv_rec oatv_rec_type := p_oatv_rec;
1826: --
1827: l_proc varchar2(72) := ' okc_outcome_pub.'||'update_out_arg';
1828: --

Line 1837: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1833: okc_debug.Set_Indentation(l_proc);
1834: okc_debug.Log('10: Entering ',2);
1835: END IF;
1836:
1837: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1838: g_pkg_name,
1839: p_init_msg_list,
1840: l_api_version,
1841: p_api_version,

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

1840: l_api_version,
1841: p_api_version,
1842: '_PUB',
1843: x_return_status);
1844: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1845: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1846: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1847: RAISE OKC_API.G_EXCEPTION_ERROR;
1848: END IF;

Line 1845: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1841: p_api_version,
1842: '_PUB',
1843: x_return_status);
1844: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1845: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1846: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1847: RAISE OKC_API.G_EXCEPTION_ERROR;
1848: END IF;
1849:

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

1842: '_PUB',
1843: x_return_status);
1844: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1845: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1846: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1847: RAISE OKC_API.G_EXCEPTION_ERROR;
1848: END IF;
1849:
1850: -- USER HOOK CALL FOR BEFORE, STARTS

Line 1847: RAISE OKC_API.G_EXCEPTION_ERROR;

1843: x_return_status);
1844: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1845: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1846: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1847: RAISE OKC_API.G_EXCEPTION_ERROR;
1848: END IF;
1849:
1850: -- USER HOOK CALL FOR BEFORE, STARTS
1851: g_oatv_rec := l_oatv_rec;

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

1853: okc_util.call_user_hook(x_return_status => x_return_status,
1854: p_package_name => g_pkg_name,
1855: p_procedure_name => l_api_name,
1856: p_before_after => 'B');
1857: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1858: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1859: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1860: RAISE OKC_API.G_EXCEPTION_ERROR;
1861: END IF;

Line 1858: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1854: p_package_name => g_pkg_name,
1855: p_procedure_name => l_api_name,
1856: p_before_after => 'B');
1857: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1858: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1859: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1860: RAISE OKC_API.G_EXCEPTION_ERROR;
1861: END IF;
1862:

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

1855: p_procedure_name => l_api_name,
1856: p_before_after => 'B');
1857: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1858: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1859: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1860: RAISE OKC_API.G_EXCEPTION_ERROR;
1861: END IF;
1862:
1863: --get values back from hook call

Line 1860: RAISE OKC_API.G_EXCEPTION_ERROR;

1856: p_before_after => 'B');
1857: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1858: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1859: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1860: RAISE OKC_API.G_EXCEPTION_ERROR;
1861: END IF;
1862:
1863: --get values back from hook call
1864: l_oatv_rec := migrate_oatv(l_oatv_rec, g_oatv_rec);

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

1871: x_msg_data => x_msg_data,
1872: p_oatv_rec => l_oatv_rec,
1873: x_oatv_rec => x_oatv_rec);
1874:
1875: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1876: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1877: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1878: RAISE OKC_API.G_EXCEPTION_ERROR;
1879: END IF;

Line 1876: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1872: p_oatv_rec => l_oatv_rec,
1873: x_oatv_rec => x_oatv_rec);
1874:
1875: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1876: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1877: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1878: RAISE OKC_API.G_EXCEPTION_ERROR;
1879: END IF;
1880:

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

1873: x_oatv_rec => x_oatv_rec);
1874:
1875: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1876: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1877: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1878: RAISE OKC_API.G_EXCEPTION_ERROR;
1879: END IF;
1880:
1881: --USER HOOK CALL FOR AFTER, STARTS

Line 1878: RAISE OKC_API.G_EXCEPTION_ERROR;

1874:
1875: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1876: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1877: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1878: RAISE OKC_API.G_EXCEPTION_ERROR;
1879: END IF;
1880:
1881: --USER HOOK CALL FOR AFTER, STARTS
1882: g_oatv_rec := x_oatv_rec;

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

1884: okc_util.call_user_hook(x_return_status => x_return_status,
1885: p_package_name => g_pkg_name,
1886: p_procedure_name => l_api_name,
1887: p_before_after => 'A');
1888: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1889: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1890: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1891: RAISE OKC_API.G_EXCEPTION_ERROR;
1892: END IF;

Line 1889: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1885: p_package_name => g_pkg_name,
1886: p_procedure_name => l_api_name,
1887: p_before_after => 'A');
1888: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1889: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1890: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1891: RAISE OKC_API.G_EXCEPTION_ERROR;
1892: END IF;
1893: --USER HOOK CALL FOR AFTER, ENDS

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

1886: p_procedure_name => l_api_name,
1887: p_before_after => 'A');
1888: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1889: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1890: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1891: RAISE OKC_API.G_EXCEPTION_ERROR;
1892: END IF;
1893: --USER HOOK CALL FOR AFTER, ENDS
1894:

Line 1891: RAISE OKC_API.G_EXCEPTION_ERROR;

1887: p_before_after => 'A');
1888: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1889: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1890: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1891: RAISE OKC_API.G_EXCEPTION_ERROR;
1892: END IF;
1893: --USER HOOK CALL FOR AFTER, ENDS
1894:
1895: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1891: RAISE OKC_API.G_EXCEPTION_ERROR;
1892: END IF;
1893: --USER HOOK CALL FOR AFTER, ENDS
1894:
1895: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1896:
1897:
1898: IF (l_debug = 'Y') THEN
1899: okc_debug.Log('1000: Leaving ',2);

Line 1904: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1900: okc_debug.Reset_Indentation;
1901: END IF;
1902:
1903: EXCEPTION
1904: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1905: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1906: (
1907: l_api_name,
1908: G_PKG_NAME,

Line 1905: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1901: END IF;
1902:
1903: EXCEPTION
1904: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1905: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1906: (
1907: l_api_name,
1908: G_PKG_NAME,
1909: 'OKC_API.G_RET_STS_ERROR',

Line 1909: 'OKC_API.G_RET_STS_ERROR',

1905: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1906: (
1907: l_api_name,
1908: G_PKG_NAME,
1909: 'OKC_API.G_RET_STS_ERROR',
1910: x_msg_count,
1911: x_msg_data,
1912: '_PUB'
1913: );

Line 1919: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1915: okc_debug.Log('2000: Leaving ',2);
1916: okc_debug.Reset_Indentation;
1917: END IF;
1918:
1919: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1920: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1921: (
1922: l_api_name,
1923: G_PKG_NAME,

Line 1920: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1916: okc_debug.Reset_Indentation;
1917: END IF;
1918:
1919: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1920: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1921: (
1922: l_api_name,
1923: G_PKG_NAME,
1924: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1924: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1920: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1921: (
1922: l_api_name,
1923: G_PKG_NAME,
1924: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1925: x_msg_count,
1926: x_msg_data,
1927: '_PUB'
1928: );

Line 1935: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1931: okc_debug.Reset_Indentation;
1932: END IF;
1933:
1934: WHEN OTHERS THEN
1935: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1936: (
1937: l_api_name,
1938: G_PKG_NAME,
1939: 'OTHERS',

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

1954: x_msg_data OUT NOCOPY VARCHAR2,
1955: p_oatv_tbl IN oatv_tbl_type,
1956: x_oatv_tbl OUT NOCOPY oatv_tbl_type) IS
1957:
1958: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1959: i NUMBER := 0;
1960: --
1961: l_proc varchar2(72) := ' okc_outcome_pub.'||'update_out_arg';
1962: --

Line 1972: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1968: okc_debug.Log('10: Entering ',2);
1969: END IF;
1970:
1971: --Initialize the return status
1972: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1973:
1974: IF p_oatv_tbl.COUNT > 0 THEN
1975: i := p_oatv_tbl.FIRST;
1976: LOOP

Line 1985: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1981: x_msg_count,
1982: x_msg_data,
1983: p_oatv_tbl(i),
1984: x_oatv_tbl(i));
1985: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1987: x_return_status := l_return_status;
1988: raise G_EXCEPTION_HALT_VALIDATION;
1989: ELSE

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

1982: x_msg_data,
1983: p_oatv_tbl(i),
1984: x_oatv_tbl(i));
1985: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1987: x_return_status := l_return_status;
1988: raise G_EXCEPTION_HALT_VALIDATION;
1989: ELSE
1990: x_return_status := l_return_status;

Line 2012: OKC_API.set_message(p_app_name => g_app_name,

2008: okc_debug.Reset_Indentation;
2009: END IF;
2010:
2011: WHEN OTHERS THEN
2012: OKC_API.set_message(p_app_name => g_app_name,
2013: p_msg_name => g_unexpected_error,
2014: p_token1 => g_sqlcode_token,
2015: p_token1_value => sqlcode,
2016: p_token2 => g_sqlerrm_token,

Line 2018: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2014: p_token1 => g_sqlcode_token,
2015: p_token1_value => sqlcode,
2016: p_token2 => g_sqlerrm_token,
2017: p_token2_value => sqlerrm);
2018: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2019: IF (l_debug = 'Y') THEN
2020: okc_debug.Log('3000: Leaving ',2);
2021: okc_debug.Reset_Indentation;
2022: END IF;

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

2030: p_oatv_rec IN oatv_rec_type) IS
2031:
2032: l_api_name CONSTANT VARCHAR2(30) := 'delete_out_arg';
2033: l_api_version CONSTANT NUMBER := 1.0;
2034: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2035: l_oatv_rec oatv_rec_type := p_oatv_rec;
2036: --
2037: l_proc varchar2(72) := ' okc_outcome_pub.'||'delete_out_arg';
2038: --

Line 2047: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

2043: okc_debug.Set_Indentation(l_proc);
2044: okc_debug.Log('10: Entering ',2);
2045: END IF;
2046:
2047: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2048: g_pkg_name,
2049: p_init_msg_list,
2050: l_api_version,
2051: p_api_version,

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

2051: p_api_version,
2052: '_PUB',
2053: x_return_status);
2054:
2055: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2056: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2057: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2058: RAISE OKC_API.G_EXCEPTION_ERROR;
2059: END IF;

Line 2056: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2052: '_PUB',
2053: x_return_status);
2054:
2055: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2056: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2057: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2058: RAISE OKC_API.G_EXCEPTION_ERROR;
2059: END IF;
2060:

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

2053: x_return_status);
2054:
2055: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2056: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2057: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2058: RAISE OKC_API.G_EXCEPTION_ERROR;
2059: END IF;
2060:
2061: -- USER HOOK CALL FOR BEFORE, STARTS

Line 2058: RAISE OKC_API.G_EXCEPTION_ERROR;

2054:
2055: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2056: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2057: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2058: RAISE OKC_API.G_EXCEPTION_ERROR;
2059: END IF;
2060:
2061: -- USER HOOK CALL FOR BEFORE, STARTS
2062: g_oatv_rec := l_oatv_rec;

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

2064: okc_util.call_user_hook(x_return_status => x_return_status,
2065: p_package_name => g_pkg_name,
2066: p_procedure_name => l_api_name,
2067: p_before_after => 'B');
2068: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2070: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2071: RAISE OKC_API.G_EXCEPTION_ERROR;
2072: END IF;

Line 2069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2065: p_package_name => g_pkg_name,
2066: p_procedure_name => l_api_name,
2067: p_before_after => 'B');
2068: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2070: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2071: RAISE OKC_API.G_EXCEPTION_ERROR;
2072: END IF;
2073:

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

2066: p_procedure_name => l_api_name,
2067: p_before_after => 'B');
2068: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2070: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2071: RAISE OKC_API.G_EXCEPTION_ERROR;
2072: END IF;
2073:
2074: --get values back from hook call

Line 2071: RAISE OKC_API.G_EXCEPTION_ERROR;

2067: p_before_after => 'B');
2068: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2070: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2071: RAISE OKC_API.G_EXCEPTION_ERROR;
2072: END IF;
2073:
2074: --get values back from hook call
2075: l_oatv_rec := migrate_oatv(l_oatv_rec, g_oatv_rec);

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

2080: x_return_status => x_return_status,
2081: x_msg_count => x_msg_count,
2082: x_msg_data => x_msg_data,
2083: p_oatv_rec => l_oatv_rec);
2084: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2085: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2086: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2087: RAISE OKC_API.G_EXCEPTION_ERROR;
2088: END IF;

Line 2085: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2081: x_msg_count => x_msg_count,
2082: x_msg_data => x_msg_data,
2083: p_oatv_rec => l_oatv_rec);
2084: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2085: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2086: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2087: RAISE OKC_API.G_EXCEPTION_ERROR;
2088: END IF;
2089:

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

2082: x_msg_data => x_msg_data,
2083: p_oatv_rec => l_oatv_rec);
2084: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2085: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2086: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2087: RAISE OKC_API.G_EXCEPTION_ERROR;
2088: END IF;
2089:
2090: --USER HOOK CALL FOR AFTER, STARTS

Line 2087: RAISE OKC_API.G_EXCEPTION_ERROR;

2083: p_oatv_rec => l_oatv_rec);
2084: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2085: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2086: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2087: RAISE OKC_API.G_EXCEPTION_ERROR;
2088: END IF;
2089:
2090: --USER HOOK CALL FOR AFTER, STARTS
2091: okc_util.call_user_hook(x_return_status => x_return_status,

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

2092: p_package_name => g_pkg_name,
2093: p_procedure_name => l_api_name,
2094: p_before_after => 'A');
2095:
2096: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2097: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2098: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2099: RAISE OKC_API.G_EXCEPTION_ERROR;
2100: END IF;

Line 2097: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2093: p_procedure_name => l_api_name,
2094: p_before_after => 'A');
2095:
2096: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2097: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2098: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2099: RAISE OKC_API.G_EXCEPTION_ERROR;
2100: END IF;
2101: --USER HOOK CALL FOR AFTER, ENDS

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

2094: p_before_after => 'A');
2095:
2096: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2097: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2098: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2099: RAISE OKC_API.G_EXCEPTION_ERROR;
2100: END IF;
2101: --USER HOOK CALL FOR AFTER, ENDS
2102:

Line 2099: RAISE OKC_API.G_EXCEPTION_ERROR;

2095:
2096: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2097: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2098: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2099: RAISE OKC_API.G_EXCEPTION_ERROR;
2100: END IF;
2101: --USER HOOK CALL FOR AFTER, ENDS
2102:
2103: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2099: RAISE OKC_API.G_EXCEPTION_ERROR;
2100: END IF;
2101: --USER HOOK CALL FOR AFTER, ENDS
2102:
2103: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2104:
2105: IF (l_debug = 'Y') THEN
2106: okc_debug.Log('1000: Leaving ',2);
2107: okc_debug.Reset_Indentation;

Line 2111: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2107: okc_debug.Reset_Indentation;
2108: END IF;
2109:
2110: EXCEPTION
2111: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2112: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2113: (
2114: l_api_name,
2115: G_PKG_NAME,

Line 2112: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2108: END IF;
2109:
2110: EXCEPTION
2111: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2112: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2113: (
2114: l_api_name,
2115: G_PKG_NAME,
2116: 'OKC_API.G_RET_STS_ERROR',

Line 2116: 'OKC_API.G_RET_STS_ERROR',

2112: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2113: (
2114: l_api_name,
2115: G_PKG_NAME,
2116: 'OKC_API.G_RET_STS_ERROR',
2117: x_msg_count,
2118: x_msg_data,
2119: '_PUB'
2120: );

Line 2126: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2122: okc_debug.Log('2000: Leaving ',2);
2123: okc_debug.Reset_Indentation;
2124: END IF;
2125:
2126: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2127: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2128: (
2129: l_api_name,
2130: G_PKG_NAME,

Line 2127: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2123: okc_debug.Reset_Indentation;
2124: END IF;
2125:
2126: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2127: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2128: (
2129: l_api_name,
2130: G_PKG_NAME,
2131: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2131: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2127: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2128: (
2129: l_api_name,
2130: G_PKG_NAME,
2131: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2132: x_msg_count,
2133: x_msg_data,
2134: '_PUB'
2135: );

Line 2142: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2138: okc_debug.Reset_Indentation;
2139: END IF;
2140:
2141: WHEN OTHERS THEN
2142: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2143: (
2144: l_api_name,
2145: G_PKG_NAME,
2146: 'OTHERS',

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

2160: x_msg_count OUT NOCOPY NUMBER,
2161: x_msg_data OUT NOCOPY VARCHAR2,
2162: p_oatv_tbl IN oatv_tbl_type) IS
2163:
2164: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2165: i NUMBER := 0;
2166: --
2167: l_proc varchar2(72) := ' okc_outcome_pub.'||'delete_out_arg';
2168: --

Line 2178: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2174: okc_debug.Log('10: Entering ',2);
2175: END IF;
2176:
2177: --Initialize the return status
2178: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2179:
2180: IF p_oatv_tbl.COUNT > 0 THEN
2181: i := p_oatv_tbl.FIRST;
2182: LOOP

Line 2190: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2186: x_return_status,
2187: x_msg_count,
2188: x_msg_data,
2189: p_oatv_tbl(i));
2190: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2191: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
2192: l_return_status := x_return_status;
2193: RAISE G_EXCEPTION_HALT_VALIDATION;
2194: ELSE

Line 2191: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

2187: x_msg_count,
2188: x_msg_data,
2189: p_oatv_tbl(i));
2190: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2191: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
2192: l_return_status := x_return_status;
2193: RAISE G_EXCEPTION_HALT_VALIDATION;
2194: ELSE
2195: l_return_status := x_return_status; -- record that there was an error

Line 2217: OKC_API.set_message(p_app_name => g_app_name,

2213: okc_debug.Reset_Indentation;
2214: END IF;
2215:
2216: WHEN OTHERS THEN
2217: OKC_API.set_message(p_app_name => g_app_name,
2218: p_msg_name => g_unexpected_error,
2219: p_token1 => g_sqlcode_token,
2220: p_token1_value => sqlcode,
2221: p_token2 => g_sqlerrm_token,

Line 2223: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2219: p_token1 => g_sqlcode_token,
2220: p_token1_value => sqlcode,
2221: p_token2 => g_sqlerrm_token,
2222: p_token2_value => sqlerrm);
2223: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2224: IF (l_debug = 'Y') THEN
2225: okc_debug.Log('3000: Leaving ',2);
2226: okc_debug.Reset_Indentation;
2227: END IF;

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

2235: p_oatv_rec IN oatv_rec_type) IS
2236:
2237: l_api_name CONSTANT VARCHAR2(30) := 'validate_out_arg';
2238: l_api_version CONSTANT NUMBER := 1.0;
2239: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2240: l_oatv_rec oatv_rec_type := p_oatv_rec;
2241: --
2242: l_proc varchar2(72) := ' okc_outcome_pub.'||'validate_out_arg';
2243: --

Line 2252: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

2248: okc_debug.Set_Indentation(l_proc);
2249: okc_debug.Log('10: Entering ',2);
2250: END IF;
2251:
2252: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2253: g_pkg_name,
2254: p_init_msg_list,
2255: l_api_version,
2256: p_api_version,

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

2256: p_api_version,
2257: '_PUB',
2258: x_return_status);
2259:
2260: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2262: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2263: RAISE OKC_API.G_EXCEPTION_ERROR;
2264: END IF;

Line 2261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2257: '_PUB',
2258: x_return_status);
2259:
2260: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2262: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2263: RAISE OKC_API.G_EXCEPTION_ERROR;
2264: END IF;
2265:

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

2258: x_return_status);
2259:
2260: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2262: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2263: RAISE OKC_API.G_EXCEPTION_ERROR;
2264: END IF;
2265:
2266: -- USER HOOK CALL FOR BEFORE, STARTS

Line 2263: RAISE OKC_API.G_EXCEPTION_ERROR;

2259:
2260: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2262: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2263: RAISE OKC_API.G_EXCEPTION_ERROR;
2264: END IF;
2265:
2266: -- USER HOOK CALL FOR BEFORE, STARTS
2267: g_oatv_rec := l_oatv_rec;

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

2269: okc_util.call_user_hook(x_return_status => x_return_status,
2270: p_package_name => g_pkg_name,
2271: p_procedure_name => l_api_name,
2272: p_before_after => 'B');
2273: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2275: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2276: RAISE OKC_API.G_EXCEPTION_ERROR;
2277: END IF;

Line 2274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2270: p_package_name => g_pkg_name,
2271: p_procedure_name => l_api_name,
2272: p_before_after => 'B');
2273: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2275: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2276: RAISE OKC_API.G_EXCEPTION_ERROR;
2277: END IF;
2278:

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

2271: p_procedure_name => l_api_name,
2272: p_before_after => 'B');
2273: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2275: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2276: RAISE OKC_API.G_EXCEPTION_ERROR;
2277: END IF;
2278:
2279: --get values back from hook call

Line 2276: RAISE OKC_API.G_EXCEPTION_ERROR;

2272: p_before_after => 'B');
2273: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2275: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2276: RAISE OKC_API.G_EXCEPTION_ERROR;
2277: END IF;
2278:
2279: --get values back from hook call
2280: l_oatv_rec := migrate_oatv(l_oatv_rec, g_oatv_rec);

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

2286: x_msg_count => x_msg_count,
2287: x_msg_data => x_msg_data,
2288: p_oatv_rec => l_oatv_rec);
2289:
2290: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2291: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2292: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2293: RAISE OKC_API.G_EXCEPTION_ERROR;
2294: END IF;

Line 2291: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2287: x_msg_data => x_msg_data,
2288: p_oatv_rec => l_oatv_rec);
2289:
2290: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2291: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2292: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2293: RAISE OKC_API.G_EXCEPTION_ERROR;
2294: END IF;
2295:

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

2288: p_oatv_rec => l_oatv_rec);
2289:
2290: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2291: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2292: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2293: RAISE OKC_API.G_EXCEPTION_ERROR;
2294: END IF;
2295:
2296: --USER HOOK CALL FOR AFTER, STARTS

Line 2293: RAISE OKC_API.G_EXCEPTION_ERROR;

2289:
2290: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2291: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2292: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2293: RAISE OKC_API.G_EXCEPTION_ERROR;
2294: END IF;
2295:
2296: --USER HOOK CALL FOR AFTER, STARTS
2297: okc_util.call_user_hook(x_return_status => x_return_status,

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

2297: okc_util.call_user_hook(x_return_status => x_return_status,
2298: p_package_name => g_pkg_name,
2299: p_procedure_name => l_api_name,
2300: p_before_after => 'A');
2301: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2302: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2303: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2304: RAISE OKC_API.G_EXCEPTION_ERROR;
2305: END IF;

Line 2302: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2298: p_package_name => g_pkg_name,
2299: p_procedure_name => l_api_name,
2300: p_before_after => 'A');
2301: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2302: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2303: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2304: RAISE OKC_API.G_EXCEPTION_ERROR;
2305: END IF;
2306: --USER HOOK CALL FOR AFTER, ENDS

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

2299: p_procedure_name => l_api_name,
2300: p_before_after => 'A');
2301: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2302: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2303: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2304: RAISE OKC_API.G_EXCEPTION_ERROR;
2305: END IF;
2306: --USER HOOK CALL FOR AFTER, ENDS
2307:

Line 2304: RAISE OKC_API.G_EXCEPTION_ERROR;

2300: p_before_after => 'A');
2301: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2302: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2303: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2304: RAISE OKC_API.G_EXCEPTION_ERROR;
2305: END IF;
2306: --USER HOOK CALL FOR AFTER, ENDS
2307:
2308: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2304: RAISE OKC_API.G_EXCEPTION_ERROR;
2305: END IF;
2306: --USER HOOK CALL FOR AFTER, ENDS
2307:
2308: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2309:
2310:
2311: IF (l_debug = 'Y') THEN
2312: okc_debug.Log('1000: Leaving ',2);

Line 2317: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2313: okc_debug.Reset_Indentation;
2314: END IF;
2315:
2316: EXCEPTION
2317: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2318: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2319: (
2320: l_api_name,
2321: G_PKG_NAME,

Line 2318: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2314: END IF;
2315:
2316: EXCEPTION
2317: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2318: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2319: (
2320: l_api_name,
2321: G_PKG_NAME,
2322: 'OKC_API.G_RET_STS_ERROR',

Line 2322: 'OKC_API.G_RET_STS_ERROR',

2318: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2319: (
2320: l_api_name,
2321: G_PKG_NAME,
2322: 'OKC_API.G_RET_STS_ERROR',
2323: x_msg_count,
2324: x_msg_data,
2325: '_PUB'
2326: );

Line 2332: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2328: okc_debug.Log('2000: Leaving ',2);
2329: okc_debug.Reset_Indentation;
2330: END IF;
2331:
2332: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2333: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2334: (
2335: l_api_name,
2336: G_PKG_NAME,

Line 2333: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2329: okc_debug.Reset_Indentation;
2330: END IF;
2331:
2332: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2333: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2334: (
2335: l_api_name,
2336: G_PKG_NAME,
2337: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2337: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2333: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2334: (
2335: l_api_name,
2336: G_PKG_NAME,
2337: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2338: x_msg_count,
2339: x_msg_data,
2340: '_PUB'
2341: );

Line 2348: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2344: okc_debug.Reset_Indentation;
2345: END IF;
2346:
2347: WHEN OTHERS THEN
2348: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2349: (
2350: l_api_name,
2351: G_PKG_NAME,
2352: 'OTHERS',

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

2366: x_msg_count OUT NOCOPY NUMBER,
2367: x_msg_data OUT NOCOPY VARCHAR2,
2368: p_oatv_tbl IN oatv_tbl_type) IS
2369:
2370: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2371: i NUMBER := 0;
2372: --
2373: l_proc varchar2(72) := ' okc_outcome_pub.'||'validate_out_arg';
2374: --

Line 2384: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2380: okc_debug.Log('10: Entering ',2);
2381: END IF;
2382:
2383: --Initialize the return status
2384: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2385:
2386: IF p_oatv_tbl.COUNT > 0 THEN
2387: i := p_oatv_tbl.FIRST;
2388: LOOP

Line 2396: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2392: l_return_status,
2393: x_msg_count,
2394: x_msg_data,
2395: p_oatv_tbl(i));
2396: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2397: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2398: x_return_status := l_return_status;
2399: raise G_EXCEPTION_HALT_VALIDATION;
2400: ELSE

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

2393: x_msg_count,
2394: x_msg_data,
2395: p_oatv_tbl(i));
2396: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2397: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2398: x_return_status := l_return_status;
2399: raise G_EXCEPTION_HALT_VALIDATION;
2400: ELSE
2401: x_return_status := l_return_status;

Line 2423: OKC_API.set_message(p_app_name => g_app_name,

2419: okc_debug.Reset_Indentation;
2420: END IF;
2421:
2422: WHEN OTHERS THEN
2423: OKC_API.set_message(p_app_name => g_app_name,
2424: p_msg_name => g_unexpected_error,
2425: p_token1 => g_sqlcode_token,
2426: p_token1_value => sqlcode,
2427: p_token2 => g_sqlerrm_token,

Line 2429: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2425: p_token1 => g_sqlcode_token,
2426: p_token1_value => sqlcode,
2427: p_token2 => g_sqlerrm_token,
2428: p_token2_value => sqlerrm);
2429: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2430: IF (l_debug = 'Y') THEN
2431: okc_debug.Log('3000: Leaving ',2);
2432: okc_debug.Reset_Indentation;
2433: END IF;