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.PER_UTILITY_FUNCTIONS dependencies on PER_FORMULA_FUNCTIONS

Line 85: l_error := per_formula_functions.raise_error(800, 'HR_52798_PTO_PAYROLL_INVALID');

81: fetch csr_get_payroll_period into l_start_date,l_end_date,l_period_number;
82: if csr_get_payroll_period%notfound then
83: close csr_get_payroll_period;
84: hr_utility.set_location('Payroll Period not found '||l_proc, 10);
85: l_error := per_formula_functions.raise_error(800, 'HR_52798_PTO_PAYROLL_INVALID');
86: return 1;
87: end if;
88: close csr_get_payroll_period;
89: --

Line 90: l_error := per_formula_functions.set_date

86: return 1;
87: end if;
88: close csr_get_payroll_period;
89: --
90: l_error := per_formula_functions.set_date
91: ('PAYROLL_PERIOD_START_DATE',l_start_date);
92: l_error := per_formula_functions.set_date
93: ('PAYROLL_PERIOD_END_DATE',l_end_date);
94: l_error := per_formula_functions.set_number

Line 92: l_error := per_formula_functions.set_date

88: close csr_get_payroll_period;
89: --
90: l_error := per_formula_functions.set_date
91: ('PAYROLL_PERIOD_START_DATE',l_start_date);
92: l_error := per_formula_functions.set_date
93: ('PAYROLL_PERIOD_END_DATE',l_end_date);
94: l_error := per_formula_functions.set_number
95: ('PAYROLL_PERIOD_NUMBER',l_period_number);
96: --

Line 94: l_error := per_formula_functions.set_number

90: l_error := per_formula_functions.set_date
91: ('PAYROLL_PERIOD_START_DATE',l_start_date);
92: l_error := per_formula_functions.set_date
93: ('PAYROLL_PERIOD_END_DATE',l_end_date);
94: l_error := per_formula_functions.set_number
95: ('PAYROLL_PERIOD_NUMBER',l_period_number);
96: --
97: hr_utility.set_location(l_proc, 15);
98: return 0;

Line 150: l_error := per_formula_functions.set_number('ANNUAL_RATE',l_annual_rate);

146: return 1;
147: end if;
148: close csr_get_accrual_band;
149: --
150: l_error := per_formula_functions.set_number('ANNUAL_RATE',l_annual_rate);
151: l_error := per_formula_functions.set_number('UPPER_LIMIT',l_upper_limit);
152: l_error := per_formula_functions.set_number('CEILING' ,l_ceiling);
153: l_error := per_formula_functions.set_number('MAX_CARRY_OVER',l_max_carry_over);
154: --

Line 151: l_error := per_formula_functions.set_number('UPPER_LIMIT',l_upper_limit);

147: end if;
148: close csr_get_accrual_band;
149: --
150: l_error := per_formula_functions.set_number('ANNUAL_RATE',l_annual_rate);
151: l_error := per_formula_functions.set_number('UPPER_LIMIT',l_upper_limit);
152: l_error := per_formula_functions.set_number('CEILING' ,l_ceiling);
153: l_error := per_formula_functions.set_number('MAX_CARRY_OVER',l_max_carry_over);
154: --
155: hr_utility.set_location(l_proc, 15);

Line 152: l_error := per_formula_functions.set_number('CEILING' ,l_ceiling);

148: close csr_get_accrual_band;
149: --
150: l_error := per_formula_functions.set_number('ANNUAL_RATE',l_annual_rate);
151: l_error := per_formula_functions.set_number('UPPER_LIMIT',l_upper_limit);
152: l_error := per_formula_functions.set_number('CEILING' ,l_ceiling);
153: l_error := per_formula_functions.set_number('MAX_CARRY_OVER',l_max_carry_over);
154: --
155: hr_utility.set_location(l_proc, 15);
156: return 0;

Line 153: l_error := per_formula_functions.set_number('MAX_CARRY_OVER',l_max_carry_over);

149: --
150: l_error := per_formula_functions.set_number('ANNUAL_RATE',l_annual_rate);
151: l_error := per_formula_functions.set_number('UPPER_LIMIT',l_upper_limit);
152: l_error := per_formula_functions.set_number('CEILING' ,l_ceiling);
153: l_error := per_formula_functions.set_number('MAX_CARRY_OVER',l_max_carry_over);
154: --
155: hr_utility.set_location(l_proc, 15);
156: return 0;
157: exception

Line 207: l_error := per_formula_functions.set_date

203: l_end_date := l_start_date + p_unit_multiplier - 1;
204: end if;
205: --
206: if P_Date_In_Period between l_start_date and l_end_date then
207: l_error := per_formula_functions.set_date
208: ('PERIOD_START_DATE',l_start_date);
209: l_error := per_formula_functions.set_date
210: ('PERIOD_END_DATE',l_end_date);
211: exit;

Line 209: l_error := per_formula_functions.set_date

205: --
206: if P_Date_In_Period between l_start_date and l_end_date then
207: l_error := per_formula_functions.set_date
208: ('PERIOD_START_DATE',l_start_date);
209: l_error := per_formula_functions.set_date
210: ('PERIOD_END_DATE',l_end_date);
211: exit;
212: else
213: l_start_date := l_end_date + 1;

Line 236: l_error := per_formula_functions.set_date

232: l_start_date := l_end_date - p_unit_multiplier + 1;
233: end if;
234: --
235: if P_Date_In_Period between l_start_date and l_end_date then
236: l_error := per_formula_functions.set_date
237: ('PERIOD_START_DATE',l_start_date);
238: l_error := per_formula_functions.set_date
239: ('PERIOD_END_DATE',l_end_date);
240: exit;

Line 238: l_error := per_formula_functions.set_date

234: --
235: if P_Date_In_Period between l_start_date and l_end_date then
236: l_error := per_formula_functions.set_date
237: ('PERIOD_START_DATE',l_start_date);
238: l_error := per_formula_functions.set_date
239: ('PERIOD_END_DATE',l_end_date);
240: exit;
241: else
242: l_end_date := l_start_date - 1;

Line 297: l_hire_date := per_formula_functions.get_date('HIRE_DATE_ANNIVERSARY');

293: --
294: if P_Date_In_Period between l_start_date and l_end_date then
295:
296: if to_char(l_start_date,'ddmm') = '2902' then
297: l_hire_date := per_formula_functions.get_date('HIRE_DATE_ANNIVERSARY');
298: if to_char(l_hire_date,'ddmm') <> '2902' then
299: l_start_date := l_start_date -1;
300: end if;
301:

Line 303: l_error := per_formula_functions.set_date

299: l_start_date := l_start_date -1;
300: end if;
301:
302: end if;
303: l_error := per_formula_functions.set_date
304: ('PERIOD_START_DATE',l_start_date);
305: l_error := per_formula_functions.set_date
306: ('PERIOD_END_DATE',l_end_date);
307: exit;

Line 305: l_error := per_formula_functions.set_date

301:
302: end if;
303: l_error := per_formula_functions.set_date
304: ('PERIOD_START_DATE',l_start_date);
305: l_error := per_formula_functions.set_date
306: ('PERIOD_END_DATE',l_end_date);
307: exit;
308: else
309: l_start_date := l_end_date + 1;

Line 332: l_error := per_formula_functions.set_date

328: l_start_date := l_end_date - p_unit_multiplier + 1;
329: end if;
330: --
331: if P_Date_In_Period between l_start_date and l_end_date then
332: l_error := per_formula_functions.set_date
333: ('PERIOD_START_DATE',l_start_date);
334: l_error := per_formula_functions.set_date
335: ('PERIOD_END_DATE',l_end_date);
336: exit;

Line 334: l_error := per_formula_functions.set_date

330: --
331: if P_Date_In_Period between l_start_date and l_end_date then
332: l_error := per_formula_functions.set_date
333: ('PERIOD_START_DATE',l_start_date);
334: l_error := per_formula_functions.set_date
335: ('PERIOD_END_DATE',l_end_date);
336: exit;
337: else
338: l_end_date := l_start_date - 1;

Line 396: l_error := per_formula_functions.set_date

392: return 1;
393: end if;
394: close csr_assignment_status;
395: --
396: l_error := per_formula_functions.set_date
397: ('ASSIGNMENT_EFFECTIVE_SD',l_effective_start_date);
398: l_error := per_formula_functions.set_date
399: ('ASSIGNMENT_EFFECTIVE_ED',l_effective_end_date);
400: l_error := per_formula_functions.set_text

Line 398: l_error := per_formula_functions.set_date

394: close csr_assignment_status;
395: --
396: l_error := per_formula_functions.set_date
397: ('ASSIGNMENT_EFFECTIVE_SD',l_effective_start_date);
398: l_error := per_formula_functions.set_date
399: ('ASSIGNMENT_EFFECTIVE_ED',l_effective_end_date);
400: l_error := per_formula_functions.set_text
401: ('ASSIGNMENT_SYSTEM_STATUS',l_per_system_status);
402: --

Line 400: l_error := per_formula_functions.set_text

396: l_error := per_formula_functions.set_date
397: ('ASSIGNMENT_EFFECTIVE_SD',l_effective_start_date);
398: l_error := per_formula_functions.set_date
399: ('ASSIGNMENT_EFFECTIVE_ED',l_effective_end_date);
400: l_error := per_formula_functions.set_text
401: ('ASSIGNMENT_SYSTEM_STATUS',l_per_system_status);
402: --
403: hr_utility.set_location(l_proc, 10);
404: return 0;

Line 453: l_error := per_formula_functions.set_number

449: open c_count_periods;
450: fetch c_count_periods into l_periods;
451: close c_count_periods;
452:
453: l_error := per_formula_functions.set_number
454: ('PAYROLL_YEAR_NUMBER_OF_PERIODS',l_periods);
455:
456: hr_utility.set_location(l_proc, 10);
457: -- START bug 4956943

Line 479: l_error := per_formula_functions.set_date

475: fetch c_first_date into l_start_date;
476: close c_first_date;
477: end if;
478:
479: l_error := per_formula_functions.set_date
480: ('PAYROLL_YEAR_FIRST_VALID_DATE', l_start_date);
481:
482: hr_utility.set_location(l_proc, 15);
483:

Line 1016: l_error := per_formula_functions.set_number

1012: if csr_get_payroll%isopen then
1013: close csr_get_payroll;
1014: end if;
1015: --
1016: l_error := per_formula_functions.set_number
1017: ('LATEST_PAYROLL_ID',l_payroll_id);
1018: --
1019: hr_utility.set_location(l_proc, 15);
1020: return 0;

Line 1053: l_error := per_formula_functions.raise_error(800, 'HR_52798_PTO_PAYROLL_INVALID');

1049: fetch csr_get_payroll_period into l_start_date,l_end_date,l_period_number;
1050: if csr_get_payroll_period%notfound then
1051: close csr_get_payroll_period;
1052: hr_utility.set_location('Payroll Period not found '||l_proc, 10);
1053: l_error := per_formula_functions.raise_error(800, 'HR_52798_PTO_PAYROLL_INVALID');
1054: return 1;
1055: end if;
1056: close csr_get_payroll_period;
1057: --

Line 1058: l_error := per_formula_functions.set_date

1054: return 1;
1055: end if;
1056: close csr_get_payroll_period;
1057: --
1058: l_error := per_formula_functions.set_date
1059: ('PAYROLL_PERIOD_START_DATE',l_start_date);
1060: l_error := per_formula_functions.set_date
1061: ('PAYROLL_PERIOD_END_DATE',l_end_date);
1062: l_error := per_formula_functions.set_number

Line 1060: l_error := per_formula_functions.set_date

1056: close csr_get_payroll_period;
1057: --
1058: l_error := per_formula_functions.set_date
1059: ('PAYROLL_PERIOD_START_DATE',l_start_date);
1060: l_error := per_formula_functions.set_date
1061: ('PAYROLL_PERIOD_END_DATE',l_end_date);
1062: l_error := per_formula_functions.set_number
1063: ('PAYROLL_PERIOD_NUMBER',l_period_number);
1064: --

Line 1062: l_error := per_formula_functions.set_number

1058: l_error := per_formula_functions.set_date
1059: ('PAYROLL_PERIOD_START_DATE',l_start_date);
1060: l_error := per_formula_functions.set_date
1061: ('PAYROLL_PERIOD_END_DATE',l_end_date);
1062: l_error := per_formula_functions.set_number
1063: ('PAYROLL_PERIOD_NUMBER',l_period_number);
1064: --
1065: hr_utility.set_location(l_proc, 15);
1066: return 0;

Line 1380: l_error := per_formula_functions.set_date

1376: fetch csr_get_per_term_date into l_Per_date;
1377: close csr_get_per_term_date;
1378: --
1379: if l_Per_date is not null THEN
1380: l_error := per_formula_functions.set_date
1381: ('PER_TERMINATION_DATE',l_Per_date);
1382: else
1383: --changes for bug 5749588 starts here
1384: open csr_get_Asg_term_date;

Line 1389: l_error := per_formula_functions.set_date

1385: fetch csr_get_Asg_term_date into l_Per_date;
1386: close csr_get_Asg_term_date;
1387: --changes for bug 5749588 ends here
1388: -- l_Per_date := hr_api.g_eot;
1389: l_error := per_formula_functions.set_date
1390: ('PER_TERMINATION_DATE',l_Per_date);
1391: hr_utility.set_location(l_proc, 10);
1392: -- return 1;
1393: end if;

Line 1424: l_error := per_formula_functions.set_date

1420: fetch csr_get_payroll_range into l_start_date,l_end_date;
1421: close csr_get_payroll_range;
1422: --
1423: if l_start_date is not null and l_end_date is not null then
1424: l_error := per_formula_functions.set_date
1425: ('PAYROLL_MAX_START_DATE',l_start_date);
1426: l_error := per_formula_functions.set_date
1427: ('PAYROLL_MAX_END_DATE',l_end_date);
1428: else

Line 1426: l_error := per_formula_functions.set_date

1422: --
1423: if l_start_date is not null and l_end_date is not null then
1424: l_error := per_formula_functions.set_date
1425: ('PAYROLL_MAX_START_DATE',l_start_date);
1426: l_error := per_formula_functions.set_date
1427: ('PAYROLL_MAX_END_DATE',l_end_date);
1428: else
1429: hr_utility.set_location(l_proc, 10);
1430: return 1;