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 68: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

64: l_basis VARCHAR2(30);
65: --bug 13521835
66: BEGIN
67:
68: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
69: IF l_debug = Fnd_Api.G_TRUE THEN
70: Qp_Preq_Grp.engine_debug('***Begin Procedure Reverse_Limit *** ');
71:
72: END IF;

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

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

Line 303: qp_Preq_Grp.engine_debug('SPLIT NEW amount_rounded :'||amount_rounded);

299:
300: --bug#7540503
301: ELSIF p_action_code = 'SPLIT_NEW' THEN
302: amount_rounded := l_proration * l_cons_trans_rec.amount; --bug13521835
303: qp_Preq_Grp.engine_debug('SPLIT NEW amount_rounded :'||amount_rounded);
304: BEGIN
305: --Check if a split child record exists.
306: SELECT amount
307: INTO l_returned_amount

Line 325: qp_Preq_Grp.engine_debug(' SPLIT NEW l_basis :'||l_basis);

321: and ql.list_line_id = l_cons_trans_rec.list_line_id
322: and ql.limit_id = qlb.limit_id
323: and qlb.limit_balance_id = l_cons_trans_rec.limit_balance_id;
324:
325: qp_Preq_Grp.engine_debug(' SPLIT NEW l_basis :'||l_basis);
326: IF (l_basis='QUANTITY') then
327: amount_rounded:= round(amount_rounded);
328: qp_Preq_Grp.engine_debug('SPLIT NEW amount_rounded :'||amount_rounded);
329: END IF;

Line 328: qp_Preq_Grp.engine_debug('SPLIT NEW amount_rounded :'||amount_rounded);

324:
325: qp_Preq_Grp.engine_debug(' SPLIT NEW l_basis :'||l_basis);
326: IF (l_basis='QUANTITY') then
327: amount_rounded:= round(amount_rounded);
328: qp_Preq_Grp.engine_debug('SPLIT NEW amount_rounded :'||amount_rounded);
329: END IF;
330: EXCEPTION
331: WHEN OTHERS THEN
332: NULL;

Line 379: qp_Preq_Grp.engine_debug('amount_rounded :'||amount_rounded);

375: END; --Block around SELECT stmt to check if split child rec exists
376:
377: ELSIF p_action_code = 'SPLIT_ORIG' THEN
378: amount_rounded := l_proration * l_cons_trans_rec.amount; --bug13521835
379: qp_Preq_Grp.engine_debug('amount_rounded :'||amount_rounded);
380: BEGIN
381: --A record must exist for it to updated.
382: SELECT amount
383: INTO l_consumed_amount

Line 396: qp_Preq_Grp.engine_debug('l_consumed_amount :'||l_consumed_amount);

392: FND_MESSAGE.SET_NAME('QP','QP_LIMIT_TXN_NOT_FOUND');
393: x_return_message := FND_MESSAGE.GET;
394: RAISE FND_API.G_EXC_ERROR;
395: END;
396: qp_Preq_Grp.engine_debug('l_consumed_amount :'||l_consumed_amount);
397: --bug13521835
398: BEGIN
399: select ql.BASIS into l_basis
400: from qp_limits ql, qp_limit_balances qlb

Line 413: qp_Preq_Grp.engine_debug('l_basis :'||l_basis);

409: EXCEPTION
410: WHEN OTHERS THEN
411: NULL;
412: END;
413: qp_Preq_Grp.engine_debug('l_basis :'||l_basis);
414: qp_Preq_Grp.engine_debug('amount_rounded :'||amount_rounded);
415: --bug13521835
416: --Transaction Record to be updated exists. Update trxn amount.
417: UPDATE qp_limit_transactions

Line 414: qp_Preq_Grp.engine_debug('amount_rounded :'||amount_rounded);

410: WHEN OTHERS THEN
411: NULL;
412: END;
413: qp_Preq_Grp.engine_debug('l_basis :'||l_basis);
414: qp_Preq_Grp.engine_debug('amount_rounded :'||amount_rounded);
415: --bug13521835
416: --Transaction Record to be updated exists. Update trxn amount.
417: UPDATE qp_limit_transactions
418: SET amount = amount_rounded, --bug13521835

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

436: NULL;
437: END LOOP;--Loop over limit trxn records of consuming price_request_code
438:
439: IF l_debug = Fnd_Api.G_TRUE THEN
440: Qp_Preq_Grp.engine_debug('***End Procedure Reverse_Limit*** ');
441:
442: END IF;
443: EXCEPTION
444: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 590: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

586: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
587: l_order_status_rec Qp_Util_Pub.ORDER_LINES_STATUS_REC_TYPE;
588: l_dummy VARCHAR2(1);
589: BEGIN
590: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
591: l_dummy := NULL;
592:
593: -- bug 3006670
594: -- use alternate cursor if freight call

Line 670: qp_preq_grp.engine_debug('Error in Procedure Get_Order_Lines_Status');

666:
667: EXCEPTION
668: WHEN OTHERS THEN
669: IF l_debug = FND_API.G_TRUE THEN
670: qp_preq_grp.engine_debug('Error in Procedure Get_Order_Lines_Status');
671:
672: END IF;
673: END Get_Order_Lines_Status;
674:

Line 844: l_debug := qp_preq_grp.G_DEBUG_ENGINE;

840:
841: if ( x_pass_all_lines='N') then -- 9251187
842: l_order_status_rec.ALL_LINES_FLAG := 'N'; -- 9251187
843: else -- 9251187
844: l_debug := qp_preq_grp.G_DEBUG_ENGINE;
845: l_dummy := NULL;
846:
847: -- bug 3006670
848: -- use alternate cursor if freight call

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

923:
924: EXCEPTION
925: WHEN OTHERS THEN
926: IF l_debug = Fnd_Api.G_TRUE THEN
927: Qp_Preq_Grp.engine_debug('Error in Procedure Get_Order_Lines_Status');
928:
929: END IF;
930: END Get_Order_Lines_Status;
931:

Line 977: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

973: AND ROWNUM = 1;
974:
975: l_manual_grpline_profile_value Varchar2(1):= Nvl(Fnd_Profile.Value('QP_MANUAL_LINEGROUP'),'N');
976: BEGIN
977: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
978:
979: IF l_debug = FND_API.G_TRUE THEN
980: QP_PREQ_GRP.engine_debug(' Inside Get_Manual_All_Lines_Status ');
981: END IF;

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

976: BEGIN
977: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
978:
979: IF l_debug = FND_API.G_TRUE THEN
980: QP_PREQ_GRP.engine_debug(' Inside Get_Manual_All_Lines_Status ');
981: END IF;
982:
983: x_manual_all_lines_status := 'N';
984:

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

990: x_manual_all_lines_status := 'N';
991: END IF;
992:
993: IF l_debug = FND_API.G_TRUE THEN
994: QP_PREQ_GRP.engine_debug(' x_manual_all_lines_status :'||x_manual_all_lines_status);
995: QP_PREQ_GRP.engine_debug(' Leaving Get_Manual_All_Lines_Status ');
996: END IF;
997:
998: EXCEPTION

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

991: END IF;
992:
993: IF l_debug = FND_API.G_TRUE THEN
994: QP_PREQ_GRP.engine_debug(' x_manual_all_lines_status :'||x_manual_all_lines_status);
995: QP_PREQ_GRP.engine_debug(' Leaving Get_Manual_All_Lines_Status ');
996: END IF;
997:
998: EXCEPTION
999: WHEN OTHERS THEN

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

998: EXCEPTION
999: WHEN OTHERS THEN
1000:
1001: IF l_debug = FND_API.G_TRUE THEN
1002: QP_PREQ_GRP.engine_debug('Error in Procedure Get_Manual_All_Lines_Status');
1003: END IF;
1004:
1005: END Get_Manual_All_Lines_Status;
1006:

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

1057: -- bug 2943033
1058: IF UPPER(Fnd_Profile.value('QP_MULTI_CURRENCY_INSTALLED')) IN ('Y', 'YES') AND
1059: (NVL(Fnd_Profile.value('QP_MULTI_CURRENCY_USAGE'), 'Y') = 'Y') THEN
1060: IF l_debug = Fnd_Api.G_TRUE THEN
1061: Qp_Preq_Grp.engine_debug('validate price list - multi-currency');
1062:
1063: END IF;
1064:
1065: --Multi-Currency is installed

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

1079:
1080: ELSE --Multi-Currency is not installed
1081:
1082: IF l_debug = Fnd_Api.G_TRUE THEN
1083: Qp_Preq_Grp.engine_debug('validate price list - no multi-currency');
1084:
1085: END IF;
1086: OPEN c_validate_pl_curr_no_multi;
1087: FETCH c_validate_pl_curr_no_multi INTO l_select;

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

1100: END IF; --Multi-Currency is installed
1101:
1102:
1103: IF l_debug = Fnd_Api.G_TRUE THEN
1104: Qp_Preq_Grp.engine_debug('validate price list - result is ' || l_validate_result);
1105:
1106: END IF;
1107: EXCEPTION
1108: WHEN OTHERS THEN

Line 1620: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

1616: l_cust_relation_flag := Oe_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG',l_org_id);
1617: ELSE
1618: l_cust_relation_flag := '';
1619: END IF;
1620: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
1621: IF l_debug = Fnd_Api.G_TRUE THEN
1622: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Get_Price_List BEGIN ');
1623: Oe_Debug_Pub.ADD('l_currency_code = ' || l_currency_code);
1624: Oe_Debug_Pub.ADD('l_pricing_effective_date = ' ||l_pricing_effective_date);

Line 1768: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

1764: l_price_list_blkt c_price_list_blkt%ROWTYPE;
1765:
1766: BEGIN
1767:
1768: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
1769: IF l_debug = Fnd_Api.G_TRUE THEN
1770: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Get_Price_Lists BEGIN ');
1771: Oe_Debug_Pub.ADD('p_currency_code = ' || p_currency_code);
1772: END IF;

Line 2133: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

2129: IS
2130: l_rounding_factor NUMBER;
2131: l_status_code VARCHAR2(1);
2132: BEGIN
2133: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2134: IF l_debug = Fnd_Api.G_TRUE THEN
2135: Oe_Debug_Pub.ADD('BEGIN qp_util_pub.get_rounding_factor');
2136: Oe_Debug_Pub.ADD('p_use_multi_currency = ' || p_use_multi_currency);
2137: Oe_Debug_Pub.ADD('p_price_list_id = ' || p_price_list_id);

Line 2193: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

2189: l_rounding_options VARCHAR2(30);
2190: l_oe_unit_price_rounding VARCHAR2(30);
2191:
2192: BEGIN
2193: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2194: IF l_debug = Fnd_Api.G_TRUE THEN
2195: Oe_Debug_Pub.ADD('BEGIN round_price');
2196: Oe_Debug_Pub.ADD('p_operand = ' || p_operand);
2197: Oe_Debug_Pub.ADD('p_rounding_factor = ' || p_rounding_factor);

Line 2457: p_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;

2453: x_request_id OUT NOCOPY NUMBER,
2454: x_return_status OUT NOCOPY VARCHAR2,
2455: x_return_status_text OUT NOCOPY VARCHAR2)
2456: IS
2457: p_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2458: p_qual_tbl Qp_Preq_Grp.QUAL_TBL_TYPE;
2459: p_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2460: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2461:

Line 2458: p_qual_tbl Qp_Preq_Grp.QUAL_TBL_TYPE;

2454: x_return_status OUT NOCOPY VARCHAR2,
2455: x_return_status_text OUT NOCOPY VARCHAR2)
2456: IS
2457: p_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2458: p_qual_tbl Qp_Preq_Grp.QUAL_TBL_TYPE;
2459: p_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2460: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2461:
2462: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;

Line 2459: p_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;

2455: x_return_status_text OUT NOCOPY VARCHAR2)
2456: IS
2457: p_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2458: p_qual_tbl Qp_Preq_Grp.QUAL_TBL_TYPE;
2459: p_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2460: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2461:
2462: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2463: p_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;

Line 2460: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;

2456: IS
2457: p_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2458: p_qual_tbl Qp_Preq_Grp.QUAL_TBL_TYPE;
2459: p_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2460: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2461:
2462: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2463: p_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2464: p_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;

Line 2462: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;

2458: p_qual_tbl Qp_Preq_Grp.QUAL_TBL_TYPE;
2459: p_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2460: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2461:
2462: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2463: p_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2464: p_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2465:
2466: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;

Line 2463: p_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;

2459: p_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2460: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2461:
2462: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2463: p_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2464: p_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2465:
2466: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;
2467:

Line 2464: p_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;

2460: p_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2461:
2462: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2463: p_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2464: p_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2465:
2466: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;
2467:
2468: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;

Line 2466: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;

2462: p_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2463: p_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2464: p_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2465:
2466: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;
2467:
2468: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2469: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;
2470: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;

Line 2468: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;

2464: p_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2465:
2466: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;
2467:
2468: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2469: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;
2470: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2471: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2472: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;

Line 2469: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;

2465:
2466: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;
2467:
2468: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2469: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;
2470: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2471: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2472: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2473: x_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;

Line 2470: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;

2466: p_control_rec Qp_Preq_Grp.CONTROL_RECORD_TYPE;
2467:
2468: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2469: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;
2470: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2471: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2472: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2473: x_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2474: x_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;

Line 2471: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;

2467:
2468: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2469: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;
2470: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2471: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2472: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2473: x_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2474: x_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2475:

Line 2472: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;

2468: x_line_tbl Qp_Preq_Grp.LINE_TBL_TYPE;
2469: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;
2470: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2471: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2472: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2473: x_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2474: x_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2475:
2476: l_return_status VARCHAR2(240);

Line 2473: x_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;

2469: x_line_qual Qp_Preq_Grp.QUAL_TBL_TYPE;
2470: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2471: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2472: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2473: x_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2474: x_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2475:
2476: l_return_status VARCHAR2(240);
2477: l_return_status_text VARCHAR2(240);

Line 2474: x_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;

2470: x_line_attr_tbl Qp_Preq_Grp.LINE_ATTR_TBL_TYPE;
2471: x_line_detail_tbl Qp_Preq_Grp.LINE_DETAIL_TBL_TYPE;
2472: x_line_detail_qual_tbl Qp_Preq_Grp.LINE_DETAIL_QUAL_TBL_TYPE;
2473: x_line_detail_attr_tbl Qp_Preq_Grp.LINE_DETAIL_ATTR_TBL_TYPE;
2474: x_related_lines_tbl Qp_Preq_Grp.RELATED_LINES_TBL_TYPE;
2475:
2476: l_return_status VARCHAR2(240);
2477: l_return_status_text VARCHAR2(240);
2478:

Line 2513: relationship_type_code = Qp_Preq_Grp.G_SERVICE_LINE;

2509: CURSOR cl_rltd_dbg(p_req_id NUMBER) IS
2510: SELECT *
2511: FROM qp_debug_req_rltd_lines
2512: WHERE request_id = p_req_id AND
2513: relationship_type_code = Qp_Preq_Grp.G_SERVICE_LINE;
2514:
2515:
2516: l_dbg_req_rec qp_debug_req%ROWTYPE;
2517:

Line 2526: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

2522: --l_dbg_req_rltd qp_debug_req_rltd_lines%ROWTYPE;
2523:
2524: I NUMBER;
2525: BEGIN
2526: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2527: IF l_debug = Fnd_Api.G_TRUE THEN
2528: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Reprice_Debug_Engine_Request BEGIN');
2529: Oe_Debug_Pub.ADD('p_request_id = ' || p_request_id);
2530: END IF;

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

2756:
2757: END IF;
2758: --dbms_output.put_line('The File is'|| oe_debug_pub.Set_Debug_Mode('FILE'));
2759: --dbms_output.put_line('The debug is ' || oe_debug_pub.g_debug);
2760: --l_version := qp_preq_grp.GET_VERSION;
2761: --dbms_output.put_line('Testing version '||l_version);
2762: --dbms_output.put_line('Debug2: ' || oe_debug_pub.g_debug);
2763: --dbms_output.put_line('Debug2: ');
2764:

Line 2870: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

2866: --Fix for bug 3550303 to reset the QP_BULK_PREQ_GRP.G_HVOP_pricing_ON
2867: --at the end of HVOP pricing call
2868: PROCEDURE RESET_HVOP_PRICING_ON IS
2869: BEGIN
2870: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2871: IF HVOP_Pricing_ON = 'Y' THEN
2872: IF l_debug = Fnd_Api.G_TRUE THEN
2873: Qp_Preq_Grp.Engine_debug('HVOP_Pricing_On is: '||Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON);
2874: Qp_Preq_Grp.Engine_debug('Resetting HVOP_Pricing_On at the end');

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

2869: BEGIN
2870: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2871: IF HVOP_Pricing_ON = 'Y' THEN
2872: IF l_debug = Fnd_Api.G_TRUE THEN
2873: Qp_Preq_Grp.Engine_debug('HVOP_Pricing_On is: '||Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON);
2874: Qp_Preq_Grp.Engine_debug('Resetting HVOP_Pricing_On at the end');
2875: END IF;--l_debug
2876: Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON := 'N';
2877: IF l_debug = Fnd_Api.G_TRUE THEN

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

2870: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2871: IF HVOP_Pricing_ON = 'Y' THEN
2872: IF l_debug = Fnd_Api.G_TRUE THEN
2873: Qp_Preq_Grp.Engine_debug('HVOP_Pricing_On is: '||Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON);
2874: Qp_Preq_Grp.Engine_debug('Resetting HVOP_Pricing_On at the end');
2875: END IF;--l_debug
2876: Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON := 'N';
2877: IF l_debug = Fnd_Api.G_TRUE THEN
2878: Qp_Preq_Grp.Engine_debug('HVOP_Pricing_On Now Reset to: '||Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON);

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

2874: Qp_Preq_Grp.Engine_debug('Resetting HVOP_Pricing_On at the end');
2875: END IF;--l_debug
2876: Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON := 'N';
2877: IF l_debug = Fnd_Api.G_TRUE THEN
2878: Qp_Preq_Grp.Engine_debug('HVOP_Pricing_On Now Reset to: '||Qp_Bulk_Preq_Grp.G_HVOP_pricing_ON);
2879: END IF;--l_debug
2880: END IF;--HVOP_Pricing_ON
2881: EXCEPTION
2882: WHEN OTHERS THEN

Line 3334: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

3330: and update temp tables when plsql engine is installed*/
3331: PROCEDURE Update_Lines(p_update_type IN VARCHAR2, p_line_id IN NUMBER,
3332: p_line_index IN NUMBER, p_priced_quantity IN NUMBER) IS
3333: BEGIN
3334: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
3335: IF Qp_Java_Engine_Util_Pub.Java_Engine_Running = 'N' THEN
3336: IF l_debug = Fnd_Api.G_TRUE THEN
3337: Qp_Preq_Grp.engine_debug('Java engine not installed '
3338: ||' line_id '||p_line_id||' line_index '||p_line_index

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

3333: BEGIN
3334: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
3335: IF Qp_Java_Engine_Util_Pub.Java_Engine_Running = 'N' THEN
3336: IF l_debug = Fnd_Api.G_TRUE THEN
3337: Qp_Preq_Grp.engine_debug('Java engine not installed '
3338: ||' line_id '||p_line_id||' line_index '||p_line_index
3339: ||' p_priced_quantity '||p_priced_quantity||' p_update_type '||p_update_type);
3340: END IF;
3341: IF p_update_type = 'UPDATE_LINE_ID' THEN

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

3355: END IF;--p_line_id IS NOT NULL
3356: END IF;
3357: ELSE
3358: IF l_debug = Fnd_Api.G_TRUE THEN
3359: Qp_Preq_Grp.engine_debug('Java engine installed '
3360: ||' line_id '||p_line_id||' line_index '||p_line_index
3361: ||' p_priced_quantity '||p_priced_quantity||' p_update_type '||p_update_type);
3362: END IF;
3363: IF p_update_type = 'UPDATE_LINE_ID' THEN