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 169: x_return_status := FND_API.G_RET_STS_ERROR;

165: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
166: );
167: x_mesg_token_tbl := l_out_mesg_token_tbl;
168:
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: END IF;
171: END IF;
172: END IF;
173:

Line 243: x_return_status := FND_API.G_RET_STS_SUCCESS;

239: BEGIN
240:
241: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Operation Completeion Check Attributes'); END IF;
242:
243: x_return_status := FND_API.G_RET_STS_SUCCESS;
244:
245: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual start and end date ...'); END IF;
246: BEGIN
247: IF p_eam_op_comp_rec.actual_start_date > p_eam_op_comp_rec.actual_end_date THEN

Line 248: raise fnd_api.g_exc_unexpected_error;

244:
245: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual start and end date ...'); END IF;
246: BEGIN
247: IF p_eam_op_comp_rec.actual_start_date > p_eam_op_comp_rec.actual_end_date THEN
248: raise fnd_api.g_exc_unexpected_error;
249: END IF;
250:
251: x_return_status := FND_API.G_RET_STS_SUCCESS;
252:

Line 251: x_return_status := FND_API.G_RET_STS_SUCCESS;

247: IF p_eam_op_comp_rec.actual_start_date > p_eam_op_comp_rec.actual_end_date THEN
248: raise fnd_api.g_exc_unexpected_error;
249: END IF;
250:
251: x_return_status := FND_API.G_RET_STS_SUCCESS;
252:
253: EXCEPTION
254: WHEN OTHERS THEN
255: l_token_tbl(1).token_name := 'OP_SEQ_NO';

Line 267: x_return_status := FND_API.G_RET_STS_ERROR;

263: , x_mesg_token_tbl => l_out_mesg_token_tbl
264: );
265: l_mesg_token_tbl := l_out_mesg_token_tbl;
266:
267: x_return_status := FND_API.G_RET_STS_ERROR;
268: x_mesg_token_tbl := l_mesg_token_tbl ;
269: RETURN;
270: END;
271:

Line 275: raise fnd_api.g_exc_unexpected_error;

271:
272: BEGIN
273: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking shutdown start and end date ...'); END IF;
274: IF p_eam_op_comp_rec.shutdown_start_date > p_eam_op_comp_rec.shutdown_end_date THEN
275: raise fnd_api.g_exc_unexpected_error;
276: END IF;
277:
278: x_return_status := FND_API.G_RET_STS_SUCCESS;
279:

Line 278: x_return_status := FND_API.G_RET_STS_SUCCESS;

274: IF p_eam_op_comp_rec.shutdown_start_date > p_eam_op_comp_rec.shutdown_end_date THEN
275: raise fnd_api.g_exc_unexpected_error;
276: END IF;
277:
278: x_return_status := FND_API.G_RET_STS_SUCCESS;
279:
280: EXCEPTION
281: WHEN OTHERS THEN
282: l_token_tbl(1).token_name := 'OP_SEQ_NO';

Line 294: x_return_status := FND_API.G_RET_STS_ERROR;

290: , x_mesg_token_tbl => l_out_mesg_token_tbl
291: );
292: l_mesg_token_tbl := l_out_mesg_token_tbl;
293:
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: x_mesg_token_tbl := l_mesg_token_tbl ;
296: RETURN;
297: END;
298:

Line 302: raise fnd_api.g_exc_unexpected_error;

298:
299: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual duration ...'); END IF;
300: BEGIN
301: IF p_eam_op_comp_rec.actual_duration < 0 THEN
302: raise fnd_api.g_exc_unexpected_error;
303: END IF;
304:
305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306:

Line 305: x_return_status := FND_API.G_RET_STS_SUCCESS;

301: IF p_eam_op_comp_rec.actual_duration < 0 THEN
302: raise fnd_api.g_exc_unexpected_error;
303: END IF;
304:
305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306:
307: EXCEPTION
308: WHEN OTHERS THEN
309: l_token_tbl(1).token_name := 'OP_SEQ_NO';

Line 321: x_return_status := FND_API.G_RET_STS_ERROR;

317: , x_mesg_token_tbl => l_out_mesg_token_tbl
318: );
319: l_mesg_token_tbl := l_out_mesg_token_tbl;
320:
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: x_mesg_token_tbl := l_mesg_token_tbl ;
323: RETURN;
324: END;
325:

Line 329: raise fnd_api.g_exc_unexpected_error;

325:
326: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking actual end date ...'); END IF;
327: BEGIN
328: IF p_eam_op_comp_rec.actual_end_date > sysdate THEN
329: raise fnd_api.g_exc_unexpected_error;
330: END IF;
331:
332: x_return_status := FND_API.G_RET_STS_SUCCESS;
333:

Line 332: x_return_status := FND_API.G_RET_STS_SUCCESS;

328: IF p_eam_op_comp_rec.actual_end_date > sysdate THEN
329: raise fnd_api.g_exc_unexpected_error;
330: END IF;
331:
332: x_return_status := FND_API.G_RET_STS_SUCCESS;
333:
334: EXCEPTION
335: WHEN OTHERS THEN
336:

Line 349: x_return_status := FND_API.G_RET_STS_ERROR;

345: , x_mesg_token_tbl => l_out_mesg_token_tbl
346: );
347: l_mesg_token_tbl := l_out_mesg_token_tbl;
348:
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: x_mesg_token_tbl := l_mesg_token_tbl ;
351: RETURN;
352: END;
353:

Line 357: raise fnd_api.g_exc_unexpected_error;

353:
354: --also added following code as part of bug 5476770
355: BEGIN
356: IF p_eam_op_comp_rec.shutdown_end_date > sysdate THEN
357: raise fnd_api.g_exc_unexpected_error;
358: END IF;
359:
360: x_return_status := FND_API.G_RET_STS_SUCCESS;
361:

Line 360: x_return_status := FND_API.G_RET_STS_SUCCESS;

356: IF p_eam_op_comp_rec.shutdown_end_date > sysdate THEN
357: raise fnd_api.g_exc_unexpected_error;
358: END IF;
359:
360: x_return_status := FND_API.G_RET_STS_SUCCESS;
361:
362: EXCEPTION
363: WHEN OTHERS THEN
364:

Line 377: x_return_status := FND_API.G_RET_STS_ERROR;

373: , x_mesg_token_tbl => l_out_mesg_token_tbl
374: );
375: l_mesg_token_tbl := l_out_mesg_token_tbl;
376:
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: x_mesg_token_tbl := l_mesg_token_tbl ;
379: RETURN;
380: END;
381:

Line 394: raise fnd_api.g_exc_unexpected_error;

390: WHERE organization_id = (select organization_id from wip_discrete_jobs where wip_entity_id = p_eam_op_comp_rec.wip_entity_id)
391: AND open_flag = 'Y';
392:
393: IF sysdate < l_open_acct_per_date THEN -- p_transaction_date < l_open_acct_per_date
394: raise fnd_api.g_exc_unexpected_error;
395: END IF;
396:
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398:

Line 397: x_return_status := FND_API.G_RET_STS_SUCCESS;

393: IF sysdate < l_open_acct_per_date THEN -- p_transaction_date < l_open_acct_per_date
394: raise fnd_api.g_exc_unexpected_error;
395: END IF;
396:
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398:
399: EXCEPTION
400: WHEN OTHERS THEN
401:

Line 414: x_return_status := FND_API.G_RET_STS_ERROR;

410: , x_mesg_token_tbl => l_out_mesg_token_tbl
411: );
412: l_mesg_token_tbl := l_out_mesg_token_tbl;
413:
414: x_return_status := FND_API.G_RET_STS_ERROR;
415: x_mesg_token_tbl := l_mesg_token_tbl ;
416: RETURN;
417: END;
418:

Line 431: x_return_status := FND_API.G_RET_STS_SUCCESS;

427: AND ml.lookup_code = p_eam_op_comp_rec.reconciliation_code;
428:
429: END IF;
430:
431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432:
433: EXCEPTION
434: WHEN NO_DATA_FOUND THEN
435:

Line 448: x_return_status := FND_API.G_RET_STS_ERROR;

444: , x_mesg_token_tbl => l_out_mesg_token_tbl
445: );
446: l_mesg_token_tbl := l_out_mesg_token_tbl;
447:
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: x_mesg_token_tbl := l_mesg_token_tbl ;
450: RETURN;
451: END;
452:

Line 466: raise fnd_api.g_exc_unexpected_error;

462: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking shutdown start and end date ...'); END IF;
463:
464: IF l_shutdown_type IS NOT NULL AND to_number(l_shutdown_type) = 2 THEN
465: IF p_eam_op_comp_rec.shutdown_start_date IS NULL OR p_eam_op_comp_rec.shutdown_end_date IS NULL THEN
466: raise fnd_api.g_exc_unexpected_error;
467: END IF;
468: END IF;
469:
470: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 470: x_return_status := FND_API.G_RET_STS_SUCCESS;

466: raise fnd_api.g_exc_unexpected_error;
467: END IF;
468: END IF;
469:
470: x_return_status := FND_API.G_RET_STS_SUCCESS;
471:
472: EXCEPTION
473: WHEN NO_DATA_FOUND THEN
474:

Line 487: x_return_status := FND_API.G_RET_STS_ERROR;

483: , x_mesg_token_tbl => l_out_mesg_token_tbl
484: );
485: l_mesg_token_tbl := l_out_mesg_token_tbl;
486:
487: x_return_status := FND_API.G_RET_STS_ERROR;
488: x_mesg_token_tbl := l_mesg_token_tbl ;
489: RETURN;
490: END;
491: END IF;

Line 504: raise fnd_api.g_exc_unexpected_error;

500: close CON1;
501:
502: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking prev_uncomplete ...'); END IF;
503: IF l_prev_uncomplete > 0 THEN
504: raise fnd_api.g_exc_unexpected_error;
505: END IF;
506:
507: x_return_status := FND_API.G_RET_STS_SUCCESS;
508:

Line 507: x_return_status := FND_API.G_RET_STS_SUCCESS;

503: IF l_prev_uncomplete > 0 THEN
504: raise fnd_api.g_exc_unexpected_error;
505: END IF;
506:
507: x_return_status := FND_API.G_RET_STS_SUCCESS;
508:
509: EXCEPTION
510: WHEN OTHERS THEN
511:

Line 525: x_return_status := FND_API.G_RET_STS_ERROR;

521: , x_mesg_token_tbl => l_out_mesg_token_tbl
522: );
523: l_mesg_token_tbl := l_out_mesg_token_tbl;
524:
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: x_mesg_token_tbl := l_mesg_token_tbl ;
527: RETURN;
528: END;
529: END IF;

Line 542: raise fnd_api.g_exc_unexpected_error;

538: close CON;
539: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking prev_uncomplete ...'); END IF;
540:
541: IF l_prev_uncomplete > 0 THEN
542: raise fnd_api.g_exc_unexpected_error;
543: END IF;
544:
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546:

Line 545: x_return_status := FND_API.G_RET_STS_SUCCESS;

541: IF l_prev_uncomplete > 0 THEN
542: raise fnd_api.g_exc_unexpected_error;
543: END IF;
544:
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546:
547: EXCEPTION
548: WHEN OTHERS THEN
549:

Line 563: x_return_status := FND_API.G_RET_STS_ERROR;

559: , x_mesg_token_tbl => l_out_mesg_token_tbl
560: );
561: l_mesg_token_tbl := l_out_mesg_token_tbl;
562:
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: x_mesg_token_tbl := l_mesg_token_tbl ;
565: RETURN;
566: END;
567: END IF;

Line 578: raise fnd_api.g_exc_unexpected_error;

574: WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id;
575: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking status_type ...'); END IF;
576:
577: IF (l_job_status = 4 ) THEN
578: raise fnd_api.g_exc_unexpected_error;
579: END IF;
580:
581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582:

Line 581: x_return_status := FND_API.G_RET_STS_SUCCESS;

577: IF (l_job_status = 4 ) THEN
578: raise fnd_api.g_exc_unexpected_error;
579: END IF;
580:
581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582:
583: EXCEPTION
584: WHEN OTHERS THEN
585:

Line 598: x_return_status := FND_API.G_RET_STS_ERROR;

594: , x_mesg_token_tbl => l_out_mesg_token_tbl
595: );
596: l_mesg_token_tbl := l_out_mesg_token_tbl;
597:
598: x_return_status := FND_API.G_RET_STS_ERROR;
599: x_mesg_token_tbl := l_mesg_token_tbl ;
600: RETURN;
601: END;
602: END IF;

Line 612: raise fnd_api.g_exc_unexpected_error;

608: close CON3;
609: 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;
610:
611: if(p_eam_op_comp_rec.actual_start_date < l_max_prior_end_date) then
612: raise fnd_api.g_exc_unexpected_error;
613: end if;
614:
615: x_return_status := FND_API.G_RET_STS_SUCCESS;
616:

Line 615: x_return_status := FND_API.G_RET_STS_SUCCESS;

611: if(p_eam_op_comp_rec.actual_start_date < l_max_prior_end_date) then
612: raise fnd_api.g_exc_unexpected_error;
613: end if;
614:
615: x_return_status := FND_API.G_RET_STS_SUCCESS;
616:
617: EXCEPTION
618: WHEN OTHERS THEN
619: l_token_tbl(1).token_name := 'MIN_START_DATE';

Line 631: x_return_status := FND_API.G_RET_STS_ERROR;

627: , x_mesg_token_tbl => l_out_mesg_token_tbl
628: );
629: l_mesg_token_tbl := l_out_mesg_token_tbl;
630:
631: x_return_status := FND_API.G_RET_STS_ERROR;
632: x_mesg_token_tbl := l_mesg_token_tbl ;
633: RETURN;
634: END;
635: END IF;