eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_PRICING_INT dependencies on ASO_UTILITY_PVT

Line 899: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

895:
896:
897: EXCEPTION
898: WHEN FND_API.G_EXC_ERROR THEN
899: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
900: P_API_NAME => L_API_NAME
901: ,P_PKG_NAME => G_PKG_NAME
902: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
903: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 903: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

899: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
900: P_API_NAME => L_API_NAME
901: ,P_PKG_NAME => G_PKG_NAME
902: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
903: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
904: ,P_SQLCODE => SQLCODE
905: ,P_SQLERRM => SQLERRM
906: ,X_MSG_COUNT => X_MSG_COUNT
907: ,X_MSG_DATA => X_MSG_DATA

Line 911: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

907: ,X_MSG_DATA => X_MSG_DATA
908: ,X_RETURN_STATUS => X_RETURN_STATUS);
909:
910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
912: P_API_NAME => L_API_NAME
913: ,P_PKG_NAME => G_PKG_NAME
914: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
915: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 915: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

911: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
912: P_API_NAME => L_API_NAME
913: ,P_PKG_NAME => G_PKG_NAME
914: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
915: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
916: ,P_SQLCODE => SQLCODE
917: ,P_SQLERRM => SQLERRM
918: ,X_MSG_COUNT => X_MSG_COUNT
919: ,X_MSG_DATA => X_MSG_DATA

Line 923: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

919: ,X_MSG_DATA => X_MSG_DATA
920: ,X_RETURN_STATUS => X_RETURN_STATUS);
921:
922: WHEN OTHERS THEN
923: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
924: P_API_NAME => L_API_NAME
925: ,P_PKG_NAME => G_PKG_NAME
926: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
927: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 926: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

922: WHEN OTHERS THEN
923: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
924: P_API_NAME => L_API_NAME
925: ,P_PKG_NAME => G_PKG_NAME
926: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
927: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
928: ,P_SQLCODE => SQLCODE
929: ,P_SQLERRM => SQLERRM
930: ,X_MSG_COUNT => X_MSG_COUNT

Line 927: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

923: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
924: P_API_NAME => L_API_NAME
925: ,P_PKG_NAME => G_PKG_NAME
926: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
927: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
928: ,P_SQLCODE => SQLCODE
929: ,P_SQLERRM => SQLERRM
930: ,X_MSG_COUNT => X_MSG_COUNT
931: ,X_MSG_DATA => X_MSG_DATA

Line 1174: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1170: WHEN FND_API.G_EXC_ERROR THEN
1171: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1172: aso_debug_pub.add('ASO_PRICING_INT:after inside EXCEPTION return status'||x_return_status, 1, 'Y');
1173: END IF;
1174: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1175: P_API_NAME => L_API_NAME
1176: ,P_PKG_NAME => G_PKG_NAME
1177: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1178: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1178: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1174: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1175: P_API_NAME => L_API_NAME
1176: ,P_PKG_NAME => G_PKG_NAME
1177: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1178: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1179: ,P_SQLCODE => SQLCODE
1180: ,P_SQLERRM => SQLERRM
1181: ,X_MSG_COUNT => X_MSG_COUNT
1182: ,X_MSG_DATA => X_MSG_DATA

Line 1186: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1182: ,X_MSG_DATA => X_MSG_DATA
1183: ,X_RETURN_STATUS => X_RETURN_STATUS);
1184:
1185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1186: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1187: P_API_NAME => L_API_NAME
1188: ,P_PKG_NAME => G_PKG_NAME
1189: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1190: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1190: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1186: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1187: P_API_NAME => L_API_NAME
1188: ,P_PKG_NAME => G_PKG_NAME
1189: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1190: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1191: ,P_SQLCODE => SQLCODE
1192: ,P_SQLERRM => SQLERRM
1193: ,X_MSG_COUNT => X_MSG_COUNT
1194: ,X_MSG_DATA => X_MSG_DATA

Line 1198: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1194: ,X_MSG_DATA => X_MSG_DATA
1195: ,X_RETURN_STATUS => X_RETURN_STATUS);
1196:
1197: WHEN OTHERS THEN
1198: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1199: P_API_NAME => L_API_NAME
1200: ,P_PKG_NAME => G_PKG_NAME
1201: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1202: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1201: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1197: WHEN OTHERS THEN
1198: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1199: P_API_NAME => L_API_NAME
1200: ,P_PKG_NAME => G_PKG_NAME
1201: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1202: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1203: ,P_SQLCODE => SQLCODE
1204: ,P_SQLERRM => SQLERRM
1205: ,X_MSG_COUNT => X_MSG_COUNT

Line 1202: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1198: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1199: P_API_NAME => L_API_NAME
1200: ,P_PKG_NAME => G_PKG_NAME
1201: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1202: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1203: ,P_SQLCODE => SQLCODE
1204: ,P_SQLERRM => SQLERRM
1205: ,X_MSG_COUNT => X_MSG_COUNT
1206: ,X_MSG_DATA => X_MSG_DATA

Line 1280: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);

1276:
1277: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1278:
1279: x_return_status := FND_API.G_RET_STS_SUCCESS;
1280: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);
1281: l_qte_header_id := l_qte_line_rec.QUOTE_HEADER_ID;
1282: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_qte_header_id);
1283: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(l_qte_header_id, NULL);
1284:

Line 1282: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_qte_header_id);

1278:
1279: x_return_status := FND_API.G_RET_STS_SUCCESS;
1280: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);
1281: l_qte_header_id := l_qte_line_rec.QUOTE_HEADER_ID;
1282: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_qte_header_id);
1283: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(l_qte_header_id, NULL);
1284:
1285: IF l_hd_shipment_tbl.count = 1 THEN
1286: l_hd_shipment_rec := l_hd_shipment_tbl(1);

Line 1283: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(l_qte_header_id, NULL);

1279: x_return_status := FND_API.G_RET_STS_SUCCESS;
1280: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);
1281: l_qte_header_id := l_qte_line_rec.QUOTE_HEADER_ID;
1282: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_qte_header_id);
1283: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(l_qte_header_id, NULL);
1284:
1285: IF l_hd_shipment_tbl.count = 1 THEN
1286: l_hd_shipment_rec := l_hd_shipment_tbl(1);
1287: END IF;

Line 1288: l_hd_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(l_qte_header_id, null);

1284:
1285: IF l_hd_shipment_tbl.count = 1 THEN
1286: l_hd_shipment_rec := l_hd_shipment_tbl(1);
1287: END IF;
1288: l_hd_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(l_qte_header_id, null);
1289: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_qte_line_id);
1290:
1291: IF l_qte_line_dtl_tbl.count = 1 THEN
1292: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(1);

Line 1289: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_qte_line_id);

1285: IF l_hd_shipment_tbl.count = 1 THEN
1286: l_hd_shipment_rec := l_hd_shipment_tbl(1);
1287: END IF;
1288: l_hd_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(l_qte_header_id, null);
1289: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_qte_line_id);
1290:
1291: IF l_qte_line_dtl_tbl.count = 1 THEN
1292: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(1);
1293: END IF;

Line 1294: l_ln_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(l_qte_header_id, p_QTE_LINE_ID);

1290:
1291: IF l_qte_line_dtl_tbl.count = 1 THEN
1292: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(1);
1293: END IF;
1294: l_ln_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(l_qte_header_id, p_QTE_LINE_ID);
1295:
1296: IF l_ln_shipment_tbl.count = 1 THEN
1297: l_ln_shipment_rec := l_ln_shipment_tbl(1);
1298: END IF;

Line 1299: l_ln_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(l_qte_header_id, p_qte_line_id);

1295:
1296: IF l_ln_shipment_tbl.count = 1 THEN
1297: l_ln_shipment_rec := l_ln_shipment_tbl(1);
1298: END IF;
1299: l_ln_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(l_qte_header_id, p_qte_line_id);
1300: --Code changed on 04/18/2000
1301:
1302: OPEN c_header_id;
1303: FETCH c_header_id INTO l_qte_header_id;

Line 1361: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(lx_qte_line_tbl(i).quote_line_id);

1357: aso_debug_pub.add('ASO_PRICING_INT:ADJ Lines deleted '||sql%ROWCOUNT,1,'Y');
1358: END IF;
1359:
1360: FOR i IN 1..lx_qte_line_tbl.count LOOP
1361: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(lx_qte_line_tbl(i).quote_line_id);
1362: lx_qte_line_tbl(i).price_list_id := l_qte_line_rec.price_list_id;
1363: END LOOP;
1364:
1365: ASO_PRICING_CALLBACK_PVT.Update_Quote_Rows (

Line 1384: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1380: END IF;
1381:
1382: EXCEPTION
1383: WHEN FND_API.G_EXC_ERROR THEN
1384: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1385: P_API_NAME => L_API_NAME
1386: ,P_PKG_NAME => G_PKG_NAME
1387: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1388: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1388: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1384: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1385: P_API_NAME => L_API_NAME
1386: ,P_PKG_NAME => G_PKG_NAME
1387: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1388: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1389: ,P_SQLCODE => SQLCODE
1390: ,P_SQLERRM => SQLERRM
1391: ,X_MSG_COUNT => X_MSG_COUNT
1392: ,X_MSG_DATA => X_MSG_DATA

Line 1396: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1392: ,X_MSG_DATA => X_MSG_DATA
1393: ,X_RETURN_STATUS => X_RETURN_STATUS);
1394:
1395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1396: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1397: P_API_NAME => L_API_NAME
1398: ,P_PKG_NAME => G_PKG_NAME
1399: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1400: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1400: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1396: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1397: P_API_NAME => L_API_NAME
1398: ,P_PKG_NAME => G_PKG_NAME
1399: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1400: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1401: ,P_SQLCODE => SQLCODE
1402: ,P_SQLERRM => SQLERRM
1403: ,X_MSG_COUNT => X_MSG_COUNT
1404: ,X_MSG_DATA => X_MSG_DATA

Line 1408: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1404: ,X_MSG_DATA => X_MSG_DATA
1405: ,X_RETURN_STATUS => X_RETURN_STATUS);
1406:
1407: WHEN OTHERS THEN
1408: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1409: P_API_NAME => L_API_NAME
1410: ,P_PKG_NAME => G_PKG_NAME
1411: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1412: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1411: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1407: WHEN OTHERS THEN
1408: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1409: P_API_NAME => L_API_NAME
1410: ,P_PKG_NAME => G_PKG_NAME
1411: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1412: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1413: ,P_SQLCODE => SQLCODE
1414: ,P_SQLERRM => SQLERRM
1415: ,X_MSG_COUNT => X_MSG_COUNT

Line 1412: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1408: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1409: P_API_NAME => L_API_NAME
1410: ,P_PKG_NAME => G_PKG_NAME
1411: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1412: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1413: ,P_SQLCODE => SQLCODE
1414: ,P_SQLERRM => SQLERRM
1415: ,X_MSG_COUNT => X_MSG_COUNT
1416: ,X_MSG_DATA => X_MSG_DATA

Line 1514: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);

1510: x_return_status := FND_API.G_RET_STS_SUCCESS;
1511: l_request_type := p_control_rec.request_type;
1512: l_pricing_event := p_control_rec.pricing_event;
1513:
1514: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
1515: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id,NULL);
1516: IF l_shipment_tbl.count = 1 THEN
1517: l_shipment_rec := l_shipment_tbl(1);
1518: END IF;

Line 1515: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id,NULL);

1511: l_request_type := p_control_rec.request_type;
1512: l_pricing_event := p_control_rec.pricing_event;
1513:
1514: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
1515: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id,NULL);
1516: IF l_shipment_tbl.count = 1 THEN
1517: l_shipment_rec := l_shipment_tbl(1);
1518: END IF;
1519: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, null);

Line 1519: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, null);

1515: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id,NULL);
1516: IF l_shipment_tbl.count = 1 THEN
1517: l_shipment_rec := l_shipment_tbl(1);
1518: END IF;
1519: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, null);
1520: ASO_PRICING_INT.Pricing_Order(
1521: P_Api_Version_Number => 1.0,
1522: P_Init_Msg_List => FND_API.G_FALSE,
1523: P_Commit => FND_API.G_FALSE,

Line 1556: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1552: );
1553:
1554: EXCEPTION
1555: WHEN FND_API.G_EXC_ERROR THEN
1556: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1557: P_API_NAME => L_API_NAME
1558: ,P_PKG_NAME => G_PKG_NAME
1559: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1560: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1560: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1556: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1557: P_API_NAME => L_API_NAME
1558: ,P_PKG_NAME => G_PKG_NAME
1559: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1560: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1561: ,P_SQLCODE => SQLCODE
1562: ,P_SQLERRM => SQLERRM
1563: ,X_MSG_COUNT => X_MSG_COUNT
1564: ,X_MSG_DATA => X_MSG_DATA

Line 1568: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1564: ,X_MSG_DATA => X_MSG_DATA
1565: ,X_RETURN_STATUS => X_RETURN_STATUS);
1566:
1567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1568: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1569: P_API_NAME => L_API_NAME
1570: ,P_PKG_NAME => G_PKG_NAME
1571: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1572: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1572: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1568: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1569: P_API_NAME => L_API_NAME
1570: ,P_PKG_NAME => G_PKG_NAME
1571: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1572: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1573: ,P_SQLCODE => SQLCODE
1574: ,P_SQLERRM => SQLERRM
1575: ,X_MSG_COUNT => X_MSG_COUNT
1576: ,X_MSG_DATA => X_MSG_DATA

Line 1580: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1576: ,X_MSG_DATA => X_MSG_DATA
1577: ,X_RETURN_STATUS => X_RETURN_STATUS);
1578:
1579: WHEN OTHERS THEN
1580: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1581: P_API_NAME => L_API_NAME
1582: ,P_PKG_NAME => G_PKG_NAME
1583: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1584: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1583: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1579: WHEN OTHERS THEN
1580: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1581: P_API_NAME => L_API_NAME
1582: ,P_PKG_NAME => G_PKG_NAME
1583: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1584: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1585: ,P_SQLCODE => SQLCODE
1586: ,P_SQLERRM => SQLERRM
1587: ,X_MSG_COUNT => X_MSG_COUNT

Line 1584: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1580: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1581: P_API_NAME => L_API_NAME
1582: ,P_PKG_NAME => G_PKG_NAME
1583: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1584: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1585: ,P_SQLCODE => SQLCODE
1586: ,P_SQLERRM => SQLERRM
1587: ,X_MSG_COUNT => X_MSG_COUNT
1588: ,X_MSG_DATA => X_MSG_DATA