DBA Data[Home] [Help]

APPS.AST_CAMP_RESULT_PVT dependencies on JTF_PLSQL_API

Line 75: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');

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;

Line 145: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');

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,

Line 155: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

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

Line 165: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

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

Line 175: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 178: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 179: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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;

Line 225: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'start');

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

Line 249: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');

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.

Line 261: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

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

Line 271: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

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

Line 281: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 284: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 285: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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;