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

Line 65: Purpose : Log a message, either using fnd_file, or hr_utility.trace

61:
62:
63: /******************************************************************************
64: Name : msg
65: Purpose : Log a message, either using fnd_file, or hr_utility.trace
66: ******************************************************************************/
67:
68: PROCEDURE msg(p_text VARCHAR2)
69: IS

Line 79: Purpose : Log a message, either using fnd_file, or hr_utility.trace

75: END msg;
76:
77: /******************************************************************************
78: Name : dbg
79: Purpose : Log a message, either using fnd_file, or hr_utility.trace
80: if debuggging is enabled
81: ******************************************************************************/
82: PROCEDURE dbg(p_text VARCHAR2) IS
83:

Line 92: hr_utility.trace(p_text);

88: -- Write to the concurrent request log
89: fnd_file.put_line(fnd_file.log, p_text);
90: ELSE
91: -- Use HR trace
92: hr_utility.trace(p_text);
93: END IF;
94: END IF;
95:
96: END dbg;

Line 146: hr_utility.set_location(gv_package || lv_procedure_name, 10);

142: BEGIN
143:
144: lv_procedure_name := '.get_payroll_action_info';
145:
146: hr_utility.set_location(gv_package || lv_procedure_name, 10);
147: ln_step := 1;
148: dbg('Entering get_payroll_action_info .......');
149:
150: -- open the cursor to get all the parameters from pay_payroll_actions table

Line 172: hr_utility.set_location(gv_package || lv_procedure_name, 20);

168: dbg('affliation type : ' || p_affl_type );
169: dbg('transmitter gre id : ' || to_char(p_trans_gre_id)) ;
170: dbg('gre id : ' || to_char(p_gre_id)) ;
171:
172: hr_utility.set_location(gv_package || lv_procedure_name, 20);
173: ln_step := 3;
174:
175: dbg('Exiting get_payroll_action_info .......');
176:

Line 183: hr_utility.raise_error;

179: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
180: gv_package || lv_procedure_name;
181:
182: dbg(lv_error_message || '-' || sqlerrm);
183: hr_utility.raise_error;
184:
185: END get_payroll_action_info;
186:
187:

Line 217: hr_utility.set_location(gv_package || lv_procedure_name, 10);

213: g_debug_flag := 'Y' ;
214: -- g_concurrent_flag := 'Y' ;
215:
216: lv_procedure_name := '.range_cursor';
217: hr_utility.set_location(gv_package || lv_procedure_name, 10);
218:
219: -- Get all the parameter information from pay_payroll_actions table
220: dbg('Get parameter information from pay_payroll_actions table' ) ;
221:

Line 228: hr_utility.set_location(gv_package || lv_procedure_name, 20);

224: ,p_trans_gre_id => ln_trans_gre_id
225: ,p_gre_id => ln_gre_id
226: ,p_affl_type => lv_affl_type);
227:
228: hr_utility.set_location(gv_package || lv_procedure_name, 20);
229:
230: lv_sql_string := 'select distinct pai.assignment_id
231: from pay_action_information pai
232: where pai.action_information_category =

Line 237: hr_utility.set_location(gv_package || lv_procedure_name, 30);

233: decode(''' ||lv_affl_type|| ''',''HIRES'',''MX SS HIRE DETAILS'',''SEPARATIONS'',''MX SS SEPARATION DETAILS'')
234: and pai.action_information22 =''A''
235: and :payroll_action_id > 0 ' ;
236:
237: hr_utility.set_location(gv_package || lv_procedure_name, 30);
238: p_sqlstr := lv_sql_string;
239: hr_utility.set_location(gv_package || lv_procedure_name, 40);
240:
241: dbg('Exiting range_cursor .......') ;

Line 239: hr_utility.set_location(gv_package || lv_procedure_name, 40);

235: and :payroll_action_id > 0 ' ;
236:
237: hr_utility.set_location(gv_package || lv_procedure_name, 30);
238: p_sqlstr := lv_sql_string;
239: hr_utility.set_location(gv_package || lv_procedure_name, 40);
240:
241: dbg('Exiting range_cursor .......') ;
242:
243: END range_cursor;

Line 320: hr_utility.set_location(gv_package || lv_procedure_name, 10);

316: -- g_concurrent_flag := 'Y' ;
317:
318: lv_procedure_name := '.action_creation';
319:
320: hr_utility.set_location(gv_package || lv_procedure_name, 10);
321: ln_step := 1;
322: dbg('Get parameter information from pay_payroll_actions table' ) ;
323:
324: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id

Line 331: hr_utility.set_location(gv_package || lv_procedure_name, 20);

327: ,p_gre_id => ln_gre_id
328: ,p_affl_type => lv_affl_type);
329:
330:
331: hr_utility.set_location(gv_package || lv_procedure_name, 20);
332: ln_step := 2;
333: dbg('Action creation Query parameters') ;
334: dbg('Start assignment id : ' || to_char(p_start_assignment_id));
335: dbg('End assignment id : ' || to_char(p_end_assignment_id));

Line 348: hr_utility.set_location(gv_package || lv_procedure_name, 30);

344: ,ln_gre_id
345: ,lv_affl_type);
346:
347: -- Loop for all rows returned for SQL statement.
348: hr_utility.set_location(gv_package || lv_procedure_name, 30);
349: ln_step := 3;
350:
351: loop
352: fetch c_get_asg into ln_action_context_id,ln_assignment_id,ln_tax_unit_id ;

Line 384: hr_utility.set_location(gv_package || lv_procedure_name, 50);

380:
381: end loop;
382: close c_get_asg;
383:
384: hr_utility.set_location(gv_package || lv_procedure_name, 50);
385: ln_step := 5;
386:
387: dbg('Exiting Action creation ..............') ;
388:

Line 395: hr_utility.raise_error;

391: when others then
392: lv_error_message := 'Error at step ' || ln_step || ' in ' ||
393: gv_package || lv_procedure_name;
394: dbg(lv_error_message || '-' || sqlerrm);
395: hr_utility.raise_error;
396:
397: END action_creation;
398:
399: /************************************************************

Line 420: -- Null/N means write as a hr_utility.trace

416:
417: gv_package := 'per_mx_ssaffl_dispmag' ;
418: g_debug_flag := 'Y' ; -- Y means debug is ON
419: -- g_concurrent_flag := 'Y' ; -- Y means write in log file
420: -- Null/N means write as a hr_utility.trace
421:
422: lv_procedure_name := '.archinit';
423:
424: hr_utility.set_location(gv_package || lv_procedure_name, 10);

Line 424: hr_utility.set_location(gv_package || lv_procedure_name, 10);

420: -- Null/N means write as a hr_utility.trace
421:
422: lv_procedure_name := '.archinit';
423:
424: hr_utility.set_location(gv_package || lv_procedure_name, 10);
425: ln_step := 1;
426:
427: dbg('Exiting archinit .............');
428:

Line 1217: --hr_utility.trace_on (null, 'SSDISPMAG');

1213: END format_dispmag_total_record ;
1214:
1215:
1216: --begin
1217: --hr_utility.trace_on (null, 'SSDISPMAG');
1218:
1219: end per_mx_ssaffl_dispmag;