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.PA_FORECAST_ITEMS_UTILS dependencies on PA_FORECASTITEM_PVT

Line 419: PA_FORECASTITEM_PVT.print_message('Inside Get_Period_Set_Name');

415:
416: FUNCTION Get_Period_Set_Name(p_org_id NUMBER) RETURN VARCHAR2 IS
417: lv_period_set_name VARCHAR2(15);
418: BEGIN
419: PA_FORECASTITEM_PVT.print_message('Inside Get_Period_Set_Name');
420:
421:
422: -- 2196924: Adding case when p_org_id = -88
423: -- This may occur when there's no HR assignment for

Line 450: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND');

446: EXCEPTION
447: WHEN NO_DATA_FOUND THEN
448: lv_period_set_name := 'NO_DATA_FOUND';
449: NULL;
450: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND');
451: WHEN OTHERS THEN
452: lv_period_set_name := 'ERROR';
453: NULL;
454: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND');

Line 454: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND');

450: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND');
451: WHEN OTHERS THEN
452: lv_period_set_name := 'ERROR';
453: NULL;
454: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND');
455: END;
456: END IF;
457:
458: RETURN (lv_period_set_name);

Line 558: PA_FORECASTITEM_PVT.print_message('Inside Get_PA_Period_Name');

554: IS
555:
556: BEGIN
557:
558: PA_FORECASTITEM_PVT.print_message('Inside Get_PA_Period_Name');
559:
560: -- 2196924: Adding case when p_org_id = -88
561: -- This may occur when there's no HR assignment for
562: -- part of the resources time, so no ou for which

Line 658: PA_FORECASTITEM_PVT.print_message('No periods found.');

654: END IF;
655: end if;
656:
657: if (NVL(x_StartDateTab.count,0) = 0) then
658: PA_FORECASTITEM_PVT.print_message('No periods found.');
659: else
660: PA_FORECASTITEM_PVT.print_message('x_StartDateTab(first): ' || x_StartDateTab(x_StartDateTab.first));
661: PA_FORECASTITEM_PVT.print_message('x_EndDateTab(first): ' || x_EndDateTab(x_EndDateTab.first));
662: PA_FORECASTITEM_PVT.print_message('x_PAPeriodNameTab(first): ' || x_PAPeriodNameTab(x_PAPeriodNameTab.first));

Line 660: PA_FORECASTITEM_PVT.print_message('x_StartDateTab(first): ' || x_StartDateTab(x_StartDateTab.first));

656:
657: if (NVL(x_StartDateTab.count,0) = 0) then
658: PA_FORECASTITEM_PVT.print_message('No periods found.');
659: else
660: PA_FORECASTITEM_PVT.print_message('x_StartDateTab(first): ' || x_StartDateTab(x_StartDateTab.first));
661: PA_FORECASTITEM_PVT.print_message('x_EndDateTab(first): ' || x_EndDateTab(x_EndDateTab.first));
662: PA_FORECASTITEM_PVT.print_message('x_PAPeriodNameTab(first): ' || x_PAPeriodNameTab(x_PAPeriodNameTab.first));
663: PA_FORECASTITEM_PVT.print_message('x_StartDateTab(last): ' || x_StartDateTab(x_StartDateTab.last));
664: PA_FORECASTITEM_PVT.print_message('x_EndDateTab(last): ' || x_EndDateTab(x_EndDateTab.last));

Line 661: PA_FORECASTITEM_PVT.print_message('x_EndDateTab(first): ' || x_EndDateTab(x_EndDateTab.first));

657: if (NVL(x_StartDateTab.count,0) = 0) then
658: PA_FORECASTITEM_PVT.print_message('No periods found.');
659: else
660: PA_FORECASTITEM_PVT.print_message('x_StartDateTab(first): ' || x_StartDateTab(x_StartDateTab.first));
661: PA_FORECASTITEM_PVT.print_message('x_EndDateTab(first): ' || x_EndDateTab(x_EndDateTab.first));
662: PA_FORECASTITEM_PVT.print_message('x_PAPeriodNameTab(first): ' || x_PAPeriodNameTab(x_PAPeriodNameTab.first));
663: PA_FORECASTITEM_PVT.print_message('x_StartDateTab(last): ' || x_StartDateTab(x_StartDateTab.last));
664: PA_FORECASTITEM_PVT.print_message('x_EndDateTab(last): ' || x_EndDateTab(x_EndDateTab.last));
665: PA_FORECASTITEM_PVT.print_message('x_PAPeriodNameTab(last): ' || x_PAPeriodNameTab(x_PAPeriodNameTab.last));

Line 662: PA_FORECASTITEM_PVT.print_message('x_PAPeriodNameTab(first): ' || x_PAPeriodNameTab(x_PAPeriodNameTab.first));

658: PA_FORECASTITEM_PVT.print_message('No periods found.');
659: else
660: PA_FORECASTITEM_PVT.print_message('x_StartDateTab(first): ' || x_StartDateTab(x_StartDateTab.first));
661: PA_FORECASTITEM_PVT.print_message('x_EndDateTab(first): ' || x_EndDateTab(x_EndDateTab.first));
662: PA_FORECASTITEM_PVT.print_message('x_PAPeriodNameTab(first): ' || x_PAPeriodNameTab(x_PAPeriodNameTab.first));
663: PA_FORECASTITEM_PVT.print_message('x_StartDateTab(last): ' || x_StartDateTab(x_StartDateTab.last));
664: PA_FORECASTITEM_PVT.print_message('x_EndDateTab(last): ' || x_EndDateTab(x_EndDateTab.last));
665: PA_FORECASTITEM_PVT.print_message('x_PAPeriodNameTab(last): ' || x_PAPeriodNameTab(x_PAPeriodNameTab.last));
666:

Line 663: PA_FORECASTITEM_PVT.print_message('x_StartDateTab(last): ' || x_StartDateTab(x_StartDateTab.last));

659: else
660: PA_FORECASTITEM_PVT.print_message('x_StartDateTab(first): ' || x_StartDateTab(x_StartDateTab.first));
661: PA_FORECASTITEM_PVT.print_message('x_EndDateTab(first): ' || x_EndDateTab(x_EndDateTab.first));
662: PA_FORECASTITEM_PVT.print_message('x_PAPeriodNameTab(first): ' || x_PAPeriodNameTab(x_PAPeriodNameTab.first));
663: PA_FORECASTITEM_PVT.print_message('x_StartDateTab(last): ' || x_StartDateTab(x_StartDateTab.last));
664: PA_FORECASTITEM_PVT.print_message('x_EndDateTab(last): ' || x_EndDateTab(x_EndDateTab.last));
665: PA_FORECASTITEM_PVT.print_message('x_PAPeriodNameTab(last): ' || x_PAPeriodNameTab(x_PAPeriodNameTab.last));
666:
667: end if;

Line 664: PA_FORECASTITEM_PVT.print_message('x_EndDateTab(last): ' || x_EndDateTab(x_EndDateTab.last));

660: PA_FORECASTITEM_PVT.print_message('x_StartDateTab(first): ' || x_StartDateTab(x_StartDateTab.first));
661: PA_FORECASTITEM_PVT.print_message('x_EndDateTab(first): ' || x_EndDateTab(x_EndDateTab.first));
662: PA_FORECASTITEM_PVT.print_message('x_PAPeriodNameTab(first): ' || x_PAPeriodNameTab(x_PAPeriodNameTab.first));
663: PA_FORECASTITEM_PVT.print_message('x_StartDateTab(last): ' || x_StartDateTab(x_StartDateTab.last));
664: PA_FORECASTITEM_PVT.print_message('x_EndDateTab(last): ' || x_EndDateTab(x_EndDateTab.last));
665: PA_FORECASTITEM_PVT.print_message('x_PAPeriodNameTab(last): ' || x_PAPeriodNameTab(x_PAPeriodNameTab.last));
666:
667: end if;
668:

Line 665: PA_FORECASTITEM_PVT.print_message('x_PAPeriodNameTab(last): ' || x_PAPeriodNameTab(x_PAPeriodNameTab.last));

661: PA_FORECASTITEM_PVT.print_message('x_EndDateTab(first): ' || x_EndDateTab(x_EndDateTab.first));
662: PA_FORECASTITEM_PVT.print_message('x_PAPeriodNameTab(first): ' || x_PAPeriodNameTab(x_PAPeriodNameTab.first));
663: PA_FORECASTITEM_PVT.print_message('x_StartDateTab(last): ' || x_StartDateTab(x_StartDateTab.last));
664: PA_FORECASTITEM_PVT.print_message('x_EndDateTab(last): ' || x_EndDateTab(x_EndDateTab.last));
665: PA_FORECASTITEM_PVT.print_message('x_PAPeriodNameTab(last): ' || x_PAPeriodNameTab(x_PAPeriodNameTab.last));
666:
667: end if;
668:
669: EXCEPTION

Line 671: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND');

667: end if;
668:
669: EXCEPTION
670: WHEN NO_DATA_FOUND THEN
671: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND');
672: NULL;
673: WHEN OTHERS THEN -- 4537865 : Included this block
674: x_StartDateTab.delete;
675: x_EndDateTab.delete;

Line 708: PA_FORECASTITEM_PVT.print_message('Inside Get_GL_Period_Name');

704: x_PAPeriodNameTab OUT NOCOPY PA_FORECAST_GLOB.PeriodNameTabTyp) /* 2674619 - Nocopy change */
705: IS
706:
707: BEGIN
708: PA_FORECASTITEM_PVT.print_message('Inside Get_GL_Period_Name');
709:
710: -- 2196924: Adding case when p_org_id = -88
711: -- This may occur when there's no HR assignment for
712: -- part of the resources time, so no ou for which

Line 789: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND');

785: END IF;
786: END IF;
787: EXCEPTION
788: WHEN NO_DATA_FOUND THEN
789: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND');
790: NULL;
791: WHEN OTHERS THEN -- 4537865 : Included this block
792: x_StartDateTab.delete;
793: x_EndDateTab.delete;

Line 848: PA_FORECASTITEM_PVT.print_message('Inside Get_Resource_OU');

844: ld_prev_end_date DATE;
845: l_msg_index_out NUMBER;
846:
847: BEGIN
848: PA_FORECASTITEM_PVT.print_message('Inside Get_Resource_OU');
849: g_TimelineProfileSetup := PA_TIMELINE_UTIL.get_timeline_profile_setup;
850: availability_duration := g_TimelineProfileSetup.availability_duration;
851:
852: ld_start_date := NVL(p_start_date, ADD_MONTHS(sysdate, -12));

Line 855: PA_FORECASTITEM_PVT.print_message('p_resource_id: ' || p_resource_id);

851:
852: ld_start_date := NVL(p_start_date, ADD_MONTHS(sysdate, -12));
853: ld_end_date := NVL(p_end_date, ADD_MONTHS(sysdate, availability_duration * (12)));
854:
855: PA_FORECASTITEM_PVT.print_message('p_resource_id: ' || p_resource_id);
856: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
857: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
858: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
859: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);

Line 856: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);

852: ld_start_date := NVL(p_start_date, ADD_MONTHS(sysdate, -12));
853: ld_end_date := NVL(p_end_date, ADD_MONTHS(sysdate, availability_duration * (12)));
854:
855: PA_FORECASTITEM_PVT.print_message('p_resource_id: ' || p_resource_id);
856: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
857: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
858: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
859: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
860:

Line 857: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);

853: ld_end_date := NVL(p_end_date, ADD_MONTHS(sysdate, availability_duration * (12)));
854:
855: PA_FORECASTITEM_PVT.print_message('p_resource_id: ' || p_resource_id);
856: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
857: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
858: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
859: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
860:
861: -- 2196924: Added logic so it wouldn't raise NO_DATA_FOUND

Line 858: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);

854:
855: PA_FORECASTITEM_PVT.print_message('p_resource_id: ' || p_resource_id);
856: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
857: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
858: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
859: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
860:
861: -- 2196924: Added logic so it wouldn't raise NO_DATA_FOUND
862: BEGIN

Line 859: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);

855: PA_FORECASTITEM_PVT.print_message('p_resource_id: ' || p_resource_id);
856: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
857: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
858: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
859: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
860:
861: -- 2196924: Added logic so it wouldn't raise NO_DATA_FOUND
862: BEGIN
863: --Bug 4207110 :Added equalto condition while performing date check

Line 878: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');

874: ORDER BY rou.resource_effective_start_date;
875:
876: --Bug 4207110 END
877:
878: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
879: EXCEPTION
880: WHEN NO_DATA_FOUND THEN
881: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
882: END;

Line 881: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');

877:
878: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
879: EXCEPTION
880: WHEN NO_DATA_FOUND THEN
881: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
882: END;
883:
884:
885: -- 2196924: Added logic so that all dates have a record in out table.

Line 904: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);

900: li_first_ou := x_ResourceOUTab(li_first_index);
901: ld_last_end_date := x_EndDateTab(li_last_index);
902: li_last_ou := x_ResourceOUTab(li_last_index);
903:
904: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
905: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
906: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
907: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
908: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);

Line 905: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);

901: ld_last_end_date := x_EndDateTab(li_last_index);
902: li_last_ou := x_ResourceOUTab(li_last_index);
903:
904: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
905: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
906: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
907: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
908: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
909: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);

Line 906: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);

902: li_last_ou := x_ResourceOUTab(li_last_index);
903:
904: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
905: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
906: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
907: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
908: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
909: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
910: PA_FORECASTITEM_PVT.print_message('li_first_ou: ' || li_first_ou);

Line 907: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);

903:
904: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
905: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
906: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
907: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
908: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
909: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
910: PA_FORECASTITEM_PVT.print_message('li_first_ou: ' || li_first_ou);
911: PA_FORECASTITEM_PVT.print_message('li_last_ou: ' || li_last_ou);

Line 908: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);

904: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
905: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
906: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
907: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
908: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
909: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
910: PA_FORECASTITEM_PVT.print_message('li_first_ou: ' || li_first_ou);
911: PA_FORECASTITEM_PVT.print_message('li_last_ou: ' || li_last_ou);
912:

Line 909: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);

905: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
906: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
907: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
908: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
909: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
910: PA_FORECASTITEM_PVT.print_message('li_first_ou: ' || li_first_ou);
911: PA_FORECASTITEM_PVT.print_message('li_last_ou: ' || li_last_ou);
912:
913: if (ld_first_start_date > ld_start_date) then

Line 910: PA_FORECASTITEM_PVT.print_message('li_first_ou: ' || li_first_ou);

906: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
907: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
908: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
909: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
910: PA_FORECASTITEM_PVT.print_message('li_first_ou: ' || li_first_ou);
911: PA_FORECASTITEM_PVT.print_message('li_last_ou: ' || li_last_ou);
912:
913: if (ld_first_start_date > ld_start_date) then
914: -- Insert a record into table

Line 911: PA_FORECASTITEM_PVT.print_message('li_last_ou: ' || li_last_ou);

907: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
908: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
909: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
910: PA_FORECASTITEM_PVT.print_message('li_first_ou: ' || li_first_ou);
911: PA_FORECASTITEM_PVT.print_message('li_last_ou: ' || li_last_ou);
912:
913: if (ld_first_start_date > ld_start_date) then
914: -- Insert a record into table
915: PA_FORECASTITEM_PVT.print_message('ld_first_start_date > ld_start_date');

Line 915: PA_FORECASTITEM_PVT.print_message('ld_first_start_date > ld_start_date');

911: PA_FORECASTITEM_PVT.print_message('li_last_ou: ' || li_last_ou);
912:
913: if (ld_first_start_date > ld_start_date) then
914: -- Insert a record into table
915: PA_FORECASTITEM_PVT.print_message('ld_first_start_date > ld_start_date');
916: x_ResourceOUTab(li_new_first_index) := -88;
917: x_StartDateTab(li_new_first_index) := ld_start_date;
918: x_EndDateTab(li_new_first_index) := ld_first_start_date - 1;
919: end if;

Line 923: PA_FORECASTITEM_PVT.print_message('ld_last_end_date < ld_end_date');

919: end if;
920:
921: if (ld_last_end_date < ld_end_date) then
922: -- Insert a record into table
923: PA_FORECASTITEM_PVT.print_message('ld_last_end_date < ld_end_date');
924: x_ResourceOUTab(li_new_last_index) := -88;
925: x_StartDateTab(li_new_last_index) := ld_last_end_date + 1;
926: x_EndDateTab(li_new_last_index) := ld_end_date;
927: end if;

Line 955: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');

951: x_EndDateTab := l_new_EndDateTab;
952: -- 4537865 : EXCEPTION BLOCK INCLUDED
953: EXCEPTION
954: WHEN NO_DATA_FOUND THEN
955: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
956: NULL ;
957: WHEN OTHERS THEN
958: x_ResourceOUTab.delete;
959: x_StartDateTab.delete;

Line 1016: PA_FORECASTITEM_PVT.print_message('Get_Res_Org_And_Job');

1012: l_msg_index_out NUMBER;
1013:
1014: BEGIN
1015:
1016: PA_FORECASTITEM_PVT.print_message('Get_Res_Org_And_Job');
1017:
1018: g_TimelineProfileSetup := PA_TIMELINE_UTIL.get_timeline_profile_setup;
1019: availability_duration := g_TimelineProfileSetup.availability_duration;
1020:

Line 1024: PA_FORECASTITEM_PVT.print_message('p_person_id: ' || p_person_id);

1020:
1021: ld_start_date := NVL(p_start_date, ADD_MONTHS(sysdate, -12));
1022: ld_end_date := NVL(p_end_date, ADD_MONTHS(sysdate, availability_duration * (12)));
1023:
1024: PA_FORECASTITEM_PVT.print_message('p_person_id: ' || p_person_id);
1025: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
1026: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
1027: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
1028: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);

Line 1025: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);

1021: ld_start_date := NVL(p_start_date, ADD_MONTHS(sysdate, -12));
1022: ld_end_date := NVL(p_end_date, ADD_MONTHS(sysdate, availability_duration * (12)));
1023:
1024: PA_FORECASTITEM_PVT.print_message('p_person_id: ' || p_person_id);
1025: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
1026: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
1027: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
1028: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
1029:

Line 1026: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);

1022: ld_end_date := NVL(p_end_date, ADD_MONTHS(sysdate, availability_duration * (12)));
1023:
1024: PA_FORECASTITEM_PVT.print_message('p_person_id: ' || p_person_id);
1025: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
1026: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
1027: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
1028: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
1029:
1030: --- | 18-sep-01 jmarques 2001160: modified per_people_x select

Line 1027: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);

1023:
1024: PA_FORECASTITEM_PVT.print_message('p_person_id: ' || p_person_id);
1025: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
1026: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
1027: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
1028: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
1029:
1030: --- | 18-sep-01 jmarques 2001160: modified per_people_x select
1031: --- | statement to select from per_people_f

Line 1028: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);

1024: PA_FORECASTITEM_PVT.print_message('p_person_id: ' || p_person_id);
1025: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
1026: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
1027: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
1028: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
1029:
1030: --- | 18-sep-01 jmarques 2001160: modified per_people_x select
1031: --- | statement to select from per_people_f
1032: --- | also added new date criteria since

Line 1062: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');

1058:
1059:
1060: EXCEPTION
1061: WHEN NO_DATA_FOUND THEN
1062: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
1063: END;
1064:
1065: PA_FORECASTITEM_PVT.print_message('JM: 1');
1066:

Line 1065: PA_FORECASTITEM_PVT.print_message('JM: 1');

1061: WHEN NO_DATA_FOUND THEN
1062: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
1063: END;
1064:
1065: PA_FORECASTITEM_PVT.print_message('JM: 1');
1066:
1067: -- 2196924: Added logic so that all dates have a record in out table.
1068: li_count := NVL(x_StartDateTab.count,0);
1069: if (li_count = 0) then

Line 1070: PA_FORECASTITEM_PVT.print_message('JM: 2');

1066:
1067: -- 2196924: Added logic so that all dates have a record in out table.
1068: li_count := NVL(x_StartDateTab.count,0);
1069: if (li_count = 0) then
1070: PA_FORECASTITEM_PVT.print_message('JM: 2');
1071: x_StartDateTab(1) := ld_start_date;
1072: x_EndDateTab(1) := ld_end_date;
1073: x_ResourceOrganizationIDTab(1) := -77;
1074: x_ResourceJobIDTab(1) := null;

Line 1078: PA_FORECASTITEM_PVT.print_message('JM: 3');

1074: x_ResourceJobIDTab(1) := null;
1075: li_count := 1;
1076: end if;
1077:
1078: PA_FORECASTITEM_PVT.print_message('JM: 3');
1079: li_first_index := x_StartDateTab.first;
1080: li_new_first_index := li_first_index - 1;
1081: li_last_index := x_StartDateTab.last;
1082: li_new_last_index := li_last_index + 1;

Line 1086: PA_FORECASTITEM_PVT.print_message('JM: 4');

1082: li_new_last_index := li_last_index + 1;
1083: ld_first_start_date := x_StartDateTab(li_first_index);
1084: ld_last_end_date := x_EndDateTab(li_last_index);
1085:
1086: PA_FORECASTITEM_PVT.print_message('JM: 4');
1087: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
1088: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
1089: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
1090: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);

Line 1087: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);

1083: ld_first_start_date := x_StartDateTab(li_first_index);
1084: ld_last_end_date := x_EndDateTab(li_last_index);
1085:
1086: PA_FORECASTITEM_PVT.print_message('JM: 4');
1087: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
1088: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
1089: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
1090: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
1091: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);

Line 1088: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);

1084: ld_last_end_date := x_EndDateTab(li_last_index);
1085:
1086: PA_FORECASTITEM_PVT.print_message('JM: 4');
1087: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
1088: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
1089: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
1090: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
1091: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
1092: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);

Line 1089: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);

1085:
1086: PA_FORECASTITEM_PVT.print_message('JM: 4');
1087: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
1088: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
1089: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
1090: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
1091: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
1092: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
1093:

Line 1090: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);

1086: PA_FORECASTITEM_PVT.print_message('JM: 4');
1087: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
1088: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
1089: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
1090: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
1091: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
1092: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
1093:
1094: if (ld_first_start_date > ld_start_date) then

Line 1091: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);

1087: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
1088: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
1089: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
1090: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
1091: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
1092: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
1093:
1094: if (ld_first_start_date > ld_start_date) then
1095: -- Insert a record into table

Line 1092: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);

1088: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
1089: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
1090: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
1091: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
1092: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
1093:
1094: if (ld_first_start_date > ld_start_date) then
1095: -- Insert a record into table
1096: PA_FORECASTITEM_PVT.print_message('ld_first_start_date > ld_start_date');

Line 1096: PA_FORECASTITEM_PVT.print_message('ld_first_start_date > ld_start_date');

1092: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
1093:
1094: if (ld_first_start_date > ld_start_date) then
1095: -- Insert a record into table
1096: PA_FORECASTITEM_PVT.print_message('ld_first_start_date > ld_start_date');
1097: x_ResourceOrganizationIDTab(li_new_first_index) := -77;
1098: x_ResourceJobIDTab(li_new_first_index) := null;
1099: x_StartDateTab(li_new_first_index) := ld_start_date;
1100: x_EndDateTab(li_new_first_index) := ld_first_start_date - 1;

Line 1105: PA_FORECASTITEM_PVT.print_message('ld_last_end_date < ld_end_date');

1101: end if;
1102:
1103: if (ld_last_end_date < ld_end_date) then
1104: -- Insert a record into table
1105: PA_FORECASTITEM_PVT.print_message('ld_last_end_date < ld_end_date');
1106: x_ResourceOrganizationIDTab(li_new_last_index) := -77;
1107: x_ResourceJobIDTab(li_new_last_index) := null;
1108: x_StartDateTab(li_new_last_index) := ld_last_end_date + 1;
1109: x_EndDateTab(li_new_last_index) := ld_end_date;

Line 1141: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');

1137: x_EndDateTab := l_new_EndDateTab;
1138: -- 4537865 : EXCEPTION BLOCK INCLUDED
1139: EXCEPTION
1140: WHEN NO_DATA_FOUND THEN
1141: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
1142: NULL ;
1143: WHEN OTHERS THEN
1144: x_ResourceOrganizationIDTab.delete;
1145: x_ResourceJobIDTab.delete;

Line 1164: PA_FORECASTITEM_PVT.print_message('p_resource_id: ' || p_resource_id);

1160: ------------------------------------------------------------------------------------
1161: FUNCTION Get_Person_Id(p_resource_id NUMBER) RETURN NUMBER IS
1162: li_person_id NUMBER;
1163: BEGIN
1164: PA_FORECASTITEM_PVT.print_message('p_resource_id: ' || p_resource_id);
1165: SELECT person_id
1166: INTO li_person_id
1167: FROM pa_resource_txn_attributes
1168: WHERE resource_id = p_resource_id

Line 1252: PA_FORECASTITEM_PVT.print_message('p_org_id: ' || p_org_id );

1248: PA_DEBUG.Init_err_stack(
1249: 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions');
1250: -- Selecting columns corresponding to the given org id
1251:
1252: PA_FORECASTITEM_PVT.print_message('p_org_id: ' || p_org_id );
1253:
1254: -- 2196924: Adding case when p_org_id is null
1255: -- This may occur when there's no HR assignment for
1256: -- part of the resources time, so no ou.