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

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_person_internal.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< product_installed >---------------------------|
11: -- ----------------------------------------------------------------------------

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

19: --
20: BEGIN
21: --
22: if g_debug then
23: hr_utility.set_location('Entering:'|| l_proc, 10);
24: end if;
25: --
26: p_yes_no := 'N';
27: p_oracle_username := 'DUMMY';

Line 45: hr_utility.set_location('Leaving:'|| l_proc, 100);

41: when NO_DATA_FOUND then null;
42: end;
43: --
44: if g_debug then
45: hr_utility.set_location('Leaving:'|| l_proc, 100);
46: end if;
47: --
48: END product_installed;
49: --

Line 73: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');

69: --
70: EXCEPTION
71: when NO_DATA_FOUND then
72: --
73: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
74: hr_utility.set_message_token ('PROCEDURE','PERSON_EXISTANCE_CHECK');
75: hr_utility.set_message_token ('STEP', '1');
76: hr_utility.raise_error;
77: --

Line 74: hr_utility.set_message_token ('PROCEDURE','PERSON_EXISTANCE_CHECK');

70: EXCEPTION
71: when NO_DATA_FOUND then
72: --
73: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
74: hr_utility.set_message_token ('PROCEDURE','PERSON_EXISTANCE_CHECK');
75: hr_utility.set_message_token ('STEP', '1');
76: hr_utility.raise_error;
77: --
78: END person_existance_check;

Line 75: hr_utility.set_message_token ('STEP', '1');

71: when NO_DATA_FOUND then
72: --
73: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
74: hr_utility.set_message_token ('PROCEDURE','PERSON_EXISTANCE_CHECK');
75: hr_utility.set_message_token ('STEP', '1');
76: hr_utility.raise_error;
77: --
78: END person_existance_check;
79: --

Line 76: hr_utility.raise_error;

72: --
73: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
74: hr_utility.set_message_token ('PROCEDURE','PERSON_EXISTANCE_CHECK');
75: hr_utility.set_message_token ('STEP', '1');
76: hr_utility.raise_error;
77: --
78: END person_existance_check;
79: --
80: -- ----------------------------------------------------------------------------

Line 106: hr_utility.set_message (801,'HR_6274_ALL_AOL_PER_NO_DEL');

102: );
103: --
104: exception
105: when NO_DATA_FOUND then
106: hr_utility.set_message (801,'HR_6274_ALL_AOL_PER_NO_DEL');
107: hr_utility.raise_error;
108: end;
109: --
110: END aol_predel_validation;

Line 107: hr_utility.raise_error;

103: --
104: exception
105: when NO_DATA_FOUND then
106: hr_utility.set_message (801,'HR_6274_ALL_AOL_PER_NO_DEL');
107: hr_utility.raise_error;
108: end;
109: --
110: END aol_predel_validation;
111: --

Line 147: hr_utility.set_message (801,'HR_6305_ALL_ASSGT_SET_NO_DEL');

143: );
144: --
145: EXCEPTION
146: when NO_DATA_FOUND then
147: hr_utility.set_message (801,'HR_6305_ALL_ASSGT_SET_NO_DEL');
148: hr_utility.raise_error;
149: --
150: END assignment_set_check;
151: --

Line 148: hr_utility.raise_error;

144: --
145: EXCEPTION
146: when NO_DATA_FOUND then
147: hr_utility.set_message (801,'HR_6305_ALL_ASSGT_SET_NO_DEL');
148: hr_utility.raise_error;
149: --
150: END assignment_set_check;
151: --
152: -- ----------------------------------------------------------------------------

Line 185: hr_utility.set_message (801,'HR_6237_ALL_ASS_ACTIONS_EXIST');

181: and ppa.action_type <> 'Z');
182: --
183: exception
184: when NO_DATA_FOUND then
185: hr_utility.set_message (801,'HR_6237_ALL_ASS_ACTIONS_EXIST');
186: hr_utility.raise_error;
187: end;
188: --
189: END pay_predel_validation;

Line 186: hr_utility.raise_error;

182: --
183: exception
184: when NO_DATA_FOUND then
185: hr_utility.set_message (801,'HR_6237_ALL_ASS_ACTIONS_EXIST');
186: hr_utility.raise_error;
187: end;
188: --
189: END pay_predel_validation;
190: --

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

238: --
239: BEGIN
240: --
241: if g_debug then
242: hr_utility.set_location('Entering:'|| l_proc, 10);
243: end if;
244: --
245: FOR each_entry in csr_this_persons_ee LOOP
246: --

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

252: --
253: END LOOP;
254: --
255: if g_debug then
256: hr_utility.set_location('Leaving:'|| l_proc, 10);
257: end if;
258: --
259: END closed_element_entry_check;
260: --

Line 295: hr_utility.set_message (801,'HR_6981_ALL_CONT_COBRA_EXISTS');

291: and c.contact_relationship_id = e.contact_relationship_id);
292: --
293: exception
294: when NO_DATA_FOUND then
295: hr_utility.set_message (801,'HR_6981_ALL_CONT_COBRA_EXISTS');
296: hr_utility.raise_error;
297: end;
298: --
299: END contact_cobra_validation;

Line 296: hr_utility.raise_error;

292: --
293: exception
294: when NO_DATA_FOUND then
295: hr_utility.set_message (801,'HR_6981_ALL_CONT_COBRA_EXISTS');
296: hr_utility.raise_error;
297: end;
298: --
299: END contact_cobra_validation;
300: --

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

315: --
316: begin
317: --
318: if g_debug then
319: hr_utility.set_location('Entering:'|| l_proc, 10);
320: end if;
321: --
322: -- Check that no child records exist for the
323: -- person on per_contracts_f when

Line 336: hr_utility.set_message(800,'PER_52851_PER_NO_DEL_CONTRACTS');

332: where person_id = p_person_id);
333: --
334: exception
335: when NO_DATA_FOUND then
336: hr_utility.set_message(800,'PER_52851_PER_NO_DEL_CONTRACTS');
337: hr_utility.raise_error;
338: --
339: END contracts_check;
340: --

Line 337: hr_utility.raise_error;

333: --
334: exception
335: when NO_DATA_FOUND then
336: hr_utility.set_message(800,'PER_52851_PER_NO_DEL_CONTRACTS');
337: hr_utility.raise_error;
338: --
339: END contracts_check;
340: --
341: -- ----------------------------------------------------------------------------

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

370: --
371: BEGIN
372: --
373: if g_debug then
374: hr_utility.set_location('Entering:'|| l_proc, 10);
375: end if;
376: --
377: hr_person_internal.person_existance_check(P_CONTACT_PERSON_ID);
378: --

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

376: --
377: hr_person_internal.person_existance_check(P_CONTACT_PERSON_ID);
378: --
379: if g_debug then
380: hr_utility.set_location(l_proc, 20);
381: end if;
382: --
383: begin
384: --

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

399: return;
400: end if;
401: --
402: if g_debug then
403: hr_utility.set_location(l_proc, 30);
404: end if;
405: --
406: begin
407: --

Line 432: when hr_utility.hr_error then

428: l_delete_contact := 'Y';
429: hr_person_internal.strong_predel_validation(P_CONTACT_PERSON_ID,
430: p_effective_date);
431: exception
432: when hr_utility.hr_error then
433: l_delete_contact := 'N';
434: end;
435: --
436: if l_delete_contact = 'Y' then

Line 443: hr_utility.set_location('Leaving:'||l_proc, 99);

439: --
440: end;
441: --
442: if g_debug then
443: hr_utility.set_location('Leaving:'||l_proc, 99);
444: end if;
445: END check_contact;
446: --
447: -- ----------------------------------------------------------------------------

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

655: --
656: BEGIN
657: --
658: if g_debug then
659: hr_utility.set_location('Entering:'|| l_proc, 10);
660: end if;
661: --
662: hr_person_internal.person_existance_check(P_PERSON_ID);
663: --

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

661: --
662: hr_person_internal.person_existance_check(P_PERSON_ID);
663: --
664: if g_debug then
665: hr_utility.set_location(l_proc, 20);
666: end if;
667: --
668: hr_person_internal.product_installed('PAY'
669: ,l_pay_status

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

670: ,l_pay_installed
671: ,l_oracle_id);
672: --
673: if g_debug then
674: hr_utility.set_location(l_proc, 30);
675: end if;
676: --
677: hr_person_internal.aol_predel_validation(P_PERSON_ID);
678: --

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

676: --
677: hr_person_internal.aol_predel_validation(P_PERSON_ID);
678: --
679: if g_debug then
680: hr_utility.set_location(l_proc, 40);
681: end if;
682: --
683: hr_person_internal.assignment_set_check(P_PERSON_ID);
684: --

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

682: --
683: hr_person_internal.assignment_set_check(P_PERSON_ID);
684: --
685: if g_debug then
686: hr_utility.set_location(l_proc, 50);
687: end if;
688: --
689: if (l_pay_installed = 'Y') then
690: --

Line 692: hr_utility.set_location(l_proc, 55);

688: --
689: if (l_pay_installed = 'Y') then
690: --
691: if g_debug then
692: hr_utility.set_location(l_proc, 55);
693: end if;
694: --
695: hr_person_internal.pay_predel_validation(P_PERSON_ID);
696: --

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

719: --
720: hr_person_internal.ben_predel_validation(P_PERSON_ID,p_effective_date);
721: --
722: if g_debug then
723: hr_utility.set_location(l_proc, 60);
724: end if;
725: --
726: hr_person_internal.closed_element_entry_check(P_PERSON_ID, p_effective_date);
727: --

Line 729: hr_utility.set_location(l_proc, 70);

725: --
726: hr_person_internal.closed_element_entry_check(P_PERSON_ID, p_effective_date);
727: --
728: if g_debug then
729: hr_utility.set_location(l_proc, 70);
730: end if;
731: --
732: hr_person_internal.contact_cobra_validation(P_PERSON_ID);
733: --

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

731: --
732: hr_person_internal.contact_cobra_validation(P_PERSON_ID);
733: --
734: if g_debug then
735: hr_utility.set_location(l_proc, 80);
736: end if;
737: --
738: hr_person_internal.contracts_check(P_PERSON_ID);
739: --

Line 741: hr_utility.set_location(l_proc, 90);

737: --
738: hr_person_internal.contracts_check(P_PERSON_ID);
739: --
740: if g_debug then
741: hr_utility.set_location(l_proc, 90);
742: end if;
743: -- Bug 14028011
744: per_ota_predel_validation.ota_predel_per_validation(P_PERSON_ID);
745: --

Line 747: hr_utility.set_location('Leaving:'||l_proc, 100);

743: -- Bug 14028011
744: per_ota_predel_validation.ota_predel_per_validation(P_PERSON_ID);
745: --
746: if g_debug then
747: hr_utility.set_location('Leaving:'||l_proc, 100);
748: end if;
749: --
750: END weak_predel_validation;
751: --

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

786: --
787: BEGIN
788: --
789: if g_debug then
790: hr_utility.set_location('Entering:'|| l_proc, 10);
791: end if;
792: --
793: -- check if person type changes exist.
794: --

Line 843: hr_utility.set_message (801,'HR_6324_ALL_PER_ADD_NO_DEL');

839:
840: --
841: if l_person_types > 0 then
842: --
843: hr_utility.set_message (801,'HR_6324_ALL_PER_ADD_NO_DEL');
844: hr_utility.raise_error;
845: --
846: end if;
847: --

Line 844: hr_utility.raise_error;

840: --
841: if l_person_types > 0 then
842: --
843: hr_utility.set_message (801,'HR_6324_ALL_PER_ADD_NO_DEL');
844: hr_utility.raise_error;
845: --
846: end if;
847: --
848: if g_debug then

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

845: --
846: end if;
847: --
848: if g_debug then
849: hr_utility.set_location(l_proc, 20);
850: end if;
851: --
852: begin
853: --

Line 881: hr_utility.set_message (801,'HR_6325_ALL_PER_RL_NO_DEL');

877: and a.assignment_id = r.assignment_id));
878: --
879: exception
880: when NO_DATA_FOUND then
881: hr_utility.set_message (801,'HR_6325_ALL_PER_RL_NO_DEL');
882: hr_utility.raise_error;
883: end;
884: --
885: if g_debug then

Line 882: hr_utility.raise_error;

878: --
879: exception
880: when NO_DATA_FOUND then
881: hr_utility.set_message (801,'HR_6325_ALL_PER_RL_NO_DEL');
882: hr_utility.raise_error;
883: end;
884: --
885: if g_debug then
886: hr_utility.set_location(l_proc, 30);

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

882: hr_utility.raise_error;
883: end;
884: --
885: if g_debug then
886: hr_utility.set_location(l_proc, 30);
887: end if;
888: --
889: begin
890: --

Line 902: hr_utility.set_message (801,'HR_6326_ALL_PER_CR_NO_DEL');

898: or r.contact_person_id = P_PERSON_ID);
899: --
900: exception
901: when NO_DATA_FOUND then
902: hr_utility.set_message (801,'HR_6326_ALL_PER_CR_NO_DEL');
903: hr_utility.raise_error;
904: end;
905: --
906: if g_debug then

Line 903: hr_utility.raise_error;

899: --
900: exception
901: when NO_DATA_FOUND then
902: hr_utility.set_message (801,'HR_6326_ALL_PER_CR_NO_DEL');
903: hr_utility.raise_error;
904: end;
905: --
906: if g_debug then
907: hr_utility.set_location(l_proc, 40);

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

903: hr_utility.raise_error;
904: end;
905: --
906: if g_debug then
907: hr_utility.set_location(l_proc, 40);
908: end if;
909: --
910: begin
911: --

Line 922: hr_utility.set_message (801,'HR_6328_ALL_PER_EVENT_NO_DEL');

918: where e.internal_contact_person_id = P_PERSON_ID);
919: --
920: exception
921: when NO_DATA_FOUND then
922: hr_utility.set_message (801,'HR_6328_ALL_PER_EVENT_NO_DEL');
923: hr_utility.raise_error;
924: end;
925: --
926: if g_debug then

Line 923: hr_utility.raise_error;

919: --
920: exception
921: when NO_DATA_FOUND then
922: hr_utility.set_message (801,'HR_6328_ALL_PER_EVENT_NO_DEL');
923: hr_utility.raise_error;
924: end;
925: --
926: if g_debug then
927: hr_utility.set_location(l_proc, 50);

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

923: hr_utility.raise_error;
924: end;
925: --
926: if g_debug then
927: hr_utility.set_location(l_proc, 50);
928: end if;
929: --
930: begin
931: --

Line 942: hr_utility.set_message (801,'HR_6329_ALL_PER_BOOK_NO_DEL');

938: where b.person_id = P_PERSON_ID);
939: --
940: exception
941: when NO_DATA_FOUND then
942: hr_utility.set_message (801,'HR_6329_ALL_PER_BOOK_NO_DEL');
943: hr_utility.raise_error;
944: end;
945: --
946: if g_debug then

Line 943: hr_utility.raise_error;

939: --
940: exception
941: when NO_DATA_FOUND then
942: hr_utility.set_message (801,'HR_6329_ALL_PER_BOOK_NO_DEL');
943: hr_utility.raise_error;
944: end;
945: --
946: if g_debug then
947: hr_utility.set_location(l_proc, 60);

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

943: hr_utility.raise_error;
944: end;
945: --
946: if g_debug then
947: hr_utility.set_location(l_proc, 60);
948: end if;
949: --
950: begin
951: --

Line 963: hr_utility.set_message (801,'HR_6330_ALL_PER_ASSGT_NO_DEL');

959: and a.effective_start_date >= p_effective_date);
960: --
961: exception
962: when NO_DATA_FOUND then
963: hr_utility.set_message (801,'HR_6330_ALL_PER_ASSGT_NO_DEL');
964: hr_utility.raise_error;
965: end;
966: --
967: if g_debug then

Line 964: hr_utility.raise_error;

960: --
961: exception
962: when NO_DATA_FOUND then
963: hr_utility.set_message (801,'HR_6330_ALL_PER_ASSGT_NO_DEL');
964: hr_utility.raise_error;
965: end;
966: --
967: if g_debug then
968: hr_utility.set_location(l_proc, 70);

Line 968: hr_utility.set_location(l_proc, 70);

964: hr_utility.raise_error;
965: end;
966: --
967: if g_debug then
968: hr_utility.set_location(l_proc, 70);
969: end if;
970: --
971: begin
972: --

Line 984: hr_utility.set_message (801,'HR_6331_ALL_PER_RT_SUP_NO_DEL');

980: or a.supervisor_id = P_PERSON_ID);
981: --
982: exception
983: when NO_DATA_FOUND then
984: hr_utility.set_message (801,'HR_6331_ALL_PER_RT_SUP_NO_DEL');
985: hr_utility.raise_error;
986: end;
987: --
988: if g_debug then

Line 985: hr_utility.raise_error;

981: --
982: exception
983: when NO_DATA_FOUND then
984: hr_utility.set_message (801,'HR_6331_ALL_PER_RT_SUP_NO_DEL');
985: hr_utility.raise_error;
986: end;
987: --
988: if g_debug then
989: hr_utility.set_location(l_proc, 80);

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

985: hr_utility.raise_error;
986: end;
987: --
988: if g_debug then
989: hr_utility.set_location(l_proc, 80);
990: end if;
991: --
992: begin
993: --

Line 1004: hr_utility.set_message (801,'HR_6332_ALL_PER_TERM_NO_DEL');

1000: where p.termination_accepted_person_id = P_PERSON_ID);
1001: --
1002: exception
1003: when NO_DATA_FOUND then
1004: hr_utility.set_message (801,'HR_6332_ALL_PER_TERM_NO_DEL');
1005: hr_utility.raise_error;
1006: end;
1007: --
1008: if g_debug then

Line 1005: hr_utility.raise_error;

1001: --
1002: exception
1003: when NO_DATA_FOUND then
1004: hr_utility.set_message (801,'HR_6332_ALL_PER_TERM_NO_DEL');
1005: hr_utility.raise_error;
1006: end;
1007: --
1008: if g_debug then
1009: hr_utility.set_location(l_proc, 90);

Line 1009: hr_utility.set_location(l_proc, 90);

1005: hr_utility.raise_error;
1006: end;
1007: --
1008: if g_debug then
1009: hr_utility.set_location(l_proc, 90);
1010: end if;
1011: --
1012: begin
1013: --

Line 1024: hr_utility.set_message (801,'HR_6334_ALL_PER_ANAL_NO_DEL');

1020: where a.person_id = P_PERSON_ID);
1021: --
1022: exception
1023: when NO_DATA_FOUND then
1024: hr_utility.set_message (801,'HR_6334_ALL_PER_ANAL_NO_DEL');
1025: hr_utility.raise_error;
1026: end;
1027: --
1028: if g_debug then

Line 1025: hr_utility.raise_error;

1021: --
1022: exception
1023: when NO_DATA_FOUND then
1024: hr_utility.set_message (801,'HR_6334_ALL_PER_ANAL_NO_DEL');
1025: hr_utility.raise_error;
1026: end;
1027: --
1028: if g_debug then
1029: hr_utility.set_location(l_proc, 100);

Line 1029: hr_utility.set_location(l_proc, 100);

1025: hr_utility.raise_error;
1026: end;
1027: --
1028: if g_debug then
1029: hr_utility.set_location(l_proc, 100);
1030: end if;
1031: --
1032: begin
1033: --

Line 1044: hr_utility.set_message (801,'HR_6335_ALL_PER_ABS_ATT_NO_DEL');

1040: where a.person_id = P_PERSON_ID);
1041: --
1042: exception
1043: when NO_DATA_FOUND then
1044: hr_utility.set_message (801,'HR_6335_ALL_PER_ABS_ATT_NO_DEL');
1045: hr_utility.raise_error;
1046: end;
1047: --
1048: if g_debug then

Line 1045: hr_utility.raise_error;

1041: --
1042: exception
1043: when NO_DATA_FOUND then
1044: hr_utility.set_message (801,'HR_6335_ALL_PER_ABS_ATT_NO_DEL');
1045: hr_utility.raise_error;
1046: end;
1047: --
1048: if g_debug then
1049: hr_utility.set_location(l_proc, 110);

Line 1049: hr_utility.set_location(l_proc, 110);

1045: hr_utility.raise_error;
1046: end;
1047: --
1048: if g_debug then
1049: hr_utility.set_location(l_proc, 110);
1050: end if;
1051: --
1052: begin
1053: --

Line 1065: hr_utility.set_message (801,'HR_6336_ALL_PER_AUTH_NO_DEL');

1061: or a.replacement_person_id = P_PERSON_ID);
1062: --
1063: exception
1064: when NO_DATA_FOUND then
1065: hr_utility.set_message (801,'HR_6336_ALL_PER_AUTH_NO_DEL');
1066: hr_utility.raise_error;
1067: end;
1068: --
1069: if g_debug then

Line 1066: hr_utility.raise_error;

1062: --
1063: exception
1064: when NO_DATA_FOUND then
1065: hr_utility.set_message (801,'HR_6336_ALL_PER_AUTH_NO_DEL');
1066: hr_utility.raise_error;
1067: end;
1068: --
1069: if g_debug then
1070: hr_utility.set_location(l_proc, 120);

Line 1070: hr_utility.set_location(l_proc, 120);

1066: hr_utility.raise_error;
1067: end;
1068: --
1069: if g_debug then
1070: hr_utility.set_location(l_proc, 120);
1071: end if;
1072: --
1073: begin
1074: --

Line 1086: hr_utility.set_message (801,'HR_6337_ALL_PER_REC_NO_DEL');

1082: or r.internal_contact_person_id = P_PERSON_ID);
1083: --
1084: exception
1085: when NO_DATA_FOUND then
1086: hr_utility.set_message (801,'HR_6337_ALL_PER_REC_NO_DEL');
1087: hr_utility.raise_error;
1088: end;
1089: --
1090: if g_debug then

Line 1087: hr_utility.raise_error;

1083: --
1084: exception
1085: when NO_DATA_FOUND then
1086: hr_utility.set_message (801,'HR_6337_ALL_PER_REC_NO_DEL');
1087: hr_utility.raise_error;
1088: end;
1089: --
1090: if g_debug then
1091: hr_utility.set_location(l_proc, 130);

Line 1091: hr_utility.set_location(l_proc, 130);

1087: hr_utility.raise_error;
1088: end;
1089: --
1090: if g_debug then
1091: hr_utility.set_location(l_proc, 130);
1092: end if;
1093: --
1094: begin
1095: --

Line 1112: hr_utility.set_location(l_proc, 140);

1108: fnd_message.raise_error;
1109: end;
1110: --
1111: if g_debug then
1112: hr_utility.set_location(l_proc, 140);
1113: end if;
1114: --
1115: begin
1116: --

Line 1132: hr_utility.set_location(l_proc, 150);

1128: fnd_message.raise_error;
1129: end;
1130: --
1131: if g_debug then
1132: hr_utility.set_location(l_proc, 150);
1133: end if;
1134: --
1135: begin
1136: --

Line 1147: hr_utility.set_message (801,'HR_6338_ALL_PER_REQ_NO_DEL');

1143: where r.person_id = P_PERSON_ID);
1144: --
1145: exception
1146: when NO_DATA_FOUND then
1147: hr_utility.set_message (801,'HR_6338_ALL_PER_REQ_NO_DEL');
1148: hr_utility.raise_error;
1149: end;
1150: --
1151: if g_debug then

Line 1148: hr_utility.raise_error;

1144: --
1145: exception
1146: when NO_DATA_FOUND then
1147: hr_utility.set_message (801,'HR_6338_ALL_PER_REQ_NO_DEL');
1148: hr_utility.raise_error;
1149: end;
1150: --
1151: if g_debug then
1152: hr_utility.set_location(l_proc, 160);

Line 1152: hr_utility.set_location(l_proc, 160);

1148: hr_utility.raise_error;
1149: end;
1150: --
1151: if g_debug then
1152: hr_utility.set_location(l_proc, 160);
1153: end if;
1154: --
1155: begin
1156: --

Line 1167: hr_utility.set_message (801,'HR_6339_ALL_PER_VAC_NO_DEL');

1163: where v.recruiter_id = P_PERSON_ID);
1164: --
1165: exception
1166: when NO_DATA_FOUND then
1167: hr_utility.set_message (801,'HR_6339_ALL_PER_VAC_NO_DEL');
1168: hr_utility.raise_error;
1169: end;
1170: --
1171: if g_debug then

Line 1168: hr_utility.raise_error;

1164: --
1165: exception
1166: when NO_DATA_FOUND then
1167: hr_utility.set_message (801,'HR_6339_ALL_PER_VAC_NO_DEL');
1168: hr_utility.raise_error;
1169: end;
1170: --
1171: if g_debug then
1172: hr_utility.set_location(l_proc, 170);

Line 1172: hr_utility.set_location(l_proc, 170);

1168: hr_utility.raise_error;
1169: end;
1170: --
1171: if g_debug then
1172: hr_utility.set_location(l_proc, 170);
1173: end if;
1174: --
1175: -- Any discretionary link element entries?
1176: --

Line 1194: hr_utility.set_message (801,'HR_6340_ALL_PER_DISC_NO_DEL');

1190: and l.standard_link_flag = 'N');
1191: --
1192: exception
1193: when NO_DATA_FOUND then
1194: hr_utility.set_message (801,'HR_6340_ALL_PER_DISC_NO_DEL');
1195: hr_utility.raise_error;
1196: end;
1197: --
1198: if g_debug then

Line 1195: hr_utility.raise_error;

1191: --
1192: exception
1193: when NO_DATA_FOUND then
1194: hr_utility.set_message (801,'HR_6340_ALL_PER_DISC_NO_DEL');
1195: hr_utility.raise_error;
1196: end;
1197: --
1198: if g_debug then
1199: hr_utility.set_location(l_proc, 180);

Line 1199: hr_utility.set_location(l_proc, 180);

1195: hr_utility.raise_error;
1196: end;
1197: --
1198: if g_debug then
1199: hr_utility.set_location(l_proc, 180);
1200: end if;
1201: --
1202: -- Any entry adjustments, overrides etc.?
1203: -- (We cannot capture manual enty of standard link entries)

Line 1220: hr_utility.set_message (801,'HR_6375_ALL_PER_ENTRY_NO_DEL');

1216: and e.entry_type <> 'E');
1217: --
1218: exception
1219: when NO_DATA_FOUND then
1220: hr_utility.set_message (801,'HR_6375_ALL_PER_ENTRY_NO_DEL');
1221: hr_utility.raise_error;
1222: end;
1223: --
1224: if g_debug then

Line 1221: hr_utility.raise_error;

1217: --
1218: exception
1219: when NO_DATA_FOUND then
1220: hr_utility.set_message (801,'HR_6375_ALL_PER_ENTRY_NO_DEL');
1221: hr_utility.raise_error;
1222: end;
1223: --
1224: if g_debug then
1225: hr_utility.set_location(l_proc, 190);

Line 1225: hr_utility.set_location(l_proc, 190);

1221: hr_utility.raise_error;
1222: end;
1223: --
1224: if g_debug then
1225: hr_utility.set_location(l_proc, 190);
1226: end if;
1227: --
1228: begin
1229: --

Line 1244: hr_utility.set_message (801,'HR_6341_ALL_PER_ASS_INFO_DEL');

1240: and a.assignment_id = i.assignment_id));
1241: --
1242: exception
1243: when NO_DATA_FOUND then
1244: hr_utility.set_message (801,'HR_6341_ALL_PER_ASS_INFO_DEL');
1245: hr_utility.raise_error;
1246: end;
1247: --
1248: if g_debug then

Line 1245: hr_utility.raise_error;

1241: --
1242: exception
1243: when NO_DATA_FOUND then
1244: hr_utility.set_message (801,'HR_6341_ALL_PER_ASS_INFO_DEL');
1245: hr_utility.raise_error;
1246: end;
1247: --
1248: if g_debug then
1249: hr_utility.set_location(l_proc, 200);

Line 1249: hr_utility.set_location(l_proc, 200);

1245: hr_utility.raise_error;
1246: end;
1247: --
1248: if g_debug then
1249: hr_utility.set_location(l_proc, 200);
1250: end if;
1251: --
1252: begin
1253: --

Line 1268: hr_utility.set_message (801,'HR_6340_ALL_PER_DISC_NO_DEL');

1264: and a.assignment_id = s.assignment_id));
1265: --
1266: exception
1267: when NO_DATA_FOUND then
1268: hr_utility.set_message (801,'HR_6340_ALL_PER_DISC_NO_DEL');
1269: hr_utility.raise_error;
1270: end;
1271: --
1272: if g_debug then

Line 1269: hr_utility.raise_error;

1265: --
1266: exception
1267: when NO_DATA_FOUND then
1268: hr_utility.set_message (801,'HR_6340_ALL_PER_DISC_NO_DEL');
1269: hr_utility.raise_error;
1270: end;
1271: --
1272: if g_debug then
1273: hr_utility.set_location(l_proc, 210);

Line 1273: hr_utility.set_location(l_proc, 210);

1269: hr_utility.raise_error;
1270: end;
1271: --
1272: if g_debug then
1273: hr_utility.set_location(l_proc, 210);
1274: end if;
1275: --
1276: begin
1277: --

Line 1292: hr_utility.set_message (801,'HR_6344_ALL_PER_INT_NO_DEL');

1288: and a.assignment_id = e.assignment_id));
1289: --
1290: exception
1291: when NO_DATA_FOUND then
1292: hr_utility.set_message (801,'HR_6344_ALL_PER_INT_NO_DEL');
1293: hr_utility.raise_error;
1294: end;
1295: --
1296: if g_debug then

Line 1293: hr_utility.raise_error;

1289: --
1290: exception
1291: when NO_DATA_FOUND then
1292: hr_utility.set_message (801,'HR_6344_ALL_PER_INT_NO_DEL');
1293: hr_utility.raise_error;
1294: end;
1295: --
1296: if g_debug then
1297: hr_utility.set_location(l_proc, 220);

Line 1297: hr_utility.set_location(l_proc, 220);

1293: hr_utility.raise_error;
1294: end;
1295: --
1296: if g_debug then
1297: hr_utility.set_location(l_proc, 220);
1298: end if;
1299: --
1300: begin
1301: --

Line 1316: hr_utility.set_message (801,'HR_6374_ALL_PER_SPINE_NO_DEL');

1312: and a.assignment_id = p.assignment_id));
1313: --
1314: exception
1315: when NO_DATA_FOUND then
1316: hr_utility.set_message (801,'HR_6374_ALL_PER_SPINE_NO_DEL');
1317: hr_utility.raise_error;
1318: end;
1319: --
1320: if g_debug then

Line 1317: hr_utility.raise_error;

1313: --
1314: exception
1315: when NO_DATA_FOUND then
1316: hr_utility.set_message (801,'HR_6374_ALL_PER_SPINE_NO_DEL');
1317: hr_utility.raise_error;
1318: end;
1319: --
1320: if g_debug then
1321: hr_utility.set_location(l_proc, 230);

Line 1321: hr_utility.set_location(l_proc, 230);

1317: hr_utility.raise_error;
1318: end;
1319: --
1320: if g_debug then
1321: hr_utility.set_location(l_proc, 230);
1322: end if;
1323: --
1324: begin
1325: --

Line 1340: hr_utility.set_message (801,'HR_6379_ALL_PER_QP_NO_DEL');

1336: and a.assignment_id = t.assignment_id));
1337: --
1338: exception
1339: when NO_DATA_FOUND then
1340: hr_utility.set_message (801,'HR_6379_ALL_PER_QP_NO_DEL');
1341: hr_utility.raise_error;
1342: end;
1343: --
1344: if g_debug then

Line 1341: hr_utility.raise_error;

1337: --
1338: exception
1339: when NO_DATA_FOUND then
1340: hr_utility.set_message (801,'HR_6379_ALL_PER_QP_NO_DEL');
1341: hr_utility.raise_error;
1342: end;
1343: --
1344: if g_debug then
1345: hr_utility.set_location(l_proc, 240);

Line 1345: hr_utility.set_location(l_proc, 240);

1341: hr_utility.raise_error;
1342: end;
1343: --
1344: if g_debug then
1345: hr_utility.set_location(l_proc, 240);
1346: end if;
1347: --
1348: begin
1349: --

Line 1364: hr_utility.set_message (801,'HR_6476_ALL_PER_COB_NO_DEL');

1360: and a.assignment_id = c.assignment_id));
1361: --
1362: exception
1363: when NO_DATA_FOUND then
1364: hr_utility.set_message (801,'HR_6476_ALL_PER_COB_NO_DEL');
1365: hr_utility.raise_error;
1366: end;
1367: --
1368: if g_debug then

Line 1365: hr_utility.raise_error;

1361: --
1362: exception
1363: when NO_DATA_FOUND then
1364: hr_utility.set_message (801,'HR_6476_ALL_PER_COB_NO_DEL');
1365: hr_utility.raise_error;
1366: end;
1367: --
1368: if g_debug then
1369: hr_utility.set_location(l_proc, 250);

Line 1369: hr_utility.set_location(l_proc, 250);

1365: hr_utility.raise_error;
1366: end;
1367: --
1368: if g_debug then
1369: hr_utility.set_location(l_proc, 250);
1370: end if;
1371: --
1372: OPEN ben_ext_chg_log (p_person_id);
1373: --

Line 1391: hr_utility.set_location(l_proc, 260);

1387: --
1388: ben_person_delete.perform_ri_check(p_person_id);
1389: --
1390: if g_debug then
1391: hr_utility.set_location(l_proc, 260);
1392: end if;
1393: --
1394: -- Validation for OTA.
1395: --

Line 1401: hr_utility.set_location(l_proc, 270);

1397: --
1398: -- validation for PA
1399: --
1400: if g_debug then
1401: hr_utility.set_location(l_proc, 270);
1402: end if;
1403: --
1404: pa_person.pa_predel_validation(P_PERSON_ID);
1405: --

Line 1409: hr_utility.set_location(l_proc, 280);

1405: --
1406: -- validation for WIP
1407: --
1408: if g_debug then
1409: hr_utility.set_location(l_proc, 280);
1410: end if;
1411: --
1412: wip_person.wip_predel_validation(P_PERSON_ID);
1413: --

Line 1417: hr_utility.set_location(l_proc, 290);

1413: --
1414: -- validation for ENG
1415: --
1416: if g_debug then
1417: hr_utility.set_location(l_proc, 290);
1418: end if;
1419: --
1420: eng_person.eng_predel_validation(P_PERSON_ID);
1421: --

Line 1425: hr_utility.set_location(l_proc, 300);

1421: --
1422: -- validation for AP
1423: --
1424: if g_debug then
1425: hr_utility.set_location(l_proc, 300);
1426: end if;
1427: --
1428: ap_person.ap_predel_validation(P_PERSON_ID);
1429: --

Line 1433: hr_utility.set_location(l_proc, 310);

1429: --
1430: -- validation for FA
1431: --
1432: if g_debug then
1433: hr_utility.set_location(l_proc, 310);
1434: end if;
1435: --
1436: fa_person.fa_predel_validation(P_PERSON_ID);
1437: --

Line 1441: hr_utility.set_location(l_proc, 320);

1437: --
1438: -- validation for PO
1439: --
1440: if g_debug then
1441: hr_utility.set_location(l_proc, 320);
1442: end if;
1443: --
1444: po_person.po_predel_validation(P_PERSON_ID);
1445: --

Line 1449: hr_utility.set_location(l_proc, 330);

1445: --
1446: -- validation for RCV
1447: --
1448: if g_debug then
1449: hr_utility.set_location(l_proc, 330);
1450: end if;
1451: --
1452: rcv_person.rcv_predel_validation(P_PERSON_ID);
1453: --

Line 1455: hr_utility.set_location('Leaving:'||l_proc, 999);

1451: --
1452: rcv_person.rcv_predel_validation(P_PERSON_ID);
1453: --
1454: if g_debug then
1455: hr_utility.set_location('Leaving:'||l_proc, 999);
1456: end if;
1457: --
1458: END strong_predel_validation;
1459: --

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

1505: --
1506: BEGIN
1507: --
1508: if g_debug then
1509: hr_utility.set_location('Entering:'||l_proc, 10);
1510: end if;
1511: --
1512: hr_person_internal.person_existance_check(P_PERSON_ID);
1513: --

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

1511: --
1512: hr_person_internal.person_existance_check(P_PERSON_ID);
1513: --
1514: if g_debug then
1515: hr_utility.set_location(l_proc, 20);
1516: end if;
1517: --
1518: open LOCK_PERSON_ROWS;
1519: --

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

1527: --
1528: -- End of Fix for WWBUG 1294400
1529: --
1530: if g_debug then
1531: hr_utility.set_location(l_proc, 30);
1532: end if;
1533: --
1534: hr_security.delete_per_from_list(P_PERSON_ID);
1535: --

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

1533: --
1534: hr_security.delete_per_from_list(P_PERSON_ID);
1535: --
1536: if g_debug then
1537: hr_utility.set_location(l_proc, 40);
1538: end if;
1539: --
1540: -- Lock assignments now, delete at end.
1541: -- Can select into a variable as max one assignment should exist (as

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

1553: when NO_DATA_FOUND then null;
1554: end;
1555: --
1556: if g_debug then
1557: hr_utility.set_location(l_proc, 50);
1558: end if;
1559: --
1560: begin
1561: --

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

1565: when NO_DATA_FOUND then null;
1566: end;
1567: --
1568: if g_debug then
1569: hr_utility.set_location(l_proc, 60);
1570: end if;
1571: --
1572: begin
1573: --

Line 1581: hr_utility.set_location(l_proc, 70);

1577: when NO_DATA_FOUND then null;
1578: end;
1579: --
1580: if g_debug then
1581: hr_utility.set_location(l_proc, 70);
1582: end if;
1583: --
1584: begin
1585: delete from per_addresses a

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

1588: when NO_DATA_FOUND then null;
1589: end;
1590: --
1591: if g_debug then
1592: hr_utility.set_location(l_proc, 80);
1593: end if;
1594: --
1595: begin
1596: delete from per_phones a

Line 1604: hr_utility.set_location(l_proc, 90);

1600: when NO_DATA_FOUND then null;
1601: end;
1602: --
1603: if g_debug then
1604: hr_utility.set_location(l_proc, 90);
1605: end if;
1606: --
1607: begin
1608: delete from pay_cost_allocations_f a

Line 1615: hr_utility.set_location(l_proc, 100);

1611: when NO_DATA_FOUND then null;
1612: end;
1613: --
1614: if g_debug then
1615: hr_utility.set_location(l_proc, 100);
1616: end if;
1617: --
1618: begin
1619: delete from pay_element_entry_values_f v

Line 1629: hr_utility.set_location(l_proc, 110);

1625: when NO_DATA_FOUND then null;
1626: end;
1627: --
1628: if g_debug then
1629: hr_utility.set_location(l_proc, 110);
1630: end if;
1631: --
1632: begin
1633: delete from pay_run_results r

Line 1644: hr_utility.set_location(l_proc, 120);

1640: when NO_DATA_FOUND then null;
1641: end;
1642: --
1643: if g_debug then
1644: hr_utility.set_location(l_proc, 120);
1645: end if;
1646: --
1647: begin
1648: delete from pay_element_entries_f e

Line 1655: hr_utility.set_location(l_proc, 130);

1651: when NO_DATA_FOUND then null;
1652: end;
1653: --
1654: if g_debug then
1655: hr_utility.set_location(l_proc, 130);
1656: end if;
1657: --
1658: -- No exception, should succeed.
1659: --

Line 1666: hr_utility.set_location(l_proc, 140);

1662: where ass.assignment_id = l_assignment_id;
1663: end;
1664: --
1665: if g_debug then
1666: hr_utility.set_location(l_proc, 140);
1667: end if;
1668: --
1669: begin
1670: delete from per_periods_of_service p

Line 1677: hr_utility.set_location(l_proc, 150);

1673: when NO_DATA_FOUND then null;
1674: end;
1675: --
1676: if g_debug then
1677: hr_utility.set_location(l_proc, 150);
1678: end if;
1679: --
1680: begin
1681: delete from per_applications a

Line 1690: hr_utility.set_location(l_proc, 160);

1686: --
1687: -- Added this delete for quickhire checklists
1688: --
1689: if g_debug then
1690: hr_utility.set_location(l_proc, 160);
1691: end if;
1692: --
1693: begin
1694: delete from per_checklist_items

Line 1704: hr_utility.set_location(l_proc, 170);

1700: -- End addition for quickhire checklists
1701: --
1702: --
1703: if g_debug then
1704: hr_utility.set_location(l_proc, 170);
1705: end if;
1706: --
1707: close LOCK_PERSON_ROWS;
1708: --

Line 1710: hr_utility.set_location(l_proc, 180);

1706: --
1707: close LOCK_PERSON_ROWS;
1708: --
1709: if g_debug then
1710: hr_utility.set_location(l_proc, 180);
1711: end if;
1712: --
1713: begin
1714: delete from per_people_f

Line 1721: hr_utility.set_location(l_proc, 190);

1717: when NO_DATA_FOUND then null;
1718: end;
1719: --
1720: if g_debug then
1721: hr_utility.set_location(l_proc, 190);
1722: end if;
1723: --
1724: begin
1725: delete from per_periods_of_placement p

Line 1732: hr_utility.set_location('Leaving:'||l_proc, 999);

1728: when NO_DATA_FOUND then null;
1729: end;
1730: --
1731: if g_debug then
1732: hr_utility.set_location('Leaving:'||l_proc, 999);
1733: end if;
1734: --
1735: begin
1736: for attached_docs_rec in attached_docs_cursor1

Line 1757: hr_utility.set_location('Leaving:'||l_proc, 999);

1753: exception
1754: when NO_DATA_FOUND then null;
1755: end;
1756: if g_debug then
1757: hr_utility.set_location('Leaving:'||l_proc, 999);
1758: end if;
1759: --
1760: END people_default_deletes;
1761: --

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

1802: --
1803: BEGIN
1804: --
1805: if g_debug then
1806: hr_utility.set_location('Entering:'||l_proc, 10);
1807: end if;
1808: --
1809: hr_person_internal.person_existance_check(P_PERSON_ID);
1810: --

Line 1812: hr_utility.set_location(l_proc, 10);

1808: --
1809: hr_person_internal.person_existance_check(P_PERSON_ID);
1810: --
1811: if g_debug then
1812: hr_utility.set_location(l_proc, 10);
1813: end if;
1814: --
1815: open LOCK_PERSON_ROWS;
1816: --

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

1816: --
1817: -- Now start cascade.
1818: --
1819: if g_debug then
1820: hr_utility.set_location(l_proc, 20);
1821: end if;
1822: --
1823: begin
1824: delete from per_person_list l

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

1827: when NO_DATA_FOUND then null;
1828: end;
1829: --
1830: if g_debug then
1831: hr_utility.set_location(l_proc, 30);
1832: end if;
1833: --
1834: -- Can select into a variable as only one assignment should exist (as
1835: -- strong_predel_validation has already been performed).

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

1842: FOR UPDATE;
1843: end;
1844: --
1845: if g_debug then
1846: hr_utility.set_location(l_proc, 40);
1847: end if;
1848: --
1849: begin
1850: delete from per_addresses a

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

1853: when NO_DATA_FOUND then null;
1854: end;
1855: --
1856: if g_debug then
1857: hr_utility.set_location(l_proc, 50);
1858: end if;
1859: --
1860: begin
1861: delete from per_phones a

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

1865: when NO_DATA_FOUND then null;
1866: end;
1867: --
1868: if g_debug then
1869: hr_utility.set_location(l_proc, 60);
1870: end if;
1871: --
1872: begin
1873: delete from per_assignments_f ass

Line 1878: hr_utility.set_location(l_proc, 70);

1874: where ass.assignment_id = l_assignment_id;
1875: end;
1876: --
1877: if g_debug then
1878: hr_utility.set_location(l_proc, 70);
1879: end if;
1880: --
1881: begin
1882: delete from per_applications a

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

1887: --
1888: -- Added this delete for quickhire checklists
1889: --
1890: if g_debug then
1891: hr_utility.set_location(l_proc, 80);
1892: end if;
1893: --
1894: begin
1895: delete from per_checklist_items

Line 1906: hr_utility.set_location(l_proc, 90);

1902: --
1903: -- Added this delete for PTU
1904: --
1905: if g_debug then
1906: hr_utility.set_location(l_proc, 90);
1907: end if;
1908: --
1909: begin
1910: delete from per_person_type_usages_f

Line 1919: hr_utility.set_location(l_proc, 100);

1915: --
1916: -- End addition for PTU
1917: --
1918: if g_debug then
1919: hr_utility.set_location(l_proc, 100);
1920: end if;
1921: --
1922: close LOCK_PERSON_ROWS;
1923: --

Line 1925: hr_utility.set_location(l_proc, 110);

1921: --
1922: close LOCK_PERSON_ROWS;
1923: --
1924: if g_debug then
1925: hr_utility.set_location(l_proc, 110);
1926: end if;
1927: --
1928: begin
1929: delete from per_people_f

Line 1936: hr_utility.set_location('Leaving:'||l_proc, 999);

1932: when NO_DATA_FOUND then null;
1933: end;
1934: --
1935: if g_debug then
1936: hr_utility.set_location('Leaving:'||l_proc, 999);
1937: end if;
1938: --
1939: begin
1940: for attached_docs_rec in attached_docs_cursor2

Line 1961: hr_utility.set_location('Leaving:'||l_proc, 999);

1957: exception
1958: when NO_DATA_FOUND then null;
1959: end;
1960: if g_debug then
1961: hr_utility.set_location('Leaving:'||l_proc, 999);
1962: end if;
1963: --
1964: END applicant_default_deletes;
1965: --

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

2082: -- Fix for 4490489 ends here
2083: BEGIN
2084: --
2085: if g_debug then
2086: hr_utility.set_location('Entering:'||l_proc, 10);
2087: end if;
2088: --
2089: -- Lock person rows, delete at end of procedure.
2090: --

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

2092: --
2093: -- Now start cascade.
2094: --
2095: if g_debug then
2096: hr_utility.set_location(l_proc, 20);
2097: end if;
2098: --
2099: -- bug fix 3732129 starts here.
2100: -- fetching the assignment ids into a pl/sql table.

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

2105: --
2106: -- bug fix 3732129 ends here.
2107: --
2108: if g_debug then
2109: hr_utility.set_location(l_proc, 30);
2110: end if;
2111: --
2112: begin
2113: --

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

2117: --
2118: exception
2119: when NO_DATA_FOUND then
2120: if g_debug then
2121: hr_utility.set_location(l_proc, 40);
2122: end if;
2123: end;
2124: --
2125: if g_debug then

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

2122: end if;
2123: end;
2124: --
2125: if g_debug then
2126: hr_utility.set_location(l_proc, 50);
2127: end if;
2128: --
2129: begin
2130: -- bug fix 3732129.

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

2138: --
2139: exception
2140: when NO_DATA_FOUND then
2141: if g_debug then
2142: hr_utility.set_location(l_proc, 60);
2143: end if;
2144: end;
2145: --
2146: -- Leave per_letter_requests for the moment - may not be necessary to

Line 2151: hr_utility.set_location(l_proc, 70);

2147: -- delete the parent with no children which requires some work with
2148: -- cursors.
2149: --
2150: if g_debug then
2151: hr_utility.set_location(l_proc, 70);
2152: end if;
2153: --
2154: begin
2155: --

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

2158: --
2159: exception
2160: when NO_DATA_FOUND then
2161: if g_debug then
2162: hr_utility.set_location(l_proc, 80);
2163: end if;
2164: end;
2165: --
2166: if g_debug then

Line 2167: hr_utility.set_location(l_proc, 90);

2163: end if;
2164: end;
2165: --
2166: if g_debug then
2167: hr_utility.set_location(l_proc, 90);
2168: end if;
2169: --
2170: begin
2171: --

Line 2179: hr_utility.set_location(l_proc, 100);

2175: --
2176: exception
2177: when NO_DATA_FOUND then
2178: if g_debug then
2179: hr_utility.set_location(l_proc, 100);
2180: end if;
2181: end;
2182: --
2183: if g_debug then

Line 2184: hr_utility.set_location(l_proc, 110);

2180: end if;
2181: end;
2182: --
2183: if g_debug then
2184: hr_utility.set_location(l_proc, 110);
2185: end if;
2186: --
2187: begin
2188: --

Line 2196: hr_utility.set_location(l_proc, 120);

2192: --
2193: exception
2194: when NO_DATA_FOUND then
2195: if g_debug then
2196: hr_utility.set_location(l_proc, 120);
2197: end if;
2198: end;
2199: --
2200: if g_debug then

Line 2201: hr_utility.set_location(l_proc, 130);

2197: end if;
2198: end;
2199: --
2200: if g_debug then
2201: hr_utility.set_location(l_proc, 130);
2202: end if;
2203: --
2204: begin
2205: --

Line 2212: hr_utility.set_location(l_proc, 140);

2208: --
2209: exception
2210: when NO_DATA_FOUND then
2211: if g_debug then
2212: hr_utility.set_location(l_proc, 140);
2213: end if;
2214: end;
2215: --
2216: if g_debug then

Line 2217: hr_utility.set_location(l_proc, 150);

2213: end if;
2214: end;
2215: --
2216: if g_debug then
2217: hr_utility.set_location(l_proc, 150);
2218: end if;
2219: --
2220: -- Delete of per_periods_of_service at end after delete of
2221: -- per_assignments_f.

Line 2232: hr_utility.set_location(l_proc, 160);

2228: --
2229: exception
2230: when NO_DATA_FOUND then
2231: if g_debug then
2232: hr_utility.set_location(l_proc, 160);
2233: end if;
2234: end;
2235: --
2236: if g_debug then

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

2233: end if;
2234: end;
2235: --
2236: if g_debug then
2237: hr_utility.set_location(l_proc, 170);
2238: end if;
2239: --
2240: begin
2241: --

Line 2249: hr_utility.set_location(l_proc, 180);

2245: --
2246: exception
2247: when NO_DATA_FOUND then
2248: if g_debug then
2249: hr_utility.set_location(l_proc, 180);
2250: end if;
2251: end;
2252: --
2253: if g_debug then

Line 2254: hr_utility.set_location(l_proc, 190);

2250: end if;
2251: end;
2252: --
2253: if g_debug then
2254: hr_utility.set_location(l_proc, 190);
2255: end if;
2256: --
2257: begin
2258: --

Line 2266: hr_utility.set_location(l_proc, 200);

2262: --
2263: exception
2264: when NO_DATA_FOUND then
2265: if g_debug then
2266: hr_utility.set_location(l_proc, 200);
2267: end if;
2268: end;
2269: --
2270: if g_debug then

Line 2271: hr_utility.set_location(l_proc, 210);

2267: end if;
2268: end;
2269: --
2270: if g_debug then
2271: hr_utility.set_location(l_proc, 210);
2272: end if;
2273: --
2274: -- Bug 4873360 fix for performance repository sql id 14960331.
2275: -- Rewrote the delete query commented out below (and already once tuned for

Line 2296: hr_utility.set_location(l_proc, 211);

2292: exception
2293: when NO_DATA_FOUND then
2294: l_dummy := null;
2295: if g_debug then
2296: hr_utility.set_location(l_proc, 211);
2297: end if;
2298: end;
2299: if l_dummy = 1
2300: then

Line 2314: hr_utility.set_location(l_proc, 215);

2310: and qsa.type = 'PARTICIPANT'
2311: and par.person_id = P_PERSON_ID);
2312: end if;
2313: if g_debug then
2314: hr_utility.set_location(l_proc, 215);
2315: end if;
2316: end; -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
2317: begin -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2318: begin

Line 2331: hr_utility.set_location(l_proc, 220);

2327: exception
2328: when NO_DATA_FOUND then
2329: l_dummy := null;
2330: if g_debug then
2331: hr_utility.set_location(l_proc, 220);
2332: end if;
2333: end;
2334: if l_dummy = 2
2335: then

Line 2349: hr_utility.set_location(l_proc, 221);

2345: and qsa.type='APPRAISAL'
2346: and (apr.appraisee_person_id = P_PERSON_ID
2347: or apr.appraiser_person_id = P_PERSON_ID));
2348: if g_debug then
2349: hr_utility.set_location(l_proc, 221);
2350: end if;
2351: end if;
2352: end; -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2353: end; -- Delete from HR_QUEST_ANSWER_VALUES

Line 2375: hr_utility.set_location(l_proc, 220);

2371: ); -- Fix 3619599
2372: exception
2373: when NO_DATA_FOUND then
2374: if g_debug then
2375: hr_utility.set_location(l_proc, 220);
2376: end if;
2377: end; */
2378: -- Now delete from HR_QUEST_ANSWERS
2379: begin

Line 2406: hr_utility.set_location(l_proc, 230);

2402: --
2403: exception
2404: when NO_DATA_FOUND then
2405: if g_debug then
2406: hr_utility.set_location(l_proc, 230);
2407: end if;
2408: end;
2409: --
2410: -- Now delete from per_participants

Line 2435: hr_utility.set_location(l_proc, 240);

2431: --
2432: exception
2433: when NO_DATA_FOUND then
2434: if g_debug then
2435: hr_utility.set_location(l_proc, 240);
2436: end if;
2437: end;
2438: --
2439: -- Now delete from per_appraisals

Line 2452: hr_utility.set_location(l_proc, 250);

2448: --
2449: exception
2450: when NO_DATA_FOUND then
2451: if g_debug then
2452: hr_utility.set_location(l_proc, 250);
2453: end if;
2454: end;
2455: --
2456: */ -- commented as part of bug fix 9885957 suggested by Talent Mgmt team.

Line 2469: hr_utility.set_location(l_proc, 250);

2465: exception
2466:
2467: when NO_DATA_FOUND then
2468: if g_debug then
2469: hr_utility.set_location(l_proc, 250);
2470: end if;
2471: end;
2472:
2473: -- End of modification as part of Bug#11685107

Line 2476: hr_utility.set_location(l_proc, 260);

2472:
2473: -- End of modification as part of Bug#11685107
2474:
2475: if g_debug then
2476: hr_utility.set_location(l_proc, 260);
2477: end if;
2478: --
2479: hr_security.delete_per_from_list(P_PERSON_ID);
2480: --

Line 2482: hr_utility.set_location(l_proc, 270);

2478: --
2479: hr_security.delete_per_from_list(P_PERSON_ID);
2480: --
2481: if g_debug then
2482: hr_utility.set_location(l_proc, 270);
2483: end if;
2484: --
2485: begin
2486: --

Line 2494: hr_utility.set_location(l_proc, 280);

2490: --
2491: exception
2492: when NO_DATA_FOUND then
2493: if g_debug then
2494: hr_utility.set_location(l_proc, 280);
2495: end if;
2496: end;
2497: --
2498: if g_debug then

Line 2499: hr_utility.set_location(l_proc, 290);

2495: end if;
2496: end;
2497: --
2498: if g_debug then
2499: hr_utility.set_location(l_proc, 290);
2500: end if;
2501: --
2502: begin
2503: --

Line 2511: hr_utility.set_location(l_proc, 300);

2507: --
2508: exception
2509: when NO_DATA_FOUND then
2510: if g_debug then
2511: hr_utility.set_location(l_proc, 300);
2512: end if;
2513: end;
2514: --
2515: if g_debug then

Line 2516: hr_utility.set_location(l_proc, 310);

2512: end if;
2513: end;
2514: --
2515: if g_debug then
2516: hr_utility.set_location(l_proc, 310);
2517: end if;
2518: --
2519: begin
2520: --

Line 2528: hr_utility.set_location(l_proc, 320);

2524: --
2525: exception
2526: when NO_DATA_FOUND then
2527: if g_debug then
2528: hr_utility.set_location(l_proc, 320);
2529: end if;
2530: end;
2531: --
2532: if g_debug then

Line 2533: hr_utility.set_location(l_proc, 330);

2529: end if;
2530: end;
2531: --
2532: if g_debug then
2533: hr_utility.set_location(l_proc, 330);
2534: end if;
2535: --
2536: begin
2537: --

Line 2545: hr_utility.set_location(l_proc, 340);

2541: --
2542: exception
2543: when NO_DATA_FOUND then
2544: if g_debug then
2545: hr_utility.set_location(l_proc, 340);
2546: end if;
2547: end;
2548: --
2549: if g_debug then

Line 2550: hr_utility.set_location(l_proc, 350);

2546: end if;
2547: end;
2548: --
2549: if g_debug then
2550: hr_utility.set_location(l_proc, 350);
2551: end if;
2552: --
2553: -- LOCK ASSIGNMENTS NOW: have to use cursor as cannot return >1 row for
2554: -- 'into' part of PL/SQL.

Line 2559: hr_utility.set_location(l_proc, 360);

2555: --
2556: OPEN csr_lock_assignment_rows;
2557: --
2558: if g_debug then
2559: hr_utility.set_location(l_proc, 360);
2560: end if;
2561: --
2562: begin
2563: --

Line 2591: hr_utility.set_location(l_proc, 370);

2587: --
2588: exception
2589: when NO_DATA_FOUND then
2590: if g_debug then
2591: hr_utility.set_location(l_proc, 370);
2592: end if;
2593: end;
2594: --
2595: if g_debug then

Line 2596: hr_utility.set_location(l_proc, 380);

2592: end if;
2593: end;
2594: --
2595: if g_debug then
2596: hr_utility.set_location(l_proc, 380);
2597: end if;
2598: --
2599: begin
2600: --

Line 2610: hr_utility.set_location(l_proc, 390);

2606: --
2607: exception
2608: when NO_DATA_FOUND then
2609: if g_debug then
2610: hr_utility.set_location(l_proc, 390);
2611: end if;
2612: end;
2613: --
2614: if g_debug then

Line 2615: hr_utility.set_location(l_proc, 400);

2611: end if;
2612: end;
2613: --
2614: if g_debug then
2615: hr_utility.set_location(l_proc, 400);
2616: end if;
2617: --
2618: begin
2619: --

Line 2629: hr_utility.set_location(l_proc, 410);

2625: --
2626: exception
2627: when NO_DATA_FOUND then
2628: if g_debug then
2629: hr_utility.set_location(l_proc, 410);
2630: end if;
2631: end;
2632: --
2633: if g_debug then

Line 2634: hr_utility.set_location(l_proc, 420);

2630: end if;
2631: end;
2632: --
2633: if g_debug then
2634: hr_utility.set_location(l_proc, 420);
2635: end if;
2636: --
2637: begin
2638: --

Line 2648: hr_utility.set_location(l_proc, 430);

2644: --
2645: exception
2646: when NO_DATA_FOUND then
2647: if g_debug then
2648: hr_utility.set_location(l_proc, 430);
2649: end if;
2650: end;
2651: --
2652: if g_debug then

Line 2653: hr_utility.set_location(l_proc, 440);

2649: end if;
2650: end;
2651: --
2652: if g_debug then
2653: hr_utility.set_location(l_proc, 440);
2654: end if;
2655: --
2656: begin
2657: --

Line 2667: hr_utility.set_location(l_proc, 450);

2663: --
2664: exception
2665: when NO_DATA_FOUND then
2666: if g_debug then
2667: hr_utility.set_location(l_proc, 450);
2668: end if;
2669: end;
2670: --
2671: if g_debug then

Line 2672: hr_utility.set_location(l_proc, 460);

2668: end if;
2669: end;
2670: --
2671: if g_debug then
2672: hr_utility.set_location(l_proc, 460);
2673: end if;
2674: --
2675: -- Delete COBRA references and then any contact relationships. COBRA
2676: -- must be deleted first as PER_COBRA_COV_ENROLLMENTS has a

Line 2695: hr_utility.set_location(l_proc, 470);

2691: --
2692: exception
2693: when NO_DATA_FOUND then
2694: if g_debug then
2695: hr_utility.set_location(l_proc, 470);
2696: end if;
2697: end;
2698: --
2699: if g_debug then

Line 2700: hr_utility.set_location(l_proc, 480);

2696: end if;
2697: end;
2698: --
2699: if g_debug then
2700: hr_utility.set_location(l_proc, 480);
2701: end if;
2702: --
2703: begin
2704: --

Line 2722: hr_utility.set_location(l_proc, 490);

2718: --
2719: exception
2720: when NO_DATA_FOUND then
2721: if g_debug then
2722: hr_utility.set_location(l_proc, 490);
2723: end if;
2724: end;
2725: --
2726: if g_debug then

Line 2727: hr_utility.set_location(l_proc, 500);

2723: end if;
2724: end;
2725: --
2726: if g_debug then
2727: hr_utility.set_location(l_proc, 500);
2728: end if;
2729: --
2730: begin
2731: --

Line 2746: hr_utility.set_location(l_proc, 510);

2742: --
2743: exception
2744: when NO_DATA_FOUND then
2745: if g_debug then
2746: hr_utility.set_location(l_proc, 510);
2747: end if;
2748: end;
2749: --
2750: if g_debug then

Line 2751: hr_utility.set_location(l_proc, 520);

2747: end if;
2748: end;
2749: --
2750: if g_debug then
2751: hr_utility.set_location(l_proc, 520);
2752: end if;
2753: --
2754: begin
2755: --

Line 2773: hr_utility.set_location(l_proc, 530);

2769: --
2770: exception
2771: when NO_DATA_FOUND then
2772: if g_debug then
2773: hr_utility.set_location(l_proc, 530);
2774: end if;
2775: end;
2776: --
2777: if g_debug then

Line 2778: hr_utility.set_location(l_proc, 540);

2774: end if;
2775: end;
2776: --
2777: if g_debug then
2778: hr_utility.set_location(l_proc, 540);
2779: end if;
2780: --
2781: begin
2782: --

Line 2797: hr_utility.set_location(l_proc, 550);

2793: --
2794: exception
2795: when NO_DATA_FOUND then
2796: if g_debug then
2797: hr_utility.set_location(l_proc, 550);
2798: end if;
2799: end;
2800: --
2801: if g_debug then

Line 2802: hr_utility.set_location(l_proc, 560);

2798: end if;
2799: end;
2800: --
2801: if g_debug then
2802: hr_utility.set_location(l_proc, 560);
2803: end if;
2804: --
2805: begin
2806: --

Line 2824: hr_utility.set_location(l_proc, 570);

2820: --
2821: exception
2822: when NO_DATA_FOUND then
2823: if g_debug then
2824: hr_utility.set_location(l_proc, 570);
2825: end if;
2826: end;
2827: --
2828: if g_debug then

Line 2829: hr_utility.set_location(l_proc, 580);

2825: end if;
2826: end;
2827: --
2828: if g_debug then
2829: hr_utility.set_location(l_proc, 580);
2830: end if;
2831: --
2832: begin
2833: --

Line 2843: hr_utility.set_location(l_proc, 590);

2839: --
2840: exception
2841: when NO_DATA_FOUND then
2842: if g_debug then
2843: hr_utility.set_location(l_proc, 590);
2844: end if;
2845: end;
2846: --
2847: if g_debug then

Line 2848: hr_utility.set_location(l_proc, 600);

2844: end if;
2845: end;
2846: --
2847: if g_debug then
2848: hr_utility.set_location(l_proc, 600);
2849: end if;
2850: --
2851: begin
2852: --

Line 2869: hr_utility.set_location(l_proc, 610);

2865: --
2866: exception
2867: when NO_DATA_FOUND then
2868: if g_debug then
2869: hr_utility.set_location(l_proc, 610);
2870: end if;
2871: end;
2872: --
2873: --Bug# 3026024 Start Here

Line 2879: hr_utility.set_location(l_proc, 620);

2875: -- contact person whom is getting deleted.
2876: --
2877: --
2878: if g_debug then
2879: hr_utility.set_location(l_proc, 620);
2880: end if;
2881: --
2882: begin
2883: --

Line 2894: hr_utility.set_location(l_proc, 630);

2890: --
2891: exception
2892: when NO_DATA_FOUND then
2893: if g_debug then
2894: hr_utility.set_location(l_proc, 630);
2895: end if;
2896: end;
2897: --
2898: --Bug# 3026024 End Here

Line 2911: hr_utility.set_location(l_proc, 640);

2907: -- are created: a,b and b,a so that they can be queried in either
2908: -- direction. Hence must delete both here.
2909: --
2910: if g_debug then
2911: hr_utility.set_location(l_proc, 640);
2912: end if;
2913: --
2914: begin
2915: --

Line 2942: hr_utility.set_location(l_proc, 650);

2938: --
2939: exception
2940: when NO_DATA_FOUND then
2941: if g_debug then
2942: hr_utility.set_location(l_proc, 650);
2943: end if;
2944: end;
2945: --
2946: if g_debug then

Line 2947: hr_utility.set_location(l_proc, 660);

2943: end if;
2944: end;
2945: --
2946: if g_debug then
2947: hr_utility.set_location(l_proc, 660);
2948: end if;
2949: --
2950: begin
2951: --

Line 2958: hr_utility.set_location(l_proc, 670);

2954: --
2955: exception
2956: when NO_DATA_FOUND then
2957: if g_debug then
2958: hr_utility.set_location(l_proc, 670);
2959: end if;
2960: end;
2961: --
2962: if g_debug then

Line 2963: hr_utility.set_location(l_proc, 680);

2959: end if;
2960: end;
2961: --
2962: if g_debug then
2963: hr_utility.set_location(l_proc, 680);
2964: end if;
2965: --
2966: begin
2967: --

Line 2974: hr_utility.set_location(l_proc, 690);

2970: --
2971: exception
2972: when NO_DATA_FOUND then
2973: if g_debug then
2974: hr_utility.set_location(l_proc, 690);
2975: end if;
2976: end;
2977: --
2978: if g_debug then

Line 2979: hr_utility.set_location(l_proc, 700);

2975: end if;
2976: end;
2977: --
2978: if g_debug then
2979: hr_utility.set_location(l_proc, 700);
2980: end if;
2981: --
2982: begin
2983: --

Line 2991: hr_utility.set_location(l_proc, 710);

2987: --
2988: exception
2989: when NO_DATA_FOUND then
2990: if g_debug then
2991: hr_utility.set_location(l_proc, 710);
2992: end if;
2993: end;
2994: --
2995: if g_debug then

Line 2996: hr_utility.set_location(l_proc, 720);

2992: end if;
2993: end;
2994: --
2995: if g_debug then
2996: hr_utility.set_location(l_proc, 720);
2997: end if;
2998: --
2999: -- we must do this delete in dynamic sql because the per_performance_reviews
3000: -- table will not exist if the database has not been upgraded to new salary

Line 3025: hr_utility.set_location(l_proc, 730);

3021: end if;
3022: end;
3023: --
3024: if g_debug then
3025: hr_utility.set_location(l_proc, 730);
3026: end if;
3027: --
3028: -- About to delete interview events for assignments. However, must
3029: -- first delete bookings (interviewers) for those events.

Line 3055: hr_utility.set_location(l_proc, 740);

3051: );*/
3052: exception
3053: when NO_DATA_FOUND then
3054: if g_debug then
3055: hr_utility.set_location(l_proc, 740);
3056: end if;
3057: end;
3058: --
3059: if g_debug then

Line 3060: hr_utility.set_location(l_proc, 750);

3056: end if;
3057: end;
3058: --
3059: if g_debug then
3060: hr_utility.set_location(l_proc, 750);
3061: end if;
3062: --
3063: begin
3064: -- bug fix 3732129.

Line 3079: hr_utility.set_location(l_proc, 760);

3075: where ass.person_id = P_PERSON_ID);*/
3076: exception
3077: when NO_DATA_FOUND then
3078: if g_debug then
3079: hr_utility.set_location(l_proc, 760);
3080: end if;
3081: end;
3082: --
3083: if g_debug then

Line 3084: hr_utility.set_location(l_proc, 770);

3080: end if;
3081: end;
3082: --
3083: if g_debug then
3084: hr_utility.set_location(l_proc, 770);
3085: end if;
3086: --
3087: begin
3088: --

Line 3096: hr_utility.set_location(l_proc, 780);

3092: --
3093: exception
3094: when NO_DATA_FOUND then
3095: if g_debug then
3096: hr_utility.set_location(l_proc, 780);
3097: end if;
3098: end;
3099: --
3100: if g_debug then

Line 3101: hr_utility.set_location(l_proc, 790);

3097: end if;
3098: end;
3099: --
3100: if g_debug then
3101: hr_utility.set_location(l_proc, 790);
3102: end if;
3103: --
3104: begin
3105: --

Line 3112: hr_utility.set_location(l_proc, 800);

3108: --
3109: exception
3110: when NO_DATA_FOUND then
3111: if g_debug then
3112: hr_utility.set_location(l_proc, 800);
3113: end if;
3114: end;
3115: --
3116: if g_debug then

Line 3117: hr_utility.set_location(l_proc, 810);

3113: end if;
3114: end;
3115: --
3116: if g_debug then
3117: hr_utility.set_location(l_proc, 810);
3118: end if;
3119: --
3120: begin
3121: --

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

3127: --
3128: exception
3129: when NO_DATA_FOUND then
3130: if g_debug then
3131: hr_utility.set_location(l_proc, 820);
3132: end if;
3133: end;
3134: --
3135: if g_debug then

Line 3136: hr_utility.set_location(l_proc, 830);

3132: end if;
3133: end;
3134: --
3135: if g_debug then
3136: hr_utility.set_location(l_proc, 830);
3137: end if;
3138: --
3139: -- Validation has already been performed against
3140: -- hr_assignment_set_amendments in weak_predel_validation.

Line 3153: hr_utility.set_location(l_proc, 840);

3149: --
3150: exception
3151: when NO_DATA_FOUND then
3152: if g_debug then
3153: hr_utility.set_location(l_proc, 840);
3154: end if;
3155: end;
3156: --
3157: if g_debug then

Line 3158: hr_utility.set_location(l_proc, 850);

3154: end if;
3155: end;
3156: --
3157: if g_debug then
3158: hr_utility.set_location(l_proc, 850);
3159: end if;
3160: --
3161: begin
3162: --

Line 3172: hr_utility.set_location(l_proc, 860);

3168: --
3169: exception
3170: when NO_DATA_FOUND then
3171: if g_debug then
3172: hr_utility.set_location(l_proc, 860);
3173: end if;
3174: end;
3175: --
3176: if g_debug then

Line 3177: hr_utility.set_location(l_proc, 870);

3173: end if;
3174: end;
3175: --
3176: if g_debug then
3177: hr_utility.set_location(l_proc, 870);
3178: end if;
3179: --
3180: begin
3181: --

Line 3191: hr_utility.set_location(l_proc, 880);

3187: --
3188: exception
3189: when NO_DATA_FOUND then
3190: if g_debug then
3191: hr_utility.set_location(l_proc, 880);
3192: end if;
3193: end;
3194: --
3195: if g_debug then

Line 3196: hr_utility.set_location(l_proc, 890);

3192: end if;
3193: end;
3194: --
3195: if g_debug then
3196: hr_utility.set_location(l_proc, 890);
3197: end if;
3198: --
3199: -- Validation has already been performed against
3200: -- pay_assignment_actions in weak_predel_validation.

Line 3213: hr_utility.set_location(l_proc, 900);

3209: --
3210: exception
3211: when NO_DATA_FOUND then
3212: if g_debug then
3213: hr_utility.set_location(l_proc, 900);
3214: end if;
3215: end;
3216: --
3217: if g_debug then

Line 3218: hr_utility.set_location(l_proc, 910);

3214: end if;
3215: end;
3216: --
3217: if g_debug then
3218: hr_utility.set_location(l_proc, 910);
3219: end if;
3220: --
3221: begin
3222: --

Line 3232: hr_utility.set_location(l_proc, 920);

3228: --
3229: exception
3230: when NO_DATA_FOUND then
3231: if g_debug then
3232: hr_utility.set_location(l_proc, 920);
3233: end if;
3234: end;
3235: --
3236: if g_debug then

Line 3237: hr_utility.set_location(l_proc, 930);

3233: end if;
3234: end;
3235: --
3236: if g_debug then
3237: hr_utility.set_location(l_proc, 930);
3238: end if;
3239: --
3240: begin
3241: -- bug fix 3732129

Line 3257: hr_utility.set_location(l_proc, 940);

3253: where ass.person_id = P_PERSON_ID); */
3254: exception
3255: when NO_DATA_FOUND then
3256: if g_debug then
3257: hr_utility.set_location(l_proc, 940);
3258: end if;
3259: end;
3260: --
3261: if g_debug then

Line 3262: hr_utility.set_location(l_proc, 950);

3258: end if;
3259: end;
3260: --
3261: if g_debug then
3262: hr_utility.set_location(l_proc, 950);
3263: end if;
3264: --
3265: begin
3266: --

Line 3281: hr_utility.set_location(l_proc, 960);

3277: --
3278: exception
3279: when NO_DATA_FOUND then
3280: if g_debug then
3281: hr_utility.set_location(l_proc, 960);
3282: end if;
3283: end;
3284: --
3285: if g_debug then

Line 3286: hr_utility.set_location(l_proc, 970);

3282: end if;
3283: end;
3284: --
3285: if g_debug then
3286: hr_utility.set_location(l_proc, 970);
3287: end if;
3288: --
3289: begin
3290: --

Line 3306: hr_utility.set_location(l_proc, 980);

3302: --
3303: exception
3304: when NO_DATA_FOUND then
3305: if g_debug then
3306: hr_utility.set_location(l_proc, 980);
3307: end if;
3308: end;
3309: --
3310: if g_debug then

Line 3311: hr_utility.set_location(l_proc, 990);

3307: end if;
3308: end;
3309: --
3310: if g_debug then
3311: hr_utility.set_location(l_proc, 990);
3312: end if;
3313: --
3314: begin
3315: --

Line 3325: hr_utility.set_location(l_proc, 10);

3321: --
3322: exception
3323: when NO_DATA_FOUND then
3324: if g_debug then
3325: hr_utility.set_location(l_proc, 10);
3326: end if;
3327: end;
3328: --
3329: if g_debug then

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

3326: end if;
3327: end;
3328: --
3329: if g_debug then
3330: hr_utility.set_location(l_proc, 20);
3331: end if;
3332: --
3333: -- Rmonge Bug 1686922 22-FEB-2002
3334: -- Tax records were not being deleted. Therefore, there were orphans rows in

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

3345: --
3346: exception
3347: when no_data_found then
3348: if g_debug then
3349: hr_utility.set_location(l_proc, 30);
3350: end if;
3351: end;
3352: --
3353: begin

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

3352: --
3353: begin
3354: --
3355: if g_debug then
3356: hr_utility.set_location(l_proc, 40);
3357: end if;
3358: --
3359: Delete pay_us_emp_state_tax_rules_f pest
3360: Where pest.assignment_id in

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

3364: --
3365: exception
3366: when no_data_found then
3367: if g_debug then
3368: hr_utility.set_location(l_proc, 50);
3369: end if;
3370: end;
3371: --
3372: begin

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

3371: --
3372: begin
3373: --
3374: if g_debug then
3375: hr_utility.set_location(l_proc, 60);
3376: end if;
3377: --
3378: Delete pay_us_emp_county_tax_rules_f pect
3379: Where pect.assignment_id in

Line 3387: hr_utility.set_location(l_proc, 70);

3383: --
3384: exception
3385: when no_data_found then
3386: if g_debug then
3387: hr_utility.set_location(l_proc, 70);
3388: end if;
3389: end;
3390: --
3391: begin

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

3390: --
3391: begin
3392: --
3393: if g_debug then
3394: hr_utility.set_location(l_proc, 80);
3395: end if;
3396: --
3397: Delete pay_us_emp_city_tax_rules_f pecit
3398: Where pecit.assignment_id in

Line 3406: hr_utility.set_location(l_proc, 90);

3402: --
3403: exception
3404: when no_data_found then
3405: if g_debug then
3406: hr_utility.set_location(l_proc, 90);
3407: end if;
3408: end;
3409: -- Finished, now unlock assignments and delete them.
3410: --

Line 3414: hr_utility.set_location(l_proc, 100);

3410: --
3411: close csr_lock_assignment_rows;
3412: --
3413: if g_debug then
3414: hr_utility.set_location(l_proc, 100);
3415: end if;
3416: --
3417: begin
3418: --

Line 3425: hr_utility.set_location(l_proc, 110);

3421: --
3422: exception
3423: when NO_DATA_FOUND then
3424: if g_debug then
3425: hr_utility.set_location(l_proc, 110);
3426: end if;
3427: end;
3428: --
3429: if g_debug then

Line 3430: hr_utility.set_location(l_proc, 120);

3426: end if;
3427: end;
3428: --
3429: if g_debug then
3430: hr_utility.set_location(l_proc, 120);
3431: end if;
3432: --
3433: begin
3434: --

Line 3441: hr_utility.set_location(l_proc, 130);

3437: --
3438: exception
3439: when NO_DATA_FOUND then
3440: if g_debug then
3441: hr_utility.set_location(l_proc, 130);
3442: end if;
3443: end;
3444: --
3445: if g_debug then

Line 3446: hr_utility.set_location(l_proc, 140);

3442: end if;
3443: end;
3444: --
3445: if g_debug then
3446: hr_utility.set_location(l_proc, 140);
3447: end if;
3448: --
3449: begin
3450: --

Line 3457: hr_utility.set_location(l_proc, 150);

3453: --
3454: exception
3455: when NO_DATA_FOUND then
3456: if g_debug then
3457: hr_utility.set_location(l_proc, 150);
3458: end if;
3459: end;
3460: --
3461: -- 03/18/98 Bug #642566

Line 3464: hr_utility.set_location(l_proc, 160);

3460: --
3461: -- 03/18/98 Bug #642566
3462: -- delete per_people_extra_info records
3463: if g_debug then
3464: hr_utility.set_location(l_proc, 160);
3465: end if;
3466: --
3467: begin
3468: --

Line 3475: hr_utility.set_location(l_proc, 170);

3471: --
3472: exception
3473: when NO_DATA_FOUND then
3474: if g_debug then
3475: hr_utility.set_location(l_proc, 170);
3476: end if;
3477: end;
3478: -- 03/18/98 Change Ends
3479: --

Line 3485: hr_utility.set_location(l_proc, 180);

3481: --
3482: -- 28/5/98
3483: -- Add delete from per_person_type_usages_f
3484: if g_debug then
3485: hr_utility.set_location(l_proc, 180);
3486: end if;
3487: --
3488: for ptu_rec in csr_ptu loop
3489: --

Line 3503: hr_utility.set_location('l_person_type_usage_id = '||to_char(ptu_rec.person_type_usage_id),44);

3499: and ptu2.effective_start_date = l_effective_date;
3500: --
3501: if g_debug then
3502: --
3503: hr_utility.set_location('l_person_type_usage_id = '||to_char(ptu_rec.person_type_usage_id),44);
3504: hr_utility.set_location('l_effective_date = '||to_char(l_effective_date,'DD/MM/YYYY'),44);
3505: hr_utility.set_location('l_object_version_number = '||to_char(l_object_version_number),44);
3506: --
3507: end if;

Line 3504: hr_utility.set_location('l_effective_date = '||to_char(l_effective_date,'DD/MM/YYYY'),44);

3500: --
3501: if g_debug then
3502: --
3503: hr_utility.set_location('l_person_type_usage_id = '||to_char(ptu_rec.person_type_usage_id),44);
3504: hr_utility.set_location('l_effective_date = '||to_char(l_effective_date,'DD/MM/YYYY'),44);
3505: hr_utility.set_location('l_object_version_number = '||to_char(l_object_version_number),44);
3506: --
3507: end if;
3508: begin

Line 3505: hr_utility.set_location('l_object_version_number = '||to_char(l_object_version_number),44);

3501: if g_debug then
3502: --
3503: hr_utility.set_location('l_person_type_usage_id = '||to_char(ptu_rec.person_type_usage_id),44);
3504: hr_utility.set_location('l_effective_date = '||to_char(l_effective_date,'DD/MM/YYYY'),44);
3505: hr_utility.set_location('l_object_version_number = '||to_char(l_object_version_number),44);
3506: --
3507: end if;
3508: begin
3509: --

Line 3537: hr_utility.set_location(l_proc, 190);

3533: end loop;
3534: --
3535: -- delete per_person_dlvry_methods
3536: if g_debug then
3537: hr_utility.set_location(l_proc, 190);
3538: end if;
3539: --
3540: begin
3541: --

Line 3551: hr_utility.set_location(l_proc, 200);

3547: --
3548: -- Added this delete for quickhire checklists
3549: --
3550: if g_debug then
3551: hr_utility.set_location(l_proc, 200);
3552: end if;
3553: begin
3554: --
3555: delete from per_checklist_items

Line 3565: hr_utility.set_location(l_proc, 210);

3561: -- End addition for quickhire checklists
3562: --
3563: -- delete per_qualification and per_subjects_taken records
3564: if g_debug then
3565: hr_utility.set_location(l_proc, 210);
3566: end if;
3567: --
3568: begin
3569: -- Fix for 4490489 starts here

Line 3592: hr_utility.set_location(l_proc, 220);

3588: and s.qualification_id = q.qualification_id
3589: );
3590: --
3591: if g_debug then
3592: hr_utility.set_location(l_proc, 220);
3593: end if;
3594: --
3595: delete from per_subjects_taken s
3596: where s.qualification_id in

Line 3602: hr_utility.set_location(l_proc, 230);

3598: from per_qualifications
3599: where party_id = l_party_id );
3600: --
3601: if g_debug then
3602: hr_utility.set_location(l_proc, 230);
3603: end if;
3604: --PMFLETCH Added delete from tl table
3605: delete from per_qualifications_tl qt
3606: where qt.qualification_id in

Line 3612: hr_utility.set_location(l_proc, 240);

3608: from per_qualifications q
3609: where q.party_id = l_party_id);
3610: --
3611: if g_debug then
3612: hr_utility.set_location(l_proc, 240);
3613: end if;
3614: --
3615: delete from per_qualifications q
3616: where q.party_id = l_party_id;

Line 3623: hr_utility.set_location(l_proc, 250);

3619: --
3620: exception
3621: when NO_DATA_FOUND then
3622: if g_debug then
3623: hr_utility.set_location(l_proc, 250);
3624: end if;
3625: end;
3626: --
3627: -- Fix for 4490489 ends here

Line 3641: hr_utility.set_location(l_proc, 220);

3637: and s.qualification_id = q.qualification_id
3638: );
3639: --
3640: if g_debug then
3641: hr_utility.set_location(l_proc, 220);
3642: end if;
3643: --
3644: delete from per_subjects_taken s
3645: where s.qualification_id in

Line 3651: hr_utility.set_location(l_proc, 230);

3647: from per_qualifications
3648: where person_id = P_PERSON_ID );
3649: --
3650: if g_debug then
3651: hr_utility.set_location(l_proc, 230);
3652: end if;
3653: --PMFLETCH Added delete from tl table
3654: delete from per_qualifications_tl qt
3655: where qt.qualification_id in

Line 3661: hr_utility.set_location(l_proc, 240);

3657: from per_qualifications q
3658: where q.person_id = P_PERSON_ID);
3659: --
3660: if g_debug then
3661: hr_utility.set_location(l_proc, 240);
3662: end if;
3663: --
3664: delete from per_qualifications q
3665: where q.person_id = P_PERSON_ID;

Line 3670: hr_utility.set_location(l_proc, 250);

3666: --
3667: exception
3668: when NO_DATA_FOUND then
3669: if g_debug then
3670: hr_utility.set_location(l_proc, 250);
3671: end if;
3672: end; */
3673: --
3674: close csr_lock_person_rows;

Line 3677: hr_utility.set_location(l_proc, 260);

3673: --
3674: close csr_lock_person_rows;
3675: --
3676: if g_debug then
3677: hr_utility.set_location(l_proc, 260);
3678: end if;
3679:
3680: --changes for 5166353 starts here
3681: ben_person_delete.delete_ben_rows(P_PERSON_ID);

Line 3691: hr_utility.set_location(l_proc, 270);

3687: where person_id = P_PERSON_ID;
3688: exception
3689: when NO_DATA_FOUND then
3690: if g_debug then
3691: hr_utility.set_location(l_proc, 270);
3692: end if;
3693: end;
3694: --
3695: -- Now remove contracts

Line 3703: hr_utility.set_location(l_proc, 280);

3699: NULL,
3700: NULL);
3701: --
3702: if g_debug then
3703: hr_utility.set_location(l_proc, 280);
3704: end if;
3705: --
3706: -- Now remove Medical Assessments
3707: --

Line 3718: hr_utility.set_location(l_proc, 290);

3714: --
3715: END LOOP;
3716: --
3717: if g_debug then
3718: hr_utility.set_location(l_proc, 290);
3719: end if;
3720: --
3721: --
3722: -- Now remove disabilities

Line 3732: hr_utility.set_location(l_proc, 300);

3728: per_disability_api.delete_disability(false,p_effective_date ,'ZAP',l_disability_id, l_object_version_no, l_effective_start_date, l_effective_end_date);
3729: END LOOP;
3730: --
3731: if g_debug then
3732: hr_utility.set_location(l_proc, 300);
3733: end if;
3734: --
3735: --
3736: -- Now remove Work incidences

Line 3746: hr_utility.set_location(l_proc, 310);

3742: per_work_incident_api.delete_work_incident(false,l_incident_id, l_object_version_number);
3743: END LOOP;
3744: --
3745: if g_debug then
3746: hr_utility.set_location(l_proc, 310);
3747: end if;
3748: --
3749: --
3750: -- Now remove Supplementary Roles

Line 3760: hr_utility.set_location(l_proc, 320);

3756: per_supplementary_role_api.delete_supplementary_role(false, l_role_id, l_ovn_roles);
3757: END LOOP;
3758: --
3759: if g_debug then
3760: hr_utility.set_location(l_proc, 320);
3761: end if;
3762: --
3763: --
3764: begin

Line 3770: hr_utility.set_location(l_proc, 330);

3766: where p.person_id = P_PERSON_ID;
3767: exception
3768: when NO_DATA_FOUND then
3769: if g_debug then
3770: hr_utility.set_location(l_proc, 330);
3771: end if;
3772: end;
3773: --
3774: --

Line 3837: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 1111);

3833: WHERE person_id = P_PERSON_ID;
3834:
3835: EXCEPTION
3836: WHEN Others Then
3837: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 1111);
3838:
3839: END;
3840: BEGIN
3841: DELETE

Line 3861: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 1112);

3857: WHERE appraisee_person_id = P_PERSON_ID);
3858:
3859: EXCEPTION
3860: WHEN Others Then
3861: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 1112);
3862: END;
3863: -- fix 9885957
3864: begin
3865: --

Line 3874: hr_utility.set_location(l_proc, 250);

3870: --
3871: exception
3872: when NO_DATA_FOUND then
3873: if g_debug then
3874: hr_utility.set_location(l_proc, 250);
3875: end if;
3876: end;
3877: -- fix 9885957
3878: -- fix for the bug 8865114

Line 3882: hr_utility.set_location('Leaving:'||l_proc, 999);

3878: -- fix for the bug 8865114
3879: --
3880:
3881: if g_debug then
3882: hr_utility.set_location('Leaving:'||l_proc, 999);
3883: end if;
3884: --
3885: END delete_person;
3886: end hr_person_internal;