APPS.HR_FTP_BUS dependencies on HR_API

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

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

Line 114: nvl(hr_ftp_shd.g_old_rec.form_canvas_id,hr_api.g_number)

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

Line 122: hr_api.argument_changed_error

118: END IF;
119: --
120: EXCEPTION
121: WHEN l_error THEN
122: hr_api.argument_changed_error
123: (p_api_name => l_proc
124: ,p_argument => l_argument);
125: WHEN OTHERS THEN
126: RAISE;

Line 160: and nvl(hr_ftp_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>

156: --
157: -- Only proceed with SQL validation if absolutely necessary
158: --
159: if ( ( l_api_updating
160: and nvl(hr_ftp_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
161: nvl(p_form_canvas_id,hr_api.g_number))
162: or (NOT l_api_updating)) then
163: --
164: hr_utility.set_location(l_proc,30);

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

157: -- Only proceed with SQL validation if absolutely necessary
158: --
159: if ( ( l_api_updating
160: and nvl(hr_ftp_shd.g_old_rec.form_canvas_id,hr_api.g_number) <>
161: nvl(p_form_canvas_id,hr_api.g_number))
162: or (NOT l_api_updating)) then
163: --
164: hr_utility.set_location(l_proc,30);
165: --

Line 168: hr_api.mandatory_arg_error

164: hr_utility.set_location(l_proc,30);
165: --
166: -- Check value has been passed
167: --
168: hr_api.mandatory_arg_error
169: (p_api_name => l_proc
170: ,p_argument => 'form_canvas_id'
171: ,p_argument_value => p_form_canvas_id
172: );

Line 191: if nvl(l_canvas_type,hr_api.g_varchar2) <> 'TAB' then

187: close csr_form_canvas;
188: --
189: hr_utility.set_location(l_proc,50);
190: --
191: if nvl(l_canvas_type,hr_api.g_varchar2) <> 'TAB' then
192: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
193: fnd_message.set_token('PROCEDURE', l_proc);
194: fnd_message.set_token('STEP','20');
195: fnd_message.raise_error;

Line 221: hr_api.mandatory_arg_error

217: hr_utility.set_location('Entering:'||l_proc, 10);
218: --
219: -- Check value has been passed
220: --
221: hr_api.mandatory_arg_error
222: (p_api_name => l_proc
223: ,p_argument => 'tab_page_name'
224: ,p_argument_value => p_tab_page_name
225: );

Line 257: hr_api.mandatory_arg_error

253: hr_utility.set_location('Entering:'||l_proc, 10);
254: --
255: -- Check value has been passed
256: --
257: hr_api.mandatory_arg_error
258: (p_api_name => l_proc
259: ,p_argument => 'display_order'
260: ,p_argument_value => p_display_order
261: );

Line 293: hr_api.mandatory_arg_error

289: hr_utility.set_location('Entering:'||l_proc, 10);
290: --
291: -- Check mandatory arguments have been set
292: --
293: hr_api.mandatory_arg_error
294: (p_api_name => l_proc
295: ,p_argument => 'effective_date'
296: ,p_argument_value => p_effective_date
297: );

Line 308: and nvl(hr_ftp_shd.g_old_rec.visible_override,hr_api.g_number) <>

304: --
305: -- Only proceed with SQL validation if absolutely necessary
306: --
307: if ( ( l_api_updating
308: and nvl(hr_ftp_shd.g_old_rec.visible_override,hr_api.g_number) <>
309: nvl(p_visible_override,hr_api.g_number))
310: or (NOT l_api_updating)) then
311: --
312: hr_utility.set_location(l_proc,30);

Line 309: nvl(p_visible_override,hr_api.g_number))

305: -- Only proceed with SQL validation if absolutely necessary
306: --
307: if ( ( l_api_updating
308: and nvl(hr_ftp_shd.g_old_rec.visible_override,hr_api.g_number) <>
309: nvl(p_visible_override,hr_api.g_number))
310: or (NOT l_api_updating)) then
311: --
312: hr_utility.set_location(l_proc,30);
313: --

Line 321: if hr_api.not_exists_in_hrstanlookups

317: --
318: -- Must exist in hr_standard_lookups where lookup_type is
319: -- PROPERTY_TRUE_OR_FALSE
320: --
321: if hr_api.not_exists_in_hrstanlookups
322: (p_effective_date => p_effective_date
323: ,p_lookup_type => 'PROPERTY_TRUE_OR_FALSE'
324: ,p_lookup_code => p_visible_override
325: ) then