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 333: hr_utility.set_location('pytrgl.trans_pay_costs',10);

329: l_group_id VARCHAR2(80);
330: --
331: BEGIN
332: --
333: hr_utility.set_location('pytrgl.trans_pay_costs',10);
334: --
335: sql_curs :=dbms_sql.open_cursor;
336: --
337: OPEN transfer_payrolls (i_payroll_action_id);

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

335: sql_curs :=dbms_sql.open_cursor;
336: --
337: OPEN transfer_payrolls (i_payroll_action_id);
338: --
339: hr_utility.set_location('pytrgl.trans_pay_costs',20);
340: --
341: -- Bug 1066820 avoid passing in hard coded strings.
342: --
343: select user_je_source_name

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

344: into l_source_name
345: from gl_je_sources_vl
346: where je_source_name = 'Payroll';
347: --
348: hr_utility.set_location('pytrgl.trans_pay_costs',25);
349: --
350: select user_je_category_name
351: into l_category_name
352: from gl_je_categories_vl

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

351: into l_category_name
352: from gl_je_categories_vl
353: where je_category_name = 'Payroll';
354: --
355: hr_utility.set_location('pytrgl.trans_pay_costs',27);
356: --
357: -- Find if use an accouting date of date_earned
358: -- (default is effective_date)
359: --

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

366: when others then
367: l_date_used := 'P';
368: end;
369: --
370: hr_utility.set_location('pytrgl.trans_pay_costs',28);
371: --
372: -- Find if use an accouting date of date_earned
373: -- (default is effective_date)
374: --

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

381: when others then
382: l_rvb_acc_date := 'P';
383: end;
384: --
385: hr_utility.set_location('pytrgl.trans_pay_costs',29);
386: --
387: -- Find if should populate gl_interface.group_id
388: -- (default is to leave this column blank)
389: -- If so we populate it with the TGL payroll_action_id

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

397: when others then
398: l_group_id := 'N';
399: end;
400: --
401: hr_utility.set_location('pytrgl.trans_pay_costs',30);
402: --
403: -- Process each run action in turn. Each run action may be for
404: -- several payrolls. Each payroll will be processed separately.
405: LOOP

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

409: c_cost_action_id, -- cost action
410: c_payroll_id,
411: c_set_of_books_id;
412: --
413: hr_utility.set_location('pytrgl.trans_pay_costs',31);
414: --
415: EXIT WHEN transfer_payrolls%NOTFOUND;
416: --
417: hr_utility.set_location('pytrgl.trans_pay_costs',32);

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

413: hr_utility.set_location('pytrgl.trans_pay_costs',31);
414: --
415: EXIT WHEN transfer_payrolls%NOTFOUND;
416: --
417: hr_utility.set_location('pytrgl.trans_pay_costs',32);
418: --
419: select decode(ppa1.action_type, 'S', ppa1.effective_date,
420: decode(ppa2.action_type, 'B', decode(l_rvb_acc_date, 'C', ppa1.effective_date,
421: ppa2.effective_date),

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

434: pay_payroll_actions ppa2 -- Payroll run action
435: where ppa1.payroll_action_id = c_cost_action_id
436: and ppa2.payroll_action_id = c_run_action_id;
437: --
438: hr_utility.set_location('pytrgl.trans_pay_costs',35);
439: --
440: -- Get payrolls currency conversion rate type
441: -- handle fact that it may be null
442: --

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

447: c_conversion_date := c_accounting_date;
448:
449: exception
450: when no_data_found then
451: hr_utility.set_location('pytrgl.trans_pay_costs',37);
452: l_currency_type := null;
453: c_conversion_date := null;
454: end;
455: --

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

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

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

468: -- Dynamically build up the segment lists for the payroll.
469: FOR flex_segs IN flex_segments ( c_payroll_id, c_set_of_books_id )
470: LOOP
471: --
472: hr_utility.set_location('pytrgl.trans_pay_costs',50);
473: --
474: gl_segment_list := gl_segment_list ||
475: flex_segs.gl_account_segment ||',';
476: --

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

473: --
474: gl_segment_list := gl_segment_list ||
475: flex_segs.gl_account_segment ||',';
476: --
477: hr_utility.set_location('pytrgl.trans_pay_costs',60);
478: --
479: -- Payroll segment list needs to MIN() function as not grouped
480: -- by each segment.
481: --

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

488: --
489: prev_payroll_id := c_payroll_id;
490: prev_sob_id := c_set_of_books_id;
491: --
492: hr_utility.set_location('pytrgl.trans_pay_costs',70);
493: --
494: -- Put the statement into the cursor and parse. Don't know how long
495: -- the segment list is so we cannot bind to variables.
496: --

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

906: decode (IV.uom, ''M'', et.output_currency_code, ''STAT'')',
907: dbms_sql.v7);
908: end if;
909: --
910: hr_utility.set_location('pytrgl.trans_pay_costs',80);
911: --
912: -- Bind the variable values to the cursor values.
913: --
914: dbms_sql.bind_variable(sql_curs,'c_run_action_id',

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

939: -- Execute the insert statment.
940: --
941: rows_processed := dbms_sql.execute(sql_curs);
942: --
943: hr_utility.set_location('pytrgl.trans_pay_costs',90);
944: --
945: -- Update the assignment actions. Mark as processed.
946: --
947: UPDATE pay_assignment_actions pa

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

968: AND ppa2.effective_date
969: BETWEEN per.effective_start_date
970: AND per.effective_end_date);
971: --
972: hr_utility.set_location('pytrgl.trans_pay_costs', 100);
973: --
974: COMMIT;
975: --
976: END LOOP;

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

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

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

980: CLOSE transfer_payrolls;
981: --
982: dbms_sql.close_cursor(sql_curs);
983: --
984: hr_utility.set_location('pytrgl.trans_pay_costs',120);
985: --
986: END trans_pay_costs;
987:
988: --

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

1129: l_asg_join VARCHAR2(500);
1130: --
1131: BEGIN
1132: --
1133: hr_utility.set_location('pytrgl.trans_pay_costs_mt',10);
1134: --
1135: sql_curs := dbms_sql.open_cursor;
1136: --
1137: OPEN transfer_payrolls (i_payroll_action_id);

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

1135: sql_curs := dbms_sql.open_cursor;
1136: --
1137: OPEN transfer_payrolls (i_payroll_action_id);
1138: --
1139: hr_utility.set_location('pytrgl.trans_pay_costs_mt',20);
1140: --
1141: -- Bug 1066820 avoid passing in hard coded strings.
1142: --
1143: select user_je_source_name

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

1144: into l_source_name
1145: from gl_je_sources_vl
1146: where je_source_name = 'Payroll';
1147: --
1148: hr_utility.set_location('pytrgl.trans_pay_costs_mt',25);
1149: --
1150: select user_je_category_name
1151: into l_category_name
1152: from gl_je_categories_vl

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

1151: into l_category_name
1152: from gl_je_categories_vl
1153: where je_category_name = 'Payroll';
1154: --
1155: hr_utility.set_location('pytrgl.trans_pay_costs_mt',27);
1156: --
1157: select bus.currency_code, bus.business_group_id
1158: into l_bus_currency_code, l_bus_grp_id
1159: from per_business_groups_perf bus,

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

1160: pay_payroll_actions ppa
1161: where ppa.payroll_action_id = i_payroll_action_id
1162: and bus.business_group_id = ppa.business_group_id;
1163: --
1164: hr_utility.set_location('pytrgl.trans_pay_costs',28);
1165: --
1166: -- Find if use an accouting date of date_earned
1167: -- (default is effective_date)
1168: --

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

1188: when others then
1189: l_rvb_acc_date := 'P';
1190: end;
1191: --
1192: hr_utility.set_location('pytrgl.trans_pay_costs',29);
1193: --
1194: -- Find if should populate gl_interface.group_id
1195: -- (default is to leave this column blank)
1196: -- If so we populate it with the TGL payroll_action_id

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

1216: c_payroll_id,
1217: c_set_of_books_id,
1218: c_pay_id;
1219: --
1220: hr_utility.set_location('pytrgl.trans_pay_costs_mt',30);
1221: --
1222: EXIT WHEN transfer_payrolls%NOTFOUND;
1223: --
1224: hr_utility.set_location('pytrgl.trans_pay_costs_mt',32);

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

1220: hr_utility.set_location('pytrgl.trans_pay_costs_mt',30);
1221: --
1222: EXIT WHEN transfer_payrolls%NOTFOUND;
1223: --
1224: hr_utility.set_location('pytrgl.trans_pay_costs_mt',32);
1225: --
1226: if (c_action_type in ('C', 'S')) then
1227:
1228: select decode(ppa1.action_type, 'S', ppa1.effective_date,

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

1257: -- required payroll. Use string concatenation method to avoid performance hit
1258: -- ie only join to per_all_assignments_f if have to.
1259: if ((c_action_type = 'EC' or c_action_type = 'CP') and
1260: c_pay_id is null) then
1261: hr_utility.set_location('pytrgl.trans_pay_costs_mt',33);
1262: l_asg_tab := 'per_all_assignments_f paf,';
1263: l_asg_join :=
1264: 'AND paf.assignment_id = '||'p'||'a.assignment_id
1265: AND :c_run_date between paf.effective_start_date

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

1265: AND :c_run_date between paf.effective_start_date
1266: and paf.effective_end_date
1267: AND paf.payroll_id = :c_payroll_id';
1268: else
1269: hr_utility.set_location('pytrgl.trans_pay_costs_mt',34);
1270: l_asg_tab := '';
1271: l_asg_join := '';
1272: end if;
1273:

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

1271: l_asg_join := '';
1272: end if;
1273:
1274: --
1275: hr_utility.set_location('pytrgl.trans_pay_costs_mt',35);
1276: --
1277: -- Get payrolls currency conversion rate type
1278: -- handle fact that it may be null
1279: --

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

1284: c_conversion_date := c_accounting_date;
1285:
1286: exception
1287: when no_data_found then
1288: hr_utility.set_location('pytrgl.trans_pay_costs',37);
1289: l_currency_type := null;
1290: c_conversion_date := null;
1291: end;
1292: --

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

1299: --
1300: pay_segment_list := NULL;
1301: gl_segment_list := NULL;
1302: --
1303: hr_utility.set_location('pytrgl.trans_pay_costs_mt',40);
1304: --
1305: -- Dynamically build up the segment lists for the payroll.
1306: FOR flex_segs IN flex_segments ( c_payroll_id, c_set_of_books_id )
1307: LOOP

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

1305: -- Dynamically build up the segment lists for the payroll.
1306: FOR flex_segs IN flex_segments ( c_payroll_id, c_set_of_books_id )
1307: LOOP
1308: --
1309: hr_utility.set_location('pytrgl.trans_pay_costs_mt',50);
1310: --
1311: gl_segment_list := gl_segment_list ||
1312: flex_segs.gl_account_segment ||',';
1313: --

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

1310: --
1311: gl_segment_list := gl_segment_list ||
1312: flex_segs.gl_account_segment ||',';
1313: --
1314: hr_utility.set_location('pytrgl.trans_pay_costs_mt',60);
1315: --
1316: -- Payroll segment list needs to MIN() function as not grouped
1317: -- by each segment.
1318: --

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

1325: --
1326: prev_payroll_id := c_payroll_id;
1327: prev_sob_id := c_set_of_books_id;
1328: --
1329: hr_utility.set_location('pytrgl.trans_pay_costs_mt',65);
1330: --
1331: -- For Payment Costs should not populate segment columns
1332: -- in gl_interface : bug 6169000
1333: --

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

1338: l_pay_segment_list := pay_segment_list;
1339: l_gl_segment_list := gl_segment_list;
1340: end if;
1341: --
1342: hr_utility.set_location('pytrgl.trans_pay_costs_mt',70);
1343: --
1344: -- Put the statement into the cursor and parse. Don't know how long
1345: -- the segment list is so we cannot bind to variables.
1346: --

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

1486: pgl.currency_code',
1487: dbms_sql.v7);
1488: end if;
1489: --
1490: hr_utility.set_location('pytrgl.trans_pay_costs_mt',80);
1491: --
1492: -- Bind the variable values to the cursor values.
1493: --
1494: dbms_sql.bind_variable(sql_curs,'c_run_action_id',

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

1530: -- Execute the insert statment.
1531: --
1532: rows_processed := dbms_sql.execute(sql_curs);
1533: --
1534: hr_utility.set_location('pytrgl.trans_pay_costs_mt',90);
1535: --
1536: END LOOP;
1537: --
1538: hr_utility.set_location('pytrgl.trans_pay_costs_mt',100);

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

1534: hr_utility.set_location('pytrgl.trans_pay_costs_mt',90);
1535: --
1536: END LOOP;
1537: --
1538: hr_utility.set_location('pytrgl.trans_pay_costs_mt',100);
1539: --
1540: CLOSE transfer_payrolls;
1541: --
1542: dbms_sql.close_cursor(sql_curs);

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

1540: CLOSE transfer_payrolls;
1541: --
1542: dbms_sql.close_cursor(sql_curs);
1543: --
1544: hr_utility.set_location('pytrgl.trans_pay_costs_mt',110);
1545: --
1546: COMMIT;
1547: --
1548: hr_utility.set_location('pytrgl.trans_pay_costs_mt',120);

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

1544: hr_utility.set_location('pytrgl.trans_pay_costs_mt',110);
1545: --
1546: COMMIT;
1547: --
1548: hr_utility.set_location('pytrgl.trans_pay_costs_mt',120);
1549: --
1550: END trans_pay_costs_mt;
1551: --
1552: PROCEDURE trans_ass_costs

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

1565: l_date_used VARCHAR2(80);
1566: l_accounting_date DATE;
1567: BEGIN
1568: --
1569: hr_utility.set_location('pytrgl.trans_ass_costs',10);
1570: --
1571: if (sla_mode = 1) then
1572: --
1573: hr_utility.set_location('pytrgl.trans_ass_costs',14);

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

1569: hr_utility.set_location('pytrgl.trans_ass_costs',10);
1570: --
1571: if (sla_mode = 1) then
1572: --
1573: hr_utility.set_location('pytrgl.trans_ass_costs',14);
1574: --
1575: pay_sla_pkg.trans_asg_costs(i_assignment_action_id);
1576: --
1577: hr_utility.set_location('pytrgl.trans_ass_costs',16);

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

1573: hr_utility.set_location('pytrgl.trans_ass_costs',14);
1574: --
1575: pay_sla_pkg.trans_asg_costs(i_assignment_action_id);
1576: --
1577: hr_utility.set_location('pytrgl.trans_ass_costs',16);
1578: --
1579: else
1580: --
1581: hr_utility.set_location('pytrgl.trans_ass_costs',18);

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

1577: hr_utility.set_location('pytrgl.trans_ass_costs',16);
1578: --
1579: else
1580: --
1581: hr_utility.set_location('pytrgl.trans_ass_costs',18);
1582: --
1583: SELECT pa.payroll_action_id,
1584: pa1.assignment_id,
1585: pa1.assignment_action_id,

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

1604: --
1605: -- Costing or Retrocostong hence know run result populated
1606: -- in pay_costs.
1607: --
1608: hr_utility.set_location('pytrgl.trans_ass_costs',20);
1609: --
1610: SELECT pa2.assignment_action_id,
1611: ppa2.payroll_action_id,
1612: ppa2.action_type,

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

1624: AND pa2.assignment_action_id = pi2.locked_action_id
1625: AND ppa2.payroll_action_id = pa2.payroll_action_id
1626: AND ppa2.action_type NOT IN ('C', 'S', 'EC');
1627: --
1628: hr_utility.set_location('pytrgl.trans_ass_costs',30);
1629: --
1630: INSERT INTO pay_gl_interface
1631: ( assignment_action_id,
1632: run_payroll_action_id,

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

1784: GROUP BY cst.cost_allocation_keyflex_id,
1785: cst.debit_or_credit,
1786: decode (IV.uom, 'M', et.output_currency_code, 'STAT');
1787: --
1788: hr_utility.set_location('pytrgl.trans_ass_costs',40);
1789: --
1790: elsif (c_action_type = 'EC') then
1791: --
1792: -- Estimate Costing hence run result not populated

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

1791: --
1792: -- Estimate Costing hence run result not populated
1793: -- in pay_costs.
1794: --
1795: hr_utility.set_location('pytrgl.trans_ass_costs',50);
1796: --
1797: --
1798: -- Find if use an accouting date of date_earned
1799: -- (default is effective_date)

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

1810: end;
1811: end if;
1812: l_date_used := g_date_used;
1813: --
1814: hr_utility.set_location('pytrgl.trans_pay_costs',29);
1815: --
1816: -- get accounting_date according to TGL_DATE_USED
1817: -- for use with the reversal costs
1818: --

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

1835: AND ptp.payroll_id = pera.payroll_id
1836: AND ppa.effective_date BETWEEN ptp.start_date
1837: AND ptp.end_date;
1838: --
1839: hr_utility.set_location('pytrgl.trans_ass_costs',50);
1840: --
1841: INSERT INTO pay_gl_interface
1842: ( assignment_action_id,
1843: run_payroll_action_id,

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

1917: cst.debit_or_credit,
1918: decode (IV.uom, 'M', et.output_currency_code, 'STAT'),
1919: decode (CST.source_id, null, null, l_accounting_date);
1920: --
1921: hr_utility.set_location('pytrgl.trans_ass_costs',60);
1922: --
1923: else
1924: --
1925: -- Payment Costing processes

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

1962: ppc.account_id,
1963: ppc.debit_or_credit,
1964: ppc.currency_code;
1965: --
1966: hr_utility.set_location('pytrgl.trans_ass_costs',70);
1967: --
1968: end if;
1969: --
1970: end if;