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_PROCESS_TENURE_STATUS dependencies on HR_UTILITY

Line 108: hr_utility.set_location('Entering: PQH_PROCESS_TENURE.get_tenure_details',5);

104: l_transaction_step_id number;
105: l_api_name hr_api_transaction_steps.api_name%TYPE;
106:
107: BEGIN
108: hr_utility.set_location('Entering: PQH_PROCESS_TENURE.get_tenure_details',5);
109: --
110: l_transaction_step_id := to_number(x_transaction_step_id);
111: --
112:

Line 159: hr_utility.set_location('Leaving: PQH_PROCESS_TENURE.get_tenure_details',10);

155: hr_transaction_api.get_varchar2_value
156: (p_transaction_step_id => l_transaction_step_id
157: ,p_name => 'P_PERSON_EXTRA_INFO_ID');
158: --
159: hr_utility.set_location('Leaving: PQH_PROCESS_TENURE.get_tenure_details',10);
160: EXCEPTION
161: WHEN hr_utility.hr_error THEN
162: hr_utility.raise_error;
163: WHEN OTHERS THEN

Line 161: WHEN hr_utility.hr_error THEN

157: ,p_name => 'P_PERSON_EXTRA_INFO_ID');
158: --
159: hr_utility.set_location('Leaving: PQH_PROCESS_TENURE.get_tenure_details',10);
160: EXCEPTION
161: WHEN hr_utility.hr_error THEN
162: hr_utility.raise_error;
163: WHEN OTHERS THEN
164: x_pei_information1 := null;
165: x_pei_information2 := null;

Line 162: hr_utility.raise_error;

158: --
159: hr_utility.set_location('Leaving: PQH_PROCESS_TENURE.get_tenure_details',10);
160: EXCEPTION
161: WHEN hr_utility.hr_error THEN
162: hr_utility.raise_error;
163: WHEN OTHERS THEN
164: x_pei_information1 := null;
165: x_pei_information2 := null;
166: x_pei_information3 := null;

Line 200: hr_utility.set_location('Entering: PQH_PROCESS_TENURE.set_tenure_details',5);

196: l_review_proc_call VARCHAR2(30);
197: l_effective_date DATE ;
198:
199: BEGIN
200: hr_utility.set_location('Entering: PQH_PROCESS_TENURE.set_tenure_details',5);
201: l_review_proc_call := 'PqhTenureStatusReview';
202: l_effective_date := SYSDATE;
203: --
204: hr_transaction_api.get_transaction_step_info

Line 274: hr_utility.set_location('Leaving: PQH_PROCESS_TENURE.set_tenure_details',10);

270: ,p_login_person_id => x_login_person_id
271: ,p_transaction_step_id => l_transaction_step_id
272: ,p_api_name => l_api_name
273: ,p_transaction_data => l_trans_tbl );
274: hr_utility.set_location('Leaving: PQH_PROCESS_TENURE.set_tenure_details',10);
275: commit;
276: EXCEPTION
277: WHEN hr_utility.hr_error THEN
278: hr_utility.raise_error;

Line 277: WHEN hr_utility.hr_error THEN

273: ,p_transaction_data => l_trans_tbl );
274: hr_utility.set_location('Leaving: PQH_PROCESS_TENURE.set_tenure_details',10);
275: commit;
276: EXCEPTION
277: WHEN hr_utility.hr_error THEN
278: hr_utility.raise_error;
279: WHEN OTHERS THEN
280: RAISE; -- Raise error here relevant to the new tech stack.
281: END set_tenure_details;

Line 278: hr_utility.raise_error;

274: hr_utility.set_location('Leaving: PQH_PROCESS_TENURE.set_tenure_details',10);
275: commit;
276: EXCEPTION
277: WHEN hr_utility.hr_error THEN
278: hr_utility.raise_error;
279: WHEN OTHERS THEN
280: RAISE; -- Raise error here relevant to the new tech stack.
281: END set_tenure_details;
282: --

Line 303: hr_utility.set_location('Entering: PQH_PROCESS_TENURE.process_api',5);

299: l_pei_information6 VARCHAR2(255);
300: --
301: --
302: BEGIN
303: hr_utility.set_location('Entering: PQH_PROCESS_TENURE.process_api',5);
304: --
305: savepoint process_tenure_details;
306: --
307: get_tenure_details (

Line 374: hr_utility.set_location('Leaving: PQH_PROCESS_TENURE.process_api',10);

370: -- resurrecting the transaction (via update action link), it is then
371: -- attempted to rollback which would fail if committed here.
372: -- commit;
373: --
374: hr_utility.set_location('Leaving: PQH_PROCESS_TENURE.process_api',10);
375: EXCEPTION
376: WHEN hr_utility.hr_error THEN
377: ROLLBACK TO process_tenure_details;
378: RAISE;

Line 376: WHEN hr_utility.hr_error THEN

372: -- commit;
373: --
374: hr_utility.set_location('Leaving: PQH_PROCESS_TENURE.process_api',10);
375: EXCEPTION
376: WHEN hr_utility.hr_error THEN
377: ROLLBACK TO process_tenure_details;
378: RAISE;
379: WHEN OTHERS THEN
380: RAISE; -- Raise error here relevant to the new tech stack.