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

Line 35: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED

31: , pricing_status_code
32: , qp_number.canonical_to_number(value_from)
33: FROM qp_npreq_line_attrs_tmp lattr
34: WHERE attribute_type IN ('PRICING', 'PRODUCT')
35: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
36: AND EXISTS (
37: SELECT format_type
38: FROM fnd_flex_value_sets VSET,
39: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS

Line 58: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED

54: ,pricing_status_code
55: ,qp_number.canonical_to_number(value_from)
56: FROM qp_npreq_line_attrs_tmp lattr
57: WHERE attribute_type IN ('PRICING', 'PRODUCT')
58: AND pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
59: AND EXISTS(
60: SELECT format_type
61: FROM fnd_flex_value_sets vset
62: ,fnd_descr_flex_column_usages dflex

Line 87: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

83: l_rows NATURAL := 5000;
84: --End Bug No: 8427852 scroll down for more changes
85:
86: BEGIN
87: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
88: IF l_debug = FND_API.G_TRUE THEN
89: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_insert_into_tmp = '
90: || l_insert_into_tmp);
91: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_price_formula_id = '

Line 89: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_insert_into_tmp = '

85:
86: BEGIN
87: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
88: IF l_debug = FND_API.G_TRUE THEN
89: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_insert_into_tmp = '
90: || l_insert_into_tmp);
91: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_price_formula_id = '
92: || l_price_formula_id);
93: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_operand_value = '

Line 91: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_price_formula_id = '

87: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
88: IF l_debug = FND_API.G_TRUE THEN
89: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_insert_into_tmp = '
90: || l_insert_into_tmp);
91: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_price_formula_id = '
92: || l_price_formula_id);
93: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_operand_value = '
94: || l_operand_value);
95: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_pricing_effective_date = '

Line 93: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_operand_value = '

89: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_insert_into_tmp = '
90: || l_insert_into_tmp);
91: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_price_formula_id = '
92: || l_price_formula_id);
93: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_operand_value = '
94: || l_operand_value);
95: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_pricing_effective_date = '
96: || l_pricing_effective_date);
97: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_line_index = '

Line 95: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_pricing_effective_date = '

91: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_price_formula_id = '
92: || l_price_formula_id);
93: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_operand_value = '
94: || l_operand_value);
95: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_pricing_effective_date = '
96: || l_pricing_effective_date);
97: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_line_index = '
98: || l_line_index);
99: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_modifier_value = '

Line 97: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_line_index = '

93: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_operand_value = '
94: || l_operand_value);
95: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_pricing_effective_date = '
96: || l_pricing_effective_date);
97: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_line_index = '
98: || l_line_index);
99: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_modifier_value = '
100: || l_modifier_value);
101: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_formula_based_value = '

Line 99: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_modifier_value = '

95: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_pricing_effective_date = '
96: || l_pricing_effective_date);
97: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_line_index = '
98: || l_line_index);
99: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_modifier_value = '
100: || l_modifier_value);
101: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_formula_based_value = '
102: || l_formula_based_value);
103: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_return_status = '

Line 101: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_formula_based_value = '

97: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_line_index = '
98: || l_line_index);
99: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_modifier_value = '
100: || l_modifier_value);
101: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_formula_based_value = '
102: || l_formula_based_value);
103: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_return_status = '
104: || l_return_status);
105:

Line 103: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_return_status = '

99: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_modifier_value = '
100: || l_modifier_value);
101: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_formula_based_value = '
102: || l_formula_based_value);
103: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_return_status = '
104: || l_return_status);
105:
106: END IF;
107:

Line 180: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED

176: qp_npreq_line_attrs_tmp lattr
177: WHERE
178: attribute_type IN ('PRICING', 'PRODUCT')
179: AND
180: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
181: AND
182: EXISTS(
183: SELECT format_type
184: FROM fnd_flex_value_sets VSET,

Line 219: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED

215: qp_npreq_line_attrs_tmp lattr
216: WHERE
217: attribute_type IN ('PRICING', 'PRODUCT')
218: AND
219: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
220: AND
221: NOT EXISTS(
222: SELECT format_type
223: FROM fnd_flex_value_sets VSET,

Line 292: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED

288: qp_npreq_line_attrs_tmp lattr
289: WHERE
290: attribute_type IN ('PRICING', 'PRODUCT')
291: AND
292: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
293: AND
294: EXISTS(
295: SELECT format_type
296: FROM fnd_flex_value_sets vset

Line 334: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED

330: qp_npreq_line_attrs_tmp lattr
331: WHERE
332: attribute_type IN ('PRICING', 'PRODUCT')
333: AND
334: pricing_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED
335: AND
336: NOT EXISTS(
337: SELECT format_type
338: FROM fnd_flex_value_sets vset

Line 380: QP_PREQ_GRP.engine_debug('Formula return status: '||l_status);

376: END IF;
377:
378:
379: IF l_debug = FND_API.G_TRUE THEN
380: QP_PREQ_GRP.engine_debug('Formula return status: '||l_status);
381: QP_PREQ_GRP.engine_debug('Formula base rate: '|| l_formula_based_value);
382:
383: IF l_status IS NULL THEN
384: QP_PREQ_GRP.engine_debug('Formula return status is NULL');

Line 381: QP_PREQ_GRP.engine_debug('Formula base rate: '|| l_formula_based_value);

377:
378:
379: IF l_debug = FND_API.G_TRUE THEN
380: QP_PREQ_GRP.engine_debug('Formula return status: '||l_status);
381: QP_PREQ_GRP.engine_debug('Formula base rate: '|| l_formula_based_value);
382:
383: IF l_status IS NULL THEN
384: QP_PREQ_GRP.engine_debug('Formula return status is NULL');
385: QP_PREQ_GRP.engine_debug('FND_API.G_RET_STS_ERROR: '||FND_API.G_RET_STS_ERROR);

Line 384: QP_PREQ_GRP.engine_debug('Formula return status is NULL');

380: QP_PREQ_GRP.engine_debug('Formula return status: '||l_status);
381: QP_PREQ_GRP.engine_debug('Formula base rate: '|| l_formula_based_value);
382:
383: IF l_status IS NULL THEN
384: QP_PREQ_GRP.engine_debug('Formula return status is NULL');
385: QP_PREQ_GRP.engine_debug('FND_API.G_RET_STS_ERROR: '||FND_API.G_RET_STS_ERROR);
386: null;
387: END IF;
388:

Line 385: QP_PREQ_GRP.engine_debug('FND_API.G_RET_STS_ERROR: '||FND_API.G_RET_STS_ERROR);

381: QP_PREQ_GRP.engine_debug('Formula base rate: '|| l_formula_based_value);
382:
383: IF l_status IS NULL THEN
384: QP_PREQ_GRP.engine_debug('Formula return status is NULL');
385: QP_PREQ_GRP.engine_debug('FND_API.G_RET_STS_ERROR: '||FND_API.G_RET_STS_ERROR);
386: null;
387: END IF;
388:
389: END IF;

Line 397: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - OTHERS exception '

393:
394: WHEN OTHERS THEN
395:
396: IF l_debug = FND_API.G_TRUE THEN
397: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - OTHERS exception '
398: || SQLERRM);
399: END IF;
400: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
401:

Line 526: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

522:
523: qp_debug_util.tstart('CURRENCY_CONVERSION_API', 'CURRENCY_CONVERSION_API'); --by smuhamme
524:
525: --If there is a formula, then need to insert pricing attributes once for each run
526: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
527: IF l_debug = FND_API.G_TRUE THEN
528: qp_preq_grp.engine_debug('Currency_Conversion_API - Enter');
529: END IF;
530:

Line 528: qp_preq_grp.engine_debug('Currency_Conversion_API - Enter');

524:
525: --If there is a formula, then need to insert pricing attributes once for each run
526: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
527: IF l_debug = FND_API.G_TRUE THEN
528: qp_preq_grp.engine_debug('Currency_Conversion_API - Enter');
529: END IF;
530:
531: IF l_debug = FND_API.G_TRUE THEN
532: qp_preq_grp.engine_debug('Currency_Conversion_API - p_user_conversion_rate' || p_user_conversion_rate);

Line 532: qp_preq_grp.engine_debug('Currency_Conversion_API - p_user_conversion_rate' || p_user_conversion_rate);

528: qp_preq_grp.engine_debug('Currency_Conversion_API - Enter');
529: END IF;
530:
531: IF l_debug = FND_API.G_TRUE THEN
532: qp_preq_grp.engine_debug('Currency_Conversion_API - p_user_conversion_rate' || p_user_conversion_rate);
533: qp_preq_grp.engine_debug('Currency_Conversion_API - p_user_conversion_type' || p_user_conversion_type);
534: qp_preq_grp.engine_debug('Currency_Conversion_API - p_function_currency' || p_function_currency);
535: qp_preq_grp.engine_debug('Currency_Conversion_API - p_rounding_flag' || p_rounding_flag);
536:

Line 533: qp_preq_grp.engine_debug('Currency_Conversion_API - p_user_conversion_type' || p_user_conversion_type);

529: END IF;
530:
531: IF l_debug = FND_API.G_TRUE THEN
532: qp_preq_grp.engine_debug('Currency_Conversion_API - p_user_conversion_rate' || p_user_conversion_rate);
533: qp_preq_grp.engine_debug('Currency_Conversion_API - p_user_conversion_type' || p_user_conversion_type);
534: qp_preq_grp.engine_debug('Currency_Conversion_API - p_function_currency' || p_function_currency);
535: qp_preq_grp.engine_debug('Currency_Conversion_API - p_rounding_flag' || p_rounding_flag);
536:
537: END IF;

Line 534: qp_preq_grp.engine_debug('Currency_Conversion_API - p_function_currency' || p_function_currency);

530:
531: IF l_debug = FND_API.G_TRUE THEN
532: qp_preq_grp.engine_debug('Currency_Conversion_API - p_user_conversion_rate' || p_user_conversion_rate);
533: qp_preq_grp.engine_debug('Currency_Conversion_API - p_user_conversion_type' || p_user_conversion_type);
534: qp_preq_grp.engine_debug('Currency_Conversion_API - p_function_currency' || p_function_currency);
535: qp_preq_grp.engine_debug('Currency_Conversion_API - p_rounding_flag' || p_rounding_flag);
536:
537: END IF;
538:

Line 535: qp_preq_grp.engine_debug('Currency_Conversion_API - p_rounding_flag' || p_rounding_flag);

531: IF l_debug = FND_API.G_TRUE THEN
532: qp_preq_grp.engine_debug('Currency_Conversion_API - p_user_conversion_rate' || p_user_conversion_rate);
533: qp_preq_grp.engine_debug('Currency_Conversion_API - p_user_conversion_type' || p_user_conversion_type);
534: qp_preq_grp.engine_debug('Currency_Conversion_API - p_function_currency' || p_function_currency);
535: qp_preq_grp.engine_debug('Currency_Conversion_API - p_rounding_flag' || p_rounding_flag);
536:
537: END IF;
538:
539: l_insert_into_tmp := 'Y'; --Bug No. 8323485, performace reason, moved from loop to here

Line 590: qp_preq_grp.engine_debug('Currency_Conversion_API - record count = '||line_index_t.count);

586: LIMIT rows;
587:
588:
589: IF l_debug = FND_API.G_TRUE THEN
590: qp_preq_grp.engine_debug('Currency_Conversion_API - record count = '||line_index_t.count);
591: END IF;
592: IF line_index_t.count > 0 THEN
593: --process every record in this fetch
594:

Line 619: qp_preq_grp.engine_debug('Currency_Conversion_API - conversion_type = '||conversion_type_t(J));

615: l_operand_value := NULL;
616: result_operand_value_t(J) := NULL;
617:
618: IF l_debug = FND_API.G_TRUE THEN
619: qp_preq_grp.engine_debug('Currency_Conversion_API - conversion_type = '||conversion_type_t(J));
620:
621: END IF;
622: IF conversion_type_t(J) = 'FIXED' THEN
623:

Line 628: qp_preq_grp.engine_debug('Currency_Conversion_API - FIXED l_conversion_rate = '

624: -- Use the fixed value
625: l_conversion_rate := fixed_value_t(J);
626:
627: IF l_debug = FND_API.G_TRUE THEN
628: qp_preq_grp.engine_debug('Currency_Conversion_API - FIXED l_conversion_rate = '
629: ||l_conversion_rate);
630: END IF;
631:
632: ELSIF conversion_type_t(J) = 'TRANSACTION' THEN

Line 643: qp_preq_grp.engine_debug('Currency_Conversion_API - TRANSACTION function and base currency same ');

639:
640: -- Only when function and base currency are same, use the OM rate
641:
642: IF l_debug = FND_API.G_TRUE THEN
643: qp_preq_grp.engine_debug('Currency_Conversion_API - TRANSACTION function and base currency same ');
644: END IF;
645:
646: -- [julin/4099147] integrating apps users expect entered rate to
647: -- be from transaction currency to functional currency

Line 650: qp_preq_grp.engine_debug('Currency_Conversion_API - TRANSACTION l_conversion_rate = '

646: -- [julin/4099147] integrating apps users expect entered rate to
647: -- be from transaction currency to functional currency
648: l_conversion_rate := 1/p_user_conversion_rate;
649: IF l_debug = FND_API.G_TRUE THEN
650: qp_preq_grp.engine_debug('Currency_Conversion_API - TRANSACTION l_conversion_rate = '
651: ||l_conversion_rate);
652:
653: END IF;
654: ELSE

Line 657: qp_preq_grp.engine_debug('Currency_Conversion_API - TRANSACTION function and base currency different ');

653: END IF;
654: ELSE
655:
656: IF l_debug = FND_API.G_TRUE THEN
657: qp_preq_grp.engine_debug('Currency_Conversion_API - TRANSACTION function and base currency different ');
658: END IF;
659: -- Function and base currency not same, raise error
660: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
661: FND_MESSAGE.SET_NAME('QP', 'QP_DIFF_FUNC_AND_BASE_CURR');

Line 666: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

662: FND_MESSAGE.SET_TOKEN('BASE_CURR', base_currency_code_t(J));
663: FND_MESSAGE.SET_TOKEN('FUNC_CURR', p_function_currency);
664:
665: error_message_t(J) := FND_MESSAGE.GET;
666: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
667: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
668:
669: END IF;
670:

Line 667: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

663: FND_MESSAGE.SET_TOKEN('FUNC_CURR', p_function_currency);
664:
665: error_message_t(J) := FND_MESSAGE.GET;
666: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
667: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
668:
669: END IF;
670:
671: RAISE FND_API.G_EXC_ERROR;

Line 679: qp_preq_grp.engine_debug('Currency_Conversion_API - x_from_currency = '||base_currency_code_t(J) );

675: ELSIF p_user_conversion_type IS NOT NULL THEN
676: -- p_user_conversion_type <> 'USER' THEN
677:
678: IF l_debug = FND_API.G_TRUE THEN
679: qp_preq_grp.engine_debug('Currency_Conversion_API - x_from_currency = '||base_currency_code_t(J) );
680: qp_preq_grp.engine_debug('Currency_Conversion_API - x_to_currency = '|| to_currency_code_t(J));
681: qp_preq_grp.engine_debug('Currency_Conversion_API - x_conversion_date = '|| pricing_effective_date_t(J));
682: qp_preq_grp.engine_debug('Currency_Conversion_API - x_conversion_type = '|| p_user_conversion_type);
683:

Line 680: qp_preq_grp.engine_debug('Currency_Conversion_API - x_to_currency = '|| to_currency_code_t(J));

676: -- p_user_conversion_type <> 'USER' THEN
677:
678: IF l_debug = FND_API.G_TRUE THEN
679: qp_preq_grp.engine_debug('Currency_Conversion_API - x_from_currency = '||base_currency_code_t(J) );
680: qp_preq_grp.engine_debug('Currency_Conversion_API - x_to_currency = '|| to_currency_code_t(J));
681: qp_preq_grp.engine_debug('Currency_Conversion_API - x_conversion_date = '|| pricing_effective_date_t(J));
682: qp_preq_grp.engine_debug('Currency_Conversion_API - x_conversion_type = '|| p_user_conversion_type);
683:
684: END IF;

Line 681: qp_preq_grp.engine_debug('Currency_Conversion_API - x_conversion_date = '|| pricing_effective_date_t(J));

677:
678: IF l_debug = FND_API.G_TRUE THEN
679: qp_preq_grp.engine_debug('Currency_Conversion_API - x_from_currency = '||base_currency_code_t(J) );
680: qp_preq_grp.engine_debug('Currency_Conversion_API - x_to_currency = '|| to_currency_code_t(J));
681: qp_preq_grp.engine_debug('Currency_Conversion_API - x_conversion_date = '|| pricing_effective_date_t(J));
682: qp_preq_grp.engine_debug('Currency_Conversion_API - x_conversion_type = '|| p_user_conversion_type);
683:
684: END IF;
685: -- use the functional conversion rate defined in GL(from base currency to order currency)

Line 682: qp_preq_grp.engine_debug('Currency_Conversion_API - x_conversion_type = '|| p_user_conversion_type);

678: IF l_debug = FND_API.G_TRUE THEN
679: qp_preq_grp.engine_debug('Currency_Conversion_API - x_from_currency = '||base_currency_code_t(J) );
680: qp_preq_grp.engine_debug('Currency_Conversion_API - x_to_currency = '|| to_currency_code_t(J));
681: qp_preq_grp.engine_debug('Currency_Conversion_API - x_conversion_date = '|| pricing_effective_date_t(J));
682: qp_preq_grp.engine_debug('Currency_Conversion_API - x_conversion_type = '|| p_user_conversion_type);
683:
684: END IF;
685: -- use the functional conversion rate defined in GL(from base currency to order currency)
686: l_conversion_rate := gl_currency_api.get_rate_sql

Line 695: qp_preq_grp.engine_debug('Currency_Conversion_API - GL l_conversion_rate = '|| l_conversion_rate);

691: ,x_conversion_type => p_user_conversion_type
692: );
693:
694: IF l_debug = FND_API.G_TRUE THEN
695: qp_preq_grp.engine_debug('Currency_Conversion_API - GL l_conversion_rate = '|| l_conversion_rate);
696: END IF;
697:
698: IF l_conversion_rate = -1 THEN
699:

Line 709: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

705: FND_MESSAGE.SET_TOKEN('CONV_DATE', pricing_effective_date_t(J));
706: FND_MESSAGE.SET_TOKEN('CONV_TYPE', p_user_conversion_type);
707:
708: error_message_t(J) := FND_MESSAGE.GET;
709: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
710: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
711:
712: END IF;
713:

Line 710: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

706: FND_MESSAGE.SET_TOKEN('CONV_TYPE', p_user_conversion_type);
707:
708: error_message_t(J) := FND_MESSAGE.GET;
709: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
710: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
711:
712: END IF;
713:
714: RAISE FND_API.G_EXC_ERROR;

Line 723: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

719: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
720: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CURRENCY');
721:
722: error_message_t(J) := FND_MESSAGE.GET;
723: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
724: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
725:
726:
727: END IF;

Line 724: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

720: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CURRENCY');
721:
722: error_message_t(J) := FND_MESSAGE.GET;
723: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
724: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
725:
726:
727: END IF;
728:

Line 737: qp_preq_grp.engine_debug('Currency_Conversion_API - TRANSACTION no conversion type ');

733:
734: ELSE
735:
736: IF l_debug = FND_API.G_TRUE THEN
737: qp_preq_grp.engine_debug('Currency_Conversion_API - TRANSACTION no conversion type ');
738: END IF;
739: -- For 'TRANSACTION' conv, OM did not pass user conversion type, raise error
740: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
741:

Line 745: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

741:
742: FND_MESSAGE.SET_NAME('QP', 'QP_NO_USER_CONVTYPE_F_TRANSACT');
743:
744: error_message_t(J) := FND_MESSAGE.GET;
745: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
746: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
747:
748: END IF;
749:

Line 746: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

742: FND_MESSAGE.SET_NAME('QP', 'QP_NO_USER_CONVTYPE_F_TRANSACT');
743:
744: error_message_t(J) := FND_MESSAGE.GET;
745: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
746: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
747:
748: END IF;
749:
750:

Line 778: qp_preq_grp.engine_debug('Currency_Conversion_API - FORMULA not success');

774:
775: IF l_formula_status <> FND_API.G_RET_STS_SUCCESS THEN
776:
777: IF l_debug = FND_API.G_TRUE THEN
778: qp_preq_grp.engine_debug('Currency_Conversion_API - FORMULA not success');
779: END IF;
780: -- Formula calculation failed, raise error
781: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
782: FND_MESSAGE.SET_NAME('QP', 'QP_FORMULA_CALC_FAILURE');

Line 785: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

781: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
782: FND_MESSAGE.SET_NAME('QP', 'QP_FORMULA_CALC_FAILURE');
783:
784: error_message_t(J) := FND_MESSAGE.GET;
785: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
786: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
787:
788: END IF;
789:

Line 786: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

782: FND_MESSAGE.SET_NAME('QP', 'QP_FORMULA_CALC_FAILURE');
783:
784: error_message_t(J) := FND_MESSAGE.GET;
785: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
786: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
787:
788: END IF;
789:
790: RAISE FND_API.G_EXC_ERROR;

Line 804: qp_preq_grp.engine_debug('Currency_Conversion_API - FORMULA l_conversion_rate'

800: -- Use the rate returned from the formula calculation
801: l_conversion_rate := l_formula_based_value;
802:
803: IF l_debug = FND_API.G_TRUE THEN
804: qp_preq_grp.engine_debug('Currency_Conversion_API - FORMULA l_conversion_rate'
805: || l_conversion_rate);
806: END IF;
807: --End of processing conversion type ='FORMULA'
808:

Line 812: qp_preq_grp.engine_debug('Currency_Conversion_API - null conversion type');

808:
809: ELSIF conversion_type_t(J) IS NULL THEN
810:
811: IF l_debug = FND_API.G_TRUE THEN
812: qp_preq_grp.engine_debug('Currency_Conversion_API - null conversion type');
813: END IF;
814: IF to_currency_code_t(J) = base_currency_code_t(J) THEN
815:
816: IF l_debug = FND_API.G_TRUE THEN

Line 817: qp_preq_grp.engine_debug('Currency_Conversion_API - null conversion type - curr matches');

813: END IF;
814: IF to_currency_code_t(J) = base_currency_code_t(J) THEN
815:
816: IF l_debug = FND_API.G_TRUE THEN
817: qp_preq_grp.engine_debug('Currency_Conversion_API - null conversion type - curr matches');
818: END IF;
819: --There order currency and base currency are same, the conversion rate is 1
820:
821: l_conversion_rate := 1;

Line 830: qp_preq_grp.engine_debug('Currency_Conversion_API - date type FIXED');

826: ELSE --All conversion types other than FIXED, TRANSACTION and FORMULA
827:
828: IF conversion_date_type_t(J) = 'FIXED' THEN
829: IF l_debug = FND_API.G_TRUE THEN
830: qp_preq_grp.engine_debug('Currency_Conversion_API - date type FIXED');
831: END IF;
832: l_conversion_date := conversion_date_t(J);
833: ELSE
834: l_conversion_date := pricing_effective_date_t(J);

Line 844: qp_preq_grp.engine_debug('Currency_Conversion_API - function and base currency same ');

840:
841: -- Only when function and base currency are same, use the OM rate
842:
843: IF l_debug = FND_API.G_TRUE THEN
844: qp_preq_grp.engine_debug('Currency_Conversion_API - function and base currency same ');
845: END IF;
846:
847: l_conversion_rate := 1/p_user_conversion_rate;
848: IF l_debug = FND_API.G_TRUE THEN

Line 849: qp_preq_grp.engine_debug('Currency_Conversion_API - l_conversion_rate = '

845: END IF;
846:
847: l_conversion_rate := 1/p_user_conversion_rate;
848: IF l_debug = FND_API.G_TRUE THEN
849: qp_preq_grp.engine_debug('Currency_Conversion_API - l_conversion_rate = '
850: ||l_conversion_rate);
851:
852: END IF;
853: ELSE

Line 856: qp_preq_grp.engine_debug('Currency_Conversion_API - function and base currency different ');

852: END IF;
853: ELSE
854:
855: IF l_debug = FND_API.G_TRUE THEN
856: qp_preq_grp.engine_debug('Currency_Conversion_API - function and base currency different ');
857: END IF;
858: -- Function and base currency not same, raise error
859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
860: FND_MESSAGE.SET_NAME('QP', 'QP_DIFF_FUNC_AND_BASE_CURR');

Line 865: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

861: FND_MESSAGE.SET_TOKEN('BASE_CURR', base_currency_code_t(J));
862: FND_MESSAGE.SET_TOKEN('FUNC_CURR', p_function_currency);
863:
864: error_message_t(J) := FND_MESSAGE.GET;
865: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
866: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
867:
868: END IF;
869:

Line 866: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

862: FND_MESSAGE.SET_TOKEN('FUNC_CURR', p_function_currency);
863:
864: error_message_t(J) := FND_MESSAGE.GET;
865: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
866: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
867:
868: END IF;
869:
870: RAISE FND_API.G_EXC_ERROR;

Line 893: qp_preq_grp.engine_debug('Currency_Conversion_API - GL2 l_conversion_rate'

889: ,x_conversion_type => l_user_conversion_type --bug 9503901
890: );
891:
892: IF l_debug = FND_API.G_TRUE THEN
893: qp_preq_grp.engine_debug('Currency_Conversion_API - GL2 l_conversion_rate'
894: || l_conversion_rate);
895: END IF;
896: IF l_conversion_rate = -1 THEN
897:

Line 907: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

903: FND_MESSAGE.SET_TOKEN('CONV_DATE', l_conversion_date);
904: FND_MESSAGE.SET_TOKEN('CONV_TYPE', conversion_type_t(J));
905:
906: error_message_t(J) := FND_MESSAGE.GET;
907: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
908: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
909:
910: END IF;
911:

Line 908: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

904: FND_MESSAGE.SET_TOKEN('CONV_TYPE', conversion_type_t(J));
905:
906: error_message_t(J) := FND_MESSAGE.GET;
907: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
908: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
909:
910: END IF;
911:
912: RAISE FND_API.G_EXC_ERROR;

Line 921: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

917: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
918: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CURRENCY');
919:
920: error_message_t(J) := FND_MESSAGE.GET;
921: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
922: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
923:
924: END IF;
925:

Line 922: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

918: FND_MESSAGE.SET_NAME('QP','QP_INVALID_CURRENCY');
919:
920: error_message_t(J) := FND_MESSAGE.GET;
921: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
922: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
923:
924: END IF;
925:
926: RAISE FND_API.G_EXC_ERROR;

Line 937: qp_preq_grp.engine_debug('Currency_Conversion_API - operand_value = '

933: --End of processing of conversion_rate
934:
935:
936: IF l_debug = FND_API.G_TRUE THEN
937: qp_preq_grp.engine_debug('Currency_Conversion_API - operand_value = '
938: || operand_value_t(J));
939: qp_preq_grp.engine_debug('Currency_Conversion_API - l_conversion_rate = '
940: || l_conversion_rate);
941:

Line 939: qp_preq_grp.engine_debug('Currency_Conversion_API - l_conversion_rate = '

935:
936: IF l_debug = FND_API.G_TRUE THEN
937: qp_preq_grp.engine_debug('Currency_Conversion_API - operand_value = '
938: || operand_value_t(J));
939: qp_preq_grp.engine_debug('Currency_Conversion_API - l_conversion_rate = '
940: || l_conversion_rate);
941:
942: END IF;
943: -- Bug 2929366 - removed the NVL so that if the operand is null,

Line 950: qp_preq_grp.engine_debug('Currency_Conversion_API - result_operand_value = '

946: --result_operand_value_t(J) := NVL(operand_value_t(J), 1) * l_conversion_rate;
947: result_operand_value_t(J) := operand_value_t(J) * l_conversion_rate;
948:
949: IF l_debug = FND_API.G_TRUE THEN
950: qp_preq_grp.engine_debug('Currency_Conversion_API - result_operand_value = '
951: || result_operand_value_t(J));
952: END IF;
953: -- Start processing Markup
954:

Line 956: qp_preq_grp.engine_debug('Currency_Conversion_API - markup_value = '

952: END IF;
953: -- Start processing Markup
954:
955: IF l_debug = FND_API.G_TRUE THEN
956: qp_preq_grp.engine_debug('Currency_Conversion_API - markup_value = '
957: || markup_value_t(J));
958: qp_preq_grp.engine_debug('Currency_Conversion_API - markup_formula_id = '
959: || markup_formula_id_t(J));
960: qp_preq_grp.engine_debug('Currency_Conversion_API - markup_operator = '

Line 958: qp_preq_grp.engine_debug('Currency_Conversion_API - markup_formula_id = '

954:
955: IF l_debug = FND_API.G_TRUE THEN
956: qp_preq_grp.engine_debug('Currency_Conversion_API - markup_value = '
957: || markup_value_t(J));
958: qp_preq_grp.engine_debug('Currency_Conversion_API - markup_formula_id = '
959: || markup_formula_id_t(J));
960: qp_preq_grp.engine_debug('Currency_Conversion_API - markup_operator = '
961: || markup_operator_t(J));
962:

Line 960: qp_preq_grp.engine_debug('Currency_Conversion_API - markup_operator = '

956: qp_preq_grp.engine_debug('Currency_Conversion_API - markup_value = '
957: || markup_value_t(J));
958: qp_preq_grp.engine_debug('Currency_Conversion_API - markup_formula_id = '
959: || markup_formula_id_t(J));
960: qp_preq_grp.engine_debug('Currency_Conversion_API - markup_operator = '
961: || markup_operator_t(J));
962:
963: END IF;
964: IF markup_value_t(J) IS NOT NULL and markup_formula_id_t(J) IS NULL THEN

Line 971: qp_preq_grp.engine_debug('Currency_Conversion_API - markup % result_operand_value = '

967:
968: result_operand_value_t(J) := result_operand_value_t(J) +
969: (result_operand_value_t(J) * (markup_value_t(J) / 100));
970: IF l_debug = FND_API.G_TRUE THEN
971: qp_preq_grp.engine_debug('Currency_Conversion_API - markup % result_operand_value = '
972: || result_operand_value_t(J));
973:
974: END IF;
975: ELSIF markup_operator_t(J) = 'AMT' THEN

Line 979: qp_preq_grp.engine_debug('Currency_Conversion_API - markup AMT result_operand_value = '

975: ELSIF markup_operator_t(J) = 'AMT' THEN
976:
977: result_operand_value_t(J) := result_operand_value_t(J) + markup_value_t(J);
978: IF l_debug = FND_API.G_TRUE THEN
979: qp_preq_grp.engine_debug('Currency_Conversion_API - markup AMT result_operand_value = '
980: || result_operand_value_t(J));
981: END IF;
982:
983: END IF;

Line 991: qp_preq_grp.engine_debug('Currency_Conversion_API - markup formula NOT null ');

987:
988:
989: IF markup_formula_id_t(J) IS NOT NULL THEN
990: IF l_debug = FND_API.G_TRUE THEN
991: qp_preq_grp.engine_debug('Currency_Conversion_API - markup formula NOT null ');
992: END IF;
993:
994: --call the process formula API
995:

Line 1012: qp_preq_grp.engine_debug('Currency_Conversion_API - markup formula fails ');

1008:
1009: IF l_formula_status <> FND_API.G_RET_STS_SUCCESS THEN
1010:
1011: IF l_debug = FND_API.G_TRUE THEN
1012: qp_preq_grp.engine_debug('Currency_Conversion_API - markup formula fails ');
1013: END IF;
1014: -- Formula calculation failed, raise error
1015: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1016: FND_MESSAGE.SET_NAME('QP', 'QP_FORMULA_CALC_FAILURE');

Line 1019: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

1015: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1016: FND_MESSAGE.SET_NAME('QP', 'QP_FORMULA_CALC_FAILURE');
1017:
1018: error_message_t(J) := FND_MESSAGE.GET;
1019: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
1020: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
1021:
1022: END IF;
1023:

Line 1020: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;

1016: FND_MESSAGE.SET_NAME('QP', 'QP_FORMULA_CALC_FAILURE');
1017:
1018: error_message_t(J) := FND_MESSAGE.GET;
1019: status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
1020: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
1021:
1022: END IF;
1023:
1024: RAISE FND_API.G_EXC_ERROR;

Line 1037: qp_preq_grp.engine_debug('Currency_Conversion_API - markup % result_operand_value = '

1033: result_operand_value_t(J) := result_operand_value_t(J) +
1034: (result_operand_value_t(J) * (l_formula_based_value/100));
1035:
1036: IF l_debug = FND_API.G_TRUE THEN
1037: qp_preq_grp.engine_debug('Currency_Conversion_API - markup % result_operand_value = '
1038: || result_operand_value_t(J));
1039: END IF;
1040: ELSIF markup_operator_t(J) = 'AMT' THEN
1041:

Line 1044: qp_preq_grp.engine_debug('Currency_Conversion_API - markup AMT result_operand_value = '

1040: ELSIF markup_operator_t(J) = 'AMT' THEN
1041:
1042: result_operand_value_t(J) := result_operand_value_t(J) + l_formula_based_value;
1043: IF l_debug = FND_API.G_TRUE THEN
1044: qp_preq_grp.engine_debug('Currency_Conversion_API - markup AMT result_operand_value = '
1045: || result_operand_value_t(J));
1046:
1047: END IF;
1048: END IF;

Line 1058: qp_preq_grp.engine_debug('Currency_Conversion_API - p_rounding_flag = '

1054:
1055: -- l_conversion_rate := l_conversion_rate * Value returned from Rounding;
1056: if p_rounding_flag = 'Y' then
1057: IF l_debug = FND_API.G_TRUE THEN
1058: qp_preq_grp.engine_debug('Currency_Conversion_API - p_rounding_flag = '
1059: || p_rounding_flag);
1060: END IF;
1061: qp_util_pub.round_price(
1062: P_OPERAND => result_operand_value_t(J)

Line 1075: qp_preq_grp.engine_debug('Currency_Conversion_API - round_price fails ');

1071: );
1072:
1073: IF l_round_price_status <> 'S' THEN
1074: IF l_debug = FND_API.G_TRUE THEN
1075: qp_preq_grp.engine_debug('Currency_Conversion_API - round_price fails ');
1076: END IF;
1077:
1078: -- Formula calculation failed, raise error
1079: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1090: qp_preq_grp.engine_debug('Currency_Conversion_API - after rounding result_operand_value = '

1086: RAISE FND_API.G_EXC_ERROR;
1087:
1088: END IF;
1089: IF l_debug = FND_API.G_TRUE THEN
1090: qp_preq_grp.engine_debug('Currency_Conversion_API - after rounding result_operand_value = '
1091: || result_operand_value_t(J));
1092:
1093: END IF;
1094: END IF; -- rounding flag

Line 1100: qp_preq_grp.engine_debug('Currency_Conversion_API - handle exception FND_API.G_EXC_ERROR');

1096: EXCEPTION
1097:
1098: WHEN FND_API.G_EXC_ERROR THEN
1099: IF l_debug = FND_API.G_TRUE THEN
1100: qp_preq_grp.engine_debug('Currency_Conversion_API - handle exception FND_API.G_EXC_ERROR');
1101:
1102: END IF;
1103: NULL;
1104:

Line 1116: qp_preq_grp.engine_debug('Currency_Conversion_API - BEFORE updating the temp tables = ');

1112:
1113: END IF; --IF line_index_t.count>0
1114:
1115: IF l_debug = FND_API.G_TRUE THEN
1116: qp_preq_grp.engine_debug('Currency_Conversion_API - BEFORE updating the temp tables = ');
1117: qp_preq_grp.engine_debug('Currency_Conversion_API - line_index_t.count' || line_index_t.count);
1118: END IF;
1119: --sql statement upd1
1120: IF line_index_t.count > 0 THEN

Line 1117: qp_preq_grp.engine_debug('Currency_Conversion_API - line_index_t.count' || line_index_t.count);

1113: END IF; --IF line_index_t.count>0
1114:
1115: IF l_debug = FND_API.G_TRUE THEN
1116: qp_preq_grp.engine_debug('Currency_Conversion_API - BEFORE updating the temp tables = ');
1117: qp_preq_grp.engine_debug('Currency_Conversion_API - line_index_t.count' || line_index_t.count);
1118: END IF;
1119: --sql statement upd1
1120: IF line_index_t.count > 0 THEN
1121:

Line 1123: qp_preq_grp.engine_debug('Currency_Conversion_API - updating the temp tables = ');

1119: --sql statement upd1
1120: IF line_index_t.count > 0 THEN
1121:
1122: IF l_debug = FND_API.G_TRUE THEN
1123: qp_preq_grp.engine_debug('Currency_Conversion_API - updating the temp tables = ');
1124:
1125: END IF;
1126: FORALL K IN line_index_t.FIRST..line_index_t.LAST
1127:

Line 1149: qp_preq_grp.engine_debug('Currency_Conversion_API - after updating the temp tables ');

1145:
1146: END IF;
1147:
1148: IF l_debug = FND_API.G_TRUE THEN
1149: qp_preq_grp.engine_debug('Currency_Conversion_API - after updating the temp tables ');
1150:
1151: END IF;
1152: EXIT WHEN c_currency_conversions%NOTFOUND;
1153:

Line 1186: qp_preq_grp.engine_debug('Currency_Conversion_API - OTHERS exception SQLERRM' || SQLERRM);

1182:
1183: WHEN OTHERS THEN
1184:
1185: IF l_debug = FND_API.G_TRUE THEN
1186: qp_preq_grp.engine_debug('Currency_Conversion_API - OTHERS exception SQLERRM' || SQLERRM);
1187: END IF;
1188: l_process_status := FND_API.G_RET_STS_UNEXP_ERROR;
1189:
1190: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1204: qp_preq_grp.engine_debug('Currency_Conversion_API - End');

1200: CLOSE c_currency_conversions;
1201: END IF;
1202:
1203: IF l_debug = FND_API.G_TRUE THEN
1204: qp_preq_grp.engine_debug('Currency_Conversion_API - End');
1205: END IF;
1206: END Currency_Conversion_Api;
1207:
1208: END QP_MULTI_CURRENCY_PVT;