1015: end if;
1016:
1017: EXCEPTION
1018: WHEN FND_API.G_EXC_ERROR THEN
1019: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1020: P_API_NAME => L_API_NAME
1021: ,P_PKG_NAME => G_PKG_NAME
1022: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1023: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1019: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1020: P_API_NAME => L_API_NAME
1021: ,P_PKG_NAME => G_PKG_NAME
1022: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1023: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1024: ,X_MSG_COUNT => X_MSG_COUNT
1025: ,X_MSG_DATA => X_MSG_DATA
1026: ,X_RETURN_STATUS => X_RETURN_STATUS);
1027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1024: ,X_MSG_COUNT => X_MSG_COUNT
1025: ,X_MSG_DATA => X_MSG_DATA
1026: ,X_RETURN_STATUS => X_RETURN_STATUS);
1027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1028: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1029: P_API_NAME => L_API_NAME
1030: ,P_PKG_NAME => G_PKG_NAME
1031: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1032: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1028: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1029: P_API_NAME => L_API_NAME
1030: ,P_PKG_NAME => G_PKG_NAME
1031: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1032: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1033: ,X_MSG_COUNT => X_MSG_COUNT
1034: ,X_MSG_DATA => X_MSG_DATA
1035: ,X_RETURN_STATUS => X_RETURN_STATUS);
1036: WHEN OTHERS THEN
4257: end if;
4258:
4259: EXCEPTION
4260: WHEN FND_API.G_EXC_ERROR THEN
4261: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4262: P_API_NAME => L_API_NAME
4263: ,P_PKG_NAME => G_PKG_NAME
4264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4265: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4261: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4262: P_API_NAME => L_API_NAME
4263: ,P_PKG_NAME => G_PKG_NAME
4264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4265: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4266: ,X_MSG_COUNT => X_MSG_COUNT
4267: ,X_MSG_DATA => X_MSG_DATA
4268: ,X_RETURN_STATUS => X_RETURN_STATUS);
4269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4266: ,X_MSG_COUNT => X_MSG_COUNT
4267: ,X_MSG_DATA => X_MSG_DATA
4268: ,X_RETURN_STATUS => X_RETURN_STATUS);
4269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4270: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4271: P_API_NAME => L_API_NAME
4272: ,P_PKG_NAME => G_PKG_NAME
4273: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4274: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4270: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4271: P_API_NAME => L_API_NAME
4272: ,P_PKG_NAME => G_PKG_NAME
4273: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4274: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4275: ,X_MSG_COUNT => X_MSG_COUNT
4276: ,X_MSG_DATA => X_MSG_DATA
4277: ,X_RETURN_STATUS => X_RETURN_STATUS);
4278:
4699: , p_data => x_msg_data);
4700:
4701: EXCEPTION
4702: WHEN FND_API.G_EXC_ERROR THEN
4703: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4704: P_API_NAME => L_API_NAME
4705: ,P_PKG_NAME => G_PKG_NAME
4706: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4707: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4703: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4704: P_API_NAME => L_API_NAME
4705: ,P_PKG_NAME => G_PKG_NAME
4706: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4707: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4708: ,X_MSG_COUNT => X_MSG_COUNT
4709: ,X_MSG_DATA => X_MSG_DATA
4710: ,X_RETURN_STATUS => X_RETURN_STATUS);
4711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4708: ,X_MSG_COUNT => X_MSG_COUNT
4709: ,X_MSG_DATA => X_MSG_DATA
4710: ,X_RETURN_STATUS => X_RETURN_STATUS);
4711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4712: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4713: P_API_NAME => L_API_NAME
4714: ,P_PKG_NAME => G_PKG_NAME
4715: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4716: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4712: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
4713: P_API_NAME => L_API_NAME
4714: ,P_PKG_NAME => G_PKG_NAME
4715: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4716: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
4717: ,X_MSG_COUNT => X_MSG_COUNT
4718: ,X_MSG_DATA => X_MSG_DATA
4719: ,X_RETURN_STATUS => X_RETURN_STATUS);
4720: