DBA Data[Home] [Help]

APPS.BOM_VALIDATE_SUB_OP_RES dependencies on BOM_VALIDATE_OP_RES

Line 1489: -- Call BOM_Validate_Op_Res.Get_Rev_Op_ACD(p_op_seq_id to get parent revised

1485: --
1486: -- ACD Type,
1487: -- If the Transaction Type is CREATE and the ACD_Type of parent revised
1488: -- operation is Add then,the ACD_Type must be Add.
1489: -- Call BOM_Validate_Op_Res.Get_Rev_Op_ACD(p_op_seq_id to get parent revised
1490: -- operation's ACD Type
1491: --
1492: IF l_rev_sub_resource_rec.Transaction_Type = BOM_Rtg_Globals.G_OPR_CREATE
1493: THEN

Line 1496: BOM_Validate_Op_Res.Get_Rev_Op_ACD(p_op_seq_id

1492: IF l_rev_sub_resource_rec.Transaction_Type = BOM_Rtg_Globals.G_OPR_CREATE
1493: THEN
1494: IF
1495: l_ACD_ADD =
1496: BOM_Validate_Op_Res.Get_Rev_Op_ACD(p_op_seq_id
1497: => l_rev_sub_res_unexp_rec.operation_sequence_id)
1498: AND NVL(l_rev_sub_resource_rec.acd_type,l_ACD_ADD ) <> l_ACD_ADD
1499: THEN
1500: l_token_tbl(3).token_name := 'OP_SEQ_NUMBER';

Line 1651: -- Call BOM_Validate_Op_Res.Val_Resource_Id

1647:
1648: --
1649: -- Resource Id
1650: -- Check if valid resource id exists and belongs to depatment
1651: -- Call BOM_Validate_Op_Res.Val_Resource_Id
1652: --
1653:
1654: IF ( ( NVL(l_rev_sub_resource_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
1655: AND l_rev_sub_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE )

Line 1663: BOM_Validate_Op_Res.Val_Resource_Id

1659: THEN
1660:
1661:
1662: /* Call Val_Resource_Id */
1663: BOM_Validate_Op_Res.Val_Resource_Id
1664: ( p_resource_id => NVL(l_rev_sub_res_unexp_rec.new_resource_id,
1665: l_rev_sub_res_unexp_rec.resource_id )
1666: , p_op_seq_id => l_rev_sub_res_unexp_rec.operation_sequence_id
1667: , x_return_status => l_temp_status

Line 1816: -- BOM_Validate_Op_Res.Val_Activity_Id

1812:
1813: --
1814: -- Activity Id
1815: -- Check if Activity is enabled
1816: -- BOM_Validate_Op_Res.Val_Activity_Id
1817: --
1818: IF ( ( NVL(l_rev_sub_resource_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
1819: AND l_rev_sub_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE )
1820: OR NVL(l_rev_sub_res_unexp_rec.activity_id, FND_API.G_MISS_NUM)

Line 1833: BOM_Validate_Op_Res.Val_Activity_Id

1829: END IF ;
1830:
1831:
1832: /* Call Val_Activity_Id */
1833: BOM_Validate_Op_Res.Val_Activity_Id
1834: ( p_activity_id => l_rev_sub_res_unexp_rec.activity_id
1835: , p_op_seq_id => l_rev_sub_res_unexp_rec.operation_sequence_id
1836: , x_return_status => l_temp_status
1837: ) ;

Line 1866: -- BOM_Validate_Op_Res.Val_Activity_Id

1862:
1863: --
1864: -- Activity Id
1865: -- Check if Activity is enabled
1866: -- BOM_Validate_Op_Res.Val_Activity_Id
1867: --
1868: IF ( ( NVL(l_rev_sub_resource_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
1869: AND l_rev_sub_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE )
1870: OR NVL(l_rev_sub_res_unexp_rec.setup_Id , FND_API.G_MISS_NUM)

Line 1883: BOM_Validate_Op_Res.Val_Setup_Id

1879: END IF ;
1880:
1881:
1882: /* Call Val_Activity_Id */
1883: BOM_Validate_Op_Res.Val_Setup_Id
1884: ( p_setup_id => l_rev_sub_res_unexp_rec.setup_id
1885: , p_resource_id => NVL(l_rev_sub_res_unexp_rec.new_resource_id,
1886: l_rev_sub_res_unexp_rec.resource_id )
1887: , p_organization_id => l_rev_sub_res_unexp_rec.organization_id

Line 1930: -- Call BOM_Validate_Op_Res.Get_Resource_Uom

1926: -- same
1927: -- 2. Resource UOM class <> Hour UOM class
1928: -- 3. No conversion between resource UOM and Hour UOM
1929: --
1930: -- Call BOM_Validate_Op_Res.Get_Resource_Uom
1931: -- and BOM_Validate_Op_Res.Val_Res_UOM_For_Schedule
1932: --
1933: IF p_rev_sub_resource_rec.schedule_flag <> l_NO_SCHEDULE -- 2: No
1934: THEN

Line 1931: -- and BOM_Validate_Op_Res.Val_Res_UOM_For_Schedule

1927: -- 2. Resource UOM class <> Hour UOM class
1928: -- 3. No conversion between resource UOM and Hour UOM
1929: --
1930: -- Call BOM_Validate_Op_Res.Get_Resource_Uom
1931: -- and BOM_Validate_Op_Res.Val_Res_UOM_For_Schedule
1932: --
1933: IF p_rev_sub_resource_rec.schedule_flag <> l_NO_SCHEDULE -- 2: No
1934: THEN
1935:

Line 1942: BOM_Validate_Op_Res.Get_Resource_Uom

1938: l_res_uom_code IS NULL OR
1939: l_res_uom_class IS NULL
1940: )
1941: THEN
1942: BOM_Validate_Op_Res.Get_Resource_Uom
1943: ( p_resource_id
1944: => NVL(l_rev_sub_res_unexp_rec.new_resource_id,
1945: l_rev_sub_res_unexp_rec.resource_id)
1946: , x_hour_uom_code => l_hour_uom_code

Line 1953: BOM_Validate_Op_Res.Val_Res_UOM_For_Schedule

1949: , x_res_uom_class => l_res_uom_class ) ;
1950: END IF ;
1951:
1952: /* Call Val_Scheduled_Resource */
1953: BOM_Validate_Op_Res.Val_Res_UOM_For_Schedule
1954: ( p_hour_uom_class => l_hour_uom_class
1955: , p_res_uom_class => l_res_uom_class
1956: , p_hour_uom_code => l_hour_uom_code
1957: , p_res_uom_code => l_res_uom_code

Line 2071: -- Call BOM_Validate_Op_Res.Val_Dept_Has_Location

2067: --
2068: -- Autocharge Type
2069: -- Autocharge type cannot be PO Receipt if the
2070: -- department has no location.
2071: -- Call BOM_Validate_Op_Res.Val_Dept_Has_Location
2072: --
2073: IF ( ( NVL(l_rev_sub_resource_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
2074: AND l_rev_sub_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE )
2075: OR l_rev_sub_resource_rec.autocharge_type <> p_old_rev_sub_resource_rec.autocharge_type

Line 2081: BOM_Validate_Op_Res.Val_Dept_Has_Location

2077: AND l_rev_sub_resource_rec.autocharge_type = l_PO_RECEIPT
2078: THEN
2079:
2080: /* Call Val_Dept_Has_Location */
2081: BOM_Validate_Op_Res.Val_Dept_Has_Location
2082: ( p_op_seq_id => l_rev_sub_res_unexp_rec.operation_sequence_id
2083: , x_return_status => l_temp_status
2084: ) ;
2085:

Line 2113: -- Call BOM_Validate_Op_Res.Val_Autocharge_for_OSP_Res

2109: --
2110: -- Autocharge Type
2111: -- Autocharge Type cannot be PO Move or PO Receipt if the resource
2112: -- is non-OSP resource
2113: -- Call BOM_Validate_Op_Res.Val_Autocharge_for_OSP_Res
2114: --
2115: IF ( ( NVL(l_rev_sub_resource_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
2116: AND l_rev_sub_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE )
2117: OR l_rev_sub_resource_rec.autocharge_type <> p_old_rev_sub_resource_rec.autocharge_type

Line 2123: BOM_Validate_Op_Res.Val_Autocharge_for_OSP_Res

2119: AND l_rev_sub_resource_rec.autocharge_type IN (l_PO_RECEIPT, l_PO_MOVE )
2120: THEN
2121:
2122: /* Call Val_Autocharge_for_OSP_Res */
2123: BOM_Validate_Op_Res.Val_Autocharge_for_OSP_Res
2124: ( p_resource_id => NVL(l_rev_sub_res_unexp_rec.new_resource_id,
2125: l_rev_sub_res_unexp_rec.resource_id)
2126: , p_organization_id => l_rev_sub_res_unexp_rec.organization_id
2127: , x_return_status => l_temp_status

Line 2203: -- Call BOM_Validate_Op_Res.Val_Usage_Rate_or_Amount

2199:
2200: --
2201: -- Usage Rate or Amount
2202: -- Check round values for Usage Rate or Amount and the Inverse.
2203: -- Call BOM_Validate_Op_Res.Val_Usage_Rate_or_Amount
2204: --
2205: IF ( ( NVL(l_rev_sub_resource_rec.acd_type,l_ACD_ADD) = l_ACD_ADD
2206: AND l_rev_sub_resource_rec.transaction_type = BOM_Rtg_Globals.G_OPR_CREATE )
2207: OR l_rev_sub_resource_rec.usage_rate_or_amount

Line 2215: BOM_Validate_Op_Res.Val_Usage_Rate_or_Amount

2211: )
2212: THEN
2213:
2214: /* Call Val_Usage_Rate_or_Amount */
2215: BOM_Validate_Op_Res.Val_Usage_Rate_or_Amount
2216: ( p_usage_rate_or_amount => l_rev_sub_resource_rec.usage_rate_or_amount
2217: , p_usage_rate_or_amount_inverse => l_rev_sub_resource_rec.usage_rate_or_amount_inverse
2218: , x_return_status => l_temp_status
2219: ) ;

Line 2271: BOM_Validate_Op_Res.Get_Resource_Uom

2267: l_res_uom_code IS NULL OR
2268: l_res_uom_class IS NULL
2269: )
2270: THEN
2271: BOM_Validate_Op_Res.Get_Resource_Uom
2272: ( p_resource_id => NVL(l_rev_sub_res_unexp_rec.new_resource_id,
2273: l_rev_sub_res_unexp_rec.resource_id)
2274: , x_hour_uom_code => l_hour_uom_code
2275: , x_hour_uom_class => l_hour_uom_class

Line 2282: BOM_Validate_Op_Res.Val_Negative_Usage_Rate

2278: END IF ;
2279:
2280:
2281: /* Call Val_Negative_Usage_Rate */
2282: BOM_Validate_Op_Res.Val_Negative_Usage_Rate
2283: ( p_autocharge_type => l_rev_sub_resource_rec.autocharge_type
2284: , p_schedule_flag => l_rev_sub_resource_rec.schedule_flag
2285: , p_hour_uom_class => l_hour_uom_class
2286: , p_res_uom_class => l_res_uom_class