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 88: IF l_debug = FND_API.G_TRUE THEN

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 = '
92: || l_price_formula_id);

Line 110: l_return_status := FND_API.G_RET_STS_SUCCESS;

106: END IF;
107:
108: qp_debug_util.tstart('PROCESS_FORMULA_API', 'PROCESS_FORMULA_API'); --by smuhamme
109:
110: l_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112: IF l_insert_into_tmp = 'Y' THEN
113:
114: -- Change flexible mask to mask below for formula pattern use

Line 372: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN

368: ,x_return_status => l_status
369: ,p_modifier_value => l_modifier_value
370: );
371:
372: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
373:
374: l_return_status := FND_API.G_RET_STS_ERROR;
375:
376: END IF;

Line 374: l_return_status := FND_API.G_RET_STS_ERROR;

370: );
371:
372: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
373:
374: l_return_status := FND_API.G_RET_STS_ERROR;
375:
376: END IF;
377:
378:

Line 379: IF l_debug = FND_API.G_TRUE THEN

375:
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

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 396: IF l_debug = FND_API.G_TRUE THEN

392: 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;

Line 400: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
402: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403:
404:

Line 402: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

398: || SQLERRM);
399: END IF;
400: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
401:
402: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403:
404:
405: END Process_Formula_API;
406:

Line 527: IF l_debug = FND_API.G_TRUE THEN

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:
531: IF l_debug = FND_API.G_TRUE THEN

Line 531: IF l_debug = FND_API.G_TRUE THEN

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);
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);

Line 589: IF l_debug = FND_API.G_TRUE THEN

585: markup_formula_id_t
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

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

598: BEGIN
599:
600: --l_insert_into_tmp := 'Y'; --moved before the loop, smuhamme bug#8323485
601:
602: --l_process_status := FND_API.G_RET_STS_SUCCESS;
603:
604: error_message_t(J) := NULL;
605:
606: -- status_code_t is used for updating the qp_npreq_ldets_tmp table Bug 2327718

Line 618: IF l_debug = FND_API.G_TRUE THEN

614: l_conversion_rate := NULL;
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

Line 627: IF l_debug = FND_API.G_TRUE THEN

623:
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:

Line 642: IF l_debug = FND_API.G_TRUE THEN

638: IF p_function_currency = base_currency_code_t(J) THEN
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

Line 649: IF l_debug = FND_API.G_TRUE THEN

645:
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;

Line 656: IF l_debug = FND_API.G_TRUE THEN

652:
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

Line 671: RAISE FND_API.G_EXC_ERROR;

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;
672:
673: END IF;
674:
675: ELSIF p_user_conversion_type IS NOT NULL THEN

Line 678: IF l_debug = FND_API.G_TRUE THEN

674:
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);

Line 694: IF l_debug = FND_API.G_TRUE THEN

690: ,x_conversion_date => pricing_effective_date_t(J)
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

Line 714: RAISE FND_API.G_EXC_ERROR;

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;
715:
716: ELSIF l_conversion_rate = -2 THEN
717:
718: -- Base currency or/and order currency are in valid, raise error

Line 729: RAISE FND_API.G_EXC_ERROR;

725:
726:
727: END IF;
728:
729: RAISE FND_API.G_EXC_ERROR;
730:
731: END IF;
732:
733:

Line 736: IF l_debug = FND_API.G_TRUE THEN

732:
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

Line 751: RAISE FND_API.G_EXC_ERROR;

747:
748: END IF;
749:
750:
751: RAISE FND_API.G_EXC_ERROR;
752:
753: END IF;
754:
755:

Line 775: IF l_formula_status <> FND_API.G_RET_STS_SUCCESS THEN

771: ,l_formula_status
772: );
773:
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;

Line 777: IF l_debug = FND_API.G_TRUE THEN

773:
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

Line 790: RAISE FND_API.G_EXC_ERROR;

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;
791:
792: END IF;
793:
794:

Line 803: IF l_debug = FND_API.G_TRUE THEN

799:
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'

Line 811: IF l_debug = FND_API.G_TRUE THEN

807: --End of processing conversion type ='FORMULA'
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:

Line 816: 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
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:

Line 829: IF l_debug = FND_API.G_TRUE THEN

825:
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

Line 843: IF l_debug = FND_API.G_TRUE THEN

839: IF p_function_currency = base_currency_code_t(J) THEN
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;

Line 848: 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
849: qp_preq_grp.engine_debug('Currency_Conversion_API - l_conversion_rate = '
850: ||l_conversion_rate);
851:
852: END IF;

Line 855: IF l_debug = FND_API.G_TRUE THEN

851:
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

Line 870: RAISE FND_API.G_EXC_ERROR;

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;
871:
872: END IF;
873:
874: ELSE

Line 892: IF l_debug = FND_API.G_TRUE THEN

888: --,x_conversion_type => conversion_type_t(J) --bug 9503901
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

Line 912: RAISE FND_API.G_EXC_ERROR;

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;
913:
914: ELSIF l_conversion_rate = -2 THEN
915:
916: -- Base currency or/and order currency are in valid, raise error

Line 926: RAISE FND_API.G_EXC_ERROR;

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;
927:
928: END IF;
929:
930:

Line 936: IF l_debug = FND_API.G_TRUE THEN

932: END IF ;
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);

Line 949: IF l_debug = FND_API.G_TRUE THEN

945: -- "Item and uom is not on the pricelist"
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

Line 955: IF l_debug = FND_API.G_TRUE THEN

951: || result_operand_value_t(J));
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));

Line 970: IF l_debug = FND_API.G_TRUE THEN

966: IF markup_operator_t(J) = '%' THEN
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;

Line 978: IF l_debug = FND_API.G_TRUE THEN

974: END IF;
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:

Line 990: IF l_debug = FND_API.G_TRUE THEN

986:
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

Line 1009: IF l_formula_status <> FND_API.G_RET_STS_SUCCESS THEN

1005: ,l_formula_status
1006: );
1007:
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;

Line 1011: IF l_debug = FND_API.G_TRUE THEN

1007:
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

Line 1024: RAISE FND_API.G_EXC_ERROR;

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;
1025:
1026: END IF;
1027:
1028:

Line 1036: IF l_debug = FND_API.G_TRUE THEN

1032:
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

Line 1043: IF l_debug = FND_API.G_TRUE THEN

1039: END IF;
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;

Line 1057: IF l_debug = FND_API.G_TRUE THEN

1053: -- Call Process Rounding API
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(

Line 1074: IF l_debug = FND_API.G_TRUE THEN

1070: ,p_operand_type => 'S'
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

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

1077:
1078: -- Formula calculation failed, raise error
1079: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1080: error_message_t(J) := FND_MESSAGE.GET;
1081: status_code_t(J) := FND_API.G_RET_STS_ERROR;
1082: lines_status_code_t(J) := FND_API.G_RET_STS_ERROR;
1083:
1084: END IF;
1085:

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

1078: -- Formula calculation failed, raise error
1079: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1080: error_message_t(J) := FND_MESSAGE.GET;
1081: status_code_t(J) := FND_API.G_RET_STS_ERROR;
1082: lines_status_code_t(J) := FND_API.G_RET_STS_ERROR;
1083:
1084: END IF;
1085:
1086: RAISE FND_API.G_EXC_ERROR;

Line 1086: RAISE FND_API.G_EXC_ERROR;

1082: lines_status_code_t(J) := FND_API.G_RET_STS_ERROR;
1083:
1084: END IF;
1085:
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 = '

Line 1089: IF l_debug = FND_API.G_TRUE THEN

1085:
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;

Line 1098: WHEN FND_API.G_EXC_ERROR THEN

1094: END IF; -- rounding flag
1095:
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;

Line 1099: IF l_debug = FND_API.G_TRUE THEN

1095:
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;

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 1115: IF l_debug = FND_API.G_TRUE THEN

1111: END LOOP;
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

Line 1122: IF l_debug = FND_API.G_TRUE THEN

1118: END IF;
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

Line 1148: IF l_debug = FND_API.G_TRUE THEN

1144: WHERE line_index = line_index_t(K);
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;

Line 1163: WHEN FND_API.G_EXC_ERROR THEN

1159:
1160: EXCEPTION
1161:
1162: /*
1163: WHEN FND_API.G_EXC_ERROR THEN
1164:
1165: l_process_status := FND_API.G_RET_STS_ERROR;
1166:
1167: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1165: l_process_status := FND_API.G_RET_STS_ERROR;

1161:
1162: /*
1163: WHEN FND_API.G_EXC_ERROR THEN
1164:
1165: l_process_status := FND_API.G_RET_STS_ERROR;
1166:
1167: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1168:
1169: FND_MESSAGE.SET_NAME('QP','QP_CURR_CONV_EXP_ERROR');

Line 1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1169: FND_MESSAGE.SET_NAME('QP','QP_CURR_CONV_EXP_ERROR');
1170:
1171: END IF;
1172: */
1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1174:
1175: l_process_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176:
1177: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1175: l_process_status := FND_API.G_RET_STS_UNEXP_ERROR;

1171: END IF;
1172: */
1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1174:
1175: l_process_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176:
1177: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1178:
1179: FND_MESSAGE.SET_NAME('QP','QP_CURR_CONV_UNEXPECTED_ERROR');

Line 1185: IF l_debug = FND_API.G_TRUE THEN

1181: END IF;
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:

Line 1188: l_process_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
1191:
1192: FND_MSG_PUB.Add_Exc_Msg

Line 1203: IF l_debug = FND_API.G_TRUE THEN

1199: IF c_currency_conversions%ISOPEN THEN
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: