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_APPLICANT_INTERNAL dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package constant varchar2(33) := 'hr_applicant_internal.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: g_APL_person_type constant varchar2(10) := 'APL';
10: g_EX_APL_person_type constant varchar2(10) := 'EX_APL';
11: --

Line 633: hr_utility.set_location(' Entering: '||l_proc,10);

629:
630:
631: begin
632: if g_debug then
633: hr_utility.set_location(' Entering: '||l_proc,10);
634: end if;
635: --
636: l_effective_date := trunc(p_effective_date);
637: --

Line 645: hr_utility.set_location(' Entering: '||l_proc,10);

641: p_business_group_id => p_business_group_id,
642: p_expected_sys_type => 'EX_APL');
643: --
644: if g_debug then
645: hr_utility.set_location(' Entering: '||l_proc,10);
646: end if;
647: --
648: open csr_get_person_details(p_person_id, l_effective_date);
649: fetch csr_get_person_details into l_person_rec;

Line 653: hr_utility.set_location(l_proc,15);

649: fetch csr_get_person_details into l_person_rec;
650: if csr_get_person_details%FOUND then
651:
652: if g_debug then
653: hr_utility.set_location(l_proc,15);
654: end if;
655:
656: open csr_get_person_type(l_person_rec.person_type_id);
657: fetch csr_get_person_type into l_system_person_type;

Line 683: hr_utility.set_location(l_proc,20);

679: --
680: -- person is ex_applicant; do nothing
681: --
682: if g_debug then
683: hr_utility.set_location(l_proc,20);
684: end if;
685: --
686: else
687: --

Line 695: hr_utility.set_location(l_proc,25);

691: --
692: -- Update current record, simulate 'CORRECTION' mode
693: --
694: if g_debug then
695: hr_utility.set_location(l_proc,25);
696: end if;
697: --
698: Update_Person_Rec
699: (p_person_id => l_person_rec.person_id

Line 713: hr_utility.set_location(l_proc,30);

709: --
710: -- DT update: person becomes ex_applicant on effective date
711: --
712: if g_debug then
713: hr_utility.set_location(l_proc,30);
714: end if;
715:
716: l_new_effective_date := l_effective_date;
717: l_per_effective_end_date := l_person_rec.effective_end_date;

Line 744: hr_utility.set_location(l_proc,40);

740: end if;
741: end if;
742: --
743: if g_debug then
744: hr_utility.set_location(l_proc,40);
745: end if;
746: --
747: -- process future person records using "CORRECTION" mode
748: --

Line 789: hr_utility.set_location(l_proc,45);

785: end if; -- person type is different
786:
787: END LOOP;
788: if g_debug then
789: hr_utility.set_location(l_proc,45);
790: end if;
791:
792: else
793: -- person details not found: ABNORMAL condition

Line 794: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');

790: end if;
791:
792: else
793: -- person details not found: ABNORMAL condition
794: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
795: hr_utility.set_message_token('PROCEDURE',l_proc);
796: hr_utility.set_message_token('STEP',80);
797: hr_utility.raise_error;
798: end if;

Line 795: hr_utility.set_message_token('PROCEDURE',l_proc);

791:
792: else
793: -- person details not found: ABNORMAL condition
794: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
795: hr_utility.set_message_token('PROCEDURE',l_proc);
796: hr_utility.set_message_token('STEP',80);
797: hr_utility.raise_error;
798: end if;
799: close csr_get_person_details;

Line 796: hr_utility.set_message_token('STEP',80);

792: else
793: -- person details not found: ABNORMAL condition
794: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
795: hr_utility.set_message_token('PROCEDURE',l_proc);
796: hr_utility.set_message_token('STEP',80);
797: hr_utility.raise_error;
798: end if;
799: close csr_get_person_details;
800:

Line 797: hr_utility.raise_error;

793: -- person details not found: ABNORMAL condition
794: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
795: hr_utility.set_message_token('PROCEDURE',l_proc);
796: hr_utility.set_message_token('STEP',80);
797: hr_utility.raise_error;
798: end if;
799: close csr_get_person_details;
800:
801:

Line 806: hr_utility.set_location(l_proc,50);

802: -- ---------------------------------------------------------------------- +
803: -- ------------------------ PTU UPDATES --------------------------------- |
804: -- ---------------------------------------------------------------------- +
805: if g_debug then
806: hr_utility.set_location(l_proc,50);
807: hr_utility.trace(' ==> person record became EX_APL on '||
808: to_char(l_new_effective_date));
809: end if;
810: --

Line 807: hr_utility.trace(' ==> person record became EX_APL on '||

803: -- ------------------------ PTU UPDATES --------------------------------- |
804: -- ---------------------------------------------------------------------- +
805: if g_debug then
806: hr_utility.set_location(l_proc,50);
807: hr_utility.trace(' ==> person record became EX_APL on '||
808: to_char(l_new_effective_date));
809: end if;
810: --
811: open csr_ptu_details(p_person_id, l_new_effective_date);

Line 820: hr_utility.set_location(l_proc,60);

816: --
817: -- person is ex_applicant on new_effective_date
818: --
819: if g_debug then
820: hr_utility.set_location(l_proc,60);
821: end if;
822:
823: else -- person is APL
824: if g_debug then

Line 825: hr_utility.set_location(l_proc,65);

821: end if;
822:
823: else -- person is APL
824: if g_debug then
825: hr_utility.set_location(l_proc,65);
826: end if;
827: --
828: if l_ptu_rec.effective_end_date <> hr_api.g_eot then
829: hr_per_type_usage_internal.maintain_person_type_usage

Line 846: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');

842: end if;
843: --
844: end if;
845: ELSE -- APL ptu record not found
846: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
847: hr_utility.set_message_token('PROCEDURE',l_proc);
848: hr_utility.set_message_token('STEP',85);
849: hr_utility.raise_error;
850: END IF;

Line 847: hr_utility.set_message_token('PROCEDURE',l_proc);

843: --
844: end if;
845: ELSE -- APL ptu record not found
846: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
847: hr_utility.set_message_token('PROCEDURE',l_proc);
848: hr_utility.set_message_token('STEP',85);
849: hr_utility.raise_error;
850: END IF;
851: if g_debug then

Line 848: hr_utility.set_message_token('STEP',85);

844: end if;
845: ELSE -- APL ptu record not found
846: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
847: hr_utility.set_message_token('PROCEDURE',l_proc);
848: hr_utility.set_message_token('STEP',85);
849: hr_utility.raise_error;
850: END IF;
851: if g_debug then
852: hr_utility.set_location(' Leaving: '||l_proc,1000);

Line 849: hr_utility.raise_error;

845: ELSE -- APL ptu record not found
846: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
847: hr_utility.set_message_token('PROCEDURE',l_proc);
848: hr_utility.set_message_token('STEP',85);
849: hr_utility.raise_error;
850: END IF;
851: if g_debug then
852: hr_utility.set_location(' Leaving: '||l_proc,1000);
853: end if;

Line 852: hr_utility.set_location(' Leaving: '||l_proc,1000);

848: hr_utility.set_message_token('STEP',85);
849: hr_utility.raise_error;
850: END IF;
851: if g_debug then
852: hr_utility.set_location(' Leaving: '||l_proc,1000);
853: end if;
854: --
855: -- Setting OUT parameters
856: --

Line 963: hr_utility.set_location(' Entering: '||l_proc,10);

959: --
960: begin
961: --
962: if g_debug then
963: hr_utility.set_location(' Entering: '||l_proc,10);
964: end if;
965: --
966: l_effective_date := trunc(p_effective_date);
967: --

Line 979: hr_utility.set_location(l_proc,15);

975: fetch csr_get_person_details into l_person_rec;
976: if csr_get_person_details%FOUND then
977:
978: if g_debug then
979: hr_utility.set_location(l_proc,15);
980: end if;
981: --
982: open csr_get_person_type(l_person_rec.person_type_id);
983: fetch csr_get_person_type into l_system_person_type;

Line 996: hr_utility.set_location(l_proc,16);

992: --
993: -- person becomes applicant before first created in the system
994: --
995: if g_debug then
996: hr_utility.set_location(l_proc,16);
997: end if;
998: --
999: l_ovn := l_person_rec.object_version_number;
1000:

Line 1045: hr_utility.set_location(l_proc,20);

1041: --
1042: -- person is applicant; do nothing
1043: --
1044: if g_debug then
1045: hr_utility.set_location(l_proc,20);
1046: end if;
1047: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+
1048: else
1049: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+

Line 1057: hr_utility.set_location(l_proc,25);

1053: --
1054: -- Update current record, simulate 'CORRECTION' mode
1055: --
1056: if g_debug then
1057: hr_utility.set_location(l_proc,25);
1058: end if;
1059: --
1060: Update_Person_Rec
1061: (p_person_id => l_person_rec.person_id

Line 1075: hr_utility.set_location(l_proc,30);

1071: -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1072: -- DT update: person becomes applicant on effective date
1073: --
1074: if g_debug then
1075: hr_utility.set_location(l_proc,30);
1076: end if;
1077:
1078: l_new_effective_date := l_effective_date;
1079: l_per_effective_end_date := l_person_rec.effective_end_date;

Line 1108: hr_utility.set_location(l_proc,40);

1104: end if; -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+
1105: end if; -- person became applicant before first created?
1106: --
1107: if g_debug then
1108: hr_utility.set_location(l_proc,40);
1109: end if;
1110: --
1111: -- process future person records using "CORRECTION" mode
1112: --

Line 1150: hr_utility.set_location(l_proc,45);

1146: end if; -- person type is different
1147:
1148: END LOOP;
1149: if g_debug then
1150: hr_utility.set_location(l_proc,45);
1151: end if;
1152:
1153: else
1154: -- person details not found: ABNORMAL condition

Line 1155: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');

1151: end if;
1152:
1153: else
1154: -- person details not found: ABNORMAL condition
1155: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
1156: hr_utility.set_message_token('PROCEDURE',l_proc);
1157: hr_utility.set_message_token('STEP',50);
1158: hr_utility.raise_error;
1159: end if;

Line 1156: hr_utility.set_message_token('PROCEDURE',l_proc);

1152:
1153: else
1154: -- person details not found: ABNORMAL condition
1155: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
1156: hr_utility.set_message_token('PROCEDURE',l_proc);
1157: hr_utility.set_message_token('STEP',50);
1158: hr_utility.raise_error;
1159: end if;
1160: close csr_get_person_details;

Line 1157: hr_utility.set_message_token('STEP',50);

1153: else
1154: -- person details not found: ABNORMAL condition
1155: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
1156: hr_utility.set_message_token('PROCEDURE',l_proc);
1157: hr_utility.set_message_token('STEP',50);
1158: hr_utility.raise_error;
1159: end if;
1160: close csr_get_person_details;
1161:

Line 1158: hr_utility.raise_error;

1154: -- person details not found: ABNORMAL condition
1155: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
1156: hr_utility.set_message_token('PROCEDURE',l_proc);
1157: hr_utility.set_message_token('STEP',50);
1158: hr_utility.raise_error;
1159: end if;
1160: close csr_get_person_details;
1161:
1162: -- ---------------------------------------------------------------------- +

Line 1166: hr_utility.set_location(l_proc,50);

1162: -- ---------------------------------------------------------------------- +
1163: -- ------------------------ PTU UPDATES --------------------------------- |
1164: -- ---------------------------------------------------------------------- +
1165: if g_debug then
1166: hr_utility.set_location(l_proc,50);
1167: hr_utility.trace(' ==> person record became APL on '||
1168: to_char(l_new_effective_date));
1169: end if;
1170: -- get default APL person type for PTU updates

Line 1167: hr_utility.trace(' ==> person record became APL on '||

1163: -- ------------------------ PTU UPDATES --------------------------------- |
1164: -- ---------------------------------------------------------------------- +
1165: if g_debug then
1166: hr_utility.set_location(l_proc,50);
1167: hr_utility.trace(' ==> person record became APL on '||
1168: to_char(l_new_effective_date));
1169: end if;
1170: -- get default APL person type for PTU updates
1171: l_new_person_type_id := l_ptu_person_type_id;

Line 1184: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');

1180: --
1181: if l_ptu_rec.system_person_type <> 'APL' then
1182: -- person should be an applicant otherwise it is an abnormal condition
1183: close csr_ptu_details;
1184: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
1185: hr_utility.set_message_token('PROCEDURE',l_proc);
1186: hr_utility.set_message_token('STEP',60);
1187: hr_utility.raise_error;
1188: else

Line 1185: hr_utility.set_message_token('PROCEDURE',l_proc);

1181: if l_ptu_rec.system_person_type <> 'APL' then
1182: -- person should be an applicant otherwise it is an abnormal condition
1183: close csr_ptu_details;
1184: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
1185: hr_utility.set_message_token('PROCEDURE',l_proc);
1186: hr_utility.set_message_token('STEP',60);
1187: hr_utility.raise_error;
1188: else
1189: --

Line 1186: hr_utility.set_message_token('STEP',60);

1182: -- person should be an applicant otherwise it is an abnormal condition
1183: close csr_ptu_details;
1184: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
1185: hr_utility.set_message_token('PROCEDURE',l_proc);
1186: hr_utility.set_message_token('STEP',60);
1187: hr_utility.raise_error;
1188: else
1189: --
1190: l_first_person_type_id := l_ptu_rec.person_type_id;

Line 1187: hr_utility.raise_error;

1183: close csr_ptu_details;
1184: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
1185: hr_utility.set_message_token('PROCEDURE',l_proc);
1186: hr_utility.set_message_token('STEP',60);
1187: hr_utility.raise_error;
1188: else
1189: --
1190: l_first_person_type_id := l_ptu_rec.person_type_id;
1191:

Line 1227: hr_utility.set_location(l_proc,60);

1223: --
1224: -- person is applicant on new_effective_date
1225: --
1226: if g_debug then
1227: hr_utility.set_location(l_proc,60);
1228: end if;
1229: l_first_person_type_id := l_ptu_rec.person_type_id;
1230: --
1231: -- check whether future changes exist, if yes delete otherwise do nothing

Line 1257: hr_utility.set_location(l_proc,65);

1253: close csr_ptu_details;
1254: --
1255: else -- person is EX_APL
1256: if g_debug then
1257: hr_utility.set_location(l_proc,65);
1258: end if;
1259: --
1260: if l_ptu_rec.effective_start_date = l_new_effective_date then
1261: close csr_ptu_details;

Line 1280: hr_utility.set_location(l_proc,75);

1276: ,p_datetrack_update_mode => hr_api.g_update
1277: );
1278: else
1279: if g_debug then
1280: hr_utility.set_location(l_proc,75);
1281: end if;
1282: close csr_ptu_details;
1283: if l_ptu_rec.effective_end_date <> hr_api.g_eot then
1284: hr_per_type_usage_internal.maintain_person_type_usage

Line 1307: hr_utility.set_location(l_proc,80);

1303: ---
1304: -- person needs to be transformed into applicant on effective_date
1305: --
1306: if g_debug then
1307: hr_utility.set_location(l_proc,80);
1308: end if;
1309: hr_per_type_usage_internal.create_person_type_usage
1310: (p_person_id => p_person_id
1311: ,p_person_type_id => l_new_person_type_id

Line 1327: hr_utility.trace(' l_ovn : '||l_ovn);

1323: fetch csr_get_per_ovn into l_ovn;
1324: close csr_get_per_ovn;
1325:
1326: if g_debug then
1327: hr_utility.trace(' l_ovn : '||l_ovn);
1328: hr_utility.set_location(' Leaving: '||l_proc,1000);
1329: end if;
1330: --
1331: -- Setting OUT parameters

Line 1328: hr_utility.set_location(' Leaving: '||l_proc,1000);

1324: close csr_get_per_ovn;
1325:
1326: if g_debug then
1327: hr_utility.trace(' l_ovn : '||l_ovn);
1328: hr_utility.set_location(' Leaving: '||l_proc,1000);
1329: end if;
1330: --
1331: -- Setting OUT parameters
1332: --

Line 1497: hr_utility.set_location(' Entering: '||l_proc,10);

1493: END Upd_person;
1494: --
1495: BEGIN
1496: if g_debug then
1497: hr_utility.set_location(' Entering: '||l_proc,10);
1498: end if;
1499: --
1500: open csr_get_person_details (p_person_id, p_ex_apl_effective_date, p_apl_effective_date);
1501: fetch csr_get_person_details into l_ex_per_rec;

Line 1594: hr_utility.set_location(l_proc,50);

1590: -- ---------------------------------------------------------------------- +
1591: -- ------------------------ PTU UPDATES --------------------------------- |
1592: -- ---------------------------------------------------------------------- +
1593: if g_debug then
1594: hr_utility.set_location(l_proc,50);
1595: hr_utility.trace(' ==> person record became EX_APL on '||
1596: to_char(l_new_effective_date));
1597: end if;
1598: --

Line 1595: hr_utility.trace(' ==> person record became EX_APL on '||

1591: -- ------------------------ PTU UPDATES --------------------------------- |
1592: -- ---------------------------------------------------------------------- +
1593: if g_debug then
1594: hr_utility.set_location(l_proc,50);
1595: hr_utility.trace(' ==> person record became EX_APL on '||
1596: to_char(l_new_effective_date));
1597: end if;
1598: --
1599: l_ptu_person_type_id := hr_person_type_usage_info.get_default_person_type_id

Line 1611: hr_utility.set_location(l_proc,60);

1607: --
1608: -- person is ex_applicant on p_ex_apl_effective_date
1609: --
1610: if g_debug then
1611: hr_utility.set_location(l_proc,60);
1612: end if;
1613:
1614: else -- person is APL
1615: if g_debug then

Line 1616: hr_utility.set_location(l_proc,65);

1612: end if;
1613:
1614: else -- person is APL
1615: if g_debug then
1616: hr_utility.set_location(l_proc,65);
1617: end if;
1618: --
1619: if l_ptu_rec.effective_end_date <> hr_api.g_eot then
1620: hr_per_type_usage_internal.maintain_person_type_usage

Line 1643: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');

1639: end if;
1640: --
1641: end if;
1642: ELSE -- APL ptu record not found
1643: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
1644: hr_utility.set_message_token('PROCEDURE',l_proc);
1645: hr_utility.set_message_token('STEP',95);
1646: hr_utility.raise_error;
1647: END IF;

Line 1644: hr_utility.set_message_token('PROCEDURE',l_proc);

1640: --
1641: end if;
1642: ELSE -- APL ptu record not found
1643: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
1644: hr_utility.set_message_token('PROCEDURE',l_proc);
1645: hr_utility.set_message_token('STEP',95);
1646: hr_utility.raise_error;
1647: END IF;
1648: if g_debug then

Line 1645: hr_utility.set_message_token('STEP',95);

1641: end if;
1642: ELSE -- APL ptu record not found
1643: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
1644: hr_utility.set_message_token('PROCEDURE',l_proc);
1645: hr_utility.set_message_token('STEP',95);
1646: hr_utility.raise_error;
1647: END IF;
1648: if g_debug then
1649: hr_utility.set_location(' Leaving: '||l_proc,1000);

Line 1646: hr_utility.raise_error;

1642: ELSE -- APL ptu record not found
1643: hr_utility.set_message(800,'HR_6153_ALL_PROCEDURE_FAIL');
1644: hr_utility.set_message_token('PROCEDURE',l_proc);
1645: hr_utility.set_message_token('STEP',95);
1646: hr_utility.raise_error;
1647: END IF;
1648: if g_debug then
1649: hr_utility.set_location(' Leaving: '||l_proc,1000);
1650: end if;

Line 1649: hr_utility.set_location(' Leaving: '||l_proc,1000);

1645: hr_utility.set_message_token('STEP',95);
1646: hr_utility.raise_error;
1647: END IF;
1648: if g_debug then
1649: hr_utility.set_location(' Leaving: '||l_proc,1000);
1650: end if;
1651: --
1652: -- Setting OUT parameters
1653: --

Line 1669: hr_utility.trace('Update APL asg belonging to future applications');

1665: ,p_new_application_id IN number
1666: )
1667: IS
1668: BEGIN
1669: hr_utility.trace('Update APL asg belonging to future applications');
1670: hr_utility.trace('OLD appl id = '||p_old_application_id);
1671: hr_utility.trace('New appl id = '||p_new_application_id);
1672:
1673: UPDATE per_all_assignments_f

Line 1670: hr_utility.trace('OLD appl id = '||p_old_application_id);

1666: )
1667: IS
1668: BEGIN
1669: hr_utility.trace('Update APL asg belonging to future applications');
1670: hr_utility.trace('OLD appl id = '||p_old_application_id);
1671: hr_utility.trace('New appl id = '||p_new_application_id);
1672:
1673: UPDATE per_all_assignments_f
1674: set application_id = p_new_application_id

Line 1671: hr_utility.trace('New appl id = '||p_new_application_id);

1667: IS
1668: BEGIN
1669: hr_utility.trace('Update APL asg belonging to future applications');
1670: hr_utility.trace('OLD appl id = '||p_old_application_id);
1671: hr_utility.trace('New appl id = '||p_new_application_id);
1672:
1673: UPDATE per_all_assignments_f
1674: set application_id = p_new_application_id
1675: where business_group_id = p_business_group_id

Line 1742: hr_utility.set_location(' Entering: '||l_proc,10);

1738: l_apl_ovn_OUT per_applications.object_version_number%TYPE;
1739:
1740: begin
1741: if g_debug then
1742: hr_utility.set_location(' Entering: '||l_proc,10);
1743: end if;
1744: --
1745: l_appl_override_warning := FALSE;
1746: l_rowcount := 0;

Line 1756: hr_utility.trace('NO FUTURE');

1752: ,l_fut_apl_ovn;
1753:
1754: if csr_fut_apl%notfound then --no future
1755:
1756: hr_utility.trace('NO FUTURE');
1757:
1758: open csr_current_apl(p_person_id, l_effective_date) ;
1759: fetch csr_current_apl into l_current_apl_id, l_date_received
1760: ,l_apl_object_version_number;

Line 1764: hr_utility.trace('NO FUTURE, NO CURRENT');

1760: ,l_apl_object_version_number;
1761:
1762: if csr_current_apl%notfound then --no future, no current
1763:
1764: hr_utility.trace('NO FUTURE, NO CURRENT');
1765: close csr_current_apl;
1766: open csr_apl_yesterday(p_person_id, l_effective_date);
1767: fetch csr_apl_yesterday into l_yesterday_apl_id, l_date_received
1768: ,l_apl_object_version_number;

Line 1774: hr_utility.trace('no future, no current, no yesterday');

1770: if csr_apl_yesterday%notfound then --no future, no current, no yesterday
1771: close csr_apl_yesterday;
1772:
1773: --insert brand new application
1774: hr_utility.trace('no future, no current, no yesterday');
1775: hr_utility.trace('Insert brand new application');
1776:
1777: per_apl_ins.ins
1778: (p_application_id => l_application_id

Line 1775: hr_utility.trace('Insert brand new application');

1771: close csr_apl_yesterday;
1772:
1773: --insert brand new application
1774: hr_utility.trace('no future, no current, no yesterday');
1775: hr_utility.trace('Insert brand new application');
1776:
1777: per_apl_ins.ins
1778: (p_application_id => l_application_id
1779: ,p_business_group_id => p_business_group_id

Line 1794: hr_utility.trace('no future, no current, yes yesterday');

1790:
1791: else -- no future, no current, yes yesterday
1792: close csr_apl_yesterday;
1793:
1794: hr_utility.trace('no future, no current, yes yesterday');
1795: --
1796: -- set date_end to null where application_id=l_yesterday_apl_id
1797: --
1798: per_apl_upd.upd

Line 1813: hr_utility.trace('no future, yes current');

1809: end if;
1810: -- ----------------------------------------
1811: else --no future, yes current
1812: -- ----------------------------------------
1813: hr_utility.trace('no future, yes current');
1814:
1815: close csr_current_apl;
1816: --
1817: --set date_end to null where application_id=l_current_apl_id

Line 1834: hr_utility.trace('YES future');

1830: end if;
1831: -- -------------------------------------------------------------------
1832: else --yes future
1833: -- -------------------------------------------------------------------
1834: hr_utility.trace('YES future');
1835:
1836: open csr_current_apl(p_person_id, l_effective_date);
1837: fetch csr_current_apl into l_current_apl_id, l_date_received
1838: ,l_apl_object_version_number;

Line 1879: hr_utility.trace('yes future, yes current');

1875: l_apl_ovn_OUT := l_fut_apl_ovn;
1876: -- ----------------------------------------
1877: else --yes future, yes current
1878: -- ----------------------------------------
1879: hr_utility.trace('yes future, yes current');
1880:
1881: close csr_current_apl;
1882: --
1883: -- delete the first future apl we already fetched

Line 1937: hr_utility.set_location(' Leaving: '||l_proc,1000);

1933: p_object_version_number := l_apl_ovn_OUT;
1934: p_appl_override_warning := l_appl_override_warning;
1935:
1936: if g_debug then
1937: hr_utility.set_location(' Leaving: '||l_proc,1000);
1938: end if;
1939:
1940: end Create_Application;
1941: --

Line 2190: hr_utility.set_location('Entering:'|| l_proc, 5);

2186: -- ------------------------------------------------------------------------ +
2187: BEGIN
2188: --
2189: if g_debug then
2190: hr_utility.set_location('Entering:'|| l_proc, 5);
2191: end if;
2192: --
2193: -- Truncate p_effective_date
2194: --

Line 2198: hr_utility.trace(' l_effective_date = '||to_char(l_effective_date));

2194: --
2195: l_effective_date := trunc(p_effective_date);
2196: l_person_type_id := p_person_type_id;
2197: --
2198: hr_utility.trace(' l_effective_date = '||to_char(l_effective_date));
2199: --
2200: l_applicant_number := p_applicant_number;
2201: l_per_object_version_number := p_per_object_version_number;
2202: --

Line 2213: hr_utility.set_location(' Leaving:'||l_proc, 10);

2209: ,p_argument => 'person id'
2210: ,p_argument_value => p_person_id);
2211: --
2212: if g_debug then
2213: hr_utility.set_location(' Leaving:'||l_proc, 10);
2214: end if;
2215: --
2216: -- Check that this person (p_person_id) exists as of l_effective_date
2217: -- the current person type (per_people_f.person_type_id) has a

Line 2231: hr_utility.set_message(800, 'HR_51011_PER_NOT_EXIST_DATE');

2227: ,l_per_start_date
2228: ,l_system_person_type;
2229: if csr_chk_person_exists%notfound then
2230: close csr_chk_person_exists;
2231: hr_utility.set_message(800, 'HR_51011_PER_NOT_EXIST_DATE');
2232: hr_utility.raise_error;
2233: end if;
2234: close csr_chk_person_exists;
2235: --

Line 2232: hr_utility.raise_error;

2228: ,l_system_person_type;
2229: if csr_chk_person_exists%notfound then
2230: close csr_chk_person_exists;
2231: hr_utility.set_message(800, 'HR_51011_PER_NOT_EXIST_DATE');
2232: hr_utility.raise_error;
2233: end if;
2234: close csr_chk_person_exists;
2235: --
2236: if g_debug then

Line 2237: hr_utility.set_location(l_proc, 15);

2233: end if;
2234: close csr_chk_person_exists;
2235: --
2236: if g_debug then
2237: hr_utility.set_location(l_proc, 15);
2238: end if;
2239: --
2240: per_per_bus.chk_person_type
2241: (p_person_type_id => l_person_type_id,

Line 2246: hr_utility.set_location(l_proc, 20);

2242: p_business_group_id => l_business_group_id,
2243: p_expected_sys_type => 'APL');
2244: --
2245: if g_debug then
2246: hr_utility.set_location(l_proc, 20);
2247: end if;
2248: --
2249: -- Get organization id
2250: --

Line 2261: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

2257: ,l_normal_hours
2258: ,l_frequency;
2259: if csr_get_organization_id%notfound then
2260: close csr_get_organization_id;
2261: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
2262: hr_utility.raise_error;
2263: end if;
2264: close csr_get_organization_id;
2265: --

Line 2262: hr_utility.raise_error;

2258: ,l_frequency;
2259: if csr_get_organization_id%notfound then
2260: close csr_get_organization_id;
2261: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
2262: hr_utility.raise_error;
2263: end if;
2264: close csr_get_organization_id;
2265: --
2266: -- Get vacancy details.

Line 2281: hr_utility.set_message(801, 'HR_51001_THE_VAC_NOT_FOUND');

2277: ,l_vac_organization_id
2278: ,l_vac_business_group_id;
2279: if csr_get_vacancy_details%notfound then
2280: close csr_get_vacancy_details;
2281: hr_utility.set_message(801, 'HR_51001_THE_VAC_NOT_FOUND');
2282: hr_utility.raise_error;
2283: end if;
2284: close csr_get_vacancy_details;
2285: --

Line 2282: hr_utility.raise_error;

2278: ,l_vac_business_group_id;
2279: if csr_get_vacancy_details%notfound then
2280: close csr_get_vacancy_details;
2281: hr_utility.set_message(801, 'HR_51001_THE_VAC_NOT_FOUND');
2282: hr_utility.raise_error;
2283: end if;
2284: close csr_get_vacancy_details;
2285: --
2286: if l_vac_organization_id is null then

Line 2294: hr_utility.set_location(l_proc, 30);

2290: l_vac_organization_id := l_business_group_id;
2291: end if;
2292: --
2293: if g_debug then
2294: hr_utility.set_location(l_proc, 30);
2295: end if;
2296: --
2297: -- Validate applicant number
2298: -- Get number if one exists and parameter is NULL

Line 2310: hr_utility.set_location(l_proc, 33);

2306: ,p_start_date => l_per_start_date
2307: ,p_applicant_number => l_applicant_number);
2308:
2309: if g_debug then
2310: hr_utility.set_location(l_proc, 33);
2311: end if;
2312: -- ------------------------------------------------------------------------ +
2313: -- ----------------------<< MAIN PROCESS >>-------------------------------- |
2314: -- ------------------------------------------------------------------------ +

Line 2324: hr_utility.set_location(l_proc, 40);

2320: open csr_lock_ptu(p_person_id, l_effective_date);
2321: close csr_lock_ptu;
2322: --
2323: if g_debug then
2324: hr_utility.set_location(l_proc, 40);
2325: end if;
2326: --
2327: -- Update Person and PTU Records:
2328: --

Line 2352: hr_utility.set_location(l_proc, 50);

2348: ,p_validate_df_flex => false --4689836
2349: );
2350: --
2351: if g_debug then
2352: hr_utility.set_location(l_proc, 50);
2353: end if;
2354: --
2355: -- create an applicant assignment
2356: --

Line 2394: hr_utility.set_location(l_proc, 60);

2390: --
2391: );
2392:
2393: if g_debug then
2394: hr_utility.set_location(l_proc, 60);
2395: end if;
2396: --
2397: -- add to the security list
2398: --

Line 2419: hr_utility.set_location(' Leaving:'||l_proc, 50);

2415: p_per_object_version_number := l_per_object_version_number; --BUG4081676
2416: --
2417: --
2418: if g_debug then
2419: hr_utility.set_location(' Leaving:'||l_proc, 50);
2420: end if;
2421:
2422: end create_applicant_anytime;
2423: --