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 1733: l_pricing_start_time := dbms_utility.get_time;

1729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1730: END IF;
1731:
1732: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1733: l_pricing_start_time := dbms_utility.get_time;
1734: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Start of Price_Quote_With_Change_Lines',1,'Y');
1735: END IF;
1736:
1737: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1773: l_pricing_end_time := dbms_utility.get_time;

1769: ASO_PRICING_CORE_PVT.Print_G_Header_Rec;
1770:
1771: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1772: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Build_Context - Header Level... ',1,'Y');
1773: l_pricing_end_time := dbms_utility.get_time;
1774: l_accum_aso_time := l_pricing_end_time - l_pricing_start_time;
1775: END IF;
1776:
1777: QP_Price_Request_Context.Set_Request_Id;

Line 1789: l_pricing_start_time := dbms_utility.get_time;

1785: p_check_line_flag => 'N',
1786: x_pass_line => x_pass_line);
1787:
1788: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1789: l_pricing_start_time := dbms_utility.get_time;
1790: l_accum_qp_time := l_pricing_start_time - l_pricing_end_time;
1791: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: x_pass_line: '||nvl(x_pass_line,'null'),1,'Y');
1792: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Header_To_Request...',1,'Y');
1793: END IF;

Line 1829: l_pricing_end_time := dbms_utility.get_time;

1825: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Before call Get_Order_Lines_Status:p_control_rec.pricing_event:'
1826: ||p_control_rec.pricing_event,1,'Y');
1827: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Before call Get_Order_Lines_Status:p_control_rec.request_type:'
1828: ||p_control_rec.request_type,1,'Y');
1829: l_pricing_end_time := dbms_utility.get_time;
1830: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
1831: END IF;
1832:
1833: QP_UTIL_PUB.Get_Order_Lines_Status(p_event_code => p_control_rec.pricing_event,

Line 1839: l_pricing_start_time := dbms_utility.get_time;

1835: p_freight_call_flag => 'Y',
1836: p_request_type_code => p_control_rec.request_type);
1837:
1838: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1839: l_pricing_start_time := dbms_utility.get_time;
1840: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
1841:
1842: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:lx_order_status_rec.all_lines_flag:'
1843: ||lx_order_status_rec.all_lines_flag,1,'Y');

Line 1877: l_pricing_end_time := dbms_utility.get_time;

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');
1877: l_pricing_end_time := dbms_utility.get_time;
1878: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
1879: END IF;
1880:
1881: If l_qte_line_tbl.count > 0 Then

Line 1886: l_pricing_start_time := dbms_utility.get_time;

1882: --l_qte_line_tbl.count > 0
1883: --Set Check line flag from the given QP matrix
1884: --If the line is not changed and the all_lines_flag is 'Y' then only l_check_line_flag = 'Y'
1885: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1886: l_pricing_start_time := dbms_utility.get_time;
1887: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Count of passed table p_qte_line_tbl.count:'
1888: ||nvl(p_qte_line_tbl.count,0),1,'Y');
1889: END IF;
1890:

Line 1980: l_pricing_end_time := dbms_utility.get_time;

1976: End If;
1977:
1978: i := l_qte_line_tbl.first;
1979: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1980: l_pricing_end_time := dbms_utility.get_time;
1981: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
1982: END IF;
1983:
1984: While i is not null Loop

Line 1986: l_pricing_start_time := dbms_utility.get_time;

1982: END IF;
1983:
1984: While i is not null Loop
1985: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1986: l_pricing_start_time := dbms_utility.get_time;
1987: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:--------------Start line loop---------------',1,'Y');
1988: END IF;
1989: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1990: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_tbl(i).quote_line_id:'

Line 2086: l_pricing_end_time := dbms_utility.get_time;

2082: ASO_PRICING_CORE_PVT.Print_G_Line_Rec;
2083:
2084: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2085: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP Build_Contexts - Line Level...',1,'Y');
2086: l_pricing_end_time := dbms_utility.get_time;
2087: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2088: END IF;
2089:
2090: QP_ATTR_MAPPING_PUB.Build_Contexts (

Line 2100: l_pricing_start_time := dbms_utility.get_time;

2096: p_price_list_validated_flag => 'N',
2097: x_pass_line => x_pass_line);
2098:
2099: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2100: l_pricing_start_time := dbms_utility.get_time;
2101: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
2102: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: x_pass_line: '||nvl(x_pass_line,'null'),1,'Y');
2103: END IF;
2104:

Line 2189: l_pricing_end_time := dbms_utility.get_time;

2185: END IF;
2186: i:= l_qte_line_tbl.next(i);
2187: end If;--x_pass_line = 'Y' AND l_check_line_flag = 'Y'
2188: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2189: l_pricing_end_time := dbms_utility.get_time;
2190: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2191: END IF;
2192:
2193: End Loop;--End of While loop

Line 2229: l_pricing_start_time := dbms_utility.get_time;

2225: End If;
2226:
2227: -- Call to Price Adjustments, Adjustments Relationships, and Service Relationships
2228: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2229: l_pricing_start_time := dbms_utility.get_time;
2230: END IF;
2231: IF l_Qte_Line_id_tbl.EXISTS(1) THEN
2232: -- Call to Price Adjustment Relationships and Service Relationships
2233: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2452: l_pricing_end_time := dbms_utility.get_time;

2448: p_search_tbl => px_line_index_search_tbl);
2449:
2450: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2451: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Populate_QP_Temp_tables...',1,'Y');
2452: l_pricing_end_time := dbms_utility.get_time;
2453: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2454: END IF;
2455:
2456: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;

Line 2459: l_pricing_start_time := dbms_utility.get_time;

2455:
2456: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;
2457:
2458: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2459: l_pricing_start_time := dbms_utility.get_time;
2460: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
2461: END IF;
2462: -- Set the control rec for QP
2463:

Line 2479: l_pricing_end_time := dbms_utility.get_time;

2475: END IF;
2476:
2477: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2478: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
2479: l_pricing_end_time := dbms_utility.get_time;
2480: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2481: END IF;
2482:
2483: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */

Line 2506: l_pricing_start_time := dbms_utility.get_time;

2502: RAISE FND_API.G_EXC_ERROR;
2503: END IF;
2504:
2505: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2506: l_pricing_start_time := dbms_utility.get_time;
2507: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
2508: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
2509: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After PRICE_REQUEST l_return_status:'
2510: ||l_return_status, 1, 'Y');

Line 2579: l_pricing_end_time := dbms_utility.get_time;

2575: -- After the code review according to SPGOPAL if the summary line flag is 'N' then we don't need to make
2576: -- the calculate flag. Also we cannot compare the percentage of the header level since in future if there
2577: -- is a bucketing implementation for the header level modifier ASO does not have a way to compare the percentages.
2578: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2579: l_pricing_end_time := dbms_utility.get_time;
2580: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2581: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:**********Timing Before Calculate Call****************',1,'Y');
2582:
2583: 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 2701: l_pricing_start_time := dbms_utility.get_time;

2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2698: END IF;
2699:
2700: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2701: l_pricing_start_time := dbms_utility.get_time;
2702: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Start of Price_Quote_Calculate_Call',1,'Y');
2703: END IF;
2704:
2705: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2729: l_pricing_end_time := dbms_utility.get_time;

2725: /*Initialize the global tables*/
2726: ASO_PRICING_CORE_PVT.Initialize_Global_Tables;
2727:
2728: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2729: l_pricing_end_time := dbms_utility.get_time;
2730: l_accum_aso_time := l_pricing_end_time - l_pricing_start_time;
2731: END IF;
2732:
2733: QP_Price_Request_Context.Set_Request_Id;

Line 2745: l_pricing_start_time := dbms_utility.get_time;

2741: x_pass_line => x_pass_line);
2742:
2743: l_price_index := 1;
2744: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2745: l_pricing_start_time := dbms_utility.get_time;
2746: l_accum_qp_time := l_pricing_start_time - l_pricing_end_time;
2747: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: x_pass_line: '||nvl(x_pass_line,'null'),1,'Y');
2748: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Header_To_Request...',1,'Y');
2749: END IF;

Line 2772: l_pricing_end_time := dbms_utility.get_time;

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);
2774: END IF;
2775:
2776: If l_qte_line_tbl.count = 0 Then

Line 2786: l_pricing_start_time := dbms_utility.get_time;

2782: -- Line Count <> 0.
2783: For i in 1..l_qte_line_tbl.count Loop
2784:
2785: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2786: l_pricing_start_time := dbms_utility.get_time;
2787: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Line_Dtl_Rows...',1,'Y');
2788: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_tbl(i).quote_line_id:'
2789: ||NVL(l_qte_line_tbl(i).quote_line_id,0),1,'Y');
2790: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_tbl(i).pricing_line_type_indicator:'

Line 2883: l_pricing_end_time := dbms_utility.get_time;

2879: ASO_PRICING_CORE_PVT.Print_G_Line_Rec;
2880:
2881: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2882: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP Build_Contexts - Line Level...',1,'Y');
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: END IF;
2886:
2887: QP_ATTR_MAPPING_PUB.Build_Contexts (

Line 2896: l_pricing_start_time := dbms_utility.get_time;

2892: p_pricing_type_code => 'L',
2893: p_price_list_validated_flag => 'N',
2894: x_pass_line => x_pass_line);
2895: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2896: l_pricing_start_time := dbms_utility.get_time;
2897: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
2898: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: x_pass_line: '||nvl(x_pass_line,'null'),1,'Y');
2899: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Copy_Line_To_Request...',1,'Y');
2900: END IF;

Line 2951: l_pricing_end_time := dbms_utility.get_time;

2947: --increment the line index
2948: px_line_index_search_tbl(l_qte_line_id) := l_price_index;
2949: l_price_index:= l_price_index+1;
2950: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2951: l_pricing_end_time := dbms_utility.get_time;
2952: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
2953: END IF;
2954:
2955: End Loop; -- l_Qte_Line_tbl.count checking.

Line 2959: l_pricing_start_time := dbms_utility.get_time;

2955: End Loop; -- l_Qte_Line_tbl.count checking.
2956:
2957: -- Call to Price Adjustment Relationships and Service Relationships
2958: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2959: l_pricing_start_time := dbms_utility.get_time;
2960: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Price_Adj_All...',1,'Y');
2961: END IF;
2962:
2963: ASO_PRICING_CORE_PVT.Query_Price_Adj_All

Line 3014: l_pricing_end_time := dbms_utility.get_time;

3010: p_search_tbl => px_line_index_search_tbl);
3011:
3012: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3013: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Populate_QP_Temp_tables...',1,'Y');
3014: l_pricing_end_time := dbms_utility.get_time;
3015: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
3016: END IF;
3017:
3018: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;

Line 3021: l_pricing_start_time := dbms_utility.get_time;

3017:
3018: ASO_PRICING_CORE_PVT.populate_qp_temp_tables;
3019:
3020: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3021: l_pricing_start_time := dbms_utility.get_time;
3022: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
3023: END IF;
3024: -- Set the control rec for QP
3025:

Line 3038: l_pricing_end_time := dbms_utility.get_time;

3034: l_req_control_rec.rounding_flag := 'Q';
3035:
3036: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3037: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
3038: l_pricing_end_time := dbms_utility.get_time;
3039: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
3040: END IF;
3041:
3042: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */

Line 3067: l_pricing_start_time := dbms_utility.get_time;

3063: RAISE FND_API.G_EXC_ERROR;
3064: END IF;
3065:
3066: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3067: l_pricing_start_time := dbms_utility.get_time;
3068: l_accum_qp_time := l_accum_qp_time + (l_pricing_start_time - l_pricing_end_time);
3069: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
3070: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After PRICE_REQUEST l_return_status:'
3071: ||l_return_status, 1, 'Y');

Line 3123: l_pricing_end_time := dbms_utility.get_time;

3119: END LOOP;
3120:
3121:
3122: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3123: l_pricing_end_time := dbms_utility.get_time;
3124: l_accum_aso_time := l_accum_aso_time + (l_pricing_end_time - l_pricing_start_time);
3125: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:********Timing in Calculate Call**************',1,'Y');
3126: 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');
3127: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Total time taken (in secs) in Pricing+BuildContext:'||l_accum_qp_time/100,1,'Y');