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

Line 84: l_qte_header_rec := ASO_UTILITY_PVT.query_header_row (p_qte_rec.quote_header_id);

80: aso_debug_pub.add('Check_Tca: p_qte_rec.cust_account_id: '||p_qte_rec.cust_account_id, 1, 'N');
81: END IF;
82:
83: IF (p_application_type_code = 'QUOTING HTML' AND p_operation_code = 'UPDATE') THEN
84: l_qte_header_rec := ASO_UTILITY_PVT.query_header_row (p_qte_rec.quote_header_id);
85:
86: IF p_qte_rec.party_id <> FND_API.G_MISS_NUM OR
87: p_qte_rec.cust_party_id <> FND_API.G_MISS_NUM OR
88: p_qte_rec.cust_account_id <> FND_API.G_MISS_NUM OR

Line 157: l_shipment_rec := ASO_UTILITY_PVT.query_shipment_row (P_Header_Shipment_Tbl(1).shipment_id);

153: P_Header_Shipment_Tbl(1).ship_to_cust_party_id <> FND_API.G_MISS_NUM OR
154: P_Header_Shipment_Tbl(1).ship_to_cust_account_id <> FND_API.G_MISS_NUM OR
155: P_Header_Shipment_Tbl(1).ship_to_party_site_id <> FND_API.G_MISS_NUM THEN
156:
157: l_shipment_rec := ASO_UTILITY_PVT.query_shipment_row (P_Header_Shipment_Tbl(1).shipment_id);
158: IF P_Header_Shipment_Tbl(1).ship_to_cust_party_id = FND_API.G_MISS_NUM THEN
159: P_Header_Shipment_Tbl(1).ship_to_cust_party_id := l_shipment_rec.ship_to_cust_party_id;
160: END IF;
161: IF P_Header_Shipment_Tbl(1).ship_to_cust_account_id = FND_API.G_MISS_NUM THEN

Line 376: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

372: );
373:
374: EXCEPTION
375: WHEN FND_API.G_EXC_ERROR THEN
376: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
377: P_API_NAME => L_API_NAME
378: ,P_PKG_NAME => G_PKG_NAME
379: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
380: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 380: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

376: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
377: P_API_NAME => L_API_NAME
378: ,P_PKG_NAME => G_PKG_NAME
379: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
380: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
381: ,P_SQLCODE => SQLCODE
382: ,P_SQLERRM => SQLERRM
383: ,X_MSG_COUNT => X_MSG_COUNT
384: ,X_MSG_DATA => X_MSG_DATA

Line 388: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

384: ,X_MSG_DATA => X_MSG_DATA
385: ,X_RETURN_STATUS => X_RETURN_STATUS);
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
389: P_API_NAME => L_API_NAME
390: ,P_PKG_NAME => G_PKG_NAME
391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
392: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 392: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

388: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
389: P_API_NAME => L_API_NAME
390: ,P_PKG_NAME => G_PKG_NAME
391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
392: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
393: ,P_SQLCODE => SQLCODE
394: ,P_SQLERRM => SQLERRM
395: ,X_MSG_COUNT => X_MSG_COUNT
396: ,X_MSG_DATA => X_MSG_DATA

Line 400: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

396: ,X_MSG_DATA => X_MSG_DATA
397: ,X_RETURN_STATUS => X_RETURN_STATUS);
398:
399: WHEN OTHERS THEN
400: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
401: P_API_NAME => L_API_NAME
402: ,P_PKG_NAME => G_PKG_NAME
403: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
404: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 403: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

399: WHEN OTHERS THEN
400: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
401: P_API_NAME => L_API_NAME
402: ,P_PKG_NAME => G_PKG_NAME
403: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
404: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
405: ,P_SQLCODE => SQLCODE
406: ,P_SQLERRM => SQLERRM
407: ,X_MSG_COUNT => X_MSG_COUNT

Line 404: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

400: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
401: P_API_NAME => L_API_NAME
402: ,P_PKG_NAME => G_PKG_NAME
403: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
404: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
405: ,P_SQLCODE => SQLCODE
406: ,P_SQLERRM => SQLERRM
407: ,X_MSG_COUNT => X_MSG_COUNT
408: ,X_MSG_DATA => X_MSG_DATA

Line 928: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

924: );
925:
926: EXCEPTION
927: WHEN FND_API.G_EXC_ERROR THEN
928: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
929: P_API_NAME => L_API_NAME
930: ,P_PKG_NAME => G_PKG_NAME
931: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
932: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 932: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

928: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
929: P_API_NAME => L_API_NAME
930: ,P_PKG_NAME => G_PKG_NAME
931: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
932: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
933: ,P_SQLCODE => SQLCODE
934: ,P_SQLERRM => SQLERRM
935: ,X_MSG_COUNT => X_MSG_COUNT
936: ,X_MSG_DATA => X_MSG_DATA

Line 940: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

936: ,X_MSG_DATA => X_MSG_DATA
937: ,X_RETURN_STATUS => X_RETURN_STATUS);
938:
939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
940: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
941: P_API_NAME => L_API_NAME
942: ,P_PKG_NAME => G_PKG_NAME
943: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
944: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 944: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

940: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
941: P_API_NAME => L_API_NAME
942: ,P_PKG_NAME => G_PKG_NAME
943: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
944: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
945: ,P_SQLCODE => SQLCODE
946: ,P_SQLERRM => SQLERRM
947: ,X_MSG_COUNT => X_MSG_COUNT
948: ,X_MSG_DATA => X_MSG_DATA

Line 952: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

948: ,X_MSG_DATA => X_MSG_DATA
949: ,X_RETURN_STATUS => X_RETURN_STATUS);
950:
951: WHEN OTHERS THEN
952: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
953: P_API_NAME => L_API_NAME
954: ,P_PKG_NAME => G_PKG_NAME
955: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
956: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 955: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

951: WHEN OTHERS THEN
952: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
953: P_API_NAME => L_API_NAME
954: ,P_PKG_NAME => G_PKG_NAME
955: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
956: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
957: ,P_SQLCODE => SQLCODE
958: ,P_SQLERRM => SQLERRM
959: ,X_MSG_COUNT => X_MSG_COUNT

Line 956: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

952: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
953: P_API_NAME => L_API_NAME
954: ,P_PKG_NAME => G_PKG_NAME
955: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
956: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
957: ,P_SQLCODE => SQLCODE
958: ,P_SQLERRM => SQLERRM
959: ,X_MSG_COUNT => X_MSG_COUNT
960: ,X_MSG_DATA => X_MSG_DATA

Line 1066: l_qte_line_rec := ASO_UTILITY_PVT.query_qte_line_row (P_Qte_Line_Rec.quote_line_id);

1062: aso_debug_pub.add('line account info:p_qte_line_rec.invoice_to_party_site_id: '||p_qte_line_rec.invoice_to_party_site_id,1,'N');
1063: END IF;
1064:
1065: IF (P_Qte_Line_Rec.operation_code = 'UPDATE' AND P_Application_Type_Code = 'QUOTING HTML') THEN
1066: l_qte_line_rec := ASO_UTILITY_PVT.query_qte_line_row (P_Qte_Line_Rec.quote_line_id);
1067:
1068: IF P_Qte_Line_Rec.invoice_to_party_id <> FND_API.G_MISS_NUM OR
1069: P_Qte_Line_Rec.invoice_to_cust_party_id <> FND_API.G_MISS_NUM OR
1070: P_Qte_Line_Rec.invoice_to_cust_account_id <> FND_API.G_MISS_NUM OR

Line 1113: l_shipment_rec := ASO_UTILITY_PVT.query_shipment_row (P_line_Shipment_Tbl(j).shipment_id);

1109: P_line_Shipment_Tbl(j).ship_to_cust_party_id <> FND_API.G_MISS_NUM OR
1110: P_line_Shipment_Tbl(j).ship_to_cust_account_id <> FND_API.G_MISS_NUM OR
1111: P_line_Shipment_Tbl(j).ship_to_party_site_id <> FND_API.G_MISS_NUM THEN
1112:
1113: l_shipment_rec := ASO_UTILITY_PVT.query_shipment_row (P_line_Shipment_Tbl(j).shipment_id);
1114: IF P_line_Shipment_Tbl(j).ship_to_party_id = FND_API.G_MISS_NUM THEN
1115: P_line_Shipment_Tbl(j).ship_to_party_id := l_shipment_rec.ship_to_party_id;
1116: END IF;
1117: IF P_line_Shipment_Tbl(j).ship_to_cust_party_id = FND_API.G_MISS_NUM THEN

Line 1562: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1558: );
1559:
1560: EXCEPTION
1561: WHEN FND_API.G_EXC_ERROR THEN
1562: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1563: P_API_NAME => L_API_NAME
1564: ,P_PKG_NAME => G_PKG_NAME
1565: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1566: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1566: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1562: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1563: P_API_NAME => L_API_NAME
1564: ,P_PKG_NAME => G_PKG_NAME
1565: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1566: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1567: ,P_SQLCODE => SQLCODE
1568: ,P_SQLERRM => SQLERRM
1569: ,X_MSG_COUNT => X_MSG_COUNT
1570: ,X_MSG_DATA => X_MSG_DATA

Line 1574: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1570: ,X_MSG_DATA => X_MSG_DATA
1571: ,X_RETURN_STATUS => X_RETURN_STATUS);
1572:
1573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1574: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1575: P_API_NAME => L_API_NAME
1576: ,P_PKG_NAME => G_PKG_NAME
1577: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1578: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1578: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1574: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1575: P_API_NAME => L_API_NAME
1576: ,P_PKG_NAME => G_PKG_NAME
1577: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1578: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1579: ,P_SQLCODE => SQLCODE
1580: ,P_SQLERRM => SQLERRM
1581: ,X_MSG_COUNT => X_MSG_COUNT
1582: ,X_MSG_DATA => X_MSG_DATA

Line 1586: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1582: ,X_MSG_DATA => X_MSG_DATA
1583: ,X_RETURN_STATUS => X_RETURN_STATUS);
1584:
1585: WHEN OTHERS THEN
1586: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1587: P_API_NAME => L_API_NAME
1588: ,P_PKG_NAME => G_PKG_NAME
1589: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1590: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1589: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1585: WHEN OTHERS THEN
1586: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1587: P_API_NAME => L_API_NAME
1588: ,P_PKG_NAME => G_PKG_NAME
1589: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1590: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1591: ,P_SQLCODE => SQLCODE
1592: ,P_SQLERRM => SQLERRM
1593: ,X_MSG_COUNT => X_MSG_COUNT

Line 1590: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1586: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1587: P_API_NAME => L_API_NAME
1588: ,P_PKG_NAME => G_PKG_NAME
1589: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1590: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1591: ,P_SQLCODE => SQLCODE
1592: ,P_SQLERRM => SQLERRM
1593: ,X_MSG_COUNT => X_MSG_COUNT
1594: ,X_MSG_DATA => X_MSG_DATA

Line 1883: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1879: );
1880:
1881: EXCEPTION
1882: WHEN FND_API.G_EXC_ERROR THEN
1883: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1884: P_API_NAME => L_API_NAME
1885: ,P_PKG_NAME => G_PKG_NAME
1886: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1887: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1887: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1883: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1884: P_API_NAME => L_API_NAME
1885: ,P_PKG_NAME => G_PKG_NAME
1886: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1887: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1888: ,P_SQLCODE => SQLCODE
1889: ,P_SQLERRM => SQLERRM
1890: ,X_MSG_COUNT => X_MSG_COUNT
1891: ,X_MSG_DATA => X_MSG_DATA

Line 1895: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1891: ,X_MSG_DATA => X_MSG_DATA
1892: ,X_RETURN_STATUS => X_RETURN_STATUS);
1893:
1894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1895: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1896: P_API_NAME => L_API_NAME
1897: ,P_PKG_NAME => G_PKG_NAME
1898: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1899: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1899: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1895: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1896: P_API_NAME => L_API_NAME
1897: ,P_PKG_NAME => G_PKG_NAME
1898: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1899: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1900: ,P_SQLCODE => SQLCODE
1901: ,P_SQLERRM => SQLERRM
1902: ,X_MSG_COUNT => X_MSG_COUNT
1903: ,X_MSG_DATA => X_MSG_DATA

Line 1907: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1903: ,X_MSG_DATA => X_MSG_DATA
1904: ,X_RETURN_STATUS => X_RETURN_STATUS);
1905:
1906: WHEN OTHERS THEN
1907: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1908: P_API_NAME => L_API_NAME
1909: ,P_PKG_NAME => G_PKG_NAME
1910: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1911: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1910: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1906: WHEN OTHERS THEN
1907: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1908: P_API_NAME => L_API_NAME
1909: ,P_PKG_NAME => G_PKG_NAME
1910: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1911: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1912: ,P_SQLCODE => SQLCODE
1913: ,P_SQLERRM => SQLERRM
1914: ,X_MSG_COUNT => X_MSG_COUNT

Line 1911: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1907: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1908: P_API_NAME => L_API_NAME
1909: ,P_PKG_NAME => G_PKG_NAME
1910: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1911: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1912: ,P_SQLCODE => SQLCODE
1913: ,P_SQLERRM => SQLERRM
1914: ,X_MSG_COUNT => X_MSG_COUNT
1915: ,X_MSG_DATA => X_MSG_DATA

Line 2206: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2202: );
2203:
2204: EXCEPTION
2205: WHEN FND_API.G_EXC_ERROR THEN
2206: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2207: P_API_NAME => L_API_NAME
2208: ,P_PKG_NAME => G_PKG_NAME
2209: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2210: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2210: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2206: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2207: P_API_NAME => L_API_NAME
2208: ,P_PKG_NAME => G_PKG_NAME
2209: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2210: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2211: ,P_SQLCODE => SQLCODE
2212: ,P_SQLERRM => SQLERRM
2213: ,X_MSG_COUNT => X_MSG_COUNT
2214: ,X_MSG_DATA => X_MSG_DATA

Line 2218: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2214: ,X_MSG_DATA => X_MSG_DATA
2215: ,X_RETURN_STATUS => X_RETURN_STATUS);
2216:
2217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2218: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2219: P_API_NAME => L_API_NAME
2220: ,P_PKG_NAME => G_PKG_NAME
2221: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2222: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2222: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2218: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2219: P_API_NAME => L_API_NAME
2220: ,P_PKG_NAME => G_PKG_NAME
2221: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2222: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2223: ,P_SQLCODE => SQLCODE
2224: ,P_SQLERRM => SQLERRM
2225: ,X_MSG_COUNT => X_MSG_COUNT
2226: ,X_MSG_DATA => X_MSG_DATA

Line 2230: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2226: ,X_MSG_DATA => X_MSG_DATA
2227: ,X_RETURN_STATUS => X_RETURN_STATUS);
2228:
2229: WHEN OTHERS THEN
2230: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2231: P_API_NAME => L_API_NAME
2232: ,P_PKG_NAME => G_PKG_NAME
2233: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2234: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2233: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

2229: WHEN OTHERS THEN
2230: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2231: P_API_NAME => L_API_NAME
2232: ,P_PKG_NAME => G_PKG_NAME
2233: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2234: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2235: ,P_SQLCODE => SQLCODE
2236: ,P_SQLERRM => SQLERRM
2237: ,X_MSG_COUNT => X_MSG_COUNT

Line 2234: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2230: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2231: P_API_NAME => L_API_NAME
2232: ,P_PKG_NAME => G_PKG_NAME
2233: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2234: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2235: ,P_SQLCODE => SQLCODE
2236: ,P_SQLERRM => SQLERRM
2237: ,X_MSG_COUNT => X_MSG_COUNT
2238: ,X_MSG_DATA => X_MSG_DATA

Line 2383: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2379: );
2380:
2381: EXCEPTION
2382: WHEN FND_API.G_EXC_ERROR THEN
2383: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2384: P_API_NAME => L_API_NAME
2385: ,P_PKG_NAME => G_PKG_NAME
2386: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2387: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2387: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2383: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2384: P_API_NAME => L_API_NAME
2385: ,P_PKG_NAME => G_PKG_NAME
2386: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2387: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2388: ,P_SQLCODE => SQLCODE
2389: ,P_SQLERRM => SQLERRM
2390: ,X_MSG_COUNT => X_MSG_COUNT
2391: ,X_MSG_DATA => X_MSG_DATA

Line 2395: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2391: ,X_MSG_DATA => X_MSG_DATA
2392: ,X_RETURN_STATUS => X_RETURN_STATUS);
2393:
2394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2395: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2396: P_API_NAME => L_API_NAME
2397: ,P_PKG_NAME => G_PKG_NAME
2398: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2399: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2399: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2395: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2396: P_API_NAME => L_API_NAME
2397: ,P_PKG_NAME => G_PKG_NAME
2398: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2399: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2400: ,P_SQLCODE => SQLCODE
2401: ,P_SQLERRM => SQLERRM
2402: ,X_MSG_COUNT => X_MSG_COUNT
2403: ,X_MSG_DATA => X_MSG_DATA

Line 2407: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2403: ,X_MSG_DATA => X_MSG_DATA
2404: ,X_RETURN_STATUS => X_RETURN_STATUS);
2405:
2406: WHEN OTHERS THEN
2407: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2408: P_API_NAME => L_API_NAME
2409: ,P_PKG_NAME => G_PKG_NAME
2410: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2411: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2410: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

2406: WHEN OTHERS THEN
2407: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2408: P_API_NAME => L_API_NAME
2409: ,P_PKG_NAME => G_PKG_NAME
2410: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2411: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2412: ,P_SQLCODE => SQLCODE
2413: ,P_SQLERRM => SQLERRM
2414: ,X_MSG_COUNT => X_MSG_COUNT

Line 2411: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2407: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2408: P_API_NAME => L_API_NAME
2409: ,P_PKG_NAME => G_PKG_NAME
2410: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2411: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2412: ,P_SQLCODE => SQLCODE
2413: ,P_SQLERRM => SQLERRM
2414: ,X_MSG_COUNT => X_MSG_COUNT
2415: ,X_MSG_DATA => X_MSG_DATA

Line 2552: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2548: );
2549:
2550: EXCEPTION
2551: WHEN FND_API.G_EXC_ERROR THEN
2552: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2553: P_API_NAME => L_API_NAME
2554: ,P_PKG_NAME => G_PKG_NAME
2555: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2556: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2556: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2552: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2553: P_API_NAME => L_API_NAME
2554: ,P_PKG_NAME => G_PKG_NAME
2555: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2556: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2557: ,P_SQLCODE => SQLCODE
2558: ,P_SQLERRM => SQLERRM
2559: ,X_MSG_COUNT => X_MSG_COUNT
2560: ,X_MSG_DATA => X_MSG_DATA

Line 2564: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2560: ,X_MSG_DATA => X_MSG_DATA
2561: ,X_RETURN_STATUS => X_RETURN_STATUS);
2562:
2563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2564: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2565: P_API_NAME => L_API_NAME
2566: ,P_PKG_NAME => G_PKG_NAME
2567: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2568: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2568: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2564: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2565: P_API_NAME => L_API_NAME
2566: ,P_PKG_NAME => G_PKG_NAME
2567: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2568: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2569: ,P_SQLCODE => SQLCODE
2570: ,P_SQLERRM => SQLERRM
2571: ,X_MSG_COUNT => X_MSG_COUNT
2572: ,X_MSG_DATA => X_MSG_DATA

Line 2575: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2571: ,X_MSG_COUNT => X_MSG_COUNT
2572: ,X_MSG_DATA => X_MSG_DATA
2573: ,X_RETURN_STATUS => X_RETURN_STATUS);
2574: WHEN OTHERS THEN
2575: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2576: P_API_NAME => L_API_NAME
2577: ,P_PKG_NAME => G_PKG_NAME
2578: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2579: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2578: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

2574: WHEN OTHERS THEN
2575: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2576: P_API_NAME => L_API_NAME
2577: ,P_PKG_NAME => G_PKG_NAME
2578: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2579: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2580: ,P_SQLCODE => SQLCODE
2581: ,P_SQLERRM => SQLERRM
2582: ,X_MSG_COUNT => X_MSG_COUNT

Line 2579: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2575: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2576: P_API_NAME => L_API_NAME
2577: ,P_PKG_NAME => G_PKG_NAME
2578: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2579: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2580: ,P_SQLCODE => SQLCODE
2581: ,P_SQLERRM => SQLERRM
2582: ,X_MSG_COUNT => X_MSG_COUNT
2583: ,X_MSG_DATA => X_MSG_DATA

Line 3204: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3200: );
3201:
3202: EXCEPTION
3203: WHEN FND_API.G_EXC_ERROR THEN
3204: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3205: P_API_NAME => L_API_NAME
3206: ,P_PKG_NAME => G_PKG_NAME
3207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3208: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 3208: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

3204: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3205: P_API_NAME => L_API_NAME
3206: ,P_PKG_NAME => G_PKG_NAME
3207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3208: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3209: ,P_SQLCODE => SQLCODE
3210: ,P_SQLERRM => SQLERRM
3211: ,X_MSG_COUNT => X_MSG_COUNT
3212: ,X_MSG_DATA => X_MSG_DATA

Line 3216: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3212: ,X_MSG_DATA => X_MSG_DATA
3213: ,X_RETURN_STATUS => X_RETURN_STATUS);
3214:
3215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3216: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3217: P_API_NAME => L_API_NAME
3218: ,P_PKG_NAME => G_PKG_NAME
3219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3220: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 3220: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

3216: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3217: P_API_NAME => L_API_NAME
3218: ,P_PKG_NAME => G_PKG_NAME
3219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3220: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3221: ,P_SQLCODE => SQLCODE
3222: ,P_SQLERRM => SQLERRM
3223: ,X_MSG_COUNT => X_MSG_COUNT
3224: ,X_MSG_DATA => X_MSG_DATA

Line 3228: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3224: ,X_MSG_DATA => X_MSG_DATA
3225: ,X_RETURN_STATUS => X_RETURN_STATUS);
3226:
3227: WHEN OTHERS THEN
3228: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3229: P_API_NAME => L_API_NAME
3230: ,P_PKG_NAME => G_PKG_NAME
3231: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3232: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 3231: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

3227: WHEN OTHERS THEN
3228: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3229: P_API_NAME => L_API_NAME
3230: ,P_PKG_NAME => G_PKG_NAME
3231: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3232: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3233: ,P_SQLCODE => SQLCODE
3234: ,P_SQLERRM => SQLERRM
3235: ,X_MSG_COUNT => X_MSG_COUNT

Line 3232: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

3228: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3229: P_API_NAME => L_API_NAME
3230: ,P_PKG_NAME => G_PKG_NAME
3231: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3232: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3233: ,P_SQLCODE => SQLCODE
3234: ,P_SQLERRM => SQLERRM
3235: ,X_MSG_COUNT => X_MSG_COUNT
3236: ,X_MSG_DATA => X_MSG_DATA

Line 3652: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3648: );
3649:
3650: EXCEPTION
3651: WHEN FND_API.G_EXC_ERROR THEN
3652: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3653: P_API_NAME => L_API_NAME
3654: ,P_PKG_NAME => G_PKG_NAME
3655: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3656: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 3656: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

3652: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3653: P_API_NAME => L_API_NAME
3654: ,P_PKG_NAME => G_PKG_NAME
3655: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3656: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3657: ,P_SQLCODE => SQLCODE
3658: ,P_SQLERRM => SQLERRM
3659: ,X_MSG_COUNT => X_MSG_COUNT
3660: ,X_MSG_DATA => X_MSG_DATA

Line 3664: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3660: ,X_MSG_DATA => X_MSG_DATA
3661: ,X_RETURN_STATUS => X_RETURN_STATUS);
3662:
3663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3664: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3665: P_API_NAME => L_API_NAME
3666: ,P_PKG_NAME => G_PKG_NAME
3667: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3668: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 3668: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

3664: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3665: P_API_NAME => L_API_NAME
3666: ,P_PKG_NAME => G_PKG_NAME
3667: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3668: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3669: ,P_SQLCODE => SQLCODE
3670: ,P_SQLERRM => SQLERRM
3671: ,X_MSG_COUNT => X_MSG_COUNT
3672: ,X_MSG_DATA => X_MSG_DATA

Line 3676: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3672: ,X_MSG_DATA => X_MSG_DATA
3673: ,X_RETURN_STATUS => X_RETURN_STATUS);
3674:
3675: WHEN OTHERS THEN
3676: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3677: P_API_NAME => L_API_NAME
3678: ,P_PKG_NAME => G_PKG_NAME
3679: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3680: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 3679: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

3675: WHEN OTHERS THEN
3676: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3677: P_API_NAME => L_API_NAME
3678: ,P_PKG_NAME => G_PKG_NAME
3679: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3680: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3681: ,P_SQLCODE => SQLCODE
3682: ,P_SQLERRM => SQLERRM
3683: ,X_MSG_COUNT => X_MSG_COUNT

Line 3680: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

3676: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3677: P_API_NAME => L_API_NAME
3678: ,P_PKG_NAME => G_PKG_NAME
3679: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3680: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3681: ,P_SQLCODE => SQLCODE
3682: ,P_SQLERRM => SQLERRM
3683: ,X_MSG_COUNT => X_MSG_COUNT
3684: ,X_MSG_DATA => X_MSG_DATA