DBA Data[Home] [Help]

APPS.AMS_ACTMETRICS_ENGINE_PVT dependencies on AMS_UTILITY_PVT

Line 341: Ams_Utility_Pvt.Write_Conc_Log(TO_CHAR(DBMS_UTILITY.get_time)||': '||

337: PROCEDURE write_msg(p_procedure IN VARCHAR2, p_message IN VARCHAR2)
338: IS
339:
340: BEGIN
341: Ams_Utility_Pvt.Write_Conc_Log(TO_CHAR(DBMS_UTILITY.get_time)||': '||
342: G_PKG_NAME||'.'||p_procedure||': '||p_message);
343: -- --bms_output.put_line(TO_CHAR(DBMS_UTILITY.get_time)||': '||
344: -- G_PKG_NAME||'.'||p_procedure||': '||p_message);
345: END;

Line 4599: RAISE ams_utility_pvt.resource_locked;

4595: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
4596: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4597: elsif l_is_locked = FND_API.G_FALSE THEN
4598: -- the object needs to be lock by this process.
4599: RAISE ams_utility_pvt.resource_locked;
4600: END IF;
4601: END IF;
4602: ****** NOT REQUIRED *******/
4603:

Line 6509: ----Ams_Utility_Pvt.Write_Conc_log('Inserting entries ams_act_metrics_all_denorm') ;

6505:
6506: delete
6507: from ams_act_metrics_all_denorm;
6508:
6509: ----Ams_Utility_Pvt.Write_Conc_log('Inserting entries ams_act_metrics_all_denorm') ;
6510: l_metric_col_date := SYSDATE;
6511: --bms_output.put_line('inserting all entries with metric collection date : '||TO_CHAR(l_metric_col_date,'DD-MON-YYYY HH:MI:SS'));
6512: IF AMS_DEBUG_HIGH_ON THEN
6513: write_msg('populate_all','inserting all entries with metric collection date : '||TO_CHAR(l_metric_col_date,'DD-MON-YYYY HH:MI:SS'));

Line 6666: ----Ams_Utility_Pvt.Write_Conc_log('Inserting entries ams_act_metrics_all_denorm') ;

6662: BEGIN
6663:
6664: x_return_status := FND_API.G_RET_STS_SUCCESS;
6665:
6666: ----Ams_Utility_Pvt.Write_Conc_log('Inserting entries ams_act_metrics_all_denorm') ;
6667: l_metric_col_date := SYSDATE;
6668:
6669: IF AMS_DEBUG_HIGH_ON THEN
6670: write_msg('populate_incremental','max last run date : '||TO_CHAR(p_last_run_date,'DD-MON-YYYY HH:MI:SS'));

Line 6943: --Ams_Utility_Pvt.Write_Conc_log('Entered populate_metrics_denorm');

6939: BEGIN
6940: FND_MSG_PUB.initialize;
6941:
6942: --bms_output.put_line('Entered populate_metrics_denorm');
6943: --Ams_Utility_Pvt.Write_Conc_log('Entered populate_metrics_denorm');
6944: IF AMS_DEBUG_HIGH_ON THEN
6945: write_msg('populate_metrics_denorm','Entered populate_metrics_denorm');
6946: END IF;
6947:

Line 7005: ----Ams_Utility_Pvt.Write_Conc_log ;

7001: write_msg('populate_metrics_denorm','Done Refreshing the Materialized Views');
7002: END IF;
7003:
7004: --Write_log ;
7005: ----Ams_Utility_Pvt.Write_Conc_log ;
7006:
7007: IF(l_return_status = FND_API.G_RET_STS_SUCCESS)THEN
7008: retcode :=0;
7009: ELSE