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 1416: l_payment_tbl := aso_utility_pvt.query_payment_rows(l_qte_line_rec.quote_header_id,

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

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

1579: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1580: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_ERROR', 1, 'N');
1581: END IF;
1582:
1583: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1584: P_PKG_NAME => G_PKG_NAME,
1585: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1586: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1587: X_MSG_COUNT => X_MSG_COUNT,

Line 1586: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

1582:
1583: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1584: P_PKG_NAME => G_PKG_NAME,
1585: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1586: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1587: X_MSG_COUNT => X_MSG_COUNT,
1588: X_MSG_DATA => X_MSG_DATA,
1589: X_RETURN_STATUS => X_RETURN_STATUS
1590: );

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

1594: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1595: aso_debug_pub.add('Do_Split_Line: WHEN FND_API.G_EXC_UNEXPECTED_ERROR', 1, 'N');
1596: END IF;
1597:
1598: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1599: P_PKG_NAME => G_PKG_NAME,
1600: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1601: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1602: X_MSG_COUNT => X_MSG_COUNT,

Line 1601: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

1597:
1598: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1599: P_PKG_NAME => G_PKG_NAME,
1600: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1601: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
1602: X_MSG_COUNT => X_MSG_COUNT,
1603: X_MSG_DATA => X_MSG_DATA,
1604: X_RETURN_STATUS => X_RETURN_STATUS
1605: );

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

1609: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1610: aso_debug_pub.add('Do_Split_Line: WHEN OTHERS', 1, 'N');
1611: END IF;
1612:
1613: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1614: P_PKG_NAME => G_PKG_NAME,
1615: P_SQLERRM => SQLERRM,
1616: P_SQLCODE => SQLCODE,
1617: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

Line 1617: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

1613: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
1614: P_PKG_NAME => G_PKG_NAME,
1615: P_SQLERRM => SQLERRM,
1616: P_SQLCODE => SQLCODE,
1617: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
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

Line 1618: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

1614: P_PKG_NAME => G_PKG_NAME,
1615: P_SQLERRM => SQLERRM,
1616: P_SQLCODE => SQLCODE,
1617: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
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: );