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

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

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

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

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

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

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

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

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

427: commit;
428: --
429: end if;
430: --
431: hr_utility.set_location('Leaving : ' || l_proc, 10);
432: --
433: end check_all_slaves_finished;
434: --
435: -- ----------------------------------------------------------------------------

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

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

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

455: if g_error_person_cnt > g_max_errors then
456: raise error_limit;
457: end if;
458: --
459: hr_utility.set_location('Leaving : ' || l_proc, 10);
460: --
461: exception
462: --
463: when error_limit then

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

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

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

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

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

515: --
516: l_rec benutils.g_batch_param_rec;
517: begin
518: --
519: hr_utility.set_location('Entering : ' || l_proc, 10);
520: --
521: if fnd_global.conc_request_id = -1 then
522: return;
523: end if;

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

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

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

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

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

786: end if;
787: --
788: end if;
789: --
790: hr_utility.set_location('Leaving '||l_proc,10);
791: --
792: end set_object;
793:
794:

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

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

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

860: end if;
861: --
862: end if;
863: --
864: hr_utility.set_location('Leaving '||l_proc,10);
865: --
866: end set_object;
867: --
868: --

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

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

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

1030: --
1031: p_pl_fctr_rec := l_pl_fctr_rec;
1032: p_plip_fctr_rec := l_plip_fctr_rec;
1033: --
1034: hr_utility.set_location('Leaving '||l_proc,10);
1035: --
1036: end set_fctr_object;
1037:
1038: --

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

1046: l_plip_fctr_rec g_cache_plip_fctr_rec_type;
1047: --
1048: begin
1049: --
1050: hr_utility.set_location('Entering '||l_proc,10);
1051: --
1052: if g_cache_last_pl_fctr_rec.pl_id = p_pl_id then
1053: --
1054: p_rec := g_cache_last_pl_fctr_rec;

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

1117: raise no_data_found;
1118: --
1119: end if;
1120: --
1121: hr_utility.set_location('Leaving '||l_proc,10);
1122: --
1123: exception
1124: --
1125: when no_data_found then

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

1149: l_pl_fctr_rec g_cache_pl_fctr_rec_type;
1150: --
1151: begin
1152: --
1153: hr_utility.set_location('Entering '||l_proc,10);
1154: --
1155: if g_cache_last_plip_fctr_rec.plip_id = p_plip_id then
1156: --
1157: p_rec := g_cache_last_plip_fctr_rec;

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

1220: raise no_data_found;
1221: --
1222: end if;
1223: --
1224: hr_utility.set_location('Leaving '||l_proc,10);
1225: --
1226: exception
1227: --
1228: when no_data_found then

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

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

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

1301: end if;
1302: --
1303: end if;
1304: --
1305: hr_utility.set_location('Leaving '||l_proc,10);
1306: --
1307: return l_return;
1308: --
1309: end fctr_belongs_to_comp_object;

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

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

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

1339: end if;
1340: --
1341: benutils.write(p_rec => g_rec);
1342: --
1343: hr_utility.set_location('Leaving : ' || l_proc, 10);
1344: --
1345: end chk_per_cm;
1346: --
1347: -- ----------------------------------------------------------------------------

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

1367: l_proc varchar2(80) := g_package || '.get_main_person_id';
1368: --
1369: begin
1370: --
1371: hr_utility.set_location('Entering : ' || l_proc, 10);
1372: --
1373: open c_per;
1374: fetch c_per into l_person_id;
1375: close c_per;

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

1373: open c_per;
1374: fetch c_per into l_person_id;
1375: close c_per;
1376: --
1377: hr_utility.set_location('Leaving : ' || l_proc, 10);
1378: --
1379: return l_person_id;
1380: --
1381: end get_main_person_id;

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

1397: l_proc varchar2(80) := g_package || '.get_person_type';
1398: --
1399: begin
1400: --
1401: hr_utility.set_location('Entering : ' || l_proc, 10);
1402: --
1403: open c_person_type;
1404: fetch c_person_type into l_type;
1405: close c_person_type;

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

1403: open c_person_type;
1404: fetch c_person_type into l_type;
1405: close c_person_type;
1406: --
1407: hr_utility.set_location('Leaving : ' || l_proc, 10);
1408: --
1409: return(l_type);
1410: --
1411: exception

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

1478: l_proc varchar2(80) := g_package || '.is_dependent';
1479: --
1480: begin
1481: --
1482: hr_utility.set_location('Entering : ' || l_proc, 10);
1483: --
1484: open c_dpnt;
1485: fetch c_dpnt into l_exists;
1486: close c_dpnt;

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

1488: if l_exists = 'Y' then
1489: --
1490: l_return := true;
1491: --
1492: hr_utility.set_location('Person id DPNT',10);
1493: end if;
1494: --
1495: hr_utility.set_location('Leaving : ' || l_proc, 10);
1496: --

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

1491: --
1492: hr_utility.set_location('Person id DPNT',10);
1493: end if;
1494: --
1495: hr_utility.set_location('Leaving : ' || l_proc, 10);
1496: --
1497: return(l_return);
1498: --
1499: exception

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

1526: l_proc varchar2(80) := g_package || '.check_business_rules';
1527: --
1528: begin
1529: --
1530: hr_utility.set_location ('Entering '||l_proc,10);
1531: --
1532: -- This procedure checks validity of parameters that have been passed to the
1533: -- BENTMPCM process.
1534: --

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

1859: end if;
1860: --
1861: end if; -- g_parm.cm_trgr_typ_cd = MSSMLG
1862: --
1863: hr_utility.set_location ('Leaving '||l_proc,10);
1864: --
1865: end check_business_rules;
1866: --
1867: -- ----------------------------------------------------------------------------

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

1914: l_proc varchar2(80) := g_package || '.process_age';
1915: --
1916: begin
1917: --
1918: hr_utility.set_location('Entering : ' || l_proc, 10);
1919: --
1920: hr_utility.set_location('Processing age for person ID : ' || p_person_id, 10);
1921: --
1922: -- Get the person's date of birth

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

1916: begin
1917: --
1918: hr_utility.set_location('Entering : ' || l_proc, 10);
1919: --
1920: hr_utility.set_location('Processing age for person ID : ' || p_person_id, 10);
1921: --
1922: -- Get the person's date of birth
1923: --
1924: open c_person;

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

1990: -- An age factor not specified. But a min age or a max age was specified.
1991: -- Evaluate if the person's age will cross either the min or max boundary
1992: -- in the date range (date_from to effective_date) specified.
1993: --
1994: hr_utility.set_location('Calculating user specified age ' || l_proc, 10);
1995: --
1996: l_age_before := months_between(l_effective_date - 1, l_dob )/12;
1997: l_age_after := months_between(g_parm.effective_date, l_dob)/12;
1998: l_uom := 'YR';

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

1998: l_uom := 'YR';
1999: l_min_value := g_parm.min_age;
2000: l_max_value := g_parm.max_age;
2001: --
2002: hr_utility.set_location('Age Before'||l_age_before,10);
2003: hr_utility.set_location('Age After'||l_age_after,10);
2004: hr_utility.set_location('Min Value'||l_min_value,10);
2005: hr_utility.set_location('Max Value'||l_max_value,10);
2006: --

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

1999: l_min_value := g_parm.min_age;
2000: l_max_value := g_parm.max_age;
2001: --
2002: hr_utility.set_location('Age Before'||l_age_before,10);
2003: hr_utility.set_location('Age After'||l_age_after,10);
2004: hr_utility.set_location('Min Value'||l_min_value,10);
2005: hr_utility.set_location('Max Value'||l_max_value,10);
2006: --
2007: end if; -- g_parm.age_fctr_id

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

2000: l_max_value := g_parm.max_age;
2001: --
2002: hr_utility.set_location('Age Before'||l_age_before,10);
2003: hr_utility.set_location('Age After'||l_age_after,10);
2004: hr_utility.set_location('Min Value'||l_min_value,10);
2005: hr_utility.set_location('Max Value'||l_max_value,10);
2006: --
2007: end if; -- g_parm.age_fctr_id
2008: --

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

2001: --
2002: hr_utility.set_location('Age Before'||l_age_before,10);
2003: hr_utility.set_location('Age After'||l_age_after,10);
2004: hr_utility.set_location('Min Value'||l_min_value,10);
2005: hr_utility.set_location('Max Value'||l_max_value,10);
2006: --
2007: end if; -- g_parm.age_fctr_id
2008: --
2009: -- Check if a breach occures.

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

2030: p_breach := false;
2031: --
2032: end if;
2033: --
2034: hr_utility.set_location('Leaving : ' || l_proc, 10);
2035: --
2036: exception
2037: --
2038: when dob_null then

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

2035: --
2036: exception
2037: --
2038: when dob_null then
2039: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2040: fnd_message.set_name('BEN', 'BEN_91337_DOB');
2041: fnd_message.set_token('PROC',l_proc);
2042: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2043: -- The person being processed does not have a date of birth.

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

2043: -- The person being processed does not have a date of birth.
2044: raise ben_manage_life_events.g_record_error;
2045: --
2046: when agf_pgm_or_pl then
2047: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2048: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2049: fnd_message.set_token('PROC',l_proc);
2050: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2051: --

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

2054: --
2055: raise ben_manage_life_events.g_record_error;
2056: --
2057: when others then
2058: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2059: -- For nocopy changes
2060: p_lf_evt_ocrd_dt := null;
2061: p_breach := false;
2062: --

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

2105: l_proc varchar2(80) := g_package || '.calculate_los';
2106: --
2107: begin
2108: --
2109: hr_utility.set_location('Entering : ' || l_proc, 10);
2110: --
2111: hr_utility.set_location('Person ID : ' || p_person_id, 10);
2112: --
2113: open c_person;

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

2107: begin
2108: --
2109: hr_utility.set_location('Entering : ' || l_proc, 10);
2110: --
2111: hr_utility.set_location('Person ID : ' || p_person_id, 10);
2112: --
2113: open c_person;
2114: fetch c_person into l_start_date,
2115: l_adj_svc_date;

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

2185: -- An LOS factor not specified. But a min LOS or a max LOS was specified.
2186: -- Evaluate if the person's LOS will cross either the min or max boundary
2187: -- in the date range (date_from to effective_date) specified.
2188: --
2189: hr_utility.set_location('Calculating user specified LOS ' || l_proc, 10);
2190: --
2191: l_los_before := months_between(l_effective_date - 1, l_start_date )/12;
2192: l_los_after := months_between(g_parm.effective_date, l_start_date)/12;
2193: l_uom := 'YR';

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

2219: p_breach := false;
2220: --
2221: end if;
2222: --
2223: hr_utility.set_location('Leaving : ' || l_proc, 10);
2224: --
2225: exception
2226: --
2227: when lsf_pgm_or_pl then

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

2225: exception
2226: --
2227: when lsf_pgm_or_pl then
2228: --
2229: hr_utility.set_location('Leaving : ' || l_proc, 10);
2230: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2231: fnd_message.set_token('PROC',l_proc);
2232: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2233: --

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

2236: --
2237: raise ben_manage_life_events.g_record_error;
2238: --
2239: when others then
2240: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2241: -- For nocopy changes
2242: p_lf_evt_ocrd_dt := null;
2243: p_breach := false;
2244: --

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

2298: l_proc varchar2(80) := g_package || '.process_cmbn_age_los';
2299: --
2300: begin
2301: --
2302: hr_utility.set_location('Entering : ' || l_proc, 10);
2303: --
2304: if g_parm.date_from is not null then
2305: --
2306: l_effective_date := g_parm.date_from;

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

2397: p_breach := false;
2398: --
2399: end if;
2400: --
2401: hr_utility.set_location('Leaving : ' || l_proc, 10);
2402: --
2403: exception
2404: --
2405: when cmbn_pgm_or_pl then

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

2402: --
2403: exception
2404: --
2405: when cmbn_pgm_or_pl then
2406: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2407: fnd_message.set_name('BEN','BEN_92181_FCTR_RQR_PGM_OR_PL');
2408: fnd_message.set_token('PROC',l_proc);
2409: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
2410: --

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

2413: --
2414: raise ben_manage_life_events.g_record_error;
2415: --
2416: when others then
2417: hr_utility.set_location('Exception raised in ' || l_proc, 10);
2418: -- For nocopy changes
2419: p_lf_evt_ocrd_dt := null;
2420: p_breach := false;
2421: --

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

2448: l_proc varchar2(80) := g_package || '.process_emrg_events';
2449: --
2450: begin
2451: --
2452: hr_utility.set_location('Entering ' || l_proc, 10);
2453: --
2454: for l_per_rec in c_per_actn loop
2455: --
2456: g_person_cnt := g_person_cnt + 1;

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

2467: if g_parm.age_fctr_id is not null or
2468: g_parm.min_age is not null or
2469: g_parm.max_age is not null then
2470: --
2471: hr_utility.set_location('Processing age ' || l_proc, 15);
2472: --
2473: -- If we are processing emerging events for dependents, then get the
2474: -- main person id since the communication will be sent to participants.
2475: --

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

2491: elsif g_parm.los_fctr_id is not null or
2492: g_parm.min_los is not null or
2493: g_parm.max_los is not null then
2494: --
2495: hr_utility.set_location('Processing LOS ' || l_proc, 15);
2496: --
2497: l_person_id := l_per_rec.person_id;
2498: --
2499: -- Process the person's length of service to check if there is a breach.

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

2504: ,p_breach => l_breach);
2505: --
2506: elsif g_parm.cmbn_age_los_fctr_id is not null then
2507: --
2508: hr_utility.set_location('Processing cmbn_age_los ' || l_proc, 15);
2509: --
2510: l_person_id := l_per_rec.person_id;
2511: --
2512: -- Process the person's combination of age and length of service.

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

2516: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
2517: ,p_breach => l_breach);
2518: --
2519: else
2520: hr_utility.set_location('Not calculating factors ' || l_proc, 15);
2521: end if;
2522: --
2523: hr_utility.set_location('After processing...', 15);
2524: --

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

2519: else
2520: hr_utility.set_location('Not calculating factors ' || l_proc, 15);
2521: end if;
2522: --
2523: hr_utility.set_location('After processing...', 15);
2524: --
2525: ben_generate_communications.g_comm_generated := false;
2526: --
2527: if l_breach then

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

2525: ben_generate_communications.g_comm_generated := false;
2526: --
2527: if l_breach then
2528: --
2529: hr_utility.set_location(l_person_id,10);
2530: hr_utility.set_location(g_parm.cm_trgr_typ_cd,10);
2531: hr_utility.set_location(g_parm.cm_typ_id,10);
2532: hr_utility.set_location(g_parm.pgm_id,10);
2533: hr_utility.set_location(g_parm.pl_nip_id,10);

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

2526: --
2527: if l_breach then
2528: --
2529: hr_utility.set_location(l_person_id,10);
2530: hr_utility.set_location(g_parm.cm_trgr_typ_cd,10);
2531: hr_utility.set_location(g_parm.cm_typ_id,10);
2532: hr_utility.set_location(g_parm.pgm_id,10);
2533: hr_utility.set_location(g_parm.pl_nip_id,10);
2534: hr_utility.set_location(l_dpnt_person_id,10);

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

2527: if l_breach then
2528: --
2529: hr_utility.set_location(l_person_id,10);
2530: hr_utility.set_location(g_parm.cm_trgr_typ_cd,10);
2531: hr_utility.set_location(g_parm.cm_typ_id,10);
2532: hr_utility.set_location(g_parm.pgm_id,10);
2533: hr_utility.set_location(g_parm.pl_nip_id,10);
2534: hr_utility.set_location(l_dpnt_person_id,10);
2535: hr_utility.set_location(g_parm.business_group_id,10);

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

2528: --
2529: hr_utility.set_location(l_person_id,10);
2530: hr_utility.set_location(g_parm.cm_trgr_typ_cd,10);
2531: hr_utility.set_location(g_parm.cm_typ_id,10);
2532: hr_utility.set_location(g_parm.pgm_id,10);
2533: hr_utility.set_location(g_parm.pl_nip_id,10);
2534: hr_utility.set_location(l_dpnt_person_id,10);
2535: hr_utility.set_location(g_parm.business_group_id,10);
2536: hr_utility.set_location(g_parm.effective_date,10);

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

2529: hr_utility.set_location(l_person_id,10);
2530: hr_utility.set_location(g_parm.cm_trgr_typ_cd,10);
2531: hr_utility.set_location(g_parm.cm_typ_id,10);
2532: hr_utility.set_location(g_parm.pgm_id,10);
2533: hr_utility.set_location(g_parm.pl_nip_id,10);
2534: hr_utility.set_location(l_dpnt_person_id,10);
2535: hr_utility.set_location(g_parm.business_group_id,10);
2536: hr_utility.set_location(g_parm.effective_date,10);
2537: hr_utility.set_location(l_lf_evt_ocrd_dt,10);

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

2530: hr_utility.set_location(g_parm.cm_trgr_typ_cd,10);
2531: hr_utility.set_location(g_parm.cm_typ_id,10);
2532: hr_utility.set_location(g_parm.pgm_id,10);
2533: hr_utility.set_location(g_parm.pl_nip_id,10);
2534: hr_utility.set_location(l_dpnt_person_id,10);
2535: hr_utility.set_location(g_parm.business_group_id,10);
2536: hr_utility.set_location(g_parm.effective_date,10);
2537: hr_utility.set_location(l_lf_evt_ocrd_dt,10);
2538: hr_utility.set_location(g_parm.mode_cd,10);

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

2531: hr_utility.set_location(g_parm.cm_typ_id,10);
2532: hr_utility.set_location(g_parm.pgm_id,10);
2533: hr_utility.set_location(g_parm.pl_nip_id,10);
2534: hr_utility.set_location(l_dpnt_person_id,10);
2535: hr_utility.set_location(g_parm.business_group_id,10);
2536: hr_utility.set_location(g_parm.effective_date,10);
2537: hr_utility.set_location(l_lf_evt_ocrd_dt,10);
2538: hr_utility.set_location(g_parm.mode_cd,10);
2539: ben_generate_communications.main

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

2532: hr_utility.set_location(g_parm.pgm_id,10);
2533: hr_utility.set_location(g_parm.pl_nip_id,10);
2534: hr_utility.set_location(l_dpnt_person_id,10);
2535: hr_utility.set_location(g_parm.business_group_id,10);
2536: hr_utility.set_location(g_parm.effective_date,10);
2537: hr_utility.set_location(l_lf_evt_ocrd_dt,10);
2538: hr_utility.set_location(g_parm.mode_cd,10);
2539: ben_generate_communications.main
2540: (p_person_id => l_person_id

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

2533: hr_utility.set_location(g_parm.pl_nip_id,10);
2534: hr_utility.set_location(l_dpnt_person_id,10);
2535: hr_utility.set_location(g_parm.business_group_id,10);
2536: hr_utility.set_location(g_parm.effective_date,10);
2537: hr_utility.set_location(l_lf_evt_ocrd_dt,10);
2538: hr_utility.set_location(g_parm.mode_cd,10);
2539: ben_generate_communications.main
2540: (p_person_id => l_person_id
2541: ,p_cm_trgr_typ_cd => g_parm.cm_trgr_typ_cd

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

2534: hr_utility.set_location(l_dpnt_person_id,10);
2535: hr_utility.set_location(g_parm.business_group_id,10);
2536: hr_utility.set_location(g_parm.effective_date,10);
2537: hr_utility.set_location(l_lf_evt_ocrd_dt,10);
2538: hr_utility.set_location(g_parm.mode_cd,10);
2539: ben_generate_communications.main
2540: (p_person_id => l_person_id
2541: ,p_cm_trgr_typ_cd => g_parm.cm_trgr_typ_cd
2542: ,p_cm_typ_id => g_parm.cm_typ_id

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

2550: ,p_mode => g_parm.mode_cd);
2551: --
2552: end if;
2553: --
2554: hr_utility.set_location('Here',10);
2555: if (g_parm.audit_log_flag = 'Y') then
2556: chk_per_cm(p_person_id => l_person_id);
2557: end if;
2558: --

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

2560: g_action_rec.action_status_cd := 'P';
2561: g_action_rec.object_version_number := l_per_rec.object_version_number;
2562: g_action_rec.effective_date := g_parm.effective_date;
2563: --
2564: hr_utility.set_location('Nearly Leaving Now',10);
2565: benutils.write(p_rec => g_action_rec);
2566: --
2567: hr_utility.set_location('Leaving Now',10);
2568: exception

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

2563: --
2564: hr_utility.set_location('Nearly Leaving Now',10);
2565: benutils.write(p_rec => g_action_rec);
2566: --
2567: hr_utility.set_location('Leaving Now',10);
2568: exception
2569: --
2570: when ben_manage_life_events.g_record_error then
2571: --

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

2568: exception
2569: --
2570: when ben_manage_life_events.g_record_error then
2571: --
2572: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
2573: --
2574: rollback to before_communications;
2575: --
2576: g_rec.person_id := l_per_rec.person_id;

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

2594: person_error_cnt;
2595: --
2596: when others then
2597: --
2598: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
2599: --
2600: rollback to before_communications;
2601: --
2602: g_rec.person_id := l_per_rec.person_id;

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

2631: ,p_file => true);
2632: --
2633: commit;
2634: --
2635: hr_utility.set_location('Leaving ' || l_proc, 10);
2636: --
2637: end process_emrg_events;
2638: --
2639: -- ----------------------------------------------------------------------------

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

2659: l_proc varchar2(80) := g_package || '.process_trgt_mass_mail';
2660: --
2661: begin
2662: --
2663: hr_utility.set_location('Entering ' || l_proc, 10);
2664: --
2665: for l_per_rec in c_per_actn loop
2666: --
2667: g_person_cnt := g_person_cnt + 1;

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

2700: exception
2701: --
2702: when ben_manage_life_events.g_record_error then
2703: --
2704: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
2705: --
2706: rollback to before_communications;
2707: --
2708: g_rec.rep_typ_cd := 'ERRCM';

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

2726: person_error_cnt;
2727: --
2728: when others then
2729: --
2730: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
2731: --
2732: rollback to before_communications;
2733: --
2734: g_rec.rep_typ_cd := 'FATAL';

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

2763: ,p_file => true);
2764: --
2765: commit;
2766: --
2767: hr_utility.set_location('Leaving ' || l_proc, 10);
2768: --
2769: end process_trgt_mass_mail;
2770: --
2771: -- ----------------------------------------------------------------------------

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

2790: l_proc varchar2(80) := g_package || '.process_actn_item_reminders';
2791: --
2792: begin
2793: --
2794: hr_utility.set_location('Entering : ' || l_proc, 10);
2795: --
2796: for l_per_rec in c_per_actn loop
2797: --
2798: hr_utility.set_location('Processing person ID : ' ||l_per_rec.person_id,10);

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

2794: hr_utility.set_location('Entering : ' || l_proc, 10);
2795: --
2796: for l_per_rec in c_per_actn loop
2797: --
2798: hr_utility.set_location('Processing person ID : ' ||l_per_rec.person_id,10);
2799: --
2800: begin
2801: --
2802: -- Set a savepoint to rollback errors

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

2836: exception
2837: --
2838: when ben_manage_life_events.g_record_error then
2839: --
2840: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
2841: --
2842: rollback to before_communications;
2843: --
2844: g_rec.rep_typ_cd := 'ERRCM';

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

2862: person_error_cnt;
2863: --
2864: when others then
2865: --
2866: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
2867: --
2868: rollback to before_communications;
2869: --
2870: g_rec.rep_typ_cd := 'FATAL';

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

2899: ,p_file => true);
2900: --
2901: commit;
2902: --
2903: hr_utility.set_location('Leaving : ' || l_proc, 10);
2904: --
2905: end process_actn_item_reminders;
2906: --
2907: -- ----------------------------------------------------------------------------

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

2928: l_asnd_lf_evt_dt date;
2929: --
2930: begin
2931: --
2932: hr_utility.set_location('Entering ' || l_proc, 10);
2933: --
2934: for l_per_rec in c_per_actn loop
2935: --
2936: g_person_cnt := g_person_cnt + 1;

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

2975: exception
2976: --
2977: when ben_manage_life_events.g_record_error then
2978: --
2979: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
2980: --
2981: rollback to before_communications;
2982: --
2983: benutils.write(p_text => fnd_message.get);

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

3003: person_error_cnt;
3004: --
3005: when others then
3006: --
3007: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
3008: --
3009: rollback to before_communications;
3010: --
3011: g_rec.rep_typ_cd := 'FATAL';

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

3040: ,p_file => true);
3041: --
3042: commit;
3043: --
3044: hr_utility.set_location('Leaving ' || l_proc, 10);
3045: --
3046: end process_enrt_reminders;
3047: --
3048: -- ----------------------------------------------------------------------------

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

3069: --
3070: begin
3071: --
3072: --
3073: hr_utility.set_location('Entering : ' || l_proc, 10);
3074: --
3075: -- get the parameters for a previous run and do a restart
3076: --
3077: open c_parm;

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

3123: -- ,p_popl_enrt_typ_cycl_id => l_parm.popl_enrt_typ_cycl_id
3124: ,p_lf_evt_ocrd_dt => fnd_date.date_to_canonical(l_parm.lf_evt_ocrd_dt)
3125: ,p_audit_log_flag => l_parm.audit_log_flag);
3126: --
3127: hr_utility.set_location('Leaving : ' || l_proc, 10);
3128: --
3129: end restart;
3130: --
3131: -- ----------------------------------------------------------------------------

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

3195: l_commit number;
3196: --
3197: begin
3198: --
3199: hr_utility.set_location('Entering : ' || l_proc, 10);
3200: --
3201: -- Convert varchar2 dates to real dates
3202: -- 1) First remove time component
3203: -- 2) Next convert format

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

3229: open c_parm;
3230: fetch c_parm into g_parm;
3231: close c_parm;
3232: --
3233: hr_utility.set_location(g_parm.business_group_id,100000);
3234: -- Set up benefits environment
3235: --
3236: ben_env_object.init(p_business_group_id => p_business_group_id,
3237: p_effective_date => l_effective_date,

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

3309: -- Write statistics of the process to a log file
3310: --
3311: write_logfile;
3312: --
3313: hr_utility.set_location('Leaving : ' || l_proc, 10);
3314: --
3315: exception
3316: --
3317: when others then

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

3317: when others then
3318: --
3319: rollback;
3320: benutils.write(p_text => sqlerrm);
3321: hr_utility.set_location ('BENTMPCM Error '|| l_proc,10);
3322: g_rec.rep_typ_cd := 'FATAL';
3323: g_rec.error_message_code := sqlcode;
3324: g_rec.text := fnd_message.get;
3325: benutils.write(p_rec => g_rec);

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

3366: l_proc varchar2(80) := g_package || '.create_actions_ranges';
3367: --
3368: begin
3369: --
3370: hr_utility.set_location('Entering : ' || l_proc, 10);
3371: --
3372: if g_parm.person_sel_rl is not null then
3373: --
3374: hr_utility.set_location('Verifying rul',10);

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

3370: hr_utility.set_location('Entering : ' || l_proc, 10);
3371: --
3372: if g_parm.person_sel_rl is not null then
3373: --
3374: hr_utility.set_location('Verifying rul',10);
3375: if not ben_rules.chk_person_selection
3376: (p_person_id => p_person_id
3377: ,p_business_group_id => g_parm.business_group_id
3378: ,p_person_selection_rule_id=> g_parm.person_sel_rl

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

3387: --
3388: --if not(verify_person_type_id(p_person_id => p_person_id,
3389: -- p_person_type_id => g_parm.person_type_id)) then
3390: -- --
3391: -- hr_utility.set_location('Verifying person type',10);
3392: -- l_person_ok := 'N';
3393: -- --
3394: --end if;
3395: --

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

3438: end if;
3439: --
3440: end if;
3441: --
3442: hr_utility.set_location('Leaving : ' || l_proc, 10);
3443: --
3444: exception
3445: when others then
3446: -- For nocopy changes

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

3562: l_proc varchar2(80) := g_package || '.create_enrtrmdr_ranges';
3563: --
3564: begin
3565: --
3566: hr_utility.set_location('Entering : ' || l_proc, 10);
3567: --
3568: hr_utility.set_location('Creating actions and ranges ' || l_proc, 15);
3569: --
3570: for l_per_rec in c_pil_enrtrmdr loop

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

3564: begin
3565: --
3566: hr_utility.set_location('Entering : ' || l_proc, 10);
3567: --
3568: hr_utility.set_location('Creating actions and ranges ' || l_proc, 15);
3569: --
3570: for l_per_rec in c_pil_enrtrmdr loop
3571: --
3572: create_actions_ranges

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

3582: --
3583: If g_person_actn_cnt > 0 and
3584: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
3585: --
3586: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
3587: --
3588: ben_batch_ranges_api.create_batch_ranges
3589: (p_validate => FALSE
3590: ,p_effective_date => g_parm.effective_date

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

3598: g_num_ranges := g_num_ranges + 1;
3599: --
3600: end if;
3601: --
3602: hr_utility.set_location('Leaving : ' || l_proc, 10);
3603: --
3604: end create_enrtrmdr_ranges;
3605: --
3606: -- ----------------------------------------------------------------------------

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

3723: l_proc varchar2(80) := g_package || '.create_actnrmdr_ranges';
3724: --
3725: begin
3726: --
3727: hr_utility.set_location('Entering : ' || l_proc, 10);
3728: --
3729: for l_per_rec in c_per_actnrmdr loop
3730: --
3731: -- Create person actions and batch ranges.

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

3742: --
3743: If g_person_actn_cnt > 0 and
3744: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
3745: --
3746: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
3747: --
3748: ben_batch_ranges_api.create_batch_ranges
3749: (p_validate => FALSE
3750: ,p_effective_date => g_parm.effective_date

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

3758: g_num_ranges := g_num_ranges + 1;
3759: --
3760: end if;
3761: --
3762: hr_utility.set_location('Leaving : ' || l_proc, 10);
3763: --
3764: end create_actnrmdr_ranges;
3765: --
3766: -- ----------------------------------------------------------------------------

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

3935: l_proc varchar2(80) := g_package || '.create_emrtevt_ranges';
3936: --
3937: begin
3938: --
3939: hr_utility.set_location('Entering : ' || l_proc, 10);
3940: --
3941: --
3942: for l_per_rec in c_per_emrgevt loop
3943: --

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

3948: -- For Dependents.
3949: --
3950: if g_parm.elig_enrol_cd = 'ENROL' then
3951: --
3952: hr_utility.set_location('Person is dependent',10);
3953: hr_utility.set_location('Person ID '||l_per_rec.person_id,10);
3954: hr_utility.set_location('BG ID '||g_parm.business_group_id,10);
3955: hr_utility.set_location('EFF DATE '||g_parm.effective_date,10);
3956: hr_utility.set_location('PGM ID '||g_parm.pgm_id,10);

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

3949: --
3950: if g_parm.elig_enrol_cd = 'ENROL' then
3951: --
3952: hr_utility.set_location('Person is dependent',10);
3953: hr_utility.set_location('Person ID '||l_per_rec.person_id,10);
3954: hr_utility.set_location('BG ID '||g_parm.business_group_id,10);
3955: hr_utility.set_location('EFF DATE '||g_parm.effective_date,10);
3956: hr_utility.set_location('PGM ID '||g_parm.pgm_id,10);
3957: hr_utility.set_location('PL_NIP ID '||g_parm.pl_nip_id,10);

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

3950: if g_parm.elig_enrol_cd = 'ENROL' then
3951: --
3952: hr_utility.set_location('Person is dependent',10);
3953: hr_utility.set_location('Person ID '||l_per_rec.person_id,10);
3954: hr_utility.set_location('BG ID '||g_parm.business_group_id,10);
3955: hr_utility.set_location('EFF DATE '||g_parm.effective_date,10);
3956: hr_utility.set_location('PGM ID '||g_parm.pgm_id,10);
3957: hr_utility.set_location('PL_NIP ID '||g_parm.pl_nip_id,10);
3958: hr_utility.set_location('PL_IN PROG FLAG '||g_parm.plan_in_pgm_flag,10);

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

3951: --
3952: hr_utility.set_location('Person is dependent',10);
3953: hr_utility.set_location('Person ID '||l_per_rec.person_id,10);
3954: hr_utility.set_location('BG ID '||g_parm.business_group_id,10);
3955: hr_utility.set_location('EFF DATE '||g_parm.effective_date,10);
3956: hr_utility.set_location('PGM ID '||g_parm.pgm_id,10);
3957: hr_utility.set_location('PL_NIP ID '||g_parm.pl_nip_id,10);
3958: hr_utility.set_location('PL_IN PROG FLAG '||g_parm.plan_in_pgm_flag,10);
3959: open c_dpnt_enrt(l_per_rec.person_id);

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

3952: hr_utility.set_location('Person is dependent',10);
3953: hr_utility.set_location('Person ID '||l_per_rec.person_id,10);
3954: hr_utility.set_location('BG ID '||g_parm.business_group_id,10);
3955: hr_utility.set_location('EFF DATE '||g_parm.effective_date,10);
3956: hr_utility.set_location('PGM ID '||g_parm.pgm_id,10);
3957: hr_utility.set_location('PL_NIP ID '||g_parm.pl_nip_id,10);
3958: hr_utility.set_location('PL_IN PROG FLAG '||g_parm.plan_in_pgm_flag,10);
3959: open c_dpnt_enrt(l_per_rec.person_id);
3960: fetch c_dpnt_enrt into l_pgm_id, l_pl_id;

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

3953: hr_utility.set_location('Person ID '||l_per_rec.person_id,10);
3954: hr_utility.set_location('BG ID '||g_parm.business_group_id,10);
3955: hr_utility.set_location('EFF DATE '||g_parm.effective_date,10);
3956: hr_utility.set_location('PGM ID '||g_parm.pgm_id,10);
3957: hr_utility.set_location('PL_NIP ID '||g_parm.pl_nip_id,10);
3958: hr_utility.set_location('PL_IN PROG FLAG '||g_parm.plan_in_pgm_flag,10);
3959: open c_dpnt_enrt(l_per_rec.person_id);
3960: fetch c_dpnt_enrt into l_pgm_id, l_pl_id;
3961: --

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

3954: hr_utility.set_location('BG ID '||g_parm.business_group_id,10);
3955: hr_utility.set_location('EFF DATE '||g_parm.effective_date,10);
3956: hr_utility.set_location('PGM ID '||g_parm.pgm_id,10);
3957: hr_utility.set_location('PL_NIP ID '||g_parm.pl_nip_id,10);
3958: hr_utility.set_location('PL_IN PROG FLAG '||g_parm.plan_in_pgm_flag,10);
3959: open c_dpnt_enrt(l_per_rec.person_id);
3960: fetch c_dpnt_enrt into l_pgm_id, l_pl_id;
3961: --
3962: if c_dpnt_enrt%found then

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

3960: fetch c_dpnt_enrt into l_pgm_id, l_pl_id;
3961: --
3962: if c_dpnt_enrt%found then
3963: --
3964: hr_utility.set_location('Definately Found record',10);
3965: l_create_action := true;
3966: --
3967: if g_parm.use_fctr_to_sel_flag = 'Y' then
3968: --

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

3965: l_create_action := true;
3966: --
3967: if g_parm.use_fctr_to_sel_flag = 'Y' then
3968: --
3969: hr_utility.set_location('Found record',10);
3970: l_create_action := fctr_belongs_to_comp_object(
3971: p_pgm_id => l_pgm_id,
3972: p_pl_id => l_pl_id);
3973: --

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

4005: close c_elig;
4006: --
4007: elsif g_parm.elig_enrol_cd = 'ENROL' then
4008: --
4009: hr_utility.set_location('Person is participant',10);
4010: open c_enrt(l_per_rec.person_id);
4011: fetch c_enrt into l_pgm_id, l_pl_id;
4012: --
4013: if c_enrt%found then

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

4044: -- Create person actions and batch ranges
4045: --
4046: g_per_slctd := g_per_slctd + 1;
4047: --
4048: hr_utility.set_location('Range created',10);
4049: --
4050: create_actions_ranges
4051: (p_person_id => l_per_rec.person_id
4052: ,p_start_person_action_id => l_start_person_action_id

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

4055: end if;
4056: --
4057: end loop;
4058: --
4059: hr_utility.set_location('People selected from database : ' || g_per_slctd,10);
4060: --
4061: -- There could be a few person actions left over from the call in the for
4062: -- loop above. Create a batch range for them.
4063: --

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

4063: --
4064: If g_person_actn_cnt > 0 and
4065: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
4066: --
4067: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
4068: --
4069: ben_batch_ranges_api.create_batch_ranges
4070: (p_validate => FALSE
4071: ,p_effective_date => g_parm.effective_date

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

4079: g_num_ranges := g_num_ranges + 1;
4080: --
4081: end if;
4082: --
4083: hr_utility.set_location('Leaving : ' || l_proc, 10);
4084: --
4085: end create_emrgevt_ranges;
4086: --
4087: -- ----------------------------------------------------------------------------

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

4462: l_proc varchar2(80) := g_package || '.create_mssmlg_ranges';
4463: --
4464: begin
4465: --
4466: hr_utility.set_location('Entering : ' || l_proc, 10);
4467: --
4468: if (g_parm.elig_enrol_cd = 'ELIG' and g_parm.pgm_id is not null and g_parm.pl_nip_id is null)
4469: then
4470: for l_per_rec in c_per_mssmlg_elig_pgm loop

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

4525: --
4526: end loop;
4527: end if;
4528: --
4529: hr_utility.set_location('People selected from database : ' || g_per_slctd,10);
4530: --
4531: -- There could be a few person actions left over from the call in the for
4532: -- loop above. Create a batch range for them.
4533: --

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

4533: --
4534: If g_person_actn_cnt > 0 and
4535: mod(g_person_actn_cnt, g_chunk_size) <> 0 then
4536: --
4537: hr_utility.set_location('Ranges for remaining people ' || l_proc, 25);
4538: --
4539: ben_batch_ranges_api.create_batch_ranges
4540: (p_validate => FALSE
4541: ,p_effective_date => g_parm.effective_date

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

4549: g_num_ranges := g_num_ranges + 1;
4550: --
4551: end if;
4552: --
4553: hr_utility.set_location('Leaving : ' || l_proc, 10);
4554: --
4555: end create_mssmlg_ranges;
4556: --
4557: -- ----------------------------------------------------------------------------

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

4608: l_lf_evt_ocrd_dt date;
4609: --
4610: begin
4611: --
4612: hr_utility.set_location('Entering : ' || l_proc, 10);
4613: --
4614: -- Convert varchar2 dates to real dates
4615: -- 1) First remove time component
4616: -- 2) Next convert format

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

4691: ,p_threads => g_threads
4692: ,p_chunk_size => g_chunk_size
4693: ,p_max_errors => g_max_errors);
4694: --
4695: hr_utility.set_location('Num Threads = ' || g_threads, 10);
4696: hr_utility.set_location('Chunk Size = ' || g_chunk_size, 10);
4697: hr_utility.set_location('Max Errors = ' || g_max_errors, 10);
4698: --
4699: -- Create benefit actions parameters in the benefit action table.

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

4692: ,p_chunk_size => g_chunk_size
4693: ,p_max_errors => g_max_errors);
4694: --
4695: hr_utility.set_location('Num Threads = ' || g_threads, 10);
4696: hr_utility.set_location('Chunk Size = ' || g_chunk_size, 10);
4697: hr_utility.set_location('Max Errors = ' || g_max_errors, 10);
4698: --
4699: -- Create benefit actions parameters in the benefit action table.
4700: -- If a benefit action already exists, do not create - in other words

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

4693: ,p_max_errors => g_max_errors);
4694: --
4695: hr_utility.set_location('Num Threads = ' || g_threads, 10);
4696: hr_utility.set_location('Chunk Size = ' || g_chunk_size, 10);
4697: hr_utility.set_location('Max Errors = ' || g_max_errors, 10);
4698: --
4699: -- Create benefit actions parameters in the benefit action table.
4700: -- If a benefit action already exists, do not create - in other words
4701: -- we are doing a restart.

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

4780: end if;
4781: --
4782: g_proc_rec.benefit_action_id := g_parm.benefit_action_id;
4783: --
4784: hr_utility.set_location('Number of person actions : ' ||
4785: to_char(g_person_actn_cnt), 10);
4786: --
4787: else -- p_benefit_action_id
4788: --

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

4789: -- Benefit action id is not null i.e. the batch process is being restarted
4790: -- for a certain benefit action id. Create batch ranges and person actions
4791: -- for restarting.
4792: --
4793: hr_utility.set_location('restart batch process ' || l_proc, 20);
4794: --
4795: ben_batch_utils.create_restart_person_actions
4796: (p_benefit_action_id => p_benefit_action_id
4797: ,p_effective_date => l_effective_date

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

4821: -- and the number of ranges created above.
4822: --
4823: g_threads := least(g_threads, g_num_ranges);
4824: --
4825: hr_utility.set_location('Number of Threads : ' || g_threads, 20);
4826: --
4827: -- Submit requests
4828: --
4829: for l_count in 1..(g_threads -1) loop

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

4832: -- process will act as the last thread and will be able to keep track of
4833: -- the child processes. If only one range got created this loop will never
4834: -- be executed and no additional concurrent requests will be submitted.
4835: --
4836: hr_utility.set_location('Sumitting thread : ' || l_count, 25);
4837: --
4838: l_request_id := fnd_request.submit_request
4839: (application => 'BEN'
4840: ,program => 'BENTMPCMT'

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

4863: ,p_thread_id => g_threads
4864: ,p_effective_date => p_effective_date
4865: ,p_business_group_id => p_business_group_id);
4866: --
4867: hr_utility.set_location('Leaving : ' || l_proc, 10);
4868: --
4869: end process;
4870: --
4871: procedure summary_by_action(p_concurrent_request_id in number,

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

5103: and nvl(org.date_to,bft.process_date);
5104: --
5105: begin
5106: --
5107: hr_utility.set_location('Entering :'||l_proc,10);
5108: --
5109: -- Default return values for nulls
5110: --
5111: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');

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

5146: p_concurrent_program_name,
5147: p_status;
5148: close c_benefit_actions;
5149: --
5150: hr_utility.set_location('Leaving :'||l_proc,10);
5151: --
5152: end;
5153: --
5154: --