52: ,p_kf_pos_no_rv_seg_clob out nocopy clob) IS
53:
54: cursor csr_config_business_groups(cp_configuration_code in varchar2) IS
55: select distinct configuration_code,
56: per_ri_config_utilities.business_group_decision(configuration_code,country_code)
57: from per_ri_config_country_v
58: where configuration_code = cp_configuration_code;
59:
60: l_proc varchar2(72) := g_package || 'create_technical_summary';
211: if g_technical_summary_mode then
212: hr_utility.trace('Technical Summary Mode');
213: end if;
214:
215: l_job_defined := per_ri_config_utilities.jpg_defined
216: (p_configuration_code => p_configuration_code
217: ,p_seg_type => 'JOB');
218:
219: l_pos_defined := per_ri_config_utilities.jpg_defined
215: l_job_defined := per_ri_config_utilities.jpg_defined
216: (p_configuration_code => p_configuration_code
217: ,p_seg_type => 'JOB');
218:
219: l_pos_defined := per_ri_config_utilities.jpg_defined
220: (p_configuration_code => p_configuration_code
221: ,p_seg_type => 'POSITION');
222:
223: l_grd_defined := per_ri_config_utilities.jpg_defined
219: l_pos_defined := per_ri_config_utilities.jpg_defined
220: (p_configuration_code => p_configuration_code
221: ,p_seg_type => 'POSITION');
222:
223: l_grd_defined := per_ri_config_utilities.jpg_defined
224: (p_configuration_code => p_configuration_code
225: ,p_seg_type => 'GRADE');
226:
227: l_jp_rv_defined := per_ri_config_utilities.regional_variance_defined
223: l_grd_defined := per_ri_config_utilities.jpg_defined
224: (p_configuration_code => p_configuration_code
225: ,p_seg_type => 'GRADE');
226:
227: l_jp_rv_defined := per_ri_config_utilities.regional_variance_defined
228: (p_configuration_code => p_configuration_code
229: ,p_rv_type => 'JP');
230:
231: l_grd_rv_defined := per_ri_config_utilities.regional_variance_defined
227: l_jp_rv_defined := per_ri_config_utilities.regional_variance_defined
228: (p_configuration_code => p_configuration_code
229: ,p_rv_type => 'JP');
230:
231: l_grd_rv_defined := per_ri_config_utilities.regional_variance_defined
232: (p_configuration_code => p_configuration_code
233: ,p_rv_type => 'GRD');
234:
235: hr_utility.set_location(l_proc, 20);
234:
235: hr_utility.set_location(l_proc, 20);
236:
237: -- populate enterprise short name global variable
238: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
239: --
240:
241: --
242: -- create HRMS_USER super user
293:
294: --
295: -- add hrms misc responsibilities to created user.
296: --
297: per_ri_config_utilities.assign_misc_responsibility
298: (p_configuration_code => p_configuration_code
299: ,p_technical_summary_mode => p_technical_summary_mode
300: ,p_hrms_misc_resp_tab => l_hrms_misc_resp_tab);
301:
690: );
691:
692: hr_utility.set_location(l_proc, 230);
693:
694: per_ri_config_utilities.create_more_hrms_resps
695: (p_configuration_code => p_configuration_code
696: ,p_security_profile_tab => l_security_profile_tab
697: ,p_int_bg_resp_tab => l_int_bg_resp_tab
698: ,p_technical_summary_mode => p_technical_summary_mode
709: ,p_hrms_resp_tab =>l_hrms_resp_main_tab
710: ,p_hrms_misc_resp_tab =>l_hrms_resp_tab);
711:
712: -- Security Group Removal Chnages
713: --per_ri_config_utilities.create_security_profile_assign
714: -- (p_security_profile_tab => l_security_profile_tab);
715:
716: hr_utility.set_location(' Leaving:'|| l_proc, 250);
717:
714: -- (p_security_profile_tab => l_security_profile_tab);
715:
716: hr_utility.set_location(' Leaving:'|| l_proc, 250);
717:
718: per_ri_config_utilities.submit_int_payroll_request
719: (errbuf => l_errbuf
720: ,retcode => l_retcode
721: ,p_country_tab => l_country_tab
722: ,p_technical_summary_mode => p_technical_summary_mode
734: hr_utility.set_location(' Leaving:'|| l_proc, 300);
735:
736: EXCEPTION
737: --when not_fresh_install then
738: --per_ri_config_utilities.write_log(p_message => l_log_message);
739: --raise;
740: when others then
741: l_error_message := 'Error in ' || l_proc;
742: hr_utility.trace(l_error_message || '-' || sqlerrm);
757: from hr_api_modules where module_name = 'CREATE_BUSINESS_GROUP'));
758:
759: cursor csr_config_business_groups(cp_configuration_code in varchar2) IS
760: select distinct configuration_code,
761: per_ri_config_utilities.business_group_decision(configuration_code,country_code)
762: from per_ri_config_country_v
763: where configuration_code = cp_configuration_code;
764:
765:
892: END;
893:
894:
895: -- Check if this database is freshly installed
896: l_fresh_installed := per_ri_config_utilities.check_fresh_installation;
897:
898: if NOT l_fresh_installed
899: and fnd_profile.value('PER_RI_LOAD_OVERRIDE') = 'N' then
900:
898: if NOT l_fresh_installed
899: and fnd_profile.value('PER_RI_LOAD_OVERRIDE') = 'N' then
900:
901: l_log_message := '<<----------------------ATTENTION------------------------------>>';
902: per_ri_config_utilities.write_log(p_message => l_log_message);
903:
904: l_log_message := 'This database got some entities setup done after it is freshly installed';
905: per_ri_config_utilities.write_log(p_message => l_log_message);
906:
901: l_log_message := '<<----------------------ATTENTION------------------------------>>';
902: per_ri_config_utilities.write_log(p_message => l_log_message);
903:
904: l_log_message := 'This database got some entities setup done after it is freshly installed';
905: per_ri_config_utilities.write_log(p_message => l_log_message);
906:
907: l_log_message := 'Loader Program Can not Continue';
908: per_ri_config_utilities.write_log(p_message => l_log_message);
909:
904: l_log_message := 'This database got some entities setup done after it is freshly installed';
905: per_ri_config_utilities.write_log(p_message => l_log_message);
906:
907: l_log_message := 'Loader Program Can not Continue';
908: per_ri_config_utilities.write_log(p_message => l_log_message);
909:
910: l_log_message := 'Exiting...' ;
911: per_ri_config_utilities.write_log(p_message => l_log_message);
912:
907: l_log_message := 'Loader Program Can not Continue';
908: per_ri_config_utilities.write_log(p_message => l_log_message);
909:
910: l_log_message := 'Exiting...' ;
911: per_ri_config_utilities.write_log(p_message => l_log_message);
912:
913: l_log_message := '<<----------------------ATTENTION------------------------------>>';
914: per_ri_config_utilities.write_log(p_message => l_log_message);
915: raise not_fresh_install;
910: l_log_message := 'Exiting...' ;
911: per_ri_config_utilities.write_log(p_message => l_log_message);
912:
913: l_log_message := '<<----------------------ATTENTION------------------------------>>';
914: per_ri_config_utilities.write_log(p_message => l_log_message);
915: raise not_fresh_install;
916: end if;
917:
918: -- Check PER_RI_LOAD_OVERRIDE
919: if fnd_profile.value('PER_RI_LOAD_OVERRIDE') = 'Y'
920: and NOT l_fresh_installed then
921: l_log_message := 'This database got some entities setup done after it is freshly installed';
922: l_log_message := l_log_message || '..Some of the entities loading might fail';
923: per_ri_config_utilities.write_log(p_message => l_log_message);
924: end if;
925:
926: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
927:
922: l_log_message := l_log_message || '..Some of the entities loading might fail';
923: per_ri_config_utilities.write_log(p_message => l_log_message);
924: end if;
925:
926: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
927:
928: l_job_defined := per_ri_config_utilities.jpg_defined
929: (p_configuration_code => p_configuration_code
930: ,p_seg_type => 'JOB');
924: end if;
925:
926: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
927:
928: l_job_defined := per_ri_config_utilities.jpg_defined
929: (p_configuration_code => p_configuration_code
930: ,p_seg_type => 'JOB');
931:
932: l_pos_defined := per_ri_config_utilities.jpg_defined
928: l_job_defined := per_ri_config_utilities.jpg_defined
929: (p_configuration_code => p_configuration_code
930: ,p_seg_type => 'JOB');
931:
932: l_pos_defined := per_ri_config_utilities.jpg_defined
933: (p_configuration_code => p_configuration_code
934: ,p_seg_type => 'POSITION');
935:
936: l_grd_defined := per_ri_config_utilities.jpg_defined
932: l_pos_defined := per_ri_config_utilities.jpg_defined
933: (p_configuration_code => p_configuration_code
934: ,p_seg_type => 'POSITION');
935:
936: l_grd_defined := per_ri_config_utilities.jpg_defined
937: (p_configuration_code => p_configuration_code
938: ,p_seg_type => 'GRADE');
939:
940: l_jp_rv_defined := per_ri_config_utilities.regional_variance_defined
936: l_grd_defined := per_ri_config_utilities.jpg_defined
937: (p_configuration_code => p_configuration_code
938: ,p_seg_type => 'GRADE');
939:
940: l_jp_rv_defined := per_ri_config_utilities.regional_variance_defined
941: (p_configuration_code => p_configuration_code
942: ,p_rv_type => 'JP');
943:
944: l_grd_rv_defined := per_ri_config_utilities.regional_variance_defined
940: l_jp_rv_defined := per_ri_config_utilities.regional_variance_defined
941: (p_configuration_code => p_configuration_code
942: ,p_rv_type => 'JP');
943:
944: l_grd_rv_defined := per_ri_config_utilities.regional_variance_defined
945: (p_configuration_code => p_configuration_code
946: ,p_rv_type => 'GRD');
947:
948: hr_utility.set_location(l_proc, 20);
947:
948: hr_utility.set_location(l_proc, 20);
949:
950: -- populate enterprise short name global variable
951: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
952: --
953:
954: --
955: -- create HRMS_USER super user
998:
999: --
1000: -- add hrms misc responsibilities to created user.
1001: --
1002: per_ri_config_utilities.assign_misc_responsibility
1003: (p_configuration_code => p_configuration_code
1004: ,p_technical_summary_mode => l_technical_summary_mode
1005: ,p_hrms_misc_resp_tab => l_hrms_misc_resp_tab);
1006:
1206: ,p_batch_id => l_batch_header_id
1207: ,p_validate => 'N'
1208: ,p_pap_group_id => null);
1209:
1210: l_data_pump_exception := per_ri_config_utilities.check_data_pump_exception(p_patch_header_id => l_batch_header_id);
1211: if l_data_pump_exception then
1212: per_ri_config_utilities.write_data_pump_exception_log(p_patch_header_id => l_batch_header_id);
1213: raise data_pump_load_failure;
1214: end if;
1208: ,p_pap_group_id => null);
1209:
1210: l_data_pump_exception := per_ri_config_utilities.check_data_pump_exception(p_patch_header_id => l_batch_header_id);
1211: if l_data_pump_exception then
1212: per_ri_config_utilities.write_data_pump_exception_log(p_patch_header_id => l_batch_header_id);
1213: raise data_pump_load_failure;
1214: end if;
1215:
1216: EXCEPTION
1269: ,p_batch_id => l_batch_header_id
1270: ,p_validate => 'N'
1271: ,p_pap_group_id => null);
1272:
1273: l_data_pump_exception := per_ri_config_utilities.check_data_pump_exception(p_patch_header_id => l_batch_header_id);
1274: if l_data_pump_exception then
1275: per_ri_config_utilities.write_data_pump_exception_log(p_patch_header_id => l_batch_header_id);
1276: raise data_pump_load_failure;
1277: end if;
1271: ,p_pap_group_id => null);
1272:
1273: l_data_pump_exception := per_ri_config_utilities.check_data_pump_exception(p_patch_header_id => l_batch_header_id);
1274: if l_data_pump_exception then
1275: per_ri_config_utilities.write_data_pump_exception_log(p_patch_header_id => l_batch_header_id);
1276: raise data_pump_load_failure;
1277: end if;
1278:
1279: EXCEPTION
1410: ,p_batch_id => l_batch_header_id
1411: ,p_validate => 'N'
1412: ,p_pap_group_id => null);
1413:
1414: l_data_pump_exception := per_ri_config_utilities.check_data_pump_exception(p_patch_header_id => l_batch_header_id);
1415: if l_data_pump_exception then
1416: per_ri_config_utilities.write_data_pump_exception_log(p_patch_header_id => l_batch_header_id);
1417: raise data_pump_load_failure;
1418: end if;
1412: ,p_pap_group_id => null);
1413:
1414: l_data_pump_exception := per_ri_config_utilities.check_data_pump_exception(p_patch_header_id => l_batch_header_id);
1415: if l_data_pump_exception then
1416: per_ri_config_utilities.write_data_pump_exception_log(p_patch_header_id => l_batch_header_id);
1417: raise data_pump_load_failure;
1418: end if;
1419:
1420: EXCEPTION
1436:
1437: hr_utility.set_location(l_proc, 230);
1438:
1439:
1440: per_ri_config_utilities.create_more_hrms_resps
1441: (p_configuration_code => p_configuration_code
1442: ,p_security_profile_tab => l_security_profile_tab
1443: ,p_int_bg_resp_tab => l_int_bg_resp_tab
1444: --,p_technical_summary_mode => l_technical_summary_mode
1449: hr_utility.set_location(' Leaving:'|| l_proc, 250);
1450:
1451: -- Security Group Removal Changes
1452: --
1453: --per_ri_config_utilities.create_security_profile_assign
1454: --(p_security_profile_tab => l_security_profile_tab);
1455:
1456: hr_utility.set_location(' Leaving:'|| l_proc, 250);
1457:
1454: --(p_security_profile_tab => l_security_profile_tab);
1455:
1456: hr_utility.set_location(' Leaving:'|| l_proc, 250);
1457:
1458: per_ri_config_utilities.submit_int_payroll_request
1459: (errbuf => l_errbuf
1460: ,retcode => l_retcode
1461: ,p_country_tab => l_country_tab
1462: ,p_technical_summary_mode => l_technical_summary_mode
1463: ,p_int_hrms_setup_tab => l_int_hrms_setup_tab
1464: );
1465: hr_utility.set_location(l_proc, 240);
1466:
1467: per_ri_config_utilities.update_configuration_status(p_configuration_code);
1468:
1469: --
1470: -- Enable Multiple Security Group process
1471: --
1469: --
1470: -- Enable Multiple Security Group process
1471: --
1472: -- commented code in this process call.
1473: per_ri_config_utilities.submit_enable_mult_sg_process
1474: (errbuf => l_errbuf_msg
1475: ,retcode => l_retcode_msg);
1476:
1477:
1483:
1484:
1485: EXCEPTION
1486: --when not_fresh_install then
1487: --per_ri_config_utilities.write_log(p_message => l_log_message);
1488: --raise;
1489: when others then
1490: l_error_message := 'Error in ' || l_proc;
1491: hr_utility.trace(l_error_message || '-' || sqlerrm);