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

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

70:
71: If(l_cnt_miss_rate1 > 0 )
72: Then
73: FND_MESSAGE.Set_Name('FII',l_msg_name);
74: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);
75: BIS_COLLECTION_UTILITIES.log('Primary Conversion rate could not be found for the given currency. Please check output file for more details' );
76: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
77:
78: FOR rate_record in C_missing_rates1

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

71: If(l_cnt_miss_rate1 > 0 )
72: Then
73: FND_MESSAGE.Set_Name('FII',l_msg_name);
74: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);
75: BIS_COLLECTION_UTILITIES.log('Primary Conversion rate could not be found for the given currency. Please check output file for more details' );
76: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
77:
78: FOR rate_record in C_missing_rates1
79: LOOP

Line 76: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

72: Then
73: FND_MESSAGE.Set_Name('FII',l_msg_name);
74: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);
75: BIS_COLLECTION_UTILITIES.log('Primary Conversion rate could not be found for the given currency. Please check output file for more details' );
76: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
77:
78: FOR rate_record in C_missing_rates1
79: LOOP
80: BIS_COLLECTION_UTILITIES.writeMissingRate(

Line 80: BIS_COLLECTION_UTILITIES.writeMissingRate(

76: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
77:
78: FOR rate_record in C_missing_rates1
79: LOOP
80: BIS_COLLECTION_UTILITIES.writeMissingRate(
81: p_rate_type => l_pgc_rate_type,
82: p_from_currency => rate_record.from_currency,
83: p_to_currency => l_global_currency_code,
84: p_date => rate_record.transaction_create_date);

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

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

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

90: End If;
91: If(l_cnt_miss_rate2 > 0 and l_secondary_currency_code is not null )
92: Then
93: FND_MESSAGE.Set_Name('FII',l_msg_name);
94: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);
95: BIS_COLLECTION_UTILITIES.log('Secondary Conversion rate could not be found for the given currency. Please check output file for more details' );
96: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
97:
98: FOR rate_record in C_missing_rates2

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

91: If(l_cnt_miss_rate2 > 0 and l_secondary_currency_code is not null )
92: Then
93: FND_MESSAGE.Set_Name('FII',l_msg_name);
94: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);
95: BIS_COLLECTION_UTILITIES.log('Secondary Conversion rate could not be found for the given currency. Please check output file for more details' );
96: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
97:
98: FOR rate_record in C_missing_rates2
99: LOOP

Line 96: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

92: Then
93: FND_MESSAGE.Set_Name('FII',l_msg_name);
94: BIS_COLLECTION_UTILITIES.debug(l_msg_name||': '||FND_MESSAGE.get);
95: BIS_COLLECTION_UTILITIES.log('Secondary Conversion rate could not be found for the given currency. Please check output file for more details' );
96: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
97:
98: FOR rate_record in C_missing_rates2
99: LOOP
100: BIS_COLLECTION_UTILITIES.writeMissingRate(

Line 100: BIS_COLLECTION_UTILITIES.writeMissingRate(

96: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
97:
98: FOR rate_record in C_missing_rates2
99: LOOP
100: BIS_COLLECTION_UTILITIES.writeMissingRate(
101: p_rate_type => l_sgc_rate_type,
102: p_from_currency => rate_record.from_currency,
103: p_to_currency => l_secondary_currency_code,
104: p_date => rate_record.transaction_create_date);

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

102: p_from_currency => rate_record.from_currency,
103: p_to_currency => l_secondary_currency_code,
104: p_date => rate_record.transaction_create_date);
105: END LOOP;
106: BIS_COLLECTION_UTILITIES.debug('before returning -1' );
107: RETURN -1;
108: ELSE
109: Return 1;
110: End If;

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

109: Return 1;
110: End If;
111: EXCEPTION
112: WHEN OTHERS THEN
113: BIS_COLLECTION_UTILITIES.Debug('Error in Check_missing_rates:'||sqlerrm);
114: RAISE;
115: END Check_Missing_Rates;
116:
117: ---------------------------------------------------------------------------------------------------

Line 182: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Facts load starts at:'||sysdate);

178: x_return_status := FND_API.G_RET_STS_SUCCESS;
179:
180: -- Debug Message
181: -- AMS_UTILITY_PVT.debug_message('Private API: ' || 'Running the populate procedure');
182: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Facts load starts at:'||sysdate);
183:
184: l_global_start_date :=BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE();
185:
186: /* THIS CODE REPLACES THE GET_LAST_REFRESH_PERIOD TO GET_LAST_REFRESH_DATES */

Line 188: bis_collection_utilities.get_last_refresh_dates('MARKETING_FACTS'

184: l_global_start_date :=BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE();
185:
186: /* THIS CODE REPLACES THE GET_LAST_REFRESH_PERIOD TO GET_LAST_REFRESH_DATES */
187:
188: bis_collection_utilities.get_last_refresh_dates('MARKETING_FACTS'
189: ,l_conc_start_date,l_conc_end_date,l_start_date,l_end_date);
190:
191:
192: IF (l_end_date IS NULL) THEN

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

191:
192: IF (l_end_date IS NULL) THEN
193:
194: IF (p_start_date IS NULL) THEN
195: bis_collection_utilities.log('Please run the Upadate Marketing Facts First Time Base Summary concurrent program before running this');
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198:
199: IF (p_start_date >= p_end_date) THEN

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

196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198:
199: IF (p_start_date >= p_end_date) THEN
200: bis_collection_utilities.log('Start Date Can not be greater than End Date');
201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203: --Validate time dimension tables
204: fii_time_api.check_missing_date (greatest(l_global_start_date,p_start_date), sysdate, l_missing_date);

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

202: END IF;
203: --Validate time dimension tables
204: fii_time_api.check_missing_date (greatest(l_global_start_date,p_start_date), sysdate, l_missing_date);
205: IF (l_missing_date) THEN
206: bis_collection_utilities.log('Time dimension has at least one missing date between ' || greatest(l_global_start_date,p_start_date) || ' and ' || sysdate);
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209:
210: l_load_type := 'FIRST_LOAD';

Line 211: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: First Load');

207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209:
210: l_load_type := 'FIRST_LOAD';
211: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: First Load');
212: FIRST_LOAD(p_start_date => greatest(l_global_start_date,p_start_date)
213: ,p_end_date => sysdate
214: ,p_api_version_number => l_api_version_number
215: ,p_init_msg_list => FND_API.G_FALSE

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

237: );
238: ELSE
239:
240: IF (l_end_date >= sysdate) THEN
241: bis_collection_utilities.log('Load Progarm already run upto ' || l_end_date);
242: RAISE FND_API.g_exc_error;
243: END IF;
244: --Validate time dimension tables
245: fii_time_api.check_missing_date (l_end_date, sysdate, l_missing_date);

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

243: END IF;
244: --Validate time dimension tables
245: fii_time_api.check_missing_date (l_end_date, sysdate, l_missing_date);
246: IF (l_missing_date) THEN
247: bis_collection_utilities.log('Time dimension has atleast one missing date between ' || l_end_date || ' and ' || sysdate);
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250:
251: l_load_type := 'SUBSEQUENT_LOAD';

Line 252: /*BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Incremental Load');

248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250:
251: l_load_type := 'SUBSEQUENT_LOAD';
252: /*BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Incremental Load');
253: SUB_LOAD(p_start_date => l_end_date +1/86400
254: ,p_end_date => sysdate
255: ,p_api_version_number => l_api_version_number
256: ,p_init_msg_list => FND_API.G_FALSE

Line 263: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Incremental Load');

259: ,x_msg_data => x_msg_data
260: ,x_return_status => x_return_status
261: );*/
262:
263: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Incremental Load');
264: SUB_LOAD(p_start_date => trunc(l_end_date)
265: ,p_end_date => sysdate
266: ,p_api_version_number => l_api_version_number
267: ,p_init_msg_list => FND_API.G_FALSE

Line 289: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Facts Concurrent Program Succesfully Completed');

285: COMMIT WORK;
286: END IF;
287:
288: COMMIT;
289: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Facts Concurrent Program Succesfully Completed');
290:
291: -- Standard call to get message count and if count is 1, get message info.
292: FND_MSG_PUB.Count_And_Get
293: (p_count => x_msg_count,

Line 417: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Drop index before inserting.');

413:
414: /* Piece of Code for retrieving,storing storage parameters and Dropping the indexes */
415: /*fnd_message.set_name('BIM','BIM_R_DROP_INDEXES');
416: fnd_file.put_line(fnd_file.log,fnd_message.get);*/
417: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Drop index before inserting.');
418: BIM_UTL_PKG.drop_index('BIM_I_MARKETING_FACTS');
419: /* End of Code for dropping the existing indexes */
420: EXCEPTION when others then
421: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: error:'||sqlerrm(sqlcode));

Line 421: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: error:'||sqlerrm(sqlcode));

417: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Drop index before inserting.');
418: BIM_UTL_PKG.drop_index('BIM_I_MARKETING_FACTS');
419: /* End of Code for dropping the existing indexes */
420: EXCEPTION when others then
421: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: error:'||sqlerrm(sqlcode));
422: --dbms_output.put_line('error first:'||sqlerrm(sqlcode));
423: END;
424: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MARKETING_FACTS_STG';
425: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MKT_RATES';

Line 427: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Inserting table bim_i_marketing_facts_stg');

423: END;
424: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MARKETING_FACTS_STG';
425: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MKT_RATES';
426: l_table_name :='bim_i_marketing_facts';
427: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Inserting table bim_i_marketing_facts_stg');
428: /*fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
429: fnd_message.set_token('TABLE_NAME',l_table_name, FALSE);
430: fnd_file.put_line(fnd_file.log,fnd_message.get);*/
431: -- dbms_output.put_Line('JUST BEFORE THE MAIN INSERT STATMENT');

Line 1973: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Second insert into bim_i_marketing_facts_stg');

1969: ,conversion_rate_s) inner ;
1970:
1971: commit;
1972:
1973: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Second insert into bim_i_marketing_facts_stg');
1974: -------------------------NEW CODE --------------
1975: INSERT /*+ append parallel */
1976: INTO BIM_I_MARKETING_FACTS_STG CDF (
1977: --MKT_DAILY_TRANSACTION_ID ,

Line 2548: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Third insert into bim_i_marketing_facts_stg');

2544: ,conversion_rate_s
2545: ) inner ;
2546: ---------------------END NEW CODE------------------------
2547: commit;
2548: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Third insert into bim_i_marketing_facts_stg');
2549: INSERT /*+ append parallel */
2550: INTO BIM_I_MARKETING_FACTS_STG CDF (
2551: --MKT_DAILY_TRANSACTION_ID ,
2552: CREATION_DATE ,

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

2674: AND s.object_type NOT IN ('RCAM')
2675: and f.object_id IS NULL;
2676: commit;
2677:
2678: bis_collection_utilities.log('Truncating Facts Table');
2679:
2680: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_marketing_facts';
2681: BIS_COLLECTION_UTILITIES.deleteLogForObject('MARKETING_FACTS');
2682:

Line 2681: BIS_COLLECTION_UTILITIES.deleteLogForObject('MARKETING_FACTS');

2677:
2678: bis_collection_utilities.log('Truncating Facts Table');
2679:
2680: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_marketing_facts';
2681: BIS_COLLECTION_UTILITIES.deleteLogForObject('MARKETING_FACTS');
2682:
2683:
2684: --insert schedules
2685: INSERT /*+ append parallel */

Line 2813: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Insert into bim_i_mkt_rates.');

2809: and s.child_object_type = f.child_object_type (+)
2810: and f.child_object_id is null;
2811: commit;
2812:
2813: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Insert into bim_i_mkt_rates.');
2814: --Insert rates_temp table
2815: INSERT /*+ append parallel */
2816: INTO BIM_I_MKT_RATES MRT(tc_code,
2817: trx_date,

Line 2828: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:After Insert into bim_i_mkt_rates.');

2824: FROM (select distinct from_currency from_currency,
2825: transaction_create_date transaction_create_date
2826: from bim_i_marketing_facts_stg);
2827: commit;
2828: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:After Insert into bim_i_mkt_rates.');
2829: l_check_missing_rate := Check_Missing_Rates (p_start_date);
2830: if (l_check_missing_rate = -1) then
2831: BIS_COLLECTION_UTILITIES.debug('before truncating first time load' );
2832: l_stmt := 'TRUNCATE table '||L_SCHEMA||'.BIM_I_MARKETING_FACTS_STG';

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

2827: commit;
2828: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:After Insert into bim_i_mkt_rates.');
2829: l_check_missing_rate := Check_Missing_Rates (p_start_date);
2830: if (l_check_missing_rate = -1) then
2831: BIS_COLLECTION_UTILITIES.debug('before truncating first time load' );
2832: l_stmt := 'TRUNCATE table '||L_SCHEMA||'.BIM_I_MARKETING_FACTS_STG';
2833: EXECUTE IMMEDIATE l_stmt;
2834: commit;
2835: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2838: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:After check missing rates');

2834: commit;
2835: x_return_status := FND_API.G_RET_STS_ERROR;
2836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2837: end if;
2838: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:After check missing rates');
2839: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Final Insert into bim_i_marketing_facts.');
2840: INSERT /*+ append parallel */
2841: INTO BIM_I_MARKETING_FACTS CDF (
2842: --MKT_DAILY_TRANSACTION_ID ,

Line 2839: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Final Insert into bim_i_marketing_facts.');

2835: x_return_status := FND_API.G_RET_STS_ERROR;
2836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2837: end if;
2838: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:After check missing rates');
2839: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Final Insert into bim_i_marketing_facts.');
2840: INSERT /*+ append parallel */
2841: INTO BIM_I_MARKETING_FACTS CDF (
2842: --MKT_DAILY_TRANSACTION_ID ,
2843: CREATION_DATE ,

Line 2971: --BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Inserted '||SQL%COUNT);

2967: where a.from_currency = rt.tc_code(+)
2968: and a.transaction_create_date= rt.trx_date(+);
2969: commit;
2970:
2971: --BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Inserted '||SQL%COUNT);
2972: EXECUTE IMMEDIATE 'COMMIT';
2973: -- EXECUTE IMMEDIATE 'ALTER SEQUENCE bim_i_marketing_facts_s CACHE 20';
2974:
2975: -- Analyze the daily facts table

Line 2983: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Wrapup');

2979:
2980: -- EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.MLOG$_BIM_I_MARKETING_FACT';
2981:
2982: -- Make entry in the history table
2983: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Wrapup');
2984: BEGIN
2985: IF (Not BIS_COLLECTION_UTILITIES.setup('MARKETING_FACTS')) THEN
2986: RAISE FND_API.G_EXC_ERROR;
2987: return;

Line 2985: IF (Not BIS_COLLECTION_UTILITIES.setup('MARKETING_FACTS')) THEN

2981:
2982: -- Make entry in the history table
2983: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Wrapup');
2984: BEGIN
2985: IF (Not BIS_COLLECTION_UTILITIES.setup('MARKETING_FACTS')) THEN
2986: RAISE FND_API.G_EXC_ERROR;
2987: return;
2988: END IF;
2989:

Line 2990: BIS_COLLECTION_UTILITIES.WRAPUP(

2986: RAISE FND_API.G_EXC_ERROR;
2987: return;
2988: END IF;
2989:
2990: BIS_COLLECTION_UTILITIES.WRAPUP(
2991: p_status =>TRUE ,
2992: p_period_from =>p_start_date,
2993: p_period_to => sysdate--p_end_date
2994: );

Line 2997: BIS_COLLECTION_UTILITIES.WRAPUP(

2993: p_period_to => sysdate--p_end_date
2994: );
2995: Exception when others then
2996: Rollback;
2997: BIS_COLLECTION_UTILITIES.WRAPUP(
2998: p_status => FALSE,
2999: p_period_from =>p_start_date,
3000: p_period_to => sysdate--p_end_date
3001: );

Line 3005: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Before create index');

3001: );
3002: RAISE FND_API.G_EXC_ERROR;
3003: END;
3004:
3005: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Before create index');
3006:
3007: BIM_UTL_PKG.CREATE_INDEX('BIM_I_MARKETING_FACTS');
3008: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
3009: --ams_utility_pvt.write_conc_log('BIM_I_MARKETING_FACTS:FIRST_LOAD: AFTER CREATE INDEX ' || l_temp_msg);

Line 3010: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:After create index');

3006:
3007: BIM_UTL_PKG.CREATE_INDEX('BIM_I_MARKETING_FACTS');
3008: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
3009: --ams_utility_pvt.write_conc_log('BIM_I_MARKETING_FACTS:FIRST_LOAD: AFTER CREATE INDEX ' || l_temp_msg);
3010: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:After create index');
3011: /*fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
3012: fnd_message.set_token('program_name', 'Marketing first load', FALSE);
3013: fnd_file.put_line(fnd_file.log,fnd_message.get);*/
3014: EXCEPTION

Line 3033: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Unexpected'||sqlerrm(sqlcode));

3029: --p_encoded => FND_API.G_FALSE,
3030: p_count => x_msg_count,
3031: p_data => x_msg_data
3032: );
3033: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Unexpected'||sqlerrm(sqlcode));
3034:
3035: WHEN OTHERS THEN
3036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3037: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)

Line 3048: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:IN OTHERS EXCEPTION'||sqlerrm(sqlcode));

3044: -- p_encoded => FND_API.G_FALSE,
3045: p_count => x_msg_count,
3046: p_data => x_msg_data
3047: );
3048: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:IN OTHERS EXCEPTION'||sqlerrm(sqlcode));
3049: --end;
3050: END FIRST_LOAD;
3051: --------------------------------------------------------------------------------------------------
3052: -- This procedure will execute when data is loaded for subsequent time.

Line 3125: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:SUBSEQUENT_LOAD start');

3121: --dbms_output.put_line('inside sub load:'||sqlerrm(sqlcode));
3122: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
3123: END;
3124: --dbms_output.put_line('right b4 inserting');
3125: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:SUBSEQUENT_LOAD start');
3126: --ams_utility_pvt.write_conc_log('BIM_I_MARKETING_FACTS:SUBSEQUENT_LOAD: BEFORE FIRST INSERT ' || l_temp_msg);
3127: BEGIN
3128: DELETE from bim_i_marketing_facts where transaction_create_date>= p_start_date and metric_type is not null;
3129: COMMIT;

Line 3132: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Error in first insert:'||sqlerrm(sqlcode));

3128: DELETE from bim_i_marketing_facts where transaction_create_date>= p_start_date and metric_type is not null;
3129: COMMIT;
3130: EXCEPTION
3131: when others then
3132: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Error in first insert:'||sqlerrm(sqlcode));
3133: --dbms_output.put_line('error inserting:'||sqlerrm(sqlcode));
3134: END;
3135: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MARKETING_FACTS_STG';
3136: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MKT_RATES';

Line 3138: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:First insert BIM_I_MARKETING_FACTS_STG');

3134: END;
3135: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MARKETING_FACTS_STG';
3136: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MKT_RATES';
3137:
3138: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:First insert BIM_I_MARKETING_FACTS_STG');
3139: --BEGIN
3140: --dbms_output.put_line('right b4 inserting'||sqlerrm(sqlcode));
3141: INSERT
3142: INTO BIM_I_MARKETING_FACTS_STG CDF

Line 4593: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Second insert BIM_I_MARKETING_FACTS_STG');

4589: ,conversion_rate
4590: ,from_currency
4591: ,conversion_rate_s) inner;
4592:
4593: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Second insert BIM_I_MARKETING_FACTS_STG');
4594: ------------------------------NEW CODE----------------------
4595: INSERT INTO bim_i_marketing_facts_STG
4596: ( --MKT_DAILY_TRANSACTION_ID ,
4597: CREATION_DATE ,

Line 5218: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Third insert BIM_I_MARKETING_FACTS_STG');

5214:
5215: --dbms_output.put_line('inserted :'||SQL%ROWCOUNT);
5216: COMMIT;
5217:
5218: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Third insert BIM_I_MARKETING_FACTS_STG');
5219: bis_collection_utilities.get_last_refresh_dates('BIM_SOURCE_CODE' ,l_conc_start_date,l_conc_end_date,l_sc_s_date,l_sc_e_date);
5220:
5221: INSERT INTO BIM_I_MARKETING_FACTS_STG CDF (
5222: --MKT_DAILY_TRANSACTION_ID ,

Line 5219: bis_collection_utilities.get_last_refresh_dates('BIM_SOURCE_CODE' ,l_conc_start_date,l_conc_end_date,l_sc_s_date,l_sc_e_date);

5215: --dbms_output.put_line('inserted :'||SQL%ROWCOUNT);
5216: COMMIT;
5217:
5218: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Third insert BIM_I_MARKETING_FACTS_STG');
5219: bis_collection_utilities.get_last_refresh_dates('BIM_SOURCE_CODE' ,l_conc_start_date,l_conc_end_date,l_sc_s_date,l_sc_e_date);
5220:
5221: INSERT INTO BIM_I_MARKETING_FACTS_STG CDF (
5222: --MKT_DAILY_TRANSACTION_ID ,
5223: CREATION_DATE ,

Line 5347: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Inserting into BIM_I_MKT_RATES');

5343: and a.object_id = b.object_id
5344: AND a.object_type NOT IN ('RCAM')
5345: and a.object_type = b.object_type);
5346:
5347: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Inserting into BIM_I_MKT_RATES');
5348: --insert into bim_i_mkt_rates
5349: INSERT
5350: INTO BIM_I_MKT_RATES MRT(tc_code,
5351: trx_date,

Line 5369: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Sub Load:after calling checking_missing_rates');

5365: commit;
5366: x_return_status := FND_API.G_RET_STS_ERROR;
5367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5368: end if;
5369: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Sub Load:after calling checking_missing_rates');
5370: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Final insert into bim_i_marketing_facts');
5371: INSERT
5372: INTO BIM_I_MARKETING_FACTS CDF (
5373: --MKT_DAILY_TRANSACTION_ID ,

Line 5370: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Final insert into bim_i_marketing_facts');

5366: x_return_status := FND_API.G_RET_STS_ERROR;
5367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5368: end if;
5369: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Sub Load:after calling checking_missing_rates');
5370: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Final insert into bim_i_marketing_facts');
5371: INSERT
5372: INTO BIM_I_MARKETING_FACTS CDF (
5373: --MKT_DAILY_TRANSACTION_ID ,
5374: CREATION_DATE ,

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

5628:
5629: --dbms_output.put_line('after analyze log'||sqlerrm(sqlcode));
5630: /***************************************************************/
5631: --dbms_output.put_line('b4 inserting log');
5632: BIS_COLLECTION_UTILITIES.log('Before Insert into log.');
5633: BEGIN
5634: IF (Not BIS_COLLECTION_UTILITIES.setup('MARKETING_FACTS')) THEN
5635: RAISE FND_API.G_EXC_ERROR;
5636: return;

Line 5634: IF (Not BIS_COLLECTION_UTILITIES.setup('MARKETING_FACTS')) THEN

5630: /***************************************************************/
5631: --dbms_output.put_line('b4 inserting log');
5632: BIS_COLLECTION_UTILITIES.log('Before Insert into log.');
5633: BEGIN
5634: IF (Not BIS_COLLECTION_UTILITIES.setup('MARKETING_FACTS')) THEN
5635: RAISE FND_API.G_EXC_ERROR;
5636: return;
5637: END IF;
5638: BIS_COLLECTION_UTILITIES.WRAPUP(

Line 5638: BIS_COLLECTION_UTILITIES.WRAPUP(

5634: IF (Not BIS_COLLECTION_UTILITIES.setup('MARKETING_FACTS')) THEN
5635: RAISE FND_API.G_EXC_ERROR;
5636: return;
5637: END IF;
5638: BIS_COLLECTION_UTILITIES.WRAPUP(
5639: p_status => TRUE ,
5640: p_period_from =>p_start_date,
5641: p_period_to => sysdate--p_end_date
5642: );

Line 5645: BIS_COLLECTION_UTILITIES.WRAPUP(

5641: p_period_to => sysdate--p_end_date
5642: );
5643: Exception when others then
5644: Rollback;
5645: BIS_COLLECTION_UTILITIES.WRAPUP(
5646: p_status => FALSE,
5647: p_period_from =>p_start_date,
5648: p_period_to =>sysdate-- p_end_date
5649: );

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

5648: p_period_to =>sysdate-- p_end_date
5649: );
5650: RAISE FND_API.G_EXC_ERROR;
5651: END;
5652: BIS_COLLECTION_UTILITIES.log('After Insert into log.');
5653: EXCEPTION
5654: WHEN FND_API.G_EXC_ERROR THEN
5655: x_return_status := FND_API.G_RET_STS_ERROR;
5656: -- Standard call to get message count and if count=1, get the message

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

5660: p_data => x_msg_data
5661: );
5662:
5663: ams_utility_pvt.write_conc_log('SUBSEQUENT_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
5664: BIS_COLLECTION_UTILITIES.log('SUBSEQUENT_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
5665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5666:
5667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5668:

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

5673: p_data => x_msg_data
5674: );
5675:
5676: ams_utility_pvt.write_conc_log('BIM_I_MARKETING_FACTS:SUBSEQUENT_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
5677: BIS_COLLECTION_UTILITIES.log('SUBSEQUENT_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
5678: WHEN OTHERS THEN
5679:
5680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5681:

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

5690: p_count => x_msg_count,
5691: p_data => x_msg_data
5692: );
5693: ams_utility_pvt.write_conc_log('BIM_I_MARKETING_FACTS:SUBSEQUENT_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
5694: BIS_COLLECTION_UTILITIES.log('SUBSEQUENT_LOAD:IN other EXCEPTION '||sqlerrm(sqlcode));
5695: END SUB_LOAD;
5696: END BIM_MARKET_FACTS_PKG;