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.HR_JP_ID_PKG dependencies on FND_MESSAGE

Line 85: fnd_message.set_name('PER','HR_JP_INVALID_SQL_STATMENT');

81: open l_csr for g_sql;
82: end if;
83: EXCEPTION
84: when others then
85: fnd_message.set_name('PER','HR_JP_INVALID_SQL_STATMENT');
86: fnd_message.set_token('SQL',g_sql);
87: fnd_message.raise_error;
88: END;
89:

Line 86: fnd_message.set_token('SQL',g_sql);

82: end if;
83: EXCEPTION
84: when others then
85: fnd_message.set_name('PER','HR_JP_INVALID_SQL_STATMENT');
86: fnd_message.set_token('SQL',g_sql);
87: fnd_message.raise_error;
88: END;
89:
90: return l_csr;

Line 87: fnd_message.raise_error;

83: EXCEPTION
84: when others then
85: fnd_message.set_name('PER','HR_JP_INVALID_SQL_STATMENT');
86: fnd_message.set_token('SQL',g_sql);
87: fnd_message.raise_error;
88: END;
89:
90: return l_csr;
91: END;

Line 104: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');

100: if p_csr%NOTFOUND then
101: l_found := FALSE;
102: if p_error_when_not_exist = 'TRUE' then
103: close p_csr;
104: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
105: fnd_message.set_token('SQL',g_sql);
106: fnd_message.raise_error;
107: end if;
108: else

Line 105: fnd_message.set_token('SQL',g_sql);

101: l_found := FALSE;
102: if p_error_when_not_exist = 'TRUE' then
103: close p_csr;
104: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
105: fnd_message.set_token('SQL',g_sql);
106: fnd_message.raise_error;
107: end if;
108: else
109: l_found := TRUE;

Line 106: fnd_message.raise_error;

102: if p_error_when_not_exist = 'TRUE' then
103: close p_csr;
104: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
105: fnd_message.set_token('SQL',g_sql);
106: fnd_message.raise_error;
107: end if;
108: else
109: l_found := TRUE;
110: end if;

Line 149: fnd_message.set_name('PER','HR_JP_INVALID_ARGUMENT');

145: l_legislation_code VARCHAR2(2);
146: PROCEDURE raise_error
147: IS
148: BEGIN
149: fnd_message.set_name('PER','HR_JP_INVALID_ARGUMENT');
150: fnd_message.set_token('PROCEDURE','hr_jp_id_pkg.construct_bus_leg_where_clause');
151: fnd_message.raise_error;
152: END;
153: BEGIN

Line 150: fnd_message.set_token('PROCEDURE','hr_jp_id_pkg.construct_bus_leg_where_clause');

146: PROCEDURE raise_error
147: IS
148: BEGIN
149: fnd_message.set_name('PER','HR_JP_INVALID_ARGUMENT');
150: fnd_message.set_token('PROCEDURE','hr_jp_id_pkg.construct_bus_leg_where_clause');
151: fnd_message.raise_error;
152: END;
153: BEGIN
154: if p_business_group_id = C_DEFAULT_BUS then

Line 151: fnd_message.raise_error;

147: IS
148: BEGIN
149: fnd_message.set_name('PER','HR_JP_INVALID_ARGUMENT');
150: fnd_message.set_token('PROCEDURE','hr_jp_id_pkg.construct_bus_leg_where_clause');
151: fnd_message.raise_error;
152: END;
153: BEGIN
154: if p_business_group_id = C_DEFAULT_BUS then
155: -- p_business_group_id p_legislation_code description

Line 265: fnd_message.raise_error;

261: if l_valid then
262: l_keyflex_combination_id := fnd_flex_keyval.combination_id;
263: else
264: if p_error_when_not_exist = 'TRUE' then
265: fnd_message.raise_error;
266: else
267: l_keyflex_combination_id := NULL;
268: end if;
269: end if;

Line 285: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');

281: l_rec PER_BUSINESS_GROUPS%ROWTYPE;
282: BEGIN
283: if p_business_group_id is NULL then
284: if p_error_when_not_exist = 'TRUE' then
285: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
286: fnd_message.raise_error;
287: end if;
288:
289: return l_rec;

Line 286: fnd_message.raise_error;

282: BEGIN
283: if p_business_group_id is NULL then
284: if p_error_when_not_exist = 'TRUE' then
285: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
286: fnd_message.raise_error;
287: end if;
288:
289: return l_rec;
290: else

Line 347: fnd_message.set_name('PER','HR_JP_INVALID_PARAMETER');

343: l_id_flex_num := to_number(l_rec.cost_allocation_structure);
344: elsif p_id_flex_code = 'GRP' then
345: l_id_flex_num := to_number(l_rec.people_group_structure);
346: else
347: fnd_message.set_name('PER','HR_JP_INVALID_PARAMETER');
348: fnd_message.set_token('PROCEDURE','hr_jp_id_pkg.id_flex_num');
349: fnd_message.set_token('PARAMETER',p_id_flex_code);
350: fnd_message.raise_error;
351: end if;

Line 348: fnd_message.set_token('PROCEDURE','hr_jp_id_pkg.id_flex_num');

344: elsif p_id_flex_code = 'GRP' then
345: l_id_flex_num := to_number(l_rec.people_group_structure);
346: else
347: fnd_message.set_name('PER','HR_JP_INVALID_PARAMETER');
348: fnd_message.set_token('PROCEDURE','hr_jp_id_pkg.id_flex_num');
349: fnd_message.set_token('PARAMETER',p_id_flex_code);
350: fnd_message.raise_error;
351: end if;
352:

Line 349: fnd_message.set_token('PARAMETER',p_id_flex_code);

345: l_id_flex_num := to_number(l_rec.people_group_structure);
346: else
347: fnd_message.set_name('PER','HR_JP_INVALID_PARAMETER');
348: fnd_message.set_token('PROCEDURE','hr_jp_id_pkg.id_flex_num');
349: fnd_message.set_token('PARAMETER',p_id_flex_code);
350: fnd_message.raise_error;
351: end if;
352:
353: return l_id_flex_num;

Line 350: fnd_message.raise_error;

346: else
347: fnd_message.set_name('PER','HR_JP_INVALID_PARAMETER');
348: fnd_message.set_token('PROCEDURE','hr_jp_id_pkg.id_flex_num');
349: fnd_message.set_token('PARAMETER',p_id_flex_code);
350: fnd_message.raise_error;
351: end if;
352:
353: return l_id_flex_num;
354: END;

Line 384: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');

380: fetch csr_currency_code into l_currency_code;
381: if csr_currency_code%NOTFOUND then
382: if p_error_when_not_exist = 'TRUE' then
383: close csr_currency_code;
384: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
385: fnd_message.raise_error;
386: end if;
387: end if;
388: close csr_currency_code;

Line 385: fnd_message.raise_error;

381: if csr_currency_code%NOTFOUND then
382: if p_error_when_not_exist = 'TRUE' then
383: close csr_currency_code;
384: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
385: fnd_message.raise_error;
386: end if;
387: end if;
388: close csr_currency_code;
389:

Line 1566: fnd_message.set_name('PAY','HR_51271_ELE_NOT_ELIGIBLE');

1562: BEGIN
1563: l_element_link_id := hr_entry_api.get_link(p_assignment_id,p_element_type_id,p_effective_date);
1564:
1565: if p_error_when_not_exist = 'TRUE' and l_element_link_id is NULL then
1566: fnd_message.set_name('PAY','HR_51271_ELE_NOT_ELIGIBLE');
1567: fnd_message.raise_error;
1568: end if;
1569:
1570: return l_element_link_id;

Line 1567: fnd_message.raise_error;

1563: l_element_link_id := hr_entry_api.get_link(p_assignment_id,p_element_type_id,p_effective_date);
1564:
1565: if p_error_when_not_exist = 'TRUE' and l_element_link_id is NULL then
1566: fnd_message.set_name('PAY','HR_51271_ELE_NOT_ELIGIBLE');
1567: fnd_message.raise_error;
1568: end if;
1569:
1570: return l_element_link_id;
1571: END;

Line 1685: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');

1681: if csr_payment_defined_balance_id%NOTFOUND then
1682: if p_error_when_not_exist = 'TRUE' then
1683: close csr_payment_defined_balance_id;
1684:
1685: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
1686: fnd_message.raise_error;
1687: else
1688: l_rec := NULL;
1689: end if;

Line 1686: fnd_message.raise_error;

1682: if p_error_when_not_exist = 'TRUE' then
1683: close csr_payment_defined_balance_id;
1684:
1685: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
1686: fnd_message.raise_error;
1687: else
1688: l_rec := NULL;
1689: end if;
1690: end if;

Line 1890: fnd_message.set_name('PER','HR_JP_PERSON_NOT_FOUND');

1886: if csr_period_of_service%NOTFOUND then
1887: if p_error_when_not_exist = 'TRUE' then
1888: close csr_period_of_service;
1889:
1890: fnd_message.set_name('PER','HR_JP_PERSON_NOT_FOUND');
1891: fnd_message.set_token('EMPLOYEE_NUMBER',p_employee_number);
1892: fnd_message.raise_error;
1893: end if;
1894: end if;

Line 1891: fnd_message.set_token('EMPLOYEE_NUMBER',p_employee_number);

1887: if p_error_when_not_exist = 'TRUE' then
1888: close csr_period_of_service;
1889:
1890: fnd_message.set_name('PER','HR_JP_PERSON_NOT_FOUND');
1891: fnd_message.set_token('EMPLOYEE_NUMBER',p_employee_number);
1892: fnd_message.raise_error;
1893: end if;
1894: end if;
1895: close csr_period_of_service;

Line 1892: fnd_message.raise_error;

1888: close csr_period_of_service;
1889:
1890: fnd_message.set_name('PER','HR_JP_PERSON_NOT_FOUND');
1891: fnd_message.set_token('EMPLOYEE_NUMBER',p_employee_number);
1892: fnd_message.raise_error;
1893: end if;
1894: end if;
1895: close csr_period_of_service;
1896:

Line 1932: fnd_message.set_name('PER','HR_JP_ELEMENT_ENTRY_NOT_FOUND');

1928: if csr_element_entry%NOTFOUND then
1929: if p_error_when_not_exist = 'TRUE' then
1930: close csr_element_entry;
1931:
1932: fnd_message.set_name('PER','HR_JP_ELEMENT_ENTRY_NOT_FOUND');
1933: fnd_message.raise_error;
1934: else
1935: l_rec := NULL;
1936: end if;

Line 1933: fnd_message.raise_error;

1929: if p_error_when_not_exist = 'TRUE' then
1930: close csr_element_entry;
1931:
1932: fnd_message.set_name('PER','HR_JP_ELEMENT_ENTRY_NOT_FOUND');
1933: fnd_message.raise_error;
1934: else
1935: l_rec := NULL;
1936: end if;
1937: end if;

Line 1984: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');

1980: fetch l_csr into l_rec;
1981: if l_csr%NOTFOUND then
1982: if p_error_when_not_exist = 'TRUE' then
1983: close l_csr;
1984: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
1985: fnd_message.set_token('SQL',g_sql);
1986: fnd_message.raise_error;
1987: else
1988: l_rec := NULL;

Line 1985: fnd_message.set_token('SQL',g_sql);

1981: if l_csr%NOTFOUND then
1982: if p_error_when_not_exist = 'TRUE' then
1983: close l_csr;
1984: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
1985: fnd_message.set_token('SQL',g_sql);
1986: fnd_message.raise_error;
1987: else
1988: l_rec := NULL;
1989: end if;

Line 1986: fnd_message.raise_error;

1982: if p_error_when_not_exist = 'TRUE' then
1983: close l_csr;
1984: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
1985: fnd_message.set_token('SQL',g_sql);
1986: fnd_message.raise_error;
1987: else
1988: l_rec := NULL;
1989: end if;
1990: end if;

Line 2099: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');

2095: fetch l_csr into l_rec;
2096: if l_csr%NOTFOUND then
2097: if p_error_when_not_exist = 'TRUE' then
2098: close l_csr;
2099: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
2100: fnd_message.set_token('SQL',g_sql);
2101: fnd_message.raise_error;
2102: else
2103: l_rec := NULL;

Line 2100: fnd_message.set_token('SQL',g_sql);

2096: if l_csr%NOTFOUND then
2097: if p_error_when_not_exist = 'TRUE' then
2098: close l_csr;
2099: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
2100: fnd_message.set_token('SQL',g_sql);
2101: fnd_message.raise_error;
2102: else
2103: l_rec := NULL;
2104: end if;

Line 2101: fnd_message.raise_error;

2097: if p_error_when_not_exist = 'TRUE' then
2098: close l_csr;
2099: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
2100: fnd_message.set_token('SQL',g_sql);
2101: fnd_message.raise_error;
2102: else
2103: l_rec := NULL;
2104: end if;
2105: end if;

Line 2143: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');

2139: fetch l_csr into l_rec;
2140: if l_csr%NOTFOUND then
2141: if p_error_when_not_exist = 'TRUE' then
2142: close l_csr;
2143: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
2144: fnd_message.set_token('SQL',g_sql);
2145: fnd_message.raise_error;
2146: else
2147: l_rec := NULL;

Line 2144: fnd_message.set_token('SQL',g_sql);

2140: if l_csr%NOTFOUND then
2141: if p_error_when_not_exist = 'TRUE' then
2142: close l_csr;
2143: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
2144: fnd_message.set_token('SQL',g_sql);
2145: fnd_message.raise_error;
2146: else
2147: l_rec := NULL;
2148: end if;

Line 2145: fnd_message.raise_error;

2141: if p_error_when_not_exist = 'TRUE' then
2142: close l_csr;
2143: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
2144: fnd_message.set_token('SQL',g_sql);
2145: fnd_message.raise_error;
2146: else
2147: l_rec := NULL;
2148: end if;
2149: end if;

Line 2193: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');

2189: fetch l_csr into l_rec;
2190: if l_csr%NOTFOUND then
2191: if p_error_when_not_exist = 'TRUE' then
2192: close l_csr;
2193: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
2194: fnd_message.set_token('SQL',g_sql);
2195: fnd_message.raise_error;
2196: else
2197: l_rec := NULL;

Line 2194: fnd_message.set_token('SQL',g_sql);

2190: if l_csr%NOTFOUND then
2191: if p_error_when_not_exist = 'TRUE' then
2192: close l_csr;
2193: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
2194: fnd_message.set_token('SQL',g_sql);
2195: fnd_message.raise_error;
2196: else
2197: l_rec := NULL;
2198: end if;

Line 2195: fnd_message.raise_error;

2191: if p_error_when_not_exist = 'TRUE' then
2192: close l_csr;
2193: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
2194: fnd_message.set_token('SQL',g_sql);
2195: fnd_message.raise_error;
2196: else
2197: l_rec := NULL;
2198: end if;
2199: end if;

Line 2248: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');

2244: fetch l_csr into l_rec;
2245: if l_csr%NOTFOUND then
2246: if p_error_when_not_exist = 'TRUE' then
2247: close l_csr;
2248: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
2249: fnd_message.set_token('SQL',g_sql);
2250: fnd_message.raise_error;
2251: else
2252: l_rec := NULL;

Line 2249: fnd_message.set_token('SQL',g_sql);

2245: if l_csr%NOTFOUND then
2246: if p_error_when_not_exist = 'TRUE' then
2247: close l_csr;
2248: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
2249: fnd_message.set_token('SQL',g_sql);
2250: fnd_message.raise_error;
2251: else
2252: l_rec := NULL;
2253: end if;

Line 2250: fnd_message.raise_error;

2246: if p_error_when_not_exist = 'TRUE' then
2247: close l_csr;
2248: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
2249: fnd_message.set_token('SQL',g_sql);
2250: fnd_message.raise_error;
2251: else
2252: l_rec := NULL;
2253: end if;
2254: end if;

Line 2278: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');

2274: fetch l_csr into l_rec;
2275: if l_csr%NOTFOUND then
2276: if p_error_when_not_exist = 'TRUE' then
2277: close l_csr;
2278: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
2279: fnd_message.set_token('SQL',g_sql);
2280: fnd_message.raise_error;
2281: else
2282: l_rec := NULL;

Line 2279: fnd_message.set_token('SQL',g_sql);

2275: if l_csr%NOTFOUND then
2276: if p_error_when_not_exist = 'TRUE' then
2277: close l_csr;
2278: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
2279: fnd_message.set_token('SQL',g_sql);
2280: fnd_message.raise_error;
2281: else
2282: l_rec := NULL;
2283: end if;

Line 2280: fnd_message.raise_error;

2276: if p_error_when_not_exist = 'TRUE' then
2277: close l_csr;
2278: fnd_message.set_name('PER','HR_JP_ID_NOT_FOUND');
2279: fnd_message.set_token('SQL',g_sql);
2280: fnd_message.raise_error;
2281: else
2282: l_rec := NULL;
2283: end if;
2284: end if;