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

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

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

Line 54: bis_collection_utilities.log('Object BIM_SGMT_ACT Not Setup Properly');

50:
51:
52:
53: IF NOT bis_collection_utilities.setup(l_object_name) THEN
54: bis_collection_utilities.log('Object BIM_SGMT_ACT Not Setup Properly');
55: RAISE FND_API.G_EXC_ERROR;
56: END IF;
57:
58: bis_collection_utilities.log('Start of the Segment Activity Facts Program');

Line 58: bis_collection_utilities.log('Start of the Segment Activity Facts Program');

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

Line 84: bis_collection_utilities.get_last_refresh_dates(l_object_name,

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

Line 90: bis_collection_utilities.get_last_user_attributes(l_object_name,

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

Line 110: bis_collection_utilities.log('Please run the Update Segment Activity Base Summary - Initial Load Concurrent Program before running this');

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

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

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

Line 126: bis_collection_utilities.log('Before calling FIRST_LOAD');

122: l_load_type := 'FIRST_LOAD';
123:
124:
125: l_sysdate := sysdate;
126: bis_collection_utilities.log('Before calling FIRST_LOAD');
127:
128: FIRST_LOAD(p_start_date => greatest(l_global_date,p_start_date)
129: ,p_end_date => l_sysdate
130: ,p_api_version_number => l_api_version_number

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

159:
160: IF (l_missing_date) THEN
161:
162: --Check it from the year start Date of the Year Passed as used in Active Customer Count
163: bis_collection_utilities.log('Time Dimension has atleast one missing date between ' || l_end_date || ' and ' || sysdate);
164: RAISE FND_API.G_EXC_ERROR;
165:
166: END IF;
167:

Line 204: bis_collection_utilities.log('Successful Completion of Segment Activity Facts Program');

200: COMMIT WORK;
201:
202: END IF;
203:
204: bis_collection_utilities.log('Successful Completion of Segment Activity Facts Program');
205:
206: -- Standard call to get message count and if count is 1, get message info.
207: FND_MSG_PUB.Count_And_Get
208: (p_count => x_msg_count,

Line 358: bis_collection_utilities.log('source_object_name --- '||l_source_object_name);

354:
355:
356: l_source := l_master_type;
357: END IF;
358: bis_collection_utilities.log('source_object_name --- '||l_source_object_name);
359: bis_collection_utilities.log('master_type_id --- '||l_master_type_id);
360: bis_collection_utilities.log('master_type --- '||l_master_type);
361: Execute Immediate 'INSERT INTO source_query_safb(sql_id, source_name) VALUES('||l_sql_id||', '''||l_source||''')';
362: l_source := NULL;

Line 359: bis_collection_utilities.log('master_type_id --- '||l_master_type_id);

355:
356: l_source := l_master_type;
357: END IF;
358: bis_collection_utilities.log('source_object_name --- '||l_source_object_name);
359: bis_collection_utilities.log('master_type_id --- '||l_master_type_id);
360: bis_collection_utilities.log('master_type --- '||l_master_type);
361: Execute Immediate 'INSERT INTO source_query_safb(sql_id, source_name) VALUES('||l_sql_id||', '''||l_source||''')';
362: l_source := NULL;
363: l_query_string := NULL;

Line 360: bis_collection_utilities.log('master_type --- '||l_master_type);

356: l_source := l_master_type;
357: END IF;
358: bis_collection_utilities.log('source_object_name --- '||l_source_object_name);
359: bis_collection_utilities.log('master_type_id --- '||l_master_type_id);
360: bis_collection_utilities.log('master_type --- '||l_master_type);
361: Execute Immediate 'INSERT INTO source_query_safb(sql_id, source_name) VALUES('||l_sql_id||', '''||l_source||''')';
362: l_source := NULL;
363: l_query_string := NULL;
364: l_sql_id := NULL;

Line 368: bis_collection_utilities.log('Populated source_name column in source_query_safb table');

364: l_sql_id := NULL;
365: END LOOP;
366: CLOSE c_query_source;
367:
368: bis_collection_utilities.log('Populated source_name column in source_query_safb table');
369:
370:
371: -- Standard call to check for call compatibility.
372: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

386:
387: -- Initialize API return status to SUCCESS
388: x_return_status := FND_API.G_RET_STS_SUCCESS;
389:
390: bis_collection_utilities.log('Running Initial Load of Segment Activity Facts');
391:
392: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
393:
394: bis_collection_utilities.log('Truncating Facts Table');

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

390: bis_collection_utilities.log('Running Initial Load of Segment Activity Facts');
391:
392: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
393:
394: bis_collection_utilities.log('Truncating Facts Table');
395:
396: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_sgmt_act_facts';
397:
398: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SGMT_ACT');

Line 398: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SGMT_ACT');

394: bis_collection_utilities.log('Truncating Facts Table');
395:
396: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_sgmt_act_facts';
397:
398: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SGMT_ACT');
399:
400: ---populating Segment Size
401: bis_collection_utilities.log('Inserting Segment Activity Details');
402:

Line 401: bis_collection_utilities.log('Inserting Segment Activity Details');

397:
398: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SGMT_ACT');
399:
400: ---populating Segment Size
401: bis_collection_utilities.log('Inserting Segment Activity Details');
402:
403: Execute Immediate 'INSERT /*+ append parallel*/ ' ||
404: ' INTO bim_i_sgmt_act_facts ' ||
405: ' (creation_date ' ||

Line 462: bis_collection_utilities.log('table source_query_safb dropped');

458: ' AND b.status_code IN (''COMPLETED'', ''CANCELLED'', ''CLOSED'', ''ACTIVE'', ''ON_HOLD'') ' ||
459: ' AND trunc(a.creation_date) BETWEEN '''|| p_start_date ||''' AND '''||p_end_date||'''' ;
460:
461: Execute immediate 'DROP TABLE source_query_safb';
462: bis_collection_utilities.log('table source_query_safb dropped');
463:
464: COMMIT;
465:
466:

Line 467: bis_collection_utilities.wrapup(p_status => TRUE

463:
464: COMMIT;
465:
466:
467: bis_collection_utilities.wrapup(p_status => TRUE
468: ,p_count => sql%rowcount
469: ,p_period_from => p_start_date
470: ,p_period_to => p_end_date
471: ,p_attribute1 => 'INITIAL_LOAD_START_DATE'

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

487: p_count => x_msg_count,
488: p_data => x_msg_data
489: );
490:
491: bis_collection_utilities.log('BIM_I_SGMT_ACT_FACTS_PKG : FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
492:
493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
494:
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

501: p_count => x_msg_count,
502: p_data => x_msg_data
503: );
504:
505: bis_collection_utilities.log('BIM_I_SGMT_ACT_FACTS_PKG : FIRST_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
506:
507: WHEN OTHERS THEN
508:
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

520: p_count => x_msg_count,
521: p_data => x_msg_data
522: );
523:
524: bis_collection_utilities.log('BIM_I_SGMT_ACT_FACTS_PKG : FIRST_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
525:
526:
527:
528: END first_load;

Line 640: bis_collection_utilities.log('source_object_name --- '||l_source_object_name);

636:
637:
638: l_source := l_master_type;
639: END IF;
640: bis_collection_utilities.log('source_object_name --- '||l_source_object_name);
641: bis_collection_utilities.log('master_type_id --- '||l_master_type_id);
642: bis_collection_utilities.log('master_type --- '||l_master_type);
643: Execute Immediate 'INSERT INTO source_query_safb(sql_id, source_name) VALUES('||l_sql_id||', '''||l_source||''')';
644: l_source := NULL;

Line 641: bis_collection_utilities.log('master_type_id --- '||l_master_type_id);

637:
638: l_source := l_master_type;
639: END IF;
640: bis_collection_utilities.log('source_object_name --- '||l_source_object_name);
641: bis_collection_utilities.log('master_type_id --- '||l_master_type_id);
642: bis_collection_utilities.log('master_type --- '||l_master_type);
643: Execute Immediate 'INSERT INTO source_query_safb(sql_id, source_name) VALUES('||l_sql_id||', '''||l_source||''')';
644: l_source := NULL;
645: l_query_string := NULL;

Line 642: bis_collection_utilities.log('master_type --- '||l_master_type);

638: l_source := l_master_type;
639: END IF;
640: bis_collection_utilities.log('source_object_name --- '||l_source_object_name);
641: bis_collection_utilities.log('master_type_id --- '||l_master_type_id);
642: bis_collection_utilities.log('master_type --- '||l_master_type);
643: Execute Immediate 'INSERT INTO source_query_safb(sql_id, source_name) VALUES('||l_sql_id||', '''||l_source||''')';
644: l_source := NULL;
645: l_query_string := NULL;
646: l_sql_id := NULL;

Line 650: bis_collection_utilities.log('Populated source_name column in source_query_safb table');

646: l_sql_id := NULL;
647: END LOOP;
648: CLOSE c_query_source;
649:
650: bis_collection_utilities.log('Populated source_name column in source_query_safb table');
651:
652: -- Standard call to check for call compatibility.
653: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
654: p_api_version_number,

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

667:
668: -- Initialize API return status to SUCCESS
669: x_return_status := FND_API.G_RET_STS_SUCCESS;
670:
671: bis_collection_utilities.log('Running Incremental Load of Segment Activity Facts');
672:
673: bis_collection_utilities.log('Inserting Segment Activity Details');
674:
675: Execute Immediate 'INSERT /*+ append parallel*/ ' ||

Line 673: bis_collection_utilities.log('Inserting Segment Activity Details');

669: x_return_status := FND_API.G_RET_STS_SUCCESS;
670:
671: bis_collection_utilities.log('Running Incremental Load of Segment Activity Facts');
672:
673: bis_collection_utilities.log('Inserting Segment Activity Details');
674:
675: Execute Immediate 'INSERT /*+ append parallel*/ ' ||
676: ' INTO bim_i_sgmt_act_facts ' ||
677: ' (creation_date ' ||

Line 741: bis_collection_utilities.wrapup(p_status => TRUE

737: execute immediate 'DROP TABLE source_query_safb';
738:
739: COMMIT;
740:
741: bis_collection_utilities.wrapup(p_status => TRUE
742: ,p_count => sql%rowcount
743: ,p_period_from => p_start_date
744: ,p_period_to => p_end_date
745: ,p_attribute1 => 'INITIAL_LOAD_START_DATE'

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

759: p_count => x_msg_count,
760: p_data => x_msg_data
761: );
762:
763: bis_collection_utilities.log('BIM_I_SGMT_ACT_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
764:
765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
766:
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

773: p_count => x_msg_count,
774: p_data => x_msg_data
775: );
776:
777: bis_collection_utilities.log('BIM_I_SGMT_ACT_FACTS_PKG:INCREMENTAL_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
778:
779: WHEN OTHERS THEN
780:
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

792: p_count => x_msg_count,
793: p_data => x_msg_data
794: );
795:
796: bis_collection_utilities.log('BIM_I_SGMT_ACT_FACTS_PKG:INCREMENTAL_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
797:
798:
799: END incremental_load;
800: