21: BEGIN
22: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
23: BIS_COLLECTION_UTILITIES.Debug('In Populate Currency Rates');
24: END IF;
25: l_rate_type := BIS_COMMON_PARAMETERS.Get_Rate_Type;
26: l_sec_rate_type := BIS_COMMON_PARAMETERS.Get_Secondary_Rate_Type;
27: l_func_rate_type := fnd_profile.value('BIS_TREASURY_RATE_TYPE');
28:
29: IF p_run_type = 'INIT' THEN -- initial
22: IF(BIS_COLLECTION_UTILITIES.g_debug) THEN
23: BIS_COLLECTION_UTILITIES.Debug('In Populate Currency Rates');
24: END IF;
25: l_rate_type := BIS_COMMON_PARAMETERS.Get_Rate_Type;
26: l_sec_rate_type := BIS_COMMON_PARAMETERS.Get_Secondary_Rate_Type;
27: l_func_rate_type := fnd_profile.value('BIS_TREASURY_RATE_TYPE');
28:
29: IF p_run_type = 'INIT' THEN -- initial
30:
211: WHERE (prim_conversion_rate < 0
212: OR prim_conversion_rate IS NULL) and rownum < 2;
213:
214: If(l_cnt_miss_rate > 0 ) Then
215: l_global_prim_rate_type := BIS_COMMON_PARAMETERS.Get_Rate_Type;
216:
217: BIS_COLLECTION_UTILITIES.put_line_out('Missing Primary Currency Rates Found!');
218: BIS_COLLECTION_UTILITIES.put_line('Missing Primary Currency Rates Found!');
219: FND_MESSAGE.Set_Name('FII',l_msg_name);
249: WHERE ((sec_conversion_rate < 0 OR sec_conversion_rate IS NULL)
250: OR (prim_conversion_rate < 0 OR prim_conversion_rate IS NULL)) and rownum < 2;
251:
252: If(l_cnt_miss_rate > 0 ) Then
253: l_global_sec_rate_type := BIS_COMMON_PARAMETERS.Get_Secondary_Rate_Type;
254: l_global_prim_rate_type := BIS_COMMON_PARAMETERS.Get_Rate_Type;
255:
256: BIS_COLLECTION_UTILITIES.put_line_out('Missing Primary/Secondary Currency Coversin Rates Found!');
257: BIS_COLLECTION_UTILITIES.put_line('Missing Primary/Secondary Currency Coversin Rates Found!');
250: OR (prim_conversion_rate < 0 OR prim_conversion_rate IS NULL)) and rownum < 2;
251:
252: If(l_cnt_miss_rate > 0 ) Then
253: l_global_sec_rate_type := BIS_COMMON_PARAMETERS.Get_Secondary_Rate_Type;
254: l_global_prim_rate_type := BIS_COMMON_PARAMETERS.Get_Rate_Type;
255:
256: BIS_COLLECTION_UTILITIES.put_line_out('Missing Primary/Secondary Currency Coversin Rates Found!');
257: BIS_COLLECTION_UTILITIES.put_line('Missing Primary/Secondary Currency Coversin Rates Found!');
258:
363: OR (func_conversion_rate<0 OR func_conversion_rate IS NULL)
364: OR (sec_conversion_rate <0 OR sec_conversion_rate IS NULL) and rownum < 2;
365: END IF;
366:
367: l_global_rate := BIS_COMMON_PARAMETERS.Get_Rate_Type;
368: l_sec_rate_type := BIS_COMMON_PARAMETERS.Get_Secondary_Rate_Type;
369:
370: BIS_COLLECTION_UTILITIES.put_line('Missing Primary Currency/Functional Currency Count '||l_cnt_miss_rate);
371:
364: OR (sec_conversion_rate <0 OR sec_conversion_rate IS NULL) and rownum < 2;
365: END IF;
366:
367: l_global_rate := BIS_COMMON_PARAMETERS.Get_Rate_Type;
368: l_sec_rate_type := BIS_COMMON_PARAMETERS.Get_Secondary_Rate_Type;
369:
370: BIS_COLLECTION_UTILITIES.put_line('Missing Primary Currency/Functional Currency Count '||l_cnt_miss_rate);
371:
372: If(l_cnt_miss_rate > 0 )
585: END IF;
586:
587: ASO_BI_UTIL_PVT.INIT;
588:
589: g_prim_currency := bis_common_parameters.get_currency_code;
590: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
591:
592: l_list(1) := 'BIS_PRIMARY_CURRENCY_CODE';
593: l_list(2) := 'BIS_PRIMARY_RATE_TYPE';
586:
587: ASO_BI_UTIL_PVT.INIT;
588:
589: g_prim_currency := bis_common_parameters.get_currency_code;
590: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
591:
592: l_list(1) := 'BIS_PRIMARY_CURRENCY_CODE';
593: l_list(2) := 'BIS_PRIMARY_RATE_TYPE';
594: /* Check for Seondary global currency implemeneted */
599: ELSE
600: BIS_COLLECTION_UTILITIES.put_line_out('Secondary Global Currency Not Implemented!!');
601: BIS_COLLECTION_UTILITIES.put_line('Secondary Global Currency Not Implemented!!');
602: END IF;
603: IF NOT(bis_common_parameters.check_global_parameters(l_list))
604: THEN
605: errbuf := FND_MESSAGE.Get;
606: retcode := -1;
607: -- RAISE_APPLICATION_ERROR(-20000,errbuf);
775: --Purge the Base Fact Table for Quote Headers and the Refresh Log
776: --for the Quote Headers load.
777: BIS_COLLECTION_UTILITIES.deleteLogForObject('ASO_BI_POPULATE_FACTS');
778:
779: g_prim_currency := bis_common_parameters.get_currency_code;
780: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
781:
782: IF(BIS_COLLECTION_UTILITIES.Setup(
783: p_object_name => 'ASO_BI_POPULATE_FACTS') = false)
776: --for the Quote Headers load.
777: BIS_COLLECTION_UTILITIES.deleteLogForObject('ASO_BI_POPULATE_FACTS');
778:
779: g_prim_currency := bis_common_parameters.get_currency_code;
780: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
781:
782: IF(BIS_COLLECTION_UTILITIES.Setup(
783: p_object_name => 'ASO_BI_POPULATE_FACTS') = false)
784: Then
805: ELSE
806: BIS_COLLECTION_UTILITIES.put_line_out('Secondary Global Currency Not Implemented!!');
807: BIS_COLLECTION_UTILITIES.put_line('Secondary Global Currency Not Implemented!!');
808: END IF;
809: IF NOT(bis_common_parameters.check_global_parameters(l_list))
810: THEN
811: errbuf := FND_MESSAGE.Get;
812: retcode := -1;
813: -- RAISE_APPLICATION_ERROR(-20000,errbuf);
962: END IF;
963: BIS_COLLECTION_UTILITIES.put_line('Initialization started ');
964: ASO_BI_UTIL_PVT.INIT;
965:
966: g_prim_currency := bis_common_parameters.get_currency_code;
967: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
968:
969: BIS_COLLECTION_UTILITIES.put_line_out('Primary Currency '||g_prim_currency);
970: BIS_COLLECTION_UTILITIES.put_line_out('Secondary Currency '||g_sec_currency);
963: BIS_COLLECTION_UTILITIES.put_line('Initialization started ');
964: ASO_BI_UTIL_PVT.INIT;
965:
966: g_prim_currency := bis_common_parameters.get_currency_code;
967: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
968:
969: BIS_COLLECTION_UTILITIES.put_line_out('Primary Currency '||g_prim_currency);
970: BIS_COLLECTION_UTILITIES.put_line_out('Secondary Currency '||g_sec_currency);
971:
981: ELSE
982: BIS_COLLECTION_UTILITIES.put_line_out('Secondary Global Currency Not Implemented!!');
983: BIS_COLLECTION_UTILITIES.put_line('Secondary Global Currency Not Implemented!!');
984: END IF;
985: IF NOT(bis_common_parameters.check_global_parameters(l_list))
986: THEN
987: errbuf := FND_MESSAGE.Get;
988: retcode := -1;
989: -- RAISE_APPLICATION_ERROR(-20000,errbuf);
1186: --Purge the Base Fact Table for Quote Lines and the Refresh debug
1187: --for the Quote Lines load.
1188: BIS_COLLECTION_UTILITIES.deleteLogForObject('ASO_BI_LINE_FACTS');
1189:
1190: g_prim_currency := bis_common_parameters.get_currency_code;
1191: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
1192:
1193: BIS_COLLECTION_UTILITIES.put_line('Secondary Currency :'||g_sec_currency);
1194: IF(BIS_COLLECTION_UTILITIES.Setup(p_object_name => 'ASO_BI_LINE_FACTS') = false)
1187: --for the Quote Lines load.
1188: BIS_COLLECTION_UTILITIES.deleteLogForObject('ASO_BI_LINE_FACTS');
1189:
1190: g_prim_currency := bis_common_parameters.get_currency_code;
1191: g_sec_currency := bis_common_parameters.get_secondary_currency_code;
1192:
1193: BIS_COLLECTION_UTILITIES.put_line('Secondary Currency :'||g_sec_currency);
1194: IF(BIS_COLLECTION_UTILITIES.Setup(p_object_name => 'ASO_BI_LINE_FACTS') = false)
1195: Then
1220: ELSE
1221: BIS_COLLECTION_UTILITIES.put_line_out('Secondary Global Currency Not Implemented!!');
1222: BIS_COLLECTION_UTILITIES.put_line('Secondary Global Currency Not Implemented!!');
1223: END IF;
1224: IF NOT(bis_common_parameters.check_global_parameters(l_list))
1225: THEN
1226: errbuf := FND_MESSAGE.Get;
1227: retcode := -1;
1228: -- RAISE_APPLICATION_ERROR(-20000,errbuf);