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

Line 69: hr_utility.set_location('Entering: PQH_PROCESS_ACADEMIC_RANK.get_academic_rank_details',5);

65: l_transaction_step_id number;
66: l_api_name hr_api_transaction_steps.api_name%TYPE;
67:
68: BEGIN
69: hr_utility.set_location('Entering: PQH_PROCESS_ACADEMIC_RANK.get_academic_rank_details',5);
70: --
71: l_transaction_step_id := to_number(x_transaction_step_id);
72: --
73:

Line 115: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.get_academic_rank_details',5);

111: hr_transaction_api.get_varchar2_value
112: (p_transaction_step_id => l_transaction_step_id
113: ,p_name => 'P_PERSON_EXTRA_INFO_ID');
114: --
115: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.get_academic_rank_details',5);
116: EXCEPTION
117: WHEN hr_utility.hr_error THEN
118: hr_utility.raise_error;
119: WHEN OTHERS THEN

Line 117: WHEN hr_utility.hr_error THEN

113: ,p_name => 'P_PERSON_EXTRA_INFO_ID');
114: --
115: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.get_academic_rank_details',5);
116: EXCEPTION
117: WHEN hr_utility.hr_error THEN
118: hr_utility.raise_error;
119: WHEN OTHERS THEN
120: x_pei_information1 := null;
121: x_pei_information2 := null;

Line 118: hr_utility.raise_error;

114: --
115: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.get_academic_rank_details',5);
116: EXCEPTION
117: WHEN hr_utility.hr_error THEN
118: hr_utility.raise_error;
119: WHEN OTHERS THEN
120: x_pei_information1 := null;
121: x_pei_information2 := null;
122: x_pei_information3 := null;

Line 155: hr_utility.set_location('Entering: PQH_PROCESS_ACADEMIC_RANK.set_academic_rank_details',5);

151: l_review_proc_call VARCHAR2(30);
152: l_effective_date DATE ;
153:
154: BEGIN
155: hr_utility.set_location('Entering: PQH_PROCESS_ACADEMIC_RANK.set_academic_rank_details',5);
156: l_review_proc_call := 'PqhAcademicRankReview';
157: l_effective_date := SYSDATE;
158: --
159: hr_transaction_api.get_transaction_step_info

Line 225: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.set_academic_rank_details',5);

221: ,p_transaction_step_id => l_transaction_step_id
222: ,p_api_name => l_api_name
223: ,p_transaction_data => l_trans_tbl );
224:
225: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.set_academic_rank_details',5);
226: commit;
227: EXCEPTION
228: WHEN hr_utility.hr_error THEN
229: hr_utility.raise_error;

Line 228: WHEN hr_utility.hr_error THEN

224:
225: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.set_academic_rank_details',5);
226: commit;
227: EXCEPTION
228: WHEN hr_utility.hr_error THEN
229: hr_utility.raise_error;
230: WHEN OTHERS THEN
231: RAISE; -- Raise error here relevant to the new tech stack.
232: END set_academic_rank_details;

Line 229: hr_utility.raise_error;

225: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.set_academic_rank_details',5);
226: commit;
227: EXCEPTION
228: WHEN hr_utility.hr_error THEN
229: hr_utility.raise_error;
230: WHEN OTHERS THEN
231: RAISE; -- Raise error here relevant to the new tech stack.
232: END set_academic_rank_details;
233: --

Line 251: hr_utility.set_location('Entering: PQH_PROCESS_ACADEMIC_RANK.process_api',5);

247: l_pei_information4 VARCHAR2(255);
248: l_pei_information5 VARCHAR2(255);
249:
250: BEGIN
251: hr_utility.set_location('Entering: PQH_PROCESS_ACADEMIC_RANK.process_api',5);
252: --
253: savepoint process_academic_rank_details;
254: --
255:

Line 313: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.process_api',5);

309: p_object_version_number => l_ovn );
310: --
311: END IF;
312: --
313: hr_utility.set_location('Leaving: PQH_PROCESS_ACADEMIC_RANK.process_api',5);
314: --
315: -- ns 5/19/2005: BUG 4381336: commenting commit as it is called while
316: -- resurrecting the transaction (via update action link), it is then
317: -- attempted to rollback which would fail if committed here.

Line 321: WHEN hr_utility.hr_error THEN

317: -- attempted to rollback which would fail if committed here.
318: -- commit;
319: --
320: EXCEPTION
321: WHEN hr_utility.hr_error THEN
322: ROLLBACK TO process_academic_rank_details;
323: RAISE;
324: WHEN OTHERS THEN
325: RAISE; -- Raise error here relevant to the new tech stack.