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

Line 301: hr_utility.trace('Start of populate_tfn_flags procedure');

297: l_super_assignment_id per_all_assignments_f.assignment_id%TYPE;
298:
299: BEGIN
300:
301: hr_utility.trace('Start of populate_tfn_flags procedure');
302:
303: hr_utility.trace('l_business_group_id : ' || to_char(p_business_group_id));
304: hr_utility.trace('l_legal_employer_id : ' || p_legal_employer_id);
305: hr_utility.trace('l_report_end_date : ' || to_char(p_report_end_date, 'DD-MON-YYYY') );

Line 303: hr_utility.trace('l_business_group_id : ' || to_char(p_business_group_id));

299: BEGIN
300:
301: hr_utility.trace('Start of populate_tfn_flags procedure');
302:
303: hr_utility.trace('l_business_group_id : ' || to_char(p_business_group_id));
304: hr_utility.trace('l_legal_employer_id : ' || p_legal_employer_id);
305: hr_utility.trace('l_report_end_date : ' || to_char(p_report_end_date, 'DD-MON-YYYY') );
306:
307:

Line 304: hr_utility.trace('l_legal_employer_id : ' || p_legal_employer_id);

300:
301: hr_utility.trace('Start of populate_tfn_flags procedure');
302:
303: hr_utility.trace('l_business_group_id : ' || to_char(p_business_group_id));
304: hr_utility.trace('l_legal_employer_id : ' || p_legal_employer_id);
305: hr_utility.trace('l_report_end_date : ' || to_char(p_report_end_date, 'DD-MON-YYYY') );
306:
307:
308:

Line 305: hr_utility.trace('l_report_end_date : ' || to_char(p_report_end_date, 'DD-MON-YYYY') );

301: hr_utility.trace('Start of populate_tfn_flags procedure');
302:
303: hr_utility.trace('l_business_group_id : ' || to_char(p_business_group_id));
304: hr_utility.trace('l_legal_employer_id : ' || p_legal_employer_id);
305: hr_utility.trace('l_report_end_date : ' || to_char(p_report_end_date, 'DD-MON-YYYY') );
306:
307:
308:
309: -- Get the values of Tax Information reportable fields and

Line 312: hr_utility.trace('Opening cursor c_get_tfn_flag_values');

308:
309: -- Get the values of Tax Information reportable fields and
310: -- pupolate values into global table.
311:
312: hr_utility.trace('Opening cursor c_get_tfn_flag_values');
313: OPEN c_get_tfn_flag_values(p_business_group_id,
314: p_legal_employer_id,
315: p_report_end_date );
316: LOOP

Line 338: hr_utility.trace('Employee is not eligible for magtape');

334: -- in the current report is not eligible to be printed on magtape
335:
336: IF (l_tax_file_number = '111 111 111' AND nvl(l_actual_termination_date,p_report_end_date + 1)
337: NOT BETWEEN (p_report_end_date - 13) AND p_report_end_date) THEN
338: hr_utility.trace('Employee is not eligible for magtape');
339:
340: ELSE
341: hr_utility.trace('Value stored for assignment id : ' || to_char(l_assignment_id));
342:

Line 341: hr_utility.trace('Value stored for assignment id : ' || to_char(l_assignment_id));

337: NOT BETWEEN (p_report_end_date - 13) AND p_report_end_date) THEN
338: hr_utility.trace('Employee is not eligible for magtape');
339:
340: ELSE
341: hr_utility.trace('Value stored for assignment id : ' || to_char(l_assignment_id));
342:
343: -- populate the global table
344: g_tfn_flags_table(l_assignment_id).k_assignment_id := l_assignment_id ;
345: g_tfn_flags_table(l_assignment_id).australian_res_flag := l_australian_res_flag ;

Line 370: hr_utility.trace('closing cursor c_get_tfn_flag_values');

366:
367:
368: END IF;
369: END LOOP;
370: hr_utility.trace('closing cursor c_get_tfn_flag_values');
371: CLOSE c_get_tfn_flag_values;
372:
373:
374: /* bug8634876

Line 379: hr_utility.trace('Populating the supernnuation flag in the global table');

375: Populate all the eligible assignments populated in the global plsql table
376: with the proper value of the 'TFN for Super' flag.
377: */
378:
379: hr_utility.trace('Populating the supernnuation flag in the global table');
380:
381: IF g_tfn_flags_table.count > 0 THEN
382: for l_assignment_id in g_tfn_flags_table.first..g_tfn_flags_table.last
383: LOOP

Line 405: hr_utility.trace('End of populate_tfn_flags procedure');

401: END IF;
402: END LOOP;
403: END IF;
404:
405: hr_utility.trace('End of populate_tfn_flags procedure');
406:
407: EXCEPTION
408: WHEN OTHERS THEN
409: hr_utility.trace('Error in populate_tfn_flags');

Line 409: hr_utility.trace('Error in populate_tfn_flags');

405: hr_utility.trace('End of populate_tfn_flags procedure');
406:
407: EXCEPTION
408: WHEN OTHERS THEN
409: hr_utility.trace('Error in populate_tfn_flags');
410: RAISE;
411:
412: END populate_tfn_flags;
413:

Line 428: hr_utility.trace('Start of get_tfn_flag_values function');

424: FUNCTION get_tfn_flag_values(p_assignment_id in per_all_assignments_f.assignment_id%TYPE,
425: p_flag_name in varchar2) RETURN varchar2 IS
426: BEGIN
427:
428: hr_utility.trace('Start of get_tfn_flag_values function');
429: hr_utility.trace('Passed p_assignment_id : ' || to_char(p_assignment_id));
430:
431: -- Check IF assignment exists in the plsql table of tax details values.
432: IF g_tfn_flags_table.exists(p_assignment_id) THEN

Line 429: hr_utility.trace('Passed p_assignment_id : ' || to_char(p_assignment_id));

425: p_flag_name in varchar2) RETURN varchar2 IS
426: BEGIN
427:
428: hr_utility.trace('Start of get_tfn_flag_values function');
429: hr_utility.trace('Passed p_assignment_id : ' || to_char(p_assignment_id));
430:
431: -- Check IF assignment exists in the plsql table of tax details values.
432: IF g_tfn_flags_table.exists(p_assignment_id) THEN
433:

Line 435: hr_utility.trace('The value of the assignment_id passed : ' || to_char(g_tfn_flags_table(p_assignment_id).k_assignment_id));

431: -- Check IF assignment exists in the plsql table of tax details values.
432: IF g_tfn_flags_table.exists(p_assignment_id) THEN
433:
434: -- Return value of the tax detail field for the employee
435: hr_utility.trace('The value of the assignment_id passed : ' || to_char(g_tfn_flags_table(p_assignment_id).k_assignment_id));
436: -- Bug 2728374 : Corrected basis of payment string
437: IF p_flag_name = 'AUSTRALIAN_RESIDENT_FLAG' THEN
438: RETURN g_tfn_flags_table(p_assignment_id).australian_res_flag;
439:

Line 483: hr_utility.trace('End of get_tfn_flag_values function');

479: ELSE
480: RETURN 'N';
481: END IF;
482:
483: hr_utility.trace('End of get_tfn_flag_values function');
484:
485: EXCEPTION
486: WHEN OTHERS THEN
487: hr_utility.trace('Error in get_tfn_flag_values');

Line 487: hr_utility.trace('Error in get_tfn_flag_values');

483: hr_utility.trace('End of get_tfn_flag_values function');
484:
485: EXCEPTION
486: WHEN OTHERS THEN
487: hr_utility.trace('Error in get_tfn_flag_values');
488: RAISE;
489: END get_tfn_flag_values;
490:
491: ------------------------------------------------------------------------------+