DBA Data[Home] [Help]

APPS.ASO_INSTBASE_INT dependencies on ASO_UTILITY_PVT

Line 87: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

83: FND_MSG_PUB.initialize;
84: END IF;
85:
86: -- Debug Message
87: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
88:
89: -- Initialize API return status to SUCCESS
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91:

Line 128: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');

124: END IF;
125:
126:
127: -- Debug Message
128: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
129:
130:
131: -- Standard call to get message count and if count is 1, get message info.
132: FND_MSG_PUB.Count_And_Get

Line 140: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

136:
137: EXCEPTION
138: WHEN FND_API.G_EXC_ERROR THEN
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
141: P_API_NAME => L_API_NAME
142: ,P_PKG_NAME => G_PKG_NAME
143: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
144: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 144: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

140: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
141: P_API_NAME => L_API_NAME
142: ,P_PKG_NAME => G_PKG_NAME
143: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
144: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
145: ,X_MSG_COUNT => X_MSG_COUNT
146: ,X_MSG_DATA => X_MSG_DATA
147: ,X_RETURN_STATUS => X_RETURN_STATUS);
148:

Line 151: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

147: ,X_RETURN_STATUS => X_RETURN_STATUS);
148:
149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
151: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
152: P_API_NAME => L_API_NAME
153: ,P_PKG_NAME => G_PKG_NAME
154: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
155: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 155: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

151: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
152: P_API_NAME => L_API_NAME
153: ,P_PKG_NAME => G_PKG_NAME
154: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
155: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
156: ,X_MSG_COUNT => X_MSG_COUNT
157: ,X_MSG_DATA => X_MSG_DATA
158: ,X_RETURN_STATUS => X_RETURN_STATUS);
159:

Line 162: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

158: ,X_RETURN_STATUS => X_RETURN_STATUS);
159:
160: WHEN OTHERS THEN
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
162: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
163: P_API_NAME => L_API_NAME
164: ,P_PKG_NAME => G_PKG_NAME
165: ,P_SQLERRM => sqlerrm
166: ,P_SQLCODE => sqlcode

Line 167: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

163: P_API_NAME => L_API_NAME
164: ,P_PKG_NAME => G_PKG_NAME
165: ,P_SQLERRM => sqlerrm
166: ,P_SQLCODE => sqlcode
167: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
168: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
169: ,X_MSG_COUNT => X_MSG_COUNT
170: ,X_MSG_DATA => X_MSG_DATA
171: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 168: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

164: ,P_PKG_NAME => G_PKG_NAME
165: ,P_SQLERRM => sqlerrm
166: ,P_SQLCODE => sqlcode
167: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
168: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
169: ,X_MSG_COUNT => X_MSG_COUNT
170: ,X_MSG_DATA => X_MSG_DATA
171: ,X_RETURN_STATUS => X_RETURN_STATUS);
172: END Delete_Installation_Detail;

Line 240: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

236: FND_MSG_PUB.initialize;
237: END IF;
238:
239: -- Debug Message
240: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
241:
242: -- Initialize API return status to SUCCESS
243: x_return_status := FND_API.G_RET_STS_SUCCESS;
244:

Line 305: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');

301: END IF;
302:
303:
304: -- Debug Message
305: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
306:
307:
308: -- Standard call to get message count and if count is 1, get message info.
309: FND_MSG_PUB.Count_And_Get

Line 317: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

313:
314: EXCEPTION
315: WHEN FND_API.G_EXC_ERROR THEN
316: x_return_status := FND_API.G_RET_STS_ERROR;
317: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
318: P_API_NAME => L_API_NAME
319: ,P_PKG_NAME => G_PKG_NAME
320: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
321: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 321: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

317: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
318: P_API_NAME => L_API_NAME
319: ,P_PKG_NAME => G_PKG_NAME
320: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
321: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
322: ,X_MSG_COUNT => X_MSG_COUNT
323: ,X_MSG_DATA => X_MSG_DATA
324: ,X_RETURN_STATUS => X_RETURN_STATUS);
325:

Line 328: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

324: ,X_RETURN_STATUS => X_RETURN_STATUS);
325:
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
329: P_API_NAME => L_API_NAME
330: ,P_PKG_NAME => G_PKG_NAME
331: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
332: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 332: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

328: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
329: P_API_NAME => L_API_NAME
330: ,P_PKG_NAME => G_PKG_NAME
331: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
332: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
333: ,X_MSG_COUNT => X_MSG_COUNT
334: ,X_MSG_DATA => X_MSG_DATA
335: ,X_RETURN_STATUS => X_RETURN_STATUS);
336:

Line 339: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

335: ,X_RETURN_STATUS => X_RETURN_STATUS);
336:
337: WHEN OTHERS THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
340: P_API_NAME => L_API_NAME
341: ,P_PKG_NAME => G_PKG_NAME
342: ,P_SQLERRM => sqlerrm
343: ,P_SQLCODE => sqlcode

Line 344: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

340: P_API_NAME => L_API_NAME
341: ,P_PKG_NAME => G_PKG_NAME
342: ,P_SQLERRM => sqlerrm
343: ,P_SQLCODE => sqlcode
344: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
345: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
346: ,X_MSG_COUNT => X_MSG_COUNT
347: ,X_MSG_DATA => X_MSG_DATA
348: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 345: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

341: ,P_PKG_NAME => G_PKG_NAME
342: ,P_SQLERRM => sqlerrm
343: ,P_SQLCODE => sqlcode
344: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
345: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
346: ,X_MSG_COUNT => X_MSG_COUNT
347: ,X_MSG_DATA => X_MSG_DATA
348: ,X_RETURN_STATUS => X_RETURN_STATUS);
349: