DBA Data[Home] [Help]

APPS.PAY_SET_BUS dependencies on FND_MESSAGE

Line 95: fnd_message.set_name('PAY', 'PAY_50137_SET_CORE_ROW_EXISTS');

91: fetch csr_disallow_update into l_disallow;
92: if csr_disallow_update%found then
93: hr_utility.set_location(l_proc, 25);
94: close csr_disallow_update;
95: fnd_message.set_name('PAY', 'PAY_50137_SET_CORE_ROW_EXISTS');
96: fnd_message.raise_error;
97: end if;
98: close csr_disallow_update;
99: --

Line 96: fnd_message.raise_error;

92: if csr_disallow_update%found then
93: hr_utility.set_location(l_proc, 25);
94: close csr_disallow_update;
95: fnd_message.set_name('PAY', 'PAY_50137_SET_CORE_ROW_EXISTS');
96: fnd_message.raise_error;
97: end if;
98: close csr_disallow_update;
99: --
100: -- Check the otherwise non-updateable arguments.

Line 156: fnd_message.set_name('PAY', 'PAY_50114_ETM_INVALID_TEMPLATE');

152: fetch csr_template_id_valid into l_valid;
153: if csr_template_id_valid%notfound then
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: close csr_template_id_valid;
156: fnd_message.set_name('PAY', 'PAY_50114_ETM_INVALID_TEMPLATE');
157: fnd_message.raise_error;
158: end if;
159: close csr_template_id_valid;
160: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 157: fnd_message.raise_error;

153: if csr_template_id_valid%notfound then
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: close csr_template_id_valid;
156: fnd_message.set_name('PAY', 'PAY_50114_ETM_INVALID_TEMPLATE');
157: fnd_message.raise_error;
158: end if;
159: close csr_template_id_valid;
160: hr_utility.set_location(' Leaving:'||l_proc, 15);
161: End chk_template_id;

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

263: ,p_lookup_type => p_lookup_type
264: ,p_lookup_code => p_lookup_code
265: )
266: then
267: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
268: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
269: fnd_message.set_token('COLUMN', upper(p_argument_name));
270: fnd_message.raise_error;
271: end if;

Line 268: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);

264: ,p_lookup_code => p_lookup_code
265: )
266: then
267: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
268: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
269: fnd_message.set_token('COLUMN', upper(p_argument_name));
270: fnd_message.raise_error;
271: end if;
272: end if;

Line 269: fnd_message.set_token('COLUMN', upper(p_argument_name));

265: )
266: then
267: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
268: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
269: fnd_message.set_token('COLUMN', upper(p_argument_name));
270: fnd_message.raise_error;
271: end if;
272: end if;
273: end chk_lookup;

Line 270: fnd_message.raise_error;

266: then
267: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
268: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
269: fnd_message.set_token('COLUMN', upper(p_argument_name));
270: fnd_message.raise_error;
271: end if;
272: end if;
273: end chk_lookup;
274: --

Line 643: fnd_message.set_name('PAY', 'PAY_50139_SET_ELEMENT_EXISTS');

639: fetch csr_T_element_name_exists into l_exists;
640: if csr_T_element_name_exists%found then
641: close csr_T_element_name_exists;
642: hr_utility.set_location(' Leaving:'||l_proc, 10);
643: fnd_message.set_name('PAY', 'PAY_50139_SET_ELEMENT_EXISTS');
644: fnd_message.set_token('ELEMENT_NAME', p_element_name);
645: fnd_message.raise_error;
646: end if;
647: close csr_T_element_name_exists;

Line 644: fnd_message.set_token('ELEMENT_NAME', p_element_name);

640: if csr_T_element_name_exists%found then
641: close csr_T_element_name_exists;
642: hr_utility.set_location(' Leaving:'||l_proc, 10);
643: fnd_message.set_name('PAY', 'PAY_50139_SET_ELEMENT_EXISTS');
644: fnd_message.set_token('ELEMENT_NAME', p_element_name);
645: fnd_message.raise_error;
646: end if;
647: close csr_T_element_name_exists;
648: elsif p_template_type = 'U' then

Line 645: fnd_message.raise_error;

641: close csr_T_element_name_exists;
642: hr_utility.set_location(' Leaving:'||l_proc, 10);
643: fnd_message.set_name('PAY', 'PAY_50139_SET_ELEMENT_EXISTS');
644: fnd_message.set_token('ELEMENT_NAME', p_element_name);
645: fnd_message.raise_error;
646: end if;
647: close csr_T_element_name_exists;
648: elsif p_template_type = 'U' then
649: --

Line 657: fnd_message.set_name('PAY', 'PAY_50139_SET_ELEMENT_EXISTS');

653: fetch csr_U_element_name_exists into l_exists;
654: if csr_U_element_name_exists%found then
655: close csr_U_element_name_exists;
656: hr_utility.set_location(' Leaving:'||l_proc, 15);
657: fnd_message.set_name('PAY', 'PAY_50139_SET_ELEMENT_EXISTS');
658: fnd_message.set_token('ELEMENT_NAME', p_element_name);
659: fnd_message.raise_error;
660: end if;
661: close csr_U_element_name_exists;

Line 658: fnd_message.set_token('ELEMENT_NAME', p_element_name);

654: if csr_U_element_name_exists%found then
655: close csr_U_element_name_exists;
656: hr_utility.set_location(' Leaving:'||l_proc, 15);
657: fnd_message.set_name('PAY', 'PAY_50139_SET_ELEMENT_EXISTS');
658: fnd_message.set_token('ELEMENT_NAME', p_element_name);
659: fnd_message.raise_error;
660: end if;
661: close csr_U_element_name_exists;
662: end if;

Line 659: fnd_message.raise_error;

655: close csr_U_element_name_exists;
656: hr_utility.set_location(' Leaving:'||l_proc, 15);
657: fnd_message.set_name('PAY', 'PAY_50139_SET_ELEMENT_EXISTS');
658: fnd_message.set_token('ELEMENT_NAME', p_element_name);
659: fnd_message.raise_error;
660: end if;
661: close csr_U_element_name_exists;
662: end if;
663: end if;

Line 709: fnd_message.set_name('PAY', 'PAY_50140_SET_PRI_SUM_RANGE');

705: if (p_relative_processing_priority < l_lower - p_base_processing_priority) or
706: (p_relative_processing_priority > l_upper - p_base_processing_priority)
707: then
708: hr_utility.set_location(' Leaving:'||l_proc, 15);
709: fnd_message.set_name('PAY', 'PAY_50140_SET_PRI_SUM_RANGE');
710: fnd_message.set_token('PRIORITY', p_relative_processing_priority);
711: fnd_message.set_token('LOWER', l_lower);
712: fnd_message.set_token('UPPER', l_upper);
713: fnd_message.raise_error;

Line 710: fnd_message.set_token('PRIORITY', p_relative_processing_priority);

706: (p_relative_processing_priority > l_upper - p_base_processing_priority)
707: then
708: hr_utility.set_location(' Leaving:'||l_proc, 15);
709: fnd_message.set_name('PAY', 'PAY_50140_SET_PRI_SUM_RANGE');
710: fnd_message.set_token('PRIORITY', p_relative_processing_priority);
711: fnd_message.set_token('LOWER', l_lower);
712: fnd_message.set_token('UPPER', l_upper);
713: fnd_message.raise_error;
714: end if;

Line 711: fnd_message.set_token('LOWER', l_lower);

707: then
708: hr_utility.set_location(' Leaving:'||l_proc, 15);
709: fnd_message.set_name('PAY', 'PAY_50140_SET_PRI_SUM_RANGE');
710: fnd_message.set_token('PRIORITY', p_relative_processing_priority);
711: fnd_message.set_token('LOWER', l_lower);
712: fnd_message.set_token('UPPER', l_upper);
713: fnd_message.raise_error;
714: end if;
715: end if;

Line 712: fnd_message.set_token('UPPER', l_upper);

708: hr_utility.set_location(' Leaving:'||l_proc, 15);
709: fnd_message.set_name('PAY', 'PAY_50140_SET_PRI_SUM_RANGE');
710: fnd_message.set_token('PRIORITY', p_relative_processing_priority);
711: fnd_message.set_token('LOWER', l_lower);
712: fnd_message.set_token('UPPER', l_upper);
713: fnd_message.raise_error;
714: end if;
715: end if;
716: hr_utility.set_location(' Leaving:'||l_proc, 25);

Line 713: fnd_message.raise_error;

709: fnd_message.set_name('PAY', 'PAY_50140_SET_PRI_SUM_RANGE');
710: fnd_message.set_token('PRIORITY', p_relative_processing_priority);
711: fnd_message.set_token('LOWER', l_lower);
712: fnd_message.set_token('UPPER', l_upper);
713: fnd_message.raise_error;
714: end if;
715: end if;
716: hr_utility.set_location(' Leaving:'||l_proc, 25);
717: End chk_processing_priority;

Line 756: fnd_message.set_name('PAY', 'HR_51855_QUA_CCY_INV');

752: fetch csr_valid_currency_code into l_valid;
753: if csr_valid_currency_code%notfound then
754: hr_utility.set_location(' Leaving:'||l_proc, 10);
755: close csr_valid_currency_code;
756: fnd_message.set_name('PAY', 'HR_51855_QUA_CCY_INV');
757: fnd_message.raise_error;
758: end if;
759: close csr_valid_currency_code;
760: end if;

Line 757: fnd_message.raise_error;

753: if csr_valid_currency_code%notfound then
754: hr_utility.set_location(' Leaving:'||l_proc, 10);
755: close csr_valid_currency_code;
756: fnd_message.set_name('PAY', 'HR_51855_QUA_CCY_INV');
757: fnd_message.raise_error;
758: end if;
759: close csr_valid_currency_code;
760: end if;
761: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 802: fnd_message.set_name('PAY', 'HR_51855_QUA_CCY_INV');

798: fetch csr_valid_currency_code into l_valid;
799: if csr_valid_currency_code%notfound then
800: hr_utility.set_location(' Leaving:'||l_proc, 10);
801: close csr_valid_currency_code;
802: fnd_message.set_name('PAY', 'HR_51855_QUA_CCY_INV');
803: fnd_message.raise_error;
804: end if;
805: close csr_valid_currency_code;
806: end if;

Line 803: fnd_message.raise_error;

799: if csr_valid_currency_code%notfound then
800: hr_utility.set_location(' Leaving:'||l_proc, 10);
801: close csr_valid_currency_code;
802: fnd_message.set_name('PAY', 'HR_51855_QUA_CCY_INV');
803: fnd_message.raise_error;
804: end if;
805: close csr_valid_currency_code;
806: end if;
807: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 876: fnd_message.set_name('PAY', 'PAY_50141_SET_BAD_PAY_FORMULA');

872: fetch csr_T_formula_valid into l_valid;
873: if csr_T_formula_valid%notfound then
874: hr_utility.set_location(' Leaving:'||l_proc, 10);
875: close csr_T_formula_valid;
876: fnd_message.set_name('PAY', 'PAY_50141_SET_BAD_PAY_FORMULA');
877: fnd_message.raise_error;
878: end if;
879: close csr_T_formula_valid;
880: elsif p_template_type = 'U' then

Line 877: fnd_message.raise_error;

873: if csr_T_formula_valid%notfound then
874: hr_utility.set_location(' Leaving:'||l_proc, 10);
875: close csr_T_formula_valid;
876: fnd_message.set_name('PAY', 'PAY_50141_SET_BAD_PAY_FORMULA');
877: fnd_message.raise_error;
878: end if;
879: close csr_T_formula_valid;
880: elsif p_template_type = 'U' then
881: open csr_U_formula_valid;

Line 886: fnd_message.set_name('PAY', 'PAY_50141_SET_BAD_PAY_FORMULA');

882: fetch csr_U_formula_valid into l_valid;
883: if csr_U_formula_valid%notfound then
884: hr_utility.set_location(' Leaving:'||l_proc, 15);
885: close csr_U_formula_valid;
886: fnd_message.set_name('PAY', 'PAY_50141_SET_BAD_PAY_FORMULA');
887: fnd_message.raise_error;
888: end if;
889: close csr_U_formula_valid;
890: end if;

Line 887: fnd_message.raise_error;

883: if csr_U_formula_valid%notfound then
884: hr_utility.set_location(' Leaving:'||l_proc, 15);
885: close csr_U_formula_valid;
886: fnd_message.set_name('PAY', 'PAY_50141_SET_BAD_PAY_FORMULA');
887: fnd_message.raise_error;
888: end if;
889: close csr_U_formula_valid;
890: end if;
891: end if;

Line 933: fnd_message.set_name('PAY', 'PAY_50100_ETM_INVALID_EXC_RULE');

929: fetch csr_exclusion_rule_id_valid into l_valid;
930: if csr_exclusion_rule_id_valid%notfound then
931: hr_utility.set_location('Leaving:'||l_proc, 10);
932: close csr_exclusion_rule_id_valid;
933: fnd_message.set_name('PAY', 'PAY_50100_ETM_INVALID_EXC_RULE');
934: fnd_message.raise_error;
935: end if;
936: close csr_exclusion_rule_id_valid;
937: end if;

Line 934: fnd_message.raise_error;

930: if csr_exclusion_rule_id_valid%notfound then
931: hr_utility.set_location('Leaving:'||l_proc, 10);
932: close csr_exclusion_rule_id_valid;
933: fnd_message.set_name('PAY', 'PAY_50100_ETM_INVALID_EXC_RULE');
934: fnd_message.raise_error;
935: end if;
936: close csr_exclusion_rule_id_valid;
937: end if;
938: end if;

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

951: --
952: Begin
953: hr_utility.set_location('Entering:'||l_proc, 5);
954: if (p_grossup_flag = 'Y' and p_iterative_flag <> 'Y') then
955: fnd_message.set_name('PAY', 'PAY_34147_ELE_ITR_GROSSUP');
956: fnd_message.raise_error;
957: end if;
958: hr_utility.set_location(' Leaving:'||l_proc, 10);
959: End chk_iterative_flag;

Line 956: fnd_message.raise_error;

952: Begin
953: hr_utility.set_location('Entering:'||l_proc, 5);
954: if (p_grossup_flag = 'Y' and p_iterative_flag <> 'Y') then
955: fnd_message.set_name('PAY', 'PAY_34147_ELE_ITR_GROSSUP');
956: fnd_message.raise_error;
957: end if;
958: hr_utility.set_location(' Leaving:'||l_proc, 10);
959: End chk_iterative_flag;
960: --

Line 974: fnd_message.set_name('PAY', 'PAY_34144_ELE_ITR_NO_FORML_PRI');

970: --
971: Begin
972: hr_utility.set_location('Entering:'||l_proc, 5);
973: if (p_iterative_flag = 'N' and p_iterative_priority is not null) then
974: fnd_message.set_name('PAY', 'PAY_34144_ELE_ITR_NO_FORML_PRI');
975: fnd_message.raise_error;
976: end if;
977: hr_utility.set_location(' Leaving:'||l_proc, 10);
978: End chk_iterative_priority;

Line 975: fnd_message.raise_error;

971: Begin
972: hr_utility.set_location('Entering:'||l_proc, 5);
973: if (p_iterative_flag = 'N' and p_iterative_priority is not null) then
974: fnd_message.set_name('PAY', 'PAY_34144_ELE_ITR_NO_FORML_PRI');
975: fnd_message.raise_error;
976: end if;
977: hr_utility.set_location(' Leaving:'||l_proc, 10);
978: End chk_iterative_priority;
979: --

Line 994: fnd_message.set_name('PAY', 'PAY_34144_ELE_ITR_NO_FORML_PRI');

990: Begin
991: hr_utility.set_location('Entering:'||l_proc, 5);
992: if p_iterative_flag is not null then
993: if (p_iterative_flag = 'N' and p_iterative_formula_name is not null) then
994: fnd_message.set_name('PAY', 'PAY_34144_ELE_ITR_NO_FORML_PRI');
995: fnd_message.raise_error;
996: end if;
997: if (p_iterative_flag = 'Y' and p_iterative_formula_name is null) then
998: fnd_message.set_name('PAY', 'PAY_34146_ELE_ITR_FORML_REQD');

Line 995: fnd_message.raise_error;

991: hr_utility.set_location('Entering:'||l_proc, 5);
992: if p_iterative_flag is not null then
993: if (p_iterative_flag = 'N' and p_iterative_formula_name is not null) then
994: fnd_message.set_name('PAY', 'PAY_34144_ELE_ITR_NO_FORML_PRI');
995: fnd_message.raise_error;
996: end if;
997: if (p_iterative_flag = 'Y' and p_iterative_formula_name is null) then
998: fnd_message.set_name('PAY', 'PAY_34146_ELE_ITR_FORML_REQD');
999: fnd_message.raise_error;

Line 998: fnd_message.set_name('PAY', 'PAY_34146_ELE_ITR_FORML_REQD');

994: fnd_message.set_name('PAY', 'PAY_34144_ELE_ITR_NO_FORML_PRI');
995: fnd_message.raise_error;
996: end if;
997: if (p_iterative_flag = 'Y' and p_iterative_formula_name is null) then
998: fnd_message.set_name('PAY', 'PAY_34146_ELE_ITR_FORML_REQD');
999: fnd_message.raise_error;
1000: end if;
1001: end if;
1002: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 999: fnd_message.raise_error;

995: fnd_message.raise_error;
996: end if;
997: if (p_iterative_flag = 'Y' and p_iterative_formula_name is null) then
998: fnd_message.set_name('PAY', 'PAY_34146_ELE_ITR_FORML_REQD');
999: fnd_message.raise_error;
1000: end if;
1001: end if;
1002: hr_utility.set_location(' Leaving:'||l_proc, 10);
1003: End chk_iterative_formula_name;

Line 1018: fnd_message.set_name('PAY', 'PAY_50093_ELE_GROSSUP_PROC_MOD');

1014: --
1015: Begin
1016: hr_utility.set_location('Entering:'||l_proc, 5);
1017: if (p_grossup_flag = 'Y' and p_process_mode = 'N') then
1018: fnd_message.set_name('PAY', 'PAY_50093_ELE_GROSSUP_PROC_MOD');
1019: fnd_message.raise_error;
1020: end if;
1021: --
1022: if (p_process_mode not in ('N','S','P')) then

Line 1019: fnd_message.raise_error;

1015: Begin
1016: hr_utility.set_location('Entering:'||l_proc, 5);
1017: if (p_grossup_flag = 'Y' and p_process_mode = 'N') then
1018: fnd_message.set_name('PAY', 'PAY_50093_ELE_GROSSUP_PROC_MOD');
1019: fnd_message.raise_error;
1020: end if;
1021: --
1022: if (p_process_mode not in ('N','S','P')) then
1023: fnd_message.set_name('PAY', 'PAY_34148_ELE_PROC_MODE');

Line 1023: fnd_message.set_name('PAY', 'PAY_34148_ELE_PROC_MODE');

1019: fnd_message.raise_error;
1020: end if;
1021: --
1022: if (p_process_mode not in ('N','S','P')) then
1023: fnd_message.set_name('PAY', 'PAY_34148_ELE_PROC_MODE');
1024: fnd_message.raise_error;
1025: end if;
1026: hr_utility.set_location(' Leaving:'||l_proc, 10);
1027: End chk_process_mode;

Line 1024: fnd_message.raise_error;

1020: end if;
1021: --
1022: if (p_process_mode not in ('N','S','P')) then
1023: fnd_message.set_name('PAY', 'PAY_34148_ELE_PROC_MODE');
1024: fnd_message.raise_error;
1025: end if;
1026: hr_utility.set_location(' Leaving:'||l_proc, 10);
1027: End chk_process_mode;
1028: --

Line 1161: fnd_message.set_name('PAY', 'PAY_50138_SET_INVALID_DELETE');

1157: end if;
1158: close csr_template_ff_usages;
1159: exception
1160: when l_error then
1161: fnd_message.set_name('PAY', 'PAY_50138_SET_INVALID_DELETE');
1162: fnd_message.raise_error;
1163: when others then
1164: hr_utility.set_location(' Leaving:'||l_proc, 200);
1165: raise;

Line 1162: fnd_message.raise_error;

1158: close csr_template_ff_usages;
1159: exception
1160: when l_error then
1161: fnd_message.set_name('PAY', 'PAY_50138_SET_INVALID_DELETE');
1162: fnd_message.raise_error;
1163: when others then
1164: hr_utility.set_location(' Leaving:'||l_proc, 200);
1165: raise;
1166: hr_utility.set_location(' Leaving:'||l_proc, 205);