DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_FND_DEF_ENTITY dependencies on HR_UTILITY

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

33: l_profile_defined boolean;
34: l_password varchar2(20) := 'welcome';
35:
36: BEGIN
37: hr_utility.set_location('Entering:'|| l_proc, 10);
38:
39: l_user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
40: (per_ri_config_main.g_configuration_user_name));
41:

Line 42: hr_utility.trace('l_user_name = ' || l_user_name);

38:
39: l_user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
40: (per_ri_config_main.g_configuration_user_name));
41:
42: hr_utility.trace('l_user_name = ' || l_user_name);
43: open csr_find_user(l_user_name);
44: fetch csr_find_user into l_user_id;
45:
46: if NOT (p_technical_summary_mode) then

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

63:
64: l_log_message := 'Created User ' || upper(per_ri_config_utilities.return_config_entity_name_pre
65: (per_ri_config_main.g_configuration_user_name));
66: per_ri_config_utilities.write_log(p_message => l_log_message);
67: hr_utility.set_location(l_proc, 20);
68: else
69: l_log_message := 'User Already Existing ';
70: per_ri_config_utilities.write_log(p_message => l_log_message);
71: hr_utility.set_location(l_proc, 30);

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

67: hr_utility.set_location(l_proc, 20);
68: else
69: l_log_message := 'User Already Existing ';
70: per_ri_config_utilities.write_log(p_message => l_log_message);
71: hr_utility.set_location(l_proc, 30);
72: end if;
73: else
74: p_user_tab(l_users_count).user_name := upper(per_ri_config_utilities.return_config_entity_name_pre
75: (per_ri_config_main.g_configuration_user_name));

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

79: l_users_count := l_users_count + 1;
80: end if;
81: close csr_find_user;
82:
83: hr_utility.set_location(' Leaving:'|| l_proc, 40);
84: EXCEPTION
85: when others then
86: l_error_message := 'Error in ' || l_proc;
87: hr_utility.trace(l_error_message || '-' || sqlerrm);

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

83: hr_utility.set_location(' Leaving:'|| l_proc, 40);
84: EXCEPTION
85: when others then
86: l_error_message := 'Error in ' || l_proc;
87: hr_utility.trace(l_error_message || '-' || sqlerrm);
88: hr_utility.set_location(' Leaving:'|| l_proc, 500);
89: hr_utility.raise_error;
90:
91: END create_user;

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

84: EXCEPTION
85: when others then
86: l_error_message := 'Error in ' || l_proc;
87: hr_utility.trace(l_error_message || '-' || sqlerrm);
88: hr_utility.set_location(' Leaving:'|| l_proc, 500);
89: hr_utility.raise_error;
90:
91: END create_user;
92:

Line 89: hr_utility.raise_error;

85: when others then
86: l_error_message := 'Error in ' || l_proc;
87: hr_utility.trace(l_error_message || '-' || sqlerrm);
88: hr_utility.set_location(' Leaving:'|| l_proc, 500);
89: hr_utility.raise_error;
90:
91: END create_user;
92:
93: /* --------------------------------------------------------------------------

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

108: l_log_message varchar2(360);
109: l_error_message varchar2(360);
110:
111: BEGIN
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113:
114: --HR_CROSS_BUSINESS_GROUP
115: if NOT (p_technical_summary_mode) then
116: per_ri_config_utilities.set_profile_option_value

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

131: end if;
132:
133: l_log_message := 'Created PROFILE_OPTION ' || 'HR_CROSS_BUSINESS_GROUP';
134: per_ri_config_utilities.write_log(p_message => l_log_message);
135: hr_utility.set_location(l_proc, 20);
136:
137: /* DGARG - MSG Changes
138: if (per_ri_config_utilities.check_selected_product
139: (p_configuration_code => p_configuration_code

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

158:
159: end if;
160: l_log_message := 'Created PROFILE_OPTION PER ' || 'ENABLE_SECURITY_GROUPS';
161: per_ri_config_utilities.write_log(p_message => l_log_message);
162: hr_utility.set_location(l_proc, 30);
163: end if;
164:
165: if (per_ri_config_utilities.check_selected_product
166: (p_configuration_code => p_configuration_code

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

185:
186: end if;
187: l_log_message := 'Created PROFILE_OPTION PAY ' || 'ENABLE_SECURITY_GROUPS';
188: per_ri_config_utilities.write_log(p_message => l_log_message);
189: hr_utility.set_location(l_proc, 30);
190: end if;
191:
192: if (per_ri_config_utilities.check_selected_product
193: (p_configuration_code => p_configuration_code

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

212:
213: end if;
214: l_log_message := 'Created PROFILE_OPTION BEN ' || 'ENABLE_SECURITY_GROUPS';
215: per_ri_config_utilities.write_log(p_message => l_log_message);
216: hr_utility.set_location(l_proc, 30);
217: end if;
218: ** */
219: --HR_SYNC_SINGLE_GL_ORG
220: if NOT (p_technical_summary_mode) then

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

236:
237: end if;
238: l_log_message := 'Created PROFILE_OPTION ' || 'HR_SYNC_SINGLE_GL_ORG';
239: per_ri_config_utilities.write_log(p_message => l_log_message);
240: hr_utility.set_location(l_proc, 40);
241:
242: --HR_GENERATE_GL_ORGS
243: if NOT (p_technical_summary_mode) then
244: per_ri_config_utilities.set_profile_option_value

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

259: end if;
260:
261: l_log_message := 'Created PROFILE_OPTION ' || 'HR_GENERATE_GL_ORGS';
262: per_ri_config_utilities.write_log(p_message => l_log_message);
263: hr_utility.set_location(l_proc, 50);
264:
265: --BIS_PRIMARY_RATE_TYPE
266: if NOT (p_technical_summary_mode) then
267: per_ri_config_utilities.set_profile_option_value

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

282: end if;
283:
284: l_log_message := 'Created PROFILE_OPTION ' || 'BIS_PRIMARY_RATE_TYPE';
285: per_ri_config_utilities.write_log(p_message => l_log_message);
286: hr_utility.set_location(l_proc, 60);
287:
288: --BIS_WORKFORCE_MEASUREMENT_TYPE
289: if NOT (p_technical_summary_mode) then
290: per_ri_config_utilities.set_profile_option_value

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

305: end if;
306:
307: l_log_message := 'Created PROFILE_OPTION ' || 'BIS_WORKFORCE_MEASUREMENT_TYPE';
308: per_ri_config_utilities.write_log(p_message => l_log_message);
309: hr_utility.set_location(l_proc, 70);
310:
311: if (per_ri_config_utilities.check_selected_product
312: (p_configuration_code => p_configuration_code
313: ,p_product_name => 'SSHR')) then

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

331: end if;
332:
333: l_log_message := 'Created PROFILE_OPTION ' || 'HR_SELF_SERVICE_HR_LICENSED';
334: per_ri_config_utilities.write_log(p_message => l_log_message);
335: hr_utility.set_location(l_proc, 80);
336: end if;
337:
338: hr_utility.set_location(' Leaving:'|| l_proc, 90);
339:

Line 338: hr_utility.set_location(' Leaving:'|| l_proc, 90);

334: per_ri_config_utilities.write_log(p_message => l_log_message);
335: hr_utility.set_location(l_proc, 80);
336: end if;
337:
338: hr_utility.set_location(' Leaving:'|| l_proc, 90);
339:
340: EXCEPTION
341: when others then
342: l_error_message := 'Error in ' || l_proc;

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

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

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

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

Line 345: hr_utility.raise_error;

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

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

379: l_self_service boolean default FALSE;
380:
381: l_product_name per_ri_config_information.config_information1%type;
382: BEGIN
383: hr_utility.set_location('Entering:'|| l_proc, 10);
384:
385: if NOT (p_technical_summary_mode) then
386: -- Attach System Administrator
387: fnd_User_resp_groups_api.load_row(

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

407:
408: l_resp_count := l_resp_count + 1 ;
409: end if;
410:
411: hr_utility.set_location(l_proc, 20);
412: l_log_message := 'Created RESPONSIBILITY ' || 'SYSTEM_ADMINISTRATOR';
413: per_ri_config_utilities.write_log(p_message => l_log_message);
414:
415: -- Attach APPLICATION IMPLEMENTATION for iSetup

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

437:
438: l_resp_count := l_resp_count + 1 ;
439:
440: end if;
441: hr_utility.set_location(l_proc, 40);
442: l_log_message := 'Created RESPONSIBILITY ' || 'APPLICATION IMPLEMENTATION';
443: per_ri_config_utilities.write_log(p_message => l_log_message);
444:
445: -- Attach FNDWF_USER_WEB_NEW for Payroll Process Workflow process

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

468:
469: l_resp_count := l_resp_count + 1 ;
470:
471: end if;
472: hr_utility.set_location(l_proc, 40);
473: l_log_message := 'Created RESPONSIBILITY ' || 'FNDWF_USER_WEB_NEW';
474: per_ri_config_utilities.write_log(p_message => l_log_message);
475:
476: -- Attach AZ_ISETUP

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

498:
499: l_resp_count := l_resp_count + 1 ;
500:
501: end if;
502: hr_utility.set_location(l_proc, 40);
503: l_log_message := 'Created RESPONSIBILITY ' || 'AZ_ISETUP';
504: per_ri_config_utilities.write_log(p_message => l_log_message);
505:
506: -- Attach HRMS_RI_WORKBENCH

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

528:
529: l_resp_count := l_resp_count + 1 ;
530:
531: end if;
532: hr_utility.set_location(l_proc, 50);
533: l_log_message := 'Created RESPONSIBILITY ' || 'HRMS_RI_WORKBENCH';
534: per_ri_config_utilities.write_log(p_message => l_log_message);
535:
536: hr_utility.set_location(' Leaving:'|| l_proc, 50);

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

532: hr_utility.set_location(l_proc, 50);
533: l_log_message := 'Created RESPONSIBILITY ' || 'HRMS_RI_WORKBENCH';
534: per_ri_config_utilities.write_log(p_message => l_log_message);
535:
536: hr_utility.set_location(' Leaving:'|| l_proc, 50);
537:
538: -- create data for technical summary for self-service responsibilities
539: open csr_get_product(p_configuration_code);
540:

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

540:
541: loop
542: fetch csr_get_product into l_product_name;
543: exit when csr_get_product%NOTFOUND;
544: hr_utility.trace('l_product_name = ' || l_product_name);
545:
546: if l_product_name = 'PER' then
547: l_hr := TRUE;
548: end if;

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

591:
592: l_resp_count := l_resp_count + 1 ;
593: end if;
594:
595: hr_utility.set_location(l_proc, 30);
596: EXCEPTION
597: when others then
598: l_error_message := 'Error in ' || l_proc;
599: hr_utility.trace(l_error_message || '-' || sqlerrm);

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

595: hr_utility.set_location(l_proc, 30);
596: EXCEPTION
597: when others then
598: l_error_message := 'Error in ' || l_proc;
599: hr_utility.trace(l_error_message || '-' || sqlerrm);
600: hr_utility.set_location(' Leaving:'|| l_proc, 500);
601: hr_utility.raise_error;
602:
603: END attach_default_responsibility;

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

596: EXCEPTION
597: when others then
598: l_error_message := 'Error in ' || l_proc;
599: hr_utility.trace(l_error_message || '-' || sqlerrm);
600: hr_utility.set_location(' Leaving:'|| l_proc, 500);
601: hr_utility.raise_error;
602:
603: END attach_default_responsibility;
604:

Line 601: hr_utility.raise_error;

597: when others then
598: l_error_message := 'Error in ' || l_proc;
599: hr_utility.trace(l_error_message || '-' || sqlerrm);
600: hr_utility.set_location(' Leaving:'|| l_proc, 500);
601: hr_utility.raise_error;
602:
603: END attach_default_responsibility;
604:
605: END per_ri_config_fnd_def_entity;