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

1191:
1192: --
1193: l_id NUMBER;
1194: BEGIN
1195: hr_utility.set_location('Entering: '||l_proc,10);
1196: FOR l_ecd IN c_ecd LOOP
1197: FOR l_crt_ordr_cvrd IN c_crt_ordr_cvrd (
1198: l_ecd.dpnt_person_id
1199: ) LOOP

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

1199: ) LOOP
1200: DELETE FROM ben_crt_ordr_cvrd_per
1201: WHERE CURRENT OF c_crt_ordr_cvrd;
1202: END LOOP;
1203: hr_utility.set_location(l_proc, 15);
1204: FOR l_cvrd_dpnt IN c_cvrd_dpnt (
1205: l_ecd.elig_cvrd_dpnt_id
1206: ) LOOP
1207: DELETE ben_cvrd_dpnt_ctfn_prvdd_f

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

1206: ) LOOP
1207: DELETE ben_cvrd_dpnt_ctfn_prvdd_f
1208: WHERE CURRENT OF c_cvrd_dpnt;
1209: END LOOP;
1210: hr_utility.set_location(l_proc, 20);
1211: OPEN c1 (
1212: l_ecd.elig_cvrd_dpnt_id
1213: );
1214: <>

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

1218: DELETE ben_prtt_enrt_actn_f
1219: WHERE CURRENT OF c1;
1220: END LOOP ben_prtt_enrt_actn_f;
1221: CLOSE c1;
1222: hr_utility.set_location(l_proc, 25);
1223: OPEN c2 (
1224: l_ecd.elig_cvrd_dpnt_id
1225: );
1226: <>

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

1230: DELETE ben_prmry_care_prvdr_f
1231: WHERE CURRENT OF c2;
1232: END LOOP ben_prmry_care_prvdr_f;
1233: CLOSE c2;
1234: hr_utility.set_location(l_proc, 30);
1235: OPEN c3 (
1236: l_ecd.elig_cvrd_dpnt_id
1237: );
1238: <>

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

1242: DELETE ben_cvrd_dpnt_ctfn_prvdd_f
1243: WHERE CURRENT OF c3;
1244: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;
1245: CLOSE c3;
1246: hr_utility.set_location(l_proc, 35);
1247: /* OPEN c4 (
1248: l_ecd.elig_cvrd_dpnt_id
1249: );
1250: <>

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

1254: DELETE ben_elig_cvrd_dpnt_f
1255: WHERE CURRENT OF c4;
1256: END LOOP ben_elig_cvrd_dpnt_f;
1257: CLOSE c4; */
1258: hr_utility.set_location(l_proc, 40);
1259: OPEN c5 (
1260: l_ecd.elig_cvrd_dpnt_id
1261: );
1262: <>

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

1266: DELETE ben_elig_dpnt
1267: WHERE CURRENT OF c5;
1268: END LOOP ben_elig_dpnt;
1269: CLOSE c5;
1270: hr_utility.set_location(l_proc, 45);
1271: OPEN c6 (
1272: l_ecd.elig_cvrd_dpnt_id
1273: );
1274: <>

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

1278: DELETE FROM ben_ext_crit_val
1279: WHERE CURRENT OF c6;
1280: END LOOP ben_ext_crit_val;
1281: CLOSE c6;
1282: hr_utility.set_location(l_proc, 50);
1283: OPEN c7 (
1284: l_ecd.elig_cvrd_dpnt_id
1285: );
1286: <>

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

1293: CLOSE c7;
1294: DELETE ben_elig_cvrd_dpnt_f
1295: WHERE CURRENT OF c_ecd;
1296: END LOOP;
1297: hr_utility.set_location('Leaving: '||l_proc,999);
1298: END delete_dependent_information;
1299:
1300: --
1301: PROCEDURE delete_communications (

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

1337: WHERE per_cm_id = p_per_cm_id
1338: FOR UPDATE OF per_cm_usg_id;
1339: l_id NUMBER;
1340: BEGIN
1341: hr_utility.set_location('Entering: '||l_proc,20);
1342: FOR r1 IN c1 LOOP
1343: OPEN c2 (
1344: r1.per_cm_id
1345: );

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

1373: WHERE CURRENT OF c4;
1374: END LOOP ben_per_cm_usg_f;
1375: CLOSE c4;
1376: END LOOP;
1377: hr_utility.set_location('Leaving: '||l_proc,999);
1378: END delete_communications;
1379:
1380: --
1381: PROCEDURE delete_life_events (

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

1656:
1657: --
1658: l_id NUMBER;
1659: BEGIN
1660: hr_utility.set_location('Entering: '||l_proc,10);
1661: FOR r1 IN c1 LOOP
1662: FOR r2 IN c2 (
1663: r1.per_in_ler_id
1664: ) LOOP

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

1780: WHERE CURRENT OF c14;
1781: END LOOP ben_cvrd_dpnt_ctfn_prvdd_f;
1782: CLOSE c14;
1783: END LOOP;
1784: hr_utility.set_location(l_proc,50);
1785: FOR r15 IN c15 (
1786: r1.per_in_ler_id
1787: ) LOOP
1788: OPEN c16 (

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

1796: WHERE CURRENT OF c16;
1797: END LOOP;
1798: CLOSE c16;
1799: END LOOP;
1800: hr_utility.set_location(l_proc,55);
1801: FOR r17 IN c17 (
1802: r1.per_in_ler_id
1803: ) LOOP
1804: OPEN c18 (

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

1812: WHERE CURRENT OF c18;
1813: END LOOP ben_enrt_bnft;
1814: CLOSE c18;
1815: --
1816: hr_utility.set_location(l_proc,60);
1817: OPEN c19 (
1818: r17.elig_per_elctbl_chc_id
1819: );
1820: <>

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

1825: WHERE CURRENT OF c19;
1826: END LOOP;
1827: CLOSE c19;
1828: --
1829: hr_utility.set_location(l_proc,65);
1830: OPEN c20 (
1831: r17.elig_per_elctbl_chc_id
1832: );
1833: <>

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

1838: WHERE CURRENT OF c20;
1839: END LOOP ben_enrt_rt;
1840: CLOSE c20;
1841: --
1842: hr_utility.set_location(l_proc,70);
1843: OPEN c21 (
1844: r17.elig_per_elctbl_chc_id
1845: );
1846: <>

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

1851: WHERE CURRENT OF c21;
1852: END LOOP ben_elctbl_chc_ctfn;
1853: CLOSE c21;
1854: END LOOP;
1855: hr_utility.set_location(l_proc,70);
1856: FOR r22 IN c22 (
1857: r1.per_in_ler_id
1858: ) LOOP
1859: OPEN c23 (

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

1892: CLOSE c25;
1893: OPEN c26 (
1894: r1.per_in_ler_id
1895: );
1896: hr_utility.set_location(l_proc,90);
1897: <>
1898: LOOP
1899: FETCH c26 INTO l_id;
1900: EXIT WHEN c26%NOTFOUND;

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

1957: WHERE CURRENT OF c31;
1958: END LOOP ben_prtt_enrt_rslt_f;
1959: CLOSE c31;
1960: END LOOP;
1961: hr_utility.set_location('Leaving: '||l_proc,999);
1962: END delete_life_events;
1963:
1964: --
1965: PROCEDURE delete_participant_information (

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

2039: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2040: FOR UPDATE OF prtt_enrt_actn_id;
2041: l_id NUMBER;
2042: BEGIN
2043: hr_utility.set_location('Entering: '||l_proc,10);
2044: FOR r1 IN c1 (
2045: p_person_id
2046: ) LOOP
2047: OPEN c2 (

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

2121: WHERE CURRENT OF c8;
2122: END LOOP ben_prtt_enrt_actn_f;
2123: CLOSE c8;
2124: END LOOP;
2125: hr_utility.set_location('Leaving: '||l_proc,999);
2126: END delete_participant_information;
2127:
2128: --
2129: PROCEDURE delete_benefit_action_children (

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

2163:
2164: --
2165: l_id NUMBER;
2166: BEGIN
2167: hr_utility.set_location('Entering: '||l_proc,10);
2168: FOR r1 IN c1 LOOP
2169: OPEN c2 (
2170: r1.benefit_action_id
2171: );

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

2199: WHERE CURRENT OF c4;
2200: END LOOP ben_batch_ranges;
2201: CLOSE c4;
2202: END LOOP;
2203: hr_utility.set_location('Leaving: '||l_proc,999);
2204: END delete_benefit_action_children;
2205:
2206: --
2207: PROCEDURE delete_reimbmt_rqst (

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

3121:
3122:
3123: l_dummy varchar2(1) := 'N' ;
3124: BEGIN
3125: hr_utility.set_location('Entering '||l_proc , 10);
3126: --check for per_in_ler in started status. Exclude the unrestricted cases
3127: open c_pil(p_person_id,p_effective_date) ;
3128: --
3129: fetch c_pil into l_dummy ;

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

3128: --
3129: fetch c_pil into l_dummy ;
3130: if c_pil%found then
3131: --
3132: hr_utility.set_location('Started Pil exist for person '||p_person_id , 20);
3133: close c_pil ;
3134: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3135: fnd_message.set_token('BEN_ITEM','Life Event');
3136: fnd_message.raise_error;

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

3142: --
3143: fetch c_pen into l_dummy ;
3144: if c_pen%found then
3145: --
3146: hr_utility.set_location('Started pen exist for person '||p_person_id , 30);
3147: close c_pen ;
3148: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3149: fnd_message.set_token('BEN_ITEM','Enrollment');
3150: fnd_message.raise_error;

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

3156: --
3157: fetch c_prv into l_dummy ;
3158: if c_prv%found then
3159: --
3160: hr_utility.set_location('Started prv exist for person '||p_person_id , 40);
3161: close c_prv ;
3162: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3163: fnd_message.set_token('BEN_ITEM','Rate');
3164: fnd_message.raise_error;

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

3170: --
3171: fetch c_ecd into l_dummy ;
3172: if c_ecd%found then
3173: --
3174: hr_utility.set_location('Started ecd exist for person '||p_person_id , 50);
3175: close c_ecd ;
3176: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3177: fnd_message.set_token('BEN_ITEM','Dependents');
3178: fnd_message.raise_error;

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

3185: --
3186: fetch c_ecdpn into l_dummy ;
3187: if c_ecdpn%found then
3188: --
3189: hr_utility.set_location('Started ecdpn exist for person '||p_person_id , 50);
3190: close c_ecdpn ;
3191: fnd_message.set_name('BEN', 'BEN_93910_DPTN_CVRD');
3192: fnd_message.raise_error;
3193: --

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

3199: --
3200: fetch c_plbnf into l_dummy ;
3201: if c_plbnf%found then
3202: --
3203: hr_utility.set_location('Started ecdpn exist for person '||p_person_id , 50);
3204: close c_plbnf ;
3205: fnd_message.set_name('BEN', 'BEN_93911_DPT_DESIG_BNF');
3206: fnd_message.raise_error;
3207: --

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

3209: close c_plbnf ;
3210:
3211:
3212: --
3213: hr_utility.set_location('Leaving '||l_proc , 100);
3214: --
3215: EXCEPTION
3216: WHEN OTHERS THEN
3217: RAISE;