DBA Data[Home] [Help]

APPS.PER_MX_VALIDATE_ID dependencies on HR_UTILITY

Line 65: hr_utility.set_message(800, p_message);

61:
62: IF p_value1 = p_value2 OR NVL(p_value1, p_value2) IS NULL THEN
63: null;
64: ELSE
65: hr_utility.set_message(800, p_message);
66: hr_utility.set_message_token('ACTION',
67: hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
68: hr_utility.raise_error;
69: END IF;

Line 66: hr_utility.set_message_token('ACTION',

62: IF p_value1 = p_value2 OR NVL(p_value1, p_value2) IS NULL THEN
63: null;
64: ELSE
65: hr_utility.set_message(800, p_message);
66: hr_utility.set_message_token('ACTION',
67: hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
68: hr_utility.raise_error;
69: END IF;
70: END IF;

Line 68: hr_utility.raise_error;

64: ELSE
65: hr_utility.set_message(800, p_message);
66: hr_utility.set_message_token('ACTION',
67: hr_general.decode_lookup('MX_ACTION_TOKEN', 'ERROR'));
68: hr_utility.raise_error;
69: END IF;
70: END IF;
71: --
72: END compare_id;

Line 90: hr_utility.trace('Entering '||l_proc_name);

86: l_proc_name varchar2(100);
87:
88: BEGIN
89: l_proc_name := glb_proc_name ||'VALIDATE_RFC_ID';
90: hr_utility.trace('Entering '||l_proc_name);
91: -- hr_general2.init_fndload(800); -- Bug 4147647
92: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
93: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
94: RETURN;

Line 92: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN

88: BEGIN
89: l_proc_name := glb_proc_name ||'VALIDATE_RFC_ID';
90: hr_utility.trace('Entering '||l_proc_name);
91: -- hr_general2.init_fndload(800); -- Bug 4147647
92: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
93: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
94: RETURN;
95: END IF;
96:

Line 93: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');

89: l_proc_name := glb_proc_name ||'VALIDATE_RFC_ID';
90: hr_utility.trace('Entering '||l_proc_name);
91: -- hr_general2.init_fndload(800); -- Bug 4147647
92: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
93: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
94: RETURN;
95: END IF;
96:
97: IF p_per_information2 = hr_api.g_varchar2 THEN /* Bug 3777663 */

Line 98: hr_utility.trace('RFC ID not available for validation.');

94: RETURN;
95: END IF;
96:
97: IF p_per_information2 = hr_api.g_varchar2 THEN /* Bug 3777663 */
98: hr_utility.trace('RFC ID not available for validation.');
99: RETURN;
100: END IF;
101:
102: per_mx_validations.check_rfc (p_per_information2,

Line 110: hr_utility.trace('Leaving '||l_proc_name);

106: p_valid_rfc_id);
107:
108: compare_id(p_per_information2, p_valid_rfc_id, 'HR_MX_INVALID_RFC');
109:
110: hr_utility.trace('Leaving '||l_proc_name);
111: END VALIDATE_RFC_ID;
112:
113: /*******************************************************************************
114: Name : validate_ss_id

Line 128: hr_utility.trace('Entering '||l_proc_name);

124: l_proc_name varchar2(100);
125:
126: BEGIN
127: l_proc_name := glb_proc_name ||'VALIDATE_SS_ID';
128: hr_utility.trace('Entering '||l_proc_name);
129: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
130: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
131: RETURN;
132: END IF;

Line 129: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN

125:
126: BEGIN
127: l_proc_name := glb_proc_name ||'VALIDATE_SS_ID';
128: hr_utility.trace('Entering '||l_proc_name);
129: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
130: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
131: RETURN;
132: END IF;
133:

Line 130: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');

126: BEGIN
127: l_proc_name := glb_proc_name ||'VALIDATE_SS_ID';
128: hr_utility.trace('Entering '||l_proc_name);
129: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
130: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
131: RETURN;
132: END IF;
133:
134: IF p_per_information3 = hr_api.g_varchar2 THEN /* Bug 3777663 */

Line 135: hr_utility.trace('Social Security ID not available for validation.');

131: RETURN;
132: END IF;
133:
134: IF p_per_information3 = hr_api.g_varchar2 THEN /* Bug 3777663 */
135: hr_utility.trace('Social Security ID not available for validation.');
136: RETURN;
137: END IF;
138:
139: -- hr_general2.init_fndload(800); -- Bug 4147647

Line 148: hr_utility.trace('Leaving '||l_proc_name);

144: p_valid_ss);
145:
146: compare_id(p_per_information3, p_valid_ss, 'HR_MX_INVALID_SS');
147:
148: hr_utility.trace('Leaving '||l_proc_name);
149: END VALIDATE_SS_ID;
150:
151:
152: /*******************************************************************************

Line 166: hr_utility.trace('Entering '||l_proc_name);

162: l_proc_name varchar2(100);
163:
164: BEGIN
165: l_proc_name := glb_proc_name ||'VALIDATE_FGA_ID';
166: hr_utility.trace('Entering '||l_proc_name);
167: -- hr_general2.init_fndload(800); -- Bug 4147647
168: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
169: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
170: RETURN;

Line 168: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN

164: BEGIN
165: l_proc_name := glb_proc_name ||'VALIDATE_FGA_ID';
166: hr_utility.trace('Entering '||l_proc_name);
167: -- hr_general2.init_fndload(800); -- Bug 4147647
168: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
169: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
170: RETURN;
171: END IF;
172:

Line 169: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');

165: l_proc_name := glb_proc_name ||'VALIDATE_FGA_ID';
166: hr_utility.trace('Entering '||l_proc_name);
167: -- hr_general2.init_fndload(800); -- Bug 4147647
168: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
169: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
170: RETURN;
171: END IF;
172:
173: IF p_per_information5 = hr_api.g_varchar2 THEN /* Bug 3777663 */

Line 174: hr_utility.trace('Federal Government Affiliation ID not available for validation.');

170: RETURN;
171: END IF;
172:
173: IF p_per_information5 = hr_api.g_varchar2 THEN /* Bug 3777663 */
174: hr_utility.trace('Federal Government Affiliation ID not available for validation.');
175: RETURN;
176: END IF;
177:
178: per_mx_validations.check_fga (p_per_information5,

Line 182: hr_utility.trace('Leaving '||l_proc_name);

178: per_mx_validations.check_fga (p_per_information5,
179: p_person_id,
180: HR_MX_UTILITY.GET_BG_FROM_PERSON(p_person_id),
181: p_warning);
182: hr_utility.trace('Leaving '||l_proc_name);
183: END VALIDATE_FGA_ID;
184:
185:
186: /*******************************************************************************

Line 200: hr_utility.trace('Entering '||l_proc_name);

196: l_proc_name varchar2(100);
197:
198: BEGIN
199: l_proc_name := glb_proc_name ||'VALIDATE_MS_ID';
200: hr_utility.trace('Entering '||l_proc_name);
201: -- hr_general2.init_fndload(800); -- Bug 4147647
202: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
203: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
204: RETURN;

Line 202: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN

198: BEGIN
199: l_proc_name := glb_proc_name ||'VALIDATE_MS_ID';
200: hr_utility.trace('Entering '||l_proc_name);
201: -- hr_general2.init_fndload(800); -- Bug 4147647
202: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
203: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
204: RETURN;
205: END IF;
206:

Line 203: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');

199: l_proc_name := glb_proc_name ||'VALIDATE_MS_ID';
200: hr_utility.trace('Entering '||l_proc_name);
201: -- hr_general2.init_fndload(800); -- Bug 4147647
202: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
203: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
204: RETURN;
205: END IF;
206:
207: IF p_per_information6 = hr_api.g_varchar2 THEN /* Bug 3777663 */

Line 208: hr_utility.trace('Military Service ID not available for validation.');

204: RETURN;
205: END IF;
206:
207: IF p_per_information6 = hr_api.g_varchar2 THEN /* Bug 3777663 */
208: hr_utility.trace('Military Service ID not available for validation.');
209: RETURN;
210: END IF;
211:
212: per_mx_validations.check_ms (p_per_information6,

Line 216: hr_utility.trace('Leaving '||l_proc_name);

212: per_mx_validations.check_ms (p_per_information6,
213: p_person_id,
214: HR_MX_UTILITY.GET_BG_FROM_PERSON(p_person_id),
215: p_warning);
216: hr_utility.trace('Leaving '||l_proc_name);
217: END VALIDATE_MS_ID;
218:
219:
220: /*******************************************************************************

Line 231: hr_utility.trace('Entering '||l_proc_name);

227:
228: l_proc_name varchar2(100);
229: BEGIN
230: l_proc_name := glb_proc_name ||'VALIDATE_IMC_ID';
231: hr_utility.trace('Entering '||l_proc_name);
232: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
233: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
234: RETURN;
235: END IF;

Line 232: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN

228: l_proc_name varchar2(100);
229: BEGIN
230: l_proc_name := glb_proc_name ||'VALIDATE_IMC_ID';
231: hr_utility.trace('Entering '||l_proc_name);
232: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
233: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
234: RETURN;
235: END IF;
236:

Line 233: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');

229: BEGIN
230: l_proc_name := glb_proc_name ||'VALIDATE_IMC_ID';
231: hr_utility.trace('Entering '||l_proc_name);
232: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
233: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
234: RETURN;
235: END IF;
236:
237: IF p_per_information4 = hr_api.g_varchar2 THEN /* Bug 3777663 */

Line 238: hr_utility.trace('Social Security Medical Center ID not available for validation.');

234: RETURN;
235: END IF;
236:
237: IF p_per_information4 = hr_api.g_varchar2 THEN /* Bug 3777663 */
238: hr_utility.trace('Social Security Medical Center ID not available for validation.');
239: RETURN;
240: END IF;
241:
242: -- hr_general2.init_fndload(800); -- Bug 4147647

Line 244: hr_utility.trace('Leaving '||l_proc_name);

240: END IF;
241:
242: -- hr_general2.init_fndload(800); -- Bug 4147647
243: per_mx_validations.check_imc(p_per_information4);
244: hr_utility.trace('Leaving '||l_proc_name);
245: END VALIDATE_IMC_ID;
246:
247:
248: /*******************************************************************************

Line 260: hr_utility.trace('Entering '||l_proc_name);

256:
257: l_proc_name varchar2(100);
258: BEGIN
259: l_proc_name := glb_proc_name ||'VALIDATE_REGN_ID';
260: hr_utility.trace('Entering '||l_proc_name);
261: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
262: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
263: RETURN;
264: END IF;

Line 261: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN

257: l_proc_name varchar2(100);
258: BEGIN
259: l_proc_name := glb_proc_name ||'VALIDATE_REGN_ID';
260: hr_utility.trace('Entering '||l_proc_name);
261: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
262: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
263: RETURN;
264: END IF;
265:

Line 262: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');

258: BEGIN
259: l_proc_name := glb_proc_name ||'VALIDATE_REGN_ID';
260: hr_utility.trace('Entering '||l_proc_name);
261: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'MX') THEN
262: hr_utility.trace('Mexico legislation not installed. Not performing validation checks.');
263: RETURN;
264: END IF;
265:
266: IF p_registration_id = hr_api.g_varchar2 THEN /* Bug 3777663 */

Line 267: hr_utility.trace('Registration ID not available for validation.');

263: RETURN;
264: END IF;
265:
266: IF p_registration_id = hr_api.g_varchar2 THEN /* Bug 3777663 */
267: hr_utility.trace('Registration ID not available for validation.');
268: RETURN;
269: END IF;
270:
271: per_mx_validations.check_regstrn_id(p_registration_id,

Line 273: hr_utility.trace('Leaving '||l_proc_name);

269: END IF;
270:
271: per_mx_validations.check_regstrn_id(p_registration_id,
272: p_disability_id);
273: hr_utility.trace('Leaving '||l_proc_name);
274: END VALIDATE_REGN_ID;
275:
276: BEGIN
277: glb_proc_name := 'PER_MX_VALIDATE_ID.';