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 286: g_debug := hr_utility.debug_enabled ;

282:
283: /*Bug#4863149 - Modification starts*/
284:
285: l_counter := 0;
286: g_debug := hr_utility.debug_enabled ;
287: g_balance_type_tab.delete;
288:
289:
290: FOR csr_bal in get_allowance_balance_types(c_assignment_id

Line 305: hr_utility.set_location('g_balance_type_tab(i) '||g_balance_type_tab(i),700);

301:
302: for i in g_balance_type_tab.FIRST..g_balance_type_tab.LAST
303: loop
304: if g_debug then
305: hr_utility.set_location('g_balance_type_tab(i) '||g_balance_type_tab(i),700);
306: end if;
307:
308: open c_allowance_balance(g_balance_type_tab(i));
309: fetch c_allowance_balance into t_allowance_balance(i).balance_name, allow_balance_value_tab(i).defined_balance_id; /* 4863149 */

Line 311: hr_utility.set_location('Defined balanced id not found for balance type id :'||g_balance_type_tab(i),700); /* 4863149 */

307:
308: open c_allowance_balance(g_balance_type_tab(i));
309: fetch c_allowance_balance into t_allowance_balance(i).balance_name, allow_balance_value_tab(i).defined_balance_id; /* 4863149 */
310: IF c_allowance_balance%NOTFOUND THEN
311: hr_utility.set_location('Defined balanced id not found for balance type id :'||g_balance_type_tab(i),700); /* 4863149 */
312: c_message := 'Allowance Balance Type ' || g_balance_type_tab(i) || ' not associated with dimension _ASG_LE_YTD';
313: RETURN 0;
314: END IF;
315: close c_allowance_balance;

Line 333: hr_utility.set_location('Assingment Action ID not found for Run in Year!!',300);

329: p_output_table=>allow_result_table);
330:
331: else
332: if g_debug then
333: hr_utility.set_location('Assingment Action ID not found for Run in Year!!',300);
334: end if;
335: end if;
336:
337: for i in g_balance_type_tab.FIRST..g_balance_type_tab.LAST

Line 340: hr_utility.set_location('g_balance_type_tab(i) '||g_balance_type_tab(i),700);

336:
337: for i in g_balance_type_tab.FIRST..g_balance_type_tab.LAST
338: loop
339: if g_debug then
340: hr_utility.set_location('g_balance_type_tab(i) '||g_balance_type_tab(i),700);
341: end if;
342:
343: t_allowance_balance(i).balance_value := allow_result_table(i).balance_value;
344:

Line 787: g_debug := hr_utility.debug_enabled;

783: and pbd.legislation_code = pbt.legislation_code
784: and pbd.legislation_code = pdb.legislation_code;
785:
786: BEGIN
787: g_debug := hr_utility.debug_enabled;
788:
789: ---Start of Bug#3749530------------------
790: g_business_group_id := p_business_group_id;
791: g_lst_yr_term := NVL(p_lst_yr_term,'Y'); --Bug3693034

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

806: c_dimension_name := '_ASG_YTD';
807: END IF;
808:
809: IF g_debug THEN
810: hr_utility.trace('Parameter p_le_level value => ' || p_le_level);
811: hr_utility.trace('Dimension is => ' || c_dimension_name);
812: END IF;
813:
814: /* End of Bug: 3186840 */

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

807: END IF;
808:
809: IF g_debug THEN
810: hr_utility.trace('Parameter p_le_level value => ' || p_le_level);
811: hr_utility.trace('Dimension is => ' || c_dimension_name);
812: END IF;
813:
814: /* End of Bug: 3186840 */
815:

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

857: g_input_table(i).defined_balance_id :=l_def_bal_id;--Bug# 3193479
858: g_input_table(i).balance_value := NULL;
859:
860: IF g_debug THEN
861: hr_utility.trace(i || ' Defined Balance id of ' || l_bal_name || '=> ' || g_input_table(i).defined_balance_id);
862: END IF;
863:
864: i:=i+1;
865: END LOOP;

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

926: where aa.assignment_id = c_assignment_id); /*Bug 4256486 */
927:
928: begin
929: if g_debug then
930: hr_utility.set_location('Start of archive_prepost_details',15);
931: END if;
932: -- Added for bug 3686549
933: l_current_employee_flag := 'Y';
934: IF (g_lst_yr_term = 'N') THEN

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

968: --------------------------------------------------------------------------------+
969: -- this procedure gets the ratios to calculate prejul83 balance and postjun83 balance
970: --------------------------------------------------------------------------------+
971: if g_debug then
972: hr_utility.set_location('calling pay_au_terminations.etp_prepost_ratios ',15);
973: END if;
974:
975: l_result :=pay_au_terminations.etp_prepost_ratios(
976: p_assignment_id -- number in

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

995:
996:
997: end if;
998: if g_debug then
999: hr_utility.set_location('End of archive_prepost_details',14);
1000: END if;
1001: g_etp_gross:=g_pre01jul1983_value+g_post30jun1983_value+Total_Invalidity_Payments;
1002: g_assessable:= round(g_post30jun1983_value,2); /* Bug 4872594 - Changed to Round upto 2 decimals */
1003: /* Bug No : 7030285 - Assessable Income modified */

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

1021:
1022: exception
1023: when e_prepost_error then
1024: if g_debug then
1025: hr_utility.set_location('error from pay_au_terminations.etp_prepost_ratios',20);
1026: END if;
1027: when others then
1028: if g_debug then
1029: hr_utility.set_location('error in function_prepost_details',21);

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

1025: hr_utility.set_location('error from pay_au_terminations.etp_prepost_ratios',20);
1026: END if;
1027: when others then
1028: if g_debug then
1029: hr_utility.set_location('error in function_prepost_details',21);
1030: END if;
1031: raise;
1032: end etp_details;
1033:

Line 1351: g_debug := hr_utility.debug_enabled;

1347: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
1348:
1349: BEGIN
1350:
1351: g_debug := hr_utility.debug_enabled;
1352:
1353: g_dimension_name := p_dimension_name;
1354:
1355: IF g_debug THEN

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

1352:
1353: g_dimension_name := p_dimension_name;
1354:
1355: IF g_debug THEN
1356: hr_utility.trace('Dimension is ' || p_dimension_name);
1357: END IF;
1358:
1359: /* Group Level Defined Balance IDs get stored in the PL/SQL table with the following order.
1360:

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

1383: LOOP
1384: g_input_group_details_table(csr_rec.sort_index).defined_balance_id := csr_rec.defined_balance_id;
1385:
1386: IF g_debug THEN
1387: hr_utility.trace(csr_rec.sort_index || ' ' || g_input_group_details_table(csr_rec.sort_index).defined_balance_id);
1388: END IF;
1389:
1390: END LOOP;
1391:

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

1423: IF g_debug THEN
1424: FOR i IN 1..g_result_group_details_table.last
1425: LOOP
1426: IF g_result_group_details_table.exists(i) THEN
1427: hr_utility.trace('Balance Value ' || i || g_result_group_details_table(i).balance_value);
1428: END IF;
1429: END LOOP;
1430: END IF;
1431:

Line 1469: g_debug := hr_utility.debug_enabled;

1465: g_debug boolean;
1466:
1467: BEGIN
1468:
1469: g_debug := hr_utility.debug_enabled;
1470:
1471: g_pre01jul1983_value :=0;
1472: g_post30jun1983_value :=0;
1473: g_etp_gross :=0;

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

1512: FOR i IN 1..g_input_term_details_table.last
1513: LOOP
1514: IF g_input_term_details_table.exists(i) THEN
1515: IF g_debug THEN
1516: hr_utility.trace(i || ' ' || g_input_term_details_table(i).defined_balance_id);
1517: END IF;
1518: END IF;
1519: END LOOP;
1520:

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

1527: IF g_debug THEN
1528: FOR i IN 1..g_result_term_details_table.last
1529: LOOP
1530: IF g_result_term_details_table.exists(i) THEN
1531: hr_utility.trace('Balance Value ' || i || g_result_term_details_table(i).balance_value);
1532: END IF;
1533: END LOOP;
1534: END IF;
1535:

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

1554: IF g_debug THEN
1555: FOR i IN 1..bal_id.last
1556: LOOP
1557: IF bal_id.exists(i) THEN
1558: hr_utility.trace('Output Balance Value ' || i || bal_id(i).balance_value);
1559: END IF;
1560: END LOOP;
1561: END IF;
1562:

Line 1588: g_debug := hr_utility.debug_enabled;

1584: procedure range_code
1585: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
1586: p_sql out nocopy varchar2) is
1587: begin
1588: g_debug := hr_utility.debug_enabled;
1589: IF g_debug THEN
1590: hr_utility.set_location('Start of range_code',1);
1591: END if;
1592: p_sql := ' select distinct p.person_id' ||

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

1586: p_sql out nocopy varchar2) is
1587: begin
1588: g_debug := hr_utility.debug_enabled;
1589: IF g_debug THEN
1590: hr_utility.set_location('Start of range_code',1);
1591: END if;
1592: p_sql := ' select distinct p.person_id' ||
1593: ' from per_people_f p,' ||
1594: ' pay_payroll_actions pa' ||

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

1595: ' where pa.payroll_action_id = :payroll_action_id' ||
1596: ' and p.business_group_id = pa.business_group_id' ||
1597: ' order by p.person_id';
1598: IF g_debug THEN
1599: hr_utility.set_location('End of range_code',2);
1600: END if;
1601: end range_code;
1602:
1603:

Line 1653: g_debug := hr_utility.debug_enabled;

1649: l_report_param_val varchar2(30);
1650:
1651: BEGIN
1652:
1653: g_debug := hr_utility.debug_enabled;
1654:
1655: IF g_debug
1656: THEN
1657: hr_utility.set_location('range_person_on',10);

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

1653: g_debug := hr_utility.debug_enabled;
1654:
1655: IF g_debug
1656: THEN
1657: hr_utility.set_location('range_person_on',10);
1658: END IF;
1659:
1660: BEGIN
1661:

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

1664: close csr_action_parameter;
1665:
1666: IF g_debug
1667: THEN
1668: hr_utility.set_location('range_person_on',20);
1669: END IF;
1670:
1671: open csr_range_format_param;
1672: fetch csr_range_format_param into l_report_param_val;

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

1672: fetch csr_range_format_param into l_report_param_val;
1673: close csr_range_format_param;
1674: IF g_debug
1675: THEN
1676: hr_utility.set_location('range_person_on',30);
1677: END IF;
1678: EXCEPTION WHEN NO_DATA_FOUND THEN
1679: l_return := FALSE;
1680: END;

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

1680: END;
1681: --
1682: IF g_debug
1683: THEN
1684: hr_utility.set_location('range_person_on',40);
1685: END IF;
1686:
1687: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
1688: l_return := TRUE;

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

1685: END IF;
1686:
1687: IF l_action_param_val = 'Y' AND l_report_param_val = 'Y' THEN
1688: l_return := TRUE;
1689: hr_utility.trace('Range Person = True');
1690: ELSE
1691: l_return := FALSE;
1692: END IF;
1693: --

Line 1998: g_debug := hr_utility.debug_enabled;

1994:
1995:
1996: begin
1997:
1998: g_debug := hr_utility.debug_enabled;
1999:
2000: IF g_debug THEN
2001: hr_utility.set_location('Start of assignment_action_code',1);
2002: END IF;

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

1997:
1998: g_debug := hr_utility.debug_enabled;
1999:
2000: IF g_debug THEN
2001: hr_utility.set_location('Start of assignment_action_code',1);
2002: END IF;
2003: -------------------------------------------------------------
2004: -- get the paramters for archival process
2005: -------------------------------------------------------------

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

2017: ,l_business_group_id ;
2018: close get_params;
2019:
2020: if g_debug then
2021: hr_utility.trace('p_assignment_id :'||l_assignment_id);
2022: hr_utility.trace('p_business_group_id :'||l_business_group_id);
2023: hr_utility.trace('p_legal_employer :' ||l_legal_employer);
2024: hr_utility.trace('p_employee_type :'||l_employee_type);
2025: hr_utility.trace('p_payroll_id :'|| l_payroll_id);

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

2018: close get_params;
2019:
2020: if g_debug then
2021: hr_utility.trace('p_assignment_id :'||l_assignment_id);
2022: hr_utility.trace('p_business_group_id :'||l_business_group_id);
2023: hr_utility.trace('p_legal_employer :' ||l_legal_employer);
2024: hr_utility.trace('p_employee_type :'||l_employee_type);
2025: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
2026: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);

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

2019:
2020: if g_debug then
2021: hr_utility.trace('p_assignment_id :'||l_assignment_id);
2022: hr_utility.trace('p_business_group_id :'||l_business_group_id);
2023: hr_utility.trace('p_legal_employer :' ||l_legal_employer);
2024: hr_utility.trace('p_employee_type :'||l_employee_type);
2025: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
2026: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);
2027: hr_utility.trace('p_fin_year_end :' ||l_fin_year_end);

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

2020: if g_debug then
2021: hr_utility.trace('p_assignment_id :'||l_assignment_id);
2022: hr_utility.trace('p_business_group_id :'||l_business_group_id);
2023: hr_utility.trace('p_legal_employer :' ||l_legal_employer);
2024: hr_utility.trace('p_employee_type :'||l_employee_type);
2025: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
2026: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);
2027: hr_utility.trace('p_fin_year_end :' ||l_fin_year_end);
2028: hr_utility.trace('p_fbt_year_start :' ||l_fbt_year_start);

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

2021: hr_utility.trace('p_assignment_id :'||l_assignment_id);
2022: hr_utility.trace('p_business_group_id :'||l_business_group_id);
2023: hr_utility.trace('p_legal_employer :' ||l_legal_employer);
2024: hr_utility.trace('p_employee_type :'||l_employee_type);
2025: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
2026: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);
2027: hr_utility.trace('p_fin_year_end :' ||l_fin_year_end);
2028: hr_utility.trace('p_fbt_year_start :' ||l_fbt_year_start);
2029: hr_utility.trace('p_fbt_year_end :' ||l_fbt_year_end);

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

2022: hr_utility.trace('p_business_group_id :'||l_business_group_id);
2023: hr_utility.trace('p_legal_employer :' ||l_legal_employer);
2024: hr_utility.trace('p_employee_type :'||l_employee_type);
2025: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
2026: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);
2027: hr_utility.trace('p_fin_year_end :' ||l_fin_year_end);
2028: hr_utility.trace('p_fbt_year_start :' ||l_fbt_year_start);
2029: hr_utility.trace('p_fbt_year_end :' ||l_fbt_year_end);
2030: END if;

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

2023: hr_utility.trace('p_legal_employer :' ||l_legal_employer);
2024: hr_utility.trace('p_employee_type :'||l_employee_type);
2025: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
2026: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);
2027: hr_utility.trace('p_fin_year_end :' ||l_fin_year_end);
2028: hr_utility.trace('p_fbt_year_start :' ||l_fbt_year_start);
2029: hr_utility.trace('p_fbt_year_end :' ||l_fbt_year_end);
2030: END if;
2031:

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

2024: hr_utility.trace('p_employee_type :'||l_employee_type);
2025: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
2026: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);
2027: hr_utility.trace('p_fin_year_end :' ||l_fin_year_end);
2028: hr_utility.trace('p_fbt_year_start :' ||l_fbt_year_start);
2029: hr_utility.trace('p_fbt_year_end :' ||l_fbt_year_end);
2030: END if;
2031:
2032: IF (l_lst_yr_term = 'N') THEN

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

2025: hr_utility.trace('p_payroll_id :'|| l_payroll_id);
2026: hr_utility.trace('p_fin_year_start :' ||l_fin_year_start);
2027: hr_utility.trace('p_fin_year_end :' ||l_fin_year_end);
2028: hr_utility.trace('p_fbt_year_start :' ||l_fbt_year_start);
2029: hr_utility.trace('p_fbt_year_end :' ||l_fbt_year_end);
2030: END if;
2031:
2032: IF (l_lst_yr_term = 'N') THEN
2033: l_lst_yr_start := to_date('01/01/1900','DD/MM/YYYY');

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

2062: THEN
2063:
2064: IF g_debug
2065: THEN
2066: hr_utility.set_location('Range Peron set - Use range cursor',1000);
2067: END IF;
2068: FOR csr_rec IN c_range_asgids(l_assignment_id ,
2069: l_business_group_id ,
2070: l_legal_employer ,

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

2078: l_lst_yr_start)
2079: LOOP
2080:
2081: IF g_debug THEN
2082: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||l_asgid,2);
2083: END if;
2084:
2085: OPEN next_action_id;
2086: FETCH next_action_id INTO l_next_action_id;

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

2088:
2089: hr_nonrun_asact.insact(l_next_action_id,csr_rec.assignment_id,p_payroll_action_id,p_chunk,null);
2090:
2091: IF g_debug THEN
2092: hr_utility.set_location('After calling hr_nonrun_asact.insact',3);
2093: END if;
2094:
2095: END LOOP;
2096:

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

2113: close c_asgids;
2114: exit;
2115: ELSE
2116: IF g_debug THEN
2117: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||l_asgid,2);
2118: END if;
2119: OPEN next_action_id;
2120: FETCH next_action_id INTO l_next_action_id;
2121: CLOSE next_action_id;

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

2121: CLOSE next_action_id;
2122: hr_nonrun_asact.insact(l_next_action_id,l_asgid,p_payroll_action_id,p_chunk,null);
2123:
2124: IF g_debug THEN
2125: hr_utility.set_location('After calling hr_nonrun_asact.insact',3);
2126: END if;
2127: END IF;
2128: END LOOP;
2129: END IF; /* Range Person Check */

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

2128: END LOOP;
2129: END IF; /* Range Person Check */
2130:
2131: ELSE -- only for Single Assignment
2132: hr_utility.trace('before open');
2133: OPEN c_asgid_only(l_assignment_id ,
2134: l_business_group_id ,
2135: l_legal_employer ,
2136: l_employee_type ,

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

2141: l_fbt_year_start ,
2142: l_fbt_year_end,
2143: l_lst_yr_start);
2144: LOOP
2145: hr_utility.trace('in loop');
2146: FETCH c_asgid_only INTO l_asgid;
2147: IF c_asgid_only%NOTFOUND THEN
2148: CLOSE c_asgid_only;
2149: EXIT;

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

2148: CLOSE c_asgid_only;
2149: EXIT;
2150: ELSE
2151: IF g_debug THEN
2152: hr_utility.set_location('Calling hr_nonrun_asact.insact for assignment id :'||l_asgid,2);
2153: END IF;
2154: OPEN next_action_id;
2155: FETCH next_action_id INTO l_next_action_id;
2156: CLOSE next_action_id;

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

2156: CLOSE next_action_id;
2157: hr_nonrun_asact.insact(l_next_action_id,l_asgid,p_payroll_action_id,p_chunk,NULL);
2158:
2159: IF g_debug THEN
2160: hr_utility.set_location('After calling hr_nonrun_asact.insact',3);
2161: END if;
2162: END IF;
2163: END LOOP;
2164: END IF;

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

2162: END IF;
2163: END LOOP;
2164: END IF;
2165: IF g_debug THEN
2166: hr_utility.set_location('End of assignment_action_code',4);
2167: END if;
2168:
2169: EXCEPTION
2170: WHEN OTHERS THEN

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

2168:
2169: EXCEPTION
2170: WHEN OTHERS THEN
2171: IF g_debug THEN
2172: hr_utility.set_location('error raised in assignment_action_code procedure ',5);
2173: hr_utility.trace(sqlerrm);
2174: END if;
2175: raise;
2176: END;

Line 2173: hr_utility.trace(sqlerrm);

2169: EXCEPTION
2170: WHEN OTHERS THEN
2171: IF g_debug THEN
2172: hr_utility.set_location('error raised in assignment_action_code procedure ',5);
2173: hr_utility.trace(sqlerrm);
2174: END if;
2175: raise;
2176: END;
2177:

Line 2258: g_debug :=hr_utility.debug_enabled ;

2254:
2255: l_parameters csr_report_params%ROWTYPE;
2256:
2257: BEGIN
2258: g_debug :=hr_utility.debug_enabled ;
2259:
2260: IF g_debug THEN
2261: hr_utility.set_location('Start of spawn_ps_report',1);
2262: END if;

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

2257: BEGIN
2258: g_debug :=hr_utility.debug_enabled ;
2259:
2260: IF g_debug THEN
2261: hr_utility.set_location('Start of spawn_ps_report',1);
2262: END if;
2263:
2264: l_count :=0;
2265: ps_request_id :=-1;

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

2286: END IF;
2287: /* End of 6839263 */
2288:
2289: IF g_debug THEN
2290: hr_utility.set_location('in BG_ID '||l_parameters.Business_group_id,1);
2291: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2292: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2293: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2294: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);

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

2287: /* End of 6839263 */
2288:
2289: IF g_debug THEN
2290: hr_utility.set_location('in BG_ID '||l_parameters.Business_group_id,1);
2291: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2292: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2293: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2294: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2295: hr_utility.set_location('fin_year'||l_parameters.Financial_year,15);

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

2288:
2289: IF g_debug THEN
2290: hr_utility.set_location('in BG_ID '||l_parameters.Business_group_id,1);
2291: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2292: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2293: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2294: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2295: hr_utility.set_location('fin_year'||l_parameters.Financial_year,15);
2296: hr_utility.set_location('lst_yr_trm'||l_parameters.lst_yr_term,16);

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

2289: IF g_debug THEN
2290: hr_utility.set_location('in BG_ID '||l_parameters.Business_group_id,1);
2291: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2292: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2293: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2294: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2295: hr_utility.set_location('fin_year'||l_parameters.Financial_year,15);
2296: hr_utility.set_location('lst_yr_trm'||l_parameters.lst_yr_term,16);
2297: end if;

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

2290: hr_utility.set_location('in BG_ID '||l_parameters.Business_group_id,1);
2291: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2292: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2293: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2294: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2295: hr_utility.set_location('fin_year'||l_parameters.Financial_year,15);
2296: hr_utility.set_location('lst_yr_trm'||l_parameters.lst_yr_term,16);
2297: end if;
2298:

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

2291: hr_utility.set_location('in payroll_parameters.id '||l_parameters.payroll_id,3);
2292: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2293: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2294: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2295: hr_utility.set_location('fin_year'||l_parameters.Financial_year,15);
2296: hr_utility.set_location('lst_yr_trm'||l_parameters.lst_yr_term,16);
2297: end if;
2298:
2299: IF g_debug THEN

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

2292: hr_utility.set_location('in asg_id '||l_parameters.assignment_id,4);
2293: hr_utility.set_location('in legal employer '||l_parameters.legal_employer,8);
2294: hr_utility.set_location('in emp_type '||l_parameters.employee_type,14);
2295: hr_utility.set_location('fin_year'||l_parameters.Financial_year,15);
2296: hr_utility.set_location('lst_yr_trm'||l_parameters.lst_yr_term,16);
2297: end if;
2298:
2299: IF g_debug THEN
2300: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);

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

2296: hr_utility.set_location('lst_yr_trm'||l_parameters.lst_yr_term,16);
2297: end if;
2298:
2299: IF g_debug THEN
2300: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);
2301: hr_utility.set_location('Before calling report',24);
2302: END IF;
2303:
2304: OPEN csr_get_print_options(p_payroll_action_id);

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

2297: end if;
2298:
2299: IF g_debug THEN
2300: hr_utility.set_location('Afer payroll action ' || p_payroll_action_id , 125);
2301: hr_utility.set_location('Before calling report',24);
2302: END IF;
2303:
2304: OPEN csr_get_print_options(p_payroll_action_id);
2305: FETCH csr_get_print_options INTO rec_print_options;

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

2315: save_output => hr_general.char_to_bool(rec_print_options.save_output),
2316: print_together => l_print_together);
2317: -- Submit report
2318: IF g_debug THEN
2319: hr_utility.set_location('payroll_action id '|| p_payroll_action_id,25);
2320: END IF;
2321:
2322: ps_request_id := fnd_request.submit_request
2323: ('PAY',

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

2334: 'P_PAYROLL_ID='||l_parameters.payroll_id,
2335: 'P_REGISTERED_EMPLOYER='||l_parameters.legal_employer);
2336:
2337: IF g_debug THEN
2338: hr_utility.set_location('End of spawn_ps_report',4);
2339: END IF;
2340:
2341: EXCEPTION
2342: WHEN others THEN

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

2340:
2341: EXCEPTION
2342: WHEN others THEN
2343: IF g_debug THEN
2344: hr_utility.set_location('error raised in spawn_ps_report procedure ',5);
2345: END if;
2346: RAISE;
2347: END;
2348:

Line 2353: g_debug := hr_utility.debug_enabled;

2349:
2350:
2351:
2352: begin
2353: g_debug := hr_utility.debug_enabled;
2354: g_pre01jul1983_value :=0;
2355: g_post30jun1983_value :=0;
2356: g_etp_gross :=0;
2357: g_etp_tax :=0;