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.HRHIRAPL dependencies on HRHIRAPL

Line 1: PACKAGE BODY hrhirapl AS

1: PACKAGE BODY hrhirapl AS
2: /* $Header: pehirapl.pkb 120.27.12010000.6 2008/12/12 11:57:05 ghshanka ship $ */
3:
4: --
5: ------------------------- BEGIN: employ_applicant --------------------

Line 127: hr_utility.set_location('IN hrhirapl.table_contents',490);

123: function table_contents return varchar2 is
124: l_appls varchar2(4000); -- Bug 3214063
125: l_max number;
126: BEGIN
127: hr_utility.set_location('IN hrhirapl.table_contents',490);
128: l_max := p_table.COUNT;
129: hr_utility.trace('table rows : '||to_char(l_max));
130: for v_index in 1..l_max loop
131:

Line 136: hr_utility.set_location('OUT hrhirapl.table_contents',495);

132: l_appls := l_appls||' ('||to_char(p_table(v_index).id)||')'
133: ||p_table(v_index).process_flag;
134:
135: END LOOP;
136: hr_utility.set_location('OUT hrhirapl.table_contents',495);
137: return(l_appls);
138: END;
139: --
140: --

Line 701: hr_utility.set_location('hrhirapl.make_secondary',1);

697: begin
698: -- # 2366672
699: -- Application needs to be end dated before the apl asg get updated.
700: --
701: hr_utility.set_location('hrhirapl.make_secondary',1);
702: -- +-----------------------------------------------------------------------+
703: -- +------------------------ End Application -----------------------------+
704: -- +-----------------------------------------------------------------------+
705: -- Does the Retain value exist in the table ?

Line 762: hr_utility.set_location('hrhirapl.make_secondary',2);

758: open get_flex_def;
759: fetch get_flex_def into l_col_name;
760: close get_flex_def;
761: --
762: hr_utility.set_location('hrhirapl.make_secondary',2);
763: --
764: -- Update all accepted assignments making them all
765: -- secondary (also end dates the assignment type 'A'
766: -- Unless the update primary_flag is set, in which case

Line 786: hr_utility.set_location('hrhirapl.make_secondary',333);

782: -- Ensure (R)etain or (E)nd date flags have not been set
783: if hr_employee_applicant_api.is_convert(p_table
784: ,l_asg_rec.assignment_id)
785: then
786: hr_utility.set_location('hrhirapl.make_secondary',333);
787: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));
788: hr_utility.trace(' start date = '||to_char(l_asg_rec.effective_start_date,'dd/mm/yy'));
789:
790: -- +--------------------------------------------------+

Line 1161: hr_utility.set_location('hrhirapl.make_secondary',3);

1157: ,p_employee_number
1158: ,p_assignment_sequence
1159: ,p_assignment_number);
1160: --
1161: hr_utility.set_location('hrhirapl.make_secondary',3);
1162: --
1163: -- fix for 7120387
1164: declare
1165:

Line 1290: hr_utility.set_location('hrhirapl.make_secondary',4);

1286: );
1287: -- End of fix 7289811
1288: -- Bug 401669
1289: --
1290: hr_utility.set_location('hrhirapl.make_secondary',4);
1291: --
1292: hr_assignment.load_budget_values(p_assignment_id
1293: ,p_business_group_id
1294: ,p_user_id

Line 1324: hr_utility.set_location('hrhirapl.make_secondary',5);

1320: -- +--------------------------------------------------+
1321: -- +--- End Date assignment --------------------------+
1322: -- +--------------------------------------------------+
1323: --
1324: hr_utility.set_location('hrhirapl.make_secondary',5);
1325: l_chk_assg_end_dated := 'Y'; -- bug 6310975
1326: begin
1327: update per_assignments_f
1328: set effective_end_date = p_start_date -1

Line 1332: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||

1328: set effective_end_date = p_start_date -1
1329: where current of ass_cur;
1330: exception
1331: when others then
1332: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
1333: to_char(l_asg_rec.assignment_id),66);
1334: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1335: hr_utility.set_message_token('PROCEDURE','make_secondary ');
1336: hr_utility.set_message_token('STEP','4');

Line 1368: hr_utility.set_location('hrhirapl.make_secondary',500);

1364: */
1365: --
1366: --bug fix 6310975
1367:
1368: hr_utility.set_location('hrhirapl.make_secondary',500);
1369: IF l_chk_assg_end_dated <> 'Y' THEN
1370:
1371:
1372: OPEN get_pay_proposal(l_asg_rec.assignment_id);

Line 1376: hr_utility.set_location('hrhirapl.make_secondary',501);

1372: OPEN get_pay_proposal(l_asg_rec.assignment_id);
1373: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date;
1374: if get_pay_proposal%found then
1375: close get_pay_proposal;
1376: hr_utility.set_location('hrhirapl.make_secondary',501);
1377: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);
1378: hr_utility.set_location(' make_secondary.l_dummy_change_date '||l_dummy_change_date,502);
1379: hr_utility.set_location(' make_secondary.l_pay_pspl_id '||l_pay_pspl_id,502);
1380: hr_utility.set_location(' make_secondary.l_proposed_sal_n '|| l_proposed_sal_n,502);

Line 1377: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);

1373: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date;
1374: if get_pay_proposal%found then
1375: close get_pay_proposal;
1376: hr_utility.set_location('hrhirapl.make_secondary',501);
1377: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);
1378: hr_utility.set_location(' make_secondary.l_dummy_change_date '||l_dummy_change_date,502);
1379: hr_utility.set_location(' make_secondary.l_pay_pspl_id '||l_pay_pspl_id,502);
1380: hr_utility.set_location(' make_secondary.l_proposed_sal_n '|| l_proposed_sal_n,502);
1381:

Line 1411: hr_utility.set_location('hrhirapl.make_secondary',521);

1407: OPEN get_pay_proposal(l_asg_rec.assignment_id);
1408: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date;
1409: if get_pay_proposal%found then
1410: close get_pay_proposal;
1411: hr_utility.set_location('hrhirapl.make_secondary',521);
1412: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);
1413:
1414: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
1415: p_validate => false,

Line 1412: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);

1408: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date;
1409: if get_pay_proposal%found then
1410: close get_pay_proposal;
1411: hr_utility.set_location('hrhirapl.make_secondary',521);
1412: hr_utility.set_location('hrhirapl.make_secondary '||l_asg_rec.assignment_id,502);
1413:
1414: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
1415: p_validate => false,
1416: p_pay_proposal_id => l_pay_pspl_id ,

Line 1427: hr_utility.set_location('hrhirapl.make_secondary',522);

1423: p_approved_warning => l_approved_warning,
1424: p_payroll_warning => l_payroll_warning,
1425: p_proposed_salary_n => l_proposed_sal_n,
1426: p_business_group_id => p_business_group_id);
1427: hr_utility.set_location('hrhirapl.make_secondary',522);
1428: else
1429: close get_pay_proposal;
1430: end if;
1431:

Line 1433: hr_utility.set_location('hrhirapl.make_secondary',524);

1429: close get_pay_proposal;
1430: end if;
1431:
1432: end if;
1433: hr_utility.set_location('hrhirapl.make_secondary',524);
1434:
1435: --
1436: --bug fix 6310975
1437: --added by amigarg for bug 4882512 end

Line 1447: hr_utility.set_location('hrhirapl.make_secondary',400);

1443: /*else
1444: -- fix for the bug
1445: -- first process the primary assignment id so that the assignment number is
1446: -- correclty generated
1447: hr_utility.set_location('hrhirapl.make_secondary',400);
1448: open csr_ass_cur_for_primary;
1449: loop
1450: fetch csr_ass_cur_for_primary into l_asg_rec; --#2119831
1451: exit when csr_ass_cur_for_primary%NOTFOUND;

Line 1461: hr_utility.set_location('hrhirapl.make_secondary',401);

1457: -- Ensure (R)etain or (E)nd date flags have not been set
1458: if hr_employee_applicant_api.is_convert(p_table
1459: ,l_asg_rec.assignment_id)
1460: then
1461: hr_utility.set_location('hrhirapl.make_secondary',401);
1462: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));
1463: hr_utility.trace(' start date = '||to_char(l_asg_rec.effective_start_date,'dd/mm/yy'));
1464:
1465: -- +--------------------------------------------------+

Line 1835: hr_utility.set_location('hrhirapl.make_secondary',402);

1831: ,p_employee_number
1832: ,p_assignment_sequence
1833: ,p_assignment_number);
1834: --
1835: hr_utility.set_location('hrhirapl.make_secondary',402);
1836: begin
1837: update per_assignments_f pa
1838: set pa.assignment_status_type_id = p_assignment_status_type_id
1839: , pa.assignment_type = 'E'

Line 1902: hr_utility.set_location('hrhirapl.make_secondary',4);

1898: ,p_object_version_number => l_asg_status_ovn);
1899: -- End of fix 3564129
1900: -- Bug 401669
1901: --
1902: hr_utility.set_location('hrhirapl.make_secondary',4);
1903: --
1904: hr_assignment.load_budget_values(p_assignment_id
1905: ,p_business_group_id
1906: ,p_user_id

Line 1935: hr_utility.set_location('hrhirapl.make_secondary',5);

1931: -- +--------------------------------------------------+
1932: -- +--- End Date assignment --------------------------+
1933: -- +--------------------------------------------------+
1934: --
1935: hr_utility.set_location('hrhirapl.make_secondary',5);
1936: begin
1937: update per_assignments_f
1938: set effective_end_date = p_start_date -1
1939: where current of csr_ass_cur_for_primary;

Line 1942: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||

1938: set effective_end_date = p_start_date -1
1939: where current of csr_ass_cur_for_primary;
1940: exception
1941: when others then
1942: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
1943: to_char(l_asg_rec.assignment_id),66);
1944: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1945: hr_utility.set_message_token('PROCEDURE','make_secondary ');
1946: hr_utility.set_message_token('STEP','4');

Line 1984: hr_utility.set_location('hrhirapl.make_secondary',403);

1980:
1981: -- now process all seconday or non primary assignments
1982:
1983:
1984: hr_utility.set_location('hrhirapl.make_secondary',403);
1985: open csr_ass_cur_for_nonprimary;
1986: loop
1987: fetch csr_ass_cur_for_nonprimary into l_asg_rec; --#2119831
1988: exit when csr_ass_cur_for_nonprimary%NOTFOUND;

Line 1998: hr_utility.set_location('hrhirapl.make_secondary',404);

1994: -- Ensure (R)etain or (E)nd date flags have not been set
1995: if hr_employee_applicant_api.is_convert(p_table
1996: ,l_asg_rec.assignment_id)
1997: then
1998: hr_utility.set_location('hrhirapl.make_secondary',404);
1999: hr_utility.trace(' asg id = '||to_char(l_asg_rec.assignment_id));
2000: hr_utility.trace(' start date = '||to_char(l_asg_rec.effective_start_date,'dd/mm/yy'));
2001:
2002: -- +--------------------------------------------------+

Line 2372: hr_utility.set_location('hrhirapl.make_secondary',405);

2368: ,p_employee_number
2369: ,p_assignment_sequence
2370: ,p_assignment_number);
2371: --
2372: hr_utility.set_location('hrhirapl.make_secondary',405);
2373: begin
2374: update per_assignments_f pa
2375: set pa.assignment_status_type_id = p_assignment_status_type_id
2376: , pa.assignment_type = 'E'

Line 2439: hr_utility.set_location('hrhirapl.make_secondary',406);

2435: ,p_object_version_number => l_asg_status_ovn);
2436: -- End of fix 3564129
2437: -- Bug 401669
2438: --
2439: hr_utility.set_location('hrhirapl.make_secondary',406);
2440: --
2441: hr_assignment.load_budget_values(p_assignment_id
2442: ,p_business_group_id
2443: ,p_user_id

Line 2472: hr_utility.set_location('hrhirapl.make_secondary',407);

2468: -- +--------------------------------------------------+
2469: -- +--- End Date assignment --------------------------+
2470: -- +--------------------------------------------------+
2471: --
2472: hr_utility.set_location('hrhirapl.make_secondary',407);
2473: begin
2474: update per_assignments_f
2475: set effective_end_date = p_start_date -1
2476: where current of csr_ass_cur_for_nonprimary;

Line 2479: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||

2475: set effective_end_date = p_start_date -1
2476: where current of csr_ass_cur_for_nonprimary;
2477: exception
2478: when others then
2479: hr_utility.set_location('hrhirapl.make_secondary ASGID : '||
2480: to_char(l_asg_rec.assignment_id),408);
2481: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2482: hr_utility.set_message_token('PROCEDURE','make_secondary ');
2483: hr_utility.set_message_token('STEP','4');

Line 2517: hr_utility.set_location('hrhirapl.make_secondary',409);

2513:
2514: end loop;
2515: --
2516: close csr_ass_cur_for_nonprimary;
2517: hr_utility.set_location('hrhirapl.make_secondary',409);
2518: end if;
2519: hr_utility.set_location('hrhirapl.make_secondary',410);
2520: -- end of bug 5498344
2521: commented for bug 5589928*/

Line 2519: hr_utility.set_location('hrhirapl.make_secondary',410);

2515: --
2516: close csr_ass_cur_for_nonprimary;
2517: hr_utility.set_location('hrhirapl.make_secondary',409);
2518: end if;
2519: hr_utility.set_location('hrhirapl.make_secondary',410);
2520: -- end of bug 5498344
2521: commented for bug 5589928*/
2522: --
2523: -- add condition: number of updates should be the same as number

Line 2753: hr_utility.set_location('hrhirapl.create_primary_assignment',1);

2749: --
2750: --
2751: begin
2752: --
2753: hr_utility.set_location('hrhirapl.create_primary_assignment',1);
2754: --
2755: -- VT 06/14/00
2756: open cur_apl_asg;
2757: fetch cur_apl_asg into apl_asg_rec;

Line 2792: hr_utility.set_location('hrhirapl.create_primary_assignment',2);

2788: end if;
2789: end;
2790: end if;
2791: --
2792: hr_utility.set_location('hrhirapl.create_primary_assignment',2);
2793: --
2794: begin
2795: --
2796: --

Line 2848: hr_utility.set_location('hrhirapl.employ_applicant',99);

2844: --
2845: -- Bug #4462906 Moved the hrutility call
2846: -- after SQL%ROWCOUNT check
2847: --
2848: hr_utility.set_location('hrhirapl.employ_applicant',99);
2849: --
2850: hrentmnt.maintain_entries_asg(p_new_primary_id
2851: ,p_business_group_id
2852: ,'HIRE_APPL' -- ,'ASG_CRITERIA' for bug 5547271

Line 2862: hr_utility.set_location('hrhirapl.create_primary_assignment',3);

2858: ,p_end_of_time);
2859: end;
2860: else
2861: --
2862: hr_utility.set_location('hrhirapl.create_primary_assignment',3);
2863: --
2864:
2865: declare
2866: --

Line 3115: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment ',3979);

3111: where pa.rowid = p_rowid;
3112: --
3113: -- Added for the bug 6497082 starts here
3114:
3115: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment ',3979);
3116: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment '||apl_asg_rec.assignment_status_type_id,3989);
3117: per_people3_pkg.get_default_person_type
3118: (p_required_type => 'ACTIVE_ASSIGN'
3119: ,p_business_group_id => p_business_group_id

Line 3116: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment '||apl_asg_rec.assignment_status_type_id,3989);

3112: --
3113: -- Added for the bug 6497082 starts here
3114:
3115: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment ',3979);
3116: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment '||apl_asg_rec.assignment_status_type_id,3989);
3117: per_people3_pkg.get_default_person_type
3118: (p_required_type => 'ACTIVE_ASSIGN'
3119: ,p_business_group_id => p_business_group_id
3120: ,p_legislation_code => p_legislation_code

Line 3123: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment '||l_assignment_status_type_id,3999);

3119: ,p_business_group_id => p_business_group_id
3120: ,p_legislation_code => p_legislation_code
3121: ,p_person_type => l_assignment_status_type_id
3122: );
3123: hr_utility.set_location('### 3: hrhirapl.create_primary_assignment '||l_assignment_status_type_id,3999);
3124:
3125: -- Fix For Bug # 7046591 Starts. Added If Clause ---
3126: if emp_asg_rec.vacancy_id is not null then
3127: IRC_ASG_STATUS_API.create_irc_asg_status

Line 3515: hr_utility.set_location('hrhirapl.create_primary_assignment',10);

3511: -- End of Bug 3506363
3512: -- End of BEN Call
3513:
3514: --
3515: hr_utility.set_location('hrhirapl.create_primary_assignment',10);
3516:
3517: --
3518: -- Changed the value for set_of_books_if from p_set_of_books_id to
3519: -- emp_asg_rec.set_of_books_id bug #2398327

Line 3594: hr_utility.set_location('### 4: hrhirapl.create_primary_assignment',3981);

3590: where pa.rowid = p_rowid;
3591: --
3592: -- Added for the bug 6497082 starts here
3593:
3594: hr_utility.set_location('### 4: hrhirapl.create_primary_assignment',3981);
3595: hr_utility.set_location('### 4: hrhirapl.create_primary_assignment'||emp_asg_rec.assignment_status_type_id,3991);
3596: per_people3_pkg.get_default_person_type
3597: (p_required_type => 'ACTIVE_ASSIGN'
3598: ,p_business_group_id => p_business_group_id

Line 3595: hr_utility.set_location('### 4: hrhirapl.create_primary_assignment'||emp_asg_rec.assignment_status_type_id,3991);

3591: --
3592: -- Added for the bug 6497082 starts here
3593:
3594: hr_utility.set_location('### 4: hrhirapl.create_primary_assignment',3981);
3595: hr_utility.set_location('### 4: hrhirapl.create_primary_assignment'||emp_asg_rec.assignment_status_type_id,3991);
3596: per_people3_pkg.get_default_person_type
3597: (p_required_type => 'ACTIVE_ASSIGN'
3598: ,p_business_group_id => p_business_group_id
3599: ,p_legislation_code => p_legislation_code

Line 3898: hr_utility.set_location('hrhirapl.create_primary_assignment',33);

3894: -- end 2433154
3895: end loop;
3896: --
3897: if ass_cur%ROWCOUNT <1 then
3898: hr_utility.set_location('hrhirapl.create_primary_assignment',33);
3899: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3900: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
3901: hr_utility.set_message_token('STEP','3');
3902: hr_utility.raise_error;

Line 3915: hr_utility.set_location('hrhirapl.create_primary_assignment',22);

3911: and p_start_date between pa.effective_start_date
3912: and pa.effective_end_date
3913: for update of pa.effective_end_date;
3914: begin
3915: hr_utility.set_location('hrhirapl.create_primary_assignment',22);
3916: hr_utility.trace(' Update APL asg id => '||to_char(p_new_primary_id));
3917: open app_cur;
3918: loop
3919: fetch app_cur into p_rowid;

Line 3921: hr_utility.set_location('hrhirapl.create_primary_assignment',23);

3917: open app_cur;
3918: loop
3919: fetch app_cur into p_rowid;
3920: exit when app_cur%notfound;
3921: hr_utility.set_location('hrhirapl.create_primary_assignment',23);
3922: update per_assignments_f
3923: set effective_end_date = p_start_date - 1
3924: where rowid = p_rowid;
3925: end loop;

Line 3927: hr_utility.set_location('hrhirapl.create_primary_assignment',44);

3923: set effective_end_date = p_start_date - 1
3924: where rowid = p_rowid;
3925: end loop;
3926: if app_cur%ROWCOUNT <1 then
3927: hr_utility.set_location('hrhirapl.create_primary_assignment',44);
3928: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3929: hr_utility.set_message_token('PROCEDURE','create_primary_assignment');
3930: hr_utility.set_message_token('STEP','4');
3931: hr_utility.raise_error;

Line 4393: hr_utility.set_location('IN hrhirapl.end_unaccepted_app_assign',303);

4389: l_end_date := p_end_date -1;
4390: --
4391: -- #2264569
4392: --
4393: hr_utility.set_location('IN hrhirapl.end_unaccepted_app_assign',303);
4394: open unacc_cur;
4395: loop
4396: fetch unacc_cur into l_asgid;
4397: exit when unacc_cur%NOTFOUND;

Line 4400: hr_utility.set_location('hrhirapl.end_unaccepted_app_assign',305);

4396: fetch unacc_cur into l_asgid;
4397: exit when unacc_cur%NOTFOUND;
4398: begin
4399: if hr_employee_applicant_api.end_date_exists(p_table,l_asgid) <> 2 then
4400: hr_utility.set_location('hrhirapl.end_unaccepted_app_assign',305);
4401: hr_utility.trace(' **** Asg ID : '||to_char(l_asgid));
4402:
4403: update per_assignments pa
4404: set pa.effective_end_date = l_end_date

Line 4442: hr_utility.set_location('OUT hrhirapl.end_unaccepted_app_assign',310);

4438: hr_utility.raise_error;
4439: end;
4440: end loop;
4441: close unacc_cur;
4442: hr_utility.set_location('OUT hrhirapl.end_unaccepted_app_assign',310);
4443:
4444: end end_unaccepted_app_assign;
4445: --
4446: -- +----------------------END: end_unaccepted_app_assign -------------+

Line 4530: end hrhirapl;

4526: end if;
4527: --
4528: end end_bookings;
4529: ----------------------------END: end_bookings --------------------
4530: end hrhirapl;