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_DATAPUMP_ENTITY dependencies on HR_UTILITY

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

76: l_enterprise_id number(9);
77:
78: BEGIN
79:
80: hr_utility.set_location('Entering:'|| l_proc, 10);
81:
82: l_multi_tenancy := hr_multi_tenancy_pkg.is_multi_tenant_system;
83: l_sec_group_id := fnd_global.security_group_id;
84: if l_multi_tenancy then

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

112: l_hr_enterprise_primary_indust,
113: l_enterprise_location_id;
114:
115: if csr_config_enterprise%FOUND then
116: hr_utility.set_location(l_proc, 20);
117:
118: -- decide on business group for enterprise
119: l_business_group_country_code := per_ri_config_utilities.get_enterprise_bg_name
120: (p_configuration_code => p_configuration_code

Line 123: hr_utility.trace('l_business_group_country_code = ' || l_business_group_country_code);

119: l_business_group_country_code := per_ri_config_utilities.get_enterprise_bg_name
120: (p_configuration_code => p_configuration_code
121: ,p_enterprise_name => l_enterprise_name_original);
122:
123: hr_utility.trace('l_business_group_country_code = ' || l_business_group_country_code);
124: hr_utility.set_location(l_business_group_country_code, 93000);
125: hr_utility.set_location(l_selected_country_code, 94000);
126: IF l_business_group_country_code = l_selected_country_code AND
127: l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'

Line 124: hr_utility.set_location(l_business_group_country_code, 93000);

120: (p_configuration_code => p_configuration_code
121: ,p_enterprise_name => l_enterprise_name_original);
122:
123: hr_utility.trace('l_business_group_country_code = ' || l_business_group_country_code);
124: hr_utility.set_location(l_business_group_country_code, 93000);
125: hr_utility.set_location(l_selected_country_code, 94000);
126: IF l_business_group_country_code = l_selected_country_code AND
127: l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
128: AND l_enterprise_id IS NOT NULL

Line 125: hr_utility.set_location(l_selected_country_code, 94000);

121: ,p_enterprise_name => l_enterprise_name_original);
122:
123: hr_utility.trace('l_business_group_country_code = ' || l_business_group_country_code);
124: hr_utility.set_location(l_business_group_country_code, 93000);
125: hr_utility.set_location(l_selected_country_code, 94000);
126: IF l_business_group_country_code = l_selected_country_code AND
127: l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
128: AND l_enterprise_id IS NOT NULL
129: THEN

Line 130: hr_utility.set_location('BG Matches', 91000);

126: IF l_business_group_country_code = l_selected_country_code AND
127: l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
128: AND l_enterprise_id IS NOT NULL
129: THEN
130: hr_utility.set_location('BG Matches', 91000);
131: l_business_group_name := l_selected_country_name;
132: ELSE
133: l_business_group_name := per_ri_config_utilities.get_enterprise_short_name
134: (p_configuration_code => p_configuration_code)

Line 137: hr_utility.trace('l_business_group_name = ' || l_business_group_name);

133: l_business_group_name := per_ri_config_utilities.get_enterprise_short_name
134: (p_configuration_code => p_configuration_code)
135: || ' ' || l_business_group_country_code || per_ri_config_main.g_bg_name_suffix_string;
136: END IF;
137: hr_utility.trace('l_business_group_name = ' || l_business_group_name);
138: hr_utility.set_location(l_business_group_name, 92000);
139: l_ent_location_code := per_ri_config_utilities.get_config_location_code
140: (p_configuration_code => p_configuration_code
141: ,p_location_id => l_enterprise_location_id);

Line 138: hr_utility.set_location(l_business_group_name, 92000);

134: (p_configuration_code => p_configuration_code)
135: || ' ' || l_business_group_country_code || per_ri_config_main.g_bg_name_suffix_string;
136: END IF;
137: hr_utility.trace('l_business_group_name = ' || l_business_group_name);
138: hr_utility.set_location(l_business_group_name, 92000);
139: l_ent_location_code := per_ri_config_utilities.get_config_location_code
140: (p_configuration_code => p_configuration_code
141: ,p_location_id => l_enterprise_location_id);
142: -- get entity name for multiple configuration

Line 144: hr_utility.trace('l_ent_location_code = ' || l_ent_location_code);

140: (p_configuration_code => p_configuration_code
141: ,p_location_id => l_enterprise_location_id);
142: -- get entity name for multiple configuration
143: --
144: hr_utility.trace('l_ent_location_code = ' || l_ent_location_code);
145: hr_utility.set_location(l_proc, 30);
146: if NOT (p_technical_summary_mode) then
147: -- if l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0' then
148: -- l_business_group_name := per_ri_config_utilities.get_business_group_name;

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

141: ,p_location_id => l_enterprise_location_id);
142: -- get entity name for multiple configuration
143: --
144: hr_utility.trace('l_ent_location_code = ' || l_ent_location_code);
145: hr_utility.set_location(l_proc, 30);
146: if NOT (p_technical_summary_mode) then
147: -- if l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0' then
148: -- l_business_group_name := per_ri_config_utilities.get_business_group_name;
149: -- end if;

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

158: ,p_location_code => l_ent_location_code
159: ,p_internal_external_flag => 'INT'
160: ,p_org_user_key => l_enterprise_name || SYSDATE);
161:
162: hr_utility.set_location(l_proc, 40);
163:
164: hrdpp_update_organization.insert_batch_lines
165: (p_batch_id => p_batch_header_id
166: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

184: end if;
185:
186: l_log_message := 'Created ENTERPRISE ' || l_enterprise_name;
187: per_ri_config_utilities.write_log(p_message => l_log_message);
188: hr_utility.set_location(l_proc, 50);
189:
190: --
191: -- Create HR_LEGAL classification for corporate LE
192: -- For all Localizations where no mandatory org info is defined.

Line 201: hr_utility.trace('l_mandatory_org_info_types = ' || 'TRUE');

197: ,p_lookup_code => 'HR_LEGAL')
198: and NOT per_ri_config_utilities.mandatory_org_info_types
199: (p_legislation_code => l_business_group_country_code
200: ,p_org_classification => 'HR_LEGAL') then
201: hr_utility.trace('l_mandatory_org_info_types = ' || 'TRUE');
202: if NOT (p_technical_summary_mode) then
203: hrdpp_create_org_classificatio.insert_batch_lines
204: (p_batch_id => p_batch_header_id
205: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

218:
219: l_ent_class_count := l_ent_class_count + 1;
220:
221: end if;
222: hr_utility.set_location(l_proc, 60);
223: l_log_message := 'Created CLASSIFICATION HR_LEGAL ' || l_enterprise_name;
224: per_ri_config_utilities.write_log(p_message => l_log_message);
225: end if;
226:

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

223: l_log_message := 'Created CLASSIFICATION HR_LEGAL ' || l_enterprise_name;
224: per_ri_config_utilities.write_log(p_message => l_log_message);
225: end if;
226:
227: hr_utility.set_location(l_proc, 70);
228:
229: --also create organization structure hierarchy batch line
230: if NOT (p_technical_summary_mode) then
231: hrdpp_create_organization_stru.insert_batch_lines

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

268: end if;
269:
270: l_log_message := 'Created HIERARCHY VERSION ' || to_char(1);
271: per_ri_config_utilities.write_log(p_message => l_log_message);
272: hr_utility.set_location(l_proc, 80);
273: else
274: null; -- report error
275: end if;
276:

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

296:
297: end if;
298: l_log_message := 'Created PROFILE_OPTION ' || 'BIS_PRIMARY_RATE_TYPE';
299: per_ri_config_utilities.write_log(p_message => l_log_message);
300: hr_utility.set_location(l_proc, 60);
301: hr_utility.set_location(' Leaving:'|| l_proc, 100);
302:
303: EXCEPTION
304: when others then

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

297: end if;
298: l_log_message := 'Created PROFILE_OPTION ' || 'BIS_PRIMARY_RATE_TYPE';
299: per_ri_config_utilities.write_log(p_message => l_log_message);
300: hr_utility.set_location(l_proc, 60);
301: hr_utility.set_location(' Leaving:'|| l_proc, 100);
302:
303: EXCEPTION
304: when others then
305: l_error_message := 'Error in ' || l_proc;

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

302:
303: EXCEPTION
304: when others then
305: l_error_message := 'Error in ' || l_proc;
306: hr_utility.trace(l_error_message || '-' || sqlerrm);
307: hr_utility.set_location(' Leaving:'|| l_proc, 500);
308: hr_utility.raise_error;
309:
310: END create_enterprise_batch_lines;

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

303: EXCEPTION
304: when others then
305: l_error_message := 'Error in ' || l_proc;
306: hr_utility.trace(l_error_message || '-' || sqlerrm);
307: hr_utility.set_location(' Leaving:'|| l_proc, 500);
308: hr_utility.raise_error;
309:
310: END create_enterprise_batch_lines;
311:

Line 308: hr_utility.raise_error;

304: when others then
305: l_error_message := 'Error in ' || l_proc;
306: hr_utility.trace(l_error_message || '-' || sqlerrm);
307: hr_utility.set_location(' Leaving:'|| l_proc, 500);
308: hr_utility.raise_error;
309:
310: END create_enterprise_batch_lines;
311:
312:

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

373: l_enterprise_id number(9);
374:
375: BEGIN
376:
377: hr_utility.set_location('Entering:'|| l_proc, 10);
378:
379: l_multi_tenancy := hr_multi_tenancy_pkg.is_multi_tenant_system;
380: l_sec_group_id := fnd_global.security_group_id;
381: if l_multi_tenancy then

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

412: l_operating_comp_location_id;
413:
414: exit when csr_config_oper_comp%NOTFOUND;
415: if csr_config_oper_comp%FOUND then
416: hr_utility.set_location(l_proc, 20);
417:
418: hr_utility.trace('l_operating_company_name = ' || l_operating_company_name);
419: l_business_group_country_code := per_ri_config_utilities.get_oc_bg_name
420: (p_configuration_code => p_configuration_code

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

414: exit when csr_config_oper_comp%NOTFOUND;
415: if csr_config_oper_comp%FOUND then
416: hr_utility.set_location(l_proc, 20);
417:
418: hr_utility.trace('l_operating_company_name = ' || l_operating_company_name);
419: l_business_group_country_code := per_ri_config_utilities.get_oc_bg_name
420: (p_configuration_code => p_configuration_code
421: ,p_operating_company_name => l_operating_company_name_orig);
422: hr_utility.set_location(l_business_group_country_code, 93000);

Line 422: hr_utility.set_location(l_business_group_country_code, 93000);

418: hr_utility.trace('l_operating_company_name = ' || l_operating_company_name);
419: l_business_group_country_code := per_ri_config_utilities.get_oc_bg_name
420: (p_configuration_code => p_configuration_code
421: ,p_operating_company_name => l_operating_company_name_orig);
422: hr_utility.set_location(l_business_group_country_code, 93000);
423: hr_utility.set_location(l_selected_country_code, 94000);
424: IF l_business_group_country_code = l_selected_country_code AND
425: l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
426: AND l_enterprise_id IS NOT NULL

Line 423: hr_utility.set_location(l_selected_country_code, 94000);

419: l_business_group_country_code := per_ri_config_utilities.get_oc_bg_name
420: (p_configuration_code => p_configuration_code
421: ,p_operating_company_name => l_operating_company_name_orig);
422: hr_utility.set_location(l_business_group_country_code, 93000);
423: hr_utility.set_location(l_selected_country_code, 94000);
424: IF l_business_group_country_code = l_selected_country_code AND
425: l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
426: AND l_enterprise_id IS NOT NULL
427: THEN

Line 428: hr_utility.set_location('BG Matches', 91000);

424: IF l_business_group_country_code = l_selected_country_code AND
425: l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
426: AND l_enterprise_id IS NOT NULL
427: THEN
428: hr_utility.set_location('BG Matches', 91000);
429: l_business_group_name := l_selected_country_name;
430: ELSE
431: l_business_group_name := per_ri_config_utilities.get_enterprise_short_name
432: (p_configuration_code => p_configuration_code)

Line 435: hr_utility.trace('l_business_group_name = ' || l_business_group_name);

431: l_business_group_name := per_ri_config_utilities.get_enterprise_short_name
432: (p_configuration_code => p_configuration_code)
433: || ' ' || l_business_group_country_code || per_ri_config_main.g_bg_name_suffix_string;
434: END IF;
435: hr_utility.trace('l_business_group_name = ' || l_business_group_name);
436:
437: l_oc_location_code := per_ri_config_utilities.get_config_location_code
438: (p_configuration_code => p_configuration_code
439: ,p_location_id => l_operating_comp_location_id);

Line 441: hr_utility.trace('l_business_group_country_code = ' || l_business_group_country_code);

437: l_oc_location_code := per_ri_config_utilities.get_config_location_code
438: (p_configuration_code => p_configuration_code
439: ,p_location_id => l_operating_comp_location_id);
440:
441: hr_utility.trace('l_business_group_country_code = ' || l_business_group_country_code);
442: hr_utility.trace('l_business_group_name = ' || l_business_group_name);
443: hr_utility.trace('l_oc_location_code = ' || l_oc_location_code);
444:
445: if NOT (p_technical_summary_mode) then

Line 442: hr_utility.trace('l_business_group_name = ' || l_business_group_name);

438: (p_configuration_code => p_configuration_code
439: ,p_location_id => l_operating_comp_location_id);
440:
441: hr_utility.trace('l_business_group_country_code = ' || l_business_group_country_code);
442: hr_utility.trace('l_business_group_name = ' || l_business_group_name);
443: hr_utility.trace('l_oc_location_code = ' || l_oc_location_code);
444:
445: if NOT (p_technical_summary_mode) then
446: -- if l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0' then

Line 443: hr_utility.trace('l_oc_location_code = ' || l_oc_location_code);

439: ,p_location_id => l_operating_comp_location_id);
440:
441: hr_utility.trace('l_business_group_country_code = ' || l_business_group_country_code);
442: hr_utility.trace('l_business_group_name = ' || l_business_group_name);
443: hr_utility.trace('l_oc_location_code = ' || l_oc_location_code);
444:
445: if NOT (p_technical_summary_mode) then
446: -- if l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0' then
447: -- l_business_group_name := per_ri_config_utilities.get_business_group_name;

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

459: ,p_location_code => l_oc_location_code
460: ,p_org_user_key => l_operating_company_name || SYSDATE);
461:
462:
463: hr_utility.set_location(l_proc, 30);
464:
465: hrdpp_update_organization.insert_batch_lines
466: (p_batch_id => p_batch_header_id
467: ,p_link_value => per_ri_config_main.g_global_dp_link_value

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

485:
486:
487: l_log_message := 'Created OPERATING COMPANY ' || l_operating_company_name;
488: per_ri_config_utilities.write_log(p_message => l_log_message);
489: hr_utility.set_location(l_proc, 40);
490:
491: -- create org hierarchy elements
492: --
493: l_enterprise_name := per_ri_config_utilities.get_enterprise_name

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

556:
557: l_oc_class_count := l_oc_class_count + 1;
558:
559: end if;
560: hr_utility.set_location(l_proc, 50);
561: l_log_message := 'Created CLASSIFICATION HR_OPC ' || l_operating_company_name;
562: per_ri_config_utilities.write_log(p_message => l_log_message);
563: end if;
564: end if;

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

563: end if;
564: end if;
565: end loop;
566: close csr_config_oper_comp;
567: hr_utility.set_location(' Leaving:'|| l_proc, 100);
568:
569: EXCEPTION
570: when others then
571: l_error_message := 'Error in ' || l_proc;

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

568:
569: EXCEPTION
570: when others then
571: l_error_message := 'Error in ' || l_proc;
572: hr_utility.trace(l_error_message || '-' || sqlerrm);
573: hr_utility.set_location(' Leaving:'|| l_proc, 500);
574: hr_utility.raise_error;
575:
576: END create_oper_comp_batch_lines;

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

569: EXCEPTION
570: when others then
571: l_error_message := 'Error in ' || l_proc;
572: hr_utility.trace(l_error_message || '-' || sqlerrm);
573: hr_utility.set_location(' Leaving:'|| l_proc, 500);
574: hr_utility.raise_error;
575:
576: END create_oper_comp_batch_lines;
577:

Line 574: hr_utility.raise_error;

570: when others then
571: l_error_message := 'Error in ' || l_proc;
572: hr_utility.trace(l_error_message || '-' || sqlerrm);
573: hr_utility.set_location(' Leaving:'|| l_proc, 500);
574: hr_utility.raise_error;
575:
576: END create_oper_comp_batch_lines;
577:
578: /* --------------------------------------------------------------------------

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

642: l_enterprise_id number(9);
643:
644: BEGIN
645:
646: hr_utility.set_location('Entering:'|| l_proc, 10);
647:
648: l_multi_tenancy := hr_multi_tenancy_pkg.is_multi_tenant_system;
649: l_sec_group_id := fnd_global.security_group_id;
650: if l_multi_tenancy then

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

683: l_le_parent_oper_comp,
684: l_legal_entity_location_id;
685:
686: exit when csr_config_legal_entity%NOTFOUND;
687: hr_utility.set_location(l_proc, 20);
688:
689: hr_utility.trace('l_legal_entity_name = ' || l_legal_entity_name);
690: hr_utility.trace('l_legal_entity_country = ' || l_legal_entity_country);
691:

Line 689: hr_utility.trace('l_legal_entity_name = ' || l_legal_entity_name);

685:
686: exit when csr_config_legal_entity%NOTFOUND;
687: hr_utility.set_location(l_proc, 20);
688:
689: hr_utility.trace('l_legal_entity_name = ' || l_legal_entity_name);
690: hr_utility.trace('l_legal_entity_country = ' || l_legal_entity_country);
691:
692: l_business_group_country_code := per_ri_config_utilities.get_le_bg_name
693: (p_configuration_code => p_configuration_code

Line 690: hr_utility.trace('l_legal_entity_country = ' || l_legal_entity_country);

686: exit when csr_config_legal_entity%NOTFOUND;
687: hr_utility.set_location(l_proc, 20);
688:
689: hr_utility.trace('l_legal_entity_name = ' || l_legal_entity_name);
690: hr_utility.trace('l_legal_entity_country = ' || l_legal_entity_country);
691:
692: l_business_group_country_code := per_ri_config_utilities.get_le_bg_name
693: (p_configuration_code => p_configuration_code
694: ,p_legal_entity_name => l_legal_entity_name_original);

Line 695: hr_utility.set_location(l_business_group_country_code, 93000);

691:
692: l_business_group_country_code := per_ri_config_utilities.get_le_bg_name
693: (p_configuration_code => p_configuration_code
694: ,p_legal_entity_name => l_legal_entity_name_original);
695: hr_utility.set_location(l_business_group_country_code, 93000);
696: hr_utility.set_location(l_selected_country_code, 94000);
697: IF l_business_group_country_code = l_selected_country_code AND
698: l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
699: AND l_enterprise_id IS NOT NULL

Line 696: hr_utility.set_location(l_selected_country_code, 94000);

692: l_business_group_country_code := per_ri_config_utilities.get_le_bg_name
693: (p_configuration_code => p_configuration_code
694: ,p_legal_entity_name => l_legal_entity_name_original);
695: hr_utility.set_location(l_business_group_country_code, 93000);
696: hr_utility.set_location(l_selected_country_code, 94000);
697: IF l_business_group_country_code = l_selected_country_code AND
698: l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
699: AND l_enterprise_id IS NOT NULL
700: THEN

Line 701: hr_utility.set_location('BG Matches', 91000);

697: IF l_business_group_country_code = l_selected_country_code AND
698: l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
699: AND l_enterprise_id IS NOT NULL
700: THEN
701: hr_utility.set_location('BG Matches', 91000);
702: l_business_group_name := l_selected_country_name;
703: ELSE
704: l_business_group_name := per_ri_config_utilities.get_enterprise_short_name
705: (p_configuration_code => p_configuration_code)

Line 708: hr_utility.trace('l_business_group_name = ' || l_business_group_name);

704: l_business_group_name := per_ri_config_utilities.get_enterprise_short_name
705: (p_configuration_code => p_configuration_code)
706: || ' ' || l_business_group_country_code || per_ri_config_main.g_bg_name_suffix_string;
707: END IF;
708: hr_utility.trace('l_business_group_name = ' || l_business_group_name);
709:
710: l_le_location_code := per_ri_config_utilities.get_config_location_code
711: (p_configuration_code => p_configuration_code
712: ,p_location_id => l_legal_entity_location_id);

Line 713: hr_utility.trace('l_legal_entity_location_id = ' || l_legal_entity_location_id);

709:
710: l_le_location_code := per_ri_config_utilities.get_config_location_code
711: (p_configuration_code => p_configuration_code
712: ,p_location_id => l_legal_entity_location_id);
713: hr_utility.trace('l_legal_entity_location_id = ' || l_legal_entity_location_id);
714: hr_utility.set_location(l_proc, 30);
715:
716: if NOT (p_technical_summary_mode) then
717: -- if l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0' then

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

710: l_le_location_code := per_ri_config_utilities.get_config_location_code
711: (p_configuration_code => p_configuration_code
712: ,p_location_id => l_legal_entity_location_id);
713: hr_utility.trace('l_legal_entity_location_id = ' || l_legal_entity_location_id);
714: hr_utility.set_location(l_proc, 30);
715:
716: if NOT (p_technical_summary_mode) then
717: -- if l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0' then
718: -- l_business_group_name := per_ri_config_utilities.get_business_group_name;

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

739: ,p_data_pump_business_grp_name => l_business_group_name
740: ,p_language_code => hr_api.userenv_lang
741: ,p_organization_name => l_legal_entity_name
742: ,p_location_code => l_le_location_code);
743: hr_utility.set_location(l_proc, 40);
744: else
745: p_org_le_tab(l_le_count).effective_date := g_config_effective_date;
746: p_org_le_tab(l_le_count).date_from := g_config_effective_date;
747: p_org_le_tab(l_le_count).business_grp_name := l_business_group_name;

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

786:
787: l_le_class_count := l_le_class_count + 1;
788:
789: end if;
790: hr_utility.set_location(l_proc, 50);
791: l_log_message := 'Created CLASSIFICATION CC ' || l_legal_entity_name;
792: per_ri_config_utilities.write_log(p_message => l_log_message);
793: end if;
794:

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

823: l_le_class_count := l_le_class_count + 1;
824:
825: end if;
826:
827: hr_utility.set_location(l_proc, 60);
828: l_log_message := 'Created CLASSIFICATION HR_LEGAL_EMPLOYER ' || l_legal_entity_name;
829: per_ri_config_utilities.write_log(p_message => l_log_message);
830: end if;
831:

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

861:
862: l_le_class_count := l_le_class_count + 1;
863:
864: end if;
865: hr_utility.set_location(l_proc, 70);
866: l_log_message := 'Created CLASSIFICATION FR_SOCIETE ' || l_legal_entity_name;
867: per_ri_config_utilities.write_log(p_message => l_log_message);
868: end if;
869:

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

900:
901: l_le_class_count := l_le_class_count + 1;
902:
903: end if;
904: hr_utility.set_location(l_proc, 80);
905: l_log_message := 'Created CLASSIFICATION IN_COMPANY ' || l_legal_entity_name;
906: per_ri_config_utilities.write_log(p_message => l_log_message);
907: end if;
908:

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

937: l_le_class_count := l_le_class_count + 1;
938:
939: end if;
940:
941: hr_utility.set_location(l_proc, 90);
942: l_log_message := 'Created CLASSIFICATION HR_LEGAL ' || l_legal_entity_name;
943: per_ri_config_utilities.write_log(p_message => l_log_message);
944: end if;
945:

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

980:
981: l_log_message := 'Created HIERARCHY ELEMENT OPERATING_COMPANY ' || l_le_parent_oper_comp || ' ' || l_legal_entity_name;
982: per_ri_config_utilities.write_log(p_message => l_log_message);
983:
984: hr_utility.set_location(l_proc, 100);
985: end loop;
986: close csr_config_legal_entity;
987:
988: hr_utility.set_location(' Leaving:'|| l_proc, 110);

Line 988: hr_utility.set_location(' Leaving:'|| l_proc, 110);

984: hr_utility.set_location(l_proc, 100);
985: end loop;
986: close csr_config_legal_entity;
987:
988: hr_utility.set_location(' Leaving:'|| l_proc, 110);
989:
990: EXCEPTION
991: when others then
992: l_error_message := 'Error in ' || l_proc;

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

989:
990: EXCEPTION
991: when others then
992: l_error_message := 'Error in ' || l_proc;
993: hr_utility.trace(l_error_message || '-' || sqlerrm);
994: hr_utility.set_location(' Leaving:'|| l_proc, 500);
995: hr_utility.raise_error;
996:
997: END create_le_batch_lines;

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

990: EXCEPTION
991: when others then
992: l_error_message := 'Error in ' || l_proc;
993: hr_utility.trace(l_error_message || '-' || sqlerrm);
994: hr_utility.set_location(' Leaving:'|| l_proc, 500);
995: hr_utility.raise_error;
996:
997: END create_le_batch_lines;
998:

Line 995: hr_utility.raise_error;

991: when others then
992: l_error_message := 'Error in ' || l_proc;
993: hr_utility.trace(l_error_message || '-' || sqlerrm);
994: hr_utility.set_location(' Leaving:'|| l_proc, 500);
995: hr_utility.raise_error;
996:
997: END create_le_batch_lines;
998:
999: /* --------------------------------------------------------------------------

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

1082: l_log_message varchar2(360);
1083: l_error_message varchar2(360);
1084:
1085: BEGIN
1086: hr_utility.set_location('Entering:'|| l_proc, 10);
1087:
1088: open csr_config_location(p_configuration_code);
1089: LOOP
1090: fetch csr_config_location into

Line 1130: hr_utility.trace( 'l_location_code = ' || l_location_code);

1126: CLOSE csr_get_country_code;
1127:
1128: end if;
1129:
1130: hr_utility.trace( 'l_location_code = ' || l_location_code);
1131: hr_utility.trace( 'l_style = ' || l_style);
1132: if NOT (p_technical_summary_mode) then
1133: hrdpp_create_location.insert_batch_lines
1134: (p_batch_id => p_batch_header_id

Line 1131: hr_utility.trace( 'l_style = ' || l_style);

1127:
1128: end if;
1129:
1130: hr_utility.trace( 'l_location_code = ' || l_location_code);
1131: hr_utility.trace( 'l_style = ' || l_style);
1132: if NOT (p_technical_summary_mode) then
1133: hrdpp_create_location.insert_batch_lines
1134: (p_batch_id => p_batch_header_id
1135: ,p_effective_date => g_config_effective_date

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

1198: end if;
1199:
1200: l_log_message := 'Created LOCATION ' || l_location_code;
1201: per_ri_config_utilities.write_log(p_message => l_log_message);
1202: hr_utility.set_location(l_proc, 40);
1203: END LOOP;
1204: close csr_config_location;
1205: hr_utility.set_location(' Leaving :' || l_proc, 50);
1206:

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

1201: per_ri_config_utilities.write_log(p_message => l_log_message);
1202: hr_utility.set_location(l_proc, 40);
1203: END LOOP;
1204: close csr_config_location;
1205: hr_utility.set_location(' Leaving :' || l_proc, 50);
1206:
1207: EXCEPTION
1208: when others then
1209: l_error_message := 'Error in ' || l_proc;

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

1206:
1207: EXCEPTION
1208: when others then
1209: l_error_message := 'Error in ' || l_proc;
1210: hr_utility.trace(l_error_message || '-' || sqlerrm);
1211: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1212: hr_utility.raise_error;
1213: END create_locations_batch_lines;
1214:

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

1207: EXCEPTION
1208: when others then
1209: l_error_message := 'Error in ' || l_proc;
1210: hr_utility.trace(l_error_message || '-' || sqlerrm);
1211: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1212: hr_utility.raise_error;
1213: END create_locations_batch_lines;
1214:
1215:

Line 1212: hr_utility.raise_error;

1208: when others then
1209: l_error_message := 'Error in ' || l_proc;
1210: hr_utility.trace(l_error_message || '-' || sqlerrm);
1211: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1212: hr_utility.raise_error;
1213: END create_locations_batch_lines;
1214:
1215:
1216: /* --------------------------------------------------------------------------

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

1286: l_country_selected PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPe;
1287: l_enterprise_id number(9);
1288:
1289: BEGIN
1290: hr_utility.set_location('Entering:'|| l_proc, 10);
1291:
1292: select legislation_code into l_country_selected from per_business_groups
1293: where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
1294:

Line 1301: hr_utility.set_location('Sec Group Id Is '||fnd_global.security_group_id, 95000);

1297: if l_multi_tenancy then
1298: l_system_model := hr_multi_tenancy_pkg.get_system_model;
1299: end if;
1300:
1301: hr_utility.set_location('Sec Group Id Is '||fnd_global.security_group_id, 95000);
1302: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1303: THEN
1304: hr_utility.set_location('Inside the if ', 96000);
1305: select security_group_name into l_security_group_name

Line 1304: hr_utility.set_location('Inside the if ', 96000);

1300:
1301: hr_utility.set_location('Sec Group Id Is '||fnd_global.security_group_id, 95000);
1302: IF l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1303: THEN
1304: hr_utility.set_location('Inside the if ', 96000);
1305: select security_group_name into l_security_group_name
1306: from fnd_security_groups_tl
1307: where security_group_id = fnd_global.security_group_id
1308: and language = userenv('LANG');

Line 1309: hr_utility.set_location('Sec Group Name Is '|| l_security_group_name, 97000);

1305: select security_group_name into l_security_group_name
1306: from fnd_security_groups_tl
1307: where security_group_id = fnd_global.security_group_id
1308: and language = userenv('LANG');
1309: hr_utility.set_location('Sec Group Name Is '|| l_security_group_name, 97000);
1310: END IF;
1311:
1312: BEGIN
1313: select enterprise_id into l_enterprise_id from per_ent_security_groups

Line 1319: hr_utility.set_location('The Legislation Code is '|| l_country_selected, 43);

1315: EXCEPTION
1316: WHEN NO_DATA_FOUND THEN
1317: l_enterprise_id := null;
1318: END;
1319: hr_utility.set_location('The Legislation Code is '|| l_country_selected, 43);
1320:
1321:
1322: open csr_config_business_groups(p_configuration_code);
1323:

Line 1341: hr_utility.set_location('The name selected is '|| l_bg_country_name, 44) ;

1337: l_business_group_name := per_ri_config_utilities.get_enterprise_short_name
1338: (p_configuration_code => p_configuration_code)
1339: || ' ' || l_bg_country_name || per_ri_config_main.g_bg_name_suffix_string;
1340:
1341: hr_utility.set_location('The name selected is '|| l_bg_country_name, 44) ;
1342:
1343: if l_bg_country_name = 'INT' then
1344: l_legislation_code := 'BF'; -- For Burkina Faso
1345: else

Line 1373: hr_utility.trace('Job Name ' || l_job_flex_stru_code);

1369:
1370: l_job_flex_stru_code := per_ri_config_utilities.get_bg_job_keyflex_name
1371: (p_configuration_code => p_configuration_code
1372: ,p_bg_country_code => l_bg_country_name);
1373: hr_utility.trace('Job Name ' || l_job_flex_stru_code);
1374:
1375: l_position_flex_stru_code := per_ri_config_utilities.get_bg_pos_keyflex_name
1376: (p_configuration_code => p_configuration_code
1377: ,p_bg_country_code => l_bg_country_name);

Line 1379: hr_utility.trace('Position Name ' || l_position_flex_stru_code);

1375: l_position_flex_stru_code := per_ri_config_utilities.get_bg_pos_keyflex_name
1376: (p_configuration_code => p_configuration_code
1377: ,p_bg_country_code => l_bg_country_name);
1378:
1379: hr_utility.trace('Position Name ' || l_position_flex_stru_code);
1380: l_grade_flex_stru_code := per_ri_config_utilities.get_bg_grd_keyflex_name
1381: (p_configuration_code => p_configuration_code
1382: ,p_bg_country_code => l_bg_country_name);
1383:

Line 1384: hr_utility.trace('Grade Name ' || l_grade_flex_stru_code);

1380: l_grade_flex_stru_code := per_ri_config_utilities.get_bg_grd_keyflex_name
1381: (p_configuration_code => p_configuration_code
1382: ,p_bg_country_code => l_bg_country_name);
1383:
1384: hr_utility.trace('Grade Name ' || l_grade_flex_stru_code);
1385:
1386: hr_utility.trace('l_legislation_code = ' || l_legislation_code);
1387:
1388: l_currecny_flag := per_ri_config_utilities.check_currency_enabled (p_legislation_code => l_legislation_code);

Line 1386: hr_utility.trace('l_legislation_code = ' || l_legislation_code);

1382: ,p_bg_country_code => l_bg_country_name);
1383:
1384: hr_utility.trace('Grade Name ' || l_grade_flex_stru_code);
1385:
1386: hr_utility.trace('l_legislation_code = ' || l_legislation_code);
1387:
1388: l_currecny_flag := per_ri_config_utilities.check_currency_enabled (p_legislation_code => l_legislation_code);
1389: hr_utility.trace('l_currecny_flag = ' || l_currecny_flag);
1390: if l_currecny_flag = 'X' then

Line 1389: hr_utility.trace('l_currecny_flag = ' || l_currecny_flag);

1385:
1386: hr_utility.trace('l_legislation_code = ' || l_legislation_code);
1387:
1388: l_currecny_flag := per_ri_config_utilities.check_currency_enabled (p_legislation_code => l_legislation_code);
1389: hr_utility.trace('l_currecny_flag = ' || l_currecny_flag);
1390: if l_currecny_flag = 'X' then
1391: per_ri_config_utilities.enable_country_currency (p_legislation_code => l_legislation_code);
1392: hr_utility.trace('l_currecny_flag = ' || l_currecny_flag);
1393: end if;

Line 1392: hr_utility.trace('l_currecny_flag = ' || l_currecny_flag);

1388: l_currecny_flag := per_ri_config_utilities.check_currency_enabled (p_legislation_code => l_legislation_code);
1389: hr_utility.trace('l_currecny_flag = ' || l_currecny_flag);
1390: if l_currecny_flag = 'X' then
1391: per_ri_config_utilities.enable_country_currency (p_legislation_code => l_legislation_code);
1392: hr_utility.trace('l_currecny_flag = ' || l_currecny_flag);
1393: end if;
1394:
1395: IF l_bg_country_name = l_country_selected AND
1396: l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'

Line 1399: hr_utility.set_location('The BG has to be skipped', 90000);

1395: IF l_bg_country_name = l_country_selected AND
1396: l_multi_tenancy AND l_system_model = 'B' AND l_sec_group_id <> '0'
1397: AND l_enterprise_id IS NOT NULL
1398: THEN
1399: hr_utility.set_location('The BG has to be skipped', 90000);
1400: ELSE
1401: if NOT (p_technical_summary_mode) then
1402:
1403: hrdpp_create_business_group.insert_batch_lines

Line 1432: hr_utility.set_location('Entering into the other tab as well ', 89);

1428: ,p_position_flex_stru_code => l_position_flex_stru_code
1429: ,p_security_group_name => l_security_group_name
1430: ,p_competence_flex_stru_code => per_ri_config_main.g_global_cmp_structure_name);
1431: else
1432: hr_utility.set_location('Entering into the other tab as well ', 89);
1433: p_bg_tab(l_bg_count).effective_date := g_config_effective_date;
1434: p_bg_tab(l_bg_count).language_code := hr_api.userenv_lang;
1435: p_bg_tab(l_bg_count).date_from := g_config_effective_date;
1436: p_bg_tab(l_bg_count).name := l_business_group_name;

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

1494: END IF;
1495:
1496: l_log_message := 'Created BUSINESS GROUP ' || l_business_group_name;
1497: per_ri_config_utilities.write_log(p_message => l_log_message);
1498: hr_utility.set_location(l_proc, 40);
1499:
1500: p_country_tab_out(csr_config_business_groups%ROWCOUNT).territory_code := l_legislation_code;
1501:
1502: p_int_bg_resp_tab(csr_config_business_groups%ROWCOUNT).security_profile_name := l_business_group_name;

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

1504: end loop;
1505: close csr_config_business_groups;
1506: close csr_config_information;
1507:
1508: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1509:
1510: EXCEPTION
1511: when others then
1512: l_error_message := 'Error in ' || l_proc;

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

1509:
1510: EXCEPTION
1511: when others then
1512: l_error_message := 'Error in ' || l_proc;
1513: hr_utility.trace(l_error_message || '-' || sqlerrm);
1514: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1515: hr_utility.raise_error;
1516:
1517: END create_bg_batch_lines;

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

1510: EXCEPTION
1511: when others then
1512: l_error_message := 'Error in ' || l_proc;
1513: hr_utility.trace(l_error_message || '-' || sqlerrm);
1514: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1515: hr_utility.raise_error;
1516:
1517: END create_bg_batch_lines;
1518:

Line 1515: hr_utility.raise_error;

1511: when others then
1512: l_error_message := 'Error in ' || l_proc;
1513: hr_utility.trace(l_error_message || '-' || sqlerrm);
1514: hr_utility.set_location(' Leaving:'|| l_proc, 500);
1515: hr_utility.raise_error;
1516:
1517: END create_bg_batch_lines;
1518:
1519: