55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
64: --
127: --
128: -- The primary key is invalid therefore we must error
129: --
130: close csr_leg_code;
131: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
132: fnd_message.raise_error;
133: end if;
134: hr_utility.set_location(l_proc,30);
135: --
128: -- The primary key is invalid therefore we must error
129: --
130: close csr_leg_code;
131: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
132: fnd_message.raise_error;
133: end if;
134: hr_utility.set_location(l_proc,30);
135: --
136: -- Set the global variables so the values are
187: --
188: -- The primary key is invalid therefore we must error
189: --
190: close csr_get_bg_id;
191: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
192: fnd_message.raise_error;
193: hr_utility.set_location(l_proc,20);
194: else -- a row is found
195: --
188: -- The primary key is invalid therefore we must error
189: --
190: close csr_get_bg_id;
191: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
192: fnd_message.raise_error;
193: hr_utility.set_location(l_proc,20);
194: else -- a row is found
195: --
196: -- if bg is null then return null, else get the leg code using the hr_api
278: THEN
279: --
280: -- The RUN_METHOD for this record is not recognised
281: --
282: fnd_message.set_name('PAY','HR_xxxx_INVALID_RUN_METHOD');
283: fnd_message.raise_error;
284: --
285: hr_utility.set_location(l_proc,10);
286: END IF;
279: --
280: -- The RUN_METHOD for this record is not recognised
281: --
282: fnd_message.set_name('PAY','HR_xxxx_INVALID_RUN_METHOD');
283: fnd_message.raise_error;
284: --
285: hr_utility.set_location(l_proc,10);
286: END IF;
287: --
480: (p_effective_date
481: ,'YES_NO'
482: ,p_srs_flag) Then
483: --
484: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
485: fnd_message.set_token('COLUMN','SRS_FLAG');
486: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
487: fnd_message.raise_error;
488: --
481: ,'YES_NO'
482: ,p_srs_flag) Then
483: --
484: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
485: fnd_message.set_token('COLUMN','SRS_FLAG');
486: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
487: fnd_message.raise_error;
488: --
489: End If;
482: ,p_srs_flag) Then
483: --
484: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
485: fnd_message.set_token('COLUMN','SRS_FLAG');
486: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
487: fnd_message.raise_error;
488: --
489: End If;
490: End If;
483: --
484: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
485: fnd_message.set_token('COLUMN','SRS_FLAG');
486: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
487: fnd_message.raise_error;
488: --
489: End If;
490: End If;
491: End chk_srs_flag;
750: open chk_for_ppa(p_run_type_id, p_business_group_id);
751: fetch chk_for_ppa into l_exists;
752: if chk_for_ppa%FOUND then
753: close chk_for_ppa;
754: fnd_message.set_name('PAY', 'HR_34981_PRT_CHILD_PPA');
755: fnd_message.raise_error;
756: hr_utility.set_location(l_proc, 10);
757: else
758: close chk_for_ppa;
751: fetch chk_for_ppa into l_exists;
752: if chk_for_ppa%FOUND then
753: close chk_for_ppa;
754: fnd_message.set_name('PAY', 'HR_34981_PRT_CHILD_PPA');
755: fnd_message.raise_error;
756: hr_utility.set_location(l_proc, 10);
757: else
758: close chk_for_ppa;
759: end if;
761: open chk_for_paa(p_run_type_id, p_business_group_id);
762: fetch chk_for_paa into l_exists;
763: if chk_for_paa%FOUND then
764: close chk_for_paa;
765: fnd_message.set_name('PAY', 'HR_34982_PRT_CHILD_PAA');
766: fnd_message.raise_error;
767: hr_utility.set_location(l_proc, 15);
768: else
769: close chk_for_paa;
762: fetch chk_for_paa into l_exists;
763: if chk_for_paa%FOUND then
764: close chk_for_paa;
765: fnd_message.set_name('PAY', 'HR_34982_PRT_CHILD_PAA');
766: fnd_message.raise_error;
767: hr_utility.set_location(l_proc, 15);
768: else
769: close chk_for_paa;
770: end if;
775: open chk_for_ppa(p_run_type_id, each_bg.business_group_id);
776: fetch chk_for_ppa into l_exists;
777: if chk_for_ppa%FOUND then
778: close chk_for_ppa;
779: fnd_message.set_name('PAY', 'HR_34981_PRT_CHILD_PPA');
780: fnd_message.raise_error;
781: hr_utility.set_location(l_proc, 20);
782: else
783: close chk_for_ppa;
776: fetch chk_for_ppa into l_exists;
777: if chk_for_ppa%FOUND then
778: close chk_for_ppa;
779: fnd_message.set_name('PAY', 'HR_34981_PRT_CHILD_PPA');
780: fnd_message.raise_error;
781: hr_utility.set_location(l_proc, 20);
782: else
783: close chk_for_ppa;
784: end if;
786: open chk_for_paa(p_run_type_id, each_bg.business_group_id);
787: fetch chk_for_paa into l_exists;
788: if chk_for_paa%FOUND then
789: close chk_for_paa;
790: fnd_message.set_name('PAY', 'HR_34982_PRT_CHILD_PAA');
791: fnd_message.raise_error;
792: hr_utility.set_location(l_proc, 25);
793: else
794: close chk_for_paa;
787: fetch chk_for_paa into l_exists;
788: if chk_for_paa%FOUND then
789: close chk_for_paa;
790: fnd_message.set_name('PAY', 'HR_34982_PRT_CHILD_PAA');
791: fnd_message.raise_error;
792: hr_utility.set_location(l_proc, 25);
793: else
794: close chk_for_paa;
795: end if;
799: open chk_for_ppanb(p_run_type_id);
800: fetch chk_for_ppanb into l_exists;
801: if chk_for_ppanb%FOUND then
802: close chk_for_ppanb;
803: fnd_message.set_name('PAY', 'HR_34981_PRT_CHILD_PPA');
804: fnd_message.raise_error;
805: hr_utility.set_location(l_proc, 30);
806: else
807: close chk_for_ppanb;
800: fetch chk_for_ppanb into l_exists;
801: if chk_for_ppanb%FOUND then
802: close chk_for_ppanb;
803: fnd_message.set_name('PAY', 'HR_34981_PRT_CHILD_PPA');
804: fnd_message.raise_error;
805: hr_utility.set_location(l_proc, 30);
806: else
807: close chk_for_ppanb;
808: end if;
810: open chk_for_paanb(p_run_type_id);
811: fetch chk_for_paanb into l_exists;
812: if chk_for_paanb%FOUND then
813: close chk_for_paanb;
814: fnd_message.set_name('PAY', 'HR_34982_PRT_CHILD_PAA');
815: fnd_message.raise_error;
816: hr_utility.set_location(l_proc, 35);
817: else
818: close chk_for_paanb;
811: fetch chk_for_paanb into l_exists;
812: if chk_for_paanb%FOUND then
813: close chk_for_paanb;
814: fnd_message.set_name('PAY', 'HR_34982_PRT_CHILD_PAA');
815: fnd_message.raise_error;
816: hr_utility.set_location(l_proc, 35);
817: else
818: close chk_for_paanb;
819: end if;
867: (p_run_type_id => p_rec.run_type_id
868: ,p_effective_date => p_effective_date
869: ,p_object_version_number => p_rec.object_version_number
870: ) THEN
871: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
872: fnd_message.set_token('PROCEDURE ', l_proc);
873: fnd_message.set_token('STEP ', '5');
874: fnd_message.raise_error;
875: END IF;
868: ,p_effective_date => p_effective_date
869: ,p_object_version_number => p_rec.object_version_number
870: ) THEN
871: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
872: fnd_message.set_token('PROCEDURE ', l_proc);
873: fnd_message.set_token('STEP ', '5');
874: fnd_message.raise_error;
875: END IF;
876: --
869: ,p_object_version_number => p_rec.object_version_number
870: ) THEN
871: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
872: fnd_message.set_token('PROCEDURE ', l_proc);
873: fnd_message.set_token('STEP ', '5');
874: fnd_message.raise_error;
875: END IF;
876: --
877: hr_utility.set_location(l_proc, 10);
870: ) THEN
871: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
872: fnd_message.set_token('PROCEDURE ', l_proc);
873: fnd_message.set_token('STEP ', '5');
874: fnd_message.raise_error;
875: END IF;
876: --
877: hr_utility.set_location(l_proc, 10);
878: --
995: --
996: -- A referential integrity check was violated therefore
997: -- we must error
998: --
999: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1000: fnd_message.set_token('TABLE_NAME', l_table_name);
1001: fnd_message.raise_error;
1002: When Others Then
1003: --
996: -- A referential integrity check was violated therefore
997: -- we must error
998: --
999: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1000: fnd_message.set_token('TABLE_NAME', l_table_name);
1001: fnd_message.raise_error;
1002: When Others Then
1003: --
1004: -- An unhandled or unexpected error has occurred which
997: -- we must error
998: --
999: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1000: fnd_message.set_token('TABLE_NAME', l_table_name);
1001: fnd_message.raise_error;
1002: When Others Then
1003: --
1004: -- An unhandled or unexpected error has occurred which
1005: -- we must report
1003: --
1004: -- An unhandled or unexpected error has occurred which
1005: -- we must report
1006: --
1007: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1008: fnd_message.set_token('PROCEDURE', l_proc);
1009: fnd_message.set_token('STEP','15');
1010: fnd_message.raise_error;
1011: End dt_update_validate;
1004: -- An unhandled or unexpected error has occurred which
1005: -- we must report
1006: --
1007: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1008: fnd_message.set_token('PROCEDURE', l_proc);
1009: fnd_message.set_token('STEP','15');
1010: fnd_message.raise_error;
1011: End dt_update_validate;
1012: --
1005: -- we must report
1006: --
1007: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1008: fnd_message.set_token('PROCEDURE', l_proc);
1009: fnd_message.set_token('STEP','15');
1010: fnd_message.raise_error;
1011: End dt_update_validate;
1012: --
1013: -- ----------------------------------------------------------------------------
1006: --
1007: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1008: fnd_message.set_token('PROCEDURE', l_proc);
1009: fnd_message.set_token('STEP','15');
1010: fnd_message.raise_error;
1011: End dt_update_validate;
1012: --
1013: -- ----------------------------------------------------------------------------
1014: -- |--------------------------< dt_delete_validate >--------------------------|
1141: --
1142: -- A referential integrity check was violated therefore
1143: -- we must error
1144: --
1145: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1146: fnd_message.set_token('TABLE_NAME', l_table_name);
1147: fnd_message.raise_error;
1148: When Others Then
1149: --
1142: -- A referential integrity check was violated therefore
1143: -- we must error
1144: --
1145: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1146: fnd_message.set_token('TABLE_NAME', l_table_name);
1147: fnd_message.raise_error;
1148: When Others Then
1149: --
1150: -- An unhandled or unexpected error has occurred which
1143: -- we must error
1144: --
1145: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1146: fnd_message.set_token('TABLE_NAME', l_table_name);
1147: fnd_message.raise_error;
1148: When Others Then
1149: --
1150: -- An unhandled or unexpected error has occurred which
1151: -- we must report
1149: --
1150: -- An unhandled or unexpected error has occurred which
1151: -- we must report
1152: --
1153: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1154: fnd_message.set_token('PROCEDURE', l_proc);
1155: fnd_message.set_token('STEP','15');
1156: fnd_message.raise_error;
1157: --
1150: -- An unhandled or unexpected error has occurred which
1151: -- we must report
1152: --
1153: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1154: fnd_message.set_token('PROCEDURE', l_proc);
1155: fnd_message.set_token('STEP','15');
1156: fnd_message.raise_error;
1157: --
1158: End dt_delete_validate;
1151: -- we must report
1152: --
1153: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1154: fnd_message.set_token('PROCEDURE', l_proc);
1155: fnd_message.set_token('STEP','15');
1156: fnd_message.raise_error;
1157: --
1158: End dt_delete_validate;
1159: --
1152: --
1153: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1154: fnd_message.set_token('PROCEDURE', l_proc);
1155: fnd_message.set_token('STEP','15');
1156: fnd_message.raise_error;
1157: --
1158: End dt_delete_validate;
1159: --
1160: -- ----------------------------------------------------------------------------