90: IF(G_DEBUG_ENABLED = 'Y') THEN
91: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);
92: END IF;
93:
94: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
95: p_pkg_name => G_PKG_NAME,
96: p_init_msg_list => p_init_msg_list,
97: l_api_version => l_api_version,
98: p_api_version => p_api_version,
167: l_sirv_rec := x_sirv_rec;
168:
169:
170:
171: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
172: x_msg_data => x_msg_data);
173: x_return_status := l_return_status;
174: EXCEPTION
175: WHEN G_EXCEPTION_ERROR THEN
177: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
178: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);
179: END IF;
180:
181: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
182: p_pkg_name => G_PKG_NAME,
183: p_exc_name => G_EXC_NAME_ERROR,
184: x_msg_count => x_msg_count,
185: x_msg_data => x_msg_data,
189: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
190: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);
191: END IF;
192:
193: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
194: p_pkg_name => G_PKG_NAME,
195: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
196: x_msg_count => x_msg_count,
197: x_msg_data => x_msg_data,
201: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
202: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||SQLERRM(SQLCODE));
203: END IF;
204:
205: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
206: p_pkg_name => G_PKG_NAME,
207: p_exc_name => G_EXC_NAME_OTHERS,
208: x_msg_count => x_msg_count,
209: x_msg_data => x_msg_data,
254: IF(G_DEBUG_ENABLED = 'Y') THEN
255: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);
256: END IF;
257:
258: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
259: p_pkg_name => G_PKG_NAME,
260: p_init_msg_list => l_init_msg_list,
261: l_api_version => l_api_version,
262: p_api_version => l_api_version,
331: l_sirv_rec := x_sirv_rec;
332:
333:
334:
335: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
336: x_msg_data => x_msg_data);
337: x_return_status := l_return_status;
338: EXCEPTION
339: WHEN G_EXCEPTION_ERROR THEN
341: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
342: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);
343: END IF;
344:
345: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
346: p_pkg_name => G_PKG_NAME,
347: p_exc_name => G_EXC_NAME_ERROR,
348: x_msg_count => x_msg_count,
349: x_msg_data => x_msg_data,
354: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
355: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);
356: END IF;
357:
358: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
359: p_pkg_name => G_PKG_NAME,
360: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
361: x_msg_count => x_msg_count,
362: x_msg_data => x_msg_data,
365: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
366: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||SQLERRM(SQLCODE));
367: END IF;
368:
369: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
370: p_pkg_name => G_PKG_NAME,
371: p_exc_name => G_EXC_NAME_OTHERS,
372: x_msg_count => x_msg_count,
373: x_msg_data => x_msg_data,
417: IF(G_DEBUG_ENABLED = 'Y') THEN
418: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);
419: END IF;
420:
421: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
422: p_pkg_name => G_PKG_NAME,
423: p_init_msg_list => p_init_msg_list,
424: l_api_version => l_api_version,
425: p_api_version => p_api_version,
498: l_sirv_rec := x_sirv_rec;
499:
500:
501:
502: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
503: x_msg_data => x_msg_data);
504: x_return_status := l_return_status;
505: EXCEPTION
506: WHEN G_EXCEPTION_ERROR THEN
508: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
509: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);
510: END IF;
511:
512: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
513: p_pkg_name => G_PKG_NAME,
514: p_exc_name => G_EXC_NAME_ERROR,
515: x_msg_count => x_msg_count,
516: x_msg_data => x_msg_data,
520: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
521: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);
522: END IF;
523:
524: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
525: p_pkg_name => G_PKG_NAME,
526: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
527: x_msg_count => x_msg_count,
528: x_msg_data => x_msg_data,
531: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
532: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||SQLERRM(SQLCODE));
533: END IF;
534:
535: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
536: p_pkg_name => G_PKG_NAME,
537: p_exc_name => G_EXC_NAME_OTHERS,
538: x_msg_count => x_msg_count,
539: x_msg_data => x_msg_data,
583: IF(G_DEBUG_ENABLED = 'Y') THEN
584: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);
585: END IF;
586:
587: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
588: p_pkg_name => G_PKG_NAME,
589: p_init_msg_list => l_init_msg_list,
590: l_api_version => l_api_version,
591: p_api_version => l_api_version,
664: l_sirv_rec := x_sirv_rec;
665:
666:
667:
668: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
669: x_msg_data => x_msg_data);
670: x_return_status := l_return_status;
671: EXCEPTION
672: WHEN G_EXCEPTION_ERROR THEN
674: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
675: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);
676: END IF;
677:
678: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
679: p_pkg_name => G_PKG_NAME,
680: p_exc_name => G_EXC_NAME_ERROR,
681: x_msg_count => x_msg_count,
682: x_msg_data => x_msg_data,
685: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
686: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);
687: END IF;
688:
689: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
690: p_pkg_name => G_PKG_NAME,
691: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
692: x_msg_count => x_msg_count,
693: x_msg_data => x_msg_data,
696: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
697: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);
698: END IF;
699:
700: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
701: p_pkg_name => G_PKG_NAME,
702: p_exc_name => G_EXC_NAME_OTHERS,
703: x_msg_count => x_msg_count,
704: x_msg_data => x_msg_data,
727:
728: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
729: BEGIN
730:
731: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
732: p_pkg_name => G_PKG_NAME,
733: p_init_msg_list => p_init_msg_list,
734: l_api_version => l_api_version,
735: p_api_version => p_api_version,
764: -- Assign record returned by private api to local record
765: l_sirv_rec := x_sirv_rec;
766:
767:
768: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
769: x_msg_data => x_msg_data);
770: x_return_status := l_return_status;
771: EXCEPTION
772: WHEN G_EXCEPTION_ERROR THEN
774: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
775: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
776: END IF;
777:
778: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
779: p_pkg_name => G_PKG_NAME,
780: p_exc_name => G_EXC_NAME_ERROR,
781: x_msg_count => x_msg_count,
782: x_msg_data => x_msg_data,
786: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
787: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
788: END IF;
789:
790: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
791: p_pkg_name => G_PKG_NAME,
792: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
793: x_msg_count => x_msg_count,
794: x_msg_data => x_msg_data,
798: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
799: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
800: END IF;
801:
802: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
803: p_pkg_name => G_PKG_NAME,
804: p_exc_name => G_EXC_NAME_OTHERS,
805: x_msg_count => x_msg_count,
806: x_msg_data => x_msg_data,
825:
826: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
827: BEGIN
828:
829: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
830: p_pkg_name => G_PKG_NAME,
831: p_init_msg_list => l_init_msg_list,
832: l_api_version => l_api_version,
833: p_api_version => l_api_version,
862: -- Assign record returned by private api to local record
863: l_sirv_rec := x_sirv_rec;
864:
865:
866: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
867: x_msg_data => x_msg_data);
868: x_return_status := l_return_status;
869: EXCEPTION
870: WHEN G_EXCEPTION_ERROR THEN
872: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
873: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
874: END IF;
875:
876: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
877: p_pkg_name => G_PKG_NAME,
878: p_exc_name => G_EXC_NAME_ERROR,
879: x_msg_count => x_msg_count,
880: x_msg_data => x_msg_data,
884: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
885: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
886: END IF;
887:
888: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
889: p_pkg_name => G_PKG_NAME,
890: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
891: x_msg_count => x_msg_count,
892: x_msg_data => x_msg_data,
896: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
897: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
898: END IF;
899:
900: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
901: p_pkg_name => G_PKG_NAME,
902: p_exc_name => G_EXC_NAME_OTHERS,
903: x_msg_count => x_msg_count,
904: x_msg_data => x_msg_data,
926:
927: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
928: BEGIN
929:
930: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
931: p_pkg_name => G_PKG_NAME,
932: p_init_msg_list => p_init_msg_list,
933: l_api_version => l_api_version,
934: p_api_version => p_api_version,
964: -- Assign record returned by private api to local record
965: l_sirv_rec := lx_sirv_rec;
966:
967:
968: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,
969: x_msg_data => lx_msg_data);
970: x_return_status := l_return_status;
971: EXCEPTION
972: WHEN G_EXCEPTION_ERROR THEN
974: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
975: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||lx_msg_data);
976: END IF;
977:
978: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
979: p_pkg_name => G_PKG_NAME,
980: p_exc_name => G_EXC_NAME_ERROR,
981: x_msg_count => lx_msg_count,
982: x_msg_data => lx_msg_data,
986: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
987: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||lx_msg_data);
988: END IF;
989:
990: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
991: p_pkg_name => G_PKG_NAME,
992: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
993: x_msg_count => lx_msg_count,
994: x_msg_data => lx_msg_data,
998: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
999: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||lx_msg_data);
1000: END IF;
1001:
1002: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1003: p_pkg_name => G_PKG_NAME,
1004: p_exc_name => G_EXC_NAME_OTHERS,
1005: x_msg_count => lx_msg_count,
1006: x_msg_data => lx_msg_data,
1028:
1029: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
1030: BEGIN
1031:
1032: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1033: p_pkg_name => G_PKG_NAME,
1034: p_init_msg_list => l_init_msg_list,
1035: l_api_version => l_api_version,
1036: p_api_version => l_api_version,
1066: -- Assign record returned by private api to local record
1067: l_sirv_rec := lx_sirv_rec;
1068:
1069:
1070: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,
1071: x_msg_data => lx_msg_data);
1072: x_return_status := l_return_status;
1073: EXCEPTION
1074: WHEN G_EXCEPTION_ERROR THEN
1076: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1077: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||lx_msg_count);
1078: END IF;
1079:
1080: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1081: p_pkg_name => G_PKG_NAME,
1082: p_exc_name => G_EXC_NAME_ERROR,
1083: x_msg_count => lx_msg_count,
1084: x_msg_data => lx_msg_data,
1088: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1089: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||lx_msg_count);
1090: END IF;
1091:
1092: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1093: p_pkg_name => G_PKG_NAME,
1094: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1095: x_msg_count => lx_msg_count,
1096: x_msg_data => lx_msg_data,
1099: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||lx_msg_count);
1101: END IF;
1102:
1103: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1104: p_pkg_name => G_PKG_NAME,
1105: p_exc_name => G_EXC_NAME_OTHERS,
1106: x_msg_count => lx_msg_count,
1107: x_msg_data => lx_msg_data,
1144:
1145: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
1146: BEGIN
1147:
1148: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1149: p_pkg_name => G_PKG_NAME,
1150: p_init_msg_list => p_init_msg_list,
1151: l_api_version => l_api_version,
1152: p_api_version => p_api_version,
1209: END IF;
1210:
1211: okl_srs_pvt.insert_row_upg(p_srsv_tbl => l_srsv_tbl);
1212:
1213: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1214: x_msg_data => x_msg_data);
1215: x_return_status := l_return_status;
1216:
1217: EXCEPTION
1220: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1221: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1222: END IF;
1223:
1224: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1225: p_pkg_name => G_PKG_NAME,
1226: p_exc_name => G_EXC_NAME_ERROR,
1227: x_msg_count => x_msg_count,
1228: x_msg_data => x_msg_data,
1232: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1233: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1234: END IF;
1235:
1236: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1237: p_pkg_name => G_PKG_NAME,
1238: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1239: x_msg_count => x_msg_count,
1240: x_msg_data => x_msg_data,
1244: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1245: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1246: END IF;
1247:
1248: x_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_OTHERS,
1251: x_msg_count => x_msg_count,
1252: x_msg_data => x_msg_data,
1286:
1287: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
1288: BEGIN
1289: --dbms_output.put_line('populate_sif_ret_strms start pub');
1290: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1291: p_pkg_name => G_PKG_NAME,
1292: p_init_msg_list => p_init_msg_list,
1293: l_api_version => l_api_version,
1294: p_api_version => p_api_version,
1371: -- Assign record returned by private api to local record
1372: l_srsv_rec := x_srsv_rec;
1373:
1374:
1375: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1376: x_msg_data => x_msg_data);
1377: x_return_status := l_return_status;
1378: EXCEPTION
1379: WHEN G_EXCEPTION_ERROR THEN
1381: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1382: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1383: END IF;
1384:
1385: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1386: p_pkg_name => G_PKG_NAME,
1387: p_exc_name => G_EXC_NAME_ERROR,
1388: x_msg_count => x_msg_count,
1389: x_msg_data => x_msg_data,
1393: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1394: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1395: END IF;
1396:
1397: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1398: p_pkg_name => G_PKG_NAME,
1399: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1400: x_msg_count => x_msg_count,
1401: x_msg_data => x_msg_data,
1405: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1406: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1407: END IF;
1408:
1409: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1410: p_pkg_name => G_PKG_NAME,
1411: p_exc_name => G_EXC_NAME_OTHERS,
1412: x_msg_count => x_msg_count,
1413: x_msg_data => x_msg_data,
1443:
1444: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
1445: BEGIN
1446: --dbms_output.put_line('populate_sif_ret_strms start pub');
1447: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1448: p_pkg_name => G_PKG_NAME,
1449: p_init_msg_list => p_init_msg_list,
1450: l_api_version => l_api_version,
1451: p_api_version => p_api_version,
1528: -- Assign record returned by private api to local record
1529: l_srsv_rec := x_srsv_rec;
1530:
1531:
1532: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1533: x_msg_data => x_msg_data);
1534: x_return_status := l_return_status;
1535: EXCEPTION
1536: WHEN G_EXCEPTION_ERROR THEN
1538: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1539: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1540: END IF;
1541:
1542: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1543: p_pkg_name => G_PKG_NAME,
1544: p_exc_name => G_EXC_NAME_ERROR,
1545: x_msg_count => x_msg_count,
1546: x_msg_data => x_msg_data,
1550: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1551: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1552: END IF;
1553:
1554: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1555: p_pkg_name => G_PKG_NAME,
1556: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1557: x_msg_count => x_msg_count,
1558: x_msg_data => x_msg_data,
1562: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1563: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1564: END IF;
1565:
1566: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1567: p_pkg_name => G_PKG_NAME,
1568: p_exc_name => G_EXC_NAME_OTHERS,
1569: x_msg_count => x_msg_count,
1570: x_msg_data => x_msg_data,
1599: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
1600:
1601: BEGIN
1602: --DBMS_OUTPUT.PUT_LINE('INSIDE PUB Procedure ');
1603: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1604: p_pkg_name => G_PKG_NAME,
1605: p_init_msg_list => p_init_msg_list,
1606: l_api_version => l_api_version,
1607: p_api_version => p_api_version,
1654: -- Assign record returned by private api to local record
1655: l_srsv_rec := x_srsv_rec;
1656:
1657:
1658: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1659: x_msg_data => x_msg_data);
1660: x_return_status := l_return_status;
1661: EXCEPTION
1662: WHEN G_EXCEPTION_ERROR THEN
1663: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1664: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1665: END IF;
1666:
1667: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1668: p_pkg_name => G_PKG_NAME,
1669: p_exc_name => G_EXC_NAME_ERROR,
1670: x_msg_count => x_msg_count,
1671: x_msg_data => x_msg_data,
1674: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1675: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1676: END IF;
1677:
1678: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1679: p_pkg_name => G_PKG_NAME,
1680: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1681: x_msg_count => x_msg_count,
1682: x_msg_data => x_msg_data,
1685: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1686: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1687: END IF;
1688:
1689: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1690: p_pkg_name => G_PKG_NAME,
1691: p_exc_name => G_EXC_NAME_OTHERS,
1692: x_msg_count => x_msg_count,
1693: x_msg_data => x_msg_data,
1729:
1730: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
1731:
1732: BEGIN
1733: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1734: p_pkg_name => G_PKG_NAME,
1735: p_init_msg_list => l_init_msg_list,
1736: l_api_version => l_api_version,
1737: p_api_version => l_api_version,
1776: END LOOP;
1777: END IF;
1778:
1779:
1780: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1781: x_msg_data => x_msg_data);
1782: x_return_status := l_return_status;
1783: EXCEPTION
1784: WHEN G_EXCEPTION_ERROR THEN
1786: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1787: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1788: END IF;
1789:
1790: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1791: p_pkg_name => G_PKG_NAME,
1792: p_exc_name => G_EXC_NAME_ERROR,
1793: x_msg_count => x_msg_count,
1794: x_msg_data => x_msg_data,
1798: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1799: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1800: END IF;
1801:
1802: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1803: p_pkg_name => G_PKG_NAME,
1804: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1805: x_msg_count => x_msg_count,
1806: x_msg_data => x_msg_data,
1810: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1811: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1812: END IF;
1813:
1814: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1815: p_pkg_name => G_PKG_NAME,
1816: p_exc_name => G_EXC_NAME_OTHERS,
1817: x_msg_count => x_msg_count,
1818: x_msg_data => x_msg_data,
1847:
1848: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
1849:
1850: BEGIN
1851: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1852: p_pkg_name => G_PKG_NAME,
1853: p_init_msg_list => p_init_msg_list,
1854: l_api_version => l_api_version,
1855: p_api_version => p_api_version,
1906: -- Assign record returned by private api to local record
1907: l_srmv_rec := x_srmv_rec;
1908:
1909:
1910: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1911: x_msg_data => x_msg_data);
1912: x_return_status := l_return_status;
1913: EXCEPTION
1914: WHEN G_EXCEPTION_ERROR THEN
1916: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1917: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1918: END IF;
1919:
1920: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1921: p_pkg_name => G_PKG_NAME,
1922: p_exc_name => G_EXC_NAME_ERROR,
1923: x_msg_count => x_msg_count,
1924: x_msg_data => x_msg_data,
1928: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1929: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1930: END IF;
1931:
1932: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1933: p_pkg_name => G_PKG_NAME,
1934: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1935: x_msg_count => x_msg_count,
1936: x_msg_data => x_msg_data,
1940: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
1941: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
1942: END IF;
1943:
1944: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1945: p_pkg_name => G_PKG_NAME,
1946: p_exc_name => G_EXC_NAME_OTHERS,
1947: x_msg_count => x_msg_count,
1948: x_msg_data => x_msg_data,
1976:
1977: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
1978:
1979: BEGIN
1980: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1981: p_pkg_name => G_PKG_NAME,
1982: p_init_msg_list => l_init_msg_list,
1983: l_api_version => l_api_version,
1984: p_api_version => l_api_version,
2034: -- Assign record returned by private api to local record
2035: l_srmv_rec := x_srmv_rec;
2036:
2037:
2038: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2039: x_msg_data => x_msg_data);
2040: x_return_status := l_return_status;
2041: EXCEPTION
2042: WHEN G_EXCEPTION_ERROR THEN
2044: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
2045: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
2046: END IF;
2047:
2048: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2049: p_pkg_name => G_PKG_NAME,
2050: p_exc_name => G_EXC_NAME_ERROR,
2051: x_msg_count => x_msg_count,
2052: x_msg_data => x_msg_data,
2056: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
2057: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
2058: END IF;
2059:
2060: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2061: p_pkg_name => G_PKG_NAME,
2062: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2063: x_msg_count => x_msg_count,
2064: x_msg_data => x_msg_data,
2068: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
2069: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
2070: END IF;
2071:
2072: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2073: p_pkg_name => G_PKG_NAME,
2074: p_exc_name => G_EXC_NAME_OTHERS,
2075: x_msg_count => x_msg_count,
2076: x_msg_data => x_msg_data,
2117: WHERE id = khr_id;
2118:
2119: BEGIN
2120:
2121: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
2122: p_pkg_name => G_PKG_NAME,
2123: p_init_msg_list => p_init_msg_list,
2124: l_api_version => l_api_version,
2125: p_api_version => p_api_version,
2179: RAISE G_EXCEPTION_ERROR;
2180: END IF;
2181:
2182:
2183: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,
2184: x_msg_data => lx_msg_data);
2185:
2186: x_return_status := l_return_status;
2187: EXCEPTION
2190: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
2191: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||lx_msg_data);
2192: END IF;
2193:
2194: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2195: p_pkg_name => G_PKG_NAME,
2196: p_exc_name => G_EXC_NAME_ERROR,
2197: x_msg_count => lx_msg_count,
2198: x_msg_data => lx_msg_data,
2202: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
2203: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||lx_msg_data);
2204: END IF;
2205:
2206: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2207: p_pkg_name => G_PKG_NAME,
2208: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2209: x_msg_count => lx_msg_count,
2210: x_msg_data => lx_msg_data,
2214: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
2215: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||lx_msg_data);
2216: END IF;
2217:
2218: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2219: p_pkg_name => G_PKG_NAME,
2220: p_exc_name => G_EXC_NAME_OTHERS,
2221: x_msg_count => lx_msg_count,
2222: x_msg_data => lx_msg_data,
2262:
2263:
2264: BEGIN
2265:
2266: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
2267: p_pkg_name => G_PKG_NAME,
2268: p_init_msg_list => l_init_msg_list,
2269: l_api_version => l_api_version,
2270: p_api_version => l_api_version,
2324: RAISE G_EXCEPTION_ERROR;
2325: END IF;
2326:
2327:
2328: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,
2329: x_msg_data => lx_msg_data);
2330:
2331: x_return_status := l_return_status;
2332: EXCEPTION
2335: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
2336: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||lx_msg_data);
2337: END IF;
2338:
2339: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2340: p_pkg_name => G_PKG_NAME,
2341: p_exc_name => G_EXC_NAME_ERROR,
2342: x_msg_count => lx_msg_count,
2343: x_msg_data => lx_msg_data,
2347: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
2348: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||lx_msg_data);
2349: END IF;
2350:
2351: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2352: p_pkg_name => G_PKG_NAME,
2353: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2354: x_msg_count => lx_msg_count,
2355: x_msg_data => lx_msg_data,
2359: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
2360: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||lx_msg_data);
2361: END IF;
2362:
2363: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2364: p_pkg_name => G_PKG_NAME,
2365: p_exc_name => G_EXC_NAME_OTHERS,
2366: x_msg_count => lx_msg_count,
2367: x_msg_data => lx_msg_data,
2383: ID,ORP_CODE
2384: FROM Okl_Stream_Interfaces
2385: WHERE okl_stream_interfaces.transaction_number = trx_number;
2386:
2387: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2388: lp_sifv_rec sifv_rec_type;
2389: lx_sifv_rec sifv_rec_type;
2390: lx_msg_count NUMBER;
2391: lx_msg_data VARCHAR2(100);
2447: ID
2448: FROM Okl_Sif_Rets
2449: WHERE okl_sif_rets.transaction_number = trx_number;
2450:
2451: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2452: lp_sifv_rec sifv_rec_type;
2453: lx_sifv_rec sifv_rec_type;
2454: lp_sirv_rec sirv_rec_type;
2455: lx_sirv_rec sirv_rec_type;
2539: ID
2540: FROM Okl_Sif_Rets
2541: WHERE okl_sif_rets.transaction_number = trx_number;
2542:
2543: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2544: lp_sifv_rec sifv_rec_type;
2545: lx_sifv_rec sifv_rec_type;
2546: lp_sirv_rec sirv_rec_type;
2547: lx_sirv_rec sirv_rec_type;
2628: ) IS
2629:
2630: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';
2631: l_api_version CONSTANT NUMBER := 1;
2632: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2633:
2634: CURSOR sif_data_csr (trx_number IN NUMBER) IS
2635: SELECT
2636: SIS_CODE
2734: x_msg_count NUMBER ;
2735:
2736: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
2737: BEGIN
2738: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
2739: p_pkg_name => G_PKG_NAME,
2740: p_init_msg_list => l_init_msg_list,
2741: l_api_version => l_api_version,
2742: p_api_version => l_api_version,
2789: -- Assign record returned by private api to local record
2790: l_srlv_rec := x_srlv_rec;
2791:
2792:
2793: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2794: x_msg_data => x_msg_data);
2795: x_return_status := l_return_status;
2796: EXCEPTION
2797: WHEN G_EXCEPTION_ERROR THEN
2799: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
2800: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
2801: END IF;
2802:
2803: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2804: p_pkg_name => G_PKG_NAME,
2805: p_exc_name => G_EXC_NAME_ERROR,
2806: x_msg_count => x_msg_count,
2807: x_msg_data => x_msg_data,
2811: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
2812: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
2813: END IF;
2814:
2815: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2816: p_pkg_name => G_PKG_NAME,
2817: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2818: x_msg_count => x_msg_count,
2819: x_msg_data => x_msg_data,
2823: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
2824: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
2825: END IF;
2826:
2827: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2828: p_pkg_name => G_PKG_NAME,
2829: p_exc_name => G_EXC_NAME_OTHERS,
2830: x_msg_count => x_msg_count,
2831: x_msg_data => x_msg_data,
3081: x_msg_data => l_msg_data,
3082: p_khr_id => l_khr_id,
3083: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
3084: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
3085: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3086: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3087: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3088: RAISE OKL_API.G_EXCEPTION_ERROR;
3089: END IF;
3082: p_khr_id => l_khr_id,
3083: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
3084: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
3085: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3086: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3087: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3088: RAISE OKL_API.G_EXCEPTION_ERROR;
3089: END IF;
3090: --srsreeni Bug6011651 ends
3083: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
3084: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
3085: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3086: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3087: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3088: RAISE OKL_API.G_EXCEPTION_ERROR;
3089: END IF;
3090: --srsreeni Bug6011651 ends
3091: resultout := 'F';
3084: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
3085: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3086: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3087: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3088: RAISE OKL_API.G_EXCEPTION_ERROR;
3089: END IF;
3090: --srsreeni Bug6011651 ends
3091: resultout := 'F';
3092: ELSE