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

APPS.ASO_PRICING_FLOWS_PVT dependencies on ASO_UTILITY_PVT

Line 196: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Pricing_Line_Rows(p_qte_header_rec.quote_header_id);

192: else
193: l_prc_control_rec.PRG_REPRICE_MODE := 'A';
194: end if;
195:
196: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Pricing_Line_Rows(p_qte_header_rec.quote_header_id);
197:
198: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
199: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_tbl.count :'||NVL(l_qte_line_tbl.count,0),1,'Y');
200: l_pricing_end_time := dbms_utility.get_time;

Line 225: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_id);

221: ||l_qte_line_tbl(i).pricing_line_type_indicator,1,'Y');
222: END IF;
223:
224: l_qte_line_id := l_qte_line_tbl(i).quote_line_id;
225: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_id);
226:
227: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
228: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Defaulting Hdr Lvl Price List and Currency..',1,'Y');
229: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: p_qte_header_rec.currency_code :'

Line 271: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows

267:
268: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
269: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Shipment_Rows..',1,'Y');
270: END IF;
271: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows
272: (p_qte_header_rec.quote_header_id, l_QTE_LINE_ID);
273: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
274: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_shipment_tbl.count :'
275: ||NVL(l_shipment_tbl.count,0),1,'Y');

Line 1200: l_qte_line_tbl(l_qte_line_tbl.COUNT+1) := ASO_UTILITY_PVT.Query_Qte_Line_Row(l_service_ref_line_id);

1196: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1197: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Parent Quote Line NOT exists in p_qte_line_tbl. ',1,'Y');
1198: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_service_ref_line_id_tbl('||l_service_ref_line_id||'). :'||NVL(to_char(l_service_ref_line_id_tbl(l_service_ref_line_id)),'null'),1,'Y');
1199: END IF;
1200: l_qte_line_tbl(l_qte_line_tbl.COUNT+1) := ASO_UTILITY_PVT.Query_Qte_Line_Row(l_service_ref_line_id);
1201: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1202: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Quote Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
1203: END IF;
1204: END IF;-- Parent line already exists.

Line 1250: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_tbl(i).quote_line_id);

1246: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1247: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: One or more records exists in l_qte_line_tbl...',1,'Y');
1248: END IF;
1249: --changes for bug 4353654
1250: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_tbl(i).quote_line_id);
1251: l_qte_line_tbl(l_qte_line_tbl.COUNT+1) := l_qte_line_rec;
1252: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1253: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After adding a new record in l_qte_line_tbl...',1,'Y');
1254: END IF;

Line 1259: l_qte_line_tbl(1) := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_tbl(i).quote_line_id);

1255: ELSE
1256: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1257: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: No record exists in l_qte_line_tbl...',1,'Y');
1258: END IF;
1259: l_qte_line_tbl(1) := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_tbl(i).quote_line_id);
1260: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1261: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After adding a new record in l_qte_line_tbl...',1,'Y');
1262: END IF;
1263: END IF; -- l_qte_line_tbl.exists.

Line 1295: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_id);

1291: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Line_Dtl_Rows...',1,'Y');
1292: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_tbl('||i||').quote_line_id :'||NVL(l_qte_line_tbl(i).quote_line_id,0),1,'Y');
1293: END IF;
1294: l_qte_line_id := l_qte_line_tbl(i).quote_line_id;
1295: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_id);
1296:
1297:
1298: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1299: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Defaulting Hdr Lvl Price List and Currency..',1,'Y');

Line 1329: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows

1325:
1326: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1327: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Shipment_Rows..',1,'Y');
1328: END IF;
1329: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows
1330: (p_qte_header_rec.quote_header_id, l_QTE_LINE_ID);
1331: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1332: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_shipment_tbl.count :'||NVL(l_shipment_tbl.count,0),1,'Y');
1333: END IF;

Line 1614: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1610: WHEN FND_API.G_EXC_ERROR THEN
1611: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1612: aso_debug_pub.add('after inside EXCEPTION return status'||x_return_status, 1, 'Y');
1613: END IF;
1614: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1615: 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_PVT

Line 1618: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1614: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1615: 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_PVT
1619: ,P_SQLCODE => SQLCODE
1620: ,P_SQLERRM => SQLERRM
1621: ,X_MSG_COUNT => X_MSG_COUNT
1622: ,X_MSG_DATA => X_MSG_DATA

Line 1626: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1622: ,X_MSG_DATA => X_MSG_DATA
1623: ,X_RETURN_STATUS => X_RETURN_STATUS);
1624:
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1627: P_API_NAME => L_API_NAME
1628: ,P_PKG_NAME => G_PKG_NAME
1629: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1630: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1630: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1626: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1627: P_API_NAME => L_API_NAME
1628: ,P_PKG_NAME => G_PKG_NAME
1629: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1630: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1631: ,P_SQLCODE => SQLCODE
1632: ,P_SQLERRM => SQLERRM
1633: ,X_MSG_COUNT => X_MSG_COUNT
1634: ,X_MSG_DATA => X_MSG_DATA

Line 1638: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1634: ,X_MSG_DATA => X_MSG_DATA
1635: ,X_RETURN_STATUS => X_RETURN_STATUS);
1636:
1637: WHEN OTHERS THEN
1638: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1639: P_API_NAME => L_API_NAME
1640: ,P_PKG_NAME => G_PKG_NAME
1641: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1642: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1641: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1637: WHEN OTHERS THEN
1638: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1639: P_API_NAME => L_API_NAME
1640: ,P_PKG_NAME => G_PKG_NAME
1641: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1642: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1643: ,P_SQLCODE => SQLCODE
1644: ,P_SQLERRM => SQLERRM
1645: ,X_MSG_COUNT => X_MSG_COUNT

Line 1642: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1638: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1639: P_API_NAME => L_API_NAME
1640: ,P_PKG_NAME => G_PKG_NAME
1641: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1642: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1643: ,P_SQLCODE => SQLCODE
1644: ,P_SQLERRM => SQLERRM
1645: ,X_MSG_COUNT => X_MSG_COUNT
1646: ,X_MSG_DATA => X_MSG_DATA

Line 1872: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Pricing_Line_Rows(P_Qte_Header_Id => p_qte_header_rec.quote_header_id,

1868: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1869: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Pricing_Line_Rows...',1,'Y');
1870: END IF;
1871:
1872: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Pricing_Line_Rows(P_Qte_Header_Id => p_qte_header_rec.quote_header_id,
1873: P_change_line_flag => FND_API.G_TRUE);
1874: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1875: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After Query_Lines_lineIdlocation l_qte_line_tbl.count :'
1876: ||NVL(l_qte_line_tbl.count,0),1,'Y');

Line 1924: ls_qte_line_tbl:=ASO_UTILITY_PVT.Query_Pricing_Line_Row(P_Qte_Header_Id => p_qte_header_rec.quote_header_id, p_qte_line_id=>p_qte_line_tbl(i).quote_line_id);

1920: If (lx_order_status_rec.all_lines_flag = 'N') AND (lx_order_status_rec.changed_lines_flag = 'Y') then
1921: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1922: aso_debug_pub.add(' rassharm ASO_PRICING_FLOWS_PVT:service ITEM line id :'||p_qte_line_tbl(i).quote_line_id,1,'Y');
1923: end if;
1924: ls_qte_line_tbl:=ASO_UTILITY_PVT.Query_Pricing_Line_Row(P_Qte_Header_Id => p_qte_header_rec.quote_header_id, p_qte_line_id=>p_qte_line_tbl(i).quote_line_id);
1925: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1926: aso_debug_pub.add(' ASO_PRICING_FLOWS_PVT:ls_qte_line_tbl count :'||ls_qte_line_tbl.count,1,'Y');
1927: end if;
1928: for ls in 1..ls_qte_line_tbl.count loop

Line 2031: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);

2027: END IF;
2028: End if;
2029: END IF;--l_qte_line_tbl(i).pricing_line_type_indicator = 'F'
2030:
2031: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);
2032: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2033: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_dtl_tbl.count :'
2034: ||NVL(l_qte_line_dtl_tbl.count,0),1,'Y');
2035: END IF;

Line 2045: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows

2041:
2042: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2043: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Shipment_Rows..',1,'Y');
2044: END IF;
2045: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows
2046: (p_qte_header_rec.quote_header_id, l_qte_line_tbl(i).quote_line_id);
2047: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2048: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_shipment_tbl.count :'
2049: ||NVL(l_shipment_tbl.count,0),1,'Y');

Line 2769: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Pricing_Line_Rows(p_qte_header_rec.quote_header_id);

2765: aso_debug_pub.add('************************ LINE LEVEL BEGINS *******************************',1,'Y');
2766: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of ASO UTL PVT Query_Pricing_Line_Rows...',1,'Y');
2767: END IF;
2768:
2769: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Pricing_Line_Rows(p_qte_header_rec.quote_header_id);
2770: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2771: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_tbl.count :'||NVL(l_qte_line_tbl.count,0),1,'Y');
2772: l_pricing_end_time := dbms_utility.get_time;
2773: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);

Line 2795: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_id);

2791: ||l_qte_line_tbl(i).pricing_line_type_indicator,1,'Y');
2792: END IF;
2793:
2794: l_qte_line_id := l_qte_line_tbl(i).quote_line_id;
2795: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_id);
2796:
2797: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2798: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Defaulting Hdr Lvl Price List and Currency..',1,'Y');
2799: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: p_qte_header_rec.currency_code :'

Line 2840: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows

2836:
2837: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2838: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Shipment_Rows..',1,'Y');
2839: END IF;
2840: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows
2841: (p_qte_header_rec.quote_header_id, l_QTE_LINE_ID);
2842: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2843: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_shipment_tbl.count :'
2844: ||NVL(l_shipment_tbl.count,0),1,'Y');