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.AHL_AMP_WORKBENCH_PVT dependencies on AHL_DEBUG_PUB

Line 9: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');

5: -- Define Global CONSTANTS --
6: -----------------------------------------------------------------
7: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_AMP_WORKBENCH_PVT';
9: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
10: ------------------------------------
11: -- Common constants and variables --
12: ------------------------------------
13: l_log_current_level NUMBER := fnd_log.g_current_runtime_level;

Line 345: AHL_DEBUG_PUB.enable_debug;

341:
342: BEGIN
343: -- Enable Debug (optional)
344: IF ( G_DEBUG = 'Y' ) THEN
345: AHL_DEBUG_PUB.enable_debug;
346: END IF;
347:
348: -- ASCP last ran date
349: -- STHILAK ER #13799535 x_plan_date := TRUNC(sysdate);

Line 354: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : ASCP plan date = '|| x_plan_date );

350: SELECT MAX(ASCP_PLAN_DATE)
351: INTO x_plan_date
352: FROM AHL_DEPT_RESOURCE_CAPACITY;
353: IF G_DEBUG = 'Y' THEN
354: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : ASCP plan date = '|| x_plan_date );
355: END IF;
356:
357: -- set the start date
358: l_start_date := TRUNC(p_start_date);

Line 368: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : EXITING after reached NO. of records = '|| l_output_record_counter );

364: FOR cur_date IN c_working_dates(p_organization_id,p_department_id,l_start_date,p_no_of_days)
365: LOOP
366: IF l_output_record_counter >= ( p_no_of_days -1 ) THEN
367: IF G_DEBUG = 'Y' THEN
368: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : EXITING after reached NO. of records = '|| l_output_record_counter );
369: END IF;
370: EXIT; -- number fo records reached . SO exit from main loop. actually this condition is not needed. but added to handle cornercases
371: END IF;
372:

Line 376: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : reached NO. of records = '|| l_output_record_counter );

372:
373: l_output_record_counter := l_output_record_counter+1;
374: l_curr_date := cur_date.cal_date;
375: IF G_DEBUG = 'Y' THEN
376: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : reached NO. of records = '|| l_output_record_counter );
377: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : DATE = '|| l_curr_date );
378: END IF;
379:
380: -- set the date

Line 377: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : DATE = '|| l_curr_date );

373: l_output_record_counter := l_output_record_counter+1;
374: l_curr_date := cur_date.cal_date;
375: IF G_DEBUG = 'Y' THEN
376: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : reached NO. of records = '|| l_output_record_counter );
377: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : DATE = '|| l_curr_date );
378: END IF;
379:
380: -- set the date
381: p_x_resource_output(l_output_record_counter).on_date := l_curr_date;

Line 397: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : REq = '|| ' res id = ' || p_x_resource_input(l_index).resource_id || ' Date= ' || l_curr_date || ' req units = ' ||l_requirement);

393: l_requirement:=0;
394: END IF;
395:
396: IF G_DEBUG = 'Y' THEN
397: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : REq = '|| ' res id = ' || p_x_resource_input(l_index).resource_id || ' Date= ' || l_curr_date || ' req units = ' ||l_requirement);
398: END IF;
399:
400: -- get the resource avail
401: OPEN c_resource_avail(p_organization_id,p_department_id,p_x_resource_input(l_index).resource_id,l_curr_date);

Line 408: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : AVAIL= '|| ' res id = ' || p_x_resource_input(l_index).resource_id || ' Date= ' || l_curr_date || ' avail units = ' ||l_availability);

404: l_availability :=0;
405: END IF;
406:
407: IF G_DEBUG = 'Y' THEN
408: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : AVAIL= '|| ' res id = ' || p_x_resource_input(l_index).resource_id || ' Date= ' || l_curr_date || ' avail units = ' ||l_availability);
409: END IF;
410:
411: -- clacualte capacity
412: IF l_availability = 0 AND l_requirement = 0 THEN

Line 426: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : BEfore case index = '|| l_index );

422: l_capacity:= p_max_range;
423: END IF;
424:
425: IF G_DEBUG = 'Y' THEN
426: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : BEfore case index = '|| l_index );
427: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : BEfore case resource Id = '|| p_x_resource_input(l_index).resource_id );
428: END IF;
429: CASE (l_index )
430: WHEN 1 THEN

Line 427: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : BEfore case resource Id = '|| p_x_resource_input(l_index).resource_id );

423: END IF;
424:
425: IF G_DEBUG = 'Y' THEN
426: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : BEfore case index = '|| l_index );
427: AHL_DEBUG_PUB.debug( 'AHL_AMP_WORKBENCH_PVT' || '.' || 'GET_MC_GRAPH_DATA' || ' : BEfore case resource Id = '|| p_x_resource_input(l_index).resource_id );
428: END IF;
429: CASE (l_index )
430: WHEN 1 THEN
431: p_x_resource_output(l_output_record_counter).r1_capacity := l_capacity;