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 332: AND t.pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED

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

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

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

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

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

Line 415: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED;

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

Line 502: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

498: l_formula_name qp_price_formulas_tl.name%TYPE;
499:
500: BEGIN
501:
502: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
503: l_formula_start_time := dbms_utility.get_time;
504:
505: x_return_status := FND_API.G_RET_STS_SUCCESS;
506:

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

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

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

569:
570: IF l_rec.price_formula_line_type_code = 'NUM' THEN
571:
572: IF l_debug = FND_API.G_TRUE THEN
573: QP_PREQ_GRP.engine_debug('Formula Line Type = NUM, Step = '|| l_rec.step_number
574: || ', Value = ' || l_rec.numeric_constant);
575: END IF;
576: l_formula_line_tbl(l_rec.step_number).component_value :=
577: l_rec.numeric_constant;

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

591:
592: ELSIF l_rec.price_formula_line_type_code = 'LP' THEN
593:
594: IF l_debug = FND_API.G_TRUE THEN
595: QP_PREQ_GRP.engine_debug('Formula Line Type = LP, Step = ' || l_rec.step_number
596: || ', Value = '|| p_list_price);
597: END IF;
598: l_formula_line_tbl(l_rec.step_number).component_value := p_list_price;
599:

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

616:
617: ELSIF l_rec.price_formula_line_type_code = 'MV' THEN
618:
619: IF l_debug = FND_API.G_TRUE THEN
620: QP_PREQ_GRP.engine_debug('Formula Line Type = MV, Step = ' || l_rec.step_number || ', Value = '|| p_modifier_value);
621:
622: END IF;
623: l_formula_line_tbl(l_rec.step_number).component_value := p_modifier_value;
624:

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

642:
643: ELSIF l_rec.price_formula_line_type_code = 'FUNC' THEN
644:
645: IF l_debug = FND_API.G_TRUE THEN
646: QP_PREQ_GRP.engine_debug('Formula Line Type = FUNC, Step = ' ||l_rec.step_number);
647: END IF;
648: l_customized := FND_PROFILE.VALUE('QP_GET_CUSTOM_PRICE_CUSTOMIZED');
649: IF l_customized = 'Y' THEN
650: IF l_debug = FND_API.G_TRUE THEN

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

647: END IF;
648: l_customized := FND_PROFILE.VALUE('QP_GET_CUSTOM_PRICE_CUSTOMIZED');
649: IF l_customized = 'Y' THEN
650: IF l_debug = FND_API.G_TRUE THEN
651: QP_PREQ_GRP.engine_debug('l_customized is Y');
652:
653: END IF;
654: --Populate l_req_line_attrs_tbl
655: -- Bug 2772214, Added If condition

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

715:
716: ELSIF l_rec.price_formula_line_type_code = 'PRA' THEN
717:
718: IF l_debug = FND_API.G_TRUE THEN
719: QP_PREQ_GRP.engine_debug('Formula Line Type = PRA, Step = ' ||l_rec.step_number);
720:
721: END IF;
722: OPEN pra_cur(l_rec.pricing_attribute_context, l_rec.pricing_attribute,
723: p_line_index);

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

727: --Return the matching pricing attribute value that is found.
728: BEGIN
729: -- bug 2195879
730: IF l_debug = FND_API.G_TRUE THEN
731: QP_PREQ_GRP.engine_debug('l_pra_rec.value_from = '||l_pra_rec.value_from);
732: END IF;
733: l_formula_line_tbl(l_rec.step_number).component_value :=
734: qp_number.canonical_to_number(l_pra_rec.value_from);
735:

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

735:
736: l_Operand_Tbl(l_rec.step_number) := l_formula_line_tbl(l_rec.step_number).component_value;
737:
738: IF l_debug = FND_API.G_TRUE THEN
739: QP_PREQ_GRP.engine_debug('Just after pra cur value from to number conversion');
740: END IF;
741: EXCEPTION
742: WHEN OTHERS THEN
743: x_return_status := FND_API.G_RET_STS_ERROR;

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

741: EXCEPTION
742: WHEN OTHERS THEN
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: IF l_debug = FND_API.G_TRUE THEN
745: QP_PREQ_GRP.engine_debug('Error converting PRA value to number');
746: END IF;
747: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
748: THEN
749: RAISE E_INVALID_NUMBER;

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

773:
774: ELSIF l_rec.price_formula_line_type_code = 'PLL' THEN
775:
776: IF l_debug = FND_API.G_TRUE THEN
777: QP_PREQ_GRP.engine_debug('Formula Line Type = PLL, Step = ' ||l_rec.step_number);
778: END IF;
779: /*
780: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.sel2,QP_LIST_LINES_PK,LIST_LINE_ID,1
781: */

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

808:
809: ELSIF l_rec.price_formula_line_type_code = 'ML' THEN
810:
811: IF l_debug = FND_API.G_TRUE THEN
812: QP_PREQ_GRP.engine_debug('Formula Line Type = ML, Step = ' ||l_rec.step_number);
813: END IF;
814: --null; --Do nothing here. All factor lists will be processed together later
815: l_Operand_Tbl(l_rec.step_number) :=null;----6726052,7249280 smbalara
816: --added for formula messages

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

826: END IF; -- IF stmt comparing price_formula_line_type_code to various values.
827: l_req_line_attrs_tbl.delete; --3531890 attribute were getting accumulated for every step
828: -- smbalara bug 7188211
829: --Based on a profile option,formula step values will be inserted into qp_nformula_step_values_tmp
830: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
831: IF l_debug = FND_API.G_TRUE THEN
832: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
833: QP_PREQ_GRP.engine_debug('Value 1='||l_formula_line_tbl(l_rec.step_number).price_formula_id );
834: QP_PREQ_GRP.engine_debug('Value 2='||l_formula_line_tbl(l_rec.step_number).step_number );

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

828: -- smbalara bug 7188211
829: --Based on a profile option,formula step values will be inserted into qp_nformula_step_values_tmp
830: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
831: IF l_debug = FND_API.G_TRUE THEN
832: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
833: QP_PREQ_GRP.engine_debug('Value 1='||l_formula_line_tbl(l_rec.step_number).price_formula_id );
834: QP_PREQ_GRP.engine_debug('Value 2='||l_formula_line_tbl(l_rec.step_number).step_number );
835: QP_PREQ_GRP.engine_debug('Value 3='||l_formula_line_tbl(l_rec.step_number).component_value );
836: QP_PREQ_GRP.engine_debug('Value 4='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );

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

829: --Based on a profile option,formula step values will be inserted into qp_nformula_step_values_tmp
830: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
831: IF l_debug = FND_API.G_TRUE THEN
832: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
833: QP_PREQ_GRP.engine_debug('Value 1='||l_formula_line_tbl(l_rec.step_number).price_formula_id );
834: QP_PREQ_GRP.engine_debug('Value 2='||l_formula_line_tbl(l_rec.step_number).step_number );
835: QP_PREQ_GRP.engine_debug('Value 3='||l_formula_line_tbl(l_rec.step_number).component_value );
836: QP_PREQ_GRP.engine_debug('Value 4='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
837: QP_PREQ_GRP.engine_debug('Value 5='||l_formula_line_tbl(l_rec.step_number).line_index );

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

830: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
831: IF l_debug = FND_API.G_TRUE THEN
832: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
833: QP_PREQ_GRP.engine_debug('Value 1='||l_formula_line_tbl(l_rec.step_number).price_formula_id );
834: QP_PREQ_GRP.engine_debug('Value 2='||l_formula_line_tbl(l_rec.step_number).step_number );
835: QP_PREQ_GRP.engine_debug('Value 3='||l_formula_line_tbl(l_rec.step_number).component_value );
836: QP_PREQ_GRP.engine_debug('Value 4='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
837: QP_PREQ_GRP.engine_debug('Value 5='||l_formula_line_tbl(l_rec.step_number).line_index );
838: QP_PREQ_GRP.engine_debug('Value 6='||l_formula_line_tbl(l_rec.step_number).list_line_type_code );

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

831: IF l_debug = FND_API.G_TRUE THEN
832: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
833: QP_PREQ_GRP.engine_debug('Value 1='||l_formula_line_tbl(l_rec.step_number).price_formula_id );
834: QP_PREQ_GRP.engine_debug('Value 2='||l_formula_line_tbl(l_rec.step_number).step_number );
835: QP_PREQ_GRP.engine_debug('Value 3='||l_formula_line_tbl(l_rec.step_number).component_value );
836: QP_PREQ_GRP.engine_debug('Value 4='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
837: QP_PREQ_GRP.engine_debug('Value 5='||l_formula_line_tbl(l_rec.step_number).line_index );
838: QP_PREQ_GRP.engine_debug('Value 6='||l_formula_line_tbl(l_rec.step_number).list_line_type_code );
839: QP_PREQ_GRP.engine_debug('Value 7='||l_formula_line_tbl(l_rec.step_number).list_header_id );

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

832: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
833: QP_PREQ_GRP.engine_debug('Value 1='||l_formula_line_tbl(l_rec.step_number).price_formula_id );
834: QP_PREQ_GRP.engine_debug('Value 2='||l_formula_line_tbl(l_rec.step_number).step_number );
835: QP_PREQ_GRP.engine_debug('Value 3='||l_formula_line_tbl(l_rec.step_number).component_value );
836: QP_PREQ_GRP.engine_debug('Value 4='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
837: QP_PREQ_GRP.engine_debug('Value 5='||l_formula_line_tbl(l_rec.step_number).line_index );
838: QP_PREQ_GRP.engine_debug('Value 6='||l_formula_line_tbl(l_rec.step_number).list_line_type_code );
839: QP_PREQ_GRP.engine_debug('Value 7='||l_formula_line_tbl(l_rec.step_number).list_header_id );
840: QP_PREQ_GRP.engine_debug('Value 8='||l_formula_line_tbl(l_rec.step_number).list_line_id );

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

833: QP_PREQ_GRP.engine_debug('Value 1='||l_formula_line_tbl(l_rec.step_number).price_formula_id );
834: QP_PREQ_GRP.engine_debug('Value 2='||l_formula_line_tbl(l_rec.step_number).step_number );
835: QP_PREQ_GRP.engine_debug('Value 3='||l_formula_line_tbl(l_rec.step_number).component_value );
836: QP_PREQ_GRP.engine_debug('Value 4='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
837: QP_PREQ_GRP.engine_debug('Value 5='||l_formula_line_tbl(l_rec.step_number).line_index );
838: QP_PREQ_GRP.engine_debug('Value 6='||l_formula_line_tbl(l_rec.step_number).list_line_type_code );
839: QP_PREQ_GRP.engine_debug('Value 7='||l_formula_line_tbl(l_rec.step_number).list_header_id );
840: QP_PREQ_GRP.engine_debug('Value 8='||l_formula_line_tbl(l_rec.step_number).list_line_id );
841: END IF;

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

834: QP_PREQ_GRP.engine_debug('Value 2='||l_formula_line_tbl(l_rec.step_number).step_number );
835: QP_PREQ_GRP.engine_debug('Value 3='||l_formula_line_tbl(l_rec.step_number).component_value );
836: QP_PREQ_GRP.engine_debug('Value 4='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
837: QP_PREQ_GRP.engine_debug('Value 5='||l_formula_line_tbl(l_rec.step_number).line_index );
838: QP_PREQ_GRP.engine_debug('Value 6='||l_formula_line_tbl(l_rec.step_number).list_line_type_code );
839: QP_PREQ_GRP.engine_debug('Value 7='||l_formula_line_tbl(l_rec.step_number).list_header_id );
840: QP_PREQ_GRP.engine_debug('Value 8='||l_formula_line_tbl(l_rec.step_number).list_line_id );
841: END IF;
842:

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

835: QP_PREQ_GRP.engine_debug('Value 3='||l_formula_line_tbl(l_rec.step_number).component_value );
836: QP_PREQ_GRP.engine_debug('Value 4='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
837: QP_PREQ_GRP.engine_debug('Value 5='||l_formula_line_tbl(l_rec.step_number).line_index );
838: QP_PREQ_GRP.engine_debug('Value 6='||l_formula_line_tbl(l_rec.step_number).list_line_type_code );
839: QP_PREQ_GRP.engine_debug('Value 7='||l_formula_line_tbl(l_rec.step_number).list_header_id );
840: QP_PREQ_GRP.engine_debug('Value 8='||l_formula_line_tbl(l_rec.step_number).list_line_id );
841: END IF;
842:
843: INSERT INTO qp_nformula_step_values_tmp

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

836: QP_PREQ_GRP.engine_debug('Value 4='||l_formula_line_tbl(l_rec.step_number).price_formula_line_type_code );
837: QP_PREQ_GRP.engine_debug('Value 5='||l_formula_line_tbl(l_rec.step_number).line_index );
838: QP_PREQ_GRP.engine_debug('Value 6='||l_formula_line_tbl(l_rec.step_number).list_line_type_code );
839: QP_PREQ_GRP.engine_debug('Value 7='||l_formula_line_tbl(l_rec.step_number).list_header_id );
840: QP_PREQ_GRP.engine_debug('Value 8='||l_formula_line_tbl(l_rec.step_number).list_line_id );
841: END IF;
842:
843: INSERT INTO qp_nformula_step_values_tmp
844: (price_formula_id,

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

860: l_formula_line_tbl(l_rec.step_number).list_header_id,
861: l_formula_line_tbl(l_rec.step_number).list_line_id
862: );
863: IF l_debug = FND_API.G_TRUE THEN
864: QP_PREQ_GRP.engine_debug('After populating formula step values temp table');
865: END IF;
866: END IF;
867: -- smbalara bug 7188211
868: END LOOP; --Loop over formula_lines_cur

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

872:
873: -- Now Process all Factor Lists in the formula
874:
875: IF l_debug = FND_API.G_TRUE THEN
876: QP_PREQ_GRP.engine_debug('Before populating plsql table of formula lines');
877:
878: END IF;
879: --Populate l_formula_line_tbl for all factor lists in the formula
880: FOR l_factors_rec IN factors_cur (p_price_formula_id, p_line_index,

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

881: p_price_effective_date)
882: LOOP
883:
884: IF l_debug = FND_API.G_TRUE THEN
885: QP_PREQ_GRP.engine_debug('enter factors_cur loop');
886:
887: END IF;
888: IF l_skip_factor AND
889: l_factors_rec.step_number = l_old_step_number

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

892: GOTO factors_loop;
893: END IF;
894:
895: IF l_debug = FND_API.G_TRUE THEN
896: QP_PREQ_GRP.engine_debug('after skip check ');
897:
898: END IF;
899: l_skip_factor := FALSE;
900:

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

921: l_formula_line_tbl(l_factors_rec.step_number).list_line_type_code :=
922: p_list_line_type_code;
923:
924: IF l_debug = FND_API.G_TRUE THEN
925: QP_PREQ_GRP.engine_debug('In factors_cur, step = ' ||l_factors_rec.step_number);
926:
927: END IF;
928: l_skip_factor := TRUE;
929:

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

963: l_formula_line_tbl(l_factors_rec.step_number).list_line_type_code :=
964: p_list_line_type_code;
965:
966: IF l_debug = FND_API.G_TRUE THEN
967: QP_PREQ_GRP.engine_debug('In sub_factors_cur, step = ' ||l_factors_rec.step_number);
968:
969: END IF;
970: l_skip_factor := TRUE;
971:

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

981: <>
982: null;
983:
984: IF l_debug = FND_API.G_TRUE THEN
985: QP_PREQ_GRP.engine_debug('exit factors_cur loop');
986:
987: END IF;
988: END LOOP; --Loop over factors_cur
989:

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

987: END IF;
988: END LOOP; --Loop over factors_cur
989:
990: IF l_debug = FND_API.G_TRUE THEN
991: QP_PREQ_GRP.engine_debug('After populating plsql table of formula lines');
992:
993: END IF;
994: --Based on a profile option, loop over plsql table of formula lines to
995: --populate qp_nformula_step_values_tmp table

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

993: END IF;
994: --Based on a profile option, loop over plsql table of formula lines to
995: --populate qp_nformula_step_values_tmp table
996: /* commented for bug 7188211 - temp table insert moved above
997: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
998:
999: IF l_debug = FND_API.G_TRUE THEN
1000: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
1001:

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

996: /* commented for bug 7188211 - temp table insert moved above
997: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
998:
999: IF l_debug = FND_API.G_TRUE THEN
1000: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
1001:
1002: END IF;
1003: i:= l_formula_line_tbl.FIRST; --set loop index to first element in plsql tbl
1004:

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

1035:
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: IF l_debug = FND_API.G_TRUE THEN
1039: QP_PREQ_GRP.engine_debug(substr(sqlerrm, 1, 240));
1040: END IF;
1041: END;
1042:
1043: i := l_formula_line_tbl.NEXT(i);--set i to next notnull position in plsql

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

1044:
1045: END LOOP; --loop over l_formula_line_tbl
1046:
1047: IF l_debug = FND_API.G_TRUE THEN
1048: QP_PREQ_GRP.engine_debug('After populating formula step values temp table');
1049:
1050: END IF;
1051: END IF; --If profile option is set
1052: commented for bug 7188211*/

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

1050: END IF;
1051: END IF; --If profile option is set
1052: commented for bug 7188211*/
1053: IF l_debug = FND_API.G_TRUE THEN
1054: QP_PREQ_GRP.engine_debug('Before Calling - QP_BUILD_FORMULA_RULES.Get_Formula_Values');
1055: QP_PREQ_GRP.engine_debug('For Formula : '||l_formula);----6726052,7249280 smbalara
1056: END IF;
1057: QP_BUILD_FORMULA_RULES.Get_Formula_Values(l_formula,
1058: l_Operand_Tbl,

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

1051: END IF; --If profile option is set
1052: commented for bug 7188211*/
1053: IF l_debug = FND_API.G_TRUE THEN
1054: QP_PREQ_GRP.engine_debug('Before Calling - QP_BUILD_FORMULA_RULES.Get_Formula_Values');
1055: QP_PREQ_GRP.engine_debug('For Formula : '||l_formula);----6726052,7249280 smbalara
1056: END IF;
1057: QP_BUILD_FORMULA_RULES.Get_Formula_Values(l_formula,
1058: l_Operand_Tbl,
1059: 'G', --sfiresto

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

1060: l_formula_value,
1061: l_return_status);
1062:
1063: IF l_debug = FND_API.G_TRUE THEN
1064: QP_PREQ_GRP.engine_debug('After Calling - QP_BUILD_FORMULA_RULES.Get_Formula_Values');
1065:
1066: QP_PREQ_GRP.engine_debug('Return Status from Get_Formula_Values ' || l_return_status);
1067:
1068: END IF;

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

1062:
1063: IF l_debug = FND_API.G_TRUE THEN
1064: QP_PREQ_GRP.engine_debug('After Calling - QP_BUILD_FORMULA_RULES.Get_Formula_Values');
1065:
1066: QP_PREQ_GRP.engine_debug('Return Status from Get_Formula_Values ' || l_return_status);
1067:
1068: END IF;
1069: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) OR (l_formula_value IS NULL) THEN
1070: l_formula_value := Select_From_Dual(l_formula, l_operand_tbl);

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

1082:
1083: END IF;
1084:
1085: IF l_debug = FND_API.G_TRUE THEN
1086: QP_PREQ_GRP.engine_debug('Formula evaluated to ' || l_formula_value);
1087:
1088: QP_PREQ_GRP.engine_debug('Formula Return Status ' || l_return_status);
1089:
1090: END IF;

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

1084:
1085: IF l_debug = FND_API.G_TRUE THEN
1086: QP_PREQ_GRP.engine_debug('Formula evaluated to ' || l_formula_value);
1087:
1088: QP_PREQ_GRP.engine_debug('Formula Return Status ' || l_return_status);
1089:
1090: END IF;
1091: l_formula_line_tbl.DELETE; --Clear the temp table table
1092:

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

1093: l_formula_end_time := dbms_utility.get_time;
1094: l_time_difference := (l_formula_end_time - l_formula_start_time)/100 ;
1095:
1096: IF l_debug = FND_API.G_TRUE THEN
1097: QP_PREQ_GRP.engine_debug('##### Total Time in QP_FORMULA_PRICE_CALC_PVT(in sec) : ' || l_time_difference || ' #####');
1098:
1099: END IF;
1100: RETURN l_formula_value;
1101: --End more POSCO changes.

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

1150: THEN
1151: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_FAILED');
1152: END IF;
1153: IF l_debug = FND_API.G_TRUE THEN
1154: QP_PREQ_GRP.engine_debug('Exception '||substr(sqlerrm, 1, 240));
1155: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||
1156: l_formula_value);
1157: END IF;
1158:

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

1151: FND_MESSAGE.SET_NAME('QP','QP_FORMULA_FAILED');
1152: END IF;
1153: IF l_debug = FND_API.G_TRUE THEN
1154: QP_PREQ_GRP.engine_debug('Exception '||substr(sqlerrm, 1, 240));
1155: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||
1156: l_formula_value);
1157: END IF;
1158:
1159: l_formula_line_tbl.DELETE; --Clear the temp table table

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

1166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1167:
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1169: IF l_debug = FND_API.G_TRUE THEN
1170: QP_PREQ_GRP.engine_debug('Unexpected Exception '||substr(sqlerrm, 1, 240));
1171: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||
1172: l_formula_value);
1173:
1174: END IF;

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

1167:
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1169: IF l_debug = FND_API.G_TRUE THEN
1170: QP_PREQ_GRP.engine_debug('Unexpected Exception '||substr(sqlerrm, 1, 240));
1171: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||
1172: l_formula_value);
1173:
1174: END IF;
1175: l_formula_line_tbl.DELETE; --Clear the temp table table

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

1189: 'Calculate:'||sqlerrm);
1190: END IF;
1191:
1192: IF l_debug = FND_API.G_TRUE THEN
1193: QP_PREQ_GRP.engine_debug('Other Exception '||substr(sqlerrm, 1, 240));
1194: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||
1195: l_formula_value);
1196:
1197: END IF;

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

1190: END IF;
1191:
1192: IF l_debug = FND_API.G_TRUE THEN
1193: QP_PREQ_GRP.engine_debug('Other Exception '||substr(sqlerrm, 1, 240));
1194: QP_PREQ_GRP.engine_debug('Exception occurred. Formula value returned is ' ||
1195: l_formula_value);
1196:
1197: END IF;
1198: l_formula_line_tbl.DELETE; --Clear the temp table table