DBA Data[Home] [Help]

APPS.PAY_FRR_BUS dependencies on HR_API

Line 51: hr_api.mandatory_arg_error

47: hr_utility.set_location('Entering:'|| l_proc, 10);
48: --
49: -- Ensure that all the mandatory parameter are not null
50: --
51: hr_api.mandatory_arg_error
52: (p_api_name => l_proc
53: ,p_argument => 'formula_result_rule_id'
54: ,p_argument_value => p_formula_result_rule_id
55: );

Line 78: hr_api.set_security_group_id

74: close csr_sec_grp;
75: --
76: -- Set the security_group_id in CLIENT_INFO
77: --
78: hr_api.set_security_group_id
79: (p_security_group_id => l_security_group_id
80: );
81: --
82: -- Set the sessions legislation context in HR_SESSION_DATA

Line 84: hr_api.set_legislation_context(l_legislation_code);

80: );
81: --
82: -- Set the sessions legislation context in HR_SESSION_DATA
83: --
84: hr_api.set_legislation_context(l_legislation_code);
85: end if;
86: --
87: hr_utility.set_location(' Leaving:'|| l_proc, 20);
88: --

Line 120: hr_api.mandatory_arg_error

116: hr_utility.set_location('Entering:'|| l_proc, 10);
117: --
118: -- Ensure that all the mandatory parameter are not null
119: --
120: hr_api.mandatory_arg_error
121: (p_api_name => l_proc
122: ,p_argument => 'formula_result_rule_id'
123: ,p_argument_value => p_formula_result_rule_id
124: );

Line 126: if ( nvl(pay_frr_bus.g_formula_result_rule_id, hr_api.g_number)

122: ,p_argument => 'formula_result_rule_id'
123: ,p_argument_value => p_formula_result_rule_id
124: );
125: --
126: if ( nvl(pay_frr_bus.g_formula_result_rule_id, hr_api.g_number)
127: = p_formula_result_rule_id) then
128: --
129: -- The legislation code has already been found with a previous
130: -- call to this function. Just return the value in the global

Line 218: If nvl(p_rec.business_group_id,hr_api.g_number) <>

214: END IF;
215: --
216: -- Ensure that the following attributes are not updated.
217: --
218: If nvl(p_rec.business_group_id,hr_api.g_number) <>
219: nvl(pay_frr_shd.g_old_rec.business_group_id,hr_api.g_number) then
220: --
221: l_argument := 'business_group_id';
222: raise l_error;

Line 219: nvl(pay_frr_shd.g_old_rec.business_group_id,hr_api.g_number) then

215: --
216: -- Ensure that the following attributes are not updated.
217: --
218: If nvl(p_rec.business_group_id,hr_api.g_number) <>
219: nvl(pay_frr_shd.g_old_rec.business_group_id,hr_api.g_number) then
220: --
221: l_argument := 'business_group_id';
222: raise l_error;
223: --

Line 226: If nvl(p_rec.legislation_code,hr_api.g_varchar2) <>

222: raise l_error;
223: --
224: End if;
225: --
226: If nvl(p_rec.legislation_code,hr_api.g_varchar2) <>
227: nvl(pay_frr_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then
228: --
229: l_argument := 'legislation_code';
230: raise l_error;

Line 227: nvl(pay_frr_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then

223: --
224: End if;
225: --
226: If nvl(p_rec.legislation_code,hr_api.g_varchar2) <>
227: nvl(pay_frr_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then
228: --
229: l_argument := 'legislation_code';
230: raise l_error;
231: --

Line 234: If nvl(p_rec.status_processing_rule_id,hr_api.g_number) <>

230: raise l_error;
231: --
232: End if;
233: --
234: If nvl(p_rec.status_processing_rule_id,hr_api.g_number) <>
235: nvl(pay_frr_shd.g_old_rec.status_processing_rule_id,hr_api.g_number) then
236: --
237: l_argument := 'status_processing_rule_id';
238: raise l_error;

Line 235: nvl(pay_frr_shd.g_old_rec.status_processing_rule_id,hr_api.g_number) then

231: --
232: End if;
233: --
234: If nvl(p_rec.status_processing_rule_id,hr_api.g_number) <>
235: nvl(pay_frr_shd.g_old_rec.status_processing_rule_id,hr_api.g_number) then
236: --
237: l_argument := 'status_processing_rule_id';
238: raise l_error;
239: --

Line 242: If nvl(p_rec.result_name,hr_api.g_varchar2) <>

238: raise l_error;
239: --
240: End if;
241: --
242: If nvl(p_rec.result_name,hr_api.g_varchar2) <>
243: nvl(pay_frr_shd.g_old_rec.result_name,hr_api.g_varchar2) then
244: --
245: l_argument := 'result_name';
246: raise l_error;

Line 243: nvl(pay_frr_shd.g_old_rec.result_name,hr_api.g_varchar2) then

239: --
240: End if;
241: --
242: If nvl(p_rec.result_name,hr_api.g_varchar2) <>
243: nvl(pay_frr_shd.g_old_rec.result_name,hr_api.g_varchar2) then
244: --
245: l_argument := 'result_name';
246: raise l_error;
247: --

Line 250: If nvl(p_rec.legislation_subgroup,hr_api.g_varchar2) <>

246: raise l_error;
247: --
248: End if;
249: --
250: If nvl(p_rec.legislation_subgroup,hr_api.g_varchar2) <>
251: nvl(pay_frr_shd.g_old_rec.legislation_subgroup,hr_api.g_varchar2) then
252: --
253: l_argument := 'legislation_subgroup';
254: raise l_error;

Line 251: nvl(pay_frr_shd.g_old_rec.legislation_subgroup,hr_api.g_varchar2) then

247: --
248: End if;
249: --
250: If nvl(p_rec.legislation_subgroup,hr_api.g_varchar2) <>
251: nvl(pay_frr_shd.g_old_rec.legislation_subgroup,hr_api.g_varchar2) then
252: --
253: l_argument := 'legislation_subgroup';
254: raise l_error;
255: --

Line 260: hr_api.argument_changed_error

256: End if;
257: --
258: EXCEPTION
259: WHEN l_error THEN
260: hr_api.argument_changed_error
261: (p_api_name => l_proc
262: ,p_argument => l_argument);
263: WHEN OTHERS THEN
264: RAISE;

Line 308: hr_api.mandatory_arg_error

304: Begin
305: --
306: -- Ensure that the p_datetrack_mode argument is not null
307: --
308: hr_api.mandatory_arg_error
309: (p_api_name => l_proc
310: ,p_argument => 'datetrack_mode'
311: ,p_argument_value => p_datetrack_mode
312: );

Line 318: hr_api.mandatory_arg_error

314: -- Mode will be valid, as this is checked at the start of the upd.
315: --
316: -- Ensure the arguments are not null
317: --
318: hr_api.mandatory_arg_error
319: (p_api_name => l_proc
320: ,p_argument => 'validation_start_date'
321: ,p_argument_value => p_validation_start_date
322: );

Line 324: hr_api.mandatory_arg_error

320: ,p_argument => 'validation_start_date'
321: ,p_argument_value => p_validation_start_date
322: );
323: --
324: hr_api.mandatory_arg_error
325: (p_api_name => l_proc
326: ,p_argument => 'validation_end_date'
327: ,p_argument_value => p_validation_end_date
328: );

Line 392: hr_api.mandatory_arg_error

388: Begin
389: --
390: -- Ensure that the p_datetrack_mode argument is not null
391: --
392: hr_api.mandatory_arg_error
393: (p_api_name => l_proc
394: ,p_argument => 'datetrack_mode'
395: ,p_argument_value => p_datetrack_mode
396: );

Line 401: If (p_datetrack_mode = hr_api.g_delete or

397: --
398: -- Only perform the validation if the datetrack mode is either
399: -- DELETE or ZAP
400: --
401: If (p_datetrack_mode = hr_api.g_delete or
402: p_datetrack_mode = hr_api.g_zap) then
403: --
404: --
405: -- Ensure the arguments are not null

Line 402: p_datetrack_mode = hr_api.g_zap) then

398: -- Only perform the validation if the datetrack mode is either
399: -- DELETE or ZAP
400: --
401: If (p_datetrack_mode = hr_api.g_delete or
402: p_datetrack_mode = hr_api.g_zap) then
403: --
404: --
405: -- Ensure the arguments are not null
406: --

Line 407: hr_api.mandatory_arg_error

403: --
404: --
405: -- Ensure the arguments are not null
406: --
407: hr_api.mandatory_arg_error
408: (p_api_name => l_proc
409: ,p_argument => 'validation_start_date'
410: ,p_argument_value => p_validation_start_date
411: );

Line 413: hr_api.mandatory_arg_error

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

Line 419: hr_api.mandatory_arg_error

415: ,p_argument => 'validation_end_date'
416: ,p_argument_value => p_validation_end_date
417: );
418: --
419: hr_api.mandatory_arg_error
420: (p_api_name => l_proc
421: ,p_argument => 'formula_result_rule_id'
422: ,p_argument_value => p_formula_result_rule_id
423: );

Line 516: hr_api.return_legislation_code(p_business_group_id))

512: and ((p_business_group_id is not null and
513: ((pet.business_group_id = p_business_group_id)
514: or
515: (pet.legislation_code =
516: hr_api.return_legislation_code(p_business_group_id))
517: ))
518: --
519: or
520: (p_legislation_code is not null

Line 570: hr_api.return_legislation_code(p_business_group_id))

566: and ((p_business_group_id is not null and
567: ((spr.business_group_id = p_business_group_id)
568: or
569: (spr.legislation_code =
570: hr_api.return_legislation_code(p_business_group_id))
571: ))
572: --
573: or
574: (p_legislation_code is not null and

Line 783: If hr_api.not_exists_in_hr_lookups

779:
780: Begin
781: hr_utility.set_location('Entering:'||l_proc, 5);
782: --
783: If hr_api.not_exists_in_hr_lookups
784: (p_effective_date
785: ,'RESULT_RULE_TYPE'
786: ,p_result_rule_type) Then
787: --

Line 918: If hr_api.not_exists_in_hr_lookups

914: --
915: Begin
916: hr_utility.set_location('Entering:'||l_proc, 5);
917: --
918: If hr_api.not_exists_in_hr_lookups
919: (p_effective_date
920: ,'FORMULA_RESULT_MESSAGE_LEVEL'
921: ,p_severity_level) Then
922: --

Line 1256: or (p_datetrack_mode = hr_api.g_delete_next_change) then

1252: --
1253: hr_utility.set_location('before set-p_validation_end_date '||to_char(p_validation_end_date),9);
1254: --
1255: if (p_result_rule_type in ('I','U','S'))
1256: or (p_datetrack_mode = hr_api.g_delete_next_change) then
1257: p_validation_end_date := least (l_max_end_date_of_element
1258: ,l_max_spr_end_date
1259: ,l_max_end_date_of_target
1260: ,l_future_rule_end_date);

Line 1341: hr_api.validate_bus_grp_id

1337: NOT IN ('GENERIC','STARTUP') THEN
1338: --
1339: -- Validate Important Attributes
1340: --
1341: hr_api.validate_bus_grp_id
1342: (p_business_group_id => p_rec.business_group_id
1343: ,p_associated_column1 => pay_frr_shd.g_tab_nam
1344: || '.BUSINESS_GROUP_ID');
1345: --

Line 1451: hr_api.validate_bus_grp_id

1447: NOT IN ('GENERIC','STARTUP') THEN
1448: --
1449: -- Validate Important Attributes
1450: --
1451: hr_api.validate_bus_grp_id
1452: (p_business_group_id => p_rec.business_group_id
1453: ,p_associated_column1 => pay_frr_shd.g_tab_nam
1454: || '.BUSINESS_GROUP_ID');
1455: --