APPS.BIM_FUND_FACTS dependencies on AMS_UTILITY_PVT

Line 150: ams_utility_pvt.write_conc_log('error alter tablebalance:'||sqlerrm(sqlcode));

146: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fdsp_daily_facts noparallel';
147: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_fund_balance noparallel';
148: exception
149: WHEN OTHERS THEN
150: ams_utility_pvt.write_conc_log('error alter tablebalance:'||sqlerrm(sqlcode));
151: --dbms_output.put_line('error alter table balance'||sqlerrm(sqlcode));
152: END;
153:
154: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_fund_balance';

Line 239: ams_utility_pvt.write_conc_log('error updateing minimum balance'||sqlerrm(sqlcode));

235: AND a.week_date = l.week_date;
236:
237: EXCEPTION
238: WHEN OTHERS THEN
239: ams_utility_pvt.write_conc_log('error updateing minimum balance'||sqlerrm(sqlcode));
240: --dbms_output.put_line('error updateing minimum balance'||sqlerrm(sqlcode));
241: END;
242: END LOOP;
243:

Line 289: ams_utility_pvt.write_conc_log('error updateing balance in loop'||sqlerrm(sqlcode));

285: where fb.fund_id = x.fund_id
286: and fb.week_date = x.week_date ;
287: EXCEPTION
288: WHEN OTHERS THEN
289: ams_utility_pvt.write_conc_log('error updateing balance in loop'||sqlerrm(sqlcode));
290: --dbms_output.put_line('error updateing balance in loop'||sqlerrm(sqlcode));
291: END;
292: END LOOP;
293: fnd_message.set_name('BIM','BIM_R_PROC_END');

Line 298: ams_utility_pvt.write_conc_log('error updateing balance'||sqlerrm(sqlcode));

294: fnd_message.set_token('proc_name', 'UPDATE_BALANCE', FALSE);
295: fnd_file.put_line(fnd_file.log,fnd_message.get);
296: EXCEPTION
297: WHEN OTHERS THEN
298: ams_utility_pvt.write_conc_log('error updateing balance'||sqlerrm(sqlcode));
299: --dbms_output.put_line('error updateing balance'||sqlerrm(sqlcode));
300: --x_return_status := FND_API.G_RET_STS_ERROR;
301: --FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
302: --FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);

Line 642: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

638: FND_MSG_PUB.initialize;
639: END IF;
640:
641: -- Debug Message
642: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
643:
644: -- Initialize API RETURN status to SUCCESS
645: x_return_status := FND_API.G_RET_STS_SUCCESS;
646:

Line 716: ams_utility_pvt.write_conc_log('The current end date cannot be less than the last end date ');

712: END IF;
713: ELSE
714: IF l_last_update_date IS NOT NULL THEN
715: IF (p_end_date <= l_last_update_date) THEN
716: ams_utility_pvt.write_conc_log('The current end date cannot be less than the last end date ');
717: RAISE FND_API.g_exc_error;
718: END IF;
719: -- dbms_output.put_line('in sub load');
720:

Line 921: --AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
918: END IF;
919:
920: -- Debug Message
921: --AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
922:
923: -- Initialize API RETURN status to SUCCESS
924: x_return_status := FND_API.G_RET_STS_SUCCESS;
925:

Line 2554: --AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

2550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2551: END IF;
2552:
2553: -- Debug Message
2554: --AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2555:
2556: -- Initialize API RETURN status to SUCCESS
2557: x_return_status := FND_API.G_RET_STS_SUCCESS;
2558: