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

Line 64: -- HR_UTILITY.TRACE_on(NULL,'rdhingra_pyuseewr');

60:
61:
62:
63: BEGIN
64: -- HR_UTILITY.TRACE_on(NULL,'rdhingra_pyuseewr');
65: --
66: hr_utility.trace('p_ele_name -->' || p_ele_name);
67: hr_utility.trace('p_ele_reporting_name -->' || p_ele_reporting_name);
68: hr_utility.trace('p_ele_description -->' || p_ele_description);

Line 66: hr_utility.trace('p_ele_name -->' || p_ele_name);

62:
63: BEGIN
64: -- HR_UTILITY.TRACE_on(NULL,'rdhingra_pyuseewr');
65: --
66: hr_utility.trace('p_ele_name -->' || p_ele_name);
67: hr_utility.trace('p_ele_reporting_name -->' || p_ele_reporting_name);
68: hr_utility.trace('p_ele_description -->' || p_ele_description);
69: hr_utility.trace('p_ele_classification -->' || p_ele_classification);
70: hr_utility.trace('p_ele_category -->' || p_ele_category);

Line 67: hr_utility.trace('p_ele_reporting_name -->' || p_ele_reporting_name);

63: BEGIN
64: -- HR_UTILITY.TRACE_on(NULL,'rdhingra_pyuseewr');
65: --
66: hr_utility.trace('p_ele_name -->' || p_ele_name);
67: hr_utility.trace('p_ele_reporting_name -->' || p_ele_reporting_name);
68: hr_utility.trace('p_ele_description -->' || p_ele_description);
69: hr_utility.trace('p_ele_classification -->' || p_ele_classification);
70: hr_utility.trace('p_ele_category -->' || p_ele_category);
71: hr_utility.trace('p_ele_ot_base -->' || p_ele_ot_base);

Line 68: hr_utility.trace('p_ele_description -->' || p_ele_description);

64: -- HR_UTILITY.TRACE_on(NULL,'rdhingra_pyuseewr');
65: --
66: hr_utility.trace('p_ele_name -->' || p_ele_name);
67: hr_utility.trace('p_ele_reporting_name -->' || p_ele_reporting_name);
68: hr_utility.trace('p_ele_description -->' || p_ele_description);
69: hr_utility.trace('p_ele_classification -->' || p_ele_classification);
70: hr_utility.trace('p_ele_category -->' || p_ele_category);
71: hr_utility.trace('p_ele_ot_base -->' || p_ele_ot_base);
72: hr_utility.trace('p_flsa_hours -->' || p_flsa_hours);

Line 69: hr_utility.trace('p_ele_classification -->' || p_ele_classification);

65: --
66: hr_utility.trace('p_ele_name -->' || p_ele_name);
67: hr_utility.trace('p_ele_reporting_name -->' || p_ele_reporting_name);
68: hr_utility.trace('p_ele_description -->' || p_ele_description);
69: hr_utility.trace('p_ele_classification -->' || p_ele_classification);
70: hr_utility.trace('p_ele_category -->' || p_ele_category);
71: hr_utility.trace('p_ele_ot_base -->' || p_ele_ot_base);
72: hr_utility.trace('p_flsa_hours -->' || p_flsa_hours);
73: hr_utility.trace('p_ele_processing_type-->' || p_ele_processing_type);

Line 70: hr_utility.trace('p_ele_category -->' || p_ele_category);

66: hr_utility.trace('p_ele_name -->' || p_ele_name);
67: hr_utility.trace('p_ele_reporting_name -->' || p_ele_reporting_name);
68: hr_utility.trace('p_ele_description -->' || p_ele_description);
69: hr_utility.trace('p_ele_classification -->' || p_ele_classification);
70: hr_utility.trace('p_ele_category -->' || p_ele_category);
71: hr_utility.trace('p_ele_ot_base -->' || p_ele_ot_base);
72: hr_utility.trace('p_flsa_hours -->' || p_flsa_hours);
73: hr_utility.trace('p_ele_processing_type-->' || p_ele_processing_type);
74: hr_utility.trace('p_ele_priority -->' || p_ele_priority);

Line 71: hr_utility.trace('p_ele_ot_base -->' || p_ele_ot_base);

67: hr_utility.trace('p_ele_reporting_name -->' || p_ele_reporting_name);
68: hr_utility.trace('p_ele_description -->' || p_ele_description);
69: hr_utility.trace('p_ele_classification -->' || p_ele_classification);
70: hr_utility.trace('p_ele_category -->' || p_ele_category);
71: hr_utility.trace('p_ele_ot_base -->' || p_ele_ot_base);
72: hr_utility.trace('p_flsa_hours -->' || p_flsa_hours);
73: hr_utility.trace('p_ele_processing_type-->' || p_ele_processing_type);
74: hr_utility.trace('p_ele_priority -->' || p_ele_priority);
75: hr_utility.trace('p_ele_standard_link -->' || p_ele_standard_link);

Line 72: hr_utility.trace('p_flsa_hours -->' || p_flsa_hours);

68: hr_utility.trace('p_ele_description -->' || p_ele_description);
69: hr_utility.trace('p_ele_classification -->' || p_ele_classification);
70: hr_utility.trace('p_ele_category -->' || p_ele_category);
71: hr_utility.trace('p_ele_ot_base -->' || p_ele_ot_base);
72: hr_utility.trace('p_flsa_hours -->' || p_flsa_hours);
73: hr_utility.trace('p_ele_processing_type-->' || p_ele_processing_type);
74: hr_utility.trace('p_ele_priority -->' || p_ele_priority);
75: hr_utility.trace('p_ele_standard_link -->' || p_ele_standard_link);
76: hr_utility.trace('p_ele_calc_ff_id -->' || p_ele_calc_ff_id);

Line 73: hr_utility.trace('p_ele_processing_type-->' || p_ele_processing_type);

69: hr_utility.trace('p_ele_classification -->' || p_ele_classification);
70: hr_utility.trace('p_ele_category -->' || p_ele_category);
71: hr_utility.trace('p_ele_ot_base -->' || p_ele_ot_base);
72: hr_utility.trace('p_flsa_hours -->' || p_flsa_hours);
73: hr_utility.trace('p_ele_processing_type-->' || p_ele_processing_type);
74: hr_utility.trace('p_ele_priority -->' || p_ele_priority);
75: hr_utility.trace('p_ele_standard_link -->' || p_ele_standard_link);
76: hr_utility.trace('p_ele_calc_ff_id -->' || p_ele_calc_ff_id);
77: hr_utility.trace('p_ele_calc_ff_name -->' || p_ele_calc_ff_name);

Line 74: hr_utility.trace('p_ele_priority -->' || p_ele_priority);

70: hr_utility.trace('p_ele_category -->' || p_ele_category);
71: hr_utility.trace('p_ele_ot_base -->' || p_ele_ot_base);
72: hr_utility.trace('p_flsa_hours -->' || p_flsa_hours);
73: hr_utility.trace('p_ele_processing_type-->' || p_ele_processing_type);
74: hr_utility.trace('p_ele_priority -->' || p_ele_priority);
75: hr_utility.trace('p_ele_standard_link -->' || p_ele_standard_link);
76: hr_utility.trace('p_ele_calc_ff_id -->' || p_ele_calc_ff_id);
77: hr_utility.trace('p_ele_calc_ff_name -->' || p_ele_calc_ff_name);
78: hr_utility.trace('p_sep_check_option -->' || p_sep_check_option);

Line 75: hr_utility.trace('p_ele_standard_link -->' || p_ele_standard_link);

71: hr_utility.trace('p_ele_ot_base -->' || p_ele_ot_base);
72: hr_utility.trace('p_flsa_hours -->' || p_flsa_hours);
73: hr_utility.trace('p_ele_processing_type-->' || p_ele_processing_type);
74: hr_utility.trace('p_ele_priority -->' || p_ele_priority);
75: hr_utility.trace('p_ele_standard_link -->' || p_ele_standard_link);
76: hr_utility.trace('p_ele_calc_ff_id -->' || p_ele_calc_ff_id);
77: hr_utility.trace('p_ele_calc_ff_name -->' || p_ele_calc_ff_name);
78: hr_utility.trace('p_sep_check_option -->' || p_sep_check_option);
79: hr_utility.trace('p_dedn_proc -->' || p_dedn_proc);

Line 76: hr_utility.trace('p_ele_calc_ff_id -->' || p_ele_calc_ff_id);

72: hr_utility.trace('p_flsa_hours -->' || p_flsa_hours);
73: hr_utility.trace('p_ele_processing_type-->' || p_ele_processing_type);
74: hr_utility.trace('p_ele_priority -->' || p_ele_priority);
75: hr_utility.trace('p_ele_standard_link -->' || p_ele_standard_link);
76: hr_utility.trace('p_ele_calc_ff_id -->' || p_ele_calc_ff_id);
77: hr_utility.trace('p_ele_calc_ff_name -->' || p_ele_calc_ff_name);
78: hr_utility.trace('p_sep_check_option -->' || p_sep_check_option);
79: hr_utility.trace('p_dedn_proc -->' || p_dedn_proc);
80: hr_utility.trace('p_mix_flag -->' || p_mix_flag);

Line 77: hr_utility.trace('p_ele_calc_ff_name -->' || p_ele_calc_ff_name);

73: hr_utility.trace('p_ele_processing_type-->' || p_ele_processing_type);
74: hr_utility.trace('p_ele_priority -->' || p_ele_priority);
75: hr_utility.trace('p_ele_standard_link -->' || p_ele_standard_link);
76: hr_utility.trace('p_ele_calc_ff_id -->' || p_ele_calc_ff_id);
77: hr_utility.trace('p_ele_calc_ff_name -->' || p_ele_calc_ff_name);
78: hr_utility.trace('p_sep_check_option -->' || p_sep_check_option);
79: hr_utility.trace('p_dedn_proc -->' || p_dedn_proc);
80: hr_utility.trace('p_mix_flag -->' || p_mix_flag);
81: hr_utility.trace('p_reduce_regular -->' || p_reduce_regular);

Line 78: hr_utility.trace('p_sep_check_option -->' || p_sep_check_option);

74: hr_utility.trace('p_ele_priority -->' || p_ele_priority);
75: hr_utility.trace('p_ele_standard_link -->' || p_ele_standard_link);
76: hr_utility.trace('p_ele_calc_ff_id -->' || p_ele_calc_ff_id);
77: hr_utility.trace('p_ele_calc_ff_name -->' || p_ele_calc_ff_name);
78: hr_utility.trace('p_sep_check_option -->' || p_sep_check_option);
79: hr_utility.trace('p_dedn_proc -->' || p_dedn_proc);
80: hr_utility.trace('p_mix_flag -->' || p_mix_flag);
81: hr_utility.trace('p_reduce_regular -->' || p_reduce_regular);
82: hr_utility.trace('p_ele_eff_start_date -->' || p_ele_eff_start_date);

Line 79: hr_utility.trace('p_dedn_proc -->' || p_dedn_proc);

75: hr_utility.trace('p_ele_standard_link -->' || p_ele_standard_link);
76: hr_utility.trace('p_ele_calc_ff_id -->' || p_ele_calc_ff_id);
77: hr_utility.trace('p_ele_calc_ff_name -->' || p_ele_calc_ff_name);
78: hr_utility.trace('p_sep_check_option -->' || p_sep_check_option);
79: hr_utility.trace('p_dedn_proc -->' || p_dedn_proc);
80: hr_utility.trace('p_mix_flag -->' || p_mix_flag);
81: hr_utility.trace('p_reduce_regular -->' || p_reduce_regular);
82: hr_utility.trace('p_ele_eff_start_date -->' || p_ele_eff_start_date);
83: hr_utility.trace('p_ele_eff_end_date -->' || p_ele_eff_end_date);

Line 80: hr_utility.trace('p_mix_flag -->' || p_mix_flag);

76: hr_utility.trace('p_ele_calc_ff_id -->' || p_ele_calc_ff_id);
77: hr_utility.trace('p_ele_calc_ff_name -->' || p_ele_calc_ff_name);
78: hr_utility.trace('p_sep_check_option -->' || p_sep_check_option);
79: hr_utility.trace('p_dedn_proc -->' || p_dedn_proc);
80: hr_utility.trace('p_mix_flag -->' || p_mix_flag);
81: hr_utility.trace('p_reduce_regular -->' || p_reduce_regular);
82: hr_utility.trace('p_ele_eff_start_date -->' || p_ele_eff_start_date);
83: hr_utility.trace('p_ele_eff_end_date -->' || p_ele_eff_end_date);
84: hr_utility.trace('p_alien_supp_category-->' || p_alien_supp_category);

Line 81: hr_utility.trace('p_reduce_regular -->' || p_reduce_regular);

77: hr_utility.trace('p_ele_calc_ff_name -->' || p_ele_calc_ff_name);
78: hr_utility.trace('p_sep_check_option -->' || p_sep_check_option);
79: hr_utility.trace('p_dedn_proc -->' || p_dedn_proc);
80: hr_utility.trace('p_mix_flag -->' || p_mix_flag);
81: hr_utility.trace('p_reduce_regular -->' || p_reduce_regular);
82: hr_utility.trace('p_ele_eff_start_date -->' || p_ele_eff_start_date);
83: hr_utility.trace('p_ele_eff_end_date -->' || p_ele_eff_end_date);
84: hr_utility.trace('p_alien_supp_category-->' || p_alien_supp_category);
85: hr_utility.trace('p_bg_id -->' || p_bg_id );

Line 82: hr_utility.trace('p_ele_eff_start_date -->' || p_ele_eff_start_date);

78: hr_utility.trace('p_sep_check_option -->' || p_sep_check_option);
79: hr_utility.trace('p_dedn_proc -->' || p_dedn_proc);
80: hr_utility.trace('p_mix_flag -->' || p_mix_flag);
81: hr_utility.trace('p_reduce_regular -->' || p_reduce_regular);
82: hr_utility.trace('p_ele_eff_start_date -->' || p_ele_eff_start_date);
83: hr_utility.trace('p_ele_eff_end_date -->' || p_ele_eff_end_date);
84: hr_utility.trace('p_alien_supp_category-->' || p_alien_supp_category);
85: hr_utility.trace('p_bg_id -->' || p_bg_id );
86: hr_utility.trace('p_termination_rule -->' || p_termination_rule);

Line 83: hr_utility.trace('p_ele_eff_end_date -->' || p_ele_eff_end_date);

79: hr_utility.trace('p_dedn_proc -->' || p_dedn_proc);
80: hr_utility.trace('p_mix_flag -->' || p_mix_flag);
81: hr_utility.trace('p_reduce_regular -->' || p_reduce_regular);
82: hr_utility.trace('p_ele_eff_start_date -->' || p_ele_eff_start_date);
83: hr_utility.trace('p_ele_eff_end_date -->' || p_ele_eff_end_date);
84: hr_utility.trace('p_alien_supp_category-->' || p_alien_supp_category);
85: hr_utility.trace('p_bg_id -->' || p_bg_id );
86: hr_utility.trace('p_termination_rule -->' || p_termination_rule);
87: hr_utility.trace('p_stop_reach_rule -->' || p_stop_reach_rule);

Line 84: hr_utility.trace('p_alien_supp_category-->' || p_alien_supp_category);

80: hr_utility.trace('p_mix_flag -->' || p_mix_flag);
81: hr_utility.trace('p_reduce_regular -->' || p_reduce_regular);
82: hr_utility.trace('p_ele_eff_start_date -->' || p_ele_eff_start_date);
83: hr_utility.trace('p_ele_eff_end_date -->' || p_ele_eff_end_date);
84: hr_utility.trace('p_alien_supp_category-->' || p_alien_supp_category);
85: hr_utility.trace('p_bg_id -->' || p_bg_id );
86: hr_utility.trace('p_termination_rule -->' || p_termination_rule);
87: hr_utility.trace('p_stop_reach_rule -->' || p_stop_reach_rule);
88: hr_utility.trace('p_student_earning -->' || p_student_earning);

Line 85: hr_utility.trace('p_bg_id -->' || p_bg_id );

81: hr_utility.trace('p_reduce_regular -->' || p_reduce_regular);
82: hr_utility.trace('p_ele_eff_start_date -->' || p_ele_eff_start_date);
83: hr_utility.trace('p_ele_eff_end_date -->' || p_ele_eff_end_date);
84: hr_utility.trace('p_alien_supp_category-->' || p_alien_supp_category);
85: hr_utility.trace('p_bg_id -->' || p_bg_id );
86: hr_utility.trace('p_termination_rule -->' || p_termination_rule);
87: hr_utility.trace('p_stop_reach_rule -->' || p_stop_reach_rule);
88: hr_utility.trace('p_student_earning -->' || p_student_earning);
89: hr_utility.trace('p_special_input_flag -->' || p_special_input_flag);

Line 86: hr_utility.trace('p_termination_rule -->' || p_termination_rule);

82: hr_utility.trace('p_ele_eff_start_date -->' || p_ele_eff_start_date);
83: hr_utility.trace('p_ele_eff_end_date -->' || p_ele_eff_end_date);
84: hr_utility.trace('p_alien_supp_category-->' || p_alien_supp_category);
85: hr_utility.trace('p_bg_id -->' || p_bg_id );
86: hr_utility.trace('p_termination_rule -->' || p_termination_rule);
87: hr_utility.trace('p_stop_reach_rule -->' || p_stop_reach_rule);
88: hr_utility.trace('p_student_earning -->' || p_student_earning);
89: hr_utility.trace('p_special_input_flag -->' || p_special_input_flag);
90: hr_utility.trace('p_special_feature_flag-->'|| p_special_feature_flag);

Line 87: hr_utility.trace('p_stop_reach_rule -->' || p_stop_reach_rule);

83: hr_utility.trace('p_ele_eff_end_date -->' || p_ele_eff_end_date);
84: hr_utility.trace('p_alien_supp_category-->' || p_alien_supp_category);
85: hr_utility.trace('p_bg_id -->' || p_bg_id );
86: hr_utility.trace('p_termination_rule -->' || p_termination_rule);
87: hr_utility.trace('p_stop_reach_rule -->' || p_stop_reach_rule);
88: hr_utility.trace('p_student_earning -->' || p_student_earning);
89: hr_utility.trace('p_special_input_flag -->' || p_special_input_flag);
90: hr_utility.trace('p_special_feature_flag-->'|| p_special_feature_flag);
91: -- =======================================================================

Line 88: hr_utility.trace('p_student_earning -->' || p_student_earning);

84: hr_utility.trace('p_alien_supp_category-->' || p_alien_supp_category);
85: hr_utility.trace('p_bg_id -->' || p_bg_id );
86: hr_utility.trace('p_termination_rule -->' || p_termination_rule);
87: hr_utility.trace('p_stop_reach_rule -->' || p_stop_reach_rule);
88: hr_utility.trace('p_student_earning -->' || p_student_earning);
89: hr_utility.trace('p_special_input_flag -->' || p_special_input_flag);
90: hr_utility.trace('p_special_feature_flag-->'|| p_special_feature_flag);
91: -- =======================================================================
92: -- Initialize THE GLOBAL variables

Line 89: hr_utility.trace('p_special_input_flag -->' || p_special_input_flag);

85: hr_utility.trace('p_bg_id -->' || p_bg_id );
86: hr_utility.trace('p_termination_rule -->' || p_termination_rule);
87: hr_utility.trace('p_stop_reach_rule -->' || p_stop_reach_rule);
88: hr_utility.trace('p_student_earning -->' || p_student_earning);
89: hr_utility.trace('p_special_input_flag -->' || p_special_input_flag);
90: hr_utility.trace('p_special_feature_flag-->'|| p_special_feature_flag);
91: -- =======================================================================
92: -- Initialize THE GLOBAL variables
93: -- =======================================================================

Line 90: hr_utility.trace('p_special_feature_flag-->'|| p_special_feature_flag);

86: hr_utility.trace('p_termination_rule -->' || p_termination_rule);
87: hr_utility.trace('p_stop_reach_rule -->' || p_stop_reach_rule);
88: hr_utility.trace('p_student_earning -->' || p_student_earning);
89: hr_utility.trace('p_special_input_flag -->' || p_special_input_flag);
90: hr_utility.trace('p_special_feature_flag-->'|| p_special_feature_flag);
91: -- =======================================================================
92: -- Initialize THE GLOBAL variables
93: -- =======================================================================
94:

Line 108: hr_utility.trace('Value of arch is ' || l_architecture);

104: close c_architecture;
105: l_architecture := upper(substr(l_architecture,1,1));
106:
107: l_proc := l_proc||'.create_earnings_element';
108: hr_utility.trace('Value of arch is ' || l_architecture);
109:
110: -- Correctly Set the formula name depending on the formula passed from
111: -- the Earnings form
112: IF p_ele_processing_type = 'R' THEN

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

174: ,p_bg_id => p_bg_id
175: ,p_termination_rule => p_termination_rule
176:
177: );
178: hr_utility.set_location(l_proc, 20);
179:
180: ELSE /* Not Alien/Expat Earnings */
181:
182: IF NVL(l_architecture,'Y') = 'N' THEN

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

202: ,p_ele_eff_end_date => p_ele_eff_end_date
203: ,p_bg_id => p_bg_id
204: ,p_termination_rule => p_termination_rule
205: );
206: hr_utility.set_location(l_proc, 30);
207: --
208: ELSE /* Architecture */
209:
210: hr_utility.set_location('10. Start of new template call',10);

Line 210: hr_utility.set_location('10. Start of new template call',10);

206: hr_utility.set_location(l_proc, 30);
207: --
208: ELSE /* Architecture */
209:
210: hr_utility.set_location('10. Start of new template call',10);
211:
212: l_tw_rec := PAY_ELE_TMPLT_OBJ(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
213: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
214: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

Line 228: hr_utility.trace('102. Start of new template call' );

224: l_freq_rule := pay_freq_rule_table(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
225:
226:
227: OPEN c_bg_name (p_bg_id);
228: hr_utility.trace('102. Start of new template call' );
229: FETCH c_bg_name
230: INTO l_tw_rec.business_group_name;
231: hr_utility.trace('105. Start of new template call');
232: CLOSE c_bg_name;

Line 231: hr_utility.trace('105. Start of new template call');

227: OPEN c_bg_name (p_bg_id);
228: hr_utility.trace('102. Start of new template call' );
229: FETCH c_bg_name
230: INTO l_tw_rec.business_group_name;
231: hr_utility.trace('105. Start of new template call');
232: CLOSE c_bg_name;
233:
234: /* Priority to be kept as 1526 for
235: all reduce regular elements

Line 244: hr_utility.trace('11. Start of new template call');

240: ELSE
241: l_ele_priority := p_ele_priority;
242: END IF;
243:
244: hr_utility.trace('11. Start of new template call');
245: -- FLSA Changes
246: -- Need to modify the IF condition to include all Calculation
247: -- rules for FLSA
248: IF ((SUBSTR (l_ele_calc_ff_name, 1, 7) = 'PREMIUM') OR

Line 251: -- hr_utility.trace_on(NULL, 'FLSA');

247: -- rules for FLSA
248: IF ((SUBSTR (l_ele_calc_ff_name, 1, 7) = 'PREMIUM') OR
249: (SUBSTR (l_ele_calc_ff_name, 1, 12) = 'HOURS_X_RATE')
250: ) THEN
251: -- hr_utility.trace_on(NULL, 'FLSA');
252: hr_utility.trace('Using FLSA template');
253: hr_utility.trace('p_ele_category = ' ||p_ele_category );
254: hr_utility.trace('p_reduce_regular = ' || p_reduce_regular);
255: hr_utility.trace('p_flsa_hours = ' || p_flsa_hours);

Line 252: hr_utility.trace('Using FLSA template');

248: IF ((SUBSTR (l_ele_calc_ff_name, 1, 7) = 'PREMIUM') OR
249: (SUBSTR (l_ele_calc_ff_name, 1, 12) = 'HOURS_X_RATE')
250: ) THEN
251: -- hr_utility.trace_on(NULL, 'FLSA');
252: hr_utility.trace('Using FLSA template');
253: hr_utility.trace('p_ele_category = ' ||p_ele_category );
254: hr_utility.trace('p_reduce_regular = ' || p_reduce_regular);
255: hr_utility.trace('p_flsa_hours = ' || p_flsa_hours);
256: hr_utility.trace('p_ele_ot_base = ' || p_ele_ot_base);

Line 253: hr_utility.trace('p_ele_category = ' ||p_ele_category );

249: (SUBSTR (l_ele_calc_ff_name, 1, 12) = 'HOURS_X_RATE')
250: ) THEN
251: -- hr_utility.trace_on(NULL, 'FLSA');
252: hr_utility.trace('Using FLSA template');
253: hr_utility.trace('p_ele_category = ' ||p_ele_category );
254: hr_utility.trace('p_reduce_regular = ' || p_reduce_regular);
255: hr_utility.trace('p_flsa_hours = ' || p_flsa_hours);
256: hr_utility.trace('p_ele_ot_base = ' || p_ele_ot_base);
257: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);

Line 254: hr_utility.trace('p_reduce_regular = ' || p_reduce_regular);

250: ) THEN
251: -- hr_utility.trace_on(NULL, 'FLSA');
252: hr_utility.trace('Using FLSA template');
253: hr_utility.trace('p_ele_category = ' ||p_ele_category );
254: hr_utility.trace('p_reduce_regular = ' || p_reduce_regular);
255: hr_utility.trace('p_flsa_hours = ' || p_flsa_hours);
256: hr_utility.trace('p_ele_ot_base = ' || p_ele_ot_base);
257: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);
258: hr_utility.trace('p_ele_eff_start_date = ' || p_ele_eff_start_date);

Line 255: hr_utility.trace('p_flsa_hours = ' || p_flsa_hours);

251: -- hr_utility.trace_on(NULL, 'FLSA');
252: hr_utility.trace('Using FLSA template');
253: hr_utility.trace('p_ele_category = ' ||p_ele_category );
254: hr_utility.trace('p_reduce_regular = ' || p_reduce_regular);
255: hr_utility.trace('p_flsa_hours = ' || p_flsa_hours);
256: hr_utility.trace('p_ele_ot_base = ' || p_ele_ot_base);
257: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);
258: hr_utility.trace('p_ele_eff_start_date = ' || p_ele_eff_start_date);
259: hr_utility.trace('p_ele_classification = ' || p_ele_classification);

Line 256: hr_utility.trace('p_ele_ot_base = ' || p_ele_ot_base);

252: hr_utility.trace('Using FLSA template');
253: hr_utility.trace('p_ele_category = ' ||p_ele_category );
254: hr_utility.trace('p_reduce_regular = ' || p_reduce_regular);
255: hr_utility.trace('p_flsa_hours = ' || p_flsa_hours);
256: hr_utility.trace('p_ele_ot_base = ' || p_ele_ot_base);
257: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);
258: hr_utility.trace('p_ele_eff_start_date = ' || p_ele_eff_start_date);
259: hr_utility.trace('p_ele_classification = ' || p_ele_classification);
260: hr_utility.trace('p_ele_name = ' || p_ele_name);

Line 257: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);

253: hr_utility.trace('p_ele_category = ' ||p_ele_category );
254: hr_utility.trace('p_reduce_regular = ' || p_reduce_regular);
255: hr_utility.trace('p_flsa_hours = ' || p_flsa_hours);
256: hr_utility.trace('p_ele_ot_base = ' || p_ele_ot_base);
257: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);
258: hr_utility.trace('p_ele_eff_start_date = ' || p_ele_eff_start_date);
259: hr_utility.trace('p_ele_classification = ' || p_ele_classification);
260: hr_utility.trace('p_ele_name = ' || p_ele_name);
261: hr_utility.trace('p_ele_calc_ff_name = ' || l_ele_calc_ff_name);

Line 258: hr_utility.trace('p_ele_eff_start_date = ' || p_ele_eff_start_date);

254: hr_utility.trace('p_reduce_regular = ' || p_reduce_regular);
255: hr_utility.trace('p_flsa_hours = ' || p_flsa_hours);
256: hr_utility.trace('p_ele_ot_base = ' || p_ele_ot_base);
257: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);
258: hr_utility.trace('p_ele_eff_start_date = ' || p_ele_eff_start_date);
259: hr_utility.trace('p_ele_classification = ' || p_ele_classification);
260: hr_utility.trace('p_ele_name = ' || p_ele_name);
261: hr_utility.trace('p_ele_calc_ff_name = ' || l_ele_calc_ff_name);
262: hr_utility.trace('p_student_earning = ' || p_student_earning);

Line 259: hr_utility.trace('p_ele_classification = ' || p_ele_classification);

255: hr_utility.trace('p_flsa_hours = ' || p_flsa_hours);
256: hr_utility.trace('p_ele_ot_base = ' || p_ele_ot_base);
257: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);
258: hr_utility.trace('p_ele_eff_start_date = ' || p_ele_eff_start_date);
259: hr_utility.trace('p_ele_classification = ' || p_ele_classification);
260: hr_utility.trace('p_ele_name = ' || p_ele_name);
261: hr_utility.trace('p_ele_calc_ff_name = ' || l_ele_calc_ff_name);
262: hr_utility.trace('p_student_earning = ' || p_student_earning);
263: hr_utility.trace('p_dedn_proc = ' || p_dedn_proc);

Line 260: hr_utility.trace('p_ele_name = ' || p_ele_name);

256: hr_utility.trace('p_ele_ot_base = ' || p_ele_ot_base);
257: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);
258: hr_utility.trace('p_ele_eff_start_date = ' || p_ele_eff_start_date);
259: hr_utility.trace('p_ele_classification = ' || p_ele_classification);
260: hr_utility.trace('p_ele_name = ' || p_ele_name);
261: hr_utility.trace('p_ele_calc_ff_name = ' || l_ele_calc_ff_name);
262: hr_utility.trace('p_student_earning = ' || p_student_earning);
263: hr_utility.trace('p_dedn_proc = ' || p_dedn_proc);
264: hr_utility.trace('p_ele_priority = ' || p_ele_priority);

Line 261: hr_utility.trace('p_ele_calc_ff_name = ' || l_ele_calc_ff_name);

257: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);
258: hr_utility.trace('p_ele_eff_start_date = ' || p_ele_eff_start_date);
259: hr_utility.trace('p_ele_classification = ' || p_ele_classification);
260: hr_utility.trace('p_ele_name = ' || p_ele_name);
261: hr_utility.trace('p_ele_calc_ff_name = ' || l_ele_calc_ff_name);
262: hr_utility.trace('p_student_earning = ' || p_student_earning);
263: hr_utility.trace('p_dedn_proc = ' || p_dedn_proc);
264: hr_utility.trace('p_ele_priority = ' || p_ele_priority);
265: hr_utility.trace('p_sep_check_option = ' || p_sep_check_option);

Line 262: hr_utility.trace('p_student_earning = ' || p_student_earning);

258: hr_utility.trace('p_ele_eff_start_date = ' || p_ele_eff_start_date);
259: hr_utility.trace('p_ele_classification = ' || p_ele_classification);
260: hr_utility.trace('p_ele_name = ' || p_ele_name);
261: hr_utility.trace('p_ele_calc_ff_name = ' || l_ele_calc_ff_name);
262: hr_utility.trace('p_student_earning = ' || p_student_earning);
263: hr_utility.trace('p_dedn_proc = ' || p_dedn_proc);
264: hr_utility.trace('p_ele_priority = ' || p_ele_priority);
265: hr_utility.trace('p_sep_check_option = ' || p_sep_check_option);
266: hr_utility.trace('p_special_input_flag = ' || p_special_input_flag);

Line 263: hr_utility.trace('p_dedn_proc = ' || p_dedn_proc);

259: hr_utility.trace('p_ele_classification = ' || p_ele_classification);
260: hr_utility.trace('p_ele_name = ' || p_ele_name);
261: hr_utility.trace('p_ele_calc_ff_name = ' || l_ele_calc_ff_name);
262: hr_utility.trace('p_student_earning = ' || p_student_earning);
263: hr_utility.trace('p_dedn_proc = ' || p_dedn_proc);
264: hr_utility.trace('p_ele_priority = ' || p_ele_priority);
265: hr_utility.trace('p_sep_check_option = ' || p_sep_check_option);
266: hr_utility.trace('p_special_input_flag = ' || p_special_input_flag);
267: hr_utility.trace('p_stop_reach_rule = ' || p_stop_reach_rule);

Line 264: hr_utility.trace('p_ele_priority = ' || p_ele_priority);

260: hr_utility.trace('p_ele_name = ' || p_ele_name);
261: hr_utility.trace('p_ele_calc_ff_name = ' || l_ele_calc_ff_name);
262: hr_utility.trace('p_student_earning = ' || p_student_earning);
263: hr_utility.trace('p_dedn_proc = ' || p_dedn_proc);
264: hr_utility.trace('p_ele_priority = ' || p_ele_priority);
265: hr_utility.trace('p_sep_check_option = ' || p_sep_check_option);
266: hr_utility.trace('p_special_input_flag = ' || p_special_input_flag);
267: hr_utility.trace('p_stop_reach_rule = ' || p_stop_reach_rule);
268: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);

Line 265: hr_utility.trace('p_sep_check_option = ' || p_sep_check_option);

261: hr_utility.trace('p_ele_calc_ff_name = ' || l_ele_calc_ff_name);
262: hr_utility.trace('p_student_earning = ' || p_student_earning);
263: hr_utility.trace('p_dedn_proc = ' || p_dedn_proc);
264: hr_utility.trace('p_ele_priority = ' || p_ele_priority);
265: hr_utility.trace('p_sep_check_option = ' || p_sep_check_option);
266: hr_utility.trace('p_special_input_flag = ' || p_special_input_flag);
267: hr_utility.trace('p_stop_reach_rule = ' || p_stop_reach_rule);
268: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);
269: hr_utility.trace('p_ele_standard_link = ' || p_ele_standard_link);

Line 266: hr_utility.trace('p_special_input_flag = ' || p_special_input_flag);

262: hr_utility.trace('p_student_earning = ' || p_student_earning);
263: hr_utility.trace('p_dedn_proc = ' || p_dedn_proc);
264: hr_utility.trace('p_ele_priority = ' || p_ele_priority);
265: hr_utility.trace('p_sep_check_option = ' || p_sep_check_option);
266: hr_utility.trace('p_special_input_flag = ' || p_special_input_flag);
267: hr_utility.trace('p_stop_reach_rule = ' || p_stop_reach_rule);
268: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);
269: hr_utility.trace('p_ele_standard_link = ' || p_ele_standard_link);
270: hr_utility.trace('p_termination_rule = ' || p_termination_rule);

Line 267: hr_utility.trace('p_stop_reach_rule = ' || p_stop_reach_rule);

263: hr_utility.trace('p_dedn_proc = ' || p_dedn_proc);
264: hr_utility.trace('p_ele_priority = ' || p_ele_priority);
265: hr_utility.trace('p_sep_check_option = ' || p_sep_check_option);
266: hr_utility.trace('p_special_input_flag = ' || p_special_input_flag);
267: hr_utility.trace('p_stop_reach_rule = ' || p_stop_reach_rule);
268: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);
269: hr_utility.trace('p_ele_standard_link = ' || p_ele_standard_link);
270: hr_utility.trace('p_termination_rule = ' || p_termination_rule);
271:

Line 268: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);

264: hr_utility.trace('p_ele_priority = ' || p_ele_priority);
265: hr_utility.trace('p_sep_check_option = ' || p_sep_check_option);
266: hr_utility.trace('p_special_input_flag = ' || p_special_input_flag);
267: hr_utility.trace('p_stop_reach_rule = ' || p_stop_reach_rule);
268: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);
269: hr_utility.trace('p_ele_standard_link = ' || p_ele_standard_link);
270: hr_utility.trace('p_termination_rule = ' || p_termination_rule);
271:
272: IF (SUBSTR (l_ele_calc_ff_name, 1, 7) = 'PREMIUM') THEN

Line 269: hr_utility.trace('p_ele_standard_link = ' || p_ele_standard_link);

265: hr_utility.trace('p_sep_check_option = ' || p_sep_check_option);
266: hr_utility.trace('p_special_input_flag = ' || p_special_input_flag);
267: hr_utility.trace('p_stop_reach_rule = ' || p_stop_reach_rule);
268: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);
269: hr_utility.trace('p_ele_standard_link = ' || p_ele_standard_link);
270: hr_utility.trace('p_termination_rule = ' || p_termination_rule);
271:
272: IF (SUBSTR (l_ele_calc_ff_name, 1, 7) = 'PREMIUM') THEN
273: -- Modifying the Priority of PREMIUM Elements

Line 270: hr_utility.trace('p_termination_rule = ' || p_termination_rule);

266: hr_utility.trace('p_special_input_flag = ' || p_special_input_flag);
267: hr_utility.trace('p_stop_reach_rule = ' || p_stop_reach_rule);
268: hr_utility.trace('p_ele_processing_type = ' || p_ele_processing_type);
269: hr_utility.trace('p_ele_standard_link = ' || p_ele_standard_link);
270: hr_utility.trace('p_termination_rule = ' || p_termination_rule);
271:
272: IF (SUBSTR (l_ele_calc_ff_name, 1, 7) = 'PREMIUM') THEN
273: -- Modifying the Priority of PREMIUM Elements
274: l_ele_priority := 3300;

Line 312: hr_utility.trace('Using US Earnings template');

308: l_tw_rec.reporting_name := nvl(p_ele_reporting_name,p_ele_name);
309: l_tw_rec.standard_link := p_ele_standard_link;
310: l_tw_rec.termination_rule := p_termination_rule;
311: ELSE
312: hr_utility.trace('Using US Earnings template');
313: l_tw_rec.calculation_rule := 'US ' || p_ele_classification;
314: l_tw_rec.configuration_info_category := p_ele_category;
315: l_tw_rec.configuration_information1 := 'Y';
316: l_tw_rec.configuration_information2 := 'N';

Line 353: hr_utility.trace('20. Calling pay_us_earnings_template.create_element');

349: l_tw_rec.standard_link := p_ele_standard_link;
350: l_tw_rec.termination_rule := p_termination_rule;
351: END IF;
352:
353: hr_utility.trace('20. Calling pay_us_earnings_template.create_element');
354:
355: /* New Call */
356: pay_element_template_user_init.create_element
357: (p_validate => FALSE,

Line 398: hr_utility.set_location(l_proc, 35);

394: ,p_special_input_flag => p_special_input_flag
395: ,p_special_feature_flag => 'Y'
396: );*/
397:
398: hr_utility.set_location(l_proc, 35);
399: END IF; /* architecture */
400: END IF; /* Alien/Expat Earnings */
401:
402:

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

402:
403: --
404: RETURN (l_ele_type_id);
405: --
406: hr_utility.set_location('Leaving '||l_proc, 50);
407: --
408: -- HR_UTILITY.TRACE_OFF;
409: END create_earnings_element;
410:

Line 408: -- HR_UTILITY.TRACE_OFF;

404: RETURN (l_ele_type_id);
405: --
406: hr_utility.set_location('Leaving '||l_proc, 50);
407: --
408: -- HR_UTILITY.TRACE_OFF;
409: END create_earnings_element;
410:
411:
412:

Line 443: -- HR_UTILITY.TRACE_on(NULL,'rdhingra_pyuseewr');

439: AND template_type = 'U';
440:
441: BEGIN
442: --
443: -- HR_UTILITY.TRACE_on(NULL,'rdhingra_pyuseewr');
444: open c1;
445: fetch c1 into l_template_id;
446: Close c1;
447:

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

445: fetch c1 into l_template_id;
446: Close c1;
447:
448: l_proc := l_proc||'.delete_earnings_element';
449: hr_utility.set_location('Entering: '||l_proc, 10);
450: --
451:
452: g_ele_type_id := p_ele_type_id;
453:

Line 463: hr_utility.trace('Calling global package for delete');

459: ,p_ele_name => p_ele_name
460: ,p_effective_date => p_eff_start_date
461: );
462: */
463: hr_utility.trace('Calling global package for delete');
464: PAY_ELEMENT_TEMPLATE_USER_INIT.delete_element
465: (
466: p_validate => FALSE
467: ,p_template_id => l_template_id

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

465: (
466: p_validate => FALSE
467: ,p_template_id => l_template_id
468: );
469: hr_utility.set_location(l_proc, 20);
470: --
471: ELSE
472: -- call the old template deletion procedure
473: hr_user_init_earn.do_deletions

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

480: ,p_del_sess_date => p_session_date
481: ,p_del_val_start_date => p_eff_start_date
482: ,p_del_val_end_date => NULL
483: );
484: hr_utility.set_location(l_proc, 40);
485: --
486: END IF;
487: --
488: hr_utility.set_location('Leaving '||l_proc, 50);

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

484: hr_utility.set_location(l_proc, 40);
485: --
486: END IF;
487: --
488: hr_utility.set_location('Leaving '||l_proc, 50);
489: --
490: END delete_earnings_element;
491: --
492: --