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.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 121: hr_utility.raise_error;

117: END IF;
118: IF v_field IS NOT NULL THEN
119: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
120: fnd_message.set_token('NAME',v_field, translate => true );
121: hr_utility.raise_error;
122: END IF;
123: END IF; -- Bug# 14275662
124: END IF;
125: END IF;

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

187: ,p_per_information10 => p_per_information10);
188: END IF;
189:
190: /* Added for GSI Bug 5472781 */
191: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
192:
193: if g_type IS NOT NULL THEN
194:
195: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then

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

205: ,p_lookup_code => p_per_information8
206: )
207: then
208: --
209: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
210: hr_utility.raise_error;
211: --
212: end if;
213: end if;

Line 210: hr_utility.raise_error;

206: )
207: then
208: --
209: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
210: hr_utility.raise_error;
211: --
212: end if;
213: end if;
214:

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

222: ,p_lookup_code => p_per_information7
223: )
224: then
225: --
226: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
227: hr_utility.raise_error;
228: --
229: end if;
230: end if;

Line 227: hr_utility.raise_error;

223: )
224: then
225: --
226: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
227: hr_utility.raise_error;
228: --
229: end if;
230: end if;
231:

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

280: ,p_per_information9 => p_per_information9
281: ,p_per_information10 => p_per_information10);
282:
283: /* Added for GSI Bug 5472781 */
284: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
285:
286: if g_type IS NOT NULL THEN
287:
288: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then

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

298: ,p_lookup_code => p_per_information8
299: )
300: then
301: --
302: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
303: hr_utility.raise_error;
304: --
305: end if;
306: end if;

Line 303: hr_utility.raise_error;

299: )
300: then
301: --
302: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
303: hr_utility.raise_error;
304: --
305: end if;
306: end if;
307:

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

314: ,p_lookup_code => p_per_information7
315: )
316: then
317: --
318: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
319: hr_utility.raise_error;
320: --
321: end if;
322: end if;

Line 319: hr_utility.raise_error;

315: )
316: then
317: --
318: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
319: hr_utility.raise_error;
320: --
321: end if;
322: end if;
323: end if;

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

373: ,p_per_information9 => p_per_information9
374: ,p_per_information10 => p_per_information10);
375:
376: /* Added for GSI Bug 5472781 */
377: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
378:
379: if g_type IS NOT NULL THEN
380: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
381: --

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

390: ,p_lookup_code => p_per_information8
391: )
392: then
393: --
394: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
395: hr_utility.raise_error;
396: --
397: end if;
398: end if;

Line 395: hr_utility.raise_error;

391: )
392: then
393: --
394: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
395: hr_utility.raise_error;
396: --
397: end if;
398: end if;
399:

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

406: ,p_lookup_code => p_per_information7
407: )
408: then
409: --
410: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
411: hr_utility.raise_error;
412: --
413: end if;
414: end if;

Line 411: hr_utility.raise_error;

407: )
408: then
409: --
410: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
411: hr_utility.raise_error;
412: --
413: end if;
414: end if;
415:

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

466: ,p_per_information9 => p_per_information9
467: ,p_per_information10 => p_per_information10);
468:
469: /* Added for GSI Bug 5472781 */
470: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
471:
472: if g_type IS NOT NULL THEN
473: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
474: --

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

483: ,p_lookup_code => p_per_information8
484: )
485: then
486: --
487: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
488: hr_utility.raise_error;
489: --
490: end if;
491: end if;

Line 488: hr_utility.raise_error;

484: )
485: then
486: --
487: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
488: hr_utility.raise_error;
489: --
490: end if;
491: end if;
492:

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

499: ,p_lookup_code => p_per_information7
500: )
501: then
502: --
503: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
504: hr_utility.raise_error;
505: --
506: end if;
507: end if;

Line 504: hr_utility.raise_error;

500: )
501: then
502: --
503: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
504: hr_utility.raise_error;
505: --
506: end if;
507: end if;
508:

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

557: ,p_per_information9 => p_per_information9
558: ,p_per_information10 => p_per_information10);
559:
560: /* Added for GSI Bug 5472781 */
561: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
562:
563: if g_type IS NOT NULL THEN
564: if p_per_information_category = 'KW' and (p_per_information8 is not null and p_per_information8 <> hr_api.g_varchar2 ) then
565: --

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

574: ,p_lookup_code => p_per_information8
575: )
576: then
577: --
578: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
579: hr_utility.raise_error;
580: --
581: end if;
582: end if;

Line 579: hr_utility.raise_error;

575: )
576: then
577: --
578: hr_utility.set_message(800, 'HR_375407_KW_INVALID_RELIGION');
579: hr_utility.raise_error;
580: --
581: end if;
582: end if;
583:

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

590: ,p_lookup_code => p_per_information7
591: )
592: then
593: --
594: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
595: hr_utility.raise_error;
596: --
597: end if;
598: end if;

Line 595: hr_utility.raise_error;

591: )
592: then
593: --
594: hr_utility.set_message(800, 'HR_375411_KW_INVALID_PREV_NAT');
595: hr_utility.raise_error;
596: --
597: end if;
598: end if;
599:

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

618: l_field VARCHAR2(300);
619: BEGIN
620:
621: /* Added for GSI Bug 5472781 */
622: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
623:
624: l_field := NULL;
625:
626:

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

635: ,p_lookup_code => p_ctr_information1
636: )
637: THEN
638: --
639: hr_utility.set_message(800, 'HR_375405_KW_INVALID_EMP_STAT');
640: hr_utility.raise_error;
641: END IF;
642: END IF;
643:

Line 640: hr_utility.raise_error;

636: )
637: THEN
638: --
639: hr_utility.set_message(800, 'HR_375405_KW_INVALID_EMP_STAT');
640: hr_utility.raise_error;
641: END IF;
642: END IF;
643:
644: --

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

646:
647: IF (fnd_date.canonical_to_date(p_ctr_information2) < p_effective_date)
648: THEN
649: --
650: hr_utility.set_message(800, 'HR_375406_KW_EXPIRY_INVALID');
651: hr_utility.raise_error;
652: --
653: END IF;
654: END IF;

Line 651: hr_utility.raise_error;

647: IF (fnd_date.canonical_to_date(p_ctr_information2) < p_effective_date)
648: THEN
649: --
650: hr_utility.set_message(800, 'HR_375406_KW_EXPIRY_INVALID');
651: hr_utility.raise_error;
652: --
653: END IF;
654: END IF;
655:

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

669:
670: BEGIN
671:
672: /* Added for GSI Bug 5472781 */
673: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
674:
675: v_field := NULL;
676: IF p_pem_information_category = 'KW' then
677: IF p_employer_name is null then

Line 686: hr_utility.raise_error;

682: END IF;
683:
684: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
685: fnd_message.set_token('NAME',v_field, translate => true );
686: hr_utility.raise_error;
687: END IF;
688:
689: IF p_pem_information1 IS NOT NULL THEN
690: IF hr_api.not_exists_in_hr_lookups

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

692: ,p_lookup_type => 'LEAV_REAS'
693: ,p_lookup_code => p_pem_information1
694: )
695: THEN
696: hr_utility.set_message(800, 'HR_375410_KW_INVALID_LEAV_REAS');
697: hr_utility.raise_error;
698: END IF;
699: END IF;
700: END IF;

Line 697: hr_utility.raise_error;

693: ,p_lookup_code => p_pem_information1
694: )
695: THEN
696: hr_utility.set_message(800, 'HR_375410_KW_INVALID_LEAV_REAS');
697: hr_utility.raise_error;
698: END IF;
699: END IF;
700: END IF;
701: END IF;

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

730: m_num NUMBER;
731: BEGIN
732:
733: /* Added for GSI Bug 5472781 */
734: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
735:
736: l_length := 0;
737: l_var1 := 0;
738: m_s := 0;

Line 749: hr_utility.raise_error;

745: IF(l_length > 8) THEN
746:
747: return_value := '0';
748: fnd_message.set_name('PER', 'HR_375403_KW_INVALID_EMPCID_LN');
749: hr_utility.raise_error;
750:
751: ELSIF(l_length = 8) THEN
752:
753: l_var1 := TO_NUMBER(SUBSTR(p_org_information6,1,2));

Line 760: hr_utility.raise_error;

756: l_var1 = 91 ) THEN
757: return_value := p_org_information6; --, invalid_mesg
758: ELSE
759: fnd_message.set_name('PER', 'HR_375404_KW_INVALID_EMPCID');
760: hr_utility.raise_error;
761: END IF;
762:
763: ELSIF(l_length < 8) THEN
764:

Line 782: hr_utility.raise_error;

778: m_num := 11 - m_rem;
779:
780: IF(m_num <> m_s) THEN
781: fnd_message.set_name('PER', 'HR_375404_KW_INVALID_EMPCID');
782: hr_utility.raise_error;
783: END IF;
784:
785: END IF;
786:

Line 795: hr_utility.raise_error;

791: l_length := LENGTH(p_org_information4);
792:
793: IF(l_length > 9) THEN
794: fnd_message.set_name('PER', 'HR_375402_KW_SSN_INVALID');
795: hr_utility.raise_error;
796: END IF;
797: END IF;
798:
799: END IF; -- legcode check

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

828: m_num NUMBER;
829: BEGIN
830:
831: /* Added for GSI Bug 5472781 */
832: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
833:
834: l_length := 0;
835: l_var1 := 0;
836: m_s := 0;

Line 848: hr_utility.raise_error;

844: IF(l_length > 8) THEN
845:
846: return_value := '0';
847: fnd_message.set_name('PER', 'HR_375403_KW_INVALID_EMPCID_LN');
848: hr_utility.raise_error;
849:
850: ELSIF(l_length = 8) THEN
851:
852: l_var1 := TO_NUMBER(SUBSTR(p_org_information6,1,2));

Line 859: hr_utility.raise_error;

855: l_var1 = 91 ) THEN
856: return_value := p_org_information6; --, invalid_mesg
857: ELSE
858: fnd_message.set_name('PER', 'HR_375404_KW_INVALID_EMPCID');
859: hr_utility.raise_error;
860: END IF;
861:
862: ELSIF(l_length < 8) THEN
863:

Line 881: hr_utility.raise_error;

877: m_num := 11 - m_rem;
878:
879: IF(m_num <> m_s) THEN
880: fnd_message.set_name('PER', 'HR_375404_KW_INVALID_EMPCID');
881: hr_utility.raise_error;
882: END IF;
883:
884: END IF;
885:

Line 893: hr_utility.raise_error;

889: l_length := LENGTH(p_org_information4);
890:
891: IF(l_length > 9) THEN
892: fnd_message.set_name('PER', 'HR_375402_KW_SSN_INVALID');
893: hr_utility.raise_error;
894: END IF;
895: END IF;
896:
897: END IF; -- legcode check

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

918: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
919: BEGIN
920:
921: /* Added for GSI Bug 5472781 */
922: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
923:
924: SELECT person_id
925: INTO l_person_id
926: FROM per_all_assignments_f

Line 960: hr_utility.raise_error;

956:
957: IF v_field IS NOT NULL THEN
958: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
959: fnd_message.set_token('NAME',v_field, translate => true );
960: hr_utility.raise_error;
961: END IF;
962: END IF;
963: END ASSIGNMENT_VALIDATE;
964:

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

973: AS
974: BEGIN
975:
976: /* Added for GSI Bug 5472781 */
977: IF hr_utility.chk_product_install('Oracle Human Resources', 'KW') THEN
978:
979: IF p_dis_information_category = 'KW' THEN
980: IF (p_degree IS NOT NULL AND p_dis_information1 IS NOT NULL) THEN
981: fnd_message.set_name('PER', 'HR_375408_KW_DISABILITY');

Line 982: hr_utility.raise_error;

978:
979: IF p_dis_information_category = 'KW' THEN
980: IF (p_degree IS NOT NULL AND p_dis_information1 IS NOT NULL) THEN
981: fnd_message.set_name('PER', 'HR_375408_KW_DISABILITY');
982: hr_utility.raise_error;
983: END IF;
984: END IF;
985:
986: END IF;