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_COMPONENT dependencies on STANDARD

Line 44: l_STANDARD CONSTANT NUMBER := 4;

40: /*
41: l_MODEL CONSTANT NUMBER := 1;
42: l_OPTION_CLASS CONSTANT NUMBER := 2;
43: l_PLANNING CONSTANT NUMBER := 3;
44: l_STANDARD CONSTANT NUMBER := 4;
45: l_PRODUCT_FAMILY CONSTANT NUMBER := 5;
46: */
47: l_Sub_Locator_Control NUMBER;
48: l_locator_control NUMBER;

Line 589: l_Token_Tbl(2).Token_Value := 'BOM_STANDARD';

585: THEN
586: l_Token_Tbl(2).Token_Value := 'BOM_PLANNING';
587: ELSIF l_bom_comp_Item_Type = 4
588: THEN
589: l_Token_Tbl(2).Token_Value := 'BOM_STANDARD';
590: END IF;
591:
592: Error_Handler.Add_Error_Token
593: ( p_Message_Name => 'BOM_BOM_COMP_ACCESS_DENIED'

Line 867: *Standard Item No No No No No Yes No Yes

863: *ATO OC No Yes No Yes No Yes No Yes
864: *Planning Yes Yes Yes Yes Yes Yes Yes Yes
865: *ATO Item No No No No No Yes No Yes
866: *PTO Item No No No No No No Yes Yes
867: *Standard Item No No No No No Yes No Yes
868: *Config Item No Yes No Yes No Yes No Yes
869: *
870: **********************************************************************/
871: FUNCTION Verify_Item_Attributes

Line 910: -- 3. PTO Standard

906: -- Verify ATO MODEL OR ATO OPTION CLASS Assembly(not config)
907: -- Attributes ATO Model does not allow
908: -- 1. Planning Components
909: -- 2. PTO Model or PTO Option Class
910: -- 3. PTO Standard
911: -- If the Assembly is ATO Standard, then it does not allow the
912: -- above three types and
913: -- 4. ATO Model or
914: -- 5. ATO Option Class

Line 911: -- If the Assembly is ATO Standard, then it does not allow the

907: -- Attributes ATO Model does not allow
908: -- 1. Planning Components
909: -- 2. PTO Model or PTO Option Class
910: -- 3. PTO Standard
911: -- If the Assembly is ATO Standard, then it does not allow the
912: -- above three types and
913: -- 4. ATO Model or
914: -- 5. ATO Option Class
915: **************************************************************/

Line 917: (Bom_Globals.G_MODEL, Bom_Globals.G_OPTION_CLASS, Bom_Globals.G_STANDARD) AND

913: -- 4. ATO Model or
914: -- 5. ATO Option Class
915: **************************************************************/
916: IF ( ( ( g_Assy_Item_Type IN
917: (Bom_Globals.G_MODEL, Bom_Globals.G_OPTION_CLASS, Bom_Globals.G_STANDARD) AND
918: g_Assy_ATO_flag = 'Y' AND
919: g_Assy_Config = 'N'
920: )
921: ) AND

Line 924: (Bom_Globals.G_MODEL, Bom_Globals.G_OPTION_CLASS, Bom_Globals.G_STANDARD) AND

920: )
921: ) AND
922: ( g_Comp_Item_Type = Bom_Globals.G_PLANNING OR
923: ( g_Comp_Item_Type IN
924: (Bom_Globals.G_MODEL, Bom_Globals.G_OPTION_CLASS, Bom_Globals.G_STANDARD) AND
925: g_Comp_PTO_Flag = 'Y'
926: )
927: )
928: ) OR

Line 930: g_Assy_Item_Type = Bom_Globals.G_STANDARD AND

926: )
927: )
928: ) OR
929: (
930: g_Assy_Item_Type = Bom_Globals.G_STANDARD AND
931: g_Assy_ATO_flag = 'Y' AND
932: g_Assy_Config = 'N' AND
933: ( g_Comp_Item_Type IN (Bom_Globals.G_MODEL, Bom_Globals.G_OPTION_CLASS) AND
934: g_Comp_ATO_Flag = 'Y'

Line 952: 'BOM_STANDARD_TYPE';

948: g_Token_Tbl(2).Translate := TRUE;
949: ELSE
950: g_Token_Tbl(2).Token_Name := 'ITEM_TYPE';
951: g_Token_Tbl(2).Token_Value :=
952: 'BOM_STANDARD_TYPE';
953: g_Token_Tbl(2).Translate := TRUE;
954: END IF;
955: g_token_tbl(3).token_name := 'REVISED_ITEM_NAME';
956: g_token_tbl(3).token_value :=

Line 984: -- 1. ATO Standard or

980:
981: /*************************************************************
982: -- If the Assembly is a Config Item i.e. ATO with Base_Item_Id
983: -- NOT NULL then it will allow
984: -- 1. ATO Standard or
985: -- 2. Standard item
986: -- and
987: -- 1. ATO Model
988: -- 2. ATO Option Class

Line 985: -- 2. Standard item

981: /*************************************************************
982: -- If the Assembly is a Config Item i.e. ATO with Base_Item_Id
983: -- NOT NULL then it will allow
984: -- 1. ATO Standard or
985: -- 2. Standard item
986: -- and
987: -- 1. ATO Model
988: -- 2. ATO Option Class
989: -- only if the assemly is Phantom is Wip_Supply_Type is 6

Line 1025: (Bom_Globals.G_MODEL, Bom_Globals.G_OPTION_CLASS, Bom_Globals.G_STANDARD)

1021: ****************************************************/
1022: ELSIF
1023: NOT
1024: ( ( g_Comp_Item_Type IN
1025: (Bom_Globals.G_MODEL, Bom_Globals.G_OPTION_CLASS, Bom_Globals.G_STANDARD)
1026: AND
1027: g_Comp_ATO_Flag = 'Y'
1028: ) OR
1029: g_Comp_Item_Type = Bom_Globals.G_STANDARD

Line 1029: g_Comp_Item_Type = Bom_Globals.G_STANDARD

1025: (Bom_Globals.G_MODEL, Bom_Globals.G_OPTION_CLASS, Bom_Globals.G_STANDARD)
1026: AND
1027: g_Comp_ATO_Flag = 'Y'
1028: ) OR
1029: g_Comp_Item_Type = Bom_Globals.G_STANDARD
1030: )
1031: THEN
1032: g_token_tbl(2).token_name:= 'REVISED_ITEM_NAME';
1033: g_token_tbl(2).token_value :=

Line 1093: -- PTO STandard will only allow Standard or PTO Standard

1089: RETURN FALSE;
1090:
1091: /****************************************************
1092: --
1093: -- PTO STandard will only allow Standard or PTO Standard
1094: --
1095: *****************************************************/
1096: ELSIF g_Assy_Item_Type = Bom_Globals.G_STANDARD AND
1097: g_Assy_PTO_Flag = 'Y' AND

Line 1096: ELSIF g_Assy_Item_Type = Bom_Globals.G_STANDARD AND

1092: --
1093: -- PTO STandard will only allow Standard or PTO Standard
1094: --
1095: *****************************************************/
1096: ELSIF g_Assy_Item_Type = Bom_Globals.G_STANDARD AND
1097: g_Assy_PTO_Flag = 'Y' AND
1098: NOT
1099: ( g_Comp_Item_Type = Bom_Globals.G_STANDARD AND
1100: ( ( g_Comp_PTO_Flag = 'Y' AND

Line 1099: ( g_Comp_Item_Type = Bom_Globals.G_STANDARD AND

1095: *****************************************************/
1096: ELSIF g_Assy_Item_Type = Bom_Globals.G_STANDARD AND
1097: g_Assy_PTO_Flag = 'Y' AND
1098: NOT
1099: ( g_Comp_Item_Type = Bom_Globals.G_STANDARD AND
1100: ( ( g_Comp_PTO_Flag = 'Y' AND
1101: g_comp_ATO_Flag = 'N'
1102: ) OR
1103: ( g_comp_ATO_Flag = 'N' AND

Line 1113: NOT ( ( g_Comp_Item_Type = Bom_Globals.G_STANDARD AND

1109: )
1110: )
1111: )
1112: /* Commenting for Bug 2627352
1113: NOT ( ( g_Comp_Item_Type = Bom_Globals.G_STANDARD AND
1114: g_Comp_PTO_flag = 'Y'
1115: ) OR
1116: ( g_Comp_Item_Type = Bom_Globals.G_STANDARD)
1117: )

Line 1116: ( g_Comp_Item_Type = Bom_Globals.G_STANDARD)

1112: /* Commenting for Bug 2627352
1113: NOT ( ( g_Comp_Item_Type = Bom_Globals.G_STANDARD AND
1114: g_Comp_PTO_flag = 'Y'
1115: ) OR
1116: ( g_Comp_Item_Type = Bom_Globals.G_STANDARD)
1117: )
1118: */
1119: THEN
1120: g_token_tbl(2).token_name := 'REVISED_ITEM_NAME';

Line 1135: -- A STANDARD bill will only allow ATO Standard and Standard

1131: RETURN FALSE;
1132:
1133: /************************************************************
1134: --
1135: -- A STANDARD bill will only allow ATO Standard and Standard
1136: -- items as components
1137: --
1138: *************************************************************/
1139: ELSIF g_Assy_Item_Type = Bom_Globals.G_STANDARD AND

Line 1139: ELSIF g_Assy_Item_Type = Bom_Globals.G_STANDARD AND

1135: -- A STANDARD bill will only allow ATO Standard and Standard
1136: -- items as components
1137: --
1138: *************************************************************/
1139: ELSIF g_Assy_Item_Type = Bom_Globals.G_STANDARD AND
1140: g_Assy_PTO_Flag = 'N' AND
1141: g_Assy_ATO_Flag = 'N' AND
1142: NOT
1143: ( g_Comp_Item_Type = Bom_Globals.G_STANDARD AND

Line 1143: ( g_Comp_Item_Type = Bom_Globals.G_STANDARD AND

1139: ELSIF g_Assy_Item_Type = Bom_Globals.G_STANDARD AND
1140: g_Assy_PTO_Flag = 'N' AND
1141: g_Assy_ATO_Flag = 'N' AND
1142: NOT
1143: ( g_Comp_Item_Type = Bom_Globals.G_STANDARD AND
1144: ( ( g_Comp_ATO_Flag = 'Y' AND
1145: g_comp_PTO_Flag = 'N'
1146: ) OR
1147: ( g_comp_ATO_Flag = 'N' AND

Line 1157: ( p_message_name => 'BOM_STANDARD_PROP_MISMATCH'

1153: g_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
1154: g_token_tbl(2).token_value :=
1155: g_rev_component_rec.revised_item_name;
1156: Error_Handler.Add_Error_Token
1157: ( p_message_name => 'BOM_STANDARD_PROP_MISMATCH'
1158: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1159: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1160: , p_Token_Tbl => g_Token_Tbl
1161: );

Line 1221: * 1. Optional must be NO (2) if Bill if Pln or Standard

1217: * Returns : 0 if Success
1218: * 1 if Optional value is incorrect for ATO/PTO Model/OC
1219: * 2 if Optional value is incorrect for Plan/Stdd Bill
1220: * Purpose : Function will verify the following things:
1221: * 1. Optional must be NO (2) if Bill if Pln or Standard
1222: * 2. If Bill is PTO Model or OC and component is
1223: * ATO Std with no base mdl then Optional must be Yes
1224: * (1)
1225: ***********************************************************************/

Line 1243: g_Comp_Item_Type = Bom_Globals.G_STANDARD AND

1239: IF ( g_Assy_PTO_flag = 'Y' AND
1240: --following clause modified for BOM ER 9946990
1241: ( (g_Assy_Item_Type = Bom_Globals.G_MODEL and nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1) OR g_Assy_Item_Type = Bom_Globals.G_OPTION_CLASS) AND
1242: g_Comp_ATO_flag = 'Y' AND
1243: g_Comp_Item_Type = Bom_Globals.G_STANDARD AND
1244: g_Comp_Config = 'N' AND
1245: g_Rev_Component_Rec.optional = 2
1246: )
1247: THEN

Line 1249: ELSIF ( g_Assy_Item_Type IN (Bom_Globals.G_STANDARD, Bom_Globals.G_PLANNING) AND

1245: g_Rev_Component_Rec.optional = 2
1246: )
1247: THEN
1248: RETURN 1;
1249: ELSIF ( g_Assy_Item_Type IN (Bom_Globals.G_STANDARD, Bom_Globals.G_PLANNING) AND
1250: g_Rev_Component_Rec.optional = 1
1251: )
1252: THEN
1253: RETURN 2;

Line 1276: IF g_Assy_Item_Type = Bom_Globals.G_STANDARD THEN

1272: FUNCTION Check_Planning_Percent RETURN NUMBER
1273: IS
1274: BEGIN
1275: IF g_rev_component_rec.planning_percent <> 100 THEN
1276: IF g_Assy_Item_Type = Bom_Globals.G_STANDARD THEN
1277: RETURN 1;
1278: ELSIF ( g_Assy_Item_Type IN (Bom_Globals.G_MODEL, Bom_Globals.G_OPTION_CLASS)
1279: AND
1280: g_rev_component_rec.optional <> 1 AND

Line 2348: AND ( ( assy.bom_item_type IN ( Bom_Globals.G_PLANNING, Bom_Globals.G_STANDARD)

2344: g_rev_comp_Unexp_rec.revised_item_id
2345: AND comp.organization_id = g_rev_comp_Unexp_rec.organization_id
2346: AND comp.inventory_item_id =
2347: g_rev_comp_Unexp_rec.component_item_id
2348: AND ( ( assy.bom_item_type IN ( Bom_Globals.G_PLANNING, Bom_Globals.G_STANDARD)
2349: AND g_rev_component_rec.optional = 2 /* NO */
2350: )
2351: OR
2352: ( assy.bom_item_type IN ( Bom_Globals.G_MODEL, Bom_Globals.G_OPTION_CLASS)

Line 2355: AND comp.bom_item_type = Bom_Globals.G_STANDARD

2351: OR
2352: ( assy.bom_item_type IN ( Bom_Globals.G_MODEL, Bom_Globals.G_OPTION_CLASS)
2353: AND assy.pick_components_flag = 'Y'
2354: /* PTO Model or PTO Option Class */
2355: AND comp.bom_item_type = Bom_Globals.G_STANDARD
2356: AND comp.replenish_to_order_flag = 'Y'
2357: AND comp.base_item_id IS NULL
2358: AND g_rev_component_rec.Optional = 1
2359: )

Line 2363: -- Optional must be 2 if Bill is Planning or Standard.

2359: )
2360: );
2361:
2362: BEGIN
2363: -- Optional must be 2 if Bill is Planning or Standard.
2364: -- If the Bill is PTO Model or PTO OC and the Component
2365: -- is an ATO Std item with no Base Model then Optional must be 1
2366: -- Else it can be anything from 1 and 2.
2367:

Line 3347: g_Assy_Item_Type = Bom_Globals.G_STANDARD AND

3343:
3344: IF
3345: p_rev_component_rec.Transaction_Type IN (BOM_GLOBALS.G_OPR_UPDATE, BOM_Globals.G_OPR_DELETE) AND
3346: nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 AND
3347: g_Assy_Item_Type = Bom_Globals.G_STANDARD AND
3348: g_Assy_PTO_Flag = 'Y' AND
3349: g_comp_ATO_Flag = 'Y' AND
3350: g_comp_PTO_Flag = 'N' AND
3351: g_Comp_Item_Type = Bom_Globals.G_STANDARD

Line 3351: g_Comp_Item_Type = Bom_Globals.G_STANDARD

3347: g_Assy_Item_Type = Bom_Globals.G_STANDARD AND
3348: g_Assy_PTO_Flag = 'Y' AND
3349: g_comp_ATO_Flag = 'Y' AND
3350: g_comp_PTO_Flag = 'N' AND
3351: g_Comp_Item_Type = Bom_Globals.G_STANDARD
3352:
3353: THEN
3354:
3355: Error_Handler.Add_Error_Token

Line 3376: g_Comp_Item_Type = Bom_Globals.G_STANDARD AND

3372: g_Assy_Item_Type = Bom_Globals.G_MODEL AND
3373: g_Assy_PTO_Flag = 'Y' AND
3374: g_comp_ATO_Flag = 'Y' AND
3375: g_comp_PTO_Flag = 'N' AND
3376: g_Comp_Item_Type = Bom_Globals.G_STANDARD AND
3377: g_Rev_Component_Rec.optional = 2
3378:
3379: THEN
3380: Error_Handler.Add_Error_Token

Line 3403: g_Comp_Item_Type = Bom_Globals.G_STANDARD AND

3399: g_Assy_Item_Type = Bom_Globals.G_MODEL AND
3400: g_Assy_PTO_Flag = 'Y' AND
3401: g_comp_ATO_Flag = 'Y' AND
3402: g_comp_PTO_Flag = 'N' AND
3403: g_Comp_Item_Type = Bom_Globals.G_STANDARD AND
3404: nvl(g_Rev_Component_Rec.optional,1) = 2
3405:
3406: THEN
3407: Error_Handler.Add_Error_Token

Line 3615: -- standard items as components.

3611:
3612: l_return_status := FND_API.G_RET_STS_ERROR;
3613: END IF;
3614: -- Unit controlled revised items can only have non-ATO or non-PTO
3615: -- standard items as components.
3616: -- Added by AS on 07/08/99 as part of unit effectivity changes
3617:
3618: IF NVL(g_rev_component_rec.acd_type, 1) = 1 AND
3619: l_is_comp_unit_controlled AND

Line 7132: l_Token_Tbl(2).Token_Value := 'BOM_STANDARD';

7128: THEN
7129: l_Token_Tbl(2).Token_Value := 'BOM_PLANNING';
7130: ELSIF l_rev_comp_Item_Type = 4
7131: THEN
7132: l_Token_Tbl(2).Token_Value := 'BOM_STANDARD';
7133: END IF;
7134:
7135: Error_Handler.Add_Error_Token
7136: ( p_Message_Name => 'BOM_REV_COMP_ACCESS_DENIED'

Line 7871: * 1. Optional must be NO (2) if Bill if Pln or Standard

7867: * Returns : 0 if Success
7868: * 1 if Optional value is incorrect for ATO/PTO Model/OC
7869: * 2 if Optional value is incorrect for Plan/Stdd Bill
7870: * Purpose : Function will verify the following things:
7871: * 1. Optional must be NO (2) if Bill if Pln or Standard
7872: * 2. If Bill is PTO Model or OC and component is
7873: * ATO Std with no base mdl then Optional must be Yes
7874: * (1)
7875: * -1. Error

Line 7912: AND l_Comp_Item_Type = Bom_Globals.G_STANDARD

7908:
7909: IF ( l_Assy_PTO_flag = 'Y'
7910: AND l_Assy_Item_Type IN ( Bom_Globals.G_MODEL, Bom_Globals.G_OPTION_CLASS)
7911: AND l_Comp_ATO_flag = 'Y'
7912: AND l_Comp_Item_Type = Bom_Globals.G_STANDARD
7913: AND l_Comp_Config = 'N'
7914: )
7915: THEN
7916: RETURN 1;

Line 7917: ELSIF ( l_Assy_Item_Type IN (Bom_Globals.G_STANDARD, Bom_Globals.G_PLANNING) )

7913: AND l_Comp_Config = 'N'
7914: )
7915: THEN
7916: RETURN 1;
7917: ELSIF ( l_Assy_Item_Type IN (Bom_Globals.G_STANDARD, Bom_Globals.G_PLANNING) )
7918: THEN
7919: RETURN 2;
7920: ELSE
7921: RETURN 0;