DBA Data[Home] [Help]

APPS.BEN_ELIG_PER_ELC_CHC_API dependencies on HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: beepeapi.pkb 120.1.12020000.2 2012/07/03 12:10:57 amnaraya ship $ */
3: --
4: -- Package Variables
5: --
6: g_debug boolean := hr_utility.debug_enabled;
7: g_package varchar2(33) := ' ben_elig_per_elc_chc_api.';
8: --
9: -- ----------------------------------------------------------------------------
10: -- |----------------------< CreOrSel_pil_elctbl_chc_popl >--------------------|

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

207: l_reinstate_ovrdn_cd varchar2(30);
208: l_reopen_le_on_reprocess varchar2(30);
209: --
210: begin
211: hr_utility.set_location('Entering:'|| l_proc, 10);
212: --
213: if g_debug then
214: l_proc := g_package||'CreOrSel_pil_elctbl_chc_popl';
215: --

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

212: --
213: if g_debug then
214: l_proc := g_package||'CreOrSel_pil_elctbl_chc_popl';
215: --
216: hr_utility.set_location('Entering:'|| l_proc, 10);
217: hr_utility.set_location(' p_pgm_id '||p_pgm_id,120);
218: hr_utility.set_location(' p_pl_id '||p_pl_id,120);
219: hr_utility.set_location(' p_lee_rsn_id '||p_lee_rsn_id,120);
220: hr_utility.set_location(' p_enrt_perd_id '||p_enrt_perd_id,120);

Line 217: hr_utility.set_location(' p_pgm_id '||p_pgm_id,120);

213: if g_debug then
214: l_proc := g_package||'CreOrSel_pil_elctbl_chc_popl';
215: --
216: hr_utility.set_location('Entering:'|| l_proc, 10);
217: hr_utility.set_location(' p_pgm_id '||p_pgm_id,120);
218: hr_utility.set_location(' p_pl_id '||p_pl_id,120);
219: hr_utility.set_location(' p_lee_rsn_id '||p_lee_rsn_id,120);
220: hr_utility.set_location(' p_enrt_perd_id '||p_enrt_perd_id,120);
221: --

Line 218: hr_utility.set_location(' p_pl_id '||p_pl_id,120);

214: l_proc := g_package||'CreOrSel_pil_elctbl_chc_popl';
215: --
216: hr_utility.set_location('Entering:'|| l_proc, 10);
217: hr_utility.set_location(' p_pgm_id '||p_pgm_id,120);
218: hr_utility.set_location(' p_pl_id '||p_pl_id,120);
219: hr_utility.set_location(' p_lee_rsn_id '||p_lee_rsn_id,120);
220: hr_utility.set_location(' p_enrt_perd_id '||p_enrt_perd_id,120);
221: --
222: end if;

Line 219: hr_utility.set_location(' p_lee_rsn_id '||p_lee_rsn_id,120);

215: --
216: hr_utility.set_location('Entering:'|| l_proc, 10);
217: hr_utility.set_location(' p_pgm_id '||p_pgm_id,120);
218: hr_utility.set_location(' p_pl_id '||p_pl_id,120);
219: hr_utility.set_location(' p_lee_rsn_id '||p_lee_rsn_id,120);
220: hr_utility.set_location(' p_enrt_perd_id '||p_enrt_perd_id,120);
221: --
222: end if;
223: --

Line 220: hr_utility.set_location(' p_enrt_perd_id '||p_enrt_perd_id,120);

216: hr_utility.set_location('Entering:'|| l_proc, 10);
217: hr_utility.set_location(' p_pgm_id '||p_pgm_id,120);
218: hr_utility.set_location(' p_pl_id '||p_pl_id,120);
219: hr_utility.set_location(' p_lee_rsn_id '||p_lee_rsn_id,120);
220: hr_utility.set_location(' p_enrt_perd_id '||p_enrt_perd_id,120);
221: --
222: end if;
223: --
224: -- Create or find ben_pil_elctbl_chc_popl

Line 268: hr_utility.set_location('BEN_?????_EPE_PL_OR_PGM', 22);

264: l_pel_create:=c_pel_at_pl_level%notfound;
265: close c_pel_at_pl_level;
266: else -- big trouble, neither is filled in error.
267: if g_debug then
268: hr_utility.set_location('BEN_?????_EPE_PL_OR_PGM', 22);
269: end if;
270: fnd_message.set_name('BEN','BEN_?????_EPE_PL_OR_PGM');
271: fnd_message.raise_error;
272: end if;

Line 277: hr_utility.set_location('BPECPAPI_CRE: '|| l_proc, 10);

273: --
274: if l_pel_create then
275: --
276: if g_debug then
277: hr_utility.set_location('BPECPAPI_CRE: '|| l_proc, 10);
278: end if;
279: --
280: -- Bug 2174005
281: --

Line 288: hr_utility.set_location('Enp found',11);

284: --
285: if c_enp%found then
286: --
287: if g_debug then
288: hr_utility.set_location('Enp found',11);
289: end if;
290: if l_enp_rec.ler_id is not null then
291: -- It is compensation Work Bench type of plan.
292: --

Line 318: --hr_utility.set_location ('Auto distribute'||l_auto_distr_flag,12);

314: open c_abr_pl (p_pl_id, p_effective_date);
315: fetch c_abr_pl into l_auto_distr_flag;
316: close c_abr_pl;
317: end if;
318: --hr_utility.set_location ('Auto distribute'||l_auto_distr_flag,12);
319: if l_auto_distr_flag = 'Y' then
320: l_bdgt_stat_cd := 'IS';
321: --l_ws_stat_cd := 'IS';
322: l_ws_iss_dt := p_effective_date;

Line 417: hr_utility.set_location(' l_reinstate_cd '||l_reinstate_cd,100);

413: else
414: l_procg_end_dt := p_procg_end_dt;
415: end if;
416: --
417: hr_utility.set_location(' l_reinstate_cd '||l_reinstate_cd,100);
418: hr_utility.set_location(' l_reinstate_ovrdn_cd '||l_reinstate_ovrdn_cd,100);
419: --
420: ben_Pil_Elctbl_chc_Popl_api.create_Pil_Elctbl_chc_Popl
421: (p_validate => FALSE

Line 418: hr_utility.set_location(' l_reinstate_ovrdn_cd '||l_reinstate_ovrdn_cd,100);

414: l_procg_end_dt := p_procg_end_dt;
415: end if;
416: --
417: hr_utility.set_location(' l_reinstate_cd '||l_reinstate_cd,100);
418: hr_utility.set_location(' l_reinstate_ovrdn_cd '||l_reinstate_ovrdn_cd,100);
419: --
420: ben_Pil_Elctbl_chc_Popl_api.create_Pil_Elctbl_chc_Popl
421: (p_validate => FALSE
422: ,p_pil_elctbl_chc_popl_id => l_pil_elctbl_chc_popl_id

Line 461: hr_utility.set_location('l_pil_elctbl_chc_popl_id '|| l_pil_elctbl_chc_popl_id, 10);

457: ,p_reopen_le_on_reprocess => l_reopen_le_on_reprocess
458: ,p_reinstate_ovrdn_cd => l_reinstate_ovrdn_cd
459: );
460: if g_debug then
461: hr_utility.set_location('l_pil_elctbl_chc_popl_id '|| l_pil_elctbl_chc_popl_id, 10);
462: end if;
463: if g_debug then
464: hr_utility.set_location('p_ws_mgr_id '|| p_ws_mgr_id, 10);
465: end if;

Line 464: hr_utility.set_location('p_ws_mgr_id '|| p_ws_mgr_id, 10);

460: if g_debug then
461: hr_utility.set_location('l_pil_elctbl_chc_popl_id '|| l_pil_elctbl_chc_popl_id, 10);
462: end if;
463: if g_debug then
464: hr_utility.set_location('p_ws_mgr_id '|| p_ws_mgr_id, 10);
465: end if;
466: if g_debug then
467: hr_utility.set_location('p_assignment_id '|| p_assignment_id, 10);
468: end if;

Line 467: hr_utility.set_location('p_assignment_id '|| p_assignment_id, 10);

463: if g_debug then
464: hr_utility.set_location('p_ws_mgr_id '|| p_ws_mgr_id, 10);
465: end if;
466: if g_debug then
467: hr_utility.set_location('p_assignment_id '|| p_assignment_id, 10);
468: end if;
469: update ben_Pil_Elctbl_chc_Popl
470: set ws_mgr_id = p_ws_mgr_id,
471: assignment_id = p_assignment_id

Line 474: hr_utility.set_location('Dn BPECPAPI_CRE: '|| l_proc, 10);

470: set ws_mgr_id = p_ws_mgr_id,
471: assignment_id = p_assignment_id
472: where Pil_Elctbl_chc_Popl_id = l_pil_elctbl_chc_popl_id;
473: if g_debug then
474: hr_utility.set_location('Dn BPECPAPI_CRE: '|| l_proc, 10);
475: end if;
476: --
477: -- If the enrollment period spans beyond the year period, issue a message.
478: --

Line 479: hr_utility.set_location('fnd_global.conc_request_id:'||fnd_global.conc_request_id,10);

475: end if;
476: --
477: -- If the enrollment period spans beyond the year period, issue a message.
478: --
479: hr_utility.set_location('fnd_global.conc_request_id:'||fnd_global.conc_request_id,10);
480: if fnd_global.conc_request_id <> -1 then
481: --
482: open c_yrp;
483: fetch c_yrp into l_yr_perd_end_dt;

Line 547: hr_utility.set_location('BPECPAPI_UPD: '|| l_proc, 10);

543: -- If any attributes need to be updated, then do it.
544: --
545: if l_update_pel then
546: if g_debug then
547: hr_utility.set_location('BPECPAPI_UPD: '|| l_proc, 10);
548: end if;
549: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl
550: (p_validate => FALSE
551: ,p_pil_elctbl_chc_popl_id => l_pil_elctbl_chc_popl_id

Line 566: hr_utility.set_location('Dn BPECPAPI_UPD: '|| l_proc, 10);

562: ,p_uom => l_pel_uom
563: ,p_acty_ref_perd_cd => l_pel_acty_ref_perd_cd
564: );
565: if g_debug then
566: hr_utility.set_location('Dn BPECPAPI_UPD: '|| l_proc, 10);
567: end if;
568: end if;
569: end if;
570: --

Line 580: hr_utility.set_location('get_oiplip', 25);

576: and p_oipl_id is not null
577: and p_pgm_id is not null
578: then
579: if g_debug then
580: hr_utility.set_location('get_oiplip', 25);
581: end if;
582: open get_oiplip;
583: fetch get_oiplip into l_oiplip_id;
584: close get_oiplip;

Line 719: g_debug := hr_utility.debug_enabled;

715: l_oiplip_id number;
716: --
717: begin
718: --
719: g_debug := hr_utility.debug_enabled;
720: if g_debug then
721: l_proc := g_package||'create_ELIG_PER_ELC_CHC';
722: hr_utility.set_location('Entering:'|| l_proc, 10);
723: end if;

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

718: --
719: g_debug := hr_utility.debug_enabled;
720: if g_debug then
721: l_proc := g_package||'create_ELIG_PER_ELC_CHC';
722: hr_utility.set_location('Entering:'|| l_proc, 10);
723: end if;
724: --
725: -- Issue a savepoint if operating in validation only mode
726: --

Line 880: hr_utility.set_location('EPE Ins: '|| l_proc, 10);

876: --
877: -- Use the resulting l_pil_elctbl_chc_popl_id as the FK
878: --
879: if g_debug then
880: hr_utility.set_location('EPE Ins: '|| l_proc, 10);
881: end if;
882: ben_epe_ins.ins
883: (
884: p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id

Line 981: hr_utility.set_location('Dn EPE Ins: '|| l_proc, 10);

977: ,p_object_version_number => l_object_version_number
978: ,p_effective_date => trunc(p_effective_date)
979: );
980: if g_debug then
981: hr_utility.set_location('Dn EPE Ins: '|| l_proc, 10);
982: end if;
983: --
984: begin
985: --

Line 1098: hr_utility.set_location(l_proc, 60);

1094: --
1095: end;
1096: --
1097: if g_debug then
1098: hr_utility.set_location(l_proc, 60);
1099: end if;
1100: --
1101: -- When in validation only mode raise the Validate_Enabled exception
1102: --

Line 1113: hr_utility.set_location('p_elig_per_elctbl_chc_id:'|| to_char(l_elig_per_elctbl_chc_id),99);

1109: p_elig_per_elctbl_chc_id := l_elig_per_elctbl_chc_id;
1110: p_object_version_number := l_object_version_number;
1111: --
1112: if g_debug then
1113: hr_utility.set_location('p_elig_per_elctbl_chc_id:'|| to_char(l_elig_per_elctbl_chc_id),99);
1114: end if;
1115:
1116: if g_debug then
1117: hr_utility.set_location(' Leaving:'||l_proc, 99);

Line 1117: hr_utility.set_location(' Leaving:'||l_proc, 99);

1113: hr_utility.set_location('p_elig_per_elctbl_chc_id:'|| to_char(l_elig_per_elctbl_chc_id),99);
1114: end if;
1115:
1116: if g_debug then
1117: hr_utility.set_location(' Leaving:'||l_proc, 99);
1118: end if;
1119: --
1120: exception
1121: --

Line 1136: hr_utility.set_location(' Leaving:'||l_proc, 80);

1132: --
1133: p_elig_per_elctbl_chc_id := null;
1134: p_object_version_number := null;
1135: if g_debug then
1136: hr_utility.set_location(' Leaving:'||l_proc, 80);
1137: end if;
1138: --
1139: when others then
1140: --

Line 1146: hr_utility.set_location(' Leaving:'||l_proc, 80);

1142: --
1143: p_elig_per_elctbl_chc_id := null;
1144: p_object_version_number := null;
1145: if g_debug then
1146: hr_utility.set_location(' Leaving:'||l_proc, 80);
1147: end if;
1148: --
1149: ROLLBACK TO create_ELIG_PER_ELC_CHC;
1150: raise;

Line 1291: g_debug := hr_utility.debug_enabled;

1287: l_sysdate date;
1288: --
1289: begin
1290: --
1291: g_debug := hr_utility.debug_enabled;
1292: if g_debug then
1293: l_proc := g_package||'create_perf_ELIG_PER_ELC_CHC';
1294: hr_utility.set_location('Entering:'|| l_proc, 10);
1295: end if;

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

1290: --
1291: g_debug := hr_utility.debug_enabled;
1292: if g_debug then
1293: l_proc := g_package||'create_perf_ELIG_PER_ELC_CHC';
1294: hr_utility.set_location('Entering:'|| l_proc, 10);
1295: end if;
1296: --
1297: -- Issue a savepoint if operating in validation only mode
1298: --

Line 1360: hr_utility.set_location('Insert EPE: '||l_proc, 5);

1356: --
1357: -- CWB : End
1358: --
1359: if g_debug then
1360: hr_utility.set_location('Insert EPE: '||l_proc, 5);
1361: end if;
1362: insert into ben_elig_per_elctbl_chc
1363: ( elig_per_elctbl_chc_id,
1364: -- enrt_typ_cycl_cd,

Line 1569: hr_utility.set_location('Dn Insert: '||l_proc, 5);

1565: p_program_update_date,
1566: l_object_version_number
1567: ) RETURNING elig_per_elctbl_chc_id into l_elig_per_elctbl_chc_id;
1568: if g_debug then
1569: hr_utility.set_location('Dn Insert: '||l_proc, 5);
1570: end if;
1571: --
1572: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
1573: --

Line 1632: hr_utility.set_location(' Leaving:'||l_proc, 99);

1628: p_elig_per_elctbl_chc_id := l_elig_per_elctbl_chc_id;
1629: p_object_version_number := l_object_version_number;
1630: --
1631: if g_debug then
1632: hr_utility.set_location(' Leaving:'||l_proc, 99);
1633: end if;
1634: --
1635: exception
1636: --

Line 1651: hr_utility.set_location(' Leaving:'||l_proc, 80);

1647: --
1648: p_elig_per_elctbl_chc_id := null;
1649: p_object_version_number := null;
1650: if g_debug then
1651: hr_utility.set_location(' Leaving:'||l_proc, 80);
1652: end if;
1653: --
1654: when others then
1655: --

Line 1661: hr_utility.set_location(' Leaving:'||l_proc, 80);

1657: --
1658: p_elig_per_elctbl_chc_id := null;
1659: p_object_version_number := null;
1660: if g_debug then
1661: hr_utility.set_location(' Leaving:'||l_proc, 80);
1662: end if;
1663: --
1664: ROLLBACK TO create_perf_ELIG_PER_ELC_CHC;
1665: raise;

Line 1782: g_debug := hr_utility.debug_enabled;

1778: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
1779: --
1780: begin
1781: --
1782: g_debug := hr_utility.debug_enabled;
1783: if g_debug then
1784: l_proc := g_package||'update_ELIG_PER_ELC_CHC';
1785: hr_utility.set_location('Entering:'|| l_proc, 10);
1786: end if;

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

1781: --
1782: g_debug := hr_utility.debug_enabled;
1783: if g_debug then
1784: l_proc := g_package||'update_ELIG_PER_ELC_CHC';
1785: hr_utility.set_location('Entering:'|| l_proc, 10);
1786: end if;
1787: --
1788: -- Issue a savepoint if operating in validation only mode
1789: --

Line 1910: hr_utility.set_location(' EPE Upd'|| l_proc, 10);

1906: --
1907: end;
1908: --
1909: if g_debug then
1910: hr_utility.set_location(' EPE Upd'|| l_proc, 10);
1911: end if;
1912: ben_epe_upd.upd
1913: (
1914: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id

Line 2011: hr_utility.set_location(' Dn EPE Upd'|| l_proc, 10);

2007: ,p_object_version_number => l_object_version_number
2008: ,p_effective_date => trunc(p_effective_date)
2009: );
2010: if g_debug then
2011: hr_utility.set_location(' Dn EPE Upd'|| l_proc, 10);
2012: end if;
2013: --
2014: begin
2015: --

Line 2128: hr_utility.set_location(l_proc, 60);

2124: --
2125: end;
2126: --
2127: if g_debug then
2128: hr_utility.set_location(l_proc, 60);
2129: end if;
2130: --
2131: -- When in validation only mode raise the Validate_Enabled exception
2132: --

Line 2142: hr_utility.set_location(' Leaving:'||l_proc, 70);

2138: --
2139: p_object_version_number := l_object_version_number;
2140: --
2141: if g_debug then
2142: hr_utility.set_location(' Leaving:'||l_proc, 70);
2143: end if;
2144: --
2145: exception
2146: --

Line 2159: hr_utility.set_location(' Leaving:'||l_proc, 80);

2155: -- (Any key or derived arguments must be set to null
2156: -- when validation only mode is being used.)
2157: --
2158: if g_debug then
2159: hr_utility.set_location(' Leaving:'||l_proc, 80);
2160: end if;
2161: --
2162: when others then
2163: --

Line 2168: hr_utility.set_location(' Leaving:'||l_proc, 80);

2164: -- A validation or unexpected error has occured
2165: --
2166: p_object_version_number := l_object_version_number;
2167: if g_debug then
2168: hr_utility.set_location(' Leaving:'||l_proc, 80);
2169: end if;
2170: --
2171: ROLLBACK TO update_ELIG_PER_ELC_CHC;
2172: raise;

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

2217: begin
2218:
2219: if g_debug then
2220: l_proc := g_package||'chk_valid_mgr';
2221: hr_utility.set_location(' Entering:'||l_proc, 10);
2222: end if;
2223:
2224: open c1;
2225: fetch c1 into l_person1,l_person2;

Line 2236: hr_utility.set_location(' Leaving:'||l_proc, 20);

2232: end if;
2233: close c1;
2234:
2235: if g_debug then
2236: hr_utility.set_location(' Leaving:'||l_proc, 20);
2237: end if;
2238: end;
2239: -- ----------------------------------------------------------------------------
2240: -- |--------------------< update_perf_ELIG_PER_ELC_CHC >--- ------------------|

Line 2357: g_debug := hr_utility.debug_enabled;

2353: l_inelig_rsn_cd varchar2(30);
2354: --
2355: begin
2356: --
2357: g_debug := hr_utility.debug_enabled;
2358: if g_debug then
2359: l_proc := g_package||'update_perf_ELIG_PER_ELC_CHC';
2360: hr_utility.set_location('Entering:'|| l_proc, 10);
2361: end if;

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

2356: --
2357: g_debug := hr_utility.debug_enabled;
2358: if g_debug then
2359: l_proc := g_package||'update_perf_ELIG_PER_ELC_CHC';
2360: hr_utility.set_location('Entering:'|| l_proc, 10);
2361: end if;
2362: --
2363: -- Issue a savepoint if operating in validation only mode
2364: --

Line 2518: hr_utility.set_location(' EPE Upd'|| l_proc, 10);

2514: --
2515: l_object_version_number := p_object_version_number+1;
2516: --
2517: if g_debug then
2518: hr_utility.set_location(' EPE Upd'|| l_proc, 10);
2519: end if;
2520: ben_epe_shd.g_api_dml := true; -- Set the api dml status
2521: --
2522: -- Update the ben_elig_per_elctbl_chc Row

Line 2632: hr_utility.set_location(' Dn EPE Upd'|| l_proc, 10);

2628: --
2629: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
2630: --
2631: if g_debug then
2632: hr_utility.set_location(' Dn EPE Upd'|| l_proc, 10);
2633: end if;
2634: --
2635: -- When in validation only mode raise the Validate_Enabled exception
2636: --

Line 2670: hr_utility.set_location(' Leaving:'||l_proc, 70);

2666: --
2667: p_object_version_number := l_object_version_number;
2668: --
2669: if g_debug then
2670: hr_utility.set_location(' Leaving:'||l_proc, 70);
2671: end if;
2672: --
2673: exception
2674: --

Line 2687: hr_utility.set_location(' Leaving:'||l_proc, 80);

2683: -- (Any key or derived arguments must be set to null
2684: -- when validation only mode is being used.)
2685: --
2686: if g_debug then
2687: hr_utility.set_location(' Leaving:'||l_proc, 80);
2688: end if;
2689: --
2690: when others then
2691: --

Line 2696: hr_utility.set_location(' Leaving:'||l_proc, 80);

2692: -- A validation or unexpected error has occured
2693: --
2694: p_object_version_number := l_object_version_number;
2695: if g_debug then
2696: hr_utility.set_location(' Leaving:'||l_proc, 80);
2697: end if;
2698: --
2699: ROLLBACK TO update_perf_ELIG_PER_ELC_CHC;
2700: raise;

Line 2792: g_debug := hr_utility.debug_enabled;

2788:
2789: --
2790: begin
2791: --
2792: g_debug := hr_utility.debug_enabled;
2793: if g_debug then
2794: l_proc := g_package||'update_ELIG_PER_ELC_CHC';
2795: hr_utility.set_location('Entering:'|| l_proc, 10);
2796: end if;

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

2791: --
2792: g_debug := hr_utility.debug_enabled;
2793: if g_debug then
2794: l_proc := g_package||'update_ELIG_PER_ELC_CHC';
2795: hr_utility.set_location('Entering:'|| l_proc, 10);
2796: end if;
2797: --
2798: -- Issue a savepoint if operating in validation only mode
2799: --

Line 2803: hr_utility.set_location(l_proc, 20);

2799: --
2800: savepoint delete_ELIG_PER_ELC_CHC;
2801: --
2802: if g_debug then
2803: hr_utility.set_location(l_proc, 20);
2804: end if;
2805: --
2806: -- Process Logic
2807: --

Line 2893: hr_utility.set_location(l_proc, 60);

2889: --
2890: end;
2891: --
2892: if g_debug then
2893: hr_utility.set_location(l_proc, 60);
2894: end if;
2895: --
2896: -- When in validation only mode raise the Validate_Enabled exception
2897: --

Line 2903: hr_utility.set_location(' Leaving:'||l_proc, 70);

2899: raise hr_api.validate_enabled;
2900: end if;
2901: --
2902: if g_debug then
2903: hr_utility.set_location(' Leaving:'||l_proc, 70);
2904: end if;
2905: --
2906: exception
2907: --

Line 2926: hr_utility.set_location(' Leaving:'||l_proc, 80);

2922: -- A validation or unexpected error has occured
2923: --
2924: p_object_version_number := l_object_version_number;
2925: if g_debug then
2926: hr_utility.set_location(' Leaving:'||l_proc, 80);
2927: end if;
2928: --
2929: ROLLBACK TO delete_ELIG_PER_ELC_CHC;
2930: raise;

Line 2951: g_debug := hr_utility.debug_enabled;

2947: l_proc varchar2(72) ;
2948: --
2949: begin
2950: --
2951: g_debug := hr_utility.debug_enabled;
2952: if g_debug then
2953: l_proc := g_package||'lck';
2954: hr_utility.set_location('Entering:'|| l_proc, 10);
2955: end if;

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

2950: --
2951: g_debug := hr_utility.debug_enabled;
2952: if g_debug then
2953: l_proc := g_package||'lck';
2954: hr_utility.set_location('Entering:'|| l_proc, 10);
2955: end if;
2956: --
2957: ben_epe_shd.lck
2958: (

Line 2964: hr_utility.set_location(' Leaving:'||l_proc, 70);

2960: ,p_object_version_number => p_object_version_number
2961: );
2962: --
2963: if g_debug then
2964: hr_utility.set_location(' Leaving:'||l_proc, 70);
2965: end if;
2966: --
2967: end lck;
2968: --