DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REF_DESIGNATOR dependencies on ERROR_HANDLER

Line 86: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

82: ********************************************************************/
83:
84: PROCEDURE Check_Entity
85: ( x_return_status OUT NOCOPY VARCHAR2
86: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
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

Line 99: l_token_tbl Error_Handler.Token_Tbl_Type;

95: l_processed BOOLEAN;
96: l_quantity NUMBER;
97: l_change NUMBER := 0;
98: l_component_seq_id NUMBER := 0;
99: l_token_tbl Error_Handler.Token_Tbl_Type;
100: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
101: l_Err_text VARCHAR2(2000);
102:
103: CURSOR c_acdtype IS

Line 100: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

96: l_quantity NUMBER;
97: l_change NUMBER := 0;
98: l_component_seq_id NUMBER := 0;
99: l_token_tbl Error_Handler.Token_Tbl_Type;
100: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
101: l_Err_text VARCHAR2(2000);
102:
103: CURSOR c_acdtype IS
104: SELECT acd_type, old_component_sequence_id

Line 188: Error_Handler.Add_Error_Token

184: 'REFERENCE_DESIGNATOR_NAME';
185: l_token_tbl(2).token_value :=
186: p_ref_designator_rec.reference_designator_name;
187:
188: Error_Handler.Add_Error_Token
189: ( x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
190: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
191: , p_message_name => 'ENG_DISABLE_DESG_NOT_FOUND'
192: , p_Token_Tbl => l_Token_Tbl

Line 220: Error_Handler.Add_Error_Token

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;
219:
220: Error_Handler.Add_Error_Token
221: ( x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
222: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
223: , p_message_name => 'ENG_RFD_ACD_NOT_COMPATIBLE'
224: , p_Token_Tbl => l_Token_Tbl

Line 254: Error_Handler.Add_Error_Token

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
255: ( x_Mesg_Token_tbl => l_Mesg_Token_Tbl
256: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
257: , p_message_name => 'ENG_RFD_NON_STD_PARENT'
258: );

Line 271: Error_Handler.Add_Error_Token

267: -- ('Unexpected error in Checking Planning Item ' ||
268: -- SQLERRM
269: -- );
270:
271: Error_Handler.Add_Error_Token
272: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
273: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
274: , p_message_text => 'ERROR in Entity validation '
275: || SUBSTR(SQLERRM, 1, 30) ||

Line 306: Error_Handler.Add_Error_Token

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
307: ( x_Mesg_Token_tbl => l_Mesg_Token_Tbl
308: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
309: , p_message_name => 'ENG_RFD_PLANNING_BILL'
310: );

Line 322: Error_Handler.Add_Error_Token

318: --('Unexpected error in Checking Planning Item ' ||
319: -- SQLERRM
320: -- );
321:
322: Error_Handler.Add_Error_Token
323: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
324: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
325: , p_message_text => 'ERROR in Entity validation '
326: || SUBSTR(SQLERRM, 1, 30) ||

Line 402: Error_Handler.Add_Error_Token

398: -- Log a warning but do not set the error status
399: l_token_tbl(1).token_name := 'REVISED_COMPONENT_NAME';
400: l_token_tbl(1).token_value :=
401: p_ref_designator_rec.component_item_name;
402: Error_Handler.Add_Error_Token
403: ( x_Mesg_Token_Tbl => l_Mesg_Token_tbl
404: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
405: , p_message_name => 'ENG_QUANTITY_RELATED_INVALID'
406: , p_token_tbl => l_token_tbl

Line 456: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

452: ********************************************************************/
453:
454: PROCEDURE Check_Attributes
455: ( x_return_status OUT NOCOPY VARCHAR2
456: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
457: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
458: )
459: IS
460: l_token_tbl Error_Handler.Token_tbl_Type;

Line 460: l_token_tbl Error_Handler.Token_tbl_Type;

456: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
457: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
458: )
459: IS
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;

Line 461: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

457: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
458: )
459: IS
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:

Line 479: Error_Handler.Add_Error_Token

475: l_token_tbl(1).token_name := 'REF_DESG';
476: l_token_tbl(1).token_value := 'ENG_REF_DESG_CAP';
477: l_token_tbl(1).translate := TRUE;
478:
479: Error_Handler.Add_Error_Token
480: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
481: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
482: , p_message_name => 'ENG_RFD_SBC_ACD_TYPE_INVALID'
483: , p_token_tbl => l_token_tbl

Line 530: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

526: ********************************************************************/
527:
528: PROCEDURE Check_Entity_Delete
529: ( x_return_status OUT NOCOPY VARCHAR2
530: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
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

Line 536: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_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:
540: /***********************************************************************

Line 557: Error_Handler.Add_Error_Token

553: -- But the Quantity Related is 1 so log a warning
554: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
555: -- This ideally should be a warning
556: THEN
557: Error_Handler.Add_Error_Token
558: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
559: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
560: , p_message_name => 'ENG_QUANTITY_RELATED_INVALID'
561: );

Line 592: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

588: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
589: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
590: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
591: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
592: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
593: , x_Return_Status OUT NOCOPY VARCHAR2
594: )
595: IS
596: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 596: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

592: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
593: , x_Return_Status OUT NOCOPY VARCHAR2
594: )
595: IS
596: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
597: l_Return_Status VARCHAR2(1);
598: l_Token_Tbl Error_Handler.Token_Tbl_Type;
599: BEGIN
600: l_Token_Tbl(1).Token_Name := 'REFERENCE_DESIGNATOR_NAME';

Line 598: l_Token_Tbl Error_Handler.Token_Tbl_Type;

594: )
595: IS
596: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
597: l_Return_Status VARCHAR2(1);
598: l_Token_Tbl Error_Handler.Token_Tbl_Type;
599: BEGIN
600: l_Token_Tbl(1).Token_Name := 'REFERENCE_DESIGNATOR_NAME';
601: l_Token_Tbl(1).Token_Value :=
602: p_ref_designator_rec.reference_designator_name;

Line 620: Error_Handler.Add_Error_Token

616:
617: IF l_return_status = BOM_Globals.G_RECORD_FOUND AND
618: p_ref_designator_rec.transaction_type = BOM_Globals.G_OPR_CREATE
619: THEN
620: Error_Handler.Add_Error_Token
621: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
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

Line 631: Error_Handler.Add_Error_Token

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
631: Error_Handler.Add_Error_Token
632: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
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

Line 640: Error_Handler.Add_Error_Token

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
643: , p_message_name => NULL
644: , p_message_text =>

Line 662: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

658:
659: PROCEDURE Check_Lineage
660: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
661: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
662: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
663: , x_Return_Status OUT NOCOPY VARCHAR2
664: )
665: IS
666: l_token_tbl Error_Handler.Token_Tbl_Type;

Line 666: l_token_tbl Error_Handler.Token_Tbl_Type;

662: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
663: , x_Return_Status OUT NOCOPY VARCHAR2
664: )
665: IS
666: l_token_tbl Error_Handler.Token_Tbl_Type;
667: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
668:
669: CURSOR c_GetComponent IS
670: SELECT revised_item_sequence_id

Line 667: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

663: , x_Return_Status OUT NOCOPY VARCHAR2
664: )
665: IS
666: l_token_tbl Error_Handler.Token_Tbl_Type;
667: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
668:
669: CURSOR c_GetComponent IS
670: SELECT revised_item_sequence_id
671: FROM bom_inventory_components

Line 696: Error_Handler.Add_Error_Token

692: 'REVISED_ITEM_NAME';
693: l_Token_Tbl(3).token_value :=
694: p_ref_designator_rec.revised_item_name;
695:
696: Error_Handler.Add_Error_Token
697: ( p_Message_Name => 'ENG_REF_REV_ITEM_MISMATCH'
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

Line 713: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

709:
710: PROCEDURE CHECK_ACCESS
711: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
712: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
713: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
714: , x_Return_Status OUT NOCOPY VARCHAR2
715: )
716: IS
717: l_return_status VARCHAR2(1);

Line 718: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

714: , x_Return_Status OUT NOCOPY VARCHAR2
715: )
716: IS
717: l_return_status VARCHAR2(1);
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;

Line 720: l_token_tbl Error_Handler.Token_Tbl_Type;

716: IS
717: l_return_status VARCHAR2(1);
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: /************************************************************************

Line 747: Error_Handler.Add_Error_Token

743: l_token_Tbl(1).Token_Name := 'REF_DESG';
744: l_token_Tbl(1).Token_Value :=
745: p_Ref_Designator_Rec.Reference_Designator_Name;
746:
747: Error_Handler.Add_Error_Token
748: ( x_Mesg_Token_tbl => l_Mesg_token_tbl
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

Line 756: Error_Handler.Add_Error_Token

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
758: , p_Mesg_token_Tbl => l_Mesg_Token_Tbl
759: , p_message_name => NULL
760: , p_message_text => 'ERROR in Entity validation '