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 1341: hr_utility.set_location('Entering:'|| l_proc, 10);

1337: l_jobs_segment_count number(9);
1338: l_jobs_segment_no number(9);
1339:
1340: BEGIN
1341: hr_utility.set_location('Entering:'|| l_proc, 10);
1342:
1343: open csr_config_jobs_rv(p_configuration_code);
1344: LOOP
1345: fetch csr_config_jobs_rv into l_jobs_rv_name,l_jobs_rv_name_orig;

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

1345: fetch csr_config_jobs_rv into l_jobs_rv_name,l_jobs_rv_name_orig;
1346:
1347: exit when csr_config_jobs_rv%NOTFOUND;
1348:
1349: hr_utility.set_location(l_proc, 20);
1350: -- Create Jobs RV Key flex
1351: if NOT (p_technical_summary_mode) then
1352: l_jobs_keyflex_number := per_ri_config_utilities.create_key_flexfield
1353: (p_appl_short_Name => 'PER'

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

1367: end if;
1368:
1369: per_ri_config_utilities.write_log(p_message => 'Created Jobs RV Keyflex ' || l_jobs_rv_name
1370: || per_ri_config_main.g_job_rv_struct_def_string );
1371: hr_utility.trace('Created Jobs RV Keyflex ' || l_jobs_rv_name
1372: || per_ri_config_main.g_job_rv_struct_def_string);
1373:
1374: open csr_config_jobs_rv_seg(p_configuration_code
1375: ,l_jobs_rv_name_orig);

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

1444: l_kf_job_rv_seg_count := l_kf_job_rv_seg_count + 1 ;
1445: end if;
1446:
1447: per_ri_config_utilities.write_log(p_message => 'Created Grade Key Flex RV Segment' || l_rv_jobs_segment_name);
1448: hr_utility.trace('Created Job Key Flex RV Segment: ' || l_rv_jobs_segment_name);
1449: END LOOP;
1450: --
1451: -- freeze and compile this flexfield
1452: --

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

1463:
1464: EXCEPTION
1465: when others then
1466: l_error_message := 'Error in ' || l_proc;
1467: hr_utility.trace(l_error_message || '-' || sqlerrm);
1468: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1469: hr_utility.raise_error;
1470:
1471: END create_jobs_rv_keyflex;

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

1464: EXCEPTION
1465: when others then
1466: l_error_message := 'Error in ' || l_proc;
1467: hr_utility.trace(l_error_message || '-' || sqlerrm);
1468: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1469: hr_utility.raise_error;
1470:
1471: END create_jobs_rv_keyflex;
1472:

Line 1469: hr_utility.raise_error;

1465: when others then
1466: l_error_message := 'Error in ' || l_proc;
1467: hr_utility.trace(l_error_message || '-' || sqlerrm);
1468: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1469: hr_utility.raise_error;
1470:
1471: END create_jobs_rv_keyflex;
1472:
1473: /* --------------------------------------------------------------------------

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

1526:
1527: l_positions_segment_count number(9);
1528: l_positions_segment_no number(9);
1529: BEGIN
1530: hr_utility.set_location('Entering:'|| l_proc, 10);
1531:
1532: open csr_config_positions_rv(p_configuration_code);
1533: LOOP
1534: fetch csr_config_positions_rv into l_positions_rv_name,l_positions_rv_name_orig;

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

1534: fetch csr_config_positions_rv into l_positions_rv_name,l_positions_rv_name_orig;
1535:
1536: exit when csr_config_positions_rv%NOTFOUND;
1537:
1538: hr_utility.set_location(l_proc, 20);
1539: -- Create Jobs RV Key flex
1540: if NOT (p_technical_summary_mode) then
1541: l_positions_keyflex_number := per_ri_config_utilities.create_key_flexfield
1542: (p_appl_short_Name => 'PER'

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

1556: l_kf_pos_rv_count := l_kf_pos_rv_count + 1 ;
1557: end if;
1558: per_ri_config_utilities.write_log(p_message => 'Created Positions RV Keyflex ' || l_positions_rv_name
1559: || per_ri_config_main.g_pos_rv_struct_def_string );
1560: hr_utility.trace('Created Positions RV Keyflex ' || l_positions_rv_name
1561: || per_ri_config_main.g_pos_rv_struct_def_string);
1562:
1563: open csr_config_positions_rv_seg(p_configuration_code
1564: ,l_positions_rv_name_orig);

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

1633: := l_kf_pos_rv_valueset_tab(l_value_set_tab_count).max_value;
1634: l_kf_pos_rv_seg_count := l_kf_pos_rv_seg_count + 1 ;
1635: end if;
1636: per_ri_config_utilities.write_log(p_message => 'Created Positions Key Flex RV Segment' || l_rv_positions_segment_name);
1637: hr_utility.trace('Created Positions Key Flex RV Segment: ' || l_rv_positions_segment_name);
1638: END LOOP;
1639: --
1640: -- freeze and compile this flexfield
1641: --

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

1648: end if;
1649: close csr_config_positions_rv_seg;
1650: END LOOP;
1651: close csr_config_positions_rv;
1652: hr_utility.set_location('Leaving:'|| l_proc, 100);
1653: EXCEPTION
1654: when others then
1655: l_error_message := 'Error in ' || l_proc;
1656: hr_utility.trace(l_error_message || '-' || sqlerrm);

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

1652: hr_utility.set_location('Leaving:'|| l_proc, 100);
1653: EXCEPTION
1654: when others then
1655: l_error_message := 'Error in ' || l_proc;
1656: hr_utility.trace(l_error_message || '-' || sqlerrm);
1657: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1658: hr_utility.raise_error;
1659:
1660: END create_positions_rv_keyflex;

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

1653: EXCEPTION
1654: when others then
1655: l_error_message := 'Error in ' || l_proc;
1656: hr_utility.trace(l_error_message || '-' || sqlerrm);
1657: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1658: hr_utility.raise_error;
1659:
1660: END create_positions_rv_keyflex;
1661:

Line 1658: hr_utility.raise_error;

1654: when others then
1655: l_error_message := 'Error in ' || l_proc;
1656: hr_utility.trace(l_error_message || '-' || sqlerrm);
1657: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1658: hr_utility.raise_error;
1659:
1660: END create_positions_rv_keyflex;
1661:
1662: /* --------------------------------------------------------------------------

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

1712:
1713: l_grades_segment_count number(9);
1714: l_grades_segment_no number(9);
1715: BEGIN
1716: hr_utility.set_location('Entering:'|| l_proc, 10);
1717:
1718: open csr_config_grade_rv(p_configuration_code);
1719: LOOP
1720: fetch csr_config_grade_rv into l_grade_rv_name,l_grade_rv_name_orig;

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

1721:
1722: exit when csr_config_grade_rv%NOTFOUND;
1723:
1724: -- Create Grades RV Key Flex
1725: hr_utility.set_location(l_proc, 20);
1726: if NOT (p_technical_summary_mode) then
1727: l_grades_keyflex_number :=
1728: per_ri_config_utilities.create_key_flexfield
1729: (p_appl_short_Name => 'PER'

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

1743: l_kf_grd_rv_count := l_kf_grd_rv_count + 1 ;
1744: end if;
1745: per_ri_config_utilities.write_log(p_message => 'Created Grades RV Keyflex '
1746: || per_ri_config_main.g_grd_rv_struct_def_string );
1747: hr_utility.trace('Created Grades RV Keyflex ' || per_ri_config_main.g_grd_rv_struct_def_string);
1748:
1749: open csr_config_grade_rv_seg(p_configuration_code
1750: ,l_grade_rv_name_orig);
1751: l_grades_segment_count := 0;

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

1817: := l_kf_grd_rv_valueset_tab(l_value_set_tab_count).max_value;
1818: l_kf_grd_rv_seg_count := l_kf_grd_rv_seg_count + 1 ;
1819: end if;
1820: per_ri_config_utilities.write_log(p_message => 'Created Grade Key Flex RV Segment' || l_rv_grade_segment_name);
1821: hr_utility.trace('Created Job Key Flex RV Segment: ' || l_rv_grade_segment_name);
1822: END LOOP;
1823: close csr_config_grade_rv_seg;
1824: --
1825: -- freeze and compile this flexfield

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

1836:
1837: EXCEPTION
1838: when others then
1839: l_error_message := 'Error in ' || l_proc;
1840: hr_utility.trace(l_error_message || '-' || sqlerrm);
1841: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1842: hr_utility.raise_error;
1843:
1844: END create_grades_rv_keyflex;

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

1837: EXCEPTION
1838: when others then
1839: l_error_message := 'Error in ' || l_proc;
1840: hr_utility.trace(l_error_message || '-' || sqlerrm);
1841: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1842: hr_utility.raise_error;
1843:
1844: END create_grades_rv_keyflex;
1845:

Line 1842: hr_utility.raise_error;

1838: when others then
1839: l_error_message := 'Error in ' || l_proc;
1840: hr_utility.trace(l_error_message || '-' || sqlerrm);
1841: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1842: hr_utility.raise_error;
1843:
1844: END create_grades_rv_keyflex;
1845:
1846: /* --------------------------------------------------------------------------

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

1900: l_kf_cmp_seg_count number(8) :=0;
1901: l_kf_cost_seg_count number(8) :=0;
1902: BEGIN
1903:
1904: hr_utility.set_location('Entering:'|| l_proc, 10);
1905:
1906: --
1907: -- create people group key flex
1908: --

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

1922: p_kf_grp_tab(l_kf_grp_count).structure_title := l_grp_structures_code;
1923: p_kf_grp_tab(l_kf_grp_count).description := l_grp_structures_code;
1924: end if;
1925:
1926: hr_utility.trace('Created People Group Key Flex: ' || l_grp_structures_code );
1927:
1928: --
1929: -- create people group flex segments
1930: --

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

1987: := l_kf_grp_valueset_tab(l_value_set_tab_count).max_value;
1988: l_kf_grp_seg_count := l_kf_grp_seg_count + 1 ;
1989: end if;
1990:
1991: hr_utility.trace('Created People Group Key Flex Segment: ' || l_grp_structures_code);
1992:
1993: --
1994: -- freeze and compile this flexfield
1995: --

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

2021: p_kf_cmp_tab(l_kf_cmp_count).structure_title := l_cmp_structures_code;
2022: p_kf_cmp_tab(l_kf_cmp_count).description := l_cmp_structures_code;
2023: end if;
2024:
2025: hr_utility.trace('Created Competence Group Key Flex: ' || l_cmp_structures_code);
2026:
2027: --
2028: -- create competence flex segments
2029: --

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

2084: := l_kf_cmp_valueset_tab(l_value_set_tab_count).max_value;
2085: l_kf_cmp_seg_count := l_kf_cmp_seg_count + 1 ;
2086: end if;
2087:
2088: hr_utility.trace('Created Competence Key Flex Segment: l_cmp_structures_code' );
2089:
2090: --
2091: -- freeze and compile this flexfield
2092: --

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

2116: p_kf_cost_tab(l_kf_cost_count).structure_title := l_cost_structures_code;
2117: p_kf_cost_tab(l_kf_cost_count).description := l_cost_structures_code;
2118: end if;
2119:
2120: hr_utility.trace('Created Cost Allocation Key Flex: ' || l_cost_structures_code);
2121:
2122: --
2123: -- create cost allocation flex segments
2124: --

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

2177: := l_kf_cost_valueset_tab(l_value_set_tab_count).min_value;
2178: p_kf_cost_seg_tab(l_kf_cost_seg_count).vs_max_value
2179: := l_kf_cmp_valueset_tab(l_value_set_tab_count).max_value;
2180: l_kf_cost_seg_count := l_kf_cost_seg_count + 1 ;
2181: hr_utility.trace('ENABLELONGLIST := ' || l_kf_cost_valueset_tab(l_value_set_tab_count).enable_longlist);
2182: end if;
2183:
2184: if NOT (p_technical_summary_mode) then
2185: per_ri_config_utilities.create_flex_segments

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

2309: end if;
2310: EXCEPTION
2311: when others then
2312: l_error_message := 'Error in ' || l_proc;
2313: hr_utility.trace(l_error_message || '-' || sqlerrm);
2314: hr_utility.set_location(' Leaving:'|| l_proc, 500);
2315: hr_utility.raise_error;
2316:
2317: END create_global_grp_cmp_cost_kf;

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

2310: EXCEPTION
2311: when others then
2312: l_error_message := 'Error in ' || l_proc;
2313: hr_utility.trace(l_error_message || '-' || sqlerrm);
2314: hr_utility.set_location(' Leaving:'|| l_proc, 500);
2315: hr_utility.raise_error;
2316:
2317: END create_global_grp_cmp_cost_kf;
2318:

Line 2315: hr_utility.raise_error;

2311: when others then
2312: l_error_message := 'Error in ' || l_proc;
2313: hr_utility.trace(l_error_message || '-' || sqlerrm);
2314: hr_utility.set_location(' Leaving:'|| l_proc, 500);
2315: hr_utility.raise_error;
2316:
2317: END create_global_grp_cmp_cost_kf;
2318:
2319: /* --------------------------------------------------------------------------

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

2363: l_log_message varchar2(360);
2364: l_error_message varchar2(360);
2365:
2366: BEGIN
2367: hr_utility.set_location('Entering:'|| l_proc, 10);
2368:
2369: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
2370:
2371: -- Create Global Jobs Key flex

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

2368:
2369: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
2370:
2371: -- Create Global Jobs Key flex
2372: hr_utility.set_location(l_proc, 20);
2373: l_job_structures_code := per_ri_config_utilities.return_config_entity_name
2374: (per_ri_config_main.g_global_job_structure_name);
2375:
2376:

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

2398: l_log_message := 'Created KEYFLEX PER JOB ' || l_job_structures_code;
2399: per_ri_config_utilities.write_log(p_message => l_log_message);
2400:
2401: -- Create Position Key flex
2402: hr_utility.set_location(l_proc, 30);
2403: l_pos_structures_code := per_ri_config_utilities.return_config_entity_name
2404: (per_ri_config_main.g_global_pos_structure_name);
2405: if NOT (p_technical_summary_mode) then
2406: l_position_fk_number := per_ri_config_utilities.create_key_flexfield

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

2421:
2422: l_log_message := 'Created KEYFLEX PER POS ' || l_pos_structures_code;
2423: per_ri_config_utilities.write_log(p_message => l_log_message);
2424:
2425: hr_utility.set_location(l_proc, 40);
2426:
2427: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
2428: hr_utility.set_location(l_proc, 50);
2429:

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

2424:
2425: hr_utility.set_location(l_proc, 40);
2426:
2427: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
2428: hr_utility.set_location(l_proc, 50);
2429:
2430: -- Create Jobs Key Flex Segments
2431:
2432: if NOT (p_technical_summary_mode) then

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

2551:
2552: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || l_pos_structures_code;
2553: per_ri_config_utilities.write_log(p_message => l_log_message);
2554:
2555: hr_utility.set_location(l_proc, 60);
2556: else
2557: hr_utility.set_location(l_proc, 70);
2558: hr_utility.trace('Positions : Industry is US_GOVERNMENT');
2559:

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

2553: per_ri_config_utilities.write_log(p_message => l_log_message);
2554:
2555: hr_utility.set_location(l_proc, 60);
2556: else
2557: hr_utility.set_location(l_proc, 70);
2558: hr_utility.trace('Positions : Industry is US_GOVERNMENT');
2559:
2560: -- create only federal job segments with specified value segment name valuesets.
2561: -- First Segment 'Name' valueset '60 Characters'

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

2554:
2555: hr_utility.set_location(l_proc, 60);
2556: else
2557: hr_utility.set_location(l_proc, 70);
2558: hr_utility.trace('Positions : Industry is US_GOVERNMENT');
2559:
2560: -- create only federal job segments with specified value segment name valuesets.
2561: -- First Segment 'Name' valueset '60 Characters'
2562: if NOT (p_technical_summary_mode) then

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

2875: end if;
2876:
2877: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Agency Code';
2878: per_ri_config_utilities.write_log(p_message => l_log_message);
2879: hr_utility.set_location(l_proc, 90);
2880: end if;
2881:
2882: --
2883: -- freeze and compile this flexfield

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

2898: ,p_flex_code => 'POS'
2899: ,p_structure_code => l_pos_structures_code);
2900: end if;
2901:
2902: hr_utility.set_location(' Leaving:'|| l_proc, 100);
2903:
2904: EXCEPTION
2905: when others then
2906: l_error_message := 'Error in ' || l_proc;

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

2903:
2904: EXCEPTION
2905: when others then
2906: l_error_message := 'Error in ' || l_proc;
2907: hr_utility.trace(l_error_message || '-' || sqlerrm);
2908: hr_utility.set_location(' Leaving:'|| l_proc, 500);
2909: hr_utility.raise_error;
2910:
2911: END create_global_job_pos_kf;

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

2904: EXCEPTION
2905: when others then
2906: l_error_message := 'Error in ' || l_proc;
2907: hr_utility.trace(l_error_message || '-' || sqlerrm);
2908: hr_utility.set_location(' Leaving:'|| l_proc, 500);
2909: hr_utility.raise_error;
2910:
2911: END create_global_job_pos_kf;
2912:

Line 2909: hr_utility.raise_error;

2905: when others then
2906: l_error_message := 'Error in ' || l_proc;
2907: hr_utility.trace(l_error_message || '-' || sqlerrm);
2908: hr_utility.set_location(' Leaving:'|| l_proc, 500);
2909: hr_utility.raise_error;
2910:
2911: END create_global_job_pos_kf;
2912:
2913: /* --------------------------------------------------------------------------

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

2945: l_value_set_tab_count number(9) := 1;
2946:
2947:
2948: BEGIN
2949: hr_utility.set_location('Entering:'|| l_proc, 10);
2950:
2951: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
2952:
2953: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry

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

2953: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
2954: (p_configuration_code => p_configuration_code);
2955:
2956: -- Create Position Key flex
2957: hr_utility.set_location(l_proc, 20);
2958:
2959: l_pos_structures_code := per_ri_config_utilities.return_config_entity_name
2960: (per_ri_config_main.g_global_pos_structure_name);
2961: if NOT (p_technical_summary_mode) then

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

2976:
2977: l_log_message := 'Created KEYFLEX PER POS ' || l_pos_structures_code;
2978: per_ri_config_utilities.write_log(p_message => l_log_message);
2979:
2980: hr_utility.set_location(l_proc, 30);
2981:
2982: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
2983: hr_utility.set_location(l_proc, 50);
2984:

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

2979:
2980: hr_utility.set_location(l_proc, 30);
2981:
2982: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
2983: hr_utility.set_location(l_proc, 50);
2984:
2985: -- Create Position Key Flex Segments
2986: if NOT (p_technical_summary_mode) then
2987: per_ri_config_utilities.create_flex_segments

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

3043:
3044: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || l_pos_structures_code;
3045: per_ri_config_utilities.write_log(p_message => l_log_message);
3046:
3047: hr_utility.set_location(l_proc, 60);
3048: else
3049: hr_utility.set_location(l_proc, 70);
3050: hr_utility.trace('Positions : Industry is US_GOVERNMENT');
3051:

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

3045: per_ri_config_utilities.write_log(p_message => l_log_message);
3046:
3047: hr_utility.set_location(l_proc, 60);
3048: else
3049: hr_utility.set_location(l_proc, 70);
3050: hr_utility.trace('Positions : Industry is US_GOVERNMENT');
3051:
3052: -- create only federal position segments with specified value segment name valuesets.
3053: -- First Segment

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

3046:
3047: hr_utility.set_location(l_proc, 60);
3048: else
3049: hr_utility.set_location(l_proc, 70);
3050: hr_utility.trace('Positions : Industry is US_GOVERNMENT');
3051:
3052: -- create only federal position segments with specified value segment name valuesets.
3053: -- First Segment
3054: if NOT (p_technical_summary_mode) then

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

3303: end if;
3304:
3305: l_log_message := 'Created KEYFLEX SEGMENT : PER POS ' || 'Agency Code';
3306: per_ri_config_utilities.write_log(p_message => l_log_message);
3307: hr_utility.set_location(l_proc, 90);
3308: end if;
3309:
3310: --
3311: -- freeze and compile this flexfield

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

3314: (p_appl_short_Name => 'PER'
3315: ,p_flex_code => 'POS'
3316: ,p_structure_code => l_pos_structures_code);
3317:
3318: hr_utility.set_location(' Leaving:'|| l_proc, 100);
3319:
3320: EXCEPTION
3321: when others then
3322: l_error_message := 'Error in ' || l_proc;

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

3319:
3320: EXCEPTION
3321: when others then
3322: l_error_message := 'Error in ' || l_proc;
3323: hr_utility.trace(l_error_message || '-' || sqlerrm);
3324: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3325: hr_utility.raise_error;
3326:
3327: END create_global_pos_kf;

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

3320: EXCEPTION
3321: when others then
3322: l_error_message := 'Error in ' || l_proc;
3323: hr_utility.trace(l_error_message || '-' || sqlerrm);
3324: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3325: hr_utility.raise_error;
3326:
3327: END create_global_pos_kf;
3328:

Line 3325: hr_utility.raise_error;

3321: when others then
3322: l_error_message := 'Error in ' || l_proc;
3323: hr_utility.trace(l_error_message || '-' || sqlerrm);
3324: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3325: hr_utility.raise_error;
3326:
3327: END create_global_pos_kf;
3328:
3329: /* --------------------------------------------------------------------------

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

3359: l_grd_structures_code fnd_id_flex_structures.id_flex_structure_code%type;
3360: l_enterprise_primary_industry per_ri_config_information.config_information1%type;
3361:
3362: BEGIN
3363: hr_utility.set_location('Entering:'|| l_proc, 10);
3364:
3365: l_enterprise_primary_industry := per_ri_config_utilities.get_ent_primary_industry
3366: (p_configuration_code => p_configuration_code);
3367:

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

3367:
3368: l_enterprise_short_name := per_ri_config_utilities.get_enterprise_short_name(p_configuration_code);
3369:
3370: if l_enterprise_primary_industry <> 'US_GOVERNMENT' then
3371: hr_utility.set_location(l_proc, 20);
3372: -- Create Grade Key Flex
3373: l_grd_structures_code := per_ri_config_utilities.return_config_entity_name
3374: (per_ri_config_main.g_global_grd_structure_name);
3375: if NOT (p_technical_summary_mode) then

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

3532:
3533: EXCEPTION
3534: when others then
3535: l_error_message := 'Error in ' || l_proc;
3536: hr_utility.trace(l_error_message || '-' || sqlerrm);
3537: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3538: hr_utility.raise_error;
3539:
3540: END create_global_grd_kf;

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

3533: EXCEPTION
3534: when others then
3535: l_error_message := 'Error in ' || l_proc;
3536: hr_utility.trace(l_error_message || '-' || sqlerrm);
3537: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3538: hr_utility.raise_error;
3539:
3540: END create_global_grd_kf;
3541:

Line 3538: hr_utility.raise_error;

3534: when others then
3535: l_error_message := 'Error in ' || l_proc;
3536: hr_utility.trace(l_error_message || '-' || sqlerrm);
3537: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3538: hr_utility.raise_error;
3539:
3540: END create_global_grd_kf;
3541:
3542: /* --------------------------------------------------------------------------

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

3565: l_value_set_exists boolean;
3566:
3567: BEGIN
3568:
3569: hr_utility.set_location('Entering:'|| l_proc, 10);
3570:
3571: fnd_flex_val_api.set_session_mode('customer_data');
3572:
3573: -- Create PER_RI_DEFAULT_GRADES

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

3572:
3573: -- Create PER_RI_DEFAULT_GRADES
3574: l_value_set_exists := fnd_flex_val_api.valueset_exists(value_set => 'PER_RI_CONFIG_DEFAULT_GRADES');
3575: if not (l_value_set_exists) then
3576: hr_utility.set_location(l_proc, 20);
3577: l_description := 'The default Grades Value Set is generated by Enterprise Structures Configuration '
3578: || 'and used in Grade flexfield validation. This will initially be empty and can '
3579: || 'be populated using the load reference data';
3580: fnd_flex_val_api.create_valueset_independent

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

3592: ,max_value => l_max_value);
3593: l_log_message := 'Created DEFAULT VALUESET ' || 'PER_RI_CONFIG_DEFAULT_GRADES';
3594: per_ri_config_utilities.write_log(p_message => l_log_message);
3595: end if;
3596: hr_utility.set_location(l_proc, 30);
3597: -- Create PER_RI_DEFAULT_GRADES
3598: l_value_set_exists := fnd_flex_val_api.valueset_exists(value_set => 'PER_RI_CONFIG_DEFAULT_LEVELS');
3599: if not (l_value_set_exists) then
3600: hr_utility.set_location(l_proc, 40);

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

3596: hr_utility.set_location(l_proc, 30);
3597: -- Create PER_RI_DEFAULT_GRADES
3598: l_value_set_exists := fnd_flex_val_api.valueset_exists(value_set => 'PER_RI_CONFIG_DEFAULT_LEVELS');
3599: if not (l_value_set_exists) then
3600: hr_utility.set_location(l_proc, 40);
3601: l_description := 'The default Grades Level Value Set is generated by Enterprise Structures Configuration '
3602: || 'and used in Grade flexfield validation. This will initially be empty and can '
3603: || 'be populated using the load reference data';
3604: fnd_flex_val_api.create_valueset_independent

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

3615: ,min_value => l_min_value
3616: ,max_value => l_max_value);
3617: l_log_message := 'Created DEFAULT VALUESET ' || 'PER_RI_CONFIG_DEFAULT_LEVELS';
3618: end if;
3619: hr_utility.set_location(l_proc, 50);
3620:
3621: -- Create PER_RI_DEFAULT_GRADES
3622: l_description := 'The default Account Number Value Set is generated by Enterprise Structures Configuration '
3623: || 'and used in Grade flexfield validation. This will initially be empty and can '

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

3623: || 'and used in Grade flexfield validation. This will initially be empty and can '
3624: || 'be populated using the load reference data';
3625: l_value_set_exists := fnd_flex_val_api.valueset_exists(value_set => 'PER_RI_CONFIG_DEFAULT_ACCOUNT');
3626: if not (l_value_set_exists) then
3627: hr_utility.set_location(l_proc, 60);
3628: fnd_flex_val_api.create_valueset_independent
3629: (value_set_name => 'PER_RI_CONFIG_DEFAULT_ACCOUNT'
3630: ,description => l_description
3631: ,security_available => l_security_available

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

3639: ,min_value => l_min_value
3640: ,max_value => l_max_value);
3641: l_log_message := 'Created DEFAULT VALUESET ' || 'PER_RI_CONFIG_DEFAULT_ACCOUNT';
3642: end if;
3643: hr_utility.set_location(l_proc, 70);
3644: -- Create PER_RI_DEFAULT_GRADES
3645: l_description := 'The default Company Value Set is generated by Enterprise Structures Configuration '
3646: || 'and used in Grade flexfield validation. This will initially be empty and can '
3647: || 'be populated using the load reference data';

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

3646: || 'and used in Grade flexfield validation. This will initially be empty and can '
3647: || 'be populated using the load reference data';
3648: l_value_set_exists := fnd_flex_val_api.valueset_exists(value_set => 'PER_RI_CONFIG_DEFAULT_COMPANY');
3649: if not (l_value_set_exists) then
3650: hr_utility.set_location(l_proc, 80);
3651: fnd_flex_val_api.create_valueset_independent
3652: (value_set_name => 'PER_RI_CONFIG_DEFAULT_COMPANY'
3653: ,description => l_description
3654: ,security_available => l_security_available

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

3662: ,min_value => l_min_value
3663: ,max_value => l_max_value);
3664: l_log_message := 'Created DEFAULT VALUESET ' || 'PER_RI_CONFIG_DEFAULT_COMPANY';
3665: end if;
3666: hr_utility.set_location(l_proc, 90);
3667: -- Create PER_RI_DEFAULT_GRADES
3668: l_description := 'The default Cost Center Value Set is generated by Enterprise Structures Configuration '
3669: || 'and used in Grade flexfield validation. This will initially be empty and can '
3670: || 'be populated using the load reference data';

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

3669: || 'and used in Grade flexfield validation. This will initially be empty and can '
3670: || 'be populated using the load reference data';
3671: l_value_set_exists := fnd_flex_val_api.valueset_exists(value_set => 'PER_RI_CONFIG_DEFAULT_CC');
3672: if not (l_value_set_exists) then
3673: hr_utility.set_location(l_proc, 100);
3674: fnd_flex_val_api.create_valueset_independent
3675: (value_set_name => 'PER_RI_CONFIG_DEFAULT_CC'
3676: ,description => l_description
3677: ,security_available => l_security_available

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

3686: ,max_value => l_max_value);
3687: l_log_message := 'Created DEFAULT VALUESET ' || 'PER_RI_CONFIG_DEFAULT_CC';
3688: end if;
3689:
3690: hr_utility.set_location(' Leaving:'|| l_proc, 120);
3691:
3692: EXCEPTION
3693: when others then
3694: l_error_message := 'Error in ' || l_proc;

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

3691:
3692: EXCEPTION
3693: when others then
3694: l_error_message := 'Error in ' || l_proc;
3695: hr_utility.trace(l_error_message || '-' || sqlerrm);
3696: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3697: hr_utility.raise_error;
3698:
3699:

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

3692: EXCEPTION
3693: when others then
3694: l_error_message := 'Error in ' || l_proc;
3695: hr_utility.trace(l_error_message || '-' || sqlerrm);
3696: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3697: hr_utility.raise_error;
3698:
3699:
3700: END create_default_value_sets;

Line 3697: hr_utility.raise_error;

3693: when others then
3694: l_error_message := 'Error in ' || l_proc;
3695: hr_utility.trace(l_error_message || '-' || sqlerrm);
3696: hr_utility.set_location(' Leaving:'|| l_proc, 500);
3697: hr_utility.raise_error;
3698:
3699:
3700: END create_default_value_sets;
3701:

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

3802: l_profile_resp_main_tab per_ri_config_tech_summary.profile_resp_tab;
3803:
3804: BEGIN
3805:
3806: hr_utility.set_location('Entering:'|| l_proc, 10);
3807:
3808: l_configuration_user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
3809: (per_ri_config_main.g_configuration_user_name));
3810: open csr_get_product(p_configuration_code);

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

3811:
3812: loop
3813: fetch csr_get_product into l_product_name;
3814: exit when csr_get_product%NOTFOUND;
3815: hr_utility.trace('l_product_name = ' || l_product_name);
3816:
3817: if l_product_name = 'PER' then
3818: l_hr := TRUE;
3819: end if;

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

3829: end loop;
3830:
3831: close csr_get_product;
3832:
3833: hr_utility.set_location(l_proc, 30);
3834:
3835: --
3836: -- assign hrms self service responsibilities
3837: --

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

3847: x_owner => 'SEED',
3848: x_start_date => l_start_date,
3849: x_end_date => l_end_date,
3850: x_description => per_ri_config_main.g_description_string);
3851: hr_utility.trace('Assigned Responsibility: ' || 'EMPLOYEE_DIRECT_ACCESS');
3852: hr_utility.set_location(l_proc, 40);
3853: else
3854: p_hrms_resp_tab(l_hrms_resp_count).user_name := l_configuration_user_name;
3855: p_hrms_resp_tab(l_hrms_resp_count).resp_key := 'EMPLOYEE_DIRECT_ACCESS_V4';

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

3848: x_start_date => l_start_date,
3849: x_end_date => l_end_date,
3850: x_description => per_ri_config_main.g_description_string);
3851: hr_utility.trace('Assigned Responsibility: ' || 'EMPLOYEE_DIRECT_ACCESS');
3852: hr_utility.set_location(l_proc, 40);
3853: else
3854: p_hrms_resp_tab(l_hrms_resp_count).user_name := l_configuration_user_name;
3855: p_hrms_resp_tab(l_hrms_resp_count).resp_key := 'EMPLOYEE_DIRECT_ACCESS_V4';
3856: p_hrms_resp_tab(l_hrms_resp_count).app_short_name := 'PER';

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

3884: p_hrms_resp_tab(l_hrms_resp_count).description := per_ri_config_main.g_description_string;
3885:
3886: l_hrms_resp_count := l_hrms_resp_count + 1 ;
3887: end if;
3888: hr_utility.trace('Assigned Responsibility: ' || 'LINE_MANAGER_DIRECT_ACCESS');
3889: hr_utility.set_location(l_proc, 50);
3890: end if;
3891:
3892: --decide on the responsibility to be assigned.

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

3885:
3886: l_hrms_resp_count := l_hrms_resp_count + 1 ;
3887: end if;
3888: hr_utility.trace('Assigned Responsibility: ' || 'LINE_MANAGER_DIRECT_ACCESS');
3889: hr_utility.set_location(l_proc, 50);
3890: end if;
3891:
3892: --decide on the responsibility to be assigned.
3893:

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

3890: end if;
3891:
3892: --decide on the responsibility to be assigned.
3893:
3894: hr_utility.set_location(l_proc, 60);
3895: l_assign_responsibility := 'PER';
3896:
3897: if l_hr and not l_hrms and not l_benefits then
3898: l_assign_responsibility := 'PER';

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

3913: := per_ri_config_utilities.determine_country_resp
3914: (p_country_code => l_country_code
3915: ,p_assign_responsibility => l_assign_responsibility);
3916:
3917: hr_utility.trace('l_assign_responsibility = ' || l_assign_responsibility);
3918: hr_utility.trace('l_assign_determined_resp = ' || l_assign_determined_resp);
3919: --open csr_get_responsibility(l_country_code
3920: -- ,l_assign_responsibility);
3921:

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

3914: (p_country_code => l_country_code
3915: ,p_assign_responsibility => l_assign_responsibility);
3916:
3917: hr_utility.trace('l_assign_responsibility = ' || l_assign_responsibility);
3918: hr_utility.trace('l_assign_determined_resp = ' || l_assign_determined_resp);
3919: --open csr_get_responsibility(l_country_code
3920: -- ,l_assign_responsibility);
3921:
3922: open csr_get_responsibility(l_country_code

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

3926: ,l_fnd_application_short_name;
3927:
3928: exit when csr_get_responsibility%NOTFOUND;
3929:
3930: hr_utility.trace('l_country_code : ' || l_country_code);
3931: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);
3932: hr_utility.trace('l_fnd_application_short_name : ' || l_fnd_application_short_name);
3933:
3934: -- Security Group Removal Changes

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

3927:
3928: exit when csr_get_responsibility%NOTFOUND;
3929:
3930: hr_utility.trace('l_country_code : ' || l_country_code);
3931: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);
3932: hr_utility.trace('l_fnd_application_short_name : ' || l_fnd_application_short_name);
3933:
3934: -- Security Group Removal Changes
3935: -- This is taken care by security_profile_assignment creation

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

3928: exit when csr_get_responsibility%NOTFOUND;
3929:
3930: hr_utility.trace('l_country_code : ' || l_country_code);
3931: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);
3932: hr_utility.trace('l_fnd_application_short_name : ' || l_fnd_application_short_name);
3933:
3934: -- Security Group Removal Changes
3935: -- This is taken care by security_profile_assignment creation
3936: --assign responsibility

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

3942: x_owner => 'SEED',
3943: x_start_date => l_start_date,
3944: x_end_date => l_end_date,
3945: x_description => per_ri_config_main.g_description_string);
3946: hr_utility.trace('Assigned Responsibility:' || l_responsibility_key || ':' || l_fnd_application_short_name);
3947: */
3948: -- get business group name for given country code
3949: l_business_group_name_main := per_ri_config_utilities.get_enterprise_short_name
3950: (p_configuration_code => p_configuration_code)

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

3985: l_hrms_resp_count := l_hrms_resp_count + 1;
3986: end if;
3987:
3988:
3989: hr_utility.trace('l_business_group_name_main : ' || l_business_group_name_main);
3990: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);
3991:
3992: hr_utility.trace('l_row_count inside = ' || to_char(l_row_count));
3993:

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

3986: end if;
3987:
3988:
3989: hr_utility.trace('l_business_group_name_main : ' || l_business_group_name_main);
3990: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);
3991:
3992: hr_utility.trace('l_row_count inside = ' || to_char(l_row_count));
3993:
3994: end loop;

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

3988:
3989: hr_utility.trace('l_business_group_name_main : ' || l_business_group_name_main);
3990: hr_utility.trace('l_responsibility_key : ' || l_responsibility_key);
3991:
3992: hr_utility.trace('l_row_count inside = ' || to_char(l_row_count));
3993:
3994: end loop;
3995: l_row_count := l_row_count + (csr_get_responsibility%ROWCOUNT);
3996: hr_utility.trace('l_row_count outside = ' || to_char(l_row_count));

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

3992: hr_utility.trace('l_row_count inside = ' || to_char(l_row_count));
3993:
3994: end loop;
3995: l_row_count := l_row_count + (csr_get_responsibility%ROWCOUNT);
3996: hr_utility.trace('l_row_count outside = ' || to_char(l_row_count));
3997: close csr_get_responsibility;
3998: end loop;
3999: close csr_get_country;
4000:

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

3998: end loop;
3999: close csr_get_country;
4000:
4001: --process gobal responsibility
4002: hr_utility.set_location('Entering:'|| l_proc, 210);
4003: l_assign_glb_resp_key_app_name := 'PER';
4004:
4005: if l_hr and not l_hrms and not l_benefits then
4006: l_assign_global_resp_key := 'GLOBAL HR MANAGER';

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

4021: l_assign_global_resp_key := 'US_BEN_MANAGER';
4022: l_assign_glb_resp_key_app_name := 'BEN';
4023: end if;
4024:
4025: hr_utility.set_location('Entering:'|| l_proc, 220);
4026: hr_utility.trace('l_assign_glb_resp_key_app_name : ' || l_assign_glb_resp_key_app_name);
4027: hr_utility.trace('l_assign_global_resp_key : ' || l_assign_global_resp_key);
4028:
4029: l_earlier_row_count := p_security_profile_tab.count + 1;

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

4022: l_assign_glb_resp_key_app_name := 'BEN';
4023: end if;
4024:
4025: hr_utility.set_location('Entering:'|| l_proc, 220);
4026: hr_utility.trace('l_assign_glb_resp_key_app_name : ' || l_assign_glb_resp_key_app_name);
4027: hr_utility.trace('l_assign_global_resp_key : ' || l_assign_global_resp_key);
4028:
4029: l_earlier_row_count := p_security_profile_tab.count + 1;
4030: hr_utility.trace('GLOBAL l_earlier_row_count : ' || l_earlier_row_count);

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

4023: end if;
4024:
4025: hr_utility.set_location('Entering:'|| l_proc, 220);
4026: hr_utility.trace('l_assign_glb_resp_key_app_name : ' || l_assign_glb_resp_key_app_name);
4027: hr_utility.trace('l_assign_global_resp_key : ' || l_assign_global_resp_key);
4028:
4029: l_earlier_row_count := p_security_profile_tab.count + 1;
4030: hr_utility.trace('GLOBAL l_earlier_row_count : ' || l_earlier_row_count);
4031:

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

4026: hr_utility.trace('l_assign_glb_resp_key_app_name : ' || l_assign_glb_resp_key_app_name);
4027: hr_utility.trace('l_assign_global_resp_key : ' || l_assign_global_resp_key);
4028:
4029: l_earlier_row_count := p_security_profile_tab.count + 1;
4030: hr_utility.trace('GLOBAL l_earlier_row_count : ' || l_earlier_row_count);
4031:
4032: open csr_global_responsibility(p_configuration_code);
4033: loop
4034: fetch csr_global_responsibility into l_country_code_global;

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

4033: loop
4034: fetch csr_global_responsibility into l_country_code_global;
4035: exit when csr_global_responsibility%NOTFOUND;
4036:
4037: hr_utility.trace('Assigned Global Responsibility:' || l_assign_global_resp_key );
4038:
4039: -- get business group name for given country code
4040: -- business group name and security profile names are same
4041: l_business_group_name_global := per_ri_config_utilities.get_enterprise_short_name

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

4095: l_business_group_name_global := per_ri_config_utilities.get_enterprise_short_name
4096: (p_configuration_code => p_configuration_code)
4097: || ' ' || l_country_code_global || per_ri_config_main.g_bg_name_suffix_string;
4098:
4099: hr_utility.trace('Security Group Removal Changes');
4100: per_ri_config_fnd_hr_entity.create_bg_id_and_sg_id_profile
4101: (p_configuration_code => p_configuration_code
4102: ,p_responsibility_key => l_assign_global_resp_key
4103: ,p_responsibility_name => l_assign_global_resp_name

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

4108:
4109: EXCEPTION
4110: when others then
4111: l_error_message := 'Error in ' || l_proc;
4112: hr_utility.trace(l_error_message || '-' || sqlerrm);
4113: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4114: hr_utility.raise_error;
4115:
4116: END create_hrms_responsibility;

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

4109: EXCEPTION
4110: when others then
4111: l_error_message := 'Error in ' || l_proc;
4112: hr_utility.trace(l_error_message || '-' || sqlerrm);
4113: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4114: hr_utility.raise_error;
4115:
4116: END create_hrms_responsibility;
4117:

Line 4114: hr_utility.raise_error;

4110: when others then
4111: l_error_message := 'Error in ' || l_proc;
4112: hr_utility.trace(l_error_message || '-' || sqlerrm);
4113: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4114: hr_utility.raise_error;
4115:
4116: END create_hrms_responsibility;
4117:
4118: /* --------------------------------------------------------------------------

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

4139: l_log_message varchar2(360);
4140: l_error_message varchar2(360);
4141:
4142: BEGIN
4143: hr_utility.set_location('Entering:'|| l_proc, 10);
4144:
4145: open csr_get_product(p_configuration_code);
4146:
4147: loop

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

4152: /* DGARG MSG Changes
4153: -- For each product selected set application level profile option
4154: -- ENABLE_SECURITY_GROUPS
4155: if l_product_name in ('PER','PAY','BEN') then
4156: hr_utility.trace('l_product_name ' || l_product_name);
4157: if NOT (p_technical_summary_mode) then
4158: per_ri_config_utilities.set_profile_option_value
4159: (p_level => 10002
4160: ,p_level_value => l_product_name

Line 4205: hr_utility.trace(l_log_message);

4201: l_log_message := 'The profile setting has errored out for application '
4202: || rec.application_id;
4203: end if;
4204: per_ri_config_utilities.write_log(p_message => l_log_message);
4205: hr_utility.trace(l_log_message);
4206: end loop;
4207: --
4208: */
4209:

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

4209:
4210: EXCEPTION
4211: when others then
4212: l_error_message := 'Error in ' || l_proc;
4213: hr_utility.trace(l_error_message || '-' || sqlerrm);
4214: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4215: hr_utility.raise_error;
4216:
4217: END create_application_level_resp;

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

4210: EXCEPTION
4211: when others then
4212: l_error_message := 'Error in ' || l_proc;
4213: hr_utility.trace(l_error_message || '-' || sqlerrm);
4214: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4215: hr_utility.raise_error;
4216:
4217: END create_application_level_resp;
4218: /* --------------------------------------------------------------------------

Line 4215: hr_utility.raise_error;

4211: when others then
4212: l_error_message := 'Error in ' || l_proc;
4213: hr_utility.trace(l_error_message || '-' || sqlerrm);
4214: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4215: hr_utility.raise_error;
4216:
4217: END create_application_level_resp;
4218: /* --------------------------------------------------------------------------
4219: -- Name : create_resp_level_profile

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

4252: l_proc varchar2(72) := g_package || 'create_resp_level_profile';
4253: l_error_message varchar2(360);
4254:
4255: BEGIN
4256: hr_utility.set_location('Entering:'|| l_proc, 10);
4257:
4258: -- only one row is there
4259: open csr_get_resp_key_app(p_responsibility_key);
4260: fetch csr_get_resp_key_app into l_application_short_name;

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

4278: else
4279: l_hr_user_type := 'PER';
4280: end if;
4281:
4282: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4283: hr_utility.trace('l_hr_user_type ' || l_hr_user_type);
4284: if NOT (p_technical_summary_mode) then
4285: per_ri_config_utilities.set_profile_option_value
4286: (p_level => 10003

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

4279: l_hr_user_type := 'PER';
4280: end if;
4281:
4282: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4283: hr_utility.trace('l_hr_user_type ' || l_hr_user_type);
4284: if NOT (p_technical_summary_mode) then
4285: per_ri_config_utilities.set_profile_option_value
4286: (p_level => 10003
4287: ,p_level_value => p_responsibility_key

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

4299:
4300: end if;
4301:
4302:
4303: hr_utility.trace('Created HR_USER_TYPE for '|| l_product_name);
4304: hr_utility.set_location('Leaving:'|| l_proc, 40);
4305:
4306: EXCEPTION
4307: when others then

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

4300: end if;
4301:
4302:
4303: hr_utility.trace('Created HR_USER_TYPE for '|| l_product_name);
4304: hr_utility.set_location('Leaving:'|| l_proc, 40);
4305:
4306: EXCEPTION
4307: when others then
4308: l_error_message := 'Error in ' || l_proc;

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

4305:
4306: EXCEPTION
4307: when others then
4308: l_error_message := 'Error in ' || l_proc;
4309: hr_utility.trace(l_error_message || '-' || sqlerrm);
4310: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4311: hr_utility.raise_error;
4312:
4313: END create_resp_level_profile;

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

4306: EXCEPTION
4307: when others then
4308: l_error_message := 'Error in ' || l_proc;
4309: hr_utility.trace(l_error_message || '-' || sqlerrm);
4310: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4311: hr_utility.raise_error;
4312:
4313: END create_resp_level_profile;
4314:

Line 4311: hr_utility.raise_error;

4307: when others then
4308: l_error_message := 'Error in ' || l_proc;
4309: hr_utility.trace(l_error_message || '-' || sqlerrm);
4310: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4311: hr_utility.raise_error;
4312:
4313: END create_resp_level_profile;
4314:
4315: /* --------------------------------------------------------------------------

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

4369: l_error_message varchar2(360);
4370: l_log_message varchar2(360);
4371:
4372: BEGIN
4373: hr_utility.set_location('Entering:'|| l_proc, 10);
4374:
4375: if NOT (p_technical_summary_mode) then
4376: -- only one row is there
4377: open csr_get_resp_key_app(p_responsibility_key);

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

4386: open csr_sg_id(p_business_group_name);
4387: fetch csr_sg_id into l_sg_id;
4388: close csr_sg_id;
4389:
4390: hr_utility.trace('l_responsibility_id ' || l_responsibility_id);
4391: hr_utility.trace('l_bg_id ' || l_bg_id);
4392: hr_utility.trace('l_sg_id ' || l_sg_id);
4393: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4394: hr_utility.trace('p_business_group_name ' || p_business_group_name);

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

4387: fetch csr_sg_id into l_sg_id;
4388: close csr_sg_id;
4389:
4390: hr_utility.trace('l_responsibility_id ' || l_responsibility_id);
4391: hr_utility.trace('l_bg_id ' || l_bg_id);
4392: hr_utility.trace('l_sg_id ' || l_sg_id);
4393: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4394: hr_utility.trace('p_business_group_name ' || p_business_group_name);
4395:

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

4388: close csr_sg_id;
4389:
4390: hr_utility.trace('l_responsibility_id ' || l_responsibility_id);
4391: hr_utility.trace('l_bg_id ' || l_bg_id);
4392: hr_utility.trace('l_sg_id ' || l_sg_id);
4393: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4394: hr_utility.trace('p_business_group_name ' || p_business_group_name);
4395:
4396: --

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

4389:
4390: hr_utility.trace('l_responsibility_id ' || l_responsibility_id);
4391: hr_utility.trace('l_bg_id ' || l_bg_id);
4392: hr_utility.trace('l_sg_id ' || l_sg_id);
4393: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4394: hr_utility.trace('p_business_group_name ' || p_business_group_name);
4395:
4396: --
4397: -- Create PER_BUSINESS_GROUP_ID

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

4390: hr_utility.trace('l_responsibility_id ' || l_responsibility_id);
4391: hr_utility.trace('l_bg_id ' || l_bg_id);
4392: hr_utility.trace('l_sg_id ' || l_sg_id);
4393: hr_utility.trace('p_responsibility_key ' || p_responsibility_key);
4394: hr_utility.trace('p_business_group_name ' || p_business_group_name);
4395:
4396: --
4397: -- Create PER_BUSINESS_GROUP_ID
4398: --

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

4404: null;
4405: end if;
4406: l_log_message := 'Created Profile Option Value PER_BUSINESS_GROUP_ID ' || l_bg_id;
4407: per_ri_config_utilities.write_log(p_message => l_log_message);
4408: hr_utility.set_location(l_proc, 20);
4409:
4410: --
4411: -- Create PER_SECURITY_PROFILE_ID
4412: --

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

4418: null;
4419: end if;
4420: l_log_message := 'Created Profile Option Value PER_SECURITY_PROFILE_ID ' || l_sg_id;
4421: per_ri_config_utilities.write_log(p_message => l_log_message);
4422: hr_utility.set_location(l_proc, 30);
4423:
4424: open csr_get_product(p_configuration_code);
4425: loop
4426: fetch csr_get_product into l_product_name;

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

4450: null;
4451: end if;
4452: l_log_message := 'Created Profile Option Value HR_USER_TYPE ' || l_hr_user_type;
4453: per_ri_config_utilities.write_log(p_message => l_log_message);
4454: hr_utility.set_location(' Leaving:'|| l_proc, 50);
4455:
4456: else
4457: hr_utility.set_location(l_proc, 110);
4458: open csr_get_product(p_configuration_code);

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

4453: per_ri_config_utilities.write_log(p_message => l_log_message);
4454: hr_utility.set_location(' Leaving:'|| l_proc, 50);
4455:
4456: else
4457: hr_utility.set_location(l_proc, 110);
4458: open csr_get_product(p_configuration_code);
4459: loop
4460: fetch csr_get_product into l_product_name;
4461: exit when csr_get_product%NOTFOUND;

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

4472: l_hr_user_type := 'INT';
4473: else
4474: l_hr_user_type := 'PER';
4475: end if;
4476: hr_utility.set_location(l_proc, 120);
4477: p_bg_sg_ut_profile_resp_tab(l_profile_count).level := 10003;
4478: p_bg_sg_ut_profile_resp_tab(l_profile_count).level_value := p_responsibility_key;
4479: p_bg_sg_ut_profile_resp_tab(l_profile_count).level_value_app := 'PER';
4480: p_bg_sg_ut_profile_resp_tab(l_profile_count).profile_name := 'PER_BUSINESS_GROUP_ID';

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

4495: p_bg_sg_ut_profile_resp_tab(l_profile_count).profile_option_value := l_hr_user_type;
4496:
4497: l_profile_count := l_profile_count + 1;
4498:
4499: hr_utility.set_location(l_proc, 130);
4500: end if;
4501: EXCEPTION
4502: when others then
4503: l_error_message := 'Error in ' || l_proc;

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

4500: end if;
4501: EXCEPTION
4502: when others then
4503: l_error_message := 'Error in ' || l_proc;
4504: hr_utility.trace(l_error_message || '-' || sqlerrm);
4505: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4506: hr_utility.raise_error;
4507:
4508: END create_bg_id_and_sg_id_profile;

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

4501: EXCEPTION
4502: when others then
4503: l_error_message := 'Error in ' || l_proc;
4504: hr_utility.trace(l_error_message || '-' || sqlerrm);
4505: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4506: hr_utility.raise_error;
4507:
4508: END create_bg_id_and_sg_id_profile;
4509:

Line 4506: hr_utility.raise_error;

4502: when others then
4503: l_error_message := 'Error in ' || l_proc;
4504: hr_utility.trace(l_error_message || '-' || sqlerrm);
4505: hr_utility.set_location(' Leaving:'|| l_proc, 500);
4506: hr_utility.raise_error;
4507:
4508: END create_bg_id_and_sg_id_profile;
4509:
4510: END per_ri_config_fnd_hr_entity;