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.PAY_PYR_BUS dependencies on HR_UTILITY

Line 31: hr_utility.set_location('Entering : '||l_proc,10);

27: l_proc VARCHAR2(72) := g_package||'chk_rate_basis';
28: --
29: BEGIN
30: --
31: hr_utility.set_location('Entering : '||l_proc,10);
32: --
33: -- Only proceed with validation if :
34: -- a) The rate_basis is changing or new
35: -- b) The value for rate_uom is changing and not null

Line 41: hr_utility.set_location(l_proc, 20);

37: l_api_updating := pay_pyr_shd.api_updating
38: (p_rate_id => p_rate_id
39: ,p_object_version_number => p_object_version_number);
40: --
41: hr_utility.set_location(l_proc, 20);
42: --
43: IF ((l_api_updating AND
44: NVL(pay_pyr_shd.g_old_rec.rate_basis, hr_api.g_varchar2) <>
45: NVL(p_rate_basis, hr_api.g_varchar2) AND (p_rate_basis IS NOT NULL)) OR

Line 48: hr_utility.set_location('g_old_rec.rate_basis'||pay_pyr_shd.g_old_rec.rate_basis,888);

44: NVL(pay_pyr_shd.g_old_rec.rate_basis, hr_api.g_varchar2) <>
45: NVL(p_rate_basis, hr_api.g_varchar2) AND (p_rate_basis IS NOT NULL)) OR
46: (NOT l_api_updating and p_rate_basis IS NOT NULL)) THEN
47: --
48: hr_utility.set_location('g_old_rec.rate_basis'||pay_pyr_shd.g_old_rec.rate_basis,888);
49: hr_utility.set_location('p_rate_basis'||p_rate_basis,888);
50: -- Check that the rate basis exists in HR_LOOKUPS
51: --
52: IF hr_api.not_exists_in_hr_lookups

Line 49: hr_utility.set_location('p_rate_basis'||p_rate_basis,888);

45: NVL(p_rate_basis, hr_api.g_varchar2) AND (p_rate_basis IS NOT NULL)) OR
46: (NOT l_api_updating and p_rate_basis IS NOT NULL)) THEN
47: --
48: hr_utility.set_location('g_old_rec.rate_basis'||pay_pyr_shd.g_old_rec.rate_basis,888);
49: hr_utility.set_location('p_rate_basis'||p_rate_basis,888);
50: -- Check that the rate basis exists in HR_LOOKUPS
51: --
52: IF hr_api.not_exists_in_hr_lookups
53: (p_effective_date => p_effective_date

Line 57: hr_utility.set_location(l_proc, 30);

53: (p_effective_date => p_effective_date
54: ,p_lookup_type => 'RATE_BASIS'
55: ,p_lookup_code => p_rate_basis) THEN
56: --
57: hr_utility.set_location(l_proc, 30);
58: --
59: hr_utility.set_message(800, 'HR_289581_RATE_BASIS_INVALID');
60: hr_utility.raise_error;
61: --

Line 59: hr_utility.set_message(800, 'HR_289581_RATE_BASIS_INVALID');

55: ,p_lookup_code => p_rate_basis) THEN
56: --
57: hr_utility.set_location(l_proc, 30);
58: --
59: hr_utility.set_message(800, 'HR_289581_RATE_BASIS_INVALID');
60: hr_utility.raise_error;
61: --
62: END IF;
63: --

Line 60: hr_utility.raise_error;

56: --
57: hr_utility.set_location(l_proc, 30);
58: --
59: hr_utility.set_message(800, 'HR_289581_RATE_BASIS_INVALID');
60: hr_utility.raise_error;
61: --
62: END IF;
63: --
64: END IF;

Line 66: hr_utility.set_location(' Leaving : '||l_proc,997);

62: END IF;
63: --
64: END IF;
65: --
66: hr_utility.set_location(' Leaving : '||l_proc,997);
67: --
68: EXCEPTION
69: --
70: WHEN app_exception.application_exception THEN

Line 75: hr_utility.set_location(' Leaving : '||l_proc,998);

71: --
72: IF hr_multi_message.exception_add
73: (p_associated_column1 => 'PAY_RATES.RATE_BASIS') THEN
74: --
75: hr_utility.set_location(' Leaving : '||l_proc,998);
76: --
77: RAISE;
78: --
79: END IF;

Line 81: hr_utility.set_location(' Leaving : '||l_proc,999);

77: RAISE;
78: --
79: END IF;
80: --
81: hr_utility.set_location(' Leaving : '||l_proc,999);
82: --
83: END chk_rate_basis;
84: --
85: -- ---------------------------------------------------------------------------

Line 100: hr_utility.set_location('Entering : '||l_proc,10);

96: l_proc VARCHAR2(72) := g_package||'chk_rate_uom';
97: --
98: BEGIN
99: --
100: hr_utility.set_location('Entering : '||l_proc,10);
101: --
102: -- Only proceed with validation if :
103: -- a) The rate_uom is changing or new
104: -- b) The value for rate_uom is changing and not null

Line 110: hr_utility.set_location(l_proc, 20);

106: l_api_updating := pay_pyr_shd.api_updating
107: (p_rate_id => p_rate_id
108: ,p_object_version_number => p_object_version_number);
109: --
110: hr_utility.set_location(l_proc, 20);
111: --
112: IF ((l_api_updating AND
113: NVL(pay_pyr_shd.g_old_rec.rate_uom, hr_api.g_varchar2) <>
114: NVL(p_rate_uom, hr_api.g_varchar2) AND (p_rate_uom IS NOT NULL)) OR

Line 124: hr_utility.set_location(l_proc, 30);

120: (p_effective_date => p_effective_date
121: ,p_lookup_type => 'UNITS'
122: ,p_lookup_code => p_rate_uom) THEN
123: --
124: hr_utility.set_location(l_proc, 30);
125: --
126: hr_utility.set_message(800, 'HR_289582_RATE_UOM_INVALID');
127: hr_utility.raise_error;
128: --

Line 126: hr_utility.set_message(800, 'HR_289582_RATE_UOM_INVALID');

122: ,p_lookup_code => p_rate_uom) THEN
123: --
124: hr_utility.set_location(l_proc, 30);
125: --
126: hr_utility.set_message(800, 'HR_289582_RATE_UOM_INVALID');
127: hr_utility.raise_error;
128: --
129: END IF;
130: --

Line 127: hr_utility.raise_error;

123: --
124: hr_utility.set_location(l_proc, 30);
125: --
126: hr_utility.set_message(800, 'HR_289582_RATE_UOM_INVALID');
127: hr_utility.raise_error;
128: --
129: END IF;
130: --
131: END IF;

Line 133: hr_utility.set_location(' Leaving : '||l_proc,997);

129: END IF;
130: --
131: END IF;
132: --
133: hr_utility.set_location(' Leaving : '||l_proc,997);
134: --
135: EXCEPTION
136: --
137: WHEN app_exception.application_exception THEN

Line 142: hr_utility.set_location(' Leaving : '||l_proc,998);

138: --
139: IF hr_multi_message.exception_add
140: (p_associated_column1 => 'PAY_RATES.RATE_UOM') THEN
141: --
142: hr_utility.set_location(' Leaving : '||l_proc,998);
143: --
144: RAISE;
145: --
146: END IF;

Line 148: hr_utility.set_location(' Leaving : '||l_proc,999);

144: RAISE;
145: --
146: END IF;
147: --
148: hr_utility.set_location(' Leaving : '||l_proc,999);
149: --
150: END chk_rate_uom;
151: --
152: -- ---------------------------------------------------------------------------

Line 167: hr_utility.set_location('Entering : '||l_proc,10);

163: l_proc VARCHAR2(72) := g_package||'chk_rate_type';
164: --
165: BEGIN
166: --
167: hr_utility.set_location('Entering : '||l_proc,10);
168: --
169: -- Only proceed with validation if :
170: -- a) The rate_type is changing or new
171: -- b) The value for rate_type is changing and not null

Line 177: hr_utility.set_location(l_proc, 20);

173: l_api_updating := pay_pyr_shd.api_updating
174: (p_rate_id => p_rate_id
175: ,p_object_version_number => p_object_version_number);
176: --
177: hr_utility.set_location(l_proc, 20);
178: --
179: IF ((l_api_updating AND
180: NVL(pay_pyr_shd.g_old_rec.rate_type, hr_api.g_varchar2) <>
181: NVL(p_rate_type, hr_api.g_varchar2) AND (p_rate_type IS NOT NULL)) OR

Line 191: hr_utility.set_location(l_proc, 30);

187: (p_effective_date => p_effective_date
188: ,p_lookup_type => 'RATE_TYPE'
189: ,p_lookup_code => p_rate_type) THEN
190: --
191: hr_utility.set_location(l_proc, 30);
192: --
193: hr_utility.set_message(800, 'HR_289589_INV_ASG_RATE_TYPE');
194: hr_utility.raise_error;
195: --

Line 193: hr_utility.set_message(800, 'HR_289589_INV_ASG_RATE_TYPE');

189: ,p_lookup_code => p_rate_type) THEN
190: --
191: hr_utility.set_location(l_proc, 30);
192: --
193: hr_utility.set_message(800, 'HR_289589_INV_ASG_RATE_TYPE');
194: hr_utility.raise_error;
195: --
196: END IF;
197: --

Line 194: hr_utility.raise_error;

190: --
191: hr_utility.set_location(l_proc, 30);
192: --
193: hr_utility.set_message(800, 'HR_289589_INV_ASG_RATE_TYPE');
194: hr_utility.raise_error;
195: --
196: END IF;
197: --
198: END IF;

Line 200: hr_utility.set_location(' Leaving : '||l_proc,997);

196: END IF;
197: --
198: END IF;
199: --
200: hr_utility.set_location(' Leaving : '||l_proc,997);
201: --
202: EXCEPTION
203: --
204: WHEN app_exception.application_exception THEN

Line 209: hr_utility.set_location(' Leaving : '||l_proc,998);

205: --
206: IF hr_multi_message.exception_add
207: (p_associated_column1 => 'PAY_RATES.RATE_TYPE') THEN
208: --
209: hr_utility.set_location(' Leaving : '||l_proc,998);
210: --
211: RAISE;
212: --
213: END IF;

Line 215: hr_utility.set_location(' Leaving : '||l_proc,999);

211: RAISE;
212: --
213: END IF;
214: --
215: hr_utility.set_location(' Leaving : '||l_proc,999);
216: --
217: END chk_rate_type;
218: --
219: -- ---------------------------------------------------------------------------

Line 256: hr_utility.set_location('Entering: '||l_proc,10);

252: l_api_updating BOOLEAN;
253: --
254: BEGIN
255: --
256: hr_utility.set_location('Entering: '||l_proc,10);
257: --
258: hr_api.mandatory_arg_error
259: (p_api_name => l_proc
260: ,p_argument => 'name'

Line 271: hr_utility.set_location(l_proc||'/'||p_business_group_id, 20);

267: l_api_updating := pay_pyr_shd.api_updating
268: (p_rate_id => p_rate_id
269: ,p_object_version_number => p_object_version_number);
270: --
271: hr_utility.set_location(l_proc||'/'||p_business_group_id, 20);
272: --
273: IF ((l_api_updating AND
274: NVL(pay_pyr_shd.g_old_rec.name, hr_api.g_varchar2) <>
275: NVL(p_name, hr_api.g_varchar2) AND (p_Name IS NOT NULL)) OR

Line 278: hr_utility.set_location(l_proc, 30);

274: NVL(pay_pyr_shd.g_old_rec.name, hr_api.g_varchar2) <>
275: NVL(p_name, hr_api.g_varchar2) AND (p_Name IS NOT NULL)) OR
276: (NOT l_api_updating and p_name IS NOT NULL)) THEN
277: --
278: hr_utility.set_location(l_proc, 30);
279: --
280: -- Check to see if the name already
281: -- exists for the business group
282: --

Line 293: hr_utility.set_message(800, 'PAY_6703_DEF_GRD_RATE_EXISTS');

289: IF chk_duplicate_name%FOUND THEN
290: --
291: CLOSE chk_duplicate_name;
292: --
293: hr_utility.set_message(800, 'PAY_6703_DEF_GRD_RATE_EXISTS');
294: hr_utility.raise_error;
295: --
296: ELSE
297: --

Line 294: hr_utility.raise_error;

290: --
291: CLOSE chk_duplicate_name;
292: --
293: hr_utility.set_message(800, 'PAY_6703_DEF_GRD_RATE_EXISTS');
294: hr_utility.raise_error;
295: --
296: ELSE
297: --
298: CLOSE chk_duplicate_name;

Line 302: hr_utility.set_location(l_proc, 40);

298: CLOSE chk_duplicate_name;
299: --
300: END IF;
301: --
302: hr_utility.set_location(l_proc, 40);
303: --
304: END IF;
305: --
306: hr_utility.set_location('Leaving : '||l_proc,997);

Line 306: hr_utility.set_location('Leaving : '||l_proc,997);

302: hr_utility.set_location(l_proc, 40);
303: --
304: END IF;
305: --
306: hr_utility.set_location('Leaving : '||l_proc,997);
307: --
308: EXCEPTION
309: --
310: WHEN app_exception.application_exception THEN

Line 315: hr_utility.set_location(' Leaving : '||l_proc,998);

311: --
312: IF hr_multi_message.exception_add
313: (p_associated_column1 => 'PAY_RATES.NAME') THEN
314: --
315: hr_utility.set_location(' Leaving : '||l_proc,998);
316: --
317: RAISE;
318: --
319: END IF;

Line 321: hr_utility.set_location(' Leaving : '||l_proc,999);

317: RAISE;
318: --
319: END IF;
320: --
321: hr_utility.set_location(' Leaving : '||l_proc,999);
322: --
323: END chk_name;
324: --
325: -- ---------------------------------------------------------------------------

Line 344: hr_utility.set_location('Entering: '||l_proc,10);

340: l_api_updating BOOLEAN;
341: --
342: BEGIN
343: --
344: hr_utility.set_location('Entering: '||l_proc,10);
345: --
346: hr_api.mandatory_arg_error
347: (p_api_name => l_proc
348: ,p_argument => 'rate_id'

Line 354: hr_utility.set_location(l_proc||'/'||p_rate_type,20);

350: --
351: OPEN chk_for_records;
352: FETCH chk_for_records INTO l_dummy;
353: --
354: hr_utility.set_location(l_proc||'/'||p_rate_type,20);
355: --
356: -- If child records exists then the delete
357: -- cannot be performed until these child records
358: -- have been deleted. So raise an error.

Line 362: hr_utility.set_location(l_proc,30);

358: -- have been deleted. So raise an error.
359: --
360: IF chk_for_records%FOUND THEN
361: --
362: hr_utility.set_location(l_proc,30);
363: --
364: CLOSE chk_for_records;
365: --
366: IF p_rate_type = 'G' THEN

Line 368: hr_utility.set_message(800, 'HR_289594_GRADE_RULES_EXIST');

364: CLOSE chk_for_records;
365: --
366: IF p_rate_type = 'G' THEN
367: --
368: hr_utility.set_message(800, 'HR_289594_GRADE_RULES_EXIST');
369: hr_utility.raise_error;
370: --
371: ELSIF p_rate_type = 'SP' THEN
372: --

Line 369: hr_utility.raise_error;

365: --
366: IF p_rate_type = 'G' THEN
367: --
368: hr_utility.set_message(800, 'HR_289594_GRADE_RULES_EXIST');
369: hr_utility.raise_error;
370: --
371: ELSIF p_rate_type = 'SP' THEN
372: --
373: hr_utility.set_message(800, 'HR_289595_POINT_VALUES_EXIST');

Line 373: hr_utility.set_message(800, 'HR_289595_POINT_VALUES_EXIST');

369: hr_utility.raise_error;
370: --
371: ELSIF p_rate_type = 'SP' THEN
372: --
373: hr_utility.set_message(800, 'HR_289595_POINT_VALUES_EXIST');
374: hr_utility.raise_error;
375: --
376: ELSIF p_rate_type = 'A' THEN
377: --

Line 374: hr_utility.raise_error;

370: --
371: ELSIF p_rate_type = 'SP' THEN
372: --
373: hr_utility.set_message(800, 'HR_289595_POINT_VALUES_EXIST');
374: hr_utility.raise_error;
375: --
376: ELSIF p_rate_type = 'A' THEN
377: --
378: hr_utility.set_message(800, 'HR_289596_ASG_RATE_VAL_EXISTS');

Line 378: hr_utility.set_message(800, 'HR_289596_ASG_RATE_VAL_EXISTS');

374: hr_utility.raise_error;
375: --
376: ELSIF p_rate_type = 'A' THEN
377: --
378: hr_utility.set_message(800, 'HR_289596_ASG_RATE_VAL_EXISTS');
379: hr_utility.raise_error;
380: --
381: END IF;
382: --

Line 379: hr_utility.raise_error;

375: --
376: ELSIF p_rate_type = 'A' THEN
377: --
378: hr_utility.set_message(800, 'HR_289596_ASG_RATE_VAL_EXISTS');
379: hr_utility.raise_error;
380: --
381: END IF;
382: --
383: ELSE

Line 389: hr_utility.set_location('Leaving : '||l_proc,999);

385: CLOSE chk_for_records;
386: --
387: END IF;
388: --
389: hr_utility.set_location('Leaving : '||l_proc,999);
390: --
391: END chk_for_child_records;
392: --
393: -- ---------------------------------------------------------------------------

Line 410: hr_utility.set_location('Entering: '||l_proc,10);

406: l_api_updating BOOLEAN;
407: --
408: BEGIN
409: --
410: hr_utility.set_location('Entering: '||l_proc,10);
411: --
412: -- If the rate type is an Assignment then
413: -- check the correct fields have been set
414: -- and that they have the correct value

Line 418: hr_utility.set_location(l_proc, 20);

414: -- and that they have the correct value
415: --
416: IF p_rate_type = 'A' THEN
417: --
418: hr_utility.set_location(l_proc, 20);
419: --
420: -- If the rate_uom has not been set
421: -- to M (Money) then raise an error
422: --

Line 425: hr_utility.set_message(800, 'HR_289590_INV_ASG_RATE_UOM');

421: -- to M (Money) then raise an error
422: --
423: IF p_rate_uom <> 'M' THEN
424: --
425: hr_utility.set_message(800, 'HR_289590_INV_ASG_RATE_UOM');
426: hr_utility.raise_error;
427: --
428: -- If the parent spine id has been populated
429: -- then raise an error.

Line 426: hr_utility.raise_error;

422: --
423: IF p_rate_uom <> 'M' THEN
424: --
425: hr_utility.set_message(800, 'HR_289590_INV_ASG_RATE_UOM');
426: hr_utility.raise_error;
427: --
428: -- If the parent spine id has been populated
429: -- then raise an error.
430: --

Line 433: hr_utility.set_message(800, 'HR_289591_SPINE_ID_POPULATED');

429: -- then raise an error.
430: --
431: ELSIF p_parent_spine_id IS NOT NULL THEN
432: --
433: hr_utility.set_message(800, 'HR_289591_SPINE_ID_POPULATED');
434: hr_utility.raise_error;
435: --
436: -- If the pay basis field has not been populated
437: -- then raise an error as for Assignment Rates

Line 434: hr_utility.raise_error;

430: --
431: ELSIF p_parent_spine_id IS NOT NULL THEN
432: --
433: hr_utility.set_message(800, 'HR_289591_SPINE_ID_POPULATED');
434: hr_utility.raise_error;
435: --
436: -- If the pay basis field has not been populated
437: -- then raise an error as for Assignment Rates
438: -- the pay basis field is mandatory.

Line 442: hr_utility.set_message(800, 'HR_289592_RATE_BASIS_IS_NULL');

438: -- the pay basis field is mandatory.
439: --
440: ELSIF p_rate_basis IS NULL THEN
441: --
442: hr_utility.set_message(800, 'HR_289592_RATE_BASIS_IS_NULL');
443: hr_utility.raise_error;
444: --
445: END IF;
446: --

Line 443: hr_utility.raise_error;

439: --
440: ELSIF p_rate_basis IS NULL THEN
441: --
442: hr_utility.set_message(800, 'HR_289592_RATE_BASIS_IS_NULL');
443: hr_utility.raise_error;
444: --
445: END IF;
446: --
447: -- If the Rate is a Grade Rate then check that the

Line 455: hr_utility.set_message(800, 'HR_289593_RATE_BASIS_NOT_NULL');

451: ELSIF p_rate_type = 'G' THEN
452: --
453: IF p_rate_basis IS NOT NULL THEN
454: --
455: hr_utility.set_message(800, 'HR_289593_RATE_BASIS_NOT_NULL');
456: hr_utility.raise_error;
457: --
458: ELSIF p_parent_spine_id IS NOT NULL THEN
459: --

Line 456: hr_utility.raise_error;

452: --
453: IF p_rate_basis IS NOT NULL THEN
454: --
455: hr_utility.set_message(800, 'HR_289593_RATE_BASIS_NOT_NULL');
456: hr_utility.raise_error;
457: --
458: ELSIF p_parent_spine_id IS NOT NULL THEN
459: --
460: hr_utility.set_message(800, 'HR_289743_PARENT_SPINE_NOT_NUL');

Line 460: hr_utility.set_message(800, 'HR_289743_PARENT_SPINE_NOT_NUL');

456: hr_utility.raise_error;
457: --
458: ELSIF p_parent_spine_id IS NOT NULL THEN
459: --
460: hr_utility.set_message(800, 'HR_289743_PARENT_SPINE_NOT_NUL');
461: hr_utility.raise_error;
462: --
463: ELSIF p_asg_rate_type IS NOT NULL THEN
464: hr_utility.set_message(800, 'HR_449033_ASGRAT_TYPE_NOT_NULL');

Line 461: hr_utility.raise_error;

457: --
458: ELSIF p_parent_spine_id IS NOT NULL THEN
459: --
460: hr_utility.set_message(800, 'HR_289743_PARENT_SPINE_NOT_NUL');
461: hr_utility.raise_error;
462: --
463: ELSIF p_asg_rate_type IS NOT NULL THEN
464: hr_utility.set_message(800, 'HR_449033_ASGRAT_TYPE_NOT_NULL');
465: hr_utility.raise_error;

Line 464: hr_utility.set_message(800, 'HR_449033_ASGRAT_TYPE_NOT_NULL');

460: hr_utility.set_message(800, 'HR_289743_PARENT_SPINE_NOT_NUL');
461: hr_utility.raise_error;
462: --
463: ELSIF p_asg_rate_type IS NOT NULL THEN
464: hr_utility.set_message(800, 'HR_449033_ASGRAT_TYPE_NOT_NULL');
465: hr_utility.raise_error;
466: --
467: END IF;
468: --

Line 465: hr_utility.raise_error;

461: hr_utility.raise_error;
462: --
463: ELSIF p_asg_rate_type IS NOT NULL THEN
464: hr_utility.set_message(800, 'HR_449033_ASGRAT_TYPE_NOT_NULL');
465: hr_utility.raise_error;
466: --
467: END IF;
468: --
469: -- If the Rate is a Scale Rate then check that the rate_basis

Line 477: hr_utility.set_message(800, 'HR_289593_RATE_BASIS_NOT_NULL');

473: ELSIF p_rate_type = 'SP' THEN
474: --
475: IF p_rate_basis IS NOT NULL THEN
476: --
477: hr_utility.set_message(800, 'HR_289593_RATE_BASIS_NOT_NULL');
478: hr_utility.raise_error;
479: --
480: ELSIF p_parent_spine_id IS NULL THEN
481: --

Line 478: hr_utility.raise_error;

474: --
475: IF p_rate_basis IS NOT NULL THEN
476: --
477: hr_utility.set_message(800, 'HR_289593_RATE_BASIS_NOT_NULL');
478: hr_utility.raise_error;
479: --
480: ELSIF p_parent_spine_id IS NULL THEN
481: --
482: hr_utility.set_message(800, 'HR_289744_PARENT_SPINE_NULL');

Line 482: hr_utility.set_message(800, 'HR_289744_PARENT_SPINE_NULL');

478: hr_utility.raise_error;
479: --
480: ELSIF p_parent_spine_id IS NULL THEN
481: --
482: hr_utility.set_message(800, 'HR_289744_PARENT_SPINE_NULL');
483: hr_utility.raise_error;
484: --
485: ELSIF p_asg_rate_type IS NOT NULL THEN
486: hr_utility.set_message(800, 'HR_449033_ASGRAT_TYPE_NOT_NULL');

Line 483: hr_utility.raise_error;

479: --
480: ELSIF p_parent_spine_id IS NULL THEN
481: --
482: hr_utility.set_message(800, 'HR_289744_PARENT_SPINE_NULL');
483: hr_utility.raise_error;
484: --
485: ELSIF p_asg_rate_type IS NOT NULL THEN
486: hr_utility.set_message(800, 'HR_449033_ASGRAT_TYPE_NOT_NULL');
487: hr_utility.raise_error;

Line 486: hr_utility.set_message(800, 'HR_449033_ASGRAT_TYPE_NOT_NULL');

482: hr_utility.set_message(800, 'HR_289744_PARENT_SPINE_NULL');
483: hr_utility.raise_error;
484: --
485: ELSIF p_asg_rate_type IS NOT NULL THEN
486: hr_utility.set_message(800, 'HR_449033_ASGRAT_TYPE_NOT_NULL');
487: hr_utility.raise_error;
488: --
489: END IF;
490: --

Line 487: hr_utility.raise_error;

483: hr_utility.raise_error;
484: --
485: ELSIF p_asg_rate_type IS NOT NULL THEN
486: hr_utility.set_message(800, 'HR_449033_ASGRAT_TYPE_NOT_NULL');
487: hr_utility.raise_error;
488: --
489: END IF;
490: --
491: END IF;

Line 493: hr_utility.set_location('Leaving : '||l_proc,999);

489: END IF;
490: --
491: END IF;
492: --
493: hr_utility.set_location('Leaving : '||l_proc,999);
494: --
495: END chk_field_combinations;
496: --
497: -- ---------------------------------------------------------------------------

Line 521: hr_utility.set_location('Entering:'||l_proc, 10);

517: l_api_updating BOOLEAN;
518: --
519: BEGIN
520: --
521: hr_utility.set_location('Entering:'||l_proc, 10);
522: --
523: -- Only proceed with validation if :
524: -- a) The parent_spine_id is changing or new
525: -- b) The value for parent_spine_id is changing and not null

Line 531: hr_utility.set_location(l_proc, 20);

527: l_api_updating := pay_pyr_shd.api_updating
528: (p_rate_id => p_rate_id
529: ,p_object_version_number => p_object_version_number);
530: --
531: hr_utility.set_location(l_proc, 20);
532: --
533: IF ((l_api_updating AND
534: NVL(pay_pyr_shd.g_old_rec.rate_id, hr_api.g_number) <>
535: NVL(p_rate_id, hr_api.g_number) AND (p_rate_id IS NOT NULL)) OR

Line 538: hr_utility.set_location(l_proc, 30);

534: NVL(pay_pyr_shd.g_old_rec.rate_id, hr_api.g_number) <>
535: NVL(p_rate_id, hr_api.g_number) AND (p_rate_id IS NOT NULL)) OR
536: (NOT l_api_updating and p_rate_id IS NOT NULL)) THEN
537: --
538: hr_utility.set_location(l_proc, 30);
539: --
540: -- Check if parent_spine_id is not null
541: --
542: OPEN csr_chk_parent_spine_fk;

Line 549: hr_utility.set_message(800, 'HR_289286_PARENT_SPINE_INVALID');

545: IF csr_chk_parent_spine_fk%NOTFOUND THEN
546: --
547: CLOSE csr_chk_parent_spine_fk;
548: --
549: hr_utility.set_message(800, 'HR_289286_PARENT_SPINE_INVALID');
550: hr_utility.raise_error;
551: --
552: ELSE
553: --

Line 550: hr_utility.raise_error;

546: --
547: CLOSE csr_chk_parent_spine_fk;
548: --
549: hr_utility.set_message(800, 'HR_289286_PARENT_SPINE_INVALID');
550: hr_utility.raise_error;
551: --
552: ELSE
553: --
554: hr_utility.set_location(l_proc, 40);

Line 554: hr_utility.set_location(l_proc, 40);

550: hr_utility.raise_error;
551: --
552: ELSE
553: --
554: hr_utility.set_location(l_proc, 40);
555: --
556: CLOSE csr_chk_parent_spine_fk;
557: --
558: END IF;

Line 562: hr_utility.set_location(' Leaving: '||l_proc,997);

558: END IF;
559: --
560: END IF;
561: --
562: hr_utility.set_location(' Leaving: '||l_proc,997);
563: --
564: EXCEPTION
565: --
566: WHEN app_exception.application_exception THEN

Line 571: hr_utility.set_location(' Leaving: '|| l_proc,998);

567: --
568: IF hr_multi_message.exception_add
569: (p_associated_column1 => 'PAY_RATES.PARENT_SPINE_ID') THEN
570: --
571: hr_utility.set_location(' Leaving: '|| l_proc,998);
572: RAISE;
573: --
574: END IF;
575: --

Line 576: hr_utility.set_location(' Leaving: '||l_proc,999);

572: RAISE;
573: --
574: END IF;
575: --
576: hr_utility.set_location(' Leaving: '||l_proc,999);
577: --
578: END chk_parent_spine_id;
579: --
580: -- ---------------------------------------------------------------------------

Line 625: hr_utility.set_location('Entering:'|| l_proc, 10);

621: AND p_effective_date between nvl(start_date_active,hr_api.g_sot)
622: and nvl(end_date_active,hr_api.g_eot));
623: --
624: BEGIN
625: hr_utility.set_location('Entering:'|| l_proc, 10);
626: --
627: -- Only proceed with validation if :
628: -- a) Updating and the asg_rate_type is changing
629: -- b) Inserting

Line 646: hr_utility.set_message(800, 'HR_449034_ASGRAT_TYPE_INVALID');

642: open csr_price_differentials;
643: fetch csr_price_differentials into l_dummy;
644: IF csr_price_differentials%notfound then
645: close csr_price_differentials;
646: hr_utility.set_message(800, 'HR_449034_ASGRAT_TYPE_INVALID');
647: hr_utility.raise_error;
648: ELSE
649: close csr_price_differentials;
650: END IF;

Line 647: hr_utility.raise_error;

643: fetch csr_price_differentials into l_dummy;
644: IF csr_price_differentials%notfound then
645: close csr_price_differentials;
646: hr_utility.set_message(800, 'HR_449034_ASGRAT_TYPE_INVALID');
647: hr_utility.raise_error;
648: ELSE
649: close csr_price_differentials;
650: END IF;
651: --

Line 668: hr_utility.set_location('Leaving:'|| l_proc, 10);

664: close csr_matching_children;
665: end if;
666: --
667: END IF;
668: hr_utility.set_location('Leaving:'|| l_proc, 10);
669: END chk_asg_rate_type;
670: --
671: -- ---------------------------------------------------------------------------
672: -- |----------------------< set_security_group_id >--------------------------|

Line 696: hr_utility.set_location('Entering:'|| l_proc, 10);

692: l_proc VARCHAR2(72) := g_package||'set_security_group_id';
693: --
694: BEGIN
695: --
696: hr_utility.set_location('Entering:'|| l_proc, 10);
697: --
698: -- Ensure that all the mandatory parameter are not NULL
699: --
700: hr_api.mandatory_arg_error

Line 731: hr_utility.set_location(' Leaving:'|| l_proc, 20);

727: (p_security_group_id => l_security_group_id
728: );
729: END IF;
730: --
731: hr_utility.set_location(' Leaving:'|| l_proc, 20);
732: --
733: END set_security_group_id;
734: --
735: -- ---------------------------------------------------------------------------

Line 760: hr_utility.set_location('Entering:'|| l_proc, 10);

756: l_proc VARCHAR2(72) := g_package||'return_legislation_code';
757: --
758: BEGIN
759: --
760: hr_utility.set_location('Entering:'|| l_proc, 10);
761: --
762: -- Ensure that all the mandatory parameter are not NULL
763: --
764: hr_api.mandatory_arg_error

Line 778: hr_utility.set_location(l_proc, 20);

774: -- call to this function. Just RETURN the value IN the global
775: -- variable.
776: --
777: l_legislation_code := pay_pyr_bus.g_legislation_code;
778: hr_utility.set_location(l_proc, 20);
779: ELSE
780: --
781: -- The ID IS different to the last call to this function
782: -- or this IS the first call to this function.

Line 795: hr_utility.set_location(l_proc,30);

791: CLOSE csr_leg_code;
792: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
793: fnd_message.raise_error;
794: END IF;
795: hr_utility.set_location(l_proc,30);
796: --
797: -- Set the global variables so the values are
798: -- available for the next call to this function.
799: --

Line 804: hr_utility.set_location(' Leaving:'|| l_proc, 40);

800: CLOSE csr_leg_code;
801: pay_pyr_bus.g_rate_id := p_rate_id;
802: pay_pyr_bus.g_legislation_code := l_legislation_code;
803: END IF;
804: hr_utility.set_location(' Leaving:'|| l_proc, 40);
805: RETURN l_legislation_code;
806: END return_legislation_code;
807: --
808: -- ----------------------------------------------------------------------------

Line 843: hr_utility.set_location('Entering:'||l_proc,10);

839: --
840: l_proc VARCHAR2(72) := g_package || 'chk_df';
841: --
842: BEGIN
843: hr_utility.set_location('Entering:'||l_proc,10);
844: --
845: IF ((p_rec.rate_id IS not NULL) AND (
846: NVL(pay_pyr_shd.g_old_rec.attribute_category, hr_api.g_VARCHAR2) <>
847: NVL(p_rec.attribute_category, hr_api.g_VARCHAR2) or

Line 942: hr_utility.set_location(' Leaving:'||l_proc,20);

938: ,p_attribute20_value => p_rec.attribute20
939: );
940: END IF;
941: --
942: hr_utility.set_location(' Leaving:'||l_proc,20);
943: END chk_df;
944: --
945: -- ----------------------------------------------------------------------------
946: -- |-----------------------< chk_non_updateable_args >------------------------|

Line 983: hr_utility.set_location('Entering:'||l_proc, 10);

979: l_argument VARCHAR2(30);
980: --
981: BEGIN
982: --
983: hr_utility.set_location('Entering:'||l_proc, 10);
984: --
985: -- Only proceed with the validation IF a row exists for the current
986: -- record IN the HR Schema.
987: --

Line 998: hr_utility.set_location(l_proc,20);

994: fnd_message.set_token('STEP ', '5');
995: fnd_message.raise_error;
996: END IF;
997: --
998: hr_utility.set_location(l_proc,20);
999: --
1000: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
1001: nvl(pay_pyr_shd.g_old_rec.business_group_id,hr_api.g_number) THEN
1002: --

Line 1008: hr_utility.set_location('Leaving :'||l_proc,999);

1004: RAISE l_error;
1005: --
1006: END IF;
1007: --
1008: hr_utility.set_location('Leaving :'||l_proc,999);
1009: --
1010: EXCEPTION
1011: WHEN l_error THEN
1012: --

Line 1034: hr_utility.set_location('Entering:'||l_proc, 10);

1030: --
1031: l_proc VARCHAR2(72) := g_package||'insert_validate';
1032: --
1033: BEGIN
1034: hr_utility.set_location('Entering:'||l_proc, 10);
1035: --
1036: -- Call all supporting business operations
1037: --
1038: hr_api.validate_bus_grp_id

Line 1049: hr_utility.set_location(l_proc,20);

1045: -- one error has been found THEN abort further validation.
1046: --
1047: hr_multi_message.end_validation_set;
1048: --
1049: hr_utility.set_location(l_proc,20);
1050: --
1051: -- Validate Dependent Attributes
1052: --
1053: pay_pyr_bus.chk_parent_spine_id

Line 1058: hr_utility.set_location(l_proc,30);

1054: (p_parent_spine_id => p_rec.parent_spine_id
1055: ,p_rate_id => p_rec.rate_id
1056: ,p_object_version_number => p_rec.object_version_number);
1057: --
1058: hr_utility.set_location(l_proc,30);
1059: --
1060: pay_pyr_bus.chk_rate_type
1061: (p_rate_type => p_rec.rate_type
1062: ,p_effective_date => p_effective_date

Line 1066: hr_utility.set_location(l_proc,40);

1062: ,p_effective_date => p_effective_date
1063: ,p_rate_id => p_rec.rate_id
1064: ,p_object_version_number => p_rec.object_version_number);
1065: --
1066: hr_utility.set_location(l_proc,40);
1067: --
1068: pay_pyr_bus.chk_rate_uom
1069: (p_rate_uom => p_rec.rate_uom
1070: ,p_effective_date => p_effective_date

Line 1074: hr_utility.set_location(l_proc,50);

1070: ,p_effective_date => p_effective_date
1071: ,p_rate_id => p_rec.rate_id
1072: ,p_object_version_number => p_rec.object_version_number);
1073: --
1074: hr_utility.set_location(l_proc,50);
1075: --
1076: pay_pyr_bus.chk_rate_basis
1077: (p_rate_basis => p_rec.rate_basis
1078: ,p_effective_date => p_effective_date

Line 1082: hr_utility.set_location(l_proc,60);

1078: ,p_effective_date => p_effective_date
1079: ,p_rate_id => p_rec.rate_id
1080: ,p_object_version_number => p_rec.object_version_number);
1081: --
1082: hr_utility.set_location(l_proc,60);
1083: --
1084: pay_pyr_bus.chk_name
1085: (p_name => p_rec.name
1086: ,p_rate_id => p_rec.rate_id

Line 1092: hr_utility.set_location(l_proc,70);

1088: ,p_object_version_number => p_rec.object_version_number
1089: ,p_rate_type => p_rec.rate_type
1090: ,p_asg_rate_type => p_rec.asg_rate_type);
1091: --
1092: hr_utility.set_location(l_proc,70);
1093: --
1094: pay_pyr_bus.chk_field_combinations
1095: (p_rate_type => p_rec.rate_type
1096: ,p_rate_uom => p_rec.rate_uom

Line 1101: hr_utility.set_location(l_proc,80);

1097: ,p_rate_basis => p_rec.rate_basis
1098: ,p_parent_spine_id => p_rec.parent_spine_id
1099: ,p_asg_rate_type => p_rec.asg_rate_type);
1100: --
1101: hr_utility.set_location(l_proc,80);
1102: --
1103: pay_pyr_bus.chk_asg_rate_type
1104: (p_rate_id => p_rec.rate_id
1105: ,p_object_version_number => p_rec.object_version_number

Line 1111: hr_utility.set_location(l_proc,90);

1107: ,p_asg_rate_type => p_rec.asg_rate_type
1108: ,p_rate_type => p_rec.rate_type
1109: );
1110: --
1111: hr_utility.set_location(l_proc,90);
1112: --
1113: pay_pyr_bus.chk_df(p_rec);
1114: --
1115: hr_utility.set_location(' Leaving:'||l_proc, 999);

Line 1115: hr_utility.set_location(' Leaving:'||l_proc, 999);

1111: hr_utility.set_location(l_proc,90);
1112: --
1113: pay_pyr_bus.chk_df(p_rec);
1114: --
1115: hr_utility.set_location(' Leaving:'||l_proc, 999);
1116: --
1117: END insert_validate;
1118: --
1119: -- ----------------------------------------------------------------------------

Line 1131: hr_utility.set_location('Entering:'||l_proc, 10);

1127: l_proc VARCHAR2(72) := g_package||'update_validate';
1128: --
1129: BEGIN
1130: --
1131: hr_utility.set_location('Entering:'||l_proc, 10);
1132: --
1133: -- Call all supporting business operations
1134: --
1135: hr_api.validate_bus_grp_id

Line 1146: hr_utility.set_location(l_proc,20);

1142: -- one error has been found THEN abort further validation.
1143: --
1144: hr_multi_message.end_validation_set;
1145: --
1146: hr_utility.set_location(l_proc,20);
1147: --
1148: -- Validate Dependent Attributes
1149: --
1150: chk_non_updateable_args

Line 1154: hr_utility.set_location(l_proc,30);

1150: chk_non_updateable_args
1151: (p_effective_date => p_effective_date
1152: ,p_rec => p_rec );
1153: --
1154: hr_utility.set_location(l_proc,30);
1155: --
1156: -- Validate Dependent Attributes
1157: --
1158: pay_pyr_bus.chk_parent_spine_id

Line 1163: hr_utility.set_location(l_proc,40);

1159: (p_parent_spine_id => p_rec.parent_spine_id
1160: ,p_rate_id => p_rec.rate_id
1161: ,p_object_version_number => p_rec.object_version_number);
1162: --
1163: hr_utility.set_location(l_proc,40);
1164: --
1165: pay_pyr_bus.chk_rate_type
1166: (p_rate_type => p_rec.rate_type
1167: ,p_effective_date => p_effective_date

Line 1171: hr_utility.set_location(l_proc,50);

1167: ,p_effective_date => p_effective_date
1168: ,p_rate_id => p_rec.rate_id
1169: ,p_object_version_number => p_rec.object_version_number);
1170: --
1171: hr_utility.set_location(l_proc,50);
1172: --
1173: pay_pyr_bus.chk_rate_uom
1174: (p_rate_uom => p_rec.rate_uom
1175: ,p_effective_date => p_effective_date

Line 1179: hr_utility.set_location(l_proc,60);

1175: ,p_effective_date => p_effective_date
1176: ,p_rate_id => p_rec.rate_id
1177: ,p_object_version_number => p_rec.object_version_number);
1178: --
1179: hr_utility.set_location(l_proc,60);
1180: --
1181: pay_pyr_bus.chk_rate_basis
1182: (p_rate_basis => p_rec.rate_basis
1183: ,p_effective_date => p_effective_date

Line 1187: hr_utility.set_location(l_proc,70);

1183: ,p_effective_date => p_effective_date
1184: ,p_rate_id => p_rec.rate_id
1185: ,p_object_version_number => p_rec.object_version_number);
1186: --
1187: hr_utility.set_location(l_proc,70);
1188: --
1189: pay_pyr_bus.chk_name
1190: (p_name => p_rec.name
1191: ,p_rate_id => p_rec.rate_id

Line 1197: hr_utility.set_location(l_proc,80);

1193: ,p_object_version_number => p_rec.object_version_number
1194: ,p_rate_type => p_rec.rate_type
1195: ,p_asg_rate_type => p_rec.asg_rate_type);
1196: --
1197: hr_utility.set_location(l_proc,80);
1198: --
1199: pay_pyr_bus.chk_field_combinations
1200: (p_rate_type => p_rec.rate_type
1201: ,p_rate_uom => p_rec.rate_uom

Line 1206: hr_utility.set_location(l_proc,90);

1202: ,p_rate_basis => p_rec.rate_basis
1203: ,p_parent_spine_id => p_rec.parent_spine_id
1204: ,p_asg_rate_type => p_rec.asg_rate_type);
1205: --
1206: hr_utility.set_location(l_proc,90);
1207: --
1208: pay_pyr_bus.chk_asg_rate_type
1209: (p_rate_id => p_rec.rate_id
1210: ,p_object_version_number => p_rec.object_version_number

Line 1216: hr_utility.set_location(l_proc,100);

1212: ,p_asg_rate_type => p_rec.asg_rate_type
1213: ,p_rate_type => p_rec.rate_type
1214: );
1215: --
1216: hr_utility.set_location(l_proc,100);
1217: --
1218: pay_pyr_bus.chk_df(p_rec);
1219: --
1220: hr_utility.set_location(' Leaving:'||l_proc, 999);

Line 1220: hr_utility.set_location(' Leaving:'||l_proc, 999);

1216: hr_utility.set_location(l_proc,100);
1217: --
1218: pay_pyr_bus.chk_df(p_rec);
1219: --
1220: hr_utility.set_location(' Leaving:'||l_proc, 999);
1221: --
1222: END update_validate;
1223: --
1224: -- ----------------------------------------------------------------------------

Line 1234: hr_utility.set_location('Entering:'||l_proc, 5);

1230: --
1231: l_proc VARCHAR2(72) := g_package||'delete_validate';
1232: --
1233: BEGIN
1234: hr_utility.set_location('Entering:'||l_proc, 5);
1235: --
1236: pay_pyr_bus.chk_for_child_records
1237: (p_rate_id => p_rec.rate_id
1238: ,p_rate_type => p_rec.rate_type);

Line 1240: hr_utility.set_location(' Leaving:'||l_proc, 10);

1236: pay_pyr_bus.chk_for_child_records
1237: (p_rate_id => p_rec.rate_id
1238: ,p_rate_type => p_rec.rate_type);
1239: --
1240: hr_utility.set_location(' Leaving:'||l_proc, 10);
1241: END delete_validate;
1242: --
1243: END pay_pyr_bus;