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.

[Home] [Help]

APPS.PER_PDP_BUS dependencies on HR_UTILITY

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

37: l_proc varchar2(72) := g_package||'set_security_group_id';
38: --
39: begin
40: --
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

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

72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --
76: hr_utility.set_location(' Leaving:'|| l_proc, 20);
77: --
78: end set_security_group_id;
79: --
80: -- ---------------------------------------------------------------------------

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

101: l_proc varchar2(72) := g_package||'return_legislation_code';
102: --
103: Begin
104: --
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

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

119: -- call to this function. Just return the value in the global
120: -- variable.
121: --
122: l_legislation_code := per_pdp_bus.g_legislation_code;
123: hr_utility.set_location(l_proc, 20);
124: else
125: --
126: -- The ID is different to the last call to this function
127: -- or this is the first call to this function.

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

136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are
143: -- available for the next call to this function.
144: --

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

145: close csr_leg_code;
146: per_pdp_bus.g_period_of_placement_id := p_period_of_placement_id;
147: per_pdp_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
152: --
153: -- ---------------------------------------------------------------------------

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

168: l_proc varchar2(72) := g_package||'return_period_of_placement_id';
169: l_period_of_placement_id number;
170:
171: begin
172: hr_utility.set_location('Entering:'||l_proc, 5);
173:
174: open c_get_period_of_placement_id;
175: fetch c_get_period_of_placement_id into l_period_of_placement_id;
176: close c_get_period_of_placement_id;

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

186:
187: --
188: -- Return the period_of_placement_id
189: --
190: hr_utility.set_location('Leaving:'||l_proc, 10);
191:
192: return l_period_of_placement_id;
193:
194: end return_period_of_placement_id;

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

262: from per_all_people_f per
263: where per.person_id = p_person_id;
264: --
265: begin
266: hr_utility.set_location('Entering:'|| l_proc, 10);
267:
268: --
269: -- Only proceed with validation when the Multiple Message List
270: -- does not already contain an error associated with the

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

278: '.LAST_STANDARD_PROCESS_DATE'
279: ) then
280:
281: --
282: hr_utility.set_location(l_proc, 20);
283: --
284: -- Check to see if record updated.
285: --
286: l_api_updating := per_pdp_shd.api_updating

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

286: l_api_updating := per_pdp_shd.api_updating
287: (p_period_of_placement_id => p_period_of_placement_id
288: ,p_object_version_number => p_object_version_number);
289: --
290: hr_utility.set_location(l_proc, 30);
291: --
292: if l_api_updating
293: then
294: --

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

295: if nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>
296: nvl(p_actual_termination_date, hr_api.g_date)
297: and p_actual_termination_date is not null
298: then
299: hr_utility.set_location(l_proc, 40);
300: --
301: if per_pdp_shd.g_old_rec.actual_termination_date is not null
302: then
303: --

Line 307: hr_utility.set_message(801,'HR_7955_PDS_INV_ATT_CHANGE');

303: --
304: -- Cannot be changed from one not null value to another not null value.
305: -- CHK_ACTUAL_TERMINATION_DATE / d
306: --
307: hr_utility.set_message(801,'HR_7955_PDS_INV_ATT_CHANGE');
308: hr_utility.raise_error;
309: end if;
310: hr_utility.set_location(l_proc, 60);
311: --

Line 308: hr_utility.raise_error;

304: -- Cannot be changed from one not null value to another not null value.
305: -- CHK_ACTUAL_TERMINATION_DATE / d
306: --
307: hr_utility.set_message(801,'HR_7955_PDS_INV_ATT_CHANGE');
308: hr_utility.raise_error;
309: end if;
310: hr_utility.set_location(l_proc, 60);
311: --
312: if p_actual_termination_date > p_last_standard_process_date and

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

306: --
307: hr_utility.set_message(801,'HR_7955_PDS_INV_ATT_CHANGE');
308: hr_utility.raise_error;
309: end if;
310: hr_utility.set_location(l_proc, 60);
311: --
312: if p_actual_termination_date > p_last_standard_process_date and
313: p_last_standard_process_date is not null then
314: --

Line 317: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');

313: p_last_standard_process_date is not null then
314: --
315: -- CHK_ACTUAL_TERMINATION_DATE / a
316: --
317: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');
318: hr_utility.raise_error;
319: end if;
320: hr_utility.set_location(l_proc, 70);
321: --

Line 318: hr_utility.raise_error;

314: --
315: -- CHK_ACTUAL_TERMINATION_DATE / a
316: --
317: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');
318: hr_utility.raise_error;
319: end if;
320: hr_utility.set_location(l_proc, 70);
321: --
322: if not (nvl(p_actual_termination_date, hr_api.g_eot) >=

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

316: --
317: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');
318: hr_utility.raise_error;
319: end if;
320: hr_utility.set_location(l_proc, 70);
321: --
322: if not (nvl(p_actual_termination_date, hr_api.g_eot) >=
323: p_date_start) then
324: --

Line 327: hr_utility.set_message(801,'HR_7493_PDS_INV_ATT_DT_ST');

323: p_date_start) then
324: --
325: -- CHK_ACTUAL_TERMINATION_DATE / b
326: --
327: hr_utility.set_message(801,'HR_7493_PDS_INV_ATT_DT_ST');
328: hr_utility.raise_error;
329: end if;
330: hr_utility.set_location(l_proc, 80);
331: --

Line 328: hr_utility.raise_error;

324: --
325: -- CHK_ACTUAL_TERMINATION_DATE / b
326: --
327: hr_utility.set_message(801,'HR_7493_PDS_INV_ATT_DT_ST');
328: hr_utility.raise_error;
329: end if;
330: hr_utility.set_location(l_proc, 80);
331: --
332: -- Get the initial insert date of the latest assignment.

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

326: --
327: hr_utility.set_message(801,'HR_7493_PDS_INV_ATT_DT_ST');
328: hr_utility.raise_error;
329: end if;
330: hr_utility.set_location(l_proc, 80);
331: --
332: -- Get the initial insert date of the latest assignment.
333: --
334: open csr_get_max_asg_start_date;

Line 342: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

338: --
339: if csr_get_max_asg_start_date%NOTFOUND then
340: --
341: close csr_get_max_asg_start_date;
342: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
343: hr_utility.set_message_token('PROCEDURE', l_proc);
344: hr_utility.set_message_token('STEP', '5');
345: hr_utility.raise_error;
346: --

Line 343: hr_utility.set_message_token('PROCEDURE', l_proc);

339: if csr_get_max_asg_start_date%NOTFOUND then
340: --
341: close csr_get_max_asg_start_date;
342: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
343: hr_utility.set_message_token('PROCEDURE', l_proc);
344: hr_utility.set_message_token('STEP', '5');
345: hr_utility.raise_error;
346: --
347: elsif (p_actual_termination_date < l_effective_start_date) then

Line 344: hr_utility.set_message_token('STEP', '5');

340: --
341: close csr_get_max_asg_start_date;
342: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
343: hr_utility.set_message_token('PROCEDURE', l_proc);
344: hr_utility.set_message_token('STEP', '5');
345: hr_utility.raise_error;
346: --
347: elsif (p_actual_termination_date < l_effective_start_date) then
348: --

Line 345: hr_utility.raise_error;

341: close csr_get_max_asg_start_date;
342: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
343: hr_utility.set_message_token('PROCEDURE', l_proc);
344: hr_utility.set_message_token('STEP', '5');
345: hr_utility.raise_error;
346: --
347: elsif (p_actual_termination_date < l_effective_start_date) then
348: --
349: -- CHK_ACTUAL_TERMINATION_DATE / e

Line 352: hr_utility.set_message(801,'HR_7956_PDS_INV_ATT_DT_EARLY');

348: --
349: -- CHK_ACTUAL_TERMINATION_DATE / e
350: --
351: close csr_get_max_asg_start_date;
352: hr_utility.set_message(801,'HR_7956_PDS_INV_ATT_DT_EARLY');
353: hr_utility.raise_error;
354: end if;
355: close csr_get_max_asg_start_date;
356: hr_utility.set_location(l_proc, 110);

Line 353: hr_utility.raise_error;

349: -- CHK_ACTUAL_TERMINATION_DATE / e
350: --
351: close csr_get_max_asg_start_date;
352: hr_utility.set_message(801,'HR_7956_PDS_INV_ATT_DT_EARLY');
353: hr_utility.raise_error;
354: end if;
355: close csr_get_max_asg_start_date;
356: hr_utility.set_location(l_proc, 110);
357: --

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

352: hr_utility.set_message(801,'HR_7956_PDS_INV_ATT_DT_EARLY');
353: hr_utility.raise_error;
354: end if;
355: close csr_get_max_asg_start_date;
356: hr_utility.set_location(l_proc, 110);
357: --
358: -- Get the latest effective start date for any person future changes.
359: --
360: open csr_get_max_per_eff_date;

Line 367: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

363: close csr_get_max_per_eff_date;
364: --
365: if l_effective_start_date is null then
366: --
367: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
368: hr_utility.set_message_token('PROCEDURE', l_proc);
369: hr_utility.set_message_token('STEP', '10');
370: hr_utility.raise_error;
371: --

Line 368: hr_utility.set_message_token('PROCEDURE', l_proc);

364: --
365: if l_effective_start_date is null then
366: --
367: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
368: hr_utility.set_message_token('PROCEDURE', l_proc);
369: hr_utility.set_message_token('STEP', '10');
370: hr_utility.raise_error;
371: --
372: elsif not (p_actual_termination_date >= l_effective_start_date) then

Line 369: hr_utility.set_message_token('STEP', '10');

365: if l_effective_start_date is null then
366: --
367: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
368: hr_utility.set_message_token('PROCEDURE', l_proc);
369: hr_utility.set_message_token('STEP', '10');
370: hr_utility.raise_error;
371: --
372: elsif not (p_actual_termination_date >= l_effective_start_date) then
373: --

Line 370: hr_utility.raise_error;

366: --
367: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
368: hr_utility.set_message_token('PROCEDURE', l_proc);
369: hr_utility.set_message_token('STEP', '10');
370: hr_utility.raise_error;
371: --
372: elsif not (p_actual_termination_date >= l_effective_start_date) then
373: --
374: -- CHK_ACTUAL_TERMINATION_DATE / f

Line 376: hr_utility.set_message(801,'HR_7957_PDS_INV_ATT_FUTURE');

372: elsif not (p_actual_termination_date >= l_effective_start_date) then
373: --
374: -- CHK_ACTUAL_TERMINATION_DATE / f
375: --
376: hr_utility.set_message(801,'HR_7957_PDS_INV_ATT_FUTURE');
377: hr_utility.raise_error;
378: end if;
379: end if;
380: --

Line 377: hr_utility.raise_error;

373: --
374: -- CHK_ACTUAL_TERMINATION_DATE / f
375: --
376: hr_utility.set_message(801,'HR_7957_PDS_INV_ATT_FUTURE');
377: hr_utility.raise_error;
378: end if;
379: end if;
380: --
381: end if;

Line 383: hr_utility.set_location(' Leaving:'|| l_proc, 120);

379: end if;
380: --
381: end if;
382: --
383: hr_utility.set_location(' Leaving:'|| l_proc, 120);
384:
385: end if; -- end multi_message if
386:
387: exception

Line 397: hr_utility.set_location(' Leaving:'|| l_proc, 130);

393: when app_exception.application_exception then
394: if hr_multi_message.exception_add
395: (p_same_associated_columns => 'Y'
396: ) then
397: hr_utility.set_location(' Leaving:'|| l_proc, 130);
398: raise;
399: end if;
400: hr_utility.set_location(' Leaving:'|| l_proc, 140);
401:

Line 400: hr_utility.set_location(' Leaving:'|| l_proc, 140);

396: ) then
397: hr_utility.set_location(' Leaving:'|| l_proc, 130);
398: raise;
399: end if;
400: hr_utility.set_location(' Leaving:'|| l_proc, 140);
401:
402: end chk_actual_termination_date;
403: --
404: -- ---------------------------------------------------------------------------

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

437: --
438: l_proc varchar2(72) := g_package||'chk_date_start';
439: --
440: begin
441: hr_utility.set_location('Entering:'|| l_proc, 10);
442: --
443: -- CHK_DATE_START / a
444: --
445: hr_api.mandatory_arg_error

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

447: ,p_argument => 'date_start'
448: ,p_argument_value => p_date_start
449: );
450: --
451: hr_utility.set_location(' Leaving:'|| l_proc, 20);
452:
453: exception
454: when app_exception.application_exception then
455: if hr_multi_message.exception_add

Line 458: hr_utility.set_location(' Leaving:'|| l_proc, 30);

454: when app_exception.application_exception then
455: if hr_multi_message.exception_add
456: (p_associated_column1 => per_pdp_shd.g_tab_nam||'.DATE_START'
457: ) then
458: hr_utility.set_location(' Leaving:'|| l_proc, 30);
459: raise;
460: end if;
461: hr_utility.set_location(' Leaving:'|| l_proc, 40);
462:

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

457: ) then
458: hr_utility.set_location(' Leaving:'|| l_proc, 30);
459: raise;
460: end if;
461: hr_utility.set_location(' Leaving:'|| l_proc, 40);
462:
463: end chk_date_start;
464: --
465: -- ---------------------------------------------------------------------------

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

501: l_proc varchar2(72) := g_package||'chk_projected_term_date';
502: l_api_updating boolean;
503: --
504: begin
505: hr_utility.set_location('Entering:'|| l_proc, 10);
506: --
507: -- Check to see if record updated.
508: --
509: l_api_updating := per_pdp_shd.api_updating

Line 513: hr_utility.set_location('Entering:'|| l_proc, 20);

509: l_api_updating := per_pdp_shd.api_updating
510: (p_period_of_placement_id => p_period_of_placement_id
511: ,p_object_version_number => p_object_version_number);
512: --
513: hr_utility.set_location('Entering:'|| l_proc, 20);
514: --
515: if (l_api_updating
516: AND (nvl(per_pdp_shd.g_old_rec.projected_termination_date, hr_api.g_date) <>
517: nvl(p_projected_termination_date, hr_api.g_date)))

Line 525: hr_utility.set_message(800,'HR_289745_ERR_PLACEMENT_DATE');

521: then
522: --
523: -- CHK_PROJECTED_TERM_DATE / a
524: --
525: hr_utility.set_message(800,'HR_289745_ERR_PLACEMENT_DATE');
526: hr_utility.raise_error;
527: end if;
528: end if;
529: --

Line 526: hr_utility.raise_error;

522: --
523: -- CHK_PROJECTED_TERM_DATE / a
524: --
525: hr_utility.set_message(800,'HR_289745_ERR_PLACEMENT_DATE');
526: hr_utility.raise_error;
527: end if;
528: end if;
529: --
530: hr_utility.set_location(' Leaving:'|| l_proc, 30);

Line 530: hr_utility.set_location(' Leaving:'|| l_proc, 30);

526: hr_utility.raise_error;
527: end if;
528: end if;
529: --
530: hr_utility.set_location(' Leaving:'|| l_proc, 30);
531: exception
532: when app_exception.application_exception then
533: if hr_multi_message.exception_add
534: (p_associated_column1 => per_pdp_shd.g_tab_nam||'.PROJECTED_TERMINATION_DATE'

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

532: when app_exception.application_exception then
533: if hr_multi_message.exception_add
534: (p_associated_column1 => per_pdp_shd.g_tab_nam||'.PROJECTED_TERMINATION_DATE'
535: ) then
536: hr_utility.set_location(' Leaving:'|| l_proc, 40);
537: raise;
538: end if;
539: hr_utility.set_location(' Leaving:'|| l_proc, 50);
540: end chk_projected_term_date;

Line 539: hr_utility.set_location(' Leaving:'|| l_proc, 50);

535: ) then
536: hr_utility.set_location(' Leaving:'|| l_proc, 40);
537: raise;
538: end if;
539: hr_utility.set_location(' Leaving:'|| l_proc, 50);
540: end chk_projected_term_date;
541: --
542: -- ---------------------------------------------------------------------------
543: -- |------------------------------------------------|

Line 596: hr_utility.set_location('Entering:'|| l_proc, 1);

592: l_max_end_date date;
593: l_proc varchar2(72) := g_package||'chk_final_process_date';
594: --
595: begin
596: hr_utility.set_location('Entering:'|| l_proc, 1);
597:
598: --
599: -- Only proceed with validation when the Multiple Message List
600: -- does not already contain an error associated with the

Line 621: hr_utility.set_location(l_proc, 5);

617: l_api_updating := per_pdp_shd.api_updating
618: (p_period_of_placement_id => p_period_of_placement_id
619: ,p_object_version_number => p_object_version_number);
620: --
621: hr_utility.set_location(l_proc, 5);
622: --
623: if l_api_updating
624: then
625: --

Line 630: hr_utility.set_location(l_proc, 6);

626: if nvl(per_pdp_shd.g_old_rec.final_process_date, hr_api.g_date) <>
627: nvl(p_final_process_date, hr_api.g_date)
628: then
629: --
630: hr_utility.set_location(l_proc, 6);
631: --
632: --
633: if per_pdp_shd.g_old_rec.final_process_date is not null
634: and p_final_process_date is not null

Line 638: hr_utility.set_message(801,'HR_7962_PDS_INV_FP_CHANGE');

634: and p_final_process_date is not null
635: then
636: -- CHK_FINAL_PROCESS_DATE / g
637: --
638: hr_utility.set_message(801,'HR_7962_PDS_INV_FP_CHANGE');
639: hr_utility.raise_error;
640: end if;
641: --
642: hr_utility.set_location(l_proc, 50);

Line 639: hr_utility.raise_error;

635: then
636: -- CHK_FINAL_PROCESS_DATE / g
637: --
638: hr_utility.set_message(801,'HR_7962_PDS_INV_FP_CHANGE');
639: hr_utility.raise_error;
640: end if;
641: --
642: hr_utility.set_location(l_proc, 50);
643: if p_actual_termination_date is null

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

638: hr_utility.set_message(801,'HR_7962_PDS_INV_FP_CHANGE');
639: hr_utility.raise_error;
640: end if;
641: --
642: hr_utility.set_location(l_proc, 50);
643: if p_actual_termination_date is null
644: then
645: --
646: if not (p_final_process_date is null)

Line 650: hr_utility.set_message(801,'HR_7503_PDS_INV_FP_DT_BLANK');

646: if not (p_final_process_date is null)
647: then
648: -- CHK_FINAL_PROCESS_DATE / d
649: --
650: hr_utility.set_message(801,'HR_7503_PDS_INV_FP_DT_BLANK');
651: hr_utility.raise_error;
652: end if;
653: --
654: end if;

Line 651: hr_utility.raise_error;

647: then
648: -- CHK_FINAL_PROCESS_DATE / d
649: --
650: hr_utility.set_message(801,'HR_7503_PDS_INV_FP_DT_BLANK');
651: hr_utility.raise_error;
652: end if;
653: --
654: end if;
655: --

Line 656: hr_utility.set_location(l_proc, 7);

652: end if;
653: --
654: end if;
655: --
656: hr_utility.set_location(l_proc, 7);
657: --
658: if p_last_standard_process_date is null
659: then
660: --

Line 661: hr_utility.set_location(l_proc, 8);

657: --
658: if p_last_standard_process_date is null
659: then
660: --
661: hr_utility.set_location(l_proc, 8);
662: --
663: if not (nvl(p_final_process_date, hr_api.g_eot) >=
664: nvl(p_actual_termination_date, hr_api.g_eot))
665: then

Line 668: hr_utility.set_message(801,'HR_7963_PDS_INV_FP_BEFORE_ATT');

664: nvl(p_actual_termination_date, hr_api.g_eot))
665: then
666: -- CHK_FINAL_PROCESS_DATE / f
667: --
668: hr_utility.set_message(801,'HR_7963_PDS_INV_FP_BEFORE_ATT');
669: hr_utility.raise_error;
670: end if;
671: else
672: --

Line 669: hr_utility.raise_error;

665: then
666: -- CHK_FINAL_PROCESS_DATE / f
667: --
668: hr_utility.set_message(801,'HR_7963_PDS_INV_FP_BEFORE_ATT');
669: hr_utility.raise_error;
670: end if;
671: else
672: --
673: if not (nvl(p_final_process_date, hr_api.g_eot) >=

Line 679: hr_utility.set_message(801,'HR_7504_PDS_INV_FP_LSP_DT');

675: --
676: then
677: -- CHK_FINAL_PROCESS_DATE / c
678: --
679: hr_utility.set_message(801,'HR_7504_PDS_INV_FP_LSP_DT');
680: hr_utility.raise_error;
681: end if;
682: end if;
683: --

Line 680: hr_utility.raise_error;

676: then
677: -- CHK_FINAL_PROCESS_DATE / c
678: --
679: hr_utility.set_message(801,'HR_7504_PDS_INV_FP_LSP_DT');
680: hr_utility.raise_error;
681: end if;
682: end if;
683: --
684: hr_utility.set_location(l_proc, 8);

Line 684: hr_utility.set_location(l_proc, 8);

680: hr_utility.raise_error;
681: end if;
682: end if;
683: --
684: hr_utility.set_location(l_proc, 8);
685: --
686: end if;
687: end if;
688: --

Line 689: hr_utility.set_location(' Leaving:'|| l_proc, 14);

685: --
686: end if;
687: end if;
688: --
689: hr_utility.set_location(' Leaving:'|| l_proc, 14);
690:
691: end if; -- end multi_message if
692:
693: exception

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

699: when app_exception.application_exception then
700: if hr_multi_message.exception_add
701: (p_same_associated_columns => 'Y'
702: ) then
703: hr_utility.set_location(' Leaving:'|| l_proc, 20);
704: raise;
705: end if;
706: hr_utility.set_location(' Leaving:'|| l_proc, 30);
707:

Line 706: hr_utility.set_location(' Leaving:'|| l_proc, 30);

702: ) then
703: hr_utility.set_location(' Leaving:'|| l_proc, 20);
704: raise;
705: end if;
706: hr_utility.set_location(' Leaving:'|| l_proc, 30);
707:
708: end chk_final_process_date;
709: --
710: -- ---------------------------------------------------------------------------

Line 773: hr_utility.set_location('Entering:'|| l_proc, 1);

769: -- Bug 3387328. Used _perf view to increase perfomance.
770: --
771: --
772: begin
773: hr_utility.set_location('Entering:'|| l_proc, 1);
774: --
775: --
776: -- Check to see if record updated.
777: --

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

778: l_api_updating := per_pdp_shd.api_updating
779: (p_period_of_placement_id => p_period_of_placement_id
780: ,p_object_version_number => p_object_version_number);
781: --
782: hr_utility.set_location(l_proc, 20);
783: --
784: if l_api_updating
785: then
786: --

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

787: if nvl(per_pdp_shd.g_old_rec.last_standard_process_date, hr_api.g_date) <>
788: nvl(p_last_standard_process_date, hr_api.g_date)
789: then
790: --
791: hr_utility.set_location(l_proc, 30);
792: --
793: if per_pdp_shd.g_old_rec.last_standard_process_date is not null
794: and p_last_standard_process_date is not null
795: then

Line 798: hr_utility.set_message(801,'HR_7960_PDS_INV_LSP_CHANGE');

794: and p_last_standard_process_date is not null
795: then
796: -- CHK_LAST_STANDARD_PROCESS_DATE / i
797: --
798: hr_utility.set_message(801,'HR_7960_PDS_INV_LSP_CHANGE');
799: hr_utility.raise_error;
800: end if;
801: --
802: hr_utility.set_location(l_proc, 40);

Line 799: hr_utility.raise_error;

795: then
796: -- CHK_LAST_STANDARD_PROCESS_DATE / i
797: --
798: hr_utility.set_message(801,'HR_7960_PDS_INV_LSP_CHANGE');
799: hr_utility.raise_error;
800: end if;
801: --
802: hr_utility.set_location(l_proc, 40);
803: --

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

798: hr_utility.set_message(801,'HR_7960_PDS_INV_LSP_CHANGE');
799: hr_utility.raise_error;
800: end if;
801: --
802: hr_utility.set_location(l_proc, 40);
803: --
804: open csr_get_legislation_code;
805: fetch csr_get_legislation_code
806: into l_legislation_code;

Line 813: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

809: then
810: --
811: close csr_get_legislation_code;
812: --
813: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
814: hr_utility.set_message_token('PROCEDURE', l_proc);
815: hr_utility.set_message_token('STEP', '5');
816: hr_utility.raise_error;
817: end if;

Line 814: hr_utility.set_message_token('PROCEDURE', l_proc);

810: --
811: close csr_get_legislation_code;
812: --
813: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
814: hr_utility.set_message_token('PROCEDURE', l_proc);
815: hr_utility.set_message_token('STEP', '5');
816: hr_utility.raise_error;
817: end if;
818: --

Line 815: hr_utility.set_message_token('STEP', '5');

811: close csr_get_legislation_code;
812: --
813: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
814: hr_utility.set_message_token('PROCEDURE', l_proc);
815: hr_utility.set_message_token('STEP', '5');
816: hr_utility.raise_error;
817: end if;
818: --
819: close csr_get_legislation_code;

Line 816: hr_utility.raise_error;

812: --
813: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
814: hr_utility.set_message_token('PROCEDURE', l_proc);
815: hr_utility.set_message_token('STEP', '5');
816: hr_utility.raise_error;
817: end if;
818: --
819: close csr_get_legislation_code;
820: --

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

817: end if;
818: --
819: close csr_get_legislation_code;
820: --
821: hr_utility.set_location(l_proc, 50);
822: --
823: -- Bug 1711085. VS. 27-Mar-2001. Commented out the code that disables
824: -- last_standard_process for US legislature.
825: /* if l_legislation_code = 'US'

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

824: -- last_standard_process for US legislature.
825: /* if l_legislation_code = 'US'
826: then
827: --
828: hr_utility.set_location(l_proc, 60);
829: --
830: if not (p_last_standard_process_date is null)
831: then
832: -- CHK_LAST_STANDARD_PROCESS_DATE / g

Line 834: hr_utility.set_message(801,'HR_7958_PDS_INV_US_LSP_BLANK');

830: if not (p_last_standard_process_date is null)
831: then
832: -- CHK_LAST_STANDARD_PROCESS_DATE / g
833: --
834: hr_utility.set_message(801,'HR_7958_PDS_INV_US_LSP_BLANK');
835: hr_utility.raise_error;
836: end if;
837: end if;
838: */

Line 835: hr_utility.raise_error;

831: then
832: -- CHK_LAST_STANDARD_PROCESS_DATE / g
833: --
834: hr_utility.set_message(801,'HR_7958_PDS_INV_US_LSP_BLANK');
835: hr_utility.raise_error;
836: end if;
837: end if;
838: */
839: --

Line 847: hr_utility.set_message(801,'HR_7497_PDS_INV_LSP_DT_BLANK');

843: if not (p_last_standard_process_date is null)
844: then
845: -- CHK_LAST_STANDARD_PROCESS_DATE / f
846: --
847: hr_utility.set_message(801,'HR_7497_PDS_INV_LSP_DT_BLANK');
848: hr_utility.raise_error;
849: end if;
850: --
851: end if;

Line 848: hr_utility.raise_error;

844: then
845: -- CHK_LAST_STANDARD_PROCESS_DATE / f
846: --
847: hr_utility.set_message(801,'HR_7497_PDS_INV_LSP_DT_BLANK');
848: hr_utility.raise_error;
849: end if;
850: --
851: end if;
852: --

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

849: end if;
850: --
851: end if;
852: --
853: hr_utility.set_location(l_proc, 80);
854: --
855: if not (nvl(p_last_standard_process_date, hr_api.g_eot) >=
856: nvl(p_actual_termination_date, hr_api.g_eot))
857: --

Line 861: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');

857: --
858: then
859: -- CHK_LAST_STANDARD_PROCESS_DATE / c
860: --
861: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');
862: hr_utility.raise_error;
863: end if;
864: --
865: hr_utility.set_location(l_proc, 90);

Line 862: hr_utility.raise_error;

858: then
859: -- CHK_LAST_STANDARD_PROCESS_DATE / c
860: --
861: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');
862: hr_utility.raise_error;
863: end if;
864: --
865: hr_utility.set_location(l_proc, 90);
866: --

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

861: hr_utility.set_message(801,'HR_7505_PDS_INV_LSP_ATT_DT');
862: hr_utility.raise_error;
863: end if;
864: --
865: hr_utility.set_location(l_proc, 90);
866: --
867: end if;
868: --
869: if (nvl(per_pdp_shd.g_old_rec.actual_termination_date, hr_api.g_date) <>

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

870: nvl(p_actual_termination_date,hr_api.g_date) )
871: and (p_actual_termination_date is not null)
872: and l_legislation_code <> 'US'
873: then
874: hr_utility.set_location(l_proc, 100);
875: --
876: if p_last_standard_process_date is null
877: --
878: then

Line 884: hr_utility.set_message(801,'HR_7959_PDS_INV_LSP_BLANK');

880: -- Must also be set to not null value if actual_termination_date
881: -- updated to not null value.
882: -- CHK_LAST_STANDARD_PROCESS_DATE / h
883: --
884: hr_utility.set_message(801,'HR_7959_PDS_INV_LSP_BLANK');
885: hr_utility.raise_error;
886: end if;
887: end if;
888: --

Line 885: hr_utility.raise_error;

881: -- updated to not null value.
882: -- CHK_LAST_STANDARD_PROCESS_DATE / h
883: --
884: hr_utility.set_message(801,'HR_7959_PDS_INV_LSP_BLANK');
885: hr_utility.raise_error;
886: end if;
887: end if;
888: --
889: end if;

Line 891: hr_utility.set_location(l_proc, 120);

887: end if;
888: --
889: end if;
890: --
891: hr_utility.set_location(l_proc, 120);
892: --
893: hr_utility.set_location(' Leaving:'|| l_proc, 130);
894:
895: exception

Line 893: hr_utility.set_location(' Leaving:'|| l_proc, 130);

889: end if;
890: --
891: hr_utility.set_location(l_proc, 120);
892: --
893: hr_utility.set_location(' Leaving:'|| l_proc, 130);
894:
895: exception
896: when app_exception.application_exception then
897: if hr_multi_message.exception_add

Line 901: hr_utility.set_location(' Leaving:'|| l_proc, 140);

897: if hr_multi_message.exception_add
898: (p_associated_column1 => per_pdp_shd.g_tab_nam||
899: '.LAST_STANDARD_PROCESS_DATE'
900: ) then
901: hr_utility.set_location(' Leaving:'|| l_proc, 140);
902: raise;
903: end if;
904: hr_utility.set_location(' Leaving:'|| l_proc, 150);
905:

Line 904: hr_utility.set_location(' Leaving:'|| l_proc, 150);

900: ) then
901: hr_utility.set_location(' Leaving:'|| l_proc, 140);
902: raise;
903: end if;
904: hr_utility.set_location(' Leaving:'|| l_proc, 150);
905:
906: end chk_last_standard_process_date;
907: --
908: -- ---------------------------------------------------------------------------

Line 963: hr_utility.set_location('Entering:'|| l_proc, 1);

959: and rownum = 1;
960: -- Bug 3387328. Used _perf view to improve performance.
961: --
962: begin
963: hr_utility.set_location('Entering:'|| l_proc, 1);
964:
965: --
966: -- Only proceed with validation when the Multiple Message List
967: -- does not already contain an error associated with the

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

984: l_api_updating := per_pdp_shd.api_updating
985: (p_period_of_placement_id => p_period_of_placement_id
986: ,p_object_version_number => p_object_version_number);
987: --
988: hr_utility.set_location(l_proc, 20);
989: --
990: -- Only proceed with validation if :
991: -- a) The current g_old_rec is current and
992: -- b) The value for actual_termination_date or last_standard_process_date

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

1000: <> nvl(p_last_standard_process_date, hr_api.g_date))))
1001: or
1002: NOT l_api_updating then
1003: --
1004: hr_utility.set_location(l_proc, 30);
1005: --
1006: open csr_get_legislation_code;
1007: fetch csr_get_legislation_code
1008: into l_legislation_code;

Line 1015: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1011: then
1012: --
1013: close csr_get_legislation_code;
1014: --
1015: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1016: hr_utility.set_message_token('PROCEDURE', l_proc);
1017: hr_utility.set_message_token('STEP', '5');
1018: hr_utility.raise_error;
1019: end if;

Line 1016: hr_utility.set_message_token('PROCEDURE', l_proc);

1012: --
1013: close csr_get_legislation_code;
1014: --
1015: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1016: hr_utility.set_message_token('PROCEDURE', l_proc);
1017: hr_utility.set_message_token('STEP', '5');
1018: hr_utility.raise_error;
1019: end if;
1020: --

Line 1017: hr_utility.set_message_token('STEP', '5');

1013: close csr_get_legislation_code;
1014: --
1015: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1016: hr_utility.set_message_token('PROCEDURE', l_proc);
1017: hr_utility.set_message_token('STEP', '5');
1018: hr_utility.raise_error;
1019: end if;
1020: --
1021: close csr_get_legislation_code;

Line 1018: hr_utility.raise_error;

1014: --
1015: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1016: hr_utility.set_message_token('PROCEDURE', l_proc);
1017: hr_utility.set_message_token('STEP', '5');
1018: hr_utility.raise_error;
1019: end if;
1020: --
1021: close csr_get_legislation_code;
1022: --

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

1019: end if;
1020: --
1021: close csr_get_legislation_code;
1022: --
1023: hr_utility.set_location(l_proc, 50);
1024: --
1025: if l_legislation_code <> 'US' then
1026: --
1027: -- Check combination when either actual_termination_date or

Line 1034: hr_utility.set_message(801,'HR_7959_PDS_INV_LSP_BLANK');

1030: if (per_pdp_shd.g_old_rec.actual_termination_date is null
1031: and p_actual_termination_date is not null)
1032: and p_last_standard_process_date is null
1033: then
1034: hr_utility.set_message(801,'HR_7959_PDS_INV_LSP_BLANK');
1035: hr_utility.raise_error;
1036: end if;
1037: --
1038: end if;

Line 1035: hr_utility.raise_error;

1031: and p_actual_termination_date is not null)
1032: and p_last_standard_process_date is null
1033: then
1034: hr_utility.set_message(801,'HR_7959_PDS_INV_LSP_BLANK');
1035: hr_utility.raise_error;
1036: end if;
1037: --
1038: end if;
1039: --

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

1038: end if;
1039: --
1040: end if;
1041: --
1042: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1043:
1044: end if; -- end multi_message if
1045:
1046: exception

Line 1056: hr_utility.set_location(' Leaving:'|| l_proc, 50);

1052: when app_exception.application_exception then
1053: if hr_multi_message.exception_add
1054: (p_same_associated_columns => 'Y'
1055: ) then
1056: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1057: raise;
1058: end if;
1059: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1060:

Line 1059: hr_utility.set_location(' Leaving:'|| l_proc, 60);

1055: ) then
1056: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1057: raise;
1058: end if;
1059: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1060:
1061: end chk_at_date_lsp_date;
1062: --
1063: -- ---------------------------------------------------------------------------

Line 1107: hr_utility.set_location('Entering:'|| l_proc, 1);

1103: l_proc varchar2(72) := g_package||'chk_termination_reason';
1104: l_rec per_pdp_shd.g_rec_type;
1105: --
1106: begin
1107: hr_utility.set_location('Entering:'|| l_proc, 1);
1108: --
1109: hr_api.mandatory_arg_error
1110: (p_api_name => l_proc
1111: ,p_argument => 'effective date'

Line 1121: hr_utility.set_location(l_proc, 2);

1117: l_api_updating := per_pdp_shd.api_updating
1118: (p_period_of_placement_id => p_period_of_placement_id
1119: ,p_object_version_number => p_object_version_number);
1120: --
1121: hr_utility.set_location(l_proc, 2);
1122: --
1123: if l_api_updating
1124: and p_termination_reason is not null
1125: then

Line 1140: hr_utility.set_location(l_proc, 3);

1136: ,p_lookup_type => 'HR_CWK_TERMINATION_REASONS'
1137: ,p_lookup_code => p_termination_reason
1138: ) then
1139: -- Error - Invalid Termination Reason
1140: hr_utility.set_location(l_proc, 3);
1141: hr_utility.set_message(800,'HR_289610_PDP_TERM_REASON');
1142: hr_utility.raise_error;
1143: end if;
1144: --

Line 1141: hr_utility.set_message(800,'HR_289610_PDP_TERM_REASON');

1137: ,p_lookup_code => p_termination_reason
1138: ) then
1139: -- Error - Invalid Termination Reason
1140: hr_utility.set_location(l_proc, 3);
1141: hr_utility.set_message(800,'HR_289610_PDP_TERM_REASON');
1142: hr_utility.raise_error;
1143: end if;
1144: --
1145: end if;

Line 1142: hr_utility.raise_error;

1138: ) then
1139: -- Error - Invalid Termination Reason
1140: hr_utility.set_location(l_proc, 3);
1141: hr_utility.set_message(800,'HR_289610_PDP_TERM_REASON');
1142: hr_utility.raise_error;
1143: end if;
1144: --
1145: end if;
1146: --

Line 1149: hr_utility.set_location(' Leaving:'|| l_proc, 5);

1145: end if;
1146: --
1147: end if;
1148: --
1149: hr_utility.set_location(' Leaving:'|| l_proc, 5);
1150:
1151: exception
1152: when app_exception.application_exception then
1153: if hr_multi_message.exception_add

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

1153: if hr_multi_message.exception_add
1154: (p_associated_column1 => per_pdp_shd.g_tab_nam||
1155: '.TERMINATION_REASON'
1156: ) then
1157: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1158: raise;
1159: end if;
1160: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1161:

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

1156: ) then
1157: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1158: raise;
1159: end if;
1160: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1161:
1162: end chk_termination_reason;
1163: --
1164: -- ---------------------------------------------------------------------------

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

1211: and p_effective_date between
1212: p.effective_start_date and p.effective_end_date;
1213: --
1214: begin
1215: hr_utility.set_location('Entering:'|| l_proc, 10);
1216: --
1217: -- CHK_PERSON_ID / a
1218: --
1219: hr_api.mandatory_arg_error

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

1221: ,p_argument => 'person_id'
1222: ,p_argument_value => p_person_id
1223: );
1224: --
1225: hr_utility.set_location(l_proc, 20);
1226:
1227: --
1228: -- CHK_PERSON_ID / b
1229: --

Line 1243: hr_utility.set_location(' Leaving:'|| l_proc, 30);

1239: fnd_message.raise_error;
1240:
1241: end if;
1242:
1243: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1244:
1245: exception
1246: when app_exception.application_exception then
1247: if hr_multi_message.exception_add

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

1246: when app_exception.application_exception then
1247: if hr_multi_message.exception_add
1248: (p_associated_column1 => per_pdp_shd.g_tab_nam||'.PERSON_ID'
1249: ) then
1250: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1251: raise;
1252: end if;
1253: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1254:

Line 1253: hr_utility.set_location(' Leaving:'|| l_proc, 50);

1249: ) then
1250: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1251: raise;
1252: end if;
1253: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1254:
1255: end chk_person_id;
1256: --
1257: -- ---------------------------------------------------------------------------

Line 1304: hr_utility.set_location('Entering:'|| l_proc, 1);

1300: where pdp.person_id = p_person_id
1301: and pdp.date_start = p_date_start;
1302: --
1303: begin
1304: hr_utility.set_location('Entering:'|| l_proc, 1);
1305: --
1306: -- Check mandatory parameters have been set
1307: --
1308: hr_api.mandatory_arg_error

Line 1313: hr_utility.set_location(l_proc, 4);

1309: (p_api_name => l_proc
1310: ,p_argument => 'person_id'
1311: ,p_argument_value => p_person_id
1312: );
1313: hr_utility.set_location(l_proc, 4);
1314: --
1315: hr_api.mandatory_arg_error
1316: (p_api_name => l_proc
1317: ,p_argument => 'date_start'

Line 1320: hr_utility.set_location(l_proc, 5);

1316: (p_api_name => l_proc
1317: ,p_argument => 'date_start'
1318: ,p_argument_value => p_date_start
1319: );
1320: hr_utility.set_location(l_proc, 5);
1321: --
1322: -- Check to see if record updated.
1323: --
1324: l_api_updating := per_pdp_shd.api_updating

Line 1334: hr_utility.set_location(l_proc, 6);

1330: --
1331: -- Check that the Person ID and Date Start combination does not exist
1332: -- on PER_PERIODS_OF_PLACEMENT
1333: --
1334: hr_utility.set_location(l_proc, 6);
1335: --
1336: open csr_new_pers_date;
1337: --
1338: fetch csr_new_pers_date into l_exists;

Line 1345: hr_utility.set_message(800, 'HR_289611_PDP_EXISTS');

1341: then
1342: -- CHK_PERSON_ID_DATE_START / a
1343: --
1344: close csr_new_pers_date;
1345: hr_utility.set_message(800, 'HR_289611_PDP_EXISTS');
1346: hr_utility.raise_error;
1347: end if;
1348: --
1349: close csr_new_pers_date;

Line 1346: hr_utility.raise_error;

1342: -- CHK_PERSON_ID_DATE_START / a
1343: --
1344: close csr_new_pers_date;
1345: hr_utility.set_message(800, 'HR_289611_PDP_EXISTS');
1346: hr_utility.raise_error;
1347: end if;
1348: --
1349: close csr_new_pers_date;
1350: end if;

Line 1352: hr_utility.set_location(' Leaving:'|| l_proc, 9);

1348: --
1349: close csr_new_pers_date;
1350: end if;
1351: --
1352: hr_utility.set_location(' Leaving:'|| l_proc, 9);
1353:
1354: exception
1355: when app_exception.application_exception then
1356: if hr_multi_message.exception_add

Line 1360: hr_utility.set_location(' Leaving:'|| l_proc, 30);

1356: if hr_multi_message.exception_add
1357: (p_associated_column1 => per_pdp_shd.g_tab_nam||'.PERSON_ID'
1358: ,p_associated_column2 => per_pdp_shd.g_tab_nam||'.DATE_START'
1359: ) then
1360: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1361: raise;
1362: end if;
1363: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1364:

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

1359: ) then
1360: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1361: raise;
1362: end if;
1363: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1364:
1365: end chk_person_id_date_start;
1366: --
1367: -- ----------------------------------------------------------------------------

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

1399: --
1400: l_proc varchar2(72) := g_package || 'chk_ddf';
1401: --
1402: begin
1403: hr_utility.set_location('Entering:'||l_proc,10);
1404: --
1405: if ((p_rec.period_of_placement_id is not null) and (
1406: nvl(per_pdp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
1407: nvl(p_rec.information_category, hr_api.g_varchar2) or

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

1538: ,p_attribute30_value => p_rec.information30
1539: );
1540: end if;
1541: --
1542: hr_utility.set_location(' Leaving:'||l_proc,20);
1543: end chk_ddf;
1544: --
1545: -- ----------------------------------------------------------------------------
1546: -- |------------------------------< chk_df >----------------------------------|

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

1577: --
1578: l_proc varchar2(72) := g_package || 'chk_df';
1579: --
1580: begin
1581: hr_utility.set_location('Entering:'||l_proc,10);
1582: --
1583: if ((p_rec.period_of_placement_id is not null) and (
1584: nvl(per_pdp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1585: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

1716: ,p_attribute30_value => p_rec.attribute30
1717: );
1718: end if;
1719: --
1720: hr_utility.set_location(' Leaving:'||l_proc,20);
1721: end chk_df;
1722: --
1723: -- ----------------------------------------------------------------------------
1724: -- |-----------------------< chk_non_updateable_args >------------------------|

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

1782: --
1783: l_proc varchar2(72) := g_package||'insert_validate';
1784: --
1785: Begin
1786: hr_utility.set_location('Entering:'||l_proc, 5);
1787: --
1788: -- Call all supporting business operations
1789: --
1790: hr_api.validate_bus_grp_id

Line 1795: hr_utility.set_location(l_proc, 10);

1791: (p_business_group_id => p_rec.business_group_id
1792: ,p_associated_column1 => per_pdp_shd.g_tab_nam
1793: || '.BUSINESS_GROUP_ID');
1794:
1795: hr_utility.set_location(l_proc, 10);
1796:
1797: --
1798: -- Validate person id
1799: --

Line 1809: hr_utility.set_location(l_proc, 15);

1805: (p_person_id => p_rec.person_id,
1806: p_effective_date => p_effective_date,
1807: p_business_group_id => p_rec.business_group_id);
1808: --
1809: hr_utility.set_location(l_proc, 15);
1810:
1811: --
1812: -- Validate date start
1813: --

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

1816: -- CHK_DATE_START / a
1817: --
1818: per_pdp_bus.chk_date_start(p_date_start => p_rec.date_start);
1819:
1820: hr_utility.set_location(l_proc, 20);
1821:
1822: --
1823: -- After validating the set of important attributes,
1824: -- if Multiple Message detection is enabled and at least

Line 1832: hr_utility.set_location(l_proc, 25);

1828:
1829: --
1830: -- Validate Independent Attributes
1831: --
1832: hr_utility.set_location(l_proc, 25);
1833: --
1834: --
1835: -- Validate person id and date start combination
1836: --

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

1843: ,p_object_version_number => p_rec.object_version_number
1844: ,p_period_of_placement_id => p_rec.period_of_placement_id
1845: ,p_person_id => p_rec.person_id);
1846:
1847: hr_utility.set_location(l_proc, 30);
1848:
1849: --
1850: -- Validate projected termination date
1851: --

Line 1862: hr_utility.set_location(l_proc, 35);

1858: ,p_projected_termination_date => p_rec.projected_termination_date
1859: ,p_object_version_number => p_rec.object_version_number
1860: ,p_period_of_placement_id => p_rec.period_of_placement_id);
1861: --
1862: hr_utility.set_location(l_proc, 35);
1863: --
1864: -- Validate termination reason
1865: --
1866: -- Business Rule Mapping

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

1872: p_effective_date => p_effective_date,
1873: p_object_version_number => p_rec.object_version_number,
1874: p_period_of_placement_id => p_rec.period_of_placement_id);
1875:
1876: hr_utility.set_location(l_proc, 40);
1877:
1878: --
1879: -- Validate last standard process date
1880: --

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

1892: ,p_object_version_number => p_rec.object_version_number
1893: ,p_period_of_placement_id => p_rec.period_of_placement_id
1894: );
1895:
1896: hr_utility.set_location(l_proc, 50);
1897:
1898: --
1899: -- Validate Dependent Attributes
1900: --

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

1913: ,p_object_version_number => p_rec.object_version_number
1914: ,p_period_of_placement_id => p_rec.period_of_placement_id
1915: ,p_person_id => p_rec.person_id);
1916:
1917: hr_utility.set_location(l_proc, 60);
1918:
1919: --
1920: -- Validate final process date
1921: --

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

1930: p_last_standard_process_date => p_rec.last_standard_process_date,
1931: p_object_version_number => p_rec.object_version_number,
1932: p_period_of_placement_id => p_rec.period_of_placement_id);
1933:
1934: hr_utility.set_location(l_proc, 70);
1935:
1936: --
1937: -- Validate actual termination date/last standard process date
1938: --

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

1947: ,p_period_of_placement_id => p_rec.period_of_placement_id
1948: ,p_business_group_id => p_rec.business_group_id
1949: );
1950:
1951: hr_utility.set_location(l_proc, 80);
1952:
1953: --
1954: -- Only validate the flexfields if the PDP being created
1955: -- is not the default for a new person.

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

1960: per_pdp_bus.chk_df(p_rec);
1961:
1962: end if;
1963:
1964: hr_utility.set_location(' Leaving:'||l_proc, 10);
1965: End insert_validate;
1966: --
1967: -- ----------------------------------------------------------------------------
1968: -- |---------------------------< update_validate >----------------------------|

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

1974: --
1975: l_proc varchar2(72) := g_package||'update_validate';
1976: --
1977: Begin
1978: hr_utility.set_location('Entering:'||l_proc, 5);
1979: --
1980: -- Call all supporting business operations
1981: --
1982: hr_api.validate_bus_grp_id

Line 1987: hr_utility.set_location(l_proc, 10);

1983: (p_business_group_id => p_rec.business_group_id
1984: ,p_associated_column1 => per_pdp_shd.g_tab_nam
1985: || '.BUSINESS_GROUP_ID');
1986:
1987: hr_utility.set_location(l_proc, 10);
1988:
1989: --
1990: -- Validate person id
1991: --

Line 2001: hr_utility.set_location(l_proc, 15);

1997: (p_person_id => p_rec.person_id,
1998: p_effective_date => p_effective_date,
1999: p_business_group_id => p_rec.business_group_id);
2000: --
2001: hr_utility.set_location(l_proc, 15);
2002:
2003: --
2004: -- Validate date start
2005: --

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

2006: -- Business Rule Mapping
2007:
2008: -- CHK_DATE_START / a -- per_pdp_bus.chk_date_start(p_date_start => p_rec.date_start);
2009:
2010: hr_utility.set_location(l_proc, 20);
2011:
2012: --
2013: -- After validating the set of important attributes,
2014: -- if Multiple Message detection is enabled and at least

Line 2029: hr_utility.set_location(l_proc, 25);

2025: --
2026: -- Validate Independent Attributes
2027: --
2028:
2029: hr_utility.set_location(l_proc, 25);
2030: --
2031: --
2032: -- Validate person id and date start combination
2033: --

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

2040: ,p_object_version_number => p_rec.object_version_number
2041: ,p_period_of_placement_id => p_rec.period_of_placement_id
2042: ,p_person_id => p_rec.person_id);
2043:
2044: hr_utility.set_location(l_proc, 30);
2045:
2046: --
2047: -- Validate projected termination date
2048: --

Line 2059: hr_utility.set_location(l_proc, 35);

2055: ,p_projected_termination_date => p_rec.projected_termination_date
2056: ,p_object_version_number => p_rec.object_version_number
2057: ,p_period_of_placement_id => p_rec.period_of_placement_id);
2058: --
2059: hr_utility.set_location(l_proc, 35);
2060: --
2061: -- Validate termination reason
2062: --
2063: -- Business Rule Mapping

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

2069: p_effective_date => p_effective_date,
2070: p_object_version_number => p_rec.object_version_number,
2071: p_period_of_placement_id => p_rec.period_of_placement_id);
2072:
2073: hr_utility.set_location(l_proc, 40);
2074: --
2075: -- Validate last standard process date
2076: --
2077: -- Business Rule Mapping

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

2088: ,p_object_version_number => p_rec.object_version_number
2089: ,p_period_of_placement_id => p_rec.period_of_placement_id
2090: );
2091:
2092: hr_utility.set_location(l_proc, 50);
2093:
2094: --
2095: -- Validate Dependent Attributes
2096: --

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

2109: ,p_object_version_number => p_rec.object_version_number
2110: ,p_period_of_placement_id => p_rec.period_of_placement_id
2111: ,p_person_id => p_rec.person_id);
2112:
2113: hr_utility.set_location(l_proc, 60);
2114:
2115: --
2116: -- Validate final process date
2117: --

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

2126: p_last_standard_process_date => p_rec.last_standard_process_date,
2127: p_object_version_number => p_rec.object_version_number,
2128: p_period_of_placement_id => p_rec.period_of_placement_id);
2129:
2130: hr_utility.set_location(l_proc, 70);
2131:
2132: --
2133: -- Validate actual termination date/last standard process date
2134: --

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

2143: ,p_period_of_placement_id => p_rec.period_of_placement_id
2144: ,p_business_group_id => p_rec.business_group_id
2145: );
2146:
2147: hr_utility.set_location(l_proc, 80);
2148:
2149: --
2150: -- Only validate the flexfields if the PDP being created
2151: -- is not the default for a new person.

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

2156: per_pdp_bus.chk_df(p_rec);
2157:
2158: end if;
2159: --
2160: hr_utility.set_location(' Leaving:'||l_proc, 10);
2161: End update_validate;
2162: --
2163: -- ----------------------------------------------------------------------------
2164: -- |---------------------------< delete_validate >----------------------------|

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

2169: --
2170: l_proc varchar2(72) := g_package||'delete_validate';
2171: --
2172: Begin
2173: hr_utility.set_location('Entering:'||l_proc, 5);
2174: --
2175: -- Call all supporting business operations
2176: --
2177: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

2173: hr_utility.set_location('Entering:'||l_proc, 5);
2174: --
2175: -- Call all supporting business operations
2176: --
2177: hr_utility.set_location(' Leaving:'||l_proc, 10);
2178: End delete_validate;
2179: --
2180: end per_pdp_bus;