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

Line 111: l_return_status := FND_API.G_RET_STS_ERROR;

107: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
108: , p_message_name => 'BOM_ASSY_ITEM_ALREADY_EXISTS'
109: , p_token_tbl => l_token_tbl
110: );
111: l_return_status := FND_API.G_RET_STS_ERROR;
112: ELSIF l_return_status = BOM_Globals.G_RECORD_NOT_FOUND AND
113: p_bom_header_rec.transaction_type IN
114: (BOM_Globals.G_OPR_UPDATE, BOM_Globals.G_OPR_DELETE)
115: THEN

Line 125: l_return_status := FND_API.G_RET_STS_ERROR;

121: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
122: , p_message_name => 'BOM_ASSY_ITEM_DOESNOT_EXISTS'
123: , p_token_tbl => l_token_tbl
124: );
125: l_return_status := FND_API.G_RET_STS_ERROR;
126: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
127: THEN
128: Error_Handler.Add_Error_Token
129: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl

Line 126: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR

122: , p_message_name => 'BOM_ASSY_ITEM_DOESNOT_EXISTS'
123: , p_token_tbl => l_token_tbl
124: );
125: l_return_status := FND_API.G_RET_STS_ERROR;
126: ELSIF l_Return_status = FND_API.G_RET_STS_UNEXP_ERROR
127: THEN
128: Error_Handler.Add_Error_Token
129: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
130: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 138: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

134: 'Assembly item '||
135: p_bom_header_rec.assembly_item_name
136: , p_token_tbl => l_token_tbl
137: );
138: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: ELSE
140:
141: /* Assign the relevant transaction type for SYNC operations */
142:

Line 152: l_return_status := FND_API.G_RET_STS_SUCCESS;

148: x_old_bom_header_rec.transaction_type :=
149: Bom_Globals.G_OPR_CREATE;
150: END IF;
151: END IF;
152: l_return_status := FND_API.G_RET_STS_SUCCESS;
153:
154: END IF;
155:
156: x_return_status := l_return_status;

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

180: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
181: , x_return_status IN OUT NOCOPY VARCHAR2
182: )
183: IS
184: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
185: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type :=
186: p_mesg_token_tbl;
187: l_bom_item_type NUMBER;
188: l_assembly_type NUMBER;

Line 219: l_return_status := FND_API.G_RET_STS_ERROR;

215: ( p_Message_name => 'BOM_ASSEMBLY_TYPE_ENG'
216: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
217: , x_mesg_token_tbl => l_mesg_token_tbl
218: );
219: l_return_status := FND_API.G_RET_STS_ERROR;
220: END IF;*/
221:
222: /* Validations for OPM Convergence Project
223: Model/Option class bills are not allowed in OPM organizations*/

Line 231: l_return_status := FND_API.G_RET_STS_ERROR;

227: ( p_Message_name => 'BOM_OPM_ORG_MODEL_OC'
228: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
229: , x_mesg_token_tbl => l_mesg_token_tbl
230: );
231: l_return_status := FND_API.G_RET_STS_ERROR;
232: END IF;
233:
234: /* Validations for OPM Convergence Project
235: Dual UOM controlled items should not be allowed*/

Line 243: l_return_status := FND_API.G_RET_STS_ERROR;

239: ( p_Message_name => 'BOM_DUAL_UOM_ITEMS'
240: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
241: , x_mesg_token_tbl => l_mesg_token_tbl
242: );
243: l_return_status := FND_API.G_RET_STS_ERROR;
244: END IF;
245:
246:
247: IF BOM_Globals.Get_STD_Item_Access IS NULL AND

Line 328: l_return_status := FND_API.G_RET_STS_ERROR;

324: , p_Mesg_Token_Tbl => l_mesg_token_tbl
325: , x_Mesg_Token_Tbl => l_mesg_token_tbl
326: , p_Token_Tbl => l_token_tbl
327: );
328: l_return_status := FND_API.G_RET_STS_ERROR;
329: END IF;
330:
331: x_return_status := l_return_status;
332: x_mesg_token_tbl := l_mesg_token_tbl;

Line 365: x_return_status := FND_API.G_RET_STS_SUCCESS;

361: l_Token_Tbl Error_Handler.Token_Tbl_Type;
362:
363: BEGIN
364:
365: x_return_status := FND_API.G_RET_STS_SUCCESS;
366:
367: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Within Bom Header Check Attributes . . . '); END IF;
368:
369: IF p_bom_header_rec.alternate_bom_code IS NOT NULL AND

Line 370: p_bom_header_rec.alternate_bom_code <> FND_API.G_MISS_CHAR

366:
367: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Within Bom Header Check Attributes . . . '); END IF;
368:
369: IF p_bom_header_rec.alternate_bom_code IS NOT NULL AND
370: p_bom_header_rec.alternate_bom_code <> FND_API.G_MISS_CHAR
371: AND
372: ( p_bom_header_rec.alternate_bom_code <>
373: p_old_bom_header_rec.alternate_bom_code OR
374: p_old_bom_header_rec.alternate_bom_code IS NULL

Line 395: x_return_status := FND_API.G_RET_STS_ERROR;

391: 'BOM_ALTERNATE_DESG_INVALID'
392: , p_mesg_token_tbl => l_mesg_token_tbl
393: , x_mesg_token_tbl => l_mesg_token_tbl
394: );
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: END IF;
397: END IF;
398:
399: IF p_bom_header_rec.assembly_type IS NOT NULL AND

Line 400: p_bom_header_rec.assembly_type <> FND_API.G_MISS_NUM AND

396: END IF;
397: END IF;
398:
399: IF p_bom_header_rec.assembly_type IS NOT NULL AND
400: p_bom_header_rec.assembly_type <> FND_API.G_MISS_NUM AND
401: p_bom_header_rec.assembly_type NOT IN (1,2)
402: THEN
403: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
404: l_token_tbl(1).token_value :=

Line 415: x_return_status := FND_API.G_RET_STS_ERROR;

411: , p_token_tbl => l_token_tbl
412: , p_mesg_token_tbl => l_mesg_token_tbl
413: , x_mesg_token_tbl => l_mesg_token_tbl
414: );
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: END IF;
417:
418: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
419:

Line 438: x_return_status := FND_API.G_RET_STS_SUCCESS;

434: IS
435: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
436: l_Token_Tbl Error_Handler.Token_Tbl_Type;
437: BEGIN
438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439:
440: IF ( p_bom_header_rec.common_organization_code IS NOT NULL AND
441: p_bom_header_rec.common_organization_code <>
442: FND_API.G_MISS_CHAR

Line 442: FND_API.G_MISS_CHAR

438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439:
440: IF ( p_bom_header_rec.common_organization_code IS NOT NULL AND
441: p_bom_header_rec.common_organization_code <>
442: FND_API.G_MISS_CHAR
443: ) AND
444: ( p_bom_header_rec.common_assembly_item_name IS NULL OR
445: p_bom_header_rec.common_assembly_item_name =
446: FND_API.G_MISS_CHAR

Line 446: FND_API.G_MISS_CHAR

442: FND_API.G_MISS_CHAR
443: ) AND
444: ( p_bom_header_rec.common_assembly_item_name IS NULL OR
445: p_bom_header_rec.common_assembly_item_name =
446: FND_API.G_MISS_CHAR
447: )
448: THEN
449: --
450: -- If the common org code is given the common assembly

Line 464: x_return_status := FND_API.G_RET_STS_ERROR;

460: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
461: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
462: );
463:
464: x_return_status := FND_API.G_RET_STS_ERROR;
465: END IF;
466:
467: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
468:

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

491: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
492: , x_return_status IN OUT NOCOPY VARCHAR2
493: )
494: IS
495: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
496: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
497: l_Token_Tbl Error_Handler.Token_Tbl_Type;
498: l_dummy VARCHAR2(1);
499: l_valid_op_seq VARCHAR2(1);

Line 555: l_return_status := FND_API.G_RET_STS_ERROR;

551: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
552: , p_token_tbl => g_token_tbl
553: );
554:
555: l_return_status := FND_API.G_RET_STS_ERROR;
556:
557: END IF;
558:
559: --

Line 565: l_return_status := FND_API.G_RET_STS_ERROR;

561: -- Verify that engineering bill is created for engineering assy
562: -- and manufacturing bill is created for manufacturing assy
563: --
564: IF l_dummy IS NOT NULL THEN
565: l_return_status := FND_API.G_RET_STS_ERROR;
566: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
567: l_token_tbl(1).token_value := p_bom_header_rec.assembly_item_name;
568: IF l_dummy = 'E' THEN
569: Error_Handler.Add_Error_Token

Line 602: l_return_status := FND_API.G_RET_STS_ERROR;

598: ( p_message_name => 'BOM_CREATE_PACK_HIER_NOT_ALLOW'
599: , p_mesg_token_tbl => l_Mesg_Token_Tbl
600: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
601: );
602: l_return_status := FND_API.G_RET_STS_ERROR;
603: END IF;
604:
605: ---
606: -- Packaging BOM creation is allowed only with the prefered structure name for the

Line 625: l_return_status := FND_API.G_RET_STS_ERROR;

621: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
622: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
623: , p_Token_Tbl => l_token_tbl
624: );
625: l_return_status := FND_API.G_RET_STS_ERROR;
626: END IF;
627:
628: ---
629: -- Do not allow packaging hierarchies to be created in child orgs.

Line 643: l_return_status := FND_API.G_RET_STS_ERROR;

639: ( p_message_name => 'BOM_PKG_HIERARCHY_IN_CHILD_ORG'
640: , p_mesg_token_tbl => l_Mesg_Token_Tbl
641: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
642: );
643: l_return_status := FND_API.G_RET_STS_ERROR;
644: END IF;
645: END IF;
646: END IF;
647:

Line 654: p_bom_header_rec.alternate_bom_code <> FND_API.G_MISS_CHAR

650: -- If alternate designator is NOT NULL, then Primary Bill
651: -- must exist if the user is trying to create an Alternate
652: --
653: IF p_bom_header_rec.alternate_bom_code IS NOT NULL AND
654: p_bom_header_rec.alternate_bom_code <> FND_API.G_MISS_CHAR
655: THEN
656: BEGIN
657: SELECT '1'
658: INTO l_dummy

Line 673: FND_API.G_RET_STS_ERROR;

669:
670: EXCEPTION
671: WHEN NO_DATA_FOUND THEN
672: l_return_status :=
673: FND_API.G_RET_STS_ERROR;
674: l_token_tbl(1).token_name :=
675: 'ASSEMBLY_ITEM_NAME';
676: l_token_tbl(1).token_value :=
677: p_bom_header_rec.assembly_item_name;

Line 689: --The value of structure type in the case of null or FND_API.MISS_CHAR

685: END;
686: END IF;
687:
688: --validate structure type
689: --The value of structure type in the case of null or FND_API.MISS_CHAR
690: --will be ignored.
691:
692: IF ( p_bom_header_rec.alternate_bom_code IS NOT NULL
693: AND p_bom_header_rec.alternate_bom_code <> FND_API.G_MISS_CHAR

Line 693: AND p_bom_header_rec.alternate_bom_code <> FND_API.G_MISS_CHAR

689: --The value of structure type in the case of null or FND_API.MISS_CHAR
690: --will be ignored.
691:
692: IF ( p_bom_header_rec.alternate_bom_code IS NOT NULL
693: AND p_bom_header_rec.alternate_bom_code <> FND_API.G_MISS_CHAR
694: AND p_bom_head_unexp_rec.structure_type_id IS NOT NULL
695: AND p_bom_head_unexp_rec.structure_type_id <> FND_API.G_MISS_NUM )
696: THEN
697: SELECT COUNT(1)

Line 695: AND p_bom_head_unexp_rec.structure_type_id <> FND_API.G_MISS_NUM )

691:
692: IF ( p_bom_header_rec.alternate_bom_code IS NOT NULL
693: AND p_bom_header_rec.alternate_bom_code <> FND_API.G_MISS_CHAR
694: AND p_bom_head_unexp_rec.structure_type_id IS NOT NULL
695: AND p_bom_head_unexp_rec.structure_type_id <> FND_API.G_MISS_NUM )
696: THEN
697: SELECT COUNT(1)
698: INTO l_count
699: FROM BOM_ALTERNATE_DESIGNATORS BAD

Line 711: l_return_status := FND_API.G_RET_STS_ERROR;

707: CONNECT BY PRIOR BST.PARENT_STRUCTURE_TYPE_ID = BST.STRUCTURE_TYPE_ID
708: );
709:
710: IF ( l_count = 0 ) THEN
711: l_return_status := FND_API.G_RET_STS_ERROR;
712:
713: l_token_tbl(1).token_name := 'STRUCTURE_NAME';
714: l_token_tbl(1).token_value := p_bom_header_rec.alternate_bom_code;
715: l_token_tbl(2).token_name := 'STRUCTURE_TYPE';

Line 730: AND p_bom_head_unexp_rec.structure_type_id <> FND_API.G_MISS_NUM

726:
727: -- In update case, the new structure type must be a child of the existing one
728: IF ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
729: AND p_bom_head_unexp_rec.structure_type_id IS NOT NULL
730: AND p_bom_head_unexp_rec.structure_type_id <> FND_API.G_MISS_NUM
731: AND p_bom_head_unexp_rec.structure_type_id <> p_old_bom_head_unexp_rec.structure_type_id )
732: THEN
733: SELECT COUNT(1)
734: INTO l_count

Line 741: l_return_status := FND_API.G_RET_STS_ERROR;

737: START WITH BST.STRUCTURE_TYPE_ID = p_old_bom_head_unexp_rec.structure_type_id
738: CONNECT BY PRIOR BST.STRUCTURE_TYPE_ID = BST.PARENT_STRUCTURE_TYPE_ID;
739:
740: IF ( l_count = 0 ) THEN
741: l_return_status := FND_API.G_RET_STS_ERROR;
742:
743: --existing structure type is not populated in the BO record
744: l_token_tbl(1).token_name := 'OLD_STRTYPE';
745: BEGIN

Line 807: FND_API.G_MISS_CHAR

803: IF p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
804: AND
805: ( ( p_bom_header_rec.common_organization_code IS NOT NULL
806: AND p_bom_header_rec.common_organization_code <>
807: FND_API.G_MISS_CHAR
808: AND NVL(p_bom_header_rec.common_organization_code, 'XXX') <>
809: NVL(p_old_bom_head_rec.common_organization_code,'XXX')
810: )
811: OR

Line 814: FND_API.G_MISS_CHAR

810: )
811: OR
812: ( p_bom_header_rec.common_assembly_item_name IS NOT NULL
813: AND p_bom_header_rec.common_assembly_item_name <>
814: FND_API.G_MISS_CHAR
815: AND NVL(p_bom_header_rec.common_assembly_item_name, 'NONE') <>
816: NVL(p_old_bom_head_rec.common_assembly_item_name, 'NONE')
817: )
818: )

Line 831: l_return_status := FND_API.G_RET_STS_ERROR;

827: , p_token_tbl => l_token_tbl
828: , p_mesg_token_tbl => l_mesg_token_tbl
829: , x_mesg_token_tbl => l_mesg_token_tbl
830: );
831: l_return_status := FND_API.G_RET_STS_ERROR;
832: END IF;
833:
834: --
835: -- If the user is trying to perform an update, and the bill is

Line 858: l_return_status := FND_API.G_RET_STS_ERROR;

854: , p_token_tbl => l_token_tbl
855: , p_mesg_token_tbl => l_mesg_token_tbl
856: , x_mesg_token_tbl => l_mesg_token_tbl
857: );
858: l_return_status := FND_API.G_RET_STS_ERROR;
859: END IF;
860:
861: END LOOP; */
862: --

Line 872: FND_API.G_MISS_NUM

868: -- Using the common bill sequence_id check if the record for the
869: -- common bill has a common bill sequence id.
870: IF p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
871: p_bom_head_unexp_rec.source_bill_sequence_id <>
872: FND_API.G_MISS_NUM
873: THEN
874: BEGIN
875: SELECT '1'
876: INTO l_dummy

Line 897: l_return_status := FND_API.G_RET_STS_ERROR;

893: , p_token_tbl => l_token_tbl
894: , p_mesg_token_tbl => l_mesg_token_tbl
895: , x_mesg_token_tbl => l_mesg_token_tbl
896: );
897: l_return_status := FND_API.G_RET_STS_ERROR;
898:
899: EXCEPTION
900: WHEN NO_DATA_FOUND THEN
901: NULL;

Line 943: l_return_status := FND_API.G_RET_STS_ERROR;

939: , p_token_tbl => l_token_tbl
940: , p_mesg_token_tbl => l_mesg_token_tbl
941: , x_mesg_token_tbl => l_mesg_token_tbl
942: );
943: l_return_status := FND_API.G_RET_STS_ERROR;
944: END;
945: END IF;
946:
947: IF p_bom_header_Rec.ENABLE_ATTRS_UPDATE = 'Y'

Line 956: IF l_valid_op_seq = FND_API.G_RET_STS_ERROR

952: , p_assembly_item_id => p_bom_head_unexp_rec.assembly_item_id
953: , p_organization_id => p_bom_head_unexp_rec.organization_id
954: , p_alt_desg => p_bom_header_rec.alternate_bom_code
955: , x_Return_Status => l_valid_op_seq);
956: IF l_valid_op_seq = FND_API.G_RET_STS_ERROR
957: THEN
958: --BOM_COMMON_OPN_INVALID
959: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
960: l_token_tbl(1).token_value := p_bom_header_rec.assembly_item_name;

Line 977: l_return_status := FND_API.G_RET_STS_ERROR;

973: , p_token_tbl => l_token_tbl
974: , p_mesg_token_tbl => l_mesg_token_tbl
975: , x_mesg_token_tbl => l_mesg_token_tbl
976: );
977: l_return_status := FND_API.G_RET_STS_ERROR;
978: END IF;
979: END IF;
980:
981:

Line 988: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND

984: -- Validation for inter-org common
985: --
986: IF ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE AND
987: p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
988: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND
989: p_old_bom_head_unexp_rec.source_bill_sequence_id IS NULL AND
990: p_old_bom_head_unexp_rec.organization_id <>
991: p_bom_head_unexp_rec.common_organization_id
992: )

Line 996: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND

992: )
993: OR
994: ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND
995: p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
996: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND
997: p_bom_head_unexp_rec.common_organization_id <>
998: p_bom_head_unexp_rec.organization_id
999: )
1000: THEN

Line 1039: l_return_status := FND_API.G_RET_STS_ERROR;

1035: , p_mesg_token_tbl => l_mesg_token_tbl
1036: , x_mesg_token_tbl => l_mesg_token_tbl
1037: );
1038:
1039: l_return_status := FND_API.G_RET_STS_ERROR;
1040: END; -- if master org same ends
1041:
1042: -- Add operation sequence number validation here
1043: --call bompcmbm.validate_operation_sequence_id

Line 1049: IF l_valid_op_seq = FND_API.G_RET_STS_UNEXP_ERROR

1045: , p_assembly_item_id => p_bom_head_unexp_rec.assembly_item_id
1046: , p_organization_id => p_bom_head_unexp_rec.organization_id
1047: , p_alt_desg => p_bom_header_rec.alternate_bom_code
1048: , x_Return_Status => l_valid_op_seq);
1049: IF l_valid_op_seq = FND_API.G_RET_STS_UNEXP_ERROR
1050: THEN
1051: --BOM_COMMON_OPN_INVALID
1052: l_token_tbl(1).token_name := 'ALT_DESG';
1053: l_token_tbl(1).token_value := p_bom_header_rec.alternate_bom_code;

Line 1068: l_return_status := FND_API.G_RET_STS_ERROR;

1064: , p_token_tbl => l_token_tbl
1065: , p_mesg_token_tbl => l_mesg_token_tbl
1066: , x_mesg_token_tbl => l_mesg_token_tbl
1067: );
1068: l_return_status := FND_API.G_RET_STS_ERROR;
1069: END IF;*/
1070:
1071: -- If the current bom and the bom being referenced as common are not in the
1072: -- same org, then make sure that the components of the parent BOM exist in

Line 1191: l_return_status := FND_API.G_RET_STS_ERROR;

1187: , p_mesg_token_tbl => l_mesg_token_tbl
1188: , x_mesg_token_tbl => l_mesg_token_tbl
1189: );
1190:
1191: l_return_status := FND_API.G_RET_STS_ERROR;
1192: END IF;
1193: END;
1194:
1195: --If the source bom comtains fixed rev components, make sure the same revisions exist in the

Line 1201: IF l_comp_rev_status <> FND_API.G_RET_STS_SUCCESS --Bug 7526867

1197: BOMPCMBM.check_comp_rev_in_local_org(p_src_bill_seq_id => p_bom_head_unexp_rec.source_bill_sequence_id,
1198: p_org_id => p_bom_head_unexp_rec.organization_id,
1199: x_return_status => l_comp_rev_status); --Bug 7526867
1200:
1201: IF l_comp_rev_status <> FND_API.G_RET_STS_SUCCESS --Bug 7526867
1202: THEN
1203:
1204: l_token_tbl.DELETE;
1205: l_token_tbl(1).token_name := 'ASSY_ITEM';

Line 1217: l_return_status := FND_API.G_RET_STS_ERROR; --Bug 7526867

1213: , p_mesg_token_tbl => l_mesg_token_tbl
1214: , x_mesg_token_tbl => l_mesg_token_tbl
1215: );
1216:
1217: l_return_status := FND_API.G_RET_STS_ERROR; --Bug 7526867
1218:
1219: END IF;
1220:
1221: --

Line 1316: l_return_status := FND_API.G_RET_STS_ERROR;

1312: , p_mesg_token_tbl => l_mesg_token_tbl
1313: , x_mesg_token_tbl => l_mesg_token_tbl
1314: );
1315:
1316: l_return_status := FND_API.G_RET_STS_ERROR;
1317:
1318: END IF;
1319: END; -- Check if all the substitutes exist ends
1320: END IF; -- User creating a common or updating the common info Ends

Line 1326: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND

1322: /* BOM ER 9904085 */
1323: --begin
1324: IF ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE AND
1325: p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
1326: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND
1327: p_old_bom_head_unexp_rec.source_bill_sequence_id IS NULL AND
1328: p_old_bom_head_unexp_rec.organization_id =
1329: p_bom_head_unexp_rec.common_organization_id
1330: )

Line 1334: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND

1330: )
1331: OR
1332: ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND
1333: p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
1334: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND
1335: p_bom_head_unexp_rec.common_organization_id =
1336: p_bom_head_unexp_rec.organization_id
1337: )
1338: THEN

Line 1415: l_return_status := FND_API.G_RET_STS_ERROR;

1411: , p_mesg_token_tbl => l_mesg_token_tbl
1412: , x_mesg_token_tbl => l_mesg_token_tbl
1413: );
1414:
1415: l_return_status := FND_API.G_RET_STS_ERROR;
1416: END IF;
1417: END;
1418:
1419:

Line 1476: l_return_status := FND_API.G_RET_STS_ERROR;

1472: , p_mesg_token_tbl => l_mesg_token_tbl
1473: , x_mesg_token_tbl => l_mesg_token_tbl
1474: );
1475:
1476: l_return_status := FND_API.G_RET_STS_ERROR;
1477:
1478: END IF;
1479: END; -- Check if all the substitutes exist ends
1480: END IF; -- User creating a common or updating the common info Ends

Line 1491: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND

1487: -- Common item must have bom_enabled_flag = 'Y'
1488: --
1489: IF ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE AND
1490: p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
1491: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND
1492: p_old_bom_head_unexp_rec.source_bill_sequence_id IS NULL
1493: )
1494: OR
1495: ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND

Line 1497: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM

1493: )
1494: OR
1495: ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND
1496: p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
1497: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM
1498: )
1499: THEN
1500: BEGIN
1501: SELECT 1

Line 1518: l_return_status := FND_API.G_RET_STS_ERROR;

1514: AND msi1.effectivity_control = msi2.effectivity_control;
1515: --Commoning should happen within the eff ctrl.
1516: EXCEPTION
1517: WHEN no_data_found THEN
1518: l_return_status := FND_API.G_RET_STS_ERROR;
1519: l_token_tbl.DELETE;
1520: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
1521: l_token_tbl(1).token_value := p_bom_header_rec.assembly_item_name;
1522: l_token_tbl(2).token_name := 'COMMON_ORG_CODE';

Line 1564: x_return_status := FND_API.G_RET_STS_SUCCESS;

1560: WHERE delete_group_name = p_bom_header_rec.Delete_Group_Name
1561: AND organization_id = p_bom_head_Unexp_Rec.organization_id;
1562:
1563: BEGIN
1564: x_return_status := FND_API.G_RET_STS_SUCCESS;
1565: x_bom_head_unexp_rec := p_bom_head_unexp_rec;
1566:
1567: IF p_bom_header_rec.Delete_Group_Name IS NULL OR
1568: p_bom_header_rec.Delete_Group_Name = FND_API.G_MISS_CHAR

Line 1568: p_bom_header_rec.Delete_Group_Name = FND_API.G_MISS_CHAR

1564: x_return_status := FND_API.G_RET_STS_SUCCESS;
1565: x_bom_head_unexp_rec := p_bom_head_unexp_rec;
1566:
1567: IF p_bom_header_rec.Delete_Group_Name IS NULL OR
1568: p_bom_header_rec.Delete_Group_Name = FND_API.G_MISS_CHAR
1569: THEN
1570: Error_Handler.Add_Error_Token
1571: ( p_message_name => 'BOM_DG_NAME_MISSING'
1572: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1575: x_return_status := FND_API.G_RET_STS_ERROR;

1571: ( p_message_name => 'BOM_DG_NAME_MISSING'
1572: , p_mesg_token_tbl => l_mesg_token_tbl
1573: , x_mesg_token_tbl => x_mesg_token_tbl
1574: );
1575: x_return_status := FND_API.G_RET_STS_ERROR;
1576: RETURN;
1577: END IF;
1578:
1579: For c_CheckGroup in CheckGroup

Line 1587: x_return_status := FND_API.G_RET_STS_ERROR;

1583: ( p_message_name => 'BOM_DUPLICATE_DELETE_GROUP'
1584: , p_mesg_token_tbl=>l_mesg_token_tbl
1585: , x_mesg_token_tbl=>x_mesg_token_tbl
1586: );
1587: x_return_status := FND_API.G_RET_STS_ERROR;
1588: RETURN;
1589: End if;
1590:
1591: