eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_XLA_EVENTS_PVT dependencies on OKL_API

Line 112: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

108:
109: RAISE EVENT_CLASS_CODE_EXCP;
110: END IF;
111:
112: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
113:
114: EXCEPTION
115: WHEN NO_DATA_FOUND THEN
116: Okl_Api.set_message(p_app_name => g_app_name,

Line 116: Okl_Api.set_message(p_app_name => g_app_name,

112: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
113:
114: EXCEPTION
115: WHEN NO_DATA_FOUND THEN
116: Okl_Api.set_message(p_app_name => g_app_name,
117: p_msg_name => 'OKL_AM_NO_TRX_TYPE_FOUND',
118: p_token1 => 'TRY_NAME',
119: p_token1_value => p_try_id);
120:

Line 121: x_return_status := Okl_Api.G_RET_STS_ERROR;

117: p_msg_name => 'OKL_AM_NO_TRX_TYPE_FOUND',
118: p_token1 => 'TRY_NAME',
119: p_token1_value => p_try_id);
120:
121: x_return_status := Okl_Api.G_RET_STS_ERROR;
122:
123: WHEN EVENT_CLASS_CODE_EXCP THEN
124: Okl_Api.set_message(p_app_name => g_app_name,
125: p_msg_name => 'OKL_INVALID_EVENT_CLASS',

Line 124: Okl_Api.set_message(p_app_name => g_app_name,

120:
121: x_return_status := Okl_Api.G_RET_STS_ERROR;
122:
123: WHEN EVENT_CLASS_CODE_EXCP THEN
124: Okl_Api.set_message(p_app_name => g_app_name,
125: p_msg_name => 'OKL_INVALID_EVENT_CLASS',
126: p_token1 => 'TRANSACTION_TYPE',
127: p_token1_value => l_trx_type_name);
128:

Line 129: x_return_status := Okl_Api.G_RET_STS_ERROR;

125: p_msg_name => 'OKL_INVALID_EVENT_CLASS',
126: p_token1 => 'TRANSACTION_TYPE',
127: p_token1_value => l_trx_type_name);
128:
129: x_return_status := Okl_Api.G_RET_STS_ERROR;
130:
131: END get_entity_event_class;
132:
133: -------------------------------------------------------------------------------

Line 184: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

180: l_msg_data VARCHAR2(2000);
181:
182: BEGIN
183:
184: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
185: ,G_PKG_NAME
186: ,p_init_msg_list
187: ,l_api_version
188: ,p_api_version

Line 192: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

188: ,p_api_version
189: ,'_PVT'
190: ,x_return_status);
191:
192: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
194: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
195: RAISE Okl_Api.G_EXCEPTION_ERROR;
196: END IF;

Line 193: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

189: ,'_PVT'
190: ,x_return_status);
191:
192: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
194: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
195: RAISE Okl_Api.G_EXCEPTION_ERROR;
196: END IF;
197:

Line 194: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

190: ,x_return_status);
191:
192: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
194: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
195: RAISE Okl_Api.G_EXCEPTION_ERROR;
196: END IF;
197:
198: WRITE_TO_LOG('');

Line 195: RAISE Okl_Api.G_EXCEPTION_ERROR;

191:
192: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
194: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
195: RAISE Okl_Api.G_EXCEPTION_ERROR;
196: END IF;
197:
198: WRITE_TO_LOG('');
199: WRITE_TO_LOG('Inside the call to CREATE_EVENT');

Line 228: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

224: ,x_entity_type_code => l_entity_type_code
225: ,x_event_class_code => l_event_class_code
226: ,x_return_status => l_return_status);
227:
228: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
229: RAISE Okl_Api.G_EXCEPTION_ERROR;
230: END IF;
231:
232: l_event_source_info.source_application_id := g_application_id;

Line 229: RAISE Okl_Api.G_EXCEPTION_ERROR;

225: ,x_event_class_code => l_event_class_code
226: ,x_return_status => l_return_status);
227:
228: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
229: RAISE Okl_Api.G_EXCEPTION_ERROR;
230: END IF;
231:
232: l_event_source_info.source_application_id := g_application_id;
233: l_event_source_info.application_id := g_application_id;

Line 280: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

276: ,p_security_context => l_security_context
277: );
278: EXCEPTION
279: WHEN OTHERS THEN
280: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
281: p_msg_name => g_unexpected_error,
282: p_token1 => g_sqlcode_token,
283: p_token1_value => SQLCODE,
284: p_token2 => g_sqlerrm_token,

Line 287: RAISE Okl_Api.G_EXCEPTION_ERROR;

283: p_token1_value => SQLCODE,
284: p_token2 => g_sqlerrm_token,
285: p_token2_value => SQLERRM);
286:
287: RAISE Okl_Api.G_EXCEPTION_ERROR;
288: END;
289:
290: WRITE_TO_LOG('');
291: WRITE_TO_LOG('Done with CREATE_EVENT');

Line 293: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

289:
290: WRITE_TO_LOG('');
291: WRITE_TO_LOG('Done with CREATE_EVENT');
292:
293: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
294: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
295:
296: return l_event_id;
297:

Line 294: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

290: WRITE_TO_LOG('');
291: WRITE_TO_LOG('Done with CREATE_EVENT');
292:
293: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
294: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
295:
296: return l_event_id;
297:
298: EXCEPTION

Line 299: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

295:
296: return l_event_id;
297:
298: EXCEPTION
299: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
300: IF get_tcn_csr%ISOPEN THEN
301: CLOSE get_tcn_csr;
302: END IF;
303:

Line 304: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

300: IF get_tcn_csr%ISOPEN THEN
301: CLOSE get_tcn_csr;
302: END IF;
303:
304: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
305: ,g_pkg_name
306: ,'OKL_API.G_RET_STS_ERROR'
307: ,x_msg_count
308: ,x_msg_data

Line 306: ,'OKL_API.G_RET_STS_ERROR'

302: END IF;
303:
304: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
305: ,g_pkg_name
306: ,'OKL_API.G_RET_STS_ERROR'
307: ,x_msg_count
308: ,x_msg_data
309: ,'_PVT');
310: RETURN -1;

Line 311: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

307: ,x_msg_count
308: ,x_msg_data
309: ,'_PVT');
310: RETURN -1;
311: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
312: IF get_tcn_csr%ISOPEN THEN
313: CLOSE get_tcn_csr;
314: END IF;
315:

Line 316: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

312: IF get_tcn_csr%ISOPEN THEN
313: CLOSE get_tcn_csr;
314: END IF;
315:
316: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
317: p_msg_name => g_unexpected_error,
318: p_token1 => g_sqlcode_token,
319: p_token1_value => SQLCODE,
320: p_token2 => g_sqlerrm_token,

Line 323: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

319: p_token1_value => SQLCODE,
320: p_token2 => g_sqlerrm_token,
321: p_token2_value => SQLERRM);
322:
323: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
324: ,g_pkg_name
325: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
326: ,x_msg_count
327: ,x_msg_data

Line 325: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

321: p_token2_value => SQLERRM);
322:
323: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
324: ,g_pkg_name
325: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
326: ,x_msg_count
327: ,x_msg_data
328: ,'_PVT');
329: RETURN -1;

Line 336: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

332: IF get_tcn_csr%ISOPEN THEN
333: CLOSE get_tcn_csr;
334: END IF;
335:
336: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
337: (l_api_name,
338: G_PKG_NAME,
339: 'OTHERS',
340: x_msg_count,

Line 391: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

387: l_sla_api_name VARCHAR2(30);
388: l_return_status VARCHAR2(1);
389: BEGIN
390:
391: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
392: ,G_PKG_NAME
393: ,p_init_msg_list
394: ,l_api_version
395: ,p_api_version

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

395: ,p_api_version
396: ,'_PVT'
397: ,x_return_status);
398:
399: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
400: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
401: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
402: RAISE Okl_Api.G_EXCEPTION_ERROR;
403: END IF;

Line 400: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

396: ,'_PVT'
397: ,x_return_status);
398:
399: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
400: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
401: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
402: RAISE Okl_Api.G_EXCEPTION_ERROR;
403: END IF;
404:

Line 401: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

397: ,x_return_status);
398:
399: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
400: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
401: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
402: RAISE Okl_Api.G_EXCEPTION_ERROR;
403: END IF;
404:
405: WRITE_TO_LOG('');

Line 402: RAISE Okl_Api.G_EXCEPTION_ERROR;

398:
399: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
400: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
401: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
402: RAISE Okl_Api.G_EXCEPTION_ERROR;
403: END IF;
404:
405: WRITE_TO_LOG('');
406: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 436: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

432: ,x_entity_type_code => l_entity_type_code
433: ,x_event_class_code => l_event_class_code
434: ,x_return_status => l_return_status);
435:
436: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
437: RAISE Okl_Api.G_EXCEPTION_ERROR;
438: END IF;
439:
440: l_event_source_info.source_application_id := g_application_id;

Line 437: RAISE Okl_Api.G_EXCEPTION_ERROR;

433: ,x_event_class_code => l_event_class_code
434: ,x_return_status => l_return_status);
435:
436: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
437: RAISE Okl_Api.G_EXCEPTION_ERROR;
438: END IF;
439:
440: l_event_source_info.source_application_id := g_application_id;
441: l_event_source_info.application_id := g_application_id;

Line 484: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

480: ,p_valuation_method => p_representation_code
481: ,p_security_context => l_security_context);
482: EXCEPTION
483: WHEN OTHERS THEN
484: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
485: p_msg_name => g_unexpected_error,
486: p_token1 => g_sqlcode_token,
487: p_token1_value => SQLCODE,
488: p_token2 => g_sqlerrm_token,

Line 491: RAISE Okl_Api.G_EXCEPTION_ERROR;

487: p_token1_value => SQLCODE,
488: p_token2 => g_sqlerrm_token,
489: p_token2_value => SQLERRM);
490:
491: RAISE Okl_Api.G_EXCEPTION_ERROR;
492: END;
493:
494: WRITE_TO_LOG('');
495: WRITE_TO_LOG('Done with ' || l_api_name);

Line 497: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

493:
494: WRITE_TO_LOG('');
495: WRITE_TO_LOG('Done with ' || l_api_name);
496:
497: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
498: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
499:
500: EXCEPTION
501: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

Line 498: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

494: WRITE_TO_LOG('');
495: WRITE_TO_LOG('Done with ' || l_api_name);
496:
497: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
498: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
499:
500: EXCEPTION
501: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
502: IF get_tcn_csr%ISOPEN THEN

Line 501: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

497: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
498: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
499:
500: EXCEPTION
501: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
502: IF get_tcn_csr%ISOPEN THEN
503: CLOSE get_tcn_csr;
504: END IF;
505:

Line 506: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

502: IF get_tcn_csr%ISOPEN THEN
503: CLOSE get_tcn_csr;
504: END IF;
505:
506: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
507: ,g_pkg_name
508: ,'OKL_API.G_RET_STS_ERROR'
509: ,x_msg_count
510: ,x_msg_data

Line 508: ,'OKL_API.G_RET_STS_ERROR'

504: END IF;
505:
506: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
507: ,g_pkg_name
508: ,'OKL_API.G_RET_STS_ERROR'
509: ,x_msg_count
510: ,x_msg_data
511: ,'_PVT');
512:

Line 513: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

509: ,x_msg_count
510: ,x_msg_data
511: ,'_PVT');
512:
513: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
514: IF get_tcn_csr%ISOPEN THEN
515: CLOSE get_tcn_csr;
516: END IF;
517:

Line 518: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

514: IF get_tcn_csr%ISOPEN THEN
515: CLOSE get_tcn_csr;
516: END IF;
517:
518: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
519: p_msg_name => g_unexpected_error,
520: p_token1 => g_sqlcode_token,
521: p_token1_value => SQLCODE,
522: p_token2 => g_sqlerrm_token,

Line 525: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

521: p_token1_value => SQLCODE,
522: p_token2 => g_sqlerrm_token,
523: p_token2_value => SQLERRM);
524:
525: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
526: ,g_pkg_name
527: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
528: ,x_msg_count
529: ,x_msg_data

Line 527: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

523: p_token2_value => SQLERRM);
524:
525: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
526: ,g_pkg_name
527: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
528: ,x_msg_count
529: ,x_msg_data
530: ,'_PVT');
531:

Line 537: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

533: IF get_tcn_csr%ISOPEN THEN
534: CLOSE get_tcn_csr;
535: END IF;
536:
537: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
538: (l_api_name,
539: G_PKG_NAME,
540: 'OTHERS',
541: x_msg_count,

Line 594: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

590: l_return_status VARCHAR2(1);
591: l_sla_api_name VARCHAR2(60);
592:
593: BEGIN
594: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
595: ,G_PKG_NAME
596: ,p_init_msg_list
597: ,l_api_version
598: ,p_api_version

Line 602: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

598: ,p_api_version
599: ,'_PVT'
600: ,x_return_status);
601:
602: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
603: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
604: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
605: RAISE Okl_Api.G_EXCEPTION_ERROR;
606: END IF;

Line 603: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

599: ,'_PVT'
600: ,x_return_status);
601:
602: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
603: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
604: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
605: RAISE Okl_Api.G_EXCEPTION_ERROR;
606: END IF;
607:

Line 604: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

600: ,x_return_status);
601:
602: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
603: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
604: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
605: RAISE Okl_Api.G_EXCEPTION_ERROR;
606: END IF;
607:
608: WRITE_TO_LOG('');

Line 605: RAISE Okl_Api.G_EXCEPTION_ERROR;

601:
602: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
603: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
604: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
605: RAISE Okl_Api.G_EXCEPTION_ERROR;
606: END IF;
607:
608: WRITE_TO_LOG('');
609: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 643: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

639: ,x_entity_type_code => l_entity_type_code
640: ,x_event_class_code => l_event_class_code
641: ,x_return_status => l_return_status);
642:
643: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
644: RAISE Okl_Api.G_EXCEPTION_ERROR;
645: END IF;
646:
647: l_event_source_info.source_application_id := g_application_id;

Line 644: RAISE Okl_Api.G_EXCEPTION_ERROR;

640: ,x_event_class_code => l_event_class_code
641: ,x_return_status => l_return_status);
642:
643: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
644: RAISE Okl_Api.G_EXCEPTION_ERROR;
645: END IF;
646:
647: l_event_source_info.source_application_id := g_application_id;
648: l_event_source_info.application_id := g_application_id;

Line 736: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

732:
733: END IF;
734: EXCEPTION
735: WHEN OTHERS THEN
736: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
737: p_msg_name => g_unexpected_error,
738: p_token1 => g_sqlcode_token,
739: p_token1_value => SQLCODE,
740: p_token2 => g_sqlerrm_token,

Line 743: RAISE Okl_Api.G_EXCEPTION_ERROR;

739: p_token1_value => SQLCODE,
740: p_token2 => g_sqlerrm_token,
741: p_token2_value => SQLERRM);
742:
743: RAISE Okl_Api.G_EXCEPTION_ERROR;
744: END;
745:
746: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
747: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 746: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

742:
743: RAISE Okl_Api.G_EXCEPTION_ERROR;
744: END;
745:
746: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
747: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
748:
749: WRITE_TO_LOG('');
750: WRITE_TO_LOG('Done with ' || l_api_name);

Line 747: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

743: RAISE Okl_Api.G_EXCEPTION_ERROR;
744: END;
745:
746: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
747: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
748:
749: WRITE_TO_LOG('');
750: WRITE_TO_LOG('Done with ' || l_api_name);
751:

Line 753: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

749: WRITE_TO_LOG('');
750: WRITE_TO_LOG('Done with ' || l_api_name);
751:
752: EXCEPTION
753: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
754: IF get_tcn_csr%ISOPEN THEN
755: CLOSE get_tcn_csr;
756: END IF;
757:

Line 758: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

754: IF get_tcn_csr%ISOPEN THEN
755: CLOSE get_tcn_csr;
756: END IF;
757:
758: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
759: ,g_pkg_name
760: ,'OKL_API.G_RET_STS_ERROR'
761: ,x_msg_count
762: ,x_msg_data

Line 760: ,'OKL_API.G_RET_STS_ERROR'

756: END IF;
757:
758: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
759: ,g_pkg_name
760: ,'OKL_API.G_RET_STS_ERROR'
761: ,x_msg_count
762: ,x_msg_data
763: ,'_PVT');
764:

Line 765: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

761: ,x_msg_count
762: ,x_msg_data
763: ,'_PVT');
764:
765: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
766: IF get_tcn_csr%ISOPEN THEN
767: CLOSE get_tcn_csr;
768: END IF;
769:

Line 770: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

766: IF get_tcn_csr%ISOPEN THEN
767: CLOSE get_tcn_csr;
768: END IF;
769:
770: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
771: p_msg_name => g_unexpected_error,
772: p_token1 => g_sqlcode_token,
773: p_token1_value => SQLCODE,
774: p_token2 => g_sqlerrm_token,

Line 777: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

773: p_token1_value => SQLCODE,
774: p_token2 => g_sqlerrm_token,
775: p_token2_value => SQLERRM);
776:
777: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
778: ,g_pkg_name
779: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
780: ,x_msg_count
781: ,x_msg_data

Line 779: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

775: p_token2_value => SQLERRM);
776:
777: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
778: ,g_pkg_name
779: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
780: ,x_msg_count
781: ,x_msg_data
782: ,'_PVT');
783:

Line 789: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

785: IF get_tcn_csr%ISOPEN THEN
786: CLOSE get_tcn_csr;
787: END IF;
788:
789: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
790: (l_api_name,
791: G_PKG_NAME,
792: 'OTHERS',
793: x_msg_count,

Line 840: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

836: l_return_status VARCHAR2(1);
837: l_sla_api_name VARCHAR2(60);
838:
839: BEGIN
840: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
841: ,G_PKG_NAME
842: ,p_init_msg_list
843: ,l_api_version
844: ,p_api_version

Line 848: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

844: ,p_api_version
845: ,'_PVT'
846: ,x_return_status);
847:
848: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
849: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
850: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
851: RAISE Okl_Api.G_EXCEPTION_ERROR;
852: END IF;

Line 849: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

845: ,'_PVT'
846: ,x_return_status);
847:
848: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
849: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
850: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
851: RAISE Okl_Api.G_EXCEPTION_ERROR;
852: END IF;
853:

Line 850: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

846: ,x_return_status);
847:
848: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
849: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
850: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
851: RAISE Okl_Api.G_EXCEPTION_ERROR;
852: END IF;
853:
854: WRITE_TO_LOG('');

Line 851: RAISE Okl_Api.G_EXCEPTION_ERROR;

847:
848: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
849: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
850: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
851: RAISE Okl_Api.G_EXCEPTION_ERROR;
852: END IF;
853:
854: WRITE_TO_LOG('');
855: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 884: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

880: ,x_entity_type_code => l_entity_type_code
881: ,x_event_class_code => l_event_class_code
882: ,x_return_status => l_return_status);
883:
884: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
885: RAISE Okl_Api.G_EXCEPTION_ERROR;
886: END IF;
887:
888: l_event_source_info.source_application_id := g_application_id;

Line 885: RAISE Okl_Api.G_EXCEPTION_ERROR;

881: ,x_event_class_code => l_event_class_code
882: ,x_return_status => l_return_status);
883:
884: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
885: RAISE Okl_Api.G_EXCEPTION_ERROR;
886: END IF;
887:
888: l_event_source_info.source_application_id := g_application_id;
889: l_event_source_info.application_id := g_application_id;

Line 925: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

921: ,p_security_context => l_security_context);
922:
923: EXCEPTION
924: WHEN OTHERS THEN
925: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
926: p_msg_name => g_unexpected_error,
927: p_token1 => g_sqlcode_token,
928: p_token1_value => SQLCODE,
929: p_token2 => g_sqlerrm_token,

Line 932: RAISE Okl_Api.G_EXCEPTION_ERROR;

928: p_token1_value => SQLCODE,
929: p_token2 => g_sqlerrm_token,
930: p_token2_value => SQLERRM);
931:
932: RAISE Okl_Api.G_EXCEPTION_ERROR;
933: END;
934:
935: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
936: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 935: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

931:
932: RAISE Okl_Api.G_EXCEPTION_ERROR;
933: END;
934:
935: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
936: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
937:
938: WRITE_TO_LOG('');
939: WRITE_TO_LOG('Done with ' || l_api_name);

Line 936: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

932: RAISE Okl_Api.G_EXCEPTION_ERROR;
933: END;
934:
935: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
936: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
937:
938: WRITE_TO_LOG('');
939: WRITE_TO_LOG('Done with ' || l_api_name);
940:

Line 942: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

938: WRITE_TO_LOG('');
939: WRITE_TO_LOG('Done with ' || l_api_name);
940:
941: EXCEPTION
942: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
943: IF get_tcn_csr%ISOPEN THEN
944: CLOSE get_tcn_csr;
945: END IF;
946:

Line 947: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

943: IF get_tcn_csr%ISOPEN THEN
944: CLOSE get_tcn_csr;
945: END IF;
946:
947: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
948: ,g_pkg_name
949: ,'OKL_API.G_RET_STS_ERROR'
950: ,x_msg_count
951: ,x_msg_data

Line 949: ,'OKL_API.G_RET_STS_ERROR'

945: END IF;
946:
947: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
948: ,g_pkg_name
949: ,'OKL_API.G_RET_STS_ERROR'
950: ,x_msg_count
951: ,x_msg_data
952: ,'_PVT');
953:

Line 954: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

950: ,x_msg_count
951: ,x_msg_data
952: ,'_PVT');
953:
954: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
955: IF get_tcn_csr%ISOPEN THEN
956: CLOSE get_tcn_csr;
957: END IF;
958:

Line 959: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

955: IF get_tcn_csr%ISOPEN THEN
956: CLOSE get_tcn_csr;
957: END IF;
958:
959: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
960: p_msg_name => g_unexpected_error,
961: p_token1 => g_sqlcode_token,
962: p_token1_value => SQLCODE,
963: p_token2 => g_sqlerrm_token,

Line 966: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

962: p_token1_value => SQLCODE,
963: p_token2 => g_sqlerrm_token,
964: p_token2_value => SQLERRM);
965:
966: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
967: ,g_pkg_name
968: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
969: ,x_msg_count
970: ,x_msg_data

Line 968: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

964: p_token2_value => SQLERRM);
965:
966: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
967: ,g_pkg_name
968: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
969: ,x_msg_count
970: ,x_msg_data
971: ,'_PVT');
972:

Line 978: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

974: IF get_tcn_csr%ISOPEN THEN
975: CLOSE get_tcn_csr;
976: END IF;
977:
978: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
979: (l_api_name,
980: G_PKG_NAME,
981: 'OTHERS',
982: x_msg_count,

Line 1014: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

1010: l_sla_api_name VARCHAR2(30);
1011: l_return_status VARCHAR2(1);
1012: BEGIN
1013:
1014: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
1015: ,G_PKG_NAME
1016: ,p_init_msg_list
1017: ,l_api_version
1018: ,p_api_version

Line 1022: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1018: ,p_api_version
1019: ,'_PVT'
1020: ,x_return_status);
1021:
1022: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1023: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1024: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1025: RAISE Okl_Api.G_EXCEPTION_ERROR;
1026: END IF;

Line 1023: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1019: ,'_PVT'
1020: ,x_return_status);
1021:
1022: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1023: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1024: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1025: RAISE Okl_Api.G_EXCEPTION_ERROR;
1026: END IF;
1027:

Line 1024: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

1020: ,x_return_status);
1021:
1022: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1023: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1024: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1025: RAISE Okl_Api.G_EXCEPTION_ERROR;
1026: END IF;
1027:
1028: WRITE_TO_LOG('');

Line 1025: RAISE Okl_Api.G_EXCEPTION_ERROR;

1021:
1022: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1023: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1024: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1025: RAISE Okl_Api.G_EXCEPTION_ERROR;
1026: END IF;
1027:
1028: WRITE_TO_LOG('');
1029: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 1056: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1052: ,x_entity_type_code => l_entity_type_code
1053: ,x_event_class_code => l_event_class_code
1054: ,x_return_status => l_return_status);
1055:
1056: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1057: RAISE Okl_Api.G_EXCEPTION_ERROR;
1058: END IF;
1059:
1060: FORALL i IN 1..p_tcn_tbl.COUNT

Line 1057: RAISE Okl_Api.G_EXCEPTION_ERROR;

1053: ,x_event_class_code => l_event_class_code
1054: ,x_return_status => l_return_status);
1055:
1056: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1057: RAISE Okl_Api.G_EXCEPTION_ERROR;
1058: END IF;
1059:
1060: FORALL i IN 1..p_tcn_tbl.COUNT
1061: INSERT INTO xla_events_int_gt(

Line 1086: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1082: l_sla_api_name := 'UPDATE_BULK_EVENT_STATUSES';
1083: XLA_EVENTS_PUB_PKG.update_bulk_event_statuses(p_application_id => g_application_id);
1084: EXCEPTION
1085: WHEN OTHERS THEN
1086: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1087: p_msg_name => g_unexpected_error,
1088: p_token1 => g_sqlcode_token,
1089: p_token1_value => SQLCODE,
1090: p_token2 => g_sqlerrm_token,

Line 1093: RAISE Okl_Api.G_EXCEPTION_ERROR;

1089: p_token1_value => SQLCODE,
1090: p_token2 => g_sqlerrm_token,
1091: p_token2_value => SQLERRM);
1092:
1093: RAISE Okl_Api.G_EXCEPTION_ERROR;
1094: END;
1095:
1096: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1097: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1096: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1092:
1093: RAISE Okl_Api.G_EXCEPTION_ERROR;
1094: END;
1095:
1096: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1097: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1098:
1099: WRITE_TO_LOG('');
1100: WRITE_TO_LOG('Done with ' || l_api_name);

Line 1097: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1093: RAISE Okl_Api.G_EXCEPTION_ERROR;
1094: END;
1095:
1096: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1097: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1098:
1099: WRITE_TO_LOG('');
1100: WRITE_TO_LOG('Done with ' || l_api_name);
1101:

Line 1103: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1099: WRITE_TO_LOG('');
1100: WRITE_TO_LOG('Done with ' || l_api_name);
1101:
1102: EXCEPTION
1103: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1104: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1105: ,g_pkg_name
1106: ,'OKL_API.G_RET_STS_ERROR'
1107: ,x_msg_count

Line 1104: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1100: WRITE_TO_LOG('Done with ' || l_api_name);
1101:
1102: EXCEPTION
1103: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1104: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1105: ,g_pkg_name
1106: ,'OKL_API.G_RET_STS_ERROR'
1107: ,x_msg_count
1108: ,x_msg_data

Line 1106: ,'OKL_API.G_RET_STS_ERROR'

1102: EXCEPTION
1103: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1104: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1105: ,g_pkg_name
1106: ,'OKL_API.G_RET_STS_ERROR'
1107: ,x_msg_count
1108: ,x_msg_data
1109: ,'_PVT');
1110:

Line 1111: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1107: ,x_msg_count
1108: ,x_msg_data
1109: ,'_PVT');
1110:
1111: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1112: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1113: p_msg_name => g_unexpected_error,
1114: p_token1 => g_sqlcode_token,
1115: p_token1_value => SQLCODE,

Line 1112: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1108: ,x_msg_data
1109: ,'_PVT');
1110:
1111: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1112: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1113: p_msg_name => g_unexpected_error,
1114: p_token1 => g_sqlcode_token,
1115: p_token1_value => SQLCODE,
1116: p_token2 => g_sqlerrm_token,

Line 1119: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1115: p_token1_value => SQLCODE,
1116: p_token2 => g_sqlerrm_token,
1117: p_token2_value => SQLERRM);
1118:
1119: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1120: ,g_pkg_name
1121: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1122: ,x_msg_count
1123: ,x_msg_data

Line 1121: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1117: p_token2_value => SQLERRM);
1118:
1119: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1120: ,g_pkg_name
1121: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1122: ,x_msg_count
1123: ,x_msg_data
1124: ,'_PVT');
1125:

Line 1127: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1123: ,x_msg_data
1124: ,'_PVT');
1125:
1126: WHEN OTHERS THEN
1127: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1128: (l_api_name,
1129: G_PKG_NAME,
1130: 'OTHERS',
1131: x_msg_count,

Line 1177: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

1173: l_return_status VARCHAR2(1);
1174:
1175: BEGIN
1176:
1177: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
1178: ,G_PKG_NAME
1179: ,p_init_msg_list
1180: ,l_api_version
1181: ,p_api_version

Line 1185: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1181: ,p_api_version
1182: ,'_PVT'
1183: ,x_return_status);
1184:
1185: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1188: RAISE Okl_Api.G_EXCEPTION_ERROR;
1189: END IF;

Line 1186: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1182: ,'_PVT'
1183: ,x_return_status);
1184:
1185: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1188: RAISE Okl_Api.G_EXCEPTION_ERROR;
1189: END IF;
1190:

Line 1187: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

1183: ,x_return_status);
1184:
1185: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1188: RAISE Okl_Api.G_EXCEPTION_ERROR;
1189: END IF;
1190:
1191: WRITE_TO_LOG('');

Line 1188: RAISE Okl_Api.G_EXCEPTION_ERROR;

1184:
1185: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1188: RAISE Okl_Api.G_EXCEPTION_ERROR;
1189: END IF;
1190:
1191: WRITE_TO_LOG('');
1192: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 1220: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1216: ,x_entity_type_code => l_entity_type_code
1217: ,x_event_class_code => l_event_class_code
1218: ,x_return_status => l_return_status);
1219:
1220: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1221: RAISE Okl_Api.G_EXCEPTION_ERROR;
1222: END IF;
1223:
1224: l_event_source_info.source_application_id := g_application_id;

Line 1221: RAISE Okl_Api.G_EXCEPTION_ERROR;

1217: ,x_event_class_code => l_event_class_code
1218: ,x_return_status => l_return_status);
1219:
1220: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1221: RAISE Okl_Api.G_EXCEPTION_ERROR;
1222: END IF;
1223:
1224: l_event_source_info.source_application_id := g_application_id;
1225: l_event_source_info.application_id := g_application_id;

Line 1259: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1255: ,p_valuation_method => p_representation_code
1256: ,p_security_context => l_security_context);
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1260: p_msg_name => g_unexpected_error,
1261: p_token1 => g_sqlcode_token,
1262: p_token1_value => SQLCODE,
1263: p_token2 => g_sqlerrm_token,

Line 1266: RAISE Okl_Api.G_EXCEPTION_ERROR;

1262: p_token1_value => SQLCODE,
1263: p_token2 => g_sqlerrm_token,
1264: p_token2_value => SQLERRM);
1265:
1266: RAISE Okl_Api.G_EXCEPTION_ERROR;
1267: END;
1268:
1269: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1270: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1269: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1265:
1266: RAISE Okl_Api.G_EXCEPTION_ERROR;
1267: END;
1268:
1269: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1270: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1271:
1272: WRITE_TO_LOG('');
1273: WRITE_TO_LOG('Done with ' || l_api_name);

Line 1270: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1266: RAISE Okl_Api.G_EXCEPTION_ERROR;
1267: END;
1268:
1269: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1270: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1271:
1272: WRITE_TO_LOG('');
1273: WRITE_TO_LOG('Done with ' || l_api_name);
1274:

Line 1276: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1272: WRITE_TO_LOG('');
1273: WRITE_TO_LOG('Done with ' || l_api_name);
1274:
1275: EXCEPTION
1276: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1277: IF get_tcn_csr%ISOPEN THEN
1278: CLOSE get_tcn_csr;
1279: END IF;
1280:

Line 1281: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1277: IF get_tcn_csr%ISOPEN THEN
1278: CLOSE get_tcn_csr;
1279: END IF;
1280:
1281: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1282: ,g_pkg_name
1283: ,'OKL_API.G_RET_STS_ERROR'
1284: ,x_msg_count
1285: ,x_msg_data

Line 1283: ,'OKL_API.G_RET_STS_ERROR'

1279: END IF;
1280:
1281: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1282: ,g_pkg_name
1283: ,'OKL_API.G_RET_STS_ERROR'
1284: ,x_msg_count
1285: ,x_msg_data
1286: ,'_PVT');
1287:

Line 1288: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1284: ,x_msg_count
1285: ,x_msg_data
1286: ,'_PVT');
1287:
1288: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1289: IF get_tcn_csr%ISOPEN THEN
1290: CLOSE get_tcn_csr;
1291: END IF;
1292:

Line 1293: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1289: IF get_tcn_csr%ISOPEN THEN
1290: CLOSE get_tcn_csr;
1291: END IF;
1292:
1293: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1294: p_msg_name => g_unexpected_error,
1295: p_token1 => g_sqlcode_token,
1296: p_token1_value => SQLCODE,
1297: p_token2 => g_sqlerrm_token,

Line 1300: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1296: p_token1_value => SQLCODE,
1297: p_token2 => g_sqlerrm_token,
1298: p_token2_value => SQLERRM);
1299:
1300: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1301: ,g_pkg_name
1302: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1303: ,x_msg_count
1304: ,x_msg_data

Line 1302: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1298: p_token2_value => SQLERRM);
1299:
1300: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1301: ,g_pkg_name
1302: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1303: ,x_msg_count
1304: ,x_msg_data
1305: ,'_PVT');
1306:

Line 1312: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1308: IF get_tcn_csr%ISOPEN THEN
1309: CLOSE get_tcn_csr;
1310: END IF;
1311:
1312: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1313: (l_api_name,
1314: G_PKG_NAME,
1315: 'OTHERS',
1316: x_msg_count,

Line 1364: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

1360: l_return_status VARCHAR2(1);
1361: l_events_deleted NUMBER;
1362:
1363: BEGIN
1364: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
1365: ,G_PKG_NAME
1366: ,p_init_msg_list
1367: ,l_api_version
1368: ,p_api_version

Line 1372: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1368: ,p_api_version
1369: ,'_PVT'
1370: ,x_return_status);
1371:
1372: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1373: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1374: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1375: RAISE Okl_Api.G_EXCEPTION_ERROR;
1376: END IF;

Line 1373: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1369: ,'_PVT'
1370: ,x_return_status);
1371:
1372: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1373: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1374: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1375: RAISE Okl_Api.G_EXCEPTION_ERROR;
1376: END IF;
1377:

Line 1374: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

1370: ,x_return_status);
1371:
1372: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1373: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1374: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1375: RAISE Okl_Api.G_EXCEPTION_ERROR;
1376: END IF;
1377:
1378: WRITE_TO_LOG('');

Line 1375: RAISE Okl_Api.G_EXCEPTION_ERROR;

1371:
1372: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1373: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1374: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1375: RAISE Okl_Api.G_EXCEPTION_ERROR;
1376: END IF;
1377:
1378: WRITE_TO_LOG('');
1379: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 1408: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1404: ,x_entity_type_code => l_entity_type_code
1405: ,x_event_class_code => l_event_class_code
1406: ,x_return_status => l_return_status);
1407:
1408: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1409: RAISE Okl_Api.G_EXCEPTION_ERROR;
1410: END IF;
1411:
1412: l_event_source_info.source_application_id := g_application_id;

Line 1409: RAISE Okl_Api.G_EXCEPTION_ERROR;

1405: ,x_event_class_code => l_event_class_code
1406: ,x_return_status => l_return_status);
1407:
1408: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1409: RAISE Okl_Api.G_EXCEPTION_ERROR;
1410: END IF;
1411:
1412: l_event_source_info.source_application_id := g_application_id;
1413: l_event_source_info.application_id := g_application_id;

Line 1455: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1451: ,p_valuation_method => p_representation_code
1452: ,p_security_context => l_security_context);
1453: EXCEPTION
1454: WHEN OTHERS THEN
1455: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1456: p_msg_name => g_unexpected_error,
1457: p_token1 => g_sqlcode_token,
1458: p_token1_value => SQLCODE,
1459: p_token2 => g_sqlerrm_token,

Line 1462: RAISE Okl_Api.G_EXCEPTION_ERROR;

1458: p_token1_value => SQLCODE,
1459: p_token2 => g_sqlerrm_token,
1460: p_token2_value => SQLERRM);
1461:
1462: RAISE Okl_Api.G_EXCEPTION_ERROR;
1463: END;
1464:
1465: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1466: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1465: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1461:
1462: RAISE Okl_Api.G_EXCEPTION_ERROR;
1463: END;
1464:
1465: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1466: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1467:
1468: WRITE_TO_LOG('');
1469: WRITE_TO_LOG('Done with ' || l_api_name);

Line 1466: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1462: RAISE Okl_Api.G_EXCEPTION_ERROR;
1463: END;
1464:
1465: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1466: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1467:
1468: WRITE_TO_LOG('');
1469: WRITE_TO_LOG('Done with ' || l_api_name);
1470:

Line 1474: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1470:
1471: return l_events_deleted;
1472:
1473: EXCEPTION
1474: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1475: IF get_tcn_csr%ISOPEN THEN
1476: CLOSE get_tcn_csr;
1477: END IF;
1478:

Line 1479: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1475: IF get_tcn_csr%ISOPEN THEN
1476: CLOSE get_tcn_csr;
1477: END IF;
1478:
1479: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1480: ,g_pkg_name
1481: ,'OKL_API.G_RET_STS_ERROR'
1482: ,x_msg_count
1483: ,x_msg_data

Line 1481: ,'OKL_API.G_RET_STS_ERROR'

1477: END IF;
1478:
1479: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1480: ,g_pkg_name
1481: ,'OKL_API.G_RET_STS_ERROR'
1482: ,x_msg_count
1483: ,x_msg_data
1484: ,'_PVT');
1485: return -1;

Line 1486: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1482: ,x_msg_count
1483: ,x_msg_data
1484: ,'_PVT');
1485: return -1;
1486: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1487: IF get_tcn_csr%ISOPEN THEN
1488: CLOSE get_tcn_csr;
1489: END IF;
1490:

Line 1491: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1487: IF get_tcn_csr%ISOPEN THEN
1488: CLOSE get_tcn_csr;
1489: END IF;
1490:
1491: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1492: p_msg_name => g_unexpected_error,
1493: p_token1 => g_sqlcode_token,
1494: p_token1_value => SQLCODE,
1495: p_token2 => g_sqlerrm_token,

Line 1498: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1494: p_token1_value => SQLCODE,
1495: p_token2 => g_sqlerrm_token,
1496: p_token2_value => SQLERRM);
1497:
1498: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1499: ,g_pkg_name
1500: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1501: ,x_msg_count
1502: ,x_msg_data

Line 1500: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1496: p_token2_value => SQLERRM);
1497:
1498: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1499: ,g_pkg_name
1500: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1501: ,x_msg_count
1502: ,x_msg_data
1503: ,'_PVT');
1504: return -1;

Line 1510: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1506: IF get_tcn_csr%ISOPEN THEN
1507: CLOSE get_tcn_csr;
1508: END IF;
1509:
1510: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1511: (l_api_name,
1512: G_PKG_NAME,
1513: 'OTHERS',
1514: x_msg_count,

Line 1559: l_init_msg_list VARCHAR2(2000) := OKL_API.G_TRUE;

1555:
1556: l_api_name VARCHAR2(30) := 'GET_EVENT_INFO';
1557: l_api_version CONSTANT NUMBER := 1.0;
1558:
1559: l_init_msg_list VARCHAR2(2000) := OKL_API.G_TRUE;
1560: l_return_status VARCHAR2(1);
1561: l_msg_count NUMBER;
1562: l_msg_data VARCHAR2(2000);
1563:

Line 1565: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

1561: l_msg_count NUMBER;
1562: l_msg_data VARCHAR2(2000);
1563:
1564: BEGIN
1565: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
1566: ,G_PKG_NAME
1567: ,p_init_msg_list
1568: ,l_api_version
1569: ,p_api_version

Line 1573: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1569: ,p_api_version
1570: ,'_PVT'
1571: ,x_return_status);
1572:
1573: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1574: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1575: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1576: RAISE Okl_Api.G_EXCEPTION_ERROR;
1577: END IF;

Line 1574: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1570: ,'_PVT'
1571: ,x_return_status);
1572:
1573: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1574: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1575: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1576: RAISE Okl_Api.G_EXCEPTION_ERROR;
1577: END IF;
1578:

Line 1575: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

1571: ,x_return_status);
1572:
1573: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1574: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1575: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1576: RAISE Okl_Api.G_EXCEPTION_ERROR;
1577: END IF;
1578:
1579: WRITE_TO_LOG('');

Line 1576: RAISE Okl_Api.G_EXCEPTION_ERROR;

1572:
1573: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1574: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1575: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1576: RAISE Okl_Api.G_EXCEPTION_ERROR;
1577: END IF;
1578:
1579: WRITE_TO_LOG('');
1580: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 1608: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1604: ,x_entity_type_code => l_entity_type_code
1605: ,x_event_class_code => l_event_class_code
1606: ,x_return_status => l_return_status);
1607:
1608: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1609: RAISE Okl_Api.G_EXCEPTION_ERROR;
1610: END IF;
1611:
1612: l_event_source_info.source_application_id := g_application_id;

Line 1609: RAISE Okl_Api.G_EXCEPTION_ERROR;

1605: ,x_event_class_code => l_event_class_code
1606: ,x_return_status => l_return_status);
1607:
1608: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1609: RAISE Okl_Api.G_EXCEPTION_ERROR;
1610: END IF;
1611:
1612: l_event_source_info.source_application_id := g_application_id;
1613: l_event_source_info.application_id := g_application_id;

Line 1647: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1643: ,p_valuation_method => p_representation_code
1644: ,p_security_context => l_security_context);
1645: EXCEPTION
1646: WHEN OTHERS THEN
1647: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1648: p_msg_name => g_unexpected_error,
1649: p_token1 => g_sqlcode_token,
1650: p_token1_value => SQLCODE,
1651: p_token2 => g_sqlerrm_token,

Line 1654: RAISE Okl_Api.G_EXCEPTION_ERROR;

1650: p_token1_value => SQLCODE,
1651: p_token2 => g_sqlerrm_token,
1652: p_token2_value => SQLERRM);
1653:
1654: RAISE Okl_Api.G_EXCEPTION_ERROR;
1655: END;
1656:
1657: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1658: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1657: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1653:
1654: RAISE Okl_Api.G_EXCEPTION_ERROR;
1655: END;
1656:
1657: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1658: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1659:
1660: WRITE_TO_LOG('');
1661: WRITE_TO_LOG('Done with ' || l_api_name);

Line 1658: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1654: RAISE Okl_Api.G_EXCEPTION_ERROR;
1655: END;
1656:
1657: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1658: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1659:
1660: WRITE_TO_LOG('');
1661: WRITE_TO_LOG('Done with ' || l_api_name);
1662:

Line 1666: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1662:
1663: return l_event_info;
1664:
1665: EXCEPTION
1666: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1667: IF get_tcn_csr%ISOPEN THEN
1668: CLOSE get_tcn_csr;
1669: END IF;
1670:

Line 1671: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1667: IF get_tcn_csr%ISOPEN THEN
1668: CLOSE get_tcn_csr;
1669: END IF;
1670:
1671: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1672: ,g_pkg_name
1673: ,'OKL_API.G_RET_STS_ERROR'
1674: ,x_msg_count
1675: ,x_msg_data

Line 1673: ,'OKL_API.G_RET_STS_ERROR'

1669: END IF;
1670:
1671: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1672: ,g_pkg_name
1673: ,'OKL_API.G_RET_STS_ERROR'
1674: ,x_msg_count
1675: ,x_msg_data
1676: ,'_PVT');
1677: RETURN NULL;

Line 1678: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1674: ,x_msg_count
1675: ,x_msg_data
1676: ,'_PVT');
1677: RETURN NULL;
1678: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1679: IF get_tcn_csr%ISOPEN THEN
1680: CLOSE get_tcn_csr;
1681: END IF;
1682:

Line 1683: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1679: IF get_tcn_csr%ISOPEN THEN
1680: CLOSE get_tcn_csr;
1681: END IF;
1682:
1683: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1684: p_msg_name => g_unexpected_error,
1685: p_token1 => g_sqlcode_token,
1686: p_token1_value => SQLCODE,
1687: p_token2 => g_sqlerrm_token,

Line 1690: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1686: p_token1_value => SQLCODE,
1687: p_token2 => g_sqlerrm_token,
1688: p_token2_value => SQLERRM);
1689:
1690: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1691: ,g_pkg_name
1692: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1693: ,x_msg_count
1694: ,x_msg_data

Line 1692: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1688: p_token2_value => SQLERRM);
1689:
1690: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1691: ,g_pkg_name
1692: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1693: ,x_msg_count
1694: ,x_msg_data
1695: ,'_PVT');
1696: RETURN NULL;

Line 1702: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1698: IF get_tcn_csr%ISOPEN THEN
1699: CLOSE get_tcn_csr;
1700: END IF;
1701:
1702: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1703: (l_api_name,
1704: G_PKG_NAME,
1705: 'OTHERS',
1706: x_msg_count,

Line 1758: l_init_msg_list VARCHAR2(2000) := OKL_API.G_FALSE;

1754:
1755: l_api_name VARCHAR2(30) := 'GET_ARRAY_EVENT_INFO';
1756: l_api_version CONSTANT NUMBER := 1.0;
1757:
1758: l_init_msg_list VARCHAR2(2000) := OKL_API.G_FALSE;
1759: l_return_status VARCHAR2(1);
1760: l_msg_count NUMBER;
1761: l_msg_data VARCHAR2(2000);
1762:

Line 1765: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

1761: l_msg_data VARCHAR2(2000);
1762:
1763:
1764: BEGIN
1765: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
1766: ,G_PKG_NAME
1767: ,p_init_msg_list
1768: ,l_api_version
1769: ,p_api_version

Line 1773: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1769: ,p_api_version
1770: ,'_PVT'
1771: ,x_return_status);
1772:
1773: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1774: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1775: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1776: RAISE Okl_Api.G_EXCEPTION_ERROR;
1777: END IF;

Line 1774: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1770: ,'_PVT'
1771: ,x_return_status);
1772:
1773: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1774: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1775: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1776: RAISE Okl_Api.G_EXCEPTION_ERROR;
1777: END IF;
1778:

Line 1775: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

1771: ,x_return_status);
1772:
1773: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1774: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1775: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1776: RAISE Okl_Api.G_EXCEPTION_ERROR;
1777: END IF;
1778:
1779: l_array_event_info_null := l_array_event_info;

Line 1776: RAISE Okl_Api.G_EXCEPTION_ERROR;

1772:
1773: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1774: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1775: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1776: RAISE Okl_Api.G_EXCEPTION_ERROR;
1777: END IF;
1778:
1779: l_array_event_info_null := l_array_event_info;
1780:

Line 1812: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1808: ,x_entity_type_code => l_entity_type_code
1809: ,x_event_class_code => l_event_class_code
1810: ,x_return_status => l_return_status);
1811:
1812: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1813: RAISE Okl_Api.G_EXCEPTION_ERROR;
1814: END IF;
1815:
1816: l_event_source_info.source_application_id := g_application_id;

Line 1813: RAISE Okl_Api.G_EXCEPTION_ERROR;

1809: ,x_event_class_code => l_event_class_code
1810: ,x_return_status => l_return_status);
1811:
1812: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1813: RAISE Okl_Api.G_EXCEPTION_ERROR;
1814: END IF;
1815:
1816: l_event_source_info.source_application_id := g_application_id;
1817: l_event_source_info.application_id := g_application_id;

Line 1854: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1850: ,p_valuation_method => p_representation_code
1851: ,p_security_context => l_security_context);
1852: EXCEPTION
1853: WHEN OTHERS THEN
1854: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1855: p_msg_name => g_unexpected_error,
1856: p_token1 => g_sqlcode_token,
1857: p_token1_value => SQLCODE,
1858: p_token2 => g_sqlerrm_token,

Line 1861: RAISE Okl_Api.G_EXCEPTION_ERROR;

1857: p_token1_value => SQLCODE,
1858: p_token2 => g_sqlerrm_token,
1859: p_token2_value => SQLERRM);
1860:
1861: RAISE Okl_Api.G_EXCEPTION_ERROR;
1862: END;
1863:
1864: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1865: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 1864: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1860:
1861: RAISE Okl_Api.G_EXCEPTION_ERROR;
1862: END;
1863:
1864: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1865: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1866:
1867: WRITE_TO_LOG('');
1868: WRITE_TO_LOG('Done with ' || l_api_name);

Line 1865: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1861: RAISE Okl_Api.G_EXCEPTION_ERROR;
1862: END;
1863:
1864: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1865: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1866:
1867: WRITE_TO_LOG('');
1868: WRITE_TO_LOG('Done with ' || l_api_name);
1869:

Line 1873: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1869:
1870: RETURN l_array_event_info;
1871:
1872: EXCEPTION
1873: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1874: IF get_tcn_csr%ISOPEN THEN
1875: CLOSE get_tcn_csr;
1876: END IF;
1877:

Line 1878: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1874: IF get_tcn_csr%ISOPEN THEN
1875: CLOSE get_tcn_csr;
1876: END IF;
1877:
1878: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1879: ,g_pkg_name
1880: ,'OKL_API.G_RET_STS_ERROR'
1881: ,x_msg_count
1882: ,x_msg_data

Line 1880: ,'OKL_API.G_RET_STS_ERROR'

1876: END IF;
1877:
1878: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1879: ,g_pkg_name
1880: ,'OKL_API.G_RET_STS_ERROR'
1881: ,x_msg_count
1882: ,x_msg_data
1883: ,'_PVT');
1884: RETURN l_array_event_info_null;

Line 1885: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1881: ,x_msg_count
1882: ,x_msg_data
1883: ,'_PVT');
1884: RETURN l_array_event_info_null;
1885: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1886: IF get_tcn_csr%ISOPEN THEN
1887: CLOSE get_tcn_csr;
1888: END IF;
1889:

Line 1890: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1886: IF get_tcn_csr%ISOPEN THEN
1887: CLOSE get_tcn_csr;
1888: END IF;
1889:
1890: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1891: p_msg_name => g_unexpected_error,
1892: p_token1 => g_sqlcode_token,
1893: p_token1_value => SQLCODE,
1894: p_token2 => g_sqlerrm_token,

Line 1897: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1893: p_token1_value => SQLCODE,
1894: p_token2 => g_sqlerrm_token,
1895: p_token2_value => SQLERRM);
1896:
1897: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1898: ,g_pkg_name
1899: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1900: ,x_msg_count
1901: ,x_msg_data

Line 1899: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1895: p_token2_value => SQLERRM);
1896:
1897: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1898: ,g_pkg_name
1899: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1900: ,x_msg_count
1901: ,x_msg_data
1902: ,'_PVT');
1903: RETURN l_array_event_info_null;

Line 1909: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1905: IF get_tcn_csr%ISOPEN THEN
1906: CLOSE get_tcn_csr;
1907: END IF;
1908:
1909: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1910: (l_api_name,
1911: G_PKG_NAME,
1912: 'OTHERS',
1913: x_msg_count,

Line 1954: l_init_msg_list VARCHAR2(2000) := OKL_API.G_FALSE;

1950:
1951: l_api_name VARCHAR2(30) := 'GET_EVENT_STATUS';
1952: l_api_version CONSTANT NUMBER := 1.0;
1953:
1954: l_init_msg_list VARCHAR2(2000) := OKL_API.G_FALSE;
1955: l_return_status VARCHAR2(1);
1956: l_msg_count NUMBER;
1957: l_msg_data VARCHAR2(2000);
1958:

Line 1961: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

1957: l_msg_data VARCHAR2(2000);
1958:
1959:
1960: BEGIN
1961: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
1962: ,G_PKG_NAME
1963: ,p_init_msg_list
1964: ,l_api_version
1965: ,p_api_version

Line 1969: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1965: ,p_api_version
1966: ,'_PVT'
1967: ,x_return_status);
1968:
1969: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1970: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1971: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1972: RAISE Okl_Api.G_EXCEPTION_ERROR;
1973: END IF;

Line 1970: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1966: ,'_PVT'
1967: ,x_return_status);
1968:
1969: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1970: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1971: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1972: RAISE Okl_Api.G_EXCEPTION_ERROR;
1973: END IF;
1974:

Line 1971: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

1967: ,x_return_status);
1968:
1969: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1970: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1971: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1972: RAISE Okl_Api.G_EXCEPTION_ERROR;
1973: END IF;
1974:
1975: WRITE_TO_LOG('');

Line 1972: RAISE Okl_Api.G_EXCEPTION_ERROR;

1968:
1969: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1970: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1971: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1972: RAISE Okl_Api.G_EXCEPTION_ERROR;
1973: END IF;
1974:
1975: WRITE_TO_LOG('');
1976: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 2004: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

2000: ,x_entity_type_code => l_entity_type_code
2001: ,x_event_class_code => l_event_class_code
2002: ,x_return_status => l_return_status);
2003:
2004: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
2005: RAISE Okl_Api.G_EXCEPTION_ERROR;
2006: END IF;
2007:
2008: l_event_source_info.source_application_id := g_application_id;

Line 2005: RAISE Okl_Api.G_EXCEPTION_ERROR;

2001: ,x_event_class_code => l_event_class_code
2002: ,x_return_status => l_return_status);
2003:
2004: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
2005: RAISE Okl_Api.G_EXCEPTION_ERROR;
2006: END IF;
2007:
2008: l_event_source_info.source_application_id := g_application_id;
2009: l_event_source_info.application_id := g_application_id;

Line 2043: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

2039: ,p_valuation_method => p_representation_code
2040: ,p_security_context => l_security_context);
2041: EXCEPTION
2042: WHEN OTHERS THEN
2043: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
2044: p_msg_name => g_unexpected_error,
2045: p_token1 => g_sqlcode_token,
2046: p_token1_value => SQLCODE,
2047: p_token2 => g_sqlerrm_token,

Line 2050: RAISE Okl_Api.G_EXCEPTION_ERROR;

2046: p_token1_value => SQLCODE,
2047: p_token2 => g_sqlerrm_token,
2048: p_token2_value => SQLERRM);
2049:
2050: RAISE Okl_Api.G_EXCEPTION_ERROR;
2051: END;
2052:
2053: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2054: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

Line 2053: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2049:
2050: RAISE Okl_Api.G_EXCEPTION_ERROR;
2051: END;
2052:
2053: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2054: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2055:
2056: WRITE_TO_LOG('');
2057: WRITE_TO_LOG('Done with ' || l_api_name);

Line 2054: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2050: RAISE Okl_Api.G_EXCEPTION_ERROR;
2051: END;
2052:
2053: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2054: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2055:
2056: WRITE_TO_LOG('');
2057: WRITE_TO_LOG('Done with ' || l_api_name);
2058:

Line 2062: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2058:
2059: RETURN l_event_status_code;
2060:
2061: EXCEPTION
2062: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2063: IF get_tcn_csr%ISOPEN THEN
2064: CLOSE get_tcn_csr;
2065: END IF;
2066:

Line 2067: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

2063: IF get_tcn_csr%ISOPEN THEN
2064: CLOSE get_tcn_csr;
2065: END IF;
2066:
2067: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2068: ,g_pkg_name
2069: ,'OKL_API.G_RET_STS_ERROR'
2070: ,x_msg_count
2071: ,x_msg_data

Line 2069: ,'OKL_API.G_RET_STS_ERROR'

2065: END IF;
2066:
2067: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2068: ,g_pkg_name
2069: ,'OKL_API.G_RET_STS_ERROR'
2070: ,x_msg_count
2071: ,x_msg_data
2072: ,'_PVT');
2073: RETURN 'F';

Line 2074: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2070: ,x_msg_count
2071: ,x_msg_data
2072: ,'_PVT');
2073: RETURN 'F';
2074: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2075: IF get_tcn_csr%ISOPEN THEN
2076: CLOSE get_tcn_csr;
2077: END IF;
2078:

Line 2079: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

2075: IF get_tcn_csr%ISOPEN THEN
2076: CLOSE get_tcn_csr;
2077: END IF;
2078:
2079: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
2080: p_msg_name => g_unexpected_error,
2081: p_token1 => g_sqlcode_token,
2082: p_token1_value => SQLCODE,
2083: p_token2 => g_sqlerrm_token,

Line 2086: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

2082: p_token1_value => SQLCODE,
2083: p_token2 => g_sqlerrm_token,
2084: p_token2_value => SQLERRM);
2085:
2086: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2087: ,g_pkg_name
2088: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2089: ,x_msg_count
2090: ,x_msg_data

Line 2088: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2084: p_token2_value => SQLERRM);
2085:
2086: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2087: ,g_pkg_name
2088: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2089: ,x_msg_count
2090: ,x_msg_data
2091: ,'_PVT');
2092: RETURN 'F';

Line 2098: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

2094: IF get_tcn_csr%ISOPEN THEN
2095: CLOSE get_tcn_csr;
2096: END IF;
2097:
2098: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2099: (l_api_name,
2100: G_PKG_NAME,
2101: 'OTHERS',
2102: x_msg_count,

Line 2131: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

2127: l_api_name VARCHAR2(30) := 'EVENT_EXISTS';
2128: l_api_version CONSTANT NUMBER := 1.0;
2129:
2130: BEGIN
2131: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
2132: ,G_PKG_NAME
2133: ,p_init_msg_list
2134: ,l_api_version
2135: ,p_api_version

Line 2139: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2135: ,p_api_version
2136: ,'_PVT'
2137: ,x_return_status);
2138:
2139: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2140: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2141: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2142: RAISE Okl_Api.G_EXCEPTION_ERROR;
2143: END IF;

Line 2140: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2136: ,'_PVT'
2137: ,x_return_status);
2138:
2139: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2140: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2141: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2142: RAISE Okl_Api.G_EXCEPTION_ERROR;
2143: END IF;
2144:

Line 2141: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

2137: ,x_return_status);
2138:
2139: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2140: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2141: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2142: RAISE Okl_Api.G_EXCEPTION_ERROR;
2143: END IF;
2144:
2145: WRITE_TO_LOG('');

Line 2142: RAISE Okl_Api.G_EXCEPTION_ERROR;

2138:
2139: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2140: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2141: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2142: RAISE Okl_Api.G_EXCEPTION_ERROR;
2143: END IF;
2144:
2145: WRITE_TO_LOG('');
2146: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 2195: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2191: FETCH get_event_csr into x_event_id, x_event_date;
2192: CLOSE get_event_csr;
2193: END IF;
2194:
2195: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2196: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2197:
2198: WRITE_TO_LOG('');
2199: WRITE_TO_LOG('Done with ' || l_api_name);

Line 2196: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2192: CLOSE get_event_csr;
2193: END IF;
2194:
2195: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2196: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2197:
2198: WRITE_TO_LOG('');
2199: WRITE_TO_LOG('Done with ' || l_api_name);
2200:

Line 2207: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

2203: IF get_event_csr%ISOPEN THEN
2204: CLOSE get_event_csr;
2205: END IF;
2206:
2207: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2208: (l_api_name,
2209: G_PKG_NAME,
2210: 'OTHERS',
2211: x_msg_count,