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 188: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

184: l_access_mode VARCHAR2(1);
185:
186: BEGIN
187:
188: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
189: ,G_PKG_NAME
190: ,p_init_msg_list
191: ,l_api_version
192: ,p_api_version

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

192: ,p_api_version
193: ,'_PVT'
194: ,x_return_status);
195:
196: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
197: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
198: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
199: RAISE Okl_Api.G_EXCEPTION_ERROR;
200: END IF;

Line 197: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

193: ,'_PVT'
194: ,x_return_status);
195:
196: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
197: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
198: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
199: RAISE Okl_Api.G_EXCEPTION_ERROR;
200: END IF;
201:

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

194: ,x_return_status);
195:
196: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
197: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
198: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
199: RAISE Okl_Api.G_EXCEPTION_ERROR;
200: END IF;
201:
202: WRITE_TO_LOG('');

Line 199: RAISE Okl_Api.G_EXCEPTION_ERROR;

195:
196: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
197: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
198: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
199: RAISE Okl_Api.G_EXCEPTION_ERROR;
200: END IF;
201:
202: WRITE_TO_LOG('');
203: WRITE_TO_LOG('Inside the call to CREATE_EVENT');

Line 232: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

228: ,x_entity_type_code => l_entity_type_code
229: ,x_event_class_code => l_event_class_code
230: ,x_return_status => l_return_status);
231:
232: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
233: RAISE Okl_Api.G_EXCEPTION_ERROR;
234: END IF;
235:
236: l_event_source_info.source_application_id := g_application_id;

Line 233: RAISE Okl_Api.G_EXCEPTION_ERROR;

229: ,x_event_class_code => l_event_class_code
230: ,x_return_status => l_return_status);
231:
232: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
233: RAISE Okl_Api.G_EXCEPTION_ERROR;
234: END IF;
235:
236: l_event_source_info.source_application_id := g_application_id;
237: l_event_source_info.application_id := g_application_id;

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

293: END IF;
294:
295: EXCEPTION
296: WHEN OTHERS THEN
297: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
298: p_msg_name => g_unexpected_error,
299: p_token1 => g_sqlcode_token,
300: p_token1_value => SQLCODE,
301: p_token2 => g_sqlerrm_token,

Line 304: RAISE Okl_Api.G_EXCEPTION_ERROR;

300: p_token1_value => SQLCODE,
301: p_token2 => g_sqlerrm_token,
302: p_token2_value => SQLERRM);
303:
304: RAISE Okl_Api.G_EXCEPTION_ERROR;
305: END;
306:
307: WRITE_TO_LOG('');
308: WRITE_TO_LOG('Done with CREATE_EVENT');

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

306:
307: WRITE_TO_LOG('');
308: WRITE_TO_LOG('Done with CREATE_EVENT');
309:
310: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
311: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
312:
313: return l_event_id;
314:

Line 311: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

307: WRITE_TO_LOG('');
308: WRITE_TO_LOG('Done with CREATE_EVENT');
309:
310: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
311: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
312:
313: return l_event_id;
314:
315: EXCEPTION

Line 316: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

312:
313: return l_event_id;
314:
315: EXCEPTION
316: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
317: IF get_tcn_csr%ISOPEN THEN
318: CLOSE get_tcn_csr;
319: END IF;
320:

Line 321: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

317: IF get_tcn_csr%ISOPEN THEN
318: CLOSE get_tcn_csr;
319: END IF;
320:
321: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
322: ,g_pkg_name
323: ,'OKL_API.G_RET_STS_ERROR'
324: ,x_msg_count
325: ,x_msg_data

Line 323: ,'OKL_API.G_RET_STS_ERROR'

319: END IF;
320:
321: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
322: ,g_pkg_name
323: ,'OKL_API.G_RET_STS_ERROR'
324: ,x_msg_count
325: ,x_msg_data
326: ,'_PVT');
327: RETURN -1;

Line 328: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

324: ,x_msg_count
325: ,x_msg_data
326: ,'_PVT');
327: RETURN -1;
328: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
329: IF get_tcn_csr%ISOPEN THEN
330: CLOSE get_tcn_csr;
331: END IF;
332:

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

329: IF get_tcn_csr%ISOPEN THEN
330: CLOSE get_tcn_csr;
331: END IF;
332:
333: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
334: p_msg_name => g_unexpected_error,
335: p_token1 => g_sqlcode_token,
336: p_token1_value => SQLCODE,
337: p_token2 => g_sqlerrm_token,

Line 340: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

336: p_token1_value => SQLCODE,
337: p_token2 => g_sqlerrm_token,
338: p_token2_value => SQLERRM);
339:
340: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
341: ,g_pkg_name
342: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
343: ,x_msg_count
344: ,x_msg_data

Line 342: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

338: p_token2_value => SQLERRM);
339:
340: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
341: ,g_pkg_name
342: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
343: ,x_msg_count
344: ,x_msg_data
345: ,'_PVT');
346: RETURN -1;

Line 353: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

349: IF get_tcn_csr%ISOPEN THEN
350: CLOSE get_tcn_csr;
351: END IF;
352:
353: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
354: (l_api_name,
355: G_PKG_NAME,
356: 'OTHERS',
357: x_msg_count,

Line 408: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

404: l_sla_api_name VARCHAR2(30);
405: l_return_status VARCHAR2(1);
406: BEGIN
407:
408: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
409: ,G_PKG_NAME
410: ,p_init_msg_list
411: ,l_api_version
412: ,p_api_version

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

412: ,p_api_version
413: ,'_PVT'
414: ,x_return_status);
415:
416: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
417: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
418: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
419: RAISE Okl_Api.G_EXCEPTION_ERROR;
420: END IF;

Line 417: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

413: ,'_PVT'
414: ,x_return_status);
415:
416: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
417: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
418: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
419: RAISE Okl_Api.G_EXCEPTION_ERROR;
420: END IF;
421:

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

414: ,x_return_status);
415:
416: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
417: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
418: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
419: RAISE Okl_Api.G_EXCEPTION_ERROR;
420: END IF;
421:
422: WRITE_TO_LOG('');

Line 419: RAISE Okl_Api.G_EXCEPTION_ERROR;

415:
416: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
417: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
418: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
419: RAISE Okl_Api.G_EXCEPTION_ERROR;
420: END IF;
421:
422: WRITE_TO_LOG('');
423: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 453: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

449: ,x_entity_type_code => l_entity_type_code
450: ,x_event_class_code => l_event_class_code
451: ,x_return_status => l_return_status);
452:
453: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
454: RAISE Okl_Api.G_EXCEPTION_ERROR;
455: END IF;
456:
457: l_event_source_info.source_application_id := g_application_id;

Line 454: RAISE Okl_Api.G_EXCEPTION_ERROR;

450: ,x_event_class_code => l_event_class_code
451: ,x_return_status => l_return_status);
452:
453: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
454: RAISE Okl_Api.G_EXCEPTION_ERROR;
455: END IF;
456:
457: l_event_source_info.source_application_id := g_application_id;
458: l_event_source_info.application_id := g_application_id;

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

497: ,p_valuation_method => p_representation_code
498: ,p_security_context => l_security_context);
499: EXCEPTION
500: WHEN OTHERS THEN
501: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
502: p_msg_name => g_unexpected_error,
503: p_token1 => g_sqlcode_token,
504: p_token1_value => SQLCODE,
505: p_token2 => g_sqlerrm_token,

Line 508: RAISE Okl_Api.G_EXCEPTION_ERROR;

504: p_token1_value => SQLCODE,
505: p_token2 => g_sqlerrm_token,
506: p_token2_value => SQLERRM);
507:
508: RAISE Okl_Api.G_EXCEPTION_ERROR;
509: END;
510:
511: WRITE_TO_LOG('');
512: WRITE_TO_LOG('Done with ' || l_api_name);

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

510:
511: WRITE_TO_LOG('');
512: WRITE_TO_LOG('Done with ' || l_api_name);
513:
514: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
515: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
516:
517: EXCEPTION
518: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

Line 515: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

511: WRITE_TO_LOG('');
512: WRITE_TO_LOG('Done with ' || l_api_name);
513:
514: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
515: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
516:
517: EXCEPTION
518: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
519: IF get_tcn_csr%ISOPEN THEN

Line 518: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

514: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
515: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
516:
517: EXCEPTION
518: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
519: IF get_tcn_csr%ISOPEN THEN
520: CLOSE get_tcn_csr;
521: END IF;
522:

Line 523: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

519: IF get_tcn_csr%ISOPEN THEN
520: CLOSE get_tcn_csr;
521: END IF;
522:
523: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
524: ,g_pkg_name
525: ,'OKL_API.G_RET_STS_ERROR'
526: ,x_msg_count
527: ,x_msg_data

Line 525: ,'OKL_API.G_RET_STS_ERROR'

521: END IF;
522:
523: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
524: ,g_pkg_name
525: ,'OKL_API.G_RET_STS_ERROR'
526: ,x_msg_count
527: ,x_msg_data
528: ,'_PVT');
529:

Line 530: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

526: ,x_msg_count
527: ,x_msg_data
528: ,'_PVT');
529:
530: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
531: IF get_tcn_csr%ISOPEN THEN
532: CLOSE get_tcn_csr;
533: END IF;
534:

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

531: IF get_tcn_csr%ISOPEN THEN
532: CLOSE get_tcn_csr;
533: END IF;
534:
535: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
536: p_msg_name => g_unexpected_error,
537: p_token1 => g_sqlcode_token,
538: p_token1_value => SQLCODE,
539: p_token2 => g_sqlerrm_token,

Line 542: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

538: p_token1_value => SQLCODE,
539: p_token2 => g_sqlerrm_token,
540: p_token2_value => SQLERRM);
541:
542: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
543: ,g_pkg_name
544: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
545: ,x_msg_count
546: ,x_msg_data

Line 544: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

540: p_token2_value => SQLERRM);
541:
542: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
543: ,g_pkg_name
544: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
545: ,x_msg_count
546: ,x_msg_data
547: ,'_PVT');
548:

Line 554: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

550: IF get_tcn_csr%ISOPEN THEN
551: CLOSE get_tcn_csr;
552: END IF;
553:
554: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
555: (l_api_name,
556: G_PKG_NAME,
557: 'OTHERS',
558: x_msg_count,

Line 611: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

607: l_return_status VARCHAR2(1);
608: l_sla_api_name VARCHAR2(60);
609:
610: BEGIN
611: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
612: ,G_PKG_NAME
613: ,p_init_msg_list
614: ,l_api_version
615: ,p_api_version

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

615: ,p_api_version
616: ,'_PVT'
617: ,x_return_status);
618:
619: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
622: RAISE Okl_Api.G_EXCEPTION_ERROR;
623: END IF;

Line 620: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

616: ,'_PVT'
617: ,x_return_status);
618:
619: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
622: RAISE Okl_Api.G_EXCEPTION_ERROR;
623: END IF;
624:

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

617: ,x_return_status);
618:
619: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
622: RAISE Okl_Api.G_EXCEPTION_ERROR;
623: END IF;
624:
625: WRITE_TO_LOG('');

Line 622: RAISE Okl_Api.G_EXCEPTION_ERROR;

618:
619: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
622: RAISE Okl_Api.G_EXCEPTION_ERROR;
623: END IF;
624:
625: WRITE_TO_LOG('');
626: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 660: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

656: ,x_entity_type_code => l_entity_type_code
657: ,x_event_class_code => l_event_class_code
658: ,x_return_status => l_return_status);
659:
660: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
661: RAISE Okl_Api.G_EXCEPTION_ERROR;
662: END IF;
663:
664: l_event_source_info.source_application_id := g_application_id;

Line 661: RAISE Okl_Api.G_EXCEPTION_ERROR;

657: ,x_event_class_code => l_event_class_code
658: ,x_return_status => l_return_status);
659:
660: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
661: RAISE Okl_Api.G_EXCEPTION_ERROR;
662: END IF;
663:
664: l_event_source_info.source_application_id := g_application_id;
665: l_event_source_info.application_id := g_application_id;

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

749:
750: END IF;
751: EXCEPTION
752: WHEN OTHERS THEN
753: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
754: p_msg_name => g_unexpected_error,
755: p_token1 => g_sqlcode_token,
756: p_token1_value => SQLCODE,
757: p_token2 => g_sqlerrm_token,

Line 760: RAISE Okl_Api.G_EXCEPTION_ERROR;

756: p_token1_value => SQLCODE,
757: p_token2 => g_sqlerrm_token,
758: p_token2_value => SQLERRM);
759:
760: RAISE Okl_Api.G_EXCEPTION_ERROR;
761: END;
762:
763: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
764: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

759:
760: RAISE Okl_Api.G_EXCEPTION_ERROR;
761: END;
762:
763: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
764: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
765:
766: WRITE_TO_LOG('');
767: WRITE_TO_LOG('Done with ' || l_api_name);

Line 764: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

760: RAISE Okl_Api.G_EXCEPTION_ERROR;
761: END;
762:
763: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
764: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
765:
766: WRITE_TO_LOG('');
767: WRITE_TO_LOG('Done with ' || l_api_name);
768:

Line 770: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

766: WRITE_TO_LOG('');
767: WRITE_TO_LOG('Done with ' || l_api_name);
768:
769: EXCEPTION
770: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
771: IF get_tcn_csr%ISOPEN THEN
772: CLOSE get_tcn_csr;
773: END IF;
774:

Line 775: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

771: IF get_tcn_csr%ISOPEN THEN
772: CLOSE get_tcn_csr;
773: END IF;
774:
775: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
776: ,g_pkg_name
777: ,'OKL_API.G_RET_STS_ERROR'
778: ,x_msg_count
779: ,x_msg_data

Line 777: ,'OKL_API.G_RET_STS_ERROR'

773: END IF;
774:
775: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
776: ,g_pkg_name
777: ,'OKL_API.G_RET_STS_ERROR'
778: ,x_msg_count
779: ,x_msg_data
780: ,'_PVT');
781:

Line 782: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

778: ,x_msg_count
779: ,x_msg_data
780: ,'_PVT');
781:
782: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
783: IF get_tcn_csr%ISOPEN THEN
784: CLOSE get_tcn_csr;
785: END IF;
786:

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

783: IF get_tcn_csr%ISOPEN THEN
784: CLOSE get_tcn_csr;
785: END IF;
786:
787: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
788: p_msg_name => g_unexpected_error,
789: p_token1 => g_sqlcode_token,
790: p_token1_value => SQLCODE,
791: p_token2 => g_sqlerrm_token,

Line 794: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

790: p_token1_value => SQLCODE,
791: p_token2 => g_sqlerrm_token,
792: p_token2_value => SQLERRM);
793:
794: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
795: ,g_pkg_name
796: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
797: ,x_msg_count
798: ,x_msg_data

Line 796: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

792: p_token2_value => SQLERRM);
793:
794: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
795: ,g_pkg_name
796: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
797: ,x_msg_count
798: ,x_msg_data
799: ,'_PVT');
800:

Line 806: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

802: IF get_tcn_csr%ISOPEN THEN
803: CLOSE get_tcn_csr;
804: END IF;
805:
806: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
807: (l_api_name,
808: G_PKG_NAME,
809: 'OTHERS',
810: x_msg_count,

Line 857: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

853: l_return_status VARCHAR2(1);
854: l_sla_api_name VARCHAR2(60);
855:
856: BEGIN
857: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
858: ,G_PKG_NAME
859: ,p_init_msg_list
860: ,l_api_version
861: ,p_api_version

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

861: ,p_api_version
862: ,'_PVT'
863: ,x_return_status);
864:
865: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
866: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
867: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
868: RAISE Okl_Api.G_EXCEPTION_ERROR;
869: END IF;

Line 866: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

862: ,'_PVT'
863: ,x_return_status);
864:
865: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
866: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
867: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
868: RAISE Okl_Api.G_EXCEPTION_ERROR;
869: END IF;
870:

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

863: ,x_return_status);
864:
865: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
866: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
867: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
868: RAISE Okl_Api.G_EXCEPTION_ERROR;
869: END IF;
870:
871: WRITE_TO_LOG('');

Line 868: RAISE Okl_Api.G_EXCEPTION_ERROR;

864:
865: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
866: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
867: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
868: RAISE Okl_Api.G_EXCEPTION_ERROR;
869: END IF;
870:
871: WRITE_TO_LOG('');
872: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 901: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

897: ,x_entity_type_code => l_entity_type_code
898: ,x_event_class_code => l_event_class_code
899: ,x_return_status => l_return_status);
900:
901: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
902: RAISE Okl_Api.G_EXCEPTION_ERROR;
903: END IF;
904:
905: l_event_source_info.source_application_id := g_application_id;

Line 902: RAISE Okl_Api.G_EXCEPTION_ERROR;

898: ,x_event_class_code => l_event_class_code
899: ,x_return_status => l_return_status);
900:
901: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
902: RAISE Okl_Api.G_EXCEPTION_ERROR;
903: END IF;
904:
905: l_event_source_info.source_application_id := g_application_id;
906: l_event_source_info.application_id := g_application_id;

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

938: ,p_security_context => l_security_context);
939:
940: EXCEPTION
941: WHEN OTHERS THEN
942: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
943: p_msg_name => g_unexpected_error,
944: p_token1 => g_sqlcode_token,
945: p_token1_value => SQLCODE,
946: p_token2 => g_sqlerrm_token,

Line 949: RAISE Okl_Api.G_EXCEPTION_ERROR;

945: p_token1_value => SQLCODE,
946: p_token2 => g_sqlerrm_token,
947: p_token2_value => SQLERRM);
948:
949: RAISE Okl_Api.G_EXCEPTION_ERROR;
950: END;
951:
952: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
953: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

948:
949: RAISE Okl_Api.G_EXCEPTION_ERROR;
950: END;
951:
952: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
953: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
954:
955: WRITE_TO_LOG('');
956: WRITE_TO_LOG('Done with ' || l_api_name);

Line 953: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

949: RAISE Okl_Api.G_EXCEPTION_ERROR;
950: END;
951:
952: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
953: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
954:
955: WRITE_TO_LOG('');
956: WRITE_TO_LOG('Done with ' || l_api_name);
957:

Line 959: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

955: WRITE_TO_LOG('');
956: WRITE_TO_LOG('Done with ' || l_api_name);
957:
958: EXCEPTION
959: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
960: IF get_tcn_csr%ISOPEN THEN
961: CLOSE get_tcn_csr;
962: END IF;
963:

Line 964: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

960: IF get_tcn_csr%ISOPEN THEN
961: CLOSE get_tcn_csr;
962: END IF;
963:
964: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
965: ,g_pkg_name
966: ,'OKL_API.G_RET_STS_ERROR'
967: ,x_msg_count
968: ,x_msg_data

Line 966: ,'OKL_API.G_RET_STS_ERROR'

962: END IF;
963:
964: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
965: ,g_pkg_name
966: ,'OKL_API.G_RET_STS_ERROR'
967: ,x_msg_count
968: ,x_msg_data
969: ,'_PVT');
970:

Line 971: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

967: ,x_msg_count
968: ,x_msg_data
969: ,'_PVT');
970:
971: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
972: IF get_tcn_csr%ISOPEN THEN
973: CLOSE get_tcn_csr;
974: END IF;
975:

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

972: IF get_tcn_csr%ISOPEN THEN
973: CLOSE get_tcn_csr;
974: END IF;
975:
976: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
977: p_msg_name => g_unexpected_error,
978: p_token1 => g_sqlcode_token,
979: p_token1_value => SQLCODE,
980: p_token2 => g_sqlerrm_token,

Line 983: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

979: p_token1_value => SQLCODE,
980: p_token2 => g_sqlerrm_token,
981: p_token2_value => SQLERRM);
982:
983: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
984: ,g_pkg_name
985: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
986: ,x_msg_count
987: ,x_msg_data

Line 985: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

981: p_token2_value => SQLERRM);
982:
983: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
984: ,g_pkg_name
985: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
986: ,x_msg_count
987: ,x_msg_data
988: ,'_PVT');
989:

Line 995: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

991: IF get_tcn_csr%ISOPEN THEN
992: CLOSE get_tcn_csr;
993: END IF;
994:
995: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
996: (l_api_name,
997: G_PKG_NAME,
998: 'OTHERS',
999: x_msg_count,

Line 1031: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

1027: l_sla_api_name VARCHAR2(30);
1028: l_return_status VARCHAR2(1);
1029: BEGIN
1030:
1031: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
1032: ,G_PKG_NAME
1033: ,p_init_msg_list
1034: ,l_api_version
1035: ,p_api_version

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

1035: ,p_api_version
1036: ,'_PVT'
1037: ,x_return_status);
1038:
1039: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1040: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1041: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;

Line 1040: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1036: ,'_PVT'
1037: ,x_return_status);
1038:
1039: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1040: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1041: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;
1044:

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

1037: ,x_return_status);
1038:
1039: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1040: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1041: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;
1044:
1045: WRITE_TO_LOG('');

Line 1042: RAISE Okl_Api.G_EXCEPTION_ERROR;

1038:
1039: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1040: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1041: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;
1044:
1045: WRITE_TO_LOG('');
1046: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 1073: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1069: ,x_entity_type_code => l_entity_type_code
1070: ,x_event_class_code => l_event_class_code
1071: ,x_return_status => l_return_status);
1072:
1073: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1074: RAISE Okl_Api.G_EXCEPTION_ERROR;
1075: END IF;
1076:
1077: FORALL i IN 1..p_tcn_tbl.COUNT

Line 1074: RAISE Okl_Api.G_EXCEPTION_ERROR;

1070: ,x_event_class_code => l_event_class_code
1071: ,x_return_status => l_return_status);
1072:
1073: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1074: RAISE Okl_Api.G_EXCEPTION_ERROR;
1075: END IF;
1076:
1077: FORALL i IN 1..p_tcn_tbl.COUNT
1078: INSERT INTO xla_events_int_gt(

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

1099: l_sla_api_name := 'UPDATE_BULK_EVENT_STATUSES';
1100: XLA_EVENTS_PUB_PKG.update_bulk_event_statuses(p_application_id => g_application_id);
1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1104: p_msg_name => g_unexpected_error,
1105: p_token1 => g_sqlcode_token,
1106: p_token1_value => SQLCODE,
1107: p_token2 => g_sqlerrm_token,

Line 1110: RAISE Okl_Api.G_EXCEPTION_ERROR;

1106: p_token1_value => SQLCODE,
1107: p_token2 => g_sqlerrm_token,
1108: p_token2_value => SQLERRM);
1109:
1110: RAISE Okl_Api.G_EXCEPTION_ERROR;
1111: END;
1112:
1113: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1114: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

1109:
1110: RAISE Okl_Api.G_EXCEPTION_ERROR;
1111: END;
1112:
1113: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1114: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1115:
1116: WRITE_TO_LOG('');
1117: WRITE_TO_LOG('Done with ' || l_api_name);

Line 1114: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1110: RAISE Okl_Api.G_EXCEPTION_ERROR;
1111: END;
1112:
1113: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1114: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1115:
1116: WRITE_TO_LOG('');
1117: WRITE_TO_LOG('Done with ' || l_api_name);
1118:

Line 1120: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1116: WRITE_TO_LOG('');
1117: WRITE_TO_LOG('Done with ' || l_api_name);
1118:
1119: EXCEPTION
1120: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1121: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1122: ,g_pkg_name
1123: ,'OKL_API.G_RET_STS_ERROR'
1124: ,x_msg_count

Line 1121: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1117: WRITE_TO_LOG('Done with ' || l_api_name);
1118:
1119: EXCEPTION
1120: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1121: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1122: ,g_pkg_name
1123: ,'OKL_API.G_RET_STS_ERROR'
1124: ,x_msg_count
1125: ,x_msg_data

Line 1123: ,'OKL_API.G_RET_STS_ERROR'

1119: EXCEPTION
1120: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1121: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1122: ,g_pkg_name
1123: ,'OKL_API.G_RET_STS_ERROR'
1124: ,x_msg_count
1125: ,x_msg_data
1126: ,'_PVT');
1127:

Line 1128: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1124: ,x_msg_count
1125: ,x_msg_data
1126: ,'_PVT');
1127:
1128: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1129: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1130: p_msg_name => g_unexpected_error,
1131: p_token1 => g_sqlcode_token,
1132: p_token1_value => SQLCODE,

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

1125: ,x_msg_data
1126: ,'_PVT');
1127:
1128: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1129: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1130: p_msg_name => g_unexpected_error,
1131: p_token1 => g_sqlcode_token,
1132: p_token1_value => SQLCODE,
1133: p_token2 => g_sqlerrm_token,

Line 1136: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1132: p_token1_value => SQLCODE,
1133: p_token2 => g_sqlerrm_token,
1134: p_token2_value => SQLERRM);
1135:
1136: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1137: ,g_pkg_name
1138: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1139: ,x_msg_count
1140: ,x_msg_data

Line 1138: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1134: p_token2_value => SQLERRM);
1135:
1136: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1137: ,g_pkg_name
1138: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1139: ,x_msg_count
1140: ,x_msg_data
1141: ,'_PVT');
1142:

Line 1144: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1140: ,x_msg_data
1141: ,'_PVT');
1142:
1143: WHEN OTHERS THEN
1144: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1145: (l_api_name,
1146: G_PKG_NAME,
1147: 'OTHERS',
1148: x_msg_count,

Line 1194: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

1190: l_return_status VARCHAR2(1);
1191:
1192: BEGIN
1193:
1194: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
1195: ,G_PKG_NAME
1196: ,p_init_msg_list
1197: ,l_api_version
1198: ,p_api_version

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

1198: ,p_api_version
1199: ,'_PVT'
1200: ,x_return_status);
1201:
1202: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1203: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1204: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1205: RAISE Okl_Api.G_EXCEPTION_ERROR;
1206: END IF;

Line 1203: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1199: ,'_PVT'
1200: ,x_return_status);
1201:
1202: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1203: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1204: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1205: RAISE Okl_Api.G_EXCEPTION_ERROR;
1206: END IF;
1207:

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

1200: ,x_return_status);
1201:
1202: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1203: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1204: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1205: RAISE Okl_Api.G_EXCEPTION_ERROR;
1206: END IF;
1207:
1208: WRITE_TO_LOG('');

Line 1205: RAISE Okl_Api.G_EXCEPTION_ERROR;

1201:
1202: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1203: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1204: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1205: RAISE Okl_Api.G_EXCEPTION_ERROR;
1206: END IF;
1207:
1208: WRITE_TO_LOG('');
1209: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 1237: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1233: ,x_entity_type_code => l_entity_type_code
1234: ,x_event_class_code => l_event_class_code
1235: ,x_return_status => l_return_status);
1236:
1237: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1238: RAISE Okl_Api.G_EXCEPTION_ERROR;
1239: END IF;
1240:
1241: l_event_source_info.source_application_id := g_application_id;

Line 1238: RAISE Okl_Api.G_EXCEPTION_ERROR;

1234: ,x_event_class_code => l_event_class_code
1235: ,x_return_status => l_return_status);
1236:
1237: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1238: RAISE Okl_Api.G_EXCEPTION_ERROR;
1239: END IF;
1240:
1241: l_event_source_info.source_application_id := g_application_id;
1242: l_event_source_info.application_id := g_application_id;

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

1272: ,p_valuation_method => p_representation_code
1273: ,p_security_context => l_security_context);
1274: EXCEPTION
1275: WHEN OTHERS THEN
1276: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1277: p_msg_name => g_unexpected_error,
1278: p_token1 => g_sqlcode_token,
1279: p_token1_value => SQLCODE,
1280: p_token2 => g_sqlerrm_token,

Line 1283: RAISE Okl_Api.G_EXCEPTION_ERROR;

1279: p_token1_value => SQLCODE,
1280: p_token2 => g_sqlerrm_token,
1281: p_token2_value => SQLERRM);
1282:
1283: RAISE Okl_Api.G_EXCEPTION_ERROR;
1284: END;
1285:
1286: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1287: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

1282:
1283: RAISE Okl_Api.G_EXCEPTION_ERROR;
1284: END;
1285:
1286: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1287: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1288:
1289: WRITE_TO_LOG('');
1290: WRITE_TO_LOG('Done with ' || l_api_name);

Line 1287: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1283: RAISE Okl_Api.G_EXCEPTION_ERROR;
1284: END;
1285:
1286: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1287: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1288:
1289: WRITE_TO_LOG('');
1290: WRITE_TO_LOG('Done with ' || l_api_name);
1291:

Line 1293: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1289: WRITE_TO_LOG('');
1290: WRITE_TO_LOG('Done with ' || l_api_name);
1291:
1292: EXCEPTION
1293: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1294: IF get_tcn_csr%ISOPEN THEN
1295: CLOSE get_tcn_csr;
1296: END IF;
1297:

Line 1298: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1294: IF get_tcn_csr%ISOPEN THEN
1295: CLOSE get_tcn_csr;
1296: END IF;
1297:
1298: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1299: ,g_pkg_name
1300: ,'OKL_API.G_RET_STS_ERROR'
1301: ,x_msg_count
1302: ,x_msg_data

Line 1300: ,'OKL_API.G_RET_STS_ERROR'

1296: END IF;
1297:
1298: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1299: ,g_pkg_name
1300: ,'OKL_API.G_RET_STS_ERROR'
1301: ,x_msg_count
1302: ,x_msg_data
1303: ,'_PVT');
1304:

Line 1305: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1301: ,x_msg_count
1302: ,x_msg_data
1303: ,'_PVT');
1304:
1305: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1306: IF get_tcn_csr%ISOPEN THEN
1307: CLOSE get_tcn_csr;
1308: END IF;
1309:

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

1306: IF get_tcn_csr%ISOPEN THEN
1307: CLOSE get_tcn_csr;
1308: END IF;
1309:
1310: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1311: p_msg_name => g_unexpected_error,
1312: p_token1 => g_sqlcode_token,
1313: p_token1_value => SQLCODE,
1314: p_token2 => g_sqlerrm_token,

Line 1317: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1313: p_token1_value => SQLCODE,
1314: p_token2 => g_sqlerrm_token,
1315: p_token2_value => SQLERRM);
1316:
1317: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1318: ,g_pkg_name
1319: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1320: ,x_msg_count
1321: ,x_msg_data

Line 1319: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1315: p_token2_value => SQLERRM);
1316:
1317: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1318: ,g_pkg_name
1319: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1320: ,x_msg_count
1321: ,x_msg_data
1322: ,'_PVT');
1323:

Line 1329: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1325: IF get_tcn_csr%ISOPEN THEN
1326: CLOSE get_tcn_csr;
1327: END IF;
1328:
1329: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1330: (l_api_name,
1331: G_PKG_NAME,
1332: 'OTHERS',
1333: x_msg_count,

Line 1381: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

1377: l_return_status VARCHAR2(1);
1378: l_events_deleted NUMBER;
1379:
1380: BEGIN
1381: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
1382: ,G_PKG_NAME
1383: ,p_init_msg_list
1384: ,l_api_version
1385: ,p_api_version

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

1385: ,p_api_version
1386: ,'_PVT'
1387: ,x_return_status);
1388:
1389: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1390: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1391: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1392: RAISE Okl_Api.G_EXCEPTION_ERROR;
1393: END IF;

Line 1390: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1386: ,'_PVT'
1387: ,x_return_status);
1388:
1389: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1390: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1391: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1392: RAISE Okl_Api.G_EXCEPTION_ERROR;
1393: END IF;
1394:

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

1387: ,x_return_status);
1388:
1389: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1390: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1391: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1392: RAISE Okl_Api.G_EXCEPTION_ERROR;
1393: END IF;
1394:
1395: WRITE_TO_LOG('');

Line 1392: RAISE Okl_Api.G_EXCEPTION_ERROR;

1388:
1389: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1390: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1391: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1392: RAISE Okl_Api.G_EXCEPTION_ERROR;
1393: END IF;
1394:
1395: WRITE_TO_LOG('');
1396: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 1425: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1421: ,x_entity_type_code => l_entity_type_code
1422: ,x_event_class_code => l_event_class_code
1423: ,x_return_status => l_return_status);
1424:
1425: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1426: RAISE Okl_Api.G_EXCEPTION_ERROR;
1427: END IF;
1428:
1429: l_event_source_info.source_application_id := g_application_id;

Line 1426: RAISE Okl_Api.G_EXCEPTION_ERROR;

1422: ,x_event_class_code => l_event_class_code
1423: ,x_return_status => l_return_status);
1424:
1425: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1426: RAISE Okl_Api.G_EXCEPTION_ERROR;
1427: END IF;
1428:
1429: l_event_source_info.source_application_id := g_application_id;
1430: l_event_source_info.application_id := g_application_id;

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

1468: ,p_valuation_method => p_representation_code
1469: ,p_security_context => l_security_context);
1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1473: p_msg_name => g_unexpected_error,
1474: p_token1 => g_sqlcode_token,
1475: p_token1_value => SQLCODE,
1476: p_token2 => g_sqlerrm_token,

Line 1479: RAISE Okl_Api.G_EXCEPTION_ERROR;

1475: p_token1_value => SQLCODE,
1476: p_token2 => g_sqlerrm_token,
1477: p_token2_value => SQLERRM);
1478:
1479: RAISE Okl_Api.G_EXCEPTION_ERROR;
1480: END;
1481:
1482: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1483: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

1478:
1479: RAISE Okl_Api.G_EXCEPTION_ERROR;
1480: END;
1481:
1482: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1483: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1484:
1485: WRITE_TO_LOG('');
1486: WRITE_TO_LOG('Done with ' || l_api_name);

Line 1483: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1479: RAISE Okl_Api.G_EXCEPTION_ERROR;
1480: END;
1481:
1482: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1483: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1484:
1485: WRITE_TO_LOG('');
1486: WRITE_TO_LOG('Done with ' || l_api_name);
1487:

Line 1491: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1487:
1488: return l_events_deleted;
1489:
1490: EXCEPTION
1491: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1492: IF get_tcn_csr%ISOPEN THEN
1493: CLOSE get_tcn_csr;
1494: END IF;
1495:

Line 1496: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1492: IF get_tcn_csr%ISOPEN THEN
1493: CLOSE get_tcn_csr;
1494: END IF;
1495:
1496: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1497: ,g_pkg_name
1498: ,'OKL_API.G_RET_STS_ERROR'
1499: ,x_msg_count
1500: ,x_msg_data

Line 1498: ,'OKL_API.G_RET_STS_ERROR'

1494: END IF;
1495:
1496: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1497: ,g_pkg_name
1498: ,'OKL_API.G_RET_STS_ERROR'
1499: ,x_msg_count
1500: ,x_msg_data
1501: ,'_PVT');
1502: return -1;

Line 1503: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1499: ,x_msg_count
1500: ,x_msg_data
1501: ,'_PVT');
1502: return -1;
1503: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1504: IF get_tcn_csr%ISOPEN THEN
1505: CLOSE get_tcn_csr;
1506: END IF;
1507:

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

1504: IF get_tcn_csr%ISOPEN THEN
1505: CLOSE get_tcn_csr;
1506: END IF;
1507:
1508: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1509: p_msg_name => g_unexpected_error,
1510: p_token1 => g_sqlcode_token,
1511: p_token1_value => SQLCODE,
1512: p_token2 => g_sqlerrm_token,

Line 1515: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1511: p_token1_value => SQLCODE,
1512: p_token2 => g_sqlerrm_token,
1513: p_token2_value => SQLERRM);
1514:
1515: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1516: ,g_pkg_name
1517: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1518: ,x_msg_count
1519: ,x_msg_data

Line 1517: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1513: p_token2_value => SQLERRM);
1514:
1515: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1516: ,g_pkg_name
1517: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1518: ,x_msg_count
1519: ,x_msg_data
1520: ,'_PVT');
1521: return -1;

Line 1527: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1523: IF get_tcn_csr%ISOPEN THEN
1524: CLOSE get_tcn_csr;
1525: END IF;
1526:
1527: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1528: (l_api_name,
1529: G_PKG_NAME,
1530: 'OTHERS',
1531: x_msg_count,

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

1572:
1573: l_api_name VARCHAR2(30) := 'GET_EVENT_INFO';
1574: l_api_version CONSTANT NUMBER := 1.0;
1575:
1576: l_init_msg_list VARCHAR2(2000) := OKL_API.G_TRUE;
1577: l_return_status VARCHAR2(1);
1578: l_msg_count NUMBER;
1579: l_msg_data VARCHAR2(2000);
1580:

Line 1582: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

1578: l_msg_count NUMBER;
1579: l_msg_data VARCHAR2(2000);
1580:
1581: BEGIN
1582: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
1583: ,G_PKG_NAME
1584: ,p_init_msg_list
1585: ,l_api_version
1586: ,p_api_version

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

1586: ,p_api_version
1587: ,'_PVT'
1588: ,x_return_status);
1589:
1590: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1591: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1592: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1593: RAISE Okl_Api.G_EXCEPTION_ERROR;
1594: END IF;

Line 1591: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1587: ,'_PVT'
1588: ,x_return_status);
1589:
1590: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1591: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1592: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1593: RAISE Okl_Api.G_EXCEPTION_ERROR;
1594: END IF;
1595:

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

1588: ,x_return_status);
1589:
1590: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1591: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1592: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1593: RAISE Okl_Api.G_EXCEPTION_ERROR;
1594: END IF;
1595:
1596: WRITE_TO_LOG('');

Line 1593: RAISE Okl_Api.G_EXCEPTION_ERROR;

1589:
1590: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1591: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1592: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1593: RAISE Okl_Api.G_EXCEPTION_ERROR;
1594: END IF;
1595:
1596: WRITE_TO_LOG('');
1597: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 1625: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1621: ,x_entity_type_code => l_entity_type_code
1622: ,x_event_class_code => l_event_class_code
1623: ,x_return_status => l_return_status);
1624:
1625: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1626: RAISE Okl_Api.G_EXCEPTION_ERROR;
1627: END IF;
1628:
1629: l_event_source_info.source_application_id := g_application_id;

Line 1626: RAISE Okl_Api.G_EXCEPTION_ERROR;

1622: ,x_event_class_code => l_event_class_code
1623: ,x_return_status => l_return_status);
1624:
1625: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1626: RAISE Okl_Api.G_EXCEPTION_ERROR;
1627: END IF;
1628:
1629: l_event_source_info.source_application_id := g_application_id;
1630: l_event_source_info.application_id := g_application_id;

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

1660: ,p_valuation_method => p_representation_code
1661: ,p_security_context => l_security_context);
1662: EXCEPTION
1663: WHEN OTHERS THEN
1664: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1665: p_msg_name => g_unexpected_error,
1666: p_token1 => g_sqlcode_token,
1667: p_token1_value => SQLCODE,
1668: p_token2 => g_sqlerrm_token,

Line 1671: RAISE Okl_Api.G_EXCEPTION_ERROR;

1667: p_token1_value => SQLCODE,
1668: p_token2 => g_sqlerrm_token,
1669: p_token2_value => SQLERRM);
1670:
1671: RAISE Okl_Api.G_EXCEPTION_ERROR;
1672: END;
1673:
1674: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1675: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

1670:
1671: RAISE Okl_Api.G_EXCEPTION_ERROR;
1672: END;
1673:
1674: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1675: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1676:
1677: WRITE_TO_LOG('');
1678: WRITE_TO_LOG('Done with ' || l_api_name);

Line 1675: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1671: RAISE Okl_Api.G_EXCEPTION_ERROR;
1672: END;
1673:
1674: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1675: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1676:
1677: WRITE_TO_LOG('');
1678: WRITE_TO_LOG('Done with ' || l_api_name);
1679:

Line 1683: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1679:
1680: return l_event_info;
1681:
1682: EXCEPTION
1683: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1684: IF get_tcn_csr%ISOPEN THEN
1685: CLOSE get_tcn_csr;
1686: END IF;
1687:

Line 1688: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1684: IF get_tcn_csr%ISOPEN THEN
1685: CLOSE get_tcn_csr;
1686: END IF;
1687:
1688: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1689: ,g_pkg_name
1690: ,'OKL_API.G_RET_STS_ERROR'
1691: ,x_msg_count
1692: ,x_msg_data

Line 1690: ,'OKL_API.G_RET_STS_ERROR'

1686: END IF;
1687:
1688: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1689: ,g_pkg_name
1690: ,'OKL_API.G_RET_STS_ERROR'
1691: ,x_msg_count
1692: ,x_msg_data
1693: ,'_PVT');
1694: RETURN NULL;

Line 1695: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1691: ,x_msg_count
1692: ,x_msg_data
1693: ,'_PVT');
1694: RETURN NULL;
1695: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1696: IF get_tcn_csr%ISOPEN THEN
1697: CLOSE get_tcn_csr;
1698: END IF;
1699:

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

1696: IF get_tcn_csr%ISOPEN THEN
1697: CLOSE get_tcn_csr;
1698: END IF;
1699:
1700: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1701: p_msg_name => g_unexpected_error,
1702: p_token1 => g_sqlcode_token,
1703: p_token1_value => SQLCODE,
1704: p_token2 => g_sqlerrm_token,

Line 1707: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1703: p_token1_value => SQLCODE,
1704: p_token2 => g_sqlerrm_token,
1705: p_token2_value => SQLERRM);
1706:
1707: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1708: ,g_pkg_name
1709: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1710: ,x_msg_count
1711: ,x_msg_data

Line 1709: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1705: p_token2_value => SQLERRM);
1706:
1707: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1708: ,g_pkg_name
1709: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1710: ,x_msg_count
1711: ,x_msg_data
1712: ,'_PVT');
1713: RETURN NULL;

Line 1719: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1715: IF get_tcn_csr%ISOPEN THEN
1716: CLOSE get_tcn_csr;
1717: END IF;
1718:
1719: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1720: (l_api_name,
1721: G_PKG_NAME,
1722: 'OTHERS',
1723: x_msg_count,

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

1771:
1772: l_api_name VARCHAR2(30) := 'GET_ARRAY_EVENT_INFO';
1773: l_api_version CONSTANT NUMBER := 1.0;
1774:
1775: l_init_msg_list VARCHAR2(2000) := OKL_API.G_FALSE;
1776: l_return_status VARCHAR2(1);
1777: l_msg_count NUMBER;
1778: l_msg_data VARCHAR2(2000);
1779:

Line 1782: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

1778: l_msg_data VARCHAR2(2000);
1779:
1780:
1781: BEGIN
1782: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
1783: ,G_PKG_NAME
1784: ,p_init_msg_list
1785: ,l_api_version
1786: ,p_api_version

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

1786: ,p_api_version
1787: ,'_PVT'
1788: ,x_return_status);
1789:
1790: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1791: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1792: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1793: RAISE Okl_Api.G_EXCEPTION_ERROR;
1794: END IF;

Line 1791: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1787: ,'_PVT'
1788: ,x_return_status);
1789:
1790: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1791: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1792: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1793: RAISE Okl_Api.G_EXCEPTION_ERROR;
1794: END IF;
1795:

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

1788: ,x_return_status);
1789:
1790: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1791: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1792: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1793: RAISE Okl_Api.G_EXCEPTION_ERROR;
1794: END IF;
1795:
1796: l_array_event_info_null := l_array_event_info;

Line 1793: RAISE Okl_Api.G_EXCEPTION_ERROR;

1789:
1790: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1791: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1792: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1793: RAISE Okl_Api.G_EXCEPTION_ERROR;
1794: END IF;
1795:
1796: l_array_event_info_null := l_array_event_info;
1797:

Line 1829: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

1825: ,x_entity_type_code => l_entity_type_code
1826: ,x_event_class_code => l_event_class_code
1827: ,x_return_status => l_return_status);
1828:
1829: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1830: RAISE Okl_Api.G_EXCEPTION_ERROR;
1831: END IF;
1832:
1833: l_event_source_info.source_application_id := g_application_id;

Line 1830: RAISE Okl_Api.G_EXCEPTION_ERROR;

1826: ,x_event_class_code => l_event_class_code
1827: ,x_return_status => l_return_status);
1828:
1829: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
1830: RAISE Okl_Api.G_EXCEPTION_ERROR;
1831: END IF;
1832:
1833: l_event_source_info.source_application_id := g_application_id;
1834: l_event_source_info.application_id := g_application_id;

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

1867: ,p_valuation_method => p_representation_code
1868: ,p_security_context => l_security_context);
1869: EXCEPTION
1870: WHEN OTHERS THEN
1871: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1872: p_msg_name => g_unexpected_error,
1873: p_token1 => g_sqlcode_token,
1874: p_token1_value => SQLCODE,
1875: p_token2 => g_sqlerrm_token,

Line 1878: RAISE Okl_Api.G_EXCEPTION_ERROR;

1874: p_token1_value => SQLCODE,
1875: p_token2 => g_sqlerrm_token,
1876: p_token2_value => SQLERRM);
1877:
1878: RAISE Okl_Api.G_EXCEPTION_ERROR;
1879: END;
1880:
1881: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1882: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

1877:
1878: RAISE Okl_Api.G_EXCEPTION_ERROR;
1879: END;
1880:
1881: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1882: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1883:
1884: WRITE_TO_LOG('');
1885: WRITE_TO_LOG('Done with ' || l_api_name);

Line 1882: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1878: RAISE Okl_Api.G_EXCEPTION_ERROR;
1879: END;
1880:
1881: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1882: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1883:
1884: WRITE_TO_LOG('');
1885: WRITE_TO_LOG('Done with ' || l_api_name);
1886:

Line 1890: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1886:
1887: RETURN l_array_event_info;
1888:
1889: EXCEPTION
1890: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1891: IF get_tcn_csr%ISOPEN THEN
1892: CLOSE get_tcn_csr;
1893: END IF;
1894:

Line 1895: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1891: IF get_tcn_csr%ISOPEN THEN
1892: CLOSE get_tcn_csr;
1893: END IF;
1894:
1895: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1896: ,g_pkg_name
1897: ,'OKL_API.G_RET_STS_ERROR'
1898: ,x_msg_count
1899: ,x_msg_data

Line 1897: ,'OKL_API.G_RET_STS_ERROR'

1893: END IF;
1894:
1895: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1896: ,g_pkg_name
1897: ,'OKL_API.G_RET_STS_ERROR'
1898: ,x_msg_count
1899: ,x_msg_data
1900: ,'_PVT');
1901: RETURN l_array_event_info_null;

Line 1902: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1898: ,x_msg_count
1899: ,x_msg_data
1900: ,'_PVT');
1901: RETURN l_array_event_info_null;
1902: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1903: IF get_tcn_csr%ISOPEN THEN
1904: CLOSE get_tcn_csr;
1905: END IF;
1906:

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

1903: IF get_tcn_csr%ISOPEN THEN
1904: CLOSE get_tcn_csr;
1905: END IF;
1906:
1907: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1908: p_msg_name => g_unexpected_error,
1909: p_token1 => g_sqlcode_token,
1910: p_token1_value => SQLCODE,
1911: p_token2 => g_sqlerrm_token,

Line 1914: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1910: p_token1_value => SQLCODE,
1911: p_token2 => g_sqlerrm_token,
1912: p_token2_value => SQLERRM);
1913:
1914: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1915: ,g_pkg_name
1916: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1917: ,x_msg_count
1918: ,x_msg_data

Line 1916: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1912: p_token2_value => SQLERRM);
1913:
1914: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1915: ,g_pkg_name
1916: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1917: ,x_msg_count
1918: ,x_msg_data
1919: ,'_PVT');
1920: RETURN l_array_event_info_null;

Line 1926: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1922: IF get_tcn_csr%ISOPEN THEN
1923: CLOSE get_tcn_csr;
1924: END IF;
1925:
1926: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1927: (l_api_name,
1928: G_PKG_NAME,
1929: 'OTHERS',
1930: x_msg_count,

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

1967:
1968: l_api_name VARCHAR2(30) := 'GET_EVENT_STATUS';
1969: l_api_version CONSTANT NUMBER := 1.0;
1970:
1971: l_init_msg_list VARCHAR2(2000) := OKL_API.G_FALSE;
1972: l_return_status VARCHAR2(1);
1973: l_msg_count NUMBER;
1974: l_msg_data VARCHAR2(2000);
1975:

Line 1978: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

1974: l_msg_data VARCHAR2(2000);
1975:
1976:
1977: BEGIN
1978: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
1979: ,G_PKG_NAME
1980: ,p_init_msg_list
1981: ,l_api_version
1982: ,p_api_version

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

1982: ,p_api_version
1983: ,'_PVT'
1984: ,x_return_status);
1985:
1986: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1987: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1988: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1989: RAISE Okl_Api.G_EXCEPTION_ERROR;
1990: END IF;

Line 1987: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1983: ,'_PVT'
1984: ,x_return_status);
1985:
1986: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1987: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1988: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1989: RAISE Okl_Api.G_EXCEPTION_ERROR;
1990: END IF;
1991:

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

1984: ,x_return_status);
1985:
1986: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1987: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1988: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1989: RAISE Okl_Api.G_EXCEPTION_ERROR;
1990: END IF;
1991:
1992: WRITE_TO_LOG('');

Line 1989: RAISE Okl_Api.G_EXCEPTION_ERROR;

1985:
1986: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1987: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1988: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1989: RAISE Okl_Api.G_EXCEPTION_ERROR;
1990: END IF;
1991:
1992: WRITE_TO_LOG('');
1993: WRITE_TO_LOG('Inside the call to ' || l_api_name);

Line 2021: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN

2017: ,x_entity_type_code => l_entity_type_code
2018: ,x_event_class_code => l_event_class_code
2019: ,x_return_status => l_return_status);
2020:
2021: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
2022: RAISE Okl_Api.G_EXCEPTION_ERROR;
2023: END IF;
2024:
2025: l_event_source_info.source_application_id := g_application_id;

Line 2022: RAISE Okl_Api.G_EXCEPTION_ERROR;

2018: ,x_event_class_code => l_event_class_code
2019: ,x_return_status => l_return_status);
2020:
2021: IF l_return_status = Okl_Api.G_RET_STS_ERROR THEN
2022: RAISE Okl_Api.G_EXCEPTION_ERROR;
2023: END IF;
2024:
2025: l_event_source_info.source_application_id := g_application_id;
2026: l_event_source_info.application_id := g_application_id;

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

2056: ,p_valuation_method => p_representation_code
2057: ,p_security_context => l_security_context);
2058: EXCEPTION
2059: WHEN OTHERS THEN
2060: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
2061: p_msg_name => g_unexpected_error,
2062: p_token1 => g_sqlcode_token,
2063: p_token1_value => SQLCODE,
2064: p_token2 => g_sqlerrm_token,

Line 2067: RAISE Okl_Api.G_EXCEPTION_ERROR;

2063: p_token1_value => SQLCODE,
2064: p_token2 => g_sqlerrm_token,
2065: p_token2_value => SQLERRM);
2066:
2067: RAISE Okl_Api.G_EXCEPTION_ERROR;
2068: END;
2069:
2070: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2071: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

2066:
2067: RAISE Okl_Api.G_EXCEPTION_ERROR;
2068: END;
2069:
2070: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2071: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2072:
2073: WRITE_TO_LOG('');
2074: WRITE_TO_LOG('Done with ' || l_api_name);

Line 2071: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2067: RAISE Okl_Api.G_EXCEPTION_ERROR;
2068: END;
2069:
2070: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2071: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2072:
2073: WRITE_TO_LOG('');
2074: WRITE_TO_LOG('Done with ' || l_api_name);
2075:

Line 2079: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2075:
2076: RETURN l_event_status_code;
2077:
2078: EXCEPTION
2079: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2080: IF get_tcn_csr%ISOPEN THEN
2081: CLOSE get_tcn_csr;
2082: END IF;
2083:

Line 2084: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

2080: IF get_tcn_csr%ISOPEN THEN
2081: CLOSE get_tcn_csr;
2082: END IF;
2083:
2084: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2085: ,g_pkg_name
2086: ,'OKL_API.G_RET_STS_ERROR'
2087: ,x_msg_count
2088: ,x_msg_data

Line 2086: ,'OKL_API.G_RET_STS_ERROR'

2082: END IF;
2083:
2084: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2085: ,g_pkg_name
2086: ,'OKL_API.G_RET_STS_ERROR'
2087: ,x_msg_count
2088: ,x_msg_data
2089: ,'_PVT');
2090: RETURN 'F';

Line 2091: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2087: ,x_msg_count
2088: ,x_msg_data
2089: ,'_PVT');
2090: RETURN 'F';
2091: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2092: IF get_tcn_csr%ISOPEN THEN
2093: CLOSE get_tcn_csr;
2094: END IF;
2095:

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

2092: IF get_tcn_csr%ISOPEN THEN
2093: CLOSE get_tcn_csr;
2094: END IF;
2095:
2096: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
2097: p_msg_name => g_unexpected_error,
2098: p_token1 => g_sqlcode_token,
2099: p_token1_value => SQLCODE,
2100: p_token2 => g_sqlerrm_token,

Line 2103: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

2099: p_token1_value => SQLCODE,
2100: p_token2 => g_sqlerrm_token,
2101: p_token2_value => SQLERRM);
2102:
2103: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2104: ,g_pkg_name
2105: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2106: ,x_msg_count
2107: ,x_msg_data

Line 2105: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

2101: p_token2_value => SQLERRM);
2102:
2103: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
2104: ,g_pkg_name
2105: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
2106: ,x_msg_count
2107: ,x_msg_data
2108: ,'_PVT');
2109: RETURN 'F';

Line 2115: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

2111: IF get_tcn_csr%ISOPEN THEN
2112: CLOSE get_tcn_csr;
2113: END IF;
2114:
2115: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2116: (l_api_name,
2117: G_PKG_NAME,
2118: 'OTHERS',
2119: x_msg_count,

Line 2148: x_return_status := Okl_Api.START_ACTIVITY(l_api_name

2144: l_api_name VARCHAR2(30) := 'EVENT_EXISTS';
2145: l_api_version CONSTANT NUMBER := 1.0;
2146:
2147: BEGIN
2148: x_return_status := Okl_Api.START_ACTIVITY(l_api_name
2149: ,G_PKG_NAME
2150: ,p_init_msg_list
2151: ,l_api_version
2152: ,p_api_version

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

2152: ,p_api_version
2153: ,'_PVT'
2154: ,x_return_status);
2155:
2156: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2157: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2158: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2159: RAISE Okl_Api.G_EXCEPTION_ERROR;
2160: END IF;

Line 2157: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2153: ,'_PVT'
2154: ,x_return_status);
2155:
2156: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2157: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2158: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2159: RAISE Okl_Api.G_EXCEPTION_ERROR;
2160: END IF;
2161:

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

2154: ,x_return_status);
2155:
2156: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2157: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2158: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2159: RAISE Okl_Api.G_EXCEPTION_ERROR;
2160: END IF;
2161:
2162: WRITE_TO_LOG('');

Line 2159: RAISE Okl_Api.G_EXCEPTION_ERROR;

2155:
2156: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2157: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2158: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
2159: RAISE Okl_Api.G_EXCEPTION_ERROR;
2160: END IF;
2161:
2162: WRITE_TO_LOG('');
2163: WRITE_TO_LOG('Inside the call to ' || l_api_name);

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

2208: FETCH get_event_csr into x_event_id, x_event_date;
2209: CLOSE get_event_csr;
2210: END IF;
2211:
2212: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2213: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2214:
2215: WRITE_TO_LOG('');
2216: WRITE_TO_LOG('Done with ' || l_api_name);

Line 2213: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2209: CLOSE get_event_csr;
2210: END IF;
2211:
2212: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2213: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2214:
2215: WRITE_TO_LOG('');
2216: WRITE_TO_LOG('Done with ' || l_api_name);
2217:

Line 2224: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

2220: IF get_event_csr%ISOPEN THEN
2221: CLOSE get_event_csr;
2222: END IF;
2223:
2224: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
2225: (l_api_name,
2226: G_PKG_NAME,
2227: 'OTHERS',
2228: x_msg_count,