DBA Data[Home] [Help]

APPS.AMS_ACTMETRICS_ENGINE_PVT dependencies on DBMS_UTILITY

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 343: -- --bms_output.put_line(TO_CHAR(DBMS_UTILITY.get_time)||': '||

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;
346:
347: PROCEDURE write_error(p_procedure IN varchar2)

Line 2434: --write_msg('Per LOOP TIME: '|| (DBMS_UTILITY.get_time-l_start_time)/l_count);

2430:
2431: IF AMS_DEBUG_HIGH_ON THEN
2432: write_msg(L_API_NAME,'PARENT CHECK COMPLETE: PARENTS CREATED='||l_creates);
2433: END IF;
2434: --write_msg('Per LOOP TIME: '|| (DBMS_UTILITY.get_time-l_start_time)/l_count);
2435:
2436: --now, do bulk update
2437: IF l_act_metrics.count > 0 then
2438: l_first := l_act_metrics.first;

Line 3076: l_start_time := DBMS_UTILITY.get_time;

3072: LOOP
3073: IF AMS_DEBUG_HIGH_ON THEN
3074: write_msg(L_API_NAME,'PROCEDURE = '||l_function_list(l_index));
3075: END IF;
3076: l_start_time := DBMS_UTILITY.get_time;
3077: IF p_object_list.COUNT > 0 THEN
3078: FOR l_index2 IN p_object_list.first..p_object_list.last
3079: LOOP
3080: OPEN c_has_procedure(l_function_list(l_index),

Line 3100: || ((DBMS_UTILITY.get_time - l_start_time) / 100));

3096: x_return_status => l_return_status);
3097: END IF;
3098: IF AMS_DEBUG_HIGH_ON THEN
3099: write_msg(L_API_NAME,'elapse time (seconds)= '
3100: || ((DBMS_UTILITY.get_time - l_start_time) / 100));
3101: END IF;
3102: IF p_commit = FND_API.G_TRUE THEN
3103: COMMIT;
3104: IF AMS_DEBUG_MEDIUM_ON THEN