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 FND_API

Line 26: IF l_debug = FND_API.G_TRUE THEN

22:
23: l_status VARCHAR2(1);
24: BEGIN
25: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
26: IF l_debug = FND_API.G_TRUE THEN
27: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_insert_into_tmp = '
28: || l_insert_into_tmp);
29: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_price_formula_id = '
30: || l_price_formula_id);

Line 45: l_return_status := FND_API.G_RET_STS_SUCCESS;

41: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - l_return_status = '
42: || l_return_status);
43:
44: END IF;
45: l_return_status := FND_API.G_RET_STS_SUCCESS;
46:
47: IF l_insert_into_tmp = 'Y' THEN
48:
49: -- Change flexible mask to mask below for formula pattern use

Line 234: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN

230: ,x_return_status => l_status
231: ,p_modifier_value => l_modifier_value
232: );
233:
234: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
235:
236: l_return_status := FND_API.G_RET_STS_ERROR;
237:
238: END IF;

Line 236: l_return_status := FND_API.G_RET_STS_ERROR;

232: );
233:
234: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
235:
236: l_return_status := FND_API.G_RET_STS_ERROR;
237:
238: END IF;
239:
240:

Line 241: IF l_debug = FND_API.G_TRUE THEN

237:
238: END IF;
239:
240:
241: IF l_debug = FND_API.G_TRUE THEN
242: QP_PREQ_GRP.engine_debug('Formula return status: '||l_status);
243: QP_PREQ_GRP.engine_debug('Formula base rate: '|| l_formula_based_value);
244:
245: IF l_status IS NULL THEN

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

243: QP_PREQ_GRP.engine_debug('Formula base rate: '|| l_formula_based_value);
244:
245: IF l_status IS NULL THEN
246: QP_PREQ_GRP.engine_debug('Formula return status is NULL');
247: QP_PREQ_GRP.engine_debug('FND_API.G_RET_STS_ERROR: '||FND_API.G_RET_STS_ERROR);
248: null;
249: END IF;
250:
251: END IF;

Line 256: IF l_debug = FND_API.G_TRUE THEN

252: EXCEPTION
253:
254: WHEN OTHERS THEN
255:
256: IF l_debug = FND_API.G_TRUE THEN
257: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - OTHERS exception '
258: || SQLERRM);
259: END IF;
260: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 260: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

256: IF l_debug = FND_API.G_TRUE THEN
257: qp_preq_grp.engine_debug('QP_MULTI_CURRENCY_PVT.Process_Formula_API - OTHERS exception '
258: || SQLERRM);
259: END IF;
260: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261:
262: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263:
264:

Line 262: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

258: || SQLERRM);
259: END IF;
260: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261:
262: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263:
264:
265: END Process_Formula_API;
266:

Line 382: IF l_debug = FND_API.G_TRUE THEN

378: BEGIN
379:
380: --If there is a formula, then need to insert pricing attributes once for each run
381: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
382: IF l_debug = FND_API.G_TRUE THEN
383: qp_preq_grp.engine_debug('Currency_Conversion_API - Enter');
384: END IF;
385:
386: IF l_debug = FND_API.G_TRUE THEN

Line 386: IF l_debug = FND_API.G_TRUE THEN

382: IF l_debug = FND_API.G_TRUE THEN
383: qp_preq_grp.engine_debug('Currency_Conversion_API - Enter');
384: END IF;
385:
386: IF l_debug = FND_API.G_TRUE THEN
387: qp_preq_grp.engine_debug('Currency_Conversion_API - p_user_conversion_rate' || p_user_conversion_rate);
388: qp_preq_grp.engine_debug('Currency_Conversion_API - p_user_conversion_type' || p_user_conversion_type);
389: qp_preq_grp.engine_debug('Currency_Conversion_API - p_function_currency' || p_function_currency);
390: qp_preq_grp.engine_debug('Currency_Conversion_API - p_rounding_flag' || p_rounding_flag);

Line 441: IF l_debug = FND_API.G_TRUE THEN

437: markup_formula_id_t
438: LIMIT rows;
439:
440:
441: IF l_debug = FND_API.G_TRUE THEN
442: qp_preq_grp.engine_debug('Currency_Conversion_API - record count = '||line_index_t.count);
443: END IF;
444: IF line_index_t.count > 0 THEN
445: --process every record in this fetch

Line 454: --l_process_status := FND_API.G_RET_STS_SUCCESS;

450: BEGIN
451:
452: l_insert_into_tmp := 'Y';
453:
454: --l_process_status := FND_API.G_RET_STS_SUCCESS;
455:
456: error_message_t(J) := NULL;
457:
458: -- status_code_t is used for updating the qp_npreq_ldets_tmp table Bug 2327718

Line 470: IF l_debug = FND_API.G_TRUE THEN

466: l_conversion_rate := NULL;
467: l_operand_value := NULL;
468: result_operand_value_t(J) := NULL;
469:
470: IF l_debug = FND_API.G_TRUE THEN
471: qp_preq_grp.engine_debug('Currency_Conversion_API - conversion_type = '||conversion_type_t(J));
472:
473: END IF;
474: IF conversion_type_t(J) = 'FIXED' THEN

Line 479: IF l_debug = FND_API.G_TRUE THEN

475:
476: -- Use the fixed value
477: l_conversion_rate := fixed_value_t(J);
478:
479: IF l_debug = FND_API.G_TRUE THEN
480: qp_preq_grp.engine_debug('Currency_Conversion_API - FIXED l_conversion_rate = '
481: ||l_conversion_rate);
482: END IF;
483:

Line 494: IF l_debug = FND_API.G_TRUE THEN

490: IF p_function_currency = base_currency_code_t(J) THEN
491:
492: -- Only when function and base currency are same, use the OM rate
493:
494: IF l_debug = FND_API.G_TRUE THEN
495: qp_preq_grp.engine_debug('Currency_Conversion_API - TRANSACTION function and base currency same ');
496: END IF;
497:
498: -- [julin/4099147] integrating apps users expect entered rate to

Line 501: IF l_debug = FND_API.G_TRUE THEN

497:
498: -- [julin/4099147] integrating apps users expect entered rate to
499: -- be from transaction currency to functional currency
500: l_conversion_rate := 1/p_user_conversion_rate;
501: IF l_debug = FND_API.G_TRUE THEN
502: qp_preq_grp.engine_debug('Currency_Conversion_API - TRANSACTION l_conversion_rate = '
503: ||l_conversion_rate);
504:
505: END IF;

Line 508: IF l_debug = FND_API.G_TRUE THEN

504:
505: END IF;
506: ELSE
507:
508: IF l_debug = FND_API.G_TRUE THEN
509: qp_preq_grp.engine_debug('Currency_Conversion_API - TRANSACTION function and base currency different ');
510: END IF;
511: -- Function and base currency not same, raise error
512: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 523: RAISE FND_API.G_EXC_ERROR;

519: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
520:
521: END IF;
522:
523: RAISE FND_API.G_EXC_ERROR;
524:
525: END IF;
526:
527: ELSIF p_user_conversion_type IS NOT NULL THEN

Line 530: IF l_debug = FND_API.G_TRUE THEN

526:
527: ELSIF p_user_conversion_type IS NOT NULL THEN
528: -- p_user_conversion_type <> 'USER' THEN
529:
530: IF l_debug = FND_API.G_TRUE THEN
531: qp_preq_grp.engine_debug('Currency_Conversion_API - x_from_currency = '||base_currency_code_t(J) );
532: qp_preq_grp.engine_debug('Currency_Conversion_API - x_to_currency = '|| to_currency_code_t(J));
533: qp_preq_grp.engine_debug('Currency_Conversion_API - x_conversion_date = '|| pricing_effective_date_t(J));
534: qp_preq_grp.engine_debug('Currency_Conversion_API - x_conversion_type = '|| p_user_conversion_type);

Line 546: IF l_debug = FND_API.G_TRUE THEN

542: ,x_conversion_date => pricing_effective_date_t(J)
543: ,x_conversion_type => p_user_conversion_type
544: );
545:
546: IF l_debug = FND_API.G_TRUE THEN
547: qp_preq_grp.engine_debug('Currency_Conversion_API - GL l_conversion_rate = '|| l_conversion_rate);
548: END IF;
549:
550: IF l_conversion_rate = -1 THEN

Line 566: RAISE FND_API.G_EXC_ERROR;

562: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
563:
564: END IF;
565:
566: RAISE FND_API.G_EXC_ERROR;
567:
568: ELSIF l_conversion_rate = -2 THEN
569:
570: -- Base currency or/and order currency are in valid, raise error

Line 581: RAISE FND_API.G_EXC_ERROR;

577:
578:
579: END IF;
580:
581: RAISE FND_API.G_EXC_ERROR;
582:
583: END IF;
584:
585:

Line 588: IF l_debug = FND_API.G_TRUE THEN

584:
585:
586: ELSE
587:
588: IF l_debug = FND_API.G_TRUE THEN
589: qp_preq_grp.engine_debug('Currency_Conversion_API - TRANSACTION no conversion type ');
590: END IF;
591: -- For 'TRANSACTION' conv, OM did not pass user conversion type, raise error
592: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 603: RAISE FND_API.G_EXC_ERROR;

599:
600: END IF;
601:
602:
603: RAISE FND_API.G_EXC_ERROR;
604:
605: END IF;
606:
607:

Line 627: IF l_formula_status <> FND_API.G_RET_STS_SUCCESS THEN

623: ,l_formula_status
624: );
625:
626:
627: IF l_formula_status <> FND_API.G_RET_STS_SUCCESS THEN
628:
629: IF l_debug = FND_API.G_TRUE THEN
630: qp_preq_grp.engine_debug('Currency_Conversion_API - FORMULA not success');
631: END IF;

Line 629: IF l_debug = FND_API.G_TRUE THEN

625:
626:
627: IF l_formula_status <> FND_API.G_RET_STS_SUCCESS THEN
628:
629: IF l_debug = FND_API.G_TRUE THEN
630: qp_preq_grp.engine_debug('Currency_Conversion_API - FORMULA not success');
631: END IF;
632: -- Formula calculation failed, raise error
633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 642: RAISE FND_API.G_EXC_ERROR;

638: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
639:
640: END IF;
641:
642: RAISE FND_API.G_EXC_ERROR;
643:
644: END IF;
645:
646:

Line 655: IF l_debug = FND_API.G_TRUE THEN

651:
652: -- Use the rate returned from the formula calculation
653: l_conversion_rate := l_formula_based_value;
654:
655: IF l_debug = FND_API.G_TRUE THEN
656: qp_preq_grp.engine_debug('Currency_Conversion_API - FORMULA l_conversion_rate'
657: || l_conversion_rate);
658: END IF;
659: --End of processing conversion type ='FORMULA'

Line 663: IF l_debug = FND_API.G_TRUE THEN

659: --End of processing conversion type ='FORMULA'
660:
661: ELSIF conversion_type_t(J) IS NULL THEN
662:
663: IF l_debug = FND_API.G_TRUE THEN
664: qp_preq_grp.engine_debug('Currency_Conversion_API - null conversion type');
665: END IF;
666: IF to_currency_code_t(J) = base_currency_code_t(J) THEN
667:

Line 668: IF l_debug = FND_API.G_TRUE THEN

664: qp_preq_grp.engine_debug('Currency_Conversion_API - null conversion type');
665: END IF;
666: IF to_currency_code_t(J) = base_currency_code_t(J) THEN
667:
668: IF l_debug = FND_API.G_TRUE THEN
669: qp_preq_grp.engine_debug('Currency_Conversion_API - null conversion type - curr matches');
670: END IF;
671: --There order currency and base currency are same, the conversion rate is 1
672:

Line 681: IF l_debug = FND_API.G_TRUE THEN

677:
678: ELSE --All conversion types other than FIXED, TRANSACTION and FORMULA
679:
680: IF conversion_date_type_t(J) = 'FIXED' THEN
681: IF l_debug = FND_API.G_TRUE THEN
682: qp_preq_grp.engine_debug('Currency_Conversion_API - date type FIXED');
683: END IF;
684: l_conversion_date := conversion_date_t(J);
685: ELSE

Line 697: IF l_debug = FND_API.G_TRUE THEN

693: ,x_conversion_date => l_conversion_date
694: ,x_conversion_type => conversion_type_t(J)
695: );
696:
697: IF l_debug = FND_API.G_TRUE THEN
698: qp_preq_grp.engine_debug('Currency_Conversion_API - GL2 l_conversion_rate'
699: || l_conversion_rate);
700: END IF;
701: IF l_conversion_rate = -1 THEN

Line 717: RAISE FND_API.G_EXC_ERROR;

713: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
714:
715: END IF;
716:
717: RAISE FND_API.G_EXC_ERROR;
718:
719: ELSIF l_conversion_rate = -2 THEN
720:
721: -- Base currency or/and order currency are in valid, raise error

Line 731: RAISE FND_API.G_EXC_ERROR;

727: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
728:
729: END IF;
730:
731: RAISE FND_API.G_EXC_ERROR;
732:
733: END IF;
734:
735:

Line 741: IF l_debug = FND_API.G_TRUE THEN

737:
738: --End of processing of conversion_rate
739:
740:
741: IF l_debug = FND_API.G_TRUE THEN
742: qp_preq_grp.engine_debug('Currency_Conversion_API - operand_value = '
743: || operand_value_t(J));
744: qp_preq_grp.engine_debug('Currency_Conversion_API - l_conversion_rate = '
745: || l_conversion_rate);

Line 754: IF l_debug = FND_API.G_TRUE THEN

750: -- "Item and uom is not on the pricelist"
751: --result_operand_value_t(J) := NVL(operand_value_t(J), 1) * l_conversion_rate;
752: result_operand_value_t(J) := operand_value_t(J) * l_conversion_rate;
753:
754: IF l_debug = FND_API.G_TRUE THEN
755: qp_preq_grp.engine_debug('Currency_Conversion_API - result_operand_value = '
756: || result_operand_value_t(J));
757: END IF;
758: -- Start processing Markup

Line 760: IF l_debug = FND_API.G_TRUE THEN

756: || result_operand_value_t(J));
757: END IF;
758: -- Start processing Markup
759:
760: IF l_debug = FND_API.G_TRUE THEN
761: qp_preq_grp.engine_debug('Currency_Conversion_API - markup_value = '
762: || markup_value_t(J));
763: qp_preq_grp.engine_debug('Currency_Conversion_API - markup_formula_id = '
764: || markup_formula_id_t(J));

Line 775: IF l_debug = FND_API.G_TRUE THEN

771: IF markup_operator_t(J) = '%' THEN
772:
773: result_operand_value_t(J) := result_operand_value_t(J) +
774: (result_operand_value_t(J) * (markup_value_t(J) / 100));
775: IF l_debug = FND_API.G_TRUE THEN
776: qp_preq_grp.engine_debug('Currency_Conversion_API - markup % result_operand_value = '
777: || result_operand_value_t(J));
778:
779: END IF;

Line 783: IF l_debug = FND_API.G_TRUE THEN

779: END IF;
780: ELSIF markup_operator_t(J) = 'AMT' THEN
781:
782: result_operand_value_t(J) := result_operand_value_t(J) + markup_value_t(J);
783: IF l_debug = FND_API.G_TRUE THEN
784: qp_preq_grp.engine_debug('Currency_Conversion_API - markup AMT result_operand_value = '
785: || result_operand_value_t(J));
786: END IF;
787:

Line 795: IF l_debug = FND_API.G_TRUE THEN

791:
792:
793:
794: IF markup_formula_id_t(J) IS NOT NULL THEN
795: IF l_debug = FND_API.G_TRUE THEN
796: qp_preq_grp.engine_debug('Currency_Conversion_API - markup formula NOT null ');
797: END IF;
798:
799: --call the process formula API

Line 814: IF l_formula_status <> FND_API.G_RET_STS_SUCCESS THEN

810: ,l_formula_status
811: );
812:
813:
814: IF l_formula_status <> FND_API.G_RET_STS_SUCCESS THEN
815:
816: IF l_debug = FND_API.G_TRUE THEN
817: qp_preq_grp.engine_debug('Currency_Conversion_API - markup formula fails ');
818: END IF;

Line 816: IF l_debug = FND_API.G_TRUE THEN

812:
813:
814: IF l_formula_status <> FND_API.G_RET_STS_SUCCESS THEN
815:
816: IF l_debug = FND_API.G_TRUE THEN
817: qp_preq_grp.engine_debug('Currency_Conversion_API - markup formula fails ');
818: END IF;
819: -- Formula calculation failed, raise error
820: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 829: RAISE FND_API.G_EXC_ERROR;

825: lines_status_code_t(J) := QP_PREQ_GRP.G_STATUS_OTHER_ERRORS;
826:
827: END IF;
828:
829: RAISE FND_API.G_EXC_ERROR;
830:
831: END IF;
832:
833:

Line 841: IF l_debug = FND_API.G_TRUE THEN

837:
838: result_operand_value_t(J) := result_operand_value_t(J) +
839: (result_operand_value_t(J) * (l_formula_based_value/100));
840:
841: IF l_debug = FND_API.G_TRUE THEN
842: qp_preq_grp.engine_debug('Currency_Conversion_API - markup % result_operand_value = '
843: || result_operand_value_t(J));
844: END IF;
845: ELSIF markup_operator_t(J) = 'AMT' THEN

Line 848: IF l_debug = FND_API.G_TRUE THEN

844: END IF;
845: ELSIF markup_operator_t(J) = 'AMT' THEN
846:
847: result_operand_value_t(J) := result_operand_value_t(J) + l_formula_based_value;
848: IF l_debug = FND_API.G_TRUE THEN
849: qp_preq_grp.engine_debug('Currency_Conversion_API - markup AMT result_operand_value = '
850: || result_operand_value_t(J));
851:
852: END IF;

Line 862: IF l_debug = FND_API.G_TRUE THEN

858: -- Call Process Rounding API
859:
860: -- l_conversion_rate := l_conversion_rate * Value returned from Rounding;
861: if p_rounding_flag = 'Y' then
862: IF l_debug = FND_API.G_TRUE THEN
863: qp_preq_grp.engine_debug('Currency_Conversion_API - p_rounding_flag = '
864: || p_rounding_flag);
865: END IF;
866: qp_util_pub.round_price(

Line 879: IF l_debug = FND_API.G_TRUE THEN

875: ,p_operand_type => 'S'
876: );
877:
878: IF l_round_price_status <> 'S' THEN
879: IF l_debug = FND_API.G_TRUE THEN
880: qp_preq_grp.engine_debug('Currency_Conversion_API - round_price fails ');
881: END IF;
882:
883: -- Formula calculation failed, raise error

Line 886: status_code_t(J) := FND_API.G_RET_STS_ERROR;

882:
883: -- Formula calculation failed, raise error
884: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
885: error_message_t(J) := FND_MESSAGE.GET;
886: status_code_t(J) := FND_API.G_RET_STS_ERROR;
887: lines_status_code_t(J) := FND_API.G_RET_STS_ERROR;
888:
889: END IF;
890:

Line 887: lines_status_code_t(J) := FND_API.G_RET_STS_ERROR;

883: -- Formula calculation failed, raise error
884: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
885: error_message_t(J) := FND_MESSAGE.GET;
886: status_code_t(J) := FND_API.G_RET_STS_ERROR;
887: lines_status_code_t(J) := FND_API.G_RET_STS_ERROR;
888:
889: END IF;
890:
891: RAISE FND_API.G_EXC_ERROR;

Line 891: RAISE FND_API.G_EXC_ERROR;

887: lines_status_code_t(J) := FND_API.G_RET_STS_ERROR;
888:
889: END IF;
890:
891: RAISE FND_API.G_EXC_ERROR;
892:
893: END IF;
894: IF l_debug = FND_API.G_TRUE THEN
895: qp_preq_grp.engine_debug('Currency_Conversion_API - after rounding result_operand_value = '

Line 894: IF l_debug = FND_API.G_TRUE THEN

890:
891: RAISE FND_API.G_EXC_ERROR;
892:
893: END IF;
894: IF l_debug = FND_API.G_TRUE THEN
895: qp_preq_grp.engine_debug('Currency_Conversion_API - after rounding result_operand_value = '
896: || result_operand_value_t(J));
897:
898: END IF;

Line 903: WHEN FND_API.G_EXC_ERROR THEN

899: END IF; -- rounding flag
900:
901: EXCEPTION
902:
903: WHEN FND_API.G_EXC_ERROR THEN
904: IF l_debug = FND_API.G_TRUE THEN
905: qp_preq_grp.engine_debug('Currency_Conversion_API - handle exception FND_API.G_EXC_ERROR');
906:
907: END IF;

Line 904: IF l_debug = FND_API.G_TRUE THEN

900:
901: EXCEPTION
902:
903: WHEN FND_API.G_EXC_ERROR THEN
904: IF l_debug = FND_API.G_TRUE THEN
905: qp_preq_grp.engine_debug('Currency_Conversion_API - handle exception FND_API.G_EXC_ERROR');
906:
907: END IF;
908: NULL;

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

901: EXCEPTION
902:
903: WHEN FND_API.G_EXC_ERROR THEN
904: IF l_debug = FND_API.G_TRUE THEN
905: qp_preq_grp.engine_debug('Currency_Conversion_API - handle exception FND_API.G_EXC_ERROR');
906:
907: END IF;
908: NULL;
909:

Line 920: IF l_debug = FND_API.G_TRUE THEN

916: END LOOP;
917:
918: END IF; --IF line_index_t.count>0
919:
920: IF l_debug = FND_API.G_TRUE THEN
921: qp_preq_grp.engine_debug('Currency_Conversion_API - BEFORE updating the temp tables = ');
922: qp_preq_grp.engine_debug('Currency_Conversion_API - line_index_t.count' || line_index_t.count);
923: END IF;
924: --sql statement upd1

Line 927: IF l_debug = FND_API.G_TRUE THEN

923: END IF;
924: --sql statement upd1
925: IF line_index_t.count > 0 THEN
926:
927: IF l_debug = FND_API.G_TRUE THEN
928: qp_preq_grp.engine_debug('Currency_Conversion_API - updating the temp tables = ');
929:
930: END IF;
931: FORALL K IN line_index_t.FIRST..line_index_t.LAST

Line 953: IF l_debug = FND_API.G_TRUE THEN

949: WHERE line_index = line_index_t(K);
950:
951: END IF;
952:
953: IF l_debug = FND_API.G_TRUE THEN
954: qp_preq_grp.engine_debug('Currency_Conversion_API - after updating the temp tables ');
955:
956: END IF;
957: EXIT WHEN c_currency_conversions%NOTFOUND;

Line 968: WHEN FND_API.G_EXC_ERROR THEN

964:
965: EXCEPTION
966:
967: /*
968: WHEN FND_API.G_EXC_ERROR THEN
969:
970: l_process_status := FND_API.G_RET_STS_ERROR;
971:
972: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 970: l_process_status := FND_API.G_RET_STS_ERROR;

966:
967: /*
968: WHEN FND_API.G_EXC_ERROR THEN
969:
970: l_process_status := FND_API.G_RET_STS_ERROR;
971:
972: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
973:
974: FND_MESSAGE.SET_NAME('QP','QP_CURR_CONV_EXP_ERROR');

Line 978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

974: FND_MESSAGE.SET_NAME('QP','QP_CURR_CONV_EXP_ERROR');
975:
976: END IF;
977: */
978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
979:
980: l_process_status := FND_API.G_RET_STS_UNEXP_ERROR;
981:
982: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 980: l_process_status := FND_API.G_RET_STS_UNEXP_ERROR;

976: END IF;
977: */
978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
979:
980: l_process_status := FND_API.G_RET_STS_UNEXP_ERROR;
981:
982: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
983:
984: FND_MESSAGE.SET_NAME('QP','QP_CURR_CONV_UNEXPECTED_ERROR');

Line 990: IF l_debug = FND_API.G_TRUE THEN

986: END IF;
987:
988: WHEN OTHERS THEN
989:
990: IF l_debug = FND_API.G_TRUE THEN
991: qp_preq_grp.engine_debug('Currency_Conversion_API - OTHERS exception SQLERRM' || SQLERRM);
992: END IF;
993: l_process_status := FND_API.G_RET_STS_UNEXP_ERROR;
994:

Line 993: l_process_status := FND_API.G_RET_STS_UNEXP_ERROR;

989:
990: IF l_debug = FND_API.G_TRUE THEN
991: qp_preq_grp.engine_debug('Currency_Conversion_API - OTHERS exception SQLERRM' || SQLERRM);
992: END IF;
993: l_process_status := FND_API.G_RET_STS_UNEXP_ERROR;
994:
995: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
996:
997: FND_MSG_PUB.Add_Exc_Msg

Line 1008: IF l_debug = FND_API.G_TRUE THEN

1004: IF c_currency_conversions%ISOPEN THEN
1005: CLOSE c_currency_conversions;
1006: END IF;
1007:
1008: IF l_debug = FND_API.G_TRUE THEN
1009: qp_preq_grp.engine_debug('Currency_Conversion_API - End');
1010: END IF;
1011: END Currency_Conversion_Api;
1012: