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 BIM_I_MARKETING_FACTS

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 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 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 403: --dbms_output.put_line('BIM_I_MARKETING_FACTS: Running the First Load '||sqlerrm(sqlcode));

399:
400: -- Initialize API return status to SUCCESS
401: x_return_status := FND_API.G_RET_STS_SUCCESS;
402:
403: --dbms_output.put_line('BIM_I_MARKETING_FACTS: Running the First Load '||sqlerrm(sqlcode));
404:
405: -- The below four commands are necessary for the purpose of the parallel insertion */
406: BEGIN
407: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL dml ';

Line 410: --EXECUTE IMMEDIATE 'ALTER TABLE bim_i_marketing_facts nologging ';

406: BEGIN
407: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL dml ';
408: --EXECUTE IMMEDIATE 'ALTER SESSION SET SORT_AREA_SIZE=100000000 ';
409: --EXECUTE IMMEDIATE 'ALTER SESSION SET HASH_AREA_SIZE=100000000 ';
410: --EXECUTE IMMEDIATE 'ALTER TABLE bim_i_marketing_facts nologging ';
411: -- EXECUTE IMMEDIATE 'ALTER SEQUENCE BIM_I_MARKETING_FACTS_s CACHE 1000 ';
412:
413:
414: /* Piece of Code for retrieving,storing storage parameters and Dropping the indexes */

Line 411: -- EXECUTE IMMEDIATE 'ALTER SEQUENCE BIM_I_MARKETING_FACTS_s CACHE 1000 ';

407: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL dml ';
408: --EXECUTE IMMEDIATE 'ALTER SESSION SET SORT_AREA_SIZE=100000000 ';
409: --EXECUTE IMMEDIATE 'ALTER SESSION SET HASH_AREA_SIZE=100000000 ';
410: --EXECUTE IMMEDIATE 'ALTER TABLE bim_i_marketing_facts nologging ';
411: -- EXECUTE IMMEDIATE 'ALTER SEQUENCE BIM_I_MARKETING_FACTS_s CACHE 1000 ';
412:
413:
414: /* Piece of Code for retrieving,storing storage parameters and Dropping the indexes */
415: /*fnd_message.set_name('BIM','BIM_R_DROP_INDEXES');

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 418: BIM_UTL_PKG.drop_index('BIM_I_MARKETING_FACTS');

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));
422: --dbms_output.put_line('error first:'||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 424: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MARKETING_FACTS_STG';

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';
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');

Line 426: l_table_name :='bim_i_marketing_facts';

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';
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);*/

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 433: INTO BIM_I_MARKETING_FACTS_STG CDF (

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');
432: INSERT /*+ append parallel */
433: INTO BIM_I_MARKETING_FACTS_STG CDF (
434: --MKT_DAILY_TRANSACTION_ID ,
435: CREATION_DATE ,
436: LAST_UPDATE_DATE ,
437: CREATED_BY ,

Line 497: -- BIM_I_MARKETING_FACTS_s.nextval ,

493: metric1 ,
494: metric2
495: )
496: SELECT /*+ parallel */
497: -- BIM_I_MARKETING_FACTS_s.nextval ,
498: sysdate
499: ,sysdate
500: ,-1
501: ,-1

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 1976: INTO BIM_I_MARKETING_FACTS_STG CDF (

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 ,
1978: CREATION_DATE ,
1979: LAST_UPDATE_DATE ,
1980: CREATED_BY ,

Line 2038: --BIM_I_MARKETING_FACTS_s.nextval ,

2034: CONVERSION_RATE_S ,
2035: metric1 ,
2036: metric2)
2037: SELECT /*+ parallel */
2038: --BIM_I_MARKETING_FACTS_s.nextval ,
2039: sysdate
2040: ,sysdate
2041: ,-1
2042: ,-1

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 2550: INTO BIM_I_MARKETING_FACTS_STG CDF (

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 ,
2553: LAST_UPDATE_DATE ,
2554: CREATED_BY ,

Line 2669: bim_i_marketing_facts f

2665: ,0
2666: ,0
2667: ,0
2668: FROM bim_i_source_codes s,
2669: bim_i_marketing_facts f
2670: where s.child_object_id = 0
2671: and f.child_object_id(+) = 0
2672: and s.object_id = f.object_id (+)
2673: and s.object_type = f.object_type (+)

Line 2680: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_marketing_facts';

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:
2683:
2684: --insert schedules

Line 2686: INTO BIM_I_MARKETING_FACTS CDF (

2682:
2683:
2684: --insert schedules
2685: INSERT /*+ append parallel */
2686: INTO BIM_I_MARKETING_FACTS CDF (
2687: --MKT_DAILY_TRANSACTION_ID ,
2688: CREATION_DATE ,
2689: LAST_UPDATE_DATE ,
2690: CREATED_BY ,

Line 2805: bim_i_marketing_facts f

2801: ,null
2802: ,0
2803: ,0
2804: FROM bim_i_source_codes s,
2805: bim_i_marketing_facts f
2806: where s.child_object_id > 0
2807: and f.child_object_id(+) > 0
2808: and s.child_object_id = f.child_object_id (+)
2809: and s.child_object_type = f.child_object_type (+)

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 2826: from bim_i_marketing_facts_stg);

2822: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),
2823: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)
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

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 2832: l_stmt := 'TRUNCATE table '||L_SCHEMA||'.BIM_I_MARKETING_FACTS_STG';

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;
2836: RAISE FND_API.G_EXC_UNEXPECTED_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 2841: INTO BIM_I_MARKETING_FACTS CDF (

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 ,
2844: LAST_UPDATE_DATE ,
2845: CREATED_BY ,

Line 2905: -- BIM_I_MARKETING_FACTS_s.nextval ,

2901: metric1 ,
2902: metric2
2903: )
2904: SELECT /*+ parallel */
2905: -- BIM_I_MARKETING_FACTS_s.nextval ,
2906: sysdate
2907: ,sysdate
2908: ,-1
2909: ,-1

Line 2966: FROM bim_i_marketing_facts_stg a, bim_i_mkt_rates rt

2962: ,BUDGET_APPROVED*sec_conversion_rate
2963: ,CONVERSION_RATE_S
2964: ,metric1*rt.prim_conversion_rate
2965: ,metric1*sec_conversion_rate
2966: FROM bim_i_marketing_facts_stg a, bim_i_mkt_rates rt
2967: where a.from_currency = rt.tc_code(+)
2968: and a.transaction_create_date= rt.trx_date(+);
2969: commit;
2970:

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 2973: -- EXECUTE IMMEDIATE 'ALTER SEQUENCE bim_i_marketing_facts_s CACHE 20';

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
2976: DBMS_STATS.gather_table_stats('BIM','BIM_I_MARKETING_FACTS', estimate_percent => 5,
2977: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 2976: DBMS_STATS.gather_table_stats('BIM','BIM_I_MARKETING_FACTS', estimate_percent => 5,

2972: EXECUTE IMMEDIATE 'COMMIT';
2973: -- EXECUTE IMMEDIATE 'ALTER SEQUENCE bim_i_marketing_facts_s CACHE 20';
2974:
2975: -- Analyze the daily facts table
2976: DBMS_STATS.gather_table_stats('BIM','BIM_I_MARKETING_FACTS', estimate_percent => 5,
2977: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2978: --dbms_output.put_line('b4 put into history');
2979:
2980: -- EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.MLOG$_BIM_I_MARKETING_FACT';

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 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 3007: BIM_UTL_PKG.CREATE_INDEX('BIM_I_MARKETING_FACTS');

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);
3010: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:After create index');
3011: /*fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');

Line 3009: --ams_utility_pvt.write_conc_log('BIM_I_MARKETING_FACTS:FIRST_LOAD: AFTER CREATE INDEX ' || l_temp_msg);

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);
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);*/

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 3024: ams_utility_pvt.write_conc_log('BIM_I_MARKETING_FACTS:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));

3020: p_count => x_msg_count,
3021: p_data => x_msg_data
3022: );
3023:
3024: ams_utility_pvt.write_conc_log('BIM_I_MARKETING_FACTS:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
3025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3027: -- Standard call to get message count and if count=1, get the message
3028: FND_msg_PUB.Count_And_Get (

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 3117: --EXECUTE IMMEDIATE 'ALTER TABLE BIM_I_MARKETING_FACTS nologging ';

3113: BEGIN
3114: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL dml ';
3115: --EXECUTE IMMEDIATE 'ALTER SESSION SET SORT_AREA_SIZE=100000000 ';
3116: --EXECUTE IMMEDIATE 'ALTER SESSION SET HASH_AREA_SIZE=100000000 ';
3117: --EXECUTE IMMEDIATE 'ALTER TABLE BIM_I_MARKETING_FACTS nologging ';
3118: -- EXECUTE IMMEDIATE 'ALTER SEQUENCE BIM_I_MARKETING_FACTS_s CACHE 1000 ';
3119: EXCEPTION
3120: when others then
3121: --dbms_output.put_line('inside sub load:'||sqlerrm(sqlcode));

Line 3118: -- EXECUTE IMMEDIATE 'ALTER SEQUENCE BIM_I_MARKETING_FACTS_s CACHE 1000 ';

3114: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL dml ';
3115: --EXECUTE IMMEDIATE 'ALTER SESSION SET SORT_AREA_SIZE=100000000 ';
3116: --EXECUTE IMMEDIATE 'ALTER SESSION SET HASH_AREA_SIZE=100000000 ';
3117: --EXECUTE IMMEDIATE 'ALTER TABLE BIM_I_MARKETING_FACTS nologging ';
3118: -- EXECUTE IMMEDIATE 'ALTER SEQUENCE BIM_I_MARKETING_FACTS_s CACHE 1000 ';
3119: EXCEPTION
3120: when others then
3121: --dbms_output.put_line('inside sub load:'||sqlerrm(sqlcode));
3122: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');

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 3126: --ams_utility_pvt.write_conc_log('BIM_I_MARKETING_FACTS:SUBSEQUENT_LOAD: BEFORE FIRST INSERT ' || l_temp_msg);

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;
3130: EXCEPTION

Line 3128: DELETE from bim_i_marketing_facts where transaction_create_date>= p_start_date and metric_type is not null;

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;
3130: EXCEPTION
3131: when others then
3132: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Error in first insert:'||sqlerrm(sqlcode));

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 3135: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MARKETING_FACTS_STG';

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';
3137:
3138: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:First insert BIM_I_MARKETING_FACTS_STG');
3139: --BEGIN

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 3142: INTO BIM_I_MARKETING_FACTS_STG CDF

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
3143: ( -- MKT_DAILY_TRANSACTION_ID ,
3144: CREATION_DATE ,
3145: LAST_UPDATE_DATE ,
3146: CREATED_BY ,

Line 3206: --BIM_I_MARKETING_FACTS_s.nextval,

3202: metric1 ,
3203: metric2
3204: )
3205: SELECT
3206: --BIM_I_MARKETING_FACTS_s.nextval,
3207: sysdate
3208: ,sysdate
3209: ,-1
3210: ,-1

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 4595: INSERT INTO bim_i_marketing_facts_STG

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 ,
4598: LAST_UPDATE_DATE ,
4599: CREATED_BY ,

Line 5082: (SELECT source_code_id from bim_i_marketing_facts facts

5078: ,nvl(f1.functional_currency_code,'USD')
5079: HAVING sum(nvl(f1.func_forecasted_delta,0)) <> 0
5080: ) inner
5081: WHERE NOT EXISTS
5082: (SELECT source_code_id from bim_i_marketing_facts facts
5083: WHERE facts.object_id = inner.object_id
5084: AND facts.object_type = inner.object_type
5085: AND facts.source_code_id = inner.source_code_id
5086: AND facts.metric_type = inner.metric_type

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 5221: INSERT INTO BIM_I_MARKETING_FACTS_STG CDF (

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 ,
5224: LAST_UPDATE_DATE ,
5225: CREATED_BY ,

Line 5341: bim_i_marketing_facts b

5337: where a.child_object_id =0
5338: and a.obj_last_update_date >l_sc_s_date
5339: and not exists (
5340: select b.object_id,b.object_type from
5341: bim_i_marketing_facts b
5342: where b.child_object_id =0
5343: and a.object_id = b.object_id
5344: AND a.object_type NOT IN ('RCAM')
5345: and a.object_type = b.object_type);

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 5360: from bim_i_marketing_facts_stg);

5356: FII_CURRENCY.get_rate(from_currency,l_global_currency_code,transaction_create_date,l_pgc_rate_type),
5357: FII_CURRENCY.get_rate(from_currency,l_secondary_currency_code,transaction_create_date,l_sgc_rate_type)
5358: FROM (select distinct from_currency from_currency,
5359: transaction_create_date transaction_create_date
5360: from bim_i_marketing_facts_stg);
5361:
5362: l_check_missing_rate := Check_Missing_Rates (p_start_date);
5363: if (l_check_missing_rate = -1) then
5364: DELETE from bim_i_marketing_facts_stg where transaction_create_date>= p_start_date;

Line 5364: DELETE from bim_i_marketing_facts_stg where transaction_create_date>= p_start_date;

5360: from bim_i_marketing_facts_stg);
5361:
5362: l_check_missing_rate := Check_Missing_Rates (p_start_date);
5363: if (l_check_missing_rate = -1) then
5364: DELETE from bim_i_marketing_facts_stg where transaction_create_date>= p_start_date;
5365: commit;
5366: x_return_status := FND_API.G_RET_STS_ERROR;
5367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5368: end if;

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 5372: INTO BIM_I_MARKETING_FACTS CDF (

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 ,
5375: LAST_UPDATE_DATE ,
5376: CREATED_BY ,

Line 5436: -- BIM_I_MARKETING_FACTS_s.nextval ,

5432: metric1 ,
5433: metric2
5434: )
5435: SELECT /*+ parallel */
5436: -- BIM_I_MARKETING_FACTS_s.nextval ,
5437: sysdate
5438: ,sysdate
5439: ,-1
5440: ,-1

Line 5497: FROM bim_i_marketing_facts_stg a, bim_i_mkt_rates rt

5493: ,BUDGET_APPROVED*sec_conversion_rate
5494: ,CONVERSION_RATE_S
5495: ,metric1*rt.prim_conversion_rate
5496: ,metric1*sec_conversion_rate
5497: FROM bim_i_marketing_facts_stg a, bim_i_mkt_rates rt
5498: where a.from_currency = rt.tc_code(+)
5499: and a.transaction_create_date= rt.trx_date(+);
5500:
5501: --Insert schedules

Line 5502: INSERT INTO BIM_I_MARKETING_FACTS CDF (

5498: where a.from_currency = rt.tc_code(+)
5499: and a.transaction_create_date= rt.trx_date(+);
5500:
5501: --Insert schedules
5502: INSERT INTO BIM_I_MARKETING_FACTS CDF (
5503: --MKT_DAILY_TRANSACTION_ID ,
5504: CREATION_DATE ,
5505: LAST_UPDATE_DATE ,
5506: CREATED_BY ,

Line 5619: bim_i_marketing_facts b

5615: where a.child_object_id >0
5616: and a.obj_last_update_date >l_sc_s_date
5617: and not exists (
5618: select b.child_object_id,b.child_object_type from
5619: bim_i_marketing_facts b
5620: where b.child_object_id >0
5621: and a.child_object_id = b.child_object_id
5622: AND a.object_type NOT IN ('RCAM')
5623: and a.child_object_type = b.child_object_type);

Line 5626: DBMS_STATS.gather_table_stats('BIM','BIM_I_MARKETING_FACTS', estimate_percent => 5,

5622: AND a.object_type NOT IN ('RCAM')
5623: and a.child_object_type = b.child_object_type);
5624:
5625: -- Analyze the daily facts table
5626: DBMS_STATS.gather_table_stats('BIM','BIM_I_MARKETING_FACTS', estimate_percent => 5,
5627: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
5628:
5629: --dbms_output.put_line('after analyze log'||sqlerrm(sqlcode));
5630: /***************************************************************/

Line 5676: ams_utility_pvt.write_conc_log('BIM_I_MARKETING_FACTS:SUBSEQUENT_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));

5672: p_count => x_msg_count,
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;

Line 5693: ams_utility_pvt.write_conc_log('BIM_I_MARKETING_FACTS:SUBSEQUENT_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));

5689: -- p_encoded => FND_API.G_FALSE,
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;