eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_AU_PAYTAX_PKG dependencies on HR_UTILITY

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

71:
72: begin
73:
74: IF g_debug THEN
75: hr_utility.trace('Entering:' || g_package || 'get_balances');
76: hr_utility.trace('Assignment action id value ===>' || p_assignment_action_id);
77: hr_utility.trace('p_registered_employer ===>' || p_registered_employer);
78: END IF;
79:

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

72: begin
73:
74: IF g_debug THEN
75: hr_utility.trace('Entering:' || g_package || 'get_balances');
76: hr_utility.trace('Assignment action id value ===>' || p_assignment_action_id);
77: hr_utility.trace('p_registered_employer ===>' || p_registered_employer);
78: END IF;
79:
80: /* Call to this function below implements Batch Balance Retrieval for better performance */

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

73:
74: IF g_debug THEN
75: hr_utility.trace('Entering:' || g_package || 'get_balances');
76: hr_utility.trace('Assignment action id value ===>' || p_assignment_action_id);
77: hr_utility.trace('p_registered_employer ===>' || p_registered_employer);
78: END IF;
79:
80: /* Call to this function below implements Batch Balance Retrieval for better performance */
81:

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

86: p_output_table=>g_result_table);
87:
88:
89:
90: hr_utility.trace('Balance values for RUN dimension');
91: hr_utility.trace('-------------------------------------');
92: hr_utility.trace('Salaries_Wages ===>' || g_result_table(1).balance_value);
93: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
94: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);

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

87:
88:
89:
90: hr_utility.trace('Balance values for RUN dimension');
91: hr_utility.trace('-------------------------------------');
92: hr_utility.trace('Salaries_Wages ===>' || g_result_table(1).balance_value);
93: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
94: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
95: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);

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

88:
89:
90: hr_utility.trace('Balance values for RUN dimension');
91: hr_utility.trace('-------------------------------------');
92: hr_utility.trace('Salaries_Wages ===>' || g_result_table(1).balance_value);
93: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
94: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
95: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
96: /* hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);

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

89:
90: hr_utility.trace('Balance values for RUN dimension');
91: hr_utility.trace('-------------------------------------');
92: hr_utility.trace('Salaries_Wages ===>' || g_result_table(1).balance_value);
93: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
94: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
95: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
96: /* hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
97: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value); */

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

90: hr_utility.trace('Balance values for RUN dimension');
91: hr_utility.trace('-------------------------------------');
92: hr_utility.trace('Salaries_Wages ===>' || g_result_table(1).balance_value);
93: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
94: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
95: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
96: /* hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
97: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value); */
98: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(6).balance_value);

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

91: hr_utility.trace('-------------------------------------');
92: hr_utility.trace('Salaries_Wages ===>' || g_result_table(1).balance_value);
93: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
94: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
95: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
96: /* hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
97: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value); */
98: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(6).balance_value);
99: hr_utility.trace('Superannuation ===>' || g_result_table(7).balance_value);

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

92: hr_utility.trace('Salaries_Wages ===>' || g_result_table(1).balance_value);
93: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
94: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
95: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
96: /* hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
97: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value); */
98: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(6).balance_value);
99: hr_utility.trace('Superannuation ===>' || g_result_table(7).balance_value);
100: hr_utility.trace('Contractor_Payments ===>' || g_result_table(8).balance_value);

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

93: hr_utility.trace('Commission ==>' || g_result_table(2).balance_value);
94: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
95: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
96: /* hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
97: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value); */
98: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(6).balance_value);
99: hr_utility.trace('Superannuation ===>' || g_result_table(7).balance_value);
100: hr_utility.trace('Contractor_Payments ===>' || g_result_table(8).balance_value);
101: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table(9).balance_value);

Line 98: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(6).balance_value);

94: hr_utility.trace('Bonus_Allowances ===>' || g_result_table(3).balance_value);
95: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
96: /* hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
97: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value); */
98: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(6).balance_value);
99: hr_utility.trace('Superannuation ===>' || g_result_table(7).balance_value);
100: hr_utility.trace('Contractor_Payments ===>' || g_result_table(8).balance_value);
101: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table(9).balance_value);
102: hr_utility.trace('Payroll_Taxable_income ===>' || g_result_table(10).balance_value);

Line 99: hr_utility.trace('Superannuation ===>' || g_result_table(7).balance_value);

95: hr_utility.trace('Director_Fees ===>' || g_result_table(4).balance_value);
96: /* hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
97: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value); */
98: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(6).balance_value);
99: hr_utility.trace('Superannuation ===>' || g_result_table(7).balance_value);
100: hr_utility.trace('Contractor_Payments ===>' || g_result_table(8).balance_value);
101: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table(9).balance_value);
102: hr_utility.trace('Payroll_Taxable_income ===>' || g_result_table(10).balance_value);
103:

Line 100: hr_utility.trace('Contractor_Payments ===>' || g_result_table(8).balance_value);

96: /* hr_utility.trace('Termination_Payments===>' || g_result_table(5).balance_value);
97: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value); */
98: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(6).balance_value);
99: hr_utility.trace('Superannuation ===>' || g_result_table(7).balance_value);
100: hr_utility.trace('Contractor_Payments ===>' || g_result_table(8).balance_value);
101: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table(9).balance_value);
102: hr_utility.trace('Payroll_Taxable_income ===>' || g_result_table(10).balance_value);
103:
104:

Line 101: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table(9).balance_value);

97: hr_utility.trace('Elgiible_Termination_Payments ===>' || g_result_table(6).balance_value); */
98: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(6).balance_value);
99: hr_utility.trace('Superannuation ===>' || g_result_table(7).balance_value);
100: hr_utility.trace('Contractor_Payments ===>' || g_result_table(8).balance_value);
101: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table(9).balance_value);
102: hr_utility.trace('Payroll_Taxable_income ===>' || g_result_table(10).balance_value);
103:
104:
105:

Line 102: hr_utility.trace('Payroll_Taxable_income ===>' || g_result_table(10).balance_value);

98: hr_utility.trace('Fringe_Benefits ===>' || g_result_table(6).balance_value);
99: hr_utility.trace('Superannuation ===>' || g_result_table(7).balance_value);
100: hr_utility.trace('Contractor_Payments ===>' || g_result_table(8).balance_value);
101: hr_utility.trace('Other_Taxable_Income ===>' || g_result_table(9).balance_value);
102: hr_utility.trace('Payroll_Taxable_income ===>' || g_result_table(10).balance_value);
103:
104:
105:
106:

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

190: p_inputs => l_inputs,
191: p_outputs => l_outputs);
192:
193: l_tax := l_outputs(2).value;
194: hr_utility.trace('l_outputs(1).value :'||l_outputs(1).value);
195: hr_utility.trace('l_outputs(2).value :'||l_outputs(2).value);
196: hr_utility.trace('l_outputs(3).value :'||l_outputs(3).value);
197:
198: IF l_outputs(1).value = 'ZZZZ' THEN

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

191: p_outputs => l_outputs);
192:
193: l_tax := l_outputs(2).value;
194: hr_utility.trace('l_outputs(1).value :'||l_outputs(1).value);
195: hr_utility.trace('l_outputs(2).value :'||l_outputs(2).value);
196: hr_utility.trace('l_outputs(3).value :'||l_outputs(3).value);
197:
198: IF l_outputs(1).value = 'ZZZZ' THEN
199: p_message:=null;

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

192:
193: l_tax := l_outputs(2).value;
194: hr_utility.trace('l_outputs(1).value :'||l_outputs(1).value);
195: hr_utility.trace('l_outputs(2).value :'||l_outputs(2).value);
196: hr_utility.trace('l_outputs(3).value :'||l_outputs(3).value);
197:
198: IF l_outputs(1).value = 'ZZZZ' THEN
199: p_message:=null;
200: ELSE

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

206: ELSE
207: p_ot_message := l_outputs(3).value;
208: END IF;
209:
210: hr_utility.trace('p_message :'||p_message);
211: hr_utility.trace('l_tax :'||l_tax);
212: return(l_tax);
213:
214: EXCEPTION when others THEN

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

207: p_ot_message := l_outputs(3).value;
208: END IF;
209:
210: hr_utility.trace('p_message :'||p_message);
211: hr_utility.trace('l_tax :'||l_tax);
212: return(l_tax);
213:
214: EXCEPTION when others THEN
215: RAISE_APPLICATION_ERROR(-20001,'Function get_tax ' ||sqlerrm);

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

249: l_ytd_dimension_name VARCHAR2(15);
250:
251: BEGIN
252:
253: hr_utility.trace('Entering:' || g_package || 'populate_defined_balance_ids');
254:
255: g_balance_value_tab.delete;
256:
257: l_run_dimension_name := '_ASG_LE_RUN';

Line 303: g_debug :=hr_utility.debug_enabled ;

299: l_procedure varchar2(200) ;
300:
301: begin
302:
303: g_debug :=hr_utility.debug_enabled ;
304:
305: l_procedure := g_package||'range_code';
306: hr_utility.set_location('Entering '||l_procedure,1);
307:

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

302:
303: g_debug :=hr_utility.debug_enabled ;
304:
305: l_procedure := g_package||'range_code';
306: hr_utility.set_location('Entering '||l_procedure,1);
307:
308: -- Archive the payroll action level data and EIT defintions.
309: -- sql string to SELECT a range of assignments eligible for archival.
310: p_sql := ' select distinct p.person_id' ||

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

313: ' where pa.payroll_action_id = :payroll_action_id' ||
314: ' and p.business_group_id = pa.business_group_id' ||
315: ' order by p.person_id';
316:
317: hr_utility.set_location('Leaving '||l_procedure,1000);
318:
319: end range_code;
320:
321: procedure initialization_code

Line 441: g_debug :=hr_utility.debug_enabled ;

437: order by per_information2;
438:
439:
440: Begin
441: g_debug :=hr_utility.debug_enabled ;
442: g_package := 'pay_au_tax_report_pkg.' ;
443: l_procedure := g_package||'initialization_code';
444: hr_utility.set_location('Entering '||l_procedure,1);
445:

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

440: Begin
441: g_debug :=hr_utility.debug_enabled ;
442: g_package := 'pay_au_tax_report_pkg.' ;
443: l_procedure := g_package||'initialization_code';
444: hr_utility.set_location('Entering '||l_procedure,1);
445:
446:
447: -- initialization_code to to set the global tables for EIT
448: -- that will be used by each thread in multi-threading.

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

456: CLOSE csr_params;
457:
458:
459: IF g_debug THEN
460: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
461: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
462: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
463: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
464: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);

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

457:
458:
459: IF g_debug THEN
460: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
461: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
462: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
463: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
464: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
465: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);

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

458:
459: IF g_debug THEN
460: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
461: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
462: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
463: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
464: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
465: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
466: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);

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

459: IF g_debug THEN
460: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
461: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
462: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
463: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
464: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
465: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
466: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
467: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);

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

460: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
461: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
462: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
463: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
464: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
465: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
466: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
467: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
468: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);

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

461: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
462: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
463: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
464: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
465: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
466: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
467: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
468: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
469: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);

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

462: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
463: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
464: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
465: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
466: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
467: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
468: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
469: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
470: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);

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

463: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
464: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
465: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
466: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
467: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
468: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
469: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
470: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
471: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);

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

464: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
465: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
466: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
467: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
468: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
469: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
470: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
471: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
472: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);

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

465: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
466: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
467: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
468: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
469: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
470: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
471: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
472: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
473: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);

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

466: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
467: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
468: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
469: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
470: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
471: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
472: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
473: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
474: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);

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

467: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
468: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
469: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
470: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
471: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
472: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
473: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
474: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
475: end if;

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

468: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
469: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
470: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
471: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
472: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
473: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
474: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
475: end if;
476:

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

469: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
470: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
471: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
472: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
473: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
474: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
475: end if;
476:
477: g_business_group_id := g_parameters.business_group_id ;

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

470: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
471: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
472: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
473: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
474: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
475: end if;
476:
477: g_business_group_id := g_parameters.business_group_id ;
478:

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

503: open csr_etpaytax_defined_balance('_ASG_LE_RUN', csr_le_rec.per_information2); /* 4718544 */
504: fetch csr_etpaytax_defined_balance into l_elig_term_defined_balance_id;
505: close csr_etpaytax_defined_balance;
506:
507: hr_utility.set_location('l_term_defined ' || l_term_defined_balance_id,99);
508: hr_utility.set_location('per_information ' || csr_le_rec.per_information2,99);
509:
510: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id,
511: csr_le_rec.assignment_action_id, csr_le_rec.tax_unit_id, null,null,null,null);

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

504: fetch csr_etpaytax_defined_balance into l_elig_term_defined_balance_id;
505: close csr_etpaytax_defined_balance;
506:
507: hr_utility.set_location('l_term_defined ' || l_term_defined_balance_id,99);
508: hr_utility.set_location('per_information ' || csr_le_rec.per_information2,99);
509:
510: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id,
511: csr_le_rec.assignment_action_id, csr_le_rec.tax_unit_id, null,null,null,null);
512:

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

519:
520: l_elig_term_balance_value := pay_balance_pkg.get_value(l_elig_term_defined_balance_id,
521: csr_le_rec.assignment_action_id, csr_le_rec.tax_unit_id, null,null,null,null);
522:
523: hr_utility.set_location('l_balanace_value ' || l_balance_value,999);
524:
525: g_le_taxable_income := nvl(g_le_taxable_income,0) + l_balance_value;
526:
527: if g_prev_tax_state <> csr_le_rec.per_information2

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

534:
535: END LOOP;
536: /* 4713372 */
537: if g_debug then
538: hr_utility.set_location('Leaving '||l_procedure,1000);
539: end if;
540:
541: end initialization_code;
542:

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

664: begin
665: i := 1;
666: g_package := 'pay_au_tax_rep_pkg.' ;
667: l_procedure := g_package||'assignment_action_code';
668: hr_utility.set_location('Entering ' || l_procedure,1);
669: hr_utility.set_location('Entering assignment_Action_code',302);
670:
671:
672: -- initialization_code to to set the global tables for EIT

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

665: i := 1;
666: g_package := 'pay_au_tax_rep_pkg.' ;
667: l_procedure := g_package||'assignment_action_code';
668: hr_utility.set_location('Entering ' || l_procedure,1);
669: hr_utility.set_location('Entering assignment_Action_code',302);
670:
671:
672: -- initialization_code to to set the global tables for EIT
673: -- that will be used by each thread in multi-threading.

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

671:
672: -- initialization_code to to set the global tables for EIT
673: -- that will be used by each thread in multi-threading.
674: g_arc_payroll_action_id := p_payroll_action_id;
675: hr_utility.set_location('p_payroll_Action' || p_payroll_Action_id, 777);
676:
677: -- Fetch the parameters by user passed into global variable.
678:
679: OPEN csr_params(p_payroll_action_id);

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

682:
683:
684: IF g_debug THEN
685:
686: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
687: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
688: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
689: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
690: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);

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

683:
684: IF g_debug THEN
685:
686: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
687: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
688: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
689: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
690: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
691: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);

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

684: IF g_debug THEN
685:
686: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
687: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
688: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
689: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
690: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
691: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
692: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);

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

685:
686: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
687: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
688: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
689: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
690: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
691: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
692: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
693: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);

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

686: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
687: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
688: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
689: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
690: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
691: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
692: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
693: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
694: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);

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

687: hr_utility.set_location('g_parameters.business_group_id.........= ' || g_parameters.business_group_id,30);
688: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
689: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
690: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
691: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
692: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
693: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
694: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
695: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);

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

688: hr_utility.set_location('g_parameters.legal_employer.........= ' || g_parameters.legal_employer,30);
689: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
690: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
691: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
692: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
693: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
694: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
695: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
696: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);

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

689: hr_utility.set_location('g_parameters.start_date..............= ' || g_parameters.start_date,30);
690: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
691: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
692: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
693: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
694: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
695: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
696: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
697: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);

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

690: hr_utility.set_location('g_parameters.end_date................= ' || g_parameters.end_date,30);
691: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
692: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
693: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
694: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
695: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
696: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
697: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
698: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);

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

691: hr_utility.set_location('g_parameters.tax_state.........= ' || g_parameters.tax_state,30);
692: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
693: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
694: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
695: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
696: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
697: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
698: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
699: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);

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

692: hr_utility.set_location('g_parameters.report_type..........= '||g_parameters.report_type,30);
693: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
694: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
695: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
696: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
697: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
698: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
699: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
700: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);

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

693: hr_utility.set_location('g_parameters.act_threshold..........= '||g_parameters.act_override_threshold,30);
694: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
695: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
696: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
697: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
698: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
699: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
700: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
701:

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

694: hr_utility.set_location('g_parameters.vic_threshold..........= '||g_parameters.vic_override_threshold,30);
695: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
696: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
697: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
698: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
699: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
700: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
701:
702: end if;

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

695: hr_utility.set_location('g_parameters.qld_threshold..........= '||g_parameters.qld_override_threshold,30);
696: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
697: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
698: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
699: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
700: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
701:
702: end if;
703:

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

696: hr_utility.set_location('g_parameters.nsw_threshold..........= '||g_parameters.nsw_override_threshold,30);
697: hr_utility.set_location('g_parameters.tas_threshold..........= '||g_parameters.tas_override_threshold,30);
698: hr_utility.set_location('g_parameters.wa_threshold..........= '||g_parameters.wa_override_threshold,30);
699: hr_utility.set_location('g_parameters.sa_threshold..........= '||g_parameters.sa_override_threshold,30);
700: hr_utility.set_location('g_parameters.nt_threshold..........= '||g_parameters.nt_override_threshold,30);
701:
702: end if;
703:
704: g_business_group_id := g_parameters.business_group_id ;

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

716: g_parameters.start_date,
717: g_parameters.end_date,
718: g_parameters.tax_state)
719: LOOP
720: hr_utility.set_location('in loop' , 555);
721: open csr_next_action_id;
722: fetch csr_next_action_id into l_next_assignment_action_id;
723: close csr_next_action_id;
724:

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

754:
755:
756: END LOOP;
757: if g_debug then
758: hr_utility.set_location('Leaving............Loop7. Asg + Period...' || l_procedure,1000);
759: end if;
760:
761: exception
762: when others then

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

759: end if;
760:
761: exception
762: when others then
763: hr_utility.set_location('Error in '||l_procedure,999999);
764: raise;
765: end assignment_action_code;
766:
767: procedure archive_code

Line 961: g_debug :=hr_utility.debug_enabled ;

957: l_defined_balance_id number;
958:
959: begin
960:
961: g_debug :=hr_utility.debug_enabled ;
962: g_package := 'pay_au_tax_rep_pkg.' ;
963: l_procedure := g_package||'archive_code';
964: l_run_dimension_name := '_ASG_LE_RUN';
965:

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

1022: P_CONTRACTOR_PAYMENTS => l_CONTRACTOR_PAYMENTS,
1023: P_OTHER_TAXABLE_INCOME => l_OTHER_TAXABLE_INCOME,
1024: P_TAXABLE_INCOME => l_TAXABLE_INCOME);
1025:
1026: hr_utility.set_location('in BBR loop', 300);
1027: insert into pay_action_information(
1028: action_information_id,
1029: action_context_id,
1030: action_context_type,

Line 1193: g_debug :=hr_utility.debug_enabled ;

1189:
1190: Begin
1191: l_count :=0;
1192: ps_request_id :=-1;
1193: g_debug :=hr_utility.debug_enabled ;
1194:
1195:
1196: if g_debug then
1197: g_package := 'pay_au_tax_rep_pkg.' ;

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

1195:
1196: if g_debug then
1197: g_package := 'pay_au_tax_rep_pkg.' ;
1198: l_procedure := g_package||' spawn_archive_reports';
1199: hr_utility.set_location('Entering '||l_procedure,999);
1200: end if;
1201:
1202: -- Set User Parameters for Report.
1203: open csr_get_report_name(p_payroll_action_id);

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

1225: END IF;
1226: /* End 6839263 */
1227:
1228: if g_debug then
1229: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1230: hr_utility.set_location('g_parameters.business_group_id.........= ' || l_parameters.business_group_id,30);
1231: hr_utility.set_location('g_parameters.legal_employer.........= ' || l_parameters.legal_employer,30);
1232: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1233: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);

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

1226: /* End 6839263 */
1227:
1228: if g_debug then
1229: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1230: hr_utility.set_location('g_parameters.business_group_id.........= ' || l_parameters.business_group_id,30);
1231: hr_utility.set_location('g_parameters.legal_employer.........= ' || l_parameters.legal_employer,30);
1232: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1233: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1234: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);

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

1227:
1228: if g_debug then
1229: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1230: hr_utility.set_location('g_parameters.business_group_id.........= ' || l_parameters.business_group_id,30);
1231: hr_utility.set_location('g_parameters.legal_employer.........= ' || l_parameters.legal_employer,30);
1232: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1233: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1234: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1235: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);

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

1228: if g_debug then
1229: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1230: hr_utility.set_location('g_parameters.business_group_id.........= ' || l_parameters.business_group_id,30);
1231: hr_utility.set_location('g_parameters.legal_employer.........= ' || l_parameters.legal_employer,30);
1232: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1233: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1234: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1235: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1236: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);

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

1229: hr_utility.set_location('p_payroll_action_id.........= ' || p_payroll_action_id,30);
1230: hr_utility.set_location('g_parameters.business_group_id.........= ' || l_parameters.business_group_id,30);
1231: hr_utility.set_location('g_parameters.legal_employer.........= ' || l_parameters.legal_employer,30);
1232: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1233: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1234: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1235: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1236: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1237: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);

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

1230: hr_utility.set_location('g_parameters.business_group_id.........= ' || l_parameters.business_group_id,30);
1231: hr_utility.set_location('g_parameters.legal_employer.........= ' || l_parameters.legal_employer,30);
1232: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1233: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1234: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1235: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1236: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1237: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1238: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);

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

1231: hr_utility.set_location('g_parameters.legal_employer.........= ' || l_parameters.legal_employer,30);
1232: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1233: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1234: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1235: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1236: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1237: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1238: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1239: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);

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

1232: hr_utility.set_location('g_parameters.start_date..............= ' || l_parameters.start_date,30);
1233: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1234: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1235: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1236: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1237: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1238: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1239: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1240: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);

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

1233: hr_utility.set_location('g_parameters.end_date................= ' || l_parameters.end_date,30);
1234: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1235: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1236: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1237: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1238: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1239: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1240: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1241: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);

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

1234: hr_utility.set_location('g_parameters.tax_state.........= ' || l_parameters.tax_state,30);
1235: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1236: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1237: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1238: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1239: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1240: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1241: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);
1242: hr_utility.set_location('g_parameters.sa_threshold..........= '||l_parameters.sa_override_threshold,30);

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

1235: hr_utility.set_location('g_parameters.report_type..........= '||l_parameters.report_type,30);
1236: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1237: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1238: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1239: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1240: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1241: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);
1242: hr_utility.set_location('g_parameters.sa_threshold..........= '||l_parameters.sa_override_threshold,30);
1243: hr_utility.set_location('g_parameters.nt_threshold..........= '||l_parameters.nt_override_threshold,30);

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

1236: hr_utility.set_location('g_parameters.act_threshold..........= '||l_parameters.act_override_threshold,30);
1237: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1238: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1239: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1240: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1241: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);
1242: hr_utility.set_location('g_parameters.sa_threshold..........= '||l_parameters.sa_override_threshold,30);
1243: hr_utility.set_location('g_parameters.nt_threshold..........= '||l_parameters.nt_override_threshold,30);
1244: hr_utility.set_location('Output Type = '||l_parameters.p_output_type,30);

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

1237: hr_utility.set_location('g_parameters.vic_threshold..........= '||l_parameters.vic_override_threshold,30);
1238: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1239: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1240: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1241: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);
1242: hr_utility.set_location('g_parameters.sa_threshold..........= '||l_parameters.sa_override_threshold,30);
1243: hr_utility.set_location('g_parameters.nt_threshold..........= '||l_parameters.nt_override_threshold,30);
1244: hr_utility.set_location('Output Type = '||l_parameters.p_output_type,30);
1245: end if;

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

1238: hr_utility.set_location('g_parameters.qld_threshold..........= '||l_parameters.qld_override_threshold,30);
1239: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1240: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1241: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);
1242: hr_utility.set_location('g_parameters.sa_threshold..........= '||l_parameters.sa_override_threshold,30);
1243: hr_utility.set_location('g_parameters.nt_threshold..........= '||l_parameters.nt_override_threshold,30);
1244: hr_utility.set_location('Output Type = '||l_parameters.p_output_type,30);
1245: end if;
1246:

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

1239: hr_utility.set_location('g_parameters.nsw_threshold..........= '||l_parameters.nsw_override_threshold,30);
1240: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1241: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);
1242: hr_utility.set_location('g_parameters.sa_threshold..........= '||l_parameters.sa_override_threshold,30);
1243: hr_utility.set_location('g_parameters.nt_threshold..........= '||l_parameters.nt_override_threshold,30);
1244: hr_utility.set_location('Output Type = '||l_parameters.p_output_type,30);
1245: end if;
1246:
1247:

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

1240: hr_utility.set_location('g_parameters.tas_threshold..........= '||l_parameters.tas_override_threshold,30);
1241: hr_utility.set_location('g_parameters.wa_threshold..........= '||l_parameters.wa_override_threshold,30);
1242: hr_utility.set_location('g_parameters.sa_threshold..........= '||l_parameters.sa_override_threshold,30);
1243: hr_utility.set_location('g_parameters.nt_threshold..........= '||l_parameters.nt_override_threshold,30);
1244: hr_utility.set_location('Output Type = '||l_parameters.p_output_type,30);
1245: end if;
1246:
1247:
1248: OPEN csr_get_print_options(p_payroll_action_id);

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

1259: save_output => hr_general.char_to_bool(rec_print_options.save_output),
1260: print_together => l_print_together);
1261: -- Submit report
1262: if g_debug then
1263: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,25);
1264: end if;
1265:
1266: ps_request_id := fnd_request.submit_request
1267: ('PAY',

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

1305:
1306: request_error := fnd_message.get;
1307:
1308: if g_debug then
1309: hr_utility.set_location('ps_request ' || ps_request_id, 35);
1310:
1311: hr_utility.set_location('After calling report',24);
1312:
1313: end if;

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

1307:
1308: if g_debug then
1309: hr_utility.set_location('ps_request ' || ps_request_id, 35);
1310:
1311: hr_utility.set_location('After calling report',24);
1312:
1313: end if;
1314: exception
1315: when others then

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

1315: when others then
1316: err_num := SQLCODE;
1317: err_msg := substr(sqlerrm,1,100);
1318:
1319: hr_utility.set_location('erro_msg ' || err_msg, 200);
1320:
1321: end spawn_archive_reports;
1322:
1323: