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

Line 326: hr_utility.set_location('pytrgl.trans_pay_costs',10);

322: l_group_id VARCHAR2(80);
323: --
324: BEGIN
325: --
326: hr_utility.set_location('pytrgl.trans_pay_costs',10);
327: --
328: sql_curs :=dbms_sql.open_cursor;
329: --
330: OPEN transfer_payrolls (i_payroll_action_id);

Line 332: hr_utility.set_location('pytrgl.trans_pay_costs',20);

328: sql_curs :=dbms_sql.open_cursor;
329: --
330: OPEN transfer_payrolls (i_payroll_action_id);
331: --
332: hr_utility.set_location('pytrgl.trans_pay_costs',20);
333: --
334: -- Bug 1066820 avoid passing in hard coded strings.
335: --
336: select user_je_source_name

Line 341: hr_utility.set_location('pytrgl.trans_pay_costs',25);

337: into l_source_name
338: from gl_je_sources_vl
339: where je_source_name = 'Payroll';
340: --
341: hr_utility.set_location('pytrgl.trans_pay_costs',25);
342: --
343: select user_je_category_name
344: into l_category_name
345: from gl_je_categories_vl

Line 348: hr_utility.set_location('pytrgl.trans_pay_costs',27);

344: into l_category_name
345: from gl_je_categories_vl
346: where je_category_name = 'Payroll';
347: --
348: hr_utility.set_location('pytrgl.trans_pay_costs',27);
349: --
350: -- Find if use an accouting date of date_earned
351: -- (default is effective_date)
352: --

Line 363: hr_utility.set_location('pytrgl.trans_pay_costs',28);

359: when others then
360: l_date_used := 'P';
361: end;
362: --
363: hr_utility.set_location('pytrgl.trans_pay_costs',28);
364: --
365: -- Find if use an accouting date of date_earned
366: -- (default is effective_date)
367: --

Line 378: hr_utility.set_location('pytrgl.trans_pay_costs',29);

374: when others then
375: l_rvb_acc_date := 'P';
376: end;
377: --
378: hr_utility.set_location('pytrgl.trans_pay_costs',29);
379: --
380: -- Find if should populate gl_interface.group_id
381: -- (default is to leave this column blank)
382: -- If so we populate it with the TGL payroll_action_id

Line 394: hr_utility.set_location('pytrgl.trans_pay_costs',30);

390: when others then
391: l_group_id := 'N';
392: end;
393: --
394: hr_utility.set_location('pytrgl.trans_pay_costs',30);
395: --
396: -- Process each run action in turn. Each run action may be for
397: -- several payrolls. Each payroll will be processed separately.
398: LOOP

Line 406: hr_utility.set_location('pytrgl.trans_pay_costs',31);

402: c_cost_action_id, -- cost action
403: c_payroll_id,
404: c_set_of_books_id;
405: --
406: hr_utility.set_location('pytrgl.trans_pay_costs',31);
407: --
408: EXIT WHEN transfer_payrolls%NOTFOUND;
409: --
410: hr_utility.set_location('pytrgl.trans_pay_costs',32);

Line 410: hr_utility.set_location('pytrgl.trans_pay_costs',32);

406: hr_utility.set_location('pytrgl.trans_pay_costs',31);
407: --
408: EXIT WHEN transfer_payrolls%NOTFOUND;
409: --
410: hr_utility.set_location('pytrgl.trans_pay_costs',32);
411: --
412: select decode(ppa1.action_type, 'S', ppa1.effective_date,
413: decode(ppa2.action_type, 'B', decode(l_rvb_acc_date, 'C', ppa1.effective_date,
414: ppa2.effective_date),

Line 431: hr_utility.set_location('pytrgl.trans_pay_costs',35);

427: pay_payroll_actions ppa2 -- Payroll run action
428: where ppa1.payroll_action_id = c_cost_action_id
429: and ppa2.payroll_action_id = c_run_action_id;
430: --
431: hr_utility.set_location('pytrgl.trans_pay_costs',35);
432: --
433: -- Get payrolls currency conversion rate type
434: -- handle fact that it may be null
435: --

Line 444: hr_utility.set_location('pytrgl.trans_pay_costs',37);

440: c_conversion_date := c_accounting_date;
441:
442: exception
443: when no_data_found then
444: hr_utility.set_location('pytrgl.trans_pay_costs',37);
445: l_currency_type := null;
446: c_conversion_date := null;
447: end;
448: --

Line 459: hr_utility.set_location('pytrgl.trans_pay_costs',40);

455: --
456: pay_segment_list := NULL;
457: gl_segment_list := NULL;
458: --
459: hr_utility.set_location('pytrgl.trans_pay_costs',40);
460: --
461: -- Dynamically build up the segment lists for the payroll.
462: FOR flex_segs IN flex_segments ( c_payroll_id, c_set_of_books_id )
463: LOOP

Line 465: hr_utility.set_location('pytrgl.trans_pay_costs',50);

461: -- Dynamically build up the segment lists for the payroll.
462: FOR flex_segs IN flex_segments ( c_payroll_id, c_set_of_books_id )
463: LOOP
464: --
465: hr_utility.set_location('pytrgl.trans_pay_costs',50);
466: --
467: gl_segment_list := gl_segment_list ||
468: flex_segs.gl_account_segment ||',';
469: --

Line 470: hr_utility.set_location('pytrgl.trans_pay_costs',60);

466: --
467: gl_segment_list := gl_segment_list ||
468: flex_segs.gl_account_segment ||',';
469: --
470: hr_utility.set_location('pytrgl.trans_pay_costs',60);
471: --
472: -- Payroll segment list needs to MIN() function as not grouped
473: -- by each segment.
474: --

Line 485: hr_utility.set_location('pytrgl.trans_pay_costs',70);

481: --
482: prev_payroll_id := c_payroll_id;
483: prev_sob_id := c_set_of_books_id;
484: --
485: hr_utility.set_location('pytrgl.trans_pay_costs',70);
486: --
487: -- Put the statement into the cursor and parse. Don't know how long
488: -- the segment list is so we cannot bind to variables.
489: --

Line 903: hr_utility.set_location('pytrgl.trans_pay_costs',80);

899: decode (IV.uom, ''M'', et.output_currency_code, ''STAT'')',
900: dbms_sql.v7);
901: end if;
902: --
903: hr_utility.set_location('pytrgl.trans_pay_costs',80);
904: --
905: -- Bind the variable values to the cursor values.
906: --
907: dbms_sql.bind_variable(sql_curs,'c_run_action_id',

Line 936: hr_utility.set_location('pytrgl.trans_pay_costs',90);

932: -- Execute the insert statment.
933: --
934: rows_processed := dbms_sql.execute(sql_curs);
935: --
936: hr_utility.set_location('pytrgl.trans_pay_costs',90);
937: --
938: -- Update the assignment actions. Mark as processed.
939: --
940: UPDATE pay_assignment_actions pa

Line 965: hr_utility.set_location('pytrgl.trans_pay_costs', 100);

961: AND ppa2.effective_date
962: BETWEEN per.effective_start_date
963: AND per.effective_end_date);
964: --
965: hr_utility.set_location('pytrgl.trans_pay_costs', 100);
966: --
967: COMMIT;
968: --
969: END LOOP;

Line 971: hr_utility.set_location('pytrgl.trans_pay_costs',110);

967: COMMIT;
968: --
969: END LOOP;
970: --
971: hr_utility.set_location('pytrgl.trans_pay_costs',110);
972: --
973: CLOSE transfer_payrolls;
974: --
975: dbms_sql.close_cursor(sql_curs);

Line 977: hr_utility.set_location('pytrgl.trans_pay_costs',120);

973: CLOSE transfer_payrolls;
974: --
975: dbms_sql.close_cursor(sql_curs);
976: --
977: hr_utility.set_location('pytrgl.trans_pay_costs',120);
978: --
979: END trans_pay_costs;
980:
981: --

Line 1114: hr_utility.set_location('pytrgl.trans_pay_costs_mt',10);

1110: l_asg_join VARCHAR2(500);
1111: --
1112: BEGIN
1113: --
1114: hr_utility.set_location('pytrgl.trans_pay_costs_mt',10);
1115: --
1116: sql_curs := dbms_sql.open_cursor;
1117: --
1118: OPEN transfer_payrolls (i_payroll_action_id);

Line 1120: hr_utility.set_location('pytrgl.trans_pay_costs_mt',20);

1116: sql_curs := dbms_sql.open_cursor;
1117: --
1118: OPEN transfer_payrolls (i_payroll_action_id);
1119: --
1120: hr_utility.set_location('pytrgl.trans_pay_costs_mt',20);
1121: --
1122: -- Bug 1066820 avoid passing in hard coded strings.
1123: --
1124: select user_je_source_name

Line 1129: hr_utility.set_location('pytrgl.trans_pay_costs_mt',25);

1125: into l_source_name
1126: from gl_je_sources_vl
1127: where je_source_name = 'Payroll';
1128: --
1129: hr_utility.set_location('pytrgl.trans_pay_costs_mt',25);
1130: --
1131: select user_je_category_name
1132: into l_category_name
1133: from gl_je_categories_vl

Line 1136: hr_utility.set_location('pytrgl.trans_pay_costs_mt',27);

1132: into l_category_name
1133: from gl_je_categories_vl
1134: where je_category_name = 'Payroll';
1135: --
1136: hr_utility.set_location('pytrgl.trans_pay_costs_mt',27);
1137: --
1138: select bus.currency_code, bus.business_group_id
1139: into l_bus_currency_code, l_bus_grp_id
1140: from per_business_groups_perf bus,

Line 1145: hr_utility.set_location('pytrgl.trans_pay_costs',28);

1141: pay_payroll_actions ppa
1142: where ppa.payroll_action_id = i_payroll_action_id
1143: and bus.business_group_id = ppa.business_group_id;
1144: --
1145: hr_utility.set_location('pytrgl.trans_pay_costs',28);
1146: --
1147: -- Find if use an accouting date of date_earned
1148: -- (default is effective_date)
1149: --

Line 1173: hr_utility.set_location('pytrgl.trans_pay_costs',29);

1169: when others then
1170: l_rvb_acc_date := 'P';
1171: end;
1172: --
1173: hr_utility.set_location('pytrgl.trans_pay_costs',29);
1174: --
1175: -- Find if should populate gl_interface.group_id
1176: -- (default is to leave this column blank)
1177: -- If so we populate it with the TGL payroll_action_id

Line 1201: hr_utility.set_location('pytrgl.trans_pay_costs_mt',30);

1197: c_payroll_id,
1198: c_set_of_books_id,
1199: c_pay_id;
1200: --
1201: hr_utility.set_location('pytrgl.trans_pay_costs_mt',30);
1202: --
1203: EXIT WHEN transfer_payrolls%NOTFOUND;
1204: --
1205: hr_utility.set_location('pytrgl.trans_pay_costs_mt',32);

Line 1205: hr_utility.set_location('pytrgl.trans_pay_costs_mt',32);

1201: hr_utility.set_location('pytrgl.trans_pay_costs_mt',30);
1202: --
1203: EXIT WHEN transfer_payrolls%NOTFOUND;
1204: --
1205: hr_utility.set_location('pytrgl.trans_pay_costs_mt',32);
1206: --
1207: if (c_action_type in ('C', 'S')) then
1208:
1209: select decode(ppa1.action_type, 'S', ppa1.effective_date,

Line 1242: hr_utility.set_location('pytrgl.trans_pay_costs_mt',33);

1238: -- required payroll. Use string concatenation method to avoid performance hit
1239: -- ie only join to per_all_assignments_f if have to.
1240: if ((c_action_type = 'EC' or c_action_type = 'CP') and
1241: c_pay_id is null) then
1242: hr_utility.set_location('pytrgl.trans_pay_costs_mt',33);
1243: l_asg_tab := 'per_all_assignments_f paf,';
1244: l_asg_join :=
1245: 'AND paf.assignment_id = '||'p'||'a.assignment_id
1246: AND :c_run_date between paf.effective_start_date

Line 1250: hr_utility.set_location('pytrgl.trans_pay_costs_mt',34);

1246: AND :c_run_date between paf.effective_start_date
1247: and paf.effective_end_date
1248: AND paf.payroll_id = :c_payroll_id';
1249: else
1250: hr_utility.set_location('pytrgl.trans_pay_costs_mt',34);
1251: l_asg_tab := '';
1252: l_asg_join := '';
1253: end if;
1254:

Line 1256: hr_utility.set_location('pytrgl.trans_pay_costs_mt',35);

1252: l_asg_join := '';
1253: end if;
1254:
1255: --
1256: hr_utility.set_location('pytrgl.trans_pay_costs_mt',35);
1257: --
1258: -- Get payrolls currency conversion rate type
1259: -- handle fact that it may be null
1260: --

Line 1269: hr_utility.set_location('pytrgl.trans_pay_costs',37);

1265: c_conversion_date := c_accounting_date;
1266:
1267: exception
1268: when no_data_found then
1269: hr_utility.set_location('pytrgl.trans_pay_costs',37);
1270: l_currency_type := null;
1271: c_conversion_date := null;
1272: end;
1273: --

Line 1284: hr_utility.set_location('pytrgl.trans_pay_costs_mt',40);

1280: --
1281: pay_segment_list := NULL;
1282: gl_segment_list := NULL;
1283: --
1284: hr_utility.set_location('pytrgl.trans_pay_costs_mt',40);
1285: --
1286: -- Dynamically build up the segment lists for the payroll.
1287: FOR flex_segs IN flex_segments ( c_payroll_id, c_set_of_books_id )
1288: LOOP

Line 1290: hr_utility.set_location('pytrgl.trans_pay_costs_mt',50);

1286: -- Dynamically build up the segment lists for the payroll.
1287: FOR flex_segs IN flex_segments ( c_payroll_id, c_set_of_books_id )
1288: LOOP
1289: --
1290: hr_utility.set_location('pytrgl.trans_pay_costs_mt',50);
1291: --
1292: gl_segment_list := gl_segment_list ||
1293: flex_segs.gl_account_segment ||',';
1294: --

Line 1295: hr_utility.set_location('pytrgl.trans_pay_costs_mt',60);

1291: --
1292: gl_segment_list := gl_segment_list ||
1293: flex_segs.gl_account_segment ||',';
1294: --
1295: hr_utility.set_location('pytrgl.trans_pay_costs_mt',60);
1296: --
1297: -- Payroll segment list needs to MIN() function as not grouped
1298: -- by each segment.
1299: --

Line 1310: hr_utility.set_location('pytrgl.trans_pay_costs_mt',65);

1306: --
1307: prev_payroll_id := c_payroll_id;
1308: prev_sob_id := c_set_of_books_id;
1309: --
1310: hr_utility.set_location('pytrgl.trans_pay_costs_mt',65);
1311: --
1312: -- For Payment Costs should not populate segment columns
1313: -- in gl_interface : bug 6169000
1314: --

Line 1323: hr_utility.set_location('pytrgl.trans_pay_costs_mt',70);

1319: l_pay_segment_list := pay_segment_list;
1320: l_gl_segment_list := gl_segment_list;
1321: end if;
1322: --
1323: hr_utility.set_location('pytrgl.trans_pay_costs_mt',70);
1324: --
1325: -- Put the statement into the cursor and parse. Don't know how long
1326: -- the segment list is so we cannot bind to variables.
1327: --

Line 1471: hr_utility.set_location('pytrgl.trans_pay_costs_mt',80);

1467: pgl.currency_code',
1468: dbms_sql.v7);
1469: end if;
1470: --
1471: hr_utility.set_location('pytrgl.trans_pay_costs_mt',80);
1472: --
1473: -- Bind the variable values to the cursor values.
1474: --
1475: dbms_sql.bind_variable(sql_curs,'c_run_action_id',

Line 1515: hr_utility.set_location('pytrgl.trans_pay_costs_mt',90);

1511: -- Execute the insert statment.
1512: --
1513: rows_processed := dbms_sql.execute(sql_curs);
1514: --
1515: hr_utility.set_location('pytrgl.trans_pay_costs_mt',90);
1516: --
1517: END LOOP;
1518: --
1519: hr_utility.set_location('pytrgl.trans_pay_costs_mt',100);

Line 1519: hr_utility.set_location('pytrgl.trans_pay_costs_mt',100);

1515: hr_utility.set_location('pytrgl.trans_pay_costs_mt',90);
1516: --
1517: END LOOP;
1518: --
1519: hr_utility.set_location('pytrgl.trans_pay_costs_mt',100);
1520: --
1521: CLOSE transfer_payrolls;
1522: --
1523: dbms_sql.close_cursor(sql_curs);

Line 1525: hr_utility.set_location('pytrgl.trans_pay_costs_mt',110);

1521: CLOSE transfer_payrolls;
1522: --
1523: dbms_sql.close_cursor(sql_curs);
1524: --
1525: hr_utility.set_location('pytrgl.trans_pay_costs_mt',110);
1526: --
1527: COMMIT;
1528: --
1529: hr_utility.set_location('pytrgl.trans_pay_costs_mt',120);

Line 1529: hr_utility.set_location('pytrgl.trans_pay_costs_mt',120);

1525: hr_utility.set_location('pytrgl.trans_pay_costs_mt',110);
1526: --
1527: COMMIT;
1528: --
1529: hr_utility.set_location('pytrgl.trans_pay_costs_mt',120);
1530: --
1531: END trans_pay_costs_mt;
1532: --
1533: PROCEDURE trans_ass_costs

Line 1550: hr_utility.set_location('pytrgl.trans_ass_costs',10);

1546: l_date_used VARCHAR2(80);
1547: l_accounting_date DATE;
1548: BEGIN
1549: --
1550: hr_utility.set_location('pytrgl.trans_ass_costs',10);
1551: --
1552: if (sla_mode = 1) then
1553: --
1554: hr_utility.set_location('pytrgl.trans_ass_costs',14);

Line 1554: hr_utility.set_location('pytrgl.trans_ass_costs',14);

1550: hr_utility.set_location('pytrgl.trans_ass_costs',10);
1551: --
1552: if (sla_mode = 1) then
1553: --
1554: hr_utility.set_location('pytrgl.trans_ass_costs',14);
1555: --
1556: pay_sla_pkg.trans_asg_costs(i_assignment_action_id);
1557: --
1558: hr_utility.set_location('pytrgl.trans_ass_costs',16);

Line 1558: hr_utility.set_location('pytrgl.trans_ass_costs',16);

1554: hr_utility.set_location('pytrgl.trans_ass_costs',14);
1555: --
1556: pay_sla_pkg.trans_asg_costs(i_assignment_action_id);
1557: --
1558: hr_utility.set_location('pytrgl.trans_ass_costs',16);
1559: --
1560: else
1561: --
1562: hr_utility.set_location('pytrgl.trans_ass_costs',18);

Line 1562: hr_utility.set_location('pytrgl.trans_ass_costs',18);

1558: hr_utility.set_location('pytrgl.trans_ass_costs',16);
1559: --
1560: else
1561: --
1562: hr_utility.set_location('pytrgl.trans_ass_costs',18);
1563: --
1564: SELECT pa.payroll_action_id,
1565: pa1.assignment_id,
1566: pa1.assignment_action_id,

Line 1589: hr_utility.set_location('pytrgl.trans_ass_costs',20);

1585: --
1586: -- Costing or Retrocostong hence know run result populated
1587: -- in pay_costs.
1588: --
1589: hr_utility.set_location('pytrgl.trans_ass_costs',20);
1590: --
1591: SELECT pa2.assignment_action_id,
1592: ppa2.payroll_action_id,
1593: ppa2.action_type,

Line 1609: hr_utility.set_location('pytrgl.trans_ass_costs',30);

1605: AND pa2.assignment_action_id = pi2.locked_action_id
1606: AND ppa2.payroll_action_id = pa2.payroll_action_id
1607: AND ppa2.action_type NOT IN ('C', 'S', 'EC');
1608: --
1609: hr_utility.set_location('pytrgl.trans_ass_costs',30);
1610: --
1611: INSERT INTO pay_gl_interface
1612: ( assignment_action_id,
1613: run_payroll_action_id,

Line 1769: hr_utility.set_location('pytrgl.trans_ass_costs',40);

1765: GROUP BY cst.cost_allocation_keyflex_id,
1766: cst.debit_or_credit,
1767: decode (IV.uom, 'M', et.output_currency_code, 'STAT');
1768: --
1769: hr_utility.set_location('pytrgl.trans_ass_costs',40);
1770: --
1771: elsif (c_action_type = 'EC') then
1772: --
1773: -- Estimate Costing hence run result not populated

Line 1776: hr_utility.set_location('pytrgl.trans_ass_costs',50);

1772: --
1773: -- Estimate Costing hence run result not populated
1774: -- in pay_costs.
1775: --
1776: hr_utility.set_location('pytrgl.trans_ass_costs',50);
1777: --
1778: --
1779: -- Find if use an accouting date of date_earned
1780: -- (default is effective_date)

Line 1795: hr_utility.set_location('pytrgl.trans_pay_costs',29);

1791: end;
1792: end if;
1793: l_date_used := g_date_used;
1794: --
1795: hr_utility.set_location('pytrgl.trans_pay_costs',29);
1796: --
1797: -- get accounting_date according to TGL_DATE_USED
1798: -- for use with the reversal costs
1799: --

Line 1820: hr_utility.set_location('pytrgl.trans_ass_costs',50);

1816: AND ptp.payroll_id = pera.payroll_id
1817: AND ppa.effective_date BETWEEN ptp.start_date
1818: AND ptp.end_date;
1819: --
1820: hr_utility.set_location('pytrgl.trans_ass_costs',50);
1821: --
1822: INSERT INTO pay_gl_interface
1823: ( assignment_action_id,
1824: run_payroll_action_id,

Line 1902: hr_utility.set_location('pytrgl.trans_ass_costs',60);

1898: cst.debit_or_credit,
1899: decode (IV.uom, 'M', et.output_currency_code, 'STAT'),
1900: decode (CST.source_id, null, null, l_accounting_date);
1901: --
1902: hr_utility.set_location('pytrgl.trans_ass_costs',60);
1903: --
1904: else
1905: --
1906: -- Payment Costing processes

Line 1947: hr_utility.set_location('pytrgl.trans_ass_costs',70);

1943: ppc.account_id,
1944: ppc.debit_or_credit,
1945: ppc.currency_code;
1946: --
1947: hr_utility.set_location('pytrgl.trans_ass_costs',70);
1948: --
1949: end if;
1950: --
1951: end if;