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_MX_VALIDATIONS dependencies on HR_UTILITY

Line 51: hr_utility.set_message(800,'HR_MX_INVALID_RFC');

47:
48: IF l_valid = '0' THEN
49:
50: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'WARN' THEN
51: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
52: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
53: hr_utility.raise_error;
54: -- p_warning := l_warning;
55: ELSE

Line 52: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));

48: IF l_valid = '0' THEN
49:
50: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'WARN' THEN
51: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
52: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
53: hr_utility.raise_error;
54: -- p_warning := l_warning;
55: ELSE
56: hr_utility.set_message(800,'HR_MX_INVALID_RFC');

Line 53: hr_utility.raise_error;

49:
50: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <>'WARN' THEN
51: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
52: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
53: hr_utility.raise_error;
54: -- p_warning := l_warning;
55: ELSE
56: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
57: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

Line 56: hr_utility.set_message(800,'HR_MX_INVALID_RFC');

52: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
53: hr_utility.raise_error;
54: -- p_warning := l_warning;
55: ELSE
56: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
57: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
58: l_warning := 'Y';
59:
60: END IF;

Line 57: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

53: hr_utility.raise_error;
54: -- p_warning := l_warning;
55: ELSE
56: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
57: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
58: l_warning := 'Y';
59:
60: END IF;
61:

Line 89: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');

85: AND translate(l_valid, '1-', '1') = translate(pp.per_information2, '1-', '1')
86: AND pp.business_group_id +0 = p_business_group_id);
87:
88: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
89: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
90: hr_utility.set_message_token( 'ACTION', ' ');
91: hr_utility.raise_error;
92: ELSE
93: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');

Line 90: hr_utility.set_message_token( 'ACTION', ' ');

86: AND pp.business_group_id +0 = p_business_group_id);
87:
88: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
89: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
90: hr_utility.set_message_token( 'ACTION', ' ');
91: hr_utility.raise_error;
92: ELSE
93: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
94: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

Line 91: hr_utility.raise_error;

87:
88: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
89: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
90: hr_utility.set_message_token( 'ACTION', ' ');
91: hr_utility.raise_error;
92: ELSE
93: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
94: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
95: l_warning := 'Y';

Line 93: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');

89: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
90: hr_utility.set_message_token( 'ACTION', ' ');
91: hr_utility.raise_error;
92: ELSE
93: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
94: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
95: l_warning := 'Y';
96: END IF;
97: p_warning := l_warning;

Line 94: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

90: hr_utility.set_message_token( 'ACTION', ' ');
91: hr_utility.raise_error;
92: ELSE
93: hr_utility.set_message(800,'HR_MX_RFC_UNIQUE_ERROR');
94: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
95: l_warning := 'Y';
96: END IF;
97: p_warning := l_warning;
98:

Line 108: hr_utility.set_message(800,'HR_MX_INVALID_RFC');

104: END IF;
105:
106: EXCEPTION
107: WHEN VALUE_ERROR THEN
108: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
109: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
110: hr_utility.raise_error;
111: --
112: END check_RFC;

Line 109: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));

105:
106: EXCEPTION
107: WHEN VALUE_ERROR THEN
108: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
109: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
110: hr_utility.raise_error;
111: --
112: END check_RFC;
113:

Line 110: hr_utility.raise_error;

106: EXCEPTION
107: WHEN VALUE_ERROR THEN
108: hr_utility.set_message(800,'HR_MX_INVALID_RFC');
109: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
110: hr_utility.raise_error;
111: --
112: END check_RFC;
113:
114: --------------------------------------------------------------------------

Line 161: hr_utility.set_message(800,'HR_MX_INVALID_SS');

157:
158: IF l_valid = '0' THEN
159:
160: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
161: hr_utility.set_message(800,'HR_MX_INVALID_SS');
162: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
163: hr_utility.raise_error;
164: ELSE
165: hr_utility.set_message(800,'HR_MX_INVALID_SS');

Line 162: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));

158: IF l_valid = '0' THEN
159:
160: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
161: hr_utility.set_message(800,'HR_MX_INVALID_SS');
162: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
163: hr_utility.raise_error;
164: ELSE
165: hr_utility.set_message(800,'HR_MX_INVALID_SS');
166: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

Line 163: hr_utility.raise_error;

159:
160: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
161: hr_utility.set_message(800,'HR_MX_INVALID_SS');
162: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
163: hr_utility.raise_error;
164: ELSE
165: hr_utility.set_message(800,'HR_MX_INVALID_SS');
166: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
167: l_warning := 'Y';

Line 165: hr_utility.set_message(800,'HR_MX_INVALID_SS');

161: hr_utility.set_message(800,'HR_MX_INVALID_SS');
162: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
163: hr_utility.raise_error;
164: ELSE
165: hr_utility.set_message(800,'HR_MX_INVALID_SS');
166: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
167: l_warning := 'Y';
168:
169: END IF;

Line 166: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

162: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
163: hr_utility.raise_error;
164: ELSE
165: hr_utility.set_message(800,'HR_MX_INVALID_SS');
166: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
167: l_warning := 'Y';
168:
169: END IF;
170:

Line 199: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');

195: AND translate(l_valid, '1-', '1') = translate(pp.per_information3, '1-', '1')
196: AND pp.business_group_id +0 = p_business_group_id);
197:
198: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
199: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
200: hr_utility.set_message_token( 'ACTION', ' ');
201: hr_utility.raise_error;
202: ELSE
203: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');

Line 200: hr_utility.set_message_token( 'ACTION', ' ');

196: AND pp.business_group_id +0 = p_business_group_id);
197:
198: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
199: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
200: hr_utility.set_message_token( 'ACTION', ' ');
201: hr_utility.raise_error;
202: ELSE
203: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
204: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

Line 201: hr_utility.raise_error;

197:
198: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
199: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
200: hr_utility.set_message_token( 'ACTION', ' ');
201: hr_utility.raise_error;
202: ELSE
203: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
204: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
205: l_warning := 'Y';

Line 203: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');

199: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
200: hr_utility.set_message_token( 'ACTION', ' ');
201: hr_utility.raise_error;
202: ELSE
203: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
204: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
205: l_warning := 'Y';
206: END IF;
207: p_warning := l_warning;

Line 204: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

200: hr_utility.set_message_token( 'ACTION', ' ');
201: hr_utility.raise_error;
202: ELSE
203: hr_utility.set_message(800,'HR_MX_SS_UNIQUE_ERROR');
204: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
205: l_warning := 'Y';
206: END IF;
207: p_warning := l_warning;
208:

Line 219: hr_utility.set_message(800,'HR_MX_INVALID_SS');

215: END IF;
216:
217: EXCEPTION
218: WHEN VALUE_ERROR THEN
219: hr_utility.set_message(800,'HR_MX_INVALID_SS');
220: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
221: hr_utility.raise_error;
222:
223: --

Line 220: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));

216:
217: EXCEPTION
218: WHEN VALUE_ERROR THEN
219: hr_utility.set_message(800,'HR_MX_INVALID_SS');
220: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
221: hr_utility.raise_error;
222:
223: --
224: END check_SS;

Line 221: hr_utility.raise_error;

217: EXCEPTION
218: WHEN VALUE_ERROR THEN
219: hr_utility.set_message(800,'HR_MX_INVALID_SS');
220: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
221: hr_utility.raise_error;
222:
223: --
224: END check_SS;
225:

Line 266: hr_utility.set_message(800,'HR_MX_INVALID_MS');

262: --
263: IF length(p_ms_id) <> 13 THEN
264:
265: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
266: hr_utility.set_message(800,'HR_MX_INVALID_MS');
267: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
268: hr_utility.raise_error;
269: ELSE
270: hr_utility.set_message(800,'HR_MX_INVALID_MS');

Line 267: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));

263: IF length(p_ms_id) <> 13 THEN
264:
265: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
266: hr_utility.set_message(800,'HR_MX_INVALID_MS');
267: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
268: hr_utility.raise_error;
269: ELSE
270: hr_utility.set_message(800,'HR_MX_INVALID_MS');
271: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

Line 268: hr_utility.raise_error;

264:
265: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
266: hr_utility.set_message(800,'HR_MX_INVALID_MS');
267: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
268: hr_utility.raise_error;
269: ELSE
270: hr_utility.set_message(800,'HR_MX_INVALID_MS');
271: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
272:

Line 270: hr_utility.set_message(800,'HR_MX_INVALID_MS');

266: hr_utility.set_message(800,'HR_MX_INVALID_MS');
267: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
268: hr_utility.raise_error;
269: ELSE
270: hr_utility.set_message(800,'HR_MX_INVALID_MS');
271: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
272:
273: l_warning := 'Y';
274:

Line 271: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

267: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
268: hr_utility.raise_error;
269: ELSE
270: hr_utility.set_message(800,'HR_MX_INVALID_MS');
271: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
272:
273: l_warning := 'Y';
274:
275: END IF;

Line 301: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');

297: AND p_ms_id = pp.per_information6
298: AND pp.business_group_id = p_business_group_id);
299:
300: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
301: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
302: hr_utility.set_message_token( 'ACTION', ' ');
303: hr_utility.raise_error;
304: ELSE
305: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');

Line 302: hr_utility.set_message_token( 'ACTION', ' ');

298: AND pp.business_group_id = p_business_group_id);
299:
300: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
301: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
302: hr_utility.set_message_token( 'ACTION', ' ');
303: hr_utility.raise_error;
304: ELSE
305: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
306: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

Line 303: hr_utility.raise_error;

299:
300: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
301: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
302: hr_utility.set_message_token( 'ACTION', ' ');
303: hr_utility.raise_error;
304: ELSE
305: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
306: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
307: l_warning := 'Y';

Line 305: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');

301: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
302: hr_utility.set_message_token( 'ACTION', ' ');
303: hr_utility.raise_error;
304: ELSE
305: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
306: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
307: l_warning := 'Y';
308: END IF;
309: p_warning := l_warning;

Line 306: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

302: hr_utility.set_message_token( 'ACTION', ' ');
303: hr_utility.raise_error;
304: ELSE
305: hr_utility.set_message(800,'HR_MX_MS_UNIQUE_ERROR');
306: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
307: l_warning := 'Y';
308: END IF;
309: p_warning := l_warning;
310:

Line 360: hr_utility.set_message(800,'HR_MX_INVALID_FGA');

356: --
357: IF length(p_fga_id) <> 13 THEN
358:
359: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
360: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
361: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
362: hr_utility.raise_error;
363: ELSE
364: hr_utility.set_message(800,'HR_MX_INVALID_FGA');

Line 361: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));

357: IF length(p_fga_id) <> 13 THEN
358:
359: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
360: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
361: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
362: hr_utility.raise_error;
363: ELSE
364: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
365: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

Line 362: hr_utility.raise_error;

358:
359: IF fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' THEN
360: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
361: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
362: hr_utility.raise_error;
363: ELSE
364: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
365: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
366: l_warning := 'Y';

Line 364: hr_utility.set_message(800,'HR_MX_INVALID_FGA');

360: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
361: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
362: hr_utility.raise_error;
363: ELSE
364: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
365: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
366: l_warning := 'Y';
367:
368: END IF;

Line 365: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

361: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
362: hr_utility.raise_error;
363: ELSE
364: hr_utility.set_message(800,'HR_MX_INVALID_FGA');
365: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
366: l_warning := 'Y';
367:
368: END IF;
369:

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

390: AND p_fga_id = pp.per_information5
391: AND pp.business_group_id = p_business_group_id);
392:
393: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
394: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
395: hr_utility.set_message_token( 'ACTION', ' ');
396: hr_utility.raise_error;
397: ELSE
398: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');

Line 395: hr_utility.set_message_token( 'ACTION', ' ');

391: AND pp.business_group_id = p_business_group_id);
392:
393: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
394: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
395: hr_utility.set_message_token( 'ACTION', ' ');
396: hr_utility.raise_error;
397: ELSE
398: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
399: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

Line 396: hr_utility.raise_error;

392:
393: IF fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') = 'ERROR' THEN
394: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
395: hr_utility.set_message_token( 'ACTION', ' ');
396: hr_utility.raise_error;
397: ELSE
398: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
399: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
400: l_warning := 'Y';

Line 398: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');

394: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
395: hr_utility.set_message_token( 'ACTION', ' ');
396: hr_utility.raise_error;
397: ELSE
398: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
399: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
400: l_warning := 'Y';
401: END IF;
402: p_warning := l_warning;

Line 399: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));

395: hr_utility.set_message_token( 'ACTION', ' ');
396: hr_utility.raise_error;
397: ELSE
398: hr_utility.set_message(800,'HR_MX_FGA_UNIQUE_ERROR');
399: hr_utility.set_message_token( 'ACTION', hr_general.decode_lookup('MX_ACTION_TOKEN', 'WARN'));
400: l_warning := 'Y';
401: END IF;
402: p_warning := l_warning;
403:

Line 437: hr_utility.set_message(800,'HR_MX_INVALID_IMC');

433: -- Check if IMSS Medical Center is upto 3 digits long
434: --
435: IF to_number(p_imc_id) > 999 OR to_number(p_imc_id) < 0 THEN
436:
437: hr_utility.set_message(800,'HR_MX_INVALID_IMC');
438: hr_utility.raise_error;
439:
440: END IF;
441: END IF;

Line 438: hr_utility.raise_error;

434: --
435: IF to_number(p_imc_id) > 999 OR to_number(p_imc_id) < 0 THEN
436:
437: hr_utility.set_message(800,'HR_MX_INVALID_IMC');
438: hr_utility.raise_error;
439:
440: END IF;
441: END IF;
442:

Line 449: hr_utility.set_message(800,'HR_MX_INVALID_IMC');

445: WHEN VALUE_ERROR THEN
446: --
447: -- Raise error when non-numeric characters are present in the IMSS Medical Center
448: --
449: hr_utility.set_message(800,'HR_MX_INVALID_IMC');
450: hr_utility.raise_error;
451:
452: END;
453:

Line 450: hr_utility.raise_error;

446: --
447: -- Raise error when non-numeric characters are present in the IMSS Medical Center
448: --
449: hr_utility.set_message(800,'HR_MX_INVALID_IMC');
450: hr_utility.raise_error;
451:
452: END;
453:
454: --

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

483: l_valid := hr_ni_chk_pkg.chk_nat_id_format( p_regstrn_id, 'AADDDDDD');
484:
485: IF l_valid = '0' THEN
486:
487: hr_utility.set_message(800,'HR_MX_INVALID_DISAB_ID');
488: hr_utility.raise_error;
489:
490: END IF;
491:

Line 488: hr_utility.raise_error;

484:
485: IF l_valid = '0' THEN
486:
487: hr_utility.set_message(800,'HR_MX_INVALID_DISAB_ID');
488: hr_utility.raise_error;
489:
490: END IF;
491:
492: -- Check for uniqueness of Registration ID.

Line 505: hr_utility.set_message(800,'HR_MX_DISAB_ID_UNIQUE_ERROR');

501: OR p_disab_id <> pdf.disability_id)
502: AND l_valid = pdf.registration_id
503: );
504:
505: hr_utility.set_message(800,'HR_MX_DISAB_ID_UNIQUE_ERROR');
506: hr_utility.raise_error;
507:
508: EXCEPTION
509: WHEN NO_DATA_FOUND THEN

Line 506: hr_utility.raise_error;

502: AND l_valid = pdf.registration_id
503: );
504:
505: hr_utility.set_message(800,'HR_MX_DISAB_ID_UNIQUE_ERROR');
506: hr_utility.raise_error;
507:
508: EXCEPTION
509: WHEN NO_DATA_FOUND THEN
510: null;

Line 542: hr_utility.set_message(800,'HR_MX_INVALID_LOOKUP_CODE');

538: -- Check if the lookup_code for leaving reason exists in the lookup
539: --
540: IF hr_general.decode_lookup('MX_STAT_IMSS_LEAVING_REASON', p_ss_leaving_reason) IS NULL THEN
541:
542: hr_utility.set_message(800,'HR_MX_INVALID_LOOKUP_CODE');
543: hr_utility.set_message_token( 'LOOKUP_TYPE', 'MX_STAT_IMSS_LEAVING_REASON');
544: hr_utility.set_message_token( 'LOOKUP_CODE', p_ss_leaving_reason);
545: hr_utility.raise_error;
546:

Line 543: hr_utility.set_message_token( 'LOOKUP_TYPE', 'MX_STAT_IMSS_LEAVING_REASON');

539: --
540: IF hr_general.decode_lookup('MX_STAT_IMSS_LEAVING_REASON', p_ss_leaving_reason) IS NULL THEN
541:
542: hr_utility.set_message(800,'HR_MX_INVALID_LOOKUP_CODE');
543: hr_utility.set_message_token( 'LOOKUP_TYPE', 'MX_STAT_IMSS_LEAVING_REASON');
544: hr_utility.set_message_token( 'LOOKUP_CODE', p_ss_leaving_reason);
545: hr_utility.raise_error;
546:
547: END IF;

Line 544: hr_utility.set_message_token( 'LOOKUP_CODE', p_ss_leaving_reason);

540: IF hr_general.decode_lookup('MX_STAT_IMSS_LEAVING_REASON', p_ss_leaving_reason) IS NULL THEN
541:
542: hr_utility.set_message(800,'HR_MX_INVALID_LOOKUP_CODE');
543: hr_utility.set_message_token( 'LOOKUP_TYPE', 'MX_STAT_IMSS_LEAVING_REASON');
544: hr_utility.set_message_token( 'LOOKUP_CODE', p_ss_leaving_reason);
545: hr_utility.raise_error;
546:
547: END IF;
548: END IF;

Line 545: hr_utility.raise_error;

541:
542: hr_utility.set_message(800,'HR_MX_INVALID_LOOKUP_CODE');
543: hr_utility.set_message_token( 'LOOKUP_TYPE', 'MX_STAT_IMSS_LEAVING_REASON');
544: hr_utility.set_message_token( 'LOOKUP_CODE', p_ss_leaving_reason);
545: hr_utility.raise_error;
546:
547: END IF;
548: END IF;
549: --