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

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

48: l_attribute_count NUMBER;
49:
50: BEGIN
51:
52: IF NOT bis_collection_utilities.setup(l_object_name) THEN
53: bis_collection_utilities.log('Object BIM_SGMT_SIZE Not Setup Properly');
54: RAISE FND_API.G_EXC_ERROR;
55: END IF;
56:

Line 53: bis_collection_utilities.log('Object BIM_SGMT_SIZE Not Setup Properly');

49:
50: BEGIN
51:
52: IF NOT bis_collection_utilities.setup(l_object_name) THEN
53: bis_collection_utilities.log('Object BIM_SGMT_SIZE Not Setup Properly');
54: RAISE FND_API.G_EXC_ERROR;
55: END IF;
56:
57: bis_collection_utilities.log('Start of the Segment Base Summary Program');

Line 57: bis_collection_utilities.log('Start of the Segment Base Summary Program');

53: bis_collection_utilities.log('Object BIM_SGMT_SIZE Not Setup Properly');
54: RAISE FND_API.G_EXC_ERROR;
55: END IF;
56:
57: bis_collection_utilities.log('Start of the Segment Base Summary Program');
58:
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
61: p_api_version_number,

Line 83: bis_collection_utilities.get_last_refresh_dates(l_object_name,

79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80:
81: --Get last Refresh dates of the program
82:
83: bis_collection_utilities.get_last_refresh_dates(l_object_name,
84: l_conc_start_date,
85: l_conc_end_date,
86: l_start_date,
87: l_end_date);

Line 89: bis_collection_utilities.get_last_user_attributes(l_object_name,

85: l_conc_end_date,
86: l_start_date,
87: l_end_date);
88:
89: bis_collection_utilities.get_last_user_attributes(l_object_name,
90: l_attribute_table,
91: l_attribute_count);
92:
93: IF l_attribute_count > 0 THEN

Line 109: bis_collection_utilities.log('Please run the Update Segment First Time Base Summary Concurrent Program before running this');

105: --before executing make sure the user called the correct program i.e inital load
106:
107: IF (p_start_date IS NULL) THEN
108: --i.e the user initiated incremental program request. raise exception and exit
109: bis_collection_utilities.log('Please run the Update Segment First Time Base Summary Concurrent Program before running this');
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;
112:
113: --- Validate Time Dimension Tables

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

113: --- Validate Time Dimension Tables
114: fii_time_api.check_missing_date (GREATEST(l_global_date,p_start_date), SYSDATE, l_missing_date);
115:
116: IF (l_missing_date) THEN
117: bis_collection_utilities.log('Time Dimension has atleast one missing date between ' || greatest(l_global_date,p_start_date) || ' and ' || sysdate);
118: RAISE FND_API.G_EXC_ERROR;
119: END IF;
120:
121:

Line 162: bis_collection_utilities.log('Time Dimension Not Defined Till '||l_end_date );

158: WHERE report_date = trunc(l_end_date);
159:
160: IF l_year_start_date IS NULL THEN
161:
162: bis_collection_utilities.log('Time Dimension Not Defined Till '||l_end_date );
163: RAISE FND_API.G_EXC_ERROR;
164:
165: END IF;
166:

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

168:
169: IF (l_missing_date) THEN
170:
171: --Check it from the year start Date of the Year Passed as used in Active Customer Count
172: bis_collection_utilities.log('Time Dimension has atleast one missing date between ' || l_end_date || ' and ' || sysdate);
173: RAISE FND_API.G_EXC_ERROR;
174:
175: END IF;
176:

Line 213: bis_collection_utilities.log('Successful Completion of Segment Base Summary Program');

209:
210: END IF;
211:
212:
213: bis_collection_utilities.log('Successful Completion of Segment Base Summary Program');
214:
215: -- Standard call to get message count and if count is 1, get message info.
216: FND_MSG_PUB.Count_And_Get
217: (p_count => x_msg_count,

Line 371: -- bis_collection_utilities.log('running the function --- '||l_source||l_master_type_id||l_master_type);

367:
368:
369: l_source := l_master_type;
370: END IF;
371: -- bis_collection_utilities.log('running the function --- '||l_source||l_master_type_id||l_master_type);
372: Execute Immediate 'INSERT INTO source_query_sgfb(sql_id, source_name) VALUES('||l_sql_id||', '''||l_source||''')';
373: l_source := NULL;
374: l_query_string := NULL;
375: l_sql_id := NULL;

Line 399: bis_collection_utilities.log('Running Initial Load of Segment Facts');

395:
396: -- Initialize API return status to SUCCESS
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398:
399: bis_collection_utilities.log('Running Initial Load of Segment Facts');
400: ---populating Segment Size
401: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
402:
403: bis_collection_utilities.log('Truncating Facts Table');

Line 403: bis_collection_utilities.log('Truncating Facts Table');

399: bis_collection_utilities.log('Running Initial Load of Segment Facts');
400: ---populating Segment Size
401: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
402:
403: bis_collection_utilities.log('Truncating Facts Table');
404:
405: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_sgmt_facts';
406:
407: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SGMT_SIZE');

Line 407: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SGMT_SIZE');

403: bis_collection_utilities.log('Truncating Facts Table');
404:
405: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_sgmt_facts';
406:
407: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SGMT_SIZE');
408:
409: bis_collection_utilities.log('Inserting Segment Size');
410:
411: Execute Immediate ' INSERT /*+ append parallel */ INTO bim_i_sgmt_facts ' ||

Line 409: bis_collection_utilities.log('Inserting Segment Size');

405: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_sgmt_facts';
406:
407: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SGMT_SIZE');
408:
409: bis_collection_utilities.log('Inserting Segment Size');
410:
411: Execute Immediate ' INSERT /*+ append parallel */ INTO bim_i_sgmt_facts ' ||
412: ' (creation_date ' ||
413: ' ,last_update_date ' ||

Line 470: bis_collection_utilities.log('Inserting Active Customer Count');

466:
467:
468: COMMIT;
469:
470: bis_collection_utilities.log('Inserting Active Customer Count');
471:
472: Execute Immediate ' INSERT INTO bim_i_sgmt_facts ' ||
473: ' (creation_date ' ||
474: ' ,last_update_date ' ||

Line 614: bis_collection_utilities.wrapup(p_status => TRUE

610: Execute Immediate 'DROP TABLE source_query_sgfb';
611:
612: COMMIT;
613:
614: bis_collection_utilities.wrapup(p_status => TRUE
615: ,p_count => sql%rowcount
616: ,p_period_from => p_start_date
617: ,p_period_to => p_end_date
618: ,p_attribute1 => 'INITIAL_LOAD_START_DATE'

Line 634: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));

630: p_count => x_msg_count,
631: p_data => x_msg_data
632: );
633:
634: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
635:
636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
637:
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 648: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:FIRST_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));

644: p_count => x_msg_count,
645: p_data => x_msg_data
646: );
647:
648: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:FIRST_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
649:
650: WHEN OTHERS THEN
651:
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 668: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:FIRST_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));

664: p_count => x_msg_count,
665: p_data => x_msg_data
666: );
667:
668: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:FIRST_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
669:
670:
671: END first_load;
672:

Line 785: -- bis_collection_utilities.log('running the function --- '||l_source||l_master_type_id||l_master_type);

781:
782:
783: l_source := l_master_type;
784: END IF;
785: -- bis_collection_utilities.log('running the function --- '||l_source||l_master_type_id||l_master_type);
786: Execute Immediate 'INSERT INTO source_query_sgfb(sql_id, source_name) VALUES('||l_sql_id||', '''||l_source||''')';
787: l_source := NULL;
788: l_query_string := NULL;
789: l_sql_id := NULL;

Line 812: bis_collection_utilities.log('Running Incremental Load of Segment Facts');

808:
809: -- Initialize API return status to SUCCESS
810: x_return_status := FND_API.G_RET_STS_SUCCESS;
811:
812: bis_collection_utilities.log('Running Incremental Load of Segment Facts');
813:
814:
815: bis_collection_utilities.log('Inserting Segment Size');
816:

Line 815: bis_collection_utilities.log('Inserting Segment Size');

811:
812: bis_collection_utilities.log('Running Incremental Load of Segment Facts');
813:
814:
815: bis_collection_utilities.log('Inserting Segment Size');
816:
817: DELETE FROM bim_i_sgmt_facts
818: WHERE metric_type = 'CUST'
819: AND transaction_create_date = TRUNC(p_start_date);

Line 1007: bis_collection_utilities.wrapup(p_status => TRUE

1003: Execute Immediate 'DROP TABLE source_query_sgfb';
1004:
1005: COMMIT;
1006:
1007: bis_collection_utilities.wrapup(p_status => TRUE
1008: ,p_count => sql%rowcount
1009: ,p_period_from => p_start_date
1010: ,p_period_to => p_end_date
1011: ,p_attribute1 => 'INITIAL_LOAD_START_DATE'

Line 1030: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));

1026: p_count => x_msg_count,
1027: p_data => x_msg_data
1028: );
1029:
1030: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
1031:
1032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1033:
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1044: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:INCREMENTAL_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));

1040: p_count => x_msg_count,
1041: p_data => x_msg_data
1042: );
1043:
1044: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:INCREMENTAL_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
1045:
1046: WHEN OTHERS THEN
1047:
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1063: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:INCREMENTAL_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));

1059: p_count => x_msg_count,
1060: p_data => x_msg_data
1061: );
1062:
1063: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:INCREMENTAL_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
1064:
1065:
1066: END incremental_load;
1067: