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_SPLIT_LINE_INT dependencies on ASO_UTILITY_PVT

Line 313: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_original_qte_line_rec.quote_line_id);

309: RAISE FND_API.G_EXC_ERROR;
310:
311: ELSE
312:
313: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_original_qte_line_rec.quote_line_id);
314:
315: IF l_qte_line_rec.line_category_code = 'RETURN' THEN
316:
317: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_rec.quote_line_id);

Line 317: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_rec.quote_line_id);

313: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_original_qte_line_rec.quote_line_id);
314:
315: IF l_qte_line_rec.line_category_code = 'RETURN' THEN
316:
317: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_rec.quote_line_id);
318:
319: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
320: aso_debug_pub.add('Split_Quote_Line: l_qte_line_dtl_tbl.count: '||l_qte_line_dtl_tbl.count);
321: END IF;

Line 540: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

536: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
537: aso_debug_pub.add('Split_Quote_line: WHEN FND_API.G_EXC_ERROR', 1, 'N');
538: END IF;
539:
540: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
541: P_PKG_NAME => G_PKG_NAME,
542: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
543: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
544: X_MSG_COUNT => X_MSG_COUNT,

Line 543: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

539:
540: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
541: P_PKG_NAME => G_PKG_NAME,
542: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
543: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
544: X_MSG_COUNT => X_MSG_COUNT,
545: X_MSG_DATA => X_MSG_DATA,
546: X_RETURN_STATUS => X_RETURN_STATUS);
547:

Line 554: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

550: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
551: aso_debug_pub.add('Split_Quote_line: WHEN FND_API.G_EXC_UNEXPECTED_ERROR', 1, 'N');
552: END IF;
553:
554: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
555: P_PKG_NAME => G_PKG_NAME,
556: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
557: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
558: X_MSG_COUNT => X_MSG_COUNT,

Line 557: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

553:
554: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
555: P_PKG_NAME => G_PKG_NAME,
556: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
557: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
558: X_MSG_COUNT => X_MSG_COUNT,
559: X_MSG_DATA => X_MSG_DATA,
560: X_RETURN_STATUS => X_RETURN_STATUS);
561:

Line 569: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

565: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
566: aso_debug_pub.add('Split_Quote_line: WHEN OTHERS', 1, 'N');
567: END IF;
568:
569: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
570: P_PKG_NAME => G_PKG_NAME,
571: P_SQLERRM => SQLERRM,
572: P_SQLCODE => SQLCODE,
573: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

Line 573: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

569: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
570: P_PKG_NAME => G_PKG_NAME,
571: P_SQLERRM => SQLERRM,
572: P_SQLCODE => SQLCODE,
573: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
574: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
575: X_MSG_COUNT => X_MSG_COUNT,
576: X_MSG_DATA => X_MSG_DATA,
577: X_RETURN_STATUS => X_RETURN_STATUS);

Line 574: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

570: P_PKG_NAME => G_PKG_NAME,
571: P_SQLERRM => SQLERRM,
572: P_SQLCODE => SQLCODE,
573: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
574: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
575: X_MSG_COUNT => X_MSG_COUNT,
576: X_MSG_DATA => X_MSG_DATA,
577: X_RETURN_STATUS => X_RETURN_STATUS);
578:

Line 703: l_qte_header_rec := aso_utility_pvt.query_header_row(l_qte_line_rec.quote_header_id);

699:
700: x_return_status := fnd_api.g_ret_sts_success;
701:
702: /*
703: l_qte_header_rec := aso_utility_pvt.query_header_row(l_qte_line_rec.quote_header_id);
704:
705: IF aso_debug_pub.g_debug_flag = 'Y' THEN
706: aso_debug_pub.add('Do_Split_Line: After querying quote header row', 1, 'N');
707: END IF;

Line 711: l_ln_Shipment_Tbl := aso_utility_pvt.Query_Shipment_Rows(l_qte_line_rec.quote_header_id,

707: END IF;
708: */
709:
710: l_ln_quantity_before_spilt := l_qte_line_rec.quantity;
711: l_ln_Shipment_Tbl := aso_utility_pvt.Query_Shipment_Rows(l_qte_line_rec.quote_header_id,
712: l_qte_line_rec.quote_line_id);
713:
714: IF aso_debug_pub.g_debug_flag = 'Y' THEN
715: aso_debug_pub.add('Do_Split_Line: After querying shipment rows', 1, 'N');

Line 718: l_qte_line_dtl_tbl := aso_utility_pvt.query_line_dtl_rows(l_qte_line_rec.quote_line_id);

714: IF aso_debug_pub.g_debug_flag = 'Y' THEN
715: aso_debug_pub.add('Do_Split_Line: After querying shipment rows', 1, 'N');
716: END IF;
717:
718: l_qte_line_dtl_tbl := aso_utility_pvt.query_line_dtl_rows(l_qte_line_rec.quote_line_id);
719: /* l_payment_tbl := aso_utility_pvt.query_payment_rows(l_qte_line_rec.quote_header_id,
720: l_qte_line_rec.quote_line_id); */
721: l_sales_credit_tbl := aso_utility_pvt.query_sales_credit_row(l_qte_line_rec.quote_header_id,
722: l_qte_line_rec.quote_line_id);

Line 719: /* l_payment_tbl := aso_utility_pvt.query_payment_rows(l_qte_line_rec.quote_header_id,

715: aso_debug_pub.add('Do_Split_Line: After querying shipment rows', 1, 'N');
716: END IF;
717:
718: l_qte_line_dtl_tbl := aso_utility_pvt.query_line_dtl_rows(l_qte_line_rec.quote_line_id);
719: /* l_payment_tbl := aso_utility_pvt.query_payment_rows(l_qte_line_rec.quote_header_id,
720: l_qte_line_rec.quote_line_id); */
721: l_sales_credit_tbl := aso_utility_pvt.query_sales_credit_row(l_qte_line_rec.quote_header_id,
722: l_qte_line_rec.quote_line_id);
723: l_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(l_qte_line_rec.quote_header_id,

Line 721: l_sales_credit_tbl := aso_utility_pvt.query_sales_credit_row(l_qte_line_rec.quote_header_id,

717:
718: l_qte_line_dtl_tbl := aso_utility_pvt.query_line_dtl_rows(l_qte_line_rec.quote_line_id);
719: /* l_payment_tbl := aso_utility_pvt.query_payment_rows(l_qte_line_rec.quote_header_id,
720: l_qte_line_rec.quote_line_id); */
721: l_sales_credit_tbl := aso_utility_pvt.query_sales_credit_row(l_qte_line_rec.quote_header_id,
722: l_qte_line_rec.quote_line_id);
723: l_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(l_qte_line_rec.quote_header_id,
724: l_qte_line_rec.quote_line_id);
725: l_price_adj_tbl := aso_utility_pvt.query_price_adj_nonPRG_rows(l_qte_line_rec.quote_header_id,

Line 723: l_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(l_qte_line_rec.quote_header_id,

719: /* l_payment_tbl := aso_utility_pvt.query_payment_rows(l_qte_line_rec.quote_header_id,
720: l_qte_line_rec.quote_line_id); */
721: l_sales_credit_tbl := aso_utility_pvt.query_sales_credit_row(l_qte_line_rec.quote_header_id,
722: l_qte_line_rec.quote_line_id);
723: l_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(l_qte_line_rec.quote_header_id,
724: l_qte_line_rec.quote_line_id);
725: l_price_adj_tbl := aso_utility_pvt.query_price_adj_nonPRG_rows(l_qte_line_rec.quote_header_id,
726: l_qte_line_rec.quote_line_id);
727: l_price_adj_rltship_tbl := aso_utility_pvt.Query_Price_Adj_Rltn_Rows(l_qte_line_rec.quote_line_id);

Line 725: l_price_adj_tbl := aso_utility_pvt.query_price_adj_nonPRG_rows(l_qte_line_rec.quote_header_id,

721: l_sales_credit_tbl := aso_utility_pvt.query_sales_credit_row(l_qte_line_rec.quote_header_id,
722: l_qte_line_rec.quote_line_id);
723: l_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(l_qte_line_rec.quote_header_id,
724: l_qte_line_rec.quote_line_id);
725: l_price_adj_tbl := aso_utility_pvt.query_price_adj_nonPRG_rows(l_qte_line_rec.quote_header_id,
726: l_qte_line_rec.quote_line_id);
727: l_price_adj_rltship_tbl := aso_utility_pvt.Query_Price_Adj_Rltn_Rows(l_qte_line_rec.quote_line_id);
728: l_price_adj_attr_tbl := aso_utility_pvt.Query_Price_Adj_Attr_Rows(l_price_adj_tbl);
729:

Line 727: l_price_adj_rltship_tbl := aso_utility_pvt.Query_Price_Adj_Rltn_Rows(l_qte_line_rec.quote_line_id);

723: l_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(l_qte_line_rec.quote_header_id,
724: l_qte_line_rec.quote_line_id);
725: l_price_adj_tbl := aso_utility_pvt.query_price_adj_nonPRG_rows(l_qte_line_rec.quote_header_id,
726: l_qte_line_rec.quote_line_id);
727: l_price_adj_rltship_tbl := aso_utility_pvt.Query_Price_Adj_Rltn_Rows(l_qte_line_rec.quote_line_id);
728: l_price_adj_attr_tbl := aso_utility_pvt.Query_Price_Adj_Attr_Rows(l_price_adj_tbl);
729:
730: FOR i IN 1 .. P_Qte_Line_Tbl.count LOOP
731:

Line 728: l_price_adj_attr_tbl := aso_utility_pvt.Query_Price_Adj_Attr_Rows(l_price_adj_tbl);

724: l_qte_line_rec.quote_line_id);
725: l_price_adj_tbl := aso_utility_pvt.query_price_adj_nonPRG_rows(l_qte_line_rec.quote_header_id,
726: l_qte_line_rec.quote_line_id);
727: l_price_adj_rltship_tbl := aso_utility_pvt.Query_Price_Adj_Rltn_Rows(l_qte_line_rec.quote_line_id);
728: l_price_adj_attr_tbl := aso_utility_pvt.Query_Price_Adj_Attr_Rows(l_price_adj_tbl);
729:
730: FOR i IN 1 .. P_Qte_Line_Tbl.count LOOP
731:
732: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1075: l_srv_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(row.quote_line_id);

1071: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1072: aso_debug_pub.add('Do_Split_Line: Inside service items quote line loop', 1, 'N');
1073: END IF;
1074:
1075: l_srv_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(row.quote_line_id);
1076:
1077: l_srv_ln_Shipment_Tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1078:
1079: l_srv_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(row.quote_line_id);

Line 1077: l_srv_ln_Shipment_Tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);

1073: END IF;
1074:
1075: l_srv_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(row.quote_line_id);
1076:
1077: l_srv_ln_Shipment_Tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1078:
1079: l_srv_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(row.quote_line_id);
1080:
1081: l_srv_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);

Line 1079: l_srv_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(row.quote_line_id);

1075: l_srv_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(row.quote_line_id);
1076:
1077: l_srv_ln_Shipment_Tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1078:
1079: l_srv_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(row.quote_line_id);
1080:
1081: l_srv_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1082:
1083: l_srv_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);

Line 1081: l_srv_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);

1077: l_srv_ln_Shipment_Tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1078:
1079: l_srv_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(row.quote_line_id);
1080:
1081: l_srv_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1082:
1083: l_srv_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1084:
1085: l_srv_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);

Line 1083: l_srv_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);

1079: l_srv_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(row.quote_line_id);
1080:
1081: l_srv_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1082:
1083: l_srv_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1084:
1085: l_srv_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1086:
1087: l_srv_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_nonPRG_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);

Line 1085: l_srv_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);

1081: l_srv_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1082:
1083: l_srv_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1084:
1085: l_srv_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1086:
1087: l_srv_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_nonPRG_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1088: l_srv_price_adj_rltship_tbl := aso_utility_pvt.Query_Price_Adj_Rltn_Rows(row.quote_line_id);
1089: l_srv_price_adj_attr_tbl := aso_utility_pvt.Query_Price_Adj_Attr_Rows(l_srv_price_adj_tbl);

Line 1087: l_srv_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_nonPRG_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);

1083: l_srv_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1084:
1085: l_srv_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1086:
1087: l_srv_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_nonPRG_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1088: l_srv_price_adj_rltship_tbl := aso_utility_pvt.Query_Price_Adj_Rltn_Rows(row.quote_line_id);
1089: l_srv_price_adj_attr_tbl := aso_utility_pvt.Query_Price_Adj_Attr_Rows(l_srv_price_adj_tbl);
1090:
1091: l_to_create_quote_line_rec := l_srv_qte_line_rec;

Line 1088: l_srv_price_adj_rltship_tbl := aso_utility_pvt.Query_Price_Adj_Rltn_Rows(row.quote_line_id);

1084:
1085: l_srv_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1086:
1087: l_srv_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_nonPRG_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1088: l_srv_price_adj_rltship_tbl := aso_utility_pvt.Query_Price_Adj_Rltn_Rows(row.quote_line_id);
1089: l_srv_price_adj_attr_tbl := aso_utility_pvt.Query_Price_Adj_Attr_Rows(l_srv_price_adj_tbl);
1090:
1091: l_to_create_quote_line_rec := l_srv_qte_line_rec;
1092: l_to_create_quote_line_rec.quantity := p_qte_line_tbl(i).quantity;

Line 1089: l_srv_price_adj_attr_tbl := aso_utility_pvt.Query_Price_Adj_Attr_Rows(l_srv_price_adj_tbl);

1085: l_srv_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1086:
1087: l_srv_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_nonPRG_Rows( l_srv_qte_line_rec.quote_header_id, row.quote_line_id);
1088: l_srv_price_adj_rltship_tbl := aso_utility_pvt.Query_Price_Adj_Rltn_Rows(row.quote_line_id);
1089: l_srv_price_adj_attr_tbl := aso_utility_pvt.Query_Price_Adj_Attr_Rows(l_srv_price_adj_tbl);
1090:
1091: l_to_create_quote_line_rec := l_srv_qte_line_rec;
1092: l_to_create_quote_line_rec.quantity := p_qte_line_tbl(i).quantity;
1093: l_to_create_quote_line_rec.operation_code := 'CREATE';

Line 1296: l_orig_payment_tbl := aso_utility_pvt.query_payment_rows(l_qte_line_rec.quote_header_id,

1292:
1293: IF l_qte_line_rec.quantity = 0 THEN
1294: l_qte_line_rec.operation_code := 'DELETE';
1295:
1296: l_orig_payment_tbl := aso_utility_pvt.query_payment_rows(l_qte_line_rec.quote_header_id,
1297: l_qte_line_rec.quote_line_id);
1298:
1299: l_orig_line_deleted := 'Y';
1300:

Line 1417: l_payment_tbl := aso_utility_pvt.query_payment_rows(l_qte_line_rec.quote_header_id,

1413:
1414: IF ( l_orig_line_deleted = 'Y' ) THEN
1415: l_payment_tbl := l_orig_payment_tbl;
1416: ELSE
1417: l_payment_tbl := aso_utility_pvt.query_payment_rows(l_qte_line_rec.quote_header_id,
1418: l_qte_line_rec.quote_line_id);
1419: END IF;
1420:
1421: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1615: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

1611: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1612: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_ERROR', 1, 'N');
1613: END IF;
1614:
1615: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1616: P_PKG_NAME => G_PKG_NAME,
1617: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1618: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1619: X_MSG_COUNT => X_MSG_COUNT,

Line 1618: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

1614:
1615: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1616: P_PKG_NAME => G_PKG_NAME,
1617: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1618: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1619: X_MSG_COUNT => X_MSG_COUNT,
1620: X_MSG_DATA => X_MSG_DATA,
1621: X_RETURN_STATUS => X_RETURN_STATUS
1622: );

Line 1630: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

1626: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1627: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_UNEXPECTED_ERROR', 1, 'N');
1628: END IF;
1629:
1630: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1631: P_PKG_NAME => G_PKG_NAME,
1632: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1633: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1634: X_MSG_COUNT => X_MSG_COUNT,

Line 1633: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

1629:
1630: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1631: P_PKG_NAME => G_PKG_NAME,
1632: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1633: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1634: X_MSG_COUNT => X_MSG_COUNT,
1635: X_MSG_DATA => X_MSG_DATA,
1636: X_RETURN_STATUS => X_RETURN_STATUS
1637: );

Line 1645: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

1641: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1642: aso_debug_pub.add('Do_Split_Line: WHEN OTHERS', 1, 'N');
1643: END IF;
1644:
1645: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1646: P_PKG_NAME => G_PKG_NAME,
1647: P_SQLERRM => SQLERRM,
1648: P_SQLCODE => SQLCODE,
1649: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

Line 1649: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

1645: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1646: P_PKG_NAME => G_PKG_NAME,
1647: P_SQLERRM => SQLERRM,
1648: P_SQLCODE => SQLCODE,
1649: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1650: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1651: X_MSG_COUNT => X_MSG_COUNT,
1652: X_MSG_DATA => X_MSG_DATA,
1653: X_RETURN_STATUS => X_RETURN_STATUS

Line 1650: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

1646: P_PKG_NAME => G_PKG_NAME,
1647: P_SQLERRM => SQLERRM,
1648: P_SQLCODE => SQLCODE,
1649: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1650: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1651: X_MSG_COUNT => X_MSG_COUNT,
1652: X_MSG_DATA => X_MSG_DATA,
1653: X_RETURN_STATUS => X_RETURN_STATUS
1654: );