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 1057: l_qte_line_tbl(l_qte_line_tbl.COUNT+1) := ASO_UTILITY_PVT.Query_Qte_Line_Row(l_service_ref_line_id);

1053: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1054: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Parent Quote Line NOT exists in p_qte_line_tbl. ',1,'Y');
1055: 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');
1056: END IF;
1057: l_qte_line_tbl(l_qte_line_tbl.COUNT+1) := ASO_UTILITY_PVT.Query_Qte_Line_Row(l_service_ref_line_id);
1058: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1059: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Quote Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
1060: END IF;
1061: END IF;-- Parent line already exists.

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

1068: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1069: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: One or more records exists in l_qte_line_tbl...',1,'Y');
1070: END IF;
1071: --changes for bug 4353654
1072: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_tbl(i).quote_line_id);
1073: l_qte_line_tbl(l_qte_line_tbl.COUNT+1) := l_qte_line_rec;
1074: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1075: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After adding a new record in l_qte_line_tbl...',1,'Y');
1076: END IF;

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

1077: ELSE
1078: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1079: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: No record exists in l_qte_line_tbl...',1,'Y');
1080: END IF;
1081: l_qte_line_tbl(1) := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_tbl(i).quote_line_id);
1082: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1083: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After adding a new record in l_qte_line_tbl...',1,'Y');
1084: END IF;
1085: END IF; -- l_qte_line_tbl.exists.

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

1113: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Line_Dtl_Rows...',1,'Y');
1114: 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');
1115: END IF;
1116: l_qte_line_id := l_qte_line_tbl(i).quote_line_id;
1117: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_id);
1118:
1119:
1120: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1121: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Defaulting Hdr Lvl Price List and Currency..',1,'Y');

Line 1151: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows

1147:
1148: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1149: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Shipment_Rows..',1,'Y');
1150: END IF;
1151: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows
1152: (p_qte_header_rec.quote_header_id, l_QTE_LINE_ID);
1153: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1154: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_shipment_tbl.count :'||NVL(l_shipment_tbl.count,0),1,'Y');
1155: END IF;

Line 1436: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1432: WHEN FND_API.G_EXC_ERROR THEN
1433: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1434: aso_debug_pub.add('after inside EXCEPTION return status'||x_return_status, 1, 'Y');
1435: END IF;
1436: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1437: P_API_NAME => L_API_NAME
1438: ,P_PKG_NAME => G_PKG_NAME
1439: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1440: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1440: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1436: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1437: P_API_NAME => L_API_NAME
1438: ,P_PKG_NAME => G_PKG_NAME
1439: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1440: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1441: ,P_SQLCODE => SQLCODE
1442: ,P_SQLERRM => SQLERRM
1443: ,X_MSG_COUNT => X_MSG_COUNT
1444: ,X_MSG_DATA => X_MSG_DATA

Line 1448: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1444: ,X_MSG_DATA => X_MSG_DATA
1445: ,X_RETURN_STATUS => X_RETURN_STATUS);
1446:
1447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1448: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1449: P_API_NAME => L_API_NAME
1450: ,P_PKG_NAME => G_PKG_NAME
1451: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1452: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1452: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1448: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1449: P_API_NAME => L_API_NAME
1450: ,P_PKG_NAME => G_PKG_NAME
1451: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1452: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1453: ,P_SQLCODE => SQLCODE
1454: ,P_SQLERRM => SQLERRM
1455: ,X_MSG_COUNT => X_MSG_COUNT
1456: ,X_MSG_DATA => X_MSG_DATA

Line 1460: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1456: ,X_MSG_DATA => X_MSG_DATA
1457: ,X_RETURN_STATUS => X_RETURN_STATUS);
1458:
1459: WHEN OTHERS THEN
1460: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1461: P_API_NAME => L_API_NAME
1462: ,P_PKG_NAME => G_PKG_NAME
1463: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1464: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1463: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1459: WHEN OTHERS THEN
1460: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1461: P_API_NAME => L_API_NAME
1462: ,P_PKG_NAME => G_PKG_NAME
1463: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1464: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1465: ,P_SQLCODE => SQLCODE
1466: ,P_SQLERRM => SQLERRM
1467: ,X_MSG_COUNT => X_MSG_COUNT

Line 1464: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1460: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1461: P_API_NAME => L_API_NAME
1462: ,P_PKG_NAME => G_PKG_NAME
1463: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1464: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1465: ,P_SQLCODE => SQLCODE
1466: ,P_SQLERRM => SQLERRM
1467: ,X_MSG_COUNT => X_MSG_COUNT
1468: ,X_MSG_DATA => X_MSG_DATA

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

1684: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1685: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Pricing_Line_Rows...',1,'Y');
1686: END IF;
1687:
1688: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Pricing_Line_Rows(P_Qte_Header_Id => p_qte_header_rec.quote_header_id,
1689: P_change_line_flag => FND_API.G_TRUE);
1690: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1691: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After Query_Lines_lineIdlocation l_qte_line_tbl.count :'
1692: ||NVL(l_qte_line_tbl.count,0),1,'Y');

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

1787: END IF;
1788: End if;
1789: END IF;--l_qte_line_tbl(i).pricing_line_type_indicator = 'F'
1790:
1791: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);
1792: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1793: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_dtl_tbl.count :'
1794: ||NVL(l_qte_line_dtl_tbl.count,0),1,'Y');
1795: END IF;

Line 1805: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows

1801:
1802: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1803: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Shipment_Rows..',1,'Y');
1804: END IF;
1805: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows
1806: (p_qte_header_rec.quote_header_id, l_qte_line_tbl(i).quote_line_id);
1807: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1808: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_shipment_tbl.count :'
1809: ||NVL(l_shipment_tbl.count,0),1,'Y');

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

2525: aso_debug_pub.add('************************ LINE LEVEL BEGINS *******************************',1,'Y');
2526: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of ASO UTL PVT Query_Pricing_Line_Rows...',1,'Y');
2527: END IF;
2528:
2529: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Pricing_Line_Rows(p_qte_header_rec.quote_header_id);
2530: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2531: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_tbl.count :'||NVL(l_qte_line_tbl.count,0),1,'Y');
2532: l_pricing_end_time := dbms_utility.get_time;
2533: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);

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

2551: ||l_qte_line_tbl(i).pricing_line_type_indicator,1,'Y');
2552: END IF;
2553:
2554: l_qte_line_id := l_qte_line_tbl(i).quote_line_id;
2555: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_id);
2556:
2557: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2558: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Defaulting Hdr Lvl Price List and Currency..',1,'Y');
2559: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: p_qte_header_rec.currency_code :'

Line 2600: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows

2596:
2597: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2598: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Shipment_Rows..',1,'Y');
2599: END IF;
2600: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows
2601: (p_qte_header_rec.quote_header_id, l_QTE_LINE_ID);
2602: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2603: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_shipment_tbl.count :'
2604: ||NVL(l_shipment_tbl.count,0),1,'Y');