59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'RETRO_COMPONENT_USAGE_ID')
67: );
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
201: IF NOT pay_rcu_shd.api_updating
202: (p_retro_component_usage_id => p_rec.retro_component_usage_id
203: ,p_object_version_number => p_rec.object_version_number
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
202: (p_retro_component_usage_id => p_rec.retro_component_usage_id
203: ,p_object_version_number => p_rec.object_version_number
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
210: --
203: ,p_object_version_number => p_rec.object_version_number
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
210: --
211: hr_utility.set_location(l_proc, 10);
204: ) THEN
205: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
206: fnd_message.set_token('PROCEDURE ', l_proc);
207: fnd_message.set_token('STEP ', '5');
208: fnd_message.raise_error;
209: END IF;
210: --
211: hr_utility.set_location(l_proc, 10);
212: --
374: fetch csr_retro_component into l_exists;
375: if csr_retro_component%notfound then
376: close csr_retro_component;
377:
378: fnd_message.set_name('PAY','PAY_33167_RCU_INV_RETRO_COMP');
379: fnd_message.raise_error;
380:
381: end if;
382: close csr_retro_component;
375: if csr_retro_component%notfound then
376: close csr_retro_component;
377:
378: fnd_message.set_name('PAY','PAY_33167_RCU_INV_RETRO_COMP');
379: fnd_message.raise_error;
380:
381: end if;
382: close csr_retro_component;
383:
505: fetch csr_element_type into l_exists;
506: if csr_element_type%notfound then
507: close csr_element_type;
508:
509: fnd_message.set_name('PAY','PAY_33168_RCU_INV_CRE_ID');
510: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');
511: fnd_message.set_token('COLUMN','ELEMENT_TYPE_ID');
512: fnd_message.raise_error;
513:
506: if csr_element_type%notfound then
507: close csr_element_type;
508:
509: fnd_message.set_name('PAY','PAY_33168_RCU_INV_CRE_ID');
510: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');
511: fnd_message.set_token('COLUMN','ELEMENT_TYPE_ID');
512: fnd_message.raise_error;
513:
514: end if;
507: close csr_element_type;
508:
509: fnd_message.set_name('PAY','PAY_33168_RCU_INV_CRE_ID');
510: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');
511: fnd_message.set_token('COLUMN','ELEMENT_TYPE_ID');
512: fnd_message.raise_error;
513:
514: end if;
515: close csr_element_type;
508:
509: fnd_message.set_name('PAY','PAY_33168_RCU_INV_CRE_ID');
510: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');
511: fnd_message.set_token('COLUMN','ELEMENT_TYPE_ID');
512: fnd_message.raise_error;
513:
514: end if;
515: close csr_element_type;
516:
524: fetch csr_classification into l_exists;
525: if csr_classification%notfound then
526: close csr_classification;
527:
528: fnd_message.set_name('PAY','PAY_33168_RCU_INV_CRE_ID');
529: fnd_message.set_token('TABLE','PAY_ELEMENT_CLASSIFICATIONS');
530: fnd_message.set_token('COLUMN','CLASSIFICATION_ID');
531: fnd_message.raise_error;
532:
525: if csr_classification%notfound then
526: close csr_classification;
527:
528: fnd_message.set_name('PAY','PAY_33168_RCU_INV_CRE_ID');
529: fnd_message.set_token('TABLE','PAY_ELEMENT_CLASSIFICATIONS');
530: fnd_message.set_token('COLUMN','CLASSIFICATION_ID');
531: fnd_message.raise_error;
532:
533: end if;
526: close csr_classification;
527:
528: fnd_message.set_name('PAY','PAY_33168_RCU_INV_CRE_ID');
529: fnd_message.set_token('TABLE','PAY_ELEMENT_CLASSIFICATIONS');
530: fnd_message.set_token('COLUMN','CLASSIFICATION_ID');
531: fnd_message.raise_error;
532:
533: end if;
534: close csr_classification;
527:
528: fnd_message.set_name('PAY','PAY_33168_RCU_INV_CRE_ID');
529: fnd_message.set_token('TABLE','PAY_ELEMENT_CLASSIFICATIONS');
530: fnd_message.set_token('COLUMN','CLASSIFICATION_ID');
531: fnd_message.raise_error;
532:
533: end if;
534: close csr_classification;
535:
534: close csr_classification;
535:
536: else
537:
538: fnd_message.set_name('PAY','PAY_33161_RCU_INV_CRE_TYP');
539: fnd_message.raise_error;
540:
541: end if;
542:
535:
536: else
537:
538: fnd_message.set_name('PAY','PAY_33161_RCU_INV_CRE_TYP');
539: fnd_message.raise_error;
540:
541: end if;
542:
543: hr_utility.set_location(' Leaving:'|| l_proc, 50);
647: ,p_lookup_code => p_reprocess_type
648: ) then
649:
650:
651: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
652: fnd_message.set_token('COLUMN','REPROCESS_TYPE');
653: fnd_message.set_token('LOOKUP_TYPE','RETRO_REPROCESS_TYPE');
654: fnd_message.raise_error;
655:
648: ) then
649:
650:
651: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
652: fnd_message.set_token('COLUMN','REPROCESS_TYPE');
653: fnd_message.set_token('LOOKUP_TYPE','RETRO_REPROCESS_TYPE');
654: fnd_message.raise_error;
655:
656: end if;
649:
650:
651: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
652: fnd_message.set_token('COLUMN','REPROCESS_TYPE');
653: fnd_message.set_token('LOOKUP_TYPE','RETRO_REPROCESS_TYPE');
654: fnd_message.raise_error;
655:
656: end if;
657:
650:
651: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
652: fnd_message.set_token('COLUMN','REPROCESS_TYPE');
653: fnd_message.set_token('LOOKUP_TYPE','RETRO_REPROCESS_TYPE');
654: fnd_message.raise_error;
655:
656: end if;
657:
658: --
664: close csr_retro_type;
665: if l_retro_type = 'F'
666: and p_reprocess_type <> 'R' then
667:
668: fnd_message.set_name('PAY','PAY_33169_RCU_INV_RPRC_TYPE');
669: fnd_message.raise_error;
670:
671: end if;
672:
665: if l_retro_type = 'F'
666: and p_reprocess_type <> 'R' then
667:
668: fnd_message.set_name('PAY','PAY_33169_RCU_INV_RPRC_TYPE');
669: fnd_message.raise_error;
670:
671: end if;
672:
673: end if;
799: ,p_lookup_code => p_default_component
800: ) then
801:
802:
803: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
804: fnd_message.set_token('COLUMN','DEFAULT_COMPONENT');
805: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
806: fnd_message.raise_error;
807:
800: ) then
801:
802:
803: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
804: fnd_message.set_token('COLUMN','DEFAULT_COMPONENT');
805: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
806: fnd_message.raise_error;
807:
808: end if;
801:
802:
803: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
804: fnd_message.set_token('COLUMN','DEFAULT_COMPONENT');
805: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
806: fnd_message.raise_error;
807:
808: end if;
809: hr_utility.set_location(l_proc, 35);
802:
803: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
804: fnd_message.set_token('COLUMN','DEFAULT_COMPONENT');
805: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
806: fnd_message.raise_error;
807:
808: end if;
809: hr_utility.set_location(l_proc, 35);
810:
819: fetch csr_default_component_usage into l_exists;
820: if csr_default_component_usage%found then
821: close csr_default_component_usage;
822:
823: fnd_message.set_name('PAY','PAY_33162_RCU_TOO_MANY_DEF');
824: fnd_message.raise_error;
825:
826: end if;
827: close csr_default_component_usage;
820: if csr_default_component_usage%found then
821: close csr_default_component_usage;
822:
823: fnd_message.set_name('PAY','PAY_33162_RCU_TOO_MANY_DEF');
824: fnd_message.raise_error;
825:
826: end if;
827: close csr_default_component_usage;
828:
930: fetch csr_recalculation_style into l_recalculation_style;
931: close csr_recalculation_style;
932:
933: if l_recalculation_style is null or l_recalculation_style <> 'R' then
934: fnd_message.set_name('PAY','PAY_33194_RCU_INVALID_COMB');
935: fnd_message.set_token('FLAG','REPLACE_RUN_FLAG');
936: fnd_message.raise_error;
937: end if;
938:
931: close csr_recalculation_style;
932:
933: if l_recalculation_style is null or l_recalculation_style <> 'R' then
934: fnd_message.set_name('PAY','PAY_33194_RCU_INVALID_COMB');
935: fnd_message.set_token('FLAG','REPLACE_RUN_FLAG');
936: fnd_message.raise_error;
937: end if;
938:
939: end if;
932:
933: if l_recalculation_style is null or l_recalculation_style <> 'R' then
934: fnd_message.set_name('PAY','PAY_33194_RCU_INVALID_COMB');
935: fnd_message.set_token('FLAG','REPLACE_RUN_FLAG');
936: fnd_message.raise_error;
937: end if;
938:
939: end if;
940:
943: ,p_lookup_type => 'YES_NO'
944: ,p_lookup_code => p_replace_run_flag
945: ) then
946:
947: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
948: fnd_message.set_token('COLUMN','REPLACE_RUN_FLAG');
949: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
950: fnd_message.raise_error;
951:
944: ,p_lookup_code => p_replace_run_flag
945: ) then
946:
947: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
948: fnd_message.set_token('COLUMN','REPLACE_RUN_FLAG');
949: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
950: fnd_message.raise_error;
951:
952: end if;
945: ) then
946:
947: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
948: fnd_message.set_token('COLUMN','REPLACE_RUN_FLAG');
949: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
950: fnd_message.raise_error;
951:
952: end if;
953: end if;
946:
947: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
948: fnd_message.set_token('COLUMN','REPLACE_RUN_FLAG');
949: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
950: fnd_message.raise_error;
951:
952: end if;
953: end if;
954: hr_utility.set_location(l_proc, 35);
1055: fetch csr_recalculation_style into l_recalculation_style;
1056: close csr_recalculation_style;
1057:
1058: if l_recalculation_style is null or l_recalculation_style <> 'R' then
1059: fnd_message.set_name('PAY','PAY_33194_RCU_INVALID_COMB');
1060: fnd_message.set_token('FLAG','USE_OVERRIDE_DATES');
1061: fnd_message.raise_error;
1062: end if;
1063:
1056: close csr_recalculation_style;
1057:
1058: if l_recalculation_style is null or l_recalculation_style <> 'R' then
1059: fnd_message.set_name('PAY','PAY_33194_RCU_INVALID_COMB');
1060: fnd_message.set_token('FLAG','USE_OVERRIDE_DATES');
1061: fnd_message.raise_error;
1062: end if;
1063:
1064: end if;
1057:
1058: if l_recalculation_style is null or l_recalculation_style <> 'R' then
1059: fnd_message.set_name('PAY','PAY_33194_RCU_INVALID_COMB');
1060: fnd_message.set_token('FLAG','USE_OVERRIDE_DATES');
1061: fnd_message.raise_error;
1062: end if;
1063:
1064: end if;
1065:
1068: ,p_lookup_type => 'YES_NO'
1069: ,p_lookup_code => p_use_override_dates
1070: ) then
1071:
1072: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1073: fnd_message.set_token('COLUMN','USE_OVERRIDE_DATES');
1074: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1075: fnd_message.raise_error;
1076:
1069: ,p_lookup_code => p_use_override_dates
1070: ) then
1071:
1072: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1073: fnd_message.set_token('COLUMN','USE_OVERRIDE_DATES');
1074: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1075: fnd_message.raise_error;
1076:
1077: end if;
1070: ) then
1071:
1072: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1073: fnd_message.set_token('COLUMN','USE_OVERRIDE_DATES');
1074: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1075: fnd_message.raise_error;
1076:
1077: end if;
1078: end if;
1071:
1072: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1073: fnd_message.set_token('COLUMN','USE_OVERRIDE_DATES');
1074: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1075: fnd_message.raise_error;
1076:
1077: end if;
1078: end if;
1079: hr_utility.set_location(l_proc, 35);