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

Line 241: hr_utility.set_location ('PAY_STATUS_RULES_PKG',1);

237: v_end_date date;
238: --
239: begin
240: --
241: hr_utility.set_location ('PAY_STATUS_RULES_PKG',1);
242: --
243: open csr_spr_end_date;
244: fetch csr_spr_end_date into v_date1;
245: close csr_spr_end_date;

Line 297: hr_utility.set_location ('PAY_STATUS_RULES_PKG.PARENT_DELETED',1);

293: for update;
294: --
295: begin
296: --
297: hr_utility.set_location ('PAY_STATUS_RULES_PKG.PARENT_DELETED',1);
298: --
299: <>
300: for fetched_rule in csr_rows_owned_by_parent LOOP
301: --

Line 314: hr_utility.set_location ('PAY_STATUS_RULES_PKG.PARENT_DELETED',2);

310: if p_delete_mode = 'ZAP' -- ie delete all rows
311: or (p_delete_mode = 'DELETE' -- ie delete all future rows
312: and fetched_rule.effective_start_date > p_session_date) then
313: --
314: hr_utility.set_location ('PAY_STATUS_RULES_PKG.PARENT_DELETED',2);
315: --
316: delete from pay_status_processing_rules_f
317: where current of csr_rows_owned_by_parent;
318: --

Line 319: hr_utility.set_location ('PAY_STATUS_RULES_PKG.PARENT_DELETED',3);

315: --
316: delete from pay_status_processing_rules_f
317: where current of csr_rows_owned_by_parent;
318: --
319: hr_utility.set_location ('PAY_STATUS_RULES_PKG.PARENT_DELETED',3);
320: --
321: delete from hr_application_ownerships
322: where key_name = 'STATUS_PROCESSING_RULE_ID'
323: and key_value = fetched_rule.status_processing_rule_id;

Line 329: hr_utility.set_location ('PAY_STATUS_RULES_PKG.PARENT_DELETED',4);

325: elsif p_delete_mode = 'DELETE'
326: and p_session_date between fetched_rule.effective_start_date
327: and fetched_rule.effective_end_date then
328: --
329: hr_utility.set_location ('PAY_STATUS_RULES_PKG.PARENT_DELETED',4);
330: --
331: update pay_status_processing_rules_f
332: set effective_end_date = p_session_date
333: where current of csr_rows_owned_by_parent;

Line 337: hr_utility.set_location ('PAY_STATUS_RULES_PKG.PARENT_DELETED',5);

333: where current of csr_rows_owned_by_parent;
334: --
335: end if;
336: --
337: hr_utility.set_location ('PAY_STATUS_RULES_PKG.PARENT_DELETED',5);
338: --
339: -- Cascade the action to formula result rules for this SPR
340: pay_formula_result_rules_pkg.parent_deleted (
341: --

Line 427: hr_utility.set_location('PAY_STATUS_RULES_PKG.NO_INPUT_VALUES_MATCH_FORMULA',1);

423: v_match_not_found boolean := FALSE;
424: --
425: begin
426: --
427: hr_utility.set_location('PAY_STATUS_RULES_PKG.NO_INPUT_VALUES_MATCH_FORMULA',1);
428: --
429: open csr_number_of_input_values;
430: fetch csr_number_of_input_values into v_number_to_match;
431: close csr_number_of_input_values;

Line 433: hr_utility.set_location('PAY_STATUS_RULES_PKG.NO_INPUT_VALUES_MATCH_FORMULA',5);

429: open csr_number_of_input_values;
430: fetch csr_number_of_input_values into v_number_to_match;
431: close csr_number_of_input_values;
432: --
433: hr_utility.set_location('PAY_STATUS_RULES_PKG.NO_INPUT_VALUES_MATCH_FORMULA',5);
434: open csr_matching_data_types;
435: fetch csr_matching_data_types into v_number_of_matches;
436: close csr_matching_data_types;
437: --

Line 470: hr_utility.set_location ('PAY_STATUS_RULES_PKG.DATE_EFFECTIVELY_UPDATED',1);

466: date_effective_updates_exist boolean := FALSE;
467:
468: begin
469:
470: hr_utility.set_location ('PAY_STATUS_RULES_PKG.DATE_EFFECTIVELY_UPDATED',1);
471:
472: open csr_dated_updates;
473: fetch csr_dated_updates into g_dummy;
474: date_effective_updates_exist := csr_dated_updates%found;

Line 612: hr_utility.set_message(801, 'HR_34858_RULE_PAST_ELEMENT');

608: if v_status_rule_end_date < p_validation_start_date then
609: if v_next_status_rule_start_date is null and
610: v_max_formula_end_date is null then
611: --- Trying to extend beyond life of element
612: hr_utility.set_message(801, 'HR_34858_RULE_PAST_ELEMENT');
613: elsif v_next_status_rule_start_date is null and
614: v_max_formula_end_date <= p_max_element_end_date then
615: -- Trying to extend beyond life of the formula
616: hr_utility.set_message(801, 'HR_34857_RULE_PAST_FORMULA');

Line 616: hr_utility.set_message(801, 'HR_34857_RULE_PAST_FORMULA');

612: hr_utility.set_message(801, 'HR_34858_RULE_PAST_ELEMENT');
613: elsif v_next_status_rule_start_date is null and
614: v_max_formula_end_date <= p_max_element_end_date then
615: -- Trying to extend beyond life of the formula
616: hr_utility.set_message(801, 'HR_34857_RULE_PAST_FORMULA');
617: else
618: -- Trying to extend beyond life of status rule causing overlap
619: hr_utility.set_message(801, 'HR_34856_STATUS_RULE_FUT_EXIST');
620: end if;

Line 619: hr_utility.set_message(801, 'HR_34856_STATUS_RULE_FUT_EXIST');

615: -- Trying to extend beyond life of the formula
616: hr_utility.set_message(801, 'HR_34857_RULE_PAST_FORMULA');
617: else
618: -- Trying to extend beyond life of status rule causing overlap
619: hr_utility.set_message(801, 'HR_34856_STATUS_RULE_FUT_EXIST');
620: end if;
621: hr_utility.raise_error;
622: end if;
623: --

Line 621: hr_utility.raise_error;

617: else
618: -- Trying to extend beyond life of status rule causing overlap
619: hr_utility.set_message(801, 'HR_34856_STATUS_RULE_FUT_EXIST');
620: end if;
621: hr_utility.raise_error;
622: end if;
623: --
624: return v_status_rule_end_date;
625: --