APPS.BIM_MARKET_FACTS_PKG dependencies on AMS_UTILITY_PVT

Line 181: -- AMS_UTILITY_PVT.debug_message('Private API: ' || 'Running the populate procedure');

177: -- Initialize API return status to SUCCESS
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:

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

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

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;