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

Line 189: hr_utility.set_location('Entering: ' || c_proc, 10);

185: p_withholding_tax_info out nocopy t_tax_info)
186: is
187: c_proc constant varchar2(61) := c_package || 'get_withholding_tax_info';
188: begin
189: hr_utility.set_location('Entering: ' || c_proc, 10);
190: --
191: if p_itax_yea_category = '0' then
192: hr_utility.set_location(c_proc, 11);
193: --

Line 192: hr_utility.set_location(c_proc, 11);

188: begin
189: hr_utility.set_location('Entering: ' || c_proc, 10);
190: --
191: if p_itax_yea_category = '0' then
192: hr_utility.set_location(c_proc, 11);
193: --
194: -- Grossup "Taxable Earnings", "Income Tax" etc.
195: -- with the same "SWOT".
196: --

Line 215: hr_utility.set_location(c_proc, 12);

211: and action_sequence <= p_action_sequence
212: and effective_date >= trunc(p_effective_date, 'YYYY')
213: and itax_organization_id = p_itax_organization_id;
214: else
215: hr_utility.set_location(c_proc, 12);
216: --
217: -- Grossup "Taxable Earnings", "Income Tax" etc.
218: -- with the same "Tax Category" and "SWOT".
219: --

Line 244: hr_utility.set_location(c_proc, 20);

240: )
241: and itax_organization_id = p_itax_organization_id;
242: end if;
243: --
244: hr_utility.set_location(c_proc, 20);
245: --
246: -- When current assignment_action_id is "YEA",
247: -- add the adjustment amount processed in YEA process.
248: -- Note if future assacts exist after YEA, it is not regarded as YEA,

Line 253: hr_utility.set_location(c_proc, 21);

249: -- it is just normal payment. In this case, no adjustment amount in YEA
250: -- is included to the total amount(Skip when null or '-1').
251: --
252: if p_itax_yea_category <> '-1' then
253: hr_utility.set_location(c_proc, 21);
254: --
255: p_withholding_tax_info.taxable_income := p_withholding_tax_info.taxable_income
256: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.taxable_income_adj_iv, p_assignment_action_id), 0);
257: p_withholding_tax_info.si_prem := p_withholding_tax_info.si_prem

Line 269: hr_utility.set_location('Leaving: ' || c_proc, 100);

265: p_withholding_tax_info.mutual_aid_prem := decode_value(p_withholding_tax_info.mutual_aid_prem <> 0, p_withholding_tax_info.mutual_aid_prem);
266: p_withholding_tax_info.disaster_tax_reduction := decode_value(p_withholding_tax_info.disaster_tax_reduction <> 0, p_withholding_tax_info.disaster_tax_reduction);
267: p_withholding_tax_info.withholding_itax := p_withholding_tax_info.itax + p_withholding_tax_info.itax_adjustment;
268: --
269: hr_utility.set_location('Leaving: ' || c_proc, 100);
270: end get_withholding_tax_info;
271: -- |-------------------------------------------------------------------|
272: -- |-------------------------< get_prev_jobs >-------------------------|
273: -- |-------------------------------------------------------------------|

Line 378: hr_utility.set_location('Entering: ' || c_proc, 10);

374: between piv.effective_start_date and piv.effective_end_date
375: group by pee.element_entry_id
376: order by termination_date desc;
377: begin
378: hr_utility.set_location('Entering: ' || c_proc, 10);
379: --
380: for l_rec in csr_swot loop
381: --
382: -- If the same itax_organization_id exist, existing information is replaced

Line 441: hr_utility.set_location(c_proc, 20);

437: p_prev_jobs(p_prev_jobs.count + 1) := l_prev_job_info;
438: end if;
439: end loop;
440: --
441: hr_utility.set_location(c_proc, 20);
442: --
443: pay_core_utils.get_upgrade_status(
444: P_BUS_GRP_ID => p_business_group_id,
445: P_SHORT_NAME => 'JP_PREV_JOB',

Line 450: hr_utility.set_location(c_proc, 21);

446: P_STATUS => l_upgrade_status,
447: P_RAISE_ERROR => true);
448: --
449: if l_upgrade_status = 'Y' then
450: hr_utility.set_location(c_proc, 21);
451: --
452: for l_rec in csr_job_pem loop
453: l_prev_job_info := null;
454: --

Line 471: hr_utility.set_location(c_proc, 22);

467: --
468: p_prev_jobs(p_prev_jobs.count + 1) := l_prev_job_info;
469: end loop;
470: else
471: hr_utility.set_location(c_proc, 22);
472: --
473: for l_rec in csr_job_pee loop
474: l_prev_job_info := null;
475: --

Line 493: hr_utility.set_location(c_proc, 30);

489: p_prev_jobs(p_prev_jobs.count + 1) := l_prev_job_info;
490: end loop;
491: end if;
492: --
493: hr_utility.set_location(c_proc, 30);
494: --
495: for i in 1..p_prev_jobs.count loop
496: p_prev_jobs(i).mutual_aid_prem := decode_value(p_prev_jobs(i).mutual_aid_prem <> 0, p_prev_jobs(i).mutual_aid_prem);
497: end loop;

Line 499: hr_utility.set_location('Leaving: ' || c_proc, 100);

495: for i in 1..p_prev_jobs.count loop
496: p_prev_jobs(i).mutual_aid_prem := decode_value(p_prev_jobs(i).mutual_aid_prem <> 0, p_prev_jobs(i).mutual_aid_prem);
497: end loop;
498: --
499: hr_utility.set_location('Leaving: ' || c_proc, 100);
500: end get_prev_jobs;
501: --
502: function convert_prev_jobs(p_prev_jobs t_prev_jobs) return t_prev_job_info
503: is

Line 571: hr_utility.set_location('Entering: ' || c_proc, 10);

567: p_submission_required_flag out nocopy varchar2)
568: is
569: c_proc constant varchar2(61) := c_package || 'get_basic_certificate_info (1)';
570: begin
571: hr_utility.set_location('Entering: ' || c_proc, 10);
572: --
573: if p_itax_yea_category = '0' then
574: hr_utility.set_location(c_proc, 21);
575: --

Line 574: hr_utility.set_location(c_proc, 21);

570: begin
571: hr_utility.set_location('Entering: ' || c_proc, 10);
572: --
573: if p_itax_yea_category = '0' then
574: hr_utility.set_location(c_proc, 21);
575: --
576: p_certificate_info.taxable_income := nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.taxable_income_iv, p_assignment_action_id), 0);
577: p_certificate_info.mutual_aid_prem := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id, g_ins_prem_exempt_elm.mutual_aid_prem_iv, p_assignment_action_id), 0);
578: p_certificate_info.mutual_aid_prem := decode_value(p_certificate_info.mutual_aid_prem <> 0, p_certificate_info.mutual_aid_prem);

Line 592: hr_utility.set_location(c_proc, 22);

588: --
589: -- No need to calculate Disaster Tax Reduction in case of YEA because it should be ZERO.
590: --
591: else
592: hr_utility.set_location(c_proc, 22);
593: --
594: -- Derive tax information withheld by current employer.
595: --
596: get_withholding_tax_info(

Line 607: hr_utility.set_location(c_proc, 30);

603: p_itax_yea_category => p_itax_yea_category,
604: p_withholding_tax_info => p_certificate_info);
605: end if;
606: --
607: hr_utility.set_location(c_proc, 30);
608: --
609: -- Check whether this Tax Receipt is required to submit to Tax Office or not.
610: --
611: p_submission_required_flag := 'N';

Line 642: hr_utility.set_location('Leaving: ' || c_proc, 100);

638: end if;
639: end if;
640: end if;
641: --
642: hr_utility.set_location('Leaving: ' || c_proc, 100);
643: end get_basic_certificate_info;
644: --
645: -- Following is deprecated.
646: --

Line 746: hr_utility.set_location('Entering: ' || c_proc, 10);

742: decode(per.sex, 'M', 1, 'F', 2, 3),
743: per.last_name,
744: per.first_name;
745: begin
746: hr_utility.set_location('Entering: ' || c_proc, 10);
747: --
748: if p_itax_category in ('M_KOU', 'M_OTSU', 'D_KOU', 'D_OTSU') then
749: hr_utility.set_location(c_proc, 20);
750: --

Line 749: hr_utility.set_location(c_proc, 20);

745: begin
746: hr_utility.set_location('Entering: ' || c_proc, 10);
747: --
748: if p_itax_category in ('M_KOU', 'M_OTSU', 'D_KOU', 'D_OTSU') then
749: hr_utility.set_location(c_proc, 20);
750: --
751: if p_dpnt_ref_type like 'CEI%' then
752: hr_utility.set_location(c_proc, 21);
753: --

Line 752: hr_utility.set_location(c_proc, 21);

748: if p_itax_category in ('M_KOU', 'M_OTSU', 'D_KOU', 'D_OTSU') then
749: hr_utility.set_location(c_proc, 20);
750: --
751: if p_dpnt_ref_type like 'CEI%' then
752: hr_utility.set_location(c_proc, 21);
753: --
754: -- No need to care for performance issue for multiple calls of the following PL/SQL function.
755: -- The following function caches the output variable result for the same input parameter values.
756: --

Line 774: hr_utility.set_location(c_proc, 22);

770: p_dpnts(l_index).first_name_kanji := l_dpnt_rec.first_name_kanji_tbl(i);
771: p_dpnts(l_index).first_name_kana := l_dpnt_rec.first_name_kana_tbl(i);
772: end loop;
773: else
774: hr_utility.set_location(c_proc, 22);
775: --
776: for l_rec in csr_dep loop
777: l_index := l_index + 1;
778: --

Line 789: hr_utility.set_location('Leaving: ' || c_proc, 100);

785: end loop;
786: end if;
787: end if;
788: --
789: hr_utility.set_location('Leaving: ' || c_proc, 100);
790: end get_dpnts;
791: -- |-------------------------------------------------------------------|
792: -- |----------------------< get_ee_description >-----------------------|
793: -- |-------------------------------------------------------------------|

Line 848: hr_utility.set_location('Entering: ' || c_proc, 10);

844: and p_effective_date
845: between piv.effective_start_date and piv.effective_end_date
846: group by pee.element_entry_id;
847: begin
848: hr_utility.set_location('Entering: ' || c_proc, 10);
849: --
850: open csr_eev;
851: fetch csr_eev into
852: p_itw_override_flag,

Line 865: hr_utility.trace('EE not found.');

861: p_wtm_description3,
862: p_wtm_description4,
863: p_wtm_description5;
864: if csr_eev%notfound then
865: hr_utility.trace('EE not found.');
866: --
867: p_itw_override_flag := 'N';
868: p_itw_description1 := null;
869: p_itw_description2 := null;

Line 882: hr_utility.set_location('Leaving: ' || c_proc, 100);

878: p_wtm_description5 := null;
879: end if;
880: close csr_eev;
881: --
882: hr_utility.set_location('Leaving: ' || c_proc, 100);
883: end get_ee_description;
884: --
885: procedure get_ee_description(
886: p_assignment_id in number,

Line 1056: hr_utility.set_location('Entering: ' || c_proc, 10);

1052: p_length_kanji,
1053: p_length_kana);
1054: end add_np_prem_description;
1055: begin
1056: hr_utility.set_location('Entering: ' || c_proc, 10);
1057: --
1058: -- ************************
1059: -- FIXED_RATE_TAX_REDUCTION
1060: -- NP_PREM

Line 1092: hr_utility.set_location(c_proc, 20);

1088: end if;
1089: end if;
1090: end if;
1091: --
1092: hr_utility.set_location(c_proc, 20);
1093: --
1094: -- ************************
1095: -- DEPENDENT
1096: -- ************************

Line 1131: hr_utility.set_location(c_proc, 30);

1127: l_description_kana,
1128: p_descriptions);
1129: end loop;
1130: --
1131: hr_utility.set_location(c_proc, 30);
1132: --
1133: -- The following information is available only for YEAed assact.
1134: --
1135: if p_itax_yea_category = '0' then

Line 1136: hr_utility.set_location(c_proc, 31);

1132: --
1133: -- The following information is available only for YEAed assact.
1134: --
1135: if p_itax_yea_category = '0' then
1136: hr_utility.set_location(c_proc, 31);
1137: --
1138: -- ************************
1139: -- PREV_JOB
1140: -- ************************

Line 1231: hr_utility.set_location(c_proc, 32);

1227: l_description_kana,
1228: p_descriptions);
1229: end loop;
1230: --
1231: hr_utility.set_location(c_proc, 32);
1232: --
1233: -- ************************
1234: -- HOUSING_TAX_REDUCTION
1235: -- ************************

Line 1294: hr_utility.set_location(c_proc, 33);

1290: l_description_kana,
1291: p_descriptions);
1292: end if;
1293: else
1294: hr_utility.set_location(c_proc, 33);
1295: --
1296: -- ************************
1297: -- DISASTER_TAX_REDUCTION
1298: -- ************************

Line 1315: hr_utility.set_location('Leaving: ' || c_proc, 100);

1311: p_descriptions);
1312: end if;
1313: end if;
1314: --
1315: hr_utility.set_location('Leaving: ' || c_proc, 100);
1316: end get_descriptions;
1317: -- |-------------------------------------------------------------------|
1318: -- |---------------------< get_certificate_info >----------------------|
1319: -- |-------------------------------------------------------------------|

Line 1339: hr_utility.set_location('Entering: ' || c_proc, 10);

1335: p_withholding_tax_info out nocopy t_tax_info)
1336: is
1337: c_proc constant varchar2(61) := c_package || 'get_certificate_info (ITT)';
1338: begin
1339: hr_utility.set_location('Entering: ' || c_proc, 10);
1340: --
1341: get_basic_certificate_info(
1342: p_assignment_action_id => p_assignment_action_id,
1343: p_assignment_id => p_assignment_id,

Line 1353: hr_utility.set_location(c_proc, 20);

1349: p_employment_category => p_employment_category,
1350: p_certificate_info => p_certificate_info,
1351: p_submission_required_flag => p_submission_required_flag);
1352: --
1353: hr_utility.set_location(c_proc, 20);
1354: --
1355: if p_itax_yea_category = '0' then
1356: hr_utility.set_location(c_proc, 21);
1357: --

Line 1356: hr_utility.set_location(c_proc, 21);

1352: --
1353: hr_utility.set_location(c_proc, 20);
1354: --
1355: if p_itax_yea_category = '0' then
1356: hr_utility.set_location(c_proc, 21);
1357: --
1358: --
1359: -- Derive withholding tax information by current employer.
1360: --

Line 1371: hr_utility.set_location(c_proc, 22);

1367: p_itax_category => p_itax_category,
1368: p_itax_yea_category => p_itax_yea_category,
1369: p_withholding_tax_info => p_withholding_tax_info);
1370: else
1371: hr_utility.set_location(c_proc, 22);
1372: --
1373: --
1374: -- For non-YEAed employees, current employer's payment with same tax category
1375: -- are shown in certificates. So just copy p_certificate_info to p_withholding_tax_info.

Line 1380: hr_utility.set_location('Leaving: ' || c_proc, 100);

1376: --
1377: p_withholding_tax_info := p_certificate_info;
1378: end if;
1379: --
1380: hr_utility.set_location('Leaving: ' || c_proc, 100);
1381: end get_certificate_info;
1382: -- |-------------------------------------------------------------------|
1383: -- |---------------------< get_certificate_info >----------------------|
1384: -- |-------------------------------------------------------------------|

Line 1434: hr_utility.set_location('Entering: ' || c_proc, 10);

1430: and ctr.contact_type = 'S'
1431: and p_effective_date
1432: between nvl(ctr.date_start, p_effective_date) and nvl(ctr.date_end, p_effective_date);
1433: begin
1434: hr_utility.set_location('Entering: ' || c_proc, 10);
1435: --
1436: get_basic_certificate_info(
1437: p_assignment_action_id => p_assignment_action_id,
1438: p_assignment_id => p_assignment_id,

Line 1448: hr_utility.set_location(c_proc, 20);

1444: p_employment_category => p_employment_category,
1445: p_certificate_info => p_certificate_info.tax_info,
1446: p_submission_required_flag => p_submission_required_flag);
1447: --
1448: hr_utility.set_location(c_proc, 20);
1449: --
1450: -- The following information is specific only for YEAed assignments.
1451: --
1452: if p_itax_yea_category = '0' then

Line 1453: hr_utility.set_location(c_proc, 21);

1449: --
1450: -- The following information is specific only for YEAed assignments.
1451: --
1452: if p_itax_yea_category = '0' then
1453: hr_utility.set_location(c_proc, 21);
1454: --
1455: p_certificate_info.net_taxable_income := nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.net_taxable_income_iv, p_assignment_action_id), 0);
1456: --
1457: p_certificate_info.spouse_sp_exempt := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id, g_ins_prem_exempt_elm.spouse_sp_exempt_iv, p_assignment_action_id), 0);

Line 1510: hr_utility.set_location(c_proc, 22);

1506: else
1507: p_certificate_info.national_pens_prem := 0;
1508: end if;
1509: --
1510: hr_utility.set_location(c_proc, 22);
1511: --
1512: get_prev_jobs(
1513: p_assignment_id => p_assignment_id,
1514: p_action_sequence => p_action_sequence,

Line 1523: hr_utility.set_location(c_proc, 30);

1519: p_person_id => p_person_id,
1520: p_prev_jobs => p_prev_jobs);
1521: end if;
1522: --
1523: hr_utility.set_location(c_proc, 30);
1524: --
1525: -- Dependents Information
1526: --
1527: if p_itax_category in ('M_KOU', 'M_OTSU', 'D_KOU', 'D_OTSU') then

Line 1529: hr_utility.set_location(c_proc, 31);

1525: -- Dependents Information
1526: --
1527: if p_itax_category in ('M_KOU', 'M_OTSU', 'D_KOU', 'D_OTSU') then
1528: if p_itax_yea_category = '0' then
1529: hr_utility.set_location(c_proc, 31);
1530: --
1531: l_disabled_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id, g_dep_exempt_result_elm.disabled_iv, p_assignment_action_id), '0');
1532: if to_number(to_char(p_effective_date,'YYYY')) < 2005 then
1533: l_aged_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id, g_dep_exempt_result_elm.aged_iv, p_assignment_action_id), '0');

Line 1549: hr_utility.set_location(c_proc, 32);

1545: l_num_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id, g_dep_exempt_result_elm.num_disableds_iv, p_assignment_action_id), 0);
1546: l_num_svr_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id, g_dep_exempt_result_elm.num_svr_disableds_iv, p_assignment_action_id), 0);
1547: l_num_svr_disableds_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id, g_dep_exempt_result_elm.num_svr_disableds_lt_iv, p_assignment_action_id), 0);
1548: else
1549: hr_utility.set_location(c_proc, 32);
1550: --
1551: l_disabled_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.disabled_iv, p_assignment_id, p_date_earned), '0');
1552: if to_number(to_char(p_effective_date,'YYYY')) < 2005 then
1553: l_aged_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.aged_iv, p_assignment_id, p_date_earned), '0');

Line 1576: hr_utility.set_location(c_proc, 33);

1572: -- Here does not do the cross validation for each dependent deduction like FastFormula.
1573: -- This dynamic deriving routine is available when YEA is not processed.
1574: --
1575: if p_dpnt_ref_type = 'CEI' then
1576: hr_utility.set_location(c_proc, 33);
1577: --
1578: if l_spouse_type is null
1579: or l_spouse_disabled_type is null
1580: or l_num_deps is null

Line 1604: hr_utility.set_location(c_proc, 34);

1600: l_num_svr_disableds := nvl(l_num_svr_disableds, l_dpnt_rec.svr_dsbl_dpnts);
1601: l_num_svr_disableds_lt := nvl(l_num_svr_disableds_lt, l_dpnt_rec.svr_dsbl_dpnts_lt);
1602: end if;
1603: else
1604: hr_utility.set_location(c_proc, 34);
1605: --
1606: l_spouse_type := nvl(l_spouse_type, '0');
1607: l_spouse_disabled_type := nvl(l_spouse_disabled_type, '0');
1608: l_num_deps := nvl(l_num_deps, 0);

Line 1618: hr_utility.set_location(c_proc, 34);

1614: l_num_svr_disableds_lt := nvl(l_num_svr_disableds_lt, 0);
1615: end if;
1616: end if;
1617: --
1618: hr_utility.set_location(c_proc, 34);
1619: --
1620: if p_itax_category in ('M_KOU', 'D_KOU') then
1621: hr_utility.set_location(c_proc, 35);
1622: --

Line 1621: hr_utility.set_location(c_proc, 35);

1617: --
1618: hr_utility.set_location(c_proc, 34);
1619: --
1620: if p_itax_category in ('M_KOU', 'D_KOU') then
1621: hr_utility.set_location(c_proc, 35);
1622: --
1623: if l_spouse_type = '2' then
1624: p_certificate_info.dep_spouse_exists_kou := 'Y';
1625: elsif l_spouse_type = '3' then

Line 1689: hr_utility.set_location(c_proc, 36);

1685: if l_working_student_type = '1' then
1686: p_certificate_info.working_student_flag := 'Y';
1687: end if;
1688: elsif p_itax_category in ('M_OTSU', 'D_OTSU') then
1689: hr_utility.set_location(c_proc, 36);
1690: --
1691: if l_spouse_type = '2' then
1692: p_certificate_info.dep_spouse_exists_otsu := 'Y';
1693: elsif l_spouse_type = '3' then

Line 1710: hr_utility.set_location(c_proc, 40);

1706: p_certificate_info.num_deps_otsu := decode_value(p_certificate_info.num_deps_otsu > 0, p_certificate_info.num_deps_otsu);
1707: end if;
1708: end if;
1709: --
1710: hr_utility.set_location(c_proc, 40);
1711: --
1712: -- Husband Exists
1713: --
1714: if to_number(to_char(p_effective_date,'YYYY')) < 2005 then

Line 1761: hr_utility.set_location('Leaving: ' || c_proc, 100);

1757: if pay_jp_balance_pkg.get_entry_value_char(g_itax_info_elm.foreigner_flag_iv, p_assignment_id, p_date_earned) = 'Y' then
1758: p_certificate_info.foreigner_flag := 'Y';
1759: end if;
1760: --
1761: hr_utility.set_location('Leaving: ' || c_proc, 100);
1762: end get_basic_certificate_info;
1763: -- |-------------------------------------------------------------------|
1764: -- |---------------------< get_certificate_info >----------------------|
1765: -- |-------------------------------------------------------------------|

Line 1817: hr_utility.set_location('Entering: ' || c_proc, 10);

1813: end if;
1814: end if;
1815: end concat_description;
1816: begin
1817: hr_utility.set_location('Entering: ' || c_proc, 10);
1818: --
1819: get_basic_certificate_info(
1820: p_assignment_action_id => p_assignment_action_id,
1821: p_assignment_id => p_assignment_id,

Line 1840: hr_utility.set_location(c_proc, 20);

1836: p_certificate_info => p_certificate_info,
1837: p_submission_required_flag => p_submission_required_flag,
1838: p_prev_jobs => p_prev_jobs);
1839: --
1840: hr_utility.set_location(c_proc, 20);
1841: --
1842: -- Get Description information
1843: -- When description on element entry is marked as "Override",
1844: -- subsequent description will be replaced by this.

Line 1855: hr_utility.set_location(c_proc, 30);

1851: p_itw_description => l_itw_description,
1852: p_wtm_override_flag => l_wtm_override_flag,
1853: p_wtm_description => l_wtm_description);
1854: --
1855: hr_utility.set_location(c_proc, 30);
1856: --
1857: if p_magnetic_media_flag = 'Y' then
1858: hr_utility.set_location(c_proc, 31);
1859: --

Line 1858: hr_utility.set_location(c_proc, 31);

1854: --
1855: hr_utility.set_location(c_proc, 30);
1856: --
1857: if p_magnetic_media_flag = 'Y' then
1858: hr_utility.set_location(c_proc, 31);
1859: --
1860: l_override_flag := l_wtm_override_flag;
1861: l_description := l_wtm_description;
1862: l_report_type := WTM;

Line 1864: hr_utility.set_location(c_proc, 32);

1860: l_override_flag := l_wtm_override_flag;
1861: l_description := l_wtm_description;
1862: l_report_type := WTM;
1863: else
1864: hr_utility.set_location(c_proc, 32);
1865: --
1866: l_override_flag := l_itw_override_flag;
1867: l_description := l_itw_description;
1868: l_report_type := ITW;

Line 1871: hr_utility.set_location(c_proc, 40);

1867: l_description := l_itw_description;
1868: l_report_type := ITW;
1869: end if;
1870: --
1871: hr_utility.set_location(c_proc, 40);
1872: --
1873: if l_override_flag = 'Y' then
1874: hr_utility.set_location(c_proc, 41);
1875: --

Line 1874: hr_utility.set_location(c_proc, 41);

1870: --
1871: hr_utility.set_location(c_proc, 40);
1872: --
1873: if l_override_flag = 'Y' then
1874: hr_utility.set_location(c_proc, 41);
1875: --
1876: p_certificate_info.description_kanji := l_description;
1877: p_certificate_info.description_kana := hr_jp_standard_pkg.to_hankaku(l_description);
1878: else

Line 1879: hr_utility.set_location(c_proc, 42);

1875: --
1876: p_certificate_info.description_kanji := l_description;
1877: p_certificate_info.description_kana := hr_jp_standard_pkg.to_hankaku(l_description);
1878: else
1879: hr_utility.set_location(c_proc, 42);
1880: --
1881: get_dpnts(
1882: p_dpnt_ref_type => p_dpnt_ref_type,
1883: p_assignment_id => p_assignment_id,

Line 1891: hr_utility.set_location(c_proc, 43);

1887: p_effective_date => p_effective_date,
1888: p_sex => p_sex,
1889: p_dpnts => l_dpnts);
1890: --
1891: hr_utility.set_location(c_proc, 43);
1892: --
1893: get_descriptions(
1894: p_assignment_id => p_assignment_id,
1895: p_person_id => p_person_id,

Line 1906: hr_utility.set_location(c_proc, 44);

1902: p_prev_jobs => p_prev_jobs,
1903: p_report_type => l_report_type,
1904: p_descriptions => l_descriptions);
1905: --
1906: hr_utility.set_location(c_proc, 44);
1907: --
1908: -- Construct Description field.
1909: --
1910: for i in 1..l_descriptions.count loop

Line 1911: hr_utility.set_location(c_proc, 45);

1907: --
1908: -- Construct Description field.
1909: --
1910: for i in 1..l_descriptions.count loop
1911: hr_utility.set_location(c_proc, 45);
1912: --
1913: if p_magnetic_media_flag = 'Y' then
1914: concat_description(l_descriptions(i).description_kanji, p_certificate_info.description_kanji, ',');
1915: concat_description(l_descriptions(i).description_kana, p_certificate_info.description_kana, ',');

Line 1931: hr_utility.set_location('Leaving: ' || c_proc, 100);

1927: concat_description(l_description, p_certificate_info.description_kanji, ',');
1928: concat_description(hr_jp_standard_pkg.to_hankaku(l_description), p_certificate_info.description_kana, ',');
1929: end if;
1930: --
1931: hr_utility.set_location('Leaving: ' || c_proc, 100);
1932: end get_certificate_info;
1933: --
1934: procedure get_certificate_info(
1935: p_assignment_action_id in number,

Line 2024: hr_utility.set_location('Entering: ' || c_proc, 10);

2020: l_wtm_description varchar2(300);
2021: l_dpnts t_dpnts;
2022: l_descriptions t_descriptions;
2023: begin
2024: hr_utility.set_location('Entering: ' || c_proc, 10);
2025: --
2026: get_certificate_info(
2027: p_assignment_action_id => p_assignment_action_id,
2028: p_assignment_id => p_assignment_id,

Line 2050: hr_utility.set_location(c_proc, 20);

2046: p_certificate_info => p_certificate_info,
2047: p_submission_required_flag => p_submission_required_flag,
2048: p_prev_jobs => p_prev_jobs);
2049: --
2050: hr_utility.set_location(c_proc, 20);
2051: --
2052: if p_itax_yea_category = '0' then
2053: hr_utility.set_location(c_proc, 21);
2054: --

Line 2053: hr_utility.set_location(c_proc, 21);

2049: --
2050: hr_utility.set_location(c_proc, 20);
2051: --
2052: if p_itax_yea_category = '0' then
2053: hr_utility.set_location(c_proc, 21);
2054: --
2055: -- Derive withholding tax information by current employer.
2056: --
2057: get_withholding_tax_info(

Line 2067: hr_utility.set_location(c_proc, 22);

2063: p_itax_category => p_itax_category,
2064: p_itax_yea_category => p_itax_yea_category,
2065: p_withholding_tax_info => p_withholding_tax_info);
2066: else
2067: hr_utility.set_location(c_proc, 22);
2068: --
2069: -- For non-YEAed employees, current employer's payment with same tax category
2070: -- are shown in certificates. So just copy p_certificate_info to p_withholding_tax_info.
2071: --

Line 2075: hr_utility.set_location('Leaving: ' || c_proc, 100);

2071: --
2072: p_withholding_tax_info := p_certificate_info.tax_info;
2073: end if;
2074: --
2075: hr_utility.set_location('Leaving: ' || c_proc, 100);
2076: end get_certificate_info;
2077: -- |-------------------------------------------------------------------|
2078: -- |---------------------< get_certificate_info >----------------------|
2079: -- |-------------------------------------------------------------------|

Line 2115: hr_utility.set_location('Entering: ' || c_proc, 10);

2111: l_prev_jobs t_prev_jobs;
2112: l_itw_override_flag varchar2(1);
2113: l_wtm_override_flag varchar2(1);
2114: begin
2115: hr_utility.set_location('Entering: ' || c_proc, 10);
2116: --
2117: get_basic_certificate_info(
2118: p_assignment_action_id => p_assignment_action_id,
2119: p_assignment_id => p_assignment_id,

Line 2138: hr_utility.set_location(c_proc, 20);

2134: p_certificate_info => p_certificate_info,
2135: p_submission_required_flag => p_submission_required_flag,
2136: p_prev_jobs => l_prev_jobs);
2137: --
2138: hr_utility.set_location(c_proc, 20);
2139: --
2140: p_prev_job_info := convert_prev_jobs(l_prev_jobs);
2141: --
2142: hr_utility.set_location(c_proc, 30);

Line 2142: hr_utility.set_location(c_proc, 30);

2138: hr_utility.set_location(c_proc, 20);
2139: --
2140: p_prev_job_info := convert_prev_jobs(l_prev_jobs);
2141: --
2142: hr_utility.set_location(c_proc, 30);
2143: --
2144: if p_itax_yea_category = '0' then
2145: --
2146: -- Derive withholding tax information by current employer.

Line 2165: hr_utility.set_location(c_proc, 40);

2161: --
2162: p_withholding_tax_info := p_certificate_info.tax_info;
2163: end if;
2164: --
2165: hr_utility.set_location(c_proc, 40);
2166: --
2167: -- Get Description information
2168: -- When description on element entry is marked as "Override",
2169: -- subsequent description will be replaced by this.

Line 2180: hr_utility.set_location(c_proc, 50);

2176: p_itw_description => p_itw_description,
2177: p_wtm_override_flag => l_wtm_override_flag,
2178: p_wtm_description => p_wtm_description);
2179: --
2180: hr_utility.set_location(c_proc, 50);
2181: --
2182: if l_itw_override_flag = 'N' or l_wtm_override_flag = 'N' then
2183: hr_utility.set_location(c_proc, 51);
2184: --

Line 2183: hr_utility.set_location(c_proc, 51);

2179: --
2180: hr_utility.set_location(c_proc, 50);
2181: --
2182: if l_itw_override_flag = 'N' or l_wtm_override_flag = 'N' then
2183: hr_utility.set_location(c_proc, 51);
2184: --
2185: get_dpnts(
2186: p_dpnt_ref_type => p_dpnt_ref_type,
2187: p_assignment_id => p_assignment_id,

Line 2195: hr_utility.set_location(c_proc, 52);

2191: p_effective_date => p_effective_date,
2192: p_sex => p_sex,
2193: p_dpnts => l_dpnts);
2194: --
2195: hr_utility.set_location(c_proc, 52);
2196: --
2197: if l_itw_override_flag = 'N' then
2198: hr_utility.set_location(c_proc, 53);
2199: --

Line 2198: hr_utility.set_location(c_proc, 53);

2194: --
2195: hr_utility.set_location(c_proc, 52);
2196: --
2197: if l_itw_override_flag = 'N' then
2198: hr_utility.set_location(c_proc, 53);
2199: --
2200: get_descriptions(
2201: p_assignment_id => p_assignment_id,
2202: p_person_id => p_person_id,

Line 2215: hr_utility.set_location(c_proc, 54);

2211: p_descriptions => p_itw_descriptions);
2212: end if;
2213: --
2214: if l_wtm_override_flag = 'N' then
2215: hr_utility.set_location(c_proc, 54);
2216: --
2217: get_descriptions(
2218: p_assignment_id => p_assignment_id,
2219: p_person_id => p_person_id,

Line 2231: hr_utility.set_location(c_proc, 55);

2227: p_report_type => WTM,
2228: p_descriptions => p_wtm_descriptions);
2229: end if;
2230: --
2231: hr_utility.set_location(c_proc, 55);
2232: end if;
2233: --
2234: hr_utility.set_location('Leaving: ' || c_proc, 100);
2235: end get_certificate_info;

Line 2234: hr_utility.set_location('Leaving: ' || c_proc, 100);

2230: --
2231: hr_utility.set_location(c_proc, 55);
2232: end if;
2233: --
2234: hr_utility.set_location('Leaving: ' || c_proc, 100);
2235: end get_certificate_info;
2236: --
2237: -- |-------------------------------------------------------------------|
2238: -- |---------------------< set_valid_term_taxable_amt >----------------|

Line 2277: hr_utility.set_message(800,'HR_7914_CHECK_FMT_NUMBER');

2273: --
2274: if p_termination_date is not null then
2275: --
2276: if pay_jp_wic_pkg.g_valid_term_taxable_amt is null then
2277: hr_utility.set_message(800,'HR_7914_CHECK_FMT_NUMBER');
2278: hr_utility.set_message_token('ARG_NAME','pay_jp_wic_pkg.g_valid_term_taxable_amt');
2279: hr_utility.set_message_token('ARG_VALUE','pay_jp_wic_pkg.g_valid_term_taxable_amt');
2280: hr_utility.raise_error;
2281: end if;

Line 2278: hr_utility.set_message_token('ARG_NAME','pay_jp_wic_pkg.g_valid_term_taxable_amt');

2274: if p_termination_date is not null then
2275: --
2276: if pay_jp_wic_pkg.g_valid_term_taxable_amt is null then
2277: hr_utility.set_message(800,'HR_7914_CHECK_FMT_NUMBER');
2278: hr_utility.set_message_token('ARG_NAME','pay_jp_wic_pkg.g_valid_term_taxable_amt');
2279: hr_utility.set_message_token('ARG_VALUE','pay_jp_wic_pkg.g_valid_term_taxable_amt');
2280: hr_utility.raise_error;
2281: end if;
2282: --

Line 2279: hr_utility.set_message_token('ARG_VALUE','pay_jp_wic_pkg.g_valid_term_taxable_amt');

2275: --
2276: if pay_jp_wic_pkg.g_valid_term_taxable_amt is null then
2277: hr_utility.set_message(800,'HR_7914_CHECK_FMT_NUMBER');
2278: hr_utility.set_message_token('ARG_NAME','pay_jp_wic_pkg.g_valid_term_taxable_amt');
2279: hr_utility.set_message_token('ARG_VALUE','pay_jp_wic_pkg.g_valid_term_taxable_amt');
2280: hr_utility.raise_error;
2281: end if;
2282: --
2283: if p_certificate_info.tax_info.taxable_income is null then

Line 2280: hr_utility.raise_error;

2276: if pay_jp_wic_pkg.g_valid_term_taxable_amt is null then
2277: hr_utility.set_message(800,'HR_7914_CHECK_FMT_NUMBER');
2278: hr_utility.set_message_token('ARG_NAME','pay_jp_wic_pkg.g_valid_term_taxable_amt');
2279: hr_utility.set_message_token('ARG_VALUE','pay_jp_wic_pkg.g_valid_term_taxable_amt');
2280: hr_utility.raise_error;
2281: end if;
2282: --
2283: if p_certificate_info.tax_info.taxable_income is null then
2284: --

Line 2630: -- hr_utility.trace_on('F', 'TTAGAWA');

2626: --
2627: g_yea_ins_prem_sp_exm_info_elm.element_type_id := hr_jp_id_pkg.element_type_id('YEA_INS_PREM_SPOUSE_SP_EXM_INFO',null,'JP');
2628: g_yea_ins_prem_sp_exm_info_elm.national_pens_prem_iv := hr_jp_id_pkg.input_value_id(g_yea_ins_prem_sp_exm_info_elm.element_type_id,'NATIONAL_PENSION_PREM');
2629: --
2630: -- hr_utility.trace_on('F', 'TTAGAWA');
2631: end pay_jp_wic_pkg;