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 FND_MESSAGE

Line 73: FND_MESSAGE.Set_Name('FII',l_msg_name);

69: AND trx_date >= p_start_date;
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:

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 93: FND_MESSAGE.Set_Name('FII',l_msg_name);

89: Return 1;
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:

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 415: /*fnd_message.set_name('BIM','BIM_R_DROP_INDEXES');

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

Line 416: fnd_file.put_line(fnd_file.log,fnd_message.get);*/

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

Line 428: /*fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');

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');
432: INSERT /*+ append parallel */

Line 429: fnd_message.set_token('TABLE_NAME',l_table_name, FALSE);

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');
432: INSERT /*+ append parallel */
433: INTO BIM_I_MARKETING_FACTS_STG CDF (

Line 430: fnd_file.put_line(fnd_file.log,fnd_message.get);*/

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

Line 3011: /*fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');

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
3015: WHEN FND_API.G_EXC_ERROR THEN

Line 3012: fnd_message.set_token('program_name', 'Marketing first load', FALSE);

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
3015: WHEN FND_API.G_EXC_ERROR THEN
3016: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3013: fnd_file.put_line(fnd_file.log,fnd_message.get);*/

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
3015: WHEN FND_API.G_EXC_ERROR THEN
3016: x_return_status := FND_API.G_RET_STS_ERROR;
3017: -- Standard call to get message count and if count=1, get the message