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_POOLCONC_PVT dependencies on OKL_API

Line 73: ,p_multi_org IN VARCHAR2 DEFAULT OKL_API.G_FALSE

69: PROCEDURE add_pool_contents(x_errbuf OUT NOCOPY VARCHAR2
70: ,x_retcode OUT NOCOPY NUMBER
71: ,p_pol_id IN VARCHAR2
72: ,p_currency_code IN VARCHAR2
73: ,p_multi_org IN VARCHAR2 DEFAULT OKL_API.G_FALSE
74: ,p_cust_object1_id1 IN VARCHAR2 DEFAULT NULL -- customer_id
75: ,p_sic_code IN VARCHAR2 DEFAULT NULL
76: ,p_dnz_chr_id IN VARCHAR2 DEFAULT NULL -- dnz_chr_id
77: ,p_pre_tax_yield_from IN VARCHAR2 DEFAULT NULL

Line 252: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

248:
249: BEGIN
250:
251: x_retcode := 0;
252: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
253: p_pkg_name => G_PKG_NAME,
254: p_init_msg_list => l_init_msg_list,
255: l_api_version => l_api_version,
256: p_api_version => p_api_version,

Line 261: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));

257: p_api_type => G_API_TYPE,
258: x_return_status => l_return_status);
259:
260: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
261: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
262: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
263: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
264: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
265: RAISE G_EXCEPTION_ERROR;

Line 264: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));

260: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
261: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
262: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
263: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
264: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
265: RAISE G_EXCEPTION_ERROR;
266: END IF;
267:
268: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

Line 268: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

264: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
265: RAISE G_EXCEPTION_ERROR;
266: END IF;
267:
268: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
269: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
270:
271: -- Printing the values in the log file.
272:

Line 585: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);

581: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
582: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
584:
585: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
586: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
587:
588: -- "No Errors"
589: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_NONE);

Line 586: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));

582: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
584:
585: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
586: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
587:
588: -- "No Errors"
589: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_NONE);
590: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_filler || l_content);

Line 598: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

594: EXCEPTION
595: WHEN G_EXCEPTION_ERROR THEN
596: x_retcode := 2;
597:
598: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
599: p_pkg_name => G_PKG_NAME,
600: p_exc_name => G_EXC_NAME_ERROR,
601: x_msg_count => l_msg_count,
602: x_msg_data => l_msg_data,

Line 618: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

614:
615: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
616: x_retcode := 2;
617:
618: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
619: p_pkg_name => G_PKG_NAME,
620: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
621: x_msg_count => l_msg_count,
622: x_msg_data => l_msg_data,

Line 637: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

633: WHEN OTHERS THEN
634: x_errbuf := SQLERRM;
635: x_retcode := 2;
636:
637: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
638: p_pkg_name => G_PKG_NAME,
639: p_exc_name => G_EXC_NAME_OTHERS,
640: x_msg_count => l_msg_count,
641: x_msg_data => l_msg_data,

Line 668: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

664: ----------------------------------------------------------------------------------
665:
666: PROCEDURE add_pool_contents_ui(
667: p_api_version IN NUMBER
668: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
669: ,x_return_status OUT nocopy VARCHAR2
670: ,x_msg_count OUT nocopy NUMBER
671: ,x_msg_data OUT nocopy VARCHAR2
672: ,x_request_id OUT nocopy NUMBER

Line 677: ,p_multi_org IN VARCHAR2 DEFAULT OKL_API.G_FALSE)

673: ,p_polsrch_rec IN polsrch_rec_type
674: ,p_sty_id1 IN NUMBER DEFAULT NULL
675: ,p_sty_id2 IN NUMBER DEFAULT NULL
676: ,p_stream_type_subclass IN VARCHAR2 DEFAULT NULL
677: ,p_multi_org IN VARCHAR2 DEFAULT OKL_API.G_FALSE)
678: AS
679: l_api_name VARCHAR2(30) := 'add_pool_contents_ui';
680: l_api_version NUMBER := 1.0;
681: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 688: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

684: BEGIN
685:
686: x_return_status := G_RET_STS_SUCCESS;
687:
688: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
689: p_pkg_name => G_PKG_NAME,
690: p_init_msg_list => p_init_msg_list,
691: l_api_version => l_api_version,
692: p_api_version => p_api_version,

Line 743: OKL_API.set_message(p_app_name => G_APP_NAME,

739: );
740:
741: -- Added these validations to check to see if the request has been submitted successfully.
742: IF x_request_id = 0 THEN
743: OKL_API.set_message(p_app_name => G_APP_NAME,
744: p_msg_name => 'OKL_CONC_REQ_ERROR',
745: p_token1 => 'PROG_NAME',
746: p_token1_value => 'OKL ADD Pool CONTENTS',
747: p_token2 => 'REQUEST_ID',

Line 753: OKL_API.end_activity(x_msg_count, x_msg_data);

749:
750: RAISE G_EXCEPTION_ERROR;
751: END IF;
752:
753: OKL_API.end_activity(x_msg_count, x_msg_data);
754:
755: EXCEPTION
756: WHEN G_EXCEPTION_ERROR THEN
757:

Line 758: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

754:
755: EXCEPTION
756: WHEN G_EXCEPTION_ERROR THEN
757:
758: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
759: p_pkg_name => G_PKG_NAME,
760: p_exc_name => G_EXC_NAME_ERROR,
761: x_msg_count => x_msg_count,
762: x_msg_data => x_msg_data,

Line 766: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

762: x_msg_data => x_msg_data,
763: p_api_type => G_API_TYPE);
764: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
765:
766: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
767: p_pkg_name => G_PKG_NAME,
768: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
769: x_msg_count => x_msg_count,
770: x_msg_data => x_msg_data,

Line 774: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

770: x_msg_data => x_msg_data,
771: p_api_type => G_API_TYPE);
772: WHEN OTHERS THEN
773:
774: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
775: p_pkg_name => G_PKG_NAME,
776: p_exc_name => G_EXC_NAME_OTHERS,
777: x_msg_count => x_msg_count,
778: x_msg_data => x_msg_data,

Line 833: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

829:
830: BEGIN
831:
832: x_retcode := 0;
833: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
834: p_pkg_name => G_PKG_NAME,
835: p_init_msg_list => l_init_msg_list,
836: l_api_version => l_api_version,
837: p_api_version => p_api_version,

Line 842: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));

838: p_api_type => G_API_TYPE,
839: x_return_status => l_return_status);
840:
841: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
842: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
843: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
844: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
845: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
846: RAISE G_EXCEPTION_ERROR;

Line 845: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));

841: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
842: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
843: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
844: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
845: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
846: RAISE G_EXCEPTION_ERROR;
847: END IF;
848: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
849: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 848: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

844: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
845: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
846: RAISE G_EXCEPTION_ERROR;
847: END IF;
848: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
849: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
850:
851: -- Printing the values in the log file.
852: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 926: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);

922: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || i);
923: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
924: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
925:
926: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
927: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
928:
929: x_retcode := 0;
930:

Line 927: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));

923: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
924: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
925:
926: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
927: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
928:
929: x_retcode := 0;
930:
931: EXCEPTION

Line 934: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

930:
931: EXCEPTION
932: WHEN G_EXCEPTION_ERROR THEN
933: x_retcode := 2;
934: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
935: p_pkg_name => G_PKG_NAME,
936: p_exc_name => G_EXC_NAME_ERROR,
937: x_msg_count => l_msg_count,
938: x_msg_data => l_msg_data,

Line 950: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

946: END LOOP;
947: END IF;
948: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
949: x_retcode := 2;
950: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
951: p_pkg_name => G_PKG_NAME,
952: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
953: x_msg_count => l_msg_count,
954: x_msg_data => l_msg_data,

Line 967: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

963: END IF;
964: WHEN OTHERS THEN
965: x_errbuf := SQLERRM;
966: x_retcode := 2;
967: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
968: p_pkg_name => G_PKG_NAME,
969: p_exc_name => G_EXC_NAME_OTHERS,
970: x_msg_count => l_msg_count,
971: x_msg_data => l_msg_data,

Line 997: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

993: ----------------------------------------------------------------------------------
994:
995: PROCEDURE recal_tot_princ_amt_ui(
996: p_api_version IN NUMBER
997: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
998: ,x_return_status OUT NOCOPY VARCHAR2
999: ,x_msg_count OUT NOCOPY NUMBER
1000: ,x_msg_data OUT NOCOPY VARCHAR2
1001: -- concurent out parameter

Line 1014: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

1010: BEGIN
1011:
1012: x_return_status := G_RET_STS_SUCCESS;
1013:
1014: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
1015: p_pkg_name => G_PKG_NAME,
1016: p_init_msg_list => p_init_msg_list,
1017: l_api_version => l_api_version,
1018: p_api_version => p_api_version,

Line 1038: OKL_API.set_message(p_app_name => G_APP_NAME,

1034: ,argument1 => p_pool_number);
1035:
1036: -- Added these validations to check to see if the request has been submitted successfully.
1037: IF x_request_id = 0 THEN
1038: OKL_API.set_message(p_app_name => G_APP_NAME,
1039: p_msg_name => 'OKL_CONC_REQ_ERROR',
1040: p_token1 => 'PROG_NAME',
1041: p_token1_value => 'OKL_RECAL_POOL_PRINC_AMT',
1042: p_token2 => 'REQUEST_ID',

Line 1048: OKL_API.end_activity(x_msg_count, x_msg_data);

1044:
1045: RAISE G_EXCEPTION_ERROR;
1046: END IF;
1047:
1048: OKL_API.end_activity(x_msg_count, x_msg_data);
1049:
1050: EXCEPTION
1051: WHEN G_EXCEPTION_ERROR THEN
1052:

Line 1053: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1049:
1050: EXCEPTION
1051: WHEN G_EXCEPTION_ERROR THEN
1052:
1053: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1054: p_pkg_name => G_PKG_NAME,
1055: p_exc_name => G_EXC_NAME_ERROR,
1056: x_msg_count => x_msg_count,
1057: x_msg_data => x_msg_data,

Line 1061: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1057: x_msg_data => x_msg_data,
1058: p_api_type => G_API_TYPE);
1059: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1060:
1061: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1062: p_pkg_name => G_PKG_NAME,
1063: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1064: x_msg_count => x_msg_count,
1065: x_msg_data => x_msg_data,

Line 1069: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1065: x_msg_data => x_msg_data,
1066: p_api_type => G_API_TYPE);
1067: WHEN OTHERS THEN
1068:
1069: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1070: p_pkg_name => G_PKG_NAME,
1071: p_exc_name => G_EXC_NAME_OTHERS,
1072: x_msg_count => x_msg_count,
1073: x_msg_data => x_msg_data,

Line 1133: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

1129:
1130: BEGIN
1131:
1132: x_retcode := 0;
1133: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
1134: p_pkg_name => G_PKG_NAME,
1135: p_init_msg_list => l_init_msg_list,
1136: l_api_version => l_api_version,
1137: p_api_version => p_api_version,

Line 1142: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));

1138: p_api_type => G_API_TYPE,
1139: x_return_status => l_return_status);
1140:
1141: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1142: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
1143: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1144: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1145: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1146: RAISE G_EXCEPTION_ERROR;

Line 1145: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));

1141: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1142: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
1143: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1144: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1145: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1146: RAISE G_EXCEPTION_ERROR;
1147: END IF;
1148:
1149: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

Line 1149: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

1145: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1146: RAISE G_EXCEPTION_ERROR;
1147: END IF;
1148:
1149: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
1150: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1151:
1152: -- Printing the values in the log file.
1153:

Line 1226: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);

1222: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || i);
1223: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
1224: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
1225:
1226: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
1228:
1229: EXCEPTION
1230: WHEN G_EXCEPTION_ERROR THEN

Line 1227: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));

1223: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
1224: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
1225:
1226: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
1227: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
1228:
1229: EXCEPTION
1230: WHEN G_EXCEPTION_ERROR THEN
1231: x_retcode := 2;

Line 1232: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1228:
1229: EXCEPTION
1230: WHEN G_EXCEPTION_ERROR THEN
1231: x_retcode := 2;
1232: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1233: p_pkg_name => G_PKG_NAME,
1234: p_exc_name => G_EXC_NAME_ERROR,
1235: x_msg_count => l_msg_count,
1236: x_msg_data => l_msg_data,

Line 1248: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1244: END LOOP;
1245: END IF;
1246: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1247: x_retcode := 2;
1248: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1249: p_pkg_name => G_PKG_NAME,
1250: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1251: x_msg_count => l_msg_count,
1252: x_msg_data => l_msg_data,

Line 1265: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1261: END IF;
1262: WHEN OTHERS THEN
1263: x_errbuf := SQLERRM;
1264: x_retcode := 2;
1265: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1266: p_pkg_name => G_PKG_NAME,
1267: p_exc_name => G_EXC_NAME_OTHERS,
1268: x_msg_count => l_msg_count,
1269: x_msg_data => l_msg_data,

Line 1336: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

1332:
1333: BEGIN
1334:
1335: x_retcode := 0;
1336: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
1337: p_pkg_name => G_PKG_NAME,
1338: p_init_msg_list => l_init_msg_list,
1339: l_api_version => l_api_version,
1340: p_api_version => p_api_version,

Line 1345: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));

1341: p_api_type => G_API_TYPE,
1342: x_return_status => l_return_status);
1343:
1344: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1345: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
1346: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1347: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1348: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1349: RAISE G_EXCEPTION_ERROR;

Line 1348: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));

1344: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1345: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
1346: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1347: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1348: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1349: RAISE G_EXCEPTION_ERROR;
1350: END IF;
1351:
1352: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

Line 1352: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

1348: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1349: RAISE G_EXCEPTION_ERROR;
1350: END IF;
1351:
1352: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
1353: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1354:
1355: -- Printing the values in the log file.
1356:

Line 1439: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);

1435: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED) || i);
1436: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
1437: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
1438:
1439: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
1440: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
1441:
1442: EXCEPTION
1443: WHEN G_EXCEPTION_ERROR THEN

Line 1440: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));

1436: --FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_TOTAL_ROWS_PROCESSED));
1437: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
1438:
1439: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
1440: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
1441:
1442: EXCEPTION
1443: WHEN G_EXCEPTION_ERROR THEN
1444: x_retcode := 2;

Line 1445: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1441:
1442: EXCEPTION
1443: WHEN G_EXCEPTION_ERROR THEN
1444: x_retcode := 2;
1445: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1446: p_pkg_name => G_PKG_NAME,
1447: p_exc_name => G_EXC_NAME_ERROR,
1448: x_msg_count => l_msg_count,
1449: x_msg_data => l_msg_data,

Line 1461: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1457: END LOOP;
1458: END IF;
1459: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1460: x_retcode := 2;
1461: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1462: p_pkg_name => G_PKG_NAME,
1463: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1464: x_msg_count => l_msg_count,
1465: x_msg_data => l_msg_data,

Line 1478: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1474: END IF;
1475: WHEN OTHERS THEN
1476: x_errbuf := SQLERRM;
1477: x_retcode := 2;
1478: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1479: p_pkg_name => G_PKG_NAME,
1480: p_exc_name => G_EXC_NAME_OTHERS,
1481: x_msg_count => l_msg_count,
1482: x_msg_data => l_msg_data,

Line 1508: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

1504: -- End of comments
1505: ----------------------------------------------------------------------------------
1506: PROCEDURE reconcile_pool_contents_ui(
1507: p_api_version IN NUMBER
1508: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
1509: ,p_pool_number IN okl_pools.POOL_NUMBER%TYPE DEFAULT NULL
1510: ,x_return_status OUT NOCOPY VARCHAR2
1511: ,x_msg_count OUT NOCOPY NUMBER
1512: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1520: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

1516: l_api_version NUMBER := 1.0;
1517: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1518:
1519: BEGIN
1520: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1521: p_pkg_name => G_PKG_NAME,
1522: p_init_msg_list => p_init_msg_list,
1523: l_api_version => l_api_version,
1524: p_api_version => p_api_version,

Line 1542: OKL_API.set_message(p_app_name => G_APP_NAME,

1538:
1539: -- Added these validations to check to see if the request has been submitted successfully.
1540: IF x_request_id = 0 THEN
1541:
1542: OKL_API.set_message(p_app_name => G_APP_NAME,
1543: p_msg_name => 'OKL_CONC_REQ_ERROR',
1544: p_token1 => 'PROG_NAME',
1545: p_token1_value => 'OKL Reconcile Pool CONTENTS',
1546: p_token2 => 'REQUEST_ID',

Line 1552: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1548:
1549: RAISE G_EXCEPTION_ERROR;
1550: END IF;
1551:
1552: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1553:
1554: x_return_status := l_return_status;
1555:
1556: EXCEPTION

Line 1559: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1555:
1556: EXCEPTION
1557: WHEN G_EXCEPTION_ERROR THEN
1558:
1559: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1560: p_pkg_name => G_PKG_NAME,
1561: p_exc_name => G_EXC_NAME_ERROR,
1562: x_msg_count => x_msg_count,
1563: x_msg_data => x_msg_data,

Line 1567: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1563: x_msg_data => x_msg_data,
1564: p_api_type => G_API_TYPE);
1565: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1566:
1567: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1568: p_pkg_name => G_PKG_NAME,
1569: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1570: x_msg_count => x_msg_count,
1571: x_msg_data => x_msg_data,

Line 1575: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

1571: x_msg_data => x_msg_data,
1572: p_api_type => G_API_TYPE);
1573: WHEN OTHERS THEN
1574:
1575: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1576: p_pkg_name => G_PKG_NAME,
1577: p_exc_name => G_EXC_NAME_OTHERS,
1578: x_msg_count => x_msg_count,
1579: x_msg_data => x_msg_data,

Line 1603: ,p_multi_org IN VARCHAR2 DEFAULT OKL_API.G_FALSE

1599: PROCEDURE cleanup_pool_contents(x_errbuf OUT NOCOPY VARCHAR2
1600: ,x_retcode OUT NOCOPY NUMBER
1601: ,p_pol_id IN VARCHAR2
1602: ,p_currency_code IN VARCHAR2
1603: ,p_multi_org IN VARCHAR2 DEFAULT OKL_API.G_FALSE
1604: ,p_cust_object1_id1 IN VARCHAR2 DEFAULT NULL -- customer_id
1605: ,p_sic_code IN VARCHAR2 DEFAULT NULL
1606: ,p_dnz_chr_id IN VARCHAR2 DEFAULT NULL -- dnz_chr_id
1607: ,p_pre_tax_yield_from IN VARCHAR2 DEFAULT NULL

Line 1819: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

1815: BEGIN
1816:
1817: x_retcode := 0;
1818:
1819: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
1820: p_pkg_name => G_PKG_NAME,
1821: p_init_msg_list => l_init_msg_list,
1822: l_api_version => l_api_version,
1823: p_api_version => p_api_version,

Line 1828: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));

1824: p_api_type => G_API_TYPE,
1825: x_return_status => l_return_status);
1826:
1827: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1828: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
1829: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1830: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1831: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1832: RAISE G_EXCEPTION_ERROR;

Line 1831: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));

1827: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1828: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
1829: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
1830: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
1831: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1832: RAISE G_EXCEPTION_ERROR;
1833: END IF;
1834:
1835: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

Line 1835: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

1831: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
1832: RAISE G_EXCEPTION_ERROR;
1833: END IF;
1834:
1835: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
1836: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1837:
1838: -- Printing the values in the log file.
1839:

Line 2222: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);

2218: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2219: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
2220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2221:
2222: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
2223: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
2224:
2225: -- "No Errors"
2226: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_NONE);

Line 2223: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));

2219: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
2220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2221:
2222: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
2223: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
2224:
2225: -- "No Errors"
2226: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_NONE);
2227: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_filler || l_content);

Line 2237: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2233: EXCEPTION
2234: WHEN G_EXCEPTION_ERROR THEN
2235: x_retcode := 2;
2236:
2237: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2238: p_pkg_name => G_PKG_NAME,
2239: p_exc_name => G_EXC_NAME_ERROR,
2240: x_msg_count => l_msg_count,
2241: x_msg_data => l_msg_data,

Line 2258: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2254:
2255: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2256: x_retcode := 2;
2257:
2258: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2259: p_pkg_name => G_PKG_NAME,
2260: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2261: x_msg_count => l_msg_count,
2262: x_msg_data => l_msg_data,

Line 2278: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2274: WHEN OTHERS THEN
2275: x_errbuf := SQLERRM;
2276: x_retcode := 2;
2277:
2278: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2279: p_pkg_name => G_PKG_NAME,
2280: p_exc_name => G_EXC_NAME_OTHERS,
2281: x_msg_count => l_msg_count,
2282: x_msg_data => l_msg_data,

Line 2312: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

2308: ----------------------------------------------------------------------------------
2309:
2310: PROCEDURE cleanup_pool_contents_ui(
2311: p_api_version IN NUMBER
2312: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
2313: ,x_return_status OUT nocopy VARCHAR2
2314: ,x_msg_count OUT nocopy NUMBER
2315: ,x_msg_data OUT nocopy VARCHAR2
2316: ,x_request_id OUT nocopy NUMBER

Line 2321: ,p_multi_org IN VARCHAR2 DEFAULT OKL_API.G_FALSE

2317: ,p_polsrch_rec IN polsrch_rec_type
2318: -- mvasudev, 11.5.10
2319: ,p_stream_type_subclass IN VARCHAR2 DEFAULT NULL
2320: -- end. mvaudev, 11.5.10
2321: ,p_multi_org IN VARCHAR2 DEFAULT OKL_API.G_FALSE
2322: ,p_action_code IN VARCHAR2)
2323: IS
2324: l_api_name VARCHAR2(30) := 'cleanup_pool_contents_ui';
2325: l_api_version NUMBER := 1.0;

Line 2329: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

2325: l_api_version NUMBER := 1.0;
2326: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
2327:
2328: BEGIN
2329: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
2330: p_pkg_name => G_PKG_NAME,
2331: p_init_msg_list => p_init_msg_list,
2332: l_api_version => l_api_version,
2333: p_api_version => p_api_version,

Line 2383: OKL_API.set_message(p_app_name => G_APP_NAME,

2379:
2380: -- Added these validations to check to see if the request has been submitted successfully.
2381: IF x_request_id = 0 THEN
2382:
2383: OKL_API.set_message(p_app_name => G_APP_NAME,
2384: p_msg_name => 'OKL_CONC_REQ_ERROR',
2385: p_token1 => 'PROG_NAME',
2386: p_token1_value => 'OKL CleanUp Pool CONTENTS',
2387: p_token2 => 'REQUEST_ID',

Line 2393: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2389:
2390: RAISE G_EXCEPTION_ERROR;
2391: END IF;
2392:
2393: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2394:
2395: x_return_status := l_return_status;
2396:
2397: EXCEPTION

Line 2400: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2396:
2397: EXCEPTION
2398: WHEN G_EXCEPTION_ERROR THEN
2399:
2400: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2401: p_pkg_name => G_PKG_NAME,
2402: p_exc_name => G_EXC_NAME_ERROR,
2403: x_msg_count => x_msg_count,
2404: x_msg_data => x_msg_data,

Line 2408: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2404: x_msg_data => x_msg_data,
2405: p_api_type => G_API_TYPE);
2406: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2407:
2408: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2409: p_pkg_name => G_PKG_NAME,
2410: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2411: x_msg_count => x_msg_count,
2412: x_msg_data => x_msg_data,

Line 2416: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2412: x_msg_data => x_msg_data,
2413: p_api_type => G_API_TYPE);
2414: WHEN OTHERS THEN
2415:
2416: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2417: p_pkg_name => G_PKG_NAME,
2418: p_exc_name => G_EXC_NAME_OTHERS,
2419: x_msg_count => x_msg_count,
2420: x_msg_data => x_msg_data,