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