DBA Data[Home] [Help]

APPS.CSD_RULES_ENGINE_PVT dependencies on JTF_PLSQL_API

Line 287: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

283: --** debug starts!!
284: --dbms_output.put_line('PROCESS_RULE_MATCHING -> exception 1');
285: --** debug ends!!
286:
287: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
288: P_API_NAME => c_API_NAME
289: ,P_PKG_NAME => G_PKG_NAME
290: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
291: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 291: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

287: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
288: P_API_NAME => c_API_NAME
289: ,P_PKG_NAME => G_PKG_NAME
290: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
291: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
292: ,X_MSG_COUNT => X_MSG_COUNT
293: ,X_MSG_DATA => X_MSG_DATA
294: ,X_RETURN_STATUS => X_RETURN_STATUS);
295:

Line 302: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

298: --** debug starts!!
299: --dbms_output.put_line('PROCESS_RULE_MATCHING -> exception 2');
300: --** debug ends!!
301:
302: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
303: P_API_NAME => c_API_NAME
304: ,P_PKG_NAME => G_PKG_NAME
305: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
306: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 306: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

302: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
303: P_API_NAME => c_API_NAME
304: ,P_PKG_NAME => G_PKG_NAME
305: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
306: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
307: ,X_MSG_COUNT => X_MSG_COUNT
308: ,X_MSG_DATA => X_MSG_DATA
309: ,X_RETURN_STATUS => X_RETURN_STATUS);
310:

Line 317: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

313: --** debug starts!!
314: --dbms_output.put_line('PROCESS_RULE_MATCHING -> exception 3');
315: --** debug ends!!
316:
317: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
318: P_API_NAME => c_API_NAME
319: ,P_PKG_NAME => G_PKG_NAME
320: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
321: ,P_SQLCODE => SQLCODE

Line 320: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

316:
317: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
318: P_API_NAME => c_API_NAME
319: ,P_PKG_NAME => G_PKG_NAME
320: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
321: ,P_SQLCODE => SQLCODE
322: ,P_SQLERRM => SQLERRM
323: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
324: ,X_MSG_COUNT => X_MSG_COUNT

Line 323: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

319: ,P_PKG_NAME => G_PKG_NAME
320: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
321: ,P_SQLCODE => SQLCODE
322: ,P_SQLERRM => SQLERRM
323: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
324: ,X_MSG_COUNT => X_MSG_COUNT
325: ,X_MSG_DATA => X_MSG_DATA
326: ,X_RETURN_STATUS => X_RETURN_STATUS);
327: END PROCESS_RULE_MATCHING;

Line 745: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

741:
742: EXCEPTION
743: WHEN FND_API.G_EXC_ERROR THEN
744: x_return_status := FND_API.G_RET_STS_ERROR;
745: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
746: P_API_NAME => c_API_NAME
747: ,P_PKG_NAME => G_PKG_NAME
748: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
749: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 749: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

745: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
746: P_API_NAME => c_API_NAME
747: ,P_PKG_NAME => G_PKG_NAME
748: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
749: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
750: ,X_MSG_COUNT => X_MSG_COUNT
751: ,X_MSG_DATA => X_MSG_DATA
752: ,X_RETURN_STATUS => X_RETURN_STATUS);
753:

Line 756: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

752: ,X_RETURN_STATUS => X_RETURN_STATUS);
753:
754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
755: x_return_status := FND_API.G_RET_STS_ERROR;
756: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
757: P_API_NAME => c_API_NAME
758: ,P_PKG_NAME => G_PKG_NAME
759: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
760: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 760: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

756: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
757: P_API_NAME => c_API_NAME
758: ,P_PKG_NAME => G_PKG_NAME
759: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
760: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
761: ,X_MSG_COUNT => X_MSG_COUNT
762: ,X_MSG_DATA => X_MSG_DATA
763: ,X_RETURN_STATUS => X_RETURN_STATUS);
764:

Line 767: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

763: ,X_RETURN_STATUS => X_RETURN_STATUS);
764:
765: WHEN OTHERS THEN
766: x_return_status := FND_API.G_RET_STS_ERROR;
767: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
768: P_API_NAME => c_API_NAME
769: ,P_PKG_NAME => G_PKG_NAME
770: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
771: ,P_SQLCODE => SQLCODE

Line 770: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

766: x_return_status := FND_API.G_RET_STS_ERROR;
767: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
768: P_API_NAME => c_API_NAME
769: ,P_PKG_NAME => G_PKG_NAME
770: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
771: ,P_SQLCODE => SQLCODE
772: ,P_SQLERRM => SQLERRM
773: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
774: ,X_MSG_COUNT => X_MSG_COUNT

Line 773: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

769: ,P_PKG_NAME => G_PKG_NAME
770: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
771: ,P_SQLCODE => SQLCODE
772: ,P_SQLERRM => SQLERRM
773: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
774: ,X_MSG_COUNT => X_MSG_COUNT
775: ,X_MSG_DATA => X_MSG_DATA
776: ,X_RETURN_STATUS => X_RETURN_STATUS);
777: END GET_DEFAULT_VALUE_FROM_RULE;

Line 854: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

850: --* logic ends here *--
851: EXCEPTION
852: WHEN FND_API.G_EXC_ERROR THEN
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
855: P_API_NAME => c_API_NAME
856: ,P_PKG_NAME => G_PKG_NAME
857: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
858: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 858: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

854: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
855: P_API_NAME => c_API_NAME
856: ,P_PKG_NAME => G_PKG_NAME
857: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
858: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
859: ,X_MSG_COUNT => X_MSG_COUNT
860: ,X_MSG_DATA => X_MSG_DATA
861: ,X_RETURN_STATUS => X_RETURN_STATUS);
862:

Line 865: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

861: ,X_RETURN_STATUS => X_RETURN_STATUS);
862:
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: x_return_status := FND_API.G_RET_STS_ERROR;
865: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
866: P_API_NAME => c_API_NAME
867: ,P_PKG_NAME => G_PKG_NAME
868: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
869: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 869: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

865: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
866: P_API_NAME => c_API_NAME
867: ,P_PKG_NAME => G_PKG_NAME
868: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
869: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
870: ,X_MSG_COUNT => X_MSG_COUNT
871: ,X_MSG_DATA => X_MSG_DATA
872: ,X_RETURN_STATUS => X_RETURN_STATUS);
873:

Line 876: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

872: ,X_RETURN_STATUS => X_RETURN_STATUS);
873:
874: WHEN OTHERS THEN
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
877: P_API_NAME => c_API_NAME
878: ,P_PKG_NAME => G_PKG_NAME
879: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
880: ,P_SQLCODE => SQLCODE

Line 879: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

875: x_return_status := FND_API.G_RET_STS_ERROR;
876: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
877: P_API_NAME => c_API_NAME
878: ,P_PKG_NAME => G_PKG_NAME
879: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
880: ,P_SQLCODE => SQLCODE
881: ,P_SQLERRM => SQLERRM
882: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
883: ,X_MSG_COUNT => X_MSG_COUNT

Line 882: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

878: ,P_PKG_NAME => G_PKG_NAME
879: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
880: ,P_SQLCODE => SQLCODE
881: ,P_SQLERRM => SQLERRM
882: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
883: ,X_MSG_COUNT => X_MSG_COUNT
884: ,X_MSG_DATA => X_MSG_DATA
885: ,X_RETURN_STATUS => X_RETURN_STATUS);
886: END GET_DEFAULT_VALUE_FROM_RULE;

Line 964: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

960: --* logic ends here *--
961: EXCEPTION
962: WHEN FND_API.G_EXC_ERROR THEN
963: x_return_status := FND_API.G_RET_STS_ERROR;
964: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
965: P_API_NAME => c_API_NAME
966: ,P_PKG_NAME => G_PKG_NAME
967: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
968: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 968: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

964: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
965: P_API_NAME => c_API_NAME
966: ,P_PKG_NAME => G_PKG_NAME
967: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
968: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
969: ,X_MSG_COUNT => X_MSG_COUNT
970: ,X_MSG_DATA => X_MSG_DATA
971: ,X_RETURN_STATUS => X_RETURN_STATUS);
972:

Line 975: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

971: ,X_RETURN_STATUS => X_RETURN_STATUS);
972:
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
974: x_return_status := FND_API.G_RET_STS_ERROR;
975: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
976: P_API_NAME => c_API_NAME
977: ,P_PKG_NAME => G_PKG_NAME
978: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
979: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 979: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

975: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
976: P_API_NAME => c_API_NAME
977: ,P_PKG_NAME => G_PKG_NAME
978: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
979: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
980: ,X_MSG_COUNT => X_MSG_COUNT
981: ,X_MSG_DATA => X_MSG_DATA
982: ,X_RETURN_STATUS => X_RETURN_STATUS);
983:

Line 986: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

982: ,X_RETURN_STATUS => X_RETURN_STATUS);
983:
984: WHEN OTHERS THEN
985: x_return_status := FND_API.G_RET_STS_ERROR;
986: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
987: P_API_NAME => c_API_NAME
988: ,P_PKG_NAME => G_PKG_NAME
989: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
990: ,P_SQLCODE => SQLCODE

Line 989: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

985: x_return_status := FND_API.G_RET_STS_ERROR;
986: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
987: P_API_NAME => c_API_NAME
988: ,P_PKG_NAME => G_PKG_NAME
989: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
990: ,P_SQLCODE => SQLCODE
991: ,P_SQLERRM => SQLERRM
992: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
993: ,X_MSG_COUNT => X_MSG_COUNT

Line 992: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

988: ,P_PKG_NAME => G_PKG_NAME
989: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
990: ,P_SQLCODE => SQLCODE
991: ,P_SQLERRM => SQLERRM
992: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
993: ,X_MSG_COUNT => X_MSG_COUNT
994: ,X_MSG_DATA => X_MSG_DATA
995: ,X_RETURN_STATUS => X_RETURN_STATUS);
996: END GET_DEFAULT_VALUE_FROM_RULE;