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 150: hr_utility.set_location('Entering:'||l_proc, 5);

146: l_proc varchar2(72) := g_package||'constraint_error';
147: --
148: Begin
149: --
150: hr_utility.set_location('Entering:'||l_proc, 5);
151: --
152: If (p_constraint_name = 'PER_ABSENCE_ATTENDANCES_FK4') Then
153: --
154: -- The linked_absence_id does not refer to a valid absence_attendance_id.

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

228: End If;
229: --
230: fnd_message.raise_error;
231: --
232: hr_utility.set_location(' Leaving:'||l_proc, 10);
233: --
234: End constraint_error;
235: --
236: -- ---------------------------------------------------------------------------

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

276: l_proc varchar2 (72) := g_package||'MPP_update_mode';
277: --
278: begin
279: --
280: hr_utility.set_location ('Entering:'||l_proc,1);
281: --
282: if p_update_mode = 1
283: then
284: g_mpp_update_mode := TRUE;

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

285: else
286: g_mpp_update_mode := FALSE;
287: end if;
288: --
289: hr_utility.set_location ('Leaving :'||l_proc,100);
290: --
291: end MPP_update_mode;
292: --
293: ------------------------------------------------------------------------------

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

316: l_nos_absences number;
317: --
318: begin
319: --
320: hr_utility.set_location ('Entering:'||l_proc,1);
321: --
322: if g_mpp_update_mode = TRUE
323: then
324: --

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

354: --
355: g_mpp_updated_date := l_default_MPP_start_date;
356: end if;
357: --
358: hr_utility.set_location ('Leaving :'||l_proc,100);
359: --
360: end reset_MPP_start_date_on_delete;
361: --
362: --------------------------------------------------------------------------------

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

404: l_mpp_updated_date date := g_mpp_updated_date;
405: --
406: begin
407: --
408: hr_utility.set_location ('Entering:'||l_proc,1);
409: --
410: if p_maternity_id is not null
411: then
412: --

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

504: end if;
505: end if;
506: end if;
507: --
508: hr_utility.set_location ('Leaving :'||l_proc,100);
509: --
510: end default_MPP_start_date;
511: --
512: procedure populate_ben_absence_rec

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

524: l_proc varchar2(72) := g_package||'populate_ben_absence_rec';
525:
526: begin
527:
528: hr_utility.set_location('Entering: '|| l_proc, 10);
529:
530: if (p_rec_type = 'O') then
531: l_absence_rec := p_old_rec;
532: else

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

616: p_ben_rec.abs_information28 := l_absence_rec.abs_information28;
617: p_ben_rec.abs_information29 := l_absence_rec.abs_information29;
618: p_ben_rec.abs_information30 := l_absence_rec.abs_information30;
619:
620: hr_utility.set_location('Leaving: '|| l_proc, 15);
621: end;
622: --------------------------------------------------------------------------------
623: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
624: X_Absence_Attendance_Id IN OUT NOCOPY NUMBER,

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

1071: OPEN C;
1072: FETCH C INTO Recinfo;
1073: if (C%NOTFOUND) then
1074: CLOSE C;
1075: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1076: hr_utility.set_message_token('PROCEDURE', 'lock_row');
1077: hr_utility.set_message_token('STEP', '1');
1078: hr_utility.raise_error;
1079: end if;

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

1072: FETCH C INTO Recinfo;
1073: if (C%NOTFOUND) then
1074: CLOSE C;
1075: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1076: hr_utility.set_message_token('PROCEDURE', 'lock_row');
1077: hr_utility.set_message_token('STEP', '1');
1078: hr_utility.raise_error;
1079: end if;
1080: CLOSE C;

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

1073: if (C%NOTFOUND) then
1074: CLOSE C;
1075: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1076: hr_utility.set_message_token('PROCEDURE', 'lock_row');
1077: hr_utility.set_message_token('STEP', '1');
1078: hr_utility.raise_error;
1079: end if;
1080: CLOSE C;
1081:

Line 1078: hr_utility.raise_error;

1074: CLOSE C;
1075: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1076: hr_utility.set_message_token('PROCEDURE', 'lock_row');
1077: hr_utility.set_message_token('STEP', '1');
1078: hr_utility.raise_error;
1079: end if;
1080: CLOSE C;
1081:
1082: recinfo.comments := rtrim(recinfo.comments);

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

1745: DELETE FROM per_absence_attendances
1746: WHERE rowid = chartorowid(X_Rowid);
1747:
1748: if (SQL%NOTFOUND) then
1749: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1750: hr_utility.set_message_token('PROCEDURE', 'delete_row');
1751: hr_utility.set_message_token('STEP', '1');
1752: hr_utility.raise_error;
1753: end if;

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

1746: WHERE rowid = chartorowid(X_Rowid);
1747:
1748: if (SQL%NOTFOUND) then
1749: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1750: hr_utility.set_message_token('PROCEDURE', 'delete_row');
1751: hr_utility.set_message_token('STEP', '1');
1752: hr_utility.raise_error;
1753: end if;
1754:

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

1747:
1748: if (SQL%NOTFOUND) then
1749: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1750: hr_utility.set_message_token('PROCEDURE', 'delete_row');
1751: hr_utility.set_message_token('STEP', '1');
1752: hr_utility.raise_error;
1753: end if;
1754:
1755: populate_ben_absence_rec

Line 1752: hr_utility.raise_error;

1748: if (SQL%NOTFOUND) then
1749: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1750: hr_utility.set_message_token('PROCEDURE', 'delete_row');
1751: hr_utility.set_message_token('STEP', '1');
1752: hr_utility.raise_error;
1753: end if;
1754:
1755: populate_ben_absence_rec
1756: (p_absence_attendance_id => l_absence.absence_attendance_id,

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

1802: and pp.current_employee_flag = 'Y';
1803: --
1804: begin
1805: --
1806: hr_utility.set_location('per_absence_attendances_pkg.b_check_auth_de',1);
1807: --
1808: open c1;
1809: --
1810: fetch c1 into l_exists;

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

1808: open c1;
1809: --
1810: fetch c1 into l_exists;
1811: IF c1%notfound THEN
1812: hr_utility.set_message(801, 'PER_7886_EMP_ABS_DURATION');
1813: close c1;
1814: hr_utility.raise_error;
1815: END IF;
1816: --

Line 1814: hr_utility.raise_error;

1810: fetch c1 into l_exists;
1811: IF c1%notfound THEN
1812: hr_utility.set_message(801, 'PER_7886_EMP_ABS_DURATION');
1813: close c1;
1814: hr_utility.raise_error;
1815: END IF;
1816: --
1817: close c1;
1818: --

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

1848: and pp.current_employee_flag = 'Y';
1849: --
1850: begin
1851: --
1852: hr_utility.set_location('per_absence_attendances_pkg.b_check_rep_de',1);
1853: --
1854: open c3;
1855: --
1856: fetch c3 into l_exists;

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

1854: open c3;
1855: --
1856: fetch c3 into l_exists;
1857: IF c3%notfound THEN
1858: hr_utility.set_message(801, 'PER_7887_EMP_ABS_DURATION');
1859: close c3;
1860: hr_utility.raise_error;
1861: END IF;
1862: --

Line 1860: hr_utility.raise_error;

1856: fetch c3 into l_exists;
1857: IF c3%notfound THEN
1858: hr_utility.set_message(801, 'PER_7887_EMP_ABS_DURATION');
1859: close c3;
1860: hr_utility.raise_error;
1861: END IF;
1862: --
1863: close c3;
1864: --

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

1880: and p.person_id = p_rep_per;
1881: --
1882: begin
1883: --
1884: hr_utility.set_location('per_absence_attendances_pkg.b_check_for_termination',1);
1885: --
1886: open c2;
1887: --
1888: l_ret_val := c2%found;

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

1918: and pp.replacement_required_flag = 'Y';
1919: --
1920: begin
1921: --
1922: hr_utility.set_location('per_absence_attendances_pkg.chk_rep_req',1);
1923: --
1924: open c4;
1925: fetch c4 into l_exists;
1926: --

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

1953: or p_dend is null);
1954: --
1955: begin
1956: --
1957: hr_utility.set_location('per_absence_attendances_pkg.chk_type',1);
1958: --
1959: open c5;
1960: --
1961: fetch c5 into l_exists;

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

1959: open c5;
1960: --
1961: fetch c5 into l_exists;
1962: IF c5%notfound THEN
1963: hr_utility.set_message(801, 'HR_6847_ABS_DET_RANGE_CHECK');
1964: hr_utility.set_message_token('ABS_DATE_FROM', to_char(p_abs_from,'DD-MON-YYYY'));
1965: hr_utility.set_message_token('ABS_DATE_TO', to_char(p_abs_to,'DD-MON-YYYY'));
1966: close c5;
1967: hr_utility.raise_error;

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

1960: --
1961: fetch c5 into l_exists;
1962: IF c5%notfound THEN
1963: hr_utility.set_message(801, 'HR_6847_ABS_DET_RANGE_CHECK');
1964: hr_utility.set_message_token('ABS_DATE_FROM', to_char(p_abs_from,'DD-MON-YYYY'));
1965: hr_utility.set_message_token('ABS_DATE_TO', to_char(p_abs_to,'DD-MON-YYYY'));
1966: close c5;
1967: hr_utility.raise_error;
1968: END IF;

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

1961: fetch c5 into l_exists;
1962: IF c5%notfound THEN
1963: hr_utility.set_message(801, 'HR_6847_ABS_DET_RANGE_CHECK');
1964: hr_utility.set_message_token('ABS_DATE_FROM', to_char(p_abs_from,'DD-MON-YYYY'));
1965: hr_utility.set_message_token('ABS_DATE_TO', to_char(p_abs_to,'DD-MON-YYYY'));
1966: close c5;
1967: hr_utility.raise_error;
1968: END IF;
1969: --

Line 1967: hr_utility.raise_error;

1963: hr_utility.set_message(801, 'HR_6847_ABS_DET_RANGE_CHECK');
1964: hr_utility.set_message_token('ABS_DATE_FROM', to_char(p_abs_from,'DD-MON-YYYY'));
1965: hr_utility.set_message_token('ABS_DATE_TO', to_char(p_abs_to,'DD-MON-YYYY'));
1966: close c5;
1967: hr_utility.raise_error;
1968: END IF;
1969: --
1970: close c5;
1971: --

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

1987: or p_proj_end is null);
1988: --
1989: begin
1990: --
1991: hr_utility.set_location('per_absence_attendances_pkg.chk_proj',1);
1992: --
1993: open c6;
1994: --
1995: fetch c6 into l_exists;

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

1993: open c6;
1994: --
1995: fetch c6 into l_exists;
1996: IF c6%notfound THEN
1997: hr_utility.set_message(801, 'HR_6457_ABS_DET_DATES');
1998: close c6;
1999: hr_utility.raise_error;
2000: END IF;
2001: --

Line 1999: hr_utility.raise_error;

1995: fetch c6 into l_exists;
1996: IF c6%notfound THEN
1997: hr_utility.set_message(801, 'HR_6457_ABS_DET_DATES');
1998: close c6;
1999: hr_utility.raise_error;
2000: END IF;
2001: --
2002: close c6;
2003: --

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

2028: and t.date_end = p_dstart -1;
2029: --
2030: begin
2031: --
2032: hr_utility.set_location('per_absence_attendances_pkg.chkab1',1);
2033: --
2034: open c7;
2035: fetch c7 into l_exists;
2036: --

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

2087: or (t.date_start between p_dstart and nvl(p_dend,p_eot)));
2088: --
2089: begin
2090: --
2091: hr_utility.set_location('per_absence_attendances_pkg.chkab2',1);
2092: --
2093: open c8;
2094: --
2095: fetch c8 into l_exists;

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

2093: open c8;
2094: --
2095: fetch c8 into l_exists;
2096: IF c8%found THEN
2097: hr_utility.set_message(801, 'SSP_35217_DEF_ONLY_ONE_ABS');
2098: close c8;
2099: hr_utility.raise_error;
2100: END IF;
2101: --

Line 2099: hr_utility.raise_error;

2095: fetch c8 into l_exists;
2096: IF c8%found THEN
2097: hr_utility.set_message(801, 'SSP_35217_DEF_ONLY_ONE_ABS');
2098: close c8;
2099: hr_utility.raise_error;
2100: END IF;
2101: --
2102: close c8;
2103: --

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

2100: END IF;
2101: --
2102: close c8;
2103: --
2104: hr_utility.set_location('per_absence_attendances_pkg.chkab2',2);
2105: --
2106: open c9;
2107: --
2108: fetch c9 into l_exists2;

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

2106: open c9;
2107: --
2108: fetch c9 into l_exists2;
2109: IF c9%found THEN
2110: hr_utility.set_message(801, 'SSP_35216_DEF_OVERLAP_ABS');
2111: close c9;
2112: hr_utility.raise_error;
2113: END IF;
2114: --

Line 2112: hr_utility.raise_error;

2108: fetch c9 into l_exists2;
2109: IF c9%found THEN
2110: hr_utility.set_message(801, 'SSP_35216_DEF_OVERLAP_ABS');
2111: close c9;
2112: hr_utility.raise_error;
2113: END IF;
2114: --
2115: close c9;
2116: --

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

2142: or (t.date_start between p_dstart and nvl(p_dend,p_eot)));
2143: --
2144: begin
2145: --
2146: hr_utility.set_location('per_absence_attendances_pkg.chkab3',1);
2147: --
2148: open c10;
2149: fetch c10 into l_exists;
2150: --

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

2190: and p_sdstart between t.start_date and t.end_date;
2191: --
2192: begin
2193: --
2194: hr_utility.set_location('per_absence_attendances_pkg.b_elmnt_entry_dets',1);
2195: --
2196: open c11;
2197: --
2198: fetch c11 into p_e_entry_id,

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

2216: and lookup_code = p_abcat;
2217: --
2218: begin
2219: --
2220: hr_utility.set_location('per_absence_attendances_pkg.b_get_category',1);
2221: --
2222: open c12;
2223: --
2224: fetch c12 into p_mean;

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

2248: from sys.dual;
2249: --
2250: begin
2251: --
2252: hr_utility.set_location('per_absence_attendances_pkg.get_defaults',1);
2253: --
2254: open c14;
2255: --
2256: fetch c14 into l_hrs_def,

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

2334: and p_sess between lu1.effective_start_date and lu1.effective_end_date));
2335: --
2336: begin
2337: --
2338: hr_utility.set_location('per_absence_attendances_pkg.get_ele_det1',1);
2339: --
2340: open c15;
2341: --
2342: fetch c15 into p_ass_id,

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

2367: and pettl.language = userenv('LANG');
2368: --
2369: begin
2370: --
2371: hr_utility.set_location('per_absence_attendances_pkg.get_ele_det2',1);
2372: --
2373: open c16;
2374: --
2375: fetch c16 into p_dele_name;

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

2395: and p_dstart between start_date and end_date;
2396: --
2397: begin
2398: --
2399: hr_utility.set_location('per_absence_attendances_pkg.get_period_dates',1);
2400: --
2401: open c18;
2402: --
2403: fetch c18 into p_prd_start,

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

2429: and primary_flag = 'Y';
2430: --
2431: begin
2432: --
2433: hr_utility.set_location('per_absence_attendances_pkg.get_run_tot',1);
2434: --
2435: open c19;
2436: --
2437: fetch c19 into p_db_itm;

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

2437: fetch c19 into p_db_itm;
2438: --
2439: close c19;
2440: --
2441: hr_utility.set_location('per_absence_attendances_pkg.get_run_tot',2);
2442: --
2443: open c20;
2444: --
2445: fetch c20 into p_ass_id;

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

2482: l_balance NUMBER := 0;
2483: --
2484: begin
2485: --
2486: hr_utility.set_location('per_absence_attendances_pkg.get_annual_bal',1);
2487: --
2488: open c19;
2489: --
2490: fetch c19 into l_balance;

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

2547:
2548: --
2549: begin
2550: --
2551: hr_utility.set_location('per_absence_attendances_pkg.check_entitlement',1);
2552: --
2553: if p_days_requested is null and p_days_requested is null then
2554: --
2555: return true;

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

2577: ,P_Accrual_End_Date => l_accrual_end_date
2578: ,P_Accrual => l_accrual
2579: ,P_Net_Entitlement => l_entitlement
2580: );
2581: hr_utility.trace('ent= '||to_char(l_entitlement));
2582:
2583: if (l_units_of_measure = 'D' and l_entitlement < p_days_requested) THEN
2584: return FALSE;
2585: elsif (l_units_of_measure = 'H' and l_entitlement < p_hours_requested) THEN

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

2617: and date_start <= p_sess;
2618: --
2619: begin
2620: --
2621: hr_utility.set_location('per_absence_attendances_pkg.init_form',1);
2622: --
2623: open c21;
2624: --
2625: fetch c21 into p_form_type;

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

2625: fetch c21 into p_form_type;
2626: --
2627: close c21;
2628: --
2629: hr_utility.set_location('per_absence_attendances_pkg.init_form',2);
2630: --
2631: open c21b;
2632: --
2633: fetch c21b into p_dstart,

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

2649: and payroll_id is not null;
2650: --
2651: begin
2652: --
2653: hr_utility.set_location('per_absence_attendances_pkg.ins_ok',1);
2654: --
2655: open c22;
2656: --
2657: fetch c22 into p_test;

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

2674: and person_id = p_per_id;
2675: --
2676: begin
2677: --
2678: hr_utility.set_location('per_absence_attendances_pkg.get_occur',1);
2679: --
2680: open c23;
2681: --
2682: fetch c23 into p_occur;

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

2701: pos.date_start AND nvl(pos.actual_termination_date,hr_general.end_of_time);
2702: --
2703: begin
2704: --
2705: hr_utility.set_location('per_absence_attendances_pkg.chk_serv_period',1);
2706: --
2707: open chk_periods;
2708: --
2709: l_ret_val := chk_periods%found;

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

2768: where h.maternity_id = p_maternity_id;
2769: c1_rec c1%ROWTYPE;
2770: BEGIN
2771: open c1;
2772: hr_utility.set_location('per_absence_attendances_pkg.get_due_date',1);
2773: fetch c1 into c1_rec;
2774: close c1;
2775: return(c1_rec.due_date);
2776: END get_due_date;

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

2799: and nvl(h.leave_type,'MA') = p_leave_type;
2800:
2801:
2802: BEGIN
2803: hr_utility.set_location('per_absence_attendances_pkg.get_due_date_2',1);
2804: counter:= 0;
2805: for c1_rec in c1 LOOP
2806: p_smp_due_date := c1_rec.due_date;
2807: counter := counter + 1;

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

2840: --
2841: maternity csr_maternity%ROWTYPE;
2842: --
2843: BEGIN
2844: hr_utility.set_location('per_absence_attendances_pkg.check_val_abs_start',1);
2845: --
2846: -- This functionality only applies to Oracle SSP users
2847: if not ssp_ssp_pkg.ssp_is_installed then
2848: return;

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

2881: from ssp_maternities h
2882: where h.person_id = p_person_id;
2883: c1_rec c1%ROWTYPE;
2884: BEGIN
2885: hr_utility.set_location('per_absence_attendances_pkg.chk_related_maernity',1);
2886: open c1;
2887: fetch c1 into c1_rec;
2888: if c1%NOTFOUND then
2889: fnd_message.set_name('SSP','SSP_36073_PREG_RELATED_ILLNESS');

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

2912: where h.absence_attendance_id = p_absence_attendance_id
2913: and h.medical_type = p_medical_type;
2914: c1_rec c1%ROWTYPE;
2915: BEGIN
2916: hr_utility.set_location('per_absence_attendances_pkg.chk_evd_before_del',1);
2917: open c1;
2918: fetch c1 into c1_rec;
2919: if c1%FOUND then
2920: fnd_message.set_name('SSP','SSP_35033_ATTACHED_SICK_NOTE');

Line 2945: hr_utility.set_location

2941:
2942: l_element_details ssp_SMP_pkg.csr_SMP_element_details%rowtype;
2943:
2944: BEGIN
2945: hr_utility.set_location
2946: ('per_absence_attendances_pkg.late_abs_notification',1);
2947: open ssp_SMP_pkg.csr_SMP_element_details(p_effective_date,
2948: p_element_name);
2949: fetch ssp_SMP_pkg.csr_SMP_element_details into l_element_details;