DBA Data[Home] [Help]

APPS.ASO_BI_POPULATE_FACTS dependencies on BIS_COMMON_PARAMETERS

Line 25: l_rate_type := BIS_COMMON_PARAMETERS.Get_Rate_Type;

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

Line 26: l_sec_rate_type := BIS_COMMON_PARAMETERS.Get_Secondary_Rate_Type;

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:

Line 215: l_global_prim_rate_type := BIS_COMMON_PARAMETERS.Get_Rate_Type;

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

Line 253: l_global_sec_rate_type := BIS_COMMON_PARAMETERS.Get_Secondary_Rate_Type;

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

Line 254: l_global_prim_rate_type := BIS_COMMON_PARAMETERS.Get_Rate_Type;

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:

Line 367: l_global_rate := BIS_COMMON_PARAMETERS.Get_Rate_Type;

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:

Line 368: l_sec_rate_type := BIS_COMMON_PARAMETERS.Get_Secondary_Rate_Type;

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 )

Line 589: g_prim_currency := bis_common_parameters.get_currency_code;

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

Line 590: g_sec_currency := bis_common_parameters.get_secondary_currency_code;

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 */

Line 603: IF NOT(bis_common_parameters.check_global_parameters(l_list))

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

Line 779: g_prim_currency := bis_common_parameters.get_currency_code;

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)

Line 780: g_sec_currency := bis_common_parameters.get_secondary_currency_code;

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

Line 809: IF NOT(bis_common_parameters.check_global_parameters(l_list))

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

Line 966: g_prim_currency := bis_common_parameters.get_currency_code;

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

Line 967: g_sec_currency := bis_common_parameters.get_secondary_currency_code;

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:

Line 985: IF NOT(bis_common_parameters.check_global_parameters(l_list))

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

Line 1190: g_prim_currency := bis_common_parameters.get_currency_code;

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)

Line 1191: g_sec_currency := bis_common_parameters.get_secondary_currency_code;

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

Line 1224: IF NOT(bis_common_parameters.check_global_parameters(l_list))

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