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

Line 200: hr_utility.trace('Before Opening Category Cursor : csr_report_category_id');

196:
197: IF csr_report_group_id%FOUND THEN
198: fnd_file.put_line(fnd_file.log,'Report Group Id : ' || ln_report_group_id);
199: IF DEBUG_MODE THEN
200: hr_utility.trace('Before Opening Category Cursor : csr_report_category_id');
201: hr_utility.trace('ln_report_group_id='||ln_report_group_id);
202: hr_utility.trace('p_lookup_type_name='||p_lookup_type_name);
203: hr_utility.trace('p_business_group_id='||p_business_group_id);
204: END IF;

Line 201: hr_utility.trace('ln_report_group_id='||ln_report_group_id);

197: IF csr_report_group_id%FOUND THEN
198: fnd_file.put_line(fnd_file.log,'Report Group Id : ' || ln_report_group_id);
199: IF DEBUG_MODE THEN
200: hr_utility.trace('Before Opening Category Cursor : csr_report_category_id');
201: hr_utility.trace('ln_report_group_id='||ln_report_group_id);
202: hr_utility.trace('p_lookup_type_name='||p_lookup_type_name);
203: hr_utility.trace('p_business_group_id='||p_business_group_id);
204: END IF;
205:

Line 202: hr_utility.trace('p_lookup_type_name='||p_lookup_type_name);

198: fnd_file.put_line(fnd_file.log,'Report Group Id : ' || ln_report_group_id);
199: IF DEBUG_MODE THEN
200: hr_utility.trace('Before Opening Category Cursor : csr_report_category_id');
201: hr_utility.trace('ln_report_group_id='||ln_report_group_id);
202: hr_utility.trace('p_lookup_type_name='||p_lookup_type_name);
203: hr_utility.trace('p_business_group_id='||p_business_group_id);
204: END IF;
205:
206: OPEN csr_report_category_id(ln_report_group_id,p_lookup_type_name,p_business_group_id);

Line 203: hr_utility.trace('p_business_group_id='||p_business_group_id);

199: IF DEBUG_MODE THEN
200: hr_utility.trace('Before Opening Category Cursor : csr_report_category_id');
201: hr_utility.trace('ln_report_group_id='||ln_report_group_id);
202: hr_utility.trace('p_lookup_type_name='||p_lookup_type_name);
203: hr_utility.trace('p_business_group_id='||p_business_group_id);
204: END IF;
205:
206: OPEN csr_report_category_id(ln_report_group_id,p_lookup_type_name,p_business_group_id);
207: FETCH csr_report_category_id INTO ln_report_category_id;

Line 210: hr_utility.trace('After Opening Category Cursor : csr_report_category_id');

206: OPEN csr_report_category_id(ln_report_group_id,p_lookup_type_name,p_business_group_id);
207: FETCH csr_report_category_id INTO ln_report_category_id;
208:
209: IF DEBUG_MODE THEN
210: hr_utility.trace('After Opening Category Cursor : csr_report_category_id');
211: hr_utility.trace('ln_report_category_id='||ln_report_category_id);
212: END IF;
213:
214: IF csr_report_category_id%FOUND THEN

Line 211: hr_utility.trace('ln_report_category_id='||ln_report_category_id);

207: FETCH csr_report_category_id INTO ln_report_category_id;
208:
209: IF DEBUG_MODE THEN
210: hr_utility.trace('After Opening Category Cursor : csr_report_category_id');
211: hr_utility.trace('ln_report_category_id='||ln_report_category_id);
212: END IF;
213:
214: IF csr_report_category_id%FOUND THEN
215:

Line 232: hr_utility.trace('DELETE FROM pay_report_variables WHERE report_variable_id = ' || ln_report_variable_id);

228: FETCH csr_report_variable_id INTO ln_report_variable_id;
229: IF csr_report_variable_id%FOUND THEN
230: fnd_file.put_line(fnd_file.log,'Removing Variable Id : ' || ln_style_sheet_id);
231: IF DEBUG_MODE THEN
232: hr_utility.trace('DELETE FROM pay_report_variables WHERE report_variable_id = ' || ln_report_variable_id);
233: ELSE
234: DELETE FROM pay_report_variables
235: WHERE report_variable_id = ln_report_variable_id;
236: END IF;

Line 240: hr_utility.trace('DELETE FROM pay_report_category_components WHERE style_sheet_variable_id = ' || ln_style_sheet_id);

236: END IF;
237: END IF;
238: CLOSE csr_report_variable_id;
239: IF DEBUG_MODE THEN
240: hr_utility.trace('DELETE FROM pay_report_category_components WHERE style_sheet_variable_id = ' || ln_style_sheet_id);
241: ELSE
242: DELETE FROM pay_report_category_components
243: WHERE style_sheet_variable_id = ln_style_sheet_id;
244: END IF;

Line 294: hr_utility.trace('DELETE FROM pay_report_categories WHERE report_category_id = ' || ln_report_category_id);

290: END LOOP;
291: CLOSE csr_get_temp_codes;
292:
293: IF DEBUG_MODE THEN
294: hr_utility.trace('DELETE FROM pay_report_categories WHERE report_category_id = ' || ln_report_category_id);
295: ELSE
296: DELETE FROM pay_report_categories
297: WHERE report_category_id = ln_report_category_id;
298: END IF;

Line 397: hr_utility.trace('Entering '||l_proc_name);

393: l_proc_name VARCHAR2(50);
394: BEGIN
395:
396: l_proc_name := 'INSERT_REPORT_VARIABLE';
397: hr_utility.trace('Entering '||l_proc_name);
398: hr_utility.trace('Inserting report variable '|| p_name);
399:
400: SELECT pay_report_variables_s.nextval INTO p_report_variable_id FROM DUAL;
401:

Line 398: hr_utility.trace('Inserting report variable '|| p_name);

394: BEGIN
395:
396: l_proc_name := 'INSERT_REPORT_VARIABLE';
397: hr_utility.trace('Entering '||l_proc_name);
398: hr_utility.trace('Inserting report variable '|| p_name);
399:
400: SELECT pay_report_variables_s.nextval INTO p_report_variable_id FROM DUAL;
401:
402: IF DEBUG_MODE THEN

Line 403: hr_utility.trace('INSERT INTO pay_report_variables(report_variable_id,report_definition_id,definition_type,name,value,legislation_code,business_group_id) ' ||

399:
400: SELECT pay_report_variables_s.nextval INTO p_report_variable_id FROM DUAL;
401:
402: IF DEBUG_MODE THEN
403: hr_utility.trace('INSERT INTO pay_report_variables(report_variable_id,report_definition_id,definition_type,name,value,legislation_code,business_group_id) ' ||
404: 'VALUES(' ||p_report_variable_id||','||p_report_definition_id||','||p_definition_type||','||p_name||','||p_value||','||NULL||','||p_business_group_id||')');
405: ELSE
406: INSERT INTO pay_report_variables(report_variable_id,
407: report_definition_id,

Line 422: hr_utility.trace('Leaving '||l_proc_name);

418: NULL,
419: p_business_group_id);
420: END IF;
421:
422: hr_utility.trace('Leaving '||l_proc_name);
423:
424: END insert_report_variable;
425:
426: PROCEDURE insert_report_catg_comp(p_report_category_id NUMBER,

Line 439: hr_utility.trace('Entering '||l_proc_name);

435:
436: BEGIN
437:
438: l_proc_name := 'INSERT_REPORT_CATEGORY_COMPONENT';
439: hr_utility.trace('Entering '||l_proc_name);
440: hr_utility.trace('Deleting report category component.');
441:
442: SELECT pay_report_category_comp_s.nextval INTO p_report_category_comp_id FROM DUAL;
443:

Line 440: hr_utility.trace('Deleting report category component.');

436: BEGIN
437:
438: l_proc_name := 'INSERT_REPORT_CATEGORY_COMPONENT';
439: hr_utility.trace('Entering '||l_proc_name);
440: hr_utility.trace('Deleting report category component.');
441:
442: SELECT pay_report_category_comp_s.nextval INTO p_report_category_comp_id FROM DUAL;
443:
444: hr_utility.trace('Inserting report category component.');

Line 444: hr_utility.trace('Inserting report category component.');

440: hr_utility.trace('Deleting report category component.');
441:
442: SELECT pay_report_category_comp_s.nextval INTO p_report_category_comp_id FROM DUAL;
443:
444: hr_utility.trace('Inserting report category component.');
445:
446: IF DEBUG_MODE THEN
447: hr_utility.trace('INSERT INTO PAY_REPORT_CATEGORY_COMPONENTS(report_category_comp_id,report_category_id,report_definition_id,breakout_variable_id,order_by_variable_id,style_sheet_variable_id,legislation_code,business_group_id) ' ||
448: 'VALUES (' ||p_report_category_comp_id||','||p_report_category_id||','||p_report_definition_id||','||p_breakout_variable_id||','||p_order_by_variable_id||','||p_style_sheet_variable_id||','||NULL||','||

Line 447: hr_utility.trace('INSERT INTO PAY_REPORT_CATEGORY_COMPONENTS(report_category_comp_id,report_category_id,report_definition_id,breakout_variable_id,order_by_variable_id,style_sheet_variable_id,legislation_code,business_group_id) ' ||

443:
444: hr_utility.trace('Inserting report category component.');
445:
446: IF DEBUG_MODE THEN
447: hr_utility.trace('INSERT INTO PAY_REPORT_CATEGORY_COMPONENTS(report_category_comp_id,report_category_id,report_definition_id,breakout_variable_id,order_by_variable_id,style_sheet_variable_id,legislation_code,business_group_id) ' ||
448: 'VALUES (' ||p_report_category_comp_id||','||p_report_category_id||','||p_report_definition_id||','||p_breakout_variable_id||','||p_order_by_variable_id||','||p_style_sheet_variable_id||','||NULL||','||
449: p_business_group_id||');');
450: ELSE
451: INSERT INTO PAY_REPORT_CATEGORY_COMPONENTS(report_category_comp_id,

Line 469: hr_utility.trace('Leaving '||l_proc_name);

465: NULL,
466: p_business_group_id);
467: END IF;
468:
469: hr_utility.trace('Leaving '||l_proc_name);
470:
471: END insert_report_catg_comp;
472:
473: PROCEDURE insert_report_category(p_report_group_id IN NUMBER,

Line 485: hr_utility.trace('Entering '||l_proc_name);

481:
482: BEGIN
483:
484: l_proc_name := 'INSERT_REPORT_CATEGORY';
485: hr_utility.trace('Entering '||l_proc_name);
486: hr_utility.trace('Inserting report category '|| p_short_name);
487:
488: IF DEBUG_MODE THEN
489: hr_utility.trace('INSERT INTO pay_report_categories(report_category_id,report_group_id,category_name,short_name,legislation_code,business_group_id) ' ||

Line 486: hr_utility.trace('Inserting report category '|| p_short_name);

482: BEGIN
483:
484: l_proc_name := 'INSERT_REPORT_CATEGORY';
485: hr_utility.trace('Entering '||l_proc_name);
486: hr_utility.trace('Inserting report category '|| p_short_name);
487:
488: IF DEBUG_MODE THEN
489: hr_utility.trace('INSERT INTO pay_report_categories(report_category_id,report_group_id,category_name,short_name,legislation_code,business_group_id) ' ||
490: 'VALUES ('||p_report_category_id||','||p_report_group_id||','||p_category_name||','||p_short_name||','||p_legislation_code||','||p_business_group_id||');');

Line 489: hr_utility.trace('INSERT INTO pay_report_categories(report_category_id,report_group_id,category_name,short_name,legislation_code,business_group_id) ' ||

485: hr_utility.trace('Entering '||l_proc_name);
486: hr_utility.trace('Inserting report category '|| p_short_name);
487:
488: IF DEBUG_MODE THEN
489: hr_utility.trace('INSERT INTO pay_report_categories(report_category_id,report_group_id,category_name,short_name,legislation_code,business_group_id) ' ||
490: 'VALUES ('||p_report_category_id||','||p_report_group_id||','||p_category_name||','||p_short_name||','||p_legislation_code||','||p_business_group_id||');');
491: ELSE
492: INSERT INTO pay_report_categories(report_category_id,
493: report_group_id,

Line 506: hr_utility.trace('Leaving '||l_proc_name);

502: p_legislation_code,
503: p_business_group_id);
504: END IF;
505:
506: hr_utility.trace('Leaving '||l_proc_name);
507:
508: END insert_report_category;
509:
510: FUNCTION GET_NAME(p_conc_prog IN VARCHAR2)