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 300: l_error := per_formula_functions.set_date

296: return 1;
297: end if;
298: close csr_assignment_status;
299: --
300: l_error := per_formula_functions.set_date
301: ('ASSIGNMENT_EFFECTIVE_SD',l_effective_start_date);
302: l_error := per_formula_functions.set_date
303: ('ASSIGNMENT_EFFECTIVE_ED',l_effective_end_date);
304: l_error := per_formula_functions.set_text

Line 302: l_error := per_formula_functions.set_date

298: close csr_assignment_status;
299: --
300: l_error := per_formula_functions.set_date
301: ('ASSIGNMENT_EFFECTIVE_SD',l_effective_start_date);
302: l_error := per_formula_functions.set_date
303: ('ASSIGNMENT_EFFECTIVE_ED',l_effective_end_date);
304: l_error := per_formula_functions.set_text
305: ('ASSIGNMENT_SYSTEM_STATUS',l_per_system_status);
306: --

Line 304: l_error := per_formula_functions.set_text

300: l_error := per_formula_functions.set_date
301: ('ASSIGNMENT_EFFECTIVE_SD',l_effective_start_date);
302: l_error := per_formula_functions.set_date
303: ('ASSIGNMENT_EFFECTIVE_ED',l_effective_end_date);
304: l_error := per_formula_functions.set_text
305: ('ASSIGNMENT_SYSTEM_STATUS',l_per_system_status);
306: --
307: hr_utility.set_location(l_proc, 10);
308: return 0;

Line 357: l_error := per_formula_functions.set_number

353: open c_count_periods;
354: fetch c_count_periods into l_periods;
355: close c_count_periods;
356:
357: l_error := per_formula_functions.set_number
358: ('PAYROLL_YEAR_NUMBER_OF_PERIODS',l_periods);
359:
360: hr_utility.set_location(l_proc, 10);
361: -- START bug 4956943

Line 383: l_error := per_formula_functions.set_date

379: fetch c_first_date into l_start_date;
380: close c_first_date;
381: end if;
382:
383: l_error := per_formula_functions.set_date
384: ('PAYROLL_YEAR_FIRST_VALID_DATE', l_start_date);
385:
386: hr_utility.set_location(l_proc, 15);
387:

Line 920: l_error := per_formula_functions.set_number

916: if csr_get_payroll%isopen then
917: close csr_get_payroll;
918: end if;
919: --
920: l_error := per_formula_functions.set_number
921: ('LATEST_PAYROLL_ID',l_payroll_id);
922: --
923: hr_utility.set_location(l_proc, 15);
924: return 0;

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

953: fetch csr_get_payroll_period into l_start_date,l_end_date,l_period_number;
954: if csr_get_payroll_period%notfound then
955: close csr_get_payroll_period;
956: hr_utility.set_location('Payroll Period not found '||l_proc, 10);
957: l_error := per_formula_functions.raise_error(800, 'HR_52798_PTO_PAYROLL_INVALID');
958: return 1;
959: end if;
960: close csr_get_payroll_period;
961: --

Line 962: l_error := per_formula_functions.set_date

958: return 1;
959: end if;
960: close csr_get_payroll_period;
961: --
962: l_error := per_formula_functions.set_date
963: ('PAYROLL_PERIOD_START_DATE',l_start_date);
964: l_error := per_formula_functions.set_date
965: ('PAYROLL_PERIOD_END_DATE',l_end_date);
966: l_error := per_formula_functions.set_number

Line 964: l_error := per_formula_functions.set_date

960: close csr_get_payroll_period;
961: --
962: l_error := per_formula_functions.set_date
963: ('PAYROLL_PERIOD_START_DATE',l_start_date);
964: l_error := per_formula_functions.set_date
965: ('PAYROLL_PERIOD_END_DATE',l_end_date);
966: l_error := per_formula_functions.set_number
967: ('PAYROLL_PERIOD_NUMBER',l_period_number);
968: --

Line 966: l_error := per_formula_functions.set_number

962: l_error := per_formula_functions.set_date
963: ('PAYROLL_PERIOD_START_DATE',l_start_date);
964: l_error := per_formula_functions.set_date
965: ('PAYROLL_PERIOD_END_DATE',l_end_date);
966: l_error := per_formula_functions.set_number
967: ('PAYROLL_PERIOD_NUMBER',l_period_number);
968: --
969: hr_utility.set_location(l_proc, 15);
970: return 0;

Line 1284: l_error := per_formula_functions.set_date

1280: fetch csr_get_per_term_date into l_Per_date;
1281: close csr_get_per_term_date;
1282: --
1283: if l_Per_date is not null THEN
1284: l_error := per_formula_functions.set_date
1285: ('PER_TERMINATION_DATE',l_Per_date);
1286: else
1287: --changes for bug 5749588 starts here
1288: open csr_get_Asg_term_date;

Line 1293: l_error := per_formula_functions.set_date

1289: fetch csr_get_Asg_term_date into l_Per_date;
1290: close csr_get_Asg_term_date;
1291: --changes for bug 5749588 ends here
1292: -- l_Per_date := hr_api.g_eot;
1293: l_error := per_formula_functions.set_date
1294: ('PER_TERMINATION_DATE',l_Per_date);
1295: hr_utility.set_location(l_proc, 10);
1296: -- return 1;
1297: end if;

Line 1328: l_error := per_formula_functions.set_date

1324: fetch csr_get_payroll_range into l_start_date,l_end_date;
1325: close csr_get_payroll_range;
1326: --
1327: if l_start_date is not null and l_end_date is not null then
1328: l_error := per_formula_functions.set_date
1329: ('PAYROLL_MAX_START_DATE',l_start_date);
1330: l_error := per_formula_functions.set_date
1331: ('PAYROLL_MAX_END_DATE',l_end_date);
1332: else

Line 1330: l_error := per_formula_functions.set_date

1326: --
1327: if l_start_date is not null and l_end_date is not null then
1328: l_error := per_formula_functions.set_date
1329: ('PAYROLL_MAX_START_DATE',l_start_date);
1330: l_error := per_formula_functions.set_date
1331: ('PAYROLL_MAX_END_DATE',l_end_date);
1332: else
1333: hr_utility.set_location(l_proc, 10);
1334: return 1;