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 1875: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1871: );
1872:
1873: EXCEPTION
1874: WHEN FND_API.G_EXC_ERROR THEN
1875: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1876: P_API_NAME => L_API_NAME
1877: ,P_PKG_NAME => G_PKG_NAME
1878: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1879: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1879: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1875: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1876: P_API_NAME => L_API_NAME
1877: ,P_PKG_NAME => G_PKG_NAME
1878: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1879: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1880: ,P_SQLCODE => SQLCODE
1881: ,P_SQLERRM => SQLERRM
1882: ,X_MSG_COUNT => X_MSG_COUNT
1883: ,X_MSG_DATA => X_MSG_DATA

Line 1887: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1883: ,X_MSG_DATA => X_MSG_DATA
1884: ,X_RETURN_STATUS => X_RETURN_STATUS);
1885:
1886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1887: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1888: P_API_NAME => L_API_NAME
1889: ,P_PKG_NAME => G_PKG_NAME
1890: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1891: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1891: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1887: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1888: P_API_NAME => L_API_NAME
1889: ,P_PKG_NAME => G_PKG_NAME
1890: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1891: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1892: ,P_SQLCODE => SQLCODE
1893: ,P_SQLERRM => SQLERRM
1894: ,X_MSG_COUNT => X_MSG_COUNT
1895: ,X_MSG_DATA => X_MSG_DATA

Line 1899: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1895: ,X_MSG_DATA => X_MSG_DATA
1896: ,X_RETURN_STATUS => X_RETURN_STATUS);
1897:
1898: WHEN OTHERS THEN
1899: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1900: P_API_NAME => L_API_NAME
1901: ,P_PKG_NAME => G_PKG_NAME
1902: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1903: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1902: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1898: WHEN OTHERS THEN
1899: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1900: P_API_NAME => L_API_NAME
1901: ,P_PKG_NAME => G_PKG_NAME
1902: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1903: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1904: ,P_SQLCODE => SQLCODE
1905: ,P_SQLERRM => SQLERRM
1906: ,X_MSG_COUNT => X_MSG_COUNT

Line 1903: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1899: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1900: P_API_NAME => L_API_NAME
1901: ,P_PKG_NAME => G_PKG_NAME
1902: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1903: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1904: ,P_SQLCODE => SQLCODE
1905: ,P_SQLERRM => SQLERRM
1906: ,X_MSG_COUNT => X_MSG_COUNT
1907: ,X_MSG_DATA => X_MSG_DATA

Line 2198: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2194: );
2195:
2196: EXCEPTION
2197: WHEN FND_API.G_EXC_ERROR THEN
2198: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2199: P_API_NAME => L_API_NAME
2200: ,P_PKG_NAME => G_PKG_NAME
2201: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2202: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2202: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2198: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2199: P_API_NAME => L_API_NAME
2200: ,P_PKG_NAME => G_PKG_NAME
2201: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2202: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2203: ,P_SQLCODE => SQLCODE
2204: ,P_SQLERRM => SQLERRM
2205: ,X_MSG_COUNT => X_MSG_COUNT
2206: ,X_MSG_DATA => X_MSG_DATA

Line 2210: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2206: ,X_MSG_DATA => X_MSG_DATA
2207: ,X_RETURN_STATUS => X_RETURN_STATUS);
2208:
2209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2210: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2211: P_API_NAME => L_API_NAME
2212: ,P_PKG_NAME => G_PKG_NAME
2213: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2214: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2214: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2210: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2211: P_API_NAME => L_API_NAME
2212: ,P_PKG_NAME => G_PKG_NAME
2213: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2214: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2215: ,P_SQLCODE => SQLCODE
2216: ,P_SQLERRM => SQLERRM
2217: ,X_MSG_COUNT => X_MSG_COUNT
2218: ,X_MSG_DATA => X_MSG_DATA

Line 2222: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2218: ,X_MSG_DATA => X_MSG_DATA
2219: ,X_RETURN_STATUS => X_RETURN_STATUS);
2220:
2221: WHEN OTHERS THEN
2222: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2223: P_API_NAME => L_API_NAME
2224: ,P_PKG_NAME => G_PKG_NAME
2225: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2226: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2225: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

2221: WHEN OTHERS THEN
2222: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2223: P_API_NAME => L_API_NAME
2224: ,P_PKG_NAME => G_PKG_NAME
2225: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2226: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2227: ,P_SQLCODE => SQLCODE
2228: ,P_SQLERRM => SQLERRM
2229: ,X_MSG_COUNT => X_MSG_COUNT

Line 2226: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2222: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2223: P_API_NAME => L_API_NAME
2224: ,P_PKG_NAME => G_PKG_NAME
2225: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2226: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2227: ,P_SQLCODE => SQLCODE
2228: ,P_SQLERRM => SQLERRM
2229: ,X_MSG_COUNT => X_MSG_COUNT
2230: ,X_MSG_DATA => X_MSG_DATA

Line 2349: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2345: );
2346:
2347: EXCEPTION
2348: WHEN FND_API.G_EXC_ERROR THEN
2349: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2350: P_API_NAME => L_API_NAME
2351: ,P_PKG_NAME => G_PKG_NAME
2352: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2353: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2353: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2349: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2350: P_API_NAME => L_API_NAME
2351: ,P_PKG_NAME => G_PKG_NAME
2352: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2353: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2354: ,P_SQLCODE => SQLCODE
2355: ,P_SQLERRM => SQLERRM
2356: ,X_MSG_COUNT => X_MSG_COUNT
2357: ,X_MSG_DATA => X_MSG_DATA

Line 2361: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2357: ,X_MSG_DATA => X_MSG_DATA
2358: ,X_RETURN_STATUS => X_RETURN_STATUS);
2359:
2360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2361: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2362: P_API_NAME => L_API_NAME
2363: ,P_PKG_NAME => G_PKG_NAME
2364: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2365: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2365: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2361: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2362: P_API_NAME => L_API_NAME
2363: ,P_PKG_NAME => G_PKG_NAME
2364: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2365: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2366: ,P_SQLCODE => SQLCODE
2367: ,P_SQLERRM => SQLERRM
2368: ,X_MSG_COUNT => X_MSG_COUNT
2369: ,X_MSG_DATA => X_MSG_DATA

Line 2373: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2369: ,X_MSG_DATA => X_MSG_DATA
2370: ,X_RETURN_STATUS => X_RETURN_STATUS);
2371:
2372: WHEN OTHERS THEN
2373: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2374: P_API_NAME => L_API_NAME
2375: ,P_PKG_NAME => G_PKG_NAME
2376: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2377: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2376: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

2372: WHEN OTHERS THEN
2373: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2374: P_API_NAME => L_API_NAME
2375: ,P_PKG_NAME => G_PKG_NAME
2376: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2377: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2378: ,P_SQLCODE => SQLCODE
2379: ,P_SQLERRM => SQLERRM
2380: ,X_MSG_COUNT => X_MSG_COUNT

Line 2377: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2373: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2374: P_API_NAME => L_API_NAME
2375: ,P_PKG_NAME => G_PKG_NAME
2376: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2377: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2378: ,P_SQLCODE => SQLCODE
2379: ,P_SQLERRM => SQLERRM
2380: ,X_MSG_COUNT => X_MSG_COUNT
2381: ,X_MSG_DATA => X_MSG_DATA

Line 2518: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2514: );
2515:
2516: EXCEPTION
2517: WHEN FND_API.G_EXC_ERROR THEN
2518: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2519: P_API_NAME => L_API_NAME
2520: ,P_PKG_NAME => G_PKG_NAME
2521: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2522: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2522: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2518: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2519: P_API_NAME => L_API_NAME
2520: ,P_PKG_NAME => G_PKG_NAME
2521: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2522: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2523: ,P_SQLCODE => SQLCODE
2524: ,P_SQLERRM => SQLERRM
2525: ,X_MSG_COUNT => X_MSG_COUNT
2526: ,X_MSG_DATA => X_MSG_DATA

Line 2530: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2526: ,X_MSG_DATA => X_MSG_DATA
2527: ,X_RETURN_STATUS => X_RETURN_STATUS);
2528:
2529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2530: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2531: P_API_NAME => L_API_NAME
2532: ,P_PKG_NAME => G_PKG_NAME
2533: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2534: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2534: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2530: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2531: P_API_NAME => L_API_NAME
2532: ,P_PKG_NAME => G_PKG_NAME
2533: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2534: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2535: ,P_SQLCODE => SQLCODE
2536: ,P_SQLERRM => SQLERRM
2537: ,X_MSG_COUNT => X_MSG_COUNT
2538: ,X_MSG_DATA => X_MSG_DATA

Line 2541: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

2537: ,X_MSG_COUNT => X_MSG_COUNT
2538: ,X_MSG_DATA => X_MSG_DATA
2539: ,X_RETURN_STATUS => X_RETURN_STATUS);
2540: WHEN OTHERS THEN
2541: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2542: P_API_NAME => L_API_NAME
2543: ,P_PKG_NAME => G_PKG_NAME
2544: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2545: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2544: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

2540: WHEN OTHERS THEN
2541: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2542: P_API_NAME => L_API_NAME
2543: ,P_PKG_NAME => G_PKG_NAME
2544: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2545: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2546: ,P_SQLCODE => SQLCODE
2547: ,P_SQLERRM => SQLERRM
2548: ,X_MSG_COUNT => X_MSG_COUNT

Line 2545: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2541: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2542: P_API_NAME => L_API_NAME
2543: ,P_PKG_NAME => G_PKG_NAME
2544: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2545: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2546: ,P_SQLCODE => SQLCODE
2547: ,P_SQLERRM => SQLERRM
2548: ,X_MSG_COUNT => X_MSG_COUNT
2549: ,X_MSG_DATA => X_MSG_DATA

Line 3156: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3152: );
3153:
3154: EXCEPTION
3155: WHEN FND_API.G_EXC_ERROR THEN
3156: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3157: P_API_NAME => L_API_NAME
3158: ,P_PKG_NAME => G_PKG_NAME
3159: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3160: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 3160: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

3156: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3157: P_API_NAME => L_API_NAME
3158: ,P_PKG_NAME => G_PKG_NAME
3159: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3160: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3161: ,P_SQLCODE => SQLCODE
3162: ,P_SQLERRM => SQLERRM
3163: ,X_MSG_COUNT => X_MSG_COUNT
3164: ,X_MSG_DATA => X_MSG_DATA

Line 3168: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3164: ,X_MSG_DATA => X_MSG_DATA
3165: ,X_RETURN_STATUS => X_RETURN_STATUS);
3166:
3167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3168: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3169: P_API_NAME => L_API_NAME
3170: ,P_PKG_NAME => G_PKG_NAME
3171: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3172: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 3172: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

3168: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3169: P_API_NAME => L_API_NAME
3170: ,P_PKG_NAME => G_PKG_NAME
3171: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3172: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3173: ,P_SQLCODE => SQLCODE
3174: ,P_SQLERRM => SQLERRM
3175: ,X_MSG_COUNT => X_MSG_COUNT
3176: ,X_MSG_DATA => X_MSG_DATA

Line 3180: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3176: ,X_MSG_DATA => X_MSG_DATA
3177: ,X_RETURN_STATUS => X_RETURN_STATUS);
3178:
3179: WHEN OTHERS THEN
3180: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3181: P_API_NAME => L_API_NAME
3182: ,P_PKG_NAME => G_PKG_NAME
3183: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3184: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 3183: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

3179: WHEN OTHERS THEN
3180: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3181: P_API_NAME => L_API_NAME
3182: ,P_PKG_NAME => G_PKG_NAME
3183: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3184: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3185: ,P_SQLCODE => SQLCODE
3186: ,P_SQLERRM => SQLERRM
3187: ,X_MSG_COUNT => X_MSG_COUNT

Line 3184: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

3180: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3181: P_API_NAME => L_API_NAME
3182: ,P_PKG_NAME => G_PKG_NAME
3183: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3184: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
3185: ,P_SQLCODE => SQLCODE
3186: ,P_SQLERRM => SQLERRM
3187: ,X_MSG_COUNT => X_MSG_COUNT
3188: ,X_MSG_DATA => X_MSG_DATA

Line 3604: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3600: );
3601:
3602: EXCEPTION
3603: WHEN FND_API.G_EXC_ERROR THEN
3604: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3605: P_API_NAME => L_API_NAME
3606: ,P_PKG_NAME => G_PKG_NAME
3607: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3608: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 3608: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

3604: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3605: P_API_NAME => L_API_NAME
3606: ,P_PKG_NAME => G_PKG_NAME
3607: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3608: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3609: ,P_SQLCODE => SQLCODE
3610: ,P_SQLERRM => SQLERRM
3611: ,X_MSG_COUNT => X_MSG_COUNT
3612: ,X_MSG_DATA => X_MSG_DATA

Line 3616: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3612: ,X_MSG_DATA => X_MSG_DATA
3613: ,X_RETURN_STATUS => X_RETURN_STATUS);
3614:
3615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3616: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3617: P_API_NAME => L_API_NAME
3618: ,P_PKG_NAME => G_PKG_NAME
3619: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3620: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 3620: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

3616: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3617: P_API_NAME => L_API_NAME
3618: ,P_PKG_NAME => G_PKG_NAME
3619: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3620: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3621: ,P_SQLCODE => SQLCODE
3622: ,P_SQLERRM => SQLERRM
3623: ,X_MSG_COUNT => X_MSG_COUNT
3624: ,X_MSG_DATA => X_MSG_DATA

Line 3628: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3624: ,X_MSG_DATA => X_MSG_DATA
3625: ,X_RETURN_STATUS => X_RETURN_STATUS);
3626:
3627: WHEN OTHERS THEN
3628: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3629: P_API_NAME => L_API_NAME
3630: ,P_PKG_NAME => G_PKG_NAME
3631: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3632: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 3631: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

3627: WHEN OTHERS THEN
3628: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3629: P_API_NAME => L_API_NAME
3630: ,P_PKG_NAME => G_PKG_NAME
3631: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3632: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3633: ,P_SQLCODE => SQLCODE
3634: ,P_SQLERRM => SQLERRM
3635: ,X_MSG_COUNT => X_MSG_COUNT

Line 3632: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

3628: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3629: P_API_NAME => L_API_NAME
3630: ,P_PKG_NAME => G_PKG_NAME
3631: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3632: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3633: ,P_SQLCODE => SQLCODE
3634: ,P_SQLERRM => SQLERRM
3635: ,X_MSG_COUNT => X_MSG_COUNT
3636: ,X_MSG_DATA => X_MSG_DATA