DBA Data[Home] [Help]

APPS.PAY_RCU_BUS dependencies on FND_MESSAGE

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

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: );

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

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: --

Line 145: fnd_message.raise_error;

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

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

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;

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

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: --

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

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);

Line 208: fnd_message.raise_error;

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: --

Line 378: fnd_message.set_name('PAY','PAY_33167_RCU_INV_RETRO_COMP');

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;

Line 379: fnd_message.raise_error;

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:

Line 509: fnd_message.set_name('PAY','PAY_33168_RCU_INV_CRE_ID');

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:

Line 510: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');

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;

Line 511: fnd_message.set_token('COLUMN','ELEMENT_TYPE_ID');

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;

Line 512: fnd_message.raise_error;

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:

Line 528: fnd_message.set_name('PAY','PAY_33168_RCU_INV_CRE_ID');

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:

Line 529: fnd_message.set_token('TABLE','PAY_ELEMENT_CLASSIFICATIONS');

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;

Line 530: fnd_message.set_token('COLUMN','CLASSIFICATION_ID');

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;

Line 531: fnd_message.raise_error;

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:

Line 538: fnd_message.set_name('PAY','PAY_33161_RCU_INV_CRE_TYP');

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:

Line 539: fnd_message.raise_error;

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);

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

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:

Line 652: fnd_message.set_token('COLUMN','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:
656: end if;

Line 653: fnd_message.set_token('LOOKUP_TYPE','RETRO_REPROCESS_TYPE');

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:

Line 654: fnd_message.raise_error;

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: --

Line 668: fnd_message.set_name('PAY','PAY_33169_RCU_INV_RPRC_TYPE');

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:

Line 669: fnd_message.raise_error;

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;

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

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:

Line 804: fnd_message.set_token('COLUMN','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:
808: end if;

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

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);

Line 806: fnd_message.raise_error;

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:

Line 823: fnd_message.set_name('PAY','PAY_33162_RCU_TOO_MANY_DEF');

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;

Line 824: fnd_message.raise_error;

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:

Line 934: fnd_message.set_name('PAY','PAY_33194_RCU_INVALID_COMB');

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:

Line 935: fnd_message.set_token('FLAG','REPLACE_RUN_FLAG');

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;

Line 936: fnd_message.raise_error;

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:

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

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:

Line 948: fnd_message.set_token('COLUMN','REPLACE_RUN_FLAG');

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;

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

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;

Line 950: fnd_message.raise_error;

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);

Line 1059: fnd_message.set_name('PAY','PAY_33194_RCU_INVALID_COMB');

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:

Line 1060: fnd_message.set_token('FLAG','USE_OVERRIDE_DATES');

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;

Line 1061: fnd_message.raise_error;

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:

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

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:

Line 1073: fnd_message.set_token('COLUMN','USE_OVERRIDE_DATES');

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;

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

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;

Line 1075: fnd_message.raise_error;

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);