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

APPS.PAY_AU_RECON_SUMMARY dependencies on HR_UTILITY

Line 331: g_debug := hr_utility.debug_enabled;

327: retro_type varchar2(50);
328: l_adv_retro_flag pay_legislation_rules.rule_mode%TYPE;
329:
330: Begin
331: g_debug := hr_utility.debug_enabled;
332: ret_counter := 1;
333:
334: OPEN get_legislation_rule;
335: FETCH get_legislation_rule INTO l_adv_retro_flag;

Line 351: hr_utility.set_location('Get_retro_Entry_Id: not found',1);

347: LOOP
348: FETCH Get_retro_Entry_ids INTO rec_ret_entry_ids;
349: IF Get_retro_Entry_ids%NOTFOUND Then
350: IF g_debug THEN
351: hr_utility.set_location('Get_retro_Entry_Id: not found',1);
352: END if;
353: Exit;
354: End If;
355: IF g_debug THEN

Line 356: hr_utility.set_location('Calling Get Retro Periods',2);

352: END if;
353: Exit;
354: End If;
355: IF g_debug THEN
356: hr_utility.set_location('Calling Get Retro Periods',2);
357: END if;
358:
359: x:=pay_au_paye_ff.get_retro_period(rec_ret_entry_ids.element_entry_id,
360: rec_ret_entry_ids.date_earned,

Line 366: hr_utility.set_location('Back from call to Get Retro Periods',3);

362: retro_start,
363: retro_end);
364:
365: IF g_debug THEN
366: hr_utility.set_location('Back from call to Get Retro Periods',3);
367: END if;
368:
369: IF months_between(rec_ret_entry_ids.date_earned,retro_end) > 12 then
370: IF g_debug THEN

Line 371: hr_utility.set_location('Getting Retro Allowance Greater than 12 months',4);

367: END if;
368:
369: IF months_between(rec_ret_entry_ids.date_earned,retro_end) > 12 then
370: IF g_debug THEN
371: hr_utility.set_location('Getting Retro Allowance Greater than 12 months',4);
372: END if;
373:
374: OPEN Get_retro_Allowances(rec_ret_entry_ids.element_entry_id, rec_ret_entry_ids.balance_type_id);
375: FETCH Get_retro_Allowances INTO rec_retro_Allowances;

Line 415: hr_utility.set_location('Get_retro_Entry_Id: not found',1);

411: LOOP
412: FETCH Get_retro_Entry_ids INTO rec_ret_entry_ids;
413: IF Get_retro_Entry_ids%NOTFOUND Then
414: IF g_debug THEN
415: hr_utility.set_location('Get_retro_Entry_Id: not found',1);
416: END if;
417: Exit;
418: End If;
419: IF g_debug THEN

Line 420: hr_utility.set_location('Calling Get Retro Time Span',2);

416: END if;
417: Exit;
418: End If;
419: IF g_debug THEN
420: hr_utility.set_location('Calling Get Retro Time Span',2);
421: END if;
422:
423: x:= pay_au_paye_ff.get_retro_time_span(rec_ret_entry_ids.element_entry_id,
424: rec_ret_entry_ids.date_earned,

Line 433: hr_utility.set_location('Back from call to Get Retro Time Span',3);

429: retro_eff_date,
430: time_span,
431: retro_type);
432: IF g_debug THEN
433: hr_utility.set_location('Back from call to Get Retro Time Span',3);
434: END if;
435: IF time_span ='GT12' then
436: IF g_debug THEN
437: hr_utility.set_location('Getting Retro Allowance Greater than 12 months',4);

Line 437: hr_utility.set_location('Getting Retro Allowance Greater than 12 months',4);

433: hr_utility.set_location('Back from call to Get Retro Time Span',3);
434: END if;
435: IF time_span ='GT12' then
436: IF g_debug THEN
437: hr_utility.set_location('Getting Retro Allowance Greater than 12 months',4);
438: END if;
439: OPEN Get_retro_Allowances(rec_ret_entry_ids.element_entry_id, rec_ret_entry_ids.balance_type_id);
440: FETCH Get_retro_Allowances INTO rec_retro_Allowances;
441: CLOSE Get_retro_Allowances;

Line 504: g_debug :=hr_utility.debug_enabled ;

500: i number;
501:
502: begin
503:
504: g_debug :=hr_utility.debug_enabled ;
505:
506: if g_debug then
507: hr_utility.set_location('Entering get_total_allowances for assingment_id '||p_assignment_id, 0);
508: end if;

Line 507: hr_utility.set_location('Entering get_total_allowances for assingment_id '||p_assignment_id, 0);

503:
504: g_debug :=hr_utility.debug_enabled ;
505:
506: if g_debug then
507: hr_utility.set_location('Entering get_total_allowances for assingment_id '||p_assignment_id, 0);
508: end if;
509:
510: IF (g_bal_dim_level = 'N') THEN
511:

Line 535: hr_utility.trace('N t_allowance_ balance name ('||cnt||') = '|| t_allowance_balance(cnt).balance_name);

531: t_allowance_balance(cnt).balance_name := l_balance_name;
532: t_allowance_balance(cnt).balance_value := g_result_alw_table(i).balance_value;
533:
534: if g_debug then
535: hr_utility.trace('N t_allowance_ balance name ('||cnt||') = '|| t_allowance_balance(cnt).balance_name);
536: hr_utility.trace('N t_allowance_balance value ('||cnt||') = '||t_allowance_balance(cnt).balance_value);
537: end if;
538:
539: cnt := cnt + 1;

Line 536: hr_utility.trace('N t_allowance_balance value ('||cnt||') = '||t_allowance_balance(cnt).balance_value);

532: t_allowance_balance(cnt).balance_value := g_result_alw_table(i).balance_value;
533:
534: if g_debug then
535: hr_utility.trace('N t_allowance_ balance name ('||cnt||') = '|| t_allowance_balance(cnt).balance_name);
536: hr_utility.trace('N t_allowance_balance value ('||cnt||') = '||t_allowance_balance(cnt).balance_value);
537: end if;
538:
539: cnt := cnt + 1;
540:

Line 561: hr_utility.trace('N1 t_allowance_ balance name ('||cnt||') = '|| t_allowance_balance(i).balance_name);

557: For i in t_allowance_balance.first .. t_allowance_balance.last LOOP
558: If t_allowance_balance.EXISTS(i) Then
559: g_total_allowance:=g_total_allowance+nvl(t_allowance_balance(i).balance_value,0);
560: if g_debug then
561: hr_utility.trace('N1 t_allowance_ balance name ('||cnt||') = '|| t_allowance_balance(i).balance_name);
562: hr_utility.trace('N1 t_allowance_balance value ('||cnt||') = '||t_allowance_balance(i).balance_value);
563: end if;
564: End If;
565: END LOOP;

Line 562: hr_utility.trace('N1 t_allowance_balance value ('||cnt||') = '||t_allowance_balance(i).balance_value);

558: If t_allowance_balance.EXISTS(i) Then
559: g_total_allowance:=g_total_allowance+nvl(t_allowance_balance(i).balance_value,0);
560: if g_debug then
561: hr_utility.trace('N1 t_allowance_ balance name ('||cnt||') = '|| t_allowance_balance(i).balance_name);
562: hr_utility.trace('N1 t_allowance_balance value ('||cnt||') = '||t_allowance_balance(i).balance_value);
563: end if;
564: End If;
565: END LOOP;
566: g_fw_allowance_tab:=t_allowance_balance;

Line 600: hr_utility.trace('G t_allowance_ balance name ('||counter||') = '|| t_allowance_balance(counter).balance_name);

596: t_allowance_balance(counter).balance_name := l_balance_name;
597: t_allowance_balance(counter).balance_value := g_result_group_alw_table(i).balance_value;
598:
599: if g_debug then
600: hr_utility.trace('G t_allowance_ balance name ('||counter||') = '|| t_allowance_balance(counter).balance_name);
601: hr_utility.trace('G t_allowance_balance value ('||counter||') = '||t_allowance_balance(counter).balance_value);
602: end if;
603:
604: counter := counter + 1;

Line 601: hr_utility.trace('G t_allowance_balance value ('||counter||') = '||t_allowance_balance(counter).balance_value);

597: t_allowance_balance(counter).balance_value := g_result_group_alw_table(i).balance_value;
598:
599: if g_debug then
600: hr_utility.trace('G t_allowance_ balance name ('||counter||') = '|| t_allowance_balance(counter).balance_name);
601: hr_utility.trace('G t_allowance_balance value ('||counter||') = '||t_allowance_balance(counter).balance_value);
602: end if;
603:
604: counter := counter + 1;
605:

Line 624: hr_utility.trace('G1 t_allowance_ balance name ('||cnt||') = '|| t_allowance_balance(i).balance_name);

620: For i in t_allowance_balance.first .. t_allowance_balance.last LOOP
621: If t_allowance_balance.EXISTS(i) Then
622: g_total_allowance:=g_total_allowance+nvl(t_allowance_balance(i).balance_value,0);
623: if g_debug then
624: hr_utility.trace('G1 t_allowance_ balance name ('||cnt||') = '|| t_allowance_balance(i).balance_name);
625: hr_utility.trace('G1 t_allowance_balance value ('||cnt||') = '||t_allowance_balance(i).balance_value);
626: end if;
627: End If;
628: END LOOP;

Line 625: hr_utility.trace('G1 t_allowance_balance value ('||cnt||') = '||t_allowance_balance(i).balance_value);

621: If t_allowance_balance.EXISTS(i) Then
622: g_total_allowance:=g_total_allowance+nvl(t_allowance_balance(i).balance_value,0);
623: if g_debug then
624: hr_utility.trace('G1 t_allowance_ balance name ('||cnt||') = '|| t_allowance_balance(i).balance_name);
625: hr_utility.trace('G1 t_allowance_balance value ('||cnt||') = '||t_allowance_balance(i).balance_value);
626: end if;
627: End If;
628: END LOOP;
629: ELSE

Line 640: hr_utility.set_location('Returned g_total_allowace : '||nvl(g_total_allowance,0), 888);

636:
637: return nvl(g_total_allowance,0);
638:
639: if g_debug then
640: hr_utility.set_location('Returned g_total_allowace : '||nvl(g_total_allowance,0), 888);
641: hr_utility.set_location('Leaving get_total_allowances for assingment_id '||p_assignment_id, 999);
642: end if;
643:
644: end get_total_allowances;

Line 641: hr_utility.set_location('Leaving get_total_allowances for assingment_id '||p_assignment_id, 999);

637: return nvl(g_total_allowance,0);
638:
639: if g_debug then
640: hr_utility.set_location('Returned g_total_allowace : '||nvl(g_total_allowance,0), 888);
641: hr_utility.set_location('Leaving get_total_allowances for assingment_id '||p_assignment_id, 999);
642: end if;
643:
644: end get_total_allowances;
645:

Line 1358: g_debug := hr_utility.debug_enabled;

1354: and pbd.legislation_code = pdb.legislation_code;
1355:
1356:
1357: BEGIN
1358: g_debug := hr_utility.debug_enabled;
1359:
1360: ---Start of Bug#3749530------------------
1361: g_business_group_id := p_business_group_id;
1362: g_lst_yr_term := NVL(p_lst_yr_term,'Y'); --Bug3693034

Line 1381: hr_utility.trace('Parameter p_le_level value => ' || p_le_level);

1377: c_dimension_name := '_ASG_YTD';
1378: END IF;
1379:
1380: IF g_debug THEN
1381: hr_utility.trace('Parameter p_le_level value => ' || p_le_level);
1382: hr_utility.trace('Dimension is => ' || c_dimension_name);
1383: END IF;
1384:
1385: /* End of Bug: 3186840 */

Line 1382: hr_utility.trace('Dimension is => ' || c_dimension_name);

1378: END IF;
1379:
1380: IF g_debug THEN
1381: hr_utility.trace('Parameter p_le_level value => ' || p_le_level);
1382: hr_utility.trace('Dimension is => ' || c_dimension_name);
1383: END IF;
1384:
1385: /* End of Bug: 3186840 */
1386:

Line 1468: hr_utility.trace(i || ' Defined Balance id of ' || l_bal_name || '=> ' || g_input_table(i).defined_balance_id);

1464: g_input_table(i).defined_balance_id :=l_def_bal_id;--Bug# 3193479
1465: g_input_table(i).balance_value := NULL;
1466:
1467: IF g_debug THEN
1468: hr_utility.trace(i || ' Defined Balance id of ' || l_bal_name || '=> ' || g_input_table(i).defined_balance_id);
1469: END IF;
1470:
1471: i:=i+1;
1472: END LOOP;

Line 1483: hr_utility.trace(csr_rec.sort_index || ' ' || g_fw_input_table(csr_rec.sort_index).balance_type_id);

1479: LOOP
1480:
1481: g_fw_input_table(csr_rec.sort_index).balance_type_id := csr_rec.balance_type_id;
1482: IF g_debug THEN
1483: hr_utility.trace(csr_rec.sort_index || ' ' || g_fw_input_table(csr_rec.sort_index).balance_type_id);
1484: END IF;
1485:
1486: END LOOP;
1487:

Line 1513: hr_utility.trace( ' Defined Balance id of ' || l_alw_bal_name || ' => ' || g_input_alw_table(cnt).defined_balance_id);

1509: g_input_alw_table(cnt).defined_balance_id := l_alw_def_bal_id;
1510: g_input_alw_table(cnt).balance_value := NULL;
1511:
1512: IF g_debug THEN
1513: hr_utility.trace( ' Defined Balance id of ' || l_alw_bal_name || ' => ' || g_input_alw_table(cnt).defined_balance_id);
1514: END IF;
1515: cnt := cnt + 1;
1516: END LOOP;
1517:

Line 1584: hr_utility.set_location('Start of archive_prepost_details',15);

1580: where aa.assignment_id = c_assignment_id); /*Bug 4256486 */
1581:
1582: begin
1583: if g_debug then
1584: hr_utility.set_location('Start of archive_prepost_details',15);
1585: END if;
1586: -- Added for bug 3686549
1587: l_current_employee_flag := 'Y';
1588: IF (g_lst_yr_term = 'N') THEN

Line 1621: hr_utility.set_location('calling pay_au_terminations.etp_prepost_ratios ',15);

1617: --------------------------------------------------------------------------------+
1618: -- this procedure gets the ratios to calculate prejul83 balance and postjun83 balance
1619: --------------------------------------------------------------------------------+
1620: if g_debug then
1621: hr_utility.set_location('calling pay_au_terminations.etp_prepost_ratios ',15);
1622: END if;
1623:
1624: l_result :=pay_au_terminations.etp_prepost_ratios(
1625: p_assignment_id -- number in

Line 1671: hr_utility.set_location('End of archive_prepost_details',14);

1667: /* End 8769345 */
1668:
1669: end if;
1670: if g_debug then
1671: hr_utility.set_location('End of archive_prepost_details',14);
1672: END if;
1673: g_etp_gross:=g_pre01jul1983_value+g_post30jun1983_value+Total_Invalidity_Payments;
1674: g_assessable:= round(g_post30jun1983_value,2); /* Bug 4872594 - Changed to Round upto 2 decimals */
1675: /* Bug No : 7030285 - Assessable Income modified */

Line 1697: hr_utility.set_location('error from pay_au_terminations.etp_prepost_ratios',20);

1693:
1694: exception
1695: when e_prepost_error then
1696: if g_debug then
1697: hr_utility.set_location('error from pay_au_terminations.etp_prepost_ratios',20);
1698: END if;
1699: when others then
1700: if g_debug then
1701: hr_utility.set_location('error in function_prepost_details',21);

Line 1701: hr_utility.set_location('error in function_prepost_details',21);

1697: hr_utility.set_location('error from pay_au_terminations.etp_prepost_ratios',20);
1698: END if;
1699: when others then
1700: if g_debug then
1701: hr_utility.set_location('error in function_prepost_details',21);
1702: END if;
1703: raise;
1704: end etp_details;
1705:

Line 1863: g_debug := hr_utility.debug_enabled;

1859: l_retro_fw_gross_total :=0;
1860: l_retro_fw_tax_total :=0;
1861: /* end bug 9950136 */
1862:
1863: g_debug := hr_utility.debug_enabled;
1864:
1865: g_result_table.delete;
1866: g_context_table.delete;
1867: bal_id.delete;

Line 1924: hr_utility.set_location('FW EMP check .. g_fw_check for assignment_id '||c_assignment_id||' is '||g_fw_check, 2);

1920:
1921: g_fw_check := pay_au_foreign_workers.check_foreign_worker(c_assignment_id, p_tax_unit_id, c_year_start, c_year_end);
1922:
1923: if g_debug then
1924: hr_utility.set_location('FW EMP check .. g_fw_check for assignment_id '||c_assignment_id||' is '||g_fw_check, 2);
1925:
1926: end if;
1927:
1928: end if;

Line 1989: hr_utility.set_location('Entering to calculate the Term and Leave Pay amounts ',1000);

1985: IF (i_idx = 1)
1986: THEN
1987: IF g_debug
1988: THEN
1989: hr_utility.set_location('Entering to calculate the Term and Leave Pay amounts ',1000);
1990: END IF;
1991: l_term_earnings := get_bal_value_new(g_db_id_flpm);
1992: l_lumpsuma := get_bal_value_new(g_db_id_flsap);
1993: l_term_tax := get_bal_value_new(g_db_id_flcd) + get_bal_value_new(g_db_id_flsad);

Line 2233: hr_utility.set_location('get_value_bbr Print Values ',1000);

2229: p_output_tab := bal_id;
2230:
2231: IF g_debug
2232: THEN
2233: hr_utility.set_location('get_value_bbr Print Values ',1000);
2234: FOR i IN p_output_tab.FIRST..p_output_tab.LAST
2235: LOOP
2236: hr_utility.set_location('Index '||i||' Value ='||p_output_tab(i).balance_value,1000);
2237: END LOOP;

Line 2236: hr_utility.set_location('Index '||i||' Value ='||p_output_tab(i).balance_value,1000);

2232: THEN
2233: hr_utility.set_location('get_value_bbr Print Values ',1000);
2234: FOR i IN p_output_tab.FIRST..p_output_tab.LAST
2235: LOOP
2236: hr_utility.set_location('Index '||i||' Value ='||p_output_tab(i).balance_value,1000);
2237: END LOOP;
2238: END IF;
2239: END;
2240: ---------------End of Bug# 3193479-----------------------------------------------------------

Line 2519: g_debug := hr_utility.debug_enabled;

2515: cnt number := 1;
2516:
2517: BEGIN
2518:
2519: g_debug := hr_utility.debug_enabled;
2520:
2521: g_dimension_name := p_dimension_name;
2522:
2523: IF g_debug THEN

Line 2524: hr_utility.trace('Dimension is ' || p_dimension_name);

2520:
2521: g_dimension_name := p_dimension_name;
2522:
2523: IF g_debug THEN
2524: hr_utility.trace('Dimension is ' || p_dimension_name);
2525: END IF;
2526:
2527: /* Group Level Defined Balance IDs get stored in the PL/SQL table with the following order.
2528:

Line 2556: hr_utility.trace(csr_rec.sort_index || ' ' || g_input_group_details_table(csr_rec.sort_index).defined_balance_id);

2552: LOOP
2553: g_input_group_details_table(csr_rec.sort_index).defined_balance_id := csr_rec.defined_balance_id;
2554:
2555: IF g_debug THEN
2556: hr_utility.trace(csr_rec.sort_index || ' ' || g_input_group_details_table(csr_rec.sort_index).defined_balance_id);
2557: END IF;
2558:
2559: END LOOP;
2560:

Line 2569: hr_utility.trace(csr_rec.sort_index || ' ' || g_input_fw_grp_dtls_table(csr_rec.sort_index).balance_type_id);

2565: LOOP
2566: g_input_fw_grp_dtls_table(csr_rec.sort_index).balance_type_id := csr_rec.balance_type_id;
2567:
2568: IF g_debug THEN
2569: hr_utility.trace(csr_rec.sort_index || ' ' || g_input_fw_grp_dtls_table(csr_rec.sort_index).balance_type_id);
2570: END IF;
2571:
2572: END LOOP;
2573: /* Changes for 9147438 end */

Line 2581: hr_utility.trace( ' Defined Balance id of ' || csr_rec.balance_name || ' => ' || g_input_group_alw_table(cnt).defined_balance_id);

2577: FOR csr_rec IN csr_group_alw_def_bal_ids LOOP
2578: g_input_group_alw_table(cnt).defined_balance_id := csr_rec.defined_balance_id;
2579:
2580: IF g_debug THEN
2581: hr_utility.trace( ' Defined Balance id of ' || csr_rec.balance_name || ' => ' || g_input_group_alw_table(cnt).defined_balance_id);
2582: END IF;
2583:
2584: cnt := cnt + 1;
2585: END LOOP;

Line 2627: hr_utility.trace('Balance Value ' || i || g_result_group_details_table(i).balance_value);

2623: IF g_debug THEN
2624: FOR i IN 1..g_result_group_details_table.last
2625: LOOP
2626: IF g_result_group_details_table.exists(i) THEN
2627: hr_utility.trace('Balance Value ' || i || g_result_group_details_table(i).balance_value);
2628: END IF;
2629: END LOOP;
2630: END IF;
2631:

Line 2674: g_debug := hr_utility.debug_enabled;

2670: g_debug boolean;
2671:
2672: BEGIN
2673:
2674: g_debug := hr_utility.debug_enabled;
2675:
2676: g_pre01jul1983_value :=0;
2677: g_post30jun1983_value :=0;
2678: g_etp_gross :=0;

Line 2734: hr_utility.trace(i || ' ' || g_input_term_details_table(i).defined_balance_id);

2730: FOR i IN 1..g_input_term_details_table.last
2731: LOOP
2732: IF g_input_term_details_table.exists(i) THEN
2733: IF g_debug THEN
2734: hr_utility.trace(i || ' ' || g_input_term_details_table(i).defined_balance_id);
2735: END IF;
2736: END IF;
2737: END LOOP;
2738:

Line 2749: hr_utility.trace('Balance Value ' || i || g_result_term_details_table(i).balance_value);

2745: IF g_debug THEN
2746: FOR i IN 1..g_result_term_details_table.last
2747: LOOP
2748: IF g_result_term_details_table.exists(i) THEN
2749: hr_utility.trace('Balance Value ' || i || g_result_term_details_table(i).balance_value);
2750: END IF;
2751: END LOOP;
2752: END IF;
2753:

Line 2775: hr_utility.trace('Output Balance Value ' || i || bal_id(i).balance_value);

2771: IF g_debug THEN
2772: FOR i IN 1..bal_id.last
2773: LOOP
2774: IF bal_id.exists(i) THEN
2775: hr_utility.trace('Output Balance Value ' || i || bal_id(i).balance_value);
2776: END IF;
2777: END LOOP;
2778: END IF;
2779:

Line 2804: g_debug := hr_utility.debug_enabled;

2800: procedure range_code
2801: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
2802: p_sql out nocopy varchar2) is
2803: begin
2804: g_debug := hr_utility.debug_enabled;
2805: IF g_debug THEN
2806: hr_utility.set_location('Start of range_code',1);
2807: END if;
2808: p_sql := ' select distinct p.person_id' ||

Line 2806: hr_utility.set_location('Start of range_code',1);

2802: p_sql out nocopy varchar2) is
2803: begin
2804: g_debug := hr_utility.debug_enabled;
2805: IF g_debug THEN
2806: hr_utility.set_location('Start of range_code',1);
2807: END if;
2808: p_sql := ' select distinct p.person_id' ||
2809: ' from per_people_f p,' ||
2810: ' pay_payroll_actions pa' ||

Line 2815: hr_utility.set_location('End of range_code',2);

2811: ' where pa.payroll_action_id = :payroll_action_id' ||
2812: ' and p.business_group_id = pa.business_group_id' ||
2813: ' order by p.person_id';
2814: IF g_debug THEN
2815: hr_utility.set_location('End of range_code',2);
2816: END if;
2817: end range_code;
2818:
2819:

Line 2869: g_debug := hr_utility.debug_enabled;

2865: l_report_param_val varchar2(30);
2866:
2867: BEGIN
2868:
2869: g_debug := hr_utility.debug_enabled;
2870:
2871: IF g_debug
2872: THEN
2873: hr_utility.set_location('range_person_on',10);

Line 2873: hr_utility.set_location('range_person_on',10);

2869: g_debug := hr_utility.debug_enabled;
2870:
2871: IF g_debug
2872: THEN
2873: hr_utility.set_location('range_person_on',10);
2874: END IF;
2875:
2876: BEGIN
2877:

Line 2884: hr_utility.set_location('range_person_on',20);

2880: close csr_action_parameter;
2881:
2882: IF g_debug
2883: THEN
2884: hr_utility.set_location('range_person_on',20);
2885: END IF;
2886:
2887: open csr_range_format_param;
2888: fetch csr_range_format_param into l_report_param_val;

Line 2892: hr_utility.set_location('range_person_on',30);

2888: fetch csr_range_format_param into l_report_param_val;
2889: close csr_range_format_param;
2890: IF g_debug
2891: THEN
2892: hr_utility.set_location('range_person_on',30);
2893: END IF;
2894: EXCEPTION WHEN NO_DATA_FOUND THEN
2895: l_return := FALSE;
2896: END;

Line 2900: hr_utility.set_location('range_person_on',40);

2896: END;
2897: --
2898: IF g_debug
2899: THEN
2900: hr_utility.set_location('range_person_on',40);
2901: END IF;
2902:
2903: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
2904: l_return := TRUE;

Line 2905: hr_utility.trace('Range Person = True');

2901: END IF;
2902:
2903: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
2904: l_return := TRUE;
2905: hr_utility.trace('Range Person = True');
2906: ELSE
2907: l_return := FALSE;
2908: END IF;
2909: --

Line 3239: g_debug := hr_utility.debug_enabled;

3235:
3236:
3237: begin
3238:
3239: g_debug := hr_utility.debug_enabled;
3240:
3241: IF g_debug THEN
3242: hr_utility.set_location('Start of assignment_action_code',1);
3243: END IF;

Line 3242: hr_utility.set_location('Start of assignment_action_code',1);

3238:
3239: g_debug := hr_utility.debug_enabled;
3240:
3241: IF g_debug THEN
3242: hr_utility.set_location('Start of assignment_action_code',1);
3243: END IF;
3244: -------------------------------------------------------------
3245: -- get the paramters for archival process
3246: -------------------------------------------------------------

Line 3262: hr_utility.trace('p_assignment_id :'||l_assignment_id);

3258: ,l_business_group_id ;
3259: close get_params;
3260:
3261: if g_debug then
3262: hr_utility.trace('p_assignment_id :'||l_assignment_id);
3263: hr_utility.trace('p_business_group_id :'||l_business_group_id);
3264: hr_utility.trace('p_legal_employer :' ||l_legal_employer);
3265: hr_utility.trace('p_employee_type :'||l_employee_type);
3266: hr_utility.trace('p_payroll_id :'|| l_payroll_id);

Line 3263: hr_utility.trace('p_business_group_id :'||l_business_group_id);

3259: close get_params;
3260:
3261: if g_debug then
3262: hr_utility.trace('p_assignment_id :'||l_assignment_id);
3263: hr_utility.trace('p_business_group_id :'||l_business_group_id);
3264: hr_utility.trace('p_legal_employer :' ||l_legal_employer);
3265: hr_utility.trace('p_employee_type :'||l_employee_type);
3266: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
3267: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);

Line 3264: hr_utility.trace('p_legal_employer :' ||l_legal_employer);

3260:
3261: if g_debug then
3262: hr_utility.trace('p_assignment_id :'||l_assignment_id);
3263: hr_utility.trace('p_business_group_id :'||l_business_group_id);
3264: hr_utility.trace('p_legal_employer :' ||l_legal_employer);
3265: hr_utility.trace('p_employee_type :'||l_employee_type);
3266: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
3267: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);
3268: hr_utility.trace('p_fin_year_end :' ||l_fin_year_end);

Line 3265: hr_utility.trace('p_employee_type :'||l_employee_type);

3261: if g_debug then
3262: hr_utility.trace('p_assignment_id :'||l_assignment_id);
3263: hr_utility.trace('p_business_group_id :'||l_business_group_id);
3264: hr_utility.trace('p_legal_employer :' ||l_legal_employer);
3265: hr_utility.trace('p_employee_type :'||l_employee_type);
3266: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
3267: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);
3268: hr_utility.trace('p_fin_year_end :' ||l_fin_year_end);
3269: hr_utility.trace('p_fbt_year_start :' ||l_fbt_year_start);

Line 3266: hr_utility.trace('p_payroll_id :'|| l_payroll_id);

3262: hr_utility.trace('p_assignment_id :'||l_assignment_id);
3263: hr_utility.trace('p_business_group_id :'||l_business_group_id);
3264: hr_utility.trace('p_legal_employer :' ||l_legal_employer);
3265: hr_utility.trace('p_employee_type :'||l_employee_type);
3266: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
3267: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);
3268: hr_utility.trace('p_fin_year_end :' ||l_fin_year_end);
3269: hr_utility.trace('p_fbt_year_start :' ||l_fbt_year_start);
3270: hr_utility.trace('p_fbt_year_end :' ||l_fbt_year_end);

Line 3267: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);

3263: hr_utility.trace('p_business_group_id :'||l_business_group_id);
3264: hr_utility.trace('p_legal_employer :' ||l_legal_employer);
3265: hr_utility.trace('p_employee_type :'||l_employee_type);
3266: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
3267: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);
3268: hr_utility.trace('p_fin_year_end :' ||l_fin_year_end);
3269: hr_utility.trace('p_fbt_year_start :' ||l_fbt_year_start);
3270: hr_utility.trace('p_fbt_year_end :' ||l_fbt_year_end);
3271: END if;

Line 3268: hr_utility.trace('p_fin_year_end :' ||l_fin_year_end);

3264: hr_utility.trace('p_legal_employer :' ||l_legal_employer);
3265: hr_utility.trace('p_employee_type :'||l_employee_type);
3266: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
3267: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);
3268: hr_utility.trace('p_fin_year_end :' ||l_fin_year_end);
3269: hr_utility.trace('p_fbt_year_start :' ||l_fbt_year_start);
3270: hr_utility.trace('p_fbt_year_end :' ||l_fbt_year_end);
3271: END if;
3272:

Line 3269: hr_utility.trace('p_fbt_year_start :' ||l_fbt_year_start);

3265: hr_utility.trace('p_employee_type :'||l_employee_type);
3266: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
3267: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);
3268: hr_utility.trace('p_fin_year_end :' ||l_fin_year_end);
3269: hr_utility.trace('p_fbt_year_start :' ||l_fbt_year_start);
3270: hr_utility.trace('p_fbt_year_end :' ||l_fbt_year_end);
3271: END if;
3272:
3273: IF (l_lst_yr_term = 'N') THEN

Line 3270: hr_utility.trace('p_fbt_year_end :' ||l_fbt_year_end);

3266: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
3267: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);
3268: hr_utility.trace('p_fin_year_end :' ||l_fin_year_end);
3269: hr_utility.trace('p_fbt_year_start :' ||l_fbt_year_start);
3270: hr_utility.trace('p_fbt_year_end :' ||l_fbt_year_end);
3271: END if;
3272:
3273: IF (l_lst_yr_term = 'N') THEN
3274: l_lst_yr_start := to_date('01/01/1900','DD/MM/YYYY');

Line 3307: hr_utility.set_location('Range Peron set - Use range cursor',1000);

3303: THEN
3304:
3305: IF g_debug
3306: THEN
3307: hr_utility.set_location('Range Peron set - Use range cursor',1000);
3308: END IF;
3309: FOR csr_rec IN c_range_asgids(l_assignment_id ,
3310: l_business_group_id ,
3311: l_legal_employer ,

Line 3323: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||l_asgid,2);

3319: l_lst_yr_start)
3320: LOOP
3321:
3322: IF g_debug THEN
3323: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||l_asgid,2);
3324: END if;
3325:
3326: OPEN next_action_id;
3327: FETCH next_action_id INTO l_next_action_id;

Line 3333: hr_utility.set_location('After calling hr_nonrun_asact.insact',3);

3329:
3330: hr_nonrun_asact.insact(l_next_action_id,csr_rec.assignment_id,p_payroll_action_id,p_chunk,null);
3331:
3332: IF g_debug THEN
3333: hr_utility.set_location('After calling hr_nonrun_asact.insact',3);
3334: END if;
3335:
3336: END LOOP;
3337:

Line 3358: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||l_asgid,2);

3354: close c_asgids;
3355: exit;
3356: ELSE
3357: IF g_debug THEN
3358: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||l_asgid,2);
3359: END if;
3360: OPEN next_action_id;
3361: FETCH next_action_id INTO l_next_action_id;
3362: CLOSE next_action_id;

Line 3366: hr_utility.set_location('After calling hr_nonrun_asact.insact',3);

3362: CLOSE next_action_id;
3363: hr_nonrun_asact.insact(l_next_action_id,l_asgid,p_payroll_action_id,p_chunk,null);
3364:
3365: IF g_debug THEN
3366: hr_utility.set_location('After calling hr_nonrun_asact.insact',3);
3367: END if;
3368: END IF;
3369: END LOOP;
3370: END IF; /* Range Person Check */

Line 3373: hr_utility.trace('before open');

3369: END LOOP;
3370: END IF; /* Range Person Check */
3371:
3372: ELSE -- only for Single Assignment
3373: hr_utility.trace('before open');
3374: OPEN c_asgid_only(l_assignment_id ,
3375: l_business_group_id ,
3376: l_legal_employer ,
3377: l_employee_type ,

Line 3386: hr_utility.trace('in loop');

3382: l_fbt_year_start ,
3383: l_fbt_year_end,
3384: l_lst_yr_start);
3385: LOOP
3386: hr_utility.trace('in loop');
3387: FETCH c_asgid_only INTO l_asgid;
3388: IF c_asgid_only%NOTFOUND THEN
3389: CLOSE c_asgid_only;
3390: EXIT;

Line 3393: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||l_asgid,2);

3389: CLOSE c_asgid_only;
3390: EXIT;
3391: ELSE
3392: IF g_debug THEN
3393: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||l_asgid,2);
3394: END IF;
3395: OPEN next_action_id;
3396: FETCH next_action_id INTO l_next_action_id;
3397: CLOSE next_action_id;

Line 3401: hr_utility.set_location('After calling hr_nonrun_asact.insact',3);

3397: CLOSE next_action_id;
3398: hr_nonrun_asact.insact(l_next_action_id,l_asgid,p_payroll_action_id,p_chunk,NULL);
3399:
3400: IF g_debug THEN
3401: hr_utility.set_location('After calling hr_nonrun_asact.insact',3);
3402: END if;
3403: END IF;
3404: END LOOP;
3405: END IF;

Line 3407: hr_utility.set_location('End of assignment_action_code',4);

3403: END IF;
3404: END LOOP;
3405: END IF;
3406: IF g_debug THEN
3407: hr_utility.set_location('End of assignment_action_code',4);
3408: END if;
3409:
3410: EXCEPTION
3411: WHEN OTHERS THEN

Line 3413: hr_utility.set_location('error raised in assignment_action_code procedure ',5);

3409:
3410: EXCEPTION
3411: WHEN OTHERS THEN
3412: IF g_debug THEN
3413: hr_utility.set_location('error raised in assignment_action_code procedure ',5);
3414: hr_utility.trace(sqlerrm);
3415: END if;
3416: raise;
3417: END;

Line 3414: hr_utility.trace(sqlerrm);

3410: EXCEPTION
3411: WHEN OTHERS THEN
3412: IF g_debug THEN
3413: hr_utility.set_location('error raised in assignment_action_code procedure ',5);
3414: hr_utility.trace(sqlerrm);
3415: END if;
3416: raise;
3417: END;
3418:

Line 3499: g_debug :=hr_utility.debug_enabled ;

3495:
3496: l_parameters csr_report_params%ROWTYPE;
3497:
3498: BEGIN
3499: g_debug :=hr_utility.debug_enabled ;
3500:
3501: IF g_debug THEN
3502: hr_utility.set_location('Start of spawn_ps_report',1);
3503: END if;

Line 3502: hr_utility.set_location('Start of spawn_ps_report',1);

3498: BEGIN
3499: g_debug :=hr_utility.debug_enabled ;
3500:
3501: IF g_debug THEN
3502: hr_utility.set_location('Start of spawn_ps_report',1);
3503: END if;
3504:
3505: l_count :=0;
3506: ps_request_id :=-1;

Line 3531: hr_utility.set_location('in BG_ID '||l_parameters.Business_group_id,1);

3527: END IF;
3528: /* End of 6839263 */
3529:
3530: IF g_debug THEN
3531: hr_utility.set_location('in BG_ID '||l_parameters.Business_group_id,1);
3532: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3533: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3534: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3535: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);

Line 3532: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);

3528: /* End of 6839263 */
3529:
3530: IF g_debug THEN
3531: hr_utility.set_location('in BG_ID '||l_parameters.Business_group_id,1);
3532: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3533: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3534: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3535: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3536: hr_utility.set_location('fin_year'||l_parameters.Financial_year,15);

Line 3533: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);

3529:
3530: IF g_debug THEN
3531: hr_utility.set_location('in BG_ID '||l_parameters.Business_group_id,1);
3532: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3533: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3534: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3535: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3536: hr_utility.set_location('fin_year'||l_parameters.Financial_year,15);
3537: hr_utility.set_location('lst_yr_trm'||l_parameters.lst_yr_term,16);

Line 3534: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);

3530: IF g_debug THEN
3531: hr_utility.set_location('in BG_ID '||l_parameters.Business_group_id,1);
3532: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3533: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3534: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3535: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3536: hr_utility.set_location('fin_year'||l_parameters.Financial_year,15);
3537: hr_utility.set_location('lst_yr_trm'||l_parameters.lst_yr_term,16);
3538: end if;

Line 3535: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);

3531: hr_utility.set_location('in BG_ID '||l_parameters.Business_group_id,1);
3532: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3533: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3534: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3535: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3536: hr_utility.set_location('fin_year'||l_parameters.Financial_year,15);
3537: hr_utility.set_location('lst_yr_trm'||l_parameters.lst_yr_term,16);
3538: end if;
3539:

Line 3536: hr_utility.set_location('fin_year'||l_parameters.Financial_year,15);

3532: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
3533: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3534: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3535: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3536: hr_utility.set_location('fin_year'||l_parameters.Financial_year,15);
3537: hr_utility.set_location('lst_yr_trm'||l_parameters.lst_yr_term,16);
3538: end if;
3539:
3540: IF g_debug THEN

Line 3537: hr_utility.set_location('lst_yr_trm'||l_parameters.lst_yr_term,16);

3533: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
3534: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
3535: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
3536: hr_utility.set_location('fin_year'||l_parameters.Financial_year,15);
3537: hr_utility.set_location('lst_yr_trm'||l_parameters.lst_yr_term,16);
3538: end if;
3539:
3540: IF g_debug THEN
3541: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);

Line 3541: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);

3537: hr_utility.set_location('lst_yr_trm'||l_parameters.lst_yr_term,16);
3538: end if;
3539:
3540: IF g_debug THEN
3541: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);
3542: hr_utility.set_location('Before calling report',24);
3543: END IF;
3544:
3545: OPEN csr_get_print_options(p_payroll_action_id);

Line 3542: hr_utility.set_location('Before calling report',24);

3538: end if;
3539:
3540: IF g_debug THEN
3541: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);
3542: hr_utility.set_location('Before calling report',24);
3543: END IF;
3544:
3545: OPEN csr_get_print_options(p_payroll_action_id);
3546: FETCH csr_get_print_options INTO rec_print_options;

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

3556: save_output => hr_general.char_to_bool(rec_print_options.save_output),
3557: print_together => l_print_together);
3558: -- Submit report
3559: IF g_debug THEN
3560: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,25);
3561: END IF;
3562:
3563: ps_request_id := fnd_request.submit_request
3564: ('PAY',

Line 3579: hr_utility.set_location('End of spawn_ps_report',4);

3575: 'P_PAYROLL_ID='||l_parameters.payroll_id,
3576: 'P_REGISTERED_EMPLOYER='||l_parameters.legal_employer);
3577:
3578: IF g_debug THEN
3579: hr_utility.set_location('End of spawn_ps_report',4);
3580: END IF;
3581:
3582: EXCEPTION
3583: WHEN others THEN

Line 3585: hr_utility.set_location('error raised in spawn_ps_report procedure ',5);

3581:
3582: EXCEPTION
3583: WHEN others THEN
3584: IF g_debug THEN
3585: hr_utility.set_location('error raised in spawn_ps_report procedure ',5);
3586: END if;
3587: RAISE;
3588: END;
3589:

Line 3594: g_debug := hr_utility.debug_enabled;

3590:
3591:
3592:
3593: begin
3594: g_debug := hr_utility.debug_enabled;
3595: g_pre01jul1983_value :=0;
3596: g_post30jun1983_value :=0;
3597: g_etp_gross :=0;
3598: g_etp_tax :=0;