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

Line 198: hr_utility.set_location('Entering : ' || l_proc, 10);

194: --
195: return l_formula_id;
196: end formula_id;
197: begin
198: hr_utility.set_location('Entering : ' || l_proc, 10);
199: --
200: -- Execute initialization code only if this is the first run
201: --
202: if g_parameter.effective_date is null then

Line 214: hr_utility.trace('Session Date : ' || fnd_date.date_to_canonical(g_parameter.effective_date));

210: g_parameter.effective_date_from := fnd_date.canonical_to_date(pay_jp_mag_utility_pkg.get_parameter('EFFECTIVE_DATE_FROM'));
211: g_parameter.effective_date_to := fnd_date.canonical_to_date(pay_jp_mag_utility_pkg.get_parameter('EFFECTIVE_DATE_TO'));
212: g_parameter.organization_id := fnd_number.canonical_to_number(pay_jp_mag_utility_pkg.get_parameter('ORGANIZATION_ID'));
213: --
214: hr_utility.trace('Session Date : ' || fnd_date.date_to_canonical(g_parameter.effective_date));
215: hr_utility.trace('EFFECTIVE_DATE_FROM : ' || fnd_date.date_to_canonical(g_parameter.effective_date_from));
216: hr_utility.trace('EFFECTIVE_DATE_TO : ' || fnd_date.date_to_canonical(g_parameter.effective_date_to));
217: hr_utility.trace('ORGANIZATION_ID : ' || to_char(g_parameter.organization_id));
218: hr_utility.trace('CHARACTER_SET : ' || pay_jp_mag_utility_pkg.get_parameter('CHARACTER_SET'));

Line 215: hr_utility.trace('EFFECTIVE_DATE_FROM : ' || fnd_date.date_to_canonical(g_parameter.effective_date_from));

211: g_parameter.effective_date_to := fnd_date.canonical_to_date(pay_jp_mag_utility_pkg.get_parameter('EFFECTIVE_DATE_TO'));
212: g_parameter.organization_id := fnd_number.canonical_to_number(pay_jp_mag_utility_pkg.get_parameter('ORGANIZATION_ID'));
213: --
214: hr_utility.trace('Session Date : ' || fnd_date.date_to_canonical(g_parameter.effective_date));
215: hr_utility.trace('EFFECTIVE_DATE_FROM : ' || fnd_date.date_to_canonical(g_parameter.effective_date_from));
216: hr_utility.trace('EFFECTIVE_DATE_TO : ' || fnd_date.date_to_canonical(g_parameter.effective_date_to));
217: hr_utility.trace('ORGANIZATION_ID : ' || to_char(g_parameter.organization_id));
218: hr_utility.trace('CHARACTER_SET : ' || pay_jp_mag_utility_pkg.get_parameter('CHARACTER_SET'));
219: hr_utility.set_location(l_proc, 20);

Line 216: hr_utility.trace('EFFECTIVE_DATE_TO : ' || fnd_date.date_to_canonical(g_parameter.effective_date_to));

212: g_parameter.organization_id := fnd_number.canonical_to_number(pay_jp_mag_utility_pkg.get_parameter('ORGANIZATION_ID'));
213: --
214: hr_utility.trace('Session Date : ' || fnd_date.date_to_canonical(g_parameter.effective_date));
215: hr_utility.trace('EFFECTIVE_DATE_FROM : ' || fnd_date.date_to_canonical(g_parameter.effective_date_from));
216: hr_utility.trace('EFFECTIVE_DATE_TO : ' || fnd_date.date_to_canonical(g_parameter.effective_date_to));
217: hr_utility.trace('ORGANIZATION_ID : ' || to_char(g_parameter.organization_id));
218: hr_utility.trace('CHARACTER_SET : ' || pay_jp_mag_utility_pkg.get_parameter('CHARACTER_SET'));
219: hr_utility.set_location(l_proc, 20);
220: --

Line 217: hr_utility.trace('ORGANIZATION_ID : ' || to_char(g_parameter.organization_id));

213: --
214: hr_utility.trace('Session Date : ' || fnd_date.date_to_canonical(g_parameter.effective_date));
215: hr_utility.trace('EFFECTIVE_DATE_FROM : ' || fnd_date.date_to_canonical(g_parameter.effective_date_from));
216: hr_utility.trace('EFFECTIVE_DATE_TO : ' || fnd_date.date_to_canonical(g_parameter.effective_date_to));
217: hr_utility.trace('ORGANIZATION_ID : ' || to_char(g_parameter.organization_id));
218: hr_utility.trace('CHARACTER_SET : ' || pay_jp_mag_utility_pkg.get_parameter('CHARACTER_SET'));
219: hr_utility.set_location(l_proc, 20);
220: --
221: -- Derive 6 formulas to be executed by PYUMAG

Line 218: hr_utility.trace('CHARACTER_SET : ' || pay_jp_mag_utility_pkg.get_parameter('CHARACTER_SET'));

214: hr_utility.trace('Session Date : ' || fnd_date.date_to_canonical(g_parameter.effective_date));
215: hr_utility.trace('EFFECTIVE_DATE_FROM : ' || fnd_date.date_to_canonical(g_parameter.effective_date_from));
216: hr_utility.trace('EFFECTIVE_DATE_TO : ' || fnd_date.date_to_canonical(g_parameter.effective_date_to));
217: hr_utility.trace('ORGANIZATION_ID : ' || to_char(g_parameter.organization_id));
218: hr_utility.trace('CHARACTER_SET : ' || pay_jp_mag_utility_pkg.get_parameter('CHARACTER_SET'));
219: hr_utility.set_location(l_proc, 20);
220: --
221: -- Derive 6 formulas to be executed by PYUMAG
222: --

Line 219: hr_utility.set_location(l_proc, 20);

215: hr_utility.trace('EFFECTIVE_DATE_FROM : ' || fnd_date.date_to_canonical(g_parameter.effective_date_from));
216: hr_utility.trace('EFFECTIVE_DATE_TO : ' || fnd_date.date_to_canonical(g_parameter.effective_date_to));
217: hr_utility.trace('ORGANIZATION_ID : ' || to_char(g_parameter.organization_id));
218: hr_utility.trace('CHARACTER_SET : ' || pay_jp_mag_utility_pkg.get_parameter('CHARACTER_SET'));
219: hr_utility.set_location(l_proc, 20);
220: --
221: -- Derive 6 formulas to be executed by PYUMAG
222: --
223: open csr_org;

Line 252: hr_utility.trace('BUSINESS_GROUP_ID : ' || to_char(g_parameter.business_group_id));

248: if g_formula.end_record_formatter is null then
249: g_formula.end_record_formatter := formula_id(c_end_record_formatter);
250: end if;
251: --
252: hr_utility.trace('BUSINESS_GROUP_ID : ' || to_char(g_parameter.business_group_id));
253: hr_utility.trace('HEADER_RECORD_FORMATTER : ' || to_char(g_formula.header_record_formatter));
254: hr_utility.trace('DATA_RECORD_INIT : ' || to_char(g_formula.data_record_init));
255: hr_utility.trace('DATA_RECORD_DETAIL : ' || to_char(g_formula.data_record_detail));
256: hr_utility.trace('DATA_RECORD_FORMATTER : ' || to_char(g_formula.data_record_formatter));

Line 253: hr_utility.trace('HEADER_RECORD_FORMATTER : ' || to_char(g_formula.header_record_formatter));

249: g_formula.end_record_formatter := formula_id(c_end_record_formatter);
250: end if;
251: --
252: hr_utility.trace('BUSINESS_GROUP_ID : ' || to_char(g_parameter.business_group_id));
253: hr_utility.trace('HEADER_RECORD_FORMATTER : ' || to_char(g_formula.header_record_formatter));
254: hr_utility.trace('DATA_RECORD_INIT : ' || to_char(g_formula.data_record_init));
255: hr_utility.trace('DATA_RECORD_DETAIL : ' || to_char(g_formula.data_record_detail));
256: hr_utility.trace('DATA_RECORD_FORMATTER : ' || to_char(g_formula.data_record_formatter));
257: hr_utility.trace('TRAILER_RECORD_FORMATTER : ' || to_char(g_formula.trailer_record_formatter));

Line 254: hr_utility.trace('DATA_RECORD_INIT : ' || to_char(g_formula.data_record_init));

250: end if;
251: --
252: hr_utility.trace('BUSINESS_GROUP_ID : ' || to_char(g_parameter.business_group_id));
253: hr_utility.trace('HEADER_RECORD_FORMATTER : ' || to_char(g_formula.header_record_formatter));
254: hr_utility.trace('DATA_RECORD_INIT : ' || to_char(g_formula.data_record_init));
255: hr_utility.trace('DATA_RECORD_DETAIL : ' || to_char(g_formula.data_record_detail));
256: hr_utility.trace('DATA_RECORD_FORMATTER : ' || to_char(g_formula.data_record_formatter));
257: hr_utility.trace('TRAILER_RECORD_FORMATTER : ' || to_char(g_formula.trailer_record_formatter));
258: hr_utility.trace('END_RECORD_FORMATTER : ' || to_char(g_formula.end_record_formatter));

Line 255: hr_utility.trace('DATA_RECORD_DETAIL : ' || to_char(g_formula.data_record_detail));

251: --
252: hr_utility.trace('BUSINESS_GROUP_ID : ' || to_char(g_parameter.business_group_id));
253: hr_utility.trace('HEADER_RECORD_FORMATTER : ' || to_char(g_formula.header_record_formatter));
254: hr_utility.trace('DATA_RECORD_INIT : ' || to_char(g_formula.data_record_init));
255: hr_utility.trace('DATA_RECORD_DETAIL : ' || to_char(g_formula.data_record_detail));
256: hr_utility.trace('DATA_RECORD_FORMATTER : ' || to_char(g_formula.data_record_formatter));
257: hr_utility.trace('TRAILER_RECORD_FORMATTER : ' || to_char(g_formula.trailer_record_formatter));
258: hr_utility.trace('END_RECORD_FORMATTER : ' || to_char(g_formula.end_record_formatter));
259: hr_utility.set_location(l_proc, 30);

Line 256: hr_utility.trace('DATA_RECORD_FORMATTER : ' || to_char(g_formula.data_record_formatter));

252: hr_utility.trace('BUSINESS_GROUP_ID : ' || to_char(g_parameter.business_group_id));
253: hr_utility.trace('HEADER_RECORD_FORMATTER : ' || to_char(g_formula.header_record_formatter));
254: hr_utility.trace('DATA_RECORD_INIT : ' || to_char(g_formula.data_record_init));
255: hr_utility.trace('DATA_RECORD_DETAIL : ' || to_char(g_formula.data_record_detail));
256: hr_utility.trace('DATA_RECORD_FORMATTER : ' || to_char(g_formula.data_record_formatter));
257: hr_utility.trace('TRAILER_RECORD_FORMATTER : ' || to_char(g_formula.trailer_record_formatter));
258: hr_utility.trace('END_RECORD_FORMATTER : ' || to_char(g_formula.end_record_formatter));
259: hr_utility.set_location(l_proc, 30);
260: --

Line 257: hr_utility.trace('TRAILER_RECORD_FORMATTER : ' || to_char(g_formula.trailer_record_formatter));

253: hr_utility.trace('HEADER_RECORD_FORMATTER : ' || to_char(g_formula.header_record_formatter));
254: hr_utility.trace('DATA_RECORD_INIT : ' || to_char(g_formula.data_record_init));
255: hr_utility.trace('DATA_RECORD_DETAIL : ' || to_char(g_formula.data_record_detail));
256: hr_utility.trace('DATA_RECORD_FORMATTER : ' || to_char(g_formula.data_record_formatter));
257: hr_utility.trace('TRAILER_RECORD_FORMATTER : ' || to_char(g_formula.trailer_record_formatter));
258: hr_utility.trace('END_RECORD_FORMATTER : ' || to_char(g_formula.end_record_formatter));
259: hr_utility.set_location(l_proc, 30);
260: --
261: -- Derive "Data Record" information with BULK COLLECT

Line 258: hr_utility.trace('END_RECORD_FORMATTER : ' || to_char(g_formula.end_record_formatter));

254: hr_utility.trace('DATA_RECORD_INIT : ' || to_char(g_formula.data_record_init));
255: hr_utility.trace('DATA_RECORD_DETAIL : ' || to_char(g_formula.data_record_detail));
256: hr_utility.trace('DATA_RECORD_FORMATTER : ' || to_char(g_formula.data_record_formatter));
257: hr_utility.trace('TRAILER_RECORD_FORMATTER : ' || to_char(g_formula.trailer_record_formatter));
258: hr_utility.trace('END_RECORD_FORMATTER : ' || to_char(g_formula.end_record_formatter));
259: hr_utility.set_location(l_proc, 30);
260: --
261: -- Derive "Data Record" information with BULK COLLECT
262: --

Line 259: hr_utility.set_location(l_proc, 30);

255: hr_utility.trace('DATA_RECORD_DETAIL : ' || to_char(g_formula.data_record_detail));
256: hr_utility.trace('DATA_RECORD_FORMATTER : ' || to_char(g_formula.data_record_formatter));
257: hr_utility.trace('TRAILER_RECORD_FORMATTER : ' || to_char(g_formula.trailer_record_formatter));
258: hr_utility.trace('END_RECORD_FORMATTER : ' || to_char(g_formula.end_record_formatter));
259: hr_utility.set_location(l_proc, 30);
260: --
261: -- Derive "Data Record" information with BULK COLLECT
262: --
263: g_data.current_index := 0;

Line 265: hr_utility.trace('DATA_RECORD_SORT_ORDER : ' || l_data_record_sort_order);

261: -- Derive "Data Record" information with BULK COLLECT
262: --
263: g_data.current_index := 0;
264: --
265: hr_utility.trace('DATA_RECORD_SORT_ORDER : ' || l_data_record_sort_order);
266: --
267: -- Broken the cursor fetch statement as PL/SQL Code to fix Bug 5371071
268: --
269: for l_rec in csr_data(l_data_record_sort_order)

Line 381: hr_utility.trace('Num of Data Records : ' || to_char(g_data.district_code_tbl.count));

377: g_data.term_prefectural_tax_tbl(l_rec_count) := l_sp_ltax_to;
378:
379: end if;
380: --
381: hr_utility.trace('Num of Data Records : ' || to_char(g_data.district_code_tbl.count));
382: end if;
383: --
384: hr_utility.set_location('Leaving : ' || l_proc, 40);
385: end init;

Line 384: hr_utility.set_location('Leaving : ' || l_proc, 40);

380: --
381: hr_utility.trace('Num of Data Records : ' || to_char(g_data.district_code_tbl.count));
382: end if;
383: --
384: hr_utility.set_location('Leaving : ' || l_proc, 40);
385: end init;
386: -- ----------------------------------------------------------------------------
387: -- |-----------------------------< run_formula >------------------------------|
388: -- ----------------------------------------------------------------------------

Line 395: hr_utility.set_location('Entering : ' || l_proc, 10);

391: l_proc varchar2(61) := c_package || 'run_formula';
392: --
393: l_formula_id number;
394: begin
395: hr_utility.set_location('Entering : ' || l_proc, 10);
396: --
397: -- Execute initialization code
398: --
399: init;

Line 445: hr_utility.set_location(l_proc, 20);

441: raise NO_DATA_FOUND;
442: end if;
443: end if;
444: --
445: hr_utility.set_location(l_proc, 20);
446: --
447: -- Setup contexts and parameters depending on the formula
448: -- which is going to be executed by PYUMAG.
449: -- Note that all parameter values are inherited to the subsequent formulas,

Line 458: hr_utility.trace('HEADER_RECORD_FORMATTER');

454: --
455: -- HEADER_RECORD_FORMATTER
456: --
457: if l_formula_id = g_formula.header_record_formatter then
458: hr_utility.trace('HEADER_RECORD_FORMATTER');
459: --
460: pay_jp_mag_utility_pkg.set_context('BUSINESS_GROUP_ID', g_parameter.business_group_id);
461: pay_jp_mag_utility_pkg.set_context('DATE_EARNED', g_parameter.effective_date);
462: pay_jp_mag_utility_pkg.set_context('ORGANIZATION_ID', g_parameter.organization_id);

Line 467: hr_utility.trace('DATA_RECORD_INIT');

463: --
464: -- DATA_RECORD_INIT
465: --
466: elsif l_formula_id = g_formula.data_record_init then
467: hr_utility.trace('DATA_RECORD_INIT');
468: --
469: pay_jp_mag_utility_pkg.set_context('BUSINESS_GROUP_ID', g_parameter.business_group_id);
470: pay_jp_mag_utility_pkg.set_context('DATE_EARNED', g_parameter.effective_date);
471: pay_jp_mag_utility_pkg.set_context('ORGANIZATION_ID', g_parameter.organization_id);

Line 480: hr_utility.trace('DATA_RECORD_DETAIL');

476: --
477: -- DATA_RECORD_DETAIL
478: --
479: elsif l_formula_id = g_formula.data_record_detail then
480: hr_utility.trace('DATA_RECORD_DETAIL');
481: --
482: pay_jp_mag_utility_pkg.set_context('BUSINESS_GROUP_ID', g_parameter.business_group_id);
483: pay_jp_mag_utility_pkg.set_context('ORGANIZATION_ID', g_parameter.organization_id);
484: pay_jp_mag_utility_pkg.set_context('ASSIGNMENT_ID', g_data.assignment_id_tbl(g_data.current_index));

Line 497: hr_utility.trace('DATA_RECORD_FORMATTER');

493: --
494: -- DATA_RECORD_FORMATTER
495: --
496: elsif l_formula_id = g_formula.data_record_formatter then
497: hr_utility.trace('DATA_RECORD_FORMATTER');
498: --
499: pay_jp_mag_utility_pkg.set_context('BUSINESS_GROUP_ID', g_parameter.business_group_id);
500: pay_jp_mag_utility_pkg.set_context('DATE_EARNED', g_parameter.effective_date);
501: pay_jp_mag_utility_pkg.set_context('ORGANIZATION_ID', g_parameter.organization_id);

Line 506: hr_utility.trace('TRAILER_RECORD_FORMATTER');

502: --
503: -- TRAILER_RECORD_FORMATTER
504: --
505: elsif l_formula_id = g_formula.trailer_record_formatter then
506: hr_utility.trace('TRAILER_RECORD_FORMATTER');
507: --
508: pay_jp_mag_utility_pkg.set_context('BUSINESS_GROUP_ID', g_parameter.business_group_id);
509: pay_jp_mag_utility_pkg.set_context('DATE_EARNED', g_parameter.effective_date);
510: pay_jp_mag_utility_pkg.set_context('ORGANIZATION_ID', g_parameter.organization_id);

Line 515: hr_utility.trace('END_RECORD_FORMATTER');

511: --
512: -- END_RECORD_FORMATTER
513: --
514: elsif l_formula_id = g_formula.end_record_formatter then
515: hr_utility.trace('END_RECORD_FORMATTER');
516: --
517: pay_jp_mag_utility_pkg.set_context('BUSINESS_GROUP_ID', g_parameter.business_group_id);
518: pay_jp_mag_utility_pkg.set_context('DATE_EARNED', g_parameter.effective_date);
519: else

Line 520: hr_utility.trace('Unknown formula : ' || to_char(l_formula_id));

516: --
517: pay_jp_mag_utility_pkg.set_context('BUSINESS_GROUP_ID', g_parameter.business_group_id);
518: pay_jp_mag_utility_pkg.set_context('DATE_EARNED', g_parameter.effective_date);
519: else
520: hr_utility.trace('Unknown formula : ' || to_char(l_formula_id));
521: end if;
522: --
523: hr_utility.set_location('Leaving : ' || l_proc, 30);
524: end run_formula;

Line 523: hr_utility.set_location('Leaving : ' || l_proc, 30);

519: else
520: hr_utility.trace('Unknown formula : ' || to_char(l_formula_id));
521: end if;
522: --
523: hr_utility.set_location('Leaving : ' || l_proc, 30);
524: end run_formula;
525: --
526: end pay_jp_ltax_efile_pkg;