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 DBMS_OUTPUT

Line 191: dbms_output.put_line('Before Opening Category Cursor : csr_report_category_id');

187:
188: IF csr_report_group_id%FOUND THEN
189: fnd_file.put_line(fnd_file.log,'Report Group Id : ' || ln_report_group_id);
190: IF DEBUG_MODE THEN
191: dbms_output.put_line('Before Opening Category Cursor : csr_report_category_id');
192: dbms_output.put_line('ln_report_group_id='||ln_report_group_id);
193: dbms_output.put_line('p_lookup_type_name='||p_lookup_type_name);
194: dbms_output.put_line('p_business_group_id='||p_business_group_id);
195: END IF;

Line 192: dbms_output.put_line('ln_report_group_id='||ln_report_group_id);

188: IF csr_report_group_id%FOUND THEN
189: fnd_file.put_line(fnd_file.log,'Report Group Id : ' || ln_report_group_id);
190: IF DEBUG_MODE THEN
191: dbms_output.put_line('Before Opening Category Cursor : csr_report_category_id');
192: dbms_output.put_line('ln_report_group_id='||ln_report_group_id);
193: dbms_output.put_line('p_lookup_type_name='||p_lookup_type_name);
194: dbms_output.put_line('p_business_group_id='||p_business_group_id);
195: END IF;
196:

Line 193: dbms_output.put_line('p_lookup_type_name='||p_lookup_type_name);

189: fnd_file.put_line(fnd_file.log,'Report Group Id : ' || ln_report_group_id);
190: IF DEBUG_MODE THEN
191: dbms_output.put_line('Before Opening Category Cursor : csr_report_category_id');
192: dbms_output.put_line('ln_report_group_id='||ln_report_group_id);
193: dbms_output.put_line('p_lookup_type_name='||p_lookup_type_name);
194: dbms_output.put_line('p_business_group_id='||p_business_group_id);
195: END IF;
196:
197: OPEN csr_report_category_id(ln_report_group_id,p_lookup_type_name,p_business_group_id);

Line 194: dbms_output.put_line('p_business_group_id='||p_business_group_id);

190: IF DEBUG_MODE THEN
191: dbms_output.put_line('Before Opening Category Cursor : csr_report_category_id');
192: dbms_output.put_line('ln_report_group_id='||ln_report_group_id);
193: dbms_output.put_line('p_lookup_type_name='||p_lookup_type_name);
194: dbms_output.put_line('p_business_group_id='||p_business_group_id);
195: END IF;
196:
197: OPEN csr_report_category_id(ln_report_group_id,p_lookup_type_name,p_business_group_id);
198: FETCH csr_report_category_id INTO ln_report_category_id;

Line 201: dbms_output.put_line('After Opening Category Cursor : csr_report_category_id');

197: OPEN csr_report_category_id(ln_report_group_id,p_lookup_type_name,p_business_group_id);
198: FETCH csr_report_category_id INTO ln_report_category_id;
199:
200: IF DEBUG_MODE THEN
201: dbms_output.put_line('After Opening Category Cursor : csr_report_category_id');
202: dbms_output.put_line('ln_report_category_id='||ln_report_category_id);
203: END IF;
204:
205: IF csr_report_category_id%FOUND THEN

Line 202: dbms_output.put_line('ln_report_category_id='||ln_report_category_id);

198: FETCH csr_report_category_id INTO ln_report_category_id;
199:
200: IF DEBUG_MODE THEN
201: dbms_output.put_line('After Opening Category Cursor : csr_report_category_id');
202: dbms_output.put_line('ln_report_category_id='||ln_report_category_id);
203: END IF;
204:
205: IF csr_report_category_id%FOUND THEN
206:

Line 223: dbms_output.put_line('DELETE FROM pay_report_variables WHERE report_variable_id = ' || ln_report_variable_id);

219: FETCH csr_report_variable_id INTO ln_report_variable_id;
220: IF csr_report_variable_id%FOUND THEN
221: fnd_file.put_line(fnd_file.log,'Removing Variable Id : ' || ln_style_sheet_id);
222: IF DEBUG_MODE THEN
223: dbms_output.put_line('DELETE FROM pay_report_variables WHERE report_variable_id = ' || ln_report_variable_id);
224: ELSE
225: DELETE FROM pay_report_variables
226: WHERE report_variable_id = ln_report_variable_id;
227: END IF;

Line 231: dbms_output.put_line('DELETE FROM pay_report_category_components WHERE style_sheet_variable_id = ' || ln_style_sheet_id);

227: END IF;
228: END IF;
229: CLOSE csr_report_variable_id;
230: IF DEBUG_MODE THEN
231: dbms_output.put_line('DELETE FROM pay_report_category_components WHERE style_sheet_variable_id = ' || ln_style_sheet_id);
232: ELSE
233: DELETE FROM pay_report_category_components
234: WHERE style_sheet_variable_id = ln_style_sheet_id;
235: END IF;

Line 285: dbms_output.put_line('DELETE FROM pay_report_categories WHERE report_category_id = ' || ln_report_category_id);

281: END LOOP;
282: CLOSE csr_get_temp_codes;
283:
284: IF DEBUG_MODE THEN
285: dbms_output.put_line('DELETE FROM pay_report_categories WHERE report_category_id = ' || ln_report_category_id);
286: ELSE
287: DELETE FROM pay_report_categories
288: WHERE report_category_id = ln_report_category_id;
289: END IF;

Line 394: dbms_output.put_line('INSERT INTO pay_report_variables(report_variable_id,report_definition_id,definition_type,name,value,legislation_code,business_group_id) ' ||

390:
391: SELECT pay_report_variables_s.nextval INTO p_report_variable_id FROM DUAL;
392:
393: IF DEBUG_MODE THEN
394: dbms_output.put_line('INSERT INTO pay_report_variables(report_variable_id,report_definition_id,definition_type,name,value,legislation_code,business_group_id) ' ||
395: 'VALUES(' ||p_report_variable_id||','||p_report_definition_id||','||p_definition_type||','||p_name||','||p_value||','||NULL||','||p_business_group_id||')');
396: ELSE
397: INSERT INTO pay_report_variables(report_variable_id,
398: report_definition_id,

Line 438: dbms_output.put_line('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) ' ||

434:
435: hr_utility.trace('Inserting report category component.');
436:
437: IF DEBUG_MODE THEN
438: dbms_output.put_line('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) ' ||
439: '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||','||
440: p_business_group_id||');');
441: ELSE
442: INSERT INTO PAY_REPORT_CATEGORY_COMPONENTS(report_category_comp_id,

Line 480: dbms_output.put_line('INSERT INTO pay_report_categories(report_category_id,report_group_id,category_name,short_name,legislation_code,business_group_id) ' ||

476: hr_utility.trace('Entering '||l_proc_name);
477: hr_utility.trace('Inserting report category '|| p_short_name);
478:
479: IF DEBUG_MODE THEN
480: dbms_output.put_line('INSERT INTO pay_report_categories(report_category_id,report_group_id,category_name,short_name,legislation_code,business_group_id) ' ||
481: 'VALUES ('||p_report_category_id||','||p_report_group_id||','||p_category_name||','||p_short_name||','||p_legislation_code||','||p_business_group_id||');');
482: ELSE
483: INSERT INTO pay_report_categories(report_category_id,
484: report_group_id,