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

Line 138: hr_utility.set_location('per_db_per_additional.insert_period_of_service',1);

134: --
135: begin
136: --
137: --
138: hr_utility.set_location('per_db_per_additional.insert_period_of_service',1);
139: SELECT per_periods_of_service_s.nextval
140: INTO l_period_of_service_id
141: FROM sys.dual;
142: --

Line 143: hr_utility.set_location('per_db_per_additional.insert_period_of_service',2);

139: SELECT per_periods_of_service_s.nextval
140: INTO l_period_of_service_id
141: FROM sys.dual;
142: --
143: hr_utility.set_location('per_db_per_additional.insert_period_of_service',2);
144: --
145: -- Note : this check will only work for NEW employees - ie no
146: -- previous periods of service.
147: --

Line 156: hr_utility.set_location('per_db_per_additional.insert_period_of_service',5);

152: FROM per_people_f pp
153: WHERE pp.person_id = p_person_id
154: AND pp.current_employee_flag = 'Y');
155: --
156: hr_utility.set_location('per_db_per_additional.insert_period_of_service',5);
157: INSERT INTO per_periods_of_service
158: (period_of_service_id
159: ,business_group_id
160: ,person_id

Line 240: hr_utility.set_location('per_db_per_additional.insert_application',1);

236: --
237: begin
238: --
239: --
240: hr_utility.set_location('per_db_per_additional.insert_application',1);
241: SELECT per_applications_s.nextval
242: INTO l_application_id
243: FROM sys.dual;
244: --

Line 245: hr_utility.set_location('per_db_per_additional.insert_application',2);

241: SELECT per_applications_s.nextval
242: INTO l_application_id
243: FROM sys.dual;
244: --
245: hr_utility.set_location('per_db_per_additional.insert_application',2);
246: --
247: -- Note : this check will only work for NEW applicants - ie no
248: -- previous applications .
249: --

Line 258: hr_utility.set_location('per_db_per_additional.insert_application',5);

254: FROM per_people_f pp
255: WHERE pp.person_id = p_person_id
256: AND pp.current_applicant_flag = 'Y');
257: --
258: hr_utility.set_location('per_db_per_additional.insert_application',5);
259: INSERT INTO per_applications
260: (application_id
261: ,business_group_id
262: ,person_id

Line 334: hr_utility.set_location('per_db_per_additional.insert_person',1);

330: l_current_npw VARCHAR2(30) := NULL;
331: --
332: begin
333: --
334: hr_utility.set_location('per_db_per_additional.insert_person',1);
335: --
336: l_applicant_number := p_applicant_number;
337: l_employee_number := p_employee_number;
338: --

Line 343: hr_utility.set_location('per_db_per_additional.insert_person',2);

339: SELECT per_people_s.nextval
340: INTO l_person_id
341: FROM sys.dual;
342: --
343: hr_utility.set_location('per_db_per_additional.insert_person',2);
344: hr_person.validate_national_identifier(p_national_identifier,
345: l_person_id,
346: p_business_group_id);
347: --

Line 348: if hr_utility.check_warning then

344: hr_person.validate_national_identifier(p_national_identifier,
345: l_person_id,
346: p_business_group_id);
347: --
348: if hr_utility.check_warning then
349: hr_utility.raise_error;
350: end if;
351: --
352: hr_utility.set_location('per_db_per_additional.insert_person',3);

Line 349: hr_utility.raise_error;

345: l_person_id,
346: p_business_group_id);
347: --
348: if hr_utility.check_warning then
349: hr_utility.raise_error;
350: end if;
351: --
352: hr_utility.set_location('per_db_per_additional.insert_person',3);
353: hr_person.validate_dob(p_date_of_birth,

Line 352: hr_utility.set_location('per_db_per_additional.insert_person',3);

348: if hr_utility.check_warning then
349: hr_utility.raise_error;
350: end if;
351: --
352: hr_utility.set_location('per_db_per_additional.insert_person',3);
353: hr_person.validate_dob(p_date_of_birth,
354: p_effective_start_date);
355: --
356: --

Line 357: hr_utility.set_location('per_db_per_additional.insert_person',4);

353: hr_person.validate_dob(p_date_of_birth,
354: p_effective_start_date);
355: --
356: --
357: hr_utility.set_location('per_db_per_additional.insert_person',4);
358: --
359: -- this is replaced by new call below
360: --
361: --hr_person.derive_full_name(p_first_name,

Line 368: if hr_utility.check_warning then

364: -- l_person_id, p_business_group_id
365: -- ,l_full_name,l_dup_name);
366:
367: --
368: if hr_utility.check_warning then
369: hr_utility.raise_error;
370: end if;
371: --
372: hr_person.generate_number(p_current_employee_flag,

Line 369: hr_utility.raise_error;

365: -- ,l_full_name,l_dup_name);
366:
367: --
368: if hr_utility.check_warning then
369: hr_utility.raise_error;
370: end if;
371: --
372: hr_person.generate_number(p_current_employee_flag,
373: p_current_applicant_flag,

Line 383: hr_utility.set_location('per_db_per_additional.insert_person',5);

379: l_applicant_number,
380: l_npw_number);
381: --
382: --
383: hr_utility.set_location('per_db_per_additional.insert_person',5);
384: hr_person.validate_sex_and_title(p_current_employee_flag
385: ,p_sex
386: ,p_title);
387: if hr_utility.check_warning then

Line 387: if hr_utility.check_warning then

383: hr_utility.set_location('per_db_per_additional.insert_person',5);
384: hr_person.validate_sex_and_title(p_current_employee_flag
385: ,p_sex
386: ,p_title);
387: if hr_utility.check_warning then
388: hr_utility.raise_error;
389: end if;
390: --
391: hr_person.validate_unique_number(l_person_id

Line 388: hr_utility.raise_error;

384: hr_person.validate_sex_and_title(p_current_employee_flag
385: ,p_sex
386: ,p_title);
387: if hr_utility.check_warning then
388: hr_utility.raise_error;
389: end if;
390: --
391: hr_person.validate_unique_number(l_person_id
392: ,p_business_group_id

Line 401: hr_utility.set_location('per_db_per_additional.insert_person',6);

397: ,p_current_applicant_flag
398: ,l_current_npw --current_npw_flag
399: );
400: --
401: hr_utility.set_location('per_db_per_additional.insert_person',6);
402: --
403: hr_person_name.derive_person_names -- #3889584
404: (p_format_name => NULL, -- derive all names
405: p_business_group_id => p_business_group_id,

Line 427: hr_utility.set_location('per_db_per_additional.insert_person',7);

423: p_local_name => l_local_name,
424: p_duplicate_flag => l_dup_name
425: );
426: --
427: hr_utility.set_location('per_db_per_additional.insert_person',7);
428: --
429: INSERT INTO per_people_f
430: (person_id
431: ,effective_start_date

Line 555: hr_utility.set_location('per_db_per_additional.insert_assignment',1);

551: --
552: begin
553: --
554: --
555: hr_utility.set_location('per_db_per_additional.insert_assignment',1);
556: SELECT per_assignments_s.nextval
557: , pp.employee_number
558: INTO l_assignment_id
559: , l_employee_number

Line 565: hr_utility.set_location('per_db_per_additional.insert_assignment',20);

561: WHERE pp.person_id = p_person_id
562: AND p_effective_start_date BETWEEN pp.effective_start_date
563: AND pp.effective_end_date;
564: --
565: hr_utility.set_location('per_db_per_additional.insert_assignment',20);
566: if p_assignment_type = 'E' then -- Employee
567: SELECT period_of_service_id
568: INTO l_period_of_service_id
569: FROM per_periods_of_service

Line 587: hr_utility.set_location('per_db_per_additional.insert_assignment',2);

583: AND p_effective_end_date <=
584: nvl(date_end,to_date('4712/12/31','YYYY/MM/DD'));
585: end if;
586: --
587: hr_utility.set_location('per_db_per_additional.insert_assignment',2);
588: hr_assignment.gen_new_ass_sequence(p_person_id,
589: p_assignment_type,
590: l_assignment_sequence);
591: --

Line 594: hr_utility.set_location('per_db_per_additional.insert_assignment',3);

590: l_assignment_sequence);
591: --
592: --
593: if p_assignment_type = 'E' then -- Employee
594: hr_utility.set_location('per_db_per_additional.insert_assignment',3);
595: hr_assignment.gen_new_ass_number(l_assignment_id,
596: p_business_group_id,
597: l_employee_number,
598: l_assignment_sequence,

Line 603: hr_utility.set_location('per_db_per_additional.insert_assignment',4);

599: l_assignment_number);
600: --
601: end if;
602: --
603: hr_utility.set_location('per_db_per_additional.insert_assignment',4);
604: hr_assignment.check_hours(p_frequency,
605: fnd_number.canonical_to_number(p_normal_hours));
606: --
607: --

Line 608: hr_utility.set_location('per_db_per_additional.insert_assignment',5);

604: hr_assignment.check_hours(p_frequency,
605: fnd_number.canonical_to_number(p_normal_hours));
606: --
607: --
608: hr_utility.set_location('per_db_per_additional.insert_assignment',5);
609: INSERT INTO per_all_assignments_f
610: (assignment_id
611: ,effective_start_date
612: ,effective_end_date

Line 698: hr_utility.set_location('per_db_per_additional.insert_assignment',8);

694: --
695: -- Add effective start and end dates.
696: --SASmith 2-APR-98
697: --
698: hr_utility.set_location('per_db_per_additional.insert_assignment',8);
699: hr_assignment.load_budget_values(l_assignment_id
700: ,p_business_group_id
701: ,0
702: ,0

Line 706: hr_utility.set_location('per_db_per_additional.insert_assignment',10);

702: ,0
703: ,p_effective_start_date
704: ,p_effective_end_date);
705: --
706: hr_utility.set_location('per_db_per_additional.insert_assignment',10);
707: if p_assignment_type = 'E' then null;
708: else -- assignment type = 'A'
709: hr_utility.set_location('per_db_per_additional.insert_assignment',15);
710: begin

Line 709: hr_utility.set_location('per_db_per_additional.insert_assignment',15);

705: --
706: hr_utility.set_location('per_db_per_additional.insert_assignment',10);
707: if p_assignment_type = 'E' then null;
708: else -- assignment type = 'A'
709: hr_utility.set_location('per_db_per_additional.insert_assignment',15);
710: begin
711: SELECT letter_type_id
712: INTO l_letter_type_id
713: FROM per_letter_gen_statuses

Line 721: hr_utility.set_location('per_db_per_additional.insert_assignment',20);

717: --
718: exception when NO_DATA_FOUND then null;
719: end;
720: --
721: hr_utility.set_location('per_db_per_additional.insert_assignment',20);
722: if l_letter_type_id IS NOT NULL then
723: begin
724: hr_utility.set_location('per_db_per_additional.insert_assignment',25);
725: SELECT letter_request_id

Line 724: hr_utility.set_location('per_db_per_additional.insert_assignment',25);

720: --
721: hr_utility.set_location('per_db_per_additional.insert_assignment',20);
722: if l_letter_type_id IS NOT NULL then
723: begin
724: hr_utility.set_location('per_db_per_additional.insert_assignment',25);
725: SELECT letter_request_id
726: INTO l_letter_request_id
727: FROM per_letter_requests
728: WHERE letter_type_id = l_letter_type_id

Line 736: hr_utility.set_location('per_db_per_additional.insert_assignment',30);

732: --
733: exception when NO_DATA_FOUND then null;
734: end;
735: --
736: hr_utility.set_location('per_db_per_additional.insert_assignment',30);
737: if l_letter_request_id IS NOT NULL then null;
738: else
739: hr_utility.set_location('per_db_per_additional.insert_assignment',35);
740: SELECT per_letter_requests_s.nextval

Line 739: hr_utility.set_location('per_db_per_additional.insert_assignment',35);

735: --
736: hr_utility.set_location('per_db_per_additional.insert_assignment',30);
737: if l_letter_request_id IS NOT NULL then null;
738: else
739: hr_utility.set_location('per_db_per_additional.insert_assignment',35);
740: SELECT per_letter_requests_s.nextval
741: INTO l_letter_request_id
742: FROM sys.dual;
743: --

Line 744: hr_utility.set_location('per_db_per_additional.insert_assignment',40);

740: SELECT per_letter_requests_s.nextval
741: INTO l_letter_request_id
742: FROM sys.dual;
743: --
744: hr_utility.set_location('per_db_per_additional.insert_assignment',40);
745: INSERT INTO per_letter_requests
746: (letter_request_id
747: ,business_group_id
748: ,letter_type_id

Line 774: hr_utility.set_location('per_db_per_additional.insert_assignment',45);

770: ,p_vacancy_id);
771: --
772: end if;
773: --
774: hr_utility.set_location('per_db_per_additional.insert_assignment',45);
775: INSERT INTO per_letter_request_lines
776: (letter_request_line_id
777: ,business_group_id
778: ,letter_request_id

Line 886: hr_utility.set_location('per_db_per_additional.create_applicant',1);

882: --
883: begin -- FUNCTION create_applicant
884: --
885: --
886: hr_utility.set_location('per_db_per_additional.create_applicant',1);
887: --
888: SELECT business_group_id
889: , people_group_structure
890: INTO l_business_group_id

Line 895: hr_utility.set_location('per_db_per_additional.create_applicant',2);

891: , l_people_group_structure
892: FROM per_business_groups
893: WHERE name = p_business_group;
894: --
895: hr_utility.set_location('per_db_per_additional.create_applicant',2);
896: --
897: SELECT person_type_id
898: INTO l_person_type_id
899: FROM per_person_types

Line 904: hr_utility.set_location('per_db_per_additional.create_applicant',4);

900: WHERE business_group_id = l_business_group_id --Bug fix 3648477
901: AND system_person_type = 'APL'
902: AND default_flag = 'Y';
903: --
904: hr_utility.set_location('per_db_per_additional.create_applicant',4);
905: SELECT assignment_status_type_id
906: INTO l_assignment_status_type_id
907: FROM per_ass_status_type_amends
908: WHERE business_group_id + 0 = l_business_group_id

Line 925: hr_utility.set_location('per_db_per_additional.create_applicant',6);

921: AND ast1.default_flag = 'Y'
922: AND ast1.assignment_status_type_id =
923: ast.assignment_status_type_id) ;
924: --
925: hr_utility.set_location('per_db_per_additional.create_applicant',6);
926: l_current_employee_flag := null;
927: l_current_applicant_flag := 'Y';
928: l_current_emp_or_apl_flag := 'Y';
929: l_effective_start_date := nvl(p_effective_start_date, trunc(SYSDATE));

Line 935: hr_utility.set_location('per_db_per_additional.create_applicant',8);

931: to_date('4712/12/31','YYYY/MM/DD'));
932: l_date_of_birth := nvl(p_date_of_birth,
933: to_date('1958/01/01','YYYY/MM/DD'));
934: --
935: hr_utility.set_location('per_db_per_additional.create_applicant',8);
936: --
937: l_person_id := insert_person(l_effective_start_date
938: ,l_effective_end_date
939: ,l_business_group_id

Line 964: hr_utility.set_location('per_db_per_additional.create_applicant',10);

960: ,p_work_telephone );
961: --
962: --
963: --
964: hr_utility.set_location('per_db_per_additional.create_applicant',10);
965: l_application_id := insert_application(l_person_id
966: ,l_business_group_id
967: ,l_effective_start_date
968: ,null

Line 984: hr_utility.set_location('per_db_per_additional.create_applicant',12);

980:
981: -- End of PTU Changes
982:
983: --
984: hr_utility.set_location('per_db_per_additional.create_applicant',12);
985: --
986: -- WWBUG 1833930, changed hr_locations to hr_locations_all
987: --
988: if p_vacancy IS NULL then

Line 992: hr_utility.set_location('per_db_per_additional.create_applicant',14);

988: if p_vacancy IS NULL then
989: --
990: if p_location IS NULL then null;
991: else
992: hr_utility.set_location('per_db_per_additional.create_applicant',14);
993: SELECT location_id
994: INTO l_location_id
995: FROM hr_locations_all
996: WHERE location_code = p_location

Line 1002: hr_utility.set_location('per_db_per_additional.create_applicant',16);

998: 'YYYY/MM/DD'));
999: end if;
1000: --
1001: --
1002: hr_utility.set_location('per_db_per_additional.create_applicant',16);
1003: if p_position IS NULL then -- job and organization
1004: --
1005: if p_organization IS NULL then
1006: l_organization_id := l_business_group_id;

Line 1007: else hr_utility.set_location('per_db_per_additional.create_applicant',18);

1003: if p_position IS NULL then -- job and organization
1004: --
1005: if p_organization IS NULL then
1006: l_organization_id := l_business_group_id;
1007: else hr_utility.set_location('per_db_per_additional.create_applicant',18);
1008: SELECT organization_id
1009: , location_id
1010: INTO l_organization_id
1011: , l_location_id

Line 1020: hr_utility.set_location('per_db_per_additional.create_applicant',1);

1016: AND nvl(date_to,to_date('4712/12/31',
1017: 'YYYY/MM/DD'));
1018: end if;
1019: --
1020: hr_utility.set_location('per_db_per_additional.create_applicant',1);
1021: if p_job IS NULL then null;
1022: else hr_utility.set_location('per_db_per_additional.create_applicant',20);
1023: SELECT job_id
1024: INTO l_job_id

Line 1022: else hr_utility.set_location('per_db_per_additional.create_applicant',20);

1018: end if;
1019: --
1020: hr_utility.set_location('per_db_per_additional.create_applicant',1);
1021: if p_job IS NULL then null;
1022: else hr_utility.set_location('per_db_per_additional.create_applicant',20);
1023: SELECT job_id
1024: INTO l_job_id
1025: FROM per_jobs_v
1026: WHERE name = p_job

Line 1034: hr_utility.set_location('per_db_per_additional.create_applicant',22);

1030: 'YYYY/MM/DD'));
1031: end if;
1032: --
1033: else -- p_position is not null (position overrides job and org)
1034: hr_utility.set_location('per_db_per_additional.create_applicant',22);
1035: SELECT pos.position_id
1036: , pos.job_id
1037: , pos.organization_id
1038: , nvl(pos.location_id,nvl(org.location_id,l_location_id))

Line 1055: hr_utility.set_location('per_db_per_additional.create_applicant',24);

1051: end if;
1052: --
1053: if p_grade IS NULL then null;
1054: else
1055: hr_utility.set_location('per_db_per_additional.create_applicant',24);
1056: SELECT grade_id
1057: INTO l_grade_id
1058: FROM per_grades_vl
1059: WHERE name = p_grade

Line 1068: hr_utility.set_location('per_db_per_additional.create_applicant',26);

1064: end if;
1065: --
1066: else -- p_vacancy is not null (vacancy overrides all other columns)
1067: --
1068: hr_utility.set_location('per_db_per_additional.create_applicant',26);
1069: SELECT vacancy_id
1070: , position_id
1071: , job_id
1072: , organization_id

Line 1088: hr_utility.set_location('per_db_per_additional.create_applicant',28);

1084: WHERE name = p_vacancy
1085: AND l_effective_start_date BETWEEN date_from
1086: AND nvl(date_to,to_date('4712/12/31','YYYY/MM/DD'));
1087: --
1088: hr_utility.set_location('per_db_per_additional.create_applicant',28);
1089: if l_organization_id IS NULL then
1090: l_organization_id := l_business_group_id; -- mandatory column
1091: end if;
1092: --

Line 1093: hr_utility.set_location('per_db_per_additional.create_applicant',30);

1089: if l_organization_id IS NULL then
1090: l_organization_id := l_business_group_id; -- mandatory column
1091: end if;
1092: --
1093: hr_utility.set_location('per_db_per_additional.create_applicant',30);
1094: if p_recruitment_activity_id IS NULL then
1095: l_recruitment_activity_id := null;
1096: else
1097: hr_utility.set_location('per_db_per_additional.create_applicant',32);

Line 1097: hr_utility.set_location('per_db_per_additional.create_applicant',32);

1093: hr_utility.set_location('per_db_per_additional.create_applicant',30);
1094: if p_recruitment_activity_id IS NULL then
1095: l_recruitment_activity_id := null;
1096: else
1097: hr_utility.set_location('per_db_per_additional.create_applicant',32);
1098: SELECT recruitment_activity_id
1099: INTO l_recruitment_activity_id
1100: FROM per_recruitment_activity_for
1101: WHERE business_group_id + 0 = l_business_group_id

Line 1107: hr_utility.set_location('per_db_per_additional.create_applicant',34);

1103: end if;
1104: --
1105: end if;
1106: --
1107: hr_utility.set_location('per_db_per_additional.create_applicant',34);
1108: if p_people_group_id IS NULL then
1109: l_people_group_id := null;
1110: else
1111: SELECT people_group_id

Line 1118: hr_utility.set_location('per_db_per_additional.create_applicant',36);

1114: WHERE people_group_id = p_people_group_id
1115: AND id_flex_num = l_people_group_structure;
1116: end if;
1117: --
1118: hr_utility.set_location('per_db_per_additional.create_applicant',36);
1119: if p_source_organization_id IS NULL then null;
1120: else
1121: SELECT organization_id
1122: INTO l_source_organization_id

Line 1130: hr_utility.set_location('per_db_per_additional.create_applicant',38);

1126: AND l_effective_start_date BETWEEN date_from
1127: AND nvl(date_to,to_date('4712/12/31','YYYY/MM/DD'));
1128: end if;
1129: --
1130: hr_utility.set_location('per_db_per_additional.create_applicant',38);
1131: if p_recruiter_id IS NULL then null;
1132: else
1133: SELECT person_id
1134: INTO l_recruiter_id

Line 1144: hr_utility.set_location('per_db_per_additional.create_applicant',40);

1140: AND l_effective_start_date BETWEEN effective_start_date
1141: AND effective_end_date;
1142: end if;
1143: --
1144: hr_utility.set_location('per_db_per_additional.create_applicant',40);
1145: if p_person_referred_by_id IS NULL then null;
1146: else
1147: SELECT person_id
1148: INTO l_person_referred_by_id

Line 1158: hr_utility.set_location('per_db_per_additional.create_applicant',42);

1154: AND l_effective_start_date BETWEEN effective_start_date
1155: AND effective_end_date;
1156: end if;
1157: --
1158: hr_utility.set_location('per_db_per_additional.create_applicant',42);
1159: l_assignment_id := insert_assignment(l_effective_start_date
1160: , l_effective_end_date
1161: , l_business_group_id
1162: , l_person_id

Line 1192: hr_utility.set_location('per_db_per_additional.create_applicant',45);

1188: , l_source_organization_id
1189: , p_time_normal_finish
1190: , p_time_normal_start);
1191: --
1192: hr_utility.set_location('per_db_per_additional.create_applicant',45);
1193:
1194: --
1195: return l_person_id;
1196: --

Line 1281: hr_utility.set_location('per_db_per_additional.create_employee',1);

1277: --
1278: begin -- FUNCTION create_employee
1279: --
1280: --
1281: hr_utility.set_location('per_db_per_additional.create_employee',1);
1282: --
1283: SELECT business_group_id
1284: , people_group_structure
1285: , cost_allocation_structure

Line 1292: hr_utility.set_location('per_db_per_additional.create_employee',2);

1288: , l_cost_allocation_structure
1289: FROM per_business_groups
1290: WHERE name = p_business_group;
1291: --
1292: hr_utility.set_location('per_db_per_additional.create_employee',2);
1293: --
1294: SELECT person_type_id
1295: INTO l_person_type_id
1296: FROM per_person_types

Line 1301: hr_utility.set_location('per_db_per_additional.create_employee',4);

1297: WHERE business_group_id = l_business_group_id --Bug fix 3648477
1298: AND system_person_type = 'EMP'
1299: AND default_flag = 'Y';
1300: --
1301: hr_utility.set_location('per_db_per_additional.create_employee',4);
1302: SELECT assignment_status_type_id
1303: INTO l_assignment_status_type_id
1304: FROM per_ass_status_type_amends
1305: WHERE business_group_id + 0 = l_business_group_id

Line 1322: hr_utility.set_location('per_db_per_additional.create_employee',6);

1318: AND ast1.default_flag = 'Y'
1319: AND ast1.assignment_status_type_id =
1320: ast.assignment_status_type_id) ;
1321: --
1322: hr_utility.set_location('per_db_per_additional.create_employee',6);
1323: l_current_employee_flag := 'Y';
1324: l_current_applicant_flag := null;
1325: l_current_emp_or_apl_flag := 'Y';
1326: l_effective_start_date := nvl(p_effective_start_date, trunc(SYSDATE));

Line 1332: hr_utility.set_location('per_db_per_additional.create_employee',8);

1328: to_date('4712/12/31','YYYY/MM/DD'));
1329: l_date_of_birth := nvl(p_date_of_birth,
1330: to_date('1958/01/01','YYYY/MM/DD'));
1331: --
1332: hr_utility.set_location('per_db_per_additional.create_employee',8);
1333: --
1334: l_person_id := insert_person(l_effective_start_date
1335: ,l_effective_end_date
1336: ,l_business_group_id

Line 1370: hr_utility.set_location('per_db_per_additional.create_employee',10);

1366: );
1367:
1368: -- End of PTU Changes
1369: --
1370: hr_utility.set_location('per_db_per_additional.create_employee',10);
1371: l_period_of_service_id := insert_period_of_service(l_person_id
1372: ,l_business_group_id
1373: ,l_effective_start_date
1374: ,null

Line 1383: hr_utility.set_location('per_db_per_additional.create_employee',12);

1379: ,null
1380: ,null
1381: ,null);
1382: --
1383: hr_utility.set_location('per_db_per_additional.create_employee',12);
1384: -- Validate position before using
1385: --
1386: -- WWBUG 1833930, changed hr_locations to hr_locations_all
1387: --

Line 1390: hr_utility.set_location('per_db_per_additional.create_employee',14);

1386: -- WWBUG 1833930, changed hr_locations to hr_locations_all
1387: --
1388: if p_location IS NULL then null;
1389: else
1390: hr_utility.set_location('per_db_per_additional.create_employee',14);
1391: SELECT location_id
1392: INTO l_location_id
1393: FROM hr_locations_all
1394: WHERE location_code = p_location

Line 1399: hr_utility.set_location('per_db_per_additional.create_employee',16);

1395: AND l_effective_start_date <= nvl(inactive_date,to_date('4712/12/31',
1396: 'YYYY/MM/DD'));
1397: end if;
1398: --
1399: hr_utility.set_location('per_db_per_additional.create_employee',16);
1400: if p_position IS NULL then -- position overrides job and organization
1401: --
1402: if p_organization IS NULL then
1403: hr_utility.set_location('per_db_per_additional.create_employee',18);

Line 1403: hr_utility.set_location('per_db_per_additional.create_employee',18);

1399: hr_utility.set_location('per_db_per_additional.create_employee',16);
1400: if p_position IS NULL then -- position overrides job and organization
1401: --
1402: if p_organization IS NULL then
1403: hr_utility.set_location('per_db_per_additional.create_employee',18);
1404: l_organization_id := l_business_group_id;
1405: else hr_utility.set_location('per_db_per_additional.create_employee',20);
1406: SELECT organization_id
1407: , nvl(location_id, l_location_id)

Line 1405: else hr_utility.set_location('per_db_per_additional.create_employee',20);

1401: --
1402: if p_organization IS NULL then
1403: hr_utility.set_location('per_db_per_additional.create_employee',18);
1404: l_organization_id := l_business_group_id;
1405: else hr_utility.set_location('per_db_per_additional.create_employee',20);
1406: SELECT organization_id
1407: , nvl(location_id, l_location_id)
1408: INTO l_organization_id
1409: , l_location_id

Line 1418: hr_utility.set_location('per_db_per_additional.create_employee',22);

1414: AND nvl(date_to,to_date('4712/12/31',
1415: 'YYYY/MM/DD'));
1416: end if;
1417: --
1418: hr_utility.set_location('per_db_per_additional.create_employee',22);
1419: if p_job IS NULL then null;
1420: else hr_utility.set_location('per_db_per_additional.create_employee',24);
1421: SELECT job_id
1422: INTO l_job_id

Line 1420: else hr_utility.set_location('per_db_per_additional.create_employee',24);

1416: end if;
1417: --
1418: hr_utility.set_location('per_db_per_additional.create_employee',22);
1419: if p_job IS NULL then null;
1420: else hr_utility.set_location('per_db_per_additional.create_employee',24);
1421: SELECT job_id
1422: INTO l_job_id
1423: FROM per_jobs_v
1424: WHERE name = p_job

Line 1431: else hr_utility.set_location('per_db_per_additional.create_employee',26);

1427: AND nvl(date_to,to_date('4712/12/31',
1428: 'YYYY/MM/DD'));
1429: end if;
1430: --
1431: else hr_utility.set_location('per_db_per_additional.create_employee',26);
1432: SELECT pos.position_id
1433: , pos.job_id
1434: , pos.organization_id
1435: , nvl(pos.location_id,nvl(org.location_id,l_location_id))

Line 1450: hr_utility.set_location('per_db_per_additional.create_employee',28);

1446: AND nvl(pos.date_end,to_date('4712/12/31',
1447: 'YYYY/MM/DD'));
1448: end if;
1449: --
1450: hr_utility.set_location('per_db_per_additional.create_employee',28);
1451: if p_grade IS NULL then null;
1452: else
1453: hr_utility.set_location('per_db_per_additional.create_employee',30);
1454: SELECT grade_id

Line 1453: hr_utility.set_location('per_db_per_additional.create_employee',30);

1449: --
1450: hr_utility.set_location('per_db_per_additional.create_employee',28);
1451: if p_grade IS NULL then null;
1452: else
1453: hr_utility.set_location('per_db_per_additional.create_employee',30);
1454: SELECT grade_id
1455: INTO l_grade_id
1456: FROM per_grades_vl
1457: WHERE name = p_grade

Line 1464: hr_utility.set_location('per_db_per_additional.create_employee',32);

1460: AND nvl(date_to,to_date('4712/12/31',
1461: 'YYYY/MM/DD'));
1462: end if;
1463: --
1464: hr_utility.set_location('per_db_per_additional.create_employee',32);
1465: if p_payroll IS NULL then null;
1466: else
1467: hr_utility.set_location('per_db_per_additional.create_employee',34);
1468: SELECT pa.payroll_id

Line 1467: hr_utility.set_location('per_db_per_additional.create_employee',34);

1463: --
1464: hr_utility.set_location('per_db_per_additional.create_employee',32);
1465: if p_payroll IS NULL then null;
1466: else
1467: hr_utility.set_location('per_db_per_additional.create_employee',34);
1468: SELECT pa.payroll_id
1469: INTO l_payroll_id
1470: FROM pay_payrolls_f pa
1471: WHERE pa.payroll_name = p_payroll

Line 1482: hr_utility.set_location('per_db_per_additional.create_employee',36);

1478: l_business_group_id
1479: AND pa1.payroll_id = pa.payroll_id) ;
1480: end if;
1481: --
1482: hr_utility.set_location('per_db_per_additional.create_employee',36);
1483: if p_supervisor_id IS NULL then null;
1484: else
1485: SELECT person_id
1486: INTO l_supervisor_id

Line 1496: hr_utility.set_location('per_db_per_additional.create_employee',38);

1492: AND l_effective_start_date BETWEEN effective_start_date
1493: AND effective_end_date;
1494: end if;
1495: --
1496: hr_utility.set_location('per_db_per_additional.create_employee',38);
1497: if p_cost_allocation_keyflex_id IS NULL then
1498: l_cost_allocation_keyflex_id := null;
1499: else
1500: hr_utility.set_location('per_db_per_additional.create_employee',40);

Line 1500: hr_utility.set_location('per_db_per_additional.create_employee',40);

1496: hr_utility.set_location('per_db_per_additional.create_employee',38);
1497: if p_cost_allocation_keyflex_id IS NULL then
1498: l_cost_allocation_keyflex_id := null;
1499: else
1500: hr_utility.set_location('per_db_per_additional.create_employee',40);
1501: SELECT cost_allocation_keyflex_id
1502: INTO l_cost_allocation_keyflex_id
1503: FROM pay_cost_allocation_keyflex
1504: WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id

Line 1508: hr_utility.set_location('per_db_per_additional.create_employee',42);

1504: WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id
1505: AND id_flex_num = l_cost_allocation_structure;
1506: end if;
1507: --
1508: hr_utility.set_location('per_db_per_additional.create_employee',42);
1509: if p_people_group_id IS NULL then
1510: l_people_group_id := null;
1511: else
1512: hr_utility.set_location('per_db_per_additional.create_employee',44);

Line 1512: hr_utility.set_location('per_db_per_additional.create_employee',44);

1508: hr_utility.set_location('per_db_per_additional.create_employee',42);
1509: if p_people_group_id IS NULL then
1510: l_people_group_id := null;
1511: else
1512: hr_utility.set_location('per_db_per_additional.create_employee',44);
1513: SELECT people_group_id
1514: INTO l_people_group_id
1515: FROM pay_people_groups
1516: WHERE people_group_id = p_people_group_id

Line 1521: hr_utility.set_location('per_db_per_additional.create_employee',46);

1517: AND id_flex_num = l_people_group_structure;
1518: end if;
1519: --
1520: --
1521: hr_utility.set_location('per_db_per_additional.create_employee',46);
1522: l_assignment_id := insert_assignment(l_effective_start_date
1523: , l_effective_end_date
1524: , l_business_group_id
1525: , l_person_id

Line 1600: hr_utility.set_location('per_db_per_additional.create_other',1);

1596: --
1597: begin -- FUNCTION create_other
1598: --
1599: --
1600: hr_utility.set_location('per_db_per_additional.create_other',1);
1601: --
1602: SELECT business_group_id
1603: INTO l_business_group_id
1604: FROM per_business_groups

Line 1607: hr_utility.set_location('per_db_per_additional.create_other',2);

1603: INTO l_business_group_id
1604: FROM per_business_groups
1605: WHERE name = p_business_group;
1606: --
1607: hr_utility.set_location('per_db_per_additional.create_other',2);
1608: --
1609: SELECT person_type_id
1610: INTO l_person_type_id
1611: FROM per_person_types

Line 1624: hr_utility.set_location('per_db_per_additional.create_other',3);

1620: trunc(SYSDATE));
1621: l_effective_end_date := nvl(p_effective_end_date,
1622: to_date('4712/12/31','YYYY/MM/DD'));
1623: --
1624: hr_utility.set_location('per_db_per_additional.create_other',3);
1625: --
1626: l_person_id := insert_person(l_effective_start_date
1627: ,l_effective_end_date
1628: ,l_business_group_id

Line 1729: hr_utility.set_location('per_db_per_additional.create_secondary_assign',1);

1725: --
1726: begin
1727: --
1728: --
1729: hr_utility.set_location('per_db_per_additional.create_secondary_assign',1);
1730: SELECT business_group_id
1731: , cost_allocation_structure
1732: , people_group_structure
1733: INTO l_business_group_id

Line 1739: hr_utility.set_location('per_db_per_additional.create_secondary_assign',2);

1735: , l_people_group_structure
1736: FROM per_business_groups
1737: WHERE name = p_business_group;
1738: --
1739: hr_utility.set_location('per_db_per_additional.create_secondary_assign',2);
1740: l_effective_start_date := nvl(p_effective_start_date,trunc(SYSDATE));
1741: l_effective_end_date := nvl(p_effective_end_date,
1742: to_date('4712/12/31','YYYY/MM/DD'));
1743: --

Line 1744: hr_utility.set_location('per_db_per_additional.create_secondary_assign',3);

1740: l_effective_start_date := nvl(p_effective_start_date,trunc(SYSDATE));
1741: l_effective_end_date := nvl(p_effective_end_date,
1742: to_date('4712/12/31','YYYY/MM/DD'));
1743: --
1744: hr_utility.set_location('per_db_per_additional.create_secondary_assign',3);
1745: SELECT 'Y'
1746: INTO l_type_check
1747: FROM per_people_f pp
1748: WHERE pp.person_id = p_person_id

Line 1758: hr_utility.set_location('per_db_per_additional.create_secondary_assign',4);

1754: AND pp.current_applicant_flag = 'Y'));
1755: --
1756: --
1757: if p_assignment_type = 'E' then -- Employee
1758: hr_utility.set_location('per_db_per_additional.create_secondary_assign',4);
1759: SELECT assignment_status_type_id
1760: INTO l_assignment_status_type_id
1761: FROM per_ass_status_type_amends
1762: WHERE business_group_id + 0 = l_business_group_id

Line 1780: hr_utility.set_location('per_db_per_additional.create_secondary_assign',7);

1776: AND ast1.assignment_status_type_id =
1777: ast.assignment_status_type_id) ;
1778: --
1779: else -- Applicant
1780: hr_utility.set_location('per_db_per_additional.create_secondary_assign',7);
1781: SELECT assignment_status_type_id
1782: INTO l_assignment_status_type_id
1783: FROM per_ass_status_type_amends
1784: WHERE business_group_id + 0 = l_business_group_id

Line 1806: hr_utility.set_location('per_db_per_additional.create_secondary_assign',9);

1802: --
1803: --
1804: if p_assignment_type = 'E' then
1805: --
1806: hr_utility.set_location('per_db_per_additional.create_secondary_assign',9);
1807: -- Validate position before using
1808: --
1809: -- WWBUG 1833930, changed hr_locations to hr_locations_all
1810: --

Line 1813: hr_utility.set_location('per_db_per_additional.create_secondary_assign',11);

1809: -- WWBUG 1833930, changed hr_locations to hr_locations_all
1810: --
1811: if p_location IS NULL then null;
1812: else
1813: hr_utility.set_location('per_db_per_additional.create_secondary_assign',11);
1814: SELECT location_id
1815: INTO l_location_id
1816: FROM hr_locations_all
1817: WHERE location_code = p_location

Line 1825: hr_utility.set_location('per_db_per_additional.create_secondary_assign',13);

1821: --
1822: if p_position IS NULL then -- position overrides job and organization
1823: --
1824: if p_organization IS NULL then
1825: hr_utility.set_location('per_db_per_additional.create_secondary_assign',13);
1826: l_organization_id := l_business_group_id;
1827: else
1828: hr_utility.set_location('per_db_per_additional.create_secondary_assign',15);
1829: SELECT organization_id

Line 1828: hr_utility.set_location('per_db_per_additional.create_secondary_assign',15);

1824: if p_organization IS NULL then
1825: hr_utility.set_location('per_db_per_additional.create_secondary_assign',13);
1826: l_organization_id := l_business_group_id;
1827: else
1828: hr_utility.set_location('per_db_per_additional.create_secondary_assign',15);
1829: SELECT organization_id
1830: , nvl(location_id, l_location_id)
1831: INTO l_organization_id
1832: , l_location_id

Line 1841: hr_utility.set_location('per_db_per_additional.create_secondary_assign',17);

1837: AND nvl(date_to,to_date('4712/12/31',
1838: 'YYYY/MM/DD'));
1839: end if;
1840: --
1841: hr_utility.set_location('per_db_per_additional.create_secondary_assign',17);
1842: if p_job IS NULL then null;
1843: else
1844: hr_utility.set_location('per_db_per_additional.create_secondary_assign',19);
1845: SELECT job_id

Line 1844: hr_utility.set_location('per_db_per_additional.create_secondary_assign',19);

1840: --
1841: hr_utility.set_location('per_db_per_additional.create_secondary_assign',17);
1842: if p_job IS NULL then null;
1843: else
1844: hr_utility.set_location('per_db_per_additional.create_secondary_assign',19);
1845: SELECT job_id
1846: INTO l_job_id
1847: FROM per_jobs_v
1848: WHERE name = p_job

Line 1856: hr_utility.set_location('per_db_per_additional.create_secondary_assign',21);

1852: 'YYYY/MM/DD'));
1853: end if;
1854: --
1855: else
1856: hr_utility.set_location('per_db_per_additional.create_secondary_assign',21);
1857: SELECT pos.position_id
1858: , pos.job_id
1859: , pos.organization_id
1860: , nvl(pos.location_id,nvl(org.location_id,l_location_id))

Line 1875: hr_utility.set_location('per_db_per_additional.create_secondary_assign',23);

1871: AND nvl(pos.date_end,to_date('4712/12/31',
1872: 'YYYY/MM/DD'));
1873: end if;
1874: --
1875: hr_utility.set_location('per_db_per_additional.create_secondary_assign',23);
1876: if p_grade IS NULL then null;
1877: else
1878: hr_utility.set_location('per_db_per_additional.create_secondary_assign',25);
1879: SELECT grade_id

Line 1878: hr_utility.set_location('per_db_per_additional.create_secondary_assign',25);

1874: --
1875: hr_utility.set_location('per_db_per_additional.create_secondary_assign',23);
1876: if p_grade IS NULL then null;
1877: else
1878: hr_utility.set_location('per_db_per_additional.create_secondary_assign',25);
1879: SELECT grade_id
1880: INTO l_grade_id
1881: FROM per_grades_vl
1882: WHERE name = p_grade

Line 1889: hr_utility.set_location('per_db_per_additional.create_secondary_assign',27);

1885: AND nvl(date_to,to_date('4712/12/31',
1886: 'YYYY/MM/DD'));
1887: end if;
1888: --
1889: hr_utility.set_location('per_db_per_additional.create_secondary_assign',27);
1890: if p_payroll IS NULL then null;
1891: else
1892: hr_utility.set_location('per_db_per_additional.create_secondary_assign',29);
1893: SELECT pa.payroll_id

Line 1892: hr_utility.set_location('per_db_per_additional.create_secondary_assign',29);

1888: --
1889: hr_utility.set_location('per_db_per_additional.create_secondary_assign',27);
1890: if p_payroll IS NULL then null;
1891: else
1892: hr_utility.set_location('per_db_per_additional.create_secondary_assign',29);
1893: SELECT pa.payroll_id
1894: INTO l_payroll_id
1895: FROM pay_payrolls_f pa
1896: WHERE pa.payroll_name = p_payroll

Line 1907: hr_utility.set_location('per_db_per_additional.create_secondary_assign',31);

1903: l_business_group_id
1904: AND pa1.payroll_id = pa.payroll_id) ;
1905: end if;
1906: --
1907: hr_utility.set_location('per_db_per_additional.create_secondary_assign',31);
1908: if p_supervisor_id IS NULL then null;
1909: else
1910: SELECT person_id
1911: INTO l_supervisor_id

Line 1921: hr_utility.set_location('per_db_per_additional.create_secondary_assign',33);

1917: AND effective_end_date;
1918: end if;
1919: --
1920: --
1921: hr_utility.set_location('per_db_per_additional.create_secondary_assign',33);
1922: if p_cost_allocation_keyflex_id IS NULL then
1923: l_cost_allocation_keyflex_id := null;
1924: else
1925: hr_utility.set_location('per_db_per_additional.create_secondary_assign',35);

Line 1925: hr_utility.set_location('per_db_per_additional.create_secondary_assign',35);

1921: hr_utility.set_location('per_db_per_additional.create_secondary_assign',33);
1922: if p_cost_allocation_keyflex_id IS NULL then
1923: l_cost_allocation_keyflex_id := null;
1924: else
1925: hr_utility.set_location('per_db_per_additional.create_secondary_assign',35);
1926: SELECT cost_allocation_keyflex_id
1927: INTO l_cost_allocation_keyflex_id
1928: FROM pay_cost_allocation_keyflex
1929: WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id

Line 1933: hr_utility.set_location('per_db_per_additional.create_secondary_assign',37);

1929: WHERE cost_allocation_keyflex_id = p_cost_allocation_keyflex_id
1930: AND id_flex_num = l_cost_allocation_structure;
1931: end if;
1932: --
1933: hr_utility.set_location('per_db_per_additional.create_secondary_assign',37);
1934: if p_people_group_id IS NULL then
1935: l_people_group_id := null;
1936: else
1937: hr_utility.set_location('per_db_per_additional.create_secondary_assign',39);

Line 1937: hr_utility.set_location('per_db_per_additional.create_secondary_assign',39);

1933: hr_utility.set_location('per_db_per_additional.create_secondary_assign',37);
1934: if p_people_group_id IS NULL then
1935: l_people_group_id := null;
1936: else
1937: hr_utility.set_location('per_db_per_additional.create_secondary_assign',39);
1938: SELECT people_group_id
1939: INTO l_people_group_id
1940: FROM pay_people_groups
1941: WHERE people_group_id = p_people_group_id

Line 1946: hr_utility.set_location('per_db_per_additional.create_secondary_assign',41);

1942: AND id_flex_num = l_people_group_structure;
1943: end if;
1944: --
1945: else -- if p_assignment_type = 'A'
1946: hr_utility.set_location('per_db_per_additional.create_secondary_assign',41);
1947: --
1948: -- WWBUG 1833930, changed hr_locations to hr_locations_all
1949: --
1950: if p_vacancy IS NULL then

Line 1954: hr_utility.set_location('per_db_per_additional.create_secondary_assign',43);

1950: if p_vacancy IS NULL then
1951: --
1952: if p_location IS NULL then null;
1953: else
1954: hr_utility.set_location('per_db_per_additional.create_secondary_assign',43);
1955: SELECT location_id
1956: INTO l_location_id
1957: FROM hr_locations_all
1958: WHERE location_code = p_location

Line 1964: hr_utility.set_location('per_db_per_additional.create_secondary_assign',44);

1960: 'YYYY/MM/DD'));
1961: end if;
1962: --
1963: --
1964: hr_utility.set_location('per_db_per_additional.create_secondary_assign',44);
1965: if p_position IS NULL then -- job and organization
1966: --
1967: if p_organization IS NULL then
1968: l_organization_id := l_business_group_id;

Line 1970: hr_utility.set_location('per_db_per_additional.create_secondary_assign',46);

1966: --
1967: if p_organization IS NULL then
1968: l_organization_id := l_business_group_id;
1969: else
1970: hr_utility.set_location('per_db_per_additional.create_secondary_assign',46);
1971: SELECT organization_id
1972: , location_id
1973: INTO l_organization_id
1974: , l_location_id

Line 1985: hr_utility.set_location('per_db_per_additional.create_secondary_assign',48);

1981: end if;
1982: --
1983: if p_job IS NULL then null;
1984: else
1985: hr_utility.set_location('per_db_per_additional.create_secondary_assign',48);
1986: SELECT job_id
1987: INTO l_job_id
1988: FROM per_jobs_v
1989: WHERE name = p_job

Line 1997: hr_utility.set_location('per_db_per_additional.create_secondary_assign',50);

1993: 'YYYY/MM/DD'));
1994: end if;
1995: --
1996: else -- p_position is not null (position overrides job and org)
1997: hr_utility.set_location('per_db_per_additional.create_secondary_assign',50);
1998: SELECT pos.position_id
1999: , pos.job_id
2000: , pos.organization_id
2001: , nvl(pos.location_id,nvl(org.location_id,l_location_id))

Line 2018: hr_utility.set_location('per_db_per_additional.create_secondary_assign',52);

2014: end if;
2015: --
2016: if p_grade IS NULL then null;
2017: else
2018: hr_utility.set_location('per_db_per_additional.create_secondary_assign',52);
2019: SELECT grade_id
2020: INTO l_grade_id
2021: FROM per_grades_vl
2022: WHERE name = p_grade

Line 2031: hr_utility.set_location('per_db_per_additional.create_secondary_assign',54);

2027: end if;
2028: --
2029: else -- p_vacancy is not null (vacancy overrides all other columns)
2030: --
2031: hr_utility.set_location('per_db_per_additional.create_secondary_assign',54);
2032: SELECT vacancy_id
2033: , position_id
2034: , job_id
2035: , organization_id

Line 2051: hr_utility.set_location('per_db_per_additional.create_secondary_assign',56);

2047: WHERE name = p_vacancy
2048: AND l_effective_start_date BETWEEN date_from
2049: AND nvl(date_to,to_date('4712/12/31','YYYY/MM/DD'));
2050: --
2051: hr_utility.set_location('per_db_per_additional.create_secondary_assign',56);
2052: if l_organization_id IS NULL then
2053: l_organization_id := l_business_group_id; -- mandatory column
2054: end if;
2055: --

Line 2056: hr_utility.set_location('per_db_per_additional.create_secondary_assign',58);

2052: if l_organization_id IS NULL then
2053: l_organization_id := l_business_group_id; -- mandatory column
2054: end if;
2055: --
2056: hr_utility.set_location('per_db_per_additional.create_secondary_assign',58);
2057: if p_recruitment_activity_id IS NULL then
2058: l_recruitment_activity_id := null;
2059: else
2060: hr_utility.set_location('per_db_per_additional.create_secondary_assign',60);

Line 2060: hr_utility.set_location('per_db_per_additional.create_secondary_assign',60);

2056: hr_utility.set_location('per_db_per_additional.create_secondary_assign',58);
2057: if p_recruitment_activity_id IS NULL then
2058: l_recruitment_activity_id := null;
2059: else
2060: hr_utility.set_location('per_db_per_additional.create_secondary_assign',60);
2061: SELECT recruitment_activity_id
2062: INTO l_recruitment_activity_id
2063: FROM per_recruitment_activity_for
2064: WHERE business_group_id + 0 = l_business_group_id

Line 2070: hr_utility.set_location('per_db_per_additional.create_secondary_assign',62);

2066: end if;
2067: --
2068: end if; -- vacancy not null within applicant
2069: --
2070: hr_utility.set_location('per_db_per_additional.create_secondary_assign',62);
2071: if p_source_organization_id IS NULL then null;
2072: else
2073: SELECT organization_id
2074: INTO l_organization_id

Line 2082: hr_utility.set_location('per_db_per_additional.create_secondary_assign',64);

2078: AND l_effective_start_date BETWEEN date_from
2079: AND nvl(date_to,to_date('4712/12/31','YYYY/MM/DD'));
2080: end if;
2081: --
2082: hr_utility.set_location('per_db_per_additional.create_secondary_assign',64);
2083: if p_recruiter_id IS NULL then null;
2084: else
2085: SELECT person_id
2086: INTO l_recruiter_id

Line 2096: hr_utility.set_location('per_db_per_additional.create_secondary_assign',66);

2092: AND l_effective_start_date BETWEEN effective_start_date
2093: AND effective_end_date;
2094: end if;
2095: --
2096: hr_utility.set_location('per_db_per_additional.create_secondary_assign',66);
2097: if p_person_referred_by_id IS NULL then null;
2098: else
2099: SELECT person_id
2100: INTO l_person_referred_by_id

Line 2112: hr_utility.set_location('per_db_per_additional.create_secondary_assign',68);

2108: end if;
2109: --
2110: end if; -- split by assignment type
2111: --
2112: hr_utility.set_location('per_db_per_additional.create_secondary_assign',68);
2113: if p_people_group_id IS NULL then
2114: l_people_group_id := null;
2115: else
2116: hr_utility.set_location('per_db_per_additional.create_secondary_assign',70);

Line 2116: hr_utility.set_location('per_db_per_additional.create_secondary_assign',70);

2112: hr_utility.set_location('per_db_per_additional.create_secondary_assign',68);
2113: if p_people_group_id IS NULL then
2114: l_people_group_id := null;
2115: else
2116: hr_utility.set_location('per_db_per_additional.create_secondary_assign',70);
2117: SELECT people_group_id
2118: INTO l_people_group_id
2119: FROM pay_people_groups
2120: WHERE people_group_id = p_people_group_id

Line 2124: hr_utility.set_location('per_db_per_additional.create_secondary_assign',72);

2120: WHERE people_group_id = p_people_group_id
2121: AND id_flex_num = l_people_group_structure;
2122: end if;
2123: --
2124: hr_utility.set_location('per_db_per_additional.create_secondary_assign',72);
2125: l_assignment_id := insert_assignment(l_effective_start_date
2126: ,l_effective_end_date
2127: ,l_business_group_id
2128: ,p_person_id

Line 2210: hr_utility.set_location('per_db_per_additional.create_contact',1);

2206: --
2207: begin -- function create_contact
2208: --
2209: --
2210: hr_utility.set_location('per_db_per_additional.create_contact',1);
2211: SELECT business_group_id
2212: INTO l_business_group_id
2213: FROM per_business_groups
2214: WHERE name = p_business_group;

Line 2220: hr_utility.set_location('per_db_per_additional.create_contact',2);

2216: l_effective_start_date := nvl(p_effective_start_date,trunc(SYSDATE));
2217: l_effective_end_date := nvl(p_effective_end_date,
2218: to_date('4712/12/31','YYYY/MM/DD'));
2219: --
2220: hr_utility.set_location('per_db_per_additional.create_contact',2);
2221: SELECT pp.person_id
2222: INTO l_person_id
2223: FROM per_periods_of_service pos
2224: , per_people_f pp

Line 2238: hr_utility.set_location('per_db_per_additional.create_contact',3);

2234: nvl(pos.actual_termination_date,to_date('4712/12/31','YYYY/MM/DD'));
2235: --
2236: --
2237: if p_contact_person_id IS NULL then
2238: hr_utility.set_location('per_db_per_additional.create_contact',3);
2239: l_contact_person_id := per_db_per_additional.create_other
2240: (p_effective_start_date
2241: ,p_effective_end_date
2242: ,p_business_group

Line 2258: hr_utility.set_location('per_db_per_additional.create_contact',4);

2254: ,p_sex
2255: ,p_title
2256: ,p_work_telephone);
2257: else
2258: hr_utility.set_location('per_db_per_additional.create_contact',4);
2259: SELECT DISTINCT person_id
2260: INTO l_contact_person_id
2261: FROM per_people_f
2262: WHERE business_group_id + 0 = l_business_group_id

Line 2267: hr_utility.set_location('per_db_per_additional.create_contact',5);

2263: AND person_id = p_contact_person_id;
2264: end if;
2265: --
2266: if p_relationship IS NULL then
2267: hr_utility.set_location('per_db_per_additional.create_contact',5);
2268: l_contact_type := 'O';
2269: else
2270: hr_utility.set_location('per_db_per_additional.create_contact',6);
2271: SELECT lookup_code

Line 2270: hr_utility.set_location('per_db_per_additional.create_contact',6);

2266: if p_relationship IS NULL then
2267: hr_utility.set_location('per_db_per_additional.create_contact',5);
2268: l_contact_type := 'O';
2269: else
2270: hr_utility.set_location('per_db_per_additional.create_contact',6);
2271: SELECT lookup_code
2272: INTO l_contact_type
2273: FROM hr_lookups
2274: WHERE lookup_type = 'CONTACT'

Line 2278: hr_utility.set_location('per_db_per_additional.create_contact',7);

2274: WHERE lookup_type = 'CONTACT'
2275: AND meaning = p_relationship;
2276: end if;
2277: --
2278: hr_utility.set_location('per_db_per_additional.create_contact',7);
2279: SELECT per_contact_relationships_s.nextval
2280: INTO l_contact_relationship_id
2281: FROM sys.dual;
2282: --

Line 2284: hr_utility.set_location('per_db_per_additional.create_contact',8);

2280: INTO l_contact_relationship_id
2281: FROM sys.dual;
2282: --
2283: --
2284: hr_utility.set_location('per_db_per_additional.create_contact',8);
2285: INSERT INTO per_contact_relationships
2286: (contact_relationship_id
2287: ,business_group_id
2288: ,person_id