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);
611: l_description := p_system_description || l_separator || p_user_description;
612: end if;
613: --
614: if length(l_description) > 100 then
615: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DESC_WARN');
616: fnd_message.set_token('ACTION_INFORMATION_ID', null);
617: fnd_message.set_token('EMPLOYEE_NUMBER', null);
618: fnd_message.set_token('FULL_NAME', null);
619: fnd_message.set_token('SWOT_NAME', null);
612: end if;
613: --
614: if length(l_description) > 100 then
615: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DESC_WARN');
616: fnd_message.set_token('ACTION_INFORMATION_ID', null);
617: fnd_message.set_token('EMPLOYEE_NUMBER', null);
618: fnd_message.set_token('FULL_NAME', null);
619: fnd_message.set_token('SWOT_NAME', null);
620: fnd_message.set_token('TAX_TYPE', null);
613: --
614: if length(l_description) > 100 then
615: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DESC_WARN');
616: fnd_message.set_token('ACTION_INFORMATION_ID', null);
617: fnd_message.set_token('EMPLOYEE_NUMBER', null);
618: fnd_message.set_token('FULL_NAME', null);
619: fnd_message.set_token('SWOT_NAME', null);
620: fnd_message.set_token('TAX_TYPE', null);
621: fnd_message.set_token('DESCRIPTION', l_description);
614: if length(l_description) > 100 then
615: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DESC_WARN');
616: fnd_message.set_token('ACTION_INFORMATION_ID', null);
617: fnd_message.set_token('EMPLOYEE_NUMBER', null);
618: fnd_message.set_token('FULL_NAME', null);
619: fnd_message.set_token('SWOT_NAME', null);
620: fnd_message.set_token('TAX_TYPE', null);
621: fnd_message.set_token('DESCRIPTION', l_description);
622: fnd_file.put_line(fnd_file.log, fnd_message.get);
615: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DESC_WARN');
616: fnd_message.set_token('ACTION_INFORMATION_ID', null);
617: fnd_message.set_token('EMPLOYEE_NUMBER', null);
618: fnd_message.set_token('FULL_NAME', null);
619: fnd_message.set_token('SWOT_NAME', null);
620: fnd_message.set_token('TAX_TYPE', null);
621: fnd_message.set_token('DESCRIPTION', l_description);
622: fnd_file.put_line(fnd_file.log, fnd_message.get);
623: end if;
616: fnd_message.set_token('ACTION_INFORMATION_ID', null);
617: fnd_message.set_token('EMPLOYEE_NUMBER', null);
618: fnd_message.set_token('FULL_NAME', null);
619: fnd_message.set_token('SWOT_NAME', null);
620: fnd_message.set_token('TAX_TYPE', null);
621: fnd_message.set_token('DESCRIPTION', l_description);
622: fnd_file.put_line(fnd_file.log, fnd_message.get);
623: end if;
624: end log_description;
617: fnd_message.set_token('EMPLOYEE_NUMBER', null);
618: fnd_message.set_token('FULL_NAME', null);
619: fnd_message.set_token('SWOT_NAME', null);
620: fnd_message.set_token('TAX_TYPE', null);
621: fnd_message.set_token('DESCRIPTION', l_description);
622: fnd_file.put_line(fnd_file.log, fnd_message.get);
623: end if;
624: end log_description;
625: */
618: fnd_message.set_token('FULL_NAME', null);
619: fnd_message.set_token('SWOT_NAME', null);
620: fnd_message.set_token('TAX_TYPE', null);
621: fnd_message.set_token('DESCRIPTION', l_description);
622: fnd_file.put_line(fnd_file.log, fnd_message.get);
623: end if;
624: end log_description;
625: */
626: --
653: else
654: py_rollback_pkg.rollback_ass_action(p_action_context_id);
655: end if;
656: --
657: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DELETED');
658: fnd_message.set_token('ACTION_INFORMATION_ID', p_action_information_id);
659: fnd_message.set_token('EMPLOYEE_NUMBER', null);
660: fnd_message.set_token('FULL_NAME', null);
661: fnd_message.set_token('SWOT_NAME', null);
654: py_rollback_pkg.rollback_ass_action(p_action_context_id);
655: end if;
656: --
657: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DELETED');
658: fnd_message.set_token('ACTION_INFORMATION_ID', p_action_information_id);
659: fnd_message.set_token('EMPLOYEE_NUMBER', null);
660: fnd_message.set_token('FULL_NAME', null);
661: fnd_message.set_token('SWOT_NAME', null);
662: fnd_message.set_token('TAX_TYPE', null);
655: end if;
656: --
657: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DELETED');
658: fnd_message.set_token('ACTION_INFORMATION_ID', p_action_information_id);
659: fnd_message.set_token('EMPLOYEE_NUMBER', null);
660: fnd_message.set_token('FULL_NAME', null);
661: fnd_message.set_token('SWOT_NAME', null);
662: fnd_message.set_token('TAX_TYPE', null);
663: fnd_file.put_line(fnd_file.log, fnd_message.get);
656: --
657: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DELETED');
658: fnd_message.set_token('ACTION_INFORMATION_ID', p_action_information_id);
659: fnd_message.set_token('EMPLOYEE_NUMBER', null);
660: fnd_message.set_token('FULL_NAME', null);
661: fnd_message.set_token('SWOT_NAME', null);
662: fnd_message.set_token('TAX_TYPE', null);
663: fnd_file.put_line(fnd_file.log, fnd_message.get);
664: --
657: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_DELETED');
658: fnd_message.set_token('ACTION_INFORMATION_ID', p_action_information_id);
659: fnd_message.set_token('EMPLOYEE_NUMBER', null);
660: fnd_message.set_token('FULL_NAME', null);
661: fnd_message.set_token('SWOT_NAME', null);
662: fnd_message.set_token('TAX_TYPE', null);
663: fnd_file.put_line(fnd_file.log, fnd_message.get);
664: --
665: end delete_archive;
658: fnd_message.set_token('ACTION_INFORMATION_ID', p_action_information_id);
659: fnd_message.set_token('EMPLOYEE_NUMBER', null);
660: fnd_message.set_token('FULL_NAME', null);
661: fnd_message.set_token('SWOT_NAME', null);
662: fnd_message.set_token('TAX_TYPE', null);
663: fnd_file.put_line(fnd_file.log, fnd_message.get);
664: --
665: end delete_archive;
666: --
659: fnd_message.set_token('EMPLOYEE_NUMBER', null);
660: fnd_message.set_token('FULL_NAME', null);
661: fnd_message.set_token('SWOT_NAME', null);
662: fnd_message.set_token('TAX_TYPE', null);
663: fnd_file.put_line(fnd_file.log, fnd_message.get);
664: --
665: end delete_archive;
666: --
667: BEGIN
799: l_wtm_user_desc_kanji := l_archive_rec.wtm_user_desc_kanji;
800: l_wtm_user_desc_kana := l_archive_rec.wtm_user_desc_kana;
801: /*
802: --
803: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_INHERITED');
804: fnd_message.set_token('ACTION_INFORMATION_ID', null);
805: fnd_message.set_token('EMPLOYEE_NUMBER', null);
806: fnd_message.set_token('FULL_NAME', null);
807: fnd_message.set_token('SWOT_NAME', null);
800: l_wtm_user_desc_kana := l_archive_rec.wtm_user_desc_kana;
801: /*
802: --
803: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_INHERITED');
804: fnd_message.set_token('ACTION_INFORMATION_ID', null);
805: fnd_message.set_token('EMPLOYEE_NUMBER', null);
806: fnd_message.set_token('FULL_NAME', null);
807: fnd_message.set_token('SWOT_NAME', null);
808: fnd_message.set_token('TAX_TYPE', null);
801: /*
802: --
803: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_INHERITED');
804: fnd_message.set_token('ACTION_INFORMATION_ID', null);
805: fnd_message.set_token('EMPLOYEE_NUMBER', null);
806: fnd_message.set_token('FULL_NAME', null);
807: fnd_message.set_token('SWOT_NAME', null);
808: fnd_message.set_token('TAX_TYPE', null);
809: fnd_message.set_token('SRC_ACTION_INFORMATION_ID', null);
802: --
803: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_INHERITED');
804: fnd_message.set_token('ACTION_INFORMATION_ID', null);
805: fnd_message.set_token('EMPLOYEE_NUMBER', null);
806: fnd_message.set_token('FULL_NAME', null);
807: fnd_message.set_token('SWOT_NAME', null);
808: fnd_message.set_token('TAX_TYPE', null);
809: fnd_message.set_token('SRC_ACTION_INFORMATION_ID', null);
810: fnd_file.put_line(fnd_file.log, fnd_message.get);
803: fnd_message.set_name('PAY', 'PAY_JP_ITW_ARCHIVE_INHERITED');
804: fnd_message.set_token('ACTION_INFORMATION_ID', null);
805: fnd_message.set_token('EMPLOYEE_NUMBER', null);
806: fnd_message.set_token('FULL_NAME', null);
807: fnd_message.set_token('SWOT_NAME', null);
808: fnd_message.set_token('TAX_TYPE', null);
809: fnd_message.set_token('SRC_ACTION_INFORMATION_ID', null);
810: fnd_file.put_line(fnd_file.log, fnd_message.get);
811: --
804: fnd_message.set_token('ACTION_INFORMATION_ID', null);
805: fnd_message.set_token('EMPLOYEE_NUMBER', null);
806: fnd_message.set_token('FULL_NAME', null);
807: fnd_message.set_token('SWOT_NAME', null);
808: fnd_message.set_token('TAX_TYPE', null);
809: fnd_message.set_token('SRC_ACTION_INFORMATION_ID', null);
810: fnd_file.put_line(fnd_file.log, fnd_message.get);
811: --
812: */
805: fnd_message.set_token('EMPLOYEE_NUMBER', null);
806: fnd_message.set_token('FULL_NAME', null);
807: fnd_message.set_token('SWOT_NAME', null);
808: fnd_message.set_token('TAX_TYPE', null);
809: fnd_message.set_token('SRC_ACTION_INFORMATION_ID', null);
810: fnd_file.put_line(fnd_file.log, fnd_message.get);
811: --
812: */
813: --
806: fnd_message.set_token('FULL_NAME', null);
807: fnd_message.set_token('SWOT_NAME', null);
808: fnd_message.set_token('TAX_TYPE', null);
809: fnd_message.set_token('SRC_ACTION_INFORMATION_ID', null);
810: fnd_file.put_line(fnd_file.log, fnd_message.get);
811: --
812: */
813: --
814: end if;