eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_VALIDATE_OP_SEQ dependencies on STANDARD

Line 30: l_STANDARD CONSTANT NUMBER := 4 ;

26:
27: l_MODEL CONSTANT NUMBER := 1 ;
28: l_OPTION_CLASS CONSTANT NUMBER := 2 ;
29: l_PLANNING CONSTANT NUMBER := 3 ;
30: l_STANDARD CONSTANT NUMBER := 4 ;
31: l_PRODFAMILY CONSTANT NUMBER := 5 ;
32: l_EVENT CONSTANT NUMBER := 1 ;
33: l_PROCESS CONSTANT NUMBER := 2 ;
34: l_LINE_OP CONSTANT NUMBER := 3 ;

Line 815: -- Standard Operation Id and Operation Type

811: x_return_status := FND_API.G_RET_STS_ERROR ;
812:
813: END IF;
814:
815: -- Standard Operation Id and Operation Type
816: IF ( p_com_operation_rec.operation_type IN (2, 3)
817: AND p_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE
818: AND ( p_com_operation_rec.standard_operation_code IS NULL OR
819: p_com_operation_rec.standard_operation_code = FND_API.G_MISS_CHAR )

Line 818: AND ( p_com_operation_rec.standard_operation_code IS NULL OR

814:
815: -- Standard Operation Id and Operation Type
816: IF ( p_com_operation_rec.operation_type IN (2, 3)
817: AND p_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE
818: AND ( p_com_operation_rec.standard_operation_code IS NULL OR
819: p_com_operation_rec.standard_operation_code = FND_API.G_MISS_CHAR )
820: )
821: THEN
822: Error_Handler.Add_Error_Token

Line 819: p_com_operation_rec.standard_operation_code = FND_API.G_MISS_CHAR )

815: -- Standard Operation Id and Operation Type
816: IF ( p_com_operation_rec.operation_type IN (2, 3)
817: AND p_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE
818: AND ( p_com_operation_rec.standard_operation_code IS NULL OR
819: p_com_operation_rec.standard_operation_code = FND_API.G_MISS_CHAR )
820: )
821: THEN
822: Error_Handler.Add_Error_Token
823: ( p_message_name => 'BOM_FLM_OP_STDOP_REQUIRED'

Line 839: AND ( p_com_operation_rec.standard_operation_code IS NULL OR

835: p_com_operation_rec.department_code = FND_API.G_MISS_CHAR
836: )
837: AND p_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE
838: AND NVL(p_com_operation_rec.acd_type, 1) = l_ACD_ADD
839: AND ( p_com_operation_rec.standard_operation_code IS NULL OR
840: p_com_operation_rec.standard_operation_code = FND_API.G_MISS_CHAR )
841: AND BOM_Rtg_Globals.Get_CFM_Rtg_Flag <> BOM_Rtg_Globals.G_Lot_Rtg
842: THEN
843: Error_Handler.Add_Error_Token

Line 840: p_com_operation_rec.standard_operation_code = FND_API.G_MISS_CHAR )

836: )
837: AND p_com_operation_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE
838: AND NVL(p_com_operation_rec.acd_type, 1) = l_ACD_ADD
839: AND ( p_com_operation_rec.standard_operation_code IS NULL OR
840: p_com_operation_rec.standard_operation_code = FND_API.G_MISS_CHAR )
841: AND BOM_Rtg_Globals.Get_CFM_Rtg_Flag <> BOM_Rtg_Globals.G_Lot_Rtg
842: THEN
843: Error_Handler.Add_Error_Token
844: ( p_message_name => 'BOM_OP_DEPT_REQUIRED'

Line 1119: -- Standard Operation Code

1115: END IF ;
1116:
1117:
1118:
1119: -- Standard Operation Code
1120: IF p_com_operation_rec.standard_operation_code = FND_API.G_MISS_CHAR
1121: THEN
1122: Error_Handler.Add_Error_Token
1123: ( p_Message_Name => 'BOM_OP_STD_OP_NOTUPDATABLE'

Line 1120: IF p_com_operation_rec.standard_operation_code = FND_API.G_MISS_CHAR

1116:
1117:
1118:
1119: -- Standard Operation Code
1120: IF p_com_operation_rec.standard_operation_code = FND_API.G_MISS_CHAR
1121: THEN
1122: Error_Handler.Add_Error_Token
1123: ( p_Message_Name => 'BOM_OP_STD_OP_NOTUPDATABLE'
1124: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1716: -- Standard Operation Id and Operation Type

1712: l_Token_Tbl(1).token_name := 'OP_SEQ_NUMBER';
1713: l_Token_Tbl(1).token_value := p_com_operation_rec.operation_sequence_number ;
1714:
1715: /* Moved to Check_Required
1716: -- Standard Operation Id and Operation Type
1717: */
1718:
1719: -- Return the message table.
1720: x_mesg_token_tbl := l_Mesg_Token_Tbl ;

Line 2094: /Bug 6523550 even for standard routings the value shouldnt be defaulted to 1/

2090: --
2091:
2092: -- Include_In_Rollup
2093: IF BOM_Rtg_Globals.Get_CFM_Rtg_Flag NOT IN (BOM_Rtg_Globals.G_LOT_RTG, BOM_Rtg_Globals.G_STD_RTG) AND
2094: /*Bug 6523550 even for standard routings the value shouldnt be defaulted to 1*/
2095: ( l_com_operation_rec.include_in_rollup IS NOT NULL OR
2096: l_com_operation_rec.include_in_rollup <> FND_API.G_MISS_NUM )
2097: AND l_com_operation_rec.include_in_rollup <> 1 -- Not default. Bug1744254
2098: THEN

Line 2317: * Standard Operation. If Std Op is not null

2313: * Common Old Operation unexposed column record
2314: * Parameters out: Return Status
2315: * Message Token Table
2316: * Purpose : Check_Ref_Operation validate Reference flag and
2317: * Standard Operation. If Std Op is not null
2318: * Set Standard Operation infor to exposed and unexposed
2319: * coulumns regarding reference flag
2320: **********************************************************************/
2321: PROCEDURE Check_Ref_Std_Operation

Line 2318: * Set Standard Operation infor to exposed and unexposed

2314: * Parameters out: Return Status
2315: * Message Token Table
2316: * Purpose : Check_Ref_Operation validate Reference flag and
2317: * Standard Operation. If Std Op is not null
2318: * Set Standard Operation infor to exposed and unexposed
2319: * coulumns regarding reference flag
2320: **********************************************************************/
2321: PROCEDURE Check_Ref_Std_Operation
2322: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

Line 2366: WHERE standard_operation_id = p_std_op_id

2362: SELECT 'Sub Resources Exist'
2363: FROM DUAL
2364: WHERE EXISTS (SELECT NULL
2365: FROM BOM_STD_SUB_OP_RESOURCES
2366: WHERE standard_operation_id = p_std_op_id
2367: AND Schedule_Seq_Num IS NULL); -- Bug 7370692
2368:
2369: -- Get Standard Operation Info.
2370: CURSOR l_stdop_csr( p_std_op_id NUMBER

Line 2369: -- Get Standard Operation Info.

2365: FROM BOM_STD_SUB_OP_RESOURCES
2366: WHERE standard_operation_id = p_std_op_id
2367: AND Schedule_Seq_Num IS NULL); -- Bug 7370692
2368:
2369: -- Get Standard Operation Info.
2370: CURSOR l_stdop_csr( p_std_op_id NUMBER
2371: , p_op_type NUMBER
2372: , p_rtg_seq_id NUMBER
2373: , p_org_id NUMBER

Line 2381: FROM BOM_STANDARD_OPERATIONS bso

2377: IS
2378: SELECT 'Std Op Invalid'
2379: FROM DUAL
2380: WHERE NOT EXISTS (SELECT NULL
2381: FROM BOM_STANDARD_OPERATIONS bso
2382: , bom_operational_routings bor
2383: WHERE NVL(bso.operation_type,1 )
2384: = DECODE( p_op_type, FND_API.G_MISS_NUM, 1
2385: , NVL(p_op_type, 1))

Line 2391: AND bso.standard_operation_id = p_std_op_id

2387: = NVL(bor.line_id, FND_API.G_MISS_NUM)
2388: AND bor.routing_sequence_id = p_rtg_seq_id
2389: AND bso.department_id = p_dept_id
2390: AND bso.organization_id = p_org_id
2391: AND bso.standard_operation_id = p_std_op_id
2392: UNION
2393: SELECT NULL
2394: FROM BOM_STANDARD_OPERATIONS bso
2395: , ENG_REVISED_ITEMS eri

Line 2394: FROM BOM_STANDARD_OPERATIONS bso

2390: AND bso.organization_id = p_org_id
2391: AND bso.standard_operation_id = p_std_op_id
2392: UNION
2393: SELECT NULL
2394: FROM BOM_STANDARD_OPERATIONS bso
2395: , ENG_REVISED_ITEMS eri
2396: WHERE NVL(bso.operation_type, 1)
2397: = DECODE( p_op_type, FND_API.G_MISS_NUM, 1
2398: , NVL(p_op_type, 1 ) )

Line 2408: AND bso.standard_operation_id = p_std_op_id

2404: WHERE routing_sequence_id = p_rtg_seq_id)
2405: AND eri.revised_item_sequence_id = p_rit_seq_id
2406: AND bso.department_id = p_dept_id
2407: AND bso.organization_id = p_org_id
2408: AND bso.standard_operation_id = p_std_op_id
2409: ) ;
2410: BEGIN
2411:
2412: -- Initialize operation exp and unexp record

Line 2423: -- Standard Operation is not updatable

2419:
2420: l_return_status := FND_API.G_RET_STS_SUCCESS;
2421:
2422: --
2423: -- Standard Operation is not updatable
2424: --
2425: IF ( l_com_operation_rec.Transaction_Type = BOM_Rtg_Globals.G_OPR_UPDATE
2426: OR ( l_com_operation_rec.Transaction_Type = BOM_Rtg_Globals.G_OPR_CREATE
2427: AND l_com_operation_rec.acd_type = l_ACD_CHANGE )

Line 2429: AND ( NVL(p_old_com_op_unexp_rec.standard_operation_id, FND_API.G_MISS_NUM ) <>

2425: IF ( l_com_operation_rec.Transaction_Type = BOM_Rtg_Globals.G_OPR_UPDATE
2426: OR ( l_com_operation_rec.Transaction_Type = BOM_Rtg_Globals.G_OPR_CREATE
2427: AND l_com_operation_rec.acd_type = l_ACD_CHANGE )
2428: )
2429: AND ( NVL(p_old_com_op_unexp_rec.standard_operation_id, FND_API.G_MISS_NUM ) <>
2430: NVL(l_com_op_unexp_rec.standard_operation_id, FND_API.G_MISS_NUM )
2431: )
2432: THEN
2433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 2430: NVL(l_com_op_unexp_rec.standard_operation_id, FND_API.G_MISS_NUM )

2426: OR ( l_com_operation_rec.Transaction_Type = BOM_Rtg_Globals.G_OPR_CREATE
2427: AND l_com_operation_rec.acd_type = l_ACD_CHANGE )
2428: )
2429: AND ( NVL(p_old_com_op_unexp_rec.standard_operation_id, FND_API.G_MISS_NUM ) <>
2430: NVL(l_com_op_unexp_rec.standard_operation_id, FND_API.G_MISS_NUM )
2431: )
2432: THEN
2433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2434: THEN

Line 2561: -- Standard Operation has changed to not null value

2557:
2558: END IF ;
2559:
2560: --
2561: -- Standard Operation has changed to not null value
2562: --
2563: IF ( NVL(l_com_operation_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
2564: OR l_com_operation_rec.acd_type = l_ACD_CHANGE)
2565: AND (( NVL(p_old_com_op_unexp_rec.standard_operation_id, -1) <>

Line 2565: AND (( NVL(p_old_com_op_unexp_rec.standard_operation_id, -1) <>

2561: -- Standard Operation has changed to not null value
2562: --
2563: IF ( NVL(l_com_operation_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
2564: OR l_com_operation_rec.acd_type = l_ACD_CHANGE)
2565: AND (( NVL(p_old_com_op_unexp_rec.standard_operation_id, -1) <>
2566: NVL(l_com_op_unexp_rec.standard_operation_id, -1)
2567: AND(p_old_com_op_unexp_rec.standard_operation_id <> FND_API.G_MISS_NUM
2568: OR p_old_com_op_unexp_rec.standard_operation_id IS NULL)
2569: ) OR

Line 2566: NVL(l_com_op_unexp_rec.standard_operation_id, -1)

2562: --
2563: IF ( NVL(l_com_operation_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
2564: OR l_com_operation_rec.acd_type = l_ACD_CHANGE)
2565: AND (( NVL(p_old_com_op_unexp_rec.standard_operation_id, -1) <>
2566: NVL(l_com_op_unexp_rec.standard_operation_id, -1)
2567: AND(p_old_com_op_unexp_rec.standard_operation_id <> FND_API.G_MISS_NUM
2568: OR p_old_com_op_unexp_rec.standard_operation_id IS NULL)
2569: ) OR
2570: ( p_old_com_op_unexp_rec.standard_operation_id = FND_API.G_MISS_NUM

Line 2567: AND(p_old_com_op_unexp_rec.standard_operation_id <> FND_API.G_MISS_NUM

2563: IF ( NVL(l_com_operation_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
2564: OR l_com_operation_rec.acd_type = l_ACD_CHANGE)
2565: AND (( NVL(p_old_com_op_unexp_rec.standard_operation_id, -1) <>
2566: NVL(l_com_op_unexp_rec.standard_operation_id, -1)
2567: AND(p_old_com_op_unexp_rec.standard_operation_id <> FND_API.G_MISS_NUM
2568: OR p_old_com_op_unexp_rec.standard_operation_id IS NULL)
2569: ) OR
2570: ( p_old_com_op_unexp_rec.standard_operation_id = FND_API.G_MISS_NUM
2571: AND ( l_com_op_unexp_rec.standard_operation_id IS NOT NULL

Line 2568: OR p_old_com_op_unexp_rec.standard_operation_id IS NULL)

2564: OR l_com_operation_rec.acd_type = l_ACD_CHANGE)
2565: AND (( NVL(p_old_com_op_unexp_rec.standard_operation_id, -1) <>
2566: NVL(l_com_op_unexp_rec.standard_operation_id, -1)
2567: AND(p_old_com_op_unexp_rec.standard_operation_id <> FND_API.G_MISS_NUM
2568: OR p_old_com_op_unexp_rec.standard_operation_id IS NULL)
2569: ) OR
2570: ( p_old_com_op_unexp_rec.standard_operation_id = FND_API.G_MISS_NUM
2571: AND ( l_com_op_unexp_rec.standard_operation_id IS NOT NULL
2572: AND l_com_op_unexp_rec.standard_operation_id <> FND_API.G_MISS_NUM )

Line 2570: ( p_old_com_op_unexp_rec.standard_operation_id = FND_API.G_MISS_NUM

2566: NVL(l_com_op_unexp_rec.standard_operation_id, -1)
2567: AND(p_old_com_op_unexp_rec.standard_operation_id <> FND_API.G_MISS_NUM
2568: OR p_old_com_op_unexp_rec.standard_operation_id IS NULL)
2569: ) OR
2570: ( p_old_com_op_unexp_rec.standard_operation_id = FND_API.G_MISS_NUM
2571: AND ( l_com_op_unexp_rec.standard_operation_id IS NOT NULL
2572: AND l_com_op_unexp_rec.standard_operation_id <> FND_API.G_MISS_NUM )
2573: ))
2574: THEN

Line 2571: AND ( l_com_op_unexp_rec.standard_operation_id IS NOT NULL

2567: AND(p_old_com_op_unexp_rec.standard_operation_id <> FND_API.G_MISS_NUM
2568: OR p_old_com_op_unexp_rec.standard_operation_id IS NULL)
2569: ) OR
2570: ( p_old_com_op_unexp_rec.standard_operation_id = FND_API.G_MISS_NUM
2571: AND ( l_com_op_unexp_rec.standard_operation_id IS NOT NULL
2572: AND l_com_op_unexp_rec.standard_operation_id <> FND_API.G_MISS_NUM )
2573: ))
2574: THEN
2575:

Line 2572: AND l_com_op_unexp_rec.standard_operation_id <> FND_API.G_MISS_NUM )

2568: OR p_old_com_op_unexp_rec.standard_operation_id IS NULL)
2569: ) OR
2570: ( p_old_com_op_unexp_rec.standard_operation_id = FND_API.G_MISS_NUM
2571: AND ( l_com_op_unexp_rec.standard_operation_id IS NOT NULL
2572: AND l_com_op_unexp_rec.standard_operation_id <> FND_API.G_MISS_NUM )
2573: ))
2574: THEN
2575:
2576: --

Line 2624: -- Get Standard Operatin Information

2620: THEN
2621: --l_std_op_found := FALSE ;
2622:
2623: --
2624: -- Get Standard Operatin Information
2625: --
2626:
2627: FOR l_stdop_rec IN l_stdop_csr
2628: ( p_std_op_id => l_com_op_unexp_rec.standard_operation_id

Line 2628: ( p_std_op_id => l_com_op_unexp_rec.standard_operation_id

2624: -- Get Standard Operatin Information
2625: --
2626:
2627: FOR l_stdop_rec IN l_stdop_csr
2628: ( p_std_op_id => l_com_op_unexp_rec.standard_operation_id
2629: , p_op_type => l_com_operation_rec.operation_type
2630: , p_rtg_seq_id => l_com_op_unexp_rec.routing_sequence_id
2631: , p_org_id => l_com_op_unexp_rec.organization_id
2632: , p_dept_id => l_com_op_unexp_rec.department_id

Line 2637: -- invalid standard op code

2633: , p_rit_seq_id => l_com_op_unexp_rec.revised_item_sequence_id
2634: )
2635: LOOP
2636:
2637: -- invalid standard op code
2638: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2639: THEN
2640: Error_Handler.Add_Error_Token
2641: ( p_message_name => 'BOM_OP_STD_OP_INVALID'

Line 2655: END LOOP ; -- copy standard operation

2651: ('Std operation is invalid. Return Status is '|| l_return_status ) ;
2652: END IF ;
2653:
2654:
2655: END LOOP ; -- copy standard operation
2656: FOR l_std_sub_res_rec IN c_std_sub_res (p_std_op_id => l_com_op_unexp_rec.standard_operation_id)
2657: LOOP
2658: -- The standard operation contains alternate resources
2659: -- We need to warn the user to change the schedule sequence number which will be defaulted to 0

Line 2656: FOR l_std_sub_res_rec IN c_std_sub_res (p_std_op_id => l_com_op_unexp_rec.standard_operation_id)

2652: END IF ;
2653:
2654:
2655: END LOOP ; -- copy standard operation
2656: FOR l_std_sub_res_rec IN c_std_sub_res (p_std_op_id => l_com_op_unexp_rec.standard_operation_id)
2657: LOOP
2658: -- The standard operation contains alternate resources
2659: -- We need to warn the user to change the schedule sequence number which will be defaulted to 0
2660: -- We will also unreference this standard operation as the user still has to enter the SSN

Line 2658: -- The standard operation contains alternate resources

2654:
2655: END LOOP ; -- copy standard operation
2656: FOR l_std_sub_res_rec IN c_std_sub_res (p_std_op_id => l_com_op_unexp_rec.standard_operation_id)
2657: LOOP
2658: -- The standard operation contains alternate resources
2659: -- We need to warn the user to change the schedule sequence number which will be defaulted to 0
2660: -- We will also unreference this standard operation as the user still has to enter the SSN
2661: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2662: THEN

Line 2660: -- We will also unreference this standard operation as the user still has to enter the SSN

2656: FOR l_std_sub_res_rec IN c_std_sub_res (p_std_op_id => l_com_op_unexp_rec.standard_operation_id)
2657: LOOP
2658: -- The standard operation contains alternate resources
2659: -- We need to warn the user to change the schedule sequence number which will be defaulted to 0
2660: -- We will also unreference this standard operation as the user still has to enter the SSN
2661: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2662: THEN
2663: Error_Handler.Add_Error_Token
2664: ( p_message_name => 'BOM_SSN_ZERO_VALUE'

Line 2682: ('Check Reference Standard Operation was processed. . . ' || l_return_status);

2678: END IF ;
2679:
2680:
2681: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
2682: ('Check Reference Standard Operation was processed. . . ' || l_return_status);
2683: END IF ;
2684:
2685: --
2686: -- Return Common Operation Record

Line 3548: -- If Standard Operation Id is not null, Department Id is not updatable

3544: END IF ;
3545:
3546:
3547: --
3548: -- If Standard Operation Id is not null, Department Id is not updatable
3549: --
3550: -- For eAM enhancenment, added Eam Item condidtions for this validation.
3551: -- Also in maintenace routing, we allow eam users to update the dept code
3552: -- if the dept resources that have been assigned to the current operation

Line 3556: AND (l_com_op_unexp_rec.standard_operation_id IS NOT NULL

3552: -- if the dept resources that have been assigned to the current operation
3553: -- should also exist in the dept to which the user changes.
3554:
3555: IF p_old_com_op_unexp_rec.department_id <> l_com_op_unexp_rec.department_id
3556: AND (l_com_op_unexp_rec.standard_operation_id IS NOT NULL
3557: OR Check_ResExists
3558: ( p_op_seq_id => l_com_op_unexp_rec.operation_sequence_id
3559: , p_old_op_seq_id => l_com_op_unexp_rec.old_operation_sequence_id
3560: , p_acd_type => l_com_operation_rec.acd_type

Line 3646: -- If standard operation id is null, It is unable to reference

3642: END IF ;
3643:
3644: --
3645: -- Reference Flag Validation.
3646: -- If standard operation id is null, It is unable to reference
3647: -- missing stanadrd op. So, It must be 2: No.
3648: --
3649: IF ( NVL(l_com_operation_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
3650: OR l_com_operation_rec.acd_type = l_ACD_CHANGE)

Line 3651: AND l_com_op_unexp_rec.standard_operation_id IS NULL

3647: -- missing stanadrd op. So, It must be 2: No.
3648: --
3649: IF ( NVL(l_com_operation_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
3650: OR l_com_operation_rec.acd_type = l_ACD_CHANGE)
3651: AND l_com_op_unexp_rec.standard_operation_id IS NULL
3652: AND l_com_operation_rec.reference_flag <> 2 -- 2:No
3653: THEN
3654:
3655: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 3672: -- Validate Standard Operation and Reference flag

3668: END IF ;
3669:
3670: END IF ;
3671:
3672: -- Validate Standard Operation and Reference flag
3673: -- If Standard Operation has changed to not null value
3674: -- If OK, Copy Std Operation and Std Resource
3675: -- Info regarding with Reference Flag.
3676: --

Line 3673: -- If Standard Operation has changed to not null value

3669:
3670: END IF ;
3671:
3672: -- Validate Standard Operation and Reference flag
3673: -- If Standard Operation has changed to not null value
3674: -- If OK, Copy Std Operation and Std Resource
3675: -- Info regarding with Reference Flag.
3676: --
3677: Check_Ref_Std_Operation

Line 3785: -- If Rev Item or Assem Item's BOM Item Type is Standard,

3781: END IF ;
3782:
3783: --
3784: -- Option Dependent Flag Validation.
3785: -- If Rev Item or Assem Item's BOM Item Type is Standard,
3786: -- Operation Dependent Flag must be 2: No.
3787: --
3788:
3789: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN

Line 3795: AND l_bom_item_type = l_STANDARD -- 4:Standard

3791: END IF ;
3792:
3793: IF ( NVL(l_com_operation_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
3794: OR l_com_operation_rec.acd_type = l_ACD_CHANGE)
3795: AND l_bom_item_type = l_STANDARD -- 4:Standard
3796: AND l_com_operation_rec.option_dependent_flag <> 2 -- 2:No
3797: THEN
3798:
3799: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)