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

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

209: l_proc varchar2(80) := g_package || '.seconds_to_hours';
210: --
211: begin
212: --
213: hr_utility.set_location('Entering : ' || l_proc, 10);
214: --
215: l_hours := to_char(floor(p_seconds/3600));
216: l_minutes := to_char(floor(mod(p_seconds, 3600)/60));
217: l_seconds := to_char(mod(p_seconds, 60));

Line 231: hr_utility.set_location('Leaving : ' || l_proc, 10);

227: if length(l_seconds) = 1 then
228: l_seconds := '0' || l_seconds;
229: end if;
230: --
231: hr_utility.set_location('Leaving : ' || l_proc, 10);
232: --
233: return l_hours || 'h : ' || l_minutes || 'm : ' || l_seconds || 's';
234: --
235: end seconds_to_hours;

Line 275: hr_utility.set_location ('Entering '||l_proc,05);

271: l_actn varchar2(80);
272: l_request_id number;
273: begin
274: --
275: hr_utility.set_location ('Entering '||l_proc,05);
276: --
277: -- Fire off the following Reports for BENTMPCM run.
278: -- * Audit Log
279: -- * Activity Summary

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

342: and pac.action_status_cd = nvl(p_status_cd,pac.action_status_cd);
343: --
344: begin
345: --
346: hr_utility.set_location('Entering : ' || l_proc, 10);
347: --
348: -- Check if process is master
349: --
350: open c_master;

Line 435: hr_utility.set_location('Leaving : ' || l_proc, 10);

431: commit;
432: --
433: end if;
434: --
435: hr_utility.set_location('Leaving : ' || l_proc, 10);
436: --
437: end check_all_slaves_finished;
438: --
439: -- ----------------------------------------------------------------------------

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

447: l_proc varchar2(80) := g_package || '.person_error_cnt';
448: --
449: begin
450: --
451: hr_utility.set_location('Entering : ' || l_proc, 10);
452: --
453: -- Increment the error count
454: --
455: g_error_person_cnt := g_error_person_cnt + 1;

Line 463: hr_utility.set_location('Leaving : ' || l_proc, 10);

459: if g_error_person_cnt > g_max_errors then
460: raise error_limit;
461: end if;
462: --
463: hr_utility.set_location('Leaving : ' || l_proc, 10);
464: --
465: exception
466: --
467: when error_limit then

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

481: l_proc varchar2(80) := g_package || '.write_logfile';
482: --
483: begin
484: --
485: hr_utility.set_location('Entering : ' || l_proc, 10);
486: --
487: benutils.write(p_text => benutils.g_banner_minus);
488: benutils.write(p_text => 'Batch Process Statistical Information');
489: benutils.write(p_text => benutils.g_banner_minus);

Line 498: hr_utility.set_location('Leaving : ' || l_proc, 10);

494: benutils.write_table_and_file(p_table => false
495: ,p_file => true);
496: commit;
497: --
498: hr_utility.set_location('Leaving : ' || l_proc, 10);
499: --
500: exception
501: --
502: when others then

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

519: --
520: l_rec benutils.g_batch_param_rec;
521: begin
522: --
523: hr_utility.set_location('Entering : ' || l_proc, 10);
524: --
525: if fnd_global.conc_request_id = -1 then
526: return;
527: end if;

Line 721: hr_utility.set_location('Leaving : ' || l_proc, 10);

717: fnd_file.put_line(which => fnd_file.log
718: ,buff => 'Audit Log Flag : ' ||
719: hr_general.decode_lookup('YES_NO',g_parm.audit_log_flag));
720: --
721: hr_utility.set_location('Leaving : ' || l_proc, 10);
722: --
723: end print_parameters;
724: --
725: procedure set_object(p_rec in g_cache_pl_fctr_rec_type) is

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

729: l_not_hash_found boolean;
730: --
731: begin
732: --
733: hr_utility.set_location('Entering '||l_proc,10);
734: --
735: -- 1) get hash index
736: -- 2) If hash index is not used use hash index
737: -- 3) If hash index is used and correct then do nothing

Line 794: hr_utility.set_location('Leaving '||l_proc,10);

790: end if;
791: --
792: end if;
793: --
794: hr_utility.set_location('Leaving '||l_proc,10);
795: --
796: end set_object;
797:
798:

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

803: l_not_hash_found boolean;
804: --
805: begin
806: --
807: hr_utility.set_location('Entering '||l_proc,10);
808: --
809: -- 1) get hash index
810: -- 2) If hash index is not used use hash index
811: -- 3) If hash index is used and correct then do nothing

Line 868: hr_utility.set_location('Leaving '||l_proc,10);

864: end if;
865: --
866: end if;
867: --
868: hr_utility.set_location('Leaving '||l_proc,10);
869: --
870: end set_object;
871: --
872: --

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

957: l_plip_fctr_rec g_cache_plip_fctr_rec_type;
958: --
959: begin
960: --
961: hr_utility.set_location('Entering '||l_proc,10);
962: --
963: -- 1) Get record from database.
964: -- 2) If record not found then raise error.
965: -- 3) Pass record to set_object routine.

Line 1038: hr_utility.set_location('Leaving '||l_proc,10);

1034: --
1035: p_pl_fctr_rec := l_pl_fctr_rec;
1036: p_plip_fctr_rec := l_plip_fctr_rec;
1037: --
1038: hr_utility.set_location('Leaving '||l_proc,10);
1039: --
1040: end set_fctr_object;
1041:
1042: --

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

1050: l_plip_fctr_rec g_cache_plip_fctr_rec_type;
1051: --
1052: begin
1053: --
1054: hr_utility.set_location('Entering '||l_proc,10);
1055: --
1056: if g_cache_last_pl_fctr_rec.pl_id = p_pl_id then
1057: --
1058: p_rec := g_cache_last_pl_fctr_rec;

Line 1125: hr_utility.set_location('Leaving '||l_proc,10);

1121: raise no_data_found;
1122: --
1123: end if;
1124: --
1125: hr_utility.set_location('Leaving '||l_proc,10);
1126: --
1127: exception
1128: --
1129: when no_data_found then

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

1153: l_pl_fctr_rec g_cache_pl_fctr_rec_type;
1154: --
1155: begin
1156: --
1157: hr_utility.set_location('Entering '||l_proc,10);
1158: --
1159: if g_cache_last_plip_fctr_rec.plip_id = p_plip_id then
1160: --
1161: p_rec := g_cache_last_plip_fctr_rec;

Line 1228: hr_utility.set_location('Leaving '||l_proc,10);

1224: raise no_data_found;
1225: --
1226: end if;
1227: --
1228: hr_utility.set_location('Leaving '||l_proc,10);
1229: --
1230: exception
1231: --
1232: when no_data_found then

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

1277: l_proc varchar2(80) := g_package || '.fctr_belongs_to_comp_object';
1278: --
1279: begin
1280: --
1281: hr_utility.set_location('Entering '||l_proc,10);
1282: --
1283: if p_pgm_id is not null then
1284: --
1285: open c_get_pl_details;

Line 1309: hr_utility.set_location('Leaving '||l_proc,10);

1305: end if;
1306: --
1307: end if;
1308: --
1309: hr_utility.set_location('Leaving '||l_proc,10);
1310: --
1311: return l_return;
1312: --
1313: end fctr_belongs_to_comp_object;

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

1321: l_proc varchar2(80) := g_package || '.chk_per_cm';
1322: --
1323: begin
1324: --
1325: hr_utility.set_location('Entering : ' || l_proc, 10);
1326: --
1327: g_rec.person_id := p_person_id;
1328: --
1329: if ben_generate_communications.g_comm_generated then

Line 1347: hr_utility.set_location('Leaving : ' || l_proc, 10);

1343: end if;
1344: --
1345: benutils.write(p_rec => g_rec);
1346: --
1347: hr_utility.set_location('Leaving : ' || l_proc, 10);
1348: --
1349: end chk_per_cm;
1350: --
1351: -- ----------------------------------------------------------------------------

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

1371: l_proc varchar2(80) := g_package || '.get_main_person_id';
1372: --
1373: begin
1374: --
1375: hr_utility.set_location('Entering : ' || l_proc, 10);
1376: --
1377: open c_per;
1378: fetch c_per into l_person_id;
1379: close c_per;

Line 1381: hr_utility.set_location('Leaving : ' || l_proc, 10);

1377: open c_per;
1378: fetch c_per into l_person_id;
1379: close c_per;
1380: --
1381: hr_utility.set_location('Leaving : ' || l_proc, 10);
1382: --
1383: return l_person_id;
1384: --
1385: end get_main_person_id;

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

1401: l_proc varchar2(80) := g_package || '.get_person_type';
1402: --
1403: begin
1404: --
1405: hr_utility.set_location('Entering : ' || l_proc, 10);
1406: --
1407: open c_person_type;
1408: fetch c_person_type into l_type;
1409: close c_person_type;

Line 1411: hr_utility.set_location('Leaving : ' || l_proc, 10);

1407: open c_person_type;
1408: fetch c_person_type into l_type;
1409: close c_person_type;
1410: --
1411: hr_utility.set_location('Leaving : ' || l_proc, 10);
1412: --
1413: return(l_type);
1414: --
1415: exception

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

1482: l_proc varchar2(80) := g_package || '.is_dependent';
1483: --
1484: begin
1485: --
1486: hr_utility.set_location('Entering : ' || l_proc, 10);
1487: --
1488: open c_dpnt;
1489: fetch c_dpnt into l_exists;
1490: close c_dpnt;

Line 1496: hr_utility.set_location('Person id DPNT',10);

1492: if l_exists = 'Y' then
1493: --
1494: l_return := true;
1495: --
1496: hr_utility.set_location('Person id DPNT',10);
1497: end if;
1498: --
1499: hr_utility.set_location('Leaving : ' || l_proc, 10);
1500: --

Line 1499: hr_utility.set_location('Leaving : ' || l_proc, 10);

1495: --
1496: hr_utility.set_location('Person id DPNT',10);
1497: end if;
1498: --
1499: hr_utility.set_location('Leaving : ' || l_proc, 10);
1500: --
1501: return(l_return);
1502: --
1503: exception

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

1529: l_proc varchar2(80) := g_package || '.is_dependent_emp';
1530: --
1531: begin
1532: --
1533: hr_utility.set_location('Entering : ' || l_proc, 10);
1534: --
1535: open c_dpnt;
1536: fetch c_dpnt into l_exists;
1537: close c_dpnt;

Line 1543: hr_utility.set_location('Person id EMP',10);

1539: if l_exists = 'Y' then
1540: --
1541: l_return := true;
1542: --
1543: hr_utility.set_location('Person id EMP',10);
1544: end if;
1545: --
1546: hr_utility.set_location('Leaving : ' || l_proc, 10);
1547: --

Line 1546: hr_utility.set_location('Leaving : ' || l_proc, 10);

1542: --
1543: hr_utility.set_location('Person id EMP',10);
1544: end if;
1545: --
1546: hr_utility.set_location('Leaving : ' || l_proc, 10);
1547: --
1548: return(l_return);
1549: --
1550: exception

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

1580: l_proc varchar2(80) := g_package || '.check_business_rules';
1581: --
1582: begin
1583: --
1584: hr_utility.set_location ('Entering '||l_proc,10);
1585: --
1586: -- This procedure checks validity of parameters that have been passed to the
1587: -- BENTMPCM process.
1588: --

Line 1917: hr_utility.set_location ('Leaving '||l_proc,10);

1913: end if;
1914: --
1915: end if; -- g_parm.cm_trgr_typ_cd = MSSMLG
1916: --
1917: hr_utility.set_location ('Leaving '||l_proc,10);
1918: --
1919: end check_business_rules;
1920: --
1921: -- ----------------------------------------------------------------------------

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

1968: l_proc varchar2(80) := g_package || '.process_age';
1969: --
1970: begin
1971: --
1972: hr_utility.set_location('Entering : ' || l_proc, 10);
1973: --
1974: hr_utility.set_location('Processing age for person ID : ' || p_person_id, 10);
1975: --
1976: -- Get the person's date of birth

Line 1974: hr_utility.set_location('Processing age for person ID : ' || p_person_id, 10);

1970: begin
1971: --
1972: hr_utility.set_location('Entering : ' || l_proc, 10);
1973: --
1974: hr_utility.set_location('Processing age for person ID : ' || p_person_id, 10);
1975: --
1976: -- Get the person's date of birth
1977: --
1978: open c_person;

Line 2048: hr_utility.set_location('Calculating user specified age ' || l_proc, 10);

2044: -- An age factor not specified. But a min age or a max age was specified.
2045: -- Evaluate if the person's age will cross either the min or max boundary
2046: -- in the date range (date_from to effective_date) specified.
2047: --
2048: hr_utility.set_location('Calculating user specified age ' || l_proc, 10);
2049: --
2050: l_age_before := months_between(l_effective_date - 1, l_dob )/12;
2051: l_age_after := months_between(g_parm.effective_date, l_dob)/12;
2052: l_uom := 'YR';

Line 2056: hr_utility.set_location('Age Before'||l_age_before,10);

2052: l_uom := 'YR';
2053: l_min_value := g_parm.min_age;
2054: l_max_value := g_parm.max_age;
2055: --
2056: hr_utility.set_location('Age Before'||l_age_before,10);
2057: hr_utility.set_location('Age After'||l_age_after,10);
2058: hr_utility.set_location('Min Value'||l_min_value,10);
2059: hr_utility.set_location('Max Value'||l_max_value,10);
2060: --

Line 2057: hr_utility.set_location('Age After'||l_age_after,10);

2053: l_min_value := g_parm.min_age;
2054: l_max_value := g_parm.max_age;
2055: --
2056: hr_utility.set_location('Age Before'||l_age_before,10);
2057: hr_utility.set_location('Age After'||l_age_after,10);
2058: hr_utility.set_location('Min Value'||l_min_value,10);
2059: hr_utility.set_location('Max Value'||l_max_value,10);
2060: --
2061: end if; -- g_parm.age_fctr_id

Line 2058: hr_utility.set_location('Min Value'||l_min_value,10);

2054: l_max_value := g_parm.max_age;
2055: --
2056: hr_utility.set_location('Age Before'||l_age_before,10);
2057: hr_utility.set_location('Age After'||l_age_after,10);
2058: hr_utility.set_location('Min Value'||l_min_value,10);
2059: hr_utility.set_location('Max Value'||l_max_value,10);
2060: --
2061: end if; -- g_parm.age_fctr_id
2062: --

Line 2059: hr_utility.set_location('Max Value'||l_max_value,10);

2055: --
2056: hr_utility.set_location('Age Before'||l_age_before,10);
2057: hr_utility.set_location('Age After'||l_age_after,10);
2058: hr_utility.set_location('Min Value'||l_min_value,10);
2059: hr_utility.set_location('Max Value'||l_max_value,10);
2060: --
2061: end if; -- g_parm.age_fctr_id
2062: --
2063: -- Check if a breach occures.

Line 2088: hr_utility.set_location('Leaving : ' || l_proc, 10);

2084: p_breach := false;
2085: --
2086: end if;
2087: --
2088: hr_utility.set_location('Leaving : ' || l_proc, 10);
2089: --
2090: exception
2091: --
2092: when dob_null then

Line 2093: hr_utility.set_location('Exception raised in ' || l_proc, 10);

2089: --
2090: exception
2091: --
2092: when dob_null then
2093: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2094: fnd_message.set_name('BEN', 'BEN_91337_DOB');
2095: fnd_message.set_token('PROC',l_proc);
2096: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2097: -- The person being processed does not have a date of birth.

Line 2101: hr_utility.set_location('Exception raised in ' || l_proc, 10);

2097: -- The person being processed does not have a date of birth.
2098: raise ben_manage_life_events.g_record_error;
2099: --
2100: when agf_pgm_or_pl then
2101: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2102: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2103: fnd_message.set_token('PROC',l_proc);
2104: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2105: --

Line 2112: hr_utility.set_location('Exception raised in ' || l_proc, 10);

2108: --
2109: raise ben_manage_life_events.g_record_error;
2110: --
2111: when others then
2112: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2113: -- For nocopy changes
2114: p_lf_evt_ocrd_dt := null;
2115: p_breach := false;
2116: --

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

2159: l_proc varchar2(80) := g_package || '.calculate_los';
2160: --
2161: begin
2162: --
2163: hr_utility.set_location('Entering : ' || l_proc, 10);
2164: --
2165: hr_utility.set_location('Person ID : ' || p_person_id, 10);
2166: --
2167: open c_person;

Line 2165: hr_utility.set_location('Person ID : ' || p_person_id, 10);

2161: begin
2162: --
2163: hr_utility.set_location('Entering : ' || l_proc, 10);
2164: --
2165: hr_utility.set_location('Person ID : ' || p_person_id, 10);
2166: --
2167: open c_person;
2168: fetch c_person into l_start_date,
2169: l_adj_svc_date;

Line 2243: hr_utility.set_location('Calculating user specified LOS ' || l_proc, 10);

2239: -- An LOS factor not specified. But a min LOS or a max LOS was specified.
2240: -- Evaluate if the person's LOS will cross either the min or max boundary
2241: -- in the date range (date_from to effective_date) specified.
2242: --
2243: hr_utility.set_location('Calculating user specified LOS ' || l_proc, 10);
2244: --
2245: l_los_before := months_between(l_effective_date - 1, l_start_date )/12;
2246: l_los_after := months_between(g_parm.effective_date, l_start_date)/12;
2247: l_uom := 'YR';

Line 2277: hr_utility.set_location('Leaving : ' || l_proc, 10);

2273: p_breach := false;
2274: --
2275: end if;
2276: --
2277: hr_utility.set_location('Leaving : ' || l_proc, 10);
2278: --
2279: exception
2280: --
2281: when lsf_pgm_or_pl then

Line 2283: hr_utility.set_location('Leaving : ' || l_proc, 10);

2279: exception
2280: --
2281: when lsf_pgm_or_pl then
2282: --
2283: hr_utility.set_location('Leaving : ' || l_proc, 10);
2284: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2285: fnd_message.set_token('PROC',l_proc);
2286: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2287: --

Line 2294: hr_utility.set_location('Exception raised in ' || l_proc, 10);

2290: --
2291: raise ben_manage_life_events.g_record_error;
2292: --
2293: when others then
2294: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2295: -- For nocopy changes
2296: p_lf_evt_ocrd_dt := null;
2297: p_breach := false;
2298: --

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

2352: l_proc varchar2(80) := g_package || '.process_cmbn_age_los';
2353: --
2354: begin
2355: --
2356: hr_utility.set_location('Entering : ' || l_proc, 10);
2357: --
2358: if g_parm.date_from is not null then
2359: --
2360: l_effective_date := g_parm.date_from;

Line 2455: hr_utility.set_location('Leaving : ' || l_proc, 10);

2451: p_breach := false;
2452: --
2453: end if;
2454: --
2455: hr_utility.set_location('Leaving : ' || l_proc, 10);
2456: --
2457: exception
2458: --
2459: when cmbn_pgm_or_pl then

Line 2460: hr_utility.set_location('Exception raised in ' || l_proc, 10);

2456: --
2457: exception
2458: --
2459: when cmbn_pgm_or_pl then
2460: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2461: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2462: fnd_message.set_token('PROC',l_proc);
2463: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2464: --

Line 2471: hr_utility.set_location('Exception raised in ' || l_proc, 10);

2467: --
2468: raise ben_manage_life_events.g_record_error;
2469: --
2470: when others then
2471: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2472: -- For nocopy changes
2473: p_lf_evt_ocrd_dt := null;
2474: p_breach := false;
2475: --

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

2502: l_proc varchar2(80) := g_package || '.process_emrg_events';
2503: --
2504: begin
2505: --
2506: hr_utility.set_location('Entering ' || l_proc, 10);
2507: --
2508: for l_per_rec in c_per_actn loop
2509: --
2510: g_person_cnt := g_person_cnt + 1;

Line 2525: hr_utility.set_location('Processing age ' || l_proc, 15);

2521: if g_parm.age_fctr_id is not null or
2522: g_parm.min_age is not null or
2523: g_parm.max_age is not null then
2524: --
2525: hr_utility.set_location('Processing age ' || l_proc, 15);
2526: --
2527: -- If we are processing emerging events for dependents, then get the
2528: -- main person id since the communication will be sent to participants.
2529: --

Line 2533: hr_utility.set_location('Dependent is Employee ', 15);

2529: --
2530: /* Bug 8364821: Added If else condition. If Dependent is an Employee, do not create communication on the
2531: Employee. Communication should be sent to the Dependent. If not send the Communication to the Employee */
2532: if is_dependent_emp(p_person_id => l_per_rec.person_id) then
2533: hr_utility.set_location('Dependent is Employee ', 15);
2534: l_person_id := l_per_rec.person_id;
2535: else
2536: hr_utility.set_location('Dependent is Dependent ', 15);
2537: l_person_id := get_main_person_id

Line 2536: hr_utility.set_location('Dependent is Dependent ', 15);

2532: if is_dependent_emp(p_person_id => l_per_rec.person_id) then
2533: hr_utility.set_location('Dependent is Employee ', 15);
2534: l_person_id := l_per_rec.person_id;
2535: else
2536: hr_utility.set_location('Dependent is Dependent ', 15);
2537: l_person_id := get_main_person_id
2538: (p_dpnt_person_id => l_per_rec.person_id);
2539: --
2540: l_dpnt_person_id := l_per_rec.person_id;

Line 2553: hr_utility.set_location('Processing LOS ' || l_proc, 15);

2549: elsif g_parm.los_fctr_id is not null or
2550: g_parm.min_los is not null or
2551: g_parm.max_los is not null then
2552: --
2553: hr_utility.set_location('Processing LOS ' || l_proc, 15);
2554: --
2555: l_person_id := l_per_rec.person_id;
2556: --
2557: -- Process the person's length of service to check if there is a breach.

Line 2566: hr_utility.set_location('Processing cmbn_age_los ' || l_proc, 15);

2562: ,p_breach => l_breach);
2563: --
2564: elsif g_parm.cmbn_age_los_fctr_id is not null then
2565: --
2566: hr_utility.set_location('Processing cmbn_age_los ' || l_proc, 15);
2567: --
2568: l_person_id := l_per_rec.person_id;
2569: --
2570: -- Process the person's combination of age and length of service.

Line 2578: hr_utility.set_location('Not calculating factors ' || l_proc, 15);

2574: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
2575: ,p_breach => l_breach);
2576: --
2577: else
2578: hr_utility.set_location('Not calculating factors ' || l_proc, 15);
2579: end if;
2580: --
2581: hr_utility.set_location('After processing...', 15);
2582: --

Line 2581: hr_utility.set_location('After processing...', 15);

2577: else
2578: hr_utility.set_location('Not calculating factors ' || l_proc, 15);
2579: end if;
2580: --
2581: hr_utility.set_location('After processing...', 15);
2582: --
2583: ben_generate_communications.g_comm_generated := false;
2584: --
2585: if l_breach then

Line 2587: hr_utility.set_location(l_person_id,10);

2583: ben_generate_communications.g_comm_generated := false;
2584: --
2585: if l_breach then
2586: --
2587: hr_utility.set_location(l_person_id,10);
2588: hr_utility.set_location(g_parm.cm_trgr_typ_cd,10);
2589: hr_utility.set_location(g_parm.cm_typ_id,10);
2590: hr_utility.set_location(g_parm.pgm_id,10);
2591: hr_utility.set_location(g_parm.pl_nip_id,10);

Line 2588: hr_utility.set_location(g_parm.cm_trgr_typ_cd,10);

2584: --
2585: if l_breach then
2586: --
2587: hr_utility.set_location(l_person_id,10);
2588: hr_utility.set_location(g_parm.cm_trgr_typ_cd,10);
2589: hr_utility.set_location(g_parm.cm_typ_id,10);
2590: hr_utility.set_location(g_parm.pgm_id,10);
2591: hr_utility.set_location(g_parm.pl_nip_id,10);
2592: hr_utility.set_location(l_dpnt_person_id,10);

Line 2589: hr_utility.set_location(g_parm.cm_typ_id,10);

2585: if l_breach then
2586: --
2587: hr_utility.set_location(l_person_id,10);
2588: hr_utility.set_location(g_parm.cm_trgr_typ_cd,10);
2589: hr_utility.set_location(g_parm.cm_typ_id,10);
2590: hr_utility.set_location(g_parm.pgm_id,10);
2591: hr_utility.set_location(g_parm.pl_nip_id,10);
2592: hr_utility.set_location(l_dpnt_person_id,10);
2593: hr_utility.set_location(g_parm.business_group_id,10);

Line 2590: hr_utility.set_location(g_parm.pgm_id,10);

2586: --
2587: hr_utility.set_location(l_person_id,10);
2588: hr_utility.set_location(g_parm.cm_trgr_typ_cd,10);
2589: hr_utility.set_location(g_parm.cm_typ_id,10);
2590: hr_utility.set_location(g_parm.pgm_id,10);
2591: hr_utility.set_location(g_parm.pl_nip_id,10);
2592: hr_utility.set_location(l_dpnt_person_id,10);
2593: hr_utility.set_location(g_parm.business_group_id,10);
2594: hr_utility.set_location(g_parm.effective_date,10);

Line 2591: hr_utility.set_location(g_parm.pl_nip_id,10);

2587: hr_utility.set_location(l_person_id,10);
2588: hr_utility.set_location(g_parm.cm_trgr_typ_cd,10);
2589: hr_utility.set_location(g_parm.cm_typ_id,10);
2590: hr_utility.set_location(g_parm.pgm_id,10);
2591: hr_utility.set_location(g_parm.pl_nip_id,10);
2592: hr_utility.set_location(l_dpnt_person_id,10);
2593: hr_utility.set_location(g_parm.business_group_id,10);
2594: hr_utility.set_location(g_parm.effective_date,10);
2595: hr_utility.set_location(l_lf_evt_ocrd_dt,10);

Line 2592: hr_utility.set_location(l_dpnt_person_id,10);

2588: hr_utility.set_location(g_parm.cm_trgr_typ_cd,10);
2589: hr_utility.set_location(g_parm.cm_typ_id,10);
2590: hr_utility.set_location(g_parm.pgm_id,10);
2591: hr_utility.set_location(g_parm.pl_nip_id,10);
2592: hr_utility.set_location(l_dpnt_person_id,10);
2593: hr_utility.set_location(g_parm.business_group_id,10);
2594: hr_utility.set_location(g_parm.effective_date,10);
2595: hr_utility.set_location(l_lf_evt_ocrd_dt,10);
2596: hr_utility.set_location(g_parm.mode_cd,10);

Line 2593: hr_utility.set_location(g_parm.business_group_id,10);

2589: hr_utility.set_location(g_parm.cm_typ_id,10);
2590: hr_utility.set_location(g_parm.pgm_id,10);
2591: hr_utility.set_location(g_parm.pl_nip_id,10);
2592: hr_utility.set_location(l_dpnt_person_id,10);
2593: hr_utility.set_location(g_parm.business_group_id,10);
2594: hr_utility.set_location(g_parm.effective_date,10);
2595: hr_utility.set_location(l_lf_evt_ocrd_dt,10);
2596: hr_utility.set_location(g_parm.mode_cd,10);
2597: ben_generate_communications.main

Line 2594: hr_utility.set_location(g_parm.effective_date,10);

2590: hr_utility.set_location(g_parm.pgm_id,10);
2591: hr_utility.set_location(g_parm.pl_nip_id,10);
2592: hr_utility.set_location(l_dpnt_person_id,10);
2593: hr_utility.set_location(g_parm.business_group_id,10);
2594: hr_utility.set_location(g_parm.effective_date,10);
2595: hr_utility.set_location(l_lf_evt_ocrd_dt,10);
2596: hr_utility.set_location(g_parm.mode_cd,10);
2597: ben_generate_communications.main
2598: (p_person_id => l_person_id

Line 2595: hr_utility.set_location(l_lf_evt_ocrd_dt,10);

2591: hr_utility.set_location(g_parm.pl_nip_id,10);
2592: hr_utility.set_location(l_dpnt_person_id,10);
2593: hr_utility.set_location(g_parm.business_group_id,10);
2594: hr_utility.set_location(g_parm.effective_date,10);
2595: hr_utility.set_location(l_lf_evt_ocrd_dt,10);
2596: hr_utility.set_location(g_parm.mode_cd,10);
2597: ben_generate_communications.main
2598: (p_person_id => l_person_id
2599: ,p_cm_trgr_typ_cd => g_parm.cm_trgr_typ_cd

Line 2596: hr_utility.set_location(g_parm.mode_cd,10);

2592: hr_utility.set_location(l_dpnt_person_id,10);
2593: hr_utility.set_location(g_parm.business_group_id,10);
2594: hr_utility.set_location(g_parm.effective_date,10);
2595: hr_utility.set_location(l_lf_evt_ocrd_dt,10);
2596: hr_utility.set_location(g_parm.mode_cd,10);
2597: ben_generate_communications.main
2598: (p_person_id => l_person_id
2599: ,p_cm_trgr_typ_cd => g_parm.cm_trgr_typ_cd
2600: ,p_cm_typ_id => g_parm.cm_typ_id

Line 2612: hr_utility.set_location('Here',10);

2608: ,p_mode => g_parm.mode_cd);
2609: --
2610: end if;
2611: --
2612: hr_utility.set_location('Here',10);
2613: if (g_parm.audit_log_flag = 'Y') then
2614: chk_per_cm(p_person_id => l_person_id);
2615: end if;
2616: --

Line 2622: hr_utility.set_location('Nearly Leaving Now',10);

2618: g_action_rec.action_status_cd := 'P';
2619: g_action_rec.object_version_number := l_per_rec.object_version_number;
2620: g_action_rec.effective_date := g_parm.effective_date;
2621: --
2622: hr_utility.set_location('Nearly Leaving Now',10);
2623: benutils.write(p_rec => g_action_rec);
2624: --
2625: hr_utility.set_location('Leaving Now',10);
2626: exception

Line 2625: hr_utility.set_location('Leaving Now',10);

2621: --
2622: hr_utility.set_location('Nearly Leaving Now',10);
2623: benutils.write(p_rec => g_action_rec);
2624: --
2625: hr_utility.set_location('Leaving Now',10);
2626: exception
2627: --
2628: when ben_manage_life_events.g_record_error then
2629: --

Line 2630: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);

2626: exception
2627: --
2628: when ben_manage_life_events.g_record_error then
2629: --
2630: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
2631: --
2632: rollback to before_communications;
2633: --
2634: g_rec.person_id := l_per_rec.person_id;

Line 2656: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);

2652: person_error_cnt;
2653: --
2654: when others then
2655: --
2656: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
2657: --
2658: rollback to before_communications;
2659: --
2660: g_rec.person_id := l_per_rec.person_id;

Line 2693: hr_utility.set_location('Leaving ' || l_proc, 10);

2689: ,p_file => true);
2690: --
2691: commit;
2692: --
2693: hr_utility.set_location('Leaving ' || l_proc, 10);
2694: --
2695: end process_emrg_events;
2696: --
2697: -- ----------------------------------------------------------------------------

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

2717: l_proc varchar2(80) := g_package || '.process_trgt_mass_mail';
2718: --
2719: begin
2720: --
2721: hr_utility.set_location('Entering ' || l_proc, 10);
2722: --
2723: for l_per_rec in c_per_actn loop
2724: --
2725: g_person_cnt := g_person_cnt + 1;

Line 2762: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);

2758: exception
2759: --
2760: when ben_manage_life_events.g_record_error then
2761: --
2762: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
2763: --
2764: rollback to before_communications;
2765: --
2766: g_rec.rep_typ_cd := 'ERRCM';

Line 2788: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);

2784: person_error_cnt;
2785: --
2786: when others then
2787: --
2788: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
2789: --
2790: rollback to before_communications;
2791: --
2792: g_rec.rep_typ_cd := 'FATAL';

Line 2825: hr_utility.set_location('Leaving ' || l_proc, 10);

2821: ,p_file => true);
2822: --
2823: commit;
2824: --
2825: hr_utility.set_location('Leaving ' || l_proc, 10);
2826: --
2827: end process_trgt_mass_mail;
2828: --
2829: -- ----------------------------------------------------------------------------

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

2848: l_proc varchar2(80) := g_package || '.process_actn_item_reminders';
2849: --
2850: begin
2851: --
2852: hr_utility.set_location('Entering : ' || l_proc, 10);
2853: --
2854: for l_per_rec in c_per_actn loop
2855: --
2856: hr_utility.set_location('Processing person ID : ' ||l_per_rec.person_id,10);

Line 2856: hr_utility.set_location('Processing person ID : ' ||l_per_rec.person_id,10);

2852: hr_utility.set_location('Entering : ' || l_proc, 10);
2853: --
2854: for l_per_rec in c_per_actn loop
2855: --
2856: hr_utility.set_location('Processing person ID : ' ||l_per_rec.person_id,10);
2857: --
2858: begin
2859: --
2860: -- Set a savepoint to rollback errors

Line 2898: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);

2894: exception
2895: --
2896: when ben_manage_life_events.g_record_error then
2897: --
2898: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
2899: --
2900: rollback to before_communications;
2901: --
2902: g_rec.rep_typ_cd := 'ERRCM';

Line 2924: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);

2920: person_error_cnt;
2921: --
2922: when others then
2923: --
2924: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
2925: --
2926: rollback to before_communications;
2927: --
2928: g_rec.rep_typ_cd := 'FATAL';

Line 2961: hr_utility.set_location('Leaving : ' || l_proc, 10);

2957: ,p_file => true);
2958: --
2959: commit;
2960: --
2961: hr_utility.set_location('Leaving : ' || l_proc, 10);
2962: --
2963: end process_actn_item_reminders;
2964: --
2965: -- ----------------------------------------------------------------------------

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

2986: l_asnd_lf_evt_dt date;
2987: --
2988: begin
2989: --
2990: hr_utility.set_location('Entering ' || l_proc, 10);
2991: --
2992: for l_per_rec in c_per_actn loop
2993: --
2994: g_person_cnt := g_person_cnt + 1;

Line 3037: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);

3033: exception
3034: --
3035: when ben_manage_life_events.g_record_error then
3036: --
3037: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
3038: --
3039: rollback to before_communications;
3040: --
3041: benutils.write(p_text => fnd_message.get);

Line 3065: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);

3061: person_error_cnt;
3062: --
3063: when others then
3064: --
3065: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
3066: --
3067: rollback to before_communications;
3068: --
3069: g_rec.rep_typ_cd := 'FATAL';

Line 3102: hr_utility.set_location('Leaving ' || l_proc, 10);

3098: ,p_file => true);
3099: --
3100: commit;
3101: --
3102: hr_utility.set_location('Leaving ' || l_proc, 10);
3103: --
3104: end process_enrt_reminders;
3105: --
3106: -- ----------------------------------------------------------------------------

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

3127: --
3128: begin
3129: --
3130: --
3131: hr_utility.set_location('Entering : ' || l_proc, 10);
3132: --
3133: -- get the parameters for a previous run and do a restart
3134: --
3135: open c_parm;

Line 3185: hr_utility.set_location('Leaving : ' || l_proc, 10);

3181: -- ,p_popl_enrt_typ_cycl_id => l_parm.popl_enrt_typ_cycl_id
3182: ,p_lf_evt_ocrd_dt => fnd_date.date_to_canonical(l_parm.lf_evt_ocrd_dt)
3183: ,p_audit_log_flag => l_parm.audit_log_flag);
3184: --
3185: hr_utility.set_location('Leaving : ' || l_proc, 10);
3186: --
3187: end restart;
3188: --
3189: -- ----------------------------------------------------------------------------

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

3253: l_commit number;
3254: --
3255: begin
3256: --
3257: hr_utility.set_location('Entering : ' || l_proc, 10);
3258: --
3259: -- Convert varchar2 dates to real dates
3260: -- 1) First remove time component
3261: -- 2) Next convert format

Line 3291: hr_utility.set_location(g_parm.business_group_id,100000);

3287: open c_parm;
3288: fetch c_parm into g_parm;
3289: close c_parm;
3290: --
3291: hr_utility.set_location(g_parm.business_group_id,100000);
3292: -- Set up benefits environment
3293: --
3294: ben_env_object.init(p_business_group_id => p_business_group_id,
3295: p_effective_date => l_effective_date,

Line 3371: hr_utility.set_location('Leaving : ' || l_proc, 10);

3367: -- Write statistics of the process to a log file
3368: --
3369: write_logfile;
3370: --
3371: hr_utility.set_location('Leaving : ' || l_proc, 10);
3372: --
3373: exception
3374: --
3375: when others then

Line 3379: hr_utility.set_location ('BENTMPCM Error '|| l_proc,10);

3375: when others then
3376: --
3377: rollback;
3378: benutils.write(p_text => sqlerrm);
3379: hr_utility.set_location ('BENTMPCM Error '|| l_proc,10);
3380: g_rec.rep_typ_cd := 'FATAL';
3381: g_rec.error_message_code := sqlcode;
3382: g_rec.text := fnd_message.get;
3383: benutils.write(p_rec => g_rec);

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

3424: l_proc varchar2(80) := g_package || '.create_actions_ranges';
3425: --
3426: begin
3427: --
3428: hr_utility.set_location('Entering : ' || l_proc, 10);
3429: --
3430: if g_parm.person_sel_rl is not null then
3431: --
3432: hr_utility.set_location('Verifying rul',10);

Line 3432: hr_utility.set_location('Verifying rul',10);

3428: hr_utility.set_location('Entering : ' || l_proc, 10);
3429: --
3430: if g_parm.person_sel_rl is not null then
3431: --
3432: hr_utility.set_location('Verifying rul',10);
3433: if not ben_rules.chk_person_selection
3434: (p_person_id => p_person_id
3435: ,p_business_group_id => g_parm.business_group_id
3436: ,p_person_selection_rule_id=> g_parm.person_sel_rl

Line 3449: -- hr_utility.set_location('Verifying person type',10);

3445: --
3446: --if not(verify_person_type_id(p_person_id => p_person_id,
3447: -- p_person_type_id => g_parm.person_type_id)) then
3448: -- --
3449: -- hr_utility.set_location('Verifying person type',10);
3450: -- l_person_ok := 'N';
3451: -- --
3452: --end if;
3453: --

Line 3500: hr_utility.set_location('Leaving : ' || l_proc, 10);

3496: end if;
3497: --
3498: end if;
3499: --
3500: hr_utility.set_location('Leaving : ' || l_proc, 10);
3501: --
3502: exception
3503: when others then
3504: -- For nocopy changes

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

3620: l_proc varchar2(80) := g_package || '.create_enrtrmdr_ranges';
3621: --
3622: begin
3623: --
3624: hr_utility.set_location('Entering : ' || l_proc, 10);
3625: --
3626: hr_utility.set_location('Creating actions and ranges ' || l_proc, 15);
3627: --
3628: for l_per_rec in c_pil_enrtrmdr loop

Line 3626: hr_utility.set_location('Creating actions and ranges ' || l_proc, 15);

3622: begin
3623: --
3624: hr_utility.set_location('Entering : ' || l_proc, 10);
3625: --
3626: hr_utility.set_location('Creating actions and ranges ' || l_proc, 15);
3627: --
3628: for l_per_rec in c_pil_enrtrmdr loop
3629: --
3630: create_actions_ranges

Line 3644: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);

3640: --
3641: If g_person_actn_cnt > 0 and
3642: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
3643: --
3644: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
3645: --
3646: ben_batch_ranges_api.create_batch_ranges
3647: (p_validate => FALSE
3648: ,p_effective_date => g_parm.effective_date

Line 3660: hr_utility.set_location('Leaving : ' || l_proc, 10);

3656: g_num_ranges := g_num_ranges + 1;
3657: --
3658: end if;
3659: --
3660: hr_utility.set_location('Leaving : ' || l_proc, 10);
3661: --
3662: end create_enrtrmdr_ranges;
3663: --
3664: -- ----------------------------------------------------------------------------

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

3781: l_proc varchar2(80) := g_package || '.create_actnrmdr_ranges';
3782: --
3783: begin
3784: --
3785: hr_utility.set_location('Entering : ' || l_proc, 10);
3786: --
3787: for l_per_rec in c_per_actnrmdr loop
3788: --
3789: -- Create person actions and batch ranges.

Line 3804: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);

3800: --
3801: If g_person_actn_cnt > 0 and
3802: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
3803: --
3804: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
3805: --
3806: ben_batch_ranges_api.create_batch_ranges
3807: (p_validate => FALSE
3808: ,p_effective_date => g_parm.effective_date

Line 3820: hr_utility.set_location('Leaving : ' || l_proc, 10);

3816: g_num_ranges := g_num_ranges + 1;
3817: --
3818: end if;
3819: --
3820: hr_utility.set_location('Leaving : ' || l_proc, 10);
3821: --
3822: end create_actnrmdr_ranges;
3823: --
3824: -- ----------------------------------------------------------------------------

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

3996: l_proc varchar2(80) := g_package || '.create_emrtevt_ranges';
3997: --
3998: begin
3999: --
4000: hr_utility.set_location('Entering : ' || l_proc, 10);
4001: --
4002: --
4003: for l_per_rec in c_per_emrgevt loop
4004: --

Line 4013: hr_utility.set_location('Person is dependent',10);

4009: -- For Dependents.
4010: --
4011: if g_parm.elig_enrol_cd = 'ENROL' then
4012: --
4013: hr_utility.set_location('Person is dependent',10);
4014: hr_utility.set_location('Person ID '||l_per_rec.person_id,10);
4015: hr_utility.set_location('BG ID '||g_parm.business_group_id,10);
4016: hr_utility.set_location('EFF DATE '||g_parm.effective_date,10);
4017: hr_utility.set_location('PGM ID '||g_parm.pgm_id,10);

Line 4014: hr_utility.set_location('Person ID '||l_per_rec.person_id,10);

4010: --
4011: if g_parm.elig_enrol_cd = 'ENROL' then
4012: --
4013: hr_utility.set_location('Person is dependent',10);
4014: hr_utility.set_location('Person ID '||l_per_rec.person_id,10);
4015: hr_utility.set_location('BG ID '||g_parm.business_group_id,10);
4016: hr_utility.set_location('EFF DATE '||g_parm.effective_date,10);
4017: hr_utility.set_location('PGM ID '||g_parm.pgm_id,10);
4018: hr_utility.set_location('PL_NIP ID '||g_parm.pl_nip_id,10);

Line 4015: hr_utility.set_location('BG ID '||g_parm.business_group_id,10);

4011: if g_parm.elig_enrol_cd = 'ENROL' then
4012: --
4013: hr_utility.set_location('Person is dependent',10);
4014: hr_utility.set_location('Person ID '||l_per_rec.person_id,10);
4015: hr_utility.set_location('BG ID '||g_parm.business_group_id,10);
4016: hr_utility.set_location('EFF DATE '||g_parm.effective_date,10);
4017: hr_utility.set_location('PGM ID '||g_parm.pgm_id,10);
4018: hr_utility.set_location('PL_NIP ID '||g_parm.pl_nip_id,10);
4019: hr_utility.set_location('PL_IN PROG FLAG '||g_parm.plan_in_pgm_flag,10);

Line 4016: hr_utility.set_location('EFF DATE '||g_parm.effective_date,10);

4012: --
4013: hr_utility.set_location('Person is dependent',10);
4014: hr_utility.set_location('Person ID '||l_per_rec.person_id,10);
4015: hr_utility.set_location('BG ID '||g_parm.business_group_id,10);
4016: hr_utility.set_location('EFF DATE '||g_parm.effective_date,10);
4017: hr_utility.set_location('PGM ID '||g_parm.pgm_id,10);
4018: hr_utility.set_location('PL_NIP ID '||g_parm.pl_nip_id,10);
4019: hr_utility.set_location('PL_IN PROG FLAG '||g_parm.plan_in_pgm_flag,10);
4020: open c_dpnt_enrt(l_per_rec.person_id);

Line 4017: hr_utility.set_location('PGM ID '||g_parm.pgm_id,10);

4013: hr_utility.set_location('Person is dependent',10);
4014: hr_utility.set_location('Person ID '||l_per_rec.person_id,10);
4015: hr_utility.set_location('BG ID '||g_parm.business_group_id,10);
4016: hr_utility.set_location('EFF DATE '||g_parm.effective_date,10);
4017: hr_utility.set_location('PGM ID '||g_parm.pgm_id,10);
4018: hr_utility.set_location('PL_NIP ID '||g_parm.pl_nip_id,10);
4019: hr_utility.set_location('PL_IN PROG FLAG '||g_parm.plan_in_pgm_flag,10);
4020: open c_dpnt_enrt(l_per_rec.person_id);
4021: fetch c_dpnt_enrt into l_pgm_id, l_pl_id;

Line 4018: hr_utility.set_location('PL_NIP ID '||g_parm.pl_nip_id,10);

4014: hr_utility.set_location('Person ID '||l_per_rec.person_id,10);
4015: hr_utility.set_location('BG ID '||g_parm.business_group_id,10);
4016: hr_utility.set_location('EFF DATE '||g_parm.effective_date,10);
4017: hr_utility.set_location('PGM ID '||g_parm.pgm_id,10);
4018: hr_utility.set_location('PL_NIP ID '||g_parm.pl_nip_id,10);
4019: hr_utility.set_location('PL_IN PROG FLAG '||g_parm.plan_in_pgm_flag,10);
4020: open c_dpnt_enrt(l_per_rec.person_id);
4021: fetch c_dpnt_enrt into l_pgm_id, l_pl_id;
4022: --

Line 4019: hr_utility.set_location('PL_IN PROG FLAG '||g_parm.plan_in_pgm_flag,10);

4015: hr_utility.set_location('BG ID '||g_parm.business_group_id,10);
4016: hr_utility.set_location('EFF DATE '||g_parm.effective_date,10);
4017: hr_utility.set_location('PGM ID '||g_parm.pgm_id,10);
4018: hr_utility.set_location('PL_NIP ID '||g_parm.pl_nip_id,10);
4019: hr_utility.set_location('PL_IN PROG FLAG '||g_parm.plan_in_pgm_flag,10);
4020: open c_dpnt_enrt(l_per_rec.person_id);
4021: fetch c_dpnt_enrt into l_pgm_id, l_pl_id;
4022: --
4023: if c_dpnt_enrt%found then

Line 4025: hr_utility.set_location('Definately Found record',10);

4021: fetch c_dpnt_enrt into l_pgm_id, l_pl_id;
4022: --
4023: if c_dpnt_enrt%found then
4024: --
4025: hr_utility.set_location('Definately Found record',10);
4026: l_create_action := true;
4027: --
4028: if g_parm.use_fctr_to_sel_flag = 'Y' then
4029: --

Line 4030: hr_utility.set_location('Found record',10);

4026: l_create_action := true;
4027: --
4028: if g_parm.use_fctr_to_sel_flag = 'Y' then
4029: --
4030: hr_utility.set_location('Found record',10);
4031: l_create_action := fctr_belongs_to_comp_object(
4032: p_pgm_id => l_pgm_id,
4033: p_pl_id => l_pl_id);
4034: --

Line 4070: hr_utility.set_location('Person is participant',10);

4066: close c_elig;
4067: --
4068: elsif g_parm.elig_enrol_cd = 'ENROL' then
4069: --
4070: hr_utility.set_location('Person is participant',10);
4071: open c_enrt(l_per_rec.person_id);
4072: fetch c_enrt into l_pgm_id, l_pl_id;
4073: --
4074: if c_enrt%found then

Line 4109: hr_utility.set_location('Range created',10);

4105: -- Create person actions and batch ranges
4106: --
4107: g_per_slctd := g_per_slctd + 1;
4108: --
4109: hr_utility.set_location('Range created',10);
4110: --
4111: create_actions_ranges
4112: (p_person_id => l_per_rec.person_id
4113: ,p_start_person_action_id => l_start_person_action_id

Line 4120: hr_utility.set_location('People selected from database : ' || g_per_slctd,10);

4116: end if;
4117: --
4118: end loop;
4119: --
4120: hr_utility.set_location('People selected from database : ' || g_per_slctd,10);
4121: --
4122: -- There could be a few person actions left over from the call in the for
4123: -- loop above. Create a batch range for them.
4124: --

Line 4128: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);

4124: --
4125: If g_person_actn_cnt > 0 and
4126: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
4127: --
4128: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
4129: --
4130: ben_batch_ranges_api.create_batch_ranges
4131: (p_validate => FALSE
4132: ,p_effective_date => g_parm.effective_date

Line 4144: hr_utility.set_location('Leaving : ' || l_proc, 10);

4140: g_num_ranges := g_num_ranges + 1;
4141: --
4142: end if;
4143: --
4144: hr_utility.set_location('Leaving : ' || l_proc, 10);
4145: --
4146: end create_emrgevt_ranges;
4147: --
4148: -- ----------------------------------------------------------------------------

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

4527: l_proc varchar2(80) := g_package || '.create_mssmlg_ranges';
4528: --
4529: begin
4530: --
4531: hr_utility.set_location('Entering : ' || l_proc, 10);
4532: --
4533: if (g_parm.elig_enrol_cd = 'ELIG' and g_parm.pgm_id is not null and g_parm.pl_nip_id is null)
4534: then
4535: for l_per_rec in c_per_mssmlg_elig_pgm loop

Line 4594: hr_utility.set_location('People selected from database : ' || g_per_slctd,10);

4590: --
4591: end loop;
4592: end if;
4593: --
4594: hr_utility.set_location('People selected from database : ' || g_per_slctd,10);
4595: --
4596: -- There could be a few person actions left over from the call in the for
4597: -- loop above. Create a batch range for them.
4598: --

Line 4602: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);

4598: --
4599: If g_person_actn_cnt > 0 and
4600: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
4601: --
4602: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
4603: --
4604: ben_batch_ranges_api.create_batch_ranges
4605: (p_validate => FALSE
4606: ,p_effective_date => g_parm.effective_date

Line 4618: hr_utility.set_location('Leaving : ' || l_proc, 10);

4614: g_num_ranges := g_num_ranges + 1;
4615: --
4616: end if;
4617: --
4618: hr_utility.set_location('Leaving : ' || l_proc, 10);
4619: --
4620: end create_mssmlg_ranges;
4621: --
4622: -- ----------------------------------------------------------------------------

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

4673: l_lf_evt_ocrd_dt date;
4674: --
4675: begin
4676: --
4677: hr_utility.set_location('Entering : ' || l_proc, 10);
4678: --
4679: -- Convert varchar2 dates to real dates
4680: -- 1) First remove time component
4681: -- 2) Next convert format

Line 4760: hr_utility.set_location('Num Threads = ' || g_threads, 10);

4756: ,p_threads => g_threads
4757: ,p_chunk_size => g_chunk_size
4758: ,p_max_errors => g_max_errors);
4759: --
4760: hr_utility.set_location('Num Threads = ' || g_threads, 10);
4761: hr_utility.set_location('Chunk Size = ' || g_chunk_size, 10);
4762: hr_utility.set_location('Max Errors = ' || g_max_errors, 10);
4763: --
4764: -- Create benefit actions parameters in the benefit action table.

Line 4761: hr_utility.set_location('Chunk Size = ' || g_chunk_size, 10);

4757: ,p_chunk_size => g_chunk_size
4758: ,p_max_errors => g_max_errors);
4759: --
4760: hr_utility.set_location('Num Threads = ' || g_threads, 10);
4761: hr_utility.set_location('Chunk Size = ' || g_chunk_size, 10);
4762: hr_utility.set_location('Max Errors = ' || g_max_errors, 10);
4763: --
4764: -- Create benefit actions parameters in the benefit action table.
4765: -- If a benefit action already exists, do not create - in other words

Line 4762: hr_utility.set_location('Max Errors = ' || g_max_errors, 10);

4758: ,p_max_errors => g_max_errors);
4759: --
4760: hr_utility.set_location('Num Threads = ' || g_threads, 10);
4761: hr_utility.set_location('Chunk Size = ' || g_chunk_size, 10);
4762: hr_utility.set_location('Max Errors = ' || g_max_errors, 10);
4763: --
4764: -- Create benefit actions parameters in the benefit action table.
4765: -- If a benefit action already exists, do not create - in other words
4766: -- we are doing a restart.

Line 4849: hr_utility.set_location('Number of person actions : ' ||

4845: end if;
4846: --
4847: g_proc_rec.benefit_action_id := g_parm.benefit_action_id;
4848: --
4849: hr_utility.set_location('Number of person actions : ' ||
4850: to_char(g_person_actn_cnt), 10);
4851: --
4852: else -- p_benefit_action_id
4853: --

Line 4858: hr_utility.set_location('restart batch process ' || l_proc, 20);

4854: -- Benefit action id is not null i.e. the batch process is being restarted
4855: -- for a certain benefit action id. Create batch ranges and person actions
4856: -- for restarting.
4857: --
4858: hr_utility.set_location('restart batch process ' || l_proc, 20);
4859: --
4860: ben_batch_utils.create_restart_person_actions
4861: (p_benefit_action_id => p_benefit_action_id
4862: ,p_effective_date => l_effective_date

Line 4890: hr_utility.set_location('Number of Threads : ' || g_threads, 20);

4886: -- and the number of ranges created above.
4887: --
4888: g_threads := least(g_threads, g_num_ranges);
4889: --
4890: hr_utility.set_location('Number of Threads : ' || g_threads, 20);
4891: --
4892: -- Submit requests
4893: --
4894: for l_count in 1..(g_threads -1) loop

Line 4901: hr_utility.set_location('Sumitting thread : ' || l_count, 25);

4897: -- process will act as the last thread and will be able to keep track of
4898: -- the child processes. If only one range got created this loop will never
4899: -- be executed and no additional concurrent requests will be submitted.
4900: --
4901: hr_utility.set_location('Sumitting thread : ' || l_count, 25);
4902: --
4903: l_request_id := fnd_request.submit_request
4904: (application => 'BEN'
4905: ,program => 'BENTMPCMT'

Line 4932: hr_utility.set_location('Leaving : ' || l_proc, 10);

4928: ,p_thread_id => g_threads
4929: ,p_effective_date => p_effective_date
4930: ,p_business_group_id => p_business_group_id);
4931: --
4932: hr_utility.set_location('Leaving : ' || l_proc, 10);
4933: --
4934: end process;
4935: --
4936: procedure summary_by_action(p_concurrent_request_id in number,

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

5168: and nvl(org.date_to,bft.process_date);
5169: --
5170: begin
5171: --
5172: hr_utility.set_location('Entering :'||l_proc,10);
5173: --
5174: -- Default return values for nulls
5175: --
5176: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');

Line 5215: hr_utility.set_location('Leaving :'||l_proc,10);

5211: p_concurrent_program_name,
5212: p_status;
5213: close c_benefit_actions;
5214: --
5215: hr_utility.set_location('Leaving :'||l_proc,10);
5216: --
5217: end;
5218: --
5219: --