DBA Data[Home] [Help]

APPS.ASO_CONFIG_OPERATIONS_PVT dependencies on ASO_UTILITY_PVT

Line 307: x_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_quote_header_id);

303: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
304: raise FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306:
307: x_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_quote_header_id);
308:
309: -- End of API body
310: IF aso_debug_pub.g_debug_flag = 'Y' THEN
311: aso_debug_pub.add('****** End of add to container API ******', 1, 'Y');

Line 331: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

327:
328: EXCEPTION
329: WHEN FND_API.G_EXC_ERROR THEN
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
332: P_API_NAME => L_API_NAME
333: ,P_PKG_NAME => G_PKG_NAME
334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
335: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 335: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

331: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
332: P_API_NAME => L_API_NAME
333: ,P_PKG_NAME => G_PKG_NAME
334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
335: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
336: ,X_MSG_COUNT => X_MSG_COUNT
337: ,X_MSG_DATA => X_MSG_DATA
338: ,X_RETURN_STATUS => X_RETURN_STATUS);
339:

Line 342: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

338: ,X_RETURN_STATUS => X_RETURN_STATUS);
339:
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
343: P_API_NAME => L_API_NAME
344: ,P_PKG_NAME => G_PKG_NAME
345: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
346: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 346: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

342: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
343: P_API_NAME => L_API_NAME
344: ,P_PKG_NAME => G_PKG_NAME
345: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
346: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
347: ,X_MSG_COUNT => X_MSG_COUNT
348: ,X_MSG_DATA => X_MSG_DATA
349: ,X_RETURN_STATUS => X_RETURN_STATUS);
350:

Line 353: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

349: ,X_RETURN_STATUS => X_RETURN_STATUS);
350:
351: WHEN OTHERS THEN
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
354: P_API_NAME => L_API_NAME
355: ,P_PKG_NAME => G_PKG_NAME
356: ,P_SQLERRM => sqlerrm
357: ,P_SQLCODE => sqlcode

Line 358: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

354: P_API_NAME => L_API_NAME
355: ,P_PKG_NAME => G_PKG_NAME
356: ,P_SQLERRM => sqlerrm
357: ,P_SQLCODE => sqlcode
358: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
359: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
360: ,X_MSG_COUNT => X_MSG_COUNT
361: ,X_MSG_DATA => X_MSG_DATA
362: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 359: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

355: ,P_PKG_NAME => G_PKG_NAME
356: ,P_SQLERRM => sqlerrm
357: ,P_SQLCODE => sqlcode
358: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
359: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
360: ,X_MSG_COUNT => X_MSG_COUNT
361: ,X_MSG_DATA => X_MSG_DATA
362: ,X_RETURN_STATUS => X_RETURN_STATUS);
363:

Line 750: x_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(P_QTE_HEADER_REC.quote_header_id);

746: END IF;
747:
748: END LOOP;
749:
750: x_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(P_QTE_HEADER_REC.quote_header_id);
751:
752: -- End of API body
753:
754: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 774: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

770:
771: EXCEPTION
772: WHEN FND_API.G_EXC_ERROR THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
775: P_API_NAME => L_API_NAME
776: ,P_PKG_NAME => G_PKG_NAME
777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
778: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 778: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

774: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
775: P_API_NAME => L_API_NAME
776: ,P_PKG_NAME => G_PKG_NAME
777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
778: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
779: ,X_MSG_COUNT => X_MSG_COUNT
780: ,X_MSG_DATA => X_MSG_DATA
781: ,X_RETURN_STATUS => X_RETURN_STATUS);
782:

Line 785: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

781: ,X_RETURN_STATUS => X_RETURN_STATUS);
782:
783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
786: P_API_NAME => L_API_NAME
787: ,P_PKG_NAME => G_PKG_NAME
788: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
789: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 789: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

785: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
786: P_API_NAME => L_API_NAME
787: ,P_PKG_NAME => G_PKG_NAME
788: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
789: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
790: ,X_MSG_COUNT => X_MSG_COUNT
791: ,X_MSG_DATA => X_MSG_DATA
792: ,X_RETURN_STATUS => X_RETURN_STATUS);
793:

Line 796: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

792: ,X_RETURN_STATUS => X_RETURN_STATUS);
793:
794: WHEN OTHERS THEN
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
797: P_API_NAME => L_API_NAME
798: ,P_PKG_NAME => G_PKG_NAME
799: ,P_SQLERRM => sqlerrm
800: ,P_SQLCODE => sqlcode

Line 801: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

797: P_API_NAME => L_API_NAME
798: ,P_PKG_NAME => G_PKG_NAME
799: ,P_SQLERRM => sqlerrm
800: ,P_SQLCODE => sqlcode
801: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
802: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
803: ,X_MSG_COUNT => X_MSG_COUNT
804: ,X_MSG_DATA => X_MSG_DATA
805: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 802: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

798: ,P_PKG_NAME => G_PKG_NAME
799: ,P_SQLERRM => sqlerrm
800: ,P_SQLCODE => sqlcode
801: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
802: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
803: ,X_MSG_COUNT => X_MSG_COUNT
804: ,X_MSG_DATA => X_MSG_DATA
805: ,X_RETURN_STATUS => X_RETURN_STATUS);
806:

Line 1249: x_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(P_QTE_HEADER_REC.quote_header_id);

1245: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1246: aso_debug_pub.add('Deactivate_from_quote:Query Quote Header Rec', 1, 'N');
1247: END IF;
1248:
1249: x_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(P_QTE_HEADER_REC.quote_header_id);
1250:
1251: -- End of API body
1252:
1253: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1272: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1268:
1269: EXCEPTION
1270: WHEN FND_API.G_EXC_ERROR THEN
1271: x_return_status := FND_API.G_RET_STS_ERROR;
1272: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1273: P_API_NAME => L_API_NAME
1274: ,P_PKG_NAME => G_PKG_NAME
1275: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1276: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1276: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1272: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1273: P_API_NAME => L_API_NAME
1274: ,P_PKG_NAME => G_PKG_NAME
1275: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1276: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1277: ,X_MSG_COUNT => X_MSG_COUNT
1278: ,X_MSG_DATA => X_MSG_DATA
1279: ,X_RETURN_STATUS => X_RETURN_STATUS);
1280:

Line 1283: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1279: ,X_RETURN_STATUS => X_RETURN_STATUS);
1280:
1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1283: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1284: P_API_NAME => L_API_NAME
1285: ,P_PKG_NAME => G_PKG_NAME
1286: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1287: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1287: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1283: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1284: P_API_NAME => L_API_NAME
1285: ,P_PKG_NAME => G_PKG_NAME
1286: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1287: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1288: ,X_MSG_COUNT => X_MSG_COUNT
1289: ,X_MSG_DATA => X_MSG_DATA
1290: ,X_RETURN_STATUS => X_RETURN_STATUS);
1291:

Line 1294: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1290: ,X_RETURN_STATUS => X_RETURN_STATUS);
1291:
1292: WHEN OTHERS THEN
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1295: P_API_NAME => L_API_NAME
1296: ,P_PKG_NAME => G_PKG_NAME
1297: ,P_SQLERRM => sqlerrm
1298: ,P_SQLCODE => sqlcode

Line 1299: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1295: P_API_NAME => L_API_NAME
1296: ,P_PKG_NAME => G_PKG_NAME
1297: ,P_SQLERRM => sqlerrm
1298: ,P_SQLCODE => sqlcode
1299: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1300: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1301: ,X_MSG_COUNT => X_MSG_COUNT
1302: ,X_MSG_DATA => X_MSG_DATA
1303: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1300: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1296: ,P_PKG_NAME => G_PKG_NAME
1297: ,P_SQLERRM => sqlerrm
1298: ,P_SQLCODE => sqlcode
1299: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1300: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1301: ,X_MSG_COUNT => X_MSG_COUNT
1302: ,X_MSG_DATA => X_MSG_DATA
1303: ,X_RETURN_STATUS => X_RETURN_STATUS);
1304: