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;
143: END IF;
144:
145:
146: -- Debug Message
147: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
148:
149: -- Standard call to get message count and if count is 1, get message info.
150: FND_MSG_PUB.Count_And_Get
151: ( p_count => x_msg_count,
153: );
154:
155: EXCEPTION
156: WHEN FND_API.G_EXC_ERROR THEN
157: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
158: P_API_NAME => L_API_NAME
159: ,P_PKG_NAME => G_PKG_NAME
160: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
161: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
157: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
158: P_API_NAME => L_API_NAME
159: ,P_PKG_NAME => G_PKG_NAME
160: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
161: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
162: ,X_MSG_COUNT => X_MSG_COUNT
163: ,X_MSG_DATA => X_MSG_DATA
164: ,X_RETURN_STATUS => X_RETURN_STATUS);
165:
163: ,X_MSG_DATA => X_MSG_DATA
164: ,X_RETURN_STATUS => X_RETURN_STATUS);
165:
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
168: P_API_NAME => L_API_NAME
169: ,P_PKG_NAME => G_PKG_NAME
170: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
171: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
167: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
168: P_API_NAME => L_API_NAME
169: ,P_PKG_NAME => G_PKG_NAME
170: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
171: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
172: ,X_MSG_COUNT => X_MSG_COUNT
173: ,X_MSG_DATA => X_MSG_DATA
174: ,X_RETURN_STATUS => X_RETURN_STATUS);
175:
173: ,X_MSG_DATA => X_MSG_DATA
174: ,X_RETURN_STATUS => X_RETURN_STATUS);
175:
176: WHEN OTHERS THEN
177: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
178: P_API_NAME => L_API_NAME
179: ,P_PKG_NAME => G_PKG_NAME
180: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
181: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
176: WHEN OTHERS THEN
177: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
178: P_API_NAME => L_API_NAME
179: ,P_PKG_NAME => G_PKG_NAME
180: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
181: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
182: ,X_MSG_COUNT => X_MSG_COUNT
183: ,X_MSG_DATA => X_MSG_DATA
184: ,X_RETURN_STATUS => X_RETURN_STATUS);
177: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
178: P_API_NAME => L_API_NAME
179: ,P_PKG_NAME => G_PKG_NAME
180: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
181: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
182: ,X_MSG_COUNT => X_MSG_COUNT
183: ,X_MSG_DATA => X_MSG_DATA
184: ,X_RETURN_STATUS => X_RETURN_STATUS);
185: End Create_camp_reason;
223: END IF;
224:
225:
226: -- Debug Message
227: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');
228:
229:
230:
231: -- Initialize API return status to SUCCESS
247: END IF;
248:
249:
250: -- Debug Message
251: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');
252:
253:
254:
255: -- Standard call to get message count and if count is 1, get message info.
259: );
260:
261: EXCEPTION
262: WHEN FND_API.G_EXC_ERROR THEN
263: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
264: P_API_NAME => L_API_NAME
265: ,P_PKG_NAME => G_PKG_NAME
266: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
267: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
263: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
264: P_API_NAME => L_API_NAME
265: ,P_PKG_NAME => G_PKG_NAME
266: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
267: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
268: ,X_MSG_COUNT => X_MSG_COUNT
269: ,X_MSG_DATA => X_MSG_DATA
270: ,X_RETURN_STATUS => X_RETURN_STATUS);
271:
269: ,X_MSG_DATA => X_MSG_DATA
270: ,X_RETURN_STATUS => X_RETURN_STATUS);
271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
274: P_API_NAME => L_API_NAME
275: ,P_PKG_NAME => G_PKG_NAME
276: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
277: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
273: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
274: P_API_NAME => L_API_NAME
275: ,P_PKG_NAME => G_PKG_NAME
276: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
277: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
278: ,X_MSG_COUNT => X_MSG_COUNT
279: ,X_MSG_DATA => X_MSG_DATA
280: ,X_RETURN_STATUS => X_RETURN_STATUS);
281:
279: ,X_MSG_DATA => X_MSG_DATA
280: ,X_RETURN_STATUS => X_RETURN_STATUS);
281:
282: WHEN OTHERS THEN
283: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
284: P_API_NAME => L_API_NAME
285: ,P_PKG_NAME => G_PKG_NAME
286: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
287: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
282: WHEN OTHERS THEN
283: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
284: P_API_NAME => L_API_NAME
285: ,P_PKG_NAME => G_PKG_NAME
286: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
287: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
288: ,X_MSG_COUNT => X_MSG_COUNT
289: ,X_MSG_DATA => X_MSG_DATA
290: ,X_RETURN_STATUS => X_RETURN_STATUS);
283: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
284: P_API_NAME => L_API_NAME
285: ,P_PKG_NAME => G_PKG_NAME
286: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
287: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
288: ,X_MSG_COUNT => X_MSG_COUNT
289: ,X_MSG_DATA => X_MSG_DATA
290: ,X_RETURN_STATUS => X_RETURN_STATUS);
291: End Delete_camp_reason;