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 PER_ABSENCE_ATTENDANCES

Line 1: package body PER_ABSENCE_ATTENDANCES_PKG as

1: package body PER_ABSENCE_ATTENDANCES_PKG as
2: /* $Header: peaba01t.pkb 120.5.12020000.2 2012/07/05 00:25:27 amnaraya ship $ */
3:
4: /* Date Name Release Description
5: ---- ---- ------- -----------

Line 26: hardcoded 'PER_ABSENCE_ATTENDANCES_PKG';

22: not be delivered until SSP delivery. These
23: commented out bits should be uncommented at that
24: time.
25: 13-OCT-95 J Thuringer Replaced 'PACKAGE_NAME' variable by
26: hardcoded 'PER_ABSENCE_ATTENDANCES_PKG';
27: removed error checking code from end of script
28: 17-OCT-95 F Assadi Added a new function get_anuual_bal to work
29: out the absence taken from the year.
30: is_emp_entitled function was added. This

Line 123: 115.26 06-NOV-2003 3156665 kjagadee Modified per_absence_attendances_pkg.get_defaults

119: 115.24 23-JUL-2003 2829746 ablinko amendments for SAP/SPP
120: 115.25 25-Aug-2003 3111653 skota added to_number() for explicit
121: conversion. Seems implicit conversion
122: is not taking place in 10G
123: 115.26 06-NOV-2003 3156665 kjagadee Modified per_absence_attendances_pkg.get_defaults
124: procedure to calculate the drfault hours in a day
125: as 24 hours.
126: 115.27 29-JAN-2004 3387265 smparame Modified inti_form procedure.
127: upper(formula_type_name) is changed to formula

Line 146: g_package varchar2(33) := ' per_absence_attendances_pkg.';

142: 120.0.12000000.6 05-Jan-2011 13486124 npannamp Added check for Adjusted Service date in procedure
143: chk_apl_empl_continuity.
144: -------+------------+---------+----------+------------------------------------------------
145: */
146: g_package varchar2(33) := ' per_absence_attendances_pkg.';
147: -- Global package name
148:
149: --
150: ------------------------------------------------------------------------------

Line 162: If (p_constraint_name = 'PER_ABSENCE_ATTENDANCES_FK4') Then

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.
165: --
166: fnd_message.set_name('SSP', 'SSP_35060_SSP_ABS_FK2');

Line 168: ElsIf (p_constraint_name = 'PER_ABSENCE_ATTENDANCES_FK5') Then

164: -- The linked_absence_id does not refer to a valid absence_attendance_id.
165: --
166: fnd_message.set_name('SSP', 'SSP_35060_SSP_ABS_FK2');
167: --
168: ElsIf (p_constraint_name = 'PER_ABSENCE_ATTENDANCES_FK5') Then
169: --
170: -- The maternity_id is not valid.
171: --
172: fnd_message.set_name('SSP', 'SSP_35061_SSP_ABS_FK1');

Line 261: from per_absence_attendances

257: p_nos_absences in out nocopy number) is
258: --
259: cursor c2 is
260: select date_start, rowid
261: from per_absence_attendances
262: where maternity_id = p_maternity_id;
263: c2_rec c2%ROWTYPE;
264: --
265: begin

Line 619: p_old_rec in per_absence_attendances%rowtype,

615: --
616: procedure populate_ben_absence_rec
617: (p_absence_attendance_id in number,
618: p_rec_type in varchar2,
619: p_old_rec in per_absence_attendances%rowtype,
620: p_ben_rec out nocopy ben_abs_ler.g_abs_ler_rec) is
621:
622: cursor c_current_absence is
623: select *

Line 624: from per_absence_attendances

620: p_ben_rec out nocopy ben_abs_ler.g_abs_ler_rec) is
621:
622: cursor c_current_absence is
623: select *
624: from per_absence_attendances
625: where absence_attendance_id = p_absence_attendance_id;
626: --
627: l_absence_rec per_absence_attendances%rowtype;
628: l_proc varchar2(72) := g_package||'populate_ben_absence_rec';

Line 627: l_absence_rec per_absence_attendances%rowtype;

623: select *
624: from per_absence_attendances
625: where absence_attendance_id = p_absence_attendance_id;
626: --
627: l_absence_rec per_absence_attendances%rowtype;
628: l_proc varchar2(72) := g_package||'populate_ben_absence_rec';
629:
630: begin
631:

Line 811: CURSOR C IS SELECT rowid FROM per_absence_attendances

807: X_Abs_Information28 VARCHAR2,
808: X_Abs_Information29 VARCHAR2,
809: X_Abs_Information30 VARCHAR2
810: ) IS
811: CURSOR C IS SELECT rowid FROM per_absence_attendances
812: WHERE absence_attendance_id = X_absence_attendance_id;
813:
814: CURSOR C2 IS SELECT per_absence_attendances_s.nextval FROM sys.dual;
815:

Line 814: CURSOR C2 IS SELECT per_absence_attendances_s.nextval FROM sys.dual;

810: ) IS
811: CURSOR C IS SELECT rowid FROM per_absence_attendances
812: WHERE absence_attendance_id = X_absence_attendance_id;
813:
814: CURSOR C2 IS SELECT per_absence_attendances_s.nextval FROM sys.dual;
815:
816: cursor csr_later_sickness is
817: select 1
818: from per_absence_attendances

Line 818: from per_absence_attendances

814: CURSOR C2 IS SELECT per_absence_attendances_s.nextval FROM sys.dual;
815:
816: cursor csr_later_sickness is
817: select 1
818: from per_absence_attendances
819: where person_id = X_person_id
820: and sickness_start_date is not null
821: and sickness_start_date > X_sickness_start_date;
822: --

Line 867: INSERT INTO per_absence_attendances(

863: OPEN C2;
864: FETCH C2 INTO X_absence_attendance_id;
865: CLOSE C2;
866: end if;
867: INSERT INTO per_absence_attendances(
868: absence_attendance_id,
869: business_group_id,
870: absence_attendance_type_id,
871: abs_attendance_reason_id,

Line 1068: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

1064: --
1065: Exception
1066: When hr_api.check_integrity_violated Then
1067: -- A check constraint has been violated
1068: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1069: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1070: When hr_api.parent_integrity_violated Then
1071: -- Parent integrity has been violated
1072: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

Line 1072: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

1068: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1069: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1070: When hr_api.parent_integrity_violated Then
1071: -- Parent integrity has been violated
1072: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1073: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1074: When hr_api.unique_integrity_violated Then
1075: -- Unique integrity has been violated
1076: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

Line 1076: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

1072: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1073: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1074: When hr_api.unique_integrity_violated Then
1075: -- Unique integrity has been violated
1076: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1077: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1078: When Others Then
1079: Raise;
1080: END Insert_Row;

Line 1169: FROM per_absence_attendances

1165: X_Abs_Information30 VARCHAR2
1166: ) IS
1167: CURSOR C IS
1168: SELECT *
1169: FROM per_absence_attendances
1170: WHERE rowid = chartorowid(X_Rowid)
1171: FOR UPDATE of absence_attendance_id NOWAIT;
1172:
1173: Recinfo C%ROWTYPE;

Line 1602: from per_absence_attendances

1598: ) IS
1599:
1600: cursor csr_absence is
1601: select *
1602: from per_absence_attendances
1603: where absence_attendance_id = X_absence_attendance_id;
1604: --
1605: l_absence csr_absence%rowtype;
1606: --

Line 1612: from per_absence_attendances

1608: -- Start of BUGFIX for WWBUG 1408379
1609: --
1610: cursor c1 is
1611: select *
1612: from per_absence_attendances
1613: where rowid = chartorowid(X_rowid);
1614: --
1615: l_c1 c1%rowtype;
1616: l_rows_found boolean := false;

Line 1656: UPDATE per_absence_attendances

1652: close c1;
1653: --
1654: -- End of BUGFIX for WWBUG 1408379
1655: --
1656: UPDATE per_absence_attendances
1657: SET
1658: absence_attendance_id = X_Absence_Attendance_Id,
1659: business_group_id = X_Business_Group_Id,
1660: absence_attendance_type_id = X_Absence_Attendance_Type_Id,

Line 1802: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

1798: --
1799: Exception
1800: When hr_api.check_integrity_violated Then
1801: -- A check constraint has been violated
1802: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1803: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1804: When hr_api.parent_integrity_violated Then
1805: -- Parent integrity has been violated
1806: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

Line 1806: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

1802: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1803: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1804: When hr_api.parent_integrity_violated Then
1805: -- Parent integrity has been violated
1806: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1807: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1808: When hr_api.unique_integrity_violated Then
1809: -- Unique integrity has been violated
1810: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

Line 1810: PER_ABSENCE_ATTENDANCES_PKG.constraint_error

1806: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1807: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1808: When hr_api.unique_integrity_violated Then
1809: -- Unique integrity has been violated
1810: PER_ABSENCE_ATTENDANCES_PKG.constraint_error
1811: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1812: When Others Then
1813: Raise;
1814: END Update_Row;

Line 1822: from per_absence_attendances

1818: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
1819: --
1820: cursor csr_current_absence is
1821: select *
1822: from per_absence_attendances
1823: where rowid = X_ROWID;
1824: --
1825: l_absence csr_current_absence%rowtype;
1826: l_old ben_abs_ler.g_abs_ler_rec;

Line 1849: DELETE FROM per_absence_attendances

1845: p_absence_attendance_id => l_absence.absence_attendance_id);
1846: --
1847: end if;
1848: --
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');

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 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 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 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 2122: from per_absence_attendances t,

2118: l_ret_val BOOLEAN;
2119:
2120: cursor c7 is
2121: select 1
2122: from per_absence_attendances t,
2123: per_absence_attendance_types a,
2124: per_absence_attendance_types b
2125: where (p_abat_id is null
2126: or (p_abat_id is not null and p_abat_id <> t.absence_attendance_id))

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 2165: from per_absence_attendances t,

2161: l_exists2 VARCHAR2(1);
2162:
2163: cursor c8 is
2164: select 'x'
2165: from per_absence_attendances t,
2166: per_absence_attendance_types a,
2167: per_absence_attendance_types b
2168: where (p_abat_id is null
2169: or (p_abat_id is not null and p_abat_id <> t.absence_attendance_id))

Line 2180: from per_absence_attendances t,

2176: and t.date_end is null;
2177: --
2178: cursor c9 is
2179: select 'x'
2180: from per_absence_attendances t,
2181: per_absence_attendance_types a,
2182: per_absence_attendance_types b
2183: where (p_abat_id is null
2184: or (p_abat_id is not null and p_abat_id <> t.absence_attendance_id))

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 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 2237: from per_absence_attendances t,

2233: l_ret_val BOOLEAN;
2234:
2235: cursor c10 is
2236: select 1
2237: from per_absence_attendances t,
2238: per_absence_attendance_types a,
2239: per_absence_attendance_types b
2240: where (p_abat_id is null
2241: or (p_abat_id is not null and p_abat_id <> t.absence_attendance_id))

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 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 2776: from per_absence_attendances

2772: p_occur IN OUT NOCOPY NUMBER) is
2773:
2774: cursor c23 is
2775: select nvl(max(occurrence),0) + 1
2776: from per_absence_attendances
2777: where business_group_id + 0 = p_bgroup_id
2778: and absence_attendance_type_id = p_abat_type
2779: and person_id = p_per_id;
2780: --

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 3118: ('per_absence_attendances_pkg.late_abs_notification',1);

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;
3122: close ssp_SMP_pkg.csr_SMP_element_details;

Line 3134: end PER_ABSENCE_ATTENDANCES_PKG;

3130: return(FALSE);
3131: end if;
3132: END late_abs_notification;
3133:
3134: end PER_ABSENCE_ATTENDANCES_PKG;