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.

[Home] [Help]

APPS.HR_UTIL_MISC_SS dependencies on HR_UTILITY

Line 5: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY HR_UTIL_MISC_SS AS
2: /* $Header: hrutlmss.pkb 120.17.12010000.1 2008/07/28 03:57:24 appldev ship $ */
3:
4: g_package VARCHAR2(30) := 'HR_UTIL_MISC_SS.';
5: g_debug boolean := hr_utility.debug_enabled;
6:
7: PROCEDURE initLoginPrsnCtx(p_eff_date IN DATE) IS
8: l_proc constant varchar2(100) := g_package || ' initLoginPrsnCtx';
9: CURSOR c_bg IS

Line 17: hr_utility.set_location('Entering: '|| l_proc,5);

13: AND ppf.business_group_id = oi.organization_id
14: AND oi.org_information_context = 'Business Group Information'
15: AND g_eff_date between ppf.effective_start_date and ppf.effective_end_date;
16: BEGIN
17: hr_utility.set_location('Entering: '|| l_proc,5);
18: OPEN c_bg;
19: hr_utility.trace('Going into Fetch after ( OPEN c_bg ): '|| l_proc);
20: FETCH c_bg INTO g_loginPrsnBGId, g_loginPrsnCurrencyCode;
21: CLOSE c_bg;

Line 19: hr_utility.trace('Going into Fetch after ( OPEN c_bg ): '|| l_proc);

15: AND g_eff_date between ppf.effective_start_date and ppf.effective_end_date;
16: BEGIN
17: hr_utility.set_location('Entering: '|| l_proc,5);
18: OPEN c_bg;
19: hr_utility.trace('Going into Fetch after ( OPEN c_bg ): '|| l_proc);
20: FETCH c_bg INTO g_loginPrsnBGId, g_loginPrsnCurrencyCode;
21: CLOSE c_bg;
22: g_rate_type := hr_currency_pkg.get_rate_type (
23: p_business_group_id => g_loginPrsnBGId

Line 27: hr_utility.set_location('Leaving: '|| l_proc,15);

23: p_business_group_id => g_loginPrsnBGId
24: ,p_conversion_date => p_eff_date
25: ,p_processing_type => 'R');
26:
27: hr_utility.set_location('Leaving: '|| l_proc,15);
28: END initLoginPrsnCtx;
29:
30: /*
31: Currency conversion function to return converted amount as a number.

Line 262: hr_utility.set_location('Entering: '|| l_proc, 5);

258: l_asg_security VARCHAR2(10) := hr_general2.supervisor_assignments_in_use;
259: BEGIN
260:
261: IF g_debug then
262: hr_utility.set_location('Entering: '|| l_proc, 5);
263: END IF;
264:
265: IF (l_asg_security = 'TRUE' AND p_person_id <> '-1' ) THEN
266: l_status := check_term_access(

Line 276: hr_utility.trace('In ( IF (l_status = T AND p_person_id <> -1 ) ): '|| l_proc);

272: END IF;
273:
274:
275: IF (l_status = 'T' AND p_person_id <> '-1' ) THEN
276: hr_utility.trace('In ( IF (l_status = T AND p_person_id <> -1 ) ): '|| l_proc);
277: IF g_debug then
278: hr_utility.set_location('Entering: '|| 'fnd_data_security.check_function', 10);
279: END IF;
280:

Line 278: hr_utility.set_location('Entering: '|| 'fnd_data_security.check_function', 10);

274:
275: IF (l_status = 'T' AND p_person_id <> '-1' ) THEN
276: hr_utility.trace('In ( IF (l_status = T AND p_person_id <> -1 ) ): '|| l_proc);
277: IF g_debug then
278: hr_utility.set_location('Entering: '|| 'fnd_data_security.check_function', 10);
279: END IF;
280:
281: l_status := fnd_data_security.check_function(
282: p_api_version => p_api_version

Line 288: hr_utility.trace('Error in fnd_data_security.check_function l_status is: '||l_status||'. Error is: '|| replace(fnd_message.get_encoded(), chr(0), ' '));

284: ,p_object_name => p_object_name
285: ,p_instance_pk1_value => p_person_id
286: ,p_instance_pk2_value => p_instance_pk2_value);
287: IF l_status = 'E' OR l_status = 'U' THEN
288: hr_utility.trace('Error in fnd_data_security.check_function l_status is: '||l_status||'. Error is: '|| replace(fnd_message.get_encoded(), chr(0), ' '));
289: l_status := 'F';
290: END IF;
291:
292: IF g_debug then

Line 293: hr_utility.set_location('Leaving: '|| 'fnd_data_security.check_function', 15);

289: l_status := 'F';
290: END IF;
291:
292: IF g_debug then
293: hr_utility.set_location('Leaving: '|| 'fnd_data_security.check_function', 15);
294: END IF;
295: END IF;
296:
297: IF (l_status = 'T' AND p_person_id <> '-1' ) THEN

Line 305: hr_utility.set_location('Leaving: '||l_proc, 20);

301: p_eff_date => p_eff_date);
302: END IF;
303:
304: IF g_debug then
305: hr_utility.set_location('Leaving: '||l_proc, 20);
306: END IF;
307:
308: RETURN l_status;
309: END validate_selected_function;

Line 360: hr_utility.set_location('Entering: '|| l_proc,5);

356: l_smarker INTEGER;
357: l_emarker INTEGER;
358: l_proc constant varchar2(100) := g_package || ' get_parameter_value';
359: BEGIN
360: hr_utility.set_location('Entering: '|| l_proc,5);
361: l_smarker := instr(p_parameter_list, p_parameter);
362:
363: if (l_smarker = 0) THEN
364: hr_utility.set_location('Leaving: '|| l_proc,10);

Line 364: hr_utility.set_location('Leaving: '|| l_proc,10);

360: hr_utility.set_location('Entering: '|| l_proc,5);
361: l_smarker := instr(p_parameter_list, p_parameter);
362:
363: if (l_smarker = 0) THEN
364: hr_utility.set_location('Leaving: '|| l_proc,10);
365: RETURN NULL;
366:
367: END IF;
368:

Line 375: hr_utility.set_location('Leaving: '|| l_proc,15);

371:
372: IF (l_emarker <= 0) THEN
373: l_emarker := LENGTH(p_parameter_list)+1;
374: END IF;
375: hr_utility.set_location('Leaving: '|| l_proc,15);
376:
377: RETURN SUBSTR(p_parameter_list, l_smarker, l_emarker - l_smarker);
378: EXCEPTION
379: WHEN OTHERS THEN

Line 380: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

376:
377: RETURN SUBSTR(p_parameter_list, l_smarker, l_emarker - l_smarker);
378: EXCEPTION
379: WHEN OTHERS THEN
380: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
381: RETURN NULL;
382: END get_parameter_value;
383:
384:

Line 445: hr_utility.set_location('Entering: '|| l_proc, 5);

441:
442: l_func_details csr_fnd_func_details%ROWTYPE;
443: BEGIN
444: IF g_debug then
445: hr_utility.set_location('Entering: '|| l_proc, 5);
446: END IF;
447:
448: OPEN csr_fnd_func_details (p_function);
449: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_func_details (p_function)): '|| l_proc);

Line 449: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_func_details (p_function)): '|| l_proc);

445: hr_utility.set_location('Entering: '|| l_proc, 5);
446: END IF;
447:
448: OPEN csr_fnd_func_details (p_function);
449: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_func_details (p_function)): '|| l_proc);
450: FETCH csr_fnd_func_details INTO l_func_details;
451: CLOSE csr_fnd_func_details;
452: -- Overriding p_function value depending on pCalledFrom value
453: l_function_name := nvl(get_parameter_value(l_func_details.parameters,

Line 458: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_func_details (l_function_name)): '|| l_proc);

454: 'pCalledFrom'),p_function);
455:
456: IF l_function_name <> p_function THEN
457: OPEN csr_fnd_func_details (l_function_name);
458: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_func_details (l_function_name)): '|| l_proc);
459: FETCH csr_fnd_func_details INTO l_func_details;
460: CLOSE csr_fnd_func_details;
461: END IF;
462:

Line 465: hr_utility.trace('In( IF (INSTR(l_func_details.parameters, pProcessName) <> 0)): '|| l_proc);

461: END IF;
462:
463: -- Checks whether this function is workflow based
464: IF (INSTR(l_func_details.parameters, 'pProcessName') <> 0) THEN
465: hr_utility.trace('In( IF (INSTR(l_func_details.parameters, pProcessName) <> 0)): '|| l_proc);
466: l_temp := get_parameter_value(l_func_details.parameters,
467: 'pProcessName');
468:
469: IF (l_temp is not null) THEN

Line 470: hr_utility.trace('In( IF (l_temp is not null)): '|| l_proc);

466: l_temp := get_parameter_value(l_func_details.parameters,
467: 'pProcessName');
468:
469: IF (l_temp is not null) THEN
470: hr_utility.trace('In( IF (l_temp is not null)): '|| l_proc);
471: l_item_type := get_parameter_value(l_func_details.parameters,
472: 'pItemType');
473: OPEN csr_wf_process (l_temp, l_item_type);
474: hr_utility.trace('Going into Fetch after( OPEN csr_wf_process (l_temp, l_item_type))): '|| l_proc);

Line 474: hr_utility.trace('Going into Fetch after( OPEN csr_wf_process (l_temp, l_item_type))): '|| l_proc);

470: hr_utility.trace('In( IF (l_temp is not null)): '|| l_proc);
471: l_item_type := get_parameter_value(l_func_details.parameters,
472: 'pItemType');
473: OPEN csr_wf_process (l_temp, l_item_type);
474: hr_utility.trace('Going into Fetch after( OPEN csr_wf_process (l_temp, l_item_type))): '|| l_proc);
475: FETCH csr_wf_process INTO l_status;
476: IF csr_wf_process%NOTFOUND THEN
477: l_status := 'T';
478: ELSE

Line 485: hr_utility.trace('In else of (IF (INSTR(l_func_details.parameters, pProcessName) <> 0)): '|| l_proc);

481: CLOSE csr_wf_process;
482:
483: END IF;
484: ELSE
485: hr_utility.trace('In else of (IF (INSTR(l_func_details.parameters, pProcessName) <> 0)): '|| l_proc);
486: l_status := 'T';
487: END IF;
488:
489: IF g_debug then

Line 490: hr_utility.set_location('Leaving: '||l_proc, 30);

486: l_status := 'T';
487: END IF;
488:
489: IF g_debug then
490: hr_utility.set_location('Leaving: '||l_proc, 30);
491: END IF;
492:
493: RETURN l_status; -- if status is N then it is no term access
494:

Line 497: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

493: RETURN l_status; -- if status is N then it is no term access
494:
495: EXCEPTION
496: WHEN OTHERS THEN
497: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
498: RETURN 'N';
499: END check_term_access;
500:
501: /**

Line 526: hr_utility.set_location('Entering: '|| l_proc, 5);

522:
523: l_proc varchar2(72) := g_package||'check_primary_access';
524: BEGIN
525: IF g_debug then
526: hr_utility.set_location('Entering: '|| l_proc, 5);
527: END IF;
528:
529: OPEN fetch_asg (p_selected_person_id, p_effective_date);
530: hr_utility.trace('Going into Fetch after (OPEN fetch_asg (p_selected_person_id, p_effective_date) ): '|| l_proc);

Line 530: hr_utility.trace('Going into Fetch after (OPEN fetch_asg (p_selected_person_id, p_effective_date) ): '|| l_proc);

526: hr_utility.set_location('Entering: '|| l_proc, 5);
527: END IF;
528:
529: OPEN fetch_asg (p_selected_person_id, p_effective_date);
530: hr_utility.trace('Going into Fetch after (OPEN fetch_asg (p_selected_person_id, p_effective_date) ): '|| l_proc);
531: FETCH fetch_asg INTO l_status;
532:
533: IF fetch_asg%NOTFOUND THEN
534: l_status := 'N';

Line 540: hr_utility.set_location('Leaving: '||l_proc, 10);

536:
537: CLOSE fetch_asg;
538:
539: IF g_debug then
540: hr_utility.set_location('Leaving: '||l_proc, 10);
541: END IF;
542:
543: RETURN l_status;
544:

Line 587: hr_utility.set_location('Entering: '|| l_proc,5);

583: 'HR_LOA_SUMMARY_TOP_SS'
584: );
585:
586: BEGIN
587: hr_utility.set_location('Entering: '|| l_proc,5);
588: OPEN csr_akregion_list;
589: hr_utility.trace('Going into Fetch after ( OPEN csr_akregion_list ): '|| l_proc);
590: FETCH csr_akregion_list INTO l_status;
591: IF csr_akregion_list%NOTFOUND

Line 589: hr_utility.trace('Going into Fetch after ( OPEN csr_akregion_list ): '|| l_proc);

585:
586: BEGIN
587: hr_utility.set_location('Entering: '|| l_proc,5);
588: OPEN csr_akregion_list;
589: hr_utility.trace('Going into Fetch after ( OPEN csr_akregion_list ): '|| l_proc);
590: FETCH csr_akregion_list INTO l_status;
591: IF csr_akregion_list%NOTFOUND
592: THEN
593: l_status := 'T';

Line 598: hr_utility.set_location('Leaving: '|| l_proc,15);

594: END IF;
595: CLOSE csr_akregion_list;
596:
597: RETURN l_status;
598: hr_utility.set_location('Leaving: '|| l_proc,15);
599: END check_akregion_code;
600:
601: /**
602: * Checks for the CWK access of the function returns a C or T

Line 654: hr_utility.set_location('Entering: '|| l_proc, 5);

650:
651: l_func_details csr_fnd_func_details%ROWTYPE;
652: BEGIN
653: IF g_debug then
654: hr_utility.set_location('Entering: '|| l_proc, 5);
655: END IF;
656:
657: OPEN csr_per_npw_flag;
658: hr_utility.trace('Going into Fetch after (OPEN csr_per_npw_flag ): '|| l_proc);

Line 658: hr_utility.trace('Going into Fetch after (OPEN csr_per_npw_flag ): '|| l_proc);

654: hr_utility.set_location('Entering: '|| l_proc, 5);
655: END IF;
656:
657: OPEN csr_per_npw_flag;
658: hr_utility.trace('Going into Fetch after (OPEN csr_per_npw_flag ): '|| l_proc);
659: FETCH csr_per_npw_flag INTO l_npw_status;
660: IF csr_per_npw_flag%NOTFOUND THEN
661: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
662: hr_utility.raise_error;

Line 661: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');

657: OPEN csr_per_npw_flag;
658: hr_utility.trace('Going into Fetch after (OPEN csr_per_npw_flag ): '|| l_proc);
659: FETCH csr_per_npw_flag INTO l_npw_status;
660: IF csr_per_npw_flag%NOTFOUND THEN
661: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
662: hr_utility.raise_error;
663: END IF;
664: CLOSE csr_per_npw_flag;
665: IF (l_npw_status <> 'Y') THEN

Line 662: hr_utility.raise_error;

658: hr_utility.trace('Going into Fetch after (OPEN csr_per_npw_flag ): '|| l_proc);
659: FETCH csr_per_npw_flag INTO l_npw_status;
660: IF csr_per_npw_flag%NOTFOUND THEN
661: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
662: hr_utility.raise_error;
663: END IF;
664: CLOSE csr_per_npw_flag;
665: IF (l_npw_status <> 'Y') THEN
666: hr_utility.set_location('Leaving: '|| l_proc,15);

Line 666: hr_utility.set_location('Leaving: '|| l_proc,15);

662: hr_utility.raise_error;
663: END IF;
664: CLOSE csr_per_npw_flag;
665: IF (l_npw_status <> 'Y') THEN
666: hr_utility.set_location('Leaving: '|| l_proc,15);
667: RETURN 'T';
668: END IF;
669:
670: OPEN csr_fnd_func_details (p_function);

Line 671: hr_utility.trace('Going into Fetch after ( OPEN csr_fnd_func_details (p_function)): '|| l_proc);

667: RETURN 'T';
668: END IF;
669:
670: OPEN csr_fnd_func_details (p_function);
671: hr_utility.trace('Going into Fetch after ( OPEN csr_fnd_func_details (p_function)): '|| l_proc);
672: FETCH csr_fnd_func_details INTO l_func_details;
673: CLOSE csr_fnd_func_details;
674: -- Overriding p_function value depending on pCalledFrom value
675: l_function_name := nvl(get_parameter_value(l_func_details.parameters,

Line 679: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_func_details (l_function_name)): '|| l_proc);

675: l_function_name := nvl(get_parameter_value(l_func_details.parameters,
676: 'pCalledFrom'),p_function);
677: IF l_function_name <> p_function THEN
678: OPEN csr_fnd_func_details (l_function_name);
679: hr_utility.trace('Going into Fetch after (OPEN csr_fnd_func_details (l_function_name)): '|| l_proc);
680: FETCH csr_fnd_func_details INTO l_func_details;
681: CLOSE csr_fnd_func_details;
682: END IF;
683:

Line 686: hr_utility.trace('In( IF (INSTR(l_func_details.parameters, pProcessName) <> 0) '|| l_proc);

682: END IF;
683:
684: -- Checks whether this function is workflow based
685: IF (INSTR(l_func_details.parameters, 'pProcessName') <> 0) THEN
686: hr_utility.trace('In( IF (INSTR(l_func_details.parameters, pProcessName) <> 0) '|| l_proc);
687: l_temp := get_parameter_value(l_func_details.parameters,
688: 'pProcessName');
689: IF (l_temp is not null) THEN
690: l_item_type := get_parameter_value(l_func_details.parameters,

Line 693: hr_utility.trace('Going into Fetch after (OPEN csr_wf_process (l_temp, l_item_type)): '|| l_proc);

689: IF (l_temp is not null) THEN
690: l_item_type := get_parameter_value(l_func_details.parameters,
691: 'pItemType');
692: OPEN csr_wf_process (l_temp, l_item_type);
693: hr_utility.trace('Going into Fetch after (OPEN csr_wf_process (l_temp, l_item_type)): '|| l_proc);
694: FETCH csr_wf_process INTO l_status;
695: IF csr_wf_process%NOTFOUND THEN
696: l_status := 'T';
697: END IF;

Line 703: hr_utility.trace('In else of ( IF (INSTR(l_func_details.parameters, pProcessName) <> 0) '|| l_proc);

699:
700: END IF;
701:
702: ELSE
703: hr_utility.trace('In else of ( IF (INSTR(l_func_details.parameters, pProcessName) <> 0) '|| l_proc);
704:
705: l_temp := nvl(get_parameter_value(l_func_details.web_html_call,
706: 'akRegionCode'),
707: get_parameter_value(l_func_details.web_html_call,

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

710: l_status := check_akregion_code(l_temp);
711: END IF;
712:
713: IF g_debug then
714: hr_utility.set_location('Leaving: '||l_proc, 40);
715: END IF;
716:
717: RETURN l_status;
718: EXCEPTION

Line 721: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

717: RETURN l_status;
718: EXCEPTION
719: WHEN OTHERS THEN
720:
721: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
722: RETURN 'C';
723: END check_cwk_access;
724:
725: PROCEDURE clear_cache

Line 730: hr_utility.set_location('Entering: '|| l_proc,5);

726: IS
727: --local variable
728: l_proc constant varchar2(100) := g_package || ' clear_cache';
729: BEGIN
730: hr_utility.set_location('Entering: '|| l_proc,5);
731: g_entity_list.delete;
732: -- g_entitydetail_list.delete;
733: hr_utility.set_location('Leaving: '|| l_proc,10);
734: END clear_cache;

Line 733: hr_utility.set_location('Leaving: '|| l_proc,10);

729: BEGIN
730: hr_utility.set_location('Entering: '|| l_proc,5);
731: g_entity_list.delete;
732: -- g_entitydetail_list.delete;
733: hr_utility.set_location('Leaving: '|| l_proc,10);
734: END clear_cache;
735:
736: FUNCTION entity_exists (
737: p_entity_id IN NUMBER

Line 744: hr_utility.set_location('Entering: '|| l_proc,5);

740: IS
741: --local variable
742: l_proc constant varchar2(100) := g_package || ' entity_exists';
743: BEGIN
744: hr_utility.set_location('Entering: '|| l_proc,5);
745: IF g_entity_list.exists(p_entity_id) THEN
746: hr_utility.set_location('Leaving: '|| l_proc,10);
747: RETURN 'T';
748: END IF;

Line 746: hr_utility.set_location('Leaving: '|| l_proc,10);

742: l_proc constant varchar2(100) := g_package || ' entity_exists';
743: BEGIN
744: hr_utility.set_location('Entering: '|| l_proc,5);
745: IF g_entity_list.exists(p_entity_id) THEN
746: hr_utility.set_location('Leaving: '|| l_proc,10);
747: RETURN 'T';
748: END IF;
749: hr_utility.set_location('Leaving: '|| l_proc,15);
750: RETURN 'F';

Line 749: hr_utility.set_location('Leaving: '|| l_proc,15);

745: IF g_entity_list.exists(p_entity_id) THEN
746: hr_utility.set_location('Leaving: '|| l_proc,10);
747: RETURN 'T';
748: END IF;
749: hr_utility.set_location('Leaving: '|| l_proc,15);
750: RETURN 'F';
751: EXCEPTION
752: WHEN others THEN
753: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

Line 753: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

749: hr_utility.set_location('Leaving: '|| l_proc,15);
750: RETURN 'F';
751: EXCEPTION
752: WHEN others THEN
753: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
754: RETURN 'F';
755: END entity_exists;
756:
757: PROCEDURE populate_entity_list (

Line 765: hr_utility.set_location('Entering: '|| l_proc,5);

761: IS
762: --local variable
763: l_proc constant varchar2(100) := g_package || ' populate_entity_list';
764: BEGIN
765: hr_utility.set_location('Entering: '|| l_proc,5);
766: if p_retain_cache = 'N'
767: then
768: clear_cache();
769: end if;

Line 773: hr_utility.set_location('Leaving: '|| l_proc,10);

769: end if;
770: FOR I IN 1 ..p_elist.count LOOP
771: g_entity_list(p_elist(i)) := p_elist(i);
772: END LOOP;
773: hr_utility.set_location('Leaving: '|| l_proc,10);
774: END populate_entity_list;
775:
776: PROCEDURE check_ota_installed (appl_id number, status out nocopy varchar2) is
777: l_status VARCHAR2(1);

Line 783: hr_utility.set_location('Entering: '|| l_proc,5);

779: l_flag boolean;
780: --local variable
781: l_proc constant varchar2(100) := g_package || ' check_ota_installed';
782: begin
783: hr_utility.set_location('Entering: '|| l_proc,5);
784: l_flag := fnd_installation.get(appl_id => appl_id,
785: dep_appl_id => appl_id,
786: status => l_status,
787: industry => l_industry );

Line 794: hr_utility.set_location('Leaving: '|| l_proc,10);

790: status := 'Y';
791: else
792: status := 'N';
793: end if;
794: hr_utility.set_location('Leaving: '|| l_proc,10);
795: end check_ota_installed;
796:
797: FUNCTION get_employee_salary(
798: p_assignment_id IN NUMBER

Line 837: hr_utility.set_location('Entering: '|| l_proc,5);

833: l_text_value wf_activity_attr_values.text_value%type;
834: --local variable
835: l_proc constant varchar2(100) := g_package || ' is_employee_check';
836: BEGIN
837: hr_utility.set_location('Entering: '|| l_proc,5);
838: --
839: l_text_value := wf_engine.GetItemAttrText (
840: itemtype => itemtype,
841: itemkey => itemkey,

Line 850: hr_utility.set_location('Leaving: '|| l_proc,10);

846: else
847: resultout := 'COMPLETE:'|| 'Y';
848: end if;
849: --
850: hr_utility.set_location('Leaving: '|| l_proc,10);
851: EXCEPTION
852: WHEN OTHERS THEN
853:
854: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

Line 854: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

850: hr_utility.set_location('Leaving: '|| l_proc,10);
851: EXCEPTION
852: WHEN OTHERS THEN
853:
854: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
855: WF_CORE.CONTEXT (
856: g_package,
857: 'branch_on_approval_flag',
858: itemtype,

Line 872: hr_utility.set_location('Entering: '|| l_proc,5);

868: IS
869: --local variable
870: l_proc constant varchar2(100) := g_package || ' populateInterimPersonList';
871: BEGIN
872: hr_utility.set_location('Entering: '|| l_proc,5);
873: -- This commit is issued here to remove the Data from the Temp table.
874: -- This can be replaced by truncate.
875: --COMMIT;
876: DELETE PER_INTERIM_PERSON_LIST;

Line 881: hr_utility.set_location('Leaving: '|| l_proc,10);

877: FOR i in 1.. person_data.count LOOP
878: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
879: values (person_data(i).person_id, person_data(i).assignment_id, person_data(i).in_my_list);
880: END LOOP;
881: hr_utility.set_location('Leaving: '|| l_proc,10);
882: EXCEPTION
883: WHEN others THEN
884: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
885: RAISE;

Line 884: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

880: END LOOP;
881: hr_utility.set_location('Leaving: '|| l_proc,10);
882: EXCEPTION
883: WHEN others THEN
884: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
885: RAISE;
886: END populateInterimPersonList;
887:
888: PROCEDURE populateInterimListFromMyList (

Line 895: hr_utility.set_location('Entering: '|| l_proc,5);

891: IS
892: --local variable
893: l_proc constant varchar2(100) := g_package || ' populateInterimListFromMyList';
894: BEGIN
895: hr_utility.set_location('Entering: '|| l_proc,5);
896: --COMMIT;
897: DELETE PER_INTERIM_PERSON_LIST;
898: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
899: SELECT selected_person_id, selected_assignment_id, 'Y'

Line 902: hr_utility.set_location('Leaving: '|| l_proc,10);

898: INSERT INTO PER_INTERIM_PERSON_LIST (person_id, assignment_id, in_my_list)
899: SELECT selected_person_id, selected_assignment_id, 'Y'
900: FROM hr_working_person_lists
901: WHERE owning_person_id = person_id;
902: hr_utility.set_location('Leaving: '|| l_proc,10);
903: EXCEPTION
904: WHEN others THEN
905: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
906: RAISE;

Line 905: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

901: WHERE owning_person_id = person_id;
902: hr_utility.set_location('Leaving: '|| l_proc,10);
903: EXCEPTION
904: WHEN others THEN
905: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
906: RAISE;
907: END populateInterimListFromMyList;
908:
909: PROCEDURE addToMyListFromInterimList (

Line 916: hr_utility.set_location('Entering: '|| l_proc,5);

912: IS
913: --local variable
914: l_proc constant varchar2(100) := g_package || ' addToMyListFromInterimList';
915: BEGIN
916: hr_utility.set_location('Entering: '|| l_proc,5);
917: INSERT INTO HR_WORKING_PERSON_LISTS(working_person_list_id, owning_person_id,
918: selected_person_id, current_selection, multiple_selection, selected_assignment_id)
919: SELECT HR_WORKING_PERSON_LISTS_s.NEXTVAL,
920: prsn_id,

Line 926: hr_utility.set_location('Leaving: '|| l_proc,10);

922: NULL,
923: NULL,
924: list.assignment_id
925: FROM PER_INTERIM_PERSON_LIST list;
926: hr_utility.set_location('Leaving: '|| l_proc,10);
927: EXCEPTION
928: WHEN others THEN
929: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
930: RAISE;

Line 929: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

925: FROM PER_INTERIM_PERSON_LIST list;
926: hr_utility.set_location('Leaving: '|| l_proc,10);
927: EXCEPTION
928: WHEN others THEN
929: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
930: RAISE;
931: END addToMyListFromInterimList;
932:
933: PROCEDURE setEffectiveDate

Line 942: hr_utility.set_location('Entering: '|| l_proc,5);

938: --
939: --local variable
940: l_proc constant varchar2(100) := g_package || ' setEffectiveDate';
941: BEGIN
942: hr_utility.set_location('Entering: '|| l_proc,5);
943: --
944: g_eff_date := trunc(p_effective_date);
945: --bug 5765957 start
946: begin

Line 950: hr_utility.set_location('change for DUP_VAL_ON_INDEX : ' || l_proc ,999);

946: begin
947: dt_fndate.set_effective_date(g_eff_date);
948: exception
949: when DUP_VAL_ON_INDEX then
950: hr_utility.set_location('change for DUP_VAL_ON_INDEX : ' || l_proc ,999);
951: when others then
952: hr_utility.set_location('change for others : ' || l_proc ,998);
953: end;
954: --bug 5765957 end

Line 952: hr_utility.set_location('change for others : ' || l_proc ,998);

948: exception
949: when DUP_VAL_ON_INDEX then
950: hr_utility.set_location('change for DUP_VAL_ON_INDEX : ' || l_proc ,999);
951: when others then
952: hr_utility.set_location('change for others : ' || l_proc ,998);
953: end;
954: --bug 5765957 end
955: initLoginPrsnCtx(g_eff_date);
956: g_year_start := to_date('01/01/'||to_char(g_eff_date,'RRRR'),'DD/MM/RRRR');

Line 960: hr_utility.set_location('Leaving: '|| l_proc,10);

956: g_year_start := to_date('01/01/'||to_char(g_eff_date,'RRRR'),'DD/MM/RRRR');
957: --
958: commit;
959: --
960: hr_utility.set_location('Leaving: '|| l_proc,10);
961: EXCEPTION
962: WHEN others THEN
963: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
964: rollback;

Line 963: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

959: --
960: hr_utility.set_location('Leaving: '|| l_proc,10);
961: EXCEPTION
962: WHEN others THEN
963: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
964: rollback;
965: raise;
966: END setEffectiveDate;
967:

Line 979: hr_utility.set_location('Entering: '|| l_proc,5);

975: IS
976: --local variable
977: l_proc constant varchar2(100) := g_package || ' getObjectName';
978: BEGIN
979: hr_utility.set_location('Entering: '|| l_proc,5);
980: IF PER_WORK_STRUCTURE_OVERRIDE_SS.isOverrideEnabled(p_object) THEN
981: return nvl(PER_WORK_STRUCTURE_OVERRIDE_SS.getObjectName(p_object
982: , p_object_id, p_bg_id, p_value) ,p_value);
983: END IF;

Line 984: hr_utility.set_location('Leaving: '|| l_proc,10);

980: IF PER_WORK_STRUCTURE_OVERRIDE_SS.isOverrideEnabled(p_object) THEN
981: return nvl(PER_WORK_STRUCTURE_OVERRIDE_SS.getObjectName(p_object
982: , p_object_id, p_bg_id, p_value) ,p_value);
983: END IF;
984: hr_utility.set_location('Leaving: '|| l_proc,10);
985: return p_value;
986: END getObjectName;
987:
988: PROCEDURE initialize_am IS

Line 995: g_debug := hr_utility.debug_enabled;

991:
992: -- If g_debug is only set at package level
993: -- logging will not work consistently
994: --
995: g_debug := hr_utility.debug_enabled;
996:
997: IF g_debug then
998: hr_utility.set_location('Entering: '|| l_proc, 5);
999: END IF;

Line 998: hr_utility.set_location('Entering: '|| l_proc, 5);

994: --
995: g_debug := hr_utility.debug_enabled;
996:
997: IF g_debug then
998: hr_utility.set_location('Entering: '|| l_proc, 5);
999: END IF;
1000:
1001:
1002: -- 3952978

Line 1087: hr_utility.set_location('Entering: '|| l_proc,5);

1083: IS
1084: --local variable
1085: l_proc constant varchar2(100) := g_package || ' populateInterimEntityList';
1086: BEGIN
1087: hr_utility.set_location('Entering: '|| l_proc,5);
1088: if p_retain_cache = 'N'
1089: then
1090: DELETE PER_INTERIM_ENTITY_LIST;
1091: end if;

Line 1096: hr_utility.set_location('Leaving: '|| l_proc,10);

1092: FOR i in 1.. entity_data.count LOOP
1093: INSERT INTO PER_INTERIM_ENTITY_LIST (entity_name,state,pk1,pk2,pk3,pk4,pk5)
1094: values (entity_data(i).entity_name, entity_data(i).state,entity_data(i).pk1,entity_data(i).pk2,entity_data(i).pk3,entity_data(i).pk4,entity_data(i).pk5);
1095: END LOOP;
1096: hr_utility.set_location('Leaving: '|| l_proc,10);
1097: EXCEPTION
1098: WHEN others THEN
1099: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1100: RAISE;

Line 1099: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1095: END LOOP;
1096: hr_utility.set_location('Leaving: '|| l_proc,10);
1097: EXCEPTION
1098: WHEN others THEN
1099: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1100: RAISE;
1101: END populateInterimEntityList;
1102:
1103: PROCEDURE clearInterimEntityList

Line 1107: hr_utility.set_location('Entering: '|| l_proc,5);

1103: PROCEDURE clearInterimEntityList
1104: IS
1105: l_proc constant varchar2(100) := g_package || 'clearInterimEntityList';
1106: BEGIN
1107: hr_utility.set_location('Entering: '|| l_proc,5);
1108: DELETE PER_INTERIM_ENTITY_LIST;
1109: END clearInterimEntityList;
1110:
1111: procedure isPersonTerminated (

Line 1121: hr_utility.set_location('Entering: '|| l_proc,5);

1117: l_proc constant varchar2(100) := g_package || ' isPersonTerminated';
1118: assi_id varchar2(200) := null ;
1119:
1120: begin
1121: hr_utility.set_location('Entering: '|| l_proc,5);
1122:
1123: select assignment_id
1124: into assi_id
1125: from per_people_f ppf, per_assignments_f paf

Line 1145: hr_utility.set_location('EXCEPTION: '|| l_proc,555);

1141: when no_data_found then
1142: result := 'FALSE';
1143: null;
1144: WHEN others THEN
1145: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1146: result := 'TRUE';
1147: END isPersonTerminated;
1148:
1149: procedure getDeploymentPersonID (person_id in number, result out nocopy number )