59: fetch csr_pact into l_csr_pact;
60: close csr_pact;
61: --
62: if l_csr_pact.submission_period_status = 'C' then
63: fnd_message.set_name('PAY','PAY_JP_DEF_PERIOD_CLOSED');
64: fnd_message.raise_error;
65: end if;
66: --
67: l_submission_date := sysdate;
60: close csr_pact;
61: --
62: if l_csr_pact.submission_period_status = 'C' then
63: fnd_message.set_name('PAY','PAY_JP_DEF_PERIOD_CLOSED');
64: fnd_message.raise_error;
65: end if;
66: --
67: l_submission_date := sysdate;
68: --
66: --
67: l_submission_date := sysdate;
68: --
69: if l_submission_date < nvl(l_csr_pact.submission_start_date,l_submission_date) then
70: fnd_message.set_name('PAY','PAY_JP_DEF_PERIOD_NOT_STARTED');
71: fnd_message.raise_error;
72: end if;
73: --
74: if l_submission_date > nvl(l_csr_pact.submission_end_date,l_submission_date) then
67: l_submission_date := sysdate;
68: --
69: if l_submission_date < nvl(l_csr_pact.submission_start_date,l_submission_date) then
70: fnd_message.set_name('PAY','PAY_JP_DEF_PERIOD_NOT_STARTED');
71: fnd_message.raise_error;
72: end if;
73: --
74: if l_submission_date > nvl(l_csr_pact.submission_end_date,l_submission_date) then
75: fnd_message.set_name('PAY','PAY_JP_DEF_PERIOD_EXPIRED');
71: fnd_message.raise_error;
72: end if;
73: --
74: if l_submission_date > nvl(l_csr_pact.submission_end_date,l_submission_date) then
75: fnd_message.set_name('PAY','PAY_JP_DEF_PERIOD_EXPIRED');
76: fnd_message.raise_error;
77: end if;
78: --
79: return l_submission_date;
72: end if;
73: --
74: if l_submission_date > nvl(l_csr_pact.submission_end_date,l_submission_date) then
75: fnd_message.set_name('PAY','PAY_JP_DEF_PERIOD_EXPIRED');
76: fnd_message.raise_error;
77: end if;
78: --
79: return l_submission_date;
80: --
737: g_sp_calc_dct9 := to_char(to_number(g_sp_calc_dct9),fnd_currency.get_format_mask('JPY',40));
738: --
739: end if;
740: --
741: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
742: fnd_message.set_token('RANGE_B',g_life_range1b);
743: g_msg_life_range1 := fnd_message.get;
744: --
745: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
738: --
739: end if;
740: --
741: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
742: fnd_message.set_token('RANGE_B',g_life_range1b);
743: g_msg_life_range1 := fnd_message.get;
744: --
745: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
746: fnd_message.set_token('RANGE_A',g_life_range2a);
739: end if;
740: --
741: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
742: fnd_message.set_token('RANGE_B',g_life_range1b);
743: g_msg_life_range1 := fnd_message.get;
744: --
745: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
746: fnd_message.set_token('RANGE_A',g_life_range2a);
747: fnd_message.set_token('RANGE_B',g_life_range2b);
741: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_FIRST');
742: fnd_message.set_token('RANGE_B',g_life_range1b);
743: g_msg_life_range1 := fnd_message.get;
744: --
745: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
746: fnd_message.set_token('RANGE_A',g_life_range2a);
747: fnd_message.set_token('RANGE_B',g_life_range2b);
748: g_msg_life_range2 := fnd_message.get;
749: --
742: fnd_message.set_token('RANGE_B',g_life_range1b);
743: g_msg_life_range1 := fnd_message.get;
744: --
745: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
746: fnd_message.set_token('RANGE_A',g_life_range2a);
747: fnd_message.set_token('RANGE_B',g_life_range2b);
748: g_msg_life_range2 := fnd_message.get;
749: --
750: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
743: g_msg_life_range1 := fnd_message.get;
744: --
745: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
746: fnd_message.set_token('RANGE_A',g_life_range2a);
747: fnd_message.set_token('RANGE_B',g_life_range2b);
748: g_msg_life_range2 := 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_range3a);
744: --
745: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
746: fnd_message.set_token('RANGE_A',g_life_range2a);
747: fnd_message.set_token('RANGE_B',g_life_range2b);
748: g_msg_life_range2 := 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_range3a);
752: fnd_message.set_token('RANGE_B',g_life_range3b);
746: fnd_message.set_token('RANGE_A',g_life_range2a);
747: fnd_message.set_token('RANGE_B',g_life_range2b);
748: g_msg_life_range2 := 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_range3a);
752: fnd_message.set_token('RANGE_B',g_life_range3b);
753: g_msg_life_range3 := fnd_message.get;
754: --
747: fnd_message.set_token('RANGE_B',g_life_range2b);
748: g_msg_life_range2 := 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_range3a);
752: fnd_message.set_token('RANGE_B',g_life_range3b);
753: g_msg_life_range3 := fnd_message.get;
754: --
755: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
748: g_msg_life_range2 := 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_range3a);
752: fnd_message.set_token('RANGE_B',g_life_range3b);
753: g_msg_life_range3 := fnd_message.get;
754: --
755: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
756: fnd_message.set_token('RANGE_A',g_life_range4a);
749: --
750: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_MID');
751: fnd_message.set_token('RANGE_A',g_life_range3a);
752: fnd_message.set_token('RANGE_B',g_life_range3b);
753: g_msg_life_range3 := fnd_message.get;
754: --
755: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
756: fnd_message.set_token('RANGE_A',g_life_range4a);
757: g_msg_life_range4 := fnd_message.get;
751: fnd_message.set_token('RANGE_A',g_life_range3a);
752: fnd_message.set_token('RANGE_B',g_life_range3b);
753: g_msg_life_range3 := fnd_message.get;
754: --
755: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
756: fnd_message.set_token('RANGE_A',g_life_range4a);
757: g_msg_life_range4 := fnd_message.get;
758: --
759: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
752: fnd_message.set_token('RANGE_B',g_life_range3b);
753: g_msg_life_range3 := fnd_message.get;
754: --
755: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
756: fnd_message.set_token('RANGE_A',g_life_range4a);
757: g_msg_life_range4 := fnd_message.get;
758: --
759: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
760: fnd_message.set_token('CALC',g_life_calc2);
753: g_msg_life_range3 := fnd_message.get;
754: --
755: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
756: fnd_message.set_token('RANGE_A',g_life_range4a);
757: g_msg_life_range4 := fnd_message.get;
758: --
759: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
760: fnd_message.set_token('CALC',g_life_calc2);
761: g_msg_life_calc2 := fnd_message.get;
755: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_RANGE_LAST');
756: fnd_message.set_token('RANGE_A',g_life_range4a);
757: g_msg_life_range4 := fnd_message.get;
758: --
759: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
760: fnd_message.set_token('CALC',g_life_calc2);
761: g_msg_life_calc2 := fnd_message.get;
762: --
763: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
756: fnd_message.set_token('RANGE_A',g_life_range4a);
757: g_msg_life_range4 := fnd_message.get;
758: --
759: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
760: fnd_message.set_token('CALC',g_life_calc2);
761: g_msg_life_calc2 := fnd_message.get;
762: --
763: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
764: fnd_message.set_token('CALC',g_life_calc3);
757: g_msg_life_range4 := fnd_message.get;
758: --
759: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
760: fnd_message.set_token('CALC',g_life_calc2);
761: g_msg_life_calc2 := fnd_message.get;
762: --
763: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
764: fnd_message.set_token('CALC',g_life_calc3);
765: g_msg_life_calc3 := fnd_message.get;
759: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
760: fnd_message.set_token('CALC',g_life_calc2);
761: g_msg_life_calc2 := fnd_message.get;
762: --
763: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
764: fnd_message.set_token('CALC',g_life_calc3);
765: g_msg_life_calc3 := fnd_message.get;
766: --
767: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
760: fnd_message.set_token('CALC',g_life_calc2);
761: g_msg_life_calc2 := fnd_message.get;
762: --
763: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
764: fnd_message.set_token('CALC',g_life_calc3);
765: g_msg_life_calc3 := fnd_message.get;
766: --
767: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
768: fnd_message.set_token('CALC',g_life_calc4);
761: g_msg_life_calc2 := fnd_message.get;
762: --
763: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
764: fnd_message.set_token('CALC',g_life_calc3);
765: g_msg_life_calc3 := fnd_message.get;
766: --
767: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
768: fnd_message.set_token('CALC',g_life_calc4);
769: g_msg_life_calc4 := fnd_message.get;
763: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_MID');
764: fnd_message.set_token('CALC',g_life_calc3);
765: g_msg_life_calc3 := fnd_message.get;
766: --
767: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
768: fnd_message.set_token('CALC',g_life_calc4);
769: g_msg_life_calc4 := fnd_message.get;
770: --
771: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
764: fnd_message.set_token('CALC',g_life_calc3);
765: g_msg_life_calc3 := fnd_message.get;
766: --
767: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
768: fnd_message.set_token('CALC',g_life_calc4);
769: g_msg_life_calc4 := fnd_message.get;
770: --
771: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
772: fnd_message.set_token('MAX_VAL',g_life_gen_max);
765: g_msg_life_calc3 := fnd_message.get;
766: --
767: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
768: fnd_message.set_token('CALC',g_life_calc4);
769: g_msg_life_calc4 := fnd_message.get;
770: --
771: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
772: fnd_message.set_token('MAX_VAL',g_life_gen_max);
773: g_msg_life_gen_max := fnd_message.get;
767: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LIFE_DCT_LAST');
768: fnd_message.set_token('CALC',g_life_calc4);
769: g_msg_life_calc4 := fnd_message.get;
770: --
771: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
772: fnd_message.set_token('MAX_VAL',g_life_gen_max);
773: g_msg_life_gen_max := fnd_message.get;
774: --
775: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
768: fnd_message.set_token('CALC',g_life_calc4);
769: g_msg_life_calc4 := fnd_message.get;
770: --
771: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
772: fnd_message.set_token('MAX_VAL',g_life_gen_max);
773: g_msg_life_gen_max := fnd_message.get;
774: --
775: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
776: fnd_message.set_token('MAX_VAL',g_life_pens_max);
769: g_msg_life_calc4 := fnd_message.get;
770: --
771: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
772: fnd_message.set_token('MAX_VAL',g_life_gen_max);
773: g_msg_life_gen_max := fnd_message.get;
774: --
775: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
776: fnd_message.set_token('MAX_VAL',g_life_pens_max);
777: g_msg_life_pens_max := fnd_message.get;
771: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
772: fnd_message.set_token('MAX_VAL',g_life_gen_max);
773: g_msg_life_gen_max := fnd_message.get;
774: --
775: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
776: fnd_message.set_token('MAX_VAL',g_life_pens_max);
777: g_msg_life_pens_max := fnd_message.get;
778: --
779: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
772: fnd_message.set_token('MAX_VAL',g_life_gen_max);
773: g_msg_life_gen_max := fnd_message.get;
774: --
775: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
776: fnd_message.set_token('MAX_VAL',g_life_pens_max);
777: g_msg_life_pens_max := fnd_message.get;
778: --
779: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
780: fnd_message.set_token('MAX_VAL',g_life_ins_max);
773: g_msg_life_gen_max := fnd_message.get;
774: --
775: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
776: fnd_message.set_token('MAX_VAL',g_life_pens_max);
777: g_msg_life_pens_max := fnd_message.get;
778: --
779: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
780: fnd_message.set_token('MAX_VAL',g_life_ins_max);
781: g_msg_life_ins_max := fnd_message.get;
775: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
776: fnd_message.set_token('MAX_VAL',g_life_pens_max);
777: g_msg_life_pens_max := fnd_message.get;
778: --
779: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
780: fnd_message.set_token('MAX_VAL',g_life_ins_max);
781: g_msg_life_ins_max := fnd_message.get;
782: --
783: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_2007');
776: fnd_message.set_token('MAX_VAL',g_life_pens_max);
777: g_msg_life_pens_max := fnd_message.get;
778: --
779: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
780: fnd_message.set_token('MAX_VAL',g_life_ins_max);
781: g_msg_life_ins_max := fnd_message.get;
782: --
783: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_2007');
784: g_msg_nonlife_2007 := fnd_message.get;
777: g_msg_life_pens_max := fnd_message.get;
778: --
779: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
780: fnd_message.set_token('MAX_VAL',g_life_ins_max);
781: g_msg_life_ins_max := fnd_message.get;
782: --
783: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_2007');
784: g_msg_nonlife_2007 := fnd_message.get;
785: --
779: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
780: fnd_message.set_token('MAX_VAL',g_life_ins_max);
781: g_msg_life_ins_max := fnd_message.get;
782: --
783: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_2007');
784: g_msg_nonlife_2007 := fnd_message.get;
785: --
786: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_AP_2007');
787: g_msg_nonlife_ap_2007 := fnd_message.get;
780: fnd_message.set_token('MAX_VAL',g_life_ins_max);
781: g_msg_life_ins_max := fnd_message.get;
782: --
783: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_2007');
784: g_msg_nonlife_2007 := fnd_message.get;
785: --
786: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_AP_2007');
787: g_msg_nonlife_ap_2007 := fnd_message.get;
788: --
782: --
783: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_2007');
784: g_msg_nonlife_2007 := fnd_message.get;
785: --
786: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_AP_2007');
787: g_msg_nonlife_ap_2007 := fnd_message.get;
788: --
789: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_S_2007');
790: g_msg_eqnonlife_s_2007 := fnd_message.get;
783: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_2007');
784: g_msg_nonlife_2007 := fnd_message.get;
785: --
786: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_AP_2007');
787: g_msg_nonlife_ap_2007 := fnd_message.get;
788: --
789: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_S_2007');
790: g_msg_eqnonlife_s_2007 := fnd_message.get;
791: --
785: --
786: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_AP_2007');
787: g_msg_nonlife_ap_2007 := fnd_message.get;
788: --
789: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_S_2007');
790: g_msg_eqnonlife_s_2007 := fnd_message.get;
791: --
792: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_S_2007');
793: g_msg_lnonlife_s_2007 := fnd_message.get;
786: fnd_message.set_name('PAY','PAY_JP_ISDF_P_NONLIFE_AP_2007');
787: g_msg_nonlife_ap_2007 := fnd_message.get;
788: --
789: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_S_2007');
790: g_msg_eqnonlife_s_2007 := fnd_message.get;
791: --
792: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_S_2007');
793: g_msg_lnonlife_s_2007 := fnd_message.get;
794: --
788: --
789: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_S_2007');
790: g_msg_eqnonlife_s_2007 := fnd_message.get;
791: --
792: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_S_2007');
793: g_msg_lnonlife_s_2007 := fnd_message.get;
794: --
795: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE');
796: fnd_message.set_token('YEAR',g_lnonlife_year);
789: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_S_2007');
790: g_msg_eqnonlife_s_2007 := fnd_message.get;
791: --
792: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_S_2007');
793: g_msg_lnonlife_s_2007 := fnd_message.get;
794: --
795: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE');
796: fnd_message.set_token('YEAR',g_lnonlife_year);
797: g_msg_lnonlife := fnd_message.get;
791: --
792: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_S_2007');
793: g_msg_lnonlife_s_2007 := fnd_message.get;
794: --
795: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE');
796: fnd_message.set_token('YEAR',g_lnonlife_year);
797: g_msg_lnonlife := fnd_message.get;
798: --
799: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_2007');
792: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_S_2007');
793: g_msg_lnonlife_s_2007 := fnd_message.get;
794: --
795: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE');
796: fnd_message.set_token('YEAR',g_lnonlife_year);
797: g_msg_lnonlife := fnd_message.get;
798: --
799: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_2007');
800: g_msg_eqnonlife_2007 := fnd_message.get;
793: g_msg_lnonlife_s_2007 := fnd_message.get;
794: --
795: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE');
796: fnd_message.set_token('YEAR',g_lnonlife_year);
797: g_msg_lnonlife := fnd_message.get;
798: --
799: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_2007');
800: g_msg_eqnonlife_2007 := fnd_message.get;
801: --
795: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE');
796: fnd_message.set_token('YEAR',g_lnonlife_year);
797: g_msg_lnonlife := fnd_message.get;
798: --
799: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_2007');
800: g_msg_eqnonlife_2007 := fnd_message.get;
801: --
802: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_2007');
803: g_msg_lnonlife_2007 := fnd_message.get;
796: fnd_message.set_token('YEAR',g_lnonlife_year);
797: g_msg_lnonlife := fnd_message.get;
798: --
799: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_2007');
800: g_msg_eqnonlife_2007 := fnd_message.get;
801: --
802: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_2007');
803: g_msg_lnonlife_2007 := fnd_message.get;
804: --
798: --
799: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_2007');
800: g_msg_eqnonlife_2007 := fnd_message.get;
801: --
802: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_2007');
803: g_msg_lnonlife_2007 := fnd_message.get;
804: --
805: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_DCT');
806: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
799: fnd_message.set_name('PAY','PAY_JP_ISDF_P_EQNONLIFE_2007');
800: g_msg_eqnonlife_2007 := fnd_message.get;
801: --
802: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_2007');
803: g_msg_lnonlife_2007 := fnd_message.get;
804: --
805: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_DCT');
806: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
807: fnd_message.set_token('CALC',g_lnonlife_calc2);
801: --
802: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_2007');
803: g_msg_lnonlife_2007 := fnd_message.get;
804: --
805: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_DCT');
806: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
807: fnd_message.set_token('CALC',g_lnonlife_calc2);
808: g_msg_lnonlife_dct := fnd_message.get;
809: --
802: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_2007');
803: g_msg_lnonlife_2007 := fnd_message.get;
804: --
805: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_DCT');
806: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
807: fnd_message.set_token('CALC',g_lnonlife_calc2);
808: g_msg_lnonlife_dct := fnd_message.get;
809: --
810: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SNONLIFE_DCT');
803: g_msg_lnonlife_2007 := fnd_message.get;
804: --
805: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_DCT');
806: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
807: fnd_message.set_token('CALC',g_lnonlife_calc2);
808: g_msg_lnonlife_dct := fnd_message.get;
809: --
810: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SNONLIFE_DCT');
811: fnd_message.set_token('RANGE_B',g_snonlife_range1b);
804: --
805: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONLIFE_DCT');
806: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
807: fnd_message.set_token('CALC',g_lnonlife_calc2);
808: g_msg_lnonlife_dct := fnd_message.get;
809: --
810: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SNONLIFE_DCT');
811: fnd_message.set_token('RANGE_B',g_snonlife_range1b);
812: fnd_message.set_token('CALC',g_snonlife_calc2);
806: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
807: fnd_message.set_token('CALC',g_lnonlife_calc2);
808: g_msg_lnonlife_dct := fnd_message.get;
809: --
810: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SNONLIFE_DCT');
811: fnd_message.set_token('RANGE_B',g_snonlife_range1b);
812: fnd_message.set_token('CALC',g_snonlife_calc2);
813: g_msg_snonlife_dct := fnd_message.get;
814: --
807: fnd_message.set_token('CALC',g_lnonlife_calc2);
808: g_msg_lnonlife_dct := fnd_message.get;
809: --
810: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SNONLIFE_DCT');
811: fnd_message.set_token('RANGE_B',g_snonlife_range1b);
812: fnd_message.set_token('CALC',g_snonlife_calc2);
813: g_msg_snonlife_dct := fnd_message.get;
814: --
815: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONL_DCT_2007');
808: g_msg_lnonlife_dct := fnd_message.get;
809: --
810: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SNONLIFE_DCT');
811: fnd_message.set_token('RANGE_B',g_snonlife_range1b);
812: fnd_message.set_token('CALC',g_snonlife_calc2);
813: g_msg_snonlife_dct := fnd_message.get;
814: --
815: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONL_DCT_2007');
816: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
809: --
810: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SNONLIFE_DCT');
811: fnd_message.set_token('RANGE_B',g_snonlife_range1b);
812: fnd_message.set_token('CALC',g_snonlife_calc2);
813: g_msg_snonlife_dct := fnd_message.get;
814: --
815: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONL_DCT_2007');
816: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
817: fnd_message.set_token('CALC',g_lnonlife_calc2);
811: fnd_message.set_token('RANGE_B',g_snonlife_range1b);
812: fnd_message.set_token('CALC',g_snonlife_calc2);
813: g_msg_snonlife_dct := fnd_message.get;
814: --
815: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONL_DCT_2007');
816: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
817: fnd_message.set_token('CALC',g_lnonlife_calc2);
818: g_msg_lnonlife_dct_2007 := fnd_message.get;
819: --
812: fnd_message.set_token('CALC',g_snonlife_calc2);
813: g_msg_snonlife_dct := fnd_message.get;
814: --
815: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONL_DCT_2007');
816: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
817: fnd_message.set_token('CALC',g_lnonlife_calc2);
818: g_msg_lnonlife_dct_2007 := fnd_message.get;
819: --
820: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
813: g_msg_snonlife_dct := fnd_message.get;
814: --
815: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONL_DCT_2007');
816: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
817: fnd_message.set_token('CALC',g_lnonlife_calc2);
818: g_msg_lnonlife_dct_2007 := fnd_message.get;
819: --
820: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
821: fnd_message.set_token('MAX_VAL',g_earthquake_max);
814: --
815: fnd_message.set_name('PAY','PAY_JP_ISDF_P_LNONL_DCT_2007');
816: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
817: fnd_message.set_token('CALC',g_lnonlife_calc2);
818: g_msg_lnonlife_dct_2007 := fnd_message.get;
819: --
820: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
821: fnd_message.set_token('MAX_VAL',g_earthquake_max);
822: g_msg_earthquake_max := fnd_message.get;
816: fnd_message.set_token('RANGE_B',g_lnonlife_range1b);
817: fnd_message.set_token('CALC',g_lnonlife_calc2);
818: g_msg_lnonlife_dct_2007 := fnd_message.get;
819: --
820: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
821: fnd_message.set_token('MAX_VAL',g_earthquake_max);
822: g_msg_earthquake_max := fnd_message.get;
823: --
824: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
817: fnd_message.set_token('CALC',g_lnonlife_calc2);
818: g_msg_lnonlife_dct_2007 := fnd_message.get;
819: --
820: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
821: fnd_message.set_token('MAX_VAL',g_earthquake_max);
822: g_msg_earthquake_max := fnd_message.get;
823: --
824: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
825: fnd_message.set_token('MAX_VAL',g_lnonlife_max);
818: g_msg_lnonlife_dct_2007 := fnd_message.get;
819: --
820: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
821: fnd_message.set_token('MAX_VAL',g_earthquake_max);
822: g_msg_earthquake_max := fnd_message.get;
823: --
824: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
825: fnd_message.set_token('MAX_VAL',g_lnonlife_max);
826: g_msg_nonlife_long_max := fnd_message.get;
820: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
821: fnd_message.set_token('MAX_VAL',g_earthquake_max);
822: g_msg_earthquake_max := fnd_message.get;
823: --
824: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
825: fnd_message.set_token('MAX_VAL',g_lnonlife_max);
826: g_msg_nonlife_long_max := fnd_message.get;
827: --
828: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
821: fnd_message.set_token('MAX_VAL',g_earthquake_max);
822: g_msg_earthquake_max := fnd_message.get;
823: --
824: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
825: fnd_message.set_token('MAX_VAL',g_lnonlife_max);
826: g_msg_nonlife_long_max := fnd_message.get;
827: --
828: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
829: fnd_message.set_token('MAX_VAL',g_snonlife_max);
822: g_msg_earthquake_max := fnd_message.get;
823: --
824: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
825: fnd_message.set_token('MAX_VAL',g_lnonlife_max);
826: g_msg_nonlife_long_max := fnd_message.get;
827: --
828: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
829: fnd_message.set_token('MAX_VAL',g_snonlife_max);
830: g_msg_nonlife_short_max := fnd_message.get;
824: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
825: fnd_message.set_token('MAX_VAL',g_lnonlife_max);
826: g_msg_nonlife_long_max := fnd_message.get;
827: --
828: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
829: fnd_message.set_token('MAX_VAL',g_snonlife_max);
830: g_msg_nonlife_short_max := fnd_message.get;
831: --
832: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
825: fnd_message.set_token('MAX_VAL',g_lnonlife_max);
826: g_msg_nonlife_long_max := fnd_message.get;
827: --
828: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
829: fnd_message.set_token('MAX_VAL',g_snonlife_max);
830: g_msg_nonlife_short_max := fnd_message.get;
831: --
832: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
833: fnd_message.set_token('MAX_VAL',g_nonlife_max);
826: g_msg_nonlife_long_max := fnd_message.get;
827: --
828: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
829: fnd_message.set_token('MAX_VAL',g_snonlife_max);
830: g_msg_nonlife_short_max := fnd_message.get;
831: --
832: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
833: fnd_message.set_token('MAX_VAL',g_nonlife_max);
834: g_msg_nonlife_ins_max := fnd_message.get;
828: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
829: fnd_message.set_token('MAX_VAL',g_snonlife_max);
830: g_msg_nonlife_short_max := fnd_message.get;
831: --
832: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
833: fnd_message.set_token('MAX_VAL',g_nonlife_max);
834: g_msg_nonlife_ins_max := fnd_message.get;
835: --
836: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
829: fnd_message.set_token('MAX_VAL',g_snonlife_max);
830: g_msg_nonlife_short_max := fnd_message.get;
831: --
832: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
833: fnd_message.set_token('MAX_VAL',g_nonlife_max);
834: g_msg_nonlife_ins_max := fnd_message.get;
835: --
836: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
837: fnd_message.set_token('MAX_VAL',g_nonlife_max_2007);
830: g_msg_nonlife_short_max := fnd_message.get;
831: --
832: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
833: fnd_message.set_token('MAX_VAL',g_nonlife_max);
834: g_msg_nonlife_ins_max := fnd_message.get;
835: --
836: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
837: fnd_message.set_token('MAX_VAL',g_nonlife_max_2007);
838: g_msg_nonlife_ins_max_2007 := fnd_message.get;
832: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
833: fnd_message.set_token('MAX_VAL',g_nonlife_max);
834: g_msg_nonlife_ins_max := fnd_message.get;
835: --
836: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
837: fnd_message.set_token('MAX_VAL',g_nonlife_max_2007);
838: g_msg_nonlife_ins_max_2007 := fnd_message.get;
839: --
840: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_EMP_INC_MAX');
833: fnd_message.set_token('MAX_VAL',g_nonlife_max);
834: g_msg_nonlife_ins_max := fnd_message.get;
835: --
836: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
837: fnd_message.set_token('MAX_VAL',g_nonlife_max_2007);
838: g_msg_nonlife_ins_max_2007 := fnd_message.get;
839: --
840: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_EMP_INC_MAX');
841: fnd_message.set_token('EMP_INC_MAX',g_sp_emp_inc_max);
834: g_msg_nonlife_ins_max := fnd_message.get;
835: --
836: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
837: fnd_message.set_token('MAX_VAL',g_nonlife_max_2007);
838: g_msg_nonlife_ins_max_2007 := fnd_message.get;
839: --
840: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_EMP_INC_MAX');
841: fnd_message.set_token('EMP_INC_MAX',g_sp_emp_inc_max);
842: g_msg_sp_emp_inc_max := fnd_message.get;
836: fnd_message.set_name('PAY','PAY_JP_ISDF_P_MAX');
837: fnd_message.set_token('MAX_VAL',g_nonlife_max_2007);
838: g_msg_nonlife_ins_max_2007 := fnd_message.get;
839: --
840: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_EMP_INC_MAX');
841: fnd_message.set_token('EMP_INC_MAX',g_sp_emp_inc_max);
842: g_msg_sp_emp_inc_max := fnd_message.get;
843: --
844: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_SP_INC_MAX');
837: fnd_message.set_token('MAX_VAL',g_nonlife_max_2007);
838: g_msg_nonlife_ins_max_2007 := fnd_message.get;
839: --
840: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_EMP_INC_MAX');
841: fnd_message.set_token('EMP_INC_MAX',g_sp_emp_inc_max);
842: g_msg_sp_emp_inc_max := fnd_message.get;
843: --
844: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_SP_INC_MAX');
845: fnd_message.set_token('SP_DCT_MAX',g_sp_spdct_max);
838: g_msg_nonlife_ins_max_2007 := fnd_message.get;
839: --
840: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_EMP_INC_MAX');
841: fnd_message.set_token('EMP_INC_MAX',g_sp_emp_inc_max);
842: g_msg_sp_emp_inc_max := fnd_message.get;
843: --
844: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_SP_INC_MAX');
845: fnd_message.set_token('SP_DCT_MAX',g_sp_spdct_max);
846: fnd_message.set_token('SP_INC_MAX',g_sp_spinc_max);
840: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_EMP_INC_MAX');
841: fnd_message.set_token('EMP_INC_MAX',g_sp_emp_inc_max);
842: g_msg_sp_emp_inc_max := fnd_message.get;
843: --
844: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_SP_INC_MAX');
845: fnd_message.set_token('SP_DCT_MAX',g_sp_spdct_max);
846: fnd_message.set_token('SP_INC_MAX',g_sp_spinc_max);
847: g_msg_sp_sp_inc_max := fnd_message.get;
848: --
841: fnd_message.set_token('EMP_INC_MAX',g_sp_emp_inc_max);
842: g_msg_sp_emp_inc_max := fnd_message.get;
843: --
844: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_SP_INC_MAX');
845: fnd_message.set_token('SP_DCT_MAX',g_sp_spdct_max);
846: fnd_message.set_token('SP_INC_MAX',g_sp_spinc_max);
847: g_msg_sp_sp_inc_max := fnd_message.get;
848: --
849: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP1');
842: g_msg_sp_emp_inc_max := fnd_message.get;
843: --
844: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_SP_INC_MAX');
845: fnd_message.set_token('SP_DCT_MAX',g_sp_spdct_max);
846: fnd_message.set_token('SP_INC_MAX',g_sp_spinc_max);
847: g_msg_sp_sp_inc_max := fnd_message.get;
848: --
849: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP1');
850: fnd_message.set_token('SP_CALC_EXP1',g_sp_calc_cal1);
843: --
844: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_SP_INC_MAX');
845: fnd_message.set_token('SP_DCT_MAX',g_sp_spdct_max);
846: fnd_message.set_token('SP_INC_MAX',g_sp_spinc_max);
847: g_msg_sp_sp_inc_max := fnd_message.get;
848: --
849: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP1');
850: fnd_message.set_token('SP_CALC_EXP1',g_sp_calc_cal1);
851: g_msg_sp_calc_cal1 := fnd_message.get;
845: fnd_message.set_token('SP_DCT_MAX',g_sp_spdct_max);
846: fnd_message.set_token('SP_INC_MAX',g_sp_spinc_max);
847: g_msg_sp_sp_inc_max := fnd_message.get;
848: --
849: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP1');
850: fnd_message.set_token('SP_CALC_EXP1',g_sp_calc_cal1);
851: g_msg_sp_calc_cal1 := fnd_message.get;
852: --
853: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP6');
846: fnd_message.set_token('SP_INC_MAX',g_sp_spinc_max);
847: g_msg_sp_sp_inc_max := fnd_message.get;
848: --
849: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP1');
850: fnd_message.set_token('SP_CALC_EXP1',g_sp_calc_cal1);
851: g_msg_sp_calc_cal1 := fnd_message.get;
852: --
853: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP6');
854: fnd_message.set_token('SP_CALC_EXP6',g_sp_calc_cal6);
847: g_msg_sp_sp_inc_max := fnd_message.get;
848: --
849: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP1');
850: fnd_message.set_token('SP_CALC_EXP1',g_sp_calc_cal1);
851: g_msg_sp_calc_cal1 := fnd_message.get;
852: --
853: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP6');
854: fnd_message.set_token('SP_CALC_EXP6',g_sp_calc_cal6);
855: g_msg_sp_calc_cal6 := fnd_message.get;
849: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP1');
850: fnd_message.set_token('SP_CALC_EXP1',g_sp_calc_cal1);
851: g_msg_sp_calc_cal1 := fnd_message.get;
852: --
853: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP6');
854: fnd_message.set_token('SP_CALC_EXP6',g_sp_calc_cal6);
855: g_msg_sp_calc_cal6 := fnd_message.get;
856: --
857: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
850: fnd_message.set_token('SP_CALC_EXP1',g_sp_calc_cal1);
851: g_msg_sp_calc_cal1 := fnd_message.get;
852: --
853: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP6');
854: fnd_message.set_token('SP_CALC_EXP6',g_sp_calc_cal6);
855: g_msg_sp_calc_cal6 := fnd_message.get;
856: --
857: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
858: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range1a);
851: g_msg_sp_calc_cal1 := fnd_message.get;
852: --
853: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP6');
854: fnd_message.set_token('SP_CALC_EXP6',g_sp_calc_cal6);
855: g_msg_sp_calc_cal6 := fnd_message.get;
856: --
857: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
858: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range1a);
859: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range1b);
853: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_CALC_EXP6');
854: fnd_message.set_token('SP_CALC_EXP6',g_sp_calc_cal6);
855: g_msg_sp_calc_cal6 := fnd_message.get;
856: --
857: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
858: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range1a);
859: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range1b);
860: g_msg_sp_calc_dct_range1 := fnd_message.get;
861: --
854: fnd_message.set_token('SP_CALC_EXP6',g_sp_calc_cal6);
855: g_msg_sp_calc_cal6 := fnd_message.get;
856: --
857: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
858: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range1a);
859: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range1b);
860: g_msg_sp_calc_dct_range1 := fnd_message.get;
861: --
862: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
855: g_msg_sp_calc_cal6 := fnd_message.get;
856: --
857: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
858: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range1a);
859: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range1b);
860: g_msg_sp_calc_dct_range1 := 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_range2a);
856: --
857: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
858: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range1a);
859: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range1b);
860: g_msg_sp_calc_dct_range1 := 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_range2a);
864: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range2b);
858: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range1a);
859: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range1b);
860: g_msg_sp_calc_dct_range1 := 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_range2a);
864: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range2b);
865: g_msg_sp_calc_dct_range2 := fnd_message.get;
866: --
859: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range1b);
860: g_msg_sp_calc_dct_range1 := 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_range2a);
864: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range2b);
865: g_msg_sp_calc_dct_range2 := fnd_message.get;
866: --
867: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
860: g_msg_sp_calc_dct_range1 := 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_range2a);
864: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range2b);
865: g_msg_sp_calc_dct_range2 := 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_range3a);
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_range2a);
864: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range2b);
865: g_msg_sp_calc_dct_range2 := 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_range3a);
869: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range3b);
863: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range2a);
864: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range2b);
865: g_msg_sp_calc_dct_range2 := 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_range3a);
869: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range3b);
870: g_msg_sp_calc_dct_range3 := fnd_message.get;
871: --
864: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range2b);
865: g_msg_sp_calc_dct_range2 := 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_range3a);
869: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range3b);
870: g_msg_sp_calc_dct_range3 := fnd_message.get;
871: --
872: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
865: g_msg_sp_calc_dct_range2 := 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_range3a);
869: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range3b);
870: g_msg_sp_calc_dct_range3 := 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_range4a);
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_range3a);
869: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range3b);
870: g_msg_sp_calc_dct_range3 := 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_range4a);
874: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range4b);
868: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range3a);
869: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range3b);
870: g_msg_sp_calc_dct_range3 := 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_range4a);
874: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range4b);
875: g_msg_sp_calc_dct_range4 := fnd_message.get;
876: --
869: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range3b);
870: g_msg_sp_calc_dct_range3 := 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_range4a);
874: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range4b);
875: g_msg_sp_calc_dct_range4 := fnd_message.get;
876: --
877: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
870: g_msg_sp_calc_dct_range3 := 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_range4a);
874: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range4b);
875: g_msg_sp_calc_dct_range4 := 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_range5a);
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_range4a);
874: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range4b);
875: g_msg_sp_calc_dct_range4 := 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_range5a);
879: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range5b);
873: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range4a);
874: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range4b);
875: g_msg_sp_calc_dct_range4 := 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_range5a);
879: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range5b);
880: g_msg_sp_calc_dct_range5 := fnd_message.get;
881: --
874: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range4b);
875: g_msg_sp_calc_dct_range4 := 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_range5a);
879: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range5b);
880: g_msg_sp_calc_dct_range5 := fnd_message.get;
881: --
882: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
875: g_msg_sp_calc_dct_range4 := 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_range5a);
879: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range5b);
880: g_msg_sp_calc_dct_range5 := 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_range6a);
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_range5a);
879: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range5b);
880: g_msg_sp_calc_dct_range5 := 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_range6a);
884: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range6b);
878: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range5a);
879: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range5b);
880: g_msg_sp_calc_dct_range5 := 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_range6a);
884: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range6b);
885: g_msg_sp_calc_dct_range6 := fnd_message.get;
886: --
879: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range5b);
880: g_msg_sp_calc_dct_range5 := 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_range6a);
884: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range6b);
885: g_msg_sp_calc_dct_range6 := fnd_message.get;
886: --
887: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
880: g_msg_sp_calc_dct_range5 := 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_range6a);
884: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range6b);
885: g_msg_sp_calc_dct_range6 := 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_range7a);
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_range6a);
884: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range6b);
885: g_msg_sp_calc_dct_range6 := 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_range7a);
889: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range7b);
883: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range6a);
884: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range6b);
885: g_msg_sp_calc_dct_range6 := 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_range7a);
889: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range7b);
890: g_msg_sp_calc_dct_range7 := fnd_message.get;
891: --
884: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range6b);
885: g_msg_sp_calc_dct_range6 := 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_range7a);
889: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range7b);
890: g_msg_sp_calc_dct_range7 := fnd_message.get;
891: --
892: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
885: g_msg_sp_calc_dct_range6 := 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_range7a);
889: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range7b);
890: g_msg_sp_calc_dct_range7 := 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_range8a);
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_range7a);
889: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range7b);
890: g_msg_sp_calc_dct_range7 := 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_range8a);
894: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range8b);
888: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range7a);
889: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range7b);
890: g_msg_sp_calc_dct_range7 := 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_range8a);
894: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range8b);
895: g_msg_sp_calc_dct_range8 := fnd_message.get;
896: --
889: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range7b);
890: g_msg_sp_calc_dct_range7 := 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_range8a);
894: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range8b);
895: g_msg_sp_calc_dct_range8 := fnd_message.get;
896: --
897: fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT_RANGE');
890: g_msg_sp_calc_dct_range7 := 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_range8a);
894: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range8b);
895: g_msg_sp_calc_dct_range8 := 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_range9a);
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_range8a);
894: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range8b);
895: g_msg_sp_calc_dct_range8 := 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_range9a);
899: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range9b);
893: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range8a);
894: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range8b);
895: g_msg_sp_calc_dct_range8 := 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_range9a);
899: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range9b);
900: g_msg_sp_calc_dct_range9 := fnd_message.get;
901: --
894: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range8b);
895: g_msg_sp_calc_dct_range8 := 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_range9a);
899: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range9b);
900: g_msg_sp_calc_dct_range9 := fnd_message.get;
901: --
902: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
895: g_msg_sp_calc_dct_range8 := 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_range9a);
899: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range9b);
900: g_msg_sp_calc_dct_range9 := fnd_message.get;
901: --
902: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
903: --fnd_message.set_token('DCT',g_sp_calc_dct1);
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_range9a);
899: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range9b);
900: g_msg_sp_calc_dct_range9 := fnd_message.get;
901: --
902: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
903: --fnd_message.set_token('DCT',g_sp_calc_dct1);
904: --g_msg_sp_calc_dct1 := fnd_message.get;
898: fnd_message.set_token('RANGE_A',g_sp_calc_dct_range9a);
899: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range9b);
900: g_msg_sp_calc_dct_range9 := fnd_message.get;
901: --
902: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
903: --fnd_message.set_token('DCT',g_sp_calc_dct1);
904: --g_msg_sp_calc_dct1 := fnd_message.get;
905: g_msg_sp_calc_dct1 := g_sp_calc_dct1;
906: --
899: fnd_message.set_token('RANGE_B',g_sp_calc_dct_range9b);
900: g_msg_sp_calc_dct_range9 := fnd_message.get;
901: --
902: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
903: --fnd_message.set_token('DCT',g_sp_calc_dct1);
904: --g_msg_sp_calc_dct1 := fnd_message.get;
905: g_msg_sp_calc_dct1 := g_sp_calc_dct1;
906: --
907: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
900: g_msg_sp_calc_dct_range9 := fnd_message.get;
901: --
902: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
903: --fnd_message.set_token('DCT',g_sp_calc_dct1);
904: --g_msg_sp_calc_dct1 := fnd_message.get;
905: g_msg_sp_calc_dct1 := g_sp_calc_dct1;
906: --
907: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
908: --fnd_message.set_token('DCT',g_sp_calc_dct2);
903: --fnd_message.set_token('DCT',g_sp_calc_dct1);
904: --g_msg_sp_calc_dct1 := fnd_message.get;
905: g_msg_sp_calc_dct1 := g_sp_calc_dct1;
906: --
907: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
908: --fnd_message.set_token('DCT',g_sp_calc_dct2);
909: --g_msg_sp_calc_dct2 := fnd_message.get;
910: g_msg_sp_calc_dct2 := g_sp_calc_dct2;
911: --
904: --g_msg_sp_calc_dct1 := fnd_message.get;
905: g_msg_sp_calc_dct1 := g_sp_calc_dct1;
906: --
907: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
908: --fnd_message.set_token('DCT',g_sp_calc_dct2);
909: --g_msg_sp_calc_dct2 := fnd_message.get;
910: g_msg_sp_calc_dct2 := g_sp_calc_dct2;
911: --
912: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
905: g_msg_sp_calc_dct1 := g_sp_calc_dct1;
906: --
907: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
908: --fnd_message.set_token('DCT',g_sp_calc_dct2);
909: --g_msg_sp_calc_dct2 := fnd_message.get;
910: g_msg_sp_calc_dct2 := g_sp_calc_dct2;
911: --
912: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
913: --fnd_message.set_token('DCT',g_sp_calc_dct3);
908: --fnd_message.set_token('DCT',g_sp_calc_dct2);
909: --g_msg_sp_calc_dct2 := fnd_message.get;
910: g_msg_sp_calc_dct2 := g_sp_calc_dct2;
911: --
912: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
913: --fnd_message.set_token('DCT',g_sp_calc_dct3);
914: --g_msg_sp_calc_dct3 := fnd_message.get;
915: g_msg_sp_calc_dct3 := g_sp_calc_dct3;
916: --
909: --g_msg_sp_calc_dct2 := fnd_message.get;
910: g_msg_sp_calc_dct2 := g_sp_calc_dct2;
911: --
912: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
913: --fnd_message.set_token('DCT',g_sp_calc_dct3);
914: --g_msg_sp_calc_dct3 := fnd_message.get;
915: g_msg_sp_calc_dct3 := g_sp_calc_dct3;
916: --
917: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
910: g_msg_sp_calc_dct2 := g_sp_calc_dct2;
911: --
912: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
913: --fnd_message.set_token('DCT',g_sp_calc_dct3);
914: --g_msg_sp_calc_dct3 := fnd_message.get;
915: g_msg_sp_calc_dct3 := g_sp_calc_dct3;
916: --
917: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
918: --fnd_message.set_token('DCT',g_sp_calc_dct4);
913: --fnd_message.set_token('DCT',g_sp_calc_dct3);
914: --g_msg_sp_calc_dct3 := fnd_message.get;
915: g_msg_sp_calc_dct3 := g_sp_calc_dct3;
916: --
917: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
918: --fnd_message.set_token('DCT',g_sp_calc_dct4);
919: --g_msg_sp_calc_dct4 := fnd_message.get;
920: g_msg_sp_calc_dct4 := g_sp_calc_dct4;
921: --
914: --g_msg_sp_calc_dct3 := fnd_message.get;
915: g_msg_sp_calc_dct3 := g_sp_calc_dct3;
916: --
917: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
918: --fnd_message.set_token('DCT',g_sp_calc_dct4);
919: --g_msg_sp_calc_dct4 := fnd_message.get;
920: g_msg_sp_calc_dct4 := g_sp_calc_dct4;
921: --
922: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
915: g_msg_sp_calc_dct3 := g_sp_calc_dct3;
916: --
917: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
918: --fnd_message.set_token('DCT',g_sp_calc_dct4);
919: --g_msg_sp_calc_dct4 := fnd_message.get;
920: g_msg_sp_calc_dct4 := g_sp_calc_dct4;
921: --
922: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
923: --fnd_message.set_token('DCT',g_sp_calc_dct5);
918: --fnd_message.set_token('DCT',g_sp_calc_dct4);
919: --g_msg_sp_calc_dct4 := fnd_message.get;
920: g_msg_sp_calc_dct4 := g_sp_calc_dct4;
921: --
922: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
923: --fnd_message.set_token('DCT',g_sp_calc_dct5);
924: --g_msg_sp_calc_dct5 := fnd_message.get;
925: g_msg_sp_calc_dct5 := g_sp_calc_dct5;
926: --
919: --g_msg_sp_calc_dct4 := fnd_message.get;
920: g_msg_sp_calc_dct4 := g_sp_calc_dct4;
921: --
922: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
923: --fnd_message.set_token('DCT',g_sp_calc_dct5);
924: --g_msg_sp_calc_dct5 := fnd_message.get;
925: g_msg_sp_calc_dct5 := g_sp_calc_dct5;
926: --
927: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
920: g_msg_sp_calc_dct4 := g_sp_calc_dct4;
921: --
922: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
923: --fnd_message.set_token('DCT',g_sp_calc_dct5);
924: --g_msg_sp_calc_dct5 := fnd_message.get;
925: g_msg_sp_calc_dct5 := g_sp_calc_dct5;
926: --
927: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
928: --fnd_message.set_token('DCT',g_sp_calc_dct6);
923: --fnd_message.set_token('DCT',g_sp_calc_dct5);
924: --g_msg_sp_calc_dct5 := fnd_message.get;
925: g_msg_sp_calc_dct5 := g_sp_calc_dct5;
926: --
927: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
928: --fnd_message.set_token('DCT',g_sp_calc_dct6);
929: --g_msg_sp_calc_dct6 := fnd_message.get;
930: g_msg_sp_calc_dct6 := g_sp_calc_dct6;
931: --
924: --g_msg_sp_calc_dct5 := fnd_message.get;
925: g_msg_sp_calc_dct5 := g_sp_calc_dct5;
926: --
927: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
928: --fnd_message.set_token('DCT',g_sp_calc_dct6);
929: --g_msg_sp_calc_dct6 := fnd_message.get;
930: g_msg_sp_calc_dct6 := g_sp_calc_dct6;
931: --
932: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
925: g_msg_sp_calc_dct5 := g_sp_calc_dct5;
926: --
927: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
928: --fnd_message.set_token('DCT',g_sp_calc_dct6);
929: --g_msg_sp_calc_dct6 := fnd_message.get;
930: g_msg_sp_calc_dct6 := g_sp_calc_dct6;
931: --
932: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
933: --fnd_message.set_token('DCT',g_sp_calc_dct7);
928: --fnd_message.set_token('DCT',g_sp_calc_dct6);
929: --g_msg_sp_calc_dct6 := fnd_message.get;
930: g_msg_sp_calc_dct6 := g_sp_calc_dct6;
931: --
932: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
933: --fnd_message.set_token('DCT',g_sp_calc_dct7);
934: --g_msg_sp_calc_dct7 := fnd_message.get;
935: g_msg_sp_calc_dct7 := g_sp_calc_dct7;
936: --
929: --g_msg_sp_calc_dct6 := fnd_message.get;
930: g_msg_sp_calc_dct6 := g_sp_calc_dct6;
931: --
932: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
933: --fnd_message.set_token('DCT',g_sp_calc_dct7);
934: --g_msg_sp_calc_dct7 := fnd_message.get;
935: g_msg_sp_calc_dct7 := g_sp_calc_dct7;
936: --
937: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
930: g_msg_sp_calc_dct6 := g_sp_calc_dct6;
931: --
932: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
933: --fnd_message.set_token('DCT',g_sp_calc_dct7);
934: --g_msg_sp_calc_dct7 := fnd_message.get;
935: g_msg_sp_calc_dct7 := g_sp_calc_dct7;
936: --
937: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
938: --fnd_message.set_token('DCT',g_sp_calc_dct8);
933: --fnd_message.set_token('DCT',g_sp_calc_dct7);
934: --g_msg_sp_calc_dct7 := fnd_message.get;
935: g_msg_sp_calc_dct7 := g_sp_calc_dct7;
936: --
937: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
938: --fnd_message.set_token('DCT',g_sp_calc_dct8);
939: --g_msg_sp_calc_dct8 := fnd_message.get;
940: g_msg_sp_calc_dct8 := g_sp_calc_dct8;
941: --
934: --g_msg_sp_calc_dct7 := fnd_message.get;
935: g_msg_sp_calc_dct7 := g_sp_calc_dct7;
936: --
937: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
938: --fnd_message.set_token('DCT',g_sp_calc_dct8);
939: --g_msg_sp_calc_dct8 := fnd_message.get;
940: g_msg_sp_calc_dct8 := g_sp_calc_dct8;
941: --
942: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
935: g_msg_sp_calc_dct7 := g_sp_calc_dct7;
936: --
937: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
938: --fnd_message.set_token('DCT',g_sp_calc_dct8);
939: --g_msg_sp_calc_dct8 := fnd_message.get;
940: g_msg_sp_calc_dct8 := g_sp_calc_dct8;
941: --
942: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
943: --fnd_message.set_token('DCT',g_sp_calc_dct9);
938: --fnd_message.set_token('DCT',g_sp_calc_dct8);
939: --g_msg_sp_calc_dct8 := fnd_message.get;
940: g_msg_sp_calc_dct8 := g_sp_calc_dct8;
941: --
942: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
943: --fnd_message.set_token('DCT',g_sp_calc_dct9);
944: --g_msg_sp_calc_dct9 := fnd_message.get;
945: g_msg_sp_calc_dct9 := g_sp_calc_dct9;
946: --
939: --g_msg_sp_calc_dct8 := fnd_message.get;
940: g_msg_sp_calc_dct8 := g_sp_calc_dct8;
941: --
942: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
943: --fnd_message.set_token('DCT',g_sp_calc_dct9);
944: --g_msg_sp_calc_dct9 := fnd_message.get;
945: g_msg_sp_calc_dct9 := g_sp_calc_dct9;
946: --
947: end if;
940: g_msg_sp_calc_dct8 := g_sp_calc_dct8;
941: --
942: --fnd_message.set_name('PAY','PAY_JP_ISDF_P_SP_DCT');
943: --fnd_message.set_token('DCT',g_sp_calc_dct9);
944: --g_msg_sp_calc_dct9 := fnd_message.get;
945: g_msg_sp_calc_dct9 := g_sp_calc_dct9;
946: --
947: end if;
948: --
1095: --
1096: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1097: --
1098: if l_assact_rec.transaction_status not in ('U', 'N') then
1099: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
1100: fnd_message.raise_error;
1101: end if;
1102: --
1103: if g_debug then
1096: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1097: --
1098: if l_assact_rec.transaction_status not in ('U', 'N') then
1099: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
1100: fnd_message.raise_error;
1101: end if;
1102: --
1103: if g_debug then
1104: hr_utility.set_location(l_proc,20);
1211: --
1212: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1213: --
1214: if l_assact_rec.transaction_status <> 'N' then
1215: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
1216: fnd_message.raise_error;
1217: end if;
1218: --
1219: if g_debug then
1212: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
1213: --
1214: if l_assact_rec.transaction_status <> 'N' then
1215: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
1216: fnd_message.raise_error;
1217: end if;
1218: --
1219: if g_debug then
1220: hr_utility.set_location(l_proc,20);
2568: from pay_jp_isdf_assact_v
2569: where action_information_id = p_action_information_id;
2570: --
2571: if l_assact_rec.transaction_status <> 'N' then
2572: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
2573: fnd_message.raise_error;
2574: end if;
2575: --
2576: if g_debug then
2569: where action_information_id = p_action_information_id;
2570: --
2571: if l_assact_rec.transaction_status <> 'N' then
2572: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
2573: fnd_message.raise_error;
2574: end if;
2575: --
2576: if g_debug then
2577: hr_utility.set_location(l_proc,20);
2728: --
2729: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2730: --
2731: if l_assact_rec.transaction_status <> 'N' then
2732: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
2733: fnd_message.raise_error;
2734: end if;
2735: --
2736: if g_debug then
2729: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
2730: --
2731: if l_assact_rec.transaction_status <> 'N' then
2732: fnd_message.set_name('PAY','PAY_JP_DEF_INVALID_TXN_STATUS');
2733: fnd_message.raise_error;
2734: end if;
2735: --
2736: if g_debug then
2737: hr_utility.set_location(l_proc,20);
3015: --
3016: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3017: --
3018: if l_assact_rec.transaction_status not in ('F', 'A') then
3019: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3020: fnd_message.raise_error;
3021: elsif l_assact_rec.transfer_status <> 'U' then
3022: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3023: fnd_message.raise_error;
3016: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3017: --
3018: if l_assact_rec.transaction_status not in ('F', 'A') then
3019: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3020: fnd_message.raise_error;
3021: elsif l_assact_rec.transfer_status <> 'U' then
3022: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3023: fnd_message.raise_error;
3024: end if;
3018: if l_assact_rec.transaction_status not in ('F', 'A') then
3019: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3020: fnd_message.raise_error;
3021: elsif l_assact_rec.transfer_status <> 'U' then
3022: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3023: fnd_message.raise_error;
3024: end if;
3025: --
3026: if g_debug then
3019: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3020: fnd_message.raise_error;
3021: elsif l_assact_rec.transfer_status <> 'U' then
3022: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3023: fnd_message.raise_error;
3024: end if;
3025: --
3026: if g_debug then
3027: hr_utility.set_location(l_proc,20);
3102: --
3103: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3104: --
3105: if l_assact_rec.transaction_status not in ('F', 'A') then
3106: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3107: fnd_message.raise_error;
3108: elsif l_assact_rec.transfer_status <> 'U' then
3109: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3110: fnd_message.raise_error;
3103: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3104: --
3105: if l_assact_rec.transaction_status not in ('F', 'A') then
3106: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3107: fnd_message.raise_error;
3108: elsif l_assact_rec.transfer_status <> 'U' then
3109: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3110: fnd_message.raise_error;
3111: end if;
3105: if l_assact_rec.transaction_status not in ('F', 'A') then
3106: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3107: fnd_message.raise_error;
3108: elsif l_assact_rec.transfer_status <> 'U' then
3109: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3110: fnd_message.raise_error;
3111: end if;
3112: --
3113: if g_debug then
3106: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3107: fnd_message.raise_error;
3108: elsif l_assact_rec.transfer_status <> 'U' then
3109: fnd_message.set_name('PAY','PAY_JP_DEF_ALREADY_TRANSFERRED');
3110: fnd_message.raise_error;
3111: end if;
3112: --
3113: if g_debug then
3114: hr_utility.set_location(l_proc,20);
3174: --
3175: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3176: --
3177: if l_assact_rec.transaction_status <> 'F' then
3178: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3179: fnd_message.raise_error;
3180: end if;
3181: --
3182: if g_debug then
3175: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
3176: --
3177: if l_assact_rec.transaction_status <> 'F' then
3178: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
3179: fnd_message.raise_error;
3180: end if;
3181: --
3182: if g_debug then
3183: hr_utility.set_location(l_proc,20);
3437: p_element_type_id => c_isdf_ins_elm_id,
3438: p_session_date => l_effective_date);
3439: --
3440: if l_ins_element_link_id is null then
3441: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
3442: fnd_message.set_token('ELE_NAME',c_isdf_ins_elm);
3443: fnd_message.raise_error;
3444: end if;
3445: --
3438: p_session_date => l_effective_date);
3439: --
3440: if l_ins_element_link_id is null then
3441: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
3442: fnd_message.set_token('ELE_NAME',c_isdf_ins_elm);
3443: fnd_message.raise_error;
3444: end if;
3445: --
3446: pay_element_entry_api.create_element_entry(
3439: --
3440: if l_ins_element_link_id is null then
3441: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
3442: fnd_message.set_token('ELE_NAME',c_isdf_ins_elm);
3443: fnd_message.raise_error;
3444: end if;
3445: --
3446: pay_element_entry_api.create_element_entry(
3447: p_validate => false,
3507: p_element_type_id => c_isdf_is_elm_id,
3508: p_session_date => l_effective_date);
3509: --
3510: if l_is_element_link_id is null then
3511: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
3512: fnd_message.set_token('ELE_NAME',c_isdf_is_elm);
3513: fnd_message.raise_error;
3514: end if;
3515: --
3508: p_session_date => l_effective_date);
3509: --
3510: if l_is_element_link_id is null then
3511: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
3512: fnd_message.set_token('ELE_NAME',c_isdf_is_elm);
3513: fnd_message.raise_error;
3514: end if;
3515: --
3516: pay_element_entry_api.create_element_entry(
3509: --
3510: if l_is_element_link_id is null then
3511: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
3512: fnd_message.set_token('ELE_NAME',c_isdf_is_elm);
3513: fnd_message.raise_error;
3514: end if;
3515: --
3516: pay_element_entry_api.create_element_entry(
3517: p_validate => false,
3637: p_element_type_id => c_isdf_ins_elm_id,
3638: p_session_date => l_effective_date);
3639: --
3640: if l_ins_element_link_id is null then
3641: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
3642: fnd_message.set_token('ELE_NAME',c_isdf_ins_elm);
3643: fnd_message.raise_error;
3644: end if;
3645: --
3638: p_session_date => l_effective_date);
3639: --
3640: if l_ins_element_link_id is null then
3641: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
3642: fnd_message.set_token('ELE_NAME',c_isdf_ins_elm);
3643: fnd_message.raise_error;
3644: end if;
3645: --
3646: pay_element_entry_api.create_element_entry(
3639: --
3640: if l_ins_element_link_id is null then
3641: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
3642: fnd_message.set_token('ELE_NAME',c_isdf_ins_elm);
3643: fnd_message.raise_error;
3644: end if;
3645: --
3646: pay_element_entry_api.create_element_entry(
3647: p_validate => false,
3717: p_element_type_id => c_isdf_is_elm_id,
3718: p_session_date => l_effective_date);
3719: --
3720: if l_is_element_link_id is null then
3721: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
3722: fnd_message.set_token('ELE_NAME',c_isdf_is_elm);
3723: fnd_message.raise_error;
3724: end if;
3725: --
3718: p_session_date => l_effective_date);
3719: --
3720: if l_is_element_link_id is null then
3721: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
3722: fnd_message.set_token('ELE_NAME',c_isdf_is_elm);
3723: fnd_message.raise_error;
3724: end if;
3725: --
3726: pay_element_entry_api.create_element_entry(
3719: --
3720: if l_is_element_link_id is null then
3721: fnd_message.set_name('PAY', 'PAY_JP_ISDF_NO_ELE_LINK');
3722: fnd_message.set_token('ELE_NAME',c_isdf_is_elm);
3723: fnd_message.raise_error;
3724: end if;
3725: --
3726: pay_element_entry_api.create_element_entry(
3727: p_validate => false,
4486: --
4487: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
4488: --
4489: if l_assact_rec.transaction_status <> 'A' then
4490: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
4491: fnd_message.raise_error;
4492: elsif l_assact_rec.transfer_status <> 'U' then
4493: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
4494: fnd_message.raise_error;
4487: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
4488: --
4489: if l_assact_rec.transaction_status <> 'A' then
4490: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
4491: fnd_message.raise_error;
4492: elsif l_assact_rec.transfer_status <> 'U' then
4493: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
4494: fnd_message.raise_error;
4495: end if;
4489: if l_assact_rec.transaction_status <> 'A' then
4490: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
4491: fnd_message.raise_error;
4492: elsif l_assact_rec.transfer_status <> 'U' then
4493: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
4494: fnd_message.raise_error;
4495: end if;
4496: --
4497: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;
4490: fnd_message.set_name('PAY', 'PAY_JP_DEF_INVALID_TXN_STATUS');
4491: fnd_message.raise_error;
4492: elsif l_assact_rec.transfer_status <> 'U' then
4493: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_TRANSFERRED');
4494: fnd_message.raise_error;
4495: end if;
4496: --
4497: l_year_end_date := add_months(trunc(l_assact_rec.effective_date, 'YYYY'), 12) - 1;
4498: l_dec_first_date := trunc(l_year_end_date,'MM');
4508: -- but basically transfer should be done after archive process date.
4509: if l_effective_date < l_assact_rec.effective_date
4510: or l_effective_date < l_dec_first_date
4511: or l_effective_date > l_year_end_date then
4512: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
4513: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
4514: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
4515: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
4516: fnd_message.raise_error;
4509: if l_effective_date < l_assact_rec.effective_date
4510: or l_effective_date < l_dec_first_date
4511: or l_effective_date > l_year_end_date then
4512: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
4513: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
4514: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
4515: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
4516: fnd_message.raise_error;
4517: end if;
4510: or l_effective_date < l_dec_first_date
4511: or l_effective_date > l_year_end_date then
4512: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
4513: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
4514: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
4515: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
4516: fnd_message.raise_error;
4517: end if;
4518: --
4511: or l_effective_date > l_year_end_date then
4512: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
4513: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
4514: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
4515: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
4516: fnd_message.raise_error;
4517: end if;
4518: --
4519: -- for api use
4512: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_TRANS_DATE');
4513: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_chardate(l_assact_rec.effective_date));
4514: fnd_message.set_token('DEC_FIRST_DATE', fnd_date.date_to_chardate(l_dec_first_date));
4515: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
4516: fnd_message.raise_error;
4517: end if;
4518: --
4519: -- for api use
4520: if p_create_session then
4683: --
4684: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
4685: --
4686: if l_assact_rec.transaction_status = 'U' then
4687: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
4688: fnd_message.raise_error;
4689: elsif l_assact_rec.transfer_status = 'E' then
4690: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
4691: fnd_message.raise_error;
4684: pay_jp_isdf_dml_pkg.lock_assact(p_action_information_id, p_object_version_number, l_assact_rec);
4685: --
4686: if l_assact_rec.transaction_status = 'U' then
4687: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
4688: fnd_message.raise_error;
4689: elsif l_assact_rec.transfer_status = 'E' then
4690: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
4691: fnd_message.raise_error;
4692: end if;
4686: if l_assact_rec.transaction_status = 'U' then
4687: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
4688: fnd_message.raise_error;
4689: elsif l_assact_rec.transfer_status = 'E' then
4690: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
4691: fnd_message.raise_error;
4692: end if;
4693: --
4694: if g_debug then
4687: fnd_message.set_name('PAY', 'PAY_JP_DEF_NOT_TRANSFERRED_YET');
4688: fnd_message.raise_error;
4689: elsif l_assact_rec.transfer_status = 'E' then
4690: fnd_message.set_name('PAY', 'PAY_JP_DEF_ALREADY_EXPIRED');
4691: fnd_message.raise_error;
4692: end if;
4693: --
4694: if g_debug then
4695: hr_utility.set_location(l_proc,20);
4708: -- (transfer_date is always set since transfer_status check has been done)
4709: if p_expiry_date < l_assact_rec.effective_date
4710: or p_expiry_date < l_assact_rec.transfer_date
4711: or p_expiry_date > l_year_end_date then
4712: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_EXP_DATE');
4713: fnd_message.set_token('TRANSFER_DATE', fnd_date.date_to_chardate(l_assact_rec.transfer_date));
4714: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
4715: fnd_message.raise_error;
4716: end if;
4709: if p_expiry_date < l_assact_rec.effective_date
4710: or p_expiry_date < l_assact_rec.transfer_date
4711: or p_expiry_date > l_year_end_date then
4712: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_EXP_DATE');
4713: fnd_message.set_token('TRANSFER_DATE', fnd_date.date_to_chardate(l_assact_rec.transfer_date));
4714: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
4715: fnd_message.raise_error;
4716: end if;
4717: --
4710: or p_expiry_date < l_assact_rec.transfer_date
4711: or p_expiry_date > l_year_end_date then
4712: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_EXP_DATE');
4713: fnd_message.set_token('TRANSFER_DATE', fnd_date.date_to_chardate(l_assact_rec.transfer_date));
4714: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
4715: fnd_message.raise_error;
4716: end if;
4717: --
4718: -- l_dec_first_date or effective_date <= l_transfer_date <= l_year_end_date
4711: or p_expiry_date > l_year_end_date then
4712: fnd_message.set_name('PAY', 'PAY_JP_ISDF_INVALID_EXP_DATE');
4713: fnd_message.set_token('TRANSFER_DATE', fnd_date.date_to_chardate(l_assact_rec.transfer_date));
4714: fnd_message.set_token('YEAR_END_DATE', fnd_date.date_to_chardate(l_year_end_date));
4715: fnd_message.raise_error;
4716: end if;
4717: --
4718: -- l_dec_first_date or effective_date <= l_transfer_date <= l_year_end_date
4719: -- l_transfer_date <= l_expirty_date <= l_year_end_date
4839: --
4840: if sqlcode = -20001 then
4841: --
4842: declare
4843: l_sqlerrm varchar2(2000) := fnd_message.get;
4844: begin
4845: if l_sqlerrm is not null then
4846: return l_sqlerrm;
4847: else