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

Line 215: hr_utility.trace('Get reprocess type bgid :' || to_char(pay_proc_environment_pkg.bgid));

211: when no_data_found then
212: --
213: begin
214: --
215: hr_utility.trace('Get reprocess type bgid :' || to_char(pay_proc_environment_pkg.bgid));
216: hr_utility.trace('Get reprocess type legc:' || pay_proc_environment_pkg.legc);
217:
218: select prcu.reprocess_type
219: into l_reprocess_type

Line 216: hr_utility.trace('Get reprocess type legc:' || pay_proc_environment_pkg.legc);

212: --
213: begin
214: --
215: hr_utility.trace('Get reprocess type bgid :' || to_char(pay_proc_environment_pkg.bgid));
216: hr_utility.trace('Get reprocess type legc:' || pay_proc_environment_pkg.legc);
217:
218: select prcu.reprocess_type
219: into l_reprocess_type
220: from pay_retro_component_usages prcu

Line 451: hr_utility.trace('Clash : '||p_entry_id||' '||p_aa_id);

447: --
448: exception
449: when others then
450:
451: hr_utility.trace('Clash : '||p_entry_id||' '||p_aa_id);
452: for rr in c_rr loop
453: hr_utility.trace(rr.element_type_id||' '||rr.element_entry_id);
454: end loop;
455:

Line 453: hr_utility.trace(rr.element_type_id||' '||rr.element_entry_id);

449: when others then
450:
451: hr_utility.trace('Clash : '||p_entry_id||' '||p_aa_id);
452: for rr in c_rr loop
453: hr_utility.trace(rr.element_type_id||' '||rr.element_entry_id);
454: end loop;
455:
456: raise;
457: end;

Line 502: hr_utility.trace('p_payroll_id:'||p_payroll_id);

498: declare
499: l_leg_code per_business_groups_perf.legislation_code%type;
500: begin
501: --
502: hr_utility.trace('p_payroll_id:'||p_payroll_id);
503: hr_utility.trace('p_assact_id:'||p_assact_id);
504: select legislation_code
505: into l_leg_code
506: from per_business_groups_perf

Line 503: hr_utility.trace('p_assact_id:'||p_assact_id);

499: l_leg_code per_business_groups_perf.legislation_code%type;
500: begin
501: --
502: hr_utility.trace('p_payroll_id:'||p_payroll_id);
503: hr_utility.trace('p_assact_id:'||p_assact_id);
504: select legislation_code
505: into l_leg_code
506: from per_business_groups_perf
507: where business_group_id = p_business_group_id;

Line 879: -- hr_utility.trace(' Returned component_id is '||l_retro_comp_id);

875: p_element_entry_id,
876: p_ef_date,
877: null); -- Direct calls should also pass element_type_id
878: --
879: -- hr_utility.trace(' Returned component_id is '||l_retro_comp_id);
880: return l_retro_comp_id;
881: END get_retro_component_id;
882: --
883: /*

Line 1296: hr_utility.set_location('Entry Proc Path in correct format', 10);

1292: n := instr(p_entry_process_path, '[');
1293: epath_length := length(p_entry_process_path);
1294: --
1295: if (n <> 0) then
1296: hr_utility.set_location('Entry Proc Path in correct format', 10);
1297: l_entry_path := p_entry_process_path;
1298: else
1299: hr_utility.set_location('Convert Entry Proc Path: ' || p_entry_process_path, 20);
1300: --

Line 1299: hr_utility.set_location('Convert Entry Proc Path: ' || p_entry_process_path, 20);

1295: if (n <> 0) then
1296: hr_utility.set_location('Entry Proc Path in correct format', 10);
1297: l_entry_path := p_entry_process_path;
1298: else
1299: hr_utility.set_location('Convert Entry Proc Path: ' || p_entry_process_path, 20);
1300: --
1301: /* find first element type */
1302: curr_pos := instr(p_entry_process_path, '.', 1,counter);
1303: curr_et := substr(p_entry_process_path, 1, curr_pos-1);

Line 1313: hr_utility.set_location('Entry Path: ' || curr_epath || 'Counter: ' || to_char(counter), 30);

1309: if (curr_pos = 0) then
1310: l_entry_path := p_entry_process_path;
1311: else
1312: while(last_element = 0) loop
1313: hr_utility.set_location('Entry Path: ' || curr_epath || 'Counter: ' || to_char(counter), 30);
1314: --
1315: if (next_pos = 0) then
1316: next_et := substr(p_entry_process_path, curr_pos+1, epath_length-curr_pos);
1317: else

Line 1322: hr_utility.set_location('If Same Element Type', 40);

1318: next_et := substr(p_entry_process_path, curr_pos+1, next_pos-1-curr_pos);
1319: end if;
1320: --
1321: if (curr_et = next_et) then
1322: hr_utility.set_location('If Same Element Type', 40);
1323: while ((curr_et = next_et) and (last_element = 0)) loop
1324: hr_utility.set_location('While Same Element Type: ' || curr_et || ' ' || next_et, 50);
1325: hr_utility.set_location('Curr Pos and Next Pos: ' || to_char(curr_pos) || ' ' || to_char(next_pos), 55);
1326: recursive_level := recursive_level+1;

Line 1324: hr_utility.set_location('While Same Element Type: ' || curr_et || ' ' || next_et, 50);

1320: --
1321: if (curr_et = next_et) then
1322: hr_utility.set_location('If Same Element Type', 40);
1323: while ((curr_et = next_et) and (last_element = 0)) loop
1324: hr_utility.set_location('While Same Element Type: ' || curr_et || ' ' || next_et, 50);
1325: hr_utility.set_location('Curr Pos and Next Pos: ' || to_char(curr_pos) || ' ' || to_char(next_pos), 55);
1326: recursive_level := recursive_level+1;
1327: --
1328: hr_utility.set_location('Recursive Level: ' || to_char(recursive_level), 56);

Line 1325: hr_utility.set_location('Curr Pos and Next Pos: ' || to_char(curr_pos) || ' ' || to_char(next_pos), 55);

1321: if (curr_et = next_et) then
1322: hr_utility.set_location('If Same Element Type', 40);
1323: while ((curr_et = next_et) and (last_element = 0)) loop
1324: hr_utility.set_location('While Same Element Type: ' || curr_et || ' ' || next_et, 50);
1325: hr_utility.set_location('Curr Pos and Next Pos: ' || to_char(curr_pos) || ' ' || to_char(next_pos), 55);
1326: recursive_level := recursive_level+1;
1327: --
1328: hr_utility.set_location('Recursive Level: ' || to_char(recursive_level), 56);
1329: if (next_pos = 0) then

Line 1328: hr_utility.set_location('Recursive Level: ' || to_char(recursive_level), 56);

1324: hr_utility.set_location('While Same Element Type: ' || curr_et || ' ' || next_et, 50);
1325: hr_utility.set_location('Curr Pos and Next Pos: ' || to_char(curr_pos) || ' ' || to_char(next_pos), 55);
1326: recursive_level := recursive_level+1;
1327: --
1328: hr_utility.set_location('Recursive Level: ' || to_char(recursive_level), 56);
1329: if (next_pos = 0) then
1330: last_element := 1;
1331: next_et := substr(p_entry_process_path, curr_pos+1, epath_length-curr_pos);
1332: hr_utility.set_location('Next ET: ' || next_et || 'Curr Pos: ' || curr_pos, 81);

Line 1332: hr_utility.set_location('Next ET: ' || next_et || 'Curr Pos: ' || curr_pos, 81);

1328: hr_utility.set_location('Recursive Level: ' || to_char(recursive_level), 56);
1329: if (next_pos = 0) then
1330: last_element := 1;
1331: next_et := substr(p_entry_process_path, curr_pos+1, epath_length-curr_pos);
1332: hr_utility.set_location('Next ET: ' || next_et || 'Curr Pos: ' || curr_pos, 81);
1333: else
1334: curr_pos := next_pos;
1335: counter := counter +1;
1336: next_pos := instr(p_entry_process_path, '.', 1, counter);

Line 1342: hr_utility.set_location('Next ET: ' || next_et, 82);

1338: next_et := substr(p_entry_process_path, curr_pos+1, epath_length-curr_pos);
1339: else
1340: next_et := substr(p_entry_process_path, curr_pos+1, next_pos-1-curr_pos);
1341: end if;
1342: hr_utility.set_location('Next ET: ' || next_et, 82);
1343: end if;
1344: end loop;
1345: --
1346: hr_utility.set_location('Entry Path: ' || curr_epath, 100);

Line 1346: hr_utility.set_location('Entry Path: ' || curr_epath, 100);

1342: hr_utility.set_location('Next ET: ' || next_et, 82);
1343: end if;
1344: end loop;
1345: --
1346: hr_utility.set_location('Entry Path: ' || curr_epath, 100);
1347: --
1348: if (curr_epath is null) then
1349: curr_epath := curr_et || '[' || to_char(recursive_level) || ']';
1350: else

Line 1357: hr_utility.set_location('Entry Path: ' || curr_epath, 200);

1353:
1354: if ((last_element = 1) and (curr_et <> next_et)) then
1355: curr_epath := curr_epath || '.' || next_et;
1356: end if;
1357: hr_utility.set_location('Entry Path: ' || curr_epath, 200);
1358: --
1359: else
1360: hr_utility.set_location('If Not Same Element Type: ' || curr_et || ' ' || next_et, 60);
1361: recursive_level := 1;

Line 1360: hr_utility.set_location('If Not Same Element Type: ' || curr_et || ' ' || next_et, 60);

1356: end if;
1357: hr_utility.set_location('Entry Path: ' || curr_epath, 200);
1358: --
1359: else
1360: hr_utility.set_location('If Not Same Element Type: ' || curr_et || ' ' || next_et, 60);
1361: recursive_level := 1;
1362: --
1363: hr_utility.set_location('Entry Path: ' || curr_epath, 300);
1364: --

Line 1363: hr_utility.set_location('Entry Path: ' || curr_epath, 300);

1359: else
1360: hr_utility.set_location('If Not Same Element Type: ' || curr_et || ' ' || next_et, 60);
1361: recursive_level := 1;
1362: --
1363: hr_utility.set_location('Entry Path: ' || curr_epath, 300);
1364: --
1365: if (curr_epath is null) then
1366: curr_epath := curr_et || '.' || next_et;
1367: else

Line 1380: hr_utility.set_location('Entry Path: ' || curr_epath, 400);

1376: else
1377: last_element := 1;
1378: end if;
1379: --
1380: hr_utility.set_location('Entry Path: ' || curr_epath, 400);
1381: --
1382: end if;
1383: end loop;
1384: l_entry_path := curr_epath;

Line 1640: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',10);

1636: l_rr_id number;
1637: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
1638: --
1639: begin
1640: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',10);
1641: select pay_payroll_actions_s.nextval,
1642: ppa.business_group_id,
1643: ppa.consolidation_set_id,
1644: ppa.payroll_id,

Line 1744: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',20);

1740: end if;
1741:
1742:
1743: --
1744: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',20);
1745: l_ee_id := -1;
1746: l_run_type := -1;
1747: l_tax_unit_id := -1;
1748: l_asg_act_id := -1;

Line 1837: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',30);

1833: );
1834: --
1835: end loop;
1836: --
1837: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',30);
1838: /* Bug 8614449 */
1839: if (l_asg_act_id <> -1) then
1840: pay_balance_pkg.maintain_balances_for_action(l_asg_act_id);
1841:

Line 1975: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',40);

1971: --
1972: if (l_asg_act_id <> -1) then
1973: pay_balance_pkg.maintain_balances_for_action(l_asg_act_id);
1974: end if;
1975: hr_utility.set_location('pay_retro_pkg.overlap_adjustments ',40);
1976: --
1977: end overlap_adjustments;
1978: --
1979: -- Note in process_recorded_date, we're using the serial_number column to

Line 1993: hr_utility.set_location('process_recorded_date', 10);

1989: v_recorded_date date;
1990: l_date date;
1991: l_min_retro_asg_date date;
1992: begin
1993: hr_utility.set_location('process_recorded_date', 10);
1994:
1995: -- p_adj_start_date is the earliest overlap_start_date for the assignment in this retropay run
1996: hr_utility.trace('p_adj_start_date : '|| p_adj_start_date);
1997:

Line 1996: hr_utility.trace('p_adj_start_date : '|| p_adj_start_date);

1992: begin
1993: hr_utility.set_location('process_recorded_date', 10);
1994:
1995: -- p_adj_start_date is the earliest overlap_start_date for the assignment in this retropay run
1996: hr_utility.trace('p_adj_start_date : '|| p_adj_start_date);
1997:
1998: -- Get the recorded_date for 'RETRO_OVERLAP' attribute for the assignment
1999: pay_recorded_requests_pkg.get_recorded_date_no_ins( p_process,
2000: l_rec_date,

Line 2003: hr_utility.trace('l_rec_date : '|| l_rec_date);

1999: pay_recorded_requests_pkg.get_recorded_date_no_ins( p_process,
2000: l_rec_date,
2001: p_assignment_id);
2002: --
2003: hr_utility.trace('l_rec_date : '|| l_rec_date);
2004: --
2005: /*
2006: If retropay is being run for the first time since enabling RETRO_OVERLAP functionality or
2007: if the earliest overlapping_start_date is less than the recorded_date, then do full recalculations

Line 2016: hr_utility.set_location('process_recorded_date', 20);

2012: */
2013: if (l_rec_date = hr_api.g_sot OR
2014: p_adj_start_date < l_rec_date) THEN
2015: --
2016: hr_utility.set_location('process_recorded_date', 20);
2017:
2018: v_recorded_date := p_adj_start_date;
2019: --
2020: pay_recorded_requests_pkg.set_recorded_date(

Line 2038: hr_utility.set_location('process_recorded_date', 30);

2034: where assignment_action_id = p_assact_id;
2035: --
2036: else
2037: --
2038: hr_utility.set_location('process_recorded_date', 30);
2039:
2040: -- Get the reprocess_date of the assignment for this retropay run.
2041:
2042: begin

Line 2053: hr_utility.trace('l_min_retro_asg_date : '|| l_min_retro_asg_date);

2049: when others
2050: then null;
2051: end;
2052:
2053: hr_utility.trace('l_min_retro_asg_date : '|| l_min_retro_asg_date);
2054:
2055: v_recorded_date := l_min_retro_asg_date;
2056: --
2057: end if;

Line 2067: hr_utility.set_location('process_recorded_date', 40);

2063: update pay_assignment_actions
2064: set serial_number = serial_number || 'rcl=' || substr(fnd_date.date_to_canonical(v_recorded_date),1,11)
2065: where assignment_action_id = p_assact_id;
2066: --
2067: hr_utility.set_location('process_recorded_date', 40);
2068: --
2069: return v_recorded_date;
2070: --
2071: end process_recorded_date;

Line 2081: hr_utility.set_location('reset_recorded_request', 10);

2077: l_assign_id number;
2078:
2079: begin
2080: --
2081: hr_utility.set_location('reset_recorded_request', 10);
2082: --
2083: hr_utility.trace('p_assact_id : '|| p_assact_id);
2084:
2085: -- bug 8407213. Fetch the previous recorded_date from label_identifier column of pay_assignment_actions during rollback.

Line 2083: hr_utility.trace('p_assact_id : '|| p_assact_id);

2079: begin
2080: --
2081: hr_utility.set_location('reset_recorded_request', 10);
2082: --
2083: hr_utility.trace('p_assact_id : '|| p_assact_id);
2084:
2085: -- bug 8407213. Fetch the previous recorded_date from label_identifier column of pay_assignment_actions during rollback.
2086:
2087: select to_date(substr(label_identifier, 1,11), 'YYYY/MM/DD'), assignment_id

Line 2093: hr_utility.set_location('reset_recorded_request', 20);

2089: from pay_assignment_actions
2090: where assignment_action_id = p_assact_id;
2091:
2092: --
2093: hr_utility.set_location('reset_recorded_request', 20);
2094: --
2095:
2096: hr_utility.trace('l_assign_id : '|| l_assign_id);
2097: hr_utility.trace('l_prev_rec_date : '|| l_prev_rec_date);

Line 2096: hr_utility.trace('l_assign_id : '|| l_assign_id);

2092: --
2093: hr_utility.set_location('reset_recorded_request', 20);
2094: --
2095:
2096: hr_utility.trace('l_assign_id : '|| l_assign_id);
2097: hr_utility.trace('l_prev_rec_date : '|| l_prev_rec_date);
2098:
2099: /* Added to_char for l_assign_id in the following
2100: two queries for fixing Bug:6893208 */

Line 2097: hr_utility.trace('l_prev_rec_date : '|| l_prev_rec_date);

2093: hr_utility.set_location('reset_recorded_request', 20);
2094: --
2095:
2096: hr_utility.trace('l_assign_id : '|| l_assign_id);
2097: hr_utility.trace('l_prev_rec_date : '|| l_prev_rec_date);
2098:
2099: /* Added to_char for l_assign_id in the following
2100: two queries for fixing Bug:6893208 */
2101: /* Bug 8790029

Line 2131: hr_utility.set_location('reset_recorded_request', 30);

2127: where ATTRIBUTE_CATEGORY = 'RETRO_OVERLAP'
2128: and ATTRIBUTE1 = to_char(l_assign_id);
2129: --
2130: end if;
2131: hr_utility.set_location('reset_recorded_request', 30);
2132: --
2133: end reset_recorded_request;
2134: --
2135: end pay_retro_pkg;