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

[Home] [Help]

APPS.HR_KW_VALIDATE_PKG dependencies on HR_UTILITY

Line 39: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN

35: AND ppt.person_type_Id = p_person_type_id;
36: BEGIN
37:
38: /* Added for GSI Bug 5472781 */
39: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
40:
41: v_field := NULL;
42: g_type := NULL;
43: g_per_type := NULL;

Line 110: hr_utility.raise_error;

106: END IF;
107: IF v_field IS NOT NULL THEN
108: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
109: fnd_message.set_token('NAME',v_field, translate => true );
110: hr_utility.raise_error;
111: END IF;
112: END IF;
113: END IF;
114: END VALIDATE;

Line 179: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN

175: ,p_per_information10 => p_per_information10);
176: END IF;
177:
178: /* Added for GSI Bug 5472781 */
179: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
180:
181: if g_type IS NOT NULL THEN
182:
183: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then

Line 197: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');

193: ,p_lookup_code => p_per_information8
194: )
195: then
196: --
197: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
198: hr_utility.raise_error;
199: --
200: end if;
201: end if;

Line 198: hr_utility.raise_error;

194: )
195: then
196: --
197: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
198: hr_utility.raise_error;
199: --
200: end if;
201: end if;
202:

Line 214: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');

210: ,p_lookup_code => p_per_information7
211: )
212: then
213: --
214: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
215: hr_utility.raise_error;
216: --
217: end if;
218: end if;

Line 215: hr_utility.raise_error;

211: )
212: then
213: --
214: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
215: hr_utility.raise_error;
216: --
217: end if;
218: end if;
219:

Line 272: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN

268: ,p_per_information9 => p_per_information9
269: ,p_per_information10 => p_per_information10);
270:
271: /* Added for GSI Bug 5472781 */
272: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
273:
274: if g_type IS NOT NULL THEN
275:
276: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then

Line 290: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');

286: ,p_lookup_code => p_per_information8
287: )
288: then
289: --
290: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
291: hr_utility.raise_error;
292: --
293: end if;
294: end if;

Line 291: hr_utility.raise_error;

287: )
288: then
289: --
290: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
291: hr_utility.raise_error;
292: --
293: end if;
294: end if;
295:

Line 306: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');

302: ,p_lookup_code => p_per_information7
303: )
304: then
305: --
306: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
307: hr_utility.raise_error;
308: --
309: end if;
310: end if;

Line 307: hr_utility.raise_error;

303: )
304: then
305: --
306: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
307: hr_utility.raise_error;
308: --
309: end if;
310: end if;
311: end if;

Line 365: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN

361: ,p_per_information9 => p_per_information9
362: ,p_per_information10 => p_per_information10);
363:
364: /* Added for GSI Bug 5472781 */
365: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
366:
367: if g_type IS NOT NULL THEN
368: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
369: --

Line 382: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');

378: ,p_lookup_code => p_per_information8
379: )
380: then
381: --
382: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
383: hr_utility.raise_error;
384: --
385: end if;
386: end if;

Line 383: hr_utility.raise_error;

379: )
380: then
381: --
382: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
383: hr_utility.raise_error;
384: --
385: end if;
386: end if;
387:

Line 398: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');

394: ,p_lookup_code => p_per_information7
395: )
396: then
397: --
398: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
399: hr_utility.raise_error;
400: --
401: end if;
402: end if;

Line 399: hr_utility.raise_error;

395: )
396: then
397: --
398: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
399: hr_utility.raise_error;
400: --
401: end if;
402: end if;
403:

Line 458: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN

454: ,p_per_information9 => p_per_information9
455: ,p_per_information10 => p_per_information10);
456:
457: /* Added for GSI Bug 5472781 */
458: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
459:
460: if g_type IS NOT NULL THEN
461: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
462: --

Line 475: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');

471: ,p_lookup_code => p_per_information8
472: )
473: then
474: --
475: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
476: hr_utility.raise_error;
477: --
478: end if;
479: end if;

Line 476: hr_utility.raise_error;

472: )
473: then
474: --
475: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
476: hr_utility.raise_error;
477: --
478: end if;
479: end if;
480:

Line 491: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');

487: ,p_lookup_code => p_per_information7
488: )
489: then
490: --
491: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
492: hr_utility.raise_error;
493: --
494: end if;
495: end if;

Line 492: hr_utility.raise_error;

488: )
489: then
490: --
491: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
492: hr_utility.raise_error;
493: --
494: end if;
495: end if;
496:

Line 549: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN

545: ,p_per_information9 => p_per_information9
546: ,p_per_information10 => p_per_information10);
547:
548: /* Added for GSI Bug 5472781 */
549: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
550:
551: if g_type IS NOT NULL THEN
552: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
553: --

Line 566: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');

562: ,p_lookup_code => p_per_information8
563: )
564: then
565: --
566: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
567: hr_utility.raise_error;
568: --
569: end if;
570: end if;

Line 567: hr_utility.raise_error;

563: )
564: then
565: --
566: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
567: hr_utility.raise_error;
568: --
569: end if;
570: end if;
571:

Line 582: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');

578: ,p_lookup_code => p_per_information7
579: )
580: then
581: --
582: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
583: hr_utility.raise_error;
584: --
585: end if;
586: end if;

Line 583: hr_utility.raise_error;

579: )
580: then
581: --
582: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
583: hr_utility.raise_error;
584: --
585: end if;
586: end if;
587:

Line 610: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN

606: l_field VARCHAR2(300);
607: BEGIN
608:
609: /* Added for GSI Bug 5472781 */
610: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
611:
612: l_field := NULL;
613:
614:

Line 627: hr_utility.set_message(800, 'HR_375405_KW_INVALID_EMP_STAT');

623: ,p_lookup_code => p_ctr_information1
624: )
625: THEN
626: --
627: hr_utility.set_message(800, 'HR_375405_KW_INVALID_EMP_STAT');
628: hr_utility.raise_error;
629: END IF;
630: END IF;
631:

Line 628: hr_utility.raise_error;

624: )
625: THEN
626: --
627: hr_utility.set_message(800, 'HR_375405_KW_INVALID_EMP_STAT');
628: hr_utility.raise_error;
629: END IF;
630: END IF;
631:
632: --

Line 638: hr_utility.set_message(800, 'HR_375406_KW_EXPIRY_INVALID');

634:
635: IF (fnd_date.canonical_to_date(p_ctr_information2) < p_effective_date)
636: THEN
637: --
638: hr_utility.set_message(800, 'HR_375406_KW_EXPIRY_INVALID');
639: hr_utility.raise_error;
640: --
641: END IF;
642: END IF;

Line 639: hr_utility.raise_error;

635: IF (fnd_date.canonical_to_date(p_ctr_information2) < p_effective_date)
636: THEN
637: --
638: hr_utility.set_message(800, 'HR_375406_KW_EXPIRY_INVALID');
639: hr_utility.raise_error;
640: --
641: END IF;
642: END IF;
643:

Line 661: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN

657:
658: BEGIN
659:
660: /* Added for GSI Bug 5472781 */
661: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
662:
663: v_field := NULL;
664: IF p_pem_information_category = 'KW' then
665: IF p_employer_name is null then

Line 674: hr_utility.raise_error;

670: END IF;
671:
672: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
673: fnd_message.set_token('NAME',v_field, translate => true );
674: hr_utility.raise_error;
675: END IF;
676:
677: IF p_pem_information1 IS NOT NULL THEN
678: IF hr_api.not_exists_in_hr_lookups

Line 684: hr_utility.set_message(800, 'HR_375410_KW_INVALID_LEAV_REAS');

680: ,p_lookup_type => 'LEAV_REAS'
681: ,p_lookup_code => p_pem_information1
682: )
683: THEN
684: hr_utility.set_message(800, 'HR_375410_KW_INVALID_LEAV_REAS');
685: hr_utility.raise_error;
686: END IF;
687: END IF;
688: END IF;

Line 685: hr_utility.raise_error;

681: ,p_lookup_code => p_pem_information1
682: )
683: THEN
684: hr_utility.set_message(800, 'HR_375410_KW_INVALID_LEAV_REAS');
685: hr_utility.raise_error;
686: END IF;
687: END IF;
688: END IF;
689: END IF;

Line 722: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN

718: m_num NUMBER;
719: BEGIN
720:
721: /* Added for GSI Bug 5472781 */
722: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
723:
724: l_length := 0;
725: l_var1 := 0;
726: m_s := 0;

Line 737: hr_utility.raise_error;

733: IF(l_length > 8) THEN
734:
735: return_value := '0';
736: fnd_message.set_name('PER', 'HR_375403_KW_INVALID_EMPCID_LN');
737: hr_utility.raise_error;
738:
739: ELSIF(l_length = 8) THEN
740:
741: l_var1 := TO_NUMBER(SUBSTR(p_org_information6,1,2));

Line 748: hr_utility.raise_error;

744: l_var1 = 91 ) THEN
745: return_value := p_org_information6; --, invalid_mesg
746: ELSE
747: fnd_message.set_name('PER', 'HR_375404_KW_INVALID_EMPCID');
748: hr_utility.raise_error;
749: END IF;
750:
751: ELSIF(l_length < 8) THEN
752:

Line 770: hr_utility.raise_error;

766: m_num := 11 - m_rem;
767:
768: IF(m_num <> m_s) THEN
769: fnd_message.set_name('PER', 'HR_375404_KW_INVALID_EMPCID');
770: hr_utility.raise_error;
771: END IF;
772:
773: END IF;
774:

Line 783: hr_utility.raise_error;

779: l_length := LENGTH(p_org_information4);
780:
781: IF(l_length > 9) THEN
782: fnd_message.set_name('PER', 'HR_375402_KW_SSN_INVALID');
783: hr_utility.raise_error;
784: END IF;
785: END IF;
786:
787: END IF; -- legcode check

Line 820: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN

816: m_num NUMBER;
817: BEGIN
818:
819: /* Added for GSI Bug 5472781 */
820: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
821:
822: l_length := 0;
823: l_var1 := 0;
824: m_s := 0;

Line 836: hr_utility.raise_error;

832: IF(l_length > 8) THEN
833:
834: return_value := '0';
835: fnd_message.set_name('PER', 'HR_375403_KW_INVALID_EMPCID_LN');
836: hr_utility.raise_error;
837:
838: ELSIF(l_length = 8) THEN
839:
840: l_var1 := TO_NUMBER(SUBSTR(p_org_information6,1,2));

Line 847: hr_utility.raise_error;

843: l_var1 = 91 ) THEN
844: return_value := p_org_information6; --, invalid_mesg
845: ELSE
846: fnd_message.set_name('PER', 'HR_375404_KW_INVALID_EMPCID');
847: hr_utility.raise_error;
848: END IF;
849:
850: ELSIF(l_length < 8) THEN
851:

Line 869: hr_utility.raise_error;

865: m_num := 11 - m_rem;
866:
867: IF(m_num <> m_s) THEN
868: fnd_message.set_name('PER', 'HR_375404_KW_INVALID_EMPCID');
869: hr_utility.raise_error;
870: END IF;
871:
872: END IF;
873:

Line 881: hr_utility.raise_error;

877: l_length := LENGTH(p_org_information4);
878:
879: IF(l_length > 9) THEN
880: fnd_message.set_name('PER', 'HR_375402_KW_SSN_INVALID');
881: hr_utility.raise_error;
882: END IF;
883: END IF;
884:
885: END IF; -- legcode check

Line 910: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN

906: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
907: BEGIN
908:
909: /* Added for GSI Bug 5472781 */
910: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
911:
912: SELECT person_id
913: INTO l_person_id
914: FROM per_all_assignments_f

Line 948: hr_utility.raise_error;

944:
945: IF v_field IS NOT NULL THEN
946: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
947: fnd_message.set_token('NAME',v_field, translate => true );
948: hr_utility.raise_error;
949: END IF;
950: END IF;
951: END ASSIGNMENT_VALIDATE;
952:

Line 965: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN

961: AS
962: BEGIN
963:
964: /* Added for GSI Bug 5472781 */
965: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
966:
967: IF p_dis_information_category = 'KW' THEN
968: IF (p_degree IS NOT NULL AND p_dis_information1 IS NOT NULL) THEN
969: fnd_message.set_name('PER', 'HR_375408_KW_DISABILITY');

Line 970: hr_utility.raise_error;

966:
967: IF p_dis_information_category = 'KW' THEN
968: IF (p_degree IS NOT NULL AND p_dis_information1 IS NOT NULL) THEN
969: fnd_message.set_name('PER', 'HR_375408_KW_DISABILITY');
970: hr_utility.raise_error;
971: END IF;
972: END IF;
973:
974: END IF;