64: fetch csr_pact into l_csr_pact;
65: close csr_pact;
66: --
67: if l_csr_pact.submission_period_status = 'C' then
68: fnd_message.set_name('PAY','PAY_JP_DEF_PERIOD_CLOSED');
69: fnd_message.raise_error;
70: end if;
71: --
72: l_submission_date := sysdate;
65: close csr_pact;
66: --
67: if l_csr_pact.submission_period_status = 'C' then
68: fnd_message.set_name('PAY','PAY_JP_DEF_PERIOD_CLOSED');
69: fnd_message.raise_error;
70: end if;
71: --
72: l_submission_date := sysdate;
73: --
71: --
72: l_submission_date := sysdate;
73: --
74: if l_submission_date < nvl(l_csr_pact.submission_start_date,l_submission_date) then
75: fnd_message.set_name('PAY','PAY_JP_DEF_PERIOD_NOT_STARTED');
76: fnd_message.raise_error;
77: end if;
78: --
79: if l_submission_date > nvl(l_csr_pact.submission_end_date,l_submission_date) then
72: l_submission_date := sysdate;
73: --
74: if l_submission_date < nvl(l_csr_pact.submission_start_date,l_submission_date) then
75: fnd_message.set_name('PAY','PAY_JP_DEF_PERIOD_NOT_STARTED');
76: fnd_message.raise_error;
77: end if;
78: --
79: if l_submission_date > nvl(l_csr_pact.submission_end_date,l_submission_date) then
80: fnd_message.set_name('PAY','PAY_JP_DEF_PERIOD_EXPIRED');
76: fnd_message.raise_error;
77: end if;
78: --
79: if l_submission_date > nvl(l_csr_pact.submission_end_date,l_submission_date) then
80: fnd_message.set_name('PAY','PAY_JP_DEF_PERIOD_EXPIRED');
81: fnd_message.raise_error;
82: end if;
83: --
84: return l_submission_date;
77: end if;
78: --
79: if l_submission_date > nvl(l_csr_pact.submission_end_date,l_submission_date) then
80: fnd_message.set_name('PAY','PAY_JP_DEF_PERIOD_EXPIRED');
81: fnd_message.raise_error;
82: end if;
83: --
84: return l_submission_date;
85: --
742: g_sp_calc_dct9 := to_char(to_number(g_sp_calc_dct9),fnd_currency.get_format_mask('JPY',40));
743: --
744: end if;
745: --
746: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
747: fnd_message.set_token('RANGE_B',g_life_range1b);
748: g_msg_life_range1 := fnd_message.get;
749: --
750: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
743: --
744: end if;
745: --
746: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
747: fnd_message.set_token('RANGE_B',g_life_range1b);
748: g_msg_life_range1 := fnd_message.get;
749: --
750: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
751: fnd_message.set_token('RANGE_A',g_life_range2a);
744: end if;
745: --
746: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
747: fnd_message.set_token('RANGE_B',g_life_range1b);
748: g_msg_life_range1 := fnd_message.get;
749: --
750: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
751: fnd_message.set_token('RANGE_A',g_life_range2a);
752: fnd_message.set_token('RANGE_B',g_life_range2b);
746: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
747: fnd_message.set_token('RANGE_B',g_life_range1b);
748: g_msg_life_range1 := fnd_message.get;
749: --
750: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
751: fnd_message.set_token('RANGE_A',g_life_range2a);
752: fnd_message.set_token('RANGE_B',g_life_range2b);
753: g_msg_life_range2 := fnd_message.get;
754: --
747: fnd_message.set_token('RANGE_B',g_life_range1b);
748: g_msg_life_range1 := fnd_message.get;
749: --
750: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
751: fnd_message.set_token('RANGE_A',g_life_range2a);
752: fnd_message.set_token('RANGE_B',g_life_range2b);
753: g_msg_life_range2 := fnd_message.get;
754: --
755: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
748: g_msg_life_range1 := fnd_message.get;
749: --
750: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
751: fnd_message.set_token('RANGE_A',g_life_range2a);
752: fnd_message.set_token('RANGE_B',g_life_range2b);
753: g_msg_life_range2 := fnd_message.get;
754: --
755: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
756: fnd_message.set_token('RANGE_A',g_life_range3a);
749: --
750: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
751: fnd_message.set_token('RANGE_A',g_life_range2a);
752: fnd_message.set_token('RANGE_B',g_life_range2b);
753: g_msg_life_range2 := fnd_message.get;
754: --
755: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
756: fnd_message.set_token('RANGE_A',g_life_range3a);
757: fnd_message.set_token('RANGE_B',g_life_range3b);
751: fnd_message.set_token('RANGE_A',g_life_range2a);
752: fnd_message.set_token('RANGE_B',g_life_range2b);
753: g_msg_life_range2 := fnd_message.get;
754: --
755: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
756: fnd_message.set_token('RANGE_A',g_life_range3a);
757: fnd_message.set_token('RANGE_B',g_life_range3b);
758: g_msg_life_range3 := fnd_message.get;
759: --
752: fnd_message.set_token('RANGE_B',g_life_range2b);
753: g_msg_life_range2 := fnd_message.get;
754: --
755: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
756: fnd_message.set_token('RANGE_A',g_life_range3a);
757: fnd_message.set_token('RANGE_B',g_life_range3b);
758: g_msg_life_range3 := fnd_message.get;
759: --
760: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
753: g_msg_life_range2 := fnd_message.get;
754: --
755: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
756: fnd_message.set_token('RANGE_A',g_life_range3a);
757: fnd_message.set_token('RANGE_B',g_life_range3b);
758: g_msg_life_range3 := fnd_message.get;
759: --
760: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
761: fnd_message.set_token('RANGE_A',g_life_range4a);
754: --
755: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
756: fnd_message.set_token('RANGE_A',g_life_range3a);
757: fnd_message.set_token('RANGE_B',g_life_range3b);
758: g_msg_life_range3 := fnd_message.get;
759: --
760: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
761: fnd_message.set_token('RANGE_A',g_life_range4a);
762: g_msg_life_range4 := fnd_message.get;
756: fnd_message.set_token('RANGE_A',g_life_range3a);
757: fnd_message.set_token('RANGE_B',g_life_range3b);
758: g_msg_life_range3 := fnd_message.get;
759: --
760: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
761: fnd_message.set_token('RANGE_A',g_life_range4a);
762: g_msg_life_range4 := fnd_message.get;
763: --
764: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
757: fnd_message.set_token('RANGE_B',g_life_range3b);
758: g_msg_life_range3 := fnd_message.get;
759: --
760: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
761: fnd_message.set_token('RANGE_A',g_life_range4a);
762: g_msg_life_range4 := fnd_message.get;
763: --
764: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
765: fnd_message.set_token('CALC',g_life_calc2);
758: g_msg_life_range3 := fnd_message.get;
759: --
760: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
761: fnd_message.set_token('RANGE_A',g_life_range4a);
762: g_msg_life_range4 := fnd_message.get;
763: --
764: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
765: fnd_message.set_token('CALC',g_life_calc2);
766: g_msg_life_calc2 := fnd_message.get;
760: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
761: fnd_message.set_token('RANGE_A',g_life_range4a);
762: g_msg_life_range4 := fnd_message.get;
763: --
764: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
765: fnd_message.set_token('CALC',g_life_calc2);
766: g_msg_life_calc2 := fnd_message.get;
767: --
768: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
761: fnd_message.set_token('RANGE_A',g_life_range4a);
762: g_msg_life_range4 := fnd_message.get;
763: --
764: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
765: fnd_message.set_token('CALC',g_life_calc2);
766: g_msg_life_calc2 := fnd_message.get;
767: --
768: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
769: fnd_message.set_token('CALC',g_life_calc3);
762: g_msg_life_range4 := fnd_message.get;
763: --
764: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
765: fnd_message.set_token('CALC',g_life_calc2);
766: g_msg_life_calc2 := fnd_message.get;
767: --
768: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
769: fnd_message.set_token('CALC',g_life_calc3);
770: g_msg_life_calc3 := fnd_message.get;
764: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
765: fnd_message.set_token('CALC',g_life_calc2);
766: g_msg_life_calc2 := fnd_message.get;
767: --
768: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
769: fnd_message.set_token('CALC',g_life_calc3);
770: g_msg_life_calc3 := fnd_message.get;
771: --
772: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
765: fnd_message.set_token('CALC',g_life_calc2);
766: g_msg_life_calc2 := fnd_message.get;
767: --
768: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
769: fnd_message.set_token('CALC',g_life_calc3);
770: g_msg_life_calc3 := fnd_message.get;
771: --
772: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
773: fnd_message.set_token('CALC',g_life_calc4);
766: g_msg_life_calc2 := fnd_message.get;
767: --
768: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
769: fnd_message.set_token('CALC',g_life_calc3);
770: g_msg_life_calc3 := fnd_message.get;
771: --
772: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
773: fnd_message.set_token('CALC',g_life_calc4);
774: g_msg_life_calc4 := fnd_message.get;
768: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
769: fnd_message.set_token('CALC',g_life_calc3);
770: g_msg_life_calc3 := fnd_message.get;
771: --
772: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
773: fnd_message.set_token('CALC',g_life_calc4);
774: g_msg_life_calc4 := fnd_message.get;
775: --
776: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
769: fnd_message.set_token('CALC',g_life_calc3);
770: g_msg_life_calc3 := fnd_message.get;
771: --
772: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
773: fnd_message.set_token('CALC',g_life_calc4);
774: g_msg_life_calc4 := fnd_message.get;
775: --
776: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
777: fnd_message.set_token('MAX_VAL',g_life_gen_max);
770: g_msg_life_calc3 := fnd_message.get;
771: --
772: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
773: fnd_message.set_token('CALC',g_life_calc4);
774: g_msg_life_calc4 := fnd_message.get;
775: --
776: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
777: fnd_message.set_token('MAX_VAL',g_life_gen_max);
778: g_msg_life_gen_max := fnd_message.get;
772: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
773: fnd_message.set_token('CALC',g_life_calc4);
774: g_msg_life_calc4 := fnd_message.get;
775: --
776: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
777: fnd_message.set_token('MAX_VAL',g_life_gen_max);
778: g_msg_life_gen_max := fnd_message.get;
779: --
780: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
773: fnd_message.set_token('CALC',g_life_calc4);
774: g_msg_life_calc4 := fnd_message.get;
775: --
776: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
777: fnd_message.set_token('MAX_VAL',g_life_gen_max);
778: g_msg_life_gen_max := fnd_message.get;
779: --
780: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
781: fnd_message.set_token('MAX_VAL',g_life_pens_max);
774: g_msg_life_calc4 := fnd_message.get;
775: --
776: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
777: fnd_message.set_token('MAX_VAL',g_life_gen_max);
778: g_msg_life_gen_max := fnd_message.get;
779: --
780: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
781: fnd_message.set_token('MAX_VAL',g_life_pens_max);
782: g_msg_life_pens_max := fnd_message.get;
776: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
777: fnd_message.set_token('MAX_VAL',g_life_gen_max);
778: g_msg_life_gen_max := fnd_message.get;
779: --
780: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
781: fnd_message.set_token('MAX_VAL',g_life_pens_max);
782: g_msg_life_pens_max := fnd_message.get;
783: --
784: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
777: fnd_message.set_token('MAX_VAL',g_life_gen_max);
778: g_msg_life_gen_max := fnd_message.get;
779: --
780: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
781: fnd_message.set_token('MAX_VAL',g_life_pens_max);
782: g_msg_life_pens_max := fnd_message.get;
783: --
784: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
785: fnd_message.set_token('MAX_VAL',g_life_ins_max);
778: g_msg_life_gen_max := fnd_message.get;
779: --
780: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
781: fnd_message.set_token('MAX_VAL',g_life_pens_max);
782: g_msg_life_pens_max := fnd_message.get;
783: --
784: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
785: fnd_message.set_token('MAX_VAL',g_life_ins_max);
786: g_msg_life_ins_max := fnd_message.get;
780: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
781: fnd_message.set_token('MAX_VAL',g_life_pens_max);
782: g_msg_life_pens_max := fnd_message.get;
783: --
784: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
785: fnd_message.set_token('MAX_VAL',g_life_ins_max);
786: g_msg_life_ins_max := fnd_message.get;
787: --
788: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_2007');
781: fnd_message.set_token('MAX_VAL',g_life_pens_max);
782: g_msg_life_pens_max := fnd_message.get;
783: --
784: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
785: fnd_message.set_token('MAX_VAL',g_life_ins_max);
786: g_msg_life_ins_max := fnd_message.get;
787: --
788: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_2007');
789: g_msg_nonlife_2007 := fnd_message.get;
782: g_msg_life_pens_max := fnd_message.get;
783: --
784: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
785: fnd_message.set_token('MAX_VAL',g_life_ins_max);
786: g_msg_life_ins_max := fnd_message.get;
787: --
788: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_2007');
789: g_msg_nonlife_2007 := fnd_message.get;
790: --
784: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
785: fnd_message.set_token('MAX_VAL',g_life_ins_max);
786: g_msg_life_ins_max := fnd_message.get;
787: --
788: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_2007');
789: g_msg_nonlife_2007 := fnd_message.get;
790: --
791: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_AP_2007');
792: g_msg_nonlife_ap_2007 := fnd_message.get;
785: fnd_message.set_token('MAX_VAL',g_life_ins_max);
786: g_msg_life_ins_max := fnd_message.get;
787: --
788: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_2007');
789: g_msg_nonlife_2007 := fnd_message.get;
790: --
791: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_AP_2007');
792: g_msg_nonlife_ap_2007 := fnd_message.get;
793: --
787: --
788: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_2007');
789: g_msg_nonlife_2007 := fnd_message.get;
790: --
791: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_AP_2007');
792: g_msg_nonlife_ap_2007 := fnd_message.get;
793: --
794: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_S_2007');
795: g_msg_eqnonlife_s_2007 := fnd_message.get;
788: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_2007');
789: g_msg_nonlife_2007 := fnd_message.get;
790: --
791: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_AP_2007');
792: g_msg_nonlife_ap_2007 := fnd_message.get;
793: --
794: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_S_2007');
795: g_msg_eqnonlife_s_2007 := fnd_message.get;
796: --
790: --
791: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_AP_2007');
792: g_msg_nonlife_ap_2007 := fnd_message.get;
793: --
794: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_S_2007');
795: g_msg_eqnonlife_s_2007 := fnd_message.get;
796: --
797: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_S_2007');
798: g_msg_lnonlife_s_2007 := fnd_message.get;
791: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_AP_2007');
792: g_msg_nonlife_ap_2007 := fnd_message.get;
793: --
794: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_S_2007');
795: g_msg_eqnonlife_s_2007 := fnd_message.get;
796: --
797: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_S_2007');
798: g_msg_lnonlife_s_2007 := fnd_message.get;
799: --
793: --
794: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_S_2007');
795: g_msg_eqnonlife_s_2007 := fnd_message.get;
796: --
797: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_S_2007');
798: g_msg_lnonlife_s_2007 := fnd_message.get;
799: --
800: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE');
801: fnd_message.set_token('YEAR',g_lnonlife_year);
794: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_S_2007');
795: g_msg_eqnonlife_s_2007 := fnd_message.get;
796: --
797: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_S_2007');
798: g_msg_lnonlife_s_2007 := fnd_message.get;
799: --
800: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE');
801: fnd_message.set_token('YEAR',g_lnonlife_year);
802: g_msg_lnonlife := fnd_message.get;
796: --
797: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_S_2007');
798: g_msg_lnonlife_s_2007 := fnd_message.get;
799: --
800: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE');
801: fnd_message.set_token('YEAR',g_lnonlife_year);
802: g_msg_lnonlife := fnd_message.get;
803: --
804: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_2007');
797: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_S_2007');
798: g_msg_lnonlife_s_2007 := fnd_message.get;
799: --
800: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE');
801: fnd_message.set_token('YEAR',g_lnonlife_year);
802: g_msg_lnonlife := fnd_message.get;
803: --
804: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_2007');
805: g_msg_eqnonlife_2007 := fnd_message.get;
798: g_msg_lnonlife_s_2007 := fnd_message.get;
799: --
800: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE');
801: fnd_message.set_token('YEAR',g_lnonlife_year);
802: g_msg_lnonlife := fnd_message.get;
803: --
804: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_2007');
805: g_msg_eqnonlife_2007 := fnd_message.get;
806: --
800: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE');
801: fnd_message.set_token('YEAR',g_lnonlife_year);
802: g_msg_lnonlife := fnd_message.get;
803: --
804: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_2007');
805: g_msg_eqnonlife_2007 := fnd_message.get;
806: --
807: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_2007');
808: g_msg_lnonlife_2007 := fnd_message.get;
801: fnd_message.set_token('YEAR',g_lnonlife_year);
802: g_msg_lnonlife := fnd_message.get;
803: --
804: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_2007');
805: g_msg_eqnonlife_2007 := fnd_message.get;
806: --
807: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_2007');
808: g_msg_lnonlife_2007 := fnd_message.get;
809: --
803: --
804: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_2007');
805: g_msg_eqnonlife_2007 := fnd_message.get;
806: --
807: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_2007');
808: g_msg_lnonlife_2007 := fnd_message.get;
809: --
810: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_DCT');
811: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
804: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_2007');
805: g_msg_eqnonlife_2007 := fnd_message.get;
806: --
807: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_2007');
808: g_msg_lnonlife_2007 := fnd_message.get;
809: --
810: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_DCT');
811: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
812: fnd_message.set_token('CALC',g_lnonlife_calc2);
806: --
807: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_2007');
808: g_msg_lnonlife_2007 := fnd_message.get;
809: --
810: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_DCT');
811: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
812: fnd_message.set_token('CALC',g_lnonlife_calc2);
813: g_msg_lnonlife_dct := fnd_message.get;
814: --
807: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_2007');
808: g_msg_lnonlife_2007 := fnd_message.get;
809: --
810: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_DCT');
811: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
812: fnd_message.set_token('CALC',g_lnonlife_calc2);
813: g_msg_lnonlife_dct := fnd_message.get;
814: --
815: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SNONLIFE_DCT');
808: g_msg_lnonlife_2007 := fnd_message.get;
809: --
810: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_DCT');
811: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
812: fnd_message.set_token('CALC',g_lnonlife_calc2);
813: g_msg_lnonlife_dct := fnd_message.get;
814: --
815: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SNONLIFE_DCT');
816: fnd_message.set_token('RANGE_B',g_snonlife_range1b);
809: --
810: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_DCT');
811: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
812: fnd_message.set_token('CALC',g_lnonlife_calc2);
813: g_msg_lnonlife_dct := fnd_message.get;
814: --
815: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SNONLIFE_DCT');
816: fnd_message.set_token('RANGE_B',g_snonlife_range1b);
817: fnd_message.set_token('CALC',g_snonlife_calc2);
811: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
812: fnd_message.set_token('CALC',g_lnonlife_calc2);
813: g_msg_lnonlife_dct := fnd_message.get;
814: --
815: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SNONLIFE_DCT');
816: fnd_message.set_token('RANGE_B',g_snonlife_range1b);
817: fnd_message.set_token('CALC',g_snonlife_calc2);
818: g_msg_snonlife_dct := fnd_message.get;
819: --
812: fnd_message.set_token('CALC',g_lnonlife_calc2);
813: g_msg_lnonlife_dct := fnd_message.get;
814: --
815: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SNONLIFE_DCT');
816: fnd_message.set_token('RANGE_B',g_snonlife_range1b);
817: fnd_message.set_token('CALC',g_snonlife_calc2);
818: g_msg_snonlife_dct := fnd_message.get;
819: --
820: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONL_DCT_2007');
813: g_msg_lnonlife_dct := fnd_message.get;
814: --
815: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SNONLIFE_DCT');
816: fnd_message.set_token('RANGE_B',g_snonlife_range1b);
817: fnd_message.set_token('CALC',g_snonlife_calc2);
818: g_msg_snonlife_dct := fnd_message.get;
819: --
820: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONL_DCT_2007');
821: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
814: --
815: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SNONLIFE_DCT');
816: fnd_message.set_token('RANGE_B',g_snonlife_range1b);
817: fnd_message.set_token('CALC',g_snonlife_calc2);
818: g_msg_snonlife_dct := fnd_message.get;
819: --
820: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONL_DCT_2007');
821: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
822: fnd_message.set_token('CALC',g_lnonlife_calc2);
816: fnd_message.set_token('RANGE_B',g_snonlife_range1b);
817: fnd_message.set_token('CALC',g_snonlife_calc2);
818: g_msg_snonlife_dct := fnd_message.get;
819: --
820: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONL_DCT_2007');
821: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
822: fnd_message.set_token('CALC',g_lnonlife_calc2);
823: g_msg_lnonlife_dct_2007 := fnd_message.get;
824: --
817: fnd_message.set_token('CALC',g_snonlife_calc2);
818: g_msg_snonlife_dct := fnd_message.get;
819: --
820: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONL_DCT_2007');
821: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
822: fnd_message.set_token('CALC',g_lnonlife_calc2);
823: g_msg_lnonlife_dct_2007 := fnd_message.get;
824: --
825: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
818: g_msg_snonlife_dct := fnd_message.get;
819: --
820: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONL_DCT_2007');
821: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
822: fnd_message.set_token('CALC',g_lnonlife_calc2);
823: g_msg_lnonlife_dct_2007 := fnd_message.get;
824: --
825: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
826: fnd_message.set_token('MAX_VAL',g_earthquake_max);
819: --
820: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONL_DCT_2007');
821: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
822: fnd_message.set_token('CALC',g_lnonlife_calc2);
823: g_msg_lnonlife_dct_2007 := fnd_message.get;
824: --
825: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
826: fnd_message.set_token('MAX_VAL',g_earthquake_max);
827: g_msg_earthquake_max := fnd_message.get;
821: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
822: fnd_message.set_token('CALC',g_lnonlife_calc2);
823: g_msg_lnonlife_dct_2007 := fnd_message.get;
824: --
825: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
826: fnd_message.set_token('MAX_VAL',g_earthquake_max);
827: g_msg_earthquake_max := fnd_message.get;
828: --
829: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
822: fnd_message.set_token('CALC',g_lnonlife_calc2);
823: g_msg_lnonlife_dct_2007 := fnd_message.get;
824: --
825: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
826: fnd_message.set_token('MAX_VAL',g_earthquake_max);
827: g_msg_earthquake_max := fnd_message.get;
828: --
829: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
830: fnd_message.set_token('MAX_VAL',g_lnonlife_max);
823: g_msg_lnonlife_dct_2007 := fnd_message.get;
824: --
825: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
826: fnd_message.set_token('MAX_VAL',g_earthquake_max);
827: g_msg_earthquake_max := fnd_message.get;
828: --
829: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
830: fnd_message.set_token('MAX_VAL',g_lnonlife_max);
831: g_msg_nonlife_long_max := fnd_message.get;
825: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
826: fnd_message.set_token('MAX_VAL',g_earthquake_max);
827: g_msg_earthquake_max := fnd_message.get;
828: --
829: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
830: fnd_message.set_token('MAX_VAL',g_lnonlife_max);
831: g_msg_nonlife_long_max := fnd_message.get;
832: --
833: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
826: fnd_message.set_token('MAX_VAL',g_earthquake_max);
827: g_msg_earthquake_max := fnd_message.get;
828: --
829: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
830: fnd_message.set_token('MAX_VAL',g_lnonlife_max);
831: g_msg_nonlife_long_max := fnd_message.get;
832: --
833: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
834: fnd_message.set_token('MAX_VAL',g_snonlife_max);
827: g_msg_earthquake_max := fnd_message.get;
828: --
829: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
830: fnd_message.set_token('MAX_VAL',g_lnonlife_max);
831: g_msg_nonlife_long_max := fnd_message.get;
832: --
833: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
834: fnd_message.set_token('MAX_VAL',g_snonlife_max);
835: g_msg_nonlife_short_max := fnd_message.get;
829: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
830: fnd_message.set_token('MAX_VAL',g_lnonlife_max);
831: g_msg_nonlife_long_max := fnd_message.get;
832: --
833: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
834: fnd_message.set_token('MAX_VAL',g_snonlife_max);
835: g_msg_nonlife_short_max := fnd_message.get;
836: --
837: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
830: fnd_message.set_token('MAX_VAL',g_lnonlife_max);
831: g_msg_nonlife_long_max := fnd_message.get;
832: --
833: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
834: fnd_message.set_token('MAX_VAL',g_snonlife_max);
835: g_msg_nonlife_short_max := fnd_message.get;
836: --
837: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
838: fnd_message.set_token('MAX_VAL',g_nonlife_max);
831: g_msg_nonlife_long_max := fnd_message.get;
832: --
833: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
834: fnd_message.set_token('MAX_VAL',g_snonlife_max);
835: g_msg_nonlife_short_max := fnd_message.get;
836: --
837: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
838: fnd_message.set_token('MAX_VAL',g_nonlife_max);
839: g_msg_nonlife_ins_max := fnd_message.get;
833: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
834: fnd_message.set_token('MAX_VAL',g_snonlife_max);
835: g_msg_nonlife_short_max := fnd_message.get;
836: --
837: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
838: fnd_message.set_token('MAX_VAL',g_nonlife_max);
839: g_msg_nonlife_ins_max := fnd_message.get;
840: --
841: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
834: fnd_message.set_token('MAX_VAL',g_snonlife_max);
835: g_msg_nonlife_short_max := fnd_message.get;
836: --
837: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
838: fnd_message.set_token('MAX_VAL',g_nonlife_max);
839: g_msg_nonlife_ins_max := fnd_message.get;
840: --
841: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
842: fnd_message.set_token('MAX_VAL',g_nonlife_max_2007);
835: g_msg_nonlife_short_max := fnd_message.get;
836: --
837: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
838: fnd_message.set_token('MAX_VAL',g_nonlife_max);
839: g_msg_nonlife_ins_max := fnd_message.get;
840: --
841: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
842: fnd_message.set_token('MAX_VAL',g_nonlife_max_2007);
843: g_msg_nonlife_ins_max_2007 := fnd_message.get;
837: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
838: fnd_message.set_token('MAX_VAL',g_nonlife_max);
839: g_msg_nonlife_ins_max := fnd_message.get;
840: --
841: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
842: fnd_message.set_token('MAX_VAL',g_nonlife_max_2007);
843: g_msg_nonlife_ins_max_2007 := fnd_message.get;
844: --
845: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_EMP_INC_MAX');
838: fnd_message.set_token('MAX_VAL',g_nonlife_max);
839: g_msg_nonlife_ins_max := fnd_message.get;
840: --
841: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
842: fnd_message.set_token('MAX_VAL',g_nonlife_max_2007);
843: g_msg_nonlife_ins_max_2007 := fnd_message.get;
844: --
845: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_EMP_INC_MAX');
846: fnd_message.set_token('EMP_INC_MAX',g_sp_emp_inc_max);
839: g_msg_nonlife_ins_max := fnd_message.get;
840: --
841: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
842: fnd_message.set_token('MAX_VAL',g_nonlife_max_2007);
843: g_msg_nonlife_ins_max_2007 := fnd_message.get;
844: --
845: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_EMP_INC_MAX');
846: fnd_message.set_token('EMP_INC_MAX',g_sp_emp_inc_max);
847: g_msg_sp_emp_inc_max := fnd_message.get;
841: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
842: fnd_message.set_token('MAX_VAL',g_nonlife_max_2007);
843: g_msg_nonlife_ins_max_2007 := fnd_message.get;
844: --
845: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_EMP_INC_MAX');
846: fnd_message.set_token('EMP_INC_MAX',g_sp_emp_inc_max);
847: g_msg_sp_emp_inc_max := fnd_message.get;
848: --
849: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_SP_INC_MAX');
842: fnd_message.set_token('MAX_VAL',g_nonlife_max_2007);
843: g_msg_nonlife_ins_max_2007 := fnd_message.get;
844: --
845: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_EMP_INC_MAX');
846: fnd_message.set_token('EMP_INC_MAX',g_sp_emp_inc_max);
847: g_msg_sp_emp_inc_max := fnd_message.get;
848: --
849: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_SP_INC_MAX');
850: fnd_message.set_token('SP_DCT_MAX',g_sp_spdct_max);
843: g_msg_nonlife_ins_max_2007 := fnd_message.get;
844: --
845: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_EMP_INC_MAX');
846: fnd_message.set_token('EMP_INC_MAX',g_sp_emp_inc_max);
847: g_msg_sp_emp_inc_max := fnd_message.get;
848: --
849: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_SP_INC_MAX');
850: fnd_message.set_token('SP_DCT_MAX',g_sp_spdct_max);
851: fnd_message.set_token('SP_INC_MAX',g_sp_spinc_max);
845: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_EMP_INC_MAX');
846: fnd_message.set_token('EMP_INC_MAX',g_sp_emp_inc_max);
847: g_msg_sp_emp_inc_max := fnd_message.get;
848: --
849: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_SP_INC_MAX');
850: fnd_message.set_token('SP_DCT_MAX',g_sp_spdct_max);
851: fnd_message.set_token('SP_INC_MAX',g_sp_spinc_max);
852: g_msg_sp_sp_inc_max := fnd_message.get;
853: --
846: fnd_message.set_token('EMP_INC_MAX',g_sp_emp_inc_max);
847: g_msg_sp_emp_inc_max := fnd_message.get;
848: --
849: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_SP_INC_MAX');
850: fnd_message.set_token('SP_DCT_MAX',g_sp_spdct_max);
851: fnd_message.set_token('SP_INC_MAX',g_sp_spinc_max);
852: g_msg_sp_sp_inc_max := fnd_message.get;
853: --
854: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP1');
847: g_msg_sp_emp_inc_max := fnd_message.get;
848: --
849: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_SP_INC_MAX');
850: fnd_message.set_token('SP_DCT_MAX',g_sp_spdct_max);
851: fnd_message.set_token('SP_INC_MAX',g_sp_spinc_max);
852: g_msg_sp_sp_inc_max := fnd_message.get;
853: --
854: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP1');
855: fnd_message.set_token('SP_CALC_EXP1',g_sp_calc_cal1);
848: --
849: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_SP_INC_MAX');
850: fnd_message.set_token('SP_DCT_MAX',g_sp_spdct_max);
851: fnd_message.set_token('SP_INC_MAX',g_sp_spinc_max);
852: g_msg_sp_sp_inc_max := fnd_message.get;
853: --
854: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP1');
855: fnd_message.set_token('SP_CALC_EXP1',g_sp_calc_cal1);
856: g_msg_sp_calc_cal1 := fnd_message.get;
850: fnd_message.set_token('SP_DCT_MAX',g_sp_spdct_max);
851: fnd_message.set_token('SP_INC_MAX',g_sp_spinc_max);
852: g_msg_sp_sp_inc_max := fnd_message.get;
853: --
854: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP1');
855: fnd_message.set_token('SP_CALC_EXP1',g_sp_calc_cal1);
856: g_msg_sp_calc_cal1 := fnd_message.get;
857: --
858: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP6');
851: fnd_message.set_token('SP_INC_MAX',g_sp_spinc_max);
852: g_msg_sp_sp_inc_max := fnd_message.get;
853: --
854: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP1');
855: fnd_message.set_token('SP_CALC_EXP1',g_sp_calc_cal1);
856: g_msg_sp_calc_cal1 := fnd_message.get;
857: --
858: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP6');
859: fnd_message.set_token('SP_CALC_EXP6',g_sp_calc_cal6);
852: g_msg_sp_sp_inc_max := fnd_message.get;
853: --
854: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP1');
855: fnd_message.set_token('SP_CALC_EXP1',g_sp_calc_cal1);
856: g_msg_sp_calc_cal1 := fnd_message.get;
857: --
858: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP6');
859: fnd_message.set_token('SP_CALC_EXP6',g_sp_calc_cal6);
860: g_msg_sp_calc_cal6 := fnd_message.get;
854: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP1');
855: fnd_message.set_token('SP_CALC_EXP1',g_sp_calc_cal1);
856: g_msg_sp_calc_cal1 := fnd_message.get;
857: --
858: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP6');
859: fnd_message.set_token('SP_CALC_EXP6',g_sp_calc_cal6);
860: g_msg_sp_calc_cal6 := fnd_message.get;
861: --
862: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
855: fnd_message.set_token('SP_CALC_EXP1',g_sp_calc_cal1);
856: g_msg_sp_calc_cal1 := fnd_message.get;
857: --
858: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP6');
859: fnd_message.set_token('SP_CALC_EXP6',g_sp_calc_cal6);
860: g_msg_sp_calc_cal6 := fnd_message.get;
861: --
862: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
863: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range1a);
856: g_msg_sp_calc_cal1 := fnd_message.get;
857: --
858: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP6');
859: fnd_message.set_token('SP_CALC_EXP6',g_sp_calc_cal6);
860: g_msg_sp_calc_cal6 := fnd_message.get;
861: --
862: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
863: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range1a);
864: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range1b);
858: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP6');
859: fnd_message.set_token('SP_CALC_EXP6',g_sp_calc_cal6);
860: g_msg_sp_calc_cal6 := fnd_message.get;
861: --
862: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
863: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range1a);
864: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range1b);
865: g_msg_sp_calc_dct_range1 := fnd_message.get;
866: --
859: fnd_message.set_token('SP_CALC_EXP6',g_sp_calc_cal6);
860: g_msg_sp_calc_cal6 := fnd_message.get;
861: --
862: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
863: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range1a);
864: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range1b);
865: g_msg_sp_calc_dct_range1 := fnd_message.get;
866: --
867: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
860: g_msg_sp_calc_cal6 := fnd_message.get;
861: --
862: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
863: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range1a);
864: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range1b);
865: g_msg_sp_calc_dct_range1 := fnd_message.get;
866: --
867: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
868: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range2a);
861: --
862: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
863: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range1a);
864: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range1b);
865: g_msg_sp_calc_dct_range1 := fnd_message.get;
866: --
867: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
868: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range2a);
869: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range2b);
863: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range1a);
864: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range1b);
865: g_msg_sp_calc_dct_range1 := fnd_message.get;
866: --
867: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
868: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range2a);
869: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range2b);
870: g_msg_sp_calc_dct_range2 := fnd_message.get;
871: --
864: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range1b);
865: g_msg_sp_calc_dct_range1 := fnd_message.get;
866: --
867: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
868: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range2a);
869: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range2b);
870: g_msg_sp_calc_dct_range2 := fnd_message.get;
871: --
872: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
865: g_msg_sp_calc_dct_range1 := fnd_message.get;
866: --
867: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
868: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range2a);
869: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range2b);
870: g_msg_sp_calc_dct_range2 := fnd_message.get;
871: --
872: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
873: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range3a);
866: --
867: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
868: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range2a);
869: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range2b);
870: g_msg_sp_calc_dct_range2 := fnd_message.get;
871: --
872: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
873: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range3a);
874: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range3b);
868: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range2a);
869: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range2b);
870: g_msg_sp_calc_dct_range2 := fnd_message.get;
871: --
872: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
873: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range3a);
874: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range3b);
875: g_msg_sp_calc_dct_range3 := fnd_message.get;
876: --
869: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range2b);
870: g_msg_sp_calc_dct_range2 := fnd_message.get;
871: --
872: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
873: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range3a);
874: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range3b);
875: g_msg_sp_calc_dct_range3 := fnd_message.get;
876: --
877: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
870: g_msg_sp_calc_dct_range2 := fnd_message.get;
871: --
872: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
873: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range3a);
874: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range3b);
875: g_msg_sp_calc_dct_range3 := fnd_message.get;
876: --
877: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
878: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range4a);
871: --
872: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
873: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range3a);
874: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range3b);
875: g_msg_sp_calc_dct_range3 := fnd_message.get;
876: --
877: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
878: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range4a);
879: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range4b);
873: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range3a);
874: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range3b);
875: g_msg_sp_calc_dct_range3 := fnd_message.get;
876: --
877: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
878: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range4a);
879: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range4b);
880: g_msg_sp_calc_dct_range4 := fnd_message.get;
881: --
874: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range3b);
875: g_msg_sp_calc_dct_range3 := fnd_message.get;
876: --
877: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
878: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range4a);
879: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range4b);
880: g_msg_sp_calc_dct_range4 := fnd_message.get;
881: --
882: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
875: g_msg_sp_calc_dct_range3 := fnd_message.get;
876: --
877: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
878: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range4a);
879: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range4b);
880: g_msg_sp_calc_dct_range4 := fnd_message.get;
881: --
882: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
883: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range5a);
876: --
877: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
878: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range4a);
879: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range4b);
880: g_msg_sp_calc_dct_range4 := fnd_message.get;
881: --
882: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
883: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range5a);
884: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range5b);
878: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range4a);
879: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range4b);
880: g_msg_sp_calc_dct_range4 := fnd_message.get;
881: --
882: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
883: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range5a);
884: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range5b);
885: g_msg_sp_calc_dct_range5 := fnd_message.get;
886: --
879: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range4b);
880: g_msg_sp_calc_dct_range4 := fnd_message.get;
881: --
882: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
883: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range5a);
884: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range5b);
885: g_msg_sp_calc_dct_range5 := fnd_message.get;
886: --
887: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
880: g_msg_sp_calc_dct_range4 := fnd_message.get;
881: --
882: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
883: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range5a);
884: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range5b);
885: g_msg_sp_calc_dct_range5 := fnd_message.get;
886: --
887: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
888: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range6a);
881: --
882: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
883: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range5a);
884: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range5b);
885: g_msg_sp_calc_dct_range5 := fnd_message.get;
886: --
887: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
888: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range6a);
889: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range6b);
883: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range5a);
884: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range5b);
885: g_msg_sp_calc_dct_range5 := fnd_message.get;
886: --
887: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
888: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range6a);
889: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range6b);
890: g_msg_sp_calc_dct_range6 := fnd_message.get;
891: --
884: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range5b);
885: g_msg_sp_calc_dct_range5 := fnd_message.get;
886: --
887: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
888: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range6a);
889: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range6b);
890: g_msg_sp_calc_dct_range6 := fnd_message.get;
891: --
892: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
885: g_msg_sp_calc_dct_range5 := fnd_message.get;
886: --
887: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
888: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range6a);
889: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range6b);
890: g_msg_sp_calc_dct_range6 := fnd_message.get;
891: --
892: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
893: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range7a);
886: --
887: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
888: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range6a);
889: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range6b);
890: g_msg_sp_calc_dct_range6 := fnd_message.get;
891: --
892: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
893: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range7a);
894: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range7b);
888: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range6a);
889: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range6b);
890: g_msg_sp_calc_dct_range6 := fnd_message.get;
891: --
892: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
893: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range7a);
894: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range7b);
895: g_msg_sp_calc_dct_range7 := fnd_message.get;
896: --
889: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range6b);
890: g_msg_sp_calc_dct_range6 := fnd_message.get;
891: --
892: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
893: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range7a);
894: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range7b);
895: g_msg_sp_calc_dct_range7 := fnd_message.get;
896: --
897: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
890: g_msg_sp_calc_dct_range6 := fnd_message.get;
891: --
892: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
893: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range7a);
894: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range7b);
895: g_msg_sp_calc_dct_range7 := fnd_message.get;
896: --
897: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
898: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range8a);
891: --
892: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
893: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range7a);
894: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range7b);
895: g_msg_sp_calc_dct_range7 := fnd_message.get;
896: --
897: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
898: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range8a);
899: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range8b);
893: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range7a);
894: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range7b);
895: g_msg_sp_calc_dct_range7 := fnd_message.get;
896: --
897: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
898: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range8a);
899: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range8b);
900: g_msg_sp_calc_dct_range8 := fnd_message.get;
901: --
894: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range7b);
895: g_msg_sp_calc_dct_range7 := fnd_message.get;
896: --
897: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
898: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range8a);
899: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range8b);
900: g_msg_sp_calc_dct_range8 := fnd_message.get;
901: --
902: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
895: g_msg_sp_calc_dct_range7 := fnd_message.get;
896: --
897: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
898: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range8a);
899: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range8b);
900: g_msg_sp_calc_dct_range8 := fnd_message.get;
901: --
902: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
903: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range9a);
896: --
897: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
898: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range8a);
899: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range8b);
900: g_msg_sp_calc_dct_range8 := fnd_message.get;
901: --
902: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
903: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range9a);
904: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range9b);
898: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range8a);
899: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range8b);
900: g_msg_sp_calc_dct_range8 := fnd_message.get;
901: --
902: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
903: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range9a);
904: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range9b);
905: g_msg_sp_calc_dct_range9 := fnd_message.get;
906: --
899: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range8b);
900: g_msg_sp_calc_dct_range8 := fnd_message.get;
901: --
902: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
903: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range9a);
904: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range9b);
905: g_msg_sp_calc_dct_range9 := fnd_message.get;
906: --
907: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
900: g_msg_sp_calc_dct_range8 := fnd_message.get;
901: --
902: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
903: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range9a);
904: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range9b);
905: g_msg_sp_calc_dct_range9 := fnd_message.get;
906: --
907: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
908: --fnd_message.set_token('DCT',g_sp_calc_dct1);
901: --
902: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
903: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range9a);
904: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range9b);
905: g_msg_sp_calc_dct_range9 := fnd_message.get;
906: --
907: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
908: --fnd_message.set_token('DCT',g_sp_calc_dct1);
909: --g_msg_sp_calc_dct1 := fnd_message.get;
903: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range9a);
904: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range9b);
905: g_msg_sp_calc_dct_range9 := fnd_message.get;
906: --
907: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
908: --fnd_message.set_token('DCT',g_sp_calc_dct1);
909: --g_msg_sp_calc_dct1 := fnd_message.get;
910: g_msg_sp_calc_dct1 := g_sp_calc_dct1;
911: --
904: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range9b);
905: g_msg_sp_calc_dct_range9 := fnd_message.get;
906: --
907: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
908: --fnd_message.set_token('DCT',g_sp_calc_dct1);
909: --g_msg_sp_calc_dct1 := fnd_message.get;
910: g_msg_sp_calc_dct1 := g_sp_calc_dct1;
911: --
912: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
905: g_msg_sp_calc_dct_range9 := fnd_message.get;
906: --
907: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
908: --fnd_message.set_token('DCT',g_sp_calc_dct1);
909: --g_msg_sp_calc_dct1 := fnd_message.get;
910: g_msg_sp_calc_dct1 := g_sp_calc_dct1;
911: --
912: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
913: --fnd_message.set_token('DCT',g_sp_calc_dct2);
908: --fnd_message.set_token('DCT',g_sp_calc_dct1);
909: --g_msg_sp_calc_dct1 := fnd_message.get;
910: g_msg_sp_calc_dct1 := g_sp_calc_dct1;
911: --
912: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
913: --fnd_message.set_token('DCT',g_sp_calc_dct2);
914: --g_msg_sp_calc_dct2 := fnd_message.get;
915: g_msg_sp_calc_dct2 := g_sp_calc_dct2;
916: --
909: --g_msg_sp_calc_dct1 := fnd_message.get;
910: g_msg_sp_calc_dct1 := g_sp_calc_dct1;
911: --
912: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
913: --fnd_message.set_token('DCT',g_sp_calc_dct2);
914: --g_msg_sp_calc_dct2 := fnd_message.get;
915: g_msg_sp_calc_dct2 := g_sp_calc_dct2;
916: --
917: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
910: g_msg_sp_calc_dct1 := g_sp_calc_dct1;
911: --
912: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
913: --fnd_message.set_token('DCT',g_sp_calc_dct2);
914: --g_msg_sp_calc_dct2 := fnd_message.get;
915: g_msg_sp_calc_dct2 := g_sp_calc_dct2;
916: --
917: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
918: --fnd_message.set_token('DCT',g_sp_calc_dct3);
913: --fnd_message.set_token('DCT',g_sp_calc_dct2);
914: --g_msg_sp_calc_dct2 := fnd_message.get;
915: g_msg_sp_calc_dct2 := g_sp_calc_dct2;
916: --
917: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
918: --fnd_message.set_token('DCT',g_sp_calc_dct3);
919: --g_msg_sp_calc_dct3 := fnd_message.get;
920: g_msg_sp_calc_dct3 := g_sp_calc_dct3;
921: --
914: --g_msg_sp_calc_dct2 := fnd_message.get;
915: g_msg_sp_calc_dct2 := g_sp_calc_dct2;
916: --
917: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
918: --fnd_message.set_token('DCT',g_sp_calc_dct3);
919: --g_msg_sp_calc_dct3 := fnd_message.get;
920: g_msg_sp_calc_dct3 := g_sp_calc_dct3;
921: --
922: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
915: g_msg_sp_calc_dct2 := g_sp_calc_dct2;
916: --
917: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
918: --fnd_message.set_token('DCT',g_sp_calc_dct3);
919: --g_msg_sp_calc_dct3 := fnd_message.get;
920: g_msg_sp_calc_dct3 := g_sp_calc_dct3;
921: --
922: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
923: --fnd_message.set_token('DCT',g_sp_calc_dct4);
918: --fnd_message.set_token('DCT',g_sp_calc_dct3);
919: --g_msg_sp_calc_dct3 := fnd_message.get;
920: g_msg_sp_calc_dct3 := g_sp_calc_dct3;
921: --
922: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
923: --fnd_message.set_token('DCT',g_sp_calc_dct4);
924: --g_msg_sp_calc_dct4 := fnd_message.get;
925: g_msg_sp_calc_dct4 := g_sp_calc_dct4;
926: --
919: --g_msg_sp_calc_dct3 := fnd_message.get;
920: g_msg_sp_calc_dct3 := g_sp_calc_dct3;
921: --
922: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
923: --fnd_message.set_token('DCT',g_sp_calc_dct4);
924: --g_msg_sp_calc_dct4 := fnd_message.get;
925: g_msg_sp_calc_dct4 := g_sp_calc_dct4;
926: --
927: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
920: g_msg_sp_calc_dct3 := g_sp_calc_dct3;
921: --
922: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
923: --fnd_message.set_token('DCT',g_sp_calc_dct4);
924: --g_msg_sp_calc_dct4 := fnd_message.get;
925: g_msg_sp_calc_dct4 := g_sp_calc_dct4;
926: --
927: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
928: --fnd_message.set_token('DCT',g_sp_calc_dct5);
923: --fnd_message.set_token('DCT',g_sp_calc_dct4);
924: --g_msg_sp_calc_dct4 := fnd_message.get;
925: g_msg_sp_calc_dct4 := g_sp_calc_dct4;
926: --
927: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
928: --fnd_message.set_token('DCT',g_sp_calc_dct5);
929: --g_msg_sp_calc_dct5 := fnd_message.get;
930: g_msg_sp_calc_dct5 := g_sp_calc_dct5;
931: --
924: --g_msg_sp_calc_dct4 := fnd_message.get;
925: g_msg_sp_calc_dct4 := g_sp_calc_dct4;
926: --
927: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
928: --fnd_message.set_token('DCT',g_sp_calc_dct5);
929: --g_msg_sp_calc_dct5 := fnd_message.get;
930: g_msg_sp_calc_dct5 := g_sp_calc_dct5;
931: --
932: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
925: g_msg_sp_calc_dct4 := g_sp_calc_dct4;
926: --
927: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
928: --fnd_message.set_token('DCT',g_sp_calc_dct5);
929: --g_msg_sp_calc_dct5 := fnd_message.get;
930: g_msg_sp_calc_dct5 := g_sp_calc_dct5;
931: --
932: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
933: --fnd_message.set_token('DCT',g_sp_calc_dct6);
928: --fnd_message.set_token('DCT',g_sp_calc_dct5);
929: --g_msg_sp_calc_dct5 := fnd_message.get;
930: g_msg_sp_calc_dct5 := g_sp_calc_dct5;
931: --
932: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
933: --fnd_message.set_token('DCT',g_sp_calc_dct6);
934: --g_msg_sp_calc_dct6 := fnd_message.get;
935: g_msg_sp_calc_dct6 := g_sp_calc_dct6;
936: --
929: --g_msg_sp_calc_dct5 := fnd_message.get;
930: g_msg_sp_calc_dct5 := g_sp_calc_dct5;
931: --
932: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
933: --fnd_message.set_token('DCT',g_sp_calc_dct6);
934: --g_msg_sp_calc_dct6 := fnd_message.get;
935: g_msg_sp_calc_dct6 := g_sp_calc_dct6;
936: --
937: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
930: g_msg_sp_calc_dct5 := g_sp_calc_dct5;
931: --
932: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
933: --fnd_message.set_token('DCT',g_sp_calc_dct6);
934: --g_msg_sp_calc_dct6 := fnd_message.get;
935: g_msg_sp_calc_dct6 := g_sp_calc_dct6;
936: --
937: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
938: --fnd_message.set_token('DCT',g_sp_calc_dct7);
933: --fnd_message.set_token('DCT',g_sp_calc_dct6);
934: --g_msg_sp_calc_dct6 := fnd_message.get;
935: g_msg_sp_calc_dct6 := g_sp_calc_dct6;
936: --
937: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
938: --fnd_message.set_token('DCT',g_sp_calc_dct7);
939: --g_msg_sp_calc_dct7 := fnd_message.get;
940: g_msg_sp_calc_dct7 := g_sp_calc_dct7;
941: --
934: --g_msg_sp_calc_dct6 := fnd_message.get;
935: g_msg_sp_calc_dct6 := g_sp_calc_dct6;
936: --
937: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
938: --fnd_message.set_token('DCT',g_sp_calc_dct7);
939: --g_msg_sp_calc_dct7 := fnd_message.get;
940: g_msg_sp_calc_dct7 := g_sp_calc_dct7;
941: --
942: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
935: g_msg_sp_calc_dct6 := g_sp_calc_dct6;
936: --
937: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
938: --fnd_message.set_token('DCT',g_sp_calc_dct7);
939: --g_msg_sp_calc_dct7 := fnd_message.get;
940: g_msg_sp_calc_dct7 := g_sp_calc_dct7;
941: --
942: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
943: --fnd_message.set_token('DCT',g_sp_calc_dct8);
938: --fnd_message.set_token('DCT',g_sp_calc_dct7);
939: --g_msg_sp_calc_dct7 := fnd_message.get;
940: g_msg_sp_calc_dct7 := g_sp_calc_dct7;
941: --
942: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
943: --fnd_message.set_token('DCT',g_sp_calc_dct8);
944: --g_msg_sp_calc_dct8 := fnd_message.get;
945: g_msg_sp_calc_dct8 := g_sp_calc_dct8;
946: --
939: --g_msg_sp_calc_dct7 := fnd_message.get;
940: g_msg_sp_calc_dct7 := g_sp_calc_dct7;
941: --
942: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
943: --fnd_message.set_token('DCT',g_sp_calc_dct8);
944: --g_msg_sp_calc_dct8 := fnd_message.get;
945: g_msg_sp_calc_dct8 := g_sp_calc_dct8;
946: --
947: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
940: g_msg_sp_calc_dct7 := g_sp_calc_dct7;
941: --
942: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
943: --fnd_message.set_token('DCT',g_sp_calc_dct8);
944: --g_msg_sp_calc_dct8 := fnd_message.get;
945: g_msg_sp_calc_dct8 := g_sp_calc_dct8;
946: --
947: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
948: --fnd_message.set_token('DCT',g_sp_calc_dct9);
943: --fnd_message.set_token('DCT',g_sp_calc_dct8);
944: --g_msg_sp_calc_dct8 := fnd_message.get;
945: g_msg_sp_calc_dct8 := g_sp_calc_dct8;
946: --
947: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
948: --fnd_message.set_token('DCT',g_sp_calc_dct9);
949: --g_msg_sp_calc_dct9 := fnd_message.get;
950: g_msg_sp_calc_dct9 := g_sp_calc_dct9;
951: --
944: --g_msg_sp_calc_dct8 := fnd_message.get;
945: g_msg_sp_calc_dct8 := g_sp_calc_dct8;
946: --
947: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
948: --fnd_message.set_token('DCT',g_sp_calc_dct9);
949: --g_msg_sp_calc_dct9 := fnd_message.get;
950: g_msg_sp_calc_dct9 := g_sp_calc_dct9;
951: --
952: end if;
945: g_msg_sp_calc_dct8 := g_sp_calc_dct8;
946: --
947: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
948: --fnd_message.set_token('DCT',g_sp_calc_dct9);
949: --g_msg_sp_calc_dct9 := fnd_message.get;
950: g_msg_sp_calc_dct9 := g_sp_calc_dct9;
951: --
952: end if;
953: --
1124: end if;
1125: --
1126: l_legislation_code := 'JP';
1127:
1128: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_OLD_CLASS_2012');
1129: g_new_old_class_2012 := fnd_message.get;
1130:
1131: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INS_PREM_2012');
1132: g_new_ins_prem_2012 := fnd_message.get;
1125: --
1126: l_legislation_code := 'JP';
1127:
1128: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_OLD_CLASS_2012');
1129: g_new_old_class_2012 := fnd_message.get;
1130:
1131: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INS_PREM_2012');
1132: g_new_ins_prem_2012 := fnd_message.get;
1133:
1127:
1128: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_OLD_CLASS_2012');
1129: g_new_old_class_2012 := fnd_message.get;
1130:
1131: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INS_PREM_2012');
1132: g_new_ins_prem_2012 := fnd_message.get;
1133:
1134: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INS_PREM_2012');
1135: g_old_ins_prem_2012 := fnd_message.get;
1128: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_OLD_CLASS_2012');
1129: g_new_old_class_2012 := fnd_message.get;
1130:
1131: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INS_PREM_2012');
1132: g_new_ins_prem_2012 := fnd_message.get;
1133:
1134: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INS_PREM_2012');
1135: g_old_ins_prem_2012 := fnd_message.get;
1136:
1130:
1131: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INS_PREM_2012');
1132: g_new_ins_prem_2012 := fnd_message.get;
1133:
1134: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INS_PREM_2012');
1135: g_old_ins_prem_2012 := fnd_message.get;
1136:
1137: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_DEDN_INS_2012');
1138: g_new_dedn_ins_2012 := fnd_message.get;
1131: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INS_PREM_2012');
1132: g_new_ins_prem_2012 := fnd_message.get;
1133:
1134: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INS_PREM_2012');
1135: g_old_ins_prem_2012 := fnd_message.get;
1136:
1137: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_DEDN_INS_2012');
1138: g_new_dedn_ins_2012 := fnd_message.get;
1139:
1133:
1134: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INS_PREM_2012');
1135: g_old_ins_prem_2012 := fnd_message.get;
1136:
1137: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_DEDN_INS_2012');
1138: g_new_dedn_ins_2012 := fnd_message.get;
1139:
1140: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_DEDN_INS_2012');
1141: g_old_dedn_ins_2012 := fnd_message.get;
1134: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INS_PREM_2012');
1135: g_old_ins_prem_2012 := fnd_message.get;
1136:
1137: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_DEDN_INS_2012');
1138: g_new_dedn_ins_2012 := fnd_message.get;
1139:
1140: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_DEDN_INS_2012');
1141: g_old_dedn_ins_2012 := fnd_message.get;
1142:
1136:
1137: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_DEDN_INS_2012');
1138: g_new_dedn_ins_2012 := fnd_message.get;
1139:
1140: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_DEDN_INS_2012');
1141: g_old_dedn_ins_2012 := fnd_message.get;
1142:
1143: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_INS_2012');
1144: g_tot_ins_2012 := fnd_message.get;
1137: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_DEDN_INS_2012');
1138: g_new_dedn_ins_2012 := fnd_message.get;
1139:
1140: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_DEDN_INS_2012');
1141: g_old_dedn_ins_2012 := fnd_message.get;
1142:
1143: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_INS_2012');
1144: g_tot_ins_2012 := fnd_message.get;
1145:
1139:
1140: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_DEDN_INS_2012');
1141: g_old_dedn_ins_2012 := fnd_message.get;
1142:
1143: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_INS_2012');
1144: g_tot_ins_2012 := fnd_message.get;
1145:
1146: fnd_message.set_name('PAY','PAY_JP_ISDF_FIN_INS_2012');
1147: g_fin_ins_2012 := fnd_message.get;
1140: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_DEDN_INS_2012');
1141: g_old_dedn_ins_2012 := fnd_message.get;
1142:
1143: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_INS_2012');
1144: g_tot_ins_2012 := fnd_message.get;
1145:
1146: fnd_message.set_name('PAY','PAY_JP_ISDF_FIN_INS_2012');
1147: g_fin_ins_2012 := fnd_message.get;
1148:
1142:
1143: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_INS_2012');
1144: g_tot_ins_2012 := fnd_message.get;
1145:
1146: fnd_message.set_name('PAY','PAY_JP_ISDF_FIN_INS_2012');
1147: g_fin_ins_2012 := fnd_message.get;
1148:
1149: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_PREM_2012');
1150: g_cmi_prem_2012 := fnd_message.get;
1143: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_INS_2012');
1144: g_tot_ins_2012 := fnd_message.get;
1145:
1146: fnd_message.set_name('PAY','PAY_JP_ISDF_FIN_INS_2012');
1147: g_fin_ins_2012 := fnd_message.get;
1148:
1149: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_PREM_2012');
1150: g_cmi_prem_2012 := fnd_message.get;
1151:
1145:
1146: fnd_message.set_name('PAY','PAY_JP_ISDF_FIN_INS_2012');
1147: g_fin_ins_2012 := fnd_message.get;
1148:
1149: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_PREM_2012');
1150: g_cmi_prem_2012 := fnd_message.get;
1151:
1152: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_DEDN_2012');
1153: g_cmi_dedn_2012 := fnd_message.get;
1146: fnd_message.set_name('PAY','PAY_JP_ISDF_FIN_INS_2012');
1147: g_fin_ins_2012 := fnd_message.get;
1148:
1149: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_PREM_2012');
1150: g_cmi_prem_2012 := fnd_message.get;
1151:
1152: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_DEDN_2012');
1153: g_cmi_dedn_2012 := fnd_message.get;
1154:
1148:
1149: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_PREM_2012');
1150: g_cmi_prem_2012 := fnd_message.get;
1151:
1152: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_DEDN_2012');
1153: g_cmi_dedn_2012 := fnd_message.get;
1154:
1155: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_TOT_2012');
1156: g_cmi_tot_2012 := fnd_message.get;
1149: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_PREM_2012');
1150: g_cmi_prem_2012 := fnd_message.get;
1151:
1152: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_DEDN_2012');
1153: g_cmi_dedn_2012 := fnd_message.get;
1154:
1155: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_TOT_2012');
1156: g_cmi_tot_2012 := fnd_message.get;
1157:
1151:
1152: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_DEDN_2012');
1153: g_cmi_dedn_2012 := fnd_message.get;
1154:
1155: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_TOT_2012');
1156: g_cmi_tot_2012 := fnd_message.get;
1157:
1158: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_DEDN_PENS_2012');
1159: g_new_dedn_pens_2012 := fnd_message.get;
1152: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_DEDN_2012');
1153: g_cmi_dedn_2012 := fnd_message.get;
1154:
1155: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_TOT_2012');
1156: g_cmi_tot_2012 := fnd_message.get;
1157:
1158: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_DEDN_PENS_2012');
1159: g_new_dedn_pens_2012 := fnd_message.get;
1160:
1154:
1155: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_TOT_2012');
1156: g_cmi_tot_2012 := fnd_message.get;
1157:
1158: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_DEDN_PENS_2012');
1159: g_new_dedn_pens_2012 := fnd_message.get;
1160:
1161: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_DEDN_PENS_2012');
1162: g_old_dedn_pens_2012 := fnd_message.get;
1155: fnd_message.set_name('PAY','PAY_JP_ISDF_CMI_TOT_2012');
1156: g_cmi_tot_2012 := fnd_message.get;
1157:
1158: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_DEDN_PENS_2012');
1159: g_new_dedn_pens_2012 := fnd_message.get;
1160:
1161: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_DEDN_PENS_2012');
1162: g_old_dedn_pens_2012 := fnd_message.get;
1163:
1157:
1158: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_DEDN_PENS_2012');
1159: g_new_dedn_pens_2012 := fnd_message.get;
1160:
1161: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_DEDN_PENS_2012');
1162: g_old_dedn_pens_2012 := fnd_message.get;
1163:
1164: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_PENS_2012');
1165: g_tot_pens_2012 := fnd_message.get;
1158: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_DEDN_PENS_2012');
1159: g_new_dedn_pens_2012 := fnd_message.get;
1160:
1161: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_DEDN_PENS_2012');
1162: g_old_dedn_pens_2012 := fnd_message.get;
1163:
1164: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_PENS_2012');
1165: g_tot_pens_2012 := fnd_message.get;
1166:
1160:
1161: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_DEDN_PENS_2012');
1162: g_old_dedn_pens_2012 := fnd_message.get;
1163:
1164: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_PENS_2012');
1165: g_tot_pens_2012 := fnd_message.get;
1166:
1167: fnd_message.set_name('PAY','PAY_JP_ISDF_FIN_PENS_2012');
1168: g_fin_pens_2012 := fnd_message.get;
1161: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_DEDN_PENS_2012');
1162: g_old_dedn_pens_2012 := fnd_message.get;
1163:
1164: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_PENS_2012');
1165: g_tot_pens_2012 := fnd_message.get;
1166:
1167: fnd_message.set_name('PAY','PAY_JP_ISDF_FIN_PENS_2012');
1168: g_fin_pens_2012 := fnd_message.get;
1169:
1163:
1164: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_PENS_2012');
1165: g_tot_pens_2012 := fnd_message.get;
1166:
1167: fnd_message.set_name('PAY','PAY_JP_ISDF_FIN_PENS_2012');
1168: g_fin_pens_2012 := fnd_message.get;
1169:
1170: fnd_message.set_name('PAY','PAY_JP_ISDF_PENS_TOT_2012');
1171: g_pens_tot_2012 := fnd_message.get;
1164: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_PENS_2012');
1165: g_tot_pens_2012 := fnd_message.get;
1166:
1167: fnd_message.set_name('PAY','PAY_JP_ISDF_FIN_PENS_2012');
1168: g_fin_pens_2012 := fnd_message.get;
1169:
1170: fnd_message.set_name('PAY','PAY_JP_ISDF_PENS_TOT_2012');
1171: g_pens_tot_2012 := fnd_message.get;
1172:
1166:
1167: fnd_message.set_name('PAY','PAY_JP_ISDF_FIN_PENS_2012');
1168: g_fin_pens_2012 := fnd_message.get;
1169:
1170: fnd_message.set_name('PAY','PAY_JP_ISDF_PENS_TOT_2012');
1171: g_pens_tot_2012 := fnd_message.get;
1172:
1173: fnd_message.set_name('PAY','PAY_JP_ISDF_LIFE_TAB_NEW_2012');
1174: g_life_tab_new_2012 := fnd_message.get;
1167: fnd_message.set_name('PAY','PAY_JP_ISDF_FIN_PENS_2012');
1168: g_fin_pens_2012 := fnd_message.get;
1169:
1170: fnd_message.set_name('PAY','PAY_JP_ISDF_PENS_TOT_2012');
1171: g_pens_tot_2012 := fnd_message.get;
1172:
1173: fnd_message.set_name('PAY','PAY_JP_ISDF_LIFE_TAB_NEW_2012');
1174: g_life_tab_new_2012 := fnd_message.get;
1175:
1169:
1170: fnd_message.set_name('PAY','PAY_JP_ISDF_PENS_TOT_2012');
1171: g_pens_tot_2012 := fnd_message.get;
1172:
1173: fnd_message.set_name('PAY','PAY_JP_ISDF_LIFE_TAB_NEW_2012');
1174: g_life_tab_new_2012 := fnd_message.get;
1175:
1176: fnd_message.set_name('PAY','PAY_JP_ISDF_COL1_NEW_2012');
1177: g_col1_new_2012 := fnd_message.get;
1170: fnd_message.set_name('PAY','PAY_JP_ISDF_PENS_TOT_2012');
1171: g_pens_tot_2012 := fnd_message.get;
1172:
1173: fnd_message.set_name('PAY','PAY_JP_ISDF_LIFE_TAB_NEW_2012');
1174: g_life_tab_new_2012 := fnd_message.get;
1175:
1176: fnd_message.set_name('PAY','PAY_JP_ISDF_COL1_NEW_2012');
1177: g_col1_new_2012 := fnd_message.get;
1178:
1172:
1173: fnd_message.set_name('PAY','PAY_JP_ISDF_LIFE_TAB_NEW_2012');
1174: g_life_tab_new_2012 := fnd_message.get;
1175:
1176: fnd_message.set_name('PAY','PAY_JP_ISDF_COL1_NEW_2012');
1177: g_col1_new_2012 := fnd_message.get;
1178:
1179: fnd_message.set_name('PAY','PAY_JP_ISDF_FORM_DEDN_AMT_2012');
1180: g_form_dedn_amt_2012 := fnd_message.get;
1173: fnd_message.set_name('PAY','PAY_JP_ISDF_LIFE_TAB_NEW_2012');
1174: g_life_tab_new_2012 := fnd_message.get;
1175:
1176: fnd_message.set_name('PAY','PAY_JP_ISDF_COL1_NEW_2012');
1177: g_col1_new_2012 := fnd_message.get;
1178:
1179: fnd_message.set_name('PAY','PAY_JP_ISDF_FORM_DEDN_AMT_2012');
1180: g_form_dedn_amt_2012 := fnd_message.get;
1181:
1175:
1176: fnd_message.set_name('PAY','PAY_JP_ISDF_COL1_NEW_2012');
1177: g_col1_new_2012 := fnd_message.get;
1178:
1179: fnd_message.set_name('PAY','PAY_JP_ISDF_FORM_DEDN_AMT_2012');
1180: g_form_dedn_amt_2012 := fnd_message.get;
1181:
1182: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL2_2012');
1183: g_row1_col2_2012 := fnd_message.get;
1176: fnd_message.set_name('PAY','PAY_JP_ISDF_COL1_NEW_2012');
1177: g_col1_new_2012 := fnd_message.get;
1178:
1179: fnd_message.set_name('PAY','PAY_JP_ISDF_FORM_DEDN_AMT_2012');
1180: g_form_dedn_amt_2012 := fnd_message.get;
1181:
1182: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL2_2012');
1183: g_row1_col2_2012 := fnd_message.get;
1184:
1178:
1179: fnd_message.set_name('PAY','PAY_JP_ISDF_FORM_DEDN_AMT_2012');
1180: g_form_dedn_amt_2012 := fnd_message.get;
1181:
1182: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL2_2012');
1183: g_row1_col2_2012 := fnd_message.get;
1184:
1185: fnd_message.set_name('PAY','PAY_JP_ISDF_LIFE_TAB_OLD_2012');
1186: g_life_tab_old_2012 := fnd_message.get;
1179: fnd_message.set_name('PAY','PAY_JP_ISDF_FORM_DEDN_AMT_2012');
1180: g_form_dedn_amt_2012 := fnd_message.get;
1181:
1182: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL2_2012');
1183: g_row1_col2_2012 := fnd_message.get;
1184:
1185: fnd_message.set_name('PAY','PAY_JP_ISDF_LIFE_TAB_OLD_2012');
1186: g_life_tab_old_2012 := fnd_message.get;
1187:
1181:
1182: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL2_2012');
1183: g_row1_col2_2012 := fnd_message.get;
1184:
1185: fnd_message.set_name('PAY','PAY_JP_ISDF_LIFE_TAB_OLD_2012');
1186: g_life_tab_old_2012 := fnd_message.get;
1187:
1188: fnd_message.set_name('PAY','PAY_JP_ISDF_COL3_NEW_2012');
1189: g_col3_new_2012 := fnd_message.get;
1182: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL2_2012');
1183: g_row1_col2_2012 := fnd_message.get;
1184:
1185: fnd_message.set_name('PAY','PAY_JP_ISDF_LIFE_TAB_OLD_2012');
1186: g_life_tab_old_2012 := fnd_message.get;
1187:
1188: fnd_message.set_name('PAY','PAY_JP_ISDF_COL3_NEW_2012');
1189: g_col3_new_2012 := fnd_message.get;
1190:
1184:
1185: fnd_message.set_name('PAY','PAY_JP_ISDF_LIFE_TAB_OLD_2012');
1186: g_life_tab_old_2012 := fnd_message.get;
1187:
1188: fnd_message.set_name('PAY','PAY_JP_ISDF_COL3_NEW_2012');
1189: g_col3_new_2012 := fnd_message.get;
1190:
1191: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL4_2012');
1192: g_row1_col4_2012 := fnd_message.get;
1185: fnd_message.set_name('PAY','PAY_JP_ISDF_LIFE_TAB_OLD_2012');
1186: g_life_tab_old_2012 := fnd_message.get;
1187:
1188: fnd_message.set_name('PAY','PAY_JP_ISDF_COL3_NEW_2012');
1189: g_col3_new_2012 := fnd_message.get;
1190:
1191: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL4_2012');
1192: g_row1_col4_2012 := fnd_message.get;
1193:
1187:
1188: fnd_message.set_name('PAY','PAY_JP_ISDF_COL3_NEW_2012');
1189: g_col3_new_2012 := fnd_message.get;
1190:
1191: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL4_2012');
1192: g_row1_col4_2012 := fnd_message.get;
1193:
1194: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_LID_2012');
1195: g_tot_lid_2012 := fnd_message.get;
1188: fnd_message.set_name('PAY','PAY_JP_ISDF_COL3_NEW_2012');
1189: g_col3_new_2012 := fnd_message.get;
1190:
1191: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL4_2012');
1192: g_row1_col4_2012 := fnd_message.get;
1193:
1194: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_LID_2012');
1195: g_tot_lid_2012 := fnd_message.get;
1196:
1190:
1191: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL4_2012');
1192: g_row1_col4_2012 := fnd_message.get;
1193:
1194: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_LID_2012');
1195: g_tot_lid_2012 := fnd_message.get;
1196:
1197: fnd_message.set_name('PAY','PAY_JP_ISDF_CORP_TYPE_2012');
1198: g_corp_type_2012 := fnd_message.get;
1191: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL4_2012');
1192: g_row1_col4_2012 := fnd_message.get;
1193:
1194: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_LID_2012');
1195: g_tot_lid_2012 := fnd_message.get;
1196:
1197: fnd_message.set_name('PAY','PAY_JP_ISDF_CORP_TYPE_2012');
1198: g_corp_type_2012 := fnd_message.get;
1199:
1193:
1194: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_LID_2012');
1195: g_tot_lid_2012 := fnd_message.get;
1196:
1197: fnd_message.set_name('PAY','PAY_JP_ISDF_CORP_TYPE_2012');
1198: g_corp_type_2012 := fnd_message.get;
1199:
1200: -- messages for new table
1201: --
1194: fnd_message.set_name('PAY','PAY_JP_ISDF_TOT_LID_2012');
1195: g_tot_lid_2012 := fnd_message.get;
1196:
1197: fnd_message.set_name('PAY','PAY_JP_ISDF_CORP_TYPE_2012');
1198: g_corp_type_2012 := fnd_message.get;
1199:
1200: -- messages for new table
1201: --
1202: open csr_udt_row(c_life_gen_new_calc_udt,c_st_upd_date_2012);
1294: --
1295: end loop;
1296: close csr_udt_row;
1297:
1298: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
1299: fnd_message.set_token('RANGE_B',g_new_life_range1b);
1300: g_new_life_range1 := fnd_message.get;
1301: --
1302: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1295: end loop;
1296: close csr_udt_row;
1297:
1298: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
1299: fnd_message.set_token('RANGE_B',g_new_life_range1b);
1300: g_new_life_range1 := fnd_message.get;
1301: --
1302: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1303: fnd_message.set_token('RANGE_A',g_new_life_range2a);
1296: close csr_udt_row;
1297:
1298: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
1299: fnd_message.set_token('RANGE_B',g_new_life_range1b);
1300: g_new_life_range1 := fnd_message.get;
1301: --
1302: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1303: fnd_message.set_token('RANGE_A',g_new_life_range2a);
1304: fnd_message.set_token('RANGE_B',g_new_life_range2b);
1298: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
1299: fnd_message.set_token('RANGE_B',g_new_life_range1b);
1300: g_new_life_range1 := fnd_message.get;
1301: --
1302: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1303: fnd_message.set_token('RANGE_A',g_new_life_range2a);
1304: fnd_message.set_token('RANGE_B',g_new_life_range2b);
1305: g_new_life_range2 := fnd_message.get;
1306: --
1299: fnd_message.set_token('RANGE_B',g_new_life_range1b);
1300: g_new_life_range1 := fnd_message.get;
1301: --
1302: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1303: fnd_message.set_token('RANGE_A',g_new_life_range2a);
1304: fnd_message.set_token('RANGE_B',g_new_life_range2b);
1305: g_new_life_range2 := fnd_message.get;
1306: --
1307: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1300: g_new_life_range1 := fnd_message.get;
1301: --
1302: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1303: fnd_message.set_token('RANGE_A',g_new_life_range2a);
1304: fnd_message.set_token('RANGE_B',g_new_life_range2b);
1305: g_new_life_range2 := fnd_message.get;
1306: --
1307: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1308: fnd_message.set_token('RANGE_A',g_new_life_range3a);
1301: --
1302: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1303: fnd_message.set_token('RANGE_A',g_new_life_range2a);
1304: fnd_message.set_token('RANGE_B',g_new_life_range2b);
1305: g_new_life_range2 := fnd_message.get;
1306: --
1307: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1308: fnd_message.set_token('RANGE_A',g_new_life_range3a);
1309: fnd_message.set_token('RANGE_B',g_new_life_range3b);
1303: fnd_message.set_token('RANGE_A',g_new_life_range2a);
1304: fnd_message.set_token('RANGE_B',g_new_life_range2b);
1305: g_new_life_range2 := fnd_message.get;
1306: --
1307: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1308: fnd_message.set_token('RANGE_A',g_new_life_range3a);
1309: fnd_message.set_token('RANGE_B',g_new_life_range3b);
1310: g_new_life_range3 := fnd_message.get;
1311: --
1304: fnd_message.set_token('RANGE_B',g_new_life_range2b);
1305: g_new_life_range2 := fnd_message.get;
1306: --
1307: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1308: fnd_message.set_token('RANGE_A',g_new_life_range3a);
1309: fnd_message.set_token('RANGE_B',g_new_life_range3b);
1310: g_new_life_range3 := fnd_message.get;
1311: --
1312: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
1305: g_new_life_range2 := fnd_message.get;
1306: --
1307: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1308: fnd_message.set_token('RANGE_A',g_new_life_range3a);
1309: fnd_message.set_token('RANGE_B',g_new_life_range3b);
1310: g_new_life_range3 := fnd_message.get;
1311: --
1312: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
1313: fnd_message.set_token('RANGE_A',g_new_life_range4a);
1306: --
1307: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1308: fnd_message.set_token('RANGE_A',g_new_life_range3a);
1309: fnd_message.set_token('RANGE_B',g_new_life_range3b);
1310: g_new_life_range3 := fnd_message.get;
1311: --
1312: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
1313: fnd_message.set_token('RANGE_A',g_new_life_range4a);
1314: g_new_life_range4 := fnd_message.get;
1308: fnd_message.set_token('RANGE_A',g_new_life_range3a);
1309: fnd_message.set_token('RANGE_B',g_new_life_range3b);
1310: g_new_life_range3 := fnd_message.get;
1311: --
1312: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
1313: fnd_message.set_token('RANGE_A',g_new_life_range4a);
1314: g_new_life_range4 := fnd_message.get;
1315: --
1316: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL2_2012');
1309: fnd_message.set_token('RANGE_B',g_new_life_range3b);
1310: g_new_life_range3 := fnd_message.get;
1311: --
1312: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
1313: fnd_message.set_token('RANGE_A',g_new_life_range4a);
1314: g_new_life_range4 := fnd_message.get;
1315: --
1316: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL2_2012');
1317: g_new_life_calc1 := fnd_message.get;
1310: g_new_life_range3 := fnd_message.get;
1311: --
1312: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
1313: fnd_message.set_token('RANGE_A',g_new_life_range4a);
1314: g_new_life_range4 := fnd_message.get;
1315: --
1316: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL2_2012');
1317: g_new_life_calc1 := fnd_message.get;
1318: --
1312: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
1313: fnd_message.set_token('RANGE_A',g_new_life_range4a);
1314: g_new_life_range4 := fnd_message.get;
1315: --
1316: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL2_2012');
1317: g_new_life_calc1 := fnd_message.get;
1318: --
1319: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INDX_2012');
1320: fnd_message.set_token('CALC',g_new_life_calc2a);
1313: fnd_message.set_token('RANGE_A',g_new_life_range4a);
1314: g_new_life_range4 := fnd_message.get;
1315: --
1316: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL2_2012');
1317: g_new_life_calc1 := fnd_message.get;
1318: --
1319: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INDX_2012');
1320: fnd_message.set_token('CALC',g_new_life_calc2a);
1321: g_new_life_calc2 := fnd_message.get;
1315: --
1316: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL2_2012');
1317: g_new_life_calc1 := fnd_message.get;
1318: --
1319: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INDX_2012');
1320: fnd_message.set_token('CALC',g_new_life_calc2a);
1321: g_new_life_calc2 := fnd_message.get;
1322: --
1323: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INDX_2012');
1316: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL2_2012');
1317: g_new_life_calc1 := fnd_message.get;
1318: --
1319: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INDX_2012');
1320: fnd_message.set_token('CALC',g_new_life_calc2a);
1321: g_new_life_calc2 := fnd_message.get;
1322: --
1323: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INDX_2012');
1324: fnd_message.set_token('CALC',g_new_life_calc3a);
1317: g_new_life_calc1 := fnd_message.get;
1318: --
1319: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INDX_2012');
1320: fnd_message.set_token('CALC',g_new_life_calc2a);
1321: g_new_life_calc2 := fnd_message.get;
1322: --
1323: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INDX_2012');
1324: fnd_message.set_token('CALC',g_new_life_calc3a);
1325: g_new_life_calc3 := fnd_message.get;
1319: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INDX_2012');
1320: fnd_message.set_token('CALC',g_new_life_calc2a);
1321: g_new_life_calc2 := fnd_message.get;
1322: --
1323: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INDX_2012');
1324: fnd_message.set_token('CALC',g_new_life_calc3a);
1325: g_new_life_calc3 := fnd_message.get;
1326: --
1327: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
1320: fnd_message.set_token('CALC',g_new_life_calc2a);
1321: g_new_life_calc2 := fnd_message.get;
1322: --
1323: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INDX_2012');
1324: fnd_message.set_token('CALC',g_new_life_calc3a);
1325: g_new_life_calc3 := fnd_message.get;
1326: --
1327: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
1328: fnd_message.set_token('CALC',g_new_life_calc4a);
1321: g_new_life_calc2 := fnd_message.get;
1322: --
1323: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INDX_2012');
1324: fnd_message.set_token('CALC',g_new_life_calc3a);
1325: g_new_life_calc3 := fnd_message.get;
1326: --
1327: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
1328: fnd_message.set_token('CALC',g_new_life_calc4a);
1329: g_new_life_calc4 := fnd_message.get;
1323: fnd_message.set_name('PAY','PAY_JP_ISDF_NEW_INDX_2012');
1324: fnd_message.set_token('CALC',g_new_life_calc3a);
1325: g_new_life_calc3 := fnd_message.get;
1326: --
1327: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
1328: fnd_message.set_token('CALC',g_new_life_calc4a);
1329: g_new_life_calc4 := fnd_message.get;
1330: --
1331: -- messages for old table
1324: fnd_message.set_token('CALC',g_new_life_calc3a);
1325: g_new_life_calc3 := fnd_message.get;
1326: --
1327: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
1328: fnd_message.set_token('CALC',g_new_life_calc4a);
1329: g_new_life_calc4 := fnd_message.get;
1330: --
1331: -- messages for old table
1332: --
1325: g_new_life_calc3 := fnd_message.get;
1326: --
1327: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
1328: fnd_message.set_token('CALC',g_new_life_calc4a);
1329: g_new_life_calc4 := fnd_message.get;
1330: --
1331: -- messages for old table
1332: --
1333: open csr_udt_row(c_life_gen_calc_udt,c_st_upd_date_2012);
1425: --
1426: end loop;
1427: close csr_udt_row;
1428:
1429: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
1430: fnd_message.set_token('RANGE_B',g_old_life_range1b);
1431: g_old_life_range1 := fnd_message.get;
1432: --
1433: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1426: end loop;
1427: close csr_udt_row;
1428:
1429: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
1430: fnd_message.set_token('RANGE_B',g_old_life_range1b);
1431: g_old_life_range1 := fnd_message.get;
1432: --
1433: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1434: fnd_message.set_token('RANGE_A',g_old_life_range2a);
1427: close csr_udt_row;
1428:
1429: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
1430: fnd_message.set_token('RANGE_B',g_old_life_range1b);
1431: g_old_life_range1 := fnd_message.get;
1432: --
1433: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1434: fnd_message.set_token('RANGE_A',g_old_life_range2a);
1435: fnd_message.set_token('RANGE_B',g_old_life_range2b);
1429: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
1430: fnd_message.set_token('RANGE_B',g_old_life_range1b);
1431: g_old_life_range1 := fnd_message.get;
1432: --
1433: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1434: fnd_message.set_token('RANGE_A',g_old_life_range2a);
1435: fnd_message.set_token('RANGE_B',g_old_life_range2b);
1436: g_old_life_range2 := fnd_message.get;
1437: --
1430: fnd_message.set_token('RANGE_B',g_old_life_range1b);
1431: g_old_life_range1 := fnd_message.get;
1432: --
1433: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1434: fnd_message.set_token('RANGE_A',g_old_life_range2a);
1435: fnd_message.set_token('RANGE_B',g_old_life_range2b);
1436: g_old_life_range2 := fnd_message.get;
1437: --
1438: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1431: g_old_life_range1 := fnd_message.get;
1432: --
1433: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1434: fnd_message.set_token('RANGE_A',g_old_life_range2a);
1435: fnd_message.set_token('RANGE_B',g_old_life_range2b);
1436: g_old_life_range2 := fnd_message.get;
1437: --
1438: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1439: fnd_message.set_token('RANGE_A',g_old_life_range3a);
1432: --
1433: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1434: fnd_message.set_token('RANGE_A',g_old_life_range2a);
1435: fnd_message.set_token('RANGE_B',g_old_life_range2b);
1436: g_old_life_range2 := fnd_message.get;
1437: --
1438: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1439: fnd_message.set_token('RANGE_A',g_old_life_range3a);
1440: fnd_message.set_token('RANGE_B',g_old_life_range3b);
1434: fnd_message.set_token('RANGE_A',g_old_life_range2a);
1435: fnd_message.set_token('RANGE_B',g_old_life_range2b);
1436: g_old_life_range2 := fnd_message.get;
1437: --
1438: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1439: fnd_message.set_token('RANGE_A',g_old_life_range3a);
1440: fnd_message.set_token('RANGE_B',g_old_life_range3b);
1441: g_old_life_range3 := fnd_message.get;
1442: --
1435: fnd_message.set_token('RANGE_B',g_old_life_range2b);
1436: g_old_life_range2 := fnd_message.get;
1437: --
1438: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1439: fnd_message.set_token('RANGE_A',g_old_life_range3a);
1440: fnd_message.set_token('RANGE_B',g_old_life_range3b);
1441: g_old_life_range3 := fnd_message.get;
1442: --
1443: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
1436: g_old_life_range2 := fnd_message.get;
1437: --
1438: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1439: fnd_message.set_token('RANGE_A',g_old_life_range3a);
1440: fnd_message.set_token('RANGE_B',g_old_life_range3b);
1441: g_old_life_range3 := fnd_message.get;
1442: --
1443: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
1444: fnd_message.set_token('RANGE_A',g_old_life_range4a);
1437: --
1438: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
1439: fnd_message.set_token('RANGE_A',g_old_life_range3a);
1440: fnd_message.set_token('RANGE_B',g_old_life_range3b);
1441: g_old_life_range3 := fnd_message.get;
1442: --
1443: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
1444: fnd_message.set_token('RANGE_A',g_old_life_range4a);
1445: g_old_life_range4 := fnd_message.get;
1439: fnd_message.set_token('RANGE_A',g_old_life_range3a);
1440: fnd_message.set_token('RANGE_B',g_old_life_range3b);
1441: g_old_life_range3 := fnd_message.get;
1442: --
1443: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
1444: fnd_message.set_token('RANGE_A',g_old_life_range4a);
1445: g_old_life_range4 := fnd_message.get;
1446: --
1447: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL4_2012');
1440: fnd_message.set_token('RANGE_B',g_old_life_range3b);
1441: g_old_life_range3 := fnd_message.get;
1442: --
1443: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
1444: fnd_message.set_token('RANGE_A',g_old_life_range4a);
1445: g_old_life_range4 := fnd_message.get;
1446: --
1447: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL4_2012');
1448: g_old_life_calc1 := fnd_message.get;
1441: g_old_life_range3 := fnd_message.get;
1442: --
1443: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
1444: fnd_message.set_token('RANGE_A',g_old_life_range4a);
1445: g_old_life_range4 := fnd_message.get;
1446: --
1447: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL4_2012');
1448: g_old_life_calc1 := fnd_message.get;
1449: --
1443: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
1444: fnd_message.set_token('RANGE_A',g_old_life_range4a);
1445: g_old_life_range4 := fnd_message.get;
1446: --
1447: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL4_2012');
1448: g_old_life_calc1 := fnd_message.get;
1449: --
1450: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INDX_2012');
1451: fnd_message.set_token('CALC',g_old_life_calc2a);
1444: fnd_message.set_token('RANGE_A',g_old_life_range4a);
1445: g_old_life_range4 := fnd_message.get;
1446: --
1447: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL4_2012');
1448: g_old_life_calc1 := fnd_message.get;
1449: --
1450: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INDX_2012');
1451: fnd_message.set_token('CALC',g_old_life_calc2a);
1452: g_old_life_calc2 := fnd_message.get;
1446: --
1447: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL4_2012');
1448: g_old_life_calc1 := fnd_message.get;
1449: --
1450: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INDX_2012');
1451: fnd_message.set_token('CALC',g_old_life_calc2a);
1452: g_old_life_calc2 := fnd_message.get;
1453: --
1454: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INDX_2012');
1447: fnd_message.set_name('PAY','PAY_JP_ISDF_ROW1_COL4_2012');
1448: g_old_life_calc1 := fnd_message.get;
1449: --
1450: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INDX_2012');
1451: fnd_message.set_token('CALC',g_old_life_calc2a);
1452: g_old_life_calc2 := fnd_message.get;
1453: --
1454: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INDX_2012');
1455: fnd_message.set_token('CALC',g_old_life_calc3a);
1448: g_old_life_calc1 := fnd_message.get;
1449: --
1450: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INDX_2012');
1451: fnd_message.set_token('CALC',g_old_life_calc2a);
1452: g_old_life_calc2 := fnd_message.get;
1453: --
1454: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INDX_2012');
1455: fnd_message.set_token('CALC',g_old_life_calc3a);
1456: g_old_life_calc3 := fnd_message.get;
1450: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INDX_2012');
1451: fnd_message.set_token('CALC',g_old_life_calc2a);
1452: g_old_life_calc2 := fnd_message.get;
1453: --
1454: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INDX_2012');
1455: fnd_message.set_token('CALC',g_old_life_calc3a);
1456: g_old_life_calc3 := fnd_message.get;
1457: --
1458: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
1451: fnd_message.set_token('CALC',g_old_life_calc2a);
1452: g_old_life_calc2 := fnd_message.get;
1453: --
1454: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INDX_2012');
1455: fnd_message.set_token('CALC',g_old_life_calc3a);
1456: g_old_life_calc3 := fnd_message.get;
1457: --
1458: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
1459: fnd_message.set_token('CALC',g_old_life_calc4a);
1452: g_old_life_calc2 := fnd_message.get;
1453: --
1454: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INDX_2012');
1455: fnd_message.set_token('CALC',g_old_life_calc3a);
1456: g_old_life_calc3 := fnd_message.get;
1457: --
1458: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
1459: fnd_message.set_token('CALC',g_old_life_calc4a);
1460: g_old_life_calc4 := fnd_message.get;
1454: fnd_message.set_name('PAY','PAY_JP_ISDF_OLD_INDX_2012');
1455: fnd_message.set_token('CALC',g_old_life_calc3a);
1456: g_old_life_calc3 := fnd_message.get;
1457: --
1458: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
1459: fnd_message.set_token('CALC',g_old_life_calc4a);
1460: g_old_life_calc4 := fnd_message.get;
1461: --
1462:
1455: fnd_message.set_token('CALC',g_old_life_calc3a);
1456: g_old_life_calc3 := fnd_message.get;
1457: --
1458: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
1459: fnd_message.set_token('CALC',g_old_life_calc4a);
1460: g_old_life_calc4 := fnd_message.get;
1461: --
1462:
1463: end set_form_pg_prompt2012;
1456: g_old_life_calc3 := fnd_message.get;
1457: --
1458: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
1459: fnd_message.set_token('CALC',g_old_life_calc4a);
1460: g_old_life_calc4 := fnd_message.get;
1461: --
1462:
1463: end set_form_pg_prompt2012;
1464: --
1496: --
1497: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1498: --
1499: if l_assact_rec.transaction_status not in ('U', 'N') then
1500: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
1501: fnd_message.raise_error;
1502: end if;
1503: --
1504: if g_debug then
1497: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1498: --
1499: if l_assact_rec.transaction_status not in ('U', 'N') then
1500: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
1501: fnd_message.raise_error;
1502: end if;
1503: --
1504: if g_debug then
1505: hr_utility.set_location(l_proc,20);
1612: --
1613: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1614: --
1615: if l_assact_rec.transaction_status <> 'N' then
1616: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
1617: fnd_message.raise_error;
1618: end if;
1619: --
1620: if g_debug then
1613: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1614: --
1615: if l_assact_rec.transaction_status <> 'N' then
1616: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
1617: fnd_message.raise_error;
1618: end if;
1619: --
1620: if g_debug then
1621: hr_utility.set_location(l_proc,20);
3124: from pay_jp_isdf_assact_v
3125: where action_information_id = p_action_information_id;
3126: --
3127: if l_assact_rec.transaction_status <> 'N' then
3128: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
3129: fnd_message.raise_error;
3130: end if;
3131: --
3132: if g_debug then
3125: where action_information_id = p_action_information_id;
3126: --
3127: if l_assact_rec.transaction_status <> 'N' then
3128: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
3129: fnd_message.raise_error;
3130: end if;
3131: --
3132: if g_debug then
3133: hr_utility.set_location(l_proc,20);
3340: --
3341: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3342: --
3343: if l_assact_rec.transaction_status <> 'N' then
3344: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
3345: fnd_message.raise_error;
3346: end if;
3347: --
3348: if g_debug then
3341: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3342: --
3343: if l_assact_rec.transaction_status <> 'N' then
3344: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
3345: fnd_message.raise_error;
3346: end if;
3347: --
3348: if g_debug then
3349: hr_utility.set_location(l_proc,20);
3682: --
3683: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3684: --
3685: if l_assact_rec.transaction_status not in ('F', 'A') then
3686: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3687: fnd_message.raise_error;
3688: elsif l_assact_rec.transfer_status <> 'U' then
3689: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3690: fnd_message.raise_error;
3683: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3684: --
3685: if l_assact_rec.transaction_status not in ('F', 'A') then
3686: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3687: fnd_message.raise_error;
3688: elsif l_assact_rec.transfer_status <> 'U' then
3689: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3690: fnd_message.raise_error;
3691: end if;
3685: if l_assact_rec.transaction_status not in ('F', 'A') then
3686: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3687: fnd_message.raise_error;
3688: elsif l_assact_rec.transfer_status <> 'U' then
3689: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3690: fnd_message.raise_error;
3691: end if;
3692: --
3693: if g_debug then
3686: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3687: fnd_message.raise_error;
3688: elsif l_assact_rec.transfer_status <> 'U' then
3689: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3690: fnd_message.raise_error;
3691: end if;
3692: --
3693: if g_debug then
3694: hr_utility.set_location(l_proc,20);
3769: --
3770: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3771: --
3772: if l_assact_rec.transaction_status not in ('F', 'A') then
3773: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3774: fnd_message.raise_error;
3775: elsif l_assact_rec.transfer_status <> 'U' then
3776: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3777: fnd_message.raise_error;
3770: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3771: --
3772: if l_assact_rec.transaction_status not in ('F', 'A') then
3773: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3774: fnd_message.raise_error;
3775: elsif l_assact_rec.transfer_status <> 'U' then
3776: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3777: fnd_message.raise_error;
3778: end if;
3772: if l_assact_rec.transaction_status not in ('F', 'A') then
3773: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3774: fnd_message.raise_error;
3775: elsif l_assact_rec.transfer_status <> 'U' then
3776: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3777: fnd_message.raise_error;
3778: end if;
3779: --
3780: if g_debug then
3773: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3774: fnd_message.raise_error;
3775: elsif l_assact_rec.transfer_status <> 'U' then
3776: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3777: fnd_message.raise_error;
3778: end if;
3779: --
3780: if g_debug then
3781: hr_utility.set_location(l_proc,20);
3841: --
3842: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3843: --
3844: if l_assact_rec.transaction_status <> 'F' then
3845: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3846: fnd_message.raise_error;
3847: end if;
3848: --
3849: if g_debug then
3842: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3843: --
3844: if l_assact_rec.transaction_status <> 'F' then
3845: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3846: fnd_message.raise_error;
3847: end if;
3848: --
3849: if g_debug then
3850: hr_utility.set_location(l_proc,20);
4110: p_element_type_id => c_isdf_ins_elm_id,
4111: p_session_date => l_effective_date);
4112: --
4113: if l_ins_element_link_id is null then
4114: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
4115: fnd_message.set_token('ELE_NAME',c_isdf_ins_elm);
4116: fnd_message.raise_error;
4117: end if;
4118: --
4111: p_session_date => l_effective_date);
4112: --
4113: if l_ins_element_link_id is null then
4114: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
4115: fnd_message.set_token('ELE_NAME',c_isdf_ins_elm);
4116: fnd_message.raise_error;
4117: end if;
4118: --
4119: pay_element_entry_api.create_element_entry(
4112: --
4113: if l_ins_element_link_id is null then
4114: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
4115: fnd_message.set_token('ELE_NAME',c_isdf_ins_elm);
4116: fnd_message.raise_error;
4117: end if;
4118: --
4119: pay_element_entry_api.create_element_entry(
4120: p_validate => false,
4186: p_element_type_id => c_isdf_is_elm_id,
4187: p_session_date => l_effective_date);
4188: --
4189: if l_is_element_link_id is null then
4190: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
4191: fnd_message.set_token('ELE_NAME',c_isdf_is_elm);
4192: fnd_message.raise_error;
4193: end if;
4194: --
4187: p_session_date => l_effective_date);
4188: --
4189: if l_is_element_link_id is null then
4190: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
4191: fnd_message.set_token('ELE_NAME',c_isdf_is_elm);
4192: fnd_message.raise_error;
4193: end if;
4194: --
4195: pay_element_entry_api.create_element_entry(
4188: --
4189: if l_is_element_link_id is null then
4190: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
4191: fnd_message.set_token('ELE_NAME',c_isdf_is_elm);
4192: fnd_message.raise_error;
4193: end if;
4194: --
4195: pay_element_entry_api.create_element_entry(
4196: p_validate => false,
4328: p_element_type_id => c_isdf_ins_elm_id,
4329: p_session_date => l_effective_date);
4330: --
4331: if l_ins_element_link_id is null then
4332: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
4333: fnd_message.set_token('ELE_NAME',c_isdf_ins_elm);
4334: fnd_message.raise_error;
4335: end if;
4336: --
4329: p_session_date => l_effective_date);
4330: --
4331: if l_ins_element_link_id is null then
4332: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
4333: fnd_message.set_token('ELE_NAME',c_isdf_ins_elm);
4334: fnd_message.raise_error;
4335: end if;
4336: --
4337: pay_element_entry_api.create_element_entry(
4330: --
4331: if l_ins_element_link_id is null then
4332: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
4333: fnd_message.set_token('ELE_NAME',c_isdf_ins_elm);
4334: fnd_message.raise_error;
4335: end if;
4336: --
4337: pay_element_entry_api.create_element_entry(
4338: p_validate => false,
4414: p_element_type_id => c_isdf_is_elm_id,
4415: p_session_date => l_effective_date);
4416: --
4417: if l_is_element_link_id is null then
4418: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
4419: fnd_message.set_token('ELE_NAME',c_isdf_is_elm);
4420: fnd_message.raise_error;
4421: end if;
4422: --
4415: p_session_date => l_effective_date);
4416: --
4417: if l_is_element_link_id is null then
4418: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
4419: fnd_message.set_token('ELE_NAME',c_isdf_is_elm);
4420: fnd_message.raise_error;
4421: end if;
4422: --
4423: pay_element_entry_api.create_element_entry(
4416: --
4417: if l_is_element_link_id is null then
4418: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
4419: fnd_message.set_token('ELE_NAME',c_isdf_is_elm);
4420: fnd_message.raise_error;
4421: end if;
4422: --
4423: pay_element_entry_api.create_element_entry(
4424: p_validate => false,
5406: --
5407: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
5408: --
5409: if l_assact_rec.transaction_status <> 'A' then
5410: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
5411: fnd_message.raise_error;
5412: elsif l_assact_rec.transfer_status <> 'U' then
5413: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
5414: fnd_message.raise_error;
5407: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
5408: --
5409: if l_assact_rec.transaction_status <> 'A' then
5410: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
5411: fnd_message.raise_error;
5412: elsif l_assact_rec.transfer_status <> 'U' then
5413: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
5414: fnd_message.raise_error;
5415: end if;
5409: if l_assact_rec.transaction_status <> 'A' then
5410: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
5411: fnd_message.raise_error;
5412: elsif l_assact_rec.transfer_status <> 'U' then
5413: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
5414: fnd_message.raise_error;
5415: end if;
5416: --
5417: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;
5410: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
5411: fnd_message.raise_error;
5412: elsif l_assact_rec.transfer_status <> 'U' then
5413: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
5414: fnd_message.raise_error;
5415: end if;
5416: --
5417: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;
5418: l_dec_first_date := trunc(l_year_end_date,'MM');
5428: -- but basically transfer should be done after archive process date.
5429: if l_effective_date < l_assact_rec.effective_date
5430: or l_effective_date < l_dec_first_date
5431: or l_effective_date > l_year_end_date then
5432: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
5433: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
5434: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
5435: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
5436: fnd_message.raise_error;
5429: if l_effective_date < l_assact_rec.effective_date
5430: or l_effective_date < l_dec_first_date
5431: or l_effective_date > l_year_end_date then
5432: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
5433: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
5434: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
5435: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
5436: fnd_message.raise_error;
5437: end if;
5430: or l_effective_date < l_dec_first_date
5431: or l_effective_date > l_year_end_date then
5432: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
5433: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
5434: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
5435: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
5436: fnd_message.raise_error;
5437: end if;
5438: --
5431: or l_effective_date > l_year_end_date then
5432: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
5433: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
5434: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
5435: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
5436: fnd_message.raise_error;
5437: end if;
5438: --
5439: -- for api use
5432: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
5433: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
5434: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
5435: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
5436: fnd_message.raise_error;
5437: end if;
5438: --
5439: -- for api use
5440: if p_create_session then
5609: --
5610: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
5611: --
5612: if l_assact_rec.transaction_status = 'U' then
5613: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
5614: fnd_message.raise_error;
5615: elsif l_assact_rec.transfer_status = 'E' then
5616: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
5617: fnd_message.raise_error;
5610: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
5611: --
5612: if l_assact_rec.transaction_status = 'U' then
5613: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
5614: fnd_message.raise_error;
5615: elsif l_assact_rec.transfer_status = 'E' then
5616: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
5617: fnd_message.raise_error;
5618: end if;
5612: if l_assact_rec.transaction_status = 'U' then
5613: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
5614: fnd_message.raise_error;
5615: elsif l_assact_rec.transfer_status = 'E' then
5616: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
5617: fnd_message.raise_error;
5618: end if;
5619: --
5620: if g_debug then
5613: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
5614: fnd_message.raise_error;
5615: elsif l_assact_rec.transfer_status = 'E' then
5616: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
5617: fnd_message.raise_error;
5618: end if;
5619: --
5620: if g_debug then
5621: hr_utility.set_location(l_proc,20);
5634: -- (transfer_date is always set since transfer_status check has been done)
5635: if p_expiry_date < l_assact_rec.effective_date
5636: or p_expiry_date < l_assact_rec.transfer_date
5637: or p_expiry_date > l_year_end_date then
5638: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_EXP_DATE');
5639: fnd_message.set_token('TRANSFER_DATE', fnd_date.date_to_chardate(l_assact_rec.transfer_date));
5640: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
5641: fnd_message.raise_error;
5642: end if;
5635: if p_expiry_date < l_assact_rec.effective_date
5636: or p_expiry_date < l_assact_rec.transfer_date
5637: or p_expiry_date > l_year_end_date then
5638: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_EXP_DATE');
5639: fnd_message.set_token('TRANSFER_DATE', fnd_date.date_to_chardate(l_assact_rec.transfer_date));
5640: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
5641: fnd_message.raise_error;
5642: end if;
5643: --
5636: or p_expiry_date < l_assact_rec.transfer_date
5637: or p_expiry_date > l_year_end_date then
5638: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_EXP_DATE');
5639: fnd_message.set_token('TRANSFER_DATE', fnd_date.date_to_chardate(l_assact_rec.transfer_date));
5640: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
5641: fnd_message.raise_error;
5642: end if;
5643: --
5644: -- l_dec_first_date or effective_date <= l_transfer_date <= l_year_end_date
5637: or p_expiry_date > l_year_end_date then
5638: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_EXP_DATE');
5639: fnd_message.set_token('TRANSFER_DATE', fnd_date.date_to_chardate(l_assact_rec.transfer_date));
5640: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
5641: fnd_message.raise_error;
5642: end if;
5643: --
5644: -- l_dec_first_date or effective_date <= l_transfer_date <= l_year_end_date
5645: -- l_transfer_date <= l_expirty_date <= l_year_end_date
5765: --
5766: if sqlcode = -20001 then
5767: --
5768: declare
5769: l_sqlerrm varchar2(2000) := fnd_message.get;
5770: begin
5771: if l_sqlerrm is not null then
5772: return l_sqlerrm;
5773: else