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.QP_UTIL_PUB dependencies on QP_PREQ_GRP

Line 18: Qp_Preq_Grp.engine_debug('Begin Update_Balance');

14: PRAGMA AUTONOMOUS_TRANSACTION;
15: BEGIN
16:
17: IF l_debug = Fnd_Api.G_TRUE THEN
18: Qp_Preq_Grp.engine_debug('***Begin Update_Balance***');
19:
20: END IF;
21: UPDATE qp_limit_balances
22: SET available_amount = available_amount - p_new_trxn_amount +

Line 31: Qp_Preq_Grp.engine_debug('End Update_Balance');

27:
28: COMMIT;
29:
30: IF l_debug = Fnd_Api.G_TRUE THEN
31: Qp_Preq_Grp.engine_debug('***End Update_Balance***');
32:
33: END IF;
34: END Update_Balance;
35:

Line 65: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

61: l_consumed_amount NUMBER;
62:
63: BEGIN
64:
65: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
66: IF l_debug = Fnd_Api.G_TRUE THEN
67: Qp_Preq_Grp.engine_debug('***Begin Procedure Reverse_Limit *** ');
68:
69: END IF;

Line 67: Qp_Preq_Grp.engine_debug('Begin Procedure Reverse_Limit ');

63: BEGIN
64:
65: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
66: IF l_debug = Fnd_Api.G_TRUE THEN
67: Qp_Preq_Grp.engine_debug('***Begin Procedure Reverse_Limit *** ');
68:
69: END IF;
70: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
71:

Line 374: Qp_Preq_Grp.engine_debug('End Procedure Reverse_Limit ');

370: NULL;
371: END LOOP;--Loop over limit trxn records of consuming price_request_code
372:
373: IF l_debug = Fnd_Api.G_TRUE THEN
374: Qp_Preq_Grp.engine_debug('***End Procedure Reverse_Limit*** ');
375:
376: END IF;
377: EXCEPTION
378: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 522: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

518: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
519: l_order_status_rec Qp_Util_Pub.ORDER_LINES_STATUS_REC_TYPE;
520: l_dummy VARCHAR2(1);
521: BEGIN
522: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
523: l_dummy := NULL;
524:
525: -- bug 3006670
526: -- use alternate cursor if freight call

Line 602: Qp_Preq_Grp.engine_debug('Error in Procedure Get_Order_Lines_Status');

598:
599: EXCEPTION
600: WHEN OTHERS THEN
601: IF l_debug = Fnd_Api.G_TRUE THEN
602: Qp_Preq_Grp.engine_debug('Error in Procedure Get_Order_Lines_Status');
603:
604: END IF;
605: END Get_Order_Lines_Status;
606:

Line 651: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

647: WHERE ROWNUM < 7)
648: AND ROWNUM = 1;
649:
650: BEGIN
651: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
652:
653: IF l_debug = FND_API.G_TRUE THEN
654: QP_PREQ_GRP.engine_debug(' Inside Get_Manual_All_Lines_Status ');
655: END IF;

Line 654: QP_PREQ_GRP.engine_debug(' Inside Get_Manual_All_Lines_Status ');

650: BEGIN
651: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
652:
653: IF l_debug = FND_API.G_TRUE THEN
654: QP_PREQ_GRP.engine_debug(' Inside Get_Manual_All_Lines_Status ');
655: END IF;
656:
657: x_manual_all_lines_status := 'N';
658:

Line 664: QP_PREQ_GRP.engine_debug(' x_manual_all_lines_status :'||x_manual_all_lines_status);

660: FETCH l_manual_all_lines_info_cur INTO x_manual_all_lines_status;
661: CLOSE l_manual_all_lines_info_cur;
662:
663: IF l_debug = FND_API.G_TRUE THEN
664: QP_PREQ_GRP.engine_debug(' x_manual_all_lines_status :'||x_manual_all_lines_status);
665: QP_PREQ_GRP.engine_debug(' Leaving Get_Manual_All_Lines_Status ');
666: END IF;
667:
668: EXCEPTION

Line 665: QP_PREQ_GRP.engine_debug(' Leaving Get_Manual_All_Lines_Status ');

661: CLOSE l_manual_all_lines_info_cur;
662:
663: IF l_debug = FND_API.G_TRUE THEN
664: QP_PREQ_GRP.engine_debug(' x_manual_all_lines_status :'||x_manual_all_lines_status);
665: QP_PREQ_GRP.engine_debug(' Leaving Get_Manual_All_Lines_Status ');
666: END IF;
667:
668: EXCEPTION
669: WHEN OTHERS THEN

Line 672: QP_PREQ_GRP.engine_debug('Error in Procedure Get_Manual_All_Lines_Status');

668: EXCEPTION
669: WHEN OTHERS THEN
670:
671: IF l_debug = FND_API.G_TRUE THEN
672: QP_PREQ_GRP.engine_debug('Error in Procedure Get_Manual_All_Lines_Status');
673: END IF;
674:
675: END Get_Manual_All_Lines_Status;
676:

Line 731: Qp_Preq_Grp.engine_debug('validate price list - multi-currency');

727: -- bug 2943033
728: IF UPPER(Fnd_Profile.value('QP_MULTI_CURRENCY_INSTALLED')) IN ('Y', 'YES') AND
729: (NVL(Fnd_Profile.value('QP_MULTI_CURRENCY_USAGE'), 'Y') = 'Y') THEN
730: IF l_debug = Fnd_Api.G_TRUE THEN
731: Qp_Preq_Grp.engine_debug('validate price list - multi-currency');
732:
733: END IF;
734:
735: --Multi-Currency is installed

Line 753: Qp_Preq_Grp.engine_debug('validate price list - no multi-currency');

749:
750: ELSE --Multi-Currency is not installed
751:
752: IF l_debug = Fnd_Api.G_TRUE THEN
753: Qp_Preq_Grp.engine_debug('validate price list - no multi-currency');
754:
755: END IF;
756: OPEN c_validate_pl_curr_no_multi;
757: FETCH c_validate_pl_curr_no_multi INTO l_select;

Line 774: Qp_Preq_Grp.engine_debug('validate price list - result is ' || l_validate_result);

770: END IF; --Multi-Currency is installed
771:
772:
773: IF l_debug = Fnd_Api.G_TRUE THEN
774: Qp_Preq_Grp.engine_debug('validate price list - result is ' || l_validate_result);
775:
776: END IF;
777: EXCEPTION
778: WHEN OTHERS THEN

Line 1290: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

1286: l_cust_relation_flag := Oe_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG',l_org_id);
1287: ELSE
1288: l_cust_relation_flag := '';
1289: END IF;
1290: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
1291: IF l_debug = Fnd_Api.G_TRUE THEN
1292: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Get_Price_List BEGIN ');
1293: Oe_Debug_Pub.ADD('l_currency_code = ' || l_currency_code);
1294: Oe_Debug_Pub.ADD('l_pricing_effective_date = ' ||l_pricing_effective_date);

Line 1438: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

1434: l_price_list_blkt c_price_list_blkt%ROWTYPE;
1435:
1436: BEGIN
1437:
1438: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
1439: IF l_debug = Fnd_Api.G_TRUE THEN
1440: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Get_Price_Lists BEGIN ');
1441: Oe_Debug_Pub.ADD('p_currency_code = ' || p_currency_code);
1442: END IF;

Line 1803: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

1799: IS
1800: l_rounding_factor NUMBER;
1801: l_status_code VARCHAR2(1);
1802: BEGIN
1803: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
1804: IF l_debug = Fnd_Api.G_TRUE THEN
1805: Oe_Debug_Pub.ADD('BEGIN qp_util_pub.get_rounding_factor');
1806: Oe_Debug_Pub.ADD('p_use_multi_currency = ' || p_use_multi_currency);
1807: Oe_Debug_Pub.ADD('p_price_list_id = ' || p_price_list_id);

Line 1863: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

1859: l_rounding_options VARCHAR2(30);
1860: l_oe_unit_price_rounding VARCHAR2(30);
1861:
1862: BEGIN
1863: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
1864: IF l_debug = Fnd_Api.G_TRUE THEN
1865: Oe_Debug_Pub.ADD('BEGIN round_price');
1866: Oe_Debug_Pub.ADD('p_operand = ' || p_operand);
1867: Oe_Debug_Pub.ADD('p_rounding_factor = ' || p_rounding_factor);

Line 2127: p_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;

2123: x_request_id OUT NOCOPY NUMBER,
2124: x_return_status OUT NOCOPY VARCHAR2,
2125: x_return_status_text OUT NOCOPY VARCHAR2)
2126: IS
2127: p_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2128: p_qual_tbl Qp_Preq_Grp.QUAL_TBL_TYPE;
2129: p_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2130: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2131:

Line 2128: p_qual_tbl Qp_Preq_Grp.QUAL_TBL_TYPE;

2124: x_return_status OUT NOCOPY VARCHAR2,
2125: x_return_status_text OUT NOCOPY VARCHAR2)
2126: IS
2127: p_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2128: p_qual_tbl Qp_Preq_Grp.QUAL_TBL_TYPE;
2129: p_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2130: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2131:
2132: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;

Line 2129: p_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;

2125: x_return_status_text OUT NOCOPY VARCHAR2)
2126: IS
2127: p_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2128: p_qual_tbl Qp_Preq_Grp.QUAL_TBL_TYPE;
2129: p_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2130: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2131:
2132: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2133: p_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;

Line 2130: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;

2126: IS
2127: p_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2128: p_qual_tbl Qp_Preq_Grp.QUAL_TBL_TYPE;
2129: p_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2130: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2131:
2132: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2133: p_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2134: p_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;

Line 2132: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;

2128: p_qual_tbl Qp_Preq_Grp.QUAL_TBL_TYPE;
2129: p_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2130: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2131:
2132: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2133: p_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2134: p_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2135:
2136: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;

Line 2133: p_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;

2129: p_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2130: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2131:
2132: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2133: p_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2134: p_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2135:
2136: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;
2137:

Line 2134: p_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;

2130: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2131:
2132: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2133: p_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2134: p_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2135:
2136: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;
2137:
2138: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;

Line 2136: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;

2132: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2133: p_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2134: p_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2135:
2136: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;
2137:
2138: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2139: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;
2140: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;

Line 2138: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;

2134: p_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2135:
2136: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;
2137:
2138: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2139: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;
2140: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2141: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2142: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;

Line 2139: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;

2135:
2136: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;
2137:
2138: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2139: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;
2140: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2141: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2142: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2143: x_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;

Line 2140: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;

2136: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;
2137:
2138: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2139: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;
2140: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2141: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2142: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2143: x_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2144: x_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;

Line 2141: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;

2137:
2138: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2139: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;
2140: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2141: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2142: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2143: x_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2144: x_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2145:

Line 2142: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;

2138: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2139: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;
2140: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2141: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2142: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2143: x_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2144: x_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2145:
2146: l_return_status VARCHAR2(240);

Line 2143: x_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;

2139: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;
2140: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2141: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2142: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2143: x_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2144: x_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2145:
2146: l_return_status VARCHAR2(240);
2147: l_return_status_text VARCHAR2(240);

Line 2144: x_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;

2140: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2141: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2142: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2143: x_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2144: x_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2145:
2146: l_return_status VARCHAR2(240);
2147: l_return_status_text VARCHAR2(240);
2148:

Line 2183: relationship_type_code = Qp_Preq_Grp.G_SERVICE_LINE;

2179: CURSOR cl_rltd_dbg(p_req_id NUMBER) IS
2180: SELECT *
2181: FROM qp_debug_req_rltd_lines
2182: WHERE request_id = p_req_id AND
2183: relationship_type_code = Qp_Preq_Grp.G_SERVICE_LINE;
2184:
2185:
2186: l_dbg_req_rec qp_debug_req%ROWTYPE;
2187:

Line 2196: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

2192: --l_dbg_req_rltd qp_debug_req_rltd_lines%ROWTYPE;
2193:
2194: I NUMBER;
2195: BEGIN
2196: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2197: IF l_debug = Fnd_Api.G_TRUE THEN
2198: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Reprice_Debug_Engine_Request BEGIN');
2199: Oe_Debug_Pub.ADD('p_request_id = ' || p_request_id);
2200: END IF;

Line 2430: --l_version := qp_preq_grp.GET_VERSION;

2426:
2427: END IF;
2428: --dbms_output.put_line('The File is'|| oe_debug_pub.Set_Debug_Mode('FILE'));
2429: --dbms_output.put_line('The debug is ' || oe_debug_pub.g_debug);
2430: --l_version := qp_preq_grp.GET_VERSION;
2431: --dbms_output.put_line('Testing version '||l_version);
2432: --dbms_output.put_line('Debug2: ' || oe_debug_pub.g_debug);
2433: --dbms_output.put_line('Debug2: ');
2434:

Line 2540: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

2536: --Fix for bug 3550303 to reset the QP_BULK_PREQ_GRP.G_HVOP_pricing_ON
2537: --at the end of HVOP pricing call
2538: PROCEDURE RESET_HVOP_PRICING_ON IS
2539: BEGIN
2540: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2541: IF HVOP_Pricing_ON = 'Y' THEN
2542: IF l_debug = Fnd_Api.G_TRUE THEN
2543: Qp_Preq_Grp.Engine_debug('HVOP_Pricing_On is: '||Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON);
2544: Qp_Preq_Grp.Engine_debug('Resetting HVOP_Pricing_On at the end');

Line 2543: Qp_Preq_Grp.Engine_debug('HVOP_Pricing_On is: '||Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON);

2539: BEGIN
2540: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2541: IF HVOP_Pricing_ON = 'Y' THEN
2542: IF l_debug = Fnd_Api.G_TRUE THEN
2543: Qp_Preq_Grp.Engine_debug('HVOP_Pricing_On is: '||Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON);
2544: Qp_Preq_Grp.Engine_debug('Resetting HVOP_Pricing_On at the end');
2545: END IF;--l_debug
2546: Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON := 'N';
2547: IF l_debug = Fnd_Api.G_TRUE THEN

Line 2544: Qp_Preq_Grp.Engine_debug('Resetting HVOP_Pricing_On at the end');

2540: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2541: IF HVOP_Pricing_ON = 'Y' THEN
2542: IF l_debug = Fnd_Api.G_TRUE THEN
2543: Qp_Preq_Grp.Engine_debug('HVOP_Pricing_On is: '||Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON);
2544: Qp_Preq_Grp.Engine_debug('Resetting HVOP_Pricing_On at the end');
2545: END IF;--l_debug
2546: Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON := 'N';
2547: IF l_debug = Fnd_Api.G_TRUE THEN
2548: Qp_Preq_Grp.Engine_debug('HVOP_Pricing_On Now Reset to: '||Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON);

Line 2548: Qp_Preq_Grp.Engine_debug('HVOP_Pricing_On Now Reset to: '||Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON);

2544: Qp_Preq_Grp.Engine_debug('Resetting HVOP_Pricing_On at the end');
2545: END IF;--l_debug
2546: Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON := 'N';
2547: IF l_debug = Fnd_Api.G_TRUE THEN
2548: Qp_Preq_Grp.Engine_debug('HVOP_Pricing_On Now Reset to: '||Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON);
2549: END IF;--l_debug
2550: END IF;--HVOP_Pricing_ON
2551: EXCEPTION
2552: WHEN OTHERS THEN

Line 3004: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

3000: and update temp tables when plsql engine is installed*/
3001: PROCEDURE Update_Lines(p_update_type IN VARCHAR2, p_line_id IN NUMBER,
3002: p_line_index IN NUMBER, p_priced_quantity IN NUMBER) IS
3003: BEGIN
3004: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
3005: IF Qp_Java_Engine_Util_Pub.Java_Engine_Running = 'N' THEN
3006: IF l_debug = Fnd_Api.G_TRUE THEN
3007: Qp_Preq_Grp.engine_debug('Java engine not installed '
3008: ||' line_id '||p_line_id||' line_index '||p_line_index

Line 3007: Qp_Preq_Grp.engine_debug('Java engine not installed '

3003: BEGIN
3004: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
3005: IF Qp_Java_Engine_Util_Pub.Java_Engine_Running = 'N' THEN
3006: IF l_debug = Fnd_Api.G_TRUE THEN
3007: Qp_Preq_Grp.engine_debug('Java engine not installed '
3008: ||' line_id '||p_line_id||' line_index '||p_line_index
3009: ||' p_priced_quantity '||p_priced_quantity||' p_update_type '||p_update_type);
3010: END IF;
3011: IF p_update_type = 'UPDATE_LINE_ID' THEN

Line 3029: Qp_Preq_Grp.engine_debug('Java engine installed '

3025: END IF;--p_line_id IS NOT NULL
3026: END IF;
3027: ELSE
3028: IF l_debug = Fnd_Api.G_TRUE THEN
3029: Qp_Preq_Grp.engine_debug('Java engine installed '
3030: ||' line_id '||p_line_id||' line_index '||p_line_index
3031: ||' p_priced_quantity '||p_priced_quantity||' p_update_type '||p_update_type);
3032: END IF;
3033: IF p_update_type = 'UPDATE_LINE_ID' THEN