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

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

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

Line 52: bis_collection_utilities.log('Object BIM_CUST_SGMT Not Setup Properly');

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

Line 56: bis_collection_utilities.log('Start of the Segment Customer Facts Program');

52: bis_collection_utilities.log('Object BIM_CUST_SGMT Not Setup Properly');
53: RAISE FND_API.G_EXC_ERROR;
54: END IF;
55:
56: bis_collection_utilities.log('Start of the Segment Customer Facts Program');
57:
58: -- Standard call to check for call compatibility.
59: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
60: 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 Customer Base Summary - Initial Load 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 Customer Base Summary - Initial Load 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: l_load_type := 'FIRST_LOAD';

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

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

Line 203: bis_collection_utilities.log('Successful Completion of Segment Customer Facts Program');

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

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

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

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

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

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

387: bis_collection_utilities.log('Running Initial Load of Segment Customer Facts');
388:
389: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
390:
391: bis_collection_utilities.log('Truncating Facts Table');
392:
393: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_party_sgmt_facts' ;
394:
395: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SGMT_CUST');

Line 395: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SGMT_CUST');

391: bis_collection_utilities.log('Truncating Facts Table');
392:
393: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_party_sgmt_facts' ;
394:
395: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SGMT_CUST');
396:
397: ---populating Segment Size
398: bis_collection_utilities.log('Inserting Segment Customer Details');
399:

Line 398: bis_collection_utilities.log('Inserting Segment Customer Details');

394:
395: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_SGMT_CUST');
396:
397: ---populating Segment Size
398: bis_collection_utilities.log('Inserting Segment Customer Details');
399:
400: Execute Immediate 'INSERT/*+ append parallel*/ INTO bim_i_party_sgmt_facts ' ||
401: ' (segment_id ' ||
402: ' ,party_id ' ||

Line 479: bis_collection_utilities.wrapup(p_status => TRUE

475: WHERE a.party_id=b.party_id);
476:
477:
478: commit;
479: bis_collection_utilities.wrapup(p_status => TRUE
480: ,p_count => sql%rowcount
481: ,p_period_from => p_start_date
482: ,p_period_to => p_end_date
483: ,p_attribute1 => 'INITIAL_LOAD_START_DATE'

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

497: p_count => x_msg_count,
498: p_data => x_msg_data
499: );
500:
501: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG : FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504:
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

511: p_count => x_msg_count,
512: p_data => x_msg_data
513: );
514:
515: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG : FIRST_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
516:
517: WHEN OTHERS THEN
518:
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

530: p_count => x_msg_count,
531: p_data => x_msg_data
532: );
533:
534: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG : FIRST_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
535:
536: END first_load;
537:
538: --------------------------------------------------------------------------------------------------

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

650:
651:
652: l_source := l_master_type;
653: END IF;
654: -- bis_collection_utilities.log('running the function --- '||l_source||l_master_type_id||l_master_type);
655: Execute Immediate 'INSERT INTO source_query_scfb(sql_id, source_name) VALUES('||l_sql_id||', '''||l_source||''')';
656: l_source := NULL;
657: l_query_string := NULL;
658: l_sql_id := NULL;

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

679: -- Initialize API return status to SUCCESS
680: x_return_status := FND_API.G_RET_STS_SUCCESS;
681:
682:
683: bis_collection_utilities.log('Running Incremental Load of Segment Customer Facts');
684:
685: bis_collection_utilities.log('Inserting Segment Customer Details');
686:
687: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);

Line 685: bis_collection_utilities.log('Inserting Segment Customer Details');

681:
682:
683: bis_collection_utilities.log('Running Incremental Load of Segment Customer Facts');
684:
685: bis_collection_utilities.log('Inserting Segment Customer Details');
686:
687: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
688:
689: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_party_sgmt_stg';

Line 872: bis_collection_utilities.wrapup(p_status => TRUE

868:
869:
870: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_party_sgmt_stg';
871:
872: bis_collection_utilities.wrapup(p_status => TRUE
873: ,p_count => sql%rowcount
874: ,p_period_from => p_start_date
875: ,p_period_to => p_end_date
876: ,p_attribute1 => 'INITIAL_LOAD_START_DATE'

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

890: p_count => x_msg_count,
891: p_data => x_msg_data
892: );
893:
894: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
895:
896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
897:
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

904: p_count => x_msg_count,
905: p_data => x_msg_data
906: );
907:
908: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG:INCREMENTAL_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
909:
910: WHEN OTHERS THEN
911:
912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

923: p_count => x_msg_count,
924: p_data => x_msg_data
925: );
926:
927: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG:INCREMENTAL_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
928:
929:
930: END incremental_load;
931: