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

Line 147: hr_utility.set_location('L:'||p_letter,5);

143: --' AND opt1.object_id = i.integrator_id ' ||
144: --' AND i.integrator_id = bl.integrator_id ' ||
145: --' AND bl.layout_id = opt2.object_id ' ||
146: --' AND upper(opt2.value) = upper(''' || p_letter || ''')';
147: hr_utility.set_location('L:'||p_letter,5);
148: OPEN l_int_csr FOR
149: 'SELECT pli.string_value ' ||
150: ' FROM bne_param_lists_b plb ' ||
151: ' , bne_param_list_items pli ' ||

Line 208: hr_utility.trace('Form_name ='||g_form_name||'--');

204: 'end;';
205: l_return_code varchar2(60);
206: --
207: BEGIN
208: hr_utility.trace('Form_name ='||g_form_name||'--');
209: EXECUTE IMMEDIATE l_sql
210: USING out l_return_code,
211: in p_sql,
212: in p_date,

Line 232: -- hr_utility.trace_on;

228: --
229: l_exists varchar2(1);
230: BEGIN
231: --
232: -- hr_utility.trace_on;
233: hr_utility.set_location('ADD_OR_UPDATE_SESSION',10);
234: --
235: open csr_find_row;
236: fetch csr_find_row into l_exists;

Line 233: hr_utility.set_location('ADD_OR_UPDATE_SESSION',10);

229: l_exists varchar2(1);
230: BEGIN
231: --
232: -- hr_utility.trace_on;
233: hr_utility.set_location('ADD_OR_UPDATE_SESSION',10);
234: --
235: open csr_find_row;
236: fetch csr_find_row into l_exists;
237: IF csr_find_row%NOTFOUND THEN

Line 239: hr_utility.set_location('ADD_OR_UPDATE_SESSION - NO ROW',20);

235: open csr_find_row;
236: fetch csr_find_row into l_exists;
237: IF csr_find_row%NOTFOUND THEN
238: --
239: hr_utility.set_location('ADD_OR_UPDATE_SESSION - NO ROW',20);
240: --
241: -- Row does not exist, so add
242: INSERT INTO fnd_sessions (session_id, effective_date)
243: VALUES (userenv('sessionid'), p_sess_date);

Line 245: hr_utility.set_location('ADD_OR_UPDATE_SESSION - ROW ADDED',30);

241: -- Row does not exist, so add
242: INSERT INTO fnd_sessions (session_id, effective_date)
243: VALUES (userenv('sessionid'), p_sess_date);
244: --
245: hr_utility.set_location('ADD_OR_UPDATE_SESSION - ROW ADDED',30);
246: --
247: ELSE
248: --
249: hr_utility.set_location('ADD_OR_UPDATE_SESSION - ROW EXISTS',40);

Line 249: hr_utility.set_location('ADD_OR_UPDATE_SESSION - ROW EXISTS',40);

245: hr_utility.set_location('ADD_OR_UPDATE_SESSION - ROW ADDED',30);
246: --
247: ELSE
248: --
249: hr_utility.set_location('ADD_OR_UPDATE_SESSION - ROW EXISTS',40);
250: -- Row exists, so update date
251: UPDATE fnd_sessions
252: SET effective_date = p_sess_date
253: WHERE session_id = userenv('sessionid');

Line 254: hr_utility.set_location('ADD_OR_UPDATE_SESSION - ROW UPDATE',50);

250: -- Row exists, so update date
251: UPDATE fnd_sessions
252: SET effective_date = p_sess_date
253: WHERE session_id = userenv('sessionid');
254: hr_utility.set_location('ADD_OR_UPDATE_SESSION - ROW UPDATE',50);
255: --
256: END IF;
257: close csr_find_row;
258: --

Line 260: -- hr_utility.trace_off;

256: END IF;
257: close csr_find_row;
258: --
259: commit;
260: -- hr_utility.trace_off;
261: END add_or_update_session;
262: --
263: -- -------------------------------------------------------------------------
264: -- |------------------< add_hr_param_list_to_content >---------------------|

Line 456: hr_utility.set_location('Found at: ' || l_pos,10);

452: --
453: WHILE (instr(l_upper_sql,upper(l_base_table)|| '.',l_start) > 0) LOOP
454: --
455: l_pos := instr(l_upper_sql,upper(l_base_table) || '.',l_start);
456: hr_utility.set_location('Found at: ' || l_pos,10);
457: --
458: l_temp_sql := substr(l_temp_sql,1,l_pos-1) || 'ADI1.' ||
459: substr(l_temp_sql,l_pos + length(l_base_table || '.'));
460: hr_utility.set_location('replaced',11);

Line 460: hr_utility.set_location('replaced',11);

456: hr_utility.set_location('Found at: ' || l_pos,10);
457: --
458: l_temp_sql := substr(l_temp_sql,1,l_pos-1) || 'ADI1.' ||
459: substr(l_temp_sql,l_pos + length(l_base_table || '.'));
460: hr_utility.set_location('replaced',11);
461: --
462: l_upper_sql := upper(l_temp_sql);
463: --
464: -- l_start := l_pos + length(l_base_table || '.');

Line 465: -- hr_utility.set_location('start:'||l_start,12);

461: --
462: l_upper_sql := upper(l_temp_sql);
463: --
464: -- l_start := l_pos + length(l_base_table || '.');
465: -- hr_utility.set_location('start:'||l_start,12);
466: --
467: END LOOP;
468: --
469: -- replace Alias which may be in upper or lower case

Line 476: hr_utility.set_location('Alias found at: ' || l_pos,13);

472: --
473: WHILE (instr(l_upper_sql, ' ' || upper(l_base_table_alias) || '.', l_start) > 0) LOOP
474: --
475: l_pos := instr(l_upper_sql, ' '||upper(l_base_table_alias) || '.', l_start);
476: hr_utility.set_location('Alias found at: ' || l_pos,13);
477: --
478: l_temp_sql := substr(l_temp_sql,1,l_pos-1) || ' ADI1.' ||
479: substr(l_temp_sql,l_pos + length(' '||l_base_table_alias||'.'));
480: hr_utility.set_location('Alias replaced',14);

Line 480: hr_utility.set_location('Alias replaced',14);

476: hr_utility.set_location('Alias found at: ' || l_pos,13);
477: --
478: l_temp_sql := substr(l_temp_sql,1,l_pos-1) || ' ADI1.' ||
479: substr(l_temp_sql,l_pos + length(' '||l_base_table_alias||'.'));
480: hr_utility.set_location('Alias replaced',14);
481: --
482: l_upper_sql := upper(l_temp_sql);
483: --
484: END LOOP;

Line 493: hr_utility.set_location('Alias found at: ' || l_pos,13);

489: --
490: WHILE (instr(l_upper_sql, '(' || upper(l_base_table_alias) || '.', l_start) > 0) LOOP
491: --
492: l_pos := instr(l_upper_sql, '('||upper(l_base_table_alias) || '.', l_start);
493: hr_utility.set_location('Alias found at: ' || l_pos,13);
494: --
495: l_temp_sql := substr(l_temp_sql,1,l_pos-1) || '(ADI1.' ||
496: substr(l_temp_sql,l_pos + length('('||l_base_table_alias||'.'));
497: hr_utility.set_location('Alias replaced',14);

Line 497: hr_utility.set_location('Alias replaced',14);

493: hr_utility.set_location('Alias found at: ' || l_pos,13);
494: --
495: l_temp_sql := substr(l_temp_sql,1,l_pos-1) || '(ADI1.' ||
496: substr(l_temp_sql,l_pos + length('('||l_base_table_alias||'.'));
497: hr_utility.set_location('Alias replaced',14);
498: --
499: l_upper_sql := upper(l_temp_sql);
500: --
501: END LOOP;