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

Line 102: hr_api.mandatory_arg_error

98: FETCH csr_person_type into l_cwk;
99: CLOSE csr_person_type;
100:
101:
102: hr_api.mandatory_arg_error
103: (p_api_name => l_proc,
104: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','LAST'),
105: p_argument_value => p_last_name
106: );

Line 110: hr_api.mandatory_arg_error

106: );
107:
108: if l_chk = 'Y' then -- Person Type is an Employee
109:
110: hr_api.mandatory_arg_error
111: (p_api_name => l_proc,
112: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','FIRST'),
113: p_argument_value => p_first_name
114: );

Line 116: hr_api.mandatory_arg_error

112: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','FIRST'),
113: p_argument_value => p_first_name
114: );
115:
116: hr_api.mandatory_arg_error
117: (p_api_name => l_proc,
118: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','STATUS'),
119: p_argument_value => p_marital_status
120: );

Line 122: hr_api.mandatory_arg_error

118: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','STATUS'),
119: p_argument_value => p_marital_status
120: );
121:
122: hr_api.mandatory_arg_error
123: (p_api_name => l_proc,
124: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NAT'),
125: p_argument_value => p_nationality
126: );

Line 128: hr_api.mandatory_arg_error

124: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NAT'),
125: p_argument_value => p_nationality
126: );
127:
128: hr_api.mandatory_arg_error
129: (p_api_name => l_proc,
130: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','BIRTH'),
131: p_argument_value => p_date_of_birth
132: );

Line 134: hr_api.mandatory_arg_error

130: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','BIRTH'),
131: p_argument_value => p_date_of_birth
132: );
133: /*legal employer mandatory for employee*/
134: hr_api.mandatory_arg_error
135: (p_api_name => l_proc,
136: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','LEGAL_EMPLOYER'),
137: p_argument_value => p_per_information7
138: );

Line 140: hr_api.mandatory_arg_error

136: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','LEGAL_EMPLOYER'),
137: p_argument_value => p_per_information7
138: );
139: --Citizenship Mandatory for Employee.
140: hr_api.mandatory_arg_error
141: (p_api_name => l_proc,
142: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CITIZENSHIP'),
143: p_argument_value => p_per_information8
144: );

Line 147: hr_api.mandatory_arg_error

143: p_argument_value => p_per_information8
144: );
145:
146: --National Fund of Health Mandatory for Employee.
147: hr_api.mandatory_arg_error
148: (p_api_name => l_proc,
149: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NATIONAL_FUND_OF_HEALTH'),
150: p_argument_value => p_per_information5
151: );

Line 154: --if p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality = 'PQH_PL') then

150: p_argument_value => p_per_information5
151: );
152: --Modified the condition to check for PESEL and NIP.
153: --NIP and PESEL are mandatory if both Nationality and Citizenship are Polish.
154: --if p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality = 'PQH_PL') then
155:
156: if ((p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality = 'PQH_PL'))
157: and
158: (p_per_information8 = 'PL' or (p_per_information8= hr_api.g_varchar2 and l_csr_per_value.per_information8 = 'PL'))

Line 156: if ((p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality = 'PQH_PL'))

152: --Modified the condition to check for PESEL and NIP.
153: --NIP and PESEL are mandatory if both Nationality and Citizenship are Polish.
154: --if p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality = 'PQH_PL') then
155:
156: if ((p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality = 'PQH_PL'))
157: and
158: (p_per_information8 = 'PL' or (p_per_information8= hr_api.g_varchar2 and l_csr_per_value.per_information8 = 'PL'))
159: )then
160: if p_national_identifier is NULL or (p_national_identifier = hr_api.g_varchar2 and l_csr_per_value.national_identifier is null) then

Line 158: (p_per_information8 = 'PL' or (p_per_information8= hr_api.g_varchar2 and l_csr_per_value.per_information8 = 'PL'))

154: --if p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality = 'PQH_PL') then
155:
156: if ((p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality = 'PQH_PL'))
157: and
158: (p_per_information8 = 'PL' or (p_per_information8= hr_api.g_varchar2 and l_csr_per_value.per_information8 = 'PL'))
159: )then
160: if p_national_identifier is NULL or (p_national_identifier = hr_api.g_varchar2 and l_csr_per_value.national_identifier is null) then
161: /* Bug fix 4627784 add check fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') */
162: if fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') then

Line 160: if p_national_identifier is NULL or (p_national_identifier = hr_api.g_varchar2 and l_csr_per_value.national_identifier is null) then

156: if ((p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality = 'PQH_PL'))
157: and
158: (p_per_information8 = 'PL' or (p_per_information8= hr_api.g_varchar2 and l_csr_per_value.per_information8 = 'PL'))
159: )then
160: if p_national_identifier is NULL or (p_national_identifier = hr_api.g_varchar2 and l_csr_per_value.national_identifier is null) then
161: /* Bug fix 4627784 add check fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') */
162: if fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') then
163: hr_api.mandatory_arg_error
164: (p_api_name => l_proc,

Line 163: hr_api.mandatory_arg_error

159: )then
160: if p_national_identifier is NULL or (p_national_identifier = hr_api.g_varchar2 and l_csr_per_value.national_identifier is null) then
161: /* Bug fix 4627784 add check fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') */
162: if fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') in ('ERROR','WARN') then
163: hr_api.mandatory_arg_error
164: (p_api_name => l_proc,
165: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PESEL'),
166: p_argument_value => identifier_chk
167: );

Line 171: if p_per_information1 is NULL or (p_per_information1 = hr_api.g_varchar2 and l_csr_per_value.per_information1 is null) then

167: );
168: end if;
169: end if;
170: /* Commented by nprasath for Bug 6272487
171: if p_per_information1 is NULL or (p_per_information1 = hr_api.g_varchar2 and l_csr_per_value.per_information1 is null) then
172: hr_api.mandatory_arg_error
173: (p_api_name => l_proc,
174: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NIP'),
175: p_argument_value => identifier_chk --passing this value as it is bound to fail

Line 172: hr_api.mandatory_arg_error

168: end if;
169: end if;
170: /* Commented by nprasath for Bug 6272487
171: if p_per_information1 is NULL or (p_per_information1 = hr_api.g_varchar2 and l_csr_per_value.per_information1 is null) then
172: hr_api.mandatory_arg_error
173: (p_api_name => l_proc,
174: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','NIP'),
175: p_argument_value => identifier_chk --passing this value as it is bound to fail
176: );

Line 211: if ( ( p_per_information2 = 'Y' or (p_per_information2 = hr_api.g_varchar2 and l_csr_per_value.per_information2 = 'Y'))

207:
208: elsif l_con = 'Y' then -- Person Type is Contact
209:
210:
211: if ( ( p_per_information2 = 'Y' or (p_per_information2 = hr_api.g_varchar2 and l_csr_per_value.per_information2 = 'Y'))
212: or ( p_per_information3 = 'Y' or (p_per_information3 = hr_api.g_varchar2 and l_csr_per_value.per_information3 = 'Y'))
213: ) then
214:
215: -- Bug 4567534 : Replaced hr_api.mandatory_arg_error with an error message

Line 212: or ( p_per_information3 = 'Y' or (p_per_information3 = hr_api.g_varchar2 and l_csr_per_value.per_information3 = 'Y'))

208: elsif l_con = 'Y' then -- Person Type is Contact
209:
210:
211: if ( ( p_per_information2 = 'Y' or (p_per_information2 = hr_api.g_varchar2 and l_csr_per_value.per_information2 = 'Y'))
212: or ( p_per_information3 = 'Y' or (p_per_information3 = hr_api.g_varchar2 and l_csr_per_value.per_information3 = 'Y'))
213: ) then
214:
215: -- Bug 4567534 : Replaced hr_api.mandatory_arg_error with an error message
216: if p_first_name is null then

Line 215: -- Bug 4567534 : Replaced hr_api.mandatory_arg_error with an error message

211: if ( ( p_per_information2 = 'Y' or (p_per_information2 = hr_api.g_varchar2 and l_csr_per_value.per_information2 = 'Y'))
212: or ( p_per_information3 = 'Y' or (p_per_information3 = hr_api.g_varchar2 and l_csr_per_value.per_information3 = 'Y'))
213: ) then
214:
215: -- Bug 4567534 : Replaced hr_api.mandatory_arg_error with an error message
216: if p_first_name is null then
217: hr_utility.set_message(800,'HR_375873_FIRST_NAME_REQD');
218: hr_utility.raise_error;
219: end if;

Line 222: hr_api.mandatory_arg_error

218: hr_utility.raise_error;
219: end if;
220:
221: --Citizenship Mandatory for contact if either insured by or inheritor is yes.
222: hr_api.mandatory_arg_error
223: (p_api_name => l_proc,
224: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CITIZENSHIP'),
225: p_argument_value => p_per_information8
226: );

Line 230: if ( (p_per_information3 = 'Y' or (p_per_information3 = hr_api.g_varchar2 and l_csr_per_value.per_information3 = 'Y'))

226: );
227:
228: /*********************Validations surrounding Inheritor is Yes******************/
229: /* Commented by nprasath for Bug 6272487
230: if ( (p_per_information3 = 'Y' or (p_per_information3 = hr_api.g_varchar2 and l_csr_per_value.per_information3 = 'Y'))
231: and (p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality= 'PQH_PL'))
232: and (p_per_information8 = 'PL' or (p_per_information8= hr_api.g_varchar2 and l_csr_per_value.per_information8 = 'PL'))
233: ) then
234:

Line 231: and (p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality= 'PQH_PL'))

227:
228: /*********************Validations surrounding Inheritor is Yes******************/
229: /* Commented by nprasath for Bug 6272487
230: if ( (p_per_information3 = 'Y' or (p_per_information3 = hr_api.g_varchar2 and l_csr_per_value.per_information3 = 'Y'))
231: and (p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality= 'PQH_PL'))
232: and (p_per_information8 = 'PL' or (p_per_information8= hr_api.g_varchar2 and l_csr_per_value.per_information8 = 'PL'))
233: ) then
234:
235: -- Bug 4567534 : Replaced hr_api.mandatory_arg_error with an error message

Line 232: and (p_per_information8 = 'PL' or (p_per_information8= hr_api.g_varchar2 and l_csr_per_value.per_information8 = 'PL'))

228: /*********************Validations surrounding Inheritor is Yes******************/
229: /* Commented by nprasath for Bug 6272487
230: if ( (p_per_information3 = 'Y' or (p_per_information3 = hr_api.g_varchar2 and l_csr_per_value.per_information3 = 'Y'))
231: and (p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality= 'PQH_PL'))
232: and (p_per_information8 = 'PL' or (p_per_information8= hr_api.g_varchar2 and l_csr_per_value.per_information8 = 'PL'))
233: ) then
234:
235: -- Bug 4567534 : Replaced hr_api.mandatory_arg_error with an error message
236: if p_per_information1 is null then

Line 235: -- Bug 4567534 : Replaced hr_api.mandatory_arg_error with an error message

231: and (p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality= 'PQH_PL'))
232: and (p_per_information8 = 'PL' or (p_per_information8= hr_api.g_varchar2 and l_csr_per_value.per_information8 = 'PL'))
233: ) then
234:
235: -- Bug 4567534 : Replaced hr_api.mandatory_arg_error with an error message
236: if p_per_information1 is null then
237: hr_utility.set_message(800,'HR_375874_NIP_REQD');
238: hr_utility.raise_error;
239: end if;

Line 244: if ( p_per_information2 = 'Y' or (p_per_information2 = hr_api.g_varchar2 and l_csr_per_value.per_information2 = 'Y')) then

240:
241: end if; */
242:
243: /**********Validations surrounding Insured by employee is Yes******************/
244: if ( p_per_information2 = 'Y' or (p_per_information2 = hr_api.g_varchar2 and l_csr_per_value.per_information2 = 'Y')) then
245:
246: hr_api.mandatory_arg_error
247: (p_api_name => l_proc,
248: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','BIRTH'),

Line 246: hr_api.mandatory_arg_error

242:
243: /**********Validations surrounding Insured by employee is Yes******************/
244: if ( p_per_information2 = 'Y' or (p_per_information2 = hr_api.g_varchar2 and l_csr_per_value.per_information2 = 'Y')) then
245:
246: hr_api.mandatory_arg_error
247: (p_api_name => l_proc,
248: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','BIRTH'),
249: p_argument_value => p_date_of_birth
250: );

Line 252: if ((p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality = 'PQH_PL'))

248: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','BIRTH'),
249: p_argument_value => p_date_of_birth
250: );
251:
252: if ((p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality = 'PQH_PL'))
253: and (p_per_information8 = 'PL' or (p_per_information8= hr_api.g_varchar2 and l_csr_per_value.per_information8 = 'PL'))
254: )then
255: /* NIP/PESEL enhancement.If Insured by employee is yes and
256: nationality and citizenship are polish,NIP or PESEL needs to be entered.*/

Line 253: and (p_per_information8 = 'PL' or (p_per_information8= hr_api.g_varchar2 and l_csr_per_value.per_information8 = 'PL'))

249: p_argument_value => p_date_of_birth
250: );
251:
252: if ((p_nationality = 'PQH_PL' or (p_nationality = hr_api.g_varchar2 and l_csr_per_value.nationality = 'PQH_PL'))
253: and (p_per_information8 = 'PL' or (p_per_information8= hr_api.g_varchar2 and l_csr_per_value.per_information8 = 'PL'))
254: )then
255: /* NIP/PESEL enhancement.If Insured by employee is yes and
256: nationality and citizenship are polish,NIP or PESEL needs to be entered.*/
257:

Line 260: or ((p_per_information1 = hr_api.g_varchar2 and l_csr_per_value.per_information1 is null) --NIP is null

256: nationality and citizenship are polish,NIP or PESEL needs to be entered.*/
257:
258:
259: if( ( p_per_information1 is null and p_national_identifier is null )
260: or ((p_per_information1 = hr_api.g_varchar2 and l_csr_per_value.per_information1 is null) --NIP is null
261: and (p_national_identifier = hr_api.g_varchar2 and l_csr_per_value.national_identifier is null) --PESEL is null
262: )
263: )then
264: hr_utility.set_message(800,'HR_375878_NIP_OR_PESEL');

Line 261: and (p_national_identifier = hr_api.g_varchar2 and l_csr_per_value.national_identifier is null) --PESEL is null

257:
258:
259: if( ( p_per_information1 is null and p_national_identifier is null )
260: or ((p_per_information1 = hr_api.g_varchar2 and l_csr_per_value.per_information1 is null) --NIP is null
261: and (p_national_identifier = hr_api.g_varchar2 and l_csr_per_value.national_identifier is null) --PESEL is null
262: )
263: )then
264: hr_utility.set_message(800,'HR_375878_NIP_OR_PESEL');
265: hr_utility.raise_error;

Line 280: hr_api.mandatory_arg_error

276: elsif (l_cwk = 'Y' or l_app = 'Y') then
277:
278: -- This is neither a Contact nor an Employee (like Contingent/Applicant)
279:
280: hr_api.mandatory_arg_error
281: (p_api_name => l_proc,
282: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','FIRST'),
283: p_argument_value => p_first_name
284: );

Line 291: if p_national_identifier is not null and p_national_identifier <> hr_api.g_varchar2 then

287: end if; -- End if of Person Type in 'Employee/Contact'
288:
289:
290:
291: if p_national_identifier is not null and p_national_identifier <> hr_api.g_varchar2 then
292: hr_pl_utility.per_pl_validate(p_national_identifier);
293: if p_per_information7 is not null then
294: hr_pl_utility.per_pl_check_ni_unique(p_national_identifier,p_person_id,per_business_group_id,p_per_information7);
295: end if;

Line 298: if p_per_information1 is not null and p_per_information1 <> hr_api.g_varchar2 then

294: hr_pl_utility.per_pl_check_ni_unique(p_national_identifier,p_person_id,per_business_group_id,p_per_information7);
295: end if;
296: end if;
297:
298: if p_per_information1 is not null and p_per_information1 <> hr_api.g_varchar2 then
299: hr_pl_utility.per_pl_nip_validate(p_per_information1,p_person_id,per_business_group_id,p_per_information7,p_nationality,
300: p_per_information8);
301: end if;
302: