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

Line 160: hr_utility.set_location('Entering:'||l_proc, 5);

156: l_proc varchar2(72) := g_package||'constraint_error';
157: --
158: Begin
159: --
160: hr_utility.set_location('Entering:'||l_proc, 5);
161: --
162: If (p_constraint_name = 'PER_ABSENCE_ATTENDANCES_FK4') Then
163: --
164: -- The linked_absence_id does not refer to a valid absence_attendance_id.

Line 242: hr_utility.set_location(' Leaving:'||l_proc, 10);

238: End If;
239: --
240: fnd_message.raise_error;
241: --
242: hr_utility.set_location(' Leaving:'||l_proc, 10);
243: --
244: End constraint_error;
245: --
246: -- ---------------------------------------------------------------------------

Line 290: hr_utility.set_location ('Entering:'||l_proc,1);

286: l_proc varchar2 (72) := g_package||'MPP_update_mode';
287: --
288: begin
289: --
290: hr_utility.set_location ('Entering:'||l_proc,1);
291: --
292: if p_update_mode = 1
293: then
294: g_mpp_update_mode := TRUE;

Line 299: hr_utility.set_location ('Leaving :'||l_proc,100);

295: else
296: g_mpp_update_mode := FALSE;
297: end if;
298: --
299: hr_utility.set_location ('Leaving :'||l_proc,100);
300: --
301: end MPP_update_mode;
302: --
303: ------------------------------------------------------------------------------

Line 332: hr_utility.set_location ('Entering:'||l_proc,1);

328: l_nos_absences number;
329: --
330: begin
331: --
332: hr_utility.set_location ('Entering:'||l_proc,1);
333: --
334: if g_mpp_update_mode = TRUE
335: then
336: --

Line 370: hr_utility.set_location ('Leaving :'||l_proc,100);

366: --
367: g_mpp_updated_date := l_default_MPP_start_date;
368: end if;
369: --
370: hr_utility.set_location ('Leaving :'||l_proc,100);
371: --
372: end reset_MPP_start_date_on_delete;
373: --
374: --------------------------------------------------------------------------------

Line 426: hr_utility.set_location ('Entering:'||l_proc,1);

422: l_apl_max_weeks number := 0; -- Bug 12850183
423: --
424: begin
425: --
426: hr_utility.set_location ('Entering:'||l_proc,1);
427: --
428: if p_maternity_id is not null
429: then
430: --

Line 441: hr_utility.set_location ('End date beyond 12 months of birth date:'||l_maternity.actual_birth_date,2);

437: /* Bug fix 12850183 start. Added validations for APL duration checks. */
438: if l_maternity.leave_type = 'AB' then
439:
440: if (nvl(p_end_date, hr_api.g_sot) >= add_months(l_maternity.actual_birth_date, 12)) then
441: hr_utility.set_location ('End date beyond 12 months of birth date:'||l_maternity.actual_birth_date,2);
442: fnd_message.set_name ('SSP', 'SSP_36812_APL_ABS_END');
443: fnd_message.raise_error;
444: end if;
445:

Line 453: hr_utility.set_location ('APL Max Weeks is:'||l_apl_max_weeks,2);

449: where ele1.element_name = ssp_apab_pkg.c_APAB_element_name
450: and l_maternity.due_date between ele1.effective_start_date
451: and ele1.effective_end_date;
452:
453: hr_utility.set_location ('APL Max Weeks is:'||l_apl_max_weeks,2);
454: if (nvl(p_end_date, hr_api.g_sot) > (nvl(p_start_date, hr_api.g_sot) + (l_apl_max_weeks * 7))) then
455: hr_utility.set_location ('APL Exceeded Max Weeks'||l_apl_max_weeks,2);
456: fnd_message.set_name ('SSP', 'SSP_36811_APL_ABS_MAX');
457: fnd_message.raise_error;

Line 455: hr_utility.set_location ('APL Exceeded Max Weeks'||l_apl_max_weeks,2);

451: and ele1.effective_end_date;
452:
453: hr_utility.set_location ('APL Max Weeks is:'||l_apl_max_weeks,2);
454: if (nvl(p_end_date, hr_api.g_sot) > (nvl(p_start_date, hr_api.g_sot) + (l_apl_max_weeks * 7))) then
455: hr_utility.set_location ('APL Exceeded Max Weeks'||l_apl_max_weeks,2);
456: fnd_message.set_name ('SSP', 'SSP_36811_APL_ABS_MAX');
457: fnd_message.raise_error;
458: end if;
459:

Line 464: hr_utility.set_location ('End date beyond 12 months of placement date:'||l_maternity.placement_date,2);

460: end if; -- End of leave type AB validations
461:
462: if l_maternity.leave_type = 'AA' then
463: if (nvl(p_end_date, hr_api.g_sot) >= add_months(l_maternity.placement_date, 12)) then
464: hr_utility.set_location ('End date beyond 12 months of placement date:'||l_maternity.placement_date,2);
465: fnd_message.set_name ('SSP', 'SSP_36812_APL_ABS_END');
466: fnd_message.raise_error;
467: end if;
468:

Line 476: hr_utility.set_location ('APL Max Weeks is:'||l_apl_max_weeks,2);

472: where ele1.element_name = ssp_apad_pkg.c_APAD_element_name
473: and l_maternity.due_date between ele1.effective_start_date
474: and ele1.effective_end_date;
475:
476: hr_utility.set_location ('APL Max Weeks is:'||l_apl_max_weeks,2);
477: if (nvl(p_end_date, hr_api.g_sot) > (nvl(p_start_date, hr_api.g_sot) + (l_apl_max_weeks * 7))) then
478: hr_utility.set_location ('APL Exceeded Max Weeks'||l_apl_max_weeks,2);
479: fnd_message.set_name ('SSP', 'SSP_36811_APL_ABS_MAX');
480: fnd_message.raise_error;

Line 478: hr_utility.set_location ('APL Exceeded Max Weeks'||l_apl_max_weeks,2);

474: and ele1.effective_end_date;
475:
476: hr_utility.set_location ('APL Max Weeks is:'||l_apl_max_weeks,2);
477: if (nvl(p_end_date, hr_api.g_sot) > (nvl(p_start_date, hr_api.g_sot) + (l_apl_max_weeks * 7))) then
478: hr_utility.set_location ('APL Exceeded Max Weeks'||l_apl_max_weeks,2);
479: fnd_message.set_name ('SSP', 'SSP_36811_APL_ABS_MAX');
480: fnd_message.raise_error;
481: end if;
482:

Line 612: hr_utility.set_location ('Leaving :'||l_proc,100);

608: end if;
609: end if;
610: end if;
611: --
612: hr_utility.set_location ('Leaving :'||l_proc,100);
613: --
614: end default_MPP_start_date;
615: --
616: procedure populate_ben_absence_rec

Line 632: hr_utility.set_location('Entering: '|| l_proc, 10);

628: l_proc varchar2(72) := g_package||'populate_ben_absence_rec';
629:
630: begin
631:
632: hr_utility.set_location('Entering: '|| l_proc, 10);
633:
634: if (p_rec_type = 'O') then
635: l_absence_rec := p_old_rec;
636: else

Line 724: hr_utility.set_location('Leaving: '|| l_proc, 15);

720: p_ben_rec.abs_information28 := l_absence_rec.abs_information28;
721: p_ben_rec.abs_information29 := l_absence_rec.abs_information29;
722: p_ben_rec.abs_information30 := l_absence_rec.abs_information30;
723:
724: hr_utility.set_location('Leaving: '|| l_proc, 15);
725: end;
726: --------------------------------------------------------------------------------
727: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
728: X_Absence_Attendance_Id IN OUT NOCOPY NUMBER,

Line 1179: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1175: OPEN C;
1176: FETCH C INTO Recinfo;
1177: if (C%NOTFOUND) then
1178: CLOSE C;
1179: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1180: hr_utility.set_message_token('PROCEDURE', 'lock_row');
1181: hr_utility.set_message_token('STEP', '1');
1182: hr_utility.raise_error;
1183: end if;

Line 1180: hr_utility.set_message_token('PROCEDURE', 'lock_row');

1176: FETCH C INTO Recinfo;
1177: if (C%NOTFOUND) then
1178: CLOSE C;
1179: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1180: hr_utility.set_message_token('PROCEDURE', 'lock_row');
1181: hr_utility.set_message_token('STEP', '1');
1182: hr_utility.raise_error;
1183: end if;
1184: CLOSE C;

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

1177: if (C%NOTFOUND) then
1178: CLOSE C;
1179: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1180: hr_utility.set_message_token('PROCEDURE', 'lock_row');
1181: hr_utility.set_message_token('STEP', '1');
1182: hr_utility.raise_error;
1183: end if;
1184: CLOSE C;
1185:

Line 1182: hr_utility.raise_error;

1178: CLOSE C;
1179: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1180: hr_utility.set_message_token('PROCEDURE', 'lock_row');
1181: hr_utility.set_message_token('STEP', '1');
1182: hr_utility.raise_error;
1183: end if;
1184: CLOSE C;
1185:
1186: recinfo.comments := rtrim(recinfo.comments);

Line 1853: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1849: DELETE FROM per_absence_attendances
1850: WHERE rowid = chartorowid(X_Rowid);
1851:
1852: if (SQL%NOTFOUND) then
1853: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1854: hr_utility.set_message_token('PROCEDURE', 'delete_row');
1855: hr_utility.set_message_token('STEP', '1');
1856: hr_utility.raise_error;
1857: end if;

Line 1854: hr_utility.set_message_token('PROCEDURE', 'delete_row');

1850: WHERE rowid = chartorowid(X_Rowid);
1851:
1852: if (SQL%NOTFOUND) then
1853: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1854: hr_utility.set_message_token('PROCEDURE', 'delete_row');
1855: hr_utility.set_message_token('STEP', '1');
1856: hr_utility.raise_error;
1857: end if;
1858:

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

1851:
1852: if (SQL%NOTFOUND) then
1853: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1854: hr_utility.set_message_token('PROCEDURE', 'delete_row');
1855: hr_utility.set_message_token('STEP', '1');
1856: hr_utility.raise_error;
1857: end if;
1858:
1859: populate_ben_absence_rec

Line 1856: hr_utility.raise_error;

1852: if (SQL%NOTFOUND) then
1853: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1854: hr_utility.set_message_token('PROCEDURE', 'delete_row');
1855: hr_utility.set_message_token('STEP', '1');
1856: hr_utility.raise_error;
1857: end if;
1858:
1859: populate_ben_absence_rec
1860: (p_absence_attendance_id => l_absence.absence_attendance_id,

Line 1910: hr_utility.set_location('per_absence_attendances_pkg.b_check_auth_de',1);

1906: and pp.current_employee_flag = 'Y';
1907: --
1908: begin
1909: --
1910: hr_utility.set_location('per_absence_attendances_pkg.b_check_auth_de',1);
1911: --
1912: open c1;
1913: --
1914: fetch c1 into l_exists;

Line 1916: hr_utility.set_message(801, 'PER_7886_EMP_ABS_DURATION');

1912: open c1;
1913: --
1914: fetch c1 into l_exists;
1915: IF c1%notfound THEN
1916: hr_utility.set_message(801, 'PER_7886_EMP_ABS_DURATION');
1917: close c1;
1918: hr_utility.raise_error;
1919: END IF;
1920: --

Line 1918: hr_utility.raise_error;

1914: fetch c1 into l_exists;
1915: IF c1%notfound THEN
1916: hr_utility.set_message(801, 'PER_7886_EMP_ABS_DURATION');
1917: close c1;
1918: hr_utility.raise_error;
1919: END IF;
1920: --
1921: close c1;
1922: --

Line 1956: hr_utility.set_location('per_absence_attendances_pkg.b_check_rep_de',1);

1952: and pp.current_employee_flag = 'Y';
1953: --
1954: begin
1955: --
1956: hr_utility.set_location('per_absence_attendances_pkg.b_check_rep_de',1);
1957: --
1958: open c3;
1959: --
1960: fetch c3 into l_exists;

Line 1962: hr_utility.set_message(801, 'PER_7887_EMP_ABS_DURATION');

1958: open c3;
1959: --
1960: fetch c3 into l_exists;
1961: IF c3%notfound THEN
1962: hr_utility.set_message(801, 'PER_7887_EMP_ABS_DURATION');
1963: close c3;
1964: hr_utility.raise_error;
1965: END IF;
1966: --

Line 1964: hr_utility.raise_error;

1960: fetch c3 into l_exists;
1961: IF c3%notfound THEN
1962: hr_utility.set_message(801, 'PER_7887_EMP_ABS_DURATION');
1963: close c3;
1964: hr_utility.raise_error;
1965: END IF;
1966: --
1967: close c3;
1968: --

Line 1988: hr_utility.set_location('per_absence_attendances_pkg.b_check_for_termination',1);

1984: and p.person_id = p_rep_per;
1985: --
1986: begin
1987: --
1988: hr_utility.set_location('per_absence_attendances_pkg.b_check_for_termination',1);
1989: --
1990: open c2;
1991: --
1992: l_ret_val := c2%found;

Line 2026: hr_utility.set_location('per_absence_attendances_pkg.chk_rep_req',1);

2022: and pp.replacement_required_flag = 'Y';
2023: --
2024: begin
2025: --
2026: hr_utility.set_location('per_absence_attendances_pkg.chk_rep_req',1);
2027: --
2028: open c4;
2029: fetch c4 into l_exists;
2030: --

Line 2061: hr_utility.set_location('per_absence_attendances_pkg.chk_type',1);

2057: or p_dend is null);
2058: --
2059: begin
2060: --
2061: hr_utility.set_location('per_absence_attendances_pkg.chk_type',1);
2062: --
2063: open c5;
2064: --
2065: fetch c5 into l_exists;

Line 2067: hr_utility.set_message(801, 'HR_6847_ABS_DET_RANGE_CHECK');

2063: open c5;
2064: --
2065: fetch c5 into l_exists;
2066: IF c5%notfound THEN
2067: hr_utility.set_message(801, 'HR_6847_ABS_DET_RANGE_CHECK');
2068: hr_utility.set_message_token('ABS_DATE_FROM', to_char(p_abs_from,'DD-MON-YYYY'));
2069: hr_utility.set_message_token('ABS_DATE_TO', to_char(p_abs_to,'DD-MON-YYYY'));
2070: close c5;
2071: hr_utility.raise_error;

Line 2068: hr_utility.set_message_token('ABS_DATE_FROM', to_char(p_abs_from,'DD-MON-YYYY'));

2064: --
2065: fetch c5 into l_exists;
2066: IF c5%notfound THEN
2067: hr_utility.set_message(801, 'HR_6847_ABS_DET_RANGE_CHECK');
2068: hr_utility.set_message_token('ABS_DATE_FROM', to_char(p_abs_from,'DD-MON-YYYY'));
2069: hr_utility.set_message_token('ABS_DATE_TO', to_char(p_abs_to,'DD-MON-YYYY'));
2070: close c5;
2071: hr_utility.raise_error;
2072: END IF;

Line 2069: hr_utility.set_message_token('ABS_DATE_TO', to_char(p_abs_to,'DD-MON-YYYY'));

2065: fetch c5 into l_exists;
2066: IF c5%notfound THEN
2067: hr_utility.set_message(801, 'HR_6847_ABS_DET_RANGE_CHECK');
2068: hr_utility.set_message_token('ABS_DATE_FROM', to_char(p_abs_from,'DD-MON-YYYY'));
2069: hr_utility.set_message_token('ABS_DATE_TO', to_char(p_abs_to,'DD-MON-YYYY'));
2070: close c5;
2071: hr_utility.raise_error;
2072: END IF;
2073: --

Line 2071: hr_utility.raise_error;

2067: hr_utility.set_message(801, 'HR_6847_ABS_DET_RANGE_CHECK');
2068: hr_utility.set_message_token('ABS_DATE_FROM', to_char(p_abs_from,'DD-MON-YYYY'));
2069: hr_utility.set_message_token('ABS_DATE_TO', to_char(p_abs_to,'DD-MON-YYYY'));
2070: close c5;
2071: hr_utility.raise_error;
2072: END IF;
2073: --
2074: close c5;
2075: --

Line 2095: hr_utility.set_location('per_absence_attendances_pkg.chk_proj',1);

2091: or p_proj_end is null);
2092: --
2093: begin
2094: --
2095: hr_utility.set_location('per_absence_attendances_pkg.chk_proj',1);
2096: --
2097: open c6;
2098: --
2099: fetch c6 into l_exists;

Line 2101: hr_utility.set_message(801, 'HR_6457_ABS_DET_DATES');

2097: open c6;
2098: --
2099: fetch c6 into l_exists;
2100: IF c6%notfound THEN
2101: hr_utility.set_message(801, 'HR_6457_ABS_DET_DATES');
2102: close c6;
2103: hr_utility.raise_error;
2104: END IF;
2105: --

Line 2103: hr_utility.raise_error;

2099: fetch c6 into l_exists;
2100: IF c6%notfound THEN
2101: hr_utility.set_message(801, 'HR_6457_ABS_DET_DATES');
2102: close c6;
2103: hr_utility.raise_error;
2104: END IF;
2105: --
2106: close c6;
2107: --

Line 2136: hr_utility.set_location('per_absence_attendances_pkg.chkab1',1);

2132: and t.date_end = p_dstart -1;
2133: --
2134: begin
2135: --
2136: hr_utility.set_location('per_absence_attendances_pkg.chkab1',1);
2137: --
2138: open c7;
2139: fetch c7 into l_exists;
2140: --

Line 2195: hr_utility.set_location('per_absence_attendances_pkg.chkab2',1);

2191: or (t.date_start between p_dstart and nvl(p_dend,p_eot)));
2192: --
2193: begin
2194: --
2195: hr_utility.set_location('per_absence_attendances_pkg.chkab2',1);
2196: --
2197: open c8;
2198: --
2199: fetch c8 into l_exists;

Line 2201: hr_utility.set_message(801, 'SSP_35217_DEF_ONLY_ONE_ABS');

2197: open c8;
2198: --
2199: fetch c8 into l_exists;
2200: IF c8%found THEN
2201: hr_utility.set_message(801, 'SSP_35217_DEF_ONLY_ONE_ABS');
2202: close c8;
2203: hr_utility.raise_error;
2204: END IF;
2205: --

Line 2203: hr_utility.raise_error;

2199: fetch c8 into l_exists;
2200: IF c8%found THEN
2201: hr_utility.set_message(801, 'SSP_35217_DEF_ONLY_ONE_ABS');
2202: close c8;
2203: hr_utility.raise_error;
2204: END IF;
2205: --
2206: close c8;
2207: --

Line 2208: hr_utility.set_location('per_absence_attendances_pkg.chkab2',2);

2204: END IF;
2205: --
2206: close c8;
2207: --
2208: hr_utility.set_location('per_absence_attendances_pkg.chkab2',2);
2209: --
2210: open c9;
2211: --
2212: fetch c9 into l_exists2;

Line 2214: hr_utility.set_message(801, 'SSP_35216_DEF_OVERLAP_ABS');

2210: open c9;
2211: --
2212: fetch c9 into l_exists2;
2213: IF c9%found THEN
2214: hr_utility.set_message(801, 'SSP_35216_DEF_OVERLAP_ABS');
2215: close c9;
2216: hr_utility.raise_error;
2217: END IF;
2218: --

Line 2216: hr_utility.raise_error;

2212: fetch c9 into l_exists2;
2213: IF c9%found THEN
2214: hr_utility.set_message(801, 'SSP_35216_DEF_OVERLAP_ABS');
2215: close c9;
2216: hr_utility.raise_error;
2217: END IF;
2218: --
2219: close c9;
2220: --

Line 2250: hr_utility.set_location('per_absence_attendances_pkg.chkab3',1);

2246: or (t.date_start between p_dstart and nvl(p_dend,p_eot)));
2247: --
2248: begin
2249: --
2250: hr_utility.set_location('per_absence_attendances_pkg.chkab3',1);
2251: --
2252: open c10;
2253: fetch c10 into l_exists;
2254: --

Line 2298: hr_utility.set_location('per_absence_attendances_pkg.b_elmnt_entry_dets',1);

2294: and p_sdstart between t.start_date and t.end_date;
2295: --
2296: begin
2297: --
2298: hr_utility.set_location('per_absence_attendances_pkg.b_elmnt_entry_dets',1);
2299: --
2300: open c11;
2301: --
2302: fetch c11 into p_e_entry_id,

Line 2324: hr_utility.set_location('per_absence_attendances_pkg.b_get_category',1);

2320: and lookup_code = p_abcat;
2321: --
2322: begin
2323: --
2324: hr_utility.set_location('per_absence_attendances_pkg.b_get_category',1);
2325: --
2326: open c12;
2327: --
2328: fetch c12 into p_mean;

Line 2356: hr_utility.set_location('per_absence_attendances_pkg.get_defaults',1);

2352: from sys.dual;
2353: --
2354: begin
2355: --
2356: hr_utility.set_location('per_absence_attendances_pkg.get_defaults',1);
2357: --
2358: open c14;
2359: --
2360: fetch c14 into l_hrs_def,

Line 2442: hr_utility.set_location('per_absence_attendances_pkg.get_ele_det1',1);

2438: and p_sess between lu1.effective_start_date and lu1.effective_end_date));
2439: --
2440: begin
2441: --
2442: hr_utility.set_location('per_absence_attendances_pkg.get_ele_det1',1);
2443: --
2444: open c15;
2445: --
2446: fetch c15 into p_ass_id,

Line 2475: hr_utility.set_location('per_absence_attendances_pkg.get_ele_det2',1);

2471: and pettl.language = userenv('LANG');
2472: --
2473: begin
2474: --
2475: hr_utility.set_location('per_absence_attendances_pkg.get_ele_det2',1);
2476: --
2477: open c16;
2478: --
2479: fetch c16 into p_dele_name;

Line 2503: hr_utility.set_location('per_absence_attendances_pkg.get_period_dates',1);

2499: and p_dstart between start_date and end_date;
2500: --
2501: begin
2502: --
2503: hr_utility.set_location('per_absence_attendances_pkg.get_period_dates',1);
2504: --
2505: open c18;
2506: --
2507: fetch c18 into p_prd_start,

Line 2537: hr_utility.set_location('per_absence_attendances_pkg.get_run_tot',1);

2533: and primary_flag = 'Y';
2534: --
2535: begin
2536: --
2537: hr_utility.set_location('per_absence_attendances_pkg.get_run_tot',1);
2538: --
2539: open c19;
2540: --
2541: fetch c19 into p_db_itm;

Line 2545: hr_utility.set_location('per_absence_attendances_pkg.get_run_tot',2);

2541: fetch c19 into p_db_itm;
2542: --
2543: close c19;
2544: --
2545: hr_utility.set_location('per_absence_attendances_pkg.get_run_tot',2);
2546: --
2547: open c20;
2548: --
2549: fetch c20 into p_ass_id;

Line 2590: hr_utility.set_location('per_absence_attendances_pkg.get_annual_bal',1);

2586: l_balance NUMBER := 0;
2587: --
2588: begin
2589: --
2590: hr_utility.set_location('per_absence_attendances_pkg.get_annual_bal',1);
2591: --
2592: open c19;
2593: --
2594: fetch c19 into l_balance;

Line 2656: hr_utility.set_location('per_absence_attendances_pkg.check_entitlement',1);

2652:
2653: --
2654: begin
2655: --
2656: hr_utility.set_location('per_absence_attendances_pkg.check_entitlement',1);
2657: --
2658: if p_days_requested is null and p_days_requested is null then
2659: --
2660: return true;

Line 2686: hr_utility.trace('ent= '||to_char(l_entitlement));

2682: ,P_Accrual_End_Date => l_accrual_end_date
2683: ,P_Accrual => l_accrual
2684: ,P_Net_Entitlement => l_entitlement
2685: );
2686: hr_utility.trace('ent= '||to_char(l_entitlement));
2687:
2688: if (l_units_of_measure = 'D' and l_entitlement < p_days_requested) THEN
2689: return FALSE;
2690: elsif (l_units_of_measure = 'H' and l_entitlement < p_hours_requested) THEN

Line 2726: hr_utility.set_location('per_absence_attendances_pkg.init_form',1);

2722: and date_start <= p_sess;
2723: --
2724: begin
2725: --
2726: hr_utility.set_location('per_absence_attendances_pkg.init_form',1);
2727: --
2728: open c21;
2729: --
2730: fetch c21 into p_form_type;

Line 2734: hr_utility.set_location('per_absence_attendances_pkg.init_form',2);

2730: fetch c21 into p_form_type;
2731: --
2732: close c21;
2733: --
2734: hr_utility.set_location('per_absence_attendances_pkg.init_form',2);
2735: --
2736: open c21b;
2737: --
2738: fetch c21b into p_dstart,

Line 2758: hr_utility.set_location('per_absence_attendances_pkg.ins_ok',1);

2754: and payroll_id is not null;
2755: --
2756: begin
2757: --
2758: hr_utility.set_location('per_absence_attendances_pkg.ins_ok',1);
2759: --
2760: open c22;
2761: --
2762: fetch c22 into p_test;

Line 2783: hr_utility.set_location('per_absence_attendances_pkg.get_occur',1);

2779: and person_id = p_per_id;
2780: --
2781: begin
2782: --
2783: hr_utility.set_location('per_absence_attendances_pkg.get_occur',1);
2784: --
2785: open c23;
2786: --
2787: fetch c23 into p_occur;

Line 2810: hr_utility.set_location('per_absence_attendances_pkg.chk_serv_period',1);

2806: pos.date_start AND nvl(pos.actual_termination_date,hr_general.end_of_time);
2807: --
2808: begin
2809: --
2810: hr_utility.set_location('per_absence_attendances_pkg.chk_serv_period',1);
2811: --
2812: open chk_periods;
2813: --
2814: l_ret_val := chk_periods%found;

Line 2877: hr_utility.set_location('per_absence_attendances_pkg.get_due_date',1);

2873: where h.maternity_id = p_maternity_id;
2874: c1_rec c1%ROWTYPE;
2875: BEGIN
2876: open c1;
2877: hr_utility.set_location('per_absence_attendances_pkg.get_due_date',1);
2878: fetch c1 into c1_rec;
2879: close c1;
2880: return(c1_rec.due_date);
2881: END get_due_date;

Line 2908: hr_utility.set_location('per_absence_attendances_pkg.get_due_date_2',1);

2904: and nvl(h.leave_type,'MA') = p_leave_type;
2905:
2906:
2907: BEGIN
2908: hr_utility.set_location('per_absence_attendances_pkg.get_due_date_2',1);
2909: counter:= 0;
2910: for c1_rec in c1 LOOP
2911: p_smp_due_date := c1_rec.due_date;
2912: counter := counter + 1;

Line 2949: hr_utility.set_location('per_absence_attendances_pkg.check_val_abs_start',1);

2945: --
2946: maternity csr_maternity%ROWTYPE;
2947: --
2948: BEGIN
2949: hr_utility.set_location('per_absence_attendances_pkg.check_val_abs_start',1);
2950: --
2951: -- This functionality only applies to Oracle SSP users
2952: if not ssp_ssp_pkg.ssp_is_installed then
2953: return;

Line 3008: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',1);

3004: maternity csr_maternity%ROWTYPE;
3005: l_dummy period_of_service%ROWTYPE;
3006: --
3007: BEGIN
3008: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',1);
3009: --
3010: -- This functionality only applies to Oracle SSP users
3011: if not ssp_ssp_pkg.ssp_is_installed then
3012: return;

Line 3018: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',2);

3014: --
3015:
3016: if p_maternity_id is not null then
3017: --
3018: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',2);
3019: open csr_maternity;
3020: fetch csr_maternity into maternity;
3021: if csr_maternity%found then
3022: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',3);

Line 3022: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',3);

3018: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',2);
3019: open csr_maternity;
3020: fetch csr_maternity into maternity;
3021: if csr_maternity%found then
3022: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',3);
3023: open period_of_service(maternity.person_id, maternity.continous_emp_date);
3024: fetch period_of_service into l_dummy;
3025:
3026: if period_of_service%notfound then

Line 3027: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',4);

3023: open period_of_service(maternity.person_id, maternity.continous_emp_date);
3024: fetch period_of_service into l_dummy;
3025:
3026: if period_of_service%notfound then
3027: hr_utility.set_location('per_absence_attendances_pkg.chk_apl_empl_continuity',4);
3028: close period_of_service;
3029: fnd_message.set_name('SSP', 'SSP_36810_APL_CONTINOUS_EMPL');
3030: fnd_message.raise_error;
3031: end if;

Line 3057: hr_utility.set_location('per_absence_attendances_pkg.chk_related_maernity',1);

3053: from ssp_maternities h
3054: where h.person_id = p_person_id;
3055: c1_rec c1%ROWTYPE;
3056: BEGIN
3057: hr_utility.set_location('per_absence_attendances_pkg.chk_related_maernity',1);
3058: open c1;
3059: fetch c1 into c1_rec;
3060: if c1%NOTFOUND then
3061: fnd_message.set_name('SSP','SSP_36073_PREG_RELATED_ILLNESS');

Line 3088: hr_utility.set_location('per_absence_attendances_pkg.chk_evd_before_del',1);

3084: where h.absence_attendance_id = p_absence_attendance_id
3085: and h.medical_type = p_medical_type;
3086: c1_rec c1%ROWTYPE;
3087: BEGIN
3088: hr_utility.set_location('per_absence_attendances_pkg.chk_evd_before_del',1);
3089: open c1;
3090: fetch c1 into c1_rec;
3091: if c1%FOUND then
3092: fnd_message.set_name('SSP','SSP_35033_ATTACHED_SICK_NOTE');

Line 3117: hr_utility.set_location

3113:
3114: l_element_details ssp_SMP_pkg.csr_SMP_element_details%rowtype;
3115:
3116: BEGIN
3117: hr_utility.set_location
3118: ('per_absence_attendances_pkg.late_abs_notification',1);
3119: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date,
3120: p_element_name);
3121: fetch ssp_SMP_pkg.csr_SMP_element_details into l_element_details;