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

Line 75: AND NVL(bor.alternate_routing_designator, FND_API.G_MISS_CHAR) =

71: SELECT routing_sequence_id
72: FROM bom_operational_routings bor
73: WHERE bor.assembly_item_id = p_revised_item_id
74: AND bor.organization_id = p_organization_id
75: AND NVL(bor.alternate_routing_designator, FND_API.G_MISS_CHAR) =
76: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR);
77:
78:
79: CURSOR l_rtg_seq_csr IS

Line 76: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR);

72: FROM bom_operational_routings bor
73: WHERE bor.assembly_item_id = p_revised_item_id
74: AND bor.organization_id = p_organization_id
75: AND NVL(bor.alternate_routing_designator, FND_API.G_MISS_CHAR) =
76: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR);
77:
78:
79: CURSOR l_rtg_seq_csr IS
80: SELECT Bom_Operational_Routings_S.NEXTVAL Rtg_Seq_Id

Line 182: OR p_std_op_code = FND_API.G_MISS_CHAR )

178: IS
179: BEGIN
180:
181: IF ( p_std_op_code IS NULL
182: OR p_std_op_code = FND_API.G_MISS_CHAR )
183: THEN
184: RETURN 2 ; -- Return No which is 2
185:
186: ELSE

Line 308: IF l_com_operation_rec.attribute_category = FND_API.G_MISS_CHAR THEN

304: l_com_operation_rec := p_com_operation_rec ;
305:
306: -- In the future call Flex APIs for defaults
307:
308: IF l_com_operation_rec.attribute_category = FND_API.G_MISS_CHAR THEN
309: l_com_operation_rec.attribute_category := NULL;
310: END IF;
311:
312: IF l_com_operation_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 312: IF l_com_operation_rec.attribute1 = FND_API.G_MISS_CHAR THEN

308: IF l_com_operation_rec.attribute_category = FND_API.G_MISS_CHAR THEN
309: l_com_operation_rec.attribute_category := NULL;
310: END IF;
311:
312: IF l_com_operation_rec.attribute1 = FND_API.G_MISS_CHAR THEN
313: l_com_operation_rec.attribute1 := NULL;
314: END IF;
315:
316: IF l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 316: IF l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR THEN

312: IF l_com_operation_rec.attribute1 = FND_API.G_MISS_CHAR THEN
313: l_com_operation_rec.attribute1 := NULL;
314: END IF;
315:
316: IF l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR THEN
317: l_com_operation_rec.attribute2 := NULL;
318: END IF;
319:
320: IF l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 320: IF l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR THEN

316: IF l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR THEN
317: l_com_operation_rec.attribute2 := NULL;
318: END IF;
319:
320: IF l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR THEN
321: l_com_operation_rec.attribute3 := NULL;
322: END IF;
323:
324: IF l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 324: IF l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR THEN

320: IF l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR THEN
321: l_com_operation_rec.attribute3 := NULL;
322: END IF;
323:
324: IF l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR THEN
325: l_com_operation_rec.attribute4 := NULL;
326: END IF;
327:
328: IF l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 328: IF l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR THEN

324: IF l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR THEN
325: l_com_operation_rec.attribute4 := NULL;
326: END IF;
327:
328: IF l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR THEN
329: l_com_operation_rec.attribute5 := NULL;
330: END IF;
331:
332: IF l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 332: IF l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR THEN

328: IF l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR THEN
329: l_com_operation_rec.attribute5 := NULL;
330: END IF;
331:
332: IF l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR THEN
333: l_com_operation_rec.attribute6 := NULL;
334: END IF;
335:
336: IF l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 336: IF l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR THEN

332: IF l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR THEN
333: l_com_operation_rec.attribute6 := NULL;
334: END IF;
335:
336: IF l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR THEN
337: l_com_operation_rec.attribute7 := NULL;
338: END IF;
339:
340: IF l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 340: IF l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR THEN

336: IF l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR THEN
337: l_com_operation_rec.attribute7 := NULL;
338: END IF;
339:
340: IF l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR THEN
341: l_com_operation_rec.attribute8 := NULL;
342: END IF;
343:
344: IF l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 344: IF l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR THEN

340: IF l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR THEN
341: l_com_operation_rec.attribute8 := NULL;
342: END IF;
343:
344: IF l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR THEN
345: l_com_operation_rec.attribute9 := NULL;
346: END IF;
347:
348: IF l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 348: IF l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR THEN

344: IF l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR THEN
345: l_com_operation_rec.attribute9 := NULL;
346: END IF;
347:
348: IF l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR THEN
349: l_com_operation_rec.attribute10 := NULL;
350: END IF;
351:
352: IF l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 352: IF l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR THEN

348: IF l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR THEN
349: l_com_operation_rec.attribute10 := NULL;
350: END IF;
351:
352: IF l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR THEN
353: l_com_operation_rec.attribute11 := NULL;
354: END IF;
355:
356: IF l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 356: IF l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR THEN

352: IF l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR THEN
353: l_com_operation_rec.attribute11 := NULL;
354: END IF;
355:
356: IF l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR THEN
357: l_com_operation_rec.attribute12 := NULL;
358: END IF;
359:
360: IF l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 360: IF l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR THEN

356: IF l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR THEN
357: l_com_operation_rec.attribute12 := NULL;
358: END IF;
359:
360: IF l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR THEN
361: l_com_operation_rec.attribute13 := NULL;
362: END IF;
363:
364: IF l_com_operation_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 364: IF l_com_operation_rec.attribute14 = FND_API.G_MISS_CHAR THEN

360: IF l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR THEN
361: l_com_operation_rec.attribute13 := NULL;
362: END IF;
363:
364: IF l_com_operation_rec.attribute14 = FND_API.G_MISS_CHAR THEN
365: l_com_operation_rec.attribute14 := NULL;
366: END IF;
367:
368: IF l_com_operation_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 368: IF l_com_operation_rec.attribute15 = FND_API.G_MISS_CHAR THEN

364: IF l_com_operation_rec.attribute14 = FND_API.G_MISS_CHAR THEN
365: l_com_operation_rec.attribute14 := NULL;
366: END IF;
367:
368: IF l_com_operation_rec.attribute15 = FND_API.G_MISS_CHAR THEN
369: l_com_operation_rec.attribute15 := NULL;
370: END IF;
371:
372: x_com_operation_rec := l_com_operation_rec ;

Line 472: = DECODE(p_op_type, FND_API.G_MISS_NUM, 1

468: , bso.track_multiple_res_usage_dates -- End of MES Changes
469: FROM BOM_STANDARD_OPERATIONS bso
470: , bom_operational_routings bor
471: WHERE NVL(bso.operation_type,1 )
472: = DECODE(p_op_type, FND_API.G_MISS_NUM, 1
473: , NVL(p_op_type, 1))
474: AND NVL(bso.line_id, FND_API.G_MISS_NUM)
475: = NVL(bor.line_id, FND_API.G_MISS_NUM)
476: AND bor.routing_sequence_id = p_rtg_seq_id

Line 474: AND NVL(bso.line_id, FND_API.G_MISS_NUM)

470: , bom_operational_routings bor
471: WHERE NVL(bso.operation_type,1 )
472: = DECODE(p_op_type, FND_API.G_MISS_NUM, 1
473: , NVL(p_op_type, 1))
474: AND NVL(bso.line_id, FND_API.G_MISS_NUM)
475: = NVL(bor.line_id, FND_API.G_MISS_NUM)
476: AND bor.routing_sequence_id = p_rtg_seq_id
477: AND bso.organization_id = p_org_id
478: AND bso.standard_operation_id = p_std_op_id

Line 475: = NVL(bor.line_id, FND_API.G_MISS_NUM)

471: WHERE NVL(bso.operation_type,1 )
472: = DECODE(p_op_type, FND_API.G_MISS_NUM, 1
473: , NVL(p_op_type, 1))
474: AND NVL(bso.line_id, FND_API.G_MISS_NUM)
475: = NVL(bor.line_id, FND_API.G_MISS_NUM)
476: AND bor.routing_sequence_id = p_rtg_seq_id
477: AND bso.organization_id = p_org_id
478: AND bso.standard_operation_id = p_std_op_id
479: UNION

Line 517: = DECODE( p_op_type, FND_API.G_MISS_NUM, 1

513: , bso.track_multiple_res_usage_dates -- End of MES Changes
514: FROM BOM_STANDARD_OPERATIONS bso
515: -- , ENG_REVISED_ITEMS eri --Bug : 3640944 By AMALVIYA
516: WHERE NVL(bso.operation_type, 1)
517: = DECODE( p_op_type, FND_API.G_MISS_NUM, 1
518: , NVL(p_op_type, 1 ) )
519: -- AND NVL(bso.line_id, FND_API.G_MISS_NUM)
520: -- = NVL(eri.line_id, FND_API.G_MISS_NUM)
521: -- AND eri.revised_item_sequence_id = p_rev_item_sequence_id

Line 519: -- AND NVL(bso.line_id, FND_API.G_MISS_NUM)

515: -- , ENG_REVISED_ITEMS eri --Bug : 3640944 By AMALVIYA
516: WHERE NVL(bso.operation_type, 1)
517: = DECODE( p_op_type, FND_API.G_MISS_NUM, 1
518: , NVL(p_op_type, 1 ) )
519: -- AND NVL(bso.line_id, FND_API.G_MISS_NUM)
520: -- = NVL(eri.line_id, FND_API.G_MISS_NUM)
521: -- AND eri.revised_item_sequence_id = p_rev_item_sequence_id
522: AND BOM_Rtg_Globals.Get_Routing_Sequence_Id IS NULL
523: AND bso.organization_id = p_org_id

Line 520: -- = NVL(eri.line_id, FND_API.G_MISS_NUM)

516: WHERE NVL(bso.operation_type, 1)
517: = DECODE( p_op_type, FND_API.G_MISS_NUM, 1
518: , NVL(p_op_type, 1 ) )
519: -- AND NVL(bso.line_id, FND_API.G_MISS_NUM)
520: -- = NVL(eri.line_id, FND_API.G_MISS_NUM)
521: -- AND eri.revised_item_sequence_id = p_rev_item_sequence_id
522: AND BOM_Rtg_Globals.Get_Routing_Sequence_Id IS NULL
523: AND bso.organization_id = p_org_id
524: AND bso.standard_operation_id = p_std_op_id

Line 538: l_return_status := FND_API.G_RET_STS_SUCCESS;

534: -- Set the first token to be equal to the operation sequence number
535: l_Token_Tbl(1).token_name := 'OP_SEQ_NUMBER';
536: l_Token_Tbl(1).token_value := p_com_operation_rec.operation_sequence_number ;
537:
538: l_return_status := FND_API.G_RET_STS_SUCCESS;
539:
540: --
541: -- Standard Operation has changed to not null value
542: --

Line 567: l_return_status := FND_API.G_RET_STS_ERROR ;

563: , p_Token_Tbl => l_Token_Tbl
564: ) ;
565: END IF ;
566:
567: l_return_status := FND_API.G_RET_STS_ERROR ;
568: l_copy_std_op := FALSE ;
569: END LOOP ;
570:
571: IF l_com_operation_rec.acd_type = l_ACD_CHANGE

Line 586: l_return_status := FND_API.G_RET_STS_ERROR ;

582: , p_Token_Tbl => l_Token_Tbl
583: ) ;
584: END IF ;
585:
586: l_return_status := FND_API.G_RET_STS_ERROR ;
587: l_copy_std_op := FALSE ;
588: END LOOP ;
589: END IF ;
590:

Line 633: l_com_op_unexp_rec.department_id = FND_API.G_MISS_NUM

629: END IF ;
630:
631:
632: IF l_com_op_unexp_rec.department_id IS NULL OR
633: l_com_op_unexp_rec.department_id = FND_API.G_MISS_NUM
634: THEN
635: l_com_op_unexp_rec.department_id := l_stdop_rec.department_id ;
636: END IF ;
637:

Line 639: l_com_operation_rec.count_point_type = FND_API.G_MISS_NUM

635: l_com_op_unexp_rec.department_id := l_stdop_rec.department_id ;
636: END IF ;
637:
638: IF l_com_operation_rec.count_point_type IS NULL OR
639: l_com_operation_rec.count_point_type = FND_API.G_MISS_NUM
640: THEN
641: l_com_operation_rec.count_point_type := l_stdop_rec.count_point_type ;
642: END IF ;
643:

Line 645: l_com_operation_rec.backflush_flag = FND_API.G_MISS_NUM

641: l_com_operation_rec.count_point_type := l_stdop_rec.count_point_type ;
642: END IF ;
643:
644: IF l_com_operation_rec.backflush_flag IS NULL OR
645: l_com_operation_rec.backflush_flag = FND_API.G_MISS_NUM
646: THEN
647: l_com_operation_rec.backflush_flag := l_stdop_rec.backflush_flag ;
648: END IF ;
649:

Line 651: l_com_operation_rec.minimum_transfer_quantity = FND_API.G_MISS_NUM

647: l_com_operation_rec.backflush_flag := l_stdop_rec.backflush_flag ;
648: END IF ;
649:
650: IF l_com_operation_rec.minimum_transfer_quantity IS NULL OR
651: l_com_operation_rec.minimum_transfer_quantity = FND_API.G_MISS_NUM
652: THEN
653: l_com_operation_rec.minimum_transfer_quantity := l_stdop_rec.minimum_transfer_quantity ;
654: END IF ;
655:

Line 657: l_com_operation_rec.option_dependent_flag = FND_API.G_MISS_NUM

653: l_com_operation_rec.minimum_transfer_quantity := l_stdop_rec.minimum_transfer_quantity ;
654: END IF ;
655:
656: IF l_com_operation_rec.option_dependent_flag IS NULL OR
657: l_com_operation_rec.option_dependent_flag = FND_API.G_MISS_NUM
658: THEN
659: l_com_operation_rec.option_dependent_flag := l_stdop_rec.option_dependent_flag ;
660: END IF ;
661:

Line 664: l_com_operation_rec.operation_description = FND_API.G_MISS_CHAR

660: END IF ;
661:
662:
663: IF l_com_operation_rec.operation_description IS NULL OR
664: l_com_operation_rec.operation_description = FND_API.G_MISS_CHAR
665: THEN
666: l_com_operation_rec.operation_description := l_stdop_rec.operation_description ;
667: END IF ;
668:

Line 671: l_com_operation_rec.op_yield_enabled_flag = FND_API.G_MISS_NUM )

667: END IF ;
668:
669: -- Added condition for Bug1744254
670: IF ( l_com_operation_rec.op_yield_enabled_flag IS NULL OR
671: l_com_operation_rec.op_yield_enabled_flag = FND_API.G_MISS_NUM )
672: AND BOM_Rtg_Globals.Get_CFM_Rtg_Flag = BOM_Rtg_Globals.G_LOT_RTG
673: THEN
674: l_com_operation_rec.op_yield_enabled_flag := l_stdop_rec.operation_yield_enabled ;
675: l_com_operation_rec.yield := l_stdop_rec.yield; --bug 3572770

Line 680: l_com_operation_rec.shutdown_type = FND_API.G_MISS_CHAR

676: END IF ;
677:
678: -- Added by MK on 04/10/2001 for eAM changes
679: IF l_com_operation_rec.shutdown_type IS NULL OR
680: l_com_operation_rec.shutdown_type = FND_API.G_MISS_CHAR
681: THEN
682: l_com_operation_rec.shutdown_type := l_stdop_rec.shutdown_type ;
683: END IF ;
684:

Line 745: l_com_op_unexp_rec.department_id = FND_API.G_MISS_NUM

741: END IF ;
742:
743: -- Set Standard Operation Info.
744: IF l_com_op_unexp_rec.department_id IS NULL OR
745: l_com_op_unexp_rec.department_id = FND_API.G_MISS_NUM
746: THEN
747: l_com_op_unexp_rec.department_id := l_stdop_rec.department_id ;
748: END IF ;
749:

Line 757: l_com_operation_rec.option_dependent_flag = FND_API.G_MISS_NUM

753:
754:
755: -- l_com_operation_rec.option_dependent_flag := l_stdop_rec.option_dependent_flag ;
756: IF l_com_operation_rec.option_dependent_flag IS NULL OR
757: l_com_operation_rec.option_dependent_flag = FND_API.G_MISS_NUM
758: THEN
759: l_com_operation_rec.option_dependent_flag := l_stdop_rec.option_dependent_flag ;
760: END IF ;
761:

Line 857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

853: , x_mesg_token_tbl => l_mesg_token_tbl
854: ) ;
855:
856: -- Return the status and message table.
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
858: x_mesg_token_tbl := l_mesg_token_tbl ;
859:
860: END Default_Std_Op_Attributes;
861:

Line 893: x_return_status := FND_API.G_RET_STS_SUCCESS;

889: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
890:
891: BEGIN
892:
893: x_return_status := FND_API.G_RET_STS_SUCCESS;
894:
895: -- Convert Routing Operation to Common Operation
896: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp
897: ( p_rtg_operation_rec => p_operation_rec

Line 961: x_return_status := FND_API.G_RET_STS_SUCCESS;

957: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
958:
959: BEGIN
960:
961: x_return_status := FND_API.G_RET_STS_SUCCESS;
962:
963:
964: -- Convert Revised Operation to Common Operation
965: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

Line 1039: l_return_status := FND_API.G_RET_STS_SUCCESS ;

1035: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
1036: ('Within the Rev. Operation Attr. Defaulting...') ;
1037: END IF ;
1038:
1039: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1040: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1041:
1042: -- Initialize operation exp and unexp record
1043: l_com_operation_rec := p_com_operation_rec ;

Line 1040: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1036: ('Within the Rev. Operation Attr. Defaulting...') ;
1037: END IF ;
1038:
1039: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1040: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1041:
1042: -- Initialize operation exp and unexp record
1043: l_com_operation_rec := p_com_operation_rec ;
1044: l_com_op_unexp_rec := p_com_op_unexp_rec ;

Line 1052: IF l_com_operation_rec.acd_type = FND_API.G_MISS_NUM

1048: -- Default ACD Type
1049: --
1050: ***********************************************************/
1051:
1052: IF l_com_operation_rec.acd_type = FND_API.G_MISS_NUM
1053: THEN
1054: l_com_operation_rec.acd_type := NULL ;
1055: END IF;
1056:

Line 1065: l_com_op_unexp_rec.operation_sequence_id = FND_API.G_MISS_NUM

1061: -- Default Operation_Sequence_Id
1062: --
1063: ***********************************************************/
1064: IF l_com_op_unexp_rec.operation_sequence_id IS NULL OR
1065: l_com_op_unexp_rec.operation_sequence_id = FND_API.G_MISS_NUM
1066: THEN
1067:
1068: l_com_op_unexp_rec.operation_sequence_id :=
1069: Get_Operation_Sequence_Id ;

Line 1081: OR l_com_operation_rec.operation_type = FND_API.G_MISS_NUM

1077: IF ( BOM_Rtg_Globals.Get_CFM_Rtg_Flag <> BOM_Rtg_Globals.G_FLOW_RTG
1078: OR BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_ECO_BO
1079: )
1080: AND ( l_com_operation_rec.operation_type IS NULL
1081: OR l_com_operation_rec.operation_type = FND_API.G_MISS_NUM
1082: )
1083: THEN
1084: l_com_operation_rec.operation_type :=
1085: Get_Operation_Type ;

Line 1110: l_com_operation_rec.reference_flag = FND_API.G_MISS_NUM

1106: --
1107: ************************************************************/
1108:
1109: IF l_com_operation_rec.reference_flag IS NULL OR
1110: l_com_operation_rec.reference_flag = FND_API.G_MISS_NUM
1111: THEN
1112: l_com_operation_rec.reference_flag :=
1113: Get_Reference_Flag
1114: (p_std_op_code => l_com_operation_rec.standard_operation_code ) ;

Line 1124: l_com_operation_rec.option_dependent_flag = FND_API.G_MISS_NUM

1120: --
1121: ************************************************************/
1122:
1123: IF l_com_operation_rec.option_dependent_flag IS NULL OR
1124: l_com_operation_rec.option_dependent_flag = FND_API.G_MISS_NUM
1125: THEN
1126: l_com_operation_rec.option_dependent_flag :=
1127: Get_Option_Dependent_Flag
1128: ( p_revised_item_id => l_com_op_unexp_rec.revised_item_id

Line 1136: OR l_com_operation_rec.standard_operation_code = FND_API.G_MISS_CHAR

1132:
1133:
1134:
1135: IF ( l_com_operation_rec.standard_operation_code IS NULL
1136: OR l_com_operation_rec.standard_operation_code = FND_API.G_MISS_CHAR
1137: )
1138: THEN
1139:
1140: /*********************************************************

Line 1147: l_com_operation_rec.count_point_type = FND_API.G_MISS_NUM

1143: --
1144: ***********************************************************/
1145:
1146: IF l_com_operation_rec.count_point_type IS NULL OR
1147: l_com_operation_rec.count_point_type = FND_API.G_MISS_NUM
1148: THEN
1149:
1150: l_com_operation_rec.count_point_type :=
1151: Get_Count_Point_Type ;

Line 1161: l_com_operation_rec.backflush_flag = FND_API.G_MISS_NUM

1157: --
1158: ************************************************************/
1159:
1160: IF l_com_operation_rec.backflush_flag IS NULL OR
1161: l_com_operation_rec.backflush_flag = FND_API.G_MISS_NUM
1162: THEN
1163: l_com_operation_rec.backflush_flag :=
1164: Get_BackFlush_Flag ;
1165: END IF;

Line 1172: l_com_operation_rec.option_dependent_flag = FND_API.G_MISS_NUM

1168: -- Option Dependent should be defaulted even if Std Op is not NULL
1169: -- Default Option_Dependent_Flag
1170: --
1171: IF l_com_operation_rec.option_dependent_flag IS NULL OR
1172: l_com_operation_rec.option_dependent_flag = FND_API.G_MISS_NUM
1173: THEN
1174: l_com_operation_rec.option_dependent_flag :=
1175: Get_Option_Dependent_Flag
1176: ( p_revised_item_id => l_com_op_unexp_rec.revised_item_id

Line 1190: l_com_operation_rec.minimum_transfer_quantity = FND_API.G_MISS_NUM

1186: --
1187: ************************************************************/
1188:
1189: IF l_com_operation_rec.minimum_transfer_quantity IS NULL OR
1190: l_com_operation_rec.minimum_transfer_quantity = FND_API.G_MISS_NUM
1191: THEN
1192: l_com_operation_rec.minimum_transfer_quantity :=
1193: Get_Minimum_Transfer_Quantity ;
1194: END IF;

Line 1214: IF l_temp_return_status = FND_API.G_RET_STS_ERROR

1210: , x_mesg_token_tbl => l_temp_mesg_token_tbl
1211: ) ;
1212:
1213:
1214: IF l_temp_return_status = FND_API.G_RET_STS_ERROR
1215: THEN
1216: l_mesg_token_tbl := l_temp_mesg_token_tbl ;
1217: l_return_status := FND_API.G_RET_STS_ERROR ;
1218: END IF ;

Line 1217: l_return_status := FND_API.G_RET_STS_ERROR ;

1213:
1214: IF l_temp_return_status = FND_API.G_RET_STS_ERROR
1215: THEN
1216: l_mesg_token_tbl := l_temp_mesg_token_tbl ;
1217: l_return_status := FND_API.G_RET_STS_ERROR ;
1218: END IF ;
1219:
1220:
1221: END IF ; -- if Std Op is null or not null

Line 1239: l_com_operation_rec.user_labor_time = FND_API.G_MISS_NUM

1235: --
1236: ************************************************************/
1237:
1238: IF l_com_operation_rec.user_labor_time IS NULL OR
1239: l_com_operation_rec.user_labor_time = FND_API.G_MISS_NUM
1240: THEN
1241: l_com_operation_rec.user_labor_time := Get_User_Labor_Time ;
1242: END IF ;
1243:

Line 1252: l_com_operation_rec.user_machine_time = FND_API.G_MISS_NUM

1248: --
1249: ************************************************************/
1250:
1251: IF l_com_operation_rec.user_machine_time IS NULL OR
1252: l_com_operation_rec.user_machine_time = FND_API.G_MISS_NUM
1253: THEN
1254: l_com_operation_rec.user_machine_time := Get_User_Machine_Time ;
1255: END IF ;
1256:

Line 1264: l_com_operation_rec.user_elapsed_time = FND_API.G_MISS_NUM

1260: -- Default User_Elapsed_Time
1261: --
1262: -- Defaulting User_Elapsed Time is moved to Entity Defaulting
1263: IF l_com_operation_rec.user_elapsed_time IS NULL OR
1264: l_com_operation_rec.user_elapsed_time = FND_API.G_MISS_NUM
1265: THEN
1266: l_com_operation_rec.user_elapsed_time :=
1267: Get_User_Elapsed_Time ;
1268: END IF ;

Line 1292: l_com_operation_rec.include_in_rollup = FND_API.G_MISS_NUM

1288: --
1289: ************************************************************/
1290:
1291: IF l_com_operation_rec.include_in_rollup IS NULL OR
1292: l_com_operation_rec.include_in_rollup = FND_API.G_MISS_NUM
1293: THEN
1294: l_com_operation_rec.include_in_rollup := Get_Include_In_Rollup ;
1295: END IF ;
1296:

Line 1305: l_com_operation_rec.op_yield_enabled_flag = FND_API.G_MISS_NUM

1301: --
1302: ************************************************************/
1303:
1304: IF l_com_operation_rec.op_yield_enabled_flag IS NULL OR
1305: l_com_operation_rec.op_yield_enabled_flag = FND_API.G_MISS_NUM
1306: THEN
1307: l_com_operation_rec.op_yield_enabled_flag := Get_Op_Yield_Enabled_Flag ;
1308: END IF ;
1309:

Line 1346: OR l_com_operation_rec.old_operation_sequence_number = FND_API.G_MISS_NUM

1342: ***********************************************************/
1343: IF ( BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_ECO_BO
1344: )
1345: AND ( l_com_operation_rec.old_operation_sequence_number IS NULL
1346: OR l_com_operation_rec.old_operation_sequence_number = FND_API.G_MISS_NUM
1347: )
1348: AND l_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE
1349: AND l_com_operation_rec.acd_type IN (2,3 ) -- Add
1350: THEN

Line 1374: OR l_com_op_unexp_rec.old_operation_sequence_id = FND_API.G_MISS_NUM)

1370: --
1371: **************************************************************/
1372:
1373: IF (l_com_op_unexp_rec.old_operation_sequence_id IS NULL
1374: OR l_com_op_unexp_rec.old_operation_sequence_id = FND_API.G_MISS_NUM)
1375: AND BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_ECO_BO
1376: AND l_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE
1377: AND l_com_operation_rec.acd_type = 1 -- Add
1378: THEN

Line 1392: IF l_com_operation_rec.attribute_category = FND_API.G_MISS_CHAR

1388: -- Default Operation Sequence's FlexFields
1389: --
1390: ************************************************************/
1391:
1392: IF l_com_operation_rec.attribute_category = FND_API.G_MISS_CHAR
1393: OR l_com_operation_rec.attribute1 = FND_API.G_MISS_CHAR
1394: OR l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR
1395: OR l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR
1396: OR l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR

Line 1393: OR l_com_operation_rec.attribute1 = FND_API.G_MISS_CHAR

1389: --
1390: ************************************************************/
1391:
1392: IF l_com_operation_rec.attribute_category = FND_API.G_MISS_CHAR
1393: OR l_com_operation_rec.attribute1 = FND_API.G_MISS_CHAR
1394: OR l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR
1395: OR l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR
1396: OR l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR
1397: OR l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR

Line 1394: OR l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR

1390: ************************************************************/
1391:
1392: IF l_com_operation_rec.attribute_category = FND_API.G_MISS_CHAR
1393: OR l_com_operation_rec.attribute1 = FND_API.G_MISS_CHAR
1394: OR l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR
1395: OR l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR
1396: OR l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR
1397: OR l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR
1398: OR l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR

Line 1395: OR l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR

1391:
1392: IF l_com_operation_rec.attribute_category = FND_API.G_MISS_CHAR
1393: OR l_com_operation_rec.attribute1 = FND_API.G_MISS_CHAR
1394: OR l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR
1395: OR l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR
1396: OR l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR
1397: OR l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR
1398: OR l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR
1399: OR l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR

Line 1396: OR l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR

1392: IF l_com_operation_rec.attribute_category = FND_API.G_MISS_CHAR
1393: OR l_com_operation_rec.attribute1 = FND_API.G_MISS_CHAR
1394: OR l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR
1395: OR l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR
1396: OR l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR
1397: OR l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR
1398: OR l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR
1399: OR l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR
1400: OR l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR

Line 1397: OR l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR

1393: OR l_com_operation_rec.attribute1 = FND_API.G_MISS_CHAR
1394: OR l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR
1395: OR l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR
1396: OR l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR
1397: OR l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR
1398: OR l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR
1399: OR l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR
1400: OR l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR
1401: OR l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR

Line 1398: OR l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR

1394: OR l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR
1395: OR l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR
1396: OR l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR
1397: OR l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR
1398: OR l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR
1399: OR l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR
1400: OR l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR
1401: OR l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR
1402: OR l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR

Line 1399: OR l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR

1395: OR l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR
1396: OR l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR
1397: OR l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR
1398: OR l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR
1399: OR l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR
1400: OR l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR
1401: OR l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR
1402: OR l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR
1403: OR l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR

Line 1400: OR l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR

1396: OR l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR
1397: OR l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR
1398: OR l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR
1399: OR l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR
1400: OR l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR
1401: OR l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR
1402: OR l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR
1403: OR l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR
1404: OR l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR

Line 1401: OR l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR

1397: OR l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR
1398: OR l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR
1399: OR l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR
1400: OR l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR
1401: OR l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR
1402: OR l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR
1403: OR l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR
1404: OR l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR
1405: OR l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR

Line 1402: OR l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR

1398: OR l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR
1399: OR l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR
1400: OR l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR
1401: OR l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR
1402: OR l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR
1403: OR l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR
1404: OR l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR
1405: OR l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR
1406: OR l_com_operation_rec.attribute14 = FND_API.G_MISS_CHAR

Line 1403: OR l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR

1399: OR l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR
1400: OR l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR
1401: OR l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR
1402: OR l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR
1403: OR l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR
1404: OR l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR
1405: OR l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR
1406: OR l_com_operation_rec.attribute14 = FND_API.G_MISS_CHAR
1407: OR l_com_operation_rec.attribute15 = FND_API.G_MISS_CHAR

Line 1404: OR l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR

1400: OR l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR
1401: OR l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR
1402: OR l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR
1403: OR l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR
1404: OR l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR
1405: OR l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR
1406: OR l_com_operation_rec.attribute14 = FND_API.G_MISS_CHAR
1407: OR l_com_operation_rec.attribute15 = FND_API.G_MISS_CHAR
1408: THEN

Line 1405: OR l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR

1401: OR l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR
1402: OR l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR
1403: OR l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR
1404: OR l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR
1405: OR l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR
1406: OR l_com_operation_rec.attribute14 = FND_API.G_MISS_CHAR
1407: OR l_com_operation_rec.attribute15 = FND_API.G_MISS_CHAR
1408: THEN
1409:

Line 1406: OR l_com_operation_rec.attribute14 = FND_API.G_MISS_CHAR

1402: OR l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR
1403: OR l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR
1404: OR l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR
1405: OR l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR
1406: OR l_com_operation_rec.attribute14 = FND_API.G_MISS_CHAR
1407: OR l_com_operation_rec.attribute15 = FND_API.G_MISS_CHAR
1408: THEN
1409:
1410: Get_Flex_Op_Seq( p_com_operation_rec => l_com_operation_rec

Line 1407: OR l_com_operation_rec.attribute15 = FND_API.G_MISS_CHAR

1403: OR l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR
1404: OR l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR
1405: OR l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR
1406: OR l_com_operation_rec.attribute14 = FND_API.G_MISS_CHAR
1407: OR l_com_operation_rec.attribute15 = FND_API.G_MISS_CHAR
1408: THEN
1409:
1410: Get_Flex_Op_Seq( p_com_operation_rec => l_com_operation_rec
1411: , x_com_operation_rec => l_com_operation_rec ) ;

Line 1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1440: , x_mesg_token_tbl => l_mesg_token_tbl
1441: ) ;
1442:
1443: -- Return the status and message table.
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1445: x_mesg_token_tbl := l_mesg_token_tbl ;
1446:
1447:
1448: END Attribute_Defaulting ;

Line 1914: l_com_op_unexp_rec.operation_sequence_id = FND_API.G_MISS_NUM

1910: -- Default Operation_Sequence_Id
1911: --
1912: ***********************************************************/
1913: IF l_com_op_unexp_rec.operation_sequence_id IS NULL OR
1914: l_com_op_unexp_rec.operation_sequence_id = FND_API.G_MISS_NUM
1915: THEN
1916: l_com_op_unexp_rec.operation_sequence_id :=
1917: Get_Operation_Sequence_Id ;
1918: END IF ;

Line 1923: l_com_op_unexp_rec.Standard_Operation_Id = FND_API.G_MISS_NUM

1919: END IF;
1920:
1921:
1922: IF l_com_op_unexp_rec.Standard_Operation_Id IS NULL OR
1923: l_com_op_unexp_rec.Standard_Operation_Id = FND_API.G_MISS_NUM
1924:
1925: THEN
1926: l_com_op_unexp_rec.Standard_Operation_Id
1927: := p_old_com_op_unexp_rec.Standard_Operation_Id ;

Line 1931: l_com_op_unexp_rec.Department_Id = FND_API.G_MISS_NUM

1927: := p_old_com_op_unexp_rec.Standard_Operation_Id ;
1928: END IF ;
1929:
1930: IF l_com_op_unexp_rec.Department_Id IS NULL OR
1931: l_com_op_unexp_rec.Department_Id = FND_API.G_MISS_NUM
1932: THEN
1933: l_com_op_unexp_rec.Department_Id
1934: := p_old_com_op_unexp_rec.Department_Id ;
1935: END IF ;

Line 1938: l_com_op_unexp_rec.Process_Op_Seq_Id = FND_API.G_MISS_NUM

1934: := p_old_com_op_unexp_rec.Department_Id ;
1935: END IF ;
1936:
1937: IF l_com_op_unexp_rec.Process_Op_Seq_Id IS NULL OR
1938: l_com_op_unexp_rec.Process_Op_Seq_Id = FND_API.G_MISS_NUM
1939: THEN
1940: l_com_op_unexp_rec.Process_Op_Seq_Id
1941: := p_old_com_op_unexp_rec.Process_Op_Seq_Id ;
1942: END IF ;

Line 1945: l_com_op_unexp_rec.Line_Op_Seq_Id = FND_API.G_MISS_NUM

1941: := p_old_com_op_unexp_rec.Process_Op_Seq_Id ;
1942: END IF ;
1943:
1944: IF l_com_op_unexp_rec.Line_Op_Seq_Id IS NULL OR
1945: l_com_op_unexp_rec.Line_Op_Seq_Id = FND_API.G_MISS_NUM
1946: THEN
1947: l_com_op_unexp_rec.Line_Op_Seq_Id
1948: := p_old_com_op_unexp_rec.Line_Op_Seq_Id ;
1949: END IF ;

Line 1953: l_com_op_unexp_rec.Line_Op_Seq_Id = FND_API.G_MISS_NUM

1949: END IF ;
1950:
1951:
1952: IF l_com_op_unexp_rec.User_Elapsed_Time IS NULL OR
1953: l_com_op_unexp_rec.Line_Op_Seq_Id = FND_API.G_MISS_NUM
1954: THEN
1955: l_com_op_unexp_rec.User_Elapsed_Time
1956: := p_old_com_op_unexp_rec.User_Elapsed_Time ;
1957: END IF ;

Line 2063: x_return_status := FND_API.G_RET_STS_SUCCESS;

2059: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2060:
2061: BEGIN
2062:
2063: x_return_status := FND_API.G_RET_STS_SUCCESS;
2064:
2065: --
2066: -- The record definition of Revised Operation in ECO BO is
2067: -- slightly different than the operation definition of RTG BO

Line 2138: x_return_status := FND_API.G_RET_STS_SUCCESS;

2134: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2135:
2136: BEGIN
2137:
2138: x_return_status := FND_API.G_RET_STS_SUCCESS;
2139:
2140: --
2141: -- The record definition of Revised Operation in ECO BO is
2142: -- slightly different than the operation definition of RTG BO

Line 2223: x_return_status := FND_API.G_RET_STS_SUCCESS;

2219: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
2220: ('Within the Rev. Operation Entity Defaulting...') ;
2221: END IF ;
2222:
2223: x_return_status := FND_API.G_RET_STS_SUCCESS;
2224: l_return_status := FND_API.G_RET_STS_SUCCESS;
2225:
2226: -- Initialize operation exp and unexp record
2227: l_com_operation_rec := p_com_operation_rec ;

Line 2224: l_return_status := FND_API.G_RET_STS_SUCCESS;

2220: ('Within the Rev. Operation Entity Defaulting...') ;
2221: END IF ;
2222:
2223: x_return_status := FND_API.G_RET_STS_SUCCESS;
2224: l_return_status := FND_API.G_RET_STS_SUCCESS;
2225:
2226: -- Initialize operation exp and unexp record
2227: l_com_operation_rec := p_com_operation_rec ;
2228: l_com_op_unexp_rec := p_com_op_unexp_rec ;

Line 2235: IF l_com_operation_rec.alternate_routing_code = FND_API.G_MISS_CHAR

2231: THEN
2232: l_com_operation_rec.new_start_effective_date := NULL ;
2233: END IF ;
2234:
2235: IF l_com_operation_rec.alternate_routing_code = FND_API.G_MISS_CHAR
2236: THEN
2237: l_com_operation_rec.alternate_routing_code := NULL ;
2238: END IF ;
2239:

Line 2243: l_com_operation_rec.operation_type = FND_API.G_MISS_NUM )

2239:
2240: IF ( BOM_Rtg_Globals.Get_CFM_Rtg_Flag <> BOM_Rtg_Globals.G_FLOW_RTG
2241: OR BOM_Rtg_Globals.Get_Bo_Identifier = BOM_Rtg_Globals.G_ECO_BO)
2242: AND (l_com_operation_rec.operation_type = NULL OR
2243: l_com_operation_rec.operation_type = FND_API.G_MISS_NUM )
2244: THEN
2245: l_com_operation_rec.operation_type := l_EVENT ;
2246: END IF ;
2247:

Line 2249: IF l_com_operation_rec.User_Labor_Time = FND_API.G_MISS_NUM

2245: l_com_operation_rec.operation_type := l_EVENT ;
2246: END IF ;
2247:
2248:
2249: IF l_com_operation_rec.User_Labor_Time = FND_API.G_MISS_NUM
2250: THEN
2251: l_com_operation_rec.User_Labor_Time := NULL ;
2252: END IF ;
2253:

Line 2254: IF l_com_operation_rec.User_Machine_Time = FND_API.G_MISS_NUM

2250: THEN
2251: l_com_operation_rec.User_Labor_Time := NULL ;
2252: END IF ;
2253:
2254: IF l_com_operation_rec.User_Machine_Time = FND_API.G_MISS_NUM
2255: THEN
2256: l_com_operation_rec.User_Machine_Time := NULL ;
2257: END IF ;
2258:

Line 2267: IF l_com_op_unexp_rec.department_id = FND_API.G_MISS_NUM

2263: , p_user_machine_time => l_com_operation_rec.User_Machine_Time
2264: ) ;
2265:
2266: -- Set missing column values to Null
2267: IF l_com_op_unexp_rec.department_id = FND_API.G_MISS_NUM
2268: THEN
2269: l_com_op_unexp_rec.department_id := NULL ;
2270: END IF;
2271:

Line 2272: IF l_com_op_unexp_rec.standard_operation_id = FND_API.G_MISS_NUM

2268: THEN
2269: l_com_op_unexp_rec.department_id := NULL ;
2270: END IF;
2271:
2272: IF l_com_op_unexp_rec.standard_operation_id = FND_API.G_MISS_NUM
2273: THEN
2274: l_com_op_unexp_rec.standard_operation_id := NULL ;
2275: END IF;
2276:

Line 2277: IF (l_com_operation_rec.Process_Seq_Number = FND_API.G_MISS_NUM

2273: THEN
2274: l_com_op_unexp_rec.standard_operation_id := NULL ;
2275: END IF;
2276:
2277: IF (l_com_operation_rec.Process_Seq_Number = FND_API.G_MISS_NUM
2278: AND l_com_operation_rec.Process_Code = FND_API.G_MISS_CHAR )
2279: OR l_com_op_unexp_rec.process_op_seq_id = FND_API.G_MISS_NUM
2280: THEN
2281: l_com_op_unexp_rec.process_op_seq_id := NULL ;

Line 2278: AND l_com_operation_rec.Process_Code = FND_API.G_MISS_CHAR )

2274: l_com_op_unexp_rec.standard_operation_id := NULL ;
2275: END IF;
2276:
2277: IF (l_com_operation_rec.Process_Seq_Number = FND_API.G_MISS_NUM
2278: AND l_com_operation_rec.Process_Code = FND_API.G_MISS_CHAR )
2279: OR l_com_op_unexp_rec.process_op_seq_id = FND_API.G_MISS_NUM
2280: THEN
2281: l_com_op_unexp_rec.process_op_seq_id := NULL ;
2282: END IF ;

Line 2279: OR l_com_op_unexp_rec.process_op_seq_id = FND_API.G_MISS_NUM

2275: END IF;
2276:
2277: IF (l_com_operation_rec.Process_Seq_Number = FND_API.G_MISS_NUM
2278: AND l_com_operation_rec.Process_Code = FND_API.G_MISS_CHAR )
2279: OR l_com_op_unexp_rec.process_op_seq_id = FND_API.G_MISS_NUM
2280: THEN
2281: l_com_op_unexp_rec.process_op_seq_id := NULL ;
2282: END IF ;
2283:

Line 2284: IF (l_com_operation_rec.Line_Op_Seq_Number = FND_API.G_MISS_NUM

2280: THEN
2281: l_com_op_unexp_rec.process_op_seq_id := NULL ;
2282: END IF ;
2283:
2284: IF (l_com_operation_rec.Line_Op_Seq_Number = FND_API.G_MISS_NUM
2285: AND l_com_operation_rec.Line_Op_Code = FND_API.G_MISS_CHAR)
2286: OR l_com_op_unexp_rec.line_op_seq_id = FND_API.G_MISS_NUM
2287: THEN
2288: l_com_op_unexp_rec.line_op_seq_id := NULL ;

Line 2285: AND l_com_operation_rec.Line_Op_Code = FND_API.G_MISS_CHAR)

2281: l_com_op_unexp_rec.process_op_seq_id := NULL ;
2282: END IF ;
2283:
2284: IF (l_com_operation_rec.Line_Op_Seq_Number = FND_API.G_MISS_NUM
2285: AND l_com_operation_rec.Line_Op_Code = FND_API.G_MISS_CHAR)
2286: OR l_com_op_unexp_rec.line_op_seq_id = FND_API.G_MISS_NUM
2287: THEN
2288: l_com_op_unexp_rec.line_op_seq_id := NULL ;
2289: END IF ;

Line 2286: OR l_com_op_unexp_rec.line_op_seq_id = FND_API.G_MISS_NUM

2282: END IF ;
2283:
2284: IF (l_com_operation_rec.Line_Op_Seq_Number = FND_API.G_MISS_NUM
2285: AND l_com_operation_rec.Line_Op_Code = FND_API.G_MISS_CHAR)
2286: OR l_com_op_unexp_rec.line_op_seq_id = FND_API.G_MISS_NUM
2287: THEN
2288: l_com_op_unexp_rec.line_op_seq_id := NULL ;
2289: END IF ;
2290:

Line 2291: IF l_com_operation_rec.new_operation_sequence_number = FND_API.G_MISS_NUM

2287: THEN
2288: l_com_op_unexp_rec.line_op_seq_id := NULL ;
2289: END IF ;
2290:
2291: IF l_com_operation_rec.new_operation_sequence_number = FND_API.G_MISS_NUM
2292: THEN
2293: l_com_operation_rec.new_operation_sequence_number := NULL ;
2294: END IF ;
2295:

Line 2296: IF l_com_operation_rec.new_start_effective_date = FND_API.G_MISS_DATE

2292: THEN
2293: l_com_operation_rec.new_operation_sequence_number := NULL ;
2294: END IF ;
2295:
2296: IF l_com_operation_rec.new_start_effective_date = FND_API.G_MISS_DATE
2297: THEN
2298: l_com_operation_rec.new_start_effective_date := NULL ;
2299: END IF ;
2300:

Line 2301: IF l_com_operation_rec.Disable_Date = FND_API.G_MISS_DATE

2297: THEN
2298: l_com_operation_rec.new_start_effective_date := NULL ;
2299: END IF ;
2300:
2301: IF l_com_operation_rec.Disable_Date = FND_API.G_MISS_DATE
2302: THEN
2303: l_com_operation_rec.Disable_Date := NULL ;
2304: END IF ;
2305:

Line 2306: IF l_com_operation_rec.Op_Lead_Time_Percent = FND_API.G_MISS_NUM

2302: THEN
2303: l_com_operation_rec.Disable_Date := NULL ;
2304: END IF ;
2305:
2306: IF l_com_operation_rec.Op_Lead_Time_Percent = FND_API.G_MISS_NUM
2307: THEN
2308: l_com_operation_rec.Op_Lead_Time_Percent := NULL ;
2309: END IF ;
2310:

Line 2311: IF l_com_operation_rec.Minimum_Transfer_Quantity = FND_API.G_MISS_NUM

2307: THEN
2308: l_com_operation_rec.Op_Lead_Time_Percent := NULL ;
2309: END IF ;
2310:
2311: IF l_com_operation_rec.Minimum_Transfer_Quantity = FND_API.G_MISS_NUM
2312: THEN
2313: l_com_operation_rec.Minimum_Transfer_Quantity := NULL ;
2314: END IF ;
2315:

Line 2316: IF l_com_operation_rec.Operation_Description = FND_API.G_MISS_CHAR

2312: THEN
2313: l_com_operation_rec.Minimum_Transfer_Quantity := NULL ;
2314: END IF ;
2315:
2316: IF l_com_operation_rec.Operation_Description = FND_API.G_MISS_CHAR
2317: THEN
2318: l_com_operation_rec.Operation_Description := NULL ;
2319: END IF ;
2320:

Line 2321: IF l_com_operation_rec.Yield = FND_API.G_MISS_NUM

2317: THEN
2318: l_com_operation_rec.Operation_Description := NULL ;
2319: END IF ;
2320:
2321: IF l_com_operation_rec.Yield = FND_API.G_MISS_NUM
2322: THEN
2323: l_com_operation_rec.Yield := NULL ;
2324: END IF ;
2325:

Line 2326: IF l_com_operation_rec.Cumulative_Yield = FND_API.G_MISS_NUM

2322: THEN
2323: l_com_operation_rec.Yield := NULL ;
2324: END IF ;
2325:
2326: IF l_com_operation_rec.Cumulative_Yield = FND_API.G_MISS_NUM
2327: THEN
2328: l_com_operation_rec.Cumulative_Yield := NULL ;
2329: END IF ;
2330:

Line 2331: IF l_com_operation_rec.Reverse_CUM_Yield = FND_API.G_MISS_NUM

2327: THEN
2328: l_com_operation_rec.Cumulative_Yield := NULL ;
2329: END IF ;
2330:
2331: IF l_com_operation_rec.Reverse_CUM_Yield = FND_API.G_MISS_NUM
2332: THEN
2333: l_com_operation_rec.Reverse_CUM_Yield := NULL ;
2334: END IF ;
2335:

Line 2337: IF l_com_operation_rec.Calculated_Labor_Time = FND_API.G_MISS_NUM

2333: l_com_operation_rec.Reverse_CUM_Yield := NULL ;
2334: END IF ;
2335:
2336: /* Following calc op times columns no longer used
2337: IF l_com_operation_rec.Calculated_Labor_Time = FND_API.G_MISS_NUM
2338: THEN
2339: l_com_operation_rec.Calculated_Labor_Time := NULL ;
2340: END IF ;
2341:

Line 2342: IF l_com_operation_rec.Calculated_Machine_Time = FND_API.G_MISS_NUM

2338: THEN
2339: l_com_operation_rec.Calculated_Labor_Time := NULL ;
2340: END IF ;
2341:
2342: IF l_com_operation_rec.Calculated_Machine_Time = FND_API.G_MISS_NUM
2343: THEN
2344: l_com_operation_rec.Calculated_Machine_Time := NULL ;
2345: END IF ;
2346:

Line 2347: IF l_com_operation_rec.Calculated_Elapsed_Time = FND_API.G_MISS_NUM

2343: THEN
2344: l_com_operation_rec.Calculated_Machine_Time := NULL ;
2345: END IF ;
2346:
2347: IF l_com_operation_rec.Calculated_Elapsed_Time = FND_API.G_MISS_NUM
2348: THEN
2349: l_com_operation_rec.Calculated_Elapsed_Time := NULL ;
2350: END IF ;
2351: */

Line 2354: IF l_com_operation_rec.Net_Planning_Percent = FND_API.G_MISS_NUM

2350: END IF ;
2351: */
2352:
2353:
2354: IF l_com_operation_rec.Net_Planning_Percent = FND_API.G_MISS_NUM
2355: THEN
2356: l_com_operation_rec.Net_Planning_Percent := NULL ;
2357: END IF ;
2358:

Line 2359: IF l_com_operation_rec.original_system_reference = FND_API.G_MISS_CHAR THEN

2355: THEN
2356: l_com_operation_rec.Net_Planning_Percent := NULL ;
2357: END IF ;
2358:
2359: IF l_com_operation_rec.original_system_reference = FND_API.G_MISS_CHAR THEN
2360: l_com_operation_rec.original_system_reference := NULL ;
2361: END IF;
2362:
2363: -- Added by MK on 04/10/2001 for eAM changes

Line 2364: IF l_com_operation_rec.Shutdown_Type = FND_API.G_MISS_CHAR THEN

2360: l_com_operation_rec.original_system_reference := NULL ;
2361: END IF;
2362:
2363: -- Added by MK on 04/10/2001 for eAM changes
2364: IF l_com_operation_rec.Shutdown_Type = FND_API.G_MISS_CHAR THEN
2365: l_com_operation_rec.Shutdown_Type := NULL ;
2366: END IF;
2367:
2368: -- Added for long description (Bug 2689249)

Line 2369: IF l_com_operation_rec.long_description = FND_API.G_MISS_CHAR THEN

2365: l_com_operation_rec.Shutdown_Type := NULL ;
2366: END IF;
2367:
2368: -- Added for long description (Bug 2689249)
2369: IF l_com_operation_rec.long_description = FND_API.G_MISS_CHAR THEN
2370: l_com_operation_rec.long_description := NULL ;
2371: END IF;
2372:
2373:

Line 2375: IF l_com_operation_rec.attribute_category = FND_API.G_MISS_CHAR THEN

2371: END IF;
2372:
2373:
2374: -- FlexFields
2375: IF l_com_operation_rec.attribute_category = FND_API.G_MISS_CHAR THEN
2376: l_com_operation_rec.attribute_category := NULL ;
2377: END IF;
2378:
2379: IF l_com_operation_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 2379: IF l_com_operation_rec.attribute1 = FND_API.G_MISS_CHAR THEN

2375: IF l_com_operation_rec.attribute_category = FND_API.G_MISS_CHAR THEN
2376: l_com_operation_rec.attribute_category := NULL ;
2377: END IF;
2378:
2379: IF l_com_operation_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2380: l_com_operation_rec.attribute1 := NULL ;
2381: END IF;
2382:
2383: IF l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 2383: IF l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR THEN

2379: IF l_com_operation_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2380: l_com_operation_rec.attribute1 := NULL ;
2381: END IF;
2382:
2383: IF l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2384: l_com_operation_rec.attribute2 := NULL ;
2385: END IF;
2386:
2387: IF l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 2387: IF l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR THEN

2383: IF l_com_operation_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2384: l_com_operation_rec.attribute2 := NULL ;
2385: END IF;
2386:
2387: IF l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2388: l_com_operation_rec.attribute3 := NULL ;
2389: END IF;
2390:
2391: IF l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 2391: IF l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR THEN

2387: IF l_com_operation_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2388: l_com_operation_rec.attribute3 := NULL ;
2389: END IF;
2390:
2391: IF l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2392: l_com_operation_rec.attribute4 := NULL ;
2393: END IF;
2394:
2395: IF l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 2395: IF l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR THEN

2391: IF l_com_operation_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2392: l_com_operation_rec.attribute4 := NULL ;
2393: END IF;
2394:
2395: IF l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2396: l_com_operation_rec.attribute5 := NULL ;
2397: END IF;
2398:
2399: IF l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 2399: IF l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR THEN

2395: IF l_com_operation_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2396: l_com_operation_rec.attribute5 := NULL ;
2397: END IF;
2398:
2399: IF l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2400: l_com_operation_rec.attribute6 := NULL ;
2401: END IF;
2402:
2403: IF l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 2403: IF l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR THEN

2399: IF l_com_operation_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2400: l_com_operation_rec.attribute6 := NULL ;
2401: END IF;
2402:
2403: IF l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2404: l_com_operation_rec.attribute7 := NULL ;
2405: END IF;
2406:
2407: IF l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 2407: IF l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR THEN

2403: IF l_com_operation_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2404: l_com_operation_rec.attribute7 := NULL ;
2405: END IF;
2406:
2407: IF l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2408: l_com_operation_rec.attribute8 := NULL ;
2409: END IF;
2410:
2411: IF l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 2411: IF l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR THEN

2407: IF l_com_operation_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2408: l_com_operation_rec.attribute8 := NULL ;
2409: END IF;
2410:
2411: IF l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2412: l_com_operation_rec.attribute9 := NULL ;
2413: END IF;
2414:
2415: IF l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 2415: IF l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR THEN

2411: IF l_com_operation_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2412: l_com_operation_rec.attribute9 := NULL ;
2413: END IF;
2414:
2415: IF l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2416: l_com_operation_rec.attribute10 := NULL ;
2417: END IF;
2418:
2419: IF l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 2419: IF l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR THEN

2415: IF l_com_operation_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2416: l_com_operation_rec.attribute10 := NULL ;
2417: END IF;
2418:
2419: IF l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2420: l_com_operation_rec.attribute11 := NULL ;
2421: END IF;
2422:
2423: IF l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 2423: IF l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR THEN

2419: IF l_com_operation_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2420: l_com_operation_rec.attribute11 := NULL ;
2421: END IF;
2422:
2423: IF l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2424: l_com_operation_rec.attribute12 := NULL ;
2425: END IF;
2426:
2427: IF l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 2427: IF l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR THEN

2423: IF l_com_operation_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2424: l_com_operation_rec.attribute12 := NULL ;
2425: END IF;
2426:
2427: IF l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2428: l_com_operation_rec.attribute13 := NULL ;
2429: END IF;
2430:
2431: IF l_com_operation_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 2431: IF l_com_operation_rec.attribute14 = FND_API.G_MISS_CHAR THEN

2427: IF l_com_operation_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2428: l_com_operation_rec.attribute13 := NULL ;
2429: END IF;
2430:
2431: IF l_com_operation_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2432: l_com_operation_rec.attribute14 := NULL ;
2433: END IF;
2434:
2435: IF l_com_operation_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 2435: IF l_com_operation_rec.attribute15 = FND_API.G_MISS_CHAR THEN

2431: IF l_com_operation_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2432: l_com_operation_rec.attribute14 := NULL ;
2433: END IF;
2434:
2435: IF l_com_operation_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2436: l_com_operation_rec.attribute15 := NULL ;
2437: END IF;
2438:
2439: -- Return the status and message table.

Line 2467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2463: , x_mesg_token_tbl => l_mesg_token_tbl
2464: ) ;
2465:
2466: -- Return the status and message table.
2467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2468: x_mesg_token_tbl := l_mesg_token_tbl ;
2469:
2470: END Entity_Defaulting ;
2471: