eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CEI_BUS dependencies on HR_API

Line 44: hr_api.mandatory_arg_error

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

Line 67: hr_api.set_security_group_id

63: close csr_sec_grp;
64: --
65: -- Set the security_group_id in CLIENT_INFO
66: --
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 104: hr_api.mandatory_arg_error

100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error
105: (p_api_name => l_proc
106: ,p_argument => 'cagr_entitlement_item_id'
107: ,p_argument_value => p_cagr_entitlement_item_id
108: );

Line 110: if ( nvl(per_cei_bus.g_cagr_entitlement_item_id, hr_api.g_number)

106: ,p_argument => 'cagr_entitlement_item_id'
107: ,p_argument_value => p_cagr_entitlement_item_id
108: );
109: --
110: if ( nvl(per_cei_bus.g_cagr_entitlement_item_id, hr_api.g_number)
111: = p_cagr_entitlement_item_id) then
112: --
113: -- The legislation code has already been found with a previous
114: -- 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: hr_utility.set_location(l_proc, 10);
217: --
218: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
219: nvl(per_cei_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(per_cei_shd.g_old_rec.business_group_id,hr_api.g_number) THEN

215: --
216: hr_utility.set_location(l_proc, 10);
217: --
218: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
219: nvl(per_cei_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 228: IF nvl(p_rec.legislation_code, hr_api.g_varchar2) <>

224: END IF;
225: --
226: hr_utility.set_location(l_proc, 20);
227: --
228: IF nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
229: nvl(per_cei_shd.g_old_rec.legislation_code,hr_api.g_varchar2) THEN
230: --
231: l_argument := 'legislation_code';
232: RAISE l_error;

Line 229: nvl(per_cei_shd.g_old_rec.legislation_code,hr_api.g_varchar2) THEN

225: --
226: hr_utility.set_location(l_proc, 20);
227: --
228: IF nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
229: nvl(per_cei_shd.g_old_rec.legislation_code,hr_api.g_varchar2) THEN
230: --
231: l_argument := 'legislation_code';
232: RAISE l_error;
233: --

Line 253: IF nvl(p_rec.mult_entries_allowed_flag , hr_api.g_varchar2) <>

249: -- should an error should be raised.
250: --
251: IF l_item_in_use THEN
252: --
253: IF nvl(p_rec.mult_entries_allowed_flag , hr_api.g_varchar2) <>
254: nvl(per_cei_shd.g_old_rec.mult_entries_allowed_flag,hr_api.g_varchar2) THEN
255: --
256: l_argument := 'mult_entries_allowed_flag';
257: RAISE l_error;

Line 254: nvl(per_cei_shd.g_old_rec.mult_entries_allowed_flag,hr_api.g_varchar2) THEN

250: --
251: IF l_item_in_use THEN
252: --
253: IF nvl(p_rec.mult_entries_allowed_flag , hr_api.g_varchar2) <>
254: nvl(per_cei_shd.g_old_rec.mult_entries_allowed_flag,hr_api.g_varchar2) THEN
255: --
256: l_argument := 'mult_entries_allowed_flag';
257: RAISE l_error;
258: --

Line 263: IF nvl(p_rec.column_type, hr_api.g_varchar2) <>

259: END IF;
260: --
261: hr_utility.set_location(l_proc||'/'||p_rec.column_type||'/', 50);
262: --
263: IF nvl(p_rec.column_type, hr_api.g_varchar2) <>
264: nvl(per_cei_shd.g_old_rec.column_type,hr_api.g_varchar2) THEN
265: --
266: l_argument := 'column_type';
267: RAISE l_error;

Line 264: nvl(per_cei_shd.g_old_rec.column_type,hr_api.g_varchar2) THEN

260: --
261: hr_utility.set_location(l_proc||'/'||p_rec.column_type||'/', 50);
262: --
263: IF nvl(p_rec.column_type, hr_api.g_varchar2) <>
264: nvl(per_cei_shd.g_old_rec.column_type,hr_api.g_varchar2) THEN
265: --
266: l_argument := 'column_type';
267: RAISE l_error;
268: --

Line 273: IF nvl(p_rec.flex_value_set_id, hr_api.g_number) <>

269: END IF;
270: --
271: hr_utility.set_location(l_proc, 60);
272: --
273: IF nvl(p_rec.flex_value_set_id, hr_api.g_number) <>
274: nvl(per_cei_shd.g_old_rec.flex_value_set_id,hr_api.g_number) THEN
275: --
276: l_argument := 'flex_value_set_id';
277: RAISE l_error;

Line 274: nvl(per_cei_shd.g_old_rec.flex_value_set_id,hr_api.g_number) THEN

270: --
271: hr_utility.set_location(l_proc, 60);
272: --
273: IF nvl(p_rec.flex_value_set_id, hr_api.g_number) <>
274: nvl(per_cei_shd.g_old_rec.flex_value_set_id,hr_api.g_number) THEN
275: --
276: l_argument := 'flex_value_set_id';
277: RAISE l_error;
278: --

Line 283: IF nvl(p_rec.category_name, hr_api.g_varchar2) <>

279: END IF;
280: --
281: hr_utility.set_location(l_proc, 70);
282: --
283: IF nvl(p_rec.category_name, hr_api.g_varchar2) <>
284: nvl(per_cei_shd.g_old_rec.category_name,hr_api.g_varchar2) THEN
285: --
286: l_argument := 'category_name';
287: RAISE l_error;

Line 284: nvl(per_cei_shd.g_old_rec.category_name,hr_api.g_varchar2) THEN

280: --
281: hr_utility.set_location(l_proc, 70);
282: --
283: IF nvl(p_rec.category_name, hr_api.g_varchar2) <>
284: nvl(per_cei_shd.g_old_rec.category_name,hr_api.g_varchar2) THEN
285: --
286: l_argument := 'category_name';
287: RAISE l_error;
288: --

Line 293: IF nvl(p_rec.input_value_id, hr_api.g_number) <>

289: END IF;
290: --
291: hr_utility.set_location(l_proc, 80);
292: --
293: IF nvl(p_rec.input_value_id, hr_api.g_number) <>
294: nvl(per_cei_shd.g_old_rec.input_value_id,hr_api.g_number) THEN
295: --
296: l_argument := 'input_value_id';
297: RAISE l_error;

Line 294: nvl(per_cei_shd.g_old_rec.input_value_id,hr_api.g_number) THEN

290: --
291: hr_utility.set_location(l_proc, 80);
292: --
293: IF nvl(p_rec.input_value_id, hr_api.g_number) <>
294: nvl(per_cei_shd.g_old_rec.input_value_id,hr_api.g_number) THEN
295: --
296: l_argument := 'input_value_id';
297: RAISE l_error;
298: --

Line 303: IF nvl(p_rec.element_type_id, hr_api.g_number) <>

299: END IF;
300: --
301: hr_utility.set_location(l_proc, 90);
302: --
303: IF nvl(p_rec.element_type_id, hr_api.g_number) <>
304: nvl(per_cei_shd.g_old_rec.element_type_id,hr_api.g_number) THEN
305: --
306: l_argument := 'element_type_id';
307: RAISE l_error;

Line 304: nvl(per_cei_shd.g_old_rec.element_type_id,hr_api.g_number) THEN

300: --
301: hr_utility.set_location(l_proc, 90);
302: --
303: IF nvl(p_rec.element_type_id, hr_api.g_number) <>
304: nvl(per_cei_shd.g_old_rec.element_type_id,hr_api.g_number) THEN
305: --
306: l_argument := 'element_type_id';
307: RAISE l_error;
308: --

Line 311: IF nvl(p_rec.cagr_api_id, hr_api.g_number) <>

307: RAISE l_error;
308: --
309: END IF;
310: --
311: IF nvl(p_rec.cagr_api_id, hr_api.g_number) <>
312: nvl(per_cei_shd.g_old_rec.cagr_api_id,hr_api.g_number) THEN
313: --
314: l_argument := 'cagr_api_id';
315: RAISE l_error;

Line 312: nvl(per_cei_shd.g_old_rec.cagr_api_id,hr_api.g_number) THEN

308: --
309: END IF;
310: --
311: IF nvl(p_rec.cagr_api_id, hr_api.g_number) <>
312: nvl(per_cei_shd.g_old_rec.cagr_api_id,hr_api.g_number) THEN
313: --
314: l_argument := 'cagr_api_id';
315: RAISE l_error;
316: --

Line 319: IF nvl(p_rec.cagr_api_param_id, hr_api.g_number) <>

315: RAISE l_error;
316: --
317: END IF;
318: --
319: IF nvl(p_rec.cagr_api_param_id, hr_api.g_number) <>
320: nvl(per_cei_shd.g_old_rec.cagr_api_param_id,hr_api.g_number) THEN
321: --
322: l_argument := 'cagr_api_param_id';
323: RAISE l_error;

Line 320: nvl(per_cei_shd.g_old_rec.cagr_api_param_id,hr_api.g_number) THEN

316: --
317: END IF;
318: --
319: IF nvl(p_rec.cagr_api_param_id, hr_api.g_number) <>
320: nvl(per_cei_shd.g_old_rec.cagr_api_param_id,hr_api.g_number) THEN
321: --
322: l_argument := 'cagr_api_param_id';
323: RAISE l_error;
324: --

Line 333: hr_api.argument_changed_error

329: hr_utility.set_location('Leaving :'||l_proc, 999);
330: --
331: EXCEPTION
332: WHEN l_error THEN
333: hr_api.argument_changed_error
334: (p_api_name => l_proc
335: ,p_argument => l_argument);
336: WHEN OTHERS THEN
337: RAISE;

Line 612: NVL(per_cei_shd.g_old_rec.beneficial_rule,hr_api.g_varchar2) <>

608: -- a) Inserting or
609: -- b) The value for beneficial rule has changed
610: --
611: IF p_beneficial_rule IS NOT NULL OR
612: NVL(per_cei_shd.g_old_rec.beneficial_rule,hr_api.g_varchar2) <>
613: NVL(p_beneficial_rule, hr_api.g_varchar2) THEN
614: --
615: hr_utility.set_location(l_proc, 20);
616: --

Line 613: NVL(p_beneficial_rule, hr_api.g_varchar2) THEN

609: -- b) The value for beneficial rule has changed
610: --
611: IF p_beneficial_rule IS NOT NULL OR
612: NVL(per_cei_shd.g_old_rec.beneficial_rule,hr_api.g_varchar2) <>
613: NVL(p_beneficial_rule, hr_api.g_varchar2) THEN
614: --
615: hr_utility.set_location(l_proc, 20);
616: --
617: -- Check that if a beneficial value set has been entered

Line 630: IF hr_api.not_exists_in_hr_lookups

626: END IF;
627: --
628: -- Check that the category exists in HR_LOOKUPS
629: --
630: IF hr_api.not_exists_in_hr_lookups
631: (p_effective_date => p_effective_date
632: ,p_lookup_type => 'CAGR_BENEFICIAL_RULE'
633: ,p_lookup_code => p_beneficial_rule) THEN
634: --

Line 710: hr_api.mandatory_arg_error

706: hr_utility.set_location('Entering: '||l_proc,10);
707: --
708: -- Check mandatory parameter is set
709: --
710: hr_api.mandatory_arg_error
711: (p_api_name => l_proc
712: ,p_argument => 'effective_date'
713: ,p_argument_value => p_effective_date
714: );

Line 775: IF hr_api.not_exists_in_hr_lookups

771: hr_utility.set_location(l_proc, 60);
772: --
773: -- Check that the category exists in HR_LOOKUPS
774: --
775: IF hr_api.not_exists_in_hr_lookups
776: (p_effective_date => p_effective_date
777: ,p_lookup_type => 'CAGR_PARAM_TYPES'
778: ,p_lookup_code => p_column_type) THEN
779: --

Line 849: hr_api.mandatory_arg_error

845: hr_utility.set_location('Entering: '||l_proc,10);
846: --
847: -- Check mandatory parameter is set
848: --
849: hr_api.mandatory_arg_error
850: (p_api_name => l_proc
851: ,p_argument => 'column_size'
852: ,p_argument_value => p_column_size
853: );

Line 955: (NVL(per_cei_shd.g_old_rec.cagr_api_id, hr_api.g_number) <>

951: -- b) The value for cagr api id has changed
952: --
953: IF ( (p_cagr_entitlement_item_id IS NULL) OR
954: ((p_cagr_entitlement_item_id IS NOT NULL) AND
955: (NVL(per_cei_shd.g_old_rec.cagr_api_id, hr_api.g_number) <>
956: NVL(p_cagr_api_id,hr_api.g_number)))) THEN
957: --
958: hr_utility.set_location(l_proc,20);
959: --

Line 956: NVL(p_cagr_api_id,hr_api.g_number)))) THEN

952: --
953: IF ( (p_cagr_entitlement_item_id IS NULL) OR
954: ((p_cagr_entitlement_item_id IS NOT NULL) AND
955: (NVL(per_cei_shd.g_old_rec.cagr_api_id, hr_api.g_number) <>
956: NVL(p_cagr_api_id,hr_api.g_number)))) THEN
957: --
958: hr_utility.set_location(l_proc,20);
959: --
960: IF p_cagr_api_id IS NOT NULL THEN

Line 1174: hr_api.mandatory_arg_error

1170: hr_utility.set_location('Entering: '||l_proc,10);
1171: --
1172: -- Check mandatory parameter is set
1173: --
1174: hr_api.mandatory_arg_error
1175: (p_api_name => l_proc
1176: ,p_argument => 'category_name'
1177: ,p_argument_value => p_category_name);
1178: --

Line 1191: IF hr_api.not_exists_in_hr_lookups

1187: hr_utility.set_location(l_proc, 20);
1188: --
1189: -- Check that the category exists in HR_LOOKUPS
1190: --
1191: IF hr_api.not_exists_in_hr_lookups
1192: (p_effective_date => p_effective_date
1193: ,p_lookup_type => 'CAGR_CATEGORIES'
1194: ,p_lookup_code => p_category_name) THEN
1195: --

Line 1277: (per_cei_shd.g_old_rec.uom <> NVL(p_uom,hr_api.g_varchar2)))) THEN

1273: -- b) The value for uom has changed
1274: --
1275: IF ( (p_cagr_entitlement_item_id IS NULL) OR
1276: ((p_cagr_entitlement_item_id IS NOT NULL) AND
1277: (per_cei_shd.g_old_rec.uom <> NVL(p_uom,hr_api.g_varchar2)))) THEN
1278: --
1279: hr_utility.set_location(l_proc, 20);
1280: --
1281: -- If the item has been defined as a denormalised payroll item

Line 1312: IF hr_api.not_exists_in_hr_lookups

1308: p_cagr_api_param_id IS NULL THEN
1309: --
1310: hr_utility.set_location(l_proc, 40);
1311: --
1312: IF hr_api.not_exists_in_hr_lookups
1313: (p_effective_date => p_effective_date
1314: ,p_lookup_type => NVL(l_uom_lookup,'UNITS')
1315: ,p_lookup_code => p_uom) THEN
1316: --

Line 1380: IF hr_api.not_exists_in_hr_lookups

1376: l_uom_lookup IS NOT NULL THEN
1377: --
1378: hr_utility.set_location(l_proc, 70);
1379: --
1380: IF hr_api.not_exists_in_hr_lookups
1381: (p_effective_date => p_effective_date
1382: ,p_lookup_type => l_uom_lookup
1383: ,p_lookup_code => p_uom) THEN
1384: --

Line 1459: hr_api.mandatory_arg_error

1455: hr_utility.set_location('Entering : '||l_proc,10);
1456: --
1457: -- Check mandatory parameter is set
1458: --
1459: hr_api.mandatory_arg_error
1460: (p_api_name => l_proc
1461: ,p_argument => 'cagr_entitlement_item_id'
1462: ,p_argument_value => p_cagr_entitlement_item_id
1463: );

Line 1557: hr_api.mandatory_arg_error

1553: hr_utility.set_location('Entering : '||l_proc,5);
1554: --
1555: -- Check mandatory parameter is set
1556: --
1557: hr_api.mandatory_arg_error
1558: (p_api_name => l_proc
1559: ,p_argument => 'effective_date'
1560: ,p_argument_value => p_effective_date);
1561: --

Line 1569: NVL(p_mult_entries_allowed_flag,hr_api.g_varchar2)))) THEN

1565: --
1566: IF ( (p_cagr_entitlement_item_id IS NULL) OR
1567: ((p_cagr_entitlement_item_id IS NOT NULL) AND
1568: (per_cei_shd.g_old_rec.mult_entries_allowed_flag <>
1569: NVL(p_mult_entries_allowed_flag,hr_api.g_varchar2)))) THEN
1570: --
1571: hr_utility.set_location(l_proc,20);
1572: --
1573: -- Check that the category is correct

Line 1718: IF (hr_api.not_exists_in_hr_lookups

1714: IF p_auto_create_entries_flag IS NOT NULL THEN
1715: --
1716: hr_utility.set_location(l_proc,40);
1717: --
1718: IF (hr_api.not_exists_in_hr_lookups
1719: (p_effective_date => p_effective_date
1720: ,p_lookup_type => 'YES_NO'
1721: ,p_lookup_code => p_auto_create_entries_flag
1722: )

Line 1977: hr_api.mandatory_arg_error

1973: hr_utility.set_location('Entering : '||l_proc,10);
1974: --
1975: -- Check mandatory parameter is set
1976: --
1977: hr_api.mandatory_arg_error
1978: (p_api_name => l_proc
1979: ,p_argument => 'effective_date'
1980: ,p_argument_value => p_effective_date
1981: );

Line 2119: hr_api.mandatory_arg_error

2115: hr_utility.set_location('Entering : '||l_proc,10);
2116: --
2117: -- Check mandatory parameter is set
2118: --
2119: hr_api.mandatory_arg_error
2120: (p_api_name => l_proc
2121: ,p_argument => 'effective_date'
2122: ,p_argument_value => p_effective_date
2123: );

Line 2125: hr_utility.set_location(l_proc||'/'||NVL(p_input_value_id,hr_api.g_number),20);

2121: ,p_argument => 'effective_date'
2122: ,p_argument_value => p_effective_date
2123: );
2124: --
2125: hr_utility.set_location(l_proc||'/'||NVL(p_input_value_id,hr_api.g_number),20);
2126: --
2127: -- Only proceed with validation if :
2128: -- a) Inserting or
2129: -- b) The value for input_value_id has changed

Line 2134: NVL(p_input_value_id,hr_api.g_number)))) THEN

2130: --
2131: IF ( (p_cagr_entitlement_item_id IS NULL) OR
2132: ((p_cagr_entitlement_item_id IS NOT NULL) AND
2133: (per_cei_shd.g_old_rec.input_value_id <>
2134: NVL(p_input_value_id,hr_api.g_number)))) THEN
2135: --
2136: hr_utility.set_location(l_proc,30);
2137: --
2138: IF p_input_value_id IS NOT NULL THEN

Line 2261: (NVL(per_cei_shd.g_old_rec.flex_value_set_id, hr_api.g_number) <>

2257: -- b) The value for flex_value_set_id has changed
2258: --
2259: IF ( (p_cagr_entitlement_item_id IS NULL) OR
2260: ((p_cagr_entitlement_item_id IS NOT NULL) AND
2261: (NVL(per_cei_shd.g_old_rec.flex_value_set_id, hr_api.g_number) <>
2262: NVL(p_flex_value_set_id, hr_api.g_number)))) THEN
2263: --
2264: hr_utility.set_location(l_proc,20);
2265: --

Line 2262: NVL(p_flex_value_set_id, hr_api.g_number)))) THEN

2258: --
2259: IF ( (p_cagr_entitlement_item_id IS NULL) OR
2260: ((p_cagr_entitlement_item_id IS NOT NULL) AND
2261: (NVL(per_cei_shd.g_old_rec.flex_value_set_id, hr_api.g_number) <>
2262: NVL(p_flex_value_set_id, hr_api.g_number)))) THEN
2263: --
2264: hr_utility.set_location(l_proc,20);
2265: --
2266: IF p_flex_value_set_id IS NOT NULL THEN

Line 2351: (NVL(per_cei_shd.g_old_rec.ben_rule_value_set_id, hr_api.g_number) <>

2347: -- b) The value for ben rule value set has changed
2348: --
2349: IF ( (p_cagr_entitlement_item_id IS NULL) OR
2350: ((p_cagr_entitlement_item_id IS NOT NULL) AND
2351: (NVL(per_cei_shd.g_old_rec.ben_rule_value_set_id, hr_api.g_number) <>
2352: NVL(p_ben_rule_value_set_id, hr_api.g_number)))) THEN
2353: --
2354: hr_utility.set_location(l_proc,20);
2355: --

Line 2352: NVL(p_ben_rule_value_set_id, hr_api.g_number)))) THEN

2348: --
2349: IF ( (p_cagr_entitlement_item_id IS NULL) OR
2350: ((p_cagr_entitlement_item_id IS NOT NULL) AND
2351: (NVL(per_cei_shd.g_old_rec.ben_rule_value_set_id, hr_api.g_number) <>
2352: NVL(p_ben_rule_value_set_id, hr_api.g_number)))) THEN
2353: --
2354: hr_utility.set_location(l_proc,20);
2355: --
2356: IF p_ben_rule_value_set_id IS NOT NULL THEN

Line 2404: hr_api.validate_bus_grp_id(p_rec.business_group_id);

2400: -- Validate Bus Grp if one has been entered.
2401: --
2402: -- IF p_rec.business_group_id IS NOT NULL THEN
2403: --
2404: hr_api.validate_bus_grp_id(p_rec.business_group_id);
2405: --
2406: -- END IF;
2407: --
2408: hr_utility.set_location(l_proc,20);

Line 2571: hr_api.validate_bus_grp_id(p_rec.business_group_id);

2567: -- Validate Bus Grp if one has been entered.
2568: --
2569: IF p_rec.business_group_id IS NOT NULL THEN
2570: --
2571: hr_api.validate_bus_grp_id(p_rec.business_group_id);
2572: --
2573: END IF;
2574: --
2575: hr_utility.set_location(l_proc,20);