APPS.PER_PHN_BUS dependencies on HR_UTILITY

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

17: --
18: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
19: --
20: Begin
21: hr_utility.set_location('Entering:'||l_proc, 10);
22: --
23: -- Only proceed with validation if a row exists for
24: -- the current record in the HR Schema
25: --

Line 30: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

26: if not per_phn_shd.api_updating
27: (p_phone_id => p_rec.phone_id,
28: p_object_version_number => p_rec.object_version_number)
29: then
30: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
31: hr_utility.set_message_token('PROCEDURE', l_proc);
32: hr_utility.set_message_token('STEP', '20');
33: end if;
34: hr_utility.set_location(l_proc, 30);

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

27: (p_phone_id => p_rec.phone_id,
28: p_object_version_number => p_rec.object_version_number)
29: then
30: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
31: hr_utility.set_message_token('PROCEDURE', l_proc);
32: hr_utility.set_message_token('STEP', '20');
33: end if;
34: hr_utility.set_location(l_proc, 30);
35: --

Line 32: hr_utility.set_message_token('STEP', '20');

28: p_object_version_number => p_rec.object_version_number)
29: then
30: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
31: hr_utility.set_message_token('PROCEDURE', l_proc);
32: hr_utility.set_message_token('STEP', '20');
33: end if;
34: hr_utility.set_location(l_proc, 30);
35: --
36: -- start of commenting of the following code, as parent_id and parent_table

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

30: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
31: hr_utility.set_message_token('PROCEDURE', l_proc);
32: hr_utility.set_message_token('STEP', '20');
33: end if;
34: hr_utility.set_location(l_proc, 30);
35: --
36: -- start of commenting of the following code, as parent_id and parent_table
37: -- are updteable if null. Present code makes it non updateable hence
38: -- commented

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

50: );
51: --
52: end if;
53: --
54: hr_utility.set_location(l_proc, 40);
55: if nvl(p_rec.parent_table, hr_api.g_varchar2) <>
56: nvl(per_phn_shd.g_old_rec.parent_table
57: ,hr_api.g_varchar2
58: ) then

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

67: --
68: */
69: -- end of commenting the code
70: --
71: hr_utility.set_location(' Leaving:'||l_proc, 50);
72: end chk_non_updateable_args;
73: --
74: -- ---------------------------------------------------------------------------
75: -- |----------------------------< chk_date_from >----------------------------|

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

112: l_proc varchar2(72) := g_package||'chk_date_from';
113: l_api_updating boolean;
114: --
115: begin
116: hr_utility.set_location('Entering:'||l_proc, 1);
117: --
118: -- Check mandatory parameters have been set
119: --
120: hr_api.mandatory_arg_error

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

137: or nvl(per_phn_shd.g_old_rec.date_to,hr_api.g_eot)
138: <> nvl(p_date_to,hr_api.g_eot)))
139: or
140: (NOT l_api_updating) then
141: hr_utility.set_location(l_proc, 2);
142: --
143: -- Check that the date_from value is less than or equal to the date_to
144: -- value for the current record
145: --

Line 147: hr_utility.set_message(801,'PER_7004_ALL_DATE_TO_FROM');

143: -- Check that the date_from value is less than or equal to the date_to
144: -- value for the current record
145: --
146: if p_date_from > nvl(p_date_to,hr_api.g_eot)then
147: hr_utility.set_message(801,'PER_7004_ALL_DATE_TO_FROM');
148: hr_utility.raise_error;
149: end if;
150: end if;
151: --

Line 148: hr_utility.raise_error;

144: -- value for the current record
145: --
146: if p_date_from > nvl(p_date_to,hr_api.g_eot)then
147: hr_utility.set_message(801,'PER_7004_ALL_DATE_TO_FROM');
148: hr_utility.raise_error;
149: end if;
150: end if;
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 3);

Line 152: hr_utility.set_location(' Leaving:'||l_proc, 3);

148: hr_utility.raise_error;
149: end if;
150: end if;
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 3);
153: --
154: exception
155: when app_exception.application_exception then
156: if hr_multi_message.exception_add

Line 161: hr_utility.set_location(' Leaving:'||l_proc, 4);

157: (p_associated_column1 => 'PER_PHONES.DATE_FROM'
158: ,p_associated_column2 => 'PER_PHONES.DATE_TO'
159: ) then
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 4);
162: --
163: raise;
164: end if;
165: --

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

162: --
163: raise;
164: end if;
165: --
166: hr_utility.set_location(' Leaving:'||l_proc, 5);
167: --
168: end chk_date_from;
169: --
170: -- ---------------------------------------------------------------------------

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

211: l_proc varchar2(72) := g_package||'chk_phone_type';
212: l_api_updating boolean;
213: --
214: begin
215: hr_utility.set_location('Entering:'|| l_proc, 1);
216: --
217: -- Check mandatory parameters have been set
218: --
219: hr_api.mandatory_arg_error

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

245: and nvl(per_phn_shd.g_old_rec.phone_type, hr_api.g_varchar2) <>
246: nvl(p_phone_type, hr_api.g_varchar2))
247: or
248: (NOT l_api_updating)) then
249: hr_utility.set_location(l_proc, 2);
250: --
251: -- Checks that the value for phone_type is
252: -- valid and exists on hr_lookups within the
253: -- specified date range

Line 262: hr_utility.set_message(801, 'HR_51529_PHN_TYPE_INVALID');

258: ,p_lookup_code => p_phone_type
259: ) then
260: --
261: -- Error: Invalid phone type.
262: hr_utility.set_message(801, 'HR_51529_PHN_TYPE_INVALID');
263: hr_utility.raise_error;
264: end if;
265: end if;
266: --

Line 263: hr_utility.raise_error;

259: ) then
260: --
261: -- Error: Invalid phone type.
262: hr_utility.set_message(801, 'HR_51529_PHN_TYPE_INVALID');
263: hr_utility.raise_error;
264: end if;
265: end if;
266: --
267: hr_utility.set_location(' Leaving:'|| l_proc, 3);

Line 267: hr_utility.set_location(' Leaving:'|| l_proc, 3);

263: hr_utility.raise_error;
264: end if;
265: end if;
266: --
267: hr_utility.set_location(' Leaving:'|| l_proc, 3);
268: exception
269: when app_exception.application_exception then
270: if hr_multi_message.exception_add
271: (p_associated_column1 => 'PER_PHONES.PHONE_TYPE'

Line 274: hr_utility.set_location(' Leaving:'||l_proc, 4);

270: if hr_multi_message.exception_add
271: (p_associated_column1 => 'PER_PHONES.PHONE_TYPE'
272: ) then
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 4);
275: --
276: raise;
277: end if;
278: --

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

275: --
276: raise;
277: end if;
278: --
279: hr_utility.set_location(' Leaving:'||l_proc, 5);
280: --
281: end chk_phone_type;
282: -- ---------------------------------------------------------------------------
283: -- |-------------------------< chk_phone_type_limits >---------------------|

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

375: (phn.party_id = p_party_id and p_parent_id is null) -- 3299844
376: );
377: --
378: begin
379: hr_utility.set_location('Entering:'|| l_proc, 1);
380: if hr_multi_message.no_all_inclusive_error
381: (p_check_column1 => 'PER_PHONES.PHONE_TYPE'
382: ,p_check_column2 => 'PER_PHONES.DATE_FROM'
383: ,p_check_column3 => 'PER_PHONES.PARENT_TABLE'

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

397: l_api_updating := per_phn_shd.api_updating
398: (p_phone_id => p_phone_id
399: ,p_object_version_number => p_object_version_number);
400: --
401: hr_utility.set_location(l_proc, 2);
402: --
403: if ((l_api_updating
404: and (per_phn_shd.g_old_rec.phone_type <> p_phone_type
405: or per_phn_shd.g_old_rec.date_from <> p_date_from

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

407: nvl(p_date_to,hr_api.g_eot)))
408: OR
409: (NOT l_api_updating)) then
410: --
411: hr_utility.set_location(l_proc, 3);
412: --
413: -- Checks that there is only one active primary home (H1) phone number
414: --
415: if p_phone_type = 'H1' then

Line 420: hr_utility.set_message(801, 'HR_51530_PHN_TYPE_HOME_LIMIT');

416: open csr_home_phone_limit;
417: fetch csr_home_phone_limit into l_dummy;
418: if csr_home_phone_limit%found then
419: close csr_home_phone_limit;
420: hr_utility.set_message(801, 'HR_51530_PHN_TYPE_HOME_LIMIT');
421: hr_utility.raise_error;
422: end if;
423: close csr_home_phone_limit;
424: end if;

Line 421: hr_utility.raise_error;

417: fetch csr_home_phone_limit into l_dummy;
418: if csr_home_phone_limit%found then
419: close csr_home_phone_limit;
420: hr_utility.set_message(801, 'HR_51530_PHN_TYPE_HOME_LIMIT');
421: hr_utility.raise_error;
422: end if;
423: close csr_home_phone_limit;
424: end if;
425: --

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

422: end if;
423: close csr_home_phone_limit;
424: end if;
425: --
426: hr_utility.set_location(l_proc, 4);
427: --
428: -- Checks that there is only one active primary work (W1) phone number
429: --
430: if p_phone_type = 'W1' then

Line 435: hr_utility.set_message(801, 'HR_51531_PHN_TYPE_WORK_LIMIT');

431: open csr_work_phone_limit;
432: fetch csr_work_phone_limit into l_dummy;
433: if csr_work_phone_limit%found then
434: close csr_work_phone_limit;
435: hr_utility.set_message(801, 'HR_51531_PHN_TYPE_WORK_LIMIT');
436: hr_utility.raise_error;
437: end if;
438: close csr_work_phone_limit;
439: end if;

Line 436: hr_utility.raise_error;

432: fetch csr_work_phone_limit into l_dummy;
433: if csr_work_phone_limit%found then
434: close csr_work_phone_limit;
435: hr_utility.set_message(801, 'HR_51531_PHN_TYPE_WORK_LIMIT');
436: hr_utility.raise_error;
437: end if;
438: close csr_work_phone_limit;
439: end if;
440: --

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

441: end if;
442: --
443: end if;
444: --
445: hr_utility.set_location(' Leaving:'|| l_proc, 5);
446: --
447: exception
448: when app_exception.application_exception then
449: if hr_multi_message.exception_add

Line 453: hr_utility.set_location(' Leaving:'||l_proc, 6);

449: if hr_multi_message.exception_add
450: (p_same_associated_columns => 'Y'
451: ) then
452: --
453: hr_utility.set_location(' Leaving:'||l_proc, 6);
454: --
455: raise;
456: end if;
457: --

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

454: --
455: raise;
456: end if;
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 7);
459: --
460: end chk_phone_type_limits;
461: -- ---------------------------------------------------------------------------
462: -- |----------------------------< chk_parent_table >-------------------------|

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

495: --
496: l_proc varchar2(72) := g_package||'chk_parent_table';
497: --
498: begin
499: hr_utility.set_location('Entering:'||l_proc, 1);
500: --
501: -- Check mandatory parameters have been set
502: --
503: hr_api.mandatory_arg_error

Line 512: hr_utility.set_location('IJH: Table name is: '||p_parent_table, 2);

508: --
509: -- Check that the parent_table is in the per_people table.
510: -- This is a temporary solution.
511: --
512: hr_utility.set_location('IJH: Table name is: '||p_parent_table, 2);
513: If p_parent_table <> 'PER_ALL_PEOPLE_F' then
514: hr_utility.set_location('Failed parent Table check', 4);
515: hr_utility.set_message(801, 'HR_51532_PHN_FK_NOT_FOUND');
516: hr_utility.raise_error;

Line 514: hr_utility.set_location('Failed parent Table check', 4);

510: -- This is a temporary solution.
511: --
512: hr_utility.set_location('IJH: Table name is: '||p_parent_table, 2);
513: If p_parent_table <> 'PER_ALL_PEOPLE_F' then
514: hr_utility.set_location('Failed parent Table check', 4);
515: hr_utility.set_message(801, 'HR_51532_PHN_FK_NOT_FOUND');
516: hr_utility.raise_error;
517: end if;
518:

Line 515: hr_utility.set_message(801, 'HR_51532_PHN_FK_NOT_FOUND');

511: --
512: hr_utility.set_location('IJH: Table name is: '||p_parent_table, 2);
513: If p_parent_table <> 'PER_ALL_PEOPLE_F' then
514: hr_utility.set_location('Failed parent Table check', 4);
515: hr_utility.set_message(801, 'HR_51532_PHN_FK_NOT_FOUND');
516: hr_utility.raise_error;
517: end if;
518:
519: hr_utility.set_location(' Leaving:'||l_proc, 5);

Line 516: hr_utility.raise_error;

512: hr_utility.set_location('IJH: Table name is: '||p_parent_table, 2);
513: If p_parent_table <> 'PER_ALL_PEOPLE_F' then
514: hr_utility.set_location('Failed parent Table check', 4);
515: hr_utility.set_message(801, 'HR_51532_PHN_FK_NOT_FOUND');
516: hr_utility.raise_error;
517: end if;
518:
519: hr_utility.set_location(' Leaving:'||l_proc, 5);
520: --

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

515: hr_utility.set_message(801, 'HR_51532_PHN_FK_NOT_FOUND');
516: hr_utility.raise_error;
517: end if;
518:
519: hr_utility.set_location(' Leaving:'||l_proc, 5);
520: --
521: exception
522: when app_exception.application_exception then
523: if hr_multi_message.exception_add

Line 527: hr_utility.set_location(' Leaving:'||l_proc, 6);

523: if hr_multi_message.exception_add
524: (p_associated_column1 => 'PER_PHONES.PARENT_TABLE'
525: ) then
526: --
527: hr_utility.set_location(' Leaving:'||l_proc, 6);
528: --
529: raise;
530: end if;
531: --

Line 532: hr_utility.set_location(' Leaving:'||l_proc, 7);

528: --
529: raise;
530: end if;
531: --
532: hr_utility.set_location(' Leaving:'||l_proc, 7);
533: --
534: end chk_parent_table;
535: --
536: -- ---------------------------------------------------------------------------

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

583: where per.person_id = p_parent_id
584: and rownum <2; -- performance bug fix 3387297
585: --
586: begin
587: hr_utility.set_location('Entering:'||l_proc, 1);
588: --
589: -- Check mandatory parameters have been set
590: --
591: hr_api.mandatory_arg_error

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

593: ,p_argument => 'parent_id'
594: ,p_argument_value => p_parent_id
595: );
596: --
597: hr_utility.set_location(l_proc, 2);
598: --
599: if hr_multi_message.no_exclusive_error
600: (p_check_column1 => 'PER_PHONES.PARENT_TABLE'
601: ) then

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

599: if hr_multi_message.no_exclusive_error
600: (p_check_column1 => 'PER_PHONES.PARENT_TABLE'
601: ) then
602: --
603: hr_utility.set_location(l_proc, 3);
604: --
605: -- Only proceed with validation if :
606: -- a) The current g_old_rec is current and
607: -- b) The date_from value has changed

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

613: if ((l_api_updating and per_phn_shd.g_old_rec.parent_id <> p_parent_id)
614: or
615: (NOT l_api_updating)) then
616: --
617: hr_utility.set_location(l_proc, 4);
618: --
619: -- Check that the parent_id is in the per_people table.
620: -- This is a temporary solution.
621: --

Line 626: hr_utility.set_message(801, 'HR_51532_PHN_FK_NOT_FOUND');

622: open csr_valid_parent_id;
623: fetch csr_valid_parent_id into l_dummy;
624: if csr_valid_parent_id %notfound then
625: close csr_valid_parent_id;
626: hr_utility.set_message(801, 'HR_51532_PHN_FK_NOT_FOUND');
627: hr_utility.raise_error;
628: end if;
629: close csr_valid_parent_id;
630: end if;

Line 627: hr_utility.raise_error;

623: fetch csr_valid_parent_id into l_dummy;
624: if csr_valid_parent_id %notfound then
625: close csr_valid_parent_id;
626: hr_utility.set_message(801, 'HR_51532_PHN_FK_NOT_FOUND');
627: hr_utility.raise_error;
628: end if;
629: close csr_valid_parent_id;
630: end if;
631: --

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

628: end if;
629: close csr_valid_parent_id;
630: end if;
631: --
632: hr_utility.set_location(l_proc, 10);
633: --
634: --UPDATE not allowed unless currently null
635: --
636: if (l_api_updating

Line 640: hr_utility.set_location(l_proc, 11);

636: if (l_api_updating
637: and nvl(per_phn_shd.g_old_rec.parent_id,hr_api.g_number) <> hr_api.g_number
638: and per_phn_shd.g_old_rec.parent_id <> p_parent_id
639: ) then
640: hr_utility.set_location(l_proc, 11);
641: hr_utility.set_message(800, 'HR_289949_INV_UPD_PARENT_ID');
642: hr_utility.raise_error;
643: end if;
644: --

Line 641: hr_utility.set_message(800, 'HR_289949_INV_UPD_PARENT_ID');

637: and nvl(per_phn_shd.g_old_rec.parent_id,hr_api.g_number) <> hr_api.g_number
638: and per_phn_shd.g_old_rec.parent_id <> p_parent_id
639: ) then
640: hr_utility.set_location(l_proc, 11);
641: hr_utility.set_message(800, 'HR_289949_INV_UPD_PARENT_ID');
642: hr_utility.raise_error;
643: end if;
644: --
645: hr_utility.set_location(l_proc, 15);

Line 642: hr_utility.raise_error;

638: and per_phn_shd.g_old_rec.parent_id <> p_parent_id
639: ) then
640: hr_utility.set_location(l_proc, 11);
641: hr_utility.set_message(800, 'HR_289949_INV_UPD_PARENT_ID');
642: hr_utility.raise_error;
643: end if;
644: --
645: hr_utility.set_location(l_proc, 15);
646: --

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

641: hr_utility.set_message(800, 'HR_289949_INV_UPD_PARENT_ID');
642: hr_utility.raise_error;
643: end if;
644: --
645: hr_utility.set_location(l_proc, 15);
646: --
647: if ((nvl(p_parent_id,hr_api.g_number) <> hr_api.g_number)
648: and (nvl(p_parent_table,hr_api.g_varchar2) = hr_api.g_varchar2)) then
649: hr_utility.set_location(l_proc, 16);

Line 649: hr_utility.set_location(l_proc, 16);

645: hr_utility.set_location(l_proc, 15);
646: --
647: if ((nvl(p_parent_id,hr_api.g_number) <> hr_api.g_number)
648: and (nvl(p_parent_table,hr_api.g_varchar2) = hr_api.g_varchar2)) then
649: hr_utility.set_location(l_proc, 16);
650: hr_utility.set_message(800, 'HR_289946_INV_PARENT_TABLE');
651: hr_utility.raise_error;
652: end if;
653: --

Line 650: hr_utility.set_message(800, 'HR_289946_INV_PARENT_TABLE');

646: --
647: if ((nvl(p_parent_id,hr_api.g_number) <> hr_api.g_number)
648: and (nvl(p_parent_table,hr_api.g_varchar2) = hr_api.g_varchar2)) then
649: hr_utility.set_location(l_proc, 16);
650: hr_utility.set_message(800, 'HR_289946_INV_PARENT_TABLE');
651: hr_utility.raise_error;
652: end if;
653: --
654: hr_utility.set_location(l_proc,20);

Line 651: hr_utility.raise_error;

647: if ((nvl(p_parent_id,hr_api.g_number) <> hr_api.g_number)
648: and (nvl(p_parent_table,hr_api.g_varchar2) = hr_api.g_varchar2)) then
649: hr_utility.set_location(l_proc, 16);
650: hr_utility.set_message(800, 'HR_289946_INV_PARENT_TABLE');
651: hr_utility.raise_error;
652: end if;
653: --
654: hr_utility.set_location(l_proc,20);
655: end if;

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

650: hr_utility.set_message(800, 'HR_289946_INV_PARENT_TABLE');
651: hr_utility.raise_error;
652: end if;
653: --
654: hr_utility.set_location(l_proc,20);
655: end if;
656: --
657: hr_utility.set_location(' Leaving:'||l_proc, 25);
658: --

Line 657: hr_utility.set_location(' Leaving:'||l_proc, 25);

653: --
654: hr_utility.set_location(l_proc,20);
655: end if;
656: --
657: hr_utility.set_location(' Leaving:'||l_proc, 25);
658: --
659: exception
660: when app_exception.application_exception then
661: if hr_multi_message.exception_add

Line 665: hr_utility.set_location(' Leaving:'||l_proc, 6);

661: if hr_multi_message.exception_add
662: (p_associated_column1 => 'PER_PHONES.PARENT_ID'
663: ) then
664: --
665: hr_utility.set_location(' Leaving:'||l_proc, 6);
666: --
667: raise;
668: end if;
669: --

Line 670: hr_utility.set_location(' Leaving:'||l_proc, 7);

666: --
667: raise;
668: end if;
669: --
670: hr_utility.set_location(' Leaving:'||l_proc, 7);
671: --
672: end chk_parent_id;
673: --
674: -- ----------------------------------------------------------------------------

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

725: from hz_parties hzp
726: where hzp.party_id = p_rec.party_id;
727: --
728: begin
729: hr_utility.set_location('Entering:'|| l_proc, 10);
730: --
731: --
732: if p_rec.parent_id is not null then
733: if hr_multi_message.no_exclusive_error

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

737: open csr_get_party_id;
738: fetch csr_get_party_id into l_party_id;
739: close csr_get_party_id;
740: --
741: hr_utility.set_location(l_proc,20);
742: --
743: if p_rec.party_id is not null then
744: --
745: hr_utility.set_location(l_proc,30);

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

741: hr_utility.set_location(l_proc,20);
742: --
743: if p_rec.party_id is not null then
744: --
745: hr_utility.set_location(l_proc,30);
746: --
747: if p_rec.party_id <> nvl(l_party_id,-1) then
748: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
749: hr_utility.set_location(l_proc,40);

Line 748: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');

744: --
745: hr_utility.set_location(l_proc,30);
746: --
747: if p_rec.party_id <> nvl(l_party_id,-1) then
748: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
749: hr_utility.set_location(l_proc,40);
750: hr_multi_message.add
751: (p_associated_column1 => 'PER_PHONES.PARENT_ID'
752: ,p_associated_column2 => 'PER_PHONES.PARTY_ID'

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

745: hr_utility.set_location(l_proc,30);
746: --
747: if p_rec.party_id <> nvl(l_party_id,-1) then
748: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
749: hr_utility.set_location(l_proc,40);
750: hr_multi_message.add
751: (p_associated_column1 => 'PER_PHONES.PARENT_ID'
752: ,p_associated_column2 => 'PER_PHONES.PARTY_ID'
753: );

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

755: else
756: --
757: -- derive party_id from per_all_people_f using parent_id
758: --
759: hr_utility.set_location(l_proc,50);
760: p_rec.party_id := l_party_id;
761: end if;
762: end if; -- for no_excl_err
763: else

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

761: end if;
762: end if; -- for no_excl_err
763: else
764: --
765: hr_utility.set_location(l_proc,60);
766: --
767: if p_rec.party_id is null then
768: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
769: hr_utility.set_location(l_proc,70);

Line 768: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');

764: --
765: hr_utility.set_location(l_proc,60);
766: --
767: if p_rec.party_id is null then
768: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
769: hr_utility.set_location(l_proc,70);
770: hr_multi_message.add
771: (p_associated_column1 => 'PER_PHONES.PARENT_ID'
772: ,p_associated_column2 => 'PER_PHONES.PARTY_ID'

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

765: hr_utility.set_location(l_proc,60);
766: --
767: if p_rec.party_id is null then
768: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
769: hr_utility.set_location(l_proc,70);
770: hr_multi_message.add
771: (p_associated_column1 => 'PER_PHONES.PARENT_ID'
772: ,p_associated_column2 => 'PER_PHONES.PARTY_ID'
773: );

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

774: else
775: open csr_valid_party_id;
776: fetch csr_valid_party_id into l_party_id2;
777: --
778: hr_utility.set_location(l_proc,80);
779: --
780: if csr_valid_party_id%notfound then
781: close csr_valid_party_id;
782: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');

Line 782: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');

778: hr_utility.set_location(l_proc,80);
779: --
780: if csr_valid_party_id%notfound then
781: close csr_valid_party_id;
782: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
783: hr_utility.set_location(l_proc,90);
784: hr_multi_message.add
785: (p_associated_column1 => 'PER_PHONES.PARTY_ID'
786: );

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

779: --
780: if csr_valid_party_id%notfound then
781: close csr_valid_party_id;
782: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
783: hr_utility.set_location(l_proc,90);
784: hr_multi_message.add
785: (p_associated_column1 => 'PER_PHONES.PARTY_ID'
786: );
787: else

Line 793: hr_utility.set_location(' Leaving:'||l_proc,100);

789: end if;
790: end if;
791: end if;
792: --
793: hr_utility.set_location(' Leaving:'||l_proc,100);
794: End chk_party_id;
795:
796: --
797: -- ---------------------------------------------------------------------------

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

828: --
829: l_proc varchar2(72) := g_package||'chk_object_version_number';
830: --
831: begin
832: hr_utility.set_location('Entering:'||l_proc, 1);
833: --
834: -- Check mandatory parameters have been set
835: --
836: hr_api.mandatory_arg_error

Line 842: hr_utility.set_location(' Leaving:'||l_proc, 3);

838: ,p_argument => 'object_version_number'
839: ,p_argument_value => p_object_version_number
840: );
841: --
842: hr_utility.set_location(' Leaving:'||l_proc, 3);
843: --
844: end chk_object_version_number;
845: --
846: --

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

878: --
879: l_proc varchar2(72) := g_package||'df_update_validate';
880: --
881: begin
882: hr_utility.set_location('Entering:'||l_proc, 10);
883: --
884: if nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
885: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
886: nvl(per_phn_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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

950: -- so we must call the flex stub
951: per_phn_flex.df(p_rec => p_rec);
952: end if;
953: --
954: hr_utility.set_location(' Leaving:'||l_proc, 10);
955: end df_update_validate;
956: --
957: -- -----------------------------------------------------------------------
958: -- |------------------------------< chk_df >-----------------------------|

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

986: --
987: l_proc varchar2(72) := g_package||'chk_df';
988: --
989: begin
990: hr_utility.set_location('Entering:'||l_proc, 10);
991: --
992: if ((p_rec.phone_id is not null) and (
993: nvl(per_phn_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
994: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

1126: ,p_attribute30_value => p_rec.attribute30
1127: );
1128: end if;
1129: --
1130: hr_utility.set_location(' Leaving:'||l_proc, 20);
1131:
1132: end chk_df;
1133: --
1134: -- ---------------------------------------------------------------------------

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

1167: --
1168: l_proc varchar2(72) := g_package||'chk_validity';
1169: --
1170: Begin
1171: hr_utility.set_location('Entering:'||l_proc, 5);
1172: If p_validity is not null
1173: then
1174: hr_utility.set_location(l_proc, 10);
1175: If hr_api.not_exists_in_hr_lookups

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

1170: Begin
1171: hr_utility.set_location('Entering:'||l_proc, 5);
1172: If p_validity is not null
1173: then
1174: hr_utility.set_location(l_proc, 10);
1175: If hr_api.not_exists_in_hr_lookups
1176: (p_effective_date => p_effective_date
1177: ,p_lookup_type => 'IRC_CONTACT_TIMES'
1178: ,p_lookup_code => p_validity

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

1181: fnd_message.set_name('PER','PER_289551_BAD_PHN_VALIDITY');
1182: fnd_message.raise_error;
1183: end if;
1184: end if;
1185: hr_utility.set_location(' Leaving:'||l_proc, 20);
1186: exception
1187: when app_exception.application_exception then
1188: if hr_multi_message.exception_add
1189: (p_associated_column1 => 'PER_PHONES.VALIDITY'

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

1188: if hr_multi_message.exception_add
1189: (p_associated_column1 => 'PER_PHONES.VALIDITY'
1190: ) then
1191: --
1192: hr_utility.set_location(' Leaving:'||l_proc, 30);
1193: --
1194: raise;
1195: end if;
1196: --

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

1193: --
1194: raise;
1195: end if;
1196: --
1197: hr_utility.set_location(' Leaving:'||l_proc, 40);
1198: --
1199: End chk_validity;
1200: --
1201: -- ----------------------------------------------------------------------------

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

1207: --
1208: l_proc varchar2(72) := g_package||'insert_validate';
1209: --
1210: Begin
1211: hr_utility.set_location('Entering:'||l_proc, 5);
1212: --
1213: --
1214: if p_rec.parent_table = 'PER_ALL_PEOPLE_F' then
1215: per_per_bus.set_security_group_id

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

1226: hr_multi_message.end_validation_set;
1227: --
1228: -- Validate Dependent Attributes
1229: --
1230: hr_utility.set_location(l_proc, 7);
1231: --
1232: -- Validiate dates
1233: --
1234: chk_date_from

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

1300: --
1301: per_phn_bus.chk_df(p_rec => p_rec);
1302: --
1303: --
1304: hr_utility.set_location(' Leaving:'||l_proc, 10);
1305: End insert_validate;
1306: --
1307: -- ----------------------------------------------------------------------------
1308: -- |---------------------------< update_validate >----------------------------|

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

1313: --
1314: l_proc varchar2(72) := g_package||'update_validate';
1315: --
1316: Begin
1317: hr_utility.set_location('Entering:'||l_proc, 5);
1318: --
1319: if p_rec.parent_table = 'PER_ALL_PEOPLE_F' then
1320: per_per_bus.set_security_group_id
1321: (

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

1329: -- one error has been found then abort further validation.
1330: --
1331: hr_multi_message.end_validation_set;
1332: --
1333: hr_utility.set_location(l_proc, 7);
1334: --
1335: -- Check whether called has tried to update non-updateable values.
1336: --
1337: chk_non_updateable_args (p_rec => p_rec);

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

1403: --
1404: per_phn_bus.chk_df(p_rec => p_rec);
1405: --
1406: --
1407: hr_utility.set_location(' Leaving:'||l_proc, 10);
1408: End update_validate;
1409: --
1410: -- ----------------------------------------------------------------------------
1411: -- |---------------------------< delete_validate >----------------------------|

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

1414: --
1415: l_proc varchar2(72) := g_package||'delete_validate';
1416: --
1417: Begin
1418: hr_utility.set_location('Entering:'||l_proc, 5);
1419: --
1420: -- Call all supporting business operations
1421: --
1422: -- Validate Object Version Number

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

1423: --
1424: chk_object_version_number
1425: (p_object_version_number => p_rec.object_version_number);
1426: --
1427: hr_utility.set_location(' Leaving:'||l_proc, 10);
1428: End delete_validate;
1429: --
1430: -- ---------------------------------------------------------------------------
1431: -- |---------------------< return_legislation_code >-------------------------|

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

1450: --
1451: l_legislation_code varchar2(150);
1452: l_proc varchar2(72) := 'return_legislation_code';
1453: begin
1454: hr_utility.set_location('Entering:'|| l_proc, 10);
1455: --
1456: -- Ensure that all the mandatory parameter are not null
1457: --
1458: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1465: -- call to this function. Just return the value in the global
1466: -- variable.
1467: --
1468: l_legislation_code := g_legislation_code;
1469: hr_utility.set_location(l_proc, 20);
1470: else
1471: --
1472: -- The ID is different to the last call to this function
1473: -- or this is the first call to this function.

Line 1482: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

1478: --
1479: -- The primary key is invalid therefore we must error
1480: --
1481: close csr_leg_code;
1482: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1483: hr_utility.raise_error;
1484: end if;
1485: hr_utility.set_location(l_proc, 30);
1486: --

Line 1483: hr_utility.raise_error;

1479: -- The primary key is invalid therefore we must error
1480: --
1481: close csr_leg_code;
1482: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1483: hr_utility.raise_error;
1484: end if;
1485: hr_utility.set_location(l_proc, 30);
1486: --
1487: -- Set the global variables so the values are

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

1481: close csr_leg_code;
1482: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1483: hr_utility.raise_error;
1484: end if;
1485: hr_utility.set_location(l_proc, 30);
1486: --
1487: -- Set the global variables so the values are
1488: -- available for the next call to this function
1489: --

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

1490: close csr_leg_code;
1491: g_phone_id := p_phone_id;
1492: g_legislation_code := l_legislation_code;
1493: end if;
1494: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1495: --
1496: return l_legislation_code;
1497: end return_legislation_code;
1498: --

Line 1512: hr_utility.set_message(801, 'HR_51532_PHN_FK_NOT_FOUND');

1508: if p_parent_table = 'PER_ALL_PEOPLE_F'
1509: then
1510: return per_per_bus.return_legislation_code(p_person_id => p_parent_id);
1511: else
1512: hr_utility.set_message(801, 'HR_51532_PHN_FK_NOT_FOUND');
1513: hr_utility.raise_error;
1514: end if;
1515:
1516: end return_legislation_parent;

Line 1513: hr_utility.raise_error;

1509: then
1510: return per_per_bus.return_legislation_code(p_person_id => p_parent_id);
1511: else
1512: hr_utility.set_message(801, 'HR_51532_PHN_FK_NOT_FOUND');
1513: hr_utility.raise_error;
1514: end if;
1515:
1516: end return_legislation_parent;
1517: