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.EAM_CLEARANCE_VALIDATE_PVT dependencies on FND_API

Line 57: l_return_status := FND_API.G_RET_STS_ERROR;

53: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
54: p_message_name => 'EAM_SAFETY_ALREADY_EXISTS' ,
55: p_token_tbl => l_token_tbl );
56: l_mesg_token_tbl := l_out_mesg_token_tbl;
57: l_return_status := FND_API.G_RET_STS_ERROR;
58:
59: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND p_work_clearance_header_rec.transaction_type IN (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE) THEN
60: l_token_tbl(1).token_name := 'SAFETY_NAME';
61: l_token_tbl(1).token_value := p_work_clearance_header_rec.work_clearance_name;

Line 69: l_return_status := FND_API.G_RET_STS_ERROR;

65: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
66: p_message_name => 'EAM_SAFETY_EXISTENCE_ERROR' ,
67: p_token_tbl => l_token_tbl );
68: l_mesg_token_tbl := l_out_mesg_token_tbl;
69: l_return_status := FND_API.G_RET_STS_ERROR;
70:
71: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
72: l_out_mesg_token_tbl := l_mesg_token_tbl;
73: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 71: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

67: p_token_tbl => l_token_tbl );
68: l_mesg_token_tbl := l_out_mesg_token_tbl;
69: l_return_status := FND_API.G_RET_STS_ERROR;
70:
71: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
72: l_out_mesg_token_tbl := l_mesg_token_tbl;
73: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
74: x_Mesg_token_tbl => l_out_Mesg_Token_Tbl ,
75: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,

Line 79: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

75: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
76: p_message_name => NULL ,
77: p_message_text => 'Unexpected error' );
78: l_mesg_token_tbl := l_out_mesg_token_tbl;
79: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
80: ELSE
81: l_return_status := FND_API.G_RET_STS_SUCCESS;
82: x_clearance_header_rec :=l_work_clearance_header_rec;
83: END IF;

Line 81: l_return_status := FND_API.G_RET_STS_SUCCESS;

77: p_message_text => 'Unexpected error' );
78: l_mesg_token_tbl := l_out_mesg_token_tbl;
79: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
80: ELSE
81: l_return_status := FND_API.G_RET_STS_SUCCESS;
82: x_clearance_header_rec :=l_work_clearance_header_rec;
83: END IF;
84: x_return_status := l_return_status;
85: x_mesg_token_tbl := l_mesg_token_tbl;

Line 120: x_return_status := FND_API.G_RET_STS_SUCCESS;

116: mtl_parameters mp
117: WHERE wep.organization_id = mp.organization_id
118: AND mp.eam_enabled_flag = 'Y'
119: AND wep.organization_id = p_work_clearance_header_rec.organization_id;
120: x_return_status := FND_API.G_RET_STS_SUCCESS;
121: EXCEPTION
122: WHEN no_data_found THEN
123: l_out_mesg_token_tbl := l_mesg_token_tbl;
124: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 130: x_return_status := FND_API.G_RET_STS_ERROR;

126: p_token_tbl => l_token_tbl ,
127: p_mesg_token_tbl => l_mesg_token_tbl ,
128: x_mesg_token_tbl => l_out_mesg_token_tbl );
129: l_mesg_token_tbl := l_out_mesg_token_tbl;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: x_mesg_token_tbl := l_mesg_token_tbl ;
132: RETURN;
133: END;
134:

Line 147: raise fnd_api.g_exc_unexpected_error;

143: FROM EAM_WORK_CLEARANCES
144: WHERE WORK_CLEARANCE_ID = p_work_clearance_header_rec.WORK_CLEARANCE_ID
145: AND organization_id = p_work_clearance_header_rec.organization_id;
146: IF(l_count > 0) THEN
147: raise fnd_api.g_exc_unexpected_error;
148: END IF;
149: END IF;
150: x_return_status := FND_API.G_RET_STS_SUCCESS;
151: EXCEPTION

Line 150: x_return_status := FND_API.G_RET_STS_SUCCESS;

146: IF(l_count > 0) THEN
147: raise fnd_api.g_exc_unexpected_error;
148: END IF;
149: END IF;
150: x_return_status := FND_API.G_RET_STS_SUCCESS;
151: EXCEPTION
152: WHEN fnd_api.g_exc_unexpected_error THEN
153: l_token_tbl(1).token_name := 'SAFETY_NAME';
154: l_token_tbl(1).token_value := p_work_clearance_header_rec.WORK_CLEARANCE_NAME;

Line 152: WHEN fnd_api.g_exc_unexpected_error THEN

148: END IF;
149: END IF;
150: x_return_status := FND_API.G_RET_STS_SUCCESS;
151: EXCEPTION
152: WHEN fnd_api.g_exc_unexpected_error THEN
153: l_token_tbl(1).token_name := 'SAFETY_NAME';
154: l_token_tbl(1).token_value := p_work_clearance_header_rec.WORK_CLEARANCE_NAME;
155: l_out_mesg_token_tbl := l_mesg_token_tbl;
156: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 162: x_return_status := FND_API.G_RET_STS_ERROR;

158: p_token_tbl => l_token_tbl ,
159: p_mesg_token_tbl => l_mesg_token_tbl ,
160: x_mesg_token_tbl => l_out_mesg_token_tbl );
161: l_mesg_token_tbl := l_out_mesg_token_tbl;
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: x_mesg_token_tbl := l_mesg_token_tbl ;
164: RETURN;
165: END;
166:

Line 180: raise fnd_api.g_exc_unexpected_error;

176: WHERE WORK_CLEARANCE_ID = p_work_clearance_header_rec.WORK_CLEARANCE_ID
177: AND organization_id = p_work_clearance_header_rec.organization_id;
178:
179: IF(l_count <> 1) THEN
180: raise fnd_api.g_exc_unexpected_error;
181: END IF;
182: END IF;
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: EXCEPTION

Line 183: x_return_status := FND_API.G_RET_STS_SUCCESS;

179: IF(l_count <> 1) THEN
180: raise fnd_api.g_exc_unexpected_error;
181: END IF;
182: END IF;
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: EXCEPTION
185: WHEN fnd_api.g_exc_unexpected_error THEN
186: l_out_mesg_token_tbl := l_mesg_token_tbl;
187: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 185: WHEN fnd_api.g_exc_unexpected_error THEN

181: END IF;
182: END IF;
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184: EXCEPTION
185: WHEN fnd_api.g_exc_unexpected_error THEN
186: l_out_mesg_token_tbl := l_mesg_token_tbl;
187: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
188: p_message_name => 'EAM_SAFETY_ID_NOT_EXIST' ,
189: p_token_tbl => l_token_tbl ,

Line 193: x_return_status := FND_API.G_RET_STS_ERROR;

189: p_token_tbl => l_token_tbl ,
190: p_mesg_token_tbl => l_mesg_token_tbl ,
191: x_mesg_token_tbl => l_out_mesg_token_tbl );
192: l_mesg_token_tbl := l_out_mesg_token_tbl;
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: x_mesg_token_tbl := l_mesg_token_tbl ;
195: RETURN;
196: END;
197:

Line 213: raise fnd_api.g_exc_unexpected_error;

209: FROM EAM_WORK_CLEARANCES
210: WHERE work_clearance_name = p_work_clearance_header_rec.work_clearance_name
211: AND organization_id = p_work_clearance_header_rec.organization_id;
212: IF(l_count > 0) THEN
213: raise fnd_api.g_exc_unexpected_error;
214: END IF;
215: END IF;
216:
217: -- Clearance name should be validated incase of copy Clearance,where transaction type is update.

Line 236: raise fnd_api.g_exc_unexpected_error;

232: END;
233: END IF;
234:
235: IF(l_work_clearance_id <> p_work_clearance_header_rec.WORK_CLEARANCE_ID) THEN
236: raise fnd_api.g_exc_unexpected_error;
237: END IF;
238:
239: x_return_status := FND_API.G_RET_STS_SUCCESS;
240: EXCEPTION

Line 239: x_return_status := FND_API.G_RET_STS_SUCCESS;

235: IF(l_work_clearance_id <> p_work_clearance_header_rec.WORK_CLEARANCE_ID) THEN
236: raise fnd_api.g_exc_unexpected_error;
237: END IF;
238:
239: x_return_status := FND_API.G_RET_STS_SUCCESS;
240: EXCEPTION
241: WHEN fnd_api.g_exc_unexpected_error THEN
242: l_out_mesg_token_tbl := l_mesg_token_tbl;
243: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 241: WHEN fnd_api.g_exc_unexpected_error THEN

237: END IF;
238:
239: x_return_status := FND_API.G_RET_STS_SUCCESS;
240: EXCEPTION
241: WHEN fnd_api.g_exc_unexpected_error THEN
242: l_out_mesg_token_tbl := l_mesg_token_tbl;
243: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
244: p_message_name => 'EAM_SAFETY_NAME' ,
245: p_token_tbl => l_token_tbl ,

Line 249: x_return_status := FND_API.G_RET_STS_ERROR;

245: p_token_tbl => l_token_tbl ,
246: p_mesg_token_tbl => l_mesg_token_tbl ,
247: x_mesg_token_tbl => l_out_mesg_token_tbl );
248: l_mesg_token_tbl := l_out_mesg_token_tbl;
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: x_mesg_token_tbl := l_mesg_token_tbl ;
251: RETURN;
252: END;
253:

Line 259: raise fnd_api.g_exc_unexpected_error;

255: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating status_type. . . '); END IF;
256:
257: BEGIN
258: IF (p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE AND p_work_clearance_header_rec.system_status NOT IN (wip_constants.released, wip_constants.draft)) THEN
259: raise fnd_api.g_exc_unexpected_error;
260: -- elsif (p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND p_work_clearance_header_rec.system_status NOT IN (wip_constants.released, wip_constants.cancelled,wip_constants.comp_chrg,wip_constants.comp_nochrg )) THEN
261: -- raise fnd_api.g_exc_unexpected_error;
262: END IF;
263: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 261: -- raise fnd_api.g_exc_unexpected_error;

257: BEGIN
258: IF (p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE AND p_work_clearance_header_rec.system_status NOT IN (wip_constants.released, wip_constants.draft)) THEN
259: raise fnd_api.g_exc_unexpected_error;
260: -- elsif (p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND p_work_clearance_header_rec.system_status NOT IN (wip_constants.released, wip_constants.cancelled,wip_constants.comp_chrg,wip_constants.comp_nochrg )) THEN
261: -- raise fnd_api.g_exc_unexpected_error;
262: END IF;
263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264: EXCEPTION
265: WHEN fnd_api.g_exc_unexpected_error THEN

Line 263: x_return_status := FND_API.G_RET_STS_SUCCESS;

259: raise fnd_api.g_exc_unexpected_error;
260: -- elsif (p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND p_work_clearance_header_rec.system_status NOT IN (wip_constants.released, wip_constants.cancelled,wip_constants.comp_chrg,wip_constants.comp_nochrg )) THEN
261: -- raise fnd_api.g_exc_unexpected_error;
262: END IF;
263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264: EXCEPTION
265: WHEN fnd_api.g_exc_unexpected_error THEN
266: l_out_mesg_token_tbl := l_mesg_token_tbl;
267: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 265: WHEN fnd_api.g_exc_unexpected_error THEN

261: -- raise fnd_api.g_exc_unexpected_error;
262: END IF;
263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264: EXCEPTION
265: WHEN fnd_api.g_exc_unexpected_error THEN
266: l_out_mesg_token_tbl := l_mesg_token_tbl;
267: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
268: p_message_name => 'EAM_SAFETY_STATUS_TYPE' ,
269: p_token_tbl => l_token_tbl ,

Line 273: x_return_status := FND_API.G_RET_STS_ERROR;

269: p_token_tbl => l_token_tbl ,
270: p_mesg_token_tbl => l_mesg_token_tbl ,
271: x_mesg_token_tbl => l_out_mesg_token_tbl );
272: l_mesg_token_tbl := l_out_mesg_token_tbl;
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: x_mesg_token_tbl := l_mesg_token_tbl ;
275: RETURN;
276: END;
277:

Line 308: raise fnd_api.g_exc_unexpected_error;

304: p_work_clearance_header_rec.ATTRIBUTE13 <> p_old_work_permit_header_rec.ATTRIBUTE13 OR
305: p_work_clearance_header_rec.ATTRIBUTE14 <> p_old_work_permit_header_rec.ATTRIBUTE14 OR
306: p_work_clearance_header_rec.ATTRIBUTE15 <> p_old_work_permit_header_rec.ATTRIBUTE15 OR
307: p_work_clearance_header_rec.APPROVED_BY <> p_old_work_permit_header_rec.APPROVED_BY ) THEN
308: raise fnd_api.g_exc_unexpected_error;
309: END IF;
310: x_return_status := FND_API.G_RET_STS_SUCCESS;
311: EXCEPTION
312: WHEN fnd_api.g_exc_unexpected_error THEN

Line 310: x_return_status := FND_API.G_RET_STS_SUCCESS;

306: p_work_clearance_header_rec.ATTRIBUTE15 <> p_old_work_permit_header_rec.ATTRIBUTE15 OR
307: p_work_clearance_header_rec.APPROVED_BY <> p_old_work_permit_header_rec.APPROVED_BY ) THEN
308: raise fnd_api.g_exc_unexpected_error;
309: END IF;
310: x_return_status := FND_API.G_RET_STS_SUCCESS;
311: EXCEPTION
312: WHEN fnd_api.g_exc_unexpected_error THEN
313: l_token_tbl(1).token_name := 'SAFETY_NAME';
314: l_token_tbl(1).token_value := p_work_clearance_header_rec.WORK_CLEARANCE_NAME;

Line 312: WHEN fnd_api.g_exc_unexpected_error THEN

308: raise fnd_api.g_exc_unexpected_error;
309: END IF;
310: x_return_status := FND_API.G_RET_STS_SUCCESS;
311: EXCEPTION
312: WHEN fnd_api.g_exc_unexpected_error THEN
313: l_token_tbl(1).token_name := 'SAFETY_NAME';
314: l_token_tbl(1).token_value := p_work_clearance_header_rec.WORK_CLEARANCE_NAME;
315: -- l_out_mesg_token_tbl := l_mesg_token_tbl;
316: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 322: x_return_status := FND_API.G_RET_STS_ERROR;

318: p_token_tbl => l_token_tbl ,
319: p_mesg_token_tbl => l_mesg_token_tbl ,
320: x_mesg_token_tbl => l_out_mesg_token_tbl );
321: l_mesg_token_tbl := l_out_mesg_token_tbl;
322: x_return_status := FND_API.G_RET_STS_ERROR;
323: x_mesg_token_tbl := l_mesg_token_tbl ;
324: RETURN;
325: END; */
326:

Line 336: x_return_status := FND_API.G_RET_STS_SUCCESS;

332: SELECT 1
333: INTO g_dummy
334: FROM fnd_user
335: WHERE user_id = p_work_clearance_header_rec.user_id;
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337: END IF;
338: EXCEPTION
339: WHEN no_data_found THEN
340: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 347: x_return_status := FND_API.G_RET_STS_ERROR;

343: p_token_tbl => l_token_tbl ,
344: p_mesg_token_tbl => l_mesg_token_tbl ,
345: x_mesg_token_tbl => l_out_mesg_token_tbl );
346: l_mesg_token_tbl := l_out_mesg_token_tbl;
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: x_mesg_token_tbl := l_mesg_token_tbl ;
349: RETURN;
350: END;
351:

Line 361: x_return_status := FND_API.G_RET_STS_SUCCESS;

357: SELECT 1
358: INTO g_dummy
359: FROM fnd_responsibility
360: WHERE responsibility_id = p_work_clearance_header_rec.responsibility_id;
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362: END IF;
363: EXCEPTION
364: WHEN no_data_found THEN
365: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 372: x_return_status := FND_API.G_RET_STS_ERROR;

368: p_token_tbl => l_token_tbl ,
369: p_mesg_token_tbl => l_mesg_token_tbl ,
370: x_mesg_token_tbl => l_out_mesg_token_tbl );
371: l_mesg_token_tbl := l_out_mesg_token_tbl;
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: x_mesg_token_tbl := l_mesg_token_tbl ;
374: RETURN;
375: END;
376:

Line 396: x_return_status := FND_API.G_RET_STS_SUCCESS;

392: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
393: BEGIN
394: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking required attributes for Clearance . . . '); END IF;
395:
396: x_return_status := FND_API.G_RET_STS_SUCCESS;
397:
398: IF p_work_clearance_header_rec.WORK_CLEARANCE_ID IS NULL THEN
399:
400: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 407: x_return_status := FND_API.G_RET_STS_ERROR;

403: p_token_tbl => l_Token_tbl ,
404: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
405: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );
406: l_mesg_token_tbl := l_out_mesg_token_tbl;
407: x_return_status := FND_API.G_RET_STS_ERROR;
408: END IF;
409: IF p_work_clearance_header_rec.WORK_CLEARANCE_NAME IS NULL THEN
410:
411: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 418: x_return_status := FND_API.G_RET_STS_ERROR;

414: p_token_tbl => l_Token_tbl ,
415: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
416: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );
417: l_mesg_token_tbl := l_out_mesg_token_tbl;
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: END IF;
420:
421: IF p_work_clearance_header_rec.ORGANIZATION_ID IS NULL THEN
422:

Line 430: x_return_status := FND_API.G_RET_STS_ERROR;

426: p_token_tbl => l_Token_tbl ,
427: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
428: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );
429: l_mesg_token_tbl := l_out_mesg_token_tbl;
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: END IF;
432:
433: IF p_work_clearance_header_rec.SYSTEM_STATUS IS NULL THEN
434: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 441: x_return_status := FND_API.G_RET_STS_ERROR;

437: p_token_tbl => l_Token_tbl ,
438: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
439: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );
440: l_mesg_token_tbl := l_out_mesg_token_tbl;
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: END IF;
443:
444: IF (p_work_clearance_header_rec.SCHEDULED_ESTAB_START_DATE IS NULL) OR
445: (p_work_clearance_header_rec.SCHEDULED_ESTAB_END_DATE IS NULL) OR

Line 456: x_return_status := FND_API.G_RET_STS_ERROR;

452: p_token_tbl => l_Token_tbl ,
453: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
454: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );
455: l_mesg_token_tbl := l_out_mesg_token_tbl;
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: END IF;
458:
459: IF p_work_clearance_header_rec.USER_ID IS NULL
460: THEN

Line 469: x_return_status := FND_API.G_RET_STS_ERROR;

465: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
466: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
467: );
468: l_mesg_token_tbl := l_out_mesg_token_tbl;
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: END IF;
471:
472: IF p_work_clearance_header_rec.RESPONSIBILITY_ID IS NULL
473: THEN

Line 482: x_return_status := FND_API.G_RET_STS_ERROR;

478: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
479: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
480: );
481: l_mesg_token_tbl := l_out_mesg_token_tbl;
482: x_return_status := FND_API.G_RET_STS_ERROR;
483: END IF;
484: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
485: x_return_status := FND_API.G_RET_STS_SUCCESS;
486: END CHECK_REQUIRED;

Line 485: x_return_status := FND_API.G_RET_STS_SUCCESS;

481: l_mesg_token_tbl := l_out_mesg_token_tbl;
482: x_return_status := FND_API.G_RET_STS_ERROR;
483: END IF;
484: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
485: x_return_status := FND_API.G_RET_STS_SUCCESS;
486: END CHECK_REQUIRED;
487:
488:
489: END EAM_CLEARANCE_VALIDATE_PVT ;