DBA Data[Home] [Help]

APPS.HR_PERSONAL_PAY_METHOD_API dependencies on FND_MESSAGE

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

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

Line 506: fnd_message.raise_error;

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

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

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

Line 524: fnd_message.raise_error;

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

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

927:
928: fetch csr_ppm_info_category into l_ppm_information_category;
929: if (csr_ppm_info_category%notfound) then
930: close csr_ppm_info_category;
931: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
932: fnd_message.set_token('COLUMN_NAME', 'PPM_INFORMATION_CATEGORY');
933: fnd_message.raise_error;
934: end if;
935: close csr_ppm_info_category;

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

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

Line 933: fnd_message.raise_error;

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

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

2296:
2297: fetch csr_ppm_info_category into l_ppm_information_category;
2298: if (csr_ppm_info_category%notfound) then
2299: close csr_ppm_info_category;
2300: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
2301: fnd_message.set_token('COLUMN_NAME', 'PPM_INFORMATION_CATEGORY');
2302: fnd_message.raise_error;
2303: end if;
2304: close csr_ppm_info_category;

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

2297: fetch csr_ppm_info_category into l_ppm_information_category;
2298: if (csr_ppm_info_category%notfound) then
2299: close csr_ppm_info_category;
2300: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
2301: fnd_message.set_token('COLUMN_NAME', 'PPM_INFORMATION_CATEGORY');
2302: fnd_message.raise_error;
2303: end if;
2304: close csr_ppm_info_category;
2305: /* Bug 6439573 ppm_info_category is not null, then assigned to the local one */

Line 2302: fnd_message.raise_error;

2298: if (csr_ppm_info_category%notfound) then
2299: close csr_ppm_info_category;
2300: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
2301: fnd_message.set_token('COLUMN_NAME', 'PPM_INFORMATION_CATEGORY');
2302: fnd_message.raise_error;
2303: end if;
2304: close csr_ppm_info_category;
2305: /* Bug 6439573 ppm_info_category is not null, then assigned to the local one */
2306: elsif p_ppm_information_category <> hr_api.g_varchar2 then