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

APPS.PER_KAD_BUS dependencies on HR_UTILITY

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

51: from per_people_f ppf
52: where ppf.person_id = p_person_id;
53: --
54: begin
55: hr_utility.set_location('Entering:'|| l_proc, 1);
56: --
57: -- Check mandatory parameters have been set
58: --
59: hr_api.mandatory_arg_error

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

60: (p_api_name => l_proc
61: ,p_argument => 'person_id'
62: ,p_argument_value => p_person_id
63: );
64: hr_utility.set_location(l_proc, 2);
65: --
66: -- Check that the Person ID is linked to a
67: -- valid person on PER_PEOPLE_F
68: --

Line 73: hr_utility.set_message(801, 'HR_7298_ADD_PERSON_INVALID');

69: open csr_valid_pers;
70: fetch csr_valid_pers into l_exists;
71: if csr_valid_pers%notfound then
72: close csr_valid_pers;
73: hr_utility.set_message(801, 'HR_7298_ADD_PERSON_INVALID');
74: hr_utility.raise_error;
75: end if;
76: close csr_valid_pers;
77: hr_utility.set_location(' Leaving:'|| l_proc, 3);

Line 74: hr_utility.raise_error;

70: fetch csr_valid_pers into l_exists;
71: if csr_valid_pers%notfound then
72: close csr_valid_pers;
73: hr_utility.set_message(801, 'HR_7298_ADD_PERSON_INVALID');
74: hr_utility.raise_error;
75: end if;
76: close csr_valid_pers;
77: hr_utility.set_location(' Leaving:'|| l_proc, 3);
78: end chk_person_id;

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

73: hr_utility.set_message(801, 'HR_7298_ADD_PERSON_INVALID');
74: hr_utility.raise_error;
75: end if;
76: close csr_valid_pers;
77: hr_utility.set_location(' Leaving:'|| l_proc, 3);
78: end chk_person_id;
79: --
80: -- ---------------------------------------------------------------------------
81: -- |-------------------------< chk_address_type >---------------------------|

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

121: l_proc varchar2(72) := g_package||'chk_address_type';
122: l_api_updating boolean;
123: --
124: begin
125: hr_utility.set_location('Entering:'|| l_proc, 1);
126: --
127: -- Check mandatory parameters have been set
128: --
129: hr_api.mandatory_arg_error

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

148: if ((l_api_updating and
149: nvl(per_kad_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
150: nvl(p_address_type, hr_api.g_varchar2)) or
151: (NOT l_api_updating)) then
152: hr_utility.set_location(l_proc, 2);
153: --
154: -- Checks that the value for address_type is
155: -- valid and exists on hr_lookups within the
156: -- specified date range

Line 167: hr_utility.set_message(801, 'HR_7299_ADD_TYPE_INVALID');

163: ,p_lookup_code => p_address_type
164: ) then
165: --
166: -- Error: Invalid address type.
167: hr_utility.set_message(801, 'HR_7299_ADD_TYPE_INVALID');
168: hr_utility.raise_error;
169: end if;
170: end if;
171: end if;

Line 168: hr_utility.raise_error;

164: ) then
165: --
166: -- Error: Invalid address type.
167: hr_utility.set_message(801, 'HR_7299_ADD_TYPE_INVALID');
168: hr_utility.raise_error;
169: end if;
170: end if;
171: end if;
172: --

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

169: end if;
170: end if;
171: end if;
172: --
173: hr_utility.set_location(' Leaving:'|| l_proc, 4);
174: end chk_address_type;
175: --
176: -- ---------------------------------------------------------------------------
177: -- |---------------------------< chk_country >------------------------------|

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

218: from fnd_territories ft
219: where ft.territory_code = p_country;
220: --
221: begin
222: hr_utility.set_location('Entering:'|| l_proc, 1);
223: --
224: -- Only proceed with validation if :
225: -- a) The current g_old_rec is current and
226: -- b) The value for country has changed

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

232: if ((l_api_updating and
233: nvl(per_kad_shd.g_old_rec.country, hr_api.g_varchar2) <>
234: nvl(p_country, hr_api.g_varchar2)) or
235: (NOT l_api_updating)) then
236: hr_utility.set_location(l_proc, 2);
237: --
238: -- Checks that value for country is a valid
239: -- country on fnd_territories
240: --

Line 248: hr_utility.set_message(801, 'HR_7300_ADD_COUNTRY_INVALID');

244: open csr_valid_ctry;
245: fetch csr_valid_ctry into l_exists;
246: if csr_valid_ctry%notfound then
247: close csr_valid_ctry;
248: hr_utility.set_message(801, 'HR_7300_ADD_COUNTRY_INVALID');
249: hr_utility.raise_error;
250: end if;
251: close csr_valid_ctry;
252: end if;

Line 249: hr_utility.raise_error;

245: fetch csr_valid_ctry into l_exists;
246: if csr_valid_ctry%notfound then
247: close csr_valid_ctry;
248: hr_utility.set_message(801, 'HR_7300_ADD_COUNTRY_INVALID');
249: hr_utility.raise_error;
250: end if;
251: close csr_valid_ctry;
252: end if;
253: end if;

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

251: close csr_valid_ctry;
252: end if;
253: end if;
254: --
255: hr_utility.set_location(' Leaving:'|| l_proc, 3);
256: end chk_country;
257: --
258: -- ---------------------------------------------------------------------------
259: -- |------------------------< chk_date_to >---------------------------------|

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

297: l_date_to date;
298: l_api_updating boolean;
299: --
300: begin
301: hr_utility.set_location('Entering:'|| l_proc, 1);
302: --
303: -- Check mandatory parameters have been set
304: --
305: hr_api.mandatory_arg_error

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

320: nvl(per_kad_shd.g_old_rec.date_to, hr_api.g_eot) <>
321: nvl(p_date_to, hr_api.g_eot)) or
322: (NOT l_api_updating)) then
323: --
324: hr_utility.set_location(l_proc, 2);
325: --
326: -- Checks that the value for date_to is greater than or
327: -- equal to the corresponding value for date_from for the
328: -- same record

Line 331: hr_utility.set_message(801, 'HR_7301_ADD_DATE_TO_LATER');

327: -- equal to the corresponding value for date_from for the
328: -- same record
329: --
330: if nvl(p_date_to, hr_api.g_eot) < p_date_from then
331: hr_utility.set_message(801, 'HR_7301_ADD_DATE_TO_LATER');
332: hr_utility.raise_error;
333: end if;
334: --
335: end if;

Line 332: hr_utility.raise_error;

328: -- same record
329: --
330: if nvl(p_date_to, hr_api.g_eot) < p_date_from then
331: hr_utility.set_message(801, 'HR_7301_ADD_DATE_TO_LATER');
332: hr_utility.raise_error;
333: end if;
334: --
335: end if;
336: --

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

333: end if;
334: --
335: end if;
336: --
337: hr_utility.set_location(' Leaving:'|| l_proc, 3);
338: end chk_date_to;
339: --
340: -- ---------------------------------------------------------------------------
341: -- |------------------------< chk_date_from >-------------------------------|

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

377: l_proc varchar2(72) := g_package||'chk_date_from';
378: l_api_updating boolean;
379: --
380: begin
381: hr_utility.set_location('Entering:'|| l_proc, 1);
382: --
383: -- Check mandatory parameters have been set
384: --
385: hr_api.mandatory_arg_error

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

397: ,p_object_version_number => p_object_version_number);
398: --
399: if ((l_api_updating and per_kad_shd.g_old_rec.date_from <> p_date_from) or
400: (NOT l_api_updating)) then
401: hr_utility.set_location(l_proc, 2);
402: --
403: -- Check that the date_from values is less than
404: -- or equal to the date_to value for the current
405: -- record

Line 408: hr_utility.set_message(801, 'HR_7303_ADD_DATE_FROM_EARLIER');

404: -- or equal to the date_to value for the current
405: -- record
406: --
407: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
408: hr_utility.set_message(801, 'HR_7303_ADD_DATE_FROM_EARLIER');
409: hr_utility.raise_error;
410: end if;
411: --
412: end if;

Line 409: hr_utility.raise_error;

405: -- record
406: --
407: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
408: hr_utility.set_message(801, 'HR_7303_ADD_DATE_FROM_EARLIER');
409: hr_utility.raise_error;
410: end if;
411: --
412: end if;
413: --

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

410: end if;
411: --
412: end if;
413: --
414: hr_utility.set_location(' Leaving:'|| l_proc, 3);
415: end chk_date_from;
416: --
417: -- ---------------------------------------------------------------------------
418: -- |-----------------------------< chk_style >------------------------------|

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

471: -- 70.2 change c end.
472: --
473: --
474: begin
475: hr_utility.set_location('Entering:'|| l_proc, 1);
476: --
477: -- Check mandatory parameters have been set
478: --
479: hr_api.mandatory_arg_error

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

480: (p_api_name => l_proc
481: ,p_argument => 'style'
482: ,p_argument_value => p_style
483: );
484: hr_utility.set_location(l_proc, 2);
485: --
486: -- Checks that the flex structure for the style
487: -- selected exists in fnd_descr_flex_contents
488: --

Line 493: hr_utility.set_message(801, 'HR_7304_ADD_NO_FORMAT');

489: open csr_valid_flex_struc;
490: fetch csr_valid_flex_struc into l_exists;
491: if csr_valid_flex_struc%notfound then
492: close csr_valid_flex_struc;
493: hr_utility.set_message(801, 'HR_7304_ADD_NO_FORMAT');
494: hr_utility.raise_error;
495: end if;
496: close csr_valid_flex_struc;
497: hr_utility.set_location(l_proc, 3);

Line 494: hr_utility.raise_error;

490: fetch csr_valid_flex_struc into l_exists;
491: if csr_valid_flex_struc%notfound then
492: close csr_valid_flex_struc;
493: hr_utility.set_message(801, 'HR_7304_ADD_NO_FORMAT');
494: hr_utility.raise_error;
495: end if;
496: close csr_valid_flex_struc;
497: hr_utility.set_location(l_proc, 3);
498: --

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

493: hr_utility.set_message(801, 'HR_7304_ADD_NO_FORMAT');
494: hr_utility.raise_error;
495: end if;
496: close csr_valid_flex_struc;
497: hr_utility.set_location(l_proc, 3);
498: --
499: -- Only the style 'GB','US','JP' and 'GENERIC' are accepted by the API
500: --
501: if p_style <> 'GB'

Line 505: hr_utility.set_message(801, 'HR_7297_API_ARG_ONLY');

501: if p_style <> 'GB'
502: and p_style <> 'US'
503: and p_style <> 'JP'
504: and p_style <> 'GENERIC' then
505: hr_utility.set_message(801, 'HR_7297_API_ARG_ONLY');
506: hr_utility.set_message_token('ARG_NAME', 'ADDRESS_STYLE');
507: hr_utility.set_message_token('ARG_ONLY', 'GB, US, JP or GENERIC');
508: hr_utility.raise_error;
509: end if;

Line 506: hr_utility.set_message_token('ARG_NAME', 'ADDRESS_STYLE');

502: and p_style <> 'US'
503: and p_style <> 'JP'
504: and p_style <> 'GENERIC' then
505: hr_utility.set_message(801, 'HR_7297_API_ARG_ONLY');
506: hr_utility.set_message_token('ARG_NAME', 'ADDRESS_STYLE');
507: hr_utility.set_message_token('ARG_ONLY', 'GB, US, JP or GENERIC');
508: hr_utility.raise_error;
509: end if;
510: --

Line 507: hr_utility.set_message_token('ARG_ONLY', 'GB, US, JP or GENERIC');

503: and p_style <> 'JP'
504: and p_style <> 'GENERIC' then
505: hr_utility.set_message(801, 'HR_7297_API_ARG_ONLY');
506: hr_utility.set_message_token('ARG_NAME', 'ADDRESS_STYLE');
507: hr_utility.set_message_token('ARG_ONLY', 'GB, US, JP or GENERIC');
508: hr_utility.raise_error;
509: end if;
510: --
511: hr_utility.set_location(' Leaving:'|| l_proc, 4);

Line 508: hr_utility.raise_error;

504: and p_style <> 'GENERIC' then
505: hr_utility.set_message(801, 'HR_7297_API_ARG_ONLY');
506: hr_utility.set_message_token('ARG_NAME', 'ADDRESS_STYLE');
507: hr_utility.set_message_token('ARG_ONLY', 'GB, US, JP or GENERIC');
508: hr_utility.raise_error;
509: end if;
510: --
511: hr_utility.set_location(' Leaving:'|| l_proc, 4);
512: end chk_style;

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

507: hr_utility.set_message_token('ARG_ONLY', 'GB, US, JP or GENERIC');
508: hr_utility.raise_error;
509: end if;
510: --
511: hr_utility.set_location(' Leaving:'|| l_proc, 4);
512: end chk_style;
513: --
514: -- ---------------------------------------------------------------------------
515: -- |----------------------< chk_style_null_attr >---------------------------|

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

560: l_proc varchar2(72) := g_package||'chk_style_null_attr';
561: --
562: --
563: begin
564: hr_utility.set_location('Entering:'|| l_proc, 1);
565: --
566: -- Check 'GB' address style
567: --
568: if p_style = 'GB' then

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

576: l_token := 'telephone_number_3';
577: raise l_error;
578: end if;
579: --
580: hr_utility.set_location(l_proc, 2);
581: --
582: -- Check 'US' address style
583: --
584: elsif p_style = 'US' then

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

619: raise l_error;
620: --
621: end if;
622: --
623: hr_utility.set_location(l_proc, 3);
624: --
625: -- Check 'GENERIC' address style
626: --
627: elsif p_style = 'GENERIC' then

Line 636: hr_utility.set_message(801, 'HR_7324_ADD_ADD_ATTRIBUTE_NULL');

632: end if;
633: --
634: exception
635: when l_error then
636: hr_utility.set_message(801, 'HR_7324_ADD_ADD_ATTRIBUTE_NULL');
637: hr_utility.set_message_token('ARGUMENT', l_token);
638: hr_utility.raise_error;
639: when others then
640: raise;

Line 637: hr_utility.set_message_token('ARGUMENT', l_token);

633: --
634: exception
635: when l_error then
636: hr_utility.set_message(801, 'HR_7324_ADD_ADD_ATTRIBUTE_NULL');
637: hr_utility.set_message_token('ARGUMENT', l_token);
638: hr_utility.raise_error;
639: when others then
640: raise;
641: --

Line 638: hr_utility.raise_error;

634: exception
635: when l_error then
636: hr_utility.set_message(801, 'HR_7324_ADD_ADD_ATTRIBUTE_NULL');
637: hr_utility.set_message_token('ARGUMENT', l_token);
638: hr_utility.raise_error;
639: when others then
640: raise;
641: --
642: -- 09/12/97 Change Ends

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

639: when others then
640: raise;
641: --
642: -- 09/12/97 Change Ends
643: hr_utility.set_location(' Leaving:'|| l_proc, 4);
644:
645: end chk_style_null_attr;
646: --
647: -- ---------------------------------------------------------------------------

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

684: l_proc varchar2(72) := g_package||'chk_address_line1';
685: l_api_updating boolean;
686:
687: begin
688: hr_utility.set_location('Entering:'|| l_proc, 1);
689: --
690: -- Check mandatory parameters have been set
691: --
692: hr_api.mandatory_arg_error

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

706: if ((l_api_updating and
707: nvl(per_kad_shd.g_old_rec.address_line1, hr_api.g_varchar2) <>
708: nvl(p_address_line1, hr_api.g_varchar2)) or
709: (NOT l_api_updating)) then
710: hr_utility.set_location(l_proc, 2);
711: --
712: -- Check that value for address_line1 is not null for 'US' and 'GB'
713: -- style.
714: --

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

714: --
715: if p_style = 'GB' or
716: p_style = 'US' then
717: --
718: hr_utility.set_location(l_proc, 3);
719: --
720: if p_address_line1 is null then
721: --
722: hr_utility.set_message(801, 'HR_51233_ADD_ADD_LINE1_REQ');

Line 722: hr_utility.set_message(801, 'HR_51233_ADD_ADD_LINE1_REQ');

718: hr_utility.set_location(l_proc, 3);
719: --
720: if p_address_line1 is null then
721: --
722: hr_utility.set_message(801, 'HR_51233_ADD_ADD_LINE1_REQ');
723: hr_utility.raise_error;
724: end if;
725: --
726: end if;

Line 723: hr_utility.raise_error;

719: --
720: if p_address_line1 is null then
721: --
722: hr_utility.set_message(801, 'HR_51233_ADD_ADD_LINE1_REQ');
723: hr_utility.raise_error;
724: end if;
725: --
726: end if;
727: --

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

725: --
726: end if;
727: --
728: end if;
729: hr_utility.set_location(' Leaving:'|| l_proc, 5);
730: end chk_address_line1;
731: --
732: -- ----------------------------------------------------------------------------
733: -- |------------------------< chk_half_kana >---------------------------------|

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

742:
743: begin
744: -- make sure that all the characters are half kana kana
745:
746: hr_utility.set_location('Entering:'|| l_proc, 1);
747:
748: while i <= l_strlen and l_correct loop
749: l_ch := substr(p_string, i, 1);
750: if l_ch between ' ' and '~' then

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

754: end if;
755: i := i + 1;
756: end loop;
757:
758: hr_utility.set_location(l_proc, 2);
759:
760: if not l_correct then
761: hr_utility.set_message(801, 'HR_51692_ADD_INVALID_KANA');
762: hr_utility.raise_error;

Line 761: hr_utility.set_message(801, 'HR_51692_ADD_INVALID_KANA');

757:
758: hr_utility.set_location(l_proc, 2);
759:
760: if not l_correct then
761: hr_utility.set_message(801, 'HR_51692_ADD_INVALID_KANA');
762: hr_utility.raise_error;
763: end if;
764: hr_utility.set_location(' Leaving:'|| l_proc, 3);
765: end chk_half_kana;

Line 762: hr_utility.raise_error;

758: hr_utility.set_location(l_proc, 2);
759:
760: if not l_correct then
761: hr_utility.set_message(801, 'HR_51692_ADD_INVALID_KANA');
762: hr_utility.raise_error;
763: end if;
764: hr_utility.set_location(' Leaving:'|| l_proc, 3);
765: end chk_half_kana;
766: --

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

760: if not l_correct then
761: hr_utility.set_message(801, 'HR_51692_ADD_INVALID_KANA');
762: hr_utility.raise_error;
763: end if;
764: hr_utility.set_location(' Leaving:'|| l_proc, 3);
765: end chk_half_kana;
766: --
767: -- ----------------------------------------------------------------------------
768: -- |--------------------------------------------|

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

788: l_api_updating boolean;
789: l_proc varchar2(72) := g_package||'chk_address1_towncity_comb';
790:
791: begin
792: hr_utility.set_location('Entering:'|| l_proc, 1);
793:
794: -- Only proceed with validation if :
795: -- a) The current g_old_rec is current and
796: -- b) The value for town_or_city, address_line1, or region_1 have changed

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

807: nvl(per_kad_shd_t.g_old_rec.region_1, hr_api.g_varchar2) <>
808: nvl(p_region_1, hr_api.g_varchar2)
809: )) or (NOT l_api_updating)) then
810:
811: hr_utility.set_location(l_proc, 2);
812:
813: if p_town_or_city is not NULL then
814: hr_utility.set_location(l_proc, 3);
815: open c1;

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

810:
811: hr_utility.set_location(l_proc, 2);
812:
813: if p_town_or_city is not NULL then
814: hr_utility.set_location(l_proc, 3);
815: open c1;
816: fetch c1 into jp_address_rec;
817: if c1%notfound then
818: hr_utility.set_message(801, 'HR_51693_ADD_INVALID_DISTCODE');

Line 818: hr_utility.set_message(801, 'HR_51693_ADD_INVALID_DISTCODE');

814: hr_utility.set_location(l_proc, 3);
815: open c1;
816: fetch c1 into jp_address_rec;
817: if c1%notfound then
818: hr_utility.set_message(801, 'HR_51693_ADD_INVALID_DISTCODE');
819: hr_utility.raise_error;
820: end if;
821: close c1;
822:

Line 819: hr_utility.raise_error;

815: open c1;
816: fetch c1 into jp_address_rec;
817: if c1%notfound then
818: hr_utility.set_message(801, 'HR_51693_ADD_INVALID_DISTCODE');
819: hr_utility.raise_error;
820: end if;
821: close c1;
822:
823: if p_address_line1 is not null and

Line 826: hr_utility.set_message(801, 'HR_51694_ADD_INVALID_ADD_LINE1');

822:
823: if p_address_line1 is not null and
824: p_address_line1 <> jp_address_rec.address_line1 then
825:
826: hr_utility.set_message(801, 'HR_51694_ADD_INVALID_ADD_LINE1');
827: hr_utility.raise_error;
828: end if;
829: p_address_line1 := jp_address_rec.address_line1;
830:

Line 827: hr_utility.raise_error;

823: if p_address_line1 is not null and
824: p_address_line1 <> jp_address_rec.address_line1 then
825:
826: hr_utility.set_message(801, 'HR_51694_ADD_INVALID_ADD_LINE1');
827: hr_utility.raise_error;
828: end if;
829: p_address_line1 := jp_address_rec.address_line1;
830:
831: elsif p_address_line1 is not NULL then

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

828: end if;
829: p_address_line1 := jp_address_rec.address_line1;
830:
831: elsif p_address_line1 is not NULL then
832: hr_utility.set_location(l_proc, 4);
833: open c2;
834: fetch c2 into jp_address_rec;
835: if c2%notfound then
836: hr_utility.set_message(801, 'HR_51694_ADD_INVALID_ADD_LINE1');

Line 836: hr_utility.set_message(801, 'HR_51694_ADD_INVALID_ADD_LINE1');

832: hr_utility.set_location(l_proc, 4);
833: open c2;
834: fetch c2 into jp_address_rec;
835: if c2%notfound then
836: hr_utility.set_message(801, 'HR_51694_ADD_INVALID_ADD_LINE1');
837: hr_utility.raise_error;
838: end if;
839: close c2;
840: p_town_or_city := jp_address_rec.district_code;

Line 837: hr_utility.raise_error;

833: open c2;
834: fetch c2 into jp_address_rec;
835: if c2%notfound then
836: hr_utility.set_message(801, 'HR_51694_ADD_INVALID_ADD_LINE1');
837: hr_utility.raise_error;
838: end if;
839: close c2;
840: p_town_or_city := jp_address_rec.district_code;
841:

Line 843: hr_utility.set_message(801, 'HR_51695_ADD_DIST_ADD1_NULL');

839: close c2;
840: p_town_or_city := jp_address_rec.district_code;
841:
842: else
843: hr_utility.set_message(801, 'HR_51695_ADD_DIST_ADD1_NULL');
844: hr_utility.raise_error;
845: end if;
846:
847: if p_region_1 is not null and p_region_1 <>

Line 844: hr_utility.raise_error;

840: p_town_or_city := jp_address_rec.district_code;
841:
842: else
843: hr_utility.set_message(801, 'HR_51695_ADD_DIST_ADD1_NULL');
844: hr_utility.raise_error;
845: end if;
846:
847: if p_region_1 is not null and p_region_1 <>
848: jp_address_rec.address_line1_kana then

Line 849: hr_utility.set_message(801, 'HR_51696_ADD_INVALID_ADD1_KANA');

845: end if;
846:
847: if p_region_1 is not null and p_region_1 <>
848: jp_address_rec.address_line1_kana then
849: hr_utility.set_message(801, 'HR_51696_ADD_INVALID_ADD1_KANA');
850: hr_utility.raise_error;
851: end if;
852: p_region_1 := jp_address_rec.address_line1_kana;
853: end if;

Line 850: hr_utility.raise_error;

846:
847: if p_region_1 is not null and p_region_1 <>
848: jp_address_rec.address_line1_kana then
849: hr_utility.set_message(801, 'HR_51696_ADD_INVALID_ADD1_KANA');
850: hr_utility.raise_error;
851: end if;
852: p_region_1 := jp_address_rec.address_line1_kana;
853: end if;
854: hr_utility.set_location('Leaving:'|| l_proc, 5);

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

850: hr_utility.raise_error;
851: end if;
852: p_region_1 := jp_address_rec.address_line1_kana;
853: end if;
854: hr_utility.set_location('Leaving:'|| l_proc, 5);
855: end chk_address1_towncity_comb;
856: --
857: -- ----------------------------------------------------------------------------
858: -- |---------------------------------------------|

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

870: l_api_updating boolean;
871: l_proc varchar2(72) := g_package||'chk_address2_region2_comb';
872:
873: begin
874: hr_utility.set_location('Entering:'|| l_proc, 1);
875:
876: -- Only proceed with validation if :
877: -- a) The current g_old_rec is current and
878: -- b) The value for address_line2, or region_2 have changed

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

887: nvl(per_kad_shd_t.g_old_rec.region_2, hr_api.g_varchar2) <>
888: nvl(p_region_2, hr_api.g_varchar2)
889: )) or (NOT l_api_updating)) then
890:
891: hr_utility.set_location(l_proc, 2);
892:
893: if p_address_line2 is NULL and p_region_2 is not NULL then
894: hr_utility.set_message(801, 'HR_51697_ADD_REGION2_NOT_NULL');
895: hr_utility.raise_error;

Line 894: hr_utility.set_message(801, 'HR_51697_ADD_REGION2_NOT_NULL');

890:
891: hr_utility.set_location(l_proc, 2);
892:
893: if p_address_line2 is NULL and p_region_2 is not NULL then
894: hr_utility.set_message(801, 'HR_51697_ADD_REGION2_NOT_NULL');
895: hr_utility.raise_error;
896: end if;
897: chk_half_kana(p_region_2);
898: end if;

Line 895: hr_utility.raise_error;

891: hr_utility.set_location(l_proc, 2);
892:
893: if p_address_line2 is NULL and p_region_2 is not NULL then
894: hr_utility.set_message(801, 'HR_51697_ADD_REGION2_NOT_NULL');
895: hr_utility.raise_error;
896: end if;
897: chk_half_kana(p_region_2);
898: end if;
899:

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

896: end if;
897: chk_half_kana(p_region_2);
898: end if;
899:
900: hr_utility.set_location('Leaving:'|| l_proc, 3);
901: end chk_address2_region2_comb;
902: --
903: -- ----------------------------------------------------------------------------
904: -- |---------------------------------------------|

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

916: l_api_updating boolean;
917: l_proc varchar2(72) := g_package||'chk_address3_region3_comb';
918:
919: begin
920: hr_utility.set_location('Entering:'|| l_proc, 1);
921:
922: -- Only proceed with validation if :
923: -- a) The current g_old_rec is current and
924: -- b) The value for address_line3, or region_3 have changed

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

933: nvl(per_kad_shd_t.g_old_rec.region_3, hr_api.g_varchar2) <>
934: nvl(p_region_3, hr_api.g_varchar2)
935: )) or (NOT l_api_updating)) then
936:
937: hr_utility.set_location(l_proc, 2);
938:
939: if p_address_line3 is NULL and p_region_3 is not NULL then
940: hr_utility.set_message(801, 'HR_51698_ADD_REGION3_NOT_NULL');
941: hr_utility.raise_error;

Line 940: hr_utility.set_message(801, 'HR_51698_ADD_REGION3_NOT_NULL');

936:
937: hr_utility.set_location(l_proc, 2);
938:
939: if p_address_line3 is NULL and p_region_3 is not NULL then
940: hr_utility.set_message(801, 'HR_51698_ADD_REGION3_NOT_NULL');
941: hr_utility.raise_error;
942: end if;
943: chk_half_kana(p_region_3);
944: end if;

Line 941: hr_utility.raise_error;

937: hr_utility.set_location(l_proc, 2);
938:
939: if p_address_line3 is NULL and p_region_3 is not NULL then
940: hr_utility.set_message(801, 'HR_51698_ADD_REGION3_NOT_NULL');
941: hr_utility.raise_error;
942: end if;
943: chk_half_kana(p_region_3);
944: end if;
945:

Line 946: hr_utility.set_location('Leaving:'|| l_proc, 1);

942: end if;
943: chk_half_kana(p_region_3);
944: end if;
945:
946: hr_utility.set_location('Leaving:'|| l_proc, 1);
947: end chk_address3_region3_comb;
948: */
949: --
950: -- ----------------------------------------------------------------------------

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

958: l_strlen number := length(p_string);
959: l_proc varchar2(72) := g_package||'chk_jp_postal_code';
960:
961: begin
962: hr_utility.set_location('Entering:'|| l_proc, 1);
963:
964: if l_strlen <> 3 and l_strlen <> 6 then
965: hr_utility.set_message(801, 'HR_51699_ADD_');
966: hr_utility.raise_error;

Line 965: hr_utility.set_message(801, 'HR_51699_ADD_');

961: begin
962: hr_utility.set_location('Entering:'|| l_proc, 1);
963:
964: if l_strlen <> 3 and l_strlen <> 6 then
965: hr_utility.set_message(801, 'HR_51699_ADD_');
966: hr_utility.raise_error;
967: end if;
968:
969: -- checking the first 3 characters

Line 966: hr_utility.raise_error;

962: hr_utility.set_location('Entering:'|| l_proc, 1);
963:
964: if l_strlen <> 3 and l_strlen <> 6 then
965: hr_utility.set_message(801, 'HR_51699_ADD_');
966: hr_utility.raise_error;
967: end if;
968:
969: -- checking the first 3 characters
970:

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

967: end if;
968:
969: -- checking the first 3 characters
970:
971: hr_utility.set_location(l_proc, 2);
972: for i in 1..3 loop
973: if substr(p_string, i, 1) between '0' and '9' then
974: NULL;
975: else

Line 976: hr_utility.set_message(801, 'HR_51699_ADD_INVALID_POST_CODE');

972: for i in 1..3 loop
973: if substr(p_string, i, 1) between '0' and '9' then
974: NULL;
975: else
976: hr_utility.set_message(801, 'HR_51699_ADD_INVALID_POST_CODE');
977: hr_utility.raise_error;
978: end if;
979: end loop;
980:

Line 977: hr_utility.raise_error;

973: if substr(p_string, i, 1) between '0' and '9' then
974: NULL;
975: else
976: hr_utility.set_message(801, 'HR_51699_ADD_INVALID_POST_CODE');
977: hr_utility.raise_error;
978: end if;
979: end loop;
980:
981: if l_strlen = 6 then

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

978: end if;
979: end loop;
980:
981: if l_strlen = 6 then
982: hr_utility.set_location(l_proc, 3);
983:
984: -- checking the 4th character
985:
986: l_ch := substr(p_string, 4, 1);

Line 990: hr_utility.set_message(801, 'HR_51699_ADD_INVALID_POST_CODE');

986: l_ch := substr(p_string, 4, 1);
987: if l_ch = '-' then
988: NULL;
989: else
990: hr_utility.set_message(801, 'HR_51699_ADD_INVALID_POST_CODE');
991: hr_utility.raise_error;
992: end if;
993:
994: -- checking the last 2 characters

Line 991: hr_utility.raise_error;

987: if l_ch = '-' then
988: NULL;
989: else
990: hr_utility.set_message(801, 'HR_51699_ADD_INVALID_POST_CODE');
991: hr_utility.raise_error;
992: end if;
993:
994: -- checking the last 2 characters
995:

Line 1000: hr_utility.set_message(801, 'HR_51699_ADD_INVALID_POST_CODE');

996: for i in 5..6 loop
997: if substr(p_string, i, 1) between '0' and '9' then
998: NULL;
999: else
1000: hr_utility.set_message(801, 'HR_51699_ADD_INVALID_POST_CODE');
1001: hr_utility.raise_error;
1002: end if;
1003: end loop;
1004: end if;

Line 1001: hr_utility.raise_error;

997: if substr(p_string, i, 1) between '0' and '9' then
998: NULL;
999: else
1000: hr_utility.set_message(801, 'HR_51699_ADD_INVALID_POST_CODE');
1001: hr_utility.raise_error;
1002: end if;
1003: end loop;
1004: end if;
1005:

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

1002: end if;
1003: end loop;
1004: end if;
1005:
1006: hr_utility.set_location(' Leaving:'|| l_proc, 4);
1007: end chk_jp_postal_code;
1008: --
1009: -- ---------------------------------------------------------------------------
1010: -- |---------------------------< chk_postal_code >--------------------------|

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

1060: l_postal_code_3 varchar2(4);
1061: l_geocodes_installed varchar2(1); -- 09/12/97 Changed
1062: --
1063: begin
1064: hr_utility.set_location('Entering:'|| l_proc, 1);
1065: --
1066: -- Check mandatory parameters have been set
1067: --
1068: hr_api.mandatory_arg_error

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

1082: if ((l_api_updating
1083: and nvl(per_kad_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1084: nvl(p_postal_code, hr_api.g_varchar2)) or
1085: (NOT l_api_updating)) then
1086: hr_utility.set_location(l_proc, 2);
1087: --
1088: -- Check if US payroll is installed.
1089: --
1090: -- 09/12/97 Change Begins

Line 1101: hr_utility.set_message(801, 'HR_7306_ADD_POST_CODE');

1097: -- 8 characters long
1098: --
1099: if p_style = 'GB' then
1100: if length(p_postal_code) > 8 then
1101: hr_utility.set_message(801, 'HR_7306_ADD_POST_CODE');
1102: hr_utility.raise_error;
1103: end if;
1104: --
1105: -- Check that the US postal code is either 5 or 10 character

Line 1102: hr_utility.raise_error;

1098: --
1099: if p_style = 'GB' then
1100: if length(p_postal_code) > 8 then
1101: hr_utility.set_message(801, 'HR_7306_ADD_POST_CODE');
1102: hr_utility.raise_error;
1103: end if;
1104: --
1105: -- Check that the US postal code is either 5 or 10 character
1106: --

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

1104: --
1105: -- Check that the US postal code is either 5 or 10 character
1106: --
1107: elsif p_style = 'US' then
1108: hr_utility.set_location(l_proc, 3);
1109: --
1110: begin
1111: --
1112: if length(p_postal_code) = 5 then

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

1109: --
1110: begin
1111: --
1112: if length(p_postal_code) = 5 then
1113: hr_utility.set_location(l_proc, 4);
1114: --
1115: -- Check if zip code is all numbers
1116: --
1117: for i in 1..5 loop

Line 1120: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');

1116: --
1117: for i in 1..5 loop
1118: if(substr(p_postal_code,i,1)
1119: not between '0' and '9') then
1120: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1121: hr_utility.raise_error;
1122: end if;
1123: end loop;
1124: --

Line 1121: hr_utility.raise_error;

1117: for i in 1..5 loop
1118: if(substr(p_postal_code,i,1)
1119: not between '0' and '9') then
1120: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1121: hr_utility.raise_error;
1122: end if;
1123: end loop;
1124: --
1125: elsif length(p_postal_code) = 10 then

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

1122: end if;
1123: end loop;
1124: --
1125: elsif length(p_postal_code) = 10 then
1126: hr_utility.set_location(l_proc, 5);
1127: --
1128: -- Parse zip code to validate for correct format.
1129: --
1130: l_postal_code_1 := substr(p_postal_code,1,5);

Line 1139: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');

1135: --
1136: for i in 1..5 loop
1137: if(substr(l_postal_code_1,i,1)
1138: not between '0' and '9') then
1139: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1140: hr_utility.raise_error;
1141: end if;
1142: end loop;
1143: hr_utility.set_location(l_proc, 6);

Line 1140: hr_utility.raise_error;

1136: for i in 1..5 loop
1137: if(substr(l_postal_code_1,i,1)
1138: not between '0' and '9') then
1139: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1140: hr_utility.raise_error;
1141: end if;
1142: end loop;
1143: hr_utility.set_location(l_proc, 6);
1144: --

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

1139: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1140: hr_utility.raise_error;
1141: end if;
1142: end loop;
1143: hr_utility.set_location(l_proc, 6);
1144: --
1145: -- Validate last 4 characters are numbers
1146: --
1147: for i in 1..4 loop

Line 1150: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');

1146: --
1147: for i in 1..4 loop
1148: if(substr(l_postal_code_3,i,1)
1149: not between '0' and '9') then
1150: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1151: hr_utility.raise_error;
1152: end if;
1153: end loop;
1154: hr_utility.set_location(l_proc, 7);

Line 1151: hr_utility.raise_error;

1147: for i in 1..4 loop
1148: if(substr(l_postal_code_3,i,1)
1149: not between '0' and '9') then
1150: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1151: hr_utility.raise_error;
1152: end if;
1153: end loop;
1154: hr_utility.set_location(l_proc, 7);
1155: --

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

1150: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1151: hr_utility.raise_error;
1152: end if;
1153: end loop;
1154: hr_utility.set_location(l_proc, 7);
1155: --
1156: -- Validate last sixth characters is '-'
1157: --
1158: if l_postal_code_2 <> '-' then

Line 1159: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');

1155: --
1156: -- Validate last sixth characters is '-'
1157: --
1158: if l_postal_code_2 <> '-' then
1159: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1160: hr_utility.raise_error;
1161: end if;
1162:
1163: else

Line 1160: hr_utility.raise_error;

1156: -- Validate last sixth characters is '-'
1157: --
1158: if l_postal_code_2 <> '-' then
1159: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1160: hr_utility.raise_error;
1161: end if;
1162:
1163: else
1164: --

Line 1167: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');

1163: else
1164: --
1165: -- If zip code is not 5 or 10 character long
1166: --
1167: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1168: hr_utility.raise_error;
1169: end if;
1170: --
1171: -- If an invalid zip code character generates an

Line 1168: hr_utility.raise_error;

1164: --
1165: -- If zip code is not 5 or 10 character long
1166: --
1167: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1168: hr_utility.raise_error;
1169: end if;
1170: --
1171: -- If an invalid zip code character generates an
1172: -- exception

Line 1176: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');

1172: -- exception
1173: --
1174: exception
1175: when others then
1176: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1177: hr_utility.raise_error;
1178: end;
1179: /* elsif p_style = 'JP' then
1180: hr_utility.set_location(l_proc, 8);

Line 1177: hr_utility.raise_error;

1173: --
1174: exception
1175: when others then
1176: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1177: hr_utility.raise_error;
1178: end;
1179: /* elsif p_style = 'JP' then
1180: hr_utility.set_location(l_proc, 8);
1181: chk_jp_postal_code(p_postal_code); */

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

1176: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1177: hr_utility.raise_error;
1178: end;
1179: /* elsif p_style = 'JP' then
1180: hr_utility.set_location(l_proc, 8);
1181: chk_jp_postal_code(p_postal_code); */
1182: end if;
1183: --
1184: -- If style is US and US payroll is installed, postal_code is mandatory.

Line 1189: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');

1185: --
1186: else
1187: if p_style = 'US'
1188: and l_geocodes_installed = 'Y' then -- 09/12/97 Changed
1189: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1190: hr_utility.raise_error;
1191: end if;
1192: end if;
1193: end if;

Line 1190: hr_utility.raise_error;

1186: else
1187: if p_style = 'US'
1188: and l_geocodes_installed = 'Y' then -- 09/12/97 Changed
1189: hr_utility.set_message(801, 'HR_51195_ADD_INVALID_ZIP_CODE');
1190: hr_utility.raise_error;
1191: end if;
1192: end if;
1193: end if;
1194: --

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

1191: end if;
1192: end if;
1193: end if;
1194: --
1195: hr_utility.set_location(' Leaving:'|| l_proc, 9);
1196: end chk_postal_code;
1197: --
1198: -- ---------------------------------------------------------------------------
1199: -- |---------------------------< chk_region_1 >-----------------------------|

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

1248: from pay_us_counties
1249: where county_name = p_region_1;
1250: --
1251: begin
1252: hr_utility.set_location('Entering:'|| l_proc, 1);
1253: --
1254: -- Check mandatory parameters have been set
1255: --
1256: hr_api.mandatory_arg_error

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

1276: if ((l_api_updating and
1277: nvl(per_kad_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1278: nvl(p_region_1, hr_api.g_varchar2)) or
1279: (NOT l_api_updating)) then
1280: hr_utility.set_location(l_proc, 2);
1281: --
1282: -- Check that value for region_1 is valid
1283: --
1284: if p_region_1 is not null then

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

1281: --
1282: -- Check that value for region_1 is valid
1283: --
1284: if p_region_1 is not null then
1285: hr_utility.set_location(l_proc, 3);
1286: --
1287: if p_style = 'GB' then
1288: hr_utility.set_location(l_proc, 4);
1289: --

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

1284: if p_region_1 is not null then
1285: hr_utility.set_location(l_proc, 3);
1286: --
1287: if p_style = 'GB' then
1288: hr_utility.set_location(l_proc, 4);
1289: --
1290: if hr_api.not_exists_in_hr_lookups
1291: (p_effective_date => p_effective_date
1292: ,p_lookup_type => 'GB_COUNTY'

Line 1297: hr_utility.set_message(801, 'HR_7307_ADD_GB_REGION_1');

1293: ,p_lookup_code => p_region_1
1294: ) then
1295: --
1296: -- Error: Invalid region 1.
1297: hr_utility.set_message(801, 'HR_7307_ADD_GB_REGION_1');
1298: hr_utility.raise_error;
1299: end if;
1300: end if;
1301: --

Line 1298: hr_utility.raise_error;

1294: ) then
1295: --
1296: -- Error: Invalid region 1.
1297: hr_utility.set_message(801, 'HR_7307_ADD_GB_REGION_1');
1298: hr_utility.raise_error;
1299: end if;
1300: end if;
1301: --
1302: -- Style is US and payroll is installed under US legislation.

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

1306: --
1307: -- If US payroll is installed.
1308: --
1309: if hr_general.chk_geocodes_installed = 'Y' then -- 09/12/97 Chg
1310: hr_utility.set_location(l_proc, 5);
1311: open csr_valid_us_county;
1312: fetch csr_valid_us_county into l_exists;
1313: if csr_valid_us_county%notfound then
1314: close csr_valid_us_county;

Line 1315: hr_utility.set_message(801, 'HR_7953_ADDR_NO_COUNTY_FOUND');

1311: open csr_valid_us_county;
1312: fetch csr_valid_us_county into l_exists;
1313: if csr_valid_us_county%notfound then
1314: close csr_valid_us_county;
1315: hr_utility.set_message(801, 'HR_7953_ADDR_NO_COUNTY_FOUND');
1316: hr_utility.raise_error;
1317: end if;
1318: end if;
1319: end if;

Line 1316: hr_utility.raise_error;

1312: fetch csr_valid_us_county into l_exists;
1313: if csr_valid_us_county%notfound then
1314: close csr_valid_us_county;
1315: hr_utility.set_message(801, 'HR_7953_ADDR_NO_COUNTY_FOUND');
1316: hr_utility.raise_error;
1317: end if;
1318: end if;
1319: end if;
1320: --

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

1320: --
1321: end if;
1322: --
1323: end if;
1324: hr_utility.set_location(' Leaving:'|| l_proc, 6);
1325: end chk_region_1;
1326: --
1327: -- ---------------------------------------------------------------------------
1328: -- |---------------------------< chk_region_2 >-----------------------------|

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

1380: from pay_us_states
1381: where state_abbrev = p_region_2;
1382: --
1383: begin
1384: hr_utility.set_location('Entering:'|| l_proc, 1);
1385: --
1386: -- Check mandatory parameters have been set.
1387: --
1388: hr_api.mandatory_arg_error

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

1408: if ((l_api_updating and
1409: nvl(per_kad_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1410: nvl(p_region_2, hr_api.g_varchar2)) or
1411: (NOT l_api_updating)) then
1412: hr_utility.set_location(l_proc, 2);
1413: --
1414: -- Check if US payroll is installed.
1415: --
1416: if p_style = 'US' then

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

1421: --
1422: -- Check that value for region_2 is valid.
1423: --
1424: if p_region_2 is not null then
1425: hr_utility.set_location(l_proc, 3);
1426: --
1427: if p_style = 'US'
1428: and l_geocodes_installed = 'N' then -- 09/12/97 Changed
1429: hr_utility.set_location(l_proc, 4);

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

1425: hr_utility.set_location(l_proc, 3);
1426: --
1427: if p_style = 'US'
1428: and l_geocodes_installed = 'N' then -- 09/12/97 Changed
1429: hr_utility.set_location(l_proc, 4);
1430: --
1431: if hr_api.not_exists_in_hr_lookups
1432: (p_effective_date => p_effective_date
1433: ,p_lookup_type => 'US_STATE'

Line 1438: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');

1434: ,p_lookup_code => p_region_2
1435: ) then
1436: --
1437: -- Error: Invalid region 2.
1438: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');
1439: hr_utility.raise_error;
1440: end if;
1441: end if;
1442: end if;

Line 1439: hr_utility.raise_error;

1435: ) then
1436: --
1437: -- Error: Invalid region 2.
1438: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');
1439: hr_utility.raise_error;
1440: end if;
1441: end if;
1442: end if;
1443: --

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

1444: -- If payroll is installed under US legislation.
1445: --
1446: if p_style = 'US'
1447: and l_geocodes_installed = 'Y' then -- 09/12/97 Changed
1448: hr_utility.set_location(l_proc, 5);
1449: --
1450: open csr_valid_state;
1451: fetch csr_valid_state into l_exists;
1452: if csr_valid_state%notfound then

Line 1454: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');

1450: open csr_valid_state;
1451: fetch csr_valid_state into l_exists;
1452: if csr_valid_state%notfound then
1453: close csr_valid_state;
1454: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');
1455: hr_utility.raise_error;
1456: end if;
1457: close csr_valid_state;
1458: end if;

Line 1455: hr_utility.raise_error;

1451: fetch csr_valid_state into l_exists;
1452: if csr_valid_state%notfound then
1453: close csr_valid_state;
1454: hr_utility.set_message(801, 'HR_7952_ADDR_NO_STATE_CODE');
1455: hr_utility.raise_error;
1456: end if;
1457: close csr_valid_state;
1458: end if;
1459: --

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

1458: end if;
1459: --
1460: end if;
1461: --
1462: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1463: end chk_region_2;
1464: --
1465: -- ---------------------------------------------------------------------------
1466: -- |---------------------------< chk_town_or_city >--------------------------|

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

1513: select null
1514: from pay_us_city_names
1515: where city_name = p_town_or_city;
1516: begin
1517: hr_utility.set_location('Entering:'|| l_proc, 1);
1518: --
1519: -- Check mandatory parameters have been set
1520: --
1521: hr_api.mandatory_arg_error

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

1535: if ((l_api_updating and
1536: nvl(per_kad_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1537: nvl(p_town_or_city, hr_api.g_varchar2)) or
1538: (NOT l_api_updating)) then
1539: hr_utility.set_location(l_proc, 2);
1540: --
1541: --
1542: hr_utility.set_location(l_proc, 3);
1543: --

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

1538: (NOT l_api_updating)) then
1539: hr_utility.set_location(l_proc, 2);
1540: --
1541: --
1542: hr_utility.set_location(l_proc, 3);
1543: --
1544: if p_style = 'US' then
1545: --
1546: -- If US payroll is installed.

Line 1553: hr_utility.set_message(801, 'HR_51276_ADD_INVALID_CITY');

1549: open csr_valid_town_or_city;
1550: fetch csr_valid_town_or_city into l_exists;
1551: if csr_valid_town_or_city%notfound then
1552: close csr_valid_town_or_city;
1553: hr_utility.set_message(801, 'HR_51276_ADD_INVALID_CITY');
1554: hr_utility.raise_error;
1555: end if;
1556: hr_utility.set_location(l_proc, 4);
1557: --

Line 1554: hr_utility.raise_error;

1550: fetch csr_valid_town_or_city into l_exists;
1551: if csr_valid_town_or_city%notfound then
1552: close csr_valid_town_or_city;
1553: hr_utility.set_message(801, 'HR_51276_ADD_INVALID_CITY');
1554: hr_utility.raise_error;
1555: end if;
1556: hr_utility.set_location(l_proc, 4);
1557: --
1558: close csr_valid_town_or_city;

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

1552: close csr_valid_town_or_city;
1553: hr_utility.set_message(801, 'HR_51276_ADD_INVALID_CITY');
1554: hr_utility.raise_error;
1555: end if;
1556: hr_utility.set_location(l_proc, 4);
1557: --
1558: close csr_valid_town_or_city;
1559: end if;
1560: end if;

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

1558: close csr_valid_town_or_city;
1559: end if;
1560: end if;
1561: end if;
1562: hr_utility.set_location(' Leaving:'|| l_proc, 5);
1563: end chk_town_or_city;
1564: --
1565: -- ---------------------------------------------------------------------------
1566: -- |-------------------< chk_city_state_zip_comb >----------------------------|

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

1632: and l_postal_code between zip_start
1633: and zip_end;
1634: --
1635: begin
1636: hr_utility.set_location('Entering:'|| l_proc, 1);
1637: --
1638: -- Only proceed with validation if :
1639: -- a) US address style and payroll is installed under US legislation and
1640: -- b) The current g_old_rec is current and

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

1652: (nvl(per_kad_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1653: nvl(p_town_or_city, hr_api.g_varchar2))) or
1654: (NOT l_api_updating)) then
1655: --
1656: hr_utility.set_location(l_proc, 2);
1657: --
1658: -- Check if US payroll installed.
1659: --
1660: -- 09/12/97 Change Begins

Line 1674: hr_utility.set_message(801, 'HR_51771_ADD_CITY_NOT_IN_STATE');

1670: fetch csr_valid_city_state into l_city_code
1671: ,l_state_code;
1672: if csr_valid_city_state%notfound then
1673: close csr_valid_city_state;
1674: hr_utility.set_message(801, 'HR_51771_ADD_CITY_NOT_IN_STATE');
1675: hr_utility.raise_error;
1676: end if;
1677: close csr_valid_city_state;
1678: hr_utility.set_location(l_proc, 3);

Line 1675: hr_utility.raise_error;

1671: ,l_state_code;
1672: if csr_valid_city_state%notfound then
1673: close csr_valid_city_state;
1674: hr_utility.set_message(801, 'HR_51771_ADD_CITY_NOT_IN_STATE');
1675: hr_utility.raise_error;
1676: end if;
1677: close csr_valid_city_state;
1678: hr_utility.set_location(l_proc, 3);
1679: --

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

1674: hr_utility.set_message(801, 'HR_51771_ADD_CITY_NOT_IN_STATE');
1675: hr_utility.raise_error;
1676: end if;
1677: close csr_valid_city_state;
1678: hr_utility.set_location(l_proc, 3);
1679: --
1680: -- Check if zip code is valid for city and state.
1681: -- Only the first 5 characters are used.
1682: --

Line 1689: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');

1685: open csr_valid_zip_code;
1686: fetch csr_valid_zip_code into l_exists;
1687: if csr_valid_zip_code%notfound then
1688: close csr_valid_zip_code;
1689: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
1690: hr_utility.raise_error;
1691: end if;
1692: close csr_valid_zip_code;
1693: hr_utility.set_location(l_proc, 4);

Line 1690: hr_utility.raise_error;

1686: fetch csr_valid_zip_code into l_exists;
1687: if csr_valid_zip_code%notfound then
1688: close csr_valid_zip_code;
1689: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
1690: hr_utility.raise_error;
1691: end if;
1692: close csr_valid_zip_code;
1693: hr_utility.set_location(l_proc, 4);
1694: end if;

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

1689: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
1690: hr_utility.raise_error;
1691: end if;
1692: close csr_valid_zip_code;
1693: hr_utility.set_location(l_proc, 4);
1694: end if;
1695: --
1696: end if;
1697: hr_utility.set_location(' Leaving:'|| l_proc, 5);

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

1693: hr_utility.set_location(l_proc, 4);
1694: end if;
1695: --
1696: end if;
1697: hr_utility.set_location(' Leaving:'|| l_proc, 5);
1698: --
1699: end chk_city_state_zip_comb;
1700: --
1701: -- ---------------------------------------------------------------------------

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

1758: and pa2.primary_flag = 'Y');
1759: --
1760: begin
1761: l_date := nvl(per_kad_shd.g_old_rec.date_to, hr_api.g_eot);
1762: hr_utility.set_location('Entering:'|| l_proc, 1);
1763: --
1764: -- For primary addresses only
1765: -- ==========================
1766: --

Line 1779: hr_utility.set_message(801, 'HR_7308_ADD_PRIMARY_DEL');

1775: open csr_del_address;
1776: fetch csr_del_address into l_exists;
1777: if csr_del_address%found then
1778: close csr_del_address;
1779: hr_utility.set_message(801, 'HR_7308_ADD_PRIMARY_DEL');
1780: hr_utility.raise_error;
1781: end if;
1782: close csr_del_address;
1783: hr_utility.set_location(l_proc, 2);

Line 1780: hr_utility.raise_error;

1776: fetch csr_del_address into l_exists;
1777: if csr_del_address%found then
1778: close csr_del_address;
1779: hr_utility.set_message(801, 'HR_7308_ADD_PRIMARY_DEL');
1780: hr_utility.raise_error;
1781: end if;
1782: close csr_del_address;
1783: hr_utility.set_location(l_proc, 2);
1784: --

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

1779: hr_utility.set_message(801, 'HR_7308_ADD_PRIMARY_DEL');
1780: hr_utility.raise_error;
1781: end if;
1782: close csr_del_address;
1783: hr_utility.set_location(l_proc, 2);
1784: --
1785: -- Check that the deletion of a primary
1786: -- address does not break the contiguous
1787: -- nature of the address

Line 1793: hr_utility.set_message(801, 'HR_51030_ADDR_PRIM_GAP');

1789: open csr_no_del_contig_add;
1790: fetch csr_no_del_contig_add into l_exists;
1791: if csr_no_del_contig_add%found then
1792: close csr_no_del_contig_add;
1793: hr_utility.set_message(801, 'HR_51030_ADDR_PRIM_GAP');
1794: hr_utility.raise_error;
1795: end if;
1796: close csr_no_del_contig_add;
1797: end if;

Line 1794: hr_utility.raise_error;

1790: fetch csr_no_del_contig_add into l_exists;
1791: if csr_no_del_contig_add%found then
1792: close csr_no_del_contig_add;
1793: hr_utility.set_message(801, 'HR_51030_ADDR_PRIM_GAP');
1794: hr_utility.raise_error;
1795: end if;
1796: close csr_no_del_contig_add;
1797: end if;
1798: --

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

1795: end if;
1796: close csr_no_del_contig_add;
1797: end if;
1798: --
1799: hr_utility.set_location(' Leaving:'|| l_proc, 3);
1800: end chk_del_address;
1801: --
1802: -- ----------------------------------------------------------------------------
1803: -- |----------------------< check_non_updateable_args >-----------------------|

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

1832: l_error exception;
1833: l_argument varchar2(30);
1834: --
1835: Begin
1836: hr_utility.set_location('Entering:'||l_proc, 5);
1837: --
1838: -- Only proceed with validation if a row exists for
1839: -- the current record in the HR Schema
1840: --

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

1840: --
1841: if not per_kad_shd.api_updating
1842: (p_address_id => p_rec.address_id,
1843: p_object_version_number => p_rec.object_version_number) then
1844: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1845: hr_utility.set_message_token('PROCEDURE', l_proc);
1846: hr_utility.set_message_token('STEP', '5');
1847: end if;
1848: --

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

1841: if not per_kad_shd.api_updating
1842: (p_address_id => p_rec.address_id,
1843: p_object_version_number => p_rec.object_version_number) then
1844: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1845: hr_utility.set_message_token('PROCEDURE', l_proc);
1846: hr_utility.set_message_token('STEP', '5');
1847: end if;
1848: --
1849: hr_utility.set_location(l_proc, 6);

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

1842: (p_address_id => p_rec.address_id,
1843: p_object_version_number => p_rec.object_version_number) then
1844: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1845: hr_utility.set_message_token('PROCEDURE', l_proc);
1846: hr_utility.set_message_token('STEP', '5');
1847: end if;
1848: --
1849: hr_utility.set_location(l_proc, 6);
1850: --

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

1845: hr_utility.set_message_token('PROCEDURE', l_proc);
1846: hr_utility.set_message_token('STEP', '5');
1847: end if;
1848: --
1849: hr_utility.set_location(l_proc, 6);
1850: --
1851: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1852: per_kad_shd.g_old_rec.business_group_id then
1853: l_argument := 'business_group_id';

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

1852: per_kad_shd.g_old_rec.business_group_id then
1853: l_argument := 'business_group_id';
1854: raise l_error;
1855: end if;
1856: hr_utility.set_location(l_proc, 7);
1857: --
1858: if nvl(p_rec.person_id, hr_api.g_number) <>
1859: per_kad_shd.g_old_rec.person_id then
1860: l_argument := 'person_id';

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

1859: per_kad_shd.g_old_rec.person_id then
1860: l_argument := 'person_id';
1861: raise l_error;
1862: end if;
1863: hr_utility.set_location(l_proc, 8);
1864: --
1865: if nvl(p_rec.primary_flag, hr_api.g_varchar2) <>
1866: per_kad_shd.g_old_rec.primary_flag then
1867: l_argument := 'primary_flag';

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

1866: per_kad_shd.g_old_rec.primary_flag then
1867: l_argument := 'primary_flag';
1868: raise l_error;
1869: end if;
1870: hr_utility.set_location(l_proc, 10);
1871: --
1872: if nvl(p_rec.style, hr_api.g_varchar2) <>
1873: per_kad_shd.g_old_rec.style then
1874: l_argument := 'style';

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

1873: per_kad_shd.g_old_rec.style then
1874: l_argument := 'style';
1875: raise l_error;
1876: end if;
1877: hr_utility.set_location(l_proc, 11);
1878: --
1879: exception
1880: when l_error then
1881: hr_api.argument_changed_error

Line 1886: hr_utility.set_location(' Leaving:'||l_proc, 12);

1882: (p_api_name => l_proc
1883: ,p_argument => l_argument);
1884: when others then
1885: raise;
1886: hr_utility.set_location(' Leaving:'||l_proc, 12);
1887: end check_non_updateable_args;
1888: --
1889: -- ----------------------------------------------------------------------------
1890: -- |---------------------------< insert_validate >----------------------------|

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

1896: --
1897: l_proc varchar2(72) := g_package||'insert_validate';
1898: --
1899: Begin
1900: hr_utility.set_location('Entering:'||l_proc, 5);
1901: --
1902: -- Reset global variable that indicates if payroll is installed under
1903: -- US legislation prior to validation.
1904: --

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

1909: -- Validate business group id
1910: --
1911: hr_api.validate_bus_grp_id(p_rec.business_group_id);
1912: --
1913: hr_utility.set_location(l_proc, 6);
1914: --
1915: -- Validate date from
1916: --
1917: chk_date_from

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

1920: ,p_date_to => p_rec.date_to
1921: ,p_object_version_number => p_rec.object_version_number
1922: );
1923: --
1924: hr_utility.set_location(l_proc, 7);
1925: --
1926: -- Validate person_id
1927: --
1928: chk_person_id

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

1928: chk_person_id
1929: (p_person_id => p_rec.person_id
1930: );
1931: --
1932: hr_utility.set_location(l_proc, 8);
1933: --
1934: -- Validate style
1935: --
1936: chk_style

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

1936: chk_style
1937: (p_style => p_rec.style
1938: );
1939: --
1940: hr_utility.set_location(l_proc, 10);
1941: --
1942: -- Validate address type
1943: --
1944: chk_address_type

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

1948: ,p_effective_date => p_effective_date
1949: ,p_object_version_number => p_rec.object_version_number
1950: );
1951: --
1952: hr_utility.set_location(l_proc, 11);
1953: --
1954: -- Validate country
1955: --
1956: chk_country

Line 1963: hr_utility.set_location(l_proc, 12);

1959: ,p_address_id => p_rec.address_id
1960: ,p_object_version_number => p_rec.object_version_number
1961: );
1962: --
1963: hr_utility.set_location(l_proc, 12);
1964: --
1965: -- Validate postal code.
1966: --
1967: chk_postal_code

Line 1983: hr_utility.set_location(l_proc, 13);

1979: p_rec.style = 'US' or
1980: p_rec.style = 'GENERIC' then
1981: -- Check null attributes for address style.
1982: --
1983: hr_utility.set_location(l_proc, 13);
1984: chk_style_null_attr
1985: -- 09/12/97 Change Begins
1986: (p_address_id => p_rec.address_id
1987: ,p_object_version_number => p_rec.object_version_number

Line 1994: hr_utility.set_location(l_proc, 14);

1990: ,p_region_3 => p_rec.region_3
1991: ,p_telephone_number_3 => p_rec.telephone_number_3
1992: );
1993: -- 09/12/97 Change Ends
1994: hr_utility.set_location(l_proc, 14);
1995: --
1996: -- Validate address_line1
1997: --
1998: chk_address_line1

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

2000: ,p_style => p_rec.style
2001: ,p_address_line1 => p_rec.address_line1
2002: ,p_object_version_number => p_rec.object_version_number
2003: );
2004: hr_utility.set_location(l_proc, 15);
2005: --
2006: --
2007: --
2008: -- Validate date_to

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

2010: -- No procedural call is made to the procedure
2011: -- chk_date_to as the insert logic is handled
2012: -- by chk_date_from
2013: --
2014: hr_utility.set_location(l_proc, 16);
2015: --
2016: -- Validate region 1.
2017: --
2018: chk_region_1

Line 2027: hr_utility.set_location(l_proc, 17);

2023: ,p_effective_date => p_effective_date
2024: ,p_object_version_number => p_rec.object_version_number
2025: );
2026: --
2027: hr_utility.set_location(l_proc, 17);
2028: --
2029: -- Validate region 2.
2030: --
2031: chk_region_2

Line 2040: hr_utility.set_location(l_proc, 18);

2036: ,p_effective_date => p_effective_date
2037: ,p_object_version_number => p_rec.object_version_number
2038: );
2039: --
2040: hr_utility.set_location(l_proc, 18);
2041: --
2042: -- Validate town or city.
2043: --
2044: chk_town_or_city

Line 2051: hr_utility.set_location(l_proc, 19);

2047: ,p_town_or_city => p_rec.town_or_city
2048: ,p_business_group_id => p_rec.business_group_id
2049: ,p_object_version_number => p_rec.object_version_number
2050: );
2051: hr_utility.set_location(l_proc, 19);
2052: --
2053: --
2054: -- This is only applicable if payroll is installed under US legislation
2055: -- and address style is 'US'.

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

2065: ,p_business_group_id => p_rec.business_group_id
2066: ,p_object_version_number => p_rec.object_version_number
2067: );
2068: --
2069: hr_utility.set_location(l_proc, 20);
2070: --
2071: --Validation specific to JP
2072: --
2073: /*elsif p_rec.style = 'JP' then

Line 2074: hr_utility.set_location(l_proc, 21);

2070: --
2071: --Validation specific to JP
2072: --
2073: /*elsif p_rec.style = 'JP' then
2074: hr_utility.set_location(l_proc, 21);
2075: --
2076: -- Check the combination checking for town_or_city(district_code)
2077: -- address_line1, and region_1
2078: --

Line 2086: hr_utility.set_location(l_proc, 22);

2082: ,p_town_or_city => p_rec.town_or_city
2083: ,p_address_line1 => p_rec.address_line1
2084: ,p_region_1 => p_rec.region_1
2085: );
2086: hr_utility.set_location(l_proc, 22);
2087: --
2088: -- Validate region_2 according to address_line2
2089: --
2090: chk_address2_region2_comb

Line 2096: hr_utility.set_location(l_proc, 23);

2092: ,p_object_version_number => p_rec.object_version_number
2093: ,p_address_line2 => p_rec.address_line2
2094: ,p_region_2 => p_rec.region_2
2095: );
2096: hr_utility.set_location(l_proc, 23);
2097: --
2098: -- Validate region_3 according to address_line3
2099: --
2100: chk_address3_region3_comb

Line 2106: hr_utility.set_location(l_proc, 24); */

2102: ,p_object_version_number => p_rec.object_version_number
2103: ,p_address_line3 => p_rec.address_line3
2104: ,p_region_3 => p_rec.region_3
2105: );
2106: hr_utility.set_location(l_proc, 24); */
2107:
2108: end if;
2109: -- Validate flexfields. This is commented out as we do not need flexfield
2110: -- validation for employee kiosk.

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

2110: -- validation for employee kiosk.
2111: --
2112: -- per_add_flex.df(p_rec => p_rec);
2113: --
2114: hr_utility.set_location(' Leaving:'||l_proc, 25);
2115: --
2116: End insert_validate;
2117: --
2118: -- ----------------------------------------------------------------------------

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

2125: --
2126: l_proc varchar2(72) := g_package||'update_validate';
2127: --
2128: Begin
2129: hr_utility.set_location('Entering:'||l_proc, 1);
2130: --
2131: -- Reset global variable that indicates if payroll is installed under
2132: -- US legislation prior to validation.
2133: --

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

2144: -- be updated have not changed
2145: --
2146: check_non_updateable_args(p_rec => p_rec);
2147: --
2148: hr_utility.set_location(l_proc, 2);
2149: --
2150: -- Validate date from
2151: --
2152: chk_date_from

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

2155: ,p_date_to => p_rec.date_to
2156: ,p_object_version_number => p_rec.object_version_number
2157: );
2158: --
2159: hr_utility.set_location(l_proc, 4);
2160: --
2161: -- Validate country.
2162: --
2163: chk_country

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

2166: ,p_address_id => p_rec.address_id
2167: ,p_object_version_number => p_rec.object_version_number
2168: );
2169: --
2170: hr_utility.set_location(l_proc, 5);
2171: --
2172: -- Validate address type.
2173: --
2174: chk_address_type

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

2178: ,p_effective_date => p_effective_date
2179: ,p_object_version_number => p_rec.object_version_number
2180: );
2181: --
2182: hr_utility.set_location(l_proc, 6);
2183: --
2184: -- Validate postal code.
2185: --
2186: chk_postal_code

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

2189: ,p_postal_code => p_rec.postal_code
2190: ,p_business_group_id => p_rec.business_group_id
2191: ,p_object_version_number => p_rec.object_version_number
2192: );
2193: hr_utility.set_location(l_proc, 8);
2194: --
2195: -- Validate date to.
2196: --
2197: chk_date_to

Line 2203: hr_utility.set_location(l_proc, 9);

2199: ,p_date_from => p_rec.date_from
2200: ,p_date_to => p_rec.date_to
2201: ,p_object_version_number => p_rec.object_version_number
2202: );
2203: hr_utility.set_location(l_proc, 9);
2204: --
2205: --
2206: -- Validation specific to GB, US, GENERIC
2207: --

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

2218: ,p_business_group_id => p_rec.business_group_id
2219: ,p_effective_date => p_effective_date
2220: ,p_object_version_number => p_rec.object_version_number
2221: );
2222: hr_utility.set_location(l_proc, 10);
2223: --
2224: -- Validate region 2.
2225: --
2226: chk_region_2

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

2230: ,p_business_group_id => p_rec.business_group_id
2231: ,p_effective_date => p_effective_date
2232: ,p_object_version_number => p_rec.object_version_number
2233: );
2234: hr_utility.set_location(l_proc, 11);
2235: --
2236: -- Validate town or city.
2237: --
2238: chk_town_or_city

Line 2245: hr_utility.set_location(l_proc, 12);

2241: ,p_town_or_city => p_rec.town_or_city
2242: ,p_business_group_id => p_rec.business_group_id
2243: ,p_object_version_number => p_rec.object_version_number
2244: );
2245: hr_utility.set_location(l_proc, 12);
2246: --
2247: -- Validate address_line 1.
2248: --
2249: chk_address_line1

Line 2255: hr_utility.set_location(l_proc, 13);

2251: ,p_style => p_rec.style
2252: ,p_address_line1 => p_rec.address_line1
2253: ,p_object_version_number => p_rec.object_version_number
2254: );
2255: hr_utility.set_location(l_proc, 13);
2256: --
2257: -- Check null attributes for address style.
2258: --
2259: chk_style_null_attr

Line 2269: hr_utility.set_location(l_proc, 14);

2265: ,p_region_3 => p_rec.region_3
2266: ,p_telephone_number_3 => p_rec.telephone_number_3
2267: );
2268: -- 09/12/97 Change Ends
2269: hr_utility.set_location(l_proc, 14);
2270: --
2271: -- This is only applicable if payroll is installed under US legislation
2272: -- and address style is 'US'.
2273: -- Validate city(town_or_city) and state(region_2)

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

2282: ,p_business_group_id => p_rec.business_group_id
2283: ,p_object_version_number => p_rec.object_version_number
2284: );
2285: --
2286: hr_utility.set_location(l_proc, 15);
2287: --
2288: --
2289: /* elsif p_rec.style = 'JP' then
2290: hr_utility.set_location(l_proc, 16);

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

2286: hr_utility.set_location(l_proc, 15);
2287: --
2288: --
2289: /* elsif p_rec.style = 'JP' then
2290: hr_utility.set_location(l_proc, 16);
2291: --
2292: -- Check the combination checking for town_or_city(district_code)
2293: -- address_line1, and region_1
2294: --

Line 2302: hr_utility.set_location(l_proc, 17);

2298: ,p_town_or_city => p_rec.town_or_city
2299: ,p_address_line1 => p_rec.address_line1
2300: ,p_region_1 => p_rec.region_1
2301: );
2302: hr_utility.set_location(l_proc, 17);
2303: --
2304: -- Validate region_2 according to address_line2
2305: --
2306: chk_address2_region2_comb

Line 2312: hr_utility.set_location(l_proc, 18);

2308: ,p_object_version_number => p_rec.object_version_number
2309: ,p_address_line2 => p_rec.address_line2
2310: ,p_region_2 => p_rec.region_2
2311: );
2312: hr_utility.set_location(l_proc, 18);
2313: --
2314: -- Validate region_3 according to address_line3
2315: --
2316: chk_address3_region3_comb

Line 2322: hr_utility.set_location(l_proc, 19); */

2318: ,p_object_version_number => p_rec.object_version_number
2319: ,p_address_line3 => p_rec.address_line3
2320: ,p_region_3 => p_rec.region_3
2321: );
2322: hr_utility.set_location(l_proc, 19); */
2323:
2324: end if;
2325: --
2326: -- Validate flexfields. This is commented out as we do not need flexfields

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

2327: -- validation for employee kiosk.
2328: --
2329: -- per_add_flex.df(p_rec => p_rec);
2330: --
2331: hr_utility.set_location(' Leaving:'||l_proc, 20);
2332: End update_validate;
2333: --
2334: -- ----------------------------------------------------------------------------
2335: -- |---------------------------< delete_validate >----------------------------|

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

2338: --
2339: l_proc varchar2(72) := g_package||'delete_validate';
2340: --
2341: Begin
2342: hr_utility.set_location('Entering:'||l_proc, 5);
2343: --
2344: -- Call all supporting business operations. Mapping to the
2345: -- appropriate business rules on peradd.bru is provided
2346: --

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

2353: -- as the primary address
2354: --
2355: chk_del_address;
2356: --
2357: hr_utility.set_location(' Leaving:'||l_proc, 10);
2358: End delete_validate;
2359: --
2360: end per_kad_bus;