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.

[Home] [Help]

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 1160: hr_utility.set_message(801,'HR_6385_APP_TERM_FUT_CHANGES' );

1156: open c1 ;
1157: fetch c1 into l_dummy ;
1158: if c1%found then
1159: close c1 ;
1160: hr_utility.set_message(801,'HR_6385_APP_TERM_FUT_CHANGES' );
1161: hr_utility.raise_error ;
1162: end if;
1163: close c1 ;
1164: end canc_chk_fut_per_changes ;

Line 1161: hr_utility.raise_error ;

1157: fetch c1 into l_dummy ;
1158: if c1%found then
1159: close c1 ;
1160: hr_utility.set_message(801,'HR_6385_APP_TERM_FUT_CHANGES' );
1161: hr_utility.raise_error ;
1162: end if;
1163: close c1 ;
1164: end canc_chk_fut_per_changes ;
1165: -----------------------------------------------------------------------------

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

1189: OPEN c_per_changes;
1190: FETCH c_per_changes INTO v_dummy_number;
1191: IF c_per_changes%FOUND THEN
1192: CLOSE c_per_changes;
1193: hr_utility.set_message(800,'HR_6382_APP_TERM_FUTURE_PPT');
1194: hr_utility.set_message_token('DATE',P_date_end);
1195: hr_utility.raise_error;
1196: ELSE CLOSE c_per_changes;
1197: END IF;

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

1190: FETCH c_per_changes INTO v_dummy_number;
1191: IF c_per_changes%FOUND THEN
1192: CLOSE c_per_changes;
1193: hr_utility.set_message(800,'HR_6382_APP_TERM_FUTURE_PPT');
1194: hr_utility.set_message_token('DATE',P_date_end);
1195: hr_utility.raise_error;
1196: ELSE CLOSE c_per_changes;
1197: END IF;
1198: --

Line 1195: hr_utility.raise_error;

1191: IF c_per_changes%FOUND THEN
1192: CLOSE c_per_changes;
1193: hr_utility.set_message(800,'HR_6382_APP_TERM_FUTURE_PPT');
1194: hr_utility.set_message_token('DATE',P_date_end);
1195: hr_utility.raise_error;
1196: ELSE CLOSE c_per_changes;
1197: END IF;
1198: --
1199: END term_chk_fut_per_changes;

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

1223: OPEN c_assign_changes;
1224: FETCH c_assign_changes INTO v_number;
1225: IF c_assign_changes%FOUND THEN
1226: CLOSE c_assign_changes;
1227: hr_utility.set_message(800,'HR_6583_APP_TERM_FUT_ASS');
1228: hr_utility.set_message_token('DATE',P_date_end);
1229: hr_utility.raise_error;
1230: ELSE CLOSE c_assign_changes;
1231: END IF;

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

1224: FETCH c_assign_changes INTO v_number;
1225: IF c_assign_changes%FOUND THEN
1226: CLOSE c_assign_changes;
1227: hr_utility.set_message(800,'HR_6583_APP_TERM_FUT_ASS');
1228: hr_utility.set_message_token('DATE',P_date_end);
1229: hr_utility.raise_error;
1230: ELSE CLOSE c_assign_changes;
1231: END IF;
1232: --

Line 1229: hr_utility.raise_error;

1225: IF c_assign_changes%FOUND THEN
1226: CLOSE c_assign_changes;
1227: hr_utility.set_message(800,'HR_6583_APP_TERM_FUT_ASS');
1228: hr_utility.set_message_token('DATE',P_date_end);
1229: hr_utility.raise_error;
1230: ELSE CLOSE c_assign_changes;
1231: END IF;
1232: --
1233: END term_chk_fut_assign_changes;

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

1594: OPEN c_chk_already_term;
1595: FETCH c_chk_already_term into V_dummy_1;
1596: IF c_chk_already_term%found THEN
1597: CLOSE c_chk_already_term;
1598: hr_utility.set_message(800,'HR_7105_APPL_ALREADY_TERMED');
1599: hr_utility.raise_error;
1600: ELSE
1601: CLOSE c_chk_already_term;
1602: END IF;

Line 1599: hr_utility.raise_error;

1595: FETCH c_chk_already_term into V_dummy_1;
1596: IF c_chk_already_term%found THEN
1597: CLOSE c_chk_already_term;
1598: hr_utility.set_message(800,'HR_7105_APPL_ALREADY_TERMED');
1599: hr_utility.raise_error;
1600: ELSE
1601: CLOSE c_chk_already_term;
1602: END IF;
1603: END chk_not_already_termed;

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

2255: l_date_end date;
2256: l_update_mode varchar2(30);
2257:
2258: BEGIN
2259: hr_utility.set_location('per_applications_pkg.update_row',10);
2260: -- Bug 3053711 Start
2261: -- Added the check if flag = 'Y'
2262: --Commented out for the Bug 4202317
2263: -- if p_Cancellation_Flag = 'Y' then

Line 2336: hr_utility.set_location('per_applications_pkg.update_row',20);

2332: appl_attribute20 = p_Appl_Attribute20
2333: WHERE rowid = p_rowid;
2334: end if;*/
2335: -- Bug 3053711 End
2336: hr_utility.set_location('per_applications_pkg.update_row',20);
2337: if (SQL%NOTFOUND) then
2338: RAISE NO_DATA_FOUND;
2339: end if;
2340:

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

2337: if (SQL%NOTFOUND) then
2338: RAISE NO_DATA_FOUND;
2339: end if;
2340:
2341: hr_utility.set_location('per_applications_pkg.update_row',30);
2342: --
2343: -- Now maintain the PTU data...
2344: --
2345: -- 3652025: Another package will do the updates when performing a termination.

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

2352: -- terminated application.
2353: --
2354: -- PTU : Following code added for PTU
2355: --
2356: --hr_utility.set_location('per_applications_pkg.update_row',40);
2357:
2358: --Bug No 3891787 starts here
2359: --Open csr_ptu_row1;
2360: --fetch csr_ptu_row1 into l_person_type_id,l_start_date;

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

2377: -- );
2378: --end if;
2379: --close csr_ptu_row1;
2380: --Bug No 3891787 ends here
2381: --hr_utility.set_location('per_applications_pkg.update_row',50);
2382: -- End of PTU Changes
2383: --
2384: -- hr_per_type_usage_internal.maintain_ptu(
2385: -- p_action => 'TERM_APL',

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

2399: open csr_ptu_row;
2400: fetch csr_ptu_row into l_date_end;
2401: close csr_ptu_row;
2402:
2403: hr_utility.set_location('per_applications_pkg.p_date_received = '||to_char(p_date_received,'DD/MM/YYYY'),60);
2404: hr_utility.set_location('per_applications_pkg.p_date_end = '||to_char(l_date_end,'DD/MM/YYYY'),60);
2405: hr_utility.set_location('per_applications_pkg.p_person_id = '||to_char(p_person_id),60);
2406:
2407: hr_per_type_usage_internal.cancel_person_type_usage

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

2400: fetch csr_ptu_row into l_date_end;
2401: close csr_ptu_row;
2402:
2403: hr_utility.set_location('per_applications_pkg.p_date_received = '||to_char(p_date_received,'DD/MM/YYYY'),60);
2404: hr_utility.set_location('per_applications_pkg.p_date_end = '||to_char(l_date_end,'DD/MM/YYYY'),60);
2405: hr_utility.set_location('per_applications_pkg.p_person_id = '||to_char(p_person_id),60);
2406:
2407: hr_per_type_usage_internal.cancel_person_type_usage
2408: (

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

2401: close csr_ptu_row;
2402:
2403: hr_utility.set_location('per_applications_pkg.p_date_received = '||to_char(p_date_received,'DD/MM/YYYY'),60);
2404: hr_utility.set_location('per_applications_pkg.p_date_end = '||to_char(l_date_end,'DD/MM/YYYY'),60);
2405: hr_utility.set_location('per_applications_pkg.p_person_id = '||to_char(p_person_id),60);
2406:
2407: hr_per_type_usage_internal.cancel_person_type_usage
2408: (
2409: p_effective_date => l_date_end

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

2486: and paa.effective_end_date = p_date_end;
2487: --
2488: begin
2489: --
2490: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 10);
2491: --
2492: -- Termination of applicant
2493: if p_action = 'TERM' then
2494: --

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

2493: if p_action = 'TERM' then
2494: --
2495: l_ass_status := 'TERM_APL';
2496: --
2497: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 20);
2498: --
2499: open csr_get_asg_status;
2500: fetch csr_get_asg_status into l_ass_status_type_id;
2501: close csr_get_asg_status;

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

2519: else
2520: --
2521: l_ass_status := 'ACTIVE_APL';
2522: --
2523: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 30);
2524: --
2525: open csr_get_asg_status;
2526: fetch csr_get_asg_status into l_ass_status_type_id;
2527: close csr_get_asg_status;

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

2542: close csr_cancel_ass_id;
2543: --
2544: end if;
2545: --
2546: hr_utility.set_location('PER_APPLICATIONS_PKG.maintain_irc_ass_status', 40);
2547: --
2548: end maintain_irc_ass_status;
2549: --
2550: END PER_APPLICATIONS_PKG;