13: -- Check if any category creations have been recorded (there might have
14: -- been only creations of items that are not product family items).
15: -----------------------------------------------------------------------
16:
17: IF ( BOM_PFI_PVT.G_Cat_Create_Num > 0 ) THEN
18: FND_MESSAGE.CLEAR;
19:
20: ---------------------------------------------------------------------
21: -- Perform each category creation that has been recorded by the call
21: -- Perform each category creation that has been recorded by the call
22: -- to Store_Cat_Create procedure in the row-level trigger.
23: ---------------------------------------------------------------------
24:
25: BOM_PFI_PVT.Create_PF_Category
26: ( p_return_sts => l_return_sts ,
27: p_return_err => l_return_err ,
28: p_Cat_Create_Num => BOM_PFI_PVT.G_Cat_Create_Num ,
29: p_Create_Cat_Tbl => BOM_PFI_PVT.G_Create_Cat_Tbl
24:
25: BOM_PFI_PVT.Create_PF_Category
26: ( p_return_sts => l_return_sts ,
27: p_return_err => l_return_err ,
28: p_Cat_Create_Num => BOM_PFI_PVT.G_Cat_Create_Num ,
29: p_Create_Cat_Tbl => BOM_PFI_PVT.G_Create_Cat_Tbl
30: );
31: END IF;
32:
25: BOM_PFI_PVT.Create_PF_Category
26: ( p_return_sts => l_return_sts ,
27: p_return_err => l_return_err ,
28: p_Cat_Create_Num => BOM_PFI_PVT.G_Cat_Create_Num ,
29: p_Create_Cat_Tbl => BOM_PFI_PVT.G_Create_Cat_Tbl
30: );
31: END IF;
32:
33: ---------------------------------------------------------------------
34: -- Check if any item assignments of product family items to their own
35: -- categories have been recorded.
36: ---------------------------------------------------------------------
37:
38: IF ( BOM_PFI_PVT.G_Assign_Num > 0 ) THEN
39: FND_MESSAGE.CLEAR;
40:
41: BOM_PFI_PVT.Assign_To_Category
42: ( p_return_sts => l_return_sts ,
37:
38: IF ( BOM_PFI_PVT.G_Assign_Num > 0 ) THEN
39: FND_MESSAGE.CLEAR;
40:
41: BOM_PFI_PVT.Assign_To_Category
42: ( p_return_sts => l_return_sts ,
43: p_return_err => l_return_err ,
44: p_Assign_Num => BOM_PFI_PVT.G_Assign_Num ,
45: p_Cat_Assign_Tbl => BOM_PFI_PVT.G_Cat_Assign_Tbl
40:
41: BOM_PFI_PVT.Assign_To_Category
42: ( p_return_sts => l_return_sts ,
43: p_return_err => l_return_err ,
44: p_Assign_Num => BOM_PFI_PVT.G_Assign_Num ,
45: p_Cat_Assign_Tbl => BOM_PFI_PVT.G_Cat_Assign_Tbl
46: );
47: END IF;
48:
41: BOM_PFI_PVT.Assign_To_Category
42: ( p_return_sts => l_return_sts ,
43: p_return_err => l_return_err ,
44: p_Assign_Num => BOM_PFI_PVT.G_Assign_Num ,
45: p_Cat_Assign_Tbl => BOM_PFI_PVT.G_Cat_Assign_Tbl
46: );
47: END IF;
48:
49: