7: c_checked CONSTANT VARCHAR2(2) := '*';
8: --
9: -- Global Variables
10: --
11: g_old_fixed_rate_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_YEA_FIXED_RATE');
12: g_old_fixed_rate_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_YEA_FIXED_RATE_KANA');
13: g_old_national_pens_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_NATIONAL_PENSION');
14: g_old_national_pens_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_NATIONAL_PENSION_KANA');
15: g_new_fixed_rate_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_FIXED_RATE');
8: --
9: -- Global Variables
10: --
11: g_old_fixed_rate_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_YEA_FIXED_RATE');
12: g_old_fixed_rate_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_YEA_FIXED_RATE_KANA');
13: g_old_national_pens_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_NATIONAL_PENSION');
14: g_old_national_pens_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_NATIONAL_PENSION_KANA');
15: g_new_fixed_rate_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_FIXED_RATE');
16: g_new_fixed_rate_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_FIXED_RATE_KANA');
9: -- Global Variables
10: --
11: g_old_fixed_rate_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_YEA_FIXED_RATE');
12: g_old_fixed_rate_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_YEA_FIXED_RATE_KANA');
13: g_old_national_pens_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_NATIONAL_PENSION');
14: g_old_national_pens_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_NATIONAL_PENSION_KANA');
15: g_new_fixed_rate_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_FIXED_RATE');
16: g_new_fixed_rate_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_FIXED_RATE_KANA');
17: g_new_national_pens_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_NATIONAL_PENSION');
10: --
11: g_old_fixed_rate_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_YEA_FIXED_RATE');
12: g_old_fixed_rate_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_YEA_FIXED_RATE_KANA');
13: g_old_national_pens_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_NATIONAL_PENSION');
14: g_old_national_pens_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_NATIONAL_PENSION_KANA');
15: g_new_fixed_rate_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_FIXED_RATE');
16: g_new_fixed_rate_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_FIXED_RATE_KANA');
17: g_new_national_pens_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_NATIONAL_PENSION');
18: g_new_national_pens_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_NATIONAL_PENS_KANA');
11: g_old_fixed_rate_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_YEA_FIXED_RATE');
12: g_old_fixed_rate_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_YEA_FIXED_RATE_KANA');
13: g_old_national_pens_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_NATIONAL_PENSION');
14: g_old_national_pens_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_NATIONAL_PENSION_KANA');
15: g_new_fixed_rate_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_FIXED_RATE');
16: g_new_fixed_rate_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_FIXED_RATE_KANA');
17: g_new_national_pens_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_NATIONAL_PENSION');
18: g_new_national_pens_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_NATIONAL_PENS_KANA');
19: --
12: g_old_fixed_rate_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_YEA_FIXED_RATE_KANA');
13: g_old_national_pens_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_NATIONAL_PENSION');
14: g_old_national_pens_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_NATIONAL_PENSION_KANA');
15: g_new_fixed_rate_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_FIXED_RATE');
16: g_new_fixed_rate_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_FIXED_RATE_KANA');
17: g_new_national_pens_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_NATIONAL_PENSION');
18: g_new_national_pens_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_NATIONAL_PENS_KANA');
19: --
20: g_payroll_action_id number;
13: g_old_national_pens_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_NATIONAL_PENSION');
14: g_old_national_pens_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_NATIONAL_PENSION_KANA');
15: g_new_fixed_rate_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_FIXED_RATE');
16: g_new_fixed_rate_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_FIXED_RATE_KANA');
17: g_new_national_pens_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_NATIONAL_PENSION');
18: g_new_national_pens_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_NATIONAL_PENS_KANA');
19: --
20: g_payroll_action_id number;
21: g_business_group_id number;
14: g_old_national_pens_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_NATIONAL_PENSION_KANA');
15: g_new_fixed_rate_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_FIXED_RATE');
16: g_new_fixed_rate_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_FIXED_RATE_KANA');
17: g_new_national_pens_kanji VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_NATIONAL_PENSION');
18: g_new_national_pens_kana VARCHAR2(80) := fnd_message.get_string('PAY', 'PAY_JP_ITAX_NATIONAL_PENS_KANA');
19: --
20: g_payroll_action_id number;
21: g_business_group_id number;
22: g_bg_dpnt_ref_type varchar2(30);
600: l_description := p_system_description || l_separator || p_user_description;
601: end if;
602: --
603: if length(l_description) > 100 then
604: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DESC_WARN');
605: fnd_message.set_token('ACTION_INFORMATION_ID', null);
606: fnd_message.set_token('EMPLOYEE_NUMBER', null);
607: fnd_message.set_token('FULL_NAME', null);
608: fnd_message.set_token('SWOT_NAME', null);
601: end if;
602: --
603: if length(l_description) > 100 then
604: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DESC_WARN');
605: fnd_message.set_token('ACTION_INFORMATION_ID', null);
606: fnd_message.set_token('EMPLOYEE_NUMBER', null);
607: fnd_message.set_token('FULL_NAME', null);
608: fnd_message.set_token('SWOT_NAME', null);
609: fnd_message.set_token('TAX_TYPE', null);
602: --
603: if length(l_description) > 100 then
604: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DESC_WARN');
605: fnd_message.set_token('ACTION_INFORMATION_ID', null);
606: fnd_message.set_token('EMPLOYEE_NUMBER', null);
607: fnd_message.set_token('FULL_NAME', null);
608: fnd_message.set_token('SWOT_NAME', null);
609: fnd_message.set_token('TAX_TYPE', null);
610: fnd_message.set_token('DESCRIPTION', l_description);
603: if length(l_description) > 100 then
604: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DESC_WARN');
605: fnd_message.set_token('ACTION_INFORMATION_ID', null);
606: fnd_message.set_token('EMPLOYEE_NUMBER', null);
607: fnd_message.set_token('FULL_NAME', null);
608: fnd_message.set_token('SWOT_NAME', null);
609: fnd_message.set_token('TAX_TYPE', null);
610: fnd_message.set_token('DESCRIPTION', l_description);
611: fnd_file.put_line(fnd_file.log, fnd_message.get);
604: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DESC_WARN');
605: fnd_message.set_token('ACTION_INFORMATION_ID', null);
606: fnd_message.set_token('EMPLOYEE_NUMBER', null);
607: fnd_message.set_token('FULL_NAME', null);
608: fnd_message.set_token('SWOT_NAME', null);
609: fnd_message.set_token('TAX_TYPE', null);
610: fnd_message.set_token('DESCRIPTION', l_description);
611: fnd_file.put_line(fnd_file.log, fnd_message.get);
612: end if;
605: fnd_message.set_token('ACTION_INFORMATION_ID', null);
606: fnd_message.set_token('EMPLOYEE_NUMBER', null);
607: fnd_message.set_token('FULL_NAME', null);
608: fnd_message.set_token('SWOT_NAME', null);
609: fnd_message.set_token('TAX_TYPE', null);
610: fnd_message.set_token('DESCRIPTION', l_description);
611: fnd_file.put_line(fnd_file.log, fnd_message.get);
612: end if;
613: end log_description;
606: fnd_message.set_token('EMPLOYEE_NUMBER', null);
607: fnd_message.set_token('FULL_NAME', null);
608: fnd_message.set_token('SWOT_NAME', null);
609: fnd_message.set_token('TAX_TYPE', null);
610: fnd_message.set_token('DESCRIPTION', l_description);
611: fnd_file.put_line(fnd_file.log, fnd_message.get);
612: end if;
613: end log_description;
614: */
607: fnd_message.set_token('FULL_NAME', null);
608: fnd_message.set_token('SWOT_NAME', null);
609: fnd_message.set_token('TAX_TYPE', null);
610: fnd_message.set_token('DESCRIPTION', l_description);
611: fnd_file.put_line(fnd_file.log, fnd_message.get);
612: end if;
613: end log_description;
614: */
615: --
642: else
643: py_rollback_pkg.rollback_ass_action(p_action_context_id);
644: end if;
645: --
646: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DELETED');
647: fnd_message.set_token('ACTION_INFORMATION_ID', p_action_information_id);
648: fnd_message.set_token('EMPLOYEE_NUMBER', null);
649: fnd_message.set_token('FULL_NAME', null);
650: fnd_message.set_token('SWOT_NAME', null);
643: py_rollback_pkg.rollback_ass_action(p_action_context_id);
644: end if;
645: --
646: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DELETED');
647: fnd_message.set_token('ACTION_INFORMATION_ID', p_action_information_id);
648: fnd_message.set_token('EMPLOYEE_NUMBER', null);
649: fnd_message.set_token('FULL_NAME', null);
650: fnd_message.set_token('SWOT_NAME', null);
651: fnd_message.set_token('TAX_TYPE', null);
644: end if;
645: --
646: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DELETED');
647: fnd_message.set_token('ACTION_INFORMATION_ID', p_action_information_id);
648: fnd_message.set_token('EMPLOYEE_NUMBER', null);
649: fnd_message.set_token('FULL_NAME', null);
650: fnd_message.set_token('SWOT_NAME', null);
651: fnd_message.set_token('TAX_TYPE', null);
652: fnd_file.put_line(fnd_file.log, fnd_message.get);
645: --
646: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DELETED');
647: fnd_message.set_token('ACTION_INFORMATION_ID', p_action_information_id);
648: fnd_message.set_token('EMPLOYEE_NUMBER', null);
649: fnd_message.set_token('FULL_NAME', null);
650: fnd_message.set_token('SWOT_NAME', null);
651: fnd_message.set_token('TAX_TYPE', null);
652: fnd_file.put_line(fnd_file.log, fnd_message.get);
653: end delete_archive;
646: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DELETED');
647: fnd_message.set_token('ACTION_INFORMATION_ID', p_action_information_id);
648: fnd_message.set_token('EMPLOYEE_NUMBER', null);
649: fnd_message.set_token('FULL_NAME', null);
650: fnd_message.set_token('SWOT_NAME', null);
651: fnd_message.set_token('TAX_TYPE', null);
652: fnd_file.put_line(fnd_file.log, fnd_message.get);
653: end delete_archive;
654: BEGIN
647: fnd_message.set_token('ACTION_INFORMATION_ID', p_action_information_id);
648: fnd_message.set_token('EMPLOYEE_NUMBER', null);
649: fnd_message.set_token('FULL_NAME', null);
650: fnd_message.set_token('SWOT_NAME', null);
651: fnd_message.set_token('TAX_TYPE', null);
652: fnd_file.put_line(fnd_file.log, fnd_message.get);
653: end delete_archive;
654: BEGIN
655: hr_utility.set_location('Entering: ' || c_proc, 10);
648: fnd_message.set_token('EMPLOYEE_NUMBER', null);
649: fnd_message.set_token('FULL_NAME', null);
650: fnd_message.set_token('SWOT_NAME', null);
651: fnd_message.set_token('TAX_TYPE', null);
652: fnd_file.put_line(fnd_file.log, fnd_message.get);
653: end delete_archive;
654: BEGIN
655: hr_utility.set_location('Entering: ' || c_proc, 10);
656: --
776: l_wtm_user_desc_kanji := l_archive_rec.wtm_user_desc_kanji;
777: l_wtm_user_desc_kana := l_archive_rec.wtm_user_desc_kana;
778: /*
779: --
780: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_INHERITED');
781: fnd_message.set_token('ACTION_INFORMATION_ID', null);
782: fnd_message.set_token('EMPLOYEE_NUMBER', null);
783: fnd_message.set_token('FULL_NAME', null);
784: fnd_message.set_token('SWOT_NAME', null);
777: l_wtm_user_desc_kana := l_archive_rec.wtm_user_desc_kana;
778: /*
779: --
780: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_INHERITED');
781: fnd_message.set_token('ACTION_INFORMATION_ID', null);
782: fnd_message.set_token('EMPLOYEE_NUMBER', null);
783: fnd_message.set_token('FULL_NAME', null);
784: fnd_message.set_token('SWOT_NAME', null);
785: fnd_message.set_token('TAX_TYPE', null);
778: /*
779: --
780: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_INHERITED');
781: fnd_message.set_token('ACTION_INFORMATION_ID', null);
782: fnd_message.set_token('EMPLOYEE_NUMBER', null);
783: fnd_message.set_token('FULL_NAME', null);
784: fnd_message.set_token('SWOT_NAME', null);
785: fnd_message.set_token('TAX_TYPE', null);
786: fnd_message.set_token('SRC_ACTION_INFORMATION_ID', null);
779: --
780: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_INHERITED');
781: fnd_message.set_token('ACTION_INFORMATION_ID', null);
782: fnd_message.set_token('EMPLOYEE_NUMBER', null);
783: fnd_message.set_token('FULL_NAME', null);
784: fnd_message.set_token('SWOT_NAME', null);
785: fnd_message.set_token('TAX_TYPE', null);
786: fnd_message.set_token('SRC_ACTION_INFORMATION_ID', null);
787: fnd_file.put_line(fnd_file.log, fnd_message.get);
780: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_INHERITED');
781: fnd_message.set_token('ACTION_INFORMATION_ID', null);
782: fnd_message.set_token('EMPLOYEE_NUMBER', null);
783: fnd_message.set_token('FULL_NAME', null);
784: fnd_message.set_token('SWOT_NAME', null);
785: fnd_message.set_token('TAX_TYPE', null);
786: fnd_message.set_token('SRC_ACTION_INFORMATION_ID', null);
787: fnd_file.put_line(fnd_file.log, fnd_message.get);
788: */
781: fnd_message.set_token('ACTION_INFORMATION_ID', null);
782: fnd_message.set_token('EMPLOYEE_NUMBER', null);
783: fnd_message.set_token('FULL_NAME', null);
784: fnd_message.set_token('SWOT_NAME', null);
785: fnd_message.set_token('TAX_TYPE', null);
786: fnd_message.set_token('SRC_ACTION_INFORMATION_ID', null);
787: fnd_file.put_line(fnd_file.log, fnd_message.get);
788: */
789: end if;
782: fnd_message.set_token('EMPLOYEE_NUMBER', null);
783: fnd_message.set_token('FULL_NAME', null);
784: fnd_message.set_token('SWOT_NAME', null);
785: fnd_message.set_token('TAX_TYPE', null);
786: fnd_message.set_token('SRC_ACTION_INFORMATION_ID', null);
787: fnd_file.put_line(fnd_file.log, fnd_message.get);
788: */
789: end if;
790: --
783: fnd_message.set_token('FULL_NAME', null);
784: fnd_message.set_token('SWOT_NAME', null);
785: fnd_message.set_token('TAX_TYPE', null);
786: fnd_message.set_token('SRC_ACTION_INFORMATION_ID', null);
787: fnd_file.put_line(fnd_file.log, fnd_message.get);
788: */
789: end if;
790: --
791: delete_archive(