APPS.OKL_POPULATE_PRCENG_RST_PUB dependencies on OKL_API

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

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,

Line 171: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

Line 181: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 193: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 205: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 335: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

Line 345: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 358: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 369: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 502: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

Line 512: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 524: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 535: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 668: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

Line 678: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 689: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 700: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 768: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

Line 778: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 790: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 802: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 866: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

Line 876: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 888: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 900: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 968: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,

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

Line 978: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 990: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 1002: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 1070: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,

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

Line 1080: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 1092: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 1103: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 1213: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

Line 1224: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 1236: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 1248: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 1375: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

Line 1385: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 1397: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 1409: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 1532: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

Line 1542: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 1554: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 1566: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 1658: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

Line 1667: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 1678: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 1689: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 1780: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

Line 1790: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 1802: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 1814: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 1910: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

Line 1920: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 1932: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 1944: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 2038: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

Line 2048: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 2060: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 2072: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 2183: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,

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

Line 2194: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 2206: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 2218: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

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

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,

Line 2328: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,

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

Line 2339: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 2351: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 2363: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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,

Line 2387: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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);

Line 2451: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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;

Line 2543: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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;

Line 2632: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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

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

2732: x_msg_count NUMBER ;
2733:
2734: l_module VARCHAR2(255) := G_MODULE||'.'||l_api_name||'.'||G_TRANSACTION_NUMBER;
2735: BEGIN
2736: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
2737: p_pkg_name => G_PKG_NAME,
2738: p_init_msg_list => l_init_msg_list,
2739: l_api_version => l_api_version,
2740: p_api_version => l_api_version,

Line 2789: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

2785: -- Assign record returned by private api to local record
2786: l_srlv_rec := x_srlv_rec;
2787:
2788:
2789: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2790: x_msg_data => x_msg_data);
2791: x_return_status := l_return_status;
2792: EXCEPTION
2793: WHEN G_EXCEPTION_ERROR THEN

Line 2799: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2795: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
2796: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
2797: END IF;
2798:
2799: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2800: p_pkg_name => G_PKG_NAME,
2801: p_exc_name => G_EXC_NAME_ERROR,
2802: x_msg_count => x_msg_count,
2803: x_msg_data => x_msg_data,

Line 2811: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2807: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
2808: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
2809: END IF;
2810:
2811: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2812: p_pkg_name => G_PKG_NAME,
2813: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2814: x_msg_count => x_msg_count,
2815: x_msg_data => x_msg_data,

Line 2823: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

2819: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
2820: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);
2821: END IF;
2822:
2823: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2824: p_pkg_name => G_PKG_NAME,
2825: p_exc_name => G_EXC_NAME_OTHERS,
2826: x_msg_count => x_msg_count,
2827: x_msg_data => x_msg_data,

Line 3081: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

3077: x_msg_data => l_msg_data,
3078: p_khr_id => l_khr_id,
3079: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
3080: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
3081: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3082: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3083: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3084: RAISE OKL_API.G_EXCEPTION_ERROR;
3085: END IF;

Line 3082: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3078: p_khr_id => l_khr_id,
3079: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
3080: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
3081: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3082: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3083: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3084: RAISE OKL_API.G_EXCEPTION_ERROR;
3085: END IF;
3086: --srsreeni Bug6011651 ends

Line 3083: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

3079: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
3080: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
3081: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3082: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3083: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3084: RAISE OKL_API.G_EXCEPTION_ERROR;
3085: END IF;
3086: --srsreeni Bug6011651 ends
3087: resultout := 'F';

Line 3084: RAISE OKL_API.G_EXCEPTION_ERROR;

3080: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
3081: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3082: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3083: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3084: RAISE OKL_API.G_EXCEPTION_ERROR;
3085: END IF;
3086: --srsreeni Bug6011651 ends
3087: resultout := 'F';
3088: ELSE