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_SUB_COMPONENT dependencies on ERROR_HANDLER

Line 17: Error_Handler.Mesg_Token_Tbl_Type

13: PROCEDURE CHECK_REQUIRED( x_return_status OUT NOCOPY VARCHAR2
14: , p_sub_component_rec IN
15: Bom_Bo_Pub.Sub_Component_Rec_Type
16: , x_Mesg_Token_tbl OUT NOCOPY
17: Error_Handler.Mesg_Token_Tbl_Type
18: )
19: IS
20: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
21: BEGIN

Line 20: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

16: , x_Mesg_Token_tbl OUT NOCOPY
17: Error_Handler.Mesg_Token_Tbl_Type
18: )
19: IS
20: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
21: BEGIN
22: IF p_sub_component_rec.Revised_Item_Name IS NULL OR
23: p_sub_component_rec.Revised_Item_Name = FND_API.G_MISS_CHAR OR
24: p_sub_component_rec.Start_Effective_Date IS NULL OR

Line 40: Error_Handler.Add_Error_Token

36: p_sub_component_rec.acd_type IS NULL OR
37: p_sub_component_rec.acd_type = FND_API.G_MISS_NUM
38: THEN
39: x_return_status := FND_API.G_RET_STS_ERROR;
40: Error_Handler.Add_Error_Token
41: ( x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
42: , p_Message_Name => 'ENG_SUB_COMP_REQ'
43: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
44: );

Line 67: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

63: *
64: *********************************************************************/
65: PROCEDURE Check_Entity
66: ( x_return_status OUT NOCOPY VARCHAR2
67: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
68: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
69: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
70: )
71: IS

Line 87: l_token_tbl Error_Handler.Token_Tbl_Type;

83: l_rec_ID DATE;
84: l_processed BOOLEAN;
85: l_err_text VARCHAR2(200);
86: stmt_num NUMBER := 0;
87: l_token_tbl Error_Handler.Token_Tbl_Type;
88: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
89: l_sbc_item_type NUMBER;
90: l_sbc_bom_enabled_flag VARCHAR2(1);
91: l_sbc_eng_item_flag VARCHAR2(1);

Line 88: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

84: l_processed BOOLEAN;
85: l_err_text VARCHAR2(200);
86: stmt_num NUMBER := 0;
87: l_token_tbl Error_Handler.Token_Tbl_Type;
88: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
89: l_sbc_item_type NUMBER;
90: l_sbc_bom_enabled_flag VARCHAR2(1);
91: l_sbc_eng_item_flag VARCHAR2(1);
92: BEGIN

Line 154: Error_Handler.Add_Error_Token

150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
151: --dbms_output.put_line
152: -- ('Expected Error. non-standard component . . . ');
153:
154: Error_Handler.Add_Error_Token
155: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
156: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
157: , p_message_name => l_err_text
158: );

Line 171: Error_Handler.Add_Error_Token

167: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
168: --dbms_output.put_line
169: -- ('Expected Error. planning parent. . . ');
170:
171: Error_Handler.Add_Error_Token
172: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
173: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
174: , p_message_name => l_err_text
175: );

Line 190: Error_Handler.Add_Error_Token

186: NULL; -- Do nothing
187: WHEN OTHERS THEN
188: --dbms_output.put_line('Unexpected error in Checking Planning Item
189: -- ' || SQLERRM);
190: Error_Handler.Add_Error_Token
191: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
192: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
193: , p_message_name => NULL
194: , p_message_text => 'ERROR in Entity validation ' ||

Line 244: Error_Handler.Add_Error_Token

240: AND inventory_item_id = p_Sub_Comp_Unexp_Rec.substitute_component_id;
241:
242: IF l_sbc_item_type <> 4 THEN
243: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
244: Error_Handler.Add_Error_Token
245: ( x_Mesg_Token_tbl => l_Mesg_Token_Tbl
246: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
247: , p_message_name => 'ENG_SUB_COMP_NOT_STD'
248: );

Line 259: Error_Handler.Add_Error_Token

255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
256: l_token_tbl(1).token_name := 'SUBSTITUTE_ITEM_NAME';
257: l_token_tbl(1).token_value :=
258: p_sub_component_rec.substitute_component_name;
259: Error_Handler.Add_Error_Token
260: ( x_Mesg_Token_tbl => l_Mesg_Token_Tbl
261: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
262: , p_message_name => 'ENG_SUB_COMP_NOT_BOM_ENABLED'
263: , p_token_tbl => l_token_tbl

Line 272: Error_Handler.Add_Error_Token

268:
269: IF ((l_rec_AST = 2) OR (l_rec_AST = 1 AND l_sbc_eng_item_flag = 'Y'))
270: THEN
271: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
272: Error_Handler.Add_Error_Token
273: ( x_Mesg_Token_tbl => l_Mesg_Token_Tbl
274: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
275: , p_message_name => 'ENG_SUB_COMP_ASSEMBLY_MFG'
276: );

Line 316: Error_Handler.Add_Error_Token

312: l_token_tbl.DELETE;
313: l_Token_tbl(1).token_name := 'SUBSTITUTE_ITEM_NAME';
314: l_token_tbl(1).token_value :=
315: p_sub_component_rec.substitute_component_name;
316: Error_Handler.Add_Error_Token
317: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
318: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
319: , p_message_name => 'ENG_SBC_COMBILL_DOES_NOT_EXIST'
320: , p_token_tbl => l_token_tbl

Line 344: Error_Handler.Add_Error_Token

340: p_Sub_Comp_Unexp_Rec.Substitute_Component_Id IN
341: (l_rec_AII,l_rec_CII))
342: THEN
343: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
344: Error_Handler.Add_Error_Token
345: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
346: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
347: , p_message_name => 'ENG_SUBCOMP_SAMEAS_ITEM_COMP'
348: , p_token_tbl => l_token_tbl

Line 370: Error_Handler.Add_Error_Token

366: stmt_num := 11;
367: IF l_parent_acd_type = 3 THEN
368: l_return_status := FND_API.G_RET_STS_ERROR;
369: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
370: Error_Handler.Add_Error_Token
371: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
372: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
373: , p_message_name => 'ENG_SBC_COMP_ACD_TYPE_DISABLE'
374: );

Line 387: Error_Handler.Add_Error_Token

383: THEN
384: l_return_status := FND_API.G_RET_STS_ERROR;
385: l_token_tbl(1).token_name := 'REVISED_COMPONENT_NAME';
386: l_token_tbl(1).token_value := p_sub_component_rec.component_item_name;
387: Error_Handler.Add_Error_Token
388: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
389: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
390: , p_message_name => 'ENG_SBC_ACD_NOT_COMPATIBLE'
391: , p_token_tbl => l_token_tbl

Line 446: Error_Handler.Add_Error_Token

442: p_sub_component_rec.substitute_component_name;
443: l_token_tbl(2).token_name := 'REVISED_COMPONENT_NAME';
444: l_token_tbl(2).token_value :=
445: p_sub_component_rec.component_item_name;
446: Error_Handler.Add_Error_Token
447: ( x_Mesg_Token_tbl => l_Mesg_Token_tbl
448: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
449: , p_message_name => 'ENG_DISABLE_SCOMP_NOT_FOUND'
450: , p_token_tbl => l_token_tbl

Line 491: Error_Handler.Add_Error_Token( x_Mesg_Token_tbl => x_Mesg_Token_tbl

487: THEN
488: l_err_text := G_PKG_NAME ||
489: 'Validation (Substitute Component Entity)' ||
490: SUBSTR(SQLERRM, 1, 100);
491: Error_Handler.Add_Error_Token( x_Mesg_Token_tbl => x_Mesg_Token_tbl
492: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
493: , p_message_name => NULL
494: , p_message_text => l_err_text
495: );

Line 514: , x_Mesg_Token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

510: *********************************************************************/
511:
512: PROCEDURE Check_Attributes
513: ( x_return_status OUT NOCOPY VARCHAR2
514: , x_Mesg_Token_tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
515: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
516: )
517: IS
518: l_err_text VARCHAR2(255);

Line 519: l_token_tbl Error_Handler.Token_Tbl_Type;

515: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
516: )
517: IS
518: l_err_text VARCHAR2(255);
519: l_token_tbl Error_Handler.Token_Tbl_Type;
520: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
521: BEGIN
522:
523: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 520: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

516: )
517: IS
518: l_err_text VARCHAR2(255);
519: l_token_tbl Error_Handler.Token_Tbl_Type;
520: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
521: BEGIN
522:
523: x_return_status := FND_API.G_RET_STS_SUCCESS;
524:

Line 536: Error_Handler.Add_Error_Token

532: THEN
533: l_token_tbl(1).token_name := 'SUBSITUTE_ITEM_NAME';
534: l_token_tbl(1).token_value :=
535: p_sub_component_rec.substitute_component_name;
536: Error_Handler.Add_Error_Token
537: ( x_Mesg_Token_tbl => x_Mesg_Token_tbl
538: , p_message_name => 'ENG_SUB_COMP_QTY_ZERO'
539: , p_token_tbl => l_token_tbl
540: );

Line 563: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

559: *********************************************************************/
560:
561: PROCEDURE Check_Entity_Delete
562: ( x_return_status OUT NOCOPY VARCHAR2
563: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
564: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
565: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
566: )
567: IS

Line 571: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

567: IS
568: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
569: l_err_text VARCHAR2(255);
570: l_rec_ID DATE := NULL;
571: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
572: BEGIN
573:
574: -- Validate entity delete.
575: x_return_status := l_return_status;

Line 598: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

594: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
595: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
596: , x_old_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
597: , x_old_sub_comp_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
598: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
599: , x_Return_Status OUT NOCOPY VARCHAR2
600: )
601: IS
602: l_token_tbl Error_Handler.Token_Tbl_Type;

Line 602: l_token_tbl Error_Handler.Token_Tbl_Type;

598: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
599: , x_Return_Status OUT NOCOPY VARCHAR2
600: )
601: IS
602: l_token_tbl Error_Handler.Token_Tbl_Type;
603: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
604: l_return_status VARCHAR2(1);
605: BEGIN
606: l_Token_Tbl(1).Token_Name := 'SUBSTITUTE_ITEM_NAME';

Line 603: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

599: , x_Return_Status OUT NOCOPY VARCHAR2
600: )
601: IS
602: l_token_tbl Error_Handler.Token_Tbl_Type;
603: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
604: l_return_status VARCHAR2(1);
605: BEGIN
606: l_Token_Tbl(1).Token_Name := 'SUBSTITUTE_ITEM_NAME';
607: l_Token_Tbl(1).Token_Value :=

Line 628: Error_Handler.Add_Error_Token

624:
625: IF l_return_status = Bom_Globals.G_RECORD_FOUND AND
626: p_sub_component_rec.transaction_type = Bom_Globals.G_OPR_CREATE
627: THEN
628: Error_Handler.Add_Error_Token
629: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
630: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
631: , p_message_name => 'ENG_SUB_COMP_ALREADY_EXISTS'
632: , p_token_tbl => l_token_tbl

Line 639: Error_Handler.Add_Error_Token

635: ELSIF l_return_status = Bom_Globals.G_RECORD_NOT_FOUND AND
636: p_sub_component_rec.transaction_type IN
637: (Bom_Globals.G_OPR_UPDATE, Bom_Globals.G_OPR_DELETE)
638: THEN
639: Error_Handler.Add_Error_Token
640: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
641: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
642: , p_message_name => 'ENG_SUB_COMP_DOESNOT_EXIST'
643: , p_token_tbl => l_token_tbl

Line 648: Error_Handler.Add_Error_Token

644: );
645: l_return_status := FND_API.G_RET_STS_ERROR;
646: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
647: THEN
648: Error_Handler.Add_Error_Token
649: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
650: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
651: , p_message_name => NULL
652: , p_message_text =>

Line 680: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

676: *****************************************************************************/
677: PROCEDURE Check_Lineage
678: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
679: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
680: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
681: , x_Return_Status OUT NOCOPY VARCHAR2
682: )
683: IS
684: l_token_tbl Error_Handler.Token_Tbl_Type;

Line 684: l_token_tbl Error_Handler.Token_Tbl_Type;

680: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
681: , x_Return_Status OUT NOCOPY VARCHAR2
682: )
683: IS
684: l_token_tbl Error_Handler.Token_Tbl_Type;
685: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
686:
687: CURSOR c_GetComponent IS
688: SELECT revised_item_sequence_id

Line 685: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

681: , x_Return_Status OUT NOCOPY VARCHAR2
682: )
683: IS
684: l_token_tbl Error_Handler.Token_Tbl_Type;
685: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
686:
687: CURSOR c_GetComponent IS
688: SELECT revised_item_sequence_id
689: FROM bom_inventory_components

Line 714: Error_Handler.Add_Error_Token

710: 'SUBSTITUTE_ITEM_NAME';
711: l_token_tbl(3).token_value :=
712: p_sub_component_rec.substitute_component_name;
713:
714: Error_Handler.Add_Error_Token
715: ( p_Message_Name => 'ENG_SBC_REV_ITEM_MISMATCH'
716: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
717: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
718: , p_Token_Tbl => l_Token_Tbl

Line 744: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

740: ****************************************************************************/
741: PROCEDURE Check_Access
742: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
743: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
744: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
745: , x_Return_Status OUT NOCOPY VARCHAR2
746: )
747: IS
748: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 748: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

744: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
745: , x_Return_Status OUT NOCOPY VARCHAR2
746: )
747: IS
748: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
749: l_Token_Tbl Error_Handler.Token_Tbl_Type;
750: l_Return_Status VARCHAR2(1);
751: CURSOR c_GetSubCompType IS
752: SELECT bom_item_type

Line 749: l_Token_Tbl Error_Handler.Token_Tbl_Type;

745: , x_Return_Status OUT NOCOPY VARCHAR2
746: )
747: IS
748: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
749: l_Token_Tbl Error_Handler.Token_Tbl_Type;
750: l_Return_Status VARCHAR2(1);
751: CURSOR c_GetSubCompType IS
752: SELECT bom_item_type
753: FROM mtl_system_items

Line 796: Error_Handler.Add_Error_Token

792: FOR SubCompType IN c_GetSubCompType
793: LOOP
794: IF SubCompType.bom_item_type = Bom_Globals.G_PRODUCT_FAMILY
795: THEN
796: Error_Handler.Add_Error_Token
797: ( p_Message_Name => 'ENG_SUB_COMP_PF'
798: , p_mesg_token_tbl => l_mesg_token_tbl
799: , x_mesg_token_tbl => l_mesg_token_tbl
800: , p_token_tbl => l_token_tbl

Line 830: Error_Handler.Add_Error_Token

826: THEN
827: l_Token_Tbl(2).Token_Value := 'ENG_STANDARD';
828: END IF;
829:
830: Error_Handler.Add_Error_Token
831: ( p_Message_Name => 'ENG_SUB_COMP_ACCESS_DENIED'
832: , p_Mesg_Token_Tbl => l_mesg_token_tbl
833: , x_Mesg_Token_Tbl => l_mesg_token_tbl
834: , p_Token_Tbl => l_token_tbl