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

Line 91: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

87: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
88: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
89: )
90: IS
91: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
92: l_ref_qty NUMBER := 0;
93: l_component_qty NUMBER;
94: l_dummy VARCHAR(80);
95: l_processed BOOLEAN;

Line 141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

137: x_err_text => l_err_text
138: );
139:
140: EXCEPTION
141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
142: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: END;
144:
145: END IF;

Line 142: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

138: );
139:
140: EXCEPTION
141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
142: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: END;
144:
145: END IF;
146:

Line 195: l_return_status := FND_API.G_RET_STS_ERROR;

191: , p_message_name => 'ENG_DISABLE_DESG_NOT_FOUND'
192: , p_Token_Tbl => l_Token_Tbl
193: );
194:
195: l_return_status := FND_API.G_RET_STS_ERROR;
196: END;
197:
198: END IF;
199:

Line 214: l_return_status := FND_API.G_RET_STS_ERROR;

210: --
211: IF acd.acd_type = 1 /* ADD */ AND
212: p_ref_designator_rec.acd_type <> 1
213: THEN
214: l_return_status := FND_API.G_RET_STS_ERROR;
215:
216: l_Token_Tbl(1).Token_Name := 'REVISED_COMPONENT_NAME';
217: l_Token_Tbl(1).Token_Value :=
218: p_Ref_Designator_Rec.component_item_name;

Line 250: l_return_status := FND_API.G_RET_STS_ERROR;

246:
247: -- If no exception is raised then
248: -- Generate an error saying that the component is non-standard.
249:
250: l_return_status := FND_API.G_RET_STS_ERROR;
251:
252: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
253: THEN
254: Error_Handler.Add_Error_Token

Line 280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

276: ' ' || to_char(SQLCODE)
277: , p_message_name => NULL
278: );
279:
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281:
282: END; /* End Checking for non-standard component */
283:
284: BEGIN

Line 302: l_return_status := FND_API.G_RET_STS_ERROR;

298: );
299:
300: -- If a record is found, then log an error because of the above
301: -- mentioned comment.
302: l_return_status := FND_API.G_RET_STS_ERROR;
303:
304: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
305: THEN
306: Error_Handler.Add_Error_Token

Line 331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

327: ' ' || to_char(SQLCODE)
328: , p_message_name => NULL
329: );
330:
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END; /* End Checking for Planning Parent */
333:
334:
335: --dbms_output.put_line('Verified Component not planning . . .');

Line 424: WHEN FND_API.G_EXC_ERROR THEN

420: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
421:
422: EXCEPTION
423:
424: WHEN FND_API.G_EXC_ERROR THEN
425:
426: --dbms_output.put_line('Expected Error in Ref Desgs. Entity Validation ');
427:
428: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 429: x_return_status := FND_API.G_RET_STS_ERROR;

425:
426: --dbms_output.put_line('Expected Error in Ref Desgs. Entity Validation ');
427:
428: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
429: x_return_status := FND_API.G_RET_STS_ERROR;
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432:
433: --dbms_output.put_line('UNExpected Error in Ref. Desgs Entity Validation ');

Line 431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

427:
428: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
429: x_return_status := FND_API.G_RET_STS_ERROR;
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432:
433: --dbms_output.put_line('UNExpected Error in Ref. Desgs Entity Validation ');
434: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432:
433: --dbms_output.put_line('UNExpected Error in Ref. Desgs Entity Validation ');
434: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
436:
437: WHEN OTHERS THEN
438: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
436:
437: WHEN OTHERS THEN
438: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440:
441: END Check_Entity;
442:
443: /********************************************************************

Line 464: x_return_status := FND_API.G_RET_STS_SUCCESS;

460: l_token_tbl Error_Handler.Token_tbl_Type;
461: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
462: BEGIN
463:
464: x_return_status := FND_API.G_RET_STS_SUCCESS;
465:
466: -- Validate ref_designator attributes
467:
468: --dbms_output.put_line('Attribute Validation Starts . . . ');

Line 486: x_return_status := FND_API.G_RET_STS_ERROR;

482: , p_message_name => 'ENG_RFD_SBC_ACD_TYPE_INVALID'
483: , p_token_tbl => l_token_tbl
484: );
485: END IF;
486: x_return_status := FND_API.G_RET_STS_ERROR;
487: END IF;
488:
489: --dbms_output.put_line('After ACD_TYPE . . .');
490:

Line 496: WHEN FND_API.G_EXC_ERROR THEN

492: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
493:
494: EXCEPTION
495:
496: WHEN FND_API.G_EXC_ERROR THEN
497:
498: --dbms_output.put_line('Expected Error in Ref. Desgs Attr Validation . . .');
499: x_Mesg_token_Tbl := l_Mesg_token_Tbl;
500: x_return_status := FND_API.G_RET_STS_ERROR;

Line 500: x_return_status := FND_API.G_RET_STS_ERROR;

496: WHEN FND_API.G_EXC_ERROR THEN
497:
498: --dbms_output.put_line('Expected Error in Ref. Desgs Attr Validation . . .');
499: x_Mesg_token_Tbl := l_Mesg_token_Tbl;
500: x_return_status := FND_API.G_RET_STS_ERROR;
501:
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503:
504: --dbms_output.put_line('UNExpected Error in Ref. Desgs Attr Validation . . .');

Line 502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

498: --dbms_output.put_line('Expected Error in Ref. Desgs Attr Validation . . .');
499: x_Mesg_token_Tbl := l_Mesg_token_Tbl;
500: x_return_status := FND_API.G_RET_STS_ERROR;
501:
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503:
504: --dbms_output.put_line('UNExpected Error in Ref. Desgs Attr Validation . . .');
505: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503:
504: --dbms_output.put_line('UNExpected Error in Ref. Desgs Attr Validation . . .');
505: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507:
508: WHEN OTHERS THEN
509: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507:
508: WHEN OTHERS THEN
509: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511:
512: END Check_Attributes;
513:
514: /********************************************************************

Line 535: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

531: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
532: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
533: )
534: IS
535: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
536: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
537:
538: BEGIN
539:

Line 626: l_return_status := FND_API.G_RET_STS_ERROR;

622: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
623: , p_message_name => 'ENG_REF_DESG_ALREADY_EXISTS'
624: , p_token_tbl => l_token_tbl
625: );
626: l_return_status := FND_API.G_RET_STS_ERROR;
627: ELSIF l_return_status = BOM_Globals.G_RECORD_NOT_FOUND AND
628: p_ref_designator_rec.transaction_type IN
629: (BOM_Globals.G_OPR_UPDATE, BOM_Globals.G_OPR_DELETE)
630: THEN

Line 637: l_return_status := FND_API.G_RET_STS_ERROR;

633: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
634: , p_message_name => 'ENG_REF_DESG_DOESNOT_EXIST'
635: , p_token_tbl => l_token_tbl
636: );
637: l_return_status := FND_API.G_RET_STS_ERROR;
638: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
639: THEN
640: Error_Handler.Add_Error_Token
641: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl

Line 638: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR

634: , p_message_name => 'ENG_REF_DESG_DOESNOT_EXIST'
635: , p_token_tbl => l_token_tbl
636: );
637: l_return_status := FND_API.G_RET_STS_ERROR;
638: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
639: THEN
640: Error_Handler.Add_Error_Token
641: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
642: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 651: l_return_status := FND_API.G_RET_STS_SUCCESS;

647: p_ref_designator_rec.reference_designator_name
648: , p_token_tbl => l_token_tbl
649: );
650: ELSE
651: l_return_status := FND_API.G_RET_STS_SUCCESS;
652: END IF;
653:
654: x_return_status := l_return_status;
655: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 677: x_return_status := FND_API.G_RET_STS_SUCCESS;

673: AND operation_seq_num=p_ref_designator_rec.operation_sequence_number
674: AND effectivity_date = p_ref_designator_rec.start_effective_date
675: AND bill_sequence_id = p_ref_desg_unexp_rec.bill_sequence_id;
676: BEGIN
677: x_return_status := FND_API.G_RET_STS_SUCCESS;
678:
679: FOR Component IN c_GetComponent LOOP
680: IF Component.revised_item_sequence_id <>
681: p_ref_desg_unexp_rec.revised_item_sequence_id

Line 702: x_return_status := FND_API.G_RET_STS_ERROR;

698: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
699: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
700: , p_Token_Tbl => l_Token_Tbl
701: );
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: END IF;
704: END LOOP;
705:
706: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;

Line 722: l_return_status := FND_API.G_RET_STS_SUCCESS;

718: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
719: l_dummy VARCHAR2(80);
720: l_token_tbl Error_Handler.Token_Tbl_Type;
721: BEGIN
722: l_return_status := FND_API.G_RET_STS_SUCCESS;
723:
724: /************************************************************************
725: *
726: * If the parent component is having an ACD_type of Disable then cannot

Line 753: l_return_status := FND_API.G_RET_STS_ERROR;

749: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
750: , p_message_name => 'ENG_RFD_COMP_ACD_TYPE_DISABLE'
751: , p_Token_Tbl => l_Token_Tbl
752: );
753: l_return_status := FND_API.G_RET_STS_ERROR;
754: WHEN OTHERS THEN
755: --This means that an unexpected error has occured
756: Error_Handler.Add_Error_Token
757: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl

Line 765: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

761: || SUBSTR(SQLERRM, 1, 240)
762: || ' ' || to_char(SQLCODE)
763: );
764:
765: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766: END;
767: x_return_status := l_return_status;
768: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
769: