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_FORMULA_PRICE_CALC_PVT dependencies on QP_PREQ_GRP

Line 39: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED;

35: FROM qp_int_line_attrs_t lattr
36: WHERE request_id = p_request_id
37: AND line_index = p_line_index
38: AND attribute_type IN ('PRICING','PRODUCT')
39: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED;
40:
41: -- qual cursor
42: CURSOR req_line_attrs_qual_cur(a_line_index NUMBER)
43: IS

Line 49: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED;

45: FROM qp_int_line_attrs_t lattr
46: WHERE request_id = p_request_id
47: AND line_index = p_line_index
48: AND attribute_type IN ('PRICING','PRODUCT','QUALIFIER')
49: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED;
50:
51: l_pass_qualifiers VARCHAR2(10) := FND_PROFILE.VALUE('QP_PASS_QUALIFIERS_TO_GET_CUSTOM');
52: l_req_line_attrs_tbl QP_FORMULA_PRICE_CALC_PVT.REQ_LINE_ATTRS_TBL;
53: i NUMBER := 1;

Line 177: QP_PREQ_GRP.engine_debug('Formula is ' || l_new_formula);

173: END IF; -- If the character is a number or not
174: END LOOP; -- Loop through every character in the Formula String
175:
176: IF l_debug = FND_API.G_TRUE THEN
177: QP_PREQ_GRP.engine_debug('Formula is ' || l_new_formula);
178: END IF;
179:
180: l_select_stmt := 'SELECT '|| l_new_formula || ' FROM DUAL';
181: EXECUTE IMMEDIATE l_select_stmt INTO l_formula_value;

Line 256: AND t.pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED

252: AND fl.price_formula_line_type_code = 'ML'
253: AND t.line_index = a_line_index
254: AND t.attribute_type in ('PRICING','PRODUCT')
255: AND fl.price_formula_id = a_price_formula_id
256: AND t.pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
257: AND fla.list_header_id = fl.price_modifier_list_id
258: AND fla.pricing_attribute_context = t.context
259: AND fla.pricing_attribute = t.attribute
260: AND a.list_header_id = fla.list_header_id

Line 282: AND t.pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED

278: AND fl.price_formula_line_type_code = 'ML'
279: AND t.line_index = a_line_index
280: AND t.attribute_type in ('PRICING','PRODUCT')
281: AND fl.price_formula_id = a_price_formula_id
282: AND t.pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
283: AND fla.list_header_id = fl.price_modifier_list_id
284: AND fla.pricing_attribute_context = t.context
285: AND fla.pricing_attribute = t.attribute
286: AND a.list_header_id = fla.list_header_id

Line 334: AND t.pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED

330: AND t.context = a.pricing_attribute_context
331: AND t.attribute = a.pricing_attribute
332: AND t.line_index = a_line_index
333: AND t.attribute_type in ('PRICING','PRODUCT')
334: AND t.pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
335: AND a.list_header_id = fla.list_header_id
336: AND a.list_line_id = a_list_line_id
337: AND a.search_ind = 2
338: AND(t.value_from BETWEEN a.pattern_value_from_positive

Line 356: -- AND t.pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED

352: -- AND t.context = a.pricing_attribute_context
353: -- AND t.attribute = a.pricing_attribute
354: -- AND t.line_index = a_line_index
355: -- AND t.attribute_type in ('PRICING','PRODUCT')
356: -- AND t.pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
357: -- AND a.list_header_id = fla.list_header_id
358: -- AND a.list_line_id = a_list_line_id
359: -- AND a.search_ind = 2
360: -- AND t.value_from between --3520634 start

Line 376: -- AND t.pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED

372: -- AND t.context = a.pricing_attribute_context
373: -- AND t.attribute = a.pricing_attribute
374: -- AND t.line_index = a_line_index
375: -- AND t.attribute_type in ('PRICING','PRODUCT')
376: -- AND t.pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
377: -- AND a.list_header_id = fla.list_header_id
378: -- AND a.list_line_id = a_list_line_id
379: -- AND a.search_ind = 2
380: -- AND t.value_from between

Line 417: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED;

413: WHERE context = a_pricing_attribute_context
414: AND attribute = a_pricing_attribute
415: AND line_index = a_line_index
416: AND attribute_type in ('PRICING','PRODUCT')
417: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED;
418:
419: l_pra_rec pra_cur%ROWTYPE;
420: l_attr_count NUMBER := 0;
421: l_attr_flag BOOLEAN := FALSE;

Line 505: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

501: L_MAINT_DYN_SRC_VER VARCHAR2(1) := NVL(Fnd_Profile.value('QP_MAINTAIN_DYNAMIC_SOURCE_VERSIONS'),'N'); -- 13638721
502: l_pkg_ver VARCHAR2(10);
503: BEGIN
504:
505: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
506: l_formula_start_time := dbms_utility.get_time;
507:
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509:

Line 511: QP_PREQ_GRP.engine_debug('Start Formula...');

507:
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509:
510: IF l_debug = FND_API.G_TRUE THEN
511: QP_PREQ_GRP.engine_debug('Start Formula...');
512: END IF;
513:
514: --added for formula messages
515: SELECT name

Line 577: QP_PREQ_GRP.engine_debug('Before populating plsql table of formula lines');

573: --process all factors before for bug 10273166 smbalara START
574: -- Now Process all Factor Lists in the formula
575:
576: IF l_debug = FND_API.G_TRUE THEN
577: QP_PREQ_GRP.engine_debug('Before populating plsql table of formula lines');
578:
579: END IF;
580: --Populate l_formula_line_tbl for all factor lists in the formula
581: FOR l_factors_rec IN factors_cur (p_price_formula_id, p_line_index,

Line 587: QP_PREQ_GRP.engine_debug('enter factors_cur loop -step number -'||l_factors_rec.step_number);

583: LOOP
584: --l_Operand_Tbl(l_factors_rec.step_number):= null;--10273166,commented for 11898355
585:
586: IF l_debug = FND_API.G_TRUE THEN
587: QP_PREQ_GRP.engine_debug('enter factors_cur loop -step number -'||l_factors_rec.step_number);
588:
589: END IF;
590: IF l_skip_factor AND
591: l_factors_rec.step_number = l_old_step_number

Line 598: QP_PREQ_GRP.engine_debug('after skip check ');

594: GOTO factors_loop;
595: END IF;
596:
597: IF l_debug = FND_API.G_TRUE THEN
598: QP_PREQ_GRP.engine_debug('after skip check ');
599: QP_PREQ_GRP.engine_debug('l_factors_rec.step_number:'||l_factors_rec.step_number);--11898355
600: QP_PREQ_GRP.engine_debug('l_old_step_number:'|| l_old_step_number);--11898355
601: QP_PREQ_GRP.engine_debug('l_factors_rec.group_count :'|| l_factors_rec.group_count );--11898355
602: END IF;

Line 599: QP_PREQ_GRP.engine_debug('l_factors_rec.step_number:'||l_factors_rec.step_number);--11898355

595: END IF;
596:
597: IF l_debug = FND_API.G_TRUE THEN
598: QP_PREQ_GRP.engine_debug('after skip check ');
599: QP_PREQ_GRP.engine_debug('l_factors_rec.step_number:'||l_factors_rec.step_number);--11898355
600: QP_PREQ_GRP.engine_debug('l_old_step_number:'|| l_old_step_number);--11898355
601: QP_PREQ_GRP.engine_debug('l_factors_rec.group_count :'|| l_factors_rec.group_count );--11898355
602: END IF;
603: l_skip_factor := FALSE;

Line 600: QP_PREQ_GRP.engine_debug('l_old_step_number:'|| l_old_step_number);--11898355

596:
597: IF l_debug = FND_API.G_TRUE THEN
598: QP_PREQ_GRP.engine_debug('after skip check ');
599: QP_PREQ_GRP.engine_debug('l_factors_rec.step_number:'||l_factors_rec.step_number);--11898355
600: QP_PREQ_GRP.engine_debug('l_old_step_number:'|| l_old_step_number);--11898355
601: QP_PREQ_GRP.engine_debug('l_factors_rec.group_count :'|| l_factors_rec.group_count );--11898355
602: END IF;
603: l_skip_factor := FALSE;
604:

Line 601: QP_PREQ_GRP.engine_debug('l_factors_rec.group_count :'|| l_factors_rec.group_count );--11898355

597: IF l_debug = FND_API.G_TRUE THEN
598: QP_PREQ_GRP.engine_debug('after skip check ');
599: QP_PREQ_GRP.engine_debug('l_factors_rec.step_number:'||l_factors_rec.step_number);--11898355
600: QP_PREQ_GRP.engine_debug('l_old_step_number:'|| l_old_step_number);--11898355
601: QP_PREQ_GRP.engine_debug('l_factors_rec.group_count :'|| l_factors_rec.group_count );--11898355
602: END IF;
603: l_skip_factor := FALSE;
604:
605: --If no attributes with search_ind = 2 then no need to open sub_factors_cur

Line 629: QP_PREQ_GRP.engine_debug('In factors_cur, step = ' ||l_factors_rec.step_number);

625: l_formula_line_tbl(l_factors_rec.step_number).list_line_type_code :=
626: p_list_line_type_code;
627:
628: IF l_debug = FND_API.G_TRUE THEN
629: QP_PREQ_GRP.engine_debug('In factors_cur, step = ' ||l_factors_rec.step_number);
630: QP_PREQ_GRP.engine_debug('Factor evaluated to = '||l_formula_line_tbl(l_factors_rec.step_number).component_value); --10273166
631: END IF;
632: l_skip_factor := TRUE;
633:

Line 630: QP_PREQ_GRP.engine_debug('Factor evaluated to = '||l_formula_line_tbl(l_factors_rec.step_number).component_value); --10273166

626: p_list_line_type_code;
627:
628: IF l_debug = FND_API.G_TRUE THEN
629: QP_PREQ_GRP.engine_debug('In factors_cur, step = ' ||l_factors_rec.step_number);
630: QP_PREQ_GRP.engine_debug('Factor evaluated to = '||l_formula_line_tbl(l_factors_rec.step_number).component_value); --10273166
631: END IF;
632: l_skip_factor := TRUE;
633:
634: --added for formula messages

Line 639: QP_PREQ_GRP.engine_debug('sub factors check1 ');--11898355

635: l_null_step_number_tbl.DELETE(l_factors_rec.step_number);
636:
637: ELSE --If l_factors_rec.group_count > 0
638: IF l_debug = FND_API.G_TRUE THEN
639: QP_PREQ_GRP.engine_debug('sub factors check1 ');--11898355
640: END IF;
641: --sub_factors_cur has to be fetched to determine if all attributes match
642: OPEN sub_factors_cur(p_price_formula_id,
643: p_line_index,

Line 653: QP_PREQ_GRP.engine_debug('sub factors check2 ');--11898355

649: INTO l_sub_factors_rec;
650:
651: IF sub_factors_cur%FOUND THEN
652: IF l_debug = FND_API.G_TRUE THEN
653: QP_PREQ_GRP.engine_debug('sub factors check2 ');--11898355
654: END IF;
655: l_formula_line_tbl(l_factors_rec.step_number).component_value :=
656: l_factors_rec.operand;
657:

Line 676: QP_PREQ_GRP.engine_debug('In sub_factors_cur, step = ' ||l_factors_rec.step_number);

672: l_formula_line_tbl(l_factors_rec.step_number).list_line_type_code :=
673: p_list_line_type_code;
674:
675: IF l_debug = FND_API.G_TRUE THEN
676: QP_PREQ_GRP.engine_debug('In sub_factors_cur, step = ' ||l_factors_rec.step_number);
677: QP_PREQ_GRP.engine_debug('Sub Factor evaluated to = '||l_formula_line_tbl(l_factors_rec.step_number).component_value); --10273166
678: END IF;
679: l_skip_factor := TRUE;
680:

Line 677: QP_PREQ_GRP.engine_debug('Sub Factor evaluated to = '||l_formula_line_tbl(l_factors_rec.step_number).component_value); --10273166

673: p_list_line_type_code;
674:
675: IF l_debug = FND_API.G_TRUE THEN
676: QP_PREQ_GRP.engine_debug('In sub_factors_cur, step = ' ||l_factors_rec.step_number);
677: QP_PREQ_GRP.engine_debug('Sub Factor evaluated to = '||l_formula_line_tbl(l_factors_rec.step_number).component_value); --10273166
678: END IF;
679: l_skip_factor := TRUE;
680:
681: l_null_step_number_tbl.DELETE(l_factors_rec.step_number);

Line 686: QP_PREQ_GRP.engine_debug('sub factors check3 ');--11898355

682: END IF;--sub_factors_cur%FOUND
683:
684: CLOSE sub_factors_cur;
685: IF l_debug = FND_API.G_TRUE THEN
686: QP_PREQ_GRP.engine_debug('sub factors check3 ');--11898355
687: END IF;
688: END IF; --If l_factors_rec.group_count = 0
689:
690: l_old_step_number := l_factors_rec.step_number;

Line 692: QP_PREQ_GRP.engine_debug('factors check end');--11898355

688: END IF; --If l_factors_rec.group_count = 0
689:
690: l_old_step_number := l_factors_rec.step_number;
691: IF l_debug = FND_API.G_TRUE THEN
692: QP_PREQ_GRP.engine_debug('factors check end');--11898355
693: END IF;
694:
695: <>
696: null;

Line 699: QP_PREQ_GRP.engine_debug('exit factors_cur loop');

695: <>
696: null;
697:
698: IF l_debug = FND_API.G_TRUE THEN
699: QP_PREQ_GRP.engine_debug('exit factors_cur loop');
700:
701: END IF;
702: END LOOP; --Loop over factors_cur
703:

Line 705: QP_PREQ_GRP.engine_debug('After populating plsql table of formula lines');

701: END IF;
702: END LOOP; --Loop over factors_cur
703:
704: IF l_debug = FND_API.G_TRUE THEN
705: QP_PREQ_GRP.engine_debug('After populating plsql table of formula lines');
706:
707: END IF;
708: --process all factors before for bug 10273166 smbalara END
709:

Line 720: QP_PREQ_GRP.engine_debug('Formula Line Type = NUM, Step = '|| l_rec.step_number

716:
717: IF l_rec.price_formula_line_type_code = 'NUM' THEN
718:
719: IF l_debug = FND_API.G_TRUE THEN
720: QP_PREQ_GRP.engine_debug('Formula Line Type = NUM, Step = '|| l_rec.step_number
721: || ', Value = ' || l_rec.numeric_constant);
722: END IF;
723: l_formula_line_tbl(l_rec.step_number).component_value :=
724: l_rec.numeric_constant;

Line 742: QP_PREQ_GRP.engine_debug('Formula Line Type = LP, Step = ' || l_rec.step_number

738:
739: ELSIF l_rec.price_formula_line_type_code = 'LP' THEN
740:
741: IF l_debug = FND_API.G_TRUE THEN
742: QP_PREQ_GRP.engine_debug('Formula Line Type = LP, Step = ' || l_rec.step_number
743: || ', Value = '|| p_list_price);
744: END IF;
745: l_formula_line_tbl(l_rec.step_number).component_value := p_list_price;
746:

Line 767: QP_PREQ_GRP.engine_debug('Formula Line Type = MV, Step = ' || l_rec.step_number || ', Value = '|| p_modifier_value);

763:
764: ELSIF l_rec.price_formula_line_type_code = 'MV' THEN
765:
766: IF l_debug = FND_API.G_TRUE THEN
767: QP_PREQ_GRP.engine_debug('Formula Line Type = MV, Step = ' || l_rec.step_number || ', Value = '|| p_modifier_value);
768:
769: END IF;
770: l_formula_line_tbl(l_rec.step_number).component_value := p_modifier_value;
771:

Line 793: QP_PREQ_GRP.engine_debug('Formula Line Type = FUNC, Step = ' ||l_rec.step_number);

789:
790: ELSIF l_rec.price_formula_line_type_code = 'FUNC' THEN
791:
792: IF l_debug = FND_API.G_TRUE THEN
793: QP_PREQ_GRP.engine_debug('Formula Line Type = FUNC, Step = ' ||l_rec.step_number);
794: END IF;
795: l_customized := FND_PROFILE.VALUE('QP_GET_CUSTOM_PRICE_CUSTOMIZED');
796: IF l_customized = 'Y' THEN
797: IF l_debug = FND_API.G_TRUE THEN

Line 798: QP_PREQ_GRP.engine_debug('l_customized is Y');

794: END IF;
795: l_customized := FND_PROFILE.VALUE('QP_GET_CUSTOM_PRICE_CUSTOMIZED');
796: IF l_customized = 'Y' THEN
797: IF l_debug = FND_API.G_TRUE THEN
798: QP_PREQ_GRP.engine_debug('l_customized is Y');
799:
800: END IF;
801: --Populate l_req_line_attrs_tbl
802: -- Bug 2772214, Added If condition

Line 866: QP_PREQ_GRP.engine_debug('Formula Line Type = PRA, Step = ' ||l_rec.step_number);

862:
863: ELSIF l_rec.price_formula_line_type_code = 'PRA' THEN
864:
865: IF l_debug = FND_API.G_TRUE THEN
866: QP_PREQ_GRP.engine_debug('Formula Line Type = PRA, Step = ' ||l_rec.step_number);
867:
868: END IF;
869: OPEN pra_cur(l_rec.pricing_attribute_context, l_rec.pricing_attribute,
870: p_line_index);

Line 878: QP_PREQ_GRP.engine_debug('l_pra_rec.value_from = '||l_pra_rec.value_from);

874: --Return the matching pricing attribute value that is found.
875: BEGIN
876: -- bug 2195879
877: IF l_debug = FND_API.G_TRUE THEN
878: QP_PREQ_GRP.engine_debug('l_pra_rec.value_from = '||l_pra_rec.value_from);
879: END IF;
880: l_formula_line_tbl(l_rec.step_number).component_value :=
881: qp_number.canonical_to_number(l_pra_rec.value_from);
882:

Line 886: QP_PREQ_GRP.engine_debug('Just after pra cur value from to number conversion');

882:
883: l_Operand_Tbl(l_rec.step_number) := l_formula_line_tbl(l_rec.step_number).component_value;
884:
885: IF l_debug = FND_API.G_TRUE THEN
886: QP_PREQ_GRP.engine_debug('Just after pra cur value from to number conversion');
887: END IF;
888: EXCEPTION
889: WHEN OTHERS THEN
890: x_return_status := FND_API.G_RET_STS_ERROR;

Line 892: QP_PREQ_GRP.engine_debug('Error converting PRA value to number');

888: EXCEPTION
889: WHEN OTHERS THEN
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: IF l_debug = FND_API.G_TRUE THEN
892: QP_PREQ_GRP.engine_debug('Error converting PRA value to number');
893: END IF;
894: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
895: THEN
896: RAISE E_INVALID_NUMBER;

Line 924: QP_PREQ_GRP.engine_debug('Formula Line Type = PLL, Step = ' ||l_rec.step_number);

920:
921: ELSIF l_rec.price_formula_line_type_code = 'PLL' THEN
922:
923: IF l_debug = FND_API.G_TRUE THEN
924: QP_PREQ_GRP.engine_debug('Formula Line Type = PLL, Step = ' ||l_rec.step_number);
925: END IF;
926: /*
927: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.sel2,QP_LIST_LINES_PK,LIST_LINE_ID,1
928: */

Line 959: QP_PREQ_GRP.engine_debug('Formula Line Type = ML, Step = ' ||l_rec.step_number);

955:
956: ELSIF l_rec.price_formula_line_type_code = 'ML' THEN
957:
958: IF l_debug = FND_API.G_TRUE THEN
959: QP_PREQ_GRP.engine_debug('Formula Line Type = ML, Step = ' ||l_rec.step_number);
960: END IF;
961: --null; --Do nothing here. All factor lists will be processed together later
962: --l_Operand_Tbl(l_rec.step_number) :=null;----6726052,7249280 smbalara 10273166-commenting as factor list is processed above
963: --added for formula messages

Line 988: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN

984: END IF; -- IF stmt comparing price_formula_line_type_code to various values.
985: l_req_line_attrs_tbl.delete; --3531890 attribute were getting accumulated for every step
986: -- smbalara bug 7188211
987: --Based on a profile option,formula step values will be inserted into qp_nformula_step_values_tmp
988: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
989: IF l_debug = FND_API.G_TRUE THEN
990: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
991: QP_PREQ_GRP.engine_debug('Value price_formula_id ='||l_formula_line_tbl(l_rec.step_number).price_formula_id );
992: QP_PREQ_GRP.engine_debug('Value step_number ='||l_formula_line_tbl(l_rec.step_number).step_number );

Line 990: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');

986: -- smbalara bug 7188211
987: --Based on a profile option,formula step values will be inserted into qp_nformula_step_values_tmp
988: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
989: IF l_debug = FND_API.G_TRUE THEN
990: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
991: QP_PREQ_GRP.engine_debug('Value price_formula_id ='||l_formula_line_tbl(l_rec.step_number).price_formula_id );
992: QP_PREQ_GRP.engine_debug('Value step_number ='||l_formula_line_tbl(l_rec.step_number).step_number );
993: QP_PREQ_GRP.engine_debug('Value component_value ='||l_formula_line_tbl(l_rec.step_number).component_value );
994: QP_PREQ_GRP.engine_debug('Value price_formula_line_type_code='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );

Line 991: QP_PREQ_GRP.engine_debug('Value price_formula_id ='||l_formula_line_tbl(l_rec.step_number).price_formula_id );

987: --Based on a profile option,formula step values will be inserted into qp_nformula_step_values_tmp
988: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
989: IF l_debug = FND_API.G_TRUE THEN
990: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
991: QP_PREQ_GRP.engine_debug('Value price_formula_id ='||l_formula_line_tbl(l_rec.step_number).price_formula_id );
992: QP_PREQ_GRP.engine_debug('Value step_number ='||l_formula_line_tbl(l_rec.step_number).step_number );
993: QP_PREQ_GRP.engine_debug('Value component_value ='||l_formula_line_tbl(l_rec.step_number).component_value );
994: QP_PREQ_GRP.engine_debug('Value price_formula_line_type_code='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
995: QP_PREQ_GRP.engine_debug('Value line_index ='||l_formula_line_tbl(l_rec.step_number).line_index );

Line 992: QP_PREQ_GRP.engine_debug('Value step_number ='||l_formula_line_tbl(l_rec.step_number).step_number );

988: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
989: IF l_debug = FND_API.G_TRUE THEN
990: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
991: QP_PREQ_GRP.engine_debug('Value price_formula_id ='||l_formula_line_tbl(l_rec.step_number).price_formula_id );
992: QP_PREQ_GRP.engine_debug('Value step_number ='||l_formula_line_tbl(l_rec.step_number).step_number );
993: QP_PREQ_GRP.engine_debug('Value component_value ='||l_formula_line_tbl(l_rec.step_number).component_value );
994: QP_PREQ_GRP.engine_debug('Value price_formula_line_type_code='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
995: QP_PREQ_GRP.engine_debug('Value line_index ='||l_formula_line_tbl(l_rec.step_number).line_index );
996: QP_PREQ_GRP.engine_debug('Value list_line_type_code ='||l_formula_line_tbl(l_rec.step_number).list_line_type_code );

Line 993: QP_PREQ_GRP.engine_debug('Value component_value ='||l_formula_line_tbl(l_rec.step_number).component_value );

989: IF l_debug = FND_API.G_TRUE THEN
990: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
991: QP_PREQ_GRP.engine_debug('Value price_formula_id ='||l_formula_line_tbl(l_rec.step_number).price_formula_id );
992: QP_PREQ_GRP.engine_debug('Value step_number ='||l_formula_line_tbl(l_rec.step_number).step_number );
993: QP_PREQ_GRP.engine_debug('Value component_value ='||l_formula_line_tbl(l_rec.step_number).component_value );
994: QP_PREQ_GRP.engine_debug('Value price_formula_line_type_code='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
995: QP_PREQ_GRP.engine_debug('Value line_index ='||l_formula_line_tbl(l_rec.step_number).line_index );
996: QP_PREQ_GRP.engine_debug('Value list_line_type_code ='||l_formula_line_tbl(l_rec.step_number).list_line_type_code );
997: QP_PREQ_GRP.engine_debug('Value list_header_id ='||l_formula_line_tbl(l_rec.step_number).list_header_id );

Line 994: QP_PREQ_GRP.engine_debug('Value price_formula_line_type_code='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );

990: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
991: QP_PREQ_GRP.engine_debug('Value price_formula_id ='||l_formula_line_tbl(l_rec.step_number).price_formula_id );
992: QP_PREQ_GRP.engine_debug('Value step_number ='||l_formula_line_tbl(l_rec.step_number).step_number );
993: QP_PREQ_GRP.engine_debug('Value component_value ='||l_formula_line_tbl(l_rec.step_number).component_value );
994: QP_PREQ_GRP.engine_debug('Value price_formula_line_type_code='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
995: QP_PREQ_GRP.engine_debug('Value line_index ='||l_formula_line_tbl(l_rec.step_number).line_index );
996: QP_PREQ_GRP.engine_debug('Value list_line_type_code ='||l_formula_line_tbl(l_rec.step_number).list_line_type_code );
997: QP_PREQ_GRP.engine_debug('Value list_header_id ='||l_formula_line_tbl(l_rec.step_number).list_header_id );
998: QP_PREQ_GRP.engine_debug('Value list_line_id ='||l_formula_line_tbl(l_rec.step_number).list_line_id );

Line 995: QP_PREQ_GRP.engine_debug('Value line_index ='||l_formula_line_tbl(l_rec.step_number).line_index );

991: QP_PREQ_GRP.engine_debug('Value price_formula_id ='||l_formula_line_tbl(l_rec.step_number).price_formula_id );
992: QP_PREQ_GRP.engine_debug('Value step_number ='||l_formula_line_tbl(l_rec.step_number).step_number );
993: QP_PREQ_GRP.engine_debug('Value component_value ='||l_formula_line_tbl(l_rec.step_number).component_value );
994: QP_PREQ_GRP.engine_debug('Value price_formula_line_type_code='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
995: QP_PREQ_GRP.engine_debug('Value line_index ='||l_formula_line_tbl(l_rec.step_number).line_index );
996: QP_PREQ_GRP.engine_debug('Value list_line_type_code ='||l_formula_line_tbl(l_rec.step_number).list_line_type_code );
997: QP_PREQ_GRP.engine_debug('Value list_header_id ='||l_formula_line_tbl(l_rec.step_number).list_header_id );
998: QP_PREQ_GRP.engine_debug('Value list_line_id ='||l_formula_line_tbl(l_rec.step_number).list_line_id );
999: END IF;

Line 996: QP_PREQ_GRP.engine_debug('Value list_line_type_code ='||l_formula_line_tbl(l_rec.step_number).list_line_type_code );

992: QP_PREQ_GRP.engine_debug('Value step_number ='||l_formula_line_tbl(l_rec.step_number).step_number );
993: QP_PREQ_GRP.engine_debug('Value component_value ='||l_formula_line_tbl(l_rec.step_number).component_value );
994: QP_PREQ_GRP.engine_debug('Value price_formula_line_type_code='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
995: QP_PREQ_GRP.engine_debug('Value line_index ='||l_formula_line_tbl(l_rec.step_number).line_index );
996: QP_PREQ_GRP.engine_debug('Value list_line_type_code ='||l_formula_line_tbl(l_rec.step_number).list_line_type_code );
997: QP_PREQ_GRP.engine_debug('Value list_header_id ='||l_formula_line_tbl(l_rec.step_number).list_header_id );
998: QP_PREQ_GRP.engine_debug('Value list_line_id ='||l_formula_line_tbl(l_rec.step_number).list_line_id );
999: END IF;
1000:

Line 997: QP_PREQ_GRP.engine_debug('Value list_header_id ='||l_formula_line_tbl(l_rec.step_number).list_header_id );

993: QP_PREQ_GRP.engine_debug('Value component_value ='||l_formula_line_tbl(l_rec.step_number).component_value );
994: QP_PREQ_GRP.engine_debug('Value price_formula_line_type_code='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
995: QP_PREQ_GRP.engine_debug('Value line_index ='||l_formula_line_tbl(l_rec.step_number).line_index );
996: QP_PREQ_GRP.engine_debug('Value list_line_type_code ='||l_formula_line_tbl(l_rec.step_number).list_line_type_code );
997: QP_PREQ_GRP.engine_debug('Value list_header_id ='||l_formula_line_tbl(l_rec.step_number).list_header_id );
998: QP_PREQ_GRP.engine_debug('Value list_line_id ='||l_formula_line_tbl(l_rec.step_number).list_line_id );
999: END IF;
1000:
1001: INSERT INTO qp_nformula_step_values_tmp

Line 998: QP_PREQ_GRP.engine_debug('Value list_line_id ='||l_formula_line_tbl(l_rec.step_number).list_line_id );

994: QP_PREQ_GRP.engine_debug('Value price_formula_line_type_code='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
995: QP_PREQ_GRP.engine_debug('Value line_index ='||l_formula_line_tbl(l_rec.step_number).line_index );
996: QP_PREQ_GRP.engine_debug('Value list_line_type_code ='||l_formula_line_tbl(l_rec.step_number).list_line_type_code );
997: QP_PREQ_GRP.engine_debug('Value list_header_id ='||l_formula_line_tbl(l_rec.step_number).list_header_id );
998: QP_PREQ_GRP.engine_debug('Value list_line_id ='||l_formula_line_tbl(l_rec.step_number).list_line_id );
999: END IF;
1000:
1001: INSERT INTO qp_nformula_step_values_tmp
1002: (price_formula_id,

Line 1022: QP_PREQ_GRP.engine_debug('After populating formula step values temp table');

1018: l_formula_line_tbl(l_rec.step_number).list_header_id,
1019: l_formula_line_tbl(l_rec.step_number).list_line_id
1020: );
1021: IF l_debug = FND_API.G_TRUE THEN
1022: QP_PREQ_GRP.engine_debug('After populating formula step values temp table');
1023: END IF;
1024: END IF;
1025: -- smbalara bug 7188211
1026: END LOOP; --Loop over formula_lines_cur

Line 1034: QP_PREQ_GRP.engine_debug('Before populating plsql table of formula lines');

1030: --commenting below for bug 10273166 smbalara START
1031: -- Now Process all Factor Lists in the formula
1032:
1033: /* IF l_debug = FND_API.G_TRUE THEN
1034: QP_PREQ_GRP.engine_debug('Before populating plsql table of formula lines');
1035:
1036: END IF;
1037: --Populate l_formula_line_tbl for all factor lists in the formula
1038: FOR l_factors_rec IN factors_cur (p_price_formula_id, p_line_index,

Line 1043: QP_PREQ_GRP.engine_debug('enter factors_cur loop');

1039: p_price_effective_date)
1040: LOOP
1041:
1042: IF l_debug = FND_API.G_TRUE THEN
1043: QP_PREQ_GRP.engine_debug('enter factors_cur loop');
1044:
1045: END IF;
1046: IF l_skip_factor AND
1047: l_factors_rec.step_number = l_old_step_number

Line 1054: QP_PREQ_GRP.engine_debug('after skip check ');

1050: GOTO factors_loop;
1051: END IF;
1052:
1053: IF l_debug = FND_API.G_TRUE THEN
1054: QP_PREQ_GRP.engine_debug('after skip check ');
1055:
1056: END IF;
1057: l_skip_factor := FALSE;
1058:

Line 1083: QP_PREQ_GRP.engine_debug('In factors_cur, step = ' ||l_factors_rec.step_number);

1079: l_formula_line_tbl(l_factors_rec.step_number).list_line_type_code :=
1080: p_list_line_type_code;
1081:
1082: IF l_debug = FND_API.G_TRUE THEN
1083: QP_PREQ_GRP.engine_debug('In factors_cur, step = ' ||l_factors_rec.step_number);
1084:
1085: END IF;
1086: l_skip_factor := TRUE;
1087:

Line 1125: QP_PREQ_GRP.engine_debug('In sub_factors_cur, step = ' ||l_factors_rec.step_number);

1121: l_formula_line_tbl(l_factors_rec.step_number).list_line_type_code :=
1122: p_list_line_type_code;
1123:
1124: IF l_debug = FND_API.G_TRUE THEN
1125: QP_PREQ_GRP.engine_debug('In sub_factors_cur, step = ' ||l_factors_rec.step_number);
1126:
1127: END IF;
1128: l_skip_factor := TRUE;
1129:

Line 1143: QP_PREQ_GRP.engine_debug('exit factors_cur loop');

1139: <>
1140: null;
1141:
1142: IF l_debug = FND_API.G_TRUE THEN
1143: QP_PREQ_GRP.engine_debug('exit factors_cur loop');
1144:
1145: END IF;
1146: END LOOP; --Loop over factors_cur
1147:

Line 1149: QP_PREQ_GRP.engine_debug('After populating plsql table of formula lines');

1145: END IF;
1146: END LOOP; --Loop over factors_cur
1147:
1148: IF l_debug = FND_API.G_TRUE THEN
1149: QP_PREQ_GRP.engine_debug('After populating plsql table of formula lines');
1150:
1151: END IF;*/
1152: --commenting above for bug 10273166 smbalara END
1153: --Based on a profile option, loop over plsql table of formula lines to

Line 1156: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN

1152: --commenting above for bug 10273166 smbalara END
1153: --Based on a profile option, loop over plsql table of formula lines to
1154: --populate qp_nformula_step_values_tmp table
1155: /* commented for bug 7188211 - temp table insert moved above
1156: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
1157:
1158: IF l_debug = FND_API.G_TRUE THEN
1159: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
1160:

Line 1159: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');

1155: /* commented for bug 7188211 - temp table insert moved above
1156: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
1157:
1158: IF l_debug = FND_API.G_TRUE THEN
1159: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
1160:
1161: END IF;
1162: i:= l_formula_line_tbl.FIRST; --set loop index to first element in plsql tbl
1163:

Line 1198: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));

1194:
1195: EXCEPTION
1196: WHEN OTHERS THEN
1197: IF l_debug = FND_API.G_TRUE THEN
1198: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
1199: END IF;
1200: END;
1201:
1202: i := l_formula_line_tbl.NEXT(i);--set i to next notnull position in plsql

Line 1207: QP_PREQ_GRP.engine_debug('After populating formula step values temp table');

1203:
1204: END LOOP; --loop over l_formula_line_tbl
1205:
1206: IF l_debug = FND_API.G_TRUE THEN
1207: QP_PREQ_GRP.engine_debug('After populating formula step values temp table');
1208:
1209: END IF;
1210: END IF; --If profile option is set
1211: commented for bug 7188211*/

Line 1213: QP_PREQ_GRP.engine_debug('Before Calling - QP_BUILD_FORMULA_RULES.Get_Formula_Values');

1209: END IF;
1210: END IF; --If profile option is set
1211: commented for bug 7188211*/
1212: IF l_debug = FND_API.G_TRUE THEN
1213: QP_PREQ_GRP.engine_debug('Before Calling - QP_BUILD_FORMULA_RULES.Get_Formula_Values');
1214: QP_PREQ_GRP.engine_debug('For Formula : '||l_formula);----6726052,7249280 smbalara
1215: QP_PREQ_GRP.engine_debug('Maintain Dynamic pkgs profile is :'||L_MAINT_DYN_SRC_VER);
1216: END IF;
1217: -- 13638721

Line 1214: QP_PREQ_GRP.engine_debug('For Formula : '||l_formula);----6726052,7249280 smbalara

1210: END IF; --If profile option is set
1211: commented for bug 7188211*/
1212: IF l_debug = FND_API.G_TRUE THEN
1213: QP_PREQ_GRP.engine_debug('Before Calling - QP_BUILD_FORMULA_RULES.Get_Formula_Values');
1214: QP_PREQ_GRP.engine_debug('For Formula : '||l_formula);----6726052,7249280 smbalara
1215: QP_PREQ_GRP.engine_debug('Maintain Dynamic pkgs profile is :'||L_MAINT_DYN_SRC_VER);
1216: END IF;
1217: -- 13638721
1218: IF (L_MAINT_DYN_SRC_VER='N') THEN

Line 1215: QP_PREQ_GRP.engine_debug('Maintain Dynamic pkgs profile is :'||L_MAINT_DYN_SRC_VER);

1211: commented for bug 7188211*/
1212: IF l_debug = FND_API.G_TRUE THEN
1213: QP_PREQ_GRP.engine_debug('Before Calling - QP_BUILD_FORMULA_RULES.Get_Formula_Values');
1214: QP_PREQ_GRP.engine_debug('For Formula : '||l_formula);----6726052,7249280 smbalara
1215: QP_PREQ_GRP.engine_debug('Maintain Dynamic pkgs profile is :'||L_MAINT_DYN_SRC_VER);
1216: END IF;
1217: -- 13638721
1218: IF (L_MAINT_DYN_SRC_VER='N') THEN
1219: QP_BUILD_FORMULA_RULES.Get_Formula_Values(l_formula,

Line 1228: QP_PREQ_GRP.engine_debug('1. found row in qp_params for code BLD_FORMULA_ACTV_VER pkg ver : ' || l_pkg_ver);

1224: ELSE
1225: BEGIN
1226: SELECT SEEDED_VALUE INTO l_pkg_ver FROM qp_parameters_b WHERE PARAMETER_CODE='BLD_FORMULA_ACTV_VER' AND ROWNUM=1;
1227: IF l_debug = FND_API.G_TRUE THEN
1228: QP_PREQ_GRP.engine_debug('1. found row in qp_params for code BLD_FORMULA_ACTV_VER pkg ver : ' || l_pkg_ver);
1229: END IF;
1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: l_pkg_ver:='0';

Line 1234: QP_PREQ_GRP.engine_debug('1. when others row in qp_params for code BLD_FORMULA_ACTV_VER pkg ver: ' || l_pkg_ver);

1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: l_pkg_ver:='0';
1233: IF l_debug = FND_API.G_TRUE THEN
1234: QP_PREQ_GRP.engine_debug('1. when others row in qp_params for code BLD_FORMULA_ACTV_VER pkg ver: ' || l_pkg_ver);
1235: END IF;
1236: END;
1237: IF (l_pkg_ver='5') THEN
1238: QP_BUILD_FORMULA_RULES5.Get_Formula_Values(l_formula,

Line 1278: QP_PREQ_GRP.engine_debug('After Calling - QP_BUILD_FORMULA_RULES.Get_Formula_Values');

1274: END IF;
1275: -- 13638721
1276:
1277: IF l_debug = FND_API.G_TRUE THEN
1278: QP_PREQ_GRP.engine_debug('After Calling - QP_BUILD_FORMULA_RULES.Get_Formula_Values');
1279:
1280: QP_PREQ_GRP.engine_debug('Return Status from Get_Formula_Values ' || l_return_status);
1281:
1282: END IF;

Line 1280: QP_PREQ_GRP.engine_debug('Return Status from Get_Formula_Values ' || l_return_status);

1276:
1277: IF l_debug = FND_API.G_TRUE THEN
1278: QP_PREQ_GRP.engine_debug('After Calling - QP_BUILD_FORMULA_RULES.Get_Formula_Values');
1279:
1280: QP_PREQ_GRP.engine_debug('Return Status from Get_Formula_Values ' || l_return_status);
1281:
1282: END IF;
1283: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) OR (l_formula_value IS NULL) THEN
1284: l_formula_value := Select_From_Dual(l_formula, l_operand_tbl);

Line 1300: QP_PREQ_GRP.engine_debug('Formula evaluated to ' || l_formula_value);

1296:
1297: END IF;
1298:
1299: IF l_debug = FND_API.G_TRUE THEN
1300: QP_PREQ_GRP.engine_debug('Formula evaluated to ' || l_formula_value);
1301:
1302: QP_PREQ_GRP.engine_debug('Formula Return Status ' || l_return_status);
1303:
1304: END IF;

Line 1302: QP_PREQ_GRP.engine_debug('Formula Return Status ' || l_return_status);

1298:
1299: IF l_debug = FND_API.G_TRUE THEN
1300: QP_PREQ_GRP.engine_debug('Formula evaluated to ' || l_formula_value);
1301:
1302: QP_PREQ_GRP.engine_debug('Formula Return Status ' || l_return_status);
1303:
1304: END IF;
1305: l_formula_line_tbl.DELETE; --Clear the temp table table
1306:

Line 1311: QP_PREQ_GRP.engine_debug('##### Total Time in QP_FORMULA_PRICE_CALC_PVT(in sec) : ' || l_time_difference || ' #####');

1307: l_formula_end_time := dbms_utility.get_time;
1308: l_time_difference := (l_formula_end_time - l_formula_start_time)/100 ;
1309:
1310: IF l_debug = FND_API.G_TRUE THEN
1311: QP_PREQ_GRP.engine_debug('##### Total Time in QP_FORMULA_PRICE_CALC_PVT(in sec) : ' || l_time_difference || ' #####');
1312:
1313: END IF;
1314: RETURN l_formula_value;
1315: --End more POSCO changes.

Line 1368: QP_PREQ_GRP.engine_debug('Exception '||substr(sqlerrm, 1, 240));

1364: THEN
1365: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_FAILED');
1366: END IF;
1367: IF l_debug = FND_API.G_TRUE THEN
1368: QP_PREQ_GRP.engine_debug('Exception '||substr(sqlerrm, 1, 240));
1369: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||
1370: l_formula_value);
1371: END IF;
1372:

Line 1369: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||

1365: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_FAILED');
1366: END IF;
1367: IF l_debug = FND_API.G_TRUE THEN
1368: QP_PREQ_GRP.engine_debug('Exception '||substr(sqlerrm, 1, 240));
1369: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||
1370: l_formula_value);
1371: END IF;
1372:
1373: l_formula_line_tbl.DELETE; --Clear the temp table table

Line 1384: QP_PREQ_GRP.engine_debug('Unexpected Exception '||substr(sqlerrm, 1, 240));

1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1381:
1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1383: IF l_debug = FND_API.G_TRUE THEN
1384: QP_PREQ_GRP.engine_debug('Unexpected Exception '||substr(sqlerrm, 1, 240));
1385: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||
1386: l_formula_value);
1387:
1388: END IF;

Line 1385: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||

1381:
1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1383: IF l_debug = FND_API.G_TRUE THEN
1384: QP_PREQ_GRP.engine_debug('Unexpected Exception '||substr(sqlerrm, 1, 240));
1385: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||
1386: l_formula_value);
1387:
1388: END IF;
1389: l_formula_line_tbl.DELETE; --Clear the temp table table

Line 1407: QP_PREQ_GRP.engine_debug('Other Exception '||substr(sqlerrm, 1, 240));

1403: 'Calculate:'||sqlerrm);
1404: END IF;
1405:
1406: IF l_debug = FND_API.G_TRUE THEN
1407: QP_PREQ_GRP.engine_debug('Other Exception '||substr(sqlerrm, 1, 240));
1408: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||
1409: l_formula_value);
1410:
1411: END IF;

Line 1408: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||

1404: END IF;
1405:
1406: IF l_debug = FND_API.G_TRUE THEN
1407: QP_PREQ_GRP.engine_debug('Other Exception '||substr(sqlerrm, 1, 240));
1408: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||
1409: l_formula_value);
1410:
1411: END IF;
1412: l_formula_line_tbl.DELETE; --Clear the temp table table