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

Line 112: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_INSERTION', 1);

108: p_business_group_id number ) is
109: --
110: begin
111: --
112: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_INSERTION', 1);
113: --
114: pay_link_input_values_pkg.create_link_input_value(
115: --
116: p_element_link_id,

Line 122: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_INSERTION', 2);

118: p_effective_start_date,
119: p_effective_end_date,
120: p_element_type_id);
121: --
122: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_INSERTION', 2);
123: --
124: if p_people_group_id is not null then
125: pay_asg_link_usages_pkg.insert_alu(
126: --

Line 169: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_DELETION', 1);

165: for update;
166: --
167: begin
168: --
169: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_DELETION', 1);
170: --
171: for fetched_entry in csr_links_entries LOOP
172: --
173: hr_entry_api.delete_element_entry (

Line 181: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_DELETION', 2);

177: fetched_entry.element_entry_id);
178: --
179: end loop;
180: --
181: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_DELETION', 2);
182: --
183: pay_asg_link_usages_pkg.cascade_link_deletion (
184: --
185: p_element_link_id,

Line 205: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_DELETION', 3);

201: ,p_payroll_action_id => null
202: );
203: end if;
204: --
205: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_DELETION', 3);
206: --
207: <>
208: --
209: FOR fetched_input_value in csr_all_inputs_for_link LOOP

Line 254: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_DELETION', 4);

250: end if;
251: --
252: end loop remove_orphaned_input_values;
253: --
254: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_DELETION', 4);
255: --
256: end cascade_deletion;
257: --------------------------------------------------------------------------------
258: function LINK_END_DATE (p_link_id number) return date is

Line 339: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.INSERT_ROW',1);

335: from sys.dual;
336: --
337: begin
338: --
339: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.INSERT_ROW',1);
340: --
341: if p_element_link_id is null then
342: open csr_next_ID;
343: fetch csr_next_ID into p_element_link_id;

Line 352: hr_utility.set_message(801,'PAY_6462_LINK_DIST_IN_DIST');

348: p_element_type_id,
349: p_business_group_id,
350: p_legislation_code) then
351:
352: hr_utility.set_message(801,'PAY_6462_LINK_DIST_IN_DIST');
353: hr_utility.raise_error;
354:
355: end if;
356: --

Line 353: hr_utility.raise_error;

349: p_business_group_id,
350: p_legislation_code) then
351:
352: hr_utility.set_message(801,'PAY_6462_LINK_DIST_IN_DIST');
353: hr_utility.raise_error;
354:
355: end if;
356: --
357:

Line 363: hr_utility.set_message(801,'PAY_33093_LINK_NO_PAY_BASIS');

359:
360: if p_standard_link_flag = 'Y' and
361: pay_basis_exists(p_element_type_id, p_business_group_id) then
362:
363: hr_utility.set_message(801,'PAY_33093_LINK_NO_PAY_BASIS');
364: hr_utility.raise_error;
365: end if;
366:
367: */

Line 364: hr_utility.raise_error;

360: if p_standard_link_flag = 'Y' and
361: pay_basis_exists(p_element_type_id, p_business_group_id) then
362:
363: hr_utility.set_message(801,'PAY_33093_LINK_NO_PAY_BASIS');
364: hr_utility.raise_error;
365: end if;
366:
367: */
368: --

Line 545: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.LOCK_ROW',1);

541: locked_row csr_locked_row%rowtype;
542: --
543: begin
544: --
545: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.LOCK_ROW',1);
546: --
547: open csr_locked_row;
548: fetch csr_locked_row into locked_row;
549: if csr_locked_row%notfound then

Line 756: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.UPDATE_ROW',1);

752: p_attribute20 varchar2) is
753: --
754: begin
755: --
756: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.UPDATE_ROW',1);
757: --
758: /*
759: p_effective_end_date := pay_element_links_pkg.max_end_date (
760: p_element_type_id,

Line 815: hr_utility.trace ('|p_effective_end_date>' || p_effective_end_date || '<');

811: p_employment_category,
812: p_pay_basis_id,
813: p_business_group_id)
814: );
815: hr_utility.trace ('|p_effective_end_date>' || p_effective_end_date || '<');
816:
817:
818: if p_costable_type = 'D'
819: and pay_element_links_pkg.element_in_distribution_set (

Line 824: hr_utility.set_message(801,'PAY_6462_LINK_DIST_IN_DIST');

820: p_element_type_id,
821: p_business_group_id,
822: p_legislation_code) then
823:
824: hr_utility.set_message(801,'PAY_6462_LINK_DIST_IN_DIST');
825: hr_utility.raise_error;
826:
827: end if;
828:

Line 825: hr_utility.raise_error;

821: p_business_group_id,
822: p_legislation_code) then
823:
824: hr_utility.set_message(801,'PAY_6462_LINK_DIST_IN_DIST');
825: hr_utility.raise_error;
826:
827: end if;
828:
829: update pay_element_links_f

Line 901: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.DELETE_ROW',1);

897: v_effective_end_date date;
898: --
899: begin
900: --
901: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.DELETE_ROW',1);
902: --
903: check_deletion_allowed ( p_element_link_id,
904: p_delete_mode,
905: p_validation_start_date);

Line 1114: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.LAST_EXCLUSIVE_DATE', 1);

1110: end link_differs_on;
1111:
1112: BEGIN
1113:
1114: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.LAST_EXCLUSIVE_DATE', 1);
1115:
1116: open csr_my_people_group;
1117: fetch csr_my_people_group into new_link;
1118:

Line 1174: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.last_exclusive_date',2);

1170: or (link_differs_on (existing_link.segment29, new_link.segment29))
1171: or (link_differs_on (existing_link.segment30, new_link.segment30)))
1172: then
1173: --
1174: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.last_exclusive_date',2);
1175: --
1176: -- Set the end date to avoid clash; raise an error if that is not possible
1177: if (p_validation_start_date < existing_link.effective_start_date) then
1178: --

Line 1179: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.last_exclusive_date',3);

1175: --
1176: -- Set the end date to avoid clash; raise an error if that is not possible
1177: if (p_validation_start_date < existing_link.effective_start_date) then
1178: --
1179: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.last_exclusive_date',3);
1180: v_last_exclusive_date := existing_link.effective_start_date - 1;
1181: exit LINK_TEST; -- The cursor ordering ensures that the date is that
1182: -- of the chronologically first matching link
1183: --

Line 1186: hr_utility.set_message(801,'PAY_6398_ELEMENT_NOT_MUT_EXCLU');

1182: -- of the chronologically first matching link
1183: --
1184: else
1185: --
1186: hr_utility.set_message(801,'PAY_6398_ELEMENT_NOT_MUT_EXCLU');
1187: hr_utility.raise_error;
1188: --
1189: end if;
1190: --

Line 1187: hr_utility.raise_error;

1183: --
1184: else
1185: --
1186: hr_utility.set_message(801,'PAY_6398_ELEMENT_NOT_MUT_EXCLU');
1187: hr_utility.raise_error;
1188: --
1189: end if;
1190: --
1191: end if;

Line 1200: hr_utility.trace ('v_last_exclusive_date is '||v_last_exclusive_date);

1196: if v_last_exclusive_date is null then -- no matching criteria were found
1197: v_last_exclusive_date := c_end_of_time;
1198: end if;
1199: --
1200: hr_utility.trace ('v_last_exclusive_date is '||v_last_exclusive_date);
1201: --
1202: return v_last_exclusive_date;
1203: --
1204: end last_exclusive_date;

Line 1257: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.MAX_END_DATE',1);

1253: from pay_payrolls_f
1254: where payroll_id = p_payroll_id;
1255: begin
1256: --
1257: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.MAX_END_DATE',1);
1258: hr_utility.trace ('p_validation_start_date = '||p_validation_start_date);
1259: hr_utility.trace ('p_validation_end_date = '||p_validation_end_date);
1260: --
1261: -- If there is a named payroll, then take its last end date; if the link is to

Line 1258: hr_utility.trace ('p_validation_start_date = '||p_validation_start_date);

1254: where payroll_id = p_payroll_id;
1255: begin
1256: --
1257: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.MAX_END_DATE',1);
1258: hr_utility.trace ('p_validation_start_date = '||p_validation_start_date);
1259: hr_utility.trace ('p_validation_end_date = '||p_validation_end_date);
1260: --
1261: -- If there is a named payroll, then take its last end date; if the link is to
1262: -- all payrolls, then take the latest end date from all payrolls in the

Line 1259: hr_utility.trace ('p_validation_end_date = '||p_validation_end_date);

1255: begin
1256: --
1257: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.MAX_END_DATE',1);
1258: hr_utility.trace ('p_validation_start_date = '||p_validation_start_date);
1259: hr_utility.trace ('p_validation_end_date = '||p_validation_end_date);
1260: --
1261: -- If there is a named payroll, then take its last end date; if the link is to
1262: -- all payrolls, then take the latest end date from all payrolls in the
1263: -- business group.

Line 1284: hr_utility.trace ('v_max_element_date is '||v_max_element_date);

1280: close csr_named_element;
1281: --
1282: v_max_element_date := nvl(v_max_element_date, c_end_of_time);
1283: --
1284: hr_utility.trace ('v_max_element_date is '||v_max_element_date);
1285: hr_utility.trace ('v_max_payroll_date is '||v_max_payroll_date);
1286:
1287: return least ( v_max_payroll_date,
1288: v_max_element_date,

Line 1285: hr_utility.trace ('v_max_payroll_date is '||v_max_payroll_date);

1281: --
1282: v_max_element_date := nvl(v_max_element_date, c_end_of_time);
1283: --
1284: hr_utility.trace ('v_max_element_date is '||v_max_element_date);
1285: hr_utility.trace ('v_max_payroll_date is '||v_max_payroll_date);
1286:
1287: return least ( v_max_payroll_date,
1288: v_max_element_date,
1289: last_exclusive_date (p_element_type_id,

Line 1340: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CHECK_DISTRIBUTION_SET', 1);

1336: element_in_set boolean;
1337:
1338: begin
1339:
1340: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CHECK_DISTRIBUTION_SET', 1);
1341:
1342: open csr_distribution_set;
1343: fetch csr_distribution_set into g_dummy;
1344: element_in_set := csr_distribution_set%found;

Line 1370: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.ELEMENT_ENTRIES_EXIST', 1);

1366: from pay_element_entries_f
1367: where element_link_id = p_element_link_id;
1368: begin
1369: --
1370: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.ELEMENT_ENTRIES_EXIST', 1);
1371: --
1372: open csr_entries;
1373: fetch csr_entries into g_dummy;
1374: if csr_entries%found and p_error_if_true then

Line 1376: hr_utility.set_message(801,'PAY_52153_ENTRIES_EXIST');

1372: open csr_entries;
1373: fetch csr_entries into g_dummy;
1374: if csr_entries%found and p_error_if_true then
1375: -- Bug 481143. Changed message 6465 to 52153.01-Jul-1997.mlisieck.
1376: hr_utility.set_message(801,'PAY_52153_ENTRIES_EXIST');
1377: hr_utility.raise_error;
1378: end if;
1379: v_entries_exist := csr_entries%found;
1380: close csr_entries;

Line 1377: hr_utility.raise_error;

1373: fetch csr_entries into g_dummy;
1374: if csr_entries%found and p_error_if_true then
1375: -- Bug 481143. Changed message 6465 to 52153.01-Jul-1997.mlisieck.
1376: hr_utility.set_message(801,'PAY_52153_ENTRIES_EXIST');
1377: hr_utility.raise_error;
1378: end if;
1379: v_entries_exist := csr_entries%found;
1380: close csr_entries;
1381: --

Line 1407: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DATE_EFFECTIVELY_UPDATED',1);

1403: and rowid <> p_rowid;
1404: --
1405: begin
1406: --
1407: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DATE_EFFECTIVELY_UPDATED',1);
1408: --
1409: open csr_updates;
1410: fetch csr_updates into g_dummy;
1411: v_updates_exist := csr_updates%found;

Line 1449: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CHECK_DELETION_ALLOWED', 10);

1445: and balance_entry.entry_type = 'B';
1446: --
1447: begin
1448: --
1449: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CHECK_DELETION_ALLOWED', 10);
1450: --
1451: -- Bug 5512101. Changes for Batch Element Link support.
1452: -- We need to ensure that the element link is complete
1453: -- unless the delete mode is ZAP.

Line 1463: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CHECK_DELETION_ALLOWED', 20);

1459: );
1460: end if;
1461:
1462:
1463: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CHECK_DELETION_ALLOWED', 20);
1464: --
1465: -- Bug 1490304 - if p_delete_mode in DELETE or ZAP then open both cursors
1466: -- else only open csr_entries.
1467: --

Line 1474: hr_utility.set_message(801,'HR_7134_LINK_NO_DEL_ENTRIES');

1470: open csr_balance_adjustments;
1471: fetch csr_entries into g_dummy;
1472: fetch csr_balance_adjustments into g_dummy;
1473: if csr_entries%found or csr_balance_adjustments%found then
1474: hr_utility.set_message(801,'HR_7134_LINK_NO_DEL_ENTRIES');
1475: hr_utility.raise_error;
1476: end if;
1477: close csr_entries;
1478: close csr_balance_adjustments;

Line 1475: hr_utility.raise_error;

1471: fetch csr_entries into g_dummy;
1472: fetch csr_balance_adjustments into g_dummy;
1473: if csr_entries%found or csr_balance_adjustments%found then
1474: hr_utility.set_message(801,'HR_7134_LINK_NO_DEL_ENTRIES');
1475: hr_utility.raise_error;
1476: end if;
1477: close csr_entries;
1478: close csr_balance_adjustments;
1479: ELSE

Line 1483: hr_utility.set_message(801,'HR_7134_LINK_NO_DEL_ENTRIES');

1479: ELSE
1480: open csr_entries;
1481: fetch csr_entries into g_dummy;
1482: if csr_entries%found then
1483: hr_utility.set_message(801,'HR_7134_LINK_NO_DEL_ENTRIES');
1484: hr_utility.raise_error;
1485: end if;
1486: close csr_entries;
1487: END IF;

Line 1484: hr_utility.raise_error;

1480: open csr_entries;
1481: fetch csr_entries into g_dummy;
1482: if csr_entries%found then
1483: hr_utility.set_message(801,'HR_7134_LINK_NO_DEL_ENTRIES');
1484: hr_utility.raise_error;
1485: end if;
1486: close csr_entries;
1487: END IF;
1488: end check_deletion_allowed;

Line 1507: hr_utility.set_location ('pay_element_links_pkg.check_relationships',1);

1503: p_element_entries_exist out nocopy boolean ) is
1504: --
1505: begin
1506: --
1507: hr_utility.set_location ('pay_element_links_pkg.check_relationships',1);
1508: --
1509: p_date_effectively_updated := date_effectively_updated (p_element_link_id,
1510: p_rowid );
1511: --