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_RU_PEOPLE_LEG_HOOK dependencies on HR_API

Line 9: IF (param <> hr_api.g_varchar2) OR (param IS NULL)

5: FUNCTION param_or_db (param VARCHAR2, db_item VARCHAR2)
6: RETURN VARCHAR2
7: IS
8: BEGIN
9: IF (param <> hr_api.g_varchar2) OR (param IS NULL)
10: THEN
11: RETURN param;
12: ELSE
13: RETURN db_item;

Line 71: IF p_per_information13 <> hr_api.g_varchar2

67:
68: l_effective_date := TRUNC (p_effective_date);
69:
70: --Validate Pension fund number
71: IF p_per_information13 <> hr_api.g_varchar2
72: AND p_per_information13 IS NOT NULL
73: THEN
74: l_err :=
75: hr_ru_utility.validate_spifn (p_per_information13,

Line 97: IF (p_per_information5 <> hr_api.g_varchar2)

93: END IF;
94: END IF;
95:
96: --Check for Invalid Combination of military document and other military details
97: IF (p_per_information5 <> hr_api.g_varchar2)
98: OR (p_per_information5 IS NULL)
99: OR (p_per_information6 <> hr_api.g_varchar2)
100: OR (p_per_information6 IS NULL)
101: OR (p_per_information7 <> hr_api.g_varchar2)

Line 99: OR (p_per_information6 <> hr_api.g_varchar2)

95:
96: --Check for Invalid Combination of military document and other military details
97: IF (p_per_information5 <> hr_api.g_varchar2)
98: OR (p_per_information5 IS NULL)
99: OR (p_per_information6 <> hr_api.g_varchar2)
100: OR (p_per_information6 IS NULL)
101: OR (p_per_information7 <> hr_api.g_varchar2)
102: OR (p_per_information7 IS NULL)
103: OR (p_per_information8 <> hr_api.g_varchar2)

Line 101: OR (p_per_information7 <> hr_api.g_varchar2)

97: IF (p_per_information5 <> hr_api.g_varchar2)
98: OR (p_per_information5 IS NULL)
99: OR (p_per_information6 <> hr_api.g_varchar2)
100: OR (p_per_information6 IS NULL)
101: OR (p_per_information7 <> hr_api.g_varchar2)
102: OR (p_per_information7 IS NULL)
103: OR (p_per_information8 <> hr_api.g_varchar2)
104: OR (p_per_information8 IS NULL)
105: OR (p_per_information9 <> hr_api.g_varchar2)

Line 103: OR (p_per_information8 <> hr_api.g_varchar2)

99: OR (p_per_information6 <> hr_api.g_varchar2)
100: OR (p_per_information6 IS NULL)
101: OR (p_per_information7 <> hr_api.g_varchar2)
102: OR (p_per_information7 IS NULL)
103: OR (p_per_information8 <> hr_api.g_varchar2)
104: OR (p_per_information8 IS NULL)
105: OR (p_per_information9 <> hr_api.g_varchar2)
106: OR (p_per_information9 IS NULL)
107: OR (p_per_information10 <> hr_api.g_varchar2)

Line 105: OR (p_per_information9 <> hr_api.g_varchar2)

101: OR (p_per_information7 <> hr_api.g_varchar2)
102: OR (p_per_information7 IS NULL)
103: OR (p_per_information8 <> hr_api.g_varchar2)
104: OR (p_per_information8 IS NULL)
105: OR (p_per_information9 <> hr_api.g_varchar2)
106: OR (p_per_information9 IS NULL)
107: OR (p_per_information10 <> hr_api.g_varchar2)
108: OR (p_per_information10 IS NULL)
109: OR (p_per_information11 <> hr_api.g_varchar2)

Line 107: OR (p_per_information10 <> hr_api.g_varchar2)

103: OR (p_per_information8 <> hr_api.g_varchar2)
104: OR (p_per_information8 IS NULL)
105: OR (p_per_information9 <> hr_api.g_varchar2)
106: OR (p_per_information9 IS NULL)
107: OR (p_per_information10 <> hr_api.g_varchar2)
108: OR (p_per_information10 IS NULL)
109: OR (p_per_information11 <> hr_api.g_varchar2)
110: OR (p_per_information11 IS NULL)
111: OR (p_per_information12 <> hr_api.g_varchar2)

Line 109: OR (p_per_information11 <> hr_api.g_varchar2)

105: OR (p_per_information9 <> hr_api.g_varchar2)
106: OR (p_per_information9 IS NULL)
107: OR (p_per_information10 <> hr_api.g_varchar2)
108: OR (p_per_information10 IS NULL)
109: OR (p_per_information11 <> hr_api.g_varchar2)
110: OR (p_per_information11 IS NULL)
111: OR (p_per_information12 <> hr_api.g_varchar2)
112: OR (p_per_information12 IS NULL)
113: OR (p_per_information14 <> hr_api.g_varchar2)

Line 111: OR (p_per_information12 <> hr_api.g_varchar2)

107: OR (p_per_information10 <> hr_api.g_varchar2)
108: OR (p_per_information10 IS NULL)
109: OR (p_per_information11 <> hr_api.g_varchar2)
110: OR (p_per_information11 IS NULL)
111: OR (p_per_information12 <> hr_api.g_varchar2)
112: OR (p_per_information12 IS NULL)
113: OR (p_per_information14 <> hr_api.g_varchar2)
114: OR (p_per_information14 IS NULL)
115: OR (p_per_information15 <> hr_api.g_varchar2)

Line 113: OR (p_per_information14 <> hr_api.g_varchar2)

109: OR (p_per_information11 <> hr_api.g_varchar2)
110: OR (p_per_information11 IS NULL)
111: OR (p_per_information12 <> hr_api.g_varchar2)
112: OR (p_per_information12 IS NULL)
113: OR (p_per_information14 <> hr_api.g_varchar2)
114: OR (p_per_information14 IS NULL)
115: OR (p_per_information15 <> hr_api.g_varchar2)
116: OR (p_per_information15 IS NULL)
117: OR (p_per_information18 <> hr_api.g_varchar2)

Line 115: OR (p_per_information15 <> hr_api.g_varchar2)

111: OR (p_per_information12 <> hr_api.g_varchar2)
112: OR (p_per_information12 IS NULL)
113: OR (p_per_information14 <> hr_api.g_varchar2)
114: OR (p_per_information14 IS NULL)
115: OR (p_per_information15 <> hr_api.g_varchar2)
116: OR (p_per_information15 IS NULL)
117: OR (p_per_information18 <> hr_api.g_varchar2)
118: OR (p_per_information18 IS NULL)
119: THEN

Line 117: OR (p_per_information18 <> hr_api.g_varchar2)

113: OR (p_per_information14 <> hr_api.g_varchar2)
114: OR (p_per_information14 IS NULL)
115: OR (p_per_information15 <> hr_api.g_varchar2)
116: OR (p_per_information15 IS NULL)
117: OR (p_per_information18 <> hr_api.g_varchar2)
118: OR (p_per_information18 IS NULL)
119: THEN
120: OPEN csr_get_mil_info (p_person_id);
121:

Line 167: hr_api.mandatory_arg_error

163: p_argument_value => l_per_information5,
164: p_lookup_type => 'RU_MILITARY_DOC_TYPE',
165: p_effective_date => p_effective_date
166: );
167: hr_api.mandatory_arg_error
168: (p_api_name => l_proc,
169: p_argument => hr_general.decode_lookup
170: ('RU_FORM_LABELS',
171: 'MIL_SERVICE_READINESS'

Line 366: hr_api.mandatory_arg_error

362: p_argument_value => p_per_information5,
363: p_lookup_type => 'RU_MILITARY_DOC_TYPE',
364: p_effective_date => p_effective_date
365: );
366: hr_api.mandatory_arg_error
367: (p_api_name => l_proc,
368: p_argument => hr_general.decode_lookup
369: ('RU_FORM_LABELS',
370: 'MIL_SERVICE_READINESS'

Line 527: hr_api.mandatory_arg_error

523: --
524: -- Check for Citizenship
525: IF per_per_bus.g_global_transfer_in_process IS NULL
526: OR per_per_bus.g_global_transfer_in_process = FALSE THEN --BUG 14509259
527: hr_api.mandatory_arg_error
528: (p_api_name => l_proc,
529: p_argument => hr_general.decode_lookup
530: ('RU_FORM_LABELS',
531: 'CITIZENSHIP'

Line 547: hr_api.mandatory_arg_error

543: );
544: END IF;
545:
546: -- Check for first name
547: hr_api.mandatory_arg_error
548: (p_api_name => l_proc,
549: p_argument => hr_general.decode_lookup
550: ('RU_FORM_LABELS',
551: 'FIRST_NAME'

Line 623: hr_api.mandatory_arg_error

619: --
620: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
621: --
622: -- Check for Citizenship
623: hr_api.mandatory_arg_error
624: (p_api_name => l_proc,
625: p_argument => hr_general.decode_lookup
626: ('RU_FORM_LABELS',
627: 'CITIZENSHIP'

Line 733: hr_api.mandatory_arg_error

729: --
730: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
731: --
732: -- Check for Citizenship
733: hr_api.mandatory_arg_error
734: (p_api_name => l_proc,
735: p_argument => hr_general.decode_lookup
736: ('RU_FORM_LABELS',
737: 'CITIZENSHIP'

Line 829: IF (p_person_type_id <> hr_api.g_number

825: IF hr_utility.chk_product_install('Oracle Human Resources', 'RU') THEN
826: --
827: l_effective_date := TRUNC (p_effective_date);
828:
829: IF (p_person_type_id <> hr_api.g_number
830: ) -- If person type has changed , get new type
831: THEN
832: OPEN csr_val_person_type (p_person_type_id);
833:

Line 847: IF (p_per_information1 <> hr_api.g_varchar2)

843:
844: CLOSE csr_ptu_type;
845: END IF;
846: -- Check Place of Birth takes valid OKATO lookup value
847: IF (p_per_information1 <> hr_api.g_varchar2)
848: THEN
849: hr_ru_utility.check_lookup_value
850: (p_argument => hr_general.decode_lookup
851: ('RU_FORM_LABELS',

Line 863: hr_api.mandatory_arg_error

859: --
860: IF l_seeded_person_type_key <> 'CONTACT'
861: THEN
862: -- Check for Citizenship
863: hr_api.mandatory_arg_error
864: (p_api_name => l_proc,
865: p_argument => hr_general.decode_lookup
866: ('RU_FORM_LABELS',
867: 'CITIZENSHIP'

Line 872: IF (p_per_information4 <> hr_api.g_varchar2)

868: ),
869: p_argument_value => p_per_information4
870: );
871:
872: IF (p_per_information4 <> hr_api.g_varchar2)
873: THEN
874: hr_ru_utility.check_lookup_value
875: (p_argument => hr_general.decode_lookup
876: ('RU_FORM_LABELS',

Line 890: IF (p_first_name <> hr_api.g_varchar2) OR (p_first_name IS NULL)

886: -- Check if Military Document is provided for male employees between 17 and 65
887: IF l_system_person_type LIKE 'EMP%'
888: THEN
889: -- Check for first name
890: IF (p_first_name <> hr_api.g_varchar2) OR (p_first_name IS NULL)
891: THEN
892: hr_api.mandatory_arg_error
893: (p_api_name => l_proc,
894: p_argument => hr_general.decode_lookup

Line 892: hr_api.mandatory_arg_error

888: THEN
889: -- Check for first name
890: IF (p_first_name <> hr_api.g_varchar2) OR (p_first_name IS NULL)
891: THEN
892: hr_api.mandatory_arg_error
893: (p_api_name => l_proc,
894: p_argument => hr_general.decode_lookup
895: ('RU_FORM_LABELS',
896: 'FIRST_NAME'

Line 902: IF (p_date_of_birth <> hr_api.g_date)

898: p_argument_value => p_first_name
899: );
900: END IF;
901:
902: IF (p_date_of_birth <> hr_api.g_date)
903: OR (p_sex <> hr_api.g_varchar2)
904: OR ( p_per_information5 <> hr_api.g_varchar2
905: OR p_per_information5 IS NULL
906: )

Line 903: OR (p_sex <> hr_api.g_varchar2)

899: );
900: END IF;
901:
902: IF (p_date_of_birth <> hr_api.g_date)
903: OR (p_sex <> hr_api.g_varchar2)
904: OR ( p_per_information5 <> hr_api.g_varchar2
905: OR p_per_information5 IS NULL
906: )
907: THEN

Line 904: OR ( p_per_information5 <> hr_api.g_varchar2

900: END IF;
901:
902: IF (p_date_of_birth <> hr_api.g_date)
903: OR (p_sex <> hr_api.g_varchar2)
904: OR ( p_per_information5 <> hr_api.g_varchar2
905: OR p_per_information5 IS NULL
906: )
907: THEN
908: OPEN csr_get_person_info (p_person_id);