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_POPULATE_PRCENG_RST_PUB dependencies on FND_LOG

Line 83: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);

79: BEGIN
80: G_TRANSACTION_NUMBER := p_transaction_number;
81:
82: IF(G_DEBUG_ENABLED = 'Y') THEN
83: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);
84: END IF;
85:
86: IF(G_DEBUG_ENABLED = 'Y') THEN
87: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);

Line 87: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);

83: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);
84: END IF;
85:
86: IF(G_DEBUG_ENABLED = 'Y') THEN
87: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);
88: END IF;
89:
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);

Line 91: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);

87: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);
88: END IF;
89:
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,

Line 178: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);

174: EXCEPTION
175: WHEN G_EXCEPTION_ERROR THEN
176:
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,

Line 190: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);

186: p_api_type => G_API_TYPE);
187: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
188:
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,

Line 202: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||SQLERRM(SQLCODE));

198: p_api_type => G_API_TYPE);
199: WHEN OTHERS THEN
200:
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,

Line 247: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);

243:
244: G_TRANSACTION_NUMBER := p_transaction_number;
245:
246: IF(G_DEBUG_ENABLED = 'Y') THEN
247: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);
248: END IF;
249:
250: IF(G_DEBUG_ENABLED = 'Y') THEN
251: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);

Line 251: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);

247: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);
248: END IF;
249:
250: IF(G_DEBUG_ENABLED = 'Y') THEN
251: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);
252: END IF;
253:
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);

Line 255: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);

251: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);
252: END IF;
253:
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,

Line 342: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);

338: EXCEPTION
339: WHEN G_EXCEPTION_ERROR THEN
340:
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,

Line 355: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);

351:
352: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
353:
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,

Line 366: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||SQLERRM(SQLCODE));

362: x_msg_data => x_msg_data,
363: p_api_type => G_API_TYPE);
364: WHEN OTHERS THEN
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,

Line 410: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);

406:
407: G_TRANSACTION_NUMBER := p_transaction_number;
408:
409: IF(G_DEBUG_ENABLED = 'Y') THEN
410: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);
411: END IF;
412:
413: IF(G_DEBUG_ENABLED = 'Y') THEN
414: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);

Line 414: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);

410: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);
411: END IF;
412:
413: IF(G_DEBUG_ENABLED = 'Y') THEN
414: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);
415: END IF;
416:
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);

Line 418: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);

414: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);
415: END IF;
416:
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,

Line 509: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);

505: EXCEPTION
506: WHEN G_EXCEPTION_ERROR THEN
507:
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,

Line 521: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);

517: p_api_type => G_API_TYPE);
518: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
519:
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,

Line 532: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||SQLERRM(SQLCODE));

528: x_msg_data => x_msg_data,
529: p_api_type => G_API_TYPE);
530: WHEN OTHERS THEN
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,

Line 576: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);

572:
573: G_TRANSACTION_NUMBER := p_transaction_number;
574:
575: IF(G_DEBUG_ENABLED = 'Y') THEN
576: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);
577: END IF;
578:
579: IF(G_DEBUG_ENABLED = 'Y') THEN
580: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);

Line 580: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);

576: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);
577: END IF;
578:
579: IF(G_DEBUG_ENABLED = 'Y') THEN
580: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);
581: END IF;
582:
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);

Line 584: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);

580: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);
581: END IF;
582:
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,

Line 675: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);

671: EXCEPTION
672: WHEN G_EXCEPTION_ERROR THEN
673:
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,

Line 686: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);

682: x_msg_data => x_msg_data,
683: p_api_type => G_API_TYPE);
684: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
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,

Line 697: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||x_msg_data);

693: x_msg_data => x_msg_data,
694: p_api_type => G_API_TYPE);
695: WHEN OTHERS THEN
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,

Line 775: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

771: EXCEPTION
772: WHEN G_EXCEPTION_ERROR THEN
773:
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,

Line 787: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

783: p_api_type => G_API_TYPE);
784: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
785:
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,

Line 799: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

795: p_api_type => G_API_TYPE);
796: WHEN OTHERS THEN
797:
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,

Line 873: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

869: EXCEPTION
870: WHEN G_EXCEPTION_ERROR THEN
871:
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,

Line 885: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

881: p_api_type => G_API_TYPE);
882: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
883:
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,

Line 897: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

893: p_api_type => G_API_TYPE);
894: WHEN OTHERS THEN
895:
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,

Line 975: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||lx_msg_data);

971: EXCEPTION
972: WHEN G_EXCEPTION_ERROR THEN
973:
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,

Line 987: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||lx_msg_data);

983: p_api_type => G_API_TYPE);
984: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
985:
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,

Line 999: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||lx_msg_data);

995: p_api_type => G_API_TYPE);
996: WHEN OTHERS THEN
997:
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,

Line 1077: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||lx_msg_count);

1073: EXCEPTION
1074: WHEN G_EXCEPTION_ERROR THEN
1075:
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,

Line 1089: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||lx_msg_count);

1085: p_api_type => G_API_TYPE);
1086: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1087:
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,

Line 1100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||lx_msg_count);

1096: x_msg_data => lx_msg_data,
1097: p_api_type => G_API_TYPE);
1098: WHEN OTHERS THEN
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,

Line 1221: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1217: EXCEPTION
1218: WHEN G_EXCEPTION_ERROR THEN
1219:
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,

Line 1233: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1229: p_api_type => G_API_TYPE);
1230: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1231:
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,

Line 1245: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1241: p_api_type => G_API_TYPE);
1242: WHEN OTHERS THEN
1243:
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,

Line 1382: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1378: EXCEPTION
1379: WHEN G_EXCEPTION_ERROR THEN
1380:
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,

Line 1394: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1390: p_api_type => G_API_TYPE);
1391: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1392:
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,

Line 1406: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1402: p_api_type => G_API_TYPE);
1403: WHEN OTHERS THEN
1404:
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,

Line 1539: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1535: EXCEPTION
1536: WHEN G_EXCEPTION_ERROR THEN
1537:
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,

Line 1551: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1547: p_api_type => G_API_TYPE);
1548: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1549:
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,

Line 1563: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1559: p_api_type => G_API_TYPE);
1560: WHEN OTHERS THEN
1561:
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,

Line 1664: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||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,

Line 1675: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1671: x_msg_data => x_msg_data,
1672: p_api_type => G_API_TYPE);
1673: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
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,

Line 1686: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1682: x_msg_data => x_msg_data,
1683: p_api_type => G_API_TYPE);
1684: WHEN OTHERS THEN
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,

Line 1787: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1783: EXCEPTION
1784: WHEN G_EXCEPTION_ERROR THEN
1785:
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,

Line 1799: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1795: p_api_type => G_API_TYPE);
1796: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1797:
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,

Line 1811: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1807: p_api_type => G_API_TYPE);
1808: WHEN OTHERS THEN
1809:
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,

Line 1917: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1913: EXCEPTION
1914: WHEN G_EXCEPTION_ERROR THEN
1915:
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,

Line 1929: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1925: p_api_type => G_API_TYPE);
1926: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1927:
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,

Line 1941: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

1937: p_api_type => G_API_TYPE);
1938: WHEN OTHERS THEN
1939:
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,

Line 2045: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

2041: EXCEPTION
2042: WHEN G_EXCEPTION_ERROR THEN
2043:
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,

Line 2057: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

2053: p_api_type => G_API_TYPE);
2054: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2055:
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,

Line 2069: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

2065: p_api_type => G_API_TYPE);
2066: WHEN OTHERS THEN
2067:
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,

Line 2191: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||lx_msg_data);

2187: EXCEPTION
2188: WHEN G_EXCEPTION_ERROR THEN
2189:
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,

Line 2203: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||lx_msg_data);

2199: p_api_type => G_API_TYPE);
2200: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2201:
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,

Line 2215: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||lx_msg_data);

2211: p_api_type => G_API_TYPE);
2212: WHEN OTHERS THEN
2213:
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,

Line 2336: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||lx_msg_data);

2332: EXCEPTION
2333: WHEN G_EXCEPTION_ERROR THEN
2334:
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,

Line 2348: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||lx_msg_data);

2344: p_api_type => G_API_TYPE);
2345: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2346:
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,

Line 2360: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,p_transaction_number ||': '||lx_msg_data);

2356: p_api_type => G_API_TYPE);
2357: WHEN OTHERS THEN
2358:
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,

Line 2800: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

2796: EXCEPTION
2797: WHEN G_EXCEPTION_ERROR THEN
2798:
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,

Line 2812: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

2808: p_api_type => G_API_TYPE);
2809: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2810:
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,

Line 2824: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module ,G_TRANSACTION_NUMBER ||': '||x_msg_data);

2820: p_api_type => G_API_TYPE);
2821: WHEN OTHERS THEN
2822:
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,

Line 2915: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);

2911:
2912: G_TRANSACTION_NUMBER := p_transaction_number;
2913:
2914: IF(G_DEBUG_ENABLED = 'Y') THEN
2915: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);
2916: END IF;
2917:
2918: IF(G_DEBUG_ENABLED = 'Y') THEN
2919: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);

Line 2919: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);

2915: G_IS_DEBUG_EXCEPTION_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_EXCEPTION);
2916: END IF;
2917:
2918: IF(G_DEBUG_ENABLED = 'Y') THEN
2919: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);
2920: END IF;
2921:
2922: IF(G_DEBUG_ENABLED = 'Y') THEN
2923: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);

Line 2923: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);

2919: G_IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_PROCEDURE);
2920: END IF;
2921:
2922: IF(G_DEBUG_ENABLED = 'Y') THEN
2923: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);
2924: END IF;
2925:
2926: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
2927: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module,p_transaction_number||': begin okl_populate_prceng_rst_pub.process');

Line 2927: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module,p_transaction_number||': begin okl_populate_prceng_rst_pub.process');

2923: G_IS_DEBUG_ERROR_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_ERROR);
2924: END IF;
2925:
2926: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
2927: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module,p_transaction_number||': begin okl_populate_prceng_rst_pub.process');
2928: END IF;
2929:
2930: -- Do nothing in cancel or timeout mode
2931: l_transaction_number:=p_transaction_number;

Line 2941: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': l_orp_code = '||l_orp_code);

2937: l_khr_id := strm_interfaces_data.khr_id; -- added by smahapat for setting context (bug 3145238)
2938: END LOOP;
2939:
2940: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
2941: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': l_orp_code = '||l_orp_code);
2942: END IF;
2943:
2944: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
2945: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': l_khr_id = '||l_khr_id);

Line 2945: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': l_khr_id = '||l_khr_id);

2941: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': l_orp_code = '||l_orp_code);
2942: END IF;
2943:
2944: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
2945: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': l_khr_id = '||l_khr_id);
2946: END IF;
2947:
2948: -- set context (bug 3145238)
2949: OPEN l_hdr_csr( l_khr_id );

Line 3010: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': l_return_status = '||l_return_status);

3006:
3007: END IF;
3008:
3009: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
3010: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': l_return_status = '||l_return_status);
3011: END IF;
3012:
3013:
3014: -- if error

Line 3038: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_ERROR, l_module, p_transaction_number||': '||l_error_msg);

3034: END IF;
3035: END LOOP;
3036:
3037: IF(G_IS_DEBUG_ERROR_ON) THEN
3038: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_ERROR, l_module, p_transaction_number||': '||l_error_msg);
3039: END IF;
3040:
3041: l_error_message_tbl(1) := 'Errors while processing Streams Results :- ';
3042:

Line 3097: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module,p_transaction_number||': resultout = '||resultout);

3093: resultout := 'T';
3094: END IF;
3095:
3096: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
3097: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module,p_transaction_number||': resultout = '||resultout);
3098: END IF;
3099:
3100: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
3101: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module,p_transaction_number||': end okl_populate_prceng_rst_pub.process');

Line 3101: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module,p_transaction_number||': end okl_populate_prceng_rst_pub.process');

3097: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module,p_transaction_number||': resultout = '||resultout);
3098: END IF;
3099:
3100: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
3101: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module,p_transaction_number||': end okl_populate_prceng_rst_pub.process');
3102: END IF;
3103:
3104: EXCEPTION
3105: WHEN OTHERS THEN

Line 3118: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module, p_transaction_number||': '||SQLERRM(SQLCODE));

3114: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
3115: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
3116: --srsreeni Bug6011651 ends
3117: IF(G_IS_DEBUG_EXCEPTION_ON) THEN
3118: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_EXCEPTION, l_module, p_transaction_number||': '||SQLERRM(SQLCODE));
3119: END IF;
3120:
3121: RAISE;
3122: END process;