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 148: hr_utility.set_location('L:'||p_letter,5);

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

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

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

Line 233: -- hr_utility.trace_on;

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

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

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

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

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

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

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

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

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

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

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

Line 261: -- hr_utility.trace_off;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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