DBA Data[Home] [Help]

APPS.HR_BUDGET_CALENDAR dependencies on HR_UTILITY

Line 72: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');

68: where tpe.period_set_name = p_period_set_name
69: and tpe.start_date = p_start_date;
70: exception
71: when no_data_found then
72: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');
73: hr_utility.set_message_token('PROCEDURE',
74: 'hr_budget_calendar.midpoint_offset');
75: hr_utility.set_message_token('STEP', '1');
76: hr_utility.raise_error;

Line 73: hr_utility.set_message_token('PROCEDURE',

69: and tpe.start_date = p_start_date;
70: exception
71: when no_data_found then
72: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');
73: hr_utility.set_message_token('PROCEDURE',
74: 'hr_budget_calendar.midpoint_offset');
75: hr_utility.set_message_token('STEP', '1');
76: hr_utility.raise_error;
77: end;

Line 75: hr_utility.set_message_token('STEP', '1');

71: when no_data_found then
72: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');
73: hr_utility.set_message_token('PROCEDURE',
74: 'hr_budget_calendar.midpoint_offset');
75: hr_utility.set_message_token('STEP', '1');
76: hr_utility.raise_error;
77: end;
78: --
79: return v_midpoint_offset;

Line 76: hr_utility.raise_error;

72: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');
73: hr_utility.set_message_token('PROCEDURE',
74: 'hr_budget_calendar.midpoint_offset');
75: hr_utility.set_message_token('STEP', '1');
76: hr_utility.raise_error;
77: end;
78: --
79: return v_midpoint_offset;
80: --

Line 301: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');

297: where cal.period_set_name = p_period_set_name
298: and tpt.period_type = cal.actual_period_type;
299: exception
300: when no_data_found then
301: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');
302: hr_utility.set_message_token('PROCEDURE',
303: 'hr_budget_calendar.get_cal_details');
304: hr_utility.set_message_token('STEP', '1');
305: hr_utility.raise_error;

Line 302: hr_utility.set_message_token('PROCEDURE',

298: and tpt.period_type = cal.actual_period_type;
299: exception
300: when no_data_found then
301: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');
302: hr_utility.set_message_token('PROCEDURE',
303: 'hr_budget_calendar.get_cal_details');
304: hr_utility.set_message_token('STEP', '1');
305: hr_utility.raise_error;
306: end;

Line 304: hr_utility.set_message_token('STEP', '1');

300: when no_data_found then
301: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');
302: hr_utility.set_message_token('PROCEDURE',
303: 'hr_budget_calendar.get_cal_details');
304: hr_utility.set_message_token('STEP', '1');
305: hr_utility.raise_error;
306: end;
307: --
308: -- Find the base period type and multiplier for the period type.

Line 305: hr_utility.raise_error;

301: hr_utility.set_message(801, 'ALL_PROCEDURE_FAIL');
302: hr_utility.set_message_token('PROCEDURE',
303: 'hr_budget_calendar.get_cal_details');
304: hr_utility.set_message_token('STEP', '1');
305: hr_utility.raise_error;
306: end;
307: --
308: -- Find the base period type and multiplier for the period type.
309: hr_payrolls.get_period_details

Line 543: hr_utility.set_message(801, 'HR_7087_TIME_ONE_YR_AT_LEAST');

539: --
540: -- At least one year of time periods must exist for the calendar unless the
541: -- calendar is being removed where all time period need to be removed.
542: if p_at_least_one_year and p_number_of_years < 1 then
543: hr_utility.set_message(801, 'HR_7087_TIME_ONE_YR_AT_LEAST');
544: hr_utility.raise_error;
545: else
546: --
547: -- See if any of the time periods to be removed are used by a budget.

Line 544: hr_utility.raise_error;

540: -- At least one year of time periods must exist for the calendar unless the
541: -- calendar is being removed where all time period need to be removed.
542: if p_at_least_one_year and p_number_of_years < 1 then
543: hr_utility.set_message(801, 'HR_7087_TIME_ONE_YR_AT_LEAST');
544: hr_utility.raise_error;
545: else
546: --
547: -- See if any of the time periods to be removed are used by a budget.
548: open csr_budget_values;

Line 552: hr_utility.set_message(801, 'HR_7088_TIME_USED_IN_BUDGET');

548: open csr_budget_values;
549: fetch csr_budget_values into v_time_period_id;
550: if csr_budget_values%found then
551: close csr_budget_values;
552: hr_utility.set_message(801, 'HR_7088_TIME_USED_IN_BUDGET');
553: hr_utility.raise_error;
554: else
555: close csr_budget_values;
556: end if;

Line 553: hr_utility.raise_error;

549: fetch csr_budget_values into v_time_period_id;
550: if csr_budget_values%found then
551: close csr_budget_values;
552: hr_utility.set_message(801, 'HR_7088_TIME_USED_IN_BUDGET');
553: hr_utility.raise_error;
554: else
555: close csr_budget_values;
556: end if;
557: --