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

Line 61: l_return_status := FND_API.G_RET_STS_SUCCESS;

57:
58:
59: BEGIN
60:
61: l_return_status := FND_API.G_RET_STS_SUCCESS;
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63: l_mesg_token_tbl := p_mesg_token_tbl;
64:
65: IF BOM_Rtg_Globals.Get_Debug = 'Y'

Line 62: x_return_status := FND_API.G_RET_STS_SUCCESS;

58:
59: BEGIN
60:
61: l_return_status := FND_API.G_RET_STS_SUCCESS;
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63: l_mesg_token_tbl := p_mesg_token_tbl;
64:
65: IF BOM_Rtg_Globals.Get_Debug = 'Y'
66: THEN Error_Handler.Write_Debug

Line 76: l_common_routing_sequence_id = FND_API.G_MISS_NUM

72: -- If the value is Null, set Common Routing Seq Id.
73: l_common_routing_sequence_id := BOM_Rtg_Globals.Get_Common_Rtg_Seq_id ;
74:
75: IF l_common_routing_sequence_id IS NULL OR
76: l_common_routing_sequence_id = FND_API.G_MISS_NUM
77: THEN
78: BEGIN
79: SELECT common_routing_sequence_id
80: INTO l_common_routing_sequence_id

Line 102: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

98: , x_err_msg => l_err_msg
99: , x_return_status => l_return_status
100: ) ;
101:
102: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
103:
104: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
105: THEN
106: Error_Handler.Add_Error_Token

Line 114: x_return_status := FND_API.G_RET_STS_ERROR ;

110: , x_mesg_token_tbl => x_mesg_token_tbl
111: ) ;
112:
113: END IF;
114: x_return_status := FND_API.G_RET_STS_ERROR ;
115: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND
116: l_err_msg IS NOT NULL THEN
117: Error_Handler.Add_Error_Token
118: (

Line 115: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND

111: ) ;
112:
113: END IF;
114: x_return_status := FND_API.G_RET_STS_ERROR ;
115: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS AND
116: l_err_msg IS NOT NULL THEN
117: Error_Handler.Add_Error_Token
118: (
119: p_message_name => NULL,

Line 198: l_return_status := FND_API.G_RET_STS_ERROR;

194: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
195: , p_message_name => 'BOM_OP_NWK_ALREADY_EXISTS'
196: , p_token_tbl => l_token_tbl
197: );
198: l_return_status := FND_API.G_RET_STS_ERROR;
199: ELSIF l_return_status = BOM_Rtg_Globals.G_RECORD_NOT_FOUND AND
200: p_op_network_rec.transaction_type IN
201: ( BOM_Rtg_Globals.G_OPR_UPDATE, BOM_Rtg_Globals.G_OPR_DELETE)
202: THEN

Line 215: l_return_status := FND_API.G_RET_STS_ERROR;

211: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
212: , p_message_name => 'BOM_OP_NWK_DOESNOT_EXISTS'
213: , p_token_tbl => l_token_tbl
214: );
215: l_return_status := FND_API.G_RET_STS_ERROR;
216: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
217: THEN
218: l_token_tbl(1).token_name := 'FROM_OP_SEQ_NUMBER';
219: l_token_tbl(1).token_value :=

Line 216: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR

212: , p_message_name => 'BOM_OP_NWK_DOESNOT_EXISTS'
213: , p_token_tbl => l_token_tbl
214: );
215: l_return_status := FND_API.G_RET_STS_ERROR;
216: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
217: THEN
218: l_token_tbl(1).token_name := 'FROM_OP_SEQ_NUMBER';
219: l_token_tbl(1).token_value :=
220: p_op_network_rec.from_op_seq_number;

Line 234: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

230: 'operation network'||
231: p_op_network_rec.assembly_item_name
232: , p_token_tbl => l_token_tbl
233: );
234: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS
236: THEN
237: l_return_status := FND_API.G_RET_STS_SUCCESS;
238: END IF;

Line 235: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS

231: p_op_network_rec.assembly_item_name
232: , p_token_tbl => l_token_tbl
233: );
234: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS
236: THEN
237: l_return_status := FND_API.G_RET_STS_SUCCESS;
238: END IF;
239:

Line 237: l_return_status := FND_API.G_RET_STS_SUCCESS;

233: );
234: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS
236: THEN
237: l_return_status := FND_API.G_RET_STS_SUCCESS;
238: END IF;
239:
240: x_return_status := l_return_status;
241: x_mesg_token_tbl := l_mesg_token_tbl;

Line 284: l_return_status := FND_API.G_RET_STS_SUCCESS;

280: WHERE bos.operation_sequence_id = p_op_seq_id ;
281:
282: BEGIN
283:
284: l_return_status := FND_API.G_RET_STS_SUCCESS;
285:
286: IF BOM_Rtg_Globals.Get_Debug = 'Y'
287: THEN Error_Handler.Write_Debug
288: ('Within Operation Network Check Access. . . ');

Line 314: l_cfm_flag = FND_API.G_MISS_NUM

310: '. . . Eam Item Type is ' || to_char(BOM_Rtg_Globals.Get_Eam_Item_Type) ) ;
311: END IF ;
312:
313: IF l_cfm_flag IS NULL OR
314: l_cfm_flag = FND_API.G_MISS_NUM
315: THEN
316: l_cfm_flag := Bom_Rtg_Validate.Get_Flow_Routing_Flag
317: (p_op_network_unexp_rec.routing_sequence_id) ;
318: BOM_Rtg_Globals.Set_CFM_Rtg_Flag(p_cfm_rtg_type => l_cfm_flag) ;

Line 354: l_return_status := FND_API.G_RET_STS_ERROR ;

350: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
351: , p_Token_Tbl => l_Token_Tbl
352: ) ;
353: END IF ;
354: l_return_status := FND_API.G_RET_STS_ERROR ;
355: END IF ;
356:
357: IF NVL(l_nwkop_rec.disable_date , TRUNC(sysdate)+1 )
358: <= TRUNC(sysdate)

Line 369: l_return_status := FND_API.G_RET_STS_ERROR ;

365: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
366: , p_Token_Tbl => l_Token_Tbl
367: ) ;
368: END IF ;
369: l_return_status := FND_API.G_RET_STS_ERROR ;
370: END IF ;
371:
372: END LOOP ;
373:

Line 374: IF l_return_status <> FND_API.G_RET_STS_ERROR

370: END IF ;
371:
372: END LOOP ;
373:
374: IF l_return_status <> FND_API.G_RET_STS_ERROR
375: THEN
376: FOR l_nwkop_rec IN l_nwkop_csr
377: ( p_op_seq_id => NVL( p_op_network_unexp_rec.new_to_op_seq_id
378: , p_op_network_unexp_rec.to_op_seq_id )

Line 391: l_return_status := FND_API.G_RET_STS_ERROR ;

387: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
388: , p_Token_Tbl => l_Token_Tbl
389: ) ;
390: END IF ;
391: l_return_status := FND_API.G_RET_STS_ERROR ;
392: END IF ;
393:
394: IF NVL(l_nwkop_rec.disable_date , TRUNC(sysdate) + 1)
395: <= TRUNC(sysdate)

Line 406: l_return_status := FND_API.G_RET_STS_ERROR ;

402: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
403: , p_Token_Tbl => l_Token_Tbl
404: ) ;
405: END IF ;
406: l_return_status := FND_API.G_RET_STS_ERROR ;
407: END IF ;
408:
409: END LOOP ;
410:

Line 443: l_return_status := FND_API.G_RET_STS_ERROR ;

439: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
440: , p_Token_Tbl => l_Token_Tbl
441: ) ;
442: END IF ;
443: l_return_status := FND_API.G_RET_STS_ERROR ;
444: END IF ;
445:
446: END LOOP ;
447:

Line 449: IF l_return_status <> FND_API.G_RET_STS_ERROR

445:
446: END LOOP ;
447:
448:
449: IF l_return_status <> FND_API.G_RET_STS_ERROR
450: THEN
451: -- Check if the to operation has been disabled
452: FOR l_nwkop_rec IN l_nwkop_csr
453: ( p_op_seq_id => NVL( p_op_network_unexp_rec.new_to_op_seq_id

Line 470: l_return_status := FND_API.G_RET_STS_ERROR ;

466: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
467: , p_Token_Tbl => l_Token_Tbl
468: ) ;
469: END IF ;
470: l_return_status := FND_API.G_RET_STS_ERROR ;
471: END IF ;
472:
473: END LOOP ;
474:

Line 499: l_return_status := FND_API.G_RET_STS_ERROR ;

495: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
496: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
497: , p_Token_Tbl => l_Token_Tbl
498: );
499: l_return_status := FND_API.G_RET_STS_ERROR ;
500:
501: END IF ;
502:
503: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

Line 528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

524: , x_mesg_token_tbl => l_mesg_token_tbl
525: ) ;
526:
527: -- Return the status and message table.
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
529: x_mesg_token_tbl := l_mesg_token_tbl ;
530:
531:
532: END Check_Access ;

Line 563: x_return_status := FND_API.G_RET_STS_SUCCESS;

559: l_cfm_flag NUMBER := NULL ;
560:
561: BEGIN
562:
563: x_return_status := FND_API.G_RET_STS_SUCCESS;
564:
565: IF BOM_Rtg_Globals.Get_Debug = 'Y'
566: THEN Error_Handler.Write_Debug
567: ('Within Operation Network Check Attributes . . . ');

Line 593: IF p_op_network_rec.connection_type = FND_API.G_MISS_NUM

589: ('Operation Attr Validation: Missing Value. . . ' || x_return_status) ;
590: END IF;
591:
592: -- Connection(Transition) Type
593: IF p_op_network_rec.connection_type = FND_API.G_MISS_NUM
594: THEN
595: Error_Handler.Add_Error_Token
596: ( p_Message_Name => 'BOM_OP_NWK_CNTTYPE_MISSING'
597: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 601: x_return_status := FND_API.G_RET_STS_ERROR;

597: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
598: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
599: , p_Token_Tbl => l_Token_Tbl
600: );
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: END IF ;
603:
604:
605: -- Planning Percent

Line 606: IF p_op_network_rec.planning_percent = FND_API.G_MISS_NUM

602: END IF ;
603:
604:
605: -- Planning Percent
606: IF p_op_network_rec.planning_percent = FND_API.G_MISS_NUM
607: THEN
608: Error_Handler.Add_Error_Token
609: ( p_Message_Name => 'BOM_OP_NWK_PLNPCT_MISSING'
610: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 614: x_return_status := FND_API.G_RET_STS_ERROR;

610: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
611: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
612: , p_Token_Tbl => l_Token_Tbl
613: );
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: END IF;
616: END IF ;
617:
618: IF ( p_op_network_rec.From_X_Coordinate <> FND_API.G_MISS_NUM

Line 618: IF ( p_op_network_rec.From_X_Coordinate <> FND_API.G_MISS_NUM

614: x_return_status := FND_API.G_RET_STS_ERROR;
615: END IF;
616: END IF ;
617:
618: IF ( p_op_network_rec.From_X_Coordinate <> FND_API.G_MISS_NUM
619: AND p_op_network_rec.From_X_Coordinate < 0 )
620: OR ( p_op_network_rec.From_Y_Coordinate <> FND_API.G_MISS_NUM
621: AND p_op_network_rec.From_Y_Coordinate < 0 )
622: OR ( p_op_network_rec.To_X_Coordinate <> FND_API.G_MISS_NUM

Line 620: OR ( p_op_network_rec.From_Y_Coordinate <> FND_API.G_MISS_NUM

616: END IF ;
617:
618: IF ( p_op_network_rec.From_X_Coordinate <> FND_API.G_MISS_NUM
619: AND p_op_network_rec.From_X_Coordinate < 0 )
620: OR ( p_op_network_rec.From_Y_Coordinate <> FND_API.G_MISS_NUM
621: AND p_op_network_rec.From_Y_Coordinate < 0 )
622: OR ( p_op_network_rec.To_X_Coordinate <> FND_API.G_MISS_NUM
623: AND p_op_network_rec.To_X_Coordinate < 0 )
624: OR ( p_op_network_rec.To_Y_Coordinate <> FND_API.G_MISS_NUM

Line 622: OR ( p_op_network_rec.To_X_Coordinate <> FND_API.G_MISS_NUM

618: IF ( p_op_network_rec.From_X_Coordinate <> FND_API.G_MISS_NUM
619: AND p_op_network_rec.From_X_Coordinate < 0 )
620: OR ( p_op_network_rec.From_Y_Coordinate <> FND_API.G_MISS_NUM
621: AND p_op_network_rec.From_Y_Coordinate < 0 )
622: OR ( p_op_network_rec.To_X_Coordinate <> FND_API.G_MISS_NUM
623: AND p_op_network_rec.To_X_Coordinate < 0 )
624: OR ( p_op_network_rec.To_Y_Coordinate <> FND_API.G_MISS_NUM
625: AND p_op_network_rec.To_Y_Coordinate < 0 ) THEN
626: Error_Handler.Add_Error_Token

Line 624: OR ( p_op_network_rec.To_Y_Coordinate <> FND_API.G_MISS_NUM

620: OR ( p_op_network_rec.From_Y_Coordinate <> FND_API.G_MISS_NUM
621: AND p_op_network_rec.From_Y_Coordinate < 0 )
622: OR ( p_op_network_rec.To_X_Coordinate <> FND_API.G_MISS_NUM
623: AND p_op_network_rec.To_X_Coordinate < 0 )
624: OR ( p_op_network_rec.To_Y_Coordinate <> FND_API.G_MISS_NUM
625: AND p_op_network_rec.To_Y_Coordinate < 0 ) THEN
626: Error_Handler.Add_Error_Token
627: ( p_message_name => 'BOM_OP_NWK_COORD_NEGATIVE'
628: , p_token_tbl => l_token_tbl

Line 633: x_return_status := FND_API.G_RET_STS_ERROR;

629: , p_mesg_token_tbl => l_mesg_token_tbl
630: , x_mesg_token_tbl => l_mesg_token_tbl
631: );
632:
633: x_return_status := FND_API.G_RET_STS_ERROR;
634:
635: END IF;
636: /*
637: FOR I in 1..p_op_network_tbl.COUNT LOOP

Line 670: x_return_status := FND_API.G_RET_STS_ERROR;

666: , p_mesg_token_tbl => l_mesg_token_tbl
667: , x_mesg_token_tbl => l_mesg_token_tbl
668: );
669:
670: x_return_status := FND_API.G_RET_STS_ERROR;
671:
672: END IF;
673:
674: END LOOP;

Line 680: l_cfm_flag = FND_API.G_MISS_NUM

676: l_cfm_flag := BOM_Rtg_Globals.Get_CFM_Rtg_Flag ;
677:
678:
679: IF l_cfm_flag IS NULL OR
680: l_cfm_flag = FND_API.G_MISS_NUM
681: THEN
682: l_cfm_flag := Bom_Rtg_Validate.Get_Flow_Routing_Flag
683: (p_op_network_unexp_rec.routing_sequence_id) ;
684: BOM_Rtg_Globals.Set_CFM_Rtg_Flag(p_cfm_rtg_type => l_cfm_flag) ;

Line 689: AND p_op_network_rec.connection_type <> FND_API.G_MISS_NUM

685: END IF;
686:
687: IF p_op_network_rec.connection_type NOT IN (1, 2)
688: AND p_op_network_rec.connection_type is NOT NULL
689: AND p_op_network_rec.connection_type <> FND_API.G_MISS_NUM
690: AND l_cfm_flag = BOM_Rtg_Globals.G_LOT_RTG
691: THEN
692: Error_Handler.Add_Error_Token
693: ( p_message_name => 'BOM_OP_NWK_CNTYPE_INVALID'

Line 699: x_return_status := FND_API.G_RET_STS_ERROR;

695: , p_mesg_token_tbl => l_mesg_token_tbl
696: , x_mesg_token_tbl => l_mesg_token_tbl
697: );
698:
699: x_return_status := FND_API.G_RET_STS_ERROR;
700:
701: -- Flow Routing's Network can have connetion type : 3 - Rework
702: ELSIF p_op_network_rec.connection_type NOT IN (1, 2, 3)
703: AND p_op_network_rec.connection_type is NOT NULL

Line 704: AND p_op_network_rec.connection_type <> FND_API.G_MISS_NUM

700:
701: -- Flow Routing's Network can have connetion type : 3 - Rework
702: ELSIF p_op_network_rec.connection_type NOT IN (1, 2, 3)
703: AND p_op_network_rec.connection_type is NOT NULL
704: AND p_op_network_rec.connection_type <> FND_API.G_MISS_NUM
705: AND l_cfm_flag = BOM_Rtg_Globals.G_FLOW_RTG
706: THEN
707:
708: Error_Handler.Add_Error_Token

Line 715: x_return_status := FND_API.G_RET_STS_ERROR;

711: , p_mesg_token_tbl => l_mesg_token_tbl
712: , x_mesg_token_tbl => l_mesg_token_tbl
713: );
714:
715: x_return_status := FND_API.G_RET_STS_ERROR;
716:
717: END IF;
718:
719: IF (p_op_network_rec.planning_percent > 100

Line 722: AND p_op_network_rec.planning_percent <> FND_API.G_MISS_NUM

718:
719: IF (p_op_network_rec.planning_percent > 100
720: OR p_op_network_rec.planning_percent < 0)
721: AND p_op_network_rec.planning_percent IS NOT NULL
722: AND p_op_network_rec.planning_percent <> FND_API.G_MISS_NUM
723: THEN
724:
725: Error_Handler.Add_Error_Token
726: ( p_message_name => 'BOM_OP_NWK_PLNPCT_INVALID'

Line 731: x_return_status := FND_API.G_RET_STS_ERROR;

727: , p_token_tbl => l_token_tbl
728: , p_mesg_token_tbl => l_mesg_token_tbl
729: , x_mesg_token_tbl => l_mesg_token_tbl
730: );
731: x_return_status := FND_API.G_RET_STS_ERROR;
732: END IF;
733:
734: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
735:

Line 754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

750: , x_mesg_token_tbl => l_mesg_token_tbl
751: ) ;
752:
753: -- Return the status and message table.
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
755: x_mesg_token_tbl := l_mesg_token_tbl ;
756:
757:
758: END Check_Attributes;

Line 827: x_return_status := FND_API.G_RET_STS_SUCCESS;

823:
824: BEGIN
825:
826:
827: x_return_status := FND_API.G_RET_STS_SUCCESS;
828:
829: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN
830: Error_Handler.Write_Debug ('Within Operation Network Check Entity1 . . . ');
831: END IF;

Line 866: x_return_status := FND_API.G_RET_STS_ERROR;

862: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
863: , p_message_name => 'BOM_OP_NWK_ALREADY_EXISTS'
864: , p_token_tbl => l_token_tbl
865: );
866: x_return_status := FND_API.G_RET_STS_ERROR;
867:
868: END LOOP ;
869: END IF ;
870:

Line 893: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

889: , x_err_msg => l_err_text
890: , x_return_status => l_return_status
891: ) ;
892:
893: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
894:
895: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
896: THEN
897: Error_Handler.Add_Error_Token

Line 905: x_return_status := FND_API.G_RET_STS_ERROR ;

901: , x_mesg_token_tbl => l_mesg_token_tbl
902: ) ;
903:
904: END IF;
905: x_return_status := FND_API.G_RET_STS_ERROR ;
906: END IF ;
907:
908: -- If operation network is for maintenance routing,
909: -- pass through followings validations.

Line 926: OR p_op_network_rec.planning_percent = FND_API.G_MISS_NUM

922: -- Merge step 12 into this procedure
923: -- Check conditionally required attributes
924: --
925: IF p_op_network_rec.planning_percent IS NULL
926: OR p_op_network_rec.planning_percent = FND_API.G_MISS_NUM
927: THEN
928:
929: Error_Handler.Add_Error_Token
930: ( p_message_name => 'BOM_OP_NWK_PLNPCT_REQUIRED'

Line 935: x_return_status := FND_API.G_RET_STS_ERROR;

931: , p_token_tbl => l_token_tbl
932: , p_mesg_token_tbl => l_mesg_token_tbl
933: , x_mesg_token_tbl => l_mesg_token_tbl
934: );
935: x_return_status := FND_API.G_RET_STS_ERROR;
936: END IF;
937:
938: --
939: -- If connection type =1, there must be only one primary from operation. --

Line 962: x_return_status := FND_API.G_RET_STS_ERROR;

958: , p_token_tbl => l_token_tbl
959: , p_mesg_token_tbl => l_mesg_token_tbl
960: , x_mesg_token_tbl => l_mesg_token_tbl
961: );
962: x_return_status := FND_API.G_RET_STS_ERROR;
963:
964: ELSIF p_op_network_rec.operation_type = 2
965: THEN
966:

Line 973: x_return_status := FND_API.G_RET_STS_ERROR;

969: , p_token_tbl => l_token_tbl
970: , p_mesg_token_tbl => l_mesg_token_tbl
971: , x_mesg_token_tbl => l_mesg_token_tbl
972: );
973: x_return_status := FND_API.G_RET_STS_ERROR;
974: ELSIF p_op_network_rec.operation_type = 3
975: THEN
976:
977: Error_Handler.Add_Error_Token

Line 983: x_return_status := FND_API.G_RET_STS_ERROR;

979: , p_token_tbl => l_token_tbl
980: , p_mesg_token_tbl => l_mesg_token_tbl
981: , x_mesg_token_tbl => l_mesg_token_tbl
982: );
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: END IF;
985:
986: END LOOP;
987: END IF;

Line 1047: x_return_status := FND_API.G_RET_STS_ERROR;

1043: , p_token_tbl => l_token_tbl
1044: , p_mesg_token_tbl => l_mesg_token_tbl
1045: , x_mesg_token_tbl => l_mesg_token_tbl
1046: );
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048: ELSIF p_op_network_rec.operation_type = 3
1049: THEN
1050: Error_Handler.Add_Error_Token
1051: ( p_message_name => 'BOM_OP_NWK_LO_PLNLPCT_INVALID'

Line 1056: x_return_status := FND_API.G_RET_STS_ERROR;

1052: , p_token_tbl => l_token_tbl
1053: , p_mesg_token_tbl=> l_mesg_token_tbl
1054: , x_mesg_token_tbl=> l_mesg_token_tbl
1055: );
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057: END IF;
1058:
1059: END IF;
1060: END IF;

Line 1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1101: , x_mesg_token_tbl => l_mesg_token_tbl
1102: ) ;
1103:
1104: -- Return the status and message table.
1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1106: x_mesg_token_tbl := l_mesg_token_tbl ;
1107:
1108:
1109: END Check_Entity1;

Line 1147: x_return_status := FND_API.G_RET_STS_SUCCESS;

1143:
1144: BEGIN
1145:
1146:
1147: x_return_status := FND_API.G_RET_STS_SUCCESS;
1148:
1149: IF BOM_Rtg_Globals.Get_Debug = 'Y'
1150: THEN Error_Handler.Write_Debug
1151: ('Within operation network entity level check2 . . . ');

Line 1219: x_return_status := FND_API.G_RET_STS_ERROR;

1215: , p_token_tbl => l_token_tbl
1216: , p_mesg_token_tbl => l_mesg_token_tbl
1217: , x_mesg_token_tbl => l_mesg_token_tbl
1218: );
1219: x_return_status := FND_API.G_RET_STS_ERROR;
1220: ELSIF p_op_network_rec.operation_type = 3
1221: THEN
1222: Error_Handler.Add_Error_Token
1223: ( p_message_name => 'BOM_OP_NWK_LO_PLNLPCT_INVALID'

Line 1228: x_return_status := FND_API.G_RET_STS_ERROR;

1224: , p_token_tbl => l_token_tbl
1225: , p_mesg_token_tbl=> l_mesg_token_tbl
1226: , x_mesg_token_tbl=> l_mesg_token_tbl
1227: );
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: END IF;
1230:
1231: l_token_tbl(2).token_name := 'TO_OP_SEQ_NUMBER';
1232: l_token_tbl(2).token_value :=

Line 1278: x_return_status := FND_API.G_RET_STS_ERROR;

1274: , p_token_tbl => l_token_tbl
1275: , p_mesg_token_tbl => l_mesg_token_tbl
1276: , x_mesg_token_tbl => l_mesg_token_tbl
1277: );
1278: x_return_status := FND_API.G_RET_STS_ERROR;
1279: ELSIF UPPER( RTRIM(x_message) ) =
1280: UPPER('A broken link exists in this routing Network.')
1281: THEN
1282:

Line 1290: x_return_status := FND_API.G_RET_STS_ERROR;

1286: , p_mesg_token_tbl => l_mesg_token_tbl
1287: , x_mesg_token_tbl => l_mesg_token_tbl
1288: );
1289:
1290: x_return_status := FND_API.G_RET_STS_ERROR;
1291: ELSE
1292:
1293: Error_Handler.Add_Error_Token
1294: ( p_message_name => 'BOM_OP_NWK_VLDN_ERROR'

Line 1300: x_return_status := FND_API.G_RET_STS_ERROR;

1296: , p_mesg_token_tbl => l_mesg_token_tbl
1297: , x_mesg_token_tbl => l_mesg_token_tbl
1298: );
1299:
1300: x_return_status := FND_API.G_RET_STS_ERROR;
1301: END IF;
1302: END IF;
1303: */
1304: -- For eAM enhancement

Line 1320: IF x_status = FND_API.G_RET_STS_ERROR THEN

1316: , x_mesg_token_tbl => l_mesg_token_tbl
1317: , x_return_status => x_status
1318: ) ;
1319:
1320: IF x_status = FND_API.G_RET_STS_ERROR THEN
1321: x_return_status := FND_API.G_RET_STS_ERROR;
1322: END IF ;
1323:
1324:

Line 1321: x_return_status := FND_API.G_RET_STS_ERROR;

1317: , x_return_status => x_status
1318: ) ;
1319:
1320: IF x_status = FND_API.G_RET_STS_ERROR THEN
1321: x_return_status := FND_API.G_RET_STS_ERROR;
1322: END IF ;
1323:
1324:
1325: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN

Line 1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1350: , x_mesg_token_tbl => l_mesg_token_tbl
1351: ) ;
1352:
1353: -- Return the status and message table.
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1355: x_mesg_token_tbl := l_mesg_token_tbl ;
1356:
1357:
1358: END Check_Entity2;

Line 1397: x_return_status := FND_API.G_RET_STS_SUCCESS;

1393: err_msg VARCHAR2(2000);
1394: l_token_tbl Error_Handler.Token_Tbl_Type;
1395: x_success NUMBER:=0;
1396: BEGIN
1397: x_return_status := FND_API.G_RET_STS_SUCCESS;
1398:
1399: select routing_sequence_id, cfm_routing_flag
1400: into l_routing_sequence_id,l_cfm_routing_flag
1401: from bom_operational_routings where

Line 1408: l_common_routing_sequence_id = FND_API.G_MISS_NUM THEN

1404: -- Get Common Routing Seq Id from System Info Rec.
1405: -- If the value is Null, set Common Routing Seq Id.
1406: l_common_routing_sequence_id := BOM_Rtg_Globals.Get_Common_Rtg_Seq_id ;
1407: IF l_common_routing_sequence_id IS NULL OR
1408: l_common_routing_sequence_id = FND_API.G_MISS_NUM THEN
1409: BEGIN
1410: SELECT common_routing_sequence_id
1411: INTO l_common_routing_sequence_id
1412: FROM bom_operational_routings

Line 1439: x_return_status := FND_API.G_RET_STS_ERROR ;

1435: , x_mesg_token_tbl => l_mesg_token_tbl
1436: ) ;
1437:
1438: END IF;
1439: x_return_status := FND_API.G_RET_STS_ERROR ;
1440: x_mesg_token_tbl := l_mesg_token_tbl ; --for bug 3134027
1441:
1442: RETURN;
1443: END IF;

Line 1462: x_return_status := FND_API.G_RET_STS_ERROR ;

1458: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
1459: , p_token_tbl => l_token_tbl
1460: ) ;
1461: END IF ;
1462: x_return_status := FND_API.G_RET_STS_ERROR ;
1463: x_mesg_token_tbl := l_mesg_token_tbl ; --for bug 3134027
1464:
1465: RETURN;
1466: END IF;

Line 1491: x_return_status := FND_API.G_RET_STS_ERROR ;

1487: , x_mesg_token_tbl => l_mesg_token_tbl
1488: ) ;
1489:
1490: END IF;
1491: x_return_status := FND_API.G_RET_STS_ERROR ;
1492: x_mesg_token_tbl := l_mesg_token_tbl ; --for bug 3134027
1493:
1494: RETURN;
1495: END IF;

Line 1513: x_return_status := FND_API.G_RET_STS_ERROR ;

1509: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
1510: , p_token_tbl => l_token_tbl
1511: ) ;
1512: END IF ;
1513: x_return_status := FND_API.G_RET_STS_ERROR ;
1514: x_mesg_token_tbl := l_mesg_token_tbl ; --for bug 3134027
1515:
1516: RETURN;
1517: END IF;

Line 1541: x_return_status := FND_API.G_RET_STS_ERROR ;

1537: , p_mesg_token_tbl => l_mesg_token_tbl
1538: , x_mesg_token_tbl => l_mesg_token_tbl
1539: ) ;
1540: END IF;
1541: x_return_status := FND_API.G_RET_STS_ERROR ;
1542: x_mesg_token_tbl := l_mesg_token_tbl ; --for bug 3134027
1543:
1544: RETURN ;
1545:

Line 1565: x_return_status := FND_API.G_RET_STS_ERROR ;

1561: , p_mesg_token_tbl => l_mesg_token_tbl
1562: , x_mesg_token_tbl => l_mesg_token_tbl
1563: ) ;
1564: END IF;
1565: x_return_status := FND_API.G_RET_STS_ERROR ;
1566: x_mesg_token_tbl := l_mesg_token_tbl ; --for bug 3134027
1567:
1568: RETURN ;
1569: END IF;