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 DBMS_UTILITY

Line 81: l_pricing_start_time := dbms_utility.get_time;

77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END IF;
79:
80: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
81: l_pricing_start_time := dbms_utility.get_time;
82: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Start of Price_Entire_Quote',1,'Y');
83: END IF;
84:
85: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 112: l_pricing_end_time := dbms_utility.get_time;

108: end If;--If p_internal_call_flag = 'N' then
109:
110: ASO_PRICING_CORE_PVT.Print_G_Header_Rec;
111: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
112: l_pricing_end_time := dbms_utility.get_time;
113: l_accum_aso_time := l_pricing_end_time - l_pricing_start_time;
114: END IF;
115:
116: QP_Price_Request_Context.Set_Request_Id;

Line 128: l_pricing_start_time := dbms_utility.get_time;

124: x_pass_line => x_pass_line);
125:
126:
127: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
128: l_pricing_start_time := dbms_utility.get_time;
129: l_accum_qp_time := l_pricing_start_time - l_pricing_end_time;
130: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: x_pass_line: '||nvl(x_pass_line,'null'),1,'Y');
131: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Header_To_Request...',1,'Y');
132: END IF;

Line 169: l_pricing_end_time := dbms_utility.get_time;

165: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Before call Get_Order_Lines_Status:p_control_rec.pricing_event:'
166: ||p_control_rec.pricing_event,1,'Y');
167: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Before call Get_Order_Lines_Status:p_control_rec.request_type:'
168: ||p_control_rec.request_type,1,'Y');
169: l_pricing_end_time := dbms_utility.get_time;
170: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
171: END IF;
172:
173: QP_UTIL_PUB.Get_Order_Lines_Status(p_event_code => p_control_rec.pricing_event,

Line 179: l_pricing_start_time := dbms_utility.get_time;

175: p_freight_call_flag => 'Y',
176: p_request_type_code => p_control_rec.request_type);
177:
178: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
179: l_pricing_start_time := dbms_utility.get_time;
180: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
181:
182: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:lx_order_status_rec.all_lines_flag:'
183: ||lx_order_status_rec.all_lines_flag,1,'Y');

Line 200: l_pricing_end_time := dbms_utility.get_time;

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;
201: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
202: END IF;
203:
204: -- Added this code to delete all the adjustments when there are no items in the cart

Line 216: l_pricing_start_time := dbms_utility.get_time;

212:
213: For i in 1..l_qte_line_tbl.count Loop
214:
215: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
216: l_pricing_start_time := dbms_utility.get_time;
217: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Line_Dtl_Rows...',1,'Y');
218: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_tbl(i).quote_line_id:'
219: ||NVL(l_qte_line_tbl(i).quote_line_id,0),1,'Y');
220: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_tbl(i).pricing_line_type_indicator:'

Line 313: l_pricing_end_time := dbms_utility.get_time;

309: ASO_PRICING_CORE_PVT.Print_G_Line_Rec;
310:
311: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
312: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP Build_Contexts - Line Level...',1,'Y');
313: l_pricing_end_time := dbms_utility.get_time;
314: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
315: END IF;
316: QP_ATTR_MAPPING_PUB.Build_Contexts (
317: p_request_type_code => p_control_rec.request_type,

Line 325: l_pricing_start_time := dbms_utility.get_time;

321: p_pricing_type_code => 'L',
322: p_price_list_validated_flag => 'N',
323: x_pass_line => x_pass_line);
324: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
325: l_pricing_start_time := dbms_utility.get_time;
326: l_accum_qp_time := l_accum_qp_time +(l_pricing_start_time - l_pricing_end_time);
327: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: x_pass_line: '||nvl(x_pass_line,'null'),1,'Y');
328: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Line_To_Request...',1,'Y');
329: END IF;

Line 394: l_pricing_end_time := dbms_utility.get_time;

390: --increment the line index
391: px_line_index_search_tbl(l_qte_line_id) := l_price_index;
392: l_price_index:= l_price_index+1;
393: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
394: l_pricing_end_time := dbms_utility.get_time;
395: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
396: END IF;
397: End Loop; -- l_Qte_Line_tbl.count checking.
398:

Line 401: l_pricing_start_time := dbms_utility.get_time;

397: End Loop; -- l_Qte_Line_tbl.count checking.
398:
399: -- Call to Price Adjustment Relationships and Service Relationships
400: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
401: l_pricing_start_time := dbms_utility.get_time;
402: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Price_Adjustments...',1,'Y');
403: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_id_tbl.count :'
404: ||NVL(l_qte_line_id_tbl.count,0),1,'Y');
405: END IF;

Line 528: l_pricing_end_time := dbms_utility.get_time;

524: p_search_tbl => px_line_index_search_tbl);
525:
526: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
527: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Populate_QP_Temp_tables...',1,'Y');
528: l_pricing_end_time := dbms_utility.get_time;
529: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
530: END IF;
531:
532: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;

Line 535: l_pricing_start_time := dbms_utility.get_time;

531:
532: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;
533:
534: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
535: l_pricing_start_time := dbms_utility.get_time;
536: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
537: END IF;
538:
539:

Line 557: l_pricing_end_time := dbms_utility.get_time;

553: l_req_control_rec.rounding_flag := 'Q';
554:
555: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
556: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
557: l_pricing_end_time := dbms_utility.get_time;
558: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
559: END IF;
560:
561: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */

Line 585: l_pricing_start_time := dbms_utility.get_time;

581: RAISE FND_API.G_EXC_ERROR;
582: END IF;
583:
584: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
585: l_pricing_start_time := dbms_utility.get_time;
586: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
587: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
588: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After PRICE_REQUEST l_return_status:'
589: ||l_return_status, 1, 'Y');

Line 671: l_pricing_end_time := dbms_utility.get_time;

667: END IF;
668: END LOOP;
669:
670: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
671: l_pricing_end_time := dbms_utility.get_time;
672: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
673: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:**********Timing in Price Entire Quote**************',1,'Y');
674: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Total time taken (in secs) in Price Entire Quote(Besides Pricing):'||l_accum_aso_time/100,1,'Y');
675: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Total time taken (in secs) in Pricing+BuildContext:'||l_accum_qp_time/100,1,'Y');

Line 1549: l_pricing_start_time := dbms_utility.get_time;

1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1546: END IF;
1547:
1548: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1549: l_pricing_start_time := dbms_utility.get_time;
1550: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Start of Price_Quote_With_Change_Lines',1,'Y');
1551: END IF;
1552:
1553: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1589: l_pricing_end_time := dbms_utility.get_time;

1585: ASO_PRICING_CORE_PVT.Print_G_Header_Rec;
1586:
1587: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1588: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Build_Context - Header Level... ',1,'Y');
1589: l_pricing_end_time := dbms_utility.get_time;
1590: l_accum_aso_time := l_pricing_end_time - l_pricing_start_time;
1591: END IF;
1592:
1593: QP_Price_Request_Context.Set_Request_Id;

Line 1605: l_pricing_start_time := dbms_utility.get_time;

1601: p_check_line_flag => 'N',
1602: x_pass_line => x_pass_line);
1603:
1604: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1605: l_pricing_start_time := dbms_utility.get_time;
1606: l_accum_qp_time := l_pricing_start_time - l_pricing_end_time;
1607: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: x_pass_line: '||nvl(x_pass_line,'null'),1,'Y');
1608: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Header_To_Request...',1,'Y');
1609: END IF;

Line 1645: l_pricing_end_time := dbms_utility.get_time;

1641: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Before call Get_Order_Lines_Status:p_control_rec.pricing_event:'
1642: ||p_control_rec.pricing_event,1,'Y');
1643: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Before call Get_Order_Lines_Status:p_control_rec.request_type:'
1644: ||p_control_rec.request_type,1,'Y');
1645: l_pricing_end_time := dbms_utility.get_time;
1646: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
1647: END IF;
1648:
1649: QP_UTIL_PUB.Get_Order_Lines_Status(p_event_code => p_control_rec.pricing_event,

Line 1655: l_pricing_start_time := dbms_utility.get_time;

1651: p_freight_call_flag => 'Y',
1652: p_request_type_code => p_control_rec.request_type);
1653:
1654: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1655: l_pricing_start_time := dbms_utility.get_time;
1656: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
1657:
1658: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:lx_order_status_rec.all_lines_flag:'
1659: ||lx_order_status_rec.all_lines_flag,1,'Y');

Line 1693: l_pricing_end_time := dbms_utility.get_time;

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');
1693: l_pricing_end_time := dbms_utility.get_time;
1694: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
1695: END IF;
1696:
1697: If l_qte_line_tbl.count > 0 Then

Line 1702: l_pricing_start_time := dbms_utility.get_time;

1698: --l_qte_line_tbl.count > 0
1699: --Set Check line flag from the given QP matrix
1700: --If the line is not changed and the all_lines_flag is 'Y' then only l_check_line_flag = 'Y'
1701: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1702: l_pricing_start_time := dbms_utility.get_time;
1703: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Count of passed table p_qte_line_tbl.count:'
1704: ||nvl(p_qte_line_tbl.count,0),1,'Y');
1705: END IF;
1706:

Line 1740: l_pricing_end_time := dbms_utility.get_time;

1736: End If;
1737:
1738: i := l_qte_line_tbl.first;
1739: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1740: l_pricing_end_time := dbms_utility.get_time;
1741: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
1742: END IF;
1743:
1744: While i is not null Loop

Line 1746: l_pricing_start_time := dbms_utility.get_time;

1742: END IF;
1743:
1744: While i is not null Loop
1745: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1746: l_pricing_start_time := dbms_utility.get_time;
1747: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:--------------Start line loop---------------',1,'Y');
1748: END IF;
1749: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1750: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_tbl(i).quote_line_id:'

Line 1846: l_pricing_end_time := dbms_utility.get_time;

1842: ASO_PRICING_CORE_PVT.Print_G_Line_Rec;
1843:
1844: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1845: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP Build_Contexts - Line Level...',1,'Y');
1846: l_pricing_end_time := dbms_utility.get_time;
1847: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
1848: END IF;
1849:
1850: QP_ATTR_MAPPING_PUB.Build_Contexts (

Line 1860: l_pricing_start_time := dbms_utility.get_time;

1856: p_price_list_validated_flag => 'N',
1857: x_pass_line => x_pass_line);
1858:
1859: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1860: l_pricing_start_time := dbms_utility.get_time;
1861: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
1862: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: x_pass_line: '||nvl(x_pass_line,'null'),1,'Y');
1863: END IF;
1864:

Line 1949: l_pricing_end_time := dbms_utility.get_time;

1945: END IF;
1946: i:= l_qte_line_tbl.next(i);
1947: end If;--x_pass_line = 'Y' AND l_check_line_flag = 'Y'
1948: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1949: l_pricing_end_time := dbms_utility.get_time;
1950: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
1951: END IF;
1952:
1953: End Loop;--End of While loop

Line 1989: l_pricing_start_time := dbms_utility.get_time;

1985: End If;
1986:
1987: -- Call to Price Adjustments, Adjustments Relationships, and Service Relationships
1988: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1989: l_pricing_start_time := dbms_utility.get_time;
1990: END IF;
1991: IF l_Qte_Line_id_tbl.EXISTS(1) THEN
1992: -- Call to Price Adjustment Relationships and Service Relationships
1993: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2212: l_pricing_end_time := dbms_utility.get_time;

2208: p_search_tbl => px_line_index_search_tbl);
2209:
2210: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2211: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Populate_QP_Temp_tables...',1,'Y');
2212: l_pricing_end_time := dbms_utility.get_time;
2213: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2214: END IF;
2215:
2216: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;

Line 2219: l_pricing_start_time := dbms_utility.get_time;

2215:
2216: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;
2217:
2218: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2219: l_pricing_start_time := dbms_utility.get_time;
2220: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
2221: END IF;
2222: -- Set the control rec for QP
2223:

Line 2239: l_pricing_end_time := dbms_utility.get_time;

2235: END IF;
2236:
2237: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2238: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
2239: l_pricing_end_time := dbms_utility.get_time;
2240: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2241: END IF;
2242:
2243: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */

Line 2266: l_pricing_start_time := dbms_utility.get_time;

2262: RAISE FND_API.G_EXC_ERROR;
2263: END IF;
2264:
2265: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2266: l_pricing_start_time := dbms_utility.get_time;
2267: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
2268: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
2269: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After PRICE_REQUEST l_return_status:'
2270: ||l_return_status, 1, 'Y');

Line 2339: l_pricing_end_time := dbms_utility.get_time;

2335: -- After the code review according to SPGOPAL if the summary line flag is 'N' then we don't need to make
2336: -- the calculate flag. Also we cannot compare the percentage of the header level since in future if there
2337: -- is a bucketing implementation for the header level modifier ASO does not have a way to compare the percentages.
2338: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2339: l_pricing_end_time := dbms_utility.get_time;
2340: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2341: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:**********Timing Before Calculate Call****************',1,'Y');
2342:
2343: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Total time taken (in secs) in Price Entire Quote(Besides Pricing):'||l_accum_aso_time/100,1,'Y');

Line 2461: l_pricing_start_time := dbms_utility.get_time;

2457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2458: END IF;
2459:
2460: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2461: l_pricing_start_time := dbms_utility.get_time;
2462: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Start of Price_Quote_Calculate_Call',1,'Y');
2463: END IF;
2464:
2465: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2489: l_pricing_end_time := dbms_utility.get_time;

2485: /*Initialize the global tables*/
2486: ASO_PRICING_CORE_PVT.Initialize_Global_Tables;
2487:
2488: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2489: l_pricing_end_time := dbms_utility.get_time;
2490: l_accum_aso_time := l_pricing_end_time - l_pricing_start_time;
2491: END IF;
2492:
2493: QP_Price_Request_Context.Set_Request_Id;

Line 2505: l_pricing_start_time := dbms_utility.get_time;

2501: x_pass_line => x_pass_line);
2502:
2503: l_price_index := 1;
2504: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2505: l_pricing_start_time := dbms_utility.get_time;
2506: l_accum_qp_time := l_pricing_start_time - l_pricing_end_time;
2507: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: x_pass_line: '||nvl(x_pass_line,'null'),1,'Y');
2508: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Header_To_Request...',1,'Y');
2509: END IF;

Line 2532: l_pricing_end_time := dbms_utility.get_time;

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);
2534: END IF;
2535:
2536: If l_qte_line_tbl.count = 0 Then

Line 2546: l_pricing_start_time := dbms_utility.get_time;

2542: -- Line Count <> 0.
2543: For i in 1..l_qte_line_tbl.count Loop
2544:
2545: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2546: l_pricing_start_time := dbms_utility.get_time;
2547: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Line_Dtl_Rows...',1,'Y');
2548: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_tbl(i).quote_line_id:'
2549: ||NVL(l_qte_line_tbl(i).quote_line_id,0),1,'Y');
2550: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_tbl(i).pricing_line_type_indicator:'

Line 2643: l_pricing_end_time := dbms_utility.get_time;

2639: ASO_PRICING_CORE_PVT.Print_G_Line_Rec;
2640:
2641: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2642: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP Build_Contexts - Line Level...',1,'Y');
2643: l_pricing_end_time := dbms_utility.get_time;
2644: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2645: END IF;
2646:
2647: QP_ATTR_MAPPING_PUB.Build_Contexts (

Line 2656: l_pricing_start_time := dbms_utility.get_time;

2652: p_pricing_type_code => 'L',
2653: p_price_list_validated_flag => 'N',
2654: x_pass_line => x_pass_line);
2655: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2656: l_pricing_start_time := dbms_utility.get_time;
2657: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
2658: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: x_pass_line: '||nvl(x_pass_line,'null'),1,'Y');
2659: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Line_To_Request...',1,'Y');
2660: END IF;

Line 2711: l_pricing_end_time := dbms_utility.get_time;

2707: --increment the line index
2708: px_line_index_search_tbl(l_qte_line_id) := l_price_index;
2709: l_price_index:= l_price_index+1;
2710: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2711: l_pricing_end_time := dbms_utility.get_time;
2712: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2713: END IF;
2714:
2715: End Loop; -- l_Qte_Line_tbl.count checking.

Line 2719: l_pricing_start_time := dbms_utility.get_time;

2715: End Loop; -- l_Qte_Line_tbl.count checking.
2716:
2717: -- Call to Price Adjustment Relationships and Service Relationships
2718: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2719: l_pricing_start_time := dbms_utility.get_time;
2720: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Price_Adj_All...',1,'Y');
2721: END IF;
2722:
2723: ASO_PRICING_CORE_PVT.Query_Price_Adj_All

Line 2774: l_pricing_end_time := dbms_utility.get_time;

2770: p_search_tbl => px_line_index_search_tbl);
2771:
2772: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2773: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Populate_QP_Temp_tables...',1,'Y');
2774: l_pricing_end_time := dbms_utility.get_time;
2775: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2776: END IF;
2777:
2778: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;

Line 2781: l_pricing_start_time := dbms_utility.get_time;

2777:
2778: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;
2779:
2780: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2781: l_pricing_start_time := dbms_utility.get_time;
2782: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
2783: END IF;
2784: -- Set the control rec for QP
2785:

Line 2798: l_pricing_end_time := dbms_utility.get_time;

2794: l_req_control_rec.rounding_flag := 'Q';
2795:
2796: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2797: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
2798: l_pricing_end_time := dbms_utility.get_time;
2799: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2800: END IF;
2801:
2802: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */

Line 2827: l_pricing_start_time := dbms_utility.get_time;

2823: RAISE FND_API.G_EXC_ERROR;
2824: END IF;
2825:
2826: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2827: l_pricing_start_time := dbms_utility.get_time;
2828: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
2829: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
2830: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After PRICE_REQUEST l_return_status:'
2831: ||l_return_status, 1, 'Y');

Line 2883: l_pricing_end_time := dbms_utility.get_time;

2879: END LOOP;
2880:
2881:
2882: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2883: l_pricing_end_time := dbms_utility.get_time;
2884: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2885: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:********Timing in Calculate Call**************',1,'Y');
2886: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Total time taken (in secs) in Calculate call(Besides Pricing):'||l_accum_aso_time/100,1,'Y');
2887: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Total time taken (in secs) in Pricing+BuildContext:'||l_accum_qp_time/100,1,'Y');