DBA Data[Home] [Help]

APPS.PER_CN_EMP_LEG_HOOK dependencies on HR_API

Line 120: hr_api.mandatory_arg_error

116:
117: -- if per_per_bus.g_global_transfer_in_process is null
118: -- or per_per_bus.g_global_transfer_in_process = false then
119:
120: hr_api.mandatory_arg_error
121: (p_api_name => l_proc,
122: p_argument => 'P_PERSON_TYPE_ID',
123: p_argument_value => p_person_type_id
124: );

Line 152: hr_api.mandatory_arg_error

148: -- Bug 3342105 Changes.
149: -- Moved the Expat Indicator and CIN check to this IF block
150:
151: hr_cn_api.set_location(g_trace,l_proc,10);
152: hr_api.mandatory_arg_error
153: (p_api_name => l_proc,
154: p_argument => 'P_EXPATRIATE_INDICATOR',
155: p_argument_value => p_expatriate_indicator
156: );

Line 160: hr_api.mandatory_arg_error

156: );
157:
158: IF p_expatriate_indicator ='N' THEN
159: hr_cn_api.set_location(g_trace,l_proc,20);
160: hr_api.mandatory_arg_error
161: (p_api_name => l_proc,
162: p_argument => 'P_HUKOU_TYPE',
163: p_argument_value => p_hukou_type
164: );

Line 167: hr_api.mandatory_arg_error

163: p_argument_value => p_hukou_type
164: );
165:
166: hr_cn_api.set_location(g_trace,l_proc,30);
167: hr_api.mandatory_arg_error
168: (p_api_name => l_proc,
169: p_argument => 'P_HUKOU_LOCATION',
170: p_argument_value => p_hukou_location
171: );

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

179: -- Bug 2782045 -- In place of p_person_type_id, we call check_cin
180: -- with l_person_type for ease in checking.
181: -- Bug 2902659 -- Tested p_national_identifier for NULL condition
182: --
183: IF (p_national_identifier <> hr_api.g_varchar2) OR (p_national_identifier IS NULL) THEN
184: hr_cn_api.check_cin
185: ( p_business_group_id => p_business_group_id,
186: p_national_identifier => p_national_identifier,
187: p_person_type_id => p_person_type_id,

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

196: -- Check for the valid lookup values
197: --
198: hr_cn_api.set_location(g_trace,l_proc,40);
199:
200: IF p_hukou_type IS NOT NULL and p_hukou_type <> hr_api.g_varchar2 THEN
201: hr_cn_api.check_lookup (
202: p_lookup_type => 'CN_HUKOU_TYPE',
203: p_argument => 'P_HUKOU_TYPE',
204: p_argument_value => p_hukou_type

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

205: );
206: END IF;
207:
208: hr_cn_api.set_location(g_trace,l_proc,50);
209: IF p_hukou_location IS NOT NULL and p_hukou_location <> hr_api.g_varchar2 THEN
210: hr_cn_api.check_lookup (
211: p_lookup_type => 'CN_HUKOU_LOCN',
212: p_argument => 'P_HUKOU_LOCATION',
213: p_argument_value => p_hukou_location

Line 218: IF p_expatriate_indicator <> hr_api.g_varchar2 THEN

214: );
215: END IF;
216:
217: hr_cn_api.set_location(g_trace,l_proc,60);
218: IF p_expatriate_indicator <> hr_api.g_varchar2 THEN
219: hr_cn_api.check_lookup (
220: p_lookup_type => 'YES_NO',
221: p_argument => 'P_EXPATRIATE_INDICATOR',
222: p_argument_value => p_expatriate_indicator

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

223: );
224: END IF;
225:
226: hr_cn_api.set_location(g_trace,l_proc,70);
227: IF p_race_ethnic_origin is not null AND p_race_ethnic_origin <> hr_api.g_varchar2
228: THEN
229: hr_cn_api.check_lookup (
230: p_lookup_type => 'CN_RACE',
231: p_argument => 'P_RACE_ETHNIC_ORGIN',

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

233: );
234: END IF;
235:
236: hr_cn_api.set_location(g_trace,l_proc,80);
237: IF p_highest_education_level is not null AND p_highest_education_level <> hr_api.g_varchar2
238: THEN
239: hr_cn_api.check_lookup (
240: p_lookup_type => 'CN_HIGH_EDU_LEVEL',
241: p_argument => 'P_HIGHEST_EDUCATION_LEVEL',

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

243: );
244: END IF;
245:
246: hr_cn_api.set_location(g_trace,l_proc,90);
247: IF p_health_status is not null AND p_health_status <> hr_api.g_varchar2
248: THEN
249: hr_cn_api.check_lookup (
250: p_lookup_type => 'CN_HEALTH_STATUS',
251: p_argument => 'P_HEALTH_STATUS',

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

253: );
254: END IF;
255:
256: hr_cn_api.set_location(g_trace,l_proc,100);
257: IF p_tax_exemption_indicator is not null AND p_tax_exemption_indicator <> hr_api.g_varchar2
258: THEN
259: hr_cn_api.check_lookup (
260: p_lookup_type => 'YES_NO',
261: p_argument => 'P_TAX_EXEMPTION_INDICATOR',

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

267: --
268: -- Validation for Number of Children
269: --
270: hr_cn_api.set_location(g_trace,l_proc,110);
271: IF p_number_of_children is not null AND p_number_of_children <> hr_api.g_varchar2
272: THEN
273: --
274: IF hr_cn_api.is_number(p_number_of_children) THEN
275: --

Line 641: IF p_per_information11 <> hr_api.g_varchar2 THEN

637: FETCH csr_per INTO l_person_type_id, l_tax_exemption_indicator, l_percentage, l_expatriate_indicator
638: ,l_national_identifier;
639: CLOSE csr_per;
640:
641: IF p_per_information11 <> hr_api.g_varchar2 THEN
642: l_tax_exemption_indicator := p_per_information11;
643: END IF;
644:
645: IF p_per_information12 <> hr_api.g_varchar2 THEN

Line 645: IF p_per_information12 <> hr_api.g_varchar2 THEN

641: IF p_per_information11 <> hr_api.g_varchar2 THEN
642: l_tax_exemption_indicator := p_per_information11;
643: END IF;
644:
645: IF p_per_information12 <> hr_api.g_varchar2 THEN
646: l_percentage := p_per_information12;
647: END IF;
648:
649: IF p_national_identifier <> hr_api.g_varchar2 THEN

Line 649: IF p_national_identifier <> hr_api.g_varchar2 THEN

645: IF p_per_information12 <> hr_api.g_varchar2 THEN
646: l_percentage := p_per_information12;
647: END IF;
648:
649: IF p_national_identifier <> hr_api.g_varchar2 THEN
650: l_national_identifier := p_national_identifier;
651: END IF;
652:
653:

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

653:
654: --
655: -- Bug 2900110: Added the following IF..END IF clause for Expat Indicator
656: --
657: IF p_per_information8 <> hr_api.g_varchar2 and p_per_information8 IS NOT NULL THEN
658: l_expatriate_indicator := p_per_information8;
659: END IF;
660:
661: --

Line 664: hr_api.mandatory_arg_error

660:
661: --
662: -- Validation to be carried out only for certain PTs
663: --
664: hr_api.mandatory_arg_error
665: (p_api_name => l_proc,
666: p_argument => 'P_PERSON_TYPE_ID',
667: p_argument_value => p_person_type_id
668: );

Line 670: IF p_person_type_id <> hr_api.g_number

666: p_argument => 'P_PERSON_TYPE_ID',
667: p_argument_value => p_person_type_id
668: );
669:
670: IF p_person_type_id <> hr_api.g_number
671: THEN
672: l_person_type_id := p_person_type_id;
673: END IF;
674: