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.BIM_I_BGT_FACTS_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 57: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);

53:
54: If(l_cnt_miss_rate1 > 0 )
55: Then
56: FND_MESSAGE.Set_Name('FII',l_msg_name);
57: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);
58: BIS_COLLECTION_UTILITIES.log('Primary Conversion rate could not be found for the given currency. Please check output file for more details' );
59: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
60: FOR rate_record1 in C_missing_rates1
61: LOOP

Line 58: BIS_COLLECTION_UTILITIES.log('Primary Conversion rate could not be found for the given currency. Please check output file for more details' );

54: If(l_cnt_miss_rate1 > 0 )
55: Then
56: FND_MESSAGE.Set_Name('FII',l_msg_name);
57: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);
58: BIS_COLLECTION_UTILITIES.log('Primary Conversion rate could not be found for the given currency. Please check output file for more details' );
59: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
60: FOR rate_record1 in C_missing_rates1
61: LOOP
62: BIS_COLLECTION_UTILITIES.writeMissingRate(

Line 59: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

55: Then
56: FND_MESSAGE.Set_Name('FII',l_msg_name);
57: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);
58: BIS_COLLECTION_UTILITIES.log('Primary Conversion rate could not be found for the given currency. Please check output file for more details' );
59: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
60: FOR rate_record1 in C_missing_rates1
61: LOOP
62: BIS_COLLECTION_UTILITIES.writeMissingRate(
63: p_rate_type => l_pgc_rate_type,

Line 62: BIS_COLLECTION_UTILITIES.writeMissingRate(

58: BIS_COLLECTION_UTILITIES.log('Primary Conversion rate could not be found for the given currency. Please check output file for more details' );
59: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
60: FOR rate_record1 in C_missing_rates1
61: LOOP
62: BIS_COLLECTION_UTILITIES.writeMissingRate(
63: p_rate_type => l_pgc_rate_type,
64: p_from_currency => rate_record1.from_currency,
65: p_to_currency => l_global_currency_code,
66: p_date => rate_record1.transaction_create_date);

Line 68: BIS_COLLECTION_UTILITIES.debug('before returning -1' );

64: p_from_currency => rate_record1.from_currency,
65: p_to_currency => l_global_currency_code,
66: p_date => rate_record1.transaction_create_date);
67: END LOOP;
68: BIS_COLLECTION_UTILITIES.debug('before returning -1' );
69: RETURN -1;
70: ELSE
71: Return 1;
72: End If;

Line 77: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);

73:
74: If(l_cnt_miss_rate2 > 0 and l_secondary_currency_code is not null )
75: Then
76: FND_MESSAGE.Set_Name('FII',l_msg_name);
77: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);
78: BIS_COLLECTION_UTILITIES.log('Secondary Conversion rate could not be found for the given currency. Please check output file for more details' );
79: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
80: FOR rate_record2 in C_missing_rates2
81: LOOP

Line 78: BIS_COLLECTION_UTILITIES.log('Secondary Conversion rate could not be found for the given currency. Please check output file for more details' );

74: If(l_cnt_miss_rate2 > 0 and l_secondary_currency_code is not null )
75: Then
76: FND_MESSAGE.Set_Name('FII',l_msg_name);
77: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);
78: BIS_COLLECTION_UTILITIES.log('Secondary Conversion rate could not be found for the given currency. Please check output file for more details' );
79: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
80: FOR rate_record2 in C_missing_rates2
81: LOOP
82: BIS_COLLECTION_UTILITIES.writeMissingRate(

Line 79: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

75: Then
76: FND_MESSAGE.Set_Name('FII',l_msg_name);
77: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);
78: BIS_COLLECTION_UTILITIES.log('Secondary Conversion rate could not be found for the given currency. Please check output file for more details' );
79: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
80: FOR rate_record2 in C_missing_rates2
81: LOOP
82: BIS_COLLECTION_UTILITIES.writeMissingRate(
83: p_rate_type => l_sgc_rate_type,

Line 82: BIS_COLLECTION_UTILITIES.writeMissingRate(

78: BIS_COLLECTION_UTILITIES.log('Secondary Conversion rate could not be found for the given currency. Please check output file for more details' );
79: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
80: FOR rate_record2 in C_missing_rates2
81: LOOP
82: BIS_COLLECTION_UTILITIES.writeMissingRate(
83: p_rate_type => l_sgc_rate_type,
84: p_from_currency => rate_record2.from_currency,
85: p_to_currency => l_secondary_currency_code,
86: p_date => rate_record2.transaction_create_date);

Line 88: BIS_COLLECTION_UTILITIES.debug('before returning -1' );

84: p_from_currency => rate_record2.from_currency,
85: p_to_currency => l_secondary_currency_code,
86: p_date => rate_record2.transaction_create_date);
87: END LOOP;
88: BIS_COLLECTION_UTILITIES.debug('before returning -1' );
89: RETURN -1;
90: ELSE
91: Return 1;
92: End If;

Line 96: BIS_COLLECTION_UTILITIES.Debug('Error in Check_missing_rates:'||sqlerrm);

92: End If;
93:
94: EXCEPTION
95: WHEN OTHERS THEN
96: BIS_COLLECTION_UTILITIES.Debug('Error in Check_missing_rates:'||sqlerrm);
97: RAISE;
98: END Check_Missing_Rates;
99:
100: ---------------------------------------------------------------------------------------------------

Line 164: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: Facts load starts at:'||sysdate);

160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161:
162: -- Debug Message
163: -- AMS_UTILITY_PVT.debug_message('Private API: ' || 'Running the populate procedure');
164: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: Facts load starts at:'||sysdate);
165:
166: l_global_start_date :=BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE();
167:
168: /* THIS CODE REPLACES THE GET_LAST_REFRESH_PERIOD TO GET_LAST_REFRESH_DATES */

Line 170: bis_collection_utilities.get_last_refresh_dates('BUDGET_FACTS'

166: l_global_start_date :=BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE();
167:
168: /* THIS CODE REPLACES THE GET_LAST_REFRESH_PERIOD TO GET_LAST_REFRESH_DATES */
169:
170: bis_collection_utilities.get_last_refresh_dates('BUDGET_FACTS'
171: ,l_conc_start_date,l_conc_end_date,l_start_date,l_end_date);
172:
173:
174: IF (l_end_date IS NULL) THEN

Line 177: bis_collection_utilities.log('Please run the Upadate budget Facts First Time Base Summary concurrent program before running this');

173:
174: IF (l_end_date IS NULL) THEN
175:
176: IF (p_start_date IS NULL) THEN
177: bis_collection_utilities.log('Please run the Upadate budget Facts First Time Base Summary concurrent program before running this');
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180:
181: IF (p_start_date >= p_end_date) THEN

Line 182: bis_collection_utilities.log('Start Date Can not be greater than End Date');

178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180:
181: IF (p_start_date >= p_end_date) THEN
182: bis_collection_utilities.log('Start Date Can not be greater than End Date');
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185: --Validate time dimension tables
186: fii_time_api.check_missing_date (greatest(l_global_start_date,p_start_date), sysdate, l_missing_date);

Line 188: bis_collection_utilities.log('Time dimension has at least one missing date between ' || greatest(l_global_start_date,p_start_date) || ' and ' || sysdate);

184: END IF;
185: --Validate time dimension tables
186: fii_time_api.check_missing_date (greatest(l_global_start_date,p_start_date), sysdate, l_missing_date);
187: IF (l_missing_date) THEN
188: bis_collection_utilities.log('Time dimension has at least one missing date between ' || greatest(l_global_start_date,p_start_date) || ' and ' || sysdate);
189: RAISE FND_API.G_EXC_ERROR;
190: END IF;
191:
192: l_load_type := 'FIRST_LOAD';

Line 193: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: First Load');

189: RAISE FND_API.G_EXC_ERROR;
190: END IF;
191:
192: l_load_type := 'FIRST_LOAD';
193: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: First Load');
194:
195: FIRST_LOAD(p_start_date => greatest(l_global_start_date,p_start_date)
196: ,p_end_date => sysdate
197: ,p_api_version_number => l_api_version_number

Line 225: bis_collection_utilities.log('Load Progarm already run upto ' || l_end_date);

221: ELSE
222:
223:
224: IF (l_end_date >= sysdate) THEN
225: bis_collection_utilities.log('Load Progarm already run upto ' || l_end_date);
226: RAISE FND_API.g_exc_error;
227: END IF;
228: --Validate time dimension tables
229: fii_time_api.check_missing_date (l_end_date, sysdate, l_missing_date);

Line 231: bis_collection_utilities.log('Time dimension has atleast one missing date between ' || l_end_date || ' and ' || sysdate);

227: END IF;
228: --Validate time dimension tables
229: fii_time_api.check_missing_date (l_end_date, sysdate, l_missing_date);
230: IF (l_missing_date) THEN
231: bis_collection_utilities.log('Time dimension has atleast one missing date between ' || l_end_date || ' and ' || sysdate);
232: RAISE FND_API.G_EXC_ERROR;
233: END IF;
234:
235: l_load_type := 'SUBSEQUENT_LOAD';

Line 236: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: Incremental Load');

232: RAISE FND_API.G_EXC_ERROR;
233: END IF;
234:
235: l_load_type := 'SUBSEQUENT_LOAD';
236: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: Incremental Load');
237: /*SUB_LOAD(p_start_date => l_end_date+1/86400
238: ,p_end_date => sysdate
239: ,p_api_version_number => l_api_version_number
240: ,p_init_msg_list => FND_API.G_FALSE

Line 271: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: Facts Concurrent Program Succesfully Completed');

267: COMMIT WORK;
268: END IF;
269:
270: COMMIT;
271: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: Facts Concurrent Program Succesfully Completed');
272:
273: -- Standard call to get message count and if count is 1, get message info.
274: FND_MSG_PUB.Count_And_Get
275: (p_count => x_msg_count,

Line 394: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Drop index before inserting.');

390: -- EXECUTE IMMEDIATE 'ALTER SEQUENCE BIM_I_BUDGET_FACTS_s CACHE 1000 ';
391:
392:
393: /* Piece of Code for retrieving,storing storage parameters and Dropping the indexes */
394: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Drop index before inserting.');
395: BIM_UTL_PKG.drop_index('BIM_I_BUDGET_FACTS');
396: /* End of Code for dropping the existing indexes */
397: EXCEPTION when others then
398: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: error:'||sqlerrm(sqlcode));

Line 398: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: error:'||sqlerrm(sqlcode));

394: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Drop index before inserting.');
395: BIM_UTL_PKG.drop_index('BIM_I_BUDGET_FACTS');
396: /* End of Code for dropping the existing indexes */
397: EXCEPTION when others then
398: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: error:'||sqlerrm(sqlcode));
399: --dbms_output.put_line('error first:'||sqlerrm(sqlcode));
400: END;
401: l_table_name :='BIM_I_BUDGET_FACTS';
402: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BUDGET_FACTS_STG';

Line 404: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:First insert into table BIM_I_BUDGET_FACTS_STG');

400: END;
401: l_table_name :='BIM_I_BUDGET_FACTS';
402: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BUDGET_FACTS_STG';
403: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BGT_RATES';
404: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:First insert into table BIM_I_BUDGET_FACTS_STG');
405: -- dbms_output.put_Line('JUST BEFORE THE MAIN INSERT STATMENT');
406: INSERT /*+ append parallel */
407: INTO BIM_I_BUDGET_FACTS_STG CDF(
408: creation_date

Line 1398: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Inserting into BIM_I_BGT_RATES');

1394: metric_type,
1395: conversion_rate_s
1396: )inner;
1397: commit;
1398: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Inserting into BIM_I_BGT_RATES');
1399: --insert into bim_i_mkt_rates
1400: INSERT /*+ append parallel */
1401: INTO BIM_I_BGT_RATES BRT(tc_code,
1402: trx_date,

Line 1415: BIS_COLLECTION_UTILITIES.debug('before truncating first time load' );

1411: from bim_i_budget_facts_stg);
1412: commit;
1413: l_check_missing_rate := Check_Missing_Rates (p_start_date);
1414: if (l_check_missing_rate = -1) then
1415: BIS_COLLECTION_UTILITIES.debug('before truncating first time load' );
1416: l_stmt := 'TRUNCATE table '||l_schema||'.BIM_I_BUDGET_FACTS_stg';
1417: EXECUTE IMMEDIATE l_stmt;
1418: commit;
1419: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1423: --BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Inserted '||SQL%COUNT);

1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: end if;
1422:
1423: --BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Inserted '||SQL%COUNT);
1424: EXECUTE IMMEDIATE 'COMMIT';
1425: -- EXECUTE IMMEDIATE 'ALTER SEQUENCE BIM_I_BUDGET_FACTS_s CACHE 20';
1426:
1427: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.BIM_I_BUDGET_FACTS';

Line 1428: BIS_COLLECTION_UTILITIES.deleteLogForObject('BUDGET_FACTS');

1424: EXECUTE IMMEDIATE 'COMMIT';
1425: -- EXECUTE IMMEDIATE 'ALTER SEQUENCE BIM_I_BUDGET_FACTS_s CACHE 20';
1426:
1427: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.BIM_I_BUDGET_FACTS';
1428: BIS_COLLECTION_UTILITIES.deleteLogForObject('BUDGET_FACTS');
1429:
1430: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Insert into BIM_I_BUDGET_FACTS');
1431: INSERT /*+ append parallel */
1432: INTO BIM_I_BUDGET_FACTS CDF(

Line 1430: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Insert into BIM_I_BUDGET_FACTS');

1426:
1427: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.BIM_I_BUDGET_FACTS';
1428: BIS_COLLECTION_UTILITIES.deleteLogForObject('BUDGET_FACTS');
1429:
1430: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Insert into BIM_I_BUDGET_FACTS');
1431: INSERT /*+ append parallel */
1432: INTO BIM_I_BUDGET_FACTS CDF(
1433: creation_date
1434: ,last_update_date

Line 1534: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: Wrapup');

1530: DBMS_STATS.gather_table_stats('BIM','BIM_I_BUDGET_FACTS', estimate_percent => 5,
1531: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
1532:
1533: -- Make entry in the history table
1534: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: Wrapup');
1535: BEGIN
1536: IF (Not BIS_COLLECTION_UTILITIES.setup('BUDGET_FACTS')) THEN
1537: RAISE FND_API.G_EXC_ERROR;
1538: return;

Line 1536: IF (Not BIS_COLLECTION_UTILITIES.setup('BUDGET_FACTS')) THEN

1532:
1533: -- Make entry in the history table
1534: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: Wrapup');
1535: BEGIN
1536: IF (Not BIS_COLLECTION_UTILITIES.setup('BUDGET_FACTS')) THEN
1537: RAISE FND_API.G_EXC_ERROR;
1538: return;
1539: END IF;
1540:

Line 1541: BIS_COLLECTION_UTILITIES.WRAPUP(

1537: RAISE FND_API.G_EXC_ERROR;
1538: return;
1539: END IF;
1540:
1541: BIS_COLLECTION_UTILITIES.WRAPUP(
1542: p_status =>TRUE ,
1543: p_period_from =>p_start_date,
1544: p_period_to => sysdate
1545: );

Line 1548: BIS_COLLECTION_UTILITIES.WRAPUP(

1544: p_period_to => sysdate
1545: );
1546: Exception when others then
1547: Rollback;
1548: BIS_COLLECTION_UTILITIES.WRAPUP(
1549: p_status => FALSE,
1550: p_period_from =>p_start_date,
1551: p_period_to =>sysdate
1552: );

Line 1556: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Before create index');

1552: );
1553: RAISE FND_API.G_EXC_ERROR;
1554: END;
1555:
1556: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Before create index');
1557:
1558: BIM_UTL_PKG.CREATE_INDEX('BIM_I_BUDGET_FACTS');
1559: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1560: --ams_utility_pvt.write_conc_log('BIM_I_BUDGET_FACTS:FIRST_LOAD: AFTER CREATE INDEX ' || l_temp_msg);

Line 1561: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:After create index');

1557:
1558: BIM_UTL_PKG.CREATE_INDEX('BIM_I_BUDGET_FACTS');
1559: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1560: --ams_utility_pvt.write_conc_log('BIM_I_BUDGET_FACTS:FIRST_LOAD: AFTER CREATE INDEX ' || l_temp_msg);
1561: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:After create index');
1562: /*fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
1563: fnd_message.set_token('program_name', 'Budget first load', FALSE);
1564: fnd_file.put_line(fnd_file.log,fnd_message.get);*/
1565: EXCEPTION

Line 1584: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Unexpected'||sqlerrm(sqlcode));

1580: --p_encoded => FND_API.G_FALSE,
1581: p_count => x_msg_count,
1582: p_data => x_msg_data
1583: );
1584: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Unexpected'||sqlerrm(sqlcode));
1585:
1586: WHEN OTHERS THEN
1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1588: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)

Line 1599: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:IN OTHERS EXCEPTION'||sqlerrm(sqlcode));

1595: -- p_encoded => FND_API.G_FALSE,
1596: p_count => x_msg_count,
1597: p_data => x_msg_data
1598: );
1599: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:IN OTHERS EXCEPTION'||sqlerrm(sqlcode));
1600: --end;
1601: END FIRST_LOAD;
1602: --------------------------------------------------------------------------------------------------
1603: -- This procedure will execute when data is loaded for subsequent time.

Line 1682: BIS_COLLECTION_UTILITIES.log('BIM_I_budget_facts: Error in deleting data:'|| sqlerrm(sqlcode));

1678: DELETE from bim_i_budget_facts where transaction_create_date>= p_start_date and metric_type is not null;
1679: COMMIT;
1680: EXCEPTION
1681: when others then
1682: BIS_COLLECTION_UTILITIES.log('BIM_I_budget_facts: Error in deleting data:'|| sqlerrm(sqlcode));
1683: --dbms_output.put_line('error inserting:'||sqlerrm(sqlcode));
1684: END;
1685: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BUDGET_FACTS_STG';
1686: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BGT_RATES';

Line 1688: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Incremental load start');

1684: END;
1685: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BUDGET_FACTS_STG';
1686: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_BGT_RATES';
1687: --dbms_output.put_line('right b4 inserting');
1688: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Incremental load start');
1689: INSERT INTO BIM_I_BUDGET_FACTS_STG CDF(
1690: creation_date
1691: ,last_update_date
1692: ,created_by

Line 2674: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Inserting into BIM_I_BGT_RATES');

2670: metric_type,
2671: conversion_rate_s
2672: )inner;
2673:
2674: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Inserting into BIM_I_BGT_RATES');
2675: --insert into bim_i_mkt_rates
2676: INSERT
2677: INTO BIM_I_BGT_RATES BRT(tc_code,
2678: trx_date,

Line 2696: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Incremental Load:after calling checking_missing_rates');

2692: commit;
2693: x_return_status := FND_API.G_RET_STS_ERROR;
2694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2695: end if;
2696: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Incremental Load:after calling checking_missing_rates');
2697:
2698: --insert into facts table
2699: INSERT /*+ append parallel */
2700: INTO BIM_I_BUDGET_FACTS CDF(

Line 2801: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Before Insert into log.');

2797: DBMS_STATS.gather_table_stats('BIM','BIM_I_BUDGET_FACTS', estimate_percent => 5,
2798: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2799:
2800: --dbms_output.put_line('b4 inserting log');
2801: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Before Insert into log.');
2802: BEGIN
2803: IF (Not BIS_COLLECTION_UTILITIES.setup('BUDGET_FACTS')) THEN
2804: RAISE FND_API.G_EXC_ERROR;
2805: return;

Line 2803: IF (Not BIS_COLLECTION_UTILITIES.setup('BUDGET_FACTS')) THEN

2799:
2800: --dbms_output.put_line('b4 inserting log');
2801: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Before Insert into log.');
2802: BEGIN
2803: IF (Not BIS_COLLECTION_UTILITIES.setup('BUDGET_FACTS')) THEN
2804: RAISE FND_API.G_EXC_ERROR;
2805: return;
2806: END IF;
2807: BIS_COLLECTION_UTILITIES.WRAPUP(

Line 2807: BIS_COLLECTION_UTILITIES.WRAPUP(

2803: IF (Not BIS_COLLECTION_UTILITIES.setup('BUDGET_FACTS')) THEN
2804: RAISE FND_API.G_EXC_ERROR;
2805: return;
2806: END IF;
2807: BIS_COLLECTION_UTILITIES.WRAPUP(
2808: p_status => TRUE ,
2809: p_period_from =>p_start_date,
2810: p_period_to => sysdate
2811: );

Line 2814: BIS_COLLECTION_UTILITIES.WRAPUP(

2810: p_period_to => sysdate
2811: );
2812: Exception when others then
2813: Rollback;
2814: BIS_COLLECTION_UTILITIES.WRAPUP(
2815: p_status => FALSE,
2816: p_period_from =>p_start_date,
2817: p_period_to =>sysdate
2818: );

Line 2821: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:After Insert into log.');

2817: p_period_to =>sysdate
2818: );
2819: RAISE FND_API.G_EXC_ERROR;
2820: END;
2821: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:After Insert into log.');
2822: EXCEPTION
2823: WHEN FND_API.G_EXC_ERROR THEN
2824: x_return_status := FND_API.G_RET_STS_ERROR;
2825: -- Standard call to get message count and if count=1, get the message

Line 2832: BIS_COLLECTION_UTILITIES.log('SUBSEQUENT_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));

2828: p_count => x_msg_count,
2829: p_data => x_msg_data
2830: );
2831:
2832: BIS_COLLECTION_UTILITIES.log('SUBSEQUENT_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
2833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2834:
2835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2836:

Line 2845: BIS_COLLECTION_UTILITIES.log('SUBSEQUENT_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));

2841: p_data => x_msg_data
2842: );
2843:
2844: ams_utility_pvt.write_conc_log('BIM_I_BUDGET_FACTS:SUBSEQUENT_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
2845: BIS_COLLECTION_UTILITIES.log('SUBSEQUENT_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
2846: WHEN OTHERS THEN
2847:
2848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2849:

Line 2861: BIS_COLLECTION_UTILITIES.log('SUBSEQUENT_LOAD:IN other EXCEPTION '||sqlerrm(sqlcode));

2857: -- p_encoded => FND_API.G_FALSE,
2858: p_count => x_msg_count,
2859: p_data => x_msg_data
2860: );
2861: BIS_COLLECTION_UTILITIES.log('SUBSEQUENT_LOAD:IN other EXCEPTION '||sqlerrm(sqlcode));
2862: END SUB_LOAD;
2863: END BIM_I_BGT_FACTS_PKG;