DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_MAIN dependencies on PER_RI_CONFIG_UTILITIES

Line 56: per_ri_config_utilities.business_group_decision(configuration_code,country_code)

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';

Line 215: l_job_defined := per_ri_config_utilities.jpg_defined

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

Line 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

Line 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

Line 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

Line 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);

Line 238: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);

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

Line 297: per_ri_config_utilities.assign_misc_responsibility

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:

Line 694: per_ri_config_utilities.create_more_hrms_resps

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

Line 713: --per_ri_config_utilities.create_security_profile_assign

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:

Line 718: per_ri_config_utilities.submit_int_payroll_request

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

Line 738: --per_ri_config_utilities.write_log(p_message => l_log_message);

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);

Line 761: per_ri_config_utilities.business_group_decision(configuration_code,country_code)

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:

Line 896: l_fresh_installed := per_ri_config_utilities.check_fresh_installation;

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:

Line 902: per_ri_config_utilities.write_log(p_message => l_log_message);

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:

Line 905: per_ri_config_utilities.write_log(p_message => l_log_message);

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:

Line 908: per_ri_config_utilities.write_log(p_message => l_log_message);

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:

Line 911: per_ri_config_utilities.write_log(p_message => l_log_message);

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;

Line 914: per_ri_config_utilities.write_log(p_message => l_log_message);

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

Line 923: per_ri_config_utilities.write_log(p_message => l_log_message);

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:

Line 926: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);

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');

Line 928: l_job_defined := per_ri_config_utilities.jpg_defined

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

Line 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

Line 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

Line 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

Line 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);

Line 951: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);

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

Line 1002: per_ri_config_utilities.assign_misc_responsibility

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:

Line 1210: l_data_pump_exception := per_ri_config_utilities.check_data_pump_exception(p_patch_header_id => l_batch_header_id);

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;

Line 1212: per_ri_config_utilities.write_data_pump_exception_log(p_patch_header_id => l_batch_header_id);

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

Line 1273: l_data_pump_exception := per_ri_config_utilities.check_data_pump_exception(p_patch_header_id => l_batch_header_id);

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;

Line 1275: per_ri_config_utilities.write_data_pump_exception_log(p_patch_header_id => l_batch_header_id);

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

Line 1414: l_data_pump_exception := per_ri_config_utilities.check_data_pump_exception(p_patch_header_id => l_batch_header_id);

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;

Line 1416: per_ri_config_utilities.write_data_pump_exception_log(p_patch_header_id => l_batch_header_id);

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

Line 1440: per_ri_config_utilities.create_more_hrms_resps

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

Line 1453: --per_ri_config_utilities.create_security_profile_assign

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:

Line 1458: per_ri_config_utilities.submit_int_payroll_request

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

Line 1467: per_ri_config_utilities.update_configuration_status(p_configuration_code);

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: --

Line 1473: per_ri_config_utilities.submit_enable_mult_sg_process

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:

Line 1487: --per_ri_config_utilities.write_log(p_message => l_log_message);

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);