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

Line 20: hr_utility.set_location (l_proc

16: l_wanted varchar2(1);
17: BEGIN
18: l_proc := 'per_delete_unwanted_sec_prof.concurrent_process';
19:
20: hr_utility.set_location (l_proc
21: ,10);
22:
23: l_strong_delete := 'Y';
24:

Line 30: hr_utility.set_location (l_proc

26:
27: retcode := 0;
28:
29: IF p_report = 'Y' THEN
30: hr_utility.set_location (l_proc
31: ,20);
32:
33: fnd_file.put_line (fnd_file.log
34: ,'Report - Shows Unused Security Profiles');

Line 41: hr_utility.set_location (l_proc

37: ,'------------------------------------------');
38:
39: show_unwanted_sec_prof;
40: ELSIF p_report = 'N' THEN
41: hr_utility.set_location (l_proc
42: ,30);
43:
44: IF p_del_all_sec_profile = 'Y' THEN
45: fnd_file.put_line (fnd_file.log

Line 54: hr_utility.set_location (l_proc

50:
51: del_all_unwanted_sec_prof (l_strong_delete);
52: ELSIF (nvl(p_del_all_sec_profile,'N') = 'N'
53: AND p_security_profile_name IS NOT NULL) THEN
54: hr_utility.set_location (l_proc
55: ,40);
56:
57: OPEN csr_security_prof_name;
58:

Line 63: hr_utility.set_location (l_proc

59: FETCH csr_security_prof_name
60: INTO l_security_profile_id;
61:
62: IF csr_security_prof_name%NOTFOUND THEN
63: hr_utility.set_location (l_proc
64: ,50);
65:
66: fnd_file.put_line (fnd_file.log
67: ,'Security Profile Name Invalid : '

Line 70: hr_utility.set_location (l_proc

66: fnd_file.put_line (fnd_file.log
67: ,'Security Profile Name Invalid : '
68: || p_security_profile_name);
69: ELSE
70: hr_utility.set_location (l_proc
71: ,60);
72:
73: l_wanted := check_unwanted_sec_prof (l_security_profile_id);
74:

Line 94: hr_utility.set_location (l_proc

90: END IF;
91: END IF;
92: END IF;
93:
94: hr_utility.set_location (l_proc
95: ,70);
96: EXCEPTION
97: WHEN others THEN
98: hr_utility.set_location (l_proc

Line 98: hr_utility.set_location (l_proc

94: hr_utility.set_location (l_proc
95: ,70);
96: EXCEPTION
97: WHEN others THEN
98: hr_utility.set_location (l_proc
99: ,80);
100:
101: fnd_file.put_line (fnd_file.log
102: ,'Exception Occurred: '

Line 205: hr_utility.set_location (l_proc

201: l_proc varchar2(100);
202: BEGIN
203: l_proc := 'per_delete_unwanted_sec_prof.show_unwanted_sec_prof';
204:
205: hr_utility.set_location (l_proc
206: ,10);
207:
208: fnd_file.put_line (fnd_file.log
209: ,' Inactive Security Profile Names ');

Line 223: hr_utility.set_location (l_proc

219:
220: FOR csr_security_profile IN c_security_profile LOOP
221: l_valid := 'N';
222:
223: hr_utility.set_location (l_proc
224: ,20);
225:
226: FOR csr_sec_prf_assign IN c_sec_profile_assignments (csr_security_profile.security_profile_id) LOOP
227: OPEN c_responsibility (csr_sec_prf_assign.responsibility_id);

Line 239: hr_utility.set_location (l_proc

235:
236: CLOSE c_responsibility;
237: END LOOP;
238:
239: hr_utility.set_location (l_proc
240: ,30);
241:
242: FOR csr_sec_profile IN c_sec_profile (csr_security_profile.security_profile_id) LOOP
243: OPEN c_responsibility (csr_sec_profile.level_value);

Line 255: hr_utility.set_location (l_proc

251:
252: CLOSE c_responsibility;
253: END LOOP;
254:
255: hr_utility.set_location (l_proc
256: ,40);
257:
258: FOR csr_sec_usr_profile IN c_sec_usr_profile (csr_security_profile.security_profile_id) LOOP
259: OPEN c_user (csr_sec_usr_profile.level_value);

Line 282: hr_utility.set_location (l_proc

278: END IF;
279:
280: CLOSE c_sec_profile_site;
281:
282: hr_utility.set_location (l_proc
283: ,50);
284:
285: FOR csr_mo_profile IN c_mo_profile (csr_security_profile.security_profile_id) LOOP
286: OPEN c_responsibility (csr_mo_profile.level_value);

Line 322: hr_utility.set_location (l_proc

318: l_profile_counter := l_profile_counter + 1;
319: END IF;
320: END LOOP;
321:
322: hr_utility.set_location (l_proc
323: ,60);
324:
325: fnd_file.put_line (fnd_file.log
326: ,'-----------------------------------------------------');

Line 344: hr_utility.set_location (l_proc

340: l_proc varchar2(100);
341: BEGIN
342: l_proc := 'per_delete_unwanted_sec_prof.del_sec_prof';
343:
344: hr_utility.set_location (l_proc
345: ,10);
346:
347: FOR csr_security_profile IN c_security_profile (p_security_profile_id) LOOP
348: hr_utility.set_location (l_proc

Line 348: hr_utility.set_location (l_proc

344: hr_utility.set_location (l_proc
345: ,10);
346:
347: FOR csr_security_profile IN c_security_profile (p_security_profile_id) LOOP
348: hr_utility.set_location (l_proc
349: ,20);
350:
351: IF nvl (csr_security_profile.view_all_flag
352: ,'N') = 'Y' THEN

Line 353: hr_utility.set_message (800

349: ,20);
350:
351: IF nvl (csr_security_profile.view_all_flag
352: ,'N') = 'Y' THEN
353: hr_utility.set_message (800
354: ,'HR_6797_SECURITY_NO_DEL');
355:
356: hr_utility.raise_error;
357: END IF;

Line 356: hr_utility.raise_error;

352: ,'N') = 'Y' THEN
353: hr_utility.set_message (800
354: ,'HR_6797_SECURITY_NO_DEL');
355:
356: hr_utility.raise_error;
357: END IF;
358:
359: IF p_strong_delete <> 'Y' THEN
360: hr_utility.set_location (l_proc

Line 360: hr_utility.set_location (l_proc

356: hr_utility.raise_error;
357: END IF;
358:
359: IF p_strong_delete <> 'Y' THEN
360: hr_utility.set_location (l_proc
361: ,30);
362:
363: per_security_profiles_pkg.pre_delete_validation (csr_security_profile.security_profile_id
364: ,csr_security_profile.view_all_flag

Line 367: hr_utility.set_location (l_proc

363: per_security_profiles_pkg.pre_delete_validation (csr_security_profile.security_profile_id
364: ,csr_security_profile.view_all_flag
365: ,l_secgen_warn);
366:
367: hr_utility.set_location (l_proc
368: ,40);
369:
370: IF l_secgen_warn = 'Y' THEN
371: hr_utility.set_message (800

Line 371: hr_utility.set_message (800

367: hr_utility.set_location (l_proc
368: ,40);
369:
370: IF l_secgen_warn = 'Y' THEN
371: hr_utility.set_message (800
372: ,'HR_SECURITY_IN_USE');
373:
374: hr_utility.raise_error;
375: END IF;

Line 374: hr_utility.raise_error;

370: IF l_secgen_warn = 'Y' THEN
371: hr_utility.set_message (800
372: ,'HR_SECURITY_IN_USE');
373:
374: hr_utility.raise_error;
375: END IF;
376:
377: hr_utility.set_location (l_proc
378: ,100);

Line 377: hr_utility.set_location (l_proc

373:
374: hr_utility.raise_error;
375: END IF;
376:
377: hr_utility.set_location (l_proc
378: ,100);
379:
380: per_security_profiles_pkg.check_assigned_sec_profile (csr_security_profile.security_profile_id);
381: ELSE

Line 382: hr_utility.set_location (l_proc

378: ,100);
379:
380: per_security_profiles_pkg.check_assigned_sec_profile (csr_security_profile.security_profile_id);
381: ELSE
382: hr_utility.set_location (l_proc
383: ,60);
384:
385: strong_delete_sec_prof (p_security_profile_id);
386:

Line 387: hr_utility.set_location (l_proc

383: ,60);
384:
385: strong_delete_sec_prof (p_security_profile_id);
386:
387: hr_utility.set_location (l_proc
388: ,70);
389: END IF;
390:
391: hr_utility.set_location (l_proc

Line 391: hr_utility.set_location (l_proc

387: hr_utility.set_location (l_proc
388: ,70);
389: END IF;
390:
391: hr_utility.set_location (l_proc
392: ,80);
393:
394: per_security_profiles_pkg.delete_row (csr_security_profile.rowid);
395:

Line 396: hr_utility.set_location (l_proc

392: ,80);
393:
394: per_security_profiles_pkg.delete_row (csr_security_profile.rowid);
395:
396: hr_utility.set_location (l_proc
397: ,90);
398: END LOOP;
399:
400: hr_utility.set_location (l_proc

Line 400: hr_utility.set_location (l_proc

396: hr_utility.set_location (l_proc
397: ,90);
398: END LOOP;
399:
400: hr_utility.set_location (l_proc
401: ,90);
402: END del_sec_prof;
403:
404: PROCEDURE strong_delete_sec_prof

Line 411: hr_utility.set_location (l_proc

407: l_proc varchar2(100);
408: BEGIN
409: l_proc := 'per_delete_unwanted_sec_prof.strong_delete_sec_prof';
410:
411: hr_utility.set_location (l_proc
412: ,10);
413:
414: l_security_profile_id := p_security_profile_id;
415:

Line 425: hr_utility.set_location (l_proc

421: WHEN no_data_found THEN
422: NULL;
423: END;
424:
425: hr_utility.set_location (l_proc
426: ,20);
427:
428: BEGIN
429: DELETE

Line 437: hr_utility.set_location (l_proc

433: WHEN no_data_found THEN
434: NULL;
435: END;
436:
437: hr_utility.set_location (l_proc
438: ,30);
439:
440: BEGIN
441: DELETE

Line 449: hr_utility.set_location (l_proc

445: WHEN no_data_found THEN
446: NULL;
447: END;
448:
449: hr_utility.set_location (l_proc
450: ,40);
451:
452: BEGIN
453: DELETE

Line 461: hr_utility.set_location (l_proc

457: WHEN no_data_found THEN
458: NULL;
459: END;
460:
461: hr_utility.set_location (l_proc
462: ,100);
463:
464: BEGIN
465: DELETE

Line 473: hr_utility.set_location (l_proc

469: WHEN no_data_found THEN
470: NULL;
471: END;
472:
473: hr_utility.set_location (l_proc
474: ,60);
475:
476: BEGIN
477: DELETE

Line 485: hr_utility.set_location (l_proc

481: WHEN no_data_found THEN
482: NULL;
483: END;
484:
485: hr_utility.set_location (l_proc
486: ,70);
487:
488: BEGIN
489: DELETE

Line 497: hr_utility.set_location (l_proc

493: WHEN no_data_found THEN
494: NULL;
495: END;
496:
497: hr_utility.set_location (l_proc
498: ,80);
499:
500: BEGIN
501: DELETE

Line 509: hr_utility.set_location (l_proc

505: WHEN no_data_found THEN
506: NULL;
507: END;
508:
509: hr_utility.set_location (l_proc
510: ,90);
511:
512: BEGIN
513: DELETE

Line 521: hr_utility.set_location (l_proc

517: WHEN no_data_found THEN
518: NULL;
519: END;
520:
521: hr_utility.set_location (l_proc
522: ,100);
523:
524: BEGIN
525: DELETE

Line 533: hr_utility.set_location (l_proc

529: WHEN no_data_found THEN
530: NULL;
531: END;
532:
533: hr_utility.set_location (l_proc
534: ,110);
535:
536: BEGIN
537: UPDATE fnd_profile_option_values

Line 551: hr_utility.set_location (l_proc

547: WHEN no_data_found THEN
548: NULL;
549: END;
550:
551: hr_utility.set_location (l_proc
552: ,120);
553: END strong_delete_sec_prof;
554:
555: PROCEDURE del_all_unwanted_sec_prof

Line 653: hr_utility.set_location (l_proc

649: l_proc varchar2(100);
650: BEGIN
651: l_proc := 'per_delete_unwanted_sec_prof.strong_delete_sec_prof';
652:
653: hr_utility.set_location (l_proc
654: ,10);
655:
656: fnd_file.put_line (fnd_file.log
657: ,' Inactive Security Profile Names ');

Line 671: hr_utility.set_location (l_proc

667:
668: FOR csr_security_profile IN c_security_profile LOOP
669: l_valid := 'N';
670:
671: hr_utility.set_location (l_proc
672: ,20);
673:
674: FOR csr_sec_prf_assign IN c_sec_profile_assignments (csr_security_profile.security_profile_id) LOOP
675: OPEN c_responsibility (csr_sec_prf_assign.responsibility_id);

Line 687: hr_utility.set_location (l_proc

683:
684: CLOSE c_responsibility;
685: END LOOP;
686:
687: hr_utility.set_location (l_proc
688: ,30);
689:
690: FOR csr_sec_profile IN c_sec_profile (csr_security_profile.security_profile_id) LOOP
691: OPEN c_responsibility (csr_sec_profile.level_value);

Line 703: hr_utility.set_location (l_proc

699:
700: CLOSE c_responsibility;
701: END LOOP;
702:
703: hr_utility.set_location (l_proc
704: ,40);
705:
706: FOR csr_sec_usr_profile IN c_sec_usr_profile (csr_security_profile.security_profile_id) LOOP
707: OPEN c_user (csr_sec_usr_profile.level_value);

Line 730: hr_utility.set_location (l_proc

726: END IF;
727:
728: CLOSE c_sec_profile_site;
729:
730: hr_utility.set_location (l_proc
731: ,50);
732:
733: FOR csr_mo_profile IN c_mo_profile (csr_security_profile.security_profile_id) LOOP
734: OPEN c_responsibility (csr_mo_profile.level_value);

Line 779: hr_utility.set_location (l_proc

775:
776: fnd_file.put_line (fnd_file.log
777: ,'-------+-------------------------------');
778:
779: hr_utility.set_location (l_proc
780: ,60);
781: END del_all_unwanted_sec_prof;
782:
783: FUNCTION check_unwanted_sec_prof

Line 880: hr_utility.set_location (l_proc

876: l_proc varchar2(100);
877: BEGIN
878: l_proc := 'per_delete_unwanted_sec_prof.check_unwanted_sec_prof';
879:
880: hr_utility.set_location (l_proc
881: ,10);
882:
883: l_valid := 'Y';
884: