[Home] [Help]
171:
172: BEGIN
173:
174:
175: hr_utility.set_location('Entering:'|| l_proc, 10);
176:
177: hr_utility.trace('Starting Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
178:
179: -- Set global variable for loader program mode
173:
174:
175: hr_utility.set_location('Entering:'|| l_proc, 10);
176:
177: hr_utility.trace('Starting Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
178:
179: -- Set global variable for loader program mode
180: g_technical_summary_mode := p_technical_summary_mode;
181:
179: -- Set global variable for loader program mode
180: g_technical_summary_mode := p_technical_summary_mode;
181:
182: if g_technical_summary_mode then
183: hr_utility.trace('Technical Summary Mode');
184: end if;
185:
186: l_job_defined := per_ri_config_utilities.jpg_defined
187: (p_configuration_code => p_configuration_code
202: l_grd_rv_defined := per_ri_config_utilities.regional_variance_defined
203: (p_configuration_code => p_configuration_code
204: ,p_rv_type => 'GRD');
205:
206: hr_utility.set_location(l_proc, 20);
207:
208: -- populate enterprise short name global variable
209: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
210: --
216: ,p_user_tab => l_user_tab);
217:
218: p_user_clob := per_ri_config_tech_summary.get_user_sql (l_user_tab);
219:
220: hr_utility.set_location(l_proc, 30);
221:
222: --
223: -- attach default responsibility
224: --
227: ,p_technical_summary_mode => p_technical_summary_mode
228: ,p_resp_tab => l_resp_tab
229: );
230:
231: hr_utility.set_location(l_proc, 40);
232:
233: --
234: -- set site level profile options
235: --
248: (p_configuration_code => p_configuration_code
249: ,p_technical_summary_mode => p_technical_summary_mode
250: ,p_profile_apps_tab => l_profile_apps_tab);
251:
252: hr_utility.set_location(l_proc, 50);
253: --
254: -- add hrms responsibilities to created user.
255: --
256: per_ri_config_fnd_hr_entity.create_hrms_responsibility
259: ,p_technical_summary_mode => p_technical_summary_mode
260: ,p_hrms_resp_tab => l_hrms_resp_tab);
261:
262:
263: hr_utility.set_location(l_proc, 60);
264:
265: --
266: -- add hrms misc responsibilities to created user.
267: --
270: ,p_technical_summary_mode => p_technical_summary_mode
271: ,p_hrms_misc_resp_tab => l_hrms_misc_resp_tab);
272:
273:
274: hr_utility.set_location(l_proc, 65);
275:
276: --
277: -- always create default PEA, GRP and COST KF
278: --
285: ,p_kf_grp_seg_tab => l_kf_grp_seg_tab
286: ,p_kf_cmp_seg_tab => l_kf_cmp_seg_tab
287: ,p_kf_cost_seg_tab => l_kf_cost_seg_tab
288: );
289: hr_utility.set_location(l_proc, 70);
290:
291:
292: --
293: -- make decisions about job, positions and grades
294: --
295:
296: --jobs/positions not defined
297: if NOT l_job_defined and NOT l_pos_defined then
298: hr_utility.trace('Jobs/Positions NOT defined');
299: --
300: -- create global jobs and positions
301: --
302: per_ri_config_fnd_hr_entity.create_global_job_pos_kf
306: ,p_kf_pos_tab => l_kf_pos_tab
307: ,p_kf_job_seg_tab => l_kf_job_seg_tab
308: ,p_kf_pos_seg_tab => l_kf_pos_seg_tab
309: );
310: hr_utility.set_location(l_proc, 80);
311: end if;
312:
313: --when positions not defined - this case comes when
314: -- user has selected only job in RV section.
313: --when positions not defined - this case comes when
314: -- user has selected only job in RV section.
315:
316: if NOT l_pos_defined then
317: hr_utility.trace('Positions NOT defined');
318: --
319: -- create global positions
320: --
321: per_ri_config_fnd_hr_entity.create_global_pos_kf
323: ,p_technical_summary_mode => p_technical_summary_mode
324: ,p_kf_pos_tab => l_kf_pos_tab
325: ,p_kf_pos_seg_tab => l_kf_pos_seg_tab
326: );
327: hr_utility.set_location(l_proc, 85);
328: end if;
329: --grades are not defined
330: if NOT l_grd_defined then
331: hr_utility.trace('Grades NOT defined');
327: hr_utility.set_location(l_proc, 85);
328: end if;
329: --grades are not defined
330: if NOT l_grd_defined then
331: hr_utility.trace('Grades NOT defined');
332: --
333: -- create global grades
334: --
335: per_ri_config_fnd_hr_entity.create_global_grd_kf
337: ,p_technical_summary_mode => p_technical_summary_mode
338: ,p_kf_grd_tab => l_kf_grd_tab
339: ,p_kf_grd_seg_tab => l_kf_grd_seg_tab
340: );
341: hr_utility.set_location(l_proc, 90);
342: end if;
343:
344: -- jobs defined (including RVs)
345: if l_job_defined or l_jp_rv_defined then
342: end if;
343:
344: -- jobs defined (including RVs)
345: if l_job_defined or l_jp_rv_defined then
346: hr_utility.trace('Jobs defined');
347: --
348: -- create jobs with no rvs
349: --
350: per_ri_config_fnd_hr_entity.create_jobs_no_rv_keyflex
352: ,p_technical_summary_mode => p_technical_summary_mode
353: ,p_kf_job_no_rv_tab => l_kf_job_no_rv_tab
354: ,p_kf_job_no_rv_seg_tab => l_kf_job_no_rv_seg_tab
355: );
356: hr_utility.set_location(l_proc, 100);
357: -- create jobs with rvs
358: --
359: per_ri_config_fnd_hr_entity.create_jobs_rv_keyflex
360: (p_configuration_code => p_configuration_code
361: ,p_technical_summary_mode => p_technical_summary_mode
362: ,p_kf_job_rv_tab => l_kf_job_rv_tab
363: ,p_kf_job_rv_seg_tab => l_kf_job_rv_seg_tab
364: );
365: hr_utility.set_location(l_proc, 110);
366: end if;
367:
368: -- Positions defined (including RVs)
369: if l_pos_defined or (l_pos_defined and l_jp_rv_defined) then -- fix for 4522666
366: end if;
367:
368: -- Positions defined (including RVs)
369: if l_pos_defined or (l_pos_defined and l_jp_rv_defined) then -- fix for 4522666
370: hr_utility.trace('Positions IS defined');
371: --
372: -- create positions with no rvs
373: --
374: per_ri_config_fnd_hr_entity.create_positions_no_rv_keyflex
376: ,p_technical_summary_mode => p_technical_summary_mode
377: ,p_kf_pos_no_rv_tab => l_kf_pos_no_rv_tab
378: ,p_kf_pos_no_rv_seg_tab => l_kf_pos_no_rv_seg_tab
379: );
380: hr_utility.set_location(l_proc, 120);
381: --
382: -- create positions with rvs
383: --
384: per_ri_config_fnd_hr_entity.create_positions_rv_keyflex
386: ,p_technical_summary_mode => p_technical_summary_mode
387: ,p_kf_pos_rv_tab => l_kf_pos_rv_tab
388: ,p_kf_pos_rv_seg_tab => l_kf_pos_rv_seg_tab
389: );
390: hr_utility.set_location(l_proc, 130);
391: end if;
392:
393: -- Grades defined (including RVs)
394: if l_grd_defined or l_grd_rv_defined then
391: end if;
392:
393: -- Grades defined (including RVs)
394: if l_grd_defined or l_grd_rv_defined then
395: hr_utility.trace('Grades IS defined');
396: --
397: -- create grades with no rvs
398: --
399: per_ri_config_fnd_hr_entity.create_grades_no_rv_keyflex
401: ,p_technical_summary_mode => p_technical_summary_mode
402: ,p_kf_grd_no_rv_tab => l_kf_grd_no_rv_tab
403: ,p_kf_grd_no_rv_seg_tab => l_kf_grd_no_rv_seg_tab
404: );
405: hr_utility.set_location(l_proc, 140);
406: --
407: -- create grades with rvs
408: --
409: per_ri_config_fnd_hr_entity.create_grades_rv_keyflex
411: ,p_technical_summary_mode => p_technical_summary_mode
412: ,p_kf_grd_rv_tab => l_kf_grd_rv_tab
413: ,p_kf_grd_rv_seg_tab => l_kf_grd_rv_seg_tab
414: );
415: hr_utility.set_location(l_proc, 150);
416: end if;
417:
418: -- Get Keyflex and Segments
419: p_key_str_clob := per_ri_config_tech_summary.get_keyflex_structure_sql
489: p_kf_grp_seg_clob := l_kf_grp_seg_clob;
490: p_kf_cmp_seg_clob := l_kf_cmp_seg_clob;
491: p_kf_cost_seg_clob := l_kf_cost_seg_clob;
492:
493: hr_utility.set_location(l_proc, 170);
494: --
495: -- create locations
496: --
497: per_ri_config_datapump_entity.create_locations_batch_lines
503:
504: p_location_clob := per_ri_config_tech_summary.get_locations_sql (p_location_tab => l_location_tab) ;
505:
506:
507: hr_utility.set_location(l_proc, 180);
508:
509:
510: --
511: -- create business groups
527: );
528: p_post_install_clob := per_ri_config_tech_summary.get_post_install_sql(
529: p_post_install_tab =>l_post_install_tab
530: );
531: hr_utility.set_location(l_proc, 190);
532: --
533: -- create enterprise orgs and related classifications
534: --
535: per_ri_config_datapump_entity.create_enterprise_batch_lines
549: p_site_profile_clob := per_ri_config_tech_summary.get_profile_sql (
550: p_profile_tab => l_profile_tab
551: ,p_profile_dpe_ent_tab => l_profile_dpe_ent_tab
552: );
553: hr_utility.set_location(l_proc, 200);
554:
555: --
556: -- create operating companies orgs and related classifications
557: --
561: ,p_technical_summary_mode => p_technical_summary_mode
562: ,p_org_oc_tab => l_org_oc_tab
563: ,p_org_oc_class_tab => l_org_oc_class_tab
564: ,p_org_hierarchy_ele_oc_tab => l_org_hierarchy_ele_oc_tab);
565: hr_utility.set_location(l_proc, 200);
566: hr_utility.set_location(l_proc, 210);
567:
568: --
569: -- create legal entities orgs and related classifications
562: ,p_org_oc_tab => l_org_oc_tab
563: ,p_org_oc_class_tab => l_org_oc_class_tab
564: ,p_org_hierarchy_ele_oc_tab => l_org_hierarchy_ele_oc_tab);
565: hr_utility.set_location(l_proc, 200);
566: hr_utility.set_location(l_proc, 210);
567:
568: --
569: -- create legal entities orgs and related classifications
570: --
575: ,p_org_le_tab => l_org_le_tab
576: ,p_org_le_class_tab => l_org_le_class_tab
577: ,p_org_hierarchy_ele_le_tab => l_org_hierarchy_ele_le_tab);
578:
579: hr_utility.set_location(l_proc, 220);
580:
581: p_organization_clob := per_ri_config_tech_summary.get_org_sql
582: (p_org_ent_tab => l_org_ent_tab
583: ,p_org_oc_tab => l_org_oc_tab
634: ,p_kf_cmp_seg_tab => l_kf_cmp_seg_tab
635: ,p_kf_cost_seg_tab => l_kf_cost_seg_tab
636: );
637:
638: hr_utility.set_location(l_proc, 230);
639:
640: per_ri_config_utilities.create_more_hrms_resps
641: (p_configuration_code => p_configuration_code
642: ,p_security_profile_tab => l_security_profile_tab
658: -- Security Group Removal Chnages
659: --per_ri_config_utilities.create_security_profile_assign
660: -- (p_security_profile_tab => l_security_profile_tab);
661:
662: hr_utility.set_location(' Leaving:'|| l_proc, 250);
663:
664: per_ri_config_utilities.submit_int_payroll_request
665: (errbuf => l_errbuf
666: ,retcode => l_retcode
671:
672: p_int_hrms_clob := per_ri_config_tech_summary.get_int_hrms_setup_sql
673: (p_int_hrms_setup_tab => l_int_hrms_setup_tab);
674:
675: hr_utility.set_location(l_proc, 240);
676:
677: rollback;
678:
679: hr_utility.trace('Ending Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
675: hr_utility.set_location(l_proc, 240);
676:
677: rollback;
678:
679: hr_utility.trace('Ending Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
680: hr_utility.set_location(' Leaving:'|| l_proc, 300);
681:
682: EXCEPTION
683: --when not_fresh_install then
676:
677: rollback;
678:
679: hr_utility.trace('Ending Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
680: hr_utility.set_location(' Leaving:'|| l_proc, 300);
681:
682: EXCEPTION
683: --when not_fresh_install then
684: --per_ri_config_utilities.write_log(p_message => l_log_message);
684: --per_ri_config_utilities.write_log(p_message => l_log_message);
685: --raise;
686: when others then
687: l_error_message := 'Error in ' || l_proc;
688: hr_utility.trace(l_error_message || '-' || sqlerrm);
689: hr_utility.set_location(' Leaving:'|| l_proc, 500);
690: hr_utility.raise_error;
691:
692: END create_technical_summary;
685: --raise;
686: when others then
687: l_error_message := 'Error in ' || l_proc;
688: hr_utility.trace(l_error_message || '-' || sqlerrm);
689: hr_utility.set_location(' Leaving:'|| l_proc, 500);
690: hr_utility.raise_error;
691:
692: END create_technical_summary;
693:
686: when others then
687: l_error_message := 'Error in ' || l_proc;
688: hr_utility.trace(l_error_message || '-' || sqlerrm);
689: hr_utility.set_location(' Leaving:'|| l_proc, 500);
690: hr_utility.raise_error;
691:
692: END create_technical_summary;
693:
694:
796:
797: BEGIN
798:
799:
800: hr_utility.set_location('Entering:'|| l_proc, 10);
801:
802: hr_utility.trace('Starting Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
803:
804: --Check Whether multiTenancy is enabled or not
798:
799:
800: hr_utility.set_location('Entering:'|| l_proc, 10);
801:
802: hr_utility.trace('Starting Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
803:
804: --Check Whether multiTenancy is enabled or not
805: l_multi_tenancy := hr_multi_tenancy_pkg.is_multi_tenant_system;
806: l_sec_group_id := fnd_global.security_group_id;
815: EXCEPTION
816: WHEN NO_DATA_FOUND THEN
817: l_enterprise_id := null;
818: END;
819: hr_utility.set_location('Enterprise Id is ' || l_enterprise_id, 78);
820: hr_utility.set_location('BEFORE SEC GROUP ID IS : '||fnd_global.security_group_id, 78);
821: l_old_sec_group_id := fnd_global.security_group_id;
822: BEGIN
823: select 'C::'||enterprise_label into l_label from per_ent_security_groups
816: WHEN NO_DATA_FOUND THEN
817: l_enterprise_id := null;
818: END;
819: hr_utility.set_location('Enterprise Id is ' || l_enterprise_id, 78);
820: hr_utility.set_location('BEFORE SEC GROUP ID IS : '||fnd_global.security_group_id, 78);
821: l_old_sec_group_id := fnd_global.security_group_id;
822: BEGIN
823: select 'C::'||enterprise_label into l_label from per_ent_security_groups
824: where security_group_id = fnd_global.security_group_id;
821: l_old_sec_group_id := fnd_global.security_group_id;
822: BEGIN
823: select 'C::'||enterprise_label into l_label from per_ent_security_groups
824: where security_group_id = fnd_global.security_group_id;
825: hr_utility.set_location('Sec Group Id is '||fnd_global.security_group_id, 100) ;
826: EXCEPTION
827: WHEN NO_DATA_FOUND THEN
828: l_label := null;
829: END;
881: l_grd_rv_defined := per_ri_config_utilities.regional_variance_defined
882: (p_configuration_code => p_configuration_code
883: ,p_rv_type => 'GRD');
884:
885: hr_utility.set_location(l_proc, 20);
886:
887: -- populate enterprise short name global variable
888: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
889: --
903: (p_configuration_code => p_configuration_code
904: ,p_technical_summary_mode => l_technical_summary_mode
905: ,p_resp_tab => l_resp_tab
906: );
907: hr_utility.set_location(l_proc, 40);
908:
909: --
910: -- set site level profile options
911: --
920: per_ri_config_fnd_hr_entity.create_application_level_resp
921: (p_configuration_code => p_configuration_code
922: ,p_technical_summary_mode => l_technical_summary_mode
923: ,p_profile_apps_tab => l_profile_apps_tab);
924: hr_utility.set_location(l_proc, 50);
925: --
926: -- add hrms responsibilities to created user.
927: --
928: per_ri_config_fnd_hr_entity.create_hrms_responsibility
930: ,p_security_profile_tab => l_security_profile_tab
931: ,p_technical_summary_mode => l_technical_summary_mode
932: ,p_hrms_resp_tab => l_hrms_resp_tab);
933:
934: hr_utility.set_location(l_proc, 60);
935:
936: --
937: -- add hrms misc responsibilities to created user.
938: --
941: ,p_technical_summary_mode => l_technical_summary_mode
942: ,p_hrms_misc_resp_tab => l_hrms_misc_resp_tab);
943:
944:
945: hr_utility.set_location(l_proc, 65);
946:
947: --
948: -- always create default PEA, GRP and COST KF
949: --
957: ,p_kf_cmp_seg_tab => l_kf_cmp_seg_tab
958: ,p_kf_cost_seg_tab => l_kf_cost_seg_tab
959: );
960:
961: hr_utility.set_location(l_proc, 70);
962:
963:
964: --
965: -- make decisions about job, positions and grades
966: --
967:
968: --jobs/positions not defined
969: if NOT l_job_defined and NOT l_pos_defined then
970: hr_utility.trace('Jobs/Positions NOT defined');
971: --
972: -- create global jobs and positions
973: --
974: per_ri_config_fnd_hr_entity.create_global_job_pos_kf
978: ,p_kf_pos_tab => l_kf_pos_tab
979: ,p_kf_job_seg_tab => l_kf_job_seg_tab
980: ,p_kf_pos_seg_tab => l_kf_pos_seg_tab
981: );
982: hr_utility.set_location(l_proc, 80);
983: end if;
984:
985: --when positions not defined - this case comes when
986: --user has selected only job in RV section.
985: --when positions not defined - this case comes when
986: --user has selected only job in RV section.
987:
988: if NOT l_pos_defined then
989: hr_utility.trace('Positions NOT defined');
990: --
991: -- create global positions
992: --
993: per_ri_config_fnd_hr_entity.create_global_pos_kf
995: ,p_technical_summary_mode => l_technical_summary_mode
996: ,p_kf_pos_tab => l_kf_pos_tab
997: ,p_kf_pos_seg_tab => l_kf_pos_seg_tab
998: );
999: hr_utility.set_location(l_proc, 85);
1000: end if;
1001: --grades are not defined
1002: if NOT l_grd_defined then
1003: hr_utility.trace('Grades NOT defined');
999: hr_utility.set_location(l_proc, 85);
1000: end if;
1001: --grades are not defined
1002: if NOT l_grd_defined then
1003: hr_utility.trace('Grades NOT defined');
1004: --
1005: -- create global grades
1006: --
1007: per_ri_config_fnd_hr_entity.create_global_grd_kf
1009: ,p_technical_summary_mode => l_technical_summary_mode
1010: ,p_kf_grd_tab => l_kf_grd_tab
1011: ,p_kf_grd_seg_tab => l_kf_grd_seg_tab
1012: );
1013: hr_utility.set_location(l_proc, 90);
1014: end if;
1015:
1016: -- jobs defined (including RVs)
1017: if l_job_defined or l_jp_rv_defined then
1014: end if;
1015:
1016: -- jobs defined (including RVs)
1017: if l_job_defined or l_jp_rv_defined then
1018: hr_utility.trace('Jobs defined');
1019: --
1020: -- create jobs with no rvs
1021: --
1022: per_ri_config_fnd_hr_entity.create_jobs_no_rv_keyflex
1024: ,p_technical_summary_mode => l_technical_summary_mode
1025: ,p_kf_job_no_rv_tab => l_kf_job_no_rv_tab
1026: ,p_kf_job_no_rv_seg_tab => l_kf_job_no_rv_seg_tab
1027: );
1028: hr_utility.set_location(l_proc, 100);
1029: -- create jobs with rvs
1030: --
1031: per_ri_config_fnd_hr_entity.create_jobs_rv_keyflex
1032: (p_configuration_code => p_configuration_code
1033: ,p_technical_summary_mode => l_technical_summary_mode
1034: ,p_kf_job_rv_tab => l_kf_job_rv_tab
1035: ,p_kf_job_rv_seg_tab => l_kf_job_rv_seg_tab
1036: );
1037: hr_utility.set_location(l_proc, 110);
1038: end if;
1039:
1040: -- Positions defined (including RVs)
1041: if l_pos_defined or (l_pos_defined and l_jp_rv_defined) then -- fix for 4522666
1038: end if;
1039:
1040: -- Positions defined (including RVs)
1041: if l_pos_defined or (l_pos_defined and l_jp_rv_defined) then -- fix for 4522666
1042: hr_utility.trace('Positions IS defined');
1043: --
1044: -- create positions with no rvs
1045: --
1046: per_ri_config_fnd_hr_entity.create_positions_no_rv_keyflex
1048: ,p_technical_summary_mode => l_technical_summary_mode
1049: ,p_kf_pos_no_rv_tab => l_kf_pos_no_rv_tab
1050: ,p_kf_pos_no_rv_seg_tab => l_kf_pos_no_rv_seg_tab
1051: );
1052: hr_utility.set_location(l_proc, 120);
1053: --
1054: -- create positions with rvs
1055: --
1056: per_ri_config_fnd_hr_entity.create_positions_rv_keyflex
1058: ,p_technical_summary_mode => l_technical_summary_mode
1059: ,p_kf_pos_rv_tab => l_kf_pos_rv_tab
1060: ,p_kf_pos_rv_seg_tab => l_kf_pos_rv_seg_tab
1061: );
1062: hr_utility.set_location(l_proc, 130);
1063:
1064: end if;
1065:
1066: -- Grades defined (including RVs)
1064: end if;
1065:
1066: -- Grades defined (including RVs)
1067: if l_grd_defined or l_grd_rv_defined then
1068: hr_utility.trace('Grades IS defined');
1069: --
1070: -- create grades with no rvs
1071: --
1072: per_ri_config_fnd_hr_entity.create_grades_no_rv_keyflex
1074: ,p_technical_summary_mode => l_technical_summary_mode
1075: ,p_kf_grd_no_rv_tab => l_kf_grd_no_rv_tab
1076: ,p_kf_grd_no_rv_seg_tab => l_kf_grd_no_rv_seg_tab
1077: );
1078: hr_utility.set_location(l_proc, 140);
1079: --
1080: -- create grades with rvs
1081: --
1082: per_ri_config_fnd_hr_entity.create_grades_rv_keyflex
1084: ,p_technical_summary_mode => l_technical_summary_mode
1085: ,p_kf_grd_rv_tab => l_kf_grd_rv_tab
1086: ,p_kf_grd_rv_seg_tab => l_kf_grd_rv_seg_tab
1087: );
1088: hr_utility.set_location(l_proc, 150);
1089: end if;
1090:
1091:
1092: --
1092: --
1093: -- create batch header
1094: l_batch_name := substr(p_configuration_code || ' ' || to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'),1,80);
1095:
1096: hr_utility.set_location(l_proc, 160);
1097: l_batch_header_id := hr_pump_utils.create_batch_header
1098: (p_batch_name => l_batch_name);
1099: hr_utility.set_location(l_batch_name, 1990);
1100: hr_utility.set_location(l_batch_header_id, 2000);
1095:
1096: hr_utility.set_location(l_proc, 160);
1097: l_batch_header_id := hr_pump_utils.create_batch_header
1098: (p_batch_name => l_batch_name);
1099: hr_utility.set_location(l_batch_name, 1990);
1100: hr_utility.set_location(l_batch_header_id, 2000);
1101: hr_utility.set_location(l_proc, 170);
1102: --
1103: -- create locations
1096: hr_utility.set_location(l_proc, 160);
1097: l_batch_header_id := hr_pump_utils.create_batch_header
1098: (p_batch_name => l_batch_name);
1099: hr_utility.set_location(l_batch_name, 1990);
1100: hr_utility.set_location(l_batch_header_id, 2000);
1101: hr_utility.set_location(l_proc, 170);
1102: --
1103: -- create locations
1104: --
1097: l_batch_header_id := hr_pump_utils.create_batch_header
1098: (p_batch_name => l_batch_name);
1099: hr_utility.set_location(l_batch_name, 1990);
1100: hr_utility.set_location(l_batch_header_id, 2000);
1101: hr_utility.set_location(l_proc, 170);
1102: --
1103: -- create locations
1104: --
1105: per_ri_config_datapump_entity.create_locations_batch_lines
1107: ,p_batch_header_id => l_batch_header_id
1108: ,p_technical_summary_mode => l_technical_summary_mode
1109: ,p_location_tab => l_location_tab
1110: );
1111: hr_utility.set_location(l_proc, 180);
1112:
1113:
1114: --
1115: -- create business groups
1124: ,p_sg_tab => l_sg_tab
1125: ,p_post_install_tab => l_post_install_tab
1126: ,p_int_bg_resp_tab => l_int_bg_resp_tab);
1127:
1128: hr_utility.set_location(l_proc, 190);
1129:
1130: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1131: AND l_enterprise_id IS NOT NULL
1132: THEN
1129:
1130: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1131: AND l_enterprise_id IS NOT NULL
1132: THEN
1133: hr_utility.set_location('DP is getting run before hand ', 76);
1134: BEGIN
1135: --
1136: -- run data pump to load hrms entities into schema
1137: --
1148: end if;
1149:
1150: EXCEPTION
1151: when data_pump_load_failure then
1152: hr_utility.set_location(l_proc, 221);
1153: hr_utility.raise_error;
1154: commit;
1155: when others then
1156: hr_utility.set_location(l_proc, 222);
1149:
1150: EXCEPTION
1151: when data_pump_load_failure then
1152: hr_utility.set_location(l_proc, 221);
1153: hr_utility.raise_error;
1154: commit;
1155: when others then
1156: hr_utility.set_location(l_proc, 222);
1157: p_errbuff := 'Error cooured in loading datapump records';
1152: hr_utility.set_location(l_proc, 221);
1153: hr_utility.raise_error;
1154: commit;
1155: when others then
1156: hr_utility.set_location(l_proc, 222);
1157: p_errbuff := 'Error cooured in loading datapump records';
1158: p_retcode := 2;
1159:
1160: l_error_message := 'Error in ' || l_proc;
1157: p_errbuff := 'Error cooured in loading datapump records';
1158: p_retcode := 2;
1159:
1160: l_error_message := 'Error in ' || l_proc;
1161: --hr_utility.trace(l_error_message || '-' || sqlerrm);
1162: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1163: hr_utility.raise_error;
1164: commit;
1165: END;
1158: p_retcode := 2;
1159:
1160: l_error_message := 'Error in ' || l_proc;
1161: --hr_utility.trace(l_error_message || '-' || sqlerrm);
1162: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1163: hr_utility.raise_error;
1164: commit;
1165: END;
1166:
1159:
1160: l_error_message := 'Error in ' || l_proc;
1161: --hr_utility.trace(l_error_message || '-' || sqlerrm);
1162: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1163: hr_utility.raise_error;
1164: commit;
1165: END;
1166:
1167:
1164: commit;
1165: END;
1166:
1167:
1168: hr_utility.set_location('Sec Group Id is '||fnd_global.security_group_id, 100);
1169:
1170: open csr_bg_ids(l_batch_header_id);
1171: loop
1172: fetch csr_bg_ids into
1180: ,p_organization_id => :4); end;'
1181: USING out l_err_buf, out l_ret_code, l_enterprise_id, l_bg_id;
1182:
1183:
1184: hr_utility.set_location('The label method has been called ', 90);
1185:
1186: -- BEGIN
1187: -- hr_utility.set_location('Before the first execute', 10);
1188: -- EXECUTE IMMEDIATE 'UPDATE hr_all_organization_units
1183:
1184: hr_utility.set_location('The label method has been called ', 90);
1185:
1186: -- BEGIN
1187: -- hr_utility.set_location('Before the first execute', 10);
1188: -- EXECUTE IMMEDIATE 'UPDATE hr_all_organization_units
1189: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'', :1)
1190: -- WHERE organization_id = :2'
1191: -- USING l_label, l_bg_id;
1188: -- EXECUTE IMMEDIATE 'UPDATE hr_all_organization_units
1189: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'', :1)
1190: -- WHERE organization_id = :2'
1191: -- USING l_label, l_bg_id;
1192: -- hr_utility.set_location('After the first execute', 10);
1193: --
1194: -- EXECUTE Immediate 'UPDATE hr_organization_information
1195: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'',:1 )
1196: -- WHERE organization_id = :2'
1195: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'',:1 )
1196: -- WHERE organization_id = :2'
1197: -- USING l_label
1198: -- ,l_bg_id;
1199: -- hr_utility.set_location('After the second execute', 10);
1200: -- EXECUTE IMMEDIATE 'UPDATE per_number_generation_controls
1201: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'', :1)
1202: -- WHERE business_group_id = :2'
1203: -- USING l_label
1201: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'', :1)
1202: -- WHERE business_group_id = :2'
1203: -- USING l_label
1204: -- ,l_bg_id;
1205: -- hr_utility.set_location('After the third execute', 10);
1206: -- EXECUTE IMMEDIATE 'UPDATE hr_all_organization_units_tl
1207: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'', :1)
1208: -- WHERE organization_id = :2'
1209: -- USING l_label, l_bg_id;
1206: -- EXECUTE IMMEDIATE 'UPDATE hr_all_organization_units_tl
1207: -- SET hr_enterprise = char_to_label(''HR_ENTERPRISE_POLICY'', :1)
1208: -- WHERE organization_id = :2'
1209: -- USING l_label, l_bg_id;
1210: -- hr_utility.set_location('After the fourth execute', 10);
1211: -- END;
1212:
1213: end loop;
1214: close csr_bg_ids;
1214: close csr_bg_ids;
1215:
1216: fnd_global.set_security_group_id_context(security_group_id
1217: => l_old_sec_group_id);
1218: hr_utility.set_location('After change the Sec group id is : ' ||
1219: fnd_global.security_group_id, 90);
1220:
1221: l_batch_name := substr(p_configuration_code || 'second' || ' ' || to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'),1,80);
1222:
1219: fnd_global.security_group_id, 90);
1220:
1221: l_batch_name := substr(p_configuration_code || 'second' || ' ' || to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'),1,80);
1222:
1223: hr_utility.set_location(l_proc, 160);
1224: l_batch_header_id := hr_pump_utils.create_batch_header
1225: (p_batch_name => l_batch_name);
1226: hr_utility.set_location(l_batch_name, 1990);
1227: hr_utility.set_location(l_batch_header_id, 2000);
1222:
1223: hr_utility.set_location(l_proc, 160);
1224: l_batch_header_id := hr_pump_utils.create_batch_header
1225: (p_batch_name => l_batch_name);
1226: hr_utility.set_location(l_batch_name, 1990);
1227: hr_utility.set_location(l_batch_header_id, 2000);
1228: hr_utility.set_location(l_proc, 170);
1229:
1230: END IF;
1223: hr_utility.set_location(l_proc, 160);
1224: l_batch_header_id := hr_pump_utils.create_batch_header
1225: (p_batch_name => l_batch_name);
1226: hr_utility.set_location(l_batch_name, 1990);
1227: hr_utility.set_location(l_batch_header_id, 2000);
1228: hr_utility.set_location(l_proc, 170);
1229:
1230: END IF;
1231: --
1224: l_batch_header_id := hr_pump_utils.create_batch_header
1225: (p_batch_name => l_batch_name);
1226: hr_utility.set_location(l_batch_name, 1990);
1227: hr_utility.set_location(l_batch_header_id, 2000);
1228: hr_utility.set_location(l_proc, 170);
1229:
1230: END IF;
1231: --
1232: -- create enterprise orgs and related classifications
1238: ,p_org_ent_tab => l_org_ent_tab
1239: ,p_org_ent_class_tab => l_org_ent_class_tab
1240: ,p_org_hierarchy_tab => l_org_hierarchy_tab
1241: ,p_profile_dpe_ent_tab => l_profile_dpe_ent_tab);
1242: hr_utility.set_location(l_proc, 200);
1243:
1244:
1245:
1246: --
1252: ,p_technical_summary_mode => l_technical_summary_mode
1253: ,p_org_oc_tab => l_org_oc_tab
1254: ,p_org_oc_class_tab => l_org_oc_class_tab
1255: ,p_org_hierarchy_ele_oc_tab => l_org_hierarchy_ele_oc_tab);
1256: hr_utility.set_location(l_proc, 210);
1257:
1258: --
1259: -- create legal entities orgs and related classifications
1260: --
1264: ,p_technical_summary_mode => l_technical_summary_mode
1265: ,p_org_le_tab => l_org_le_tab
1266: ,p_org_le_class_tab => l_org_le_class_tab
1267: ,p_org_hierarchy_ele_le_tab => l_org_hierarchy_ele_le_tab);
1268: hr_utility.set_location(l_proc, 220);
1269:
1270:
1271:
1272:
1288: end if;
1289:
1290: EXCEPTION
1291: when data_pump_load_failure then
1292: hr_utility.set_location(l_proc, 221);
1293: hr_utility.raise_error;
1294: commit;
1295: when others then
1296: hr_utility.set_location(l_proc, 222);
1289:
1290: EXCEPTION
1291: when data_pump_load_failure then
1292: hr_utility.set_location(l_proc, 221);
1293: hr_utility.raise_error;
1294: commit;
1295: when others then
1296: hr_utility.set_location(l_proc, 222);
1297: p_errbuff := 'Error cooured in loading datapump records';
1292: hr_utility.set_location(l_proc, 221);
1293: hr_utility.raise_error;
1294: commit;
1295: when others then
1296: hr_utility.set_location(l_proc, 222);
1297: p_errbuff := 'Error cooured in loading datapump records';
1298: p_retcode := 2;
1299:
1300: l_error_message := 'Error in ' || l_proc;
1297: p_errbuff := 'Error cooured in loading datapump records';
1298: p_retcode := 2;
1299:
1300: l_error_message := 'Error in ' || l_proc;
1301: --hr_utility.trace(l_error_message || '-' || sqlerrm);
1302: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1303: hr_utility.raise_error;
1304: commit;
1305: END;
1298: p_retcode := 2;
1299:
1300: l_error_message := 'Error in ' || l_proc;
1301: --hr_utility.trace(l_error_message || '-' || sqlerrm);
1302: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1303: hr_utility.raise_error;
1304: commit;
1305: END;
1306:
1299:
1300: l_error_message := 'Error in ' || l_proc;
1301: --hr_utility.trace(l_error_message || '-' || sqlerrm);
1302: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1303: hr_utility.raise_error;
1304: commit;
1305: END;
1306:
1307: hr_utility.set_location(l_proc, 230);
1303: hr_utility.raise_error;
1304: commit;
1305: END;
1306:
1307: hr_utility.set_location(l_proc, 230);
1308:
1309:
1310: per_ri_config_utilities.create_more_hrms_resps
1311: (p_configuration_code => p_configuration_code
1315: ,p_hrms_resp_main_tab => l_hrms_resp_main_tab
1316: ,p_more_profile_resp_tab => l_more_profile_resp_tab
1317: ,p_more_int_profile_resp_tab => l_more_int_profile_resp_tab);
1318:
1319: hr_utility.set_location(' Leaving:'|| l_proc, 250);
1320:
1321: -- Security Group Removal Changes
1322: --
1323: --per_ri_config_utilities.create_security_profile_assign
1322: --
1323: --per_ri_config_utilities.create_security_profile_assign
1324: --(p_security_profile_tab => l_security_profile_tab);
1325:
1326: hr_utility.set_location(' Leaving:'|| l_proc, 250);
1327:
1328: per_ri_config_utilities.submit_int_payroll_request
1329: (errbuf => l_errbuf
1330: ,retcode => l_retcode
1331: ,p_country_tab => l_country_tab
1332: ,p_technical_summary_mode => l_technical_summary_mode
1333: ,p_int_hrms_setup_tab => l_int_hrms_setup_tab
1334: );
1335: hr_utility.set_location(l_proc, 240);
1336:
1337: per_ri_config_utilities.update_configuration_status(p_configuration_code);
1338:
1339: --
1346:
1347:
1348: commit;
1349:
1350: hr_utility.trace('Ending Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
1351: hr_utility.set_location(' Leaving:'|| l_proc, 300);
1352:
1353:
1354:
1347:
1348: commit;
1349:
1350: hr_utility.trace('Ending Time = ' || to_char(sysdate,'DD-Mon-YYYY HH24:MI:SS'));
1351: hr_utility.set_location(' Leaving:'|| l_proc, 300);
1352:
1353:
1354:
1355: EXCEPTION
1357: --per_ri_config_utilities.write_log(p_message => l_log_message);
1358: --raise;
1359: when others then
1360: l_error_message := 'Error in ' || l_proc;
1361: hr_utility.trace(l_error_message || '-' || sqlerrm);
1362: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1363: hr_utility.raise_error;
1364:
1365: END load_enterprise_configuration;
1358: --raise;
1359: when others then
1360: l_error_message := 'Error in ' || l_proc;
1361: hr_utility.trace(l_error_message || '-' || sqlerrm);
1362: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1363: hr_utility.raise_error;
1364:
1365: END load_enterprise_configuration;
1366:
1359: when others then
1360: l_error_message := 'Error in ' || l_proc;
1361: hr_utility.trace(l_error_message || '-' || sqlerrm);
1362: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1363: hr_utility.raise_error;
1364:
1365: END load_enterprise_configuration;
1366:
1367: END per_ri_config_main;