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

Line 106: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',5);

102: --
103: BEGIN
104: p_del_flag := 'N';
105:
106: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',5);
107: hr_utility.set_location(p_date_end,6);
108:
109: BEGIN
110:

Line 107: hr_utility.set_location(p_date_end,6);

103: BEGIN
104: p_del_flag := 'N';
105:
106: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',5);
107: hr_utility.set_location(p_date_end,6);
108:
109: BEGIN
110:
111: select 'Y'

Line 131: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',10);

127: END;
128: --
129: IF p_del_flag = 'Y' THEN
130: --
131: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',10);
132: --
133: delete from per_assignment_budget_values_f abv
134: where exists (
135: Select null

Line 151: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',15);

147: END IF;
148:
149: p_del_flag := 'N';
150: --
151: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',15);
152: --
153: -- Check for and update any assignment budget value row(s) where the termination end date occurs during the
154: -- life of the assignment budget value row(s).
155: --

Line 179: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',20);

175: END;
176:
177: IF p_del_flag = 'Y' THEN
178: --
179: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',20);
180: --
181: --
182: -- Start of fix for WWBUG 1408379
183: --

Line 281: hr_utility.set_location('PER_APPLICATIONS_PKG.cancel_update_ass_bud_val',5);

277: --
278: BEGIN
279: p_del_flag := 'N';
280:
281: hr_utility.set_location('PER_APPLICATIONS_PKG.cancel_update_ass_bud_val',5);
282:
283: --
284: BEGIN
285:

Line 307: hr_utility.set_location('PER_APPLICATIONS_PKG.cancel_update_ass_bud_val',10);

303: END;
304:
305: IF p_del_flag = 'Y' THEN
306: --
307: hr_utility.set_location('PER_APPLICATIONS_PKG.cancel_update_ass_bud_val',10);
308: --
309: --
310: -- Start of fix for WWBUG 1408379
311: --

Line 919: hr_utility.set_message(800,'PER_7594_APP_TERM_EMP_HIRE');

915: OPEN c_hired_emp;
916: FETCH c_hired_emp INTO v_dummy_hired_emp;
917: IF c_hired_emp%FOUND THEN
918: CLOSE c_hired_emp;
919: hr_utility.set_message(800,'PER_7594_APP_TERM_EMP_HIRE');
920: hr_utility.raise_error;
921: ELSE CLOSE c_hired_emp;
922: END IF;
923: END cancel_chk_current_emp;

Line 920: hr_utility.raise_error;

916: FETCH c_hired_emp INTO v_dummy_hired_emp;
917: IF c_hired_emp%FOUND THEN
918: CLOSE c_hired_emp;
919: hr_utility.set_message(800,'PER_7594_APP_TERM_EMP_HIRE');
920: hr_utility.raise_error;
921: ELSE CLOSE c_hired_emp;
922: END IF;
923: END cancel_chk_current_emp;
924: -----------------------------------------------------------------------------

Line 1276: hr_utility.set_message(801,'HR_6385_APP_TERM_FUT_CHANGES' );

1272: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
1273: open c2;
1274: fetch c2 into l_dummy;
1275: if c2%found then
1276: hr_utility.set_message(801,'HR_6385_APP_TERM_FUT_CHANGES' );
1277: hr_utility.raise_error ;
1278: end if;
1279: close c2;
1280: else

Line 1277: hr_utility.raise_error ;

1273: open c2;
1274: fetch c2 into l_dummy;
1275: if c2%found then
1276: hr_utility.set_message(801,'HR_6385_APP_TERM_FUT_CHANGES' );
1277: hr_utility.raise_error ;
1278: end if;
1279: close c2;
1280: else
1281: hr_utility.set_message(801,'HR_6385_APP_TERM_FUT_CHANGES' );

Line 1281: hr_utility.set_message(801,'HR_6385_APP_TERM_FUT_CHANGES' );

1277: hr_utility.raise_error ;
1278: end if;
1279: close c2;
1280: else
1281: hr_utility.set_message(801,'HR_6385_APP_TERM_FUT_CHANGES' );
1282: hr_utility.raise_error ;
1283: end if;
1284: end if;
1285: close c1 ;

Line 1282: hr_utility.raise_error ;

1278: end if;
1279: close c2;
1280: else
1281: hr_utility.set_message(801,'HR_6385_APP_TERM_FUT_CHANGES' );
1282: hr_utility.raise_error ;
1283: end if;
1284: end if;
1285: close c1 ;
1286: end canc_chk_fut_per_changes ;

Line 1315: hr_utility.set_message(800,'HR_6382_APP_TERM_FUTURE_PPT');

1311: OPEN c_per_changes;
1312: FETCH c_per_changes INTO v_dummy_number;
1313: IF c_per_changes%FOUND THEN
1314: CLOSE c_per_changes;
1315: hr_utility.set_message(800,'HR_6382_APP_TERM_FUTURE_PPT');
1316: hr_utility.set_message_token('DATE',P_date_end);
1317: hr_utility.raise_error;
1318: ELSE CLOSE c_per_changes;
1319: END IF;

Line 1316: hr_utility.set_message_token('DATE',P_date_end);

1312: FETCH c_per_changes INTO v_dummy_number;
1313: IF c_per_changes%FOUND THEN
1314: CLOSE c_per_changes;
1315: hr_utility.set_message(800,'HR_6382_APP_TERM_FUTURE_PPT');
1316: hr_utility.set_message_token('DATE',P_date_end);
1317: hr_utility.raise_error;
1318: ELSE CLOSE c_per_changes;
1319: END IF;
1320: --

Line 1317: hr_utility.raise_error;

1313: IF c_per_changes%FOUND THEN
1314: CLOSE c_per_changes;
1315: hr_utility.set_message(800,'HR_6382_APP_TERM_FUTURE_PPT');
1316: hr_utility.set_message_token('DATE',P_date_end);
1317: hr_utility.raise_error;
1318: ELSE CLOSE c_per_changes;
1319: END IF;
1320: --
1321: END term_chk_fut_per_changes;

Line 1349: hr_utility.set_message(800,'HR_6583_APP_TERM_FUT_ASS');

1345: OPEN c_assign_changes;
1346: FETCH c_assign_changes INTO v_number;
1347: IF c_assign_changes%FOUND THEN
1348: CLOSE c_assign_changes;
1349: hr_utility.set_message(800,'HR_6583_APP_TERM_FUT_ASS');
1350: hr_utility.set_message_token('DATE',P_date_end);
1351: hr_utility.raise_error;
1352: ELSE CLOSE c_assign_changes;
1353: END IF;

Line 1350: hr_utility.set_message_token('DATE',P_date_end);

1346: FETCH c_assign_changes INTO v_number;
1347: IF c_assign_changes%FOUND THEN
1348: CLOSE c_assign_changes;
1349: hr_utility.set_message(800,'HR_6583_APP_TERM_FUT_ASS');
1350: hr_utility.set_message_token('DATE',P_date_end);
1351: hr_utility.raise_error;
1352: ELSE CLOSE c_assign_changes;
1353: END IF;
1354: --

Line 1351: hr_utility.raise_error;

1347: IF c_assign_changes%FOUND THEN
1348: CLOSE c_assign_changes;
1349: hr_utility.set_message(800,'HR_6583_APP_TERM_FUT_ASS');
1350: hr_utility.set_message_token('DATE',P_date_end);
1351: hr_utility.raise_error;
1352: ELSE CLOSE c_assign_changes;
1353: END IF;
1354: --
1355: END term_chk_fut_assign_changes;

Line 1724: hr_utility.set_message(800,'HR_7105_APPL_ALREADY_TERMED');

1720: OPEN c_chk_already_term;
1721: FETCH c_chk_already_term into V_dummy_1;
1722: IF c_chk_already_term%found THEN
1723: CLOSE c_chk_already_term;
1724: hr_utility.set_message(800,'HR_7105_APPL_ALREADY_TERMED');
1725: hr_utility.raise_error;
1726: ELSE
1727: CLOSE c_chk_already_term;
1728: END IF;

Line 1725: hr_utility.raise_error;

1721: FETCH c_chk_already_term into V_dummy_1;
1722: IF c_chk_already_term%found THEN
1723: CLOSE c_chk_already_term;
1724: hr_utility.set_message(800,'HR_7105_APPL_ALREADY_TERMED');
1725: hr_utility.raise_error;
1726: ELSE
1727: CLOSE c_chk_already_term;
1728: END IF;
1729: END chk_not_already_termed;

Line 2463: hr_utility.set_location('per_applications_pkg.update_row',10);

2459: where person_id = p_person_id
2460: and date_received > p_date_received;
2461:
2462: BEGIN
2463: hr_utility.set_location('per_applications_pkg.update_row',10);
2464:
2465: -- ER FPT
2466: IF (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
2467: -- Reverse Terminating the End Application

Line 2473: hr_utility.set_location('Future APL exists on : '||apl.application_id,12);

2469: -- looping through the future APL
2470: for apl in future_apln loop
2471:
2472:
2473: hr_utility.set_location('Future APL exists on : '||apl.application_id,12);
2474: -- updating the assignments whose APL ID is in future with current APL ID
2475: update per_all_assignments_f
2476: set application_id = p_application_id
2477: where application_id = apl.application_id

Line 2488: hr_utility.set_location('Cancelling future APL records on PTU on : '||ptu_rec.effective_start_date,12);

2484:
2485: -- looping through the future PTU records of APL
2486: for ptu_rec in fpt_ptu_apl loop
2487:
2488: hr_utility.set_location('Cancelling future APL records on PTU on : '||ptu_rec.effective_start_date,12);
2489: l_person_type_id1 := ptu_rec.person_type_id;
2490: delete from per_person_type_usages_f
2491: where person_id = p_person_id
2492: and effective_start_date = ptu_rec.effective_start_date

Line 2525: hr_utility.set_location('Updating PER record on : '||per_rec.effective_start_date,12);

2521: elsif hr_general2.is_person_type(p_person_id,'EX_EMP',per_rec.effective_start_date) then
2522: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id(p_business_group_id,'EX_EMP_APL');
2523: end if;
2524:
2525: hr_utility.set_location('Updating PER record on : '||per_rec.effective_start_date,12);
2526:
2527: update per_all_people_f
2528: set person_type_id = l_person_type_id1
2529: ,current_applicant_flag = 'Y'

Line 2559: hr_utility.set_location('Creating a new APL with ID : '||l_new_application_id,15);

2555: if chk_apl_exists%notfound then
2556:
2557: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;
2558: l_current_apl_id := l_new_application_id;
2559: hr_utility.set_location('Creating a new APL with ID : '||l_new_application_id,15);
2560: begin
2561: -- If there is no APL, creating the new APL
2562: INSERT INTO PER_APPLICATIONS(
2563: application_id,

Line 2676: -- hr_utility.set_location('per_applications_pkg.update_row',20); --Commented to resolve Bug#13934184

2672: appl_attribute20 = p_Appl_Attribute20
2673: WHERE rowid = p_rowid;
2674: end if;*/
2675: -- Bug 3053711 End
2676: -- hr_utility.set_location('per_applications_pkg.update_row',20); --Commented to resolve Bug#13934184
2677: if (SQL%NOTFOUND) then
2678: RAISE NO_DATA_FOUND;
2679: end if;
2680:

Line 2681: hr_utility.set_location('per_applications_pkg.update_row',30);

2677: if (SQL%NOTFOUND) then
2678: RAISE NO_DATA_FOUND;
2679: end if;
2680:
2681: hr_utility.set_location('per_applications_pkg.update_row',30);
2682: --
2683: -- Now maintain the PTU data...
2684: --
2685: -- 3652025: Another package will do the updates when performing a termination.

Line 2696: --hr_utility.set_location('per_applications_pkg.update_row',40);

2692: -- terminated application.
2693: --
2694: -- PTU : Following code added for PTU
2695: --
2696: --hr_utility.set_location('per_applications_pkg.update_row',40);
2697:
2698: --Bug No 3891787 starts here
2699: --Open csr_ptu_row1;
2700: --fetch csr_ptu_row1 into l_person_type_id,l_start_date;

Line 2721: --hr_utility.set_location('per_applications_pkg.update_row',50);

2717: -- );
2718: --end if;
2719: --close csr_ptu_row1;
2720: --Bug No 3891787 ends here
2721: --hr_utility.set_location('per_applications_pkg.update_row',50);
2722: -- End of PTU Changes
2723: --
2724: -- hr_per_type_usage_internal.maintain_ptu(
2725: -- p_action => 'TERM_APL',

Line 2747: hr_utility.set_location('per_applications_pkg.update_row',60);

2743: -- Bug 10286850
2744: open csr_chk_emp;
2745: fetch csr_chk_emp into l_person_id;
2746: if csr_chk_emp%found then
2747: hr_utility.set_location('per_applications_pkg.update_row',60);
2748: hr_utility.set_message(800,'PER_7594_APP_TERM_EMP_HIRE');
2749: hr_utility.raise_error;
2750: end if;
2751: close csr_chk_emp;

Line 2748: hr_utility.set_message(800,'PER_7594_APP_TERM_EMP_HIRE');

2744: open csr_chk_emp;
2745: fetch csr_chk_emp into l_person_id;
2746: if csr_chk_emp%found then
2747: hr_utility.set_location('per_applications_pkg.update_row',60);
2748: hr_utility.set_message(800,'PER_7594_APP_TERM_EMP_HIRE');
2749: hr_utility.raise_error;
2750: end if;
2751: close csr_chk_emp;
2752:

Line 2749: hr_utility.raise_error;

2745: fetch csr_chk_emp into l_person_id;
2746: if csr_chk_emp%found then
2747: hr_utility.set_location('per_applications_pkg.update_row',60);
2748: hr_utility.set_message(800,'PER_7594_APP_TERM_EMP_HIRE');
2749: hr_utility.raise_error;
2750: end if;
2751: close csr_chk_emp;
2752:
2753: hr_utility.set_location('per_applications_pkg.p_date_received = '||to_char(p_date_received,'DD/MM/YYYY'),60);

Line 2753: hr_utility.set_location('per_applications_pkg.p_date_received = '||to_char(p_date_received,'DD/MM/YYYY'),60);

2749: hr_utility.raise_error;
2750: end if;
2751: close csr_chk_emp;
2752:
2753: hr_utility.set_location('per_applications_pkg.p_date_received = '||to_char(p_date_received,'DD/MM/YYYY'),60);
2754: hr_utility.set_location('per_applications_pkg.p_date_end = '||to_char(l_date_end,'DD/MM/YYYY'),60);
2755: hr_utility.set_location('per_applications_pkg.p_person_id = '||to_char(p_person_id),60);
2756:
2757: if l_date_end is not null then

Line 2754: hr_utility.set_location('per_applications_pkg.p_date_end = '||to_char(l_date_end,'DD/MM/YYYY'),60);

2750: end if;
2751: close csr_chk_emp;
2752:
2753: hr_utility.set_location('per_applications_pkg.p_date_received = '||to_char(p_date_received,'DD/MM/YYYY'),60);
2754: hr_utility.set_location('per_applications_pkg.p_date_end = '||to_char(l_date_end,'DD/MM/YYYY'),60);
2755: hr_utility.set_location('per_applications_pkg.p_person_id = '||to_char(p_person_id),60);
2756:
2757: if l_date_end is not null then
2758: hr_per_type_usage_internal.cancel_person_type_usage

Line 2755: hr_utility.set_location('per_applications_pkg.p_person_id = '||to_char(p_person_id),60);

2751: close csr_chk_emp;
2752:
2753: hr_utility.set_location('per_applications_pkg.p_date_received = '||to_char(p_date_received,'DD/MM/YYYY'),60);
2754: hr_utility.set_location('per_applications_pkg.p_date_end = '||to_char(l_date_end,'DD/MM/YYYY'),60);
2755: hr_utility.set_location('per_applications_pkg.p_person_id = '||to_char(p_person_id),60);
2756:
2757: if l_date_end is not null then
2758: hr_per_type_usage_internal.cancel_person_type_usage
2759: (

Line 2842: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 10);

2838: and paa.effective_end_date = p_date_end;
2839: --
2840: begin
2841: --
2842: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 10);
2843: --
2844: -- Termination of applicant
2845: if p_action = 'TERM' then
2846: --

Line 2849: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 20);

2845: if p_action = 'TERM' then
2846: --
2847: l_ass_status := 'TERM_APL';
2848: --
2849: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 20);
2850: --
2851: open csr_get_asg_status;
2852: fetch csr_get_asg_status into l_ass_status_type_id;
2853: close csr_get_asg_status;

Line 2875: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 30);

2871: else
2872: --
2873: l_ass_status := 'ACTIVE_APL';
2874: --
2875: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 30);
2876: --
2877: open csr_get_asg_status;
2878: fetch csr_get_asg_status into l_ass_status_type_id;
2879: close csr_get_asg_status;

Line 2898: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 40);

2894: close csr_cancel_ass_id;
2895: --
2896: end if;
2897: --
2898: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 40);
2899: --
2900: end maintain_irc_ass_status;
2901: --
2902: END PER_APPLICATIONS_PKG;