DBA Data[Home] [Help]

APPS.HR_FCN_BUS dependencies on HR_API

Line 113: IF (nvl(p_rec.form_window_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_window_id,hr_api.g_number) <>
114: nvl(hr_fcn_shd.g_old_rec.form_window_id,hr_api.g_number)
115: ) THEN
116: l_argument := 'form_window_id';
117: RAISE l_error;

Line 114: nvl(hr_fcn_shd.g_old_rec.form_window_id,hr_api.g_number)

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

Line 120: IF (nvl(p_rec.canvas_type,hr_api.g_varchar2) <>

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

Line 121: nvl(hr_fcn_shd.g_old_rec.canvas_type,hr_api.g_varchar2)

117: RAISE l_error;
118: END IF;
119: --
120: IF (nvl(p_rec.canvas_type,hr_api.g_varchar2) <>
121: nvl(hr_fcn_shd.g_old_rec.canvas_type,hr_api.g_varchar2)
122: ) THEN
123: l_argument := 'canvas_type';
124: RAISE l_error;
125: END IF;

Line 129: hr_api.argument_changed_error

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

Line 154: hr_api.mandatory_arg_error

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

Line 181: hr_api.mandatory_arg_error

177: hr_utility.set_location('Entering:'||l_proc, 10);
178: --
179: -- Check value has been passed
180: --
181: hr_api.mandatory_arg_error
182: (p_api_name => l_proc
183: ,p_argument => 'canvas_name'
184: ,p_argument_value => p_canvas_name
185: );

Line 217: hr_api.mandatory_arg_error

213: hr_utility.set_location('Entering:'||l_proc, 10);
214: --
215: -- Check mandatory arguments have been set
216: --
217: hr_api.mandatory_arg_error
218: (p_api_name => l_proc
219: ,p_argument => 'effective_date'
220: ,p_argument_value => p_effective_date
221: );

Line 232: and nvl(hr_fcn_shd.g_old_rec.canvas_type,hr_api.g_varchar2) <>

228: --
229: -- Only proceed with SQL validation if absolutely necessary
230: --
231: if ( ( l_api_updating
232: and nvl(hr_fcn_shd.g_old_rec.canvas_type,hr_api.g_varchar2) <>
233: nvl(p_canvas_type,hr_api.g_varchar2))
234: or (NOT l_api_updating)) then
235: --
236: hr_utility.set_location(l_proc,30);

Line 233: nvl(p_canvas_type,hr_api.g_varchar2))

229: -- Only proceed with SQL validation if absolutely necessary
230: --
231: if ( ( l_api_updating
232: and nvl(hr_fcn_shd.g_old_rec.canvas_type,hr_api.g_varchar2) <>
233: nvl(p_canvas_type,hr_api.g_varchar2))
234: or (NOT l_api_updating)) then
235: --
236: hr_utility.set_location(l_proc,30);
237: --

Line 240: hr_api.mandatory_arg_error

236: hr_utility.set_location(l_proc,30);
237: --
238: -- Check value has been passed
239: --
240: hr_api.mandatory_arg_error
241: (p_api_name => l_proc
242: ,p_argument => 'canvas_type'
243: ,p_argument_value => p_canvas_type
244: );

Line 250: if hr_api.not_exists_in_hrstanlookups

246: hr_utility.set_location(l_proc,40);
247: --
248: -- Must exist in hr_standard_lookups where lookup_type is CANVAS_TYPES
249: --
250: if hr_api.not_exists_in_hrstanlookups
251: (p_effective_date => p_effective_date
252: ,p_lookup_type => 'CANVAS_TYPES'
253: ,p_lookup_code => p_canvas_type
254: ) then

Line 300: hr_api.mandatory_arg_error

296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: -- Check mandatory arguments have been set
299: --
300: hr_api.mandatory_arg_error
301: (p_api_name => l_proc
302: ,p_argument => 'effective_date'
303: ,p_argument_value => p_effective_date
304: );

Line 348: hr_api.mandatory_arg_error

344: hr_utility.set_location('Entering:'||l_proc, 5);
345: --
346: -- Check mandatory arguments have been set
347: --
348: hr_api.mandatory_arg_error
349: (p_api_name => l_proc
350: ,p_argument => 'effective_date'
351: ,p_argument_value => p_effective_date
352: );