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_ISOLATION_VALIDATE_PVT dependencies on FND_API

Line 60: l_return_status := FND_API.G_RET_STS_ERROR;

56: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
57: p_message_name => 'EAM_SAFETY_ALREADY_EXISTS' ,
58: p_token_tbl => l_token_tbl );
59: l_mesg_token_tbl := l_out_mesg_token_tbl;
60: l_return_status := FND_API.G_RET_STS_ERROR;
61:
62: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND p_iso_header_rec.transaction_type IN (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE) THEN
63: l_token_tbl(1).token_name := 'SAFETY_NAME';
64: l_token_tbl(1).token_value := p_iso_header_rec.ISOLATION_NAME;

Line 73: l_return_status := FND_API.G_RET_STS_ERROR;

69: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
70: p_message_name => 'EAM_SAFETY_EXISTENCE_ERROR' ,
71: p_token_tbl => l_token_tbl );
72: l_mesg_token_tbl := l_out_mesg_token_tbl;
73: l_return_status := FND_API.G_RET_STS_ERROR;
74:
75: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
76: l_out_mesg_token_tbl := l_mesg_token_tbl;
77: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 75: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

71: p_token_tbl => l_token_tbl );
72: l_mesg_token_tbl := l_out_mesg_token_tbl;
73: l_return_status := FND_API.G_RET_STS_ERROR;
74:
75: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
76: l_out_mesg_token_tbl := l_mesg_token_tbl;
77: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
78: x_Mesg_token_tbl => l_out_Mesg_Token_Tbl ,
79: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,

Line 83: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

79: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
80: p_message_name => NULL ,
81: p_message_text => 'Unexpected error' );
82: l_mesg_token_tbl := l_out_mesg_token_tbl;
83: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: ELSE
85: l_return_status := FND_API.G_RET_STS_SUCCESS;
86: x_iso_header_rec :=l_isolation_header_rec;
87: END IF;

Line 85: l_return_status := FND_API.G_RET_STS_SUCCESS;

81: p_message_text => 'Unexpected error' );
82: l_mesg_token_tbl := l_out_mesg_token_tbl;
83: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84: ELSE
85: l_return_status := FND_API.G_RET_STS_SUCCESS;
86: x_iso_header_rec :=l_isolation_header_rec;
87: END IF;
88: x_return_status := l_return_status;
89: x_mesg_token_tbl := l_mesg_token_tbl;

Line 122: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 132: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 148: raise fnd_api.g_exc_unexpected_error;

144: FROM EAM_ISOLATIONS
145: WHERE ISOLATION_ID = p_iso_header_rec.ISOLATION_ID
146: AND organization_id = p_iso_header_rec.organization_id;
147: IF(l_count > 0) THEN
148: raise fnd_api.g_exc_unexpected_error;
149: END IF;
150: END IF;
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152: EXCEPTION

Line 151: x_return_status := FND_API.G_RET_STS_SUCCESS;

147: IF(l_count > 0) THEN
148: raise fnd_api.g_exc_unexpected_error;
149: END IF;
150: END IF;
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152: EXCEPTION
153: WHEN fnd_api.g_exc_unexpected_error THEN
154: l_out_mesg_token_tbl := l_mesg_token_tbl;
155: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 153: WHEN fnd_api.g_exc_unexpected_error THEN

149: END IF;
150: END IF;
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152: EXCEPTION
153: WHEN fnd_api.g_exc_unexpected_error THEN
154: l_out_mesg_token_tbl := l_mesg_token_tbl;
155: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
156: p_message_name => 'EAM_SAFETY_ID_EXISTS' ,
157: p_token_tbl => l_token_tbl ,

Line 161: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 178: raise fnd_api.g_exc_unexpected_error;

174: WHERE ISOLATION_ID = p_iso_header_rec.ISOLATION_ID
175: AND organization_id = p_iso_header_rec.organization_id;
176:
177: IF(l_count <> 1) THEN
178: raise fnd_api.g_exc_unexpected_error;
179: END IF;
180: END IF;
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182: EXCEPTION

Line 181: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 183: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 191: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 207: raise fnd_api.g_exc_unexpected_error;

203: FROM EAM_ISOLATIONS
204: WHERE ISOLATION_NAME = p_iso_header_rec.ISOLATION_NAME
205: AND organization_id = p_iso_header_rec.organization_id;
206: IF(l_count > 0) THEN
207: raise fnd_api.g_exc_unexpected_error;
208: END IF;
209: END IF;
210: x_return_status := FND_API.G_RET_STS_SUCCESS;
211: EXCEPTION

Line 210: x_return_status := FND_API.G_RET_STS_SUCCESS;

206: IF(l_count > 0) THEN
207: raise fnd_api.g_exc_unexpected_error;
208: END IF;
209: END IF;
210: x_return_status := FND_API.G_RET_STS_SUCCESS;
211: EXCEPTION
212: WHEN fnd_api.g_exc_unexpected_error THEN
213: l_out_mesg_token_tbl := l_mesg_token_tbl;
214: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 212: WHEN fnd_api.g_exc_unexpected_error THEN

208: END IF;
209: END IF;
210: x_return_status := FND_API.G_RET_STS_SUCCESS;
211: EXCEPTION
212: WHEN fnd_api.g_exc_unexpected_error THEN
213: l_out_mesg_token_tbl := l_mesg_token_tbl;
214: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
215: p_message_name => 'EAM_SAFETY_NAME' ,
216: p_token_tbl => l_token_tbl ,

Line 220: x_return_status := FND_API.G_RET_STS_ERROR;

216: p_token_tbl => l_token_tbl ,
217: p_mesg_token_tbl => l_mesg_token_tbl ,
218: x_mesg_token_tbl => l_out_mesg_token_tbl );
219: l_mesg_token_tbl := l_out_mesg_token_tbl;
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: x_mesg_token_tbl := l_mesg_token_tbl ;
222: RETURN;
223: END;
224:

Line 229: raise fnd_api.g_exc_unexpected_error;

225: -- status_type
226: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Isolation status_type. . . '); END IF;
227: BEGIN
228: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.draft)) THEN
229: raise fnd_api.g_exc_unexpected_error;
230: -- elsif (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.cancelled,wip_constants.comp_chrg,wip_constants.comp_nochrg,wip_constants.draft )) THEN
231: -- raise fnd_api.g_exc_unexpected_error;
232: END IF;
233: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 231: -- raise fnd_api.g_exc_unexpected_error;

227: BEGIN
228: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.draft)) THEN
229: raise fnd_api.g_exc_unexpected_error;
230: -- elsif (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.cancelled,wip_constants.comp_chrg,wip_constants.comp_nochrg,wip_constants.draft )) THEN
231: -- raise fnd_api.g_exc_unexpected_error;
232: END IF;
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234: EXCEPTION
235: WHEN fnd_api.g_exc_unexpected_error THEN

Line 233: x_return_status := FND_API.G_RET_STS_SUCCESS;

229: raise fnd_api.g_exc_unexpected_error;
230: -- elsif (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE AND p_iso_header_rec.SYSTEM_STATUS NOT IN (wip_constants.released, wip_constants.cancelled,wip_constants.comp_chrg,wip_constants.comp_nochrg,wip_constants.draft )) THEN
231: -- raise fnd_api.g_exc_unexpected_error;
232: END IF;
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234: EXCEPTION
235: WHEN fnd_api.g_exc_unexpected_error THEN
236:
237: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 235: WHEN fnd_api.g_exc_unexpected_error THEN

231: -- raise fnd_api.g_exc_unexpected_error;
232: END IF;
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234: EXCEPTION
235: WHEN fnd_api.g_exc_unexpected_error THEN
236:
237: l_out_mesg_token_tbl := l_mesg_token_tbl;
238: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (
239: p_message_name => 'EAM_SAFETY_STATUS_TYPE' ,

Line 244: x_return_status := FND_API.G_RET_STS_ERROR;

240: p_token_tbl => l_token_tbl ,
241: p_mesg_token_tbl => l_mesg_token_tbl ,
242: x_mesg_token_tbl => l_out_mesg_token_tbl );
243: l_mesg_token_tbl := l_out_mesg_token_tbl;
244: x_return_status := FND_API.G_RET_STS_ERROR;
245: x_mesg_token_tbl := l_mesg_token_tbl ;
246: RETURN;
247: END;
248:

Line 295: raise fnd_api.g_exc_unexpected_error;

291: p_iso_header_rec.ATTRIBUTE28 <> p_old_iso_header_rec.ATTRIBUTE13 OR
292: p_iso_header_rec.ATTRIBUTE29 <> p_old_iso_header_rec.ATTRIBUTE14 OR
293: p_iso_header_rec.ATTRIBUTE30 <> p_old_iso_header_rec.ATTRIBUTE15 OR
294: p_iso_header_rec.APPROVED_BY <> p_old_iso_header_rec.APPROVED_BY ) THEN
295: raise fnd_api.g_exc_unexpected_error;
296: END IF;
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298: EXCEPTION
299: WHEN fnd_api.g_exc_unexpected_error THEN

Line 297: x_return_status := FND_API.G_RET_STS_SUCCESS;

293: p_iso_header_rec.ATTRIBUTE30 <> p_old_iso_header_rec.ATTRIBUTE15 OR
294: p_iso_header_rec.APPROVED_BY <> p_old_iso_header_rec.APPROVED_BY ) THEN
295: raise fnd_api.g_exc_unexpected_error;
296: END IF;
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298: EXCEPTION
299: WHEN fnd_api.g_exc_unexpected_error THEN
300: l_token_tbl(1).token_name := 'SAFETY_NAME';
301: l_token_tbl(1).token_value := p_iso_header_rec.ISOLATION_NAME;

Line 299: WHEN fnd_api.g_exc_unexpected_error THEN

295: raise fnd_api.g_exc_unexpected_error;
296: END IF;
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298: EXCEPTION
299: WHEN fnd_api.g_exc_unexpected_error THEN
300: l_token_tbl(1).token_name := 'SAFETY_NAME';
301: l_token_tbl(1).token_value := p_iso_header_rec.ISOLATION_NAME;
302: l_out_mesg_token_tbl := l_mesg_token_tbl;
303: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 309: x_return_status := FND_API.G_RET_STS_ERROR;

305: p_token_tbl => l_token_tbl ,
306: p_mesg_token_tbl => l_mesg_token_tbl ,
307: x_mesg_token_tbl => l_out_mesg_token_tbl );
308: l_mesg_token_tbl := l_out_mesg_token_tbl;
309: x_return_status := FND_API.G_RET_STS_ERROR;
310: x_mesg_token_tbl := l_mesg_token_tbl ;
311: RETURN;
312: END; */
313:

Line 322: x_return_status := FND_API.G_RET_STS_SUCCESS;

318: SELECT 1
319: INTO g_dummy
320: FROM fnd_user
321: WHERE user_id = p_iso_header_rec.user_id;
322: x_return_status := FND_API.G_RET_STS_SUCCESS;
323: END IF;
324: EXCEPTION
325: WHEN no_data_found THEN
326:

Line 334: x_return_status := FND_API.G_RET_STS_ERROR;

330: p_token_tbl => l_token_tbl ,
331: p_mesg_token_tbl => l_mesg_token_tbl ,
332: x_mesg_token_tbl => l_out_mesg_token_tbl );
333: l_mesg_token_tbl := l_out_mesg_token_tbl;
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: x_mesg_token_tbl := l_mesg_token_tbl ;
336: RETURN;
337: END;
338:

Line 347: x_return_status := FND_API.G_RET_STS_SUCCESS;

343: SELECT 1
344: INTO g_dummy
345: FROM fnd_responsibility
346: WHERE responsibility_id = p_iso_header_rec.responsibility_id;
347: x_return_status := FND_API.G_RET_STS_SUCCESS;
348: END IF;
349: EXCEPTION
350: WHEN no_data_found THEN
351:

Line 359: x_return_status := FND_API.G_RET_STS_ERROR;

355: p_token_tbl => l_token_tbl ,
356: p_mesg_token_tbl => l_mesg_token_tbl ,
357: x_mesg_token_tbl => l_out_mesg_token_tbl );
358: l_mesg_token_tbl := l_out_mesg_token_tbl;
359: x_return_status := FND_API.G_RET_STS_ERROR;
360: x_mesg_token_tbl := l_mesg_token_tbl ;
361: RETURN;
362: END;
363: END CHECK_ATTRIBUTES;

Line 380: x_return_status:= FND_API.G_RET_STS_SUCCESS;

376: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
377: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
378: BEGIN
379: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking required attributes for Isolation . . . '); END IF;
380: x_return_status:= FND_API.G_RET_STS_SUCCESS;
381: IF p_iso_header_rec.ISOLATION_ID IS NULL THEN
382:
383: l_out_mesg_token_tbl := l_mesg_token_tbl;
384: EAM_ERROR_MESSAGE_PVT.Add_Error_Token (

Line 390: x_return_status := FND_API.G_RET_STS_ERROR;

386: p_token_tbl => l_Token_tbl ,
387: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
388: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );
389: l_mesg_token_tbl := l_out_mesg_token_tbl;
390: x_return_status := FND_API.G_RET_STS_ERROR;
391: END IF;
392: IF p_iso_header_rec.ISOLATION_NAME IS NULL THEN
393:
394: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 401: x_return_status := FND_API.G_RET_STS_ERROR;

397: p_token_tbl => l_Token_tbl ,
398: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
399: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );
400: l_mesg_token_tbl := l_out_mesg_token_tbl;
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: END IF;
403: IF p_iso_header_rec.ISOLATION_TYPE IS NULL THEN
404:
405: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 412: x_return_status := FND_API.G_RET_STS_ERROR;

408: p_token_tbl => l_Token_tbl ,
409: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
410: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );
411: l_mesg_token_tbl := l_out_mesg_token_tbl;
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: END IF;
414: IF p_iso_header_rec.ORGANIZATION_ID IS NULL THEN
415:
416: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 423: x_return_status := FND_API.G_RET_STS_ERROR;

419: p_token_tbl => l_Token_tbl ,
420: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
421: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );
422: l_mesg_token_tbl := l_out_mesg_token_tbl;
423: x_return_status := FND_API.G_RET_STS_ERROR;
424: END IF;
425: IF p_iso_header_rec.SYSTEM_STATUS IS NULL THEN
426:
427: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 434: x_return_status := FND_API.G_RET_STS_ERROR;

430: p_token_tbl => l_Token_tbl ,
431: p_Mesg_Token_Tbl => l_Mesg_Token_Tbl ,
432: x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl );
433: l_mesg_token_tbl := l_out_mesg_token_tbl;
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: END IF;
436:
437: IF p_iso_header_rec.USER_ID IS NULL THEN
438:

Line 447: x_return_status := FND_API.G_RET_STS_ERROR;

443: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
444: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
445: );
446: l_mesg_token_tbl := l_out_mesg_token_tbl;
447: x_return_status := FND_API.G_RET_STS_ERROR;
448: END IF;
449: IF p_iso_header_rec.RESPONSIBILITY_ID IS NULL THEN
450:
451: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 459: x_return_status := FND_API.G_RET_STS_ERROR;

455: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
456: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
457: );
458: l_mesg_token_tbl := l_out_mesg_token_tbl;
459: x_return_status := FND_API.G_RET_STS_ERROR;
460: END IF;
461: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463: END CHECK_REQUIRED;

Line 462: x_return_status := FND_API.G_RET_STS_SUCCESS;

458: l_mesg_token_tbl := l_out_mesg_token_tbl;
459: x_return_status := FND_API.G_RET_STS_ERROR;
460: END IF;
461: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463: END CHECK_REQUIRED;
464:
465:
466: END EAM_ISOLATION_VALIDATE_PVT;