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

Line 2312: hr_utility.set_location( 'Returning Y ',130);

2308: person_ug_map_rec_table(ug_index).user_group_id := p_user_group_id;
2309: person_ug_map_rec_table(ug_index).is_person_matches_ug := is_avail;
2310:
2311: if(is_avail = true) then
2312: hr_utility.set_location( 'Returning Y ',130);
2313: return 'Y';
2314: else
2315: hr_utility.set_location( 'Returning N ',130);
2316: return 'N';

Line 2315: hr_utility.set_location( 'Returning N ',130);

2311: if(is_avail = true) then
2312: hr_utility.set_location( 'Returning Y ',130);
2313: return 'Y';
2314: else
2315: hr_utility.set_location( 'Returning N ',130);
2316: return 'N';
2317: end if;
2318:
2319: end is_learner_in_user_group;

Line 2336: hr_utility.set_location( 'Entered ota_learner_access_util.is_learner_matches_user_group ',130);

2332: begin
2333: for elements in csr_user_group_elements(p_user_group_id, p_business_group_id, p_ignore_ug_date_check) loop
2334:
2335: l_user_group_operator := elements.user_group_operator;
2336: hr_utility.set_location( 'Entered ota_learner_access_util.is_learner_matches_user_group ',130);
2337: hr_utility.set_location( 'p_person_id :'||p_person_id,130);
2338: hr_utility.set_location( 'p_user_group_id :'||p_user_group_id,130);
2339: hr_utility.set_location( 'l_user_group_operator :'||l_user_group_operator,130);
2340: hr_utility.set_location( 'elements.person_id :'|| elements.person_id,130);

Line 2337: hr_utility.set_location( 'p_person_id :'||p_person_id,130);

2333: for elements in csr_user_group_elements(p_user_group_id, p_business_group_id, p_ignore_ug_date_check) loop
2334:
2335: l_user_group_operator := elements.user_group_operator;
2336: hr_utility.set_location( 'Entered ota_learner_access_util.is_learner_matches_user_group ',130);
2337: hr_utility.set_location( 'p_person_id :'||p_person_id,130);
2338: hr_utility.set_location( 'p_user_group_id :'||p_user_group_id,130);
2339: hr_utility.set_location( 'l_user_group_operator :'||l_user_group_operator,130);
2340: hr_utility.set_location( 'elements.person_id :'|| elements.person_id,130);
2341: hr_utility.set_location( 'elements.elig_prfl_id :'||elements.elig_prfl_id,130);

Line 2338: hr_utility.set_location( 'p_user_group_id :'||p_user_group_id,130);

2334:
2335: l_user_group_operator := elements.user_group_operator;
2336: hr_utility.set_location( 'Entered ota_learner_access_util.is_learner_matches_user_group ',130);
2337: hr_utility.set_location( 'p_person_id :'||p_person_id,130);
2338: hr_utility.set_location( 'p_user_group_id :'||p_user_group_id,130);
2339: hr_utility.set_location( 'l_user_group_operator :'||l_user_group_operator,130);
2340: hr_utility.set_location( 'elements.person_id :'|| elements.person_id,130);
2341: hr_utility.set_location( 'elements.elig_prfl_id :'||elements.elig_prfl_id,130);
2342:

Line 2339: hr_utility.set_location( 'l_user_group_operator :'||l_user_group_operator,130);

2335: l_user_group_operator := elements.user_group_operator;
2336: hr_utility.set_location( 'Entered ota_learner_access_util.is_learner_matches_user_group ',130);
2337: hr_utility.set_location( 'p_person_id :'||p_person_id,130);
2338: hr_utility.set_location( 'p_user_group_id :'||p_user_group_id,130);
2339: hr_utility.set_location( 'l_user_group_operator :'||l_user_group_operator,130);
2340: hr_utility.set_location( 'elements.person_id :'|| elements.person_id,130);
2341: hr_utility.set_location( 'elements.elig_prfl_id :'||elements.elig_prfl_id,130);
2342:
2343: if elements.user_group_operator is not null and elements.user_group_operator = 'AND' then

Line 2340: hr_utility.set_location( 'elements.person_id :'|| elements.person_id,130);

2336: hr_utility.set_location( 'Entered ota_learner_access_util.is_learner_matches_user_group ',130);
2337: hr_utility.set_location( 'p_person_id :'||p_person_id,130);
2338: hr_utility.set_location( 'p_user_group_id :'||p_user_group_id,130);
2339: hr_utility.set_location( 'l_user_group_operator :'||l_user_group_operator,130);
2340: hr_utility.set_location( 'elements.person_id :'|| elements.person_id,130);
2341: hr_utility.set_location( 'elements.elig_prfl_id :'||elements.elig_prfl_id,130);
2342:
2343: if elements.user_group_operator is not null and elements.user_group_operator = 'AND' then
2344: if elements.person_id is not null and elements.person_id <> p_person_id then

Line 2341: hr_utility.set_location( 'elements.elig_prfl_id :'||elements.elig_prfl_id,130);

2337: hr_utility.set_location( 'p_person_id :'||p_person_id,130);
2338: hr_utility.set_location( 'p_user_group_id :'||p_user_group_id,130);
2339: hr_utility.set_location( 'l_user_group_operator :'||l_user_group_operator,130);
2340: hr_utility.set_location( 'elements.person_id :'|| elements.person_id,130);
2341: hr_utility.set_location( 'elements.elig_prfl_id :'||elements.elig_prfl_id,130);
2342:
2343: if elements.user_group_operator is not null and elements.user_group_operator = 'AND' then
2344: if elements.person_id is not null and elements.person_id <> p_person_id then
2345: hr_utility.set_location( 'elements.person_id is not null and elements.person_id <> p_person_id',130);

Line 2345: hr_utility.set_location( 'elements.person_id is not null and elements.person_id <> p_person_id',130);

2341: hr_utility.set_location( 'elements.elig_prfl_id :'||elements.elig_prfl_id,130);
2342:
2343: if elements.user_group_operator is not null and elements.user_group_operator = 'AND' then
2344: if elements.person_id is not null and elements.person_id <> p_person_id then
2345: hr_utility.set_location( 'elements.person_id is not null and elements.person_id <> p_person_id',130);
2346: return false;
2347: elsif elements.elig_prfl_id is not null then
2348: hr_utility.set_location( 'elements.elig_prfl_id is not null',130);
2349: if ota_elig_profile_util.check_processing_status(p_user_group_id) <> 'A' then --by default return false for AND

Line 2348: hr_utility.set_location( 'elements.elig_prfl_id is not null',130);

2344: if elements.person_id is not null and elements.person_id <> p_person_id then
2345: hr_utility.set_location( 'elements.person_id is not null and elements.person_id <> p_person_id',130);
2346: return false;
2347: elsif elements.elig_prfl_id is not null then
2348: hr_utility.set_location( 'elements.elig_prfl_id is not null',130);
2349: if ota_elig_profile_util.check_processing_status(p_user_group_id) <> 'A' then --by default return false for AND
2350: hr_utility.set_location( 'processing_status <> A returns false',130);
2351: return false;
2352: else

Line 2350: hr_utility.set_location( 'processing_status <> A returns false',130);

2346: return false;
2347: elsif elements.elig_prfl_id is not null then
2348: hr_utility.set_location( 'elements.elig_prfl_id is not null',130);
2349: if ota_elig_profile_util.check_processing_status(p_user_group_id) <> 'A' then --by default return false for AND
2350: hr_utility.set_location( 'processing_status <> A returns false',130);
2351: return false;
2352: else
2353: --if record doesnot exist in resolved data return false
2354: if ota_elig_profile_util.is_learner_in_resolved_ug_data(p_user_group_id,p_person_id, 'A')= 'N' then

Line 2355: hr_utility.set_location( 'learner not in resolved data return true',130);

2351: return false;
2352: else
2353: --if record doesnot exist in resolved data return false
2354: if ota_elig_profile_util.is_learner_in_resolved_ug_data(p_user_group_id,p_person_id, 'A')= 'N' then
2355: hr_utility.set_location( 'learner not in resolved data return true',130);
2356: return false;
2357: end if;
2358: end if;
2359:

Line 2361: hr_utility.set_location( 'elements.child_user_group_id is not null',130);

2357: end if;
2358: end if;
2359:
2360: elsif elements.child_user_group_id is not null then
2361: hr_utility.set_location( 'elements.child_user_group_id is not null',130);
2362:
2363: for i in 1 .. person_ug_map_rec_table.count loop
2364: l_person_id := person_ug_map_rec_table(i).person_id;
2365: l_user_group_id := person_ug_map_rec_table(i).user_group_id;

Line 2368: hr_utility.set_location( 'l_person_id :'||l_person_id,130);

2364: l_person_id := person_ug_map_rec_table(i).person_id;
2365: l_user_group_id := person_ug_map_rec_table(i).user_group_id;
2366: l_is_avail := person_ug_map_rec_table(i).is_person_matches_ug;
2367:
2368: hr_utility.set_location( 'l_person_id :'||l_person_id,130);
2369: hr_utility.set_location( 'l_user_group_id :'||l_user_group_id,130);
2370: if( l_person_id is not null and l_person_id = p_person_id and
2371: l_user_group_id is not null and l_user_group_id = elements.child_user_group_id and
2372: l_is_avail is not null and l_is_avail = false) then

Line 2369: hr_utility.set_location( 'l_user_group_id :'||l_user_group_id,130);

2365: l_user_group_id := person_ug_map_rec_table(i).user_group_id;
2366: l_is_avail := person_ug_map_rec_table(i).is_person_matches_ug;
2367:
2368: hr_utility.set_location( 'l_person_id :'||l_person_id,130);
2369: hr_utility.set_location( 'l_user_group_id :'||l_user_group_id,130);
2370: if( l_person_id is not null and l_person_id = p_person_id and
2371: l_user_group_id is not null and l_user_group_id = elements.child_user_group_id and
2372: l_is_avail is not null and l_is_avail = false) then
2373: hr_utility.set_location( 'if satisfied so false',130);

Line 2373: hr_utility.set_location( 'if satisfied so false',130);

2369: hr_utility.set_location( 'l_user_group_id :'||l_user_group_id,130);
2370: if( l_person_id is not null and l_person_id = p_person_id and
2371: l_user_group_id is not null and l_user_group_id = elements.child_user_group_id and
2372: l_is_avail is not null and l_is_avail = false) then
2373: hr_utility.set_location( 'if satisfied so false',130);
2374: return false;
2375: end if;
2376: end loop;
2377: else

Line 2378: hr_utility.set_location( 'assignment match',130);

2374: return false;
2375: end if;
2376: end loop;
2377: else
2378: hr_utility.set_location( 'assignment match',130);
2379: if person_matches_assoc(p_person_id, sysdate, elements.person_id, elements.organization_id, elements.org_structure_version_id, elements.job_id, elements.position_id, elements.match_type) = false then
2380: return false;
2381: end if;
2382: end if;

Line 2419: hr_utility.set_location( 'Done with everything',130);

2415: end if;
2416: end if;
2417: end loop;
2418:
2419: hr_utility.set_location( 'Done with everything',130);
2420: if l_user_group_operator is not null and l_user_group_operator = 'AND' then
2421: hr_utility.set_location( 'Returning true from is_learner_matches_user_group ',130);
2422: return true;
2423: else

Line 2421: hr_utility.set_location( 'Returning true from is_learner_matches_user_group ',130);

2417: end loop;
2418:
2419: hr_utility.set_location( 'Done with everything',130);
2420: if l_user_group_operator is not null and l_user_group_operator = 'AND' then
2421: hr_utility.set_location( 'Returning true from is_learner_matches_user_group ',130);
2422: return true;
2423: else
2424: return false;
2425: end if;