eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_RI_CONFIG_FND_HR_ENTITY dependencies on HR_UTILITY

Line 60: hr_utility.set_location('Entering:'|| l_proc, 10);

56:
57: l_global_job_structure_name fnd_id_flex_structures.id_flex_structure_code%type;
58:
59: BEGIN
60: hr_utility.set_location('Entering:'|| l_proc, 10);
61:
62: l_global_job_structure_name := per_ri_config_utilities.return_config_entity_name
63: (per_ri_config_main.g_global_job_structure_name);
64: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry

Line 67: hr_utility.trace('l_enterprise_primary_industry = ' || l_enterprise_primary_industry);

63: (per_ri_config_main.g_global_job_structure_name);
64: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
65: (p_configuration_code => p_configuration_code);
66:
67: hr_utility.trace('l_enterprise_primary_industry = ' || l_enterprise_primary_industry);
68:
69: -- Create Global Jobs Key flex
70: if NOT (p_technical_summary_mode) then
71: l_jobs_keyflex_number := per_ri_config_utilities.create_key_flexfield

Line 89: hr_utility.set_location(l_proc, 30);

85: || per_ri_config_main.g_description_suffix_string;
86: l_kf_job_no_rv_count := l_kf_job_no_rv_count + 1 ;
87: end if;
88:
89: hr_utility.set_location(l_proc, 30);
90: l_log_message := 'Created KEYFLEX PER JOB ' || l_global_job_structure_name;
91: per_ri_config_utilities.write_log(p_message => l_log_message);
92:
93: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then

Line 94: hr_utility.set_location(l_proc, 20);

90: l_log_message := 'Created KEYFLEX PER JOB ' || l_global_job_structure_name;
91: per_ri_config_utilities.write_log(p_message => l_log_message);
92:
93: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
94: hr_utility.set_location(l_proc, 20);
95: -- create segments
96: open csr_config_job_no_rv(p_configuration_code);
97: l_jobs_segment_count := 0;
98: LOOP

Line 177: hr_utility.set_location(l_proc, 100);

173: per_ri_config_utilities.write_log(p_message => l_log_message);
174: END LOOP;
175: close csr_config_job_no_rv;
176: else
177: hr_utility.set_location(l_proc, 100);
178: hr_utility.trace('Jobs: Industry is US_GOVERNMENT');
179:
180: -- create only federal job segments with specified value segment name valuesets.
181: -- First Segment 'Name' valueset '60 Characters'

Line 178: hr_utility.trace('Jobs: Industry is US_GOVERNMENT');

174: END LOOP;
175: close csr_config_job_no_rv;
176: else
177: hr_utility.set_location(l_proc, 100);
178: hr_utility.trace('Jobs: Industry is US_GOVERNMENT');
179:
180: -- create only federal job segments with specified value segment name valuesets.
181: -- First Segment 'Name' valueset '60 Characters'
182: if NOT (p_technical_summary_mode) then

Line 256: hr_utility.trace('l_jobs_segment_count = ' || to_char(l_jobs_segment_count));

252: ,l_job_segment_type
253: ,l_industry_attribute
254: ,l_jobs_segment_no;
255: exit when csr_config_job_no_rv%NOTFOUND;
256: hr_utility.trace('l_jobs_segment_count = ' || to_char(l_jobs_segment_count));
257:
258: if l_industry_attribute = per_ri_config_main.g_global_fed_job_non_fed_att then
259:
260: l_jobs_segment_count := l_jobs_segment_count_fixed + csr_config_job_no_rv%ROWCOUNT;

Line 263: hr_utility.trace('l_jobs_segment_count = ' || to_char(l_jobs_segment_count));

259:
260: l_jobs_segment_count := l_jobs_segment_count_fixed + csr_config_job_no_rv%ROWCOUNT;
261:
262:
263: hr_utility.trace('l_jobs_segment_count = ' || to_char(l_jobs_segment_count));
264: if NOT (p_technical_summary_mode) then
265: per_ri_config_utilities.create_flex_segments
266: (p_appl_short_Name => 'PER'
267: ,p_flex_code => 'JOB'

Line 341: hr_utility.set_location(' Leaving:'|| l_proc, 100);

337: ,p_flex_code => 'JOB'
338: ,p_structure_code => l_global_job_structure_name);
339: end if;
340:
341: hr_utility.set_location(' Leaving:'|| l_proc, 100);
342:
343: EXCEPTION
344: when others then
345: l_error_message := 'Error in ' || l_proc;

Line 346: hr_utility.trace(l_error_message || '-' || sqlerrm);

342:
343: EXCEPTION
344: when others then
345: l_error_message := 'Error in ' || l_proc;
346: hr_utility.trace(l_error_message || '-' || sqlerrm);
347: hr_utility.set_location(' Leaving:'|| l_proc, 500);
348: hr_utility.raise_error;
349:
350: END create_jobs_no_rv_keyflex;

Line 347: hr_utility.set_location(' Leaving:'|| l_proc, 500);

343: EXCEPTION
344: when others then
345: l_error_message := 'Error in ' || l_proc;
346: hr_utility.trace(l_error_message || '-' || sqlerrm);
347: hr_utility.set_location(' Leaving:'|| l_proc, 500);
348: hr_utility.raise_error;
349:
350: END create_jobs_no_rv_keyflex;
351:

Line 348: hr_utility.raise_error;

344: when others then
345: l_error_message := 'Error in ' || l_proc;
346: hr_utility.trace(l_error_message || '-' || sqlerrm);
347: hr_utility.set_location(' Leaving:'|| l_proc, 500);
348: hr_utility.raise_error;
349:
350: END create_jobs_no_rv_keyflex;
351:
352: /* --------------------------------------------------------------------------

Line 410: hr_utility.set_location('Entering:'|| l_proc, 10);

406: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
407: l_global_pos_structure_name fnd_id_flex_structures.id_flex_structure_code%type;
408:
409: BEGIN
410: hr_utility.set_location('Entering:'|| l_proc, 10);
411:
412: l_global_pos_structure_name := per_ri_config_utilities.return_config_entity_name
413: (per_ri_config_main.g_global_pos_structure_name);
414:

Line 418: hr_utility.trace('l_enterprise_primary_industry = ' || l_enterprise_primary_industry);

414:
415: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
416: (p_configuration_code => p_configuration_code);
417:
418: hr_utility.trace('l_enterprise_primary_industry = ' || l_enterprise_primary_industry);
419:
420: -- Create Global Position Key flex
421: if NOT (p_technical_summary_mode) then
422: l_pos_keyflex_number := per_ri_config_utilities.create_key_flexfield

Line 440: hr_utility.set_location(l_proc, 30);

436: l_kf_pos_no_rv_count := l_kf_pos_no_rv_count + 1 ;
437: end if;
438:
439:
440: hr_utility.set_location(l_proc, 30);
441: l_log_message := 'Created KEYFLEX PER POS ' || l_global_pos_structure_name;
442: per_ri_config_utilities.write_log(p_message => l_log_message);
443:
444: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then

Line 445: hr_utility.set_location(l_proc, 20);

441: l_log_message := 'Created KEYFLEX PER POS ' || l_global_pos_structure_name;
442: per_ri_config_utilities.write_log(p_message => l_log_message);
443:
444: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
445: hr_utility.set_location(l_proc, 20);
446:
447: -- create segments
448: open csr_config_position_no_rv(p_configuration_code);
449: l_pos_segment_count := 0;

Line 520: hr_utility.trace('Created Position Key Flex NO RV Segment: ' || l_pos_segment_name);

516: l_kf_pos_no_rv_seg_count := l_kf_pos_no_rv_seg_count + 1 ;
517: end if;
518:
519: per_ri_config_utilities.write_log(p_message => 'Created Global Position Key Flex Segment' || l_pos_segment_name);
520: hr_utility.trace('Created Position Key Flex NO RV Segment: ' || l_pos_segment_name);
521: END LOOP;
522: --
523: -- freeze and compile this flexfield
524: --

Line 532: hr_utility.set_location(l_proc, 100);

528: ,p_flex_code => 'POS'
529: ,p_structure_code => l_global_pos_structure_name);
530: end if;
531: else
532: hr_utility.set_location(l_proc, 100);
533: hr_utility.trace('Positions: Industry is US_GOVERNMENT');
534:
535: -- create only federal job segments with specified value segment name valuesets.
536: -- First Segment

Line 533: hr_utility.trace('Positions: Industry is US_GOVERNMENT');

529: ,p_structure_code => l_global_pos_structure_name);
530: end if;
531: else
532: hr_utility.set_location(l_proc, 100);
533: hr_utility.trace('Positions: Industry is US_GOVERNMENT');
534:
535: -- create only federal job segments with specified value segment name valuesets.
536: -- First Segment
537: if NOT (p_technical_summary_mode) then

Line 809: hr_utility.trace('l_pos_segment_count = ' || to_char(l_pos_segment_count));

805: ,l_pos_segment_type
806: ,l_industry_attribute
807: ,l_pos_segment_no;
808: exit when csr_config_position_no_rv%NOTFOUND;
809: hr_utility.trace('l_pos_segment_count = ' || to_char(l_pos_segment_count));
810:
811: if l_industry_attribute = per_ri_config_main.g_global_fed_pos_non_fed_att then
812:
813: l_pos_segment_count := l_pos_segment_count_fixed + csr_config_position_no_rv%ROWCOUNT;

Line 816: hr_utility.trace('l_pos_segment_count = ' || to_char(l_pos_segment_count));

812:
813: l_pos_segment_count := l_pos_segment_count_fixed + csr_config_position_no_rv%ROWCOUNT;
814:
815:
816: hr_utility.trace('l_pos_segment_count = ' || to_char(l_pos_segment_count));
817:
818: if NOT (p_technical_summary_mode) then
819: per_ri_config_utilities.create_flex_segments
820: (p_appl_short_Name => 'PER'

Line 900: hr_utility.trace('l_position_no_rv_no_seg_count = ' || l_position_no_rv_no_seg_count);

896: --
897: open csr_config_position_no_rv_cnt(p_configuration_code);
898: fetch csr_config_position_no_rv_cnt into l_position_no_rv_no_seg_count;
899:
900: hr_utility.trace('l_position_no_rv_no_seg_count = ' || l_position_no_rv_no_seg_count);
901: if l_position_no_rv_no_seg_count = 0 then
902: hr_utility.trace('Only Jobs are defined');
903: -- In case when no positions are defined
904: -- Attach default segments to it.

Line 902: hr_utility.trace('Only Jobs are defined');

898: fetch csr_config_position_no_rv_cnt into l_position_no_rv_no_seg_count;
899:
900: hr_utility.trace('l_position_no_rv_no_seg_count = ' || l_position_no_rv_no_seg_count);
901: if l_position_no_rv_no_seg_count = 0 then
902: hr_utility.trace('Only Jobs are defined');
903: -- In case when no positions are defined
904: -- Attach default segments to it.
905: -- FED case always Jobs and Positions defined.
906: hr_utility.set_location(l_proc, 110);

Line 906: hr_utility.set_location(l_proc, 110);

902: hr_utility.trace('Only Jobs are defined');
903: -- In case when no positions are defined
904: -- Attach default segments to it.
905: -- FED case always Jobs and Positions defined.
906: hr_utility.set_location(l_proc, 110);
907:
908: -- Create Position Key Flex Segments
909: if NOT (p_technical_summary_mode) then
910: per_ri_config_utilities.create_flex_segments

Line 980: hr_utility.set_location(' Leaving:'|| l_proc, 40);

976: ,p_structure_code => l_global_pos_structure_name);
977: end if;
978: end if;
979:
980: hr_utility.set_location(' Leaving:'|| l_proc, 40);
981:
982: EXCEPTION
983: when others then
984: l_error_message := 'Error in ' || l_proc;

Line 985: hr_utility.trace(l_error_message || '-' || sqlerrm);

981:
982: EXCEPTION
983: when others then
984: l_error_message := 'Error in ' || l_proc;
985: hr_utility.trace(l_error_message || '-' || sqlerrm);
986: hr_utility.set_location(' Leaving:'|| l_proc, 500);
987: hr_utility.raise_error;
988:
989:

Line 986: hr_utility.set_location(' Leaving:'|| l_proc, 500);

982: EXCEPTION
983: when others then
984: l_error_message := 'Error in ' || l_proc;
985: hr_utility.trace(l_error_message || '-' || sqlerrm);
986: hr_utility.set_location(' Leaving:'|| l_proc, 500);
987: hr_utility.raise_error;
988:
989:
990: END create_positions_no_rv_keyflex;

Line 987: hr_utility.raise_error;

983: when others then
984: l_error_message := 'Error in ' || l_proc;
985: hr_utility.trace(l_error_message || '-' || sqlerrm);
986: hr_utility.set_location(' Leaving:'|| l_proc, 500);
987: hr_utility.raise_error;
988:
989:
990: END create_positions_no_rv_keyflex;
991:

Line 1045: hr_utility.set_location('Entering:'|| l_proc, 10);

1041: l_global_grd_structure_name fnd_id_flex_structures.id_flex_structure_code%type;
1042:
1043: BEGIN
1044:
1045: hr_utility.set_location('Entering:'|| l_proc, 10);
1046:
1047: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
1048: (p_configuration_code => p_configuration_code);
1049: hr_utility.trace('l_enterprise_primary_industry = ' || l_enterprise_primary_industry);

Line 1049: hr_utility.trace('l_enterprise_primary_industry = ' || l_enterprise_primary_industry);

1045: hr_utility.set_location('Entering:'|| l_proc, 10);
1046:
1047: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
1048: (p_configuration_code => p_configuration_code);
1049: hr_utility.trace('l_enterprise_primary_industry = ' || l_enterprise_primary_industry);
1050:
1051: l_global_grd_structure_name := per_ri_config_utilities.return_config_entity_name
1052: (per_ri_config_main.g_global_grd_structure_name);
1053: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then

Line 1054: hr_utility.set_location(l_proc, 20);

1050:
1051: l_global_grd_structure_name := per_ri_config_utilities.return_config_entity_name
1052: (per_ri_config_main.g_global_grd_structure_name);
1053: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
1054: hr_utility.set_location(l_proc, 20);
1055: -- Create Global Grades Key flex
1056: if NOT (p_technical_summary_mode) then
1057: l_grade_keyflex_number := per_ri_config_utilities.create_key_flexfield
1058: (p_appl_short_Name => 'PER'

Line 1075: hr_utility.set_location(l_proc, 30);

1071: l_kf_grd_no_rv_count := l_kf_grd_no_rv_count + 1 ;
1072: end if;
1073:
1074:
1075: hr_utility.set_location(l_proc, 30);
1076: l_log_message := 'Created KEYFLEX PER GRD ' || l_global_grd_structure_name;
1077: per_ri_config_utilities.write_log(p_message => l_log_message);
1078:
1079: -- create segments

Line 1082: hr_utility.set_location(l_proc, 40);

1078:
1079: -- create segments
1080: open csr_config_grade_no_rv(p_configuration_code);
1081: l_grade_segment_count := 0;
1082: hr_utility.set_location(l_proc, 40);
1083: LOOP
1084: fetch csr_config_grade_no_rv into l_grade_segment_name
1085: ,l_grade_segment_type
1086: ,l_industry_attribute

Line 1127: hr_utility.trace('VALUESETSET_NAME = ' || l_kf_grd_no_rv_valueset_tab(l_value_set_tab_count).value_set_name);

1123: ,p_valueset_tab => l_kf_grd_no_rv_valueset_tab);
1124:
1125: p_kf_grd_no_rv_seg_tab(l_kf_grd_no_rv_seg_count).vs_value_set_name
1126: := l_kf_grd_no_rv_valueset_tab(l_value_set_tab_count).value_set_name;
1127: hr_utility.trace('VALUESETSET_NAME = ' || l_kf_grd_no_rv_valueset_tab(l_value_set_tab_count).value_set_name);
1128: p_kf_grd_no_rv_seg_tab(l_kf_grd_no_rv_seg_count).vs_description
1129: := l_kf_grd_no_rv_valueset_tab(l_value_set_tab_count).description;
1130: p_kf_grd_no_rv_seg_tab(l_kf_grd_no_rv_seg_count).vs_security_available
1131: := l_kf_grd_no_rv_valueset_tab(l_value_set_tab_count).security_available;

Line 1156: hr_utility.set_location(l_proc, 50);

1152:
1153: l_log_message := 'Created KEYFLEX SEGMENT : PER GRD ' || l_grade_segment_name;
1154: per_ri_config_utilities.write_log(p_message => l_log_message);
1155: END LOOP;
1156: hr_utility.set_location(l_proc, 50);
1157: --
1158: -- freeze and compile this flexfield
1159: --
1160: if NOT (p_technical_summary_mode) then

Line 1168: hr_utility.set_location(l_proc, 100);

1164: ,p_structure_code => l_global_grd_structure_name);
1165: end if;
1166: close csr_config_grade_no_rv;
1167: else
1168: hr_utility.set_location(l_proc, 100);
1169: hr_utility.trace('Grades: Industry is US_GOVERNMENT');
1170:
1171: -- create Global Jobs Key flex
1172: -- do not create grade flex field use US_FEDERAL_GRADE

Line 1169: hr_utility.trace('Grades: Industry is US_GOVERNMENT');

1165: end if;
1166: close csr_config_grade_no_rv;
1167: else
1168: hr_utility.set_location(l_proc, 100);
1169: hr_utility.trace('Grades: Industry is US_GOVERNMENT');
1170:
1171: -- create Global Jobs Key flex
1172: -- do not create grade flex field use US_FEDERAL_GRADE
1173: -- create only non federal segments

Line 1187: hr_utility.trace('l_grade_segment_count = ' || to_char(l_grade_segment_count));

1183: ,l_industry_attribute
1184: ,l_grade_segment_no;
1185:
1186: exit when csr_config_grade_no_rv%NOTFOUND;
1187: hr_utility.trace('l_grade_segment_count = ' || to_char(l_grade_segment_count));
1188: hr_utility.trace('p_structure_code = ' || per_ri_config_main.g_global_fed_grd_struct_name);
1189:
1190: if l_industry_attribute = per_ri_config_main.g_global_fed_grd_non_fed_att then
1191:

Line 1188: hr_utility.trace('p_structure_code = ' || per_ri_config_main.g_global_fed_grd_struct_name);

1184: ,l_grade_segment_no;
1185:
1186: exit when csr_config_grade_no_rv%NOTFOUND;
1187: hr_utility.trace('l_grade_segment_count = ' || to_char(l_grade_segment_count));
1188: hr_utility.trace('p_structure_code = ' || per_ri_config_main.g_global_fed_grd_struct_name);
1189:
1190: if l_industry_attribute = per_ri_config_main.g_global_fed_grd_non_fed_att then
1191:
1192: l_grade_segment_count := l_grade_segment_count_fixed + csr_config_grade_no_rv%ROWCOUNT;

Line 1195: hr_utility.trace('l_grade_segment_count = ' || to_char(l_grade_segment_count));

1191:
1192: l_grade_segment_count := l_grade_segment_count_fixed + csr_config_grade_no_rv%ROWCOUNT;
1193:
1194:
1195: hr_utility.trace('l_grade_segment_count = ' || to_char(l_grade_segment_count));
1196:
1197:
1198: if NOT (p_technical_summary_mode) then
1199: per_ri_config_utilities.create_flex_segments

Line 1277: hr_utility.trace(l_error_message || '-' || sqlerrm);

1273:
1274: EXCEPTION
1275: when others then
1276: l_error_message := 'Error in ' || l_proc;
1277: hr_utility.trace(l_error_message || '-' || sqlerrm);
1278: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1279: hr_utility.raise_error;
1280:
1281: END create_grades_no_rv_keyflex;

Line 1278: hr_utility.set_location(' Leaving:'|| l_proc, 500);

1274: EXCEPTION
1275: when others then
1276: l_error_message := 'Error in ' || l_proc;
1277: hr_utility.trace(l_error_message || '-' || sqlerrm);
1278: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1279: hr_utility.raise_error;
1280:
1281: END create_grades_no_rv_keyflex;
1282:

Line 1279: hr_utility.raise_error;

1275: when others then
1276: l_error_message := 'Error in ' || l_proc;
1277: hr_utility.trace(l_error_message || '-' || sqlerrm);
1278: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1279: hr_utility.raise_error;
1280:
1281: END create_grades_no_rv_keyflex;
1282:
1283: /* --------------------------------------------------------------------------

Line 1347: hr_utility.set_location('Entering:'|| l_proc, 10);

1343: l_system_model varchar2(10) := 'N';
1344: l_sec_group_id varchar2(10);
1345:
1346: BEGIN
1347: hr_utility.set_location('Entering:'|| l_proc, 10);
1348:
1349: select legislation_code into l_country_selected from per_business_groups
1350: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
1351:

Line 1364: hr_utility.set_location(l_proc, 20);

1360: fetch csr_config_jobs_rv into l_jobs_rv_name,l_jobs_rv_name_orig,l_rv_country_code;
1361:
1362: exit when csr_config_jobs_rv%NOTFOUND;
1363:
1364: hr_utility.set_location(l_proc, 20);
1365: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1366: AND l_rv_country_code = l_country_selected THEN
1367: hr_utility.set_location('skip the creation of the flexfield structure', 90);
1368: ELSE

Line 1367: hr_utility.set_location('skip the creation of the flexfield structure', 90);

1363:
1364: hr_utility.set_location(l_proc, 20);
1365: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1366: AND l_rv_country_code = l_country_selected THEN
1367: hr_utility.set_location('skip the creation of the flexfield structure', 90);
1368: ELSE
1369: -- Create Jobs RV Key flex
1370: if NOT (p_technical_summary_mode) then
1371: l_jobs_keyflex_number := per_ri_config_utilities.create_key_flexfield

Line 1390: hr_utility.trace('Created Jobs RV Keyflex ' || l_jobs_rv_name

1386: end if;
1387:
1388: per_ri_config_utilities.write_log(p_message => 'Created Jobs RV Keyflex ' || l_jobs_rv_name
1389: || per_ri_config_main.g_job_rv_struct_def_string );
1390: hr_utility.trace('Created Jobs RV Keyflex ' || l_jobs_rv_name
1391: || per_ri_config_main.g_job_rv_struct_def_string);
1392:
1393: open csr_config_jobs_rv_seg(p_configuration_code
1394: ,l_jobs_rv_name_orig);

Line 1467: hr_utility.trace('Created Job Key Flex RV Segment: ' || l_rv_jobs_segment_name);

1463: l_kf_job_rv_seg_count := l_kf_job_rv_seg_count + 1 ;
1464: end if;
1465:
1466: per_ri_config_utilities.write_log(p_message => 'Created Grade Key Flex RV Segment' || l_rv_jobs_segment_name);
1467: hr_utility.trace('Created Job Key Flex RV Segment: ' || l_rv_jobs_segment_name);
1468: END LOOP;
1469: --
1470: -- freeze and compile this flexfield
1471: --

Line 1487: hr_utility.trace(l_error_message || '-' || sqlerrm);

1483:
1484: EXCEPTION
1485: when others then
1486: l_error_message := 'Error in ' || l_proc;
1487: hr_utility.trace(l_error_message || '-' || sqlerrm);
1488: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1489: hr_utility.raise_error;
1490:
1491: END create_jobs_rv_keyflex;

Line 1488: hr_utility.set_location(' Leaving:'|| l_proc, 500);

1484: EXCEPTION
1485: when others then
1486: l_error_message := 'Error in ' || l_proc;
1487: hr_utility.trace(l_error_message || '-' || sqlerrm);
1488: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1489: hr_utility.raise_error;
1490:
1491: END create_jobs_rv_keyflex;
1492:

Line 1489: hr_utility.raise_error;

1485: when others then
1486: l_error_message := 'Error in ' || l_proc;
1487: hr_utility.trace(l_error_message || '-' || sqlerrm);
1488: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1489: hr_utility.raise_error;
1490:
1491: END create_jobs_rv_keyflex;
1492:
1493: /* --------------------------------------------------------------------------

Line 1556: hr_utility.set_location('Entering:'|| l_proc, 10);

1552: l_multi_tenancy boolean default false;
1553: l_system_model varchar2(10) := 'N';
1554: l_sec_group_id varchar2(10);
1555: BEGIN
1556: hr_utility.set_location('Entering:'|| l_proc, 10);
1557:
1558: select legislation_code into l_country_selected from per_business_groups
1559: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
1560:

Line 1573: hr_utility.set_location(l_proc, 20);

1569: fetch csr_config_positions_rv into l_positions_rv_name,l_positions_rv_name_orig,l_rv_country_code;
1570:
1571: exit when csr_config_positions_rv%NOTFOUND;
1572:
1573: hr_utility.set_location(l_proc, 20);
1574: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1575: AND l_rv_country_code = l_country_selected THEN
1576: hr_utility.set_location('skip the creation of the flexfield structure', 90);
1577: ELSE

Line 1576: hr_utility.set_location('skip the creation of the flexfield structure', 90);

1572:
1573: hr_utility.set_location(l_proc, 20);
1574: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1575: AND l_rv_country_code = l_country_selected THEN
1576: hr_utility.set_location('skip the creation of the flexfield structure', 90);
1577: ELSE
1578: -- Create Jobs RV Key flex
1579: if NOT (p_technical_summary_mode) then
1580: l_positions_keyflex_number := per_ri_config_utilities.create_key_flexfield

Line 1599: hr_utility.trace('Created Positions RV Keyflex ' || l_positions_rv_name

1595: l_kf_pos_rv_count := l_kf_pos_rv_count + 1 ;
1596: end if;
1597: per_ri_config_utilities.write_log(p_message => 'Created Positions RV Keyflex ' || l_positions_rv_name
1598: || per_ri_config_main.g_pos_rv_struct_def_string );
1599: hr_utility.trace('Created Positions RV Keyflex ' || l_positions_rv_name
1600: || per_ri_config_main.g_pos_rv_struct_def_string);
1601:
1602: open csr_config_positions_rv_seg(p_configuration_code
1603: ,l_positions_rv_name_orig);

Line 1676: hr_utility.trace('Created Positions Key Flex RV Segment: ' || l_rv_positions_segment_name);

1672: := l_kf_pos_rv_valueset_tab(l_value_set_tab_count).max_value;
1673: l_kf_pos_rv_seg_count := l_kf_pos_rv_seg_count + 1 ;
1674: end if;
1675: per_ri_config_utilities.write_log(p_message => 'Created Positions Key Flex RV Segment' || l_rv_positions_segment_name);
1676: hr_utility.trace('Created Positions Key Flex RV Segment: ' || l_rv_positions_segment_name);
1677: END LOOP;
1678: --
1679: -- freeze and compile this flexfield
1680: --

Line 1692: hr_utility.set_location('Leaving:'|| l_proc, 100);

1688: close csr_config_positions_rv_seg;
1689: END IF;
1690: END LOOP;
1691: close csr_config_positions_rv;
1692: hr_utility.set_location('Leaving:'|| l_proc, 100);
1693: EXCEPTION
1694: when others then
1695: l_error_message := 'Error in ' || l_proc;
1696: hr_utility.trace(l_error_message || '-' || sqlerrm);

Line 1696: hr_utility.trace(l_error_message || '-' || sqlerrm);

1692: hr_utility.set_location('Leaving:'|| l_proc, 100);
1693: EXCEPTION
1694: when others then
1695: l_error_message := 'Error in ' || l_proc;
1696: hr_utility.trace(l_error_message || '-' || sqlerrm);
1697: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1698: hr_utility.raise_error;
1699:
1700: END create_positions_rv_keyflex;

Line 1697: hr_utility.set_location(' Leaving:'|| l_proc, 500);

1693: EXCEPTION
1694: when others then
1695: l_error_message := 'Error in ' || l_proc;
1696: hr_utility.trace(l_error_message || '-' || sqlerrm);
1697: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1698: hr_utility.raise_error;
1699:
1700: END create_positions_rv_keyflex;
1701:

Line 1698: hr_utility.raise_error;

1694: when others then
1695: l_error_message := 'Error in ' || l_proc;
1696: hr_utility.trace(l_error_message || '-' || sqlerrm);
1697: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1698: hr_utility.raise_error;
1699:
1700: END create_positions_rv_keyflex;
1701:
1702: /* --------------------------------------------------------------------------

Line 1762: hr_utility.set_location('Entering:'|| l_proc, 10);

1758: l_multi_tenancy boolean default false;
1759: l_system_model varchar2(10) := 'N';
1760: l_sec_group_id varchar2(10);
1761: BEGIN
1762: hr_utility.set_location('Entering:'|| l_proc, 10);
1763:
1764: select legislation_code into l_country_selected from per_business_groups
1765: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
1766:

Line 1780: hr_utility.set_location(l_proc, 20);

1776:
1777: exit when csr_config_grade_rv%NOTFOUND;
1778:
1779: -- Create Grades RV Key Flex
1780: hr_utility.set_location(l_proc, 20);
1781: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1782: AND l_rv_country_code = l_country_selected THEN
1783: hr_utility.set_location('skip the creation of the flexfield structure', 90);
1784: ELSE

Line 1783: hr_utility.set_location('skip the creation of the flexfield structure', 90);

1779: -- Create Grades RV Key Flex
1780: hr_utility.set_location(l_proc, 20);
1781: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1782: AND l_rv_country_code = l_country_selected THEN
1783: hr_utility.set_location('skip the creation of the flexfield structure', 90);
1784: ELSE
1785: if NOT (p_technical_summary_mode) then
1786: l_grades_keyflex_number :=
1787: per_ri_config_utilities.create_key_flexfield

Line 1806: hr_utility.trace('Created Grades RV Keyflex ' || per_ri_config_main.g_grd_rv_struct_def_string);

1802: l_kf_grd_rv_count := l_kf_grd_rv_count + 1 ;
1803: end if;
1804: per_ri_config_utilities.write_log(p_message => 'Created Grades RV Keyflex '
1805: || per_ri_config_main.g_grd_rv_struct_def_string );
1806: hr_utility.trace('Created Grades RV Keyflex ' || per_ri_config_main.g_grd_rv_struct_def_string);
1807:
1808: open csr_config_grade_rv_seg(p_configuration_code
1809: ,l_grade_rv_name_orig);
1810: l_grades_segment_count := 0;

Line 1880: hr_utility.trace('Created Job Key Flex RV Segment: ' || l_rv_grade_segment_name);

1876: := l_kf_grd_rv_valueset_tab(l_value_set_tab_count).max_value;
1877: l_kf_grd_rv_seg_count := l_kf_grd_rv_seg_count + 1 ;
1878: end if;
1879: per_ri_config_utilities.write_log(p_message => 'Created Grade Key Flex RV Segment' || l_rv_grade_segment_name);
1880: hr_utility.trace('Created Job Key Flex RV Segment: ' || l_rv_grade_segment_name);
1881: END LOOP;
1882: close csr_config_grade_rv_seg;
1883: --
1884: -- freeze and compile this flexfield

Line 1900: hr_utility.trace(l_error_message || '-' || sqlerrm);

1896:
1897: EXCEPTION
1898: when others then
1899: l_error_message := 'Error in ' || l_proc;
1900: hr_utility.trace(l_error_message || '-' || sqlerrm);
1901: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1902: hr_utility.raise_error;
1903:
1904: END create_grades_rv_keyflex;

Line 1901: hr_utility.set_location(' Leaving:'|| l_proc, 500);

1897: EXCEPTION
1898: when others then
1899: l_error_message := 'Error in ' || l_proc;
1900: hr_utility.trace(l_error_message || '-' || sqlerrm);
1901: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1902: hr_utility.raise_error;
1903:
1904: END create_grades_rv_keyflex;
1905:

Line 1902: hr_utility.raise_error;

1898: when others then
1899: l_error_message := 'Error in ' || l_proc;
1900: hr_utility.trace(l_error_message || '-' || sqlerrm);
1901: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1902: hr_utility.raise_error;
1903:
1904: END create_grades_rv_keyflex;
1905:
1906: /* --------------------------------------------------------------------------

Line 1964: hr_utility.set_location('Entering:'|| l_proc, 10);

1960: l_kf_cmp_seg_count number(8) :=0;
1961: l_kf_cost_seg_count number(8) :=0;
1962: BEGIN
1963:
1964: hr_utility.set_location('Entering:'|| l_proc, 10);
1965:
1966: --
1967: -- create people group key flex
1968: --

Line 1986: hr_utility.trace('Created People Group Key Flex: ' || l_grp_structures_code );

1982: p_kf_grp_tab(l_kf_grp_count).structure_title := l_grp_structures_code;
1983: p_kf_grp_tab(l_kf_grp_count).description := l_grp_structures_code;
1984: end if;
1985:
1986: hr_utility.trace('Created People Group Key Flex: ' || l_grp_structures_code );
1987:
1988: --
1989: -- create people group flex segments
1990: --

Line 2051: hr_utility.trace('Created People Group Key Flex Segment: ' || l_grp_structures_code);

2047: := l_kf_grp_valueset_tab(l_value_set_tab_count).max_value;
2048: l_kf_grp_seg_count := l_kf_grp_seg_count + 1 ;
2049: end if;
2050:
2051: hr_utility.trace('Created People Group Key Flex Segment: ' || l_grp_structures_code);
2052:
2053: --
2054: -- freeze and compile this flexfield
2055: --

Line 2085: hr_utility.trace('Created Competence Group Key Flex: ' || l_cmp_structures_code);

2081: p_kf_cmp_tab(l_kf_cmp_count).structure_title := l_cmp_structures_code;
2082: p_kf_cmp_tab(l_kf_cmp_count).description := l_cmp_structures_code;
2083: end if;
2084:
2085: hr_utility.trace('Created Competence Group Key Flex: ' || l_cmp_structures_code);
2086:
2087: --
2088: -- create competence flex segments
2089: --

Line 2148: hr_utility.trace('Created Competence Key Flex Segment: l_cmp_structures_code' );

2144: := l_kf_cmp_valueset_tab(l_value_set_tab_count).max_value;
2145: l_kf_cmp_seg_count := l_kf_cmp_seg_count + 1 ;
2146: end if;
2147:
2148: hr_utility.trace('Created Competence Key Flex Segment: l_cmp_structures_code' );
2149:
2150: --
2151: -- freeze and compile this flexfield
2152: --

Line 2180: hr_utility.trace('Created Cost Allocation Key Flex: ' || l_cost_structures_code);

2176: p_kf_cost_tab(l_kf_cost_count).structure_title := l_cost_structures_code;
2177: p_kf_cost_tab(l_kf_cost_count).description := l_cost_structures_code;
2178: end if;
2179:
2180: hr_utility.trace('Created Cost Allocation Key Flex: ' || l_cost_structures_code);
2181:
2182: --
2183: -- create cost allocation flex segments
2184: --

Line 2241: hr_utility.trace('ENABLELONGLIST := ' || l_kf_cost_valueset_tab(l_value_set_tab_count).enable_longlist);

2237: := l_kf_cost_valueset_tab(l_value_set_tab_count).min_value;
2238: p_kf_cost_seg_tab(l_kf_cost_seg_count).vs_max_value
2239: := l_kf_cmp_valueset_tab(l_value_set_tab_count).max_value;
2240: l_kf_cost_seg_count := l_kf_cost_seg_count + 1 ;
2241: hr_utility.trace('ENABLELONGLIST := ' || l_kf_cost_valueset_tab(l_value_set_tab_count).enable_longlist);
2242: end if;
2243:
2244: if NOT (p_technical_summary_mode) then
2245: per_ri_config_utilities.create_flex_segments

Line 2373: hr_utility.trace(l_error_message || '-' || sqlerrm);

2369: end if;
2370: EXCEPTION
2371: when others then
2372: l_error_message := 'Error in ' || l_proc;
2373: hr_utility.trace(l_error_message || '-' || sqlerrm);
2374: hr_utility.set_location(' Leaving:'|| l_proc, 500);
2375: hr_utility.raise_error;
2376:
2377: END create_global_grp_cmp_cost_kf;

Line 2374: hr_utility.set_location(' Leaving:'|| l_proc, 500);

2370: EXCEPTION
2371: when others then
2372: l_error_message := 'Error in ' || l_proc;
2373: hr_utility.trace(l_error_message || '-' || sqlerrm);
2374: hr_utility.set_location(' Leaving:'|| l_proc, 500);
2375: hr_utility.raise_error;
2376:
2377: END create_global_grp_cmp_cost_kf;
2378:

Line 2375: hr_utility.raise_error;

2371: when others then
2372: l_error_message := 'Error in ' || l_proc;
2373: hr_utility.trace(l_error_message || '-' || sqlerrm);
2374: hr_utility.set_location(' Leaving:'|| l_proc, 500);
2375: hr_utility.raise_error;
2376:
2377: END create_global_grp_cmp_cost_kf;
2378:
2379: /* --------------------------------------------------------------------------

Line 2427: hr_utility.set_location('Entering:'|| l_proc, 10);

2423: l_log_message varchar2(360);
2424: l_error_message varchar2(360);
2425:
2426: BEGIN
2427: hr_utility.set_location('Entering:'|| l_proc, 10);
2428:
2429: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
2430:
2431: -- Create Global Jobs Key flex

Line 2432: hr_utility.set_location(l_proc, 20);

2428:
2429: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
2430:
2431: -- Create Global Jobs Key flex
2432: hr_utility.set_location(l_proc, 20);
2433: l_job_structures_code := per_ri_config_utilities.return_config_entity_name
2434: (per_ri_config_main.g_global_job_structure_name);
2435:
2436:

Line 2462: hr_utility.set_location(l_proc, 30);

2458: l_log_message := 'Created KEYFLEX PER JOB ' || l_job_structures_code;
2459: per_ri_config_utilities.write_log(p_message => l_log_message);
2460:
2461: -- Create Position Key flex
2462: hr_utility.set_location(l_proc, 30);
2463: l_pos_structures_code := per_ri_config_utilities.return_config_entity_name
2464: (per_ri_config_main.g_global_pos_structure_name);
2465: if NOT (p_technical_summary_mode) then
2466: l_position_fk_number := per_ri_config_utilities.create_key_flexfield

Line 2485: hr_utility.set_location(l_proc, 40);

2481:
2482: l_log_message := 'Created KEYFLEX PER POS ' || l_pos_structures_code;
2483: per_ri_config_utilities.write_log(p_message => l_log_message);
2484:
2485: hr_utility.set_location(l_proc, 40);
2486:
2487: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
2488: hr_utility.set_location(l_proc, 50);
2489:

Line 2488: hr_utility.set_location(l_proc, 50);

2484:
2485: hr_utility.set_location(l_proc, 40);
2486:
2487: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
2488: hr_utility.set_location(l_proc, 50);
2489:
2490: -- Create Jobs Key Flex Segments
2491:
2492: if NOT (p_technical_summary_mode) then

Line 2615: hr_utility.set_location(l_proc, 60);

2611:
2612: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || l_pos_structures_code;
2613: per_ri_config_utilities.write_log(p_message => l_log_message);
2614:
2615: hr_utility.set_location(l_proc, 60);
2616: else
2617: hr_utility.set_location(l_proc, 70);
2618: hr_utility.trace('Positions : Industry is US_GOVERNMENT');
2619:

Line 2617: hr_utility.set_location(l_proc, 70);

2613: per_ri_config_utilities.write_log(p_message => l_log_message);
2614:
2615: hr_utility.set_location(l_proc, 60);
2616: else
2617: hr_utility.set_location(l_proc, 70);
2618: hr_utility.trace('Positions : Industry is US_GOVERNMENT');
2619:
2620: -- create only federal job segments with specified value segment name valuesets.
2621: -- First Segment 'Name' valueset '60 Characters'

Line 2618: hr_utility.trace('Positions : Industry is US_GOVERNMENT');

2614:
2615: hr_utility.set_location(l_proc, 60);
2616: else
2617: hr_utility.set_location(l_proc, 70);
2618: hr_utility.trace('Positions : Industry is US_GOVERNMENT');
2619:
2620: -- create only federal job segments with specified value segment name valuesets.
2621: -- First Segment 'Name' valueset '60 Characters'
2622: if NOT (p_technical_summary_mode) then

Line 2939: hr_utility.set_location(l_proc, 90);

2935: end if;
2936:
2937: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Agency Code';
2938: per_ri_config_utilities.write_log(p_message => l_log_message);
2939: hr_utility.set_location(l_proc, 90);
2940: end if;
2941:
2942: --
2943: -- freeze and compile this flexfield

Line 2962: hr_utility.set_location(' Leaving:'|| l_proc, 100);

2958: ,p_flex_code => 'POS'
2959: ,p_structure_code => l_pos_structures_code);
2960: end if;
2961:
2962: hr_utility.set_location(' Leaving:'|| l_proc, 100);
2963:
2964: EXCEPTION
2965: when others then
2966: l_error_message := 'Error in ' || l_proc;

Line 2967: hr_utility.trace(l_error_message || '-' || sqlerrm);

2963:
2964: EXCEPTION
2965: when others then
2966: l_error_message := 'Error in ' || l_proc;
2967: hr_utility.trace(l_error_message || '-' || sqlerrm);
2968: hr_utility.set_location(' Leaving:'|| l_proc, 500);
2969: hr_utility.raise_error;
2970:
2971: END create_global_job_pos_kf;

Line 2968: hr_utility.set_location(' Leaving:'|| l_proc, 500);

2964: EXCEPTION
2965: when others then
2966: l_error_message := 'Error in ' || l_proc;
2967: hr_utility.trace(l_error_message || '-' || sqlerrm);
2968: hr_utility.set_location(' Leaving:'|| l_proc, 500);
2969: hr_utility.raise_error;
2970:
2971: END create_global_job_pos_kf;
2972:

Line 2969: hr_utility.raise_error;

2965: when others then
2966: l_error_message := 'Error in ' || l_proc;
2967: hr_utility.trace(l_error_message || '-' || sqlerrm);
2968: hr_utility.set_location(' Leaving:'|| l_proc, 500);
2969: hr_utility.raise_error;
2970:
2971: END create_global_job_pos_kf;
2972:
2973: /* --------------------------------------------------------------------------

Line 3009: hr_utility.set_location('Entering:'|| l_proc, 10);

3005: l_value_set_tab_count number(9) := 1;
3006:
3007:
3008: BEGIN
3009: hr_utility.set_location('Entering:'|| l_proc, 10);
3010:
3011: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
3012:
3013: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry

Line 3017: hr_utility.set_location(l_proc, 20);

3013: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
3014: (p_configuration_code => p_configuration_code);
3015:
3016: -- Create Position Key flex
3017: hr_utility.set_location(l_proc, 20);
3018:
3019: l_pos_structures_code := per_ri_config_utilities.return_config_entity_name
3020: (per_ri_config_main.g_global_pos_structure_name);
3021: if NOT (p_technical_summary_mode) then

Line 3040: hr_utility.set_location(l_proc, 30);

3036:
3037: l_log_message := 'Created KEYFLEX PER POS ' || l_pos_structures_code;
3038: per_ri_config_utilities.write_log(p_message => l_log_message);
3039:
3040: hr_utility.set_location(l_proc, 30);
3041:
3042: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
3043: hr_utility.set_location(l_proc, 50);
3044:

Line 3043: hr_utility.set_location(l_proc, 50);

3039:
3040: hr_utility.set_location(l_proc, 30);
3041:
3042: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
3043: hr_utility.set_location(l_proc, 50);
3044:
3045: -- Create Position Key Flex Segments
3046: if NOT (p_technical_summary_mode) then
3047: per_ri_config_utilities.create_flex_segments

Line 3107: hr_utility.set_location(l_proc, 60);

3103:
3104: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || l_pos_structures_code;
3105: per_ri_config_utilities.write_log(p_message => l_log_message);
3106:
3107: hr_utility.set_location(l_proc, 60);
3108: else
3109: hr_utility.set_location(l_proc, 70);
3110: hr_utility.trace('Positions : Industry is US_GOVERNMENT');
3111:

Line 3109: hr_utility.set_location(l_proc, 70);

3105: per_ri_config_utilities.write_log(p_message => l_log_message);
3106:
3107: hr_utility.set_location(l_proc, 60);
3108: else
3109: hr_utility.set_location(l_proc, 70);
3110: hr_utility.trace('Positions : Industry is US_GOVERNMENT');
3111:
3112: -- create only federal position segments with specified value segment name valuesets.
3113: -- First Segment

Line 3110: hr_utility.trace('Positions : Industry is US_GOVERNMENT');

3106:
3107: hr_utility.set_location(l_proc, 60);
3108: else
3109: hr_utility.set_location(l_proc, 70);
3110: hr_utility.trace('Positions : Industry is US_GOVERNMENT');
3111:
3112: -- create only federal position segments with specified value segment name valuesets.
3113: -- First Segment
3114: if NOT (p_technical_summary_mode) then

Line 3367: hr_utility.set_location(l_proc, 90);

3363: end if;
3364:
3365: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Agency Code';
3366: per_ri_config_utilities.write_log(p_message => l_log_message);
3367: hr_utility.set_location(l_proc, 90);
3368: end if;
3369:
3370: --
3371: -- freeze and compile this flexfield

Line 3378: hr_utility.set_location(' Leaving:'|| l_proc, 100);

3374: (p_appl_short_Name => 'PER'
3375: ,p_flex_code => 'POS'
3376: ,p_structure_code => l_pos_structures_code);
3377:
3378: hr_utility.set_location(' Leaving:'|| l_proc, 100);
3379:
3380: EXCEPTION
3381: when others then
3382: l_error_message := 'Error in ' || l_proc;

Line 3383: hr_utility.trace(l_error_message || '-' || sqlerrm);

3379:
3380: EXCEPTION
3381: when others then
3382: l_error_message := 'Error in ' || l_proc;
3383: hr_utility.trace(l_error_message || '-' || sqlerrm);
3384: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3385: hr_utility.raise_error;
3386:
3387: END create_global_pos_kf;

Line 3384: hr_utility.set_location(' Leaving:'|| l_proc, 500);

3380: EXCEPTION
3381: when others then
3382: l_error_message := 'Error in ' || l_proc;
3383: hr_utility.trace(l_error_message || '-' || sqlerrm);
3384: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3385: hr_utility.raise_error;
3386:
3387: END create_global_pos_kf;
3388:

Line 3385: hr_utility.raise_error;

3381: when others then
3382: l_error_message := 'Error in ' || l_proc;
3383: hr_utility.trace(l_error_message || '-' || sqlerrm);
3384: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3385: hr_utility.raise_error;
3386:
3387: END create_global_pos_kf;
3388:
3389: /* --------------------------------------------------------------------------

Line 3423: hr_utility.set_location('Entering:'|| l_proc, 10);

3419: l_grd_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
3420: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
3421:
3422: BEGIN
3423: hr_utility.set_location('Entering:'|| l_proc, 10);
3424:
3425: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
3426: (p_configuration_code => p_configuration_code);
3427:

Line 3431: hr_utility.set_location(l_proc, 20);

3427:
3428: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
3429:
3430: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
3431: hr_utility.set_location(l_proc, 20);
3432: -- Create Grade Key Flex
3433: l_grd_structures_code := per_ri_config_utilities.return_config_entity_name
3434: (per_ri_config_main.g_global_grd_structure_name);
3435: if NOT (p_technical_summary_mode) then

Line 3596: hr_utility.trace(l_error_message || '-' || sqlerrm);

3592:
3593: EXCEPTION
3594: when others then
3595: l_error_message := 'Error in ' || l_proc;
3596: hr_utility.trace(l_error_message || '-' || sqlerrm);
3597: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3598: hr_utility.raise_error;
3599:
3600: END create_global_grd_kf;

Line 3597: hr_utility.set_location(' Leaving:'|| l_proc, 500);

3593: EXCEPTION
3594: when others then
3595: l_error_message := 'Error in ' || l_proc;
3596: hr_utility.trace(l_error_message || '-' || sqlerrm);
3597: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3598: hr_utility.raise_error;
3599:
3600: END create_global_grd_kf;
3601:

Line 3598: hr_utility.raise_error;

3594: when others then
3595: l_error_message := 'Error in ' || l_proc;
3596: hr_utility.trace(l_error_message || '-' || sqlerrm);
3597: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3598: hr_utility.raise_error;
3599:
3600: END create_global_grd_kf;
3601:
3602: /* --------------------------------------------------------------------------

Line 3629: hr_utility.set_location('Entering:'|| l_proc, 10);

3625: l_value_set_exists boolean;
3626:
3627: BEGIN
3628:
3629: hr_utility.set_location('Entering:'|| l_proc, 10);
3630:
3631: fnd_flex_val_api.set_session_mode('customer_data');
3632:
3633: -- Create PER_RI_DEFAULT_GRADES

Line 3636: hr_utility.set_location(l_proc, 20);

3632:
3633: -- Create PER_RI_DEFAULT_GRADES
3634: l_value_set_exists := fnd_flex_val_api.valueset_exists(value_set => 'PER_RI_CONFIG_DEFAULT_GRADES');
3635: if not (l_value_set_exists) then
3636: hr_utility.set_location(l_proc, 20);
3637: l_description := 'The default Grades Value Set is generated by Enterprise Structures Configuration '
3638: || 'and used in Grade flexfield validation. This will initially be empty and can '
3639: || 'be populated using the load reference data';
3640: fnd_flex_val_api.create_valueset_independent

Line 3656: hr_utility.set_location(l_proc, 30);

3652: ,max_value => l_max_value);
3653: l_log_message := 'Created DEFAULT VALUESET ' || 'PER_RI_CONFIG_DEFAULT_GRADES';
3654: per_ri_config_utilities.write_log(p_message => l_log_message);
3655: end if;
3656: hr_utility.set_location(l_proc, 30);
3657: -- Create PER_RI_DEFAULT_GRADES
3658: l_value_set_exists := fnd_flex_val_api.valueset_exists(value_set => 'PER_RI_CONFIG_DEFAULT_LEVELS');
3659: if not (l_value_set_exists) then
3660: hr_utility.set_location(l_proc, 40);

Line 3660: hr_utility.set_location(l_proc, 40);

3656: hr_utility.set_location(l_proc, 30);
3657: -- Create PER_RI_DEFAULT_GRADES
3658: l_value_set_exists := fnd_flex_val_api.valueset_exists(value_set => 'PER_RI_CONFIG_DEFAULT_LEVELS');
3659: if not (l_value_set_exists) then
3660: hr_utility.set_location(l_proc, 40);
3661: l_description := 'The default Grades Level Value Set is generated by Enterprise Structures Configuration '
3662: || 'and used in Grade flexfield validation. This will initially be empty and can '
3663: || 'be populated using the load reference data';
3664: fnd_flex_val_api.create_valueset_independent

Line 3679: hr_utility.set_location(l_proc, 50);

3675: ,min_value => l_min_value
3676: ,max_value => l_max_value);
3677: l_log_message := 'Created DEFAULT VALUESET ' || 'PER_RI_CONFIG_DEFAULT_LEVELS';
3678: end if;
3679: hr_utility.set_location(l_proc, 50);
3680:
3681: -- Create PER_RI_DEFAULT_GRADES
3682: l_description := 'The default Account Number Value Set is generated by Enterprise Structures Configuration '
3683: || 'and used in Grade flexfield validation. This will initially be empty and can '

Line 3687: hr_utility.set_location(l_proc, 60);

3683: || 'and used in Grade flexfield validation. This will initially be empty and can '
3684: || 'be populated using the load reference data';
3685: l_value_set_exists := fnd_flex_val_api.valueset_exists(value_set => 'PER_RI_CONFIG_DEFAULT_ACCOUNT');
3686: if not (l_value_set_exists) then
3687: hr_utility.set_location(l_proc, 60);
3688: fnd_flex_val_api.create_valueset_independent
3689: (value_set_name => 'PER_RI_CONFIG_DEFAULT_ACCOUNT'
3690: ,description => l_description
3691: ,security_available => l_security_available

Line 3703: hr_utility.set_location(l_proc, 70);

3699: ,min_value => l_min_value
3700: ,max_value => l_max_value);
3701: l_log_message := 'Created DEFAULT VALUESET ' || 'PER_RI_CONFIG_DEFAULT_ACCOUNT';
3702: end if;
3703: hr_utility.set_location(l_proc, 70);
3704: -- Create PER_RI_DEFAULT_GRADES
3705: l_description := 'The default Company Value Set is generated by Enterprise Structures Configuration '
3706: || 'and used in Grade flexfield validation. This will initially be empty and can '
3707: || 'be populated using the load reference data';

Line 3710: hr_utility.set_location(l_proc, 80);

3706: || 'and used in Grade flexfield validation. This will initially be empty and can '
3707: || 'be populated using the load reference data';
3708: l_value_set_exists := fnd_flex_val_api.valueset_exists(value_set => 'PER_RI_CONFIG_DEFAULT_COMPANY');
3709: if not (l_value_set_exists) then
3710: hr_utility.set_location(l_proc, 80);
3711: fnd_flex_val_api.create_valueset_independent
3712: (value_set_name => 'PER_RI_CONFIG_DEFAULT_COMPANY'
3713: ,description => l_description
3714: ,security_available => l_security_available

Line 3726: hr_utility.set_location(l_proc, 90);

3722: ,min_value => l_min_value
3723: ,max_value => l_max_value);
3724: l_log_message := 'Created DEFAULT VALUESET ' || 'PER_RI_CONFIG_DEFAULT_COMPANY';
3725: end if;
3726: hr_utility.set_location(l_proc, 90);
3727: -- Create PER_RI_DEFAULT_GRADES
3728: l_description := 'The default Cost Center Value Set is generated by Enterprise Structures Configuration '
3729: || 'and used in Grade flexfield validation. This will initially be empty and can '
3730: || 'be populated using the load reference data';

Line 3733: hr_utility.set_location(l_proc, 100);

3729: || 'and used in Grade flexfield validation. This will initially be empty and can '
3730: || 'be populated using the load reference data';
3731: l_value_set_exists := fnd_flex_val_api.valueset_exists(value_set => 'PER_RI_CONFIG_DEFAULT_CC');
3732: if not (l_value_set_exists) then
3733: hr_utility.set_location(l_proc, 100);
3734: fnd_flex_val_api.create_valueset_independent
3735: (value_set_name => 'PER_RI_CONFIG_DEFAULT_CC'
3736: ,description => l_description
3737: ,security_available => l_security_available

Line 3750: hr_utility.set_location(' Leaving:'|| l_proc, 120);

3746: ,max_value => l_max_value);
3747: l_log_message := 'Created DEFAULT VALUESET ' || 'PER_RI_CONFIG_DEFAULT_CC';
3748: end if;
3749:
3750: hr_utility.set_location(' Leaving:'|| l_proc, 120);
3751:
3752: EXCEPTION
3753: when others then
3754: l_error_message := 'Error in ' || l_proc;

Line 3755: hr_utility.trace(l_error_message || '-' || sqlerrm);

3751:
3752: EXCEPTION
3753: when others then
3754: l_error_message := 'Error in ' || l_proc;
3755: hr_utility.trace(l_error_message || '-' || sqlerrm);
3756: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3757: hr_utility.raise_error;
3758:
3759:

Line 3756: hr_utility.set_location(' Leaving:'|| l_proc, 500);

3752: EXCEPTION
3753: when others then
3754: l_error_message := 'Error in ' || l_proc;
3755: hr_utility.trace(l_error_message || '-' || sqlerrm);
3756: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3757: hr_utility.raise_error;
3758:
3759:
3760: END create_default_value_sets;

Line 3757: hr_utility.raise_error;

3753: when others then
3754: l_error_message := 'Error in ' || l_proc;
3755: hr_utility.trace(l_error_message || '-' || sqlerrm);
3756: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3757: hr_utility.raise_error;
3758:
3759:
3760: END create_default_value_sets;
3761:

Line 3866: hr_utility.set_location('Entering:'|| l_proc, 10);

3862: l_profile_resp_main_tab per_ri_config_tech_summary.profile_resp_tab;
3863:
3864: BEGIN
3865:
3866: hr_utility.set_location('Entering:'|| l_proc, 10);
3867:
3868: l_configuration_user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
3869: (per_ri_config_main.g_configuration_user_name));
3870: open csr_get_product(p_configuration_code);

Line 3875: hr_utility.trace('l_product_name = ' || l_product_name);

3871:
3872: loop
3873: fetch csr_get_product into l_product_name;
3874: exit when csr_get_product%NOTFOUND;
3875: hr_utility.trace('l_product_name = ' || l_product_name);
3876:
3877: if l_product_name = 'PER' then
3878: l_hr := TRUE;
3879: end if;

Line 3893: hr_utility.set_location(l_proc, 30);

3889: end loop;
3890:
3891: close csr_get_product;
3892:
3893: hr_utility.set_location(l_proc, 30);
3894:
3895: --
3896: -- assign hrms self service responsibilities
3897: --

Line 3911: hr_utility.trace('Assigned Responsibility: ' || 'EMPLOYEE_DIRECT_ACCESS');

3907: x_owner => 'SEED',
3908: x_start_date => l_start_date,
3909: x_end_date => l_end_date,
3910: x_description => per_ri_config_main.g_description_string);
3911: hr_utility.trace('Assigned Responsibility: ' || 'EMPLOYEE_DIRECT_ACCESS');
3912: hr_utility.set_location(l_proc, 40);
3913: else
3914: p_hrms_resp_tab(l_hrms_resp_count).user_name := l_configuration_user_name;
3915: p_hrms_resp_tab(l_hrms_resp_count).resp_key := 'EMPLOYEE_DIRECT_ACCESS_V4';

Line 3912: hr_utility.set_location(l_proc, 40);

3908: x_start_date => l_start_date,
3909: x_end_date => l_end_date,
3910: x_description => per_ri_config_main.g_description_string);
3911: hr_utility.trace('Assigned Responsibility: ' || 'EMPLOYEE_DIRECT_ACCESS');
3912: hr_utility.set_location(l_proc, 40);
3913: else
3914: p_hrms_resp_tab(l_hrms_resp_count).user_name := l_configuration_user_name;
3915: p_hrms_resp_tab(l_hrms_resp_count).resp_key := 'EMPLOYEE_DIRECT_ACCESS_V4';
3916: p_hrms_resp_tab(l_hrms_resp_count).app_short_name := 'PER';

Line 3948: hr_utility.trace('Assigned Responsibility: ' || 'LINE_MANAGER_DIRECT_ACCESS');

3944: p_hrms_resp_tab(l_hrms_resp_count).description := per_ri_config_main.g_description_string;
3945:
3946: l_hrms_resp_count := l_hrms_resp_count + 1 ;
3947: end if;
3948: hr_utility.trace('Assigned Responsibility: ' || 'LINE_MANAGER_DIRECT_ACCESS');
3949: hr_utility.set_location(l_proc, 50);
3950: end if;
3951:
3952: --decide on the responsibility to be assigned.

Line 3949: hr_utility.set_location(l_proc, 50);

3945:
3946: l_hrms_resp_count := l_hrms_resp_count + 1 ;
3947: end if;
3948: hr_utility.trace('Assigned Responsibility: ' || 'LINE_MANAGER_DIRECT_ACCESS');
3949: hr_utility.set_location(l_proc, 50);
3950: end if;
3951:
3952: --decide on the responsibility to be assigned.
3953:

Line 3954: hr_utility.set_location(l_proc, 60);

3950: end if;
3951:
3952: --decide on the responsibility to be assigned.
3953:
3954: hr_utility.set_location(l_proc, 60);
3955: l_assign_responsibility := 'PER';
3956:
3957: if l_hr and not l_hrms and not l_benefits then
3958: l_assign_responsibility := 'PER';

Line 3977: hr_utility.trace('l_assign_responsibility = ' || l_assign_responsibility);

3973: := per_ri_config_utilities.determine_country_resp
3974: (p_country_code => l_country_code
3975: ,p_assign_responsibility => l_assign_responsibility);
3976:
3977: hr_utility.trace('l_assign_responsibility = ' || l_assign_responsibility);
3978: hr_utility.trace('l_assign_determined_resp = ' || l_assign_determined_resp);
3979: --open csr_get_responsibility(l_country_code
3980: -- ,l_assign_responsibility);
3981:

Line 3978: hr_utility.trace('l_assign_determined_resp = ' || l_assign_determined_resp);

3974: (p_country_code => l_country_code
3975: ,p_assign_responsibility => l_assign_responsibility);
3976:
3977: hr_utility.trace('l_assign_responsibility = ' || l_assign_responsibility);
3978: hr_utility.trace('l_assign_determined_resp = ' || l_assign_determined_resp);
3979: --open csr_get_responsibility(l_country_code
3980: -- ,l_assign_responsibility);
3981:
3982: open csr_get_responsibility(l_country_code

Line 3990: hr_utility.trace('l_country_code : ' || l_country_code);

3986: ,l_fnd_application_short_name;
3987:
3988: exit when csr_get_responsibility%NOTFOUND;
3989:
3990: hr_utility.trace('l_country_code : ' || l_country_code);
3991: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);
3992: hr_utility.trace('l_fnd_application_short_name : ' || l_fnd_application_short_name);
3993:
3994: -- Security Group Removal Changes

Line 3991: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);

3987:
3988: exit when csr_get_responsibility%NOTFOUND;
3989:
3990: hr_utility.trace('l_country_code : ' || l_country_code);
3991: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);
3992: hr_utility.trace('l_fnd_application_short_name : ' || l_fnd_application_short_name);
3993:
3994: -- Security Group Removal Changes
3995: -- This is taken care by security_profile_assignment creation

Line 3992: hr_utility.trace('l_fnd_application_short_name : ' || l_fnd_application_short_name);

3988: exit when csr_get_responsibility%NOTFOUND;
3989:
3990: hr_utility.trace('l_country_code : ' || l_country_code);
3991: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);
3992: hr_utility.trace('l_fnd_application_short_name : ' || l_fnd_application_short_name);
3993:
3994: -- Security Group Removal Changes
3995: -- This is taken care by security_profile_assignment creation
3996: --assign responsibility

Line 4006: hr_utility.trace('Assigned Responsibility:' || l_responsibility_key || ':' || l_fnd_application_short_name);

4002: x_owner => 'SEED',
4003: x_start_date => l_start_date,
4004: x_end_date => l_end_date,
4005: x_description => per_ri_config_main.g_description_string);
4006: hr_utility.trace('Assigned Responsibility:' || l_responsibility_key || ':' || l_fnd_application_short_name);
4007: */
4008: -- get business group name for given country code
4009: l_business_group_name_main := per_ri_config_utilities.get_enterprise_short_name
4010: (p_configuration_code => p_configuration_code)

Line 4049: hr_utility.trace('l_business_group_name_main : ' || l_business_group_name_main);

4045: l_hrms_resp_count := l_hrms_resp_count + 1;
4046: end if;
4047:
4048:
4049: hr_utility.trace('l_business_group_name_main : ' || l_business_group_name_main);
4050: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);
4051:
4052: hr_utility.trace('l_row_count inside = ' || to_char(l_row_count));
4053:

Line 4050: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);

4046: end if;
4047:
4048:
4049: hr_utility.trace('l_business_group_name_main : ' || l_business_group_name_main);
4050: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);
4051:
4052: hr_utility.trace('l_row_count inside = ' || to_char(l_row_count));
4053:
4054: end loop;

Line 4052: hr_utility.trace('l_row_count inside = ' || to_char(l_row_count));

4048:
4049: hr_utility.trace('l_business_group_name_main : ' || l_business_group_name_main);
4050: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);
4051:
4052: hr_utility.trace('l_row_count inside = ' || to_char(l_row_count));
4053:
4054: end loop;
4055: l_row_count := l_row_count + (csr_get_responsibility%ROWCOUNT);
4056: hr_utility.trace('l_row_count outside = ' || to_char(l_row_count));

Line 4056: hr_utility.trace('l_row_count outside = ' || to_char(l_row_count));

4052: hr_utility.trace('l_row_count inside = ' || to_char(l_row_count));
4053:
4054: end loop;
4055: l_row_count := l_row_count + (csr_get_responsibility%ROWCOUNT);
4056: hr_utility.trace('l_row_count outside = ' || to_char(l_row_count));
4057: close csr_get_responsibility;
4058: end loop;
4059: close csr_get_country;
4060:

Line 4062: hr_utility.set_location('Entering:'|| l_proc, 210);

4058: end loop;
4059: close csr_get_country;
4060:
4061: --process gobal responsibility
4062: hr_utility.set_location('Entering:'|| l_proc, 210);
4063: l_assign_glb_resp_key_app_name := 'PER';
4064:
4065: if l_hr and not l_hrms and not l_benefits then
4066: l_assign_global_resp_key := 'GLOBAL HR MANAGER';

Line 4085: hr_utility.set_location('Entering:'|| l_proc, 220);

4081: l_assign_global_resp_key := 'US_BEN_MANAGER';
4082: l_assign_glb_resp_key_app_name := 'BEN';
4083: end if;
4084:
4085: hr_utility.set_location('Entering:'|| l_proc, 220);
4086: hr_utility.trace('l_assign_glb_resp_key_app_name : ' || l_assign_glb_resp_key_app_name);
4087: hr_utility.trace('l_assign_global_resp_key : ' || l_assign_global_resp_key);
4088:
4089: l_earlier_row_count := p_security_profile_tab.count + 1;

Line 4086: hr_utility.trace('l_assign_glb_resp_key_app_name : ' || l_assign_glb_resp_key_app_name);

4082: l_assign_glb_resp_key_app_name := 'BEN';
4083: end if;
4084:
4085: hr_utility.set_location('Entering:'|| l_proc, 220);
4086: hr_utility.trace('l_assign_glb_resp_key_app_name : ' || l_assign_glb_resp_key_app_name);
4087: hr_utility.trace('l_assign_global_resp_key : ' || l_assign_global_resp_key);
4088:
4089: l_earlier_row_count := p_security_profile_tab.count + 1;
4090: hr_utility.trace('GLOBAL l_earlier_row_count : ' || l_earlier_row_count);

Line 4087: hr_utility.trace('l_assign_global_resp_key : ' || l_assign_global_resp_key);

4083: end if;
4084:
4085: hr_utility.set_location('Entering:'|| l_proc, 220);
4086: hr_utility.trace('l_assign_glb_resp_key_app_name : ' || l_assign_glb_resp_key_app_name);
4087: hr_utility.trace('l_assign_global_resp_key : ' || l_assign_global_resp_key);
4088:
4089: l_earlier_row_count := p_security_profile_tab.count + 1;
4090: hr_utility.trace('GLOBAL l_earlier_row_count : ' || l_earlier_row_count);
4091:

Line 4090: hr_utility.trace('GLOBAL l_earlier_row_count : ' || l_earlier_row_count);

4086: hr_utility.trace('l_assign_glb_resp_key_app_name : ' || l_assign_glb_resp_key_app_name);
4087: hr_utility.trace('l_assign_global_resp_key : ' || l_assign_global_resp_key);
4088:
4089: l_earlier_row_count := p_security_profile_tab.count + 1;
4090: hr_utility.trace('GLOBAL l_earlier_row_count : ' || l_earlier_row_count);
4091:
4092: open csr_global_responsibility(p_configuration_code);
4093: loop
4094: fetch csr_global_responsibility into l_country_code_global;

Line 4097: hr_utility.trace('Assigned Global Responsibility:' || l_assign_global_resp_key );

4093: loop
4094: fetch csr_global_responsibility into l_country_code_global;
4095: exit when csr_global_responsibility%NOTFOUND;
4096:
4097: hr_utility.trace('Assigned Global Responsibility:' || l_assign_global_resp_key );
4098:
4099: -- get business group name for given country code
4100: -- business group name and security profile names are same
4101: l_business_group_name_global := per_ri_config_utilities.get_enterprise_short_name

Line 4159: hr_utility.trace('Security Group Removal Changes');

4155: l_business_group_name_global := per_ri_config_utilities.get_enterprise_short_name
4156: (p_configuration_code => p_configuration_code)
4157: || ' ' || l_country_code_global || per_ri_config_main.g_bg_name_suffix_string;
4158:
4159: hr_utility.trace('Security Group Removal Changes');
4160: per_ri_config_fnd_hr_entity.create_bg_id_and_sg_id_profile
4161: (p_configuration_code => p_configuration_code
4162: ,p_responsibility_key => l_assign_global_resp_key
4163: ,p_responsibility_name => l_assign_global_resp_name

Line 4172: hr_utility.trace(l_error_message || '-' || sqlerrm);

4168:
4169: EXCEPTION
4170: when others then
4171: l_error_message := 'Error in ' || l_proc;
4172: hr_utility.trace(l_error_message || '-' || sqlerrm);
4173: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4174: hr_utility.raise_error;
4175:
4176: END create_hrms_responsibility;

Line 4173: hr_utility.set_location(' Leaving:'|| l_proc, 500);

4169: EXCEPTION
4170: when others then
4171: l_error_message := 'Error in ' || l_proc;
4172: hr_utility.trace(l_error_message || '-' || sqlerrm);
4173: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4174: hr_utility.raise_error;
4175:
4176: END create_hrms_responsibility;
4177:

Line 4174: hr_utility.raise_error;

4170: when others then
4171: l_error_message := 'Error in ' || l_proc;
4172: hr_utility.trace(l_error_message || '-' || sqlerrm);
4173: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4174: hr_utility.raise_error;
4175:
4176: END create_hrms_responsibility;
4177:
4178: /* --------------------------------------------------------------------------

Line 4203: hr_utility.set_location('Entering:'|| l_proc, 10);

4199: l_log_message varchar2(360);
4200: l_error_message varchar2(360);
4201:
4202: BEGIN
4203: hr_utility.set_location('Entering:'|| l_proc, 10);
4204:
4205: open csr_get_product(p_configuration_code);
4206:
4207: loop

Line 4216: hr_utility.trace('l_product_name ' || l_product_name);

4212: /* DGARG MSG Changes
4213: -- For each product selected set application level profile option
4214: -- ENABLE_SECURITY_GROUPS
4215: if l_product_name in ('PER','PAY','BEN') then
4216: hr_utility.trace('l_product_name ' || l_product_name);
4217: if NOT (p_technical_summary_mode) then
4218: per_ri_config_utilities.set_profile_option_value
4219: (p_level => 10002
4220: ,p_level_value => l_product_name

Line 4265: hr_utility.trace(l_log_message);

4261: l_log_message := 'The profile setting has errored out for application '
4262: || rec.application_id;
4263: end if;
4264: per_ri_config_utilities.write_log(p_message => l_log_message);
4265: hr_utility.trace(l_log_message);
4266: end loop;
4267: --
4268: */
4269:

Line 4273: hr_utility.trace(l_error_message || '-' || sqlerrm);

4269:
4270: EXCEPTION
4271: when others then
4272: l_error_message := 'Error in ' || l_proc;
4273: hr_utility.trace(l_error_message || '-' || sqlerrm);
4274: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4275: hr_utility.raise_error;
4276:
4277: END create_application_level_resp;

Line 4274: hr_utility.set_location(' Leaving:'|| l_proc, 500);

4270: EXCEPTION
4271: when others then
4272: l_error_message := 'Error in ' || l_proc;
4273: hr_utility.trace(l_error_message || '-' || sqlerrm);
4274: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4275: hr_utility.raise_error;
4276:
4277: END create_application_level_resp;
4278: /* --------------------------------------------------------------------------

Line 4275: hr_utility.raise_error;

4271: when others then
4272: l_error_message := 'Error in ' || l_proc;
4273: hr_utility.trace(l_error_message || '-' || sqlerrm);
4274: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4275: hr_utility.raise_error;
4276:
4277: END create_application_level_resp;
4278: /* --------------------------------------------------------------------------
4279: -- Name : create_resp_level_profile

Line 4316: hr_utility.set_location('Entering:'|| l_proc, 10);

4312: l_proc varchar2(72) := g_package || 'create_resp_level_profile';
4313: l_error_message varchar2(360);
4314:
4315: BEGIN
4316: hr_utility.set_location('Entering:'|| l_proc, 10);
4317:
4318: -- only one row is there
4319: open csr_get_resp_key_app(p_responsibility_key);
4320: fetch csr_get_resp_key_app into l_application_short_name;

Line 4342: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);

4338: else
4339: l_hr_user_type := 'PER';
4340: end if;
4341:
4342: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4343: hr_utility.trace('l_hr_user_type ' || l_hr_user_type);
4344: if NOT (p_technical_summary_mode) then
4345: per_ri_config_utilities.set_profile_option_value
4346: (p_level => 10003

Line 4343: hr_utility.trace('l_hr_user_type ' || l_hr_user_type);

4339: l_hr_user_type := 'PER';
4340: end if;
4341:
4342: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4343: hr_utility.trace('l_hr_user_type ' || l_hr_user_type);
4344: if NOT (p_technical_summary_mode) then
4345: per_ri_config_utilities.set_profile_option_value
4346: (p_level => 10003
4347: ,p_level_value => p_responsibility_key

Line 4363: hr_utility.trace('Created HR_USER_TYPE for '|| l_product_name);

4359:
4360: end if;
4361:
4362:
4363: hr_utility.trace('Created HR_USER_TYPE for '|| l_product_name);
4364: hr_utility.set_location('Leaving:'|| l_proc, 40);
4365:
4366: EXCEPTION
4367: when others then

Line 4364: hr_utility.set_location('Leaving:'|| l_proc, 40);

4360: end if;
4361:
4362:
4363: hr_utility.trace('Created HR_USER_TYPE for '|| l_product_name);
4364: hr_utility.set_location('Leaving:'|| l_proc, 40);
4365:
4366: EXCEPTION
4367: when others then
4368: l_error_message := 'Error in ' || l_proc;

Line 4369: hr_utility.trace(l_error_message || '-' || sqlerrm);

4365:
4366: EXCEPTION
4367: when others then
4368: l_error_message := 'Error in ' || l_proc;
4369: hr_utility.trace(l_error_message || '-' || sqlerrm);
4370: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4371: hr_utility.raise_error;
4372:
4373: END create_resp_level_profile;

Line 4370: hr_utility.set_location(' Leaving:'|| l_proc, 500);

4366: EXCEPTION
4367: when others then
4368: l_error_message := 'Error in ' || l_proc;
4369: hr_utility.trace(l_error_message || '-' || sqlerrm);
4370: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4371: hr_utility.raise_error;
4372:
4373: END create_resp_level_profile;
4374:

Line 4371: hr_utility.raise_error;

4367: when others then
4368: l_error_message := 'Error in ' || l_proc;
4369: hr_utility.trace(l_error_message || '-' || sqlerrm);
4370: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4371: hr_utility.raise_error;
4372:
4373: END create_resp_level_profile;
4374:
4375: /* --------------------------------------------------------------------------

Line 4433: hr_utility.set_location('Entering:'|| l_proc, 10);

4429: l_error_message varchar2(360);
4430: l_log_message varchar2(360);
4431:
4432: BEGIN
4433: hr_utility.set_location('Entering:'|| l_proc, 10);
4434:
4435: if NOT (p_technical_summary_mode) then
4436: -- only one row is there
4437: open csr_get_resp_key_app(p_responsibility_key);

Line 4450: hr_utility.trace('l_responsibility_id ' || l_responsibility_id);

4446: open csr_sg_id(p_business_group_name);
4447: fetch csr_sg_id into l_sg_id;
4448: close csr_sg_id;
4449:
4450: hr_utility.trace('l_responsibility_id ' || l_responsibility_id);
4451: hr_utility.trace('l_bg_id ' || l_bg_id);
4452: hr_utility.trace('l_sg_id ' || l_sg_id);
4453: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4454: hr_utility.trace('p_business_group_name ' || p_business_group_name);

Line 4451: hr_utility.trace('l_bg_id ' || l_bg_id);

4447: fetch csr_sg_id into l_sg_id;
4448: close csr_sg_id;
4449:
4450: hr_utility.trace('l_responsibility_id ' || l_responsibility_id);
4451: hr_utility.trace('l_bg_id ' || l_bg_id);
4452: hr_utility.trace('l_sg_id ' || l_sg_id);
4453: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4454: hr_utility.trace('p_business_group_name ' || p_business_group_name);
4455:

Line 4452: hr_utility.trace('l_sg_id ' || l_sg_id);

4448: close csr_sg_id;
4449:
4450: hr_utility.trace('l_responsibility_id ' || l_responsibility_id);
4451: hr_utility.trace('l_bg_id ' || l_bg_id);
4452: hr_utility.trace('l_sg_id ' || l_sg_id);
4453: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4454: hr_utility.trace('p_business_group_name ' || p_business_group_name);
4455:
4456: --

Line 4453: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);

4449:
4450: hr_utility.trace('l_responsibility_id ' || l_responsibility_id);
4451: hr_utility.trace('l_bg_id ' || l_bg_id);
4452: hr_utility.trace('l_sg_id ' || l_sg_id);
4453: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4454: hr_utility.trace('p_business_group_name ' || p_business_group_name);
4455:
4456: --
4457: -- Create PER_BUSINESS_GROUP_ID

Line 4454: hr_utility.trace('p_business_group_name ' || p_business_group_name);

4450: hr_utility.trace('l_responsibility_id ' || l_responsibility_id);
4451: hr_utility.trace('l_bg_id ' || l_bg_id);
4452: hr_utility.trace('l_sg_id ' || l_sg_id);
4453: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4454: hr_utility.trace('p_business_group_name ' || p_business_group_name);
4455:
4456: --
4457: -- Create PER_BUSINESS_GROUP_ID
4458: --

Line 4468: hr_utility.set_location(l_proc, 20);

4464: null;
4465: end if;
4466: l_log_message := 'Created Profile Option Value PER_BUSINESS_GROUP_ID ' || l_bg_id;
4467: per_ri_config_utilities.write_log(p_message => l_log_message);
4468: hr_utility.set_location(l_proc, 20);
4469:
4470: --
4471: -- Create PER_SECURITY_PROFILE_ID
4472: --

Line 4482: hr_utility.set_location(l_proc, 30);

4478: null;
4479: end if;
4480: l_log_message := 'Created Profile Option Value PER_SECURITY_PROFILE_ID ' || l_sg_id;
4481: per_ri_config_utilities.write_log(p_message => l_log_message);
4482: hr_utility.set_location(l_proc, 30);
4483:
4484: open csr_get_product(p_configuration_code);
4485: loop
4486: fetch csr_get_product into l_product_name;

Line 4514: hr_utility.set_location(' Leaving:'|| l_proc, 50);

4510: null;
4511: end if;
4512: l_log_message := 'Created Profile Option Value HR_USER_TYPE ' || l_hr_user_type;
4513: per_ri_config_utilities.write_log(p_message => l_log_message);
4514: hr_utility.set_location(' Leaving:'|| l_proc, 50);
4515:
4516: else
4517: hr_utility.set_location(l_proc, 110);
4518: open csr_get_product(p_configuration_code);

Line 4517: hr_utility.set_location(l_proc, 110);

4513: per_ri_config_utilities.write_log(p_message => l_log_message);
4514: hr_utility.set_location(' Leaving:'|| l_proc, 50);
4515:
4516: else
4517: hr_utility.set_location(l_proc, 110);
4518: open csr_get_product(p_configuration_code);
4519: loop
4520: fetch csr_get_product into l_product_name;
4521: exit when csr_get_product%NOTFOUND;

Line 4536: hr_utility.set_location(l_proc, 120);

4532: l_hr_user_type := 'INT';
4533: else
4534: l_hr_user_type := 'PER';
4535: end if;
4536: hr_utility.set_location(l_proc, 120);
4537: p_bg_sg_ut_profile_resp_tab(l_profile_count).level := 10003;
4538: p_bg_sg_ut_profile_resp_tab(l_profile_count).level_value := p_responsibility_key;
4539: p_bg_sg_ut_profile_resp_tab(l_profile_count).level_value_app := 'PER';
4540: p_bg_sg_ut_profile_resp_tab(l_profile_count).profile_name := 'PER_BUSINESS_GROUP_ID';

Line 4559: hr_utility.set_location(l_proc, 130);

4555: p_bg_sg_ut_profile_resp_tab(l_profile_count).profile_option_value := l_hr_user_type;
4556:
4557: l_profile_count := l_profile_count + 1;
4558:
4559: hr_utility.set_location(l_proc, 130);
4560: end if;
4561: EXCEPTION
4562: when others then
4563: l_error_message := 'Error in ' || l_proc;

Line 4564: hr_utility.trace(l_error_message || '-' || sqlerrm);

4560: end if;
4561: EXCEPTION
4562: when others then
4563: l_error_message := 'Error in ' || l_proc;
4564: hr_utility.trace(l_error_message || '-' || sqlerrm);
4565: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4566: hr_utility.raise_error;
4567:
4568: END create_bg_id_and_sg_id_profile;

Line 4565: hr_utility.set_location(' Leaving:'|| l_proc, 500);

4561: EXCEPTION
4562: when others then
4563: l_error_message := 'Error in ' || l_proc;
4564: hr_utility.trace(l_error_message || '-' || sqlerrm);
4565: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4566: hr_utility.raise_error;
4567:
4568: END create_bg_id_and_sg_id_profile;
4569:

Line 4566: hr_utility.raise_error;

4562: when others then
4563: l_error_message := 'Error in ' || l_proc;
4564: hr_utility.trace(l_error_message || '-' || sqlerrm);
4565: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4566: hr_utility.raise_error;
4567:
4568: END create_bg_id_and_sg_id_profile;
4569:
4570: END per_ri_config_fnd_hr_entity;