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.HR_HEAD_COUNT dependencies on HR_UTILITY

Line 844: hr_utility.set_location('l_AsgWorkerType_formula_id = '|| l_AsgWorkerType_formula_id,10);

840:
841: open c_get_PerType_formula(p_business_group_id);
842: fetch c_get_PerType_formula into l_AsgWorkerType_formula_id;
843:
844: hr_utility.set_location('l_AsgWorkerType_formula_id = '|| l_AsgWorkerType_formula_id,10);
845:
846: if (c_get_PerType_formula%notfound)
847: then
848: close c_get_PerType_formula;

Line 850: hr_utility.set_location('Formula - HR_PERSON_TYPE does not exist.',15);

846: if (c_get_PerType_formula%notfound)
847: then
848: close c_get_PerType_formula;
849:
850: hr_utility.set_location('Formula - HR_PERSON_TYPE does not exist.',15);
851:
852: -- If User Defined HR_PERSON_TYPE formula does not exist,
853: -- look for seeded HR_PERSON_TYPE_TEMPLATE formula
854:

Line 858: hr_utility.set_location('Template_AsgWorkerType_formula_id = '|| l_AsgWorkerType_formula_id,20);

854:
855: open c_get_tmplt_PerType_formula;
856: fetch c_get_tmplt_PerType_formula into l_AsgWorkerType_formula_id;
857:
858: hr_utility.set_location('Template_AsgWorkerType_formula_id = '|| l_AsgWorkerType_formula_id,20);
859:
860: if (c_get_tmplt_PerType_formula%notfound)
861: then
862: close c_get_tmplt_PerType_formula;

Line 868: hr_utility.set_location('Formula - HR_PERSON_TYPE_TEMPLATE does not exist.',20);

864: -- Set to null so that we can calculate values differently later
865:
866: l_AsgWorkerType_formula_id := null;
867:
868: hr_utility.set_location('Formula - HR_PERSON_TYPE_TEMPLATE does not exist.',20);
869:
870: else
871:
872: close c_get_tmplt_PerType_formula;

Line 889: hr_utility.set_location('ABV Formula ID = '||l_ABV_formula_id,30);

885:
886: open c_get_ABV_formula(p_business_group_id);
887: fetch c_get_ABV_formula into l_ABV_formula_id;
888:
889: hr_utility.set_location('ABV Formula ID = '||l_ABV_formula_id,30);
890:
891: if (c_get_ABV_formula%notfound)
892: then
893: close c_get_ABV_formula;

Line 895: hr_utility.set_location('User Defined Formula - BUDGET_FTE/HEAD does not exist.',35);

891: if (c_get_ABV_formula%notfound)
892: then
893: close c_get_ABV_formula;
894:
895: hr_utility.set_location('User Defined Formula - BUDGET_FTE/HEAD does not exist.',35);
896:
897: -- If User Defined BUDGET_FTE/HEAD formula does not exist,
898: -- look for seeded TEMPLATE_FTE/HEAD formula
899:

Line 903: hr_utility.set_location('Template ABV Formula = '||l_ABV_formula_id,40);

899:
900: open c_get_tmplt_ABV_formula;
901: fetch c_get_tmplt_ABV_formula into l_ABV_formula_id;
902:
903: hr_utility.set_location('Template ABV Formula = '||l_ABV_formula_id,40);
904:
905: if (c_get_tmplt_ABV_formula%notfound)
906: then
907: close c_get_tmplt_ABV_formula;

Line 909: hr_utility.set_location('Seeded Formula - TEMPLATE_FTE/HEAD does not exist.',45);

905: if (c_get_tmplt_ABV_formula%notfound)
906: then
907: close c_get_tmplt_ABV_formula;
908:
909: hr_utility.set_location('Seeded Formula - TEMPLATE_FTE/HEAD does not exist.',45);
910: -- Set to null so that we can calculate values differently later
911:
912: l_ABV_formula_id := null;
913:

Line 946: hr_utility.set_location('Term Formula ID = '|| l_term_formula_id,50);

942: /*
943: open c_get_term_formula(p_business_group_id);
944: fetch c_get_term_formula into l_term_formula_id;
945:
946: hr_utility.set_location('Term Formula ID = '|| l_term_formula_id,50);
947:
948: if (c_get_term_formula%notfound)
949: then
950: close c_get_term_formula;

Line 952: hr_utility.set_location('User Defined Formula - HR_MOVE_TYPE does not exist.',55);

948: if (c_get_term_formula%notfound)
949: then
950: close c_get_term_formula;
951:
952: hr_utility.set_location('User Defined Formula - HR_MOVE_TYPE does not exist.',55);
953:
954: -- If User Defined HR_MOVE_TYPE formula does not exist,
955: -- look for seeded HR_MOVE_TYPE_TEMPLATE formula
956:

Line 960: hr_utility.set_location('Term Template Formula ID = '|| l_term_formula_id,60);

956:
957: open c_get_tmplt_term_formula;
958: fetch c_get_tmplt_term_formula into l_term_formula_id;
959:
960: hr_utility.set_location('Term Template Formula ID = '|| l_term_formula_id,60);
961:
962: if (c_get_tmplt_term_formula%notfound)
963: then
964: close c_get_tmplt_term_formula;

Line 966: hr_utility.set_location('User Defined Formula - HR_MOVE_TYPE_TEMPLATE does not exist.',65);

962: if (c_get_tmplt_term_formula%notfound)
963: then
964: close c_get_tmplt_term_formula;
965:
966: hr_utility.set_location('User Defined Formula - HR_MOVE_TYPE_TEMPLATE does not exist.',65);
967:
968: -- Set to null so that we can calculate values differently later
969: l_term_formula_id := null;
970: else

Line 981: hr_utility.set_location('P_REPORT_DATE_FROM='||P_REPORT_DATE_FROM,70);

977: close c_get_term_formula;
978:
979: end if;
980: */
981: hr_utility.set_location('P_REPORT_DATE_FROM='||P_REPORT_DATE_FROM,70);
982:
983: for osv_rec in get_org_structure_version
984: (P_ORGANIZATION_STRUCTURE_ID
985: ,P_REPORT_DATE_FROM

Line 990: hr_utility.set_location('osv_rec.date_from ='||osv_rec.date_from,90);

986: ,P_REPORT_DATE_TO)
987:
988: loop
989:
990: hr_utility.set_location('osv_rec.date_from ='||osv_rec.date_from,90);
991: hr_utility.set_location('osv_rec.date_to ='||osv_rec.date_to,100);
992:
993: if P_REPORT_DATE_FROM > osv_rec.date_from then
994: P_DATE_FROM := P_REPORT_DATE_FROM;

Line 991: hr_utility.set_location('osv_rec.date_to ='||osv_rec.date_to,100);

987:
988: loop
989:
990: hr_utility.set_location('osv_rec.date_from ='||osv_rec.date_from,90);
991: hr_utility.set_location('osv_rec.date_to ='||osv_rec.date_to,100);
992:
993: if P_REPORT_DATE_FROM > osv_rec.date_from then
994: P_DATE_FROM := P_REPORT_DATE_FROM;
995: else

Line 999: hr_utility.set_location('P_DATE_FROM='||P_DATE_FROM,110);

995: else
996: P_DATE_FROM :=osv_rec.date_from;
997: end if;
998:
999: hr_utility.set_location('P_DATE_FROM='||P_DATE_FROM,110);
1000:
1001: if P_REPORT_DATE_TO < osv_rec.date_to then
1002: P_DATE_TO := P_REPORT_DATE_TO;
1003: else

Line 1015: hr_utility.set_location('l_cur_date_from ='||l_cur_date_from,118);

1011: if l_cur_date_from < osv_rec.date_from then
1012: l_cur_date_from := osv_rec.date_from;
1013: end if;
1014:
1015: hr_utility.set_location('l_cur_date_from ='||l_cur_date_from,118);
1016: hr_utility.set_location('l_cur_date_to ='||l_cur_date_to,119);
1017:
1018: hr_utility.set_location('P_DATE_TO ='||P_DATE_TO,120);
1019:

Line 1016: hr_utility.set_location('l_cur_date_to ='||l_cur_date_to,119);

1012: l_cur_date_from := osv_rec.date_from;
1013: end if;
1014:
1015: hr_utility.set_location('l_cur_date_from ='||l_cur_date_from,118);
1016: hr_utility.set_location('l_cur_date_to ='||l_cur_date_to,119);
1017:
1018: hr_utility.set_location('P_DATE_TO ='||P_DATE_TO,120);
1019:
1020: for ose_rec in get_org_structure_element

Line 1018: hr_utility.set_location('P_DATE_TO ='||P_DATE_TO,120);

1014:
1015: hr_utility.set_location('l_cur_date_from ='||l_cur_date_from,118);
1016: hr_utility.set_location('l_cur_date_to ='||l_cur_date_to,119);
1017:
1018: hr_utility.set_location('P_DATE_TO ='||P_DATE_TO,120);
1019:
1020: for ose_rec in get_org_structure_element
1021: (osv_rec.org_structure_version_id
1022: ,P_TOP_ORGANIZATION_ID)

Line 1055: hr_utility.set_location('osv_rec.org_structure_version_id='||osv_rec.org_structure_version_id,130);

1051: HQOrgData(ose_rec.org_structure_element_id).rev_cur_term := 0;
1052: HQOrgData(ose_rec.org_structure_element_id).nonrev_cur_term := 0;
1053:
1054:
1055: hr_utility.set_location('osv_rec.org_structure_version_id='||osv_rec.org_structure_version_id,130);
1056: hr_utility.set_location('ose_rec.organization_id ='||ose_rec.organization_id,140);
1057:
1058: for org_rec in get_organizations
1059: (osv_rec.org_structure_version_id -- P_ORG_STRUCTURE_VERSION_ID

Line 1056: hr_utility.set_location('ose_rec.organization_id ='||ose_rec.organization_id,140);

1052: HQOrgData(ose_rec.org_structure_element_id).nonrev_cur_term := 0;
1053:
1054:
1055: hr_utility.set_location('osv_rec.org_structure_version_id='||osv_rec.org_structure_version_id,130);
1056: hr_utility.set_location('ose_rec.organization_id ='||ose_rec.organization_id,140);
1057:
1058: for org_rec in get_organizations
1059: (osv_rec.org_structure_version_id -- P_ORG_STRUCTURE_VERSION_ID
1060: ,ose_rec.organization_id -- P_ORGANIZATION_ID

Line 1071: hr_utility.set_location('org_rec.organization_id='||org_rec.organization_id,150);

1067: l_nonrev_end_val :=0;
1068: l_rev_transfer_out :=0;
1069: l_nonrev_transfer_out:=0;
1070:
1071: hr_utility.set_location('org_rec.organization_id='||org_rec.organization_id,150);
1072:
1073: --changes for bug 6124652 starts here
1074: for asg_rec in get_assignment_start_end_fte
1075: (P_DATE_FROM

Line 1155: hr_utility.set_location('Movement Category 1 = '||l_movement_category,160);

1151: ,p_assignment_type => P_WORKER_TYPE
1152: ,p_movement_category => l_movement_category
1153: );
1154:
1155: hr_utility.set_location('Movement Category 1 = '||l_movement_category,160);
1156:
1157: if (l_movement_category = 'TRANSFER_OUT' or
1158: -- l_movement_category = 'SEPARATED' or
1159: l_movement_category = 'SUSPENDED' ) then

Line 1178: hr_utility.set_location('Beginning Head/FTE Count (R) = '||HQOrgData(ose_rec.org_structure_element_id).rev_start_val,170);

1174: HQOrgData(ose_rec.org_structure_element_id).rev_start_val + nvl(l_rev_start_val,0);
1175: HQOrgData(ose_rec.org_structure_element_id).nonrev_start_val :=
1176: HQOrgData(ose_rec.org_structure_element_id).nonrev_start_val + nvl(l_nonrev_start_val,0);
1177:
1178: hr_utility.set_location('Beginning Head/FTE Count (R) = '||HQOrgData(ose_rec.org_structure_element_id).rev_start_val,170);
1179: hr_utility.set_location('Beginning Head/FTE Count (N) = '||HQOrgData(ose_rec.org_structure_element_id).nonrev_start_val,180);
1180:
1181: HQOrgData(ose_rec.org_structure_element_id).rev_transfer_out :=
1182: HQOrgData(ose_rec.org_structure_element_id).rev_transfer_out + nvl(l_rev_transfer_out,0);

Line 1179: hr_utility.set_location('Beginning Head/FTE Count (N) = '||HQOrgData(ose_rec.org_structure_element_id).nonrev_start_val,180);

1175: HQOrgData(ose_rec.org_structure_element_id).nonrev_start_val :=
1176: HQOrgData(ose_rec.org_structure_element_id).nonrev_start_val + nvl(l_nonrev_start_val,0);
1177:
1178: hr_utility.set_location('Beginning Head/FTE Count (R) = '||HQOrgData(ose_rec.org_structure_element_id).rev_start_val,170);
1179: hr_utility.set_location('Beginning Head/FTE Count (N) = '||HQOrgData(ose_rec.org_structure_element_id).nonrev_start_val,180);
1180:
1181: HQOrgData(ose_rec.org_structure_element_id).rev_transfer_out :=
1182: HQOrgData(ose_rec.org_structure_element_id).rev_transfer_out + nvl(l_rev_transfer_out,0);
1183: HQOrgData(ose_rec.org_structure_element_id).nonrev_transfer_out :=

Line 1271: hr_utility.set_location('Movement Category 2 = '||l_movement_category,190);

1267:
1268: if (l_movement_category = 'TRANSFER_IN' or
1269: l_movement_category = 'REACTIVATED') then
1270:
1271: hr_utility.set_location('Movement Category 2 = '||l_movement_category,190);
1272: hr_utility.set_location('Organization ID = '||org_rec.organization_id,200);
1273: hr_utility.set_location('Assignment ID = '||asg_rec.assignment_id,210);
1274: hr_utility.set_location('Start Date = '||to_char(P_DATE_FROM,'DD-MON-YYYY'),220);
1275: hr_utility.set_location('End Date = '||to_char(P_DATE_TO,'DD-MON-YYYY'),230);

Line 1272: hr_utility.set_location('Organization ID = '||org_rec.organization_id,200);

1268: if (l_movement_category = 'TRANSFER_IN' or
1269: l_movement_category = 'REACTIVATED') then
1270:
1271: hr_utility.set_location('Movement Category 2 = '||l_movement_category,190);
1272: hr_utility.set_location('Organization ID = '||org_rec.organization_id,200);
1273: hr_utility.set_location('Assignment ID = '||asg_rec.assignment_id,210);
1274: hr_utility.set_location('Start Date = '||to_char(P_DATE_FROM,'DD-MON-YYYY'),220);
1275: hr_utility.set_location('End Date = '||to_char(P_DATE_TO,'DD-MON-YYYY'),230);
1276:

Line 1273: hr_utility.set_location('Assignment ID = '||asg_rec.assignment_id,210);

1269: l_movement_category = 'REACTIVATED') then
1270:
1271: hr_utility.set_location('Movement Category 2 = '||l_movement_category,190);
1272: hr_utility.set_location('Organization ID = '||org_rec.organization_id,200);
1273: hr_utility.set_location('Assignment ID = '||asg_rec.assignment_id,210);
1274: hr_utility.set_location('Start Date = '||to_char(P_DATE_FROM,'DD-MON-YYYY'),220);
1275: hr_utility.set_location('End Date = '||to_char(P_DATE_TO,'DD-MON-YYYY'),230);
1276:
1277: if l_jobcatg = 'Y'

Line 1274: hr_utility.set_location('Start Date = '||to_char(P_DATE_FROM,'DD-MON-YYYY'),220);

1270:
1271: hr_utility.set_location('Movement Category 2 = '||l_movement_category,190);
1272: hr_utility.set_location('Organization ID = '||org_rec.organization_id,200);
1273: hr_utility.set_location('Assignment ID = '||asg_rec.assignment_id,210);
1274: hr_utility.set_location('Start Date = '||to_char(P_DATE_FROM,'DD-MON-YYYY'),220);
1275: hr_utility.set_location('End Date = '||to_char(P_DATE_TO,'DD-MON-YYYY'),230);
1276:
1277: if l_jobcatg = 'Y'
1278: then

Line 1275: hr_utility.set_location('End Date = '||to_char(P_DATE_TO,'DD-MON-YYYY'),230);

1271: hr_utility.set_location('Movement Category 2 = '||l_movement_category,190);
1272: hr_utility.set_location('Organization ID = '||org_rec.organization_id,200);
1273: hr_utility.set_location('Assignment ID = '||asg_rec.assignment_id,210);
1274: hr_utility.set_location('Start Date = '||to_char(P_DATE_FROM,'DD-MON-YYYY'),220);
1275: hr_utility.set_location('End Date = '||to_char(P_DATE_TO,'DD-MON-YYYY'),230);
1276:
1277: if l_jobcatg = 'Y'
1278: then
1279: l_rev_transfer_in := l_rev_transfer_in + l_abv;

Line 1302: hr_utility.set_location('New Hire = '||l_cur_nh,240);

1298: , p_assignment_type => P_WORKER_TYPE
1299: , p_cur_date_from => l_cur_date_from
1300: , p_cur_date_to => l_cur_date_to);
1301:
1302: hr_utility.set_location('New Hire = '||l_cur_nh,240);
1303:
1304: if l_cur_nh = 'Y' then
1305:
1306: if l_jobcatg = 'Y'

Line 1319: hr_utility.set_location('org_structure_element_id = '||ose_rec.org_structure_element_id,250);

1315: end if;
1316:
1317: end loop; -- get_assignment_start_end
1318:
1319: hr_utility.set_location('org_structure_element_id = '||ose_rec.org_structure_element_id,250);
1320: HQOrgData(ose_rec.org_structure_element_id).rev_end_val :=
1321: HQOrgData(ose_rec.org_structure_element_id).rev_end_val + nvl(l_rev_end_val,0);
1322: HQOrgData(ose_rec.org_structure_element_id).nonrev_end_val :=
1323: HQOrgData(ose_rec.org_structure_element_id).nonrev_end_val + nvl(l_nonrev_end_val,0);

Line 1325: hr_utility.set_location('Ending HeadCount (R) = '||HQOrgData(ose_rec.org_structure_element_id).rev_end_val,260);

1321: HQOrgData(ose_rec.org_structure_element_id).rev_end_val + nvl(l_rev_end_val,0);
1322: HQOrgData(ose_rec.org_structure_element_id).nonrev_end_val :=
1323: HQOrgData(ose_rec.org_structure_element_id).nonrev_end_val + nvl(l_nonrev_end_val,0);
1324:
1325: hr_utility.set_location('Ending HeadCount (R) = '||HQOrgData(ose_rec.org_structure_element_id).rev_end_val,260);
1326: hr_utility.set_location('Ending HeadCount (N) = '||HQOrgData(ose_rec.org_structure_element_id).nonrev_end_val,270);
1327:
1328: HQOrgData(ose_rec.org_structure_element_id).rev_transfer_in :=
1329: HQOrgData(ose_rec.org_structure_element_id).rev_transfer_in + nvl(l_rev_transfer_in,0);

Line 1326: hr_utility.set_location('Ending HeadCount (N) = '||HQOrgData(ose_rec.org_structure_element_id).nonrev_end_val,270);

1322: HQOrgData(ose_rec.org_structure_element_id).nonrev_end_val :=
1323: HQOrgData(ose_rec.org_structure_element_id).nonrev_end_val + nvl(l_nonrev_end_val,0);
1324:
1325: hr_utility.set_location('Ending HeadCount (R) = '||HQOrgData(ose_rec.org_structure_element_id).rev_end_val,260);
1326: hr_utility.set_location('Ending HeadCount (N) = '||HQOrgData(ose_rec.org_structure_element_id).nonrev_end_val,270);
1327:
1328: HQOrgData(ose_rec.org_structure_element_id).rev_transfer_in :=
1329: HQOrgData(ose_rec.org_structure_element_id).rev_transfer_in + nvl(l_rev_transfer_in,0);
1330:

Line 1333: hr_utility.set_location('Transfer In',2701);

1329: HQOrgData(ose_rec.org_structure_element_id).rev_transfer_in + nvl(l_rev_transfer_in,0);
1330:
1331: HQOrgData(ose_rec.org_structure_element_id).nonrev_transfer_in :=
1332: HQOrgData(ose_rec.org_structure_element_id).nonrev_transfer_in + nvl(l_nonrev_transfer_in,0);
1333: hr_utility.set_location('Transfer In',2701);
1334:
1335: HQOrgData(ose_rec.org_structure_element_id).rev_nh :=
1336: HQOrgData(ose_rec.org_structure_element_id).rev_nh + nvl(l_rev_nh,0);
1337: HQOrgData(ose_rec.org_structure_element_id).nonrev_nh :=

Line 1340: hr_utility.set_location('New Hire',2702);

1336: HQOrgData(ose_rec.org_structure_element_id).rev_nh + nvl(l_rev_nh,0);
1337: HQOrgData(ose_rec.org_structure_element_id).nonrev_nh :=
1338: HQOrgData(ose_rec.org_structure_element_id).nonrev_nh + nvl(l_nonrev_nh,0);
1339:
1340: hr_utility.set_location('New Hire',2702);
1341:
1342: HQOrgData(ose_rec.org_structure_element_id).rev_cur_nh :=
1343: HQOrgData(ose_rec.org_structure_element_id).rev_cur_nh + nvl(l_rev_cur_nh,0);
1344: HQOrgData(ose_rec.org_structure_element_id).nonrev_cur_nh :=

Line 1347: hr_utility.set_location('Current New Hire',2703);

1343: HQOrgData(ose_rec.org_structure_element_id).rev_cur_nh + nvl(l_rev_cur_nh,0);
1344: HQOrgData(ose_rec.org_structure_element_id).nonrev_cur_nh :=
1345: HQOrgData(ose_rec.org_structure_element_id).nonrev_cur_nh + nvl(l_nonrev_cur_nh,0);
1346:
1347: hr_utility.set_location('Current New Hire',2703);
1348:
1349: l_rev_transfer_in := 0;
1350: l_nonrev_transfer_in := 0;
1351: l_rev_nh := 0;

Line 1356: hr_utility.set_location('Current Organization',2704);

1352: l_nonrev_nh := 0;
1353: l_rev_cur_nh := 0;
1354: l_nonrev_cur_nh := 0;
1355:
1356: hr_utility.set_location('Current Organization',2704);
1357:
1358: -- For the Current Organization
1359:
1360: for assgt_rec in get_assignment

Line 1370: hr_utility.set_location('Current Organization',2705);

1366: , P_INCLUDE_ASG_TYPE)
1367:
1368: loop -- get_assignment
1369:
1370: hr_utility.set_location('Current Organization',2705);
1371:
1372: hr_utility.set_location('l_AsgWorkerType_formula_id = '||to_char(l_AsgWorkerType_formula_id),275);
1373: hr_utility.set_location('assgt_rec.assignment_id = '||to_char(assgt_rec.assignment_id),275);
1374: hr_utility.set_location('assgt_rec.effective_start_date = '||to_char(assgt_rec.effective_start_date,'DD/MM/YYYY'),275);

Line 1372: hr_utility.set_location('l_AsgWorkerType_formula_id = '||to_char(l_AsgWorkerType_formula_id),275);

1368: loop -- get_assignment
1369:
1370: hr_utility.set_location('Current Organization',2705);
1371:
1372: hr_utility.set_location('l_AsgWorkerType_formula_id = '||to_char(l_AsgWorkerType_formula_id),275);
1373: hr_utility.set_location('assgt_rec.assignment_id = '||to_char(assgt_rec.assignment_id),275);
1374: hr_utility.set_location('assgt_rec.effective_start_date = '||to_char(assgt_rec.effective_start_date,'DD/MM/YYYY'),275);
1375:
1376: if assgt_rec.assignment_type <> 'C' then

Line 1373: hr_utility.set_location('assgt_rec.assignment_id = '||to_char(assgt_rec.assignment_id),275);

1369:
1370: hr_utility.set_location('Current Organization',2705);
1371:
1372: hr_utility.set_location('l_AsgWorkerType_formula_id = '||to_char(l_AsgWorkerType_formula_id),275);
1373: hr_utility.set_location('assgt_rec.assignment_id = '||to_char(assgt_rec.assignment_id),275);
1374: hr_utility.set_location('assgt_rec.effective_start_date = '||to_char(assgt_rec.effective_start_date,'DD/MM/YYYY'),275);
1375:
1376: if assgt_rec.assignment_type <> 'C' then
1377:

Line 1374: hr_utility.set_location('assgt_rec.effective_start_date = '||to_char(assgt_rec.effective_start_date,'DD/MM/YYYY'),275);

1370: hr_utility.set_location('Current Organization',2705);
1371:
1372: hr_utility.set_location('l_AsgWorkerType_formula_id = '||to_char(l_AsgWorkerType_formula_id),275);
1373: hr_utility.set_location('assgt_rec.assignment_id = '||to_char(assgt_rec.assignment_id),275);
1374: hr_utility.set_location('assgt_rec.effective_start_date = '||to_char(assgt_rec.effective_start_date,'DD/MM/YYYY'),275);
1375:
1376: if assgt_rec.assignment_type <> 'C' then
1377:
1378: l_pertype := NULL;

Line 1388: hr_utility.set_location('AsgWorkerType = '||l_pertype,280);

1384: );
1385:
1386: end if;
1387:
1388: hr_utility.set_location('AsgWorkerType = '||l_pertype,280);
1389:
1390: l_jobcatg := NULL;
1391: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1392: (assgt_rec.job_id

Line 1402: hr_utility.set_location('l_abv = '||l_abv,290);

1398: , p_assignment_id => assgt_rec.assignment_id
1399: , p_effective_date => assgt_rec.effective_start_date
1400: , p_session_date => trunc(sysdate) );
1401:
1402: hr_utility.set_location('l_abv = '||l_abv,290);
1403: hr_utility.set_location('l_jobcatg = '||l_jobcatg,300);
1404: hr_utility.set_location('l_pertype = '||l_pertype,310);
1405:
1406: if l_pertype = 'P' then

Line 1403: hr_utility.set_location('l_jobcatg = '||l_jobcatg,300);

1399: , p_effective_date => assgt_rec.effective_start_date
1400: , p_session_date => trunc(sysdate) );
1401:
1402: hr_utility.set_location('l_abv = '||l_abv,290);
1403: hr_utility.set_location('l_jobcatg = '||l_jobcatg,300);
1404: hr_utility.set_location('l_pertype = '||l_pertype,310);
1405:
1406: if l_pertype = 'P' then
1407:

Line 1404: hr_utility.set_location('l_pertype = '||l_pertype,310);

1400: , p_session_date => trunc(sysdate) );
1401:
1402: hr_utility.set_location('l_abv = '||l_abv,290);
1403: hr_utility.set_location('l_jobcatg = '||l_jobcatg,300);
1404: hr_utility.set_location('l_pertype = '||l_pertype,310);
1405:
1406: if l_pertype = 'P' then
1407:
1408: if l_jobcatg = 'Y'

Line 1415: hr_utility.set_location('Rev Perm = '||to_char(l_rev_perm),320);

1411: else
1412: l_nonrev_perm := l_nonrev_perm + l_abv;
1413: end if;
1414:
1415: hr_utility.set_location('Rev Perm = '||to_char(l_rev_perm),320);
1416: hr_utility.set_location('NonRev Perm = '||to_char(l_nonrev_perm),330);
1417:
1418: elsif l_pertype = 'T' then
1419:

Line 1416: hr_utility.set_location('NonRev Perm = '||to_char(l_nonrev_perm),330);

1412: l_nonrev_perm := l_nonrev_perm + l_abv;
1413: end if;
1414:
1415: hr_utility.set_location('Rev Perm = '||to_char(l_rev_perm),320);
1416: hr_utility.set_location('NonRev Perm = '||to_char(l_nonrev_perm),330);
1417:
1418: elsif l_pertype = 'T' then
1419:
1420: if l_jobcatg = 'Y'

Line 1465: hr_utility.set_location('Permanent (R) = '||HQOrgData(ose_rec.org_structure_element_id).rev_perm,340);

1461:
1462: l_rev_perm := 0;
1463: l_nonrev_perm := 0;
1464:
1465: hr_utility.set_location('Permanent (R) = '||HQOrgData(ose_rec.org_structure_element_id).rev_perm,340);
1466: hr_utility.set_location('Permanent (N) = '||HQOrgData(ose_rec.org_structure_element_id).nonrev_perm,350);
1467:
1468: HQOrgData(ose_rec.org_structure_element_id).rev_temp :=
1469: HQOrgData(ose_rec.org_structure_element_id).rev_temp + nvl(l_rev_temp,0);

Line 1466: hr_utility.set_location('Permanent (N) = '||HQOrgData(ose_rec.org_structure_element_id).nonrev_perm,350);

1462: l_rev_perm := 0;
1463: l_nonrev_perm := 0;
1464:
1465: hr_utility.set_location('Permanent (R) = '||HQOrgData(ose_rec.org_structure_element_id).rev_perm,340);
1466: hr_utility.set_location('Permanent (N) = '||HQOrgData(ose_rec.org_structure_element_id).nonrev_perm,350);
1467:
1468: HQOrgData(ose_rec.org_structure_element_id).rev_temp :=
1469: HQOrgData(ose_rec.org_structure_element_id).rev_temp + nvl(l_rev_temp,0);
1470: HQOrgData(ose_rec.org_structure_element_id).nonrev_temp :=

Line 1488: hr_utility.set_location('Permanent HeadCount (R) = '||HQOrgData(ose_rec.org_structure_element_id).rev_perm,360);

1484:
1485: HQOrgData(ose_rec.org_structure_element_id).rev_open_offers := 0;
1486: HQOrgData(ose_rec.org_structure_element_id).nonrev_open_offers := 0;
1487:
1488: hr_utility.set_location('Permanent HeadCount (R) = '||HQOrgData(ose_rec.org_structure_element_id).rev_perm,360);
1489: hr_utility.set_location('Permanent HeadCount (N) = '||HQOrgData(ose_rec.org_structure_element_id).nonrev_perm,370);
1490:
1491: l_rev_open_offers := 0;
1492: l_nonrev_open_offers := 0;

Line 1489: hr_utility.set_location('Permanent HeadCount (N) = '||HQOrgData(ose_rec.org_structure_element_id).nonrev_perm,370);

1485: HQOrgData(ose_rec.org_structure_element_id).rev_open_offers := 0;
1486: HQOrgData(ose_rec.org_structure_element_id).nonrev_open_offers := 0;
1487:
1488: hr_utility.set_location('Permanent HeadCount (R) = '||HQOrgData(ose_rec.org_structure_element_id).rev_perm,360);
1489: hr_utility.set_location('Permanent HeadCount (N) = '||HQOrgData(ose_rec.org_structure_element_id).nonrev_perm,370);
1490:
1491: l_rev_open_offers := 0;
1492: l_nonrev_open_offers := 0;
1493:

Line 1590: hr_utility.set_location('Organization ID............ '||org_rec.organization_id,400);

1586: HQOrgData(ose_rec.org_structure_element_id).rev_vacant_FTE + l_rev_vacant_FTE;
1587: HQOrgData(ose_rec.org_structure_element_id).nonrev_vacant_FTE :=
1588: HQOrgData(ose_rec.org_structure_element_id).nonrev_vacant_FTE + l_nonrev_vacant_FTE;
1589:
1590: hr_utility.set_location('Organization ID............ '||org_rec.organization_id,400);
1591:
1592: if P_WORKER_TYPE <> 'C' then
1593:
1594: hr_utility.set_location('Start of Worker Type <> C Current Terminations.......',405);

Line 1594: hr_utility.set_location('Start of Worker Type <> C Current Terminations.......',405);

1590: hr_utility.set_location('Organization ID............ '||org_rec.organization_id,400);
1591:
1592: if P_WORKER_TYPE <> 'C' then
1593:
1594: hr_utility.set_location('Start of Worker Type <> C Current Terminations.......',405);
1595:
1596: l_rev_cur_term :=0;
1597: l_nonrev_cur_term :=0;
1598:

Line 1637: hr_utility.set_location('End of Worker Type <> C Current Terminations.......',450);

1633: HQOrgData(ose_rec.org_structure_element_id).rev_cur_term + nvl(l_rev_cur_term,0);
1634: HQOrgData(ose_rec.org_structure_element_id).nonrev_cur_term :=
1635: HQOrgData(ose_rec.org_structure_element_id).nonrev_cur_term + nvl(l_nonrev_cur_term,0);
1636:
1637: hr_utility.set_location('End of Worker Type <> C Current Terminations.......',450);
1638:
1639: l_rev_vol_term :=0;
1640: l_nonrev_vol_term :=0;
1641: l_rev_invol_term :=0;

Line 1644: hr_utility.set_location('Start of Worker Type <> C Terminations.......',460);

1640: l_nonrev_vol_term :=0;
1641: l_rev_invol_term :=0;
1642: l_nonrev_invol_term :=0;
1643:
1644: hr_utility.set_location('Start of Worker Type <> C Terminations.......',460);
1645: hr_utility.set_location('E Rev Vol T = '||l_rev_vol_term||'..........'||
1646: HQOrgData(ose_rec.org_structure_element_id).rev_vol_term,480);
1647:
1648: for term_rec in get_terminations

Line 1645: hr_utility.set_location('E Rev Vol T = '||l_rev_vol_term||'..........'||

1641: l_rev_invol_term :=0;
1642: l_nonrev_invol_term :=0;
1643:
1644: hr_utility.set_location('Start of Worker Type <> C Terminations.......',460);
1645: hr_utility.set_location('E Rev Vol T = '||l_rev_vol_term||'..........'||
1646: HQOrgData(ose_rec.org_structure_element_id).rev_vol_term,480);
1647:
1648: for term_rec in get_terminations
1649: ( P_DATE_FROM

Line 1656: hr_utility.set_location('Leaving Reason = '||term_rec.leaving_reason,465);

1652: , P_BUSINESS_GROUP_ID)
1653:
1654: loop -- get_terminations
1655:
1656: hr_utility.set_location('Leaving Reason = '||term_rec.leaving_reason,465);
1657:
1658: l_termtype:= NULL;
1659: l_termtype:= HR_PERSON_FLEX_LOGIC.GetTermType
1660: (p_term_formula_id => l_term_formula_id

Line 1664: hr_utility.set_location('Term Type = '||l_termtype,470);

1660: (p_term_formula_id => l_term_formula_id
1661: ,p_leaving_reason => term_rec.leaving_reason
1662: ,p_session_date => trunc(sysdate));
1663:
1664: hr_utility.set_location('Term Type = '||l_termtype,470);
1665:
1666: l_jobcatg := NULL;
1667: l_abv := NULL;
1668:

Line 1680: hr_utility.set_location('Job Category = '||l_jobcatg,475);

1676: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1677: (term_rec.job_id
1678: ,p_job_category);
1679:
1680: hr_utility.set_location('Job Category = '||l_jobcatg,475);
1681:
1682: if l_termtype = 'V'
1683: then
1684: if l_jobcatg = 'Y'

Line 1702: hr_utility.set_location('E Rev Vol T = '||l_rev_vol_term||'..........'||

1698: end if;
1699:
1700: end loop; -- get_terminations
1701:
1702: hr_utility.set_location('E Rev Vol T = '||l_rev_vol_term||'..........'||
1703: HQOrgData(ose_rec.org_structure_element_id).rev_vol_term,480);
1704: hr_utility.set_location('E NonRev Vol T = '||l_nonrev_vol_term||'.......'||
1705: HQOrgData(ose_rec.org_structure_element_id).nonrev_vol_term,485);
1706:

Line 1704: hr_utility.set_location('E NonRev Vol T = '||l_nonrev_vol_term||'.......'||

1700: end loop; -- get_terminations
1701:
1702: hr_utility.set_location('E Rev Vol T = '||l_rev_vol_term||'..........'||
1703: HQOrgData(ose_rec.org_structure_element_id).rev_vol_term,480);
1704: hr_utility.set_location('E NonRev Vol T = '||l_nonrev_vol_term||'.......'||
1705: HQOrgData(ose_rec.org_structure_element_id).nonrev_vol_term,485);
1706:
1707: hr_utility.set_location('E Rev InVol T = '||l_rev_invol_term||'........'||
1708: HQOrgData(ose_rec.org_structure_element_id).rev_invol_term,490);

Line 1707: hr_utility.set_location('E Rev InVol T = '||l_rev_invol_term||'........'||

1703: HQOrgData(ose_rec.org_structure_element_id).rev_vol_term,480);
1704: hr_utility.set_location('E NonRev Vol T = '||l_nonrev_vol_term||'.......'||
1705: HQOrgData(ose_rec.org_structure_element_id).nonrev_vol_term,485);
1706:
1707: hr_utility.set_location('E Rev InVol T = '||l_rev_invol_term||'........'||
1708: HQOrgData(ose_rec.org_structure_element_id).rev_invol_term,490);
1709: hr_utility.set_location('E NonRev InVol T = '||l_nonrev_invol_term||'.....'||
1710: HQOrgData(ose_rec.org_structure_element_id).nonrev_invol_term,495);
1711:

Line 1709: hr_utility.set_location('E NonRev InVol T = '||l_nonrev_invol_term||'.....'||

1705: HQOrgData(ose_rec.org_structure_element_id).nonrev_vol_term,485);
1706:
1707: hr_utility.set_location('E Rev InVol T = '||l_rev_invol_term||'........'||
1708: HQOrgData(ose_rec.org_structure_element_id).rev_invol_term,490);
1709: hr_utility.set_location('E NonRev InVol T = '||l_nonrev_invol_term||'.....'||
1710: HQOrgData(ose_rec.org_structure_element_id).nonrev_invol_term,495);
1711:
1712: HQOrgData(ose_rec.org_structure_element_id).rev_vol_term :=
1713: HQOrgData(ose_rec.org_structure_element_id).rev_vol_term + nvl(l_rev_vol_term,0);

Line 1727: hr_utility.set_location('End of Worker Type <> C Terminations.......',500);

1723: l_nonrev_vol_term :=0;
1724: l_rev_invol_term :=0;
1725: l_nonrev_invol_term :=0;
1726:
1727: hr_utility.set_location('End of Worker Type <> C Terminations.......',500);
1728:
1729: end if;
1730:
1731: if P_WORKER_TYPE <> 'E' then

Line 1733: hr_utility.set_location('Start of Worker Type <> E Current Terminations.......',505);

1729: end if;
1730:
1731: if P_WORKER_TYPE <> 'E' then
1732:
1733: hr_utility.set_location('Start of Worker Type <> E Current Terminations.......',505);
1734:
1735: l_rev_cur_term :=0;
1736: l_nonrev_cur_term :=0;
1737:

Line 1776: hr_utility.set_location('End of Worker Type <> E Current Terminations.......',550);

1772: HQOrgData(ose_rec.org_structure_element_id).rev_cur_term + nvl(l_rev_cur_term,0);
1773: HQOrgData(ose_rec.org_structure_element_id).nonrev_cur_term :=
1774: HQOrgData(ose_rec.org_structure_element_id).nonrev_cur_term + nvl(l_nonrev_cur_term,0);
1775:
1776: hr_utility.set_location('End of Worker Type <> E Current Terminations.......',550);
1777:
1778: l_rev_vol_term :=0;
1779: l_nonrev_vol_term :=0;
1780: l_rev_invol_term :=0;

Line 1783: hr_utility.set_location('Start of Worker Type <> E Terminations.......',560);

1779: l_nonrev_vol_term :=0;
1780: l_rev_invol_term :=0;
1781: l_nonrev_invol_term :=0;
1782:
1783: hr_utility.set_location('Start of Worker Type <> E Terminations.......',560);
1784:
1785: for term_rec in get_terminations_cwk
1786: ( P_DATE_FROM
1787: , P_DATE_TO

Line 1802: hr_utility.set_location('Term Type = '||l_cwk_termtype,470);

1798: (p_term_formula_id => l_cwk_term_formula_id
1799: ,p_leaving_reason => term_rec.termination_reason
1800: ,p_session_date => trunc(sysdate));
1801:
1802: hr_utility.set_location('Term Type = '||l_cwk_termtype,470);
1803:
1804: l_abv := HR_PERSON_FLEX_LOGIC.GetABV
1805: ( p_ABV_formula_id => l_ABV_formula_id
1806: , p_ABV => p_budget

Line 1815: -- hr_utility.set_location('Job Categ = '||l_jobcatg,565);

1811: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1812: (term_rec.job_id
1813: ,p_job_category);
1814:
1815: -- hr_utility.set_location('Job Categ = '||l_jobcatg,565);
1816:
1817: if l_cwk_termtype = 'V'
1818: then
1819: if l_jobcatg = 'Y'

Line 1837: hr_utility.set_location('C Rev Vol T = '||l_rev_vol_term,570);

1833: end if;
1834:
1835: end loop; -- get_terminations_cwk
1836:
1837: hr_utility.set_location('C Rev Vol T = '||l_rev_vol_term,570);
1838: hr_utility.set_location('C NONRev Vol T = '||l_nonrev_vol_term,575);
1839:
1840: hr_utility.set_location('C Rev InVol T = '||l_rev_vol_term,580);
1841: hr_utility.set_location('C NONRev InVol T = '||l_nonrev_vol_term,585);

Line 1838: hr_utility.set_location('C NONRev Vol T = '||l_nonrev_vol_term,575);

1834:
1835: end loop; -- get_terminations_cwk
1836:
1837: hr_utility.set_location('C Rev Vol T = '||l_rev_vol_term,570);
1838: hr_utility.set_location('C NONRev Vol T = '||l_nonrev_vol_term,575);
1839:
1840: hr_utility.set_location('C Rev InVol T = '||l_rev_vol_term,580);
1841: hr_utility.set_location('C NONRev InVol T = '||l_nonrev_vol_term,585);
1842:

Line 1840: hr_utility.set_location('C Rev InVol T = '||l_rev_vol_term,580);

1836:
1837: hr_utility.set_location('C Rev Vol T = '||l_rev_vol_term,570);
1838: hr_utility.set_location('C NONRev Vol T = '||l_nonrev_vol_term,575);
1839:
1840: hr_utility.set_location('C Rev InVol T = '||l_rev_vol_term,580);
1841: hr_utility.set_location('C NONRev InVol T = '||l_nonrev_vol_term,585);
1842:
1843: HQOrgData(ose_rec.org_structure_element_id).rev_vol_term :=
1844: HQOrgData(ose_rec.org_structure_element_id).rev_vol_term + nvl(l_rev_vol_term,0);

Line 1841: hr_utility.set_location('C NONRev InVol T = '||l_nonrev_vol_term,585);

1837: hr_utility.set_location('C Rev Vol T = '||l_rev_vol_term,570);
1838: hr_utility.set_location('C NONRev Vol T = '||l_nonrev_vol_term,575);
1839:
1840: hr_utility.set_location('C Rev InVol T = '||l_rev_vol_term,580);
1841: hr_utility.set_location('C NONRev InVol T = '||l_nonrev_vol_term,585);
1842:
1843: HQOrgData(ose_rec.org_structure_element_id).rev_vol_term :=
1844: HQOrgData(ose_rec.org_structure_element_id).rev_vol_term + nvl(l_rev_vol_term,0);
1845: HQOrgData(ose_rec.org_structure_element_id).nonrev_vol_term :=

Line 1853: hr_utility.set_location('End of Worker Type <> E Terminations.......',600);

1849: l_nonrev_vol_term :=0;
1850: l_rev_invol_term :=0;
1851: l_nonrev_invol_term :=0;
1852:
1853: hr_utility.set_location('End of Worker Type <> E Terminations.......',600);
1854:
1855: end if;
1856:
1857: if P_WORKER_TYPE = 'B' then

Line 1859: hr_utility.set_location('Worker Type = B Terminations.......',605);

1855: end if;
1856:
1857: if P_WORKER_TYPE = 'B' then
1858:
1859: hr_utility.set_location('Worker Type = B Terminations.......',605);
1860:
1861: HQOrgData(ose_rec.org_structure_element_id).rev_vol_term :=
1862: HQOrgData(ose_rec.org_structure_element_id).rev_vol_term +
1863: HQOrgData(ose_rec.org_structure_element_id).rev_invol_term;

Line 1878: hr_utility.set_location('P_INCLUDE_TOP_ORG = Y',800);

1874: -- This is the start of the TOP Organization story for a version
1875:
1876: if P_INCLUDE_TOP_ORG = 'Y' then
1877:
1878: hr_utility.set_location('P_INCLUDE_TOP_ORG = Y',800);
1879:
1880: HQOrgData(1-(osv_rec.org_structure_version_id+P_TOP_ORGANIZATION_ID)).rev_start_val := 0;
1881: HQOrgData(1-(osv_rec.org_structure_version_id+P_TOP_ORGANIZATION_ID)).rev_end_val := 0;
1882: HQOrgData(1-(osv_rec.org_structure_version_id+P_TOP_ORGANIZATION_ID)).nonrev_start_val := 0;

Line 1908: hr_utility.set_location('Top Organization ='||(1-(osv_rec.org_structure_version_id+P_TOP_ORGANIZATION_ID)),810);

1904: HQOrgData(1-(osv_rec.org_structure_version_id+P_TOP_ORGANIZATION_ID)).rev_cur_term := 0;
1905: HQOrgData(1-(osv_rec.org_structure_version_id+P_TOP_ORGANIZATION_ID)).nonrev_cur_term := 0;
1906:
1907:
1908: hr_utility.set_location('Top Organization ='||(1-(osv_rec.org_structure_version_id+P_TOP_ORGANIZATION_ID)),810);
1909: hr_utility.set_location('osv_rec.org_structure_version_id = '||osv_rec.org_structure_version_id,820);
1910: hr_utility.set_location('P_TOP_ORGANIZATION_ID = '||P_TOP_ORGANIZATION_ID,830);
1911:
1912: l_rev_start_val :=0;

Line 1909: hr_utility.set_location('osv_rec.org_structure_version_id = '||osv_rec.org_structure_version_id,820);

1905: HQOrgData(1-(osv_rec.org_structure_version_id+P_TOP_ORGANIZATION_ID)).nonrev_cur_term := 0;
1906:
1907:
1908: hr_utility.set_location('Top Organization ='||(1-(osv_rec.org_structure_version_id+P_TOP_ORGANIZATION_ID)),810);
1909: hr_utility.set_location('osv_rec.org_structure_version_id = '||osv_rec.org_structure_version_id,820);
1910: hr_utility.set_location('P_TOP_ORGANIZATION_ID = '||P_TOP_ORGANIZATION_ID,830);
1911:
1912: l_rev_start_val :=0;
1913: l_rev_end_val :=0;

Line 1910: hr_utility.set_location('P_TOP_ORGANIZATION_ID = '||P_TOP_ORGANIZATION_ID,830);

1906:
1907:
1908: hr_utility.set_location('Top Organization ='||(1-(osv_rec.org_structure_version_id+P_TOP_ORGANIZATION_ID)),810);
1909: hr_utility.set_location('osv_rec.org_structure_version_id = '||osv_rec.org_structure_version_id,820);
1910: hr_utility.set_location('P_TOP_ORGANIZATION_ID = '||P_TOP_ORGANIZATION_ID,830);
1911:
1912: l_rev_start_val :=0;
1913: l_rev_end_val :=0;
1914: l_nonrev_start_val :=0;

Line 1947: hr_utility.set_location('Top Org l_jobcatg = '||l_jobcatg,880);

1943: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1944: (asg_rec.job_id
1945: ,p_job_category);
1946:
1947: hr_utility.set_location('Top Org l_jobcatg = '||l_jobcatg,880);
1948:
1949: if l_jobcatg = 'Y'
1950: then
1951: l_rev_start_val := l_rev_start_val + l_abv;

Line 1979: hr_utility.set_location('Top Org Assignment ID = '||asg_rec.assignment_id,840);

1975: , p_assignment_id => asg_rec.assignment_id
1976: , p_effective_date => asg_rec.effective_start_date
1977: , p_session_date => trunc(sysdate) );
1978:
1979: hr_utility.set_location('Top Org Assignment ID = '||asg_rec.assignment_id,840);
1980: hr_utility.set_location('Top Org Effective Start Date = '||to_char(asg_rec.effective_start_date,'DD/MM/YYYY'),850);
1981: hr_utility.set_location('Top Org Job ID = '||asg_rec.job_id,860);
1982: hr_utility.set_location('Top Org l_abv = '||l_abv,870);
1983:

Line 1980: hr_utility.set_location('Top Org Effective Start Date = '||to_char(asg_rec.effective_start_date,'DD/MM/YYYY'),850);

1976: , p_effective_date => asg_rec.effective_start_date
1977: , p_session_date => trunc(sysdate) );
1978:
1979: hr_utility.set_location('Top Org Assignment ID = '||asg_rec.assignment_id,840);
1980: hr_utility.set_location('Top Org Effective Start Date = '||to_char(asg_rec.effective_start_date,'DD/MM/YYYY'),850);
1981: hr_utility.set_location('Top Org Job ID = '||asg_rec.job_id,860);
1982: hr_utility.set_location('Top Org l_abv = '||l_abv,870);
1983:
1984: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory

Line 1981: hr_utility.set_location('Top Org Job ID = '||asg_rec.job_id,860);

1977: , p_session_date => trunc(sysdate) );
1978:
1979: hr_utility.set_location('Top Org Assignment ID = '||asg_rec.assignment_id,840);
1980: hr_utility.set_location('Top Org Effective Start Date = '||to_char(asg_rec.effective_start_date,'DD/MM/YYYY'),850);
1981: hr_utility.set_location('Top Org Job ID = '||asg_rec.job_id,860);
1982: hr_utility.set_location('Top Org l_abv = '||l_abv,870);
1983:
1984: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1985: (asg_rec.job_id

Line 1982: hr_utility.set_location('Top Org l_abv = '||l_abv,870);

1978:
1979: hr_utility.set_location('Top Org Assignment ID = '||asg_rec.assignment_id,840);
1980: hr_utility.set_location('Top Org Effective Start Date = '||to_char(asg_rec.effective_start_date,'DD/MM/YYYY'),850);
1981: hr_utility.set_location('Top Org Job ID = '||asg_rec.job_id,860);
1982: hr_utility.set_location('Top Org l_abv = '||l_abv,870);
1983:
1984: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1985: (asg_rec.job_id
1986: ,p_job_category);

Line 1988: hr_utility.set_location('Top Org l_jobcatg = '||l_jobcatg,880);

1984: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
1985: (asg_rec.job_id
1986: ,p_job_category);
1987:
1988: hr_utility.set_location('Top Org l_jobcatg = '||l_jobcatg,880);
1989:
1990: /* if l_jobcatg = 'Y'
1991: then
1992: l_rev_start_val := l_rev_start_val + l_abv;

Line 2009: hr_utility.set_location('Top Org l_movement_category = '||l_movement_category,890);

2005: ,p_assignment_type => P_WORKER_TYPE
2006: ,p_movement_category => l_movement_category
2007: );
2008:
2009: hr_utility.set_location('Top Org l_movement_category = '||l_movement_category,890);
2010:
2011: if (l_movement_category = 'TRANSFER_OUT' or
2012: -- l_movement_category = 'SEPARATED' or
2013: l_movement_category = 'SUSPENDED' ) then

Line 2125: hr_utility.set_location('Top Org l_movement_category2 = '||l_movement_category,900);

2121:
2122: if (l_movement_category = 'TRANSFER_IN' or
2123: l_movement_category = 'REACTIVATED') then
2124:
2125: hr_utility.set_location('Top Org l_movement_category2 = '||l_movement_category,900);
2126: hr_utility.set_location('Top Org Start Date = '||to_char(P_DATE_FROM,'DD-MON-YYYY'),910);
2127: hr_utility.set_location('Top Org End Date = '||to_char(P_DATE_TO,'DD-MON-YYYY'),920);
2128:
2129: if l_jobcatg = 'Y'

Line 2126: hr_utility.set_location('Top Org Start Date = '||to_char(P_DATE_FROM,'DD-MON-YYYY'),910);

2122: if (l_movement_category = 'TRANSFER_IN' or
2123: l_movement_category = 'REACTIVATED') then
2124:
2125: hr_utility.set_location('Top Org l_movement_category2 = '||l_movement_category,900);
2126: hr_utility.set_location('Top Org Start Date = '||to_char(P_DATE_FROM,'DD-MON-YYYY'),910);
2127: hr_utility.set_location('Top Org End Date = '||to_char(P_DATE_TO,'DD-MON-YYYY'),920);
2128:
2129: if l_jobcatg = 'Y'
2130: then

Line 2127: hr_utility.set_location('Top Org End Date = '||to_char(P_DATE_TO,'DD-MON-YYYY'),920);

2123: l_movement_category = 'REACTIVATED') then
2124:
2125: hr_utility.set_location('Top Org l_movement_category2 = '||l_movement_category,900);
2126: hr_utility.set_location('Top Org Start Date = '||to_char(P_DATE_FROM,'DD-MON-YYYY'),910);
2127: hr_utility.set_location('Top Org End Date = '||to_char(P_DATE_TO,'DD-MON-YYYY'),920);
2128:
2129: if l_jobcatg = 'Y'
2130: then
2131: l_rev_transfer_in := l_rev_transfer_in + l_abv;

Line 2154: hr_utility.set_location('Top Org New Hire = '||l_cur_nh,930);

2150: , p_assignment_type => P_WORKER_TYPE
2151: , p_cur_date_from => l_cur_date_from
2152: , p_cur_date_to => l_cur_date_to);
2153:
2154: hr_utility.set_location('Top Org New Hire = '||l_cur_nh,930);
2155:
2156: if l_cur_nh = 'Y' then
2157:
2158: if l_jobcatg = 'Y'

Line 2217: hr_utility.set_location('Top Org New Hire = '||l_cur_nh,930);

2213: , P_INCLUDE_ASG_TYPE)
2214:
2215: loop -- get_assignment
2216:
2217: hr_utility.set_location('Top Org New Hire = '||l_cur_nh,930);
2218: hr_utility.set_location('Top Org assgt_rec.assignment_id = '||to_char(assgt_rec.assignment_id),940);
2219: hr_utility.set_location('assgt_rec.effective_start_date = '||to_char(assgt_rec.effective_start_date,'DD/MM/YYYY'),950);
2220:
2221: if assgt_rec.assignment_type <> 'C' then

Line 2218: hr_utility.set_location('Top Org assgt_rec.assignment_id = '||to_char(assgt_rec.assignment_id),940);

2214:
2215: loop -- get_assignment
2216:
2217: hr_utility.set_location('Top Org New Hire = '||l_cur_nh,930);
2218: hr_utility.set_location('Top Org assgt_rec.assignment_id = '||to_char(assgt_rec.assignment_id),940);
2219: hr_utility.set_location('assgt_rec.effective_start_date = '||to_char(assgt_rec.effective_start_date,'DD/MM/YYYY'),950);
2220:
2221: if assgt_rec.assignment_type <> 'C' then
2222: l_pertype := NULL;

Line 2219: hr_utility.set_location('assgt_rec.effective_start_date = '||to_char(assgt_rec.effective_start_date,'DD/MM/YYYY'),950);

2215: loop -- get_assignment
2216:
2217: hr_utility.set_location('Top Org New Hire = '||l_cur_nh,930);
2218: hr_utility.set_location('Top Org assgt_rec.assignment_id = '||to_char(assgt_rec.assignment_id),940);
2219: hr_utility.set_location('assgt_rec.effective_start_date = '||to_char(assgt_rec.effective_start_date,'DD/MM/YYYY'),950);
2220:
2221: if assgt_rec.assignment_type <> 'C' then
2222: l_pertype := NULL;
2223: l_pertype := HR_PERSON_FLEX_LOGIC.GetAsgWorkerType

Line 2231: hr_utility.set_location('Top Org AsgWorkerType = '||l_pertype,960);

2227: ,p_session_date => trunc(sysdate)
2228: );
2229: end if;
2230:
2231: hr_utility.set_location('Top Org AsgWorkerType = '||l_pertype,960);
2232:
2233: l_jobcatg := NULL;
2234: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
2235: (assgt_rec.job_id

Line 2245: hr_utility.set_location('Top Org l_abv = '||l_abv,970);

2241: , p_assignment_id => assgt_rec.assignment_id
2242: , p_effective_date => assgt_rec.effective_start_date
2243: , p_session_date => trunc(sysdate) );
2244:
2245: hr_utility.set_location('Top Org l_abv = '||l_abv,970);
2246: hr_utility.set_location('Top Org l_jobcatg = '||l_jobcatg,980);
2247: hr_utility.set_location('Top Org l_pertype = '||l_pertype,990);
2248:
2249: if l_pertype = 'P' then

Line 2246: hr_utility.set_location('Top Org l_jobcatg = '||l_jobcatg,980);

2242: , p_effective_date => assgt_rec.effective_start_date
2243: , p_session_date => trunc(sysdate) );
2244:
2245: hr_utility.set_location('Top Org l_abv = '||l_abv,970);
2246: hr_utility.set_location('Top Org l_jobcatg = '||l_jobcatg,980);
2247: hr_utility.set_location('Top Org l_pertype = '||l_pertype,990);
2248:
2249: if l_pertype = 'P' then
2250: if l_jobcatg = 'Y'

Line 2247: hr_utility.set_location('Top Org l_pertype = '||l_pertype,990);

2243: , p_session_date => trunc(sysdate) );
2244:
2245: hr_utility.set_location('Top Org l_abv = '||l_abv,970);
2246: hr_utility.set_location('Top Org l_jobcatg = '||l_jobcatg,980);
2247: hr_utility.set_location('Top Org l_pertype = '||l_pertype,990);
2248:
2249: if l_pertype = 'P' then
2250: if l_jobcatg = 'Y'
2251: then

Line 2257: hr_utility.set_location('Top Org Rev Perm = '||to_char(l_rev_perm),1000);

2253: else
2254: l_nonrev_perm := l_nonrev_perm + l_abv;
2255: end if;
2256:
2257: hr_utility.set_location('Top Org Rev Perm = '||to_char(l_rev_perm),1000);
2258: hr_utility.set_location('Top Org NonRev Perm = '||to_char(l_nonrev_perm),1010);
2259:
2260: elsif l_pertype = 'T' then
2261: if l_jobcatg = 'Y'

Line 2258: hr_utility.set_location('Top Org NonRev Perm = '||to_char(l_nonrev_perm),1010);

2254: l_nonrev_perm := l_nonrev_perm + l_abv;
2255: end if;
2256:
2257: hr_utility.set_location('Top Org Rev Perm = '||to_char(l_rev_perm),1000);
2258: hr_utility.set_location('Top Org NonRev Perm = '||to_char(l_nonrev_perm),1010);
2259:
2260: elsif l_pertype = 'T' then
2261: if l_jobcatg = 'Y'
2262: then

Line 2499: hr_utility.set_location('Term Type = '||l_termtype,400);

2495: (p_term_formula_id => l_term_formula_id
2496: ,p_leaving_reason => term_rec.leaving_reason
2497: ,p_session_date => trunc(sysdate));
2498:
2499: hr_utility.set_location('Term Type = '||l_termtype,400);
2500:
2501: l_jobcatg := NULL;
2502: l_abv := NULL;
2503:

Line 2516: hr_utility.set_location('Job Categ = '||l_jobcatg,410);

2512: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
2513: (term_rec.job_id
2514: ,p_job_category);
2515:
2516: hr_utility.set_location('Job Categ = '||l_jobcatg,410);
2517:
2518: if l_termtype = 'V'
2519: then
2520: if l_jobcatg = 'Y'

Line 2538: hr_utility.set_location('Rev Vol T = '||l_rev_vol_term,420);

2534: end if;
2535:
2536: end loop; -- get_terminations
2537:
2538: hr_utility.set_location('Rev Vol T = '||l_rev_vol_term,420);
2539: hr_utility.set_location('NONRev Vol T = '||l_nonrev_vol_term,430);
2540:
2541: end if;
2542:

Line 2539: hr_utility.set_location('NONRev Vol T = '||l_nonrev_vol_term,430);

2535:
2536: end loop; -- get_terminations
2537:
2538: hr_utility.set_location('Rev Vol T = '||l_rev_vol_term,420);
2539: hr_utility.set_location('NONRev Vol T = '||l_nonrev_vol_term,430);
2540:
2541: end if;
2542:
2543: HQOrgData(1-(osv_rec.org_structure_version_id+P_TOP_ORGANIZATION_ID)).rev_vol_term :=

Line 2636: hr_utility.set_location('Job Categ = '||l_jobcatg,410);

2632: l_jobcatg := HR_PERSON_FLEX_LOGIC.GetJobCategory
2633: (term_rec.job_id
2634: ,p_job_category);
2635:
2636: hr_utility.set_location('Job Categ = '||l_jobcatg,410);
2637:
2638: if l_cwk_termtype = 'V'
2639: then
2640: if l_jobcatg = 'Y'

Line 2658: hr_utility.set_location('Rev Vol T = '||l_rev_vol_term,420);

2654: end if;
2655:
2656: end loop; -- get_terminations
2657:
2658: hr_utility.set_location('Rev Vol T = '||l_rev_vol_term,420);
2659: hr_utility.set_location('NONRev Vol T = '||l_nonrev_vol_term,430);
2660:
2661: HQOrgData(1-(osv_rec.org_structure_version_id+P_TOP_ORGANIZATION_ID)).rev_vol_term :=
2662: HQOrgData(1-(osv_rec.org_structure_version_id+P_TOP_ORGANIZATION_ID)).rev_vol_term + nvl(l_rev_vol_term,0);

Line 2659: hr_utility.set_location('NONRev Vol T = '||l_nonrev_vol_term,430);

2655:
2656: end loop; -- get_terminations
2657:
2658: hr_utility.set_location('Rev Vol T = '||l_rev_vol_term,420);
2659: hr_utility.set_location('NONRev Vol T = '||l_nonrev_vol_term,430);
2660:
2661: HQOrgData(1-(osv_rec.org_structure_version_id+P_TOP_ORGANIZATION_ID)).rev_vol_term :=
2662: HQOrgData(1-(osv_rec.org_structure_version_id+P_TOP_ORGANIZATION_ID)).rev_vol_term + nvl(l_rev_vol_term,0);
2663:

Line 2688: hr_utility.set_location(' End of P_INCLUDE_TOP_ORG = Y',1000);

2684: end if;
2685:
2686: end if;
2687:
2688: hr_utility.set_location(' End of P_INCLUDE_TOP_ORG = Y',1000);
2689:
2690: end if; -- if P_INCLUDE_TOP_ORG = 'Y'
2691:
2692: hr_utility.set_location(' Out of P_INCLUDE_TOP_ORG = Y',1000);

Line 2692: hr_utility.set_location(' Out of P_INCLUDE_TOP_ORG = Y',1000);

2688: hr_utility.set_location(' End of P_INCLUDE_TOP_ORG = Y',1000);
2689:
2690: end if; -- if P_INCLUDE_TOP_ORG = 'Y'
2691:
2692: hr_utility.set_location(' Out of P_INCLUDE_TOP_ORG = Y',1000);
2693:
2694: end loop; -- get_org_structure_version
2695:
2696: hr_utility.set_location(' Out of get_org_structure_version ',1000);

Line 2696: hr_utility.set_location(' Out of get_org_structure_version ',1000);

2692: hr_utility.set_location(' Out of P_INCLUDE_TOP_ORG = Y',1000);
2693:
2694: end loop; -- get_org_structure_version
2695:
2696: hr_utility.set_location(' Out of get_org_structure_version ',1000);
2697: hr_utility.set_location(' ',1000);
2698: hr_utility.set_location('*Organiz*STAR*PERM*CONT*TEMP*CuNH*NewH*TrIN*TrOt*VoTM*InTM*ENDV*',8000);
2699:
2700: for all_org_rec in c_get_all_orgs

Line 2697: hr_utility.set_location(' ',1000);

2693:
2694: end loop; -- get_org_structure_version
2695:
2696: hr_utility.set_location(' Out of get_org_structure_version ',1000);
2697: hr_utility.set_location(' ',1000);
2698: hr_utility.set_location('*Organiz*STAR*PERM*CONT*TEMP*CuNH*NewH*TrIN*TrOt*VoTM*InTM*ENDV*',8000);
2699:
2700: for all_org_rec in c_get_all_orgs
2701: (P_ORGANIZATION_STRUCTURE_ID

Line 2698: hr_utility.set_location('OrganizSTARPERMCONTTEMPCuNHNewHTrINTrOtVoTMInTMENDV*',8000);

2694: end loop; -- get_org_structure_version
2695:
2696: hr_utility.set_location(' Out of get_org_structure_version ',1000);
2697: hr_utility.set_location(' ',1000);
2698: hr_utility.set_location('*Organiz*STAR*PERM*CONT*TEMP*CuNH*NewH*TrIN*TrOt*VoTM*InTM*ENDV*',8000);
2699:
2700: for all_org_rec in c_get_all_orgs
2701: (P_ORGANIZATION_STRUCTURE_ID
2702: ,P_TOP_ORGANIZATION_ID

Line 2708: hr_utility.set_location(' ',8000);

2704: ,P_REPORT_DATE_TO)
2705:
2706: loop
2707:
2708: hr_utility.set_location(' ',8000);
2709: hr_utility.set_location('R'||lpad(to_char(all_org_rec.organization_id_child),7,'.')||
2710: '*'||
2711: lpad(HQOrgData(all_org_rec.org_structure_element_id).rev_start_val,4,'.')||
2712: '*'||

Line 2709: hr_utility.set_location('R'||lpad(to_char(all_org_rec.organization_id_child),7,'.')||

2705:
2706: loop
2707:
2708: hr_utility.set_location(' ',8000);
2709: hr_utility.set_location('R'||lpad(to_char(all_org_rec.organization_id_child),7,'.')||
2710: '*'||
2711: lpad(HQOrgData(all_org_rec.org_structure_element_id).rev_start_val,4,'.')||
2712: '*'||
2713: lpad(HQOrgData(all_org_rec.org_structure_element_id).rev_perm,4,'.')||

Line 2733: hr_utility.set_location('N'||lpad(to_char(all_org_rec.organization_id_child),7,'.')||

2729: lpad(HQOrgData(all_org_rec.org_structure_element_id).rev_invol_term,4,'.')||
2730: '*'||
2731: lpad(HQOrgData(all_org_rec.org_structure_element_id).rev_end_val,4,'*'),8000);
2732:
2733: hr_utility.set_location('N'||lpad(to_char(all_org_rec.organization_id_child),7,'.')||
2734: '*'||
2735: lpad(HQOrgData(all_org_rec.org_structure_element_id).nonrev_start_val,4,'.')||
2736: '*'||
2737: lpad(HQOrgData(all_org_rec.org_structure_element_id).nonrev_perm,4,'.')||

Line 2761: hr_utility.set_location(' ',10000);

2757: end loop;
2758:
2759: if P_INCLUDE_TOP_ORG = 'Y' then
2760:
2761: hr_utility.set_location(' ',10000);
2762: hr_utility.set_location('start of c_get_top_orgs',10000);
2763: hr_utility.set_location(' ',10000);
2764: hr_utility.set_location('*Organiz*STAR*PERM*CONT*TEMP*CuNH*NewH*TrIN*TrOt*VoTM*InTM*ENDV*',8000);
2765:

Line 2762: hr_utility.set_location('start of c_get_top_orgs',10000);

2758:
2759: if P_INCLUDE_TOP_ORG = 'Y' then
2760:
2761: hr_utility.set_location(' ',10000);
2762: hr_utility.set_location('start of c_get_top_orgs',10000);
2763: hr_utility.set_location(' ',10000);
2764: hr_utility.set_location('*Organiz*STAR*PERM*CONT*TEMP*CuNH*NewH*TrIN*TrOt*VoTM*InTM*ENDV*',8000);
2765:
2766: for all_top_org_rec in c_get_top_orgs

Line 2763: hr_utility.set_location(' ',10000);

2759: if P_INCLUDE_TOP_ORG = 'Y' then
2760:
2761: hr_utility.set_location(' ',10000);
2762: hr_utility.set_location('start of c_get_top_orgs',10000);
2763: hr_utility.set_location(' ',10000);
2764: hr_utility.set_location('*Organiz*STAR*PERM*CONT*TEMP*CuNH*NewH*TrIN*TrOt*VoTM*InTM*ENDV*',8000);
2765:
2766: for all_top_org_rec in c_get_top_orgs
2767: (P_ORGANIZATION_STRUCTURE_ID

Line 2764: hr_utility.set_location('OrganizSTARPERMCONTTEMPCuNHNewHTrINTrOtVoTMInTMENDV*',8000);

2760:
2761: hr_utility.set_location(' ',10000);
2762: hr_utility.set_location('start of c_get_top_orgs',10000);
2763: hr_utility.set_location(' ',10000);
2764: hr_utility.set_location('*Organiz*STAR*PERM*CONT*TEMP*CuNH*NewH*TrIN*TrOt*VoTM*InTM*ENDV*',8000);
2765:
2766: for all_top_org_rec in c_get_top_orgs
2767: (P_ORGANIZATION_STRUCTURE_ID
2768: ,P_TOP_ORGANIZATION_ID

Line 2774: -- hr_utility.set_location('Top Org == '||all_top_org_rec.org_structure_element_id,10000);

2770: ,P_REPORT_DATE_TO)
2771:
2772: loop
2773:
2774: -- hr_utility.set_location('Top Org == '||all_top_org_rec.org_structure_element_id,10000);
2775: hr_utility.set_location('R'||lpad(to_char(all_top_org_rec.organization_id_child),7,'.')||
2776: '*'||
2777: lpad(HQOrgData(all_top_org_rec.org_structure_element_id).rev_start_val,4,'.')||
2778: '*'||

Line 2775: hr_utility.set_location('R'||lpad(to_char(all_top_org_rec.organization_id_child),7,'.')||

2771:
2772: loop
2773:
2774: -- hr_utility.set_location('Top Org == '||all_top_org_rec.org_structure_element_id,10000);
2775: hr_utility.set_location('R'||lpad(to_char(all_top_org_rec.organization_id_child),7,'.')||
2776: '*'||
2777: lpad(HQOrgData(all_top_org_rec.org_structure_element_id).rev_start_val,4,'.')||
2778: '*'||
2779: lpad(HQOrgData(all_top_org_rec.org_structure_element_id).rev_perm,4,'.')||

Line 2799: hr_utility.set_location('N'||lpad(to_char(all_top_org_rec.organization_id_child),7,'.')||

2795: lpad(HQOrgData(all_top_org_rec.org_structure_element_id).rev_invol_term,4,'.')||
2796: '*'||
2797: lpad(HQOrgData(all_top_org_rec.org_structure_element_id).rev_end_val,4,'.'),8000);
2798:
2799: hr_utility.set_location('N'||lpad(to_char(all_top_org_rec.organization_id_child),7,'.')||
2800: '*'||
2801: lpad(HQOrgData(all_top_org_rec.org_structure_element_id).nonrev_start_val,4,'.')||
2802: '*'||
2803: lpad(HQOrgData(all_top_org_rec.org_structure_element_id).nonrev_perm,4,'.')||

Line 2822: hr_utility.set_location(' ',10000);

2818: '*'||
2819: lpad(HQOrgData(all_top_org_rec.org_structure_element_id).nonrev_invol_term,4,'.')||
2820: '*'||
2821: lpad(HQOrgData(all_top_org_rec.org_structure_element_id).nonrev_end_val,4,'.'),8000);
2822: hr_utility.set_location(' ',10000);
2823:
2824:
2825: end loop; -- c_get_top_orgs
2826:

Line 2829: hr_utility.set_location('end populate_headcount_table',9999);

2825: end loop; -- c_get_top_orgs
2826:
2827: end if; -- if P_INCLUDE_TOP_ORG = 'Y'
2828:
2829: hr_utility.set_location('end populate_headcount_table',9999);
2830:
2831: end populate_headcount_table;
2832:
2833: END HR_HEAD_COUNT;