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 544: l_return_status := FND_API.G_RET_STS_ERROR;

540: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
541: , p_token_tbl => g_token_tbl
542: );
543:
544: l_return_status := FND_API.G_RET_STS_ERROR;
545:
546: END IF;
547:
548: -- PackBom Related validations ..

Line 565: l_return_status := FND_API.G_RET_STS_ERROR;

561: ( p_message_name => 'BOM_CREATE_PACK_HIER_NOT_ALLOW'
562: , p_mesg_token_tbl => l_Mesg_Token_Tbl
563: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
564: );
565: l_return_status := FND_API.G_RET_STS_ERROR;
566: END IF;
567:
568: ---
569: -- Packaging BOM creation is allowed only with the prefered structure name for the

Line 588: l_return_status := FND_API.G_RET_STS_ERROR;

584: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
585: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
586: , p_Token_Tbl => l_token_tbl
587: );
588: l_return_status := FND_API.G_RET_STS_ERROR;
589: END IF;
590:
591: ---
592: -- Do not allow packaging hierarchies to be created in child orgs.

Line 606: l_return_status := FND_API.G_RET_STS_ERROR;

602: ( p_message_name => 'BOM_PKG_HIERARCHY_IN_CHILD_ORG'
603: , p_mesg_token_tbl => l_Mesg_Token_Tbl
604: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
605: );
606: l_return_status := FND_API.G_RET_STS_ERROR;
607: END IF;
608: END IF;
609: END IF;
610:

Line 617: p_bom_header_rec.alternate_bom_code <> FND_API.G_MISS_CHAR

613: -- If alternate designator is NOT NULL, then Primary Bill
614: -- must exist if the user is trying to create an Alternate
615: --
616: IF p_bom_header_rec.alternate_bom_code IS NOT NULL AND
617: p_bom_header_rec.alternate_bom_code <> FND_API.G_MISS_CHAR
618: THEN
619: BEGIN
620: SELECT '1'
621: INTO l_dummy

Line 636: FND_API.G_RET_STS_ERROR;

632:
633: EXCEPTION
634: WHEN NO_DATA_FOUND THEN
635: l_return_status :=
636: FND_API.G_RET_STS_ERROR;
637: l_token_tbl(1).token_name :=
638: 'ASSEMBLY_ITEM_NAME';
639: l_token_tbl(1).token_value :=
640: p_bom_header_rec.assembly_item_name;

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

648: END;
649: END IF;
650:
651: --validate structure type
652: --The value of structure type in the case of null or FND_API.MISS_CHAR
653: --will be ignored.
654:
655: IF ( p_bom_header_rec.alternate_bom_code IS NOT NULL
656: AND p_bom_header_rec.alternate_bom_code <> FND_API.G_MISS_CHAR

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

652: --The value of structure type in the case of null or FND_API.MISS_CHAR
653: --will be ignored.
654:
655: IF ( p_bom_header_rec.alternate_bom_code IS NOT NULL
656: AND p_bom_header_rec.alternate_bom_code <> FND_API.G_MISS_CHAR
657: AND p_bom_head_unexp_rec.structure_type_id IS NOT NULL
658: AND p_bom_head_unexp_rec.structure_type_id <> FND_API.G_MISS_NUM )
659: THEN
660: SELECT COUNT(1)

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

654:
655: IF ( p_bom_header_rec.alternate_bom_code IS NOT NULL
656: AND p_bom_header_rec.alternate_bom_code <> FND_API.G_MISS_CHAR
657: AND p_bom_head_unexp_rec.structure_type_id IS NOT NULL
658: AND p_bom_head_unexp_rec.structure_type_id <> FND_API.G_MISS_NUM )
659: THEN
660: SELECT COUNT(1)
661: INTO l_count
662: FROM BOM_ALTERNATE_DESIGNATORS BAD

Line 674: l_return_status := FND_API.G_RET_STS_ERROR;

670: CONNECT BY PRIOR BST.PARENT_STRUCTURE_TYPE_ID = BST.STRUCTURE_TYPE_ID
671: );
672:
673: IF ( l_count = 0 ) THEN
674: l_return_status := FND_API.G_RET_STS_ERROR;
675:
676: l_token_tbl(1).token_name := 'STRUCTURE_NAME';
677: l_token_tbl(1).token_value := p_bom_header_rec.alternate_bom_code;
678: l_token_tbl(2).token_name := 'STRUCTURE_TYPE';

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

689:
690: -- In update case, the new structure type must be a child of the existing one
691: IF ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
692: AND p_bom_head_unexp_rec.structure_type_id IS NOT NULL
693: AND p_bom_head_unexp_rec.structure_type_id <> FND_API.G_MISS_NUM
694: AND p_bom_head_unexp_rec.structure_type_id <> p_old_bom_head_unexp_rec.structure_type_id )
695: THEN
696: SELECT COUNT(1)
697: INTO l_count

Line 704: l_return_status := FND_API.G_RET_STS_ERROR;

700: START WITH BST.STRUCTURE_TYPE_ID = p_old_bom_head_unexp_rec.structure_type_id
701: CONNECT BY PRIOR BST.STRUCTURE_TYPE_ID = BST.PARENT_STRUCTURE_TYPE_ID;
702:
703: IF ( l_count = 0 ) THEN
704: l_return_status := FND_API.G_RET_STS_ERROR;
705:
706: --existing structure type is not populated in the BO record
707: l_token_tbl(1).token_name := 'OLD_STRTYPE';
708: BEGIN

Line 770: FND_API.G_MISS_CHAR

766: IF p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE
767: AND
768: ( ( p_bom_header_rec.common_organization_code IS NOT NULL
769: AND p_bom_header_rec.common_organization_code <>
770: FND_API.G_MISS_CHAR
771: AND NVL(p_bom_header_rec.common_organization_code, 'XXX') <>
772: NVL(p_old_bom_head_rec.common_organization_code,'XXX')
773: )
774: OR

Line 777: FND_API.G_MISS_CHAR

773: )
774: OR
775: ( p_bom_header_rec.common_assembly_item_name IS NOT NULL
776: AND p_bom_header_rec.common_assembly_item_name <>
777: FND_API.G_MISS_CHAR
778: AND NVL(p_bom_header_rec.common_assembly_item_name, 'NONE') <>
779: NVL(p_old_bom_head_rec.common_assembly_item_name, 'NONE')
780: )
781: )

Line 794: l_return_status := FND_API.G_RET_STS_ERROR;

790: , p_token_tbl => l_token_tbl
791: , p_mesg_token_tbl => l_mesg_token_tbl
792: , x_mesg_token_tbl => l_mesg_token_tbl
793: );
794: l_return_status := FND_API.G_RET_STS_ERROR;
795: END IF;
796:
797: --
798: -- If the user is trying to perform an update, and the bill is

Line 817: l_return_status := FND_API.G_RET_STS_ERROR;

813: , p_token_tbl => l_token_tbl
814: , p_mesg_token_tbl => l_mesg_token_tbl
815: , x_mesg_token_tbl => l_mesg_token_tbl
816: );
817: l_return_status := FND_API.G_RET_STS_ERROR;
818: END IF;
819:
820: END LOOP;
821: --

Line 831: FND_API.G_MISS_NUM

827: -- Using the common bill sequence_id check if the record for the
828: -- common bill has a common bill sequence id.
829: IF p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
830: p_bom_head_unexp_rec.source_bill_sequence_id <>
831: FND_API.G_MISS_NUM
832: THEN
833: BEGIN
834: SELECT '1'
835: INTO l_dummy

Line 856: l_return_status := FND_API.G_RET_STS_ERROR;

852: , p_token_tbl => l_token_tbl
853: , p_mesg_token_tbl => l_mesg_token_tbl
854: , x_mesg_token_tbl => l_mesg_token_tbl
855: );
856: l_return_status := FND_API.G_RET_STS_ERROR;
857:
858: EXCEPTION
859: WHEN NO_DATA_FOUND THEN
860: NULL;

Line 902: l_return_status := FND_API.G_RET_STS_ERROR;

898: , p_token_tbl => l_token_tbl
899: , p_mesg_token_tbl => l_mesg_token_tbl
900: , x_mesg_token_tbl => l_mesg_token_tbl
901: );
902: l_return_status := FND_API.G_RET_STS_ERROR;
903: END;
904: END IF;
905:
906: IF p_bom_header_Rec.ENABLE_ATTRS_UPDATE = 'Y'

Line 915: IF l_valid_op_seq = FND_API.G_RET_STS_ERROR

911: , p_assembly_item_id => p_bom_head_unexp_rec.assembly_item_id
912: , p_organization_id => p_bom_head_unexp_rec.organization_id
913: , p_alt_desg => p_bom_header_rec.alternate_bom_code
914: , x_Return_Status => l_valid_op_seq);
915: IF l_valid_op_seq = FND_API.G_RET_STS_ERROR
916: THEN
917: --BOM_COMMON_OPN_INVALID
918: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
919: l_token_tbl(1).token_value := p_bom_header_rec.assembly_item_name;

Line 936: l_return_status := FND_API.G_RET_STS_ERROR;

932: , p_token_tbl => l_token_tbl
933: , p_mesg_token_tbl => l_mesg_token_tbl
934: , x_mesg_token_tbl => l_mesg_token_tbl
935: );
936: l_return_status := FND_API.G_RET_STS_ERROR;
937: END IF;
938: END IF;
939:
940:

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

943: -- Validation for inter-org common
944: --
945: IF ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE AND
946: p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
947: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND
948: p_old_bom_head_unexp_rec.source_bill_sequence_id IS NULL AND
949: p_old_bom_head_unexp_rec.organization_id <>
950: p_bom_head_unexp_rec.common_organization_id
951: )

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

951: )
952: OR
953: ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND
954: p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
955: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND
956: p_bom_head_unexp_rec.common_organization_id <>
957: p_bom_head_unexp_rec.organization_id
958: )
959: THEN

Line 998: l_return_status := FND_API.G_RET_STS_ERROR;

994: , p_mesg_token_tbl => l_mesg_token_tbl
995: , x_mesg_token_tbl => l_mesg_token_tbl
996: );
997:
998: l_return_status := FND_API.G_RET_STS_ERROR;
999: END; -- if master org same ends
1000:
1001: -- Add operation sequence number validation here
1002: --call bompcmbm.validate_operation_sequence_id

Line 1008: IF l_valid_op_seq = FND_API.G_RET_STS_UNEXP_ERROR

1004: , p_assembly_item_id => p_bom_head_unexp_rec.assembly_item_id
1005: , p_organization_id => p_bom_head_unexp_rec.organization_id
1006: , p_alt_desg => p_bom_header_rec.alternate_bom_code
1007: , x_Return_Status => l_valid_op_seq);
1008: IF l_valid_op_seq = FND_API.G_RET_STS_UNEXP_ERROR
1009: THEN
1010: --BOM_COMMON_OPN_INVALID
1011: l_token_tbl(1).token_name := 'ALT_DESG';
1012: l_token_tbl(1).token_value := p_bom_header_rec.alternate_bom_code;

Line 1027: l_return_status := FND_API.G_RET_STS_ERROR;

1023: , p_token_tbl => l_token_tbl
1024: , p_mesg_token_tbl => l_mesg_token_tbl
1025: , x_mesg_token_tbl => l_mesg_token_tbl
1026: );
1027: l_return_status := FND_API.G_RET_STS_ERROR;
1028: END IF;*/
1029:
1030: -- If the current bom and the bom being referenced as common are not in the
1031: -- same org, then make sure that the components of the parent BOM exist in

Line 1126: l_return_status := FND_API.G_RET_STS_ERROR;

1122: , p_mesg_token_tbl => l_mesg_token_tbl
1123: , x_mesg_token_tbl => l_mesg_token_tbl
1124: );
1125:
1126: l_return_status := FND_API.G_RET_STS_ERROR;
1127: END IF;
1128: END;
1129:
1130: --If the source bom comtains fixed rev components, make sure the same revisions exist in the

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

1132: BOMPCMBM.check_comp_rev_in_local_org(p_src_bill_seq_id => p_bom_head_unexp_rec.source_bill_sequence_id,
1133: p_org_id => p_bom_head_unexp_rec.organization_id,
1134: x_return_status => l_comp_rev_status); --Bug 7526867
1135:
1136: IF l_comp_rev_status <> FND_API.G_RET_STS_SUCCESS --Bug 7526867
1137: THEN
1138:
1139: l_token_tbl.DELETE;
1140: l_token_tbl(1).token_name := 'ASSY_ITEM';

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

1148: , p_mesg_token_tbl => l_mesg_token_tbl
1149: , x_mesg_token_tbl => l_mesg_token_tbl
1150: );
1151:
1152: l_return_status := FND_API.G_RET_STS_ERROR; --Bug 7526867
1153:
1154: END IF;
1155:
1156: --

Line 1238: l_return_status := FND_API.G_RET_STS_ERROR;

1234: , p_mesg_token_tbl => l_mesg_token_tbl
1235: , x_mesg_token_tbl => l_mesg_token_tbl
1236: );
1237:
1238: l_return_status := FND_API.G_RET_STS_ERROR;
1239:
1240: END IF;
1241: END; -- Check if all the substitutes exist ends
1242: END IF; -- User creating a common or updating the common info Ends

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

1245: -- Common item must have bom_enabled_flag = 'Y'
1246: --
1247: IF ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_UPDATE AND
1248: p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
1249: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM AND
1250: p_old_bom_head_unexp_rec.source_bill_sequence_id IS NULL
1251: )
1252: OR
1253: ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND

Line 1255: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM

1251: )
1252: OR
1253: ( p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND
1254: p_bom_head_unexp_rec.source_bill_sequence_id IS NOT NULL AND
1255: p_bom_head_unexp_rec.source_bill_sequence_id <> FND_API.G_MISS_NUM
1256: )
1257: THEN
1258: BEGIN
1259: SELECT 1

Line 1276: l_return_status := FND_API.G_RET_STS_ERROR;

1272: AND msi1.effectivity_control = msi2.effectivity_control;
1273: --Commoning should happen within the eff ctrl.
1274: EXCEPTION
1275: WHEN no_data_found THEN
1276: l_return_status := FND_API.G_RET_STS_ERROR;
1277: l_token_tbl.DELETE;
1278: l_token_tbl(1).token_name := 'ASSEMBLY_ITEM_NAME';
1279: l_token_tbl(1).token_value := p_bom_header_rec.assembly_item_name;
1280: l_token_tbl(2).token_name := 'COMMON_ORG_CODE';

Line 1322: x_return_status := FND_API.G_RET_STS_SUCCESS;

1318: WHERE delete_group_name = p_bom_header_rec.Delete_Group_Name
1319: AND organization_id = p_bom_head_Unexp_Rec.organization_id;
1320:
1321: BEGIN
1322: x_return_status := FND_API.G_RET_STS_SUCCESS;
1323: x_bom_head_unexp_rec := p_bom_head_unexp_rec;
1324:
1325: IF p_bom_header_rec.Delete_Group_Name IS NULL OR
1326: p_bom_header_rec.Delete_Group_Name = FND_API.G_MISS_CHAR

Line 1326: p_bom_header_rec.Delete_Group_Name = FND_API.G_MISS_CHAR

1322: x_return_status := FND_API.G_RET_STS_SUCCESS;
1323: x_bom_head_unexp_rec := p_bom_head_unexp_rec;
1324:
1325: IF p_bom_header_rec.Delete_Group_Name IS NULL OR
1326: p_bom_header_rec.Delete_Group_Name = FND_API.G_MISS_CHAR
1327: THEN
1328: Error_Handler.Add_Error_Token
1329: ( p_message_name => 'BOM_DG_NAME_MISSING'
1330: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1333: x_return_status := FND_API.G_RET_STS_ERROR;

1329: ( p_message_name => 'BOM_DG_NAME_MISSING'
1330: , p_mesg_token_tbl => l_mesg_token_tbl
1331: , x_mesg_token_tbl => x_mesg_token_tbl
1332: );
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: RETURN;
1335: END IF;
1336:
1337: For c_CheckGroup in CheckGroup

Line 1345: x_return_status := FND_API.G_RET_STS_ERROR;

1341: ( p_message_name => 'BOM_DUPLICATE_DELETE_GROUP'
1342: , p_mesg_token_tbl=>l_mesg_token_tbl
1343: , x_mesg_token_tbl=>x_mesg_token_tbl
1344: );
1345: x_return_status := FND_API.G_RET_STS_ERROR;
1346: RETURN;
1347: End if;
1348:
1349: