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.CSD_RULES_ENGINE_PVT dependencies on JTF_PLSQL_API

Line 234: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

230: --** debug starts!!
231: --dbms_output.put_line('PROCESS_RULE_MATCHING -> exception 1');
232: --** debug ends!!
233:
234: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
235: P_API_NAME => c_API_NAME
236: ,P_PKG_NAME => G_PKG_NAME
237: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
238: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 238: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

234: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
235: P_API_NAME => c_API_NAME
236: ,P_PKG_NAME => G_PKG_NAME
237: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
238: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
239: ,X_MSG_COUNT => X_MSG_COUNT
240: ,X_MSG_DATA => X_MSG_DATA
241: ,X_RETURN_STATUS => X_RETURN_STATUS);
242:

Line 249: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

245: --** debug starts!!
246: --dbms_output.put_line('PROCESS_RULE_MATCHING -> exception 2');
247: --** debug ends!!
248:
249: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
250: P_API_NAME => c_API_NAME
251: ,P_PKG_NAME => G_PKG_NAME
252: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
253: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 253: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

249: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
250: P_API_NAME => c_API_NAME
251: ,P_PKG_NAME => G_PKG_NAME
252: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
253: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
254: ,X_MSG_COUNT => X_MSG_COUNT
255: ,X_MSG_DATA => X_MSG_DATA
256: ,X_RETURN_STATUS => X_RETURN_STATUS);
257:

Line 264: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

260: --** debug starts!!
261: --dbms_output.put_line('PROCESS_RULE_MATCHING -> exception 3');
262: --** debug ends!!
263:
264: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
265: P_API_NAME => c_API_NAME
266: ,P_PKG_NAME => G_PKG_NAME
267: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
268: ,P_SQLCODE => SQLCODE

Line 267: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

263:
264: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
265: P_API_NAME => c_API_NAME
266: ,P_PKG_NAME => G_PKG_NAME
267: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
268: ,P_SQLCODE => SQLCODE
269: ,P_SQLERRM => SQLERRM
270: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
271: ,X_MSG_COUNT => X_MSG_COUNT

Line 270: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

266: ,P_PKG_NAME => G_PKG_NAME
267: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
268: ,P_SQLCODE => SQLCODE
269: ,P_SQLERRM => SQLERRM
270: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
271: ,X_MSG_COUNT => X_MSG_COUNT
272: ,X_MSG_DATA => X_MSG_DATA
273: ,X_RETURN_STATUS => X_RETURN_STATUS);
274: END PROCESS_RULE_MATCHING;

Line 451: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

447:
448: EXCEPTION
449: WHEN FND_API.G_EXC_ERROR THEN
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
452: P_API_NAME => c_API_NAME
453: ,P_PKG_NAME => G_PKG_NAME
454: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
455: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 455: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

451: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
452: P_API_NAME => c_API_NAME
453: ,P_PKG_NAME => G_PKG_NAME
454: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
455: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
456: ,X_MSG_COUNT => X_MSG_COUNT
457: ,X_MSG_DATA => X_MSG_DATA
458: ,X_RETURN_STATUS => X_RETURN_STATUS);
459:

Line 462: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

458: ,X_RETURN_STATUS => X_RETURN_STATUS);
459:
460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
463: P_API_NAME => c_API_NAME
464: ,P_PKG_NAME => G_PKG_NAME
465: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
466: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 466: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

462: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
463: P_API_NAME => c_API_NAME
464: ,P_PKG_NAME => G_PKG_NAME
465: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
466: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
467: ,X_MSG_COUNT => X_MSG_COUNT
468: ,X_MSG_DATA => X_MSG_DATA
469: ,X_RETURN_STATUS => X_RETURN_STATUS);
470:

Line 473: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

469: ,X_RETURN_STATUS => X_RETURN_STATUS);
470:
471: WHEN OTHERS THEN
472: x_return_status := FND_API.G_RET_STS_ERROR;
473: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
474: P_API_NAME => c_API_NAME
475: ,P_PKG_NAME => G_PKG_NAME
476: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
477: ,P_SQLCODE => SQLCODE

Line 476: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

472: x_return_status := FND_API.G_RET_STS_ERROR;
473: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
474: P_API_NAME => c_API_NAME
475: ,P_PKG_NAME => G_PKG_NAME
476: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
477: ,P_SQLCODE => SQLCODE
478: ,P_SQLERRM => SQLERRM
479: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
480: ,X_MSG_COUNT => X_MSG_COUNT

Line 479: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

475: ,P_PKG_NAME => G_PKG_NAME
476: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
477: ,P_SQLCODE => SQLCODE
478: ,P_SQLERRM => SQLERRM
479: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
480: ,X_MSG_COUNT => X_MSG_COUNT
481: ,X_MSG_DATA => X_MSG_DATA
482: ,X_RETURN_STATUS => X_RETURN_STATUS);
483: END GET_DEFAULT_VALUE_FROM_RULE;

Line 560: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

556: --* logic ends here *--
557: EXCEPTION
558: WHEN FND_API.G_EXC_ERROR THEN
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
561: P_API_NAME => c_API_NAME
562: ,P_PKG_NAME => G_PKG_NAME
563: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
564: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 564: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

560: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
561: P_API_NAME => c_API_NAME
562: ,P_PKG_NAME => G_PKG_NAME
563: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
564: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
565: ,X_MSG_COUNT => X_MSG_COUNT
566: ,X_MSG_DATA => X_MSG_DATA
567: ,X_RETURN_STATUS => X_RETURN_STATUS);
568:

Line 571: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

567: ,X_RETURN_STATUS => X_RETURN_STATUS);
568:
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
572: P_API_NAME => c_API_NAME
573: ,P_PKG_NAME => G_PKG_NAME
574: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
575: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 575: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

571: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
572: P_API_NAME => c_API_NAME
573: ,P_PKG_NAME => G_PKG_NAME
574: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
575: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
576: ,X_MSG_COUNT => X_MSG_COUNT
577: ,X_MSG_DATA => X_MSG_DATA
578: ,X_RETURN_STATUS => X_RETURN_STATUS);
579:

Line 582: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

578: ,X_RETURN_STATUS => X_RETURN_STATUS);
579:
580: WHEN OTHERS THEN
581: x_return_status := FND_API.G_RET_STS_ERROR;
582: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
583: P_API_NAME => c_API_NAME
584: ,P_PKG_NAME => G_PKG_NAME
585: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
586: ,P_SQLCODE => SQLCODE

Line 585: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

581: x_return_status := FND_API.G_RET_STS_ERROR;
582: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
583: P_API_NAME => c_API_NAME
584: ,P_PKG_NAME => G_PKG_NAME
585: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
586: ,P_SQLCODE => SQLCODE
587: ,P_SQLERRM => SQLERRM
588: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
589: ,X_MSG_COUNT => X_MSG_COUNT

Line 588: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

584: ,P_PKG_NAME => G_PKG_NAME
585: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
586: ,P_SQLCODE => SQLCODE
587: ,P_SQLERRM => SQLERRM
588: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
589: ,X_MSG_COUNT => X_MSG_COUNT
590: ,X_MSG_DATA => X_MSG_DATA
591: ,X_RETURN_STATUS => X_RETURN_STATUS);
592: END GET_DEFAULT_VALUE_FROM_RULE;

Line 670: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

666: --* logic ends here *--
667: EXCEPTION
668: WHEN FND_API.G_EXC_ERROR THEN
669: x_return_status := FND_API.G_RET_STS_ERROR;
670: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
671: P_API_NAME => c_API_NAME
672: ,P_PKG_NAME => G_PKG_NAME
673: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
674: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 674: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

670: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
671: P_API_NAME => c_API_NAME
672: ,P_PKG_NAME => G_PKG_NAME
673: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
674: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
675: ,X_MSG_COUNT => X_MSG_COUNT
676: ,X_MSG_DATA => X_MSG_DATA
677: ,X_RETURN_STATUS => X_RETURN_STATUS);
678:

Line 681: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

677: ,X_RETURN_STATUS => X_RETURN_STATUS);
678:
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
682: P_API_NAME => c_API_NAME
683: ,P_PKG_NAME => G_PKG_NAME
684: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
685: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 685: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

681: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
682: P_API_NAME => c_API_NAME
683: ,P_PKG_NAME => G_PKG_NAME
684: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
685: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
686: ,X_MSG_COUNT => X_MSG_COUNT
687: ,X_MSG_DATA => X_MSG_DATA
688: ,X_RETURN_STATUS => X_RETURN_STATUS);
689:

Line 692: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

688: ,X_RETURN_STATUS => X_RETURN_STATUS);
689:
690: WHEN OTHERS THEN
691: x_return_status := FND_API.G_RET_STS_ERROR;
692: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
693: P_API_NAME => c_API_NAME
694: ,P_PKG_NAME => G_PKG_NAME
695: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
696: ,P_SQLCODE => SQLCODE

Line 695: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

691: x_return_status := FND_API.G_RET_STS_ERROR;
692: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
693: P_API_NAME => c_API_NAME
694: ,P_PKG_NAME => G_PKG_NAME
695: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
696: ,P_SQLCODE => SQLCODE
697: ,P_SQLERRM => SQLERRM
698: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
699: ,X_MSG_COUNT => X_MSG_COUNT

Line 698: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

694: ,P_PKG_NAME => G_PKG_NAME
695: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
696: ,P_SQLCODE => SQLCODE
697: ,P_SQLERRM => SQLERRM
698: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
699: ,X_MSG_COUNT => X_MSG_COUNT
700: ,X_MSG_DATA => X_MSG_DATA
701: ,X_RETURN_STATUS => X_RETURN_STATUS);
702: END GET_DEFAULT_VALUE_FROM_RULE;