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

Line 113: hr_utility.trace('Entering load_data ...' ||SQLERRM);

109: BEGIN
110:
111: /*Inserts final calculated values into temp table*/
112:
113: hr_utility.trace('Entering load_data ...' ||SQLERRM);
114:
115:
116:
117: INSERT INTO pay_us_rpt_totals

Line 166: hr_utility.trace('Error occurred load balances...' ||SQLERRM);

162: EXCEPTION
163: ---------
164: WHEN OTHERS THEN
165:
166: hr_utility.trace('Error occurred load balances...' ||SQLERRM);
167:
168: END load_balances;
169:
170: FUNCTION get_legislation_code (p_business_group_id IN NUMBER)

Line 178: hr_utility.trace('Enter Legislation code');

174: IS
175:
176: l_legislation_code_l per_business_groups.legislation_code%TYPE;
177: BEGIN
178: hr_utility.trace('Enter Legislation code');
179: SELECT legislation_code
180: INTO l_legislation_code_l
181: FROM per_business_groups
182: WHERE business_group_id =p_business_group_id;

Line 185: hr_utility.trace('Leaving Legislation code' );

181: FROM per_business_groups
182: WHERE business_group_id =p_business_group_id;
183:
184: RETURN (l_legislation_code_l);
185: hr_utility.trace('Leaving Legislation code' );
186:
187: EXCEPTION
188: ---------
189: WHEN OTHERS THEN

Line 253: hr_utility.trace('l_instr_count :'||l_instr_count);

249: CLOSE c_get_bal_dim;
250:
251: pay_ip_wrapper.get_ip_installation(p_legislation_code, l_supported_loc);
252:
253: hr_utility.trace('l_instr_count :'||l_instr_count);
254: hr_utility.trace('l_instr_count1 :'||l_instr_count1);
255: hr_utility.trace('l_instr_count2 :'||l_instr_count2);
256: hr_utility.trace('l_instr_count3 :'||l_instr_count3);
257: hr_utility.trace('g_gre_id :'||g_gre_id);

Line 254: hr_utility.trace('l_instr_count1 :'||l_instr_count1);

250:
251: pay_ip_wrapper.get_ip_installation(p_legislation_code, l_supported_loc);
252:
253: hr_utility.trace('l_instr_count :'||l_instr_count);
254: hr_utility.trace('l_instr_count1 :'||l_instr_count1);
255: hr_utility.trace('l_instr_count2 :'||l_instr_count2);
256: hr_utility.trace('l_instr_count3 :'||l_instr_count3);
257: hr_utility.trace('g_gre_id :'||g_gre_id);
258: hr_utility.trace('l_organization_id :'||l_organization_id);

Line 255: hr_utility.trace('l_instr_count2 :'||l_instr_count2);

251: pay_ip_wrapper.get_ip_installation(p_legislation_code, l_supported_loc);
252:
253: hr_utility.trace('l_instr_count :'||l_instr_count);
254: hr_utility.trace('l_instr_count1 :'||l_instr_count1);
255: hr_utility.trace('l_instr_count2 :'||l_instr_count2);
256: hr_utility.trace('l_instr_count3 :'||l_instr_count3);
257: hr_utility.trace('g_gre_id :'||g_gre_id);
258: hr_utility.trace('l_organization_id :'||l_organization_id);
259: hr_utility.trace('l_tax_unit_id :'||l_tax_unit_id);

Line 256: hr_utility.trace('l_instr_count3 :'||l_instr_count3);

252:
253: hr_utility.trace('l_instr_count :'||l_instr_count);
254: hr_utility.trace('l_instr_count1 :'||l_instr_count1);
255: hr_utility.trace('l_instr_count2 :'||l_instr_count2);
256: hr_utility.trace('l_instr_count3 :'||l_instr_count3);
257: hr_utility.trace('g_gre_id :'||g_gre_id);
258: hr_utility.trace('l_organization_id :'||l_organization_id);
259: hr_utility.trace('l_tax_unit_id :'||l_tax_unit_id);
260:

Line 257: hr_utility.trace('g_gre_id :'||g_gre_id);

253: hr_utility.trace('l_instr_count :'||l_instr_count);
254: hr_utility.trace('l_instr_count1 :'||l_instr_count1);
255: hr_utility.trace('l_instr_count2 :'||l_instr_count2);
256: hr_utility.trace('l_instr_count3 :'||l_instr_count3);
257: hr_utility.trace('g_gre_id :'||g_gre_id);
258: hr_utility.trace('l_organization_id :'||l_organization_id);
259: hr_utility.trace('l_tax_unit_id :'||l_tax_unit_id);
260:
261: IF p_legislation_code='GB' AND ( p_comp_type='IC' OR p_comp_type='MC'

Line 258: hr_utility.trace('l_organization_id :'||l_organization_id);

254: hr_utility.trace('l_instr_count1 :'||l_instr_count1);
255: hr_utility.trace('l_instr_count2 :'||l_instr_count2);
256: hr_utility.trace('l_instr_count3 :'||l_instr_count3);
257: hr_utility.trace('g_gre_id :'||g_gre_id);
258: hr_utility.trace('l_organization_id :'||l_organization_id);
259: hr_utility.trace('l_tax_unit_id :'||l_tax_unit_id);
260:
261: IF p_legislation_code='GB' AND ( p_comp_type='IC' OR p_comp_type='MC'
262: OR p_comp_type='PADP' OR p_comp_type='PADT'

Line 259: hr_utility.trace('l_tax_unit_id :'||l_tax_unit_id);

255: hr_utility.trace('l_instr_count2 :'||l_instr_count2);
256: hr_utility.trace('l_instr_count3 :'||l_instr_count3);
257: hr_utility.trace('g_gre_id :'||g_gre_id);
258: hr_utility.trace('l_organization_id :'||l_organization_id);
259: hr_utility.trace('l_tax_unit_id :'||l_tax_unit_id);
260:
261: IF p_legislation_code='GB' AND ( p_comp_type='IC' OR p_comp_type='MC'
262: OR p_comp_type='PADP' OR p_comp_type='PADT'
263: OR p_comp_type= 'PANP' OR p_comp_type= 'PANT'

Line 266: hr_utility.trace('Enter GB Legislation');

262: OR p_comp_type='PADP' OR p_comp_type='PADT'
263: OR p_comp_type= 'PANP' OR p_comp_type= 'PANT'
264: OR p_comp_type= 'PC' OR p_comp_type= 'PP'
265: OR p_comp_type= 'QC' OR p_comp_type= 'YC') THEN
266: hr_utility.trace('Enter GB Legislation');
267: --l_ret_value:=hr_gbbal.calc_all_balances (p_paydate, p_assignment_id,p_defined_balance_id);
268: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
269: --Commented out as we are using a wrapper after the bug was fixed for PTD dim.
270: -- l_ret_value:=hr_dirbal.get_balance(p_assignment_id,p_defined_balance_id,p_paydate );

Line 271: hr_utility.trace('Leaving GB Legislation');

267: --l_ret_value:=hr_gbbal.calc_all_balances (p_paydate, p_assignment_id,p_defined_balance_id);
268: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
269: --Commented out as we are using a wrapper after the bug was fixed for PTD dim.
270: -- l_ret_value:=hr_dirbal.get_balance(p_assignment_id,p_defined_balance_id,p_paydate );
271: hr_utility.trace('Leaving GB Legislation');
272: p_errmsg:='NOERROR' ;
273: --MAN,MP,QAN,QP,YP
274: ELSIF p_legislation_code='GB' AND ( p_comp_type='MAN' OR p_comp_type= 'MP'
275: OR p_comp_type= 'QAN' OR p_comp_type= 'QP'

Line 305: hr_utility.trace('Entering US OR CA Legislation');

301: END IF;
302: IF g_jd_code IS NOT NULL THEN
303: pay_balance_pkg.set_context('JURISDICTION_CODE',g_jd_code);
304: END IF;
305: hr_utility.trace('Entering US OR CA Legislation');
306: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
307: hr_utility.trace('Leaving US OR CA Legislation');
308: p_errmsg:='NOERROR' ;
309:

Line 307: hr_utility.trace('Leaving US OR CA Legislation');

303: pay_balance_pkg.set_context('JURISDICTION_CODE',g_jd_code);
304: END IF;
305: hr_utility.trace('Entering US OR CA Legislation');
306: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
307: hr_utility.trace('Leaving US OR CA Legislation');
308: p_errmsg:='NOERROR' ;
309:
310: ELSIF (l_instr_count3 > 0 AND l_supported_loc = 'N') THEN
311: hr_utility.trace('Entered IP Tax Unit case');

Line 311: hr_utility.trace('Entered IP Tax Unit case');

307: hr_utility.trace('Leaving US OR CA Legislation');
308: p_errmsg:='NOERROR' ;
309:
310: ELSIF (l_instr_count3 > 0 AND l_supported_loc = 'N') THEN
311: hr_utility.trace('Entered IP Tax Unit case');
312: SELECT hsck.segment1 INTO l_tax_unit
313: FROM hr_soft_coding_keyflex hsck, per_all_assignments_f paaf
314: WHERE paaf.assignment_id = p_assignment_id
315: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id

Line 318: hr_utility.trace('Tax unit ID :'||l_tax_unit);

314: WHERE paaf.assignment_id = p_assignment_id
315: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
316: AND sysdate BETWEEN paaf.effective_start_date AND paaf.effective_end_date;
317:
318: hr_utility.trace('Tax unit ID :'||l_tax_unit);
319: IF l_tax_unit IS NOT NULL THEN
320: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_tax_unit);
321: END IF;
322: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );

Line 323: hr_utility.trace('l_ret_value :'||l_ret_value);

319: IF l_tax_unit IS NOT NULL THEN
320: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_tax_unit);
321: END IF;
322: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
323: hr_utility.trace('l_ret_value :'||l_ret_value);
324:
325: ELSE
326: -- Call the core get_balance pkg
327: hr_utility.trace('Entering General Legislation');

Line 327: hr_utility.trace('Entering General Legislation');

323: hr_utility.trace('l_ret_value :'||l_ret_value);
324:
325: ELSE
326: -- Call the core get_balance pkg
327: hr_utility.trace('Entering General Legislation');
328: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
329: hr_utility.trace('Leaving General Legislation');
330: p_errmsg:='NOERROR' ;
331: END IF;

Line 329: hr_utility.trace('Leaving General Legislation');

325: ELSE
326: -- Call the core get_balance pkg
327: hr_utility.trace('Entering General Legislation');
328: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
329: hr_utility.trace('Leaving General Legislation');
330: p_errmsg:='NOERROR' ;
331: END IF;
332:
333: RETURN(l_ret_value);

Line 400: hr_utility.trace('l_instr_count :'||l_instr_count);

396: OPEN c_tax_unit_id;
397: FETCH c_tax_unit_id INTO l_segment1,l_segment11,l_segment12;
398: CLOSE c_tax_unit_id;
399:
400: hr_utility.trace('l_instr_count :'||l_instr_count);
401: hr_utility.trace('g_gre_id :'||g_gre_id);
402: hr_utility.trace('l_organization_id :'||l_organization_id);
403: hr_utility.trace('l_segment1 :'||l_segment1);
404: hr_utility.trace('l_segment11 :'||l_segment11);

Line 401: hr_utility.trace('g_gre_id :'||g_gre_id);

397: FETCH c_tax_unit_id INTO l_segment1,l_segment11,l_segment12;
398: CLOSE c_tax_unit_id;
399:
400: hr_utility.trace('l_instr_count :'||l_instr_count);
401: hr_utility.trace('g_gre_id :'||g_gre_id);
402: hr_utility.trace('l_organization_id :'||l_organization_id);
403: hr_utility.trace('l_segment1 :'||l_segment1);
404: hr_utility.trace('l_segment11 :'||l_segment11);
405: hr_utility.trace('l_segment12 :'||l_segment12);

Line 402: hr_utility.trace('l_organization_id :'||l_organization_id);

398: CLOSE c_tax_unit_id;
399:
400: hr_utility.trace('l_instr_count :'||l_instr_count);
401: hr_utility.trace('g_gre_id :'||g_gre_id);
402: hr_utility.trace('l_organization_id :'||l_organization_id);
403: hr_utility.trace('l_segment1 :'||l_segment1);
404: hr_utility.trace('l_segment11 :'||l_segment11);
405: hr_utility.trace('l_segment12 :'||l_segment12);
406: hr_utility.trace('p_paydate '||to_char(p_paydate));

Line 403: hr_utility.trace('l_segment1 :'||l_segment1);

399:
400: hr_utility.trace('l_instr_count :'||l_instr_count);
401: hr_utility.trace('g_gre_id :'||g_gre_id);
402: hr_utility.trace('l_organization_id :'||l_organization_id);
403: hr_utility.trace('l_segment1 :'||l_segment1);
404: hr_utility.trace('l_segment11 :'||l_segment11);
405: hr_utility.trace('l_segment12 :'||l_segment12);
406: hr_utility.trace('p_paydate '||to_char(p_paydate));
407:

Line 404: hr_utility.trace('l_segment11 :'||l_segment11);

400: hr_utility.trace('l_instr_count :'||l_instr_count);
401: hr_utility.trace('g_gre_id :'||g_gre_id);
402: hr_utility.trace('l_organization_id :'||l_organization_id);
403: hr_utility.trace('l_segment1 :'||l_segment1);
404: hr_utility.trace('l_segment11 :'||l_segment11);
405: hr_utility.trace('l_segment12 :'||l_segment12);
406: hr_utility.trace('p_paydate '||to_char(p_paydate));
407:
408: OPEN c_get_in_comp_name;

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

401: hr_utility.trace('g_gre_id :'||g_gre_id);
402: hr_utility.trace('l_organization_id :'||l_organization_id);
403: hr_utility.trace('l_segment1 :'||l_segment1);
404: hr_utility.trace('l_segment11 :'||l_segment11);
405: hr_utility.trace('l_segment12 :'||l_segment12);
406: hr_utility.trace('p_paydate '||to_char(p_paydate));
407:
408: OPEN c_get_in_comp_name;
409: FETCH c_get_in_comp_name INTO l_component_name;

Line 406: hr_utility.trace('p_paydate '||to_char(p_paydate));

402: hr_utility.trace('l_organization_id :'||l_organization_id);
403: hr_utility.trace('l_segment1 :'||l_segment1);
404: hr_utility.trace('l_segment11 :'||l_segment11);
405: hr_utility.trace('l_segment12 :'||l_segment12);
406: hr_utility.trace('p_paydate '||to_char(p_paydate));
407:
408: OPEN c_get_in_comp_name;
409: FETCH c_get_in_comp_name INTO l_component_name;
410: CLOSE c_get_in_comp_name;

Line 434: hr_utility.trace('l_total_value :'||l_total_value);

430: END IF;
431:
432: p_errmsg:='NOERROR' ;
433: l_total_value := l_ret_value1+l_ret_value11+l_ret_value12;
434: hr_utility.trace('l_total_value :'||l_total_value);
435: hr_utility.trace('l_ret_value1 :'||l_ret_value1);
436: hr_utility.trace('l_ret_value11 :'||l_ret_value11);
437: hr_utility.trace('l_ret_value12 :'||l_ret_value12);
438:

Line 435: hr_utility.trace('l_ret_value1 :'||l_ret_value1);

431:
432: p_errmsg:='NOERROR' ;
433: l_total_value := l_ret_value1+l_ret_value11+l_ret_value12;
434: hr_utility.trace('l_total_value :'||l_total_value);
435: hr_utility.trace('l_ret_value1 :'||l_ret_value1);
436: hr_utility.trace('l_ret_value11 :'||l_ret_value11);
437: hr_utility.trace('l_ret_value12 :'||l_ret_value12);
438:
439: RETURN(l_total_value);

Line 436: hr_utility.trace('l_ret_value11 :'||l_ret_value11);

432: p_errmsg:='NOERROR' ;
433: l_total_value := l_ret_value1+l_ret_value11+l_ret_value12;
434: hr_utility.trace('l_total_value :'||l_total_value);
435: hr_utility.trace('l_ret_value1 :'||l_ret_value1);
436: hr_utility.trace('l_ret_value11 :'||l_ret_value11);
437: hr_utility.trace('l_ret_value12 :'||l_ret_value12);
438:
439: RETURN(l_total_value);
440:

Line 437: hr_utility.trace('l_ret_value12 :'||l_ret_value12);

433: l_total_value := l_ret_value1+l_ret_value11+l_ret_value12;
434: hr_utility.trace('l_total_value :'||l_total_value);
435: hr_utility.trace('l_ret_value1 :'||l_ret_value1);
436: hr_utility.trace('l_ret_value11 :'||l_ret_value11);
437: hr_utility.trace('l_ret_value12 :'||l_ret_value12);
438:
439: RETURN(l_total_value);
440:
441: EXCEPTION

Line 577: hr_utility.trace('Enter Get balances');

573: l_temp_date Date;
574: l_tax_year_start_date Date;
575:
576: BEGIN
577: hr_utility.trace('Enter Get balances');
578: hr_utility.trace('Enter legislation code');
579:
580: -- Nocopy changes
581: l_ret_value_nc := p_ret_value;

Line 578: hr_utility.trace('Enter legislation code');

574: l_tax_year_start_date Date;
575:
576: BEGIN
577: hr_utility.trace('Enter Get balances');
578: hr_utility.trace('Enter legislation code');
579:
580: -- Nocopy changes
581: l_ret_value_nc := p_ret_value;
582:

Line 591: hr_utility.trace('Exit legislation code');

587: l_business_group_id_ct:=p_business_group_id;
588: l_legislation_code:=get_legislation_code(p_business_group_id);
589: END IF;
590:
591: hr_utility.trace('Exit legislation code');
592: /*Check Report or Group id is entered by user*/
593: IF l_rep_detail.count=0 THEN
594: IF p_report_id IS NOT NULL THEN
595: hr_utility.trace('Enter Report id loop');

Line 595: hr_utility.trace('Enter Report id loop');

591: hr_utility.trace('Exit legislation code');
592: /*Check Report or Group id is entered by user*/
593: IF l_rep_detail.count=0 THEN
594: IF p_report_id IS NOT NULL THEN
595: hr_utility.trace('Enter Report id loop');
596: /*Get report detail*/
597: OPEN c_rep_name (l_legislation_code);
598: LOOP
599: FETCH c_rep_name INTO l_rep_detail(1).exception_report_id ,

Line 617: hr_utility.trace('Leaving Report id loop');

613: END LOOP;
614: CLOSE c_def_bal;
615: END LOOP;
616: CLOSE c_rep_name;
617: hr_utility.trace('Leaving Report id loop');
618: ELSIF p_group_id IS NOT NULL AND p_report_id IS NULL THEN
619: hr_utility.trace('Enter Group loop');
620: l_count:=0;
621: /*Get Group detail*/

Line 619: hr_utility.trace('Enter Group loop');

615: END LOOP;
616: CLOSE c_rep_name;
617: hr_utility.trace('Leaving Report id loop');
618: ELSIF p_group_id IS NOT NULL AND p_report_id IS NULL THEN
619: hr_utility.trace('Enter Group loop');
620: l_count:=0;
621: /*Get Group detail*/
622: OPEN c_group_name (l_legislation_code) ;
623: LOOP

Line 652: hr_utility.trace('Enter date calc loop');

648: l_date_detail.DELETE;
649:
650: END IF;
651: /*Calculation based on comparison type*/
652: hr_utility.trace('Enter date calc loop');
653: IF l_date_detail.count=0 THEN
654: OPEN c_maxdate;
655: LOOP
656: FETCH c_maxdate INTO l_maxdate,l_maxdate1;

Line 664: hr_utility.trace('Enter conditions loop');

660: l_def_bal_id := l_rep_detail(i).defined_balance_id;
661: l_comp_type := l_rep_detail(i).comparison_type;
662: l_comp_value := l_rep_detail(i).comparison_value;
663:
664: hr_utility.trace('Enter conditions loop');
665:
666: --Added by Gattu for tax year change
667: --Getting the financial tax year
668: l_tax_year_start_date := Get_Tax_Start_Date(l_legislation_code

Line 840: hr_utility.trace('Leaving conditions loop');

836: END IF; --end if for comparison type
837: END LOOP;--endloop for l_repdetail_table
838: END LOOP;
839: CLOSE c_maxdate;
840: hr_utility.trace('Leaving conditions loop');
841: hr_utility.trace('Complete Populating table');
842: END IF;
843: hr_utility.trace('Enter Balance and calc loop');
844: l_loop_count:=0;

Line 841: hr_utility.trace('Complete Populating table');

837: END LOOP;--endloop for l_repdetail_table
838: END LOOP;
839: CLOSE c_maxdate;
840: hr_utility.trace('Leaving conditions loop');
841: hr_utility.trace('Complete Populating table');
842: END IF;
843: hr_utility.trace('Enter Balance and calc loop');
844: l_loop_count:=0;
845: l_rowcount:=1;

Line 843: hr_utility.trace('Enter Balance and calc loop');

839: CLOSE c_maxdate;
840: hr_utility.trace('Leaving conditions loop');
841: hr_utility.trace('Complete Populating table');
842: END IF;
843: hr_utility.trace('Enter Balance and calc loop');
844: l_loop_count:=0;
845: l_rowcount:=1;
846: FOR i IN 1..l_rep_detail.count
847: LOOP

Line 865: hr_utility.trace('Enter Balance call');

861: FOR j in l_rowcount..l_date_detail.count
862: LOOP
863: IF l_def_bal_id=l_date_detail(j).defined_balance_id
864: AND l_exp_rep_id=l_date_detail(j).exception_report_id THEN
865: hr_utility.trace('Enter Balance call');
866: IF l_loop_count=0 THEN
867: if l_legislation_code = 'CA' and g_gre_id is null then
868: l_max_balance := get_value (p_assignment_id ,
869: l_def_bal_id,

Line 903: hr_utility.trace('Leaving Balance call');

899:
900: IF l_errmsg='NOERROR' THEN
901: l_tot_count:=l_tot_count+1;
902: END IF;
903: hr_utility.trace('Leaving Balance call');
904: IF l_prev_balance1<>0 THEN
905: l_pay_count:=l_pay_count+1;
906: END IF;
907: END IF;

Line 913: hr_utility.trace('Enter final calc loop');

909: --l_rowcount:=j-1;
910: l_rowcount:=j;
911: EXIT;
912: END IF;--end if for def balance comparison
913: hr_utility.trace('Enter final calc loop');
914: END LOOP;--endloop for l_date_detail forloop
915: IF l_comp_type ='PADT'OR l_comp_type ='PANT'
916: OR l_comp_type='QP'OR l_comp_type='QAN'
917: OR l_comp_type='MP'OR l_comp_type='MAN' THEN

Line 983: hr_utility.trace('Leaving final calc loop');

979: l_total_balance:=100*l_total_balance/l_prev_balance;
980: ELSE
981: l_total_balance:=l_total_balance;
982: END IF;
983: hr_utility.trace('Leaving final calc loop');
984: END IF;
985: -- Code for variance operator
986: IF l_rep_detail(i).variance_operator = '=' THEN
987: --Fix for Bug 8361529

Line 1038: hr_utility.trace('Leaving Balance and calc loop');

1034: p_ret_value(l_retvalue_count).curent_balance:=l_max_balance;
1035: p_ret_value(l_retvalue_count).previous_balance:=l_prev_balance;
1036: p_ret_value(l_retvalue_count).ret_val:=l_return_value;
1037: END LOOP; --end loop for repdetail for loop
1038: hr_utility.trace('Leaving Balance and calc loop');
1039: hr_utility.trace('Leaving Get Balances');
1040:
1041: -- Added by tmehra for nocopy changes - Feb03
1042: EXCEPTION

Line 1039: hr_utility.trace('Leaving Get Balances');

1035: p_ret_value(l_retvalue_count).previous_balance:=l_prev_balance;
1036: p_ret_value(l_retvalue_count).ret_val:=l_return_value;
1037: END LOOP; --end loop for repdetail for loop
1038: hr_utility.trace('Leaving Balance and calc loop');
1039: hr_utility.trace('Leaving Get Balances');
1040:
1041: -- Added by tmehra for nocopy changes - Feb03
1042: EXCEPTION
1043: ---------

Line 1045: hr_utility.trace('Error occurred' ||SQLERRM);

1041: -- Added by tmehra for nocopy changes - Feb03
1042: EXCEPTION
1043: ---------
1044: WHEN OTHERS THEN
1045: hr_utility.trace('Error occurred' ||SQLERRM);
1046: p_ret_value := l_ret_value_nc;
1047: RAISE;
1048:
1049: END;

Line 1081: hr_utility.trace('Enter update payroll action');

1077: l_temp_date DATE ;
1078: l_temp_date1 DATE ;
1079: l_count NUMBER ;
1080: BEGIN
1081: hr_utility.trace('Enter update payroll action');
1082: OPEN c_set_paydate ;
1083: LOOP
1084: FETCH c_set_paydate INTO l_maxdate,l_mindate;
1085: EXIT WHEN c_set_paydate%NOTFOUND;

Line 1094: hr_utility.trace('Leaving Update payroll action') ;

1090: SET Start_date= NVL(l_mindate,p_effective_date)
1091: , effective_date=NVL(l_maxdate,p_effective_date)
1092: WHERE payroll_action_id=pactid;
1093:
1094: hr_utility.trace('Leaving Update payroll action') ;
1095:
1096: END;
1097:
1098: PROCEDURE load_details (p_assignment IN NUMBER)

Line 1123: hr_utility.trace('Enter Load details');

1119: --ORDER BY ppv.last_update_date;
1120:
1121:
1122: BEGIN
1123: hr_utility.trace('Enter Load details');
1124: l_last_name:='';
1125: l_first_name:='';
1126: l_middle_name:='';
1127: l_full_name := '';

Line 1151: hr_utility.trace('Leaving Load details');

1147:
1148: END LOOP;
1149: CLOSE per_det;
1150:
1151: hr_utility.trace('Leaving Load details');
1152:
1153: EXCEPTION
1154: --------
1155: WHEN OTHERS THEN

Line 1157: hr_utility.trace('Error occurred load_er_liab ...' ||SQLERRM);

1153: EXCEPTION
1154: --------
1155: WHEN OTHERS THEN
1156: msg1:=SQLERRM;
1157: hr_utility.trace('Error occurred load_er_liab ...' ||SQLERRM);
1158: END load_details;
1159:
1160:
1161:

Line 1229: hr_utility.trace('ACTID = '||actid);

1225: l_act_date DATE;
1226: l_offset_date NUMBER;
1227:
1228: BEGIN
1229: hr_utility.trace('ACTID = '||actid);
1230: hr_utility.trace('Enter Load data');
1231: OPEN sel_aaid (actid);
1232: LOOP
1233: FETCH sel_aaid INTO l_assignment_id,

Line 1230: hr_utility.trace('Enter Load data');

1226: l_offset_date NUMBER;
1227:
1228: BEGIN
1229: hr_utility.trace('ACTID = '||actid);
1230: hr_utility.trace('Enter Load data');
1231: OPEN sel_aaid (actid);
1232: LOOP
1233: FETCH sel_aaid INTO l_assignment_id,
1234: l_start_date,

Line 1291: hr_utility.trace('Legislative Details not found...');

1287:
1288: EXCEPTION
1289: ---------
1290: WHEN NO_DATA_FOUND THEN
1291: hr_utility.trace('Legislative Details not found...');
1292: RAISE;
1293: END;
1294: END IF;
1295: hr_utility.trace('Number of Records fetched = '||to_char(sel_aaid%ROWCOUNT));

Line 1295: hr_utility.trace('Number of Records fetched = '||to_char(sel_aaid%ROWCOUNT));

1291: hr_utility.trace('Legislative Details not found...');
1292: RAISE;
1293: END;
1294: END IF;
1295: hr_utility.trace('Number of Records fetched = '||to_char(sel_aaid%ROWCOUNT));
1296: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
1297: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
1298: hr_utility.trace('Action Type = '||l_action_type);
1299: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));

Line 1296: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));

1292: RAISE;
1293: END;
1294: END IF;
1295: hr_utility.trace('Number of Records fetched = '||to_char(sel_aaid%ROWCOUNT));
1296: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
1297: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
1298: hr_utility.trace('Action Type = '||l_action_type);
1299: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
1300: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));

Line 1297: hr_utility.trace('Effective Date = '||to_char(l_effective_date));

1293: END;
1294: END IF;
1295: hr_utility.trace('Number of Records fetched = '||to_char(sel_aaid%ROWCOUNT));
1296: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
1297: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
1298: hr_utility.trace('Action Type = '||l_action_type);
1299: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
1300: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
1301: IF l_group_id IS NOT NULL THEN

Line 1298: hr_utility.trace('Action Type = '||l_action_type);

1294: END IF;
1295: hr_utility.trace('Number of Records fetched = '||to_char(sel_aaid%ROWCOUNT));
1296: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
1297: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
1298: hr_utility.trace('Action Type = '||l_action_type);
1299: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
1300: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
1301: IF l_group_id IS NOT NULL THEN
1302: l_vartype:=NULL;

Line 1299: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));

1295: hr_utility.trace('Number of Records fetched = '||to_char(sel_aaid%ROWCOUNT));
1296: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
1297: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
1298: hr_utility.trace('Action Type = '||l_action_type);
1299: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
1300: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
1301: IF l_group_id IS NOT NULL THEN
1302: l_vartype:=NULL;
1303: l_varvalue:=NULL;

Line 1300: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));

1296: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
1297: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
1298: hr_utility.trace('Action Type = '||l_action_type);
1299: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
1300: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
1301: IF l_group_id IS NOT NULL THEN
1302: l_vartype:=NULL;
1303: l_varvalue:=NULL;
1304: END IF;

Line 1352: hr_utility.trace('End of LOAD DATA');

1348: END IF;
1349: END LOOP;
1350: END IF;
1351: END LOOP;
1352: hr_utility.trace('End of LOAD DATA');
1353: CLOSE sel_aaid;
1354: hr_utility.trace('Leaving Load data');
1355: EXCEPTION
1356: ---------

Line 1354: hr_utility.trace('Leaving Load data');

1350: END IF;
1351: END LOOP;
1352: hr_utility.trace('End of LOAD DATA');
1353: CLOSE sel_aaid;
1354: hr_utility.trace('Leaving Load data');
1355: EXCEPTION
1356: ---------
1357: WHEN OTHERS THEN
1358: hr_utility.trace('Error occurred load_data ...' ||SQLERRM);

Line 1358: hr_utility.trace('Error occurred load_data ...' ||SQLERRM);

1354: hr_utility.trace('Leaving Load data');
1355: EXCEPTION
1356: ---------
1357: WHEN OTHERS THEN
1358: hr_utility.trace('Error occurred load_data ...' ||SQLERRM);
1359: RAISE;
1360: END load_data;
1361:
1362: --This function determines if there are any offset date.

Line 1402: hr_utility.trace('Enter run preprocess');

1398: v_alter_string VARCHAR2(100);
1399: v_numrows NUMBER;
1400: BEGIN
1401:
1402: hr_utility.trace('Enter run preprocess');
1403: -- ppa_finder := pqp_ustiaa_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);
1404:
1405: load_data(actid,
1406: p_effective_date );

Line 1407: hr_utility.trace('Leaving run preprocess');

1403: -- ppa_finder := pqp_ustiaa_pkg.get_parameter('TRANSFER_PPA_FINDER',l_param);
1404:
1405: load_data(actid,
1406: p_effective_date );
1407: hr_utility.trace('Leaving run preprocess');
1408: EXCEPTION
1409: ---------
1410: WHEN no_data_found THEN
1411: RAISE;

Line 1441: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

1437: l_tax_year_start_dt Date;
1438: l_proc_name Varchar2(150) := g_proc_name ||'Get_Tax_Start_Date';
1439:
1440: BEGIN
1441: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1442: Hr_Utility.set_location('p_legislation_code '||p_legislation_code, 5);
1443: Hr_Utility.set_location('p_effective_date '||p_effective_date, 5);
1444: Hr_Utility.set_location('p_dimension_type_id '||p_dimension_type_id, 5);
1445:

Line 1442: Hr_Utility.set_location('p_legislation_code '||p_legislation_code, 5);

1438: l_proc_name Varchar2(150) := g_proc_name ||'Get_Tax_Start_Date';
1439:
1440: BEGIN
1441: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1442: Hr_Utility.set_location('p_legislation_code '||p_legislation_code, 5);
1443: Hr_Utility.set_location('p_effective_date '||p_effective_date, 5);
1444: Hr_Utility.set_location('p_dimension_type_id '||p_dimension_type_id, 5);
1445:
1446:

Line 1443: Hr_Utility.set_location('p_effective_date '||p_effective_date, 5);

1439:
1440: BEGIN
1441: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1442: Hr_Utility.set_location('p_legislation_code '||p_legislation_code, 5);
1443: Hr_Utility.set_location('p_effective_date '||p_effective_date, 5);
1444: Hr_Utility.set_location('p_dimension_type_id '||p_dimension_type_id, 5);
1445:
1446:
1447: OPEN c_tax_start_date(p_dimension_type_id,p_legislation_code);

Line 1444: Hr_Utility.set_location('p_dimension_type_id '||p_dimension_type_id, 5);

1440: BEGIN
1441: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1442: Hr_Utility.set_location('p_legislation_code '||p_legislation_code, 5);
1443: Hr_Utility.set_location('p_effective_date '||p_effective_date, 5);
1444: Hr_Utility.set_location('p_dimension_type_id '||p_dimension_type_id, 5);
1445:
1446:
1447: OPEN c_tax_start_date(p_dimension_type_id,p_legislation_code);
1448: FETCH c_tax_start_date INTO l_tax_year_start;

Line 1451: Hr_Utility.set_location('l_tax_year_start '||l_tax_year_start, 5);

1447: OPEN c_tax_start_date(p_dimension_type_id,p_legislation_code);
1448: FETCH c_tax_start_date INTO l_tax_year_start;
1449: CLOSE c_tax_start_date;
1450:
1451: Hr_Utility.set_location('l_tax_year_start '||l_tax_year_start, 5);
1452:
1453:
1454: IF l_tax_year_start IS NOT NULL THEN
1455: SELECT fnd_date.canonical_to_date(to_char(p_effective_date,'YYYY') ||

Line 1462: Hr_Utility.set_location('l_tax_year_start_dt '||l_tax_year_start_dt, 5);

1458:
1459: --SELECT to_date(to_char(l_tax_year_start,'DD-MON-')|| to_char(p_effective_date,'YYYY'),'DD-MON-YYYY')
1460: --INTO l_tax_year_start_dt from dual;
1461: END IF;
1462: Hr_Utility.set_location('l_tax_year_start_dt '||l_tax_year_start_dt, 5);
1463: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1464: RETURN l_tax_year_start_dt;
1465:
1466: EXCEPTION

Line 1463: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

1459: --SELECT to_date(to_char(l_tax_year_start,'DD-MON-')|| to_char(p_effective_date,'YYYY'),'DD-MON-YYYY')
1460: --INTO l_tax_year_start_dt from dual;
1461: END IF;
1462: Hr_Utility.set_location('l_tax_year_start_dt '||l_tax_year_start_dt, 5);
1463: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1464: RETURN l_tax_year_start_dt;
1465:
1466: EXCEPTION
1467: WHEN Others THEN

Line 1468: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

1464: RETURN l_tax_year_start_dt;
1465:
1466: EXCEPTION
1467: WHEN Others THEN
1468: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1469: RETURN null;
1470: END Get_Tax_Start_Date;
1471:
1472: -- =============================================================================

Line 1484: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

1480: l_previous_year_tax_dt Date;
1481: l_proc_name Varchar2(150) := g_proc_name ||'Get_Previous_Year_Tax_Date';
1482:
1483: BEGIN
1484: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1485: Hr_Utility.set_location('p_effective_date: '||p_effective_date, 5);
1486: Hr_Utility.set_location('p_tax_year_start_date:'||p_tax_year_start_date, 5);
1487:
1488: IF p_tax_year_start_date IS NOT NULL THEN

Line 1485: Hr_Utility.set_location('p_effective_date: '||p_effective_date, 5);

1481: l_proc_name Varchar2(150) := g_proc_name ||'Get_Previous_Year_Tax_Date';
1482:
1483: BEGIN
1484: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1485: Hr_Utility.set_location('p_effective_date: '||p_effective_date, 5);
1486: Hr_Utility.set_location('p_tax_year_start_date:'||p_tax_year_start_date, 5);
1487:
1488: IF p_tax_year_start_date IS NOT NULL THEN
1489: IF p_tax_year_start_date > p_effective_date THEN

Line 1486: Hr_Utility.set_location('p_tax_year_start_date:'||p_tax_year_start_date, 5);

1482:
1483: BEGIN
1484: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1485: Hr_Utility.set_location('p_effective_date: '||p_effective_date, 5);
1486: Hr_Utility.set_location('p_tax_year_start_date:'||p_tax_year_start_date, 5);
1487:
1488: IF p_tax_year_start_date IS NOT NULL THEN
1489: IF p_tax_year_start_date > p_effective_date THEN
1490: l_previous_year_tax_dt := ADD_MONTHS(p_tax_year_start_date ,-12)-1;

Line 1495: Hr_Utility.set_location('l_previous_year_tax_dt '||l_previous_year_tax_dt, 5);

1491: ELSE
1492: l_previous_year_tax_dt := p_tax_year_start_date-1;
1493: END IF;
1494: END IF;
1495: Hr_Utility.set_location('l_previous_year_tax_dt '||l_previous_year_tax_dt, 5);
1496: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1497: RETURN l_previous_year_tax_dt;
1498:
1499: EXCEPTION

Line 1496: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

1492: l_previous_year_tax_dt := p_tax_year_start_date-1;
1493: END IF;
1494: END IF;
1495: Hr_Utility.set_location('l_previous_year_tax_dt '||l_previous_year_tax_dt, 5);
1496: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1497: RETURN l_previous_year_tax_dt;
1498:
1499: EXCEPTION
1500: WHEN Others THEN

Line 1501: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

1497: RETURN l_previous_year_tax_dt;
1498:
1499: EXCEPTION
1500: WHEN Others THEN
1501: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1502: RETURN null;
1503: END Get_Previous_Year_Tax_Date;
1504:
1505:

Line 1520: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

1516: l_proc_name Varchar2(150) := g_proc_name ||'Get_Previous_Quarter_Tax_Date';
1517: l_tax_year_start_date Date;
1518: l_sign number;
1519: BEGIN
1520: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1521: Hr_Utility.set_location('p_tax_year_start_date:'||p_tax_year_start_date, 5);
1522: Hr_Utility.set_location('p_effective_date: '||p_effective_date, 5);
1523: Hr_Utility.set_location('p_count: '||p_count, 5);
1524:

Line 1521: Hr_Utility.set_location('p_tax_year_start_date:'||p_tax_year_start_date, 5);

1517: l_tax_year_start_date Date;
1518: l_sign number;
1519: BEGIN
1520: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1521: Hr_Utility.set_location('p_tax_year_start_date:'||p_tax_year_start_date, 5);
1522: Hr_Utility.set_location('p_effective_date: '||p_effective_date, 5);
1523: Hr_Utility.set_location('p_count: '||p_count, 5);
1524:
1525: IF p_tax_year_start_date IS NOT NULL THEN

Line 1522: Hr_Utility.set_location('p_effective_date: '||p_effective_date, 5);

1518: l_sign number;
1519: BEGIN
1520: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1521: Hr_Utility.set_location('p_tax_year_start_date:'||p_tax_year_start_date, 5);
1522: Hr_Utility.set_location('p_effective_date: '||p_effective_date, 5);
1523: Hr_Utility.set_location('p_count: '||p_count, 5);
1524:
1525: IF p_tax_year_start_date IS NOT NULL THEN
1526: IF p_tax_year_start_date > p_effective_date THEN

Line 1523: Hr_Utility.set_location('p_count: '||p_count, 5);

1519: BEGIN
1520: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1521: Hr_Utility.set_location('p_tax_year_start_date:'||p_tax_year_start_date, 5);
1522: Hr_Utility.set_location('p_effective_date: '||p_effective_date, 5);
1523: Hr_Utility.set_location('p_count: '||p_count, 5);
1524:
1525: IF p_tax_year_start_date IS NOT NULL THEN
1526: IF p_tax_year_start_date > p_effective_date THEN
1527: l_tax_year_start_date := ADD_MONTHS(p_tax_year_start_date ,-12);

Line 1565: Hr_Utility.set_location('l_previous_quater_tax_dt '||l_previous_quater_tax_dt, 5);

1561: l_previous_quater_tax_dt:= ADD_MONTHS(l_previous_quater_tax_dt,((p_count-1)*-3));
1562: END IF;
1563: END IF;
1564:
1565: Hr_Utility.set_location('l_previous_quater_tax_dt '||l_previous_quater_tax_dt, 5);
1566: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1567: RETURN l_previous_quater_tax_dt;
1568:
1569: EXCEPTION

Line 1566: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

1562: END IF;
1563: END IF;
1564:
1565: Hr_Utility.set_location('l_previous_quater_tax_dt '||l_previous_quater_tax_dt, 5);
1566: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1567: RETURN l_previous_quater_tax_dt;
1568:
1569: EXCEPTION
1570: WHEN Others THEN

Line 1571: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

1567: RETURN l_previous_quater_tax_dt;
1568:
1569: EXCEPTION
1570: WHEN Others THEN
1571: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
1572: RETURN null;
1573: END Get_Previous_Quarter_Tax_Date;
1574: ------------------------------ end load data -------------------------------
1575: END ;