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

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

240: decode(per.sex, 'F', 2, 1),
241: per.last_name,
242: per.first_name;
243: begin
244: hr_utility.set_location('Entering : ' || l_proc, 10);
245: --
246: -- If p_effective_date is null, use session_date as effective_date.
247: -- Never cache effective_date into package global variables
248: -- which will cause inconsistency when retropay is run.

Line 258: -- hr_utility.trace('L_EFFECTIVE_DATE : ' || fnd_date.date_to_chardate(l_effective_date));

254: where session_id = userenv('sessionid');
255: end if;
256: l_soy := trunc(l_effective_date, 'YYYY');
257: l_eoy := add_months(l_soy, 12) - 1;
258: -- hr_utility.trace('L_EFFECTIVE_DATE : ' || fnd_date.date_to_chardate(l_effective_date));
259: -- hr_utility.trace('L_SOY : ' || fnd_date.date_to_chardate(l_soy));
260: -- hr_utility.trace('L_EOY : ' || fnd_date.date_to_chardate(l_eoy));
261: --
262: -- If cache is available, use cache.

Line 259: -- hr_utility.trace('L_SOY : ' || fnd_date.date_to_chardate(l_soy));

255: end if;
256: l_soy := trunc(l_effective_date, 'YYYY');
257: l_eoy := add_months(l_soy, 12) - 1;
258: -- hr_utility.trace('L_EFFECTIVE_DATE : ' || fnd_date.date_to_chardate(l_effective_date));
259: -- hr_utility.trace('L_SOY : ' || fnd_date.date_to_chardate(l_soy));
260: -- hr_utility.trace('L_EOY : ' || fnd_date.date_to_chardate(l_eoy));
261: --
262: -- If cache is available, use cache.
263: --

Line 260: -- hr_utility.trace('L_EOY : ' || fnd_date.date_to_chardate(l_eoy));

256: l_soy := trunc(l_effective_date, 'YYYY');
257: l_eoy := add_months(l_soy, 12) - 1;
258: -- hr_utility.trace('L_EFFECTIVE_DATE : ' || fnd_date.date_to_chardate(l_effective_date));
259: -- hr_utility.trace('L_SOY : ' || fnd_date.date_to_chardate(l_soy));
260: -- hr_utility.trace('L_EOY : ' || fnd_date.date_to_chardate(l_eoy));
261: --
262: -- If cache is available, use cache.
263: --
264: if p_use_cache

Line 268: hr_utility.trace('Cache is available.');

264: if p_use_cache
265: and g_itax_dpnt_rec.assignment_id = p_assignment_id
266: and g_itax_dpnt_rec.itax_type = p_itax_type
267: and g_itax_dpnt_rec.effective_date = l_effective_date then
268: hr_utility.trace('Cache is available.');
269: --
270: p_itax_dpnt_rec := g_itax_dpnt_rec;
271: --
272: -- Cache is not available, derive directly from CTR and CEI.

Line 275: hr_utility.trace('Cache is NOT available. Derive from CTR and CEI.');

271: --
272: -- Cache is not available, derive directly from CTR and CEI.
273: --
274: else
275: hr_utility.trace('Cache is NOT available. Derive from CTR and CEI.');
276: --
277: -- Initialization for "p_itax_dpnt_rec" is automatically done by "OUT" parameter.
278: --
279: p_itax_dpnt_rec.assignment_id := p_assignment_id;

Line 286: hr_utility.trace('Taxation Type : ' || p_itax_type);

282: --
283: -- Income Tax Type "KOU"
284: --
285: if p_itax_type in ('M_KOU', 'D_KOU', 'M_OTSU', 'D_OTSU') then
286: hr_utility.trace('Taxation Type : ' || p_itax_type);
287: --
288: if p_itax_type in ('M_KOU', 'D_KOU') then
289: l_information_type := c_kou_information_type;
290: else

Line 295: hr_utility.trace('**********');

291: l_information_type := c_otsu_information_type;
292: end if;
293: --
294: for l_dpnt in csr_dpnt(l_information_type) loop
295: hr_utility.trace('**********');
296: -- hr_utility.trace('Effective Date : ' || fnd_date.date_to_chardate(l_dpnt.effective_date));
297: -- hr_utility.trace('Date of Birth : ' || fnd_date.date_to_chardate(l_dpnt.date_of_birth));
298: -- hr_utility.trace('Date of Death : ' || fnd_date.date_to_chardate(l_dpnt.date_of_death));
299: hr_utility.trace('Contact Type : ' || l_dpnt.contact_type);

Line 296: -- hr_utility.trace('Effective Date : ' || fnd_date.date_to_chardate(l_dpnt.effective_date));

292: end if;
293: --
294: for l_dpnt in csr_dpnt(l_information_type) loop
295: hr_utility.trace('**********');
296: -- hr_utility.trace('Effective Date : ' || fnd_date.date_to_chardate(l_dpnt.effective_date));
297: -- hr_utility.trace('Date of Birth : ' || fnd_date.date_to_chardate(l_dpnt.date_of_birth));
298: -- hr_utility.trace('Date of Death : ' || fnd_date.date_to_chardate(l_dpnt.date_of_death));
299: hr_utility.trace('Contact Type : ' || l_dpnt.contact_type);
300: hr_utility.trace('Last Name : ' || l_dpnt.first_name_kana);

Line 297: -- hr_utility.trace('Date of Birth : ' || fnd_date.date_to_chardate(l_dpnt.date_of_birth));

293: --
294: for l_dpnt in csr_dpnt(l_information_type) loop
295: hr_utility.trace('**********');
296: -- hr_utility.trace('Effective Date : ' || fnd_date.date_to_chardate(l_dpnt.effective_date));
297: -- hr_utility.trace('Date of Birth : ' || fnd_date.date_to_chardate(l_dpnt.date_of_birth));
298: -- hr_utility.trace('Date of Death : ' || fnd_date.date_to_chardate(l_dpnt.date_of_death));
299: hr_utility.trace('Contact Type : ' || l_dpnt.contact_type);
300: hr_utility.trace('Last Name : ' || l_dpnt.first_name_kana);
301: hr_utility.trace('Age : ' || l_dpnt.age);

Line 298: -- hr_utility.trace('Date of Death : ' || fnd_date.date_to_chardate(l_dpnt.date_of_death));

294: for l_dpnt in csr_dpnt(l_information_type) loop
295: hr_utility.trace('**********');
296: -- hr_utility.trace('Effective Date : ' || fnd_date.date_to_chardate(l_dpnt.effective_date));
297: -- hr_utility.trace('Date of Birth : ' || fnd_date.date_to_chardate(l_dpnt.date_of_birth));
298: -- hr_utility.trace('Date of Death : ' || fnd_date.date_to_chardate(l_dpnt.date_of_death));
299: hr_utility.trace('Contact Type : ' || l_dpnt.contact_type);
300: hr_utility.trace('Last Name : ' || l_dpnt.first_name_kana);
301: hr_utility.trace('Age : ' || l_dpnt.age);
302: --

Line 299: hr_utility.trace('Contact Type : ' || l_dpnt.contact_type);

295: hr_utility.trace('**********');
296: -- hr_utility.trace('Effective Date : ' || fnd_date.date_to_chardate(l_dpnt.effective_date));
297: -- hr_utility.trace('Date of Birth : ' || fnd_date.date_to_chardate(l_dpnt.date_of_birth));
298: -- hr_utility.trace('Date of Death : ' || fnd_date.date_to_chardate(l_dpnt.date_of_death));
299: hr_utility.trace('Contact Type : ' || l_dpnt.contact_type);
300: hr_utility.trace('Last Name : ' || l_dpnt.first_name_kana);
301: hr_utility.trace('Age : ' || l_dpnt.age);
302: --
303: -- If the contact_type is "Spouse"

Line 300: hr_utility.trace('Last Name : ' || l_dpnt.first_name_kana);

296: -- hr_utility.trace('Effective Date : ' || fnd_date.date_to_chardate(l_dpnt.effective_date));
297: -- hr_utility.trace('Date of Birth : ' || fnd_date.date_to_chardate(l_dpnt.date_of_birth));
298: -- hr_utility.trace('Date of Death : ' || fnd_date.date_to_chardate(l_dpnt.date_of_death));
299: hr_utility.trace('Contact Type : ' || l_dpnt.contact_type);
300: hr_utility.trace('Last Name : ' || l_dpnt.first_name_kana);
301: hr_utility.trace('Age : ' || l_dpnt.age);
302: --
303: -- If the contact_type is "Spouse"
304: --

Line 301: hr_utility.trace('Age : ' || l_dpnt.age);

297: -- hr_utility.trace('Date of Birth : ' || fnd_date.date_to_chardate(l_dpnt.date_of_birth));
298: -- hr_utility.trace('Date of Death : ' || fnd_date.date_to_chardate(l_dpnt.date_of_death));
299: hr_utility.trace('Contact Type : ' || l_dpnt.contact_type);
300: hr_utility.trace('Last Name : ' || l_dpnt.first_name_kana);
301: hr_utility.trace('Age : ' || l_dpnt.age);
302: --
303: -- If the contact_type is "Spouse"
304: --
305: if l_dpnt.contact_type = 'S' then

Line 402: hr_utility.trace('**********');

398: -- for input parameters.
399: --
400: g_itax_dpnt_rec := p_itax_dpnt_rec;
401: --
402: hr_utility.trace('**********');
403: hr_utility.trace('spouse_type : ' || p_itax_dpnt_rec.spouse_type);
404: hr_utility.trace('dpnt_spouse_dsbl_type : ' || p_itax_dpnt_rec.dpnt_spouse_dsbl_type);
405: hr_utility.trace('dpnts : ' || to_char(p_itax_dpnt_rec.dpnts));
406: hr_utility.trace('aged_dpnts : ' || to_char(p_itax_dpnt_rec.aged_dpnts));

Line 403: hr_utility.trace('spouse_type : ' || p_itax_dpnt_rec.spouse_type);

399: --
400: g_itax_dpnt_rec := p_itax_dpnt_rec;
401: --
402: hr_utility.trace('**********');
403: hr_utility.trace('spouse_type : ' || p_itax_dpnt_rec.spouse_type);
404: hr_utility.trace('dpnt_spouse_dsbl_type : ' || p_itax_dpnt_rec.dpnt_spouse_dsbl_type);
405: hr_utility.trace('dpnts : ' || to_char(p_itax_dpnt_rec.dpnts));
406: hr_utility.trace('aged_dpnts : ' || to_char(p_itax_dpnt_rec.aged_dpnts));
407: hr_utility.trace('aged_dpnt_parents_lt : ' || to_char(p_itax_dpnt_rec.aged_dpnt_parents_lt));

Line 404: hr_utility.trace('dpnt_spouse_dsbl_type : ' || p_itax_dpnt_rec.dpnt_spouse_dsbl_type);

400: g_itax_dpnt_rec := p_itax_dpnt_rec;
401: --
402: hr_utility.trace('**********');
403: hr_utility.trace('spouse_type : ' || p_itax_dpnt_rec.spouse_type);
404: hr_utility.trace('dpnt_spouse_dsbl_type : ' || p_itax_dpnt_rec.dpnt_spouse_dsbl_type);
405: hr_utility.trace('dpnts : ' || to_char(p_itax_dpnt_rec.dpnts));
406: hr_utility.trace('aged_dpnts : ' || to_char(p_itax_dpnt_rec.aged_dpnts));
407: hr_utility.trace('aged_dpnt_parents_lt : ' || to_char(p_itax_dpnt_rec.aged_dpnt_parents_lt));
408: hr_utility.trace('young_dpnts : ' || to_char(p_itax_dpnt_rec.young_dpnts));

Line 405: hr_utility.trace('dpnts : ' || to_char(p_itax_dpnt_rec.dpnts));

401: --
402: hr_utility.trace('**********');
403: hr_utility.trace('spouse_type : ' || p_itax_dpnt_rec.spouse_type);
404: hr_utility.trace('dpnt_spouse_dsbl_type : ' || p_itax_dpnt_rec.dpnt_spouse_dsbl_type);
405: hr_utility.trace('dpnts : ' || to_char(p_itax_dpnt_rec.dpnts));
406: hr_utility.trace('aged_dpnts : ' || to_char(p_itax_dpnt_rec.aged_dpnts));
407: hr_utility.trace('aged_dpnt_parents_lt : ' || to_char(p_itax_dpnt_rec.aged_dpnt_parents_lt));
408: hr_utility.trace('young_dpnts : ' || to_char(p_itax_dpnt_rec.young_dpnts));
409: hr_utility.trace('minor_dpnts : ' || to_char(p_itax_dpnt_rec.minor_dpnts));

Line 406: hr_utility.trace('aged_dpnts : ' || to_char(p_itax_dpnt_rec.aged_dpnts));

402: hr_utility.trace('**********');
403: hr_utility.trace('spouse_type : ' || p_itax_dpnt_rec.spouse_type);
404: hr_utility.trace('dpnt_spouse_dsbl_type : ' || p_itax_dpnt_rec.dpnt_spouse_dsbl_type);
405: hr_utility.trace('dpnts : ' || to_char(p_itax_dpnt_rec.dpnts));
406: hr_utility.trace('aged_dpnts : ' || to_char(p_itax_dpnt_rec.aged_dpnts));
407: hr_utility.trace('aged_dpnt_parents_lt : ' || to_char(p_itax_dpnt_rec.aged_dpnt_parents_lt));
408: hr_utility.trace('young_dpnts : ' || to_char(p_itax_dpnt_rec.young_dpnts));
409: hr_utility.trace('minor_dpnts : ' || to_char(p_itax_dpnt_rec.minor_dpnts));
410: hr_utility.trace('dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.dsbl_dpnts));

Line 407: hr_utility.trace('aged_dpnt_parents_lt : ' || to_char(p_itax_dpnt_rec.aged_dpnt_parents_lt));

403: hr_utility.trace('spouse_type : ' || p_itax_dpnt_rec.spouse_type);
404: hr_utility.trace('dpnt_spouse_dsbl_type : ' || p_itax_dpnt_rec.dpnt_spouse_dsbl_type);
405: hr_utility.trace('dpnts : ' || to_char(p_itax_dpnt_rec.dpnts));
406: hr_utility.trace('aged_dpnts : ' || to_char(p_itax_dpnt_rec.aged_dpnts));
407: hr_utility.trace('aged_dpnt_parents_lt : ' || to_char(p_itax_dpnt_rec.aged_dpnt_parents_lt));
408: hr_utility.trace('young_dpnts : ' || to_char(p_itax_dpnt_rec.young_dpnts));
409: hr_utility.trace('minor_dpnts : ' || to_char(p_itax_dpnt_rec.minor_dpnts));
410: hr_utility.trace('dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.dsbl_dpnts));
411: hr_utility.trace('svr_dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts));

Line 408: hr_utility.trace('young_dpnts : ' || to_char(p_itax_dpnt_rec.young_dpnts));

404: hr_utility.trace('dpnt_spouse_dsbl_type : ' || p_itax_dpnt_rec.dpnt_spouse_dsbl_type);
405: hr_utility.trace('dpnts : ' || to_char(p_itax_dpnt_rec.dpnts));
406: hr_utility.trace('aged_dpnts : ' || to_char(p_itax_dpnt_rec.aged_dpnts));
407: hr_utility.trace('aged_dpnt_parents_lt : ' || to_char(p_itax_dpnt_rec.aged_dpnt_parents_lt));
408: hr_utility.trace('young_dpnts : ' || to_char(p_itax_dpnt_rec.young_dpnts));
409: hr_utility.trace('minor_dpnts : ' || to_char(p_itax_dpnt_rec.minor_dpnts));
410: hr_utility.trace('dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.dsbl_dpnts));
411: hr_utility.trace('svr_dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts));
412: hr_utility.trace('svr_dsbl_dpnts_lt : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts_lt));

Line 409: hr_utility.trace('minor_dpnts : ' || to_char(p_itax_dpnt_rec.minor_dpnts));

405: hr_utility.trace('dpnts : ' || to_char(p_itax_dpnt_rec.dpnts));
406: hr_utility.trace('aged_dpnts : ' || to_char(p_itax_dpnt_rec.aged_dpnts));
407: hr_utility.trace('aged_dpnt_parents_lt : ' || to_char(p_itax_dpnt_rec.aged_dpnt_parents_lt));
408: hr_utility.trace('young_dpnts : ' || to_char(p_itax_dpnt_rec.young_dpnts));
409: hr_utility.trace('minor_dpnts : ' || to_char(p_itax_dpnt_rec.minor_dpnts));
410: hr_utility.trace('dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.dsbl_dpnts));
411: hr_utility.trace('svr_dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts));
412: hr_utility.trace('svr_dsbl_dpnts_lt : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts_lt));
413: if p_itax_dpnt_rec.multiple_spouses_warning then

Line 410: hr_utility.trace('dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.dsbl_dpnts));

406: hr_utility.trace('aged_dpnts : ' || to_char(p_itax_dpnt_rec.aged_dpnts));
407: hr_utility.trace('aged_dpnt_parents_lt : ' || to_char(p_itax_dpnt_rec.aged_dpnt_parents_lt));
408: hr_utility.trace('young_dpnts : ' || to_char(p_itax_dpnt_rec.young_dpnts));
409: hr_utility.trace('minor_dpnts : ' || to_char(p_itax_dpnt_rec.minor_dpnts));
410: hr_utility.trace('dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.dsbl_dpnts));
411: hr_utility.trace('svr_dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts));
412: hr_utility.trace('svr_dsbl_dpnts_lt : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts_lt));
413: if p_itax_dpnt_rec.multiple_spouses_warning then
414: hr_utility.trace('multiple_spouses_warning : TRUE');

Line 411: hr_utility.trace('svr_dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts));

407: hr_utility.trace('aged_dpnt_parents_lt : ' || to_char(p_itax_dpnt_rec.aged_dpnt_parents_lt));
408: hr_utility.trace('young_dpnts : ' || to_char(p_itax_dpnt_rec.young_dpnts));
409: hr_utility.trace('minor_dpnts : ' || to_char(p_itax_dpnt_rec.minor_dpnts));
410: hr_utility.trace('dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.dsbl_dpnts));
411: hr_utility.trace('svr_dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts));
412: hr_utility.trace('svr_dsbl_dpnts_lt : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts_lt));
413: if p_itax_dpnt_rec.multiple_spouses_warning then
414: hr_utility.trace('multiple_spouses_warning : TRUE');
415: else

Line 412: hr_utility.trace('svr_dsbl_dpnts_lt : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts_lt));

408: hr_utility.trace('young_dpnts : ' || to_char(p_itax_dpnt_rec.young_dpnts));
409: hr_utility.trace('minor_dpnts : ' || to_char(p_itax_dpnt_rec.minor_dpnts));
410: hr_utility.trace('dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.dsbl_dpnts));
411: hr_utility.trace('svr_dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts));
412: hr_utility.trace('svr_dsbl_dpnts_lt : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts_lt));
413: if p_itax_dpnt_rec.multiple_spouses_warning then
414: hr_utility.trace('multiple_spouses_warning : TRUE');
415: else
416: hr_utility.trace('multiple_spouses_warning : FALSE');

Line 414: hr_utility.trace('multiple_spouses_warning : TRUE');

410: hr_utility.trace('dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.dsbl_dpnts));
411: hr_utility.trace('svr_dsbl_dpnts : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts));
412: hr_utility.trace('svr_dsbl_dpnts_lt : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts_lt));
413: if p_itax_dpnt_rec.multiple_spouses_warning then
414: hr_utility.trace('multiple_spouses_warning : TRUE');
415: else
416: hr_utility.trace('multiple_spouses_warning : FALSE');
417: end if;
418: end if;

Line 416: hr_utility.trace('multiple_spouses_warning : FALSE');

412: hr_utility.trace('svr_dsbl_dpnts_lt : ' || to_char(p_itax_dpnt_rec.svr_dsbl_dpnts_lt));
413: if p_itax_dpnt_rec.multiple_spouses_warning then
414: hr_utility.trace('multiple_spouses_warning : TRUE');
415: else
416: hr_utility.trace('multiple_spouses_warning : FALSE');
417: end if;
418: end if;
419: --
420: hr_utility.set_location('Leaving : ' || l_proc, 20);

Line 420: hr_utility.set_location('Leaving : ' || l_proc, 20);

416: hr_utility.trace('multiple_spouses_warning : FALSE');
417: end if;
418: end if;
419: --
420: hr_utility.set_location('Leaving : ' || l_proc, 20);
421: end get_itax_dpnt_info;
422: -- ----------------------------------------------------------------------------
423: -- |--------------< Interface Functions for get_itax_dpnt_info >--------------|
424: -- ----------------------------------------------------------------------------