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 105: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_INSERTION', 1);

101: p_business_group_id number ) is
102: --
103: begin
104: --
105: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_INSERTION', 1);
106: --
107: pay_link_input_values_pkg.create_link_input_value(
108: --
109: p_element_link_id,

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

111: p_effective_start_date,
112: p_effective_end_date,
113: p_element_type_id);
114: --
115: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_INSERTION', 2);
116: --
117: pay_asg_link_usages_pkg.insert_alu(
118: --
119: p_business_group_id,

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

156: for update;
157: --
158: begin
159: --
160: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_DELETION', 1);
161: --
162: for fetched_entry in csr_links_entries LOOP
163: --
164: hr_entry_api.delete_element_entry (

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

168: fetched_entry.element_entry_id);
169: --
170: end loop;
171: --
172: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_DELETION', 2);
173: --
174: pay_asg_link_usages_pkg.cascade_link_deletion (
175: --
176: p_element_link_id,

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

192: ,p_payroll_action_id => null
193: );
194: end if;
195: --
196: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_DELETION', 3);
197: --
198: <>
199: --
200: FOR fetched_input_value in csr_all_inputs_for_link LOOP

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

241: end if;
242: --
243: end loop remove_orphaned_input_values;
244: --
245: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CASCADE_DELETION', 4);
246: --
247: end cascade_deletion;
248: --------------------------------------------------------------------------------
249: function LINK_END_DATE (p_link_id number) return date is

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

326: from sys.dual;
327: --
328: begin
329: --
330: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.INSERT_ROW',1);
331: --
332: if p_element_link_id is null then
333: open csr_next_ID;
334: fetch csr_next_ID into p_element_link_id;

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

339: p_element_type_id,
340: p_business_group_id,
341: p_legislation_code) then
342:
343: hr_utility.set_message(801,'PAY_6462_LINK_DIST_IN_DIST');
344: hr_utility.raise_error;
345:
346: end if;
347: --

Line 344: hr_utility.raise_error;

340: p_business_group_id,
341: p_legislation_code) then
342:
343: hr_utility.set_message(801,'PAY_6462_LINK_DIST_IN_DIST');
344: hr_utility.raise_error;
345:
346: end if;
347: --
348:

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

350:
351: if p_standard_link_flag = 'Y' and
352: pay_basis_exists(p_element_type_id, p_business_group_id) then
353:
354: hr_utility.set_message(801,'PAY_33093_LINK_NO_PAY_BASIS');
355: hr_utility.raise_error;
356: end if;
357:
358: */

Line 355: hr_utility.raise_error;

351: if p_standard_link_flag = 'Y' and
352: pay_basis_exists(p_element_type_id, p_business_group_id) then
353:
354: hr_utility.set_message(801,'PAY_33093_LINK_NO_PAY_BASIS');
355: hr_utility.raise_error;
356: end if;
357:
358: */
359: --

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

532: locked_row csr_locked_row%rowtype;
533: --
534: begin
535: --
536: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.LOCK_ROW',1);
537: --
538: open csr_locked_row;
539: fetch csr_locked_row into locked_row;
540: if csr_locked_row%notfound then

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

743: p_attribute20 varchar2) is
744: --
745: begin
746: --
747: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.UPDATE_ROW',1);
748: --
749: /*
750: p_effective_end_date := pay_element_links_pkg.max_end_date (
751: p_element_type_id,

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

802: p_employment_category,
803: p_pay_basis_id,
804: p_business_group_id)
805: );
806: hr_utility.trace ('|p_effective_end_date>' || p_effective_end_date || '<');
807:
808:
809: if p_costable_type = 'D'
810: and pay_element_links_pkg.element_in_distribution_set (

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

811: p_element_type_id,
812: p_business_group_id,
813: p_legislation_code) then
814:
815: hr_utility.set_message(801,'PAY_6462_LINK_DIST_IN_DIST');
816: hr_utility.raise_error;
817:
818: end if;
819:

Line 816: hr_utility.raise_error;

812: p_business_group_id,
813: p_legislation_code) then
814:
815: hr_utility.set_message(801,'PAY_6462_LINK_DIST_IN_DIST');
816: hr_utility.raise_error;
817:
818: end if;
819:
820: update pay_element_links_f

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

888: v_effective_end_date date;
889: --
890: begin
891: --
892: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.DELETE_ROW',1);
893: --
894: check_deletion_allowed ( p_element_link_id,
895: p_delete_mode,
896: p_validation_start_date);

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

1099: end link_differs_on;
1100:
1101: BEGIN
1102:
1103: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.LAST_EXCLUSIVE_DATE', 1);
1104:
1105: open csr_my_people_group;
1106: fetch csr_my_people_group into new_link;
1107:

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

1159: or (link_differs_on (existing_link.segment29, new_link.segment29))
1160: or (link_differs_on (existing_link.segment30, new_link.segment30)))
1161: then
1162: --
1163: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.last_exclusive_date',2);
1164: --
1165: -- Set the end date to avoid clash; raise an error if that is not possible
1166: if (p_validation_start_date < existing_link.effective_start_date) then
1167: --

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

1164: --
1165: -- Set the end date to avoid clash; raise an error if that is not possible
1166: if (p_validation_start_date < existing_link.effective_start_date) then
1167: --
1168: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.last_exclusive_date',3);
1169: v_last_exclusive_date := existing_link.effective_start_date - 1;
1170: exit LINK_TEST; -- The cursor ordering ensures that the date is that
1171: -- of the chronologically first matching link
1172: --

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

1171: -- of the chronologically first matching link
1172: --
1173: else
1174: --
1175: hr_utility.set_message(801,'PAY_6398_ELEMENT_NOT_MUT_EXCLU');
1176: hr_utility.raise_error;
1177: --
1178: end if;
1179: --

Line 1176: hr_utility.raise_error;

1172: --
1173: else
1174: --
1175: hr_utility.set_message(801,'PAY_6398_ELEMENT_NOT_MUT_EXCLU');
1176: hr_utility.raise_error;
1177: --
1178: end if;
1179: --
1180: end if;

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

1185: if v_last_exclusive_date is null then -- no matching criteria were found
1186: v_last_exclusive_date := c_end_of_time;
1187: end if;
1188: --
1189: hr_utility.trace ('v_last_exclusive_date is '||v_last_exclusive_date);
1190: --
1191: return v_last_exclusive_date;
1192: --
1193: end last_exclusive_date;

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

1242: from pay_payrolls_f
1243: where payroll_id = p_payroll_id;
1244: begin
1245: --
1246: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.MAX_END_DATE',1);
1247: hr_utility.trace ('p_validation_start_date = '||p_validation_start_date);
1248: hr_utility.trace ('p_validation_end_date = '||p_validation_end_date);
1249: --
1250: -- If there is a named payroll, then take its last end date; if the link is to

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

1243: where payroll_id = p_payroll_id;
1244: begin
1245: --
1246: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.MAX_END_DATE',1);
1247: hr_utility.trace ('p_validation_start_date = '||p_validation_start_date);
1248: hr_utility.trace ('p_validation_end_date = '||p_validation_end_date);
1249: --
1250: -- If there is a named payroll, then take its last end date; if the link is to
1251: -- all payrolls, then take the latest end date from all payrolls in the

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

1244: begin
1245: --
1246: hr_utility.set_location ('PAY_ELEMENT_LINKS_PKG.MAX_END_DATE',1);
1247: hr_utility.trace ('p_validation_start_date = '||p_validation_start_date);
1248: hr_utility.trace ('p_validation_end_date = '||p_validation_end_date);
1249: --
1250: -- If there is a named payroll, then take its last end date; if the link is to
1251: -- all payrolls, then take the latest end date from all payrolls in the
1252: -- business group.

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

1269: close csr_named_element;
1270: --
1271: v_max_element_date := nvl(v_max_element_date, c_end_of_time);
1272: --
1273: hr_utility.trace ('v_max_element_date is '||v_max_element_date);
1274: hr_utility.trace ('v_max_payroll_date is '||v_max_payroll_date);
1275:
1276: return least ( v_max_payroll_date,
1277: v_max_element_date,

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

1270: --
1271: v_max_element_date := nvl(v_max_element_date, c_end_of_time);
1272: --
1273: hr_utility.trace ('v_max_element_date is '||v_max_element_date);
1274: hr_utility.trace ('v_max_payroll_date is '||v_max_payroll_date);
1275:
1276: return least ( v_max_payroll_date,
1277: v_max_element_date,
1278: last_exclusive_date (p_element_type_id,

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

1325: element_in_set boolean;
1326:
1327: begin
1328:
1329: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CHECK_DISTRIBUTION_SET', 1);
1330:
1331: open csr_distribution_set;
1332: fetch csr_distribution_set into g_dummy;
1333: element_in_set := csr_distribution_set%found;

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

1355: from pay_element_entries_f
1356: where element_link_id = p_element_link_id;
1357: begin
1358: --
1359: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.ELEMENT_ENTRIES_EXIST', 1);
1360: --
1361: open csr_entries;
1362: fetch csr_entries into g_dummy;
1363: if csr_entries%found and p_error_if_true then

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

1361: open csr_entries;
1362: fetch csr_entries into g_dummy;
1363: if csr_entries%found and p_error_if_true then
1364: -- Bug 481143. Changed message 6465 to 52153.01-Jul-1997.mlisieck.
1365: hr_utility.set_message(801,'PAY_52153_ENTRIES_EXIST');
1366: hr_utility.raise_error;
1367: end if;
1368: v_entries_exist := csr_entries%found;
1369: close csr_entries;

Line 1366: hr_utility.raise_error;

1362: fetch csr_entries into g_dummy;
1363: if csr_entries%found and p_error_if_true then
1364: -- Bug 481143. Changed message 6465 to 52153.01-Jul-1997.mlisieck.
1365: hr_utility.set_message(801,'PAY_52153_ENTRIES_EXIST');
1366: hr_utility.raise_error;
1367: end if;
1368: v_entries_exist := csr_entries%found;
1369: close csr_entries;
1370: --

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

1392: and rowid <> p_rowid;
1393: --
1394: begin
1395: --
1396: hr_utility.set_location ('PAY_ELEMENT_TYPES_PKG.DATE_EFFECTIVELY_UPDATED',1);
1397: --
1398: open csr_updates;
1399: fetch csr_updates into g_dummy;
1400: v_updates_exist := csr_updates%found;

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

1434: and balance_entry.entry_type = 'B';
1435: --
1436: begin
1437: --
1438: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CHECK_DELETION_ALLOWED', 10);
1439: --
1440: -- Bug 5512101. Changes for Batch Element Link support.
1441: -- We need to ensure that the element link is complete
1442: -- unless the delete mode is ZAP.

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

1448: );
1449: end if;
1450:
1451:
1452: hr_utility.set_location('PAY_ELEMENT_LINKS_PKG.CHECK_DELETION_ALLOWED', 20);
1453: --
1454: -- Bug 1490304 - if p_delete_mode in DELETE or ZAP then open both cursors
1455: -- else only open csr_entries.
1456: --

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

1459: open csr_balance_adjustments;
1460: fetch csr_entries into g_dummy;
1461: fetch csr_balance_adjustments into g_dummy;
1462: if csr_entries%found or csr_balance_adjustments%found then
1463: hr_utility.set_message(801,'HR_7134_LINK_NO_DEL_ENTRIES');
1464: hr_utility.raise_error;
1465: end if;
1466: close csr_entries;
1467: close csr_balance_adjustments;

Line 1464: hr_utility.raise_error;

1460: fetch csr_entries into g_dummy;
1461: fetch csr_balance_adjustments into g_dummy;
1462: if csr_entries%found or csr_balance_adjustments%found then
1463: hr_utility.set_message(801,'HR_7134_LINK_NO_DEL_ENTRIES');
1464: hr_utility.raise_error;
1465: end if;
1466: close csr_entries;
1467: close csr_balance_adjustments;
1468: ELSE

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

1468: ELSE
1469: open csr_entries;
1470: fetch csr_entries into g_dummy;
1471: if csr_entries%found then
1472: hr_utility.set_message(801,'HR_7134_LINK_NO_DEL_ENTRIES');
1473: hr_utility.raise_error;
1474: end if;
1475: close csr_entries;
1476: END IF;

Line 1473: hr_utility.raise_error;

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

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

1492: p_element_entries_exist out nocopy boolean ) is
1493: --
1494: begin
1495: --
1496: hr_utility.set_location ('pay_element_links_pkg.check_relationships',1);
1497: --
1498: p_date_effectively_updated := date_effectively_updated (p_element_link_id,
1499: p_rowid );
1500: --