DBA Data[Home] [Help]

APPS.HR_PERSONAL_PAY_METHOD_API dependencies on FND_MESSAGE

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

505: --
506: -- There must've been an invalid primary key for the query to
507: -- return no rows.
508: --
509: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
510: fnd_message.raise_error;
511: end if;
512: close csr_payroll_details;
513: --

Line 510: fnd_message.raise_error;

506: -- There must've been an invalid primary key for the query to
507: -- return no rows.
508: --
509: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
510: fnd_message.raise_error;
511: end if;
512: close csr_payroll_details;
513: --
514: if l_prenote_allowed = 'Y' then

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

523: --
524: -- There must've been an invalid primary key for the query to
525: -- return no rows.
526: --
527: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
528: fnd_message.raise_error;
529: end if;
530: close csr_exa_ovn;
531: --

Line 528: fnd_message.raise_error;

524: -- There must've been an invalid primary key for the query to
525: -- return no rows.
526: --
527: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
528: fnd_message.raise_error;
529: end if;
530: close csr_exa_ovn;
531: --
532: pay_exa_upd.upd

Line 936: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

932:
933: fetch csr_ppm_info_category into l_ppm_information_category;
934: if (csr_ppm_info_category%notfound) then
935: close csr_ppm_info_category;
936: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
937: fnd_message.set_token('COLUMN_NAME', 'PPM_INFORMATION_CATEGORY');
938: fnd_message.raise_error;
939: end if;
940: close csr_ppm_info_category;

Line 937: fnd_message.set_token('COLUMN_NAME', 'PPM_INFORMATION_CATEGORY');

933: fetch csr_ppm_info_category into l_ppm_information_category;
934: if (csr_ppm_info_category%notfound) then
935: close csr_ppm_info_category;
936: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
937: fnd_message.set_token('COLUMN_NAME', 'PPM_INFORMATION_CATEGORY');
938: fnd_message.raise_error;
939: end if;
940: close csr_ppm_info_category;
941: /* Bug 6439573 ppm_info_category is not null, then assigned to the local one */

Line 938: fnd_message.raise_error;

934: if (csr_ppm_info_category%notfound) then
935: close csr_ppm_info_category;
936: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
937: fnd_message.set_token('COLUMN_NAME', 'PPM_INFORMATION_CATEGORY');
938: fnd_message.raise_error;
939: end if;
940: close csr_ppm_info_category;
941: /* Bug 6439573 ppm_info_category is not null, then assigned to the local one */
942: elsif p_ppm_information_category is not null then

Line 2496: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

2492:
2493: fetch csr_ppm_info_category into l_ppm_information_category;
2494: if (csr_ppm_info_category%notfound) then
2495: close csr_ppm_info_category;
2496: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
2497: fnd_message.set_token('COLUMN_NAME', 'PPM_INFORMATION_CATEGORY');
2498: fnd_message.raise_error;
2499: end if;
2500: close csr_ppm_info_category;

Line 2497: fnd_message.set_token('COLUMN_NAME', 'PPM_INFORMATION_CATEGORY');

2493: fetch csr_ppm_info_category into l_ppm_information_category;
2494: if (csr_ppm_info_category%notfound) then
2495: close csr_ppm_info_category;
2496: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
2497: fnd_message.set_token('COLUMN_NAME', 'PPM_INFORMATION_CATEGORY');
2498: fnd_message.raise_error;
2499: end if;
2500: close csr_ppm_info_category;
2501: /* Bug 6439573 ppm_info_category is not null, then assigned to the local one */

Line 2498: fnd_message.raise_error;

2494: if (csr_ppm_info_category%notfound) then
2495: close csr_ppm_info_category;
2496: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
2497: fnd_message.set_token('COLUMN_NAME', 'PPM_INFORMATION_CATEGORY');
2498: fnd_message.raise_error;
2499: end if;
2500: close csr_ppm_info_category;
2501: /* Bug 6439573 ppm_info_category is not null, then assigned to the local one */
2502: elsif p_ppm_information_category <> hr_api.g_varchar2 then