DBA Data[Home] [Help]

APPS.PAY_EVQ_BUS dependencies on HR_API

Line 45: hr_api.mandatory_arg_error

41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error
46: (p_api_name => l_proc
47: ,p_argument => 'event_qualifier_id'
48: ,p_argument_value => p_event_qualifier_id
49: );

Line 71: hr_api.set_security_group_id

67: close csr_sec_grp;
68: --
69: -- Set the security_group_id in CLIENT_INFO
70: --
71: hr_api.set_security_group_id
72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --

Line 109: hr_api.mandatory_arg_error

105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error
110: (p_api_name => l_proc
111: ,p_argument => 'event_qualifier_id'
112: ,p_argument_value => p_event_qualifier_id
113: );

Line 115: if ( nvl(pay_evq_bus.g_event_qualifier_id, hr_api.g_number)

111: ,p_argument => 'event_qualifier_id'
112: ,p_argument_value => p_event_qualifier_id
113: );
114: --
115: if ( nvl(pay_evq_bus.g_event_qualifier_id, hr_api.g_number)
116: = p_event_qualifier_id) then
117: --
118: -- The legislation code has already been found with a previous
119: -- call to this function. Just return the value in the global

Line 209: if (nvl(p_rec.event_qualifier_id, hr_api.g_number) <>

205: --
206: -- Checks to ensure non-updateable args havent been updated.
207: --
208: --
209: if (nvl(p_rec.event_qualifier_id, hr_api.g_number) <>
210: nvl(pay_evq_shd.g_old_rec.event_qualifier_id, hr_api.g_number)
211: ) then
212: l_argument := 'event_qualifier_id';
213: raise l_error;

Line 210: nvl(pay_evq_shd.g_old_rec.event_qualifier_id, hr_api.g_number)

206: -- Checks to ensure non-updateable args havent been updated.
207: --
208: --
209: if (nvl(p_rec.event_qualifier_id, hr_api.g_number) <>
210: nvl(pay_evq_shd.g_old_rec.event_qualifier_id, hr_api.g_number)
211: ) then
212: l_argument := 'event_qualifier_id';
213: raise l_error;
214: END IF;

Line 216: if (nvl(p_rec.dated_table_id, hr_api.g_number) <>

212: l_argument := 'event_qualifier_id';
213: raise l_error;
214: END IF;
215: --
216: if (nvl(p_rec.dated_table_id, hr_api.g_number) <>
217: nvl(pay_evq_shd.g_old_rec.dated_table_id,hr_api.g_number)
218: ) then
219: l_argument := 'dated_table_id';
220: raise l_error;

Line 217: nvl(pay_evq_shd.g_old_rec.dated_table_id,hr_api.g_number)

213: raise l_error;
214: END IF;
215: --
216: if (nvl(p_rec.dated_table_id, hr_api.g_number) <>
217: nvl(pay_evq_shd.g_old_rec.dated_table_id,hr_api.g_number)
218: ) then
219: l_argument := 'dated_table_id';
220: raise l_error;
221: END IF;

Line 223: if (nvl(p_rec.column_name, hr_api.g_varchar2) <>

219: l_argument := 'dated_table_id';
220: raise l_error;
221: END IF;
222: --
223: if (nvl(p_rec.column_name, hr_api.g_varchar2) <>
224: nvl(pay_evq_shd.g_old_rec.column_name,hr_api.g_varchar2)
225: ) then
226: l_argument := 'column_name';
227: raise l_error;

Line 224: nvl(pay_evq_shd.g_old_rec.column_name,hr_api.g_varchar2)

220: raise l_error;
221: END IF;
222: --
223: if (nvl(p_rec.column_name, hr_api.g_varchar2) <>
224: nvl(pay_evq_shd.g_old_rec.column_name,hr_api.g_varchar2)
225: ) then
226: l_argument := 'column_name';
227: raise l_error;
228: END IF;

Line 230: if (nvl(p_rec.qualifier_name, hr_api.g_varchar2) <>

226: l_argument := 'column_name';
227: raise l_error;
228: END IF;
229: --
230: if (nvl(p_rec.qualifier_name, hr_api.g_varchar2) <>
231: nvl(pay_evq_shd.g_old_rec.qualifier_name,hr_api.g_varchar2)
232: ) then
233: l_argument := 'qualifier_name';
234: raise l_error;

Line 231: nvl(pay_evq_shd.g_old_rec.qualifier_name,hr_api.g_varchar2)

227: raise l_error;
228: END IF;
229: --
230: if (nvl(p_rec.qualifier_name, hr_api.g_varchar2) <>
231: nvl(pay_evq_shd.g_old_rec.qualifier_name,hr_api.g_varchar2)
232: ) then
233: l_argument := 'qualifier_name';
234: raise l_error;
235: END IF;

Line 237: if (nvl(p_rec.legislation_code, hr_api.g_varchar2) <>

233: l_argument := 'qualifier_name';
234: raise l_error;
235: END IF;
236: --
237: if (nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
238: nvl(pay_evq_shd.g_old_rec.legislation_code,hr_api.g_varchar2)
239: ) then
240: l_argument := 'legislation_code';
241: raise l_error;

Line 238: nvl(pay_evq_shd.g_old_rec.legislation_code,hr_api.g_varchar2)

234: raise l_error;
235: END IF;
236: --
237: if (nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
238: nvl(pay_evq_shd.g_old_rec.legislation_code,hr_api.g_varchar2)
239: ) then
240: l_argument := 'legislation_code';
241: raise l_error;
242: END IF;

Line 244: if (nvl(p_rec.business_group_id, hr_api.g_number) <>

240: l_argument := 'legislation_code';
241: raise l_error;
242: END IF;
243: --
244: if (nvl(p_rec.business_group_id, hr_api.g_number) <>
245: nvl(pay_evq_shd.g_old_rec.business_group_id,hr_api.g_number)
246: ) then
247: l_argument := 'business_group_id';
248: raise l_error;

Line 245: nvl(pay_evq_shd.g_old_rec.business_group_id,hr_api.g_number)

241: raise l_error;
242: END IF;
243: --
244: if (nvl(p_rec.business_group_id, hr_api.g_number) <>
245: nvl(pay_evq_shd.g_old_rec.business_group_id,hr_api.g_number)
246: ) then
247: l_argument := 'business_group_id';
248: raise l_error;
249: END IF;

Line 253: hr_api.argument_changed_error

249: END IF;
250: --
251: EXCEPTION
252: WHEN l_error THEN
253: hr_api.argument_changed_error
254: (p_api_name => l_proc
255: ,p_argument => l_argument);
256: WHEN OTHERS THEN
257: RAISE;

Line 302: hr_api.mandatory_arg_error

298: Begin
299: --
300: -- Ensure that the p_datetrack_mode argument is not null
301: --
302: hr_api.mandatory_arg_error
303: (p_api_name => l_proc
304: ,p_argument => 'datetrack_mode'
305: ,p_argument_value => p_datetrack_mode
306: );

Line 312: hr_api.mandatory_arg_error

308: -- Mode will be valid, as this is checked at the start of the upd.
309: --
310: -- Ensure the arguments are not null
311: --
312: hr_api.mandatory_arg_error
313: (p_api_name => l_proc
314: ,p_argument => 'validation_start_date'
315: ,p_argument_value => p_validation_start_date
316: );

Line 318: hr_api.mandatory_arg_error

314: ,p_argument => 'validation_start_date'
315: ,p_argument_value => p_validation_start_date
316: );
317: --
318: hr_api.mandatory_arg_error
319: (p_api_name => l_proc
320: ,p_argument => 'validation_end_date'
321: ,p_argument_value => p_validation_end_date
322: );

Line 386: hr_api.mandatory_arg_error

382: Begin
383: --
384: -- Ensure that the p_datetrack_mode argument is not null
385: --
386: hr_api.mandatory_arg_error
387: (p_api_name => l_proc
388: ,p_argument => 'datetrack_mode'
389: ,p_argument_value => p_datetrack_mode
390: );

Line 395: If (p_datetrack_mode = hr_api.g_delete or

391: --
392: -- Only perform the validation if the datetrack mode is either
393: -- DELETE or ZAP
394: --
395: If (p_datetrack_mode = hr_api.g_delete or
396: p_datetrack_mode = hr_api.g_zap) then
397: --
398: --
399: -- Ensure the arguments are not null

Line 396: p_datetrack_mode = hr_api.g_zap) then

392: -- Only perform the validation if the datetrack mode is either
393: -- DELETE or ZAP
394: --
395: If (p_datetrack_mode = hr_api.g_delete or
396: p_datetrack_mode = hr_api.g_zap) then
397: --
398: --
399: -- Ensure the arguments are not null
400: --

Line 401: hr_api.mandatory_arg_error

397: --
398: --
399: -- Ensure the arguments are not null
400: --
401: hr_api.mandatory_arg_error
402: (p_api_name => l_proc
403: ,p_argument => 'validation_start_date'
404: ,p_argument_value => p_validation_start_date
405: );

Line 407: hr_api.mandatory_arg_error

403: ,p_argument => 'validation_start_date'
404: ,p_argument_value => p_validation_start_date
405: );
406: --
407: hr_api.mandatory_arg_error
408: (p_api_name => l_proc
409: ,p_argument => 'validation_end_date'
410: ,p_argument_value => p_validation_end_date
411: );

Line 413: hr_api.mandatory_arg_error

409: ,p_argument => 'validation_end_date'
410: ,p_argument_value => p_validation_end_date
411: );
412: --
413: hr_api.mandatory_arg_error
414: (p_api_name => l_proc
415: ,p_argument => 'event_qualifier_id'
416: ,p_argument_value => p_event_qualifier_id
417: );

Line 530: hr_api.mandatory_arg_error

526: Begin
527: --
528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: hr_api.mandatory_arg_error
531: (p_api_name => l_proc
532: ,p_argument => 'dated_table_id'
533: ,p_argument_value => p_rec.dated_table_id
534: );

Line 584: hr_api.validate_bus_grp_id

580: NOT IN ('GENERIC','STARTUP') THEN
581: --
582: -- Validate Important Attributes
583: --
584: hr_api.validate_bus_grp_id
585: (p_business_group_id => p_rec.business_group_id
586: ,p_associated_column1 => pay_evq_shd.g_tab_name
587: || '.BUSINESS_GROUP_ID');
588: end if;

Line 639: hr_api.validate_bus_grp_id

635: NOT IN ('GENERIC','STARTUP') THEN
636: --
637: -- Validate Important Attributes
638: --
639: hr_api.validate_bus_grp_id
640: (p_business_group_id => p_rec.business_group_id
641: ,p_associated_column1 => pay_evq_shd.g_tab_name
642: || '.BUSINESS_GROUP_ID');
643: --