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 782: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND');

778: END IF;
779: END IF;
780: EXCEPTION
781: WHEN NO_DATA_FOUND THEN
782: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND');
783: NULL;
784: WHEN OTHERS THEN -- 4537865 : Included this block
785: x_StartDateTab.delete;
786: x_EndDateTab.delete;

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

837: ld_prev_end_date DATE;
838: l_msg_index_out NUMBER;
839:
840: BEGIN
841: PA_FORECASTITEM_PVT.print_message('Inside Get_Resource_OU');
842: g_TimelineProfileSetup := PA_TIMELINE_UTIL.get_timeline_profile_setup;
843: availability_duration := g_TimelineProfileSetup.availability_duration;
844:
845: ld_start_date := NVL(p_start_date, ADD_MONTHS(sysdate, -12));

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

844:
845: ld_start_date := NVL(p_start_date, ADD_MONTHS(sysdate, -12));
846: ld_end_date := NVL(p_end_date, ADD_MONTHS(sysdate, availability_duration * (12)));
847:
848: PA_FORECASTITEM_PVT.print_message('p_resource_id: ' || p_resource_id);
849: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
850: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
851: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
852: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);

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

845: ld_start_date := NVL(p_start_date, ADD_MONTHS(sysdate, -12));
846: ld_end_date := NVL(p_end_date, ADD_MONTHS(sysdate, availability_duration * (12)));
847:
848: PA_FORECASTITEM_PVT.print_message('p_resource_id: ' || p_resource_id);
849: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
850: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
851: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
852: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
853:

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

846: ld_end_date := NVL(p_end_date, ADD_MONTHS(sysdate, availability_duration * (12)));
847:
848: PA_FORECASTITEM_PVT.print_message('p_resource_id: ' || p_resource_id);
849: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
850: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
851: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
852: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
853:
854: -- 2196924: Added logic so it wouldn't raise NO_DATA_FOUND

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

847:
848: PA_FORECASTITEM_PVT.print_message('p_resource_id: ' || p_resource_id);
849: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
850: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
851: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
852: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
853:
854: -- 2196924: Added logic so it wouldn't raise NO_DATA_FOUND
855: BEGIN

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

848: PA_FORECASTITEM_PVT.print_message('p_resource_id: ' || p_resource_id);
849: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
850: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
851: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
852: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
853:
854: -- 2196924: Added logic so it wouldn't raise NO_DATA_FOUND
855: BEGIN
856: --Bug 4207110 :Added equalto condition while performing date check

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

867: ORDER BY rou.resource_effective_start_date;
868:
869: --Bug 4207110 END
870:
871: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
872: EXCEPTION
873: WHEN NO_DATA_FOUND THEN
874: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
875: END;

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

870:
871: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
872: EXCEPTION
873: WHEN NO_DATA_FOUND THEN
874: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
875: END;
876:
877:
878: -- 2196924: Added logic so that all dates have a record in out table.

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

893: li_first_ou := x_ResourceOUTab(li_first_index);
894: ld_last_end_date := x_EndDateTab(li_last_index);
895: li_last_ou := x_ResourceOUTab(li_last_index);
896:
897: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
898: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
899: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
900: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
901: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);

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

894: ld_last_end_date := x_EndDateTab(li_last_index);
895: li_last_ou := x_ResourceOUTab(li_last_index);
896:
897: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
898: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
899: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
900: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
901: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
902: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);

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

895: li_last_ou := x_ResourceOUTab(li_last_index);
896:
897: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
898: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
899: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
900: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
901: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
902: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
903: PA_FORECASTITEM_PVT.print_message('li_first_ou: ' || li_first_ou);

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

896:
897: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
898: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
899: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
900: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
901: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
902: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
903: PA_FORECASTITEM_PVT.print_message('li_first_ou: ' || li_first_ou);
904: PA_FORECASTITEM_PVT.print_message('li_last_ou: ' || li_last_ou);

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

897: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
898: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
899: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
900: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
901: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
902: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
903: PA_FORECASTITEM_PVT.print_message('li_first_ou: ' || li_first_ou);
904: PA_FORECASTITEM_PVT.print_message('li_last_ou: ' || li_last_ou);
905:

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

898: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
899: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
900: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
901: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
902: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
903: PA_FORECASTITEM_PVT.print_message('li_first_ou: ' || li_first_ou);
904: PA_FORECASTITEM_PVT.print_message('li_last_ou: ' || li_last_ou);
905:
906: if (ld_first_start_date > ld_start_date) then

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

899: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
900: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
901: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
902: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
903: PA_FORECASTITEM_PVT.print_message('li_first_ou: ' || li_first_ou);
904: PA_FORECASTITEM_PVT.print_message('li_last_ou: ' || li_last_ou);
905:
906: if (ld_first_start_date > ld_start_date) then
907: -- Insert a record into table

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

900: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
901: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
902: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
903: PA_FORECASTITEM_PVT.print_message('li_first_ou: ' || li_first_ou);
904: PA_FORECASTITEM_PVT.print_message('li_last_ou: ' || li_last_ou);
905:
906: if (ld_first_start_date > ld_start_date) then
907: -- Insert a record into table
908: PA_FORECASTITEM_PVT.print_message('ld_first_start_date > ld_start_date');

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

904: PA_FORECASTITEM_PVT.print_message('li_last_ou: ' || li_last_ou);
905:
906: if (ld_first_start_date > ld_start_date) then
907: -- Insert a record into table
908: PA_FORECASTITEM_PVT.print_message('ld_first_start_date > ld_start_date');
909: x_ResourceOUTab(li_new_first_index) := -88;
910: x_StartDateTab(li_new_first_index) := ld_start_date;
911: x_EndDateTab(li_new_first_index) := ld_first_start_date - 1;
912: end if;

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

912: end if;
913:
914: if (ld_last_end_date < ld_end_date) then
915: -- Insert a record into table
916: PA_FORECASTITEM_PVT.print_message('ld_last_end_date < ld_end_date');
917: x_ResourceOUTab(li_new_last_index) := -88;
918: x_StartDateTab(li_new_last_index) := ld_last_end_date + 1;
919: x_EndDateTab(li_new_last_index) := ld_end_date;
920: end if;

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

944: x_EndDateTab := l_new_EndDateTab;
945: -- 4537865 : EXCEPTION BLOCK INCLUDED
946: EXCEPTION
947: WHEN NO_DATA_FOUND THEN
948: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
949: NULL ;
950: WHEN OTHERS THEN
951: x_ResourceOUTab.delete;
952: x_StartDateTab.delete;

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

1005: l_msg_index_out NUMBER;
1006:
1007: BEGIN
1008:
1009: PA_FORECASTITEM_PVT.print_message('Get_Res_Org_And_Job');
1010:
1011: g_TimelineProfileSetup := PA_TIMELINE_UTIL.get_timeline_profile_setup;
1012: availability_duration := g_TimelineProfileSetup.availability_duration;
1013:

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

1013:
1014: ld_start_date := NVL(p_start_date, ADD_MONTHS(sysdate, -12));
1015: ld_end_date := NVL(p_end_date, ADD_MONTHS(sysdate, availability_duration * (12)));
1016:
1017: PA_FORECASTITEM_PVT.print_message('p_person_id: ' || p_person_id);
1018: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
1019: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
1020: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
1021: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);

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

1014: ld_start_date := NVL(p_start_date, ADD_MONTHS(sysdate, -12));
1015: ld_end_date := NVL(p_end_date, ADD_MONTHS(sysdate, availability_duration * (12)));
1016:
1017: PA_FORECASTITEM_PVT.print_message('p_person_id: ' || p_person_id);
1018: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
1019: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
1020: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
1021: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
1022:

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

1015: ld_end_date := NVL(p_end_date, ADD_MONTHS(sysdate, availability_duration * (12)));
1016:
1017: PA_FORECASTITEM_PVT.print_message('p_person_id: ' || p_person_id);
1018: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
1019: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
1020: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
1021: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
1022:
1023: --- | 18-sep-01 jmarques 2001160: modified per_people_x select

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

1016:
1017: PA_FORECASTITEM_PVT.print_message('p_person_id: ' || p_person_id);
1018: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
1019: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
1020: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
1021: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
1022:
1023: --- | 18-sep-01 jmarques 2001160: modified per_people_x select
1024: --- | statement to select from per_people_f

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

1017: PA_FORECASTITEM_PVT.print_message('p_person_id: ' || p_person_id);
1018: PA_FORECASTITEM_PVT.print_message('p_start_date: ' || p_start_date);
1019: PA_FORECASTITEM_PVT.print_message('p_end_date: ' || p_end_date);
1020: PA_FORECASTITEM_PVT.print_message('ld_start_date: ' || ld_start_date);
1021: PA_FORECASTITEM_PVT.print_message('ld_end_date: ' || ld_end_date);
1022:
1023: --- | 18-sep-01 jmarques 2001160: modified per_people_x select
1024: --- | statement to select from per_people_f
1025: --- | also added new date criteria since

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

1051:
1052:
1053: EXCEPTION
1054: WHEN NO_DATA_FOUND THEN
1055: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
1056: END;
1057:
1058: PA_FORECASTITEM_PVT.print_message('JM: 1');
1059:

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

1054: WHEN NO_DATA_FOUND THEN
1055: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
1056: END;
1057:
1058: PA_FORECASTITEM_PVT.print_message('JM: 1');
1059:
1060: -- 2196924: Added logic so that all dates have a record in out table.
1061: li_count := NVL(x_StartDateTab.count,0);
1062: if (li_count = 0) then

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

1059:
1060: -- 2196924: Added logic so that all dates have a record in out table.
1061: li_count := NVL(x_StartDateTab.count,0);
1062: if (li_count = 0) then
1063: PA_FORECASTITEM_PVT.print_message('JM: 2');
1064: x_StartDateTab(1) := ld_start_date;
1065: x_EndDateTab(1) := ld_end_date;
1066: x_ResourceOrganizationIDTab(1) := -77;
1067: x_ResourceJobIDTab(1) := null;

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

1067: x_ResourceJobIDTab(1) := null;
1068: li_count := 1;
1069: end if;
1070:
1071: PA_FORECASTITEM_PVT.print_message('JM: 3');
1072: li_first_index := x_StartDateTab.first;
1073: li_new_first_index := li_first_index - 1;
1074: li_last_index := x_StartDateTab.last;
1075: li_new_last_index := li_last_index + 1;

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

1075: li_new_last_index := li_last_index + 1;
1076: ld_first_start_date := x_StartDateTab(li_first_index);
1077: ld_last_end_date := x_EndDateTab(li_last_index);
1078:
1079: PA_FORECASTITEM_PVT.print_message('JM: 4');
1080: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
1081: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
1082: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
1083: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);

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

1076: ld_first_start_date := x_StartDateTab(li_first_index);
1077: ld_last_end_date := x_EndDateTab(li_last_index);
1078:
1079: PA_FORECASTITEM_PVT.print_message('JM: 4');
1080: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
1081: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
1082: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
1083: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
1084: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);

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

1077: ld_last_end_date := x_EndDateTab(li_last_index);
1078:
1079: PA_FORECASTITEM_PVT.print_message('JM: 4');
1080: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
1081: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
1082: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
1083: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
1084: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
1085: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);

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

1078:
1079: PA_FORECASTITEM_PVT.print_message('JM: 4');
1080: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
1081: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
1082: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
1083: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
1084: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
1085: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
1086:

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

1079: PA_FORECASTITEM_PVT.print_message('JM: 4');
1080: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
1081: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
1082: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
1083: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
1084: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
1085: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
1086:
1087: if (ld_first_start_date > ld_start_date) then

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

1080: PA_FORECASTITEM_PVT.print_message('li_first_index: ' || li_first_index);
1081: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
1082: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
1083: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
1084: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
1085: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
1086:
1087: if (ld_first_start_date > ld_start_date) then
1088: -- Insert a record into table

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

1081: PA_FORECASTITEM_PVT.print_message('li_new_first_index: ' || li_new_first_index);
1082: PA_FORECASTITEM_PVT.print_message('li_last_index: ' || li_last_index);
1083: PA_FORECASTITEM_PVT.print_message('li_new_last_index: ' || li_new_last_index);
1084: PA_FORECASTITEM_PVT.print_message('ld_first_start_date: ' || ld_first_start_date);
1085: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
1086:
1087: if (ld_first_start_date > ld_start_date) then
1088: -- Insert a record into table
1089: PA_FORECASTITEM_PVT.print_message('ld_first_start_date > ld_start_date');

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

1085: PA_FORECASTITEM_PVT.print_message('ld_last_end_date: ' || ld_last_end_date);
1086:
1087: if (ld_first_start_date > ld_start_date) then
1088: -- Insert a record into table
1089: PA_FORECASTITEM_PVT.print_message('ld_first_start_date > ld_start_date');
1090: x_ResourceOrganizationIDTab(li_new_first_index) := -77;
1091: x_ResourceJobIDTab(li_new_first_index) := null;
1092: x_StartDateTab(li_new_first_index) := ld_start_date;
1093: x_EndDateTab(li_new_first_index) := ld_first_start_date - 1;

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

1094: end if;
1095:
1096: if (ld_last_end_date < ld_end_date) then
1097: -- Insert a record into table
1098: PA_FORECASTITEM_PVT.print_message('ld_last_end_date < ld_end_date');
1099: x_ResourceOrganizationIDTab(li_new_last_index) := -77;
1100: x_ResourceJobIDTab(li_new_last_index) := null;
1101: x_StartDateTab(li_new_last_index) := ld_last_end_date + 1;
1102: x_EndDateTab(li_new_last_index) := ld_end_date;

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

1130: x_EndDateTab := l_new_EndDateTab;
1131: -- 4537865 : EXCEPTION BLOCK INCLUDED
1132: EXCEPTION
1133: WHEN NO_DATA_FOUND THEN
1134: PA_FORECASTITEM_PVT.print_message('NO_DATA_FOUND ok, exception not raised');
1135: NULL ;
1136: WHEN OTHERS THEN
1137: x_ResourceOrganizationIDTab.delete;
1138: x_ResourceJobIDTab.delete;

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

1153: ------------------------------------------------------------------------------------
1154: FUNCTION Get_Person_Id(p_resource_id NUMBER) RETURN NUMBER IS
1155: li_person_id NUMBER;
1156: BEGIN
1157: PA_FORECASTITEM_PVT.print_message('p_resource_id: ' || p_resource_id);
1158: SELECT person_id
1159: INTO li_person_id
1160: FROM pa_resource_txn_attributes
1161: WHERE resource_id = p_resource_id

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

1241: PA_DEBUG.Init_err_stack(
1242: 'PA_FORECAST_ITEMS_UTILS.Get_forecastoptions');
1243: -- Selecting columns corresponding to the given org id
1244:
1245: PA_FORECASTITEM_PVT.print_message('p_org_id: ' || p_org_id );
1246:
1247: -- 2196924: Adding case when p_org_id is null
1248: -- This may occur when there's no HR assignment for
1249: -- part of the resources time, so no ou.