DBA Data[Home] [Help]

APPS.HR_TIP_BUS dependencies on FND_MESSAGE

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

93: --
94: -- The primary key is invalid therefore we must error
95: --
96: close csr_leg_code;
97: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
98: fnd_message.raise_error;
99: end if;
100: hr_utility.set_location(l_proc,30);
101: --

Line 98: fnd_message.raise_error;

94: -- The primary key is invalid therefore we must error
95: --
96: close csr_leg_code;
97: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
98: fnd_message.raise_error;
99: end if;
100: hr_utility.set_location(l_proc,30);
101: --
102: -- Set the global variables so the values are

Line 157: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

153: IF NOT hr_tip_shd.api_updating
154: (p_template_item_tab_page_id => p_rec.template_item_tab_page_id
155: ,p_object_version_number => p_rec.object_version_number
156: ) THEN
157: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
158: fnd_message.set_token('PROCEDURE ', l_proc);
159: fnd_message.set_token('STEP ', '5');
160: fnd_message.raise_error;
161: END IF;

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

154: (p_template_item_tab_page_id => p_rec.template_item_tab_page_id
155: ,p_object_version_number => p_rec.object_version_number
156: ) THEN
157: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
158: fnd_message.set_token('PROCEDURE ', l_proc);
159: fnd_message.set_token('STEP ', '5');
160: fnd_message.raise_error;
161: END IF;
162: --

Line 159: fnd_message.set_token('STEP ', '5');

155: ,p_object_version_number => p_rec.object_version_number
156: ) THEN
157: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
158: fnd_message.set_token('PROCEDURE ', l_proc);
159: fnd_message.set_token('STEP ', '5');
160: fnd_message.raise_error;
161: END IF;
162: --
163: IF (nvl(p_rec.template_item_id,hr_api.g_number) <>

Line 160: fnd_message.raise_error;

156: ) THEN
157: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
158: fnd_message.set_token('PROCEDURE ', l_proc);
159: fnd_message.set_token('STEP ', '5');
160: fnd_message.raise_error;
161: END IF;
162: --
163: IF (nvl(p_rec.template_item_id,hr_api.g_number) <>
164: nvl(hr_tip_shd.g_old_rec.template_item_id,hr_api.g_number)

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

302: open csr_template_item;
303: fetch csr_template_item into l_item_template_id;
304: if csr_template_item%notfound then
305: close csr_template_item;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE', l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: end if;

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

303: fetch csr_template_item into l_item_template_id;
304: if csr_template_item%notfound then
305: close csr_template_item;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE', l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: end if;
311: close csr_template_item;

Line 308: fnd_message.set_token('STEP','10');

304: if csr_template_item%notfound then
305: close csr_template_item;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE', l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: end if;
311: close csr_template_item;
312: --

Line 309: fnd_message.raise_error;

305: close csr_template_item;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE', l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: end if;
311: close csr_template_item;
312: --
313: open csr_template_tab_page;

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

313: open csr_template_tab_page;
314: fetch csr_template_tab_page into l_tab_page_template_id;
315: if csr_template_tab_page%notfound then
316: close csr_template_tab_page;
317: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
318: fnd_message.set_token('PROCEDURE', l_proc);
319: fnd_message.set_token('STEP','20');
320: fnd_message.raise_error;
321: end if;

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

314: fetch csr_template_tab_page into l_tab_page_template_id;
315: if csr_template_tab_page%notfound then
316: close csr_template_tab_page;
317: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
318: fnd_message.set_token('PROCEDURE', l_proc);
319: fnd_message.set_token('STEP','20');
320: fnd_message.raise_error;
321: end if;
322: close csr_template_tab_page;

Line 319: fnd_message.set_token('STEP','20');

315: if csr_template_tab_page%notfound then
316: close csr_template_tab_page;
317: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
318: fnd_message.set_token('PROCEDURE', l_proc);
319: fnd_message.set_token('STEP','20');
320: fnd_message.raise_error;
321: end if;
322: close csr_template_tab_page;
323: --

Line 320: fnd_message.raise_error;

316: close csr_template_tab_page;
317: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
318: fnd_message.set_token('PROCEDURE', l_proc);
319: fnd_message.set_token('STEP','20');
320: fnd_message.raise_error;
321: end if;
322: close csr_template_tab_page;
323: --
324: hr_utility.set_location(l_proc,40);

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

326: -- Check item and tab page reference the same template
327: --
328: if nvl(l_item_template_id,hr_api.g_number) <>
329: nvl(l_tab_page_template_id,hr_api.g_number) then
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc);
332: fnd_message.set_token('STEP','30');
333: fnd_message.raise_error;
334: end if;

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

327: --
328: if nvl(l_item_template_id,hr_api.g_number) <>
329: nvl(l_tab_page_template_id,hr_api.g_number) then
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc);
332: fnd_message.set_token('STEP','30');
333: fnd_message.raise_error;
334: end if;
335: --

Line 332: fnd_message.set_token('STEP','30');

328: if nvl(l_item_template_id,hr_api.g_number) <>
329: nvl(l_tab_page_template_id,hr_api.g_number) then
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc);
332: fnd_message.set_token('STEP','30');
333: fnd_message.raise_error;
334: end if;
335: --
336: hr_utility.set_location(l_proc,50);

Line 333: fnd_message.raise_error;

329: nvl(l_tab_page_template_id,hr_api.g_number) then
330: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
331: fnd_message.set_token('PROCEDURE', l_proc);
332: fnd_message.set_token('STEP','30');
333: fnd_message.raise_error;
334: end if;
335: --
336: hr_utility.set_location(l_proc,50);
337: --

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

340: open csr_tab_stacked_canvas;
341: fetch csr_tab_stacked_canvas into l_dummy;
342: if csr_tab_stacked_canvas%notfound then
343: close csr_tab_stacked_canvas;
344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
345: fnd_message.set_token('PROCEDURE', l_proc);
346: fnd_message.set_token('STEP','40');
347: fnd_message.raise_error;
348: end if;

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

341: fetch csr_tab_stacked_canvas into l_dummy;
342: if csr_tab_stacked_canvas%notfound then
343: close csr_tab_stacked_canvas;
344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
345: fnd_message.set_token('PROCEDURE', l_proc);
346: fnd_message.set_token('STEP','40');
347: fnd_message.raise_error;
348: end if;
349: close csr_tab_stacked_canvas;

Line 346: fnd_message.set_token('STEP','40');

342: if csr_tab_stacked_canvas%notfound then
343: close csr_tab_stacked_canvas;
344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
345: fnd_message.set_token('PROCEDURE', l_proc);
346: fnd_message.set_token('STEP','40');
347: fnd_message.raise_error;
348: end if;
349: close csr_tab_stacked_canvas;
350: --

Line 347: fnd_message.raise_error;

343: close csr_tab_stacked_canvas;
344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
345: fnd_message.set_token('PROCEDURE', l_proc);
346: fnd_message.set_token('STEP','40');
347: fnd_message.raise_error;
348: end if;
349: close csr_tab_stacked_canvas;
350: --
351: end if;