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

Line 47: hr_utility.set_location('Entering: '||l_proc, 5);

43:
44:
45: Begin
46: --
47: hr_utility.set_location('Entering: '||l_proc, 5);
48: --
49: g_asg_bgt_tab(1).assignment_id :=p_assg_ele_tab.r_assignment_id(1);
50: l_start_period :=p_assg_ele_tab.r_begin_time_period_id(1);
51: l_end_period := p_assg_ele_tab.r_end_time_period_id(1);

Line 110: hr_utility.set_location('Leaving:'||l_proc, 1000);

106: END IF;
107:
108: --
109: END LOOP;
110: hr_utility.set_location('Leaving:'||l_proc, 1000);
111: --
112: EXCEPTION
113: WHEN OTHERS THEN
114: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

Line 114: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

110: hr_utility.set_location('Leaving:'||l_proc, 1000);
111: --
112: EXCEPTION
113: WHEN OTHERS THEN
114: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
115: hr_utility.set_message_token('ROUTINE', l_proc);
116: hr_utility.set_message_token('REASON', SQLERRM);
117: hr_utility.raise_error;
118: END;

Line 115: hr_utility.set_message_token('ROUTINE', l_proc);

111: --
112: EXCEPTION
113: WHEN OTHERS THEN
114: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
115: hr_utility.set_message_token('ROUTINE', l_proc);
116: hr_utility.set_message_token('REASON', SQLERRM);
117: hr_utility.raise_error;
118: END;
119:

Line 116: hr_utility.set_message_token('REASON', SQLERRM);

112: EXCEPTION
113: WHEN OTHERS THEN
114: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
115: hr_utility.set_message_token('ROUTINE', l_proc);
116: hr_utility.set_message_token('REASON', SQLERRM);
117: hr_utility.raise_error;
118: END;
119:
120: -----------------------------------------------------------------------------

Line 117: hr_utility.raise_error;

113: WHEN OTHERS THEN
114: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
115: hr_utility.set_message_token('ROUTINE', l_proc);
116: hr_utility.set_message_token('REASON', SQLERRM);
117: hr_utility.raise_error;
118: END;
119:
120: -----------------------------------------------------------------------------
121: -- Private procedure to get Entities attached to Enc/Liquidated Assignment

Line 154: hr_utility.set_location('Entering: '||l_proc, 5);

150: l_proc VARCHAR2(72) := g_package||'get_asg_entities';
151: --
152: Begin
153: --
154: hr_utility.set_location('Entering: '||l_proc, 5);
155: For cnt in 1..g_asg_bgt_tab.COUNT
156: LOOP
157: --
158: FOR C1 in csr_asg_entities(g_asg_bgt_tab(cnt).assignment_id,

Line 174: hr_utility.set_location('Leaving:'||l_proc, 1000);

170: --
171: END LOOP;
172: --
173: END LOOP;
174: hr_utility.set_location('Leaving:'||l_proc, 1000);
175: --
176: EXCEPTION
177: WHEN OTHERS THEN
178: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

Line 178: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

174: hr_utility.set_location('Leaving:'||l_proc, 1000);
175: --
176: EXCEPTION
177: WHEN OTHERS THEN
178: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
179: hr_utility.set_message_token('ROUTINE', l_proc);
180: hr_utility.set_message_token('REASON', SQLERRM);
181: hr_utility.raise_error;
182: END;

Line 179: hr_utility.set_message_token('ROUTINE', l_proc);

175: --
176: EXCEPTION
177: WHEN OTHERS THEN
178: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
179: hr_utility.set_message_token('ROUTINE', l_proc);
180: hr_utility.set_message_token('REASON', SQLERRM);
181: hr_utility.raise_error;
182: END;
183:

Line 180: hr_utility.set_message_token('REASON', SQLERRM);

176: EXCEPTION
177: WHEN OTHERS THEN
178: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
179: hr_utility.set_message_token('ROUTINE', l_proc);
180: hr_utility.set_message_token('REASON', SQLERRM);
181: hr_utility.raise_error;
182: END;
183:
184: -----------------------------------------------------------------------------

Line 181: hr_utility.raise_error;

177: WHEN OTHERS THEN
178: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
179: hr_utility.set_message_token('ROUTINE', l_proc);
180: hr_utility.set_message_token('REASON', SQLERRM);
181: hr_utility.raise_error;
182: END;
183:
184: -----------------------------------------------------------------------------
185: -- Private procedure to get Budget Versions from Assignment Positions

Line 297: hr_utility.set_location('Entering: '||l_proc, 5);

293:
294:
295: Begin
296: --
297: hr_utility.set_location('Entering: '||l_proc, 5);
298: --
299: -- For each Encumbered Entity
300: --
301: For cnt in 1..g_encumbered_entity_tab.COUNT

Line 433: hr_utility.set_location('Leaving:'||l_proc, 1000);

429: END LOOP;
430: END IF;
431: --
432: END LOOP;
433: hr_utility.set_location('Leaving:'||l_proc, 1000);
434: --
435: EXCEPTION
436: WHEN OTHERS THEN
437: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

Line 437: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

433: hr_utility.set_location('Leaving:'||l_proc, 1000);
434: --
435: EXCEPTION
436: WHEN OTHERS THEN
437: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
438: hr_utility.set_message_token('ROUTINE', l_proc);
439: hr_utility.set_message_token('REASON', SQLERRM);
440: hr_utility.raise_error;
441: END;

Line 438: hr_utility.set_message_token('ROUTINE', l_proc);

434: --
435: EXCEPTION
436: WHEN OTHERS THEN
437: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
438: hr_utility.set_message_token('ROUTINE', l_proc);
439: hr_utility.set_message_token('REASON', SQLERRM);
440: hr_utility.raise_error;
441: END;
442:

Line 439: hr_utility.set_message_token('REASON', SQLERRM);

435: EXCEPTION
436: WHEN OTHERS THEN
437: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
438: hr_utility.set_message_token('ROUTINE', l_proc);
439: hr_utility.set_message_token('REASON', SQLERRM);
440: hr_utility.raise_error;
441: END;
442:
443: -----------------------------------------------------------------------------

Line 440: hr_utility.raise_error;

436: WHEN OTHERS THEN
437: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
438: hr_utility.set_message_token('ROUTINE', l_proc);
439: hr_utility.set_message_token('REASON', SQLERRM);
440: hr_utility.raise_error;
441: END;
442:
443: -----------------------------------------------------------------------------
444: -- Main procedure called by LD Encumbrane and Summarize/Liquidation process

Line 474: hr_utility.set_location('Entering: '||l_proc, 5);

470: l_budget_version number(15);
471: --
472: BEGIN
473:
474: hr_utility.set_location('Entering: '||l_proc, 5);
475: PSP_PQH_INTEGRATION.GET_ENCUMBRANCE_DETAILS(
476: P_CALLING_PROCESS =>p_calling_process,
477: P_ASSIGNMENT_ENC_LD_TABLE =>l_assignment_enc_ld_table,
478: P_PSP_ENCUMBERED =>l_psp_encumbered,

Line 531: hr_utility.set_location('Leaving:'||l_proc, 1000);

527: --
528: END LOOP;
529:
530: p_return_status:=FND_API.G_RET_STS_SUCCESS;
531: hr_utility.set_location('Leaving:'||l_proc, 1000);
532: EXCEPTION
533: WHEN OTHERS THEN
534: ROLLBACK ;
535: p_return_status:=FND_API.G_RET_STS_ERROR;

Line 536: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');

532: EXCEPTION
533: WHEN OTHERS THEN
534: ROLLBACK ;
535: p_return_status:=FND_API.G_RET_STS_ERROR;
536: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
537: hr_utility.set_message_token('ROUTINE', l_proc);
538: hr_utility.set_message_token('REASON', SQLERRM);
539: hr_utility.raise_error;
540: END relieve_budget_commitments;

Line 537: hr_utility.set_message_token('ROUTINE', l_proc);

533: WHEN OTHERS THEN
534: ROLLBACK ;
535: p_return_status:=FND_API.G_RET_STS_ERROR;
536: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
537: hr_utility.set_message_token('ROUTINE', l_proc);
538: hr_utility.set_message_token('REASON', SQLERRM);
539: hr_utility.raise_error;
540: END relieve_budget_commitments;
541: --

Line 538: hr_utility.set_message_token('REASON', SQLERRM);

534: ROLLBACK ;
535: p_return_status:=FND_API.G_RET_STS_ERROR;
536: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
537: hr_utility.set_message_token('ROUTINE', l_proc);
538: hr_utility.set_message_token('REASON', SQLERRM);
539: hr_utility.raise_error;
540: END relieve_budget_commitments;
541: --
542: --

Line 539: hr_utility.raise_error;

535: p_return_status:=FND_API.G_RET_STS_ERROR;
536: hr_utility.set_message(8302, 'PQH_CATASTROPHIC_ERROR');
537: hr_utility.set_message_token('ROUTINE', l_proc);
538: hr_utility.set_message_token('REASON', SQLERRM);
539: hr_utility.raise_error;
540: END relieve_budget_commitments;
541: --
542: --
543: END PQH_PSP_INTEGRATION;