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

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := ' hr_assignment_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: --
10: -- Procedure update_primary_assg_affectation
11:

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

249: l_identifier varchar2(30);
250:
251: Begin
252:
253: hr_utility.set_location(' Entering:' || l_proc,10);
254: hr_utility.set_location(' Parameters' || l_proc,10);
255: hr_utility.set_location(' p_organization_id:' || p_organization_id,10);
256: hr_utility.set_location(' p_position_id:' || p_position_id,10);
257: hr_utility.set_location(' p_person_id:' || p_person_id,10);

Line 254: hr_utility.set_location(' Parameters' || l_proc,10);

250:
251: Begin
252:
253: hr_utility.set_location(' Entering:' || l_proc,10);
254: hr_utility.set_location(' Parameters' || l_proc,10);
255: hr_utility.set_location(' p_organization_id:' || p_organization_id,10);
256: hr_utility.set_location(' p_position_id:' || p_position_id,10);
257: hr_utility.set_location(' p_person_id:' || p_person_id,10);
258: hr_utility.set_location(' p_job_id:' || p_job_id,10);

Line 255: hr_utility.set_location(' p_organization_id:' || p_organization_id,10);

251: Begin
252:
253: hr_utility.set_location(' Entering:' || l_proc,10);
254: hr_utility.set_location(' Parameters' || l_proc,10);
255: hr_utility.set_location(' p_organization_id:' || p_organization_id,10);
256: hr_utility.set_location(' p_position_id:' || p_position_id,10);
257: hr_utility.set_location(' p_person_id:' || p_person_id,10);
258: hr_utility.set_location(' p_job_id:' || p_job_id,10);
259: hr_utility.set_location(' p_supervisor_id:' || p_supervisor_id,10);

Line 256: hr_utility.set_location(' p_position_id:' || p_position_id,10);

252:
253: hr_utility.set_location(' Entering:' || l_proc,10);
254: hr_utility.set_location(' Parameters' || l_proc,10);
255: hr_utility.set_location(' p_organization_id:' || p_organization_id,10);
256: hr_utility.set_location(' p_position_id:' || p_position_id,10);
257: hr_utility.set_location(' p_person_id:' || p_person_id,10);
258: hr_utility.set_location(' p_job_id:' || p_job_id,10);
259: hr_utility.set_location(' p_supervisor_id:' || p_supervisor_id,10);
260: hr_utility.set_location(' p_assignment_number:' || p_assignment_number,10);

Line 257: hr_utility.set_location(' p_person_id:' || p_person_id,10);

253: hr_utility.set_location(' Entering:' || l_proc,10);
254: hr_utility.set_location(' Parameters' || l_proc,10);
255: hr_utility.set_location(' p_organization_id:' || p_organization_id,10);
256: hr_utility.set_location(' p_position_id:' || p_position_id,10);
257: hr_utility.set_location(' p_person_id:' || p_person_id,10);
258: hr_utility.set_location(' p_job_id:' || p_job_id,10);
259: hr_utility.set_location(' p_supervisor_id:' || p_supervisor_id,10);
260: hr_utility.set_location(' p_assignment_number:' || p_assignment_number,10);
261: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);

Line 258: hr_utility.set_location(' p_job_id:' || p_job_id,10);

254: hr_utility.set_location(' Parameters' || l_proc,10);
255: hr_utility.set_location(' p_organization_id:' || p_organization_id,10);
256: hr_utility.set_location(' p_position_id:' || p_position_id,10);
257: hr_utility.set_location(' p_person_id:' || p_person_id,10);
258: hr_utility.set_location(' p_job_id:' || p_job_id,10);
259: hr_utility.set_location(' p_supervisor_id:' || p_supervisor_id,10);
260: hr_utility.set_location(' p_assignment_number:' || p_assignment_number,10);
261: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
262: hr_utility.set_location(' p_identifier:' || p_identifier,10);

Line 259: hr_utility.set_location(' p_supervisor_id:' || p_supervisor_id,10);

255: hr_utility.set_location(' p_organization_id:' || p_organization_id,10);
256: hr_utility.set_location(' p_position_id:' || p_position_id,10);
257: hr_utility.set_location(' p_person_id:' || p_person_id,10);
258: hr_utility.set_location(' p_job_id:' || p_job_id,10);
259: hr_utility.set_location(' p_supervisor_id:' || p_supervisor_id,10);
260: hr_utility.set_location(' p_assignment_number:' || p_assignment_number,10);
261: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
262: hr_utility.set_location(' p_identifier:' || p_identifier,10);
263: hr_utility.set_location(' p_affectation_type:' || p_affectation_type,10);

Line 260: hr_utility.set_location(' p_assignment_number:' || p_assignment_number,10);

256: hr_utility.set_location(' p_position_id:' || p_position_id,10);
257: hr_utility.set_location(' p_person_id:' || p_person_id,10);
258: hr_utility.set_location(' p_job_id:' || p_job_id,10);
259: hr_utility.set_location(' p_supervisor_id:' || p_supervisor_id,10);
260: hr_utility.set_location(' p_assignment_number:' || p_assignment_number,10);
261: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
262: hr_utility.set_location(' p_identifier:' || p_identifier,10);
263: hr_utility.set_location(' p_affectation_type:' || p_affectation_type,10);
264: hr_utility.set_location(' p_percent_effected:' || p_percent_effected,10);

Line 261: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);

257: hr_utility.set_location(' p_person_id:' || p_person_id,10);
258: hr_utility.set_location(' p_job_id:' || p_job_id,10);
259: hr_utility.set_location(' p_supervisor_id:' || p_supervisor_id,10);
260: hr_utility.set_location(' p_assignment_number:' || p_assignment_number,10);
261: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
262: hr_utility.set_location(' p_identifier:' || p_identifier,10);
263: hr_utility.set_location(' p_affectation_type:' || p_affectation_type,10);
264: hr_utility.set_location(' p_percent_effected:' || p_percent_effected,10);
265: hr_utility.set_location(' p_primary_affectation:' || p_primary_affectation,10);

Line 262: hr_utility.set_location(' p_identifier:' || p_identifier,10);

258: hr_utility.set_location(' p_job_id:' || p_job_id,10);
259: hr_utility.set_location(' p_supervisor_id:' || p_supervisor_id,10);
260: hr_utility.set_location(' p_assignment_number:' || p_assignment_number,10);
261: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
262: hr_utility.set_location(' p_identifier:' || p_identifier,10);
263: hr_utility.set_location(' p_affectation_type:' || p_affectation_type,10);
264: hr_utility.set_location(' p_percent_effected:' || p_percent_effected,10);
265: hr_utility.set_location(' p_primary_affectation:' || p_primary_affectation,10);
266:

Line 263: hr_utility.set_location(' p_affectation_type:' || p_affectation_type,10);

259: hr_utility.set_location(' p_supervisor_id:' || p_supervisor_id,10);
260: hr_utility.set_location(' p_assignment_number:' || p_assignment_number,10);
261: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
262: hr_utility.set_location(' p_identifier:' || p_identifier,10);
263: hr_utility.set_location(' p_affectation_type:' || p_affectation_type,10);
264: hr_utility.set_location(' p_percent_effected:' || p_percent_effected,10);
265: hr_utility.set_location(' p_primary_affectation:' || p_primary_affectation,10);
266:
267: --

Line 264: hr_utility.set_location(' p_percent_effected:' || p_percent_effected,10);

260: hr_utility.set_location(' p_assignment_number:' || p_assignment_number,10);
261: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
262: hr_utility.set_location(' p_identifier:' || p_identifier,10);
263: hr_utility.set_location(' p_affectation_type:' || p_affectation_type,10);
264: hr_utility.set_location(' p_percent_effected:' || p_percent_effected,10);
265: hr_utility.set_location(' p_primary_affectation:' || p_primary_affectation,10);
266:
267: --
268:

Line 265: hr_utility.set_location(' p_primary_affectation:' || p_primary_affectation,10);

261: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
262: hr_utility.set_location(' p_identifier:' || p_identifier,10);
263: hr_utility.set_location(' p_affectation_type:' || p_affectation_type,10);
264: hr_utility.set_location(' p_percent_effected:' || p_percent_effected,10);
265: hr_utility.set_location(' p_primary_affectation:' || p_primary_affectation,10);
266:
267: --
268:
269: -- Issue a savepoint

Line 293: hr_utility.set_location(' CC Id '|| p_soft_coding_keyflex_id,10);

289: fetch common_info_csr into l_people_group_id,l_establishment_id,
290: l_fr_emp_category,l_admin_career_id,l_p_asg_ovn,l_p_normal_hours,l_frequency,l_business_group_id;
291: Close common_info_csr;
292:
293: hr_utility.set_location(' CC Id '|| p_soft_coding_keyflex_id,10);
294:
295: -- Create Affectation : If Affectation is a Primary, then donot pass Position
296: -- instead position will be updated on the assignment by using l_admin_career_id = assignment_id
297: -- on primary assignment

Line 301: hr_utility.set_location(' Admin career id '|| to_char(l_admin_career_id),10);

297: -- on primary assignment
298: -- else Position details will be copied to Affecation details
299: --
300: if (p_primary_affectation = 'Y') then
301: hr_utility.set_location(' Admin career id '|| to_char(l_admin_career_id),10);
302: PQH_FR_ASSIGNMENT_CHK.chk_primary_affectation(p_person_id, p_effective_date,l_admin_career_id);
303: l_position_id := null;
304: else
305: l_position_id := p_position_id;

Line 424: hr_utility.set_location(' Leaving:' || l_proc,20);

420: p_person_id => p_person_id,
421: p_supervisor_id => p_supervisor_id
422: ) ;
423:
424: hr_utility.set_location(' Leaving:' || l_proc,20);
425: --
426: End create_affectation;
427: ---
428: ---

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

518: l_p_id number;
519: l_normal_hours per_all_assignments_f.normal_hours%type;
520: Begin
521:
522: hr_utility.set_location(' Entering:' || l_proc,10);
523: --
524:
525: -- Issue a savepoint
526: --

Line 587: hr_utility.set_location(' Primary Affectation Old :'||l_old_primary_affectation||'New '||p_primary_affectation,10);

583: End if;
584:
585:
586:
587: hr_utility.set_location(' Primary Affectation Old :'||l_old_primary_affectation||'New '||p_primary_affectation,10);
588:
589: pqh_fr_assignment_chk.chk_percent_affected(p_percent_effected,p_person_id,p_effective_date,p_assignment_id);
590: pqh_fr_assignment_chk.chk_position(p_position_id,p_person_id,p_effective_date);
591: pqh_fr_assignment_chk.chk_type(p_affectation_type,p_person_id,p_effective_date,p_position_id);

Line 734: hr_utility.set_location('In condition when an no chages in primary affectation value assignment_id N ', 10);

730: ElsIf (l_old_primary_affectation='N' and p_primary_affectation = 'N') Then
731: --
732: If (pqh_fr_utility.is_worker_employee(p_person_id,p_effective_date)) Then
733: --
734: hr_utility.set_location('In condition when an no chages in primary affectation value assignment_id N ', 10);
735:
736: hr_assignment_api.update_emp_asg_criteria
737: (
738: p_validate => p_validate

Line 1140: hr_utility.set_location(' Leaving:' || l_proc,20);

1136: -- Derive the API return status value based on whether
1137: -- messages of any type exist in the Multiple Message List.
1138: -- Also disable Multiple Message Detection.
1139: --
1140: hr_utility.set_location(' Leaving:' || l_proc,20);
1141:
1142:
1143: end update_affectation;
1144: --

Line 1354: hr_utility.set_location(' Before Loop ' , 10);

1350: 1. Find the all Assignment records whose effective start date > the p_effective_end_date
1351: 2. For all those assignment records compare career details with current rec career detial
1352: If It matches update Employment Terms Information for those records
1353: */
1354: hr_utility.set_location(' Before Loop ' , 10);
1355: --
1356: FOR l_asg_rec in csr_update_admin_career(p_effective_end_date,p_assignment_category,-1
1357: ,NVL(p_reason_for_parttime,-1),NVL(p_comments,-1))
1358: LOOP

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

1892: l_identifier varchar2(30);
1893:
1894: Begin
1895:
1896: hr_utility.set_location(' Entering:' || l_proc,10);
1897: hr_utility.set_location(' Parameters' || l_proc,10);
1898: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
1899: hr_utility.set_location(' p_primary_affectation:' || p_primary_affectation,10);
1900:

Line 1897: hr_utility.set_location(' Parameters' || l_proc,10);

1893:
1894: Begin
1895:
1896: hr_utility.set_location(' Entering:' || l_proc,10);
1897: hr_utility.set_location(' Parameters' || l_proc,10);
1898: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
1899: hr_utility.set_location(' p_primary_affectation:' || p_primary_affectation,10);
1900:
1901: --

Line 1898: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);

1894: Begin
1895:
1896: hr_utility.set_location(' Entering:' || l_proc,10);
1897: hr_utility.set_location(' Parameters' || l_proc,10);
1898: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
1899: hr_utility.set_location(' p_primary_affectation:' || p_primary_affectation,10);
1900:
1901: --
1902:

Line 1899: hr_utility.set_location(' p_primary_affectation:' || p_primary_affectation,10);

1895:
1896: hr_utility.set_location(' Entering:' || l_proc,10);
1897: hr_utility.set_location(' Parameters' || l_proc,10);
1898: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
1899: hr_utility.set_location(' p_primary_affectation:' || p_primary_affectation,10);
1900:
1901: --
1902:
1903: -- Issue a savepoint

Line 2001: hr_utility.set_location(' Leaving:' || l_proc,20);

1997: p_object_version_number => l_p_asg_ovn,
1998: p_person_id => l_person_id
1999: ) ;
2000:
2001: hr_utility.set_location(' Leaving:' || l_proc,20);
2002: --
2003: End terminate_affectation;
2004:
2005: procedure suspend_affectation

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

2061: l_identifier varchar2(30);
2062:
2063: Begin
2064:
2065: hr_utility.set_location(' Entering:' || l_proc,10);
2066: hr_utility.set_location(' Parameters' || l_proc,10);
2067: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
2068:
2069:

Line 2066: hr_utility.set_location(' Parameters' || l_proc,10);

2062:
2063: Begin
2064:
2065: hr_utility.set_location(' Entering:' || l_proc,10);
2066: hr_utility.set_location(' Parameters' || l_proc,10);
2067: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
2068:
2069:
2070: --

Line 2067: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);

2063: Begin
2064:
2065: hr_utility.set_location(' Entering:' || l_proc,10);
2066: hr_utility.set_location(' Parameters' || l_proc,10);
2067: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
2068:
2069:
2070: --
2071:

Line 2149: hr_utility.set_location(' Leaving:' || l_proc,20);

2145: -- messages of any type exist in the Multiple Message List.
2146: -- Also disable Multiple Message Detection.
2147: --
2148:
2149: hr_utility.set_location(' Leaving:' || l_proc,20);
2150: --
2151: End suspend_affectation;
2152:
2153: procedure activate_affectation

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

2220: l_percent_affected varchar2(30);
2221:
2222: Begin
2223:
2224: hr_utility.set_location(' Entering:' || l_proc,10);
2225: hr_utility.set_location(' Parameters' || l_proc,10);
2226: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
2227:
2228:

Line 2225: hr_utility.set_location(' Parameters' || l_proc,10);

2221:
2222: Begin
2223:
2224: hr_utility.set_location(' Entering:' || l_proc,10);
2225: hr_utility.set_location(' Parameters' || l_proc,10);
2226: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
2227:
2228:
2229: --

Line 2226: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);

2222: Begin
2223:
2224: hr_utility.set_location(' Entering:' || l_proc,10);
2225: hr_utility.set_location(' Parameters' || l_proc,10);
2226: hr_utility.set_location(' p_assignment_status_type_id:' || p_assignment_status_type_id,10);
2227:
2228:
2229: --
2230:

Line 2311: hr_utility.set_location(' Leaving:' || l_proc,20);

2307: -- messages of any type exist in the Multiple Message List.
2308: -- Also disable Multiple Message Detection.
2309: --
2310:
2311: hr_utility.set_location(' Leaving:' || l_proc,20);
2312: --
2313: End activate_affectation;
2314: --
2315: end pqh_fr_assignment_api;