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

Line 87: l_return_status := FND_API.G_RET_STS_ERROR;

83: , p_token_tbl => l_token_tbl
84: );
85: l_mesg_token_tbl := l_out_mesg_token_tbl;
86:
87: l_return_status := FND_API.G_RET_STS_ERROR;
88:
89: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND
90: p_eam_direct_items_rec.transaction_type IN
91: (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)

Line 105: l_return_status := FND_API.G_RET_STS_ERROR;

101: , p_token_tbl => l_token_tbl
102: );
103: l_mesg_token_tbl := l_out_mesg_token_tbl;
104:
105: l_return_status := FND_API.G_RET_STS_ERROR;
106:
107: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
108: THEN
109: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 107: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR

103: l_mesg_token_tbl := l_out_mesg_token_tbl;
104:
105: l_return_status := FND_API.G_RET_STS_ERROR;
106:
107: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
108: THEN
109: l_out_mesg_token_tbl := l_mesg_token_tbl;
110: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
111: ( x_Mesg_token_tbl => l_out_Mesg_Token_Tbl

Line 117: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

113: , p_message_name => NULL
114: , p_message_text => 'Unexpected error while existence verification of ' || 'Direct Item '|| p_eam_direct_items_rec.direct_item_sequence_id , p_token_tbl => l_token_tbl
115: );
116: l_mesg_token_tbl := l_out_mesg_token_tbl;
117: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
118:
119: ELSE /* Assign the relevant transaction type for SYNC operations */
120: IF p_eam_direct_items_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
121: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN

Line 127: l_return_status := FND_API.G_RET_STS_SUCCESS;

123: ELSE
124: x_old_eam_direct_items_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
125: END IF;
126: END IF;
127: l_return_status := FND_API.G_RET_STS_SUCCESS;
128:
129: END IF;
130:
131: x_return_status := l_return_status;

Line 163: x_return_status := FND_API.G_RET_STS_SUCCESS;

159: l_ordered_quantity NUMBER;
160:
161: BEGIN
162:
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Direct Item Check Attributes . . . '); END IF;
166:
167:

Line 179: raise fnd_api.g_exc_error;

175: if (p_eam_direct_items_rec.operation_seq_num = 1 and
176: p_eam_direct_items_rec.department_id is not null) OR
177: (p_eam_direct_items_rec.operation_seq_num <> 1 and
178: p_eam_direct_items_rec.department_id is null) then
179: raise fnd_api.g_exc_error;
180: end if;
181:
182: if p_eam_direct_items_rec.operation_seq_num <> 1 then
183:

Line 200: x_return_status := FND_API.G_RET_STS_SUCCESS;

196: end if;
197:
198: end if;
199:
200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201:
202: exception
203: when others then
204:

Line 217: x_return_status := FND_API.G_RET_STS_ERROR;

213: , x_mesg_token_tbl => l_out_mesg_token_tbl
214: );
215: l_mesg_token_tbl := l_out_mesg_token_tbl;
216:
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: x_mesg_token_tbl := l_mesg_token_tbl ;
219: return;
220:
221: end;

Line 356: x_return_status := FND_API.G_RET_STS_SUCCESS;

352: end if;
353:
354: end if;
355:
356: x_return_status := FND_API.G_RET_STS_SUCCESS;
357:
358: exception
359: when others then
360:

Line 373: x_return_status := FND_API.G_RET_STS_ERROR;

369: , x_mesg_token_tbl => l_out_mesg_token_tbl
370: );
371: l_mesg_token_tbl := l_out_mesg_token_tbl;
372:
373: x_return_status := FND_API.G_RET_STS_ERROR;
374: x_mesg_token_tbl := l_mesg_token_tbl ;
375: return;
376:
377: end;

Line 401: x_return_status := FND_API.G_RET_STS_SUCCESS;

397:
398:
399: end if;
400:
401: x_return_status := FND_API.G_RET_STS_SUCCESS;
402:
403: exception
404: when others then
405:

Line 418: x_return_status := FND_API.G_RET_STS_ERROR;

414: , x_mesg_token_tbl => l_out_mesg_token_tbl
415: );
416: l_mesg_token_tbl := l_out_mesg_token_tbl;
417:
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: x_mesg_token_tbl := l_mesg_token_tbl ;
420: return;
421:
422: end;

Line 432: raise fnd_api.g_exc_unexpected_error;

428:
429: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
430:
431: if p_eam_direct_items_rec.quantity_per_assembly < 0 then
432: raise fnd_api.g_exc_unexpected_error;
433: end if;
434:
435: end if;
436:

Line 437: x_return_status := FND_API.G_RET_STS_SUCCESS;

433: end if;
434:
435: end if;
436:
437: x_return_status := FND_API.G_RET_STS_SUCCESS;
438:
439: exception
440: when others then
441:

Line 454: x_return_status := FND_API.G_RET_STS_ERROR;

450: , x_mesg_token_tbl => l_out_mesg_token_tbl
451: );
452: l_mesg_token_tbl := l_out_mesg_token_tbl;
453:
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: x_mesg_token_tbl := l_mesg_token_tbl ;
456: return;
457:
458: end;

Line 472: raise fnd_api.g_exc_unexpected_error;

468:
469: if(p_eam_direct_items_rec.wip_supply_type is not null and p_eam_direct_items_rec.wip_supply_type not in (wip_constants.push, wip_constants.bulk, wip_constants.based_on_bom)) then
470: --not a valid supply type
471:
472: raise fnd_api.g_exc_unexpected_error;
473:
474: end if;
475:
476: end if;

Line 478: x_return_status := FND_API.G_RET_STS_SUCCESS;

474: end if;
475:
476: end if;
477:
478: x_return_status := FND_API.G_RET_STS_SUCCESS;
479:
480: exception
481: when others then
482:

Line 495: x_return_status := FND_API.G_RET_STS_ERROR;

491: , x_mesg_token_tbl => l_out_mesg_token_tbl
492: );
493: l_mesg_token_tbl := l_out_mesg_token_tbl;
494:
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: x_mesg_token_tbl := l_mesg_token_tbl ;
497: return;
498:
499: end;

Line 510: raise fnd_api.g_exc_unexpected_error;

506:
507: if (p_eam_direct_items_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
508:
509: if p_eam_direct_items_rec.mrp_net_flag not in (wip_constants.yes, wip_constants.no) then
510: raise fnd_api.g_exc_unexpected_error;
511: end if;
512:
513: end if;
514:

Line 515: x_return_status := FND_API.G_RET_STS_SUCCESS;

511: end if;
512:
513: end if;
514:
515: x_return_status := FND_API.G_RET_STS_SUCCESS;
516:
517: exception
518: when others then
519:

Line 532: x_return_status := FND_API.G_RET_STS_ERROR;

528: , x_mesg_token_tbl => l_out_mesg_token_tbl
529: );
530: l_mesg_token_tbl := l_out_mesg_token_tbl;
531:
532: x_return_status := FND_API.G_RET_STS_ERROR;
533: x_mesg_token_tbl := l_mesg_token_tbl ;
534: return;
535:
536: end;

Line 560: raise fnd_api.g_exc_unexpected_error;

556: and operation_seq_num = p_eam_direct_items_rec.operation_seq_num
557: and direct_item_sequence_id = p_eam_direct_items_rec.direct_item_sequence_id;
558:
559: if(l_count_mmtt > 0) then
560: raise fnd_api.g_exc_unexpected_error;
561: end if;
562:
563: select count(*)
564: into l_count_mmt

Line 572: raise fnd_api.g_exc_unexpected_error;

568: and operation_seq_num = p_eam_direct_items_rec.operation_seq_num
569: and direct_item_sequence_id = p_eam_direct_items_rec.direct_item_sequence_id;
570:
571: if(l_count_mmt > 0) then
572: raise fnd_api.g_exc_unexpected_error;
573: end if;
574:
575: select quantity_issued
576: into l_issued_qty

Line 584: raise fnd_api.g_exc_unexpected_error;

580: and operation_seq_num = p_eam_direct_items_rec.operation_seq_num
581: and direct_item_sequence_id = p_eam_direct_items_rec.direct_item_sequence_id;
582:
583: if(l_issued_qty <> 0) then
584: raise fnd_api.g_exc_unexpected_error;
585: end if;
586:
587: end if;
588:

Line 589: x_return_status := FND_API.G_RET_STS_SUCCESS;

585: end if;
586:
587: end if;
588:
589: x_return_status := FND_API.G_RET_STS_SUCCESS;
590:
591: exception
592: when others then
593:

Line 606: x_return_status := FND_API.G_RET_STS_ERROR;

602: , x_mesg_token_tbl => l_out_mesg_token_tbl
603: );
604: l_mesg_token_tbl := l_out_mesg_token_tbl;
605:
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: x_mesg_token_tbl := l_mesg_token_tbl ;
608: return;
609:
610: end;

Line 619: raise fnd_api.g_exc_unexpected_error;

615: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating required_quantity . . . '); END IF;
616:
617: begin
618: if p_eam_direct_items_rec.required_quantity < p_eam_direct_items_rec.quantity_issued then
619: raise fnd_api.g_exc_unexpected_error;
620: end if;
621:
622: x_return_status := FND_API.G_RET_STS_SUCCESS;
623:

Line 622: x_return_status := FND_API.G_RET_STS_SUCCESS;

618: if p_eam_direct_items_rec.required_quantity < p_eam_direct_items_rec.quantity_issued then
619: raise fnd_api.g_exc_unexpected_error;
620: end if;
621:
622: x_return_status := FND_API.G_RET_STS_SUCCESS;
623:
624: exception
625: when others then
626:

Line 636: x_return_status := FND_API.G_RET_STS_ERROR;

632: , x_mesg_token_tbl => l_out_mesg_token_tbl
633: );
634: l_mesg_token_tbl := l_out_mesg_token_tbl;
635:
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: x_mesg_token_tbl := l_mesg_token_tbl ;
638: return;
639:
640: end;

Line 664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

660: ) ;
661: l_mesg_token_tbl := l_out_mesg_token_tbl;
662:
663: -- Return the status and message table.
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
665: x_mesg_token_tbl := l_mesg_token_tbl ;
666:
667:
668: END Check_Attributes;

Line 689: x_return_status := FND_API.G_RET_STS_SUCCESS;

685: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
686: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
687: BEGIN
688:
689: x_return_status := FND_API.G_RET_STS_SUCCESS;
690:
691:
692:
693: IF p_eam_direct_items_rec.wip_entity_id IS NULL

Line 707: x_return_status := FND_API.G_RET_STS_ERROR;

703: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
704: );
705: l_mesg_token_tbl := l_out_mesg_token_tbl;
706:
707: x_return_status := FND_API.G_RET_STS_ERROR;
708:
709: END IF;
710:
711:

Line 726: x_return_status := FND_API.G_RET_STS_ERROR;

722: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
723: );
724: l_mesg_token_tbl := l_out_mesg_token_tbl;
725:
726: x_return_status := FND_API.G_RET_STS_ERROR;
727:
728: END IF;
729:
730:

Line 745: x_return_status := FND_API.G_RET_STS_ERROR;

741: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
742: );
743: l_mesg_token_tbl := l_out_mesg_token_tbl;
744:
745: x_return_status := FND_API.G_RET_STS_ERROR;
746:
747: END IF;
748:
749:

Line 764: x_return_status := FND_API.G_RET_STS_ERROR;

760: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
761: );
762: l_mesg_token_tbl := l_out_mesg_token_tbl;
763:
764: x_return_status := FND_API.G_RET_STS_ERROR;
765:
766: END IF;
767:
768: IF p_eam_direct_items_rec.description IS NULL

Line 782: x_return_status := FND_API.G_RET_STS_ERROR;

778: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
779: );
780: l_mesg_token_tbl := l_out_mesg_token_tbl;
781:
782: x_return_status := FND_API.G_RET_STS_ERROR;
783:
784: END IF;
785:
786:

Line 801: x_return_status := FND_API.G_RET_STS_ERROR;

797: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
798: );
799: l_mesg_token_tbl := l_out_mesg_token_tbl;
800:
801: x_return_status := FND_API.G_RET_STS_ERROR;
802:
803: END IF;
804:
805:

Line 820: x_return_status := FND_API.G_RET_STS_ERROR;

816: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
817: );
818: l_mesg_token_tbl := l_out_mesg_token_tbl;
819:
820: x_return_status := FND_API.G_RET_STS_ERROR;
821:
822: END IF;
823:
824:

Line 839: x_return_status := FND_API.G_RET_STS_ERROR;

835: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
836: );
837: l_mesg_token_tbl := l_out_mesg_token_tbl;
838:
839: x_return_status := FND_API.G_RET_STS_ERROR;
840:
841: END IF;
842:
843: