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 199: hr_utility.trace('Get reprocess type bgid :' || to_char(pay_proc_environment_pkg.bgid));

195: when no_data_found then
196: --
197: begin
198: --
199: hr_utility.trace('Get reprocess type bgid :' || to_char(pay_proc_environment_pkg.bgid));
200: hr_utility.trace('Get reprocess type legc:' || pay_proc_environment_pkg.legc);
201:
202: select prcu.reprocess_type
203: into l_reprocess_type

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

196: --
197: begin
198: --
199: hr_utility.trace('Get reprocess type bgid :' || to_char(pay_proc_environment_pkg.bgid));
200: hr_utility.trace('Get reprocess type legc:' || pay_proc_environment_pkg.legc);
201:
202: select prcu.reprocess_type
203: into l_reprocess_type
204: from pay_retro_component_usages prcu

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

431: --
432: exception
433: when others then
434:
435: hr_utility.trace('Clash : '||p_entry_id||' '||p_aa_id);
436: for rr in c_rr loop
437: hr_utility.trace(rr.element_type_id||' '||rr.element_entry_id);
438: end loop;
439:

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

433: when others then
434:
435: hr_utility.trace('Clash : '||p_entry_id||' '||p_aa_id);
436: for rr in c_rr loop
437: hr_utility.trace(rr.element_type_id||' '||rr.element_entry_id);
438: end loop;
439:
440: raise;
441: end;

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

844: p_element_entry_id,
845: p_ef_date,
846: null); -- Direct calls should also pass element_type_id
847: --
848: -- hr_utility.trace(' Returned component_id is '||l_retro_comp_id);
849: return l_retro_comp_id;
850: END get_retro_component_id;
851: --
852: /*

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

1261: n := instr(p_entry_process_path, '[');
1262: epath_length := length(p_entry_process_path);
1263: --
1264: if (n <> 0) then
1265: hr_utility.set_location('Entry Proc Path in correct format', 10);
1266: l_entry_path := p_entry_process_path;
1267: else
1268: hr_utility.set_location('Convert Entry Proc Path: ' || p_entry_process_path, 20);
1269: --

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

1264: if (n <> 0) then
1265: hr_utility.set_location('Entry Proc Path in correct format', 10);
1266: l_entry_path := p_entry_process_path;
1267: else
1268: hr_utility.set_location('Convert Entry Proc Path: ' || p_entry_process_path, 20);
1269: --
1270: /* find first element type */
1271: curr_pos := instr(p_entry_process_path, '.', 1,counter);
1272: curr_et := substr(p_entry_process_path, 1, curr_pos-1);

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

1278: if (curr_pos = 0) then
1279: l_entry_path := p_entry_process_path;
1280: else
1281: while(last_element = 0) loop
1282: hr_utility.set_location('Entry Path: ' || curr_epath || 'Counter: ' || to_char(counter), 30);
1283: --
1284: if (next_pos = 0) then
1285: next_et := substr(p_entry_process_path, curr_pos+1, epath_length-curr_pos);
1286: else

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

1287: next_et := substr(p_entry_process_path, curr_pos+1, next_pos-1-curr_pos);
1288: end if;
1289: --
1290: if (curr_et = next_et) then
1291: hr_utility.set_location('If Same Element Type', 40);
1292: while ((curr_et = next_et) and (last_element = 0)) loop
1293: hr_utility.set_location('While Same Element Type: ' || curr_et || ' ' || next_et, 50);
1294: hr_utility.set_location('Curr Pos and Next Pos: ' || to_char(curr_pos) || ' ' || to_char(next_pos), 55);
1295: recursive_level := recursive_level+1;

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

1289: --
1290: if (curr_et = next_et) then
1291: hr_utility.set_location('If Same Element Type', 40);
1292: while ((curr_et = next_et) and (last_element = 0)) loop
1293: hr_utility.set_location('While Same Element Type: ' || curr_et || ' ' || next_et, 50);
1294: hr_utility.set_location('Curr Pos and Next Pos: ' || to_char(curr_pos) || ' ' || to_char(next_pos), 55);
1295: recursive_level := recursive_level+1;
1296: --
1297: hr_utility.set_location('Recursive Level: ' || to_char(recursive_level), 56);

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

1290: if (curr_et = next_et) then
1291: hr_utility.set_location('If Same Element Type', 40);
1292: while ((curr_et = next_et) and (last_element = 0)) loop
1293: hr_utility.set_location('While Same Element Type: ' || curr_et || ' ' || next_et, 50);
1294: hr_utility.set_location('Curr Pos and Next Pos: ' || to_char(curr_pos) || ' ' || to_char(next_pos), 55);
1295: recursive_level := recursive_level+1;
1296: --
1297: hr_utility.set_location('Recursive Level: ' || to_char(recursive_level), 56);
1298: if (next_pos = 0) then

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

1293: hr_utility.set_location('While Same Element Type: ' || curr_et || ' ' || next_et, 50);
1294: hr_utility.set_location('Curr Pos and Next Pos: ' || to_char(curr_pos) || ' ' || to_char(next_pos), 55);
1295: recursive_level := recursive_level+1;
1296: --
1297: hr_utility.set_location('Recursive Level: ' || to_char(recursive_level), 56);
1298: if (next_pos = 0) then
1299: last_element := 1;
1300: next_et := substr(p_entry_process_path, curr_pos+1, epath_length-curr_pos);
1301: hr_utility.set_location('Next ET: ' || next_et || 'Curr Pos: ' || curr_pos, 81);

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

1297: hr_utility.set_location('Recursive Level: ' || to_char(recursive_level), 56);
1298: if (next_pos = 0) then
1299: last_element := 1;
1300: next_et := substr(p_entry_process_path, curr_pos+1, epath_length-curr_pos);
1301: hr_utility.set_location('Next ET: ' || next_et || 'Curr Pos: ' || curr_pos, 81);
1302: else
1303: curr_pos := next_pos;
1304: counter := counter +1;
1305: next_pos := instr(p_entry_process_path, '.', 1, counter);

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

1307: next_et := substr(p_entry_process_path, curr_pos+1, epath_length-curr_pos);
1308: else
1309: next_et := substr(p_entry_process_path, curr_pos+1, next_pos-1-curr_pos);
1310: end if;
1311: hr_utility.set_location('Next ET: ' || next_et, 82);
1312: end if;
1313: end loop;
1314: --
1315: hr_utility.set_location('Entry Path: ' || curr_epath, 100);

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

1311: hr_utility.set_location('Next ET: ' || next_et, 82);
1312: end if;
1313: end loop;
1314: --
1315: hr_utility.set_location('Entry Path: ' || curr_epath, 100);
1316: --
1317: if (curr_epath is null) then
1318: curr_epath := curr_et || '[' || to_char(recursive_level) || ']';
1319: else

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

1322:
1323: if ((last_element = 1) and (curr_et <> next_et)) then
1324: curr_epath := curr_epath || '.' || next_et;
1325: end if;
1326: hr_utility.set_location('Entry Path: ' || curr_epath, 200);
1327: --
1328: else
1329: hr_utility.set_location('If Not Same Element Type: ' || curr_et || ' ' || next_et, 60);
1330: recursive_level := 1;

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

1325: end if;
1326: hr_utility.set_location('Entry Path: ' || curr_epath, 200);
1327: --
1328: else
1329: hr_utility.set_location('If Not Same Element Type: ' || curr_et || ' ' || next_et, 60);
1330: recursive_level := 1;
1331: --
1332: hr_utility.set_location('Entry Path: ' || curr_epath, 300);
1333: --

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

1328: else
1329: hr_utility.set_location('If Not Same Element Type: ' || curr_et || ' ' || next_et, 60);
1330: recursive_level := 1;
1331: --
1332: hr_utility.set_location('Entry Path: ' || curr_epath, 300);
1333: --
1334: if (curr_epath is null) then
1335: curr_epath := curr_et || '.' || next_et;
1336: else

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

1345: else
1346: last_element := 1;
1347: end if;
1348: --
1349: hr_utility.set_location('Entry Path: ' || curr_epath, 400);
1350: --
1351: end if;
1352: end loop;
1353: l_entry_path := curr_epath;

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

1849: v_recorded_date date;
1850: l_date date;
1851: l_min_retro_asg_date date;
1852: begin
1853: hr_utility.set_location('process_recorded_date', 10);
1854:
1855: -- p_adj_start_date is the earliest overlap_start_date for the assignment in this retropay run
1856: hr_utility.trace('p_adj_start_date : '|| p_adj_start_date);
1857:

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

1852: begin
1853: hr_utility.set_location('process_recorded_date', 10);
1854:
1855: -- p_adj_start_date is the earliest overlap_start_date for the assignment in this retropay run
1856: hr_utility.trace('p_adj_start_date : '|| p_adj_start_date);
1857:
1858: -- Get the recorded_date for 'RETRO_OVERLAP' attribute for the assignment
1859: pay_recorded_requests_pkg.get_recorded_date_no_ins( p_process,
1860: l_rec_date,

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

1859: pay_recorded_requests_pkg.get_recorded_date_no_ins( p_process,
1860: l_rec_date,
1861: p_assignment_id);
1862: --
1863: hr_utility.trace('l_rec_date : '|| l_rec_date);
1864: --
1865: /*
1866: If retropay is being run for the first time since enabling RETRO_OVERLAP functionality or
1867: if the earliest overlapping_start_date is less than the recorded_date, then do full recalculations

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

1872: */
1873: if (l_rec_date = hr_api.g_sot OR
1874: p_adj_start_date < l_rec_date) THEN
1875: --
1876: hr_utility.set_location('process_recorded_date', 20);
1877:
1878: v_recorded_date := p_adj_start_date;
1879: --
1880: pay_recorded_requests_pkg.set_recorded_date(

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

1884: p_attribute1 => p_assignment_id);
1885: --
1886: else
1887: --
1888: hr_utility.set_location('process_recorded_date', 30);
1889:
1890: -- Get the reprocess_date of the assignment for this retropay run.
1891:
1892: begin

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

1899: when others
1900: then null;
1901: end;
1902:
1903: hr_utility.trace('l_min_retro_asg_date : '|| l_min_retro_asg_date);
1904:
1905: v_recorded_date := l_min_retro_asg_date;
1906: --
1907: end if;

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

1909: update pay_assignment_actions
1910: set serial_number = substr(fnd_date.date_to_canonical(v_recorded_date),1,11)
1911: where assignment_action_id = p_assact_id;
1912: --
1913: hr_utility.set_location('process_recorded_date', 40);
1914: --
1915: return v_recorded_date;
1916: --
1917: end process_recorded_date;

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

1921: l_prev_rec_date date;
1922: l_assign_id number;
1923: begin
1924: --
1925: hr_utility.set_location('reset_recorded_request', 10);
1926: --
1927: select to_date(substr(serial_number, 1,11), 'YYYY/MM/DD'), assignment_id
1928: into l_prev_rec_date, l_assign_id
1929: from pay_assignment_actions

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

1928: into l_prev_rec_date, l_assign_id
1929: from pay_assignment_actions
1930: where assignment_action_id = p_assact_id;
1931: --
1932: hr_utility.set_location('reset_recorded_request', 20);
1933: --
1934:
1935: /* Added to_char for l_assign_id in the following
1936: two queries for fixing Bug:6893208 */

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

1945: where ATTRIBUTE_CATEGORY = 'RETRO_OVERLAP'
1946: and ATTRIBUTE1 = to_char(l_assign_id);
1947: --
1948: end if;
1949: hr_utility.set_location('reset_recorded_request', 30);
1950: --
1951: end reset_recorded_request;
1952: --
1953: end pay_retro_pkg;