DBA Data[Home] [Help]

APPS.AST_CAMP_REASON_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 147: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: ' || l_api_name || 'end');

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,

Line 157: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

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

Line 167: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

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

Line 177: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 180: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 181: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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;

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

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

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

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.

Line 263: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

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

Line 273: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

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

Line 283: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

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

Line 286: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

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

Line 287: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

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;