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.CSF_GANTT_DATA_PKG dependencies on FND_LOG

Line 77: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);

73: g_off_time VARCHAR2(80);
74: G_PER_TIME VARCHAR2(80);
75: g_commute VARCHAR2(10);
76: g_debug VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
77: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
78:
79:
80: g_excl_travel varchar2(200);
81:

Line 146: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

142:
143: PROCEDURE debug(p_message VARCHAR2, p_module VARCHAR2, p_level NUMBER) IS
144: BEGIN
145: IF g_debug = 'Y' AND p_level >= g_debug_level THEN
146: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
147: THEN
148: fnd_log.string(p_level, 'csf.plsql.CSFGTPLB.' || p_module, p_message);
149: END IF;
150: END IF;

Line 148: fnd_log.string(p_level, 'csf.plsql.CSFGTPLB.' || p_module, p_message);

144: BEGIN
145: IF g_debug = 'Y' AND p_level >= g_debug_level THEN
146: IF ( p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
147: THEN
148: fnd_log.string(p_level, 'csf.plsql.CSFGTPLB.' || p_module, p_message);
149: END IF;
150: END IF;
151: END debug;
152:

Line 492: debug('Start of function get_tooltip_data_gantt' , 'get_tooltip_data_gantt', fnd_log.level_procedure);

488:
489: BEGIN
490:
491: IF l_debug THEN
492: debug('Start of function get_tooltip_data_gantt' , 'get_tooltip_data_gantt', fnd_log.level_procedure);
493: debug('Parameters : Task_Id '||p_task_id , 'get_tooltip_data_gantt', fnd_log.level_procedure);
494: debug(' Resource_Id '||p_resource_id , 'get_tooltip_data_gantt', fnd_log.level_procedure);
495: debug(' Resource_type '||p_resource_type , 'get_tooltip_data_gantt', fnd_log.level_procedure);
496: debug(' Start Date '||to_char(p_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);

Line 493: debug('Parameters : Task_Id '||p_task_id , 'get_tooltip_data_gantt', fnd_log.level_procedure);

489: BEGIN
490:
491: IF l_debug THEN
492: debug('Start of function get_tooltip_data_gantt' , 'get_tooltip_data_gantt', fnd_log.level_procedure);
493: debug('Parameters : Task_Id '||p_task_id , 'get_tooltip_data_gantt', fnd_log.level_procedure);
494: debug(' Resource_Id '||p_resource_id , 'get_tooltip_data_gantt', fnd_log.level_procedure);
495: debug(' Resource_type '||p_resource_type , 'get_tooltip_data_gantt', fnd_log.level_procedure);
496: debug(' Start Date '||to_char(p_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);
497: debug(' End Date '||to_char(p_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);

Line 494: debug(' Resource_Id '||p_resource_id , 'get_tooltip_data_gantt', fnd_log.level_procedure);

490:
491: IF l_debug THEN
492: debug('Start of function get_tooltip_data_gantt' , 'get_tooltip_data_gantt', fnd_log.level_procedure);
493: debug('Parameters : Task_Id '||p_task_id , 'get_tooltip_data_gantt', fnd_log.level_procedure);
494: debug(' Resource_Id '||p_resource_id , 'get_tooltip_data_gantt', fnd_log.level_procedure);
495: debug(' Resource_type '||p_resource_type , 'get_tooltip_data_gantt', fnd_log.level_procedure);
496: debug(' Start Date '||to_char(p_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);
497: debug(' End Date '||to_char(p_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);
498: debug(' Incident timezone code :'||p_inc_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);

Line 495: debug(' Resource_type '||p_resource_type , 'get_tooltip_data_gantt', fnd_log.level_procedure);

491: IF l_debug THEN
492: debug('Start of function get_tooltip_data_gantt' , 'get_tooltip_data_gantt', fnd_log.level_procedure);
493: debug('Parameters : Task_Id '||p_task_id , 'get_tooltip_data_gantt', fnd_log.level_procedure);
494: debug(' Resource_Id '||p_resource_id , 'get_tooltip_data_gantt', fnd_log.level_procedure);
495: debug(' Resource_type '||p_resource_type , 'get_tooltip_data_gantt', fnd_log.level_procedure);
496: debug(' Start Date '||to_char(p_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);
497: debug(' End Date '||to_char(p_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);
498: debug(' Incident timezone code :'||p_inc_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);
499: debug(' Server timezone code :'||p_server_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);

Line 496: debug(' Start Date '||to_char(p_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);

492: debug('Start of function get_tooltip_data_gantt' , 'get_tooltip_data_gantt', fnd_log.level_procedure);
493: debug('Parameters : Task_Id '||p_task_id , 'get_tooltip_data_gantt', fnd_log.level_procedure);
494: debug(' Resource_Id '||p_resource_id , 'get_tooltip_data_gantt', fnd_log.level_procedure);
495: debug(' Resource_type '||p_resource_type , 'get_tooltip_data_gantt', fnd_log.level_procedure);
496: debug(' Start Date '||to_char(p_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);
497: debug(' End Date '||to_char(p_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);
498: debug(' Incident timezone code :'||p_inc_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);
499: debug(' Server timezone code :'||p_server_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);
500: debug(' Client timezone code :'||p_client_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);

Line 497: debug(' End Date '||to_char(p_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);

493: debug('Parameters : Task_Id '||p_task_id , 'get_tooltip_data_gantt', fnd_log.level_procedure);
494: debug(' Resource_Id '||p_resource_id , 'get_tooltip_data_gantt', fnd_log.level_procedure);
495: debug(' Resource_type '||p_resource_type , 'get_tooltip_data_gantt', fnd_log.level_procedure);
496: debug(' Start Date '||to_char(p_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);
497: debug(' End Date '||to_char(p_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);
498: debug(' Incident timezone code :'||p_inc_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);
499: debug(' Server timezone code :'||p_server_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);
500: debug(' Client timezone code :'||p_client_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);
501:

Line 498: debug(' Incident timezone code :'||p_inc_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);

494: debug(' Resource_Id '||p_resource_id , 'get_tooltip_data_gantt', fnd_log.level_procedure);
495: debug(' Resource_type '||p_resource_type , 'get_tooltip_data_gantt', fnd_log.level_procedure);
496: debug(' Start Date '||to_char(p_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);
497: debug(' End Date '||to_char(p_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);
498: debug(' Incident timezone code :'||p_inc_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);
499: debug(' Server timezone code :'||p_server_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);
500: debug(' Client timezone code :'||p_client_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);
501:
502: END IF;

Line 499: debug(' Server timezone code :'||p_server_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);

495: debug(' Resource_type '||p_resource_type , 'get_tooltip_data_gantt', fnd_log.level_procedure);
496: debug(' Start Date '||to_char(p_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);
497: debug(' End Date '||to_char(p_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);
498: debug(' Incident timezone code :'||p_inc_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);
499: debug(' Server timezone code :'||p_server_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);
500: debug(' Client timezone code :'||p_client_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);
501:
502: END IF;
503:

Line 500: debug(' Client timezone code :'||p_client_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);

496: debug(' Start Date '||to_char(p_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);
497: debug(' End Date '||to_char(p_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_procedure);
498: debug(' Incident timezone code :'||p_inc_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);
499: debug(' Server timezone code :'||p_server_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);
500: debug(' Client timezone code :'||p_client_tz_code , 'get_tooltip_data_gantt', fnd_log.level_procedure);
501:
502: END IF;
503:
504:

Line 509: debug(' Territory Id :'||l_territory , 'get_tooltip_data_gantt', fnd_log.level_statement);

505: open c_terr;
506: fetch c_terr into l_territory;
507: close c_terr;
508: IF l_debug THEN
509: debug(' Territory Id :'||l_territory , 'get_tooltip_data_gantt', fnd_log.level_statement);
510: END IF;
511: g_excl_travel := csr_scheduler_pub.get_sch_parameter_value( 'spCommuteExcludedTime'
512: , fnd_global.resp_appl_id
513: , fnd_global.resp_id

Line 529: debug(' Excluded Travel time :'||g_excl_travel , 'get_tooltip_data_gantt', fnd_log.level_statement);

525: , p_resource_id
526: );
527:
528: IF l_debug THEN
529: debug(' Excluded Travel time :'||g_excl_travel , 'get_tooltip_data_gantt', fnd_log.level_statement);
530: debug(' Commute :'||g_commute , 'get_tooltip_data_gantt', fnd_log.level_statement);
531: END IF;
532:
533: OPEN c_task;

Line 530: debug(' Commute :'||g_commute , 'get_tooltip_data_gantt', fnd_log.level_statement);

526: );
527:
528: IF l_debug THEN
529: debug(' Excluded Travel time :'||g_excl_travel , 'get_tooltip_data_gantt', fnd_log.level_statement);
530: debug(' Commute :'||g_commute , 'get_tooltip_data_gantt', fnd_log.level_statement);
531: END IF;
532:
533: OPEN c_task;
534: FETCH c_task INTO l_task_rec;

Line 538: debug(' Cursor c_task raised No Data Found exception', 'get_tooltip_data_gantt', fnd_log.level_statement);

534: FETCH c_task INTO l_task_rec;
535: IF c_task%NOTFOUND THEN
536: CLOSE c_task;
537: IF l_debug THEN
538: debug(' Cursor c_task raised No Data Found exception', 'get_tooltip_data_gantt', fnd_log.level_statement);
539: END IF;
540: RAISE NO_DATA_FOUND;
541: END IF;
542: l_task_tbl := jtf_number_table();

Line 549: debug(' Object capacity id :'||l_capacity, 'get_tooltip_data_gantt', fnd_log.level_statement);

545: FETCH c_trip into l_capacity;
546: CLOSE c_trip;
547:
548: IF l_debug THEN
549: debug(' Object capacity id :'||l_capacity, 'get_tooltip_data_gantt', fnd_log.level_statement);
550: END IF;
551:
552: OPEN c_tasks(l_capacity);
553: FETCH c_tasks BULK COLLECT INTO l_task_tbl;

Line 564: debug(' First Task in the trip :'||l_first, 'get_tooltip_data_gantt', fnd_log.level_statement);

560: l_first := l_task_tbl(i);
561: l_last := l_task_tbl(j);
562:
563: IF l_debug THEN
564: debug(' First Task in the trip :'||l_first, 'get_tooltip_data_gantt', fnd_log.level_statement);
565: debug(' last Task in the trip :'||l_last, 'get_tooltip_data_gantt', fnd_log.level_statement);
566: END IF;
567: END IF;
568:

Line 565: debug(' last Task in the trip :'||l_last, 'get_tooltip_data_gantt', fnd_log.level_statement);

561: l_last := l_task_tbl(j);
562:
563: IF l_debug THEN
564: debug(' First Task in the trip :'||l_first, 'get_tooltip_data_gantt', fnd_log.level_statement);
565: debug(' last Task in the trip :'||l_last, 'get_tooltip_data_gantt', fnd_log.level_statement);
566: END IF;
567: END IF;
568:
569: open c_arr;

Line 574: debug(' Task Type Id:'||l_task_rec.task_type_id, 'get_tooltip_data_gantt', fnd_log.level_statement);

570: fetch c_arr into l_arr;
571: close c_arr;
572:
573: IF l_debug THEN
574: debug(' Task Type Id:'||l_task_rec.task_type_id, 'get_tooltip_data_gantt', fnd_log.level_statement);
575: END IF;
576:
577: IF l_task_rec.task_type_id NOT IN(20, 21)
578: THEN

Line 583: debug(' Planned Effort :'||l_planned_effort, 'get_tooltip_data_gantt', fnd_log.level_statement);

579: l_planned_effort := l_task_rec.plan_effort;
580: l_actual_effort := l_task_rec.act_effort;
581:
582: IF l_debug THEN
583: debug(' Planned Effort :'||l_planned_effort, 'get_tooltip_data_gantt', fnd_log.level_statement);
584: debug(' Actual Effort :'||l_actual_effort, 'get_tooltip_data_gantt', fnd_log.level_statement);
585: END IF;
586:
587: IF l_debug THEN

Line 584: debug(' Actual Effort :'||l_actual_effort, 'get_tooltip_data_gantt', fnd_log.level_statement);

580: l_actual_effort := l_task_rec.act_effort;
581:
582: IF l_debug THEN
583: debug(' Planned Effort :'||l_planned_effort, 'get_tooltip_data_gantt', fnd_log.level_statement);
584: debug(' Actual Effort :'||l_actual_effort, 'get_tooltip_data_gantt', fnd_log.level_statement);
585: END IF;
586:
587: IF l_debug THEN
588: debug(' Scheduled Start Date :'||l_task_rec.scheduled_start_date, 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 588: debug(' Scheduled Start Date :'||l_task_rec.scheduled_start_date, 'get_tooltip_data_gantt', fnd_log.level_statement);

584: debug(' Actual Effort :'||l_actual_effort, 'get_tooltip_data_gantt', fnd_log.level_statement);
585: END IF;
586:
587: IF l_debug THEN
588: debug(' Scheduled Start Date :'||l_task_rec.scheduled_start_date, 'get_tooltip_data_gantt', fnd_log.level_statement);
589: debug(' Scheduled End Date :'||l_task_rec.scheduled_end_date, 'get_tooltip_data_gantt', fnd_log.level_statement);
590: debug(' Actual Start Date :'||l_task_rec.actual_start_date, 'get_tooltip_data_gantt', fnd_log.level_statement);
591: END IF;
592:

Line 589: debug(' Scheduled End Date :'||l_task_rec.scheduled_end_date, 'get_tooltip_data_gantt', fnd_log.level_statement);

585: END IF;
586:
587: IF l_debug THEN
588: debug(' Scheduled Start Date :'||l_task_rec.scheduled_start_date, 'get_tooltip_data_gantt', fnd_log.level_statement);
589: debug(' Scheduled End Date :'||l_task_rec.scheduled_end_date, 'get_tooltip_data_gantt', fnd_log.level_statement);
590: debug(' Actual Start Date :'||l_task_rec.actual_start_date, 'get_tooltip_data_gantt', fnd_log.level_statement);
591: END IF;
592:
593: IF l_task_rec.scheduled_start_date <> l_task_rec.scheduled_end_date

Line 590: debug(' Actual Start Date :'||l_task_rec.actual_start_date, 'get_tooltip_data_gantt', fnd_log.level_statement);

586:
587: IF l_debug THEN
588: debug(' Scheduled Start Date :'||l_task_rec.scheduled_start_date, 'get_tooltip_data_gantt', fnd_log.level_statement);
589: debug(' Scheduled End Date :'||l_task_rec.scheduled_end_date, 'get_tooltip_data_gantt', fnd_log.level_statement);
590: debug(' Actual Start Date :'||l_task_rec.actual_start_date, 'get_tooltip_data_gantt', fnd_log.level_statement);
591: END IF;
592:
593: IF l_task_rec.scheduled_start_date <> l_task_rec.scheduled_end_date
594: THEN

Line 602: debug(' Cursor c_task raised No Data found exception becoz of actual start date is null', 'get_tooltip_data_gantt', fnd_log.level_statement);

598: AND l_task_rec.actual_start_date is null
599: THEN
600: CLOSE c_task;
601: IF l_debug THEN
602: debug(' Cursor c_task raised No Data found exception becoz of actual start date is null', 'get_tooltip_data_gantt', fnd_log.level_statement);
603: END IF;
604: RAISE NO_DATA_FOUND;
605: END IF;
606: END IF;

Line 608: debug(' Source Object Id: '||l_task_rec.source_object_id, 'get_tooltip_data_gantt', fnd_log.level_statement);

604: RAISE NO_DATA_FOUND;
605: END IF;
606: END IF;
607: IF l_debug THEN
608: debug(' Source Object Id: '||l_task_rec.source_object_id, 'get_tooltip_data_gantt', fnd_log.level_statement);
609: END IF;
610: IF ((l_task_rec.task_type_id NOT IN(20, 21)) and (l_task_rec.source_object_type_code<>'TASK'))
611: THEN
612: OPEN c_sr(l_task_rec.source_object_id);

Line 616: debug(' Customer Product Id: '|| l_sr_rec.customer_product_id, 'get_tooltip_data_gantt', fnd_log.level_statement);

612: OPEN c_sr(l_task_rec.source_object_id);
613: FETCH c_sr INTO l_sr_rec;
614: IF l_sr_rec.customer_product_id IS NOT NULL THEN
615: IF l_debug THEN
616: debug(' Customer Product Id: '|| l_sr_rec.customer_product_id, 'get_tooltip_data_gantt', fnd_log.level_statement);
617: END IF;
618: OPEN c_ib(l_sr_rec.customer_product_id);
619: FETCH c_ib INTO l_ib_rec;
620: CLOSE c_ib;

Line 626: debug(' Serial Number: '|| l_ib_rec.serial_number, 'get_tooltip_data_gantt', fnd_log.level_statement);

622: l_ib_rec.serial_number := l_sr_rec.current_serial_number;
623: l_ib_rec.lot_number := NULL; -- not yet supported
624:
625: IF l_debug THEN
626: debug(' Serial Number: '|| l_ib_rec.serial_number, 'get_tooltip_data_gantt', fnd_log.level_statement);
627: END IF;
628: END IF;
629: END IF;
630: END IF;

Line 633: debug(' Party Name : '||l_rec.incident_customer_name , 'get_tooltip_data_gantt', fnd_log.level_statement);

629: END IF;
630: END IF;
631: l_rec.incident_customer_name := l_task_rec.party_name;
632: IF l_debug THEN
633: debug(' Party Name : '||l_rec.incident_customer_name , 'get_tooltip_data_gantt', fnd_log.level_statement);
634: END IF;
635:
636: --begin addition for bug 5674408
637: IF (LENGTH(NVL(l_task_rec.party_name, 0)) > 80)

Line 641: debug(' No. of lines : '||l_lines , 'get_tooltip_data_gantt', fnd_log.level_statement);

637: IF (LENGTH(NVL(l_task_rec.party_name, 0)) > 80)
638: THEN
639: l_lines := ceil(length(l_task_rec.party_name)/80) - 1;
640: IF l_debug THEN
641: debug(' No. of lines : '||l_lines , 'get_tooltip_data_gantt', fnd_log.level_statement);
642: END IF;
643: l_rec.incident_customer_name := null;
644:
645: for i in 1..l_lines

Line 650: debug(' Incident Customer name : '||l_rec.incident_customer_name , 'get_tooltip_data_gantt', fnd_log.level_statement);

646: loop
647: l_rec.incident_customer_name := l_rec.incident_customer_name || SUBSTRB (l_task_rec.party_name, 1, 80) || fnd_global.local_chr (10);
648: l_task_rec.party_name := substrb(l_task_rec.party_name,81);
649: IF l_debug THEN
650: debug(' Incident Customer name : '||l_rec.incident_customer_name , 'get_tooltip_data_gantt', fnd_log.level_statement);
651: debug(' Party Name : '||l_task_rec.party_name , 'get_tooltip_data_gantt', fnd_log.level_statement);
652: END IF;
653: end loop;
654:

Line 651: debug(' Party Name : '||l_task_rec.party_name , 'get_tooltip_data_gantt', fnd_log.level_statement);

647: l_rec.incident_customer_name := l_rec.incident_customer_name || SUBSTRB (l_task_rec.party_name, 1, 80) || fnd_global.local_chr (10);
648: l_task_rec.party_name := substrb(l_task_rec.party_name,81);
649: IF l_debug THEN
650: debug(' Incident Customer name : '||l_rec.incident_customer_name , 'get_tooltip_data_gantt', fnd_log.level_statement);
651: debug(' Party Name : '||l_task_rec.party_name , 'get_tooltip_data_gantt', fnd_log.level_statement);
652: END IF;
653: end loop;
654:
655: l_rec.incident_customer_name := l_rec.incident_customer_name || SUBSTRB (l_task_rec.party_name, 1);

Line 657: debug(' Incident Customer name after the loop : '||l_rec.incident_customer_name , 'get_tooltip_data_gantt', fnd_log.level_statement);

653: end loop;
654:
655: l_rec.incident_customer_name := l_rec.incident_customer_name || SUBSTRB (l_task_rec.party_name, 1);
656: IF l_debug THEN
657: debug(' Incident Customer name after the loop : '||l_rec.incident_customer_name , 'get_tooltip_data_gantt', fnd_log.level_statement);
658: END IF;
659: END IF;
660: --end addition for bug 5674408
661:

Line 669: debug(' Resource Timezone : '||l_Res_TimeZone_id , 'get_tooltip_data_gantt', fnd_log.level_statement);

665: Open C_Res_TimeZone ;
666: Fetch C_Res_TimeZone into l_Res_TimeZone_id;
667: Close C_Res_TimeZone ;
668: IF l_debug THEN
669: debug(' Resource Timezone : '||l_Res_TimeZone_id , 'get_tooltip_data_gantt', fnd_log.level_statement);
670: END IF;
671: if l_Res_TimeZone_id is not null
672: then
673: Open c_res_tz ;

Line 677: debug(' Resource Timezone code : '||l_res_tz_cd , 'get_tooltip_data_gantt', fnd_log.level_statement);

673: Open c_res_tz ;
674: Fetch c_res_tz into l_res_tz_cd,l_rs_tz_desc;
675: Close c_res_tz ;
676: IF l_debug THEN
677: debug(' Resource Timezone code : '||l_res_tz_cd , 'get_tooltip_data_gantt', fnd_log.level_statement);
678: debug(' Resource Timezone Description : '||l_rs_tz_desc , 'get_tooltip_data_gantt', fnd_log.level_statement);
679: END IF;
680: end if;
681: if p_timezone_enb

Line 678: debug(' Resource Timezone Description : '||l_rs_tz_desc , 'get_tooltip_data_gantt', fnd_log.level_statement);

674: Fetch c_res_tz into l_res_tz_cd,l_rs_tz_desc;
675: Close c_res_tz ;
676: IF l_debug THEN
677: debug(' Resource Timezone code : '||l_res_tz_cd , 'get_tooltip_data_gantt', fnd_log.level_statement);
678: debug(' Resource Timezone Description : '||l_rs_tz_desc , 'get_tooltip_data_gantt', fnd_log.level_statement);
679: END IF;
680: end if;
681: if p_timezone_enb
682: then

Line 691: debug(' If timezone is enabled and resource time zone exists then : ' , 'get_tooltip_data_gantt', fnd_log.level_statement);

687: l_ic_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,l_res_tz_cd);
688: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_res_tz_cd);
689: l_tz_desc :=l_rs_tz_desc;
690: IF l_debug THEN
691: debug(' If timezone is enabled and resource time zone exists then : ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
692: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
693: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
694: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
695: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 692: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

688: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_res_tz_cd);
689: l_tz_desc :=l_rs_tz_desc;
690: IF l_debug THEN
691: debug(' If timezone is enabled and resource time zone exists then : ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
692: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
693: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
694: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
695: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
696: END IF;

Line 693: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

689: l_tz_desc :=l_rs_tz_desc;
690: IF l_debug THEN
691: debug(' If timezone is enabled and resource time zone exists then : ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
692: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
693: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
694: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
695: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
696: END IF;
697: end if;

Line 694: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

690: IF l_debug THEN
691: debug(' If timezone is enabled and resource time zone exists then : ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
692: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
693: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
694: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
695: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
696: END IF;
697: end if;
698: else

Line 695: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

691: debug(' If timezone is enabled and resource time zone exists then : ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
692: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
693: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
694: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
695: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
696: END IF;
697: end if;
698: else
699: l_ic_planned_start_date :=l_task_rec.planned_start_date;

Line 704: debug(' If timezone is note enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);

700: l_ic_planned_end_date :=l_task_rec.planned_end_date;
701: l_ic_scheduled_start_date :=p_start_date;
702: l_ic_scheduled_end_date :=p_end_date;
703: IF l_debug THEN
704: debug(' If timezone is note enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
705: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
706: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
707: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
708: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 705: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

701: l_ic_scheduled_start_date :=p_start_date;
702: l_ic_scheduled_end_date :=p_end_date;
703: IF l_debug THEN
704: debug(' If timezone is note enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
705: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
706: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
707: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
708: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
709: END IF;

Line 706: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

702: l_ic_scheduled_end_date :=p_end_date;
703: IF l_debug THEN
704: debug(' If timezone is note enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
705: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
706: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
707: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
708: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
709: END IF;
710: end if;

Line 707: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

703: IF l_debug THEN
704: debug(' If timezone is note enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
705: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
706: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
707: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
708: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
709: END IF;
710: end if;
711: END IF;

Line 708: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

704: debug(' If timezone is note enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
705: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
706: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
707: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
708: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
709: END IF;
710: end if;
711: END IF;
712:

Line 725: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);

721: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(l_task_rec.scheduled_end_date,p_server_tz_code,p_client_tz_code);
722: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
723: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
724: IF l_debug THEN
725: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
726: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
727: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
728: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
729: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 726: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

722: l_dc_actual_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
723: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
724: IF l_debug THEN
725: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
726: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
727: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
728: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
729: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
730: debug(' l_dc_actual_start_date : '||to_char(l_dc_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 727: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

723: l_dc_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
724: IF l_debug THEN
725: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
726: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
727: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
728: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
729: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
730: debug(' l_dc_actual_start_date : '||to_char(l_dc_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
731: debug(' l_dc_actual_end_date : '||to_char(l_dc_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 728: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

724: IF l_debug THEN
725: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
726: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
727: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
728: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
729: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
730: debug(' l_dc_actual_start_date : '||to_char(l_dc_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
731: debug(' l_dc_actual_end_date : '||to_char(l_dc_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
732: END IF;

Line 729: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

725: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
726: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
727: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
728: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
729: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
730: debug(' l_dc_actual_start_date : '||to_char(l_dc_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
731: debug(' l_dc_actual_end_date : '||to_char(l_dc_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
732: END IF;
733: else

Line 730: debug(' l_dc_actual_start_date : '||to_char(l_dc_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

726: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
727: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
728: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
729: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
730: debug(' l_dc_actual_start_date : '||to_char(l_dc_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
731: debug(' l_dc_actual_end_date : '||to_char(l_dc_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
732: END IF;
733: else
734: l_dc_planned_start_date :=l_task_rec.planned_start_date;

Line 731: debug(' l_dc_actual_end_date : '||to_char(l_dc_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

727: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
728: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
729: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
730: debug(' l_dc_actual_start_date : '||to_char(l_dc_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
731: debug(' l_dc_actual_end_date : '||to_char(l_dc_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
732: END IF;
733: else
734: l_dc_planned_start_date :=l_task_rec.planned_start_date;
735: l_dc_planned_end_date :=l_task_rec.planned_end_date;

Line 741: debug(' Incident timezone code is not UTZ and timezone is not enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);

737: l_dc_scheduled_end_date :=l_task_rec.scheduled_end_date;
738: l_dc_actual_start_date :=p_start_date;
739: l_dc_actual_end_date :=p_end_date;
740: IF l_debug THEN
741: debug(' Incident timezone code is not UTZ and timezone is not enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
742: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
743: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
744: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
745: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 742: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);

738: l_dc_actual_start_date :=p_start_date;
739: l_dc_actual_end_date :=p_end_date;
740: IF l_debug THEN
741: debug(' Incident timezone code is not UTZ and timezone is not enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
742: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
743: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
744: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
745: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
746: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 743: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

739: l_dc_actual_end_date :=p_end_date;
740: IF l_debug THEN
741: debug(' Incident timezone code is not UTZ and timezone is not enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
742: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
743: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
744: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
745: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
746: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
747: debug(' l_dc_actual_start_date : '||to_char(l_dc_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 744: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

740: IF l_debug THEN
741: debug(' Incident timezone code is not UTZ and timezone is not enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
742: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
743: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
744: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
745: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
746: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
747: debug(' l_dc_actual_start_date : '||to_char(l_dc_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
748: debug(' l_dc_actual_end_date : '||to_char(l_dc_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 745: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

741: debug(' Incident timezone code is not UTZ and timezone is not enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
742: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
743: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
744: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
745: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
746: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
747: debug(' l_dc_actual_start_date : '||to_char(l_dc_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
748: debug(' l_dc_actual_end_date : '||to_char(l_dc_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
749: END IF;

Line 746: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

742: debug(' Actual start date : '||l_task_rec.actual_start_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
743: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
744: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
745: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
746: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
747: debug(' l_dc_actual_start_date : '||to_char(l_dc_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
748: debug(' l_dc_actual_end_date : '||to_char(l_dc_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
749: END IF;
750: end if;

Line 747: debug(' l_dc_actual_start_date : '||to_char(l_dc_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

743: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
744: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
745: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
746: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
747: debug(' l_dc_actual_start_date : '||to_char(l_dc_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
748: debug(' l_dc_actual_end_date : '||to_char(l_dc_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
749: END IF;
750: end if;
751: l_actual_start_date :=l_dc_actual_start_date;

Line 748: debug(' l_dc_actual_end_date : '||to_char(l_dc_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

744: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
745: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
746: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
747: debug(' l_dc_actual_start_date : '||to_char(l_dc_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
748: debug(' l_dc_actual_end_date : '||to_char(l_dc_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
749: END IF;
750: end if;
751: l_actual_start_date :=l_dc_actual_start_date;
752: if l_task_rec.ic_tz_code is not null and p_timezone_enb

Line 763: debug(' if l_task_rec.ic_tz_code is not null and p_timezone_enb then the values : ' , 'get_tooltip_data_gantt', fnd_log.level_statement);

759: l_ic_actual_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
760: l_actual_start_date :=l_ic_actual_start_date;
761: l_tz_desc :=l_task_rec.tz_desc;
762: IF l_debug THEN
763: debug(' if l_task_rec.ic_tz_code is not null and p_timezone_enb then the values : ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
764:
765: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
766: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
767: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 765: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

761: l_tz_desc :=l_task_rec.tz_desc;
762: IF l_debug THEN
763: debug(' if l_task_rec.ic_tz_code is not null and p_timezone_enb then the values : ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
764:
765: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
766: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
767: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
768: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
769: debug(' l_ic_actual_start_date : '||to_char(l_ic_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 766: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

762: IF l_debug THEN
763: debug(' if l_task_rec.ic_tz_code is not null and p_timezone_enb then the values : ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
764:
765: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
766: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
767: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
768: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
769: debug(' l_ic_actual_start_date : '||to_char(l_ic_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
770: debug(' l_ic_actual_end_date : '||to_char(l_ic_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 767: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

763: debug(' if l_task_rec.ic_tz_code is not null and p_timezone_enb then the values : ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
764:
765: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
766: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
767: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
768: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
769: debug(' l_ic_actual_start_date : '||to_char(l_ic_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
770: debug(' l_ic_actual_end_date : '||to_char(l_ic_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
771: END IF;

Line 768: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

764:
765: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
766: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
767: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
768: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
769: debug(' l_ic_actual_start_date : '||to_char(l_ic_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
770: debug(' l_ic_actual_end_date : '||to_char(l_ic_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
771: END IF;
772: end if;

Line 769: debug(' l_ic_actual_start_date : '||to_char(l_ic_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

765: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
766: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
767: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
768: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
769: debug(' l_ic_actual_start_date : '||to_char(l_ic_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
770: debug(' l_ic_actual_end_date : '||to_char(l_ic_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
771: END IF;
772: end if;
773: IF l_debug THEN

Line 770: debug(' l_ic_actual_end_date : '||to_char(l_ic_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

766: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
767: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
768: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
769: debug(' l_ic_actual_start_date : '||to_char(l_ic_actual_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
770: debug(' l_ic_actual_end_date : '||to_char(l_ic_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
771: END IF;
772: end if;
773: IF l_debug THEN
774: debug(' g_uom_minutes : '||g_uom_minutes , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 774: debug(' g_uom_minutes : '||g_uom_minutes , 'get_tooltip_data_gantt', fnd_log.level_statement);

770: debug(' l_ic_actual_end_date : '||to_char(l_ic_actual_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
771: END IF;
772: end if;
773: IF l_debug THEN
774: debug(' g_uom_minutes : '||g_uom_minutes , 'get_tooltip_data_gantt', fnd_log.level_statement);
775: END IF;
776: l_rec.departure_time:=
777: l_actual_start_date - (
778: inv_convert.inv_um_convert(

Line 792: debug(' Departure Time : '||to_char(l_rec.departure_time,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

788: );
789:
790:
791: IF l_debug THEN
792: debug(' Departure Time : '||to_char(l_rec.departure_time,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
793: END IF;
794: OPEN c_uom(NVL(l_task_rec.actual_travel_duration_uom, g_uom_minutes));
795: FETCH c_uom INTO l_uom;
796: IF c_uom%NOTFOUND THEN

Line 802: debug(' l_uom : '||l_uom , 'get_tooltip_data_gantt', fnd_log.level_statement);

798: END IF;
799: CLOSE c_uom;
800:
801: IF l_debug THEN
802: debug(' l_uom : '||l_uom , 'get_tooltip_data_gantt', fnd_log.level_statement);
803: END IF;
804:
805: l_rec.travel_time := NVL(l_task_rec.actual_travel_duration, 0) || ' ' || l_uom;
806: IF l_debug THEN

Line 807: debug(' Travel Time : '||l_rec.travel_time , 'get_tooltip_data_gantt', fnd_log.level_statement);

803: END IF;
804:
805: l_rec.travel_time := NVL(l_task_rec.actual_travel_duration, 0) || ' ' || l_uom;
806: IF l_debug THEN
807: debug(' Travel Time : '||l_rec.travel_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
808: END IF;
809: IF l_debug THEN
810: debug(' Arrival Task Id : '||l_arr.task_id , 'get_tooltip_data_gantt', fnd_log.level_statement);
811: debug(' Actual Travel Duration : '||l_arr.actual_travel_duration , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 810: debug(' Arrival Task Id : '||l_arr.task_id , 'get_tooltip_data_gantt', fnd_log.level_statement);

806: IF l_debug THEN
807: debug(' Travel Time : '||l_rec.travel_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
808: END IF;
809: IF l_debug THEN
810: debug(' Arrival Task Id : '||l_arr.task_id , 'get_tooltip_data_gantt', fnd_log.level_statement);
811: debug(' Actual Travel Duration : '||l_arr.actual_travel_duration , 'get_tooltip_data_gantt', fnd_log.level_statement);
812: END IF;
813: IF p_task_id = l_first
814: OR p_task_id = l_arr.task_id

Line 811: debug(' Actual Travel Duration : '||l_arr.actual_travel_duration , 'get_tooltip_data_gantt', fnd_log.level_statement);

807: debug(' Travel Time : '||l_rec.travel_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
808: END IF;
809: IF l_debug THEN
810: debug(' Arrival Task Id : '||l_arr.task_id , 'get_tooltip_data_gantt', fnd_log.level_statement);
811: debug(' Actual Travel Duration : '||l_arr.actual_travel_duration , 'get_tooltip_data_gantt', fnd_log.level_statement);
812: END IF;
813: IF p_task_id = l_first
814: OR p_task_id = l_arr.task_id
815: OR p_task_id = l_last

Line 845: debug(' Official Travel time : '||l_off_time , 'get_tooltip_data_gantt', fnd_log.level_statement);

841: end if;
842: END IF;
843: END IF;
844: IF l_debug THEN
845: debug(' Official Travel time : '||l_off_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
846: debug(' Personal Travel Time : '||l_per_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
847: END IF;
848: ELSE
849: if p_inc_tz_code ='UTZ'and p_timezone_enb

Line 846: debug(' Personal Travel Time : '||l_per_time , 'get_tooltip_data_gantt', fnd_log.level_statement);

842: END IF;
843: END IF;
844: IF l_debug THEN
845: debug(' Official Travel time : '||l_off_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
846: debug(' Personal Travel Time : '||l_per_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
847: END IF;
848: ELSE
849: if p_inc_tz_code ='UTZ'and p_timezone_enb
850: then

Line 856: debug(' 1. Incident tz code is UTZ and time zone enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);

852: l_dc_planned_end_date :=fnd_date.adjust_datetime(l_task_rec.planned_end_date,p_server_tz_code,p_client_tz_code);
853: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
854: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
855: IF l_debug THEN
856: debug(' 1. Incident tz code is UTZ and time zone enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
857: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
858: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
859: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
860: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 857: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

853: l_dc_scheduled_start_date :=fnd_date.adjust_datetime(p_start_date,p_server_tz_code,p_client_tz_code);
854: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
855: IF l_debug THEN
856: debug(' 1. Incident tz code is UTZ and time zone enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
857: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
858: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
859: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
860: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
861:

Line 858: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

854: l_dc_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,p_client_tz_code);
855: IF l_debug THEN
856: debug(' 1. Incident tz code is UTZ and time zone enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
857: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
858: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
859: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
860: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
861:
862: END IF;

Line 859: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

855: IF l_debug THEN
856: debug(' 1. Incident tz code is UTZ and time zone enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
857: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
858: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
859: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
860: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
861:
862: END IF;
863: else

Line 860: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

856: debug(' 1. Incident tz code is UTZ and time zone enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
857: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
858: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
859: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
860: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
861:
862: END IF;
863: else
864: l_dc_planned_start_date :=l_task_rec.planned_start_date;

Line 869: debug(' 2. Incident tz code is not UTZ and time zone not enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);

865: l_dc_planned_end_date :=l_task_rec.planned_end_date;
866: l_dc_scheduled_start_date :=p_start_date;
867: l_dc_scheduled_end_date :=p_end_date;
868: IF l_debug THEN
869: debug(' 2. Incident tz code is not UTZ and time zone not enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
870: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
871: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
872: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
873: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 870: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

866: l_dc_scheduled_start_date :=p_start_date;
867: l_dc_scheduled_end_date :=p_end_date;
868: IF l_debug THEN
869: debug(' 2. Incident tz code is not UTZ and time zone not enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
870: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
871: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
872: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
873: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
874:

Line 871: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

867: l_dc_scheduled_end_date :=p_end_date;
868: IF l_debug THEN
869: debug(' 2. Incident tz code is not UTZ and time zone not enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
870: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
871: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
872: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
873: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
874:
875: END IF;

Line 872: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

868: IF l_debug THEN
869: debug(' 2. Incident tz code is not UTZ and time zone not enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
870: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
871: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
872: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
873: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
874:
875: END IF;
876: end if;

Line 873: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

869: debug(' 2. Incident tz code is not UTZ and time zone not enabled ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
870: debug(' l_dc_planned_start_date : '||to_char(l_dc_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
871: debug(' l_dc_planned_end_date : '||to_char(l_dc_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
872: debug(' l_dc_scheduled_start_date : '||to_char(l_dc_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
873: debug(' l_dc_scheduled_end_date : '||to_char(l_dc_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
874:
875: END IF;
876: end if;
877: l_scheduled_start_date :=l_dc_scheduled_start_date;

Line 887: debug(' if l_task_rec.ic_tz_code is not null and p_timezone_enb and l_task_rec.task_type_id not in (20, 21) then: ' , 'get_tooltip_data_gantt', fnd_log.level_statement);

883: l_ic_scheduled_end_date :=fnd_date.adjust_datetime(p_end_date,p_server_tz_code,l_task_rec.ic_tz_code);
884: l_scheduled_start_date :=l_ic_scheduled_start_date;
885: l_tz_desc :=l_task_rec.tz_desc;
886: IF l_debug THEN
887: debug(' if l_task_rec.ic_tz_code is not null and p_timezone_enb and l_task_rec.task_type_id not in (20, 21) then: ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
888: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
889: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
890: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
891: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 888: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

884: l_scheduled_start_date :=l_ic_scheduled_start_date;
885: l_tz_desc :=l_task_rec.tz_desc;
886: IF l_debug THEN
887: debug(' if l_task_rec.ic_tz_code is not null and p_timezone_enb and l_task_rec.task_type_id not in (20, 21) then: ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
888: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
889: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
890: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
891: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
892:

Line 889: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

885: l_tz_desc :=l_task_rec.tz_desc;
886: IF l_debug THEN
887: debug(' if l_task_rec.ic_tz_code is not null and p_timezone_enb and l_task_rec.task_type_id not in (20, 21) then: ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
888: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
889: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
890: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
891: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
892:
893: END IF;

Line 890: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

886: IF l_debug THEN
887: debug(' if l_task_rec.ic_tz_code is not null and p_timezone_enb and l_task_rec.task_type_id not in (20, 21) then: ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
888: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
889: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
890: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
891: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
892:
893: END IF;
894: elsif l_res_tz_cd is not null and p_timezone_enb

Line 891: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

887: debug(' if l_task_rec.ic_tz_code is not null and p_timezone_enb and l_task_rec.task_type_id not in (20, 21) then: ' , 'get_tooltip_data_gantt', fnd_log.level_statement);
888: debug(' l_ic_planned_start_date : '||to_char(l_ic_planned_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
889: debug(' l_ic_planned_end_date : '||to_char(l_ic_planned_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
890: debug(' l_ic_scheduled_start_date : '||to_char(l_ic_scheduled_start_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
891: debug(' l_ic_scheduled_end_date : '||to_char(l_ic_scheduled_end_date,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
892:
893: END IF;
894: elsif l_res_tz_cd is not null and p_timezone_enb
895: then

Line 913: debug(' 2. Departure Time : '||to_char(l_rec.departure_time,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);

909: )
910: / 24
911: );
912: IF l_debug THEN
913: debug(' 2. Departure Time : '||to_char(l_rec.departure_time,'dd/mm/yyyy hh24:mi') , 'get_tooltip_data_gantt', fnd_log.level_statement);
914: END IF;
915: OPEN c_uom(NVL(l_task_rec.sched_travel_duration_uom, g_uom_minutes));
916: FETCH c_uom INTO l_uom;
917: IF c_uom%NOTFOUND THEN

Line 922: debug(' 2. l_uom : '||l_uom , 'get_tooltip_data_gantt', fnd_log.level_statement);

918: l_uom := NVL(l_task_rec.sched_travel_duration_uom, g_uom_minutes);
919: END IF;
920: CLOSE c_uom;
921: IF l_debug THEN
922: debug(' 2. l_uom : '||l_uom , 'get_tooltip_data_gantt', fnd_log.level_statement);
923: END IF;
924:
925: l_rec.travel_time := NVL(l_task_rec.sched_travel_duration, 0) || ' ' || l_uom;
926: IF l_debug THEN

Line 927: debug(' 2. Travel Time : '||l_rec.travel_time , 'get_tooltip_data_gantt', fnd_log.level_statement);

923: END IF;
924:
925: l_rec.travel_time := NVL(l_task_rec.sched_travel_duration, 0) || ' ' || l_uom;
926: IF l_debug THEN
927: debug(' 2. Travel Time : '||l_rec.travel_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
928: END IF;
929: IF l_debug THEN
930: debug(' 2. Arrival Task Id : '||l_arr.task_id , 'get_tooltip_data_gantt', fnd_log.level_statement);
931: debug(' 2. Scheduled Travel Duration : '||l_arr.sched_travel_duration , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 930: debug(' 2. Arrival Task Id : '||l_arr.task_id , 'get_tooltip_data_gantt', fnd_log.level_statement);

926: IF l_debug THEN
927: debug(' 2. Travel Time : '||l_rec.travel_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
928: END IF;
929: IF l_debug THEN
930: debug(' 2. Arrival Task Id : '||l_arr.task_id , 'get_tooltip_data_gantt', fnd_log.level_statement);
931: debug(' 2. Scheduled Travel Duration : '||l_arr.sched_travel_duration , 'get_tooltip_data_gantt', fnd_log.level_statement);
932: END IF;
933: IF p_task_id = l_first
934: OR p_task_id = l_arr.task_id

Line 931: debug(' 2. Scheduled Travel Duration : '||l_arr.sched_travel_duration , 'get_tooltip_data_gantt', fnd_log.level_statement);

927: debug(' 2. Travel Time : '||l_rec.travel_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
928: END IF;
929: IF l_debug THEN
930: debug(' 2. Arrival Task Id : '||l_arr.task_id , 'get_tooltip_data_gantt', fnd_log.level_statement);
931: debug(' 2. Scheduled Travel Duration : '||l_arr.sched_travel_duration , 'get_tooltip_data_gantt', fnd_log.level_statement);
932: END IF;
933: IF p_task_id = l_first
934: OR p_task_id = l_arr.task_id
935: OR p_task_id = l_last

Line 966: debug(' 2. Official Travel Time : '||l_off_time , 'get_tooltip_data_gantt', fnd_log.level_statement);

962: END IF;
963: END IF;
964: END IF;
965: IF l_debug THEN
966: debug(' 2. Official Travel Time : '||l_off_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
967: debug(' 2. Personal Travel Time : '||l_per_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
968: END IF;
969: l_rec.assigned_flag := l_task_rec.assigned_flag;
970: l_rec.is_plan_option := 'N';

Line 967: debug(' 2. Personal Travel Time : '||l_per_time , 'get_tooltip_data_gantt', fnd_log.level_statement);

963: END IF;
964: END IF;
965: IF l_debug THEN
966: debug(' 2. Official Travel Time : '||l_off_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
967: debug(' 2. Personal Travel Time : '||l_per_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
968: END IF;
969: l_rec.assigned_flag := l_task_rec.assigned_flag;
970: l_rec.is_plan_option := 'N';
971:

Line 978: debug(' Gps Code : '||CSF_GPS_PUB.IS_GPS_ENABLED , 'get_tooltip_data_gantt', fnd_log.level_statement);

974: test('P_RESOURCE_TYPE :'||p_resource_type );
975: test(' Gps Code : '||CSF_GPS_PUB.IS_GPS_ENABLED);
976: test('P_DATE :'||to_char(p_start_date,'dd-mon-rrrr hh24:mi:ss') );
977: IF l_debug THEN
978: debug(' Gps Code : '||CSF_GPS_PUB.IS_GPS_ENABLED , 'get_tooltip_data_gantt', fnd_log.level_statement);
979: END IF;
980:
981: If CSF_GPS_PUB.IS_GPS_ENABLED='Y'
982: THEN

Line 1005: debug('l_feed_time :'||l_feed_time , 'get_tooltip_data_gantt', fnd_log.level_statement);

1001: ,x_status_code_meaning=> l_status_code_meaning
1002: );
1003: END IF;
1004: IF l_debug THEN
1005: debug('l_feed_time :'||l_feed_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
1006: debug('l_status :'||l_status , 'get_tooltip_data_gantt', fnd_log.level_statement);
1007: debug('l_latitude :'||l_latitude , 'get_tooltip_data_gantt', fnd_log.level_statement);
1008: debug('l_longitude :'||l_longitude , 'get_tooltip_data_gantt', fnd_log.level_statement);
1009: debug('l_speed :'||l_speed , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 1006: debug('l_status :'||l_status , 'get_tooltip_data_gantt', fnd_log.level_statement);

1002: );
1003: END IF;
1004: IF l_debug THEN
1005: debug('l_feed_time :'||l_feed_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
1006: debug('l_status :'||l_status , 'get_tooltip_data_gantt', fnd_log.level_statement);
1007: debug('l_latitude :'||l_latitude , 'get_tooltip_data_gantt', fnd_log.level_statement);
1008: debug('l_longitude :'||l_longitude , 'get_tooltip_data_gantt', fnd_log.level_statement);
1009: debug('l_speed :'||l_speed , 'get_tooltip_data_gantt', fnd_log.level_statement);
1010: debug('l_direction :'||l_direction , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 1007: debug('l_latitude :'||l_latitude , 'get_tooltip_data_gantt', fnd_log.level_statement);

1003: END IF;
1004: IF l_debug THEN
1005: debug('l_feed_time :'||l_feed_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
1006: debug('l_status :'||l_status , 'get_tooltip_data_gantt', fnd_log.level_statement);
1007: debug('l_latitude :'||l_latitude , 'get_tooltip_data_gantt', fnd_log.level_statement);
1008: debug('l_longitude :'||l_longitude , 'get_tooltip_data_gantt', fnd_log.level_statement);
1009: debug('l_speed :'||l_speed , 'get_tooltip_data_gantt', fnd_log.level_statement);
1010: debug('l_direction :'||l_direction , 'get_tooltip_data_gantt', fnd_log.level_statement);
1011: debug('l_parked_time :'||l_parked_time , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 1008: debug('l_longitude :'||l_longitude , 'get_tooltip_data_gantt', fnd_log.level_statement);

1004: IF l_debug THEN
1005: debug('l_feed_time :'||l_feed_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
1006: debug('l_status :'||l_status , 'get_tooltip_data_gantt', fnd_log.level_statement);
1007: debug('l_latitude :'||l_latitude , 'get_tooltip_data_gantt', fnd_log.level_statement);
1008: debug('l_longitude :'||l_longitude , 'get_tooltip_data_gantt', fnd_log.level_statement);
1009: debug('l_speed :'||l_speed , 'get_tooltip_data_gantt', fnd_log.level_statement);
1010: debug('l_direction :'||l_direction , 'get_tooltip_data_gantt', fnd_log.level_statement);
1011: debug('l_parked_time :'||l_parked_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
1012: debug('l_address :'||l_address , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 1009: debug('l_speed :'||l_speed , 'get_tooltip_data_gantt', fnd_log.level_statement);

1005: debug('l_feed_time :'||l_feed_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
1006: debug('l_status :'||l_status , 'get_tooltip_data_gantt', fnd_log.level_statement);
1007: debug('l_latitude :'||l_latitude , 'get_tooltip_data_gantt', fnd_log.level_statement);
1008: debug('l_longitude :'||l_longitude , 'get_tooltip_data_gantt', fnd_log.level_statement);
1009: debug('l_speed :'||l_speed , 'get_tooltip_data_gantt', fnd_log.level_statement);
1010: debug('l_direction :'||l_direction , 'get_tooltip_data_gantt', fnd_log.level_statement);
1011: debug('l_parked_time :'||l_parked_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
1012: debug('l_address :'||l_address , 'get_tooltip_data_gantt', fnd_log.level_statement);
1013: debug('l_creation_date :'||l_creation_date , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 1010: debug('l_direction :'||l_direction , 'get_tooltip_data_gantt', fnd_log.level_statement);

1006: debug('l_status :'||l_status , 'get_tooltip_data_gantt', fnd_log.level_statement);
1007: debug('l_latitude :'||l_latitude , 'get_tooltip_data_gantt', fnd_log.level_statement);
1008: debug('l_longitude :'||l_longitude , 'get_tooltip_data_gantt', fnd_log.level_statement);
1009: debug('l_speed :'||l_speed , 'get_tooltip_data_gantt', fnd_log.level_statement);
1010: debug('l_direction :'||l_direction , 'get_tooltip_data_gantt', fnd_log.level_statement);
1011: debug('l_parked_time :'||l_parked_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
1012: debug('l_address :'||l_address , 'get_tooltip_data_gantt', fnd_log.level_statement);
1013: debug('l_creation_date :'||l_creation_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
1014: debug('l_device_tag :'||l_device_tag , 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 1011: debug('l_parked_time :'||l_parked_time , 'get_tooltip_data_gantt', fnd_log.level_statement);

1007: debug('l_latitude :'||l_latitude , 'get_tooltip_data_gantt', fnd_log.level_statement);
1008: debug('l_longitude :'||l_longitude , 'get_tooltip_data_gantt', fnd_log.level_statement);
1009: debug('l_speed :'||l_speed , 'get_tooltip_data_gantt', fnd_log.level_statement);
1010: debug('l_direction :'||l_direction , 'get_tooltip_data_gantt', fnd_log.level_statement);
1011: debug('l_parked_time :'||l_parked_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
1012: debug('l_address :'||l_address , 'get_tooltip_data_gantt', fnd_log.level_statement);
1013: debug('l_creation_date :'||l_creation_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
1014: debug('l_device_tag :'||l_device_tag , 'get_tooltip_data_gantt', fnd_log.level_statement);
1015: debug('l_status_code_meaning :'||l_status_code_meaning, 'get_tooltip_data_gantt', fnd_log.level_statement);

Line 1012: debug('l_address :'||l_address , 'get_tooltip_data_gantt', fnd_log.level_statement);

1008: debug('l_longitude :'||l_longitude , 'get_tooltip_data_gantt', fnd_log.level_statement);
1009: debug('l_speed :'||l_speed , 'get_tooltip_data_gantt', fnd_log.level_statement);
1010: debug('l_direction :'||l_direction , 'get_tooltip_data_gantt', fnd_log.level_statement);
1011: debug('l_parked_time :'||l_parked_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
1012: debug('l_address :'||l_address , 'get_tooltip_data_gantt', fnd_log.level_statement);
1013: debug('l_creation_date :'||l_creation_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
1014: debug('l_device_tag :'||l_device_tag , 'get_tooltip_data_gantt', fnd_log.level_statement);
1015: debug('l_status_code_meaning :'||l_status_code_meaning, 'get_tooltip_data_gantt', fnd_log.level_statement);
1016: END IF;

Line 1013: debug('l_creation_date :'||l_creation_date , 'get_tooltip_data_gantt', fnd_log.level_statement);

1009: debug('l_speed :'||l_speed , 'get_tooltip_data_gantt', fnd_log.level_statement);
1010: debug('l_direction :'||l_direction , 'get_tooltip_data_gantt', fnd_log.level_statement);
1011: debug('l_parked_time :'||l_parked_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
1012: debug('l_address :'||l_address , 'get_tooltip_data_gantt', fnd_log.level_statement);
1013: debug('l_creation_date :'||l_creation_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
1014: debug('l_device_tag :'||l_device_tag , 'get_tooltip_data_gantt', fnd_log.level_statement);
1015: debug('l_status_code_meaning :'||l_status_code_meaning, 'get_tooltip_data_gantt', fnd_log.level_statement);
1016: END IF;
1017: test('l_feed_time :'||l_feed_time);

Line 1014: debug('l_device_tag :'||l_device_tag , 'get_tooltip_data_gantt', fnd_log.level_statement);

1010: debug('l_direction :'||l_direction , 'get_tooltip_data_gantt', fnd_log.level_statement);
1011: debug('l_parked_time :'||l_parked_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
1012: debug('l_address :'||l_address , 'get_tooltip_data_gantt', fnd_log.level_statement);
1013: debug('l_creation_date :'||l_creation_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
1014: debug('l_device_tag :'||l_device_tag , 'get_tooltip_data_gantt', fnd_log.level_statement);
1015: debug('l_status_code_meaning :'||l_status_code_meaning, 'get_tooltip_data_gantt', fnd_log.level_statement);
1016: END IF;
1017: test('l_feed_time :'||l_feed_time);
1018: test('l_status :'||l_status );

Line 1015: debug('l_status_code_meaning :'||l_status_code_meaning, 'get_tooltip_data_gantt', fnd_log.level_statement);

1011: debug('l_parked_time :'||l_parked_time , 'get_tooltip_data_gantt', fnd_log.level_statement);
1012: debug('l_address :'||l_address , 'get_tooltip_data_gantt', fnd_log.level_statement);
1013: debug('l_creation_date :'||l_creation_date , 'get_tooltip_data_gantt', fnd_log.level_statement);
1014: debug('l_device_tag :'||l_device_tag , 'get_tooltip_data_gantt', fnd_log.level_statement);
1015: debug('l_status_code_meaning :'||l_status_code_meaning, 'get_tooltip_data_gantt', fnd_log.level_statement);
1016: END IF;
1017: test('l_feed_time :'||l_feed_time);
1018: test('l_status :'||l_status );
1019: test('l_latitude :'||l_latitude );

Line 1392: debug(' Tooltip string :'||l_str , 'get_tooltip_data_gantt', fnd_log.level_statement);

1388: END IF;
1389: END IF;
1390: l_str :=l_str|| '';
1391: IF l_debug THEN
1392: debug(' Tooltip string :'||l_str , 'get_tooltip_data_gantt', fnd_log.level_statement);
1393: END IF;
1394: RETURN l_str;
1395: END get_tooltip_data_gantt;
1396: FUNCTION get_tooltip_data_gantt_cust(