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_IPD_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_paye_details_id => p_rec.paye_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: IF nvl(p_rec.assignment_id, hr_api.g_number) <>

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: IF nvl(p_rec.assignment_id, hr_api.g_number) <>
205: nvl(pay_ipd_shd.g_old_rec.assignment_id, hr_api.g_number) THEN

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

264: OPEN csr_assignment;
265: FETCH csr_assignment INTO l_payroll_id;
266: IF csr_assignment%NOTFOUND THEN
267: CLOSE csr_assignment;
268: fnd_message.set_name('PAY','HR_IE_ASG_NOT_EXISTS');
269: fnd_message.raise_error;
270: END IF;
271: --
272: IF l_payroll_id IS NULL THEN

Line 269: fnd_message.raise_error;

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

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

270: END IF;
271: --
272: IF l_payroll_id IS NULL THEN
273: CLOSE csr_assignment;
274: fnd_message.set_name('PAY','HR_IE_ASG_NOT_IN_PAYROLL');
275: fnd_message.raise_error;
276: END IF;
277: CLOSE csr_assignment;
278: END chk_assignment_id;

Line 275: fnd_message.raise_error;

271: --
272: IF l_payroll_id IS NULL THEN
273: CLOSE csr_assignment;
274: fnd_message.set_name('PAY','HR_IE_ASG_NOT_IN_PAYROLL');
275: fnd_message.raise_error;
276: END IF;
277: CLOSE csr_assignment;
278: END chk_assignment_id;
279: --

Line 326: fnd_message.set_name('PAY','HR_IE_INFO_SOURCE_INVALID');

322: OPEN csr_info_source;
323: FETCH csr_info_source INTO l_exists;
324: IF csr_info_source%NOTFOUND THEN
325: CLOSE csr_info_source;
326: fnd_message.set_name('PAY','HR_IE_INFO_SOURCE_INVALID');
327: fnd_message.set_token('INFO_SOURCE', p_info_source);
328: fnd_message.raise_error;
329: END IF;
330: --

Line 327: fnd_message.set_token('INFO_SOURCE', p_info_source);

323: FETCH csr_info_source INTO l_exists;
324: IF csr_info_source%NOTFOUND THEN
325: CLOSE csr_info_source;
326: fnd_message.set_name('PAY','HR_IE_INFO_SOURCE_INVALID');
327: fnd_message.set_token('INFO_SOURCE', p_info_source);
328: fnd_message.raise_error;
329: END IF;
330: --
331: CLOSE csr_info_source;

Line 328: fnd_message.raise_error;

324: IF csr_info_source%NOTFOUND THEN
325: CLOSE csr_info_source;
326: fnd_message.set_name('PAY','HR_IE_INFO_SOURCE_INVALID');
327: fnd_message.set_token('INFO_SOURCE', p_info_source);
328: fnd_message.raise_error;
329: END IF;
330: --
331: CLOSE csr_info_source;
332: END chk_info_source;

Line 446: fnd_message.set_name('PAY','HR_IE_COMM_PERIOD_NO_INVALID');

442: BEGIN
443: l_comm_period_no := get_comm_period_no( p_effective_date => p_effective_date,
444: p_assignment_id => p_assignment_id );
445: IF l_comm_period_no <> p_comm_period_no THEN
446: fnd_message.set_name('PAY','HR_IE_COMM_PERIOD_NO_INVALID');
447: fnd_message.raise_error;
448: END IF;
449: --
450: END chk_comm_period_no;

Line 447: fnd_message.raise_error;

443: l_comm_period_no := get_comm_period_no( p_effective_date => p_effective_date,
444: p_assignment_id => p_assignment_id );
445: IF l_comm_period_no <> p_comm_period_no THEN
446: fnd_message.set_name('PAY','HR_IE_COMM_PERIOD_NO_INVALID');
447: fnd_message.raise_error;
448: END IF;
449: --
450: END chk_comm_period_no;
451: --

Line 497: fnd_message.set_name('PAY','HR_IE_TAX_BASIS_INVALID');

493: OPEN csr_tax_basis;
494: FETCH csr_tax_basis INTO l_exists;
495: IF csr_tax_basis%NOTFOUND THEN
496: CLOSE csr_tax_basis;
497: fnd_message.set_name('PAY','HR_IE_TAX_BASIS_INVALID');
498: fnd_message.set_token('TAX_BASIS', p_tax_basis);
499: fnd_message.raise_error;
500: END IF;
501: --

Line 498: fnd_message.set_token('TAX_BASIS', p_tax_basis);

494: FETCH csr_tax_basis INTO l_exists;
495: IF csr_tax_basis%NOTFOUND THEN
496: CLOSE csr_tax_basis;
497: fnd_message.set_name('PAY','HR_IE_TAX_BASIS_INVALID');
498: fnd_message.set_token('TAX_BASIS', p_tax_basis);
499: fnd_message.raise_error;
500: END IF;
501: --
502: CLOSE csr_tax_basis;

Line 499: fnd_message.raise_error;

495: IF csr_tax_basis%NOTFOUND THEN
496: CLOSE csr_tax_basis;
497: fnd_message.set_name('PAY','HR_IE_TAX_BASIS_INVALID');
498: fnd_message.set_token('TAX_BASIS', p_tax_basis);
499: fnd_message.raise_error;
500: END IF;
501: --
502: CLOSE csr_tax_basis;
503: END chk_tax_basis;

Line 551: fnd_message.set_name('PAY','HR_IE_TAX_ASSESS_BASIS_INVALID');

547: OPEN csr_tax_assess_basis;
548: FETCH csr_tax_assess_basis INTO l_exists;
549: IF csr_tax_assess_basis%NOTFOUND THEN
550: CLOSE csr_tax_assess_basis;
551: fnd_message.set_name('PAY','HR_IE_TAX_ASSESS_BASIS_INVALID');
552: fnd_message.set_token('TAX_ASSESS_BASIS', p_tax_assess_basis);
553: fnd_message.raise_error;
554: END IF;
555: --

Line 552: fnd_message.set_token('TAX_ASSESS_BASIS', p_tax_assess_basis);

548: FETCH csr_tax_assess_basis INTO l_exists;
549: IF csr_tax_assess_basis%NOTFOUND THEN
550: CLOSE csr_tax_assess_basis;
551: fnd_message.set_name('PAY','HR_IE_TAX_ASSESS_BASIS_INVALID');
552: fnd_message.set_token('TAX_ASSESS_BASIS', p_tax_assess_basis);
553: fnd_message.raise_error;
554: END IF;
555: --
556: CLOSE csr_tax_assess_basis;

Line 553: fnd_message.raise_error;

549: IF csr_tax_assess_basis%NOTFOUND THEN
550: CLOSE csr_tax_assess_basis;
551: fnd_message.set_name('PAY','HR_IE_TAX_ASSESS_BASIS_INVALID');
552: fnd_message.set_token('TAX_ASSESS_BASIS', p_tax_assess_basis);
553: fnd_message.raise_error;
554: END IF;
555: --
556: CLOSE csr_tax_assess_basis;
557: END chk_tax_assess_basis;

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

590: , p_certificate_end_date IN DATE
591: ) IS
592: BEGIN
593: IF p_certificate_start_date > nvl(p_certificate_end_date, p_certificate_start_date+1) THEN
594: fnd_message.set_name('PAY', 'HR_IE_START_END_DATES');
595: fnd_message.set_token('START_DATE', to_char(p_certificate_start_date, 'DD-MON-YYYY'));
596: fnd_message.set_token('END_DATE', to_char(p_certificate_end_date, 'DD-MON-YYYY'));
597: fnd_message.raise_error;
598: END IF;

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

591: ) IS
592: BEGIN
593: IF p_certificate_start_date > nvl(p_certificate_end_date, p_certificate_start_date+1) THEN
594: fnd_message.set_name('PAY', 'HR_IE_START_END_DATES');
595: fnd_message.set_token('START_DATE', to_char(p_certificate_start_date, 'DD-MON-YYYY'));
596: fnd_message.set_token('END_DATE', to_char(p_certificate_end_date, 'DD-MON-YYYY'));
597: fnd_message.raise_error;
598: END IF;
599: END chk_cert_start_end_Dates;

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

592: BEGIN
593: IF p_certificate_start_date > nvl(p_certificate_end_date, p_certificate_start_date+1) THEN
594: fnd_message.set_name('PAY', 'HR_IE_START_END_DATES');
595: fnd_message.set_token('START_DATE', to_char(p_certificate_start_date, 'DD-MON-YYYY'));
596: fnd_message.set_token('END_DATE', to_char(p_certificate_end_date, 'DD-MON-YYYY'));
597: fnd_message.raise_error;
598: END IF;
599: END chk_cert_start_end_Dates;
600: --

Line 597: fnd_message.raise_error;

593: IF p_certificate_start_date > nvl(p_certificate_end_date, p_certificate_start_date+1) THEN
594: fnd_message.set_name('PAY', 'HR_IE_START_END_DATES');
595: fnd_message.set_token('START_DATE', to_char(p_certificate_start_date, 'DD-MON-YYYY'));
596: fnd_message.set_token('END_DATE', to_char(p_certificate_end_date, 'DD-MON-YYYY'));
597: fnd_message.raise_error;
598: END IF;
599: END chk_cert_start_end_Dates;
600: --
601: --

Line 652: fnd_message.set_name('PAY', 'HR_IE_PAYE_DETAILS_EXIST');

648: FETCH csr_paye_details INTO paye_details_rec;
649: --
650: IF paye_details_rec.min_start_date is not null THEN
651: CLOSE csr_paye_details;
652: fnd_message.set_name('PAY', 'HR_IE_PAYE_DETAILS_EXIST');
653: fnd_message.set_token('START_DATE', to_char(paye_details_rec.min_start_date, 'DD-MON-YYYY'));
654: fnd_message.raise_error;
655: END IF;
656: --

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

649: --
650: IF paye_details_rec.min_start_date is not null THEN
651: CLOSE csr_paye_details;
652: fnd_message.set_name('PAY', 'HR_IE_PAYE_DETAILS_EXIST');
653: fnd_message.set_token('START_DATE', to_char(paye_details_rec.min_start_date, 'DD-MON-YYYY'));
654: fnd_message.raise_error;
655: END IF;
656: --
657: CLOSE csr_paye_details;

Line 654: fnd_message.raise_error;

650: IF paye_details_rec.min_start_date is not null THEN
651: CLOSE csr_paye_details;
652: fnd_message.set_name('PAY', 'HR_IE_PAYE_DETAILS_EXIST');
653: fnd_message.set_token('START_DATE', to_char(paye_details_rec.min_start_date, 'DD-MON-YYYY'));
654: fnd_message.raise_error;
655: END IF;
656: --
657: CLOSE csr_paye_details;
658: END chk_duplicate_record;

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

717: FETCH csr_pay_freq INTO pay_freq_rec;
718: --
719: IF csr_pay_freq%NOTFOUND THEN
720: CLOSE csr_pay_freq;
721: fnd_message.set_name('PAY', 'HR_IE_ASG_NOT_IN_PAYROLL');
722: fnd_message.raise_error;
723: END IF;
724: --
725: CLOSE csr_pay_freq;

Line 722: fnd_message.raise_error;

718: --
719: IF csr_pay_freq%NOTFOUND THEN
720: CLOSE csr_pay_freq;
721: fnd_message.set_name('PAY', 'HR_IE_ASG_NOT_IN_PAYROLL');
722: fnd_message.raise_error;
723: END IF;
724: --
725: CLOSE csr_pay_freq;
726: --

Line 730: fnd_message.set_name('PAY', 'HR_IE_TAX_CREDIT_NOT_NULL');

726: --
727: IF p_tax_basis = 'IE_EMERGENCY'
728: AND (p_weekly_tax_credit IS NOT NULL OR p_weekly_std_rate_cut_off IS NOT NULL
729: OR p_monthly_tax_credit IS NOT NULL OR p_monthly_std_rate_cut_off IS NOT NULL ) THEN
730: fnd_message.set_name('PAY', 'HR_IE_TAX_CREDIT_NOT_NULL');
731: fnd_message.raise_error;
732: ELSIF p_tax_basis IN ('IE_CUMULATIVE', 'IE_WEEK1_MONTH1','IE_EXEMPTION','IE_EXEMPT_WEEK_MONTH') THEN -- Bug no 4618981
733: IF pay_freq_rec.period_type IN ('Calendar Month', 'Quarter', 'Bi-Month' ) THEN
734: IF (p_monthly_tax_credit IS NULL OR p_monthly_std_rate_cut_off IS NULL) THEN

Line 731: fnd_message.raise_error;

727: IF p_tax_basis = 'IE_EMERGENCY'
728: AND (p_weekly_tax_credit IS NOT NULL OR p_weekly_std_rate_cut_off IS NOT NULL
729: OR p_monthly_tax_credit IS NOT NULL OR p_monthly_std_rate_cut_off IS NOT NULL ) THEN
730: fnd_message.set_name('PAY', 'HR_IE_TAX_CREDIT_NOT_NULL');
731: fnd_message.raise_error;
732: ELSIF p_tax_basis IN ('IE_CUMULATIVE', 'IE_WEEK1_MONTH1','IE_EXEMPTION','IE_EXEMPT_WEEK_MONTH') THEN -- Bug no 4618981
733: IF pay_freq_rec.period_type IN ('Calendar Month', 'Quarter', 'Bi-Month' ) THEN
734: IF (p_monthly_tax_credit IS NULL OR p_monthly_std_rate_cut_off IS NULL) THEN
735: fnd_message.set_name('PAY', 'HR_IE_MONTHLY_TAX_CREDIT_NULL');

Line 735: fnd_message.set_name('PAY', 'HR_IE_MONTHLY_TAX_CREDIT_NULL');

731: fnd_message.raise_error;
732: ELSIF p_tax_basis IN ('IE_CUMULATIVE', 'IE_WEEK1_MONTH1','IE_EXEMPTION','IE_EXEMPT_WEEK_MONTH') THEN -- Bug no 4618981
733: IF pay_freq_rec.period_type IN ('Calendar Month', 'Quarter', 'Bi-Month' ) THEN
734: IF (p_monthly_tax_credit IS NULL OR p_monthly_std_rate_cut_off IS NULL) THEN
735: fnd_message.set_name('PAY', 'HR_IE_MONTHLY_TAX_CREDIT_NULL');
736: fnd_message.raise_error;
737: END IF;
738: ELSE
739: IF (p_weekly_tax_credit IS NULL OR p_weekly_std_rate_cut_off IS NULL) THEN

Line 736: fnd_message.raise_error;

732: ELSIF p_tax_basis IN ('IE_CUMULATIVE', 'IE_WEEK1_MONTH1','IE_EXEMPTION','IE_EXEMPT_WEEK_MONTH') THEN -- Bug no 4618981
733: IF pay_freq_rec.period_type IN ('Calendar Month', 'Quarter', 'Bi-Month' ) THEN
734: IF (p_monthly_tax_credit IS NULL OR p_monthly_std_rate_cut_off IS NULL) THEN
735: fnd_message.set_name('PAY', 'HR_IE_MONTHLY_TAX_CREDIT_NULL');
736: fnd_message.raise_error;
737: END IF;
738: ELSE
739: IF (p_weekly_tax_credit IS NULL OR p_weekly_std_rate_cut_off IS NULL) THEN
740: fnd_message.set_name('PAY', 'HR_IE_WEEKLY_TAX_CREDIT_NULL');

Line 740: fnd_message.set_name('PAY', 'HR_IE_WEEKLY_TAX_CREDIT_NULL');

736: fnd_message.raise_error;
737: END IF;
738: ELSE
739: IF (p_weekly_tax_credit IS NULL OR p_weekly_std_rate_cut_off IS NULL) THEN
740: fnd_message.set_name('PAY', 'HR_IE_WEEKLY_TAX_CREDIT_NULL');
741: fnd_message.raise_error;
742: END IF;
743: END IF;
744: END IF;

Line 741: fnd_message.raise_error;

737: END IF;
738: ELSE
739: IF (p_weekly_tax_credit IS NULL OR p_weekly_std_rate_cut_off IS NULL) THEN
740: fnd_message.set_name('PAY', 'HR_IE_WEEKLY_TAX_CREDIT_NULL');
741: fnd_message.raise_error;
742: END IF;
743: END IF;
744: END IF;
745: --

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

828: --
829: -- A referential integrity check was violated therefore
830: -- we must error
831: --
832: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
833: fnd_message.set_token('TABLE_NAME', l_table_name);
834: fnd_message.raise_error;
835: When Others Then
836: --

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

829: -- A referential integrity check was violated therefore
830: -- we must error
831: --
832: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
833: fnd_message.set_token('TABLE_NAME', l_table_name);
834: fnd_message.raise_error;
835: When Others Then
836: --
837: -- An unhandled or unexpected error has occurred which

Line 834: fnd_message.raise_error;

830: -- we must error
831: --
832: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
833: fnd_message.set_token('TABLE_NAME', l_table_name);
834: fnd_message.raise_error;
835: When Others Then
836: --
837: -- An unhandled or unexpected error has occurred which
838: -- we must report

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

836: --
837: -- An unhandled or unexpected error has occurred which
838: -- we must report
839: --
840: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
841: fnd_message.set_token('PROCEDURE', l_proc);
842: fnd_message.set_token('STEP','15');
843: fnd_message.raise_error;
844: End dt_update_validate;

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

837: -- An unhandled or unexpected error has occurred which
838: -- we must report
839: --
840: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
841: fnd_message.set_token('PROCEDURE', l_proc);
842: fnd_message.set_token('STEP','15');
843: fnd_message.raise_error;
844: End dt_update_validate;
845: --

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

838: -- we must report
839: --
840: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
841: fnd_message.set_token('PROCEDURE', l_proc);
842: fnd_message.set_token('STEP','15');
843: fnd_message.raise_error;
844: End dt_update_validate;
845: --
846: -- ----------------------------------------------------------------------------

Line 843: fnd_message.raise_error;

839: --
840: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
841: fnd_message.set_token('PROCEDURE', l_proc);
842: fnd_message.set_token('STEP','15');
843: fnd_message.raise_error;
844: End dt_update_validate;
845: --
846: -- ----------------------------------------------------------------------------
847: -- |--------------------------< dt_delete_validate >--------------------------|

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

935: --
936: -- A referential integrity check was violated therefore
937: -- we must error
938: --
939: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
940: fnd_message.set_token('TABLE_NAME', l_table_name);
941: fnd_message.raise_error;
942: When Others Then
943: --

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

936: -- A referential integrity check was violated therefore
937: -- we must error
938: --
939: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
940: fnd_message.set_token('TABLE_NAME', l_table_name);
941: fnd_message.raise_error;
942: When Others Then
943: --
944: -- An unhandled or unexpected error has occurred which

Line 941: fnd_message.raise_error;

937: -- we must error
938: --
939: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
940: fnd_message.set_token('TABLE_NAME', l_table_name);
941: fnd_message.raise_error;
942: When Others Then
943: --
944: -- An unhandled or unexpected error has occurred which
945: -- we must report

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

943: --
944: -- An unhandled or unexpected error has occurred which
945: -- we must report
946: --
947: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
948: fnd_message.set_token('PROCEDURE', l_proc);
949: fnd_message.set_token('STEP','15');
950: fnd_message.raise_error;
951: --

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

944: -- An unhandled or unexpected error has occurred which
945: -- we must report
946: --
947: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
948: fnd_message.set_token('PROCEDURE', l_proc);
949: fnd_message.set_token('STEP','15');
950: fnd_message.raise_error;
951: --
952: End dt_delete_validate;

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

945: -- we must report
946: --
947: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
948: fnd_message.set_token('PROCEDURE', l_proc);
949: fnd_message.set_token('STEP','15');
950: fnd_message.raise_error;
951: --
952: End dt_delete_validate;
953: --

Line 950: fnd_message.raise_error;

946: --
947: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
948: fnd_message.set_token('PROCEDURE', l_proc);
949: fnd_message.set_token('STEP','15');
950: fnd_message.raise_error;
951: --
952: End dt_delete_validate;
953: --
954: -- ----------------------------------------------------------------------------