DBA Data[Home] [Help]

APPS.PAY_PAY_BUS dependencies on FND_MESSAGE

Line 65: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

61: close csr_sec_grp;
62: --
63: -- The primary key is invalid therefore we must error
64: --
65: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
66: hr_multi_message.add
67: (p_associated_column1
68: => nvl(p_associated_column1,'PAYROLL_ID')
69: );

Line 146: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

142: --
143: -- The primary key is invalid therefore we must error
144: --
145: close csr_leg_code;
146: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
147: fnd_message.raise_error;
148: --
149: end if;
150: --

Line 147: fnd_message.raise_error;

143: -- The primary key is invalid therefore we must error
144: --
145: close csr_leg_code;
146: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
147: fnd_message.raise_error;
148: --
149: end if;
150: --
151: hr_utility.set_location(l_proc,30);

Line 528: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

524: (p_payroll_id => p_rec.payroll_id
525: ,p_effective_date => p_effective_date
526: ,p_object_version_number => p_rec.object_version_number
527: ) THEN
528: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
529: fnd_message.set_token('PROCEDURE ', l_proc);
530: fnd_message.set_token('STEP ', '5');
531: fnd_message.raise_error;
532: END IF;

Line 529: fnd_message.set_token('PROCEDURE ', l_proc);

525: ,p_effective_date => p_effective_date
526: ,p_object_version_number => p_rec.object_version_number
527: ) THEN
528: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
529: fnd_message.set_token('PROCEDURE ', l_proc);
530: fnd_message.set_token('STEP ', '5');
531: fnd_message.raise_error;
532: END IF;
533:

Line 530: fnd_message.set_token('STEP ', '5');

526: ,p_object_version_number => p_rec.object_version_number
527: ) THEN
528: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
529: fnd_message.set_token('PROCEDURE ', l_proc);
530: fnd_message.set_token('STEP ', '5');
531: fnd_message.raise_error;
532: END IF;
533:
534: if nvl(p_rec.gl_set_of_books_id, hr_api.g_number) <>

Line 531: fnd_message.raise_error;

527: ) THEN
528: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
529: fnd_message.set_token('PROCEDURE ', l_proc);
530: fnd_message.set_token('STEP ', '5');
531: fnd_message.raise_error;
532: END IF;
533:
534: if nvl(p_rec.gl_set_of_books_id, hr_api.g_number) <>
535: nvl(pay_pay_shd.g_old_rec.gl_set_of_books_id, hr_api.g_number) then

Line 728: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

724: ,p_base_key_column => 'ORG_PAYMENT_METHOD_ID'
725: ,p_base_key_value => p_org_payment_method_id
726: ,p_from_date => p_validation_start_date
727: ,p_to_date => p_validation_end_date))) Then
728: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
729: fnd_message.set_token('TABLE_NAME','org payment methods');
730: hr_multi_message.add
731: (p_associated_column1 => pay_pay_shd.g_tab_nam || '.ORG_PAYMENT_METHOD_ID');
732: --

Line 729: fnd_message.set_token('TABLE_NAME','org payment methods');

725: ,p_base_key_value => p_org_payment_method_id
726: ,p_from_date => p_validation_start_date
727: ,p_to_date => p_validation_end_date))) Then
728: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
729: fnd_message.set_token('TABLE_NAME','org payment methods');
730: hr_multi_message.add
731: (p_associated_column1 => pay_pay_shd.g_tab_nam || '.ORG_PAYMENT_METHOD_ID');
732: --
733: End If;

Line 742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

738: --
739: -- An unhandled or unexpected error has occurred which
740: -- we must report
741: --
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','15');
745: fnd_message.raise_error;
746: --

Line 743: fnd_message.set_token('PROCEDURE', l_proc);

739: -- An unhandled or unexpected error has occurred which
740: -- we must report
741: --
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','15');
745: fnd_message.raise_error;
746: --
747: End dt_update_validate;

Line 744: fnd_message.set_token('STEP','15');

740: -- we must report
741: --
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','15');
745: fnd_message.raise_error;
746: --
747: End dt_update_validate;
748: --

Line 745: fnd_message.raise_error;

741: --
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','15');
745: fnd_message.raise_error;
746: --
747: End dt_update_validate;
748: --
749: -- ----------------------------------------------------------------------------

Line 884: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

880: --
881: -- A referential integrity check was violated therefore
882: -- we must error
883: --
884: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
885: fnd_message.set_token('TABLE_NAME', l_table_name);
886: fnd_message.raise_error;
887:
888: When Others Then

Line 885: fnd_message.set_token('TABLE_NAME', l_table_name);

881: -- A referential integrity check was violated therefore
882: -- we must error
883: --
884: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
885: fnd_message.set_token('TABLE_NAME', l_table_name);
886: fnd_message.raise_error;
887:
888: When Others Then
889: --

Line 886: fnd_message.raise_error;

882: -- we must error
883: --
884: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
885: fnd_message.set_token('TABLE_NAME', l_table_name);
886: fnd_message.raise_error;
887:
888: When Others Then
889: --
890: -- An unhandled or unexpected error has occurred which

Line 893: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

889: --
890: -- An unhandled or unexpected error has occurred which
891: -- we must report
892: --
893: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
894: fnd_message.set_token('PROCEDURE', l_proc);
895: fnd_message.set_token('STEP','15');
896: fnd_message.raise_error;
897: --

Line 894: fnd_message.set_token('PROCEDURE', l_proc);

890: -- An unhandled or unexpected error has occurred which
891: -- we must report
892: --
893: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
894: fnd_message.set_token('PROCEDURE', l_proc);
895: fnd_message.set_token('STEP','15');
896: fnd_message.raise_error;
897: --
898: End dt_delete_validate;

Line 895: fnd_message.set_token('STEP','15');

891: -- we must report
892: --
893: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
894: fnd_message.set_token('PROCEDURE', l_proc);
895: fnd_message.set_token('STEP','15');
896: fnd_message.raise_error;
897: --
898: End dt_delete_validate;
899: --

Line 896: fnd_message.raise_error;

892: --
893: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
894: fnd_message.set_token('PROCEDURE', l_proc);
895: fnd_message.set_token('STEP','15');
896: fnd_message.raise_error;
897: --
898: End dt_delete_validate;
899: --
900: --

Line 955: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

951: --
952: -- Payment method must exist in PAY_ORG_PAYMENT_METHODS_F
953: --
954: if v_count = 0 then
955: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
956: fnd_message.set_token('COLUMN','DEFAULT_PAYMENT_METHOD_ID');
957: fnd_message.set_token('TABLE','PAY_ORG_PAYMENT_METHODS_F');
958: fnd_message.raise_error;
959: end if;

Line 956: fnd_message.set_token('COLUMN','DEFAULT_PAYMENT_METHOD_ID');

952: -- Payment method must exist in PAY_ORG_PAYMENT_METHODS_F
953: --
954: if v_count = 0 then
955: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
956: fnd_message.set_token('COLUMN','DEFAULT_PAYMENT_METHOD_ID');
957: fnd_message.set_token('TABLE','PAY_ORG_PAYMENT_METHODS_F');
958: fnd_message.raise_error;
959: end if;
960: --

Line 957: fnd_message.set_token('TABLE','PAY_ORG_PAYMENT_METHODS_F');

953: --
954: if v_count = 0 then
955: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
956: fnd_message.set_token('COLUMN','DEFAULT_PAYMENT_METHOD_ID');
957: fnd_message.set_token('TABLE','PAY_ORG_PAYMENT_METHODS_F');
958: fnd_message.raise_error;
959: end if;
960: --
961: -- Payment method must be valid for the lifetime of payroll

Line 958: fnd_message.raise_error;

954: if v_count = 0 then
955: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
956: fnd_message.set_token('COLUMN','DEFAULT_PAYMENT_METHOD_ID');
957: fnd_message.set_token('TABLE','PAY_ORG_PAYMENT_METHODS_F');
958: fnd_message.raise_error;
959: end if;
960: --
961: -- Payment method must be valid for the lifetime of payroll
962: --

Line 965: fnd_message.set_name('PAY', 'HR_7096_PAYM_PYRLL_DFLT_INVID');

961: -- Payment method must be valid for the lifetime of payroll
962: --
963: if v_start_date > p_effective_date or v_end_date < hr_api.g_eot then
964: --
965: fnd_message.set_name('PAY', 'HR_7096_PAYM_PYRLL_DFLT_INVID');
966: fnd_message.raise_error;
967: --
968: end if;
969: --

Line 966: fnd_message.raise_error;

962: --
963: if v_start_date > p_effective_date or v_end_date < hr_api.g_eot then
964: --
965: fnd_message.set_name('PAY', 'HR_7096_PAYM_PYRLL_DFLT_INVID');
966: fnd_message.raise_error;
967: --
968: end if;
969: --
970: -- Payment Method category must be either 'Cash' or 'Cheque' and

Line 978: fnd_message.set_name('PAY', 'PAY_34175_PRL_CATG_ASS_REM');

974: fetch csr_pay_catg_ass_remun into g_exists;
975: if csr_pay_catg_ass_remun%notfound then
976: --
977: close csr_pay_catg_ass_remun;
978: fnd_message.set_name('PAY', 'PAY_34175_PRL_CATG_ASS_REM');
979: fnd_message.raise_error;
980: --
981: end if;
982: close csr_pay_catg_ass_remun;

Line 979: fnd_message.raise_error;

975: if csr_pay_catg_ass_remun%notfound then
976: --
977: close csr_pay_catg_ass_remun;
978: fnd_message.set_name('PAY', 'PAY_34175_PRL_CATG_ASS_REM');
979: fnd_message.raise_error;
980: --
981: end if;
982: close csr_pay_catg_ass_remun;
983: --

Line 1024: fnd_message.set_name('PAY','PAY_6601_PAYROLL_INV_PERIOD_TP');

1020: fetch csr_chk_parent into g_exists;
1021: if csr_chk_parent%notfound then
1022: --
1023: close csr_chk_parent;
1024: fnd_message.set_name('PAY','PAY_6601_PAYROLL_INV_PERIOD_TP');
1025: fnd_message.raise_error;
1026: --
1027: end if;
1028: close csr_chk_parent;

Line 1025: fnd_message.raise_error;

1021: if csr_chk_parent%notfound then
1022: --
1023: close csr_chk_parent;
1024: fnd_message.set_name('PAY','PAY_6601_PAYROLL_INV_PERIOD_TP');
1025: fnd_message.raise_error;
1026: --
1027: end if;
1028: close csr_chk_parent;
1029: --

Line 1035: fnd_message.set_name('PAY', 'ALL_PROCEDURE_FAIL');

1031: fetch csr_basic_period_type into p_basic_period_type, p_periods_per_period;
1032: if csr_basic_period_type%notfound then
1033: --
1034: close csr_basic_period_type;
1035: fnd_message.set_name('PAY', 'ALL_PROCEDURE_FAIL');
1036: fnd_message.set_token('PROCEDURE','chk_period_type');
1037: fnd_message.set_token('STEP', 1);
1038: fnd_message.raise_error;
1039: --

Line 1036: fnd_message.set_token('PROCEDURE','chk_period_type');

1032: if csr_basic_period_type%notfound then
1033: --
1034: close csr_basic_period_type;
1035: fnd_message.set_name('PAY', 'ALL_PROCEDURE_FAIL');
1036: fnd_message.set_token('PROCEDURE','chk_period_type');
1037: fnd_message.set_token('STEP', 1);
1038: fnd_message.raise_error;
1039: --
1040: end if;

Line 1037: fnd_message.set_token('STEP', 1);

1033: --
1034: close csr_basic_period_type;
1035: fnd_message.set_name('PAY', 'ALL_PROCEDURE_FAIL');
1036: fnd_message.set_token('PROCEDURE','chk_period_type');
1037: fnd_message.set_token('STEP', 1);
1038: fnd_message.raise_error;
1039: --
1040: end if;
1041: close csr_basic_period_type;

Line 1038: fnd_message.raise_error;

1034: close csr_basic_period_type;
1035: fnd_message.set_name('PAY', 'ALL_PROCEDURE_FAIL');
1036: fnd_message.set_token('PROCEDURE','chk_period_type');
1037: fnd_message.set_token('STEP', 1);
1038: fnd_message.raise_error;
1039: --
1040: end if;
1041: close csr_basic_period_type;
1042: --

Line 1047: fnd_message.set_name('PAY','PAY_34176_PRL_INVLD_GB_PRD');

1043: -- For 'GB' legislation, the basic period type must not be Semi-Month.
1044: --
1045: if (p_legislation_code = 'GB' and p_basic_period_type = 'SM') then
1046: --
1047: fnd_message.set_name('PAY','PAY_34176_PRL_INVLD_GB_PRD');
1048: fnd_message.raise_error;
1049: --
1050: end if;
1051: --

Line 1048: fnd_message.raise_error;

1044: --
1045: if (p_legislation_code = 'GB' and p_basic_period_type = 'SM') then
1046: --
1047: fnd_message.set_name('PAY','PAY_34176_PRL_INVLD_GB_PRD');
1048: fnd_message.raise_error;
1049: --
1050: end if;
1051: --
1052: end chk_period_type;

Line 1074: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

1070:
1071:
1072: exception
1073: when no_data_found then
1074: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1075: fnd_message.set_token('COLUMN','CONSOLIDATION_SET_ID');
1076: fnd_message.set_token('TABLE','PAY_CONSOLIDATION_SETS');
1077: fnd_message.raise_error;
1078: end chk_consolidation_set_id;

Line 1075: fnd_message.set_token('COLUMN','CONSOLIDATION_SET_ID');

1071:
1072: exception
1073: when no_data_found then
1074: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1075: fnd_message.set_token('COLUMN','CONSOLIDATION_SET_ID');
1076: fnd_message.set_token('TABLE','PAY_CONSOLIDATION_SETS');
1077: fnd_message.raise_error;
1078: end chk_consolidation_set_id;
1079: --

Line 1076: fnd_message.set_token('TABLE','PAY_CONSOLIDATION_SETS');

1072: exception
1073: when no_data_found then
1074: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1075: fnd_message.set_token('COLUMN','CONSOLIDATION_SET_ID');
1076: fnd_message.set_token('TABLE','PAY_CONSOLIDATION_SETS');
1077: fnd_message.raise_error;
1078: end chk_consolidation_set_id;
1079: --
1080: -- ----------------------------------------------------------------------------

Line 1077: fnd_message.raise_error;

1073: when no_data_found then
1074: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1075: fnd_message.set_token('COLUMN','CONSOLIDATION_SET_ID');
1076: fnd_message.set_token('TABLE','PAY_CONSOLIDATION_SETS');
1077: fnd_message.raise_error;
1078: end chk_consolidation_set_id;
1079: --
1080: -- ----------------------------------------------------------------------------
1081: -- |-------------------------< get_legislation_rules >------------------------|

Line 1174: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');

1170: ,p_arrears_flag_rule => p_arrears_flag_rule
1171: );
1172: --
1173: if p_cut_off_date_offset <> 0 and l_cutoff_date_rule = 'N' then
1174: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1175: fnd_message.set_token('COLUMN','Cut Off Date Offset');
1176: fnd_message.raise_error;
1177: end if;
1178: --

Line 1175: fnd_message.set_token('COLUMN','Cut Off Date Offset');

1171: );
1172: --
1173: if p_cut_off_date_offset <> 0 and l_cutoff_date_rule = 'N' then
1174: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1175: fnd_message.set_token('COLUMN','Cut Off Date Offset');
1176: fnd_message.raise_error;
1177: end if;
1178: --
1179: if p_direct_deposit_date_offset <> 0 and l_dd_date_rule = 'N' then

Line 1176: fnd_message.raise_error;

1172: --
1173: if p_cut_off_date_offset <> 0 and l_cutoff_date_rule = 'N' then
1174: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1175: fnd_message.set_token('COLUMN','Cut Off Date Offset');
1176: fnd_message.raise_error;
1177: end if;
1178: --
1179: if p_direct_deposit_date_offset <> 0 and l_dd_date_rule = 'N' then
1180: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');

Line 1180: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');

1176: fnd_message.raise_error;
1177: end if;
1178: --
1179: if p_direct_deposit_date_offset <> 0 and l_dd_date_rule = 'N' then
1180: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1181: fnd_message.set_token('COLUMN','Direct Deposit Date Offset');
1182: fnd_message.raise_error;
1183: end if;
1184: --

Line 1181: fnd_message.set_token('COLUMN','Direct Deposit Date Offset');

1177: end if;
1178: --
1179: if p_direct_deposit_date_offset <> 0 and l_dd_date_rule = 'N' then
1180: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1181: fnd_message.set_token('COLUMN','Direct Deposit Date Offset');
1182: fnd_message.raise_error;
1183: end if;
1184: --
1185: if p_pay_advice_date_offset <> 0 and l_pay_adv_date_rule = 'N' then

Line 1182: fnd_message.raise_error;

1178: --
1179: if p_direct_deposit_date_offset <> 0 and l_dd_date_rule = 'N' then
1180: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1181: fnd_message.set_token('COLUMN','Direct Deposit Date Offset');
1182: fnd_message.raise_error;
1183: end if;
1184: --
1185: if p_pay_advice_date_offset <> 0 and l_pay_adv_date_rule = 'N' then
1186: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');

Line 1186: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');

1182: fnd_message.raise_error;
1183: end if;
1184: --
1185: if p_pay_advice_date_offset <> 0 and l_pay_adv_date_rule = 'N' then
1186: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1187: fnd_message.set_token('COLUMN','Pay Advice Date Offset');
1188: fnd_message.raise_error;
1189: end if;
1190: --

Line 1187: fnd_message.set_token('COLUMN','Pay Advice Date Offset');

1183: end if;
1184: --
1185: if p_pay_advice_date_offset <> 0 and l_pay_adv_date_rule = 'N' then
1186: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1187: fnd_message.set_token('COLUMN','Pay Advice Date Offset');
1188: fnd_message.raise_error;
1189: end if;
1190: --
1191: if l_pay_date_rule = 'N' then

Line 1188: fnd_message.raise_error;

1184: --
1185: if p_pay_advice_date_offset <> 0 and l_pay_adv_date_rule = 'N' then
1186: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1187: fnd_message.set_token('COLUMN','Pay Advice Date Offset');
1188: fnd_message.raise_error;
1189: end if;
1190: --
1191: if l_pay_date_rule = 'N' then
1192: --

Line 1216: fnd_message.set_name('PAY', 'PAY_6992_PAY_OFFSET_RANGE');

1212: -- allowable offset.
1213: --
1214: if p_pay_date_offset > 0 or p_pay_date_offset < l_max_offset then
1215: --
1216: fnd_message.set_name('PAY', 'PAY_6992_PAY_OFFSET_RANGE');
1217: fnd_message.set_token('MAX_OFFSET', to_char(l_max_offset), false);
1218: fnd_message.raise_error;
1219: --
1220: end if;

Line 1217: fnd_message.set_token('MAX_OFFSET', to_char(l_max_offset), false);

1213: --
1214: if p_pay_date_offset > 0 or p_pay_date_offset < l_max_offset then
1215: --
1216: fnd_message.set_name('PAY', 'PAY_6992_PAY_OFFSET_RANGE');
1217: fnd_message.set_token('MAX_OFFSET', to_char(l_max_offset), false);
1218: fnd_message.raise_error;
1219: --
1220: end if;
1221: --

Line 1218: fnd_message.raise_error;

1214: if p_pay_date_offset > 0 or p_pay_date_offset < l_max_offset then
1215: --
1216: fnd_message.set_name('PAY', 'PAY_6992_PAY_OFFSET_RANGE');
1217: fnd_message.set_token('MAX_OFFSET', to_char(l_max_offset), false);
1218: fnd_message.raise_error;
1219: --
1220: end if;
1221: --
1222: end if;

Line 1245: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1241: (p_effective_date
1242: ,'YES_NO'
1243: ,p_negative_pay_allowed_flag) then
1244: --
1245: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1246: fnd_message.set_token('COLUMN','NEGATIVE_PAY_ALLOWED_FLAG');
1247: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1248: fnd_message.raise_error;
1249: --

Line 1246: fnd_message.set_token('COLUMN','NEGATIVE_PAY_ALLOWED_FLAG');

1242: ,'YES_NO'
1243: ,p_negative_pay_allowed_flag) then
1244: --
1245: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1246: fnd_message.set_token('COLUMN','NEGATIVE_PAY_ALLOWED_FLAG');
1247: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1248: fnd_message.raise_error;
1249: --
1250: end If;

Line 1247: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1243: ,p_negative_pay_allowed_flag) then
1244: --
1245: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1246: fnd_message.set_token('COLUMN','NEGATIVE_PAY_ALLOWED_FLAG');
1247: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1248: fnd_message.raise_error;
1249: --
1250: end If;
1251: end chk_negative_pay_allowed_flag;

Line 1248: fnd_message.raise_error;

1244: --
1245: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1246: fnd_message.set_token('COLUMN','NEGATIVE_PAY_ALLOWED_FLAG');
1247: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1248: fnd_message.raise_error;
1249: --
1250: end If;
1251: end chk_negative_pay_allowed_flag;
1252: --

Line 1287: fnd_message.set_name('PAY','HR_6485_PAYROLL_YEARS');

1283: -- The number of years must be greater than zero.
1284: --
1285: if p_number_of_years <= 0 then
1286: --
1287: fnd_message.set_name('PAY','HR_6485_PAYROLL_YEARS');
1288: fnd_message.raise_error;
1289: --
1290: end if;
1291: --

Line 1288: fnd_message.raise_error;

1284: --
1285: if p_number_of_years <= 0 then
1286: --
1287: fnd_message.set_name('PAY','HR_6485_PAYROLL_YEARS');
1288: fnd_message.raise_error;
1289: --
1290: end if;
1291: --
1292: -- Make sure that the number of years can only be increased NB. if the current

Line 1302: fnd_message.set_name('PAY', 'HR_6495_PAY_UPD_YEARS');

1298: close csr_current_values;
1299: --
1300: if p_number_of_years < l_values_rec.number_of_years then
1301: --
1302: fnd_message.set_name('PAY', 'HR_6495_PAY_UPD_YEARS');
1303: fnd_message.raise_error;
1304: --
1305: end if;
1306: --

Line 1303: fnd_message.raise_error;

1299: --
1300: if p_number_of_years < l_values_rec.number_of_years then
1301: --
1302: fnd_message.set_name('PAY', 'HR_6495_PAY_UPD_YEARS');
1303: fnd_message.raise_error;
1304: --
1305: end if;
1306: --
1307: -- The number of years should be within the lifetime of the payroll

Line 1314: fnd_message.set_name('PAY','PAY_34165_PAYROLL_YEARS');

1310: round(months_between(l_values_rec.max_payroll_end_date,l_values_rec.min_payroll_start_date))/12;
1311:
1312: if p_number_of_years > l_max_payroll_years then
1313: --
1314: fnd_message.set_name('PAY','PAY_34165_PAYROLL_YEARS');
1315: fnd_message.set_token('YEARS',to_char(l_max_payroll_years));
1316: fnd_message.raise_error;
1317: --
1318: end if;

Line 1315: fnd_message.set_token('YEARS',to_char(l_max_payroll_years));

1311:
1312: if p_number_of_years > l_max_payroll_years then
1313: --
1314: fnd_message.set_name('PAY','PAY_34165_PAYROLL_YEARS');
1315: fnd_message.set_token('YEARS',to_char(l_max_payroll_years));
1316: fnd_message.raise_error;
1317: --
1318: end if;
1319: --

Line 1316: fnd_message.raise_error;

1312: if p_number_of_years > l_max_payroll_years then
1313: --
1314: fnd_message.set_name('PAY','PAY_34165_PAYROLL_YEARS');
1315: fnd_message.set_token('YEARS',to_char(l_max_payroll_years));
1316: fnd_message.raise_error;
1317: --
1318: end if;
1319: --
1320: end if;

Line 1370: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1366: (p_effective_date
1367: ,'YES_NO'
1368: ,p_arrears_flag) then
1369: --
1370: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1371: fnd_message.set_token('COLUMN','ARREARS_FLAG');
1372: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1373: fnd_message.raise_error;
1374: --

Line 1371: fnd_message.set_token('COLUMN','ARREARS_FLAG');

1367: ,'YES_NO'
1368: ,p_arrears_flag) then
1369: --
1370: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1371: fnd_message.set_token('COLUMN','ARREARS_FLAG');
1372: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1373: fnd_message.raise_error;
1374: --
1375: end if;

Line 1372: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1368: ,p_arrears_flag) then
1369: --
1370: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1371: fnd_message.set_token('COLUMN','ARREARS_FLAG');
1372: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1373: fnd_message.raise_error;
1374: --
1375: end if;
1376: --

Line 1373: fnd_message.raise_error;

1369: --
1370: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1371: fnd_message.set_token('COLUMN','ARREARS_FLAG');
1372: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1373: fnd_message.raise_error;
1374: --
1375: end if;
1376: --
1377: if (p_arrears_flag = 'Y' and p_arrears_flag_rule is null) then

Line 1379: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');

1375: end if;
1376: --
1377: if (p_arrears_flag = 'Y' and p_arrears_flag_rule is null) then
1378: --
1379: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1380: fnd_message.set_token('COLUMN','Arrears Flag');
1381: fnd_message.raise_error;
1382: --
1383: end if;

Line 1380: fnd_message.set_token('COLUMN','Arrears Flag');

1376: --
1377: if (p_arrears_flag = 'Y' and p_arrears_flag_rule is null) then
1378: --
1379: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1380: fnd_message.set_token('COLUMN','Arrears Flag');
1381: fnd_message.raise_error;
1382: --
1383: end if;
1384: --

Line 1381: fnd_message.raise_error;

1377: if (p_arrears_flag = 'Y' and p_arrears_flag_rule is null) then
1378: --
1379: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1380: fnd_message.set_token('COLUMN','Arrears Flag');
1381: fnd_message.raise_error;
1382: --
1383: end if;
1384: --
1385: end chk_arrears_flag;

Line 1410: fnd_message.set_name('PAY','HR_51901_INVALID_PAYROLL_TYPE');

1406: (p_effective_date
1407: ,'PAYROLL_TYPE'
1408: ,p_payroll_type) then
1409: --
1410: fnd_message.set_name('PAY','HR_51901_INVALID_PAYROLL_TYPE');
1411: fnd_message.raise_error;
1412: --
1413: end if;
1414: --

Line 1411: fnd_message.raise_error;

1407: ,'PAYROLL_TYPE'
1408: ,p_payroll_type) then
1409: --
1410: fnd_message.set_name('PAY','HR_51901_INVALID_PAYROLL_TYPE');
1411: fnd_message.raise_error;
1412: --
1413: end if;
1414: --
1415: end chk_payroll_type;

Line 1455: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');

1451: fetch get_legislation_rule into l_rule_mode;
1452: if get_legislation_rule%notfound then
1453: --
1454: close get_legislation_rule;
1455: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1456: fnd_message.set_token('COLUMN','Multi Assignments Flag');
1457: fnd_message.raise_error;
1458: --
1459: elsif l_rule_mode = 'N' then

Line 1456: fnd_message.set_token('COLUMN','Multi Assignments Flag');

1452: if get_legislation_rule%notfound then
1453: --
1454: close get_legislation_rule;
1455: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1456: fnd_message.set_token('COLUMN','Multi Assignments Flag');
1457: fnd_message.raise_error;
1458: --
1459: elsif l_rule_mode = 'N' then
1460: --

Line 1457: fnd_message.raise_error;

1453: --
1454: close get_legislation_rule;
1455: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1456: fnd_message.set_token('COLUMN','Multi Assignments Flag');
1457: fnd_message.raise_error;
1458: --
1459: elsif l_rule_mode = 'N' then
1460: --
1461: close get_legislation_rule;

Line 1462: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');

1458: --
1459: elsif l_rule_mode = 'N' then
1460: --
1461: close get_legislation_rule;
1462: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1463: fnd_message.set_token('COLUMN','Multi Assignments Flag');
1464: fnd_message.raise_error;
1465: --
1466: end if;

Line 1463: fnd_message.set_token('COLUMN','Multi Assignments Flag');

1459: elsif l_rule_mode = 'N' then
1460: --
1461: close get_legislation_rule;
1462: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1463: fnd_message.set_token('COLUMN','Multi Assignments Flag');
1464: fnd_message.raise_error;
1465: --
1466: end if;
1467: close get_legislation_rule;

Line 1464: fnd_message.raise_error;

1460: --
1461: close get_legislation_rule;
1462: fnd_message.set_name('PAY','PAY_34174_PRL_INVALID_LEG_RULE');
1463: fnd_message.set_token('COLUMN','Multi Assignments Flag');
1464: fnd_message.raise_error;
1465: --
1466: end if;
1467: close get_legislation_rule;
1468: --

Line 1476: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1472: (p_effective_date
1473: ,'YES_NO'
1474: ,p_multi_assignments_flag) then
1475: --
1476: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1477: fnd_message.set_token('COLUMN','MULTI_ASSIGNMENTS_FLAG');
1478: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1479: fnd_message.raise_error;
1480: --

Line 1477: fnd_message.set_token('COLUMN','MULTI_ASSIGNMENTS_FLAG');

1473: ,'YES_NO'
1474: ,p_multi_assignments_flag) then
1475: --
1476: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1477: fnd_message.set_token('COLUMN','MULTI_ASSIGNMENTS_FLAG');
1478: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1479: fnd_message.raise_error;
1480: --
1481: end if;

Line 1478: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1474: ,p_multi_assignments_flag) then
1475: --
1476: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1477: fnd_message.set_token('COLUMN','MULTI_ASSIGNMENTS_FLAG');
1478: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1479: fnd_message.raise_error;
1480: --
1481: end if;
1482: --

Line 1479: fnd_message.raise_error;

1475: --
1476: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1477: fnd_message.set_token('COLUMN','MULTI_ASSIGNMENTS_FLAG');
1478: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1479: fnd_message.raise_error;
1480: --
1481: end if;
1482: --
1483: end chk_multi_assignments_flag;

Line 1505: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

1501: --
1502: if (fnd_profile.value('PAY_PERIOD_RESET_YEARS') <> 'Y' and
1503: p_period_reset_years is not null) then
1504: --
1505: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1506: fnd_message.set_token('PROCEDURE', l_proc);
1507: fnd_message.set_token('STEP','10');
1508: fnd_message.raise_error;
1509: --

Line 1506: fnd_message.set_token('PROCEDURE', l_proc);

1502: if (fnd_profile.value('PAY_PERIOD_RESET_YEARS') <> 'Y' and
1503: p_period_reset_years is not null) then
1504: --
1505: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1506: fnd_message.set_token('PROCEDURE', l_proc);
1507: fnd_message.set_token('STEP','10');
1508: fnd_message.raise_error;
1509: --
1510: end if;

Line 1507: fnd_message.set_token('STEP','10');

1503: p_period_reset_years is not null) then
1504: --
1505: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1506: fnd_message.set_token('PROCEDURE', l_proc);
1507: fnd_message.set_token('STEP','10');
1508: fnd_message.raise_error;
1509: --
1510: end if;
1511: --

Line 1508: fnd_message.raise_error;

1504: --
1505: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1506: fnd_message.set_token('PROCEDURE', l_proc);
1507: fnd_message.set_token('STEP','10');
1508: fnd_message.raise_error;
1509: --
1510: end if;
1511: --
1512: if p_number_of_years is not null and p_period_reset_years not in ('N','L','F') then

Line 1514: fnd_message.set_name('PAY','PAY_34177_RESET_YRS_INVALID');

1510: end if;
1511: --
1512: if p_number_of_years is not null and p_period_reset_years not in ('N','L','F') then
1513: --
1514: fnd_message.set_name('PAY','PAY_34177_RESET_YRS_INVALID');
1515: fnd_message.raise_error;
1516: --
1517: end if;
1518: --

Line 1515: fnd_message.raise_error;

1511: --
1512: if p_number_of_years is not null and p_period_reset_years not in ('N','L','F') then
1513: --
1514: fnd_message.set_name('PAY','PAY_34177_RESET_YRS_INVALID');
1515: fnd_message.raise_error;
1516: --
1517: end if;
1518: --
1519: end chk_period_reset_years;

Line 1541: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1537: (p_effective_date
1538: ,'WORKLOAD_SHIFTING_LEVEL'
1539: ,p_workload_shifting_level) then
1540: --
1541: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1542: fnd_message.set_token('COLUMN','WORKLOAD_SHIFTING_LEVEL');
1543: fnd_message.set_token('LOOKUP_TYPE','WORKLOAD_SHIFTING_LEVEL');
1544: fnd_message.raise_error;
1545: --

Line 1542: fnd_message.set_token('COLUMN','WORKLOAD_SHIFTING_LEVEL');

1538: ,'WORKLOAD_SHIFTING_LEVEL'
1539: ,p_workload_shifting_level) then
1540: --
1541: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1542: fnd_message.set_token('COLUMN','WORKLOAD_SHIFTING_LEVEL');
1543: fnd_message.set_token('LOOKUP_TYPE','WORKLOAD_SHIFTING_LEVEL');
1544: fnd_message.raise_error;
1545: --
1546: end If;

Line 1543: fnd_message.set_token('LOOKUP_TYPE','WORKLOAD_SHIFTING_LEVEL');

1539: ,p_workload_shifting_level) then
1540: --
1541: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1542: fnd_message.set_token('COLUMN','WORKLOAD_SHIFTING_LEVEL');
1543: fnd_message.set_token('LOOKUP_TYPE','WORKLOAD_SHIFTING_LEVEL');
1544: fnd_message.raise_error;
1545: --
1546: end If;
1547: end chk_workload_shifting_level;

Line 1544: fnd_message.raise_error;

1540: --
1541: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1542: fnd_message.set_token('COLUMN','WORKLOAD_SHIFTING_LEVEL');
1543: fnd_message.set_token('LOOKUP_TYPE','WORKLOAD_SHIFTING_LEVEL');
1544: fnd_message.raise_error;
1545: --
1546: end If;
1547: end chk_workload_shifting_level;
1548: --

Line 1605: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

1601: fetch csr_chk_keyflexs into g_exists;
1602: if csr_chk_keyflexs%notfound then
1603: --
1604: close csr_chk_keyflexs;
1605: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1606: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');
1607: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1608: fnd_message.raise_error;
1609: --

Line 1606: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');

1602: if csr_chk_keyflexs%notfound then
1603: --
1604: close csr_chk_keyflexs;
1605: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1606: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');
1607: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1608: fnd_message.raise_error;
1609: --
1610: end if;

Line 1607: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');

1603: --
1604: close csr_chk_keyflexs;
1605: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1606: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');
1607: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1608: fnd_message.raise_error;
1609: --
1610: end if;
1611: close csr_chk_keyflexs;

Line 1608: fnd_message.raise_error;

1604: close csr_chk_keyflexs;
1605: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1606: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');
1607: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1608: fnd_message.raise_error;
1609: --
1610: end if;
1611: close csr_chk_keyflexs;
1612: --

Line 1627: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

1623: fetch csr_chk_keyflexs into g_exists;
1624: if csr_chk_keyflexs%notfound then
1625: --
1626: close csr_chk_keyflexs;
1627: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1628: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');
1629: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1630: fnd_message.raise_error;
1631: --

Line 1628: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');

1624: if csr_chk_keyflexs%notfound then
1625: --
1626: close csr_chk_keyflexs;
1627: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1628: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');
1629: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1630: fnd_message.raise_error;
1631: --
1632: end if;

Line 1629: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');

1625: --
1626: close csr_chk_keyflexs;
1627: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1628: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');
1629: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1630: fnd_message.raise_error;
1631: --
1632: end if;
1633: close csr_chk_keyflexs;

Line 1630: fnd_message.raise_error;

1626: close csr_chk_keyflexs;
1627: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1628: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');
1629: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1630: fnd_message.raise_error;
1631: --
1632: end if;
1633: close csr_chk_keyflexs;
1634: --

Line 1649: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

1645: fetch csr_chk_soft_coding_kff into g_exists;
1646: if csr_chk_soft_coding_kff%notfound then
1647: --
1648: close csr_chk_soft_coding_kff;
1649: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1650: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');
1651: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');
1652: fnd_message.raise_error;
1653: --

Line 1650: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');

1646: if csr_chk_soft_coding_kff%notfound then
1647: --
1648: close csr_chk_soft_coding_kff;
1649: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1650: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');
1651: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');
1652: fnd_message.raise_error;
1653: --
1654: end if;

Line 1651: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');

1647: --
1648: close csr_chk_soft_coding_kff;
1649: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1650: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');
1651: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');
1652: fnd_message.raise_error;
1653: --
1654: end if;
1655: close csr_chk_soft_coding_kff;

Line 1652: fnd_message.raise_error;

1648: close csr_chk_soft_coding_kff;
1649: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1650: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');
1651: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');
1652: fnd_message.raise_error;
1653: --
1654: end if;
1655: close csr_chk_soft_coding_kff;
1656: --

Line 1668: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

1664: fetch csr_chk_set_of_books into g_exists;
1665: if csr_chk_set_of_books%notfound then
1666: --
1667: close csr_chk_set_of_books;
1668: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1669: fnd_message.set_token('COLUMN','GL_SET_OF_BOOKS_ID');
1670: fnd_message.set_token('TABLE','GL_SETS_OF_BOOKS');
1671: fnd_message.raise_error;
1672: --

Line 1669: fnd_message.set_token('COLUMN','GL_SET_OF_BOOKS_ID');

1665: if csr_chk_set_of_books%notfound then
1666: --
1667: close csr_chk_set_of_books;
1668: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1669: fnd_message.set_token('COLUMN','GL_SET_OF_BOOKS_ID');
1670: fnd_message.set_token('TABLE','GL_SETS_OF_BOOKS');
1671: fnd_message.raise_error;
1672: --
1673: end if;

Line 1670: fnd_message.set_token('TABLE','GL_SETS_OF_BOOKS');

1666: --
1667: close csr_chk_set_of_books;
1668: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1669: fnd_message.set_token('COLUMN','GL_SET_OF_BOOKS_ID');
1670: fnd_message.set_token('TABLE','GL_SETS_OF_BOOKS');
1671: fnd_message.raise_error;
1672: --
1673: end if;
1674: --

Line 1671: fnd_message.raise_error;

1667: close csr_chk_set_of_books;
1668: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1669: fnd_message.set_token('COLUMN','GL_SET_OF_BOOKS_ID');
1670: fnd_message.set_token('TABLE','GL_SETS_OF_BOOKS');
1671: fnd_message.raise_error;
1672: --
1673: end if;
1674: --
1675: close csr_chk_set_of_books;

Line 1686: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

1682: fetch csr_chk_org into g_exists;
1683: if csr_chk_org%notfound then
1684: --
1685: close csr_chk_org;
1686: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1687: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
1688: fnd_message.set_token('TABLE','HR_ORGANIZATION_UNITS');
1689: fnd_message.raise_error;
1690: --

Line 1687: fnd_message.set_token('COLUMN','ORGANIZATION_ID');

1683: if csr_chk_org%notfound then
1684: --
1685: close csr_chk_org;
1686: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1687: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
1688: fnd_message.set_token('TABLE','HR_ORGANIZATION_UNITS');
1689: fnd_message.raise_error;
1690: --
1691: end if;

Line 1688: fnd_message.set_token('TABLE','HR_ORGANIZATION_UNITS');

1684: --
1685: close csr_chk_org;
1686: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1687: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
1688: fnd_message.set_token('TABLE','HR_ORGANIZATION_UNITS');
1689: fnd_message.raise_error;
1690: --
1691: end if;
1692: --

Line 1689: fnd_message.raise_error;

1685: close csr_chk_org;
1686: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1687: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
1688: fnd_message.set_token('TABLE','HR_ORGANIZATION_UNITS');
1689: fnd_message.raise_error;
1690: --
1691: end if;
1692: --
1693: close csr_chk_org;

Line 1895: fnd_message.set_name('PAY', 'PAY_KR_INV_CS_BG');

1891: pay_pay_bus.chk_consolidation_set_id( p_rec.consolidation_set_id,
1892: l_business_group_id );
1893: if (l_business_group_id <> p_rec.business_group_id) then
1894: --
1895: fnd_message.set_name('PAY', 'PAY_KR_INV_CS_BG');
1896: fnd_message.raise_error;
1897: --
1898: end if;
1899: --

Line 1896: fnd_message.raise_error;

1892: l_business_group_id );
1893: if (l_business_group_id <> p_rec.business_group_id) then
1894: --
1895: fnd_message.set_name('PAY', 'PAY_KR_INV_CS_BG');
1896: fnd_message.raise_error;
1897: --
1898: end if;
1899: --
1900: End if;