DBA Data[Home] [Help]

APPS.HR_FSC_BUS dependencies on HR_API

Line 112: IF (nvl(p_rec.form_tab_page_id,hr_api.g_number) <>

108: fnd_message.set_token('STEP ', '5');
109: fnd_message.raise_error;
110: END IF;
111: --
112: IF (nvl(p_rec.form_tab_page_id,hr_api.g_number) <>
113: nvl(hr_fsc_shd.g_old_rec.form_tab_page_id,hr_api.g_number)
114: ) THEN
115: l_argument := 'form_tab_page_id';
116: RAISE l_error;

Line 113: nvl(hr_fsc_shd.g_old_rec.form_tab_page_id,hr_api.g_number)

109: fnd_message.raise_error;
110: END IF;
111: --
112: IF (nvl(p_rec.form_tab_page_id,hr_api.g_number) <>
113: nvl(hr_fsc_shd.g_old_rec.form_tab_page_id,hr_api.g_number)
114: ) THEN
115: l_argument := 'form_tab_page_id';
116: RAISE l_error;
117: END IF;

Line 119: IF (nvl(p_rec.form_canvas_id,hr_api.g_number) <>

115: l_argument := 'form_tab_page_id';
116: RAISE l_error;
117: END IF;
118: --
119: IF (nvl(p_rec.form_canvas_id,hr_api.g_number) <>
120: nvl(hr_fsc_shd.g_old_rec.form_canvas_id,hr_api.g_number)
121: ) THEN
122: l_argument := 'form_canvas_id';
123: RAISE l_error;

Line 120: nvl(hr_fsc_shd.g_old_rec.form_canvas_id,hr_api.g_number)

116: RAISE l_error;
117: END IF;
118: --
119: IF (nvl(p_rec.form_canvas_id,hr_api.g_number) <>
120: nvl(hr_fsc_shd.g_old_rec.form_canvas_id,hr_api.g_number)
121: ) THEN
122: l_argument := 'form_canvas_id';
123: RAISE l_error;
124: END IF;

Line 128: hr_api.argument_changed_error

124: END IF;
125: --
126: EXCEPTION
127: WHEN l_error THEN
128: hr_api.argument_changed_error
129: (p_api_name => l_proc
130: ,p_argument => l_argument);
131: WHEN OTHERS THEN
132: RAISE;

Line 152: hr_api.mandatory_arg_error

148: hr_utility.set_location('Entering:'||l_proc, 10);
149: --
150: -- Check value has been passed
151: --
152: hr_api.mandatory_arg_error
153: (p_api_name => l_proc
154: ,p_argument => 'form_tab_page_id'
155: ,p_argument_value => p_form_tab_page_id
156: );

Line 178: hr_api.mandatory_arg_error

174: hr_utility.set_location('Entering:'||l_proc, 10);
175: --
176: -- Check value has been passed
177: --
178: hr_api.mandatory_arg_error
179: (p_api_name => l_proc
180: ,p_argument => 'form_canvas_id'
181: ,p_argument_value => p_form_canvas_id
182: );

Line 228: and ( nvl(hr_fsc_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>

224: --
225: -- Only proceed with SQL validation if absolutely necessary
226: --
227: if ( ( l_api_updating
228: and ( nvl(hr_fsc_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>
229: nvl(p_form_tab_page_id,hr_api.g_number)
230: or nvl(hr_fsc_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
231: nvl(p_form_canvas_id,hr_api.g_number)))
232: or (NOT l_api_updating)) then

Line 229: nvl(p_form_tab_page_id,hr_api.g_number)

225: -- Only proceed with SQL validation if absolutely necessary
226: --
227: if ( ( l_api_updating
228: and ( nvl(hr_fsc_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>
229: nvl(p_form_tab_page_id,hr_api.g_number)
230: or nvl(hr_fsc_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
231: nvl(p_form_canvas_id,hr_api.g_number)))
232: or (NOT l_api_updating)) then
233: --

Line 230: or nvl(hr_fsc_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>

226: --
227: if ( ( l_api_updating
228: and ( nvl(hr_fsc_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>
229: nvl(p_form_tab_page_id,hr_api.g_number)
230: or nvl(hr_fsc_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
231: nvl(p_form_canvas_id,hr_api.g_number)))
232: or (NOT l_api_updating)) then
233: --
234: hr_utility.set_location(l_proc,30);

Line 231: nvl(p_form_canvas_id,hr_api.g_number)))

227: if ( ( l_api_updating
228: and ( nvl(hr_fsc_shd.g_old_rec.form_tab_page_id,hr_api.g_number) <>
229: nvl(p_form_tab_page_id,hr_api.g_number)
230: or nvl(hr_fsc_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
231: nvl(p_form_canvas_id,hr_api.g_number)))
232: or (NOT l_api_updating)) then
233: --
234: hr_utility.set_location(l_proc,30);
235: --

Line 264: if nvl(l_canvas_type,hr_api.g_varchar2) <> 'TAB_STACKED' then

260: hr_utility.set_location(l_proc,50);
261: --
262: -- Check the canvas is of type TAB_STACKED
263: --
264: if nvl(l_canvas_type,hr_api.g_varchar2) <> 'TAB_STACKED' then
265: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
266: fnd_message.set_token('PROCEDURE', l_proc);
267: fnd_message.set_token('STEP','30');
268: fnd_message.raise_error;

Line 275: if nvl(l_tab_page_window_id,hr_api.g_number) <>

271: hr_utility.set_location(l_proc,60);
272: --
273: -- Check the tab page and canvas reference the same window
274: --
275: if nvl(l_tab_page_window_id,hr_api.g_number) <>
276: nvl(l_canvas_window_id,hr_api.g_number) then
277: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
278: fnd_message.set_token('PROCEDURE', l_proc);
279: fnd_message.set_token('STEP','40');

Line 276: nvl(l_canvas_window_id,hr_api.g_number) then

272: --
273: -- Check the tab page and canvas reference the same window
274: --
275: if nvl(l_tab_page_window_id,hr_api.g_number) <>
276: nvl(l_canvas_window_id,hr_api.g_number) then
277: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
278: fnd_message.set_token('PROCEDURE', l_proc);
279: fnd_message.set_token('STEP','40');
280: fnd_message.raise_error;