DBA Data[Home] [Help]

APPS.PAY_PRT_BUS dependencies on FND_MESSAGE

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

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;

Line 60: fnd_message.raise_error;

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

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

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

Line 132: fnd_message.raise_error;

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

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

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

Line 192: fnd_message.raise_error;

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

Line 282: fnd_message.set_name('PAY','HR_xxxx_INVALID_RUN_METHOD');

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;

Line 283: fnd_message.raise_error;

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

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

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

Line 485: fnd_message.set_token('COLUMN','SRS_FLAG');

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;

Line 486: fnd_message.set_token('LOOKUP_TYPE','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;
490: End If;

Line 487: fnd_message.raise_error;

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;

Line 754: fnd_message.set_name('PAY', 'HR_34981_PRT_CHILD_PPA');

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;

Line 755: fnd_message.raise_error;

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;

Line 765: fnd_message.set_name('PAY', 'HR_34982_PRT_CHILD_PAA');

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;

Line 766: fnd_message.raise_error;

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;

Line 779: fnd_message.set_name('PAY', 'HR_34981_PRT_CHILD_PPA');

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;

Line 780: fnd_message.raise_error;

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;

Line 790: fnd_message.set_name('PAY', 'HR_34982_PRT_CHILD_PAA');

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;

Line 791: fnd_message.raise_error;

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;

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

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;

Line 804: fnd_message.raise_error;

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;

Line 814: fnd_message.set_name('PAY', 'HR_34982_PRT_CHILD_PAA');

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;

Line 815: fnd_message.raise_error;

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;

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

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;

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

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

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

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

Line 874: fnd_message.raise_error;

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

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

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

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

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

Line 1001: fnd_message.raise_error;

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

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

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;

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

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

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

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

Line 1010: fnd_message.raise_error;

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

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

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

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

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

Line 1147: fnd_message.raise_error;

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

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

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

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

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;

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

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

Line 1156: fnd_message.raise_error;

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