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

Line 101: hr_utility.set_location('Entering:'||l_proc, 10);

97: --
98: l_language_code varchar2(80);
99: l_proc varchar2(72) := g_package||'find_language_code';
100: begin
101: hr_utility.set_location('Entering:'||l_proc, 10);
102: --
103: -- Find out if the view definition exists in the current account
104: --
105: open csr_lang;

Line 109: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

105: open csr_lang;
106: fetch csr_lang into l_language_code;
107: if csr_lang%notfound then
108: close csr_lang;
109: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
110: hr_utility.set_message_token('PROCEDURE', l_proc);
111: hr_utility.set_message_token('STEP','20');
112: hr_utility.raise_error;
113: end if;

Line 110: hr_utility.set_message_token('PROCEDURE', l_proc);

106: fetch csr_lang into l_language_code;
107: if csr_lang%notfound then
108: close csr_lang;
109: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
110: hr_utility.set_message_token('PROCEDURE', l_proc);
111: hr_utility.set_message_token('STEP','20');
112: hr_utility.raise_error;
113: end if;
114: close csr_lang;

Line 111: hr_utility.set_message_token('STEP','20');

107: if csr_lang%notfound then
108: close csr_lang;
109: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
110: hr_utility.set_message_token('PROCEDURE', l_proc);
111: hr_utility.set_message_token('STEP','20');
112: hr_utility.raise_error;
113: end if;
114: close csr_lang;
115: --

Line 112: hr_utility.raise_error;

108: close csr_lang;
109: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
110: hr_utility.set_message_token('PROCEDURE', l_proc);
111: hr_utility.set_message_token('STEP','20');
112: hr_utility.raise_error;
113: end if;
114: close csr_lang;
115: --
116: p_language_code := l_language_code;

Line 117: hr_utility.set_location(' Leaving:'||l_proc, 30);

113: end if;
114: close csr_lang;
115: --
116: p_language_code := l_language_code;
117: hr_utility.set_location(' Leaving:'||l_proc, 30);
118: end find_language_code;
119: --
120: -- ----------------------------------------------------------------------------
121: -- |------------------------< find_view_and_details >-------------------------|

Line 191: hr_utility.set_location('Entering:'||l_proc, 10);

187: l_view_owner varchar2(80);
188: l_title_prompt varchar2(80);
189: l_proc varchar2(72) := g_package||'find_view_and_details';
190: begin
191: hr_utility.set_location('Entering:'||l_proc, 10);
192: --
193: -- Find out if the view definition exists in the current account
194: --
195: open csr_view_exists;

Line 207: hr_utility.set_message(801,'DTH_34950_MISSING_TITLE');

203: open csr_title;
204: fetch csr_title into l_title_prompt;
205: if csr_title%notfound then
206: close csr_title;
207: hr_utility.set_message(801,'DTH_34950_MISSING_TITLE');
208: hr_utility.set_message_token('VIEW', p_view_name);
209: hr_utility.raise_error;
210: end if;
211: close csr_title;

Line 208: hr_utility.set_message_token('VIEW', p_view_name);

204: fetch csr_title into l_title_prompt;
205: if csr_title%notfound then
206: close csr_title;
207: hr_utility.set_message(801,'DTH_34950_MISSING_TITLE');
208: hr_utility.set_message_token('VIEW', p_view_name);
209: hr_utility.raise_error;
210: end if;
211: close csr_title;
212: hr_utility.set_location(l_proc, 20);

Line 209: hr_utility.raise_error;

205: if csr_title%notfound then
206: close csr_title;
207: hr_utility.set_message(801,'DTH_34950_MISSING_TITLE');
208: hr_utility.set_message_token('VIEW', p_view_name);
209: hr_utility.raise_error;
210: end if;
211: close csr_title;
212: hr_utility.set_location(l_proc, 20);
213: else

Line 212: hr_utility.set_location(l_proc, 20);

208: hr_utility.set_message_token('VIEW', p_view_name);
209: hr_utility.raise_error;
210: end if;
211: close csr_title;
212: hr_utility.set_location(l_proc, 20);
213: else
214: close csr_view_exists;
215: l_view_found := false;
216: l_view_owner := null;

Line 223: hr_utility.set_location(l_proc, 30);

219: -- Note: From R11.0 onwards it is no longer necessary to double check
220: -- for a synonym. Secure users now connect to the APPS account
221: -- where the view definitions are held.
222: --
223: hr_utility.set_location(l_proc, 30);
224: end if;
225: --
226: p_view_found := l_view_found;
227: p_view_owner := l_view_owner;

Line 229: hr_utility.set_location(' Leaving:'||l_proc, 40);

225: --
226: p_view_found := l_view_found;
227: p_view_owner := l_view_owner;
228: p_title_prompt := l_title_prompt;
229: hr_utility.set_location(' Leaving:'||l_proc, 40);
230: end find_view_and_details;
231: --
232: -- ----------------------------------------------------------------------------
233: -- |-----------------------< derive_view_table_names >------------------------|

Line 285: hr_utility.set_location('Entering:'||l_proc, 10);

281: l_pos_last_unders number; -- Position of the last '_'
282: -- in the provided table name.
283: l_proc varchar2(72) := g_package||'derive_view_table_names';
284: begin
285: hr_utility.set_location('Entering:'||l_proc, 10);
286: --
287: l_table_trim := upper(rtrim(p_table_name));
288: l_name_length := length(l_table_trim);
289: l_pos_last_unders := instrb(l_table_trim, '_F', -1);

Line 303: hr_utility.set_location(' Leaving:'||l_proc, 20);

299: p_st_view_name := l_table_trim || '_D';
300: p_st_table_name := l_table_trim || '_F';
301: p_st_table_name_trim := l_table_trim;
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 20);
304: end derive_view_table_names;
305: --
306: -- ----------------------------------------------------------------------------
307: -- |------------------------< find_table_and_details >------------------------|

Line 364: hr_utility.set_location('Entering:'||l_proc, 10);

360: l_table_owner varchar2(30);
361: l_title_prompt varchar2(80);
362: l_proc varchar2(72) := g_package||'find_table_and_details';
363: begin
364: hr_utility.set_location('Entering:'||l_proc, 10);
365: --
366: -- Find out if the table synonym definition exists in the current account
367: -- Note: From R11.0 onwards, there is no need to check the actual table
368: -- definition is held in the current account. Table definitions will

Line 375: hr_utility.set_message(801, 'DTH_34952_ACCESS_TABLE');

371: open csr_tab_synonym_exists;
372: fetch csr_tab_synonym_exists into l_table_owner;
373: if csr_tab_synonym_exists%notfound then
374: close csr_tab_synonym_exists;
375: hr_utility.set_message(801, 'DTH_34952_ACCESS_TABLE');
376: hr_utility.set_message_token('TABLE', p_table_name);
377: hr_utility.raise_error;
378: end if;
379: close csr_tab_synonym_exists;

Line 376: hr_utility.set_message_token('TABLE', p_table_name);

372: fetch csr_tab_synonym_exists into l_table_owner;
373: if csr_tab_synonym_exists%notfound then
374: close csr_tab_synonym_exists;
375: hr_utility.set_message(801, 'DTH_34952_ACCESS_TABLE');
376: hr_utility.set_message_token('TABLE', p_table_name);
377: hr_utility.raise_error;
378: end if;
379: close csr_tab_synonym_exists;
380: --

Line 377: hr_utility.raise_error;

373: if csr_tab_synonym_exists%notfound then
374: close csr_tab_synonym_exists;
375: hr_utility.set_message(801, 'DTH_34952_ACCESS_TABLE');
376: hr_utility.set_message_token('TABLE', p_table_name);
377: hr_utility.raise_error;
378: end if;
379: close csr_tab_synonym_exists;
380: --
381: -- Derive the entity title name from the table name.

Line 392: hr_utility.set_location(' Leaving:'||l_proc, 20);

388: -- Set out parameters
389: p_table_owner := l_table_owner;
390: p_title_prompt := l_title_prompt;
391: --
392: hr_utility.set_location(' Leaving:'||l_proc, 20);
393: end find_table_and_details;
394: --
395: -- ----------------------------------------------------------------------------
396: -- |----------------------------< get_date_prompts >--------------------------|

Line 449: hr_utility.set_location('Entering:'||l_proc, 10);

445: where language = p_language_code;
446: --
447: l_proc varchar2(72) := g_package||'get_date_prompts';
448: begin
449: hr_utility.set_location('Entering:'||l_proc, 10);
450: --
451: -- Obtain date display prompts.
452: --
453: open csr_prompts;

Line 458: hr_utility.set_message(801, 'DTH_34951_DATE_PROMPT');

454: fetch csr_prompts into p_effective_start_prompt
455: , p_effective_end_prompt;
456: if csr_prompts%notfound then
457: close csr_prompts;
458: hr_utility.set_message(801, 'DTH_34951_DATE_PROMPT');
459: hr_utility.set_message_token('LANGUAGE', p_language_code);
460: hr_utility.raise_error;
461: end if;
462: close csr_prompts;

Line 459: hr_utility.set_message_token('LANGUAGE', p_language_code);

455: , p_effective_end_prompt;
456: if csr_prompts%notfound then
457: close csr_prompts;
458: hr_utility.set_message(801, 'DTH_34951_DATE_PROMPT');
459: hr_utility.set_message_token('LANGUAGE', p_language_code);
460: hr_utility.raise_error;
461: end if;
462: close csr_prompts;
463: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 460: hr_utility.raise_error;

456: if csr_prompts%notfound then
457: close csr_prompts;
458: hr_utility.set_message(801, 'DTH_34951_DATE_PROMPT');
459: hr_utility.set_message_token('LANGUAGE', p_language_code);
460: hr_utility.raise_error;
461: end if;
462: close csr_prompts;
463: hr_utility.set_location(' Leaving:'||l_proc, 20);
464: end get_date_prompts;

Line 463: hr_utility.set_location(' Leaving:'||l_proc, 20);

459: hr_utility.set_message_token('LANGUAGE', p_language_code);
460: hr_utility.raise_error;
461: end if;
462: close csr_prompts;
463: hr_utility.set_location(' Leaving:'||l_proc, 20);
464: end get_date_prompts;
465: --
466: -- Procedures declared in the package header
467: --

Line 558: hr_utility.set_location('Entering:'||l_proc, 10);

554: -- Get p_effective_start_prompt value from DT_DATE_PROMPTS_TL
555: -- Get p_effective_end_prompt value from DT_DATE_PROMPTS_TL
556: --
557: begin
558: hr_utility.set_location('Entering:'||l_proc, 10);
559: --
560: -- Get language from userenv('LANG')
561: --
562: find_language_code

Line 636: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

632: -- view can be found, and the table does not exist then
633: -- the "check_table_exists" procedure should have already
634: -- raised an error.
635: --
636: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
637: hr_utility.set_message_token('PROCEDURE', l_proc);
638: hr_utility.set_message_token('STEP','20');
639: hr_utility.raise_error;
640: end if;

Line 637: hr_utility.set_message_token('PROCEDURE', l_proc);

633: -- the "check_table_exists" procedure should have already
634: -- raised an error.
635: --
636: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
637: hr_utility.set_message_token('PROCEDURE', l_proc);
638: hr_utility.set_message_token('STEP','20');
639: hr_utility.raise_error;
640: end if;
641: --

Line 638: hr_utility.set_message_token('STEP','20');

634: -- raised an error.
635: --
636: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
637: hr_utility.set_message_token('PROCEDURE', l_proc);
638: hr_utility.set_message_token('STEP','20');
639: hr_utility.raise_error;
640: end if;
641: --
642: -- Obtained effective date prompts for the specified language

Line 639: hr_utility.raise_error;

635: --
636: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
637: hr_utility.set_message_token('PROCEDURE', l_proc);
638: hr_utility.set_message_token('STEP','20');
639: hr_utility.raise_error;
640: end if;
641: --
642: -- Obtained effective date prompts for the specified language
643: --

Line 658: hr_utility.set_location(' Leaving:'||l_proc, 30);

654: p_view_owner := l_view_owner;
655: p_title_prompt := l_title_prompt;
656: p_effective_start_prompt := l_effective_start_prompt;
657: p_effective_end_prompt := l_effective_end_prompt;
658: hr_utility.set_location(' Leaving:'||l_proc, 30);
659: --
660: end get_view_and_prompts;
661: --
662: -- Left an old overload version of the get_view_and_prompts