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.BEN_ELIG_PER_ELC_CHC_API dependencies on HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: beepeapi.pkb 120.0.12010000.2 2008/08/05 14:24:37 ubhat 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 208: hr_utility.set_location('Entering:'|| l_proc, 10);

204: l_reinstate_cd varchar2(30);
205: l_reinstate_ovrdn_cd varchar2(30);
206: --
207: begin
208: hr_utility.set_location('Entering:'|| l_proc, 10);
209: --
210: if g_debug then
211: l_proc := g_package||'CreOrSel_pil_elctbl_chc_popl';
212: --

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

409: else
410: l_procg_end_dt := p_procg_end_dt;
411: end if;
412: --
413: hr_utility.set_location(' l_reinstate_cd '||l_reinstate_cd,100);
414: hr_utility.set_location(' l_reinstate_ovrdn_cd '||l_reinstate_ovrdn_cd,100);
415: --
416: ben_Pil_Elctbl_chc_Popl_api.create_Pil_Elctbl_chc_Popl
417: (p_validate => FALSE

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

410: l_procg_end_dt := p_procg_end_dt;
411: end if;
412: --
413: hr_utility.set_location(' l_reinstate_cd '||l_reinstate_cd,100);
414: hr_utility.set_location(' l_reinstate_ovrdn_cd '||l_reinstate_ovrdn_cd,100);
415: --
416: ben_Pil_Elctbl_chc_Popl_api.create_Pil_Elctbl_chc_Popl
417: (p_validate => FALSE
418: ,p_pil_elctbl_chc_popl_id => l_pil_elctbl_chc_popl_id

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

452: ,p_reinstate_cd => l_reinstate_cd
453: ,p_reinstate_ovrdn_cd => l_reinstate_ovrdn_cd
454: );
455: if g_debug then
456: hr_utility.set_location('l_pil_elctbl_chc_popl_id '|| l_pil_elctbl_chc_popl_id, 10);
457: end if;
458: if g_debug then
459: hr_utility.set_location('p_ws_mgr_id '|| p_ws_mgr_id, 10);
460: end if;

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

455: if g_debug then
456: hr_utility.set_location('l_pil_elctbl_chc_popl_id '|| l_pil_elctbl_chc_popl_id, 10);
457: end if;
458: if g_debug then
459: hr_utility.set_location('p_ws_mgr_id '|| p_ws_mgr_id, 10);
460: end if;
461: if g_debug then
462: hr_utility.set_location('p_assignment_id '|| p_assignment_id, 10);
463: end if;

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

458: if g_debug then
459: hr_utility.set_location('p_ws_mgr_id '|| p_ws_mgr_id, 10);
460: end if;
461: if g_debug then
462: hr_utility.set_location('p_assignment_id '|| p_assignment_id, 10);
463: end if;
464: update ben_Pil_Elctbl_chc_Popl
465: set ws_mgr_id = p_ws_mgr_id,
466: assignment_id = p_assignment_id

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

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

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

470: end if;
471: --
472: -- If the enrollment period spans beyond the year period, issue a message.
473: --
474: hr_utility.set_location('fnd_global.conc_request_id:'||fnd_global.conc_request_id,10);
475: if fnd_global.conc_request_id <> -1 then
476: --
477: open c_yrp;
478: fetch c_yrp into l_yr_perd_end_dt;

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

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

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

557: ,p_uom => l_pel_uom
558: ,p_acty_ref_perd_cd => l_pel_acty_ref_perd_cd
559: );
560: if g_debug then
561: hr_utility.set_location('Dn BPECPAPI_UPD: '|| l_proc, 10);
562: end if;
563: end if;
564: end if;
565: --

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

571: and p_oipl_id is not null
572: and p_pgm_id is not null
573: then
574: if g_debug then
575: hr_utility.set_location('get_oiplip', 25);
576: end if;
577: open get_oiplip;
578: fetch get_oiplip into l_oiplip_id;
579: close get_oiplip;

Line 714: g_debug := hr_utility.debug_enabled;

710: l_oiplip_id number;
711: --
712: begin
713: --
714: g_debug := hr_utility.debug_enabled;
715: if g_debug then
716: l_proc := g_package||'create_ELIG_PER_ELC_CHC';
717: hr_utility.set_location('Entering:'|| l_proc, 10);
718: end if;

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

713: --
714: g_debug := hr_utility.debug_enabled;
715: if g_debug then
716: l_proc := g_package||'create_ELIG_PER_ELC_CHC';
717: hr_utility.set_location('Entering:'|| l_proc, 10);
718: end if;
719: --
720: -- Issue a savepoint if operating in validation only mode
721: --

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

871: --
872: -- Use the resulting l_pil_elctbl_chc_popl_id as the FK
873: --
874: if g_debug then
875: hr_utility.set_location('EPE Ins: '|| l_proc, 10);
876: end if;
877: ben_epe_ins.ins
878: (
879: p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id

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

972: ,p_object_version_number => l_object_version_number
973: ,p_effective_date => trunc(p_effective_date)
974: );
975: if g_debug then
976: hr_utility.set_location('Dn EPE Ins: '|| l_proc, 10);
977: end if;
978: --
979: begin
980: --

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

1089: --
1090: end;
1091: --
1092: if g_debug then
1093: hr_utility.set_location(l_proc, 60);
1094: end if;
1095: --
1096: -- When in validation only mode raise the Validate_Enabled exception
1097: --

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

1104: p_elig_per_elctbl_chc_id := l_elig_per_elctbl_chc_id;
1105: p_object_version_number := l_object_version_number;
1106: --
1107: if g_debug then
1108: hr_utility.set_location('p_elig_per_elctbl_chc_id:'|| to_char(l_elig_per_elctbl_chc_id),99);
1109: end if;
1110:
1111: if g_debug then
1112: hr_utility.set_location(' Leaving:'||l_proc, 99);

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

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

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

1127: --
1128: p_elig_per_elctbl_chc_id := null;
1129: p_object_version_number := null;
1130: if g_debug then
1131: hr_utility.set_location(' Leaving:'||l_proc, 80);
1132: end if;
1133: --
1134: when others then
1135: --

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

1137: --
1138: p_elig_per_elctbl_chc_id := null;
1139: p_object_version_number := null;
1140: if g_debug then
1141: hr_utility.set_location(' Leaving:'||l_proc, 80);
1142: end if;
1143: --
1144: ROLLBACK TO create_ELIG_PER_ELC_CHC;
1145: raise;

Line 1286: g_debug := hr_utility.debug_enabled;

1282: l_sysdate date;
1283: --
1284: begin
1285: --
1286: g_debug := hr_utility.debug_enabled;
1287: if g_debug then
1288: l_proc := g_package||'create_perf_ELIG_PER_ELC_CHC';
1289: hr_utility.set_location('Entering:'|| l_proc, 10);
1290: end if;

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

1285: --
1286: g_debug := hr_utility.debug_enabled;
1287: if g_debug then
1288: l_proc := g_package||'create_perf_ELIG_PER_ELC_CHC';
1289: hr_utility.set_location('Entering:'|| l_proc, 10);
1290: end if;
1291: --
1292: -- Issue a savepoint if operating in validation only mode
1293: --

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

1351: --
1352: -- CWB : End
1353: --
1354: if g_debug then
1355: hr_utility.set_location('Insert EPE: '||l_proc, 5);
1356: end if;
1357: insert into ben_elig_per_elctbl_chc
1358: ( elig_per_elctbl_chc_id,
1359: -- enrt_typ_cycl_cd,

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

1560: p_program_update_date,
1561: l_object_version_number
1562: ) RETURNING elig_per_elctbl_chc_id into l_elig_per_elctbl_chc_id;
1563: if g_debug then
1564: hr_utility.set_location('Dn Insert: '||l_proc, 5);
1565: end if;
1566: --
1567: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
1568: --

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

1623: p_elig_per_elctbl_chc_id := l_elig_per_elctbl_chc_id;
1624: p_object_version_number := l_object_version_number;
1625: --
1626: if g_debug then
1627: hr_utility.set_location(' Leaving:'||l_proc, 99);
1628: end if;
1629: --
1630: exception
1631: --

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

1642: --
1643: p_elig_per_elctbl_chc_id := null;
1644: p_object_version_number := null;
1645: if g_debug then
1646: hr_utility.set_location(' Leaving:'||l_proc, 80);
1647: end if;
1648: --
1649: when others then
1650: --

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

1652: --
1653: p_elig_per_elctbl_chc_id := null;
1654: p_object_version_number := null;
1655: if g_debug then
1656: hr_utility.set_location(' Leaving:'||l_proc, 80);
1657: end if;
1658: --
1659: ROLLBACK TO create_perf_ELIG_PER_ELC_CHC;
1660: raise;

Line 1777: g_debug := hr_utility.debug_enabled;

1773: l_object_version_number ben_elig_per_elctbl_chc.object_version_number%TYPE;
1774: --
1775: begin
1776: --
1777: g_debug := hr_utility.debug_enabled;
1778: if g_debug then
1779: l_proc := g_package||'update_ELIG_PER_ELC_CHC';
1780: hr_utility.set_location('Entering:'|| l_proc, 10);
1781: end if;

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

1776: --
1777: g_debug := hr_utility.debug_enabled;
1778: if g_debug then
1779: l_proc := g_package||'update_ELIG_PER_ELC_CHC';
1780: hr_utility.set_location('Entering:'|| l_proc, 10);
1781: end if;
1782: --
1783: -- Issue a savepoint if operating in validation only mode
1784: --

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

1901: --
1902: end;
1903: --
1904: if g_debug then
1905: hr_utility.set_location(' EPE Upd'|| l_proc, 10);
1906: end if;
1907: ben_epe_upd.upd
1908: (
1909: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id

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

2002: ,p_object_version_number => l_object_version_number
2003: ,p_effective_date => trunc(p_effective_date)
2004: );
2005: if g_debug then
2006: hr_utility.set_location(' Dn EPE Upd'|| l_proc, 10);
2007: end if;
2008: --
2009: begin
2010: --

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

2119: --
2120: end;
2121: --
2122: if g_debug then
2123: hr_utility.set_location(l_proc, 60);
2124: end if;
2125: --
2126: -- When in validation only mode raise the Validate_Enabled exception
2127: --

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

2133: --
2134: p_object_version_number := l_object_version_number;
2135: --
2136: if g_debug then
2137: hr_utility.set_location(' Leaving:'||l_proc, 70);
2138: end if;
2139: --
2140: exception
2141: --

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

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

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

2159: -- A validation or unexpected error has occured
2160: --
2161: p_object_version_number := l_object_version_number;
2162: if g_debug then
2163: hr_utility.set_location(' Leaving:'||l_proc, 80);
2164: end if;
2165: --
2166: ROLLBACK TO update_ELIG_PER_ELC_CHC;
2167: raise;

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

2212: begin
2213:
2214: if g_debug then
2215: l_proc := g_package||'chk_valid_mgr';
2216: hr_utility.set_location(' Entering:'||l_proc, 10);
2217: end if;
2218:
2219: open c1;
2220: fetch c1 into l_person1,l_person2;

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

2227: end if;
2228: close c1;
2229:
2230: if g_debug then
2231: hr_utility.set_location(' Leaving:'||l_proc, 20);
2232: end if;
2233: end;
2234: -- ----------------------------------------------------------------------------
2235: -- |--------------------< update_perf_ELIG_PER_ELC_CHC >--- ------------------|

Line 2352: g_debug := hr_utility.debug_enabled;

2348: l_inelig_rsn_cd varchar2(30);
2349: --
2350: begin
2351: --
2352: g_debug := hr_utility.debug_enabled;
2353: if g_debug then
2354: l_proc := g_package||'update_perf_ELIG_PER_ELC_CHC';
2355: hr_utility.set_location('Entering:'|| l_proc, 10);
2356: end if;

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

2351: --
2352: g_debug := hr_utility.debug_enabled;
2353: if g_debug then
2354: l_proc := g_package||'update_perf_ELIG_PER_ELC_CHC';
2355: hr_utility.set_location('Entering:'|| l_proc, 10);
2356: end if;
2357: --
2358: -- Issue a savepoint if operating in validation only mode
2359: --

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

2509: --
2510: l_object_version_number := p_object_version_number+1;
2511: --
2512: if g_debug then
2513: hr_utility.set_location(' EPE Upd'|| l_proc, 10);
2514: end if;
2515: ben_epe_shd.g_api_dml := true; -- Set the api dml status
2516: --
2517: -- Update the ben_elig_per_elctbl_chc Row

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

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

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

2661: --
2662: p_object_version_number := l_object_version_number;
2663: --
2664: if g_debug then
2665: hr_utility.set_location(' Leaving:'||l_proc, 70);
2666: end if;
2667: --
2668: exception
2669: --

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

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

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

2687: -- A validation or unexpected error has occured
2688: --
2689: p_object_version_number := l_object_version_number;
2690: if g_debug then
2691: hr_utility.set_location(' Leaving:'||l_proc, 80);
2692: end if;
2693: --
2694: ROLLBACK TO update_perf_ELIG_PER_ELC_CHC;
2695: raise;

Line 2787: g_debug := hr_utility.debug_enabled;

2783:
2784: --
2785: begin
2786: --
2787: g_debug := hr_utility.debug_enabled;
2788: if g_debug then
2789: l_proc := g_package||'update_ELIG_PER_ELC_CHC';
2790: hr_utility.set_location('Entering:'|| l_proc, 10);
2791: end if;

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

2786: --
2787: g_debug := hr_utility.debug_enabled;
2788: if g_debug then
2789: l_proc := g_package||'update_ELIG_PER_ELC_CHC';
2790: hr_utility.set_location('Entering:'|| l_proc, 10);
2791: end if;
2792: --
2793: -- Issue a savepoint if operating in validation only mode
2794: --

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

2794: --
2795: savepoint delete_ELIG_PER_ELC_CHC;
2796: --
2797: if g_debug then
2798: hr_utility.set_location(l_proc, 20);
2799: end if;
2800: --
2801: -- Process Logic
2802: --

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

2884: --
2885: end;
2886: --
2887: if g_debug then
2888: hr_utility.set_location(l_proc, 60);
2889: end if;
2890: --
2891: -- When in validation only mode raise the Validate_Enabled exception
2892: --

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

2894: raise hr_api.validate_enabled;
2895: end if;
2896: --
2897: if g_debug then
2898: hr_utility.set_location(' Leaving:'||l_proc, 70);
2899: end if;
2900: --
2901: exception
2902: --

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

2917: -- A validation or unexpected error has occured
2918: --
2919: p_object_version_number := l_object_version_number;
2920: if g_debug then
2921: hr_utility.set_location(' Leaving:'||l_proc, 80);
2922: end if;
2923: --
2924: ROLLBACK TO delete_ELIG_PER_ELC_CHC;
2925: raise;

Line 2946: g_debug := hr_utility.debug_enabled;

2942: l_proc varchar2(72) ;
2943: --
2944: begin
2945: --
2946: g_debug := hr_utility.debug_enabled;
2947: if g_debug then
2948: l_proc := g_package||'lck';
2949: hr_utility.set_location('Entering:'|| l_proc, 10);
2950: end if;

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

2945: --
2946: g_debug := hr_utility.debug_enabled;
2947: if g_debug then
2948: l_proc := g_package||'lck';
2949: hr_utility.set_location('Entering:'|| l_proc, 10);
2950: end if;
2951: --
2952: ben_epe_shd.lck
2953: (

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

2955: ,p_object_version_number => p_object_version_number
2956: );
2957: --
2958: if g_debug then
2959: hr_utility.set_location(' Leaving:'||l_proc, 70);
2960: end if;
2961: --
2962: end lck;
2963: --