71: END IF;
72:
73:
74: -- Debug Message
75: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
76:
77:
78: -- Initialize API return status to SUCCESS
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
141: END IF;
142:
143:
144: -- Debug Message
145: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
146:
147: -- Standard call to get message count and if count is 1, get message info.
148: FND_MSG_PUB.Count_And_Get
149: ( p_count => x_msg_count,
151: );
152:
153: EXCEPTION
154: WHEN FND_API.G_EXC_ERROR THEN
155: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
156: P_API_NAME => L_API_NAME
157: ,P_PKG_NAME => G_PKG_NAME
158: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
159: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
155: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
156: P_API_NAME => L_API_NAME
157: ,P_PKG_NAME => G_PKG_NAME
158: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
159: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
160: ,X_MSG_COUNT => X_MSG_COUNT
161: ,X_MSG_DATA => X_MSG_DATA
162: ,X_RETURN_STATUS => X_RETURN_STATUS);
163:
161: ,X_MSG_DATA => X_MSG_DATA
162: ,X_RETURN_STATUS => X_RETURN_STATUS);
163:
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
166: P_API_NAME => L_API_NAME
167: ,P_PKG_NAME => G_PKG_NAME
168: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
169: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
165: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
166: P_API_NAME => L_API_NAME
167: ,P_PKG_NAME => G_PKG_NAME
168: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
169: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
170: ,X_MSG_COUNT => X_MSG_COUNT
171: ,X_MSG_DATA => X_MSG_DATA
172: ,X_RETURN_STATUS => X_RETURN_STATUS);
173:
171: ,X_MSG_DATA => X_MSG_DATA
172: ,X_RETURN_STATUS => X_RETURN_STATUS);
173:
174: WHEN OTHERS THEN
175: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
176: P_API_NAME => L_API_NAME
177: ,P_PKG_NAME => G_PKG_NAME
178: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
179: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
174: WHEN OTHERS THEN
175: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
176: P_API_NAME => L_API_NAME
177: ,P_PKG_NAME => G_PKG_NAME
178: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
179: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
180: ,X_MSG_COUNT => X_MSG_COUNT
181: ,X_MSG_DATA => X_MSG_DATA
182: ,X_RETURN_STATUS => X_RETURN_STATUS);
175: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
176: P_API_NAME => L_API_NAME
177: ,P_PKG_NAME => G_PKG_NAME
178: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
179: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
180: ,X_MSG_COUNT => X_MSG_COUNT
181: ,X_MSG_DATA => X_MSG_DATA
182: ,X_RETURN_STATUS => X_RETURN_STATUS);
183: End Create_camp_result;
221: END IF;
222:
223:
224: -- Debug Message
225: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
226:
227:
228:
229: -- Initialize API return status to SUCCESS
245: END IF;
246:
247:
248: -- Debug Message
249: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
250:
251:
252:
253: -- Standard call to get message count and if count is 1, get message info.
257: );
258:
259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
262: P_API_NAME => L_API_NAME
263: ,P_PKG_NAME => G_PKG_NAME
264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
265: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
261: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
262: P_API_NAME => L_API_NAME
263: ,P_PKG_NAME => G_PKG_NAME
264: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
265: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
266: ,X_MSG_COUNT => X_MSG_COUNT
267: ,X_MSG_DATA => X_MSG_DATA
268: ,X_RETURN_STATUS => X_RETURN_STATUS);
269:
267: ,X_MSG_DATA => X_MSG_DATA
268: ,X_RETURN_STATUS => X_RETURN_STATUS);
269:
270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
272: P_API_NAME => L_API_NAME
273: ,P_PKG_NAME => G_PKG_NAME
274: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
275: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
271: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
272: P_API_NAME => L_API_NAME
273: ,P_PKG_NAME => G_PKG_NAME
274: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
275: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
276: ,X_MSG_COUNT => X_MSG_COUNT
277: ,X_MSG_DATA => X_MSG_DATA
278: ,X_RETURN_STATUS => X_RETURN_STATUS);
279:
277: ,X_MSG_DATA => X_MSG_DATA
278: ,X_RETURN_STATUS => X_RETURN_STATUS);
279:
280: WHEN OTHERS THEN
281: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
282: P_API_NAME => L_API_NAME
283: ,P_PKG_NAME => G_PKG_NAME
284: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
285: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
280: WHEN OTHERS THEN
281: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
282: P_API_NAME => L_API_NAME
283: ,P_PKG_NAME => G_PKG_NAME
284: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
285: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
286: ,X_MSG_COUNT => X_MSG_COUNT
287: ,X_MSG_DATA => X_MSG_DATA
288: ,X_RETURN_STATUS => X_RETURN_STATUS);
281: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
282: P_API_NAME => L_API_NAME
283: ,P_PKG_NAME => G_PKG_NAME
284: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
285: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
286: ,X_MSG_COUNT => X_MSG_COUNT
287: ,X_MSG_DATA => X_MSG_DATA
288: ,X_RETURN_STATUS => X_RETURN_STATUS);
289: End Delete_camp_result;