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.HXC_PREFERENCE_EVALUATION dependencies on HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: hxcpfevl.pkb 120.20 2011/08/10 10:23:15 asrajago ship $ */
3:
4: g_migration_mode BOOLEAN := FALSE;
5: g_package VARCHAR2 (72) := 'hxc_preference_evaluation';
6: g_debug boolean := hr_utility.debug_enabled;
7:
8: -- will use PL/SQL tables in various places to manipulate preference information
9:
10: TYPE t_str_version_row IS RECORD

Line 400: g_debug := hr_utility.debug_enabled;

396: -- persistent resp evalution based on the FND_global.resp_id
397: --2) p_resp_id = -101 we dont have to do preference evalution on persistent responsibility
398: --
399:
400: g_debug := hr_utility.debug_enabled;
401:
402: IF g_debug
403: THEN
404: hr_utility.trace('Evaluation pref for p_evaluation_date ');

Line 404: hr_utility.trace('Evaluation pref for p_evaluation_date ');

400: g_debug := hr_utility.debug_enabled;
401:
402: IF g_debug
403: THEN
404: hr_utility.trace('Evaluation pref for p_evaluation_date ');
405: hr_utility.trace('p_resource_id '||p_resource_id);
406: hr_utility.trace('p_evaluation_date '||p_evaluation_date);
407: END IF;
408:

Line 405: hr_utility.trace('p_resource_id '||p_resource_id);

401:
402: IF g_debug
403: THEN
404: hr_utility.trace('Evaluation pref for p_evaluation_date ');
405: hr_utility.trace('p_resource_id '||p_resource_id);
406: hr_utility.trace('p_evaluation_date '||p_evaluation_date);
407: END IF;
408:
409: l_resp_id := p_resp_id;

Line 406: hr_utility.trace('p_evaluation_date '||p_evaluation_date);

402: IF g_debug
403: THEN
404: hr_utility.trace('Evaluation pref for p_evaluation_date ');
405: hr_utility.trace('p_resource_id '||p_resource_id);
406: hr_utility.trace('p_evaluation_date '||p_evaluation_date);
407: END IF;
408:
409: l_resp_id := p_resp_id;
410: l_user_id := p_user_id;

Line 443: hr_utility.trace('Current user''s user_id is '||fnd_global.user_id);

439:
440:
441: IF g_debug
442: THEN
443: hr_utility.trace('Current user''s user_id is '||fnd_global.user_id);
444: hr_utility.trace('Current user''s person_id is '||l_employee_id);
445: END IF;
446:
447: -- make sure pref table is empty - otherwise this will interfere with the evaluation

Line 444: hr_utility.trace('Current user''s person_id is '||l_employee_id);

440:
441: IF g_debug
442: THEN
443: hr_utility.trace('Current user''s user_id is '||fnd_global.user_id);
444: hr_utility.trace('Current user''s person_id is '||l_employee_id);
445: END IF;
446:
447: -- make sure pref table is empty - otherwise this will interfere with the evaluation
448: p_pref_table.delete;

Line 483: HR_UTILITY.trace(g_package || ' cwk_final_process_date ' || cwk_final_process_date);

479: l_num_of_days_to_add := NVL(fnd_profile.value('HXC_CWK_TK_FPD'),0);
480:
481: if g_debug then
482:
483: HR_UTILITY.trace(g_package || ' cwk_final_process_date ' || cwk_final_process_date);
484: HR_UTILITY.trace(g_package || 'l_num_of_days_to_add ' || l_num_of_days_to_add);
485:
486: end if;
487: --End of Addition By Mithun for CWK Terminate Bug

Line 484: HR_UTILITY.trace(g_package || 'l_num_of_days_to_add ' || l_num_of_days_to_add);

480:
481: if g_debug then
482:
483: HR_UTILITY.trace(g_package || ' cwk_final_process_date ' || cwk_final_process_date);
484: HR_UTILITY.trace(g_package || 'l_num_of_days_to_add ' || l_num_of_days_to_add);
485:
486: end if;
487: --End of Addition By Mithun for CWK Terminate Bug
488:

Line 518: hr_utility.set_message(809, 'HXC_NO_HIER_FOR_DATE');

514: -- Issue 6
515: IF(l_hierarchy_list.count = 0)
516: then
517: IF( g_raise_fatal_errors = TRUE) THEN
518: hr_utility.set_message(809, 'HXC_NO_HIER_FOR_DATE');
519: hr_utility.raise_error;
520: ELSE
521: g_fatal_error_occurred := TRUE;
522: g_fatal_error := 'HXC_NO_HIER_FOR_DATE';

Line 519: hr_utility.raise_error;

515: IF(l_hierarchy_list.count = 0)
516: then
517: IF( g_raise_fatal_errors = TRUE) THEN
518: hr_utility.set_message(809, 'HXC_NO_HIER_FOR_DATE');
519: hr_utility.raise_error;
520: ELSE
521: g_fatal_error_occurred := TRUE;
522: g_fatal_error := 'HXC_NO_HIER_FOR_DATE';
523: RETURN;

Line 642: hr_utility.set_message(809, 'HXC_NO_HIER_FOR_DATE');

638: -- Issue 6
639: /*IF(l_hierarchy_list.count = 0)
640: then
641: IF( g_raise_fatal_errors = TRUE) THEN
642: hr_utility.set_message(809, 'HXC_NO_HIER_FOR_DATE');
643: hr_utility.raise_error;
644: ELSE
645: g_fatal_error_occurred := TRUE;
646: g_fatal_error := 'HXC_NO_HIER_FOR_DATE';

Line 643: hr_utility.raise_error;

639: /*IF(l_hierarchy_list.count = 0)
640: then
641: IF( g_raise_fatal_errors = TRUE) THEN
642: hr_utility.set_message(809, 'HXC_NO_HIER_FOR_DATE');
643: hr_utility.raise_error;
644: ELSE
645: g_fatal_error_occurred := TRUE;
646: g_fatal_error := 'HXC_NO_HIER_FOR_DATE';
647: RETURN;

Line 858: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');

854:
855: --g_loop_count := g_loop_count + 1;
856:
857: IF(g_loop_count > g_maxloop) THEN
858: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
859: hr_utility.raise_error;
860: END IF;
861:
862: END LOOP;

Line 859: hr_utility.raise_error;

855: --g_loop_count := g_loop_count + 1;
856:
857: IF(g_loop_count > g_maxloop) THEN
858: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
859: hr_utility.raise_error;
860: END IF;
861:
862: END LOOP;
863:

Line 920: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');

916:
917: --g_loop_count := g_loop_count + 1;
918:
919: IF(g_loop_count > g_maxloop) THEN
920: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
921: hr_utility.raise_error;
922: END IF;
923:
924:

Line 921: hr_utility.raise_error;

917: --g_loop_count := g_loop_count + 1;
918:
919: IF(g_loop_count > g_maxloop) THEN
920: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
921: hr_utility.raise_error;
922: END IF;
923:
924:
925: END LOOP;

Line 1025: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');

1021: -- debug, to be removed
1022: -- g_loop_count := g_loop_count + 1;
1023:
1024: IF(g_loop_count > g_maxloop) THEN
1025: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
1026: hr_utility.raise_error;
1027: END IF;
1028: -- debug, to be removed
1029:

Line 1026: hr_utility.raise_error;

1022: -- g_loop_count := g_loop_count + 1;
1023:
1024: IF(g_loop_count > g_maxloop) THEN
1025: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
1026: hr_utility.raise_error;
1027: END IF;
1028: -- debug, to be removed
1029:
1030: END LOOP;

Line 1037: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');

1033:
1034: -- g_loop_count := g_loop_count + 1;
1035:
1036: IF(g_loop_count > g_maxloop) THEN
1037: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
1038: hr_utility.raise_error;
1039: END IF;
1040:
1041: END LOOP;

Line 1038: hr_utility.raise_error;

1034: -- g_loop_count := g_loop_count + 1;
1035:
1036: IF(g_loop_count > g_maxloop) THEN
1037: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
1038: hr_utility.raise_error;
1039: END IF;
1040:
1041: END LOOP;
1042:

Line 1048: hr_utility.set_message(809, 'HXC_NO_VALS_FOR_PREF_CODE');

1044: -- Raise an error as the requested preference was not found for the user.
1045: -- This should never happen as all supported preferences MUST occur in the
1046: -- default preference tree (even if the value is left blank)
1047: IF( g_raise_fatal_errors = TRUE) THEN
1048: hr_utility.set_message(809, 'HXC_NO_VALS_FOR_PREF_CODE');
1049: hr_utility.raise_error;
1050: ELSE
1051: g_fatal_error_occurred := TRUE;
1052: g_fatal_error := 'HXC_NO_VALS_FOR_PREF_CODE';

Line 1049: hr_utility.raise_error;

1045: -- This should never happen as all supported preferences MUST occur in the
1046: -- default preference tree (even if the value is left blank)
1047: IF( g_raise_fatal_errors = TRUE) THEN
1048: hr_utility.set_message(809, 'HXC_NO_VALS_FOR_PREF_CODE');
1049: hr_utility.raise_error;
1050: ELSE
1051: g_fatal_error_occurred := TRUE;
1052: g_fatal_error := 'HXC_NO_VALS_FOR_PREF_CODE';
1053: RETURN null;

Line 1062: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');

1058:
1059: -- g_loop_count := g_loop_count + 1;
1060:
1061: IF(g_loop_count > g_maxloop) THEN
1062: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
1063: hr_utility.raise_error;
1064: END IF;
1065:
1066: END LOOP;

Line 1063: hr_utility.raise_error;

1059: -- g_loop_count := g_loop_count + 1;
1060:
1061: IF(g_loop_count > g_maxloop) THEN
1062: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
1063: hr_utility.raise_error;
1064: END IF;
1065:
1066: END LOOP;
1067: RETURN substr(p_pref_value_list,1,length(p_pref_value_list)-1);

Line 1112: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');

1108: -- debug, to be removed
1109: -- g_loop_count := g_loop_count + 1;
1110:
1111: IF(g_loop_count > g_maxloop) THEN
1112: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
1113: hr_utility.raise_error;
1114: END IF;
1115: -- debug, to be removed
1116:

Line 1113: hr_utility.raise_error;

1109: -- g_loop_count := g_loop_count + 1;
1110:
1111: IF(g_loop_count > g_maxloop) THEN
1112: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
1113: hr_utility.raise_error;
1114: END IF;
1115: -- debug, to be removed
1116:
1117: END LOOP;

Line 1125: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');

1121: -- debug, to be removed
1122: -- g_loop_count := g_loop_count + 1;
1123:
1124: IF(g_loop_count > g_maxloop) THEN
1125: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
1126: hr_utility.raise_error;
1127: END IF;
1128: -- debug, to be removed
1129: END LOOP;

Line 1126: hr_utility.raise_error;

1122: -- g_loop_count := g_loop_count + 1;
1123:
1124: IF(g_loop_count > g_maxloop) THEN
1125: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
1126: hr_utility.raise_error;
1127: END IF;
1128: -- debug, to be removed
1129: END LOOP;
1130: p_pref_table := l_pref_table;

Line 1794: g_debug := hr_utility.debug_enabled;

1790:
1791: l_resp_id := p_resp_id;
1792:
1793:
1794: g_debug := hr_utility.debug_enabled;
1795:
1796: IF g_debug
1797: THEN
1798: hr_utility.trace('Evaluating pref for start and stop dates');

Line 1798: hr_utility.trace('Evaluating pref for start and stop dates');

1794: g_debug := hr_utility.debug_enabled;
1795:
1796: IF g_debug
1797: THEN
1798: hr_utility.trace('Evaluating pref for start and stop dates');
1799: hr_utility.trace('p_resource_id '||p_resource_id);
1800: hr_utility.trace('p_start_evaluation_date '||p_start_evaluation_date);
1801: hr_utility.trace('p_end_evaluation_date '||p_end_evaluation_date);
1802: END IF;

Line 1799: hr_utility.trace('p_resource_id '||p_resource_id);

1795:
1796: IF g_debug
1797: THEN
1798: hr_utility.trace('Evaluating pref for start and stop dates');
1799: hr_utility.trace('p_resource_id '||p_resource_id);
1800: hr_utility.trace('p_start_evaluation_date '||p_start_evaluation_date);
1801: hr_utility.trace('p_end_evaluation_date '||p_end_evaluation_date);
1802: END IF;
1803:

Line 1800: hr_utility.trace('p_start_evaluation_date '||p_start_evaluation_date);

1796: IF g_debug
1797: THEN
1798: hr_utility.trace('Evaluating pref for start and stop dates');
1799: hr_utility.trace('p_resource_id '||p_resource_id);
1800: hr_utility.trace('p_start_evaluation_date '||p_start_evaluation_date);
1801: hr_utility.trace('p_end_evaluation_date '||p_end_evaluation_date);
1802: END IF;
1803:
1804:

Line 1801: hr_utility.trace('p_end_evaluation_date '||p_end_evaluation_date);

1797: THEN
1798: hr_utility.trace('Evaluating pref for start and stop dates');
1799: hr_utility.trace('p_resource_id '||p_resource_id);
1800: hr_utility.trace('p_start_evaluation_date '||p_start_evaluation_date);
1801: hr_utility.trace('p_end_evaluation_date '||p_end_evaluation_date);
1802: END IF;
1803:
1804:
1805:

Line 1918: hr_utility.set_message(809, 'HXC_NO_HIER_FOR_DATE');

1914: -- Issue 6
1915: if(l_hierarchy_list(0).pref_hierarchy_id is null)
1916: then
1917: IF( g_raise_fatal_errors = TRUE) THEN
1918: hr_utility.set_message(809, 'HXC_NO_HIER_FOR_DATE');
1919: hr_utility.raise_error;
1920: ELSE
1921: g_fatal_error := 'HXC_NO_HIER_FOR_DATE';
1922: g_fatal_error_occurred := TRUE;

Line 1919: hr_utility.raise_error;

1915: if(l_hierarchy_list(0).pref_hierarchy_id is null)
1916: then
1917: IF( g_raise_fatal_errors = TRUE) THEN
1918: hr_utility.set_message(809, 'HXC_NO_HIER_FOR_DATE');
1919: hr_utility.raise_error;
1920: ELSE
1921: g_fatal_error := 'HXC_NO_HIER_FOR_DATE';
1922: g_fatal_error_occurred := TRUE;
1923: RETURN;

Line 2077: hr_utility.set_message(809, 'HXC_NO_HIER_FOR_DATE');

2073: --Issue 6
2074: /*if(l_hierarchy_list.count=0)
2075: then
2076: IF( g_raise_fatal_errors = TRUE) THEN
2077: hr_utility.set_message(809, 'HXC_NO_HIER_FOR_DATE');
2078: hr_utility.raise_error;
2079: ELSE
2080: g_fatal_error := 'HXC_NO_HIER_FOR_DATE';
2081: g_fatal_error_occurred := TRUE;

Line 2078: hr_utility.raise_error;

2074: /*if(l_hierarchy_list.count=0)
2075: then
2076: IF( g_raise_fatal_errors = TRUE) THEN
2077: hr_utility.set_message(809, 'HXC_NO_HIER_FOR_DATE');
2078: hr_utility.raise_error;
2079: ELSE
2080: g_fatal_error := 'HXC_NO_HIER_FOR_DATE';
2081: g_fatal_error_occurred := TRUE;
2082: RETURN;

Line 2529: -- hr_utility.set_message(809, 'HXC_LPS_GT_MAX');

2525:
2526: l_index := l_dated_prefs.next(l_index);
2527:
2528: -- IF(g_loop_count > g_maxloop) THEN
2529: -- hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
2530: -- hr_utility.raise_error;
2531: -- END IF;
2532:
2533: -- g_loop_count := g_loop_count + 1;

Line 2530: -- hr_utility.raise_error;

2526: l_index := l_dated_prefs.next(l_index);
2527:
2528: -- IF(g_loop_count > g_maxloop) THEN
2529: -- hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
2530: -- hr_utility.raise_error;
2531: -- END IF;
2532:
2533: -- g_loop_count := g_loop_count + 1;
2534:

Line 2545: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');

2541:
2542: -- g_loop_count := g_loop_count + 1;
2543:
2544: IF(g_loop_count > g_maxloop) THEN
2545: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
2546: hr_utility.raise_error;
2547: END IF;
2548:
2549: END LOOP; --1 hierarchy loop;

Line 2546: hr_utility.raise_error;

2542: -- g_loop_count := g_loop_count + 1;
2543:
2544: IF(g_loop_count > g_maxloop) THEN
2545: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
2546: hr_utility.raise_error;
2547: END IF;
2548:
2549: END LOOP; --1 hierarchy loop;
2550:

Line 2612: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');

2608:
2609: l_index:=l_dated_prefs.next(l_index);
2610:
2611: IF(g_loop_count > g_maxloop) THEN
2612: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
2613: hr_utility.raise_error;
2614: END IF;
2615:
2616: -- g_loop_count := g_loop_count + 1;

Line 2613: hr_utility.raise_error;

2609: l_index:=l_dated_prefs.next(l_index);
2610:
2611: IF(g_loop_count > g_maxloop) THEN
2612: hr_utility.set_message(809, 'HXC_LPS_GT_MAX');
2613: hr_utility.raise_error;
2614: END IF;
2615:
2616: -- g_loop_count := g_loop_count + 1;
2617:

Line 2855: g_debug := hr_utility.debug_enabled;

2851: RETURN BOOLEAN
2852: IS
2853: l_proc VARCHAR2 (72);
2854: BEGIN
2855: g_debug := hr_utility.debug_enabled;
2856:
2857: if g_debug then
2858: l_proc := g_package|| 'migration_mode';
2859: hr_utility.set_location ( 'Entering:'

Line 2859: hr_utility.set_location ( 'Entering:'

2855: g_debug := hr_utility.debug_enabled;
2856:
2857: if g_debug then
2858: l_proc := g_package|| 'migration_mode';
2859: hr_utility.set_location ( 'Entering:'
2860: || l_proc, 10);
2861: end if;
2862:
2863: IF (g_migration_mode)

Line 2866: hr_utility.set_location (' returning g_migration_mode = TRUE', 20);

2862:
2863: IF (g_migration_mode)
2864: THEN
2865: if g_debug then
2866: hr_utility.set_location (' returning g_migration_mode = TRUE', 20);
2867: end if;
2868: ELSE
2869: if g_debug then
2870: hr_utility.set_location (' returning g_migration_mode = FALSE', 30);

Line 2870: hr_utility.set_location (' returning g_migration_mode = FALSE', 30);

2866: hr_utility.set_location (' returning g_migration_mode = TRUE', 20);
2867: end if;
2868: ELSE
2869: if g_debug then
2870: hr_utility.set_location (' returning g_migration_mode = FALSE', 30);
2871: end if;
2872: END IF;
2873:
2874: if g_debug then

Line 2875: hr_utility.set_location ( 'Leaving:'

2871: end if;
2872: END IF;
2873:
2874: if g_debug then
2875: hr_utility.set_location ( 'Leaving:'
2876: || l_proc, 100);
2877: end if;
2878: RETURN g_migration_mode;
2879: END migration_mode;

Line 2884: g_debug := hr_utility.debug_enabled;

2880: PROCEDURE set_migration_mode (p_migration_mode IN BOOLEAN)
2881: IS
2882: l_proc VARCHAR2 (72);
2883: BEGIN
2884: g_debug := hr_utility.debug_enabled;
2885:
2886: if g_debug then
2887: l_proc := g_package||'set_migration_mode';
2888: hr_utility.set_location ( 'Entering:'|| l_proc, 10);

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

2884: g_debug := hr_utility.debug_enabled;
2885:
2886: if g_debug then
2887: l_proc := g_package||'set_migration_mode';
2888: hr_utility.set_location ( 'Entering:'|| l_proc, 10);
2889: end if;
2890:
2891: IF (p_migration_mode)
2892: THEN

Line 2894: hr_utility.set_location (' setting g_migration_mode to TRUE', 20);

2890:
2891: IF (p_migration_mode)
2892: THEN
2893: if g_debug then
2894: hr_utility.set_location (' setting g_migration_mode to TRUE', 20);
2895: end if;
2896: ELSE
2897: if g_debug then
2898: hr_utility.set_location (' setting g_migration_mode to FALSE', 30);

Line 2898: hr_utility.set_location (' setting g_migration_mode to FALSE', 30);

2894: hr_utility.set_location (' setting g_migration_mode to TRUE', 20);
2895: end if;
2896: ELSE
2897: if g_debug then
2898: hr_utility.set_location (' setting g_migration_mode to FALSE', 30);
2899: end if;
2900: END IF;
2901:
2902: g_migration_mode := p_migration_mode;

Line 2904: hr_utility.set_location ( 'Leaving:'

2900: END IF;
2901:
2902: g_migration_mode := p_migration_mode;
2903: if g_debug then
2904: hr_utility.set_location ( 'Leaving:'
2905: || l_proc, 100);
2906: end if;
2907: END set_migration_mode;
2908: FUNCTION employment_ended (

Line 2934: g_debug := hr_utility.debug_enabled;

2930: AND past.per_system_status IN ('ACTIVE_ASSIGN','ACTIVE_CWK');
2931:
2932: l_existing_employment csr_existing_employment%ROWTYPE;
2933: BEGIN
2934: g_debug := hr_utility.debug_enabled;
2935:
2936: if g_debug then
2937: l_proc := g_package|| 'employment_ended';
2938: hr_utility.set_location ( 'Entering:'

Line 2938: hr_utility.set_location ( 'Entering:'

2934: g_debug := hr_utility.debug_enabled;
2935:
2936: if g_debug then
2937: l_proc := g_package|| 'employment_ended';
2938: hr_utility.set_location ( 'Entering:'
2939: || l_proc, 10);
2940: end if;
2941: OPEN csr_existing_employment (p_person_id, p_effective_date);
2942: FETCH csr_existing_employment INTO l_existing_employment;

Line 2947: hr_utility.set_location (

2943:
2944: IF (csr_existing_employment%NOTFOUND)
2945: THEN
2946: if g_debug then
2947: hr_utility.set_location (
2948: ' The employment for '
2949: || p_person_id
2950: || 'ended.',
2951: 20

Line 2961: hr_utility.set_location ( 'Leaving:'

2957: END IF;
2958:
2959: CLOSE csr_existing_employment;
2960: if g_debug then
2961: hr_utility.set_location ( 'Leaving:'
2962: || l_proc, 100);
2963: end if;
2964: RETURN l_employment_ended;
2965: END employment_ended;

Line 2990: g_debug := hr_utility.debug_enabled;

2986: AND paaf.assignment_type IN ( 'E', 'C')
2987: AND past.assignment_status_type_id = paaf.assignment_status_type_id
2988: AND past.per_system_status IN ( 'ACTIVE_ASSIGN','ACTIVE_CWK');
2989: BEGIN
2990: g_debug := hr_utility.debug_enabled;
2991:
2992: if g_debug then
2993: l_proc := g_package|| 'assignment_last_eff_dt';
2994: hr_utility.set_location ( 'Entering:'

Line 2994: hr_utility.set_location ( 'Entering:'

2990: g_debug := hr_utility.debug_enabled;
2991:
2992: if g_debug then
2993: l_proc := g_package|| 'assignment_last_eff_dt';
2994: hr_utility.set_location ( 'Entering:'
2995: || l_proc, 10);
2996: end if;
2997: OPEN csr_assignment_last_eff_dt (p_person_id, p_effective_date);
2998: FETCH csr_assignment_last_eff_dt INTO l_assignment_last_eff_dt;

Line 3007: hr_utility.set_location (

3003: -- have to act on it here.
3004: l_assignment_last_eff_dt := NULL;
3005: ELSE
3006: if g_debug then
3007: hr_utility.set_location (
3008: ' The last available effective date for person '
3009: || p_person_id
3010: || ' is '
3011: || l_assignment_last_eff_dt,

Line 3019: hr_utility.set_location ( 'Leaving:'

3015: END IF;
3016:
3017: CLOSE csr_assignment_last_eff_dt;
3018: if g_debug then
3019: hr_utility.set_location ( 'Leaving:'
3020: || l_proc, 100);
3021: end if;
3022: RETURN l_assignment_last_eff_dt;
3023: END assignment_last_eff_dt;

Line 3034: g_debug := hr_utility.debug_enabled;

3030: IS
3031: l_proc VARCHAR2 (72);
3032: l_evaluation_date DATE;
3033: BEGIN
3034: g_debug := hr_utility.debug_enabled;
3035:
3036: if g_debug then
3037: l_proc := g_package|| 'evaluation_date';
3038: hr_utility.set_location ( 'Entering:'

Line 3038: hr_utility.set_location ( 'Entering:'

3034: g_debug := hr_utility.debug_enabled;
3035:
3036: if g_debug then
3037: l_proc := g_package|| 'evaluation_date';
3038: hr_utility.set_location ( 'Entering:'
3039: || l_proc, 10);
3040: end if;
3041:
3042: IF ( (migration_mode)

Line 3054: hr_utility.set_location (

3050: l_evaluation_date := TRUNC (p_evaluation_date);
3051: END IF;
3052:
3053: if g_debug then
3054: hr_utility.set_location (
3055: ' Returning evaluation_date ='
3056: || l_evaluation_date,
3057: 20
3058: );

Line 3059: hr_utility.set_location ( 'Leaving:'

3055: ' Returning evaluation_date ='
3056: || l_evaluation_date,
3057: 20
3058: );
3059: hr_utility.set_location ( 'Leaving:'
3060: || l_proc, 100);
3061: end if;
3062: RETURN l_evaluation_date;
3063: END evaluation_date;

Line 3438: g_debug := hr_utility.debug_enabled;

3434: CURSOR get_employee_id(p_user_id IN Number) Is
3435: Select employee_id from fnd_user
3436: Where user_id = p_user_id;
3437: BEGIN
3438: g_debug := hr_utility.debug_enabled;
3439: if g_debug then
3440: hr_utility.set_location ('Starting get_tc_resp' , 10 );
3441: end if;
3442: OPEN get_resp_id (p_resource_id,p_evaluation_date);

Line 3440: hr_utility.set_location ('Starting get_tc_resp' , 10 );

3436: Where user_id = p_user_id;
3437: BEGIN
3438: g_debug := hr_utility.debug_enabled;
3439: if g_debug then
3440: hr_utility.set_location ('Starting get_tc_resp' , 10 );
3441: end if;
3442: OPEN get_resp_id (p_resource_id,p_evaluation_date);
3443: FETCH get_resp_id into resp_id, l_tc_user_id;
3444: close get_resp_id;

Line 3450: hr_utility.set_location ('Returning resp_id =' || resp_id, 20 );

3446: Fetch get_employee_id into l_tc_employee_id;
3447: Close get_employee_id;
3448: IF p_resource_id = l_tc_employee_id then
3449: if g_debug then
3450: hr_utility.set_location ('Returning resp_id =' || resp_id, 20 );
3451: hr_utility.set_location ('Returning l_tc_employee_id =' || l_tc_employee_id, 20 );
3452: end if;
3453: return to_number(resp_id);
3454: ELSE

Line 3451: hr_utility.set_location ('Returning l_tc_employee_id =' || l_tc_employee_id, 20 );

3447: Close get_employee_id;
3448: IF p_resource_id = l_tc_employee_id then
3449: if g_debug then
3450: hr_utility.set_location ('Returning resp_id =' || resp_id, 20 );
3451: hr_utility.set_location ('Returning l_tc_employee_id =' || l_tc_employee_id, 20 );
3452: end if;
3453: return to_number(resp_id);
3454: ELSE
3455: hr_utility.set_location ('Returning resp_id = -101' , 20 );

Line 3455: hr_utility.set_location ('Returning resp_id = -101' , 20 );

3451: hr_utility.set_location ('Returning l_tc_employee_id =' || l_tc_employee_id, 20 );
3452: end if;
3453: return to_number(resp_id);
3454: ELSE
3455: hr_utility.set_location ('Returning resp_id = -101' , 20 );
3456: return(-101);
3457: END IF;
3458: if g_debug then
3459: hr_utility.set_location ('Stopping get_tc_resp' , 30 );

Line 3459: hr_utility.set_location ('Stopping get_tc_resp' , 30 );

3455: hr_utility.set_location ('Returning resp_id = -101' , 20 );
3456: return(-101);
3457: END IF;
3458: if g_debug then
3459: hr_utility.set_location ('Stopping get_tc_resp' , 30 );
3460: end if;
3461: EXCEPTION
3462: WHEN NO_DATA_FOUND THEN
3463: hr_utility.set_location ('Resp_id not found in Security attribute ' || resp_id || 'for resource ' || p_resource_id , 40 );

Line 3463: hr_utility.set_location ('Resp_id not found in Security attribute ' || resp_id || 'for resource ' || p_resource_id , 40 );

3459: hr_utility.set_location ('Stopping get_tc_resp' , 30 );
3460: end if;
3461: EXCEPTION
3462: WHEN NO_DATA_FOUND THEN
3463: hr_utility.set_location ('Resp_id not found in Security attribute ' || resp_id || 'for resource ' || p_resource_id , 40 );
3464: RETURN(-101);
3465: WHEN INVALID_NUMBER THEN
3466: hr_utility.set_location ('Invalid Number Value found in resp_id ' || resp_id || 'for resource ' || p_resource_id , 40 );
3467: RETURN(-101);

Line 3466: hr_utility.set_location ('Invalid Number Value found in resp_id ' || resp_id || 'for resource ' || p_resource_id , 40 );

3462: WHEN NO_DATA_FOUND THEN
3463: hr_utility.set_location ('Resp_id not found in Security attribute ' || resp_id || 'for resource ' || p_resource_id , 40 );
3464: RETURN(-101);
3465: WHEN INVALID_NUMBER THEN
3466: hr_utility.set_location ('Invalid Number Value found in resp_id ' || resp_id || 'for resource ' || p_resource_id , 40 );
3467: RETURN(-101);
3468: END get_tc_resp;
3469:
3470:

Line 3530: g_debug := hr_utility.debug_enabled;

3526: l_tc_date_to DATE;
3527:
3528:
3529: BEGIN
3530: g_debug := hr_utility.debug_enabled;
3531: if g_debug then
3532: hr_utility.set_location ('Starting get_tc_resp' , 40 );
3533: end if;
3534:

Line 3532: hr_utility.set_location ('Starting get_tc_resp' , 40 );

3528:
3529: BEGIN
3530: g_debug := hr_utility.debug_enabled;
3531: if g_debug then
3532: hr_utility.set_location ('Starting get_tc_resp' , 40 );
3533: end if;
3534:
3535:
3536:

Line 3575: hr_utility.set_location ('Returning resp_id =' || resp_id, 50 );

3571: p_resp_appl_id := to_number(resp_appl_id);
3572:
3573:
3574: if g_debug then
3575: hr_utility.set_location ('Returning resp_id =' || resp_id, 50 );
3576: hr_utility.set_location ('Returning resp_appl_id =' || resp_appl_id, 50 );
3577: end if;
3578:
3579: ELSE

Line 3576: hr_utility.set_location ('Returning resp_appl_id =' || resp_appl_id, 50 );

3572:
3573:
3574: if g_debug then
3575: hr_utility.set_location ('Returning resp_id =' || resp_id, 50 );
3576: hr_utility.set_location ('Returning resp_appl_id =' || resp_appl_id, 50 );
3577: end if;
3578:
3579: ELSE
3580: p_resp_id := -101;

Line 3583: hr_utility.set_location ('Returning resp_id =' || p_resp_id, 55 );

3579: ELSE
3580: p_resp_id := -101;
3581: p_resp_appl_id := to_number(fnd_global.resp_appl_id);
3582: if g_debug then
3583: hr_utility.set_location ('Returning resp_id =' || p_resp_id, 55 );
3584: hr_utility.set_location ('Returning resp_appl_id =' || p_resp_appl_id, 55 );
3585: end if;
3586: END IF;
3587: ELSE

Line 3584: hr_utility.set_location ('Returning resp_appl_id =' || p_resp_appl_id, 55 );

3580: p_resp_id := -101;
3581: p_resp_appl_id := to_number(fnd_global.resp_appl_id);
3582: if g_debug then
3583: hr_utility.set_location ('Returning resp_id =' || p_resp_id, 55 );
3584: hr_utility.set_location ('Returning resp_appl_id =' || p_resp_appl_id, 55 );
3585: end if;
3586: END IF;
3587: ELSE
3588:

Line 3594: hr_utility.set_location ('10 Returning resp_id =' || p_resp_id, 58 );

3590: p_resp_id := to_number(fnd_global.resp_id);
3591: p_resp_appl_id := to_number(fnd_global.resp_appl_id);
3592:
3593: if g_debug then
3594: hr_utility.set_location ('10 Returning resp_id =' || p_resp_id, 58 );
3595: hr_utility.set_location ('10 Returning resp_appl_id =' || p_resp_appl_id, 58 );
3596: end if;
3597:
3598: END IF;

Line 3595: hr_utility.set_location ('10 Returning resp_appl_id =' || p_resp_appl_id, 58 );

3591: p_resp_appl_id := to_number(fnd_global.resp_appl_id);
3592:
3593: if g_debug then
3594: hr_utility.set_location ('10 Returning resp_id =' || p_resp_id, 58 );
3595: hr_utility.set_location ('10 Returning resp_appl_id =' || p_resp_appl_id, 58 );
3596: end if;
3597:
3598: END IF;
3599:

Line 3602: hr_utility.set_location ('Stopping get_tc_resp' , 60 );

3598: END IF;
3599:
3600:
3601: if g_debug then
3602: hr_utility.set_location ('Stopping get_tc_resp' , 60 );
3603: end if;
3604: EXCEPTION
3605: WHEN NO_DATA_FOUND THEN
3606: p_resp_id := -101;

Line 3611: hr_utility.set_location ('Invalid Number Value found in resp_id ' || resp_id || 'for resource ' || p_resource_id , 70 );

3607: p_resp_appl_id := to_number(fnd_global.resp_appl_id);
3608: WHEN INVALID_NUMBER THEN
3609: p_resp_id := -101;
3610: p_resp_appl_id := to_number(fnd_global.resp_appl_id);
3611: hr_utility.set_location ('Invalid Number Value found in resp_id ' || resp_id || 'for resource ' || p_resource_id , 70 );
3612: END get_tc_resp;
3613:
3614:
3615:

Line 3793: hr_utility.trace ('get_tc_resp');

3789:
3790:
3791: IF g_debug
3792: THEN
3793: hr_utility.trace ('get_tc_resp');
3794: END IF;
3795:
3796: OPEN get_time_periods ( p_resource_id => p_resource_id,
3797: p_start_evaluation_date => p_start_evaluation_date,