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

Line 114: hr_api.mandatory_arg_error

110: OPEN csr_ptu (p_person_type_id, p_business_group_id);
111: FETCH csr_ptu INTO l_person_type;
112: IF csr_ptu%NOTFOUND THEN
113: CLOSE csr_ptu;
114: hr_api.mandatory_arg_error
115: (p_api_name => l_proc,
116: p_argument => 'P_PERSON_TYPE_ID',
117: p_argument_value => p_person_type_id
118: );

Line 137: hr_api.mandatory_arg_error

133: -- Bug 3342105 Changes.
134: -- Moved the Expat Indicator and CIN check to this IF block
135:
136: hr_cn_api.set_location(g_trace,l_proc,10);
137: hr_api.mandatory_arg_error
138: (p_api_name => l_proc,
139: p_argument => 'P_EXPATRIATE_INDICATOR',
140: p_argument_value => p_expatriate_indicator
141: );

Line 145: hr_api.mandatory_arg_error

141: );
142:
143: IF p_expatriate_indicator ='N' THEN
144: hr_cn_api.set_location(g_trace,l_proc,20);
145: hr_api.mandatory_arg_error
146: (p_api_name => l_proc,
147: p_argument => 'P_HUKOU_TYPE',
148: p_argument_value => p_hukou_type
149: );

Line 152: hr_api.mandatory_arg_error

148: p_argument_value => p_hukou_type
149: );
150:
151: hr_cn_api.set_location(g_trace,l_proc,30);
152: hr_api.mandatory_arg_error
153: (p_api_name => l_proc,
154: p_argument => 'P_HUKOU_LOCATION',
155: p_argument_value => p_hukou_location
156: );

Line 165: IF (p_national_identifier <> hr_api.g_varchar2) OR (p_national_identifier IS NULL) THEN

161: -- Bug 2782045 -- In place of p_person_type_id, we call check_cin
162: -- with l_person_type for ease in checking.
163: -- Bug 2902659 -- Tested p_national_identifier for NULL condition
164: --
165: IF (p_national_identifier <> hr_api.g_varchar2) OR (p_national_identifier IS NULL) THEN
166: hr_cn_api.check_cin
167: ( p_business_group_id => p_business_group_id,
168: p_national_identifier => p_national_identifier,
169: p_person_type_id => p_person_type_id,

Line 182: IF p_hukou_type IS NOT NULL and p_hukou_type <> hr_api.g_varchar2 THEN

178: -- Check for the valid lookup values
179: --
180: hr_cn_api.set_location(g_trace,l_proc,40);
181:
182: IF p_hukou_type IS NOT NULL and p_hukou_type <> hr_api.g_varchar2 THEN
183: hr_cn_api.check_lookup (
184: p_lookup_type => 'CN_HUKOU_TYPE',
185: p_argument => 'P_HUKOU_TYPE',
186: p_argument_value => p_hukou_type

Line 191: IF p_hukou_location IS NOT NULL and p_hukou_location <> hr_api.g_varchar2 THEN

187: );
188: END IF;
189:
190: hr_cn_api.set_location(g_trace,l_proc,50);
191: IF p_hukou_location IS NOT NULL and p_hukou_location <> hr_api.g_varchar2 THEN
192: hr_cn_api.check_lookup (
193: p_lookup_type => 'CN_HUKOU_LOCN',
194: p_argument => 'P_HUKOU_LOCATION',
195: p_argument_value => p_hukou_location

Line 200: IF p_expatriate_indicator <> hr_api.g_varchar2 THEN

196: );
197: END IF;
198:
199: hr_cn_api.set_location(g_trace,l_proc,60);
200: IF p_expatriate_indicator <> hr_api.g_varchar2 THEN
201: hr_cn_api.check_lookup (
202: p_lookup_type => 'YES_NO',
203: p_argument => 'P_EXPATRIATE_INDICATOR',
204: p_argument_value => p_expatriate_indicator

Line 209: IF p_race_ethnic_origin is not null AND p_race_ethnic_origin <> hr_api.g_varchar2

205: );
206: END IF;
207:
208: hr_cn_api.set_location(g_trace,l_proc,70);
209: IF p_race_ethnic_origin is not null AND p_race_ethnic_origin <> hr_api.g_varchar2
210: THEN
211: hr_cn_api.check_lookup (
212: p_lookup_type => 'CN_RACE',
213: p_argument => 'P_RACE_ETHNIC_ORGIN',

Line 219: IF p_highest_education_level is not null AND p_highest_education_level <> hr_api.g_varchar2

215: );
216: END IF;
217:
218: hr_cn_api.set_location(g_trace,l_proc,80);
219: IF p_highest_education_level is not null AND p_highest_education_level <> hr_api.g_varchar2
220: THEN
221: hr_cn_api.check_lookup (
222: p_lookup_type => 'CN_HIGH_EDU_LEVEL',
223: p_argument => 'P_HIGHEST_EDUCATION_LEVEL',

Line 229: IF p_health_status is not null AND p_health_status <> hr_api.g_varchar2

225: );
226: END IF;
227:
228: hr_cn_api.set_location(g_trace,l_proc,90);
229: IF p_health_status is not null AND p_health_status <> hr_api.g_varchar2
230: THEN
231: hr_cn_api.check_lookup (
232: p_lookup_type => 'CN_HEALTH_STATUS',
233: p_argument => 'P_HEALTH_STATUS',

Line 239: IF p_tax_exemption_indicator is not null AND p_tax_exemption_indicator <> hr_api.g_varchar2

235: );
236: END IF;
237:
238: hr_cn_api.set_location(g_trace,l_proc,100);
239: IF p_tax_exemption_indicator is not null AND p_tax_exemption_indicator <> hr_api.g_varchar2
240: THEN
241: hr_cn_api.check_lookup (
242: p_lookup_type => 'YES_NO',
243: p_argument => 'P_TAX_EXEMPTION_INDICATOR',

Line 253: IF p_number_of_children is not null AND p_number_of_children <> hr_api.g_varchar2

249: --
250: -- Validation for Number of Children
251: --
252: hr_cn_api.set_location(g_trace,l_proc,110);
253: IF p_number_of_children is not null AND p_number_of_children <> hr_api.g_varchar2
254: THEN
255: --
256: IF hr_cn_api.is_number(p_number_of_children) THEN
257: --

Line 623: IF p_per_information11 <> hr_api.g_varchar2 THEN

619: FETCH csr_per INTO l_person_type_id, l_tax_exemption_indicator, l_percentage, l_expatriate_indicator
620: ,l_national_identifier;
621: CLOSE csr_per;
622:
623: IF p_per_information11 <> hr_api.g_varchar2 THEN
624: l_tax_exemption_indicator := p_per_information11;
625: END IF;
626:
627: IF p_per_information12 <> hr_api.g_varchar2 THEN

Line 627: IF p_per_information12 <> hr_api.g_varchar2 THEN

623: IF p_per_information11 <> hr_api.g_varchar2 THEN
624: l_tax_exemption_indicator := p_per_information11;
625: END IF;
626:
627: IF p_per_information12 <> hr_api.g_varchar2 THEN
628: l_percentage := p_per_information12;
629: END IF;
630:
631: IF p_national_identifier <> hr_api.g_varchar2 THEN

Line 631: IF p_national_identifier <> hr_api.g_varchar2 THEN

627: IF p_per_information12 <> hr_api.g_varchar2 THEN
628: l_percentage := p_per_information12;
629: END IF;
630:
631: IF p_national_identifier <> hr_api.g_varchar2 THEN
632: l_national_identifier := p_national_identifier;
633: END IF;
634:
635:

Line 639: IF p_per_information8 <> hr_api.g_varchar2 and p_per_information8 IS NOT NULL THEN

635:
636: --
637: -- Bug 2900110: Added the following IF..END IF clause for Expat Indicator
638: --
639: IF p_per_information8 <> hr_api.g_varchar2 and p_per_information8 IS NOT NULL THEN
640: l_expatriate_indicator := p_per_information8;
641: END IF;
642:
643: --

Line 646: hr_api.mandatory_arg_error

642:
643: --
644: -- Validation to be carried out only for certain PTs
645: --
646: hr_api.mandatory_arg_error
647: (p_api_name => l_proc,
648: p_argument => 'P_PERSON_TYPE_ID',
649: p_argument_value => p_person_type_id
650: );

Line 652: IF p_person_type_id <> hr_api.g_number

648: p_argument => 'P_PERSON_TYPE_ID',
649: p_argument_value => p_person_type_id
650: );
651:
652: IF p_person_type_id <> hr_api.g_number
653: THEN
654: l_person_type_id := p_person_type_id;
655: END IF;
656: