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

Line 39: x_return_status := FND_API.G_RET_STS_SUCCESS;

35: BEGIN
36:
37: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Operation Completeion Populate null columns'); END IF;
38:
39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40:
41:
42: IF p_eam_op_comp_rec.operation_seq_num IS NULL
43: THEN

Line 57: x_return_status := FND_API.G_RET_STS_ERROR;

53: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
54: );
55: x_mesg_token_tbl := l_out_mesg_token_tbl;
56:
57: x_return_status := FND_API.G_RET_STS_ERROR;
58:
59: END IF;
60:
61: IF p_eam_op_comp_rec.actual_start_date IS NULL

Line 76: x_return_status := FND_API.G_RET_STS_ERROR;

72: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
73: );
74: x_mesg_token_tbl := l_out_mesg_token_tbl;
75:
76: x_return_status := FND_API.G_RET_STS_ERROR;
77:
78: END IF;
79:
80: IF p_eam_op_comp_rec.actual_end_date IS NULL

Line 95: x_return_status := FND_API.G_RET_STS_ERROR;

91: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
92: );
93: x_mesg_token_tbl := l_out_mesg_token_tbl;
94:
95: x_return_status := FND_API.G_RET_STS_ERROR;
96:
97: END IF;
98:
99: IF p_eam_op_comp_rec.actual_duration IS NULL

Line 114: x_return_status := FND_API.G_RET_STS_ERROR;

110: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
111: );
112: x_mesg_token_tbl := l_out_mesg_token_tbl;
113:
114: x_return_status := FND_API.G_RET_STS_ERROR;
115:
116: END IF;
117:
118:

Line 134: x_return_status := FND_API.G_RET_STS_ERROR;

130: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
131: );
132: x_mesg_token_tbl := l_out_mesg_token_tbl;
133:
134: x_return_status := FND_API.G_RET_STS_ERROR;
135:
136: END IF;
137:
138: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE

Line 160: x_return_status := FND_API.G_RET_STS_ERROR;

156: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
157: );
158: x_mesg_token_tbl := l_out_mesg_token_tbl;
159:
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: END IF;
162: END IF;
163: END IF;
164:

Line 234: x_return_status := FND_API.G_RET_STS_SUCCESS;

230: BEGIN
231:
232: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Operation Completeion Check Attributes'); END IF;
233:
234: x_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual start and end date ...'); END IF;
237: BEGIN
238: IF p_eam_op_comp_rec.actual_start_date > p_eam_op_comp_rec.actual_end_date THEN

Line 239: raise fnd_api.g_exc_unexpected_error;

235:
236: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual start and end date ...'); END IF;
237: BEGIN
238: IF p_eam_op_comp_rec.actual_start_date > p_eam_op_comp_rec.actual_end_date THEN
239: raise fnd_api.g_exc_unexpected_error;
240: END IF;
241:
242: x_return_status := FND_API.G_RET_STS_SUCCESS;
243:

Line 242: x_return_status := FND_API.G_RET_STS_SUCCESS;

238: IF p_eam_op_comp_rec.actual_start_date > p_eam_op_comp_rec.actual_end_date THEN
239: raise fnd_api.g_exc_unexpected_error;
240: END IF;
241:
242: x_return_status := FND_API.G_RET_STS_SUCCESS;
243:
244: EXCEPTION
245: WHEN OTHERS THEN
246: l_token_tbl(1).token_name := 'OP_SEQ_NO';

Line 258: x_return_status := FND_API.G_RET_STS_ERROR;

254: , x_mesg_token_tbl => l_out_mesg_token_tbl
255: );
256: l_mesg_token_tbl := l_out_mesg_token_tbl;
257:
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: x_mesg_token_tbl := l_mesg_token_tbl ;
260: RETURN;
261: END;
262:

Line 266: raise fnd_api.g_exc_unexpected_error;

262:
263: BEGIN
264: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking shutdown start and end date ...'); END IF;
265: IF p_eam_op_comp_rec.shutdown_start_date > p_eam_op_comp_rec.shutdown_end_date THEN
266: raise fnd_api.g_exc_unexpected_error;
267: END IF;
268:
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270:

Line 269: x_return_status := FND_API.G_RET_STS_SUCCESS;

265: IF p_eam_op_comp_rec.shutdown_start_date > p_eam_op_comp_rec.shutdown_end_date THEN
266: raise fnd_api.g_exc_unexpected_error;
267: END IF;
268:
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270:
271: EXCEPTION
272: WHEN OTHERS THEN
273: l_token_tbl(1).token_name := 'OP_SEQ_NO';

Line 285: x_return_status := FND_API.G_RET_STS_ERROR;

281: , x_mesg_token_tbl => l_out_mesg_token_tbl
282: );
283: l_mesg_token_tbl := l_out_mesg_token_tbl;
284:
285: x_return_status := FND_API.G_RET_STS_ERROR;
286: x_mesg_token_tbl := l_mesg_token_tbl ;
287: RETURN;
288: END;
289:

Line 293: raise fnd_api.g_exc_unexpected_error;

289:
290: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual duration ...'); END IF;
291: BEGIN
292: IF p_eam_op_comp_rec.actual_duration < 0 THEN
293: raise fnd_api.g_exc_unexpected_error;
294: END IF;
295:
296: x_return_status := FND_API.G_RET_STS_SUCCESS;
297:

Line 296: x_return_status := FND_API.G_RET_STS_SUCCESS;

292: IF p_eam_op_comp_rec.actual_duration < 0 THEN
293: raise fnd_api.g_exc_unexpected_error;
294: END IF;
295:
296: x_return_status := FND_API.G_RET_STS_SUCCESS;
297:
298: EXCEPTION
299: WHEN OTHERS THEN
300: l_token_tbl(1).token_name := 'OP_SEQ_NO';

Line 312: x_return_status := FND_API.G_RET_STS_ERROR;

308: , x_mesg_token_tbl => l_out_mesg_token_tbl
309: );
310: l_mesg_token_tbl := l_out_mesg_token_tbl;
311:
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: x_mesg_token_tbl := l_mesg_token_tbl ;
314: RETURN;
315: END;
316:

Line 320: raise fnd_api.g_exc_unexpected_error;

316:
317: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual end date ...'); END IF;
318: BEGIN
319: IF p_eam_op_comp_rec.actual_end_date > sysdate THEN
320: raise fnd_api.g_exc_unexpected_error;
321: END IF;
322:
323: x_return_status := FND_API.G_RET_STS_SUCCESS;
324:

Line 323: x_return_status := FND_API.G_RET_STS_SUCCESS;

319: IF p_eam_op_comp_rec.actual_end_date > sysdate THEN
320: raise fnd_api.g_exc_unexpected_error;
321: END IF;
322:
323: x_return_status := FND_API.G_RET_STS_SUCCESS;
324:
325: EXCEPTION
326: WHEN OTHERS THEN
327:

Line 340: x_return_status := FND_API.G_RET_STS_ERROR;

336: , x_mesg_token_tbl => l_out_mesg_token_tbl
337: );
338: l_mesg_token_tbl := l_out_mesg_token_tbl;
339:
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: x_mesg_token_tbl := l_mesg_token_tbl ;
342: RETURN;
343: END;
344:

Line 348: raise fnd_api.g_exc_unexpected_error;

344:
345: --also added following code as part of bug 5476770
346: BEGIN
347: IF p_eam_op_comp_rec.shutdown_end_date > sysdate THEN
348: raise fnd_api.g_exc_unexpected_error;
349: END IF;
350:
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352:

Line 351: x_return_status := FND_API.G_RET_STS_SUCCESS;

347: IF p_eam_op_comp_rec.shutdown_end_date > sysdate THEN
348: raise fnd_api.g_exc_unexpected_error;
349: END IF;
350:
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352:
353: EXCEPTION
354: WHEN OTHERS THEN
355:

Line 368: x_return_status := FND_API.G_RET_STS_ERROR;

364: , x_mesg_token_tbl => l_out_mesg_token_tbl
365: );
366: l_mesg_token_tbl := l_out_mesg_token_tbl;
367:
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: x_mesg_token_tbl := l_mesg_token_tbl ;
370: RETURN;
371: END;
372:

Line 385: raise fnd_api.g_exc_unexpected_error;

381: WHERE organization_id = (select organization_id from wip_discrete_jobs where wip_entity_id = p_eam_op_comp_rec.wip_entity_id)
382: AND open_flag = 'Y';
383:
384: IF sysdate < l_open_acct_per_date THEN -- p_transaction_date < l_open_acct_per_date
385: raise fnd_api.g_exc_unexpected_error;
386: END IF;
387:
388: x_return_status := FND_API.G_RET_STS_SUCCESS;
389:

Line 388: x_return_status := FND_API.G_RET_STS_SUCCESS;

384: IF sysdate < l_open_acct_per_date THEN -- p_transaction_date < l_open_acct_per_date
385: raise fnd_api.g_exc_unexpected_error;
386: END IF;
387:
388: x_return_status := FND_API.G_RET_STS_SUCCESS;
389:
390: EXCEPTION
391: WHEN OTHERS THEN
392:

Line 405: x_return_status := FND_API.G_RET_STS_ERROR;

401: , x_mesg_token_tbl => l_out_mesg_token_tbl
402: );
403: l_mesg_token_tbl := l_out_mesg_token_tbl;
404:
405: x_return_status := FND_API.G_RET_STS_ERROR;
406: x_mesg_token_tbl := l_mesg_token_tbl ;
407: RETURN;
408: END;
409:

Line 422: x_return_status := FND_API.G_RET_STS_SUCCESS;

418: AND ml.lookup_code = p_eam_op_comp_rec.reconciliation_code;
419:
420: END IF;
421:
422: x_return_status := FND_API.G_RET_STS_SUCCESS;
423:
424: EXCEPTION
425: WHEN NO_DATA_FOUND THEN
426:

Line 439: x_return_status := FND_API.G_RET_STS_ERROR;

435: , x_mesg_token_tbl => l_out_mesg_token_tbl
436: );
437: l_mesg_token_tbl := l_out_mesg_token_tbl;
438:
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: x_mesg_token_tbl := l_mesg_token_tbl ;
441: RETURN;
442: END;
443:

Line 457: raise fnd_api.g_exc_unexpected_error;

453: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking shutdown start and end date ...'); END IF;
454:
455: IF l_shutdown_type IS NOT NULL AND to_number(l_shutdown_type) = 2 THEN
456: IF p_eam_op_comp_rec.shutdown_start_date IS NULL OR p_eam_op_comp_rec.shutdown_end_date IS NULL THEN
457: raise fnd_api.g_exc_unexpected_error;
458: END IF;
459: END IF;
460:
461: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 461: x_return_status := FND_API.G_RET_STS_SUCCESS;

457: raise fnd_api.g_exc_unexpected_error;
458: END IF;
459: END IF;
460:
461: x_return_status := FND_API.G_RET_STS_SUCCESS;
462:
463: EXCEPTION
464: WHEN NO_DATA_FOUND THEN
465:

Line 478: x_return_status := FND_API.G_RET_STS_ERROR;

474: , x_mesg_token_tbl => l_out_mesg_token_tbl
475: );
476: l_mesg_token_tbl := l_out_mesg_token_tbl;
477:
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: x_mesg_token_tbl := l_mesg_token_tbl ;
480: RETURN;
481: END;
482: END IF;

Line 495: raise fnd_api.g_exc_unexpected_error;

491: close CON1;
492:
493: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking prev_uncomplete ...'); END IF;
494: IF l_prev_uncomplete > 0 THEN
495: raise fnd_api.g_exc_unexpected_error;
496: END IF;
497:
498: x_return_status := FND_API.G_RET_STS_SUCCESS;
499:

Line 498: x_return_status := FND_API.G_RET_STS_SUCCESS;

494: IF l_prev_uncomplete > 0 THEN
495: raise fnd_api.g_exc_unexpected_error;
496: END IF;
497:
498: x_return_status := FND_API.G_RET_STS_SUCCESS;
499:
500: EXCEPTION
501: WHEN OTHERS THEN
502:

Line 516: x_return_status := FND_API.G_RET_STS_ERROR;

512: , x_mesg_token_tbl => l_out_mesg_token_tbl
513: );
514: l_mesg_token_tbl := l_out_mesg_token_tbl;
515:
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: x_mesg_token_tbl := l_mesg_token_tbl ;
518: RETURN;
519: END;
520: END IF;

Line 533: raise fnd_api.g_exc_unexpected_error;

529: close CON;
530: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking prev_uncomplete ...'); END IF;
531:
532: IF l_prev_uncomplete > 0 THEN
533: raise fnd_api.g_exc_unexpected_error;
534: END IF;
535:
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:

Line 536: x_return_status := FND_API.G_RET_STS_SUCCESS;

532: IF l_prev_uncomplete > 0 THEN
533: raise fnd_api.g_exc_unexpected_error;
534: END IF;
535:
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: EXCEPTION
539: WHEN OTHERS THEN
540:

Line 554: x_return_status := FND_API.G_RET_STS_ERROR;

550: , x_mesg_token_tbl => l_out_mesg_token_tbl
551: );
552: l_mesg_token_tbl := l_out_mesg_token_tbl;
553:
554: x_return_status := FND_API.G_RET_STS_ERROR;
555: x_mesg_token_tbl := l_mesg_token_tbl ;
556: RETURN;
557: END;
558: END IF;

Line 569: raise fnd_api.g_exc_unexpected_error;

565: WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id;
566: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking status_type ...'); END IF;
567:
568: IF (l_job_status = 4 ) THEN
569: raise fnd_api.g_exc_unexpected_error;
570: END IF;
571:
572: x_return_status := FND_API.G_RET_STS_SUCCESS;
573:

Line 572: x_return_status := FND_API.G_RET_STS_SUCCESS;

568: IF (l_job_status = 4 ) THEN
569: raise fnd_api.g_exc_unexpected_error;
570: END IF;
571:
572: x_return_status := FND_API.G_RET_STS_SUCCESS;
573:
574: EXCEPTION
575: WHEN OTHERS THEN
576:

Line 589: x_return_status := FND_API.G_RET_STS_ERROR;

585: , x_mesg_token_tbl => l_out_mesg_token_tbl
586: );
587: l_mesg_token_tbl := l_out_mesg_token_tbl;
588:
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: x_mesg_token_tbl := l_mesg_token_tbl ;
591: RETURN;
592: END;
593: END IF;

Line 603: raise fnd_api.g_exc_unexpected_error;

599: close CON3;
600: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual start date and max_prior_end_date ...'); END IF;
601:
602: if(p_eam_op_comp_rec.actual_start_date < l_max_prior_end_date) then
603: raise fnd_api.g_exc_unexpected_error;
604: end if;
605:
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607:

Line 606: x_return_status := FND_API.G_RET_STS_SUCCESS;

602: if(p_eam_op_comp_rec.actual_start_date < l_max_prior_end_date) then
603: raise fnd_api.g_exc_unexpected_error;
604: end if;
605:
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607:
608: EXCEPTION
609: WHEN OTHERS THEN
610: l_token_tbl(1).token_name := 'MIN_START_DATE';

Line 622: x_return_status := FND_API.G_RET_STS_ERROR;

618: , x_mesg_token_tbl => l_out_mesg_token_tbl
619: );
620: l_mesg_token_tbl := l_out_mesg_token_tbl;
621:
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: x_mesg_token_tbl := l_mesg_token_tbl ;
624: RETURN;
625: END;
626: END IF;