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_LEAD_FACTS_PKG dependencies on BIS_COLLECTION_UTILITIES

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

38:
39: If(l_cnt_miss_rate > 0 )
40: Then
41: FND_MESSAGE.Set_Name('FII',l_msg_name);
42: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);
43: BIS_COLLECTION_UTILITIES.log('Conversion rate could not be found for the given currency. Please check output file for more details' );
44: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
45:
46:

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

39: If(l_cnt_miss_rate > 0 )
40: Then
41: FND_MESSAGE.Set_Name('FII',l_msg_name);
42: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);
43: BIS_COLLECTION_UTILITIES.log('Conversion rate could not be found for the given currency. Please check output file for more details' );
44: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
45:
46:
47: l_global_currency_code := bis_common_parameters.get_currency_code;

Line 44: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

40: Then
41: FND_MESSAGE.Set_Name('FII',l_msg_name);
42: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);
43: BIS_COLLECTION_UTILITIES.log('Conversion rate could not be found for the given currency. Please check output file for more details' );
44: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
45:
46:
47: l_global_currency_code := bis_common_parameters.get_currency_code;
48: FOR rate_record in C_missing_rates

Line 50: BIS_COLLECTION_UTILITIES.writeMissingRate(

46:
47: l_global_currency_code := bis_common_parameters.get_currency_code;
48: FOR rate_record in C_missing_rates
49: LOOP
50: BIS_COLLECTION_UTILITIES.writeMissingRate(
51: p_rate_type => l_global_rate,
52: p_from_currency => rate_record.from_currency,
53: p_to_currency => l_global_currency_code,
54: p_date => rate_record.lead_creation_date);

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

52: p_from_currency => rate_record.from_currency,
53: p_to_currency => l_global_currency_code,
54: p_date => rate_record.lead_creation_date);
55: END LOOP;
56: BIS_COLLECTION_UTILITIES.debug('before returning -1' );
57: RETURN -1;
58: ELSE
59: Return 1;
60: End If;

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

60: End If;
61:
62: EXCEPTION
63: WHEN OTHERS THEN
64: BIS_COLLECTION_UTILITIES.Debug('Error in Check_missing_rates:'||sqlerrm);
65: RAISE;
66: END Check_Missing_Rates;
67:
68: ------------------------------------------------------------------------------------------------

Line 110: IF NOT bis_collection_utilities.setup(l_object_name) THEN

106: BEGIN
107:
108: l_global_date:= bis_common_parameters.get_global_start_date;
109:
110: IF NOT bis_collection_utilities.setup(l_object_name) THEN
111: bis_collection_utilities.log('Object BIM_LEADS Not Setup Properly');
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114: bis_collection_utilities.log('Start of the Lead Facts Program');

Line 111: bis_collection_utilities.log('Object BIM_LEADS Not Setup Properly');

107:
108: l_global_date:= bis_common_parameters.get_global_start_date;
109:
110: IF NOT bis_collection_utilities.setup(l_object_name) THEN
111: bis_collection_utilities.log('Object BIM_LEADS Not Setup Properly');
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114: bis_collection_utilities.log('Start of the Lead Facts Program');
115:

Line 114: bis_collection_utilities.log('Start of the Lead Facts Program');

110: IF NOT bis_collection_utilities.setup(l_object_name) THEN
111: bis_collection_utilities.log('Object BIM_LEADS Not Setup Properly');
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114: bis_collection_utilities.log('Start of the Lead Facts Program');
115:
116: -- Standard call to check for call compatibility.
117: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
118: p_api_version_number,

Line 134: bis_collection_utilities.get_last_refresh_dates(l_object_name,

130:
131: -- Initialize API return status to SUCCESS
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133:
134: bis_collection_utilities.get_last_refresh_dates(l_object_name,
135: l_conc_start_date,
136: l_conc_end_date,
137: l_start_date,
138: l_end_date);

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

138: l_end_date);
139: IF (l_end_date IS NULL) THEN
140:
141: IF (p_start_date IS NULL) THEN
142: bis_collection_utilities.log('Please run the Upadate Leads First Time Base Summary concurrent program before running this');
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;
145:
146: --- Validate Time Dimension Tables

Line 149: bis_collection_utilities.log('Time dimension has atleast one missing date between ' || greatest(l_global_date,p_start_date) || ' and ' || sysdate);

145:
146: --- Validate Time Dimension Tables
147: fii_time_api.check_missing_date (greatest(l_global_date,p_start_date), sysdate, l_missing_date);
148: IF (l_missing_date) THEN
149: bis_collection_utilities.log('Time dimension has atleast one missing date between ' || greatest(l_global_date,p_start_date) || ' and ' || sysdate);
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:
153:

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

180: ELSE
181: --- Validate Time Dimension Tables
182: fii_time_api.check_missing_date (l_end_date, sysdate, l_missing_date);
183: IF (l_missing_date) THEN
184: bis_collection_utilities.log('Time dimension has atleast one missing date between ' || l_end_date || ' and ' || sysdate);
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
188: l_load_type := 'SUBSEQUENT_LOAD';

Line 353: bis_collection_utilities.log('Running Initial Load of Lead Facts');

349: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_lead_facts_stg';
350:
351:
352: l_table_name := 'BIM_I_LEAD_FACTS';
353: bis_collection_utilities.log('Running Initial Load of Lead Facts');
354:
355: l_sysdate :=sysdate;
356:
357: INSERT /*+ append parallel */

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

446: COMMIT;
447:
448: /*l_check_missing_rate := Check_Missing_Rates (p_start_date);
449: if (l_check_missing_rate = -1) then
450: BIS_COLLECTION_UTILITIES.debug('before truncating first time load' );
451: l_stmt := 'TRUNCATE table '||l_schema||'.bim_i_lead_facts_stg';
452: EXECUTE IMMEDIATE l_stmt;
453: commit;
454:

Line 550: BIS_COLLECTION_UTILITIES.log('Truncating Facts Table');

546: );
547:
548: END IF;
549:
550: BIS_COLLECTION_UTILITIES.log('Truncating Facts Table');
551:
552: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_lead_facts';
553:
554: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_LEADS');

Line 554: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_LEADS');

550: BIS_COLLECTION_UTILITIES.log('Truncating Facts Table');
551:
552: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_lead_facts';
553:
554: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_LEADS');
555:
556: INSERT /*+ append parallel */
557: INTO bim_i_lead_facts LDF
558: (

Line 760: bis_collection_utilities.wrapup(p_status => TRUE

756: --dbms_output.put_line(p_start_date);
757:
758: --dbms_output.put_line(p_start_date);
759: --dbms_output.put_line(p_end_date);
760: bis_collection_utilities.wrapup(p_status => TRUE
761: ,p_count => sql%rowcount
762: ,p_period_from => p_start_date
763: ,p_period_to => l_sysdate
764: );

Line 769: bis_collection_utilities.log('Before Analyze of the table BIM_I_LEAD_FACTS');

765:
766: /***************************************************************/
767:
768:
769: bis_collection_utilities.log('Before Analyze of the table BIM_I_LEAD_FACTS');
770:
771: --Analyze the facts table
772: DBMS_STATS.gather_table_stats('BIM','BIM_I_LEAD_FACTS', estimate_percent => 5,
773: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 778: bis_collection_utilities.log('Successful Completion of Leads Facts Program');

774:
775: /* Recreating Indexes */
776: BIM_UTL_PKG.CREATE_INDEX('BIM_I_LEAD_FACTS');
777:
778: bis_collection_utilities.log('Successful Completion of Leads Facts Program');
779:
780:
781: EXCEPTION
782:

Line 903: bis_collection_utilities.log('Running Incremental Load of Lead Facts');

899: l_cert_level := nvl(FND_PROFILE.Value('HZ_DISPLAY_CERT_STATUS'),'NO');
900:
901:
902: l_table_name := 'BIM_I_LEAD_FACTS';
903: bis_collection_utilities.log('Running Incremental Load of Lead Facts');
904:
905: /* Truncate Staging table */
906: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_lead_facts_stg';
907:

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

1067: COMMIT;
1068:
1069: /*l_check_missing_rate := Check_Missing_Rates (p_start_date);
1070: if (l_check_missing_rate = -1) then
1071: BIS_COLLECTION_UTILITIES.debug('before truncating first time load' );
1072: l_stmt := 'TRUNCATE table '||l_schema||'.bim_i_lead_facts_stg';
1073: EXECUTE IMMEDIATE l_stmt;
1074: commit;
1075: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1482: bis_collection_utilities.wrapup(p_status => TRUE

1478:
1479:
1480: --dbms_output.put_line(p_start_date);
1481: --dbms_output.put_line(p_end_date);
1482: bis_collection_utilities.wrapup(p_status => TRUE
1483: ,p_count => sql%rowcount
1484: ,p_period_from => p_start_date
1485: ,p_period_to => l_sysdate
1486: );

Line 1491: bis_collection_utilities.log('Before Analyze of the table BIM_I_LEAD_FACTS');

1487:
1488: /***************************************************************/
1489:
1490:
1491: bis_collection_utilities.log('Before Analyze of the table BIM_I_LEAD_FACTS');
1492:
1493: --Analyze the facts table
1494: DBMS_STATS.gather_table_stats('BIM','BIM_I_LEAD_FACTS', estimate_percent => 5,
1495: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 1498: bis_collection_utilities.log('Successful Completion of Leads Facts Program');

1494: DBMS_STATS.gather_table_stats('BIM','BIM_I_LEAD_FACTS', estimate_percent => 5,
1495: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
1496:
1497:
1498: bis_collection_utilities.log('Successful Completion of Leads Facts Program');
1499:
1500:
1501: EXCEPTION
1502: