eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SID_BUS dependencies on FND_MESSAGE

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

57: close csr_sec_grp;
58: --
59: -- The primary key is invalid therefore we must error
60: --
61: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
62: fnd_message.raise_error;
63: --
64: end if;
65: close csr_sec_grp;

Line 62: fnd_message.raise_error;

58: --
59: -- The primary key is invalid therefore we must error
60: --
61: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
62: fnd_message.raise_error;
63: --
64: end if;
65: close csr_sec_grp;
66: --

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

132: --
133: -- The primary key is invalid therefore we must error
134: --
135: close csr_leg_code;
136: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
137: fnd_message.raise_error;
138: end if;
139: hr_utility.set_location(l_proc,30);
140: --

Line 137: fnd_message.raise_error;

133: -- The primary key is invalid therefore we must error
134: --
135: close csr_leg_code;
136: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
137: fnd_message.raise_error;
138: end if;
139: hr_utility.set_location(l_proc,30);
140: --
141: -- Set the global variables so the values are

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

194: (p_prsi_details_id => p_rec.prsi_details_id
195: ,p_effective_date => p_effective_date
196: ,p_object_version_number => p_rec.object_version_number
197: ) THEN
198: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
199: fnd_message.set_token('PROCEDURE ', l_proc);
200: fnd_message.set_token('STEP ', '5');
201: fnd_message.raise_error;
202: END IF;

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

195: ,p_effective_date => p_effective_date
196: ,p_object_version_number => p_rec.object_version_number
197: ) THEN
198: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
199: fnd_message.set_token('PROCEDURE ', l_proc);
200: fnd_message.set_token('STEP ', '5');
201: fnd_message.raise_error;
202: END IF;
203: --

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

196: ,p_object_version_number => p_rec.object_version_number
197: ) THEN
198: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
199: fnd_message.set_token('PROCEDURE ', l_proc);
200: fnd_message.set_token('STEP ', '5');
201: fnd_message.raise_error;
202: END IF;
203: --
204: --

Line 201: fnd_message.raise_error;

197: ) THEN
198: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
199: fnd_message.set_token('PROCEDURE ', l_proc);
200: fnd_message.set_token('STEP ', '5');
201: fnd_message.raise_error;
202: END IF;
203: --
204: --
205: IF nvl(p_rec.assignment_id, hr_api.g_number) <>

Line 262: fnd_message.set_name('PAY','HR_IE_ASG_NOT_EXISTS');

258: OPEN csr_assignment;
259: FETCH csr_assignment INTO l_payroll_id;
260: IF csr_assignment%NOTFOUND THEN
261: CLOSE csr_assignment;
262: fnd_message.set_name('PAY','HR_IE_ASG_NOT_EXISTS');
263: fnd_message.raise_error;
264: END IF;
265: --
266: IF l_payroll_id IS NULL THEN

Line 263: fnd_message.raise_error;

259: FETCH csr_assignment INTO l_payroll_id;
260: IF csr_assignment%NOTFOUND THEN
261: CLOSE csr_assignment;
262: fnd_message.set_name('PAY','HR_IE_ASG_NOT_EXISTS');
263: fnd_message.raise_error;
264: END IF;
265: --
266: IF l_payroll_id IS NULL THEN
267: CLOSE csr_assignment;

Line 268: fnd_message.set_name('PAY','HR_IE_ASG_NOT_IN_PAYROLL');

264: END IF;
265: --
266: IF l_payroll_id IS NULL THEN
267: CLOSE csr_assignment;
268: fnd_message.set_name('PAY','HR_IE_ASG_NOT_IN_PAYROLL');
269: fnd_message.raise_error;
270: END IF;
271: CLOSE csr_assignment;
272: END chk_assignment_id;

Line 269: fnd_message.raise_error;

265: --
266: IF l_payroll_id IS NULL THEN
267: CLOSE csr_assignment;
268: fnd_message.set_name('PAY','HR_IE_ASG_NOT_IN_PAYROLL');
269: fnd_message.raise_error;
270: END IF;
271: CLOSE csr_assignment;
272: END chk_assignment_id;
273: --

Line 320: fnd_message.set_name('PAY','HR_IE_DIRECTOR_FLAG_INVALID');

316: OPEN csr_director_flag;
317: FETCH csr_director_flag INTO l_exists;
318: IF csr_director_flag%NOTFOUND THEN
319: CLOSE csr_director_flag;
320: fnd_message.set_name('PAY','HR_IE_DIRECTOR_FLAG_INVALID');
321: fnd_message.raise_error;
322: END IF;
323: --
324: CLOSE csr_director_flag;

Line 321: fnd_message.raise_error;

317: FETCH csr_director_flag INTO l_exists;
318: IF csr_director_flag%NOTFOUND THEN
319: CLOSE csr_director_flag;
320: fnd_message.set_name('PAY','HR_IE_DIRECTOR_FLAG_INVALID');
321: fnd_message.raise_error;
322: END IF;
323: --
324: CLOSE csr_director_flag;
325: END chk_director_flag;

Line 374: fnd_message.set_name('PAY','HR_IE_CONT_CLASS_INVALID');

370: OPEN csr_contribution_class;
371: FETCH csr_contribution_class INTO l_exists;
372: IF csr_contribution_class%NOTFOUND THEN
373: CLOSE csr_contribution_class;
374: fnd_message.set_name('PAY','HR_IE_CONT_CLASS_INVALID');
375: fnd_message.raise_error;
376: END IF;
377: --
378: CLOSE csr_contribution_class;

Line 375: fnd_message.raise_error;

371: FETCH csr_contribution_class INTO l_exists;
372: IF csr_contribution_class%NOTFOUND THEN
373: CLOSE csr_contribution_class;
374: fnd_message.set_name('PAY','HR_IE_CONT_CLASS_INVALID');
375: fnd_message.raise_error;
376: END IF;
377: --
378: CLOSE csr_contribution_class;
379: END chk_contribution_class;

Line 428: fnd_message.set_name('PAY','HR_IE_CONT_SUBCLASS_INVALID');

424: OPEN csr_overridden_subclass;
425: FETCH csr_overridden_subclass INTO l_exists;
426: IF p_overridden_subclass IS NOT NULL AND csr_overridden_subclass%NOTFOUND THEN
427: CLOSE csr_overridden_subclass;
428: fnd_message.set_name('PAY','HR_IE_CONT_SUBCLASS_INVALID');
429: fnd_message.raise_error;
430: END IF;
431: --
432: CLOSE csr_overridden_subclass;

Line 429: fnd_message.raise_error;

425: FETCH csr_overridden_subclass INTO l_exists;
426: IF p_overridden_subclass IS NOT NULL AND csr_overridden_subclass%NOTFOUND THEN
427: CLOSE csr_overridden_subclass;
428: fnd_message.set_name('PAY','HR_IE_CONT_SUBCLASS_INVALID');
429: fnd_message.raise_error;
430: END IF;
431: --
432: CLOSE csr_overridden_subclass;
433: END chk_overridden_subclass;

Line 481: fnd_message.set_name('PAY','HR_IE_SOC_BEN_FLAG_INVALID');

477: OPEN csr_soc_ben_flag;
478: FETCH csr_soc_ben_flag INTO l_exists;
479: IF csr_soc_ben_flag%NOTFOUND THEN
480: CLOSE csr_soc_ben_flag;
481: fnd_message.set_name('PAY','HR_IE_SOC_BEN_FLAG_INVALID');
482: fnd_message.raise_error;
483: END IF;
484: --
485: CLOSE csr_soc_ben_flag;

Line 482: fnd_message.raise_error;

478: FETCH csr_soc_ben_flag INTO l_exists;
479: IF csr_soc_ben_flag%NOTFOUND THEN
480: CLOSE csr_soc_ben_flag;
481: fnd_message.set_name('PAY','HR_IE_SOC_BEN_FLAG_INVALID');
482: fnd_message.raise_error;
483: END IF;
484: --
485: CLOSE csr_soc_ben_flag;
486: END chk_soc_ben_flag;

Line 541: fnd_message.set_name('PAY', 'HR_IE_PRSI_DETAILS_EXIST');

537: --
538: hr_utility.set_location('prsi_details_rec'||prsi_details_rec.min_start_date,104);
539: IF prsi_details_rec.min_start_date is not null THEN
540: CLOSE csr_prsi_details;
541: fnd_message.set_name('PAY', 'HR_IE_PRSI_DETAILS_EXIST');
542: fnd_message.set_token('START_DATE', to_char(prsi_details_rec.min_start_date, 'DD-MON-YYYY'));
543: fnd_message.raise_error;
544: END IF;
545: --

Line 542: fnd_message.set_token('START_DATE', to_char(prsi_details_rec.min_start_date, 'DD-MON-YYYY'));

538: hr_utility.set_location('prsi_details_rec'||prsi_details_rec.min_start_date,104);
539: IF prsi_details_rec.min_start_date is not null THEN
540: CLOSE csr_prsi_details;
541: fnd_message.set_name('PAY', 'HR_IE_PRSI_DETAILS_EXIST');
542: fnd_message.set_token('START_DATE', to_char(prsi_details_rec.min_start_date, 'DD-MON-YYYY'));
543: fnd_message.raise_error;
544: END IF;
545: --
546: CLOSE csr_prsi_details;

Line 543: fnd_message.raise_error;

539: IF prsi_details_rec.min_start_date is not null THEN
540: CLOSE csr_prsi_details;
541: fnd_message.set_name('PAY', 'HR_IE_PRSI_DETAILS_EXIST');
542: fnd_message.set_token('START_DATE', to_char(prsi_details_rec.min_start_date, 'DD-MON-YYYY'));
543: fnd_message.raise_error;
544: END IF;
545: --
546: CLOSE csr_prsi_details;
547: END chk_overlapping_record;

Line 586: fnd_message.set_name('PAY','HR_IE_SOC_BEN_START_DATE');

582: ) IS
583: --
584: BEGIN
585: IF p_soc_ben_flag = 'N' and p_soc_ben_start_date IS NOT NULL THEN
586: fnd_message.set_name('PAY','HR_IE_SOC_BEN_START_DATE');
587: fnd_message.raise_error;
588: END IF;
589: --
590: END chk_soc_ben_start_date;

Line 587: fnd_message.raise_error;

583: --
584: BEGIN
585: IF p_soc_ben_flag = 'N' and p_soc_ben_start_date IS NOT NULL THEN
586: fnd_message.set_name('PAY','HR_IE_SOC_BEN_START_DATE');
587: fnd_message.raise_error;
588: END IF;
589: --
590: END chk_soc_ben_start_date;
591: --

Line 710: -- fnd_message.set_name('PAY','HR_IE_OVERRIDDEN_INS_WEEKS');

706: -- if overridden number of insurable weeks are more than standard
707: -- default number in current pay period then raie error
708: IF nvl(p_overridden_ins_weeks, 0) > nvl(l_std_ins_weeks, 0) THEN
709: null;
710: -- fnd_message.set_name('PAY','HR_IE_OVERRIDDEN_INS_WEEKS');
711: -- fnd_message.raise_error;
712: END IF;
713: --
714: END chk_overridden_ins_weeks;

Line 711: -- fnd_message.raise_error;

707: -- default number in current pay period then raie error
708: IF nvl(p_overridden_ins_weeks, 0) > nvl(l_std_ins_weeks, 0) THEN
709: null;
710: -- fnd_message.set_name('PAY','HR_IE_OVERRIDDEN_INS_WEEKS');
711: -- fnd_message.raise_error;
712: END IF;
713: --
714: END chk_overridden_ins_weeks;
715: --

Line 750: fnd_message.set_name('PAY', 'HR_IE_START_END_DATES');

746: , p_exemption_end_date IN DATE
747: ) IS
748: BEGIN
749: IF p_exemption_start_date > nvl(p_exemption_end_date, p_exemption_start_date+1) THEN
750: fnd_message.set_name('PAY', 'HR_IE_START_END_DATES');
751: fnd_message.set_token('START_DATE', to_char(p_exemption_start_date, 'DD-MON-YYYY'));
752: fnd_message.set_token('END_DATE', to_char(p_exemption_end_date, 'DD-MON-YYYY'));
753: fnd_message.raise_error;
754: END IF;

Line 751: fnd_message.set_token('START_DATE', to_char(p_exemption_start_date, 'DD-MON-YYYY'));

747: ) IS
748: BEGIN
749: IF p_exemption_start_date > nvl(p_exemption_end_date, p_exemption_start_date+1) THEN
750: fnd_message.set_name('PAY', 'HR_IE_START_END_DATES');
751: fnd_message.set_token('START_DATE', to_char(p_exemption_start_date, 'DD-MON-YYYY'));
752: fnd_message.set_token('END_DATE', to_char(p_exemption_end_date, 'DD-MON-YYYY'));
753: fnd_message.raise_error;
754: END IF;
755: END chk_exemption_start_end_Dates;

Line 752: fnd_message.set_token('END_DATE', to_char(p_exemption_end_date, 'DD-MON-YYYY'));

748: BEGIN
749: IF p_exemption_start_date > nvl(p_exemption_end_date, p_exemption_start_date+1) THEN
750: fnd_message.set_name('PAY', 'HR_IE_START_END_DATES');
751: fnd_message.set_token('START_DATE', to_char(p_exemption_start_date, 'DD-MON-YYYY'));
752: fnd_message.set_token('END_DATE', to_char(p_exemption_end_date, 'DD-MON-YYYY'));
753: fnd_message.raise_error;
754: END IF;
755: END chk_exemption_start_end_Dates;
756: --

Line 753: fnd_message.raise_error;

749: IF p_exemption_start_date > nvl(p_exemption_end_date, p_exemption_start_date+1) THEN
750: fnd_message.set_name('PAY', 'HR_IE_START_END_DATES');
751: fnd_message.set_token('START_DATE', to_char(p_exemption_start_date, 'DD-MON-YYYY'));
752: fnd_message.set_token('END_DATE', to_char(p_exemption_end_date, 'DD-MON-YYYY'));
753: fnd_message.raise_error;
754: END IF;
755: END chk_exemption_start_end_Dates;
756: --
757: --

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

799: OPEN csr_community_flag;
800: FETCH csr_community_flag INTO l_exists;
801: IF csr_community_flag%NOTFOUND THEN
802: CLOSE csr_community_flag;
803: fnd_message.set_name('PAY','HR_IE_COMMUNITY_FLAG_INVALID');
804: fnd_message.raise_error;
805: END IF;
806: --
807: CLOSE csr_community_flag;

Line 804: fnd_message.raise_error;

800: FETCH csr_community_flag INTO l_exists;
801: IF csr_community_flag%NOTFOUND THEN
802: CLOSE csr_community_flag;
803: fnd_message.set_name('PAY','HR_IE_COMMUNITY_FLAG_INVALID');
804: fnd_message.raise_error;
805: END IF;
806: --
807: CLOSE csr_community_flag;
808: END chk_community_flag;

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

890: --
891: -- A referential integrity check was violated therefore
892: -- we must error
893: --
894: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
895: fnd_message.set_token('TABLE_NAME', l_table_name);
896: fnd_message.raise_error;
897: When Others Then
898: --

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

891: -- A referential integrity check was violated therefore
892: -- we must error
893: --
894: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
895: fnd_message.set_token('TABLE_NAME', l_table_name);
896: fnd_message.raise_error;
897: When Others Then
898: --
899: -- An unhandled or unexpected error has occurred which

Line 896: fnd_message.raise_error;

892: -- we must error
893: --
894: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
895: fnd_message.set_token('TABLE_NAME', l_table_name);
896: fnd_message.raise_error;
897: When Others Then
898: --
899: -- An unhandled or unexpected error has occurred which
900: -- we must report

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

898: --
899: -- An unhandled or unexpected error has occurred which
900: -- we must report
901: --
902: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
903: fnd_message.set_token('PROCEDURE', l_proc);
904: fnd_message.set_token('STEP','15');
905: fnd_message.raise_error;
906: End dt_update_validate;

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

899: -- An unhandled or unexpected error has occurred which
900: -- we must report
901: --
902: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
903: fnd_message.set_token('PROCEDURE', l_proc);
904: fnd_message.set_token('STEP','15');
905: fnd_message.raise_error;
906: End dt_update_validate;
907: --

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

900: -- we must report
901: --
902: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
903: fnd_message.set_token('PROCEDURE', l_proc);
904: fnd_message.set_token('STEP','15');
905: fnd_message.raise_error;
906: End dt_update_validate;
907: --
908: -- ----------------------------------------------------------------------------

Line 905: fnd_message.raise_error;

901: --
902: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
903: fnd_message.set_token('PROCEDURE', l_proc);
904: fnd_message.set_token('STEP','15');
905: fnd_message.raise_error;
906: End dt_update_validate;
907: --
908: -- ----------------------------------------------------------------------------
909: -- |--------------------------< dt_delete_validate >--------------------------|

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

997: --
998: -- A referential integrity check was violated therefore
999: -- we must error
1000: --
1001: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1002: fnd_message.set_token('TABLE_NAME', l_table_name);
1003: fnd_message.raise_error;
1004: When Others Then
1005: --

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

998: -- A referential integrity check was violated therefore
999: -- we must error
1000: --
1001: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1002: fnd_message.set_token('TABLE_NAME', l_table_name);
1003: fnd_message.raise_error;
1004: When Others Then
1005: --
1006: -- An unhandled or unexpected error has occurred which

Line 1003: fnd_message.raise_error;

999: -- we must error
1000: --
1001: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1002: fnd_message.set_token('TABLE_NAME', l_table_name);
1003: fnd_message.raise_error;
1004: When Others Then
1005: --
1006: -- An unhandled or unexpected error has occurred which
1007: -- we must report

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

1005: --
1006: -- An unhandled or unexpected error has occurred which
1007: -- we must report
1008: --
1009: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1010: fnd_message.set_token('PROCEDURE', l_proc);
1011: fnd_message.set_token('STEP','15');
1012: fnd_message.raise_error;
1013: --

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

1006: -- An unhandled or unexpected error has occurred which
1007: -- we must report
1008: --
1009: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1010: fnd_message.set_token('PROCEDURE', l_proc);
1011: fnd_message.set_token('STEP','15');
1012: fnd_message.raise_error;
1013: --
1014: End dt_delete_validate;

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

1007: -- we must report
1008: --
1009: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1010: fnd_message.set_token('PROCEDURE', l_proc);
1011: fnd_message.set_token('STEP','15');
1012: fnd_message.raise_error;
1013: --
1014: End dt_delete_validate;
1015: --

Line 1012: fnd_message.raise_error;

1008: --
1009: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1010: fnd_message.set_token('PROCEDURE', l_proc);
1011: fnd_message.set_token('STEP','15');
1012: fnd_message.raise_error;
1013: --
1014: End dt_delete_validate;
1015: --
1016: -- ----------------------------------------------------------------------------