[Home] [Help]
185:
186: BEGIN
187:
188:
189: hr_utility.set_location('Entering:'|| l_proc, 10);
190:
191: hr_utility.trace('Starting Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
192:
193: l_multi_tenancy := hr_multi_tenancy_pkg.is_multi_tenant_system;
187:
188:
189: hr_utility.set_location('Entering:'|| l_proc, 10);
190:
191: hr_utility.trace('Starting Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
192:
193: l_multi_tenancy := hr_multi_tenancy_pkg.is_multi_tenant_system;
194: l_sec_group_id := fnd_global.security_group_id;
195: if l_multi_tenancy then
208: -- Set global variable for loader program mode
209: g_technical_summary_mode := p_technical_summary_mode;
210:
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
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);
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: --
245: ,p_user_tab => l_user_tab);
246:
247: p_user_clob := per_ri_config_tech_summary.get_user_sql (l_user_tab);
248:
249: hr_utility.set_location(l_proc, 30);
250:
251: --
252: -- attach default responsibility
253: --
256: ,p_technical_summary_mode => p_technical_summary_mode
257: ,p_resp_tab => l_resp_tab
258: );
259:
260: hr_utility.set_location(l_proc, 40);
261:
262: --
263: -- set site level profile options
264: --
277: (p_configuration_code => p_configuration_code
278: ,p_technical_summary_mode => p_technical_summary_mode
279: ,p_profile_apps_tab => l_profile_apps_tab);
280:
281: hr_utility.set_location(l_proc, 50);
282: --
283: -- add hrms responsibilities to created user.
284: --
285: per_ri_config_fnd_hr_entity.create_hrms_responsibility
288: ,p_technical_summary_mode => p_technical_summary_mode
289: ,p_hrms_resp_tab => l_hrms_resp_tab);
290:
291:
292: hr_utility.set_location(l_proc, 60);
293:
294: --
295: -- add hrms misc responsibilities to created user.
296: --
299: ,p_technical_summary_mode => p_technical_summary_mode
300: ,p_hrms_misc_resp_tab => l_hrms_misc_resp_tab);
301:
302:
303: hr_utility.set_location(l_proc, 65);
304:
305: --
306: -- Take Decision on the creation of flexfield structures
307: --
319: l_bg_count := l_bg_count + 1;
320: end loop;
321: close csr_config_business_groups;
322:
323: hr_utility.set_location('BG Count is : '|| l_bg_count, 45);
324:
325:
326: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
327: AND l_enterprise_id IS NOT NULL AND l_bg_count=1 then
324:
325:
326: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
327: AND l_enterprise_id IS NOT NULL AND l_bg_count=1 then
328: hr_utility.set_location('No flex structures required', 11);
329: ELSE
330:
331: per_ri_config_fnd_hr_entity.create_global_grp_cmp_cost_kf
332: (p_configuration_code => p_configuration_code
337: ,p_kf_grp_seg_tab => l_kf_grp_seg_tab
338: ,p_kf_cmp_seg_tab => l_kf_cmp_seg_tab
339: ,p_kf_cost_seg_tab => l_kf_cost_seg_tab
340: );
341: hr_utility.set_location(l_proc, 70);
342:
343:
344: --
345: -- make decisions about job, positions and grades
346: --
347:
348: --jobs/positions not defined
349: if NOT l_job_defined and NOT l_pos_defined then
350: hr_utility.trace('Jobs/Positions NOT defined');
351: --
352: -- create global jobs and positions
353: --
354: per_ri_config_fnd_hr_entity.create_global_job_pos_kf
358: ,p_kf_pos_tab => l_kf_pos_tab
359: ,p_kf_job_seg_tab => l_kf_job_seg_tab
360: ,p_kf_pos_seg_tab => l_kf_pos_seg_tab
361: );
362: hr_utility.set_location(l_proc, 80);
363: end if;
364:
365: --when positions not defined - this case comes when
366: -- user has selected only job in RV section.
365: --when positions not defined - this case comes when
366: -- user has selected only job in RV section.
367:
368: if NOT l_pos_defined then
369: hr_utility.trace('Positions NOT defined');
370: --
371: -- create global positions
372: --
373: per_ri_config_fnd_hr_entity.create_global_pos_kf
375: ,p_technical_summary_mode => p_technical_summary_mode
376: ,p_kf_pos_tab => l_kf_pos_tab
377: ,p_kf_pos_seg_tab => l_kf_pos_seg_tab
378: );
379: hr_utility.set_location(l_proc, 85);
380: end if;
381: --grades are not defined
382: if NOT l_grd_defined then
383: hr_utility.trace('Grades NOT defined');
379: hr_utility.set_location(l_proc, 85);
380: end if;
381: --grades are not defined
382: if NOT l_grd_defined then
383: hr_utility.trace('Grades NOT defined');
384: --
385: -- create global grades
386: --
387: per_ri_config_fnd_hr_entity.create_global_grd_kf
389: ,p_technical_summary_mode => p_technical_summary_mode
390: ,p_kf_grd_tab => l_kf_grd_tab
391: ,p_kf_grd_seg_tab => l_kf_grd_seg_tab
392: );
393: hr_utility.set_location(l_proc, 90);
394: end if;
395:
396: -- jobs defined (including RVs)
397: if l_job_defined or l_jp_rv_defined then
394: end if;
395:
396: -- jobs defined (including RVs)
397: if l_job_defined or l_jp_rv_defined then
398: hr_utility.trace('Jobs defined');
399: --
400: -- create jobs with no rvs
401: --
402: per_ri_config_fnd_hr_entity.create_jobs_no_rv_keyflex
404: ,p_technical_summary_mode => p_technical_summary_mode
405: ,p_kf_job_no_rv_tab => l_kf_job_no_rv_tab
406: ,p_kf_job_no_rv_seg_tab => l_kf_job_no_rv_seg_tab
407: );
408: hr_utility.set_location(l_proc, 100);
409: -- create jobs with rvs
410: --
411: per_ri_config_fnd_hr_entity.create_jobs_rv_keyflex
412: (p_configuration_code => p_configuration_code
413: ,p_technical_summary_mode => p_technical_summary_mode
414: ,p_kf_job_rv_tab => l_kf_job_rv_tab
415: ,p_kf_job_rv_seg_tab => l_kf_job_rv_seg_tab
416: );
417: hr_utility.set_location(l_proc, 110);
418: end if;
419:
420: -- Positions defined (including RVs)
421: if l_pos_defined or (l_pos_defined and l_jp_rv_defined) then -- fix for 4522666
418: end if;
419:
420: -- Positions defined (including RVs)
421: if l_pos_defined or (l_pos_defined and l_jp_rv_defined) then -- fix for 4522666
422: hr_utility.trace('Positions IS defined');
423: --
424: -- create positions with no rvs
425: --
426: per_ri_config_fnd_hr_entity.create_positions_no_rv_keyflex
428: ,p_technical_summary_mode => p_technical_summary_mode
429: ,p_kf_pos_no_rv_tab => l_kf_pos_no_rv_tab
430: ,p_kf_pos_no_rv_seg_tab => l_kf_pos_no_rv_seg_tab
431: );
432: hr_utility.set_location(l_proc, 120);
433: --
434: -- create positions with rvs
435: --
436: per_ri_config_fnd_hr_entity.create_positions_rv_keyflex
438: ,p_technical_summary_mode => p_technical_summary_mode
439: ,p_kf_pos_rv_tab => l_kf_pos_rv_tab
440: ,p_kf_pos_rv_seg_tab => l_kf_pos_rv_seg_tab
441: );
442: hr_utility.set_location(l_proc, 130);
443: end if;
444:
445: -- Grades defined (including RVs)
446: if l_grd_defined or l_grd_rv_defined then
443: end if;
444:
445: -- Grades defined (including RVs)
446: if l_grd_defined or l_grd_rv_defined then
447: hr_utility.trace('Grades IS defined');
448: --
449: -- create grades with no rvs
450: --
451: per_ri_config_fnd_hr_entity.create_grades_no_rv_keyflex
453: ,p_technical_summary_mode => p_technical_summary_mode
454: ,p_kf_grd_no_rv_tab => l_kf_grd_no_rv_tab
455: ,p_kf_grd_no_rv_seg_tab => l_kf_grd_no_rv_seg_tab
456: );
457: hr_utility.set_location(l_proc, 140);
458: --
459: -- create grades with rvs
460: --
461: per_ri_config_fnd_hr_entity.create_grades_rv_keyflex
463: ,p_technical_summary_mode => p_technical_summary_mode
464: ,p_kf_grd_rv_tab => l_kf_grd_rv_tab
465: ,p_kf_grd_rv_seg_tab => l_kf_grd_rv_seg_tab
466: );
467: hr_utility.set_location(l_proc, 150);
468: end if;
469:
470: -- Get Keyflex and Segments
471: p_key_str_clob := per_ri_config_tech_summary.get_keyflex_structure_sql
541: p_kf_grp_seg_clob := l_kf_grp_seg_clob;
542: p_kf_cmp_seg_clob := l_kf_cmp_seg_clob;
543: p_kf_cost_seg_clob := l_kf_cost_seg_clob;
544:
545: hr_utility.set_location(l_proc, 170);
546:
547: END IF;
548: --
549: -- create locations
557:
558: p_location_clob := per_ri_config_tech_summary.get_locations_sql (p_location_tab => l_location_tab) ;
559:
560:
561: hr_utility.set_location(l_proc, 180);
562:
563:
564: --
565: -- create business groups
581: );
582: p_post_install_clob := per_ri_config_tech_summary.get_post_install_sql(
583: p_post_install_tab =>l_post_install_tab
584: );
585: hr_utility.set_location(l_proc, 190);
586: --
587: -- create enterprise orgs and related classifications
588: --
589: per_ri_config_datapump_entity.create_enterprise_batch_lines
603: p_site_profile_clob := per_ri_config_tech_summary.get_profile_sql (
604: p_profile_tab => l_profile_tab
605: ,p_profile_dpe_ent_tab => l_profile_dpe_ent_tab
606: );
607: hr_utility.set_location(l_proc, 200);
608:
609: --
610: -- create operating companies orgs and related classifications
611: --
615: ,p_technical_summary_mode => p_technical_summary_mode
616: ,p_org_oc_tab => l_org_oc_tab
617: ,p_org_oc_class_tab => l_org_oc_class_tab
618: ,p_org_hierarchy_ele_oc_tab => l_org_hierarchy_ele_oc_tab);
619: hr_utility.set_location(l_proc, 200);
620: hr_utility.set_location(l_proc, 210);
621:
622: --
623: -- create legal entities orgs and related classifications
616: ,p_org_oc_tab => l_org_oc_tab
617: ,p_org_oc_class_tab => l_org_oc_class_tab
618: ,p_org_hierarchy_ele_oc_tab => l_org_hierarchy_ele_oc_tab);
619: hr_utility.set_location(l_proc, 200);
620: hr_utility.set_location(l_proc, 210);
621:
622: --
623: -- create legal entities orgs and related classifications
624: --
629: ,p_org_le_tab => l_org_le_tab
630: ,p_org_le_class_tab => l_org_le_class_tab
631: ,p_org_hierarchy_ele_le_tab => l_org_hierarchy_ele_le_tab);
632:
633: hr_utility.set_location(l_proc, 220);
634:
635: p_organization_clob := per_ri_config_tech_summary.get_org_sql
636: (p_org_ent_tab => l_org_ent_tab
637: ,p_org_oc_tab => l_org_oc_tab
688: ,p_kf_cmp_seg_tab => l_kf_cmp_seg_tab
689: ,p_kf_cost_seg_tab => l_kf_cost_seg_tab
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
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:
718: per_ri_config_utilities.submit_int_payroll_request
719: (errbuf => l_errbuf
720: ,retcode => l_retcode
725:
726: p_int_hrms_clob := per_ri_config_tech_summary.get_int_hrms_setup_sql
727: (p_int_hrms_setup_tab => l_int_hrms_setup_tab);
728:
729: hr_utility.set_location(l_proc, 240);
730:
731: rollback;
732:
733: hr_utility.trace('Ending Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
729: hr_utility.set_location(l_proc, 240);
730:
731: rollback;
732:
733: hr_utility.trace('Ending Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
734: hr_utility.set_location(' Leaving:'|| l_proc, 300);
735:
736: EXCEPTION
737: --when not_fresh_install then
730:
731: rollback;
732:
733: hr_utility.trace('Ending Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
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);
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);
743: hr_utility.set_location(' Leaving:'|| l_proc, 500);
744: hr_utility.raise_error;
745:
746: END create_technical_summary;
739: --raise;
740: when others then
741: l_error_message := 'Error in ' || l_proc;
742: hr_utility.trace(l_error_message || '-' || sqlerrm);
743: hr_utility.set_location(' Leaving:'|| l_proc, 500);
744: hr_utility.raise_error;
745:
746: END create_technical_summary;
747:
740: when others then
741: l_error_message := 'Error in ' || l_proc;
742: hr_utility.trace(l_error_message || '-' || sqlerrm);
743: hr_utility.set_location(' Leaving:'|| l_proc, 500);
744: hr_utility.raise_error;
745:
746: END create_technical_summary;
747:
748:
859:
860: BEGIN
861:
862:
863: hr_utility.set_location('Entering:'|| l_proc, 10);
864:
865: hr_utility.trace('Starting Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
866:
867: --Check Whether multiTenancy is enabled or not
861:
862:
863: hr_utility.set_location('Entering:'|| l_proc, 10);
864:
865: hr_utility.trace('Starting Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
866:
867: --Check Whether multiTenancy is enabled or not
868: l_multi_tenancy := hr_multi_tenancy_pkg.is_multi_tenant_system;
869: l_sec_group_id := fnd_global.security_group_id;
878: EXCEPTION
879: WHEN NO_DATA_FOUND THEN
880: l_enterprise_id := null;
881: END;
882: hr_utility.set_location('Enterprise Id is ' || l_enterprise_id, 78);
883: hr_utility.set_location('BEFORE SEC GROUP ID IS : '||fnd_global.security_group_id, 78);
884: l_old_sec_group_id := fnd_global.security_group_id;
885: BEGIN
886: select 'C::'||enterprise_label into l_label from per_ent_security_groups
879: WHEN NO_DATA_FOUND THEN
880: l_enterprise_id := null;
881: END;
882: hr_utility.set_location('Enterprise Id is ' || l_enterprise_id, 78);
883: hr_utility.set_location('BEFORE SEC GROUP ID IS : '||fnd_global.security_group_id, 78);
884: l_old_sec_group_id := fnd_global.security_group_id;
885: BEGIN
886: select 'C::'||enterprise_label into l_label from per_ent_security_groups
887: where security_group_id = fnd_global.security_group_id;
884: l_old_sec_group_id := fnd_global.security_group_id;
885: BEGIN
886: select 'C::'||enterprise_label into l_label from per_ent_security_groups
887: where security_group_id = fnd_global.security_group_id;
888: hr_utility.set_location('Sec Group Id is '||fnd_global.security_group_id, 100) ;
889: EXCEPTION
890: WHEN NO_DATA_FOUND THEN
891: l_label := null;
892: END;
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);
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: --
966: (p_configuration_code => p_configuration_code
967: ,p_technical_summary_mode => l_technical_summary_mode
968: ,p_resp_tab => l_resp_tab
969: );
970: hr_utility.set_location(l_proc, 40);
971:
972: --
973: -- set site level profile options
974: --
983: per_ri_config_fnd_hr_entity.create_application_level_resp
984: (p_configuration_code => p_configuration_code
985: ,p_technical_summary_mode => l_technical_summary_mode
986: ,p_profile_apps_tab => l_profile_apps_tab);
987: hr_utility.set_location(l_proc, 50);
988: --
989: -- add hrms responsibilities to created user.
990: --
991: per_ri_config_fnd_hr_entity.create_hrms_responsibility
993: ,p_security_profile_tab => l_security_profile_tab
994: ,p_technical_summary_mode => l_technical_summary_mode
995: ,p_hrms_resp_tab => l_hrms_resp_tab);
996:
997: hr_utility.set_location(l_proc, 60);
998:
999: --
1000: -- add hrms misc responsibilities to created user.
1001: --
1004: ,p_technical_summary_mode => l_technical_summary_mode
1005: ,p_hrms_misc_resp_tab => l_hrms_misc_resp_tab);
1006:
1007:
1008: hr_utility.set_location(l_proc, 65);
1009:
1010: --
1011: -- Take Decision on the creation of flexfields
1012: --
1021: exit when csr_config_business_groups%NOTFOUND;
1022: l_bg_count := l_bg_count + 1;
1023: end loop;
1024: close csr_config_business_groups;
1025: hr_utility.set_location('BG Count is : '|| l_bg_count, 45);
1026:
1027: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1028: AND l_enterprise_id IS NOT NULL AND l_bg_count=1 then
1029: hr_utility.set_location('No flex structures required', 11);
1025: hr_utility.set_location('BG Count is : '|| l_bg_count, 45);
1026:
1027: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1028: AND l_enterprise_id IS NOT NULL AND l_bg_count=1 then
1029: hr_utility.set_location('No flex structures required', 11);
1030: ELSE
1031:
1032: per_ri_config_fnd_hr_entity.create_global_grp_cmp_cost_kf
1033: (p_configuration_code => p_configuration_code
1039: ,p_kf_cmp_seg_tab => l_kf_cmp_seg_tab
1040: ,p_kf_cost_seg_tab => l_kf_cost_seg_tab
1041: );
1042:
1043: hr_utility.set_location(l_proc, 70);
1044:
1045:
1046: --
1047: -- make decisions about job, positions and grades
1048: --
1049:
1050: --jobs/positions not defined
1051: if NOT l_job_defined and NOT l_pos_defined then
1052: hr_utility.trace('Jobs/Positions NOT defined');
1053: --
1054: -- create global jobs and positions
1055: --
1056: per_ri_config_fnd_hr_entity.create_global_job_pos_kf
1060: ,p_kf_pos_tab => l_kf_pos_tab
1061: ,p_kf_job_seg_tab => l_kf_job_seg_tab
1062: ,p_kf_pos_seg_tab => l_kf_pos_seg_tab
1063: );
1064: hr_utility.set_location(l_proc, 80);
1065: end if;
1066:
1067: --when positions not defined - this case comes when
1068: --user has selected only job in RV section.
1067: --when positions not defined - this case comes when
1068: --user has selected only job in RV section.
1069:
1070: if NOT l_pos_defined then
1071: hr_utility.trace('Positions NOT defined');
1072: --
1073: -- create global positions
1074: --
1075: per_ri_config_fnd_hr_entity.create_global_pos_kf
1077: ,p_technical_summary_mode => l_technical_summary_mode
1078: ,p_kf_pos_tab => l_kf_pos_tab
1079: ,p_kf_pos_seg_tab => l_kf_pos_seg_tab
1080: );
1081: hr_utility.set_location(l_proc, 85);
1082: end if;
1083: --grades are not defined
1084: if NOT l_grd_defined then
1085: hr_utility.trace('Grades NOT defined');
1081: hr_utility.set_location(l_proc, 85);
1082: end if;
1083: --grades are not defined
1084: if NOT l_grd_defined then
1085: hr_utility.trace('Grades NOT defined');
1086: --
1087: -- create global grades
1088: --
1089: per_ri_config_fnd_hr_entity.create_global_grd_kf
1091: ,p_technical_summary_mode => l_technical_summary_mode
1092: ,p_kf_grd_tab => l_kf_grd_tab
1093: ,p_kf_grd_seg_tab => l_kf_grd_seg_tab
1094: );
1095: hr_utility.set_location(l_proc, 90);
1096: end if;
1097:
1098: -- jobs defined (including RVs)
1099: if l_job_defined or l_jp_rv_defined then
1096: end if;
1097:
1098: -- jobs defined (including RVs)
1099: if l_job_defined or l_jp_rv_defined then
1100: hr_utility.trace('Jobs defined');
1101: --
1102: -- create jobs with no rvs
1103: --
1104: per_ri_config_fnd_hr_entity.create_jobs_no_rv_keyflex
1106: ,p_technical_summary_mode => l_technical_summary_mode
1107: ,p_kf_job_no_rv_tab => l_kf_job_no_rv_tab
1108: ,p_kf_job_no_rv_seg_tab => l_kf_job_no_rv_seg_tab
1109: );
1110: hr_utility.set_location(l_proc, 100);
1111: -- create jobs with rvs
1112: --
1113: per_ri_config_fnd_hr_entity.create_jobs_rv_keyflex
1114: (p_configuration_code => p_configuration_code
1115: ,p_technical_summary_mode => l_technical_summary_mode
1116: ,p_kf_job_rv_tab => l_kf_job_rv_tab
1117: ,p_kf_job_rv_seg_tab => l_kf_job_rv_seg_tab
1118: );
1119: hr_utility.set_location(l_proc, 110);
1120: end if;
1121:
1122: -- Positions defined (including RVs)
1123: if l_pos_defined or (l_pos_defined and l_jp_rv_defined) then -- fix for 4522666
1120: end if;
1121:
1122: -- Positions defined (including RVs)
1123: if l_pos_defined or (l_pos_defined and l_jp_rv_defined) then -- fix for 4522666
1124: hr_utility.trace('Positions IS defined');
1125: --
1126: -- create positions with no rvs
1127: --
1128: per_ri_config_fnd_hr_entity.create_positions_no_rv_keyflex
1130: ,p_technical_summary_mode => l_technical_summary_mode
1131: ,p_kf_pos_no_rv_tab => l_kf_pos_no_rv_tab
1132: ,p_kf_pos_no_rv_seg_tab => l_kf_pos_no_rv_seg_tab
1133: );
1134: hr_utility.set_location(l_proc, 120);
1135: --
1136: -- create positions with rvs
1137: --
1138: per_ri_config_fnd_hr_entity.create_positions_rv_keyflex
1140: ,p_technical_summary_mode => l_technical_summary_mode
1141: ,p_kf_pos_rv_tab => l_kf_pos_rv_tab
1142: ,p_kf_pos_rv_seg_tab => l_kf_pos_rv_seg_tab
1143: );
1144: hr_utility.set_location(l_proc, 130);
1145:
1146: end if;
1147:
1148: -- Grades defined (including RVs)
1146: end if;
1147:
1148: -- Grades defined (including RVs)
1149: if l_grd_defined or l_grd_rv_defined then
1150: hr_utility.trace('Grades IS defined');
1151: --
1152: -- create grades with no rvs
1153: --
1154: per_ri_config_fnd_hr_entity.create_grades_no_rv_keyflex
1156: ,p_technical_summary_mode => l_technical_summary_mode
1157: ,p_kf_grd_no_rv_tab => l_kf_grd_no_rv_tab
1158: ,p_kf_grd_no_rv_seg_tab => l_kf_grd_no_rv_seg_tab
1159: );
1160: hr_utility.set_location(l_proc, 140);
1161: --
1162: -- create grades with rvs
1163: --
1164: per_ri_config_fnd_hr_entity.create_grades_rv_keyflex
1166: ,p_technical_summary_mode => l_technical_summary_mode
1167: ,p_kf_grd_rv_tab => l_kf_grd_rv_tab
1168: ,p_kf_grd_rv_seg_tab => l_kf_grd_rv_seg_tab
1169: );
1170: hr_utility.set_location(l_proc, 150);
1171: end if;
1172: END IF;
1173:
1174:
1175: --
1176: -- create batch header
1177: l_batch_name := substr(p_configuration_code || ' ' || to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'),1,80);
1178:
1179: hr_utility.set_location(l_proc, 160);
1180: l_batch_header_id := hr_pump_utils.create_batch_header
1181: (p_batch_name => l_batch_name);
1182: hr_utility.set_location(l_batch_name, 1990);
1183: hr_utility.set_location(l_batch_header_id, 2000);
1178:
1179: hr_utility.set_location(l_proc, 160);
1180: l_batch_header_id := hr_pump_utils.create_batch_header
1181: (p_batch_name => l_batch_name);
1182: hr_utility.set_location(l_batch_name, 1990);
1183: hr_utility.set_location(l_batch_header_id, 2000);
1184: hr_utility.set_location(l_proc, 170);
1185: --
1186: -- create locations
1179: hr_utility.set_location(l_proc, 160);
1180: l_batch_header_id := hr_pump_utils.create_batch_header
1181: (p_batch_name => l_batch_name);
1182: hr_utility.set_location(l_batch_name, 1990);
1183: hr_utility.set_location(l_batch_header_id, 2000);
1184: hr_utility.set_location(l_proc, 170);
1185: --
1186: -- create locations
1187: --
1180: l_batch_header_id := hr_pump_utils.create_batch_header
1181: (p_batch_name => l_batch_name);
1182: hr_utility.set_location(l_batch_name, 1990);
1183: hr_utility.set_location(l_batch_header_id, 2000);
1184: hr_utility.set_location(l_proc, 170);
1185: --
1186: -- create locations
1187: --
1188: per_ri_config_datapump_entity.create_locations_batch_lines
1190: ,p_batch_header_id => l_batch_header_id
1191: ,p_technical_summary_mode => l_technical_summary_mode
1192: ,p_location_tab => l_location_tab
1193: );
1194: hr_utility.set_location(l_proc, 180);
1195:
1196: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1197: AND l_enterprise_id IS NOT NULL
1198: THEN
1195:
1196: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1197: AND l_enterprise_id IS NOT NULL
1198: THEN
1199: hr_utility.set_location('DP is getting run before hand ', 76);
1200: BEGIN
1201: --
1202: -- run data pump to load hrms entities into schema
1203: --
1214: end if;
1215:
1216: EXCEPTION
1217: when data_pump_load_failure then
1218: hr_utility.set_location(l_proc, 221);
1219: hr_utility.raise_error;
1220: commit;
1221: when others then
1222: hr_utility.set_location(l_proc, 222);
1215:
1216: EXCEPTION
1217: when data_pump_load_failure then
1218: hr_utility.set_location(l_proc, 221);
1219: hr_utility.raise_error;
1220: commit;
1221: when others then
1222: hr_utility.set_location(l_proc, 222);
1223: p_errbuff := 'Error cooured in loading datapump records';
1218: hr_utility.set_location(l_proc, 221);
1219: hr_utility.raise_error;
1220: commit;
1221: when others then
1222: hr_utility.set_location(l_proc, 222);
1223: p_errbuff := 'Error cooured in loading datapump records';
1224: p_retcode := 2;
1225:
1226: l_error_message := 'Error in ' || l_proc;
1223: p_errbuff := 'Error cooured in loading datapump records';
1224: p_retcode := 2;
1225:
1226: l_error_message := 'Error in ' || l_proc;
1227: --hr_utility.trace(l_error_message || '-' || sqlerrm);
1228: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1229: hr_utility.raise_error;
1230: commit;
1231: END;
1224: p_retcode := 2;
1225:
1226: l_error_message := 'Error in ' || l_proc;
1227: --hr_utility.trace(l_error_message || '-' || sqlerrm);
1228: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1229: hr_utility.raise_error;
1230: commit;
1231: END;
1232:
1225:
1226: l_error_message := 'Error in ' || l_proc;
1227: --hr_utility.trace(l_error_message || '-' || sqlerrm);
1228: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1229: hr_utility.raise_error;
1230: commit;
1231: END;
1232:
1233: l_batch_name := substr(p_configuration_code || 'second' || ' ' || to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'),1,80);
1231: END;
1232:
1233: l_batch_name := substr(p_configuration_code || 'second' || ' ' || to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'),1,80);
1234:
1235: hr_utility.set_location(l_proc, 160);
1236: l_batch_header_id := hr_pump_utils.create_batch_header
1237: (p_batch_name => l_batch_name);
1238:
1239: END IF;
1252: ,p_sg_tab => l_sg_tab
1253: ,p_post_install_tab => l_post_install_tab
1254: ,p_int_bg_resp_tab => l_int_bg_resp_tab);
1255:
1256: hr_utility.set_location(l_proc, 190);
1257:
1258: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1259: AND l_enterprise_id IS NOT NULL
1260: THEN
1257:
1258: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1259: AND l_enterprise_id IS NOT NULL
1260: THEN
1261: hr_utility.set_location('DP is getting run before hand ', 76);
1262: BEGIN
1263: hr_multi_tenancy_pkg.set_context('ENT');
1264: --
1265: -- run data pump to load hrms entities into schema
1277: end if;
1278:
1279: EXCEPTION
1280: when data_pump_load_failure then
1281: hr_utility.set_location(l_proc, 221);
1282: hr_utility.raise_error;
1283: commit;
1284: when others then
1285: hr_utility.set_location(l_proc, 222);
1278:
1279: EXCEPTION
1280: when data_pump_load_failure then
1281: hr_utility.set_location(l_proc, 221);
1282: hr_utility.raise_error;
1283: commit;
1284: when others then
1285: hr_utility.set_location(l_proc, 222);
1286: p_errbuff := 'Error cooured in loading datapump records';
1281: hr_utility.set_location(l_proc, 221);
1282: hr_utility.raise_error;
1283: commit;
1284: when others then
1285: hr_utility.set_location(l_proc, 222);
1286: p_errbuff := 'Error cooured in loading datapump records';
1287: p_retcode := 2;
1288:
1289: l_error_message := 'Error in ' || l_proc;
1286: p_errbuff := 'Error cooured in loading datapump records';
1287: p_retcode := 2;
1288:
1289: l_error_message := 'Error in ' || l_proc;
1290: --hr_utility.trace(l_error_message || '-' || sqlerrm);
1291: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1292: hr_utility.raise_error;
1293: commit;
1294: END;
1287: p_retcode := 2;
1288:
1289: l_error_message := 'Error in ' || l_proc;
1290: --hr_utility.trace(l_error_message || '-' || sqlerrm);
1291: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1292: hr_utility.raise_error;
1293: commit;
1294: END;
1295:
1288:
1289: l_error_message := 'Error in ' || l_proc;
1290: --hr_utility.trace(l_error_message || '-' || sqlerrm);
1291: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1292: hr_utility.raise_error;
1293: commit;
1294: END;
1295:
1296:
1293: commit;
1294: END;
1295:
1296:
1297: hr_utility.set_location('Sec Group Id is '||fnd_global.security_group_id, 100);
1298:
1299: open csr_bg_ids(l_batch_header_id);
1300: loop
1301: fetch csr_bg_ids into
1309: ,p_organization_id => :4); end;'
1310: USING out l_err_buf, out l_ret_code, l_enterprise_id, l_bg_id;
1311:
1312:
1313: hr_utility.set_location('The label method has been called ', 90);
1314:
1315: -- BEGIN
1316: -- hr_utility.set_location('Before the first execute', 10);
1317: -- EXECUTE IMMEDIATE 'UPDATE hr_all_organization_units
1312:
1313: hr_utility.set_location('The label method has been called ', 90);
1314:
1315: -- BEGIN
1316: -- hr_utility.set_location('Before the first execute', 10);
1317: -- EXECUTE IMMEDIATE 'UPDATE hr_all_organization_units
1318: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'', :1)
1319: -- WHERE organization_id = :2'
1320: -- USING l_label, l_bg_id;
1317: -- EXECUTE IMMEDIATE 'UPDATE hr_all_organization_units
1318: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'', :1)
1319: -- WHERE organization_id = :2'
1320: -- USING l_label, l_bg_id;
1321: -- hr_utility.set_location('After the first execute', 10);
1322: --
1323: -- EXECUTE Immediate 'UPDATE hr_organization_information
1324: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'',:1 )
1325: -- WHERE organization_id = :2'
1324: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'',:1 )
1325: -- WHERE organization_id = :2'
1326: -- USING l_label
1327: -- ,l_bg_id;
1328: -- hr_utility.set_location('After the second execute', 10);
1329: -- EXECUTE IMMEDIATE 'UPDATE per_number_generation_controls
1330: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'', :1)
1331: -- WHERE business_group_id = :2'
1332: -- USING l_label
1330: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'', :1)
1331: -- WHERE business_group_id = :2'
1332: -- USING l_label
1333: -- ,l_bg_id;
1334: -- hr_utility.set_location('After the third execute', 10);
1335: -- EXECUTE IMMEDIATE 'UPDATE hr_all_organization_units_tl
1336: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'', :1)
1337: -- WHERE organization_id = :2'
1338: -- USING l_label, l_bg_id;
1335: -- EXECUTE IMMEDIATE 'UPDATE hr_all_organization_units_tl
1336: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'', :1)
1337: -- WHERE organization_id = :2'
1338: -- USING l_label, l_bg_id;
1339: -- hr_utility.set_location('After the fourth execute', 10);
1340: -- END;
1341:
1342: end loop;
1343: close csr_bg_ids;
1344:
1345: /*fnd_global.set_security_group_id_context(security_group_id
1346: => l_old_sec_group_id);*/
1347: hr_multi_tenancy_pkg.set_context(l_label);
1348: hr_utility.set_location('After change the Sec group id is : ' ||
1349: fnd_global.security_group_id, 90);
1350:
1351: l_batch_name := substr(p_configuration_code || 'third' || ' ' || to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'),1,80);
1352:
1349: fnd_global.security_group_id, 90);
1350:
1351: l_batch_name := substr(p_configuration_code || 'third' || ' ' || to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'),1,80);
1352:
1353: hr_utility.set_location(l_proc, 160);
1354: l_batch_header_id := hr_pump_utils.create_batch_header
1355: (p_batch_name => l_batch_name);
1356: hr_utility.set_location(l_batch_name, 1990);
1357: hr_utility.set_location(l_batch_header_id, 2000);
1352:
1353: hr_utility.set_location(l_proc, 160);
1354: l_batch_header_id := hr_pump_utils.create_batch_header
1355: (p_batch_name => l_batch_name);
1356: hr_utility.set_location(l_batch_name, 1990);
1357: hr_utility.set_location(l_batch_header_id, 2000);
1358: hr_utility.set_location(l_proc, 170);
1359:
1360: END IF;
1353: hr_utility.set_location(l_proc, 160);
1354: l_batch_header_id := hr_pump_utils.create_batch_header
1355: (p_batch_name => l_batch_name);
1356: hr_utility.set_location(l_batch_name, 1990);
1357: hr_utility.set_location(l_batch_header_id, 2000);
1358: hr_utility.set_location(l_proc, 170);
1359:
1360: END IF;
1361: --
1354: l_batch_header_id := hr_pump_utils.create_batch_header
1355: (p_batch_name => l_batch_name);
1356: hr_utility.set_location(l_batch_name, 1990);
1357: hr_utility.set_location(l_batch_header_id, 2000);
1358: hr_utility.set_location(l_proc, 170);
1359:
1360: END IF;
1361: --
1362: -- create enterprise orgs and related classifications
1368: ,p_org_ent_tab => l_org_ent_tab
1369: ,p_org_ent_class_tab => l_org_ent_class_tab
1370: ,p_org_hierarchy_tab => l_org_hierarchy_tab
1371: ,p_profile_dpe_ent_tab => l_profile_dpe_ent_tab);
1372: hr_utility.set_location(l_proc, 200);
1373:
1374:
1375:
1376: --
1382: ,p_technical_summary_mode => l_technical_summary_mode
1383: ,p_org_oc_tab => l_org_oc_tab
1384: ,p_org_oc_class_tab => l_org_oc_class_tab
1385: ,p_org_hierarchy_ele_oc_tab => l_org_hierarchy_ele_oc_tab);
1386: hr_utility.set_location(l_proc, 210);
1387:
1388: --
1389: -- create legal entities orgs and related classifications
1390: --
1394: ,p_technical_summary_mode => l_technical_summary_mode
1395: ,p_org_le_tab => l_org_le_tab
1396: ,p_org_le_class_tab => l_org_le_class_tab
1397: ,p_org_hierarchy_ele_le_tab => l_org_hierarchy_ele_le_tab);
1398: hr_utility.set_location(l_proc, 220);
1399:
1400:
1401:
1402:
1418: end if;
1419:
1420: EXCEPTION
1421: when data_pump_load_failure then
1422: hr_utility.set_location(l_proc, 221);
1423: hr_utility.raise_error;
1424: commit;
1425: when others then
1426: hr_utility.set_location(l_proc, 222);
1419:
1420: EXCEPTION
1421: when data_pump_load_failure then
1422: hr_utility.set_location(l_proc, 221);
1423: hr_utility.raise_error;
1424: commit;
1425: when others then
1426: hr_utility.set_location(l_proc, 222);
1427: p_errbuff := 'Error cooured in loading datapump records';
1422: hr_utility.set_location(l_proc, 221);
1423: hr_utility.raise_error;
1424: commit;
1425: when others then
1426: hr_utility.set_location(l_proc, 222);
1427: p_errbuff := 'Error cooured in loading datapump records';
1428: p_retcode := 2;
1429:
1430: l_error_message := 'Error in ' || l_proc;
1427: p_errbuff := 'Error cooured in loading datapump records';
1428: p_retcode := 2;
1429:
1430: l_error_message := 'Error in ' || l_proc;
1431: --hr_utility.trace(l_error_message || '-' || sqlerrm);
1432: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1433: hr_utility.raise_error;
1434: commit;
1435: END;
1428: p_retcode := 2;
1429:
1430: l_error_message := 'Error in ' || l_proc;
1431: --hr_utility.trace(l_error_message || '-' || sqlerrm);
1432: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1433: hr_utility.raise_error;
1434: commit;
1435: END;
1436:
1429:
1430: l_error_message := 'Error in ' || l_proc;
1431: --hr_utility.trace(l_error_message || '-' || sqlerrm);
1432: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1433: hr_utility.raise_error;
1434: commit;
1435: END;
1436:
1437: hr_utility.set_location(l_proc, 230);
1433: hr_utility.raise_error;
1434: commit;
1435: END;
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
1445: ,p_hrms_resp_main_tab => l_hrms_resp_main_tab
1446: ,p_more_profile_resp_tab => l_more_profile_resp_tab
1447: ,p_more_int_profile_resp_tab => l_more_int_profile_resp_tab);
1448:
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
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:
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: --
1476:
1477:
1478: commit;
1479:
1480: hr_utility.trace('Ending Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
1481: hr_utility.set_location(' Leaving:'|| l_proc, 300);
1482:
1483:
1484:
1477:
1478: commit;
1479:
1480: hr_utility.trace('Ending Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
1481: hr_utility.set_location(' Leaving:'|| l_proc, 300);
1482:
1483:
1484:
1485: EXCEPTION
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);
1492: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1493: hr_utility.raise_error;
1494:
1495: END load_enterprise_configuration;
1488: --raise;
1489: when others then
1490: l_error_message := 'Error in ' || l_proc;
1491: hr_utility.trace(l_error_message || '-' || sqlerrm);
1492: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1493: hr_utility.raise_error;
1494:
1495: END load_enterprise_configuration;
1496:
1489: when others then
1490: l_error_message := 'Error in ' || l_proc;
1491: hr_utility.trace(l_error_message || '-' || sqlerrm);
1492: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1493: hr_utility.raise_error;
1494:
1495: END load_enterprise_configuration;
1496:
1497: END per_ri_config_main;