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_PAYROLL_API dependencies on FND_MESSAGE

Line 631: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

627: fetch csr_cost_alloc_exists into l_dummy;
628: if (csr_cost_alloc_exists%NOTFOUND) then
629: --
630: close csr_cost_alloc_exists;
631: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
632: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');
633: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
634: fnd_message.raise_error;
635: --

Line 632: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');

628: if (csr_cost_alloc_exists%NOTFOUND) then
629: --
630: close csr_cost_alloc_exists;
631: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
632: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');
633: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
634: fnd_message.raise_error;
635: --
636: end if;

Line 633: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');

629: --
630: close csr_cost_alloc_exists;
631: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
632: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');
633: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
634: fnd_message.raise_error;
635: --
636: end if;
637: close csr_cost_alloc_exists;

Line 634: fnd_message.raise_error;

630: close csr_cost_alloc_exists;
631: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
632: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');
633: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
634: fnd_message.raise_error;
635: --
636: end if;
637: close csr_cost_alloc_exists;
638: --

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

648: fetch csr_cost_alloc_exists into l_dummy;
649: if (csr_cost_alloc_exists%NOTFOUND) then
650: --
651: close csr_cost_alloc_exists;
652: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
653: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');
654: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
655: fnd_message.raise_error;
656: --

Line 653: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');

649: if (csr_cost_alloc_exists%NOTFOUND) then
650: --
651: close csr_cost_alloc_exists;
652: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
653: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');
654: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
655: fnd_message.raise_error;
656: --
657: end if;

Line 654: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');

650: --
651: close csr_cost_alloc_exists;
652: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
653: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');
654: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
655: fnd_message.raise_error;
656: --
657: end if;
658: close csr_cost_alloc_exists;

Line 655: fnd_message.raise_error;

651: close csr_cost_alloc_exists;
652: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
653: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');
654: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
655: fnd_message.raise_error;
656: --
657: end if;
658: close csr_cost_alloc_exists;
659: --

Line 673: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

669: fetch csr_soft_coding_exists into l_dummy;
670: if (csr_soft_coding_exists%NOTFOUND) then
671: --
672: close csr_soft_coding_exists;
673: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
674: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');
675: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');
676: fnd_message.raise_error;
677: --

Line 674: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');

670: if (csr_soft_coding_exists%NOTFOUND) then
671: --
672: close csr_soft_coding_exists;
673: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
674: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');
675: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');
676: fnd_message.raise_error;
677: --
678: end if;

Line 675: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');

671: --
672: close csr_soft_coding_exists;
673: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
674: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');
675: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');
676: fnd_message.raise_error;
677: --
678: end if;
679: close csr_soft_coding_exists;

Line 676: fnd_message.raise_error;

672: close csr_soft_coding_exists;
673: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
674: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');
675: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');
676: fnd_message.raise_error;
677: --
678: end if;
679: close csr_soft_coding_exists;
680: --

Line 1861: fnd_message.set_name('PAY', 'HR_51043_PRL_DOES_NOT_EXIST');

1857: fetch csr_chk_payroll into l_dummy_char;
1858: if(csr_chk_payroll%NOTFOUND)then
1859: --
1860: close csr_chk_payroll;
1861: fnd_message.set_name('PAY', 'HR_51043_PRL_DOES_NOT_EXIST');
1862: fnd_message.raise_error;
1863: --
1864: end if;
1865: close csr_chk_payroll;

Line 1862: fnd_message.raise_error;

1858: if(csr_chk_payroll%NOTFOUND)then
1859: --
1860: close csr_chk_payroll;
1861: fnd_message.set_name('PAY', 'HR_51043_PRL_DOES_NOT_EXIST');
1862: fnd_message.raise_error;
1863: --
1864: end if;
1865: close csr_chk_payroll;
1866:

Line 1907: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

1903: fetch csr_cost_alloc_exists into l_dummy;
1904: if (csr_cost_alloc_exists%NOTFOUND) then
1905: --
1906: close csr_cost_alloc_exists;
1907: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1908: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');
1909: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1910: fnd_message.raise_error;
1911: --

Line 1908: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');

1904: if (csr_cost_alloc_exists%NOTFOUND) then
1905: --
1906: close csr_cost_alloc_exists;
1907: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1908: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');
1909: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1910: fnd_message.raise_error;
1911: --
1912: end if;

Line 1909: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');

1905: --
1906: close csr_cost_alloc_exists;
1907: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1908: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');
1909: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1910: fnd_message.raise_error;
1911: --
1912: end if;
1913: close csr_cost_alloc_exists;

Line 1910: fnd_message.raise_error;

1906: close csr_cost_alloc_exists;
1907: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1908: fnd_message.set_token('COLUMN','COST_ALLOCATION_KEYFLEX_ID');
1909: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1910: fnd_message.raise_error;
1911: --
1912: end if;
1913: close csr_cost_alloc_exists;
1914: --

Line 1927: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

1923: fetch csr_cost_alloc_exists into l_dummy;
1924: if (csr_cost_alloc_exists%NOTFOUND) then
1925: --
1926: close csr_cost_alloc_exists;
1927: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1928: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');
1929: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1930: fnd_message.raise_error;
1931: --

Line 1928: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');

1924: if (csr_cost_alloc_exists%NOTFOUND) then
1925: --
1926: close csr_cost_alloc_exists;
1927: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1928: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');
1929: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1930: fnd_message.raise_error;
1931: --
1932: end if;

Line 1929: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');

1925: --
1926: close csr_cost_alloc_exists;
1927: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1928: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');
1929: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1930: fnd_message.raise_error;
1931: --
1932: end if;
1933: close csr_cost_alloc_exists;

Line 1930: fnd_message.raise_error;

1926: close csr_cost_alloc_exists;
1927: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1928: fnd_message.set_token('COLUMN','SUSPENSE_ACCOUNT_KEYFLEX_ID');
1929: fnd_message.set_token('TABLE','PAY_COST_ALLOCATION_KEYFLEX');
1930: fnd_message.raise_error;
1931: --
1932: end if;
1933: close csr_cost_alloc_exists;
1934: --

Line 1949: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

1945: fetch csr_soft_coding_exists into l_dummy;
1946: if (csr_soft_coding_exists%NOTFOUND) then
1947: --
1948: close csr_soft_coding_exists;
1949: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1950: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');
1951: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');
1952: fnd_message.raise_error;
1953: --

Line 1950: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');

1946: if (csr_soft_coding_exists%NOTFOUND) then
1947: --
1948: close csr_soft_coding_exists;
1949: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1950: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');
1951: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');
1952: fnd_message.raise_error;
1953: --
1954: end if;

Line 1951: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');

1947: --
1948: close csr_soft_coding_exists;
1949: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1950: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');
1951: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');
1952: fnd_message.raise_error;
1953: --
1954: end if;
1955: close csr_soft_coding_exists;

Line 1952: fnd_message.raise_error;

1948: close csr_soft_coding_exists;
1949: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
1950: fnd_message.set_token('COLUMN','SOFT_CODING_KEYFLEX_ID');
1951: fnd_message.set_token('TABLE','HR_SOFT_CODING_KEYFLEX');
1952: fnd_message.raise_error;
1953: --
1954: end if;
1955: close csr_soft_coding_exists;
1956: --

Line 2168: fnd_message.set_name('PAY', 'HR_INVALID_PAYROLL_ID');

2164: fetch csr_get_costKFF into l_cost_allocation_keyflex_id;
2165: if(csr_get_costKFF%NOTFOUND) then
2166: --
2167: close csr_get_costKFF;
2168: fnd_message.set_name('PAY', 'HR_INVALID_PAYROLL_ID');
2169: fnd_message.raise_error;
2170: --
2171: end if;
2172: close csr_get_costKFF;

Line 2169: fnd_message.raise_error;

2165: if(csr_get_costKFF%NOTFOUND) then
2166: --
2167: close csr_get_costKFF;
2168: fnd_message.set_name('PAY', 'HR_INVALID_PAYROLL_ID');
2169: fnd_message.raise_error;
2170: --
2171: end if;
2172: close csr_get_costKFF;
2173:

Line 2255: fnd_message.set_name('PAY', 'HR_INVALID_PAYROLL_ID');

2251: fetch csr_get_suspenseKFF into l_suspense_account_keyflex_id;
2252: if(csr_get_suspenseKFF%NOTFOUND) then
2253: --
2254: close csr_get_suspenseKFF;
2255: fnd_message.set_name('PAY', 'HR_INVALID_PAYROLL_ID');
2256: fnd_message.raise_error;
2257: --
2258: end if;
2259: close csr_get_suspenseKFF;

Line 2256: fnd_message.raise_error;

2252: if(csr_get_suspenseKFF%NOTFOUND) then
2253: --
2254: close csr_get_suspenseKFF;
2255: fnd_message.set_name('PAY', 'HR_INVALID_PAYROLL_ID');
2256: fnd_message.raise_error;
2257: --
2258: end if;
2259: close csr_get_suspenseKFF;
2260:

Line 2342: fnd_message.set_name('PAY', 'HR_INVALID_PAYROLL_ID');

2338: fetch csr_get_softKFF into l_soft_coding_keyflex_id;
2339: if(csr_get_softKFF%NOTFOUND) then
2340: --
2341: close csr_get_softKFF;
2342: fnd_message.set_name('PAY', 'HR_INVALID_PAYROLL_ID');
2343: fnd_message.raise_error;
2344: --
2345: end if;
2346: close csr_get_softKFF;

Line 2343: fnd_message.raise_error;

2339: if(csr_get_softKFF%NOTFOUND) then
2340: --
2341: close csr_get_softKFF;
2342: fnd_message.set_name('PAY', 'HR_INVALID_PAYROLL_ID');
2343: fnd_message.raise_error;
2344: --
2345: end if;
2346: close csr_get_softKFF;
2347:

Line 3025: fnd_message.set_name('PAY', 'PAY_33275_INFOCATEGORY_INVALID');

3021:
3022: --Get the Legislation code.
3023: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);
3024: if(l_legislation_code <> p_prl_information_category) then
3025: fnd_message.set_name('PAY', 'PAY_33275_INFOCATEGORY_INVALID');
3026: fnd_message.raise_error;
3027: end if;
3028:
3029: pay_payroll_api.create_payroll(

Line 3026: fnd_message.raise_error;

3022: --Get the Legislation code.
3023: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);
3024: if(l_legislation_code <> p_prl_information_category) then
3025: fnd_message.set_name('PAY', 'PAY_33275_INFOCATEGORY_INVALID');
3026: fnd_message.raise_error;
3027: end if;
3028:
3029: pay_payroll_api.create_payroll(
3030:

Line 3253: fnd_message.set_name('PAY', 'PAY_KR_INV_CS_BG');

3249: open csr_get_BG;
3250: fetch csr_get_BG into l_business_group_id;
3251: if (csr_get_BG % NOTFOUND) then
3252: close csr_get_BG;
3253: fnd_message.set_name('PAY', 'PAY_KR_INV_CS_BG');
3254: fnd_message.raise_error;
3255: end if;
3256: close csr_get_BG;
3257: else

Line 3254: fnd_message.raise_error;

3250: fetch csr_get_BG into l_business_group_id;
3251: if (csr_get_BG % NOTFOUND) then
3252: close csr_get_BG;
3253: fnd_message.set_name('PAY', 'PAY_KR_INV_CS_BG');
3254: fnd_message.raise_error;
3255: end if;
3256: close csr_get_BG;
3257: else
3258: pay_pay_bus.chk_consolidation_set_id(p_consolidation_set_id, l_business_group_id);

Line 3266: fnd_message.set_name('PAY', 'PAY_33275_INFOCATEGORY_INVALID');

3262: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);
3263:
3264: if(l_legislation_code <> p_prl_information_category and
3265: p_prl_information_category <> hr_api.g_varchar2) then
3266: fnd_message.set_name('PAY', 'PAY_33275_INFOCATEGORY_INVALID');
3267: fnd_message.raise_error;
3268: end if;
3269:
3270: pay_payroll_api.update_payroll(

Line 3267: fnd_message.raise_error;

3263:
3264: if(l_legislation_code <> p_prl_information_category and
3265: p_prl_information_category <> hr_api.g_varchar2) then
3266: fnd_message.set_name('PAY', 'PAY_33275_INFOCATEGORY_INVALID');
3267: fnd_message.raise_error;
3268: end if;
3269:
3270: pay_payroll_api.update_payroll(
3271: p_validate => p_validate