[Home] [Help]
442: l_error_msg Varchar2(2000);
443: l_proc_name Constant Varchar2(150) :='Student_FICA_Status';
444:
445: BEGIN
446: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
447:
448: OPEN csr_tax (c_effective_date => p_effective_date
449: ,c_assignment_id => p_assignment_id);
450: FETCH csr_tax INTO l_fed_rec;
447:
448: OPEN csr_tax (c_effective_date => p_effective_date
449: ,c_assignment_id => p_assignment_id);
450: FETCH csr_tax INTO l_fed_rec;
451: Hr_Utility.set_location(' EMP_FED_TAX_RULE_ID: '||l_fed_rec.emp_fed_tax_rule_id, 10);
452: IF csr_tax%NOTFOUND THEN
453: CLOSE csr_tax;
454: RETURN;
455: END IF;
476: ELSE
477: l_Datetrack_mode := 'CORRECTION';
478: END IF;
479:
480: Hr_Utility.set_location(' l_datetrack_mode: '||l_datetrack_mode, 15);
481: IF l_fed_rec.emp_fed_tax_rule_id IS NOT NULL THEN
482: IF NVL(p_FICA_Status,'N') = 'N' THEN
483: l_fed_rec.medicare_tax_exempt := 'N';
484: l_fed_rec.ss_tax_exempt := 'N';
498: ,p_effective_start_date => l_start_effective_date
499: ,p_effective_end_date => l_end_effective_date
500: );
501: END IF;
502: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
503:
504: EXCEPTION
505: WHEN OTHERS THEN
506: IF csr_tax%ISOPEN THEN
506: IF csr_tax%ISOPEN THEN
507: CLOSE csr_tax;
508: END IF;
509: l_error_msg := sqlerrm;
510: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
511: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
512: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
513: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
514: Hr_Utility.raise_error;
507: CLOSE csr_tax;
508: END IF;
509: l_error_msg := sqlerrm;
510: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
511: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
512: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
513: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
514: Hr_Utility.raise_error;
515:
508: END IF;
509: l_error_msg := sqlerrm;
510: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
511: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
512: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
513: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
514: Hr_Utility.raise_error;
515:
516: END Student_FICA_Status;
509: l_error_msg := sqlerrm;
510: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
511: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
512: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
513: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
514: Hr_Utility.raise_error;
515:
516: END Student_FICA_Status;
517: -- =============================================================================
510: Hr_Utility.set_location('SQLCODE :'||SQLCODE,90);
511: Hr_Utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
512: Hr_Utility.set_message_token('GENERIC_TOKEN',l_error_msg );
513: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
514: Hr_Utility.raise_error;
515:
516: END Student_FICA_Status;
517: -- =============================================================================
518: -- ~ FICA_Status: Function to return the FICA status of an employee assignment.
540: l_return_status Varchar2(5);
541: l_proc_name CONSTANT Varchar2(150) := g_pkg||'FICA_Status';
542:
543: BEGIN
544: Hr_utility.set_location('Entering:' || l_proc_name, 10);
545: Hr_utility.set_location('p_assignment_id = ' || p_assignment_id, 20);
546:
547: l_return_status := 'N';
548: OPEN csr_tax(c_effective_date => p_effective_date
541: l_proc_name CONSTANT Varchar2(150) := g_pkg||'FICA_Status';
542:
543: BEGIN
544: Hr_utility.set_location('Entering:' || l_proc_name, 10);
545: Hr_utility.set_location('p_assignment_id = ' || p_assignment_id, 20);
546:
547: l_return_status := 'N';
548: OPEN csr_tax(c_effective_date => p_effective_date
549: ,c_assignment_id => p_assignment_id);
550: FETCH csr_tax INTO l_fed_rec;
551: IF csr_tax%NOTFOUND THEN
552: CLOSE csr_tax;
553: ELSE
554: Hr_utility.set_location('Tax record found', 30);
555: Hr_utility.set_location('SS :'||l_fed_rec.ss_tax_exempt, 30);
556: Hr_utility.set_location('Medicare: '||l_fed_rec.medicare_tax_exempt, 30);
557: IF NVL(l_fed_rec.medicare_tax_exempt,'N') = 'Y' AND
558: NVL(l_fed_rec.ss_tax_exempt,'N') = 'Y' THEN
551: IF csr_tax%NOTFOUND THEN
552: CLOSE csr_tax;
553: ELSE
554: Hr_utility.set_location('Tax record found', 30);
555: Hr_utility.set_location('SS :'||l_fed_rec.ss_tax_exempt, 30);
556: Hr_utility.set_location('Medicare: '||l_fed_rec.medicare_tax_exempt, 30);
557: IF NVL(l_fed_rec.medicare_tax_exempt,'N') = 'Y' AND
558: NVL(l_fed_rec.ss_tax_exempt,'N') = 'Y' THEN
559: l_return_status := 'Y';
552: CLOSE csr_tax;
553: ELSE
554: Hr_utility.set_location('Tax record found', 30);
555: Hr_utility.set_location('SS :'||l_fed_rec.ss_tax_exempt, 30);
556: Hr_utility.set_location('Medicare: '||l_fed_rec.medicare_tax_exempt, 30);
557: IF NVL(l_fed_rec.medicare_tax_exempt,'N') = 'Y' AND
558: NVL(l_fed_rec.ss_tax_exempt,'N') = 'Y' THEN
559: l_return_status := 'Y';
560: END IF;
558: NVL(l_fed_rec.ss_tax_exempt,'N') = 'Y' THEN
559: l_return_status := 'Y';
560: END IF;
561: END IF;
562: Hr_Utility.set_location('Leaving:' || l_proc_name, 50);
563: RETURN l_return_status;
564:
565: EXCEPTION
566: WHEN OTHERS THEN
566: WHEN OTHERS THEN
567: IF csr_tax%ISOPEN THEN
568: CLOSE csr_tax;
569: END IF;
570: Hr_Utility.set_location('Leaving:' || l_proc_name, 90);
571: RETURN l_return_status;
572:
573: END FICA_Status;
574: -- =============================================================================
619: e_empasg_notfound EXCEPTION;
620: l_UpdEmpAsg_out t_Upd_Emp_Asg_Api;
621:
622: BEGIN
623: hr_utility.set_location('Entering: ' || l_proc_name, 10);
624:
625: OPEN csr_asg (c_effective_date => p_effective_date
626: ,c_assignment_id => l_asg_rec.assignment_id
627: ,c_business_group_id => l_asg_rec.business_group_id
631: CLOSE csr_asg;
632: RAISE e_empasg_notfound;
633: END IF;
634: CLOSE csr_asg;
635: hr_utility.set_location(' l_cur_asg_rec: ' || p_effective_date, 20);
636: hr_utility.set_location(' l_cur_asg_rec: ' || l_asg_rec.assignment_id, 20);
637: hr_utility.set_location(' l_cur_asg_rec: ' || l_asg_rec.business_group_id, 20);
638:
639: OPEN csr_ppg(c_people_grp_id => l_asg_rec.people_group_id);
632: RAISE e_empasg_notfound;
633: END IF;
634: CLOSE csr_asg;
635: hr_utility.set_location(' l_cur_asg_rec: ' || p_effective_date, 20);
636: hr_utility.set_location(' l_cur_asg_rec: ' || l_asg_rec.assignment_id, 20);
637: hr_utility.set_location(' l_cur_asg_rec: ' || l_asg_rec.business_group_id, 20);
638:
639: OPEN csr_ppg(c_people_grp_id => l_asg_rec.people_group_id);
640: FETCH csr_ppg INTO l_cur_ppl_grp_rec;
633: END IF;
634: CLOSE csr_asg;
635: hr_utility.set_location(' l_cur_asg_rec: ' || p_effective_date, 20);
636: hr_utility.set_location(' l_cur_asg_rec: ' || l_asg_rec.assignment_id, 20);
637: hr_utility.set_location(' l_cur_asg_rec: ' || l_asg_rec.business_group_id, 20);
638:
639: OPEN csr_ppg(c_people_grp_id => l_asg_rec.people_group_id);
640: FETCH csr_ppg INTO l_cur_ppl_grp_rec;
641: IF csr_ppg%FOUND THEN
641: IF csr_ppg%FOUND THEN
642: p_asg_crit_out.people_group_id := l_asg_rec.people_group_id;
643: END IF;
644: CLOSE csr_ppg;
645: hr_utility.set_location(' people_group_id: ' || l_asg_rec.people_group_id, 30);
646:
647: OPEN csr_scl(c_scl_kff_id => l_asg_rec.soft_coding_keyflex_id);
648: FETCH csr_scl INTO l_cur_scl_rec;
649: IF csr_scl%FOUND THEN
649: IF csr_scl%FOUND THEN
650: p_asg_crit_out.soft_coding_keyflex_id := l_asg_rec.soft_coding_keyflex_id;
651: END IF;
652: CLOSE csr_scl;
653: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
654: l_asg_rec.soft_coding_keyflex_id, 40);
655:
656: Dt_Api.Find_DT_Upd_Modes
657: (p_effective_date => p_effective_date
670: l_upd_chg_ins THEN
671: -- Need to check if person type in future is EMP, APL or CWK , if yes
672: -- then raise error
673: l_datetrack_update_mode := 'UPDATE';
674: hr_utility.set_location(' l_dt_upd_override or l_upd_chg_ins ', 50);
675: ELSE
676: l_datetrack_update_mode := 'CORRECTION';
677: END IF;
678: hr_utility.set_location(' l_datetrack_update_mode: ' ||
674: hr_utility.set_location(' l_dt_upd_override or l_upd_chg_ins ', 50);
675: ELSE
676: l_datetrack_update_mode := 'CORRECTION';
677: END IF;
678: hr_utility.set_location(' l_datetrack_update_mode: ' ||
679: l_datetrack_update_mode, 60);
680:
681: Hr_Assignment_Api.Update_Emp_Asg_Criteria
682: (p_effective_date => p_effective_date
753: ,p_concatenated_segments => p_asg_crit_out.concatenated_segments
754: ,p_gsp_post_process_warning => p_asg_crit_out.gsp_post_process_warning
755: );
756: IF g_debug_on THEN
757: hr_utility.set_location(' people_group_id: ' ||
758: p_asg_crit_out.people_group_id, 70);
759: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
760: p_asg_crit_out.soft_coding_keyflex_id, 70);
761: hr_utility.set_location(' group_name: ' ||
755: );
756: IF g_debug_on THEN
757: hr_utility.set_location(' people_group_id: ' ||
758: p_asg_crit_out.people_group_id, 70);
759: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
760: p_asg_crit_out.soft_coding_keyflex_id, 70);
761: hr_utility.set_location(' group_name: ' ||
762: p_asg_crit_out.group_name, 70);
763: hr_utility.set_location(' asg_effective_start_date: ' ||
757: hr_utility.set_location(' people_group_id: ' ||
758: p_asg_crit_out.people_group_id, 70);
759: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
760: p_asg_crit_out.soft_coding_keyflex_id, 70);
761: hr_utility.set_location(' group_name: ' ||
762: p_asg_crit_out.group_name, 70);
763: hr_utility.set_location(' asg_effective_start_date: ' ||
764: p_asg_crit_out.asg_effective_start_date, 70);
765: END IF;
759: hr_utility.set_location(' soft_coding_keyflex_id: ' ||
760: p_asg_crit_out.soft_coding_keyflex_id, 70);
761: hr_utility.set_location(' group_name: ' ||
762: p_asg_crit_out.group_name, 70);
763: hr_utility.set_location(' asg_effective_start_date: ' ||
764: p_asg_crit_out.asg_effective_start_date, 70);
765: END IF;
766: l_datetrack_update_mode := 'CORRECTION';
767:
948: ,p_hourly_salaried_warning => p_updasg_api_out.hourly_salaried_warning
949: ,p_gsp_post_process_warning => p_updasg_api_out.gsp_post_process_warning
950: )*/
951:
952: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
953:
954: EXCEPTION
955: WHEN e_empasg_notfound THEN
956: l_error_msg :=
954: EXCEPTION
955: WHEN e_empasg_notfound THEN
956: l_error_msg :=
957: 'Employee Assignment could not be found as of the effective date';
958: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
959: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
960: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
961: hr_utility.raise_error;
962:
955: WHEN e_empasg_notfound THEN
956: l_error_msg :=
957: 'Employee Assignment could not be found as of the effective date';
958: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
959: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
960: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
961: hr_utility.raise_error;
962:
963: WHEN Others THEN
956: l_error_msg :=
957: 'Employee Assignment could not be found as of the effective date';
958: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
959: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
960: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
961: hr_utility.raise_error;
962:
963: WHEN Others THEN
964: l_error_msg := SQLERRM;
957: 'Employee Assignment could not be found as of the effective date';
958: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
959: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
960: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
961: hr_utility.raise_error;
962:
963: WHEN Others THEN
964: l_error_msg := SQLERRM;
965: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
961: hr_utility.raise_error;
962:
963: WHEN Others THEN
964: l_error_msg := SQLERRM;
965: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
966: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
967: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
968: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
969: hr_utility.raise_error;
962:
963: WHEN Others THEN
964: l_error_msg := SQLERRM;
965: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
966: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
967: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
968: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
969: hr_utility.raise_error;
970:
963: WHEN Others THEN
964: l_error_msg := SQLERRM;
965: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
966: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
967: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
968: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
969: hr_utility.raise_error;
970:
971: END Update_StuEmpAsg_Criteria;
964: l_error_msg := SQLERRM;
965: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
966: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
967: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
968: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
969: hr_utility.raise_error;
970:
971: END Update_StuEmpAsg_Criteria;
972:
965: hr_utility.set_location('SQLCODE :' || SQLCODE,100);
966: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
967: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
968: hr_utility.set_location('Leaving: ' || l_proc_name, 100);
969: hr_utility.raise_error;
970:
971: END Update_StuEmpAsg_Criteria;
972:
973: -- =============================================================================
993: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'InsUpd_Address';
994: l_error_msg Varchar2(2000);
995:
996: BEGIN
997: hr_utility.set_location('Entering: ' || l_proc_name, 10);
998:
999: OPEN csr_add(c_person_id => l_add_rec.person_id
1000: ,c_business_group_id => l_add_rec.business_group_id
1001: ,c_effective_date => p_effective_date
1002: ,c_primary_flag => NVL(l_add_rec.primary_flag,'Y'));
1003: FETCH csr_add INTO l_cur_add_rec;
1004:
1005: IF csr_add%NOTFOUND THEN
1006: hr_utility.set_location(' Primary Address Not found', 20);
1007: Pqp_Hrtca_Integration.Person_Address_Api
1008: (p_HR_Address_Rec => l_add_rec
1009: ,p_validate => FALSE
1010: ,p_action => 'CREATE'
1014: ,p_validate_county => TRUE
1015: ,p_HR_address_id => l_add_rec.address_id
1016: ,p_HR_object_version_number => l_add_rec.object_version_number);
1017: ELSE
1018: hr_utility.set_location(' Primary Address found: ' ||
1019: l_cur_add_rec.address_id, 30);
1020:
1021: IF Trunc(l_cur_add_rec.date_from) = Trunc(p_effective_date) THEN
1022: l_add_rec.address_id := l_cur_add_rec.address_id;
1033: ,p_HR_address_id => l_add_rec.address_id
1034: ,p_HR_object_version_number => l_add_rec.object_version_number);
1035:
1036: ELSIF Trunc(p_effective_date) > Trunc(l_cur_add_rec.date_from) THEN
1037: hr_utility.set_location(' l_add_rec.date_from: ' ||
1038: l_add_rec.date_from, 40);
1039: hr_utility.set_location(' l_add_rec.date_to: ' ||
1040: l_add_rec.date_to, 40);
1041: Pqp_Hrtca_Integration.Person_Address_Api
1035:
1036: ELSIF Trunc(p_effective_date) > Trunc(l_cur_add_rec.date_from) THEN
1037: hr_utility.set_location(' l_add_rec.date_from: ' ||
1038: l_add_rec.date_from, 40);
1039: hr_utility.set_location(' l_add_rec.date_to: ' ||
1040: l_add_rec.date_to, 40);
1041: Pqp_Hrtca_Integration.Person_Address_Api
1042: (p_HR_Address_Rec => l_add_rec
1043: ,p_validate => FALSE
1051: END IF;
1052: END IF;
1053: CLOSE csr_add;
1054:
1055: hr_utility.set_location('Leaving: ' || l_proc_name, 50);
1056:
1057: EXCEPTION
1058: WHEN Others THEN
1059: IF csr_add%ISOPEN THEN
1059: IF csr_add%ISOPEN THEN
1060: CLOSE csr_add;
1061: END IF;
1062: l_error_msg := Substr(SQLERRM,1,2000);
1063: hr_utility.set_location('SQLCODE :' || SQLCODE,60);
1064: hr_utility.set_location('SQLERRM :' || SQLERRM,60);
1065: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1066: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1067: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
1060: CLOSE csr_add;
1061: END IF;
1062: l_error_msg := Substr(SQLERRM,1,2000);
1063: hr_utility.set_location('SQLCODE :' || SQLCODE,60);
1064: hr_utility.set_location('SQLERRM :' || SQLERRM,60);
1065: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1066: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1067: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
1068: hr_utility.raise_error;
1061: END IF;
1062: l_error_msg := Substr(SQLERRM,1,2000);
1063: hr_utility.set_location('SQLCODE :' || SQLCODE,60);
1064: hr_utility.set_location('SQLERRM :' || SQLERRM,60);
1065: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1066: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1067: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
1068: hr_utility.raise_error;
1069:
1062: l_error_msg := Substr(SQLERRM,1,2000);
1063: hr_utility.set_location('SQLCODE :' || SQLCODE,60);
1064: hr_utility.set_location('SQLERRM :' || SQLERRM,60);
1065: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1066: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1067: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
1068: hr_utility.raise_error;
1069:
1070: END InsUpd_Address;
1063: hr_utility.set_location('SQLCODE :' || SQLCODE,60);
1064: hr_utility.set_location('SQLERRM :' || SQLERRM,60);
1065: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1066: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1067: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
1068: hr_utility.raise_error;
1069:
1070: END InsUpd_Address;
1071:
1064: hr_utility.set_location('SQLERRM :' || SQLERRM,60);
1065: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1066: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1067: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
1068: hr_utility.raise_error;
1069:
1070: END InsUpd_Address;
1071:
1072: -- =============================================================================
1124: l_effective_date Date;
1125: l_unaccepted_asg_del_warning Boolean;
1126:
1127: BEGIN
1128: hr_utility.set_location('Entering: ' || l_proc_name, 10);
1129:
1130: g_debug := hr_utility.debug_enabled;
1131: l_effective_date := p_hire_date;
1132:
1126:
1127: BEGIN
1128: hr_utility.set_location('Entering: ' || l_proc_name, 10);
1129:
1130: g_debug := hr_utility.debug_enabled;
1131: l_effective_date := p_hire_date;
1132:
1133: -- Get the person details for the person
1134: OPEN csr_per(c_person_id => l_per_rec.person_id
1135: ,c_business_group_id => l_per_rec.business_group_id
1136: ,c_effective_date => l_effective_date);
1137: FETCH csr_per INTO l_cur_per_rec;
1138: CLOSE csr_per;
1139: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
1140:
1141: -- Get the Applicant assignment details
1142: OPEN csr_asg (c_person_id => l_per_rec.person_id
1143: ,c_business_group_id => l_per_rec.business_group_id
1147: FETCH csr_asg INTO l_perasg_rec;
1148: CLOSE csr_asg;
1149:
1150: IF g_debug THEN
1151: hr_utility.set_location(' l_perasg_rec.person_id: ' ||
1152: l_perasg_rec.person_id, 30);
1153: hr_utility.set_location(' l_perasg_rec.asg_id: ' ||
1154: l_perasg_rec.assignment_id, 30);
1155: hr_utility.set_location(' l_perasg_rec.person_ovn: ' ||
1149:
1150: IF g_debug THEN
1151: hr_utility.set_location(' l_perasg_rec.person_id: ' ||
1152: l_perasg_rec.person_id, 30);
1153: hr_utility.set_location(' l_perasg_rec.asg_id: ' ||
1154: l_perasg_rec.assignment_id, 30);
1155: hr_utility.set_location(' l_perasg_rec.person_ovn: ' ||
1156: l_perasg_rec.per_ovn, 30);
1157: hr_utility.set_location(' l_perasg_rec.asg_ovn: ' ||
1151: hr_utility.set_location(' l_perasg_rec.person_id: ' ||
1152: l_perasg_rec.person_id, 30);
1153: hr_utility.set_location(' l_perasg_rec.asg_id: ' ||
1154: l_perasg_rec.assignment_id, 30);
1155: hr_utility.set_location(' l_perasg_rec.person_ovn: ' ||
1156: l_perasg_rec.per_ovn, 30);
1157: hr_utility.set_location(' l_perasg_rec.asg_ovn: ' ||
1158: l_perasg_rec.asg_ovn, 30);
1159: hr_utility.set_location(' l_effective_date: ' ||
1153: hr_utility.set_location(' l_perasg_rec.asg_id: ' ||
1154: l_perasg_rec.assignment_id, 30);
1155: hr_utility.set_location(' l_perasg_rec.person_ovn: ' ||
1156: l_perasg_rec.per_ovn, 30);
1157: hr_utility.set_location(' l_perasg_rec.asg_ovn: ' ||
1158: l_perasg_rec.asg_ovn, 30);
1159: hr_utility.set_location(' l_effective_date: ' ||
1160: l_effective_date, 30);
1161: END IF;
1155: hr_utility.set_location(' l_perasg_rec.person_ovn: ' ||
1156: l_perasg_rec.per_ovn, 30);
1157: hr_utility.set_location(' l_perasg_rec.asg_ovn: ' ||
1158: l_perasg_rec.asg_ovn, 30);
1159: hr_utility.set_location(' l_effective_date: ' ||
1160: l_effective_date, 30);
1161: END IF;
1162: l_accp_asg_count := 0;
1163: FOR accp_ags IN csr_accepted_asgs
1171:
1172: IF l_accp_asg_count < 1 THEN
1173: -- Means the Applicant Assignment is not accepted, so update the applicant
1174: -- as accepted as of the hire date.
1175: hr_utility.set_location(' Asg Id NOT Accepted : ' || p_assignment_id, 40);
1176: Dt_Api.Find_DT_Upd_Modes
1177: (p_effective_date => p_hire_date
1178: ,p_base_table_name => 'PER_ALL_ASSIGNMENTS_F'
1179: ,p_base_key_column => 'ASSIGNMENT_ID'
1194: NULL;
1195: ELSE
1196: l_datetrack_update_mode := 'CORRECTION';
1197: END IF;
1198: hr_utility.set_location(' DT Mode for Update of Appl Asg : ' ||
1199: l_datetrack_update_mode, 50);
1200:
1201: -- Get the Accepted Applicant Status Id
1202: OPEN csr_asg_status (c_leg_code => g_leg_code
1203: ,c_business_group_id => l_per_rec.business_group_id
1204: );
1205: FETCH csr_asg_status INTO l_asg_status_rec;
1206: CLOSE csr_asg_status;
1207: hr_utility.set_location(' Accepted Asg Status ID: ' ||
1208: l_asg_status_rec.assignment_status_type_id, 60);
1209:
1210: -- Now accept the Applicant assigment used to hire the person
1211: HR_Assignment_API.Accept_APL_Asg
1219: ,p_effective_start_date => l_appl_asg_start_date
1220: ,p_effective_end_date => l_appl_asg_end_date
1221: );
1222: IF g_debug THEN
1223: hr_utility.set_location(' l_appl_asg_start_date: ' ||
1224: l_appl_asg_start_date, 70);
1225: hr_utility.set_location(' l_appl_asg_end_date: ' ||
1226: l_appl_asg_end_date, 70);
1227: hr_utility.set_location(' l_perasg_rec.asg_ovn: ' ||
1221: );
1222: IF g_debug THEN
1223: hr_utility.set_location(' l_appl_asg_start_date: ' ||
1224: l_appl_asg_start_date, 70);
1225: hr_utility.set_location(' l_appl_asg_end_date: ' ||
1226: l_appl_asg_end_date, 70);
1227: hr_utility.set_location(' l_perasg_rec.asg_ovn: ' ||
1228: l_perasg_rec.asg_ovn, 70);
1229: END IF;
1223: hr_utility.set_location(' l_appl_asg_start_date: ' ||
1224: l_appl_asg_start_date, 70);
1225: hr_utility.set_location(' l_appl_asg_end_date: ' ||
1226: l_appl_asg_end_date, 70);
1227: hr_utility.set_location(' l_perasg_rec.asg_ovn: ' ||
1228: l_perasg_rec.asg_ovn, 70);
1229: END IF;
1230:
1231: -- Get again the person details for the person
1233: ,c_business_group_id => l_per_rec.business_group_id
1234: ,c_effective_date => l_effective_date);
1235: FETCH csr_per INTO l_cur_per_rec;
1236: CLOSE csr_per;
1237: hr_utility.set_location(' per_rec.ovn: ' ||
1238: l_cur_per_rec.object_version_number, 80);
1239: ELSE
1240: hr_utility.set_location(' Asg Id Accepted Already: ' ||
1241: p_assignment_id, 90);
1236: CLOSE csr_per;
1237: hr_utility.set_location(' per_rec.ovn: ' ||
1238: l_cur_per_rec.object_version_number, 80);
1239: ELSE
1240: hr_utility.set_location(' Asg Id Accepted Already: ' ||
1241: p_assignment_id, 90);
1242: END IF;
1243:
1244: -- Get the count of accepted Applicant Assignments
1296: ELSE
1297: l_datetrack_update_mode := 'CORRECTION';
1298: END IF;
1299:
1300: hr_utility.set_location(' l_datetrack_update_mode: ' ||
1301: l_datetrack_update_mode, 100);
1302: l_per_rec.object_version_number := l_cur_per_rec.object_version_number;
1303: IF l_tot_appl_asgs = 1 THEN
1304: -- As the person has only one applicant assignment then hire person so that
1355: FETCH csr_per INTO l_cur_per_rec;
1356: CLOSE csr_per;
1357:
1358: IF g_debug_on THEN
1359: hr_utility.set_location('..effective_start_date : ' ||
1360: p_HireAppapi_out.effective_start_date, 110);
1361: hr_utility.set_location('..effective_end_date : ' ||
1362: p_HireAppapi_out.effective_end_date, 110);
1363: hr_utility.set_location('..Old:object_version_number : ' ||
1357:
1358: IF g_debug_on THEN
1359: hr_utility.set_location('..effective_start_date : ' ||
1360: p_HireAppapi_out.effective_start_date, 110);
1361: hr_utility.set_location('..effective_end_date : ' ||
1362: p_HireAppapi_out.effective_end_date, 110);
1363: hr_utility.set_location('..Old:object_version_number : ' ||
1364: l_cur_per_rec.object_version_number, 110);
1365: END IF;
1359: hr_utility.set_location('..effective_start_date : ' ||
1360: p_HireAppapi_out.effective_start_date, 110);
1361: hr_utility.set_location('..effective_end_date : ' ||
1362: p_HireAppapi_out.effective_end_date, 110);
1363: hr_utility.set_location('..Old:object_version_number : ' ||
1364: l_cur_per_rec.object_version_number, 110);
1365: END IF;
1366: l_datetrack_update_mode := 'CORRECTION';
1367:
1561: ,p_orig_hire_warning => p_updper_api_out.orig_hire_warning
1562: );
1563:
1564: IF g_debug_on THEN
1565: hr_utility.set_location('..effective_start_date : ' ||
1566: p_updper_api_out.effective_start_date, 120);
1567: hr_utility.set_location('..effective_end_date : ' ||
1568: p_updper_api_out.effective_end_date, 120);
1569: hr_utility.set_location('..full_name : ' ||
1563:
1564: IF g_debug_on THEN
1565: hr_utility.set_location('..effective_start_date : ' ||
1566: p_updper_api_out.effective_start_date, 120);
1567: hr_utility.set_location('..effective_end_date : ' ||
1568: p_updper_api_out.effective_end_date, 120);
1569: hr_utility.set_location('..full_name : ' ||
1570: p_updper_api_out.full_name, 120);
1571: hr_utility.set_location('Leaving: ' || l_proc_name, 120);
1565: hr_utility.set_location('..effective_start_date : ' ||
1566: p_updper_api_out.effective_start_date, 120);
1567: hr_utility.set_location('..effective_end_date : ' ||
1568: p_updper_api_out.effective_end_date, 120);
1569: hr_utility.set_location('..full_name : ' ||
1570: p_updper_api_out.full_name, 120);
1571: hr_utility.set_location('Leaving: ' || l_proc_name, 120);
1572: END IF;
1573:
1567: hr_utility.set_location('..effective_end_date : ' ||
1568: p_updper_api_out.effective_end_date, 120);
1569: hr_utility.set_location('..full_name : ' ||
1570: p_updper_api_out.full_name, 120);
1571: hr_utility.set_location('Leaving: ' || l_proc_name, 120);
1572: END IF;
1573:
1574: EXCEPTION
1575: WHEN Others THEN
1582: IF csr_asg_status%ISOPEN THEN
1583: CLOSE csr_asg_status;
1584: END IF;
1585: l_error_msg := Substr(SQLERRM,1,2000);
1586: hr_utility.set_location('SQLCODE :' || SQLCODE, 130);
1587: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1588: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1589: hr_utility.set_location('Leaving: ' || l_proc_name, 130);
1590: hr_utility.raise_error;
1583: CLOSE csr_asg_status;
1584: END IF;
1585: l_error_msg := Substr(SQLERRM,1,2000);
1586: hr_utility.set_location('SQLCODE :' || SQLCODE, 130);
1587: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1588: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1589: hr_utility.set_location('Leaving: ' || l_proc_name, 130);
1590: hr_utility.raise_error;
1591:
1584: END IF;
1585: l_error_msg := Substr(SQLERRM,1,2000);
1586: hr_utility.set_location('SQLCODE :' || SQLCODE, 130);
1587: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1588: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1589: hr_utility.set_location('Leaving: ' || l_proc_name, 130);
1590: hr_utility.raise_error;
1591:
1592: END Hire_Applicant_IntoEmp;
1585: l_error_msg := Substr(SQLERRM,1,2000);
1586: hr_utility.set_location('SQLCODE :' || SQLCODE, 130);
1587: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1588: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1589: hr_utility.set_location('Leaving: ' || l_proc_name, 130);
1590: hr_utility.raise_error;
1591:
1592: END Hire_Applicant_IntoEmp;
1593:
1586: hr_utility.set_location('SQLCODE :' || SQLCODE, 130);
1587: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1588: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1589: hr_utility.set_location('Leaving: ' || l_proc_name, 130);
1590: hr_utility.raise_error;
1591:
1592: END Hire_Applicant_IntoEmp;
1593:
1594: -- =============================================================================
1628: l_error_msg Varchar2(2000);
1629: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Hire_Person_IntoEmp';
1630: e_future_chgs_exists Exception;
1631: BEGIN
1632: hr_utility.set_location('Entering: ' || l_proc_name, 10);
1633:
1634: OPEN csr_per(c_person_id => l_per_rec.person_id
1635: ,c_business_group_id => l_per_rec.business_group_id
1636: ,c_effective_date => p_hire_date);
1635: ,c_business_group_id => l_per_rec.business_group_id
1636: ,c_effective_date => p_hire_date);
1637: FETCH csr_per INTO l_cur_per_rec;
1638: CLOSE csr_per;
1639: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
1640:
1641: Dt_Api.Find_DT_Upd_Modes
1642: (p_effective_date => p_hire_date
1643: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
1668: ELSE
1669: l_datetrack_update_mode := 'CORRECTION';
1670: END IF;
1671:
1672: hr_utility.set_location('l_datetrack_update_mode: ' ||
1673: l_datetrack_update_mode, 30);
1674: l_per_rec.object_version_number := l_cur_per_rec.object_version_number;
1675:
1676: Hr_Employee_Api.Hire_Into_Job
1703: FETCH csr_per INTO l_cur_per_rec;
1704: CLOSE csr_per;
1705:
1706: IF g_debug_on THEN
1707: hr_utility.set_location('..effective_start_date : ' ||
1708: p_HireToJobapi_out.effective_start_date,40);
1709: hr_utility.set_location('..effective_end_date : ' ||
1710: p_HireToJobapi_out.effective_end_date,40);
1711: hr_utility.set_location('..New:object_version_number : ' ||
1705:
1706: IF g_debug_on THEN
1707: hr_utility.set_location('..effective_start_date : ' ||
1708: p_HireToJobapi_out.effective_start_date,40);
1709: hr_utility.set_location('..effective_end_date : ' ||
1710: p_HireToJobapi_out.effective_end_date,40);
1711: hr_utility.set_location('..New:object_version_number : ' ||
1712: l_per_rec.object_version_number,40);
1713: hr_utility.set_location('..Old:object_version_number : ' ||
1707: hr_utility.set_location('..effective_start_date : ' ||
1708: p_HireToJobapi_out.effective_start_date,40);
1709: hr_utility.set_location('..effective_end_date : ' ||
1710: p_HireToJobapi_out.effective_end_date,40);
1711: hr_utility.set_location('..New:object_version_number : ' ||
1712: l_per_rec.object_version_number,40);
1713: hr_utility.set_location('..Old:object_version_number : ' ||
1714: l_cur_per_rec.object_version_number,40);
1715: hr_utility.set_location('..New:Assignment Id : ' ||
1709: hr_utility.set_location('..effective_end_date : ' ||
1710: p_HireToJobapi_out.effective_end_date,40);
1711: hr_utility.set_location('..New:object_version_number : ' ||
1712: l_per_rec.object_version_number,40);
1713: hr_utility.set_location('..Old:object_version_number : ' ||
1714: l_cur_per_rec.object_version_number,40);
1715: hr_utility.set_location('..New:Assignment Id : ' ||
1716: p_HireToJobapi_out.assignment_id,40);
1717: END IF;
1711: hr_utility.set_location('..New:object_version_number : ' ||
1712: l_per_rec.object_version_number,40);
1713: hr_utility.set_location('..Old:object_version_number : ' ||
1714: l_cur_per_rec.object_version_number,40);
1715: hr_utility.set_location('..New:Assignment Id : ' ||
1716: p_HireToJobapi_out.assignment_id,40);
1717: END IF;
1718: l_datetrack_update_mode := 'CORRECTION';
1719:
1912: ,p_assign_payroll_warning => p_updper_api_out.assign_payroll_warning
1913: ,p_orig_hire_warning => p_updper_api_out.orig_hire_warning
1914: );
1915: IF g_debug_on THEN
1916: hr_utility.set_location('..effective_start_date : ' ||
1917: p_updper_api_out.effective_start_date, 50);
1918: hr_utility.set_location('..effective_end_date : ' ||
1919: p_updper_api_out.effective_end_date, 50);
1920: hr_utility.set_location('..full_name : ' ||
1914: );
1915: IF g_debug_on THEN
1916: hr_utility.set_location('..effective_start_date : ' ||
1917: p_updper_api_out.effective_start_date, 50);
1918: hr_utility.set_location('..effective_end_date : ' ||
1919: p_updper_api_out.effective_end_date, 50);
1920: hr_utility.set_location('..full_name : ' ||
1921: p_updper_api_out.full_name, 50);
1922: hr_utility.set_location('Leaving: ' || l_proc_name, 50);
1916: hr_utility.set_location('..effective_start_date : ' ||
1917: p_updper_api_out.effective_start_date, 50);
1918: hr_utility.set_location('..effective_end_date : ' ||
1919: p_updper_api_out.effective_end_date, 50);
1920: hr_utility.set_location('..full_name : ' ||
1921: p_updper_api_out.full_name, 50);
1922: hr_utility.set_location('Leaving: ' || l_proc_name, 50);
1923: END IF;
1924:
1918: hr_utility.set_location('..effective_end_date : ' ||
1919: p_updper_api_out.effective_end_date, 50);
1920: hr_utility.set_location('..full_name : ' ||
1921: p_updper_api_out.full_name, 50);
1922: hr_utility.set_location('Leaving: ' || l_proc_name, 50);
1923: END IF;
1924:
1925: EXCEPTION
1926: WHEN e_future_chgs_exists THEN
1926: WHEN e_future_chgs_exists THEN
1927: l_error_msg := 'This person cannot be created in HRMS as a Student '||
1928: 'Employee due to future changes beyond the date: '||p_hire_date;
1929:
1930: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
1931: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1932: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1933: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
1934: hr_utility.raise_error;
1927: l_error_msg := 'This person cannot be created in HRMS as a Student '||
1928: 'Employee due to future changes beyond the date: '||p_hire_date;
1929:
1930: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
1931: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1932: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1933: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
1934: hr_utility.raise_error;
1935:
1928: 'Employee due to future changes beyond the date: '||p_hire_date;
1929:
1930: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
1931: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1932: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1933: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
1934: hr_utility.raise_error;
1935:
1936: WHEN Others THEN
1929:
1930: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
1931: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1932: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1933: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
1934: hr_utility.raise_error;
1935:
1936: WHEN Others THEN
1937: IF csr_asg%ISOPEN THEN
1930: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
1931: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1932: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1933: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
1934: hr_utility.raise_error;
1935:
1936: WHEN Others THEN
1937: IF csr_asg%ISOPEN THEN
1938: CLOSE csr_asg;
1940: IF csr_per%ISOPEN THEN
1941: CLOSE csr_per;
1942: END IF;
1943: l_error_msg := Substr(SQLERRM,1,2000);
1944: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1945: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1946: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1947: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
1948: hr_utility.raise_error;
1941: CLOSE csr_per;
1942: END IF;
1943: l_error_msg := Substr(SQLERRM,1,2000);
1944: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1945: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1946: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1947: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
1948: hr_utility.raise_error;
1949:
1942: END IF;
1943: l_error_msg := Substr(SQLERRM,1,2000);
1944: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1945: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1946: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1947: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
1948: hr_utility.raise_error;
1949:
1950: END Hire_Person_IntoEmp;
1943: l_error_msg := Substr(SQLERRM,1,2000);
1944: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1945: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1946: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1947: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
1948: hr_utility.raise_error;
1949:
1950: END Hire_Person_IntoEmp;
1951:
1944: hr_utility.set_location('SQLCODE :' || SQLCODE,90);
1945: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
1946: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
1947: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
1948: hr_utility.raise_error;
1949:
1950: END Hire_Person_IntoEmp;
1951:
1952: -- =============================================================================
1970:
1971: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Rehire_EmpIn_HRMS';
1972:
1973: BEGIN
1974: hr_utility.set_location('Entering: ' || l_proc_name, 10);
1975:
1976: OPEN csr_per(c_person_id => l_per_rec.person_id
1977: ,c_business_group_id => l_per_rec.business_group_id
1978: ,c_effective_date => p_rehire_date);
1977: ,c_business_group_id => l_per_rec.business_group_id
1978: ,c_effective_date => p_rehire_date);
1979: FETCH csr_per INTO l_cur_per_rec;
1980: CLOSE csr_per;
1981: hr_utility.set_location(' l_cur_asg_rec: ' || l_cur_per_rec.person_id, 20);
1982: Dt_Api.Find_DT_Upd_Modes
1983: (p_effective_date => p_rehire_date
1984: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
1985: ,p_base_key_column => 'PERSON_ID'
2001: -- Need to check if person type in future is EMP, APL or CWK , if yes
2002: -- then raise error
2003: NULL;
2004: END IF;
2005: hr_utility.set_location(' l_datetrack_update_mode: ' ||
2006: l_cur_per_rec.person_id, 30);
2007:
2008: Hr_Employee_Api.re_hire_ex_employee
2009: (p_validate => p_validate
2020: ,p_assignment_sequence => p_rehire_api_out.assignment_sequence
2021: ,p_assignment_number => p_rehire_api_out.assignment_number
2022: ,p_assign_payroll_warning => p_rehire_api_out.assign_payroll_warning
2023: );
2024: hr_utility.set_location('.. assignment_id : ' ||
2025: p_rehire_api_out.assignment_id,40);
2026: hr_utility.set_location('.. object_version_number : ' ||
2027: p_rehire_api_out.asg_object_version_number,40);
2028: hr_utility.set_location('.. per_effective_start_date : ' ||
2022: ,p_assign_payroll_warning => p_rehire_api_out.assign_payroll_warning
2023: );
2024: hr_utility.set_location('.. assignment_id : ' ||
2025: p_rehire_api_out.assignment_id,40);
2026: hr_utility.set_location('.. object_version_number : ' ||
2027: p_rehire_api_out.asg_object_version_number,40);
2028: hr_utility.set_location('.. per_effective_start_date : ' ||
2029: p_rehire_api_out.per_effective_start_date,40);
2030: hr_utility.set_location('.. per_effective_end_date : ' ||
2024: hr_utility.set_location('.. assignment_id : ' ||
2025: p_rehire_api_out.assignment_id,40);
2026: hr_utility.set_location('.. object_version_number : ' ||
2027: p_rehire_api_out.asg_object_version_number,40);
2028: hr_utility.set_location('.. per_effective_start_date : ' ||
2029: p_rehire_api_out.per_effective_start_date,40);
2030: hr_utility.set_location('.. per_effective_end_date : ' ||
2031: p_rehire_api_out.per_effective_end_date,40);
2032: hr_utility.set_location('.. assignment_sequence : ' ||
2026: hr_utility.set_location('.. object_version_number : ' ||
2027: p_rehire_api_out.asg_object_version_number,40);
2028: hr_utility.set_location('.. per_effective_start_date : ' ||
2029: p_rehire_api_out.per_effective_start_date,40);
2030: hr_utility.set_location('.. per_effective_end_date : ' ||
2031: p_rehire_api_out.per_effective_end_date,40);
2032: hr_utility.set_location('.. assignment_sequence : ' ||
2033: p_rehire_api_out.assignment_sequence,40);
2034: hr_utility.set_location('.. assignment_number : ' ||
2028: hr_utility.set_location('.. per_effective_start_date : ' ||
2029: p_rehire_api_out.per_effective_start_date,40);
2030: hr_utility.set_location('.. per_effective_end_date : ' ||
2031: p_rehire_api_out.per_effective_end_date,40);
2032: hr_utility.set_location('.. assignment_sequence : ' ||
2033: p_rehire_api_out.assignment_sequence,40);
2034: hr_utility.set_location('.. assignment_number : ' ||
2035: p_rehire_api_out.assignment_number,40);
2036: hr_utility.set_location('.. Employee Re-hired : ' ||
2030: hr_utility.set_location('.. per_effective_end_date : ' ||
2031: p_rehire_api_out.per_effective_end_date,40);
2032: hr_utility.set_location('.. assignment_sequence : ' ||
2033: p_rehire_api_out.assignment_sequence,40);
2034: hr_utility.set_location('.. assignment_number : ' ||
2035: p_rehire_api_out.assignment_number,40);
2036: hr_utility.set_location('.. Employee Re-hired : ' ||
2037: l_cur_per_rec.person_id, 40);
2038:
2032: hr_utility.set_location('.. assignment_sequence : ' ||
2033: p_rehire_api_out.assignment_sequence,40);
2034: hr_utility.set_location('.. assignment_number : ' ||
2035: p_rehire_api_out.assignment_number,40);
2036: hr_utility.set_location('.. Employee Re-hired : ' ||
2037: l_cur_per_rec.person_id, 40);
2038:
2039: l_per_rec.employee_number := NVL(l_per_rec.employee_number
2040: ,l_cur_per_rec.employee_number);
2207: ,p_assign_payroll_warning => p_updper_api_out.assign_payroll_warning
2208: ,p_orig_hire_warning => p_updper_api_out.orig_hire_warning
2209: );
2210:
2211: hr_utility.set_location('.. effective_start_date : ' ||
2212: p_updper_api_out.effective_start_date, 50);
2213: hr_utility.set_location('.. effective_end_date : ' ||
2214: p_updper_api_out.effective_end_date, 50);
2215: hr_utility.set_location('.. full_name : ' ||
2209: );
2210:
2211: hr_utility.set_location('.. effective_start_date : ' ||
2212: p_updper_api_out.effective_start_date, 50);
2213: hr_utility.set_location('.. effective_end_date : ' ||
2214: p_updper_api_out.effective_end_date, 50);
2215: hr_utility.set_location('.. full_name : ' ||
2216: p_updper_api_out.full_name, 50);
2217:
2211: hr_utility.set_location('.. effective_start_date : ' ||
2212: p_updper_api_out.effective_start_date, 50);
2213: hr_utility.set_location('.. effective_end_date : ' ||
2214: p_updper_api_out.effective_end_date, 50);
2215: hr_utility.set_location('.. full_name : ' ||
2216: p_updper_api_out.full_name, 50);
2217:
2218: hr_utility.set_location('Leaving: ' || l_proc_name, 50);
2219:
2214: p_updper_api_out.effective_end_date, 50);
2215: hr_utility.set_location('.. full_name : ' ||
2216: p_updper_api_out.full_name, 50);
2217:
2218: hr_utility.set_location('Leaving: ' || l_proc_name, 50);
2219:
2220: EXCEPTION
2221: WHEN Others THEN
2222: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
2218: hr_utility.set_location('Leaving: ' || l_proc_name, 50);
2219:
2220: EXCEPTION
2221: WHEN Others THEN
2222: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
2223: RAISE;
2224:
2225: END Rehire_EmpIn_HRMS;
2226:
2250:
2251: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Create_EmpIn_HRMS';
2252:
2253: BEGIN
2254: hr_utility.set_location('Entering: ' || l_proc_name, 10);
2255:
2256: IF g_emp_num_gen <> 'M' THEN
2257: l_per_rec.employee_number := Null;
2258: END IF;
2406: l_per_rec.effective_start_date := p_emp_api_out.per_effective_start_date;
2407: l_per_rec.effective_end_date := p_emp_api_out.per_effective_end_date;
2408:
2409: IF g_debug_on THEN
2410: hr_utility.set_location('..person_id : ' ||
2411: p_emp_api_out.person_id,20);
2412: hr_utility.set_location('..assignment_id : ' ||
2413: p_emp_api_out.assignment_id,20);
2414: hr_utility.set_location('..per_object_version_number : ' ||
2408:
2409: IF g_debug_on THEN
2410: hr_utility.set_location('..person_id : ' ||
2411: p_emp_api_out.person_id,20);
2412: hr_utility.set_location('..assignment_id : ' ||
2413: p_emp_api_out.assignment_id,20);
2414: hr_utility.set_location('..per_object_version_number : ' ||
2415: p_emp_api_out.per_object_version_number,20);
2416: hr_utility.set_location('..asg_object_version_number : ' ||
2410: hr_utility.set_location('..person_id : ' ||
2411: p_emp_api_out.person_id,20);
2412: hr_utility.set_location('..assignment_id : ' ||
2413: p_emp_api_out.assignment_id,20);
2414: hr_utility.set_location('..per_object_version_number : ' ||
2415: p_emp_api_out.per_object_version_number,20);
2416: hr_utility.set_location('..asg_object_version_number : ' ||
2417: p_emp_api_out.asg_object_version_number,20);
2418: hr_utility.set_location('..per_effective_start_date : ' ||
2412: hr_utility.set_location('..assignment_id : ' ||
2413: p_emp_api_out.assignment_id,20);
2414: hr_utility.set_location('..per_object_version_number : ' ||
2415: p_emp_api_out.per_object_version_number,20);
2416: hr_utility.set_location('..asg_object_version_number : ' ||
2417: p_emp_api_out.asg_object_version_number,20);
2418: hr_utility.set_location('..per_effective_start_date : ' ||
2419: p_emp_api_out.per_effective_start_date,20);
2420: hr_utility.set_location('..per_effective_end_date : ' ||
2414: hr_utility.set_location('..per_object_version_number : ' ||
2415: p_emp_api_out.per_object_version_number,20);
2416: hr_utility.set_location('..asg_object_version_number : ' ||
2417: p_emp_api_out.asg_object_version_number,20);
2418: hr_utility.set_location('..per_effective_start_date : ' ||
2419: p_emp_api_out.per_effective_start_date,20);
2420: hr_utility.set_location('..per_effective_end_date : ' ||
2421: p_emp_api_out.per_effective_end_date,20);
2422: hr_utility.set_location('..full_name : ' ||
2416: hr_utility.set_location('..asg_object_version_number : ' ||
2417: p_emp_api_out.asg_object_version_number,20);
2418: hr_utility.set_location('..per_effective_start_date : ' ||
2419: p_emp_api_out.per_effective_start_date,20);
2420: hr_utility.set_location('..per_effective_end_date : ' ||
2421: p_emp_api_out.per_effective_end_date,20);
2422: hr_utility.set_location('..full_name : ' ||
2423: p_emp_api_out.full_name,20);
2424: hr_utility.set_location('..per_comment_id : ' ||
2418: hr_utility.set_location('..per_effective_start_date : ' ||
2419: p_emp_api_out.per_effective_start_date,20);
2420: hr_utility.set_location('..per_effective_end_date : ' ||
2421: p_emp_api_out.per_effective_end_date,20);
2422: hr_utility.set_location('..full_name : ' ||
2423: p_emp_api_out.full_name,20);
2424: hr_utility.set_location('..per_comment_id : ' ||
2425: p_emp_api_out.per_comment_id,20);
2426: hr_utility.set_location('..assignment_sequence : ' ||
2420: hr_utility.set_location('..per_effective_end_date : ' ||
2421: p_emp_api_out.per_effective_end_date,20);
2422: hr_utility.set_location('..full_name : ' ||
2423: p_emp_api_out.full_name,20);
2424: hr_utility.set_location('..per_comment_id : ' ||
2425: p_emp_api_out.per_comment_id,20);
2426: hr_utility.set_location('..assignment_sequence : ' ||
2427: p_emp_api_out.assignment_sequence,20);
2428: hr_utility.set_location('..assignment_number : ' ||
2422: hr_utility.set_location('..full_name : ' ||
2423: p_emp_api_out.full_name,20);
2424: hr_utility.set_location('..per_comment_id : ' ||
2425: p_emp_api_out.per_comment_id,20);
2426: hr_utility.set_location('..assignment_sequence : ' ||
2427: p_emp_api_out.assignment_sequence,20);
2428: hr_utility.set_location('..assignment_number : ' ||
2429: p_emp_api_out.assignment_number,20);
2430: END IF;
2424: hr_utility.set_location('..per_comment_id : ' ||
2425: p_emp_api_out.per_comment_id,20);
2426: hr_utility.set_location('..assignment_sequence : ' ||
2427: p_emp_api_out.assignment_sequence,20);
2428: hr_utility.set_location('..assignment_number : ' ||
2429: p_emp_api_out.assignment_number,20);
2430: END IF;
2431:
2432: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
2428: hr_utility.set_location('..assignment_number : ' ||
2429: p_emp_api_out.assignment_number,20);
2430: END IF;
2431:
2432: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
2433:
2434: EXCEPTION
2435: WHEN Others THEN
2436: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
2432: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
2433:
2434: EXCEPTION
2435: WHEN Others THEN
2436: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
2437: RAISE;
2438:
2439: END Create_EmpIn_HRMS;
2440:
2495: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'HR_DataPump_Per_XtraInfo';
2496: --
2497:
2498: BEGIN
2499: hr_utility.set_location('Entering: ' || l_proc_name, 10);
2500:
2501: SAVEPOINT oss_per_dtls;
2502:
2503: l_oss_person_details := 'PQP_OSS_PERSON_DETAILS';
2518: ' AND ipt.system_type IN ('||'''STUDENT'''||',' ||
2519: '''FACULTY'''||','||'''OTHER''' ||')' ;
2520:
2521: -- Create the OSS Person EIT information
2522: hr_utility.set_location(' Creating: PQP_OSS_PERSON_DETAILS', 20);
2523:
2524: l_person_extra_info_rec.information_type := l_oss_person_details;
2525: l_person_extra_info_rec.pei_information_category := l_oss_person_details;
2526:
2535: OPEN csr_igs FOR SQLstmt Using p_party_id;
2536: FETCH csr_igs INTO l_oss_per_details;
2537: CLOSE csr_igs;
2538:
2539: hr_utility.set_location(' After Dyn SQL Ref Cursor', 30);
2540:
2541: l_person_extra_info_rec.pei_information1 := NVL(l_oss_per_details.system_type
2542: ,'STUDENT');
2543: l_person_extra_info_rec.pei_information2 := l_oss_per_details.person_number;
2653: ,p_person_extra_info_user_key => p_xtra_info_key
2654: );
2655:
2656: END IF;
2657: hr_utility.set_location(' After Cursor :csr_OSS_pe', 40);
2658: CLOSE csr_OSS_pe;
2659:
2660: hr_utility.set_location('Leaving: ' || l_proc_name, 50);
2661:
2656: END IF;
2657: hr_utility.set_location(' After Cursor :csr_OSS_pe', 40);
2658: CLOSE csr_OSS_pe;
2659:
2660: hr_utility.set_location('Leaving: ' || l_proc_name, 50);
2661:
2662: EXCEPTION
2663: WHEN Others THEN
2664: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
2660: hr_utility.set_location('Leaving: ' || l_proc_name, 50);
2661:
2662: EXCEPTION
2663: WHEN Others THEN
2664: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
2665: ROLLBACK TO oss_per_dtls;
2666:
2667: END HR_DataPump_Per_XtraInfo;
2668:
2747: l_user_sequence Number := 1;
2748: l_link_value Number;
2749:
2750: BEGIN
2751: hr_utility.set_location('Entering: ' || l_proc_name, 10);
2752:
2753: -- Creating User Keys for Person, Address, Assugnment and Contact
2754: l_temp := To_Char(Sysdate,'J')||
2755: To_Char(Sysdate,'HH24MISS')||
2767: OPEN csr_per_type(l_per_rec.person_type_id
2768: ,l_per_rec.business_group_id);
2769: FETCH csr_per_type INTO l_user_person_type;
2770: CLOSE csr_per_type;
2771: hr_utility.set_location('..l_user_person_type: ' || l_user_person_type, 20);
2772:
2773: -- Get the Link value for this record
2774: OPEN csr_get_link_value (p_batch_id);
2775: FETCH csr_get_link_value INTO l_link_value;
2917: );
2918:
2919: l_user_sequence := l_user_sequence + 1;
2920:
2921: hr_utility.set_location('..Inserted into Hrdpp_Create_Employee', 30);
2922:
2923: ELSIF p_dp_mode = 'UPDATE' THEN
2924:
2925: -- Cursor to get the Latest Details of Person in System
3406: );
3407:
3408: l_user_sequence := l_user_sequence + 1;
3409:
3410: hr_utility.set_location('.Inserted into Hrdpp_Create_Person_Address', 40);
3411:
3412: END IF;
3413: CLOSE csr_ck_add_xsts ;
3414:
3428: -- FETCH csr_asg INTO l_asg_rec.assignment_id,
3429: -- l_asg_rec.object_version_number;
3430: -- IF csr_asg%NOTFOUND THEN
3431: -- CLOSE csr_asg;
3432: -- hr_utility.raise_error;
3433: -- END IF;
3434: -- CLOSE csr_asg;
3435:
3436: -- hr_utility.set_location(' l_cur_asg_rec: '||
3432: -- hr_utility.raise_error;
3433: -- END IF;
3434: -- CLOSE csr_asg;
3435:
3436: -- hr_utility.set_location(' l_cur_asg_rec: '||
3437: -- l_asg_rec.assignment_id, 6);
3438:
3439: -- Dt_Api.Find_DT_Upd_Modes
3440: -- (p_effective_date => l_per_rec.start_date
3453: -- l_upd_chg_ins THEN
3454: -- Need to check if person type in future is EMP, APL or CWK , if yes
3455: -- then raise error
3456: -- l_datetrack_update_mode := 'UPDATE';
3457: -- hr_utility.set_location(' l_dt_upd_override or' ||
3458: -- ' l_upd_chg_ins ', 20);
3459: -- ELSE
3460: -- l_datetrack_update_mode := 'CORRECTION';
3461: -- END IF;
3458: -- ' l_upd_chg_ins ', 20);
3459: -- ELSE
3460: -- l_datetrack_update_mode := 'CORRECTION';
3461: -- END IF;
3462: -- hr_utility.set_location(' l_datetrack_update_mode: ' ||
3463: -- l_datetrack_update_mode, 20);
3464:
3465: -- ELSE
3466: -- l_datetrack_update_mode := 'CORRECTION';
3538: );
3539:
3540: l_user_sequence := l_user_sequence + 1;
3541:
3542: hr_utility.set_location('..Inserted into Hrdpp_Update_Emp_Asg', 50);
3543:
3544:
3545: OPEN csr_grade(l_asg_rec.grade_id
3546: ,l_asg_rec.business_group_id
3546: ,l_asg_rec.business_group_id
3547: ,l_per_rec.START_DATE);
3548: FETCH csr_grade INTO l_grade_name;
3549: IF csr_grade%NOTFOUND THEN
3550: hr_utility.set_location('..Grade Name not found Id: ' ||
3551: l_asg_rec.grade_id, 60);
3552: END IF;
3553: CLOSE csr_grade;
3554:
3556: ,l_asg_rec.business_group_id
3557: ,l_per_rec.START_DATE);
3558: FETCH csr_position INTO l_position_name;
3559: IF csr_position%NOTFOUND THEN
3560: hr_utility.set_location('..Position Name not found Id: ' ||
3561: l_asg_rec.position_id, 70);
3562: END IF;
3563: CLOSE csr_position;
3564:
3566: ,l_asg_rec.business_group_id
3567: ,l_per_rec.START_DATE);
3568: FETCH csr_job INTO l_job_name;
3569: IF csr_job%NOTFOUND THEN
3570: hr_utility.set_location('..Job Name not found Id: ' ||
3571: l_asg_rec.job_id, 80);
3572: END IF;
3573: CLOSE csr_job;
3574:
3576: ,l_asg_rec.business_group_id
3577: ,l_per_rec.START_DATE);
3578: FETCH csr_payroll INTO l_payroll_name;
3579: IF csr_payroll%NOTFOUND THEN
3580: hr_utility.set_location('..Payroll Name not found Id: ' ||
3581: l_asg_rec.payroll_id, 90);
3582: END IF;
3583: CLOSE csr_payroll;
3584:
3585: OPEN csr_location(l_asg_rec.location_id
3586: ,l_asg_rec.business_group_id);
3587: FETCH csr_location INTO l_location_code;
3588: IF csr_location%NOTFOUND THEN
3589: hr_utility.set_location('..Location Code not found, Id: ' ||
3590: l_asg_rec.location_id, 100);
3591: END IF;
3592: CLOSE csr_location;
3593:
3595: ,l_asg_rec.business_group_id
3596: ,l_per_rec.START_DATE);
3597: FETCH csr_organization INTO l_organization_name;
3598: IF csr_organization%NOTFOUND THEN
3599: hr_utility.set_location('..Org Name not found, Id: ' ||
3600: l_asg_rec.organization_id, 110);
3601: END IF;
3602: CLOSE csr_organization;
3603:
3604: OPEN csr_paybasis(l_asg_rec.pay_basis_id
3605: ,l_asg_rec.business_group_id);
3606: FETCH csr_paybasis INTO l_pay_basis_name;
3607: IF csr_paybasis%NOTFOUND THEN
3608: hr_utility.set_location('..Org Name not found, Id: ' ||
3609: l_asg_rec.pay_basis_id, 120);
3610: END IF;
3611: CLOSE csr_paybasis;
3612:
3661: );
3662:
3663: l_user_sequence := l_user_sequence + 1;
3664:
3665: hr_utility.set_location('..Inserted into' ||
3666: ' Hrdpp_Update_Emp_Asg_Criteria', 130);
3667:
3668: OPEN csr_get_cont_dtls(c_person_id => l_per_rec.person_id
3669: ,c_business_group_id => l_add_rec.business_group_id
3716:
3717: END IF;
3718: CLOSE csr_get_cont_dtls;
3719:
3720: hr_utility.set_location('..Inserted into Hrdpp_Create_Contact', 140);
3721:
3722: -- Call to People Extra Information Procedure
3723: HR_DataPump_Per_XtraInfo
3724: (p_business_group_id => l_per_rec.business_group_id
3733: );
3734:
3735: l_user_sequence := l_user_sequence + 1;
3736:
3737: hr_utility.set_location('..Called HR_DataPump_Per_XtraInfo', 150);
3738:
3739: hr_utility.set_location('Leaving: ' || l_proc_name, 160);
3740:
3741: EXCEPTION
3735: l_user_sequence := l_user_sequence + 1;
3736:
3737: hr_utility.set_location('..Called HR_DataPump_Per_XtraInfo', 150);
3738:
3739: hr_utility.set_location('Leaving: ' || l_proc_name, 160);
3740:
3741: EXCEPTION
3742: WHEN Others THEN
3743: IF csr_asg%ISOPEN THEN
3767: IF csr_get_cont_dtls%ISOPEN THEN
3768: CLOSE csr_get_cont_dtls;
3769: END IF;
3770:
3771: hr_utility.set_location('Leaving: ' || l_proc_name, 170);
3772:
3773: RAISE;
3774:
3775: END HR_DataPump;
3938:
3939: l_pradd_ovlapval_override Boolean;
3940:
3941: BEGIN
3942: hr_utility.set_location('Entering: ' || l_proc_name, 10);
3943:
3944: -- Check if operation being corrected was insert or update because of
3945: -- duplicate person id based on the API_MODULE_ID in hr_pump_batch_lines
3946: -- and then set dp_mode flag respectively
4590: ,l_asg_rec.business_group_id
4591: ,l_per_rec.START_DATE);
4592: FETCH csr_grade INTO l_grade_name;
4593: IF csr_grade%NOTFOUND THEN
4594: hr_utility.set_location('.. DP Error Grade Name not found Id: ' ||
4595: l_asg_rec.grade_id, 20);
4596: END IF;
4597: CLOSE csr_grade;
4598:
4600: ,l_asg_rec.business_group_id
4601: ,l_per_rec.START_DATE);
4602: FETCH csr_position INTO l_position_name;
4603: IF csr_position%NOTFOUND THEN
4604: hr_utility.set_location('.. DP Error Position Name not found Id: ' ||
4605: l_asg_rec.position_id, 20);
4606: END IF;
4607: CLOSE csr_position;
4608:
4610: ,l_asg_rec.business_group_id
4611: ,l_per_rec.START_DATE);
4612: FETCH csr_job INTO l_job_name;
4613: IF csr_job%NOTFOUND THEN
4614: hr_utility.set_location('.. DP Error Job Name not found Id: ' ||
4615: l_asg_rec.job_id, 20);
4616: END IF;
4617: CLOSE csr_job;
4618:
4620: ,l_asg_rec.business_group_id
4621: ,l_per_rec.START_DATE);
4622: FETCH csr_payroll INTO l_payroll_name;
4623: IF csr_payroll%NOTFOUND THEN
4624: hr_utility.set_location('.. DP Error Payroll Name not found Id: ' ||
4625: l_asg_rec.payroll_id, 20);
4626: END IF;
4627: CLOSE csr_payroll;
4628:
4629: OPEN csr_location(l_asg_rec.location_id
4630: ,l_asg_rec.business_group_id);
4631: FETCH csr_location INTO l_location_code;
4632: IF csr_location%NOTFOUND THEN
4633: hr_utility.set_location('.. DP Error Location Code not found, Id: ' ||
4634: l_asg_rec.location_id, 20);
4635: END IF;
4636: CLOSE csr_location;
4637:
4639: ,l_asg_rec.business_group_id
4640: ,l_per_rec.START_DATE);
4641: FETCH csr_organization INTO l_organization_name;
4642: IF csr_organization%NOTFOUND THEN
4643: hr_utility.set_location('.. DP Error Org Name not found, Id: ' ||
4644: l_asg_rec.organization_id, 20);
4645: END IF;
4646: CLOSE csr_organization;
4647:
4648: OPEN csr_paybasis(l_asg_rec.pay_basis_id
4649: ,l_asg_rec.business_group_id);
4650: FETCH csr_paybasis INTO l_pay_basis_name;
4651: IF csr_paybasis%NOTFOUND THEN
4652: hr_utility.set_location('.. DP Error Org Name not found, Id: ' ||
4653: l_asg_rec.pay_basis_id, 20);
4654: END IF;
4655: CLOSE csr_paybasis;
4656:
4770: END LOOP;
4771:
4772: CLOSE csr_get_api_names;
4773:
4774: hr_utility.set_location('Leaving: ' || l_proc_name, 30);
4775:
4776: EXCEPTION
4777: WHEN Others THEN
4778: IF csr_get_api_names%ISOPEN THEN
4777: WHEN Others THEN
4778: IF csr_get_api_names%ISOPEN THEN
4779: CLOSE csr_get_api_names;
4780: END IF;
4781: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
4782: RAISE;
4783:
4784: END HR_DataPumpErr;
4785:
4798:
4799: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Create_Person_Contact';
4800:
4801: BEGIN
4802: hr_utility.set_location('Entering: ' || l_proc_name, 10);
4803:
4804: Hr_Contact_Rel_Api.create_contact
4805: (p_start_date => p_effective_date
4806: ,p_business_group_id => l_cntct_rec.business_group_id
4821: ,p_name_combination_warning => p_crt_cntct_out.name_combination_warning
4822: ,p_orig_hire_warning => p_crt_cntct_out.orig_hire_warning
4823: );
4824:
4825: hr_utility.set_location('Leaving: ' || l_proc_name, 20);
4826:
4827: END Create_Person_Contact;
4828:
4829: -- =============================================================================
4839: l_cont_object_version_num Number;
4840: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Update_Person_Contact';
4841:
4842: BEGIN
4843: hr_utility.set_location('Entering: ' || l_proc_name, 10);
4844:
4845: OPEN csr_ck_cont_xsts(c_person_id => l_per_rec.person_id
4846: ,c_business_group_id => l_add_rec.business_group_id
4847: ,c_effective_date => l_per_rec.START_DATE);
4899: );
4900:
4901: END IF;
4902:
4903: hr_utility.set_location('Leaving: ' || l_proc_name, 20);
4904:
4905: END Update_Person_Contact;
4906:
4907:
4927: l_error_msg Varchar2(3000);
4928: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Upd_OSS_Person';
4929:
4930: BEGIN
4931: hr_utility.set_location('Entering: ' || l_proc_name, 10);
4932:
4933: OPEN csr_per(c_person_id => l_per_rec.person_id
4934: ,c_business_group_id => l_per_rec.business_group_id
4935: ,c_effective_date => p_effective_date);
4935: ,c_effective_date => p_effective_date);
4936: FETCH csr_per INTO l_cur_per_rec;
4937: CLOSE csr_per;
4938:
4939: hr_utility.set_location(' l_cur_per_rec: ' || l_cur_per_rec.person_id, 20);
4940:
4941: Dt_Api.Find_DT_Upd_Modes
4942: (p_effective_date => p_effective_date
4943: ,p_base_table_name => 'PER_ALL_PEOPLE_F'
4968: ELSE
4969: l_datetrack_update_mode := 'CORRECTION';
4970: END IF;
4971:
4972: hr_utility.set_location(' l_datetrack_update_mode: ' ||
4973: l_datetrack_update_mode, 30);
4974: hr_utility.set_location(' employee_number: ' ||
4975: l_cur_per_rec.employee_number, 30);
4976: hr_utility.set_location(' per ovn: ' ||
4970: END IF;
4971:
4972: hr_utility.set_location(' l_datetrack_update_mode: ' ||
4973: l_datetrack_update_mode, 30);
4974: hr_utility.set_location(' employee_number: ' ||
4975: l_cur_per_rec.employee_number, 30);
4976: hr_utility.set_location(' per ovn: ' ||
4977: l_cur_per_rec.object_version_number, 30);
4978:
4972: hr_utility.set_location(' l_datetrack_update_mode: ' ||
4973: l_datetrack_update_mode, 30);
4974: hr_utility.set_location(' employee_number: ' ||
4975: l_cur_per_rec.employee_number, 30);
4976: hr_utility.set_location(' per ovn: ' ||
4977: l_cur_per_rec.object_version_number, 30);
4978:
4979: -- Need to pass the employee number when updating the person
4980: l_per_rec.object_version_number := l_cur_per_rec.object_version_number;
5175: ,p_orig_hire_warning => p_updper_api_out.orig_hire_warning
5176: );
5177:
5178: IF g_debug_on THEN
5179: hr_utility.set_location('..effective_start_date : ' ||
5180: p_updper_api_out.effective_start_date,40);
5181: hr_utility.set_location('..effective_end_date : ' ||
5182: p_updper_api_out.effective_end_date,40);
5183: hr_utility.set_location('..full_name : ' ||
5177:
5178: IF g_debug_on THEN
5179: hr_utility.set_location('..effective_start_date : ' ||
5180: p_updper_api_out.effective_start_date,40);
5181: hr_utility.set_location('..effective_end_date : ' ||
5182: p_updper_api_out.effective_end_date,40);
5183: hr_utility.set_location('..full_name : ' ||
5184: p_updper_api_out.full_name,40);
5185: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
5179: hr_utility.set_location('..effective_start_date : ' ||
5180: p_updper_api_out.effective_start_date,40);
5181: hr_utility.set_location('..effective_end_date : ' ||
5182: p_updper_api_out.effective_end_date,40);
5183: hr_utility.set_location('..full_name : ' ||
5184: p_updper_api_out.full_name,40);
5185: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
5186: END IF;
5187:
5181: hr_utility.set_location('..effective_end_date : ' ||
5182: p_updper_api_out.effective_end_date,40);
5183: hr_utility.set_location('..full_name : ' ||
5184: p_updper_api_out.full_name,40);
5185: hr_utility.set_location('Leaving: ' || l_proc_name, 40);
5186: END IF;
5187:
5188: EXCEPTION
5189: WHEN e_future_chgs_exists THEN
5189: WHEN e_future_chgs_exists THEN
5190: l_error_msg := 'This person cannot be created in HRMS as a Student '||
5191: 'Employee due to future changes beyond the date: '||p_effective_date;
5192:
5193: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
5194: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
5195: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
5196: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
5197: hr_utility.raise_error;
5190: l_error_msg := 'This person cannot be created in HRMS as a Student '||
5191: 'Employee due to future changes beyond the date: '||p_effective_date;
5192:
5193: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
5194: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
5195: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
5196: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
5197: hr_utility.raise_error;
5198:
5191: 'Employee due to future changes beyond the date: '||p_effective_date;
5192:
5193: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
5194: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
5195: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
5196: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
5197: hr_utility.raise_error;
5198:
5199: WHEN Others THEN
5192:
5193: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
5194: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
5195: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
5196: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
5197: hr_utility.raise_error;
5198:
5199: WHEN Others THEN
5200: hr_utility.set_location('SQLERRM :' || SQLCODE,90);
5193: hr_utility.set_location('..Future Update exists for the Student Employee', 60);
5194: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
5195: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
5196: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
5197: hr_utility.raise_error;
5198:
5199: WHEN Others THEN
5200: hr_utility.set_location('SQLERRM :' || SQLCODE,90);
5201: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
5196: hr_utility.set_location('Leaving: ' || l_proc_name, 60);
5197: hr_utility.raise_error;
5198:
5199: WHEN Others THEN
5200: hr_utility.set_location('SQLERRM :' || SQLCODE,90);
5201: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
5202: RAISE;
5203:
5204: END Upd_OSS_Person;
5197: hr_utility.raise_error;
5198:
5199: WHEN Others THEN
5200: hr_utility.set_location('SQLERRM :' || SQLCODE,90);
5201: hr_utility.set_location('Leaving: ' || l_proc_name, 90);
5202: RAISE;
5203:
5204: END Upd_OSS_Person;
5205:
5627: END;
5628:
5629: BEGIN
5630: SAVEPOINT create_student_employee;
5631: g_debug_on := hr_utility.debug_enabled;
5632:
5633: hr_utility.set_location('Entering: ' || l_proc_name, 10);
5634:
5635: l_per_rec := NULL;
5629: BEGIN
5630: SAVEPOINT create_student_employee;
5631: g_debug_on := hr_utility.debug_enabled;
5632:
5633: hr_utility.set_location('Entering: ' || l_proc_name, 10);
5634:
5635: l_per_rec := NULL;
5636: l_hr_soft_rec := NULL;
5637: l_add_rec := NULL;
5664: -- Getting the National Identifier only if the student number and last
5665: -- 4 digits of the masked NI are same. This logic will fail if user
5666: -- changes NI or Student number. Hence it needs to be documneted
5667:
5668: hr_utility.set_location('Checking NI ', 20);
5669:
5670: IF p_web_adi_identifier <> 'DP ERROR' THEN
5671: l_dyn_sql_qry := 'SELECT api_person_id ' ||
5672: 'FROM igs_pe_person_v ' ||
5712: FETCH csr_chk_ni_exists INTO l_ni_exists;
5713: CLOSE csr_chk_ni_exists;
5714:
5715: IF l_ni_exists IS NOT NULL AND p_dup_person_id IS NULL THEN -- {
5716: hr_utility.set_message(8303, 'PQP_230171_OSS_NI_EXISTS');
5717: hr_utility.raise_error;
5718: END IF; -- }
5719:
5720: -- Get Party Id corresponding to Student Number. We are assuming that there
5713: CLOSE csr_chk_ni_exists;
5714:
5715: IF l_ni_exists IS NOT NULL AND p_dup_person_id IS NULL THEN -- {
5716: hr_utility.set_message(8303, 'PQP_230171_OSS_NI_EXISTS');
5717: hr_utility.raise_error;
5718: END IF; -- }
5719:
5720: -- Get Party Id corresponding to Student Number. We are assuming that there
5721: -- will never be a case when student number is not entered
5720: -- Get Party Id corresponding to Student Number. We are assuming that there
5721: -- will never be a case when student number is not entered
5722:
5723: IF (l_student_number IS NOT NULL) THEN -- {
5724: hr_utility.set_location('Student number is not null ', 30);
5725: l_sql_qry := 'SELECT ipe.person_id ' ||
5726: ' FROM igs_pe_person_v ipe, hz_party_sites hps ' ||
5727: ' WHERE hps.party_id (+) = ipe.person_id ' ||
5728: ' AND hps.identifying_address_flag(+) = ''Y'' ' ||
5728: ' AND hps.identifying_address_flag(+) = ''Y'' ' ||
5729: ' AND ipe.person_number = ''' ||
5730: l_student_number || '''';
5731:
5732: hr_utility.set_location('Dynamic query build ', 40);
5733:
5734: IF (csr_get_party_id%ISOPEN) THEN -- {
5735: CLOSE csr_get_party_id;
5736: END IF; -- }
5738: FETCH csr_get_party_id INTO l_party_id;
5739: CLOSE csr_get_party_id;
5740: END IF; -- }
5741:
5742: hr_utility.set_location('Start of filling person rec ', 50);
5743:
5744: -- ===========================================================================
5745: -- ~ Person Details
5746: -- ===========================================================================
5807: l_per_rec.region_of_birth := p_region_of_birth;
5808: l_per_rec.country_of_birth := p_country_of_birth;
5809: l_per_rec.global_person_id := p_global_person_id;
5810:
5811: hr_utility.set_location('Person Details assigned to record : l_per_rec ',
5812: 60);
5813:
5814: -- Person DF: Customer defined
5815:
5844: l_per_rec.attribute28 := p_per_attribute28;
5845: l_per_rec.attribute29 := p_per_attribute29;
5846: l_per_rec.attribute30 := p_per_attribute30;
5847:
5848: hr_utility.set_location('Person DF assigned to record :l_per_rec ', 70);
5849:
5850: -- Person DDF: Different for each legislation
5851:
5852: IF (csr_style%ISOPEN) THEN -- {
5890: l_per_rec.per_information28 := p_per_information28;
5891: l_per_rec.per_information29 := p_per_information29;
5892: l_per_rec.per_information30 := p_per_information30;
5893:
5894: hr_utility.set_location('Person DDF assigned to record : l_per_rec ', 80);
5895:
5896: -- =======================================================================
5897: -- ~ Person Address Record
5898: -- =======================================================================
5924: l_add_rec.add_information18 := p_add_information18;
5925: l_add_rec.add_information19 := p_add_information19;
5926: l_add_rec.add_information20 := p_add_information20;
5927:
5928: hr_utility.set_location('Address DDF assigned to record, Style: ' ||
5929: p_address_style, 90);
5930: -- Address DF
5931:
5932: l_add_rec.addr_attribute_category := p_adr_attribute_category;
5950: l_add_rec.addr_attribute18 := p_adr_attribute18;
5951: l_add_rec.addr_attribute19 := p_adr_attribute19;
5952: l_add_rec.addr_attribute20 := p_adr_attribute20;
5953:
5954: hr_utility.set_location('Address DF assigned to record, Style: ' ||
5955: p_address_style, 100);
5956: -- ========================================================================
5957: -- ~ Person Primary Assignment
5958: -- ========================================================================
5994: l_asg_rec.labour_union_member_flag := p_labour_union_member_flag;
5995: l_asg_rec.hourly_salaried_code := p_hourly_salaried_code;
5996: l_asg_rec.location_id := p_location_id;
5997:
5998: hr_utility.set_location('Primary Assignment details assigned to ' ||
5999: 'record ', 110);
6000:
6001: -- Additional Assignment Details
6002:
6031: l_asg_rec.ass_attribute28 := p_ass_attribute28;
6032: l_asg_rec.ass_attribute29 := p_ass_attribute29;
6033: l_asg_rec.ass_attribute30 := p_ass_attribute30;
6034:
6035: hr_utility.set_location('Additional Assignment Details assigned to ' ||
6036: 'record ', 120);
6037: -- =======================================================================
6038: -- ~ Contact Details
6039: -- =======================================================================
6041: l_cntct_rec.contact_type := p_contact_type;
6042: l_cntct_rec.primary_contact_flag := p_primary_contact;
6043: l_cntct_rec.personal_flag := p_personal_flag;
6044:
6045: hr_utility.set_location('Contact details assigned to record ', 130);
6046: -- ========================================================================
6047: -- ~ Person Phones
6048: -- ========================================================================
6049: l_phones_rec.phone_type := p_phone_type;
6052: l_phones_rec.date_to := p_phone_date_to;
6053: l_phones_rec.party_id := l_party_id;
6054: l_phones_rec.parent_table := 'PER_ALL_PEOPLE_F';
6055:
6056: hr_utility.set_location('Phone Details assigned to record ', 140);
6057: -- ========================================================================
6058: -- ~ Soft Coding Keyflex field
6059: -- ========================================================================
6060: l_hr_soft_rec.concatenated_segments := p_soft_segments;
6089: l_hr_soft_rec.segment28 := p_soft_segment28;
6090: l_hr_soft_rec.segment29 := p_soft_segment29;
6091: l_hr_soft_rec.segment30 := p_soft_segment30;
6092:
6093: hr_utility.set_location('Soft Coding KFF segments assigned to record: ' ||
6094: 'l_hr_soft_rec ', 150);
6095: -- ========================================================================
6096: -- ~ People Group Keyflex
6097: -- ========================================================================
6161: l_ppl_grp_rec.segment28 := f_formatted_grp_seg_val('p_people_segment28',p_people_segment28);
6162: l_ppl_grp_rec.segment29 := f_formatted_grp_seg_val('p_people_segment29',p_people_segment29);
6163: l_ppl_grp_rec.segment30 := f_formatted_grp_seg_val('p_people_segment30',p_people_segment30);
6164:
6165: hr_utility.set_location('People Grp KFF segments assigned to record: ' ||
6166: 'l_ppl_grp_rec ', 160);
6167:
6168: -- Code handles all the cases if the data coming in is not corrected
6169: -- erronous data pump data, hence not 'DP ERROR'
6168: -- Code handles all the cases if the data coming in is not corrected
6169: -- erronous data pump data, hence not 'DP ERROR'
6170:
6171: IF p_web_adi_identifier <> 'DP ERROR' THEN --{{
6172: hr_utility.set_location('IF <> DP Error ', 170);
6173: IF (chk_party%ISOPEN) THEN -- {
6174: CLOSE chk_party;
6175: END IF; -- }
6176: OPEN chk_party( c_party_id => l_per_rec.party_id
6181: FETCH chk_party INTO l_chk_per;
6182:
6183: IF (chk_party%NOTFOUND) THEN -- {{
6184: -- If person doesn't exist in system then create a new person
6185: hr_utility.set_location(' Creating a new Student Employee', 180);
6186: IF (p_data_pump_flag = 'Y') THEN -- {
6187: hr_utility.set_location('If data pump flag = Y', 190);
6188: -- If person is to be created through Data Pump
6189: hr_datapump(p_data_pump_batch_line_id =>
6183: IF (chk_party%NOTFOUND) THEN -- {{
6184: -- If person doesn't exist in system then create a new person
6185: hr_utility.set_location(' Creating a new Student Employee', 180);
6186: IF (p_data_pump_flag = 'Y') THEN -- {
6187: hr_utility.set_location('If data pump flag = Y', 190);
6188: -- If person is to be created through Data Pump
6189: hr_datapump(p_data_pump_batch_line_id =>
6190: p_data_pump_batch_line_id
6191: , p_batch_id => p_batch_id
6192: , p_contact_name => p_contact_name
6193: , p_adjusted_svc_date => p_adjusted_svc_date
6194: , p_dp_mode => 'INSERT');
6195: ELSE -- }{
6196: hr_utility.set_location('If data pump flag <> Y', 200);
6197: -- Else person is to be created through real-time APIs
6198: -- Create the employee
6199: create_empin_hrms(p_validate => FALSE
6200: ,p_effective_date => l_per_rec.start_date
6210: -- Call Address API only if user has eneterd address details
6211:
6212: IF (p_address_line1 IS NOT NULL AND
6213: l_add_rec.style IS NOT NULL ) THEN -- {
6214: hr_utility.set_location('Address line 1 is filled', 210);
6215:
6216: l_add_rec.date_from := l_per_rec.start_date;
6217: l_add_rec.date_to := Null;
6218: insupd_address(p_effective_date => l_per_rec.start_date
6226: l_asg_rec.assignment_id := l_emp_api_out.assignment_id;
6227: l_asg_rec.object_version_number :=
6228: l_emp_api_out.asg_object_version_number;
6229:
6230: hr_utility.set_location('Updating asg criteria ', 220);
6231: update_stuempasg_criteria(p_effective_date =>
6232: l_per_rec.start_date ,
6233: p_asg_crit_out => l_asg_crit_out);
6234:
6231: update_stuempasg_criteria(p_effective_date =>
6232: l_per_rec.start_date ,
6233: p_asg_crit_out => l_asg_crit_out);
6234:
6235: hr_utility.set_location('Updated asg criteria', 230);
6236:
6237: -- Create Phones record default to H1=Home
6238:
6239: l_phones_rec.parent_id := l_emp_api_out.person_id;
6242: l_cntct_rec.person_id := l_emp_api_out.person_id;
6243: -- Create Contact Type only when Contact Details have been
6244: -- entered
6245: IF l_cntct_rec.contact_type IS NOT NULL THEN -- {
6246: hr_utility.set_location('Contact type is not null', 240);
6247: create_person_contact(p_effective_date=>l_per_rec.start_date
6248: , p_contact_name => p_contact_name
6249: , p_legislation_code => g_leg_code
6250: , p_crt_cntct_out=>l_crt_emp_api_out);
6279: );
6280: END IF;
6281: -- Create People Exra Information
6282: IF l_student_number IS NOT NULL THEN -- {
6283: hr_utility.set_location('Updating Extra Info', 250);
6284: hr_utility.set_location('Error Code ' ||
6285: l_oss_error_code, 255);
6286: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls
6287: (p_business_group_id => l_per_rec.business_group_id
6280: END IF;
6281: -- Create People Exra Information
6282: IF l_student_number IS NOT NULL THEN -- {
6283: hr_utility.set_location('Updating Extra Info', 250);
6284: hr_utility.set_location('Error Code ' ||
6285: l_oss_error_code, 255);
6286: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls
6287: (p_business_group_id => l_per_rec.business_group_id
6288: ,p_person_id => l_per_rec.person_id
6296: ELSIF (l_chk_per.system_person_type) IN ('OTHER' ,
6297: 'EX_EMP' ,
6298: 'EX_APL' ) THEN
6299: -- If the person already exists in the system
6300: hr_utility.set_location(' Current person type: ' ||
6301: l_chk_per.system_person_type, 260);
6302:
6303: --Raise error if contingent worker is being tried to be hired as a student employee
6304: IF l_chk_per.system_person_type ='OTHER' THEN
6322: l_per_rec.party_id := l_party_id;
6323: l_per_rec.person_id := p_dup_person_id;
6324: -- If person is to be re-hired through Data Pump
6325: IF (p_data_pump_flag = 'Y') THEN -- {{
6326: hr_utility.set_location(' Data pump flag = Y' , 270);
6327: l_add_rec.primary_flag := 'Y';
6328: hr_datapump(p_data_pump_batch_line_id =>
6329: p_data_pump_batch_line_id
6330: ,p_batch_id => p_batch_id
6332: ,p_adjusted_svc_date => p_adjusted_svc_date
6333: ,p_dp_mode => 'UPDATE');
6334: ELSE -- }{
6335: -- Else person is to be re-hired through real-time APIs
6336: hr_utility.set_location(' Data pump flag <> Y' , 280);
6337:
6338: hire_person_intoemp(p_validate => FALSE
6339: ,p_hire_date => l_per_rec.start_date
6340: ,p_person_id => p_dup_person_id
6347:
6348: IF (p_address_line1 IS NOT NULL AND
6349: l_add_rec.style IS NOT NULL) THEN -- {
6350: -- Call Address API only if user has eneterd address details
6351: hr_utility.set_location('Address line 1 is not null' , 290);
6352: l_add_rec.date_from := l_per_rec.start_date;
6353: l_add_rec.date_to := NULL;
6354:
6355: InsUpd_Address(p_effective_date => l_per_rec.start_date
6358: l_add_rec.object_version_number);
6359: END IF; -- }
6360: -- Update employee's primary assignment
6361: l_asg_rec.assignment_id := l_HireToJobapi_out.assignment_id;
6362: hr_utility.set_location('Updating Asg criteria' , 300);
6363: Update_StuEmpAsg_Criteria(p_effective_date =>
6364: l_per_rec.start_date
6365: ,p_asg_crit_out => l_asg_crit_out);
6366: hr_utility.set_location('Updated Asg criteria' , 310);
6362: hr_utility.set_location('Updating Asg criteria' , 300);
6363: Update_StuEmpAsg_Criteria(p_effective_date =>
6364: l_per_rec.start_date
6365: ,p_asg_crit_out => l_asg_crit_out);
6366: hr_utility.set_location('Updated Asg criteria' , 310);
6367: -- Create Contact Details
6368: l_cntct_rec.person_id := l_emp_api_out.person_id;
6369: -- Create Contact Type only when Contact Dets have been entered
6370: IF l_cntct_rec.contact_type IS NOT NULL THEN -- {
6367: -- Create Contact Details
6368: l_cntct_rec.person_id := l_emp_api_out.person_id;
6369: -- Create Contact Type only when Contact Dets have been entered
6370: IF l_cntct_rec.contact_type IS NOT NULL THEN -- {
6371: hr_utility.set_location('Updating Contact Details' , 320);
6372: Update_Person_Contact(p_effective_date=>l_per_rec.start_date
6373: ,p_contact_name => p_contact_name
6374: ,p_legislation_code => g_leg_code
6375: ,p_crt_cntct_out => l_crt_emp_api_out);
6404: );
6405: END IF;
6406: IF l_student_number IS NOT NULL THEN -- {
6407: -- Create People Exra Information
6408: hr_utility.set_location('Updating Extra Info' , 330);
6409: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls
6410: (p_business_group_id => l_per_rec.business_group_id
6411: ,p_person_id => l_per_rec.person_id
6412: ,p_party_id => l_per_rec.party_id
6416: END IF; --}
6417: END IF; -- }
6418: ELSIF l_chk_per.system_person_type IN
6419: ('EX_EMP_APL','APL_EX_APL','APL') THEN -- {
6420: hr_utility.set_location('..Applicant being hired as Student' ||
6421: ' Employee', 340);
6422: hr_utility.set_location(' Current person type: ' ||
6423: l_chk_per.system_person_type, 340);
6424: l_per_rec.party_id := l_party_id;
6418: ELSIF l_chk_per.system_person_type IN
6419: ('EX_EMP_APL','APL_EX_APL','APL') THEN -- {
6420: hr_utility.set_location('..Applicant being hired as Student' ||
6421: ' Employee', 340);
6422: hr_utility.set_location(' Current person type: ' ||
6423: l_chk_per.system_person_type, 340);
6424: l_per_rec.party_id := l_party_id;
6425: l_per_rec.person_id := p_dup_person_id;
6426: -- If person is to be re-hired through Data Pump
6424: l_per_rec.party_id := l_party_id;
6425: l_per_rec.person_id := p_dup_person_id;
6426: -- If person is to be re-hired through Data Pump
6427: IF (p_data_pump_flag = 'Y') THEN -- {{
6428: hr_utility.set_location(' Data pump flag = Y' , 350);
6429: l_add_rec.primary_flag := 'Y';
6430: hr_datapump(p_data_pump_batch_line_id =>
6431: p_data_pump_batch_line_id
6432: ,p_batch_id => p_batch_id
6434: ,p_adjusted_svc_date => p_adjusted_svc_date
6435: ,p_dp_mode => 'UPDATE');
6436: ELSE
6437: -- Else person is to be re-hired through real-time APIs
6438: hr_utility.set_location(' Data pump flag <> Y' , 280);
6439: l_per_rec.person_id := l_chk_per.person_id;
6440: l_per_rec.business_group_id := p_business_group_id;
6441: l_per_rec.party_id := l_party_id;
6442: l_effective_date := p_date_of_hire;
6481: -- Create Contact Type only when Contact Details have been entered
6482: l_cntct_rec.person_id := l_emp_api_out.person_id;
6483: -- Create Contact Type only when Contact Dets have been entered
6484: IF l_cntct_rec.contact_type IS NOT NULL THEN
6485: hr_utility.set_location('Updating Contact Details' , 320);
6486: Update_Person_Contact(p_effective_date=>l_per_rec.start_date
6487: ,p_contact_name => p_contact_name
6488: ,p_legislation_code => g_leg_code
6489: ,p_crt_cntct_out => l_crt_emp_api_out);
6486: Update_Person_Contact(p_effective_date=>l_per_rec.start_date
6487: ,p_contact_name => p_contact_name
6488: ,p_legislation_code => g_leg_code
6489: ,p_crt_cntct_out => l_crt_emp_api_out);
6490: hr_utility.set_location('Updated Contact Details' , 320);
6491: END IF;
6492:
6493: -- Create the primary address
6494: l_add_rec.person_id := p_dup_person_id;
6495: l_add_rec.primary_flag := 'Y';
6496: -- Call Address API only if user has eneterd address details
6497: IF (p_address_line1 IS NOT NULL AND
6498: l_add_rec.style IS NOT NULL) THEN
6499: hr_utility.set_location('Address line 1 is not null' , 290);
6500: l_add_rec.date_from := l_per_rec.start_date;
6501: l_add_rec.date_to := NULL;
6502:
6503: hr_utility.set_location(' Updating Person Primary Address ', 150);
6499: hr_utility.set_location('Address line 1 is not null' , 290);
6500: l_add_rec.date_from := l_per_rec.start_date;
6501: l_add_rec.date_to := NULL;
6502:
6503: hr_utility.set_location(' Updating Person Primary Address ', 150);
6504: InsUpd_Address(p_effective_date => l_per_rec.start_date
6505: ,p_HR_address_id => l_add_rec.address_id
6506: ,p_HR_object_version_number =>
6507: l_add_rec.object_version_number);
6504: InsUpd_Address(p_effective_date => l_per_rec.start_date
6505: ,p_HR_address_id => l_add_rec.address_id
6506: ,p_HR_object_version_number =>
6507: l_add_rec.object_version_number);
6508: hr_utility.set_location(' Updated Person Primary Address ', 150);
6509: END IF;
6510:
6511: -- Update employee's primary assignment
6512: hr_utility.set_location('Updating Asg criteria' , 300);
6508: hr_utility.set_location(' Updated Person Primary Address ', 150);
6509: END IF;
6510:
6511: -- Update employee's primary assignment
6512: hr_utility.set_location('Updating Asg criteria' , 300);
6513: Update_StuEmpAsg_Criteria(p_effective_date =>
6514: l_per_rec.start_date
6515: ,p_asg_crit_out => l_asg_crit_out);
6516: hr_utility.set_location('Updated Asg criteria' , 310);
6512: hr_utility.set_location('Updating Asg criteria' , 300);
6513: Update_StuEmpAsg_Criteria(p_effective_date =>
6514: l_per_rec.start_date
6515: ,p_asg_crit_out => l_asg_crit_out);
6516: hr_utility.set_location('Updated Asg criteria' , 310);
6517:
6518: IF g_leg_code = 'US' THEN
6519: -- Get Passport details from OSS
6520: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort
6545: );
6546: END IF;
6547: IF l_student_number IS NOT NULL THEN
6548: -- Create People Exra Information
6549: hr_utility.set_location('Updating Extra Info' , 330);
6550: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls
6551: (p_business_group_id => l_per_rec.business_group_id
6552: ,p_person_id => l_per_rec.person_id
6553: ,p_party_id => l_per_rec.party_id
6553: ,p_party_id => l_per_rec.party_id
6554: ,p_effective_date => l_per_rec.start_date
6555: ,p_oss_error_code => l_oss_error_code
6556: ,p_ossDtls_warning => l_ossDtls_warning);
6557: hr_utility.set_location('Updated Extra Info' , 330);
6558: END IF;
6559: hr_utility.set_location(' Updated Passport, Visa, Visit History' ||
6560: ' details: ', 160);
6561: END IF;
6555: ,p_oss_error_code => l_oss_error_code
6556: ,p_ossDtls_warning => l_ossDtls_warning);
6557: hr_utility.set_location('Updated Extra Info' , 330);
6558: END IF;
6559: hr_utility.set_location(' Updated Passport, Visa, Visit History' ||
6560: ' details: ', 160);
6561: END IF;
6562:
6563: ELSIF l_chk_per.system_person_type IN ('EMP','EMP_APL') THEN
6562:
6563: ELSIF l_chk_per.system_person_type IN ('EMP','EMP_APL') THEN
6564:
6565: -- If the person already exists in the system {
6566: hr_utility.set_location(' Current person type: ' ||
6567: l_chk_per.system_person_type, 260);
6568: -- Hire the existing person
6569: l_per_rec.party_id := l_party_id;
6570: l_per_rec.person_id := p_dup_person_id;
6569: l_per_rec.party_id := l_party_id;
6570: l_per_rec.person_id := p_dup_person_id;
6571: -- If person is to be re-hired through Data Pump
6572: IF (p_data_pump_flag = 'Y') THEN -- {{
6573: hr_utility.set_location(' Data pump flag = Y' , 270);
6574: l_add_rec.primary_flag := 'Y';
6575: hr_datapump(p_data_pump_batch_line_id =>
6576: p_data_pump_batch_line_id
6577: ,p_batch_id => p_batch_id
6579: ,p_adjusted_svc_date => p_adjusted_svc_date
6580: ,p_dp_mode => 'UPDATE');
6581: ELSE -- }{
6582: -- Else person is to be re-hired through real-time APIs
6583: hr_utility.set_location(' Data pump flag <> Y' , 280);
6584:
6585: hr_utility.set_location(' Updating person details ', 180);
6586: Upd_OSS_Person
6587: (p_validate => FALSE
6581: ELSE -- }{
6582: -- Else person is to be re-hired through real-time APIs
6583: hr_utility.set_location(' Data pump flag <> Y' , 280);
6584:
6585: hr_utility.set_location(' Updating person details ', 180);
6586: Upd_OSS_Person
6587: (p_validate => FALSE
6588: ,p_effective_date => l_per_rec.start_date
6589: ,p_person_id => l_per_rec.person_id
6589: ,p_person_id => l_per_rec.person_id
6590: ,p_adjusted_svc_date => p_adjusted_svc_date
6591: ,p_updper_api_out => l_updper_api_out
6592: );
6593: hr_utility.set_location(' Updated person details ', 180);
6594:
6595: -- Call the Address API only if user has eneterd the address details
6596: IF (p_address_line1 IS NOT NULL AND
6597: l_add_rec.style IS NOT NULL) THEN
6594:
6595: -- Call the Address API only if user has eneterd the address details
6596: IF (p_address_line1 IS NOT NULL AND
6597: l_add_rec.style IS NOT NULL) THEN
6598: hr_utility.set_location('Address line 1 is not null' , 290);
6599: l_add_rec.person_id := p_dup_person_id;
6600: l_add_rec.primary_flag := 'Y';
6601: l_add_rec.date_from := l_per_rec.start_date;
6602: l_add_rec.date_to := NULL;
6619: CLOSE get_dup_asg_id;
6620:
6621: -- Update employee's primary assignment
6622: l_asg_rec.assignment_id := l_dup_asg_id;
6623: hr_utility.set_location('Updating Asg criteria' , 300);
6624: Update_StuEmpAsg_Criteria(p_effective_date =>
6625: l_per_rec.start_date
6626: ,p_asg_crit_out => l_asg_crit_out);
6627: hr_utility.set_location('Updated Asg criteria' , 310);
6623: hr_utility.set_location('Updating Asg criteria' , 300);
6624: Update_StuEmpAsg_Criteria(p_effective_date =>
6625: l_per_rec.start_date
6626: ,p_asg_crit_out => l_asg_crit_out);
6627: hr_utility.set_location('Updated Asg criteria' , 310);
6628:
6629: IF g_leg_code = 'US' THEN
6630: -- Get Passport details from OSS
6631: Pqp_Hrtca_Integration.InsUpd_InHR_PassPort
6656: );
6657: END IF;
6658: IF l_student_number IS NOT NULL THEN -- {
6659: -- Create People Exra Information
6660: hr_utility.set_location('Updating Extra Info' , 330);
6661: Pqp_Hrtca_Integration.InsUpd_InHR_OSSPerDtls
6662: (p_business_group_id => l_per_rec.business_group_id
6663: ,p_person_id => l_per_rec.person_id
6664: ,p_party_id => l_per_rec.party_id
6683: , p_contact_name => p_contact_name
6684: , p_adjusted_svc_date => p_adjusted_svc_date);
6685:
6686: END IF; -- }}
6687: hr_utility.set_location('Leaving: ' || l_proc_name, 350);
6688:
6689: EXCEPTION
6690: WHEN e_active_cwk THEN
6691: CLOSE chk_party;
6689: EXCEPTION
6690: WHEN e_active_cwk THEN
6691: CLOSE chk_party;
6692: ROLLBACK TO create_student_employee;
6693: hr_utility.set_location('..CWK being hired as Student Employee', 360);
6694: hr_utility.set_message(8303, 'PQP_230216_HROSS_ACTIVE_CTW');
6695: hr_utility.set_location('Leaving: ' || l_proc_name, 360);
6696: hr_utility.raise_error;
6697:
6690: WHEN e_active_cwk THEN
6691: CLOSE chk_party;
6692: ROLLBACK TO create_student_employee;
6693: hr_utility.set_location('..CWK being hired as Student Employee', 360);
6694: hr_utility.set_message(8303, 'PQP_230216_HROSS_ACTIVE_CTW');
6695: hr_utility.set_location('Leaving: ' || l_proc_name, 360);
6696: hr_utility.raise_error;
6697:
6698: WHEN Others THEN
6691: CLOSE chk_party;
6692: ROLLBACK TO create_student_employee;
6693: hr_utility.set_location('..CWK being hired as Student Employee', 360);
6694: hr_utility.set_message(8303, 'PQP_230216_HROSS_ACTIVE_CTW');
6695: hr_utility.set_location('Leaving: ' || l_proc_name, 360);
6696: hr_utility.raise_error;
6697:
6698: WHEN Others THEN
6699: CLOSE chk_party;
6692: ROLLBACK TO create_student_employee;
6693: hr_utility.set_location('..CWK being hired as Student Employee', 360);
6694: hr_utility.set_message(8303, 'PQP_230216_HROSS_ACTIVE_CTW');
6695: hr_utility.set_location('Leaving: ' || l_proc_name, 360);
6696: hr_utility.raise_error;
6697:
6698: WHEN Others THEN
6699: CLOSE chk_party;
6700: ROLLBACK TO create_student_employee;
6697:
6698: WHEN Others THEN
6699: CLOSE chk_party;
6700: ROLLBACK TO create_student_employee;
6701: hr_utility.raise_error;
6702:
6703: END Create_Student_Employee;
6704:
6705: -- =============================================================================
6719: l_proc_name CONSTANT Varchar2(150):= g_pkg ||
6720: 'Create_BatchHdr_For_DataPump';
6721:
6722: BEGIN
6723: hr_utility.set_location('Entering: ' || l_proc_name, 10);
6724:
6725: SELECT hr_pump_batch_headers_s.nextval
6726: INTO p_batch_process_id
6727: FROM dual;
6741: ,p_batch_process_name
6742: ,'U'
6743: ,l_bg_name);
6744:
6745: hr_utility.set_location('Leaving: ' || l_proc_name, 20);
6746:
6747: END Create_BatchHdr_For_DataPump;
6748:
6749: -- =============================================================================
6967: e_active_cwk Exception;
6968:
6969: BEGIN
6970: SAVEPOINT create_upd_person;
6971: g_debug_on := hr_utility.debug_enabled;
6972:
6973: hr_utility.set_location('Entering: ' || l_proc_name, 10);
6974:
6975: IF g_debug_on THEN
6969: BEGIN
6970: SAVEPOINT create_upd_person;
6971: g_debug_on := hr_utility.debug_enabled;
6972:
6973: hr_utility.set_location('Entering: ' || l_proc_name, 10);
6974:
6975: IF g_debug_on THEN
6976: hr_utility.set_location('..p_business_group_id :' || p_business_group_id,20);
6977: hr_utility.set_location('..p_dup_person_id :' || p_dup_person_id,20);
6972:
6973: hr_utility.set_location('Entering: ' || l_proc_name, 10);
6974:
6975: IF g_debug_on THEN
6976: hr_utility.set_location('..p_business_group_id :' || p_business_group_id,20);
6977: hr_utility.set_location('..p_dup_person_id :' || p_dup_person_id,20);
6978: hr_utility.set_location('..p_party_id :' || p_party_id,20);
6979: hr_utility.set_location('..p_last_name :' || p_last_name,20);
6980: hr_utility.set_location('..p_marital_status :' || p_marital_status,20);
6973: hr_utility.set_location('Entering: ' || l_proc_name, 10);
6974:
6975: IF g_debug_on THEN
6976: hr_utility.set_location('..p_business_group_id :' || p_business_group_id,20);
6977: hr_utility.set_location('..p_dup_person_id :' || p_dup_person_id,20);
6978: hr_utility.set_location('..p_party_id :' || p_party_id,20);
6979: hr_utility.set_location('..p_last_name :' || p_last_name,20);
6980: hr_utility.set_location('..p_marital_status :' || p_marital_status,20);
6981: hr_utility.set_location('..p_sex :' || p_sex,20);
6974:
6975: IF g_debug_on THEN
6976: hr_utility.set_location('..p_business_group_id :' || p_business_group_id,20);
6977: hr_utility.set_location('..p_dup_person_id :' || p_dup_person_id,20);
6978: hr_utility.set_location('..p_party_id :' || p_party_id,20);
6979: hr_utility.set_location('..p_last_name :' || p_last_name,20);
6980: hr_utility.set_location('..p_marital_status :' || p_marital_status,20);
6981: hr_utility.set_location('..p_sex :' || p_sex,20);
6982: hr_utility.set_location('..p_date_of_birth :' || p_date_of_birth,20);
6975: IF g_debug_on THEN
6976: hr_utility.set_location('..p_business_group_id :' || p_business_group_id,20);
6977: hr_utility.set_location('..p_dup_person_id :' || p_dup_person_id,20);
6978: hr_utility.set_location('..p_party_id :' || p_party_id,20);
6979: hr_utility.set_location('..p_last_name :' || p_last_name,20);
6980: hr_utility.set_location('..p_marital_status :' || p_marital_status,20);
6981: hr_utility.set_location('..p_sex :' || p_sex,20);
6982: hr_utility.set_location('..p_date_of_birth :' || p_date_of_birth,20);
6983: hr_utility.set_location('..p_date_of_hire :' || p_date_of_hire,20);
6976: hr_utility.set_location('..p_business_group_id :' || p_business_group_id,20);
6977: hr_utility.set_location('..p_dup_person_id :' || p_dup_person_id,20);
6978: hr_utility.set_location('..p_party_id :' || p_party_id,20);
6979: hr_utility.set_location('..p_last_name :' || p_last_name,20);
6980: hr_utility.set_location('..p_marital_status :' || p_marital_status,20);
6981: hr_utility.set_location('..p_sex :' || p_sex,20);
6982: hr_utility.set_location('..p_date_of_birth :' || p_date_of_birth,20);
6983: hr_utility.set_location('..p_date_of_hire :' || p_date_of_hire,20);
6984: hr_utility.set_location('..p_employee_number :' || p_employee_number,20);
6977: hr_utility.set_location('..p_dup_person_id :' || p_dup_person_id,20);
6978: hr_utility.set_location('..p_party_id :' || p_party_id,20);
6979: hr_utility.set_location('..p_last_name :' || p_last_name,20);
6980: hr_utility.set_location('..p_marital_status :' || p_marital_status,20);
6981: hr_utility.set_location('..p_sex :' || p_sex,20);
6982: hr_utility.set_location('..p_date_of_birth :' || p_date_of_birth,20);
6983: hr_utility.set_location('..p_date_of_hire :' || p_date_of_hire,20);
6984: hr_utility.set_location('..p_employee_number :' || p_employee_number,20);
6985: hr_utility.set_location('..p_person_type_id :' || p_person_type_id,20);
6978: hr_utility.set_location('..p_party_id :' || p_party_id,20);
6979: hr_utility.set_location('..p_last_name :' || p_last_name,20);
6980: hr_utility.set_location('..p_marital_status :' || p_marital_status,20);
6981: hr_utility.set_location('..p_sex :' || p_sex,20);
6982: hr_utility.set_location('..p_date_of_birth :' || p_date_of_birth,20);
6983: hr_utility.set_location('..p_date_of_hire :' || p_date_of_hire,20);
6984: hr_utility.set_location('..p_employee_number :' || p_employee_number,20);
6985: hr_utility.set_location('..p_person_type_id :' || p_person_type_id,20);
6986: hr_utility.set_location('..p_effective_date :' || p_effective_date,20);
6979: hr_utility.set_location('..p_last_name :' || p_last_name,20);
6980: hr_utility.set_location('..p_marital_status :' || p_marital_status,20);
6981: hr_utility.set_location('..p_sex :' || p_sex,20);
6982: hr_utility.set_location('..p_date_of_birth :' || p_date_of_birth,20);
6983: hr_utility.set_location('..p_date_of_hire :' || p_date_of_hire,20);
6984: hr_utility.set_location('..p_employee_number :' || p_employee_number,20);
6985: hr_utility.set_location('..p_person_type_id :' || p_person_type_id,20);
6986: hr_utility.set_location('..p_effective_date :' || p_effective_date,20);
6987: END IF;
6980: hr_utility.set_location('..p_marital_status :' || p_marital_status,20);
6981: hr_utility.set_location('..p_sex :' || p_sex,20);
6982: hr_utility.set_location('..p_date_of_birth :' || p_date_of_birth,20);
6983: hr_utility.set_location('..p_date_of_hire :' || p_date_of_hire,20);
6984: hr_utility.set_location('..p_employee_number :' || p_employee_number,20);
6985: hr_utility.set_location('..p_person_type_id :' || p_person_type_id,20);
6986: hr_utility.set_location('..p_effective_date :' || p_effective_date,20);
6987: END IF;
6988:
6981: hr_utility.set_location('..p_sex :' || p_sex,20);
6982: hr_utility.set_location('..p_date_of_birth :' || p_date_of_birth,20);
6983: hr_utility.set_location('..p_date_of_hire :' || p_date_of_hire,20);
6984: hr_utility.set_location('..p_employee_number :' || p_employee_number,20);
6985: hr_utility.set_location('..p_person_type_id :' || p_person_type_id,20);
6986: hr_utility.set_location('..p_effective_date :' || p_effective_date,20);
6987: END IF;
6988:
6989: l_per_rec := NULL;
6982: hr_utility.set_location('..p_date_of_birth :' || p_date_of_birth,20);
6983: hr_utility.set_location('..p_date_of_hire :' || p_date_of_hire,20);
6984: hr_utility.set_location('..p_employee_number :' || p_employee_number,20);
6985: hr_utility.set_location('..p_person_type_id :' || p_person_type_id,20);
6986: hr_utility.set_location('..p_effective_date :' || p_effective_date,20);
6987: END IF;
6988:
6989: l_per_rec := NULL;
6990: l_hr_soft_rec := NULL;
7066: l_per_rec.region_of_birth := p_region_of_birth;
7067: l_per_rec.country_of_birth := p_country_of_birth;
7068: l_per_rec.global_person_id := p_global_person_id;
7069:
7070: hr_utility.set_location('Person Details assigned to record :l_per_rec ', 30);
7071:
7072: -- Person DF: Customer defined
7073: l_per_rec.attribute_category := p_per_attribute_category;
7074: l_per_rec.attribute1 := p_per_attribute1;
7101: l_per_rec.attribute28 := p_per_attribute28;
7102: l_per_rec.attribute29 := p_per_attribute29;
7103: l_per_rec.attribute30 := p_per_attribute30;
7104:
7105: hr_utility.set_location('Person DF assigned to record :l_per_rec ', 40);
7106:
7107: -- Person DDF: Different for each legislation
7108: OPEN csr_style (c_context_code => g_leg_code);
7109: FETCH csr_style INTO l_dff_ctx;
7142: l_per_rec.per_information28 := p_per_information28;
7143: l_per_rec.per_information29 := p_per_information29;
7144: l_per_rec.per_information30 := p_per_information30;
7145:
7146: hr_utility.set_location('Person DDF assigned to record :l_per_rec ', 50);
7147:
7148: -- ===========================================================================
7149: -- ~ Person Address Record
7150: -- ===========================================================================
7175: l_add_rec.add_information18 := p_add_information18;
7176: l_add_rec.add_information19 := p_add_information19;
7177: l_add_rec.add_information20 := p_add_information20;
7178:
7179: hr_utility.set_location('Address DDF assigned to record, Style: ' ||
7180: p_address_style, 60);
7181:
7182: -- Address DF
7183: l_add_rec.addr_attribute_category := p_adr_attribute_category;
7201: l_add_rec.addr_attribute18 := p_adr_attribute18;
7202: l_add_rec.addr_attribute19 := p_adr_attribute19;
7203: l_add_rec.addr_attribute20 := p_adr_attribute20;
7204:
7205: hr_utility.set_location('Address DF assigned to record, Style: ' ||
7206: p_address_style, 70);
7207:
7208: OPEN chk_party (c_party_id => l_per_rec.party_id
7209: ,c_bg_grp_id => l_per_rec.business_group_id
7211: ,c_effective_date => l_effective_date
7212: );
7213: FETCH chk_party INTO l_chk_per;
7214: IF chk_party%NOTFOUND THEN
7215: hr_utility.set_location(' Creating a new Student Employee', 80);
7216: -- Create the employee
7217: l_effective_date := p_date_of_hire;
7218: l_per_rec.start_date := l_effective_date;
7219:
7227:
7228: -- Create the primary address
7229: l_add_rec.person_id := l_emp_api_out.person_id;
7230: l_add_rec.primary_flag := 'Y';
7231: hr_utility.set_location(' Creating Primary Address', 90);
7232: -- Call the Address API only if user has eneterd the address details
7233: IF p_address_line1 IS NOT NULL AND
7234: l_add_rec.style IS NOT NULL THEN
7235:
7243: );
7244: END IF;
7245:
7246: -- Create Phones record default to H1=Home
7247: hr_utility.set_location(' Creating Phones record', 100);
7248: l_phones_rec.parent_id := l_emp_api_out.person_id;
7249: l_phones_rec.date_from := l_effective_date;
7250:
7251: -- Create Contact Details
7249: l_phones_rec.date_from := l_effective_date;
7250:
7251: -- Create Contact Details
7252: l_cntct_rec.person_id := l_emp_api_out.person_id;
7253: hr_utility.set_location(' Creating Contact details', 110);
7254:
7255: -- Create Contact Type only when Contact Details have been entered
7256: IF l_cntct_rec.contact_type IS NOT NULL THEN
7257: Create_Person_Contact
7303:
7304: ELSIF l_chk_per.system_person_type IN
7305: ('OTHER','EX_EMP','EX_APL') THEN
7306:
7307: hr_utility.set_location(' Current person type: ' ||
7308: l_chk_per.system_person_type, 120);
7309: -- Hire the existing person
7310: l_per_rec.person_id := l_chk_per.person_id;
7311: l_per_rec.business_group_id := p_business_group_id;
7410:
7411:
7412: ELSIF l_chk_per.system_person_type IN
7413: ('EX_EMP_APL','APL_EX_APL','APL') THEN
7414: hr_utility.set_location(' Current person type: ' ||
7415: l_chk_per.system_person_type, 130);
7416: hr_utility.set_location('..Applicant being hired as Student' ||
7417: ' Employee', 130);
7418:
7412: ELSIF l_chk_per.system_person_type IN
7413: ('EX_EMP_APL','APL_EX_APL','APL') THEN
7414: hr_utility.set_location(' Current person type: ' ||
7415: l_chk_per.system_person_type, 130);
7416: hr_utility.set_location('..Applicant being hired as Student' ||
7417: ' Employee', 130);
7418:
7419: l_per_rec.person_id := l_chk_per.person_id;
7420: l_per_rec.business_group_id := p_business_group_id;
7456: ,p_legislation_code => g_leg_code
7457: ,p_crt_cntct_out => l_crt_emp_api_out
7458: );
7459: END IF;
7460: hr_utility.set_location(' Updated person details ', 140);
7461: -- Call the Address API only if user has eneterd the address details
7462: IF p_address_line1 IS NOT NULL AND
7463:
7464: l_add_rec.style IS NOT NULL THEN
7469:
7470: l_add_rec.date_from := l_effective_date;
7471: l_add_rec.date_to := NULL;
7472:
7473: hr_utility.set_location(' Updating Person Primary Address ', 150);
7474: InsUpd_Address
7475: (p_effective_date => l_effective_date
7476: ,p_HR_address_id => l_add_rec.address_id
7477: ,p_HR_object_version_number => l_add_rec.object_version_number
7518: ,p_oss_error_code => l_oss_error_code
7519: ,p_ossDtls_warning => l_ossDtls_warning
7520: );
7521:
7522: hr_utility.set_location(' Updated Passport, Visa, Visit History' ||
7523: ' details: ', 160);
7524:
7525: ELSIF l_chk_per.system_person_type IN ('EMP','EMP_APL') THEN
7526:
7523: ' details: ', 160);
7524:
7525: ELSIF l_chk_per.system_person_type IN ('EMP','EMP_APL') THEN
7526:
7527: hr_utility.set_location(' Current person type: ' ||
7528: l_chk_per.system_person_type, 170);
7529:
7530: l_per_rec.person_id := l_chk_per.person_id;
7531: l_per_rec.business_group_id := p_business_group_id;
7539: ,p_adjusted_svc_date => p_adjusted_svc_date
7540: ,p_updper_api_out => l_updper_api_out
7541: );
7542:
7543: hr_utility.set_location(' Updated person details ', 180);
7544:
7545: -- Call the Address API only if user has eneterd the address details
7546: IF p_address_line1 IS NOT NULL AND
7547:
7552:
7553: l_add_rec.date_from := l_effective_date;
7554: l_add_rec.date_to := NULL;
7555:
7556: hr_utility.set_location(' Updating Person Primary Address ', 190);
7557: InsUpd_Address
7558: (p_effective_date => l_effective_date
7559: ,p_HR_address_id => l_add_rec.address_id
7560: ,p_HR_object_version_number => l_add_rec.object_version_number
7603: ,p_ossDtls_warning => l_ossDtls_warning
7604: );
7605: END IF;
7606:
7607: hr_utility.set_location(' Updated Passport, Visa, Visit History' ||
7608: ' details: ', 200);
7609:
7610: END IF;
7611: CLOSE chk_party;
7609:
7610: END IF;
7611: CLOSE chk_party;
7612:
7613: hr_utility.set_location('Leaving: ' || l_proc_name, 210);
7614:
7615: EXCEPTION
7616: WHEN e_active_cwk THEN
7617: CLOSE chk_party;
7620: 'Student Employee';
7621: l_error_message:= l_per_rec.first_name ||' '||l_per_rec.last_name ||': '||
7622: l_error_message;
7623: l_error_message := Replace(l_error_message,'ORA-20001:',' ');
7624: hr_utility.set_location('..CWK being hired as Student Employee', 220);
7625: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7626: hr_utility.set_message_token('GENERIC_TOKEN',l_error_message );
7627: hr_utility.set_location('Leaving: ' || l_proc_name, 220);
7628: hr_utility.raise_error;
7621: l_error_message:= l_per_rec.first_name ||' '||l_per_rec.last_name ||': '||
7622: l_error_message;
7623: l_error_message := Replace(l_error_message,'ORA-20001:',' ');
7624: hr_utility.set_location('..CWK being hired as Student Employee', 220);
7625: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7626: hr_utility.set_message_token('GENERIC_TOKEN',l_error_message );
7627: hr_utility.set_location('Leaving: ' || l_proc_name, 220);
7628: hr_utility.raise_error;
7629:
7622: l_error_message;
7623: l_error_message := Replace(l_error_message,'ORA-20001:',' ');
7624: hr_utility.set_location('..CWK being hired as Student Employee', 220);
7625: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7626: hr_utility.set_message_token('GENERIC_TOKEN',l_error_message );
7627: hr_utility.set_location('Leaving: ' || l_proc_name, 220);
7628: hr_utility.raise_error;
7629:
7630: WHEN Others THEN
7623: l_error_message := Replace(l_error_message,'ORA-20001:',' ');
7624: hr_utility.set_location('..CWK being hired as Student Employee', 220);
7625: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7626: hr_utility.set_message_token('GENERIC_TOKEN',l_error_message );
7627: hr_utility.set_location('Leaving: ' || l_proc_name, 220);
7628: hr_utility.raise_error;
7629:
7630: WHEN Others THEN
7631: CLOSE chk_party;
7624: hr_utility.set_location('..CWK being hired as Student Employee', 220);
7625: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7626: hr_utility.set_message_token('GENERIC_TOKEN',l_error_message );
7627: hr_utility.set_location('Leaving: ' || l_proc_name, 220);
7628: hr_utility.raise_error;
7629:
7630: WHEN Others THEN
7631: CLOSE chk_party;
7632: ROLLBACK TO create_upd_person;
7629:
7630: WHEN Others THEN
7631: CLOSE chk_party;
7632: ROLLBACK TO create_upd_person;
7633: hr_utility.set_location('SQLCODE :' || SQLCODE, 230);
7634: l_error_message := SQLERRM;
7635: l_error_message:= l_per_rec.first_name ||' '||l_per_rec.last_name|| ': '||
7636: l_error_message;
7637: l_error_message := Replace(l_error_message,'ORA-20001:',' ');
7634: l_error_message := SQLERRM;
7635: l_error_message:= l_per_rec.first_name ||' '||l_per_rec.last_name|| ': '||
7636: l_error_message;
7637: l_error_message := Replace(l_error_message,'ORA-20001:',' ');
7638: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7639: hr_utility.set_message_token('GENERIC_TOKEN',l_error_message );
7640: hr_utility.set_location('Leaving: ' || l_proc_name, 230);
7641: hr_utility.raise_error;
7642:
7635: l_error_message:= l_per_rec.first_name ||' '||l_per_rec.last_name|| ': '||
7636: l_error_message;
7637: l_error_message := Replace(l_error_message,'ORA-20001:',' ');
7638: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7639: hr_utility.set_message_token('GENERIC_TOKEN',l_error_message );
7640: hr_utility.set_location('Leaving: ' || l_proc_name, 230);
7641: hr_utility.raise_error;
7642:
7643: END Create_OSS_Person;
7636: l_error_message;
7637: l_error_message := Replace(l_error_message,'ORA-20001:',' ');
7638: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7639: hr_utility.set_message_token('GENERIC_TOKEN',l_error_message );
7640: hr_utility.set_location('Leaving: ' || l_proc_name, 230);
7641: hr_utility.raise_error;
7642:
7643: END Create_OSS_Person;
7644:
7637: l_error_message := Replace(l_error_message,'ORA-20001:',' ');
7638: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
7639: hr_utility.set_message_token('GENERIC_TOKEN',l_error_message );
7640: hr_utility.set_location('Leaving: ' || l_proc_name, 230);
7641: hr_utility.raise_error;
7642:
7643: END Create_OSS_Person;
7644:
7645: -- =============================================================================
7828: l_asg_crit_out t_AsgUpdCrit_Api;
7829: l_error_msg Varchar2(2000);
7830: l_FICA_exempt Varchar2(5);
7831: BEGIN
7832: g_debug_on := hr_utility.debug_enabled;
7833: hr_utility.set_location('Entering: ' || l_proc_name,10);
7834: -- Get Bus. Group Id in a pkg global variable
7835: OPEN csr_bg_code (c_bg_grp_id => p_business_group_id);
7836: FETCH csr_bg_code INTO g_leg_code,g_emp_num_gen;
7829: l_error_msg Varchar2(2000);
7830: l_FICA_exempt Varchar2(5);
7831: BEGIN
7832: g_debug_on := hr_utility.debug_enabled;
7833: hr_utility.set_location('Entering: ' || l_proc_name,10);
7834: -- Get Bus. Group Id in a pkg global variable
7835: OPEN csr_bg_code (c_bg_grp_id => p_business_group_id);
7836: FETCH csr_bg_code INTO g_leg_code,g_emp_num_gen;
7837: CLOSE csr_bg_code;
7840: ELSE
7841: l_FICA_exempt := p_FICA_exempt;
7842: END IF;
7843: IF g_debug_on THEN
7844: hr_utility.set_location('..p_business_group_id :' || p_business_group_id, 20);
7845: hr_utility.set_location('..p_assignment_id :' || p_assignment_id ,20);
7846: hr_utility.set_location('..p_organization_id :' || p_organization_id ,20);
7847: hr_utility.set_location('..p_job_id :' || p_job_id ,20);
7848: hr_utility.set_location('..p_pay_basis_id :' || p_pay_basis_id ,20);
7841: l_FICA_exempt := p_FICA_exempt;
7842: END IF;
7843: IF g_debug_on THEN
7844: hr_utility.set_location('..p_business_group_id :' || p_business_group_id, 20);
7845: hr_utility.set_location('..p_assignment_id :' || p_assignment_id ,20);
7846: hr_utility.set_location('..p_organization_id :' || p_organization_id ,20);
7847: hr_utility.set_location('..p_job_id :' || p_job_id ,20);
7848: hr_utility.set_location('..p_pay_basis_id :' || p_pay_basis_id ,20);
7849: hr_utility.set_location('..p_grade_id :' || p_grade_id ,20);
7842: END IF;
7843: IF g_debug_on THEN
7844: hr_utility.set_location('..p_business_group_id :' || p_business_group_id, 20);
7845: hr_utility.set_location('..p_assignment_id :' || p_assignment_id ,20);
7846: hr_utility.set_location('..p_organization_id :' || p_organization_id ,20);
7847: hr_utility.set_location('..p_job_id :' || p_job_id ,20);
7848: hr_utility.set_location('..p_pay_basis_id :' || p_pay_basis_id ,20);
7849: hr_utility.set_location('..p_grade_id :' || p_grade_id ,20);
7850: hr_utility.set_location('..p_position_id :' || p_position_id ,20);
7843: IF g_debug_on THEN
7844: hr_utility.set_location('..p_business_group_id :' || p_business_group_id, 20);
7845: hr_utility.set_location('..p_assignment_id :' || p_assignment_id ,20);
7846: hr_utility.set_location('..p_organization_id :' || p_organization_id ,20);
7847: hr_utility.set_location('..p_job_id :' || p_job_id ,20);
7848: hr_utility.set_location('..p_pay_basis_id :' || p_pay_basis_id ,20);
7849: hr_utility.set_location('..p_grade_id :' || p_grade_id ,20);
7850: hr_utility.set_location('..p_position_id :' || p_position_id ,20);
7851: hr_utility.set_location('..p_payroll_id :' || p_payroll_id ,20);
7844: hr_utility.set_location('..p_business_group_id :' || p_business_group_id, 20);
7845: hr_utility.set_location('..p_assignment_id :' || p_assignment_id ,20);
7846: hr_utility.set_location('..p_organization_id :' || p_organization_id ,20);
7847: hr_utility.set_location('..p_job_id :' || p_job_id ,20);
7848: hr_utility.set_location('..p_pay_basis_id :' || p_pay_basis_id ,20);
7849: hr_utility.set_location('..p_grade_id :' || p_grade_id ,20);
7850: hr_utility.set_location('..p_position_id :' || p_position_id ,20);
7851: hr_utility.set_location('..p_payroll_id :' || p_payroll_id ,20);
7852: hr_utility.set_location('..p_effective_date :' || p_effective_date ,20);
7845: hr_utility.set_location('..p_assignment_id :' || p_assignment_id ,20);
7846: hr_utility.set_location('..p_organization_id :' || p_organization_id ,20);
7847: hr_utility.set_location('..p_job_id :' || p_job_id ,20);
7848: hr_utility.set_location('..p_pay_basis_id :' || p_pay_basis_id ,20);
7849: hr_utility.set_location('..p_grade_id :' || p_grade_id ,20);
7850: hr_utility.set_location('..p_position_id :' || p_position_id ,20);
7851: hr_utility.set_location('..p_payroll_id :' || p_payroll_id ,20);
7852: hr_utility.set_location('..p_effective_date :' || p_effective_date ,20);
7853: END IF;
7846: hr_utility.set_location('..p_organization_id :' || p_organization_id ,20);
7847: hr_utility.set_location('..p_job_id :' || p_job_id ,20);
7848: hr_utility.set_location('..p_pay_basis_id :' || p_pay_basis_id ,20);
7849: hr_utility.set_location('..p_grade_id :' || p_grade_id ,20);
7850: hr_utility.set_location('..p_position_id :' || p_position_id ,20);
7851: hr_utility.set_location('..p_payroll_id :' || p_payroll_id ,20);
7852: hr_utility.set_location('..p_effective_date :' || p_effective_date ,20);
7853: END IF;
7854:
7847: hr_utility.set_location('..p_job_id :' || p_job_id ,20);
7848: hr_utility.set_location('..p_pay_basis_id :' || p_pay_basis_id ,20);
7849: hr_utility.set_location('..p_grade_id :' || p_grade_id ,20);
7850: hr_utility.set_location('..p_position_id :' || p_position_id ,20);
7851: hr_utility.set_location('..p_payroll_id :' || p_payroll_id ,20);
7852: hr_utility.set_location('..p_effective_date :' || p_effective_date ,20);
7853: END IF;
7854:
7855: -- ===========================================================================
7848: hr_utility.set_location('..p_pay_basis_id :' || p_pay_basis_id ,20);
7849: hr_utility.set_location('..p_grade_id :' || p_grade_id ,20);
7850: hr_utility.set_location('..p_position_id :' || p_position_id ,20);
7851: hr_utility.set_location('..p_payroll_id :' || p_payroll_id ,20);
7852: hr_utility.set_location('..p_effective_date :' || p_effective_date ,20);
7853: END IF;
7854:
7855: -- ===========================================================================
7856: -- ~ Person Primary Assignment
7893: l_asg_rec.labour_union_member_flag := p_labour_union_member_flag;
7894: l_asg_rec.hourly_salaried_code := p_hourly_salaried_code;
7895: l_asg_rec.location_id := p_location_id;
7896:
7897: hr_utility.set_location('Person Primary Assignment segments assigned to ' ||
7898: 'record: l_asg_rec ', 30);
7899: -- Additional Assignment Details
7900: l_asg_rec.ass_attribute_category := p_ass_attribute_category;
7901: l_asg_rec.ass_attribute1 := p_ass_attribute1;
7928: l_asg_rec.ass_attribute28 := p_ass_attribute28;
7929: l_asg_rec.ass_attribute29 := p_ass_attribute29;
7930: l_asg_rec.ass_attribute30 := p_ass_attribute30;
7931:
7932: hr_utility.set_location('Additional Assignment Details assigned to ' ||
7933: 'record: l_asg_rec ', 40);
7934:
7935: -- ===========================================================================
7936: -- ~ Soft Coding Keyflex field
7967: l_hr_soft_rec.segment28 := p_scl_segment28;
7968: l_hr_soft_rec.segment29 := p_scl_segment29;
7969: l_hr_soft_rec.segment30 := p_scl_segment30;
7970:
7971: hr_utility.set_location('Soft Coding KFF segments assigned to record: ' ||
7972: 'l_hr_soft_rec ', 50);
7973:
7974: -- ===========================================================================
7975: -- ~ People Group Keyflex
8006: l_ppl_grp_rec.segment28 := p_pgrp_segment28;
8007: l_ppl_grp_rec.segment29 := p_pgrp_segment29;
8008: l_ppl_grp_rec.segment30 := p_pgrp_segment30;
8009:
8010: hr_utility.set_location('People Grp KFF segments assigned to record: ' ||
8011: 'l_ppl_grp_rec ', 60);
8012:
8013: Update_StuEmpAsg_Criteria
8014: (p_effective_date => p_effective_date
8014: (p_effective_date => p_effective_date
8015: ,p_asg_crit_out => l_asg_crit_out
8016: );
8017: -- If Leg. Code is US then check if the student is exempt from FICA.
8018: hr_utility.set_location('p_FICA_exempt: ' ||p_FICA_exempt, 60);
8019:
8020: IF (g_leg_code ='US' AND
8021: l_FICA_exempt IS NOT NULL )THEN
8022: Student_FICA_Status
8024: ,p_effective_date => p_effective_date
8025: ,p_business_group_id => p_business_group_id
8026: ,p_FICA_Status => l_FICA_exempt);
8027: END IF;
8028: hr_utility.set_location('Leaving : ' || l_proc_name,70);
8029:
8030: EXCEPTION
8031: WHEN Others THEN
8032: hr_utility.set_location('SQLCODE :' || SQLCODE,80);
8028: hr_utility.set_location('Leaving : ' || l_proc_name,70);
8029:
8030: EXCEPTION
8031: WHEN Others THEN
8032: hr_utility.set_location('SQLCODE :' || SQLCODE,80);
8033: l_error_msg := SQLERRM;
8034: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
8035: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
8036: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
8030: EXCEPTION
8031: WHEN Others THEN
8032: hr_utility.set_location('SQLCODE :' || SQLCODE,80);
8033: l_error_msg := SQLERRM;
8034: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
8035: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
8036: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
8037: hr_utility.raise_error;
8038:
8031: WHEN Others THEN
8032: hr_utility.set_location('SQLCODE :' || SQLCODE,80);
8033: l_error_msg := SQLERRM;
8034: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
8035: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
8036: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
8037: hr_utility.raise_error;
8038:
8039: END Upd_OSS_Person_Asg;
8032: hr_utility.set_location('SQLCODE :' || SQLCODE,80);
8033: l_error_msg := SQLERRM;
8034: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
8035: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
8036: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
8037: hr_utility.raise_error;
8038:
8039: END Upd_OSS_Person_Asg;
8040:
8033: l_error_msg := SQLERRM;
8034: hr_utility.set_message(8303, 'PQP_230500_HROSS_GENERIC_ERR');
8035: hr_utility.set_message_token('GENERIC_TOKEN',l_error_msg );
8036: hr_utility.set_location('Leaving: ' || l_proc_name, 80);
8037: hr_utility.raise_error;
8038:
8039: END Upd_OSS_Person_Asg;
8040:
8041: -- =============================================================================