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

Line 84: hr_utility.trace('Entering:' || g_package || 'get_balances');

80:
81: begin
82:
83: IF g_debug THEN
84: hr_utility.trace('Entering:' || g_package || 'get_balances');
85: hr_utility.trace('Assignment action id value ===>' || p_assignment_action_id);
86: hr_utility.trace('p_registered_employer ===>' || p_registered_employer);
87: END IF;
88:

Line 85: hr_utility.trace('Assignment action id value ===>' || p_assignment_action_id);

81: begin
82:
83: IF g_debug THEN
84: hr_utility.trace('Entering:' || g_package || 'get_balances');
85: hr_utility.trace('Assignment action id value ===>' || p_assignment_action_id);
86: hr_utility.trace('p_registered_employer ===>' || p_registered_employer);
87: END IF;
88:
89: /* Call to this function below implements Batch Balance Retrieval for better performance */

Line 86: hr_utility.trace('p_registered_employer ===>' || p_registered_employer);

82:
83: IF g_debug THEN
84: hr_utility.trace('Entering:' || g_package || 'get_balances');
85: hr_utility.trace('Assignment action id value ===>' || p_assignment_action_id);
86: hr_utility.trace('p_registered_employer ===>' || p_registered_employer);
87: END IF;
88:
89: /* Call to this function below implements Batch Balance Retrieval for better performance */
90:

Line 99: hr_utility.trace('Balance values for RUN dimension');

95: p_output_table=>g_result_table);
96:
97:
98: IF g_debug THEN
99: hr_utility.trace('Balance values for RUN dimension');
100: hr_utility.trace('-------------------------------------');
101: hr_utility.trace('Salaries_Wages ===>' || g_result_table(1).balance_value);
102: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
103: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);

Line 100: hr_utility.trace('-------------------------------------');

96:
97:
98: IF g_debug THEN
99: hr_utility.trace('Balance values for RUN dimension');
100: hr_utility.trace('-------------------------------------');
101: hr_utility.trace('Salaries_Wages ===>' || g_result_table(1).balance_value);
102: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
103: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
104: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);

Line 101: hr_utility.trace('Salaries_Wages ===>' || g_result_table(1).balance_value);

97:
98: IF g_debug THEN
99: hr_utility.trace('Balance values for RUN dimension');
100: hr_utility.trace('-------------------------------------');
101: hr_utility.trace('Salaries_Wages ===>' || g_result_table(1).balance_value);
102: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
103: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
104: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
105: hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);

Line 102: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);

98: IF g_debug THEN
99: hr_utility.trace('Balance values for RUN dimension');
100: hr_utility.trace('-------------------------------------');
101: hr_utility.trace('Salaries_Wages ===>' || g_result_table(1).balance_value);
102: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
103: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
104: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
105: hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
106: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value);

Line 103: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);

99: hr_utility.trace('Balance values for RUN dimension');
100: hr_utility.trace('-------------------------------------');
101: hr_utility.trace('Salaries_Wages ===>' || g_result_table(1).balance_value);
102: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
103: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
104: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
105: hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
106: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value);
107: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(7).balance_value);

Line 104: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);

100: hr_utility.trace('-------------------------------------');
101: hr_utility.trace('Salaries_Wages ===>' || g_result_table(1).balance_value);
102: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
103: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
104: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
105: hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
106: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value);
107: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(7).balance_value);
108: hr_utility.trace('Superannuation ===>' || g_result_table(8).balance_value);

Line 105: hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);

101: hr_utility.trace('Salaries_Wages ===>' || g_result_table(1).balance_value);
102: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
103: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
104: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
105: hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
106: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value);
107: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(7).balance_value);
108: hr_utility.trace('Superannuation ===>' || g_result_table(8).balance_value);
109: hr_utility.trace('Contractor_Payments ===>' || g_result_table(9).balance_value);

Line 106: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value);

102: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
103: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
104: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
105: hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
106: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value);
107: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(7).balance_value);
108: hr_utility.trace('Superannuation ===>' || g_result_table(8).balance_value);
109: hr_utility.trace('Contractor_Payments ===>' || g_result_table(9).balance_value);
110: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table(10).balance_value);

Line 107: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(7).balance_value);

103: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
104: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
105: hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
106: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value);
107: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(7).balance_value);
108: hr_utility.trace('Superannuation ===>' || g_result_table(8).balance_value);
109: hr_utility.trace('Contractor_Payments ===>' || g_result_table(9).balance_value);
110: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table(10).balance_value);
111: hr_utility.trace('Payroll_Taxable_income ===>' || g_result_table(11).balance_value);

Line 108: hr_utility.trace('Superannuation ===>' || g_result_table(8).balance_value);

104: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
105: hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
106: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value);
107: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(7).balance_value);
108: hr_utility.trace('Superannuation ===>' || g_result_table(8).balance_value);
109: hr_utility.trace('Contractor_Payments ===>' || g_result_table(9).balance_value);
110: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table(10).balance_value);
111: hr_utility.trace('Payroll_Taxable_income ===>' || g_result_table(11).balance_value);
112: END IF;

Line 109: hr_utility.trace('Contractor_Payments ===>' || g_result_table(9).balance_value);

105: hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
106: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value);
107: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(7).balance_value);
108: hr_utility.trace('Superannuation ===>' || g_result_table(8).balance_value);
109: hr_utility.trace('Contractor_Payments ===>' || g_result_table(9).balance_value);
110: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table(10).balance_value);
111: hr_utility.trace('Payroll_Taxable_income ===>' || g_result_table(11).balance_value);
112: END IF;
113:

Line 110: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table(10).balance_value);

106: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value);
107: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(7).balance_value);
108: hr_utility.trace('Superannuation ===>' || g_result_table(8).balance_value);
109: hr_utility.trace('Contractor_Payments ===>' || g_result_table(9).balance_value);
110: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table(10).balance_value);
111: hr_utility.trace('Payroll_Taxable_income ===>' || g_result_table(11).balance_value);
112: END IF;
113:
114:

Line 111: hr_utility.trace('Payroll_Taxable_income ===>' || g_result_table(11).balance_value);

107: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(7).balance_value);
108: hr_utility.trace('Superannuation ===>' || g_result_table(8).balance_value);
109: hr_utility.trace('Contractor_Payments ===>' || g_result_table(9).balance_value);
110: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table(10).balance_value);
111: hr_utility.trace('Payroll_Taxable_income ===>' || g_result_table(11).balance_value);
112: END IF;
113:
114:
115:

Line 180: hr_utility.trace('Balance values for RUN dimension for '||p_tax_state);

176: p_output_table=>g_result_table_state);
177: end if;
178:
179: IF g_debug THEN
180: hr_utility.trace('Balance values for RUN dimension for '||p_tax_state);
181: hr_utility.trace('-------------------------------------');
182: hr_utility.trace('Salaries_Wages ===>' || g_result_table_state(1).balance_value);
183: hr_utility.trace('Commission ==>' || g_result_table_state(2).balance_value);
184: hr_utility.trace('Bonus_Allowances ===>' || g_result_table_state(3).balance_value);

Line 181: hr_utility.trace('-------------------------------------');

177: end if;
178:
179: IF g_debug THEN
180: hr_utility.trace('Balance values for RUN dimension for '||p_tax_state);
181: hr_utility.trace('-------------------------------------');
182: hr_utility.trace('Salaries_Wages ===>' || g_result_table_state(1).balance_value);
183: hr_utility.trace('Commission ==>' || g_result_table_state(2).balance_value);
184: hr_utility.trace('Bonus_Allowances ===>' || g_result_table_state(3).balance_value);
185: hr_utility.trace('Director_Fees ===>' || g_result_table_state(4).balance_value);

Line 182: hr_utility.trace('Salaries_Wages ===>' || g_result_table_state(1).balance_value);

178:
179: IF g_debug THEN
180: hr_utility.trace('Balance values for RUN dimension for '||p_tax_state);
181: hr_utility.trace('-------------------------------------');
182: hr_utility.trace('Salaries_Wages ===>' || g_result_table_state(1).balance_value);
183: hr_utility.trace('Commission ==>' || g_result_table_state(2).balance_value);
184: hr_utility.trace('Bonus_Allowances ===>' || g_result_table_state(3).balance_value);
185: hr_utility.trace('Director_Fees ===>' || g_result_table_state(4).balance_value);
186: hr_utility.trace('Fringe_Benefits ===>' || g_result_table_state(5).balance_value);

Line 183: hr_utility.trace('Commission ==>' || g_result_table_state(2).balance_value);

179: IF g_debug THEN
180: hr_utility.trace('Balance values for RUN dimension for '||p_tax_state);
181: hr_utility.trace('-------------------------------------');
182: hr_utility.trace('Salaries_Wages ===>' || g_result_table_state(1).balance_value);
183: hr_utility.trace('Commission ==>' || g_result_table_state(2).balance_value);
184: hr_utility.trace('Bonus_Allowances ===>' || g_result_table_state(3).balance_value);
185: hr_utility.trace('Director_Fees ===>' || g_result_table_state(4).balance_value);
186: hr_utility.trace('Fringe_Benefits ===>' || g_result_table_state(5).balance_value);
187: hr_utility.trace('Superannuation ===>' || g_result_table_state(6).balance_value);

Line 184: hr_utility.trace('Bonus_Allowances ===>' || g_result_table_state(3).balance_value);

180: hr_utility.trace('Balance values for RUN dimension for '||p_tax_state);
181: hr_utility.trace('-------------------------------------');
182: hr_utility.trace('Salaries_Wages ===>' || g_result_table_state(1).balance_value);
183: hr_utility.trace('Commission ==>' || g_result_table_state(2).balance_value);
184: hr_utility.trace('Bonus_Allowances ===>' || g_result_table_state(3).balance_value);
185: hr_utility.trace('Director_Fees ===>' || g_result_table_state(4).balance_value);
186: hr_utility.trace('Fringe_Benefits ===>' || g_result_table_state(5).balance_value);
187: hr_utility.trace('Superannuation ===>' || g_result_table_state(6).balance_value);
188: hr_utility.trace('Contractor_Payments ===>' || g_result_table_state(7).balance_value);

Line 185: hr_utility.trace('Director_Fees ===>' || g_result_table_state(4).balance_value);

181: hr_utility.trace('-------------------------------------');
182: hr_utility.trace('Salaries_Wages ===>' || g_result_table_state(1).balance_value);
183: hr_utility.trace('Commission ==>' || g_result_table_state(2).balance_value);
184: hr_utility.trace('Bonus_Allowances ===>' || g_result_table_state(3).balance_value);
185: hr_utility.trace('Director_Fees ===>' || g_result_table_state(4).balance_value);
186: hr_utility.trace('Fringe_Benefits ===>' || g_result_table_state(5).balance_value);
187: hr_utility.trace('Superannuation ===>' || g_result_table_state(6).balance_value);
188: hr_utility.trace('Contractor_Payments ===>' || g_result_table_state(7).balance_value);
189: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table_state(8).balance_value);

Line 186: hr_utility.trace('Fringe_Benefits ===>' || g_result_table_state(5).balance_value);

182: hr_utility.trace('Salaries_Wages ===>' || g_result_table_state(1).balance_value);
183: hr_utility.trace('Commission ==>' || g_result_table_state(2).balance_value);
184: hr_utility.trace('Bonus_Allowances ===>' || g_result_table_state(3).balance_value);
185: hr_utility.trace('Director_Fees ===>' || g_result_table_state(4).balance_value);
186: hr_utility.trace('Fringe_Benefits ===>' || g_result_table_state(5).balance_value);
187: hr_utility.trace('Superannuation ===>' || g_result_table_state(6).balance_value);
188: hr_utility.trace('Contractor_Payments ===>' || g_result_table_state(7).balance_value);
189: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table_state(8).balance_value);
190: END IF;

Line 187: hr_utility.trace('Superannuation ===>' || g_result_table_state(6).balance_value);

183: hr_utility.trace('Commission ==>' || g_result_table_state(2).balance_value);
184: hr_utility.trace('Bonus_Allowances ===>' || g_result_table_state(3).balance_value);
185: hr_utility.trace('Director_Fees ===>' || g_result_table_state(4).balance_value);
186: hr_utility.trace('Fringe_Benefits ===>' || g_result_table_state(5).balance_value);
187: hr_utility.trace('Superannuation ===>' || g_result_table_state(6).balance_value);
188: hr_utility.trace('Contractor_Payments ===>' || g_result_table_state(7).balance_value);
189: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table_state(8).balance_value);
190: END IF;
191:

Line 188: hr_utility.trace('Contractor_Payments ===>' || g_result_table_state(7).balance_value);

184: hr_utility.trace('Bonus_Allowances ===>' || g_result_table_state(3).balance_value);
185: hr_utility.trace('Director_Fees ===>' || g_result_table_state(4).balance_value);
186: hr_utility.trace('Fringe_Benefits ===>' || g_result_table_state(5).balance_value);
187: hr_utility.trace('Superannuation ===>' || g_result_table_state(6).balance_value);
188: hr_utility.trace('Contractor_Payments ===>' || g_result_table_state(7).balance_value);
189: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table_state(8).balance_value);
190: END IF;
191:
192:

Line 189: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table_state(8).balance_value);

185: hr_utility.trace('Director_Fees ===>' || g_result_table_state(4).balance_value);
186: hr_utility.trace('Fringe_Benefits ===>' || g_result_table_state(5).balance_value);
187: hr_utility.trace('Superannuation ===>' || g_result_table_state(6).balance_value);
188: hr_utility.trace('Contractor_Payments ===>' || g_result_table_state(7).balance_value);
189: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table_state(8).balance_value);
190: END IF;
191:
192:
193:

Line 234: --hr_utility.trace_on(null,'SKSHIN');

230: AND p_start_date between effective_start_date and effective_end_date
231: ;
232:
233: BEGIN
234: --hr_utility.trace_on(null,'SKSHIN');
235:
236: l_inputs(1).name := 'STATE_CODE';
237: l_inputs(1).value := p_state_code;
238: l_inputs(2).name := 'TAXABLE_INCOME';

Line 258: hr_utility.trace('PAYROLL_TAX input(1) p_state_code : '||nvl(l_inputs(1).value,'ZZZ'));

254: OPEN c_formula;
255: FETCH c_formula into l_formula_id;
256: CLOSE c_formula;
257:
258: hr_utility.trace('PAYROLL_TAX input(1) p_state_code : '||nvl(l_inputs(1).value,'ZZZ'));
259: hr_utility.trace('PAYROLL_TAX input(2) p_taxable_income : '||nvl(l_inputs(2).value,0));
260: hr_utility.trace('PAYROLL_TAX input(3) p_override_threshold :'||nvl(l_inputs(3).value,0));
261: hr_utility.trace('PAYROLL_TAX input(4) p_dge_state : '||nvl(l_inputs(4).value,'ZZZ'));
262: hr_utility.trace('PAYROLL_TAX input(5) p_le_taxable_income : '||nvl(l_inputs(5).value,0));

Line 259: hr_utility.trace('PAYROLL_TAX input(2) p_taxable_income : '||nvl(l_inputs(2).value,0));

255: FETCH c_formula into l_formula_id;
256: CLOSE c_formula;
257:
258: hr_utility.trace('PAYROLL_TAX input(1) p_state_code : '||nvl(l_inputs(1).value,'ZZZ'));
259: hr_utility.trace('PAYROLL_TAX input(2) p_taxable_income : '||nvl(l_inputs(2).value,0));
260: hr_utility.trace('PAYROLL_TAX input(3) p_override_threshold :'||nvl(l_inputs(3).value,0));
261: hr_utility.trace('PAYROLL_TAX input(4) p_dge_state : '||nvl(l_inputs(4).value,'ZZZ'));
262: hr_utility.trace('PAYROLL_TAX input(5) p_le_taxable_income : '||nvl(l_inputs(5).value,0));
263: hr_utility.trace('PAYROLL_TAX input(6) p_no_of_states : '||nvl(l_inputs(6).value,0));

Line 260: hr_utility.trace('PAYROLL_TAX input(3) p_override_threshold :'||nvl(l_inputs(3).value,0));

256: CLOSE c_formula;
257:
258: hr_utility.trace('PAYROLL_TAX input(1) p_state_code : '||nvl(l_inputs(1).value,'ZZZ'));
259: hr_utility.trace('PAYROLL_TAX input(2) p_taxable_income : '||nvl(l_inputs(2).value,0));
260: hr_utility.trace('PAYROLL_TAX input(3) p_override_threshold :'||nvl(l_inputs(3).value,0));
261: hr_utility.trace('PAYROLL_TAX input(4) p_dge_state : '||nvl(l_inputs(4).value,'ZZZ'));
262: hr_utility.trace('PAYROLL_TAX input(5) p_le_taxable_income : '||nvl(l_inputs(5).value,0));
263: hr_utility.trace('PAYROLL_TAX input(6) p_no_of_states : '||nvl(l_inputs(6).value,0));
264: hr_utility.trace('PAYROLL_TAX input(7) p_dge_group_name : '||nvl(l_inputs(7).value,'ZZZ'));

Line 261: hr_utility.trace('PAYROLL_TAX input(4) p_dge_state : '||nvl(l_inputs(4).value,'ZZZ'));

257:
258: hr_utility.trace('PAYROLL_TAX input(1) p_state_code : '||nvl(l_inputs(1).value,'ZZZ'));
259: hr_utility.trace('PAYROLL_TAX input(2) p_taxable_income : '||nvl(l_inputs(2).value,0));
260: hr_utility.trace('PAYROLL_TAX input(3) p_override_threshold :'||nvl(l_inputs(3).value,0));
261: hr_utility.trace('PAYROLL_TAX input(4) p_dge_state : '||nvl(l_inputs(4).value,'ZZZ'));
262: hr_utility.trace('PAYROLL_TAX input(5) p_le_taxable_income : '||nvl(l_inputs(5).value,0));
263: hr_utility.trace('PAYROLL_TAX input(6) p_no_of_states : '||nvl(l_inputs(6).value,0));
264: hr_utility.trace('PAYROLL_TAX input(7) p_dge_group_name : '||nvl(l_inputs(7).value,'ZZZ'));
265:

Line 262: hr_utility.trace('PAYROLL_TAX input(5) p_le_taxable_income : '||nvl(l_inputs(5).value,0));

258: hr_utility.trace('PAYROLL_TAX input(1) p_state_code : '||nvl(l_inputs(1).value,'ZZZ'));
259: hr_utility.trace('PAYROLL_TAX input(2) p_taxable_income : '||nvl(l_inputs(2).value,0));
260: hr_utility.trace('PAYROLL_TAX input(3) p_override_threshold :'||nvl(l_inputs(3).value,0));
261: hr_utility.trace('PAYROLL_TAX input(4) p_dge_state : '||nvl(l_inputs(4).value,'ZZZ'));
262: hr_utility.trace('PAYROLL_TAX input(5) p_le_taxable_income : '||nvl(l_inputs(5).value,0));
263: hr_utility.trace('PAYROLL_TAX input(6) p_no_of_states : '||nvl(l_inputs(6).value,0));
264: hr_utility.trace('PAYROLL_TAX input(7) p_dge_group_name : '||nvl(l_inputs(7).value,'ZZZ'));
265:
266: per_formula_functions.run_formula(p_formula_id => l_formula_id,

Line 263: hr_utility.trace('PAYROLL_TAX input(6) p_no_of_states : '||nvl(l_inputs(6).value,0));

259: hr_utility.trace('PAYROLL_TAX input(2) p_taxable_income : '||nvl(l_inputs(2).value,0));
260: hr_utility.trace('PAYROLL_TAX input(3) p_override_threshold :'||nvl(l_inputs(3).value,0));
261: hr_utility.trace('PAYROLL_TAX input(4) p_dge_state : '||nvl(l_inputs(4).value,'ZZZ'));
262: hr_utility.trace('PAYROLL_TAX input(5) p_le_taxable_income : '||nvl(l_inputs(5).value,0));
263: hr_utility.trace('PAYROLL_TAX input(6) p_no_of_states : '||nvl(l_inputs(6).value,0));
264: hr_utility.trace('PAYROLL_TAX input(7) p_dge_group_name : '||nvl(l_inputs(7).value,'ZZZ'));
265:
266: per_formula_functions.run_formula(p_formula_id => l_formula_id,
267: p_calculation_date => last_day(p_start_date),

Line 264: hr_utility.trace('PAYROLL_TAX input(7) p_dge_group_name : '||nvl(l_inputs(7).value,'ZZZ'));

260: hr_utility.trace('PAYROLL_TAX input(3) p_override_threshold :'||nvl(l_inputs(3).value,0));
261: hr_utility.trace('PAYROLL_TAX input(4) p_dge_state : '||nvl(l_inputs(4).value,'ZZZ'));
262: hr_utility.trace('PAYROLL_TAX input(5) p_le_taxable_income : '||nvl(l_inputs(5).value,0));
263: hr_utility.trace('PAYROLL_TAX input(6) p_no_of_states : '||nvl(l_inputs(6).value,0));
264: hr_utility.trace('PAYROLL_TAX input(7) p_dge_group_name : '||nvl(l_inputs(7).value,'ZZZ'));
265:
266: per_formula_functions.run_formula(p_formula_id => l_formula_id,
267: p_calculation_date => last_day(p_start_date),
268: p_inputs => l_inputs,

Line 272: hr_utility.trace('l_outputs(1).value :'||l_outputs(1).value);

268: p_inputs => l_inputs,
269: p_outputs => l_outputs);
270:
271: l_tax := l_outputs(2).value;
272: hr_utility.trace('l_outputs(1).value :'||l_outputs(1).value);
273: hr_utility.trace('l_outputs(2).value :'||l_outputs(2).value);
274: hr_utility.trace('l_outputs(3).value :'||l_outputs(3).value);
275:
276: IF l_outputs(1).value = 'ZZZZ' THEN

Line 273: hr_utility.trace('l_outputs(2).value :'||l_outputs(2).value);

269: p_outputs => l_outputs);
270:
271: l_tax := l_outputs(2).value;
272: hr_utility.trace('l_outputs(1).value :'||l_outputs(1).value);
273: hr_utility.trace('l_outputs(2).value :'||l_outputs(2).value);
274: hr_utility.trace('l_outputs(3).value :'||l_outputs(3).value);
275:
276: IF l_outputs(1).value = 'ZZZZ' THEN
277: p_message:=null;

Line 274: hr_utility.trace('l_outputs(3).value :'||l_outputs(3).value);

270:
271: l_tax := l_outputs(2).value;
272: hr_utility.trace('l_outputs(1).value :'||l_outputs(1).value);
273: hr_utility.trace('l_outputs(2).value :'||l_outputs(2).value);
274: hr_utility.trace('l_outputs(3).value :'||l_outputs(3).value);
275:
276: IF l_outputs(1).value = 'ZZZZ' THEN
277: p_message:=null;
278: ELSE

Line 288: hr_utility.trace('p_message :'||p_message);

284: ELSE
285: p_ot_message := l_outputs(3).value;
286: END IF;
287:
288: hr_utility.trace('p_message :'||p_message);
289: hr_utility.trace('l_tax :'||l_tax);
290: return(l_tax);
291:
292: EXCEPTION when others THEN

Line 289: hr_utility.trace('l_tax :'||l_tax);

285: p_ot_message := l_outputs(3).value;
286: END IF;
287:
288: hr_utility.trace('p_message :'||p_message);
289: hr_utility.trace('l_tax :'||l_tax);
290: return(l_tax);
291:
292: EXCEPTION when others THEN
293: RAISE_APPLICATION_ERROR(-20001,'Function get_tax ' ||sqlerrm);

Line 510: hr_utility.trace('Entering:' || g_package || 'populate_defined_balance_ids');

506: /* end 14134526 */
507:
508: BEGIN
509:
510: hr_utility.trace('Entering:' || g_package || 'populate_defined_balance_ids');
511:
512: g_balance_value_tab.delete;
513:
514: l_run_dimension_name := '_ASG_LE_RUN';

Line 601: g_debug :=hr_utility.debug_enabled ;

597: l_procedure varchar2(200) ;
598:
599: begin
600:
601: g_debug :=hr_utility.debug_enabled ;
602:
603: l_procedure := g_package||'range_code';
604: hr_utility.set_location('Entering '||l_procedure,1);
605:

Line 604: hr_utility.set_location('Entering '||l_procedure,1);

600:
601: g_debug :=hr_utility.debug_enabled ;
602:
603: l_procedure := g_package||'range_code';
604: hr_utility.set_location('Entering '||l_procedure,1);
605:
606: -- Archive the payroll action level data and EIT defintions.
607: -- sql string to SELECT a range of assignments eligible for archival.
608: p_sql := ' select distinct p.person_id' ||

Line 615: hr_utility.set_location('Leaving '||l_procedure,1000);

611: ' where pa.payroll_action_id = :payroll_action_id' ||
612: ' and p.business_group_id = pa.business_group_id' ||
613: ' order by p.person_id';
614:
615: hr_utility.set_location('Leaving '||l_procedure,1000);
616:
617: end range_code;
618:
619: procedure initialization_code

Line 740: g_debug :=hr_utility.debug_enabled ;

736:
737:
738: Begin
739:
740: g_debug :=hr_utility.debug_enabled ;
741: g_package := 'pay_au_tax_report_pkg.' ;
742: l_procedure := g_package||'initialization_code';
743: hr_utility.set_location('Entering '||l_procedure,1);
744:

Line 743: hr_utility.set_location('Entering '||l_procedure,1);

739:
740: g_debug :=hr_utility.debug_enabled ;
741: g_package := 'pay_au_tax_report_pkg.' ;
742: l_procedure := g_package||'initialization_code';
743: hr_utility.set_location('Entering '||l_procedure,1);
744:
745:
746: -- initialization_code to to set the global tables for EIT
747: -- that will be used by each thread in multi-threading.

Line 759: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);

755: CLOSE csr_params;
756:
757:
758: IF g_debug THEN
759: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
760: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
761: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
762: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
763: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);

Line 760: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);

756:
757:
758: IF g_debug THEN
759: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
760: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
761: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
762: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
763: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
764: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);

Line 761: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);

757:
758: IF g_debug THEN
759: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
760: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
761: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
762: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
763: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
764: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
765: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);

Line 762: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);

758: IF g_debug THEN
759: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
760: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
761: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
762: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
763: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
764: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
765: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
766: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);

Line 763: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);

759: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
760: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
761: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
762: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
763: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
764: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
765: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
766: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
767: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);

Line 764: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);

760: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
761: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
762: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
763: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
764: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
765: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
766: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
767: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
768: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);

Line 765: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);

761: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
762: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
763: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
764: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
765: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
766: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
767: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
768: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
769: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);

Line 766: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);

762: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
763: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
764: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
765: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
766: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
767: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
768: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
769: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
770: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);

Line 767: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);

763: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
764: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
765: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
766: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
767: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
768: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
769: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
770: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
771: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);

Line 768: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);

764: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
765: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
766: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
767: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
768: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
769: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
770: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
771: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
772: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);

Line 769: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);

765: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
766: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
767: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
768: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
769: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
770: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
771: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
772: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
773: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);

Line 770: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);

766: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
767: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
768: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
769: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
770: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
771: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
772: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
773: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
774: end if;

Line 771: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);

767: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
768: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
769: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
770: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
771: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
772: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
773: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
774: end if;
775:

Line 772: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);

768: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
769: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
770: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
771: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
772: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
773: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
774: end if;
775:
776: g_business_group_id := g_parameters.business_group_id ;

Line 773: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);

769: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
770: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
771: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
772: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
773: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
774: end if;
775:
776: g_business_group_id := g_parameters.business_group_id ;
777:

Line 806: hr_utility.set_location('l_term_defined ' || l_term_defined_balance_id,99);

802: open csr_etpaytax_defined_balance('_ASG_LE_RUN', csr_le_rec.per_information2); /* 4718544 */
803: fetch csr_etpaytax_defined_balance into l_elig_term_defined_balance_id;
804: close csr_etpaytax_defined_balance;
805:
806: hr_utility.set_location('l_term_defined ' || l_term_defined_balance_id,99);
807: hr_utility.set_location('per_information ' || csr_le_rec.per_information2,99);
808:
809: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id,
810: csr_le_rec.assignment_action_id, csr_le_rec.tax_unit_id, null,null,null,null);

Line 807: hr_utility.set_location('per_information ' || csr_le_rec.per_information2,99);

803: fetch csr_etpaytax_defined_balance into l_elig_term_defined_balance_id;
804: close csr_etpaytax_defined_balance;
805:
806: hr_utility.set_location('l_term_defined ' || l_term_defined_balance_id,99);
807: hr_utility.set_location('per_information ' || csr_le_rec.per_information2,99);
808:
809: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id,
810: csr_le_rec.assignment_action_id, csr_le_rec.tax_unit_id, null,null,null,null);
811:

Line 822: hr_utility.set_location('l_balanace_value ' || l_balance_value,999);

818:
819: l_elig_term_balance_value := pay_balance_pkg.get_value(l_elig_term_defined_balance_id,
820: csr_le_rec.assignment_action_id, csr_le_rec.tax_unit_id, null,null,null,null);
821:
822: hr_utility.set_location('l_balanace_value ' || l_balance_value,999);
823:
824: g_le_taxable_income := nvl(g_le_taxable_income,0) + l_balance_value;
825:
826: if g_prev_tax_state <> csr_le_rec.per_information2

Line 837: hr_utility.set_location('g_count '||g_count,1000);

833:
834: END LOOP;
835: /* 4713372 */
836: if g_debug then
837: hr_utility.set_location('g_count '||g_count,1000);
838: hr_utility.set_location('g_le_taxable_income '||g_le_taxable_income,1000);
839: hr_utility.set_location('Leaving '||l_procedure,1000);
840: end if;
841:

Line 838: hr_utility.set_location('g_le_taxable_income '||g_le_taxable_income,1000);

834: END LOOP;
835: /* 4713372 */
836: if g_debug then
837: hr_utility.set_location('g_count '||g_count,1000);
838: hr_utility.set_location('g_le_taxable_income '||g_le_taxable_income,1000);
839: hr_utility.set_location('Leaving '||l_procedure,1000);
840: end if;
841:
842: end initialization_code;

Line 839: hr_utility.set_location('Leaving '||l_procedure,1000);

835: /* 4713372 */
836: if g_debug then
837: hr_utility.set_location('g_count '||g_count,1000);
838: hr_utility.set_location('g_le_taxable_income '||g_le_taxable_income,1000);
839: hr_utility.set_location('Leaving '||l_procedure,1000);
840: end if;
841:
842: end initialization_code;
843:

Line 969: hr_utility.set_location('Entering ' || l_procedure,1);

965: begin
966: i := 1;
967: g_package := 'pay_au_tax_rep_pkg.' ;
968: l_procedure := g_package||'assignment_action_code';
969: hr_utility.set_location('Entering ' || l_procedure,1);
970: hr_utility.set_location('Entering assignment_Action_code',302);
971:
972:
973: -- initialization_code to to set the global tables for EIT

Line 970: hr_utility.set_location('Entering assignment_Action_code',302);

966: i := 1;
967: g_package := 'pay_au_tax_rep_pkg.' ;
968: l_procedure := g_package||'assignment_action_code';
969: hr_utility.set_location('Entering ' || l_procedure,1);
970: hr_utility.set_location('Entering assignment_Action_code',302);
971:
972:
973: -- initialization_code to to set the global tables for EIT
974: -- that will be used by each thread in multi-threading.

Line 976: hr_utility.set_location('p_payroll_Action' || p_payroll_Action_id, 777);

972:
973: -- initialization_code to to set the global tables for EIT
974: -- that will be used by each thread in multi-threading.
975: g_arc_payroll_action_id := p_payroll_action_id;
976: hr_utility.set_location('p_payroll_Action' || p_payroll_Action_id, 777);
977:
978: -- Fetch the parameters by user passed into global variable.
979:
980: OPEN csr_params(p_payroll_action_id);

Line 987: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);

983:
984:
985: IF g_debug THEN
986:
987: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
988: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
989: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
990: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
991: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);

Line 988: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);

984:
985: IF g_debug THEN
986:
987: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
988: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
989: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
990: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
991: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
992: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);

Line 989: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);

985: IF g_debug THEN
986:
987: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
988: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
989: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
990: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
991: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
992: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
993: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);

Line 990: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);

986:
987: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
988: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
989: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
990: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
991: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
992: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
993: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
994: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);

Line 991: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);

987: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
988: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
989: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
990: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
991: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
992: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
993: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
994: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
995: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);

Line 992: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);

988: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
989: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
990: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
991: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
992: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
993: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
994: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
995: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
996: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);

Line 993: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);

989: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
990: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
991: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
992: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
993: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
994: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
995: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
996: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
997: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);

Line 994: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);

990: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
991: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
992: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
993: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
994: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
995: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
996: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
997: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
998: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);

Line 995: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);

991: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
992: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
993: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
994: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
995: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
996: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
997: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
998: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
999: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);

Line 996: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);

992: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
993: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
994: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
995: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
996: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
997: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
998: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
999: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
1000: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);

Line 997: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);

993: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
994: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
995: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
996: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
997: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
998: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
999: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
1000: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
1001: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);

Line 998: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);

994: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
995: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
996: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
997: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
998: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
999: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
1000: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
1001: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
1002:

Line 999: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);

995: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
996: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
997: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
998: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
999: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
1000: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
1001: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
1002:
1003: end if;

Line 1000: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);

996: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
997: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
998: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
999: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
1000: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
1001: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
1002:
1003: end if;
1004:

Line 1001: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);

997: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
998: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
999: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
1000: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
1001: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
1002:
1003: end if;
1004:
1005: g_business_group_id := g_parameters.business_group_id ;

Line 1021: hr_utility.set_location('in loop' , 555);

1017: g_parameters.start_date,
1018: g_parameters.end_date,
1019: g_parameters.tax_state)
1020: LOOP
1021: hr_utility.set_location('in loop' , 555);
1022: open csr_next_action_id;
1023: fetch csr_next_action_id into l_next_assignment_action_id;
1024: close csr_next_action_id;
1025:

Line 1059: hr_utility.set_location('Leaving............Loop7. Asg + Period...' || l_procedure,1000);

1055:
1056:
1057: END LOOP;
1058: if g_debug then
1059: hr_utility.set_location('Leaving............Loop7. Asg + Period...' || l_procedure,1000);
1060: end if;
1061:
1062: exception
1063: when others then

Line 1064: hr_utility.set_location('Error in '||l_procedure,999999);

1060: end if;
1061:
1062: exception
1063: when others then
1064: hr_utility.set_location('Error in '||l_procedure,999999);
1065: raise;
1066: end assignment_action_code;
1067:
1068: procedure archive_code

Line 1273: g_debug :=hr_utility.debug_enabled ;

1269: /* end 14134526 */
1270:
1271: begin
1272:
1273: g_debug :=hr_utility.debug_enabled ;
1274: g_package := 'pay_au_tax_rep_pkg.' ;
1275: l_procedure := g_package||'archive_code';
1276: l_run_dimension_name := '_ASG_LE_RUN';
1277:

Line 1361: hr_utility.set_location('in BBR loop', 300);

1357: /* end 14134526 */
1358:
1359:
1360:
1361: hr_utility.set_location('in BBR loop', 300);
1362: insert into pay_action_information(
1363: action_information_id,
1364: action_context_id,
1365: action_context_type,

Line 1528: g_debug :=hr_utility.debug_enabled ;

1524:
1525: Begin
1526: l_count :=0;
1527: ps_request_id :=-1;
1528: g_debug :=hr_utility.debug_enabled ;
1529:
1530:
1531: if g_debug then
1532: g_package := 'pay_au_tax_rep_pkg.' ;

Line 1534: hr_utility.set_location('Entering '||l_procedure,999);

1530:
1531: if g_debug then
1532: g_package := 'pay_au_tax_rep_pkg.' ;
1533: l_procedure := g_package||' spawn_archive_reports';
1534: hr_utility.set_location('Entering '||l_procedure,999);
1535: end if;
1536:
1537: -- Set User Parameters for Report.
1538: open csr_get_report_name(p_payroll_action_id);

Line 1564: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);

1560: END IF;
1561: /* End 6839263 */
1562:
1563: if g_debug then
1564: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1565: hr_utility.set_location('g_parameters.business_group_id.........= ' || l_parameters.business_group_id,30);
1566: hr_utility.set_location('g_parameters.legal_employer.........= ' || l_parameters.legal_employer,30);
1567: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1568: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);

Line 1565: hr_utility.set_location('g_parameters.business_group_id.........= ' || l_parameters.business_group_id,30);

1561: /* End 6839263 */
1562:
1563: if g_debug then
1564: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1565: hr_utility.set_location('g_parameters.business_group_id.........= ' || l_parameters.business_group_id,30);
1566: hr_utility.set_location('g_parameters.legal_employer.........= ' || l_parameters.legal_employer,30);
1567: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1568: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1569: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);

Line 1566: hr_utility.set_location('g_parameters.legal_employer.........= ' || l_parameters.legal_employer,30);

1562:
1563: if g_debug then
1564: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1565: hr_utility.set_location('g_parameters.business_group_id.........= ' || l_parameters.business_group_id,30);
1566: hr_utility.set_location('g_parameters.legal_employer.........= ' || l_parameters.legal_employer,30);
1567: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1568: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1569: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1570: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);

Line 1567: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);

1563: if g_debug then
1564: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1565: hr_utility.set_location('g_parameters.business_group_id.........= ' || l_parameters.business_group_id,30);
1566: hr_utility.set_location('g_parameters.legal_employer.........= ' || l_parameters.legal_employer,30);
1567: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1568: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1569: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1570: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1571: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);

Line 1568: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);

1564: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1565: hr_utility.set_location('g_parameters.business_group_id.........= ' || l_parameters.business_group_id,30);
1566: hr_utility.set_location('g_parameters.legal_employer.........= ' || l_parameters.legal_employer,30);
1567: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1568: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1569: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1570: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1571: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1572: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);

Line 1569: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);

1565: hr_utility.set_location('g_parameters.business_group_id.........= ' || l_parameters.business_group_id,30);
1566: hr_utility.set_location('g_parameters.legal_employer.........= ' || l_parameters.legal_employer,30);
1567: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1568: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1569: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1570: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1571: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1572: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1573: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);

Line 1570: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);

1566: hr_utility.set_location('g_parameters.legal_employer.........= ' || l_parameters.legal_employer,30);
1567: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1568: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1569: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1570: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1571: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1572: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1573: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1574: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);

Line 1571: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);

1567: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1568: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1569: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1570: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1571: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1572: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1573: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1574: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1575: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);

Line 1572: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);

1568: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1569: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1570: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1571: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1572: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1573: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1574: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1575: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1576: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);

Line 1573: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);

1569: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1570: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1571: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1572: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1573: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1574: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1575: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1576: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);
1577: hr_utility.set_location('g_parameters.sa_threshold..........= '||l_parameters.sa_override_threshold,30);

Line 1574: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);

1570: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1571: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1572: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1573: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1574: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1575: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1576: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);
1577: hr_utility.set_location('g_parameters.sa_threshold..........= '||l_parameters.sa_override_threshold,30);
1578: hr_utility.set_location('g_parameters.nt_threshold..........= '||l_parameters.nt_override_threshold,30);

Line 1575: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);

1571: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1572: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1573: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1574: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1575: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1576: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);
1577: hr_utility.set_location('g_parameters.sa_threshold..........= '||l_parameters.sa_override_threshold,30);
1578: hr_utility.set_location('g_parameters.nt_threshold..........= '||l_parameters.nt_override_threshold,30);
1579: hr_utility.set_location('Output Type = '||l_parameters.p_output_type,30);

Line 1576: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);

1572: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1573: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1574: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1575: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1576: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);
1577: hr_utility.set_location('g_parameters.sa_threshold..........= '||l_parameters.sa_override_threshold,30);
1578: hr_utility.set_location('g_parameters.nt_threshold..........= '||l_parameters.nt_override_threshold,30);
1579: hr_utility.set_location('Output Type = '||l_parameters.p_output_type,30);
1580: end if;

Line 1577: hr_utility.set_location('g_parameters.sa_threshold..........= '||l_parameters.sa_override_threshold,30);

1573: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1574: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1575: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1576: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);
1577: hr_utility.set_location('g_parameters.sa_threshold..........= '||l_parameters.sa_override_threshold,30);
1578: hr_utility.set_location('g_parameters.nt_threshold..........= '||l_parameters.nt_override_threshold,30);
1579: hr_utility.set_location('Output Type = '||l_parameters.p_output_type,30);
1580: end if;
1581:

Line 1578: hr_utility.set_location('g_parameters.nt_threshold..........= '||l_parameters.nt_override_threshold,30);

1574: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1575: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1576: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);
1577: hr_utility.set_location('g_parameters.sa_threshold..........= '||l_parameters.sa_override_threshold,30);
1578: hr_utility.set_location('g_parameters.nt_threshold..........= '||l_parameters.nt_override_threshold,30);
1579: hr_utility.set_location('Output Type = '||l_parameters.p_output_type,30);
1580: end if;
1581:
1582:

Line 1579: hr_utility.set_location('Output Type = '||l_parameters.p_output_type,30);

1575: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1576: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);
1577: hr_utility.set_location('g_parameters.sa_threshold..........= '||l_parameters.sa_override_threshold,30);
1578: hr_utility.set_location('g_parameters.nt_threshold..........= '||l_parameters.nt_override_threshold,30);
1579: hr_utility.set_location('Output Type = '||l_parameters.p_output_type,30);
1580: end if;
1581:
1582:
1583: OPEN csr_get_print_options(p_payroll_action_id);

Line 1598: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,25);

1594: save_output => hr_general.char_to_bool(rec_print_options.save_output),
1595: print_together => l_print_together);
1596: -- Submit report
1597: if g_debug then
1598: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,25);
1599: end if;
1600:
1601: ps_request_id := fnd_request.submit_request
1602: ('PAY',

Line 1644: hr_utility.set_location('ps_request ' || ps_request_id, 35);

1640:
1641: request_error := fnd_message.get;
1642:
1643: if g_debug then
1644: hr_utility.set_location('ps_request ' || ps_request_id, 35);
1645:
1646: hr_utility.set_location('After calling report',24);
1647:
1648: end if;

Line 1646: hr_utility.set_location('After calling report',24);

1642:
1643: if g_debug then
1644: hr_utility.set_location('ps_request ' || ps_request_id, 35);
1645:
1646: hr_utility.set_location('After calling report',24);
1647:
1648: end if;
1649: exception
1650: when others then

Line 1654: hr_utility.set_location('erro_msg ' || err_msg, 200);

1650: when others then
1651: err_num := SQLCODE;
1652: err_msg := substr(sqlerrm,1,100);
1653:
1654: hr_utility.set_location('erro_msg ' || err_msg, 200);
1655:
1656: end spawn_archive_reports;
1657:
1658: