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

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

1242:
1243: --
1244: l_id NUMBER;
1245: BEGIN
1246: hr_utility.set_location('Entering: '||l_proc,10);
1247: FOR l_ecd IN c_ecd LOOP
1248: if(p_per_in_ler_id is NULL) then
1249: FOR l_crt_ordr_cvrd IN c_crt_ordr_cvrd (
1250: l_ecd.dpnt_person_id

Line 1256: hr_utility.set_location(l_proc, 15);

1252: DELETE FROM ben_crt_ordr_cvrd_per
1253: WHERE CURRENT OF c_crt_ordr_cvrd;
1254: END LOOP;
1255: end if;
1256: hr_utility.set_location(l_proc, 15);
1257: FOR l_cvrd_dpnt IN c_cvrd_dpnt (
1258: l_ecd.elig_cvrd_dpnt_id
1259: ) LOOP
1260: DELETE ben_cvrd_dpnt_ctfn_prvdd_f

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

1259: ) LOOP
1260: DELETE ben_cvrd_dpnt_ctfn_prvdd_f
1261: WHERE CURRENT OF c_cvrd_dpnt;
1262: END LOOP;
1263: hr_utility.set_location(l_proc, 20);
1264: OPEN c1 (
1265: l_ecd.elig_cvrd_dpnt_id
1266: );
1267: <>

Line 1275: hr_utility.set_location(l_proc, 25);

1271: DELETE ben_prtt_enrt_actn_f
1272: WHERE CURRENT OF c1;
1273: END LOOP ben_prtt_enrt_actn_f;
1274: CLOSE c1;
1275: hr_utility.set_location(l_proc, 25);
1276: OPEN c2 (
1277: l_ecd.elig_cvrd_dpnt_id
1278: );
1279: <>

Line 1287: hr_utility.set_location(l_proc, 30);

1283: DELETE ben_prmry_care_prvdr_f
1284: WHERE CURRENT OF c2;
1285: END LOOP ben_prmry_care_prvdr_f;
1286: CLOSE c2;
1287: hr_utility.set_location(l_proc, 30);
1288: OPEN c3 (
1289: l_ecd.elig_cvrd_dpnt_id
1290: );
1291: <>

Line 1299: hr_utility.set_location(l_proc, 35);

1295: DELETE ben_cvrd_dpnt_ctfn_prvdd_f
1296: WHERE CURRENT OF c3;
1297: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;
1298: CLOSE c3;
1299: hr_utility.set_location(l_proc, 35);
1300: /* OPEN c4 (
1301: l_ecd.elig_cvrd_dpnt_id
1302: );
1303: <>

Line 1311: hr_utility.set_location(l_proc, 40);

1307: DELETE ben_elig_cvrd_dpnt_f
1308: WHERE CURRENT OF c4;
1309: END LOOP ben_elig_cvrd_dpnt_f;
1310: CLOSE c4; */
1311: hr_utility.set_location(l_proc, 40);
1312: OPEN c5 (
1313: l_ecd.elig_cvrd_dpnt_id
1314: );
1315: <>

Line 1323: hr_utility.set_location(l_proc, 45);

1319: DELETE ben_elig_dpnt
1320: WHERE CURRENT OF c5;
1321: END LOOP ben_elig_dpnt;
1322: CLOSE c5;
1323: hr_utility.set_location(l_proc, 45);
1324: OPEN c6 (
1325: l_ecd.elig_cvrd_dpnt_id
1326: );
1327: <>

Line 1335: hr_utility.set_location(l_proc, 50);

1331: DELETE FROM ben_ext_crit_val
1332: WHERE CURRENT OF c6;
1333: END LOOP ben_ext_crit_val;
1334: CLOSE c6;
1335: hr_utility.set_location(l_proc, 50);
1336: OPEN c7 (
1337: l_ecd.elig_cvrd_dpnt_id
1338: );
1339: <>

Line 1350: hr_utility.set_location('Leaving: '||l_proc,999);

1346: CLOSE c7;
1347: DELETE ben_elig_cvrd_dpnt_f
1348: WHERE CURRENT OF c_ecd;
1349: END LOOP;
1350: hr_utility.set_location('Leaving: '||l_proc,999);
1351: END delete_dependent_information;
1352:
1353: --
1354: PROCEDURE delete_communications (

Line 1396: hr_utility.set_location('Entering: '||l_proc,20);

1392: WHERE per_cm_id = p_per_cm_id
1393: FOR UPDATE OF per_cm_usg_id;
1394: l_id NUMBER;
1395: BEGIN
1396: hr_utility.set_location('Entering: '||l_proc,20);
1397: FOR r1 IN c1 LOOP
1398: OPEN c2 (
1399: r1.per_cm_id
1400: );

Line 1432: hr_utility.set_location('Leaving: '||l_proc,999);

1428: WHERE CURRENT OF c4;
1429: END LOOP ben_per_cm_usg_f;
1430: CLOSE c4;
1431: END LOOP;
1432: hr_utility.set_location('Leaving: '||l_proc,999);
1433: END delete_communications;
1434:
1435: --
1436: PROCEDURE delete_life_events (

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

1713:
1714: --
1715: l_id NUMBER;
1716: BEGIN
1717: hr_utility.set_location('Entering: '||l_proc,10);
1718: FOR r1 IN c1 LOOP
1719: FOR r2 IN c2 (
1720: r1.per_in_ler_id
1721: ) LOOP

Line 1841: hr_utility.set_location(l_proc,50);

1837: WHERE CURRENT OF c14;
1838: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;
1839: CLOSE c14;
1840: END LOOP;
1841: hr_utility.set_location(l_proc,50);
1842: FOR r15 IN c15 (
1843: r1.per_in_ler_id
1844: ) LOOP
1845: OPEN c16 (

Line 1857: hr_utility.set_location(l_proc,55);

1853: WHERE CURRENT OF c16;
1854: END LOOP;
1855: CLOSE c16;
1856: END LOOP;
1857: hr_utility.set_location(l_proc,55);
1858: FOR r17 IN c17 (
1859: r1.per_in_ler_id
1860: ) LOOP
1861: OPEN c18 (

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

1869: WHERE CURRENT OF c18;
1870: END LOOP ben_enrt_bnft;
1871: CLOSE c18;
1872: --
1873: hr_utility.set_location(l_proc,60);
1874: OPEN c19 (
1875: r17.elig_per_elctbl_chc_id
1876: );
1877: <>

Line 1886: hr_utility.set_location(l_proc,65);

1882: WHERE CURRENT OF c19;
1883: END LOOP;
1884: CLOSE c19;
1885: --
1886: hr_utility.set_location(l_proc,65);
1887: OPEN c20 (
1888: r17.elig_per_elctbl_chc_id
1889: );
1890: <>

Line 1899: hr_utility.set_location(l_proc,70);

1895: WHERE CURRENT OF c20;
1896: END LOOP ben_enrt_rt;
1897: CLOSE c20;
1898: --
1899: hr_utility.set_location(l_proc,70);
1900: OPEN c21 (
1901: r17.elig_per_elctbl_chc_id
1902: );
1903: <>

Line 1912: hr_utility.set_location(l_proc,70);

1908: WHERE CURRENT OF c21;
1909: END LOOP ben_elctbl_chc_ctfn;
1910: CLOSE c21;
1911: END LOOP;
1912: hr_utility.set_location(l_proc,70);
1913: FOR r22 IN c22 (
1914: r1.per_in_ler_id
1915: ) LOOP
1916: OPEN c23 (

Line 1953: hr_utility.set_location(l_proc,90);

1949: CLOSE c25;
1950: OPEN c26 (
1951: r1.per_in_ler_id
1952: );
1953: hr_utility.set_location(l_proc,90);
1954: <>
1955: LOOP
1956: FETCH c26 INTO l_id;
1957: EXIT WHEN c26%NOTFOUND;

Line 2018: hr_utility.set_location('Leaving: '||l_proc,999);

2014: WHERE CURRENT OF c31;
2015: END LOOP ben_prtt_enrt_rslt_f;
2016: CLOSE c31;
2017: END LOOP;
2018: hr_utility.set_location('Leaving: '||l_proc,999);
2019: END delete_life_events;
2020:
2021: --
2022: PROCEDURE delete_participant_information (

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

2098: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2099: FOR UPDATE OF prtt_enrt_actn_id;
2100: l_id NUMBER;
2101: BEGIN
2102: hr_utility.set_location('Entering: '||l_proc,10);
2103: FOR r1 IN c1 (
2104: p_person_id
2105: ) LOOP
2106: OPEN c2 (

Line 2184: hr_utility.set_location('Leaving: '||l_proc,999);

2180: WHERE CURRENT OF c8;
2181: END LOOP ben_prtt_enrt_actn_f;
2182: CLOSE c8;
2183: END LOOP;
2184: hr_utility.set_location('Leaving: '||l_proc,999);
2185: END delete_participant_information;
2186:
2187: --
2188: PROCEDURE delete_benefit_action_children (

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

2229:
2230: --
2231: l_id NUMBER;
2232: BEGIN
2233: hr_utility.set_location('Entering: '||l_proc,10);
2234: FOR r1 IN c1 LOOP
2235: OPEN c2 (
2236: r1.benefit_action_id
2237: );

Line 2269: hr_utility.set_location('Leaving: '||l_proc,999);

2265: WHERE CURRENT OF c4;
2266: END LOOP ben_batch_ranges;
2267: CLOSE c4;
2268: END LOOP;
2269: hr_utility.set_location('Leaving: '||l_proc,999);
2270: END delete_benefit_action_children;
2271:
2272: --
2273: PROCEDURE delete_reimbmt_rqst (

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

3259:
3260:
3261: l_dummy varchar2(1) := 'N' ;
3262: BEGIN
3263: hr_utility.set_location('Entering '||l_proc , 10);
3264: --check for per_in_ler in started status. Exclude the unrestricted cases
3265: open c_pil(p_person_id,p_effective_date) ;
3266: --
3267: fetch c_pil into l_dummy ;

Line 3270: hr_utility.set_location('Started Pil exist for person '||p_person_id , 20);

3266: --
3267: fetch c_pil into l_dummy ;
3268: if c_pil%found then
3269: --
3270: hr_utility.set_location('Started Pil exist for person '||p_person_id , 20);
3271: close c_pil ;
3272: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3273: fnd_message.set_token('BEN_ITEM','Life Event');
3274: fnd_message.raise_error;

Line 3284: hr_utility.set_location('Started pen exist for person '||p_person_id , 30);

3280: --
3281: fetch c_pen into l_dummy ;
3282: if c_pen%found then
3283: --
3284: hr_utility.set_location('Started pen exist for person '||p_person_id , 30);
3285: close c_pen ;
3286: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3287: fnd_message.set_token('BEN_ITEM','Enrollment');
3288: fnd_message.raise_error;

Line 3298: hr_utility.set_location('Started prv exist for person '||p_person_id , 40);

3294: --
3295: fetch c_prv into l_dummy ;
3296: if c_prv%found then
3297: --
3298: hr_utility.set_location('Started prv exist for person '||p_person_id , 40);
3299: close c_prv ;
3300: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3301: fnd_message.set_token('BEN_ITEM','Rate');
3302: fnd_message.raise_error;

Line 3312: hr_utility.set_location('Started ecd exist for person '||p_person_id , 50);

3308: --
3309: fetch c_ecd into l_dummy ;
3310: if c_ecd%found then
3311: --
3312: hr_utility.set_location('Started ecd exist for person '||p_person_id , 50);
3313: close c_ecd ;
3314: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3315: fnd_message.set_token('BEN_ITEM','Dependents');
3316: fnd_message.raise_error;

Line 3327: hr_utility.set_location('Started ecdpn exist for person '||p_person_id , 50);

3323: --
3324: fetch c_ecdpn into l_dummy ;
3325: if c_ecdpn%found then
3326: --
3327: hr_utility.set_location('Started ecdpn exist for person '||p_person_id , 50);
3328: close c_ecdpn ;
3329: fnd_message.set_name('BEN', 'BEN_93910_DPTN_CVRD');
3330: fnd_message.raise_error;
3331: --

Line 3341: hr_utility.set_location('Started ecdpn exist for person '||p_person_id , 50);

3337: --
3338: fetch c_plbnf into l_dummy ;
3339: if c_plbnf%found then
3340: --
3341: hr_utility.set_location('Started ecdpn exist for person '||p_person_id , 50);
3342: close c_plbnf ;
3343: fnd_message.set_name('BEN', 'BEN_93911_DPT_DESIG_BNF');
3344: fnd_message.raise_error;
3345: --

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

3347: close c_plbnf ;
3348:
3349:
3350: --
3351: hr_utility.set_location('Leaving '||l_proc , 100);
3352: --
3353: EXCEPTION
3354: WHEN OTHERS THEN
3355: RAISE;

Line 3467: --hr_utility.trace_on(null,'oracle');

3463: l_threads number(5) := 1;
3464: l_max_person_err Number := 100;
3465:
3466: begin
3467: --hr_utility.trace_on(null,'oracle');
3468: hr_utility.set_location ('Entering ' || l_proc, 10);
3469:
3470: ben_batch_utils.g_audit_flag := true;
3471:

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

3464: l_max_person_err Number := 100;
3465:
3466: begin
3467: --hr_utility.trace_on(null,'oracle');
3468: hr_utility.set_location ('Entering ' || l_proc, 10);
3469:
3470: ben_batch_utils.g_audit_flag := true;
3471:
3472: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));

Line 3474: hr_utility.set_location ('hr_api.mandatory_arg_error',100);

3470: ben_batch_utils.g_audit_flag := true;
3471:
3472: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
3473:
3474: hr_utility.set_location ('hr_api.mandatory_arg_error',100);
3475: hr_api.mandatory_arg_error
3476: (p_api_name => l_proc
3477: ,p_argument => 'p_person_id'
3478: ,p_argument_value => p_person_id);

Line 3482: --hr_utility.set_location ('ben_batch_utils.ini',101);

3478: ,p_argument_value => p_person_id);
3479:
3480: -- Initialize the batch process.
3481: --
3482: --hr_utility.set_location ('ben_batch_utils.ini',101);
3483: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
3484:
3485: benutils.get_parameter
3486: (p_business_group_id => p_business_group_id

Line 3492: --hr_utility.set_location ('ben_benefit_actions_api.create_benefit_actions',102);

3488: ,p_threads => l_threads
3489: ,p_chunk_size => l_chunk_size
3490: ,p_max_errors => l_max_person_err);
3491:
3492: --hr_utility.set_location ('ben_benefit_actions_api.create_benefit_actions',102);
3493: ben_benefit_actions_api.create_benefit_actions
3494: (p_validate => FALSE
3495: ,p_benefit_action_id => l_benefit_action_id
3496: ,p_process_date => l_effective_date

Line 3513: --hr_utility.set_location ('After ben_benefit_actions_api.create_benefit_actions',103);

3509: ,p_program_application_id => fnd_global.prog_appl_id
3510: ,p_program_id => fnd_global.conc_program_id
3511: ,p_program_update_date => sysdate
3512: );
3513: --hr_utility.set_location ('After ben_benefit_actions_api.create_benefit_actions',103);
3514:
3515: benutils.g_benefit_action_id := l_benefit_action_id;
3516:
3517: -- Create a person action row.

Line 3519: --hr_utility.set_location('ben_person_actions_api.create_person_actions',104);

3515: benutils.g_benefit_action_id := l_benefit_action_id;
3516:
3517: -- Create a person action row.
3518: --
3519: --hr_utility.set_location('ben_person_actions_api.create_person_actions',104);
3520: ben_person_actions_api.create_person_actions
3521: (p_validate => FALSE
3522: ,p_person_action_id => l_person_action_id
3523: ,p_person_id => p_person_id

Line 3530: hr_utility.set_location ('creating savepoint',105);

3526: ,p_object_version_number => l_object_version_number
3527: ,p_effective_date => l_effective_date);
3528: commit;
3529:
3530: hr_utility.set_location ('creating savepoint',105);
3531: SAVEPOINT scheddu_le_data_del;
3532:
3533: ben_batch_utils.write(p_text => 'Get per_in_ler_id of Unrestricted LE');
3534: open c_get_pil;

Line 3555: hr_utility.set_location('Element entry Id '||l_ele_rec.ele_entry_id,50);

3551: else
3552: close c_chk_payroll_run;
3553: ben_batch_utils.write(p_text => ' Deleting Element Entries ');
3554: for l_ele_rec in c_element_entries loop
3555: hr_utility.set_location('Element entry Id '||l_ele_rec.ele_entry_id,50);
3556: hr_utility.set_location('l_ele_rec.esd '||l_ele_rec.esd,60);
3557: ben_batch_utils.write(p_text => ' Deleting Element Entry '||l_ele_rec.ele_entry_id);
3558: py_element_entry_api.delete_element_entry
3559: (p_validate => l_validate

Line 3556: hr_utility.set_location('l_ele_rec.esd '||l_ele_rec.esd,60);

3552: close c_chk_payroll_run;
3553: ben_batch_utils.write(p_text => ' Deleting Element Entries ');
3554: for l_ele_rec in c_element_entries loop
3555: hr_utility.set_location('Element entry Id '||l_ele_rec.ele_entry_id,50);
3556: hr_utility.set_location('l_ele_rec.esd '||l_ele_rec.esd,60);
3557: ben_batch_utils.write(p_text => ' Deleting Element Entry '||l_ele_rec.ele_entry_id);
3558: py_element_entry_api.delete_element_entry
3559: (p_validate => l_validate
3560: ,p_datetrack_delete_mode => hr_api.g_zap

Line 3583: hr_utility.set_location('No Unrestricted LE exists for the employee',80);

3579: end if;
3580: else
3581: close c_get_pil;
3582: ben_batch_utils.write(p_text => 'No Unrestricted LE exists for the employee. Error the process');
3583: hr_utility.set_location('No Unrestricted LE exists for the employee',80);
3584: fnd_message.raise_error;
3585: end if;
3586:
3587: l_thread_id := 99;

Line 3615: hr_utility.set_location('Unhandled exception',100);

3611: update ben_person_actions
3612: set action_status_cd = 'E'
3613: where person_action_id = l_person_action_id;
3614: commit;
3615: hr_utility.set_location('Unhandled exception',100);
3616: fnd_message.raise_error;
3617: end delete_unrestricted_le_enrts;
3618:
3619: --